Investment project: NPV, IRR and payback
Appraises a project from its cash flows: opening a store, launching a collection, buying equipment. Calculates net present value, internal rate of return and payback.
At a glance
- What question does it answer?
- Whether the project pays back with the time value of money and what its return is.
- What data is needed?
- The investment in period zero (a negative number).
- How to read the result?
- An NPV above zero and an IRR above the rate mean the project earns more than required. Compare the plain and discounted payback: the gap grows with the length of the project. A profitability index above 1 confirms the gain. Example on the default values: investment RUB 12m, then flows of 2.5, 4.2, 5.0, 5.2 and 5.2m at a rate of 18% (capital plus a risk premium): NPV RUB 1.13m, IRR 21.6%, profitability index 1.09. The plain payback is 3.06 periods and the discounted one 4.5: the gap shows the price of time.
Why and how to reason
A rouble today is worth more than a rouble in a year: it can be invested, and waiting is a risk. So future receipts are brought to today’s money by dividing by (1 + rate) to the power of the number of years. The sum of discounted flows with the investment is the NPV: positive means the project earns more than the rate demands.
IRR is the rate at which NPV equals zero: the project’s own return. Payback shows when accumulated flows cover the investment, and discounted payback does the same with discounted flows.
Example. Investment RUB 12 m, flows 2.5; 4.2; 5.0; 5.2; 5.2 m, rate 18%. Discounted: 2.12; 3.02; 3.04; 2.68; 2.27, total RUB 13.13 m. NPV = 13.13 - 12 = +RUB 1.13 m. IRR about 21.6%, above 18%. Simple payback 3.06 years, discounted 4.5 years. PI = 13.13 / 12, about 1.09.
When to use it
Reach for it for investment decisions: a new store, equipment, a channel launch. Suitable when flows can be estimated for several years. Assumptions: flows are estimated realistically and the rate reflects your risk and the cost of money. The longer the horizon, the less reliable the estimates. Compare projects of different size by NPV, not by IRR alone: IRR can mislead with unusual flows.
How to read the result
A positive NPV (RUB 1.13 m) says the project is worth doing under these assumptions, but the cushion is small: PI 1.09. Check sensitivity: what if flows are 15% lower or the rate higher? If payback is longer than the lease or contract term, that is a bad sign. Watch the gap between simple and discounted payback. Decision: accept the project if NPV is positive in a pessimistic scenario; reject or rework if not. Show the result at two rates, for example 18 and 25%, to see the risk cushion. Also check the contract term.
Common mistakes
Typical trap: computing flows without taxes; putting the investment in year 1 rather than year 0; taking too low a rate; forgetting working capital and refurbishment. Also: confusing profit with cash flow. Also: taking flows without allowing for real-life drops in sales and cost inflation.
What data is needed?
- The investment in period zero (a negative number).
- Net cash flows for each following period after costs and taxes.
- The discount rate: cost of capital plus the project’s risk premium (a riskier project gets a higher rate than a safe one).
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Discount rate | % per period | 18 | This is the cost of capital plus a risk premium for this particular project, not just a loan rate. For example, capital at 18% plus a 4-point risk premium gives 22%; 18% here has no premium, replace it with yours. The rate period must match the flow period (annual with annual). |
How it is calculated
| Step | Formula |
|---|---|
| NPV | Σ flow(t) ÷ (1 + rate)^t |
| IRR | The rate at which NPV = 0 (iterative) |
| Payback | The period when the cumulative flow turns positive, interpolated within the period |
| PI | Discounted inflows ÷ discounted investment |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Net present value (NPV)
- 1.13 m ₽The sum of flows brought to today. Above zero the project earns more than the required rate.
- Internal rate of return (IRR)
- 21.6 %The rate at which NPV is zero. Compare it with the discount rate.
- Payback
- 3.1 periodsWhen cumulative flows cover the investment, undiscounted.
- Discounted payback
- 4.5 periodsThe same with the rate applied: fairer for long projects.
- Profitability index (PI)
- 1.09×Discounted inflows ÷ discounted investment. Above 1 the project pays back.
- Simple
- Discounted
Data as a table
| Period | Simple | Discounted |
|---|---|---|
| Year 0 (investment) | −12m | −12m |
| Year 1 | −9.5m | −9.88m |
| Year 2 | −5.3m | −6.86m |
| Year 3 | −300k | −3.82m |
| Year 4 | 4.9m | −1.14m |
| Year 5 | 10.1m | 1.13m |
Data as a table
| Discount rate, % a year | NPV |
|---|---|
| 0 | 10.1m |
| 5 | 6.86m |
| 10 | 4.28m |
| 15 | 2.2m |
| 20 | 491k |
| 25 | −918k |
| 30 | −2.09m |
| 35 | −3.09m |
| 40 | −3.93m |
Discounting the flows
| Period | Flow | Factor | Present value | Cumulative |
|---|---|---|---|---|
| Year 0 (investment) | −12 m ₽ | 1 | −12 m ₽ | −12 m ₽ |
| Year 1 | 2.5 m ₽ | 0.847 | 2.12 m ₽ | −9.88 m ₽ |
| Year 2 | 4.2 m ₽ | 0.718 | 3.02 m ₽ | −6.86 m ₽ |
| Year 3 | 5 m ₽ | 0.609 | 3.04 m ₽ | −3.82 m ₽ |
| Year 4 | 5.2 m ₽ | 0.516 | 2.68 m ₽ | −1.14 m ₽ |
| Year 5 | 5.2 m ₽ | 0.437 | 2.27 m ₽ | 1.13 m ₽ |
At a 18 % rate the project creates 1.13 m ₽ of value, a return of 22 %. Test robustness: cut the flows by 20–30% and see whether NPV stays positive.
Nuances and limits
- Flows depend heavily on the sales forecast: test the result on flows cut by 20–30%.
- Include working capital and taxes in the flows yourself: the tool does not add them.