A free ESG value creation model for private equity in Excel
An ESG programme in a portfolio company priced the way an investment committee reads it: EBITDA effect, enterprise value at exit, equity, multiple on invested capital and IRR, plus the revenue it protects and what the exit multiple alone is worth.
An ESG programme saves 1.14 million of EBITDA a year and adds 9.69 million of enterprise value at an exit multiple of 8.5x. Carried through the capital structure it is worth 8.86 million of equity: MOIC 2.23x against 2.07x without it, IRR 22.2% against 20.0%.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
ESG_Value_Creation_Model.xlsx (25 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with The ESG Manager in Private Equity, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
7 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
The Inputs
The Chapter 10 case, plus the capital structure the book never states
Chapter 10, Restated
What the book computes, reproduced exactly
Through to Equity
The step to multiple on invested capital and rate of return
The Line That Was Dropped
Priced, at three attribution levels
The Half-Turn
What the multiple assumption is worth beside the programme
The Two Clocks
The eighteen-month claim, walked
Checks
Every figure in the appendix, recomputed here
What the worked case returns
Measure
Value
Combined EBITDA effect (millions)
1.14
Enterprise value contributed (millions)
9.69
Programme cost (millions)
0.83
Equity at exit, with the programme
125.00
Equity at exit, without it
116.14
MOIC, with
2.232x
MOIC, without
2.074x
IRR, with
22.23%
IRR, without
20.00%
Enterprise value protected by the compliance line, gross
6.89
What half a turn of exit multiple is worth
10.0
Half a turn of exit multiple is worth 1.03 times the whole programme. An ESG value creation case that does not separate the two is mostly a multiple assumption.
How to use it on your own case
Enter revenue, EBITDA, entry and exit multiples and the programme's savings and cost on The Inputs.
Add the capital structure: entry leverage, exit EBITDA and net debt at exit.
Read the effect on equity, MOIC and IRR on Through to Equity.
Price the revenue protected and compare the programme with the exit multiple assumption.
Questions people ask about it
How do you measure ESG value creation in private equity?
As any other value creation lever: its effect on EBITDA, carried at the exit multiple to enterprise value, then through net debt to equity, MOIC and IRR.
Should value protected count?
Spending that keeps customers or licences protects value rather than creating it. The file prices it separately, with an attribution share, so it is not double counted.
Why compare it with the exit multiple?
Because a small change in the assumed exit multiple can be worth more than the whole programme, which hides how much of a case rests on the programme itself.
Is this template really free?
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Go further
The free workbooks of The ESG Manager in Private Equity go further: the full companion set, blank models and the worked cases of the book.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.