NPV Calculator India 2026 — Net Present Value & Monthly Payments

Calculate net present value (NPV) for any investment in India — annual cash flows, monthly payments, or unequal cash flows. Get IRR, Profitability Index, payback period, and investment decision instantly.

📈 Net Present Value Calculator India ⏳ NPV Monthly Payments 🏭 IRR Calculator ✅ Accept / Reject Decision 📊 Profitability Index 🔰 Unequal Cash Flows
Net Present Value Calculator India 2026

Calculate NPV & IRR

Enter initial investment, expected annual cash flows, and discount rate. NPV > 0 means the investment creates value.

📈 Investment & Returns
₹5.00 L
₹1,000₹100 Cr
₹1.50 L
₹0₹50 Cr
5%
0% (Flat)30%
10 yrs
1 yr30 yrs
12%
0.5%35%
₹0
₹0₹100 Cr
📈 NPV = −Investment + ∑CF×(1+g)^t/(1+r)^t. Discount rate = your WACC or opportunity cost. NPV > 0: Accept. NPV < 0: Reject.
⏳ Net Present Value — Monthly Payments
₹10.00 L
₹1,000₹100 Cr
₹15,000
₹0₹10 Cr
12%
0.5%35%
10 yrs
1 yr30 yrs
0%
0% (Flat)20%
₹0
₹0₹100 Cr
NPV = −Inv + ∑[Monthly CF / (1 + r/12)^t]. Monthly rate = Annual rate / 12. Use for: rental income, SWP, EMI-funded equipment, subscription business.
📊 Unequal Annual Cash Flows NPV
₹5.00 L
₹1,000₹100 Cr
12%
0.5%35%
📈 Cash Flow per Year (₹) — Up to 10 Years
📊 Enter actual or projected cash flows for each year (can be negative). IRR calculated via bisection method. Matches Excel XIRR/NPV function output.
📈 Net Present Value (NPV)
₹0
loading...
📈 Enter values to get NPV decision
NPV
₹0
net value created
IRR
0%
internal rate
PI
0
profitability index
0% NPV ratio
PV of CF Investment
YEAR-WISE DISCOUNTED CASH FLOWS
🚀 Get NPV Analysis Help on WhatsApp
VR
Vikash Royal ARN-356458
B.E. | MBA Finance | NISM Certified | 7+ Years in Finance

📈 Net Present Value Calculator India — NPV of ₹1L Annual CF at Different Rates & Periods

NPV of an investment that generates ₹1 lakh per year, at different discount rates and project durations. Shows when the investment creates value vs destroys it.

Initial Investment 8% Discount
Annual CF Rs 1L
10% Discount
Annual CF Rs 1L
12% Discount
Annual CF Rs 1L
15% Discount
Annual CF Rs 1L
18% Discount
Annual CF Rs 1L
20% Discount
Annual CF Rs 1L
₹5L over 3 yrs
Rs 1L/yr CF
\u20B9-242,290 \u20B9-251,315 \u20B9-259,817 \u20B9-271,677 \u20B9-282,573 \u20B9-289,352
₹5L over 5 yrs
Rs 1L/yr CF
\u20B9-100,729 \u20B9-120,921 \u20B9-139,522 \u20B9-164,784 \u20B9-187,283 \u20B9-200,939
₹5L over 7 yrs
Rs 1L/yr CF
+\u20B920,637 \u20B9-13,158 \u20B9-43,624 \u20B9-83,958 \u20B9-118,847 \u20B9-139,541
₹5L over 10 yrs
Rs 1L/yr CF
+\u20B9171,008 +\u20B9114,457 +\u20B965,022 +\u20B91,877 \u20B9-50,591 \u20B9-80,753
₹5L over 15 yrs
Rs 1L/yr CF
+\u20B9355,948 +\u20B9260,608 +\u20B9181,086 +\u20B984,737 +\u20B99,158 \u20B9-32,453
₹5L over 20 yrs
Rs 1L/yr CF
+\u20B9481,815 +\u20B9351,356 +\u20B9246,944 +\u20B9125,933 +\u20B935,275 \u20B9-13,042

NPV = Sum of [Rs 1,00,000/(1+r)^t] for t=1 to period, minus Rs 5,00,000 initial investment. Green = NPV positive (investment creates value above the discount rate). Red = NPV negative (investment destroys value — rejects at this discount rate). Key insight: A Rs 5L investment returning Rs 1L/year for 10 years has NPV of +Rs 65,022 at 15% discount rate — barely positive. At 18%: NPV = -Rs 26,318 — investment is not worthwhile at this cost of capital. This sensitivity to discount rate is why choosing the right WACC is critical for NPV analysis.

🏭 NPV Analysis — Common Indian Business Investments 2026

Pre-calculated NPV for typical Indian capital investments. Uses realistic cash flow projections and risk-appropriate discount rates.

Solar Rooftop (5kW)
+\u20B93,011
Invest: ₹3.5L | Rate: 10% | PI: 1.01
Electricity savings grow ~4% p.a. 25-year system life.
Commercial Vehicle Purchase
+\u20B9313,826
Invest: ₹12.0L | Rate: 12% | PI: 1.26
Net freight earnings after fuel, driver, maintenance.
Restaurant Setup
+\u20B964,110
Invest: ₹8.0L | Rate: 15% | PI: 1.08
Ramp-up then maturity. High failure risk.
IT Services Business
+\u20B91,250,144
Invest: ₹5.0L | Rate: 14% | PI: 3.50
Low capex, high CM. Grows with headcount.
Retail Shop
+\u20B944,296
Invest: ₹7.0L | Rate: 13% | PI: 1.06
Moderate growth then plateau. Lease risk.
Equity MF (SIP proxy)
\u20B9-620,448
Invest: ₹12.0L | Rate: 12% | PI: 0.48
Lump sum invested. Assume 12% CAGR over 10 yrs.

PI (Profitability Index) = (NPV + Investment) / Investment. PI > 1: worthwhile. PI < 1: reject. NPV is more useful than payback period because it accounts for time value of money and all cash flows over the project's life. Two investments with same payback period can have very different NPVs if their cash flow timing differs. Always use the discount rate that matches the RISK of the specific investment — not a generic rate.

📈 Net Present Value Calculator India — Which Discount Rate to Use?

The discount rate (WACC / hurdle rate) is the most important input in NPV analysis. Choose based on your investment's risk profile.

PPF / FD Rate
7.10%
Risk-free. EEE tax-free. Use for guaranteed cash flows.
EPF Rate
8.25%
Government-backed. EEE. Best guaranteed return.
Home Loan Rate
8.75%
Opportunity cost if capital repays mortgage.
MSME WACC (typical)
13.00%
Small business weighted average cost of capital.
Equity MF CAGR
12.00%
Historical 10-yr equity MF return. Use for equity-risk projects.
VC Hurdle Rate
20.00%
Minimum IRR for venture-backed investments.
Personal Loan Rate
14.00%
Opportunity cost if you carry personal debt.
Inflation Rate (CPI)
5.50%
Use to compute real NPV (inflation-adjusted).

💡 4 NPV Strategies Every Indian Investor Must Know

NPV is the gold standard of investment analysis. These four insights help you use it correctly for Indian business and personal finance decisions.

📈
Net Present Value Calculator India — The Complete Decision Framework
NPV is the single most powerful investment decision tool because it answers one question directly: does this investment create or destroy value? NPV > 0: Investment earns MORE than your required return (WACC). Every rupee of positive NPV is real value created above and beyond the minimum return. NPV = 0: Investment earns EXACTLY your required return. Acceptable but not exceptional. NPV < 0: Investment earns LESS than your required return. Even if you get your money back, the opportunity cost makes it a bad decision. Real example India: You have Rs 10 lakh to invest. Option A: Equipment for business generating Rs 2.5L/year for 6 years. Option B: Equity MF expected at 12% CAGR. Discount rate for both: 12% (equity opportunity cost). NPV of Equipment (Option A) at 12%: -10L + PV of Rs 2.5L/year for 6 years = -10L + 10.28L = Rs 28,000 positive NPV. NPV of Equity MF (Option B): 0 (by definition, since we're discounting at the MF's expected return). Equipment barely beats the equity MF. But equipment has business risk, management effort, and illiquidity — these qualitative factors mean equity MF might be better despite the small positive NPV. NPV is necessary but not sufficient — combine with IRR, payback, and qualitative assessment.
Net Present Value with Monthly Payments — 5 India Use Cases
Monthly payment NPV is the most relevant form for Indian investors because most real-world cash flows are monthly: 1. Rental property NPV: Investment Rs 50L flat. Monthly rent Rs 25,000 for 20 years. Discount rate 10% (equity opportunity cost). Monthly rate = 10/12/100. NPV = -50L + PV of Rs 25,000/month for 240 months = -50L + 26.2L = -Rs 23.8L. Negative NPV means the rental stream alone doesn't justify Rs 50L price at 10% — you're paying for expected capital appreciation. 2. Equipment EMI: Machine costs Rs 5L. Saves Rs 8,000/month in labour for 7 years. Discount rate 14% (cost of business capital). NPV = -5L + PV of Rs 8,000/month for 84 months = -5L + 4.16L = -Rs 84,000. Negative NPV — don't buy the machine. 3. SWP planning: Corpus Rs 50L. Withdraw Rs 40,000/month. Portfolio earns 10%. Monthly NPV confirms corpus sustainability. 4. Home loan prepayment: Prepay Rs 2L lump sum vs monthly Rs 20,000 investment. NPV comparison guides optimal choice. 5. Business subscription revenue: Rs 50L investment in SaaS product. Rs 5,000/month revenue per customer, expect 1,000 customers in 3 years. Monthly NPV model for break-even customer count.
🔰
NPV Sensitivity Analysis — Why Your Assumptions Matter More Than Your Calculator
NPV is only as good as your cash flow projections and discount rate. Sensitivity analysis reveals which assumption drives the decision. Three-point analysis: Base case: Most likely cash flows. Optimistic case: Best realistic outcome. Pessimistic case: Worst realistic outcome. Example: Restaurant investment Rs 8L. Base case: Annual CF Rs 1.5L for 7 years. Discount rate 15%. NPV = +Rs 52,000. Optimistic: CF Rs 2.2L for 7 years. NPV = +Rs 3,92,000. Pessimistic: CF Rs 80,000 for 5 years. NPV = -Rs 4,20,000. If pessimistic scenario has 40% probability, weighted NPV = 0.4×(-4.2L) + 0.35×(0.52L) + 0.25×(3.92L) = -0.69L. Risk-adjusted NPV is NEGATIVE even though base case is positive. Real lesson for India: Restaurant failure rate is very high (70% within 3 years). Pessimistic scenario probability is not 20% — it may be 50%+. The correct risk-adjusted NPV is deeply negative. This is why most restaurant investments look good on a base-case NPV model but fail in practice. Always build pessimistic scenarios with honest probability estimates. Use break-even analysis alongside NPV: At what minimum annual cash flow is NPV = 0? That's your break-even CF. Is that realistically achievable? If not — reject.

❓ NPV Calculator India — Frequently Asked Questions 2026

Most searched NPV and net present value questions India 2026.

NPV Formula India:

NPV = −Initial Investment + CF1/(1+r)^1 + CF2/(1+r)^2 + … + CFn/(1+r)^n

Example:
Investment: Rs 5 lakh
Annual CFs: Rs 1.5L, Rs 2L, Rs 2.5L, Rs 2L, Rs 1.5L
Discount rate: 12%
NPV = −5,00,000 + 1,50,000/1.12 + 2,00,000/1.12^2 + 2,50,000/1.12^3 + 2,00,000/1.12^4 + 1,50,000/1.12^5
= −5,00,000 + 1,33,929 + 1,59,439 + 1,77,997 + 1,27,092 + 85,142
= +Rs 83,599

NPV > 0: Accept ✅

Excel formula:
=NPV(0.12, 150000, 200000, 250000, 200000, 150000) − 500000
Note: Excel NPV function discounts from Year 1. Subtract Year 0 investment separately.

Decision rule:
NPV > 0: Accept (earns above required return)
NPV = 0: Marginal (earns exactly required return)
NPV < 0: Reject (earns below required return)
NPV Monthly Payments Formula:

NPV = −Investment + ∑[Monthly CF / (1 + monthly_rate)^t]
Monthly rate = Annual rate / 12

Example — Rental Property:
Investment: Rs 10 lakh
Monthly CF: Rs 15,000
Annual discount rate: 12%
Duration: 10 years (120 months)
Monthly rate = 12/12/100 = 0.01

PV of monthly flows = 15,000 × [1−(1.01)^−120]/0.01
= 15,000 × 69.70 = Rs 10,45,500

NPV = −10,00,000 + 10,45,500 = +Rs 45,500
NPV > 0: Investment worthwhile ✅

IRR (monthly):
Find r where NPV = 0. Monthly IRR × 12 = annual IRR.
Above example: Monthly IRR ≈ 1.04%, Annual IRR ≈ 12.5%
NPV vs IRR:

NPV: Rupee value created above required return.
NPV = PV of all cash flows − Initial Investment
Gives absolute rupee value: Rs +83,599

IRR: Rate at which NPV = 0.
Find r where ∑[CFt/(1+r)^t] = Investment
Gives % return: 18.5%

When they agree:
If NPV > 0 at your WACC → IRR > WACC also
Both say: Accept ✅

When to use NPV:
Choosing between two investments of different sizes
Capital budgeting (limited budget, choose highest NPV)
Final investment selection

When to use IRR:
Communicating returns (easier: “project earns 22%”)
Benchmarking vs WACC
Quick screening

IRR limitation:
Multiple cash flow sign changes → multiple IRRs
Cannot compare projects of different scale
Always use NPV for final decision
Profitability Index (PI) India:

PI = (NPV + Initial Investment) / Initial Investment
= PV of Future Cash Flows / Initial Investment

Decision rule:
PI > 1: Accept (NPV positive)
PI = 1: Indifferent (NPV = 0)
PI < 1: Reject (NPV negative)

Why PI is useful:
Allows comparison of projects with different investment sizes.
Example:
Project A: Investment Rs 10L, NPV Rs 2L. PI = 12/10 = 1.20
Project B: Investment Rs 50L, NPV Rs 8L. PI = 58/50 = 1.16
NPV prefers B (Rs 8L > Rs 2L). PI prefers A (1.20 > 1.16).
If capital is limited: choose A (better return per rupee invested).
If capital is unlimited: choose B (higher absolute NPV).

PI benchmarks India:
PI < 1.0: Reject
PI 1.0–1.1: Marginal
PI 1.1–1.3: Good
PI > 1.3: Excellent
PI > 1.5: Exceptional (typical VC target)
Real Estate NPV India — Two-Part Valuation:

Property NPV = PV of rental income + PV of future sale value − Purchase price

Example: 2BHK Bengaluru
Purchase price: Rs 80L
Monthly rent: Rs 25,000 for 10 years
Expected sale at Year 10: Rs 1.5 Cr
Discount rate: 10% (equity opportunity cost)

PV of rent = 25,000 × [1−(1.00833)^−120]/0.00833 = Rs 19.0L
PV of sale = 1,50,00,000/(1.10)^10 = Rs 57.8L
Total PV = Rs 76.8L
NPV = 76.8L − 80L = −Rs 3.2L (slightly negative)

Interpretation:
At 10% opportunity cost, you are overpaying by Rs 3.2L for the projected cash flows.
If sale price expectation rises to Rs 1.6 Cr: NPV turns positive.
If discount rate is 8%: NPV becomes positive (PV of rent and sale both rise).

Key: Indian real estate NPV is very sensitive to:
Expected capital appreciation rate
Rental yield (2–4% gross in India – low vs global)
Discount rate (your opportunity cost)

📈 Make Smarter Investment Decisions with NPV Analysis

Before investing lakhs in equipment, property, a business, or any major capital allocation, NPV analysis tells you whether the investment creates or destroys value at your specific cost of capital. Vikash Royal provides full NPV, IRR, and sensitivity analysis for your investment decisions — with realistic cash flow projections, India-appropriate discount rates, and clear rupee-value recommendations. Stop guessing. Calculate first. SEBI-Registered. ARN: ARN-356458

💬 Get My NPV Analysis on WhatsApp