=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!
Thanks, I think.
I found a template that seems to work. You plug in the info and it calc, except when I arrow down it only moves the last line at the bottom, the table for the info stays put. Know how to ix that?