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.
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.
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.
| Measure | Value |
|---|---|
| Electrolyzer input / capacity factor | 100 MW / 60 percent |
| Consumption at start of stack life | 52.5 kWh per kg |
| Hydrogen output, year 1 | 10,011 tonnes |
| Delivered power price, years 1 to 15 | $39.00 per MWh |
| Capital cost | $165,000,000 |
| Discount rate | 8 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.
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.
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.
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.
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.