Quick Answer: The NPV formula is NPV = Σ [CFt / (1 + r)t] − C0, where CFt is each year’s cash flow, r is the discount rate, t is the year, and C0 is the initial investment. The term (1 + r)t is the discount factor that shrinks future rupees to today’s value. This article explains each part with Indian rupee examples.
Key takeaways:
- (1 + r)t is the discount factor; larger t means heavier discounting.
- CFt is the net cash flow in year t, ideally after tax.
- r is the discount rate reflecting cost of capital or the RBI repo rate.
- C0, the initial investment, is subtracted and not discounted.
- Summing discounted cash flows minus C0 gives the NPV.
The NPV formula can look intimidating with its summation sign and exponents, but each piece has a clear, intuitive job. Once you understand what the discount factor does and why distant cash flows count for less, the formula becomes a simple, powerful way to judge any investment. This explainer breaks the formula down term by term and shows it working on rupee examples relevant to Indian investors and businesses.
The Formula, Term by Term
Here is the formula again:
NPV = Σ [ CFt / (1 + r)t ] − C0
- CFt — the net cash flow you expect in year t, such as profit or rent received.
- r — the discount rate, written as a decimal (10% = 0.10), reflecting your required return.
- t — the year number, from 1 for the first future year onwards.
- (1 + r)t — the discount factor that converts a future rupee into today’s rupee.
- C0 — the money invested at the start, subtracted because it is already in today’s value.
The Σ (sigma) simply means “add up” the discounted cash flows for every year. An NPV calculator automates this sum, but knowing the pieces lets you trust and interrogate its output.
Understanding the Discount Factor
The heart of the formula is (1 + r)t. Because it sits in the denominator, a bigger value makes the cash flow worth less today. As t grows, the factor grows too, so cash flows further in the future are discounted more heavily. At r = 10%, one rupee in year 1 is worth 1/1.10 = 0.909 today, but in year 5 it is worth only 1/1.61 = 0.621. This is the mathematical expression of the idea that money you receive sooner is more valuable.
Expert insight: The discount factor is where risk and interest rates enter the formula. A higher discount rate punishes distant cash flows harder, which is exactly why risky Indian ventures use higher rates and value long-dated returns conservatively.
Worked Example: Discount Factors in Action
Consider a project returning ₹2,00,000 each year for three years at a 12% discount rate.
| Year (t) | Cash flow | Discount factor 1/(1.12)t | Present value |
|---|---|---|---|
| 1 | ₹2,00,000 | 0.8929 | ₹1,78,571 |
| 2 | ₹2,00,000 | 0.7972 | ₹1,59,439 |
| 3 | ₹2,00,000 | 0.7118 | ₹1,42,356 |
The present values sum to ₹4,80,366. If the initial investment C0 was ₹4,50,000, then NPV = 4,80,366 − 4,50,000 = ₹30,366, a positive result meaning the project clears the 12% hurdle.
Why the Initial Investment Is Not Discounted
A common confusion is whether to discount C0. The answer is no. The initial investment happens today, at year 0, so it is already in present-value terms — there is no future to discount it from. You simply subtract it from the sum of the discounted future cash flows. If a project has staged investments in later years, those later outflows are discounted like any other cash flow, entering the formula as negative CF values.
Choosing r for Indian Decisions
The discount rate is the formula’s most judgement-heavy input. Indian companies typically use their weighted average cost of capital, blending the cost of equity and the after-tax cost of debt. Individuals often use the return they could earn elsewhere, such as a fixed deposit or a debt mutual fund. As a neutral reference point, the RBI repo rate — 5.25% in August 2026 — represents a near risk-free rate, to which a premium is added for the project’s risk.
Benefits of Understanding the Formula
Grasping the formula rather than just plugging numbers into a tool gives you real control. You can see immediately why a project fails, adjust the discount rate to test different scenarios, and explain the result to partners or a bank. It also demystifies related measures: IRR is simply the discount rate that makes this very formula equal zero. For students of CA, CFA, and MBA programmes in India, deep familiarity with each term is essential exam knowledge and practical skill alike.
Challenges and Limitations
The formula assumes you can forecast future cash flows and pick a correct discount rate, both of which are uncertain in practice. It is highly sensitive to r: a two-point change in the rate can turn a positive NPV negative, which makes the choice of discount rate consequential. The formula also assumes cash flows arrive at neat year-end points, whereas real Indian businesses receive money throughout the year. These simplifications are usually acceptable but should be remembered when the decision is close.
Common Mistakes to Avoid
- Discounting the initial investment. C0 is at year 0 and must not be divided by any discount factor.
- Writing the rate as a whole number. Use 0.10 for 10%, not 10, inside the formula.
- Getting the year exponent wrong. Year 3’s factor is (1 + r)3, not (1 + r) × 3.
- Using pre-tax cash flows. Indian tax reduces inflows, so use after-tax figures.
- Ignoring later outflows. Future investments are negative cash flows and must be discounted too.
- Rounding discount factors too early. Keep four decimals until the final sum to stay accurate.
Best Practices and Expert Recommendations
- Lay out a cash-flow table. List year, cash flow, discount factor, and present value in columns.
- Convert the rate to a decimal first. This avoids the most common formula error.
- Keep four-decimal discount factors. Round only the final NPV.
- Test two or three discount rates. Sensitivity analysis shows how fragile the decision is.
- Use after-tax, realistic cash flows. Conservative, tax-adjusted inputs give trustworthy results.
- Cross-check with a calculator. Confirm your manual formula work with a reliable tool.
Since the cash flows in the formula are often after-tax profits net of asset write-downs, pairing your NPV work with a depreciation calculator helps you compute those figures correctly.
How Sensitivity Analysis Strengthens an NPV Decision
Because the NPV formula is so sensitive to its inputs, professionals rarely rely on a single calculation. Instead they run what is called a sensitivity analysis, recomputing the NPV under a range of assumptions to see how robust the decision really is. The idea is simple: change one input at a time and watch how far the NPV moves, which reveals which assumptions truly drive the outcome.
Take the discount rate first. Recalculating the NPV at a rate two percentage points above and below your base case shows whether a shift in the interest-rate cycle, which the Reserve Bank of India adjusts periodically, would flip your decision from accept to reject. If the project stays positive across that range, you can be far more confident. If a small change tips it into negative territory, the decision is fragile and deserves more caution.
The same treatment applies to the cash-flow estimates. Try a conservative case where revenues come in ten or twenty per cent lower than hoped, and a slightly delayed case where the benefits start a year later than planned. In Indian business conditions, where demand and input costs can be volatile, these stress tests are not pessimism but prudence. A project that survives conservative assumptions is one you can pursue with genuine conviction, while one that only works under best-case numbers should give you pause before committing capital.
Frequently Asked Questions
What is the discount factor in the NPV formula?
It is the term (1 + r)t in the denominator, which converts a future cash flow into today’s value. Because it grows with the year t, cash flows further in the future are discounted more heavily and are worth less now.
Do I write the discount rate as a percentage or decimal?
Always as a decimal inside the formula. A 10% rate becomes 0.10, so the discount factor for year 1 is (1 + 0.10)1 = 1.10. Using the whole number 10 would give a nonsensical result.
Is the initial investment discounted?
No. The initial investment C0 occurs at year 0, today, so it is already in present-value terms. You subtract it directly from the sum of the discounted future cash flows.
How is IRR related to the NPV formula?
The Internal Rate of Return is the discount rate r that makes the NPV formula equal exactly zero. It represents the project’s own rate of return, and comparing it with your required rate helps confirm the NPV decision.
