Investment Committee Model Checklist
Executive Summary
Key Takeaways
- ✓ Investment committee models are decision documents, not just calculation tools; structural review must cover both the numbers and whether they are presented in a way the committee can actually interrogate.
- ✓ Return metrics (IRR, MOIC, payback) are recalculated independently rather than accepted at the value shown, since these are the figures most directly tied to the decision being made.
- ✓ A downside or stress scenario is a minimum requirement for committee submission, not an optional addition, since a base-case-only model does not show the committee its actual risk exposure.
- ✓ Disclosure of assumption sourcing and sensitivity ranges is itself a structural checklist item, not a narrative nicety, because an unsupported assumption is a decision risk in its own right.
Objective¶
This checklist verifies that a financial model submitted for investment committee approval is structurally sound and presents an honest, interrogable basis for the committee's decision. It exists as a distinct checklist because a committee-facing model has requirements beyond general structural soundness: its return metrics must be independently verifiable, its scenario coverage must show genuine downside risk, and its figures must reconcile exactly to the narrative memo built around it.
A model can pass every general structural check in the Financial Model Audit Checklist and still fail a committee's needs if it shows only a favourable base case, buries key assumptions, or presents a headline IRR that does not reconcile to its own cash flow schedule.
Applicability¶
Applicable whenever a financial model is being prepared for, or reviewed ahead of, submission to an investment committee, whether for a new investment, an acquisition, a capital allocation decision, or a follow-on funding round. Also applicable to committee members themselves as a structured basis for questioning a model before approval, rather than relying solely on the accompanying memo narrative.
Checklist¶
| # | Check Item | Why It Matters | Evidence to Collect |
|---|---|---|---|
| 1 | IRR is independently recalculated from the underlying cash flow schedule, not accepted at face value | IRR is highly sensitive to cash flow timing and sign convention errors that do not show in the headline figure | Independent IRR recalculation output |
| 2 | MOIC and payback period are calculated and shown alongside IRR, not IRR alone | A single return metric can present a misleading picture under certain cash flow timing patterns | Multi-metric return summary |
| 3 | Cash flow timing (entry date, exit date, interim distributions) matches the assumptions stated in the memo | A mismatch between modelled timing and stated timing directly misstates the return calculation | Timing reconciliation between model and memo |
| 4 | A defined downside scenario exists with explicit, named assumption changes, not an arbitrary blanket haircut | Committees need to see which specific assumptions drive the downside, not just a lower aggregate number | Downside scenario assumption log |
| 5 | Downside and upside scenarios flow through the entire model to produce their own return metrics | A scenario that changes inputs but does not fully propagate produces a false sense of stress-testing | Scenario propagation test results |
| 6 | Every headline figure in the investment memo traces directly to a specific model cell or output | Memo/model mismatches are a common source of committee decisions based on figures the model does not actually support | Memo-to-model traceability check |
| 7 | Key assumptions (growth rates, exit multiple, discount rate) are sourced and documented, not left as unexplained inputs | An unsupported assumption is itself a decision risk; the committee should be able to see the basis for each key input | Assumption sourcing documentation |
| 8 | Sensitivity analysis covers the assumptions the return is most exposed to, identified by a formal sensitivity test | Sensitivity tables built around the wrong variables give the committee false confidence in the model's stability | Sensitivity/tornado analysis output |
| 9 | Exit or terminal value assumptions are clearly flagged as a distinct, separately-sourced input | Exit assumptions frequently drive the majority of a return calculation and warrant explicit scrutiny separate from operating assumptions | Exit value assumption documentation |
| 10 | Fees, carried interest, and other return-reducing mechanics are included in the net return calculation shown to the committee | A gross return figure presented without fee and carry drag overstates what capital providers actually receive | Gross-to-net return reconciliation |
| 11 | Model version submitted to committee matches the version referenced in the memo and any prior committee discussion | Version drift between submission and discussion undermines the committee's ability to rely on prior review | Version control log |
| 12 | Circular references (e.g. in IRR-dependent fee calculations) resolve correctly and stably | Fee structures tied to IRR hurdles can introduce circularity that, if unresolved, produces an inconsistent net return figure | Circularity resolution test |
Common Failures¶
- IRR quoted in the memo that does not match a recalculation from the model's own cash flow schedule, often due to a sign or timing error in an interim cash flow.
- Downside case built as a flat percentage haircut on revenue rather than named, specific assumption changes, giving the committee no insight into what actually drives the downside.
- Exit multiple or terminal value assumption left unsourced, with the entire return sensitive to a single unexplained input.
- Fee and carried interest mechanics omitted from the return shown to the committee, presenting a gross rather than net figure without disclosure.
- Memo figures pulled from an earlier model version that was subsequently revised, with no reconciliation performed before submission.
- Sensitivity table built around convenient variables rather than the ones formally identified as most material to the return outcome.
Recommended Evidence¶
A completed committee submission should be accompanied by an independent return recalculation, a memo-to-model traceability check, and a scenario assumption log documenting the base, upside, and downside cases. The table above is structured for direct use in model governance documentation or an audit working-paper file, and can be attached as a supporting exhibit to the investment committee memo itself.
How to Use This Checklist¶
Run the general Financial Model Audit Checklist first to confirm structural soundness, then work through this checklist focusing on return verification, scenario coverage, and memo reconciliation before the model is submitted. Committee members can also use the checklist directly during review to identify which items were not adequately addressed in the submission. See Family Office Catches an Overstated IRR Before Committing Capital for an applied example.
Continue Reading¶
Related Pillars¶
Related Checklists¶
Related Case Studies¶
- Family Office Catches an Overstated IRR Before Committing Capital
- Private Equity Firm Re-Trades Deal After Inflated Synergy Assumptions Found
Related Resources¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is an investment committee model checklist used for?
Verifying that a financial model submitted to support an investment decision is structurally sound, its return metrics are independently verifiable, and its scenario coverage gives the committee an honest view of downside risk before approval.
Why does IRR need to be independently recalculated rather than just reviewed?
IRR is highly sensitive to cash flow timing and sign errors that are not visible from the headline number alone. Independent recalculation from the underlying cash flow schedule is the only reliable way to confirm it.
What counts as adequate downside scenario coverage?
At minimum, a defined downside case with explicit assumption changes (not just an arbitrary percentage haircut) that flows through the full model, producing its own return metrics for committee comparison against the base case.
Should the model and the investment memo always match exactly?
Yes. Any figure quoted in the memo should trace directly to the model output. A mismatch between memo and model is itself a red flag, regardless of which one is correct.
Who is responsible for completing this checklist?
Typically the deal team or finance function preparing the submission, sometimes supplemented by an independent structural review before the model reaches the committee.
Does this checklist replace independent model audit before committee submission?
For lower-materiality decisions it may serve as a sufficient internal check. For higher-materiality decisions, an independent structural audit is the more rigorous standard; see the Financial Model Audit Checklist and Financial Model Auditing pillar.
What is MOIC and why does it appear on this checklist?
Multiple on invested capital, a return metric alongside IRR. It is checked because it can diverge materially from IRR under certain cash flow timing patterns, and a committee reviewing only IRR can be shown a misleading picture.
How does this checklist differ from the acquisition model checklist?
The acquisition checklist covers M&A-specific combination mechanics. This checklist covers the general presentation and return-verification standard for any model reaching an investment committee, acquisition or otherwise.
Related Articles
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.
What Is Model Risk?
Model risk is the risk that a decision is wrong not because the underlying business or investment case was flawed, but because the model used to evaluate it was. It is a distinct category of risk from market risk, credit risk, or operational risk, and it applies to any organisation that relies on a financial model, spreadsheet or otherwise, to support a material decision. Most published model risk content addresses statistical and regulatory capital models used inside banks. This page defines model risk specifically as it applies to Excel based financial models, the kind used every day for investment decisions, lending, and transaction evaluation, which is a related but distinct problem from the quantitative model risk literature most search results return.
Audit vs Validation — What's the Difference?
Financial model audit and model validation are frequently used as interchangeable terms, and specifying the wrong one in a lender requirement or an internal policy leads to real confusion about what has actually been checked. They test different things. An audit tests whether a model's mechanics are correct. Validation tests whether the model's methodology and assumptions are appropriate for its intended purpose. Both are legitimate, useful exercises. They are not substitutes for each other.