SOSofia Financial Model
InsurTech Startup Financials (Free Excel Download)
Digital-native health insurance provider targeting Mexico's underinsured middle class via a direct-to-consumer app.
professionals from Deloitte
Used by professionals from
About this model
Sofia is a digital health-insurance provider for Mexico's underinsured middle class. Its app combines plan enrollment, care navigation, telemedicine, personal assistance, claims, and access to a curated provider network.
The direct-to-consumer model earns gross written premiums, with annual pricing of roughly $300–$500 per member and benefits designed around primary and secondary care. The digital channel avoids broker intermediaries and creates a direct member relationship.
The model is health-insurance PMPM. Members, annual premium, risk pool, claims or medical-loss ratio, co-pays, provider costs, acquisition, and retention determine profitability. Care navigation and underwriting quality are central levers.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
About Sofia
How to build a detailed financial model for Sofia
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Sofia model - distilled from its pitch deck and publicly available information.
Product & value proposition
- Health plan combining insurance coverage with a mobile app for care navigation.
- Three pillars: Simple (digital-first app UX), Close to users (no intermediaries, direct relationship through full medical journey), Complete (preventive + primary + major/secondary care).
- Customer journey: Subscribe via app → video consult / find care in directory → chat with personal assistant → review plan and claims.
- Closed provider network: 80+ specialists, 6 hospitals (San Angel Inn), 2 outpatient surgery clinics (Servicura), 1 maternity clinic (Reina Madre), labs & imaging (Salud Digna, Chopo).
- Video-consult doctors on payroll; secondary care specialists on fee-for-service.
- Medical strategy: Episode-based care, standardized procedures, outcome measurement over fee accumulation.
Market
- Total healthcare market in Mexico: ~$65B USD, 50/50 public/private split → private market ~$32.5B USD.
- Only 9% of private health spend in Mexico flows through insurance (vs. 64% in the US, 61% in France, 39% in Germany).
- Current private health insurance market (Mexico, 7% population insured): ~$4B USD.
- Latent / addressable market if Mexico reaches Brazil-level penetration (26%): ~$11B USD.
- Latent / addressable market if Mexico reaches Ireland-level penetration (50%): ~$25B USD.
- Demand signal: 58% of uninsured respondents said they would buy insurance on top of public coverage; 40% cited cost as primary barrier, 20% lack of knowledge, 9% never offered one, 4% distrust.
Revenue model
- Revenue = Gross Written Premiums (GWP): annual premium per member $300–$500 USD/person.
- Plan includes primary and secondary care tiers with co-payments and co-insurance (cost-sharing reduces net claims cost).
- Sum insured per member: $50k–$75k USD.
- Distribution: 100% direct-to-consumer via mobile app; no broker intermediaries.
- One app UI screenshot shows a price of $600/month (MXN implied, ~$30–35 USD/mo) and a sum insured of $1,500,000 (MXN, ~$75k USD) - consistent with slide 11 figures.
Traction & metrics
- No revenue, member count, growth rate, or retention figures disclosed.
- No premium volume or GWP to date shown.
- Investors named: Ribbit Capital, Cavalry Ventures, Kaszek Ventures. Amount raised: Not in deck.
Unit economics
- Annual premium per member: $300–$500 USD.
- Sum insured: $50k–$75k USD.
- Co-payments apply to primary care; co-insurance applies to secondary care (reduces gross claims exposure).
- Medical cost structure: Video-consult doctors on payroll (fixed cost); secondary care specialists on fee-for-service (variable).
Competition / moat
- Incumbents: Agent/broker-dependent, generic mass-market messaging, yearly cost structure, no direct customer relationship.
- Sofia's differentiation: DTC ownership of customer relationship, one-off acquisition cost structure, data-driven digital marketing, market-expanding (education-led) approach.
- Closed provider network as a managed-care moat: controls quality and cost through preferred partnerships.
- Episode-based care model vs. fee-for-service status quo.
Team & funding ask / use of funds
- Existing backers: Ribbit Capital, Cavalry Ventures, Kaszek Ventures.
Recommended financial model
- Archetype + why: Insurance GWP / P&L model (insurer operating model). Sofia is a risk-bearing health insurer, so the core model must track GWP, net earned premium, loss ratio, expense ratio, and combined ratio - not a simple SaaS ARR model. The DTC channel and closed-network medical cost structure add a member-economics layer on top.
- Forecast horizon & granularity: 5-year annual model (Year 1–5), with Year 1 monthly for cash/solvency monitoring. Monthly is important early given regulatory capital requirements typical for insurers.
- Key drivers & assumptions:
| Driver | Value / Source |
|---|---|
| Annual premium per member (low) | $300 USD |
| Annual premium per member (high) | $500 USD |
| Base premium (midpoint) | $400 USD midpoint of deck range |
| Sum insured per member | $50k–$75k USD |
| Mexico private health insurance market (current) | ~$4B USD |
| Mexico latent market (Brazil parity) | ~$11B USD |
| Mexico latent market (Ireland parity) | ~$25B USD |
| Member growth - Year 1 members | 1,000 members; pre-commercial stage |
| Member growth rate (Y2–Y5) | 100–200% YoY early, decelerating to 40–60% by Y5; DTC insurtechs in LatAm comparable |
| Target loss ratio (medical cost ratio) | 65–75%; closed network + co-pay/co-insurance should keep claims below open-market norms; industry comparable Oscar Health ~80–85% early, managed-care targets ~70% |
| Video-consult cost per member/yr | fixed payroll allocation; modeled as % of GWP ~10–15% |
| Secondary care fee-for-service cost | variable, included within loss ratio |
| Acquisition cost (CAC) | $50–$150 USD/member; DTC digital; no broker commission saves 10–20% of premium vs. incumbents |
| Gross margin (GWP – claims – acquisition) | target 15–25% at scale; early years negative |
| Reinsurance cost | 10–15% of GWP ceded; typical for small insurer limiting peak risk |
| Regulatory capital requirement | per CNSF (Mexico) solvency rules; not quantified in deck |
| Churn / annual lapse rate | 15–25%; health insurance lapse in emerging markets; no deck data |
- Scenarios (Base / Bull / Bear - which variables flex):
- Bear: Slow member acquisition (40% YoY), loss ratio 80%, CAC $150, premium at $300.
- Base: 100% member growth YoY for 3 years then 60%, loss ratio 72%, CAC $100, premium at $400.
- Bull: 200% member growth for 2 years then 80%, loss ratio 65%, CAC $60, premium at $500; faster unit-economics improvement from network scale.
- Required sheets / outputs:
- Assumptions - all drivers, scenario toggle (Base/Bull/Bear).
- Member Roll - beginning members, new, churned, ending; average members in period.
- Income Statement (P&L) - GWP, ceded premium (reinsurance), net earned premium, claims (loss ratio × NEP), acquisition costs, operating expenses (tech, payroll, G&A), EBIT, taxes, net income.
- Loss & Expense Ratios - combined ratio waterfall.
- Cash Flow - operating CF, capex, funding rounds (placeholder); runway.
- Balance Sheet (simplified) - cash, reinsurance recoverables, deferred premiums, claims reserves, equity / regulatory capital.
- Unit Economics - LTV (NPV of premium stream × margin), CAC, LTV/CAC, payback months.
- Market Sizing - TAM/SAM/SOM build from deck figures.
- Dashboard - KPI summary (members, GWP, combined ratio, cash runway).
Frequently asked
Is the Sofia financial model free?+
Yes. The Sofia model is a free Excel (.xlsx) download with live formulas. Sign up with your email and the workbook is yours to keep, review, and edit.
What's included in the model?+
A 5-year monthly forecast with P&L, cash flow and runway, valuation (exit multiple plus a DCF cross-check), MOIC/IRR returns, and unit economics, with live formulas throughout.
How was this model built?+
It was built from Sofia's pitch deck and publicly available information, then structured to investment-banking standards as a fully editable Excel model.
Can I change the assumptions?+
Yes. You can change assumptions and the live formulas will recalculate in the downloadable Excel model.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other InsurTech Startup Financial Models
Browse another startup in the same category.
Ark Kapital
AI-powered precision lending platform for European tech startups, providing non-dilutive growth loans using real-time raw data analytics.
Battleface
Tech-enabled travel insurance platform covering high-risk and non-standard destinations globally, sold direct and via B2B2C partners.
Beam
Digital-first dental insurance company selling group dental (and ancillary) benefits to employers via brokers
Branch
Tech-enabled home & auto insurance company operating as a reciprocal exchange, selling bundled policies via embedded, direct, and agency channels.
Cachet
B2B2C insurtech marketplace offering flexible, usage-based insurance products to gig/platform economy workers via partnerships with ride-hailing, delivery, and gig platforms.
Caura
Mobile app that aggregates all car-related payments (parking, congestion/ULEZ, tolls, tax, insurance) into a single platform, with insurance comparison as a key monetisation layer.
Clark
Digital insurance broker (Makler) providing a robo-advisor + human expert hybrid platform to manage and purchase all insurance lines via mobile app
Counterpart
Digital MGA (managing general agent) selling D&O and management liability insurance to US SMEs via a tech-enabled underwriting platform.
