FS 2 working capital, current ratio, quick ratio
docx
keyboard_arrow_up
School
University of Illinois, Urbana Champaign *
*We aren’t endorsed by this school
Course
321
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
3
Uploaded by GeneralOtterPerson1482
Ratio analysis 2
(15 points)
Name: Shawna Ye
These are the three formulas you will use for the second financial statement analysis. You will use the NIKE financial statement located in appendix C. The information required for this ratio analysis is all found on the consolidated balance sheets. You will use the information from both years 5/31/18 and 5/31/17. Round the
ratios to the nearest tenth
Working capital: Current Assets – Current Liabilities
5/31/18 ratio: Current Assets: $15,134
Current Liabilities: $6,040
Working capital = $15,134 - $6,040 = $9,094
5/31/17 ratio: Current Assets: $16,061
Current Liabilities: $5,474
Working capital = $16,061 - $5,474 = $10,587
Current ratio = Current Assets / Current liabilities (Round to the nearest tenth)
5/31/18 ratio:
Current Assets: $15,134
Current Liabilities: $6,040
Current ratio = $15,134 / $6,040
= 2.5
5/31/17 ratio:
Current Assets: $16,061
Current Liabilities: $5,474
Current ratio = $16,061 / $5,474
= 2.9
Quick Ratio = Quick assets / current liabilities (Round to the nearest tenth) Note: the quick assets only include those current assets easily converted to cash, so
inventories and prepaid expenses will not be included. 5/31/18 ratio:
Quick Assets: $15,134 (total current assets) - $5,261 (inventories) - $1,130 (prepaid expenses and other current assets)
= $8,743 (Quick assets)
Current Liabilities: $6,040
Quick Ratio = $8,743 / $6,040
= 1.4
5/31/17 ratio: Quick Assets: $16,061 (total current assets) - $5,055 (inventories) - $1,150 (prepaid expenses and other current assets)
= $9,856 (Quick assets)
Current Liabilities: $5,474
Quick Ratio = $9,856 / $5,474
= 1.8
These ratios measure a company’s ability to pay its current liabilities. Ideally the current ratio should be 2 or above and the quick ratio should be 1 or above. Calculate the three ratios and comment on Nikes ability to pay its current liabilities. Nike’s current ratio for both 2017 and 2018 is well above 2.0 at 2.9 and 2.5, respectively. This means that while Nike’s more than capable of paying back their debt in both 2017 and 2018, their ability to cover their liabilities decreased from 2017
to 2018. Similarly, the trend is the same for Nike’s quick ratio, where their ratios are well above the ideal (1.0) but decreases from 2017 to 2018. Lastly, not only has Nike’s abilities to pay off their current liabilities decreased over time, but their working capital has also decreased. This means that they have incurred more liabilities compared to their assets over the year.
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
Required:
Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should
be entered as 12.34).)
1. Gross margin percentage.
2. Net profit margin percentage.
3. Return on total assets.
4. Return on equity.
5. Was financial leverage positive or negative for the year?
1. Gross margin percentage
%
2. Net profit margin percentage
%
3. Return on total assets
%
4. Return on equity
%
5. Financial Leverage
arrow_forward
Please correct Solution with Explanation and do not give image format
arrow_forward
5. Know the calculations for all of the following ratios (see ratio sheet that can be used on the
exam) and know the category (listed in Question 4) they fall in:
Formula
Category/Use
Ratio
Working Capital
Current Assets - Current
Liabilities
Net credit sales/Average
Accounts Receivable
Turnover
accounts receivable
Asset Turnover
Net sales/Average total
assets
Net income/Average total
stockholders' equity
Total liabilities/Total
stockholders equity
Net income/Net sales
Return on Equity (ROE)
Debt to equity
Return on Sales (ROS) (also
known as Net Margin
Current Assets/Current
Liabilities
Cost of goods sold/Average
inventory
Quick assets/Current
Current Ratio
Inventory Turnover
Quick Ratio
liabilities
Dividend Yield
Dividends per share/Market
price per share
Net earnings available for
common stock/Number of
outstanding common shares
Net income/Average total
Earnings per Share (EPS)
Return on Investment (ROI)
assets
Price Earnings Ratio (P/E)
Market price per
share/Earnings per share…
arrow_forward
dont uplode any image in answer
arrow_forward
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
arrow_forward
STEP 3: Solve
Calculating the four benchmark financial ratios found in Table 15.3, we get the following:
Ratio with
Ratio
Existing Common Stock with Debt
Financing
Ratio
Formula
Ratio
Financing
Debt ratio
Total Liabilities
35.2%
26.4%
51.5%
Total Assets
Interest-bearing
Interest-Bearing Debt
20.1
15.1
40.2
debt ratio
Total Assets
Times interest
Net Operating Income or EBIT
27.08
31.25
11.72
earned
Interest Expense
Depreciation Amortization
6.84
8.20
3.08
EBITDA
Earnings Before
coverage ratio
Interest and Taxes
Expense
Expense
Principal Payments
Interest Expense + (-
1
Tax Rate
STEP 4: Analyze
Whether the entire $10 million is raised by issuing equity or by borrowing has a dramatic effect on the firm's
capital structure. For example, the debt ratio will either drop from 35.2 percent to 26.4 percent if equity is used or
increase to 51.5 percent if debt is used. The interest-bearing debt ratio will change in a similar manner, dropping
from 20.1 percent to 15.1 percent if equity financing…
arrow_forward
Use for financial statements for Yellow Hammer to answer problems 1-3
1. Assess Yellow Hammer's income statement by calculating the sales growth,
EBITDA profitability (EBITDA/Sales) and coverage ratios using EBIT and EBITDA
for each year.
2. Assess Yellow Hammer's balance sheet by calculating the leverage ratios using of
Debt/Capitalization and Debt/EBITDA.
3. Using the table below and the ratios that you've calculated, insert the EBIT
interest coverage, EBITDA interest coverage, Debt/EBITDA and Debt to
Capitalization and then provide an assessment of Yellow Hammer's credit
quality.
Oper. income (bef. D&A)/revenues (%)
Return on capital (%)
EBIT interest coverage (x)
EBITDA interest coverage (x)
FFO/debt (%)
Free oper. cash flow/debt (%)
Disc. cash flow/debt (%)
Debt/EBITDA (x)
Debt/debt plus equity (%)
AA
32.1
19.7
13.1
17.9
72.3
43.9
18.3
1.0
21.0
A
19.1
16.8
8.1
11.6
53.0
28.4
10.6
1.4
32.1
BBB
17.1
12.0
4.5
7.1
34.5
15.5
6.9
2.1
42.2
BB
20.4
9.5
3.0
4.9
24.0
9.0
3.9
2.9
47.4
B
15.3…
arrow_forward
compute the following ratios using the Balance Sheet (Current Year) and Income Statement provided in the images below
Current Ratio (in numeric format, 2 decimal places):
Debt to Equity (in numeric format, 2 decimal places():
Return on Equity (stated as a percentage, 2 decimal places):
Return on Assets (stated as a percentage, 2 decimal places):
arrow_forward
Consider this simplified balance sheet for Geomorph Trading:
Current assets
Long-term assets
$ 245 Current liabilities
Long-term debt
630
Other liabilities
Equity
$ 875
Required:
a. What is the company's debt-equity ratio? (Hint: debt = Current liabilities, Long-term debt, and Other liabilities)
Note: Round your answer to 2 decimal places.
b. What is the ratio of total long-term debt to total long-term capital?
Note: Round your answer to 2 decimal places.
c. What is its net working capital?
d. What is its current ratio?
Note: Round your answer to 2 decimal places.
$ 170
215
140
350
$ 875
a Debt-equity ratio
b. Long-term debt-to-capital ratio
c. Net working capital
d. Current ratio
arrow_forward
Please try to answer handwritten i will rate you for sure
arrow_forward
Do npt give image format
arrow_forward
Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3.
Complete this question by entering your answers in the tabs below.
Analysis Analysis
Bal Sheet Inc Stmt
Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not
add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be
entered as 23.45).)
Assets
Current assets
Cash
Marketable securities
Accounts receivable (net)
Inventories
Prepaid items
Total current assets
Investments
RUNDLE COMPANY
Vertical Analysis of Balance Sheets
Year 4
Plant (net)
Land
Total long-term assets
Total assets
Liabilities and stockholders' equity
Liabilities
Current liabilities
Notes payable
Accounts payable
Salaries payable
Total current liabilities.
Noncurrent liabilities
Bonds payable
Other
Total noncurrent liabilities
Total liabilities
Stockholders' equity
Preferred stock (par value $10, 4%
cumulative, nonparticipating; 7,200
shares authorized…
arrow_forward
Margaret O'Flaherty, a portfolio manager for MCF Investments, is considering investing in Alpine Chemical 7% bonds, which mature in
10 years. She asks you to analyze the company to determine the riskiness of the bonds.
Alpine Chemical Company Financial Statements
Years Ended December 31,
($ in millions)
20X1
20X2
20X3
20X4
20X5
20X6
Assets
Cash
$ 55
$
1,637
2,021
190
$
2,143
1,293
157
249
$
1,394
1,258
3,493
1,322
Accounts receivable
3,451
1,643
2,087
Inventories
945
Other current assets
17
27
55
393
33
171
5,097
6,181
Current assets
3,114
5,038
2,543
2,495
3,986
5,757
3,138
3,865
2,707
5,619
2,841
2,778
5,265
4,650
2,177
2,473
Gross fixed assets
7,187
3,893
3,465
2,716
Less: Accumulated depreciation
Net fixed assets
2,619
3,294
Total assets
$6,338
$5,609
$5,485
$6,605
$7,813
$8,559
Liabilities and net worth
Notes payable
Accounts payable
$1,300
338
$
525
2$
750
$1,750
$1,900
673
638
681
743
978
Accrued liabilities
303
172
359
359
483
761
Current liabilities
1,501
1,985
1,997
1,457…
arrow_forward
Please help me
arrow_forward
Calculate the following five ratios for each of the two years:(i) Return on capital employed(ii) Net profit margin(iii) Current ratio(iv) Average Receivable days/ Debtors collection period(v) Average Payable days/ Creditors collection period
arrow_forward
The image uploaded is the calculation of Socite Generale Bank, Ghana, Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.
arrow_forward
Balance Sheet. Use Table 3.2 on page 82 as a guide to create a monthly balance sheet
arrow_forward
Trend Analysis
Critelli Company has provided the following comparative information:
Year 5
Year 4
Year 3
Year 2
Year 1
Net income
$1,352,800
$1,166,200
$980,000
$837,600
$709,800
Interest expense
460,000
419,800
362,600
276,400
220,000
Income tax expense
432,896
326,536
274,400
217,776
170,352
Average total assets
9,960,440
8,811,111
7,542,697
6,439,306
5,501,775
Average stockholders' equity
3,340,247
3,013,437
2,655,827
2,372,805
2,093,805
You have been asked to evaluate the historical performance of the company over the last five years.
Selected industry ratios have remained relatively steady at the following levels for the last five years:
Industry Ratios
Return on total assets
17.9 %
Return on stockholders' equity
37.3 %
Times interest earned
4.6
arrow_forward
Based on the following financial data, calculate the ratios requested. (Round your answers to 4 decimal places.)
Liabilities
Liquid assets
Monthly credit payments
Monthly savings
$11,600 Net worth
$ 9,500 Current liabilities
$ 750 Take-hone pay
$ 190 Gross income
$ 71,800
$ 1,575
$ 2,375
$ 3,600
a Debt ratio
b. Current ratio
c Debt-payments ratio
d. Savings ratio
arrow_forward
Fill out income statement please and thank you
arrow_forward
Calculate the following ratios using the information below:
Note: Round decimal places to the nearest hundredths
1. Working capital
2. Current ratio
3. Debt-to-equity ratio
Cash 182,250
Accounts Receivable 7,500
Supplies 1,000
Vehicles 300,000
A. Capital 450,000
Accounts Payable 13,500
Salaries payable 27,250
arrow_forward
Need help on part (A)
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Related Questions
- Required: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leveragearrow_forwardPlease correct Solution with Explanation and do not give image formatarrow_forward5. Know the calculations for all of the following ratios (see ratio sheet that can be used on the exam) and know the category (listed in Question 4) they fall in: Formula Category/Use Ratio Working Capital Current Assets - Current Liabilities Net credit sales/Average Accounts Receivable Turnover accounts receivable Asset Turnover Net sales/Average total assets Net income/Average total stockholders' equity Total liabilities/Total stockholders equity Net income/Net sales Return on Equity (ROE) Debt to equity Return on Sales (ROS) (also known as Net Margin Current Assets/Current Liabilities Cost of goods sold/Average inventory Quick assets/Current Current Ratio Inventory Turnover Quick Ratio liabilities Dividend Yield Dividends per share/Market price per share Net earnings available for common stock/Number of outstanding common shares Net income/Average total Earnings per Share (EPS) Return on Investment (ROI) assets Price Earnings Ratio (P/E) Market price per share/Earnings per share…arrow_forward
- dont uplode any image in answerarrow_forwardplease answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)arrow_forwardSTEP 3: Solve Calculating the four benchmark financial ratios found in Table 15.3, we get the following: Ratio with Ratio Existing Common Stock with Debt Financing Ratio Formula Ratio Financing Debt ratio Total Liabilities 35.2% 26.4% 51.5% Total Assets Interest-bearing Interest-Bearing Debt 20.1 15.1 40.2 debt ratio Total Assets Times interest Net Operating Income or EBIT 27.08 31.25 11.72 earned Interest Expense Depreciation Amortization 6.84 8.20 3.08 EBITDA Earnings Before coverage ratio Interest and Taxes Expense Expense Principal Payments Interest Expense + (- 1 Tax Rate STEP 4: Analyze Whether the entire $10 million is raised by issuing equity or by borrowing has a dramatic effect on the firm's capital structure. For example, the debt ratio will either drop from 35.2 percent to 26.4 percent if equity is used or increase to 51.5 percent if debt is used. The interest-bearing debt ratio will change in a similar manner, dropping from 20.1 percent to 15.1 percent if equity financing…arrow_forward
- Use for financial statements for Yellow Hammer to answer problems 1-3 1. Assess Yellow Hammer's income statement by calculating the sales growth, EBITDA profitability (EBITDA/Sales) and coverage ratios using EBIT and EBITDA for each year. 2. Assess Yellow Hammer's balance sheet by calculating the leverage ratios using of Debt/Capitalization and Debt/EBITDA. 3. Using the table below and the ratios that you've calculated, insert the EBIT interest coverage, EBITDA interest coverage, Debt/EBITDA and Debt to Capitalization and then provide an assessment of Yellow Hammer's credit quality. Oper. income (bef. D&A)/revenues (%) Return on capital (%) EBIT interest coverage (x) EBITDA interest coverage (x) FFO/debt (%) Free oper. cash flow/debt (%) Disc. cash flow/debt (%) Debt/EBITDA (x) Debt/debt plus equity (%) AA 32.1 19.7 13.1 17.9 72.3 43.9 18.3 1.0 21.0 A 19.1 16.8 8.1 11.6 53.0 28.4 10.6 1.4 32.1 BBB 17.1 12.0 4.5 7.1 34.5 15.5 6.9 2.1 42.2 BB 20.4 9.5 3.0 4.9 24.0 9.0 3.9 2.9 47.4 B 15.3…arrow_forwardcompute the following ratios using the Balance Sheet (Current Year) and Income Statement provided in the images below Current Ratio (in numeric format, 2 decimal places): Debt to Equity (in numeric format, 2 decimal places(): Return on Equity (stated as a percentage, 2 decimal places): Return on Assets (stated as a percentage, 2 decimal places):arrow_forwardConsider this simplified balance sheet for Geomorph Trading: Current assets Long-term assets $ 245 Current liabilities Long-term debt 630 Other liabilities Equity $ 875 Required: a. What is the company's debt-equity ratio? (Hint: debt = Current liabilities, Long-term debt, and Other liabilities) Note: Round your answer to 2 decimal places. b. What is the ratio of total long-term debt to total long-term capital? Note: Round your answer to 2 decimal places. c. What is its net working capital? d. What is its current ratio? Note: Round your answer to 2 decimal places. $ 170 215 140 350 $ 875 a Debt-equity ratio b. Long-term debt-to-capital ratio c. Net working capital d. Current ratioarrow_forward
- Please try to answer handwritten i will rate you for surearrow_forwardDo npt give image formatarrow_forwardPrepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Analysis Bal Sheet Inc Stmt Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) Assets Current assets Cash Marketable securities Accounts receivable (net) Inventories Prepaid items Total current assets Investments RUNDLE COMPANY Vertical Analysis of Balance Sheets Year 4 Plant (net) Land Total long-term assets Total assets Liabilities and stockholders' equity Liabilities Current liabilities Notes payable Accounts payable Salaries payable Total current liabilities. Noncurrent liabilities Bonds payable Other Total noncurrent liabilities Total liabilities Stockholders' equity Preferred stock (par value $10, 4% cumulative, nonparticipating; 7,200 shares authorized…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,