he company's excess earnings are closest to:

Please show work in Excel.

7. In future periods, YZX Inc. is expected to maintain a dividend payout 40%, a net profit margin of 4.6%, a total asset turnover of 2.2, and an equity multiplier of 1.35. What is YZX's projected sustainable growth rate? 5.46% 8.20% 8.55% 9.00%

A company is projected to generate revenues of $336 million and $406 million over the next two years. After that, the company is assumed to enter its terminal phase with steady growth. Given the following information, how much is each share worth today? Answer in dollars rounded to one decimal place. Forecasted operating margin: 35.4%. Forecasted tax rate: 22.2%. Forecasted reinvestment rate: 30%. Forecasted steady growth rate of free cash flow: 1.3% per year. Cost of capital: 13.2%. Debt: $40 million. Cash: $35 million. Shares outstanding: 12 million.