Dandelion Energy logo
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.

Free, no credit card required
Edit in Excel
Created by ex-finance
professionals from Deloitte
Loading...

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
Read the pitch deck
Dandelion Energy pitch deck cover
View on makeslides.com
Total raised
$70.0M
Funding round
Series B
Founded
2022
Category
Climate/Energy
Customer
B2C
Geography
US

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:
DriverValueSource
System ASP - cash sale$22,200-
System ASP - financed (total collections)~$30,000 ($250/mo × 120 mo)-
Finance term10 years-
Monthly finance payment$250-
% customers choosing finance vs. cash60% / 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 rate2–4% annual on outstanding balance - residential home improvement loans; comparable to GreenSky/Mosaic solar loss rates
Cost of capital on loan book6–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 revenuemodel as separate line, starting Year 2 at lower ASP (~$25K) with 20% gross margin; no deck pricing data
CACresidential 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:
  1. Assumptions - all drivers centralized
  2. Install Volume - units/month by channel (B2C cash, B2C financed, B2B), seasonality adjustment
  3. Revenue & Gross Profit - hardware revenue (cash installs + loan originations), monthly payment collections
  4. Loan Book Schedule - originations, outstanding balance, monthly collections, credit losses, interest income/cost
  5. Income Statement - consolidated P&L (hardware GP + loan income – OpEx)
  6. Balance Sheet - loan receivables as primary asset, debt/equity funding
  7. Cash Flow Statement - operating CF vs. loan book funding requirement (capital-intensive)
  8. Unit Economics Summary - per-install economics, LTV/CAC, payback on equity deployed
  9. Scenarios - toggle for Base/Bull/Bear
  10. 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

Alex Tapio, ex-Deloitte financial modelling expert

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.

Go further

Build the financial model you need with Fina AI

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview
Career Principles

Learn Financial Modelling Skills with industry-leading Career Principles

Breaking into the finance industry? Explore courses in Excel, financial modeling, valuation, data analytics, and AI for business and finance.

Career Principles lesson on preparing a cash flow statement in Excel
Career Principles Financial Analyst Program
Career Principles Python for Data Analysis
Career Principles AI for Business and Finance course