Please provide answers in details and excell functions

Using Discounted Cash Flow (DCF) analysis, estimate the enterprise value AND implied equity value of American Greetings at the beginning of 2012.

Model the cash flows for fiscal years 2012 through 2015 based on the two scenarios presented in case If you made assumptions in addition to the ones presented in the case, please explain.

Explain your terminal value assumptions under both scenarios. What is your terminal value estimate under both scenarios?

What is the implied enterprise value of American Greetings and the corresponding share price?

	Actual	Forcasted
	2011	2012	2013	2014	2015
Bullish Scenario	5.3%	1.0%	1.5%	2.0%	2.5%
Revenuw Growth	9.4%	9.0%	9.0%	9.0%	9.0%
Operating Margin	5.02	6.00	6.50	7.00	7.50
Net Working Capital Turnove	1.95	1.95	1.95	1.95	1.95
Fixed Asse Turnover
Bearish Scenario
Revenuw Growth	5.3%	0.0%	0.0%	0.0%	0.0%
Operating Margin	9.4%	8.0%	7.0%	6.0%	5.0%
Net Working Capital Turnove	5.02	6.00	6.50	7.00	7.50
Fixed Asse Turnover	1.95	1.95	1.95	1.95	1.95

American Greetings
Income Statement, Dec 2011										Balance Sheet
Total Revenue	1,677							Cash/Cash Equivalent	172			Debth Due in one year	0
Costs	743							Acccount Receivable	130			Accounts Payable	87
SDMarketing Expenses	526							Inventories	190			Other Current Liabilities	255
General Expenses	258							Prepaid Expenses	131
Goowill/Intangable Aets	0							Other Current Asets	54
Operating Expenses	0											Current Liabilities	343
								Total Current Asets	677
Operating Income	157							Other Asets/Plants	859			Long-Term Debt	235
Net Int & Op Expenses	28											Othr Liabilities	206
EBIT	129											Sharholder's Equity	752
Income Tax Expense	47
								Total Asets	1,538			Total L&E	1,536
Net Income	82

What do you think is the intrinsic value of American Greetings shares? Do you recommend repurchasing the shares? Please explain.