OVERALL: How do you this company performed when comparing 2020 to 2019? (state at least 4 observations) 1 2 3 4 Consolidated Balance Sheets (USD $) 12/31/2020 Vertical Analysis 12/31/2019 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 4.31% $1,929 4.76% -10.68% Receivables, net 1,484 3.72% 1,398 3.45% 6.15% Merchandise Inventories 11,079 27.73% 11,057 27.29% 0.20% Other Current Assets 1,016 2.54% 895 2.21% 13.52% Total Current Assets 15,302 38.31% 15,279 37.71% 0.15% Property and Equipment, at cost 38,513 96.41% 39,064 96.41% -1.41% Less Accumulated Depreciation and Amortization 15,793 -39.54% 15,716 -38.79% 0.49% Net Property and Equipment 22,720 56.88% 23,348 57.62% -2.69% Goodwill 1,353 3.39% 1,289 3.18% 4.97% Other Assets 571 1.43% 602 1.49% -5.15% Total Assets 39,946 100.00% 40,518 100.00% -1.41% Current Liabilities: Short-Term Debt 290 0.73% 0 Accounts Payable 5,807 14.54% 5,797 14.31% 0.17% Accrued Salaries and Related Expenses 1,391 3.48% 1,428 3.52% -2.59% Sales Taxes Payable 434 1.09% 396 0.98% 9.60% Deferred Revenue 1,468 3.67% 1,337 3.30% 9.80% Income Taxes Payable 35 0.09% 12 0.03% 191.67% Current Installments of Long-Term Debt 38 0.10% 33 0.08% 15.15% Other Accrued Expenses 1,806 4.52% 1,746 4.31% 3.44% Total Current Liabilities 11,269 28.21% 10,749 26.53% 4.84% Long-Term Debt, excluding current installments 16,869 42.23% 14,691 36.26% 14.83% Other Long-Term Liabilities 1,844 4.62% 2,042 5.04% -9.70% Deferred Income Taxes 642 1.61% 514 1.27% 24.90% Total Liabilities 30,624 76.66% 27,996 69.10% 9.39% STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.768 billion shares at February 1, 2015 and 1.761 billion shares at February 2, 2014; outstanding: 1.307 billion shares at February 1, 2015 and 1.380 billion shares at February 2, 2014 88 0.22% 88 0.22% 0.00% Paid-In Capital 8,885 22.24% 8,402 20.74% 5.75% Retained Earnings 26,995 67.58% 23,180 57.21% 16.46% Accumulated Other Comprehensive (Loss) Income -452 -1.13% 46 0.11% -1082.61% Treasury Stock, at cost, 461 million shares at February 1, 2015 and 381 million shares at February 2, 2014 -26,194 -65.57% -19,194 -47.37% 36.47% Total Stockholders’ Equity 9,322 23.34% 12,522 30.90% -25.56% Total Liabilities and Stockholders' Equity $39,946 100.00% $40,518 100.00% -1.41% Consolidated Statements of Earnings (USD $) 12 Months Ended In Millions, except Per Share data, unless otherwise specified 12/31/2020 Vertical Analysis 12/31/2019 Vertical Analysis Horizontal Analysis Income Statement [Abstract] NET SALES $83,176 100.00% $78,812 100.00% 5.54% Cost of Sales 54,222 65.19% 51,422 65.25% 5.45% GROSS PROFIT 28,954 34.81% 27,390 34.75% 5.71% Operating Expenses: Selling, General and Administrative 16,834 20.24% 16,597 21.06% 1.43% Depreciation and Amortization 1,651 1.98% 1,627 2.06% 1.48% Total Operating Expenses 18,485 22.22% 18,224 23.12% 1.43% OPERATING INCOME 10,469 12.59% 9,166 11.63% 14.22% Interest and Other (Income) Expense: Interest and Investment Income -337 -0.41% -12 -0.02% 2708.33% Interest Expense 830 1.00% 711 0.90% 16.74% Other 0 0.00% 0 0.00% 0.00% Interest and Other, net 493 0.59% 699 0.89% -29.47% EARNINGS BEFORE PROVISION FOR INCOME TAXES 9,976 11.99% 8,467 10.74% 17.82% Provision for Income Taxes 3,631 4.37% 3,082 3.91% 17.81% NET EARNINGS $6,345 7.63% $5,385 6.83% 17.83% Weighted Average Common Shares 1,338 1,425 BASIC EARNINGS PER SHARE $4.74 $3.78 Ratio Analysis 2020 Ratios Current Ratio = current asset / current liabilities = 15302 / 11269 = 1.35:1 Inventory Turnover Ratio = inventory / cost of sales *365 = 11079 / 54222 * 365 = 75days Debto to Equity Ratio = debt / equity = 19355 / 9322 = 2.07 Return on Assets =net income / total asset * 100 = 6345 / 39946 * 100 = 16 % Asset Turnover Ratio = sales / total assets = 83176 / 39946 = 2.08 Profit Margin Ratio = (total revenue - total expenses) / total revenue = 83176-18485/83176= .78% Gross Profit Ratio = gross profit / sales * 100 = 28954 / 39946 * 100 = 72.4%
OVERALL: |
||
How do you this company performed when comparing 2020 to 2019? (state at least 4 observations) |
||
1 |
||
2 |
||
3 |
||
4 |
Consolidated |
12/31/2020 |
Vertical Analysis |
12/31/2019 |
Vertical Analysis |
Horizontal Analysis |
|
||||||||
In Millions, unless otherwise specified |
|
|||||||||||||
Current Assets: |
|
|
|
|
|
|
||||||||
Cash and Cash Equivalents |
$1,723 |
4.31% |
$1,929 |
4.76% |
-10.68% |
|
||||||||
Receivables, net |
1,484 |
3.72% |
1,398 |
3.45% |
6.15% |
|
||||||||
Merchandise Inventories |
11,079 |
27.73% |
11,057 |
27.29% |
0.20% |
|
||||||||
Other Current Assets |
1,016 |
2.54% |
895 |
2.21% |
13.52% |
|
||||||||
Total Current Assets |
15,302 |
38.31% |
15,279 |
37.71% |
0.15% |
|
||||||||
Property and Equipment, at cost |
38,513 |
96.41% |
39,064 |
96.41% |
-1.41% |
|
||||||||
Less |
15,793 |
-39.54% |
15,716 |
-38.79% |
0.49% |
|
||||||||
Net Property and Equipment |
22,720 |
56.88% |
23,348 |
57.62% |
-2.69% |
|
||||||||
|
1,353 |
3.39% |
1,289 |
3.18% |
4.97% |
|
||||||||
Other Assets |
571 |
1.43% |
602 |
1.49% |
-5.15% |
|
||||||||
Total Assets |
39,946 |
100.00% |
40,518 |
100.00% |
-1.41% |
|
||||||||
Current Liabilities: |
|
|
|
|
|
|
||||||||
Short-Term Debt |
290 |
0.73% |
0 |
|
|
|
||||||||
Accounts Payable |
5,807 |
14.54% |
5,797 |
14.31% |
0.17% |
|
||||||||
Accrued Salaries and Related Expenses |
1,391 |
3.48% |
1,428 |
3.52% |
-2.59% |
|
||||||||
Sales Taxes Payable |
434 |
1.09% |
396 |
0.98% |
9.60% |
|
||||||||
Deferred Revenue |
1,468 |
3.67% |
1,337 |
3.30% |
9.80% |
|
||||||||
Income Taxes Payable |
35 |
0.09% |
12 |
0.03% |
191.67% |
|
||||||||
Current Installments of Long-Term Debt |
38 |
0.10% |
33 |
0.08% |
15.15% |
|
||||||||
Other Accrued Expenses |
1,806 |
4.52% |
1,746 |
4.31% |
3.44% |
|
||||||||
Total Current Liabilities |
11,269 |
28.21% |
10,749 |
26.53% |
4.84% |
|
||||||||
Long-Term Debt, excluding current installments |
16,869 |
42.23% |
14,691 |
36.26% |
14.83% |
|
||||||||
Other Long-Term Liabilities |
1,844 |
4.62% |
2,042 |
5.04% |
-9.70% |
|
||||||||
|
642 |
1.61% |
514 |
1.27% |
24.90% |
|
||||||||
Total Liabilities |
30,624 |
76.66% |
27,996 |
69.10% |
9.39% |
|
||||||||
|
|
|
|
|
|
|
||||||||
|
|
|
|
|
|
|
||||||||
Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.768 billion shares at February 1, 2015 and 1.761 billion shares at February 2, 2014; outstanding: 1.307 billion shares at February 1, 2015 and 1.380 billion shares at February 2, 2014 |
88 |
0.22% |
88 |
0.22% |
0.00% |
|
||||||||
Paid-In Capital |
8,885 |
22.24% |
8,402 |
20.74% |
5.75% |
|
||||||||
|
26,995 |
67.58% |
23,180 |
57.21% |
16.46% |
|
||||||||
Accumulated Other Comprehensive (Loss) Income |
-452 |
-1.13% |
46 |
0.11% |
-1082.61% |
|
||||||||
|
-26,194 |
-65.57% |
-19,194 |
-47.37% |
36.47% |
|
||||||||
Total Stockholders’ Equity |
9,322 |
23.34% |
12,522 |
30.90% |
-25.56% |
|
||||||||
Total Liabilities and Stockholders' Equity |
$39,946 |
100.00% |
$40,518 |
100.00% |
-1.41% |
|
||||||||
Consolidated Statements of Earnings (USD $) |
12 Months Ended |
|
|
|||||||||||
In Millions, except Per Share data, unless otherwise specified |
12/31/2020 |
Vertical Analysis |
12/31/2019 |
Vertical Analysis |
Horizontal Analysis |
|||||||||
Income Statement [Abstract] |
|
|
|
|
|
|||||||||
NET SALES |
$83,176 |
100.00% |
$78,812 |
100.00% |
5.54% |
|||||||||
Cost of Sales |
54,222 |
65.19% |
51,422 |
65.25% |
5.45% |
|||||||||
GROSS PROFIT |
28,954 |
34.81% |
27,390 |
34.75% |
5.71% |
|||||||||
Operating Expenses: |
|
|
|
|
|
|||||||||
Selling, General and Administrative |
16,834 |
20.24% |
16,597 |
21.06% |
1.43% |
|||||||||
Depreciation and Amortization |
1,651 |
1.98% |
1,627 |
2.06% |
1.48% |
|||||||||
Total Operating Expenses |
18,485 |
22.22% |
18,224 |
23.12% |
1.43% |
|||||||||
OPERATING INCOME |
10,469 |
12.59% |
9,166 |
11.63% |
14.22% |
|||||||||
Interest and Other (Income) Expense: |
|
|
|
|
|
|||||||||
Interest and Investment Income |
-337 |
-0.41% |
-12 |
-0.02% |
2708.33% |
|||||||||
Interest Expense |
830 |
1.00% |
711 |
0.90% |
16.74% |
|||||||||
Other |
0 |
0.00% |
0 |
0.00% |
0.00% |
|||||||||
Interest and Other, net |
493 |
0.59% |
699 |
0.89% |
-29.47% |
|||||||||
EARNINGS BEFORE PROVISION FOR INCOME TAXES |
9,976 |
11.99% |
8,467 |
10.74% |
17.82% |
|||||||||
Provision for Income Taxes |
3,631 |
4.37% |
3,082 |
3.91% |
17.81% |
|||||||||
NET EARNINGS |
$6,345 |
7.63% |
$5,385 |
6.83% |
17.83% |
|||||||||
Weighted Average Common Shares |
1,338 |
|
1,425 |
|
|
|||||||||
BASIC EARNINGS PER SHARE |
$4.74 |
|
$3.78 |
|
|
|||||||||
|
||||||||||||||
Ratio Analysis |
|
2020 Ratios |
|
|||||||||||
|
|
= current asset / current liabilities = 15302 / 11269 = 1.35:1 |
|
|||||||||||
Inventory Turnover Ratio |
|
= inventory / cost of sales *365 = 11079 / 54222 * 365 = 75days |
|
|||||||||||
Debto to Equity Ratio |
|
= debt / equity = 19355 / 9322 = 2.07 |
|
|||||||||||
Return on Assets |
|
=net income / total asset * 100 = 6345 / 39946 * 100 = 16 % |
|
|||||||||||
Asset Turnover Ratio |
|
= sales / total assets = 83176 / 39946 = 2.08 |
|
|||||||||||
Profit Margin Ratio |
|
= (total revenue - total expenses) / total revenue = 83176-18485/83176= .78% |
|
|||||||||||
Gross Profit Ratio |
|
= gross profit / sales * 100 = 28954 / 39946 * 100 = 72.4% |
|
|||||||||||
|
||||||||||||||
Trending now
This is a popular solution!
Step by step
Solved in 2 steps