SmartHelping / Renewable Energy / Excel
Biogas / Biomethane Model
Plan a biomethane business across as many as five feedstock-processing facilities over 10 years. Connect facility construction, land, capacity, feedstock mix, production yield, process efficiency, pricing, direct costs, overhead, financing, financial statements, valuation, and investor returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
See how feedstock processing becomes biomethane cash flow.
Watch the walkthrough, then open the screenshots to review the facility rollout, construction and financing, feedstock capacity, production yield, pricing, direct costs, financial statements, valuation, and investor returns.
What the model includes
A bottom-up framework for a staged biomethane rollout.
Build each facility from its construction and feedstock assumptions, then follow production through operating cash flow, financing, financial statements, valuation, and returns.
Model up to 120 monthly periods
Plan facility deployment and operations over 10 years with connected monthly and annual pro forma detail.
Scale through a staged site rollout
Configure as many as five processing facilities with their own start dates, construction schedules, costs, capacity, and financing.
Mix multiple organic input streams
Define up to six feedstock types for each facility, including acquisition costs, processing volumes, and production characteristics.
Translate tons processed into biomethane output
Use yield per ton and process-efficiency assumptions to calculate the cubic meters of biomethane produced.
Connect monthly and annual financials
Integrate high-level Income Statement, Balance Sheet, and Cash Flow Statement views with the operating forecast.
Finance the initial facility build
Use interest-only construction loans and choose whether the interest accrues into the balance or is paid currently.
Evaluate DCF, IRR, and exit value
Measure project value and returns and optionally calculate terminal proceeds from trailing-12-month EBITDA.
Review the annual summary and model checks
Use the annual executive summary and self-error-checking logic to review results and identify model inconsistencies.
Facility rollout and construction
Build each processing site around its own startup plan.
Every facility can begin at a different point in the forecast and carry distinct construction, land, debt, capacity, and feedstock assumptions.
Facility start month
Choose when each site enters the development schedule so construction spending and operating activity begin in the intended periods.
Construction duration
Define the number of months required to build each facility and spread the initial construction costs across that timeline.
Land purchase
Enter site-specific land acquisition costs alongside the facility's other startup and construction requirements.
Construction financing
Configure debt for each site and select whether interest-only-period interest is accrued or paid without accrual.
Maximum processing capacity
Set the maximum monthly tons the site can accept and use capacity growth assumptions to model its operating ramp.
Additional CAPEX
Schedule other capital items by expenditure month and define their useful lives for the fixed-asset plan.
Feedstock and production economics
Connect throughput, yield, efficiency, pricing, and direct costs.
The operating framework makes the physical and commercial drivers visible at the facility and feedstock levels.
Forecast feedstock tons by site and type
Allocate expected processing activity across as many as six feedstocks within each of the five facilities.
Grow utilization over time
Start each facility at the selected capacity level and adjust its processing utilization as operations scale.
Estimate cubic meters of biomethane
Define the biomethane yield produced by each ton of feedstock processed and apply the relevant process efficiency.
Monetize the produced biomethane
Apply pricing per cubic meter to the modeled output so production volume flows directly into facility revenue.
Model costs by output and input volume
Use costs per cubic meter produced, costs per ton processed, and three processing-cost types for each feedstock.
Reflect the cost of securing inputs
Enter acquisition costs by feedstock type to capture differences in sourcing and supply economics.
Keep facility economics distinct
Configure variable cost assumptions by facility instead of relying on one blended cost across the network.
Add the fixed cost of supporting the platform
Use the corporate-overhead section for recurring expenses that sit above the individual processing sites.
Financial statements, value, and returns
Follow the business from construction through operations and exit.
Facility-level drivers flow into consolidated financial statements, project valuation, return analysis, and an optional joint-venture structure.
Monthly and annual pro forma
Review detailed operating performance and cash flow across the full 120-month forecast and annual summary periods.
Integrated financial statements
Connect the Income Statement, Balance Sheet, and Cash Flow Statement to the facility rollout and operating assumptions.
DCF and IRR
Measure the present value of forecast cash flows and the return produced by the project under the selected assumptions.
Optional exit value
Turn terminal value on or off and, when included, apply a multiple to trailing-12-month EBITDA.
Joint-venture capability
Evaluate the modeled project cash flows within an investor and operator ownership structure when the development has multiple equity participants.
Executive summary and checks
Use the annual executive view for decision-ready outputs and the built-in error checks to identify inconsistencies.
How to use it
Move from facility rollout to project value.
Define the facility rollout
Set the start month, construction duration, construction spending, land purchase, debt, and capacity for each planned site.
Build the feedstock and production case
Configure feedstock types, tons processed, capacity growth, yield per ton, process efficiency, and biomethane pricing.
Add operating costs, overhead, and CAPEX
Enter feedstock-acquisition costs, variable production costs, site economics, corporate overhead, and other capital items.
Review statements, value, and returns
Evaluate the monthly and annual pro forma, three statements, executive summary, DCF, IRR, exit value, and joint-venture outcomes.
Who gets value from it
Built for teams developing and funding biomethane facilities.
Biogas developers and operators
Plan construction, capacity, feedstock sourcing, production, pricing, operating costs, and facility expansion.
Renewable-energy investors
Evaluate project cash flow, capital requirements, valuation, IRR, terminal value, and partner economics.
Lenders and project-finance teams
Review construction timing, interest treatment, debt-funded spending, cash flow, and repayment capacity.
Advisors and financial modelers
Use an editable bottom-up framework for feasibility studies, fundraising, scenario analysis, and client planning.
Also available in these bundles
Need a broader spreadsheet library?
The Biogas / Biomethane Model is included in the Industry-Specific, Renewable Energy, Industrial, Capacity-Based, and Super Smart collections.
Industry-Specific Models
Access bottom-up operating and financial models designed around the economics of specific business types.
View Industry-Specific ModelsRenewable Energy Models
Compare solar, wind, hydropower, hydrogen, biogas, storage, charging, recycling, and other energy projects.
View Renewable Energy ModelsIndustrial Models
Explore processing, production, energy, infrastructure, manufacturing, and other asset-intensive businesses.
View Industrial ModelsCapacity-Based Models
Find models where facilities, equipment, utilization, throughput, and production limits drive revenue and investment.
View Capacity-Based ModelsSuper Smart Bundle
Get the complete SmartHelping collection for forecasting, valuation, accounting, financing, real estate, and more.
View Super Smart BundleRelated financial models
Explore adjacent renewable-energy and infrastructure projects.
Use these complementary SmartHelping models for other production, generation, storage, recycling, and energy-distribution opportunities.
Battery Energy Storage System
Model phased battery deployment, tolling, energy trading, capacity revenue, variable costs, financing, valuation, and returns.
Explore the BESS modelBattery Recycling Plant
Forecast feedstock, processing capacity, recovered materials, pricing, plant costs, financing, and returns.
Explore the battery recycling modelSolar Farm
Connect utility-scale solar generation, revenue, project costs, debt, financial statements, valuation, and investor returns.
Explore the solar farm modelHydropower
Evaluate water-flow-driven generation, construction spending, operating costs, financing, valuation, and returns.
Explore the hydropower modelHydrogen Production Plant
Build a 20-year forecast for plant capacity, hydrogen output, customer pricing, costs, debt, statements, and returns.
Explore the hydrogen modelEV Charging Network
Plan charger deployment, utilization, kWh sales, subscriptions, operating costs, valuation, and investor returns.
Explore the EV charging modelWind Farm
Forecast turbine capacity, energy production, pricing, operating costs, financing, and project returns.
Explore the wind farm modelCustom Financial Model Work
Request modifications to this biomethane model or a custom renewable-energy forecast for a specific development.
Contact SmartHelpingQuestions before you buy
A few useful details.
How long is the forecast?
The model supports up to 120 months, or 10 years, with monthly and annual pro forma detail and integrated high-level financial statements.
How many facilities and feedstocks can I model?
You can configure up to five processing facilities and as many as six feedstock types within each site.
How is biomethane production calculated?
Facility capacity and processed tons are combined with feedstock-specific yield per ton and process-efficiency assumptions to estimate cubic meters of biomethane produced.
Which direct costs can I enter?
The model supports costs per cubic meter produced, costs per ton processed, three processing-cost types for each feedstock, feedstock-acquisition costs, and site-specific variable costs.
How does the construction loan work?
Each facility can use interest-only construction financing, with an option to accrue the interest into the balance or pay it currently without accrual.
Does it include valuation and investor returns?
Yes. The workbook includes DCF and IRR analysis, an optional exit value based on trailing-12-month EBITDA, and joint-venture capability.
Is it included in any bundles?
Yes. It is included in the Industry-Specific, Renewable Energy, Industrial, Capacity-Based, and Super Smart collections.
Model the full biomethane project lifecycle
Turn feedstock throughput into production, cash flow, value, and returns.
Get the editable 10-year model for up to five facilities, six feedstocks per site, construction financing, production economics, three statements, DCF, IRR, terminal value, executive outputs, and joint-venture analysis. One-time purchase for $45.
