Financial Statement Analysis Audit
Income Statement (In thousands)
Dell Incorporated
Saturday, March, 24th, 2018
Dell Incorporated
Current Year(2017)
Prior Year(2016)
(2015)
Revenue
61,494
100%
52,902
100%
61,101
100%
Cost of Good Sold
49,128
79.90%
42,789
80.90%
49,375
80.80%
Gross Profit
12,366
20.10%
10,113
19.10%
11,726
19.20%
R&D
661
1.10%
624
1.20%
663
1.10%
Selling General & Administrative
7,302
11.90%
6,465
12.20%
7,102
11.60%
Non Recurring
0
0%
0
0%
0%
0%
Others
0
0%
0
0%
0%
0%
Operating Income
4,403
7.20%
3,024
5.70%
3,961
6.50%
Depreciation Expense
970
1.60%
852
1.60%
769
1.30%
Other Income/Expense
116
0.20%
12
0%
47
0.10%
EBIT
3,549
5.80%
2,184
4.10%
3,417
5.60%
Interest Expense
199
0.30%
160
0.30%
93
0.20%
Tax Expense
715
1.20%
591
1.10%
846
1.40%
Income from Court Operations
2,635
4.30%
1,433
2.70%
2,478
4.10%
Net Income
16,548
27%
14,994
11%
15,802
15%
Balance Sheet
Dell Incorporated (In thousands)
Saturday, March, 24th, 2018
Current Year(2017)
Prior Year(2016)
(2015)
Cash
13,913
36%
10,635
31.60%
8,352
31.50%
Short Term Investments
452
1.20%
373
1.10%
740
2.80%
Accounts Receivable
10,136
26.30%
8,543
25.40%
6,443
24.30%
Inventory
1,301
3.40%
1,051
3.10%
867
3.30%
Other Current Assets
3,219
8.30%
3,643
10.80%
3,749
14.10%
Total Current Assets
29,021
75.20%
24,245
72%
20,151
76%
Long Term Investments
1,503
3.90%
1,113
3.30%
954
3.60%
PP&E Net
1,953
5.10%
2,181
6.50%
2,277
8.60%
Goodwill
4,365
11.30%
4,074
12.10%
1,737
6.60%
Intangibles
1,495
3.90%
1,694
5%
724
2.70%
Other Assets
262
0.70%
345
1%
657
2.50%
Total Assets
38,599
100%
33,652
100%
26,500
100%
Accounts Payable
15,474
40.10%
15,257
45.30%
12,045
45.50%
Short\Current L.T Debt
851
2.20%
663
2%
113
0.40%
Other Current Liabilities
3,158
8.20%
3,040
9%
2,701
10.20%
Total Current Liabilities
19,483
50.50%
18,960
56.30%
14,859
56.10%
Long Term Debt
5,146
13.30%
3,417
10.20%
1,898
7.20%
Other Liabilities
6,204
16.10%
5,634
16.70%
5,472
20.60%
Minority Interest
0
0%
0
0%
0
0%
Total Liabilities
30,833
79.90%
28,011
83.20%
22,229
83.90%
Preferred Stock
0
0%
0
0%
0
0%
Common Stock
11,797
43.70%
11,472
43.10%
11,189
42.20%
Additional Paid in Capital
0
0%
0
0%
0
0%
Retained Earnings
24,744
84%
22,110
81%
20,677
78%
Treasury Stock (-)
-28,704
-104.90%
-27,904
-105.30%
-27,904
-105.30%
Other Equity
-71
-0.70%
-37
-0.30%
309
1.20%
Total Stockholders' Equity
7,766
20.10%
5,641
16.80%
4,271
16.10%
Ratio Analysis
Growth Ratios
Sales Growth
16.20%
-13.40%
-0.1
Income Growth
83.90%
-42.20%
-15.90%
Asset Growth
14.70%
27%
-3.80%
Activity Ratios
Receivable Turnover
6.6
7.1
8.6
Inventory Turnover
41.8
44.6
48.2
Fixed Asset Turnover
31.5
24.3
26.8
Profit Ratios
Profit Margin
4.30%
2.70%
4.10%
Return on Assets
7.30%
4.80%
9.20%
Return on Equity
39.30%
28.90%
61.90%
Liquidity Ratios
Current Ratio
1.49
1.28
1.36
Quick Ratio
1.42
1.22
1.3
Solvency Ratios
Debt to Total Assets
0.8
0.83
0.84
Times Interest Earned (Accural)
17.83
13.65
36.74
Industry Measures
Jan-18
Jan-17
Jan-16
Product Revenue
50,...