Capital Budgeting Decision Checklist
Executive Summary
Key Takeaways
- ✓ This checklist is a pre-decision review discipline, applied before a capital budgeting analysis reaches an investment committee, lender, or other decision-making audience.
- ✓ Discount rate basis and timing convention consistency are the two most common sources of a silently incorrect NPV/IRR result.
- ✓ NPV and IRR/MIRR rankings should always be cross-checked, since they can conflict for mutually exclusive projects of different scale or cash flow pattern.
- ✓ A capital budgeting analysis without any sensitivity coverage on the discount rate and key drivers presents a false sense of precision to its decision-making audience.
Objective¶
This checklist sets out the review disciplines a capital budgeting or investment appraisal analysis should pass before it is presented to an investment committee, lender, or other decision-making audience. It is scoped specifically to the decision layer built on top of a project's cash flow forecast — discount rate selection, timing convention, ranking metric consistency, sensitivity coverage, and circularity — as set out on the Investment Analysis and Capital Budgeting pillar. It assumes the underlying cash flow forecast has already been reviewed for general structural soundness; it does not replace a full financial model audit.
Applicability¶
Applicable to any NPV, IRR, or MIRR-based capital budgeting analysis prepared to support an accept/reject decision or a ranking between competing projects, regardless of sector — corporate capital allocation, project finance, real estate, or private equity investment appraisal.
Checklist¶
| # | Check Item | Why It Matters | Evidence to Collect |
|---|---|---|---|
| 1 | Discount rate matches the cash flow basis being discounted | Discounting the wrong cash flow basis (e.g., unlevered flows at a levered rate) produces a result that is neither a valid enterprise nor equity/project value | Confirmation of cash flow basis alongside the discount rate applied |
| 2 | Discount rate (or hurdle rate) is traceable to its component build, not presented as an unsupported single figure | An unsupported rate cannot be independently assessed, sensitized, or replicated | Discount rate build-up documentation |
| 3 | Timing convention is applied consistently (e.g., NPV vs. XNPV, initial investment placed at time zero rather than inside a discounted range) | A one-period timing error is one of the most common and hardest-to-spot NPV errors | Formula inspection of the NPV/XNPV construction |
| 4 | Cash flow series is complete and matches the underlying forecast with no omitted or double-counted items | An incomplete series produces a metric that looks legitimate but does not represent the actual investment | Reconciliation of the cash flow series to the source forecast |
| 5 | NPV ranking and IRR (or MIRR) ranking have been cross-checked for mutually exclusive projects | The two metrics can rank projects differently; an unexplained conflict presented without disclosure misleads the decision-maker | Side-by-side ranking table across all metrics calculated |
| 6 | Where IRR and NPV rankings conflict, the reason for the conflict is identified and NPV is used as the governing criterion for the final recommendation | Resolves the conflict on a documented, defensible basis rather than an implicit or unexplained choice | Written rationale accompanying the recommendation |
| 7 | Sensitivity analysis has been run on the discount rate and the key cash flow drivers | A single-point result presents a false sense of precision; sensitivity shows how the conclusion responds to reasonable assumption uncertainty | Sensitivity table(s) covering discount rate and material drivers |
| 8 | Where relevant, scenario analysis or Monte Carlo simulation has been applied for higher-stakes or more complex decisions | Sensitivity alone does not test coherent combined assumption changes or attach a probability to an outcome | Scenario summary or Monte Carlo output distribution, where applicable |
| 9 | No undocumented circularity exists between the discount rate (or hurdle rate) and the cash flows it is used to discount | An unresolved circularity between a rate and the returns it is meant to evaluate can produce an unstable or self-fulfilling calculation | Formula trace confirming the discount rate's inputs are independent of the project's own calculated returns, or documentation of how any intentional circularity is controlled |
| 10 | Payback period (simple or discounted) and, where capital is rationed, the profitability index have been presented alongside NPV/IRR rather than in isolation | A capital budgeting recommendation based on a single metric omits complementary information on liquidity risk or capital efficiency | Summary table presenting all calculated metrics together |
Common Failures¶
- A discount rate presented as a single figure in the investment memorandum with no visible build-up, making it impossible for a reviewer to confirm it matches the cash flow basis being discounted.
- An IRR-based ranking presented to an investment committee without a corresponding NPV ranking, silently masking a scale-driven conflict between the two.
- Sensitivity analysis run only on revenue growth, omitting the discount rate itself, despite the discount rate's compounding effect across every period of the forecast.
- A hurdle rate quietly derived by reference to the project's own preliminary IRR, creating an undocumented circularity between the acceptance threshold and the metric being tested against it.
Recommended Evidence¶
A completed pass against this checklist should be accompanied by a short review memo recording the discount rate basis and build-up, the full set of metrics calculated (NPV, IRR, MIRR, payback, PI as applicable), the sensitivity and, where used, scenario or Monte Carlo coverage, and a note on any NPV/IRR ranking conflict identified and how it was resolved.
How to Use This Checklist¶
Apply this checklist after the underlying cash flow forecast has been structurally reviewed and before the capital budgeting analysis is finalized for presentation to its decision-making audience. Where the analysis feeds into a broader DCF or investment analysis model build, this checklist complements, rather than replaces, the Financial Modelling Best Practices for Investment Analysis construction discipline and, for a full structural audit of the underlying model, the Financial Model Audit Checklist.
Continue Reading¶
Related Pillars¶
Related Glossary¶
- NPV (Net Present Value)
- IRR (Internal Rate of Return)
- MIRR (Modified Internal Rate of Return)
- Discount Rate
Related Checklists¶
Related Products¶
- Financial Model Audit Engine (FMAE) — deterministic structural auditing, complementary to this decision-layer checklist
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is the Capital Budgeting Decision Checklist for?
A pre-decision review of a capital budgeting or investment appraisal analysis, applied before it is presented to an investment committee, lender, or other decision-making audience, covering discount rate basis, timing convention, NPV/IRR/MIRR ranking consistency, sensitivity coverage, and circularity checks.
How is this different from a general financial model audit checklist?
A general model audit checklist addresses the full structural integrity of a financial model. This checklist is scoped specifically to the capital budgeting decision layer — the discount rate, timing convention, and ranking metrics used to reach an accept/reject or ranking conclusion — and assumes the underlying cash flow forecast itself has already been reviewed for general structural soundness.
Why does the discount rate basis matter so much in this checklist?
Because a mismatch between the discount rate and the cash flow basis being discounted (for example, discounting an unlevered cash flow at a levered cost of equity) produces a result that looks plausible but is neither a correct enterprise nor equity/project value, described further on the Discount Rate glossary page.
Why check NPV against IRR or MIRR rankings specifically?
Because the two metrics can rank mutually exclusive projects differently, particularly when projects differ in scale, timing, or cash flow pattern. A cross-check surfaces any such conflict before it reaches a decision-maker unexplained, rather than presenting a single metric's ranking as if it were unambiguous.
What circularity issue does this checklist address?
Whether the discount rate itself depends, directly or indirectly, on the cash flows it is being used to discount — for example, a hurdle rate that is set by reference to a project's own preliminary return. An undocumented circularity of this kind can produce an unstable or self-fulfilling calculation.
Related Articles
Investment Analysis and Capital Budgeting
Investment analysis and capital budgeting is the discipline of deciding whether a project or investment is expected to create value, using a toolkit of quantitative techniques — net present value, internal rate of return, modified internal rate of return, payback period, and the profitability index — each applied to the same underlying forecast cash flow series but answering a subtly different question. This page is the hub for the Knowledge Centre's investment analysis content: what each technique measures, how the techniques relate to and sometimes conflict with one another, how discount rates and hurdle rates are set, how risk is layered onto the analysis through sensitivity, scenario, and Monte Carlo methods, and — distinctively — how capital-budgeting failure modes map onto FMAE's existing structural audit rule taxonomy.
NPV (Net Present Value)
Net Present Value (NPV) is the sum of a series of future cash flows, each discounted back to the present at a chosen discount rate, minus any initial investment. It is one of the two most commonly used discounted cash flow metrics in financial modelling, alongside IRR, and one of the more frequently misapplied Excel functions, due to a timing convention that is easy to get wrong.
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.
Discount Rate
The discount rate is the rate used to convert a future cash flow into its equivalent value today, reflecting both the time value of money and the risk associated with actually receiving that cash flow. In a discounted cash flow valuation, the discount rate is not a single, universal figure — it must match the cash flow being discounted. Unlevered free cash flow (FCFF), which is available to all capital providers, is discounted at the weighted average cost of capital (WACC), producing enterprise value. Levered free cash flow (FCFE), which is available only to equity holders after debt service, is discounted at the cost of equity, producing equity value directly. Selecting the wrong discount rate for a given cash flow is one of the most consequential and common errors in DCF valuation, since a mismatch corrupts both the theoretical basis and the resulting figure.