How to Build a 5-Year Financial Model for a Pet Insurance MGA
How to Build a 5-Year Financial Model for a Pet Insurance MGA
A financial model is not just a spreadsheet exercise it is your primary tool for stress-testing the economics of your pet insurance MGA before committing capital. Carriers evaluate your financial projections to assess whether you understand the insurance economics. Investors use them to gauge returns and risk. Your management team uses them for operational planning and benchmarking.
This guide walks through each component of a robust 5-year pro forma financial model for a pet insurance MGA.
What Are the Core Components of an MGA Financial Model Architecture?
A well-structured pet insurance MGA financial model consists of a revenue side and a cost side that together determine your path to profitability. Understanding the interplay between ceding commissions, profit-sharing income, management fees, and operating expenses is essential for building projections that carriers and investors will find credible.
1. Revenue Side
The revenue model for a pet insurance MGA has four primary components:
1. Ceding Commission Income
This is the primary revenue stream. The fronting carrier pays the MGA a percentage of gross written premium (GWP) to cover distribution, administration, and operating costs.
| Commission Component | Typical Range |
|---|---|
| Base override commission | 25–30% |
| Claims handling fee (if applicable) | 3–7% |
| Total ceding commission | 28–35% |
2. Profit-Sharing Income
Most binding authority agreements include profit-sharing provisions. If the program's loss ratio runs below a defined corridor, the MGA receives a share of underwriting profit.
Example structure:
- Loss ratio corridor: 60–65%
- MGA share of profit below corridor: 25–40%
- Measurement period: Annual, subject to development
3. Management Fees
Some MGAs charge flat or per-policy fees for specific administrative services, providing stable revenue less dependent on premium volume.
4. Technology and Service Fees
MGAs with proprietary technology may generate additional revenue from API access fees, integration fees, or white-label platform licensing.
2. Cost Side
Operating Expenses
| Category | Year 1 (% of GWP) | Steady State (% of GWP) |
|---|---|---|
| Personnel | 15–25% | 8–12% |
| Technology | 8–15% | 3–6% |
| Distribution / Marketing | 10–20% | 5–10% |
| Compliance / Legal | 3–5% | 1–2% |
| General & Administrative | 3–5% | 2–3% |
| Total Expenses | 40–70% | 20–33% |
Note: Year 1 percentages appear high because premium volume is low while fixed costs are relatively constant. As GWP grows, the expense ratio improves significantly.
How Do You Build Accurate Premium Projections?
Premium projections form the foundation of your entire financial model and should be built from the bottom up using policy count assumptions, average premium by tier, and retention rates. A credible premium model demonstrates to carriers and investors that you understand customer acquisition dynamics and realistic growth trajectories.
1. Policy Count Model
Build your premium projections from the bottom up:
-
Estimate monthly policy acquisition by channel
- Direct-to-consumer: Website conversions, paid search, social media
- Partnerships: Veterinary clinics, pet retailers, shelters
- Embedded: Platform integrations, employer benefits
- Agent/broker: Independent agent appointments
-
Apply average premium by product tier
| Product Tier | Avg Monthly Premium (Dog) | Avg Monthly Premium (Cat) |
|---|---|---|
| Accident-Only | $15 | $10 |
| Accident & Illness | $50 | $30 |
| Comprehensive + Wellness | $75 | $45 |
-
Model retention and lapse
- First-year retention: 75–82%
- Renewal retention: 85–92%
- Model monthly lapse patterns, heavier in months 2–6
-
Calculate in-force count and earned premium
2. Sample Premium Trajectory
| Year | New Policies | Year-End In-Force | Annual GWP |
|---|---|---|---|
| Year 1 | 3,000 | 2,400 | $1.8M |
| Year 2 | 8,000 | 8,200 | $6.2M |
| Year 3 | 15,000 | 18,500 | $15.5M |
| Year 4 | 22,000 | 33,000 | $28.0M |
| Year 5 | 28,000 | 50,000 | $45.0M |
These figures assume a multi-channel distribution strategy with an average annual premium of approximately $600 (mix of dog and cat, primarily accident and illness).
How Should You Model Loss Ratios for a Pet Insurance Program?
Loss ratios are the single most important variable in your financial model, directly determining whether your MGA program achieves underwriting profitability. For pet insurance, loss ratios vary significantly by product tier, portfolio seasoning, and underwriting discipline, and modeling them accurately requires understanding both claim frequency and severity trends.
1. Loss Ratio Assumptions
Loss ratios for pet insurance programs vary by product type, seasoning, and underwriting discipline:
| Product Tier | Year 1 | Year 2 | Steady State |
|---|---|---|---|
| Accident-Only | 50–60% | 45–55% | 40–50% |
| Accident & Illness | 65–75% | 60–68% | 55–65% |
| Comprehensive + Wellness | 70–80% | 65–75% | 60–70% |
Key factors affecting loss ratios:
- Adverse selection in early portfolio (new programs attract higher-risk pets)
- Waiting period benefits reduce first-year claims
- Underwriting guideline effectiveness
- Veterinary cost inflation (8–12% annually)
- Claims management efficiency and fraud control
2. Loss Development
Pet insurance claims typically develop quickly most claims are reported and settled within 30–90 days. However, model a small tail for complex medical cases and disputed claims.
For reinsurance structures, include ceded premium and recovered losses in your model.
What Drives the Expense Ratio in an MGA Financial Model?
The expense ratio measures your operating costs as a percentage of gross written premium, and improving it over time is critical to achieving a profitable combined ratio. In the early years, fixed costs dominate the expense structure, but as premium volume scales, the expense ratio compresses significantly making growth both a revenue driver and an efficiency lever.
1. Fixed vs Variable Costs
Categorize expenses as fixed or variable to understand breakeven dynamics:
Fixed Costs (relatively constant regardless of premium volume):
- Core team salaries
- Technology platform licenses
- Office and infrastructure
- Compliance and legal retainers
- Insurance (E&O, D&O)
Variable Costs (scale with premium or policy count):
- Customer acquisition costs
- Claims processing costs per claim
- Payment processing fees
- Per-policy administration costs
2. Expense Ratio Improvement
As premium volume grows, fixed costs become a smaller percentage of GWP:
| Year | Fixed Costs | Variable Costs | Total Expense Ratio |
|---|---|---|---|
| Year 1 | 35% | 15% | 50% |
| Year 2 | 18% | 14% | 32% |
| Year 3 | 12% | 13% | 25% |
| Year 4 | 9% | 12% | 21% |
| Year 5 | 7% | 11% | 18% |
How Do Combined Ratio and Profitability Evolve Over Five Years?
The combined ratio calculated as loss ratio plus expense ratio is the definitive profitability metric for any insurance program. A combined ratio below 100% means the MGA is generating underwriting profit from commission income after paying operating expenses. For pet insurance MGAs, the typical trajectory moves from above 100% in Year 1 to the mid-70s by Year 5 as both loss and expense ratios improve.
1. The Combined Ratio
The combined ratio (loss ratio + expense ratio) is the key profitability metric:
| Year | Loss Ratio | Expense Ratio | Combined Ratio | Operating Result |
|---|---|---|---|---|
| Year 1 | 68% | 50% | 118% | (Loss) |
| Year 2 | 63% | 32% | 95% | Near breakeven |
| Year 3 | 60% | 25% | 85% | Profitable |
| Year 4 | 58% | 21% | 79% | Profitable |
| Year 5 | 57% | 18% | 75% | Profitable |
A combined ratio below 100% means the MGA is generating underwriting profit from commission income after paying operating expenses.
2. Cash Flow Considerations
While the combined ratio drives operating profitability, cash flow timing matters:
- Premium is earned monthly but commission payments may be quarterly
- Claims are paid as incurred but carrier funding may have timing delays
- Profit sharing is typically settled annually on a lagged basis
- Capital expenditures (technology) are front-loaded
What Variables Should You Stress-Test in Sensitivity Analysis?
Sensitivity analysis is essential for demonstrating to investors and carriers that your financial model is robust under adverse conditions. By stress-testing key assumptions like policy acquisition rate, loss ratio, retention, and ceding commission terms, you reveal the breakpoints in your model and quantify how much capital cushion is needed for downside scenarios.
1. Key Variables to Stress-Test
Run scenarios varying these assumptions:
| Variable | Base Case | Conservative | Stress |
|---|---|---|---|
| Policy acquisition rate | As modeled | -30% | -50% |
| Average premium | $600/year | $500/year | $450/year |
| Loss ratio | 60% steady state | 65% | 72% |
| Retention rate | 85% | 78% | 70% |
| Ceding commission | 30% | 27% | 25% |
| Vet cost inflation | 10% | 12% | 15% |
2. Scenario Outcomes
Present three scenarios clearly:
Base Case: Breakeven in month 24, $3M cumulative profit by Year 5 Conservative: Breakeven in month 36, $1M cumulative profit by Year 5 Stress: Breakeven in month 42+, may require additional capital
How Much Capital Does a Pet Insurance MGA Require?
Most pet insurance MGAs require between $850K and $2.1M in startup capital to fund operations from formation through breakeven. This capital covers licensing, technology development, team salaries, marketing launch costs, carrier deposits, and a working capital buffer to absorb timing mismatches between premium collection and commission payments.
1. Use of Funds
Detail how startup capital will be deployed:
| Category | Amount |
|---|---|
| Licensing and regulatory setup | $50–100K |
| Technology platform | $200–500K |
| Team (12-month runway) | $400–800K |
| Marketing and distribution launch | $100–300K |
| Working capital and contingency | $200–400K |
| Total Required | $950K–$2.1M |
For guidance on funding options, see our article on raising startup capital for pet insurance MGAs.
What Are the Best Practices for Presenting Your Financial Model?
Presenting your financial model effectively is as important as building it accurately. Carriers and investors evaluate not just the numbers but how well you communicate assumptions, demonstrate understanding of insurance economics, and address downside risks a well-presented model builds confidence in your management team's financial sophistication.
When presenting your financial model to carriers and investors:
- Start with assumptions — Walk through key assumptions before showing outputs
- Show monthly detail for Year 1–2 — Demonstrate you understand ramp dynamics
- Annual summary for Years 3–5 — Show the long-term trajectory
- Include a dashboard — Key metrics at a glance (GWP, loss ratio, combined ratio, in-force count)
- Be conservative — Carriers respect realistic projections over optimistic ones
- Document everything — Every assumption should have a source or rationale
The financial model is a central component of your MGA business plan and should be consistent with all other plan sections.
Frequently Asked Questions
1. What loss ratio should I model for a pet insurance MGA?
Target loss ratios typically range from 55–65% for mature programs. New programs may run 65–75% in the first year due to limited data and adverse selection, improving as the book seasons.
2. When do pet insurance MGAs typically reach breakeven?
Most well-capitalized pet insurance MGAs reach operating breakeven in 18–36 months, depending on premium growth rate, initial expense structure, and carrier commission terms.
3. What ceding commission should I assume from a fronting carrier?
Ceding commissions for pet insurance MGA programs typically range from 25–35% of gross written premium, varying based on the scope of delegated authority, claims handling responsibility, and program size.
4. How much capital does a pet insurance MGA need before reaching profitability?
Most pet insurance MGAs require $800K–$2M in capital to fund operations through breakeven, including licensing, technology, team, marketing, and working capital.
5. What is a good combined ratio target for a pet insurance MGA?
A mature pet insurance MGA should target a combined ratio below 85%, with loss ratios of 55–65% and expense ratios of 18–25%. Programs exceeding a 100% combined ratio are operating at an underwriting loss.
6. How should I model veterinary cost inflation in my financial projections?
Veterinary cost inflation should be modeled at 8–12% annually, which is significantly higher than general CPI. This affects both claim severity projections and premium rate increase assumptions in your model.
7. What premium growth rate is realistic for a new pet insurance MGA?
Realistic premium growth for a new MGA is 200–400% in Year 2, moderating to 50–80% by Year 4–5. Carriers and investors are skeptical of projections showing more than $50M GWP within the first five years without a proven distribution advantage.
8. Should I include profit-sharing income in my base case financial model?
Include profit-sharing income in your upside scenario but not your base case. Profit sharing is contingent on favorable loss experience and typically lags by 12–18 months, making it unreliable for early-stage cash flow planning.
External Sources
Internal Links
- Explore Services → https://insurnest.com/services/
- Explore Solutions → https://insurnest.com/solutions/
