Reinsurance

Reinsurance Broker Revenue Forecasting: A Worked Model

On this page

Last reviewed: November 2026

The budget pack is due to the board, and the brokerage line is one number in a spreadsheet nobody can explain.

Producers say the book will grow, finance says rates are falling, and both are using different expiring premiums.

Reinsurance broker revenue forecasting is estimating next year's brokerage income from the treaties a broker expects to renew, treaty by treaty.

The fix is a driver model: one row per treaty, six named inputs, and a forecast you can test against actual results every quarter.

Key Takeaways

  • Forecast treaty by treaty, not book by book. A single growth rate hides which renewals carry the risk.
  • Use separate drivers for rate and exposure. They move for different reasons and need different owners.
  • Quota share brokerage follows the cedent's premium. Excess of loss rate indices do not drive it.
  • Weight by probability, then stress the downside. A weighted total is an average, not a prediction.
  • Back-test every year by driver. Variance by cause shows which assumption keeps missing.

What Is the Formula for Reinsurance Broker Revenue Forecasting?

The formula for reinsurance broker revenue forecasting multiplies six treaty-level drivers together, then sums the results across the book.

Forecast brokerage = expiring premium × (1 + rate change) × (1 + exposure change) × brokerage % × renewal probability × FX rate

DriverWhat it meansWhere it comes fromWho owns it
Expiring premiumPremium on the share placed through you at the last renewalSigned placement and technical accountsFinance
Rate changeExpected price movement on like-for-like coverProducer view, checked against market indicesHead of Broking
Exposure changeChange in limit, subject premium or ceded volumeCedent plans and renewal submissionProducer
Brokerage %Agreed brokerage on the placementSlip or terms of businessFinance
Renewal probabilityChance the cedent renews through youPipeline stage and relationship viewHead of Broking
FX rateTreaty currency to reporting currencyBudget rate set by financeCFO

Our guide to reinsurance brokerage calculation covers how the brokerage itself is worked out on each account.

Why do excess of loss and quota share treaties need different drivers?

Excess of loss and quota share treaties need different drivers because their premiums move for different reasons.

Excess of loss premium follows the reinsurance price, often a rate on line times the limit bought. A market price fall cuts brokerage directly.

Quota share premium is a share of the cedent's own written premium. Its driver is the cedent's growth and original rate change.

How Does a Worked Renewal-Book Brokerage Forecast Add Up?

A worked renewal-book brokerage forecast adds up treaty by treaty. The four treaties below are illustrative, with budget FX of EUR 1.08 and GBP 1.27 to USD.

TreatyExpiring premiumRateExposureBrokerage %Renewal probability
A: Property cat XLEUR 8,000,000-12%+3%10%90%
B: Motor quota shareGBP 20,000,0000%+8%1.5%95%
C: Marine XLUSD 3,000,000-5%0%12.5%60%
D: Casualty XLUSD 5,000,000+5%+2%10%85%

The -12% on treaty A echoes the Guy Carpenter global property cat rate on line index at 1 January 2026, as reported by Reinsurance News.

How is each treaty's forecast brokerage calculated?

Each treaty's forecast brokerage is calculated in its own currency first, then converted and weighted.

  1. Treaty A: EUR 8,000,000 × 0.88 × 1.03 = EUR 7,251,200. Brokerage at 10% is EUR 725,120, or USD 783,130. Weighted at 90%, it is USD 704,817.
  2. Treaty B: GBP 20,000,000 × 1.08 = GBP 21,600,000. Brokerage at 1.5% is GBP 324,000, or USD 411,480. Weighted at 95%, it is USD 390,906.
  3. Treaty C: USD 3,000,000 × 0.95 = USD 2,850,000. Brokerage at 12.5% is USD 356,250. Weighted at 60%, it is USD 213,750.
  4. Treaty D: USD 5,000,000 × 1.05 × 1.02 = USD 5,355,000. Brokerage at 10% is USD 535,500. Weighted at 85%, it is USD 455,175.

What does the brokerage forecast show in total?

The brokerage forecast shows three numbers the CFO should present together, not one.

ViewUSDHow it is built
Expiring brokerage at budget FX2,120,000864,000 + 381,000 + 375,000 + 500,000
All treaties renew2,086,360783,130 + 411,480 + 356,250 + 535,500
Probability-weighted1,764,648704,817 + 390,906 + 213,750 + 455,175
Downside: treaty C lost1,730,110All-renew total minus 356,250

The weighted total sits about 17% below expiring brokerage. Only 1.6 points of that gap come from rate and exposure; the rest is probability weighting.

A 5% fall in both EUR and GBP would cut the weighted forecast by about USD 54,800, because USD 1,095,723 of it is earned in those currencies.

Which Errors Distort a Reinsurance Brokerage Forecast?

The errors that distort a reinsurance brokerage forecast usually come from applying the right driver to the wrong treaty. The effects below use the worked example.

ErrorWhat happensEffect in the exampleFix
Market rate index applied to a quota shareCeded premium is cut for a price move that does not applyTreaty B brokerage falls by GBP 38,880 if -12% is appliedUse cedent premium growth for proportional treaties
Renewal probability applied to a bound multi-year dealContracted income is discountedIf D were in year two of a two-year term, USD 80,325 is understatedSet probability to 100% for bound years
Brokerage forecast on 100% of the programmeIncome is counted on shares placed by othersOverstates every line where you hold only part of the orderUse the share placed through you
Expiring FX instead of budget FXGrowth looks like FX, or FX looks like growthHides the USD 54,800 FX sensitivityRestate expiring brokerage at budget FX
Deposit premium treated as finalAdjustment brokerage is missed or double-countedDepends on the adjustable XL termsForecast deposit and adjustment separately
Shared brokerage counted grossIncome agreed to a co-broker is booked as yoursDepends on the sharing agreementForecast net of agreed shares

Why is a probability-weighted brokerage total not a prediction?

A probability-weighted brokerage total is not a prediction because every treaty either renews or does not.

Treaty C will deliver USD 356,250 or nothing. The 60% weight produces USD 213,750, a figure that can never actually occur.

Weighting works across a large book. For a small book, or one dominated by a few cedents, the downside case matters more.

How Should Broker CFOs Control the Brokerage Forecast?

Broker CFOs should control the brokerage forecast by giving every driver an owner and testing it against actual results each renewal season.

  • Lock the expiring premium to accounts. Take it from signed placements, not producer memory.
  • Record a reason for every probability under 80%. Tendering, lost relationships or cedent mergers should be named.
  • Split variance into five causes. Rate, exposure, lost or won business, FX and timing.
  • Re-forecast after each renewal date. Replace forecasts with bound results for 1 January, 1 April and mid-year.
  • Track timing separately. Brokerage on instalments and adjustments arrives later than inception.

Pipeline stages from broker renewal pipeline tracking make a sound basis for renewal probabilities.

Quote status from reinsurer quote tracking for brokers tells you when a rate assumption can be replaced with a firm price.

How Does Insurnest Support Broker Revenue Forecasting?

Insurnest Treaty Management supports the data behind the forecast, not the forecast model itself.

It holds a digital record per treaty with structure, terms, participation shares, limits and configured commission formulas, plus amendments and versioning.

That gives finance one structured view of the treaty book to take expiring terms from.

Rate, exposure and probability assumptions, the forecast model and the board pack stay with your finance and broking teams.

Where Can a Broker CFO Start on Next Year's Brokerage Forecast?

A broker CFO can start next year's brokerage forecast by rebuilding last year's forecast in the six-driver format and comparing it with actual brokerage.

  • List your top 20 renewals by brokerage. Fill all six drivers for each one.
  • Separate proportional from non-proportional. Give each group its own rate driver.
  • Mark bound multi-year deals. Remove renewal probability from contracted years.
  • Run the FX test. Show the board the effect of a 5% move in each major currency.

For the accounting side of each placement, see reinsurance broker technical accounting.

Key Terms

  • Renewal book: The treaties a broker placed last year and expects to renew this year.
  • Rate on line: Reinsurance premium as a percentage of the layer limit.
  • Renewal probability: The estimated chance a treaty renews through the same broker.
  • Probability-weighted forecast: Brokerage multiplied by renewal probability and summed across treaties.
  • Variance attribution: Splitting the gap between forecast and actual brokerage into its causes.

Sources

Frequently Asked Questions

What is reinsurance broker revenue forecasting?

Reinsurance broker revenue forecasting is estimating next year's brokerage income from the treaties a broker expects to renew. Each treaty's expiring premium is adjusted for rate and exposure change, multiplied by the brokerage percentage and renewal probability, and converted at a forecast FX rate.

What drives a reinsurance brokerage forecast?

A reinsurance brokerage forecast is driven by five inputs per treaty: expiring premium placed through the broker, expected rate change, expected exposure change, brokerage percentage and renewal probability. A sixth input, the FX rate, converts each treaty's brokerage into the reporting currency.

How do you forecast brokerage income from a renewal book?

To forecast brokerage income from a renewal book, start from each treaty's expiring premium, apply its own rate and exposure change, multiply by the brokerage percentage, weight by renewal probability and convert at a forecast FX rate. Then sum by renewal month and currency.

Should market rate indices be used in a brokerage forecast?

Market rate indices should be used in a brokerage forecast only as a starting assumption. An index is an average, and each treaty renews on its own loss record, structure and cedent appetite, so producers should replace index movements with treaty-level views where they have them.

Why should rate change not be applied to quota share brokerage?

Rate change from reinsurance pricing indices should not be applied to quota share brokerage because quota share ceded premium follows the cedent's own written premium. The forecast driver for a quota share is the cedent's premium growth and original rate change, not the excess of loss market.

How does FX affect reinsurance broker revenue forecasting?

FX affects reinsurance broker revenue forecasting because brokerage is earned in each treaty's currency but reported in one currency. In the worked example, a 5% fall in both EUR and GBP against USD reduces the probability-weighted forecast by about USD 54,800.

Does a probability-weighted brokerage forecast predict any single treaty?

A probability-weighted brokerage forecast does not predict any single treaty. Each treaty either renews or not, so the weighted figure is a portfolio average. Broker CFOs should also show a downside case that removes the treaties most at risk.

How should a broker test last year's brokerage forecast?

A broker should test last year's brokerage forecast by splitting the gap between forecast and actual into rate, exposure, lost or won business, FX and timing. Repeating the split each year shows which assumption is consistently too optimistic.

Hitul Mistry

Hitul Mistry

CEO, Insurnest

An InsurTech leader with more than a decade of experience across insurance and technology, focused on solving business problems with the help of technology. Has worked with brokers, insurance carriers, and reinsurance firms across the India, UAE, and US markets.

View LinkedIn profile →
ShareLinkedInX

Read our latest blogs and research

Featured Resources

Reinsurance

Broker Renewal Pipeline Tracking: T-180 Days to Inception

Broker renewal pipeline tracking from T-180 days to inception: what happens at each stage, who acts, what breaks and how to score every reinsurance renewal.

Read more
Reinsurance

Reinsurance Brokerage Calculation: Bases, Rates and Checks

Reinsurance brokerage calculation explained for finance teams: pick the right premium base, apply signed shares, handle adjustments and avoid double deductions.

Read more
Reinsurance

Reinsurance Broker Technical Accounting Without Errors

Reinsurance broker technical accounting fails quietly. Follow a hypothetical signed-line error from placement to payout, its root causes and controls to test.

Read more

Meet Our Innovators:

We aim to revolutionize how businesses operate through digital technology driving industry growth and positioning ourselves as global leaders.

circle basecircle base
Pioneering Digital Solutions in Insurance

Insurnest

Empowering insurers, re-insurers, and brokers to excel with innovative technology.

Insurnest specializes in digital solutions for the insurance sector, helping insurers, re-insurers, and brokers enhance operations and customer experiences with cutting-edge technology. Our deep industry expertise enables us to address unique challenges and drive competitiveness in a dynamic market.

Get in Touch with us

Ready to transform your business? Contact us now!

We respond within one business day.