Hello,
*
I was hoping you can help me figure out an excel formula to calculate a loan amount that considers a fee and a cap.* For the example below, a borrower requests $65K, they only have room in their budget to receive 30K for the year, they are charged an origination fee of 4.228% for the loan which gets added to their budget (total amount they can receive for that year).* I'm trying to figure out a formula that calculates the maximum loan amount that they can receive in that first year without going over the budget (Cell B2 +B4), the remaining loan amount gets transferred to the following year.
Screen Shot 2022-08-08 at 10.43.01 AM.png
Bookmarks