{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["AnnuityTilt"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"comments":0,"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":"AnnuityTilt","index":0,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Attachment 7: Annuity Tilt (D278983)"]
["Worked Example"]
[]
[null,null,null,null,null,"Units","Value"]
[]
[null,null,null,null,"Capital cost","#",100]
[null,null,null,null,"WACC","per cent",0.105]
[null,null,null,null,"Annuity period","years",15]
[null,null,null,null,"BESS Capital Cost Proportion","per cent",0.55000000000000004]
[null,null,null,null,"BESS Capital Cost Change","per cent",-7.8414344348681095E-2]
[null,null,null,null,"Non BESS Capital Cost Change","per cent",0]
[]
[null,null,null,null,"Multiple required","x",1.2063934388022675]
[]
["Cashflow calculations"]
[]
[null,null,null,null,null,"Total",0,{"$f":"+G17+1","v":1},{"$f":"+H17+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,"Capital Cost",null,null,{"$f":"G6","v":100},{"$f":"I34","v":95.687211060822534},{"$f":"J34","v":91.712606638624919},88.049668216239297,84.673956708634648,81.562949405609089,78.695889700514257,76.053648602402959,73.618597107611194,71.3744885792388,69.306350349766007,67.400383823579773,65.64387241289495,64.025096692819972,62.533256209482232]
[null,null,null,null,"Apply multiple to constant annuity",{"$f":"SUM(H19:BR19)","v":190.95503778847126},null,{"$f":"PMT($G$7,$G$8,-H18)*$G$13","v":16.316230164670639},15.612545594837986,14.964039989177046,14.366386525390451,13.815597666114405,13.307998554113039,12.840202493671242,12.409088354597882,12.011779748079404,11.645625835445161,11.308183641800836,10.997201756526712,10.710605311890674,10.446482139553435,10.203070012602314]
[null,null,null,null,"NPV",{"$f":"NPV(G7,H19:V19)","v":99.999999999999957}]
[null,null,null,null,"Target NPV",{"$f":"G6","v":100}]
[null,null,null,null,"Difference",{"$f":"F20-F21","v":0}]
[]
[]
[]
[]
[]
["BESS calculations"]
[]
[]
[null,null,null,null,null,"Total",0,{"$f":"+G31+1","v":1},{"$f":"+H31+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,"BESS",null,null,{"$f":"G6*G9","v":55.000000000000007},{"$f":"H32*(1+$G$10)","v":50.687211060822548},{"$f":"I32*(1+$G$10)","v":46.712606638624933},43.049668216239311,39.673956708634648,36.562949405609103,33.695889700514265,31.053648602402962,28.618597107611198,26.374488579238804,24.306350349766014,22.400383823579777,20.643872412894964,19.025096692819979,17.533256209482239]
[null,null,null,null,"Rest",null,null,{"$f":"G6-H32","v":44.999999999999993},{"$f":"H33*(1+$G$11)","v":44.999999999999993},{"$f":"I33*(1+$G$11)","v":44.999999999999993},44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993,44.999999999999993]
[null,null,null,null,"Total",null,null,{"$f":"SUM(H32:H33)","v":100},{"$f":"SUM(I32:I33)","v":95.687211060822534},91.712606638624919,88.049668216239297,84.673956708634648,81.562949405609089,78.695889700514257,76.053648602402959,73.618597107611194,71.3744885792388,69.306350349766007,67.400383823579773,65.64387241289495,64.025096692819972,62.533256209482232]
[null,null,null,null,"BESS percent",null,null,{"$f":"H32/H34","v":0.55000000000000004},{"$f":"I32/I34","v":0.52971771774813015},0.50933681148859467,0.48892482036973212,0.46854969639784044,0.44827890202674142,0.42817852150534963,0.40831241068718171,0.38874140817677183,0.36952262782182005,0.35070884885872622,0.33234801573552886,0.31448285504923568,0.29715061242466706,0.28038290778824954]
[]
["End"]