{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Title sheet","How to use","RE Inputs & Results","RE LCOE calc","Reference values","Storage Inputs & Results","LCOS calc","Storage charging cost","Cost projections","Storage references","Results"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":100,"comments":7,"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":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,4,28,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Levelised Cost Calculator for Distributed Energy Resources"]
[]
[]
[null,null,null,null,"Authors:","Martin Scherfler"]
[null,null,null,null,null,"Rohith C Unni"]
[null,null,null,null,null,"Shiv Vembadi"]
[]
[null,null,null,null,"Version:","v1.0, October 2020"]
[]
[]
[]
[]
[null,null,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":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,14,17,15],[17,1,45,12],[1,1,14,12]]}
[null,"Introduction to the levelised cost calculator"]
[null,"The tool has been developed to calculate levelised cost of RE (orange sheets) and energy storage (blue sheets). The sheet RE LCOE calc contains the calculation for the levelised cost of energy (LCOE) for a specific RE technology, based on inputs entered in the sheet RE Inputs & Results. The sheet LCOS calc contains the calculation for levelised cost of storage (LCOS), based on inputs entered in the sheet Storage Inputs & Results. \n  ▪  LCOE can be calculated for Solar PV, Wind, Biomass, Bagasse and Small Hydro. The default input values have been taken from tariff orders, which are noted in the sheet Reference values. \n  ▪  LCOS can be calculated for different storage scenarios, including: Solar PV + LI-ion storage (medium capacity), and Standalone Li-ion storage. (Use Scenario Manager to select other in-built scenarios.) The cost inputs are divided into following components: solar PV, inverter cost, power capacity (kW) component of the battery storage system, and energy capacity (kWh) component of the battery system. The power capacity costs (INR/kW) takes into account the costs of balance of system (BOS) and the EPC. The energy capacity costs takes into account the cost of the battery pack. Further, see Storage Inputs & Results for details on cost inputs for the storage system.\n  ▪  The LCOS methodology is applicable to any storage technology, such as lead acid battery, vanadium redox flow battery, hydrogen storage - with the correct input parameters. The in-built scenarios are currently only for Li-ion application.\n\nLCOS 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\nFor LCOS calculation, one of the inputs is the base yearfor calculating the LCOS. For calculation of LCOS in a future base year (e.g., 2030), future Li-ion module costs (both initial cost in Year 1 and replacement costs later) are calculated based on the cost in the Current year and the cost improvement curve given in Cost projections sheet. The sheet also provides other references on historical solar inverter and solar PV capital cost trends. To input future costs of inverter and solar PV for LCOS calculations, the user can make reasonable assumptions based on these."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 also 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▪ The Inputs and Results sheets have two areas: Inputs area for entering inputs, the Outputs are are where the results are displayed, including the levelised cost:\n   ▫ In the Inputs area, there is a general set of inputs, and then technology-specific inputs (which will \n      only apply to a particular  technology)\n   ▫ In the Inputs area, the grey-colored values are the ones that reset to their defaults when a particular RE Technology or storage\n      scenario is selected. Other input values don't have any defaults.   \n▪ In the case of Storage, debt (and the the debt repayment calculation) has been 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 35 years, the LCOE is calculated only considering  the number of years of plant life: e.g., 20 years in the case of Biomass.\n▪ Simlar, in the  LCOS calc sheet, for the scenario Solar PV + Storage, the levelised cost corresponds to the plant life of the solar PV.\n▪ For calculating depreciation, straight line method is used. The annual is calculated as a percentage of the net capital cost.\n▪ In the case of storage, in the absence of any tariff determination regulations on the same, the default depreciation rates for the storage system and for the inverter is such that the residual value (at the end of life) is 10% of the initial capital cost.\n▪ The insurance is calculated as a perentage of the net asset value or is part of O&M expense, depending on the technology.\n▪ In case of Small Hydro, the inputs are the average of normative values fixed by CERC for states other than Himachal Pradesh, Uttarakhand, West Bengal and N.E. states for the two size categories: below 5 MW, and between 5 MW to 25 MW."]

{"sheet":"RE Inputs & Results","index":2,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[[7,1,7,5],[7,10,7,12]]}
[]
[]
[null,null,null,null,null,"Select Technology:"]
[]
[]
[]
[]
[null,"Inputs",null,null,null,null,null,null,"Solar PV",null,"Outputs"]
[]
[null,"Parameter",null,"Unit",null,"Value",null,null,null,null,"Gross capital cost","INR",{"$f":"Capex_perkW*System_size","v":33500000}]
[null,null,null,null,null,null,null,null,null,null,"Net capital cost","INR",{"$f":"(Capex_perkW-Capitalsubsidy_perkW)*System_size","v":33500000}]
[null,"General inputs",null,null,null,null,null,null,null,null,"Equity","INR",{"$f":"Net_capex*Equity_percentage","v":10050000}]
[null,"System capital cost per kW",null,"INR",null,33500,null,null,null,null,"Debt","INR",{"$f":"Net_capex-Equity","v":23450000}]
[null,"Capital subsidy per kW",null,"INR",null,0,null,null,null,null,"Annual depreciation for first n1 years (on gross capex)","INR",{"$f":"Gross_capex*Depreciationrate_n1years*Depreciation_on_capexpercentage","v":1145700}]
[null,"Plant size",null,"kW",null,1000,null,null,null,null,"Annual depreciation after n1 years (on gross capex)","INR",{"$f":"IF(n1_years<Plant_life,(Gross_capex*Depreciation_on_capexpercentage-Annual_depreciation_n1yearsgross*n1_years)/(Plant_life-n1_years),0)","v":0}]
[null,"Life of plant",null,"years",null,25,null,null,null,null,"Annual depreciation for first n1 years (on net capex)","INR",{"$f":"Net_capex*Depreciationrate_n1years*Depreciation_on_capexpercentage","v":1145700}]
[null,"Capacity utilisation factor",null,"%",null,0.19,null,null,null,null,"Annual depreciation after n1 years (on net capex)","INR",{"$f":"IF(n1_years<Plant_life,(Net_capex*Depreciation_on_capexpercentage-Annual_depreciation_n1yearsnet*n1_years)/(Plant_life-n1_years),0)","v":0}]
[null,"Auxiliary consumption",null,"%",null,0]
[null,"Grid availability factor",null,"%",null,0.95]
[null,"Discount rate",null,"%",null,9.5299999999999996E-2]
[null,"Equity",null,"%",null,0.3]
[null,"Return on equity",null,"%",null,0.17599999999999999]
[null,"Loan tenure",null,"years",null,10]
[null,"Moratorium",null,"years",null,1]
[null,"Interest on loan",null,"%",null,0.1055]
[null,"Operation and Maintenance Expenses in year 1",null,"%",null,1.4E-2]
[null,"Annual increase in Operation and Maintenance expenses",null,"%",null,5.7200000000000001E-2]
[null,"Insurance (% of depreciated asset value)",null,"%",null,3.5000000000000001E-3]
[null,"Working capital - O&M",null,"months",null,1]
[null,"Working capital - Receivables",null,"months",null,2]
[null,"Working capital - Maintenance spares",null,"%",null,"-"]
[null,"Interest on working capital",null,"%",null,0.11550000000000001]
[null,"n1 years",null,"years",null,25]
[null,"Depreciation rate for the first n1 years",null,"%",null,3.5999999999999997E-2]
[null,"Percentage of capital cost on which depreciation applies",null,"%",null,0.95]
[]
[null,"Solar PV-specific inputs"]
[null,"Annual solar panel degradation",null,"%",null,0.01]
[]
[null,"Biomass/Bagasse-specific inputs"]
[null,"Working capital - Fuel",null,"months",null,1]
[null,"Station heat rate",null,"kcal/kWh",null,3840]
[null,"Calorific value",null,"kcal/kg",null,3200]
[null,"Specific fuel consumption",null,"kg/kWh",null,1.41]
[null,"Fuel cost",null,"Rs/MT",null,1834.35]
[null,"Fuel cost escalation",null,"%",null,0.05]

{"sheet":"RE LCOE calc","index":3,"n_rows":42,"n_cols":42,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["This sheet shows the LCOE calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year ----->"]
[null,"Parameter",null,"Unit",null,"Cumulative",null,1,{"$f":"H3+1","v":2},{"$f":"I3+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":"AF3+1","v":26},27,28,29,30,31,32,33,34,35]
[]
[null,"Cost of Generation"]
[null,"Gross generation / kWh input (for Storage)",null,"kWh",null,null,null,{"$f":"System_size*24*365*CUF*Grid_availability*IF(Technology=\"Solar PV\",(1-SolarPV_degradation)^(H3-1),1)","v":1581180},1565368.2,1549714.5179999999,1534217.3728199999,1518875.1990918,1503686.447100882,1488649.582629873,1473763.0868035743,1459025.4559355385,1444435.201376183,1429990.8493624211,1415690.940868797,1401534.0314601089,1387518.6911455079,1373643.5042340527,1359907.0691917122,1346307.9984997951,1332844.9185147972,1319516.4693296491,1306321.3046363525,1293258.0915899891,1280325.5106740892,1267522.2555673481,1254847.0330116749,1242298.5626815581,1229875.5770547423,1217576.8212841949,1205401.0530713531,1193347.0425406394,1181413.5721152329,1169599.4363940808,1157903.4420301397,1146324.4076098385,1134861.16353374,1123512.5518984026]
[null,"Net generation / kWh available (for Storage)",null,"kWh",null,null,null,{"$f":"H6-(H6*Aux_consumption)","v":1581180},1565368.2,1549714.5179999999,1534217.3728199999,1518875.1990918,1503686.447100882,1488649.582629873,1473763.0868035743,1459025.4559355385,1444435.201376183,1429990.8493624211,1415690.940868797,1401534.0314601089,1387518.6911455079,1373643.5042340527,1359907.0691917122,1346307.9984997951,1332844.9185147972,1319516.4693296491,1306321.3046363525,1293258.0915899891,1280325.5106740892,1267522.2555673481,1254847.0330116749,1242298.5626815581,1229875.5770547423,1217576.8212841949,1205401.0530713531,1193347.0425406394,1181413.5721152329,1169599.4363940808,1157903.4420301397,1146324.4076098385,1134861.16353374,1123512.5518984026]
[null,"Operation and Maintenance Expenses",null,"INR",null,null,null,{"$f":"OandM_year1*Gross_capex","v":469000},{"$f":"H8+(H8*OandM_escalation)","v":495826.8},524188.09295999998,554171.65187731199,585870.27036469418,619382.04982955474,654810.70307980524,692265.87529597012,731863.48336289963,773726.07461125753,817983.20607902145,864771.84546674148,914236.79502743913,966531.1397030087,1021816.7208940207,1080264.6373291588,1142055.7745843867,1207381.3648906136,1276443.5789623568,1349456.1516790036,1426645.0435550427,1508249.1400463912,1594520.9908570447,1685727.5915340676,1782151.2097698164,1884090.2589686499,1991860.2217816566,2105794.6264675674,2226246.0791015122,2353587.3548261188,2488212.551522173,2630538.3094692412,2781005.1007708819,2940078.5925349761,3108251.0880279769]
[null,"Insurance",null,"INR",null,null,null,{"$f":"Insurance*H42","v":117250},113240.05,109230.1,105220.15000000001,101210.2,97200.25,93190.3,89180.35,85170.400000000009,81160.45,77150.5,73140.55,69130.600000000006,65120.65,61110.700000000004,57100.75,53090.8,49080.85,45070.9,41060.950000000004,37051,33041.050000000003,29031.100000000002,25021.15,21011.200000000001,17001.25,17001.25,17001.25,17001.25,17001.25,17001.25,17001.25,17001.25,17001.25,17001.25]
[null,"Depreciation (on gross capital cost)",null,null,null,null,null,{"$f":"IF(H3<=n1_years, Annual_depreciation_n1yearsgross, Annual_depreciation_aftern1gross)","v":1145700},1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation (on net capital cost)",null,"INR",null,null,null,{"$f":"IF(H3<=n1_years, Annual_depreciation_n1yearsnet, Annual_depreciation_aftern1net)","v":1145700},1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,1145700,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on Term Loan",null,"INR",null,null,null,{"$f":"H27","v":2473975},2473975,2199088.888888889,1924202.7777777775,1649316.6666666665,1374430.5555555553,1099544.4444444443,824658.33333333302,549772.2222222219,274886.11111111077,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AG27","v":0},0,0,0,0,0,0,0,0,0]
[null,"Interest on Working Capital",null,"INR",null,null,null,{"$f":"H32+H36","v":119614.47815625},{"$f":"I32+I36","v":120316.8809717875},115772.31894542987,111274.90042405399,106827.32201614488,102432.43457619281,98093.252027564944,93812.960690044987,89594.929140908323,85442.718640050516,81360.094151433077,82642.593633845056,84002.867442595991,85445.364269152487,86974.787270132991,88596.108622714615,90314.584912608872,92135.773402230116,94065.549229402677,96110.123589834504,98276.062959628049,100570.30941731877,103000.20212833441,105573.50005836511,108298.40598593862,89128.866888514298,92260.692318162313,95571.6581623862,99072.011252899712,102772.58454019055,106684.83061951447,110820.85717457571,115193.46444858643,119816.18485867055,124703.32487621153]
[null,"Return on Equity",null,"INR",null,null,null,{"$f":"Equity*ROE","v":1768800},1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800,1768800]
[null,"Fuel cost",null,"INR",null,null,null,{"$f":"IF(OR(Technology=\"Biomass\",Technology=\"Bagasse\"),(H6*'RE Inputs & Results'!$F$44*'RE Inputs & Results'!$F$45)/1000,0)","v":0},{"$f":"IF(OR(Technology=\"Biomass\",Technology=\"Bagasse\"),H15*(1+Bio_fuelcost_escalation),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,0,0,0,0,0,0,0,0,0]
[null,"Total Cost of Generation",null,"INR",null,null,null,{"$f":"SUM(H8, H9, H11:H15)","v":6094339.47815625},{"$f":"SUM(I8, I9, I11:I15)","v":6117858.7309717871},{"$f":"SUM(J8, J9, J11:J15)","v":5862779.4007943189},5609369.4800791433,5357724.4590475056,5107945.2899613027,4860138.6995518152,4614417.519319348,4370901.0347260293,4129715.3543624184,3890993.8002304547,3935054.9891005866,3981870.2624700349,4031597.153972161,4084402.2081641536,4140461.4959518733,4199961.1594969956,4263097.988292844,4330080.0281917593,4401127.2252688389,4476472.1065146709,4556360.49946371,4641052.2929853797,4730822.2415924324,4825960.8157557547,3759020.3758571642,3869922.164099819,3987167.5346299536,4111119.3403544119,4242161.189366309,4380698.632141687,4527160.416643817,4681999.8152194684,4845696.0273936465,5018755.662904188]
[null,"Cost Of Generation per kWh",null,"INR",null,null,null,{"$f":"H16/H7","v":3.8542983582870072},3.9082554066013269,3.7831351082395415,3.6561764841501736,3.5274290226419631,3.3969484128885097,3.2647970054616975,3.1310443046361667,2.9957674946276884,2.8590520020751637,2.7209920972328612,2.7796003177682822,2.84107996886936,2.9056164646284905,2.9734077259307736,3.0446650287749728,3.1196139101728995,3.1984951355355413,3.2815657317195592,3.3691000901910604,3.4613911450660995,3.5587516311104306,3.6615154271259924,3.7700389905200642,3.8847028892464452,3.0564233049160294,3.1783802848826896,3.3077518262247074,3.4450324958293996,3.5907503430581347,3.7454691716059187,3.9097909655630656,4.084358480145899,4.2698580082739621,4.4670223349298421]
[null,"Discount factor",null,null,null,null,null,1,{"$f":"H18/(1+Discount_rate)","v":0.9129918743723181},0.8335541626698787,0.76102817736682071,0.69481254210428267,0.6343582051531842,0.57916388674626518,0.52877192252922967,0.48276446866541561,0.44076003712719403,0.40241033244516938,0.36739736368590287,0.33543080771104072,0.3062456018543237,0.27959974605525767,0.25527229622501385,0.23306153220580103,0.21278328513265868,0.19426941032836545,0.17736639306889934,0.16193407565863174,0.14784449526032298,0.13498082284335158,0.12323639445206938,0.11251382676168117,0.10272420958794959,9.3786368655116956E-2,8.562619250900845E-2,7.8176017994164571E-2,7.137406919945638E-2,6.5163945219991221E-2,5.9494152487894844E-2,5.4317677794115629E-2,4.9591598460801273E-2,4.5276726431846319E-2]
[null,"Present value",null,"INR",null,null,null,{"$f":"H17*H18","v":3.8542983582870072},{"$f":"I17*I18","v":3.5682054291986915},3.1534480174156321,2.7824533258642372,2.4509019263142875,2.1548820981979127,1.8908525231207642,1.6556083164866608,1.4462501027890593,1.2601558665832275,1.0949553344281544,1.0212178288485647,0.95298574872950781,0.88983226296798434,0.83136404508898554,0.77721863313138517,0.72706199779542613,0.68058630242008089,0.63750783965492985,0.59756513088529184,0.56051717556925174,0.52614183865837272,0.49423436520709241,0.46460601213541208,0.43708278790127686,{"$f":"AG17*AG18","v":0.31396866816368774},0.29808874512416356,0.28323019464434107,0.26931892238444083,0.25628646346340306,0.244069547921694,0.23260969990100264,0.22185286792022876,0.211749083830959,0.20225214822356585]
[null,"Levelised Cost of generation",null,"INR",null,{"$f":"SUM(OFFSET(H19,0,0,1,'RE Inputs & Results'!F16))/SUM(OFFSET(H18,0,0,1,'RE Inputs & Results'!F16))","v":3.3851886921114334}]
[null,"Average Cost of Generation",null,"INR",null,{"$f":"AVERAGE(OFFSET(H17,0,0,1,'RE Inputs & Results'!F16))","v":3.3178976061400829}]
[]
[null,"Debt"]
[null,"Debt opening balance",null,"INR",null,null,null,{"$f":"Debt","v":23450000},{"$f":"H26","v":23450000},{"$f":"I26","v":20844444.444444444},{"$f":"J26","v":18238888.888888888},15633333.333333332,13027777.777777776,10422222.22222222,7816666.6666666642,5211111.1111111082,2605555.5555555527,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AF26","v":0},0,0,0,0,0,0,0,0,0]
[null,"Debt repayment",null,"INR",null,null,null,{"$f":"IF(H3>Moratorium, IF(H24>0.001, Debt/(Loan_tenure-Moratorium), 0), 0)","v":0},2605555.5555555555,2605555.5555555555,2605555.5555555555,2605555.5555555555,2605555.5555555555,2605555.5555555555,2605555.5555555555,2605555.5555555555,2605555.5555555555,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",null,"INR",null,null,null,{"$f":"H24-H25","v":23450000},{"$f":"I24-I25","v":20844444.444444444},{"$f":"J24-J25","v":18238888.888888888},{"$f":"K24-K25","v":15633333.333333332},13027777.777777776,10422222.22222222,7816666.6666666642,5211111.1111111082,2605555.5555555527,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AG24-AG25","v":0},0,0,0,0,0,0,0,0,0]
[null,"Interest",null,"INR",null,null,null,{"$f":"Interest*H24","v":2473975},2473975,2199088.888888889,1924202.7777777775,1649316.6666666665,1374430.5555555553,1099544.4444444443,824658.33333333302,549772.2222222219,274886.11111111077,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",null,"INR",null,null,null,{"$f":"H25+H27","v":2473975},{"$f":"I25+I27","v":5079530.555555556},4804644.444444444,4529758.333333333,4254872.222222222,3979986.111111111,3705100,3430213.8888888885,3155327.7777777775,2880441.666666666,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AG25+AG27","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Working Capital"]
[null,"Operation and Maintenance wcap",null,"INR",null,null,null,{"$f":"H8/(12/Workingcapital_OandM)","v":39083.333333333336},41318.9,43682.341079999998,46180.970989775997,48822.522530391179,51615.170819129562,54567.558589983768,57688.822941330844,60988.623613574971,64477.172884271458,68165.267173251792,72064.320455561785,76186.399585619933,80544.261641917386,85151.393407835058,90022.053110763241,95171.314548698894,100615.11374088447,106370.29824686307,112454.67930658364,118887.08696292022,125687.42833719926,132876.74923808707,140477.29929450565,148512.60081415137,157007.52158072082,165988.35181513804,175482.88553896395,185520.50659179268,196132.27956884322,207351.04596018107,219211.52578910344,231750.42506424015,245006.54937791466,259020.92400233142]
[null,"Interest on working capital - O&M",null,null,null,null,null,{"$f":"H31*Interest_working_capital","v":4514.1250000000009},4772.33295,5045.3103947400004,5333.9021493191276,5639.0013522601812,5961.552229609465,6302.5530171431255,6663.0590497237126,7044.1860273679094,7447.1134681333542,7873.0883585105821,8323.4290126173873,8799.5291521391027,9302.8622196414581,9834.9859386049502,10397.547134293154,10992.286830374724,11621.045637072157,12285.769447512685,12988.515459910412,13731.458544217287,14516.897972946515,15347.264536999057,16225.128068515403,17153.205394034485,18134.368742573253,19171.654634648443,20268.273279750338,21427.618511352055,22653.278290201393,23949.045808400915,25318.93122864145,26767.174094919737,28298.256453149144,29916.916722269281]
[null,"Maintenance spares wcap",null,"INR",null,null,null,{"$f":"IF(ISNUMBER(Workingcapital_spares),H31*Workingcapital_spares,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,0,0,0,0,0,0,0,0,0,0]
[null,"Fuel cost wcap",null,null,null,null,null,{"$f":"IF(OR(Technology=\"Biomass\",Technology=\"Bagasse\"),H15/(12/Bio_workingcapital_fuel),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,0,0,0,0,0,0,0,0,0,0]
[null,"Receivables wcap",null,"INR",null,null,null,{"$f":"IF(Workingcapital_receivables>0, (H8+H9+H11+H12+H14+H32)/(12/Workingcapital_receivables),0)","v":996539.85416666663},1000385.6971583333,958675.39870727155,917238.08030073473,876089.35639727011,835245.73460245319,794724.66675689875,754544.60294650448,714725.04860208149,675286.62486508361,636251.13240625535,643455.97074655991,651111.15402992966,659242.44198710832,667877.0678054376,677043.82241057535,686773.14356912684,697097.21008794766,708050.04140164482,719667.60285648564,731987.91701654333,745051.18133655621,758899.89256567403,773578.97826709703,789135.93586064177,614670.97961853712,632805.52106938418,651977.35829121957,672245.82460214407,693673.64718605333,716327.14122176229,740276.41511631384,765595.58747763361,792363.01649802085,820661.5424583744]
[null,"Interest on reveivables wcap",null,"INR",null,null,null,{"$f":"H35*Interest_working_capital","v":115100.35315625},115544.5480217875,110727.00855068988,105940.99827473487,101188.3206638847,96470.882346583341,91790.699010421813,87149.901640321274,82550.743113540419,77995.605171917166,73487.0057929225,74319.164621227668,75203.338290456886,76142.502049511022,77139.80133152804,78198.561488421459,79322.298082234149,80514.727765157964,81779.779781889985,83121.60812992409,84544.604415410766,86053.41144437225,87652.937591335358,89348.371989849707,91145.200591904126,70994.498145941048,73089.037683513874,75303.384882635859,77644.39274154765,80119.306249989168,82735.784811113554,85501.925945934257,88426.290353666685,91517.928405521408,94786.408153942248]
[]
[null,"Financials"]
[null,"Cash Flow",null,"INR"]
[null,"Equity IRR",null,"%"]
[null,"Cumulative Cash Flow",null,"INR",null,null,null,{"$f":"H39","v":0},{"$f":"H41+I39","v":0},{"$f":"I41+J39","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":"AF41+AG39","v":0},0,0,0,0,0,0,0,0,0]
[null,"Asset value",null,null,null,null,null,{"$f":"Gross_capex","v":33500000},{"$f":"H42-H10","v":32354300},{"$f":"I42-I10","v":31208600},30062900,28917200,27771500,26625800,25480100,24334400,23188700,22043000,20897300,19751600,18605900,17460200,16314500,15168800,14023100,12877400,11731700,10586000,9440300,8294600,7148900,6003200,4857500,4857500,4857500,4857500,4857500,4857500,4857500,4857500,4857500,4857500]

{"sheet":"Reference values","index":4,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Assumption",null,"Unit",null,"Solar PV",null,"Wind",null,"Biomass",null,"Bagasse",null,"Small Hydro"]
[null,"Capital cost",null,"INR/kW",null,33500,null,52500,null,55000,null,52000,null,74300]
[null,"Auxiliary Consumption",null,"%",null,0,null,0,null,10,null,8.5,null,1]
[null,"Capacity utilisation factor",null,"%",null,19,null,29,null,80,null,55,null,30]
[null,"Station heat rate",null,"kCal/kWh",null,null,null,null,null,3840,null,3240]
[null,"Calorific value ",null,"kCal/kg",null,null,null,null,null,3200,null,2300]
[null,"Specific fuel consumption",null,"kg/kWh",null,null,null,null,null,1.2,null,1.41]
[null,"Fuel rate",null,"INR/MT",null,null,null,null,null,2967.35,null,1834.35]
[null,"Fuel cost escalation",null,"%",null,null,null,null,null,0.05,null,0.05]
[null,"Grid availability factor",null,"%",null,95,null,95]
[null,"Annual degradation",null,"%",null,1,null,1.6]
[null,"Operation and Maintenance Expenses in year 1",null,null,null,1.4,null,9.7000000000000003E-3,null,4.3899999999999997,null,4.3,null,3.56]
[null,"Annual increase in Operation and Maintenance Expenses",null,"%",null,5.72,null,5,null,5.72,null,5.72,null,5.72]
[null,"Insurance (% of depreciated asset value)",null,"%",null,0.35,null,0.25,null,null,null,null,null,0.35]
[null,"Equity",null,"%",null,30,null,30,null,30,null,30,null,30]
[null,"Loan tenure",null,"years",null,10,null,10,null,10,null,10,null,13]
[null,"Moratorium",null,"years",null,1,null,1,null,1,null,1,null,1]
[null,"Interest on loan",null,"%",null,10.55,null,9.9499999999999993,null,9.9499999999999993,null,9.9499999999999993,null,9.9700000000000006]
[null,"Working Capital - O&M",null,"months",null,1,null,1,null,1,null,1,null,1]
[null,"Working Capital – Receivables",null,"months",null,2,null,2,null,2,null,2,null,2]
[null,"Interest on Working Capital",null,"%",null,11.55,null,10.95,null,10.95,null,10.95,null,10.97]
[null,"Depreciation Rate",null,"%",null,3.6,null,3.6,null,4.5,null,4.5,null,"First 13 years: 5.28%\nAfter: 0.97"]
[null,"Capital cost on which depreciation rate applies",null,"%",null,95,null,95,null,85,null,85]
[null,"Discount rate",null,"%",null,9.5299999999999994,null,8.75]
[null,"Return on Equity",null,"%",null,17.600000000000001,null,17.559999999999999,null,17.559999999999999,null,17.559999999999999,null,17.559999999999999]
[null,"Economic Life",null,"years",null,25,null,25,null,20,null,20,null,35]
[null,"REFERENCES",null,null,null,"Order on generic tariff for solar power and related issues",null,"Order on generic tariff for wind power and related issues",null,"Comprehensive tariff order for Biomass based power plants",null,"Comprehensive tariff order for bagasse based co-generation power plants",null,"CERC RE Tariff order 2018-19"]

{"sheet":"Storage Inputs & Results","index":5,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[7,1,7,5],[7,10,7,12]]}
[]
[]
[null,null,null,"Select Technology/Scenario:"]
[]
[]
[]
[]
[null,"Inputs",null,null,null,null,null,null,"Solar+Storage",null,"System size & outputs"]
[]
[null,"Parameter",null,"Unit",null,"Value",null,null,null,null,"Solar PV size","kW",{"$f":"SolarPV_size","v":24}]
[null,null,null,null,null,null,null,null,null,null,"Inverter capacity","kW",{"$f":"Storage_inverter_capacity","v":12}]
[null,"General inputs",null,null,null,null,null,null,null,null,"Battery capacity","kWh",{"$f":"Storage_power_capacity*Storage_duration","v":48}]
[null,"Current year",null,"year",null,2020,null,null,null,null,"Battery life","years",{"$f":"ROUND(Storage_life_cycles/Storage_annual_cycles,0)","v":11}]
[null,"Base year for LCOS calculation",null,"year",null,2020,null,null,null,null,"Solar generated passing through battery (Year 1)","%",{"$f":"IF(I8=\"Standalone\", \"-\", IF('LCOS calc'!H95>'LCOS calc'!H94*Storage_excess_solar, Storage_excess_solar, 'LCOS calc'!H95/'LCOS calc'!H94))","v":0.43859649122807021}]
[null,"Discount rate",null,"%",null,9.5299999999999996E-2,null,null,null,null,"Solar exported (Year 1)","%",{"$f":"IF(I8=\"Standalone\", \"-\", IF('LCOS calc'!H95>'LCOS calc'!H94*Storage_excess_solar, 0, ('LCOS calc'!H94*Storage_excess_solar-'LCOS calc'!H95)/'LCOS calc'!H94))","v":6.1403508771929807E-2}]
[null,"Equity",null,"%",null,0.3,null,null,null,null,"Net capital cost","INR",{"$f":"Storage_module_capexperkWh*(1-Storage_capitalsubsidy_percentage)*Storage_capacity+Storage_invertercapex_perkW*Storage_inverter_capacity+Storage_rack_capexperkW*Storage_power_capacity+Storage_EPC_capexperkW*Storage_power_capacity+SolarPV_capex_perkW*(1-SolarPV_capitalsubsidy_perkW)*SolarPV_size","v":2264400}]
[null,"Return on Equity",null,"%",null,0.17599999999999999,null,null,null,null,"Equity","INR",{"$f":"Storage_net_capex*Storage_equity_percentage","v":679320}]
[null,"Loan tenure",null,"years",null,10,null,null,null,null,"Debt","INR",{"$f":"Storage_net_capex-Storage_equity","v":1585080}]
[null,"Moratorium",null,"years",null,1,null,null,null,null,"Annual Depreciation","INR",{"$f":"(Storage_module_capexperkWh*(1-Storage_capitalsubsidy_percentage)*Storage_capacity*Storage_depreciationrate_storage+Storage_invertercapex_perkW*Storage_inverter_capacity*Storage_depreciationrate_inverter+Storage_rack_capexperkW*Storage_power_capacity*Storage_depreciationrate_storage+Storage_EPC_capexperkW*Storage_power_capacity*Storage_depreciationrate_storage+SolarPV_capex_perkW*(1-SolarPV_capitalsubsidy_perkW)*SolarPV_size*Storage_depreciationrate_solarPV)*Storage_depreciation_on_capexpercentage","v":130304.86993006992}]
[null,"Interest on loan",null,"%",null,0.1055]
[null,"Annual increase in Operation and Maintenance Expenses",null,"%",null,5.7200000000000001E-2]
[null,"Insurance (% of depreciated asset value)",null,"%",null,3.5000000000000001E-3]
[null,"Working Capital - O&M",null,"months",null,1]
[null,"Working Capital - Receivables",null,"months",null,2]
[null,"Interest on Working Capital",null,"%",null,0.11550000000000001]
[null,"Percentage of capital cost on which depreciation applies",null,"%",null,0.95]
[]
[null,"Solar PV-specific inputs"]
[null,"System capital cost per kW (w/o solar PCU cost)",null,"INR",null,41000]
[null,"Capital subsidy per kW",null,"INR",null,0]
[null,"Solar PV size",null,"kW",null,24]
[null,"Life of solar plant",null,"years",null,25]
[null,"CUF",null,"%",null,0.19]
[null,"Operation and Maintenance Expenses in year 1",null,"%",null,1.4E-2]
[null,"Depreciation rate",null,"%",null,3.5999999999999997E-2]
[null,"Annual solar panel degradation",null,"%",null,0.02]
[]
[null,"Inverter-specific inputs"]
[null,"Inverter capital cost per kW in base year",null,"INR/kW",null,20000]
[null,"Inverter capacity",null,"kW",null,12]
[null,"Inverter replacement year",null,"years",null,14]
[null,"Cost improvement in replacement year",null,"%",null,0.6]
[null,"O&M expenses in Year 1 - Power",null,"%",null,0.01]
[null,"Depreciation rate",null,"%",null,{"$f":"0.9/(Storage_inverter_replacementyear-1)","v":6.9230769230769235E-2}]
[]
[null,"Battery storage-specific inputs"]
[null,"Battery pack capital cost per kWh in current year",null,"INR/kWh",null,20000]
[null,"Battery pack capital cost per kWh in base year",null,"INR/kWh",null,{"$f":"F47*VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$49, 3)/VLOOKUP(2020, 'Cost projections'!$B$4:$D$49, 3)","v":20000}]
[null,"Capital subsidy per kWh",null,"%",null,0]
[null,"Cost for storage container and others",null,"INR/kW",null,5500]
[null,"EPC cost",null,"INR/kW",null,1200]
[null,"Battery power capacity",null,"kW",null,12]
[null,"Storage duration (E to P ratio) at 100% DoD",null,"hr",null,4]
[null,"Storage round trip efficiency",null,"%",null,0.97]
[null,"Depth of Discharge",null,"%",null,0.8]
[null,"Storage cycles per year at given DoD",null,"cycles",null,365]
[null,"End of life capacity relative to initial capacity",null,"%",null,0.8]
[null,"Storage cycle life",null,"cycles",null,4000]
[null,"Storage shelf life",null,"years",null,13]
[null,"Cycle degradation",null,"%",null,{"$f":"1-Storage_endoflife_capacity^(1/Storage_life_cycles)","v":5.5784331824848543E-5}]
[null,"Time degradation",null,"%",null,{"$f":"1-Storage_endoflife_capacity^(1/Storage_shelf_life)","v":1.7018411149872348E-2}]
[null,"Excess solar generation available for storage",null,"%",null,0.5]
[null,"O&M expenses in Year 1 - Energy",null,"%",null,6.7999999999999996E-3]
[null,"Depreciation rate",null,"%",null,{"$f":"0.9/Storage_life","v":8.1818181818181818E-2}]
[null,"Consumer category",null,null,null,"LT Industries"]
[null,"Electricity tariff for charging battery",null,"INR/kWh",null,{"$f":"VLOOKUP(Storage_charging_source,'Storage charging cost'!B4:D18,3,0)","v":6.35}]
[null,"Cost escalation for input electricty ",null,"%",null,0.05]

{"sheet":"LCOS calc","index":6,"n_rows":109,"n_cols":32,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["This sheet shows the LCOS calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year ----->"]
[null,"Parameter",null,"Unit",null,"Cumulative",null,1,{"$f":"H3+1","v":2},{"$f":"I3+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,null,null,null,{"$f":"Storage_base_year","v":2020},{"$f":"H6+1","v":2021},{"$f":"I6+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,null,null,null,{"$f":"IF(MOD(H3,Storage_life)=0, Storage_life, MOD(H3,Storage_life))","v":1},2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11,1,2,3]
[null,"Battery pack cost per kWh in year n",null,"INR",null,null,null,{"$f":"IF(H7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!H6, 'Cost projections'!$B$4:$D$49, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$49, 3)), 0)","v":20000},{"$f":"IF(I7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!I6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(J7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!J6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(K7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!K6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(L7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!L6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(M7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!M6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(N7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!N6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(O7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!O6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(P7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!P6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(Q7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!Q6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(R7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!R6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(S7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!S6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":7999.9999999999991},{"$f":"IF(T7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!T6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(U7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!U6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(V7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!V6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(W7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!W6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(X7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!X6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(Y7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!Y6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(Z7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!Z6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(AA7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!AA6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(AB7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!AB6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(AC7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!AC6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(AD7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!AD6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":5454.545454545454},{"$f":"IF(AE7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!AE6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0},{"$f":"IF(AF7=1, (Storage_module_capexperkWh*VLOOKUP('LCOS calc'!AF6, 'Cost projections'!$B$4:$D$39, 3)/VLOOKUP(Storage_base_year, 'Cost projections'!$B$4:$D$39, 3)), 0)","v":0}]
[null,"Gross capital cost",null,"INR",null,null,null,{"$f":"IF(H7=1, (Storage_capacity*H8+Storage_rack_capexperkW*Storage_power_capacity+Storage_EPC_capexperkW*Storage_power_capacity), 0)","v":1040400},0,0,0,0,0,0,0,0,0,0,464399.99999999994,0,0,0,0,0,0,0,0,0,0,342218.18181818177,0,0]
[null,"Net capital cost",null,"INR",null,null,null,{"$f":"IF(H7=1, (Storage_capacity*H8*(1-Storage_capitalsubsidy_percentage)+Storage_rack_capexperkW*Storage_power_capacity+Storage_EPC_capexperkW*Storage_power_capacity), 0)","v":1040400},0,0,0,0,0,0,0,0,0,0,464399.99999999994,0,0,0,0,0,0,0,0,0,0,342218.18181818177,0,0]
[null,"Equity",null,"INR",null,null,null,{"$f":"H10*Storage_equity_percentage","v":312120},0,0,0,0,0,0,0,0,0,0,139319.99999999997,0,0,0,0,0,0,0,0,0,0,102665.45454545453,0,0]
[null,"Debt",null,"INR",null,null,null,{"$f":"H10-H11","v":728280},{"$f":"I10-I11","v":0},0,0,0,0,0,0,0,0,0,325080,0,0,0,0,0,0,0,0,0,0,239552.72727272724,0,0]
[null,"Annual depreciation (on gross capital cost)",null,"INR",null,null,null,{"$f":"IF(H7=1, H9*Storage_depreciationrate_storage*Storage_depreciation_on_capexpercentage, G13)","v":80867.454545454544},80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,26599.685950413215,26599.685950413215,26599.685950413215]
[null,"Annual depreciation (on net capital cost)",null,"INR",null,null,null,{"$f":"IF(H7=1, H10*Storage_depreciationrate_storage*Storage_depreciation_on_capexpercentage, G14)","v":80867.454545454544},80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,80867.454545454544,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,36096.545454545449,26599.685950413215,26599.685950413215,26599.685950413215]
[null,"Asset value",null,"INR",null,null,null,{"$f":"IF(H7=1, H9, G15-G13)","v":1040400},{"$f":"IF(I7=1, I9, H15-H13)","v":959532.54545454541},{"$f":"IF(J7=1, J9, I15-I13)","v":878665.09090909082},797797.63636363624,716930.18181818165,636062.72727272706,555195.27272727247,474327.81818181794,393460.36363636341,312592.90909090888,231725.45454545435,464399.99999999994,428303.45454545447,392206.909090909,356110.36363636353,320013.81818181806,283917.27272727259,247820.72727272715,211724.18181818171,175627.63636363627,139531.09090909082,103434.54545454538,342218.18181818177,315618.49586776854,289018.80991735531]
[null,"Operation and Maintenance Expenses",null,"INR",null,null,null,{"$f":"IF(H7=1,H9*Storage_OndMenergy_year1, G16+(G16*Storage_OandM_escalation))","v":7074.7199999999993},7479.3939839999994,7907.2153198847991,8359.5080361822093,8837.6718958518322,9343.1867282945568,9877.6170091530057,10442.616702076557,11039.934377435337,11671.418623824638,12339.023769107407,3157.9199999999996,3338.5530239999998,3529.5182569727999,3731.4067012716441,3944.8431645843821,4170.4881935986086,4409.040118272449,4661.2372130376334,4927.8599816233864,5209.7335725722442,5507.7303329233764,2327.0836363636358,2460.1928203636357,2600.9158496884356]
[null,"Insurance",null,"INR",null,null,null,{"$f":"Storage_insurance*H15","v":3641.4},3358.3639090909091,3075.3278181818177,2792.2917272727268,2509.2556363636359,2226.2195454545449,1943.1834545454537,1660.1473636363628,1377.1112727272721,1094.0751818181811,811.03909090909031,1625.3999999999999,1499.0620909090908,1372.7241818181815,1246.3862727272724,1120.0483636363633,993.71045454545413,867.37254545454505,741.03463636363597,614.69672727272689,488.35881818181792,362.02090909090884,1197.7636363636361,1104.6647355371899,1011.5658347107436]
[null,"Interest on Term Loan",null,"INR",null,null,null,{"$f":"H26","v":76833.539999999994},{"$f":"I26","v":76833.539999999994},69150.186000000002,61466.831999999995,53783.477999999996,46100.123999999996,38416.769999999997,30733.415999999997,23050.061999999998,15366.707999999999,7683.3539999999994,34295.94,34295.94,30866.345999999998,27436.752,24007.157999999999,20577.563999999998,17147.97,13718.376,10288.781999999999,6859.1880000000001,3429.5940000000001,25272.812727272722,25272.812727272722,22745.531454545449]
[null,"Interest on Working Capital",null,"INR",null,null,null,{"$f":"H31+H33","v":4368.8970079649989},{"$f":"I31+I33","v":4375.2085030045982},4234.2881021001613,4094.0788463930903,3954.6214133886747,3815.958807345507,3678.1364923657702,3541.2025330982924,3405.2077434898142,3270.2058440448322,3136.2536280806958,1950.130498365,1952.9477400954777,1890.0455542246391,1827.4607999470886,1765.211634349962,1703.3172531057799,1641.7979498795305,1580.6751791338397,1519.971622526595,1459.7112591065165,1399.919439523909,1437.0588145104541,1439.1348509935433,1392.7819834631646]
[null,"Return on Equity",null,"INR",null,null,null,{"$f":"OFFSET(H11,0,1-H7)*Storage_ROE","v":54933.119999999995},54933.119999999995,54933.119999999995,54933.119999999995,54933.119999999995,54933.119999999995,54933.119999999995,54933.119999999995,54933.119999999995,54933.119999999995,54933.119999999995,24520.319999999992,24520.319999999992,24520.319999999992,24520.319999999992,24520.319999999992,24520.319999999992,24520.319999999992,24520.319999999992,24520.319999999992,24520.319999999992,24520.319999999992,18069.119999999995,18069.119999999995,18069.119999999995]
[]
[null,"Debt"]
[null,"Debt opening balance",null,"INR",null,null,null,{"$f":"IF(H7=1, H12, G25)","v":728280},728280,655452,582624,509796,436968,364140,291312,218484,145656,72828,325080,325080,292572,260064,227556,195048,162540,130032,97524,65016,32508,239552.72727272724,239552.72727272724,215597.4545454545]
[null,"Debt repayment",null,"INR",null,null,null,{"$f":"IF(H7>Storage_moratorium, IF(H23>0, OFFSET(H12,0,1-H7)/(Storage_life-Storage_moratorium), 0), 0)","v":0},72828,72828,72828,72828,72828,72828,72828,72828,72828,72828,0,32508,32508,32508,32508,32508,32508,32508,32508,32508,32508,0,23955.272727272724,23955.272727272724]
[null,"Debt closing balance",null,"INR",null,null,null,{"$f":"H23-H24","v":728280},{"$f":"I23-I24","v":655452},{"$f":"J23-J24","v":582624},{"$f":"K23-K24","v":509796},436968,364140,291312,218484,145656,72828,0,325080,292572,260064,227556,195048,162540,130032,97524,65016,32508,0,239552.72727272724,215597.4545454545,191642.18181818177]
[null,"Interest",null,"INR",null,null,null,{"$f":"Storage_interest*H23","v":76833.539999999994},76833.539999999994,69150.186000000002,61466.831999999995,53783.477999999996,46100.123999999996,38416.769999999997,30733.415999999997,23050.061999999998,15366.707999999999,7683.3539999999994,34295.94,34295.94,30866.345999999998,27436.752,24007.157999999999,20577.563999999998,17147.97,13718.376,10288.781999999999,6859.1880000000001,3429.5940000000001,25272.812727272722,25272.812727272722,22745.531454545449]
[null,"Total debt service",null,"INR",null,null,null,{"$f":"H24+H26","v":76833.539999999994},{"$f":"I24+I26","v":149661.53999999998},141978.18599999999,134294.83199999999,126611.478,118928.124,111244.76999999999,103561.416,95878.062000000005,88194.707999999999,80511.353999999992,34295.94,66803.94,63374.345999999998,59944.752,56515.157999999996,53085.563999999998,49655.97,46226.376000000004,42796.781999999999,39367.188000000002,35937.593999999997,25272.812727272722,49228.085454545449,46700.804181818174]
[]
[null,"Working Capital"]
[null,"Operation and Maintenance wcap",null,"INR",null,null,null,{"$f":"H16/(12/Storage_workingcapital_OandM)","v":589.55999999999995},623.28283199999998,658.93460999039996,696.62566968185081,736.47265798765272,778.59889402454644,823.13475076275051,870.21805850637975,919.99453145294467,972.6182186520532,1028.2519807589506,263.15999999999997,278.21275199999997,294.12652141439997,310.95055843930368,328.73693038203186,347.54068279988405,367.42000985603744,388.43643441980277,410.65499846861553,434.14446438102033,458.9775277436147,193.92363636363632,205.01606836363632,216.74298747403631]
[null,"Interest on working capital - O&M",null,null,null,null,null,{"$f":"H30*Storage_interest_workingcap","v":68.094179999999994},71.989167096000003,76.106947453891195,80.460264848253772,85.06259199757389,89.928172259835122,95.072063713097691,100.51018575748687,106.25936838281511,112.33740425431215,118.7631037776588,30.394979999999997,32.133572856000001,33.9716132233632,35.914789499739577,37.96911545912468,40.140948863386612,42.437011138372327,44.86440817548722,47.430652323125095,50.143685636007852,53.011904454387498,22.398179999999996,23.679355895999997,25.033815053251196]
[null,"Receivables wcap",null,"INR",null,null,null,{"$f":"IF(Storage_workingcapital_receivables>0, (H16+H17+H14+H18+H20+H31)/(12/Storage_workingcapital_receivables),0)","v":37236.388120909083},37257.31026760691,36001.568438495844,34749.944428959621,33502.673778277931,32260.005498577244,31022.202845477685,29789.544132820825,28562.32359399999,27340.852292558611,26125.459084874779,16621.086739090908,16630.425690385087,16069.904251093298,15511.220869674018,14954.480683037553,14399.794841925481,13847.280854901801,13297.062952020367,12749.272469294112,12204.048255155918,11661.537100169016,12248.144021735534,12255.02593158046,11841.975484068515]
[null,"Interest on reveivables wcap",null,"INR",null,null,null,{"$f":"H32*Storage_interest_workingcap","v":4300.8028279649989},4303.2193359085986,4158.1811546462704,4013.6185815448366,3869.558821391101,3726.0306350856717,3583.0644286526726,3440.6923473408056,3298.9483751069993,3157.8684397905199,3017.4905243030371,1919.735518365,1920.8141672394777,1856.0739410012759,1791.5460104473491,1727.2425188908373,1663.1763042423931,1599.3609387411582,1535.8107709583526,1472.5409702034699,1409.5675734705087,1346.9075350695214,1414.6606345104542,1415.4554950975432,1367.7481684099134]
[]
[null,"Inverter cost timeline"]
[null,"Year",null,null,null,null,null,{"$f":"Storage_base_year","v":2020},{"$f":"H36+1","v":2021},{"$f":"I36+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,null,null,null,{"$f":"IF(MOD(H3,Storage_inverter_replacementyear-1)=0, Storage_inverter_replacementyear-1, MOD(H3,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",null,"INR",null,null,null,{"$f":"IF(H37=1, IF(H36=Storage_base_year, Storage_invertercapex_perkW, Storage_invertercapex_perkW*Storage_inverter_costimprovement), 0)","v":20000},0,0,0,0,0,0,0,0,0,0,0,0,12000,0,0,0,0,0,0,0,0,0,0,0]
[null,"Capital cost",null,"INR",null,null,null,{"$f":"IF(H37=1, Storage_inverter_capacity*H38, 0)","v":240000},0,0,0,0,0,0,0,0,0,0,0,0,144000,0,0,0,0,0,0,0,0,0,0,0]
[null,"Equity",null,"INR",null,null,null,{"$f":"H39*Storage_equity_percentage","v":72000},0,0,0,0,0,0,0,0,0,0,0,0,43200,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt",null,"INR",null,null,null,{"$f":"H39-H40","v":168000},0,0,0,0,0,0,0,0,0,0,0,0,100800,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual depreciation",null,"INR",null,null,null,{"$f":"IF(H37=1, H39*Storage_depreciationrate_inverter*Storage_depreciation_on_capexpercentage, G42)","v":15784.615384615385},15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,15784.615384615385,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305,9470.7692307692305]
[null,"Asset value",null,"INR",null,null,null,{"$f":"IF(H37=1, H39, G43-G42)","v":240000},224215.38461538462,208430.76923076925,192646.15384615387,176861.5384615385,161076.92307692312,145292.30769230775,129507.69230769236,113723.07692307697,97938.461538461575,82153.846153846185,66369.230769230795,50584.615384615412,144000,134529.23076923078,125058.46153846155,115587.69230769231,106116.92307692308,96646.153846153844,87175.38461538461,77704.615384615376,68233.846153846142,58763.076923076907,49292.307692307673,39821.538461538439]
[null,"Operation and Maintenance Expenses",null,"INR",null,null,null,{"$f":"IF(H37=1,H39*Storage_OandMpower_year1, G44+(G44*Storage_OandM_escalation))","v":2400},2537.2800000000002,2682.4124160000001,2835.8464061952,2998.0568206295652,3169.5456707695762,3350.8436831375961,3542.5119418130666,3745.143624884774,3959.3658402281831,4185.8415662892348,4425.2717038809787,4678.3972453429706,1440,1522.3679999999999,1609.4474496,1701.5078437171201,1798.8340923777394,1901.7274024617461,2010.5062098825581,2125.5071650878403,2247.0861749308647,2375.6195041369101,2511.5049397735415,2655.1630223285883]
[null,"Insurance",null,"INR",null,null,null,{"$f":"Storage_insurance*H43","v":840},784.75384615384621,729.50769230769242,674.26153846153852,619.01538461538473,563.76923076923094,508.5230769230771,453.27692307692325,398.03076923076941,342.78461538461551,287.53846153846166,232.29230769230779,177.04615384615394,504,470.85230769230776,437.70461538461541,404.55692307692311,371.40923076923076,338.26153846153846,305.11384615384617,271.96615384615382,238.81846153846149,205.67076923076917,172.52307692307687,139.37538461538455]
[null,"Interest on term loan",null,"INR",null,null,null,{"$f":"H54","v":17724},{"$f":"I54","v":17724},15754.666666666668,13785.333333333334,11816,9846.6666666666661,7877.3333333333321,5907.9999999999982,3938.6666666666647,1969.333333333331,0,0,0,10634.4,10634.4,9452.7999999999993,8271.1999999999989,7089.5999999999995,5908,4726.3999999999996,3544.7999999999997,2363.1999999999998,1181.5999999999999,0,0]
[null,"Interest on working capital",null,"INR",null,null,null,{"$f":"H59+H61","v":974.89152115384627},{"$f":"I59+I61","v":977.81742810230776},943.06186180155464,908.54754158173171,874.28826671866818,840.29862580677093,806.59404190804651,773.19082028364824,740.1061988556678,707.35840155534004,674.96669472276733,680.86111339937111,687.15352436427668,584.93491269230765,586.69045686138463,565.83711708093267,545.12852494903905,524.57296003120098,504.17917548406263,483.95642514482796,463.91449217018902,444.06371931340067,424.41504093320412,404.98001683366033,408.51666803962263]
[null,"Return on equity",null,"INR",null,null,null,{"$f":"OFFSET(H40,0,1-H37)*Storage_ROE","v":12672},12672,12672,12672,12672,12672,12672,12672,12672,12672,12672,12672,12672,7603.2,7603.2,7603.2,7603.2,7603.2,7603.2,7603.2,7603.2,7603.2,7603.2,7603.2,7603.2]
[]
[null,"Debt"]
[null,"Debt opening balance",null,"INR",null,null,null,{"$f":"IF(H37=1, H41, G53)","v":168000},168000,149333.33333333334,130666.66666666667,112000,93333.333333333328,74666.666666666657,55999.999999999985,37333.333333333314,18666.666666666646,0,0,0,100800,100800,89600,78400,67200,56000,44800,33600,22400,11200,0,0]
[null,"Debt repayment",null,"INR",null,null,null,{"$f":"IF(H37>Storage_moratorium, IF(H51>0, OFFSET(H41,0,1-H37)/(Storage_loan_tenure-Moratorium), 0), 0)","v":0},18666.666666666668,18666.666666666668,18666.666666666668,18666.666666666668,18666.666666666668,18666.666666666668,18666.666666666668,18666.666666666668,18666.666666666668,0,0,0,0,11200,11200,11200,11200,11200,11200,11200,11200,11200,0,0]
[null,"Debt closing balance",null,"INR",null,null,null,{"$f":"H51-H52","v":168000},{"$f":"I51-I52","v":149333.33333333334},{"$f":"J51-J52","v":130666.66666666667},{"$f":"K51-K52","v":112000},93333.333333333328,74666.666666666657,55999.999999999985,37333.333333333314,18666.666666666646,0,0,0,0,100800,89600,78400,67200,56000,44800,33600,22400,11200,0,0,0]
[null,"Interest",null,"INR",null,null,null,{"$f":"Storage_interest*H51","v":17724},17724,15754.666666666668,13785.333333333334,11816,9846.6666666666661,7877.3333333333321,5907.9999999999982,3938.6666666666647,1969.333333333331,0,0,0,10634.4,10634.4,9452.7999999999993,8271.1999999999989,7089.5999999999995,5908,4726.3999999999996,3544.7999999999997,2363.1999999999998,1181.5999999999999,0,0]
[null,"Total debt service",null,"INR",null,null,null,{"$f":"H52+H54","v":17724},{"$f":"I52+I54","v":36390.666666666672},34421.333333333336,32452,30482.666666666668,28513.333333333336,26544,24574.666666666664,22605.333333333332,20636,0,0,0,10634.4,21834.400000000001,20652.8,19471.199999999997,18289.599999999999,17108,15926.4,14744.8,13563.2,12381.6,0,0]
[]
[null,"Working Capital"]
[null,"Operation and Maintenance wcap",null,"INR",null,null,null,{"$f":"H44/(12/Storage_workingcapital_OandM)","v":200},211.44000000000003,223.534368,236.3205338496,249.8380683857971,264.1288058974647,279.23697359479968,295.2093284844222,312.09530207373115,329.94715335234861,348.82013052410292,368.77264199008158,389.86643711191419,120,126.86399999999999,134.12062080000001,141.79232030976002,149.90284103147829,158.47728353847884,167.54218415687984,177.12559709065337,187.25718124423872,197.96829201140918,209.2920783144618,221.26358519404903]
[null,"Interest on working capital - O&M",null,"INR",null,null,null,{"$f":"H58*Storage_interest_workingcap","v":23.1},24.421320000000005,25.818219504000002,27.295021659628802,28.856296898559567,30.506877081157175,32.251870450199362,34.096677439950767,36.047007389515947,38.108896212196264,40.28872507553389,42.593240149854424,45.029573486426095,13.860000000000001,14.652792,15.490931702400003,16.377012995777282,17.313778139135742,18.304126248694306,19.351122270119621,20.458006463970467,21.628204433709573,22.865337727317762,24.17323504532034,25.555944089912664]
[null,"Receivables wcap",null,"INR",null,null,null,{"$f":"IF(Storage_workingcapital_receivables>0, (H44+H45+H42+H46+H48+H59)/(12/Storage_workingcapital_receivables),0)","v":8240.6192307692309},8254.5117584615382,7941.5033965156244,7629.891947377514,7319.7573144598146,7011.1839716503355,6704.2612247432653,6399.0834878242204,6095.7505754645181,5794.3680116289506,5495.0473562531033,5526.1287727230883,5559.5147262151559,4944.371538461538,4952.7070550769231,4764.9020379093736,4577.9351684265084,4391.8543886758889,4206.7103829902017,4022.5567348459595,3839.4500926945325,3657.4503452787108,3476.6208069773711,3297.0284137518615,3315.6772636338524]
[null,"Interest on reveivables wcap",null,"INR",null,null,null,{"$f":"H60*Storage_interest_workingcap","v":951.79152115384625},953.39610810230772,917.24364229755463,881.25251992210292,845.43196982010863,809.79174872561373,774.34217145784714,739.09414284369745,704.0591914661519,669.24950534314382,634.67796964723345,638.2678732495167,642.12395087785058,571.07491269230763,572.03766486138466,550.34618537853271,528.7515119532618,507.25918189206521,485.87504923536829,464.60530287470834,443.45648570621853,422.43551487969108,401.54970320588637,380.80678178834,382.96072394970997]
[]
[null,"Solar PV cost timeline"]
[null,"Year",null,null,null,null,null,{"$f":"Storage_base_year","v":2020},{"$f":"H64+1","v":2021},{"$f":"I64+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,null,null,null,{"$f":"IF(MOD(H3,SolarPV_plant_life)=0, SolarPV_plant_life, MOD(H3,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",null,"INR",null,null,null,{"$f":"IF(H65=1, SolarPV_capex_perkW, 0)","v":41000},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",null,"INR",null,null,null,{"$f":"IF(H65=1, SolarPV_size*H66, 0)","v":984000},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",null,"INR",null,null,null,{"$f":"IF(H65=1, SolarPV_size*(H66-SolarPV_capitalsubsidy_perkW), 0)","v":984000},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",null,"INR",null,null,null,{"$f":"H68*Storage_equity_percentage","v":295200},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,"INR",null,null,null,{"$f":"H68-H69","v":688800},{"$f":"I68-I69","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)",null,"INR",null,null,null,{"$f":"IF(H65=1, H67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, G71)","v":33652.799999999996},{"$f":"IF(I65=1, I67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, H71)","v":33652.799999999996},{"$f":"IF(J65=1, J67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, I71)","v":33652.799999999996},{"$f":"IF(K65=1, K67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, J71)","v":33652.799999999996},{"$f":"IF(L65=1, L67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, K71)","v":33652.799999999996},{"$f":"IF(M65=1, M67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, L71)","v":33652.799999999996},{"$f":"IF(N65=1, N67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, M71)","v":33652.799999999996},{"$f":"IF(O65=1, O67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, N71)","v":33652.799999999996},{"$f":"IF(P65=1, P67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, O71)","v":33652.799999999996},{"$f":"IF(Q65=1, Q67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, P71)","v":33652.799999999996},{"$f":"IF(R65=1, R67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, Q71)","v":33652.799999999996},{"$f":"IF(S65=1, S67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, R71)","v":33652.799999999996},{"$f":"IF(T65=1, T67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, S71)","v":33652.799999999996},{"$f":"IF(U65=1, U67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, T71)","v":33652.799999999996},{"$f":"IF(V65=1, V67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, U71)","v":33652.799999999996},{"$f":"IF(W65=1, W67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, V71)","v":33652.799999999996},{"$f":"IF(X65=1, X67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, W71)","v":33652.799999999996},{"$f":"IF(Y65=1, Y67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, X71)","v":33652.799999999996},{"$f":"IF(Z65=1, Z67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, Y71)","v":33652.799999999996},{"$f":"IF(AA65=1, AA67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, Z71)","v":33652.799999999996},{"$f":"IF(AB65=1, AB67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, AA71)","v":33652.799999999996},{"$f":"IF(AC65=1, AC67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, AB71)","v":33652.799999999996},{"$f":"IF(AD65=1, AD67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, AC71)","v":33652.799999999996},{"$f":"IF(AE65=1, AE67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, AD71)","v":33652.799999999996},{"$f":"IF(AF65=1, AF67*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, AE71)","v":33652.799999999996}]
[null,"Annual depreciation (on net capital cost)",null,"INR",null,null,null,{"$f":"IF(H65=1, H68*Storage_depreciationrate_solarPV*Storage_depreciation_on_capexpercentage, G72)","v":33652.799999999996},33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996,33652.799999999996]
[null,"Asset value",null,"INR",null,null,null,{"$f":"IF(H65=1, H67, G73-G71)","v":984000},{"$f":"IF(I65=1, I67, H73-H71)","v":950347.2},916694.39999999991,883041.59999999986,849388.79999999981,815735.99999999977,782083.19999999972,748430.39999999967,714777.59999999963,681124.79999999958,647471.99999999953,613819.19999999949,580166.39999999944,546513.59999999939,512860.79999999941,479207.99999999942,445555.19999999943,411902.39999999944,378249.59999999945,344596.79999999946,310943.99999999948,277291.19999999949,243638.3999999995,209985.59999999951,176332.79999999952]
[null,"Operation and Maintenance Expenses",null,"INR",null,null,null,{"$f":"IF(H65=1,H67*SolarPV_OandM_year1, G74+(G74*Storage_OandM_escalation))","v":13776},14563.9872,15397.04726784,16277.758371560449,17208.846150413705,18193.192150217368,19233.842741209803,20334.018546007002,21497.124406838604,22726.759922909772,24026.73059050021,25401.059580276822,26854.000188268656,28390.048999037623,30013.959801782574,31730.758302444538,33545.757677344365,35464.575016488467,37493.14870743161,39637.7568134967,41905.036503228708,44302.004591213394,46836.079253830801,49515.102987149919,52347.366878014895]
[null,"Insurance",null,"INR",null,null,null,{"$f":"Storage_insurance*H73","v":3444},3326.2152000000001,3208.4303999999997,3090.6455999999994,2972.8607999999995,2855.0759999999991,2737.2911999999992,2619.5063999999988,2501.7215999999989,2383.9367999999986,2266.1519999999982,2148.3671999999983,2030.5823999999982,1912.7975999999978,1795.0127999999979,1677.227999999998,1559.4431999999981,1441.658399999998,1323.8735999999981,1206.0887999999982,1088.3039999999983,970.51919999999825,852.73439999999823,734.94959999999833,617.16479999999831]
[null,"Interest on term loan",null,"INR",null,null,null,{"$f":"H84","v":72668.399999999994},{"$f":"I84","v":72668.399999999994},64594.133333333324,56519.866666666654,48445.599999999991,40371.333333333328,32297.066666666662,24222.799999999999,16148.533333333335,8074.2666666666692,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest on working capital",null,"INR",null,null,null,{"$f":"H89+H91","v":3513.4521344999998},{"$f":"I89+I91","v":3534.0839067533998},3400.5958758896409,3268.4925975304222,3137.8532795190017,3008.7616603872757,2881.3062685111618,2755.5806960896798,2631.683888795636,2509.7204519943193,2389.8009744779147,2427.4720040508519,2467.4275093586402,2509.798162413314,2554.722109665996,2602.3453995448108,2652.822434447974,2706.3164485908783,2763.0000131860361,2823.0555705193178,2886.6759985753429,2954.0652079594524,3025.4387729636128,3101.0245987292919,3181.0636265720477]
[null,"Return on equity",null,"INR",null,null,null,{"$f":"OFFSET(H69,0,1-H65)*Storage_ROE","v":51955.199999999997},51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997,51955.199999999997]
[]
[null,"Debt"]
[null,"Debt opening balance",null,"INR",null,null,null,{"$f":"IF(H65=1, H70, G83)","v":688800},688800,612266.66666666663,535733.33333333326,459199.99999999994,382666.66666666663,306133.33333333331,229600,153066.66666666669,76533.333333333358,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt repayment",null,"INR",null,null,null,{"$f":"IF(H65>Storage_moratorium, IF(H81>0, OFFSET(H70,0,1-H65)/(Storage_loan_tenure-Storage_moratorium), 0), 0)","v":0},76533.333333333328,76533.333333333328,76533.333333333328,76533.333333333328,76533.333333333328,76533.333333333328,76533.333333333328,76533.333333333328,76533.333333333328,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt closing balance",null,"INR",null,null,null,{"$f":"H81-H82","v":688800},{"$f":"I81-I82","v":612266.66666666663},{"$f":"J81-J82","v":535733.33333333326},{"$f":"K81-K82","v":459199.99999999994},382666.66666666663,306133.33333333331,229600,153066.66666666669,76533.333333333358,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest",null,"INR",null,null,null,{"$f":"Storage_interest*H81","v":72668.399999999994},72668.399999999994,64594.133333333324,56519.866666666654,48445.599999999991,40371.333333333328,32297.066666666662,24222.799999999999,16148.533333333335,8074.2666666666692,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total debt service",null,"INR",null,null,null,{"$f":"H82+H84","v":72668.399999999994},{"$f":"I82+I84","v":149201.73333333334},141127.46666666665,133053.19999999998,124978.93333333332,116904.66666666666,108830.39999999999,100756.13333333333,92681.866666666669,84607.599999999991,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Working Capital"]
[null,"Operation and Maintenance wcap",null,"INR",null,null,null,{"$f":"H74/(12/Storage_workingcapital_OandM)","v":1148},1213.6656,1283.08727232,1356.4798642967041,1434.0705125344755,1516.0993458514474,1602.8202284341503,1694.5015455005835,1791.4270339032171,1893.8966602424809,2002.2275492083509,2116.7549650230685,2237.8333490223881,2365.8374165864684,2501.1633168152143,2644.2298585370449,2795.4798064453639,2955.381251374039,3124.429058952634,3303.1464011247249,3492.0863752690589,3691.8337159344496,3903.0066044859,4126.2585822624933,4362.2805731679082]
[null,"Interest on working capital - O&M",null,"INR",null,null,null,{"$f":"H88*Storage_interest_workingcap","v":132.59399999999999},140.17837680000002,148.19657995296001,156.67342432626933,165.63514419773193,175.10947444584218,185.12573638414437,195.7149285053174,206.90982241582159,218.74506425800655,231.25728193356454,244.48519846016441,258.46975181208586,273.25422161573709,288.88436309215729,305.4085486610287,322.87791764443955,341.34653453370152,360.87155630902924,381.51340932990576,403.33597634357631,426.40679419042897,450.79726281812145,476.58286625131802,503.84340620089341]
[null,"Receivables wcap",null,"INR",null,null,null,{"$f":"IF(Storage_workingcapital_receivables>0, (H74+H75+H72+H76+H78+H89)/(12/Storage_workingcapital_receivables),0)","v":29271.498999999996},29384.463462799995,28159.301263521047,26942.157343758896,25733.490349101903,24533.785159666088,23343.554390710106,22163.339979085387,20993.714860431293,19835.284742305739,18688.689978738959,18900.318663122831,19125.175390013454,19364.016803442224,19617.642827479121,19886.899141850925,20172.679799164802,20475.929991837027,20797.648977290104,21138.893170471099,21500.779413262044,21884.488430900634,22291.268486108151,22722.439242233537,23179.395847369302]
[null,"Interest on reveivables wcap",null,"INR",null,null,null,{"$f":"H90*Storage_interest_workingcap","v":3380.8581344999998},3393.9055299533998,3252.399295936681,3111.8191732041528,2972.21813532127,2833.6521859414333,2696.1805321270172,2559.8657675843624,2424.7740663798145,2290.9753877363128,2158.5436925443501,2182.9868055906873,2208.9577575465541,2236.5439407975769,2265.8377465738386,2296.936850883782,2329.9445168035345,2364.9699140571765,2402.128456877007,2441.5421611894121,2483.3400222317664,2527.6584137690234,2574.6415101454913,2624.4417324779738,2677.2202203711545]
[]
[null,"Cost of Generation"]
[null,"Solar PV generation",null,"kWh",null,null,null,{"$f":"SolarPV_size*24*365*SolarPV_CUF*(1-Storage_solarPV_degradation)^(H3-1)","v":39945.599999999999},39146.687999999995,38363.754239999995,37596.479155199995,36844.549572095995,36107.658580654068,35385.50540904099,34677.795300860169,33984.239394842967,33304.554606946105,32638.463514807179,31985.694244511036,31345.980359620815,30719.060752428395,30104.679537379827,29502.585946632229,28912.534227699587,28334.283543145593,27767.59787228268,27212.245914837025,26668.000996540286,26134.64097660948,25611.948157077288,25099.709193935741,24597.715010057025]
[null,"kWh input for storage",null,"kWh",null,null,null,{"$f":"Storage_capacity*Storage_annual_cycles*(1-Storage_cycle_degradation)^((H7-1)*Storage_annual_cycles)*(1-Storage_time_degradation)^(H7-1)","v":17520},16874.715002718418,16253.19671363984,15654.569773161638,15077.991062344345,14522.648515444993,13987.759976186413,13472.572096151662,12976.35927375205,12498.422632274427,12038.089035568302,17520,16874.715002718418,16253.19671363984,15654.569773161638,15077.991062344345,14522.648515444993,13987.759976186413,13472.572096151662,12976.35927375205,12498.422632274427,12038.089035568302,17520,16874.715002718418,16253.19671363984]
[null,"kWh available from storage",null,"kWh",null,null,null,{"$f":"H95*Storage_roundtripefficiency","v":16994.399999999998},16368.473552636866,15765.600812230645,15184.932679966789,14625.651330474015,14086.969059981642,13568.12717690082,13068.394933267111,12587.068495539488,12123.469953306194,11676.946364501253,16994.399999999998,16368.473552636866,15765.600812230645,15184.932679966789,14625.651330474015,14086.969059981642,13568.12717690082,13068.394933267111,12587.068495539488,12123.469953306194,11676.946364501253,16994.399999999998,16368.473552636866,15765.600812230645]
[null,"Operation and Maintenance Expenses",null,"INR",null,null,null,{"$f":"H16+H44+H74","v":23250.720000000001},24580.661183999997,25986.675003724798,27473.112813937856,29044.574866895102,30705.924549281503,32462.303433500405,34319.147189896627,36282.202409158715,38357.544386962596,40551.595925896851,32984.251284157799,34870.950457611623,33359.567256010421,35267.73450305422,37285.048916628919,39417.753714660095,41672.449227138655,44056.113322930993,46576.123005002642,49240.27724088879,52056.821099067631,51538.782394331349,54486.800747287096,57603.445750031919]
[null,"Insurance",null,"INR",null,null,null,{"$f":"H17+H45+H75","v":7925.4},7469.3329552447558,7013.2659104895101,6557.1988657342645,6101.1318209790206,5645.064776223775,5188.9977314685302,4732.9306867132855,4276.8636419580407,3820.7965972027951,3364.7295524475503,4006.0595076923059,3706.6906447552428,3789.5217818181791,3512.2513804195778,3234.9809790209765,2957.7105776223752,2680.440176223774,2403.1697748251727,2125.8993734265714,1848.6289720279701,1571.3585706293686,2256.1688055944032,2012.1374124602651,1768.1060193261264]
[null,"Depreciation (on net capital cost)",null,"INR",null,null,null,{"$f":"H14+H42+H72","v":130304.86993006992},{"$f":"I14+I42+I72","v":130304.86993006992},130304.86993006992,130304.86993006992,130304.86993006992,130304.86993006992,130304.86993006992,130304.86993006992,130304.86993006992,130304.86993006992,130304.86993006992,85533.960839160834,85533.960839160834,79220.114685314678,79220.114685314678,79220.114685314678,79220.114685314678,79220.114685314678,79220.114685314678,79220.114685314678,79220.114685314678,79220.114685314678,69723.255181182438,69723.255181182438,69723.255181182438]
[null,"Interest on term loan",null,"INR",null,null,null,{"$f":"H18+H46+H76","v":167225.94},167225.94,149498.986,131772.03199999998,114045.07799999999,96318.123999999982,78591.17,60864.216,43137.261999999995,25410.308000000001,7683.3539999999994,34295.94,34295.94,41500.745999999999,38071.152000000002,33459.957999999999,28848.763999999996,24237.57,19626.376,15015.181999999999,10403.987999999999,5792.7939999999999,26454.41272727272,25272.812727272722,22745.531454545449]
[null,"Interest on working capital",null,"INR",null,null,null,{"$f":"H19+H47+H77","v":8857.2406636188443},8887.1098378603056,8577.9458397913568,8271.1189855052435,7966.762959626345,7665.019093539554,7366.0368027849781,7069.9740494716207,6776.9978311411178,6487.2846975944922,6201.0212972813779,5058.4636158152225,5107.5287738183943,4984.7786293302606,4968.8733664744686,4933.394150975706,4901.2682125027932,4872.6873585016092,4847.8543678039387,4826.9836181907413,4810.3017498520485,4798.0483667967619,4886.9126284072709,4945.1394665564958,4982.3622780748346]
[null,"Return on equity",null,"INR",null,null,null,{"$f":"H20+H48+H78","v":119560.31999999999},119560.31999999999,119560.31999999999,119560.31999999999,119560.31999999999,119560.31999999999,119560.31999999999,119560.31999999999,119560.31999999999,119560.31999999999,119560.31999999999,89147.51999999999,89147.51999999999,84078.719999999987,84078.719999999987,84078.719999999987,84078.719999999987,84078.719999999987,84078.719999999987,84078.719999999987,84078.719999999987,84078.719999999987,77627.51999999999,77627.51999999999,77627.51999999999]
[null,"Cost of eletricity",null,"INR",null,null,null,{"$f":"IF(Storage_technology=\"Standalone\", H95*Storage_charging_cost*(1+Storage_chargingcost_escalation)^(H3-1), IF(H95>H94*Storage_excess_solar, (H95-H94*Storage_excess_solar)*Storage_charging_cost*(1+Storage_chargingcost_escalation)^(H3-1), 0))","v":0},0,0,0,0,0,0,0,0,0,0,16585.880421435311,13704.094546018052,10700.646383080293,7571.5762714990196,4312.8048328480108,920.1294442391885,0,0,0,0,0,87564.943365722575,84352.837880798776,80982.433660394672]
[null,"Total cost of generation",null,"INR",null,null,null,{"$f":"SUM(H97:H103)","v":457124.4905936888},458028.23390717496,440942.06268407567,423938.65259524726,407022.73757757037,390199.32234911475,373473.69789782382,356851.45785615145,340338.51581232779,323941.12361182983,307665.89070569567,267612.07566826144,266366.68526136409,257634.09473555378,252690.42220676193,246525.0215647883,240344.46063433914,236761.9814471787,234232.34815087478,231843.02268193464,229602.03064808348,227517.85672180838,320051.99510251079,318420.50341555779,315432.65434355545]
[null,"Cost of generation per kWh",null,"INR",null,null,null,{"$f":"IF(Storage_technology=\"Standalone\",H104/H96,H104/(H94-H95+H96))","v":11.596258005928178},11.853595773420007,11.641678618573467,11.41865639655621,11.184336960149997,10.93853864905312,10.681091876815493,10.411840863126015,10.130645523412143,9.8373835286663702,9.5319525494435364,8.5063977745379056,8.6371251729038558,8.5220513132650311,8.5267440626306623,8.4861594542877388,8.4399931999746372,8.4816386785443107,8.5600536072752877,8.6434556334686903,8.732423409979317,8.8275892556223958,12.758014562283696,12.947360930632883,13.082998591674976]
[null,"Discount factor",null,null,null,null,null,1,{"$f":"H106/(1+Storage_discount_rate)","v":0.9129918743723181},0.8335541626698787,0.76102817736682071,0.69481254210428267,0.6343582051531842,0.57916388674626518,0.52877192252922967,0.48276446866541561,0.44076003712719403,0.40241033244516938,0.36739736368590287,0.33543080771104072,0.3062456018543237,0.27959974605525767,0.25527229622501385,0.23306153220580103,0.21278328513265868,0.19426941032836545,0.17736639306889934,0.16193407565863174,0.14784449526032298,0.13498082284335158,0.12323639445206938,0.11251382676168117]
[null,"Present value",null,"INR",null,null,null,{"$f":"H105*H106","v":11.596258005928178},{"$f":"I105*I106","v":10.822236623226519},9.7039696729768359,8.689919265449161,7.7710175950327045,6.9389517444120736,6.1861026860704218,5.5054891102635368,4.8907157033477349,4.3359255293294368,3.8357561942731535,3.1252281168288576,2.8971578730485028,2.6098407334642792,2.3840754745897095,2.1662814100276417,1.9670377469926306,1.8047509413288805,1.6629565666645678,1.5330585493594,1.4140769131547977,1.3051104778629434,1.7220873034645152,1.5955860787607861,1.4720182370670369]
[null,"Levelised cost of generation",null,"INR",null,{"$f":"IF(Storage_technology=\"Solar+Storage\", SUM(OFFSET(H107,0,0,1,SolarPV_plant_life))/SUM(OFFSET(H106,0,0,1,SolarPV_plant_life)), SUM(OFFSET(H107,0,0,1,Storage_life))/SUM(OFFSET(H106,0,0,1,Storage_life)))","v":10.466430822078049}]
[null,"Average cost of generation",null,"INR",null,{"$f":"IF(Storage_technology=\"Solar+Storage\", AVERAGE(OFFSET(H105,0,0,1,SolarPV_plant_life)), AVERAGE(OFFSET(H105,0,0,1,Storage_life)))","v":10.095119375689036}]

{"sheet":"Storage charging cost","index":7,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Charging source",null,"Cost (Rs/kWh)"]
[null,"Solar PV",null,0]
[null,"Domestic (1-50 kWh)",null,2.5]
[null,"Domestic (51-100 kWh)",null,2.5]
[null,"Domestic (101-250 kWh)",null,3]
[null,"Domestic (Above 250 kWh)",null,6.6]
[null,"Public Lighting",null,6.35]
[null,"LT Govt. Educational Institution",null,5.75]
[null,"LT Pvt. Educational Institution",null,7.5]
[null,"LT Industries",null,6.35]
[null,"LT Commercial (Above 50 kWh)",null,8.0500000000000007]
[null,"HT Industries",null,6.35]
[null,"HT Govt. Educational Institution",null,6.35]
[null,"HT Pvt. Educational Institution",null,6.35]
[null,"HT Commercial",null,8]
[null,"Custom",null,3.7]

{"sheet":"Cost projections","index":8,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Li-ion storage cost improvement curve"]
[null,"Year",null,"Cost improvement (%)"]
[null,2015,null,1]
[null,2016,null,0.92]
[null,2017,null,0.8]
[null,2018,null,0.71]
[null,2019,null,0.62]
[null,2020,null,0.55000000000000004]
[null,2021,null,0.49,null,null,null,null,2015,100]
[null,2022,null,0.44,null,null,null,null,2020,55]
[null,2023,null,0.41,null,null,null,null,2025,34]
[null,2024,null,0.37,null,null,null,null,2030,23]
[null,2025,null,0.34,null,null,null,null,2035,18]
[null,2026,null,0.31,null,null,null,null,2040,16]
[null,2027,null,0.28000000000000003,null,null,null,null,2045,15]
[null,2028,null,0.26,null,null,null,null,2050,14]
[null,2029,null,0.25]
[null,2030,null,0.23]
[null,2031,null,0.22]
[null,2032,null,0.21]
[null,2033,null,0.2]
[null,2034,null,0.19]
[null,2035,null,0.18]
[null,2036,null,0.17]
[null,2037,null,0.17]
[null,2038,null,0.16]
[null,2039,null,0.16]
[null,2040,null,0.16]
[null,2041,null,0.16]
[null,2042,null,0.15]
[null,2043,null,0.15]
[null,2044,null,0.15]
[null,2045,null,0.15]
[null,2046,null,0.15]
[null,2047,null,0.14000000000000001]
[null,2048,null,0.14000000000000001]
[null,2049,null,0.14000000000000001]
[null,2050,null,0.14000000000000001]
[null,2051,null,0.14000000000000001]
[null,2052,null,0.14000000000000001]
[null,2053,null,0.13]
[null,2054,null,0.13]
[null,2055,null,0.13]
[null,2056,null,0.13]
[null,2057,null,0.13]
[null,2058,null,0.13]
[null,2059,null,0.13]
[null,2060,null,0.13]

{"sheet":"Storage references","index":9,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,6,13]]}
["This tool uses the cost improvement curve on this sheet to calculate the future cost of Li-ion storage modules. The cost curve is based on the following reference: \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.\n\nHistorical inverter price trends (global and Indian context) are noted at: https://renewablewatch.in/2017/10/24/solar-inverter-trends/\n\nMNRE's benchmark capital costs for rooftop solar provide a reference for historical price trends in solar PV.\n"]

{"sheet":"Results","index":10,"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]