I need to find a "baseline" rate of return calculation that finds the baseline rate of return, given annual deviations from the baseline rate and the CAGR for the entire duration. This could be either a formula or a VBA macro.

Here's an example.

CAGR 10%

Year# Beginning Amount Deviations
from baseline
rate of return
1 1000 5.00%
2 1100 -3.00%
3 1210 0.00%
4 1331 3.40%
5 1464.1 -2.20%
6 1610.51

Baseline rate of return (computed): 9.41%

Thanks,
SS