Investor Model Review
Executive Summary
Key Takeaways
- ✓ Investor model review centers on return calculation integrity — IRR and multiple-of-invested-capital mechanics, waterfall and carried interest calculation — a distinct focus from a lender's covenant and debt-service emphasis.
- ✓ IRR should be independently recalculated from the model's underlying cash flow timing and amounts, not accepted as reported, since a manually entered or formula-broken IRR figure is one of the most consequential possible errors in an investment decision.
- ✓ Waterfall and carried interest calculations introduce their own structural risk — a multi-tier distribution waterfall with hurdle rates and catch-up provisions is a common source of formula error distinct from the underlying cash flow projection itself.
- ✓ Sensitivity and scenario analysis completeness is itself a review criterion — a model showing only a single base case return, with no downside sensitivity, does not give an investment committee the range of outcomes needed for an informed decision.
- ✓ Cash flow timing accuracy is a specific, high-leverage check in investor model review, since IRR is highly sensitive to the exact timing of cash flows, and a model with dates entered inconsistently or approximately can materially misstate the calculated return.
Objective¶
This guide covers investor model review — return calculation integrity and risk allocation testing — within the Financial Model Due Diligence pillar. It shares structural audit methods with Lender Model Review and Independent Model Review, but its focus is distinct.
Scope¶
| Area | What Is Tested |
|---|---|
| Return calculation | IRR, MIRR, and Equity IRR independently recalculated from underlying cash flow timing and amounts |
| Distribution waterfall | Hurdle rates, catch-up provisions, and carried interest split calculated and sequenced correctly |
| Cash flow timing | Dates entered consistently and precisely, since return metrics are highly timing-sensitive |
| Sensitivity and scenario completeness | Downside and upside cases modelled explicitly, not only asserted narratively |
Why IRR Recalculation Is Central¶
A displayed IRR figure should never be accepted at face value — it should be independently recalculated directly from the model's underlying cash flow timing and amounts, tracing the formula rather than reading the summary output. A manually entered or formula-broken IRR is among the most consequential possible errors in an investment decision, since it is frequently the single figure an investment committee relies on most heavily. See IRR and MIRR for the underlying calculation mechanics.
Waterfall and Carried Interest Risk¶
A multi-tier distribution waterfall — return of capital, a preferred return hurdle, a general partner catch-up, and a carried interest split on remaining profit — introduces its own structural risk distinct from the underlying cash flow projection. Each tier's calculation, and the sequencing logic determining how cash flows through the tiers, should be independently traced, since an error in tier sequencing can materially misstate how much of a given distribution actually reaches each party.
Sensitivity and Scenario Completeness¶
A model presenting only a single base case return does not provide an investment committee the range of outcomes needed for an informed decision. Investor model review specifically checks that downside and upside scenarios — driven by the same underlying assumptions varied systematically, not narratively described — are actually built into the model. See Scenario Analysis and Sensitivity Analysis.
Structural Checks Specific to Investor Model Review¶
| Check | What It Catches |
|---|---|
| IRR and MIRR independently recalculated from underlying cash flow timing and amounts | A manually entered or formula-broken return figure |
| Every distribution waterfall tier traced and tested in sequence | An error in hurdle, catch-up, or carry calculation misallocating distributions |
| Cash flow dates entered consistently and precisely across the model | A timing error materially misstating the calculated return |
| Downside and upside scenarios built as live model cases, not narrative assertions | An investment committee decision made without visibility into the actual range of outcomes |
Continue Reading¶
Prerequisites¶
- Financial Model Due Diligence — the parent pillar
Related Glossary¶
Related Technical Guides¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What does investor model review focus on?
Return calculation integrity — the mechanics of IRR and multiple-of-invested-capital calculation, distribution waterfall and carried interest structure, and the completeness of sensitivity and scenario analysis around the base case return — commissioned by an equity investor or limited partner ahead of a transaction.
How is investor model review different from lender model review?
A lender model review focuses on covenant compliance and debt service capacity — whether the borrower can meet its debt obligations. Investor model review focuses on the return the equity investor will actually realize and how that return is allocated among co-investors — a materially different set of structural priorities even where both reviews test the same underlying model.
Why must IRR be independently recalculated rather than accepted as reported?
Because a manually entered or formula-broken IRR figure is one of the most consequential possible errors in an investment decision — IRR should be recalculated directly from the model's underlying cash flow timing and amounts, not read off a displayed summary cell that may not correctly reference those inputs.
What structural risk do distribution waterfalls introduce?
A multi-tier waterfall with hurdle rates, catch-up provisions, and carried interest splits is a common source of formula error distinct from the underlying cash flow projection itself — each tier's calculation and the sequencing between tiers should be independently traced and tested.
Why does sensitivity and scenario analysis completeness matter as a review criterion?
Because a model showing only a single base case return does not give an investment committee the range of outcomes needed for an informed decision — a complete investor model review checks that downside and upside scenarios are modelled, not only asserted narratively.
Why is cash flow timing accuracy specifically emphasized in investor model review?
Because IRR is highly sensitive to the exact timing of cash flows, and a model using approximate or inconsistently entered dates can materially misstate the calculated return even if every cash flow amount itself is correct.
Related Articles
Financial Model Due Diligence
Financial model due diligence is the discipline of testing whether the financial model used to price, structure, or finance a transaction is itself structurally sound — a distinct question from whether the target business's historical financials are reliable (the domain of financial due diligence) or whether its commercial prospects are durable (commercial due diligence). A model can be structurally unsound — an untraceable synergy figure, a broken purchase price allocation link, a hardcoded override masking the true output of a formula — independent of whether the underlying business is fundamentally healthy, and this risk is what financial model due diligence is specifically built to catch. This page is the hub for the Knowledge Centre's model-risk-in-transactions content: how model review differs by audience (independent, lender, investor, vendor), how it differs from a quality of earnings review, and how transaction-specific model risk maps onto FMAE's own structural rule set.
Model Risk During Transactions
Model risk during a transaction concentrates in mechanics that do not exist in either party's ordinary-course, standalone model — purchase price allocation, financing structure, pro-forma consolidation, and synergy assumptions — each a new potential point of structural failure introduced specifically by the transaction itself. This guide maps where that risk concentrates and why it is structurally independent of whether the underlying business being acquired is fundamentally sound.
Independent Model Review in Transactions
An independent model review, in a transaction context, is commissioned by the deal team itself for its own internal assurance ahead of investment committee approval — testing the transaction model's structural integrity separately from, and in addition to, the commercial and financial due diligence already underway. It shares its underlying methodology with the general independent model audit discipline, applied specifically to the transaction model and its combination mechanics.
IRR (Internal Rate of Return)
Internal Rate of Return (IRR) is the discount rate at which the net present value of a series of cash flows equals zero. It is the generic form of a metric that appears in financial models in several more specific variants, most commonly Project IRR and Equity IRR, each defined on its own cash flow basis. This page defines the generic IRR concept and the Excel functions used to calculate it; for the project finance-specific variants, see Project IRR and Equity IRR.
MIRR (Modified Internal Rate of Return)
Modified Internal Rate of Return (MIRR) is a capital budgeting metric that corrects two specific weaknesses of IRR — its implicit assumption that interim cash flows are reinvested at the IRR itself, which is often unrealistic, and its potential to produce multiple or no real solutions for a non-conventional cash flow series. MIRR resolves both by using an explicit finance rate for outflows and a separately specified reinvestment rate for inflows, producing a single, more defensible rate of return.
Equity IRR
Equity IRR (Equity Internal Rate of Return) is the discount rate at which the net present value of all equity cash flows — comprising the initial equity investment as a negative cash flow and subsequent distributions and terminal proceeds as positive cash flows — equals zero. It measures the annualised return earned by equity investors on capital contributed to a project or transaction, calculated on post-debt-service cash flows only. Equity IRR is distinct from Project IRR, which is calculated on total project cash flows before financing. Equity IRR is always higher than Project IRR in a positively leveraged transaction because debt amplifies equity returns. It is lower than Project IRR when leverage is negative — that is, when the cost of debt exceeds the unlevered return of the project.
Scenario Analysis
Scenario analysis is the process of recalculating a financial model's outputs under a defined set of alternative assumptions that together represent a coherent possible future state. Each scenario changes multiple assumptions simultaneously to reflect a plausible economic environment or operational outcome — for example, a scenario in which both construction costs are higher than expected and revenue is lower than expected during the ramp-up phase. Scenario analysis is distinct from sensitivity analysis, which changes one variable at a time while holding all others constant. Scenario analysis tests the model under internally consistent combinations of assumptions; sensitivity analysis tests the model's response to changes in individual variables in isolation.
Sensitivity Analysis
Sensitivity analysis is the quantitative assessment of how much a financial model's output changes when a single input variable is changed by a defined amount, while all other variables are held at their base case values. It measures the responsiveness — or sensitivity — of outputs to individual assumption changes. Sensitivity analysis is distinct from scenario analysis, which changes multiple assumptions simultaneously to reflect a coherent alternative state. Sensitivity analysis isolates the effect of individual variables; scenario analysis tests the combined effect of assumption sets.