Loan Amortization with Extra Principal Payments Using ...
At this point, we can simply enter any extra payments in column E and they will automatically be deducted from the loan balance. In my example, I am assuming that the extra payment is a constant $300 each month until the loan is paid off, and zero thereafter. So, the formula in E13 is: =IF(F12-D13>=$B$7,$B$7,F12-D13)
DA: 51 PA: 88 MOZ Rank: 25