please provide the formulas used for excel for these questions

1 Discount Model 2 Perpetual Growth Model 3 4 5 6 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline+ & & 2016 & & 2017 & i. & 2018 & & 2019 & 2020 & 2021 & Growth Rate \\ \hline Dividends & s & 3.30 & 5 & 3.70 & 3 & 4.25 & 5 & 5.00 & 5,50 & 5.90 & - \\ \hline Dividend Grewth & & & & 12.12 & & 14.86% & & 17.65N & 10.00N & 7.27% & 12.36x \\ \hline \end{tabular} 12.32 Geometric Average. 7 8 nequired Rate of fieturn 15.00% 9 10 Value of Sock using Perpetual Grewth Model with Geometric Averwe: Value of Stockushe Perpetual Growth Model with Arithmetic Averace. 12 13 14 Middual income Mode! 15 16 17 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & & \multirow{2}{*}{\multicolumn{2}{|c|}{2020}} & \multirow{2}{*}{\multicolumn{2}{|c|}{2021}} & \multirow[b]{2}{*}{ Crowth lute. } \\ \hline & & 2016 & & & & 201 & & 2019 & & & & & \\ \hline Carninge Per Sture & 5 & 14.37 & 5 & 14.94 & 5 & 15.59 & 5 & 15.58 & 5 & 15.80 & 5 & 15.90 & \\ \hline EPSGrowth & & & & 3.97K & & 4.356 & & 0.06% & & 1.41% & & 0.63 & 2.05K \\ \hline \end{tabular} 2.04 Geometric Average 18 19 20 ilequired Rateof Return. Iloak value per shyre 15.00% 521.28 21 22 Value of Stock using Residual Income Model with Geometric Averace: 23 Value of Stock using Residual Income Model with Arithmetic Average: 55 121.88 Arithmetic Average