Loan Amortization Schedule with a Variable Interest Rate in Excel Free Download
The table below shows that at the end of 120 periods, our loan is repaid. The minus sign in front of PMT is necessary as the formula returns a negative number. The first three arguments are the rate of the loan, the length of the loan (number of periods), and the principal borrowed. The “Interest” […]
Loan Amortization Schedule with a Variable Interest Rate in Excel Free Download Read More »