Net Present Value Calculator

Calculate the net present value of an investment or project by entering your initial outlay, expected cash flows, and discount rate below.

Year 1:

Net Present Value

R 0.00

What Is Net Present Value?

Net present value (NPV) measures whether an investment or project is worth undertaking by comparing the value of money you’ll receive in the future against the value of money you’re spending today.

Because a Rand received in five years is worth less than a Rand in hand today, due to inflation and the returns you could otherwise earn elsewhere, NPV discounts each future cash flow back to today’s terms before adding them up. If the total is positive, the investment is expected to add value. If it’s negative, the investment is expected to destroy value at your chosen discount rate.

NPV is widely used in South African business and investment decisions, from evaluating whether to expand a business, purchase equipment, or invest in a new project, since it accounts for both the size and the timing of returns, not just the total amount.

How to Calculate Net Present Value

Step 1: Identify your initial investment, the amount spent upfront to start the project.

Step 2: List your expected cash flows for each future period, typically each year of the project.

Step 3: Choose a discount rate that reflects your cost of capital or required rate of return.

Step 4: Discount each future cash flow back to its present value, then sum them and subtract the initial investment.

Net Present Value Formula

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

Where r is the discount rate and t is the time period in which each cash flow occurs.

Worked Example

Say you’re considering a project that requires an initial investment of R500,000, and is expected to generate cash flows of R150,000, R180,000, R200,000, and R220,000 over the next four years. You’ve chosen a discount rate of 12 percent to reflect your required return.

Discounting each cash flow back to its present value:

  • Year 1: R150,000 ÷ (1.12)¹ = R133,929
  • Year 2: R180,000 ÷ (1.12)² = R143,495
  • Year 3: R200,000 ÷ (1.12)³ = R142,356
  • Year 4: R220,000 ÷ (1.12)⁴ = R139,821

Summing these gives a total present value of R559,601. Subtracting the initial investment:

NPV = R559,601 − R500,000 = R59,601

Since the NPV is positive, this project is expected to add value at a 12 percent discount rate, and would generally be considered worth pursuing on financial grounds alone.

Choosing a Discount Rate in South Africa

The discount rate you use has a significant effect on your NPV result, so it’s worth choosing it carefully. In South Africa, a few common reference points are used as a starting point:

  • Prime lending rate: Currently 10.5 percent, following the SARB repo rate of 7.00 percent, is often used as a baseline for lower-risk projects with borrowing costs similar to standard commercial lending.
  • Weighted average cost of capital (WACC): For businesses with a mix of debt and equity funding, WACC reflects the blended cost of that funding and is generally preferred over prime for company-wide investment decisions.
  • Risk-adjusted rates: Higher-risk projects, such as new ventures or investments in volatile sectors, typically warrant a higher discount rate to compensate for that additional uncertainty.

Because interest rates move over time, it’s worth revisiting your discount rate assumption periodically rather than relying on a figure that was accurate when the project was first evaluated.

Interpreting Your NPV Result

A positive NPV means the project is expected to generate more value than it costs, at your chosen discount rate, and is generally worth pursuing from a purely financial standpoint. A negative NPV means the project is expected to destroy value at that discount rate, even if the total cash inflows look large in nominal terms. An NPV of exactly zero means the project is expected to earn precisely your required rate of return, no more and no less.

When comparing multiple projects, the one with the higher NPV is generally the better choice, assuming similar risk levels and available capital, since NPV expresses value creation in Rand terms rather than as a percentage or ratio.

NPV vs Other Investment Appraisal Methods

NPV is often used alongside other appraisal methods rather than in isolation. Internal rate of return (IRR) expresses a project’s return as a percentage rather than a Rand value, which can be easier to compare across projects of different sizes, though it can produce misleading results for projects with unconventional cash flow patterns.

Payback period simply measures how long it takes to recover the initial investment, ignoring the time value of money entirely, which makes it a useful quick filter but a poor standalone decision tool. NPV remains the most theoretically sound method of the three because it directly measures value added in today’s Rand terms.