{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["MONTECARLO"],"not_rendered":{"charts":0,"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":"MONTECARLO","index":0,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Investment",450000]
["r",{"$f":"C2+RAND()*(D2-C2)","v":3.1849040810496165E-2},2.5000000000000001E-2,3.5000000000000003E-2]
["Years",15]
["CF (year 1-7)",45000]
["CF year 8-15","Normal distribution"]
["Mean",35000]
["Std deviation ",45000]
[]
["Period",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["Cash flows",{"$f":"-B1","v":-450000},{"$f":"$B$4","v":45000},{"$f":"$B$4","v":45000},45000,45000,45000,45000,45000,{"$f":"_xlfn.NORM.INV(RAND(),$B$6,$B$7)","v":37078.002400115023},{"$f":"_xlfn.NORM.INV(RAND(),$B$6,$B$7)","v":7821.6096124079995},21450.432618293744,105120.10356862249,48865.63558581056,32997.733116996824,25926.809985066473,20851.915898977888]
["DCF",{"$f":"B10/(1+$B$2)^B9","v":-450000},{"$f":"C10/(1+$B$2)^C9","v":43611.030509514676},42264.932935596,40960.383994152638,39696.101245565049,38470.841833980463,37283.401265520784,36132.612224202334,28852.736523015101,5898.6231748733935,15677.41329846078,74457.417228829116,33543.592574004681,21951.993395979604,16715.631086003534,13028.772259145944]
["NPV",{"$f":"SUM(B11:Q11)","v":38545.483548844088}]
[null,{"$f":"_xludf.npv($B$10:$Q$10,$B$9:$Q$9,B2)","v":38545.483548844131}]