Developing Comprehensive Financial Models to Forecast ROI

MCC Economics sets out how to build return on investment models for renewable energy projects that survive lender scrutiny: start from partnership and revenue structure, avoid the five recurring modelling mistakes, stress-test with sensitivity analysis, include the variables no model can skip, and treat policy and price volatility as live scenarios.

‍

Quick Answer

A credible return on investment forecast for a renewable energy project starts with the deal structure, not the spreadsheet: revenue stacks and banking consortia set what the model must prove. The recurring failures are over-optimistic revenue curves, under-modelled operating costs, confusing profit with cash, ignored capital stack effects and single-scenario optimism. Sensitivity analysis, one-way, multi-way and Monte Carlo, exposes which levers truly move IRR and NPV, and policy and price volatility, from CfD design to negative price hours, must be modelled as toggles, not assumed away.

‍

Key takeaways

‍

  • Partnership structure drives the spreadsheet: secure multi-bank or utility partnerships first; the numbers follow.
  • Mistakes are predictable: over-stated revenues, under-counted costs and single-scenario optimism.
  • Sensitivity is non-negotiable: Monte Carlo or multi-way analysis exposes weak covenants before lenders do.
  • Volatility and policy iterate: embed toggles for CfD and PPA shifts and feed them a volatile price curve, not a flat escalator.
  • Audit-ready models win capital: clear sheet architecture and cited sources build investor trust.

‍

‍Why do partnerships still make or break a model?

The 2024-25 landmark deals show that revenue stacks and banking consortia are set before the first formula is written, and each structure changes what the model must demonstrate. ‍

‍

Table 1 summarises three.

Region2024-25 landmark dealWhat it tells modellers
UKCleve Hill Solar plus 150 MW BESS: a £218.5m term loan jointly underwritten by NatWest and Lloyds, supported by a 15-year offtake for 65% of solar generation with Tesco and the UK’s largest solar allocation under CfD Round 4. Quinbrook Infrastructure PartnersStacking contracted and indexed revenues (CfD plus merchant PPA plus capacity) dramatically improves debt-service cover.
Abu DhabiAl Ajban 1.5 GW solar PV: bid won by Masdar, EDF Renewables and KOWEPO with a long-term energy-only PPA signed at WFES 2024. MasdarForeign equity plus local utility PPA lowers WACC; single-buyer risk supersedes merchant volatility.
AustraliaFRV nine-asset portfolio, about 1 GW PV plus 102.5 MW / 205 MWh storage: AU$90m senior debt from CEFC alongside 10 global commercial banks. CEFCPortfolio refinancing frees sponsor equity and diversifies cash flow, a template for multi-asset models.

Sources: Quinbrook Infrastructure Partners, Masdar and CEFC.

‍

‍

‍

What are the five biggest ROI-model mistakes?

‍

Seen across 2024-25 models, five errors recur:

‍

  • Over-optimistic revenue curves: “hockey sticks” with no bottom-up sales or PPA logic.
  • Under-modelled O&M escalation ignoring inverter replacements and high-voltage compliance costs.
  • Confusing profitability with liquidity the P&L shows profit while monthly cash turns negative.
  • Ignoring equity dilution and capital stack effects from layered funding rounds such as convertibles, mezzanine or green bonds.
  • Single-scenario bliss no base and downside cases or toggles for price and irradiance shocks.

‍

The full catalogue of failure modes is set out by Fin-Wiser.

‍

‍

‍

How do you put sensitivity analysis to work?

‍

Modern guidance emphasises three nested approaches, one-way, multi-way and probabilistic Monte Carlo sensitivity, to reveal which levers, irradiance, PPA price, CAPEX and debt margin, truly swing IRR and NPV.

  • Pinpoint the critical few variables before running hundreds of simulations.
  • Use tornado charts for board-level conversations; keep the heavy Monte Carlo in the background.
  • Pair sensitivity outputs with hedging or commercial mitigations, such as interest-rate swaps and EPC price caps.
  • Energy arbitrage calculations require assumptions for future market price, quantity and competitive dynamics; prices should reflect supply and demand assumptions.

‍

‍

‍

Which variables can no model skip?

‍

‍

Table 2: Five pillars every solar and renewable ROI model must cover.

‍

PillarEssential inputs and tips
Cost stackCAPEX (modules, inverters, HV works), EPC contingencies, land leases, network access, financing and development fees. Fin-Wiser
ProductionSite-specific GHI, degradation curve (-0.4% p.a. typical), availability losses, curtailment assumptions.
RevenuePPA tariff or index (CfD strike, merchant curve), RECs and REGOs, capacity payments, ancillary-service upside.
CapitalDebt tenor and sculpting, hedge premiums, equity IRR hurdle; for Australia add LGC price paths.
Policy and taxCfD indexation (UK), Dh tariff escalator (UAE), instant asset write-off and carbon credit price (AU).

Source: MCC Economics, drawing on Fin-Wiser’s modelling guidance.

How do you account for policy change and price volatility?

‍

In the UK, DESNZ’s 2025 CfD AR7 shift from a fixed budget to a “capacity ambition” meant bid sizing had to remain a live scenario until auction close, as Renewable Exchange explained.

‍

  • Wholesale price risk: 2024 saw record hours of negative power prices across Europe; statistical price models missed them, while fundamental dispatch models such as PLEXOS captured the -€100/MWh events, per Energy Exemplar.
  • Tariff benchmarks: the UK solar PPA market has been declining; Q3 2024 figures show average fixed-price solar PPAs near £76/MWh, suggesting downside cases could use £70/MWh or lower as a base, per Solar Power Portal.

‍

‍

‍

Where does CfD AR7 stand now? An update, September 2026

‍

The auction the article told modellers to keep as a live scenario has closed, and it rewarded the caution. AR7 results came in two stages: 8.4 GW of offshore wind in January 2026, then 6.2 GW across solar, onshore wind and tidal in February, including 4.9 GW of solar across 157 projects, the largest UK solar procurement in any CfD round, for a record 14.7 GW in total, as Energy UK summarises. Cleared solar strike prices support the article’s downside advice: RWE’s winning solar bids struck at £65.23/MWh in 2024 prices, below the £70/MWh downside base this article suggested.

‍

‍

‍

What is the single worst assumption you can make?

‍

“A flat 95% availability for 25 years. Real-world data shows outages and curtailment knock this to ~91% by year 10.” Fin-Wiser, on financial modelling mistakes.

How exactly does sensitivity analysis save deals?

‍

It highlights which covenant bites first. At Cleve Hill, a 10% CAPEX overrun hurt the DSCR more than a 5% PPA haircut, so lenders insisted on an EPC fixed price, not a higher tariff, as Quinbrook’s financing shows. Energy arbitrage calculations should reflect future competitive landscapes, and cost forecasts should reflect observed cost curves, especially if capex sits multiple years ahead.

‍

‍

‍

Which variables must every solar or renewable model include?

‍

LCOE inputs (CAPEX, OPEX, yield), financing metrics (WACC, DSCR), tax shields, degradation, curtailment, merchant tail and exit multiple, with optionality to add batteries if not already included, per Fin-Wiser’s checklist.

‍

‍

‍

How do you price in future policy shifts?

‍

Run a policy-off and policy-on pair of cases, for example a CfD lapse or a UAE green-certificate boost, then layer price-path volatility using a fundamental model to test break-even IRR under each regime, as Energy Exemplar describes. Try to insure against policy shifts: the USA offers recent examples of policy changes that negatively affected returns.

‍

References

‍

  1. CEFC. (n.d.). FRV Australia accelerates clean energy project pipeline. https://www.cefc.com.au/case-studies/frv-australia-accelerates-clean-energy-project-pipeline/‍
  2. DESNZ. (2026). Contracts for Difference (CfD) Allocation Round 7: Results. GOV.UK. https://www.gov.uk/government/publications/contracts-for-difference-cfd-allocation-round-7-results‍
  3. Energy Exemplar. (n.d.). Statistical vs. fundamental: Best price forecasting models for volatile energy markets. https://www.energyexemplar.com/blog/statistical-vs.-fundamental-best-price-forecasting-models-for-volatile-energy-markets‍
  4. Energy UK. (2026). Energy UK explains: Allocation Round 7 results. https://www.energy-uk.org.uk/publications/energy-uk-explains-allocation-round-7-results/‍
  5. Fin-Wiser. (2024, December 23). Building financial models for solar and wind projects: Key considerations. https://fin-wiser.com/2024/12/23/building-financial-models-for-solar-and-wind-projects-key-considerations/‍
  6. Fin-Wiser. (2025, April 24). Top financial modeling mistakes that cost startups millions. https://fin-wiser.com/2025/04/24/top-financial-modeling-mistakes-that-cost-startups-millions/‍
  7. Masdar. (n.d.). EWEC announces partners to develop solar project in Abu Dhabi. https://masdar.ae/en/news/newsroom/ewec-announces-partners-to-develop-solar-project-in-abu-dhabi‍
  8. Quinbrook Infrastructure Partners. (n.d.). Quinbrook closes UK’s largest solar PV battery storage project financing for Cleve Hill Solar Park. https://www.quinbrook.com/news-insights/quinbrook-closes-uks-largest-solar-pv-battery-storage-project-financing-for-cleve-hill-solar-park/‍
  9. Renewable Exchange. (n.d.). DESNZ announces reforms for CfD AR7. https://renewable.exchange/blog/desnz-announces-reforms-for-cfd-ar7‍
  10. RWE. (2026, February 10). RWE secures Contracts for Difference for 290 megawatts of solar PV and onshore wind capacity in UK Allocation Round 7. https://www.rwe.com/en/press/rwe-renewables-europe-australia/2026-02-10-rwe-secures-contracts-for-difference-for-290-megawatts/‍
  11. Solar Power Portal. (n.d.). Solar PPA prices stable after extended European decline. https://www.solarpowerportal.co.uk/solar-ppa-prices-stable-after-extended-european-decline/

Authors

‍

 What’s next

No items found.

Featured

This paper has been published on following other platforms

No items found.

I was delighted that MCC's work was completed on time, and within budget, helping us deliver important changes and improvements, to the benefit of our stakeholders. ​ MCC's report is published on the CCC website.

- Bea Natzler
Team Leader at Climate Change Committee, UK

I am delighted to recommend MCC Economics. Specifically, I worked closely with PJ, who helped us with our Nuclear and CCUS projects. PJ helped us develop new policies and answer questions from our stakeholders. ​​His support helped us deliver important changes and improvements, to the benefit of our stakeholders.

- Gordon Hutcheson
Head of Nuclear Policy at Ofgem, UK

MCC Economics has helped us better understand the most important issues for our stakeholders, including: charges, shareholder returns, debt payments and inflation impacts.

- Leila N. Nasr
Section Head at Department of Energy, Abu Dhabi

I am delighted to recommend PJ and his team at MCC Economics. We've been working together on National Policy Statements to help meet net zero targets for 2030 and 2050. We initially appointed MCC Economics to support us on offshore wind consultation analysis and have recently reappointed MCC Economics to undertake a larger consultation analysis role across all sectors, including hydrogen, CCUS and networks. I can confirm that PJ and his team have shown excellent spreadsheet skills, alongside very good project management, planning and analysis skills, helping us deliver important changes, and continuous improvements, to the benefit of our stakeholders.

- Amy McHugh
Head of Environment in the Energy Infrastructure Planning Policy, UK

I am delighted to recommend PJ and his team from MCC Economics. They helped us with our price controls for Heathrow airport and for NATS (En Route) plc (the air traffic services provider). Specifically, the MCC team helped us deliver important changes and improvements to our financial models and supporting policy documents, to the benefit of our stakeholders.

- Dan Rock
Head of Corporate Finance at CAA, UK

I am delighted to confirm that I worked with PJ on a retail project in 2015. The project helped stakeholders understand electricity costs and charges. Specifically, the project helped us explain to stakeholders, internally and externally, why electricity charges differed across the regions (GB, NI & Ireland). PJ was a key member on the project team, which helped deliver changes and improvements in the understanding of energy retail.

- Kevin Shiels
Director at Utility Regulator, Northern Ireland