Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Under Yahoo! Finance to get your information. 1. Input the company name, 2. select Financials, 3. select Income Statement then Balance Sheet. Show all your

Under Yahoo! Finance to get your information. 1. Input the company name, 2. select Financials, 3. select Income Statement then Balance Sheet.

Show all your numbers in millions.

Use the #s for the last three years, for example, Dec 2019, Dec 2018, Dec 2017

For Amazon's Balance Sheet, for 12/31/2019 current liabilities total is 87,812,000 and 47,183,000 current accrued expenses 32,439,000 current deferred Revenue 8,190,000.

Requirements: 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% finally, confirm that you created your own spreadsheet files to complete the assignment.

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

Clinical Audit For Doctors And Healthcare Professionals

Authors: Bhoresh Dhamija, Chen Low, Geri Keane

2nd Edition

1445384043, 978-1445384047

More Books

Students also viewed these Accounting questions