(50 pts) Using Excel, construct financial ratios to determine the firms liquidity, asset management, debt management, profitability, and market value. Analyze the ratios of the firm over a three-year horizon and compare them with that of the industry for the most current year available. Use the ratios discussed in chapter 4 of the textbook. You are to interpret the ratios to describe, in words, the state of the firm relative to the five areas of performance identified above. The analysis above is the critical component of this assignment. (25 pts) What is the firm's bond rating? How does this rating relate to the performance of your firms debt management in problem 1 above? In your opinion, do the numbers justify the ratings of the rating firm? Why or why not? (15 pts) Read the annual report and the information available on FINRA and discuss the various financial and business risks faced by investors. (10 pts) Attach the financial statements used as an appendix. (A hyperlink is sufficient)

Firm: Nike Inc 2022