ERErgeon Financial Model
InsurTech Startup Financials (Free Excel Download)
Tech-enabled residential outdoor construction company (fences, hardscaping) that owns the full consumer-to-contractor-to-materials value chain.
professionals from Deloitte
Used by professionals from
About this model
Ergeon is a technology-enabled outdoor construction company that manages the homeowner journey from design and quoting through materials, contractor scheduling, installation, and support. It began with fencing and expands into adjacent home-improvement categories.
Revenue comes directly from materials and installation projects rather than a software fee. Its technology automates local pricing, permits, design, supply chain, and operations, with future recurring products such as financing and insurance attached to customer relationships.
The model is a project-revenue P&L. Leads, conversion, projects, average price, material cost, contractor labor, CAC, and geographic rollout determine revenue and contribution margin. Operational efficiency and repeat product attachment drive profitability.
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 Ergeon
ergeon.com
How to build a detailed financial model for Ergeon
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Ergeon model - distilled from its pitch deck and publicly available information.
Product & value proposition
- Outdoor home construction (initially fencing, then adjacent products - stated 2→5-6 products).
- End-to-end ownership: remote design & measurement, transparent pricing, 3D visualization, supply chain, quality assurance, contractor management.
- Tech stack automates zipcode-level data (permits, regulations, pricing, material specs) and all workflow steps (lead → quote → design → materials → schedule → install → billing → feedback).
- Fence price example: ~$49/ft (material + installation).
- 20% below retail rates on materials (e.g., lumber).
- 24/7 global remote workforce supports automated workflows.
Market
- US Construction market: $1.5T
- Residential Construction (inc. Home Improvement): $700B
- Market structure: 700K+ firms, 1M+ labor shortage, 1M+ small businesses, 68% of contractor time spent on admin work.
- SAM / SOM: Not explicitly stated. Company claims #1 outdoor construction in Northern CA with 10–15% market share in fence across 16 MSAs.
- Long-term vision: $10B+ revenue topline in 5 years.
Revenue model
- Primary revenue: Project revenue = materials + installation, sold direct to homeowners at ~$49/ft (fence).
- Future revenue streams (zero incremental CAC): materials supply, financing, insurance - described as recurring revenue attached to the customer relationship.
- Lead generation channels: Google, Facebook, Instagram, Yelp, Nextdoor, Thumbtack, Porch, HomeAdvisor.
- Strong organic/word-of-mouth component (xx% organic revenue - redacted).
- Geographic expansion model: remote launch within 50-mile radius; fly-in launch manager + local field manager.
- Contractors are partners (not employees), paid via platform; zero contractor churn claimed.
Traction & metrics
NOTE: This deck is a redacted/sanitized version. All specific financial figures are replaced with "xx" or "$xxM" placeholders. No concrete revenue, growth rate, CAC, or volume numbers are legible.
Structural facts that are visible:
- Operating in 16 MSAs as of April 2022.
- #1 outdoor construction company in Northern CA.
- 10–15% market share in fence in Northern CA.
- 2x scale of the largest local competitor; described as catching up with Home Depot in 2 years.
- Home Depot reference: market cap $300B+, larger than Airbnb + Uber + DoorDash combined.
- #1 on "all main review sites in all markets."
- Targets $xxM run-rate bookings by Q2 2024 (redacted).
- CAGR 2022–2024 target: redacted.
Unit economics
- Current unit economics: $/project waterfall chart placeholder (all values redacted).
- Claim: Profitable on first purchase net of CAC (profit = $xx+ per project).
- Future unit economics: $/project chart placeholder (all values redacted); materials/financing/insurance add recurring revenue at $0 CAC.
- Marketing CAC: shown as $/project metric on slide 10, but value is redacted.
- No LTV, payback period, or gross margin % figures visible.
Competition / moat
- Fragmented market: 700K+ firms, 1M+ small businesses - no scaled national incumbent in outdoor residential.
- Moat claims:
- Proprietary zipcode-level data engine (permits, regs, pricing, specs).
- Supply chain advantage: 20% below retail on materials.
- Brand / organic growth: #1 on review sites, viral neighborhood growth.
- Contractor loyalty: "zero contractor churn," 10x growth potential per contractor.
- Technology: modularized + automated workflows, 24/7 global remote workforce - first scalable model in the category.
- Named competitors: Home Depot (indirectly). No direct startup competitors named.
Team & funding ask / use of funds
- Jenny He - Founder & CEO, PhD (Princeton). Prior: McKinsey, ezhome, CA Dept of Consumer Affairs / Contractors State License Board.
- Odysseas Tsatalos - Founder & CTO, PhD (University of Wisconsin-Madison). Prior: Sage Intacct, ezhome, Upwork.
- Both founders previously co-founded ezhome. Framing: "Upwork transformed office workers; we do it for deskless workers."
- Funding ask: "$xxM investment to reach profitability" - amount redacted.
- Use of funds: Not detailed in deck.
- Total capital spend to date: $xxM (redacted).
Recommended financial model
- Archetype + why: Vertically integrated home services / project revenue P&L, with a unit-economics driver tree. This is a project-based business (not SaaS, not pure marketplace) - revenue = projects × ASP, with materials COGS + labour COGS + CAC driving per-project economics. The future recurring revenue layer (materials, financing, insurance) adds a small attach-rate revenue stream. Closest archetype: DTC/services 3-statement model with project-level unit economics build and geographic cohort expansion.
- Forecast horizon & granularity: Monthly for Year 1–2 (2022–2024, matching the Q2 2024 target stated in deck), quarterly for Year 3–5. 5-year total horizon.
- Key drivers & assumptions:
- Scenarios (Base / Bull / Bear - which variables flex):
- Base: MSA expansion at stated pace; organic % holds; ASP flat; attach rate grows slowly.
- Bull: Faster MSA rollout; attach rate accelerates (materials + financing); supply chain advantage expands margin; CAC falls via organic compounding.
- Bear: MSA expansion slows (field manager hiring bottleneck); lumber/materials inflation compresses margin; organic share declines; CAC rises.
- Required sheets / outputs:
- Assumptions - all drivers in one place, tagged or
- MSA Expansion Schedule - launch dates, ramp curves per cohort
- Project Volume Build - MSAs × projects/MSA/month
- Revenue Build - projects × ASP by product (fence + adjacencies)
- Unit Economics Waterfall - Revenue → Materials COGS → Labour COGS → Gross Profit → CAC → First-purchase net profit
- Attach Revenue - materials/financing/insurance on existing customer base
- P&L (Income Statement) - monthly/quarterly
- Headcount & Opex - by function
- Cash Flow & Runway - capital spend to profitability
- Scenario Toggle - Base / Bull / Bear
- Summary KPI Dashboard - revenue, projects, MSAs, gross margin %, net profit/project, cash
Frequently asked
Is the Ergeon financial model free?+
Yes. The Ergeon 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 Ergeon'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.
