{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Initial stock price",12]
["Mean return",0.12]
["Sigma",0.35]
["Delta t",{"$f":"1/12","v":8.3333333333333329E-2},{"$f":"getformula(B4)","v":"<--  =1/12"}]
[]
["Month","Random Number","Stock Price"]
[0,null,{"$f":"B1","v":12},{"$f":"getformula(C7)","v":"<--  =B1"}]
[1,{"$f":"_xlfn.NORM.S.INV(RAND())","v":-0.79713835851848347},{"$f":"C7*EXP($B$2*$B$4+$B$3*B8*SQRT($B$4))","v":11.18268658643945},{"$f":"getformula(C8)","v":"<--  =C7*EXP($B$2*$B$4+$B$3*B8*SQRT($B$4))"}]
[2,{"$f":"_xlfn.NORM.S.INV(RAND())","v":0.75153749268463121},{"$f":"C8*EXP($B$2*$B$4+$B$3*B9*SQRT($B$4))","v":12.186140814100517}]
[3,0.32853233947506955,12.724038481673487]
[4,0.66101879244664596,13.739568605584051]
[5,0.66128535750762929,14.836549736725166]
[6,-1.6968127635947707,12.624685130130334]
[7,0.46277930379426352,13.361955696934128]
[8,1.1959331754073805,15.229650241298826]
[9,-1.49756277600234,13.222712619457338]
[10,1.1906449453556891,15.062893876759251]
[11,1.7836667500649002,18.218716487626796]
[12,-0.2608352866215472,17.92319371892588]

{"sheet":"Sheet2","index":1,"n_rows":257,"n_cols":6,"rows_kept":257,"cut":false,"hidden":false,"merged":[]}
["Initial stock price",12]
["Mean return",0.12]
["Sigma",0.35]
["Delta t",{"$f":"1/250","v":4.0000000000000001E-3},{"$f":"getformula(B4)","v":"<--  =1/250"},null,{"$f":"getformula(B8)","v":"<--  =B7*EXP($B$2*$B$4+$B$3*SQRT($B$4)*NORM.S.INV(RAND()))"}]
[]
["Day","Stock Price","Return"]
[0,{"$f":"B1","v":12},null,null,"Annual mean return",{"$f":"AVERAGE(C8:C257)*250","v":0.20193822570159478}]
[1,{"$f":"B7*EXP($B$2*$B$4+$B$3*SQRT($B$4)*_xlfn.NORM.S.INV(RAND()))","v":11.993582575774521},{"$f":"LN(B8/B7)","v":-5.3492840081218232E-4},null,"Annual Sigma",{"$f":"_xlfn.STDEV.S(C8:C257)*SQRT(250)","v":0.33369736656376087}]
[2,{"$f":"B8*EXP($B$2*$B$4+$B$3*SQRT($B$4)*_xlfn.NORM.S.INV(RAND()))","v":12.056981544078919},{"$f":"LN(B9/B8)","v":5.2721520243224681E-3}]
[3,11.673741818014273,-3.2301842857489153E-2]
[4,12.098868765954043,3.5769927261151239E-2]
[5,12.057684832043957,-3.4097557538464358E-3]
[6,12.226385272474667,1.3894141601835433E-2]
[7,12.782948383989156,4.4515781650935893E-2]
[8,12.505625812154149,-2.1933517282372115E-2]
[9,12.361673503023137,-1.1577768482764766E-2]
[10,12.015655818061013,-2.8390388574151888E-2]
[11,12.142723289881571,1.0519633213214925E-2]
[12,12.862246482753196,5.7566306982233688E-2]
[13,13.036468590704597,1.3454315055352285E-2]
[14,13.374120076018862,2.5570795683418211E-2]
[15,13.6062798760841,1.7209939851089703E-2]
[16,13.57165883585947,-2.5477325060226453E-3]
[17,13.219717849271674,-2.6274217776038989E-2]
[18,13.030832312830391,-1.4391225725121061E-2]
[19,12.781782402289522,-1.9297358430545593E-2]
[20,12.720643722661499,-4.7947435634345063E-3]
[21,12.973066255176349,1.9649217976082534E-2]
[22,12.716829015302567,-1.9949146151088327E-2]
[23,12.390291032313247,-2.6013050927948145E-2]
[24,12.431387897949335,3.3113717492223721E-3]
[25,12.672819132855736,1.9234917743711173E-2]
[26,12.786226549128822,8.9090665689610885E-3]
[27,13.378853454527738,4.5306819318556166E-2]
[28,13.552163798564381,1.2870864471129083E-2]
[29,13.748389009841404,1.4375429820263278E-2]
[30,13.88606442152042,9.9641233069237573E-3]
[31,14.007737257725484,8.7240605856033909E-3]
[32,14.322505691228214,2.2222286442911687E-2]
[33,14.121640724715281,-1.412370071449838E-2]
[34,14.652206969824126,3.688254657263914E-2]
[35,14.240791093157794,-2.8480511785887477E-2]
[36,13.882610542968491,-2.5473441877013933E-2]
[37,13.792917580526996,-6.4817752396010659E-3]
[38,13.490183904250829,-2.2192938856833235E-2]
[39,13.583922958403601,6.9246552952083257E-3]
[40,13.970797947187217,2.8082332205079094E-2]
[41,13.932219464661985,-2.7651853229731715E-3]
[42,13.282924264588221,-4.7724784485014861E-2]
[43,12.69082852347416,-4.5599751381486961E-2]
[44,12.407792014697653,-2.2554905533084833E-2]
[45,12.15435808187028,-2.0636868201222642E-2]
[46,11.961341930151793,-1.6007851592518239E-2]
[47,12.287766783346346,2.6924253259272904E-2]
[48,12.556627631300213,2.1644427289282311E-2]
[49,12.881452320940339,2.5539847861873449E-2]
[50,12.70312837790433,-1.3940180057111975E-2]
[51,13.013402147288572,2.4131468721035467E-2]
[52,13.037683509910131,1.8641349518057444E-3]
[53,12.685025743983706,-2.7421673240689105E-2]
[54,12.855750262533348,1.3368979963068114E-2]
[55,12.531483275243394,-2.5547062680265274E-2]
[56,12.347792458802942,-1.4766840992802437E-2]
[57,12.578520405369346,1.8513330698078291E-2]
[58,12.523074055823745,-4.4177623703086054E-3]
[59,12.235293778315654,-2.3248159238028827E-2]
[60,12.258516251939836,1.8961917769113365E-3]
[61,12.944885211560525,5.4479846080124072E-2]
[62,12.615463740735633,-2.577740329384515E-2]
[63,12.288210520018957,-2.6283034052911408E-2]
[64,12.250797670727998,-3.0492575729850497E-3]
[65,12.254121855622062,2.7130755609127138E-4]
[66,{"$f":"B72*EXP($B$2*$B$4+$B$3*SQRT($B$4)*_xlfn.NORM.S.INV(RAND()))","v":12.170323584439306},{"$f":"LN(B73/B72)","v":-6.8618630619687393E-3}]
[67,12.046555569263129,-1.0221721141899207E-2]
[68,11.898035474697188,-1.2405473871438352E-2]
[69,12.140451584729041,2.0169682693274155E-2]
[70,12.034599335278964,-8.7572039679576306E-3]
[71,12.108086146780858,6.0877269441048047E-3]
[72,12.085966756628123,-1.8284986317824911E-3]
[73,11.906701097213482,-1.4943648327734739E-2]
[74,11.948360817529792,3.4927398483871564E-3]
[75,11.86583222715079,-6.9310701069329106E-3]
[76,11.970131044520542,8.7514384753107719E-3]
[77,12.078321680489514,8.9977818641391576E-3]
[78,12.288242077843273,1.7230627436413671E-2]
[79,12.408458204592799,9.7354767944962256E-3]
[80,12.750062098926852,2.7157788745559273E-2]
[81,12.396189326345677,-2.814702910725711E-2]
[82,12.678196307849667,2.2494578886619151E-2]
[83,12.508932206364488,-1.3440726246821999E-2]
[84,12.866233500429303,2.8163355837046235E-2]
[85,12.911876492004927,3.5412246504473556E-3]
[86,12.995508935217561,6.4562851358300902E-3]
[87,12.924779636857789,-5.457460376059182E-3]
[88,12.551980246466796,-2.9267929182867421E-2]
[89,12.555809278465752,3.0500749775988218E-4]
[90,13.094294504701931,4.1993152151071848E-2]
[91,13.01848629407688,-5.8062313762500904E-3]
[92,13.188670472476829,1.29877935383001E-2]
[93,12.82374202868661,-2.8059864690356793E-2]
[94,12.894928884397851,5.5358255290343557E-3]
[95,13.4539084580811,4.2435531170018623E-2]
[96,13.318201666150371,-1.0138009564361122E-2]
[97,13.258819471652503,-4.4686944415624598E-3]
[98,13.372922596630975,8.56900933339819E-3]
[99,13.101611383356705,-2.0496731835080099E-2]
[100,12.9795989737233,-9.3564139138766541E-3]
[101,13.505914481796683,3.9748884173365868E-2]
[102,13.447997619894469,-4.2974801445778638E-3]
[103,13.04199759891868,-3.0655484253234857E-2]
[104,13.462275004925868,3.171659474959395E-2]
[105,13.161102126389039,-2.2625659020481314E-2]
[106,13.013398380645953,-1.1286199219297926E-2]
[107,12.772147160991812,-1.8712674433681822E-2]
[108,13.47489689109115,5.3561667955348884E-2]
[109,13.378000749719613,-7.2168421612615599E-3]
[110,13.246333906706436,-9.8907948762355855E-3]
[111,13.19920620081165,-3.5641363792943245E-3]
[112,13.01254545546251,-1.4242764331753097E-2]
[113,13.376036597194927,2.7550865222748105E-2]
[114,13.518574500076166,1.0599836298200049E-2]
[115,14.009248325579803,3.5653077531792692E-2]
[116,14.072667095467853,4.5167059833629182E-3]
[117,14.243674505507258,1.2078501627761126E-2]
[118,14.294683200031136,3.5747501218887628E-3]
[119,14.922665192420533,4.2993547086632576E-2]
[120,14.724084372075405,-1.3396665280723863E-2]
[121,15.191526784138926,3.1253278266358736E-2]
[122,15.176487288859557,-9.9048271465939177E-4]
[123,14.518676378200457,-4.4311494578206642E-2]
[124,14.538611975625249,1.3721583590296032E-3]
[125,14.347184770506068,-1.3254265355163596E-2]
[126,14.124498847508832,-1.5642943138488519E-2]
[127,14.235242798664061,7.8099804607501978E-3]
[128,13.815104173599831,-2.9958278079236844E-2]
[129,13.574979640520423,-1.7534132920837164E-2]
[130,{"$f":"B136*EXP($B$2*$B$4+$B$3*SQRT($B$4)*_xlfn.NORM.S.INV(RAND()))","v":13.122818138814099},{"$f":"LN(B137/B136)","v":-3.3875808425330001E-2}]
[131,12.810067562027868,-2.4121167558321513E-2]
[132,13.089304536385374,2.1564059070346628E-2]
[133,13.253297788112045,1.2450962005100924E-2]
[134,12.980957954796562,-2.0762900207870198E-2]
[135,13.123764949995726,1.0941194076850295E-2]
[136,13.235872901615602,8.506082534200779E-3]
[137,13.075880497644199,-1.2161437776701364E-2]
[138,13.254553247148523,1.3571784935664185E-2]
[139,12.788484215906063,-3.5796039348601094E-2]
[140,12.999090872540449,1.6334326787902732E-2]
[141,12.753595721724032,-1.9066172899488618E-2]
[142,12.678872667051232,-5.8762105624254211E-3]
[143,12.598221761905048,-6.3813646825810052E-3]
[144,12.624382246242309,2.0743689834355492E-3]
[145,12.653062399745288,2.2692298380463244E-3]
[146,12.597968852623556,-4.3636740213698066E-3]
[147,12.741594034679965,1.1336163988409016E-2]
[148,12.853737164070136,8.7628361685001717E-3]
[149,12.748066036610311,-8.2550222509096809E-3]
[150,12.77544619811348,2.1454862288699077E-3]
[151,12.866801463991511,7.1254012987203982E-3]
[152,13.313617270264146,3.4136902129016974E-2]
[153,13.314999244006867,1.0379613550107615E-4]
[154,13.080254926163198,-1.7787326881381686E-2]
[155,13.128095034262572,3.6507572057092341E-3]
[156,13.077078967568657,-3.8935922456296828E-3]
[157,13.577701532272783,3.7567853355746479E-2]
[158,13.484087144979933,-6.9185937284890415E-3]
[159,14.243806210933222,5.4811900167526795E-2]
[160,14.210239833034711,-2.3593406306585104E-3]
[161,14.731104043209024,3.5998359951519239E-2]
[162,14.540513568990914,-1.3022387087542399E-2]
[163,14.555350442111202,1.0198614071493968E-3]
[164,14.337399227513112,-1.5087200166925177E-2]
[165,14.426028027570959,6.1626230953976116E-3]
[166,13.953112755505057,-3.3331456959310446E-2]
[167,14.129859309462496,1.2587619807933574E-2]
[168,13.959506075030141,-1.2129524515929255E-2]
[169,14.520095027002897,3.937283867120666E-2]
[170,14.441159762163027,-5.4511077558670627E-3]
[171,14.44775571777868,4.5664266869767861E-4]
[172,14.624259046987666,1.2142639533155978E-2]
[173,14.525715506099003,-6.7611665392972222E-3]
[174,14.148668932377012,-2.6300010560063366E-2]
[175,14.017383167988427,-9.3223370256093705E-3]
[176,13.76291689833811,-1.8320420325040949E-2]
[177,13.955629738470178,1.390519840782259E-2]
[178,13.916706285212161,-2.7929828721660354E-3]
[179,13.645627310636518,-1.9670882699391788E-2]
[180,13.021927338585044,-4.6784471864510374E-2]
[181,13.016111261954961,-4.4673693099837961E-4]
[182,13.234153061024307,1.6612923293188548E-2]
[183,13.368826348079889,1.0124763504005449E-2]
[184,13.469155975406249,7.4767241066930551E-3]
[185,13.737680010744224,1.9740094371462066E-2]
[186,13.418012601851839,-2.3544394931362463E-2]
[187,13.763036579492248,2.5388461492349055E-2]
[188,14.233624660276059,3.3620609484359791E-2]
[189,14.171312203386732,-4.3874455448556105E-3]
[190,14.476407004299645,2.1300567357558635E-2]
[191,14.508806660713198,2.2355998670360662E-3]
[192,14.147948867822386,-2.5186163727408197E-2]
[193,13.842493114619131,-2.1826584938327113E-2]
[194,{"$f":"B200*EXP($B$2*$B$4+$B$3*SQRT($B$4)*_xlfn.NORM.S.INV(RAND()))","v":13.49515513950297},{"$f":"LN(B201/B200)","v":-2.5412329829365438E-2}]
[195,13.496893211055587,1.2878396870417524E-4]
[196,13.220711747148107,-2.067485480638253E-2]
[197,13.273086078298904,3.9537102020159344E-3]
[198,13.623426113906767,2.6052437460269542E-2]
[199,13.488047972963638,-9.9868613337746256E-3]
[200,13.269598290541094,-1.6328382083075396E-2]
[201,12.722117899613073,-4.2133530290444046E-2]
[202,13.022143661373779,2.3309221364795657E-2]
[203,12.831911303722507,-1.4716127974954958E-2]
[204,12.289601740441732,-4.3181621102540452E-2]
[205,12.311204445889677,1.7562604117140313E-3]
[206,12.362782021556802,4.1807310594169323E-3]
[207,12.796601643777532,3.4489129742762692E-2]
[208,13.102880691737541,2.3652467070017547E-2]
[209,12.969428461527496,-1.0237174996933321E-2]
[210,12.90649068300679,-4.8645926186254998E-3]
[211,12.980536346917638,5.7206928985726012E-3]
[212,12.894638020956052,-6.6394637803049413E-3]
[213,12.606806177222508,-2.2574726755899034E-2]
[214,12.494231338463635,-8.9697960473483964E-3]
[215,12.374112196507591,-9.6604806798745845E-3]
[216,12.300164128168737,-5.9939581419385423E-3]
[217,12.09449212730418,-1.6862453163959353E-2]
[218,11.724635361625557,-3.1057938251889811E-2]
[219,11.608230116731086,-9.9778752641342134E-3]
[220,11.540435698857905,-5.8573234620719269E-3]
[221,11.437619570255052,-8.9491311239008053E-3]
[222,11.405460327065276,-2.8156679905540377E-3]
[223,11.261643047802936,-1.2689685732158737E-2]
[224,11.21995987805168,-3.7082068972979511E-3]
[225,11.62741616389591,3.5671447775880646E-2]
[226,11.730892866919131,8.8600060726486286E-3]
[227,12.183235484053244,3.7835088085304155E-2]
[228,12.42773043070409,1.9869434723949281E-2]
[229,12.482518484120234,4.398843379556934E-3]
[230,13.066304092755797,4.5707565545667732E-2]
[231,12.539162525388917,-4.117996102459151E-2]
[232,12.563365083081273,1.9282970678706937E-3]
[233,12.518713979497639,-3.5604026795711826E-3]
[234,12.874408662670143,2.8016873278378096E-2]
[235,13.034633738834509,1.2368432322099608E-2]
[236,12.966504382767486,-5.2405022939582728E-3]
[237,13.086070200546139,9.1788745764156947E-3]
[238,13.252424374219062,1.263218634755264E-2]
[239,13.223913319094823,-2.1537016542876883E-3]
[240,13.255898583962654,2.4158238390041397E-3]
[241,13.52449803594396,2.0060080731535427E-2]
[242,13.568358537336215,3.2377936664259479E-3]
[243,13.272834375984118,-2.2021085615945502E-2]
[244,13.353667623646027,6.0716571774612725E-3]
[245,13.507352072753189,1.144305970810849E-2]
[246,13.67830700659967,1.257701252194799E-2]
[247,13.923844232970788,1.7791635232726206E-2]
[248,14.125990930436172,1.4413645997851584E-2]
[249,14.549779385425067,2.955940204984359E-2]
[250,14.685268897132749,9.2690445007870461E-3]

{"sheet":"Sheet3","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,2,3,4]]}
["Initial stock price",20]
["Mean return",0.12]
["Delta t",{"$f":"1/12","v":8.3333333333333329E-2}]
[null,null,"Stock price when sigma = "]
["Month","Random number",0.2,0.4,0.8]
[0,null,{"$f":"$B$1","v":20},{"$f":"$B$1","v":20},20]
[1,{"$f":"_xlfn.NORM.S.INV(RAND())","v":-1.1568039910989958},{"$f":"C6*EXP($B$2*$B$3+C$5*$B7*SQRT($B$3))","v":18.895884820405104},{"$f":"D6*EXP($B$2*$B$3+D$5*$B7*SQRT($B$3))","v":17.675085593855584},15.465006636847971,{"$f":"getformula(E7)","v":"<--  =E6*EXP($B$2*$B$3+E$5*$B7*SQRT($B$3))"}]
[2,{"$f":"_xlfn.NORM.S.INV(RAND())","v":-0.40164482376522964},{"$f":"C7*EXP($B$2*$B$3+C$5*$B8*SQRT($B$3))","v":18.6483037325665},17.043656896830456,14.236711373524464]
[3,-0.97397555999758556,17.805772172790608,15.383770570299911,11.483301259864277]
[4,-0.58436845743000609,17.388066810984014,14.5244877801081,10.134442806772601]
[5,0.5301772084114591,18.108726531193369,15.596641899124965,11.569577027661923]
[6,-0.65776006437308376,17.609141240221398,14.601204687619026,10.038982884106277]
[7,1.4888034514603548,19.3825710581891,17.514274827554978,14.300581948773816]
[8,-0.84227215099762942,18.648125989300304,16.050805612366137,11.891047557638975]
[9,1.5144745203435535,20.556637574038341,19.310239449212567,17.039577384473915]
[10,-0.50364240892521184,20.168179237267012,18.402377727002701,15.321046747997434]
[11,-0.65201825572077077,19.618280016953197,17.239293730162284,13.311792831003315]
[12,-0.57141980958178307,19.172382794381381,16.300722325716134,11.783338816773353]