I need help with question 2. I did question 1 wich is the microsoft excel. I just need to do question 2 which ask what would be the conclusion drawn to the analyses. I attached the two problems and the microsoft excel. ### Financial Statement Analysis for Nike, Inc.#### Problem Description:The financial statements for Nike, Inc., are presented in Appendix D at the end of the text. Use the following additional information (in thousands):- **Accounts receivable at May 31, 2014:** $3,117- **Inventories at May 31, 2014:** $4,142- **Total assets at May 31, 2014:** $18,594- **Stockholders’ equity at May 31, 2014:** $12,000#### 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?### Explanation of Analytical Measures:1. **Working Capital:** *Calculation of the difference between current assets and current liabilities.*2. **Current Ratio:** *Measurement of a company's ability to pay short-term obligations, calculated by dividing current assets by current liabilities.*3. **Quick Ratio:** *Assessment of a company's short-term liquidity, calculated by dividing liquid assets (excluding inventories) by current liabilities.*4. **Accounts Receivable Turnover:** *Indication of how frequently a company collects its receivables in a period, calculated as net credit sales divided by average accounts receivable.*5. **Number of Days' Sales in Receivables:** *Determination of the average number of days it takes to collect receivables ### Financial Ratios Analysis#### a. Working Capital**Working capital** is calculated using the formula:\[ \text{Working capital} = \text{Current assets} - \text{Current liabilities} \]| | 2016 | 2015 ||----------------------|-------|-------|| Current assets (a) | 15025 | 15587 || Current liabilities (b) | 5358 | 6332 || Working capital | 9667 | 9255 |#### b. Current Ratio**Current ratio** is calculated using the formula:\[ \text{Current ratio} = \frac{\text{Current assets}}{\text{Current liabilities}} \]| | 2016 | 2015 ||----------------|-------|-------|| Current assets (a) | 15025 | 15587 || Current liabilities (b) | 5358 | 6332 || Current ratio | 2.8 | 2.46 |#### c. Quick Ratio**Quick ratio** is calculated using the formula:\[ \text{Quick ratio} = \frac{\text{Current assets} - \text{Inventories}}{\text{Current liabilities}} \]| | 2016 | 2015 ||----------------|-------|-------|| Current assets (a) | 15025 | 15587 || Inventories (d) | 4838 | 4327 || Current liabilities (c) | 5358 | 6332 || Quick ratio | 1.9 | 1.78 |#### d. Accounts Receivable Turnover Ratio**Accounts receivable turnover ratio** is calculated using the formula:\[ \text{Accounts receivable turnover ratio} = \frac{\text{Sales}}{\text{Average accounts receivable}} \]\[ \text{Average accounts receivable} = \frac{\text{Beg. Acc receivable} + \text{End. Acc. Receivable}}{2} \]| | 2016 | 2015 ||----------------------|-------|-------|| Revenues | 32376 | 30601 || Beg. accounts receivable | 3358 | 3117 || End. accounts receivable |

Ratios are those financial instrument which states the line items in ratio form and it is easily…

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): Accounts receivable at May 31, 2014 $ 3,117 Inventories at May 31, 2014 4,142 Total assets at May 31, 2014 18,594 Stockholders' equity at May 31, 2014 12,000

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): Accounts receivable at May 31, 2014 $ 3,117 Inventories at May 31, 2014 4,142 Total assets at May 31, 2014 18,594 Stockholders' equity at May 31, 2014 12,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

I'm stuck on how to do the excel formulas
The answer 417,974.94 was correct. Can you please help me solve without technology? Formulas used, etc. Thank you!
When should you use Power BI Services?
During the research process, if you are unsure whether or not you've found all the relevant literature, what should you do? A. Google it to see if there is anything else you've missed. B. Call your manager to verify that you've found it all. C. Use the search engine included in the Codification. D. Complain that it's too much work and call it a day.
Hi, Could you please show me how to solve this with formulas? not excel, I should have clarified. Thanks
I uploaded two pictures of the entire excel spreadsheet that I am trying to figure out. All the spots that say "FORMULA" needs solved.