View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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?