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
=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.