Trail Book Valuation Calculator
Estimate your trail book's value from recurring income and a chosen multiple. Compare offers, allow for income lost at transfer and see when projected net receipts recover a purchase price.
Income and offers
Enter your recurring receipts after any aggregator split. Exclude upfront commission and one-off payments.
Changing the period converts both multiples to keep the same offers.
The share of monthly trail expected to continue when the book transfers. Applied once to both offers.
Sale proceeds and payback
Deducted from your valuation only. Enter amounts you expect to pay from sale proceeds, such as fees or debt repayment.
A separate amount for the payback estimate. It stays unchanged when you alter an offer multiple.
Fixed monthly costs of servicing this book. These reduce the buyer's projected receipts.
The annual fall in retained trail after transfer, spread evenly through monthly compounding. New lending is excluded.
Results
Check the marked input to calculate an estimate.
Indicative book value
$360,000.00
At your multiple and retained incomeIndicative sale proceeds
$350,000.00
After entered seller costs and liabilitiesCash payback period
45 months
First recovery of the purchase price, within 30 yearsRetained monthly trail is $10,000.00. The alternative offer values the book at $300,000.00.
Income and retention sensitivity
Gross values before seller deductions. Your multiple is 3× annual income; the alternative is 2.5×.
| Retained | Monthly trail | Your multiple | Alternative |
|---|---|---|---|
| 100% | $10,000.00 | $360,000.00 | $300,000.00 |
| 90% | $9,000.00 | $324,000.00 | $270,000.00 |
| 80% | $8,000.00 | $288,000.00 | $240,000.00 |
Net receipts against purchase price
Cumulative cash after fixed monthly costs. The table shows selected years; CSV includes every month.
Cumulative net receipts after one year: $96,000.00. Purchase price: $360,000.00. Payback: 45 months.
| Year | Trail received | Costs | Net receipts | Cumulative net |
|---|---|---|---|---|
| 1 | $120,000.00 | $24,000.00 | $96,000.00 | $96,000.00 |
| 2 | $120,000.00 | $24,000.00 | $96,000.00 | $192,000.00 |
| 3 | $120,000.00 | $24,000.00 | $96,000.00 | $288,000.00 |
| 4 | $120,000.00 | $24,000.00 | $96,000.00 | $384,000.00 |
| 5 | $120,000.00 | $24,000.00 | $96,000.00 | $480,000.00 |
| 10 | $120,000.00 | $24,000.00 | $96,000.00 | $960,000.00 |
| 15 | $120,000.00 | $24,000.00 | $96,000.00 | $1,440,000.00 |
| 20 | $120,000.00 | $24,000.00 | $96,000.00 | $1,920,000.00 |
| 25 | $120,000.00 | $24,000.00 | $96,000.00 | $2,400,000.00 |
| 30 | $120,000.00 | $24,000.00 | $96,000.00 | $2,880,000.00 |
The starting figures are hypothetical. Choose multiples from the offers you want to compare. This calculator does not set a market multiple or a formal valuation.
Use one GST basis throughout. Payback excludes tax, finance costs and resale proceeds. Seller deductions affect sale proceeds only. Monthly operating costs affect payback only.
Receipts arrive at each month end. Initial retention applies before month one, and runoff begins in month two. Costs remain fixed for 30 years. PDF opens your browser's print dialog.
Valuing Recurring Trail
An income multiple values a trail book by multiplying recurring trail by the chosen multiple for the same income period. This calculator first applies your expected retention to monthly trail. An annual multiple then uses twelve times that retained monthly amount.
In the hypothetical starting example, $10,000 of monthly trail at 100% retention gives $120,000 of annual trail. A 3× annual multiple produces a $360,000 indicative value. A 36× monthly multiple produces the same value. Switching the income period converts both multiples automatically.
The correct annual calculation is $10,000 × 12 × 3 = $360,000. The incorrect calculation, $10,000 × 3 = $30,000, mixes monthly income with an annual multiple. Keep the income basis beside each offer before comparing its headline number.
The example multiples are assumptions, not quoted market rates. Business.gov.au's valuation guidance explains that buyers and sellers can use different valuation methods. This tool models a recurring-income multiple, with the rate you enter.
Comparing Offers and Retention Assumptions
Compare offers on the same retained income and time period. At $10,000 a month and full retention, the example 3× annual offer is $360,000. The alternative 2.5× annual offer is $300,000, a difference of $60,000.
If only 90% of that income transfers, retained monthly trail falls to $9,000. The same offers become $324,000 and $270,000. At 80% retention, they fall to $288,000 and $240,000. The sensitivity table changes both offers together so a higher multiple cannot hide a lower income assumption.
This calculator uses your totals to compare scenarios. A buyer's due diligence examines the underlying records and transfer terms. Business Victoria's buying guidance separates this financial assessment from the seller's asking price.
For analysis of your actual commission reports, Track My Trail's Trail Book Valuation grades each active loan and checks the book against a discounted cash flow view. Elite Suite produces a three-page report with an anonymised loan schedule to support the valuation conversation.
Reading the Valuation Result
Indicative sale proceeds equal your calculated book value less the seller costs and liabilities you enter. In the starting example, $360,000 less $10,000 gives $350,000 before tax. Enter only amounts you expect to deduct from your proceeds, such as transaction fees or debt you will repay.
A negative result means those entered deductions exceed the indicative value. The calculator keeps that shortfall visible. It does not decide which liabilities transfer to a buyer or when a deferred payment becomes payable.
Assess transfer consent, deferred consideration and any retention-linked price adjustment against the proposed agreement. The gross value assumes the retained income you enter. A later price adjustment needs a separate scenario, so you avoid counting the same income loss twice.
Purchase Price and Payback Period
Cash payback is the first month when accumulated net receipts reach the separate purchase price you enter. Each month's retained trail, less fixed operating costs, adds to that total. Seller costs do not reduce the buyer's purchase price automatically.
With the starting figures, $10,000 of monthly trail less $2,000 of monthly costs leaves $8,000. A $360,000 purchase price takes 45 month-end receipts to recover. The 3× annual income multiple becomes a 45-month cash payback because operating costs reduce the cash received.
Initial retention applies once, before the first receipt. Annual runoff then reduces income through equal monthly compounding. For example, 10% annual runoff puts month 13's trail at 90% of month one's trail. New lending adds nothing to this projection, and operating costs remain fixed.
The calculation rounds monthly receipts and costs to cents before adding them. It reports the first whole month of recovery, with immediate recovery for a zero purchase price. If receipts never reach the price within 360 months, the result says “Not reached”. Later losses can reduce cumulative cash after an earlier recovery.
Payback measures undiscounted cash recovery. It excludes financing, resale proceeds and the buyer's tax position. Use the receipts table to see whether later runoff leaves enough trail to cover the costs you entered.