Waste-to-Energy Financial Model — Techno-Economic Analysis & Project Finance (Excel)
Originally published: 24/06/2026 13:13
Publication number: ELQ-25000-1
View all versions & Certificate
certified

Waste-to-Energy Financial Model — Techno-Economic Analysis & Project Finance (Excel)

A ready-to-use Excel model to assess the financial viability of a waste-to-energy plant — full P&L, cash flow, project & equity returns, debt sizing and DSCR.

Description
OverviewThis is a complete techno-economic and project finance model for waste-to-energy (WtE) / energy-from-waste plants. Enter your project's assumptions in one input tab and instantly get a fully linked financial analysis: revenue build-up, operating costs, CAPEX and depreciation, a full debt schedule, income statement, cash flows, and a returns dashboard with NPV, IRR, payback, DSCR and equity multiple.

It was built by a practitioner — a chemical engineer with more than two decades designing, implementing and operating waste treatment, disposal and valorization projects — not by a generalist. Every formula is visible and auditable; nothing is hidden in a black box.

Who it is for
  • Developers and EPCs evaluating a waste-to-energy opportunity

  • Investors, funds and lenders running due diligence on a WtE project

  • Engineering and environmental consultants preparing feasibility studies

  • Circular-economy startups building an investor business case

  • Anyone who needs a credible, defensible WtE financial model fast

What's inside (9 linked worksheets)
  • README — instructions, colour legend and plant-type presets

  • Inputs — every assumption in one place (edit only the blue cells)

  • Revenue — modular build-up: gate fee, energy sales, recovered materials, by-products

  • OPEX — fixed, variable and maintenance costs with escalation

  • CAPEX & Depreciation — investment and straight-line depreciation

  • Financing — full debt schedule with interest, amortization and DSCR

  • P&L — income statement

  • Cash Flow — project (unlevered) and equity (levered) cash flows

  • Returns & Dashboard — NPV, IRR, payback, min/avg DSCR, MOIC + charts

Key outputsProject NPV & IRR · Equity NPV & IRR · Simple payback · Minimum and average DSCR · Equity multiple (MOIC) · Annual revenue/OPEX/EBITDA chart · Cumulative cash-flow (payback) chart.

Why this model is different
  • Modular revenue engine. Toggle each revenue stream on/off (gate fee, energy, material recovery, by-products). The same file adapts to incineration, RDF, biogas and hybrid configurations — you are not locked into one plant design.

  • Built by an operator. The structure reflects how WtE projects actually make and lose money, not a textbook template.

  • Fully transparent. Industry-standard colour coding (blue = inputs, black = formulas, green = links). Audit and adapt every cell.

  • Lender-ready. Includes the debt sizing and DSCR metrics banks ask for.

What you getOne Excel (.xlsx) file, ready to use, with a built-in instructions tab. Example figures are included as placeholders — simply replace the blue input cells with your project's real numbers and the entire model recalculates.

Requirements & notes
  • Works in Microsoft Excel and Google Sheets.

  • Built for 1 construction year + 20 operating years.

  • The example inputs are illustrative; calibrate them to your project.

  • This is a financial modelling tool, not investment, legal or tax advice.

This Best Practice includes
Included 2 files: 1. Waste-to-Energy Financial Model (.xlsx) | 2. Quick Start Guide (.pdf)

Acquire business license for $37.50

Add to cart

Add to bookmarks

Discuss

Further information

This model enables users to assess the financial viability of a waste-to-energy (WtE) or broader waste valorization project from first principles. Specifically, it allows you to:

- Build a revenue model from multiple streams (gate fee, energy sales, recovered materials, by-products) using toggleable modules adaptable to different plant configurations;
- Size capital expenditure, operating costs and financing structure;
- Generate a full set of financial statements (P&L, cash flow, debt schedule) linked to a single input tab;
- Calculate and interpret key project and equity returns: NPV, IRR, payback, DSCR and equity multiple (MOIC);
- Stress-test assumptions using a built-in 2-way sensitivity grid;
- Produce lender-ready output, including debt service coverage metrics.

This model is best suited for:

- Early-stage and pre-feasibility analysis of waste-to-energy, energy-from-waste, waste valorization or circular economy projects;
- Developers, EPCs and independent consultants building an initial investment case or feasibility study;
- Investors and lenders running a first-pass due diligence on a WtE opportunity;
- Circular economy startups preparing a financial narrative for fundraising;
- Projects with a single main treatment technology (incineration, RDF, gasification, biogas) and a clearly defined revenue mix;
- Users who need a transparent, auditable model they can adapt and present to third parties;

This model is not the best fit if:

- Your project involves multiple treatment stages with complex material flow interdependencies requiring process simulation software (e.g. Aspen, CHEMCAD);
- You need a multi-scenario or Monte Carlo probabilistic model — this is a deterministic model with sensitivity analysis, not a full risk simulation tool;
- Your financing structure involves complex instruments such as mezzanine debt, convertible notes or sculpted debt service — the financing module uses equal principal repayment;
- You require jurisdiction-specific tax treatment, loss carry-forward or depreciation schedules beyond straight-line;
- Your project horizon exceeds 20 operating years without modification to the column structure;
- You need a fully automated model without any manual calibration — all blue input cells require the user's own project data to produce meaningful output.


0.0 / 5 (0 votes)

please wait...