{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Makro i swap","Rekompensata Stary Rynek>>","Koszty netto","Rekompensata"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":43,"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":"Makro i swap","index":0,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["ZAŁOŻENIA MAKROEKONOMICZNE",null,2024,{"$f":"C2+1","v":2025},{"$f":"D2+1","v":2026},2027,2028,2029,2030,2031,2032,2033]
[]
["Inflacja"]
["Dynamika realnego wzrostu płac"]

{"sheet":"Rekompensata Stary Rynek>>","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Przychody"]
[null,"Koszty"]

{"sheet":"Koszty netto","index":2,"n_rows":139,"n_cols":16,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["KOSZTY OPERACYJNE",null,"Jednostka",null,null,0,2024,{"$f":"G5+1","v":2025},{"$f":"H5+1","v":2026},2027,2028,2029,2030,2031,2032,2033]
[]
["Koszty operacyjne",null,"PLN",{"$f":"SUM(G7:O7)","v":0},null,{"$f":"SUM(F8:F15)","v":0},{"$f":"SUM(G8:G15)","v":0},{"$f":"SUM(H8:H15)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(P8:P15)","v":0}]
["Amortyzacja",null,"PLN",0,null,{"$f":"F$21","v":0},{"$f":"G$21","v":0},{"$f":"H$21","v":0},0,0,0,0,0,0,0,0]
["Zużycie materiałów i energii",null,"PLN",0,null,{"$f":"F$27","v":0},0,0,{"$f":"I$27","v":0},0,0,0,0,0,0,0]
["Usługi obce",null,"PLN",0,null,{"$f":"F$33","v":0},0,0,0,0,0,0,0,0,0,0]
["Podatki i opłaty",null,"PLN",0,null,{"$f":"F$39","v":0},0,0,0,0,0,0,0,0,0,0]
["Wynagrodzenia oraz ubezpieczenia społeczne i inne świadczenia",null,"PLN",0,null,{"$f":"F$45","v":0},0,0,0,0,0,0,0,0,0,0]
["Pozostałe koszty rodzajowe",null,"PLN",0,null,{"$f":"F$51","v":0},0,0,0,0,0,0,0,0,0,0]
["Wartość sprzedanych towarów i materiałów",null,"PLN",0,null,{"$f":"F$57","v":0},0,0,0,0,0,0,0,0,0,0]
["Koszty wewnętrzne",null,"PLN",0,null,{"$f":"F$61","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Koszty operacyjne bez amortyzacji",null,"PLN",{"$f":"SUM(G17:O17)","v":0},null,{"$f":"F7-F8","v":0},{"$f":"G7-G8","v":0},0,0,0,0,0,0,0,0,{"$f":"P7-P8","v":0}]
[]
[]
[]
["Amortyzacja - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F22=\"\",F23=\"\"),\"\",F22+F23)","v":0},{"$f":"IF(AND(G22=\"\",G23=\"\"),\"\",G22+G23)","v":0},{"$f":"IF(AND(H22=\"\",H23=\"\"),\"\",H22+H23)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(P22=\"\",P23=\"\"),\"\",P22+P23)","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
["Koszty pośrednie",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Zużycie materiałów i energii - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F28=\"\",F29=\"\"),\"\",F28+F29)","v":0},{"$f":"IF(AND(G28=\"\",G29=\"\"),\"\",G28+G29)","v":0},{"$f":"IF(AND(H28=\"\",H29=\"\"),\"\",H28+H29)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(P28=\"\",P29=\"\"),\"\",P28+P29)","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,{"$f":"H28*'Makro i swap'!E$4","v":0},{"$f":"I28*'Makro i swap'!F$4","v":0},{"$f":"J28*'Makro i swap'!G$4","v":0},{"$f":"K28*'Makro i swap'!H$4","v":0},{"$f":"L28*'Makro i swap'!I$4","v":0},{"$f":"M28*'Makro i swap'!J$4","v":0},{"$f":"N28*'Makro i swap'!K$4","v":0},{"$f":"O28*'Makro i swap'!L$4","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,{"$f":"G28*0.161","v":0},0,{"$f":"H29*'Makro i swap'!E$4","v":0},{"$f":"I29*'Makro i swap'!F$4","v":0},{"$f":"J29*'Makro i swap'!G$4","v":0},{"$f":"K29*'Makro i swap'!H$4","v":0},{"$f":"L29*'Makro i swap'!I$4","v":0},{"$f":"M29*'Makro i swap'!J$4","v":0},{"$f":"N29*'Makro i swap'!K$4","v":0},{"$f":"O29*'Makro i swap'!L$4","v":0}]
[]
[]
[]
["Usługi obce - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F34=\"\",F35=\"\"),\"\",F34+F35)","v":0},{"$f":"IF(AND(G34=\"\",G35=\"\"),\"\",G34+G35)","v":0},{"$f":"IF(AND(H34=\"\",H35=\"\"),\"\",H34+H35)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(P34=\"\",P35=\"\"),\"\",P34+P35)","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,{"$f":"H34*'Makro i swap'!E$4","v":0},{"$f":"I34*'Makro i swap'!F$4","v":0},{"$f":"J34*'Makro i swap'!G$4","v":0},{"$f":"K34*'Makro i swap'!H$4","v":0},{"$f":"L34*'Makro i swap'!I$4","v":0},{"$f":"M34*'Makro i swap'!J$4","v":0},{"$f":"N34*'Makro i swap'!K$4","v":0},{"$f":"O34*'Makro i swap'!L$4","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,{"$f":"G34*0.161","v":0},0,{"$f":"H35*'Makro i swap'!E$4","v":0},{"$f":"I35*'Makro i swap'!F$4","v":0},{"$f":"J35*'Makro i swap'!G$4","v":0},{"$f":"K35*'Makro i swap'!H$4","v":0},{"$f":"L35*'Makro i swap'!I$4","v":0},{"$f":"M35*'Makro i swap'!J$4","v":0},{"$f":"N35*'Makro i swap'!K$4","v":0},{"$f":"O35*'Makro i swap'!L$4","v":0}]
[]
[]
[]
["Podatki i opłaty - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F40=\"\",F41=\"\"),\"\",F40+F41)","v":0},{"$f":"IF(AND(G40=\"\",G41=\"\"),\"\",G40+G41)","v":0},{"$f":"IF(AND(H40=\"\",H41=\"\"),\"\",H40+H41)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(P40=\"\",P41=\"\"),\"\",P40+P41)","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,{"$f":"G40*'Makro i swap'!D$4/9*12","v":0},{"$f":"H40*'Makro i swap'!E$4","v":0},{"$f":"I40*'Makro i swap'!F$4","v":0},{"$f":"J40*'Makro i swap'!G$4","v":0},{"$f":"K40*'Makro i swap'!H$4","v":0},{"$f":"L40*'Makro i swap'!I$4","v":0},{"$f":"M40*'Makro i swap'!J$4","v":0},{"$f":"N40*'Makro i swap'!K$4","v":0},{"$f":"O40*'Makro i swap'!L$4","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,0,{"$f":"G41*'Makro i swap'!D$4/9*12","v":0},{"$f":"H41*'Makro i swap'!E$4","v":0},{"$f":"I41*'Makro i swap'!F$4","v":0},{"$f":"J41*'Makro i swap'!G$4","v":0},{"$f":"K41*'Makro i swap'!H$4","v":0},{"$f":"L41*'Makro i swap'!I$4","v":0},{"$f":"M41*'Makro i swap'!J$4","v":0},{"$f":"N41*'Makro i swap'!K$4","v":0},{"$f":"O41*'Makro i swap'!L$4","v":0}]
[]
[]
[]
["Wynagrodzenia oraz ubezpieczenia społeczne i inne świadczenia - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F46=\"\",F47=\"\"),\"\",F46+F47)","v":0},{"$f":"IF(AND(G46=\"\",G47=\"\"),\"\",G46+G47)","v":0},{"$f":"IF(AND(H46=\"\",H47=\"\"),\"\",H46+H47)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(P46=\"\",P47=\"\"),\"\",P46+P47)","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,{"$f":"H46*'Makro i swap'!E$4*'Makro i swap'!E$5","v":0},{"$f":"I46*'Makro i swap'!F$4*'Makro i swap'!F$5","v":0},{"$f":"J46*'Makro i swap'!G$4*'Makro i swap'!G$5","v":0},{"$f":"K46*'Makro i swap'!H$4*'Makro i swap'!H$5","v":0},{"$f":"L46*'Makro i swap'!I$4*'Makro i swap'!I$5","v":0},{"$f":"M46*'Makro i swap'!J$4*'Makro i swap'!J$5","v":0},{"$f":"N46*'Makro i swap'!K$4*'Makro i swap'!K$5","v":0},{"$f":"O46*'Makro i swap'!L$4*'Makro i swap'!L$5","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,{"$f":"G46*0.161","v":0},0,{"$f":"H47*'Makro i swap'!E$4*'Makro i swap'!E$5","v":0},{"$f":"I47*'Makro i swap'!F$4*'Makro i swap'!F$5","v":0},{"$f":"J47*'Makro i swap'!G$4*'Makro i swap'!G$5","v":0},{"$f":"K47*'Makro i swap'!H$4*'Makro i swap'!H$5","v":0},{"$f":"L47*'Makro i swap'!I$4*'Makro i swap'!I$5","v":0},{"$f":"M47*'Makro i swap'!J$4*'Makro i swap'!J$5","v":0},{"$f":"N47*'Makro i swap'!K$4*'Makro i swap'!K$5","v":0},{"$f":"O47*'Makro i swap'!L$4*'Makro i swap'!L$5","v":0}]
[]
[]
[]
["Pozostałe koszty rodzajowe - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F52=\"\",F53=\"\"),\"\",F52+F53)","v":0},{"$f":"IF(AND(G52=\"\",G53=\"\"),\"\",G52+G53)","v":0},{"$f":"IF(AND(H52=\"\",H53=\"\"),\"\",H52+H53)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(P52=\"\",P53=\"\"),\"\",P52+P53)","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,{"$f":"H52*'Makro i swap'!E$4","v":0},{"$f":"I52*'Makro i swap'!F$4","v":0},{"$f":"J52*'Makro i swap'!G$4","v":0},{"$f":"K52*'Makro i swap'!H$4","v":0},{"$f":"L52*'Makro i swap'!I$4","v":0},{"$f":"M52*'Makro i swap'!J$4","v":0},{"$f":"N52*'Makro i swap'!K$4","v":0},{"$f":"O52*'Makro i swap'!L$4","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,{"$f":"G52*0.161","v":0},0,{"$f":"H53*'Makro i swap'!E$4","v":0},{"$f":"I53*'Makro i swap'!F$4","v":0},{"$f":"J53*'Makro i swap'!G$4","v":0},{"$f":"K53*'Makro i swap'!H$4","v":0},{"$f":"L53*'Makro i swap'!I$4","v":0},{"$f":"M53*'Makro i swap'!J$4","v":0},{"$f":"N53*'Makro i swap'!K$4","v":0},{"$f":"O53*'Makro i swap'!L$4","v":0}]
[]
[]
[]
["Wartość sprzedanych towarów i materiałów - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,{"$f":"G57*'Makro i swap'!D$4/9*12","v":0},{"$f":"H57*'Makro i swap'!E$4","v":0},{"$f":"I57*'Makro i swap'!F$4","v":0},{"$f":"J57*'Makro i swap'!G$4","v":0},{"$f":"K57*'Makro i swap'!H$4","v":0},{"$f":"L57*'Makro i swap'!I$4","v":0},{"$f":"M57*'Makro i swap'!J$4","v":0},{"$f":"N57*'Makro i swap'!K$4","v":0},{"$f":"O57*'Makro i swap'!L$4","v":0}]
[]
[]
[]
["koszty wewnętrzne - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,0,{"$f":"H61*'Makro i swap'!E$4","v":0},{"$f":"I61*'Makro i swap'!F$4","v":0},{"$f":"J61*'Makro i swap'!G$4","v":0},{"$f":"K61*'Makro i swap'!H$4","v":0},{"$f":"L61*'Makro i swap'!I$4","v":0},{"$f":"M61*'Makro i swap'!J$4","v":0},{"$f":"N61*'Makro i swap'!K$4","v":0},{"$f":"O61*'Makro i swap'!L$4","v":0}]
[]
[]
[]
[]
["PRZYCHODY BEZPOŚREDNIO POWIĄZANE Z ZADANIEM",null,"Jednostka",null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Przychody razem - PROGNOZA/WYKONANIE (wynajem kontenera, sprzedaż surowców)",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
["UZYSKANE PRZYSPORZENIA",null,"Jednostka",null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Dokapitalizowanie i inne przysporzenia ze środków publicznych związane z realizacją Zadania - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
["ZYSKI Z ZADAŃ POWIĄZANYCH",null,"Jednostka",null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Przychody z Zadań Powiązanych - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
["Koszty realizacji Zadań Powiązanych - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
["Podatek dochodowy dotyczący Zadań Powiązanych - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(F77=0,0,(F76-F77)*0.19)","v":0},{"$f":"IF(G77=0,0,(G76-G77)*0.19)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(P77=0,0,(P76-P77)*0.19)","v":0}]
["Zysk z Zadań Powiązanych - wartości prognozowane/rzeczywiste w danym roku (przychody-koszty-podatek dochodowy: tylko wartość dodatnia)",null,"PLN",null,null,{"$f":"F76-F77-F78","v":0},{"$f":"G76-G77-G78","v":0},0,0,0,0,0,0,0,0,{"$f":"P76-P77-P78","v":0}]
[]
[]
["KREDYTY I POŻYCZKI",null,"Jednostka",null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Zaciągnięcie kredytów i pożyczek",null,"PLN"]
["Spłata części kapitałowej",null,"PLN"]
[]
["INWESTYCJE I MODERNIZACJE",null,"Jednostka",null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Majątek Spółki zaangażowany w realizację Zadania",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
["Nakłady inwestycyjne i modernizacyjne",null,"PLN",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Wartość rezydualna",null,"PLN"]
[]
["PRZYCHODY I KOSZTY FINANSOWE",null,null,null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Przychody finansowe",null,"PLN"]
["Koszty finansowe",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
["Pozostałe przychody operacyjne",null,"PLN"]
["Pozostałe koszty operacyjne",null,"PLN"]
[]
["PODATEK DOCHODOWY",null,"Jednostka",null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Przychody",null,"PLN",null,null,{"$f":"F$122+F$124+F$115+F$117-F114","v":0},{"$f":"G$122+G$124+G$115+G$117-G114","v":0},0,0,0,0,0,0,0,0,{"$f":"P$122+P$124+P$115+P$117-P114","v":0}]
["Koszty",null,"PLN",null,null,{"$f":"F$112+F$113","v":0},{"$f":"G$112+G$113","v":0},0,0,0,0,0,0,0,0,0]
["Stawka podatku CIT",null,"%",null,null,0.19,0.19,0.19,0.19,0.19,0.19,0.19,0.19,0.19,0.19,0.19]
["Podatek dochodowy - prognoza/wykonanie w danym roku",null,"PLN",null,null,{"$f":"IF((F102-F103)*F104>0,(F102-F103)*F104,\"0\")","v":"0"},{"$f":"IF((G102-G103)*G104>0,(G102-G103)*G104,\"0\")","v":"0"},{"$f":"IF((H102-H103)*H104>0,(H102-H103)*H104,\"0\")","v":"0"},"0","0","0","0","0","0","0",{"$f":"IF((P102-P103)*P104>0,(P102-P103)*P104,\"0\")","v":"0"}]
[]
[]
["WYNAGRODZENIE",null,"Jednostka",null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Uzasadnione koszty netto",null,"PLN",{"$f":"SUM(G110:O110)","v":0},null,{"$f":"F112+F113-F114-F115-F116-F117+F118","v":0},{"$f":"G112+G113-G114-G115-G116-G117+G118","v":0},{"$f":"H112+H113-H114-H115-H116-H117+H118","v":0},0,0,0,0,0,0,0,{"$f":"P112+P113-P114-P115-P116-P117+P118","v":0}]
[]
["Koszty operacyjne",null,"PLN",null,null,{"$f":"F7","v":0},{"$f":"G7","v":0},{"$f":"H7","v":0},0,0,0,0,0,0,0,{"$f":"P7","v":0}]
["Koszty finansowe oraz pozostałe koszty operacyjne",null,"PLN",null,null,{"$f":"F96+F98","v":0},{"$f":"G96+G98","v":0},{"$f":"H96+H98","v":0},0,0,0,0,0,0,0,{"$f":"P96+P98","v":0}]
["Inne przysporzenia ze środków publicznych",null,"PLN",null,null,{"$f":"F$72","v":0},0,0,0,0,0,0,0,0,0,0]
["Przychody finansowe oraz pozostałe przychody operacyjne",null,"PLN",null,null,{"$f":"F$95+F$97","v":0},0,0,0,0,0,0,0,0,0,0]
["Zysk z Zadań Powiązanych",null,"PLN",null,null,{"$f":"F$79","v":0},0,0,0,0,0,0,0,0,0,0]
["Przychody bezpośrednio powiązane z Zadaniem",null,"PLN",null,null,{"$f":"F$68","v":0},0,0,0,0,0,0,0,0,0,0]
["Podatek dochodowy (wkleić wartości)",null,"PLN",null,null,null,null,"0","0","0","0","0","0","0","0","0"]
[]
["Rozsądny zysk",null,"PLN",null,null,{"$f":"F122+F124-F110","v":0},{"$f":"G122+G124-G110","v":0},{"$f":"H122+H124-H110","v":0},{"$f":"I122+I124-I110","v":0},0,0,0,0,0,0,{"$f":"P122+P124-P110","v":0}]
[]
["Rekompensata z uwzględnieniem rozsądnego zysku - prognoza",null,"PLN",1.0303998999999999,null,{"$f":"SUM(F112:F117)","v":0},{"$f":"IF(G124=\"\",G110*$D122,0)","v":0},{"$f":"IF(H124=\"\",H110*$D122,0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(P124=\"\",P110*$D122,0)","v":0}]
[]
["Rekompensata - wykonanie",null,"PLN"]
[]
[]
["KARY",null,"Jednostka",null,null,{"$f":"F$5","v":0},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Naliczone i zapłacone kary z tytułu nienależytej realizacji Zadania",null,"PLN"]
[]
["Naliczone i zapłacone kary z tytułu nienależytej realizacji Zadania",null,"PLN"]
[]
["Naliczone i zapłacone kary z tytułu nienależytej realizacji Zadania",null,"PLN"]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Rekompensata!C37","v":{"$error":"#NUM!"}}]

{"sheet":"Rekompensata","index":3,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,{"$f":"F6/9","v":0},{"$f":"G6/12","v":0},{"$f":"H6/12","v":0}]
["KALKULACJA REKOMPENSATY",null,null,null,0,2024,{"$f":"F2+1","v":2025},{"$f":"G2+1","v":2026},{"$f":"H2+1","v":2027},{"$f":"I2+1","v":2028},{"$f":"J2+1","v":2029},{"$f":"K2+1","v":2030},{"$f":"L2+1","v":2031},{"$f":"M2+1","v":2032},2033]
[null,"Jednostka","RAZEM"]
[]
["WPŁYWY","PLN",{"$f":"SUM(E5:O5)","v":0},null,{"$f":"SUM(E6:E12)","v":0},{"$f":"SUM(F6:F12)","v":0},{"$f":"SUM(G6:G12)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(O6:O12)","v":0}]
["Wynagrodzenie z tytułu realizacji Zadania","PLN",{"$f":"SUM(E6:O6)","v":0},null,{"$f":"'Koszty netto'!F$122+'Koszty netto'!F$124-'Koszty netto'!F114","v":0},{"$f":"'Koszty netto'!G$122+'Koszty netto'!G$124-'Koszty netto'!G114","v":0},{"$f":"'Koszty netto'!H$122+'Koszty netto'!H$124-'Koszty netto'!H114","v":0},{"$f":"'Koszty netto'!I$122+'Koszty netto'!I$124-'Koszty netto'!I114","v":0},{"$f":"'Koszty netto'!J$122+'Koszty netto'!J$124-'Koszty netto'!J114","v":0},{"$f":"'Koszty netto'!K$122+'Koszty netto'!K$124-'Koszty netto'!K114","v":0},{"$f":"'Koszty netto'!L$122+'Koszty netto'!L$124-'Koszty netto'!L114","v":0},{"$f":"'Koszty netto'!M$122+'Koszty netto'!M$124-'Koszty netto'!M114","v":0},{"$f":"'Koszty netto'!N$122+'Koszty netto'!N$124-'Koszty netto'!N114","v":0},{"$f":"'Koszty netto'!O$122+'Koszty netto'!O$124-'Koszty netto'!O114","v":0},{"$f":"'Koszty netto'!P$122+'Koszty netto'!P$124-'Koszty netto'!P114","v":0}]
["Przychody bezpośrednio powiązane z Zadaniem","PLN",{"$f":"SUM(E7:O7)","v":0},null,{"$f":"'Koszty netto'!F$117","v":0},{"$f":"'Koszty netto'!G$117","v":0},{"$f":"'Koszty netto'!H$117","v":0},{"$f":"'Koszty netto'!I$117","v":0},{"$f":"'Koszty netto'!J$117","v":0},{"$f":"'Koszty netto'!K$117","v":0},{"$f":"'Koszty netto'!L$117","v":0},{"$f":"'Koszty netto'!M$117","v":0},{"$f":"'Koszty netto'!N$117","v":0},{"$f":"'Koszty netto'!O$117","v":0},{"$f":"'Koszty netto'!P$117","v":0}]
["Przychody finansowe oraz pozostałe przychody operacyjne","PLN",0,null,{"$f":"'Koszty netto'!F$115","v":0},{"$f":"'Koszty netto'!G$115","v":0},{"$f":"'Koszty netto'!H$115","v":0},{"$f":"'Koszty netto'!I$115","v":0},{"$f":"'Koszty netto'!J$115","v":0},{"$f":"'Koszty netto'!K$115","v":0},{"$f":"'Koszty netto'!L$115","v":0},{"$f":"'Koszty netto'!M$115","v":0},{"$f":"'Koszty netto'!N$115","v":0},{"$f":"'Koszty netto'!O$115","v":0},{"$f":"'Koszty netto'!P$115","v":0}]
["Dokapitalizowanie i inne przysporzenia ze środków publicznych","PLN",0,null,{"$f":"'Koszty netto'!F$114","v":0},{"$f":"'Koszty netto'!G$114","v":0},{"$f":"'Koszty netto'!H$114","v":0},{"$f":"'Koszty netto'!I$114","v":0},{"$f":"'Koszty netto'!J$114","v":0},{"$f":"'Koszty netto'!K$114","v":0},{"$f":"'Koszty netto'!L$114","v":0},{"$f":"'Koszty netto'!M$114","v":0},{"$f":"'Koszty netto'!N$114","v":0},{"$f":"'Koszty netto'!O$114","v":0},{"$f":"'Koszty netto'!P$114","v":0}]
["Zaciągnięte kredyty i pożyczki","PLN",0,null,{"$f":"'Koszty netto'!F$84","v":0},{"$f":"'Koszty netto'!G$84","v":0},{"$f":"'Koszty netto'!H$84","v":0},{"$f":"'Koszty netto'!I$84","v":0},{"$f":"'Koszty netto'!J$84","v":0},{"$f":"'Koszty netto'!K$84","v":0},{"$f":"'Koszty netto'!L$84","v":0},{"$f":"'Koszty netto'!M$84","v":0},{"$f":"'Koszty netto'!N$84","v":0},{"$f":"'Koszty netto'!O$84","v":0},{"$f":"'Koszty netto'!P$84","v":0}]
["Zysk z Zadań Powiązanych","PLN",0,null,{"$f":"'Koszty netto'!F$116","v":0},{"$f":"'Koszty netto'!G$116","v":0},{"$f":"'Koszty netto'!H$116","v":0},{"$f":"'Koszty netto'!I$116","v":0},{"$f":"'Koszty netto'!J$116","v":0},{"$f":"'Koszty netto'!K$116","v":0},{"$f":"'Koszty netto'!L$116","v":0},{"$f":"'Koszty netto'!M$116","v":0},{"$f":"'Koszty netto'!N$116","v":0},{"$f":"'Koszty netto'!O$116","v":0},{"$f":"'Koszty netto'!P$116","v":0}]
["Wartość rezydualna","PLN",0,null,{"$f":"'Koszty netto'!F$91","v":0},{"$f":"'Koszty netto'!G$91","v":0},{"$f":"'Koszty netto'!H$91","v":0},{"$f":"'Koszty netto'!I$91","v":0},{"$f":"'Koszty netto'!J$91","v":0},{"$f":"'Koszty netto'!K$91","v":0},{"$f":"'Koszty netto'!L$91","v":0},{"$f":"'Koszty netto'!M$91","v":0},{"$f":"'Koszty netto'!N$91","v":0},{"$f":"'Koszty netto'!O$91","v":0},{"$f":"'Koszty netto'!P$91","v":0}]
[]
[]
["WYPŁYWY","PLN",{"$f":"SUM(E15:O15)","v":0},null,{"$f":"SUM(E16:E21)","v":0},{"$f":"SUM(F16:F21)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(O16:O21)","v":0}]
["Koszty operacyjne bez amortyzacji","PLN",0,null,{"$f":"'Koszty netto'!F17","v":0},{"$f":"'Koszty netto'!G17","v":0},{"$f":"'Koszty netto'!H17","v":0},{"$f":"'Koszty netto'!I17","v":0},{"$f":"'Koszty netto'!J17","v":0},{"$f":"'Koszty netto'!K17","v":0},{"$f":"'Koszty netto'!L17","v":0},{"$f":"'Koszty netto'!M17","v":0},{"$f":"'Koszty netto'!N17","v":0},{"$f":"'Koszty netto'!O17","v":0},{"$f":"'Koszty netto'!P17","v":0}]
["Koszty finansowe oraz pozostałe koszty operacyjne","PLN",0,null,{"$f":"'Koszty netto'!F$113","v":0},{"$f":"'Koszty netto'!G$113","v":0},{"$f":"'Koszty netto'!H$113","v":0},{"$f":"'Koszty netto'!I$113","v":0},{"$f":"'Koszty netto'!J$113","v":0},{"$f":"'Koszty netto'!K$113","v":0},{"$f":"'Koszty netto'!L$113","v":0},{"$f":"'Koszty netto'!M$113","v":0},{"$f":"'Koszty netto'!N$113","v":0},{"$f":"'Koszty netto'!O$113","v":0},{"$f":"'Koszty netto'!P$113","v":0}]
["Podatek dochodowy","PLN",0,null,{"$f":"'Koszty netto'!F$105","v":"0"},{"$f":"'Koszty netto'!G$105","v":"0"},{"$f":"'Koszty netto'!H$105","v":"0"},{"$f":"'Koszty netto'!I$105","v":"0"},{"$f":"'Koszty netto'!J$105","v":"0"},{"$f":"'Koszty netto'!K$105","v":"0"},{"$f":"'Koszty netto'!L$105","v":"0"},{"$f":"'Koszty netto'!M$105","v":"0"},{"$f":"'Koszty netto'!N$105","v":"0"},{"$f":"'Koszty netto'!O$105","v":"0"},{"$f":"'Koszty netto'!P$105","v":"0"}]
["Majątek Spółki zaangażowany w realizację Zadania","PLN",0,null,{"$f":"'Koszty netto'!F$89","v":0},{"$f":"'Koszty netto'!G$89","v":0},{"$f":"'Koszty netto'!H$89","v":0},{"$f":"'Koszty netto'!I$89","v":0},{"$f":"'Koszty netto'!J$89","v":0},{"$f":"'Koszty netto'!K$89","v":0},{"$f":"'Koszty netto'!L$89","v":0},{"$f":"'Koszty netto'!M$89","v":0},{"$f":"'Koszty netto'!N$89","v":0},{"$f":"'Koszty netto'!O$89","v":0},{"$f":"'Koszty netto'!P$89","v":0}]
["Spłaty rat kapitałowych kredytów i pożyczek","PLN",0,null,{"$f":"'Koszty netto'!F$85","v":0},{"$f":"'Koszty netto'!G$85","v":0},{"$f":"'Koszty netto'!H$85","v":0},{"$f":"'Koszty netto'!I$85","v":0},{"$f":"'Koszty netto'!J$85","v":0},{"$f":"'Koszty netto'!K$85","v":0},{"$f":"'Koszty netto'!L$85","v":0},{"$f":"'Koszty netto'!M$85","v":0},{"$f":"'Koszty netto'!N$85","v":0},{"$f":"'Koszty netto'!O$85","v":0},{"$f":"'Koszty netto'!P$85","v":0}]
["Nakłady inwestycyjne","PLN",0,null,{"$f":"'Koszty netto'!F$90","v":0},{"$f":"'Koszty netto'!G$90","v":0},{"$f":"'Koszty netto'!H$90","v":0},{"$f":"'Koszty netto'!I$90","v":0},{"$f":"'Koszty netto'!J$90","v":0},{"$f":"'Koszty netto'!K$90","v":0},{"$f":"'Koszty netto'!L$90","v":0},{"$f":"'Koszty netto'!M$90","v":0},{"$f":"'Koszty netto'!N$90","v":0},{"$f":"'Koszty netto'!O$90","v":0},{"$f":"'Koszty netto'!P$90","v":0}]
[]
[]
["PRZEPŁYWY NETTO","PLN",{"$f":"SUM(E24:O24)","v":0},null,{"$f":"E5-E15","v":0},{"$f":"F5-F15","v":0},{"$f":"G5-G15","v":0},0,0,0,0,0,0,0,{"$f":"O5-O15","v":0}]
[]
["PRZEPŁYWY NETTO NA DZIAŁALNOŚCI OPERACYJNEJ","PLN",{"$f":"SUM(E26:O26)","v":0},null,{"$f":"E6-E16-E18","v":0},{"$f":"F6-F16-F18","v":0},{"$f":"G6-G16-G18","v":0},0,0,0,0,0,0,0,{"$f":"O6-O16-O18","v":0}]
[]
[]
["KALKULACJA REKOMPENSATY"]
[]
["Uzasadnione koszty netto","PLN",null,null,{"$f":"'Koszty netto'!F$110","v":0},{"$f":"'Koszty netto'!G$110","v":0},{"$f":"'Koszty netto'!H$110","v":0},{"$f":"'Koszty netto'!I$110","v":0},{"$f":"'Koszty netto'!J$110","v":0},{"$f":"'Koszty netto'!K$110","v":0},{"$f":"'Koszty netto'!L$110","v":0},{"$f":"'Koszty netto'!M$110","v":0},{"$f":"'Koszty netto'!N$110","v":0},{"$f":"'Koszty netto'!O$110","v":0},{"$f":"'Koszty netto'!P$110","v":0}]
["Rozsądny zysk","PLN",null,null,{"$f":"'Koszty netto'!F$120","v":0},{"$f":"'Koszty netto'!G$120","v":0},{"$f":"'Koszty netto'!H$120","v":0},{"$f":"'Koszty netto'!I$120","v":0},{"$f":"'Koszty netto'!J$120","v":0},{"$f":"'Koszty netto'!K$120","v":0},{"$f":"'Koszty netto'!L$120","v":0},{"$f":"'Koszty netto'!M$120","v":0},{"$f":"'Koszty netto'!N$120","v":0},{"$f":"'Koszty netto'!O$120","v":0},{"$f":"'Koszty netto'!P$120","v":0}]
["Rekompensata razem","PLN",{"$f":"SUM(E33:O33)","v":0},null,{"$f":"E31+E32","v":0},{"$f":"F31+F32","v":0},{"$f":"G31+G32","v":0},0,0,0,0,0,0,0,{"$f":"O31+O32","v":0}]
[]
[]
["Maksymalna wartość rozsądnego zysku","%",{"$f":"'Makro i swap'!C$9+'Makro i swap'!C$8","v":0}]
["Prognozowana wartość rozsądnego zysku","%",{"$f":"IRR(E24:O24)","v":{"$error":"#NUM!"}},0.96821914998233038]
[]
[{"$f":"IF(C37<=C36,\"REKOMPENSATA NIE JEST NADMIERNA\",\"REKOMPENSATA JEST NADMIERNA\")","v":{"$error":"#NUM!"}}]