Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

create Income Statement for 3 years (end your report at line net income from continuing & discontinuing operation) create Balance Sheet for 3 years visit

  1. create Income Statement for 3 years (end your report at line "net income from continuing & discontinuing operation)
  2. create Balance Sheet for 3 years
  3. visit the company's website and review the Investor page. Briefly explain something interesting from your review.
  4. what industry is the company in?
  5. number of employees?
  6. who is the CEO?
  7. Briefly explain a recent news item. (try not to pick the same news item as another team members)
  8. calculate the company's "Net Working Capital" for each of the 3 years (see page 59 of the textbook)
  9. calculate the company's "Current Ratio" for each of the 3 years (page 88)
  10. calculate the company's "Inventory Turnover" for 2019 and 2018 (page 91, use the alternative calculation), plus convert your answer into # of days (page 90)
  11. For Revenue - what is the dollar change from 2018 to 2019 (state increase or decrease)
  12. For Revenue - what is the percentage change from 2018 to 2019 (state increase or decrease)
  13. For Operating Expense - what is the dollar change from 2018 to 2019 (state increase or decrease)
  14. For Operating Expense - what is the percentage change from 2018 to 2019 (state increase or decrease)
  15. calculate the company's "Gross Profit" percentage for the 3 years (page 97, also called Gross Profit Margin)
  16. briefly explain what 'Gross Profit' means. (this term is super important)
  17. what are 2 competitors of your company and what is their Gross profit percentage for 2019, Including your company, who has the best Gross Profit %?
  18. calculate the company's "Net Income" percentage (using the line "net income from continuing & discontinuing operation) for each of the 3 years
  19. for the Income Stmt, create a "% of Revenue" column for each year (page 86)
  20. create a Income Stmt budget for 2020 based on Sales increasing 20% and Operating Expenses decreasing by 10%. (see attachment)
  21. finally, confirm that you created your own spreadsheet files to complete the assignment.

DO this for Amazon, financial data can be found on Yahoo, financials. Thanks!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones Of Financial Accounting

Authors: Jay Rich, Jeff Jones, Maryanne Mowen, Don Hansen

2nd Edition

0538473452, 9780538473453

More Books

Students also viewed these Finance questions

Question

What projects have I completed at home, work, or school?

Answered: 1 week ago