Excel formula to calculate a loan that considers fee & Cap.

[lsingh718]

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

[curiouscat408]

See the first response to your posting elsewhere (click here).