WA
Waterplan 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.

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

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
Read the pitch deck
Waterplan pitch deck cover
View on makeslides.com
Total raised
$7.0M
Funding round
Seed
Founded
2022
Category
Climate/Energy
Customer
B2B
Geography
Global

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:

  1. Stressors Sensing - satellite + hydrologic model data on water quantity, quality, accessibility, governance per watershed.
  2. Water Resilience Planning - scenario simulation, risk driver quantification, financial impact modeling per site and supply chain.
  3. Impact & Accounting - centralized withdrawals/consumption/discharge tracking vs. targets, KPI monitoring.
  4. 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:
  1. Assumptions - all drivers, color-coded vs.
  2. ARR Bridge - new ARR, expansion ARR, churn ARR, net new ARR per period
  3. P&L (Income Statement) - revenue, COGS, gross profit, S&M, R&D, G&A, EBITDA, net income
  4. Headcount Plan - by department (Science/Eng, Sales, Customer Success, G&A)
  5. Cash Flow & Runway - monthly for Year 1–2; quarterly thereafter
  6. Unit Economics - CAC, LTV, LTV:CAC, payback by cohort year
  7. Scenarios - Base / Bull / Bear toggle on Assumptions sheet
  8. 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

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