The group purchase total is not the rebate base
Calder Industrial Supply / March 2 opening view and April 13 exclusivity update
Complete the decisions first. The seller's $12.240m AP total includes another entity, freight and a year-end return credited in January. Contractual eligible purchases are $10.000m. The earned rebate is $0.150m, leaving a $0.300m earnings correction. Revised adjusted EBITDA is $3.600m and maximum permitted EV is $21.600m.
Completed solution workbook · Learner workbook
1. An opening price decision, not automatic acceptance
Management's initial adjusted EBITDA is $3.900m. The seller's $25.000m ask implies 6.41× and requires $13.325m equity, exceeding both the 6.00× multiple limit and the $12.000m equity cap.
| Measure | Calculation | Result ($m) |
|---|---|---|
| Adjusted EBITDA | 3.600 + 0.180 + 0.120 | 3.900 |
| Debt drawn | 3.25 × 3.900 | 12.675 |
| Multiple ceiling | 6.00 × 3.900 | 23.400 |
| Equity-supported EV | 12.000 + 12.675 − 0.600 − 0.400 | 23.675 |
| Maximum permitted EV | Lower of 23.400 and 23.675 | 23.400 |
| Equity at the $25.000m ask | 25.000 + 1.000 − 12.675 | 13.325 |
| Equity at a $23.400m opening price | 23.400 + 1.000 − 12.675 | 11.725 |
A defensible opening action is to reprice to no more than $23.400m, conditional on earnings and working-capital diligence. A lower opening offer can reflect negotiation posture and unverified financial quality. A pause or pass can also be reasonable if linked to a stated concern. There is no observed fair-value range or return model to justify pretending a particular lower bid is uniquely correct.
Recognize the difference between the maximum permitted EV and the offer you choose. The former is deterministic; the latter is judgment. An opening price of $25.000m is outside the supplied authority. At the $23.400m ceiling, equity is $11.725m and headroom is only $0.275m.
Case continuation: regardless of the learner's opening recommendation, the later scenario stipulates a signed March 20 LOI at $23.400m and exclusivity through May 15. The April 13 decision is therefore a re-trade, pause or walk decision against that signed LOI. It does not assume the learner actually chose or approved it.
2. Resolve the three reconciling items
| Step | Treatment / source | USD $000 |
|---|---|---|
| Seller AP history | Sum of both accounts; seller export control | 12,240 |
| Remove affiliate CFS-66019 | Excluded legal entity / account; DOC-01 business perimeter and DOC-03 account terms | (2,000) |
| Main-account statement | 10,320 merchandise + 180 freight − 260 posted credits | 10,240 |
| Remove invoice freight | 180 charged in the statement; excluded by written program | (180) |
| Recognize year-end accepted returns | 60 accepted December 29; memo posted January 15 | (60) |
| Eligible FY2025 merchandise | Main account, contractual basis | 10,000 |
Cross-check independently: merchandise invoices of $10.320m less posted merchandise credits of $0.260m and accepted but later-posted returns of $0.060m equal $10.000m. These are two routes to the same contractual population. Do not subtract the $0.260m twice: it is already included in both the net AP history and the statement activity.
The program applies only to CIS-44082. The related Field Services entity is outside the acquisition and program. Shared purchasing administration does not amend a legal-entity/account rule. Freight is an invoice charge, not eligible merchandise. The January memo's posting date does not override its December 29 acceptance date.
The tier is applied to actual eligible merchandise and to all eligible volume. Because $10.000m is below $12.000m, the correct rate is 1.5%:
Earned rebate = $10.000m × 1.5% = $0.150m
Unsupported booked credit = $0.450m − $0.150m = $0.300m
The controller's email is a seller assertion, not an admission or independent verification. It supports examining the account-combination argument. The written supplier terms reject that argument and provide no waiver. A forecast is also excluded from actual qualifying purchases.
The close note's $0.450m accrual is 3.75% of a $12.000m threshold-volume placeholder, below management's $12.300m November plan. It does not establish actual eligible volume. Applying the upper rate to the reconciled $10.000m would produce $0.375m; applying it to the pooled $12.240m would produce $0.459m. Neither follows the written account and tier terms.
3. Separate the earnings correction from settlement
| Proposed correction E-01 | Debit ($000) | Credit ($000) |
|---|---|---|
| 5125 · Cost of sales, incentive recovery | 300 | 0 |
| 1340 · Vendor rebate receivable | 0 | 300 |
| Total | 300 | 300 |
All retained eligible merchandise was sold in FY2025. Increasing COGS by $0.300m reduces reported EBITDA from $3.600m to $3.300m and the rebate receivable from $0.450m to $0.150m. Retain the accepted ERP and owner adjustments, totaling $0.300m, to reach $3.600m corrected adjusted EBITDA.
The returned merchandise was already removed from inventory and merchandise-cost records in December, with a return receivable recorded then. The January credit memo settles that receivable. It affects the rebate-volume cut-off, but creates no additional $0.060m merchandise-COGS correction.
Waiting for cash cannot make an unsupported amount earned. The seller's suggested closing-working-capital treatment also does not remove the historical earnings effect. No agreed peg, closing statement or purchase-agreement definition is supplied. Do not automatically deduct another $0.300m from price as a contractual NWC adjustment.
4. Update the signed-LOI economics
| Measure | Calculation | Result ($m) |
|---|---|---|
| Revised debt | 3.25 × 3.600 | 11.700 |
| Multiple ceiling | 6.00 × 3.600 | 21.600 |
| Equity-supported EV | 12.000 + 11.700 − 1.000 | 22.700 |
| Maximum permitted EV | Lower of 21.600 and 22.700 | 21.600 |
| Equity at signed LOI price | 23.400 + 1.000 − 11.700 | 12.700 |
| Equity above cap at LOI price | 12.700 − 12.000 | 0.700 |
| Reduction from signed LOI to ceiling | 23.400 − 21.600 | 1.800 |
| Equity at revised ceiling | 21.600 + 1.000 − 11.700 | 10.900 |
At the $23.400m signed LOI price, the entry multiple becomes 6.50× and sponsor equity becomes $12.700m. The $0.300m earnings change lowers assumed debt by $0.975m. The 6.00× multiple cap requires a $1.800m reduction in EV; it binds before the equity cap.
A price of $22.700m solves only the equity limit. It still exceeds the multiple ceiling. At $21.600m EV, equity is $10.900m under the stipulated debt draw. Neither that headroom nor the multiple proves the deal is attractive.
5. Illustrative purchase-based rebate allocation
The correcting journal reverses $0.300m from the Q4 posting. That leaves Q4 reported EBITDA at $1.160m, or 12.2%. This is the corrected ledger presentation, not a fully comparable quarter-by-quarter margin series.
The earned $0.150m rebate covers a full year. For comparison, allocate it across quarters using each quarter's share of final eligible merchandise purchases: $2.160m, $2.460m, $2.640m and $2.740m. Allocate $0.0324m, $0.0369m, $0.0396m and $0.0411m respectively. Remove the remaining full-year $0.150m from Q4 before allocating these amounts. This analytical allocation leaves annual EBITDA unchanged.
Allocation limit: DOC-05 supports original purchase months for the returns and full-year sell-through of retained merchandise. It does not establish when that merchandise entered quarterly COGS. These results illustrate a purchase-based allocation; quarterly inventory/COGS matching remains unverified.
| USD $000 unless stated | Q1 | Q2 | Q3 | Q4 | FY2025 |
|---|---|---|---|---|---|
| Revenue | 7,650.0 | 8,200.0 | 8,650.0 | 9,500.0 | 34,000.0 |
| Reported EBITDA as posted | 620.0 | 730.0 | 790.0 | 1,460.0 | 3,600.0 |
| Posted-entry correction | 0.0 | 0.0 | 0.0 | (300.0) | (300.0) |
| Reported EBITDA after correcting Q4 entry | 620.0 | 730.0 | 790.0 | 1,160.0 | 3,300.0 |
| Remove annual earned benefit from Q4 posting | 0.0 | 0.0 | 0.0 | (150.0) | (150.0) |
| Earned annual rebate allocated by eligible purchases | 32.4 | 36.9 | 39.6 | 41.1 | 150.0 |
| EBITDA with earned benefit allocated to purchase quarters | 652.4 | 766.9 | 829.6 | 1,051.1 | 3,300.0 |
| Illustrative reported EBITDA margin | 8.5% | 9.4% | 9.6% | 11.1% | 9.7% |
| Accepted ERP and owner adjustments | 30.0 | 90.0 | 150.0 | 30.0 | 300.0 |
| Illustrative adjusted EBITDA | 682.4 | 856.9 | 979.6 | 1,081.1 | 3,600.0 |
| Illustrative adjusted EBITDA margin | 8.9% | 10.5% | 11.3% | 11.4% | 10.6% |
Under this allocation convention, reported Q4 margin is 11.1%, versus 8.5%, 9.4% and 9.6% in Q1–Q3. Q4 remains about 1.5 percentage points above Q3. After the accepted add-backs, Q3 and Q4 adjusted margins are 11.3% and 11.4%. That small gap is conditional on the allocation convention; the evidence does not establish fully comparable quarterly earnings or explain the remaining pattern.
6. Explain the annual growth and challenge the forecast
Even after correction, adjusted EBITDA rises 27.7%, from $2.820m to $3.600m, on 7.6% revenue growth, from $31.600m to $34.000m. Adjusted margin rises from 8.9% to 10.6%.
| Annual movement | Change ($000) |
|---|---|
| Revenue | 2,400 |
| Merchandise cost of sales | (1,650) |
| Earned / aggregate vendor benefit | (30) |
| Corrected gross profit | 720 |
| Cash operating expenses | (120) |
| Corrected reported EBITDA | 600 |
| Increase in accepted ERP adjustment | 180 |
| Owner adjustment change | 0 |
| Corrected adjusted EBITDA | 780 |
The accounts mechanically explain the change: corrected gross profit rises $0.720m while cash operating expenses rise $0.120m, and the new accepted ERP adjustment adds a further $0.180m to adjusted growth. They do not establish why merchandise margin improved, whether operating costs can keep growing slowly or whether these earnings persist. Product mix, pricing, cost allocation, period cut-off and accruals remain useful follow-up areas.
The November 30 main-account forecast was $12.300m. Through November, merchandise less then-posted credits was $9.100m, implying $3.200m of December volume to reach that plan. The later return attribution reduces final eligible January–November volume to $9.080m. Using that final basis for a retrospective comparison, the implied December requirement is $3.220m versus $0.920m actually achieved.
The retrospective $3.220m requirement is 3.5 times the final September–November average of $0.920m per month. No order support or explanation for that step-up is supplied. This challenges forecast credibility; it is not proof of intent or a claim that the December return was known on November 30.
Q4 eligible purchases of $2.740m annualize to $10.960m, still below the $12.000m threshold. Even an extrapolation of the latest quarter does not support assuming the upper rate. Annualizing one quarter is not a verified forward forecast.
7. Close the calculation, keep the diligence open
- Issue
- E-01 / Aster annual incentive accrual
- Reference links
- Q-07 is the diligence request. E-01 is the resulting buyer finding. QOE-03 is its earnings-bridge adjustment. These references identify the same issue at different points in the work.
- Evidence
- Supplier terms and account limitation; seller AP export; supplier activity; RA-251229; CM-260115; original journal and seller correspondence.
- Finding
- $10.000m qualifies for the 1.5% tier. The $0.450m booked accrual exceeds the $0.150m earned benefit by $0.300m.
- Buyer treatment
- Correct COGS and rebate receivable once; resize debt and price limits. Treat no additional return-inventory adjustment as outstanding.
- Seller position
- Group volume earns the upper tier; collection or closing NWC resolves the balance. The written terms and cut-off records do not support that position.
- Disposition
- Quantified for this screen. Seller acceptance and a posted correcting entry are not evidenced. Q-08 remains open; broader earnings diligence is incomplete.
8. One defensible five-field investment update
Recommendation. Re-trade the $23.400m LOI to no more than $21.600m EV and continue only if the seller accepts the corrected earnings basis. Pause if the account-combination position remains unresolved.
Evidence. DOC-03 limits the program to CIS-44082 and assigns returns to the year of supplier acceptance. DOC-05 includes an excluded affiliate, freight and a later-posted December return. Reconciled eligible volume is $10.000m, supporting $0.150m against the $0.450m accrual; the matching provisional estimate in the journal support does not replace that reconciliation.
Economics. Adjusted EBITDA becomes $3.600m. At the LOI price, entry is 6.50× and sponsor equity $12.700m. At $21.600m, assumed debt is $11.700m and equity $10.900m.
Conditions. Obtain seller agreement on the correction and the all-vendor incentive register, test year-end cut-off and secure lender underwriting before advancing.
Open questions. First, Q-08: further unsupported vendor accruals could reduce the earnings base and bid. Second, Q-05: product/SKU margins must explain the improvement before I rely on it in underwriting. Third, Q-09: capex, cash conversion and NWC definitions could change funding and the price mechanism. These are my prioritized requests; the other open requests remain relevant.
Pause is defensible if the unsupported forecast and disputed accounting create too much uncertainty to name a revised bid now. State the known price ceiling and evidence needed to resume. Pass is defensible if the seller will not accept a compliant price or the control concerns exceed the buyer's risk tolerance. A lower price than $21.600m can be defensible without claiming it is uniquely required.
Hold the LOI price unchanged breaches both limits under the supplied evidence. A waiver, extra debt, additional equity, future synergy or a higher future rebate cannot be invented to make it fit.
Searcher / owner-operator condition: before committing, define the seller's transition and the roles the buyer must fill. Q-12 can help establish the current management team and replacement-role costs. Those costs and the buyer's operating capability remain unquantified; the accepted owner personal-expense addback does not settle them. If that is the critical risk, prioritize Q-12 among your two or three requests.
9. What the evidence cannot establish
The record does not establish fraud, a final NWC purchase-price deduction, a sustainable forward earnings base, customer retention, a complete QoE, an IRR or a committed financing package. FY2024 vendor benefit is an aggregate line; it does not prove the same account terms applied then. The $21.600m ceiling is a mandate calculation, not fair value.
10. Review your work
Money is checked within ±$0.0005m and multiples within ±0.005×. Trace each calculated answer back to its population, unit and timing. Distinguish $3.300m corrected reported EBITDA from $3.600m corrected adjusted EBITDA. The latter equals the original reported amount by coincidence, so label the measure.
For judgment, compare all five fields with the example. A complete answer states a decision, uses the source evidence, respects the mandate, gives a meaningful condition and names an actual unresolved question. The example is one defensible response, not a prescribed wording.
| Check | Evidence in your answer |
|---|---|
| Source and accounting | Cite DOC-03's named-account and return-acceptance clauses; reconcile DOC-05's purchase population and explain why the correction affects COGS and the receivable once. |
| Economics | Label reported versus adjusted earnings, resize debt, test both authority limits and distinguish the LOI from your proposed price. |
| Decision | State what you would tell the seller and capital partners, the condition for advancing, and what evidence could make you pause or pass. |
| Priorities | Rank two or three open request IDs and explain their decision consequences. Naming every diligence request does not prioritize the work. |
| Owner-operation | If you plan to run Calder, name a specific transition or operating-role-cost condition and the evidence needed to resolve it. Keep unquantified conditions separate from the stipulated earnings bridge. |