50.1K

Verified Solution

Link Copied!

please give correct answer, for discounted free cash flows and free cash flow multiple in multiple based valuation

Williams Company is a manufacturer of auto parts having the following financial statements for 2018-2019. 0.83 points Balance Sheet December 31 2019 Cash $ 273,000 Accounts receivable 163,000 Inventory 398,000 Total current assets $ 834,000 Long-lived assets 1,770,000 Total assets $2,604,000 Current liabilities 356,000 Long-term debt 900,000 Shareholders' equity 1,348,000 Total debt and equity $2,604,000 2018 $ 148,000 238,000 188,000 $ 574,000 1,630,000 $2,204,000 305,000 930,000 969,000 $2,204,000 Income Statement For the years ended December 31 2019 Sales $3,630,000 Cost of sales 2,760,000 Gross margin 870,000 Operating expenses* 513,000 Operating income 357,000 Taxes 142,800 Net income $ 214,200 2018 $3,730,000 2,860,000 870,000 307,000 563,000 197,050 $ 365,950 Cash Flow from Operations $ 2018 365,950 115,000 Net income Plus depreciation expense + Decrease (-increase) in accounts receivable and inventory + Increase (-decrease) in current liabilities Cash flow from operations 2019 $ 214,200 125,000 (135,000) 51,000 $ 255,200 $ 480,950 *Operating expenses include depreciation expense. Additional financial information, including industry averages for 2019, where appropriate, includes: Industry 2019 35.0% 2019 2018 $ 170,000 $ 230,000 40% 35% $ 125,000 $ 115,000 $ 37,000 $ 37,000 $ 3.55 $ 4 1,930,000 1,930,000 25.00 1.50 18.00 9.00 Capital expenditures Income tax rate Depreciation expense Dividends Year-end stock price Number of outstanding shares Sales multiplier Free cash flow multiplier Earnings multiplier Cost of capital Accounts receivable turnover Inventory turnover Current ratio Quick ratio Cash flow from operations ratio Free cash flow ratio Gross margin percentage Return on assets (net book value) Return on equity 5% 5% 11.10 10.50 2.30 1.90 1.20 1.10 30.0% 20.0% 30.0% Required: Develop a business valuation for Williams Company for 2019 using the following methods: (1) book value of equity, (2) market value of equity, (3) discounted cash flow (DCF), (4) enterprise value, and (5) all the multiples-based valuations for which there is an industry average multiplier. For the calculation of the DCF valuation, you may use the simplifying assumption that free cash flows will continue indefinitely at the amount in 2019. Answer is complete but not entirely correct. $ 1,348,000 6,851,500 12,760 7,478,500 Book value of equity Market value of equity Discounted free cash flows Enterprise value Multiples-based valuation Earnings multiple Free cash flow multiple Sales multiple 1,927,800 1,533,600 5,445,000 Williams Company is a manufacturer of auto parts having the following financial statements for 2018-2019. 0.83 points Balance Sheet December 31 2019 Cash $ 273,000 Accounts receivable 163,000 Inventory 398,000 Total current assets $ 834,000 Long-lived assets 1,770,000 Total assets $2,604,000 Current liabilities 356,000 Long-term debt 900,000 Shareholders' equity 1,348,000 Total debt and equity $2,604,000 2018 $ 148,000 238,000 188,000 $ 574,000 1,630,000 $2,204,000 305,000 930,000 969,000 $2,204,000 Income Statement For the years ended December 31 2019 Sales $3,630,000 Cost of sales 2,760,000 Gross margin 870,000 Operating expenses* 513,000 Operating income 357,000 Taxes 142,800 Net income $ 214,200 2018 $3,730,000 2,860,000 870,000 307,000 563,000 197,050 $ 365,950 Cash Flow from Operations $ 2018 365,950 115,000 Net income Plus depreciation expense + Decrease (-increase) in accounts receivable and inventory + Increase (-decrease) in current liabilities Cash flow from operations 2019 $ 214,200 125,000 (135,000) 51,000 $ 255,200 $ 480,950 *Operating expenses include depreciation expense. Additional financial information, including industry averages for 2019, where appropriate, includes: Industry 2019 35.0% 2019 2018 $ 170,000 $ 230,000 40% 35% $ 125,000 $ 115,000 $ 37,000 $ 37,000 $ 3.55 $ 4 1,930,000 1,930,000 25.00 1.50 18.00 9.00 Capital expenditures Income tax rate Depreciation expense Dividends Year-end stock price Number of outstanding shares Sales multiplier Free cash flow multiplier Earnings multiplier Cost of capital Accounts receivable turnover Inventory turnover Current ratio Quick ratio Cash flow from operations ratio Free cash flow ratio Gross margin percentage Return on assets (net book value) Return on equity 5% 5% 11.10 10.50 2.30 1.90 1.20 1.10 30.0% 20.0% 30.0% Required: Develop a business valuation for Williams Company for 2019 using the following methods: (1) book value of equity, (2) market value of equity, (3) discounted cash flow (DCF), (4) enterprise value, and (5) all the multiples-based valuations for which there is an industry average multiplier. For the calculation of the DCF valuation, you may use the simplifying assumption that free cash flows will continue indefinitely at the amount in 2019. Answer is complete but not entirely correct. $ 1,348,000 6,851,500 12,760 7,478,500 Book value of equity Market value of equity Discounted free cash flows Enterprise value Multiples-based valuation Earnings multiple Free cash flow multiple Sales multiple 1,927,800 1,533,600 5,445,000

Answer & Explanation Solved by verified expert

See Answer