Financial Statement Analysis
The financial statements for Nike, Inc., are presented in Appendix 1£ at the end of the text. The following additional information is available (in thousands):
$ 3,117 | |
Inventories at May 31, 2013 | 3,484 |
Total assets at May 31, 2013 | 17,545 |
Stockholders' equity at May 31, 2013 | 11,081 |
Instructions
- 1. Determine the following measures for the fiscal years ended May 31, 2015, and May 31, 2014. (Round ratios and percentages to one decimal place.)
- A.
Working capital - B.
Current ratio - C. Quick ratio
- D. Accounts receivable turnover
- E. Number of days' sales in receivables
- F. Inventory turnover
- G. Number of days' sales in inventory
- H. Ratio of liabilities to stockholders' equity
- I. Asset turnover
- J. Return on total assets, assuming interest expense is $28 million for the year ending May 31, 2015, and $24 million for the year ending May 31, 2014
- K. Return on common stockholders’ equity
- L. Price–earnings ratio, assuming that the market price was $ 101,67 per share on May 29, 2015, and $76.91 per share on May 30, 2014
- M. Percentage relationship of net income to sales
- 2. What conclusions can be drawn from these analyses?
1(a)
Financial Ratios: Financial ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company.
Explanation of Solution
a. Working capital for 2016 and 2015
Working capital is determined as the difference between current assets and current liabilities.
Formula:
Thus, working capital for 2016 and 2015 is $9,667.0 and $9,255.0
1(b)
The current ratio for the year
Explanation of Solution
Current ratio for 2016 and 2015
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:
Thus, current ratio for 2016 and 2015 is 2.8 and 2.5
1(c)
Acid-test ratio for 2016
Explanation of Solution
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:
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:
Hence, quick ratio for 2016 and 2015 are 1.6 and 1.5 respectively.
1(d)
Accounts receivable turnover ratio for 2016 and 2015
Explanation of Solution
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:
Average accounts receivable, net for 2016 and 2015 is determined as follows:
Hence, the accounts receivable turnover ratio for 2016 and 2015 is 9.8 times and 9.5 times.
1(e)
Number of days’ sales in receivables for 2016 and 2015
Explanation of Solution
Number of days’ sales in receivables is used to determine the number of days a particular company takes to collect accounts receivables.
Formula:
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:
Hence, the number of days’ sales in receivable for 2016 and 2015 are 9.8 days and 9.5 days respectively.
1(f)
Inventory turnover ratio for 2016 and 2015
Explanation of Solution
Inventory turnover ratio is used to determine the number of times inventory used or sold during the particular accounting period.
Formula:
Average inventory for 2016 and 2015 is determined as below:
Hence, the inventory turnover ratio for 2016and 2015 is 3.8 and 4.0 respectively.
1(g)
Number of days sales in inventory for 2016 and 2015
Explanation of Solution
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:
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:
Hence, the number of days’ sales in inventory for 2016 and 2015 are 96.2 days and 91.4 days respectively.
1(h)
Ratio of liabilities to stockholders’ equity for 2016 and 2015
Explanation of Solution
Ratio of liabilities to stockholders’ equity is determined by dividing liabilities and stockholders’ equity.
Formula:
Conclusion:
Hence, the ratio of liabilities to stockholders’ equity for 2016 and 2015 is 0.7.
1(i)
Asset turnover ratio for 2016 and 2015
Explanation of Solution
Asset turnover ratio is used to determine the asset’s efficiency towards sales.
Formula:
Working notes for average total assets for 2016 and 2015 are as follows:
Hence, asset turnover ratio for 2016 and 2015 is 1.5.
1(j)
Return on total assets for 2016 and 2015
Explanation of Solution
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:
Hence, rate of return on assets for 2016 and 2015 are 17.6% and 16.4% respectively.
1(k)
Return on common stockholders’ equity for 2016 and 2015
Explanation of Solution
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:
Average stockholders’ equity is determined as follows:
Hence, rate of return on stockholders’ equity for 2016 and 2015 are 30.1% and 26.5% respectively.
1(l)
Price earnings ratio for 2016 and 2015
Explanation of Solution
Price/earnings ratio is used to determine the profitability of a company. This ratio is abbreviated as P/E.
Formula:
Hence, the calculated price-earnings ratio for 2016 and 2015 is 24.8 and 28.5 respectively.
1(m)
Net income to sales for 2016 and 2015
Explanation of Solution
Net income to sales is determined by dividing net income to sales.
Formula:
Thus, summary table of determined ratios are below:
Particulars | 2016 | 2015 |
|
$9,667.0 | $9,255.0 |
|
2.8 | 2.5 |
|
1.6 | 1.5 |
|
9.8 | 9.5 |
|
37.2 days | 38.6 days |
|
3.8 times | 4.0 times |
|
96.2 days | 91.4 days |
|
0.7 | 0.7 |
|
1.5 | 1.5 |
|
17.6% | 16.4% |
|
30.1% | 26.5% |
|
24.8 times | 28.5 times |
|
11.6% | 10.7% |
2.
To draw: Conclusion about the analysis made
Explanation of Solution
- The working capital ratio have 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 have 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 have decreased in the year 2016.
- The percentage of net income to sales have increased during 2016.
Want to see more full solutions like this?
Chapter 14 Solutions
Corporate Financial Accounting
- Real-world annual report The financial statements for Nike, Inc. (NKE), are presented in Appendix E at the end of the text. The following additional information is available (in thousands): Instructions 1. Determine the following measures for the fiscal years ended May 31, 2017, and May 31, 2016. Round ratios and percentages to one decimal place. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory' h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets, assuming interest expense is 82 million for the year ending May 31. 2017, and 33 million for the year ending May 31, 2016. k. k. Return on common stockholders equity l. Price-eamings ratio, assuming that the market price was 52.81 per share on May 31, 2017, and 54.35 per share on May 31, 2016. m. m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardFinancial 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): Instructions 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. a. Working capital b. Current ratio c. Quick ratio d. Accounts receivable turnover e. Number of days sales in receivables f. Inventory turnover g. Number of days sales in inventory h. Ratio of liabilities to stockholders equity i. Asset turnover j. Return on total assets. k. Return on common stockholders equity 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 m. Percentage relationship of net income to sales 2. What conclusions can be drawn from these analyses?arrow_forwardJuroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: Note: Round answers to two decimal places. 1. Calculate the times-interest-earned ratio. 2. Calculate the debt ratio. 3. Calculate the debt-to-equity ratio.arrow_forward
- The income statement, statement of retained earnings, and balance sheet for Somerville Company are as follows: Includes both state and federal taxes. Brief Exercise 15-20 Calculating the Average Common Stockholders Equity and the Return on Stockholders Equity Refer to the information for Somerville Company on the previous pages. Required: Note: Round answers to four decimal places. 1. Calculate the average common stockholders equity. 2. Calculate the return on stockholders equity.arrow_forward(1) Debt and equity ratios. (2-a) Compute debt-to-equity ratio for the current year and one year ago. (2-b) Based on debt-to-equity ratio, does the company have more or less debt in the current year versus one year ago? (3-a) Times interest earned. (3-b) Based on times interest earned, is the company more or less risky for creditors in the Current Year versus 1 Year Ago? Complete this question by entering your answers in the tabs below. Required 1 Required 2A Required 2B Required 3A Required 3B Compute debt and equity ratio for the current year and one year ago. Current Year: 1 Year Ago: Current Year: 1 Year Ago: Numerator: Numerator: Debt Ratio 1 1 Equity Ratio 1 1 1 1 Required 1 Denominator: Denominator: = = = Required 2A > Debt Ratio Debt ratio % % Equity Ratio Equity ratio % %arrow_forwardAn extract from a computer company's 2021 financial statements follows: Balance sheet As of December 31, 2021 As of December 31, 2020 Total assets 57,699 54,013 Total liabilities 37,682 37,919 Total stockholders' equity 20,017 16,096 What was the company's debt-to- equity ratio for 2021? OA. 2.5 OB. 1.6 O C. 0.9 O D. 1.9arrow_forward
- Exercise 17-7 (Algo) Analyzing liquidity LO P3 (1-a) Compute the current ratio for each of the three years. (1-b) Did the current ratio improve or worsen over the three-year period? (2-a) Compute the acid-test ratio for each of the three years. (2-b) Did the acid-test ratio improve or worsen over the three-year period? Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Compute the current ratio for each of the three years. Current Year: 1 Year Ago: 2 Years Ago: Numerator: 1 1 1 1 1 Current Ratio Denominator:arrow_forwardCould you please help mearrow_forwardRequired information Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable. Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity Current Year 1 Year Ago $ 29,682 52,463 $ 25,647 73,597 93,460 8,096 229,592 $430,392 $ 107,168 81,723 163,500 78,001 $430,392 Exercise 13-7 (Algo) Analyzing liquidity LO P3 Required 1A Required 1B (1-a) Compute the current ratio for each of the three years. (1-b) Did the current ratio improve or worsen over the three-year period? (2-a) Compute the acid-test ratio for each of the three years. (2-b) Did the acid-test ratio improve or worsen over the three-year period? 69,327 7,558 211,998 $ 371,028 Complete this question by entering…arrow_forward
- view Policies Current Attempt in Progress Using these data from the comparative balance sheet of Cullumber Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Amount Percentage Accounts receivable $ 467,400 $ 410,000 Inventory $ 785,400 % $ 660,000 % Total assets $3,197,900 % $2,830,000 % eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answerarrow_forwardComputing Activity Ratios Selected balance sheet and income statement information follows for R.A. Corporation. R.A. Corporation $ millions April 2, 2020 March 28, 2019 Income statement information: Sales $20,967 $22,353 Cost of goods sold 9,654 9,726 Balance sheet information: Accounts receivable, gross 2,313 2,718 Inventory 3,375 3,126 Accounts payable 468 630 Required Compute the following ratios for its fiscal year ended April 2, 2020. Round your answers to two decimal places (for example, enter 20.46 for 20.4555558). a. Accounts receivable turnover Answer b. Average days to collect receivables Answer c. Inventory turnover Answer d. Average days in inventory Answer e. Accounts payable turnover Answer f. Average days payable outstanding Answer g. Cash conversion cycle Answerarrow_forwardAnswer in excel formarrow_forward
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning