{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["1. Forside","2. Samlet prisloft","3. Driftsomkostninger","4. Historiske investeringer","5. Gennemførte investeringer","6. Korrektion investeringer","7. Planlagte investeringer","8. 1-1 omkostninger","9. Miljø- og servicemål","10. Klimatilpasning","11. Nettofinansielle poster","12. Over- eller underdækning","13. Kontrol med indtægtsrammen","14. EAA-beregning"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"1. Forside","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,3,7,5],[12,3,12,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[22,3,22,5],[21,3,21,5],[20,3,20,5],[19,3,19,5],[18,3,18,5],[27,3,27,5],[26,3,26,5],[25,3,25,5],[24,3,24,5],[23,3,23,5]]}
["Ikast-Brande Spildevand A/S"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Bilag A"]
[]
[]
[]
[]
[null,null,null,"Indholdsfortegnelse"]
[]
[]
[null,null,"Fane nr. 2","Samlet prisloft "]
[null,null,"Fane nr. 3","Driftsomkostninger"]
[null,null,"Fane nr. 4","Historiske investeringer "]
[null,null,"Fane nr. 5","Gennemførte investeringer"]
[null,null,"Fane nr. 6","Korrektion investeringer"]
[null,null,"Fane nr. 7","Planlagte investeringer"]
[null,null,"Fane nr. 8","1:1 omkostninger"]
[null,null,"Fane nr. 9","Miljø- og servicemål"]
[null,null,"Fane nr. 10","Klimatilpasning"]
[null,null,"Fane nr. 11","Nettofinansielle poster"]
[null,null,"Fane nr. 12","Over- eller underdækning"]
[null,null,"Fane nr. 13","Kontrol med indtægtsrammen og oversigt over ekstraordinære effektiviseringsgevinster"]
[null,null,"Fane nr. 14","EAA-beregning"]

{"sheet":"2. Samlet prisloft","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,3,5]]}
[{"$f":"'1. Forside'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 2. Samlet prisloft for 2015"]
[]
[null,"Driftsomkostninger"]
[null,"Driftsomkostninger i prisloftet for 2014",{"$f":"'3. Driftsomkostninger'!C20","v":23925852.132136721},"kr."]
[null,"Bortfald af væsentlige omkostninger",{"$f":"-'3. Driftsomkostninger'!C16","v":0},"kr."]
[null,"Korrektion for prisudviklingen 2014-2015",{"$f":"'3. Driftsomkostninger'!C22","v":19140.681705709379},"kr."]
[null,"Forhøjelse til effektivt niveau iht. benchmarkingen",{"$f":"'3. Driftsomkostninger'!C28","v":0},"kr."]
[null,"Korrektion for generelt effektiviseringskrav",{"$f":"-'3. Driftsomkostninger'!C34","v":-105273.74938140158},"kr."]
[null,"Korrektion for individuelt effektiviseringskrav",{"$f":"-'3. Driftsomkostninger'!C43","v":-1064700.419880084},"kr."]
[null,"Driftsomkostninger i alt",{"$f":"SUM(C7:C12)","v":22775018.644580945},"kr.",{"$f":"C13","v":22775018.644580945}," kr."]
[null,"Investeringer"]
[null,"Tillæg for historiske investeringer",{"$f":"'4. Historiske investeringer'!C9","v":34918635.644363478},"kr."]
[null,"Tillæg for gennemførte investeringer i 2011-2013",{"$f":"'5. Gennemførte investeringer'!F35","v":4290678.0533333337},"kr."]
[null,"Korrektion af tillæg for planlagte investeringer vedrørende 2013  ",{"$f":"'6. Korrektion investeringer'!C10","v":1754012.58},"kr."]
[null,"Tillæg for planlagte investeringer i 2014 og 2015",{"$f":"'7. Planlagte investeringer'!F41","v":1525500},"kr."]
[null,"Investeringstillæg i alt",{"$f":"SUM(C15:C18)","v":42488826.277696811},"kr.",{"$f":"C19","v":42488826.277696811}," kr."]
[null,"Øvrige omkostninger mv."]
[null,"Tillæg for 1:1 omkostninger i 2015",{"$f":"'8. 1-1 omkostninger'!C12","v":5368000},"kr."]
[null,"Tillæg vedr. revisorerklæringer og DANVA/FVD-kontingent",{"$f":"'8. 1-1 omkostninger'!C20","v":135000},"kr."]
[null,"Korrektion ift. faktiske 1:1 omkostninger i 2013",{"$f":"'8. 1-1 omkostninger'!C26","v":-51357},"kr."]
[null,"Tillæg for driftsomkostninger til miljø- og servicemål i 2015",{"$f":"'9. Miljø- og servicemål'!C8","v":0},"kr."]
[null,"Korrektion ift. faktiske driftsomkostninger til miljø- og servicemål i 2013",{"$f":"'9. Miljø- og servicemål'!C15","v":0},"kr."]
[null,"Tillæg for driftsomkostninger til medfinansiering af klimatilpasningsprojekter i 2015",{"$f":"'10. Klimatilpasning'!C9","v":407366},"kr."]
[null,"Korrektion ift. faktiske omkostninger til medfinansiering af klimatilpasningsprojekter i 2013",{"$f":"'10. Klimatilpasning'!C16","v":0},"kr."]
[null,"Tillæg/fradrag for nettofinansielle poster i 2015",{"$f":"'11. Nettofinansielle poster'!C9","v":1350000},"kr."]
[null,"Korrektion ift. faktiske nettofinansielle poster i 2013",{"$f":"'11. Nettofinansielle poster'!C16","v":-169943},"kr."]
[null,"Øvrige omkostninger mv. i alt",{"$f":"SUM(C21:C29)","v":7039066},"kr.",{"$f":"C30","v":7039066}," kr."]
[null,"Historisk over- eller underdækning"]
[null,"Tillæg/fradrag for over- eller underdækning til og med 2010",{"$f":"'12. Over- eller underdækning'!C11","v":899470.49735449732},"kr.",{"$f":"C32","v":899470.49735449732}," kr."]
[null,"Korrektion i forhold til tidligere indtægtsramme "]
[null,"Korrektion for overholdelse af indtægtsramme i prisloft 2013",{"$f":"'13. Kontrol med indtægtsrammen'!E27","v":2984305.5684619993},"kr.",{"$f":"C34","v":2984305.5684619993}," kr."]
[null,"Samlet prisloft"]
[null,"Indtægtsramme i 2015 ",null,null,{"$f":"SUM(E13:E34)","v":76186686.98809424}," kr."]
[null,"Debiteret vandmængde i 2013",null,null,1773991," m3"]
[null,"Prisloft 2015",null,null,{"$f":"E36/E37","v":42.946490138954616}," kr./m3"]

{"sheet":"3. Driftsomkostninger","index":2,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'1. Forside'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 3. Driftsomkostninger "]
[]
[null,"Driftsomkostningerne i prisloftet for 2014"]
[null,"Korrigerede driftsomkostninger i prisloftet for 2013 (DOiPL 2013)",24793629.152473286,"kr."]
[null,"Prisfremskrivning 1,5 pct.",{"$f":"0.015*SUM(C7:C7)","v":371904.43728709925},"kr."]
[null,"Generelt effektiviseringskrav (0 pct.)",0,"kr."]
[null,"Individuelt effektiviseringskrav ",-1239681.4576236643,"kr."]
[null,"Driftsomkostningerne i prisloftet for 2014 (DOiPL 2014)",{"$f":"SUM(C7:C10)","v":23925852.132136721},"kr."]
[]
[]
[null,"Korrektion for forventet bortfald af væsentlige omkostninger"]
[null,"Selskabets indberettede bortfald af væsentlige omkostninger inden 2015",0,"kr."]
[null,"Korrektion for forventet bortfald ",{"$f":"SUM(C15:C15)","v":0},"kr."]
[]
[]
[null,"Korrektion for prisudviklingen fra 2014-2015"]
[null,"Driftsomkostningerne i prisloftet for 2014",{"$f":"C11-C16","v":23925852.132136721},"kr."]
[null,"Prisudvikling 2014 - 2015 ",0.08,"pct."]
[null,"Korrektion for prisudvikling",{"$f":"C20*(C21/100)","v":19140.681705709379},"kr."]
[]
[]
[null,"Eventuel forhøjelse til effektivt niveau iht. benchmarkingen"]
[null,"Selskabets effektive driftsomkostninger iht. benchmarkingen",16501660.215534696,"kr."]
[null,"Selskabets pristalskorrigerede driftsomkostninger i 2015-niveau",{"$f":"C20+C22","v":23944992.813842431},"kr."]
[null,"Eventuel forhøjelse til effektivt niveau",{"$f":"IF(C27>C26,0,C26-C27)","v":0},"kr."]
[]
[]
[null,"Korrektion for generelt effektiviseringskrav"]
[null,"Driftsomkostningerne i prisloftet for 2014",{"$f":"C20","v":23925852.132136721},"kr. "]
[null,"Generelt effektiviseringskrav ",0.44,"pct."]
[null,"Endeligt generelt effektiviseringskrav",{"$f":"C32*(C33/100)","v":105273.74938140158},"kr. "]
[]
[]
[null,"Korrektion for individuelt effektiviseringskrav"]
[null,"Rå effektiviseringspotentiale",7529465.6659834255,"kr."]
[null,"Effektiviseringspotentiale efter eventuel korrektion for særlige forhold",7424191.9166020248,"kr."]
[null,"Effektiviseringspotentiale efter forsigtighedshensyn",4258801.679520336,"kr."]
[null,"Effektiviseringspotentiale efter eventuel korrektion for sammensætning af signifikante costdrivere",4258801.679520336,"kr. "]
[null,"Umiddelbart effektiviseringskrav",{"$f":"C41/4","v":1064700.419880084},"kr."]
[null,"Endeligt individuelt effektiviseringskrav",{"$f":"IF(C42>0.05*C20,0.05*C20,IF(C42<0.01*C20,0,C42))","v":1064700.419880084},"kr. "]

{"sheet":"4. Historiske investeringer","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[{"$f":"'3. Driftsomkostninger'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 4. Historiske investeringer "]
[]
[null,"Tillæg for historiske investeringer "]
[null,"Værdi af selskabets materielle anlægsaktiver pr. 1. januar 2010",1600767744.0731723,"kr."]
[null,"Den årlige standardafskrivning på de materielle anlægsaktiver iht. POLKA",34918635.644363478,"kr."]
[null,"Tillæg i alt i 2015",{"$f":"C8","v":34918635.644363478},"kr."]

{"sheet":"5. Gennemførte investeringer","index":4,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,1,3,5],[6,5,6,6]]}
[{"$f":"'4. Historiske investeringer'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 5. Gennemførte investeringer i 2010 - 2013 "]
[]
[null,"Tillæg for gennemførte investeringer i 2013"]
[null," Beskrivelse af investeringen   ","Årstal ","Std. levetid (år)   "," Anskaffelses-pris (kr.)","Afskrivning "]
[null,"Ledningsnet = Ø 200 mm",2013,75,19002855,{"$f":"E8/D8","v":253371.4},"kr."]
[null,"Ø 200 mm < Ledningsnet = Ø 500 mm",2013,75,5690330,{"$f":"E9/D9","v":75871.066666666666},"kr."]
[null,"Ø 500 mm < Ledningsnet = Ø 800 mm",2013,75,3347619,44634.92,"kr."]
[null,"Ø 800 mm < Ledningsnet = Ø 1000 mm",2013,75,593372,7911.626666666667,"kr."]
[null,"Ø 1200 mm < Ledningsnet = Ø 1600 mm",2013,75,244175,3255.6666666666665,"kr."]
[null,"Brønde",2013,75,7280841,97077.88,"kr."]
[null,"Installationer \"ingen eller faste riste\" (mindre end 7 m2)",2013,20,1136122,56806.1,"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), Konstruktioner",2013,50,417273,8345.4599999999991,"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), Mek/EL",2013,20,1318114,65905.7,"kr."]
[null,"Strømpeforing = Ø 200 mm",2013,50,745085,14901.7,"kr."]
[null,"Strømpeforing Ø 200 mm < Ledningsnet = Ø 500 mm",2013,50,64727,1294.54,"kr."]
[null,"Jordbassin Klasse A",2013,50,1768684,35373.68,"kr."]
[null,"Pumpestationer i brønde (< 6,25 m2), SRO",2013,10,157945,15794.5,"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), SRO",2013,10,157944,15794.4,"kr."]
[null,"Indløb med riste, SRO",2013,10,1935064,193506.4,"kr."]
[null,"Beluftningstanke, SRO",2013,10,2256725,225672.5,"kr."]
[null,"Efterklaringstanke, SRO",2013,10,1569862,156986.20000000001,"kr."]
[null,"Beluftningstanke, Konstruktioner",2013,60,235609,3926.8166666666666,"kr."]
[null,"Slutafvanding, slam - højteknologisk (centrifuger), Konstruktioner",2013,60,681063,11351.05,"kr."]
[null,"Slutafvanding, slam - højteknologisk (centrifuger), Mek/El",2013,20,2217929,110896.45,"kr."]
[null,"Slutafvanding, slam - højteknologisk (centrifuger), SRO",2013,10,171880,17188,"kr."]
[null,"Køretøjer, store lastvogne (> 3.500 kg.)",2013,5,1011980,202396,"kr."]
[null,"Køretøjer, små lastvogne (< 3.500 kg.)",2013,5,452383,90476.6,"kr."]
[null,"Slutdisponering, slam - lavteknologisk (slammineralisering), Konstruktioner",2013,60,3638438,60640.633333333331,"kr."]
[null,"Oversvømmelseskort",2013,5,1085635,217127,"kr."]
[null,"Tillæg for 2013 ",null,null,null,{"$f":"SUM(F8:F32)","v":1986506.29},"kr."]
[null,"Tillæg for 2010 - 2012",null,null,null,2304171.7633333337,"kr."]
[null,"Samlet tillæg for gennemførte investeringer",null,null,null,{"$f":"F33+F34","v":4290678.0533333337},"kr."]

{"sheet":"6. Korrektion investeringer","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'5. Gennemførte investeringer'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 6. Korrektion af tillæg for planlagte investeringer"]
[]
[null,"Korrektion af tillæg for planlagte investeringer vedr. 2013"]
[null,"Tillæg for planlagte investeringer i 2013 i prisloft 2013",864000,"kr."]
[null,"Tillæg for planlagte investeringer i 2013 i prisloft 2014",1355000,"kr."]
[null,"Selskabets faktiske afskrivninger på gennemførte investeringer i 2013",{"$f":"'5. Gennemførte investeringer'!F33","v":1986506.29},"kr."]
[null,"Korrektion af tillæg for planlagte investeringer vedr. 2013",{"$f":"C9-C7+C9-C8","v":1754012.58},"kr."]

{"sheet":"7. Planlagte investeringer","index":6,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,5,6,6],[3,1,3,6]]}
[{"$f":"'6. Korrektion investeringer'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 7. Planlagte investeringer "]
[]
[null,"Tillæg for planlagte investeringer i 2014 og 2015"]
[null,"Beskrivelse af investeringen   ","Årstal ","Std. levetid (år)   ","Anskaffelses-pris (kr.)   ","Afskrivning"]
[null,"Jordbassin Klasse A",2014,50,6000000,{"$f":"E8/D8","v":120000},"kr."]
[null,"Brønde",2014,75,2200000,{"$f":"E9/D9","v":29333.333333333332},"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), Konstruktioner",2014,50,100000,{"$f":"E10/D10","v":2000},"kr."]
[null,"Ledningsnet = Ø 200 mm",2014,75,9700000,129333.33333333333,"kr."]
[null,"Ø 200 mm < Ledningsnet = Ø 500 mm",2014,75,4000000,53333.333333333336,"kr."]
[null,"Ø 500 mm < Ledningsnet = Ø 800 mm",2014,75,1000000,13333.333333333334,"kr."]
[null,"Ø 800 mm < Ledningsnet = Ø 1000 mm",2014,75,2000000,26666.666666666668,"kr."]
[null,"Strømpeforing = Ø 200 mm",2014,50,2000000,40000,"kr."]
[null,"Køretøjer, små lastvogne (< 3.500 kg.)",2014,5,1200000,240000,"kr."]
[null,"Beluftningstanke, SRO",2014,10,1400000,140000,"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), Mek/EL",2014,20,520000,26000,"kr."]
[null,"Jordbassin Klasse A",2014,50,200000,4000,"kr."]
[null,"Efterklaringstanke, Konstruktioner",2014,60,180000,3000,"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), Mek/EL",2014,20,300000,15000,"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), SRO",2014,10,200000,20000,"kr."]
[null,"Jordbassin Klasse A",2015,50,3000000,60000,"kr."]
[null,"Brønde",2015,75,4500000,60000,"kr."]
[null,"Pumpestationer i brønde (< 6,25 m2), Konstruktioner",2015,50,250000,5000,"kr."]
[null,"Pumpestationer i brønde (< 6,25 m2), Mek/EL",2015,20,250000,12500,"kr."]
[null,"Ledningsnet = Ø 200 mm",2015,75,8000000,106666.66666666667,"kr."]
[null,"Ø 200 mm < Ledningsnet = Ø 500 mm",2015,75,5500000,73333.333333333328,"kr."]
[null,"Ø 500 mm < Ledningsnet = Ø 800 mm",2015,75,3500000,46666.666666666664,"kr."]
[null,"Ø 800 mm < Ledningsnet = Ø 1000 mm",2015,75,2000000,26666.666666666668,"kr."]
[null,"Strømpeforing Ø 200 mm < Ledningsnet = Ø 500 mm",2015,50,500000,10000,"kr."]
[null,"Værksteder, garager",2015,75,3200000,42666.666666666664,"kr."]
[null,"Efterklaringstanke, SRO",2015,10,400000,40000,"kr."]
[null,"Køretøjer, små lastvogne (< 3.500 kg.)",2015,5,500000,100000,"kr."]
[null,"Efterklaringstanke, Mek/El",2015,20,300000,15000,"kr."]
[null,"Pumpestationer i brønde (< 6,25 m2), Mek/EL",2015,20,400000,20000,"kr."]
[null,"Pumpestationer i brønde (< 6,25 m2), SRO",2015,10,400000,40000,"kr."]
[null,"Efterklaringstanke, Konstruktioner",2015,60,300000,5000,"kr."]
[null,"Tillæg for 2014",null,null,null,{"$f":"SUMIF(C8:C38,\"2014\",F8:F38)","v":862000},"kr."]
[null,"Tillæg for 2015",null,null,null,{"$f":"SUMIF(C8:C38,\"2015\",F8:F38)","v":663500},"kr."]
[null,"Tillæg i alt",null,null,null,{"$f":"F39+F40","v":1525500},"kr."]

{"sheet":"8. 1-1 omkostninger","index":7,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,3],[16,1,16,3],[22,1,22,3]]}
[{"$f":"'7. Planlagte investeringer'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 8. 1:1 omkostninger"]
[]
[null,"Tillæg for budgetterede 1:1 omkostninger i 2015"]
[null,"Betaling til Forsyningssekretariatet",33000,"kr."]
[null,"Spildevandsafgift",750000,"kr."]
[null,"Betaling af selskabsskatter ",4200000,"kr. "]
[null,"Køb af varer og tjenesteydelser hos et andet prisloftreguleret vandselskab",310000,"kr."]
[null,"Ejendomsskatter",75000,"kr."]
[null,"Tillæg i alt ",{"$f":"SUM(C7:C11)","v":5368000},"kr."]
[]
[]
[]
[]
[null,"Tillæg for budgetterede nødvendige udgifter til revisorerklæringer samt ordinært medlemskab af DANVA og FVD i 2015"]
[null,"Betaling for ordinært medlemskab af DANVA/FVD",80000,"kr."]
[null,"Betaling for revisorerklæringer",55000,"kr."]
[null,"Tillæg i alt ",{"$f":"SUM(C18:C19)","v":135000},"kr."]
[]
[]
[null,"Korrektion af tillæg for faktiske 1:1 omkostninger (inkl. revisorerklæringer og ordinært medlemskab af DANVA/FVD) i 2013"]
[null,"Selskabets faktiske 1:1 omkostninger mv. i 2013, jf. reguleringsregnskabet",1336643,"kr."]
[null,"Tillæg for budgetterede 1:1 omkostninger mv. i prisloft 2013",1388000,"kr."]
[null,"Korrektion af tillæg for budgetterede 1:1 omkostninger mv. i 2013",{"$f":"C24-C25","v":-51357},"kr."]

{"sheet":"9. Miljø- og servicemål","index":8,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'8. 1-1 omkostninger'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 9. Driftsomkostninger til miljø- og servicemål "]
[]
[null,"Tillæg for budgetterede driftsomkostninger til miljø- og servicemål i 2015"]
[null,null,0,"kr."]
[null,"Tillæg i alt",{"$f":"SUM(C7:C7)","v":0},"kr."]
[]
[]
[]
[null,"Korrektion af tillæg for faktiske driftsomkostninger til miljø- og servicemål i 2013"]
[null,"Selskabets faktiske driftsomkostninger til miljø- og servicemål i 2013, jf. reguleringsregnskabet",0,"kr."]
[null,"Tillæg for budgetterede driftsomkostninger til miljø- og servicemål i prisloft 2013",0,"kr."]
[null,"Korrektion af tillæg for budgetterede driftsomkostninger til miljø- og servicemål i 2013",{"$f":"C13-C14","v":0},"kr."]

{"sheet":"10. Klimatilpasning","index":9,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,3],[12,1,12,3],[6,1,6,3]]}
[{"$f":"'9. Miljø- og servicemål'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 10. Medfinansiering af klimatilpasningsprojekter"]
[]
[]
[null,"Tillæg for budgetterede omkostninger til medfinansiering af klimatilpasningsprojekter i 2015"]
[null,"Klimaprojekt Sædbækken",407366,"kr."]
[null,"Tillæg i alt",{"$f":" SUM(C8:C8)","v":407366},"kr."]
[]
[]
[]
[null,"Korrektion af tillæg for faktiske omkostninger til medfinansiering af klimatilpasningsprojekter i 2013"]
[null,"Selskabets faktiske driftsomkostninger til klimatilpasningsprojekter i 2013, jf. reguleringsregnskabet",0,"kr."]
[null,"Tillæg for budgetterede driftsomkostninger til klimatilpasningsprojekter i prisloft 2013",0,"kr."]
[null,"Korrektion af tillæg for budgetterede omkostninger til klimatilpasningsprojekter i 2013",{"$f":"C14-C15","v":0},"kr."]

{"sheet":"11. Nettofinansielle poster","index":10,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'10. Klimatilpasning'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 11. Nettofinansielle poster"]
[]
[null,"Tillæg for budgetterede nettofinansielle poster i 2015"]
[null,"Budgetterede renteudgifter og gebyrer i 2015",1500000,"kr."]
[null,"Budgetterede renteindtægter i 2015",150000,"kr."]
[null,"Tillæg/fradrag i alt",{"$f":"C7-C8","v":1350000},"kr."]
[]
[]
[]
[null,"Korrektion af tillæg for faktiske nettofinansielle poster i 2013"]
[null,"Selskabets faktiske nettofinansielle poster i 2013, jf. reguleringsregnskabet",860057,"kr."]
[null,"Tillæg for budgetterede nettofinansielle poster i prisloft 2013",1030000,"kr."]
[null,"Korrektion af tillæg for budgetterede nettofinansielle poster i 2013",{"$f":"C14-C15","v":-169943},"kr."]

{"sheet":"12. Over- eller underdækning","index":11,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'11. Nettofinansielle poster'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 12. Over- eller underdækning til og med 2010"]
[]
[null,"Tillæg/fradrag for over- eller underdækning til og med 2010"]
[null,"Opgjort over- eller underdækning per 31. december 2010",8297704,"kr."]
[null,"Heraf beløb indregnet i prislofterne for 2011 - 2014",2900881.0158730159,"kr."]
[null,"Endnu ikke indregnet over- eller underdækning",{"$f":"C7-C8","v":5396822.9841269841},"kr."]
[null,"Resterende indregningsperiode (fastsat i prisloftet for 2012)",6,"år"]
[null,"Tillæg/fradrag i alt",{"$f":"IF(C7=0,0,C9/C10)","v":899470.49735449732},"kr."]

{"sheet":"13. Kontrol med indtægtsrammen","index":12,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,3,5],[30,1,30,4],[5,1,5,5]]}
[{"$f":"'12. Over- eller underdækning'!A1","v":"Ikast-Brande Spildevand A/S"}]
[]
[]
[null,"Fane 13. Korrektion for overholdelse af indtægtsrammen i prisloftet for 2013"]
[]
[null,"Samlet opgørelse vedrørende overholdelse af indtægtsrammen i prisloftet for 2013"]
[null,"Indtægtsramme i prisloftet for 2013",null,null,75479934.985896334,"kr."]
[null,"Ikke anvendt likviditet vedrørende investeringer i 2013"]
[null,"Tillæg for historiske investeringer ",35458365.264961049,"kr."]
[null,"Tillæg for gennemførte investeringer i 2011",1891523,"kr."]
[null,"Korrektion af tillæg for planlagte investeringer i 2011",55878,"kr."]
[null,"Tillæg for planlagte investeringer i 2012 og 2013",1915667,"kr."]
[null,"Indtægter fra tilslutningsbidrag",4079071,"kr."]
[null,"Indtægter fra salg af anlægsaktiver",573500,"kr."]
[null,"Erstatninger vedr. anlægsaktiver mv.",0,"kr."]
[null,"Ekstraordinær effektiviseringsgevinst anvendt til investeringer",185737,"kr."]
[null,"Udgifter til investeringer",-33775497,"kr."]
[null,"Ikke anvendt likviditet vedr. investeringer i alt",{"$f":"SUM(C9:C17)","v":10384244.264961049},"kr.",{"$f":"IF(C18<0,0,-C18)","v":-10384244.264961049},"kr."]
[null,"Ekstraordinære effektiviseringsgevinster anvendt til takstnedsættelse"]
[null,"Ekstraordinær effektiviseringsgevinst anvendt til takstnedsættelse",1834454.1524732858,"kr.",{"$f":"-C20","v":-1834454.1524732858},"kr."]
[null,"Korrektion af ikke opkrævet tillæg fra 2011 i prisloft 2013"]
[null,"Korrektion af ikke opkrævet tillæg fra 2011 i prisloft 2013",0,"kr.",{"$f":"-C22","v":0},"kr."]
[null,"Indtægter fra primære aktiviteter mv."]
[null,"Indtægter fra kubikmetertakster, faste takster, særbidrag, målergebyrer samt andre takster og gebyrer",60176510,"kr."]
[null,"Andre indtægter i prisloftåret, som selskabet har opnået i forbindelse med eller som følge af selskabets primære aktiviteter",100421,"kr."]
[null,"Indtægter fra primære aktiviteter mv. i alt",{"$f":"SUM(C24:C25)","v":60276931},"kr.",{"$f":"-C26","v":-60276931},"kr."]
[null,"Tillæg/fradrag i prisloftet for 2015 i alt",null,null,{"$f":"E7+E18+E20+E22+E26","v":2984305.5684619993},"kr."]
[]
[]
[]
[null,"Oversigt over ekstraordinære effektiviseringsgevinster"]
[]
[null,null,2012,null,2013,null,2014,null,2015,null,2016]
[null,"Indhentet ekstraordinær effektiviseringsgevinst",1058642,"kr.",1834454.1524732858,"kr.",null,"kr.",null,"kr.",null,"kr."]
[null,"Gevinst anvendt til investeringer",0,"kr.",185737,"kr.",null,"kr.",null,"kr.",null,"kr."]
[null,"Gevinst anvendt til takstnedsættelse",872905,"kr.",1834454.1524732858,"kr.",null,"kr.",null,"kr.",null,"kr."]
[null,"Korrektion for  effektiviseringsgevinst der ikke er anvendt inden 4 år",0,"kr.",0,"kr.",null,"kr.",null,"kr.",{"$f":"IF(C38>SUM(C35:I36),C38-SUM(E35:I36),0)*-1","v":0},"kr."]
[null,"Resterende gevinst",{"$f":"C34-C35-C36","v":185737},"kr.",{"$f":"C38+E34-E35-E36","v":0},"kr.",{"$f":"E38+G34-G35-G36","v":0},"kr.",{"$f":"G38+I34-I35-I36","v":0},"kr.",{"$f":"K34-K35-K36+K37","v":0},"kr."]

{"sheet":"14. EAA-beregning","index":13,"n_rows":144,"n_cols":12,"rows_kept":144,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vejledning:"]
[null,"Dette dokument kan anvendes til at vurdere, hvorvidt klimatilpasning ved hhv. sædvanlig afhjælpning eller alternativt projekt er mest omkostningseffektivt. Oplysninger om forventet årlig effektiv rente"]
[null,"samt omkostninger til anlæg og drift skal indtastes i de orange celler. Det bemærkes, at omkostninger indgår som negative tal."]
[null,"Herefter beregnes den årlige ækvivalente annuitet ved de to typer klimatilpasningsinitiativer. Sidst beregnes hvilket klimatilpasningsinitiativ, som er mest omkostningseffektivt"]
[]
[]
[null,"Rente",null,null,"Resultater"]
[]
[null,"Forventet årlig effektiv rente",2.5000000000000001E-2,null,"Årlig ækvivalent annuitet ved sædvanlig afhjælpning",{"$f":"IF(SUM($C$21:$C$144)<0,($C$10*SUM($K$25:$K$144)/(1-(1+$C$10)^(-($C$19-$C$18+1)))),\"\")","v":-565725.44588323857}]
[null,null,null,null,"Årlig ækvivalent annuitet ved alternativt klimatilpasningsprojekt",{"$f":"IF(SUM($F$25:$G$144)<0,($C$10*SUM($L$25:$L$144)/(1-(1+$C$10)^(-($F$19-$F$18+1)))),\"\")","v":-417550.15000000084}]
[]
[null,null,null,null,"Konklusion",{"$f":"IF($F$10<0,IF($F$10<>$F$11,IF($F$10>$F$11,\"Sædvanlig afhjælpning er mest omkostningseffektivt\",\"Alternativt projekt er mest omkostningseffektivt\"),\"Sædvanlig afhjælpning og alternativt projekt er lige omkostningseffektivt\"),\"\")","v":"Alternativt projekt er mest omkostningseffektivt"}]
[]
[]
[null,"Klimatilpasning ved sædvanlig afhjælpning",null,null,"Klimatilpasning ved alternativt klimatilpasningsprojekt"]
[]
[null,"Projektets startår",2015,null,"Projektets startår",2015,null,null,null,null,null,{"$f":" IF($E18>=$F$18,IF($E18<=$F$19,SUM($F18:$G18),\"\"),\"\")","v":""}]
[null,"Projektets slutår",2114,null,"Projektets slutår",2039,null,null,null,null,null,{"$f":" IF($E19>=$F$18,IF($E19<=$F$19,SUM($F19:$G19),\"\"),\"\")","v":""}]
[]
[null,"Anlægsomkostninger",-19400000]
[]
[]
[null,"År","Forventede driftsomkostninger i år t",null,"År ","Tilskud til anlægsomkostninger betalt i år t","Tilskud til driftsomkostninger betalt i år t",null,"Sædvanlig afhjælpning: Cash-flow for anlæg","Sædvanlig afhjælpning: Cash-flow for drift","Tilbagediskonteret cash-flow for sædvanlig afhjælpning","Tilbagediskonteret cash-flow for alternativt projekt"]
[null,2013,null,null,2013,null,null,null,{"$f":" IF($B25=$C$18,$C$21,\"\")","v":""},{"$f":" IF($B25>=$C$18,IF($B25<=$C$19,$C25,\"\"),\"\")","v":""},{"$f":" IF(SUM($I25:$J25)/((1+$C$10)^($B25-$C$18))<0,SUM($I25:$J25)/((1+$C$10)^($B25-$C$18)),\"\")","v":""},{"$f":" IF($E25>=$F$18,IF($E25<=$F$19,IF(SUM($F25:$G25)/((1+$C$10)^($E25-$F$18))<0,SUM($F25:$G25)/((1+$C$10)^($E25-$F$18)),\"\"),\"\"),\"\")","v":""}]
[null,2014,null,null,2014,null,null,null,{"$f":" IF($B26=$C$18,$C$21,\"\")","v":""},{"$f":" IF($B26>=$C$18,IF($B26<=$C$19,$C26,\"\"),\"\")","v":""},{"$f":" IF(SUM($I26:$J26)/((1+$C$10)^($B26-$C$18))<0,SUM($I26:$J26)/((1+$C$10)^($B26-$C$18)),\"\")","v":""},{"$f":" IF($E26>=$F$18,IF($E26<=$F$19,IF(SUM($F26:$G26)/((1+$C$10)^($E26-$F$18))<0,SUM($F26:$G26)/((1+$C$10)^($E26-$F$18)),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"B26+1","v":2015},-35000,null,{"$f":"E26+1","v":2015},-347366,-60000,null,-19400000,-35000,-19435000,-407366]
[null,{"$f":"B27+1","v":2016},-35000,null,{"$f":"E27+1","v":2016},-347366,-60000,null,"",-35000,-34146.341463414639,-397430.24390243908]
[null,2017,-35000,null,2017,-347366,-60000,null,"",-35000,-33313.503866745988,-387736.82331945276]
[null,2018,-35000,null,2018,-347366,-60000,null,"",-35000,-32500.97938219121,-378279.82762873441]
[null,2019,-35000,null,2019,-347366,-60000,null,"",-35000,-31708.272567991426,-369053.49036949698]
[null,2020,-35000,null,2020,-347366,-60000,null,"",-35000,-30934.900066333103,-360052.18572633859]
[null,2021,-35000,null,2021,-347366,-60000,null,"",-35000,-30180.390308617662,-351270.42509886692]
[null,2022,-35000,null,2022,-347366,-60000,null,"",-35000,-29444.28322791967,-342702.85375499213]
[null,2023,-35000,null,2023,-347366,-60000,null,"",-35000,-28726.129978458215,-334344.24756584596]
[null,2024,-35000,null,2024,-347366,-60000,null,"",-35000,-28025.492661910459,-326189.50982033758]
[null,2025,-35000,null,2025,-347366,-60000,null,"",-35000,-27341.944060400449,-318233.66811740253]
[null,2026,-35000,null,2026,-347366,-60000,null,"",-35000,-26675.067376000436,-310471.87133405125]
[null,2027,-35000,null,2027,-347366,-60000,null,"",-35000,-26024.455976585796,-302899.38666736713]
[null,2028,-35000,null,2028,-347366,-60000,null,"",-35000,-25389.713147888582,-295511.59674865083]
[null,2029,-35000,null,2029,-347366,-60000,null,"",-35000,-24770.45185159862,-288303.9968279521]
[null,2030,-35000,null,2030,-347366,-60000,null,"",-35000,-24166.294489364504,-281272.19202727027]
[null,2031,-35000,null,2031,-347366,-60000,null,"",-35000,-23576.872672550737,-274411.89466075151]
[null,2032,-35000,null,2032,-347366,-60000,null,"",-35000,-23001.826997610478,-267718.92162024544]
[null,2033,-35000,null,2033,-347366,-60000,null,"",-35000,-22440.806826937049,-261189.19182462967]
[null,2034,-35000,null,2034,-347366,-60000,null,"",-35000,-21893.470075060537,-254818.72373134602]
[null,2035,-35000,null,2035,-347366,-60000,null,"",-35000,-21359.483000059063,-248603.6329086303]
[null,2036,-35000,null,2036,-347366,-60000,null,"",-35000,-20838.520000057626,-242540.1296669564]
[null,2037,-35000,null,2037,-347366,-60000,null,"",-35000,-20330.263414690366,-236624.51674825017]
[null,2038,-35000,null,2038,-347366,-60000,null,"",-35000,-19834.403331405236,-230853.18707146356]
[null,2039,-35000,null,2039,-347366,-60000,null,"",-35000,-19350.637396492912,-225222.62153313519]
[null,2040,-35000,null,2040,null,null,null,"",-35000,-18878.670630724795,""]
[null,2041,-35000,null,2041,null,null,null,"",-35000,-18418.215249487606,""]
[null,2042,-35000,null,2042,null,null,null,"",-35000,-17968.990487304982,""]
[null,2043,-35000,null,2043,null,null,null,"",-35000,-17530.722426639008,""]
[null,2044,-35000,null,2044,null,null,null,"",-35000,-17103.143830867324,""]
[null,2045,-35000,null,2045,null,null,null,"",-35000,-16685.993981333981,""]
[null,2046,-35000,null,2046,null,null,null,"",-35000,-16279.018518374609,""]
[null,2047,-35000,null,2047,null,null,null,"",-35000,-15881.969286219135,""]
[null,2048,-35000,null,2048,null,null,null,"",-35000,-15494.604181677205,""]
[null,2049,-35000,null,2049,null,null,null,"",-35000,-15116.687006514347,""]
[null,2050,-35000,null,2050,null,null,null,"",-35000,-14747.987323428633,""]
[null,2051,-35000,null,2051,null,null,null,"",-35000,-14388.280315540129,""]
[null,2052,-35000,null,2052,null,null,null,"",-35000,-14037.346649307445,""]
[null,2053,-35000,null,2053,null,null,null,"",-35000,-13694.972340787754,""]
[null,2054,-35000,null,2054,null,null,null,"",-35000,-13360.948625158782,""]
[null,2055,-35000,null,2055,null,null,null,"",-35000,-13035.071829423205,""]
[null,2056,-35000,null,2056,null,null,null,"",-35000,-12717.143248217761,""]
[null,2057,-35000,null,2057,null,null,null,"",-35000,-12406.969022651474,""]
[null,2058,-35000,null,2058,null,null,null,"",-35000,-12104.360022098999,""]
[null,2059,-35000,null,2059,null,null,null,"",-35000,-11809.131728877075,""]
[null,2060,-35000,null,2060,null,null,null,"",-35000,-11521.104125733731,""]
[null,2061,-35000,null,2061,null,null,null,"",-35000,-11240.101586081691,""]
[null,2062,-35000,null,2062,null,null,null,"",-35000,-10965.952766908964,""]
[null,2063,-35000,null,2063,null,null,null,"",-35000,-10698.49050430143,""]
[null,2064,-35000,null,2064,null,null,null,"",-35000,-10437.551711513592,""]
[null,2065,-35000,null,2065,null,null,null,"",-35000,-10182.977279525454,""]
[null,2066,-35000,null,2066,null,null,null,"",-35000,-9934.6119800248325,""]
[null,2067,-35000,null,2067,null,null,null,"",-35000,-9692.3043707559355,""]
[null,2068,-35000,null,2068,null,null,null,"",-35000,-9455.9067031765244,""]
[null,2069,-35000,null,2069,null,null,null,"",-35000,-9225.2748323673404,""]
[null,2070,-35000,null,2070,null,null,null,"",-35000,-9000.268129138869,""]
[null,2071,-35000,null,2071,null,null,null,"",-35000,-8780.7493942818237,""]
[null,2072,-35000,null,2072,null,null,null,"",-35000,-8566.5847749090972,""]
[null,2073,-35000,null,2073,null,null,null,"",-35000,-8357.6436828381447,""]
[null,2074,-35000,null,2074,null,null,null,"",-35000,-8153.7987149640439,""]
[null,2075,-35000,null,2075,null,null,null,"",-35000,-7954.9255755746772,""]
[null,2076,-35000,null,2076,null,null,null,"",-35000,-7760.9030005606601,""]
[null,2077,-35000,null,2077,null,null,null,"",-35000,-7571.6126834738161,""]
[null,2078,-35000,null,2078,null,null,null,{"$f":" IF($B90=$C$18,$C$21,\"\")","v":""},{"$f":" IF($B90>=$C$18,IF($B90<=$C$19,$C90,\"\"),\"\")","v":-35000},{"$f":" IF(SUM($I90:$J90)/((1+$C$10)^($B90-$C$18))<0,SUM($I90:$J90)/((1+$C$10)^($B90-$C$18)),\"\")","v":-7386.9392033890872},{"$f":" IF($E90>=$F$18,IF($E90<=$F$19,IF(SUM($F90:$G90)/((1+$C$10)^($E90-$F$18))<0,SUM($F90:$G90)/((1+$C$10)^($E90-$F$18)),\"\"),\"\"),\"\")","v":""}]
[null,2079,-35000,null,2079,null,null,null,"",-35000,-7206.7699545259402,""]
[null,{"$f":"B91+1","v":2080},-35000,null,{"$f":"E91+1","v":2080},null,null,null,"",-35000,-7030.9950775862844,""]
[null,{"$f":"B92+1","v":2081},-35000,null,{"$f":"E92+1","v":2081},null,null,null,"",-35000,-6859.5073927671065,""]
[null,{"$f":"B93+1","v":2082},-35000,null,{"$f":"E93+1","v":2082},null,null,null,"",-35000,-6692.202334406933,""]
[null,{"$f":"B94+1","v":2083},-35000,null,{"$f":"E94+1","v":2083},null,null,null,"",-35000,-6528.9778872262768,""]
[null,2084,-35000,null,2084,null,null,null,"",-35000,-6369.7345241231978,""]
[null,2085,-35000,null,2085,null,null,null,"",-35000,-6214.3751454860476,""]
[null,2086,-35000,null,2086,null,null,null,"",-35000,-6062.8050199863865,""]
[null,2087,-35000,null,2087,null,null,null,"",-35000,-5914.9317268159884,""]
[null,2088,-35000,null,2088,null,null,null,"",-35000,-5770.6650993326721,""]
[null,2089,-35000,null,2089,null,null,null,"",-35000,-5629.9171700806555,""]
[null,2090,-35000,null,2090,null,null,null,"",-35000,-5492.6021171518587,""]
[null,2091,-35000,null,2091,null,null,null,"",-35000,-5358.6362118554725,""]
[null,2092,-35000,null,2092,null,null,null,"",-35000,-5227.937767663876,""]
[null,{"$f":"B104+1","v":2093},-35000,null,{"$f":"E104+1","v":2093},null,null,null,"",-35000,-5100.4270904037821,""]
[null,{"$f":"B105+1","v":2094},-35000,null,{"$f":"E105+1","v":2094},null,null,null,"",-35000,-4976.0264296622254,""]
[null,2095,-35000,null,2095,null,null,null,"",-35000,-4854.6599313777815,""]
[null,2096,-35000,null,2096,null,null,null,"",-35000,-4736.2535915880799,""]
[null,2097,-35000,null,2097,null,null,null,"",-35000,-4620.735211305444,""]
[null,2098,-35000,null,2098,null,null,null,"",-35000,-4508.0343524931159,""]
[null,2099,-35000,null,2099,null,null,null,"",-35000,-4398.0822951152359,""]
[null,2100,-35000,null,2100,null,null,null,"",-35000,-4290.8119952343768,""]
[null,2101,-35000,null,2101,null,null,null,"",-35000,-4186.1580441310989,""]
[null,2102,-35000,null,2102,null,null,null,"",-35000,-4084.0566284205847,""]
[null,2103,-35000,null,2103,null,null,null,"",-35000,-3984.4454911420339,""]
[null,2104,-35000,null,2104,null,null,null,"",-35000,-3887.2638937971074,""]
[null,2105,-35000,null,2105,null,null,null,"",-35000,-3792.4525793142507,""]
[null,2106,-35000,null,2106,null,null,null,"",-35000,-3699.9537359163423,""]
[null,2107,-35000,null,2107,null,null,null,"",-35000,-3609.7109618696031,""]
[null,2108,-35000,null,2108,null,null,null,"",-35000,-3521.6692310922949,""]
[null,2109,-35000,null,2109,null,null,null,"",-35000,-3435.7748596022398,""]
[null,2110,-35000,null,2110,null,null,null,"",-35000,-3351.9754727826721,""]
[null,2111,-35000,null,2111,null,null,null,"",-35000,-3270.2199734465103,""]
[null,2112,-35000,null,2112,null,null,null,"",-35000,-3190.4585106795225,""]
[null,2113,-35000,null,2113,null,null,null,"",-35000,-3112.6424494434364,""]
[null,2114,-35000,null,2114,null,null,null,"",-35000,-3036.7243409204261,""]
[null,2115,null,null,2115,null,null,null,"","","",""]
[null,2116,null,null,2116,null,null,null,"","","",""]
[null,2117,null,null,2117,null,null,null,"","","",""]
[null,2118,null,null,2118,null,null,null,"","","",""]
[null,2119,null,null,2119,null,null,null,"","","",""]
[null,2120,null,null,2120,null,null,null,"","","",""]
[null,2121,null,null,2121,null,null,null,"","","",""]
[null,2122,null,null,2122,null,null,null,"","","",""]
[null,2123,null,null,2123,null,null,null,"","","",""]
[null,2124,null,null,2124,null,null,null,"","","",""]
[null,2125,null,null,2125,null,null,null,"","","",""]
[null,2126,null,null,2126,null,null,null,"","","",""]
[null,2127,null,null,2127,null,null,null,"","","",""]
[null,2128,null,null,2128,null,null,null,"","","",""]
[null,2129,null,null,2129,null,null,null,"","","",""]
[null,2130,null,null,2130,null,null,null,"","","",""]
[null,2131,null,null,2131,null,null,null,"","","",""]
[null,2132,null,null,2132,null,null,null,"","","",""]