Anaerobic Digestion Plant Excel Model
Originally published: 26/12/2018 11:07
Publication number: ELQ-57872-1
View all versions & Certificate

Anaerobic Digestion Plant Excel Model

Anaerobic digestion plant investment assessment model

30 year annual anaerobic digestion plant investment appraisal model. The user does not have to use all 30 years. The model has the ability to enter opening Balance Sheet (optional) and forecast numbers. The user has the ability to enter a capital structure. This can be a mix of senior debt and equity used for purchasing/investing in the anaerobic digestion plant site.

The outputs include a simplified Profit and Loss statement, a simplified Balance Sheet, a statement of net cash flows and an IRR (valuation) output.

Prices are entered as "real" prices and the user can enter various "inflation" rates to apply to prices.
The user can enter up to two different production efficiencies which can be pulled into the annual timeline.

In addition to electricity sales the user has the ability to enter assumptions for subsidies per MWh.
Costs are entered for both fixed and variable costs.
Working capital assumptions are entered separately in days for electricity sales, subsidy sales, fixed costs and variable costs.

Tax assumptions are entered annually and paid in the year in which they accrue. The user has the option to enter an EBITDA restriction for interest deductibility.

Debt assumptions are entered including the term, the cost, the amount, the margin, the upfront fee, hedging portion of debt.

Finally the user can enter various acquisition assumptions including equity investment required and acquisition cost percentage.

This Best Practice includes
1 powerpoint of instructions, 1 excel model template

Acquire business license for $40.00

Add to cart

Add to bookmarks


Further information

To model out and get an initial view of the feasibility of an anaerobic digestion plant investment/purchase

When the user wants a quick answer as to the feasibility of an anaerobic digestion plant investment

When the user requires more specific and sophisticated mechanisms e.g. specific jurisdictional tax and subsidy calculations


  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from ModellingGuy

See all

Any questions on Anaerobic Digestion Plant Excel Model?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...