WAWaterplan Financial Model
Climate/Energy Startup Financials (Free Excel Download)
B2B SaaS platform that automates water risk quantification and mitigation planning for corporate operations and supply chains.
professionals from Deloitte
Used by professionals from
About this model
Waterplan is enterprise software for measuring water risk and planning resilience across corporate operations and supply chains. It combines satellite and hydrologic data, scenario modelling, water accounting, and CDP-aligned reporting at site and basin level.
The product is sold to large companies as recurring SaaS, likely with enterprise or site-based expansion. Ten Fortune 500 customers were using the platform at the deck date; $425 billion of water-related value at risk and projected water shortages support demand, although pricing and revenue are not disclosed.
The model should use a high-ACV enterprise ARR bridge: new customers, sites per account, expansion, churn, and renewal timing. Tie the revenue plan to science and engineering staffing, enterprise sales costs, customer success, and data-infrastructure gross margin, with long sales cycles and regulatory urgency flexed across cases.
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 Waterplan
waterplan.io
How to build a detailed financial model for Waterplan
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Waterplan model - distilled from its pitch deck and publicly available information.
Product & value proposition
Climate water risk SaaS platform with four core modules:
- Stressors Sensing - satellite + hydrologic model data on water quantity, quality, accessibility, governance per watershed.
- Water Resilience Planning - scenario simulation, risk driver quantification, financial impact modeling per site and supply chain.
- Impact & Accounting - centralized withdrawals/consumption/discharge tracking vs. targets, KPI monitoring.
- Reporting - CDP-aligned standardized output for ESG/regulatory disclosure.
Differentiation: proprietary hydrologic models (SWAT+), World Bank climate scenarios, NASA-validated meteorological data, satellite remote sensing - delivered via a SaaS dashboard.
Market
- $425 billion in water-related financial value at risk globally (Source: CDP)
- 40% projected water supply deficit globally by 2030 (Source: UN)
- Cost of inaction is 5x the cost of action on water security (Source: CDP)
- No explicit TAM/SAM/SOM breakdown or addressable market sizing slide in deck.
Revenue model
- B2B enterprise SaaS - sold to large corporations (Fortune 500).
- Likely site/location-based or enterprise license model given product UX showing per-site and per-basin analysis.
- No pricing page, contract value, or pricing tier shown in deck.
- Sales motion: direct enterprise sales (implied by Fortune 500 customer base and YC network).
Traction & metrics
- 10 Fortune 500 companies using Waterplan to measure and mitigate water risk
- Investors: Giant Ventures, Sir Richard Branson Family, L2 Ventures, MCJ Collective
- No ARR, MRR, revenue, growth rate, NRR, or churn figures disclosed in deck.
Competition / moat
- Proprietary science stack: SWAT+ hydrologic models, NASA-validated data, satellite imagery integration
- Chief Scientist James Famiglietti (former NASA JPL, UC Center for Hydrologic Modeling) plus advisory board from Coca-Cola, Microsoft, TNC, World Bank, UN, OECD
- CDP reporting alignment as a switching-cost / compliance driver
- First-mover with Fortune 500 logos (social proof creates enterprise network effects)
Team & funding ask / use of funds
Core team:
- José Ignacio Galindo - Co-Founder & CEO
- Nicolás Wertheimer - Co-Founder & CSO
- Olivia Cesio - Co-Founder & COO
- Matías Comercio - Co-Founder & CPO
- James Famiglietti - Chief Scientist (former NASA JPL, UC Center for Hydrologic Modeling, Univ. of Saskatchewan)
Advisors: Todd Reeve (Bonneville Environmental Foundation CEO), Greg Koch (former Coca-Cola global water leader), Paul Fleming (former Microsoft), Kari Vigerstol (TNC), Benjamín Zaltchik PhD (Johns Hopkins/NASA), Michael Olson (Cloudera founder), Gonzalo Delacámara (European Commission/UN/OECD/World Bank water policy)
Recommended financial model
- Archetype + why: Enterprise SaaS ARR model. Revenue is recurring subscription (annual enterprise contracts) sold to large corporations on a per-site or per-organization basis. High ACV, low volume, long sales cycles. Secondary archetype consideration: usage-based seat/site expansion within accounts (land-and-expand typical for ESG data platforms).
- Forecast horizon & granularity: 5-year annual forecast (Year 1–5), with Year 1 broken into monthly for cash flow visibility. Early-stage company needs runway modeling alongside P&L.
- Key drivers & assumptions:
- New logos per year
- Average Contract Value (ACV) per customer
- Sites per customer]
- Net Revenue Retention (NRR)
- Gross margin
- Headcount & payroll
- S&M as % of revenue
- R&D as % of revenue
- CAC
- Payback period
- Churn
- Scenarios (Base / Bull / Bear - which variables flex):
- Base: 5–6 new logos/yr, $120K ACV, 115% NRR, 70% gross margin
- Bull: 8–10 new logos/yr, $160K ACV, 125% NRR (rapid site expansion), regulatory tailwinds accelerate deals
- Bear: 2–3 new logos/yr, $80K ACV, 105% NRR, 65% gross margin (data infra costs don't scale as expected)
- Primary flex variables: new logo growth rate, ACV, NRR, gross margin
- Required sheets / outputs:
- Assumptions - all drivers, color-coded vs.
- ARR Bridge - new ARR, expansion ARR, churn ARR, net new ARR per period
- P&L (Income Statement) - revenue, COGS, gross profit, S&M, R&D, G&A, EBITDA, net income
- Headcount Plan - by department (Science/Eng, Sales, Customer Success, G&A)
- Cash Flow & Runway - monthly for Year 1–2; quarterly thereafter
- Unit Economics - CAC, LTV, LTV:CAC, payback by cohort year
- Scenarios - Base / Bull / Bear toggle on Assumptions sheet
- Dashboard - ARR growth, logo count, NRR, gross margin, runway KPIs
Frequently asked
Is the Waterplan financial model free?+
Yes. The Waterplan 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 Waterplan'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.
Dandelion Energy
Dandelion Energy installs residential geothermal heat pump systems (ground-source HVAC) with in-house financing, targeting US homeowners on fossil-fuel heating.
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.
