Calculate the payment for the companys stock.

ANSWER MUST BE IN EXCEL FORMULA FORMAT

Staal Corporation will pay a $3.40 per share dividend next year. The company pledges to increase its dividend by 4.5 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? $ Dividend next year Dividend growth rate Required return 3.40 4.50% 11% Complete the following analysis. Do not hard code values in your calculations. Price