Net present value (NPV) is the difference between the present value of future cash inflows and the present value of cash outflows over an investment's lifetime. A positive NPV indicates the investment creates value above the required rate of return. NPV is considered the gold-standard metric for capital budgeting decisions in FP&A.
Formula
NPV = -Initial Investment + Sum [CF_t / (1+r)^t]In Depth
NPV applies the time value of money principle to investment evaluation. A pound today is worth more than a pound tomorrow because it can be invested and earn a return. NPV discounts all future cash flows back to present values using the cost of capital, then nets them against the initial investment.
The formula is: NPV = -Initial Investment + Sum of [Cash Flow_t / (1 + r)^t], where r is the discount rate and t is the time period. A positive NPV means the investment earns more than the required rate of return and creates shareholder value.
NPV is preferred over IRR by finance academics because it directly measures value creation in pound terms. There is no ambiguity about reinvestment assumptions, and it works correctly even for non-conventional cash flow patterns where IRR may give multiple solutions.
For FP&A teams, NPV analysis is essential for evaluating capital projects, M&A opportunities, lease-vs-buy decisions, and strategic investments. The key inputs are the projected cash flows (which come from the financial model) and the discount rate (typically the weighted average cost of capital, or WACC).
Sensitivity analysis around NPV is highly valuable. Testing how NPV changes with different discount rates, revenue assumptions, or cost scenarios helps management understand the range of outcomes and the robustness of the investment case.
For UK businesses, NPV calculations should use after-tax cash flows in GBP, apply an appropriate UK-relevant discount rate, and consider specific tax benefits like capital allowances, R&D credits, and regional incentives.
Real-World Example
A UK technology firm evaluates a £1M product development investment expected to generate £350K annually for 5 years. Using a 12% discount rate (the company's WACC), the present value of cash inflows is £1.26M. NPV = £1.26M - £1M = £262K. The positive NPV confirms the project creates value. Sensitivity analysis shows NPV turns negative if annual returns fall below £280K or if the discount rate exceeds 22%.
Related Terms
Free cash flow (FCF) is the cash generated by a business after accounting for operating expenses and...
Return on investment (ROI) measures the gain or loss generated by an investment relative to its cost...
The internal rate of return (IRR) is the discount rate at which the net present value (NPV) of all c...
Weighted average cost of capital (WACC) represents the average rate a company must pay to finance it...
A DCF (Discounted Cash Flow) model values a company or project by projecting future free cash flows ...
Stop wrestling with spreadsheets. Grove FP gives your finance team a purpose-built platform for budgeting, forecasting, and financial modelling — designed for UK businesses.
FAQ