Project Worksheet (???***___***??? are the important questions, anything else answered would help)

go to the following web site:

https://finance.yahoo.com/

Type Amazon in the search box.

Then click on search.

Select the ticker symbol AMZN from the menu of choices.

Summary.

The earnings per share (EPS) for Amazon for the most recent year shown on this page are (((6.15)))

The current price of Amazons common stock is? ?(((1517.96)))

Historical Data

Time Period as Dec 29, 2017- Dec 29, 2017,

What was the adjusted Closing price of the company for Dec 29, 2017?

Closing Price ?(((1169.47)))

How much money would you have made or lost from the price change if you had purchased 1 share of Amazon stock on Dec 29, 2017 and sold it on the day you looked up the current price?

??? **** ___________________ ****???

Financials

Questions 1 through 16 pertain to Amazon.

1. From the quarterly Income Statement, what was the total revenue for the quarter ending on Dec 31, 2017?

?(((60,453,000)))

2. From the quarterly Income Statement, what was the total revenue for the previous quarter ending on Sep 30, 2017?

?(((43,744,000)))

3. Now use your answers to 1 and 2 to calculate the % growth in revenue for the quarter (subtract revenues for the quarter ending Sep 30, 2017 from revenues for the quarter ending Dec 31, 2017 and divide the result by the revenues for the quarter ending Sep 30, 2017. Then express the result as a percentage).

Revenue Growth = ???****________***???

4. From the quarterly Income Statement, what was Net Income for the quarter ending on Dec 31, 2017?

? (((1,857,000)))

5. From the quarterly Income Statement, what was the Gross Profit for the quarter ending on Dec 31, 2017?

?(((21,958,000)))

6. From the quarterly Income Statement, what was the Cost of Revenue (cost of goods sold) for the quarter ending on Dec 31, 2017?

?(((38,495,000)))

7. From the quarterly Balance Sheet, what was the value of inventory as of Dec 31, 2017?

(((16,047,000)))

8. From the quarterly Balance Sheet, what was the value of inventory as of Sep 30, 2017?

(((13,711,000)))

9. From the quarterly Balance Sheet, what was the total assets value as of Dec 31, 2017?

?(((131,310,000)))

10. From the quarterly Balance Sheet, what was the total liabilities as of Dec 31, 2017?

(((103,601,000)))

11. From the quarterly Balance Sheet, what was the total current assets value as of Dec 31, 2017?

?(((60,197,000)))

12. From the quarterly Balance Sheet, what was the total current liabilities value as of Dec 31, 2017?

?(((57,883,000)))

Use Quarterly data ending at 12/31/2017 to answer question 13 to 16.

13. The largest current asset category is: ???*** ______________________________***???

14. The largest current liability category is: ???*** ___________________________***???

15. The largest non-current asset category is: ???***_____________________________***???

16. The largest non-current liability category is:???*** _____________________________***???

FINANCIAL RATIOS:

Use the information gathered from Amazons Financials on the previous pages to calculate the following ratios for Amazon. Do not try to look these up on the website. Instead you must make the calculation yourself.

Inventory Turnover ???*** ____________***???

(Cost of Goods Sold / Average Inventory)

Gross profit % ???*** ________________***???

(Gross Profit / Revenues)*100

Debt Ratio ???*** _________________***???

(Total Liabilities/Total Asset)

Current Ratio ???*** ______________???

(Current Asset/Current Liabilities)

COMPARISON OF Amazon TO THE CLOSE COMPETITOR eBay.

Now open up the income statement and balance sheet for eBay: In get quotes enter EBAY for eBay. Find the income statement and the balance sheet under Financials.

Look up the following income statement information:

Total Quarter Revenues (Dec 31, 2017) _____________

Total Quarter Revenues (Sep 30, 2017) _____________

Quarter Gross Profit (Dec 31, 2017) _____________

Look up the following Quarterly balance sheet information for Dec 31, 2017

Total Assets ____________

Total Liabilities _____________

Current Assets _____________

Current Liabilities _____________

Now use these 7 values (above) to calculate the following ratios for eBay in order to compare them to Amazon. Use the same calculation methods as for Amazon.

Revenue Growth ______________

Gross Profit% _______________

Debt Ratio ______________

Current Ratio ______________

Based on a comparison of these two ratios between Amazon and eBay which company seems to have better liquidity, which has better margin which has better solvency and which has better revenue growth?

Revenue Growth? _____________

Gross Profit? _____________

Solvency (Debt Ratio, low is good). ____________

Liquidity (Current Ratio, high is good). ____________

HORIZONTAL ANALYSIS

Horizontal analysis is also known as trend analysis. By looking at recent trends, and also taking into disclosures and press releases from the company and outside the company, the financial markets often try to predict the future stock prices.

In the next few steps, do a simple 3 years trend analysis.

Go to Yahoo! Finance and Annual Data and write down the Revenues.

	Amazon	eBay
Dec 31, 2015
Dec 31, 2016
Dec 31, 2017

Go to Yahoo! Finance and write down the Operating Income.

	Amazon	eBay
Dec 31, 2015
Dec 31, 2016
Dec 31, 2017

Now, Go to Yahoo! Finance and write down the Net Income.

	Amazon	eBay
Dec 31, 2015
Dec 31, 2016
Dec 31, 2017