Income Statement compared with Industry Average
Year Ended December 31, 2020
Randall
Industry Average
Net Sales Revenue
$800,000
100
%
Cost of Goods Sold
627,200
67.4
Gross Profit
172,800
32.6
Operating Expenses
95,000
20.9
Operating Income
77,800
11.7
Other Expenses
8,054
0.8
Net Income
$69,746
10.9
%
RANDALL DEPARTMENT STORES, INC.
Balance Sheet
31-Dec-20
Randall
Industry Average
Current Assets
$300,000
68
%
Property, Plant, and Equipment, Net
130,600
25.2
Intangible Assets, Net
8,400
1
Other Assets
7,500
5.8
Total Assets
446,500
100
%
Current Liabilities
$230,000
65
%
Long-term Liabilities
95,000
17
Total Liabilities
325,000
82
Stockholders’ Equity
121,500
18
Total Liabilities and Stockholders’ Equity
$446,500
100
%
Please refer to the Income Statement and Balance Sheet above and perform the following.
Prepare a vertical analysis for both the income statement and balance sheet.
Write a paragraph comparing the company’s performance with the industry average.
Compute the following ratios and comment on what the results mean when evaluating the company:
Current ratio
The gross profit percentage ratio
Debt ratio
Profit margin ratio
Vertical Analysis – Income Statement (Randall vs. Industry Average):
Line Item | Randall ($) | Randall % | Industry Average % |
Net Sales Revenue | $800,000 | 100.00 | 100.00 |
Cost of Goods Sold | $627,200 | 78.40 | 67.40 |
Gross Profit | $172,800 | 21.60 | 32.60 |
Operating Expenses | $95,000 | 11.88 | 20.90 |
Operating Income | $77,800 | 9.72 | 11.70 |
Other Expenses | $8,054 | 1.01 | 0.80 |
Net Income | $69,746 | 8.72 | 10.90 |
Vertical Analysis – Balance Sheet (Randall vs. Industry Average):
Line Item | Randall ($) | Randall % | Industry Average % |
Current Assets | $300,000 | 67.19 | 68.00 |
Property, Plant, and Equipment, Net | $130,600 | 29.25 | 25.20 |
Intangible Assets, Net | $8,400 | 1.88 | 1.00 |
Other Assets | $7,500 | 1.68 | 5.80 |
Total Assets | $446,500 | 100.00 | 100.00 |
Current Liabilities | $230,000 | 51.51 | 65.00 |
Long-term Liabilities | $95,000 | 21.28 | 17.00 |
Total Liabilities | $325,000 | 72.79 | 82.00 |
Stockholders’ Equity | $121,500 | 27.21 | 18.00 |
Total Liabilities and Stockholders’ Equity | $446,500 | 100.00 | 100.00 |
Comparison of Randall’s Performance with the Industry Average:
Randall Department Stores’ performance in 2020 shows a mixed picture when compared to the industry average. While Randall’s operating expenses are notably lower as a percentage of sales (11.88% vs. 20.90%), its cost of goods sold is significantly higher (78.40% vs. 67.40%), resulting in a much lower gross profit margin (21.60% vs. 32.60%). This lower gross profit ultimately leads to a lower net income percentage (8.72% vs. 10.90%) compared to the industry. On the balance sheet, Randall has a smaller proportion of current liabilities relative to its total assets (51.51% vs. 65.00%), which could indicate better short-term liquidity. However, it relies more on long-term liabilities (21.28% vs. 17.00%) and has a higher percentage of stockholder’s equity (27.21% vs. 18.00%), suggesting a potentially stronger equity base or a different financing structure.
Computed Ratios and Their Meaning: