Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Williams Company is a manufacturer of auto parts having the following financial statements for 20212022. Balance Sheet December 31 2022 2021 Cash $ 260,000 $

Williams Company is a manufacturer of auto parts having the following financial statements for 20212022.

Balance Sheet
December 31
2022 2021
Cash $ 260,000 $ 135,000
Accounts receivable 150,000 225,000
Inventory 385,000 175,000
Total current assets $ 795,000 $ 535,000
Long-lived assets 1,640,000 1,500,000
Total assets $ 2,435,000 $ 2,035,000
Current liabilities 200,000 175,000
Long-term debt 900,000 800,000
Shareholders equity 1,335,000 1,060,000
Total debt and equity $ 2,435,000 $ 2,035,000

Income Statement
For the years ended December 31
2022 2021
Sales $ 3,500,000 $ 3,600,000
Cost of sales 2,500,000 2,600,000
Gross margin 1,000,000 1,000,000
Operating expenses* 500,000 450,000
Operating income 500,000 550,000
Taxes 175,000 192,500
Net income $ 325,000 $ 357,500

Cash Flow from Operations
2022 2021
Net income $ 325,000 $ 357,500
Plus depreciation expense 60,000 50,000
+ Decrease (increase) in accounts receivable and inventory (135,000)
+ Increase (decrease) in current liabilities 25,000
Cash flow from operations $ 275,000 $ 407,500

*Operating expenses include depreciation expense.

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

2022 2021 Industry 2022
Capital expenditures $ 125,000 $ 100,000
Income tax rate 35% 35% 35.0%
Depreciation expense $ 60,000 $ 50,000
Dividends $ 50,000 $ 50,000
Year-end stock price $ 2.25 $ 2.75 25.00
Number of outstanding shares 1,800,000 1,800,000
Sales multiplier 1.50
Free cash flow multiplier 18.00
Earnings multiplier 9.00
Cost of capital 5.0% 5.0%
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:

Calculate and interpret the financial ratios (see Exhibit 20.9) for Williams for both years. Because the calculation of many ratios requires the average balance in an account (e.g., average receivables is required in calculating receivables turnover), you may assume for simplicity that the balances in these accounts in 2021 are the same as those in 2020. (Round "Earnings per share" to 3 decimal places, other "Profitability Ratios" to 1 decimal place (i.e. 0.123 = 12.3%) and rest of the answers to 2 decimal places.)

image text in transcribed \begin{tabular}{|c|c|c|c|c|c|c|} \hline Financial Ratios & \multicolumn{2}{|l|}{2021} & \multicolumn{2}{|l|}{2020} & \multicolumn{2}{|l|}{ Industry } \\ \hline Liquidity Ratios & & & & & & \\ \hline Accounts receivable turnover & & & & & 11.10 & \\ \hline Inventory turnover & & & & & 10.50 & \\ \hline Current ratio & 3.98 & & 3.06 & & 2.30 & \\ \hline Quick ratio & 2.05 & & 2.06 & & 1.90 & \\ \hline Cash Flow Ratios & & & & & & \\ \hline Cash flow from operations & 1.38 & & 2.33 & & 1.20 & \\ \hline Free cash flow & & & & & 1.10 & \\ \hline Profitability Ratios & & & & & & \\ \hline Gross margin percentage & 28.6 & % & 27.8 & % & 30 & % \\ \hline Return on assets (Net book value) & & % & 17.6 & % & 20 & % \\ \hline Return on equity & & % & 33.7 & % & 30 & % \\ \hline Earnings per share & 0.181 & & 0.199 & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forensics Audits And Dreaming

Authors: Helgard Petrus - Coetser

1st Edition

1664260250, 978-1664260252

More Books

Students also viewed these Accounting questions

Question

To solve p + 3q = 5z + tan( y - 3x)

Answered: 1 week ago

Question

Does it have at least one-inch margins?

Answered: 1 week ago

Question

Does it highlight your accomplishments rather than your duties?

Answered: 1 week ago