Connecting premium targets to sales capacity and runway
A commission-based insurance intermediary needed an annual premium ambition to translate into retained and new business, required sales capacity, acquisition economics, operating costs, financing and monthly cash. The full premium volume also had to remain distinct from the commission revenue the business actually earned.
The roll-forward separates recurring premium from the new production required in each planning period.
Premium productivity converts the commercial target into required sales headcount and deal activity.
Client value is compared with sales payroll, fixed acquisition activity and variable commission costs.
Operating overhead, funding and regulatory-capital needs share one timing-aware cash forecast.
WHY THIS WASN’T A TEMPLATE EXERCISE
The model had to respect
how the business actually moved.
The reconstructed model turns premium targets into sales-team and client requirements, then carries commission economics, seasonality, funding and capital constraints through integrated statements, runway and valuation.
Premium volume was not company revenue
The business earned a commission share of placed premium. Treating total premium as revenue would overstate both the top line and the resources available to support growth.
A sales target carried its own operating cost
Raising the premium ambition could increase the salespeople, deal activity, payroll and commissions needed to deliver it. Those consequences had to update together rather than sit in disconnected assumptions.
Annual acquisition economics met monthly cash timing
CAC and LTV were evaluated annually, but premium production, commission income and costs still arrived unevenly. Seasonality therefore mattered when the same plan was translated into cash runway.
Headline funding was not free operating cash
Operating overhead and sales investment shared the timeline with financing and regulatory-capital requirements. The useful question was the minimum cash left after all of them, not simply the amount raised.
MODEL ARCHITECTURE
From operating activity
to a decision-ready view.
Each layer has one job. Together they keep the commercial story, unit economics and cash consequences on the same timeline.
Driver dashboard
A compact input layer controls premium productivity, retention, deal size, compensation, commission rates, fixed-cost scaling and financing assumptions.
Premium roll-forward
Retained premium from existing clients combines with the new-premium target to produce total placed volume without confusing that volume with revenue.
Capacity-linked headcount
Premium production per salesperson converts the target into required sales capacity, additions and payroll while other roles remain independently planned.
Client bridge
Average deal size, orders per client and retention translate premium into existing, lost, retained and newly required client volumes.
Acquisition economics
Sales payroll, fixed acquisition activity and variable commission costs reconcile before CAC is compared with client lifetime value.
Monthly operating forecast
Seasonality distributes annual premium economics across commission revenue, direct costs, payroll, overhead and cash timing.
Funding and capital constraints
External financing, regulatory capital and other capital movements feed the same timeline used to measure minimum cash headroom and potential cash exhaustion.
Statements and valuation
Income statement, balance sheet and cash flow outputs reconcile the operating case before free cash flow extends it into a valuation view.
WHAT THE ANALYSIS SURFACED
Useful answers,
without exposing client data.
The takeaways are intentionally qualitative. Exact assumptions, calculations and outputs remain inside the confidential client model.
The premium target and sales plan were one assumption
A more ambitious target was credible only when the productivity assumption produced an affordable team and a feasible level of new client activity.
Retention reduced more than acquisition pressure
A stronger retained-premium base reduced the new volume, client wins, selling effort and cash investment needed to reach the same total premium objective.
A healthy annual ratio could still hide a cash squeeze
LTV-to-CAC could look acceptable while seasonal revenue timing, payroll and regulatory capital pushed monthly headroom toward a critical point.
Runway belonged downstream of the full operating plan
Funding became decision-useful only after sales hiring, commissions, fixed costs and capital requirements had reached the same cash schedule.
MODELING APPROACH
The working system
behind the answer.
- Premium retention and new-production roll-forward
- Sales productivity, deal activity and capacity plan
- Dynamic sales-headcount and payroll schedule
- Client retention, loss and new-business bridge
- CAC, LTV and acquisition-cost analysis
- Commission-revenue and direct-cost schedules
- Seasonal monthly operating and cash forecast
- Funding, regulatory-capital and runway controls
- Integrated statements and discounted-cash-flow view
CASE CONFIDENTIALITY
This anonymized case explains the premium, sales-capacity, retention, acquisition-cost, commission, operating-cost, funding, regulatory-capital, runway and valuation logic without naming the client, company, individuals, market or dates. Exact premiums, retention, deal sizes, staffing, compensation, commissions, expenses, funding, capital, forecast and valuation inputs remain private because client work can be confidential or NDA-protected. No source document, workbook screenshot, chart, formula, logo, model name or identifying interface is reproduced. The illustration is an original fictional insurance-placement ecosystem rather than a real office, underwriting network, client journey, deliverable or operating result.