Cash Flow Frog logo

Net Present Value (NPV)

Table of Contents
1. What Is Net Present Value (NPV)?2. How It's Calculated3. Worked Example4. Why It Matters in Practice5. How Net Present Value Affects Your Cash Flow6. How You'd See This in Cash Flow Frog7. Related Terms

What Is Net Present Value (NPV)?

Net present value is the difference between the present value of future cash inflows an investment generates and the present value of the cash it costs. A positive NPV means the investment returns more in today's money than it costs. A negative NPV means the opposite, the returns do not justify the outlay.

How It's Calculated

NPV = Σ [Cash Flow in Period t / (1 + r)^t] − Initial Investment

Where:

  • Cash Flow in Period t is the expected net cash inflow in each future period

r is the discount rate, the minimum acceptable rate of return, often the business's cost of capital or a required hurdle rate

t is the time period (Year 1, Year 2, and so on)

Initial Investment is the upfront cash cost, typically at Period 0

The discount rate is the critical input. It reflects the time value of money, cash received in the future is worth less than cash received today, because cash held today can be reinvested to generate additional returns. The higher the discount rate, the more future cash flows are discounted, and the harder it is for an investment to produce a positive NPV.

The discount factor for each period:

Discount Factor = 1 / (1 + r)^t

Multiplying each period's expected cash flow by its discount factor gives the present value of that cash flow. Summing those present values and subtracting the initial investment produces the NPV.

Worked Example

A manufacturing business is evaluating a piece of equipment costing $120,000 upfront. The equipment is expected to generate net cash inflows over five years. The business uses a discount rate of 10% to reflect its cost of capital.

Year Expected Cash Flow (USD) Discount Factor (10%) Present Value (USD)
1 $35,000 0.909 $31,818
2 $40,000 0.826 $33,058
3 $38,000 0.751 $28,550
4 $32,000 0.683 $21,857
5 $28,000 0.621 $17,386
Total PV of Inflows $132,669

NPV: $132,669 − $120,000 = +$12,669

The NPV is positive. The investment returns $12,669 more than it costs, measured in today's money. At a 10% required return, this equipment purchase is worth making.

Now suppose the discount rate is raised to 14% to reflect a higher minimum return threshold:

Year Expected Cash Flow (USD) Discount Factor (14%) Present Value (USD)
1 $35,000 0.877 $30,702
2 $40,000 0.769 $30,779
3 $38,000 0.675 $25,650
4 $32,000 0.592 $18,946
5 $28,000 0.519 $14,541
Total PV of Inflows $120,618

NPV: $120,618 − $120,000 = +$618

Still positive, but barely. At 14%, the same cash flows produce almost no surplus value over the investment cost. A small downside in Year 1 or Year 2 would push the NPV negative. The discount rate assumption is doing a great deal of work in this decision.

Why It Matters in Practice

It puts a value on timing, not just total cash

A simple payback period calculation treats $35,000 received in Year 1 the same as $35,000 received in Year 5. NPV does not. It recognizes that the earlier cash flow is worth more because it can be reinvested sooner. Two investments returning the same total undiscounted cash can have very different NPVs if the timing of those returns differs, the one that front-loads cash flows will show a higher NPV at any positive discount rate. This makes NPV a more honest measure of an investment's value than a simple sum of projected returns.

It creates a consistent basis for comparing investments

When a business has limited capital and multiple investment options, buy a second vehicle, take on new warehouse space, upgrade production equipment, NPV allows comparison on the same basis. Each option generates a different profile of future cash flows at a different upfront cost. Calculating NPV for each at the same discount rate produces a ranking: the investment returning the highest NPV creates the most value per dollar committed. That is a more rigorous basis for capital allocation than gut feel or payback period alone.

It forces explicit assumptions about future cash flows

Building an NPV analysis requires projecting cash flows year by year, not revenue, but actual net cash: when will the investment generate inflows, how large will they be, and what costs will it incur? That discipline is valuable independent of the NPV result. A business that sits down to model the cash flows of a proposed investment will often surface assumptions that had not been made explicit, a Year 3 maintenance cost, a revenue assumption that depends on a contract not yet signed, a residual value that was assumed but not verified. The NPV number is an output; the rigour of the cash flow projection is the real output.

How Net Present Value Affects Your Cash Flow

NPV values a decision on its future cash, discounted to today. A positive NPV means the cash it returns beats the cash it costs.

That framing is the practical test for any capital investment. The upfront cost is certain, cash leaves the business when the asset is purchased or the investment is made. The future inflows are projected, they depend on assumptions about revenue, costs, and timing that will not always hold exactly. NPV makes the required gap between those two explicit: the projected inflows must exceed the initial outflow by enough, when discounted, to justify the investment at the minimum acceptable rate. If they do not, the business would do better deploying the same cash elsewhere.

The link to the cash flow forecast is direct. The cash flows that go into an NPV calculation are the same cash flows the business needs to model in its forecast: when does the investment generate inflows, what are the operating costs associated with it, and when does any terminal or residual cash occur? A business that maintains a rolling cash flow forecast can model an NPV scenario directly against its actual projected position, seeing not just whether the NPV is positive but whether the upfront outflow in the quarter of purchase creates a cash gap the business can absorb, and whether the projected inflows arrive on a schedule that supports the surrounding cash position.

How You'd See This in Cash Flow Frog

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, Sage Intacct, Odoo, Zoho Books, and FreshBooks and builds a rolling cash flow forecast automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

The NPV calculation is a decision-support tool; the cash flow forecast is where the consequences of that decision play out in real time. Once an investment is made and recorded in the accounting system, the upfront outflow appears in the forecast as an investing activity. The associated inflows, additional revenue the investment generates, appear as operating inflows as they are invoiced and collected. The forecast runs up to three years out, which is sufficient to track the early years of a capital investment against the projections used in the NPV analysis. For businesses making investment decisions across multiple entities or currencies, the forecast consolidates natively. The methodology behind discounting future cash flows to a present value, the mathematical foundation of NPV, is covered in the related entry at cashflowfrog.com/glossary/discounted-cash-flow/.

Back to Glossary Page

FAQ

The discount rate should reflect the minimum return the business requires on its capital, sometimes called the hurdle rate. For a small business, this is often set at the cost of borrowing (since the alternative to investing is paying down debt), the owner's expected return on capital, or some combination of both. A higher discount rate makes positive NPV harder to achieve and favors investments with front-loaded cash returns. There is no universally correct discount rate, but the choice should be consistent across investment comparisons and reflect the actual cost of capital or opportunity cost of the funds being deployed.

Payback period calculates how long it takes to recover the initial investment from cumulative cash inflows, it ignores what happens after the payback point and gives no weight to the time value of money. NPV discounts all future cash flows to present value, accounts for the full life of the investment, and produces a single number representing the surplus value created. Payback period is simple to calculate and useful for assessing liquidity risk, how quickly does the business get its cash back. NPV is more rigorous for assessing whether the investment creates value. The two answer different questions and are best used together rather than as alternatives.

The Internal Rate of Return (IRR) is the discount rate at which NPV equals zero, the rate of return the investment produces. If the IRR exceeds the business's required return, the investment is worth making; if not, it is not. NPV and IRR usually lead to the same accept or reject decision for a single investment, but they can conflict when comparing mutually exclusive investments of different sizes or with different cash flow timing. NPV is generally considered the more reliable criterion for ranking investments because it measures absolute value created in today's dollars, rather than a rate that can be misleading for investments with unusual cash flow profiles.

Yes, with adjustment. Some investments generate value through cost savings rather than revenue, replacing an inefficient process with a cheaper one, for example. The cash flows in this case are the cost savings generated each year, net of the operating costs of the new process. Those savings are treated as positive cash inflows for NPV purposes, discounted in the same way as revenue-generating inflows. An investment that saves $30,000 per year in operating costs can be evaluated against its upfront cost using the same NPV framework, with the savings as the projected cash flow stream.

Highly sensitive, particularly to the discount rate and to cash flows in early periods. A small change in the discount rate can flip a positive NPV to negative for long-horizon investments, because the compounding effect of discounting becomes more powerful over time. Similarly, if the Year 1 or Year 2 projected cash flows are overstated, the investment takes longer to generate returns than expected, the NPV will be lower than calculated, potentially negative. Sensitivity analysis, recalculating NPV under different discount rates and cash flow assumptions, gives a better picture of the investment's risk profile than a single-scenario NPV number.

It means they create the same amount of value in present-value terms. However, the two investments may have very different upfront costs, different cash flow profiles, and different levels of risk in the underlying assumptions. A business choosing between them should also consider the scale of capital required, the risk attached to the cash flow projections, and the strategic fit of each investment. NPV alone does not distinguish between an investment requiring $50,000 upfront and one requiring $500,000 if both return the same NPV, but the resource commitment and risk profile are clearly different.

Looking for more help?

Visit our help center to find answers to your questions about CashFlowFrog.

Help Centre

Trusted by thousands of business owners

Start Free Trial Now