Show your work in Excel using formulas for calculator computation provided in the learning map for Unit 7 as appropriate. Students could also use excel formulas given as a Hint. {Select Formulas Financial tab in Excel for a listing of formulas) Q1. Top Performance Company has a policy of paying a $9 per share divident every year. If this policy is to be continued indenitely, what is the value of a share of stock if the required return is 20 percent? f Hint: Please use ordinary perpetuity formula) Q2. The next dividend for the Dynamic Company will be $5 per share. Investors require a 14 percent return on companies such as Dynamic. Dynamic's divident increases by 6 perceni every year.Based on the dividend growth model, what is the value of Dynamic's stock today': Hint: Formula for dividend growth model is as follows: Po = D I/ ['Rg) Q3. How much are you willing to pay for one share of Red Snapper stock if the company just paid a $0.60 annual dividend. the dividends increase by 2.4 percent annually. and you require a 9 percent rate of return? (' Hint: This amounts to a Nonconstant growth. and the formula is as follows: Pa =D x {1 + gJ/{Rg) where D=Dividend paid, g =growth rate, R =Reauired return}