Green fields are editable · White fields are auto-calculated
Solar Savings & ROI Calculator
Fill your last 12 months units and project details to see solar
capacity, yearly savings, tax benefit and ROI in years.
1. Last 12 Months Consumption (kWh)
| Month | Total Consumption (kWh) |
|---|---|
| Month 1 | |
| Month 2 | |
| Month 3 | |
| Month 4 | |
| Month 5 | |
| Month 6 | |
| Month 7 | |
| Month 8 | |
| Month 9 | |
| Month10 | |
| Month11 | |
| Month12 | |
| Total (12 months) | |
| Daily average consumption |
2. Solar Sizing Inputs
Usual value: 4 kWh/kW/day
Enter 0.20 (20%) – same logic as your sheet
Capacity = Daily Average ÷ Energy per kW per day
Proposed Capacity = Capacity × (1 + Margin)
Proposed Capacity = Capacity × (1 + Margin)
3. Energy Generation from Solar System
Editable – usually same as 4 kWh/kW/day
Daily generation = Total Proposed Capacity × Energy generation from solar system.
Monthly = Daily × 30 · Yearly = Daily × 365.
Monthly = Daily × 30 · Yearly = Daily × 365.
4. Payback & ROI
Enter 0.30 (30%) or 30