{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"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":230,"n_cols":2,"rows_kept":230,"cut":false,"hidden":false,"merged":[]}
["Analytic vs. Monte Carlo Down-and-Out Barrier Call (K>=B)"]
[]
["Options-Parameter:"]
["Ausuebungspreis oder Strike K",100]
["Barriere  B",80]
["Laufzeit oder Maturity T",1]
[]
["Markt-Parameter:"]
["aktueller Preis S0 des Basiswerts",100]
["jaehrliche Volatilitaet",0.2]
["jaehrlicher Zinssatz",0]
[]
[]
["Black-Scholes Preis Down-and-Out Barrier-Call",{"$f":"BarrierCall(B9,B4,B5,B6,B10,B11)","v":7.8765866857238658}]
["Monte Carlo Preis",7.8622880660887269]
[]
[]
["Monte Carlo Parameter:"]
["Anzahl Pfade ",10000]
["Anzahl Zeitschritte pro Jahr",1000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["S0","V0"]
[1,{"$f":"IF(A31>=$B$5,BarrierCall(A31,$B$4,$B$5,$B$6,$B$10,$B$11),0)","v":0}]
[2,{"$f":"IF(A32>=$B$5,BarrierCall(A32,$B$4,$B$5,$B$6,$B$10,$B$11),0)","v":0}]
[3,0]
[4,0]
[5,0]
[6,0]
[7,0]
[8,0]
[9,0]
[10,0]
[11,0]
[12,0]
[13,0]
[14,0]
[15,0]
[16,0]
[17,0]
[18,0]
[19,0]
[20,0]
[21,0]
[22,0]
[23,0]
[24,0]
[25,0]
[26,0]
[27,0]
[28,0]
[29,0]
[30,0]
[31,0]
[32,0]
[33,0]
[34,0]
[35,0]
[36,0]
[37,0]
[38,0]
[39,0]
[40,0]
[41,0]
[42,0]
[43,0]
[44,0]
[45,0]
[46,0]
[47,0]
[48,0]
[49,0]
[50,0]
[51,0]
[52,0]
[53,0]
[54,0]
[55,0]
[56,0]
[57,0]
[58,0]
[59,0]
[60,0]
[61,0]
[62,0]
[63,0]
[64,0]
[65,0]
[66,{"$f":"IF(A96>=$B$5,BarrierCall(A96,$B$4,$B$5,$B$6,$B$10,$B$11),0)","v":0}]
[67,0]
[68,0]
[69,0]
[70,0]
[71,0]
[72,0]
[73,0]
[74,0]
[75,0]
[76,0]
[77,0]
[78,0]
[79,0]
[80,0]
[81,0.29528129780143619]
[82,0.59257607575948634]
[83,0.89379532003944018]
[84,1.200732895308638]
[85,1.5150610995669571]
[86,1.8383276402770747]
[87,2.1719539146096536]
[88,2.5172344771360295]
[89,2.875337580177638]
[90,3.2473066749158259]
[91,3.6340627650105701]
[92,4.0364075086671836]
[93,4.4550269696741358]
[94,4.8904959227982454]
[95,5.3432826239850826]
[96,5.8137539610118525]
[97,6.3021809055331648]
[98,6.8087441928125578]
[99,7.3335401608151587]
[100,7.8765866857238658]
[101,8.4378291563071386]
[102,9.0171464348854666]
[103,9.6143567578893663]
[104,10.229223534147774]
[105,10.861461004063649]
[106,11.510739727697297]
[107,12.17669187446093]
[108,12.858916291605661]
[109,13.556983332931935]
[110,14.270439433158272]
[111,14.998811417122702]
[112,15.741610536456101]
[113,16.498336229546009]
[114,17.268479603499426]
[115,18.051526639411019]
[116,18.846961124551953]
[117,19.654267317118741]
[118,20.472932350929288]
[119,21.302448388935545]
[120,22.142314535651366]
[121,22.992038519585538]
[122,23.85113815753823]
[123,24.719142613183305]
[124,25.595593462734158]
[125,26.480045580697595]
[126,27.372067858774297]
[127,28.27124377088532]
[128,29.177171797107359]
[129,30.089465719003652]
[130,{"$f":"IF(A160>=$B$5,BarrierCall(A160,$B$4,$B$5,$B$6,$B$10,$B$11),0)","v":31.007754798455434}]
[131,31.931683851648899]
[132,32.860913229365195]
[133,33.795118714171267]
[134,34.733991344526459]
[135,35.677237175217421]
[136,36.624576982916658]
[137,37.575745925041232]
[138,38.530493159470616]
[139,39.488581432075073]
[140,40.449786638412327]
[141,41.413897365375213]
[142,42.380714418019963]
[143,43.350050336276304]
[144,44.321728905738865]
[145,45.29558466626596]
[146,46.27146242166733]
[147,47.249216753347717]
[148,48.228711540387742]
[149,49.209819488188039]
[150,50.19242166747528]
[151,51.176407065169514]
[152,52.161672148340898]
[153,53.148120442236305]
[154,54.135662123136306]
[155,55.124213626603037]
[156,56.113697271504023]
[157,57.104040900040552]
[158,58.095177533871592]
[159,59.08704504630591]
[160,60.079585850430625]
[161,61.072746602956379]
[162,62.066477923485238]
[163,63.060734128843158]
[164,64.055472982069588]
[165,65.050655455613196]
[166,66.046245508252142]
[167,67.042209875231364]
[168,68.038517871092651]
[169,69.035141204661869]
[170,70.032053805651529]
[171,71.029231662336258]
[172,72.02665266976075]
[173,73.024296487947197]
[174,74.022144409577052]
[175,75.020179236635087]
[176,76.018385165515753]
[177,77.016747680108168]
[178,78.01525345239186]
[179,79.013890250093098]
[180,80.01264685096946]
[181,81.011512963308377]
[182,82.010479152245367]
[183,83.009536771524211]
[184,84.008677900342718]
[185,85.007895284943459]
[186,86.007182284629025]
[187,87.006532821897693]
[188,88.005941336413656]
[189,89.005402742541634]
[190,90.00491239019243]
[191,91.004466028741476]
[192,92.004059773796655]
[193,93.003690076606802]
[194,{"$f":"IF(A224>=$B$5,BarrierCall(A224,$B$4,$B$5,$B$6,$B$10,$B$11),0)","v":94.00335369591474}]
[195,95.003047672072441]
[196,96.002769303247632]
[197,97.00251612356314]
[198,98.002285883020463]
[199,99.002076529070209]
[200,100.00188618970147]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}