What would be the VBA code for Geometric Mean for Growth Rates? Here in the excel worksheet is the 2 columns I am working with orginally Column B and Column C. these are the given periods and associated growth rates. The original amount of money invested is $100. Need a VBA code that creates a formula to solve for this Geometric mean growth rate. The answer to this code should be the highlighted cell containing -8.94%. I am not looking for the GEOMEAN formula in excel since you have to take the original growth rate and add 1 before using the GEOMEAN formula. I just need the code that will give me this answer without having to do that whole extra step.

AutoSave Book1 - Saved Search (Alt+Q) Kinsch, Grace Catherine KG 7 o X File Home Insert Draw Page Layout Formulas Data Review View Developer Help Power Pivot Share Comments E10 X fa =E9*D10 A B D E F G H 1 j K M N 2 nm 7 4 Name 6 7 8 9 Period 10 11 12 13 Rate 100 1 25% 125% 125 2 25% 125% 156.25 3 -60% 40% 62.5 4 10% 110% 68.75 91% -8.94% r=9% 100*(1+r)^4=68.75 14 15 16 17 18 19 20 21 22 23 Sheet1 | + Ready 160% D H i Type here to search o TH > 38F Partly sunny 4) 5:20 PM 12/7/2021 L