Solar ROI & Payback Calculator (Excel) – User Manual (India)

If you’ve downloaded the Solar ROI & Payback Calculator (India) workbook, this guide will show you exactly how to use it— what each input means, how payback is calculated, and how to interpret the charts.

Download the free Solar ROI Calculator Excel and estimate savings, payback, IRR and NPV for your rooftop solar system (India).

This calculator is designed for Indian rooftop solar decisions, where tariff slabs, net metering/net billing, and real-world self-consumption matter more than “generic ROI claims”.

What this Excel workbook helps you calculate

From your own inputs, the tool estimates:

• Year 1 net savings (₹)
• Simple payback (years) (basic cost ÷ Year 1 savings)
• Estimated payback (years) (based on year-by-year cash flow)
• IRR (approx) (returns across the full analysis period)
• NPV (₹) (value of future savings in today’s money)
• Plus a year-by-year cash flow model and charts for quick understanding

Before you start (important)

1) Use Microsoft Excel (recommended)

The workbook is built for Excel formulas and formatting. It may work in Google Sheets, but formatting and some functions can behave differently.

2) Edit only the blue cells

Blue cells are input fields. Everything else is calculated automatically.

3) Keep realistic assumptions

If you set export credit too high, or self-consumption too optimistic, payback will look better than reality.

Sheet 1: Inputs (where you do 90% of the work)

Enter your system size, cost, tariff and self-consumption in the blue cells to instantly see savings and payback.

On the Inputs sheet, you’ll see four sections.

A) System & Costs

• System size (kW): Your solar plant capacity (e.g., 3 kW, 5 kW).
• Installed cost before subsidy (₹): The total quoted price (including GST, structure, wiring, installation, etc.).
• Subsidy (₹): Enter the subsidy amount you expect/receive.
• Net system cost (₹): Auto-calculated: Installed cost – Subsidy (this is your “out of pocket” amount).

o   Tip: If you’re comparing vendor quotes, keep system size constant first—then change pricing.

B) Generation Assumptions

Avg generation per kW per day (kWh/kW/day): This is your expected solar output. Typical residential values in India often fall around 3.5–5.0 depending on city, shading, tilt, and roof direction.

Performance degradation per year (%): Panels slowly degrade over time. A common planning assumption is 0.5%/year.

Analysis period (years): Usually 25 years (aligned with typical panel performance warranty planning). You can reduce to 20 if you prefer conservative planning.

C) Usage & Tariff (this controls ROI the most)

Self-consumption (%): The percentage of solar generation you use directly at home during the day.

• Higher self-consumption = better ROI
• Low self-consumption + low export credit = slower payback

Retail tariff (₹/kWh): Your effective per-unit cost. If your bill has slabs, use a realistic average or marginal rate (what you pay on the last units you consume).

Export credit (₹/kWh): What you get for excess exported units (depends on your state/DISCOM policy).

• If your setup effectively offsets at retail (strong net metering), export credit can be closer to retail tariff.
• If your state uses net billing / low feed-in credits, export credit may be much lower.

Tariff escalation per year (%): Electricity tariffs often rise over time. A conservative assumption is 2–5%.

O&M cost in Year 1 (₹/year): Annual cleaning and minor upkeep. Many homeowners keep ₹2,000–₹5,000 as a planning range.

O&M escalation per year (%): If you expect maintenance costs to increase over time, keep 2–5%.

D) Replacements & Finance

Inverter replacement year (0 = none): If you want realism, set an inverter replacement around 10–12 years for many string inverters. Set 0 to ignore replacement completely.

Inverter replacement cost (₹): Your expected replacement cost (you can keep this conservative).

Discount rate for NPV (%): This is used only for NPV (time value of money).

If you want a simple approach: use 7–10% as a planning range.

Understanding the “Key Results” box

The Inputs sheet also shows KEY RESULTS on the right:

• Year 1 net savings (₹): Savings in the first year after O&M
• Simple payback (years): Net cost ÷ Year 1 net savings
• Payback (estimated, years): Based on when cumulative cash flow turns positive
• IRR (approx): A return metric over the analysis period (higher is better)
• NPV (₹): Value of the project in today’s rupees (positive is good)

Quick interpretation:

• Payback under ~4–6 years is often considered strong for grid-tied solar (depends on your tariffs and export rules).
• NPV positive means the investment beats your discount rate assumption.

The Payback tab breaks down yearly generation and cash flows to estimate payback, IRR and NPV.

Sheet 2: Payback (Year-by-Year Cash Flow Model)

This sheet breaks down everything year-by-year so you can see why payback happens when it happens.

• What each column means (in plain English)
• Generation (kWh): annual units produced (with degradation applied)
• Self-use (kWh): generation × self-consumption %
• Export (kWh): remaining generation exported
• Retail tariff / Export rate: both can increase yearly (escalation)
• Savings (₹): (Self-use × retail tariff) + (Export × export credit)
• O&M (₹): annual operations & maintenance cost
• Replacement (₹): shows cost only in replacement year
• Net cash flow (₹): Savings − O&M − Replacement
• Cumulative (₹): running total starting from negative (upfront cost)
• Payback fraction: the exact year where cumulative crosses zero
• Discount factor + PV of net cash flow: used to compute NPV

Why there are two paybacks (simple vs estimated)

• Simple payback assumes Year 1 savings stay “flat”
• Estimated payback uses the model where tariffs rise, generation degrades, and replacements may happen

So it’s normal for the two to differ slightly.

Sheet 3: Charts (quick visual payback check)

Visual charts help you spot payback year and understand how cash flow changes over time.

You get two charts:

1) Cumulative Cash Flow (₹)

This shows when your investment turns positive.

The year where the line crosses zero ≈ payback year.

2) Annual Net Cash Flow (₹)

This shows how yearly savings change over time—and highlights years where replacement costs reduce net cash flow.

How to use this workbook for real decisions (recommended workflow)

Step 1: Start with realistic generation

If you’re unsure, begin with 4.0 kWh/kW/day and then test 3.7 and 4.5 to see sensitivity.

Step 2: Set self-consumption honestly

If you work from office and most loads are evening-based, self-consumption may be lower unless you shift loads to daytime.

Step 3: Match export credit to your policy

This one input can dramatically change payback. If unsure, start conservative.

Step 4: Add inverter replacement for realism

If your payback is 4–6 years, replacement won’t “break” the economics—but it improves honesty in long-term planning.

Step 5: Compare scenarios

Try:

• With and without subsidy
• 60% vs 80% self-consumption
• Higher vs lower export credit
• 2% vs 5% tariff escalation

This makes the tool truly useful.

Common mistakes (and how to avoid them)

• Using retail tariff as export credit when your policy pays much less

→ Set export credit to your real DISCOM agreement value.

• Assuming 90–100% self-consumption without daytime load shifting

→ Start with 50–70% unless you know your usage profile.

• Ignoring shading and roof constraints

→ Generation assumptions must reflect your roof reality.

• Editing non-blue cells and breaking formulas

→ If something breaks, re-download a fresh copy and re-enter inputs.

Practical notes (India context)

• Best ROI happens when you use solar during the day (AC, pump, washing machine, office-at-home loads).
• If exports are valued low, focus on right-sizing your system and increasing self-consumption rather than oversizing.

 Grab the Solar ROI & Payback Calculator Excel Workbook Here 

Use this workbook to quickly estimate Year-1 savings, payback (simple + cash-flow), IRR, and NPV for your rooftop solar plan in India. Just edit the blue cells with your system size, cost, tariff, and self-consumption - results update automatically in seconds.