Payback Period Calculator India 2026 — Simple, Discounted & Excel Formula

Calculate payback period for any investment — simple payback, discounted payback, NPV, and IRR. Includes Excel formulas for payback period, year-wise cash flow recovery chart, and Indian investment benchmarks.

⏳ Payback Period Calculator 📊 How to Calculate in Excel 🏭 Discounted Payback Period 📈 NPV & IRR Calculator ✅ Equal & Unequal Cash Flows 🔰 Investment Recovery Analysis
Payback Period Calculator India

Calculate Payback Period

Enter initial investment and expected annual cash flows. Get exact payback period in years and months, plus Excel formulas.

📈 Investment Details
₹10.00 L
₹10,000₹100 Crore
₹3.00 L
₹1,000₹50 Crore
0%
0% (Fixed CF)30% p.a. growth
10 yrs
1 yr40 yrs
₹0
₹0₹50 Crore
⏳ Simple Payback = Investment / Annual Cash Flow. Net Cash Flow = Revenue − Operating Costs (exclude depreciation — it is non-cash). Add salvage value to total recovery in final year.
🏭 Discounted Payback Period
₹10.00 L
₹10,000₹100 Crore
₹3.00 L
₹1,000₹50 Crore
12%
1%30%
10 yrs
1 yr40 yrs
0%
0% (Fixed CF)30%
🏭 Discounted Payback discounts each year's cash flow using the cost of capital. Always longer than simple payback. More realistic for high-rate environments.
📊 Unequal Annual Cash Flows
₹10.00 L
₹10,000₹100 Crore
10%
0% (No discount)30%
📈 Cash Flow per Year (₹)
📊 Enter actual or projected cash flows for each year. Useful for startups with ramp-up, seasonal businesses, or projects with variable income. Excel MATCH formula shown in results.
⏳ Simple Payback Period
0 yrs
loading...
NPV: ₹0  |  IRR: 0%  |  ROI: 0%
⏳ Simple Payback
0 yrs
undiscounted
🏭 Discounted PBP
0 yrs
at discount rate
0% recovered
Recovered Remaining
YEAR-WISE CUMULATIVE RECOVERY
🚀 Get Investment Analysis on WhatsApp
VR
Vikash Royal ARN-356458
B.E. | MBA Finance | NISM Certified | 7+ Years in Finance

⏳ Payback Period Calculator — Recovery Period at Different Annual Cash Flows

Simple payback period for different investment sizes and annual cash flows. Green = recovered within asset life. Red = investment not recovered.

Investment CF: ₹50K/yr CF: ₹1L/yr CF: ₹2L/yr CF: ₹5L/yr CF: ₹10L/yr CF: ₹25L/yr
₹1.0 L 2.0 yrs 1.0 yrs 0.5 yrs 0.2 yrs 0.1 yrs 0.0 yrs
₹3.0 L 6.0 yrs 3.0 yrs 1.5 yrs 0.6 yrs 0.3 yrs 0.1 yrs
₹5.0 L 10.0 yrs 5.0 yrs 2.5 yrs 1.0 yrs 0.5 yrs 0.2 yrs
₹10.0 L 20.0 yrs 10.0 yrs 5.0 yrs 2.0 yrs 1.0 yrs 0.4 yrs
₹25.0 L 50.0 yrs 25.0 yrs 12.5 yrs 5.0 yrs 2.5 yrs 1.0 yrs
₹50.0 L Never 50.0 yrs 25.0 yrs 10.0 yrs 5.0 yrs 2.0 yrs
₹1.0 Cr Never Never 50.0 yrs 20.0 yrs 10.0 yrs 4.0 yrs
₹5.0 Cr Never Never Never Never 50.0 yrs 20.0 yrs

Green = payback within 5 years (excellent). Amber = 5–10 years (acceptable for large capex). Red = over 10 years (high risk — verify asset useful life exceeds payback). Formula: Simple Payback = Initial Investment / Annual Net Cash Flow. Net Cash Flow = Annual Revenue − Annual Operating Costs (exclude depreciation — non-cash). Include working capital changes and tax effects for accurate cash flow. A project with payback period longer than its useful life will never recover the investment — automatic reject regardless of other metrics.

🔰 Payback Period — Common Indian Business Investments 2026

Expected payback period for typical capital investments in India. Based on industry-average cash flows and asset useful lives.

Solar Rooftop (5kW Home)
7.8 years
Inv: ₹3.5L | Net CF: ₹45K/yr
✅ Within 25yr life
CNC Machine (SME)
5.4 years
Inv: ₹15.0L | Net CF: ₹280K/yr
✅ Within 10yr life
Commercial Vehicle
5.1 years
Inv: ₹12.0L | Net CF: ₹235K/yr
✅ Within 10yr life
Restaurant Kitchen Setup
5.7 years
Inv: ₹8.0L | Net CF: ₹140K/yr
✅ Within 7yr life
Office Renovation
6.7 years
Inv: ₹5.0L | Net CF: ₹75K/yr
✅ Within 10yr life
Software / ERP System
3.4 years
Inv: ₹4.0L | Net CF: ₹117K/yr
✅ Within 5yr life
E-commerce Warehouse
6.2 years
Inv: ₹20.0L | Net CF: ₹325K/yr
✅ Within 15yr life
Retail Shop Setup
7.6 years
Inv: ₹7.0L | Net CF: ₹92K/yr
✅ Within 10yr life
Manufacturing Plant Upgrade
6 years
Inv: ₹50.0L | Net CF: ₹840K/yr
✅ Within 15yr life
IT Infrastructure
4.1 years
Inv: ₹6.0L | Net CF: ₹145K/yr
✅ Within 5yr life

Net Cash Flow = Annual Revenue/Savings − Annual Operating & Maintenance Costs. Excludes depreciation (non-cash). Solar rooftop payback 5.8 years on ₹3.5L investment with ₹50K/year electricity savings minus ₹5K maintenance — well within 25-year panel life. Manufacturing plant upgrade payback 6.0 years — acceptable for long-life heavy machinery. Software/ERP: 2.8 years — excellent, especially as efficiency gains often grow year-on-year. Commercial vehicle: 5.1 years on ₹12L investment with ₹2.5L net annual earnings — marginal but acceptable if vehicle life is 8–10 years.

📊 How to Calculate Payback Period in Excel — Ready-to-Use Formulas

Copy these Excel formulas directly. FC = Fixed/Initial Cost, ACF = Annual Cash Flow, CF1:CFn = individual year cash flows, CUMCF = cumulative cash flow column.

📊 Simple Payback
=Initial_Investment/Annual_Cash_Flow
Assumes equal annual cash flows. Fastest formula.
📊 Cumulative CF Test
=MATCH(TRUE,CUMULATIVE_CF>=0,0)
Find first year cumulative CF turns positive. Returns year number.
📊 Exact Month (simple)
=INT(FC/ACF)&" yrs "&TEXT(MOD(FC/ACF,1)*12,"0.0")&" mo"
Splits payback into years and months.
📊 Discounted Payback
=MATCH(TRUE,DISC_CUMULATIVE_CF>=0,0)
Use NPV discounted cash flows. More accurate than simple payback.
📊 SUMIF for partial yr
=SUMIF(CF_RANGE,">"&0)/COUNT(CF_RANGE)
Average positive cash flow for interpolation.
📊 NPV Check
=NPV(Rate,CF1:CF10)-Initial_Investment
If NPV > 0, investment recovers cost. Complement to payback.
📊 IRR
=IRR({-Investment,CF1,CF2,...,CFn})
Internal rate of return. Should exceed cost of capital.
📊 XNPV (irregular CF)
=XNPV(Rate,Values,Dates)
For irregular cash flow timing. More accurate than NPV.

Excel payback period — complete setup guide: Column A = Year (0 to n). Column B = Annual Cash Flow (Year 0 = negative investment). Column C = Cumulative Cash Flow (=C1+B2, drag down). Simple Payback = ABS(B1)/B2 (for equal annual CFs). Exact payback (unequal): =MATCH(TRUE,C1:C11>=0,0)-1 + ABS(INDEX(C1:C11,MATCH(TRUE,C1:C11>=0,0)-1))/INDEX(B1:B11,MATCH(TRUE,C1:C11>=0,0)) — this is an array formula (Ctrl+Shift+Enter in Excel 2019 and older; Enter in Excel 365). For discounted payback: Add Column D = B/(1+Rate)^A. Column E = Cumulative Column D. Apply same MATCH formula to Column E. IRR = =IRR(B1:B11) where B1 is negative investment. NPV = =NPV(Rate,B2:B11)+B1 (B1 is negative, so add it back).

💡 4 Smart Payback Period Strategies for Indian Businesses

Payback period is a useful screening tool — but these four insights prevent the most common mistakes in using it.

⏳
Simple vs Discounted Payback — When to Use Which
Simple payback period is fast but ignores the time value of money. A Rs 1 lakh cash flow in Year 1 is treated identically to Rs 1 lakh in Year 7. In an inflationary economy like India (6% CPI), this matters enormously. When to use Simple Payback: Quick screening to eliminate obviously bad investments. When projects are short-term (under 3 years). When comparing very similar projects with similar timing of cash flows. When you do not know your cost of capital precisely. When to use Discounted Payback: Investments above Rs 25 lakh (where precision matters). Long-duration projects (5+ years). When comparing projects of different durations. When your cost of capital is high (above 12%). When lenders require NPV/IRR analysis. The discounted payback period is always longer than simple payback because discounted cash flows are smaller. A project with simple payback of 4 years might have discounted payback of 5.5 years at 12% cost of capital. This difference is critical for loan-financed investments — if your loan tenure is 5 years but discounted payback is 5.5 years, you may face cash flow stress toward the end of the loan period.
📈
Payback Period Is Not Enough — Always Complement With NPV
The payback period has a critical flaw: it ignores all cash flows AFTER the payback point. Example: Project A: Invest Rs 10L. Gets Rs 3L/year for 4 years. Payback = 3.33 years. Then project ends. Total recovery = Rs 12L. Project B: Invest Rs 10L. Gets Rs 2L/year for 10 years. Payback = 5 years. Total recovery = Rs 20L. Simple payback says: Project A is better (3.33 vs 5 years). NPV analysis (at 12%): Project A NPV = Rs 9.11L − Rs 10L = -Rs 0.89L (NEGATIVE — reject). Project B NPV = Rs 11.30L − Rs 10L = +Rs 1.30L (POSITIVE — accept). So payback chose the WRONG project! Project B is superior despite longer payback. Always calculate NPV alongside payback period. If NPV is negative, reject the project regardless of payback period. Use payback as a liquidity/risk filter (maximum tolerable payback period), then use NPV/IRR for the final decision. For Indian MSMEs and entrepreneurs: set a maximum payback period threshold (e.g., 5 years for equipment, 3 years for working capital investments) — reject anything above that without further analysis, but approve only if NPV is also positive.
🏭
How to Calculate Payback Period in Excel — The Right Way
The most common Excel payback mistake: using simple division (=FC/ACF) for unequal cash flows. This only works when cash flows are identical every year. Correct Excel setup for any payback calculation: Row 1: Year 0 | −Investment | −Investment (cumulative). Rows 2-n: Year | Cash Flow | =Previous cumulative + This year CF. Payback formula: =MATCH(TRUE,C1:C15>=0,0)-1+ABS(INDEX(C1:C15,MATCH(TRUE,C1:C15>=0,0)-1))/INDEX(B1:B15,MATCH(TRUE,C1:C15>=0,0)) This finds: Year before payback + fraction of remaining year needed. Press Ctrl+Shift+Enter in Excel 2019 and older. In Excel 365/2021 and Google Sheets, just press Enter. For discounted payback: Add column D = B/(1+RATE)^A. Add column E = Cumulative of D. Apply same formula to column E. For IRR: =IRR(B1:B11) where B1 is negative. Should exceed your cost of capital (WACC). For NPV: =NPV(Rate,B2:B11)+B1. If NPV > 0 and IRR > cost of capital: invest. For irregular cash flow timing (not exactly year-end): use =XNPV(Rate, Cash_Flow_Range, Date_Range) and =XIRR(Cash_Flow_Range, Date_Range) — these are more accurate.
🔰
Payback for Solar, Equipment & Vehicles — India-Specific Considerations
Common payback calculations in India have India-specific adjustments that most generic calculators miss: Solar rooftop: Payback = Cost / Annual Electricity Savings. Annual savings = Units generated x Electricity tariff (Rs 7–10/unit in most states). Add subsidy (PM Surya Ghar scheme: Rs 30,000–78,000 for 1–3 kW systems). Subtract O&M cost. Net payback: 4–8 years on a 25-year system life — excellent ROI. Add net metering benefit where available (sell excess to DISCOM). Commercial vehicle: Payback = Vehicle Cost / (Annual Freight Earnings − Fuel − Driver − Maintenance − EMI Interest). Common mistake: not deducting EMI interest as a cost (it reduces cash flow). GST and road tax are one-time costs that add to initial investment. Manufacturing equipment: Include installation, training, and testing cost in initial investment. Cash flow = Additional revenue — OR — Cost savings if replacing older machine. Factor in machine downtime for maintenance. Agricultural investments (drip irrigation, tractors): Cash flow varies by crop cycle. Use seasonal adjusted payback — calculate based on crop income per season, not calendar year. Include government subsidy in initial cost reduction (NABARD, state agri subsidies). Common to all: Always verify that payback period < asset useful life. If machine breaks down before payback — net loss. A 10-year payback on a 5-year useful life machine is a guaranteed loss.

❓ Payback Period Calculator — Frequently Asked Questions

Most searched payback period and investment analysis questions India 2026.

Excel Payback Period — Step by Step:

Setup:
A1: Year | B1: Cash Flow | C1: Cumulative CF
A2: 0 | B2: -10,00,000 (investment) | C2: =B2
A3: 1 | B3: 3,00,000 | C3: =C2+B3
(Drag down for all years)

Simple Payback (equal CFs):
=ABS(B2)/B3 → Returns 3.33 years

Exact Payback (unequal CFs):
=MATCH(TRUE,C2:C12>=0,0)-1+ABS(INDEX(C2:C12,MATCH(TRUE,C2:C12>=0,0)-1))/INDEX(B2:B12,MATCH(TRUE,C2:C12>=0,0))
(Press Ctrl+Shift+Enter in Excel 2019 and older)

IRR: =IRR(B2:B12)
NPV: =NPV(0.12,B3:B12)+B2

Discounted Payback:
Add Column D: =B3/(1+0.12)^A3 (discounted CF)
Add Column E: Cumulative of D
Apply same MATCH formula to Column E.
Payback Period = Time taken to recover initial investment from net cash flows.

Formula (equal annual CFs):
Payback = Initial Investment / Annual Net Cash Flow
Example: Rs 10L investment, Rs 3L/year CF: Payback = 10/3 = 3.33 years

Exact formula (convert to years & months):
Years = Floor(10/3) = 3 years
Remaining = 10 − (3 × 3) = Rs 1L unrecovered after 3 years
Months = (1/3) × 12 = 4 months
Payback = 3 years 4 months

For unequal cash flows (cumulative method):
Year 1: Rs 2L | Cumulative: Rs 2L
Year 2: Rs 3L | Cumulative: Rs 5L
Year 3: Rs 3.5L | Cumulative: Rs 8.5L
Year 4: Rs 3L | Cumulative: Rs 11.5L (exceeds Rs 10L)
Payback = 3 + (10 − 8.5)/3 = 3 + 0.5 = 3.5 years
Payback period benchmarks India 2026:

Manufacturing equipment: 3–7 years (machine life 10–15 years)
Commercial vehicles: 4–7 years (vehicle life 8–10 years)
Solar rooftop (residential): 5–8 years (system life 25 years)
IT infrastructure / software: 1–3 years (obsolescence risk high)
Real estate (commercial): 8–15 years (long-term asset)
Retail shop setup: 3–6 years (depends on location)
Restaurant / food business: 2–5 years (high failure rate)
Agricultural equipment: 5–10 years (seasonal income)

General rules:
Payback < 3 years: Excellent — fast recovery
Payback 3–5 years: Good for most businesses
Payback 5–8 years: Acceptable for large capex
Payback > 10 years: Risky — verify asset life
Payback > Asset life: Never invest (automatic reject)

Always verify: Payback Period < Asset Useful Life.
Simple Payback Period:
Uses undiscounted nominal cash flows
Fast to calculate. Ignores time value of money
Best for quick screening

Discounted Payback Period (DPP):
Discounts each CF: Discounted CF = CF / (1+Rate)^Year
Cumulates discounted CFs until investment recovered
Always longer than simple payback
More realistic for high-rate environments

Example: Rs 10L investment, Rs 3L/year CF, 10% rate:
Simple Payback = 10/3 = 3.33 years
Year 1 DCF = 3/1.10 = 2.73L | Cumulative: 2.73L
Year 2 DCF = 3/1.21 = 2.48L | Cumulative: 5.21L
Year 3 DCF = 3/1.331 = 2.25L | Cumulative: 7.46L
Year 4 DCF = 3/1.464 = 2.05L | Cumulative: 9.51L
Year 5 DCF = 3/1.611 = 1.86L | Cumulative: 11.37L
DPP = 4 + (10−9.51)/1.86 = 4.26 years
vs Simple Payback 3.33 years — 28% difference!
5 key limitations of payback period:

1. Ignores post-payback cash flows: A project returning Rs 10L for 20 years after payback is treated identically to one returning Rs 10L only until payback. NPV fixes this.

2. Ignores time value of money (simple payback): Rs 1 lakh in Year 1 ≠ Rs 1 lakh in Year 5 in real terms. Discounted payback partially addresses this.

3. No profitability measure: Payback just measures recovery speed — not profit. A project recovering in 2 years but making 5% ROI may be worse than one recovering in 4 years at 25% ROI.

4. Ignores salvage value: A machine worth Rs 5L at end of life has real value. Simple payback ignores this (though you can add it to final year CF).

5. Ignores project scale: A Rs 1L investment with 2-year payback vs Rs 100L investment with 2-year payback — payback treats them identically. NPV correctly shows the larger project creates more value.

Solution: Use payback as a preliminary filter only. Always follow up with NPV and IRR for the final investment decision.

⏳ Get a Full Investment Feasibility Analysis — Payback, NPV, IRR, and More

Calculating payback period is just the start of investment analysis. Vikash Royal will build a complete financial model for your proposed investment — equipment, solar, vehicle, property, or business expansion — including payback period, NPV at your cost of capital, IRR, sensitivity analysis, and tax implications. Know before you invest whether the returns justify the risk. SEBI-Registered. ARN: ARN-356458

💬 Get My Investment Analysis on WhatsApp