This site might have it:
Don’t let the site name throw you - lots of financial calculators there.
Never understood the fascination with balloons. Keep the balloons and just give me the money.
Okay, maybe a bottle of scotch and the money.
2016 Excel has mortgage templates. Just pulled up two of them by searching for “mortgage” in the Template section. The second template I tried had an amortization schedule attached.
=pmt(rate, numberPayments, loanAmount, balloon)
Sign of loanAmount and pmt are opposite. Negative numbers appear in red.
or start a table for irregular payments:
In A1 enter text “Date”
In B1 enter text “balance”
in C1 enter text “payment”
in A2 enter the origination date
in B2 enter the loan amount
in C2 enter 0.
In A3 enter the date of the subsequent payment.
In B3 enter =B2*(1 + ratePercent/1200) - C3
where ratePercent in the interest rate in percent, 1200 converts from annual interest rate in percent to monthly period, as a decimal fraction. For instance, 6% annual rate, monthly is 6/1200 = 0.005 For different rates and periods, adjust as required.
In C3 enter the actual payment amount.
Repeat the entries in row 3 until the balance vanishes. Try it for the constant interest, equal payment case, the table should closely match (within a penny) the pmt calculation result.
Good luck!
try any mortgage website. they usually have a calculator.
Bookmark.