{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Makro i swap","Rekompensata Wartostrada>>","Koszty netto","Rekompensata"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":12,"n_cols":12,"rows_kept":12,"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",null,1.0660000000000001,1.0409999999999999,1.0309999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999]
["Dynamika realnego wzrostu płac",null,1.03,1.028,1.028,1.0249999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999,1.0249999999999999]
[]
[]
["Stopy SWAP dla SGEI - Komisja Europejska","Marża",0.01,null,"https://ec.europa.eu/competition-policy/state-aid/legislation/sgei/swap-rate-proxies_en"]
["01.07.2023 - 31.12.2023",null,2.5399999999999999E-2]
[]
[]
["The swap rates valid from 01.01.2022 to 30.06.2022 "]

{"sheet":"Rekompensata Wartostrada>>","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":133,"n_cols":16,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["KOSZTY OPERACYJNE",null,"Jednostka",null,null,2023,2024,{"$f":"G5+1","v":2025},{"$f":"H5+1","v":2026},2027,2028,2029,2030,2031,2032,2033]
[]
["Koszty operacyjne",null,"PLN",0,null,{"$f":"SUM(F8:F15)","v":0},0,{"$f":"SUM(H8:H15)","v":0},0,0,0,0,0,0,0,0]
["Amortyzacja",null,"PLN",0,null,{"$f":"F$21","v":0},0,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,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",{"$f":"SUM(G13:P13)","v":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 - zagospodarowanie na składowisku",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",0,null,{"$f":"F7-F8","v":0},{"$f":"G7-G8","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Amortyzacja - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F22=\"\",F23=\"\"),\"\",F22+F23)","v":0},0,0,0,{"$f":"IF(AND(J22=\"\",J23=\"\"),\"\",J22+J23)","v":0},0,0,0,0,0,0]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,0,0,{"$f":"J22","v":0},0,0,0,0,0]
["Koszty pośrednie",null,"PLN",null,null,0,0,0,0,{"$f":"I23","v":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},0,{"$f":"IF(AND(H28=\"\",H29=\"\"),\"\",H28+H29)","v":0},0,0,0,0,0,0,0,0]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,{"$f":"G28*'Makro i swap'!D4","v":0},{"$f":"H28*'Makro i swap'!E4","v":0},{"$f":"I28*'Makro i swap'!F4","v":0},{"$f":"J28*'Makro i swap'!G4","v":0},{"$f":"K28*'Makro i swap'!H4","v":0},{"$f":"L28*'Makro i swap'!I4","v":0},{"$f":"M28*'Makro i swap'!J4","v":0},{"$f":"N28*'Makro i swap'!K4","v":0},{"$f":"O28*'Makro i swap'!L4","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,0,{"$f":"G29*'Makro i swap'!D4","v":0},{"$f":"H29*'Makro i swap'!E4","v":0},{"$f":"I29*'Makro i swap'!F4","v":0},{"$f":"J29*'Makro i swap'!G4","v":0},{"$f":"K29*'Makro i swap'!H4","v":0},{"$f":"L29*'Makro i swap'!I4","v":0},{"$f":"M29*'Makro i swap'!J4","v":0},{"$f":"N29*'Makro i swap'!K4","v":0},{"$f":"O29*'Makro i swap'!L4","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},0,{"$f":"IF(AND(H34=\"\",H35=\"\"),\"\",H34+H35)","v":0},{"$f":"IF(AND(I34=\"\",I35=\"\"),\"\",I34+I35)","v":0},{"$f":"IF(AND(J34=\"\",J35=\"\"),\"\",J34+J35)","v":0},{"$f":"IF(AND(K34=\"\",K35=\"\"),\"\",K34+K35)","v":0},{"$f":"IF(AND(L34=\"\",L35=\"\"),\"\",L34+L35)","v":0},{"$f":"IF(AND(M34=\"\",M35=\"\"),\"\",M34+M35)","v":0},{"$f":"IF(AND(N34=\"\",N35=\"\"),\"\",N34+N35)","v":0},{"$f":"IF(AND(O34=\"\",O35=\"\"),\"\",O34+O35)","v":0},{"$f":"IF(AND(P34=\"\",P35=\"\"),\"\",P34+P35)","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,{"$f":"G34*'Makro i swap'!D4","v":0},{"$f":"H34*'Makro i swap'!E4","v":0},{"$f":"I34*'Makro i swap'!F4","v":0},{"$f":"J34*'Makro i swap'!G4","v":0},{"$f":"K34*'Makro i swap'!H4","v":0},{"$f":"L34*'Makro i swap'!I4","v":0},{"$f":"M34*'Makro i swap'!J4","v":0},{"$f":"N34*'Makro i swap'!K4","v":0},{"$f":"O34*'Makro i swap'!L4","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,0,{"$f":"G35*'Makro i swap'!D4","v":0},{"$f":"H35*'Makro i swap'!E4","v":0},{"$f":"I35*'Makro i swap'!F4","v":0},{"$f":"J35*'Makro i swap'!G4","v":0},{"$f":"K35*'Makro i swap'!H4","v":0},{"$f":"L35*'Makro i swap'!I4","v":0},{"$f":"M35*'Makro i swap'!J4","v":0},{"$f":"N35*'Makro i swap'!K4","v":0},{"$f":"O35*'Makro i swap'!L4","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},{"$f":"IF(AND(I40=\"\",I41=\"\"),\"\",I40+I41)","v":0},{"$f":"IF(AND(J40=\"\",J41=\"\"),\"\",J40+J41)","v":0},{"$f":"IF(AND(K40=\"\",K41=\"\"),\"\",K40+K41)","v":0},{"$f":"IF(AND(L40=\"\",L41=\"\"),\"\",L40+L41)","v":0},{"$f":"IF(AND(M40=\"\",M41=\"\"),\"\",M40+M41)","v":0},{"$f":"IF(AND(N40=\"\",N41=\"\"),\"\",N40+N41)","v":0},{"$f":"IF(AND(O40=\"\",O41=\"\"),\"\",O40+O41)","v":0},{"$f":"IF(AND(P40=\"\",P41=\"\"),\"\",P40+P41)","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]
[]
[]
[]
["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},0,{"$f":"IF(AND(H46=\"\",H47=\"\"),\"\",H46+H47)","v":0},{"$f":"IF(AND(I46=\"\",I47=\"\"),\"\",I46+I47)","v":0},{"$f":"IF(AND(J46=\"\",J47=\"\"),\"\",J46+J47)","v":0},{"$f":"IF(AND(K46=\"\",K47=\"\"),\"\",K46+K47)","v":0},{"$f":"IF(AND(L46=\"\",L47=\"\"),\"\",L46+L47)","v":0},{"$f":"IF(AND(M46=\"\",M47=\"\"),\"\",M46+M47)","v":0},{"$f":"IF(AND(N46=\"\",N47=\"\"),\"\",N46+N47)","v":0},{"$f":"IF(AND(O46=\"\",O47=\"\"),\"\",O46+O47)","v":0},{"$f":"IF(AND(P46=\"\",P47=\"\"),\"\",P46+P47)","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,{"$f":"G46*'Makro i swap'!D4*'Makro i swap'!D5","v":0},{"$f":"H46*'Makro i swap'!E4*'Makro i swap'!E5","v":0},{"$f":"I46*'Makro i swap'!F4*'Makro i swap'!F5","v":0},{"$f":"J46*'Makro i swap'!G4*'Makro i swap'!G5","v":0},{"$f":"K46*'Makro i swap'!H4*'Makro i swap'!H5","v":0},{"$f":"L46*'Makro i swap'!I4*'Makro i swap'!I5","v":0},{"$f":"M46*'Makro i swap'!J4*'Makro i swap'!J5","v":0},{"$f":"N46*'Makro i swap'!K4*'Makro i swap'!K5","v":0},{"$f":"O46*'Makro i swap'!L4*'Makro i swap'!L5","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,0,{"$f":"G47*'Makro i swap'!D4*'Makro i swap'!D5","v":0},{"$f":"H47*'Makro i swap'!E4*'Makro i swap'!E5","v":0},{"$f":"I47*'Makro i swap'!F4*'Makro i swap'!F5","v":0},{"$f":"J47*'Makro i swap'!G4*'Makro i swap'!G5","v":0},{"$f":"K47*'Makro i swap'!H4*'Makro i swap'!H5","v":0},{"$f":"L47*'Makro i swap'!I4*'Makro i swap'!I5","v":0},{"$f":"M47*'Makro i swap'!J4*'Makro i swap'!J5","v":0},{"$f":"N47*'Makro i swap'!K4*'Makro i swap'!K5","v":0},{"$f":"O47*'Makro i swap'!L4*'Makro i swap'!L5","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},{"$f":"IF(AND(I52=\"\",I53=\"\"),\"\",I52+I53)","v":0},{"$f":"IF(AND(J52=\"\",J53=\"\"),\"\",J52+J53)","v":0},{"$f":"IF(AND(K52=\"\",K53=\"\"),\"\",K52+K53)","v":0},{"$f":"IF(AND(L52=\"\",L53=\"\"),\"\",L52+L53)","v":0},{"$f":"IF(AND(M52=\"\",M53=\"\"),\"\",M52+M53)","v":0},{"$f":"IF(AND(N52=\"\",N53=\"\"),\"\",N52+N53)","v":0},{"$f":"IF(AND(O52=\"\",O53=\"\"),\"\",O52+O53)","v":0},{"$f":"IF(AND(P52=\"\",P53=\"\"),\"\",P52+P53)","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]
[]
[]
[]
["Wartość sprzedanych towarów i materiałów - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
["koszty wewnętrzne - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
["PRZYCHODY BEZPOŚREDNIO POWIĄZANE Z ZADANIEM",null,"Jednostka",null,null,{"$f":"F$5","v":2023},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":2023},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":2023},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,{"$f":"H77*'Makro i swap'!E4","v":0},{"$f":"I77*'Makro i swap'!F4","v":0},{"$f":"J77*'Makro i swap'!G4","v":0},{"$f":"K77*'Makro i swap'!H4","v":0},{"$f":"L77*'Makro i swap'!I4","v":0},{"$f":"M77*'Makro i swap'!J4","v":0},{"$f":"N77*'Makro i swap'!K4","v":0},{"$f":"O77*'Makro i swap'!L4","v":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},{"$f":"IF(H77=0,0,(H76-H77)*0.19)","v":0},0,0,0,0,0,0,0,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},{"$f":"H76-H77-H78","v":0},0,0,0,0,0,0,0,0]
[]
[]
["KREDYTY I POŻYCZKI",null,"Jednostka",null,null,{"$f":"F$5","v":2023},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":2023},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"]
["Wartość rezydualna",null,"PLN"]
[]
["PRZYCHODY I KOSZTY FINANSOWE",null,null,null,null,{"$f":"F$5","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Przychody finansowe",null,"PLN"]
["Koszty finansowe",null,"PLN"]
["Pozostałe przychody operacyjne",null,"PLN"]
["Pozostałe koszty operacyjne",null,"PLN"]
[]
["PODATEK DOCHODOWY",null,"Jednostka",null,null,{"$f":"F$5","v":2023},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,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","0"]
[]
[]
["WYNAGRODZENIE",null,"Jednostka",null,null,{"$f":"F$5","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Uzasadnione koszty netto",null,"PLN",{"$f":"SUM(G110:P110)","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,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,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,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,null,{"$f":"G122+G124-G110","v":0},{"$f":"H122+H124-H110","v":0},0,0,0,0,0,0,0,0]
[]
["Rekompensata z uwzględnieniem rozsądnego zysku - prognoza",null,"PLN",1.006621,null,{"$f":"SUM(F112:F117)","v":0},{"$f":"IF(G124=\"\",G110*$D122,0)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Rekompensata - wykonanie",null,"PLN"]
[]
[]
["KARY",null,"Jednostka",null,null,{"$f":"F$5","v":2023},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"]

{"sheet":"Rekompensata","index":3,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,{"$f":"E6/12","v":0},{"$f":"F6/12","v":0},{"$f":"G6/12","v":0},0]
["KALKULACJA REKOMPENSATY",null,null,null,2023,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},{"$f":"N2+1","v":2033}]
[null,"Jednostka","RAZEM"]
[]
["WPŁYWY","PLN",{"$f":"SUM(F5:O5)","v":0},null,{"$f":"SUM(E6:E12)","v":0},{"$f":"SUM(F6:F12)","v":0},0,0,0,0,0,0,0,0,0]
["Wynagrodzenie z tytułu realizacji Zadania","PLN",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",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(F15:O15)","v":0},null,{"$f":"SUM(E16:E21)","v":0},{"$f":"SUM(F16:F21)","v":0},0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,0,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(F24: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,0]
[]
["PRZEPŁYWY NETTO NA DZIAŁALNOŚCI OPERACYJNEJ","PLN",{"$f":"SUM(F26: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,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(F33: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,0]
[]
[]
["Maksymalna wartość rozsądnego zysku","%",{"$f":"'Makro i swap'!C$9+'Makro i swap'!C$8","v":3.5400000000000001E-2}]
["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!"}}]
[]
[]
[]
[{"$f":"C37*100","v":{"$error":"#NUM!"}}]