Free Excel templates

A free operational due diligence scorecard in Excel

An operational due diligence rating model for fund managers: eight risk domains, veto domains and thresholds, twelve managers scored by averaging and by veto rules, three weighting schemes and how far each rating is from flipping.

Twelve fund managers are scored from 1 to 5 on eight operational risk domains. Of the twelve, 3 carry a fatal flaw (a 5 in a veto domain), and the simple average gives every one of them its top rating. A manager with no independent custody scores 1.500, better than one with no fatal flaw at 2.250.

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.

Operational_Due_Diligence_Scorecard.xlsx (24 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 Operational Due Diligence in Private Equity, which explains the method behind it, chapter by chapter.

Get the book on Amazon → Or the DRM-free PDF edition, $19.99

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

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).

Get the Library, $79 →

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

6 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

The model
Domains, veto flags, thresholds.
The book
Twelve managers scored, both decision rules side by side.
Compensation
How good the rest has to be, and the granularity paradox.
Weights
Three schemes, and what they change.
Fragility
How far each manager sits from a different answer, in analyst-points.
Checks
Every figure in Appendix E, tested.

What the worked case returns

MeasureValue
Risk domains8
Approve at or below2.0
Approve with conditions at or below3.0
Managers with a fatal flaw3
...of whom the average approves3
Score of the manager with no independent custody1.500
Score of a manager with no fatal flaw2.250
Average needed elsewhere to hide a 5, eight domains1.571
Average needed elsewhere, sixteen domains1.800

Adding domains makes it easier, not harder, to hide a fatal flaw: at sixteen domains the other fifteen only need to average 1.800. Weighting changes nothing either. Veto rules do: a 5 in a veto domain rejects the manager whatever the average says.

How to use it on your own case

  1. List your risk domains on The model, flag the veto domains and set the thresholds.
  2. Score each manager from 1 to 5 on each domain on The book.
  3. Compare the decision by averaging with the decision by veto rules.
  4. Test weighting schemes and read how many notches of disagreement would change each rating.

Questions people ask about it

What is operational due diligence?

The review of a fund manager's operations rather than its strategy: governance, controls, custody of assets, service providers, compliance, technology and valuation.

Why not just average the scores?

Because an average lets good scores elsewhere bury a fatal weakness. A manager with no independent custody can still come out with a top rating. Veto rules stop that.

Can I add my own domains?

Yes. Inputs are open. Adding domains lowers the weight of each one, which is exactly why the file adds veto rules rather than more domains.

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 Operational Due Diligence in Private Equity go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with Operational Due Diligence in Private Equity. The book is on Amazon.

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.