Free Excel Templates

LCOH Calculator for Green Hydrogen (Excel)

An unlocked Excel calculator of the levelized cost of hydrogen for one electrolysis plant: consumption and degradation, capacity factor, power price, capital cost, stack replacement and fixed costs, with the cost per kilogram broken into its five parts.

Enter your plant and your power price, and the calculator returns what a kilogram of hydrogen really costs over the life of the plant. In the prefilled case, Caliche Point Hydrogen, a fictional 100 MW PEM plant with a capital cost of $165,000,000, the levelized cost is $4.94 per kg, of which power is $2.15 and capital $2.02.

Get the Excel calculator

One unlocked Excel workbook, zero macros, zero circular references. Free: enter your email address and the download opens at once, along with the other free finance models.

LCOH_Calculator.xlsx (14 KB)

You join the reader list: one email when a new free model or book comes out. Unsubscribe in one click. Already subscribed? Enter the same address. How your address is used.

The handbook behind this calculator

This calculator is the cost side of the 11-tab workbook in The Green Hydrogen Handbook, which takes one electrolysis plant from its first kilowatt-hour to retirement: power supply and hourly matching, the 45V credit and its sale, the offtake contract, sculpted debt, equity returns, scenarios and breakevens.

Paperback PDF edition, $19.99 Book page and full workbook

What is inside the workbook

README
How the calculator is laid out, the definition of the levelized cost used (costs and kilograms discounted to the start of operation) and the conventions.
Inputs
The plant in blue cells: capacity, consumption at the start of stack life and its degradation, stack life and replacement cost, capacity factor, power price before and after the power contract, capital cost, fixed cost shares and escalation, water and consumables, discount rate, operating years and an optional credit cash per kilogram.
Calculation
One column per operating year: consumption, electricity, kilograms, each cost line, the maintenance reserve for stacks and the discount factor.
Results
The levelized cost and its five parts per kilogram, their shares, and the cost net of the credit.

What the prefilled example returns

MeasureValue
Electrolyzer input / capacity factor100 MW / 60 percent
Consumption at start of stack life52.5 kWh per kg
Hydrogen output, year 110,011 tonnes
Delivered power price, years 1 to 15$39.00 per MWh
Capital cost$165,000,000
Discount rate8 percent
Capital$2.02 per kg
Stack replacements$0.16 per kg
Power$2.15 per kg
Fixed O&M, insurance and property tax$0.56 per kg
Water and consumables$0.05 per kg
Levelized cost of hydrogen$4.94 per kg
Net of the credit$2.79 per kg

Read the two largest lines together. Power, at $2.15 per kg, is set by the power contract and by consumption; capital, at $2.02, is set by the capital cost and by how many hours the plant runs. That is why the capacity factor matters twice: more hours spread the capital over more kilograms, but under hourly matching more hours usually mean dearer firmed power. Change both in Inputs and watch which effect wins.

For the method step by step, read how to calculate the levelized cost of hydrogen; for the credit that sits beside the cost, how the 45V credit works after 2025; for the debt and returns, how a green hydrogen project is financed.

The project, its companies and every figure are fictional teaching assumptions, not market data. Education only, not legal, tax or investment advice.

Questions practitioners ask

What does the calculator compute?

The present value of every cost of the plant (capital, stack replacements, power, fixed operating costs, water and consumables) divided by the present value of the kilograms it produces, at the discount rate you enter. In the prefilled case the result is $4.94 per kg.

Why does output fall between stack replacements?

Stacks degrade: the plant needs more electricity per kilogram as they age. At fixed power input, the prefilled plant goes from 52.5 kWh per kg to 57.23 kWh per kg in year 10, so output falls from 10,011 to 9,185 tonnes a year until the stacks are replaced.

Is the LCOH the price the plant needs?

No. It is a cost at a chosen discount rate, before financing structure and tax. The price a project needs depends on its debt, its contract and the return its equity asks for. In the book's case, an offtake price of $2.51 per kg with the credit gives equity a 10 percent return; without the credit the figure is $4.65.

How do I show the effect of a production credit?

Enter the cash per kilogram you expect from the credit after any transfer discount. The prefilled case uses $2.930 per kg for ten years, worth $2.15 per kg levelized, so the cost net of the credit is $2.79.