Nike s Financials accounting homework help

Using Nike INC. obtain the financials for the most recent year period. Based on the company financials:

1. Prepare a Horizontal Analysis for all 3 financial statements.

2. Prepare a Vertical Analysis for the Balance Sheet and Income Statement.

3. Prepare a Ratio Analysis for each of the following:

a. Current Ratio

b. Acid – test ratio

c. Receivable turnover

d. Profit Margin

e. Inventory Turnover

f. Asset turnover

g. Return on Assets

h. Return on Common Stockholders Equity

i. EPS

j. Debt to Total Assets ratio

k. Times Interest Earned

SHOULD BE DONE VIA EXCEL.