Skip to main content
SBI SecuritiesAn SBI Group Company

NPV Calculator

Calculate Net Present Value and IRR for investment decisions.

Investment Details

₹10.0L
₹1.0L₹500.0L
12%
1%30%
₹2.0L
₹2.5L
₹3.0L
₹3.5L
₹4.0L

NPV Formula:

NPV = Σ (CFₜ / (1 + r)ᵗ) - Initial Investment

Where: CF = Cash Flow, r = Discount Rate, t = Time Period

Investment Analysis

Net Present Value

+0.41 L

Investment is Viable

Internal Rate of Return

13.45%

Above hurdle rate

Profitability Index1.04x
Payback Period3.7 years
Discounted Payback4.8 years
Total Return50.0%

Discounted Cash Flow Analysis

YearCash FlowDiscount FactorPresent ValueCumulative PV
0-₹10,00,0001.000-₹10,00,000-₹10,00,000
1+₹2,00,0000.8931,78,571-8,21,429
2+₹2,50,0000.7971,99,298-6,22,131
3+₹3,00,0000.7122,13,534-4,08,597
4+₹3,50,0000.6362,22,431-1,86,166
5+₹4,00,0000.5672,26,971+40,805

Decision Criteria

NPV > 0

Accept the project

IRR > Hurdle Rate

Project adds value

PI > 1

Profitable investment

Shorter Payback

Lower risk