Dealer margin and ROI calculator

A margin percentage says almost nothing about what a dealership actually earns. The same margin stretches across very different spans of stock days and credit days. Operating costs then take most of what is left. This calculator turns prices, volume, the three day-counts and one operating-cost figure into margin, markup, working capital employed and the net return that capital earns after operating costs and interest. Every trade below loads its own prices, volume, margin and costs, so no setting can print a return that no real business earns.

The calculator

How the math works

1. Prices are stripped of GST first. Both are entered inclusive, so each is divided by one plus the entered rate before anything else runs.
2. Margin on sales = (selling price less purchase price) ÷ selling price, on those stripped values.
3. Markup on cost = the same rupee margin ÷ purchase price.
4. Gross margin = rupee margin per unit × monthly volume, taken twelve times for the year.
5. Working capital employed = daily purchases × stock days + daily sales × credit days extended, less daily purchases × credit days received, taking a month as 30 days.
6. Interest for the year = working capital employed × the entered cost of capital.
7. Operating costs for the year = annual sales × the entered operating cost percentage.
8. Net return = (annual gross margin less operating costs less interest) ÷ working capital employed. The figure shown above it, before operating costs, uses the same denominator with the operating-cost line removed.

Where supplier credit covers the whole cycle the capital employed can reach zero, at which point the return stops being meaningful and the calculator says so instead of printing a number. A result far outside the band real trades occupy carries a caution line rather than a headline, because a four-digit return signals that one of the inputs has slipped rather than a discovery about the business.

Worked example: a ceramic tile stockist

Buying at ₹413 a box including GST, selling at ₹472 including GST at a rate of 18%, moving 3,500 boxes a month on 45 stock days, 60 market credit days and 15 supplier credit days, with operating costs at 7% of sales and capital costing 12% a year:

1. GST out: ₹413 ÷ 1.18 = ₹350 and ₹472 ÷ 1.18 = ₹400, so the real margin is ₹50 a box.
2. That is a 12.5% margin on sales against a 14.3% markup on cost.
3. Gross margin: ₹50 × 3,500 boxes = ₹1,75,000 a month, or ₹21,00,000 a year.
4. Daily run rates: purchases ₹40,833 and sales ₹46,667, taking the month as 30 days.
5. Working capital employed: ₹18,37,500 of stock plus ₹28,00,000 of receivables less ₹6,12,500 of supplier credit = ₹40,25,000.
6. Interest at 12% a year: ₹40,25,000 × 12% = ₹4,83,000.
7. Operating costs: annual sales of ₹1,68,00,000 at 7% = ₹11,76,000.
8. Net return: (₹21,00,000 less ₹11,76,000 less ₹4,83,000) ÷ ₹40,25,000 = ₹4,41,000 ÷ ₹40,25,000 = 11.0% a year.
9. Before operating costs the same trade reads 40.2%, which is why that figure never stands as the headline.

What is the difference between a distributor, a dealer and a retailer in India?

The three sit at different depths of the same channel, so they buy at different prices and carry very different capital. A distributor, usually called a stockist in the trade, is appointed by the company for a territory, buys in bulk at the thinnest margin and carries the heaviest stock plus the longest market credit. A dealer or sub-dealer buys from that stockist or straight from the company, sells to contractors, builders and bulk buyers, then works on a wider margin over smaller volume. A retailer, the counter itself, sells to the person who finally uses the goods, earns the widest margin of the three and collects mostly in cash. The words move around by sector, which is why this calculator names both terms for each rung and prices each one separately rather than assuming a single set of economics.

Why does this calculator show a net return rather than a gross one?

Because a gross figure flatters every trade beyond recognition. On the ceramic tiles preset the return on working capital reads 40.2% before operating costs against 11.0% after them. Only the second number is what the business keeps. Rent, salaries, freight and last-mile delivery, godown handling, breakage, scheme leakage plus bad debt all sit between the two. Distribution operating costs commonly run in the mid to high single digits of sales, which is enough to take a headline figure down by three quarters or turn it negative in a bad year. The gross figure stays visible in the breakdown because it isolates the effect of price and credit terms, though it should never be quoted on its own. One more caution belongs beside both numbers: the denominator here is working capital alone.

What is the difference between margin and markup?

Margin measures profit against the selling price while markup measures the same profit against cost, so one rupee figure produces two different percentages. A tile box bought at ₹413 and sold at ₹472 including GST works out to ₹350 and ₹400 once tax is stripped, a ₹50 profit that reads as a 12.5% margin on the selling price or a 14.3% markup on cost. The two get mixed up constantly in trade talk because an enterprise quoting a scheme usually means markup on billing price, while an accountant reading the profit and loss statement sees margin on sales. The gap widens as percentages rise, so a 50% markup is only a 33.3% margin. This calculator reports both from the same inputs, which lets a quoted scheme be read either way without converting by hand.

How do credit days change the return a stockist earns?

Every day of credit extended to the market adds a day of sales value to the capital employed, so an unchanged margin earns a very different return depending on how long the money stays out. On the tile preset, ₹46,667 of daily sales at 60 days of market credit locks ₹28,00,000 into receivables, well over half the ₹40,25,000 employed. Trimming market credit to 45 days releases ₹7,00,000 of capital, cuts the interest line and lifts the net return from 11.0% to 15.8% with no change in price, volume or costs. The lever works in reverse too, since stretching to 90 days at unchanged everything else drags the net return down to 5.0%, which is below the cost of the money funding it. Credit days received from the supplier offset the strain, because stock funded on supplier credit ties up no own capital until the due date.

What counts as working capital employed in distribution?

Working capital employed is the money locked in the trade at any moment: stock on the floor plus receivables in the market, less the purchases the supplier has billed but not yet collected. The calculator builds it from daily run rates, so daily purchases times stock days values the godown, daily sales times market credit days values the receivables and daily purchases times supplier credit days values the finance offsetting both. On the tile preset that reads ₹18,37,500 of stock plus ₹28,00,000 of receivables less ₹6,12,500 of supplier credit, or ₹40,25,000 in all. The same structure explains why two dealerships of identical turnover can employ wildly different capital. What the figure leaves out matters just as much: the godown rent advance, vehicles, racking, software plus the money placed with the principal all sit outside it, so this is a return on working capital rather than on everything the owner has put in.

How does GST change the margin calculation?

GST inflates rupee margins without changing real earnings, so the calculator strips it before doing any arithmetic. Prices are entered the way the trade actually quotes them, inclusive of tax, then the entered rate takes that tax back out of both sides. A box billed at ₹413 against one sold at ₹472 shows an apparent ₹59 of margin, while the true figure is ₹50. The extra ₹9 is exactly the output tax on the sale less the input credit on the purchase, money that passes to the government and never belongs to the business. The percentage margin happens to survive when both sides carry the same rate, though the rupee figures mislead. Any calculation mixing one inclusive price with one base price corrupts both. Trades where inputs and outputs carry different rates need line-level treatment beyond a single-rate tool.

Which trades do the presets cover?

Four researched trades plus a catchall, each priced separately for all three rungs of the channel: ceramic tiles, auto parts, pumps, FMCG and a fifth button called Any other trade. The four mirror India’s cluster economy, with tiles around Morbi, auto components around Ludhiana, pumps and motors around Coimbatore, plus FMCG spread across every district. The fifth is openly generic, a plain middle-of-the-road shape for a line none of the four describes, because a wrong preset for someone’s trade is worse than an openly neutral one. Choosing a trade fills every field, so price, volume, margin, operating cost, the GST rate and the three day-counts move together rather than a counter inheriting a stockist’s price. Across the fifteen combinations the net return lands between 9.8% and 26.7%, the band real trades occupy. Every figure is a round planning number, so a business that knows its own should overwrite it.