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?-
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?-
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks