Question

In: Accounting

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 income 280,000
  Taxes 98,000
     Net income $ 182,000

  

Cash Flow from Operations
2016
  Net income $ 182,000
  Plus depreciation expense 160,000
  +Decrease (-inc) in Accounts receivable and Inventory (155,000 )
  +Increase (-dec) in Current liabilities 125,000
     Cash flow from operations $ 312,000
*Operating expenses include depreciation expense.

  

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

  

2016 Industry 2016
  Capital expenditures $ 165,000
  Income tax rate 35 % 35.0 %
  Depreciation expense $ 160,000
  Dividends $ 30,000
  Year-end stock price $ 4.25 25.00
  Number of outstanding shares 2,000,000
  Sales multiplier 1.50
  Free cash flow multiplier 18.00
  Earnings multiplier 9.00
  Cost of capital 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 2016 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 2016.

Solutions

Expert Solution

The following methods of valuation are explained below ;

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

                                  =$2695000-(Current Liabilities +Long Term Debt)

                                  =$2695000-($420000+$920000)

                                  =$1355000

So in a broader sense it can be interpreted that if Williams Company sold off its assets and pays down its liabilities the equity value or net worth of the business would be $1355000.The return on equity is much lesser as compared to the industry standard of 30% which is 13.43%

2.Market Value of Equity is the total dollar value of a company equity calculated by multiplying the current stock price by total outstanding shares.A company market value therefore constantly changes based on these two variables.

                                       =2,000,000 *$4.25

                                       =$85000000

   3.Free Cash Flow =Net Income+Depreciation -Capital Expenditure -Change in NWC

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

                              =$182000+$160000-$165000-($155000-$125000)

                              =$147000

Discounted Free Cash Flow =$147000/(1/1.05)

                                         =$140000

4.Enterprise Value =It is ratio of the entire economic value of a company to the cash it produces

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

                           =(2,000,000 *$4.25+$920000-$280000)/$312000

                           =($85000000+$920000-$280000)/$312000

                           =274.5

                    

   


Related Solutions

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...
Jackson Auto Parts Manufacturer, a U.S. based manufacturer of piston rings and other auto parts sold...
Jackson Auto Parts Manufacturer, a U.S. based manufacturer of piston rings and other auto parts sold parts to a South Korean Auto Manufacturer on December 1, 2020 with payment in 10 million South Korean Won to be received on March 31, 2021. The following exchange rates are relevant: Date:    Spot Rate                Forward Rate Dec 1, 2020 $0.0035 $0.0034 Dec 31, 2020 $0.0033 $0.0032 March 31 2021 $0.0038 $0.0032 Assuming Jackson did not hedge its foreign exchange risk, how much foreign...
What is the Importance of having financial statements in a company (eg: Balance sheet, profit and...
What is the Importance of having financial statements in a company (eg: Balance sheet, profit and loss, trial balance, and journal report). please write it in paragraphs Thank you
1.   Williams Furniture Company has the following data:         Williams Furniture          Balance Sheet       December...
1.   Williams Furniture Company has the following data:         Williams Furniture          Balance Sheet       December 31, 201x Assets: Cash                                                $50,000 Marketable Securities            80,000 Accounts Receivable        3,000,000 Inventory                                1,000,000 Gross plant &                   Equipment           6,000,000                   Less Accum                   Depreciation       2,000,000 Total Assets                            8,130,000 Liabilities And Equity Accounts Payable               $2,200,000 Accrued Expense                        150,000 Notes Payable (current)        400,000 Bonds Payable                          2,500,000 Common Stock (1.7 Million shares, par $1)     1,700,000 Retained Earnings                  1,180,000 Total Liabilities &...
Auto Parts, Inc. is medium-sized company that manufactures auto parts in Buffalo, New York. The company...
Auto Parts, Inc. is medium-sized company that manufactures auto parts in Buffalo, New York. The company currently loses $30,000 per month. The owner of the company is evaluating whether she should shut down the factory. She thinks that the factory should continue to operate until the economic environment improves and buyer for the factory can be identified. The logic of the owner is that her company has already invested millions of dollars in the factory over the years. The monthly...
The following are the financial statements of Nosker Company.    Nosker Company    Comparative Balance Sheet...
The following are the financial statements of Nosker Company.    Nosker Company    Comparative Balance Sheet    December 31, Assets 2017 2016 Cash $ 38,000. $ 20,000 Accounts receivable 30,000 14,000 Inventory 27,000 20,000 Equipment 60,000 78,000 Accumulated depreciation- equipment (29,000) (24,000) Total $126,000 $108,000 Liabilities and Stockholders' Equity Accounts payable $ 24,000 $ 15,000 Income taxes payable 7,000 8,000 Bonds payable 27,000 33,000 Common stock 18,000    14,000 Retained earnings 50,000 38,000 Total $126,000. $ 108,000 NOSKER COMPANY INCOME...
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2006 by two...
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2006 by two talented engineers with little business training. In 2018, the company was acquired by one of its major customers. As part of an internal audit, the following facts were discovered. The audit occurred during 2018 before any adjusting entries or closing entries were prepared. The income tax rate is 40% for all years. A five-year casualty insurance policy was purchased at the beginning of 2016...
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2009 by two...
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2009 by two talented engineers with little business training. In 2021, the company was acquired by one of its major customers. As part of an internal audit, the following facts were discovered. The audit occurred during 2021 before any adjusting entries or closing entries were prepared. The income tax rate is 25% for all years. A five-year casualty insurance policy was purchased at the beginning of 2019...
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2009 by two...
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2009 by two talented engineers with little business training. In 2021, the company was acquired by one of its major customers. As part of an internal audit, the following facts were discovered. The audit occurred during 2021 before any adjusting entries or closing entries were prepared. The income tax rate is 25% for all years. A five-year casualty insurance policy was purchased at the beginning of 2019...
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2009 by two...
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2009 by two talented engineers with little business training. In 2021, the company was acquired by one of its major customers. As part of an internal audit, the following facts were discovered. The audit occurred during 2021 before any adjusting entries or closing entries were prepared. The income tax rate is 25% for all years. A five-year casualty insurance policy was purchased at the beginning of 2019...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT