Attached is the update for my worksheet 5

Use the format shown in worksheet 5-Research Summary to prepare a two-page summary of your analysis.This conclusion should summarize your research in a clear and concise manner.As part of this analysis:

1. Indicate whether the overall profitability, efficiency, liquidity, and solvency of the company are strong, average or weak.Briefly explain why you came to this conclusion.
2. Prepare the DuPont Analysis of ROE for your company and its industry.Indicate the primary driver of ROA and ROE for your company.
3. Summarize current events and other items of importance.
4. Indicate whether you would invest in your company, identifying three to five significant points that justify your conclusion.

For my amazon project and please make sure that my worksheet 5 is completed correctly

1- a. Profitability - The Company's profitability is strong. Because Company's income has grown from $ -0.24 M in 2014 to $ 2.37 M in 2016. EPS has gone up from $ -0.52 in 2014to $ 5.32 in 2016. All the income ratios such as return on sales, assets and equity are stronger. b. Efficiency - The Company's efficiency is average. Because Company's efficiency ratios such as accounts receivable turnover is slower, inventory turnover ratio is average and asset turnover ratio is quick. c. Liquidity - The Company's liquidity is weak. Because Company's current ratio is less liquid. d. Solvency - The Company's solvency is strong. Because Company's solvency ratios such as debt ratio, financial leverage and times interest earned has less risk although free cash flow has high risk. 2- DuPont Analysis of ROE - X Asset Equals X Financial Equals ROA Leverage ROE Ratio ROS Turnover Type Profitability Efficiency Solvency NI/Rev Rev/A A/SE Formula Your Company Your Industry 35.09% 1.63 35.20% 15.5 57.20% 76.88% Not 545.60% applicable NI/SE 45.64% Not applicable DuPont analysis of ROE for your company and its industry is already prepared. The primary driver of ROA and ROE of Amazon are as follows - a. The primary driver of ROA is (ROS/mark-up)/Asset Turnover (volume) b. The primary driver of ROE is (ROA (profit)/Financial Leverage (use of debt) 3 - There is no current events and other information of importance. 4- No, I would not invest in Amazon because of the following reasons - a. The return on sales, the return on assets, return on equity are lower as compared to the industry. b. The accounts receivable and inventory turnover ratio are slower as compared to the industry. c. The current ratio is less liquid as compared to the industry. d. The only positive factor about the company as compared to the industry is the solvency ratios are better as compared to the industry i.e. they are less risky. WORKSHEET 1 BALANCE SHEET ANALYSIS Your Company Name here Amazon CONDENSED CLASSIFIED BALANCE SHEET Date 2017-May-24 Most recent year Year ($ in millions) Current Assets 45781 35705 PPE, net 29114 21838 Goodwill and intangibles 3784 3759 Other Assets 4723 3445 TOTAL ASSETS 83402 65444 Current Liabilities 43816 33899 Noncurrent Liabilities 20301 18161 Contributed Capital 16206 12676 Retained Earnings 4916 2545 Treasury stock and other SE -1837 -1837 TOTAL LIABILITIES & SE 83402 65444 Your Company Name here Amazon CONDENSED TREND ANALYSIS BALANCE SHEET Date 2017-May-24 Most recent year Year ($ in millions) Current Assets 46.14% 13.98% PPE, net 71.59% 28.71% Goodwill and intangibles 14.01% 13.26% 152.43% 84.13% TOTAL ASSETS 53.02% 20.07% Current Liabilities 55.99% 20.68% Other Assets Noncurrent Liabilities 29.51% 15.86% Contributed Capital 52.47% 19.26% Retained Earnings 152.23% 30.58% 0.00% 0.00% 53.02% 20.07% Treasury stock and other SE TOTAL LIABILITIES & SE Your Company Name here Amazon CONDENSED COMMON SIZE BALANCE SHEET Date 2017-May-24 Most recent year Year ($ in millions) Current Assets 54.89% 54.56% PPE, net 34.91% 33.37% Goodwill and intangibles 4.54% 5.74% Other Assets 5.66% 5.26% TOTAL ASSETS 100.00% 100.00% Current Liabilities 52.54% 51.80% Noncurrent Liabilities 24.34% 27.75% Contributed Capital 19.43% 19.37% Retained Earnings 5.89% 3.89% -2.20% -2.81% Treasury stock and other SE TOTAL LIABILITIES & SE 100.00% 100.00% Carry all calculations out to 2 decimal places Make sure your formulas are in the cells for this worksheet Year 31327 16967 3319 1871 54505 28089 15675 10629 1949 -1837 54505 Year 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Year 57.48% 31.13% 6.09% 3.43% 100.00% 51.53% 28.76% 19.50% 3.58% -3.37% 100.00% WORKSHEET 2 INCOME STATEMENT ANALYSIS Your Company Name here Amazon CONDENSED MULTISTEP INCOME STATEMENT Date 2017-May-24 Most recent year Year ($ in millions) 2016 135.99 2015 107.00 Cost of Goods Sold 88.27 71.66 Gross Profit 47.72 35.36 Operating Expenses 43.54 33.12 4.19 2.23 -294.00 -665.00 Income before Income tax 3.90 1.57 Provision for Income tax 1.42 0.95 Income from continuing operations 2.37 0.60 Nonrecurring items 0.00 0.00 NET INCOME 2.37 0.60 Earnings per share 5.32 1.25 Sales Revenue Operating Income Nonoperating revenues and expenses Your Company Name here Amazon CONDENSED TREND ANALYSIS INCOME STATEMENT Date 2017-May-24 ($ in millions) Most recent year 2016 Year 2015 Sales Revenue 152.81% 120.24% Cost of Goods Sold 130.29% 105.77% Gross Profit 181.86% 134.76% Operating Expenses 167.08% 127.09% 2327.78% 1238.89% 101.73% 230.10% -3545.45% -1427.27% Operating Income Nonoperating revenues and expenses Income before Income tax Provision for Income tax Income from continuing operations Nonrecurring items NET INCOME Earnings per share 835.29% 558.82% -987.50% -250.00% #DIV/0! #DIV/0! -987.50% -250.00% -1023.08% -240.38% Your Company Name here AMAZON CONDENSED COMMON SIZE INCOME STATEMENT Date 2017-May-24 Year ($ in millions) Most recent year 2016 Sales Revenue 100.00% 100.00% 2015 Cost of Goods Sold 64.91% 66.97% Gross Profit 35.09% 33.05% Operating Expenses 32.02% 30.95% 3.08% 2.08% -216.19% -621.50% Income before Income tax 2.87% 1.47% Provision for Income tax 1.04% 0.89% Income from continuing operations 1.74% 0.56% Nonrecurring items 0.00% 0.00% NET INCOME 1.74% 0.56% Earnings per share 3.91% 1.17% Operating Income Nonoperating revenues and expenses Carry all calculations out to 2 decimal places Make sure your formulas are in the cells for this worksheet Year 2014 88.99 67.75 26.24 26.06 0.18 -289.00 -0.11 0.17 -0.24 0.00 -0.24 -0.52 NT Year 2014 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Year 2014 100.00% 76.13% 29.49% 29.28% 0.20% -324.76% -0.12% 0.19% -0.27% 0.00% -0.27% -0.58% WORKSHEET 3 STATEMENT OF CASH FLOW ANALYSIS Your Company Name here Amazon CONDENSED STATEMENT OF CASH FLOWS Date 2017-May-24 Most recent year Year ($ in millions) End 2016 2015 Net Cash from operating activities 16,443,000.00 11,920,000.00 Net Cash from investing activities -9,876,000.00 -6,450,000.00 Net Cash from financing activities -2,911,000.00 -3,763,000.00 -212,000.00 -374,000.00 3,444,000.00 1,333,000.00 Cash, beginning 15,890,000.00 14,557,000.00 Cash, ending 19,334,000.00 15,890,000.00 Effect of exchange rate on cash Net change in cash Your Company Name here Amazon CONDENSED TREND ANALYSIS STATEMENT OF CASH FLOW Date 2017-May-24 Most recent year Year ($ in millions) Net Cash from operating activities Net Cash from investing activities Net Cash from financing activities Effect of exchange rate on cash Net change in cash 2016 240.32% 194.99% -65.68% 68.39% 58.38% 2015 174.22% -127.34% -84.91% 120.65% 22.60% Your Company Name here Amazon CONDENSED COMMON SIZE STATEMENT OF CASH FLOWS Date 2017-May-24 Most recent year Year ($ in millions) 2016 2015 Net Cash from operating activities Net Cash from investing activities Net Cash from financing activities Effect of exchange rate on cash Net change in cash 100.00% -60.06% -17.70% -1.29% 20.95% 100.00% -54.11% -31.57% -3.14% 11.18% Carry all calculations out to 2 decimal places Make sure your formulas are in the cells for this worksheet Year 2014 6,842,000.00 -5,065,000.00 4,432,000.00 -310,000.00 5,899,000.00 8,658,000.00 14,557,000.00 OF CASH FLOW Year 2014 100.00% 100.00% 100.00% 100.00% 100.00% OWS Year 2014 100.00% -74.03% 64.78% -4.53% 86.22% WORKSHEET 4: RATIO ANALYSIS Industry Ratios Title of Ratio Average Change Profitability Ratios Return on Sales (ROS) 6.51% Stronger Return on Assets (ROA) 18.10% Stronger Return on Equity (ROE) 35.10% Stronger Gross profit margin 35.20% Stronger Efficiency Ratios Accounts receivable turnover Inventory turnover 91.25 Slower NA Asset turnover Slower/Quicker 13.50 Quicker Liquidity Ratios Current Ratio 2.03 Less Liquid Solvency Ratios Debt Ratio Less Risk Financial Leverage Less Risk Times interest earned Free cash flow ($ in millions) Additional Data Needed for part E of paper Capital expenditures Dividends paid http://www.nasdaq.com/symbol/amzn/financials?query=cash-flow 4.68 Less Risk More Risk Company Ratios Current Year Prior Year 12/31/2016 12/31/2015 1.74% 0.56% net income/sales 2.84% 0.92% net income/average total assets 12.29% 4.45% net income/average total equity 35.09% 33.04% gross profit/sales -40.39 NA -60.97 NA They don't have inventory 1.63 1.65 Assets/Sales 1.04 1.05 76.88% 79.33% 4.32 4.84 8.65 4.86 $9,706,000.00 $7,331,000.00 ($6,737,000) ($4,589,000) 0 0 WORKSHEET 5: RESEARCH SUMMARY You are answering these questions here solely to organiz conclusions into your research paper. Company Name Amazon Industry Name 1. FINANCIAL ANALYSIS of your company: Profitability Explain Efficiency Explain Liquidity Explain Solvency Explain The Company's profitability is strong. Because - Company's income has grown from $ -0.24 M in 2014 to $ 2.37 M in 2016. EP 2016. All the income ratios such as return on sales, assets and equity are stro The Company's efficiency is average. Because - Company's efficiency ratios such as accounts receivable turnover is slower, inv turnover ratio is quick. The Company's liquidity is weak. Because The Company's current ratio is less liquid. The Company's solvency is strong. Because - Company's solvency ratios such as debt ratio, financial leverage and times inte flow has high risk. 2, DuPont Analysis of ROE X Asset Equals X Financial ROA Leverage Ratio ROS Turnover Type Profitability Efficiency Solvency NI/Rev Rev/A A/SE Formula Your Company 35.09% 1.63 Your Industry 35.20% 15.5 57.20% 76.88% 545.60% not apllicable Multiply ROS x Asset Turnover to get ROA Multiply ROA x Financial Leverage to get ROE For your company, the primary driver of ROA is (ROS/mark-up)/Asset Turnover (volume) For your company, the primary driver of ROE is (ROA (profit)/Financial Leverage (use of debt) 3. SIGNIFICANT (current events and other information of importance). 4. INVESTMENT DECISION Your Company: Why? 1 Invest by invest one can increase revenue make a profit 2 invest by invest one can increase revenue make a profit 3 Not invest their will be no growth 4 invest by invest one can increase revenue make a profit 5 ere solely to organize your thoughts before inputting these State whether your company is Strong/Average/Weak $ 2.37 M in 2016. EPS has gone up from $ -0.52 in 2014to $ 5.32 in ts and equity are stronger. State whether your company is Strong/Average/Weak turnover is slower, inventory turnover ratio is average and asset State whether your company is Strong/Average/Weak State whether your company is Strong/Average/Weak everage and times interest earned has less risk although free cash Equals ROE NI/SE 45.64% notapplicabale nover (volume) verage (use of debt) * state the Word "invest" or "not invest" is Strong/Average/Weak is Strong/Average/Weak is Strong/Average/Weak is Strong/Average/Weak WRITTEN REPORT-GRADING RUBRIC Student Name Student Name Student Name Student Name Student Name Company Name Industry Name ITEM Submitted your worksheets at 2nd class meeting for checking by instructor Part A-Description of company, products, industry, market1-3 pages Part B-News-2 major events of last year 1-2 pages Part C-Stock market activity-10 years 1-2 pages Part D-Statement analysis-trend, condensed, commonsiz 4 pages Analysis of worksheet 1-Balance Sheet Analysis of worksheet 2-Income Statement Analysis of worksheet 3-Cash Flow Statement Summary Analysis of the 3 Compare company to industry averages Part E-Ratio analysis-profitability, liquidity, solvency, efficiency Overall analysis 5 Capital Expenditures 5 Dividends Paid 5 Return on sales 5 Return on assets 5 Return on equity 5 Gross profit margin 5 Accounts Receivable Turnover 5 Inventory Turnover 5 Asset Turnover 5 Current Ratio 5 Debt Ratio 5 Financial Leverage 5 Times Interest Earned 5 Free Cash Flow 5 Part F-Research summary-invest or not 2 pages Organization, grammar, spelling, punctuation, references Power Point Total POSSIBLE EARNED POINTS POINTS 50 ORGANIZATION This is the order your pap Failure to submit these by the end of class at our second meeting m 10 Title Page 10 Part A Company Description 10 Part B Company News Part C Stock Market Activity 20 Part D Financial Statement Analysis 20 Part E Ratio Analysis 20 Part F Industry Analysis 10 References 75 40 10 25 300 This is the order your paper should appear in: s at our second meeting means you lose these points permanently. You CANNOT submit them late. atement Analysis corresponds to worksheets 1, 2, 3 corresponds to worksheet 4 corresponds to worksheet 5 them late. Purpose: Prepare and deliver a presentation titled "Would you advise a friend to invest in this company?' that is based upon research, analysis, and sound reasoning. Prepare Power Point slides as a visual aid using at least 2 graphs. Prepare and deliver a presentation titled, "Would you advise a friend to invest in this company?" based upon your research and analysis of th company's financial information. Include: Use the Research Summary to help organize your presentation Convince your peers to invest or not invest in your company. Present the highlights of your research, not a broad summary. Focus on the financial information and key ratios. The presentation should have a strong opening and closing. Make your presentation interesting. Please be supportive by viewing others' presentations and commenting in the discussion forum for week eight. Use Power Point slides as your visual aid, including at least 2 graphs Remember that Power Point slides are visual aids. A rule of thumb is no more than 7 items across and 7 items down. Slides should contain bullet points, not sentences or paragraphs. hat is based upon esearch and analysis of this