This is my second big renewable energy financial model (the first was for a wind farm). It is exciting to feel like I am contributing in some way to a more sustainable future by using the skills I have. In this case, it is creating an awesome bottom-up financial modeling tool for the industry. This is a scaling and capacity-based model that deals specifically with feedstock processing, the related costs, and the resulting yield of such activity over time.
After purchase, the template will be immediately available to download. It is also included in the industry-specific financial models bundle, capacity-based models bundle, industrial sector models bundle and The Super Smart Bundle (all models).
Template Features:
- Integrated 3 statement Model (high level monthly and annual financial statements)
- Scale up to 5 Facilities
- Model for up to 120 months
- Perform DCF Analysis and IRR
- Annual Executive Summary
- Joint Venture Capable
- Monthly and Annual Pro Forma Detail
- Self-error Checking
- UPDATE: I added an option for the interest-only loan to either accrue or not accrue.
- Initial Startup Phase:
- For each site, define the start month, the initial construction costs, the length of construction (months), land purchase costs, and financing options (debt) with the capability for interest-only construction loans (select accrual or non-accrual of interest).
- Revenue Phase:
- For each site, define up to 6 feedstock types that will be processed, the maximum monthly tons that can be processed, the starting capacity / capacity growth, the yield per ton (cubic meters of biomethane produced), and the process efficiency.
- Expenses:
- Robust corporate overhead section for fixed expenses.
- Variable costs by site, costs per cubic meter of biomethane produced, costs per ton of feedstock processed (3 cost types for each feedstock type), and costs to acquire feedstock by type.
- There is also a filler section for other CAPEX items, their useful life, and expenditure month.
- Disposition:
- Choose to include an exit value or not, if so then define the trailing 12-month EBITDA multiple that drives this value.