Оцінка вартості компанії - завдання Excel

Доброго дня! 

Термінове завдання - необхідно виконати дві задачі.

1 - EM is expected to gain a $0.60 EPS next year, dividend payout ratio will be 40 percent. The dividend is expected to grow at a 30 percent annual rate for Years 2 and 3, at 15 percent annually for the next 5 years, and at constant percent annually after it . ROE for long term period of time is 5 percent. If the required rate of return is 10 percent, what is the value per share? 

2 - Provide valuation of Alcan Inc based on a two-stage FCFE valuation approach. Use the following assumptions:• Net income is currently $420 million. Net income will grow by 24 percent annually for the next three years.• The net investment in operating assets (capital expenditures less depreciation plus investment in working capital) will be $720 million next year and grow at 32 percent for the following two years.• 40 percent of the net investment in operating assets will be financed with net new debt financing.• Alcan’s beta is 1.1, the risk-free bond rate is 5,0 percent, and the equity risk premium is 4 percent.• After three years, the growth rate of net income will be 8 percent and the net investment in operating assets (capital expenditures minus depreciation plus increase in working capital) each year will drop to 25 percent of net income.• Debt is, and will continue to be, 40 percent of total assets.• Alcan has 430 million outstanding shares.Find the value per share of Alcan. 

Додаю рішення до подібної, але з іншими числами.

Прошу відгукнутись хто зможе зробити і почати зараз, до 19 : 30.

Дякую!