Answered step by step
Verified Expert Solution
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
- create Income Statement for 3 years (end your report at line "net income from continuing & discontinuing operation)
- create Balance Sheet for 3 years
- visit the company's website and review the Investor page. Briefly explain something interesting from your review.
- what industry is the company in?
- number of employees?
- who is the CEO?
- Briefly explain a recent news item. (try not to pick the same news item as another team members)
- calculate the company's "Net Working Capital" for each of the 3 years (see page 59 of the textbook)
- calculate the company's "Current Ratio" for each of the 3 years (page 88)
- 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)
- For Revenue - what is the dollar change from 2018 to 2019 (state increase or decrease)
- For Revenue - what is the percentage change from 2018 to 2019 (state increase or decrease)
- For Operating Expense - what is the dollar change from 2018 to 2019 (state increase or decrease)
- For Operating Expense - what is the percentage change from 2018 to 2019 (state increase or decrease)
- calculate the company's "Gross Profit" percentage for the 3 years (page 97, also called Gross Profit Margin)
- briefly explain what 'Gross Profit' means. (this term is super important)
- 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 %?
- calculate the company's "Net Income" percentage (using the line "net income from continuing & discontinuing operation) for each of the 3 years
- for the Income Stmt, create a "% of Revenue" column for each year (page 86)
- create a Income Stmt budget for 2020 based on Sales increasing 20% and Operating Expenses decreasing by 10%. (see attachment)
- 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
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