Get instant live expert help on I need help with compound annual growth rate formula

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Anyone know how to do that compound annual growth rate? I do know the formula but I am not sure I inputted the data correctly. Scroll to all they way to the right to look for worksheet "Case 3"
Solved by T. A. in 25 mins
I'm using the compound annual growth rate formula =(x-y)^(1/P)-1 and I am hoping to make P variable based on the first year that money is deposited. I have a chart where we could input data for each year, and it spits out the compound annual growth rate for each year. Currently the formula works if money is deposited in the first year. However I'd like to alter it such that if money isn't deposited until say, year 3, each value of P would decrease by 2.
Solved by Z. L. in 30 mins
I need the formula to see the compound growth of a number by 10% weekly
Solved by K. D. in 13 mins
how to calculate annual growth of 20%. using a simple formula
Solved by O. S. in 14 mins
I have a current population of 24million. The annual growth rate is 1.4%. I wish make a formula that will populate a table for x number of years. Preferably to 2050.
Solved by X. H. in 19 mins