1. Company Valuation Your manager has asked you to value Ted Enterprises, a potential acquisition. To make your life easier, your manager gave you some of the numbers in the Excel template file provided. Note that your manager wants the dollar price per share, so you must calculate the dollar value of the equity and then divide by the number of shares outstanding. Please show excel equations used

A B E M 1 Ted Enterprises Yrs. 1-6 15% 7 + 4.0% Cash Flows 3 5 2 3 Sales growth 4 Costs (% of sales): 5 Cost of Goods Sold 6 Advert., Prom., & Selling 7 General & Administrative 8 Rates: 153.2 44% 38% 5% Sales Cost of Goods Sold Advert., Prom., & Selling General & Administrative Net Income before Tax Taxes 9 Tax rate 10 Discount rate 21% 14% 1.6 2.0 Net Income after Tax Cash flow adjustments: Working Capital Capital Expenditures Net Cash Flows NCF (incl. terminal value) (3.1) (1.2) (3.7) (1.4) (4.8) (1.8) (6.2) (2.4) (8.0) (3.1) 11 Results 12 PV of NCF (incl. TV) 13 + Cash 14 - Debt 15 Total Equity (M$) 16 - # of shares outstanding (M) 17 - Price/share ($) 18 19 (2.1) (0.8) TV 19.2