Ch07 P15 Build a Model-913649
xlsx
keyboard_arrow_up
School
National Open and Distance University *
*We aren’t endorsed by this school
Course
122
Subject
Finance
Date
Nov 24, 2024
Type
xlsx
Pages
15
Uploaded by jacque84
Ratio Analysis
Joshua & White Technologies: December 31 Balance Sheets
(Thousands of Dollars)
2021
2020
Assets
Cash
$21,525
$20,500
Short-term investments
4,195
2,980
Accounts receivable
52,500
49,000
Inventories
88,000
56,000
Total current assets
$166,220
$128,480
Net fixed assets
231,951
210,000
Total assets
$398,171
$338,480
Liabilities & Equity
Accounts payable
$30,975
$29,500
Accruals
10,500
10,000
Notes payable
19,414
5,620
Total current liabilities
$60,889
$45,120
Long-term debt
73,032
62,260
Total liabilities
$133,921
$107,380
Common stock
182,000
182,000
Retained earnings
82,250
49,100
Total common equity
$264,250
$231,100
Total liabilities & equity
$398,171
$338,480
Joshua & White Technology: Income Statements for Year
Ending on December 31 (Thousands of Dollars)
2021
2020
Sales
$430,500
$410,000
COGS excluding depreciation and amortization
308,500
307,500
Depreciation and amortization
20,420
18,900
Other operating expenses
26,500
20,500
EBIT
$75,080
$63,100
Interest expense
6,040
4,660
EBT
$69,040
$58,440
Taxes (25%)
17,260
14,610
Net income
$51,780
$43,830
Common dividends
$18,630
$17,532
Additions to retained earnings
$33,150
$26,298
Other Data
2021
2020
Year-end stock price
$88.00
$96.00
Number of shares (Thousands)
4,046
4,000
Lease payment (Thousands of Dollars)
$20,000
$20,000
Sinking fund payment (Thousands of Dollars)
$5,000
$5,000
a. Determining whether J&W’s liquidity position has improved or worsened
2021
2020
Current ratio
2.73
2.85
Quick ratio
1.28
1.61
b. Determining whether J&W's ability to manage its assets has improved or worsened
Days in a year
365
2021
2020
Inventory turnover
3.74
5.83
Days sales outstanding (days)
44.51
43.62
Fixed assets turnover
1.86
1.95
Total assets turnover
1.08
1.21
c. Determining how J&W's profitability has changed during the last year
2021
2020
Profit margin
12.03%
10.69%
Basic earning power
18.86%
18.64%
Return on assets
13.00%
12.95%
Return on equity
19.60%
18.97%
d. Performing an extended DuPont analysis for J&W for 2020 and 2021
Profit margin
TA turnover
Equity multiplier
2021
12.03%
1.08
1.51
2020
10.69%
1.21
1.46
e. Performing a common size analysis
Common Size Balance Sheets
2021
2020
Assets
Cash
5.41%
6.06%
Short-term investments
1.05%
0.88%
Accounts receivable
13.19%
14.48%
Inventories
22.10%
16.54%
Total current assets
41.75%
37.96%
Net fixed assets
58.25%
62.04%
Total assets
100.00%
100.00%
Liabilities & Equity
Accounts payable
7.78%
8.72%
Accruals
2.64%
2.95%
Notes payable
4.88%
1.66%
Total current liabilities
15.29%
13.33%
Long-term debt
18.34%
18.39%
Total liabilities
33.63%
31.72%
Common stock
45.71%
53.77%
Retained earnings
20.66%
14.51%
Total common equity
66.37%
68.28%
Total liabilities & equity
100.00%
100.00%
Common Size Income Statements
2021
2020
Sales
100.00%
100.00%
COGS excluding depreciation and amortization
71.66%
75.00%
Depreciation and amortization
4.74%
4.61%
Other operating expenses
6.16%
5.00%
EBIT
17.44%
15.39%
Interest expense
1.40%
1.14%
EBT
16.04%
14.25%
Taxes (25%)
4.01%
3.56%
Net income
12.03%
10.69%
f. Performing a percentage change analysis
Percent Change Balance Sheet
Formulas
Assets
Cash
5.00% =(C7-D7)/D7
Short-term investments
40.77% =(C8-D8)/D8
Accounts receivable
7.14% =(C9-D9)/D9
Inventories
57.14% =(C10-D10)/D10
Total current assets
29.37% =(C11-D11)/D11
Net fixed assets
10.45% =(C12-D12)/D12
Total assets
17.64% =(C13-D13)/D13
Liabilities & Equity
Accounts payable
5.00% =(C16-D16)/D16
Accruals
5.00% =(C17-D17)/D17
Notes payable
245.44% =(C18-D18)/D18
Total current liabilities
34.95% =(C19-D19)/D19
Long-term debt
17.30% =(C20-D20)/D20
Total liabilities
24.72% =(C21-D21)/D21
Common stock
0.00% =(C22-D22)/D22
Retained earnings
67.52% =(C23-D23)/D23
Total common equity
14.34% =(C24-D24)/D24
Total liabilities & equity
17.64% =(C25-D25)/D25
Percent Change Income Statement
Formulas
Sales
5.00% =(C30-D30)/D30
COGS excluding depreciation and amortization
0.33% =(C31-D31)/D31
Depreciation and amortization
8.04% =(C32-D32)/D32
Other operating expenses
29.27% =(C33-D33)/D33
EBIT
18.99% =(C34-D34)/D34
Interest expense
29.61% =(C35-D35)/D35
EBT
18.14% =(C36-D36)/D36
Taxes (25%)
18.14% =(C37-D37)/D37
Net income
18.14% =(C38-D38)/D38
Percent Change in 2021
Percent Change in 2021
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ROE
19.60%
18.97%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Seminole Corporation reported the following items at December 31, 2021, and 2020:
(Click the icon to view the comparative financial information.)
Read the requirements.
Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio
value as strong or weak. All sales are on account with terms of net 30 days.
(a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents.
Round your final answer to two decimal places.)
Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio
$
Seminole's quick (acid-test) ratio is considered fairly weak.
(b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal
places, XX.XX. Round the days' sales outstanding up to the next whole day.)
Accounts receivable turnover =
+
Days' sales outstanding
Seminole's days'…
arrow_forward
Liquidity Ratios:
2022
2021
Current ratio
Working capital
I need help finding liquidity ratios. Could you explain why you got that? Thanks.
arrow_forward
What is Ratio Corporation's Fiscal 2021 Times Interest Earned Ratio?
1.41
2.57
4.5
1.63
arrow_forward
Ratios For Amazon.com, Inc. (AMZN)
2018 2019
Current Ratio
Acid test Ratio
Ave. Days Collection
Total Debt to Total Assets
Return on Equity
Asset Turnover
Profit Margin on net Sales
Inventory Turnover***
arrow_forward
GIVE THE COMPARATIVE BALANCE SHEET HORIZONTAL AND VERTICAL ANALYSIS FROM THE GIVEN BALANCE SHEET BELOW
JOLLIBEE BALANCE SHEET
ASSETS
ITEM
2016
2017
2018
2019
2020
Cash & Short Term Investments
17.46B
22.52B
24.17B
23.02B
57.46B
Cash & Short Term Investments Growth
-
28.99%
7.32%
-4.75%
149.59%
Cash Only
16.73B
21.11B
23.29B
20.89B
21.36B
Short-Term Investments
726M
1.41B
883.2M
2.13B
36.1B
Cash & ST Investments / Total Assets
23.96%
25.08%
16.06%
12.28%
27.26%
Total Accounts Receivable
3.59B
4.02B
4.86B
5.91B
7.05B
Total Accounts Receivable Growth
-
11.86%
21.04%
21.46%
19.36%
Accounts Receivables, Net
3.03B
3.39B
4.41B
5.37B
5.8B
Accounts Receivables, Gross
3.61B
4.08B
5.09B
5.76B
6.46B
Bad Debt/Doubtful Accounts
(579.79M)
(690.12M)
(676.91M)
(392.36M)
(658.63M)
Other Receivable
562.75M
630.06M
451.73M…
arrow_forward
Calculate
Debt-to-equity
Times interest earned
Return on Financial leverage
arrow_forward
The comparative balance sheets for Metlock Corporation show the following information.
December 312020 2019Cash $33,500 $12,900Accounts receivable 12,400 10,000Inventory 12,100 9,000Available-for-sale debt investments –0– 3,000Buildings –0– 29,800Equipment 44,800 19,900Patents 5,000 6,300 $107,800 $90,900Allowance for doubtful accounts $3,100 $4,500Accumulated depreciation—equipment 2,000 4,500Accumulated depreciation—building –0– 6,000Accounts payable 5,000 3,000Dividends payable –0– 4,900Notes payable, short-term (nontrade) 3,000 4,100Long-term notes payable 31,000 25,000Common stock 43,000 33,000Retained earnings 20,700 5,900 $107,800 $90,900
Additional data related to 2020 are as follows.
1. Equipment that had cost $11,000 and was 40% depreciated at time of disposal was sold for $2,500.2. $10,000 of the long-term note payable was paid by issuing common stock.3. Cash dividends paid were $4,900.4. On January…
arrow_forward
Additional information: 2018
current ratio: 1.4:1
debt to total assets: 61.1%
Question: find working capital for 2018
Additional information: 2017
current ratio 1.5:1
working capital: 214,500
Question find debt to total assets for 2017
arrow_forward
nterpret the results of the debt to equity ratio and how the company has managed debt over the last two years.
Balance Sheet
2018
2019
Cash
$63,000
$201,000
Accounts Receivable
199,000
305,000
Marketable Securities
81,000
42,000
Inventories
441,000
455,000
Prepaids
5,000
9,000
Total Current Assets
789,000
1,012,000
Property, Plant, and Equipment, net
858,000
858,000
Total Assets
$1,647,000
$1,870,000
Account Payable
$150,000
$100,000
Accruals
101,000
95,000
Total Current Liabilities
$251,000
$195,000
Bonds Payable
405,000
575,000
Total Liabilities
656,000
770,000
Common Stocks
700,000
700,000
Retained Earnings
291,000
400,000
Total Stockholders’ Equity
991,000
1,100,000
Total Liabilities & Equity
$1,647,000
$1,870,000
Income Statement…
arrow_forward
Total fixed assets
31420 OMR
Total long term liabilities
9970 OMR
Total current assets
18930 OMR
Total current liabilities
4765 OMR
Shareholders’ funds
35615 OMR
Capital employed
45585 OMR
Gross profit
175000 OMR
Net profit
113950 OMR
Return on capital employed
25%
Current ratio
3.97
Liquid ratio
3.34
Return on Equity
3.191
Gross Profit Margin
53,03%
Net Profit Margin
34.53%
Q/Give a brief report on the financial position of the company based on the above figures?
arrow_forward
From the balance sheet prepare a proforma income statement where revenues can increase by 2% and the firm can borrow at 5.5%
BALANCE SHEET
2021
Cash and cash equivalents
280
Receivables
2588
Inventory
2516
Other CA
189
TOTAL CA
5573
Fixed assets
5024
TOTAL ASSETS
10597
Accounts payable
4713
Short term debt
78
TOTAL CL
4790
LT debt
921
Shareh. Equity
4886
TOTAL LIAB. AND SHARH. EQUITY
10597
INCOME STATEMENT
2021
Sales
19418
COGS
13136
Depreciations
354
SG&A
4952
EBIT
976
Interest Expenses
52
Tax
268
Net income
656
Pro-forma statement
Pro Forma Forecasts
Actual
Projected
Projected
Projected
Projected
Projected
2021
2022
2023
2024
2025
2026
COGS/REVENUES
SGA/SALES
INVENTORIES/COGS
OTHER CA/SALES
AR/SALES
AP/COGS
SALES/FIXED ASSETS
DEPR/ FIXED ASSETS
EQUITY/INVESTED CAPITAL
ST DEBT/INVESTED…
arrow_forward
General Finance
arrow_forward
Give true solution for this accounting question
arrow_forward
Calculate gross profit ratio for the year 2018 and 2019
arrow_forward
Find debt-to-equity, times interest earned, and return on financial leverage for both companies for years 2017, 2018, and 2019.
arrow_forward
Please show calculation
arrow_forward
Use the common-size financial statements found here:
ommon-Size Balance Sheet 2016Cash and marketable securities $ 480 1.5 %Accounts receivable 6,030 18.2Inventory 9,540 28.8Total current assets $ 16,050 48.5 %Net property, plant, and equipment 17,020 51.5Total assets $33,070 100.0 %Accounts payable $ 7,150 21.6 %Short-term notes 6,850 20.7Total current liabilities $ 14,000 42.3 %Long-term liabilities 7,010 21.2Total liabilities $ 21,010 63.5 %Total common shareholders’ equity 12,060 36.5Total liabilities and shareholders’ equity $33,070 100.0 %Common-Size Income Statement 2016Revenues $ 30,000 100.0 %Cost of goods sold (20,050) 66.8Gross profit $ 9,950 33.2 %Operating expenses (7,960) 26.5Net operating income $ 1,990 6.6 %Interest expense (940) 3.1Earnings before taxes $ 1,050 3.5 %Income taxes (382) 1.3Net income $668 2.2 %
Specifically, write up a brief narrative that responds to the following questions:
a. How much cash does Patterson have on hand relative to its total…
arrow_forward
Crane Company has these comparative balance sheet data:
CRANE COMPANYBalance SheetsDecember 31
2022
2021
Cash
$ 27,105
$ 54,210
Accounts receivable (net)
126,490
108,420
Inventory
108,420
90,350
Plant assets (net)
361,400
325,260
$623,415
$578,240
Accounts payable
$ 90,350
$ 108,420
Mortgage payable (15%)
180,700
180,700
Common stock, $10 par
252,980
216,840
Retained earnings
99,385
72,280
$623,415
$578,240
Additional information for 2022:
1.
Net income was $27,900.
2.
Sales on account were $382,300. Sales returns and allowances amounted to $29,000.
3.
Cost of goods sold was $207,500.
4.
Net cash provided by operating activities was $57,000.
5.
Capital expenditures were $28,900, and cash dividends were $17,900.
Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…
arrow_forward
།
Debt-to-Equity (D/E) Ratio
Equity Ratio
Gearing Ratios
= Total Debt + Total Equity
= Total Shareholders' Equity - Total Assets
Debt Ratio
= Total Debt + Total Assets
Lola's Company
Balance Sheet
December 31st, 2020
Assets
Cash and Cash Equivalents $100,000
Accounts Receivable $150,000
Inventory $200,000
Prepaid Expenses $50,000
Property, Plant and Equipment $500,000
Total Assets $1,000,000
Liabilities
Accounts Payable $100,000
Notes Payable $200,000
Accrued Expenses $50,000
Total Liabilities $350,000
Owner's Equity
Common Stock $250,000
Retained Earnings $400,000
Total Owner's Equity $650,000
Total Liabilities and Owner's Equity $1,000,000
Statement of Owner's Equity
December 31st, 2020
Owner's Equity at Beginning of Year
$400,000
Net Income for the Year
$130,000
Issuance of Common Stock
$50,000
Dividends Paid
($30,000)
Owner's Equity at End of Year
$550,000
Lola's Company
Statement of Cash Flow
December 31st, 2020
Cash Flows from Operating Activities
Net Income
Depreciation Expense…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Related Questions
- Seminole Corporation reported the following items at December 31, 2021, and 2020: (Click the icon to view the comparative financial information.) Read the requirements. Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio value as strong or weak. All sales are on account with terms of net 30 days. (a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents. Round your final answer to two decimal places.) Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio $ Seminole's quick (acid-test) ratio is considered fairly weak. (b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal places, XX.XX. Round the days' sales outstanding up to the next whole day.) Accounts receivable turnover = + Days' sales outstanding Seminole's days'…arrow_forwardLiquidity Ratios: 2022 2021 Current ratio Working capital I need help finding liquidity ratios. Could you explain why you got that? Thanks.arrow_forwardWhat is Ratio Corporation's Fiscal 2021 Times Interest Earned Ratio? 1.41 2.57 4.5 1.63arrow_forward
- Ratios For Amazon.com, Inc. (AMZN) 2018 2019 Current Ratio Acid test Ratio Ave. Days Collection Total Debt to Total Assets Return on Equity Asset Turnover Profit Margin on net Sales Inventory Turnover***arrow_forwardGIVE THE COMPARATIVE BALANCE SHEET HORIZONTAL AND VERTICAL ANALYSIS FROM THE GIVEN BALANCE SHEET BELOW JOLLIBEE BALANCE SHEET ASSETS ITEM 2016 2017 2018 2019 2020 Cash & Short Term Investments 17.46B 22.52B 24.17B 23.02B 57.46B Cash & Short Term Investments Growth - 28.99% 7.32% -4.75% 149.59% Cash Only 16.73B 21.11B 23.29B 20.89B 21.36B Short-Term Investments 726M 1.41B 883.2M 2.13B 36.1B Cash & ST Investments / Total Assets 23.96% 25.08% 16.06% 12.28% 27.26% Total Accounts Receivable 3.59B 4.02B 4.86B 5.91B 7.05B Total Accounts Receivable Growth - 11.86% 21.04% 21.46% 19.36% Accounts Receivables, Net 3.03B 3.39B 4.41B 5.37B 5.8B Accounts Receivables, Gross 3.61B 4.08B 5.09B 5.76B 6.46B Bad Debt/Doubtful Accounts (579.79M) (690.12M) (676.91M) (392.36M) (658.63M) Other Receivable 562.75M 630.06M 451.73M…arrow_forwardCalculate Debt-to-equity Times interest earned Return on Financial leveragearrow_forward
- The comparative balance sheets for Metlock Corporation show the following information. December 312020 2019Cash $33,500 $12,900Accounts receivable 12,400 10,000Inventory 12,100 9,000Available-for-sale debt investments –0– 3,000Buildings –0– 29,800Equipment 44,800 19,900Patents 5,000 6,300 $107,800 $90,900Allowance for doubtful accounts $3,100 $4,500Accumulated depreciation—equipment 2,000 4,500Accumulated depreciation—building –0– 6,000Accounts payable 5,000 3,000Dividends payable –0– 4,900Notes payable, short-term (nontrade) 3,000 4,100Long-term notes payable 31,000 25,000Common stock 43,000 33,000Retained earnings 20,700 5,900 $107,800 $90,900 Additional data related to 2020 are as follows. 1. Equipment that had cost $11,000 and was 40% depreciated at time of disposal was sold for $2,500.2. $10,000 of the long-term note payable was paid by issuing common stock.3. Cash dividends paid were $4,900.4. On January…arrow_forwardAdditional information: 2018 current ratio: 1.4:1 debt to total assets: 61.1% Question: find working capital for 2018 Additional information: 2017 current ratio 1.5:1 working capital: 214,500 Question find debt to total assets for 2017arrow_forwardnterpret the results of the debt to equity ratio and how the company has managed debt over the last two years. Balance Sheet 2018 2019 Cash $63,000 $201,000 Accounts Receivable 199,000 305,000 Marketable Securities 81,000 42,000 Inventories 441,000 455,000 Prepaids 5,000 9,000 Total Current Assets 789,000 1,012,000 Property, Plant, and Equipment, net 858,000 858,000 Total Assets $1,647,000 $1,870,000 Account Payable $150,000 $100,000 Accruals 101,000 95,000 Total Current Liabilities $251,000 $195,000 Bonds Payable 405,000 575,000 Total Liabilities 656,000 770,000 Common Stocks 700,000 700,000 Retained Earnings 291,000 400,000 Total Stockholders’ Equity 991,000 1,100,000 Total Liabilities & Equity $1,647,000 $1,870,000 Income Statement…arrow_forward
- Total fixed assets 31420 OMR Total long term liabilities 9970 OMR Total current assets 18930 OMR Total current liabilities 4765 OMR Shareholders’ funds 35615 OMR Capital employed 45585 OMR Gross profit 175000 OMR Net profit 113950 OMR Return on capital employed 25% Current ratio 3.97 Liquid ratio 3.34 Return on Equity 3.191 Gross Profit Margin 53,03% Net Profit Margin 34.53% Q/Give a brief report on the financial position of the company based on the above figures?arrow_forwardFrom the balance sheet prepare a proforma income statement where revenues can increase by 2% and the firm can borrow at 5.5% BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other CA 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciations 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Pro-forma statement Pro Forma Forecasts Actual Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 COGS/REVENUES SGA/SALES INVENTORIES/COGS OTHER CA/SALES AR/SALES AP/COGS SALES/FIXED ASSETS DEPR/ FIXED ASSETS EQUITY/INVESTED CAPITAL ST DEBT/INVESTED…arrow_forwardGeneral Financearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning

Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning