Calculate the numbers using excel formula in the green boxes Add account lables in beige boxes Put your final solution in the yellow boxes AC220-Unit 7 Problems Show your work in Excel. Students must also (Select Formulas - Financial tab in Excel for a QI. Top Performance Company has a this formula is frequently used for perferred stock. DiVi Q2. The dividend for the Will be Share. PO /(R-g) where paid g growth R 2Required return) This video might be helpful in understanding the Contstant Growth Mode! https;//www_irp.restopedia.com/termSid/ddm_a SP required n increase Constant Growth Model Q3. HOW much are you Willing to pay for one share Of Red (Hint: This amounts to a Constant growth, and the formula is os follows: Po Do x (I where D=Dividend paid, g =grpwth rate, R -Required return) Required I Constant Growth Model