Clean Hydrogen Production Project Economic Model

This is a detailed and easy-to-use catalytic methane pyrolysis financial model. This is a modular financial model, meaning that relevant calculations are separated into separate tabs that can be used to build a forecast for a methane pyrolysis project. More complex models at the most basic level are separated into 1) inputs, 2) calculations, and 3) outputs. In overly simplistic models, these items are often grouped into a single tab.

The model template does not overcomplicate the analysis by including too many inputs and assumptions, calculations, and outputs but rather focuses on key inputs and assumptions required to derive the most relevant outputs (i.e., carbon and hydrogen production, unit sales and operating costs, levelized costs and project NPV and IRR).

I have used the following structural approach for every model that I have built, which users have always found to be clean, practical, easy to follow, and user-friendly. Sections may vary somewhat depending on the complexity of the model, but the basic layout remains the same.

The sections of this model template are as follows:

1. Title Page: A brief description of the model’s purpose. Contact information can also be included here.

2. Assumptions Tab: Inputs and assumptions that drive the model.

3. Dashboard Tab: Key metrics are presented here in graphical and tabular format, including forecast cash flow, carbon and hydrogen production, unit sales and operating costs, project NPV and IRR, and levelized costs.

4. Annual Summary Tab: A simple and easy-to-follow tab showing annual forecast amounts.

5. Project Economics Tab: Detailed but easy-to-follow monthly calculations for the next 20 years.

6. Pricing Tab: Pricing scenarios whereby key inputs such as natural gas, hydrogen, carbon, and electricity prices can be varied.

The model template utilizes 20 years for the forecast period. Again, this is a detailed but user-friendly model that forecasts financial and operating metrics for a methane pyrolysis project.

File types: .xlsm and .pdf

You must log in to submit a review.