formula to calculate sum of payment increased by 3% annually
Hi,
=SUM(B8*12*1.03^{0,1,2,3,4})
where B8 contains the initial payment size.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"JSC" wrote:
example: I'm paying $1000 a month today. The amount increases by 3% each
year. I pay for 5 years. How much am i paying in total? is there a formula
to calculate this?
|