OK...I think I understand...You want to be able to calculate the sum of payments for any start/end period within the term.
Pmts 1 through 6
Pmts 7 through 18
etc.
If that's true, try this:
A1: Rate
A2: Initial Pmt
A3: CalcMth_Start
A4: CalcMth_End
A5: PeriodSum
B1: 0.15
B2: $115
B3: 7
B4: 18
This regular formula returns the sum of pmts for mths 7 through 18
In the above example, the formula returns: $7714.50
If you change the parameters to calc mths 1 through 6
the formula returns: $1006.68
Does that help?
Bookmarks