Williams Company is a manufacturer of auto parts having the following financial statements for 2021-2022. Cash...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Williams Company is a manufacturer of auto parts having the following financial statements for 2021-2022. Cash Accounts receivable Inventory Total current assets Long-lived assets Total assets Current liabilities Long-term debt Shareholders' equity Total debt and equity Sales Cost of sales Gross margin Operating expenses* Operating income Taxes Net income Balance Sheet December 31 2022 $ 274,000 164,000 399,000 $ 837,000 1,780,000 $ 2,617,000 368,000 900,000 1,349,000 $ 2,617,000 Income Statement For the years ended December 31 2822 $ 3,640,000 2,780,000 860,000 514,000 346,000 121,100 $ 224,900 2021 $ 149,000 239,000 189,000 $ 577,000 1,640,000 $ 2,217,000 315,000 940,000 962,000 $ 2,217,000 Cash Flow from Operations 2021 $ 3,740,000 2,880,000 860,000 296,000 564,000 197,400 $366,600 2022 $ 224,900 130,000 (135,000) 2021 $ 366,600 120,000 Net income Plus depreciation expense + Decrease (-increase) in accounts receivable and inventory + Increase (-decrease) in current liabilities Cash flow from operations *Operating expenses include depreciation expense. Additional financial information, including industry averages for 2022, where appropriate, includes: 53,000 $ 272,900 $ 486,600 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 Lurrent ratio Quick ratio Cash flow from operations ratio Free cash flow ratio Gross margin percentage Return on assets (net book value) Return on equity Book value of equity Market value of equity Discounted free cash flows Enterprise value 2022 $ 170,000 35% Multiples-based valuation Earnings multiple Free cash flow multiple Sales multiple $ 130,000 $36,000 $ 3.65 1,940,000 5% 2021 $ 240,000 35% $ 120,000 $ 36,000 $4 1,940,000 5% Industry 2022 35.0% 25.00 1.50. 18.00 9.00 11.10 10.50 2.36 1.98 Required: Develop a business valuation for Williams Company for 2022 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 2022. 1.20 1.10 30.0% 20.0% 30.0% Williams Company is a manufacturer of auto parts having the following financial statements for 2021-2022. Cash Accounts receivable Inventory Total current assets Long-lived assets Total assets Current liabilities Long-term debt Shareholders' equity Total debt and equity Sales Cost of sales Gross margin Operating expenses* Operating income Taxes Net income Balance Sheet December 31 2022 $ 274,000 164,000 399,000 $ 837,000 1,780,000 $ 2,617,000 368,000 900,000 1,349,000 $ 2,617,000 Income Statement For the years ended December 31 2822 $ 3,640,000 2,780,000 860,000 514,000 346,000 121,100 $ 224,900 2021 $ 149,000 239,000 189,000 $ 577,000 1,640,000 $ 2,217,000 315,000 940,000 962,000 $ 2,217,000 Cash Flow from Operations 2021 $ 3,740,000 2,880,000 860,000 296,000 564,000 197,400 $366,600 2022 $ 224,900 130,000 (135,000) 2021 $ 366,600 120,000 Net income Plus depreciation expense + Decrease (-increase) in accounts receivable and inventory + Increase (-decrease) in current liabilities Cash flow from operations *Operating expenses include depreciation expense. Additional financial information, including industry averages for 2022, where appropriate, includes: 53,000 $ 272,900 $ 486,600 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 Lurrent ratio Quick ratio Cash flow from operations ratio Free cash flow ratio Gross margin percentage Return on assets (net book value) Return on equity Book value of equity Market value of equity Discounted free cash flows Enterprise value 2022 $ 170,000 35% Multiples-based valuation Earnings multiple Free cash flow multiple Sales multiple $ 130,000 $36,000 $ 3.65 1,940,000 5% 2021 $ 240,000 35% $ 120,000 $ 36,000 $4 1,940,000 5% Industry 2022 35.0% 25.00 1.50. 18.00 9.00 11.10 10.50 2.36 1.98 Required: Develop a business valuation for Williams Company for 2022 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 2022. 1.20 1.10 30.0% 20.0% 30.0%
Expert Answer:
Related Book For
Cost Management A Strategic Emphasis
ISBN: 978-0077733773
7th edition
Authors: Edward Blocher, David Stout, Paul Juras, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
Williams Company is a manufacturer of auto parts having the following financial statements for 20182019. Required Calculate and interpret the financial ratios for Williams for both years. Because the...
-
Williams Company is a manufacturer of auto parts having the following financial statements for 2015-2016. Balance Sheet December 31, 2016 and 2015 2016 2015 $ 260,000 150,000 385,000 $ 795,000...
-
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...
-
Construct a multilevel bill of material for product Z. How many Us are needed to make each Z? How many Ws are needed to make eachZ? Z. (2) (3) (2) (1) (1) (4)
-
Develop the user-friendly program in either a high-level or macro language of your choice to obtain a solution for a tridiagonal system with the Thomas algorithm (Figure). Test your program by...
-
When in 1920 the Chia brothers opened their first shop in Bangkok selling seeds for farmers, they did not know that they were on the way to launching the development of one of the most successful...
-
Choose a country from three of the regions presented in Table 6.7. Using the Internet, collect as much information as you believe is needed to identify the potential for market segments based on age,...
-
Brooklyn Corporation had the following transactions relating to product X during September. Determine the ending inventory value under each of the following costing methods: 1. FIFO (perpetual) 2....
-
You have just been named Director of Data Administration of General Hardware Co. General Hardware maintains a large, central IS organization with several operational relational databases at its...
-
In a volumetric determination of an analyte A, the data obtained and their standard deviations are as follows: From the data, find the coefficient of variation of the final result for the % A that is...
-
Which key reagents would you need to use to distinguish between following two molecules? OH OH A. Silver nitrate and ammonium hydroxide B. Chromic acid C. 2,4- dinitrophenyl hydrazine D. Anhydrous...
-
Describe the steps that should be taken to ensure a smooth handover of the project output from the project team to the client and the eventual users. These are steps that should take place before and...
-
Provide a comprehensive analysis of the policy Affordable Care Act. Include the following: Describe the model used for policy analysis. Discuss the problem the policy addresses. Identify the...
-
How will you as a health care manager ensure regulations are applied in your organization to maintain compliance? Provide an example. Discussion 2 What would you do if you were a new CEO and found...
-
Instructions: In order to ensure that you are truly grasping the assigned readings, each week students are required to submit (approximately) a one fiftey-word essay on: questions. Since this is an...
-
Management and Internal Control Create a scenario where external auditors determined that a company's internal controls were deficient, but such a deficiency might not mean that a material weakness...
-
5) The following are transactions for the city of Springfield. a. Borrowed $20,000 by issuing a three-month, 5% note.
-
Define a traverse in Surveying?
-
Green Grow Inc. (GGI) manufactures lawn fertilizer. Because of the product's very high quality, GGI often receives special orders from agricultural research groups. For each type of fertilizer sold,...
-
RJM Enterprises is a manufacturer of consumer electronics products. The industry is very competitive and RJM has seen its profits fall in recent years, including an operating loss of $18,585 last...
-
RNB is a bank holding company for a statewide group of retail consumer-oriented banks. RNB was formed in the early 1960s by investors who believed in a high level of consumer services. The number of...
-
What are the Returns and Risks currently for the different asset classes?
-
What is the P(Gain) for each?
-
What does the time series state when graphing from the Financial Crisis to the current day for each of the asset classes?
Study smarter with the SolutionInn App