{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RZiS","Bilans","Przepływy"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"RZiS","index":0,"n_rows":35,"n_cols":26,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,7,2,7],[31,2,31,3],[32,2,32,3]]}
[" "]
[null,"Tabela nr 1. Rachunek zysków i strat",null,null,null,null,null,"PIERWSZY ROK PROGNOZY"]
[]
[null,"Lp.","Rachunek zysków i strat","Jedn.",{"$f":"IF($H$4=\"\",\"n-3\",IF($H$4=\"n\",\"n-3\",$H$4-3))","v":2020},{"$f":"IF($H$4=\"\",\"n-2\",IF($H$4=\"n\",\"n-2\",$H$4-2))","v":2021},{"$f":"IF($H$4=\"\",\"n-1\",IF($H$4=\"n\",\"n-1\",$H$4-1))","v":2022},2023,{"$f":"IF($H$4=\"\",\"n+1\",IF($H$4=\"n\",\"n+1\",$H$4+1))","v":2024},{"$f":"IF($H$4=\"\",\"n+2\",IF($H$4=\"n\",\"n+2\",$H$4+2))","v":2025},{"$f":"IF($H$4=\"\",\"n+3\",IF($H$4=\"n\",\"n+3\",$H$4+3))","v":2026},{"$f":"IF($H$4=\"\",\"n+4\",IF($H$4=\"n\",\"n+4\",$H$4+4))","v":2027},{"$f":"IF($H$4=\"\",\"n+5\",IF($H$4=\"n\",\"n+5\",$H$4+5))","v":2028},{"$f":"IF($H$4=\"\",\"n+6\",IF($H$4=\"n\",\"n+6\",$H$4+6))","v":2029},{"$f":"IF($H$4=\"\",\"n+7\",IF($H$4=\"n\",\"n+7\",$H$4+7))","v":2030},{"$f":"IF($H$4=\"\",\"n+8\",IF($H$4=\"n\",\"n+8\",$H$4+8))","v":2031},{"$f":"IF($H$4=\"\",\"n+9\",IF($H$4=\"n\",\"n+9\",$H$4+9))","v":2032},{"$f":"IF($H$4=\"\",\"n+10\",IF($H$4=\"n\",\"n+10\",$H$4+10))","v":2033},{"$f":"IF($H$4=\"\",\"n+11\",IF($H$4=\"n\",\"n+11\",$H$4+11))","v":2034},{"$f":"IF($H$4=\"\",\"n+12\",IF($H$4=\"n\",\"n+12\",$H$4+12))","v":2035},{"$f":"IF($H$4=\"\",\"n+13\",IF($H$4=\"n\",\"n+13\",$H$4+13))","v":2036},{"$f":"IF($H$4=\"\",\"n+14\",IF($H$4=\"n\",\"n+14\",$H$4+14))","v":2037},{"$f":"IF($H$4=\"\",\"n+15\",IF($H$4=\"n\",\"n+15\",$H$4+15))","v":2038},{"$f":"IF($H$4=\"\",\"n+16\",IF($H$4=\"n\",\"n+16\",$H$4+16))","v":2039},{"$f":"IF($H$4=\"\",\"n+17\",IF($H$4=\"n\",\"n+17\",$H$4+17))","v":2040},"…"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,"…"]
[null,"A.","Przychody netto ze sprzedaży i zrównane z nimi","zł"]
[null,"B.","Koszty działalności operacyjnej","zł",{"$f":"SUM(E8:E15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z8:Z15)","v":0}]
[null,"I.","Amortyzacja","zł"]
[null,"II.","Zużycie materiałów i energii","zł"]
[null,"III.","Usługi obce","zł"]
[null,"IV.","Podatki i opłaty","zł"]
[null,"V.","Wynagrodzenia","zł"]
[null,"VI.","Ubezpieczenia społeczne i inne świadczenia","zł"]
[null,"VII.","Pozostałe koszty rodzajowe","zł"]
[null,"VIII.","Wartość sprzedanych towarów i materiałów","zł"]
[null,"C.","Zysk/strata ze sprzedaży (A-B)","zł",{"$f":"E6-E7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z6-Z7","v":0}]
[null,"D.","Pozostałe przychody operacyjne, w tym:","zł"]
[null,null," - rozliczenie wnioskowanej dotacji z MF EOG","zł"]
[null,"E.","Pozostałe koszty operacyjne","zł"]
[null,"F.","Zysk/strata z działalności operacyjnej (C+D-E)","zł",{"$f":"E16+E17-E19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z16+Z17-Z19","v":0}]
[null,"G.","Przychody finansowe","zł"]
[null,"H.","Koszty finansowe, w tym:","zł"]
[null,null," - odsetki od wnioskowanej pożyczki z NFOŚiGW (jeżeli dotyczy)","zł"]
[null,"I.","Zysk/strata brutto (F+G-H)","zł",{"$f":"E20+E21-E22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z20+Z21-Z22","v":0}]
[null,"J.","Podatek dochodowy","zł"]
[null,"K.","Pozostałe obowiązkowe zmniejszenie zysku/zwiększenie straty","zł"]
[null,"L.","Zysk/strata netto (I-J-K)","zł",{"$f":"E24-E25-E26","v":0},{"$f":"F24-F25-F26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"T24-T25-T26","v":0},0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,"………………………………………………………………."]
[null,null,"Data i podpis Wnioskodawcy"]
[]
[null,null,"UWAGA: Należy wypełnić tylko pola zaznaczone żółtym kolorem."]

{"sheet":"Bilans","index":1,"n_rows":50,"n_cols":26,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,7,2,7],[44,2,44,3],[45,2,45,3]]}
[]
[null,"Tabela nr 2. Bilans",null,null,null,null,null,"PIERWSZY ROK PROGNOZY"]
[]
[null,"Lp.","Bilans","Jedn.",{"$f":"IF($H$4=\"\",\"n-3\",IF($H$4=\"n\",\"n-3\",$H$4-3))","v":2020},{"$f":"IF($H$4=\"\",\"n-2\",IF($H$4=\"n\",\"n-2\",$H$4-2))","v":2021},{"$f":"IF($H$4=\"\",\"n-1\",IF($H$4=\"n\",\"n-1\",$H$4-1))","v":2022},2023,{"$f":"IF($H$4=\"\",\"n+1\",IF($H$4=\"n\",\"n+1\",$H$4+1))","v":2024},{"$f":"IF($H$4=\"\",\"n+2\",IF($H$4=\"n\",\"n+2\",$H$4+2))","v":2025},{"$f":"IF($H$4=\"\",\"n+3\",IF($H$4=\"n\",\"n+3\",$H$4+3))","v":2026},{"$f":"IF($H$4=\"\",\"n+4\",IF($H$4=\"n\",\"n+4\",$H$4+4))","v":2027},{"$f":"IF($H$4=\"\",\"n+5\",IF($H$4=\"n\",\"n+5\",$H$4+5))","v":2028},{"$f":"IF($H$4=\"\",\"n+6\",IF($H$4=\"n\",\"n+6\",$H$4+6))","v":2029},{"$f":"IF($H$4=\"\",\"n+7\",IF($H$4=\"n\",\"n+7\",$H$4+7))","v":2030},{"$f":"IF($H$4=\"\",\"n+8\",IF($H$4=\"n\",\"n+8\",$H$4+8))","v":2031},{"$f":"IF($H$4=\"\",\"n+9\",IF($H$4=\"n\",\"n+9\",$H$4+9))","v":2032},{"$f":"IF($H$4=\"\",\"n+10\",IF($H$4=\"n\",\"n+10\",$H$4+10))","v":2033},{"$f":"IF($H$4=\"\",\"n+11\",IF($H$4=\"n\",\"n+11\",$H$4+11))","v":2034},{"$f":"IF($H$4=\"\",\"n+12\",IF($H$4=\"n\",\"n+12\",$H$4+12))","v":2035},{"$f":"IF($H$4=\"\",\"n+13\",IF($H$4=\"n\",\"n+13\",$H$4+13))","v":2036},{"$f":"IF($H$4=\"\",\"n+14\",IF($H$4=\"n\",\"n+14\",$H$4+14))","v":2037},{"$f":"IF($H$4=\"\",\"n+15\",IF($H$4=\"n\",\"n+15\",$H$4+15))","v":2038},{"$f":"IF($H$4=\"\",\"n+16\",IF($H$4=\"n\",\"n+16\",$H$4+16))","v":2039},{"$f":"IF($H$4=\"\",\"n+17\",IF($H$4=\"n\",\"n+17\",$H$4+17))","v":2040},"…"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,"…"]
[null,null,"AKTYWA"]
[null,"A.","Aktywa trwałe","zł",{"$f":"E8+E9+E11+E12+E13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"I.","Wartości niematerialne i prawne","zł"]
[null,"II.","Rzeczowe aktywa trwałe, w tym:","zł"]
[null,null," - z tytułu wnioskowanego przedsięwzięcia","zł"]
[null,"III.","Należności długoterminowe","zł"]
[null,"IV.","Inwestycje długoterminowe","zł"]
[null,"V.","Długoterminowe rozliczenia międzyokresowe","zł"]
[null,"B.","Aktywa obrotowe","zł",{"$f":"E15+E16+E17+E19","v":0},{"$f":"F15+F16+F17+F19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"I.","Zapasy","zł"]
[null,"II.","Należności krótkoterminowe","zł"]
[null,"III.","Inwestycje krótkoterminowe, w tym:","zł"]
[null,null," - środki pieniężne i inne aktywa pieniężne","zł"]
[null,"IV.","Krótkoterminowe rozliczenia międzyokresowe","zł"]
[null,"C.","Należne wpłaty na kapitał (fundusz) podstawowy","zł"]
[null,"D.","Udziały (akcje) własne","zł"]
[null,null,"Aktywa razem (A+B)","zł",{"$f":"E14+E7+E20+E21","v":0},{"$f":"F14+F7+F20+F21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"PASYWA"]
[null,"A.","Kapitał (fundusz) własny","zł",{"$f":"SUM(E25:E31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"I.","Kapitał (fundusz) podstawowy","zł"]
[null,"II.","Kapitał (fundusz) zapasowy","zł"]
[null,"III.","Kapitał (fundusz) rezerwowy z aktualizacji wyceny","zł"]
[null,"IV.","Pozostałe kapitały (fundusze) rezerwowe","zł"]
[null,"V.","Zysk (strata) z lat ubiegłych","zł"]
[null,"VI.","Zysk (strata) netto","zł"]
[null,"VII.","Odpisy z zysku netto w ciągu roku obrotowego (-)","zł"]
[null,"B.","Zobowiązania i rezerwy na zobowiązania","zł",{"$f":"E33+E34+E36+E38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"I.","Rezerwy na zobowiązania","zł"]
[null,"II.","Zobowiązania długoterminowe, w tym:","zł"]
[null,null," - z tytułu wnioskowanej pożyczki z NFOŚiGW (jeżeli dotyczy)","zł"]
[null,"III.","Zobowiązania krótkoterminowe, w tym:","zł"]
[null,null," - z tytułu wnioskowanej pożyczki z NFOŚiGW (jeżeli dotyczy)","zł"]
[null,"IV.","Rozliczenia międzyokresowe, w tym:","zł"]
[null,null," - rozliczenie wnioskowanej dotacji z MF EOG","zł"]
[null,null,"Suma Pasywów (A+B)","zł",{"$f":"E32+E24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IF(ROUND(E22,2)=ROUND(E40,2),\"\",\"BŁĄD\")","v":""},{"$f":"IF(F22=F40,\"\",\"BŁĄD\")","v":""},"","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[null,null,"………………………………………………………………."]
[null,null,"Data i podpis Wnioskodawcy"]
[]
[null,null,"UWAGA: Należy wypełnić tylko pola zaznaczone żółtym kolorem."]
[]
[null,null,"sprawdzenie",null,{"$f":"E40=E22","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true]

{"sheet":"Przepływy","index":2,"n_rows":47,"n_cols":26,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,7,2,7],[42,2,42,3],[43,2,43,3]]}
[]
[null,"Tabela nr 3. Rachunek przepływów pieniężnych",null,null,null,null,null,"PIERWSZY ROK PROGNOZY"]
[]
[null,"Lp.","Rachunek przepływów pieniężnych","Jedn.",{"$f":"IF($H$4=\"\",\"n-3\",IF($H$4=\"n\",\"n-3\",$H$4-3))","v":2020},{"$f":"IF($H$4=\"\",\"n-2\",IF($H$4=\"n\",\"n-2\",$H$4-2))","v":2021},{"$f":"IF($H$4=\"\",\"n-1\",IF($H$4=\"n\",\"n-1\",$H$4-1))","v":2022},2023,{"$f":"IF($H$4=\"\",\"n+1\",IF($H$4=\"n\",\"n+1\",$H$4+1))","v":2024},{"$f":"IF($H$4=\"\",\"n+2\",IF($H$4=\"n\",\"n+2\",$H$4+2))","v":2025},{"$f":"IF($H$4=\"\",\"n+3\",IF($H$4=\"n\",\"n+3\",$H$4+3))","v":2026},{"$f":"IF($H$4=\"\",\"n+4\",IF($H$4=\"n\",\"n+4\",$H$4+4))","v":2027},{"$f":"IF($H$4=\"\",\"n+5\",IF($H$4=\"n\",\"n+5\",$H$4+5))","v":2028},{"$f":"IF($H$4=\"\",\"n+6\",IF($H$4=\"n\",\"n+6\",$H$4+6))","v":2029},{"$f":"IF($H$4=\"\",\"n+7\",IF($H$4=\"n\",\"n+7\",$H$4+7))","v":2030},{"$f":"IF($H$4=\"\",\"n+8\",IF($H$4=\"n\",\"n+8\",$H$4+8))","v":2031},{"$f":"IF($H$4=\"\",\"n+9\",IF($H$4=\"n\",\"n+9\",$H$4+9))","v":2032},{"$f":"IF($H$4=\"\",\"n+10\",IF($H$4=\"n\",\"n+10\",$H$4+10))","v":2033},{"$f":"IF($H$4=\"\",\"n+11\",IF($H$4=\"n\",\"n+11\",$H$4+11))","v":2034},{"$f":"IF($H$4=\"\",\"n+12\",IF($H$4=\"n\",\"n+12\",$H$4+12))","v":2035},{"$f":"IF($H$4=\"\",\"n+13\",IF($H$4=\"n\",\"n+13\",$H$4+13))","v":2036},{"$f":"IF($H$4=\"\",\"n+14\",IF($H$4=\"n\",\"n+14\",$H$4+14))","v":2037},{"$f":"IF($H$4=\"\",\"n+15\",IF($H$4=\"n\",\"n+15\",$H$4+15))","v":2038},{"$f":"IF($H$4=\"\",\"n+16\",IF($H$4=\"n\",\"n+16\",$H$4+16))","v":2039},{"$f":"IF($H$4=\"\",\"n+17\",IF($H$4=\"n\",\"n+17\",$H$4+17))","v":2040},"…"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,"…"]
[null,"A.","Przepływy środków pieniężnych z działalności operacyjnej"]
[null,"I.","Zysk ( strata ) netto","zł",{"$f":"RZiS!E27","v":0},{"$f":"RZiS!F27","v":0},{"$f":"RZiS!G27","v":0},{"$f":"RZiS!H27","v":0},{"$f":"RZiS!I27","v":0},{"$f":"RZiS!J27","v":0},{"$f":"RZiS!K27","v":0},{"$f":"RZiS!L27","v":0},{"$f":"RZiS!M27","v":0},{"$f":"RZiS!N27","v":0},{"$f":"RZiS!O27","v":0},{"$f":"RZiS!P27","v":0},{"$f":"RZiS!Q27","v":0},{"$f":"RZiS!R27","v":0},{"$f":"RZiS!S27","v":0},{"$f":"RZiS!T27","v":0},{"$f":"RZiS!U27","v":0},{"$f":"RZiS!V27","v":0},{"$f":"RZiS!W27","v":0},{"$f":"RZiS!X27","v":0},{"$f":"RZiS!Y27","v":0},{"$f":"RZiS!Z27","v":0}]
[null,"II.","Korekty razem","zł",{"$f":"SUM(E9:E18)","v":0},{"$f":"SUM(F9:F18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"1.","Amortyzacja","zł",{"$f":"RZiS!E8","v":0},{"$f":"RZiS!F8","v":0},{"$f":"RZiS!G8","v":0},{"$f":"RZiS!H8","v":0},{"$f":"RZiS!I8","v":0},{"$f":"RZiS!J8","v":0},{"$f":"RZiS!K8","v":0},{"$f":"RZiS!L8","v":0},{"$f":"RZiS!M8","v":0},{"$f":"RZiS!N8","v":0},{"$f":"RZiS!O8","v":0},{"$f":"RZiS!P8","v":0},{"$f":"RZiS!Q8","v":0},{"$f":"RZiS!R8","v":0},{"$f":"RZiS!S8","v":0},{"$f":"RZiS!T8","v":0},{"$f":"RZiS!U8","v":0},{"$f":"RZiS!V8","v":0},{"$f":"RZiS!W8","v":0},{"$f":"RZiS!X8","v":0},{"$f":"RZiS!Y8","v":0},{"$f":"RZiS!Z8","v":0}]
[null,"2.","Zysk/strata z tytułu różnic kursowych","zł"]
[null,"3.","Odsetki i udziały w zyskach (dywidendy)","zł"]
[null,"4.","Zysk/strata z działalności inwestycyjnej","zł"]
[null,"5.","Zmiana stanu rezerw","zł"]
[null,"6.","Zmiana stanu zapasów ","zł"]
[null,"7.","Zmiana stanu należności","zł"]
[null,"8.","Zmiana stanu zobowiązań krótkoterminowych, z wyjątkiem pożyczek i kredytów","zł"]
[null,"9.","Zmiana stanu rozliczeń międzyokresowych","zł"]
[null,"10.","Inne korekty","zł"]
[null,"III.","Przepływy pieniężne netto z działalności operacyjnej (I±II)","zł",{"$f":"E7+E8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"B.","Przepływy środków pieniężnych z działalności inwestycyjnej"]
[null,"I.","Wpływy","zł"]
[null,"II.","Wydatki, w tym:","zł"]
[null,null," - z tytułu wnioskowanego przedsięwzięcia","zł"]
[null,"III.","Przepływy pieniężne netto z działalności inwestycyjnej (I-II)","zł",{"$f":"E21-E22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"C.","Przepływy środków pieniężnych z działalności finansowej"]
[null,"I.","Wpływy, w tym:","zł"]
[null,null," - z tytułu wnioskowanej dotacji MF EOG / pożyczki z NFOŚiGW (jeżeli dotyczy)","zł"]
[null,"II.","Wydatki, w tym:","zł"]
[null,null,"Spłaty kredytów i pożyczek, w tym:","zł"]
[null,null," - z tytułu wnioskowanej pożyczki z NFOŚiGW (jeżeli dotyczy)","zł"]
[null,null,"Odsetki, w tym:","zł"]
[null,null," - spłata odsetek od wnioskowanej pożyczki z NFOŚiGW (jeżeli dotyczy)","zł"]
[null,null,"Pozostałe wydatki finansowe","zł"]
[null,"III.","Przepływy pieniężne netto z działalności finansowej  (I-II)","zł",{"$f":"E26-E28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"D.","Przepływy pieniężne netto razem (A.III±B.III±C.III)","zł",{"$f":"E19+E24+E34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"E.","Bilansowa zmiana stanu środków pieniężnych","zł"]
[null,"F.","Środki pieniężne na początek okresu","zł"]
[null,"G.","Środki pieniężne na koniec okresu (F±D)","zł",{"$f":"E37+E35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,"………………………………………………………………."]
[null,null,"Data i podpis Wnioskodawcy"]
[]
[]
[null,null,"UWAGA: Należy wypełnić tylko pola zaznaczone żółtym kolorem."]