90.2K

Verified Solution

Link Copied!

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 in excel with formulas.

MGMT332_Excel_Template_3 [Compatibility Mode] - Excel Jim Alvarado File Home Insert Page Layout Formulas Data Review View Help Power Pivot Tell me what you want to do & Share Times New Rom 12 AP A ab Wrap Text Percentage Accents Accento Comma Comma [0] AY * Cut e Copy *Format Painter Paste BIU. > A- Merge & Center - $ % till 08 Currency [0] Percent Conditional Format as Currency Formatting Table Insert Delete Format AutoSum - Fill- Sort & Find & Clear Filter - Select Editing Sensitivity Clipboard Font Alignment Number Styles Cells Sensitivity E20 X f A B D F G H I J K L M N O P Q R E Ted Enterprises 1 Yrs. 1-6 15% 7+ 4.0% Cash Flows 3 2 4 5 6 1 153.2 44% 38% 5% 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 ($) 18 Sales Cost of Goods Sold Advert., Prom., & Selling General & Administrative Net Income before Tax Taxes 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) (2.1) (0.8) TY 19.2 19 20 21 22

Answer & Explanation Solved by verified expert

See Answer