Dandelion Energy Financial Model
Climate/Energy Startup Financials (Free Excel Download)
Dandelion Energy installs residential geothermal heat pump systems (ground-source HVAC) with in-house financing, targeting US homeowners on fossil-fuel heating.
professionals from Deloitte
Used by professionals from
About this model
Dandelion Energy sells and installs home geothermal systems: a ground loop and heat pump that use existing ducts for heating and cooling. It owns the customer journey from virtual design and sales through installation, monitoring, and financing.
Homeowners can pay about $22,200 upfront or finance with no upfront payment and roughly $250 monthly payments for ten years. The proposition is lower heating and cooling cost, while homebuilder partnerships offer another channel; the deck frames a $978 billion addressable retrofit and new-build market.
This needs a hardware-and-lending model, not a simple installer P&L. Forecast installs by cash, financed, and builder channel, with ASP, drilling and equipment COGS, and seasonal capacity. A loan-book schedule should track originations, receivables, collections, credit losses, and cost of capital alongside operating cash requirements.
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 Dandelion Energy
dandelionenergy.com
How to build a detailed financial model for Dandelion Energy
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Dandelion Energy model - distilled from its pitch deck and publicly available information.
Product & value proposition
- Product: Home geothermal system - ~350 ft ground loop + heat pump + distribution via existing ducts. Heats and cools.
- Full-stack model: Dandelion owns design, sales, install, monitoring, and financing. "One-stop shop."
- Proprietary tech: Virtual sales process; algorithms to estimate costs from photos; proprietary soil conductivity data used by installers; system performance monitoring.
- Value prop: Lowers heating costs by 80%, AC costs by 30%; ground loops last 50+ years; increases home value.
- Two purchase paths: Cash purchase ($22,200 upfront, 7-year payback) or financed ($0 upfront, ~$250/month for 10 years, cash-flow positive day 1 vs. oil).
Market
- TAM (retrofit + new homes, cost-competitive US states): $978B
- Natural gas retrofit: 33M homes in 32 states × $30K = ~$990B (slide rounds to $978B stacked)
- Heating-fuel retrofit (8-state region, NY/CT/MA/ME/MD/MJ/PA/RI): 2.9M homes × $50K = $143B
- Heating-fuel retrofit (core 3-state: NY/CT/MA): 1.7M homes × $50K = $85B
- New construction (cost-competitive states): 430K homes/yr × 10 yrs × $30K = $129B
- Total US homes with natural gas: 58M
- Total US homes with heating fuel: 3.1M–5.2M depending on geography
- New single-family homes annually: 925K nationally; 430K in cost-competitive states
Revenue model
- Hardware/install revenue:
- Cash sale: ~$22,200 per home
- Financed sale: $0 upfront to customer; Dandelion finances the install and collects monthly payments (~$250/month × 10 years = ~$30,000 total)
- In-house financing: Dandelion acts as lender/servicer; future potential to turn into "utility of the future" with long-term ownership model
- B2B channel: Partnering with home builders (mentioned as largest home builder in the country) - revenue model/pricing not detailed
- Hardware innovation: Investment in next-gen efficient heat pump products (future revenue line, not quantified)
Traction & metrics
- NPS: 63
- Star rating: 4.8 on Home Advisor
- Rank: #1 Rated Contractor in State of NY
- No 3-star reviews on Home Advisor
- Finance customer monthly payment: ~$250/month
- Finance term: 10 years
- No revenue figures, customer count, install count, or growth rates are shown in the deck. The section header "Financial Results and Forecast" (slide 12) is present but no actual financial chart or table slide follows - slides 13–14 cover market size and future strategy.
Unit economics
- Customer payback (cash purchase): 7 years
- System cost to customer (cash): $22,200
- Financed monthly payment: ~$250/month for 10 years → implied total collections ~$30,000
- Status quo (fossil fuel) 7-year operating cost: $28,000 vs. Dandelion $11,000 → customer saves $17,000 over 7 years
- Status quo upfront cost (e.g. furnace replacement): ~$10,000
Competition / moat
- No direct competitor named.
- Moat claims:
- Proprietary soil conductivity database (universally used by installers)
- Full-stack ownership (design → install → monitor → finance) makes "competition unlikely"
- Brand ("Kleenex/Bandaid" positioning in geothermal)
- In-house financing creates recurring relationship / utility-like model
- Barriers to incumbents: Contractors reluctant to install heat pumps; consumer concern over cold-climate performance; high electricity cost perception
Team & funding ask / use of funds
Recommended financial model
- Archetype + why: Hardware + consumer finance P&L with loan book overlay. Dandelion has two revenue streams that need separate modelling: (1) hardware/installation margin per job (one-time revenue recognition at install), and (2) a growing loan receivables book (monthly payments collected over 10 years, with associated cost of capital and credit risk). The finance book will eventually dominate the balance sheet - this is closer to a specialty lender + installer hybrid than a pure installer. A 3-statement model with a dedicated loan book schedule is appropriate.
- Forecast horizon & granularity: 5 years, monthly for years 1–2 (install cadence is lumpy and seasonal), quarterly for years 3–5.
- Key drivers & assumptions:
| Driver | Value | Source |
|---|---|---|
| System ASP - cash sale | $22,200 | - |
| System ASP - financed (total collections) | ~$30,000 ($250/mo × 120 mo) | - |
| Finance term | 10 years | - |
| Monthly finance payment | $250 | - |
| % customers choosing finance vs. cash | 60% / 40% - testimonials and deck emphasis lean heavily toward finance; comparable residential solar programs see 65–70% financing take-up | |
| COGS per install (labor + equipment + drilling) | ~$14,000–$16,000 - implied from $22,200 ASP; geothermal industry drilling + equipment benchmarks suggest ~65–70% COGS for early-stage operator | |
| Gross margin (hardware) | ~25–35% - consistent with above; no deck data | |
| Loan credit loss rate | 2–4% annual on outstanding balance - residential home improvement loans; comparable to GreenSky/Mosaic solar loss rates | |
| Cost of capital on loan book | 6–8% - Dandelion must fund receivables; assume warehouse facility or equity-funded early-stage | |
| Install capacity ramp (units/month) | start with 20–50 units/month, scale 2× per year; no deck data | |
| B2B channel revenue | model as separate line, starting Year 2 at lower ASP (~$25K) with 20% gross margin; no deck pricing data | |
| CAC | residential solar analog: $500–$1,500/customer; virtual sales process implies lower; use $800 as base | |
| Operating expenses (G&A, S&M, R&D) | scale from current team; no deck data |
- Scenarios (Base / Bull / Bear - which variables flex):
- Base: 50 installs/month in Y1 growing to 300/month by Y5; 60% financed; gross margin 28%; credit losses 3%.
- Bull: B2B homebuilder channel adds 100+ units/month by Y3; utility-model pricing premium; credit losses 2%; faster cost reduction through hardware innovation.
- Bear: Slower installer network ramp limits volume; higher cost of capital on loan book; credit losses 5%; regulatory change in incentives reduces economics.
- Key flexing variables: units/month, finance take-up %, system ASP, COGS per install, cost of capital on loan book, credit loss rate, B2B channel timing.
- Required sheets / outputs:
- Assumptions - all drivers centralized
- Install Volume - units/month by channel (B2C cash, B2C financed, B2B), seasonality adjustment
- Revenue & Gross Profit - hardware revenue (cash installs + loan originations), monthly payment collections
- Loan Book Schedule - originations, outstanding balance, monthly collections, credit losses, interest income/cost
- Income Statement - consolidated P&L (hardware GP + loan income – OpEx)
- Balance Sheet - loan receivables as primary asset, debt/equity funding
- Cash Flow Statement - operating CF vs. loan book funding requirement (capital-intensive)
- Unit Economics Summary - per-install economics, LTV/CAC, payback on equity deployed
- Scenarios - toggle for Base/Bull/Bear
- Dashboard - KPI cards: total installs, loan book balance, revenue, gross margin %, cash runway
Frequently asked
Is the Dandelion Energy financial model free?+
Yes. The Dandelion Energy 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 Dandelion Energy'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 Climate/Energy Startup Financial Models
Browse another startup in the same category.
Abatable
Robo-advisor platform for sourcing and managing high-quality carbon removal offsets, targeting asset managers.
Bower
Mobile app that rewards consumers for scanning and recycling consumer packaging at existing bins, monetised by CPG brand subscriptions and consumer data.
Bramble Energy
UK deep-tech company commercialising a PCB-based hydrogen fuel cell stack (PCBFC™) for portable power and mobility applications.
Cervest
AI-powered Climate Intelligence platform that quantifies physical climate risk at the asset level, delivered as a freemium SaaS product.
Clockworks Analytics
B2B SaaS platform providing automated fault-detection and diagnostics (FDD) analytics for commercial and institutional building portfolios.
Emitwise
B2B SaaS platform automating corporate carbon footprint tracking, reporting, and reduction using machine learning.
Fisker
Fisker is an asset-light, design-led EV company merging with Spartan Energy Acquisition Corp. in a SPAC transaction to fund the launch of the Fisker Ocean SUV.
Good Loop
Purpose-driven adtech platform that donates a share of ad spend to charities in exchange for user attention, while offering brands impact reporting and carbon-offset tools.
