Description

You will prepare an Excel spreadsheet that provides various calculations based on financial reports from Nike, Inc.

Instructions

In Excel, using the provided documents; Nike, Inc annual report (10-K) in Appendix C of the textbook, as well as the Notes for Nike 10-K, determine the following measures for the fiscal year ended May 31, 2018.

Liquidity Ratio: Working Capital (Part A)

Solvency Ratio: Ratio of Liabilities to Stockholders Equity (Part H)

Profitability Ratio: Asset Turnover (Part I)

Be sure to show your calculations using formulas inside the cell. Under each calculation, please explain whether the results are favorable or unfavorable and with clear justification.