Energy Model Audit
Executive Summary
Key Takeaways
- ✓ A structural audit of an energy model tests whether the technical output chain, revenue stack, operating cost build, and debt sculpting formulas actually calculate correctly as built, not whether the underlying resource, price, or cost assumptions are themselves reasonable.
- ✓ The audit should trace each stage of the technical output chain (resource yield, degradation, curtailment, availability) independently, confirming each stage's formula correctly feeds the next rather than a single blended output figure that obscures which stage a formula error resides in.
- ✓ The revenue stack audit should confirm the sum of contracted, capacity, and merchant components reconciles exactly to the reported total revenue, with any residual investigated rather than dismissed as immaterial.
- ✓ Debt sculpting circularity should be tested for genuine convergence, not just an absence of calculation errors, since a circular calculation can appear error-free while still resolving to an unstable or manually overridden value.
- ✓ Energy model audit is distinct from energy model validation — the audit tests formula and structural integrity; validation additionally assesses the reasonableness of the underlying assumptions and methodology.
Objective¶
This guide sets out the structural audit scope specific to an energy or power project financial model, within Energy Financial Modelling, building on the general Financial Model Auditing discipline this domain applies.
Auditing the Technical Output Chain Stage by Stage¶
The audit should trace resource yield, degradation, curtailment, and availability as distinct, sequential stages, formula-checking each independently rather than auditing only a single blended output figure. This lets the auditor pinpoint exactly which stage — resource conversion, degradation application, curtailment reduction, or availability adjustment — a formula error actually resides in, consistent with the sequential build described in Power Project Financial Model Structure.
Auditing the Revenue Stack Reconciliation¶
The audit should confirm that the sum of the contracted, capacity, and merchant revenue components reconciles exactly to the model's reported total revenue figure. Any residual between the sum of the components and the total — however small — should be investigated rather than dismissed, since it typically indicates either a missing revenue source not yet captured in any component, or double-counting where the same output volume is attributed to more than one component.
Testing Debt Sculpting Circularity for Genuine Convergence¶
Where debt sculpting is circular by design, the audit should test for genuine convergence — not merely confirm the calculation displays without a visible error. A circular calculation can appear stable while actually resting on a manual override rather than a genuinely converged solution, or oscillating across recalculation passes without settling to a stable value. The audit should toggle any manual override and confirm the calculation converges to the same value independent of the override's setting, consistent with the treatment described in Circularity in Debt Models.
Distinction from Energy Model Validation¶
Audit tests whether the model's formulas, as actually built, calculate correctly — a structural, mechanical question about the model's own internal logic. Energy Model Validation additionally assesses whether the underlying assumptions and methodology are themselves reasonable — a substantive, judgment-based question distinct from, and typically applied after, the structural audit has confirmed the model's mechanics are sound.
Common Pitfalls¶
Blended technical output audited as one figure. Auditing only the final combined output figure, without tracing each stage of the technical chain independently, can miss which specific stage contains a formula error.
Revenue stack residual dismissed as immaterial. Failing to investigate a small unreconciled residual between the revenue components and the reported total can leave a genuine missing or double-counted revenue source unaddressed.
Circularity checked for errors only, not convergence. Confirming a circular calculation displays without error, without testing whether it genuinely converges, can miss an unstable or manually overridden calculation.
Recommended Practices¶
- Trace and formula-check each stage of the technical output chain independently.
- Confirm the revenue stack's components reconcile exactly to the reported total, investigating any residual.
- Test debt sculpting circularity for genuine convergence, toggling any manual override to confirm stability.
- Distinguish audit findings (structural/formula integrity) from validation findings (assumption reasonableness) explicitly in reporting.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Industries¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What does a structural audit of an energy model actually test?
Whether the formulas as actually built in the technical output chain, revenue stack, operating cost build, and debt sculpting modules calculate correctly — testing the model's own internal logic and formula integrity, not whether the underlying resource, price, or cost assumptions themselves are reasonable, which is a validation question rather than an audit question.
Why should the technical output chain be traced stage by stage?
Because tracing resource yield, degradation, curtailment, and availability as distinct, sequential stages, each formula-checked independently, lets an auditor pinpoint exactly which stage a formula error resides in — auditing only the final combined output figure would identify that an error exists without revealing where in the chain it originates.
What should the revenue stack audit confirm?
That the sum of the contracted, capacity, and merchant revenue components reconciles exactly to the model's reported total revenue figure, with any residual — however small — investigated rather than dismissed, since an unexplained residual typically indicates either a missing revenue source or double-counting between components.
Why is debt sculpting circularity tested for convergence, not just calculation error?
Because a circular calculation can display without any visible error while still resolving to an unstable value across recalculation passes, or resting on a hardcoded manual override rather than a genuine converged solution — testing convergence specifically, by toggling any override and confirming the calculation stabilizes to the same value, catches an instability that a simple formula-error check would miss.
How does energy model audit differ from energy model validation?
Audit tests whether the model's formulas, as actually built, calculate correctly — a structural, mechanical question. Validation additionally assesses whether the underlying assumptions and methodology (the resource yield basis, the price forecast methodology) are themselves reasonable — a substantive, judgment-based question distinct from, and typically following, the structural audit.
References
Related Articles
Energy Financial Modelling
Energy financial modelling is the discipline of building financial models for power generation assets, independent power producers, and renewable energy projects — structured around a technical output schedule and an electricity revenue stack that a standard corporate or general project finance model has no direct equivalent for. This page is the hub for the Knowledge Centre's energy and power modelling content: how a power project model is architected, how electricity markets and dispatch mechanics translate into revenue, and how power purchase agreements, capacity payments, and merchant exposure combine into a project's revenue structure. Technology-specific renewable energy models (solar, wind, storage, hydro, and others), technical and commercial modelling mechanics, and institutional practice for this asset class are indexed here as the domain expands.
What Is a Financial Model Audit?
A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.
Energy Model Validation
Independent validation of an energy or power project financial model tests three distinct pillars: conceptual soundness of the resource yield, degradation, and price forecasting methodology, implementation accuracy of that methodology in the actual model build, and ongoing outcomes performance once the asset is operational. This guide sets out how each pillar applies to this domain, extending the general model validation discipline with the resource- and market-specific judgment this asset class requires.
Power Project Financial Model Structure
A power generation financial model is architected around a technical output schedule — generation volume for a variable-output asset or available capacity for a dispatchable one — that drives every downstream calculation: the electricity revenue stack, the operating cost build, and, where the asset is project-financed, debt sculpting and covenant testing. This guide sets out that architecture as a sequence of explicit, separately built modules, distinct from a standard corporate model's revenue-growth-first structure.
Financial Model Audit for Renewables
Renewable energy financial models combine standard project finance debt sculpting with technical assumptions specific to the energy source, resource yield (solar irradiance or wind speed), equipment degradation over the asset life, and curtailment risk, that directly determine the cash flow feeding the debt structure. Power purchase agreement pricing and tenor, and the merchant tail risk once a PPA expires, add a further layer of revenue structure specific to this sector. This page sets out the modelling risks specific to renewables, the audit findings that recur across solar, wind, and storage financings, and what lenders typically expect before financial close.