{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Model","AnalizaWrażliwości","AnalizaScenariuszowa"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Model","index":0,"n_rows":100,"n_cols":16,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Okres 0","Okres 1","Okres 2","Okres 3","Okres 4"]
[]
[null,null,"Nakład inwestycyjny - maszyny",4000,null,null,null,"Mierniki opłacalności (kopia):"]
[null,null,"Nakład inwestycyjny - surowce",500,null,null,"NPV",{"$f":"D98","v":1721.0195671239521}]
[null,null,null,null,null,null,"PI",{"$f":"D99","v":1.3824487926942117}]
[null,null,"Finansowanie przez kapitał własny",0.4,null,null,"IRR",{"$f":"D100","v":0.35001410402543764}]
[null,null,"Finansowanie przez kapitał obcy",{"$f":"1-D6","v":0.6}]
[]
[null,null,"Popyt na Produkt A",null,10000,{"$f":"E9*(1.1)","v":11000},{"$f":"F9*(1.1)","v":12100.000000000002},{"$f":"G9*(1.1)","v":13310.000000000004}]
[null,null,"Popyt na Produkt B",null,15000,{"$f":"E10*(1.08)","v":16200.000000000002},{"$f":"F10*(1.08)","v":17496.000000000004},18895.680000000004]
[null,null,"Cena jednostkowa Produkt A",null,1,{"$f":"E11*1.03","v":1.03},{"$f":"F11*1.03","v":1.0609},1.092727]
[null,null,"Cena jednostkowa Produkt B",null,0.8,{"$f":"E12*0.98","v":0.78400000000000003},{"$f":"F12*0.98","v":0.76832},0.7529536]
[null,null,"Koszt jednostkowy Produkt A",null,0.9,{"$f":"E13*1.05","v":0.94500000000000006},{"$f":"F13*1.05","v":0.99225000000000008},1.0418625000000001]
[null,null,"Koszt jednostkowy Produkt B",null,0.65,{"$f":"E14*1.01","v":0.65650000000000008},{"$f":"F14*1.01","v":0.66306500000000013},0.66969565000000009]
[null,null,"Koszty stałe (bez amortyzacji)",null,500,{"$f":"E15","v":500},{"$f":"F15","v":500},{"$f":"G15","v":500}]
[]
[null,null,"Amortyzacja (stawka 20% rocznie)",null,{"$f":"$D$3*20%","v":800},{"$f":"$D$3*20%","v":800},800,800]
[]
[null,null,"Stopa podatku",null,0.19,{"$f":"E19","v":0.19},0.19,0.19]
[null,null,"Stopa dyskontowa",null,0.15,0.15,0.15,0.15]
[]
[null,null,"Liczba dni w okresie",null,365,{"$f":"E22","v":365},{"$f":"F22","v":365},{"$f":"G22","v":365}]
[null,null,"OUZ",null,14,{"$f":"E23","v":14},{"$f":"F23","v":14},14]
[null,null,"OSN",null,14,{"$f":"E24","v":14},14,14]
[null,null,"ORZ",null,28,{"$f":"E25","v":28},28,28]
[]
[]
[null,null,"Spłata kredytu","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4"]
[null,null,"Stan kredytu na początek okresu",0,{"$f":"D32","v":2700},{"$f":"E32","v":1800},900,0]
[null,null,"Zaciągnięcie w okresie",{"$f":"(D3+D4)*D7","v":2700}]
[null,null,"Spłata kapitału w okresie",null,{"$f":"$D$30/3","v":900},{"$f":"$D$30/3","v":900},900]
[null,null,"Stan kredytu na koniec okresu",{"$f":"D29+D30-D31","v":2700},{"$f":"E29+E30-E31","v":1800},900,0,0]
[null,null,"Odsetki w okresie (10%)",null,{"$f":"E29*10%","v":270},{"$f":"F29*10%","v":180},90,0]
[]
[]
[null,null,"Rachunek zysków i strat","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4"]
[null,null,"Przychody ze sprzedaży",null,{"$f":"E9*E11+E10*E12","v":22000},{"$f":"F9*F11+F10*F12","v":24030.800000000003},26279.416720000005,28771.766650448008]
[null,null,"- Koszty zmienne",null,{"$f":"E9*E13+E10*E14","v":18750},{"$f":"F9*F13+F10*F14","v":21030.300000000003},23607.210240000008,26521.544574792009]
[null,null,"= Marża na sprzedaży",null,{"$f":"E37-E38","v":3250},{"$f":"F37-F38","v":3000.5},2672.2064799999971,2250.2220756559982]
[null,null,"- Koszty stałe",null,{"$f":"E15+E17","v":1300},{"$f":"F15+F17","v":1300},1300,1300]
[null,null,"= Wynik operacyjny",null,{"$f":"E39-E40","v":1950},{"$f":"F39-F40","v":1700.5},1372.2064799999971,950.2220756559982,null,null,null,null,null,null,null,"`"]
[null,null,"- Odsetki",null,{"$f":"E33","v":270},{"$f":"F33","v":180},90,0]
[null,null,"= Wynik finansowy brutto",null,{"$f":"E41-E42","v":1680},{"$f":"F41-F42","v":1520.5},1282.2064799999971,950.2220756559982]
[null,null,"- Podatek dochodowy",null,{"$f":"IF(E43>0,E43*E19,0)","v":319.2},{"$f":"IF(F43>0,F43*F19,0)","v":288.89499999999998},243.61923119999946,180.54219437463965]
[null,null,"= Wynik finansowy netto",null,{"$f":"E43-E44","v":1360.8},{"$f":"F43-F44","v":1231.605},1038.5872487999977,769.67988128135858]
[]
[null,null,"Zapotrzebowanie na KON","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4"]
[null,null,"Zapasy",{"$f":"D4","v":500},{"$f":"E23/E22*E38","v":719.17808219178085},{"$f":"F23/F22*F38","v":806.64164383561661},905.4820366027401,1017.2647234166799]
[null,null,"Należności",null,{"$f":"E24/E22*E37","v":843.83561643835617},{"$f":"F24/F22*F37","v":921.72931506849329},1007.9776276164386,1103.5746112500606]
[null,null,"Zobowiązania",null,{"$f":"E25/E22*E38","v":1438.3561643835617},{"$f":"F25/F22*F38","v":1613.2832876712332},1810.9640732054802,2034.5294468333598]
[null,null,"Zapotrzebowanie na KON",{"$f":"D48+D49-D50","v":500},{"$f":"E48+E49-E50","v":124.65753424657532},115.0876712328768,102.49559101369846,86.309887833380571]
[null,null,"zmiana Zapotrzebowania na KON",{"$f":"D51","v":500},{"$f":"E51-D51","v":-375.34246575342468},{"$f":"F51-E51","v":-9.569863013698523},-12.592080219178342,-16.185703180317887]
[]
[null,null,"Przepływy pieniężne"]
[null,null,"Przepływy operacyjne",{"$f":"SUM(D56:D59)","v":-500},{"$f":"SUM(E56:E59)","v":2806.1424657534249},2221.1748630136985,1941.1793290191761,1585.8655844616765]
[null,null,"Wynik finansowy netto",{"$f":"D45","v":0},{"$f":"E45","v":1360.8},1231.605,1038.5872487999977,769.67988128135858]
[null,null,"+ Amortyzacja",{"$f":"D17","v":0},{"$f":"E17","v":800},800,800,800]
[null,null,"+ Odsetki",{"$f":"D33","v":0},{"$f":"E33","v":270},180,90,0]
[null,null,"- zmiana Zap. na KON",{"$f":"-D52","v":-500},{"$f":"-E52","v":375.34246575342468},9.569863013698523,12.592080219178342,16.185703180317887]
[null,null,"Przepływy inwestycyjne",{"$f":"D61","v":-4000},{"$f":"E61","v":0},0,0,0]
[null,null,"- Nakład na maszyny",{"$f":"-D3","v":-4000}]
[null,null,"Przepływy finansowe",{"$f":"SUM(D63:D66)","v":4500},{"$f":"SUM(E63:E66)","v":-1170},-1080,-990,0]
[null,null,"+ Wpłata kapitału własnego",{"$f":"(D3+D4)*D6","v":1800}]
[null,null,"+ Zaciągnięcie kredytu",{"$f":"D30","v":2700},{"$f":"E30","v":0},0,0,0]
[null,null,"- Spłata kredytu",{"$f":"-D31","v":0},{"$f":"-E31","v":-900},-900,-900,0]
[null,null,"- Odsetki",{"$f":"-D33","v":0},{"$f":"-E33","v":-270},-180,-90,0]
[null,null,"Zmiana środków pieniężnych",{"$f":"D55+D60+D62","v":0},{"$f":"E55+E60+E62","v":1636.1424657534249},1141.1748630136985,951.17932901917607,1585.8655844616765]
[null,null,"Środki pieniężne na początek",0,{"$f":"D69","v":0},{"$f":"E69","v":1636.1424657534249},2777.3173287671234,3728.4966577862997]
[null,null,"Środki pieniężne na koniec",{"$f":"D68+D67","v":0},{"$f":"E68+E67","v":1636.1424657534249},2777.3173287671234,3728.4966577862997,5314.3622422479766]
[]
[null,null,"Bilans"]
[null,null,"Aktywa ogółem",{"$f":"D73+D74","v":4500},{"$f":"E73+E74","v":6399.1561643835621},6905.6882876712334,7241.9563220054788,8235.2015769147165]
[null,null,"Aktywa trwałe",{"$f":"D3","v":4000},{"$f":"D73-E17","v":3200},{"$f":"E73-F17","v":2400},1600,800]
[null,null,"Aktywa obrotowe",{"$f":"SUM(D75:D77)","v":500},{"$f":"SUM(E75:E77)","v":3199.1561643835621},4505.6882876712334,5641.9563220054788,7435.2015769147165]
[null,null,"Zapasy",{"$f":"D48","v":500},{"$f":"E48","v":719.17808219178085},806.64164383561661,905.4820366027401,1017.2647234166799]
[null,null,"Należności",{"$f":"D49","v":0},843.83561643835617,921.72931506849329,1007.9776276164386,1103.5746112500606]
[null,null,"Środki pieniężne",{"$f":"D69","v":0},{"$f":"E69","v":1636.1424657534249},2777.3173287671234,3728.4966577862997,5314.3622422479766]
[null,null,"Pasywa ogółem",{"$f":"D79+D83+D84","v":4500},{"$f":"E79+E83+E84","v":6399.1561643835621},6905.6882876712334,7241.9563220054779,8235.2015769147165]
[null,null,"Kapitały własne",{"$f":"SUM(D80:D82)","v":1800},{"$f":"SUM(E80:E82)","v":3160.8},4392.4050000000007,5430.9922487999975,6200.672130081356]
[null,null,"Kapitał podstawowy",{"$f":"D63","v":1800},{"$f":"D80+E63","v":1800},{"$f":"E80+F63","v":1800},1800,1800]
[null,null,"Nie podzielony wynik",0,{"$f":"D81+D82","v":0},{"$f":"E81+E82","v":1360.8},2592.4049999999997,3630.9922487999975]
[null,null,"Wynik finansowy netto",{"$f":"D45","v":0},{"$f":"E45","v":1360.8},1231.605,1038.5872487999977,769.67988128135858]
[null,null,"Zobowiązania długookresowe",{"$f":"D32","v":2700},{"$f":"E32","v":1800},900,0,0]
[null,null,"Zobowiązania krótkookresowe",{"$f":"D50","v":0},{"$f":"E50","v":1438.3561643835617},1613.2832876712332,1810.9640732054802,2034.5294468333598]
[null,null,"suma kontrolna",{"$f":"D72-D78","v":0},{"$f":"E72-E78","v":0},0,0,0]
[]
[]
[null,null,"Przepływy do oceny opłacalności inw."]
[null,null,"Przepływy operacyjne",{"$f":"D55","v":-500},{"$f":"E55","v":2806.1424657534249},2221.1748630136985,1941.1793290191761,1585.8655844616765]
[null,null,"- tarcza na odsetkach",{"$f":"-D33*D19","v":0},{"$f":"-E33*E19","v":-51.3},-34.200000000000003,-17.100000000000001,0]
[null,null,"Przepływy inwestycyjne",{"$f":"D60","v":-4000},{"$f":"E60","v":0},0,0,0]
[null,null,"Przepływy NCF",{"$f":"SUM(D89:D91)","v":-4500},{"$f":"SUM(E89:E91)","v":2754.8424657534247},2186.9748630136987,1924.0793290191762,1585.8655844616765]
[null,null,"współczynnik dyskonta",1,{"$f":"D93/(1+E20)","v":0.86956521739130443},{"$f":"E93/(1+F20)","v":0.7561436672967865},0.65751623243198831,0.57175324559303331]
[null,null,"Zdyskontowane przeływy NCF",{"$f":"D92*D93","v":-4500},{"$f":"E92*E93","v":2395.5151876116738},1653.6671932050654,1265.1133913169567,906.72379499025624]
[]
[]
[null,null,"Mierniki opłacalności inwestycji"]
[null,null,"NPV",{"$f":"SUM(D94:H94)","v":1721.0195671239521}]
[null,null,"PI",{"$f":"SUM(E94:H94)/-D94","v":1.3824487926942117}]
[null,null,"IRR",{"$f":"IRR(D92:H92)","v":0.35001410402543764}]

{"sheet":"AnalizaWrażliwości","index":1,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,4,9,8]]}
[]
[null,"Analiza wrażliwości"]
[]
[]
[null,null,"nazwa arkusza z planem finansowym:","Model"]
[]
[null,null,"liczba zmiennych do analizy:",{"$f":"COUNTA(D12:D29)","v":14}]
[]
[null,null,"podaj adres komórki z NPV:","D98"]
[null,null,null,null,"Informacje generowane przez makro \"Analiza wrażliwości\""]
[null,"Nr","nazwa zmiennej","adres parametru","wartość pierwotna","NPV przy w. pierwotnej","wartość graniczna","NPV przy w. granicznej","% zmiana","|% zmiana|"]
[null,{"$f":"IF(C12<>\"\",ROWS($12:12),\"\")","v":1},"Cena maszyn","D3",4000,1721.0195671239521,5930.4528046494461,0,0.48261320116236162,0.48261320116236162]
[null,{"$f":"IF(C13<>\"\",ROWS($12:13),\"\")","v":2},"Wartość zapasów pierwotnych","D4",500,1721.0195671239521,13694.483347950307,0,26.388966695900614,26.388966695900614]
[null,{"$f":"IF(C14<>\"\",ROWS($12:14),\"\")","v":3},"Popyt na Produkt A","E9",10000,1721.0195671239521,1426.982288326644,0,-0.85730177116733564,0.85730177116733564]
[null,{"$f":"IF(C15<>\"\",ROWS($12:15),\"\")","v":4},"Popyt na Produkt B","E10",15000,1721.0195671239521,9264.6223080525251,9.0949470177292824E-13,-0.38235851279649835,0.38235851279649835]
[null,{"$f":"IF(C16<>\"\",ROWS($12:16),\"\")","v":5},"Cena jednostkowa Produkt A","E11",1,1721.0195671239521,0.93651194693022533,-4.5474735088646412E-13,-6.3488053069774675E-2,6.3488053069774675E-2]
[null,{"$f":"IF(C17<>\"\",ROWS($12:17),\"\")","v":6},"Cena jednostkowa Produkt B","E12",0.8,1721.0195671239521,0.75336469420198582,8.9812601800076663E-12,-5.8294132247517783E-2,5.8294132247517783E-2]
[null,{"$f":"IF(C18<>\"\",ROWS($12:18),\"\")","v":7},"Koszt jednostkowy Produkt A","E13",0.9,1721.0195671239521,0.96170698541741095,6.2527760746888816E-13,6.8563317130456491E-2,6.8563317130456491E-2]
[null,{"$f":"IF(C19<>\"\",ROWS($12:19),\"\")","v":8},"Koszt jednostkowy Produkt B","E14",0.65,1721.0195671239521,0.69470721986648698,5.2864379540551454E-12,6.8780338256133833E-2,6.8780338256133833E-2]
[null,{"$f":"IF(C20<>\"\",ROWS($12:20),\"\")","v":9},"Koszty stałe (bez amortyzacji)","E15",500,1721.0195671239521,1244.2142268807618,0,1.4884284537615233,1.4884284537615233]
[null,{"$f":"IF(C21<>\"\",ROWS($12:21),\"\")","v":10},"Stopa podatku","E19",0.19,1721.0195671239521,0.57875394359495946,0,2.0460733873418917,2.0460733873418917]
[null,{"$f":"IF(C22<>\"\",ROWS($12:22),\"\")","v":11},"Stopa dyskontowa","E20",0.15,1721.0195671239521,0.35001396808989477,8.7564419163754792E-4,1.3334264539326317,1.3334264539326317]
[null,{"$f":"IF(C23<>\"\",ROWS($12:23),\"\")","v":12},"OUZ","E23",14,1721.0195671239521,43.368628867721242,-1.7053025658242404E-12,2.0977592048372316,2.0977592048372316]
[null,{"$f":"IF(C24<>\"\",ROWS($12:24),\"\")","v":13},"OSN","E24",14,1721.0195671239521,40.651882406807651,-9.0949470177292824E-13,1.9037058862005467,1.9037058862005467]
[null,{"$f":"IF(C25<>\"\",ROWS($12:25),\"\")","v":14},"ORZ","E25",28,1721.0195671239521,-1.3686288677212239,0,-1.0488796024186151,1.0488796024186151]
[null,{"$f":"IF(C26<>\"\",ROWS($12:26),\"\")","v":""}]
[null,{"$f":"IF(C27<>\"\",ROWS($12:27),\"\")","v":""}]
[null,{"$f":"IF(C28<>\"\",ROWS($12:28),\"\")","v":""}]
[null,{"$f":"IF(C29<>\"\",ROWS($12:29),\"\")","v":""}]

{"sheet":"AnalizaScenariuszowa","index":2,"n_rows":117,"n_cols":21,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[null,null,"Scenariusz pesymistyczny",null,null,null,null,null,null,"Scenariusz typowy",null,null,null,null,null,null,"Scenariusz optymistyczny"]
[]
[null,null,"Okres 0","Okres 1","Okres 2","Okres 3","Okres 4",null,null,"Okres 0","Okres 1","Okres 2","Okres 3","Okres 4",null,null,"Okres 0","Okres 1","Okres 2","Okres 3","Okres 4"]
[]
[null,"Nakład inwestycyjny - maszyny",4500,null,null,null,"Mierniki opłacalności (kopia):",null,"Nakład inwestycyjny - maszyny",4000,null,null,null,"Mierniki opłacalności (kopia):",null,"Nakład inwestycyjny - maszyny",3900,null,null,null,"Mierniki opłacalności (kopia):"]
[null,"Nakład inwestycyjny - surowce",600,null,null,"NPV",{"$f":"C100","v":-3180.1833394952328},null,"Nakład inwestycyjny - surowce",500,null,null,"NPV",{"$f":"J100","v":1775.2641560155009},null,"Nakład inwestycyjny - surowce",450,null,null,"NPV",{"$f":"Q100","v":2463.8229569806899}]
[null,null,null,null,null,"PI",{"$f":"C101","v":0.37643463931466037},null,null,null,null,null,"PI",{"$f":"J101","v":1.3945031457812225},null,null,null,null,null,"PI",{"$f":"Q101","v":1.5663960820645262}]
[null,"Finansowanie przez kapitał własny",0.4,null,null,"IRR",{"$f":"C102","v":-0.28313916194391475},null,"Finansowanie przez kapitał własny",0.4,null,null,"IRR",{"$f":"J102","v":0.35589398182047693},null,"Finansowanie przez kapitał własny",0.4,null,null,"IRR",{"$f":"Q102","v":0.43830390911086181}]
[null,"Finansowanie przez kapitał obcy",{"$f":"1-C8","v":0.6},null,null,null,null,null,"Finansowanie przez kapitał obcy",{"$f":"1-J8","v":0.6},null,null,null,null,null,"Finansowanie przez kapitał obcy",{"$f":"1-Q8","v":0.6}]
[]
[null,"Popyt na Produkt A",null,9000,{"$f":"D11*(1.1)","v":9900},{"$f":"E11*(1.1)","v":10890},{"$f":"F11*(1.1)","v":11979.000000000002},null,"Popyt na Produkt A",null,10000,{"$f":"K11*(1.1)","v":11000},{"$f":"L11*(1.1)","v":12100.000000000002},{"$f":"M11*(1.1)","v":13310.000000000004},null,"Popyt na Produkt A",null,11000,{"$f":"R11*(1.1)","v":12100.000000000002},{"$f":"S11*(1.1)","v":13310.000000000004},{"$f":"T11*(1.1)","v":14641.000000000005}]
[null,"Popyt na Produkt B",null,14000,{"$f":"D12*(1.08)","v":15120.000000000002},{"$f":"E12*(1.08)","v":16329.600000000002},17635.968000000004,null,"Popyt na Produkt B",null,15000,{"$f":"K12*(1.08)","v":16200.000000000002},{"$f":"L12*(1.08)","v":17496.000000000004},{"$f":"M12*(1.08)","v":18895.680000000004},null,"Popyt na Produkt B",null,15500,{"$f":"R12*(1.08)","v":16740},{"$f":"S12*(1.08)","v":18079.2},{"$f":"T12*(1.08)","v":19525.536000000004}]
[null,"Cena jednostkowa Produkt A",null,0.97,{"$f":"D13*1.03","v":0.99909999999999999},{"$f":"E13*1.03","v":1.0290729999999999},1.0599451899999999,null,"Cena jednostkowa Produkt A",null,1,{"$f":"K13*1.03","v":1.03},{"$f":"L13*1.03","v":1.0609},{"$f":"M13*1.03","v":1.092727},null,"Cena jednostkowa Produkt A",null,1,{"$f":"R13*1.03","v":1.03},{"$f":"S13*1.03","v":1.0609},{"$f":"T13*1.03","v":1.092727}]
[null,"Cena jednostkowa Produkt B",null,0.78,{"$f":"D14*0.98","v":0.76439999999999997},{"$f":"E14*0.98","v":0.749112},0.73412975999999996,null,"Cena jednostkowa Produkt B",null,0.8,{"$f":"K14*0.98","v":0.78400000000000003},{"$f":"L14*0.98","v":0.76832},{"$f":"M14*0.98","v":0.7529536},null,"Cena jednostkowa Produkt B",null,0.8,{"$f":"R14*0.98","v":0.78400000000000003},{"$f":"S14*0.98","v":0.76832},{"$f":"T14*0.98","v":0.7529536}]
[null,"Koszt jednostkowy Produkt A",null,0.92,{"$f":"D15*1.05","v":0.96600000000000008},{"$f":"E15*1.05","v":1.0143000000000002},1.0650150000000003,null,"Koszt jednostkowy Produkt A",null,0.9,{"$f":"K15*1.05","v":0.94500000000000006},{"$f":"L15*1.05","v":0.99225000000000008},{"$f":"M15*1.05","v":1.0418625000000001},null,"Koszt jednostkowy Produkt A",null,0.9,{"$f":"R15*1.05","v":0.94500000000000006},{"$f":"S15*1.05","v":0.99225000000000008},{"$f":"T15*1.05","v":1.0418625000000001}]
[null,"Koszt jednostkowy Produkt B",null,0.67,{"$f":"D16*1.01","v":0.67670000000000008},{"$f":"E16*1.01","v":0.68346700000000005},0.69030167000000009,null,"Koszt jednostkowy Produkt B",null,0.65,{"$f":"K16*1.01","v":0.65650000000000008},{"$f":"L16*1.01","v":0.66306500000000013},{"$f":"M16*1.01","v":0.66969565000000009},null,"Koszt jednostkowy Produkt B",null,0.65,{"$f":"R16*1.01","v":0.65650000000000008},{"$f":"S16*1.01","v":0.66306500000000013},{"$f":"T16*1.01","v":0.66969565000000009}]
[null,"Koszty stałe (bez amortyzacji)",null,500,{"$f":"D17","v":500},{"$f":"E17","v":500},{"$f":"F17","v":500},null,"Koszty stałe (bez amortyzacji)",null,500,{"$f":"K17","v":500},{"$f":"L17","v":500},{"$f":"M17","v":500},null,"Koszty stałe (bez amortyzacji)",null,400,{"$f":"R17","v":400},{"$f":"S17","v":400},{"$f":"T17","v":400}]
[]
[null,"Amortyzacja (stawka 20% rocznie)",null,{"$f":"$C$5*20%","v":900},{"$f":"$C$5*20%","v":900},900,900,null,"Amortyzacja (stawka 20% rocznie)",null,{"$f":"$C$5*20%","v":900},{"$f":"$C$5*20%","v":900},900,900,null,"Amortyzacja (stawka 20% rocznie)",null,{"$f":"$C$5*20%","v":900},{"$f":"$C$5*20%","v":900},900,900]
[]
[null,"Stopa podatku",null,0.19,{"$f":"D21","v":0.19},0.19,0.19,null,"Stopa podatku",null,0.19,{"$f":"K21","v":0.19},{"$f":"L21","v":0.19},{"$f":"M21","v":0.19},null,"Stopa podatku",null,0.19,{"$f":"R21","v":0.19},{"$f":"S21","v":0.19},{"$f":"T21","v":0.19}]
[null,"Stopa dyskontowa",null,0.15,0.15,0.15,0.15,null,"Stopa dyskontowa",null,0.15,0.15,0.15,0.15,null,"Stopa dyskontowa",null,0.15,0.15,0.15,0.15]
[]
[null,"Liczba dni w okresie",null,365,{"$f":"D24","v":365},{"$f":"E24","v":365},{"$f":"F24","v":365},null,"Liczba dni w okresie",null,365,{"$f":"K24","v":365},{"$f":"L24","v":365},{"$f":"M24","v":365},null,"Liczba dni w okresie",null,365,{"$f":"R24","v":365},{"$f":"S24","v":365},{"$f":"T24","v":365}]
[null,"OUZ",null,21,{"$f":"D25","v":21},{"$f":"E25","v":21},21,null,"OUZ",null,14,{"$f":"K25","v":14},{"$f":"L25","v":14},{"$f":"M25","v":14},null,"OUZ",null,14,{"$f":"R25","v":14},{"$f":"S25","v":14},{"$f":"T25","v":14}]
[null,"OSN",null,28,{"$f":"D26","v":28},28,28,null,"OSN",null,14,{"$f":"K26","v":14},14,14,null,"OSN",null,14,{"$f":"R26","v":14},14,14]
[null,"ORZ",null,28,{"$f":"D27","v":28},28,28,null,"ORZ",null,28,{"$f":"K27","v":28},28,28,null,"ORZ",null,28,{"$f":"R27","v":28},28,28]
[]
[]
[null,"Spłata kredytu","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4",null,"Spłata kredytu","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4",null,"Spłata kredytu","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4"]
[null,"Stan kredytu na początek okresu",0,{"$f":"C34","v":3060},{"$f":"D34","v":2040},1020,0,null,"Stan kredytu na początek okresu",0,{"$f":"J34","v":2700},{"$f":"K34","v":1680},{"$f":"L34","v":660},{"$f":"M34","v":-360},null,"Stan kredytu na początek okresu",0,{"$f":"Q34","v":2610},{"$f":"R34","v":1590},{"$f":"S34","v":570},{"$f":"T34","v":-450}]
[null,"Zaciągnięcie w okresie",{"$f":"(C5+C6)*C9","v":3060},null,null,null,null,null,"Zaciągnięcie w okresie",{"$f":"(J5+J6)*J9","v":2700},null,null,null,null,null,"Zaciągnięcie w okresie",{"$f":"(Q5+Q6)*Q9","v":2610}]
[null,"Spłata kapitału w okresie",null,{"$f":"$C$32/3","v":1020},{"$f":"$C$32/3","v":1020},1020,null,null,"Spłata kapitału w okresie",null,{"$f":"$C$32/3","v":1020},{"$f":"$C$32/3","v":1020},1020,null,null,"Spłata kapitału w okresie",null,{"$f":"$C$32/3","v":1020},{"$f":"$C$32/3","v":1020},1020]
[null,"Stan kredytu na koniec okresu",{"$f":"C31+C32-C33","v":3060},{"$f":"D31+D32-D33","v":2040},1020,0,0,null,"Stan kredytu na koniec okresu",{"$f":"J31+J32-J33","v":2700},{"$f":"K31+K32-K33","v":1680},660,-360,-360,null,"Stan kredytu na koniec okresu",{"$f":"Q31+Q32-Q33","v":2610},{"$f":"R31+R32-R33","v":1590},570,-450,-450]
[null,"Odsetki w okresie (10%)",null,{"$f":"D31*10%","v":306},{"$f":"E31*10%","v":204},102,0,null,"Odsetki w okresie (10%)",null,{"$f":"K31*10%","v":270},{"$f":"L31*10%","v":168},66,-36,null,"Odsetki w okresie (10%)",null,{"$f":"R31*10%","v":261},{"$f":"S31*10%","v":159},57,-45]
[]
[]
[null,"Rachunek zysków i strat","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4",null,"Rachunek zysków i strat","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4",null,"Rachunek zysków i strat","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4"]
[null,"Przychody ze sprzedaży",null,{"$f":"D11*D13+D12*D14","v":19650},{"$f":"E11*E13+E12*E14","v":21448.817999999999},23439.3042852,25644.17238621768,null,"Przychody ze sprzedaży",null,{"$f":"K11*K13+K12*K14","v":22000},{"$f":"L11*L13+L12*L14","v":24030.800000000003},26279.416720000005,28771.766650448008,null,"Przychody ze sprzedaży",null,{"$f":"R11*R13+R12*R14","v":23400},{"$f":"S11*S13+S12*S14","v":25587.160000000003},28011.189944000005,30700.438630129611]
[null,"- Koszty zmienne",null,{"$f":"D11*D15+D12*D16","v":17660},{"$f":"E11*E15+E12*E16","v":19795.104000000003},22206.469723200004,24931.952847466571,null,"- Koszty zmienne",null,{"$f":"K11*K15+K12*K16","v":18750},{"$f":"L11*L15+L12*L16","v":21030.300000000003},23607.210240000008,26521.544574792009,null,"- Koszty zmienne",null,{"$f":"R11*R15+R12*R16","v":19975},{"$f":"S11*S15+S12*S16","v":22424.310000000005},25194.53224800001,28330.075385618409]
[null,"= Marża na sprzedaży",null,{"$f":"D39-D40","v":1990},{"$f":"E39-E40","v":1653.7139999999963},1232.8345619999964,712.21953875110921,null,"= Marża na sprzedaży",null,{"$f":"K39-K40","v":3250},{"$f":"L39-L40","v":3000.5},2672.2064799999971,2250.2220756559982,null,"= Marża na sprzedaży",null,{"$f":"R39-R40","v":3425},{"$f":"S39-S40","v":3162.8499999999985},2816.6576959999948,2370.3632445112016]
[null,"- Koszty stałe",null,{"$f":"D17+D19","v":1400},{"$f":"E17+E19","v":1400},1400,1400,null,"- Koszty stałe",null,{"$f":"K17+K19","v":1400},{"$f":"L17+L19","v":1400},1400,1400,null,"- Koszty stałe",null,{"$f":"R17+R19","v":1300},{"$f":"S17+S19","v":1300},1300,1300]
[null,"= Wynik operacyjny",null,{"$f":"D41-D42","v":590},{"$f":"E41-E42","v":253.7139999999963},-167.16543800000363,-687.78046124889079,null,"= Wynik operacyjny",null,{"$f":"K41-K42","v":1850},{"$f":"L41-L42","v":1600.5},1272.2064799999971,850.2220756559982,"`","= Wynik operacyjny",null,{"$f":"R41-R42","v":2125},{"$f":"S41-S42","v":1862.8499999999985},1516.6576959999948,1070.3632445112016]
[null,"- Odsetki",null,{"$f":"D35","v":306},{"$f":"E35","v":204},102,0,null,"- Odsetki",null,{"$f":"K35","v":270},{"$f":"L35","v":168},66,-36,null,"- Odsetki",null,{"$f":"R35","v":261},{"$f":"S35","v":159},57,-45]
[null,"= Wynik finansowy brutto",null,{"$f":"D43-D44","v":284},{"$f":"E43-E44","v":49.713999999996304},-269.16543800000363,-687.78046124889079,null,"= Wynik finansowy brutto",null,{"$f":"K43-K44","v":1580},{"$f":"L43-L44","v":1432.5},1206.2064799999971,886.2220756559982,null,"= Wynik finansowy brutto",null,{"$f":"R43-R44","v":1864},{"$f":"S43-S44","v":1703.8499999999985},1459.6576959999948,1115.3632445112016]
[null,"- Podatek dochodowy",null,{"$f":"IF(D45>0,D45*D21,0)","v":53.96},{"$f":"IF(E45>0,E45*E21,0)","v":9.4456599999992985},0,0,null,"- Podatek dochodowy",null,{"$f":"IF(K45>0,K45*K21,0)","v":300.2},{"$f":"IF(L45>0,L45*L21,0)","v":272.17500000000001},229.17923119999946,168.38219437463965,null,"- Podatek dochodowy",null,{"$f":"IF(R45>0,R45*R21,0)","v":354.16},{"$f":"IF(S45>0,S45*S21,0)","v":323.73149999999976},277.33496223999902,211.91901645712832]
[null,"= Wynik finansowy netto",null,{"$f":"D45-D46","v":230.04},{"$f":"E45-E46","v":40.268339999997004},-269.16543800000363,-687.78046124889079,null,"= Wynik finansowy netto",null,{"$f":"K45-K46","v":1279.8},{"$f":"L45-L46","v":1160.325},977.02724879999766,717.83988128135854,null,"= Wynik finansowy netto",null,{"$f":"R45-R46","v":1509.84},{"$f":"S45-S46","v":1380.1184999999987},1182.3227337599958,903.44422805407328]
[]
[null,"Zapotrzebowanie na KON","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4",null,"Zapotrzebowanie na KON","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4",null,"Zapotrzebowanie na KON","Okres 0","Okres 1","Okres 2","Okres 3","Okres 4"]
[null,"Zapasy",{"$f":"C6","v":600},{"$f":"D25/D24*D40","v":1016.0547945205479},{"$f":"E25/E24*E40","v":1138.896394520548},1277.6325046224661,1434.4411227309533,null,"Zapasy",{"$f":"J6","v":500},{"$f":"K25/K24*K40","v":719.17808219178085},{"$f":"L25/L24*L40","v":806.64164383561661},905.4820366027401,1017.2647234166799,null,"Zapasy",{"$f":"Q6","v":450},{"$f":"R25/R24*R40","v":766.16438356164383},{"$f":"S25/S24*S40","v":860.11052054794538},966.36562047123334,1086.6330284894732]
[null,"Należności",null,{"$f":"D26/D24*D39","v":1507.3972602739727},{"$f":"E26/E24*E39","v":1645.3887780821917},1798.0836163989043,1967.2241830523153,null,"Należności",null,{"$f":"K26/K24*K39","v":843.83561643835617},{"$f":"L26/L24*L39","v":921.72931506849329},1007.9776276164386,1103.5746112500606,null,"Należności",null,{"$f":"R26/R24*R39","v":897.53424657534254},{"$f":"S26/S24*S39","v":981.42531506849332},1074.4018060712331,1177.5510707446974]
[null,"Zobowiązania",null,{"$f":"D27/D24*D40","v":1354.7397260273974},{"$f":"E27/E24*E40","v":1518.5285260273977},1703.5100061632879,1912.5881636412714,null,"Zobowiązania",null,{"$f":"K27/K24*K40","v":1438.3561643835617},{"$f":"L27/L24*L40","v":1613.2832876712332},1810.9640732054802,2034.5294468333598,null,"Zobowiązania",null,{"$f":"R27/R24*R40","v":1532.3287671232877},{"$f":"S27/S24*S40","v":1720.2210410958908},1932.7312409424667,2173.2660569789464]
[null,"Zapotrzebowanie na KON",{"$f":"C50+C51-C52","v":600},{"$f":"D50+D51-D52","v":1168.7123287671234},1265.7566465753421,1372.2061148580824,1489.0771421419972,null,"Zapotrzebowanie na KON",{"$f":"J50+J51-J52","v":500},{"$f":"K50+K51-K52","v":124.65753424657532},115.0876712328768,102.49559101369846,86.309887833380571,null,"Zapotrzebowanie na KON",{"$f":"Q50+Q51-Q52","v":450},{"$f":"R50+R51-R52","v":131.3698630136987},121.31479452054805,108.03618559999973,90.918042255224009]
[null,"zmiana Zapotrzebowania na KON",{"$f":"C53","v":600},{"$f":"D53-C53","v":568.71232876712338},{"$f":"E53-D53","v":97.044317808218693},106.44946828274033,116.87102728391483,null,"zmiana Zapotrzebowania na KON",{"$f":"J53","v":500},{"$f":"K53-J53","v":-375.34246575342468},{"$f":"L53-K53","v":-9.569863013698523},{"$f":"M53-L53","v":-12.592080219178342},{"$f":"N53-M53","v":-16.185703180317887},null,"zmiana Zapotrzebowania na KON",{"$f":"Q53","v":450},{"$f":"R53-Q53","v":-318.6301369863013},{"$f":"S53-R53","v":-10.055068493150657},{"$f":"T53-S53","v":-13.278608920548322},{"$f":"U53-T53","v":-17.118143344775717}]
[]
[null,"Przepływy pieniężne",null,null,null,null,null,null,"Przepływy pieniężne",null,null,null,null,null,null,"Przepływy pieniężne"]
[null,"Przepływy operacyjne",{"$f":"SUM(C58:C61)","v":-600},{"$f":"SUM(D58:D61)","v":867.32767123287658},1047.2240221917782,626.38509371725604,95.348511467194385,null,"Przepływy operacyjne",{"$f":"SUM(J58:J61)","v":-500},{"$f":"SUM(K58:K61)","v":2825.1424657534249},2237.8948630136983,1955.6193290191761,1598.0255844616763,null,"Przepływy operacyjne",{"$f":"SUM(Q58:Q61)","v":-450},{"$f":"SUM(R58:R61)","v":2989.4701369863014},2449.1735684931491,2152.6013426805439,1775.5623713988491]
[null,"Wynik finansowy netto",{"$f":"C47","v":0},{"$f":"D47","v":230.04},40.268339999997004,-269.16543800000363,-687.78046124889079,null,"Wynik finansowy netto",{"$f":"J47","v":0},{"$f":"K47","v":1279.8},1160.325,977.02724879999766,717.83988128135854,null,"Wynik finansowy netto",{"$f":"Q47","v":0},{"$f":"R47","v":1509.84},1380.1184999999987,1182.3227337599958,903.44422805407328]
[null,"+ Amortyzacja",{"$f":"C19","v":0},{"$f":"D19","v":900},900,900,900,null,"+ Amortyzacja",{"$f":"J19","v":0},{"$f":"K19","v":900},900,900,900,null,"+ Amortyzacja",{"$f":"Q19","v":0},{"$f":"R19","v":900},900,900,900]
[null,"+ Odsetki",{"$f":"C35","v":0},{"$f":"D35","v":306},204,102,0,null,"+ Odsetki",{"$f":"J35","v":0},{"$f":"K35","v":270},168,66,-36,null,"+ Odsetki",{"$f":"Q35","v":0},{"$f":"R35","v":261},159,57,-45]
[null,"- zmiana Zap. na KON",{"$f":"-C54","v":-600},{"$f":"-D54","v":-568.71232876712338},-97.044317808218693,-106.44946828274033,-116.87102728391483,null,"- zmiana Zap. na KON",{"$f":"-J54","v":-500},{"$f":"-K54","v":375.34246575342468},9.569863013698523,12.592080219178342,16.185703180317887,null,"- zmiana Zap. na KON",{"$f":"-Q54","v":-450},{"$f":"-R54","v":318.6301369863013},10.055068493150657,13.278608920548322,17.118143344775717]
[null,"Przepływy inwestycyjne",{"$f":"C63","v":-4500},{"$f":"D63","v":0},0,0,0,null,"Przepływy inwestycyjne",{"$f":"J63","v":-4000},{"$f":"K63","v":0},0,0,0,null,"Przepływy inwestycyjne",{"$f":"Q63","v":-3900},{"$f":"R63","v":0},0,0,0]
[null,"- Nakład na maszyny",{"$f":"-C5","v":-4500},null,null,null,null,null,"- Nakład na maszyny",{"$f":"-J5","v":-4000},null,null,null,null,null,"- Nakład na maszyny",{"$f":"-Q5","v":-3900}]
[null,"Przepływy finansowe",{"$f":"SUM(C65:C68)","v":5100},{"$f":"SUM(D65:D68)","v":-1326},-1224,-1122,0,null,"Przepływy finansowe",{"$f":"SUM(J65:J68)","v":4500},{"$f":"SUM(K65:K68)","v":-1290},-1188,-1086,36,null,"Przepływy finansowe",{"$f":"SUM(Q65:Q68)","v":4350},{"$f":"SUM(R65:R68)","v":-1281},-1179,-1077,45]
[null,"+ Wpłata kapitału własnego",{"$f":"(C5+C6)*C8","v":2040},null,null,null,null,null,"+ Wpłata kapitału własnego",{"$f":"(J5+J6)*J8","v":1800},null,null,null,null,null,"+ Wpłata kapitału własnego",{"$f":"(Q5+Q6)*Q8","v":1740}]
[null,"+ Zaciągnięcie kredytu",{"$f":"C32","v":3060},{"$f":"D32","v":0},0,0,0,null,"+ Zaciągnięcie kredytu",{"$f":"J32","v":2700},{"$f":"K32","v":0},0,0,0,null,"+ Zaciągnięcie kredytu",{"$f":"Q32","v":2610},{"$f":"R32","v":0},0,0,0]
[null,"- Spłata kredytu",{"$f":"-C33","v":0},{"$f":"-D33","v":-1020},-1020,-1020,0,null,"- Spłata kredytu",{"$f":"-J33","v":0},{"$f":"-K33","v":-1020},-1020,-1020,0,null,"- Spłata kredytu",{"$f":"-Q33","v":0},{"$f":"-R33","v":-1020},-1020,-1020,0]
[null,"- Odsetki",{"$f":"-C35","v":0},{"$f":"-D35","v":-306},-204,-102,0,null,"- Odsetki",{"$f":"-J35","v":0},{"$f":"-K35","v":-270},-168,-66,36,null,"- Odsetki",{"$f":"-Q35","v":0},{"$f":"-R35","v":-261},-159,-57,45]
[null,"Zmiana środków pieniężnych",{"$f":"C57+C62+C64","v":0},{"$f":"D57+D62+D64","v":-458.67232876712342},-176.7759778082218,-495.61490628274396,95.348511467194385,null,"Zmiana środków pieniężnych",{"$f":"J57+J62+J64","v":0},{"$f":"K57+K62+K64","v":1535.1424657534249},1049.8948630136983,869.61932901917612,1634.0255844616763,null,"Zmiana środków pieniężnych",{"$f":"Q57+Q62+Q64","v":0},{"$f":"R57+R62+R64","v":1708.4701369863014},1270.1735684931491,1075.6013426805439,1820.5623713988491]
[null,"Środki pieniężne na początek",0,{"$f":"C71","v":0},{"$f":"D71","v":-458.67232876712342},-635.44830657534521,-1131.0632128580892,null,"Środki pieniężne na początek",0,{"$f":"J71","v":0},{"$f":"K71","v":1535.1424657534249},{"$f":"L71","v":2585.0373287671232},{"$f":"M71","v":3454.6566577862995},null,"Środki pieniężne na początek",0,{"$f":"Q71","v":0},{"$f":"R71","v":1708.4701369863014},{"$f":"S71","v":2978.6437054794505},{"$f":"T71","v":4054.2450481599944}]
[null,"Środki pieniężne na koniec",{"$f":"C70+C69","v":0},{"$f":"D70+D69","v":-458.67232876712342},-635.44830657534521,-1131.0632128580892,-1035.7147013908948,null,"Środki pieniężne na koniec",{"$f":"J70+J69","v":0},{"$f":"K70+K69","v":1535.1424657534249},2585.0373287671232,3454.6566577862995,5088.6822422479763,null,"Środki pieniężne na koniec",{"$f":"Q70+Q69","v":0},{"$f":"R70+R69","v":1708.4701369863014},2978.6437054794505,4054.2450481599944,5874.8074195588433]
[]
[null,"Bilans",null,null,null,null,null,null,"Bilans",null,null,null,null,null,null,"Bilans"]
[null,"Aktywa ogółem",{"$f":"C75+C76","v":5100},{"$f":"D75+D76","v":5664.7797260273974},4848.8368660273945,3744.6529081632812,3265.9506043923739,null,"Aktywa ogółem",{"$f":"J75+J76","v":4500},{"$f":"K75+K76","v":6198.1561643835621},6513.4082876712328,6668.1163220054787,7609.5215769147162,null,"Aktywa ogółem",{"$f":"Q75+Q76","v":4350},{"$f":"R75+R76","v":6372.1687671232876},6920.1795410958894,7295.0124747024611,8438.9915187930128]
[null,"Aktywa trwałe",{"$f":"C5","v":4500},{"$f":"C75-D19","v":3600},{"$f":"D75-E19","v":2700},1800,900,null,"Aktywa trwałe",{"$f":"J5","v":4000},{"$f":"J75-K19","v":3100},{"$f":"K75-L19","v":2200},{"$f":"L75-M19","v":1300},{"$f":"M75-N19","v":400},null,"Aktywa trwałe",{"$f":"Q5","v":3900},{"$f":"Q75-R19","v":3000},{"$f":"R75-S19","v":2100},{"$f":"S75-T19","v":1200},{"$f":"T75-U19","v":300}]
[null,"Aktywa obrotowe",{"$f":"SUM(C77:C79)","v":600},{"$f":"SUM(D77:D79)","v":2064.7797260273974},2148.8368660273945,1944.6529081632812,2365.9506043923739,null,"Aktywa obrotowe",{"$f":"SUM(J77:J79)","v":500},{"$f":"SUM(K77:K79)","v":3098.1561643835621},4313.4082876712328,5368.1163220054787,7209.5215769147162,null,"Aktywa obrotowe",{"$f":"SUM(Q77:Q79)","v":450},{"$f":"SUM(R77:R79)","v":3372.1687671232876},4820.1795410958894,6095.0124747024611,8138.9915187930137]
[null,"Zapasy",{"$f":"C50","v":600},{"$f":"D50","v":1016.0547945205479},1138.896394520548,1277.6325046224661,1434.4411227309533,null,"Zapasy",{"$f":"J50","v":500},{"$f":"K50","v":719.17808219178085},806.64164383561661,905.4820366027401,1017.2647234166799,null,"Zapasy",{"$f":"Q50","v":450},{"$f":"R50","v":766.16438356164383},860.11052054794538,966.36562047123334,1086.6330284894732]
[null,"Należności",{"$f":"C51","v":0},1507.3972602739727,1645.3887780821917,1798.0836163989043,1967.2241830523153,null,"Należności",{"$f":"J51","v":0},{"$f":"K51","v":843.83561643835617},921.72931506849329,1007.9776276164386,1103.5746112500606,null,"Należności",{"$f":"Q51","v":0},{"$f":"R51","v":897.53424657534254},981.42531506849332,1074.4018060712331,1177.5510707446974]
[null,"Środki pieniężne",{"$f":"C71","v":0},{"$f":"D71","v":-458.67232876712342},-635.44830657534521,-1131.0632128580892,-1035.7147013908948,null,"Środki pieniężne",{"$f":"J71","v":0},{"$f":"K71","v":1535.1424657534249},2585.0373287671232,3454.6566577862995,5088.6822422479763,null,"Środki pieniężne",{"$f":"Q71","v":0},{"$f":"R71","v":1708.4701369863014},2978.6437054794505,4054.2450481599944,5874.8074195588433]
[null,"Pasywa ogółem",{"$f":"C81+C85+C86","v":5100},{"$f":"D81+D85+D86","v":5664.7797260273974},4848.8368660273945,3744.6529081632812,3265.9506043923739,null,"Pasywa ogółem",{"$f":"J81+J85+J86","v":4500},{"$f":"K81+K85+K86","v":6198.1561643835621},6513.4082876712328,6668.1163220054777,7609.5215769147153,null,"Pasywa ogółem",{"$f":"Q81+Q85+Q86","v":4350},{"$f":"R81+R85+R86","v":6372.1687671232876},6920.1795410958894,7295.0124747024611,8438.9915187930146]
[null,"Kapitały własne",{"$f":"SUM(C82:C84)","v":2040},{"$f":"SUM(D82:D84)","v":2270.04},2310.3083399999969,2041.1429019999932,1353.3624407511024,null,"Kapitały własne",{"$f":"SUM(J82:J84)","v":1800},{"$f":"SUM(K82:K84)","v":3079.8},4240.125,5217.1522487999973,5934.9921300813558,null,"Kapitały własne",{"$f":"SUM(Q82:Q84)","v":1740},{"$f":"SUM(R82:R84)","v":3249.84},4629.9584999999988,5812.2812337599944,6715.7254618140678]
[null,"Kapitał podstawowy",{"$f":"C65","v":2040},{"$f":"C82+D65","v":2040},{"$f":"D82+E65","v":2040},2040,2040,null,"Kapitał podstawowy",{"$f":"J65","v":1800},{"$f":"J82+K65","v":1800},{"$f":"K82+L65","v":1800},{"$f":"L82+M65","v":1800},{"$f":"M82+N65","v":1800},null,"Kapitał podstawowy",{"$f":"Q65","v":1740},{"$f":"Q82+R65","v":1740},{"$f":"R82+S65","v":1740},{"$f":"S82+T65","v":1740},{"$f":"T82+U65","v":1740}]
[null,"Nie podzielony wynik",0,{"$f":"C83+C84","v":0},{"$f":"D83+D84","v":230.04},270.30833999999697,1.1429019999933416,null,"Nie podzielony wynik",0,{"$f":"J83+J84","v":0},{"$f":"K83+K84","v":1279.8},{"$f":"L83+L84","v":2440.125},{"$f":"M83+M84","v":3417.1522487999978},null,"Nie podzielony wynik",0,{"$f":"Q83+Q84","v":0},{"$f":"R83+R84","v":1509.84},{"$f":"S83+S84","v":2889.9584999999988},{"$f":"T83+T84","v":4072.2812337599944}]
[null,"Wynik finansowy netto",{"$f":"C47","v":0},{"$f":"D47","v":230.04},40.268339999997004,-269.16543800000363,-687.78046124889079,null,"Wynik finansowy netto",{"$f":"J47","v":0},{"$f":"K47","v":1279.8},1160.325,977.02724879999766,717.83988128135854,null,"Wynik finansowy netto",{"$f":"Q47","v":0},{"$f":"R47","v":1509.84},1380.1184999999987,1182.3227337599958,903.44422805407328]
[null,"Zobowiązania długookresowe",{"$f":"C34","v":3060},{"$f":"D34","v":2040},1020,0,0,null,"Zobowiązania długookresowe",{"$f":"J34","v":2700},{"$f":"K34","v":1680},660,-360,-360,null,"Zobowiązania długookresowe",{"$f":"Q34","v":2610},{"$f":"R34","v":1590},570,-450,-450]
[null,"Zobowiązania krótkookresowe",{"$f":"C52","v":0},{"$f":"D52","v":1354.7397260273974},1518.5285260273977,1703.5100061632879,1912.5881636412714,null,"Zobowiązania krótkookresowe",{"$f":"J52","v":0},{"$f":"K52","v":1438.3561643835617},1613.2832876712332,1810.9640732054802,2034.5294468333598,null,"Zobowiązania krótkookresowe",{"$f":"Q52","v":0},{"$f":"R52","v":1532.3287671232877},1720.2210410958908,1932.7312409424667,2173.2660569789464]
[null,"suma kontrolna",{"$f":"C74-C80","v":0},{"$f":"D74-D80","v":0},0,0,0,null,"suma kontrolna",{"$f":"J74-J80","v":0},{"$f":"K74-K80","v":0},0,0,0,null,"suma kontrolna",{"$f":"Q74-Q80","v":0},{"$f":"R74-R80","v":0},0,0,0]
[]
[]
[null,"Przepływy do oceny opłacalności inw.",null,null,null,null,null,null,"Przepływy do oceny opłacalności inw.",null,null,null,null,null,null,"Przepływy do oceny opłacalności inw."]
[null,"Przepływy operacyjne",{"$f":"C57","v":-600},{"$f":"D57","v":867.32767123287658},1047.2240221917782,626.38509371725604,95.348511467194385,null,"Przepływy operacyjne",{"$f":"J57","v":-500},{"$f":"K57","v":2825.1424657534249},2237.8948630136983,1955.6193290191761,1598.0255844616763,null,"Przepływy operacyjne",{"$f":"Q57","v":-450},{"$f":"R57","v":2989.4701369863014},2449.1735684931491,2152.6013426805439,1775.5623713988491]
[null,"- tarcza na odsetkach",{"$f":"-C35*C21","v":0},{"$f":"-D35*D21","v":-58.14},-38.76,-19.38,0,null,"- tarcza na odsetkach",{"$f":"-J35*J21","v":0},{"$f":"-K35*K21","v":-51.3},-31.92,-12.540000000000001,6.84,null,"- tarcza na odsetkach",{"$f":"-Q35*Q21","v":0},{"$f":"-R35*R21","v":-49.59},-30.21,-10.83,8.5500000000000007]
[null,"Przepływy inwestycyjne",{"$f":"C62","v":-4500},{"$f":"D62","v":0},0,0,0,null,"Przepływy inwestycyjne",{"$f":"J62","v":-4000},{"$f":"K62","v":0},0,0,0,null,"Przepływy inwestycyjne",{"$f":"Q62","v":-3900},{"$f":"R62","v":0},0,0,0]
[null,"Przepływy NCF",{"$f":"SUM(C91:C93)","v":-5100},{"$f":"SUM(D91:D93)","v":809.1876712328766},1008.4640221917782,607.00509371725605,95.348511467194385,null,"Przepływy NCF",{"$f":"SUM(J91:J93)","v":-4500},{"$f":"SUM(K91:K93)","v":2773.8424657534247},2205.9748630136983,1943.0793290191762,1604.8655844616762,null,"Przepływy NCF",{"$f":"SUM(Q91:Q93)","v":-4350},{"$f":"SUM(R91:R93)","v":2939.8801369863013},2418.9635684931491,2141.771342680544,1784.1123713988491]
[null,"współczynnik dyskonta",1,{"$f":"C95/(1+D22)","v":0.86956521739130443},{"$f":"D95/(1+E22)","v":0.7561436672967865},0.65751623243198831,0.57175324559303331,null,"współczynnik dyskonta",1,{"$f":"J95/(1+K22)","v":0.86956521739130443},{"$f":"K95/(1+L22)","v":0.7561436672967865},{"$f":"L95/(1+M22)","v":0.65751623243198831},{"$f":"M95/(1+N22)","v":0.57175324559303331},null,"współczynnik dyskonta",1,{"$f":"Q95/(1+R22)","v":0.86956521739130443},{"$f":"R95/(1+S22)","v":0.7561436672967865},{"$f":"S95/(1+T22)","v":0.65751623243198831},{"$f":"T95/(1+U22)","v":0.57175324559303331}]
[null,"Zdyskontowane przeływy NCF",{"$f":"C94*C95","v":-5100},{"$f":"D94*D95","v":703.64145324597973},762.54368407695904,399.11570228799616,54.515820893832945,null,"Zdyskontowane przeływy NCF",{"$f":"J94*J95","v":-4500},{"$f":"K94*K95","v":2412.0369267421088},1668.033922883704,1277.6061997331644,917.5871066565237,null,"Zdyskontowane przeływy NCF",{"$f":"Q94*Q95","v":-4350},{"$f":"R94*R95","v":2556.4175104228711},1829.0839837377312,1408.2494239701123,1020.0720388499752]
[]
[]
[null,"Mierniki opłacalności inwestycji",null,null,null,null,null,null,"Mierniki opłacalności inwestycji",null,null,null,null,null,null,"Mierniki opłacalności inwestycji"]
[null,"NPV",{"$f":"SUM(C96:G96)","v":-3180.1833394952328},null,null,null,null,null,"NPV",{"$f":"SUM(J96:N96)","v":1775.2641560155009},null,null,null,null,null,"NPV",{"$f":"SUM(Q96:U96)","v":2463.8229569806899}]
[null,"PI",{"$f":"SUM(D96:G96)/-C96","v":0.37643463931466037},null,null,null,null,null,"PI",{"$f":"SUM(K96:N96)/-J96","v":1.3945031457812225},null,null,null,null,null,"PI",{"$f":"SUM(R96:U96)/-Q96","v":1.5663960820645262}]
[null,"IRR",{"$f":"IFERROR(IRR(C94:G94),\"-\")","v":-0.28313916194391475},null,null,null,null,null,"IRR",{"$f":"IFERROR(IRR(J94:N94),\"-\")","v":0.35589398182047693},null,null,null,null,null,"IRR",{"$f":"IFERROR(IRR(Q94:U94),\"-\")","v":0.43830390911086181}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Podsumowanie anlizy scenariuszowej:"]
[null,null,null,null,null,null,null,null,null,"p","NPV"]
[null,null,null,null,null,null,null,null,"scenariusz pesymistyczny",0.25,{"$f":"C100","v":-3180.1833394952328}]
[null,null,null,null,null,null,null,null,"scenariusz typowy",0.5,{"$f":"J100","v":1775.2641560155009}]
[null,null,null,null,null,null,null,null,"scenariusz optymistyczny",0.25,{"$f":"Q100","v":2463.8229569806899}]
[]
[null,null,null,null,null,null,null,null,"Wartość oczekiwana NPV =",{"$f":"SUMPRODUCT(J111:J113,K111:K113)","v":708.54198237911476}]
[null,null,null,null,null,null,null,null,"Odch.standardowe NPV =",{"$f":"SUMPRODUCT(J111:J113,(K111:K113-J115)^2)^0.5","v":2262.6858111677852}]
[null,null,null,null,null,null,null,null,"Wsp.zmienności NPV =",{"$f":"J116/J115","v":3.1934392985017297}]