A hydrogen tariff calculator with integrated financial statements and a cash waterfall — an institutional-grade tool for assessing a proposal to build and operate a green hydrogen gas plant, built in Excel.

Most financial models start with a price and tell you what return it produces. This one runs the other way. You specify the Equity IRR your investors require, and the model back-calculates the tariff needed to deliver it. That inversion changes the conversation entirely — instead of guessing at a price and hoping the returns work, you start from the return you must achieve and find out exactly what you need to charge.

For anyone bidding into a hydrogen offtake process, negotiating a supply agreement or setting a price for a concession, that is the question that actually matters. This hydrogen tariff calculator answers it directly, with an automated mechanism that solves for tariff based on your desired Equity IRR, operational capacity and expected cost inputs.

Around that engine sits a complete project finance structure — construction and operations phases, integrated financial statements, a full cash waterfall and debt service profile — so the tariff it produces is grounded in a properly built model rather than a standalone calculation.

How the Tariff Calculation Works

Revenue is derived, not assumed. The hydrogen tariff calculator takes your target Equity IRR and operational capacity and works backwards through the cash flows — after debt service, after tax, after operating cost — to establish the price per unit that leaves shareholders with exactly the return they asked for.

Cost is split into two parts, as project finance requires. Construction cost is spread proportionately across the construction period, feeding the funding requirement and interest during construction. Operating cost then takes over once the plant is live. Because the two are separated properly, the tariff reflects the full lifetime economics rather than an operating-phase snapshot.

A 70-Year Horizon

The model runs on a flexible annual timeline and can forecast up to seventy years across both construction and operations. That is far beyond what most templates offer, and it matters for hydrogen infrastructure, where concessions and offtake agreements routinely extend for decades and terminal assumptions carry real weight in the tariff.

A short horizon forces the tariff up, because capital has less time to be recovered. Being able to model the genuine asset life — rather than truncating at twenty or twenty-five years for the sake of the template — often makes the difference between a bid that wins and one that prices itself out.

What the Model Produces

• Required Tariff — back-calculated from your target Equity IRR and capacity
• Project & Equity IRR and NPV — returns to the project and to shareholders
• DSCR — the debt service coverage lenders scrutinise first
• Equity Payback Period — time to recover shareholder investment
• Cash Waterfall & Debt Service Profile — the full cascade of cash through the structure
• Integrated Financial Statements — income statement, balance sheet and cash flow, fully linked

Who This Hydrogen Tariff Calculator Is For

• Green hydrogen developers pricing a proposal to build and operate a plant
• Bidders in offtake and concession processes establishing a defensible price floor
• Procuring authorities and regulators testing whether a submitted tariff is reasonable
• Energy transition investors checking what return a given price actually supports
• Project finance advisors preparing bid models and negotiating supply agreements

Why This Model

New to these metrics? Read an overview of the internal rate of return. 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.