I need help with the formulas for the red boxes please.

please help with red boxes Problem 1 Annual Dividends Required Rate of Retur 9.2% Most recent annual Dividend S Analysis Period growth rate 5.0% van Horizon Panlod growth rate 28% bol year horizon ue 3 ***8222 Analysis Period Years 2 3 465 509 407 4.62 423 Didend PV of Div 5235 y perpetuit acht dividend being your calculation.co.29) PV of Analysis Period PV of Horizon Period Stock Value: $15.97 $60.41 $76.38 um hvort setas pened escourite you can call go back to to 37 m Problem 2 Quarterly Dividends Regare Rate of Return BBON Per RRR Most recent quan Diena 51 20 And whe Analysis Pardes with 2001 Horon Prowe Horcan Palio periodic growth 1100 A Piotr 19 12 13 14 19 ts 122 py of 520 PV Analysis Pert PV of Horan Pend have STR. 1 Problem 2: Quarterly Dividends A Required Rate of Return: Periodic RRR Most recent quarterly Dividend: Analysis Period APR growth rate: Analysis Period periodic growth rate: Horizon Period APR growth rate: Horizon Period periodic growth rate: 8.80% m: 4 2.20% $1.20 8.00% Years 1-4 2.00% 4.00% infinite... begins at year 5 1.00% horizon 2 1 1.22 1.22 Dividend: PV of Div 129 3 1.35 1.35 4 1.42 1.42 5 1.49 1.49 Analysis Period Quarters 7 8 9 1.64 1.72 1.81 1.64 1.72 1.81 6 1.56 1.56 10 1.90 1.90 11 1.99 1.99 12 209 2.09 13 2.20 2.20 14 2.31 2.31 15 2.42 2.42 16 2.54 2.54 214.17 151.20 1.29 5.28 PV of Analysis Period: PV of Horizon Period Stock Value: $28.96 $151.20 $180.15