I'm amortizing 40-year notes using PPMT to calculate the principal payment.
For each monthly payment I have to manually change PER in the formula to
update the schedule. Is there another way to do this? I'm using Excel 2003.