Remember to enter dates and rates in yellow cells only. The worksheet is protected, except for the yellow input cells, so you are not tempted to type over a formula. There is no password, so you can unprotect the sheet. Back in November of 2014 I posted “Amortization Schedule With Variable Rates“, and an Excel […]
Variable Rate Amortization – Day/Year Count & Last Payment Options
