I am trying to accumulate payments annually over 5 years, where monthly PMT and present value are known, rate is zero percent (so I cannot use cumulative principle, formula) and or periods are between 3 and 68 months. Any help would be appreciated.
Columns Are as follows
A = contract name
B = Number of Months (NPER) - BTW 3 months and 68 months
C= Contract Amount (PV)
D = Monthly Payment
E = payments year 1 (accumulative)
F = payments year 2 (accumulative)
G= payments year 3 (accumulative)
H= payments year 4 (accumulative)
I = payments year 5 (accumulative)
Columns Are as follows
A = contract name
B = Number of Months (NPER) - BTW 3 months and 68 months
C= Contract Amount (PV)
D = Monthly Payment
E = payments year 1 (accumulative)
F = payments year 2 (accumulative)
G= payments year 3 (accumulative)
H= payments year 4 (accumulative)
I = payments year 5 (accumulative)
