Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete the excel table to show Nikes Project projection in the same way Amazon was done in the example. Must show formulas. Format: Annual Search
Complete the excel table to show Nikes Project projection in the same way Amazon was done in the example. Must show formulas.
Format: Annual Search for ticker or company r Annual Data | Millions of US $ except per share data 2020-05-31 2019-05-31 2018- E E E E $8,787 $2,749 $7,367 $4,663 $4,272 $5,622 $1,968 $1,653 $20,556 $4,866 $16,525 $4,744 $497 $437 $7,192 Cash On Hand Receivables Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, Plant, And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity E E E E $10,786 $31,342 $8,284 $9,406 $23,717 $7,866 $3,464 E E E E E $15,003 $23,287 $3 $6,811 $14,677 $3 $-191 $1,643 $231 $-56 $8,055 $31,342 $9,040 $23,717 J.LI Annual Data Millions of US $ except per share data 2020-05-31 2019-05-31 E E E $37,403 $21,162 $16,241 $39,117 $21,643 $17,474 1.U. $13,126 $12,702 $34,288 $3,115 $-228 $34,345 $4,772 $29 Revenue Cost Of Goods Sold Gross Profit Research And Development Expenses SG&A Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense Pre-Tax Income Income Taxes Income After Taxes Other Income Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS - Earnings Per Share EEEEEE $2,887 $348 $2,539 $4,801 $772 $4,029 $2,539 $4,029 E E E IIII $2,539 $4,234 $3,115 1,559 1,592 $1.63 $4,029 $5,492 $4,772 1,580 1,618 $2.55 ...l $1.60 $2.49 Accounting Project Calculations: Nike 2020 Liquidity Ratios 2019 Current ratio Accounts receivable Average collection period Solvency Ratios Debit to asset ratio Times interest earned Debt to equity ratio Profitability Ratios Return on asset ratio Profit margin Asset turnover Return on equity ratio Accounting Project Calculations: Amazon 2019 Liquidity Ratios 2018 It decreased; This shows that the company cannot pay its short term Current ratio 1.097048239 1.098112325 Accounts receivable 14.96396661 12.42295895 It increased; This shows that the company's collection of accounts receivable is frequent and efficient. It decreased; This shows a strength in which customers take less time Average collection period 24.39839572 29.38808374 Solvency Ratios It decreased; This is a strength because it shows the company is not as risky to invest in and provide loans. Debit to asset ratio 0.72448146 0.732250012 Times interest earned 9.72625 8.953422724 It increased; This shows their ability to meet interest payments as they are due Debt to equity ratio 2.62951982 2.734827436 It decreased; This shows that they may not be able to easily service their debt obligations. Profitability Ratios Return on asset ratio 0.059747974 Profit margin It increased; It shows they have profitability of assets in terms of 0.051936602 the income earned on each dollar invested in assets. 0.043252736 It decreased; This shows how net income generated by each dollar of sales went down which is a weakness. 1.20077031 It increased; This shows how efficient their current and fixed 0.041308703 Asset turnover 1.44637738 Return on equity ratio 0.186722527 0.231302671 It decreased; This shows that the company is less risky which is aStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started