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)

MonthTotal 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)

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.

4. Payback & ROI



Enter 0.30 (30%) or 30

 


 





Inqure Now

Terms & Conditions