# The Green Hydrogen Handbook: companion files

Julian R. Sterling. Companion page: julianrsterling.com/green-hydrogen

1. **Green_Hydrogen_Workbook.xlsx**: the model behind every figure of Caliche Point Hydrogen, the fictional 100 MW electrolysis plant followed through the book (nominal USD, 25 operating years in columns). Tabs: README, Inputs, Production, LCOH, Credit, CashFlow, Debt, Returns, Scenarios, Sensitivity and Checks. The capital cost reads $165,000,000, the sculpted debt $112,270,912 and the equity IRR 11.6 percent; the LCOH is $4.94 per kg. The scenario, breakeven, grid and tornado tables are values computed by the book model and labelled as such; every other tab is live. The Checks tab must read 0.
2. **LCOH_Calculator.xlsx**: a standalone levelized cost of hydrogen calculator for one plant (sheets README, Inputs, Calculation, Results), prefilled with the base case: it returns $4.94 per kg and its five parts (capital, stacks, power, fixed costs, water), and the LCOH net of any credit cash per kg you enter. Replace the blue cells with your own plant.

Blue cells are inputs, black cells are formulas; no macros, no circular references. The project, the companies and every figure are fictional teaching assumptions, not market data. Education only, not legal, tax, accounting or investment advice.
