please help by providing formulas for the red cell, the information comes from both the top and question 4 itself, thank you!

Calculate the estimated stock value under the assumptions given for each problem. Use the formulas from the text. Do not round any calculations. All results should be positive numbers Part B. Quarterly Dividends 7.2% 2.10 Required Rate of Retum (APR) Most recent quarterly dividend Compounding periods per year (m) Periodic RRR 1.8% uth 3 Calculate the Estimated Stock price Under the Non-growth assumption Assume dividends are paid quarterly D1 dividend Estimated Price 2.10 116.67 4 Calculate the Estimated Stock price under the Constant-growth assumption. Assume dividends are paid quarterly 1- ly Assume the (APR) constant growth rate (9) is Periodic growth rate (9) 2.8% 0.7% % D1 dividend Estimated Price 2.11 2.17 If the growth rate (g) were higher the value of the stock would be: higher 03