The effect of “Stock Days” on sales profitability & returns

I am not sure that the true effect of stock holding is often appreciated when it comes to the financial performance of your vehicle departments. The model below is simplified as it is meant to show the effect of stock levels on financial performance.

Donald Christy 2

As a result, I have assumed that the stock is 100% funded and that overheads are 60% of GP. All values in light, cursive type with the *asterisk in front, are inputs which can be changed if you want to use your own numbers in this model.

I have included both Return on Sales and Return on Investment in the analysis as they are both relevant measures. Return on Sales is the profit on the vehicle retained after deducting all overheads and interest expressed as a percentage. Return on Investment is the profit on vehicle retained as a percentage of the cost of the vehicle expressed as an annualised percentage – much like the interest you would earn on your bank account.

I don’t think the numbers need too much explanation as they speak for themselves. Given the risk, investment and effort required to run “vehicle sales” it is almost not worth being in the business with a stock holding over 45 days. This model can be applied to individual vehicles which hopefully shows what overage stock really does cost you.

Stock Days

30

45

60

90

Interest Rate

*10%

*10%

*10%

*10%

Monthly Units

*40

*40

*40

*40

Ave Sales Price/Unit

*R500 000

*R500 000

*R500 000

*R500 000

COS/Unit

R460 000

R460 000

R460 000

R460 000

Overhead % of GP

*60%

*60%

*60%

*60%

GP%

*8%

*8%

*8%

*8%

Stock Holding as per Stock Days

R18 400 000

R27 600 000

R36 800 000

R55 200 000

Monthly Interest

R151 233

R226 849

R302 466

R453 699

Interest Per Vehicle

R3 781

R5 671

R7 562

R11 342

GP/Unit Pre Int

R40 000

R40 000

R40 000

R40 000

GP/Unit After Int

R36 219

R34 329

R32 438

R28 658

GP% After Int

7.2%

6.9%

6.5%

5.7%

Overhead /Unit

R24 000

R24 000

R24 000

R24 000

Net Profit/Unit

R12 219

R10 329

R8 438

R4 658

Return on Sales

2.4%

2.1%

1.7%

0.9%

Return on Investment

31.9%

26.9%

22.0%

12.2%

Dept NOP/Year

R5 865 205

R4 957 808

R4 050 411

R2 235 616

If you would like the Excel spreadsheet to input your own numbers or if you have any questions or comments, please WhatsApp me on 0827761887.

  • Dealerfloor (dealerfloor.co.za) and I will be publishing regular articles on dealership efficiency. I am really looking forward to sharing ideas with you. Join the conversation by sending a WhatsApp to 082-776-1887 to be added to our group.

More Dealer News stories

Supergroup’s Jetour dealerships hit ground running

Supergroup’s Jetour dealerships hit ground running

Unlike in the past, when dealerships primarily waited for customers to come to them, we now take a more proactive approach, bringing our vehicles directly to places where people gather, allowing them to experience the product first-hand, including offering test drives,” says Gerrie van der Kaay, Dealer Principal at Supergroup Dealerships Jetour Midrand.

  • 22 November 2024
BB Hatfield ready to take GAC Motor to the next level

BB Hatfield ready to take GAC Motor to the next level

One of the latest Chinese automotive brands to establish itself in South Africa, GAC Motor, is benefitting from the expertise of well-known motor groups in the country, like the BB Motor Group.

  • 21 November 2024
Westvaal adds Jeep, Fiat in Klerksdorp

Westvaal adds Jeep, Fiat in Klerksdorp

Stellantis has announced the expansion of its multi-franchise dealer network with the addition of the Fiat and Jeep brands to the existing Westvaal Motor Group dealership in Klerksdorp in North West Province.

  • 18 November 2024