Calculating Growth Rate

T

tedd13

Can anyone tell me how to calculate a growth rate. I am trying to find the
mothly growth rate over two years. The growth rate is 5% a year.
I am trying to enter a value in a cell and then the next 24 cells(for two
years) would be filled in with that value plus growth rate.
Thanks
 
J

JLGWhiz

=(.05/12)*(numbertogrow)+numbertogrow
put the formula in the second cell in your 24 cell sequence and drag/copy to
remaining cells. This formula does not compound, it only shows the amount of
increase per month. To compound:
= (.05/12)*(numbertogrow)+OFFSET(currentcell,0,-1,1,1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding required growth rate 0
Better Understanding of XIRR 4
S-Functions and modeling user growth 0
Growth Rate for number series 2
Compound Interest Rate or Growth Rate 2
Reduction in Growth 4
Macro Sensitivity analysis Update table 0
Calculating percentage growth rate from a cumulative figure 4

Top