2020 Ace Retail Financial Report

Format Analysis

Conveni ence Hardware Stores

Rural Conv

Suburban

Suburban

Urban

Fringe

Conv

Conv

Hardware

Conv

Hardware

Hardware

Strategic Profit Model

Profit Margin Asset Turnover

7.1 2.2

9.3 2.2

5.7 2.2

Insufficient

Sample

Return On Assets (Pre-Tax %)

15.6

20.5

12.5

Financial Leverage

1.5

1.3

1.4

Return On Net Worth (Pre-Tax %)

23.4

26.6

17.5

Financial Ratios

Current Ratio Quick Ratio

5.6 1.6 6.6

9.4 1.9 8.2

6.2 1.8

Accounts Payable To Inventory (%) Accounts Payable Payout Period (Days)

10.5 13.3

10.9

11.5

Debt To Equity EBITDA (% Of Sales)

0.4 9.4 8.5

0.3

0.4 7.1 6.6

12.9

EBIT (% Of Sales)

9.6

Interest Coverage

31.9

22.2

27.5

Inventory Productivity

Inventory Turnover

3.3

3.3

2.9

Inventory Holding Period (Days)

110.4

110.1

125.7

Sales To Inventory Ratio

5.0

5.6

4.6

Gross Margin Return On Inventory (%)

170.0

231.8

181.5

Operating Productivity

Square Feet Of Retail Selling Space Sales $ Per Retail Square Foot Gross Profit $ Per Retail Square Foot Inventory $ Per Retail Square Foot Number Of Annual Sales Transactions

5,500

5,500

5,000

302.00 112.60

307.00 121.10

388.00 140.70

74.40

59.50

68.20

43,083

69,663

83,791

Sales $ Per Transaction

31.20

24.10

23.20

Customers (% of sales)

DIY Customers

64.5 15.5 20.0

80.0 10.0 10.0

77.3 12.4 10.3

Contractors

Commercial/Industrial Accounts

Other Customer Types

0.0

0.0

0.0

Total Sales

100.0

100.0

100.0

Business Hours

Monday Tuesday

10.0 10.0 10.0 10.0 10.0

10.5 10.5 10.5 10.5 10.5

10.5 10.5 10.5 10.5 10.5 10.0

Wednesday

Thursday

Friday

Saturday

8.0 3.0

9.8 5.0

Sunday

7.0

Total Hours Open Per Week

61.0

67.3

69.5

Employee Productivity

Number Of Full-Time Employees Number Of Part-Time Employees

4 2

4 4

6 4

Sales $ Per FTE Employee

276,221 102,770 41,707

213,855 88,642 37,311

186,525 77,012 38,259

Gross Profit $ Per FTE Employee Payroll $ Per FTE Employee

Payroll Expense (% Of Sales)

18.6 49.9

18.7 45.8

22.0 50.8

Personnel Productivity Ratio (%)

Wage $ Per Hour

20.10

17.90

18.40

Sales $ Per Payroll Dollar Sales $ Per Payroll Hour

5.50

5.70

4.80

132.80

102.80

89.70

18

Made with FlippingBook. PDF to flipbook with ease