Question

In: Accounting

Williams Company is a manufacturer of auto parts having the following financial statements for 2018-2019. Balance...

Williams Company is a manufacturer of auto parts having the following financial statements for 2018-2019.

Balance Sheet
December 31
2019 2018
Cash $ 270,000 $ 145,000
Accounts receivable 160,000 235,000
Inventory 395,000 185,000
Total current assets $ 825,000 $ 565,000
Long-lived assets 1,740,000 1,600,000
Total assets $ 2,565,000 $ 2,165,000
Current liabilities 320,000 275,000
Long-term debt 900,000 900,000
Shareholders’ equity 1,345,000 990,000
Total debt and equity $ 2,565,000 $ 2,165,000
Income Statement
For the years ended December 31
2019 2018
Sales $ 3,600,000 $ 3,700,000
Cost of sales 2,700,000 2,800,000
Gross margin 900,000 900,000
Operating expenses* 510,000 340,000
Operating income 390,000 560,000
Taxes 136,500 196,000
Net income $ 253,500 $ 364,000
Cash Flow from Operations
2019 2018
Net income $ 253,500 $ 364,000
Plus depreciation expense 110,000 100,000
+ Decrease (−increase) in accounts receivable and inventory (135,000 )
+ Increase (−decrease) in current liabilities 45,000
Cash flow from operations $ 273,500 $ 464,000

*Operating expenses include depreciation expense.

Additional financial information, including industry averages for 2019, where appropriate, includes:

2019 2018 Industry 2019
Capital expenditures $ 95,000 $ 200,000
Income tax rate 35 % 35 % 35.0 %
Depreciation expense $ 110,000 $ 100,000
Dividends $ 40,000 $ 40,000
Year-end stock price $ 3.25 $ 4 25.00
Number of outstanding shares 1,900,000 1,900,000
Sales multiplier 1.50
Free cash flow multiplier 18.00
Earnings multiplier 9.00
Cost of capital 5 % 5 %
Accounts receivable turnover 11.10
Inventory turnover 10.50
Current ratio 2.30
Quick ratio 1.90
Cash flow from operations ratio 1.20
Free cash flow ratio 1.10
Gross margin percentage 30.0 %
Return on assets (net book value) 20.0 %
Return on equity 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.

Solutions

Expert Solution

ANSWER

Answer-1:

Book Value of Equity =Total Assets-Total Liabilities (Excluding Equity)

=Total assets-(Current Liabilities +Long Term Debt)

=$2,565,000-($320,000+$920,000)

=$1,325,000

Answer-2:

Market Value of Equity = Total outstanding shares × Current stock price

=1,900,000 × $3.25

=$6,175,000

Answer-3:

Free Cash Flow =Net Income+Depreciation -Capital Expenditure -Change in Net Working Capital

=Net Income + Depreciation -Capital Expenditure -(Increase in Accounts Receivable -Increase in Current Liabilities)

=$253,500 + $110,000 - $95,000 - ($135,000 - $45,000)

=$178,000

Discounted Free Cash Flow =$178,000 × (1/1.05)

=$169,524

Answer-4:

Enterprise Value = (Market Capitalization + Total Debt - Cash) / Cash From Operations

=($6,175,000 + $900,000 - $270,000) / $273,500

=24.88

__________________________________

If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.

*****************THANK YOU*************


Related Solutions

Williams Company is a manufacturer of auto parts having the following financial statements for 2016. Balance...
Williams Company is a manufacturer of auto parts having the following financial statements for 2016. Balance Sheet December 31, 2016 2016   Cash $ 280,000   Accounts receivable 170,000   Inventory 405,000      Total current assets $ 855,000   Long-lived assets 1,840,000      Total assets $ 2,695,000   Current liabilities 420,000   Long-term debt 920,000   Shareholder equity 1,355,000      Total debt and equity $ 2,695,000 Income Statement For the years ended December 31, 2016 2016   Sales $ 3,700,000   Cost of sales 2,900,000      Gross margin 800,000   Operating expenses* 520,000      Operating...
Financial statements for Baird Company follow. BAIRD COMPANY Balance Sheets As of December 31 2019 2018...
Financial statements for Baird Company follow. BAIRD COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 17,000 $ 13,000 Marketable securities 20,200 6,200 Accounts receivable (net) 43,000 35,000 Inventories 128,000 136,000 Prepaid items 27,000 12,000 Total current assets 235,200 202,200 Investments 32,000 25,000 Plant (net) 265,000 250,000 Land 28,000 23,000 Total assets $ 560,200 $ 500,200 Liabilities and Stockholders’ Equity Liabilities Current liabilities Notes payable $ 18,800 $ 12,500 Accounts payable 113,800 100,000 Salaries payable...
Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018...
Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 40,000 $ 36,000 Marketable securities 20,000 6,000 Accounts receivable (net) 54,000 46,000 Inventories 135,000 143,000 Prepaid items 25,000 10,000 Total current assets 274,000 241,000 Investments 27,000 20,000 Plant (net) 270,000 255,000 Land 29,000 24,000 Total assets $ 600,000 $ 540,000 Liabilities and Stockholders’ Equity Liabilities Current liabilities Notes payable $ 17,000 $ 6,000 Accounts payable 113,800 100,000 Salaries payable...
Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018...
Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 40,000 $ 36,000 Marketable securities 20,000 6,000 Accounts receivable (net) 54,000 46,000 Inventories 135,000 143,000 Prepaid items 25,000 10,000 Total current assets 274,000 241,000 Investments 27,000 20,000 Plant (net) 270,000 255,000 Land 29,000 24,000 Total assets $ 600,000 $ 540,000 Liabilities and Stockholders’ Equity Liabilities Current liabilities Notes payable $ 17,000 $ 6,000 Accounts payable 113,800 100,000 Salaries payable...
Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018...
Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 40,000 $ 36,000 Marketable securities 20,000 6,000 Accounts receivable (net) 54,000 46,000 Inventories 135,000 143,000 Prepaid items 25,000 10,000 Total current assets 274,000 241,000 Investments 27,000 20,000 Plant (net) 270,000 255,000 Land 29,000 24,000 Total assets $ 600,000 $ 540,000 Liabilities and Stockholders’ Equity Liabilities Current liabilities Notes payable $ 17,000 $ 6,000 Accounts payable 113,800 100,000 Salaries payable...
Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018...
Financial statements for Allendale Company follow: ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 40,000 $ 36,000 Marketable securities 20,000 6,000 Accounts receivable (net) 54,000 46,000 Inventories 135,000 143,000 Prepaid items 25,000 10,000 Total current assets 274,000 241,000 Investments 27,000 20,000 Plant (net) 270,000 255,000 Land 29,000 24,000 Total assets $ 600,000 $ 540,000 Liabilities and Stockholders’ Equity Liabilities Current liabilities Notes payable $ 17,000 $ 6,000 Accounts payable 113,800 100,000 Salaries payable...
Financial statements for Perez Company follow. PEREZ COMPANY Balance Sheets As of December 31 2019 2018...
Financial statements for Perez Company follow. PEREZ COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 21,500 $ 17,500 Marketable securities 21,100 7,100 Accounts receivable (net) 52,000 44,000 Inventories 137,000 145,000 Prepaid items 26,000 11,000 Total current assets 257,600 224,600 Investments 32,000 25,000 Plant (net) 265,000 250,000 Land 29,000 24,000 Total assets $ 583,600 $ 523,600 Liabilities and Stockholders’ Equity Liabilities Current liabilities Notes payable $ 30,200 $ 12,900 Accounts payable 98,800 85,000 Salaries payable...
Comparative financial statements for Wing Company follow: Wing Company Balance Sheets December 31, 2018 and 2019...
Comparative financial statements for Wing Company follow: Wing Company Balance Sheets December 31, 2018 and 2019 Current assets:     Cash $18,000   $15,000        Accounts receivable 25,000   22,000       Inventory 22,000   20,000       Prepaid expenses 10,000    14,000    Total current assets 75,000   71,000 Long‐term assets 25,000   7,000   Property, plant, and equipment 80,000   77,000       Less: Accumulated depreciation (64,000) (61,000) Net property, plant, and equipment 16,000   16,000   Total assets 116,000   94,000   Liabilities and Stockholdersʹ Equity Current liabilities:      Accounts payable $8,000 6,000   ...
Consider the following abbreviated financial statements for Weston Enterprises: WESTON ENTERPRISES 2018 and 2019 Partial Balance...
Consider the following abbreviated financial statements for Weston Enterprises: WESTON ENTERPRISES 2018 and 2019 Partial Balance Sheets Assets Liabilities and Owners’ Equity 2018 2019 2018 2019 Current assets $ 1,266 $ 1,387 Current liabilities $ 552 $ 601 Net fixed assets 5,043 6,098 Long-term debt 2,738 2,915 WESTON ENTERPRISES 2019 Income Statement Sales $ 15,778 Costs 7,225 Depreciation 1,423 Interest paid 428 a. What is owners' equity for 2018 and 2019? (Do not round intermediate calculations.) b. What is the...
Consider the following abbreviated financial statements for Weston Enterprises: WESTON ENTERPRISES 2018 and 2019 Partial Balance...
Consider the following abbreviated financial statements for Weston Enterprises: WESTON ENTERPRISES 2018 and 2019 Partial Balance Sheets Assets Liabilities and Owners’ Equity 2018 2019 2018 2019 Current assets $ 1,218 $ 1,323 Current liabilities $ 496 $ 553 Net fixed assets 4,987 6,010 Long-term debt 2,650 2,819 WESTON ENTERPRISES 2019 Income Statement Sales $ 15,394 Costs 7,153 Depreciation 1,375 Interest paid 396 a. What is owners' equity for 2018 and 2019? (Do not round intermediate calculations.) b. What is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT