Question: 1. Amazon does not disclose Gross Margin or Operating Income in its income statement. Please calculate these metrics. 2. Calculate Amazon's market cap and Basic
1. Amazon does not disclose Gross Margin or Operating Income in its income statement. Please calculate these metrics.
2. Calculate Amazon's market cap and Basic EPS for the most recent four quarters. 3. Assuming Amazon's Pre-Tax Income is their entire Taxable income what is the effective tax rate for Amazon (you can leave the cell blank if there is a tax benefit). 4. Amazon provides revenue and operating income disclosure for their 3 segments. Calculate the Operating Margin for each segment 5. Calculate Revenue YoY Growth of each segment.
6. Calculate Amazon's P/S ratio and add it to the list of peers. Make sure to use trailing 4 quarters data, not just 1 quarter.
7. Smoothing data over several periods can reveal trends. Calculate the average T12m P/S ratio for each company from the peer group, using the last 4 periods.
Rank the results based on the most undervalued to overvalued companies from the peer group. (1=most undervalued, 5= most overvalued)
| Q2 2022 | Q1 2022 | Q4 2021 | Q3 2021 | Q2 2021 | Q1 2021 | Q4 2020 | Q3 2020 | |
| Gross Margin | ||||||||
| Operating Income | ||||||||
| Q2 2022 | Q1 2022 | Q4 2021 | Q3 2021 | |||||
| Market Cap | ||||||||
| Basic EPS | ||||||||
| Q2 2022 | Q1 2022 | Q4 2021 | Q3 2021 | Q2 2021 | Q1 2021 | Q4 2020 | Q3 2020 | |
| Effective Tax Rate | ||||||||
| Operating Margin per Segment | Q2 2022 | Q1 2022 | Q4 2021 | Q3 2021 | Q2 2021 | Q1 2021 | Q4 2020 | Q3 2020 |
| North America | ||||||||
| International | ||||||||
| Amazon Web Services(AWS) |
| AMZN US - Income Statement | ||||||||
| (In Millions of USD except Per Share) | Q2 2022 | Q1 2022 | Q4 2021 | Q3 2021 | Q2 2021 | Q1 2021 | Q4 2020 | Q3 2020 |
| 3 Months Ending | 6/30/22 | 3/31/22 | 12/31/21 | 9/30/21 | 6/30/21 | 3/31/21 | 12/31/20 | 9/30/20 |
| Revenue | 121,234.00 | 116,444.00 | 137,412.00 | 110,812.00 | 113,080.00 | 108,518.00 | 125,555.00 | 96,145.00 |
| Cost of Revenue | 66,424.00 | 66,499.00 | 82,835.00 | 62,930.00 | 64,176.00 | 62,403.00 | 79,284.00 | 57,106.00 |
| Selling, General, and Administratve Costs | 12,989.00 | 10,914.00 | 13,335.00 | 10,163.00 | 9,682.00 | 8,194.00 | 9,371.00 | 7,102.00 |
| Research and Development | 18,072.00 | 14,842.00 | 15,313.00 | 14,380.00 | 13,871.00 | 12,488.00 | 12,049.00 | 10,976.00 |
| Other Operating Expenses | 20,432.00 | 20,520.00 | 22,469.00 | 18,487.00 | 17,649.00 | 16,568.00 | 17,978.00 | 14,767.00 |
| Other Non-Operating Income (Expense), net | 1,528.00 | 970.00 | 9.00 | 163.00 | -1,261.00 | -1,697.00 | -1,206.00 | -925.00 |
| Pre-Tax Income | 1,247.00 | 2,335.00 | 3,087.00 | 4,315.00 | 8,634.00 | 10,268.00 | 7,765.00 | 6,809.00 |
| Income Tax Expense | -637.00 | -1,422.00 | 612.00 | 1,155.00 | 868.00 | 2,156.00 | 566.00 | 569.00 |
| Net Income | -2,028.00 | -3,844.00 | 14,323.00 | 3,156.00 | 7,778.00 | 8,107.00 | 7,222.00 | 6,331.00 |
| Diluted EPS | -0.20 | -0.38 | 1.39 | 0.31 | 0.76 | 0.79 | 0.70 | 0.62 |
| Shares Outstanding | 10,175.00 | 10,180.00 | 10,160.00 | 10,140.00 | 10,100.00 | 10,080.00 | 10,040.00 | 10,020.00 |
| Last Price | 106.21 | 163.00 | 166.72 | 164.25 | 172.01 | 154.70 | 162.85 | 157.44 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts