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

Videos

Textbook Question
100%
Book Icon
Chapter 17, Problem 1FSA

Financial statement analysis

The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information (in thousands):

Chapter 17, Problem 1FSA, Financial statement analysis The financial statements for Nike, Inc., are presented in Appendix D at

Instructions

  1. 1. Determine the following measures for the fiscal years ended May 31, 2016, and May 31, 2015. Round ratios and percentages to one decimal place.
    1. a. Working capital
    2. b. Current ratio
    3. c. Quick ratio
    4. d. Accounts receivable turnover
    5. e. Number of days’ sales in receivables
    6. f. Inventory turnover
    7. g. Number of days’ sales in inventory
    8. h. Ratio of liabilities to stockholders’ equity
    9. i. Asset turnover
    10. j. Return on total assets.
    11. k. Return on common stockholders’ equity
    12. l. Price-earnings ratio, assuming that the market price was $54.90 per share on May 29, 2016, and $52.81 per share on May 30, 2015
    13. m. Percentage relationship of net income to sales
  2. 2. What conclusions can be drawn from these analyses?

1.

Expert Solution
Check Mark
To determine

Determine the following ratios for the fiscal years ended May 31, 2016 and May 31, 2015:

  1. (a) Working capital
  2. (b) Current ratio
  3. (c) Quick ratio
  4. (d) Accounts receivable turnover ratio
  5. (e) Number of days’ sales in receivables
  6. (f) Inventory turnover ratio
  7. (g) Number of days’ sales in inventory
  8. (h) Ratio of liabilities to stockholders’ equity
  9. (i) Asset turnover ratio
  10. (j) Return on total assets
  11. (k) Return on common stockholders’ equity
  12. (l) Price-earnings ratio
  13. (m) Percentage relationship of net income  to sales 

Explanation of Solution

Financial Ratios: Financial ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company.

(a)

Working capital is determined as the difference between current assets and current liabilities.

Formula:

Working capital = Current assets – Current liabilities 

Calculate working capital for May 31, 2015 and May 31, 2016.

Working capital  (2016)= Current assets – Current liabilities = $15,025.0 – $5,358.0= $9,667.0

Working capital  (2015)= Current assets – Current liabilities = $15,587.0 – $6,332.0= $9,255.0

Thus, working capital for 2016 and 2015 is $9,667.0 and $9,255.0

b)

Current ratio is used to determine the relationship between current assets and current liabilities. The ideal current ratio is 2:1.  Current assets include cash and cash equivalents, short-term investments, net, accounts and notes receivables, net, inventories, and prepaid expenses and other current assets. Current liabilities include short-term obligations and accounts payable.  

Formula:

Current ratio=Current assetsCurrentliabilities

Current ratio for 2016 and 2015

Current ratio(2016)=Current assetsCurrentliabilities=$15,025.0$5,358.0=2.8

 Current ratio(2015)=Current assetsCurrentliabilities=$15,587.0$63,320=2.5

Thus, current ratio for 2016 and 2015 is 2.8 and 2.5

c)

Acid-Test Ratio is the ratio denotes that this ratio is a more rigorous test of solvency than the current ratio. It is determined by dividing quick assets and current liabilities. The acceptable acid-test ratio is 0.90 to 1.00. Use the following formula to determine the acid-test ratio:

Acid Ratio=Quick assetsCurrentliabilities

Acid-test ratio for 2016

Acid-test ratio (2016)=Quick assets Currentliabilities=$8,698.0$5,358.0=1.6

Acid-test ratio (2015)=Quick assets Currentliabilities=$9,282.0$6,332.0=1.5

Working notes:

Quick Assets are those assets that are most liquid. The examples of quick assets include cash and bank balances, marketable securities, and sundry debtors. Use the following formula to determine the Quick assets:

Quick assets  for 2016=(Cash + Short-term investments + Net accounts and notes receivables)=$3,138.0+$2,319.0+$3,241.0=$8,698.0

Quick assets  for 2015=(Cash + Short-term investments + Net accounts and notes receivables)=$3,852.0+$2,072.0+$3,358.0=$9,282.0

Hence, quick ratio for 2016 and 2015 are 1.6 and 1.5 respectively.

d)

Accounts receivable turnover ratio for 2016 and 2015

Accounts receivables turnover ratio (2016)}=Net credit salesAverage accounts receivables=$32,376.0$3,299.5=9.8

Accounts receivables turnover ratio (2015)}=Net credit salesAverage accounts receivables=$30,601.0$3,237.5=9.5

Description:

Accounts receivables turnover ratio is mainly used to evaluate the collection process efficiency. It helps the company to know the number of times the accounts receivable is collected in a particular time period. Main purpose of accounts receivable turnover ratio is to manage the working capital of the company. This ratio is determined by dividing credit sales and sales return.

Formula:

Accounts receivables turnover ratio}=Net credit salesAverage accounts receivables

Average accounts receivable, net for 2016 and 2015 is determined as follows:

Average accounts receivables (2016)}(Opening accounts receivables + Closing accounts receivables )2=$3,358.0+$3,241.02=$3,299.50

Average accounts receivables (2015)}(Opening accounts receivables + Closing accounts receivables )2=$3,117.0+$3,358.02=$3,237.50

Hence, the accounts receivable turnover ratio for 2016 and 2015 is 9.8 times and 9.5 times.

e)

Number of days’ sales in receivables for 2016 and 2015

 Number of days’ sales in receivable (2016)}=Average accounts receivable Average daily sales=$3,299.5088.7=37.2days

 Number of days’ sales in receivable (2015)}=Average accounts receivable Average daily sales=$3,237.5083.8=38.6days

Description:

Number of days’ sales in receivables is used to determine the number of days a particular company takes to collect accounts receivables.

Formula:

 Number of days’ sales in receivable=Average accounts receivable Average daily sales

Average daily sales are determined by dividing sales by 365 days. Average accounts receivables for 2016 and 2015 are determined in previous requirement. Thus, average daily sales for 2016 and 2015 are determined as follows:

Average daily sales (2016)Sales365days=$32,376.0365days=$88.7

Average daily sales (2015)Sales365days=$30,601.0365days=$83.8

Hence, the number of days’ sales in receivable for 2016 and 2015 are 9.8 days and 9.5 days respectively.

f)

Inventory turnover ratio for 2016 and 2015

Inventory turnover ratio (2016)=Cost of goods soldAverage inventory=$17,405.0$4,587.5=3.8times

Inventory turnover ratio (2015)=Cost of goods soldAverage inventory=$16,534.0$4,142.0=4.0times

Description:

Inventory turnover ratio is used to determine the number of times inventory used or sold during the particular accounting period.

Formula:

Inventory turnover=Cost of goods soldAverage inventory

Average inventory for 2016 and 2015 is determined as below:

 Average inventory (2016)}(Opening inventory + Closing inventory )2=$4,337.0+$4,838.02=$4,587.50

Average inventory (2015)}(Opening inventory + Closing inventory )2=$3,947.0+$4,337.02=$4,142.0

Hence, the inventory turnover ratio for 2016and 2015 is 3.8 and 4.0 respectively.

g)

Number of days sales in inventory for 2016 and 2015 

 Number of days’ sales in inventory (2016)}=Average inventory Average daily cost of goods sold=$4,587.5$47.7=96.2days

 Number of days’ sales in inventory (2015)}=Average inventory Average daily cost of goods sold=$4,142.0$45.3=91.4days

Description:

Number of days’ sales in inventory is determined as the number of days a particular company takes to make sales of the inventory available with them.

Formula:

 Number of days’ sales in invenotry=Average inventory Average daily cost of goods sold

Average daily cost of goods sold are determined by dividing cost of goods sold by 365 days. Thus, average daily cost of goods sold are determined as follows:

Average daily cost of goods sold (2016)Cost of goods sold365days=$17,405.0365days=$47.7

Average daily cost of goods sold (2015)Cost of goods sold365days=$16,534365days=$45.3

Hence, the number of days’ sales in inventory for 2016 and 2015 are 96.2 days and 91.4 days respectively.

h)

Ratio of liabilities to stockholders’ equity for 2016 and 2015.

 Ratio of liabilities to stockholders' equity (2016)}=Total liabilitiesStockholders' equity=$9,138.0$12,258.0=0.7

 Ratio of liabilities to stockholders' equity (2015)}=Total liabilitiesStockholders' equity=$8,890.0$12,707.0=0.7

Description:

Ratio of liabilities to stockholders’ equity is determined by dividing liabilities and stockholders’ equity.

Formula:

 Ratio of liabilities to stockholders' equity=Total liabilitiesStockholders' equity

Hence, the ratio of liabilities to stockholders’ equity for 2016 and 2015 is 0.7.

i)

Asset turnover ratio for 2016 and 2015

Asset turnover (2016) =SalesAverage total assets=$32,376.0$21,496.5=1.5

Asset turnover (2015) =SalesAverage total assets=$300,601.0$20,095.5=1.5

Description:

Asset turnover ratio is used to determine the asset’s efficiency towards sales.

Formula: Asset turnover =NetrevenueAverage total assets

Working notes for average total assets for 2016 and 2015 are as follows:

Average total assets (2016)=Beginning total assets + Ending total assets 2=$21,597.0+$21,396.02=$21,496.5

Average total assets (2015)=Beginning total assets + Ending total assets 2=$18,594.0+$21,597.02=$20,095.5

Hence, asset turnover ratio for 2016 and 2015 is 1.5.

j)

Return on total assets for 2016 and 2015

Rate of return on assets (2016)=Netincome + Interest expenseAverage total assets=$3,760.0+$19.0$21,496.5=17.6%

Rate of return on assets (2015)=Netincome + Interest expenseAverage total assets=$3,273.0+$28.0$20,095.5=16.4%

Description:

Return on assets determines the particular company’s overall earning power. It is determined by dividing sum of net income and interest expense and average total assets.

Formula:

Rate of return on assets=Netincome + Interest expenseAverage total assets

Hence, rate of return on assets for 2016 and 2015 are 17.6% and 16.4% respectively.

k)

Return on common stockholders’ equity for 2016 and 2015

 Return on stockholders' equity(2016)}= Net income Average stockholder’s equity=$3,760.0$12,482.5=30.1%

Return on stockholders' equity(2015)}= Net income Average stockholder’s equity=$32,730.0$12,353.5=26.5%

Description:

Rate of return on stockholders’ equity is used to determine the relationship between the net income and the average common equity that are invested in the company.

Formula: Rate of return on stockholders' equtiy = Net incomeAverage  stockholder’s equity

Average stockholders’ equity is determined as follows:

Average  stockholders' equity (2016)=(Beginning  stockholders' equity  + Ending  stockholders' equity  2)=$12,707.0+$12,258.02=$12,482.5

Net income to sales (2016 ) = Net incomeSales=$3,760.0$32,376.0=11.6%

Hence, rate of return on stockholders’ equity for 2016 and 2015 are 30.1% and 26.5% respectively.

l)

Price earnings ratio for 2016 and 2015

Price earnings ratio (2016)=Market price per shareEarning per share=$54.90$2.21=24.8 times

Price earnings ratio (2015)=Market price per shareEarning per share=$52.81$1.85=28.5 times

Description:

Price/earnings ratio is used to determine the profitability of a company. This ratio is abbreviated as P/E.

Formula:

Price/earnings ratio= Market price per share of common stockEarnings per share

Hence, the calculated price-earnings ratio for 2016 and 2015 is 24.8 and 28.5 respectively.

m)

Net income to sales for 2016 and 2015

Net income to sales (2016 ) = Net incomeSales=$3,760.0$32,376.0=11.6%

Net income to sales (2015) = Net incomeSales=$3,273.0$30,601.0=10.7%

Description:

Net income to sales is determined by dividing net income to sales.

Formula:

Net income to sales = Net incomeSales

Conclusion

Thus, summary table of determined ratios are below:

Particulars20162015
  1. a. Working capital
$9,667.0$9,255.0
  1. b. Current ratio
2.82.5
  1. c. Acid test ratio
1.61.5
  1. d. Accounts receivable turnover ratio
9.89.5
  1. e. Number of days’ sales in receivables
37.2 days38.6 days
  1. f. Inventory turnover ratio
3.8 times4.0 times
  1. g. Number of days sales in inventory
96.2 days91.4 days
  1. h. Ratio of liabilities to stockholders’ equity
0.70.7
  1. i. Asset turnover ratio
1.51.5
  1. j. Return on total assets
17.6%16.4%
  1. k. Return on common stockholders’ equity
30.1%26.5%
  1. l. Price earnings ratio
24.8 times28.5 times
  1. m. Net income to sales
11.6%10.7%

2.

Expert Solution
Check Mark
To determine

Draw conclusion about the analysis made in requirement 1.

Explanation of Solution

  • The working capital ratio has increased in the year 2016 when compared with 2015.
  • The current ratio and quick ratio of the company have increased during the year 2016.
  • The accounts receivable turnover ratio and number of days’ sales in receivables have increased in the year 2016. But, whereas, number of days’ sales receivables have decreased slightly.  Thus, here, company takes over one month to collect the accounts receivables from credit sales. 
  • Inventory turnover ratio and number of days’ sales in inventory is increased and it is critical for the company. Thus, it shows a favorable change.
  • Creditor’s protection remained constant and thus, it is very sound from the ratio of liabilities to stockholders’ equity.
  • Asset turnover ratio indicates assets were used effectively towards generation of revenues for both the years.
  • Return on total assets has increased during the year 2016. Net income has increased.
  • Return on common stockholders’ equity has increased and it has strong earnings performance in the year 2016.
  • The price-earnings ratio has decreased in the year 2016.
  • The percentage of net income to sales has increased during 2016.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
please provide answer for this general account questions
Need Answer. Sub. General Account
Please given answer not use chart gpt

Chapter 17 Solutions

Financial Accounting

Ch. 17 - Prob. 1PEACh. 17 - Prob. 1PEBCh. 17 - Prob. 2PEACh. 17 - Vertical analysis Income statement information for...Ch. 17 - Prob. 3PEACh. 17 - Prob. 3PEBCh. 17 - Prob. 4PEACh. 17 - Prob. 4PEBCh. 17 - Prob. 5PEACh. 17 - Inventory analysis A company reports the...Ch. 17 - Prob. 6PEACh. 17 - Prob. 6PEBCh. 17 - Times interest earned A company reports the...Ch. 17 - Times interest earned A company reports the...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Prob. 9PEACh. 17 - Prob. 9PEBCh. 17 - Common stockholders' profitability analysis A...Ch. 17 - Common stockholders' profitability analysis A...Ch. 17 - Earnings per share and price-earnings ratio A...Ch. 17 - Earnings per share and price-earnings ratio A...Ch. 17 - Vertical analysis of income statement Revenue and...Ch. 17 - Prob. 2ECh. 17 - Common-sized income statement Revenue and expense...Ch. 17 - Prob. 4ECh. 17 - Prob. 5ECh. 17 - Current position analysis The following data were...Ch. 17 - Prob. 7ECh. 17 - Current position analysis The bond indenture for...Ch. 17 - Accounts receivable analysis The following data...Ch. 17 - Prob. 10ECh. 17 - Inventory analysis The following data were...Ch. 17 - Inventory analysis QT, Inc. and Elppa Computers,...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Prob. 14ECh. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Prob. 16ECh. 17 - Profitability ratios The following selected data...Ch. 17 - Profitability ratios Ralph Lauren Corporation...Ch. 17 - Six measures of solvency or profitability The...Ch. 17 - Five measures of solvency or profitability The...Ch. 17 - Earnings per share, price-earnings ratio, dividend...Ch. 17 - Prob. 22ECh. 17 - Earnings per share, discontinued operations The...Ch. 17 - Prob. 24ECh. 17 - Unusual items Explain whether Colston Company...Ch. 17 - Horizontal analysis of income statement For 20Y2,...Ch. 17 - Prob. 2PACh. 17 - Effect of transactions on current position...Ch. 17 - Measures of liquidity, solvency, and profitability...Ch. 17 - Solvency and profitability trend analysis Addai...Ch. 17 - Prob. 1PBCh. 17 - Prob. 2PBCh. 17 - Effect of transactions on current position...Ch. 17 - Prob. 4PBCh. 17 - Solvency and profitability trend analysis Crosby...Ch. 17 - Financial statement analysis The financial...Ch. 17 - Prob. 1CPCh. 17 - Prob. 3CPCh. 17 - Prob. 4CPCh. 17 - Prob. 5CPCh. 17 - The average liabilities, average stockholders'...
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Text book image
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Text book image
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Text book image
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License