Q: How is NPV used for solar panel investment in India?

Solar NPV calculation for Indian businesses: Initial investment = System cost (₹35–45/W installed) minus MNRE/state subsidies minus PM Surya Ghar scheme benefit. Annual cash flows = Annual electricity savings (units generated × grid tariff per unit) minus maintenance (₹0.5–1/W per year). Typical 100kW commercial system: Cost ₹40L net of subsidy; Annual savings ₹14L (1,40,000 units × ₹10/unit); at 12% WACC over 25 years: NPV = +₹62L; IRR = 30%+; Payback = 2.9 years. Solar consistently shows the highest NPV among all capital investments for Indian industrial and commercial consumers paying ₹8+/unit.

Q: What is the difference between NPV and payback period?

Payback period = Time to recover initial investment from cash flows (ignores time value of money and post-payback cash flows). NPV = True measure of value created (accounts for time value of money, considers all cash flows including post-payback). Payback Period flaw: A 3-year payback project generating only ₹1L after payback looks same as one generating ₹10L after payback — but NPV reveals the massive difference. Indian banking and infrastructure sector uses DSCR (Debt Service Coverage Ratio) which is related to payback, but investment committees always use NPV for final decisions. Use payback period as a liquidity/risk filter (reject if payback > 5 years for SME), then use NPV for the value assessment.

Question 1

What is NPV meaning in India and how is it used?

Accepted Answer

NPV (Net Present Value) is the difference between the present value of all future cash inflows and the initial investment, discounted at the required rate of return (WACC). Used in India for: capital budgeting decisions (machinery, solar, expansion), real estate project appraisal, startup valuation, infrastructure project loans from banks, and private equity/VC investment decisions. A positive NPV means the investment creates value above the required return; negative NPV means reject. Indian banks require NPV analysis (as part of CMA documents) for project loans above ₹5 crore.

Question 2

What is a good NPV for a business investment in India?

Accepted Answer

Any positive NPV is theoretically acceptable — it means the project returns more than the required rate of return (discount rate). However, Indian business benchmarks: NPV/Investment ratio (Profitability Index) above 1.2 indicates a good investment; above 1.5 is excellent. For solar/capex projects: PI of 1.5–2.5 is common. For real estate: PI of 1.05–1.25 is typical (thin margins, high capital). For restaurants/F&B: target PI above 1.3 to justify high operational risk. When comparing multiple projects with limited capital (capital rationing), rank by PI to maximise NPV per rupee invested.

Question 3

What is the difference between NPV and IRR in India?

Accepted Answer

NPV: Absolute rupee value created above required return. IRR: The discount rate at which NPV = 0 (breakeven return rate). Key differences: NPV directly measures value created in rupees — always use NPV for final decision. IRR is a percentage — easier to communicate but can be misleading for different-sized projects or multiple sign changes in cash flows. Rule: When NPV and IRR conflict (mutually exclusive projects), always follow NPV. IRR fails when projects have non-conventional cash flows (multiple negative cash flows mid-project) — use Modified IRR (MIRR) instead.

Question 4

What discount rate should I use for NPV in India?

Accepted Answer

Discount rate selection by use case in India: Government/quasi-government projects: 7–8% (G-Sec yield); Listed corporates (WACC): 10–14% (blended cost of equity + after-tax cost of debt); SME/MSME capex: 15–18% (higher risk, higher cost of capital); Real estate development: 14–18%; Restaurant/retail: 16–22% (high operational risk); Startup/early-stage: 25–40% (VC hurdle rates). The most rigorous approach: use WACC = (E/V × Re) + (D/V × Rd × (1−T)) where E = equity value, D = debt value, V = total value, Re = cost of equity (use CAPM or equity IRR target), Rd = interest rate on debt, T = tax rate.

Question 5

How to calculate NPV in Excel for Indian business decisions?

Accepted Answer

Excel NPV formula: =NPV(discount_rate, cashflow_year1:cashflow_yearN) + initial_investment. Important: Excel's =NPV() function discounts all values starting from Year 1 — Year 0 (initial investment) must be added separately as a negative number outside the function. Example: Investment ₹10L, CFs years 1–5: ₹2L, ₹3L, ₹3L, ₹4L, ₹4L, discount rate 12%. Formula: =NPV(12%, 200000, 300000, 300000, 400000, 400000) + (−1000000). For IRR: =IRR(cashflows_range) where year 0 is a negative value. For MIRR: =MIRR(cashflows, finance_rate, reinvest_rate).

Question 6

What is WACC for Indian companies in 2025-26?

Accepted Answer

Typical WACC for Indian companies FY 2025-26: Large cap NIFTY 50 companies: 10–13% WACC; Mid cap listed companies: 13–16%; Small cap listed: 15–20%; Unlisted MSME: 16–22%; Infrastructure/utility companies: 9–11% (stable cash flows, high leverage); Real estate developers: 14–18%; IT services (Infosys, TCS): 12–14% (low leverage, high ROE); FMCG (HUL, Nestle): 10–12% (stable cash flows). WACC components: Cost of equity (CAPM: risk-free rate 7% + beta × equity risk premium 6–8%); Cost of debt: 8.5–14% depending on credit rating; Tax rate: 25.17% for domestic companies under new tax regime.

Question 7

Can NPV be negative — what does it mean for my project?

Accepted Answer

Negative NPV means the project returns less than your required rate of return (discount rate) — you would be better off investing the same capital at the discount rate elsewhere. This does NOT necessarily mean the project makes an accounting loss — it may still be profitable in simple terms. It means the TIME VALUE of money makes the project unattractive at your required return. Action when NPV is negative: (1) Negotiate better purchase price or construction cost to reduce initial investment; (2) Identify ways to accelerate cash flows (faster sales, shorter payback); (3) Revisit discount rate — is 18% really your opportunity cost, or can you accept 14%? (4) If NPV is marginally negative at 18% but positive at 15%, it may still be acceptable if you're comfortable with the lower return.

Question 8

What is Profitability Index and how is it used in India?

Accepted Answer

Profitability Index (PI) = (NPV + Initial Investment) ÷ Initial Investment = PV of future cash flows ÷ Initial Investment. PI > 1: Project creates value. PI < 1: Project destroys value. PI = 1: Project exactly meets required return. PI is used in capital rationing — when a company has limited capital and must choose between multiple positive NPV projects. Rank projects by PI and invest in highest PI first. Example: Project A: NPV ₹5L on ₹20L investment → PI = 1.25. Project B: NPV ₹8L on ₹50L investment → PI = 1.16. If only ₹20L available, choose Project A (higher PI) even though Project B has higher absolute NPV.

Question 9

How is NPV used for solar panel investment in India?

Accepted Answer

Solar NPV calculation for Indian businesses: Initial investment = System cost (₹35–45/W installed) minus MNRE/state subsidies minus PM Surya Ghar scheme benefit. Annual cash flows = Annual electricity savings (units generated × grid tariff per unit) minus maintenance (₹0.5–1/W per year). Typical 100kW commercial system: Cost ₹40L net of subsidy; Annual savings ₹14L (1,40,000 units × ₹10/unit); at 12% WACC over 25 years: NPV = +₹62L; IRR = 30%+; Payback = 2.9 years. Solar consistently shows the highest NPV among all capital investments for Indian industrial and commercial consumers paying ₹8+/unit.

Question 10

What is the difference between NPV and payback period?

Accepted Answer

Payback period = Time to recover initial investment from cash flows (ignores time value of money and post-payback cash flows). NPV = True measure of value created (accounts for time value of money, considers all cash flows including post-payback). Payback Period flaw: A 3-year payback project generating only ₹1L after payback looks same as one generating ₹10L after payback — but NPV reveals the massive difference. Indian banking and infrastructure sector uses DSCR (Debt Service Coverage Ratio) which is related to payback, but investment committees always use NPV for final decisions. Use payback period as a liquidity/risk filter (reject if payback > 5 years for SME), then use NPV for the value assessment.

Question 11

How is NPV used in Indian real estate project appraisal?

Accepted Answer

Real estate NPV analysis in India: Cash outflows = Land cost + Construction phased over 2–3 years + marketing + RERA compliance. Cash inflows = Booking amounts (10–20% upfront) + construction-linked installments + possession payment (30–40%). Discount rate: 14–18% for developers. Key: staggered inflows must be correctly timed — RERA mandates 70% of collections stay in designated account, creating a liquidity constraint that effectively increases cost of capital. NPV for under-construction projects is highly sensitive to completion timeline — a 6-month delay on a ₹10Cr project can reduce NPV by ₹50–80L due to delayed inflows and continued holding costs.

Question 12

What is Modified IRR (MIRR) and when to use it in India?

Accepted Answer

MIRR corrects a key IRR flaw: IRR assumes intermediate cash flows are reinvested at the IRR rate itself (unrealistic if IRR is very high). MIRR assumes intermediate cash flows are reinvested at a realistic reinvestment rate (typically WACC). Example: Project with 35% IRR. IRR assumes you can reinvest annual cash flows at 35% — unlikely. MIRR at 12% reinvestment rate might give 22%. More conservative and realistic. Use MIRR when: IRR is very high (25%+); multiple sign changes in cash flow stream; comparing projects with different lives. Excel: =MIRR(cashflows, finance_rate, reinvest_rate). Indian private equity and infrastructure finance teams increasingly use MIRR as their primary IRR metric.

Question 13

How do Indian banks use NPV for project loan appraisal?

Accepted Answer

Indian banks evaluate project loans using: DSCR (Debt Service Coverage Ratio): Annual net operating income ÷ Annual debt service ≥ 1.2–1.5x (minimum threshold); NPV of project: Positive NPV at a discount rate of 12–15% (bank's hurdle rate for project risk); IRR: Typically must exceed 15–18% for industrial projects, 12–14% for infrastructure. CMA (Credit Monitoring Arrangement) document submitted with bank loan application must include detailed cash flow projections, sensitivity analysis, and NPV/IRR calculations. Banks often appoint independent technical consultants to verify NPV projections for loans above ₹25 crore.

Question 14

What is NPV vs ROI and which should I use for Indian business decisions?

Accepted Answer

ROI = Simple percentage return (Final Value − Cost) ÷ Cost × 100. Ignores time value of money and different-period cash flows. NPV = Time-value-adjusted absolute value created. Better for multi-year investments. When to use each: ROI: Quick screening, one-period investments, marketing campaign evaluation, simple cost-benefit comparisons. NPV: Capital expenditure decisions (machinery, solar, renovation), real estate development, multi-year business investments, startup/PE valuation. For any investment spanning 2+ years with significant capital at stake, NPV is always the more rigorous and correct tool. ROI is a good 'first pass'; NPV is the decision tool.

Question 15

How does inflation affect NPV calculations in India?

Accepted Answer

Inflation affects NPV in two ways: (1) Nominal cash flows increase with inflation — future revenues in nominal rupees are higher, but so are costs; (2) Nominal discount rate must also include an inflation premium. At 5.5% Indian CPI inflation: if real WACC = 6%, nominal WACC = (1.06 × 1.055) − 1 = 11.83%. Use either all-nominal (project rupee cash flows inflated + nominal discount rate) or all-real (constant-rupee cash flows + real discount rate). Both methods give same NPV. Mixing nominal CFs with real discount rate drastically overstates NPV — a common mistake in Indian SME financial models. For Indian projects, nominal approach is standard as it's more intuitive to project actual future rupee cash flows.

Question 16

Can I use NPV for SIP or mutual fund investment decisions?

Accepted Answer

NPV can theoretically be applied to SIP, but XIRR is the correct and standard tool for SIP evaluation. For a lumpsum mutual fund investment decision (should I invest ₹10L at current NAV?), you can compute NPV: discount projected future NAV (based on expected CAGR) at your required return rate; if NPV > 0, the fund is expected to beat your hurdle rate. However, mutual fund projections are inherently uncertain — NPV is most useful for deterministic cash flows (solar savings, loan repayments, infrastructure revenues) rather than market-linked investments where CAGR and XIRR are more appropriate.

Question 17

What is NPV for machinery purchase vs leasing in India?

Accepted Answer

Machinery purchase vs lease NPV comparison: Buy: High initial outflow (Year 0) + tax depreciation savings (25% WDV per Income Tax Act) + salvage value at end. Lease: Zero initial outflow + fixed lease payments (tax-deductible) over lease period + no salvage. NPV of buying = PV of depreciation tax shield + PV of salvage − Purchase price. NPV of leasing = PV of lease payments. Choose lower NPV of costs (or higher NPV of benefits). Indian companies with high tax rates (30%+) often find buying more NPV-positive due to accelerated depreciation benefits. MSMEs with Section 44ADA presumptive taxation may find leasing simpler. RBI's guidelines on asset financing are available at rbi.org.in.

Question 18

What is terminal value in NPV and how to calculate it for Indian projects?

Accepted Answer

Terminal Value (TV) accounts for value generated beyond the explicit forecast period. Gordon Growth Model: TV = Final Year CF × (1+g) ÷ (r−g). Where g = perpetual growth rate (typically India long-term GDP growth ~6–7%), r = discount rate. Example: A ₹10L annual CF in year 10, growing at 6%, discount rate 14%: TV = ₹10L × 1.06 ÷ (0.14−0.06) = ₹1.325 crore in Year 10. Discounted to present = ₹1.325Cr ÷ (1.14)^10 = ₹35.6L. Terminal value can represent 40–60% of total NPV for long-duration projects — omitting it (as many Indian SME models do) significantly understates true project value.

Question 19

How do I use this NPV calculator for my business investment in India?

Accepted Answer

Step 1: Enter your total initial investment (Year 0 outflow) using the slider. Step 2: Choose your discount rate — use the WACC presets as a guide (large corp 12%, SME 18%, startup 25%). Step 3: Enter annual net cash flows for each year of your project (click + Year to add rows). Cash flows should be after-tax and after all operating costs. Step 4: Review NPV, IRR, Payback Period, and PI in the results panel. Step 5: Check the sensitivity table to see how NPV changes at different discount rates — if NPV stays positive across a range, the investment is robust. Step 6: Compare IRR to your discount rate — if IRR > discount rate, the project is attractive.

Question 20

What is NPV for startup valuation in India?

Accepted Answer

Indian VC/PE funds use DCF (Discounted Cash Flow) — which is essentially NPV — for startup valuation: Project free cash flows for 5–10 years; add Terminal Value at exit year; discount at VC required return (25–40% for early stage, 20–25% for growth stage). Challenges unique to Indian startups: Cash flow uncertainty is very high; most use revenue multiples instead of DCF for early stage; Series A+ investors begin using DCF blended with comparable transaction multiples. For bootstrapped Indian founders, NPV is most useful for evaluating specific capex decisions (technology investment, geographic expansion) rather than whole-company valuation.

Question 21

What discount rate does SEBI use for project evaluation in India?

Accepted Answer

SEBI itself uses risk-adjusted discount rates for evaluating infrastructure projects under InvIT (Infrastructure Investment Trust) and REIT frameworks. SEBI's InvIT regulations require sponsors to publish DCF valuations for all projects using: Risk-free rate (10-year G-Sec yield ~7%); Equity risk premium (India: 6–8%); Project-specific risk premium. For REITs, SEBI mandates independent valuers to use DCF at a rate commensurate with the risk of the underlying real estate assets (typically 10–13% for commercial, 12–16% for retail). SEBI's guidelines on InvIT and REIT valuation are published at sebi.gov.in under the 'Legal' framework section.

Question 22

Is NPV the same as DCF (Discounted Cash Flow)?

Accepted Answer

NPV and DCF are closely related but not identical. DCF = Discounted Cash Flow — the process of discounting future cash flows to present value. It's a methodology. NPV = Net Present Value — a specific output of the DCF methodology. NPV = Sum of all discounted cash flows (DCF outputs) − Initial Investment. In practice, Indian financial professionals use 'DCF analysis' and 'NPV calculation' interchangeably when evaluating investments. SEBI requires listed companies' related-party transactions above a threshold to be evaluated using DCF (i.e., NPV analysis) by an independent valuer under SEBI's LODR (Listing Obligations and Disclosure Requirements) Regulations.

Metric	Value	Interpretation
Initial Investment	₹80,00,000	Net of MNRE subsidy ₹15L
Annual Savings (Yr 1–10)	₹22,00,000	Net after maintenance ₹3L/yr
Annual Savings (Yr 11–25)	₹18,00,000	Efficiency degradation ~2%/yr
NPV @ 12% WACC	+₹75,32,000	✅ Strong Accept
IRR	26.4%	Exceeds WACC by 14.4%
Payback Period	3.6 years	Then 21.4 years of near-free power

Year	Net Cash Flow	PV @ 18%	Note
Year 0	−₹35,00,000	−₹35,00,000	Setup + deposit
Year 1	₹3,00,000	₹2,54,237	Ramp-up, low margin
Year 2	₹7,50,000	₹5,38,819	Growing customer base
Year 3	₹10,00,000	₹6,08,631	Mature operations
Year 4	₹12,00,000	₹6,19,476	Catering added
Year 5	₹14,00,000	₹6,10,889	Full scale + Swiggy
NPV @ 18%	₹46,50,000 total CF	−₹8,68,948	⚠️ Marginal Reject

NPV Calculator India 2025-26 Net Present Value for Business Investment, Real Estate, Solar & Project Finance Decisions

Discounted Cash Flow (DCF) Breakdown

How NPV is Calculated in India — Formula, Discount Rate, IRR & Decision Rules

NPV Formula + Related Metrics

Step-by-Step: NPV for ₹10L Solar Factory Investment

NPV Decision Rules & Key Metrics

3 Real Indian NPV Examples — Solar Plant, Restaurant Expansion & Real Estate Project

Rajesh Textiles — 200kW Rooftop Solar Plant, Surat Factory ☀️

Meenakshi Iyer — Second Restaurant Branch NPV Decision, Chennai 🍱

Suresh Developers — Residential Apartment Project NPV, Pune 🏗️

5 Expert Tips for Accurate NPV Analysis in Indian Business & Investment Decisions

Choose Discount Rate Based on Project Risk — Not Just Your Loan Interest Rate

Always Run Sensitivity Analysis — NPV’s Single Number Hides Critical Uncertainty

Use NPV Over IRR When Comparing Mutually Exclusive Investments of Different Scales

Include Terminal Value for Long-Duration Projects — Especially Real Estate and Infrastructure

Use Real Cash Flows with Real Discount Rate — Or Nominal with Nominal — Never Mix Them

Frequently Asked Questions — NPV Calculator, IRR, WACC & Project Finance India

Related Calculators

Disclaimer — NPV Calculator (CalcWise Finance)