Green Hydrogen (Simple Electrolysis Financial Model)

The Model Incorporates data provided by different available sources to Model an Electrolysis financial model. It includes Electrolyzer cost, Dispenser, Storage Compression & Transport Cost. The Model has a ticker to include the cost of the transport trucks or the option to not include it. The goal of the financial model is to create a simple, easy, and clean model to understand how to model the different variables that go into such an analysis. Inputs can be changed, and may not be accurate, however, the infrastructure of the model is for the sole purpose of identifying the price of hydrogen needed for different input assumptions. The default model is one that has no transport cost included. The IRR is driven at 10%, which gave a needed cost of hydrogen per kg of around $6.

, , , , , ,
, , , , , , , , , , , , , , , , ,

The case I address is to illustrate a fueling station that produces hydrogen and sells it. This is done using an electrolyzer to separate H2 from O. The model includes the Production assumptions (Production Capacity, Water Consumption, Degradation, Cost of maintenance, Cost of Electricity, and transport). The CAPEX includes the cost of the Storage Compressor, Dispenser, Electrolyzer, and Trucks to transport the hydrogen (using diesel).

The purpose of the model is to find the selling price needed per KG of hydrogen to reach a certain IRR (which can be done through a goal seek). The model has the option of not including the transport cost which would get the selling price of hydrogen at around $4.6 per kg at a project IRR of 10%. Including Transport the selling price of hydrogen would need to be around $28 per kg for a project IRR of 10%.

The output of the model is a clean and easy-to-understand model which has a Balance Sheet, Project Finance Loan, and Cash Flow projections with Project and Equity IRR. It includes nice charts to complement the analysis.

The point is to create an easy-to-understand model that does not include any VBA or Macro Switches.

Reviews

  • Good model with a lot of detail around key components

    Good product, providing full financials and key parts for H2 as fuel project economics, along with some data sets on electrolysers, dispensers and H2 powered trucks

    723 of 1458 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • Very good green H2 production project finance model

    The model provides a complete business case analysis for green hydrogen production. But even if you have questions like I did, the author makes the difference.
    He was more than willing to answer my questions, and he keeps doing it within the next couple of hours after posting them. Incredible after sales support.

    832 of 1625 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • COO

    Great product . I was really looking for a

    similar product for quite some time .

    Hydrogen. Power. Is a the existing.

    Disruptive. Technology. Which Every.

    Energy. Consultant. Should. Know. About.

    And Should. Really. Go. In. Details.

    Through. It’s. Financial. Model. .

    898 of 1724 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • You must log in to submit a review.