{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Założenia","prognoza sprzedaży","plan inwestycyjny"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Założenia","index":0,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,"Jednostka",null,"Rok bieżący",1,2,3,4,5]
["Przychody ze sprzedaży"]
[]
["Liczba sprzedanych usług / produktów"]
["Usługa / Produkt 1","szt."]
["Usługa / Produkt 2","szt."]
["Usługa / Produkt 3","szt."]
["Usługa / Produkt 4","szt."]
["Usługa / Produkt 5","szt."]
["Suma",null,null,{"$f":"SUM(D5:D9)","v":0},0,0,0,0,0]
[]
[]
["Cena jednostkowa"]
["Usługa / Produkt 1","PLN",null,null,{"$f":"D14*(1+E$22)","v":0},{"$f":"E14*(1+F$22)","v":0},{"$f":"F14*(1+G$22)","v":0},{"$f":"G14*(1+H$22)","v":0},{"$f":"H14*(1+I$22)","v":0}]
["Usługa / Produkt 2","PLN",null,null,{"$f":"D15*(1+E$22)","v":0},0,0,0,0]
["Usługa / Produkt 3","PLN",null,null,0,0,0,0,0]
["Usługa / Produkt 4","PLN",null,null,0,0,0,0,0]
["Usługa / Produkt 5","PLN",null,null,0,0,0,0,0]
[]
["Sprzedaż towarów i materiałów","PLN"]
[]
["zmiana cen","%"]
[]
["Koszty jednostkowy świadczenia usług"]
["Usługa / Produkt 1","PLN",null,null,{"$f":"D25*(1+E$31)","v":0},{"$f":"E25*(1+F$31)","v":0},{"$f":"F25*(1+G$31)","v":0},{"$f":"G25*(1+H$31)","v":0},{"$f":"H25*(1+I$31)","v":0}]
["Usługa / Produkt 2","PLN",null,null,{"$f":"D26*(1+E$31)","v":0},0,0,0,0]
["Usługa / Produkt 3","PLN",null,null,0,0,0,0,0]
["Usługa / Produkt 4","PLN",null,null,0,0,0,0,0]
["Usługa / Produkt 5","PLN",null,null,0,0,0,0,0]
[]
["zmiana cen","%"]
[]
["Koszty operacyjne"]
[]
["Zużycie materiałów i energii","PLN/m"]
[]
["Wynagrodzenia"]
["Pracownik 1","PLN/m",null,null,{"$f":"E45*D38/100","v":0}]
["Pracownik 2","PLN/m",null,null,{"$f":"E45*D39/100","v":0}]
["Pracownik 3","PLN/m",null,null,{"$f":"E45*D40/100","v":0}]
["Pracownik 4","PLN/m",null,null,{"$f":"E45*D41/100","v":0}]
["Pracownik 5","PLN/m",null,null,{"$f":"E45*D42/100","v":0}]
["Suma","PLN/m",null,{"$f":"SUM(D38:D42)","v":0},0,0,0,0,0]
[]
["Wzrost płac"]
[]
["Ubezpieczenia społeczne i inne świadczenia ","%",null,0.1865,0.1865,0.1865,0.1865,0.1865,0.1865]
[]
["Usługi obce","PLN/a"]
[]
["Podatki i opłaty","PLN/a"]
[]
["Pozostałe koszty","PLN/a"]
[]
["Koszt zakupu towarów i materiałów","PLN",null,{"$f":"$C55*D20","v":0},0,0,0,0,0]
[]
["Podatek dochodowy","%",null,0.19,0.19,0.19,0.19,0.19,0.19]
[]
["Inwestycje"]
["Maszyny i urządzenia","PLN"]
["Środki transportu","PLN"]
["WNIP (oprogramowanie, licencje, patenty etc)","PLN"]
["Suma",null,null,{"$f":"SUM(D60:D62)","v":0},0,0,0,0,0]
[]
["Bilans"]
["Zapasy (w dniach do przychodów)","dni",null,30,30,30,30,30,30]
["Należności","dni",null,30,30,30,30,30,30]
["Zobowiązania handlowe","dni",null,30,30,30,30,30,30]
[]
["CF"]
["Zaciągnięcie kredytów i pożyczek ","PLN"]
["Spłata kredytów i pożyczek ","PLN"]
["Wypłaty na rzecz właścicieli","PLN"]
["Wpłaty dokonane przez właścicieli","PLN"]
[]
["Wybierz poziom ryzyka"]
[null,"niski"]
["średni","średni"]
[null,"wysoki"]

{"sheet":"prognoza sprzedaży","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,"Rok bieżący",1,2,3,4,5]
[]
["Przychody ze sprzedaży produktów i usług",null,0,0,0,0,0,0]
["Przychody ze sprzedaży towarów i materiałów",null,0,0,0,0,0,0]
[]
[]
["Przychody roczne razem",null,{"$f":"SUM(C3:C6)","v":0},0,0,0,0,0]
[]
["Koszty wytworzenia produktów i usług",null,0,0,0,0,0,0]
["Koszt nabycia towarów i materiałów ",null,0,0,0,0,0,0]
["Koszty wytworzenia razem",null,{"$f":"SUM(C9:C10)","v":0},0,0,0,0,0]
[]
["Marża na sprzedazy",null,{"$f":"C7-C11","v":0},0,0,0,0,0]
[null,null,{"$f":"C13/C7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"plan inwestycyjny","index":2,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,"Rok bieżący",1,2,3,4,5]
[]
["Nakłady na maszyny i urządzenia",null,0,0,0,0,0,0]
["Pozostałe nakłady kapitałowe rzeczowe",null,0,0,0,0,0,0]
["WNIP",null,0,0,0,0,0,0]
["RAZEM",null,{"$f":"C3+C4+C5","v":0},0,0,0,0,0,{"$f":"SUM(D6:H6)","v":0}]
[]
[]
["W tym koszty kwalifikowane",1,{"$f":"B9*C6","v":0},0,0,0,0,0]
[]
[]
["Amortyzacja"]
["okres amortyzacji lata"]
["Maszyny i urządzenia",5]
["Pozostałe",5]
["WNIP",5]
[]
["Rozliczenie amortyzacji"]
["Nakłady na maszyny i urządzenia",null,null,{"$f":"MIN(SUM($C3:D3)/$B$14,SUM($C$3:D3)-SUM($C$19:C19))","v":0},{"$f":"MIN(SUM($C3:E3)/$B$14,SUM($C$3:E3)-SUM($C$19:D19))","v":0},{"$f":"MIN(SUM($C3:F3)/$B$14,SUM($C$3:F3)-SUM($C$19:E19))","v":0},{"$f":"MIN(SUM($C3:G3)/$B$14,SUM($C$3:G3)-SUM($C$19:F19))","v":0},{"$f":"MIN(SUM($C3:H3)/$B$14,SUM($C$3:H3)-SUM($C$19:G19))","v":0},{"$f":"SUM(D19:H19)","v":0}]
["Pozostałe nakłady kapitałowe rzeczowe",null,null,{"$f":"SUM($C$4:D4)/$B$15","v":0},{"$f":"SUM($C$4:E4)/$B$15","v":0},{"$f":"SUM($C$4:F4)/$B$15","v":0},{"$f":"SUM($C$4:G4)/$B$15","v":0},{"$f":"SUM($C$4:H4)/$B$15","v":0},{"$f":"SUM(D20:H20)","v":0}]
["WNIP",null,null,{"$f":"SUM($C$4:D5)/$B$16","v":0},{"$f":"SUM($C$4:E5)/$B$16","v":0},{"$f":"SUM($C$4:F5)/$B$16","v":0},{"$f":"SUM($C$4:G5)/$B$16","v":0},{"$f":"SUM($C$4:H5)/$B$16","v":0},0]
["Wyliczenie dotacji",null,null,{"$f":"SUM($C$4:D6)/$B$15","v":0},null,null,null,null,0]
["Intensywność ",0.5,null,{"$f":"SUM($C$4:D7)/$B$15","v":0},null,null,null,null,0]
["Inwestycyjna",0.5,0,{"$f":"SUM($C$4:D8)/$B$15","v":0},{"$f":"C24*D9","v":0},{"$f":"D24*E9","v":0},{"$f":"E24*F9","v":0},{"$f":"F24*G9","v":0},0]
["Stworzone miejsca pracy",null,null,{"$f":"SUM($C$4:D9)/$B$15","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Łącznie należna dotacja",null,{"$f":"C24+C25","v":0},{"$f":"SUM($C$4:D10)/$B$15","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"SUM($C$4:D11)/$B$15","v":0},null,null,null,null,0]
[null,null,null,{"$f":"SUM($C$4:D12)/$B$15","v":0},null,null,null,null,0]
["Rozliczenie w P&L",null,null,{"$f":"SUM($C$4:D13)/$B$15","v":0},{"$f":"E26/60*12+D29","v":{"$error":"#REF!"}},{"$f":"F26/60*12+E29","v":{"$error":"#REF!"}},{"$f":"G26/60*12+F29","v":{"$error":"#REF!"}},{"$f":"H26/60*12+G29","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,{"$f":"SUM($C$4:D14)/$B$15","v":0},null,null,null,null,0]