Syntha Lab RU

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.

Investment and store openings For whom: Owners and finance directors deciding whether to invest in a store, collection, equipment or a new channel.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Discount rate% per period18This 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

StepFormula
NPVΣ flow(t) ÷ (1 + rate)^t
IRRThe rate at which NPV = 0 (iterative)
PaybackThe period when the cumulative flow turns positive, interpolated within the period
PIDiscounted 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.
Cumulative flow: simple and discounted
Line chart: Simple: −12m → 10.1m; Discounted: −12m → 1.13m−15m−10m−5m05m10m15mYear 0 (investment)Year 3Year 5Simple, Year 0 (investment): −12mSimple, Year 1: −9.5mSimple, Year 2: −5.3mSimple, Year 3: −300kSimple, Year 4: 4.9mSimple, Year 5: 10.1mDiscounted, Year 0 (investment): −12mDiscounted, Year 1: −9.88mDiscounted, Year 2: −6.86mDiscounted, Year 3: −3.82mDiscounted, Year 4: −1.14mDiscounted, Year 5: 1.13m₽Period
  • Simple
  • Discounted
Data as a table
PeriodSimpleDiscounted
Year 0 (investment)−12m−12m
Year 1−9.5m−9.88m
Year 2−5.3m−6.86m
Year 3−300k−3.82m
Year 44.9m−1.14m
Year 510.1m1.13m
NPV profile by discount rate
Line chart: NPV: 10.1m → −3.93m−5m05m10m15m010203040your rateIRRNPV, 0: 10.1mNPV, 5: 6.86mNPV, 10: 4.28mNPV, 15: 2.2mNPV, 20: 491kNPV, 25: −918kNPV, 30: −2.09mNPV, 35: −3.09mNPV, 40: −3.93m₽Discount rate, % a year
Data as a table
Discount rate, % a yearNPV
010.1m
56.86m
104.28m
152.2m
20491k
25−918k
30−2.09m
35−3.09m
40−3.93m

Discounting the flows

PeriodFlowFactorPresent valueCumulative
Year 0 (investment)−12 m ₽1−12 m ₽−12 m ₽
Year 12.5 m ₽0.8472.12 m ₽−9.88 m ₽
Year 24.2 m ₽0.7183.02 m ₽−6.86 m ₽
Year 35 m ₽0.6093.04 m ₽−3.82 m ₽
Year 45.2 m ₽0.5162.68 m ₽−1.14 m ₽
Year 55.2 m ₽0.4372.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.

Terms used

Calculate on your data →