{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Stratus Corp"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Stratus Corp","index":0,"n_rows":51,"n_cols":39,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,2,3,5],[7,3,7,5],[8,3,8,5],[21,4,21,5],[22,4,22,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,12,"sazba 1",9.1359999999999992,"< 50 0000",null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"sazba 2",8.92,"50 000 - 149 999,99 ",null,null,"sazba 1",2.6749999999999998,"< 50 0000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"sazba 3",8.8190000000000008,"150 000 - 349 999,99",null,null,"sazba 2",2.617,"50 000 - 149 999,99 "]
[null,null,"Indikativní nabídka financování společností ",null,null,null,null,null,null,null,null,null,null,"sazba 4",8.7650000000000006,"350 000 - 549 999",null,null,"sazba 3",2.5880000000000001,"150 000 - 349 999,99"]
[null,null,null,"       GRENKELEASING s.r.o.",null,null,null,null,null,null,null,null,null,"sazba 5",8.7319999999999993,"550 000 - 749 999",null,null,"sazba 4",2.5720000000000001,"350 000 - 549 999",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"sazba 6",null,"750 000 - 1 499 999",null,null,"sazba 5",2.5569999999999999,"550 000 - 749 999",null,null,null,null,null,null,null,null,null,null,null,null,null,"inkasem*","kvartálně*",null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"sazba 7",null,">1 500 000",null,null,"sazba 6",null,"750 000 - 1 499 999",null,null,null,null,null,null,null,null,null,null,null,null,null,"převodem","měsíčně",null,null,0.15]
[null,null,"Zákazník:","Stratus Corp",null,null,null,null,null,"Provize",null,null,null,null,null,null,null,null,"sazba 7",null,">1 500 000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,"Předmět leasingu:","Pila",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,24,"sazba 1",4.7140000000000004,"< 50 0000",null,60]
[null,null,"Pořizovací cena  bez DPH",null,"Požadovaná akontace",null,null,null,null,null,null,null,null,"sazba 2",4.6020000000000003,"50 000 - 149 999,99 ",null,null,"sazba 1",2.2080000000000002,"< 50 0000"]
[null,null,250000,null,0,null,null,null,null,null,null,null,null,"sazba 3",4.5780000000000003,"150 000 - 349 999,99",null,null,"sazba 2",2.1579999999999999,"50 000 - 149 999,99 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"sazba 4",4.5650000000000004,"350 000 - 549 999",null,null,"sazba 3",2.1339999999999999,"150 000 - 349 999,99"]
[null,null,"Classic leasing",null,null,null,null,null,null,null,null,null,null,"sazba 5",4.5579999999999998,"550 000 - 749 999",null,null,"sazba 4",2.121,"350 000 - 549 999"]
[null,null,"Délka financování","Měsíční splátka","Indikativní zůstatková hodnota",null,null,null,null,null,null,"2023-01-24",null,"sazba 6",null,"750 000 - 1 499 999",null,null,"sazba 5",2.1080000000000001,"550 000 - 749 999"]
[null,null,12,{"$f":"IF($D$25=\"převodem\",R28*1.015,R28)","v":22047.5},{"$f":"C12*10%","v":25000},null,null,null,{"$f":"(D16*C16)+E16","v":289570},{"$f":"I16/C12","v":1.15828},{"$f":"J16+E12","v":1.15828},8.1000000000000003E-2,null,"sazba 7",null,">1 500 000",null,null,"sazba 6",null,"750 000 - 1 499 999"]
[null,null,24,{"$f":"IF($D$25=\"převodem\",R29*1.015,R29)","v":11445},{"$f":"C12*8%","v":20000},null,null,null,{"$f":"(D17*C17)+E17","v":294680},{"$f":"I17/C12","v":1.17872},{"$f":"J17+E12","v":1.17872},8.1000000000000003E-2,null,null,null,null,null,null,"sazba 7",null,">1 500 000"]
[null,null,36,{"$f":"IF($D$25=\"převodem\",R30*1.015,R30)","v":8222.5},{"$f":"C12*6%","v":15000},null,null,null,{"$f":"(D18*C18)+E18","v":311010},{"$f":"I18/C12","v":1.24404},{"$f":"J18+E12","v":1.24404},7.7600000000000002E-2,36,"sazba 1",3.4039999999999999,"< 50 0000"]
[null,null,48,{"$f":"IF($D$25=\"převodem\",R31*1.015,R31)","v":6470},{"$f":"C12*5%","v":12500},null,null,null,{"$f":"(D19*C19)+E19","v":323060},{"$f":"I19/C12","v":1.2922400000000001},{"$f":"J19+E12","v":1.2922400000000001},7.4999999999999997E-2,null,"sazba 2",3.3260000000000001,"50 000 - 149 999,99 "]
[null,null,60,{"$f":"IF($D$25=\"převodem\",R32*1.015,R32)","v":5335},{"$f":"C12*4%","v":10000},null,null,null,{"$f":"(D20*C20)+E20","v":330100},{"$f":"I20/C12","v":1.3204},{"$f":"J20+E12","v":1.3204},7.3499999999999996E-2,null,"sazba 3",3.2890000000000001,"150 000 - 349 999,99"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"sazba 4",3.2679999999999998,"350 000 - 549 999"]
[null,null,"Výše akontace",{"$f":"C12*E12","v":0},null,null,null,null,null,null,null,null,null,"sazba 5",3.2490000000000001,"550 000 - 749 999"]
[null,null,"Poplatek za sjednání",0,null,null,null,null,null,null,null,null,null,"sazba 6",null,"750 000 - 1 499 999"]
[null,null,"Frekvence plateb","měsíčně",null,null,null,null,null,null,null,null,null,"sazba 7",null,">1 500 000"]
[null,null,"Způsob úhrady","inkasem*"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"splátka s provizí"]
[null,null,"*Při změně způsobu platby dochází k překalkulování splátky",null,null,null,null,null,null,"Provize","Navýšení koef.",null,null,null,null,null,{"$f":"IF(P30<49999.99,P30*O1/100,IF(AND(P30>=50000,P30<150000),P30*O2/100,IF(AND(P30>=150000,P30<350000),P30*O3/100,IF(AND(P30>=350000,P30<550000),P30*O4/100,IF(AND(P30>=550000,P30<750000),P30*O5/100,IF(AND(P30>=750000,P30<1500000),P30*O6/100,P30*O7/100))))))","v":22047.5},{"$f":"IF($J$9=0%,Q28,IF($J$9=1%,Q28*1.01,IF($J$9=2%,Q28*1.02,IF($J$9=3%,Q28*1.03,IF($J$9=4%,Q28*1.04)))))","v":22047.5}]
[null,null,null,null,null,null,null,null,null,0.01,9.7000000000000003E-3,null,null,null,null,null,{"$f":"IF(P30<49999.99,P30*O10/100,IF(AND(P30>=50000,P30<150000),P30*O11/100,IF(AND(P30>=150000,P30<350000),P30*O12/100,IF(AND(P30>=350000,P30<550000),P30*O13/100,IF(AND(P30>=550000,P30<750000),P30*O14/100,IF(AND(P30>=750000,P30<1500000),P30*O15/100,P30*O16/100))))))","v":11445},{"$f":"IF($J$9=0%,Q29,IF($J$9=1%,Q29*1.01,IF($J$9=2%,Q29*1.02,IF($J$9=3%,Q29*1.03,IF($J$9=4%,Q29*1.04)))))","v":11445}]
[null,null,"Sjednaná doba leasingu začíná běžet prvním dnem kalendářního měsíce následujícího po předání",null,null,null,null,null,null,0.02,1.9400000000000001E-2,null,null,null,"financováno",{"$f":"P31*(1+(0.0275*E12))","v":250000},{"$f":"IF(P30<49999.99,P30*O18/100,IF(AND(P30>=50000,P30<150000),P30*O19/100,IF(AND(P30>=150000,P30<350000),P30*O20/100,IF(AND(P30>=350000,P30<550000),P30*O21/100,IF(AND(P30>=550000,P30<750000),P30*O22/100,IF(AND(P30>=750000,P30<1500000),P30*O23/100,P30*O24/100))))))","v":8222.5},8222.5]
[null,null,"předmětu leasingu. ",null,null,null,null,null,null,0.03,2.8899999999999999E-2,null,null,null,"Mezisoučet",{"$f":"C12*(1-E12)","v":250000},{"$f":"IF(P30<49999.99,P30*T2/100,IF(AND(P30>=50000,P30<150000),P30*T3/100,IF(AND(P30>=150000,P30<350000),P30*T4/100,IF(AND(P30>=350000,P30<550000),P30*T5/100,IF(AND(P30>=550000,P30<750000),P30*T6/100,IF(AND(P30>=750000,P30<1500000),P30*T7/100,P30*T8/100))))))","v":6470},6470]
[null,null,"Pokud dojde k předání předmětu leasingu před začátkem běhu sjednané doby, účtuje se za každý den",null,null,null,null,null,null,0.04,3.8699999999999998E-2,null,null,null,null,null,{"$f":"IF(P30<49999.99,P30*T11/100,IF(AND(P30>=50000,P30<150000),P30*T12/100,IF(AND(P30>=150000,P30<350000),P30*T13/100,IF(AND(P30>=350000,P30<550000),P30*T14/100,IF(AND(P30>=550000,P30<750000),P30*T15/100,IF(AND(P30>=750000,P30<1500000),P30*T16/100,P30*T17/100))))))","v":5335},5335]
[null,null,"tohoto přechodného období poplatek za užívání  předmětu leasingu ve výši 1/30 měsíční leasingové splátky"]
[]
[null,null,"Povinné pojistné není součástí splátek, platba 1x ročně za kalendářní rok. "]
[null,null,"Výše ročního pojistného"]
[null,null,{"$f":"IF(C12<100000,1300,C12/100*1.1)","v":2750}]
[]
[null,null,"Ukončení financování:"]
[null,null,"Na konci základní leasingové doby má zákazník na výběr ze tří možností:"]
[null,null,"1. Vrátit předmět leasingu společnosti GRENKELEASING s.r.o."]
[null,null,"2. Odkoupit zařízení "]
[null,null,"U těchto dvou variant je třeba vypovědět smlouvu 3 měsíce před koncem leasingové doby"]
[null,null,"3. Pokračovat ve stávajícím nájmu (není vyžadována žádná akce)"]
[]
[null,null,"Všechny ceny jsou uvedeny bez DPH. DPH je účtováno s každou splátkou a s odkupem. "]
[null,null,"Datum vyhotovení:",{"$f":"TODAY()","v":"2023-03-24"},"Jméno obchodníka:","Michal Woloszcuk"]
[null,null,null,null,"Email obchodníka:","mwoloszcuk@grenke.cz"]
[]
[]
[null,null,"Platnost kalkulace je 30 dnů od data vyhotovení"]