{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Лист1","index":0,"n_rows":99,"n_cols":17,"rows_kept":99,"cut":false,"hidden":false,"merged":[[0,12,0,13],[0,10,0,11]]}
[null,"IB",52,400,"ИИС",null,"Брокер",null,"Курс рубля","Выводимая сумма в рублях\n, чтобы, оплатив НДФЛ,\n внести на ИИС 400к","Выводимая сумма в долларах,\nчтобы, оплатив НДФЛ, \nвнести на ИИС 400 к",null,"Плоти нолог",null,"ИИС",null,"Льгота"]
[null,null,null,"перевод 400 к рублей\nв долларах",{"$nulls":5},"52 к с вычета НДФЛ\nв долларах по курсу года\nвносимые на счёт брокера",null,null,"IB"]
[null,"Сумма","Дивы до и после налога",null,5.3333000000000004,{"$nulls":7},"Рублей на счету","Рублей было","Рублей на счету","Рублей было"]
[null,15.88,{"$f":"B4*0.02","v":0.31760000000000005},null,{"$f":"E3*0.9915","v":5.2879669500000004},{"$f":"E4*0.02","v":0.10575933900000001},10.666600000000001,{"$f":"G4*0.02","v":0.21333200000000002},75,{"$f":"D1/0.987","v":405.26849037487335},{"$f":"J4/I7","v":5.050074646415867},null,"Разница в рублях","Налог","Разница в рублях","Налог"]
["1 год",{"$f":"B4*0.08","v":1.2704000000000002},{"$f":"C4*0.85","v":0.26996000000000003},null,{"$f":"E4*0.08","v":0.42303735600000003},{"$f":"F4*0.85","v":8.9895438150000007E-2},{"$f":"G4*0.08","v":0.85332800000000009},{"$f":"H4*0.85","v":0.18133220000000003},null,{"$f":"52/I7","v":0.6479750778816199},null,null,"Итог в рублях",null,"Итог в рублях",null,"Итог в рублях"]
[null,{"$f":"B4+B5+C5","v":17.420360000000002},null,null,{"$f":"E4+E5+F5","v":5.8008997441500005},null,{"$f":"G4+G5+H5","v":11.7012602},{"$nulls":5},"Итог в долларах",null,"Итог а долларах",null,"Итог в долларах"]
[null,null,null,{"$f":"D1/I7","v":4.9844236760124607},{"$f":"D7+E6","v":10.785323420162461},{"$f":"E7*0.02","v":0.21570646840324922},{"$f":"G6-K4+J5","v":7.2991606314657531},{"$f":"G7*0.02","v":0.14598321262931507},{"$f":"I4*1.07","v":80.25},{"$f":"D1/0.987","v":405.26849037487335},{"$f":"J7/I10","v":4.7196959312297819},null,"Разница в долларах","Налог"]
["2 год",{"$f":"B6*0.08","v":1.3936288000000001},{"$f":"B6*0.02","v":0.34840720000000003},null,{"$f":"E7*0.08","v":0.8628258736129969},{"$f":"F7*0.85","v":0.18335049814276183},{"$f":"G7*0.08","v":0.58393285051726029},{"$f":"H7*0.85","v":0.12408573073491781},null,{"$f":"C1/I10","v":0.60558418493609334},null,null,"Итог в долларах"]
[null,{"$f":"B6+B8+C9-0.12","v":18.990134920000003},{"$f":"C8*0.85","v":0.29614612000000001},null,{"$f":"E8+E7+F8","v":11.831499791918219},null,{"$f":"G7+G8+H8","v":8.0071792127179311},{"$nulls":5},"Итог в рублях"]
[null,null,null,{"$f":"D1/I10","v":4.6583398841237953},{"$f":"E9+D10","v":16.489839676042013},{"$f":"E10*0.02","v":0.32979679352084029},{"$f":"G9-K7+J8","v":3.8930674664242426},{"$f":"G10*0.02","v":7.7861349328484861E-2},{"$f":"I7*1.07","v":85.867500000000007},"нет","нет"]
["3 год",{"$f":"B9*0.08","v":1.5192107936000003},{"$f":"B9*0.02","v":0.37980269840000008},null,{"$f":"E10*0.08","v":1.3191871740833612},{"$f":"F10*0.85","v":0.28032727449271422},{"$f":"G10*0.08","v":0.31144539731393944},{"$f":"H10*0.85","v":6.6182146929212135E-2},null,{"$f":"C1/I13","v":0.56596652797765734}]
[null,{"$f":"B9+B11+C12-0.12","v":20.712178007240002},{"$f":"C11*0.85","v":0.32283229364000005},null,{"$f":"E10+F10+E11","v":18.138823643646216},null,{"$f":"G10+G11+H11","v":4.270695010667394},{"$nulls":5},{"$f":"B12*I13","v":1902.9981511892488},1200,{"$f":"(E12+G12+J11)*I13","v":2110.9467970627234},1200]
[{"$nulls":8},{"$f":"I10*1.07","v":91.878225000000015},null,null,null,{"$f":"M12-N12","v":702.9981511892488},{"$f":"M13*0.13","v":91.389759654602344},{"$f":"O12-P12","v":910.94679706272336},{"$f":"O13*0.13","v":118.42308361815404}]
["4 год",{"$f":"B12*0.08","v":1.6569742405792003},{"$f":"B12*0.02","v":0.41424356014480007},{"$nulls":9},{"$f":"M12-N13","v":1811.6083915346464},null,{"$f":"O12-P13","v":1992.5237134445692},null,1891.6057000000001]
[null,{"$f":"B12+B14+C15-0.12","v":22.601259273942279},{"$f":"C14*0.85","v":0.35210702612308004},{"$nulls":9},{"$f":"M14/I13","v":19.717494450231772},null,{"$f":"O14/I13","v":21.686571692526375},null,{"$f":"Q14/I13","v":20.588182890995117}]
[{"$nulls":8},{"$f":"I13*1.07","v":98.309700750000019},null,null,null,{"$f":"B12-16","v":4.7121780072400021},{"$f":"M16*0.13","v":0.61258314094120025}]
["5 год",1.8081007419153823,{"$f":"B15*0.02","v":0.45202518547884557},{"$nulls":9},{"$f":"B12-N16","v":20.099594866298801}]
[null,{"$f":"B15+B17+C18-0.12","v":24.67358142351468},{"$f":"C17*0.85","v":0.38422140765701873},{"$nulls":9},{"$f":"M17*I13","v":1846.7150995346465}]
[{"$nulls":8},{"$f":"I16*1.07","v":105.19137980250002}]
["6 год",1.9738865138811745,{"$f":"B18*0.02","v":0.49347162847029363}]
[null,{"$f":"B18+B20+C21-0.12","v":26.946918821595606},{"$f":"C20*0.85","v":0.41945088419974957}]
[{"$nulls":8},{"$f":"I19*1.07","v":112.55477638867504}]
["7 год",2.1557535057276485,{"$f":"B21*0.02","v":0.53893837643191211}]
[null,{"$f":"B21+B23+C24-0.12","v":29.440769947290381},{"$f":"C23*0.85","v":0.45809761996712528}]
[{"$nulls":8},{"$f":"I22*1.07","v":120.4336107358823}]
["8 год",2.3552615957832304,{"$f":"B24*0.02","v":0.58881539894580759}]
[null,{"$f":"B24+B26+C27-0.12","v":32.176524632177546},{"$f":"C26*0.85","v":0.50049308910393642}]
[{"$nulls":8},{"$f":"I25*1.07","v":128.86396348739407}]
["9 год",2.5741219705742036,{"$f":"B27*0.02","v":0.64353049264355089}]
[null,{"$f":"B27+B29+C30-0.12","v":35.17764752149877},{"$f":"C29*0.85","v":0.54700091874701828}]
[{"$nulls":8},{"$f":"I28*1.07","v":137.88444093151168}]
["10 год",2.8142118017199018,{"$f":"B30*0.02","v":0.70355295042997545}]
[null,{"$f":"B30+B32+C33-0.12","v":38.469879331084151},{"$f":"C32*0.85","v":0.59802000786547915},{"$nulls":9},{"$f":"B33*I34","v":5675.7056505681021},1200]
[{"$nulls":8},{"$f":"I31*1.07","v":147.5363517967175},null,null,null,{"$f":"M33-N33","v":4475.7056505681021},{"$f":"M34*0.13","v":581.84173457385327}]
["11 год",3.077590346486732,{"$f":"B33*0.02","v":0.76939758662168301},{"$nulls":9},{"$f":"M33-N34","v":5093.8639159942486}]
[null,{"$f":"B33+B35+C36-0.12","v":42.081457626199317},{"$f":"C35*0.85","v":0.65398794862843057},{"$nulls":9},{"$f":"M35/I34","v":34.526161545683422}]
[{"$nulls":8},{"$f":"I34*1.07","v":157.86389642248773},null,null,null,{"$f":"B33-16","v":22.469879331084151},{"$f":"M37*0.13","v":2.9210843130409399}]
["12 год",3.3665166100959456,{"$f":"B36*0.02","v":0.8416291525239864},{"$nulls":9},{"$f":"B33-N37","v":35.548795018043208}]
[null,{"$f":"B36+B38+C39-0.12","v":46.043359015940652},{"$f":"C38*0.85","v":0.71538477964538838},{"$nulls":9},{"$f":"M38*I34","v":5244.7395277314208}]
[{"$nulls":8},{"$f":"I37*1.07","v":168.91436917206187}]
["13 год",3.6834687212752524,{"$f":"B39*0.02","v":0.92086718031881309}]
[null,{"$f":"B39+B41+C42-0.12","v":50.389564840486898},{"$f":"C41*0.85","v":0.78273710327099111}]
[{"$nulls":8},{"$f":"I40*1.07","v":180.7383750141062}]
["14 год",4.031165187238952,{"$f":"B42*0.02","v":1.007791296809738}]
[null,{"$f":"B42+B44+C45-0.12","v":55.157352630014131},{"$f":"C44*0.85","v":0.85662260228827725}]
[{"$nulls":8},{"$f":"I43*1.07","v":193.39006126509364}]
["15 год",4.4125882104011307,{"$f":"B45*0.02","v":1.1031470526002827}]
[null,{"$f":"B45+B47+C48-0.12","v":60.387615835125509},{"$f":"C47*0.85","v":0.93767499471024029}]
[{"$nulls":8},{"$f":"I46*1.07","v":206.92736555365019}]
["16 год",4.8310092668100406,{"$f":"B48*0.02","v":1.2077523167025102}]
[null,{"$f":"B48+B50+C51-0.12","v":66.125214571132673},{"$f":"C50*0.85","v":1.0265894691971336}]
[{"$nulls":8},{"$f":"I49*1.07","v":221.4122811424057}]
["17 год",5.2900171656906139,{"$f":"B51*0.02","v":1.3225042914226535}]
[null,{"$f":"B51+B53+C54-0.12","v":72.419360384532538},{"$f":"C53*0.85","v":1.1241286477092554}]
[{"$nulls":8},{"$f":"I52*1.07","v":236.91114082237411}]
["18 год",{"$f":"B54*0.08","v":5.7935488307626031},{"$f":"B54*0.02","v":1.4483872076906508}]
[null,{"$f":"B54+B56+C57","v":79.444038341832197},{"$f":"C56*0.85","v":1.2311291265370532}]
[{"$nulls":8},{"$f":"I55*1.07","v":253.49492067994032}]
["19 год",{"$f":"B57*0.08","v":6.3555230673465761},{"$f":"B57*0.02","v":1.588880766836644}]
[null,{"$f":"B57+B59+C60","v":87.150110060989931},{"$f":"C59*0.85","v":1.3505486518111474}]
[{"$nulls":8},{"$f":"I58*1.07","v":271.23956512753614}]
["20 год",{"$f":"B60*0.08","v":6.9720088048791951},{"$f":"B60*0.02","v":1.7430022012197988}]
[null,{"$f":"B60+B62+C63","v":95.603670736905954},{"$f":"C62*0.85","v":1.4815518710368289}]
[{"$nulls":8},{"$f":"I61*1.07","v":290.2263346864637}]
["21 год",{"$f":"B63*0.08","v":7.6482936589524764},{"$f":"B63*0.02","v":1.9120734147381191}]
[null,{"$f":"B63+B65+C66","v":104.87722679838583},{"$f":"C65*0.85","v":1.6252624025274012}]
[{"$nulls":8},{"$f":"I64*1.07","v":310.54217811451616}]
["22 год",{"$f":"B66*0.08","v":8.390178143870866},{"$f":"B66*0.02","v":2.0975445359677165}]
[null,{"$f":"B66+B68+C69","v":115.05031779782927},{"$f":"C68*0.85","v":1.7829128555725591}]
[{"$nulls":8},{"$f":"I67*1.07","v":332.28013058253231}]
["23 год",{"$f":"B69*0.08","v":9.2040254238263408},{"$f":"B69*0.02","v":2.3010063559565852}]
[null,{"$f":"B69+B71+C72","v":126.21019862421871},{"$f":"C71*0.85","v":1.9558554025630974}]
[{"$nulls":8},{"$f":"I70*1.07","v":355.53973972330959}]
["24 год",{"$f":"B72*0.08","v":10.096815889937497},{"$f":"B72*0.02","v":2.5242039724843743}]
[null,{"$f":"B72+B74+C75","v":138.45258789076792},{"$f":"C74*0.85","v":2.145573376611718}]
[{"$nulls":8},{"$f":"I73*1.07","v":380.42752150394131}]
["25 год",{"$f":"B75*0.08","v":11.076207031261433},{"$f":"B75*0.02","v":2.7690517578153582}]
[null,{"$f":"B75+B77+C78","v":151.88248891617241},{"$f":"C77*0.85","v":2.3536939941430544}]
[{"$nulls":8},{"$f":"I76*1.07","v":407.05744800921724}]
["26 год",{"$f":"B78*0.08","v":12.150599113293794},{"$f":"B78*0.02","v":3.0376497783234484}]
[null,{"$f":"B78+B80+C81","v":166.61509034104114},{"$f":"C80*0.85","v":2.5820023115749309}]
[{"$nulls":8},{"$f":"I79*1.07","v":435.55146936986245}]
["27 год",13.329207227283291,3.3323018068208228]
[null,{"$f":"B81+B83+C84","v":182.77675410412212},{"$f":"C83*0.85","v":2.8324565357976992}]
[{"$nulls":8},{"$f":"I82*1.07","v":466.04007222575285}]
["28 год",14.62214032832977,3.6555350820824426]
[null,{"$f":"B84+B86+C87","v":200.50609925222199},{"$f":"C86*0.85","v":3.1072048197700761}]
[{"$nulls":8},{"$f":"I85*1.07","v":498.66287728155555}]
["29 год",{"$f":"B87*0.08","v":16.040487940177758},{"$f":"B87*0.02","v":4.0101219850444396}]
[null,{"$f":"B87+B89+C90","v":219.95519087968754},{"$f":"C89*0.85","v":3.4086036872877736}]
[{"$nulls":8},{"$f":"I88*1.07","v":533.56927869126446}]
["30 год",17.596415270375005,4.3991038175937511]
[null,{"$f":"B90+B92+C93","v":241.29084439501722},{"$f":"C92*0.85","v":3.7392382449546884},{"$nulls":9},{"$f":"B93*I94","v":137757.55852456135},1200]
[{"$nulls":8},{"$f":"I91*1.07","v":570.91912819965296},null,null,null,{"$f":"M93-N93","v":136557.55852456135},{"$f":"M94*0.13","v":17752.482608192975}]
["31 год",19.303267551601376,4.825816887900344,{"$nulls":9},{"$f":"M93-N94","v":120005.07591636837}]
[null,{"$f":"B93+B95+C96","v":264.69605630133384},{"$f":"C95*0.85","v":4.1019443547152923},{"$nulls":9},{"$f":"M95/I94","v":210.19627822734651}]
[{"$nulls":8},{"$f":"I94*1.07","v":610.88346717362867},null,null,null,{"$f":"B93-16","v":225.29084439501722},{"$f":"M97*0.13","v":29.28780977135224}]
["32 год",21.175684504106709,5.2939211260266772,{"$nulls":9},{"$f":"B93-N97","v":212.00303462366497}]
[null,{"$f":"B96+B98+C99","v":290.37157376256323},{"$f":"C98*0.85","v":4.4998329571226758}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}