ACC202 Financial Statement Report( Information has to be takenfrom the website provided with the current year, My company is NikeNKE)( Link to datahttps://www.sec.gov/cgi-bin/viewer?action=view&cik=320187&accession_number=0000320187-16-000336&xbrl_type=v#) ( A, B C, and D has already been done, need another 8 from therequirements and the questions that follow.)
Go to www.sec.gov . Under the heading âFilings and Formsâ chooseâsearch for company filingsâ. Enter your company name. Find thecompanyâs form 10K Annual Report. Print the balance sheet, incomestatement, statement of cash flows, and statement of stockholdersâequity (Only print these 4 pages. Do not print the entire10K)
Using Excel calculate 12 of the following for the currentyear:
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 prioryear. Compare the change from current year to prior year anddiscuss.
4.)Locate the Notes to the Financial Statements and choose 5 ofthem. Describe them in your own words. I strongly recommend youchoose topics you are familiar with (Depreciation, RevenueRecognition, Accounts Receivable, PP&E, etc)
5.)Which accounting firm performed the audit?
6.)Prepare a vertical analysis of the balance sheet usingExcel.
7.)Prepare a horizontal analysis of the income statement usingExcel.
Submit a paper copy and an email copy (Excel & Worddocuments as attachments).
ACC202 Financial Statement Report( Information has to be takenfrom the website provided with the current year, My company is NikeNKE)( Link to datahttps://www.sec.gov/cgi-bin/viewer?action=view&cik=320187&accession_number=0000320187-16-000336&xbrl_type=v#) ( A, B C, and D has already been done, need another 8 from therequirements and the questions that follow.)
Go to www.sec.gov . Under the heading âFilings and Formsâ chooseâsearch for company filingsâ. Enter your company name. Find thecompanyâs form 10K Annual Report. Print the balance sheet, incomestatement, statement of cash flows, and statement of stockholdersâequity (Only print these 4 pages. Do not print the entire10K)
Using Excel calculate 12 of the following for the currentyear:
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 prioryear. Compare the change from current year to prior year anddiscuss.
4.)Locate the Notes to the Financial Statements and choose 5 ofthem. Describe them in your own words. I strongly recommend youchoose topics you are familiar with (Depreciation, RevenueRecognition, Accounts Receivable, PP&E, etc)
5.)Which accounting firm performed the audit?
6.)Prepare a vertical analysis of the balance sheet usingExcel.
7.)Prepare a horizontal analysis of the income statement usingExcel.
Submit a paper copy and an email copy (Excel & Worddocuments as attachments).