Format Analysis
Super Hardware Stores
Hi Profit
Super
Super
Super
Super
Super
Super
Hdwe <$2.5 Hdwe $2.5- Hdwe $3.6-
Hdwe >$7
Hardware Hardware
Million
$3.6 Mil
$7 Mil
Million
Sample Size
188
56
26
32
88
41
Typical Sales Volume ($)
4,625,571 4,972,157 2,144,706 3,037,196 4,896,292 8,997,035
Income Statement (% of sales)
Net Sales
100.0
100.0
100.0
100.0
100.0
100.0
Cost Of Goods Sold
60.8 39.2
59.4 40.6
62.1 37.9
59.0 41.0
60.8 39.2
61.2 38.8
Gross Margin Before Patronage Div.
Patronage Dividend
1.1
0.8
1.3
0.6
1.1
0.3
Gross Margin
40.3
41.4
39.2
41.6
40.3
39.1
Payroll Expenses Owners/Officers Salaries & Bonuses All Other Employee Wages & Bonuses Total Salaries, Wages & Bonuses Payroll Taxes (FICA, Worker Comp., Unemp.) Group Insurance (Hospital, Medical, Life) Benefit Plans (Pension, Profit Sharing, etc.)
2.1
2.5
2.9
2.8
2.4
1.9
12.2 14.3
10.1 12.6
10.5 13.4
12.7 15.5
12.0 14.4
12.8 14.7
1.3 0.6 0.2
1.2 0.4 0.2
1.1 0.3 0.1
1.6 0.8 0.2
1.3 0.5 0.2
1.4 0.8 0.2
Total Payroll Expenses
16.4
14.4
14.9
18.1
16.4
17.1
Occupancy Expenses Utilities (Heat, Light, Power, Water) Building Repairs & Maintenance Rent Or Ownership In Real Estate*
0.8 0.3 3.9 5.0 1.6 0.2 0.4 0.2 0.1 0.6 0.0 6.8 9.9
0.6 0.3 4.1 5.0 1.5 0.2 0.3 0.2 0.1 0.3 0.0 5.6 8.2
1.1 0.3 5.1 6.5 1.9 0.3 0.5 0.6 0.0 0.6 0.0 6.6
0.8 0.5 4.7 6.0 1.9 0.2 0.3 0.2 0.0 0.7 0.0 6.8
0.7 0.2 3.8 4.7 1.5 0.2 0.3 0.1 0.0 0.8 0.0 6.3 9.2
0.6 0.5 3.0 4.1 1.2 0.2 0.3 0.2 0.1 0.6 0.0 6.2 8.8
Total Occupancy Expenses Other Operating Expenses Advertising & Promotion
Telephone
Insurance (Business Liability & Casualty)
Interest Expense
Taxes (Pers. Property, Use, Licenses, Permits)
Depreciation
Bad Debt Losses
All Other Operating Expenses Total Other Operating Expenses
10.6 32.0
10.1 34.2
Total Operating Expenses
31.3
27.6 13.8
30.3 10.0
30.0
Operating Profit
9.0 1.4
7.2 2.1 9.3
7.4 1.2 8.6
9.1 1.4
Other Income/Expenses
1.8
1.4
Profit Before Taxes
10.4
15.6
11.4
10.5
Balance Sheet (% of assets)
Assets Cash & Marketable Securities
21.0
25.2
15.3
19.1
22.8
21.4
Accounts Receivable
3.3
2.6
2.8
2.0
3.5
4.7
Inventory
50.5
50.3
60.6
59.1
46.8
42.5
Other Current Assets Total Current Assets
4.2
2.4
6.2
1.9
3.9
6.3
79.0 21.0
80.5 19.5
84.9 15.1
82.1 17.9
77.0 23.0
74.8 25.2
Fixed & Noncurrent Assets
Total Assets
100.0
100.0
100.0
100.0
100.0
100.0
Liabilities & Net Worth Accounts Payable
9.2 0.0 9.5
6.5 0.0 5.2
8.2 0.0
13.9
6.9 0.0 7.5
8.4 0.4
Notes Payable
0.0 8.2
Other Current Liabilities Total Current Liabilities Long Term Liabilities Loans From Stockholders Net Worth or Owner Equity Total Liabilities & Net Worth
11.4 19.6 51.9
10.2 19.0 14.0
18.7 16.5
11.7 12.6
22.1 15.7
14.5 14.4
0.0
0.0
0.0
0.0
0.0
0.0
64.7
75.7
28.5
62.3
71.1
67.0
100.0
100.0
100.0
100.0
100.0
100.0
Owners' Return (%)
Owners' Discretionary Profit Margin Owners' Discretionary Return On Assets
12.5 32.2 51.4
18.1 54.1 69.4
13.3 26.4 53.3
11.4 29.5 50.3
13.8 35.2 46.9
12.4 35.5 56.8
Owners' Discretionary RONW
*includes rent, mortgage interest, building depreciation, real estate insurance and real estate taxes
23
Made with FlippingBook. PDF to flipbook with ease