(Continued on next page) Financial Statement Analysis and EPS Forecasting Report Assignment First, choose a publicly traded company to analyze this semester. Choosing a US company which has been...

1 answer below »

View more »
Answered 7 days AfterJun 29, 2021

Answer To: (Continued on next page) Financial Statement Analysis and EPS Forecasting Report Assignment First,...

Narasimhaswamy answered on Jul 02 2021
148 Votes
Amazon inc Financial Ratio Analysis
At December 2019 & 2020
The following financial ratio analysis has been completed based on Amazon Inc fiscal years 2018 & 2019 financial statements (year ending December 31, 2019 & 2020). This analysis is broken into short-term solvency ratios, long-term solvency ratios, turnover ratios, profitability ratios and market value ratios. Each set
of ratios is used to analyze different aspects of the firm’s performance and predict its position for future performance. The report culminates in forecasted revenue based on this analysis.
1. Short-term Solvency, or Liquidity, Ratios
    Liquidity Ratio
    Ratio Formula
    December 31, 2019
    December 31, 2020
    Current Ratio
    Current Assets Current Liabilities
    1.10
    
1.05
    Quick Ratio
    (Current Assets - Inventory) Current Liabilities
    0.86
    0.88
    Cash Ratio
    Cash Current Liabilities
    0.41
    0.33
Short-term Solvency, or Liquidity, Ratios. Liquidity ratios focus on current assets and current liabilities to indicate the firm’s ability to fulfill its short-term obligations. Amazon’s current ratio of 1.05 displays the firm’s strong position to pay off current liabilities. However, the fact that the current ratio lower than 2 is the first indicator that the company might be using its short-term financing facilities efficiently. While the company’s quick ratio of 0.88 confirms its ability to pay back its current liabilities, its cash ratio continues to reflect the impact of debt on the balance sheet. At 0.41 Amazon has a cash ratio significantly lower than Microsoft (0.96) and eBay (1.89). Amazon’s 2020 cash ratio reflects a Decrease in cash ratio from 2019 when the cash ratio for Amazon was (0.41).
2. Long-Term Solvency, or Financial Leverage, Ratios
    Financial Leverage Ratios
    Ratio Formula
    December 31, 2019
    December 31, 2020
    Total Debt Ratio
    (Total Assets - Total Equity) Total Assets
    1.11
    1.10
    Debt/Equity Ratio
    Total Debt Total Equity
    4.04
    3.79
    Equity Multiplier
    Total Assets
Total Equity
    3.63
    3.44
    Time Interest Earned Ratio
    EBIT
Interest
    9.09
    13.09
    Cash Coverage Ratio
    (EBIT + Depreciation)
Interest
    25.64
    30.69
Long-Term Solvency, or Financial Leverage, Ratios. Total debt ratio from 2019 to 2020, there was a small drop in the debt ratio in 2020. A total debt ratio under 0.5 reflects company assets being financed through equity. A ratio higher than 0.5, however, indicates the use of debt to finance the company’s assets. This is what we are witnessing with Amazon’s – a ratio of 1.10 is evidence of high dependency on debt.
The debt to equity ratio reveals financial leverage or the lack thereof. Amazons’ high ratio of 3.79 indicates that the company is heavily reliant on creditors to finance its business. this is concerning as they are less protected financially in the event of a decline in business. The decision to increase their debt also led to a reduction in credit score.
The equity multiplier of 3.44 which shows that the company is less dependent on debt to finance its business.
The times interest earned ratio and cash coverage ratio are better values indicating that its debt obligations can be met easily with cash earned. Both ratios indicate a low risk for bankruptcy or default and therefore, financial stability is good.
3. Asset Utilization, or Turnover, Ratios
    Turnover Ratios
    Ratio Formula
    December 31, 2019
    December 31, 2020
    Inventory Turnover
    Cost of Goods Sold Inventory
    8.79
    10.53
    Days Sales in Inventory
    365
Inventory Turnover
    41.53
    34.65
    Receivable Turnover
    Sales Account Receivable
    14.96
    17.02
    Days Sales in Receivable
    365
Receivable Turnover
    24.39
    21.44
    Total Assets Turnover
    Sales TotalAssets
    1.45
    1.41
    Capital Intensity
    TotalAssets Sales
    0.80
    0.83
Asset...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30