Water Desalination Financial Model (Excel) | SWRO, Water Purchase Agreement, DSCR Debt & LCOW

Break-Even, Cash Flow Projections, DCF Model, Debt Schedule, Debt Service Coverage, Excel, Financial Feasibility, Financial Model, Financial Statements, IRR (Internal Rate of Return), LLCR (Loan Life Coverage Ratio), NPV (Net Present Value), Payback Period, PLCR (Project Life Coverage Ratio), Project Finance, Return on Invested Capital (ROIC), Scenario Analysis, Sensitivity Analysis, Stress Test, Uses and Sources of Funds, Valuation

The Water Desalination Financial Model is an institutional, lender-grade Excel model for a seawater reverse osmosis (SWRO) plant, built on the same rigour as a full project-finance underwriting. It takes a plant capacity and a water purchase agreement and turns them into a defensible investment case: revenue, coverage, returns and the levelized cost of water, over the full operating life.

Desalination is an energy business as much as a water business. Specific energy, the kilowatt-hours needed to push a cubic metre of seawater through the membranes, is the swing cost, so I build it explicitly, from gross demand through energy recovery to the net figure that drives operating cost. Revenue is a two-part water tariff: a capacity charge on contracted capacity plus a volumetric water charge, indexed to inflation, with an energy pass-through. A take-or-pay water purchase agreement places volume risk with the offtaker, and the model shows exactly how that flows through coverage and returns.

What is inside

An SWRO process and energy engine: capacity, availability, recovery ratio and specific energy net of energy recovery.
A two-part water tariff revenue build with an energy pass-through and a take-or-pay water purchase agreement.
A full construction and funding schedule with interest during construction, and a membrane replacement reserve.
DSCR-sculpted senior debt with a debt service reserve, LLCR and PLCR, and covenant headroom.
Traditional statements and reorganized statements (NOPLAT, invested capital, ROIC, economic profit) reconciled by three bridges that equal zero in every period.
Capital allowances and deferred tax that reverses, a minimum operating cash balance, and a distribution policy limited to distributable reserves.
Project and equity IRR, equity multiple, payback, minimum and average DSCR, LLCR, PLCR and the levelized cost of water.
A four-case scenario manager, a tornado, a two-way sensitivity grid, break-even analysis and a sponsor equity cure, feeding a live dashboard.

Every calculation is formula-driven and transparent, with no macros. All inputs are illustrative and benchmarked to public industry ranges and clearly flagged; there is no reference to any specific project, company, country or private contract. The model is independently checked and carries zero formula errors, with the balance sheet balancing and the three reconciliation bridges tying to zero. A 28-page development and modelling guide is included, walking the whole build from intake and pretreatment through the RO trains to the brine outfall and mapping every stage to the model.

Who it is for: desalination developers, water utilities, independent water producers, sponsors, and infrastructure lenders sizing debt against a water offtake.

You must log in to submit a review.