MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Monthly / Annual growth

Posted by IML on January 15, 2002 10:53 AM

Lets say you have an annual growth rate in cell A1 of 5%
I want to end up with the value of $100 to be $105 in 12 months, but show it by month.
A4:L4 are names of the month
A5 is a value $100
B5:L5 are a formula to show the monthly growth
I tried
=A5*(1+$A$1/12) in B5 and copied it over but got a december value of $104.68, not $105.

dividing by 11 get 105.12

I think I needed to pay attention to exponents in math class for some reason, but can't remeber.

Here are the results with the the formula shown

Thanks in advance.

Posted by Barrie Davidson on January 15, 2002 11:06 AM

Ian, change your formula to read:


BarrieBarrie Davidson

Posted by IML on January 15, 2002 11:14 AM

Perfect, almost..