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