Variable Rate Amortization – Day/Year Count & Last Payment Options

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 […]