An integrated, institutional-grade blue hydrogen financial model for a hydrogen production plant using natural gas as feedstock with a carbon capture and storage unit — three statements, a cash waterfall and complete lender metrics, built in Excel.

Blue hydrogen occupies a pivotal position in the energy transition. Generated from natural gas with carbon capture technology attached, it delivers substantially lower emissions while making use of infrastructure that already exists — a pragmatic bridge with applications from heavy transport to grid power. But its economics are finely balanced. Natural gas price and capital cost together account for the majority of production cost, and carbon sequestration adds a further layer that a conventional model was never designed to carry.

This blue hydrogen financial model was built to hold all of it. It helps organisations assess the financial viability of setting up and operating a hydrogen production plant, capturing every essential input across construction, operation and financing — and resolving them into the metrics a developer, sponsor or lender needs to reach a decision.

Alongside the standard project-finance suite — Project and Equity IRR and NPV, minimum and average DSCR, LLCR, PLCR, equity payback and a full cash waterfall — the model calculates the Levelised Cost of Hydrogen (LCOH), the benchmark figure the entire hydrogen market is judged against.

LCOH: The Benchmark That Matters

Every hydrogen project is ultimately compared on cost per kilogram. Grey, blue and green production routes are ranked by it, offtake contracts are negotiated around it, and subsidy regimes are calibrated to it. Returns tell you whether a project is worth building; LCOH tells you whether it can compete once built.

Because the blue hydrogen financial model derives LCOH from the same assumption set that drives the cash flows, you can watch it move as you flex natural gas price, capital cost or carbon capture efficiency — the variables that decide whether a blue hydrogen project clears its market.

Assumptions You Control

Every driver of viability is an explicit, editable input. The assumptions cover:

Lender & Investor Outputs

The model resolves your assumptions into the full set of metrics a financing decision turns on:

• Project IRR & NPV — returns to the project as a whole
• Equity IRR & NPV — returns to shareholders after debt service
• Levelised Cost of Hydrogen (LCOH) — cost per unit across the asset’s life
• Minimum & Average DSCR — the coverage lenders scrutinise first
• LLCR & PLCR — loan life and project life coverage ratios
• Equity Payback Period — time to recover shareholder investment
• Cash Waterfall & Debt Service Profile — the full cascade of cash through the structure
• Integrated Financial Statements & Dashboard — income statement, balance sheet, cash flow and a fully linked dashboard

Three Scenarios, One File

Every revenue and cost assumption can be entered across three scenarios and switched at a button, so base, upside and downside cases sit side by side. The debt funding drawdown carries three scenarios of its own — valuable when negotiating terms with financial institutions — and repayment can be profiled as annuity, even-principal or sculpted, each showing its impact on IRR immediately.

Who This Is For

• Hydrogen developers and clean fuel producers building the case for a production plant
• Energy transition and infrastructure investors assessing returns and structuring equity
• Lenders and debt advisors testing coverage ratios and debt sizing
• Project finance advisors preparing bankable models for financial close
• Oil, gas and industrial finance teams evaluating low-carbon diversification

Why This Model

New to these metrics? Read an overview of the debt service coverage ratio. For a model built to your own specification, see our project finance advisory services, or browse the full range of PPP and project finance templates.