How do I make this on excel ?

Build the following three VBA functions Divi 1. GGM (Gordon Growth Model, Inputs: Div1, R, g) Stock Value, Po = R-g 2. CATCHUP (Inputs: p1, p2, r1, r2) In(3) Years to catchup 1+1 In 1+12 3. PStdev (Portfolio Standard Deviation, Expandable) (Pin as inputs, an expandable model can have more than 5 rows as shown below) Economy (0) Recession PStdev(o) = $=( 1-1)2 XP Below Average fel Probability High Tech Return (P) ( THT) r.1x-27+.2-.07+.4x.15+2x.30+.IX.45 = 12.4% 10% -27% Por=0.124 20% -7% Car Porx R 40% 15% [(-0.27 - 0.124)*(0,1)+(-0.07 -0.124) (0.2) 20% 30% = +0.15-0.124) (0.4)+(0.30-0.124)*(0.2) High Tech +(0.45-0.124) (0.1) 10% 45% Oor = 0.040144 = 20.04% where f = -1 Pini Average Above Average Boom GGM Dividend one year from now (Divi) $ 2.00 R (cost of equity) 10% g (growth rate of dividends) 4% 5 5 Stock Value Today (PO) $ 33.33 C2/C3-C4) 7 Stock Value Today (PO) (Your Function) $ 33.33 EGGM(C2,C3,C4) 8 9 CATCHUP pl (sales of WMT) $ 514,405 10 p2 (sales of AMZN) $ 280,522 11 r1 (growth rate of WMT sales) 2.90% 12 12 (growth rate of AMZN sales) 20.45% 13 14 Years to Catchup 3.85 N(C10/09)/LN((1+11)/(1+C12}} 15 Years to catchup 3:35 CATCHUPC9,10,11,12) 16 17 Portfolio STDEV Probability Value 18 -27.00% 19 20% -7.00% 20 40% 15.00% 21 20% 30.00% 22 10% 45.00% 23 24 Expected Value (r hat) 12.40% -818*C18+819-C19+B20*20+B21*C21+B22"C22 25 Portfolio Standard Deviation (Calculation) 20.04% SQRT{(818*(C24-C18)^2)+(B19" (C24-C19)^2)+(B20"(C24-C20)^2)+(B21"(C24-C21)^2)+(822 26 Portfolio Standard Deviation (Your Function) 20.01% Pstdev(818:322,C18:22) 10%