All cells which are highlighted yellow in the form below, are editable
Once you plug-in numbers that matches your requirements, click Recalculate button and then you may take a print
Capital Expenses
Size of systemkWp
Rate of systemRs./kWp
Total price of systemRs. 1,90,00,000
 
Operating Expenses
Yearly O&M costspercent of system price
Inflation in O&M costsper year
 
Finance
Subsidy of system price, which amounts to Rs. 57,00,000
Total investment   Rs. 1,33,00,000     which is equal to (total price of system - subsidy)
Equity of investment, which amounts to Rs. 1,33,00,000
Debt0%of investment, which amounts to Rs. 0
Interest rate on debt
Duration of debt years
 
Electricity
Generation per year by solar plantkWh/kWp
Degradation in yield per year due to aging0.5%per year
Current rate of grid electricityRs./kWh
Inflation in rate of grid electricityper year
 
Comparison of electricity costs
Comparison of electricity rates
 
Year 1234567891011121314151617181920
Solar Electricity
Estimated plant yield rate
(kWh/kWp)
1,7301,7211,7121,7031,6941,6851,6761,6671,6581,6491,6401,6311,6221,6131,6041,5951,5871,5791,5711,563
Annual solar electricity generation
(kWh)
1,73,0001,72,1001,71,2001,70,3001,69,4001,68,5001,67,6001,66,7001,65,8001,64,9001,64,0001,63,1001,62,2001,61,3001,60,4001,59,5001,58,7001,57,9001,57,1001,56,300
Costs of solar electricity
Equity
(Rs.)
1,33,00,000
Loan payment
(Rs.)
O&M
(Rs.)
19,00019,38019,76720,16220,56520,97621,39521,82222,25822,70323,15723,62024,09224,57325,06425,56526,07626,59727,12827,670
Annual cost of solar electricity
(Rs.)
1,33,19,00019,38019,76720,16220,56520,97621,39521,82222,25822,70323,15723,62024,09224,57325,06425,56526,07626,59727,12827,670
Cumulative cost of solar electricity
(Rs.)
1,33,19,0001,33,38,3801,33,58,1471,33,78,3091,33,98,8741,34,19,8501,34,41,2451,34,63,0671,34,85,3251,35,08,0281,35,31,1851,35,54,8051,35,78,8971,36,03,4701,36,28,5341,36,54,0991,36,80,1751,37,06,7721,37,33,9001,37,61,570
Levelized Cost of Energy (LCOE)
of solar (Rs./kWh)
76.9938.6525.8719.4815.6513.111.289.918.8587.36.726.235.815.455.134.854.64.384.18
Grid Electricity
Rate of grid electricity
(Rs./kWh)
1010.511.0311.5812.1612.7713.4114.0814.7815.5216.317.1217.9818.8819.8220.8121.8522.9424.0925.29
Annual cost of grid electricity
(Rs.)
17,30,00018,07,05018,88,33619,72,07420,59,90421,51,74522,47,51623,47,13624,50,52425,59,24826,73,20027,92,27229,16,35630,45,34431,79,12833,19,19534,67,59536,22,22637,84,53939,52,827
Cumulative cost of grid electricity
(Rs.)
17,30,00035,37,05054,25,38673,97,46094,57,3641,16,09,1091,38,56,6251,62,03,7611,86,54,2852,12,13,5332,38,86,7332,66,79,0052,95,95,3613,26,40,7053,58,19,8333,91,39,0284,26,06,6234,62,28,8495,00,13,3885,39,66,215
Levelized Cost of Energy (LCOE)
of grid (Rs./kWh)
1010.2510.5110.7711.0511.3311.6211.9312.2412.5612.8913.2313.5813.9514.3314.7115.1215.5315.9616.4