{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Makro i swap","Rekompensata Palmiarnia>>","Koszty netto","Rekompensata"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":12,"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 Palmiarnia>>","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":112,"n_cols":19,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["KOSZTY OPERACYJNE",null,"Jednostka",null,null,2024,{"$f":"F5+1","v":2025},{"$f":"G5+1","v":2026},2027,2028,2029,2030,2031,2032,2033]
[]
["Koszty operacyjne",null,"PLN",0,null,0,0,0,0,0,0,0,0,0,0]
["Amortyzacja",null,"PLN",0,null,0,0,0,0,0,0,0,0,0,0]
["Zużycie materiałów i energii",null,"PLN",0,null,0,0,0,0,0,0,0,0,0,0]
["Usługi obce",null,"PLN",0,null,0,0,0,0,0,0,0,0,0,0]
["Podatki i opłaty",null,"PLN",{"$f":"SUM(F11:O11)","v":0},null,{"$f":"F$39","v":0},0,0,0,0,0,0,0,0,0]
["Wynagrodzenia oraz ubezpieczenia społeczne i inne świadczenia",null,"PLN",0,null,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]
["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]
["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]
[]
["Koszty operacyjne bez amortyzacji",null,"PLN",0,null,{"$f":"F7-F8","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Amortyzacja - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,{"$f":"IF(AND(H22=\"\",H23=\"\"),\"\",H22+H23)","v":0},0,0,0,0,0,0,0]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,{"$f":"G22","v":0},0,0,0,0,0,0,0]
["Koszty pośrednie",null,"PLN",null,null,0,0,{"$f":"G23","v":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,0,0,{"$f":"IF(AND(H28=\"\",H29=\"\"),\"\",H28+H29)","v":0},0,0,0,0,0,0,0]
["Koszty bezpośrednie",null,"PLN",null,null,0,{"$f":"F28/9*12*'Makro i swap'!D4","v":0},{"$f":"G28*'Makro i swap'!E4","v":0},{"$f":"H28*'Makro i swap'!F4","v":0},{"$f":"I28*'Makro i swap'!G4","v":0},{"$f":"J28*'Makro i swap'!H4","v":0},{"$f":"K28*'Makro i swap'!I4","v":0},{"$f":"L28*'Makro i swap'!J4","v":0},{"$f":"M28*'Makro i swap'!K4","v":0},{"$f":"N28*'Makro i swap'!L4","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,{"$f":"F29/9*12*'Makro i swap'!D4","v":0},{"$f":"G29*'Makro i swap'!E4","v":0},{"$f":"H29*'Makro i swap'!F4","v":0},{"$f":"I29*'Makro i swap'!G4","v":0},{"$f":"J29*'Makro i swap'!H4","v":0},{"$f":"K29*'Makro i swap'!I4","v":0},{"$f":"L29*'Makro i swap'!J4","v":0},{"$f":"M29*'Makro i swap'!K4","v":0},{"$f":"N29*'Makro i swap'!L4","v":0}]
[]
[]
[]
["Usługi obce - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,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}]
["Koszty bezpośrednie",null,"PLN",null,null,0,{"$f":"F34/9*12*'Makro i swap'!D4","v":0},{"$f":"G34*'Makro i swap'!E4","v":0},{"$f":"H34*'Makro i swap'!F4","v":0},{"$f":"I34*'Makro i swap'!G4","v":0},{"$f":"J34*'Makro i swap'!H4","v":0},{"$f":"K34*'Makro i swap'!I4","v":0},{"$f":"L34*'Makro i swap'!J4","v":0},{"$f":"M34*'Makro i swap'!K4","v":0},{"$f":"N34*'Makro i swap'!L4","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,{"$f":"F35/9*12*'Makro i swap'!D4","v":0},{"$f":"G35*'Makro i swap'!E4","v":0},{"$f":"H35*'Makro i swap'!F4","v":0},{"$f":"I35*'Makro i swap'!G4","v":0},{"$f":"J35*'Makro i swap'!H4","v":0},{"$f":"K35*'Makro i swap'!I4","v":0},{"$f":"L35*'Makro i swap'!J4","v":0},{"$f":"M35*'Makro i swap'!K4","v":0},{"$f":"N35*'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}]
["Koszty bezpośrednie",null,"PLN",null,null,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]
[]
[]
[]
["Wynagrodzenia oraz ubezpieczenia społeczne i inne świadczenia - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,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}]
["Koszty bezpośrednie",null,"PLN",null,null,0,{"$f":"F46/9*12*'Makro i swap'!D4*'Makro i swap'!D5","v":0},{"$f":"G46*'Makro i swap'!E4*'Makro i swap'!E5","v":0},{"$f":"H46*'Makro i swap'!F4*'Makro i swap'!F5","v":0},{"$f":"I46*'Makro i swap'!G4*'Makro i swap'!G5","v":0},{"$f":"J46*'Makro i swap'!H4*'Makro i swap'!H5","v":0},{"$f":"K46*'Makro i swap'!I4*'Makro i swap'!I5","v":0},{"$f":"L46*'Makro i swap'!J4*'Makro i swap'!J5","v":0},{"$f":"M46*'Makro i swap'!K4*'Makro i swap'!K5","v":0},{"$f":"N46*'Makro i swap'!L4*'Makro i swap'!L5","v":0}]
["Koszty pośrednie",null,"PLN",null,null,0,{"$f":"F47/9*12*'Makro i swap'!D4*'Makro i swap'!D5","v":0},{"$f":"G47*'Makro i swap'!E4*'Makro i swap'!E5","v":0},{"$f":"H47*'Makro i swap'!F4*'Makro i swap'!F5","v":0},{"$f":"I47*'Makro i swap'!G4*'Makro i swap'!G5","v":0},{"$f":"J47*'Makro i swap'!H4*'Makro i swap'!H5","v":0},{"$f":"K47*'Makro i swap'!I4*'Makro i swap'!I5","v":0},{"$f":"L47*'Makro i swap'!J4*'Makro i swap'!J5","v":0},{"$f":"M47*'Makro i swap'!K4*'Makro i swap'!K5","v":0},{"$f":"N47*'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}]
["Koszty bezpośrednie",null,"PLN",null,null,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]
[]
[]
[]
["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]
[]
[]
[]
["koszty wewnętrzne - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,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":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]
[]
["UZYSKANE PRZYSPORZENIA",null,"Jednostka",null,null,{"$f":"F$5","v":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]
[]
["ZYSKI Z ZADAŃ POWIĄZANYCH",null,"Jednostka",null,null,{"$f":"F$5","v":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]
["Koszty realizacji Zadań Powiązanych - wartości prognozowane/rzeczywiste w danym roku",null,"PLN",null,null,0,0,{"$f":"G77*'Makro i swap'!E4","v":0},{"$f":"H77*'Makro i swap'!F4","v":0},{"$f":"I77*'Makro i swap'!G4","v":0},{"$f":"J77*'Makro i swap'!H4","v":0},{"$f":"K77*'Makro i swap'!I4","v":0},{"$f":"L77*'Makro i swap'!J4","v":0},{"$f":"M77*'Makro i swap'!K4","v":0},{"$f":"N77*'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},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},0,0,0,0,0,0,0,0]
[]
[]
["KREDYTY I POŻYCZKI",null,"Jednostka",null,null,{"$f":"F$5","v":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":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]
["Nakłady inwestycyjne i modernizacyjne",null,"PLN"]
["Wartość rezydualna",null,"PLN"]
[]
["PRZYCHODY I KOSZTY FINANSOWE",null,null,null,null,{"$f":"F$5","v":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":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033]
[]
["Przychody",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0]
["Koszty",null,"PLN",null,null,{"$f":"Rekompensata!F6+Rekompensata!F7","v":0},{"$f":"Rekompensata!G6+Rekompensata!G7","v":0},{"$f":"Rekompensata!H6+Rekompensata!H7","v":0},{"$f":"Rekompensata!I6+Rekompensata!I7","v":0},{"$f":"Rekompensata!J6+Rekompensata!J7","v":0},{"$f":"Rekompensata!K6+Rekompensata!K7","v":0},{"$f":"Rekompensata!L6+Rekompensata!L7","v":0},{"$f":"Rekompensata!M6+Rekompensata!M7","v":0},{"$f":"Rekompensata!N6+Rekompensata!N7","v":0},{"$f":"Rekompensata!O6+Rekompensata!O7","v":0}]
["Stawka podatku CIT",null,"%",null,null,0,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"},0,0,0,0,{"$f":"IF((K102-K103)*K104>0,(K102-K103)*K104,\"0\")","v":"0"},"0","0","0","0"]
[]
[]
[]
[]
["KARY",null,"Jednostka",null,null,{"$f":"F$5","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,null,null,null,"`"]
[]
["Naliczone i zapłacone kary z tytułu nienależytej realizacji Zadania",null,"PLN"]

{"sheet":"Rekompensata","index":3,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
["WYNAGRODZENIE",null,"Jednostka",null,null,2024,{"$f":"F2+1","v":2025},2026,2027,2028,2029,{"$f":"K2+1","v":2030},{"$f":"L2+1","v":2031},{"$f":"M2+1","v":2032},{"$f":"N2+1","v":2033},"RAZEM"]
[]
["Uzasadnione koszty netto",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F4:O4)","v":0}]
[]
["Koszty operacyjne",null,"PLN",null,null,{"$f":"'Koszty netto'!F7","v":0},{"$f":"'Koszty netto'!G7","v":0},{"$f":"'Koszty netto'!H7","v":0},{"$f":"'Koszty netto'!I7","v":0},{"$f":"'Koszty netto'!J7","v":0},{"$f":"'Koszty netto'!K7","v":0},{"$f":"'Koszty netto'!L7","v":0},{"$f":"'Koszty netto'!M7","v":0},{"$f":"'Koszty netto'!N7","v":0},{"$f":"'Koszty netto'!O7","v":0},{"$f":"SUM(F6:O6)","v":0}]
["Koszty finansowe oraz pozostałe koszty operacyjne",null,"PLN",null,null,{"$f":"'[1]Koszty netto'!F167+'[1]Koszty netto'!F169","v":0},{"$f":"'[1]Koszty netto'!G167+'[1]Koszty netto'!G169","v":0},{"$f":"'[1]Koszty netto'!H167+'[1]Koszty netto'!H169","v":0},{"$f":"'[1]Koszty netto'!I167+'[1]Koszty netto'!I169","v":0},{"$f":"'[1]Koszty netto'!J167+'[1]Koszty netto'!J169","v":0},{"$f":"'[1]Koszty netto'!K167+'[1]Koszty netto'!K169","v":0},{"$f":"'[1]Koszty netto'!L167+'[1]Koszty netto'!L169","v":0},{"$f":"'[1]Koszty netto'!M167+'[1]Koszty netto'!M169","v":0},{"$f":"'[1]Koszty netto'!N167+'[1]Koszty netto'!N169","v":0},{"$f":"'[1]Koszty netto'!O167+'[1]Koszty netto'!O169","v":0},0]
["Inne przysporzenia ze środków publicznych",null,"PLN",null,null,{"$f":"IF('[1]Koszty netto'!F161=\"\",'[1]Koszty netto'!F160,'[1]Koszty netto'!F161)","v":0},{"$f":"IF('[1]Koszty netto'!G161=\"\",'[1]Koszty netto'!G160,'[1]Koszty netto'!G161)","v":0},{"$f":"IF('[1]Koszty netto'!H161=\"\",'[1]Koszty netto'!H160,'[1]Koszty netto'!H161)","v":0},{"$f":"IF('[1]Koszty netto'!I161=\"\",'[1]Koszty netto'!I160,'[1]Koszty netto'!I161)","v":0},{"$f":"IF('[1]Koszty netto'!J161=\"\",'[1]Koszty netto'!J160,'[1]Koszty netto'!J161)","v":0},{"$f":"IF('[1]Koszty netto'!K161=\"\",'[1]Koszty netto'!K160,'[1]Koszty netto'!K161)","v":0},{"$f":"IF('[1]Koszty netto'!L161=\"\",'[1]Koszty netto'!L160,'[1]Koszty netto'!L161)","v":0},{"$f":"IF('[1]Koszty netto'!M161=\"\",'[1]Koszty netto'!M160,'[1]Koszty netto'!M161)","v":0},{"$f":"IF('[1]Koszty netto'!N161=\"\",'[1]Koszty netto'!N160,'[1]Koszty netto'!N161)","v":0},{"$f":"IF('[1]Koszty netto'!O161=\"\",'[1]Koszty netto'!O160,'[1]Koszty netto'!O161)","v":0},0]
["Przychody finansowe oraz pozostałe przychody operacyjne",null,"PLN",null,null,{"$f":"'[1]Koszty netto'!F166+'[1]Koszty netto'!F168","v":0},{"$f":"'[1]Koszty netto'!G166+'[1]Koszty netto'!G168","v":0},{"$f":"'[1]Koszty netto'!H166+'[1]Koszty netto'!H168","v":0},{"$f":"'[1]Koszty netto'!I166+'[1]Koszty netto'!I168","v":0},{"$f":"'[1]Koszty netto'!J166+'[1]Koszty netto'!J168","v":0},{"$f":"'[1]Koszty netto'!K166+'[1]Koszty netto'!K168","v":0},{"$f":"'[1]Koszty netto'!L166+'[1]Koszty netto'!L168","v":0},{"$f":"'[1]Koszty netto'!M166+'[1]Koszty netto'!M168","v":0},{"$f":"'[1]Koszty netto'!N166+'[1]Koszty netto'!N168","v":0},{"$f":"'[1]Koszty netto'!O166+'[1]Koszty netto'!O168","v":0},0]
["Przychody bezpośrednio powiązane z zadaniem",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
["Podatek dochodowy (wkleić wartości)",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"19%*rozsądny zysk"]
["Rozsądny zysk",null,"PLN",null,1.0960000000000001,0,0,0,0,0,0,0,0,0,0,0]
[]
["Należna rekompensata z uwzględnieniem rozsądnego zysku – prognoza",null,"PLN",1.0126446301911913,null,0,0,0,0,0,0,0,0,0,0,0]
[]
["Rekompensata - wykonanie",null,"PLN",null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F17:O17)","v":0}]
[]
[]
["Maksymalna wartość rozsądnego zysku","%",3.5400000000000001E-2]
[]
["Weryfikacja rozsądnego zysku",null,"Jednostka",null,null,{"$f":"F2","v":2024},{"$f":"F22+1","v":2025},2026,2027,2028,2029,{"$f":"K22+1","v":2030},{"$f":"L22+1","v":2031},{"$f":"M22+1","v":2032},{"$f":"N22+1","v":2033}]
["Kapitał własny na początek okresu",null,null,null,null,0,{"$f":"F24","v":0},{"$f":"G24","v":0},0,0,0,0,0,0,0]
["Kapitał własny na koniec okresu",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Średni kapitał własny Spółki",null,null,null,null,0,{"$f":"(G23+G24)/2","v":0},0,0,0,0,0,0,0,0]
[]
["Przychody ze sprzedaży Spółki",null,null,null,null,0,{"$f":"F27*'Makro i swap'!D4","v":0},{"$f":"G27*'Makro i swap'!E4","v":0},{"$f":"H27*'Makro i swap'!F4","v":0},{"$f":"I27*'Makro i swap'!G4","v":0},{"$f":"J27*'[1]Makro i swap'!H4","v":0},{"$f":"K27*'[1]Makro i swap'!I4","v":0},{"$f":"L27*'[1]Makro i swap'!J4","v":0},{"$f":"M27*'[1]Makro i swap'!K4","v":0},{"$f":"N27*'[1]Makro i swap'!L4","v":0}]
["Przychody z tyt. realizacji zadania",null,null,null,null,{"$f":"F15","v":0},{"$f":"G15","v":0},0,0,0,0,0,0,0,0]
["Udział przychodowy",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Kapitał własny będący podstawą kalkulacji stopy zwrotu z kapitału własnego",null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"O29*O25","v":0}]
["Kwota rozsądnego zysku",null,null,null,null,{"$f":"F13","v":0},0,0,0,0,0,0,0,0,0]
["Stopa zwrotu z kapitału własnego",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F33*100","v":0},{"$f":"G33*100","v":0},0,0,0,0]
["Czy rozsądny zysk jest nadmierny?",null,null,null,null,{"$f":"IF(F33<=$C$20,\"NIE\",\"TAK\")","v":"NIE"},"NIE","NIE","NIE","NIE","NIE","NIE","NIE","NIE","NIE"]