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 to find the selling price needed for a 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 $6 per kg at a project IRR of 10%. Including Transport the selling price of hydrogen would need to be around $30 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, 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.