{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Title sheet","How to use","RE LCOE - Inputs & Results","RE LCOE calc","RE references","LCOS - Inputs & Results","LCOS calc","Future LCOS","Cost projections","Tariff rates in TN","Storage references","Results"],"not_rendered":{"charts":7,"images":10,"macros":1,"external_links":0,"defined_names":121,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title sheet","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,2,28,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Levelised Cost Calculator for Distributed Energy Resources"]
[]
[]
[null,null,"Authors:","Martin Scherfler"]
[null,null,null,"Rohith C Unni"]
[null,null,null,"Shiv Vembadi"]
[]
[null,null,"Version:","v2.0, April 2021"]
[]
[]
[]
[]
[null,null,"Acknowledgment\nThis work forms part of the Sustainable Energy Transformation, Tamil Nadu (SET-TN) series of documents and activities. SET aims to facilitate higher clean energy deployment in the State by working with stakeholders in order to find sustainable and equitable solutions. SET is a collaborative initiative by Auroville Consulting (AVC), Citizen Consumer and civic Action Group (CAG), the World Resources Institute India (WRI)."]

{"sheet":"How to use","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,14,19,15],[19,1,47,12],[2,1,15,12]]}
[null,"INTRODUCTION TO THE LEVELISED COST CALCULATOR"]
[]
[null,"The tool has been developed to calculate levelised cost of energy (LCOE), from renewable energy (RE) technlogies (orange sheets) and from energy storage (blue sheets). The sheet RE LCOE calc calculates the LCOE for a RE technology, based on inputs entered in the sheet RE LCOE - Inputs & Results. The sheet LCOS calc contains the calculations for levelised cost of storage (LCOS), based on inputs entered in the sheet LCOS - Inputs & Results. \n  ▪  LCOE can be calculated for Solar PV, Wind, Biomass, Bagasse, Biomass Gasifer, Biogas and Small Hydro. The references for default input values are provided in the sheet Reference values. \n  ▪  LCOS can be calculated for two storage configurations: solar plus energy storage, and standalone energy storage. \n         -  LCOS is calculated based on detailed storage dynamics and bottom-up cost analysis. The methodology is applicable to any storage technology, such as lead acid battery, vanadium redox flow battery, hydrogen storage - with the correct input parameters.\n         - The cost inputs are divided into following components: solar PV, inverter or power conversion system, and battery storage system. The battery storage systems cost inlcude the cost of battery pack (INR/kWh), cost of balance of system (BOS) (INR/kWh) and installation cost. Further, see LCOS - Inputs & Results for details on cost inputs for the battery energy storage system.\n         - LCOS calculation takes into account the storage module replacement and inverter replacement at the end of their lives (the EPC and BOS costs for the energy storage system are assumed constant for replacement).\n\nThe sheet Future LCOS can be used to project levelised cost of solar plus energy storage (LCOSS) up to 2030 based on assumed cost reduction curves in Cost projections sheet. Installation cost for battery storage system is assumed to escalate at the same rate as the operation and maintenance expenses. These projections don't take into account technological innovations that will lead to a step increase in performance characteristics, for example, increase in wafer size in solar PV or solid state Li-ion batteries."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NOTES ON USING THE CALCULATOR"]
[]
[null,"▪ Make sure Macros are enabled in the Security Settings\n▪ Use the Inputs and Results sheets to enter the inputs. The levelised cost is displayed on the same sheet.\n▪ Please go through comments added to cells, wherever applicable, for more details\n▪ The RE LCOE calc and LCOS calc sheets contains the levelised cost calculations   \n▪ In the case of Storage, the the debt repayment and depreciation calculations are considered seperately for the storage system,  the inverter and the solar PV plant. \n▪ In the  RE LCOE calc sheet, even though the various parameters are calculated for 50 years, the LCOE is calculated only considering  the number of years of plant life: e.g., 20 years in the case of Biomass.\n▪ In the  LCOS calc sheet, for the configuration solar plus energy storage, the levelised cost corresponds to the plant life of the solar PV.\n▪ For calculating depreciation, straight line method is used. The annual depreciation is calculated as a percentage of the net capital cost.\n▪ In the case of battery storage system, the default depreciation rates for the storage system and for the inverter is such that the residual value (at the end of life) is equal to the input Salvage valu.\n▪ The insurance is calculated as a perentage of the net asset value or is part of O&M expense, depending on the technology."]

{"sheet":"RE LCOE - Inputs & Results","index":2,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[[10,2,10,4],[10,9,10,11]]}
[]
[null,null,null,null,"SELECT TECHNOLOGY:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"INPUTS",null,null,null,null,"Biomass",null,"OUTPUTS"]
[null,null,"Parameter","Unit","Value",null,null,null,null,"Parameter","Unit","Value"]
[]
[null,null,"General inputs"]
[null,null,"System capital cost per kW","INR/kW",118600,null,null,null,null,"Gross capital cost","INR",{"$f":"Capex_perkW*System_size","v":118600000}]
[null,null,"Capital subsidy per kW","INR/kW",30000,null,null,null,null,"Net capital cost","INR",{"$f":"(Capex_perkW-Capitalsubsidy_perkW)*System_size","v":88600000}]
[null,null,"Plant size","kW",1000,null,null,null,null,"Equity","INR",{"$f":"Net_capex*Equity_percentage","v":26580000}]
[null,null,"Plant life","years",25,null,null,null,null,"Debt","INR",{"$f":"Net_capex-Equity","v":62020000}]
[null,null,"Capacity utilisation factor (CUF)","%",0.9,null,null,null,null,"Annual depreciation for first n1 years (on net capex)","INR",{"$f":"Net_capex*Depreciationrate_n1years","v":4137620}]
[null,null,"Auxiliary consumption","%",0.12,null,null,null,null,"Annual depreciation after n1 years (on net capex)","INR",{"$f":"(Net_capex*(1-Salvage_value)-Annual_depreciation_n1yearsnet*n1_years)/(Plant_life-n1_years)","v":1767570}]
[null,null,"Grid availability factor","%",0.95]
[null,null,"Discount rate","%",8.6099999999999996E-2]
[null,null,"Equity","%",0.3]
[null,null,"Return on equity","%",0.156]
[null,null,"Loan tenure","years",15]
[null,null,"Moratorium","years",1]
[null,null,"Interest on loan","%",9.6699999999999994E-2]
[null,null,"Operation and Maintenance expenses in Year 1","INR/kW-yr",6131]
[null,null,"Annual increase in Operation and Maintenance expenses","%",3.8399999999999997E-2]
[null,null,"Insurance (% of depreciated asset value)","%",0]
[null,null,"Working capital – O&M","months",1]
[null,null,"Working capital – Receivables","months",1.5]
[null,null,"Working capital – Maintenance spares","%",0.15]
[null,null,"Interest on working capital","%",0.11169999999999999]
[null,null,"n1 years","years",15]
[null,null,"Depreciation rate for the first n1 years","%",4.6699999999999998E-2]
[null,null,"Salvage value at end of life","%",0.1]
[]
[null,null,"Solar PV-specific inputs"]
[null,null,"Annual solar panel degradation","%",0]
[]
[null,null,"Biomass/Bagasse-specific inputs"]
[null,null,"Working capital – Fuel","months",4]
[null,null,"Station heat rate","kcal/kWh",0]
[null,null,"Calorific value","kcal/kg",0]
[null,null,"Specific fuel consumption","kg/kWh",3]
[null,null,"Fuel cost","Rs/MT",1422]
[null,null,"Fuel cost escalation","%",0.05]

{"sheet":"RE LCOE calc","index":3,"n_rows":43,"n_cols":54,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["This sheet contains the LCOE calculations."]
[]
[null,null,null,null,null,null,null,null,null,"Year ----->"]
[null,"Parameter","Unit","Cumulative",1,{"$f":"E4+1","v":2},{"$f":"F4+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,{"$f":"AC4+1","v":26},27,28,29,30,31,32,33,34,35,{"$f":"AM4+1","v":36},{"$f":"AN4+1","v":37},{"$f":"AO4+1","v":38},{"$f":"AP4+1","v":39},{"$f":"AQ4+1","v":40},{"$f":"AR4+1","v":41},{"$f":"AS4+1","v":42},{"$f":"AT4+1","v":43},{"$f":"AU4+1","v":44},{"$f":"AV4+1","v":45},{"$f":"AW4+1","v":46},{"$f":"AX4+1","v":47},{"$f":"AY4+1","v":48},{"$f":"AZ4+1","v":49},{"$f":"BA4+1","v":50}]
[]
[null,"Cost of Generation"]
[null,"Gross generation / kWh input (for Storage)","kWh",null,{"$f":"System_size*24*365*CUF*Grid_availability*IF(Technology=\"Solar PV\",(1-SolarPV_degradation)^(E4-1),1)","v":7489800},7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,{"$f":"System_size*24*365*CUF*Grid_availability*IF(Technology=\"Solar PV\",(1-SolarPV_degradation)^(AN4-1),1)","v":7489800},7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800,7489800]
[null,"Net generation / kWh available (for Storage)","kWh",null,{"$f":"E7-(E7*Aux_consumption)","v":6591024},6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,{"$f":"AN7-(AN7*Aux_consumption)","v":6591024},6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024,6591024]
[null,"Operation and Maintenance Expenses","INR",null,{"$f":"OandM_year1*System_size","v":6131000},{"$f":"E9+(E9*OandM_escalation)","v":6366430.4000000004},6610901.3273600005,6864759.9383306243,7128366.7199625205,7402096.0020090817,7686336.4884862304,7981491.8096441012,8287981.0951344343,8606239.5691875964,8936719.1686444003,9279889.1847203448,9636236.9294136055,10006268.427503088,10390509.135119207,10789504.685907785,11203821.665846644,11634048.417815154,12080795.877059257,12544698.438738331,13026414.858785883,13526629.18936326,14046051.750234809,14585420.137443826,15145500.270721668,15727087.481117381,16331007.640392289,16958118.333783351,17609310.077800632,18285507.584788177,18987671.076044042,19716797.645364132,20473922.674946114,21260121.305664044,22076509.963801544,{"$f":"AM9+(AM9*OandM_escalation)","v":22924247.946411524},{"$f":"AN9+(AN9*OandM_escalation)","v":23804539.067553725},{"$f":"AO9+(AO9*OandM_escalation)","v":24718633.367747787},{"$f":"AP9+(AP9*OandM_escalation)","v":25667828.889069304},{"$f":"AQ9+(AQ9*OandM_escalation)","v":26653473.518409565},{"$f":"AR9+(AR9*OandM_escalation)","v":27676966.901516493},{"$f":"AS9+(AS9*OandM_escalation)","v":28739762.430534728},{"$f":"AT9+(AT9*OandM_escalation)","v":29843369.307867263},{"$f":"AU9+(AU9*OandM_escalation)","v":30989354.689289365},{"$f":"AV9+(AV9*OandM_escalation)","v":32179345.909358077},{"$f":"AW9+(AW9*OandM_escalation)","v":33415032.792277426},{"$f":"AX9+(AX9*OandM_escalation)","v":34698170.051500879},{"$f":"AY9+(AY9*OandM_escalation)","v":36030579.781478509},{"$f":"AZ9+(AZ9*OandM_escalation)","v":37414154.045087285},{"$f":"BA9+(BA9*OandM_escalation)","v":38850857.560418636}]
[null,"Insurance","INR",null,{"$f":"Insurance*E43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Insurance*AN43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation (on gross capital cost)",null,null,{"$f":"IF(E4<=n1_years, Gross_capex*Depreciationrate_n1years, (Gross_capex*(1-Salvage_value)-Gross_capex*Depreciationrate_n1years*n1_years)/(Plant_life-n1_years))","v":5538620},5538620,5538620,5538620,5538620,5538620,5538620,5538620,5538620,5538620,5538620,5538620,5538620,5538620,5538620,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,{"$f":"IF(AK4<=n1_years, Gross_capex*Depreciationrate_n1years, (Gross_capex*(1-Salvage_value)-Gross_capex*Depreciationrate_n1years*n1_years)/(Plant_life-n1_years))","v":2366070},2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070,2366070]
[null,"Depreciation (on net capital cost)","INR",null,{"$f":"IF(E4<=n1_years, Annual_depreciation_n1yearsnet, Annual_depreciation_aftern1net)","v":4137620},4137620,4137620,4137620,4137620,4137620,4137620,4137620,4137620,4137620,4137620,4137620,4137620,4137620,4137620,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,{"$f":"IF(AN4<=n1_years, Annual_depreciation_n1yearsnet, Annual_depreciation_aftern1net)","v":1767570},1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570,1767570]
[null,"Interest on Term Loan","INR",null,{"$f":"E28","v":5997334},5997334,5568953,5140572,4712191,4283810,3855429,3427048,2998667,2570286,2141905,1713524,1285143,856762,428381,0,0,0,0,0,0,0,0,0,0,{"$f":"AD28","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AN28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on Working Capital","INR",null,{"$f":"E34+E37","v":447034.03425887495},456543.00752097578,460435.85564384126,464707.86989158473,469373.61024340161,474448.19578168826,479947.32616160507,485887.30390507076,492285.05755084543,499158.1656935779,506524.8819459512,514404.16085937573,522815.6848400358,531779.8920985132,541318.00567267602,518360.24044004688,535094.39662494464,552471.14440734254,570515.15930458438,589252.06437388039,608708.4665978374,628911.99466719443,649891.33821441466,671676.28855384816,694297.7809863158,717787.93872819049,742180.11852735304,767508.95803080336,793810.42497118609,821121.86824207974,849482.07093457563,878931.30541046325,909511.39049022517,941265.75083704968,974239.47862119239,{"$f":"AN34+AN37","v":1008479.3975522462},1044034.1293702524,1080954.1628900701,1119291.9256970487,1159101.8585958155,1200440.4929178949,1243366.5307979421,1287940.9285325829,1334226.9831402341,1382290.4222448191,1432199.4974110201,1484025.0810636035,1537840.7671284457,1593722.9755381779,1651751.060750844]
[null,"Return on Equity","INR",null,{"$f":"Equity*ROE","v":4146480},4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480,4146480]
[null,"Fuel cost","INR",null,{"$f":"IF(Technology=\"Biomass\",(E7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(F7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(G7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(H7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(I7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(J7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(K7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(L7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(M7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(N7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(O7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(P7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(Q7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(R7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(S7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(T7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(U7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(V7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(W7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(X7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(Y7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(Z7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AA7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AB7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AC7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AD7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AE7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AF7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AG7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AH7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AI7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AJ7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AK7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AL7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AM7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AN7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AO7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AP7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AQ7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AR7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AS7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AT7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AU7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AV7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AW7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AX7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AY7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(AZ7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(BA7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001},{"$f":"IF(Technology=\"Biomass\",(BB7*'RE LCOE - Inputs & Results'!$E$46*'RE LCOE - Inputs & Results'!$E$47)/1000,0)","v":31951486.800000001}]
[null,"Total Cost of Generation","INR",null,{"$f":"SUM(E9, E10, E12:E16)","v":52810954.834258869},{"$f":"SUM(F9, F10, F12:F16)","v":53055894.207520977},{"$f":"SUM(G9, G10, G12:G16)","v":52875876.98300384},52705626.608222209,52545518.130205929,52395940.997790769,52257299.614647835,52130013.91354917,52014519.952685282,51911270.534881175,51820735.850590348,51743404.145579726,51679782.414253637,51630397.119601607,51595794.94079189,49173401.726347834,49604452.862471595,50052056.362222493,50516847.836363837,50999487.303112209,51500660.12538372,52021077.984030455,52561479.888449222,53122633.225997671,53705334.85170798,54310412.219845578,54938724.558919638,55591164.09181416,56268657.302771822,56972166.253030255,57702689.946978614,58461265.750774592,59248970.865436345,60066923.856501095,60916286.242422737,{"$f":"SUM(AN9, AN10, AN12:AN16)","v":61798264.143963769},62714109.996923983,63665124.330637857,64652657.614766352,65678112.17700538,66742944.194434389,67848665.761332676,68996847.036399841,70189118.472429603,71427173.131602898,72712769.08968845,74047731.932564482,75433957.348606959,76873413.820625469,78368145.421169475]
[null,"Cost Of Generation per kWh","INR",null,{"$f":"E17/E8","v":8.0125569007575859},8.0497194681010082,8.0224069860774048,7.9965763450750913,7.9722844477892858,7.9495903819786982,7.9285555043719818,7.9092435277961615,7.8917206116508272,7.8760554558565063,7.862319398410679,7.8505865166899298,7.840933732642096,7.8334409220178243,7.8281910277965743,7.4606619132850724,7.5260616351073208,7.5939727062475413,7.6644915625195473,7.737718342872399,7.8137570315908,7.8927156059559875,7.9747061895767972,8.0598452116086463,8.148253572086519,8.2400568136067438,8.3353852996013416,8.4343743994581359,8.537164680749429,8.6439021088423065,8.7547382541739509,8.8698305074863324,8.989342303325909,9.1134433521257243,9.2423098811994517,{"$f":"AN17/AN8","v":9.3761248849896113},9.5150783849253138,9.6593676992585458,9.8091977232621748,9.9647812201875432,10.126339123394846,10.294100850085309,10.468304627080684,10.649197829112685,10.837037330102712,11.032089867930758,11.234632423211398,11.444952612614816,11.663349097291327,11.890132006979412]
[null,"Discount factor",null,null,1,{"$f":"E19/(1+Discount_rate)","v":0.92072553171899452},0.84773550475922521,0.78053172337650789,0.71865548602937834,0.66168445449717184,0.60922977119710142,0.56093340502449263,0.51646570760012211,0.47552316324474919,0.43782631732321992,0.40311786881799089,0.37116091411287255,0.34173732999988266,0.31464628487237145,0.28970286794252043,0.26673682712689478,0.24559140698544771,0.22612227878229232,0.20819655536533682,0.19169188414081281,0.17649561195176577,0.16250401616035887,0.14962159668571851,0.13776042416510312,0.12683953978924878,0.11678440271544864,0.10752638128666664,9.9002284583985481E-2,9.1153931114985251E-2,8.3927751694121394E-2,7.7274423804549658E-2,7.1148534945722916E-2,6.5508272668928197E-2,6.0315139185091793E-2,{"$f":"AM19/(1+Discount_rate)","v":5.5533688596898799E-2},{"$f":"AN19/(1+Discount_rate)","v":5.1131284961696707E-2},{"$f":"AO19/(1+Discount_rate)","v":4.7077879533833626E-2},{"$f":"AP19/(1+Discount_rate)","v":4.3345805665991735E-2},{"$f":"AQ19/(1+Discount_rate)","v":3.9909589969608444E-2},{"$f":"AR19/(1+Discount_rate)","v":3.6745778445454784E-2},{"$f":"AS19/(1+Discount_rate)","v":3.3832776397619724E-2},{"$f":"AT19/(1+Discount_rate)","v":3.1150701038228267E-2},{"$f":"AU19/(1+Discount_rate)","v":2.8681245776842154E-2},{"$f":"AV19/(1+Discount_rate)","v":2.6407555268246157E-2},{"$f":"AW19/(1+Discount_rate)","v":2.4314110365754676E-2},{"$f":"AX19/(1+Discount_rate)","v":2.2386622194783792E-2},{"$f":"AY19/(1+Discount_rate)","v":2.061193462368455E-2},{"$f":"AZ19/(1+Discount_rate)","v":1.8977934466149111E-2},{"$f":"BA19/(1+Discount_rate)","v":1.7473468802273372E-2}]
[null,"Present value","INR",null,{"$f":"E18*E19","v":8.0125569007575859},{"$f":"F18*F19","v":7.4115822374560425},6.8008792357262635,6.2415815157332775,5.7293259545904629,5.2601203753755392,4.8303120558520618,4.4365589032146309,4.0758030698787131,3.7452468042599509,3.4423303478250613,3.164711705579299,2.9102481317058984,2.6769791854021903,2.4631112241674233,2.1613751530282173,2.0074778013099763,1.8650144415364216,1.7331122978245723,1.6109663053732157,1.4978338076041651,1.3930296708344538,1.2959217835051018,1.2059269096006284,1.1225068682954555,{"$f":"AD18*AD19","v":1.0451650140751432},0.97344299361707354,0.90691775759063553,0.84519880726390451,0.78792565739408738,0.73476549834333715,0.68541104171002265,0.63957853500724882,0.59700593206388297,0.55745120687629413,{"$f":"AN18*AN19","v":0.52069079960864662},0.48651818433249711,0.45474254891869748,0.4251875782518108,0.39769033263453935,0.37210021389180781,0.34827801227548338,0.32609502781529204,0.30543226026299486,0.28617966223873414,0.26823545061379239,0.25150547155570191,0.2359026150223843,0.22134627482421421,0.20776185067886682]
[null,"Levelised Cost of generation","INR",{"$f":"SUM(OFFSET(E20,0,0,1,Plant_life))/SUM(OFFSET(E19,0,0,1,Plant_life))","v":7.9073337582694352}]
[null,"Average Cost of Generation","INR",{"$f":"AVERAGE(OFFSET(E18,0,0,1,Plant_life))","v":7.8678545999144935}]
[]
[null,"Debt"]
[null,"Debt opening balance","INR",null,{"$f":"Debt","v":62020000},{"$f":"E27","v":62020000},{"$f":"F27","v":57590000},{"$f":"G27","v":53160000},48730000,44300000,39870000,35440000,31010000,26580000,22150000,17720000,13290000,8860000,4430000,0,0,0,0,0,0,0,0,0,0,{"$f":"AC27","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AM27","v":0},{"$f":"AN27","v":0},{"$f":"AO27","v":0},{"$f":"AP27","v":0},{"$f":"AQ27","v":0},{"$f":"AR27","v":0},{"$f":"AS27","v":0},{"$f":"AT27","v":0},{"$f":"AU27","v":0},{"$f":"AV27","v":0},{"$f":"AW27","v":0},{"$f":"AX27","v":0},{"$f":"AY27","v":0},{"$f":"AZ27","v":0},{"$f":"BA27","v":0}]
[null,"Debt repayment","INR",null,{"$f":"IF(E4>Moratorium, IF(E25>0.001, Debt/(Loan_tenure-Moratorium), 0), 0)","v":0},4430000,4430000,4430000,4430000,4430000,4430000,4430000,4430000,4430000,4430000,4430000,4430000,4430000,4430000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AN4>Moratorium, IF(AN25>0.001, Debt/(Loan_tenure-Moratorium), 0), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt closing balance","INR",null,{"$f":"E25-E26","v":62020000},{"$f":"F25-F26","v":57590000},{"$f":"G25-G26","v":53160000},{"$f":"H25-H26","v":48730000},44300000,39870000,35440000,31010000,26580000,22150000,17720000,13290000,8860000,4430000,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AD25-AD26","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AN25-AN26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest","INR",null,{"$f":"Interest*E25","v":5997334},5997334,5568953,5140572,4712191,4283810,3855429,3427048,2998667,2570286,2141905,1713524,1285143,856762,428381,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Interest*AN25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total debt service","INR",null,{"$f":"E26+E28","v":5997334},{"$f":"F26+F28","v":10427334},9998953,9570572,9142191,8713810,8285429,7857048,7428667,7000286,6571905,6143524,5715143,5286762,4858381,0,0,0,0,0,0,0,0,0,0,{"$f":"AD26+AD28","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AN26+AN28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Working Capital"]
[null,"Operation and Maintenance wcap","INR",null,{"$f":"E9/(12/Workingcapital_OandM)","v":510916.66666666669},530535.8666666667,550908.44394666667,572063.32819421869,594030.55999687675,616841.33350075677,640528.04070718586,665124.3174703418,690665.09126120282,717186.63076563308,744726.5973870334,773324.0987266954,803019.7441178005,833855.70229192404,865875.76125993393,899125.3904923154,933651.80548722029,969504.0348179295,1006732.9897549381,1045391.5365615276,1085534.5715654902,1127219.099113605,1170504.3125195673,1215451.6781203188,1262125.022560139,1310590.6234264483,1360917.303366024,1413176.5278152793,1467442.506483386,1523792.298732348,1582305.9230036701,1643066.4704470111,1706160.2229121763,1771676.7754720037,1839709.1636501288,{"$f":"AN9/(12/Workingcapital_OandM)","v":1910353.9955342936},1983711.5889628103,2059886.1139789822,2138985.7407557755,2221122.7932007969,2306413.9084597076,2394980.2025445607,2486947.4423222719,2582446.2241074471,2681612.1591131729,2784586.0660231188,2891514.1709584068,3002548.3151232093,3117846.1704239403,3237571.4633682198]
[null,"Maintenance spares wcap","INR",null,{"$f":"E9*Workingcapital_spares","v":919650},954964.56,991635.199104,1029713.9907495936,1069255.007994378,1110314.4003013622,1152950.4732729346,1197223.7714466152,1243197.1642701651,1290935.9353781394,1340507.87529666,1391983.3777080516,1445435.5394120407,1500940.2641254633,1558576.3702678811,1618425.7028861677,1680573.2498769965,1745107.2626722732,1812119.3815588884,1881704.7658107497,1953962.2288178822,2028994.3784044888,2106907.7625352214,2187813.0206165737,2271825.0406082501,2359063.1221676068,2449651.146058843,2543717.7500675027,2641396.5116700944,2742826.1377182263,2848150.661406606,2957519.6468046196,3071088.4012419172,3189018.1958496063,3311476.4945702315,{"$f":"AN9*Workingcapital_spares","v":3438637.1919617285},3570680.8601330589,3707795.0051621678,3850174.3333603954,3998021.0277614347,4151545.0352274738,4310964.3645802094,4476505.3961800896,4648403.2033934044,4826901.8864037115,5012254.9188416135,5204725.5077251317,5404586.967221776,5612123.1067630928,5827628.634062795]
[null,"Interest on O&M wcap","INR",null,{"$f":"(E32+E33)*Interest_working_capital","v":159794.29666666666},165930.39765866665,172302.12492875947,178918.52652602381,185788.99794462314,192923.29546569666,200331.55001157944,208024.28153202406,216012.41394285377,224307.29063825938,232920.69059876853,241864.8451177612,251152.45517028327,260796.70944882213,270811.30309165694,281210.4571303766,292008.938684183,303222.08192965563,314865.80987575435,326956.65697498334,339511.79260282265,352549.04543877108,366086.92878361989,380144.66684891086,394742.22205590899,409900.32338285598,425640.49580075761,441985.09083950671,458957.31832774373,476581.27935152914,494882.00047862786,513885.46929700713,533618.67131801229,554109.62829662382,575387.43802321423,{"$f":"(AN32+AN33)*Interest_working_capital","v":597482.31564330566},620425.63656400854,644249.98100806645,668989.18027877621,694678.36480148125,721354.01400985813,749054.00814783678,777817.68206071376,807685.88105184503,838701.01888423588,870907.13800939056,904349.97210895119,939077.0110379348,975137.56826179149,1012582.8508830443]
[null,"Fuel cost wcap","INR",null,{"$f":"IF(Technology=\"Biomass\",E16/(12/Bio_workingcapital_fuel),0)","v":10650495.6},10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,{"$f":"IF(Technology=\"Biomass\",AK16/(12/Bio_workingcapital_fuel),0)","v":10650495.6},10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6,10650495.6]
[null,"Receivables wcap","INR",null,{"$f":"IF(Workingcapital_receivables>0, (E9+E10+E12+E13+E15+E34)/(12/Workingcapital_receivables),0)","v":2571528.5370833334},2601724.3497073334,2579532.0565360952,2558543.8081070809,2538805.8397383932,2520366.1621843474,2503274.6298122262,2487583.0113970158,2473345.063634661,2460616.6074782321,2449455.6074053957,2439922.2537297634,2432079.0480729863,2425990.8921189886,2421725.179776358,2123095.6428797701,2176235.0755663537,2231415.0624681013,2288713.9608668764,2348213.1369641642,2409997.0814235881,2474153.5293502538,2540773.5848773038,2609951.8505365918,2681786.5615971969,2756379.7255625296,2833837.2670241306,2914269.178077857,2997789.6745160469,3084517.3580174632,3174575.3845653338,3268091.6393326423,3365198.918283016,3466035.1167450836,3570743.4252280947,{"$f":"IF(Workingcapital_receivables>0, (AN9+AN10+AN12+AN13+AN15+AN34)/(12/Workingcapital_receivables),0)","v":3679472.5327568538},3792376.8380147167,3909616.6685944819,4031358.5086685102,4157775.2354013808,4289046.3644407941,4425358.3048353205,4566904.6237409962,4713886.3212926509,4866512.1160302889,5024998.7412858522,5189571.252951229,5360463.349064556,5537917.701668635,5722186.30141271]
[null,"Interest on reveivables wcap","INR",null,{"$f":"E36*Interest_working_capital","v":287239.73759220832},290612.60986230912,288133.73071508179,285789.34336556093,283584.61229877849,281524.9003159916,279615.77615002566,277863.02237304667,276272.64360799163,274850.87505531852,273604.19134718267,272539.31574161456,271663.22966975253,270983.18264969101,270506.70258101914,237149.78330967031,243085.4579407617,249249.06247768691,255649.34942883009,262295.40739889711,269196.6739950148,276362.94922842336,283804.40943079483,291531.62170493731,299555.55893040687,307887.61534533452,316539.62272659538,325523.86719129659,334853.10664344241,344540.5888905506,354600.07045594777,365045.83611345611,375892.71917221288,387156.1225404258,398852.04059797816,{"$f":"AN36*Interest_working_capital","v":410997.08190894057},423608.49280624383,436704.18188200361,450302.74541827256,464423.49379433424,479086.47890803666,494312.52265010524,510123.24647186924,526541.1020883891,543589.40336058324,561292.35940162966,579675.10895465221,598763.75609051087,618585.40727638651,639168.20986779965]
[]
[null,"Financials"]
[null,"Cash Flow","INR"]
[null,"Equity IRR","%"]
[null,"Cumulative Cash Flow","INR",null,{"$f":"E40","v":0},{"$f":"E42+F40","v":0},{"$f":"F42+G40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AC42+AD40","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AM42+AN40","v":0},{"$f":"AN42+AO40","v":0},{"$f":"AO42+AP40","v":0},{"$f":"AP42+AQ40","v":0},{"$f":"AQ42+AR40","v":0},{"$f":"AR42+AS40","v":0},{"$f":"AS42+AT40","v":0},{"$f":"AT42+AU40","v":0},{"$f":"AU42+AV40","v":0},{"$f":"AV42+AW40","v":0},{"$f":"AW42+AX40","v":0},{"$f":"AX42+AY40","v":0},{"$f":"AY42+AZ40","v":0},{"$f":"AZ42+BA40","v":0},{"$f":"BA42+BB40","v":0}]
[null,"Asset value",null,null,{"$f":"Gross_capex","v":118600000},{"$f":"E43-E11","v":113061380},107522760,101984140,96445520,90906900,85368280,79829660,74291040,68752420,63213800,57675180,52136560,46597940,41059320,35520700,33154630,30788560,28422490,26056420,23690350,21324280,18958210,16592140,14226070,11860000,9493930,7127860,4761790,2395720,29650,-2336420,-4702490,-7068560,-9434630,{"$f":"AM43-AM11","v":-11800700},{"$f":"AN43-AN11","v":-14166770},{"$f":"AO43-AO11","v":-16532840},{"$f":"AP43-AP11","v":-18898910},{"$f":"AQ43-AQ11","v":-21264980},{"$f":"AR43-AR11","v":-23631050},{"$f":"AS43-AS11","v":-25997120},{"$f":"AT43-AT11","v":-28363190},{"$f":"AU43-AU11","v":-30729260},{"$f":"AV43-AV11","v":-33095330},{"$f":"AW43-AW11","v":-35461400},{"$f":"AX43-AX11","v":-37827470},{"$f":"AY43-AY11","v":-40193540},{"$f":"AZ43-AZ11","v":-42559610},{"$f":"BA43-BA11","v":-44925680}]

{"sheet":"RE references","index":4,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[50,1,50,9],[37,1,37,9],[40,1,40,9],[41,1,41,9],[42,1,42,9],[43,1,43,9],[44,1,44,9],[38,1,38,9],[45,1,45,9],[46,1,46,9],[47,1,47,9],[48,1,48,9],[49,1,49,9],[52,1,52,9],[53,1,53,9],[54,1,54,9],[55,1,55,9],[56,1,56,9],[69,1,69,9],[70,1,70,9],[39,1,39,9],[63,1,63,9],[64,1,64,9],[65,1,65,9],[66,1,66,9],[67,1,67,9],[68,1,68,9],[57,1,57,9],[58,1,58,9],[59,1,59,9],[60,1,60,9],[61,1,61,9],[62,1,62,9],[51,1,51,9]]}
[null,"DEFAULT VALUES FOR LCOE"]
[]
[null,"Assumption","Unit","Solar PV1,2,3","Wind4","Biomass","Bagasse cogeneration","Biomass Gasifier-based power projects","Biogas-based power projects","Small Hydro"]
[null,"Capital cost","INR/kW",38000,52500,60550,49200,59300,118600,84000]
[null,"Capital subsidy per kW","INR/kW",null,null,null,2500,15000,30000]
[null,"Plant size","kW",100,1000,1000,1000,1000,1000,1000]
[null,"Economic Life","years",25,25,25,25,25,25,40]
[null,"Capacity utilisation factor (CUF)","%",0.19,0.28999999999999998,0.8,0.53,0.85,0.9,0.3]
[null,"Auxiliary consumption","%",0,0,11,8.5,10,12,1]
[null,"Annual solar PV degradation5","%",1]
[null,"Station heat rate","kCal/kWh",null,null,4162,3600]
[null,"Calorific value ","kCal/kg",null,null,3100,2250]
[null,"Specific fuel consumption","kg/kWh",null,null,{"$f":"F11/F12","v":1.3425806451612903},{"$f":"G11/G12","v":1.6},1.25,3]
[null,"Fuel cost","INR/MT",null,null,3352,2225,3352,1422]
[null,"Fuel cost escalation","%",null,null,0.05,0.05,0.05,0.05]
[null,"Grid availability factor","%",95,95]
[null,"Discount rate","%",8.61,8.61,8.61,8.61,8.61,8.61,8.61]
[null,"Equity","%",30,30,30,30,null,null,30]
[null,"Loan tenure","years",15,15,15,15,15,15,15]
[null,"Moratorium","years",1,1,1,1,1,1,1]
[null,"Interest on loan","%",9.67,9.67,9.67,9.67,9.67,9.67,9.67]
[null,"Interest on Working Capital","%",11.17,11.17,11.17,11.17,11.17,11.17,11.17]
[null,"Return on Equity7","%",15.6,15.6,15.6,15.6,15.6,15.6,15.6]
[null,"Operation and Maintenance Expenses in year 1","INR/kW-yr",600,500,4642,2452,6131,6131,2902]
[null,"Annual increase in Operation and Maintenance Expenses","%",3.84,3.84,3.84,3.84,3.84,3.84,3.84]
[null,"Insurance (% of depreciated asset value)","%",0.35,0.25,null,null,null,null,0.35]
[null,"Working capital – O&M","months",1,1,1,1,1,1,1]
[null,"Working capital – Receivables","months",1.5,1.5,1.5,1.5,1.5,1.5,1.5]
[null,"Working capital – Fuel","months",null,null,4,4,4,4]
[null,"Working capital – Maintenance spares","%",0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[null,"n1 years","%",15,15,15,15,15,15,15]
[null,"Depreciation Rate for first n1 years","%",4.67,4.67,4.67,4.67,4.67,4.67,4.67]
[null,"Salvage value","%",10,10,10,10,10,10,10]
[]
[]
[null,"REFERENCES"]
[]
[null,"1. Ministry of New & Renewable Energy (MNRE). (2020). Benchmark Costs for Grid-Connected Rooftop Solar Photovoltaic for the Financial Years 2020-21. https://mnre.gov.in/img/documents/uploads/file_f-1595328067505.pdf"]
[null,"2. Tamil Nadu Electricity Regulatory Commission (TNERC). (2018). Order on generic tariff for solar power and related issues. http://www.tnerc.gov.in/orders/Tariff%20Order%202009/2019/Solar-5-29-03-2019.pdf"]
[null,"3. Karnataka Electricity Regulatory Commission (KERC). (2019). Determination of tariff in respect of Solar Power Projects (including Solar Rooftop Photo voltaic Projects) for FY20. https://karunadu.karnataka.gov.in/kerc/Documents/Determination%20of%20tariff%20in%20respect%20of%20SOlar%20Power%20Projects%20(including%20Solar%20Rooftop%20Photovoltaic%20Projects%20for%20FY20.pdf"]
[null,"4. Tamil Nadu Electricity Regulatory Commission. (2018). Order on generic tariff for wind power and related issues. http://www.tnerc.gov.in/orders/Tariff%20Order%202009/2018/Wind-6of2018.pdf"]
[null,"5. Lawrence Berkeley National Lab (LBNL). (2020). Distributed Solar 2020 Data Update. Available at: https://emp.lbl.gov/tracking-the-sun/"]
[null,"6. Central Electricity Regulatory Commission (CERC). (2021). Determination of levellised generic tariff for FY 2020-21 under Regulation 8 of the Central Electricity Regulatory Commission (Terms and Conditions for Tariff determination from Renewable Energy Sources) Regulations, 2020. http://www.cercind.gov.in/2020/orders/13-SM-2020.pdf"]
[null,"7. Center for Energy Regulation. (2020). CERC (Terms and Conditions for Tariff determination from Renewable Energy Sources) Regulations, 2020 [Draft]. Regulatory Insights, 3(1), 2-3. https://cer.iitk.ac.in/newsletters/regulatory_insights/Volume03_Issue01.pdf"]

{"sheet":"LCOS - Inputs & Results","index":5,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[[7,2,7,4],[7,9,7,11]]}
[null,"Assumed configuration for the solar plus energy storage system: DC-coupled"]
[]
[null,null,null,"SELECT CONFIGURATION:"]
[]
[]
[]
[]
[null,null,"INPUTS",null,null,null,null,"Standalone",null,"SYSTEM SIZE & OUTPUTS"]
[null,null,"Parameter","Unit","Value",null,null,null,null,"Parameter","Unit","Value"]
[]
[null,null,"General inputs"]
[null,null,"Base year for LCOS calculation","year",2020,null,null,null,null,"Solar PV size","kW",{"$f":"SolarPV_size","v":0}]
[null,null,"Battery technology",null,"Li-ion",null,null,null,null,"Inverter capacity","kW",{"$f":"Storage_inverter_capacity","v":12}]
[null,null,"Discount rate","%",8.6099999999999996E-2,null,null,null,null,"Battery capacity","kWh",{"$f":"Storage_power_capacity*Storage_duration","v":48}]
[null,null,"Equity","%",0.3,null,null,null,null,"Storage duration (E to P ratio) at 100% DoD","hr",{"$f":"Storage_duration","v":4}]
[null,null,"Return on Equity","%",0.156,null,null,null,null,"Battery life","years",{"$f":"ROUND(Storage_life_cycles/Storage_annual_cycles,0)","v":9}]
[null,null,"Loan tenure","years",15,null,null,null,null,"Solar generated passing through battery (Year 1)","%",{"$f":"IF(H8=\"Standalone\", \"-\", IF('LCOS calc'!E98/Storage_roundtripefficiency>='LCOS calc'!E97*(1-Storage_solar_directconsumption), (1-Storage_solar_directconsumption), 'LCOS calc'!E100))","v":"-"}]
[null,null,"Moratorium","years",1,null,null,null,null,"Solar exported (Year 1)","%",{"$f":"IF(H8=\"Standalone\", \"-\", IF('LCOS calc'!E98/Storage_roundtripefficiency>='LCOS calc'!E97*(1-Storage_solar_directconsumption), 0, (1-Storage_solar_directconsumption-'LCOS calc'!E100)))","v":"-"}]
[null,null,"Interest on loan","%",9.6699999999999994E-2,null,null,null,null,"Net capital cost","INR",{"$f":"Storage_pack_capexperkWh*(1-Storage_capitalsubsidy_percentage)*Storage_capacity+Storage_invertercapex_perkW*Storage_inverter_capacity+Storage_enclosure_capexperkWh*Storage_capacity+Storage_installation_cost+(SolarPV_capex_perkW*(1-SolarPV_capex_inverterpercentage*(1+Storage_inverter_GST))-SolarPV_capitalsubsidy_perkW)*SolarPV_size","v":971160}]
[null,null,"Annual increase in Operation and Maintenance expenses","%",3.8399999999999997E-2,null,null,null,null,"Equity","INR",{"$f":"Storage_net_capex*Storage_equity_percentage","v":291348}]
[null,null,"Insurance (% of depreciated asset value)","%",0,null,null,null,null,"Debt","INR",{"$f":"Storage_net_capex-Storage_equity","v":679812}]
[null,null,"Working Capital - O&M","months",1,null,null,null,null,"Annual Depreciation","INR",{"$f":"Storage_pack_capexperkWh*(1-Storage_capitalsubsidy_percentage)*Storage_capacity*Storage_depreciationrate_storage     +      Storage_invertercapex_perkW*Storage_inverter_capacity*Storage_depreciationrate_inverter                                                                  +Storage_enclosure_capexperkWh*Storage_capacity*Storage_depreciationrate_storage                                                                                          +Storage_installation_cost*Storage_depreciationrate_storage                                                                                                                            +(SolarPV_capex_perkW*(1-SolarPV_capex_inverterpercentage*(1+Storage_inverter_GST))-SolarPV_capitalsubsidy_perkW)*SolarPV_size*Storage_solarPV_depreciationrate","v":95454.461538461532}]
[null,null,"Working Capital - Receivables","months",1.5]
[null,null,"Working capital - Maintenance spares","%",0.15]
[null,null,"Interest on Working Capital","%",0.11169999999999999]
[null,null,"Salvage value at end of life","%",0.1]
[null,null,"Charge controller efficiency","%",0]
[]
[null,null,"Solar PV capital costs and inputs"]
[null,null,"Solar PV capital cost per kW","INR/kW",0]
[null,null,"Solar panel cost in total capital cost","%",0.49,null,null,null,null,0.5]
[null,null,"Inverter cost % in total capital cost","%",0.16]
[null,null,"BoS (excl solar inverter) cost % in total capital cost","%",0.2,null,null,null,null,"By changing:"]
[null,null,"Installation cost % in total capital cost","%",6.8000000000000005E-2,null,null,null,null,"SolarPV_size"]
[null,null,"Soft costs (taxes) % in total capital cost","%",8.2000000000000003E-2]
[null,null,"Capital subsidy per kW","INR",0]
[null,null,"Solar PV size","kW",0]
[null,null,"Plant life","years",25]
[null,null,"Capacity utilisation factor (CUF)","%",0.19]
[null,null,"Operation and Maintenance expenses in Year 1","INR/kW-yr",600]
[null,null,"n1 years","years",15]
[null,null,"Depreciation rate","%",4.65E-2]
[null,null,"Annual solar panel degradation","%",0.01]
[null,null,"Solar generation self-consumed directly","%",0.35]
[]
[null,null,"Inverter-specific inputs"]
[null,null,"Inverter capital cost per kW","INR/kW",4500]
[null,null,"Additional soft costs (GST)","%",0.05]
[null,null,"Inverter capacity","kW",{"$f":"IF(Storage_case = \"Solar+Storage\", SolarPV_size/1.2, Storage_power_capacity)","v":12}]
[null,null,"Inverter efficiency","%",0.96]
[null,null,"Inverter replacement year","years",14]
[null,null,"O&M expenses in Year 1 - Power","INR/kW-yr",750]
[null,null,"Depreciation rate","%",{"$f":"(1-Storage_salvage_value)/(Storage_inverter_replacementyear-1)","v":6.9230769230769235E-2}]
[]
[null,null,"Battery storage-specific inputs"]
[null,null,"Battery pack capital cost per kWh","INR/kWh",17900]
[null,null,"Cost for enclosure and BoS","INR/kWh",895]
[null,null,"Capital subsidy per kWh","%",0]
[null,null,"Installation cost","INR",15000]
[null,null,"Additional soft costs (GST on battery system)","%",0.05]
[null,null,"Additional soft costs (GST on installation)","%",0.18]
[null,null,"Battery power capacity","kW",12]
[null,null,"Storage duration (E to P ratio) at 100% DoD","hr",4]
[null,null,"Storage round trip efficiency","%",0.97]
[null,null,"Depth of Discharge","%",0.8]
[null,null,"Storage cycles per year at given DoD","cycles",365]
[null,null,"End of life capacity relative to initial capacity","%",0.8]
[null,null,"Storage cycle life","cycles",3175]
[null,null,"Storage shelf life","years",13]
[null,null,"Cycle degradation","%",5.5999999999999999E-5]
[null,null,"Time degradation","%",1.7000000000000001E-2]
[null,null,"O&M expenses in Year 1 - Energy","INR/kWh-yr",400]
[null,null,"Depreciation rate","%",{"$f":"(1-Storage_salvage_value)/Storage_life","v":0.1}]
[null,null,"Electricity tariff for charging battery","INR/kWh",6.6]
[null,null,"Cost escalation for input electricty ","%",3.8399999999999997E-2]

{"sheet":"LCOS calc","index":6,"n_rows":113,"n_cols":29,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["This sheet contains the LCOS calculations."]
[null,null,null,null,null,null,null,null,null,"Year ----->"]
[null,"Parameter","Unit","Cumulative",1,{"$f":"E3+1","v":2},{"$f":"F3+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[]
[null,"Storage cost timeline"]
[null,"Year",null,null,{"$f":"Storage_base_year","v":2020},{"$f":"E6+1","v":2021},{"$f":"F6+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044]
[null,"Storage operation year",null,null,{"$f":"IF(MOD(E3,Storage_life)=0, Storage_life, MOD(E3,Storage_life))","v":1},2,3,4,5,6,7,8,9,1,2,3,4,5,6,7,8,9,1,2,3,4,5,6,7]
[null,"Battery pack cost per kWh in year n","INR",null,{"$f":"IF(E7=1, (Storage_pack_capexperkWh*VLOOKUP(E6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":17900},{"$f":"IF(F7=1, (Storage_pack_capexperkWh*VLOOKUP(F6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(G7=1, (Storage_pack_capexperkWh*VLOOKUP(G6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(H7=1, (Storage_pack_capexperkWh*VLOOKUP(H6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(I7=1, (Storage_pack_capexperkWh*VLOOKUP(I6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(J7=1, (Storage_pack_capexperkWh*VLOOKUP(J6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(K7=1, (Storage_pack_capexperkWh*VLOOKUP(K6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(L7=1, (Storage_pack_capexperkWh*VLOOKUP(L6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(M7=1, (Storage_pack_capexperkWh*VLOOKUP(M6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(N7=1, (Storage_pack_capexperkWh*VLOOKUP(N6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":7400.3891652699303},{"$f":"IF(O7=1, (Storage_pack_capexperkWh*VLOOKUP(O6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(P7=1, (Storage_pack_capexperkWh*VLOOKUP(P6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(Q7=1, (Storage_pack_capexperkWh*VLOOKUP(Q6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(R7=1, (Storage_pack_capexperkWh*VLOOKUP(R6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(S7=1, (Storage_pack_capexperkWh*VLOOKUP(S6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(T7=1, (Storage_pack_capexperkWh*VLOOKUP(T6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(U7=1, (Storage_pack_capexperkWh*VLOOKUP(U6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(V7=1, (Storage_pack_capexperkWh*VLOOKUP(V6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(W7=1, (Storage_pack_capexperkWh*VLOOKUP(W6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":5187.1699681759219},{"$f":"IF(X7=1, (Storage_pack_capexperkWh*VLOOKUP(X6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(Y7=1, (Storage_pack_capexperkWh*VLOOKUP(Y6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(Z7=1, (Storage_pack_capexperkWh*VLOOKUP(Z6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(AA7=1, (Storage_pack_capexperkWh*VLOOKUP(AA6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(AB7=1, (Storage_pack_capexperkWh*VLOOKUP(AB6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0},{"$f":"IF(AC7=1, (Storage_pack_capexperkWh*VLOOKUP(AC6, 'Cost projections'!$C$10:$D$55, 2)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$10:$D$55, 2)), 0)","v":0}]
[null,"Gross capital cost","INR",null,{"$f":"IF(E7=1, (E8*Storage_capacity+Storage_enclosure_capexperkWh*Storage_capacity)*(1+Storage_system_GST)+Storage_installation_cost*(1+Storage_installation_GST), 0)","v":964968},0,0,0,0,0,0,0,0,435787.61392960447,0,0,0,0,0,0,0,0,324241.3663960665,0,0,0,0,0,0]
[null,"Net capital cost","INR",null,{"$f":"IF(E7=1, (E8*Storage_capacity+Storage_enclosure_capexperkWh*Storage_capacity)*(1-Storage_capitalsubsidy_percentage)*(1+Storage_system_GST)+Storage_installation_cost*(1+Storage_installation_GST), 0)","v":964968},0,0,0,0,0,0,0,0,435787.61392960447,0,0,0,0,0,0,0,0,324241.3663960665,0,0,0,0,0,0]
[null,"Equity","INR",null,{"$f":"E10*Storage_equity_percentage","v":289490.39999999997},0,0,0,0,0,0,0,0,130736.28417888134,0,0,0,0,0,0,0,0,97272.409918819947,0,0,0,0,0,0]
[null,"Debt","INR",null,{"$f":"E10-E11","v":675477.60000000009},{"$f":"F10-F11","v":0},0,0,0,0,0,0,0,305051.32975072315,0,0,0,0,0,0,0,0,226968.95647724654,0,0,0,0,0,0]
[null,"Annual depreciation (on gross capital cost)","INR",null,{"$f":" IF(E7=1, E9*Storage_depreciationrate_storage,#REF!)","v":96496.8},{"$f":"IF(F7=1, F9*Storage_depreciationrate_storage, E13)","v":96496.8},96496.8,96496.8,96496.8,96496.8,96496.8,96496.8,96496.8,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,32424.136639606651,32424.136639606651,32424.136639606651,32424.136639606651,32424.136639606651,32424.136639606651,32424.136639606651]
[null,"Annual depreciation (on net capital cost)","INR",null,{"$f":" IF(E7=1, E10*Storage_depreciationrate_storage,#REF!)","v":96496.8},{"$f":"IF(F7=1, F10*Storage_depreciationrate_storage, E14)","v":96496.8},96496.8,96496.8,96496.8,96496.8,96496.8,96496.8,96496.8,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,43578.761392960449,32424.136639606651,32424.136639606651,32424.136639606651,32424.136639606651,32424.136639606651,32424.136639606651,32424.136639606651]
[null,"Asset value","INR",null,{"$f":"IF(E7=1, E9,#REF! -#REF!)","v":964968},{"$f":"IF(F7=1, F9, E15-E13)","v":868471.2},{"$f":"IF(G7=1, G9, F15-F13)","v":771974.39999999991},675477.59999999986,578980.79999999981,482483.99999999983,385987.19999999984,289490.39999999985,192993.59999999986,435787.61392960447,392208.85253664403,348630.09114368359,305051.32975072315,261472.56835776271,217893.80696480226,174315.04557184182,130736.28417888138,87157.522785920941,324241.3663960665,291817.22975645983,259393.09311685318,226968.95647724654,194544.81983763989,162120.68319803325,129696.54655842661]
[null,"Operation and Maintenance Expenses","INR",null,{"$f":"IF(E3=1,Storage_capacity*Storage_OndMenergy_year1,#REF!+(#REF!* Storage_OandM_escalation))","v":19200},{"$f":"IF(F3=1,Storage_capacity*Storage_OndMenergy_year1, E16+(E16*Storage_OandM_escalation))","v":19937.28},20702.871551999997,21497.861819596797,22323.379713469316,23180.597494466536,24070.73243825405,24995.048563883007,25954.858428736115,26951.524992399583,27986.463552107729,29061.143752508666,30177.091672604998,31335.891992833029,32539.190245357819,33788.69515077956,35086.181044569494,36433.490396680965,37832.536427913517,39285.305826745396,40793.861570492416,42360.345854799321,43986.983135623617,45676.083288031565,47430.044886291973]
[null,"Insurance","INR",null,{"$f":"Storage_insurance*E15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on Term Loan","INR",null,{"$f":"E26","v":65318.683920000003},{"$f":"F26","v":65318.683920000003},57153.848430000013,48989.012940000008,40824.17745000001,32659.341960000009,24494.506470000008,16329.670980000006,8164.8354900000058,29498.463586894926,29498.463586894926,25811.155638533059,22123.847690171195,18436.539741809327,14749.231793447461,11061.923845085594,7374.615896723727,3687.3079483618617,21947.89809134974,21947.89809134974,19204.410829931021,16460.923568512306,13717.436307093589,10973.949045674872,8230.4617842561565]
[null,"Interest on Working Capital","INR",null,{"$f":"E32+E34","v":3665.385267393},{"$f":"F32+F34","v":3695.1638168355594},3612.0843470475893,3530.192283816079,3449.5332235527972,3370.1545135717238,3292.1053193236944,3215.4366942128604,3140.2016520940883,2393.6691489597351,2435.4700510190355,2427.3920704884099,2420.9808825350024,2416.3004919937775,2413.4173614853635,2412.4005057950199,2413.3215898757608,2416.2550306147964,2499.0898437700198,2557.7668258823155,2580.3910632201641,2605.3550194018685,2632.7485396310331,2662.6649191670795,2695.2010358073921]
[null,"Return on Equity","INR",null,{"$f":"OFFSET(E11,0,1-E7)*Storage_ROE","v":45160.502399999998},45160.502399999998,45160.502399999998,45160.502399999998,45160.502399999998,45160.502399999998,45160.502399999998,45160.502399999998,45160.502399999998,20394.860331905489,20394.860331905489,20394.860331905489,20394.860331905489,20394.860331905489,20394.860331905489,20394.860331905489,20394.860331905489,20394.860331905489,15174.495947335912,15174.495947335912,15174.495947335912,15174.495947335912,15174.495947335912,15174.495947335912,15174.495947335912]
[]
[null,"Debt"]
[null,"Debt opening balance","INR",null,{"$f":" IF(E7=1, E12,#REF!)","v":675477.60000000009},{"$f":"IF(F7=1, F12, E25)","v":675477.60000000009},591042.90000000014,506608.20000000013,422173.50000000012,337738.8000000001,253304.10000000009,168869.40000000008,84434.70000000007,305051.32975072315,305051.32975072315,266919.91353188275,228788.49731304235,190657.08109420195,152525.66487536154,114394.24865652114,76262.832437680743,38131.41621884035,226968.95647724654,226968.95647724654,198597.83691759073,170226.71735793492,141855.59779827911,113484.4782386233,85113.358678967488]
[null,"Debt repayment","INR",null,{"$f":"IF(E7>Storage_moratorium, IF(E23>0, OFFSET(E12,0,1-E7)/(Storage_life-Storage_moratorium), 0), 0)","v":0},84434.700000000012,84434.700000000012,84434.700000000012,84434.700000000012,84434.700000000012,84434.700000000012,84434.700000000012,84434.700000000012,0,38131.416218840393,38131.416218840393,38131.416218840393,38131.416218840393,38131.416218840393,38131.416218840393,38131.416218840393,38131.416218840393,0,28371.119559655817,28371.119559655817,28371.119559655817,28371.119559655817,28371.119559655817,28371.119559655817]
[null,"Debt closing balance","INR",null,{"$f":"E23-E24","v":675477.60000000009},{"$f":"F23-F24","v":591042.90000000014},{"$f":"G23-G24","v":506608.20000000013},{"$f":"H23-H24","v":422173.50000000012},337738.8000000001,253304.10000000009,168869.40000000008,84434.70000000007,0,305051.32975072315,266919.91353188275,228788.49731304235,190657.08109420195,152525.66487536154,114394.24865652114,76262.832437680743,38131.41621884035,0,226968.95647724654,198597.83691759073,170226.71735793492,141855.59779827911,113484.4782386233,85113.358678967488,56742.239119311671]
[null,"Interest","INR",null,{"$f":"Storage_interest*E23","v":65318.683920000003},65318.683920000003,57153.848430000013,48989.012940000008,40824.17745000001,32659.341960000009,24494.506470000008,16329.670980000006,8164.8354900000058,29498.463586894926,29498.463586894926,25811.155638533059,22123.847690171195,18436.539741809327,14749.231793447461,11061.923845085594,7374.615896723727,3687.3079483618617,21947.89809134974,21947.89809134974,19204.410829931021,16460.923568512306,13717.436307093589,10973.949045674872,8230.4617842561565]
[null,"Total debt service","INR",null,{"$f":"E24+E26","v":65318.683920000003},{"$f":"F24+F26","v":149753.38392000002},141588.54843000002,133423.71294000003,125258.87745000003,117094.04196000002,108929.20647000002,100764.37098000002,92599.535490000024,29498.463586894926,67629.879805735312,63942.571857373448,60255.263909011584,56567.955960649721,52880.648012287857,49193.340063925985,45506.032115564121,41818.724167202257,21947.89809134974,50319.017651005561,47575.530389586842,44832.043128168123,42088.555866749404,39345.068605330685,36601.581343911974]
[]
[null,"Working Capital"]
[null,"Operation and Maintenance wcap","INR",null,{"$f":"E16/(12/Storage_workingcapital_OandM)","v":1600},1661.4399999999998,1725.2392959999997,1791.4884849663997,1860.2816427891096,1931.7164578722113,2005.8943698545042,2082.9207136569171,2162.9048690613431,2245.9604160332988,2332.2052960089773,2421.7619793757221,2514.7576393837498,2611.3243327360856,2711.5991871131514,2815.7245958982967,2923.8484203807911,3036.1241997234138,3152.7113689927933,3273.7754855621165,3399.4884642077013,3530.0288212332766,3665.5819279686348,3806.3402740026304,3952.5037405243311]
[null,"Maintenance spares wcap","INR",null,{"$f":"E16*Storage_workingcapital_spares","v":2880},2990.5919999999996,3105.4307327999995,3224.6792729395197,3348.5069570203973,3477.0896241699802,3610.6098657381076,3749.2572845824507,3893.2287643104173,4042.7287488599372,4197.9695328161588,4359.1715628762995,4526.5637508907494,4700.3837989249541,4880.8785368036724,5068.3042726169342,5262.9271566854241,5465.023559502145,5674.8804641870274,5892.7958740118092,6119.0792355738622,6354.0518782198978,6598.047470343542,6851.4124932047343,7114.5067329437961]
[null,"Interest on O&M wcap","INR",null,{"$f":"(E30+E31)*Storage_interest_workingcap","v":500.416},519.63197439999988,539.58584221695992,560.30593855809116,581.82168659872195,604.16363936411278,627.36352311569465,651.45428240333729,676.47012684762569,702.44657971857441,729.42052837976769,757.43027666955072,786.51559929366147,816.71779830653816,848.07976176150908,880.64602461315121,914.46283195829619,949.57820470549473,986.04200776618586,1023.9060208644074,1063.2240120656006,1104.0518141289194,1146.4474037914699,1190.4709840970627,1236.1850698863896]
[null,"Receivables wcap","INR",null,{"$f":"IF(Storage_workingcapital_receivables>0, (E16+E17+E14+E18+E20+E32)/(12/Storage_workingcapital_receivables),0)","v":28334.550289999999},28429.112286799998,27506.701028027121,26588.060387269365,25673.335156258509,24762.675686728835,23856.23810392122,22954.184528285794,22056.683305697967,15140.757110484878,15273.496174031046,14950.418924072152,14632.634585866974,14320.346407226853,14013.76544067909,13713.11084316803,13418.610187264681,13130.499784326785,13545.638639246501,13731.967815737764,13582.51612492895,13440.494228047888,13306.187429181406,13179.891988093257,13061.915540922135]
[null,"Interest on reveivables wcap","INR",null,{"$f":"E33*Storage_interest_workingcap","v":3164.9692673929999},3175.5318424355596,3072.4985048306294,2969.8863452579881,2867.7115369540752,2765.9908742076109,2664.7417962079999,2563.982411809523,2463.7315252464628,1691.2225692411607,1706.0495226392677,1669.9617938188592,1634.4652832413408,1599.5826936872393,1565.3375997238543,1531.7544811818689,1498.8587579174648,1466.6768259093017,1513.0478360038342,1533.8608050179082,1517.1670511545638,1501.3032052729491,1486.3011358395629,1472.1939350700168,1459.0159659210024]
[]
[null,"Inverter cost timeline"]
[null,"Year",null,null,{"$f":"Storage_base_year","v":2020},{"$f":"E37+1","v":2021},{"$f":"F37+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044]
[null,"Inverter operation year",null,null,{"$f":"IF(MOD(E3,Storage_inverter_replacementyear-1)=0, Storage_inverter_replacementyear-1, MOD(E3,Storage_inverter_replacementyear-1))","v":1},2,3,4,5,6,7,8,9,10,11,12,13,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"Inverter capital cost per kWh in year n","INR",null,{"$f":"IF(E38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(E37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":4725},{"$f":"IF(F38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(F37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(G38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(G37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(H38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(H37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(I38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(I37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(J38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(J37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(K38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(K37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(L38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(L37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(M38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(M37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(N38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(N37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(O38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(O37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(P38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(P37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(Q38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(Q37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(R38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(R37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":2120.5331818963637},{"$f":"IF(S38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(S37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(T38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(T37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(U38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(U37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(V38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(V37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(W38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(W37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(X38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(X37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(Y38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(Y37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(Z38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(Z37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(AA38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(AA37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(AB38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(AB37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0},{"$f":"IF(AC38=1, Storage_invertercapex_perkW*(1+Storage_inverter_GST)*VLOOKUP(AC37, 'Cost projections'!$C$114:$E$254, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$C$114:$E$154, 3), 0)","v":0}]
[null,"Capital cost","INR",null,{"$f":"IF(E38=1, Storage_inverter_capacity*E39, 0)","v":56700},0,0,0,0,0,0,0,0,0,0,0,0,25446.398182756362,0,0,0,0,0,0,0,0,0,0,0]
[null,"Equity","INR",null,{"$f":"E40*Storage_equity_percentage","v":17010},0,0,0,0,0,0,0,0,0,0,0,0,7633.9194548269079,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt","INR",null,{"$f":"E40-E41","v":39690},0,0,0,0,0,0,0,0,0,0,0,0,17812.478727929454,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual depreciation","INR",null,{"$f":" IF(E38=1, E40*Storage_depreciationrate_inverter,#REF!)","v":3925.3846153846157},{"$f":"IF(F38=1, F40*Storage_depreciationrate_inverter, E43)","v":3925.3846153846157},3925.3846153846157,3925.3846153846157,3925.3846153846157,3925.3846153846157,3925.3846153846157,3925.3846153846157,3925.3846153846157,3925.3846153846157,3925.3846153846157,3925.3846153846157,3925.3846153846157,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712,1761.6737203446712]
[null,"Asset value","INR",null,{"$f":"IF(E38=1, E40,#REF! -#REF!)","v":56700},{"$f":"IF(F38=1, F40, E44-E43)","v":52774.615384615383},48849.230769230766,44923.846153846149,40998.461538461532,37073.076923076915,33147.692307692298,29222.307692307681,25296.923076923063,21371.538461538446,17446.153846153829,13520.769230769214,9595.3846153845989,25446.398182756362,23684.72446241169,21923.050742067018,20161.377021722346,18399.703301377675,16638.029581033003,14876.355860688331,13114.682140343659,11353.008419998987,9591.334699654315,7829.6609793096441,6067.9872589649731]
[null,"Operation and Maintenance Expenses","INR",null,{"$f":"IF(E3=1,Storage_inverter_capacity*Storage_OandMpower_year1,#REF!+(#REF!* Storage_OandM_escalation))","v":9000},{"$f":"IF(F3=1,Storage_inverter_capacity*Storage_OandMpower_year1, E45+(E45*Storage_OandM_escalation))","v":9345.6},9704.4710400000004,10077.122727936001,10464.084240688744,10865.905075531191,11283.155830431589,11716.429014320163,12166.339888470058,12633.527340187309,13118.654790050501,13622.41113398844,14145.511721533596,14688.699371640487,15252.745427511481,15838.450851927922,16446.647364641954,17078.198623444205,17734.001450584463,18414.987106286906,19122.122611168325,19856.412119437187,20618.898344823574,21410.664041264798,22232.833540449366]
[null,"Insurance","INR",null,{"$f":"Storage_insurance*E44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on term loan","INR",null,{"$f":"E55","v":3838.0229999999997},{"$f":"F55","v":3838.0229999999997},3518.1877499999996,3198.3525,2878.5172499999999,2558.6819999999998,2238.8467499999997,1919.0114999999998,1599.17625,1279.3409999999999,959.50574999999992,639.67049999999995,319.83524999999997,1722.466692990778,1722.466692990778,1578.9278019082133,1435.3889108256485,1291.8500197430835,1148.3111286605188,1004.7722375779539,861.23334649538901,717.69445541282425,574.15556433025938,430.61667324769451,287.07778216512969]
[null,"Interest on working capital","INR",null,{"$f":"E61+E63","v":508.95459395480765},{"$f":"F61+F63","v":522.91328900600763},532.94229826904871,543.52790435543068,554.69148058316966,566.4552210056936,578.84217192808273,591.87626463353149,605.58234936650956,619.98623062087393,635.1147037830458,650.99559318228512,667.65779160209536,658.54791929828593,681.32959432356176,702.98192390306781,725.54266275026998,749.04669378104722,773.5302394152493,799.03091301364748,825.58777229006716,853.24137477454394,882.0338354062676,912.00888633809211,943.2119390375417]
[null,"Return on equity","INR",null,{"$f":"OFFSET(E41,0,1-E38)*Storage_ROE","v":2653.56},2653.56,2653.56,2653.56,2653.56,2653.56,2653.56,2653.56,2653.56,2653.56,2653.56,2653.56,2653.56,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975,1190.8914349529975]
[]
[null,"Debt"]
[null,"Debt opening balance","INR",null,{"$f":"IF(E38=1, E42, D54)","v":39690},39690,36382.5,33075,29767.5,26460,23152.5,19845,16537.5,13230,9922.5,6615,3307.5,17812.478727929454,17812.478727929454,16328.105500602,14843.732273274545,13359.359045947091,11874.985818619636,10390.612591292182,8906.2393639647271,7421.8661366372726,5937.4929093098181,4453.1196819823635,2968.746454654909]
[null,"Debt repayment","INR",null,{"$f":"IF(E38>Storage_moratorium, IF(E52>0, OFFSET(E42,0,1-E38)/(Storage_inverter_replacementyear-1-Moratorium), 0), 0)","v":0},3307.5,3307.5,3307.5,3307.5,3307.5,3307.5,3307.5,3307.5,3307.5,3307.5,3307.5,3307.5,0,1484.3732273274545,1484.3732273274545,1484.3732273274545,1484.3732273274545,1484.3732273274545,1484.3732273274545,1484.3732273274545,1484.3732273274545,1484.3732273274545,1484.3732273274545,1484.3732273274545]
[null,"Debt closing balance","INR",null,{"$f":"E52-E53","v":39690},{"$f":"F52-F53","v":36382.5},{"$f":"G52-G53","v":33075},{"$f":"H52-H53","v":29767.5},26460,23152.5,19845,16537.5,13230,9922.5,6615,3307.5,0,17812.478727929454,16328.105500602,14843.732273274545,13359.359045947091,11874.985818619636,10390.612591292182,8906.2393639647271,7421.8661366372726,5937.4929093098181,4453.1196819823635,2968.746454654909,1484.3732273274545]
[null,"Interest","INR",null,{"$f":"Storage_interest*E52","v":3838.0229999999997},3838.0229999999997,3518.1877499999996,3198.3525,2878.5172499999999,2558.6819999999998,2238.8467499999997,1919.0114999999998,1599.17625,1279.3409999999999,959.50574999999992,639.67049999999995,319.83524999999997,1722.466692990778,1722.466692990778,1578.9278019082133,1435.3889108256485,1291.8500197430835,1148.3111286605188,1004.7722375779539,861.23334649538901,717.69445541282425,574.15556433025938,430.61667324769451,287.07778216512969]
[null,"Total debt service","INR",null,{"$f":"E53+E55","v":3838.0229999999997},{"$f":"F53+F55","v":7145.5229999999992},6825.6877499999991,6505.8525,6186.0172499999999,5866.1819999999998,5546.3467499999997,5226.5114999999996,4906.6762500000004,4586.8410000000003,4267.0057500000003,3947.1705000000002,3627.3352500000001,1722.466692990778,3206.8399203182325,3063.3010292356676,2919.762138153103,2776.223247070538,2632.6843559879735,2489.1454649054085,2345.6065738228435,2202.0676827402785,2058.528791657714,1914.989900575149,1771.4510094925843]
[]
[null,"Working Capital"]
[null,"Operation and Maintenance wcap","INR",null,{"$f":"E45/(12/Storage_workingcapital_OandM)","v":750},778.80000000000007,808.70591999999999,839.76022732800004,872.00702005739538,905.49208962759928,940.26298586929909,976.36908452668024,1013.8616573725049,1052.7939450156091,1093.2212325042085,1135.2009278323701,1178.7926434611329,1224.0582809700406,1271.06211895929,1319.8709043273268,1370.5539470534961,1423.1832186203503,1477.8334542153718,1534.5822588572421,1593.5102175973605,1654.7010099530989,1718.2415287352978,1784.2220034387331,1852.7361283707805]
[null,"Maintenance spares wcap","INR",null,{"$f":"E45*Storage_workingcapital_spares","v":1350},1401.84,1455.670656,1511.5684091904002,1569.6126361033116,1629.8857613296786,1692.4733745647384,1757.4643521480245,1824.9509832705087,1895.0291010280962,1967.798218507575,2043.3616700982659,2121.8267582300391,2203.304905746073,2287.9118141267222,2375.7676277891883,2466.9971046962933,2561.7297935166307,2660.1002175876692,2762.2480659430357,2868.3183916752487,2978.4618179155782,3092.8347517235361,3211.5996061897195,3334.9250310674047]
[null,"Interest on O&M wcap","INR",null,{"$f":"(E59+E60)*Storage_interest_workingcap","v":234.57},243.57748799999996,252.9308635392,262.64340869910529,272.72891559315099,283.20170595192792,294.07665146048197,305.36919487656451,317.0953719598246,329.27183424308186,341.91587267801623,355.04544218885201,368.67918716890392,382.83646795618989,397.53738832570752,412.80282403741472,428.65445248045148,445.11478345570072,462.20719114039963,479.95594728019097,498.38625565575046,517.52428787293115,537.39722052725176,558.03327379549808,579.46175150924523]
[null,"Receivables wcap","INR",null,{"$f":"IF(Storage_workingcapital_receivables>0, (E45+E46+E43+E47+E49+E61)/(12/Storage_workingcapital_receivables),0)","v":2456.4422019230769},2500.7681379230771,2506.8167836154771,2514.6329065024656,2524.284377708314,2535.8416746084667,2549.3779809095859,2564.9692905726679,2582.6945157268124,2602.6355987268762,2624.8776285141416,2649.508961445239,2676.62134676089,2468.3209609856403,2540.6643330157049,2597.8433291464025,2657.9069854057157,2720.9660727425826,2787.1356157103814,2856.5350558053401,2929.2884210771417,3005.5245022525764,3085.3770356223445,3168.9848929507079,3256.4922786776765]
[null,"Interest on reveivables wcap","INR",null,{"$f":"E62*Storage_interest_workingcap","v":274.38459395480766},279.33580100600767,280.01143472984876,280.88449565632538,281.96256499001868,283.25351505376574,284.76552046760071,286.50706975696698,288.4869774066849,290.71439637779207,293.19883110502963,295.95015099343317,298.97860443319138,275.71145134209598,283.79220599785424,290.17909986565314,296.88821026981844,303.93191032534645,311.32304827484961,319.07496573345645,327.2015166343167,335.71708690161279,344.63661487901584,353.97561254259404,363.75018752829646]
[]
[null,"Solar PV cost timeline"]
[null,"Year",null,null,{"$f":"Storage_base_year","v":2020},{"$f":"E66+1","v":2021},{"$f":"F66+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044]
[null,"Solar operation year",null,null,{"$f":"IF(MOD(E3,SolarPV_plant_life)=0, SolarPV_plant_life, MOD(E3,SolarPV_plant_life))","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,"Solar PV capital cost per kWh in year n","INR",null,{"$f":"IF(E67=1, SolarPV_capex_perkW*(1-SolarPV_capex_inverterpercentage*(1+Storage_inverter_GST)), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gross capital cost","INR",null,{"$f":"IF(E67=1, SolarPV_size*E68, 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Net capital cost","INR",null,{"$f":"IF(E67=1, SolarPV_size*(E68-SolarPV_capitalsubsidy_perkW), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Equity","INR",null,{"$f":"E70*Storage_equity_percentage","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt","INR",null,{"$f":"E70-E71","v":0},{"$f":"F70-F71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual depreciation (on gross capital cost)","INR",null,{"$f":"IF(E67<=SolarPV_n1_years, $E$69*Storage_solarPV_depreciationrate, $E$69*(1-Storage_salvage_value-Storage_solarPV_depreciationrate*SolarPV_n1_years)/(SolarPV_plant_life-SolarPV_n1_years))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual depreciation (on net capital cost)","INR",null,{"$f":"IF(E67<=SolarPV_n1_years, $E$70*Storage_solarPV_depreciationrate, $E$70*(1-Storage_salvage_value-Storage_solarPV_depreciationrate*SolarPV_n1_years)/(SolarPV_plant_life-SolarPV_n1_years))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Asset value","INR",null,{"$f":"IF(E67=1, E69,#REF! -#REF!)","v":0},{"$f":"IF(F67=1, F69, E75-E73)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operation and Maintenance Expenses","INR",null,{"$f":"IF(E3=1,SolarPV_size*SolarPV_OandM_year1,#REF!+(#REF!* Storage_OandM_escalation))","v":0},{"$f":"IF(F3=1,SolarPV_size*SolarPV_OandM_year1, E76+(E76*Storage_OandM_escalation))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Insurance","INR",null,{"$f":"Storage_insurance*E75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on term loan","INR",null,{"$f":"E86","v":0},{"$f":"F86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on working capital","INR",null,{"$f":"E92+E94","v":0},{"$f":"F92+F94","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Return on equity","INR",null,{"$f":"OFFSET(E71,0,1-E67)*Storage_ROE","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Debt"]
[null,"Debt opening balance","INR",null,{"$f":" IF(E67=1, E72,#REF!)","v":0},{"$f":"IF(F67=1, F72, E85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt repayment","INR",null,{"$f":"IF(E67>Storage_moratorium, IF(E83>0, OFFSET(E72,0,1-E67)/(Storage_loan_tenure-Storage_moratorium), 0), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt closing balance","INR",null,{"$f":"E83-E84","v":0},{"$f":"F83-F84","v":0},{"$f":"G83-G84","v":0},{"$f":"H83-H84","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest","INR",null,{"$f":"Storage_interest*E83","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total debt service","INR",null,{"$f":"E84+E86","v":0},{"$f":"F84+F86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Working Capital"]
[null,"Operation and Maintenance wcap","INR",null,{"$f":"E76/(12/Storage_workingcapital_OandM)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance spares wcap","INR",null,{"$f":"E76*Storage_workingcapital_spares","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on O&M wcap","INR",null,{"$f":"(E90+E91)*Storage_interest_workingcap","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Receivables wcap","INR",null,{"$f":"IF(Storage_workingcapital_receivables>0, (E76+E77+E74+E78+E80+E92)/(12/Storage_workingcapital_receivables),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on reveivables wcap","INR",null,{"$f":"E93*Storage_interest_workingcap","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Cost of Generation"]
[null,"Solar PV generation","kWh",null,{"$f":"SolarPV_size*24*365*SolarPV_CUF*Storage_chargecontroller_efficiency*(1-Storage_solarPV_degradation)^(E3-1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Energy available from battery storage","kWh",null,{"$f":"Storage_capacity*Storage_DoD*Storage_annual_cycles*(1-Storage_cycle_degradation)^((E7-1)*Storage_annual_cycles)*(1-Storage_time_degradation)^(E7-1)*Storage_roundtripefficiency*Storage_inverter_efficiency","v":13051.699200000001},12570.233532790546,12106.528709219094,11659.929547435275,11229.805034669062,10815.547435654751,10416.571433944337,10032.313304897129,9662.2301191770202,13051.699200000001,12570.233532790546,12106.528709219094,11659.929547435275,11229.805034669062,10815.547435654751,10416.571433944337,10032.313304897129,9662.2301191770202,13051.699200000001,12570.233532790546,12106.528709219094,11659.929547435275,11229.805034669062,10815.547435654751,10416.571433944337]
[null,"Total energy available","kWh",null,{"$f":"E97-E98*(1/Storage_roundtripefficiency-1)","v":-403.66080000000147},-388.7701092615647,-374.42872296554032,-360.61637775573143,-347.31355777327121,-334.5014670821069,-322.16200311168166,-310.27773107929374,-298.83185935599141,-403.66080000000147,-388.7701092615647,-374.42872296554032,-360.61637775573143,-347.31355777327121,-334.5014670821069,-322.16200311168166,-310.27773107929374,-298.83185935599141,-403.66080000000147,-388.7701092615647,-374.42872296554032,-360.61637775573143,-347.31355777327121,-334.5014670821069,-322.16200311168166]
[null,"%solar generation passing through battery","%",null,{"$f":"IFERROR(E98/E99,\"-\")","v":-32.333333333333215},{"$f":"IFERROR(F98/F99,\"-\")","v":-32.333333333333215},-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333222,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333222,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333215,-32.333333333333222]
[null,"Operation and Maintenance Expenses","INR",null,{"$f":"E16+E45+E76","v":28200},29282.879999999997,30407.342591999997,31574.984547532797,32787.463954158062,34046.502569997727,35353.888268685638,36711.477578203172,38121.198317206174,39585.052332586893,41105.118342158232,42683.554886497106,44322.603394138598,46024.591364473512,47791.935672869302,49627.146002707479,51532.828409211448,53511.689020125166,55566.537878497984,57700.292933032302,59915.984181660737,62216.757974236505,64605.881480447191,67086.74732929637,69662.878426741343]
[null,"Insurance","INR",null,{"$f":"E17+E46+E77","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation (on net capital cost)","INR",null,{"$f":"E14+E43+E74","v":100422.18461538461},100422.18461538461,100422.18461538461,100422.18461538461,100422.18461538461,100422.18461538461,100422.18461538461,100422.18461538461,100422.18461538461,47504.146008345066,47504.146008345066,47504.146008345066,47504.146008345066,45340.435113305117,45340.435113305117,45340.435113305117,45340.435113305117,45340.435113305117,34185.81035995132,34185.81035995132,34185.81035995132,34185.81035995132,34185.81035995132,34185.81035995132,34185.81035995132]
[null,"Interest on term loan","INR",null,{"$f":"E18+E47+E78","v":69156.706919999997},69156.706919999997,60672.03618000001,52187.365440000009,43702.694700000007,35218.023960000006,26733.353220000008,18248.682480000007,9764.0117400000054,30777.804586894927,30457.969336894927,26450.826138533059,22443.682940171195,20159.006434800103,16471.698486438239,12640.851646993808,8810.004807549376,4979.1579681049452,23096.20922001026,22952.670328927692,20065.644176426409,17178.61802392513,14291.591871423849,11404.565718922566,8517.5395664212865]
[null,"Interest on working capital","INR",null,{"$f":"E19+E48+E79","v":4174.3398613478075},4218.0771058415667,4145.0266453166378,4073.7201881715096,4004.2247041359669,3936.6097345774174,3870.9474912517771,3807.3129588463917,3745.7840014605981,3013.655379580609,3070.5847548020811,3078.387663670695,3088.638674137098,3074.8484112920632,3094.7469558089251,3115.3824296980874,3138.864252626031,3165.3017243958438,3272.6200831852693,3356.797738895963,3405.9788355102314,3458.5963941764126,3514.7823750373009,3574.6738055051715,3638.4129748449341]
[null,"Return on equity","INR",null,{"$f":"E20+E49+E80","v":47814.062399999995},47814.062399999995,47814.062399999995,47814.062399999995,47814.062399999995,47814.062399999995,47814.062399999995,47814.062399999995,47814.062399999995,23048.42033190549,23048.42033190549,23048.42033190549,23048.42033190549,21585.751766858488,21585.751766858488,21585.751766858488,21585.751766858488,21585.751766858488,16365.387382288909,16365.387382288909,16365.387382288909,16365.387382288909,16365.387382288909,16365.387382288909,16365.387382288909]
[null,"Cost of eletricity","INR",null,{"$f":"IF(Storage_case=\"Standalone\", E98*Storage_charging_cost*(1+Storage_chargingcost_escalation)^(E3-1)/(Storage_inverter_efficiency^2*Storage_roundtripefficiency), IF(E98/Storage_roundtripefficiency>E97*(1-Storage_solar_directconsumption), (E98-E97*(1-Storage_solar_directconsumption)*Storage_roundtripefficiency)*Storage_charging_cost*(1+Storage_chargingcost_escalation)^(E3-1)/(Storage_inverter_efficiency^2*Storage_roundtripefficiency),0))","v":96360.000000000015},96369.090625635421,96378.18210888264,96387.274449822624,96396.367648536208,96405.461705104361,96414.556619608018,96423.65239212809,96432.749022745513,135262.96605560536,135275.72679643918,135288.48874112434,135301.25188977452,135314.01624250316,135326.78179942394,135339.54856065047,135352.31652629629,135365.08569647506,189872.04219759075,189889.95477183574,189907.86903595735,189925.78499011497,189943.70263446798,189961.62196917593,189979.54299439825]
[null,"Total cost of generation","INR",null,{"$f":"SUM(E101:E107)","v":346127.29379673244},347263.00166686159,339838.8345415839,332459.59164091159,325126.99802221486,317842.84498506412,310608.99261493003,303427.37242456229,296299.99009679689,279192.04469491832,280461.96557054494,278053.82377007575,275708.74323847191,271498.64933323243,269611.349794704,267649.11552021344,265760.20087584679,263947.42128926463,322358.60712152452,324450.91351493192,323846.67397179495,323330.95512469322,322907.15610361658,322578.80656514026,322349.57170464599]
[null,"Cost of generation per kWh","INR",null,{"$f":"IF(Storage_case=\"Standalone\",E108/E98,E108/E99)","v":26.519711226315454},27.625819421810732,28.070708185972201,28.513001754289295,28.952149838618837,29.387587348307218,29.818735904095355,30.245005633590871,30.665797278903373,21.391241126283258,22.311595471868962,22.96726257778073,23.645832688510282,24.176612906016796,24.928127900941732,25.694549998287247,26.490420783222529,27.317443078218297,24.69859304767953,25.81104898875375,26.749754760436527,27.730095092711199,28.754475710551151,29.825471940673154,30.945841801094929]
[null,"Discount factor",null,null,1,{"$f":"E110/(1+Storage_discount_rate)","v":0.92072553171899452},0.84773550475922521,0.78053172337650789,0.71865548602937834,0.66168445449717184,0.60922977119710142,0.56093340502449263,0.51646570760012211,0.47552316324474919,0.43782631732321992,0.40311786881799089,0.37116091411287255,0.34173732999988266,0.31464628487237145,0.28970286794252043,0.26673682712689478,0.24559140698544771,0.22612227878229232,0.20819655536533682,0.19169188414081281,0.17649561195176577,0.16250401616035887,0.14962159668571851,0.13776042416510312]
[null,"Present value","INR",null,{"$f":"E109*E110","v":26.519711226315454},{"$f":"F109*F110","v":25.435797276319612},23.79653597298406,22.255302397912818,20.806621313868007,19.445309703552649,18.166461652238805,16.965433995035088,15.83783269077073,10.172030646101387,9.7686036790538164,9.2585139429381638,8.7764088756275189,8.2620511429428838,7.8435428328546228,7.4437848249962988,7.0659707889731287,6.7089292808245107,5.5849021426577776,5.3737714898244908,5.1277108903327546,4.8942401028687206,4.6727177855500512,4.4625347336686128,4.2631122926650162]
[null,"Levelised cost of generation","INR",{"$f":"IF(Storage_case=\"Solar+Storage\", SUM(OFFSET(E111,0,0,1,SolarPV_plant_life))/SUM(OFFSET(E110,0,0,1,SolarPV_plant_life)), SUM(OFFSET(E111,0,0,1,Storage_life))/SUM(OFFSET(E110,0,0,1,Storage_life)))","v":28.601890113875733}]
[null,"Average cost of generation","INR",{"$f":"IF(Storage_case=\"Solar+Storage\", AVERAGE(OFFSET(E109,0,0,1,SolarPV_plant_life)), AVERAGE(OFFSET(E109,0,0,1,Storage_life)))","v":28.866501843544818}]

{"sheet":"Future LCOS","index":7,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Note"]
[]
[]
[null,"Year","Solar system - Panel cost","Solar system - Inverter cost","Solar system - BoS","Solar system - Installation cost","Solar system - GST","Solar system - Capex","Solar system - O&M","Inverter cost","Inverter - O&M","Battery system - Pack cost","Battery system - BoS cost","Battery system - Installation cost","Battery system - O&M","LCOS (INR/kWh)"]
[null,{"$f":"Storage_base_year","v":2020},{"$f":"SolarPV_capex_perkW*SolarPV_capex_panelpercentage","v":0},{"$f":"SolarPV_capex_perkW*SolarPV_capex_inverterpercentage","v":0},{"$f":"SolarPV_capex_perkW*SolarPV_capex_BoSpercentage","v":0},{"$f":"SolarPV_capex_perkW*SolarPV_capex_installationpercentage","v":0},{"$f":"IF(ISNUMBER(B6),SUM(C6:F6)*SolarPV_capex_taxes/(1-SolarPV_capex_taxes),\"\")","v":0},{"$f":"IF(ISNUMBER(B6),SUM(C6:G6),\"\")","v":0},{"$f":"SolarPV_OandM_year1","v":600},{"$f":"Storage_invertercapex_perkW","v":4500},{"$f":"Storage_OandMpower_year1","v":750},{"$f":"Storage_pack_capexperkWh","v":17900},{"$f":"Storage_enclosure_capexperkWh","v":895},{"$f":"Storage_installation_cost","v":15000},{"$f":"Storage_OndMenergy_year1","v":400},28.601890113875733]
[null,{"$f":"IF(B6<2030,B6+1,\"\")","v":2021},{"$f":"IFERROR(C6+VLOOKUP(B7,Table_module_costreduction,2)*C6,\"\")","v":0},{"$f":"IFERROR(D6+VLOOKUP(B7,Table_inverter_costreduction,2)*D6,\"\")","v":0},{"$f":"IFERROR(E6+VLOOKUP(B7,Table_BoS_costreduction,2)*E6,\"\")","v":0},{"$f":"IF(ISNUMBER(B7),F6*(1+Storage_OandM_escalation),\"\")","v":0},0,{"$f":"IF(ISNUMBER(B7),SUM(C7:G7),\"\")","v":0},{"$f":"IF(ISNUMBER(B7),I6*(1+Storage_OandM_escalation),\"\")","v":623.04},{"$f":"IFERROR(J6+VLOOKUP(B7,Table_inverter_costreduction,2)*J6,\"\")","v":4005},{"$f":"IF(ISNUMBER(B7),K6*(1+Storage_OandM_escalation),\"\")","v":778.8},{"$f":"IF(Storage_battery_technology=\"Li-ion\",IFERROR(L6*VLOOKUP(B7,Table_Liionpack_costreduction,2)/VLOOKUP(B6,Table_Liionpack_costreduction,2),\"\"),IFERROR(L6*VLOOKUP(B7,Table_Pbacidpack_costreduction,2)/VLOOKUP(B6,Table_Pbacidpack_costreduction,2),\"\"))","v":16078.864672918662},{"$f":"IFERROR(M6+VLOOKUP(B7,Table_BoS_costreduction,2)*M6,\"\")","v":841.3},{"$f":"IF(ISNUMBER(B7),N6*(1+Storage_OandM_escalation),\"\")","v":15576},{"$f":"IF(ISNUMBER(B7),O6*(1+Storage_OandM_escalation),\"\")","v":415.36},27.034616102219385]
[null,{"$f":"IF(B7<2030,B7+1,\"\")","v":2022},0,0,0,0,0,0,646.9647359999999,3564.45,808.70591999999999,14424.992555432802,790.822,16174.118399999999,431.30982399999999,25.627871747097014]
[null,2023,0,0,0,0,0,0,671.80818186239992,3243.6495,839.76022732799993,12943.465939828522,751.28089999999997,16795.204546559999,447.87212124159998,24.40502747431627]
[null,2024,0,0,0,0,0,0,697.60561604591612,2951.7210450000002,872.00702005739515,11632.449132705113,713.71685500000001,17440.140401147903,465.0704106972774,23.339994121708024]
[null,2025,0,0,0,0,0,0,724.39367170207925,2745.1005718500001,905.49208962759917,10487.057834655017,685.16818079999996,18109.841792551983,482.92911446805283,22.445409604102007]
[null,2026,0,0,0,0,0,0,752.21038869543906,2552.9435318205001,940.26298586929897,9500.9254688492747,657.76145356799998,18805.259717385979,501.47359246362606,21.696023244940996]
[null,2027,0,0,0,0,0,0,781.09526762134396,2425.296355229475,976.36908452668001,8665.9106340473973,638.02860996096001,19527.381690533603,520.73017841422927,21.100076957552037]
[null,2028,0,0,0,0,0,0,811.08932589800361,2304.0315374680013,1013.8616573725045,7970.7947377173168,618.88775166213122,20277.233147450093,540.72621726533566,20.631259936603406]
[null,2029,0,0,0,0,0,0,842.23515601248698,2234.9105913439612,1052.7939450156086,7400.3891652699276,606.50999662888864,21055.878900312178,561.49010400832458,20.29070459394454]
[null,2030,0,0,0,0,0,0,874.57698600336653,2167.8632736036425,1093.221232504208,6936.2722211115006,594.3797966963109,21864.424650084165,583.0513240022442,20.047967619974354]
[null,"","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0,0,0,0,0,0,600,4500,750,17900,895,15000,400]
[null,null,0,0,0,0,0,0,623.04,4005,778.8,16078.864672918662,841.3,15576,415.36]
[null,null,0,0,0,0,0,0,646.9647359999999,3564.45,808.70591999999999,14424.992555432802,790.822,16174.118399999999,431.30982399999999]
[null,null,0,0,0,0,0,0,671.80818186239992,3243.6495,839.76022732799993,12943.465939828522,751.28089999999997,16795.204546559999,447.87212124159998]
[null,null,0,0,0,0,0,0,697.60561604591612,2951.7210450000002,872.00702005739515,11632.449132705113,713.71685500000001,17440.140401147903,465.0704106972774]
[null,null,0,0,0,0,0,0,724.39367170207925,2745.1005718500001,905.49208962759917,10487.057834655017,685.16818079999996,18109.841792551983,482.92911446805283]
[null,null,0,0,0,0,0,0,752.21038869543906,2552.9435318205001,940.26298586929897,9500.9254688492747,657.76145356799998,18805.259717385979,501.47359246362606]
[null,null,0,0,0,0,0,0,781.09526762134396,2425.296355229475,976.36908452668001,8665.9106340473973,638.02860996096001,19527.381690533603,520.73017841422927]
[null,null,0,0,0,0,0,0,811.08932589800361,2304.0315374680013,1013.8616573725045,7970.7947377173168,618.88775166213122,20277.233147450093,540.72621726533566]
[null,null,0,0,0,0,0,0,842.23515601248698,2234.9105913439612,1052.7939450156086,7400.3891652699276,606.50999662888864,21055.878900312178,561.49010400832458]
[null,null,0,0,0,0,0,0,874.57698600336653,2167.8632736036425,1093.221232504208,6936.2722211115006,594.3797966963109,21864.424650084165,583.0513240022442]
[null,null,"","","","","","","","","","","","",""]
[null,null,"","","","","","","","","","","","",""]
[null,null,"","","","","","","","","","","","",""]
[null,null,"","","","","","","","","","","","",""]
[null,null,"","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,18620]

{"sheet":"Cost projections","index":8,"n_rows":295,"n_cols":5,"rows_kept":295,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Go to cost projections for:"]
[]
[]
[]
[]
[]
[null,null,"Li-ion battery pack (BtM application) cost reduction curve (central estimate from Schmidt et al. 2019)"]
[null,null,"Year","Cost (%)"]
[null,null,2015,1]
[null,null,2016,0.87950735333916497]
[null,null,2017,0.74976363181682348]
[null,null,2018,0.68382048680476315]
[null,null,2019,0.61906507278499423]
[null,null,2020,0.55768922016073685]
[null,null,2021,0.50095025142514138]
[null,null,2022,0.44942250553428797]
[null,null,2023,0.40326432548380048]
[null,null,2024,0.36241851873618747]
[null,null,2025,0.32673291092677675]
[null,null,2026,0.29600914611887358]
[null,null,2027,0.26999357226170567]
[null,null,2028,0.24833666487926687]
[null,null,2029,0.23056521019359516]
[null,null,2030,0.21610526512928802]
[null,null,2031,0.20435125795786843]
[null,null,2032,0.19473995249273165]
[null,null,2033,0.18679530370875316]
[null,null,2034,0.1801397268384401]
[null,null,2035,0.17448453828404997]
[null,null,2036,0.16961279142332811]
[null,null,2037,0.16536212647958562]
[null,null,2038,0.16161054605548739]
[null,null,2039,0.15826556815851425]
[null,null,2040,0.15525627994391147]
[null,null,2041,0.15252761732018405]
[null,null,2042,0.15003626688185565]
[null,null,2043,0.14774772292873473]
[null,null,2044,0.14563415983646361]
[null,null,2045,0.14367287980012206]
[null,null,2046,0.14184516846554476]
[null,null,2047,0.14013544187469915]
[null,null,2048,0.13853060336908418]
[null,null,2049,0.1370195533371768]
[null,null,2050,0.13559281139547652]
[null,null,2051,0.13415650005579255]
[null,null,2052,0.13272037863480499]
[null,null,2053,0.13128425721381745]
[null,null,2054,0.12984813579282989]
[null,null,2055,0.12841201437184235]
[null,null,2056,0.12697589295085482]
[null,null,2057,0.12553977152986726]
[null,null,2058,0.12410365010887971]
[null,null,2059,0.12266752868789216]
[null,null,2060,0.12123140726690462]
[]
[]
[]
[]
[null,null,"Pb acid storage (BtM application) cost reduction curve (assumed)"]
[null,null,"Year","Cost (%)"]
[null,null,2015,1]
[null,null,2016,0.95762674313617457]
[null,null,2017,0.82795123477699362]
[null,null,2018,0.73342363630083529]
[null,null,2019,0.65700830450751069]
[null,null,2020,0.59212806155448572]
[null,null,2021,0.53563866682131211]
[null,null,2022,0.48583840500616959]
[null,null,2023,0.44173450062518538]
[null,null,2024,0.40272628465219246]
[null,null,2025,0.36844630294300884]
[null,null,2026,0.33865695811003921]
[null,null,2027,0.31315698449437929]
[null,null,2028,0.29169042993702704]
[null,null,2029,0.27388537387671219]
[null,null,2030,0.25925539458444352]
[null,null,2031,0.24725912314751686]
[null,null,2032,0.2373746032700218]
[null,null,2033,0.22914960796188269]
[null,null,2034,0.2222190244565469]
[null,null,2035,0.21630000419675885]
[null,null,2036,0.21117782811867189]
[null,null,2037,0.20669051832983404]
[null,null,2038,0.20271557789369257]
[null,null,2039,0.19915965037887454]
[null,null,2040,0.1959508302883218]
[null,null,2041,0.19303306697996947]
[null,null,2042,0.19036212227254265]
[null,null,2043,0.18790264832561776]
[null,null,2044,0.18562606378012353]
[null,null,2045,0.18350899735879042]
[null,null,2046,0.18153213612314545]
[null,null,2047,0.17967936414212249]
[null,null,2048,0.17793711132124479]
[null,null,2049,0.17629385575424469]
[null,null,2050,0.1747397393458]
[null,null,2051,0.1731755069111961]
[null,null,2052,0.17161147523646761]
[null,null,2053,0.17004744356173912]
[null,null,2054,0.1684834118870106]
[null,null,2055,0.16691938021228211]
[null,null,2056,0.16535534853755363]
[null,null,2057,0.16379131686282514]
[null,null,2058,0.16222728518809665]
[null,null,2059,0.16066325351336816]
[null,null,2060,0.15909922183863967]
[]
[]
[]
[]
[null,null,"Inverter cost reduction curve"]
[null,null,"Year","Reduction (%)","Cost (%)"]
[null,null,2020,null,1]
[null,null,2021,-0.11,{"$f":"E114+D115*E114","v":0.89}]
[null,null,2022,-0.11,0.79210000000000003]
[null,null,2023,-0.09,0.72081099999999998]
[null,null,2024,-0.09,0.65593800999999996]
[null,null,2025,-7.0000000000000007E-2,0.61002234929999999]
[null,null,2026,-7.0000000000000007E-2,0.56732078484899995]
[null,null,2027,-0.05,0.53895474560654999]
[null,null,2028,-0.05,0.51200700832622248]
[null,null,2029,-0.03,0.4966467980764358]
[null,null,2030,-0.03,0.48174739413414275]
[null,null,2031,-0.03,0.46729497231011846]
[null,null,2032,-0.02,0.45794907286391612]
[null,null,2033,-0.02,0.44879009140663778]
[null,null,2034,-0.02,0.43981428957850505]
[null,null,2035,-0.02,0.43101800378693494]
[null,null,2036,-0.01,0.42670782374906557]
[null,null,2037,-0.01,0.4224407455115749]
[null,null,2038,-0.01,0.41821633805645914]
[null,null,2039,-0.01,0.41403417467589454]
[null,null,2040,-0.01,0.40989383292913562]
[null,null,2041,-0.01,0.40579489459984425]
[null,null,2042,-8.9999999999999993E-3,0.40214274054844568]
[null,null,2043,-8.9999999999999993E-3,0.39852345588350968]
[null,null,2044,-8.9999999999999993E-3,0.39493674478055807]
[null,null,2045,-8.9999999999999993E-3,0.39138231407753304]
[null,null,2046,-8.9999999999999993E-3,0.38785987325083526]
[null,null,2047,-8.9999999999999993E-3,0.38436913439157777]
[null,null,2048,-8.0000000000000002E-3,0.38129418131644516]
[null,null,2049,-8.0000000000000002E-3,0.3782438278659136]
[null,null,2050,-8.0000000000000002E-3,0.37521787724298628]
[null,null,2051,-8.0000000000000002E-3,0.37221613422504241]
[null,null,2052,-8.0000000000000002E-3,0.36923840515124207]
[null,null,2053,-8.0000000000000002E-3,0.36628449791003215]
[null,null,2054,-8.0000000000000002E-3,0.36335422192675187]
[null,null,2055,-6.0000000000000001E-3,0.36117409659519134]
[null,null,2056,-6.0000000000000001E-3,0.35900705201562022]
[null,null,2057,-6.0000000000000001E-3,0.35685300970352651]
[null,null,2058,-6.0000000000000001E-3,0.35471189164530537]
[null,null,2059,-6.0000000000000001E-3,0.35258362029543355]
[null,null,2060,-6.0000000000000001E-3,0.35046811857366095]
[]
[]
[]
[]
[null,null,"Module cost reduction curve (assumed)"]
[null,null,"Year","Reduction (%)","Cost (%)"]
[null,null,2020,null,1]
[null,null,2021,-0.13,{"$f":"E161+D162*E161","v":0.87}]
[null,null,2022,-0.13,0.75690000000000002]
[null,null,2023,-0.10636363636363637,0.67639336363636371]
[null,null,2024,-0.10636363636363637,0.60444970586776869]
[null,null,2025,-8.2727272727272733E-2,0.55444523020052605]
[null,null,2026,-8.2727272727272733E-2,0.50857748842939166]
[null,null,2027,-5.9090909090909097E-2,0.47852518229492758]
[null,null,2028,-5.9090909090909097E-2,0.45024869425022729]
[null,null,2029,-5.9090909090909097E-2,0.42364308958998659]
[null,null,2030,-3.5454545454545454E-2,0.40862301641361432]
[null,null,2031,-3.5454545454545454E-2,0.39413547310440433]
[null,null,2032,-2.3636363636363639E-2,0.3848195437401184]
[null,null,2033,-2.3636363636363639E-2,0.37572380906989744]
[null,null,2034,-2.3636363636363639E-2,0.3668430644918817]
[null,null,2035,-1.181818181818182E-2,0.36250764645697764]
[null,null,2036,-1.181818181818182E-2,0.35822346518066789]
[null,null,2037,-1.181818181818182E-2,0.35398991513762362]
[null,null,2038,-1.181818181818182E-2,0.34980639795872442]
[null,null,2039,-1.181818181818182E-2,0.34567232234648493]
[null,null,2040,-1.181818181818182E-2,0.34158710399148101]
[null,null,2041,-1.181818181818182E-2,0.33755016548976352]
[null,null,2042,-1.0636363636363637E-2,0.33395985918409965]
[null,null,2043,-1.0636363636363637E-2,0.33040774068186879]
[null,null,2044,-1.0636363636363637E-2,0.32689340380370707]
[null,null,2045,-1.0636363636363637E-2,0.32341644669052216]
[null,null,2046,-1.0636363636363637E-2,0.31997647175754118]
[null,null,2047,-1.0636363636363637E-2,0.31657308564884734]
[null,null,2048,-9.4545454545454551E-3,0.3135800310208946]
[null,null,2049,-9.4545454545454551E-3,0.3106152743639698]
[null,null,2050,-9.4545454545454551E-3,0.30767854813361956]
[null,null,2051,-9.4545454545454551E-3,0.30476958731490172]
[null,null,2052,-8.2727272727272736E-3,0.3022483116380239]
[null,null,2053,-8.2727272727272736E-3,0.29974789378720024]
[null,null,2054,-8.2727272727272736E-3,0.29726816121132432]
[null,null,2055,-8.2727272727272736E-3,0.2948089427867579]
[null,null,2056,-7.0909090909090913E-3,0.29271847937426998]
[null,null,2057,-7.0909090909090913E-3,0.29064283924779788]
[null,null,2058,-7.0909090909090913E-3,0.28858191729676802]
[null,null,2059,-7.0909090909090913E-3,0.2865356091559364]
[null,null,2060,-7.0909090909090913E-3,0.28450381120010337]
[]
[]
[]
[]
[null,null,"BoS cost reduction curve (assumed)"]
[null,null,"Year","Reduction (%)","Cost (%)"]
[null,null,2020,null,1]
[null,null,2021,-0.06,{"$f":"E208+D209*E208","v":0.94}]
[null,null,2022,-0.06,0.88359999999999994]
[null,null,2023,-0.05,0.83941999999999994]
[null,null,2024,-0.05,0.79744899999999996]
[null,null,2025,-0.04,0.76555103999999996]
[null,null,2026,-0.04,0.73492899839999992]
[null,null,2027,-0.03,0.71288112844799989]
[null,null,2028,-0.03,0.69149469459455992]
[null,null,2029,-0.02,0.67766480070266877]
[null,null,2030,-0.02,0.66411150468861535]
[null,null,2031,-0.02,0.65082927459484308]
[null,null,2032,-0.01,0.64432098184889464]
[null,null,2033,-0.01,0.63787777203040574]
[null,null,2034,-0.01,0.6314989943101017]
[null,null,2035,-0.01,0.62518400436700072]
[null,null,2036,-6.0000000000000001E-3,0.62143290034079868]
[null,null,2037,-6.0000000000000001E-3,0.61770430293875389]
[null,null,2038,-6.0000000000000001E-3,0.61399807712112142]
[null,null,2039,-6.0000000000000001E-3,0.61031408865839465]
[null,null,2040,-6.0000000000000001E-3,0.60665220412644427]
[null,null,2041,-6.0000000000000001E-3,0.60301229090168562]
[null,null,2042,-5.0000000000000001E-3,0.59999722944717715]
[null,null,2043,-5.0000000000000001E-3,0.5969972432999413]
[null,null,2044,-5.0000000000000001E-3,0.59401225708344163]
[null,null,2045,-5.0000000000000001E-3,0.59104219579802442]
[null,null,2046,-5.0000000000000001E-3,0.58808698481903432]
[null,null,2047,-5.0000000000000001E-3,0.58514654989493919]
[null,null,2048,-4.0000000000000001E-3,0.58280596369535942]
[null,null,2049,-4.0000000000000001E-3,0.58047473984057796]
[null,null,2050,-4.0000000000000001E-3,0.57815284088121566]
[null,null,2051,-4.0000000000000001E-3,0.57584022951769076]
[null,null,2052,-4.0000000000000001E-3,0.57353686859961994]
[null,null,2053,-4.0000000000000001E-3,0.57124272112522145]
[null,null,2054,-4.0000000000000001E-3,0.56895775024072059]
[null,null,2055,-3.0000000000000001E-3,0.56725087698999843]
[null,null,2056,-3.0000000000000001E-3,0.56554912435902849]
[null,null,2057,-3.0000000000000001E-3,0.56385247698595142]
[null,null,2058,-3.0000000000000001E-3,0.56216091955499359]
[null,null,2059,-3.0000000000000001E-3,0.56047443679632858]
[null,null,2060,-3.0000000000000001E-3,0.55879301348593957]
[]
[]
[]
[]
[null,null,"CUF for PV"]
[null,null,"Year","Increase (%)","Value (%)"]
[null,null,2020,null,1]
[null,null,2021,1.2999999999999999E-3,{"$f":"E255+D256*E255","v":1.0013000000000001}]
[null,null,2022,1.2999999999999999E-3,1.0026016900000001]
[null,null,2023,1.2999999999999999E-3,1.0039050721970002]
[null,null,2024,1.2999999999999999E-3,1.0052101487908562]
[null,null,2025,1.2999999999999999E-3,1.0065169219842844]
[null,null,2026,1.2999999999999999E-3,1.0078253939828641]
[null,null,2027,1.2999999999999999E-3,1.0091355669950417]
[null,null,2028,1.2999999999999999E-3,1.0104474432321353]
[null,null,2029,1.2999999999999999E-3,1.0117610249083371]
[null,null,2030,1.2999999999999999E-3,1.013076314240718]
[null,null,2031,1.2999999999999999E-3,1.0143933134492309]
[null,null,2032,1.2999999999999999E-3,1.0157120247567148]
[null,null,2033,1.2999999999999999E-3,1.0170324503888986]
[null,null,2034,1.2999999999999999E-3,1.0183545925744042]
[null,null,2035,1.2999999999999999E-3,1.019678453544751]
[null,null,2036,1.2999999999999999E-3,1.021004035534359]
[null,null,2037,1.2999999999999999E-3,1.0223313407805537]
[null,null,2038,1.2999999999999999E-3,1.0236603715235684]
[null,null,2039,1.2999999999999999E-3,1.0249911300065491]
[null,null,2040,1.2999999999999999E-3,1.0263236184755575]
[null,null,2041,1.2999999999999999E-3,1.0276578391795756]
[null,null,2042,1.2999999999999999E-3,1.0289937943705092]
[null,null,2043,1.2999999999999999E-3,1.0303314863031909]
[null,null,2044,1.2999999999999999E-3,1.0316709172353851]
[null,null,2045,1.2999999999999999E-3,1.033012089427791]
[null,null,2046,1.2999999999999999E-3,1.0343550051440471]
[null,null,2047,1.2999999999999999E-3,1.0356996666507343]
[null,null,2048,1.2999999999999999E-3,1.0370460762173803]
[null,null,2049,1.2999999999999999E-3,1.0383942361164629]
[null,null,2050,1.2999999999999999E-3,1.0397441486234142]
[null,null,2051,1.2999999999999999E-3,1.0410958160166246]
[null,null,2052,1.2999999999999999E-3,1.0424492405774461]
[null,null,2053,1.2999999999999999E-3,1.0438044245901967]
[null,null,2054,1.2999999999999999E-3,1.0451613703421641]
[null,null,2055,1.2999999999999999E-3,1.046520080123609]
[null,null,2056,1.2999999999999999E-3,1.0478805562277698]
[null,null,2057,1.2999999999999999E-3,1.0492428009508659]
[null,null,2058,1.2999999999999999E-3,1.0506068165921021]
[null,null,2059,1.2999999999999999E-3,1.0519726054536718]
[null,null,2060,1.2999999999999999E-3,1.0533401698407616]

{"sheet":"Tariff rates in TN","index":9,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Tariff Category","Tariff (Rs/kWh)"]
[null,"Solar PV",0]
[null,"Domestic (1-50 kWh)",2.5]
[null,"Domestic (51-100 kWh)",2.5]
[null,"Domestic (101-250 kWh)",3]
[null,"Domestic (Above 250 kWh)",6.6]
[null,"Public Lighting",6.35]
[null,"LT Govt. Educational Institution",5.75]
[null,"LT Pvt. Educational Institution",7.5]
[null,"LT Industries",6.35]
[null,"LT Commercial (Above 50 kWh)",8.0500000000000007]
[null,"HT Industries",6.35]
[null,"HT Govt. Educational Institution",6.35]
[null,"HT Pvt. Educational Institution",6.35]
[null,"HT Commercial",8]
[null,"Custom",3.7]

{"sheet":"Storage references","index":10,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,1,2,13],[3,1,3,13],[4,1,4,13],[5,1,5,13],[6,1,6,13],[7,1,7,13],[8,1,8,13],[9,1,9,13],[10,1,10,13],[11,1,11,13],[12,1,12,13],[13,1,13,13],[14,1,14,13],[15,1,15,13],[16,1,16,13]]}
[null,"REFERENCES"]
[]
[null,"1. The cost reduction curves for Pb acid and Li-ion have been taken from the following: \nSchmidt, O., Melchior, S., Hawkes, A., and Staffell, I. (2018). The future cost of electrical energy storage based on experience rates:dataset. Figshare Digital Repository (2018). Available at: https://doi.org/10.6084/m9.figshare"]
[null,"2. Recent price trends in panel prices, inverter cost and balance of system costs for residential, and for commercial and industrial segments were noted from, and helped in making assumptions on respective cost reductions:\nLawrence Berkeley National Lab (LBNL). (2020). Distributed Solar 2020 Data Update. Available at: https://emp.lbl.gov/tracking-the-sun/"]

{"sheet":"Results","index":11,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"Parameter",null,"Unit",null,"Solar+Storage (LT Industry)",null,"Solar+Storage (LT Industry)",null,"Standalone Storage (LT Industry)"]
[null,null,"Installation year",null,null,null,2020,null,2025,null,2020]
[null,null,"Solar PV capital cost (w/o inverter)",null,"INR/kW",null,41000,null,35000,null,41000]
[null,null,"Solar PV capacity",null,"kW",null,24,null,24,null,24]
[null,null,"Inverter capital cost",null,"INR/kVA",null,20000,null,16000]
[null,null,"Inverter replacement year",null,null,null,13,null,13,null,13]
[null,null,"Inverter cost improvement in replacement year",null,null,null,0.6,null,0.7,null,0.6]
[null,null,"Inverter capacity",null,"kVA",null,12,null,12,null,12]
[null,null,"Storage capital cost",null,"INR/kWh",null,20000,null,12000,null,20000]
[null,null,"Storage rack and others",null,"INR",null,64000,null,64000,null,64000]
[null,null,"EPC cost",null,"INR",null,14000,null,14000,null,14000]
[null,null,"Storage duration",null,"Hr",null,4,null,4,null,4]
[null,null,"Storage life cycles",null,null,null,4000,null,4000,null,4000]
[null,null,"Storage cycles/year at 100% DoD",null,null,null,365,null,365,null,760]
[null,null,"LCOS",null,"INR/kWh",null,9.9600000000000009,null,7.77,null,12.49]