If you know these three things, you can use Excel’s PMT function to ... How to Calculate Amortization with an Extra Payment Sometimes people want to pay down their loans faster to save money ...
Make extra principal payments ... A mortgage amortization schedule is calculated using the loan amount, loan term, and interest rate. If you know these three things, you can use Excel’s PMT ...