Amortized loan with balloon pmt expected

Tell Moneylender how to do calculations for you loans. Get the numbers to come out the way you want.
Post Reply
bobyon
Posts: 4
Joined: Sun Mar 10, 2024 4:28 am

Amortized loan with balloon pmt expected

Post by bobyon »

Hi Josh,

I'm attempting to set up a standard amortized loan. The loan is amortized for 180 monthly payments but is expected to be paid in full (i.e. balloon payment) at or before 5 years. I can't seem to find where to setup the loan duration that won't affect the amortization. What am I missing?

What I've done for now is created the loan payment as monthly with an occurrence count of 180. Then calculate the payment amount and then adjust the occurrence to 60. I expect there is a better way.

Please advise.

Thanks,
Bob
Post Reply