Please use Excel formulas to help me understand how to solve this questions in Excel.

Thank You!

4. Stock Values [ LO1] Five Star Corporation will pay a dividend of $3.04 per share next year. The company pledges to increase its dividend by 3.75 percent per year indefinitely. If you require a return of 11 percent on your investment, how much will you pay for the company's stock today? Input area: Dividend next year Dividend growth rate Required return Output area: 17. Nonconstant Dividends [ LO1] McCabe Corporation is expected to pay the following dividends over the next four years: $15,$11,$9, and $2.95. Afterward, the company pledges to maintain a constant 4 percent growth rate in dividends forever. If the required return on the stock is 10.3 percent, what is the current share price? Input area: Output area