Fill out all cells highlighted in light blue
Amazon
FY2020
Balance Sheet
Cash and cash equivalents 84,396
Receivables 24,542
Inventory 23,795
Other 0
Total current assets 132,733
Property, plant, and equipment 113,114
Lease assets 37,553
Goodwill 15,017
Other 22,778
Total assets 321,195
Accounts payable 72,539
Accrued expenses and other 70,863
Total current liabilities 143,402
Debt 31,816
Lease obligations 52,573
Equity (common stock + treasury stock + additional paid-in capital) 41,033
Accumulated other comprehensive income (180)
Retained earnings 52,551
Non-controlling interest 0
Total shareholders' equity 93,404
Total liabilities and shareholders' equity 321,195
Income Statement
Revenue 386,064
Cost of goods sold (233,307)
Gross profit 152,757
Operating expenses (129,858)
Operating income 22,899
Other income 2,387
Earnings before interest and tax (EBIT) 25,286
Interest income/expense (1,092)
Taxes and other (2,863)
Net income 21,331
Ratio Analysis
FY2020
Revenue
Cost of goods sold
Net income
Effective tax rate
Interest income/expense
Average assets
Average accounts receivable
Average accounts payable
Average inventory
Average long-term liabilities
Average shareholders' equity
Average property, plant, and equipment
Working capital
Average working capital
FY2020
Profitability Ratios
Gross margin
Profit margin
Return on assets
Return on equity
Return on invested capital
Activity Ratios
Asset turnover
Invested capital turnover
Equity turnover
Capital intensity
Days receivable
Days inventory
Days payable
Cash conversion cycle
Inventory turnover
Working capital turnover
Liquidity Ratios
Current ratio
Quick ratio
Leverage Ratios
Financial leverage ratio
Times interest earned ratio
Debt-to-equity ratio
Debt-to-capitalization ratio
DuPont Analysis
Profit margin
Asset turnover
Financial leverage
Return on equity
Source: Created by the author using modified data from the Amazon
2020 and 2019, and Walmart 2021 and 2020 10-K's.
s highlighted in light blue
Amazon Walmart
FY2019 FY2021 FY2020
55,021 17,741 9,465
20,816 6,516 6,284
20,497 44,949 44,435
0 20,861 1,622
96,334 90,067 61,806
72,705 92,201 105,208
25,141 17,647 21,841
14,754 28,983 31,073
16,314 23,598 16,567
225,248 252,496 236,495
47,183 49,141 46,973
52,800 52,578 35,537
99,983 101,719 82,510
23,414 44,533 49,651
39,791 18,713 22,782
31,826 3,928 3,531
(986) (11,766) (12,805)
31,220 88,763 83,943
0 6,606 6,883
62,060 87,531 81,552
225,248 252,496 236,495
280,522 559,151 523,964
(165,536) (420,315) (394,605)
114,986 138,836 129,359
(100,445) (116,288) (108,791)
14,541 22,548 20,568
189 14 1,638
14,730 22,562 22,206
(768) (2,194) (2,410)
(2,374) (6,858) (4,915)
11,588 13,510 14,881
FY2019 FY2021 FY2020
FY2021
Fill out all cells highlighted in light blue
Amazon
FY2020 FY2019
Balance Sheet
Cash and cash equivalents 84,396 55,021
Receivables 24,542 20,816
Inventory 23,795 20,497
Other 0 0
Total current assets 132,733 96,334
Property, plant, and equipment 113,114 72,705
Lease assets 37,553 25,141
Goodwill 15,017 14,754
Other 22,778 16,314
Total assets 321,195 225,248
Accounts payable 72,539 47,183
Accrued expenses and other 70,863 52,800
Total current liabilities 143,402 99,983
Debt 31,816 23,414
Lease obligations 52,573 39,791
Equity (common stock + treasury stock + addit 41,033 31,826
Accumulated other comprehensive income (180) (986)
Retained earnings 52,551 31,220
Non-controlling interest 0 0
Total shareholders' equity 93,404 62,060
Total liabilities and shareholders' equity 321,195 225,248
Income Statement
Revenue 386,064 280,522
Cost of goods sold (233,307) (165,536)
Gross profit 152,757 114,986
Operating expenses (129,858) (100,445)
Operating income 22,899 14,541
Other income 2,387 189
Earnings before interest and tax (EBIT) 25,286 14,730
Interest income/expense (1,092) (768)
Taxes and other (2,863) (2,374)
Net income 21,331 11,588
Ratio Analysis
FY2020 FY2019
Revenue 386,064
Cost of goods sold (233,307)
Net income 21,331
Interest income/expense (1,092)
Average assets 273,222
Average accounts receivable 22,679
Average accounts payable 59,861
Average inventory 22,146
Average long-term liabilities 73,797
Average shareholders' equity 77,732
Average property, plant, and equipment 92,910
Working capital (10,669) (3,649)
Average working capital (7,159)
FY2020
Profitability Ratios
Gross margin 39.57%
Profit margin 5.53%
Return on assets 7.81%
Return on equity 27.44%
Return on invested capital 14.08%
Activity Ratios
Asset turnover 1.41x
Invested capital turnover 2.55x
Equity turnover 4.97x
Capital intensity 4.16x
Days receivable 21.44
Days inventory 34.65
Days payable 93.65
Cash conversion cycle -37.56
Inventory turnover 10.53
Working capital turnover 32.59x
Liquidity Ratios
Current ratio 0.93
Quick ratio 0.76
Leverage Ratios
Financial leverage ratio 3.51
Times interest earned ratio 23.16
Debt-to-equity ratio 2.44
Debt-to-capitalization ratio 0.47
DuPont Analysis
Profit margin 5.53%
Asset turnover 1.41x
Financial leverage 3.51
Return on equity 27.44%
Source: Created by the author using
modified data from the Amazon 2020 and
2019, and Walmart 2021 and 2020 10-K's.
Walmart
FY2021 FY2020
17,741 9,465
6,516 6,284
44,949 44,435
20,861 1,622
90,067 61,806
92,201 105,208
17,647 21,841
28,983 31,073
23,598 16,567
252,496 236,495
49,141 46,973
52,578 35,537
101,719 82,510
44,533 49,651
18,713 22,782
3,928 3,531
(11,766) (12,805)
88,763 83,943
6,606 6,883
87,531 81,552
252,496 236,495
559,151 523,964
(420,315) (394,605)
138,836 129,359
(116,288) (108,791)
22,548 20,568
14 1,638
22,562 22,206
(2,194) (2,410)
(6,858) (4,915)
13,510 14,881
FY2021 FY2020
559,151
(420,315)
13,510
(2,194)
244,496
6,400
48,057
44,692
67,840
84,542
98,705
(11,652) (20,704)
(16,178)
FY2021
24.83%
2.42%
5.53%
15.98%
8.87%
2.29x
3.67x
6.61x
5.66x
4.18
38.81
41.73
1.26
9.40
25.98x
0.89
0.24
2.89
10.28
1.88
0.42
2.42%
2.29x
2.89
15.98%
