ACC202 Financial Statement Report( Information has to be taken from the website provided with the current year, My company is Nike NKE)( Link to data https://www.sec.gov/cgi-bin/viewer?action=view&cik=320187&accession_number=0000320187-16-000336&xbrl_type=v# ) ( Questions up to 3 are done, but if it can be redone to check answer it would be great. But mostly what i need is quesions from 4 and on)

Go to www.sec.gov . Under the heading Filings and Forms choose search for company filings. Enter your company name. Find the companys form 10K Annual Report. Print the balance sheet, income statement, statement of cash flows, and statement of stockholders equity (Only print these 4 pages. Do not print the entire 10K)

Using Excel calculate 12 of the following for the current year:

a.)Earnings Per Share

b.)Working Capital

c.)Current Ratio

d.)Quick Ratio

e.)Receivables Turnover

f.)Days in Receivable

g.)Inventory Turnover

h.)Days in Inventory

i.)Profit Margin Ratio

j.)Gross Profit Ratio

k.)Return on assets

l.)Return on common stockholders equity

m.)Price-earnings Ratio

n.)Payout Ratio

o.)Debt to total assets

p.)Times interest earned

q.)Free Cash Flow

3.) Choose 3 from the above list and calculate for the prior year. Compare the change from current year to prior year and discuss.

4.)Locate the Notes to the Financial Statements and choose 5 of them. Describe them in your own words. I strongly recommend you choose topics you are familiar with (Depreciation, Revenue Recognition, Accounts Receivable, PP&E, etc)

5.)Which accounting firm performed the audit?

6.)Prepare a vertical analysis of the balance sheet using Excel.

7.)Prepare a horizontal analysis of the income statement using Excel.

Submit a paper copy and an email copy (Excel & Word documents as attachments).