Investment Analysis and Capital Budgeting

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.

Payback Period

Payback period is the length of time required for a project's cumulative cash flows to recover the initial investment. It exists in two forms — simple payback, which ignores the time value of money, and discounted payback, which discounts each cash flow before accumulating it. Payback period measures capital-recovery speed and liquidity risk rather than value creation, and its principal weakness — shared by both forms — is that it ignores every cash flow occurring after the payback threshold is reached, regardless of its magnitude.

Profitability Index (PI)

The profitability index (PI) is the present value of a project's future cash flows divided by its initial investment, equivalently expressed as 1 plus NPV divided by the initial investment. Unlike NPV, which is stated in absolute currency terms, the profitability index is a ratio, which makes it particularly useful for ranking competing projects by capital efficiency when a company faces capital rationing and cannot fund every positive-NPV project available to it.

Hurdle Rate

The hurdle rate is the minimum acceptable rate of return a project or investment must clear to be accepted. It is typically set at or above the entity's cost of capital, and is often, but not always, the same figure used as the discount rate in an NPV calculation. Where the two diverge, it is because the hurdle rate has been deliberately set above the base cost of capital to reflect a project-specific risk premium, a capital-constraint buffer, or an internal policy requiring a margin of safety above the theoretical minimum acceptable return.

Risk Analysis in Investment Appraisal

A single-point NPV or IRR calculation, built on one specific set of assumptions, does not on its own convey how a capital budgeting conclusion would change if those assumptions turned out to be wrong. Risk analysis in investment appraisal addresses this by layering a defined set of techniques on top of the base calculation: sensitivity analysis, which tests the effect of changing one input at a time; scenario analysis, which tests coherent alternative sets of assumptions together; and Monte Carlo simulation, which models a full probability distribution of outcomes across many simultaneously varying inputs. This guide sets out what each technique tests, how they complement rather than substitute for one another, and how they apply specifically to a capital budgeting decision.

Monte Carlo Simulation

Monte Carlo simulation is a quantitative technique that builds a distribution of possible outcomes by running a large number of trials, each drawing its inputs from specified probability distributions, rather than relying on a single point estimate or a small set of discrete scenarios. In financial modelling and investment analysis, it is applied wherever a decision depends on several uncertain inputs whose combined effect is difficult to characterize through sensitivity or scenario analysis alone, most prominently in capital budgeting and DCF valuation, where the DCF-specific application of the technique is treated as its own dedicated guide.

NPV vs. IRR

Net present value (NPV) and internal rate of return (IRR) are the two most widely used capital budgeting metrics, calculated from the same underlying cash flow series, and they usually agree on whether a single, standalone project should be accepted. They can disagree, however, on how to rank mutually exclusive projects of different scale or cash flow timing, and IRR carries additional technical limitations — a reinvestment assumption embedded in the rate itself, and the possibility of multiple or no real solutions for a non-conventional cash flow series — that NPV does not share. Institutional practice generally defers to NPV when the two conflict.

MIRR vs. IRR

Internal rate of return (IRR) and modified internal rate of return (MIRR) both express a project's return as a single percentage figure calculated from the same underlying cash flow series, but they differ in a specific and consequential way: IRR implicitly assumes that interim cash flows are reinvested at the IRR itself for the remainder of the project's life, an assumption that is often unrealistic, particularly for projects with a high IRR. MIRR replaces this implicit assumption with two explicit, separately specified rates — a finance rate for outflows and a reinvestment rate for inflows — producing a single, more defensible rate of return and eliminating the possibility of multiple or no real solutions for a non-conventional cash flow series.

Capital Budgeting Decision Checklist

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 covers whether the discount rate matches the cash flow basis and risk being discounted, whether the timing convention is applied consistently, whether NPV and IRR/MIRR rankings have been cross-checked for conflicts, whether sensitivity has been run on the discount rate and key drivers, and whether the model is free of circularity between the discount rate and the cash flows it discounts.

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.

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.

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.

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.

Project IRR

Project IRR (Project Internal Rate of Return) is the internal rate of return calculated on a project's total cash flows before any financing costs — that is, before debt drawdowns, interest payments, principal repayments, and equity contributions. It represents the unlevered return of the underlying project, independent of how it is financed. Project IRR answers the question: what return does the project generate on the capital deployed in it, regardless of whether that capital is debt or equity? This distinguishes it from Equity IRR, which is calculated on cash flows net of all financing — the return received by equity investors after debt has been serviced. The Project IRR formula is the same as the standard IRR formula: Where: - C_t is the total project cash flow in period t (pre-financing) - r is the Project IRR In Excel: XIRR is the correct function for project finance applications where cash flows occur at irregular intervals.

Discounted Cash Flow (DCF) Valuation

Discounted cash flow (DCF) valuation values a business, project, or asset as the present value of the cash flows it is expected to generate in the future. It is the most theoretically grounded of the major valuation methodologies, resting directly on the principle that a dollar of cash flow is worth more today than the same dollar received in the future, and that value is created when future cash flows exceed what capital providers require as compensation for the time value of money and risk. This page is the hub for the Knowledge Centre's DCF content: what DCF is and why it works, how free cash flow and discount rates are built, how terminal value is calculated and stress-tested, the method variants practitioners choose between, and — distinctively — how DCF failure modes map onto FMAE's existing structural audit rule taxonomy, since no generic valuation resource ties DCF mechanics to a named, testable audit standard.

Financial Modelling Best Practices — Standards Compared

Financial modelling best practice is not a single document but a landscape of named institutional standards, each publishing its own conventions for how a model should be structured, formatted, and documented. This page defines that landscape — what a named modelling standard actually is, how the FAST Standard and the ICAEW Financial Modelling Code differ in approach and scope, and how a practitioner chooses between them or applies more than one. It sits beside, not instead of, the Knowledge Centre's structural-foundation page on what makes an Excel financial model reliable — this page is about who has codified that discipline into a named standard, and how those standards compare to one another.

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.

Financial Modelling Best Practices for Investment Analysis

Investment analysis models, built to support a buy, sell, or hold decision on a security or asset rather than to run an operating business, are organised around one or more valuation methods, discounted cash flow, comparable companies, precedent transactions, each with its own distinct construction logic. This page sets out how such a model should be constructed: keeping valuation methods structurally separate rather than blended, building terminal value as an explicit, isolated assumption, and building scenario and sensitivity outputs as first-class results. It addresses the construction question as a discipline applied while the model is built, distinct from the audit-risk perspective covered on Financial Model Auditing.

Financial Statements in Financial Modelling

The income statement, balance sheet, and cash flow statement are the three financial statements that together describe a company's or project's performance, financial position, and cash movements. In a financial model, these are not three independent outputs — they are dynamically linked, so that a single change in an assumption flows correctly through all three, and the balance sheet balances in every period as a direct consequence of that linkage rather than as a plug engineered to force it. This page is the hub for the Knowledge Centre's financial statements content: what each statement represents, how a three-statement model integrates them, where financial-statement mechanics anchor broader industry models, and how a structural audit tests statement integration for the errors that most commonly break it.

Financial Forecasting in Financial Models

Financial forecasting is the process of projecting a business's future financial performance from a defined set of operating drivers and assumptions, structured so that every forecast line traces back to a labelled, auditable input rather than a value typed directly into a calculation. It underpins every model built for valuation, budgeting, financing, or investment decision-making, and it is also one of the areas of a financial model most prone to silent structural failure, since a forecast that looks complete can still rest on drivers that are hardcoded, undocumented, or inconsistently applied from one period to the next. This page is the hub for the Knowledge Centre's forecasting content: what a forecast driver is, the major forecasting methodologies and when each applies, the governance distinction between a budget and a forecast, rolling forecasts, and how forecasting failure modes map onto FMAE's existing structural audit rule taxonomy.

Valuation Methodologies

Valuation methodologies fall into three classical approaches — the income approach, which derives value from an asset's own forecast cash flows; the market approach, which derives value from observed pricing of similar assets, either currently trading (comparable company analysis) or previously transacted (precedent transactions); and the asset-based approach, which derives value from the fair value of a business's underlying assets less its liabilities. A fourth, related technique — leveraged buyout (LBO) valuation — derives an implied value by solving backward from a target return rather than forward from an explicit valuation model. This page is the hub for the Knowledge Centre's coverage of the market approach, the asset-based approach, and LBO-implied valuation. It does not re-explain the income approach (DCF), which has its own dedicated pillar; it frames all four techniques together, explains how and why institutional practice triangulates across them, and maps the audit questions specific to each onto FMAE's existing structural rule taxonomy.

Corporate Finance and Capital Structure

Corporate finance and capital structure is the set of decisions a company makes about how to fund itself — the mix of debt and equity it carries, the blended return it must earn to satisfy both groups of capital providers, and how it returns surplus cash to shareholders once those obligations are met. These decisions are not made once and left alone: capital structure is actively managed against a trade-off between the tax and discipline benefits of debt and the real costs of financial distress, cost of capital sets the hurdle every investment decision is measured against, and dividend policy and share buybacks are the two channels through which excess cash returns to owners. This page is the hub for the Knowledge Centre's corporate finance and capital structure content: the debt-vs-equity financing decision, Modigliani-Miller's capital structure theory and its real-world violations, cost of capital as a capital-allocation hurdle rate, dividend policy and buybacks, the credit metrics lenders and rating agencies use to assess leverage capacity, and covenant analysis as the contractual mechanism through which lenders constrain capital structure after financing is in place.