Company ValuationYour manager has asked you to value MCM Inc., a potential acquisition. To make your life easier, your manager gave you some of the numbers in the Excel template file provided. Your manager wants the dollar price per share, so you must calculate the dollar value of the equity and then divide it by the number of shares outstanding.

IMPORTANT: SHOW FORMULAS USED TO CALCULATE

B D F G H I K L E MCM Inc. 1 Yrs. 1-6 6% 7+ 3.0% Cash Flows 3 2 4 5 6 1 102.0 55% 20% 6% 20% 2 3 Sales growth 4 Costs % of sales): 5 Cost of Goods Sold 6 Advert., Prom., & Selling 7 General & Administrative 8 Rates: 9 Tax rate 10 Discount rate 11 Results 12 PV of NCF (incl. TV) 13 + Cash 14 - Debt 15 Total Equity (M$) 16 - # of shares outstanding (M) 17 Price/share ($) 8% Sales Cost of Goods Sold Advert., Prom., & Selling General & Administrative Net Income before Tax Taxes Net Income after Tax Cash flow adjustments: Working Capital Capital Expenditures Net Cash Flows (4.0) 3.0 6.0 (4.0) (3.2) (3.5) (3.3) (3.0) (3.4) (3.0) (4.0 (1.5) (2.0 (3.3 TV 22.0