{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["100","10"],"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":"100","index":0,"n_rows":106,"n_cols":9,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["время\n(лет) (N)",{"$nulls":4},"Доходность\n\nматожидания\nфинансового\nрезультата\nчерез N лет",null,null,"Среднее значение\nдоходности\nвсех совершенных\nитераций"]
[100,null,null,"корень степени N",null,{"$f":"F4^(1/$A$2)","v":1.05},null,{"$f":"H3^(1/$A$2)","v":1.0396304627936013}]
[null,null,"произведение",{"$nulls":4},{"$f":"PRODUCT(H6:H106)","v":48.741585497894903}]
[1.2,0.9,"сумма",{"$f":"SUM(D6:D106)","v":1.2676506002282297E+30},null,{"$f":"SUM(F6:F106)","v":131.5012578463035},null,null,{"$f":"SUM(I6:I106)","v":1.0393379997253844}]
["Число\nслучаев\nприроста\nна 20%","Число\nслучаев\nприроста\nна -10%","Результат\nчерез\nN лет ( R)","Случаев рез-та через 100 лет","Вероятность\nтакого\nисхода (P)","R*P",null,"Средняя\nдоходность\nза N лет\nв ЭТОМ\nисходе\n(i)","P*i"]
[0,{"$f":"$A$2-A6","v":100},{"$f":"1*($A$4^A6)*($B$4^B6)","v":2.6561398887587605E-5},{"$f":"COMBIN($A$2,A6)","v":1},{"$f":"D6/$D$4","v":7.8886090522101163E-31},{"$f":"C6*E6","v":2.0953249170398729E-35},null,{"$f":"C6^(1/$A$2)","v":0.9},{"$f":"H6*E6","v":7.0997481469891047E-31}]
[1,{"$f":"$A$2-A7","v":99},{"$f":"1*($A$4^A7)*($B$4^B7)","v":3.5415198516783469E-5},{"$f":"COMBIN($A$2,A7)","v":100},{"$f":"D7/$D$4","v":7.8886090522101158E-29},{"$f":"C7*E7","v":2.7937665560531633E-33},null,{"$f":"C7^(1/$A$2)","v":0.90259286646982984},{"$f":"H7*E7","v":7.1202022568941759E-29}]
[2,98,{"$f":"1*($A$4^A8)*($B$4^B8)","v":4.7220264689044627E-5},4950,3.9048614808440077E-27,1.843885926995088E-31,null,0.90519320289136007,3.5346540706922864E-27]
[3,97,{"$f":"1*($A$4^A9)*($B$4^B9)","v":6.2960352918726165E-5},161700,1.2755880837423759E-25,8.0311475931341608E-30,null,0.90780103078524321,1.1579801772787019E-25]
[4,96,{"$f":"1*($A$4^A10)*($B$4^B10)","v":8.394713722496822E-5},3921225,3.0933011030752613E-24,2.5967377217800451E-28,null,0.91041637173413203,2.8161919669429678E-24]
[5,95,{"$f":"1*($A$4^A11)*($B$4^B11)","v":1.1192951629995761E-4},75287520,5.9391381179045019E-23,6.6476485677569152E-27,null,0.91303924738285824,5.4226661972743722E-23]
[6,94,{"$f":"1*($A$4^A12)*($B$4^B12)","v":1.4923935506661013E-4},1192052400,9.4036353533487946E-22,1.4033924754153486E-25,null,0.91566967943861111,8.6106237695584814E-22]
[7,93,{"$f":"1*($A$4^A13)*($B$4^B13)","v":1.989858067554802E-4},16007560799.999996,1.2627738903068378E-20,2.5127408131246238E-24,null,0.91830768967111798,1.159614973784682E-20]
[8,92,{"$f":"1*($A$4^A14)*($B$4^B14)","v":2.6531440900730692E-4},186087894300,1.4679746474816994E-19,3.8947482603431678E-23,null,0.92095329991282371,1.3519360957866351E-19]
[9,91,{"$f":"1*($A$4^A15)*($B$4^B15)","v":3.537525453430758E-4},1902231808400,1.5005963063146259E-18,5.3083976289121675E-22,null,0.92360653205907151,1.3859605504959039E-18]
[10,90,{"$f":"1*($A$4^A16)*($B$4^B16)","v":4.7167006045743446E-4},17310309456440.006,1.3655426387463101E-17,6.4408557897467665E-21,null,0.92626740806828456,1.2648576405982704E-17]
[11,89,{"$f":"1*($A$4^A17)*($B$4^B17)","v":6.2889341394324583E-4},141629804643600.03,1.1172621589742536E-16,7.0263881342691977E-20,null,0.92893594996214723,1.0378649850035078E-16]
[12,88,{"$f":"1*($A$4^A18)*($B$4^B18)","v":8.3852455192432764E-4},1050421051106700,8.2863610123923787E-16,6.9483171549995376E-19,null,0.93161217982578759,7.7196748455782843E-16]
[13,87,{"$f":"1*($A$4^A19)*($B$4^B19)","v":1.1180327358991035E-3},7110542499799198,5.6092289930040699E-15,6.2713016373329136E-18,null,0.93429611980796023,5.2406808832780149E-15]
[14,86,{"$f":"1*($A$4^A20)*($B$4^B20)","v":1.4907103145321381E-3},4.41869426773236E+16,3.4857351599382448E-14,5.1962213566472737E-17,null,0.93698779212122929,3.266091291429876E-14]
[15,85,{"$f":"1*($A$4^A21)*($B$4^B21)","v":1.9876137527095172E-3},2.5333847134998864E+17,1.9984881583645935E-13,3.9722225481925817E-16,null,0.93968721904215258,1.8779537798222978E-13]
[16,84,{"$f":"1*($A$4^A22)*($B$4^B22)","v":2.6501516702793558E-3},1.3458606290468155E+18,1.061696834131191E-12,2.8136576383030802E-15,null,0.94239442291146591,1.0005371753079942E-12]
[17,83,{"$f":"1*($A$4^A23)*($B$4^B23)","v":3.5335355603724741E-3},6.6501348729371996E+18,5.2460314157070568E-12,1.8537038558232039E-14,null,0.94510942613426785,4.9580737407812371E-12]
[18,82,{"$f":"1*($A$4^A24)*($B$4^B24)","v":4.7113807471632985E-3},3.0664510802988204E+19,2.4190033750204764E-11,1.1396845928394512E-13,null,0.9478322511802052,2.2928094145581723E-11]
[19,81,{"$f":"1*($A$4^A25)*($B$4^B25)","v":6.281840996217731E-3},1.3234157293921229E+20,1.0439909302719954E-10,6.5581850254621073E-13,null,0.95056292058365899,9.92379067742199E-11]
[20,80,{"$f":"1*($A$4^A26)*($B$4^B26)","v":8.3757879949569753E-3},5.3598337040380979E+20,4.2281632676015815E-10,3.5414199137495383E-12,null,0.95330145694393109,4.0307142032013999E-10]
[21,79,{"$f":"1*($A$4^A27)*($B$4^B27)","v":1.1167717326609298E-2},2.0418414110621326E+21,1.6107288638482216E-9,1.7988164641267492E-11,null,0.95604788292543086,1.5399339202489768E-9]
[22,78,{"$f":"1*($A$4^A28)*($B$4^B28)","v":1.4890289768812395E-2},7.3320668851776583E+21,5.7839809201822503E-9,8.6125151918795857E-11,null,0.95880222125786319,5.5456937539838413E-9]
[23,77,{"$f":"1*($A$4^A29)*($B$4^B29)","v":1.9853719691749861E-2},2.4865270306254648E+22,1.9615239642357184E-8,3.8943546954585932E-10,null,0.96156449473641636,1.8861317995836911E-8]
[24,76,{"$f":"1*($A$4^A30)*($B$4^B30)","v":2.6471626255666476E-2},7.9776075565900384E+22,6.2932227185896005E-8,1.6659183975017322E-9,null,0.9643347262219506,6.0687732073848622E-8]
[25,75,{"$f":"1*($A$4^A31)*($B$4^B31)","v":3.5295501674221977E-2},2.4251926972033706E+23,1.9131397064512376E-7,6.7525225712070193E-9,null,0.96711293864118775,1.8502221635371957E-7]
[26,74,{"$f":"1*($A$4^A32)*($B$4^B32)","v":4.7060668898962627E-2},6.9957481650097247E+23,5.5186722301478026E-7,2.597124065848854E-8,null,0.96989915498690027,5.3525555326700258E-7]
[27,73,{"$f":"1*($A$4^A33)*($B$4^B33)","v":6.2747558531950159E-2},1.9173532007804425E+24,1.5125249815960639E-6,9.4907249813735851E-8,null,0.97269339831810231,1.4712230643897006E-6]
[28,72,{"$f":"1*($A$4^A34)*($B$4^B34)","v":8.3663411375933541E-2},4.9988137020347276E+24,3.9433687020183116E-6,3.2991567792393911E-7,null,0.97549569176023987,3.8467391798410324E-6]
[29,71,{"$f":"1*($A$4^A35)*($B$4^B35)","v":0.11155121516791137},1.241084781194829E+25,9.7904326394937404E-6,1.0921346579551088E-6,null,0.97830605850538266,9.578039566605572E-6]
[30,70,{"$f":"1*($A$4^A36)*($B$4^B36)","v":0.14873495355721517},2.9372339821610943E+25,2.3170690580135174E-5,3.4462915873250078E-6,null,0.98112452181241594,2.2733332715498572E-5]
[31,69,{"$f":"1*($A$4^A37)*($B$4^B37)","v":0.19831327140962021},6.6324638306863368E+25,5.2320914213208419E-5,1.0375931660763456E-5,null,0.98395110500723282,5.1481221355075055E-5]
[32,68,{"$f":"1*($A$4^A38)*($B$4^B38)","v":0.26441769521282688},1.4301250134917424E+26,1.1281697127223073E-4,2.9830803524694953E-5,null,0.98678583148292753,1.1132618880225375E-4]
[33,67,{"$f":"1*($A$4^A39)*($B$4^B39)","v":0.35255692695043578},2.9469242702254117E+26,2.3247133474277873E-4,8.1959379380980142E-5,null,0.98962872469998886,2.3006031053080032E-4]
[34,66,{"$f":"1*($A$4^A40)*($B$4^B40)","v":0.47007590260058102},5.8071742972088937E+26,4.5810527728723998E-4,2.1534425170688877E-4,null,0.99247980818649439,4.5466023773126074E-4]
[35,65,{"$f":"1*($A$4^A41)*($B$4^B41)","v":0.62676787013410795},1.0950671531879623E+27,8.6385566574165209E-4,5.4143697572017714E-4,null,0.9953391055383054,8.5982932565349332E-4]
[36,64,{"$f":"1*($A$4^A42)*($B$4^B42)","v":0.83569049351214397},1.9772045821449335E+27,1.5597393964779842E-3,1.3034593859930202E-3,null,0.99820664041926166,1.5569422228878555E-3]
[37,63,{"$f":"1*($A$4^A43)*($B$4^B43)","v":1.1142539913495253},3.4200295474939415E+27,2.6979276047186776E-3,3.0061766019298507E-3,null,1.0010824365613777,2.7008479401979752E-3]
[38,62,{"$f":"1*($A$4^A44)*($B$4^B44)","v":1.4856719884660337},5.670048986634683E+27,4.4728799762441158E-3,6.6452324884765006E-3,null,1.0039665177650394,4.4906217341307772E-3]
[39,61,{"$f":"1*($A$4^A45)*($B$4^B45)","v":1.9808959846213781},9.013924030034633E+27,7.1107322699265497E-3,1.4085621001215159E-2,null,1.0068589078992003,7.1595041276618469E-3]
[40,60,{"$f":"1*($A$4^A46)*($B$4^B46)","v":2.641194646161837},1.3746234145802817E+28,1.084386671163799E-2,2.8640762702470825E-2,null,1.0097596309015795,1.0949698848289502E-2]
[41,59,{"$f":"1*($A$4^A47)*($B$4^B47)","v":3.5215928615491161},2.0116440213369964E+28,1.586907323654339E-2,5.5884415029211328E-2,null,1.0126687107788601,1.6070113935705708E-2]
[42,58,{"$f":"1*($A$4^A48)*($B$4^B48)","v":4.6954571487321548},2.8258808871162569E+28,2.229226954657286E-2,0.10467239640391965,null,1.015586171606887,2.2639720685232727E-2]
[43,57,{"$f":"1*($A$4^A49)*($B$4^B49)","v":6.2606095316428707},3.8116532895986739E+28,3.0068642644214567E-2,0.188248030741933,null,1.0185120375308674,3.0625274485346507E-2]
[44,56,{"$f":"1*($A$4^A50)*($B$4^B50)","v":8.347479375523827},4.9378235797073715E+28,3.8952559789096133E-2,0.32515568946333873,null,1.0214463327655694,3.978794934840383E-2]
[45,55,{"$f":"1*($A$4^A51)*($B$4^B51)","v":11.129972500698438},6.1448471214136226E+28,4.8474296626430775E-2,0.53951758844287356,null,1.0243890815955232,4.9656540202138388E-2]
[46,54,{"$f":"1*($A$4^A52)*($B$4^B52)","v":14.839963334264581},7.347099819081501E+28,5.7958398140297636E-2,0.86010050331472543,null,1.0273403083752217,5.9542998618387251E-2]
[47,53,{"$f":"1*($A$4^A53)*($B$4^B53)","v":19.786617779019444},8.4413487283063988E+28,6.6590499990980212E-2,1.3176007710353232,null,1.0303000375293225,6.8608194639803263E-2]
[48,52,{"$f":"1*($A$4^A54)*($B$4^B54)","v":26.382157038692583},9.3206558875049932E+28,7.3527010406707408E-2,1.9398011351353386,null,1.0332682935528494,7.5973128572981163E-2]
[49,51,{"$f":"1*($A$4^A55)*($B$4^B55)","v":35.176209384923446},9.8913082887808022E+28,7.8028664105077195E-2,2.7447526265860556,null,1.0362451010113956,8.085682091734997E-2]
[50,50,{"$f":"1*($A$4^A56)*($B$4^B56)","v":46.90161251323125},1.0089134454556413E+29,7.9589237387178699E-2,3.7328635721570329,null,1.0392304845413265,8.2711561734152381E-2]
[51,49,{"$f":"1*($A$4^A57)*($B$4^B57)","v":62.535483350974999},9.8913082887808022E+28,7.8028664105077195E-2,4.8795602250418755,null,1.0422244688499844,8.1323383001987923E-2]
[52,48,{"$f":"1*($A$4^A58)*($B$4^B58)","v":83.380644467966675},9.3206558875049932E+28,7.3527010406707408E-2,6.1307295135141562,null,1.0452270787158924,7.6852422294115805E-2]
[53,47,{"$f":"1*($A$4^A59)*($B$4^B59)","v":111.17419262395553},8.4413487283063988E+28,6.6590499990980212E-2,7.4031450729227437,null,1.0482383389889598,6.9802715102989438E-2]
[54,46,{"$f":"1*($A$4^A60)*($B$4^B60)","v":148.2322568319407},7.347099819081501E+28,5.7958398140297636E-2,8.5913041587004741,null,1.0512582745906871,6.0929245627009382E-2]
[55,45,{"$f":"1*($A$4^A61)*($B$4^B61)","v":197.64300910925428},6.1448471214136226E+28,4.8474296626430775E-2,9.5806058497023514,null,1.0542869105143731,5.1105816429636998E-2]
[56,44,{"$f":"1*($A$4^A62)*($B$4^B62)","v":263.52401214567232},4.9378235797073715E+28,3.8952559789096133E-2,10.264934838966797,null,1.0573242718253208,4.1185486914738341E-2]
[57,43,{"$f":"1*($A$4^A63)*($B$4^B63)","v":351.36534952756313},3.8116532895986739E+28,3.0068642644214567E-2,10.565079132503842,null,1.0603703836610465,3.1883898136812708E-2]
[58,42,{"$f":"1*($A$4^A64)*($B$4^B64)","v":468.48713270341739},2.8258808871162569E+28,2.229226954657286E-2,10.44364144132563,null,1.0634252712314858,2.3706162788929633E-2]
[59,41,{"$f":"1*($A$4^A65)*($B$4^B65)","v":624.64951027122322},2.0116440213369964E+28,1.586907323654339E-2,9.9126088256650036,null,1.0664889598192033,1.6924191409335917E-2]
[60,40,{"$f":"1*($A$4^A66)*($B$4^B66)","v":832.86601369496418},1.3746234145802817E+28,1.084386671163799E-2,9.0314880411614524,null,1.0695614747796021,1.1598182072412963E-2]
[61,39,{"$f":"1*($A$4^A67)*($B$4^B67)","v":1110.4880182599522},9.013924030034633E+27,7.1107322699265497E-3,7.8963829868078257,null,1.0726428415411329,7.627276067452244E-3]
[62,38,{"$f":"1*($A$4^A68)*($B$4^B68)","v":1480.6506910132694},5.670048986634683E+27,4.4728799762441158E-3,6.6227728276452655,null,1.075733085605505,4.8116249783881609E-3]
[63,37,{"$f":"1*($A$4^A69)*($B$4^B69)","v":1974.200921351026},3.4200295474939415E+27,2.6979276047186776E-3,5.3262511629739802,null,1.0788322325478974,2.9106112610512522E-3]
[64,36,{"$f":"1*($A$4^A70)*($B$4^B70)","v":2632.2678951347007},1.9772045821449335E+27,1.5597393964779842E-3,4.1056519381257717,null,1.0819403080171697,1.6875449230519045E-3]
[65,{"$f":"$A$2-A71","v":35},{"$f":"1*($A$4^A71)*($B$4^B71)","v":3509.6905268462669},{"$f":"COMBIN($A$2,A71)","v":1.0950671531879623E+27},{"$f":"D71/$D$4","v":8.6385566574165209E-4},{"$f":"C71*E71","v":3.0318660466159515},null,{"$f":"C71^(1/$A$2)","v":1.0850573377360753},{"$f":"H71*E71","v":9.3733292885786197E-4}]
[66,34,{"$f":"1*($A$4^A72)*($B$4^B72)","v":4679.5873691283559},5.8071742972088937E+26,4.5810527728723998E-4,2.1437436693244112,null,1.0881833475014737,4.9850253414651961E-4]
[67,33,{"$f":"1*($A$4^A73)*($B$4^B73)","v":6239.4498255044746},2.9469242702254117E+26,2.3247133474277873E-4,1.4504932289956232,null,1.0913183631845444,2.5370023651881559E-4]
[68,32,{"$f":"1*($A$4^A74)*($B$4^B74)","v":8319.2664340059655},1.4301250134917424E+26,1.1281697127223073E-4,0.93855444229128437,null,1.0944624107310008,1.234739343499757E-4]
[69,31,{"$f":"1*($A$4^A75)*($B$4^B75)","v":11092.355245341285},6.6324638306863368E+25,5.2320914213208419E-5,0.58036216721393374,null,1.0976155161613048,5.7428247260162106E-5]
[70,30,{"$f":"1*($A$4^A76)*($B$4^B76)","v":14789.806993788381},2.9372339821610943E+25,2.3170690580135174E-5,0.34269004159298977,null,1.1007777055708821,2.5505779613294048E-5]
[71,29,{"$f":"1*($A$4^A77)*($B$4^B77)","v":19719.742658384508},1.241084781194829E+25,9.7904326394937404E-6,0.19306481216506474,null,1.1039490051303387,1.080813837216471E-5]
[72,28,{"$f":"1*($A$4^A78)*($B$4^B78)","v":26292.990211179342},4.9988137020347276E+24,3.9433687020183116E-6,0.10368295468123845,null,1.1071294410856769,4.3658195870602848E-6]
[73,27,{"$f":"1*($A$4^A79)*($B$4^B79)","v":35057.320281572458},1.9173532007804425E+24,1.5125249815960639E-6,5.3025072713692702E-2,null,1.110319039758513,1.6793852851765041E-6]
[74,26,{"$f":"1*($A$4^A80)*($B$4^B80)","v":46743.09370876327},6.9957481650097247E+23,5.5186722301478026E-7,2.5795981320174834E-2,null,1.1135178275462945,6.1451399126542448E-7]
[75,25,{"$f":"1*($A$4^A81)*($B$4^B81)","v":62324.124945017684},2.4251926972033706E+23,1.9131397064512376E-7,1.1923475810214138E-2,null,1.1167258309225194,2.1364525283576232E-7]
[76,24,{"$f":"1*($A$4^A82)*($B$4^B82)","v":83098.833260023559},7.9776075565900384E+22,6.2932227185896005E-8,5.2295946536026934E-3,null,1.1199430764369549,7.0480512121601742E-8]
[77,23,{"$f":"1*($A$4^A83)*($B$4^B83)","v":110798.4443466981},2.4865270306254648E+22,1.9615239642357184E-8,2.1733380378608589E-3,null,1.1231695907158565,2.2031240680899761E-8]
[78,22,{"$f":"1*($A$4^A84)*($B$4^B84)","v":147731.25912893077},7.3320668851776583E+21,5.7839809201822503E-9,8.5447478411623552E-4,null,1.1264054004621893,6.5151073446635496E-9]
[79,21,{"$f":"1*($A$4^A85)*($B$4^B85)","v":196975.01217190773},2.0418414110621326E+21,1.6107288638482216E-9,3.1727333756214655E-4,null,1.1296505324558488,1.819560718688148E-9]
[80,20,{"$f":"1*($A$4^A86)*($B$4^B86)","v":262633.34956254356},5.3598337040380979E+20,4.2281632676015815E-10,1.1104566814675126E-4,null,1.1329050135538823,4.7901073639901972E-10]
[81,19,{"$f":"1*($A$4^A87)*($B$4^B87)","v":350177.79941672471},1.3234157293921229E+20,1.0439909302719954E-10,3.6558244657366663E-5,null,1.1361688706907112,1.1861499962584781E-10]
[82,18,{"$f":"1*($A$4^A88)*($B$4^B88)","v":466903.73255563283},3.0664510802988204E+19,2.4190033750204764E-11,1.1294417048617336E-5,null,1.1394421308783538,2.756314360235261E-11]
[83,17,{"$f":"1*($A$4^A89)*($B$4^B89)","v":622538.31007417722},6.6501348729371996E+18,5.2460314157070568E-12,3.2658555321303147E-6,null,1.1427248212066492,5.9947703115583111E-12]
[84,16,{"$f":"1*($A$4^A90)*($B$4^B90)","v":830051.08009890304},1.3458606290468155E+18,1.061696834131191E-12,8.8126260390818101E-7,null,1.1460169688434814,1.2167225876817479E-12]
[85,15,{"$f":"1*($A$4^A91)*($B$4^B91)","v":1106734.7734652036},2.5333847134998864E+17,1.9984881583645935E-13,2.2117963392205303E-7,null,1.1493186010350038,2.2968996143566158E-13]
[86,14,{"$f":"1*($A$4^A92)*($B$4^B92)","v":1475646.3646202714},4.41869426773236E+16,3.4857351599382448E-14,5.1437124167919311E-8,null,1.1526297451058654,4.0177620289061719E-14]
[87,13,{"$f":"1*($A$4^A93)*($B$4^B93)","v":1967528.4861603619},7110542499799198,5.6092289930040699E-15,1.1036317829132109E-8,null,1.155950428459436,6.4839906577901448E-15]
[88,12,{"$f":"1*($A$4^A94)*($B$4^B94)","v":2623371.3148804824},1050421051106700,8.2863610123923787E-16,2.173820178465416E-9,null,1.1592806785780334,9.6062182173887967E-16]
[89,11,{"$f":"1*($A$4^A95)*($B$4^B95)","v":3497828.4198406432},141629804643600.03,1.1172621589742536E-16,3.9079913320726589E-10,null,1.1626205230231519,1.2989519156206226E-16]
[90,10,{"$f":"1*($A$4^A96)*($B$4^B96)","v":4663771.2264541909},17310309456440.006,1.3655426387463101E-17,6.3685784670813709E-11,null,1.1659699894356883,1.592181736073017E-17]
[91,9,{"$f":"1*($A$4^A97)*($B$4^B97)","v":6218361.6352722533},1902231808400,1.5005963063146259E-18,9.3312505012181201E-12,null,1.1693291055361721,1.7546909366337653E-18]
[92,8,{"$f":"1*($A$4^A98)*($B$4^B98)","v":8291148.8470296701},186087894300,1.4679746474816994E-19,1.2171196305936679E-12,null,1.1726978991249952,1.7214907850705443E-19]
[93,7,{"$f":"1*($A$4^A99)*($B$4^B99)","v":11054865.129372893},16007560799.999996,1.2627738903068378E-20,1.3959795046235611E-13,null,1.176076398082641,1.4851185685048697E-20]
[94,6,{"$f":"1*($A$4^A100)*($B$4^B100)","v":14739820.172497191},1192052400,9.4036353533487946E-22,1.3860789407609831E-14,null,1.179464630369915,1.1091255296171E-21]
[95,5,{"$f":"1*($A$4^A101)*($B$4^B101)","v":19653093.563329585},75287520,5.9391381179045019E-23,1.1672243711671434E-15,null,1.1828626240281777,7.0251844986102917E-23]
[96,4,{"$f":"1*($A$4^A102)*($B$4^B102)","v":26204124.751106109},3921225,3.0933011030752613E-24,8.1057247997718286E-17,null,1.1862704071795749,3.6694915590741186E-24]
[97,3,{"$f":"1*($A$4^A103)*($B$4^B103)","v":34938833.001474805},161700,1.2755880837423759E-25,4.4567559036546126E-18,null,1.1896880080272718,1.517551846410792E-25]
[98,2,{"$f":"1*($A$4^A104)*($B$4^B104)","v":46585110.668633074},4950,3.9048614808440077E-27,1.8190840423080053E-19,null,1.1931154548556857,4.6589505818656447E-27]
[99,1,{"$f":"1*($A$4^A105)*($B$4^B105)","v":62113480.891510755},100,7.8886090522101158E-29,4.8998896762505177E-21,null,1.1965527760307202,9.4391370604430822E-29]
[100,0,{"$f":"1*($A$4^A106)*($B$4^B106)","v":82817974.52201435},1,7.8886090522101163E-31,6.5331862350006921E-23,null,1.2,9.4663308626521396E-31]

{"sheet":"10","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["время\n(лет) (N)",{"$nulls":4},"Доходность\n\nматожидания\nфинансового\nрезультата\nчерез N лет",null,null,"Среднее значение\nдоходности\nвсех совершенных\nитераций"]
[10,null,null,"корень степени N",null,{"$f":"F4^(1/$A$2)","v":1.05},null,{"$f":"H3^(1/$A$2)","v":1.0432372016287039}]
[null,null,"произведение",{"$nulls":4},{"$f":"PRODUCT(H6:H16)","v":1.5269705292030398}]
[1.2,0.9,"сумма",{"$f":"SUM(D6:D16)","v":1024},null,{"$f":"SUM(F6:F16)","v":1.6288946267774416},null,null,{"$f":"SUM(I6:I16)","v":1.0403061003231442}]
["Число\nслучаев\nприроста\nна 20%","Число\nслучаев\nприроста\nна -10%","Результат\nчерез\nN лет ( R)","Случаев рез-та через 100 лет","Вероятность\nтакого\nисхода (P)","R*P",null,"Средняя\nдоходность\nза N лет\nв ЭТОМ\nисходе\n(i)","P*i"]
[0,{"$f":"$A$2-A6","v":10},{"$f":"1*($A$4^A6)*($B$4^B6)","v":0.34867844010000015},{"$f":"COMBIN($A$2,A6)","v":1},{"$f":"D6/$D$4","v":9.765625E-4},{"$f":"C6*E6","v":3.405062891601564E-4},null,{"$f":"C6^(1/$A$2)","v":0.9},{"$f":"H6*E6","v":8.7890625000000002E-4}]
[1,{"$f":"$A$2-A7","v":9},{"$f":"1*($A$4^A7)*($B$4^B7)","v":0.46490458680000013},{"$f":"COMBIN($A$2,A7)","v":10},{"$f":"D7/$D$4","v":9.765625E-3},{"$f":"C7*E7","v":4.5400838554687517E-3},null,{"$f":"C7^(1/$A$2)","v":0.92626740806828456},{"$f":"H7*E7","v":9.0455801569168416E-3}]
[2,8,{"$f":"1*($A$4^A8)*($B$4^B8)","v":0.61987278240000021},45,4.39453125E-2,2.724050313281251E-2,null,0.95330145694393109,4.1893130432106344E-2]
[3,7,{"$f":"1*($A$4^A9)*($B$4^B9)","v":0.82649704320000028},120,0.1171875,9.6855122250000036E-2,null,0.98112452181241594,0.11497552989989249]
[4,6,{"$f":"1*($A$4^A10)*($B$4^B10)","v":1.1019960576000003},209.99999999999997,0.20507812499999997,0.22599528525000004,null,1.0097596309015795,0.20707961180598797]
[5,5,{"$f":"1*($A$4^A11)*($B$4^B11)","v":1.4693280768000003},252,0.24609375,0.3615924564000001,null,1.0392304845413265,0.25574812705509209]
[6,4,{"$f":"1*($A$4^A12)*($B$4^B12)","v":1.9591041024000002},209.99999999999997,0.20507812499999997,0.401769396,null,1.0695614747796021,0.21934366182003556]
[7,3,{"$f":"1*($A$4^A13)*($B$4^B13)","v":2.6121388032000001},120,0.1171875,0.30611001600000004,null,1.1007777055708821,0.12899738737158775]
[8,2,{"$f":"1*($A$4^A14)*($B$4^B14)","v":3.4828517375999999},45,4.39453125E-2,0.15305500799999999,null,1.1329050135538823,4.9785864853442094E-2]
[9,1,{"$f":"1*($A$4^A15)*($B$4^B15)","v":4.6438023167999996},10,9.765625E-3,4.5349631999999994E-2,null,1.1659699894356883,1.1386425678082894E-2]
[10,0,{"$f":"1*($A$4^A16)*($B$4^B16)","v":6.1917364223999991},1,9.765625E-4,6.0466175999999991E-3,null,1.2,1.171875E-3]