Decision-making toolkit

M&A financial model

Comprehensive details to model the transaction, financing, tax and accounting assumptions over an asset whose cost and production you have already modelled.

Overview

What M&A does

The M&A model is designed for transactions on existing or consented assets. It covers all critical areas, including financing, energy generation, power pricing, tax, capital allowances, and cash flow, ensuring a robust foundation for equity valuation.

This model provides greater detail than the pre-FID version where deals are won or lost. It manages complex factors like tax treatments and working capital precisely, while integrated sensitivity grids allow you to stress-test price, availability, and discount rates instantly.

A dedicated time series editor manages annual variables such as power prices and inflation. This preserves the unique profile of your data, avoiding the inaccuracies inherent in using forced averages.

Assumptions are managed via named scenarios. You can host bid, vendor, and lender cases within a single project, allowing for direct line-by-line comparison while maintaining distinct results for each.

Live · Demonstration project

£677m

Total value, levered — equity plus debt

Unlevered enterprise value £622m HoldCo debt raised £415m Equity NPV, levered £262m

Equity plus debt, against the 8% unlevered case — leverage is worth £55m here

Top features

What you get with M&A

  1. Transaction structure and financing

    Proposed transaction and indicative financing modelled explicitly — consideration, debt sizing, gearing and the cash and equity flows to ensure price and the structure are tested together.

  2. Tax, allowances and the balance sheet

    Capital allowances, opening balance sheet, opening finance leases and working capital fully accounted for, as the assumptions that influence valuation.

  3. Revenue that reflects the market

    Power prices, renewable obligation certificates and inflation factors, with a time series editor for inputs that change year-by-year.

  4. Availability as an input, not a hope

    Turbine availability modelled alongside generation, and traceable to the OPEX scenario and energy yield calculation. This ensures that the valuation is using the same, shared data source.

  5. Sensitivities and discount rates

    A structured sensitivity chapter and explicit discount rate assumptions, so the range around the headline number is calculated instantly within the model.

  6. Scenarios per counterparty

    Bid, vendor, base and downside cases as named scenarios with their own stored results, comparable side by side.

Illustrative examples

M&A in use

Drawn in the product's own interface, and every figure is real: they come from our live Demonstration project — a 288.75 MW floating wind farm in the central North Sea — and its Default Scenario, so anything shown here can be reproduced in front of you. No client or commercial data appears on this page.

Illustrative

The transaction, modelled as a transaction

Stake, valuation date, financing and the opening balance sheet are inputs in their own right — not adjustments made to a project model after the fact. This run values a 49% stake in the operating asset from a 30 June 2020 valuation date.

Project Demonstration project Scenario Default Scenario Project team
Proposed transaction Indicative financing Scenario selectors Energy generation Prices — ROC Tax Capital allowances Sensitivities Discount rates

Proposed transaction

Proposed transaction

GBP
Stake acquired
49%
Valuation date
30 Jun 2020
Financial close
31 Dec 2020
The asset Read from the project, not retyped
Linked 25 × 11.55 MW
Operating window 31-year model, decommissioning 2045
2020–2045

Indicative financing

HoldCo level
HoldCo debt raised Sized off the P90 case
414.77£m
Margin Steps up at year 5 and again at year 10
1.80% → 1.90% → 2.00%
Sculpting target Contracted revenue against merchant
1.25× / 2.25× DSCR
Discount rates Unlevered and levered
8.00% / 10.00%
Corporation tax With capital allowances modelled separately
19%

Unlevered to levered

£m
Unlevered enterprise value, at 8.00% 622.03
Equity NPV, levered, at 10.00% 262.13
HoldCo debt raised 414.77
Total value, levered — equity plus debt 676.90
Gain from leverage, against the unlevered case 54.87

Leverage is worth £54.87m of total value here, and the equity that remains after servicing it is worth £262.13m discounted at 10.00%. Both numbers move when the debt does, which is why the financing sits in the model rather than beside it.

Illustrative

Revenue with its shape kept

Electricity, ROCs and REGOs are three revenue streams with three different indexation paths and three different end dates. Averaging them into one price per MWh is how a valuation loses the thing it was supposed to be testing.

Project Demonstration project Scenario Default Scenario Project team
Proposed transaction Indicative financing Scenario selectors Energy generation Prices — ROC Tax Capital allowances Sensitivities Discount rates

Revenue, operating cost and cover

£m per year Quarterly model, shown annually
Line 202120222023202420252026
Net generation, MWh P50, after 0.2% curtailment 1,115,7391,115,7391,115,7391,115,7391,115,7391,115,739
Electricity revenue 45.0848.0451.4152.8754.1955.05
ROC revenue 2 ROCs/MWh, fixed at £55.055 from 1 Apr 2027 120.67123.98127.39130.90134.50138.20
REGO revenue 0.390.400.410.410.420.43
Operating cost -34.83-33.05-32.64-33.77-31.95-31.69
Adjusted EBITDA 131.31139.37146.57150.41157.16161.99
HoldCo DSCR 2.84×2.84×2.85×2.86×2.85×2.85×

Where the revenue comes from

Share of total, by year
Year Total, £m Electricity / ROC / REGO Support share
2021 166.14 72.9%
2022 172.42 72.1%
2023 179.21 71.3%
2024 184.18 71.3%
2025 189.11 71.3%
2026 193.68 71.6%
Electricity ROCs REGOs

Around three quarters of revenue is support, and the ROC recycling and buy-out prices are separate inputs with their own indexation — so the date that support ends is one of the most consequential assumptions in the model, and it is visible rather than buried in a blended price.

See it on your own project

Book a demo and we will walk through the module with your numbers, not ours.

Book a demo