{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Wstęp","Makro i swap","Rekompensata Wystawki>>","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":"Wstęp","index":0,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Model bazuje na danych i informacjach otrzymanych od zlecającego oraz uzyskanych ze źródeł publicznych, jeżeli źródła te mogą być racjonalnie uznane za wiarygodne. Zakładamy, że wszelkie otrzymane dane i informacje dotyczące planowanych kosztów i przychodów są aktualne na moment przygotowywania Modelu, dokładne, kompletne i rzetelne. Nie jesteśmy zobowiązani do weryfikacji jakichkolwiek informacji lub dokumentów otrzymanych od zlecającego, w tym informacji dotyczących kosztów i przychodów, udzielonych pożyczek oraz inwestycji zrealizowanych, jak również planowanych do realizacji. \n\nZlecający potwierdza, że Model poprawnie odzwierciedla przekazane przez zlecającego dane, założenia i najlepszą wiedzę zlecającego. \n\nZlecający rozumie, że zmiana jakiegokolwiek założenia, odwołania lub wartości może spowodować zmianę rezultatów Modelu. \n\nPrognozy finansowe otrzymane od zlecającego i założenia zawarte w Modelu nie stanowią zapewnienia osiągnięcia zakładanych w prognozach finansowych wyników finansowych.\n\nModel musi być prezentowany w całości i jest przygotowany jedynie w celach opisanych w umowie między zlecającym a zleceniobiorcą. Model nie może być rozpowszechniany osobom trzecim bez pisemnej zgody zleceniobiorcy.\n"]
[]
[]
[null,null,null,"\n"]

{"sheet":"Makro i swap","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["ZAŁOŻENIA MAKROEKONOMICZNE",null,2022,{"$f":"C2+1","v":2023},{"$f":"D2+1","v":2024},2025,2026,2027,2028,2029,2030,2031]
[]
["Inflacja",null,1.1080000000000001,1.0900000000000001,1.042,1.03,1.03,1.03,1.03,1.03,1.03,1.03]
["Dynamika realnego wzrostu płac",null,1.03,1.03,1.03,1.03,1.03,1.03,1.03,1.03,1.03,1.03]
[]
[]
["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"]
["1.07.2021 – 31.12.2021",null,1.83E-2]

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

{"sheet":"Koszty netto","index":3,"n_rows":182,"n_cols":11,"rows_kept":182,"cut":false,"hidden":false,"merged":[]}
[]
["KOSZTY OPERACYJNE",null,"Jednostka",null,null,2022,{"$f":"F2+1","v":2023},{"$f":"G2+1","v":2024},2025,2026,2027]
[]
["Koszty operacyjne",null,"PLN",0,null,0,0,0,0,{"$f":"SUM(J5:J11)","v":0},0]
["Amortyzacja",null,"PLN",0,null,0,0,0,0,0,0]
["Zużycie materiałów i energii",null,"PLN",0,null,0,0,0,0,0,0]
["Usługi obce",null,"PLN",0,null,0,0,0,0,0,0]
["Podatki i opłaty",null,"PLN",0,null,0,0,0,0,0,0]
["Wynagrodzenia oraz ubezpieczenia społeczne i inne świadczenia",null,"PLN",0,null,0,0,0,0,0,0]
["Pozostałe koszty rodzajowe",null,"PLN",{"$f":"SUM(F10:K10)","v":0},null,{"$f":"IF(F137=\"\",F132,F137)","v":0},0,0,0,0,0]
["Wartość sprzedanych towarów i materiałów",null,"PLN",0,null,{"$f":"IF(F144=\"\",F142,F144)","v":0},0,0,0,0,0]
[]
[]
[]
["Amortyzacja – prognoza",null,"PLN",null,null,0,{"$f":"G16+G17","v":0},0,0,0,0]
["Koszty bezpośrednie",null,"PLN",null,null,0,{"$f":"F16*2","v":0},{"$f":"G16","v":0},{"$f":"H16","v":0},0,0]
["Koszty pośrednie",null,"PLN",null,null,0,{"$f":"G18*G16","v":0},0,0,0,0]
["Klucz podziałowy",null,null,null,null,0,{"$f":"F18","v":0},{"$f":"G18","v":0},0,0,0]
[]
["Amortyzacja –  wartości rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F21=\"\",F22=\"\"),\"\",F21+F22)","v":""},{"$f":"IF(AND(G21=\"\",G22=\"\"),\"\",G21+G22)","v":""},"","","",""]
["Koszty bezpośrednie",null,"PLN"]
["Koszty pośrednie",null,"PLN"]
[]
[]
[]
["Zużycie materiałów i energii – prognoza",null,"PLN",null,null,{"$f":"F27+F28","v":0},0,0,0,0,{"$f":"K27+K28","v":0}]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,0,0,0]
["Koszty pośrednie",null,"PLN",null,null,0,0,0,0,0,0]
["Klucz podziałowy",null,"PLN",null,null,0,{"$f":"F29","v":0},{"$f":"G29","v":0},0,0,0]
[]
["Zużycie materiałów i energii – wartości rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F32=\"\",F33=\"\"),\"\",F32+F33)","v":""},{"$f":"IF(AND(G32=\"\",G33=\"\"),\"\",G32+G33)","v":""},"","","",""]
["Koszty bezpośrednie",null,"PLN"]
["Koszty pośrednie",null,"PLN"]
[]
["Szczegółowe rozbicie kosztów materiałów i energii"]
[]
["Paliwo – ładowarka",null,null,null,null,0,0,0,0,0,0]
["Zużycie",null,"litr",null,null,0,0,0,0,0,0]
["Średnia cena",null,"PLN/litr",null,null,0,{"$f":"F39*'Makro i swap'!D$4","v":0},{"$f":"G39*'Makro i swap'!E$4","v":0},{"$f":"H39*'Makro i swap'!F$4","v":0},{"$f":"I39*'Makro i swap'!G$4","v":0},{"$f":"J39*'Makro i swap'!H$4","v":0}]
[]
["Paliwo – rozdrabniacz",null,null,null,null,{"$f":"F42*F43","v":0},0,0,0,0,0]
["Zużycie",null,"litr",null,null,0,0,0,0,0,0]
["Średnia cena",null,"PLN/litr",null,null,0,{"$f":"G39","v":0},0,0,0,0]
[]
[]
["Usługi obce – prognoza",null,"PLN",null,null,0,{"$f":"G47+G48","v":0},0,0,0,0]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,0,0,0]
["Koszty pośrednie",null,"PLN",null,null,0,0,0,0,0,0]
["Klucz podziałowy",null,null,null,null,0,0,0,{"$f":"H49","v":0},0,0]
[]
["Usługi obce – wartości rzeczywiste w danym roku",null,"PLN",null,null,null,{"$f":"IF(AND(G52=\"\",G53=\"\"),\"\",G52+G53)","v":""},{"$f":"IF(AND(H52=\"\",H53=\"\"),\"\",H52+H53)","v":""},{"$f":"IF(AND(I52=\"\",I53=\"\"),\"\",I52+I53)","v":""},{"$f":"IF(AND(J52=\"\",J53=\"\"),\"\",J52+J53)","v":""},{"$f":"IF(AND(K52=\"\",K53=\"\"),\"\",K52+K53)","v":""}]
["Koszty bezpośrednie",null,"PLN"]
["Koszty pośrednie",null,"PLN"]
[]
["Szczegółowe rozbicie kosztów usług obcych"]
[]
["Wynajem rozdrabniacza",null,"PLN",null,null,{"$f":"F58*F59","v":0},{"$f":"G58*G59","v":0},0,0,0,0]
["Liczba godzin",null,"godz.",null,null,0,{"$f":"F58*2","v":0},{"$f":"G58","v":0},{"$f":"H58","v":0},0,0]
["Stawka jednostkowa",null,"PLN/godz",null,null,0,{"$f":"F59*'Makro i swap'!D$4","v":0},{"$f":"G59*'Makro i swap'!E$4","v":0},{"$f":"H59*'Makro i swap'!F$4","v":0},{"$f":"I59*'Makro i swap'!G$4","v":0},{"$f":"J59*'Makro i swap'!H$4","v":0}]
[]
["Wynajem ładowarki",null,"PLN",null,null,{"$f":"F62+F63","v":0},{"$f":"G62+G63","v":0},0,0,0,0]
["Rata leasingowa",null,"PLN",null,null,0,0,{"$f":"G62","v":0},{"$f":"H62","v":0},0,0]
["Dodatkowy wynajem z rozdrabniaczem",null,"PLN",null,null,0,{"$f":"F63*2","v":0},{"$f":"G63","v":0},{"$f":"H63","v":0},0,0]
[]
["Wynajem wagi najazdowej",null,null,null,null,0,{"$f":"G66*G67","v":0},{"$f":"H66*H67","v":0},{"$f":"I66*I67","v":0},{"$f":"J66*J67","v":0},{"$f":"K66*K67","v":0}]
["Liczba miesięcy",null,"liczba",null,null,0,0,{"$f":"G66","v":0},{"$f":"H66","v":0},{"$f":"I66","v":0},{"$f":"J66","v":0}]
["Stawka miesięczna",null,"PLN",null,null,0,0,{"$f":"G67","v":0},0,0,0]
[]
["Zmiana organizacji ruchu",null,null,null,null,0,{"$f":"G70","v":0},0,0,0,0]
["Wartość usługi",null,"PLN",null,null,0,0,0,0,0,0]
[]
["Zagospodarowanie odpadów 20 03 07",null,"PLN",null,null,{"$f":"F73*F74","v":0},{"$f":"G73*G74","v":0},0,0,0,0]
["Ilość odpadów",null,"tona",null,null,0,{"$f":"F73*2","v":0},{"$f":"G73","v":0},{"$f":"H73","v":0},0,0]
["Średnia stawka za zagospodarowanie",null,"PLN/tona",null,null,0,{"$f":"F74*'Makro i swap'!D$4","v":0},{"$f":"G74*'Makro i swap'!E$4","v":0},{"$f":"H74*'Makro i swap'!F$4","v":0},{"$f":"I74*'Makro i swap'!G$4","v":0},{"$f":"J74*'Makro i swap'!H$4","v":0}]
[]
["Zagospodarowanie odpadów 17 01 03",null,"PLN",null,null,{"$f":"F77*F78","v":0},{"$f":"G77*G78","v":0},{"$f":"H77*H78","v":0},{"$f":"I77*I78","v":0},{"$f":"J77*J78","v":0},{"$f":"K77*K78","v":0}]
["Ilość odpadów",null,"tona",null,null,0,0,{"$f":"G77","v":0},{"$f":"H77","v":0},0,0]
["Średnia stawka za zagospodarowanie",null,"PLN/tona",null,null,0,0,{"$f":"G78*'Makro i swap'!E$4","v":0},{"$f":"H78*'Makro i swap'!F$4","v":0},{"$f":"I78*'Makro i swap'!G$4","v":0},{"$f":"J78*'Makro i swap'!H$4","v":0}]
[]
["Zagospodarowanie odpadów 16 01 03",null,"PLN",null,null,{"$f":"F81*F82","v":0},{"$f":"G81*G82","v":0},{"$f":"H81*H82","v":0},{"$f":"I81*I82","v":0},{"$f":"J81*J82","v":0},{"$f":"K81*K82","v":0}]
["Ilość odpadów",null,"tona",null,null,0,0,{"$f":"G81","v":0},{"$f":"H81","v":0},0,0]
["Średnia stawka za zagospodarowanie",null,"PLN/tona",null,null,0,{"$f":"F82*'Makro i swap'!D$4","v":0},{"$f":"G82*'Makro i swap'!E$4","v":0},{"$f":"H82*'Makro i swap'!F$4","v":0},{"$f":"I82*'Makro i swap'!G$4","v":0},{"$f":"J82*'Makro i swap'!H$4","v":0}]
[]
["Zagospodarowanie odpadów 20 01 35 / 20 01 36",null,"PLN",null,null,{"$f":"F85*F86","v":0},{"$f":"G85*G86","v":0},{"$f":"H85*H86","v":0},{"$f":"I85*I86","v":0},{"$f":"J85*J86","v":0},{"$f":"K85*K86","v":0}]
["Ilość odpadów",null,"tona",null,null,0,0,{"$f":"G85","v":0},{"$f":"H85","v":0},0,0]
["Średnia stawka za zagospodarowanie",null,"PLN/tona",null,null,0,{"$f":"F86*'Makro i swap'!D$4","v":0},{"$f":"G86*'Makro i swap'!E$4","v":0},{"$f":"H86*'Makro i swap'!F$4","v":0},{"$f":"I86*'Makro i swap'!G$4","v":0},{"$f":"J86*'Makro i swap'!H$4","v":0}]
[]
["Dzierżawa terenu",null,null,null,null,{"$f":"(F89*F91+F90*F92)*6","v":0},{"$f":"(G89*G91+G90*G92)*12","v":0},{"$f":"(H89*H91+H90*H92)*12","v":0},0,0,0]
["Place",null,"m2",null,null,0,{"$f":"F89","v":0},{"$f":"G89","v":0},{"$f":"H89","v":0},{"$f":"I89","v":0},{"$f":"J89","v":0}]
["Drogi",null,"m2",null,null,0,{"$f":"F90","v":0},0,0,0,0]
["Stwka dzierżawy – place",null,"PLN/m2",null,null,0,{"$f":"F91*'Makro i swap'!D$4","v":0},{"$f":"G91*'Makro i swap'!E$4","v":0},{"$f":"H91*'Makro i swap'!F$4","v":0},{"$f":"I91*'Makro i swap'!G$4","v":0},{"$f":"J91*'Makro i swap'!H$4","v":0}]
["Stawka dzierżawy – drogi",null,"PLN/m2",null,null,0,{"$f":"F92*'Makro i swap'!D$4","v":0},{"$f":"G92*'Makro i swap'!E$4","v":0},{"$f":"H92*'Makro i swap'!F$4","v":0},{"$f":"I92*'Makro i swap'!G$4","v":0},{"$f":"J92*'Makro i swap'!H$4","v":0}]
[]
[]
["Podatki i opłaty – prognoza",null,"PLN",null,null,{"$f":"F96+F97","v":0},{"$f":"G96+G97","v":0},{"$f":"H96+H97","v":0},0,0,0]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,0,0,0]
["Koszty pośrednie",null,"PLN",null,null,0,0,0,0,0,0]
["Klucz podziałowy",null,null,null,null,0,{"$f":"F98","v":0},{"$f":"G98","v":0},0,0,0]
[]
["Podatki i opłaty – wartości rzeczywiste w danym roku",null,"PLN",null,null,null,null,{"$f":"IF(AND(H101=\"\",H102=\"\"),\"\",H101+H102)","v":""},{"$f":"IF(AND(I101=\"\",I102=\"\"),\"\",I101+I102)","v":""},{"$f":"IF(AND(J101=\"\",J102=\"\"),\"\",J101+J102)","v":""},{"$f":"IF(AND(K101=\"\",K102=\"\"),\"\",K101+K102)","v":""}]
["Koszty bezpośrednie",null,"PLN"]
["Koszty pośrednie",null,"PLN"]
[]
["Szczegółowe rozbicie kosztów podatków i opłat"]
[]
["Podatek od nieruchomości",null,"PLN",null,null,{"$f":"F107*F108/2","v":0},{"$f":"G107*G108","v":0},{"$f":"H107*H108","v":0},0,0,0]
["Stawka podatku",null,"PLN/m2",null,null,0,0,{"$f":"G107*'Makro i swap'!E$4","v":0},{"$f":"H107*'Makro i swap'!F$4","v":0},{"$f":"I107*'Makro i swap'!G$4","v":0},{"$f":"J107*'Makro i swap'!H$4","v":0}]
["Powierzchnia",null,"m2",null,null,0,{"$f":"F108","v":0},{"$f":"G108","v":0},0,0,0]
[]
[]
[]
["Wynagrodzenia oraz ubezpieczenia społeczne i inne świadczenia – prognoza",null,"PLN",null,null,{"$f":"F113+F114","v":0},{"$f":"G113+G114","v":0},{"$f":"H113+H114","v":0},{"$f":"I113+I114","v":0},0,0]
["Koszty bezpośrednie",null,"PLN",null,null,0,0,0,0,0,0]
["Koszty pośrednie",null,"PLN",null,null,0,0,0,0,0,0]
["Klucz podziałowy",null,null,null,null,0,{"$f":"F115","v":0},{"$f":"G115","v":0},0,0,0]
[]
["Wynagrodzenia oraz ubezpieczenia społeczne i inne świadczenia – wartości rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F118=\"\",F119=\"\"),\"\",F118+F119)","v":""},{"$f":"IF(AND(G118=\"\",G119=\"\"),\"\",G118+G119)","v":""},{"$f":"IF(AND(H118=\"\",H119=\"\"),\"\",H118+H119)","v":""},{"$f":"IF(AND(I118=\"\",I119=\"\"),\"\",I118+I119)","v":""},{"$f":"IF(AND(J118=\"\",J119=\"\"),\"\",J118+J119)","v":""},{"$f":"IF(AND(K118=\"\",K119=\"\"),\"\",K118+K119)","v":""}]
["Koszty bezpośrednie",null,"PLN"]
["Koszty pośrednie",null,"PLN"]
[]
["Szczegółowe rozbicie kosztów wynagrodzeń"]
[]
["Wynagrodzenia",null,"PLN",null,null,{"$f":"SUM(F124:F126)","v":0},{"$f":"SUM(G124:G126)","v":0},0,0,0,0]
["Pracownik fizyczny",null,"PLN",null,null,0,{"$f":"F124*2*'Makro i swap'!D4*'Makro i swap'!D5","v":0},{"$f":"G124*'Makro i swap'!E4*'Makro i swap'!E5","v":0},{"$f":"H124*'Makro i swap'!F4*'Makro i swap'!F5","v":0},{"$f":"I124*'Makro i swap'!G4*'Makro i swap'!G5","v":0},{"$f":"J124*'Makro i swap'!H4*'Makro i swap'!H5","v":0}]
["Pracownik administracyjny",null,"PLN",null,null,0,{"$f":"F125*2*'Makro i swap'!D4*'Makro i swap'!D5","v":0},{"$f":"G125*'Makro i swap'!E4*'Makro i swap'!E5","v":0},{"$f":"H125*'Makro i swap'!F4*'Makro i swap'!F5","v":0},{"$f":"I125*'Makro i swap'!G4*'Makro i swap'!G5","v":0},{"$f":"J125*'Makro i swap'!H4*'Makro i swap'!H5","v":0}]
["Operator ładowarki",null,"PLN",null,null,0,0,{"$f":"H127*H128","v":0},0,0,0]
["Stawka godzinowa",null,"PLN/godz.",null,null,0,{"$f":"F127*'Makro i swap'!D4*'Makro i swap'!D5","v":0},{"$f":"G127*'Makro i swap'!E4*'Makro i swap'!E5","v":0},{"$f":"H127*'Makro i swap'!F4*'Makro i swap'!F5","v":0},{"$f":"I127*'Makro i swap'!G4*'Makro i swap'!G5","v":0},{"$f":"J127*'Makro i swap'!H4*'Makro i swap'!H5","v":0}]
["Liczba godzin",null,"godz.",null,null,0,0,0,0,0,0]
[]
[]
[]
["Pozostałe koszty rodzajowe – prognoza",null,"PLN",null,null,{"$f":"F133+F134","v":0},0,0,0,0,0]
["Koszty bezpośrednie",null,"PLN"]
["Koszty pośrednie",null,"PLN"]
["Klucz podziałowy",null,null,null,null,0,0,{"$f":"G135","v":0},0,0,0]
[]
["Pozostałe koszty rodzajowe – wartości rzeczywiste w danym roku",null,"PLN",null,null,{"$f":"IF(AND(F138=\"\",F139=\"\"),\"\",F138+F139)","v":""},{"$f":"IF(AND(G138=\"\",G139=\"\"),\"\",G138+G139)","v":""},{"$f":"IF(AND(H138=\"\",H139=\"\"),\"\",H138+H139)","v":""},{"$f":"IF(AND(I138=\"\",I139=\"\"),\"\",I138+I139)","v":""},{"$f":"IF(AND(J138=\"\",J139=\"\"),\"\",J138+J139)","v":""},{"$f":"IF(AND(K138=\"\",K139=\"\"),\"\",K138+K139)","v":""}]
["Koszty bezpośrednie",null,"PLN"]
["Koszty pośrednie",null,"PLN"]
[]
[]
["Wartość sprzedanych towarów i materiałów – prognoza",null,"PLN"]
[]
["Wartość sprzedanych towarów i materiałów – wartości rzeczywiste w danym roku",null,"PLN"]
[]
[]
[]
[]
[]
["PRZYCHODY BEZPOŚREDNIO POWIĄZANE Z ZADANIEM",null,"Jednostka",null,null,{"$f":"F158","v":2022},{"$f":"F150+1","v":2023},{"$f":"G150+1","v":2024},{"$f":"H150+1","v":2025},{"$f":"I150+1","v":2026},{"$f":"J150+1","v":2027}]
[]
["Przychody ze sprzedaży surowców – drewno",null,"PLN",null,null,{"$f":"F73*0.5*220","v":0},{"$f":"F152*'Makro i swap'!D4","v":0},{"$f":"G152*'Makro i swap'!E4","v":0},{"$f":"H152*'Makro i swap'!F4","v":0},{"$f":"I152*'Makro i swap'!G4","v":0},{"$f":"J152*'Makro i swap'!H4","v":0}]
["Przychody ze zagospodarowania sprzętu elektronicznego",null,"PLN",null,null,{"$f":"F85*280","v":0},{"$f":"F153*'Makro i swap'!D4","v":0},{"$f":"G153*'Makro i swap'!E4","v":0},{"$f":"H153*'Makro i swap'!F4","v":0},{"$f":"I153*'Makro i swap'!G4","v":0},{"$f":"J153*'Makro i swap'!H4","v":0}]
["Przychody razem – PROGNOZA",null,"PLN",null,null,{"$f":"F152+F153","v":0},{"$f":"G152+G153","v":0},0,0,0,0]
["Przychody razem – WYKONANIE",null,"PLN"]
[]
[]
["UZYSKANE PRZYSPORZENIA",null,"Jednostka",null,null,{"$f":"F2","v":2022},{"$f":"F158+1","v":2023},{"$f":"G158+1","v":2024},{"$f":"H158+1","v":2025},{"$f":"I158+1","v":2026},{"$f":"J158+1","v":2027}]
[]
["Dokapitalizowanie i inne przysporzenia ze środków publicznych związane z realizacją zadania – PROGNOZA",null,"PLN"]
["Dokapitalizowanie i inne przysporzenia ze środków publicznych związane z realizacją zadania – WYKONANIE",null,"PLN"]
[]
[]
["PRZYCHODY I KOSZTY FINANSOWE",null,null,null,null,{"$f":"F158","v":2022},{"$f":"F164+1","v":2023},{"$f":"G164+1","v":2024},{"$f":"H164+1","v":2025},{"$f":"I164+1","v":2026},{"$f":"J164+1","v":2027}]
[]
["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":"F164","v":2022},{"$f":"F171+1","v":2023},{"$f":"G171+1","v":2024},{"$f":"H171+1","v":2025},{"$f":"I171+1","v":2026},{"$f":"J171+1","v":2027}]
[]
["Przychody",null,"PLN",null,null,{"$f":"Rekompensata!F17+Rekompensata!F10+Rekompensata!F9","v":0},{"$f":"Rekompensata!G17+Rekompensata!G10+Rekompensata!G9","v":0},{"$f":"Rekompensata!H17+Rekompensata!H10+Rekompensata!H9","v":0},{"$f":"Rekompensata!I17+Rekompensata!I10+Rekompensata!I9","v":0},{"$f":"Rekompensata!J17+Rekompensata!J10+Rekompensata!J9","v":0},{"$f":"Rekompensata!K17+Rekompensata!K10+Rekompensata!K9","v":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}]
["Stawka podatku CIT",null,"%",null,null,0.19,0.19,0.19,0.19,0.19,0.19]
["Podatek dochodowy – prognoza",null,"PLN",null,null,{"$f":"IF(F177=\"\",(F173-F174)*F175,0)","v":0},{"$f":"IF(G177=\"\",(G173-G174)*G175,0)","v":0},0,0,0,0]
["Podatek dochodowy – wykonanie",null,"PLN"]
[]
[]
["KARY",null,"Jednostka",null,null,{"$f":"F171","v":2022},{"$f":"F180+1","v":2023},2024,2025,2026,2027]
[]
["Naliczone i zapłacone kary z tytułu nienależytej realizacji zadania",null,"PLN"]

{"sheet":"Rekompensata","index":4,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
["WYNAGRODZENIE",null,"Jednostka",null,null,{"$f":"'Koszty netto'!F171","v":2022},{"$f":"F2+1","v":2023},2024,2025,2026,2027,"RAZEM"]
[]
["Uzasadnione koszty netto",null,"PLN",null,null,{"$f":"F6+F7-F8-F9-F10+F11","v":0},{"$f":"G6+G7-G8-G9-G10+G11","v":0},0,0,0,0,{"$f":"SUM(F4:K4)","v":0}]
[]
["Koszty operacyjne",null,"PLN",null,null,0,0,0,0,0,0,0]
["Koszty finansowe oraz pozostałe koszty operacyjne",null,"PLN",null,null,{"$f":"'Koszty netto'!F167+'Koszty netto'!F169","v":0},{"$f":"'Koszty netto'!G167+'Koszty netto'!G169","v":0},{"$f":"'Koszty netto'!H167+'Koszty netto'!H169","v":0},{"$f":"'Koszty netto'!I167+'Koszty netto'!I169","v":0},{"$f":"'Koszty netto'!J167+'Koszty netto'!J169","v":0},{"$f":"'Koszty netto'!K167+'Koszty netto'!K169","v":0},{"$f":"SUM(F7:K7)","v":0}]
["Inne przysporzenia ze środków publicznych",null,"PLN",null,null,{"$f":"IF('Koszty netto'!F161=\"\",'Koszty netto'!F160,'Koszty netto'!F161)","v":0},{"$f":"IF('Koszty netto'!G161=\"\",'Koszty netto'!G160,'Koszty netto'!G161)","v":0},{"$f":"IF('Koszty netto'!H161=\"\",'Koszty netto'!H160,'Koszty netto'!H161)","v":0},{"$f":"IF('Koszty netto'!I161=\"\",'Koszty netto'!I160,'Koszty netto'!I161)","v":0},{"$f":"IF('Koszty netto'!J161=\"\",'Koszty netto'!J160,'Koszty netto'!J161)","v":0},{"$f":"IF('Koszty netto'!K161=\"\",'Koszty netto'!K160,'Koszty netto'!K161)","v":0},0]
["Przychody finansowe oraz pozostałe przychody operacyjne",null,"PLN",null,null,{"$f":"'Koszty netto'!F166+'Koszty netto'!F168","v":0},{"$f":"'Koszty netto'!G166+'Koszty netto'!G168","v":0},{"$f":"'Koszty netto'!H166+'Koszty netto'!H168","v":0},{"$f":"'Koszty netto'!I166+'Koszty netto'!I168","v":0},{"$f":"'Koszty netto'!J166+'Koszty netto'!J168","v":0},{"$f":"'Koszty netto'!K166+'Koszty netto'!K168","v":0},0]
["Przychody bezpośrednio powiązane z zadaniem",null,"PLN",null,null,0,0,0,0,0,0,0]
["Podatek dochodowy (wkleić wartości)",null,"PLN",null,null,0,0,0,0,0,0,0]
[null,null,null,null,"19%*rozsądny zysk"]
["Rozsądny zysk",null,"PLN",null,null,0,0,0,0,0,0,0]
[]
["Należna rekompensata z uwzględnieniem rozsądnego zysku – prognoza",null,"PLN",1.0126446301911913,null,{"$f":"F4+F13","v":0},0,0,0,0,0,{"$f":"SUM(F15:K15)","v":0}]
[]
["Przychody na bramie",null,"PLN",null,null,0,0,0,0,0,0,{"$f":"SUM(F17:K17)","v":0}]
[]
[]
["Maksymalna wartość rozsądnego zysku","%",{"$f":"'Makro i swap'!C9+'Makro i swap'!C8","v":2.8299999999999999E-2}]
[]
["Weryfikacja rozsądnego zysku",null,"Jednostka",null,null,{"$f":"F2","v":2022},{"$f":"F22+1","v":2023},{"$f":"G22+1","v":2024},{"$f":"H22+1","v":2025},{"$f":"I22+1","v":2026},{"$f":"J22+1","v":2027}]
["Kapitał własny na początek okresu",null,null,null,null,0,0,{"$f":"G23*'Makro i swap'!E4","v":0},{"$f":"H23*'Makro i swap'!F4","v":0},{"$f":"I23*'Makro i swap'!G4","v":0},{"$f":"J23*'Makro i swap'!H4","v":0}]
["Kapitał własny na koniec okresu",null,null,null,null,0,0,{"$f":"G24*'Makro i swap'!E4","v":0},{"$f":"H24*'Makro i swap'!F4","v":0},{"$f":"I24*'Makro i swap'!G4","v":0},{"$f":"J24*'Makro i swap'!H4","v":0}]
["Średni kapitał własny Spółki",null,null,null,null,0,{"$f":"(G23+G24)/2","v":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*'Makro i swap'!H4","v":0}]
["Przychody z tyt. realizacji zadania",null,null,null,null,{"$f":"F17+F10+F9","v":0},0,0,0,0,0]
["Udział przychodowy",null,null,null,null,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]
["Kwota rozsądnego zysku",null,null,null,null,{"$f":"F13","v":0},0,0,0,0,0]
["Stopa zwrotu z kapitału własnego",null,null,null,null,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"]
[]
[]
[]
["Kalkulacja stawki na bramie",null,"Jednostka",null,null,{"$f":"F2","v":2022},{"$f":"F39+1","v":2023},{"$f":"G39+1","v":2024},{"$f":"H39+1","v":2025},{"$f":"I39+1","v":2026},{"$f":"J39+1","v":2027}]
[{"$f":"#REF!*100","v":{"$error":"#REF!"}}]
["Należna rekompensata z rozsądnym zyskiem",null,"PLN",null,null,{"$f":"F15","v":0},0,0,0,0,0]
[]
["Ilość odpadów 20 03 07",null,"Mg",null,null,0,0,0,0,0,0]
["Ilość odpadów 17 01 03",null,"Mg",null,null,0,0,0,0,0,0]
["Ilość odpadów 16 01 03",null,"Mg",null,null,0,0,0,0,0,0]
["Ilość odpadów 20 01 35 / 20 01 36",null,"Mg",null,null,0,0,0,0,0,0]
["Ilość odpadów RAZEM",null,"Mg",null,null,0,0,0,0,0,0]
[]
["Udział odpadów"]
["20 03 07",null,"%",null,null,0,0,0,0,0,0]
["17 01 03",null,"%",null,null,0,0,0,0,0,0]
["16 01 03",null,"%",null,null,0,0,0,0,0,0]
["20 01 35 / 20 01 36",null,"%",null,null,0,0,0,0,0,0]
[]
["Należna rekompensata według kodu odpadów"]
["20 03 07",null,"PLN",null,null,0,0,0,0,0,0]
["17 01 03",null,"PLN",null,null,0,0,0,0,0,0]
["16 01 03",null,"PLN",null,null,0,0,0,0,0,0]
["20 01 35 / 20 01 36",null,"PLN",null,null,0,0,0,0,0,0]
[]
["STAWKI NA BRAMIE"]
["20 03 07",null,"PLN/Mg",null,null,0,0,0,0,0,0]
["17 01 03",null,"PLN/Mg",null,null,0,0,0,0,0,0]
["16 01 03",null,"PLN/Mg",null,null,0,0,0,0,0,0]
["20 01 35 / 20 01 36",null,"PLN/Mg",null,null,0,0,0,0,0,0]