Feb 09 2022 04:51 AM
Hi,
I am having trouble on a piece of work I am completing using a Compound Annual Growth rate calulator.
In the attached excel I would like to be able to work our the following:-
1) Given that I have the end value (B10), and I have the exisitng providers end value (B12), I would like to calculate the CAGR required to make my fund value match the exisiting providers. I know the answer should be i.r.o 3.03% but need help to work it out.
2) I would like the cells G3 - P139 to be completed automatically given the inputs in column B are entered.
Many thanks in advance,
Rob
Feb 09 2022 06:15 AM
@Robert1290 Haven't really tried to come up with a formula that calculates the required growth rate, but your schedule has all the calculations in it. What's left is to use Goal Seek to get the desired ending value.
This results in a growth rate of 3,008214793%, to be precise. Wouldn't that work for you?
Feb 09 2022 10:08 AM
Feb 09 2022 10:29 AM