{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Menu and documents","Certificate Builder","Historical volatility","Monthly volatility","Implied volatility","Change in option price","Moneyness","Replication method","Binomial model (one period)","Binomial (multi period)","Black-Scholes (excl. dividends)","Black-Scholes (incl. dividends)","Black-Scholes (incl. Greeks)","Put-call parity","Long call","Short call","Long put","Short put","Black 76","Garman-Kohlhagen"," Index futures","Interest rate futures","Currency futures","Commodity futures","Futures on indiv. securities","Swap Valuation","Zero Rates","Random Walk","Random NO","Disclaimer and Help"],"not_rendered":{"charts":15,"images":52,"macros":1,"external_links":0,"defined_names":1,"comments":20,"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":"Menu and documents","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Certificate Builder","index":1,"n_rows":115,"n_cols":11,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Certificate Builder"]
[]
[]
[]
[null,"bonus certificate"]
[]
[]
[null,null,"zero strike call","down and out put",null,null,"Underlying","zero","down and out put","Profit/Loss"]
[null,null,"long","long",null,null,null,"long","long"]
[]
[null,"Underlying",100,100,null,null,50,{"$f":"Payoff_EoT($G13,C$14,C$19,C$21,11,\"long\")","v":-50},{"$f":"Payoff_EoT($G13,D$14,D$19,D$21,6,\"long\")","v":-0.23972064225735767},{"$f":"H13+I13","v":-50.23972064225736}]
[null,"Strike",null,90,null,null,60,{"$f":"Payoff_EoT($G14,C$14,C$19,C$21,11,\"long\")","v":-40},{"$f":"Payoff_EoT($G14,D$14,D$19,D$21,6,\"long\")","v":-0.23972064225735767},{"$f":"H14+I14","v":-40.23972064225736}]
[null,"Interest",null,0.01,null,null,70,-30,-0.23972064225735767,-30.239720642257357]
[null,"Dividend",null,0,null,null,80,-20,9.7602793577426432,-10.239720642257357]
[null,"Vola",null,0.2,null,null,90,-10,-0.23972064225735767,-10.239720642257357]
[null,"Maturity",null,1.2,null,null,100,0,-0.23972064225735767,-0.23972064225735767]
[null,"Barrier",null,80,null,null,110,10,-0.23972064225735767,9.7602793577426432]
[null,null,null,null,null,null,120,20,-0.23972064225735767,19.760279357742643]
[null,"Theoretical Price",{"$f":"C13","v":100},{"$f":"Barrier_Option(D13,D14,D15,D16,D17,D18,D19,6)","v":0.23972064225735767},null,null,130,30,-0.23972064225735767,29.760279357742643]
[null,"Price of Certificate",{"$f":"C21+D21","v":100.23972064225735},null,null,null,140,40,-0.23972064225735767,39.76027935774264]
[null,null,null,null,null,null,150,50,-0.23972064225735767,49.76027935774264]
[]
[]
[null,"capped bonus certificate"]
[]
[]
[null,null,"zero strinke call","down and out put","call",null,"Underlying","zero","down and out put","call","Profit/Loss"]
[null,null,"long","long","short",null,null,"long","long","short"]
[]
[null,"Underlying",100,100,100,null,50,{"$f":"Payoff_EoT($G32,C$33,C$38,C$40,11,\"long\")","v":-50},{"$f":"Payoff_EoT($G32,D$33,D$38,D$40,6,\"long\")","v":-0.23972064225735767},{"$f":"Payoff_EoT($G32,E$33,E$38,-E$40,9,\"short\")","v":5.405077499964567},{"$f":"H32+I32+J32","v":-44.834643142292791}]
[null,"Strike",null,90,110,null,60,{"$f":"Payoff_EoT($G33,C$33,C$38,C$40,11,\"long\")","v":-40},{"$f":"Payoff_EoT($G33,D$33,D$38,D$40,6,\"long\")","v":-0.23972064225735767},{"$f":"Payoff_EoT($G33,E$33,E$38,-E$40,9,\"short\")","v":5.405077499964567},{"$f":"H33+I33+J33","v":-34.834643142292791}]
[null,"Interest",null,0.01,0.01,null,70,-30,-0.23972064225735767,5.405077499964567,-24.834643142292791]
[null,"Dividend",null,0,0,null,80,-20,9.7602793577426432,5.405077499964567,-4.8346431422927898]
[null,"Vola",null,0.2,0.2,null,90,-10,-0.23972064225735767,5.405077499964567,-4.8346431422927898]
[null,"Maturity",null,1.2,1.2,null,100,0,-0.23972064225735767,5.405077499964567,5.1653568577072093]
[null,"Barrier",null,80,null,null,110,10,-0.23972064225735767,5.405077499964567,15.165356857707209]
[null,null,null,null,null,null,120,20,-0.23972064225735767,-4.594922500035433,15.165356857707209]
[null,"Theoretical Price",{"$f":"C32","v":100},{"$f":"Barrier_Option(D32,D33,D34,D35,D36,D37,D38,6)","v":0.23972064225735767},{"$f":"-Black_Scholes_Call(E32,E33,E34,E35,E36,E37)","v":-5.405077499964567},null,130,30,-0.23972064225735767,-14.594922500035434,15.165356857707209]
[null,"Price of Certificate",{"$f":"C40+D40+E40","v":94.834643142292791},null,null,null,140,40,-0.23972064225735767,-24.594922500035434,15.165356857707206]
[null,null,null,null,null,null,150,50,-0.23972064225735767,-34.59492250003543,15.165356857707209]
[]
[]
[null,"discount certificate/reverse convertible"]
[]
[]
[null,null,"zero strike call","call",null,null,"Underlying","zero","call","Profit/Loss"]
[null,null,"long","short",null,null,null,"long","short"]
[]
[null,"Underlying",100,100,null,null,50,{"$f":"Payoff_EoT($G51,C$52,C$57,C$58,11,\"long\")","v":-50},{"$f":"Payoff_EoT($G51,D$52,D$57,-D$58,9,\"short\")","v":0.19817304457825013},{"$f":"H51+I51","v":-49.801826955421753}]
[null,"Strike",null,110,null,null,60,{"$f":"Payoff_EoT($G52,C$52,C$57,C$58,11,\"long\")","v":-40},{"$f":"Payoff_EoT($G52,D$52,D$57,-D$58,9,\"short\")","v":0.19817304457825013},{"$f":"H52+I52","v":-39.801826955421753}]
[null,"Interest",null,0.01,null,null,70,-30,0.19817304457825013,-29.801826955421749]
[null,"Dividend",null,0,null,null,80,-20,0.19817304457825013,-19.801826955421749]
[null,"Vola",null,0.2,null,null,90,-10,0.19817304457825013,-9.801826955421749]
[null,"Maturity",null,0.1,null,null,100,0,0.19817304457825013,0.19817304457825013]
[null,null,null,null,null,null,110,10,0.19817304457825013,10.198173044578251]
[null,"Theoretical Price",{"$f":"C51","v":100},{"$f":"-Black_Scholes_Call(D51,D52,D53,D54,D55,D56)","v":-0.19817304457825013},null,null,120,20,-9.801826955421749,10.198173044578251]
[null,"Price of Certificate",{"$f":"C58+D58","v":99.801826955421745},null,null,null,130,30,-19.801826955421749,10.198173044578251]
[null,null,null,null,null,null,140,40,-29.801826955421749,10.198173044578251]
[null,null,null,null,null,null,150,50,-39.801826955421753,10.198173044578247]
[]
[null,"outperformance certificate"]
[]
[]
[null,null,"zero strike call","call",null,null,"Underlying","zero","call","Profit/Loss"]
[null,null,"long","long",null,null,null,"long","long"]
[]
[null,"Underlying",100,100,null,null,50,{"$f":"Payoff_EoT($G69,C$70,C$75,C$76,11,\"long\")","v":-50},{"$f":"Payoff_EoT($G69,D$70,D$75,D$76,9,\"long\")","v":-5.405077499964567},{"$f":"H69+I69","v":-55.40507749996457}]
[null,"Strike",null,110,null,null,60,{"$f":"Payoff_EoT($G70,C$70,C$75,C$76,11,\"long\")","v":-40},{"$f":"Payoff_EoT($G70,D$70,D$75,D$76,9,\"long\")","v":-5.405077499964567},{"$f":"H70+I70","v":-45.40507749996457}]
[null,"Interest",null,0.01,null,null,70,-30,-5.405077499964567,-35.40507749996457]
[null,"Dividend",null,0,null,null,80,-20,-5.405077499964567,-25.405077499964566]
[null,"Vola",null,0.2,null,null,90,-10,-5.405077499964567,-15.405077499964566]
[null,"Maturity",null,1.2,null,null,100,0,-5.405077499964567,-5.405077499964567]
[null,null,null,null,null,null,110,10,-5.405077499964567,4.594922500035433]
[null,"Theoretical Price",{"$f":"C69","v":100},{"$f":"Black_Scholes_Call(D69,D70,D71,D72,D73,D74)","v":5.405077499964567},null,null,120,20,4.594922500035433,24.594922500035434]
[null,"Price of Certificate",{"$f":"C76+D76","v":105.40507749996456},null,null,null,130,30,14.594922500035434,44.594922500035437]
[null,null,null,null,null,null,140,40,24.594922500035434,64.594922500035437]
[null,null,null,null,null,null,150,50,34.59492250003543,84.594922500035437]
[]
[null,"sprint certificate"]
[]
[]
[null,null,"zero strike call","call","call",null,"Underlying","zero","call","call","Profit/Loss"]
[null,null,"long","long","short",null,null,"long","long","short"]
[]
[null,"Underlying",100,100,100,null,50,{"$f":"Payoff_EoT($G87,C$88,C$93,C$94,11,\"long\")","v":-50},{"$f":"Payoff_EoT($G87,D$88,D$93,D$94,9,\"long\")","v":-14.925228379415232},{"$f":"Payoff_EoT($G87,E$88,E$93,-E$94,9,\"short\")","v":5.405077499964567},{"$f":"H87+I87+J87","v":-59.520150879450661}]
[null,"Strike",null,90,110,null,60,{"$f":"Payoff_EoT($G88,C$88,C$93,C$94,11,\"long\")","v":-40},{"$f":"Payoff_EoT($G88,D$88,D$93,D$94,9,\"long\")","v":-14.925228379415232},{"$f":"Payoff_EoT($G88,E$88,E$93,-E$94,9,\"short\")","v":5.405077499964567},{"$f":"H88+I88+J88","v":-49.520150879450661}]
[null,"Interest",null,0.01,0.01,null,70,-30,-14.925228379415232,5.405077499964567,-39.520150879450661]
[null,"Dividend",null,0,0,null,80,-20,-14.925228379415232,5.405077499964567,-29.520150879450664]
[null,"Vola",null,0.2,0.2,null,90,-10,-14.925228379415232,5.405077499964567,-19.520150879450664]
[null,"Maturity",null,1.2,1.2,null,100,0,-4.9252283794152323,5.405077499964567,0.47984912054933471]
[null,null,null,null,null,null,110,10,5.0747716205847677,5.405077499964567,20.479849120549336]
[null,"Theoretical Price",{"$f":"C87","v":100},{"$f":"Black_Scholes_Call(D87,D88,D89,D90,D91,D92)","v":14.925228379415232},{"$f":"-Black_Scholes_Call(E87,E88,E89,E90,E91,E92)","v":-5.405077499964567},null,120,20,15.074771620584768,-4.594922500035433,30.479849120549336]
[null,"Price of Certificate",{"$f":"C94+D94+E94","v":109.52015087945067},null,null,null,130,30,25.074771620584769,-14.594922500035434,40.479849120549332]
[null,null,null,null,null,null,140,40,35.074771620584769,-24.594922500035434,50.479849120549332]
[null,null,null,null,null,null,150,50,45.074771620584769,-34.59492250003543,{"$f":"H97+I97+J97","v":60.479849120549339}]
[]
[null,"turbo certificate with down and our call"]
[]
[]
[null,null,"down and out call",null,null,null,"Underlying","down and out call","Profit/Loss"]
[null,null,"long",null,null,null,null,"long"]
[]
[null,"Underlying",100,null,null,null,50,{"$f":"Payoff_EoT($G105,C$106,C$112,C$113,2,\"long\")","v":-14.387651795438948},{"$f":"H105","v":-14.387651795438948}]
[null,"Strike",90,null,null,null,60,{"$f":"Payoff_EoT($G106,C$106,C$112,C$113,2,\"long\")","v":-14.387651795438948},{"$f":"H106","v":-14.387651795438948}]
[null,"Interest",0.01,null,null,null,70,-14.387651795438948,-14.387651795438948]
[null,"Dividend",0,null,null,null,80,-14.387651795438948,-14.387651795438948]
[null,"Vola",0.2,null,null,null,90,-14.387651795438948,-14.387651795438948]
[null,"Maturity",1.2,null,null,null,100,-4.3876517954389485,-4.3876517954389485]
[null,"Barrier",80,null,null,null,110,5.6123482045610515,5.6123482045610515]
[null,null,null,null,null,null,120,15.612348204561052,15.612348204561052]
[null,"Theoretical Price",{"$f":"Barrier_Option(C105,C106,C107,C108,C109,C110,C111,2)","v":14.387651795438948},null,null,null,130,25.612348204561052,25.612348204561052]
[null,"Price of Certificate",{"$f":"C113","v":14.387651795438948},null,null,null,140,35.612348204561052,35.612348204561052]
[null,null,null,null,null,null,150,45.612348204561052,45.612348204561052]

{"sheet":"Historical volatility","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Historical volatility (annualized)"]
[]
[null,"Date","Closing price","Change"]
[null,"2000-12-31",100.5]
[null,"2001-12-31",76.5,{"$f":"LN(C6/C5)","v":-0.27286698666664033}]
[null,"2002-12-31",40.799999999999997,-0.62860865942237421]
[null,"2003-12-31",65.099999999999994,0.46724246780440748]
[null,"2004-12-31",64.400000000000006,-1.0810916104215506E-2]
[null,"2005-12-31",70.8,9.4745367589366108E-2]
[null,"2006-12-31",75.5,6.4273655555304912E-2]
[null,"2007-12-31",100.05,0.2815374047747633]
[null,"2008-12-31",48.8,-0.71793974817064099]
[null,"2009-12-31",60.95,0.22232354306817914]
[]
[null,"Result"]
[null,"Average return",null,{"$f":"AVERAGE(D5:D14)","v":-5.5567096841316693E-2}]
[null,"Variance",null,{"$f":"VARP(D5:D14)","v":0.14638718400544984}]
[null,"Standard deviation",null,{"$f":"STDEVP(D5:D14)","v":0.38260578145847435}]

{"sheet":"Monthly volatility","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Monthly volatility"]
[]
[null,"Date","Closing price","Change"]
[null,"2008-12-29",50.81]
[null,"2009-01-31",43.57,{"$f":"LN(C6/C5)","v":-0.1537243454762898}]
[null,"2009-02-28",39.07,{"$f":"LN(C7/C6)","v":-0.10901393106237159}]
[null,"2009-03-30",41.45,5.9132972514324908E-2]
[null,"2009-04-30",50.2,0.19152714511637944]
[null,"2009-05-31",51.38,2.3233964984054029E-2]
[null,"2009-06-29",48.97,-4.8041125967511568E-2]
[null,"2009-07-31",55.13,0.11848616688736624]
[null,"2009-08-31",60.16,8.7313647039992046E-2]
[null,"2009-09-28",62.97,4.5650742859067034E-2]
[null,"2009-10-31",61.1,-3.014655632310163E-2]
[null,"2009-11-30",64.989999999999995,6.1721545728707722E-2]
[null,"2009-12-30",64.209999999999994,-1.2074450100300563E-2]
[]
[null,"Monthly perspective",null,null,null,"Annual values"]
[null,"Average return",null,{"$f":"AVERAGE(D6:D17)","v":1.9505481350026357E-2},null,"Average return",null,{"$f":"12*D20","v":0.23406577620031627}]
[null,"Variance",null,{"$f":"VARP(D6:D17)","v":8.5489633358770793E-3},null,"Variance",null,{"$f":"12*D21","v":0.10258756003052495}]
[null,"Standard deviation",null,{"$f":"STDEVP(D6:D17)","v":9.2460604237032104E-2},null,"Standard deviation",null,{"$f":"SQRT(H21)","v":0.32029292847411561}]

{"sheet":"Implied volatility","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,5]]}
[]
[null,"Implied volatility"]
[]
[null,"Implied volatility from the price of the call",null,null,"Derivation of call volatility from the price of the put"]
[null,"Price of the underlying",23,null,"Price of the underlying",35]
[null,"Strike price",24,null,"Strike price",35]
[null,"Period in years",0.5,null,"Period in years",1]
[null,"Risk-free rate of interest",0.03,null,"Risk-free rate of interest",0.06]
[null,"Option price call",5.25,null,"Option price put",3.44]
[null,"Implied volatility",{"$f":"Callvolatility(C5,C6,C7,C8,C9)","v":0.85904169082641602},null,"Implied volatility",{"$f":"PutVolatility(F5,F6,F7,F8,F9)","v":0.32490396499633789}]

{"sheet":"Change in option price","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Effect of term to maturity on option price"]
[]
[null,"Strike price of the option ","Expiry","Price of call option","Price of put option"]
[null,50,"Aug-08",0.65,1.45]
[null,50,"2022-09-01",1.35,2]
[null,50,"2008-10-01",1.8,2.5499999999999998]
[null,50,"2009-01-01",2.9,3.4]
[null,50,"2010-01-01",5.4,5.2]
[null,50,"2011-01-01",6.8,5.8]

{"sheet":"Moneyness","index":6,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Moneyness"]
[]
[null,"Underlying",null,null,60]
[]
[null,"Period considered","Strike price","Call price","In-the-Money or Out-of-the-money"]
[null," Aug01",7.5,11.9]
[null," Aug01",10,9.6]
[null," Aug01",12.5,6.5]
[null," Aug01",15,4.2]
[null," Aug01",17.5,2.1]
[null," Aug01",20,0.65]
[null," Aug01",22.5,0.15]
[null," Aug01",25,0.05]
[null," Aug01",27.5,0.1]
[null," Aug01",30,0.1]
[null," Aug01",32.5,0.05]
[null," Aug01",35,0.05]
[null,"2009-01-15",50,6.9,{"$f":"IF($E$4>C19,\"IN-THE-MONEY\",\"OUT-OF-THE-MONEY\")","v":"IN-THE-MONEY"}]
[null,"2009-01-16",55,5,{"$f":"IF($E$4>C20,\"IN-THE-MONEY\",\"OUT-OF-THE-MONEY\")","v":"IN-THE-MONEY"}]
[null,"2009-01-17",57,3.2,"IN-THE-MONEY"]
[null,"2009-01-18",60,1.8,"OUT-OF-THE-MONEY"]
[null,"2009-01-19",62.5,0.95,"OUT-OF-THE-MONEY"]
[null,"2009-01-20",65,0.45,"OUT-OF-THE-MONEY"]
[null,"2009-01-21",67,0.2,"OUT-OF-THE-MONEY"]
[null,"2009-01-22",70,0.15,"OUT-OF-THE-MONEY"]
[]
[null,"Period considered","Strike price","Put price","In-the-Money or Out-of-the-money"]
[null,"2009-01-22",50,0.1,{"$f":"IF(C29>$E$4,\"IN-THE-MONEY\",\"OUT-OF-THE-MONEY\")","v":"OUT-OF-THE-MONEY"}]
[null,"2009-01-23",55,0.25,{"$f":"IF(C30>$E$4,\"IN-THE-MONEY\",\"OUT-OF-THE-MONEY\")","v":"OUT-OF-THE-MONEY"}]
[null,"2009-01-24",57,0.65,"OUT-OF-THE-MONEY"]
[null,"2009-01-25",60,1.4,"OUT-OF-THE-MONEY"]
[null,"2009-01-26",62.5,2.5499999999999998,"IN-THE-MONEY"]
[null,"2009-01-27",65,4.0999999999999996,"IN-THE-MONEY"]
[null,"2009-01-28",67,6,"IN-THE-MONEY"]
[null,"2009-01-29",70,7.5,"IN-THE-MONEY"]
[null,"2009-01-30",72.5,10.7,"IN-THE-MONEY"]

{"sheet":"Replication method","index":7,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Replication method"]
[]
[null,"Securities"]
[null,"Share:","Siemens (x)"]
[null,"Bond:","One year zero bond (y)"]
[]
[null,"Call"]
[null,"Share price in t0",61.73]
[null,"Increase in %",0.40494999999999998]
[null,"Decline in %",0.28822967723739035]
[null,"Share price t1 è Price increase",{"$f":"C9*(1+C10)","v":86.727563499999988}]
[null,"Share price t1 è Price decline",{"$f":"C9*(1-C11)","v":43.937582024135892}]
[null,"Call price at expiry",{"$f":"IF(C12>C9,(C12-C9),0)+IF(C13>C9,(C13-C9),0)","v":24.997563499999991}]
[]
[null,"Replication model"]
[null,"Share price in t0",61.73]
[null,"Increase in %",0.40494999999999998]
[null,"Decline in %",0.28822967723739035]
[null,"Share price t1 è Price increase",{"$f":"C17*(1+C18)","v":86.727563499999988}]
[null,"Share price t1 è Price decline",{"$f":"C17*(1-C19)","v":43.937582024135892}]
[null,"Zero bond t0",61.73]
[null,"Interest rate on zero bond (risk-free) in %",0.01]
[null,"Zero bond t1 ",{"$f":"C22*(1+C23)","v":62.347299999999997}]
[]
[null,"Calculations"]
[null,"Price increase","86,73x + 62,35y = 25,00"]
[null,"Price decline","43,94x + 62,35y = 0"]
[]
[null,"Solving scenario price increase for  x","x = (25,00 - 62,35y)/86,73"]
[]
[null,"x = (25,00 - 62,35y)/86,73 into scenario Price decline"]
[]
[null,null,"y =",{"$f":"(C21*(C20-C17)/C20)/((C21*C24)/C20-C24)","v":-0.41169357009952229}]
[null,null,"x =",{"$f":"((C20-C17)-C24*D34)/C20","v":0.58419196825546638}]
[]
[null,"Value of the portfolio"]
[null,"Price of the call",{"$f":"D35*C17+D34*C22","v":10.648326118166427}]

{"sheet":"Binomial model (one period)","index":8,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Binomial model for one period"]
[]
[null,"Assumptions"]
[null,"Price of underlying",null,100]
[null,"Volatility",null,0.34]
[null,"Strike price",null,100]
[null,"Risk-free rate of interest ",null,0.01]
[null,"Time to maturity of option in years",null,1]
[]
[null,"Calculations"]
[null,"Up-factor",null,{"$f":"EXP(D6*SQRT(D9))","v":1.4049475905635938}]
[null,"Down-factor",null,{"$f":"EXP(-D6*SQRT(D9))","v":0.71177032276260965}]
[null,"Pseudo probability q",null,{"$f":"(1+D8-D13)/(D12-D13)","v":0.43023580127416139}]
[]
[]
[null,"Value development"]
[null,"Time"]
[null,0,null,1]
[null,null,null,{"$f":"B21*D12","v":140.49475905635938}]
[null,{"$f":"D5","v":100}]
[null,null,null,{"$f":"B21*D13","v":71.17703227626096}]
[]
[null,"Option tree"]
[null,"Time"]
[null,0,null,1]
[null,null,null,{"$f":"IF(D20>D7,(D20-D7),0)","v":40.494759056359385}]
[null,{"$f":"D27*D14/(1+D8)+D29*(1-D14)/(1+D8)","v":17.249797138630576}]
[null,null,null,{"$f":"IF(D22>D7,(D22-D7),0)","v":0}]

{"sheet":"Binomial (multi period)","index":9,"n_rows":79,"n_cols":14,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,2]]}
[]
[null,"Binomial model in the multi period case "]
[]
[]
[null,"Assumptions"]
[null,"Price of underlying",null,100]
[null,"Volatility",null,0.34]
[null,"Strike price",null,100]
[null,"Risk-free rate of interest (annualized)",null,0.01]
[null,"Time to maturity of option in years",null,1]
[null,"Time to maturity of option in months",null,12]
[]
[null,"Calculations"]
[null,"Monthly up-factor",null,{"$f":"EXP(D7*SQRT(1/D11))","v":1.1031277408528339}]
[null,"Monthly down-factor",null,{"$f":"EXP(-D7*SQRT(1/D11))","v":0.90651332839014154}]
[null,"Riskfree rate of interest (monthly)",null,{"$f":"(1+D9)^(1/12)-1","v":8.295381143461622E-4}]
[null,"Pseudo probability q",null,{"$f":"(1+D16-D15)/(D14-D15)","v":0.47970140409773437}]
[]
[]
[null,"Value development"]
[null,"Time"]
[null,0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M24*$D$14","v":324.72047493721067}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L25*$D$14","v":294.36343853175839}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K26*$D$14","v":266.84438041979115},null,{"$f":"M26*$D$14","v":266.84438041979115}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J27*$D$14","v":241.89798745655},null,{"$f":"L27*$D$14","v":241.89798745655}]
[null,null,null,null,null,null,null,null,null,{"$f":"I28*$D$14","v":219.28374974011385},null,{"$f":"K28*$D$14","v":219.28374974011385},null,{"$f":"M28*$D$14","v":219.28374974011385}]
[null,null,null,null,null,null,null,null,{"$f":"H29*$D$14","v":198.78364183878145},null,{"$f":"J29*$D$14","v":198.78364183878145},null,{"$f":"L29*$D$14","v":198.78364183878145}]
[null,null,null,null,null,null,null,{"$f":"G30*$D$14","v":180.20002079278757},null,{"$f":"I30*$D$14","v":180.20002079278757},null,{"$f":"K30*$D$14","v":180.20002079278757},null,{"$f":"M30*$D$14","v":180.20002079278757}]
[null,null,null,null,null,null,{"$f":"F31*$D$14","v":163.35372062484257},null,{"$f":"H31*$D$14","v":163.35372062484257},null,{"$f":"J31*$D$14","v":163.35372062484257},null,{"$f":"L31*$D$14","v":163.35372062484257}]
[null,null,null,null,null,{"$f":"E32*$D$14","v":148.08232498853934},null,{"$f":"G32*$D$14","v":148.08232498853934},null,{"$f":"I32*$D$14","v":148.08232498853934},null,{"$f":"K32*$D$14","v":148.08232498853934},null,{"$f":"M32*$D$14","v":148.08232498853934}]
[null,null,null,null,{"$f":"D33*$D$14","v":134.23860130111143},null,{"$f":"F33*$D$14","v":134.23860130111143},null,{"$f":"H33*$D$14","v":134.23860130111143},null,{"$f":"J33*$D$14","v":134.23860130111143},null,{"$f":"L33*$D$14","v":134.23860130111143}]
[null,null,null,{"$f":"C34*$D$14","v":121.68908126390771},null,{"$f":"E34*$D$14","v":121.68908126390771},null,{"$f":"G34*$D$14","v":121.68908126390771},null,{"$f":"I34*$D$14","v":121.68908126390771},null,{"$f":"K34*$D$14","v":121.68908126390771},null,{"$f":"M34*$D$14","v":121.68908126390771}]
[null,null,{"$f":"B35*$D$14","v":110.31277408528339},null,{"$f":"D35*$D$14","v":110.31277408528339},null,{"$f":"F35*$D$14","v":110.31277408528339},null,{"$f":"H35*$D$14","v":110.31277408528339},null,{"$f":"J35*$D$14","v":110.31277408528339},null,{"$f":"L35*$D$14","v":110.31277408528339}]
[null,{"$f":"D6","v":100},null,{"$f":"C36*$D$14","v":100},null,{"$f":"E36*$D$14","v":100},null,{"$f":"G36*$D$14","v":100},null,{"$f":"I36*$D$14","v":100},null,{"$f":"K36*$D$14","v":100},null,{"$f":"M36*$D$14","v":100}]
[null,null,{"$f":"B35*$D$15","v":90.65133283901416},null,{"$f":"D37*$D$14","v":90.65133283901416},null,{"$f":"F37*$D$14","v":90.65133283901416},null,{"$f":"H37*$D$14","v":90.65133283901416},null,{"$f":"J37*$D$14","v":90.65133283901416},null,{"$f":"L37*$D$14","v":90.65133283901416}]
[null,null,null,{"$f":"C36*$D$15","v":82.176641454897265},null,{"$f":"E38*$D$14","v":82.176641454897265},null,{"$f":"G38*$D$14","v":82.176641454897265},null,{"$f":"I38*$D$14","v":82.176641454897265},null,{"$f":"K38*$D$14","v":82.176641454897265},null,{"$f":"M38*$D$14","v":82.176641454897265}]
[null,null,null,null,{"$f":"D37*$D$15","v":74.4942207612022},null,{"$f":"F39*$D$14","v":74.4942207612022},null,{"$f":"H39*$D$14","v":74.4942207612022},null,{"$f":"J39*$D$14","v":74.4942207612022},null,{"$f":"L39*$D$14","v":74.4942207612022}]
[null,null,null,null,null,{"$f":"E38*$D$15","v":67.530004008067394},null,{"$f":"G40*$D$14","v":67.530004008067394},null,{"$f":"I40*$D$14","v":67.530004008067394},null,{"$f":"K40*$D$14","v":67.530004008067394},null,{"$f":"M40*$D$14","v":67.530004008067394}]
[null,null,null,null,null,null,{"$f":"F39*$D$15","v":61.21684869955277},null,{"$f":"H41*$D$14","v":61.21684869955277},null,{"$f":"J41*$D$14","v":61.21684869955277},null,{"$f":"L41*$D$14","v":61.21684869955277}]
[null,null,null,null,null,null,null,{"$f":"G40*$D$15","v":55.493889268187289},null,{"$f":"I42*$D$14","v":55.493889268187289},null,{"$f":"K42*$D$14","v":55.493889268187289},null,{"$f":"M42*$D$14","v":55.493889268187289}]
[null,null,null,null,null,null,null,null,{"$f":"H41*$D$15","v":50.305950265818417},null,{"$f":"J43*$D$14","v":50.305950265818417},null,{"$f":"L43*$D$14","v":50.305950265818417}]
[null,null,null,null,null,null,null,null,null,{"$f":"I42*$D$15","v":45.60301441329598},null,{"$f":"K44*$D$14","v":45.60301441329598},null,{"$f":"M44*$D$14","v":45.60301441329598}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J43*$D$15","v":41.339740380420537},null,{"$f":"L45*$D$14","v":41.339740380420537}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K44*$D$15","v":37.475025647039359},null,{"$f":"M46*D14","v":37.475025647039359}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L45*$D$15","v":33.97161023080357}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M46*$D$15","v":30.795717461098327}]
[]
[]
[]
[]
[null,"Option tree"]
[null,"Time"]
[null,0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N23>$D$8,(N23-$D$8),0)","v":224.72047493721067}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N55*$D$17/(1+$D$16)+N57*(1-$D$17)/(1+$D$16)","v":194.44632358688068}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M56*$D$17/(1+$D$16)+M58*(1-$D$17)/(1+$D$16)","v":167.0100818307121},null,{"$f":"IF(N25>$D$8,(N25-$D$8),0)","v":166.84438041979115}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"L57*$D$17/(1+$D$16)+L59*(1-$D$17)/(1+$D$16)","v":142.14643658088744},null,{"$f":"N57*$D$17/(1+$D$16)+N59*(1-$D$17)/(1+$D$16)","v":141.98087251167229}]
[null,null,null,null,null,null,null,null,null,{"$f":"K58*$D$17/(1+$D$16)+K60*(1-$D$17)/(1+$D$16)","v":119.61487799237992},null,{"$f":"M58*$D$17/(1+$D$16)+M60*(1-$D$17)/(1+$D$16)","v":119.44945115103479},null,{"$f":"IF(N27>$D$8,(N27-$D$8),0)","v":119.28374974011385}]
[null,null,null,null,null,null,null,null,{"$f":"J59*$D$17/(1+$D$16)+J61*(1-$D$17)/(1+$D$16)","v":99.197380690335393},null,{"$f":"L59*$D$17/(1+$D$16)+L61*(1-$D$17)/(1+$D$16)","v":99.03209096311889},null,{"$f":"N59*$D$17/(1+$D$16)+N61*(1-$D$17)/(1+$D$16)","v":98.866526893903739}]
[null,null,null,null,null,null,null,{"$f":"I60*$D$17/(1+$D$16)+I62*(1-$D$17)/(1+$D$16)","v":80.696301771788626},null,{"$f":"K60*$D$17/(1+$D$16)+K62*(1-$D$17)/(1+$D$16)","v":80.531149045053638},null,{"$f":"M60*$D$17/(1+$D$16)+M62*(1-$D$17)/(1+$D$16)","v":80.365722203708515},null,{"$f":"IF(N29>$D$8,(N29-$D$8),0)","v":80.200020792787569}]
[null,null,null,null,null,null,{"$f":"H61*$D$17/(1+$D$16)+H63*(1-$D$17)/(1+$D$16)","v":64.115385261387488},null,{"$f":"J61*$D$17/(1+$D$16)+J63*(1-$D$17)/(1+$D$16)","v":63.76745947639651},null,{"$f":"L61*$D$17/(1+$D$16)+L63*(1-$D$17)/(1+$D$16)","v":63.602169749180021},null,{"$f":"N61*$D$17/(1+$D$16)+N63*(1-$D$17)/(1+$D$16)","v":63.436605679964856}]
[null,null,null,null,null,{"$f":"G62*$D$17/(1+$D$16)+G64*(1-$D$17)/(1+$D$16)","v":49.618070271614755},null,{"$f":"I62*$D$17/(1+$D$16)+I64*(1-$D$17)/(1+$D$16)","v":48.930445617690054},null,{"$f":"K62*$D$17/(1+$D$16)+K64*(1-$D$17)/(1+$D$16)","v":48.413453240805424},null,{"$f":"M62*$D$17/(1+$D$16)+M64*(1-$D$17)/(1+$D$16)","v":48.248026399460286},null,{"$f":"IF(N31>$D$8,(N31-$D$8),0)","v":48.082324988539341}]
[null,null,null,null,{"$f":"F63*$D$17/(1+$D$16)+F65*(1-$D$17)/(1+$D$16)","v":37.365535179568624},null,{"$f":"H63*$D$17/(1+$D$16)+H65*(1-$D$17)/(1+$D$16)","v":36.331041764835724},null,{"$f":"J63*$D$17/(1+$D$16)+J65*(1-$D$17)/(1+$D$16)","v":35.329127515389168},null,{"$f":"L63*$D$17/(1+$D$16)+L65*(1-$D$17)/(1+$D$16)","v":34.487050425448871},null,{"$f":"N63*$D$17/(1+$D$16)+N65*(1-$D$17)/(1+$D$16)","v":34.321486356233713}]
[null,null,null,{"$f":"E64*$D$17/(1+$D$16)+E66*(1-$D$17)/(1+$D$16)","v":27.392626816437492},null,{"$f":"G64*$D$17/(1+$D$16)+G66*(1-$D$17)/(1+$D$16)","v":26.128598932069828},null,{"$f":"I64*$D$17/(1+$D$16)+I66*(1-$D$17)/(1+$D$16)","v":24.772652442831003},null,{"$f":"K64*$D$17/(1+$D$16)+K66*(1-$D$17)/(1+$D$16)","v":23.322055780936175},null,{"$f":"M64*$D$17/(1+$D$16)+M66*(1-$D$17)/(1+$D$16)","v":21.854782674828648},null,{"$f":"IF(N33>$D$8,(N33-$D$8),0)","v":21.68908126390771}]
[null,null,{"$f":"D65*$D$17/(1+$D$16)+D67*(1-$D$17)/(1+$D$16)","v":19.573753040677119},null,{"$f":"F65*$D$17/(1+$D$16)+F67*(1-$D$17)/(1+$D$16)","v":18.241545198623321},null,{"$f":"H65*$D$17/(1+$D$16)+H67*(1-$D$17)/(1+$D$16)","v":16.76387736297432},null,{"$f":"J65*$D$17/(1+$D$16)+J67*(1-$D$17)/(1+$D$16)","v":15.079360754260939},null,{"$f":"L65*$D$17/(1+$D$16)+L67*(1-$D$17)/(1+$D$16)","v":13.065412546512267},null,{"$f":"N65*$D$17/(1+$D$16)+N67*(1-$D$17)/(1+$D$16)","v":10.395659140405675}]
[null,{"$f":"C66*$D$17/(1+$D$16)+C68*(1-$D$17)/(1+$D$16)","v":13.656180917330129},null,{"$f":"E66*$D$17/(1+$D$16)+E68*(1-$D$17)/(1+$D$16)","v":12.396167738854279},null,{"$f":"G66*$D$17/(1+$D$16)+G68*(1-$D$17)/(1+$D$16)","v":10.998975791748371},null,{"$f":"I66*$D$17/(1+$D$16)+I68*(1-$D$17)/(1+$D$16)","v":9.4067282070069069},null,{"$f":"K66*$D$17/(1+$D$16)+K68*(1-$D$17)/(1+$D$16)","v":7.5038579479833798},null,{"$f":"M66*$D$17/(1+$D$16)+M68*(1-$D$17)/(1+$D$16)","v":4.9826789640618081},null,{"$f":"IF(N35>$D$8,(N35-$D$8),0)","v":0}]
[null,null,{"$f":"D67*$D$17/(1+$D$16)+D69*(1-$D$17)/(1+$D$16)","v":8.2221102584446193},null,{"$f":"F67*$D$17/(1+$D$16)+F69*(1-$D$17)/(1+$D$16)","v":7.0266497287652525},null,{"$f":"H67*$D$17/(1+$D$16)+H69*(1-$D$17)/(1+$D$16)","v":5.7014267876337277},null,{"$f":"J67*$D$17/(1+$D$16)+J69*(1-$D$17)/(1+$D$16)","v":4.1917101776694858},null,{"$f":"L67*$D$17/(1+$D$16)+L69*(1-$D$17)/(1+$D$16)","v":2.3882169782199321},null,{"$f":"N67*$D$17/(1+$D$16)+N69*(1-$D$17)/(1+$D$16)","v":0}]
[null,null,null,{"$f":"E68*$D$17/(1+$D$16)+E70*(1-$D$17)/(1+$D$16)","v":4.3868497061131135},null,{"$f":"G68*$D$17/(1+$D$16)+G70*(1-$D$17)/(1+$D$16)","v":3.3754741708406231},null,{"$f":"I68*$D$17/(1+$D$16)+I70*(1-$D$17)/(1+$D$16)","v":2.2943279474417073},null,{"$f":"K68*$D$17/(1+$D$16)+K70*(1-$D$17)/(1+$D$16)","v":1.1446814808250192},null,{"$f":"M68*$D$17/(1+$D$16)+M70*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"IF(N37>$D$8,(N37-$D$8),0)","v":0}]
[null,null,null,null,{"$f":"F69*$D$17/(1+$D$16)+F71*(1-$D$17)/(1+$D$16)","v":1.9600187895685728},null,{"$f":"H69*$D$17/(1+$D$16)+H71*(1-$D$17)/(1+$D$16)","v":1.2363896904534979},null,{"$f":"J69*$D$17/(1+$D$16)+J71*(1-$D$17)/(1+$D$16)","v":0.54865018735458171},null,{"$f":"L69*$D$17/(1+$D$16)+L71*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"N69*$D$17/(1+$D$16)+N71*(1-$D$17)/(1+$D$16)","v":0}]
[null,null,null,null,null,{"$f":"G70*$D$17/(1+$D$16)+G72*(1-$D$17)/(1+$D$16)","v":0.65813170227311912},null,{"$f":"I70*$D$17/(1+$D$16)+I72*(1-$D$17)/(1+$D$16)","v":0.26297012149376453},null,{"$f":"K70*$D$17/(1+$D$16)+K72*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"M70*$D$17/(1+$D$16)+M72*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"IF(N39>$D$8,(N39-$D$8),0)","v":0}]
[null,null,null,null,null,null,{"$f":"H71*$D$17/(1+$D$16)+H73*(1-$D$17)/(1+$D$16)","v":0.12604257939267394},null,{"$f":"J71*$D$17/(1+$D$16)+J73*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"L71*$D$17/(1+$D$16)+L73*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"N71*$D$17/(1+$D$16)+N73*(1-$D$17)/(1+$D$16)","v":0}]
[null,null,null,null,null,null,null,{"$f":"I72*$D$17/(1+$D$16)+I74*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"K72*$D$17/(1+$D$16)+K74*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"M72*$D$17/(1+$D$16)+M74*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"IF(N41>$D$8,(N41-$D$8),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"J73*$D$17/(1+$D$16)+J75*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"L73*$D$17/(1+$D$16)+L75*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"N73*$D$17/(1+$D$16)+N75*(1-$D$17)/(1+$D$16)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"K74*$D$17/(1+$D$16)+K76*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"M74*$D$17/(1+$D$16)+M76*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"IF(N43>$D$8,(N43-$D$8),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"L75*$D$17/(1+$D$16)+L77*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"N75*$D$17/(1+$D$16)+N77*(1-$D$17)/(1+$D$16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M76*$D$17/(1+$D$16)+M78*(1-$D$17)/(1+$D$16)","v":0},null,{"$f":"IF(N45>$D$8,(N45-$D$8),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N77*$D$17/(1+$D$16)+N79*(1-$D$17)/(1+$D$16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N47>$D$8,(N47-$D$8),0)","v":0}]

{"sheet":"Black-Scholes (excl. dividends)","index":10,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,1,5,2]]}
[]
[null,"Black-Scholes model (excluding dividends)"]
[]
[]
[]
[null,"Assumptions"]
[null,"strike price","K",180]
[null,"price of underlying","S0",185]
[null,"volatility","σ",0.2]
[null,"risk-free rate ","r",2.5000000000000001E-3]
[null,"time to maturity of option (days)","t",80]
[]
[]
[]
[null,"Calculation Call-Option"]
[null,"time to maturity in years",{"$f":"D11/365","v":0.21917808219178081}]
[null,"d1",{"$f":"(LN(D8/D7)+(D10+(D9^2)/2)*C16)/(D9*SQRT(C16))","v":0.34528968883964295}]
[null,"d2",{"$f":"C17-(D9*SQRT(C16))","v":0.25165677108273848}]
[null,"N(d1)",{"$f":"NORMSDIST(C17)","v":0.63506170116760252}]
[null,"N(d2)",{"$f":"NORMSDIST(C18)","v":0.59934681329259254}]
[null,"price of Call-Option",{"$f":"(D8*C19)-D7*EXP(-D10*C16)*C20","v":9.6630857890720279}]
[]
[]
[null,"Calculations Put-Optiom"]
[null,"time to maturity in years",{"$f":"D11/365","v":0.21917808219178081}]
[null,"-d1",{"$f":"-C17","v":-0.34528968883964295}]
[null,"-d2",{"$f":"-C18","v":-0.25165677108273848}]
[null,"N(-d1)",{"$f":"NORMSDIST(C26)","v":0.36493829883239748}]
[null,"N(-d2)",{"$f":"NORMSDIST(C27)","v":0.40065318670740752}]
[null,"price of Put-Option",{"$f":"(D7*EXP(-D10*C25)*C29)-(D8*C28)","v":4.5644826691062264}]

{"sheet":"Black-Scholes (incl. dividends)","index":11,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Black-Scholes Merton model (including dividends and Greeks)"]
[]
[]
[null,"Assumptions"]
[null,"strike price","K",20]
[null,"price of underlying","S0",20]
[null,"volatility","σ",0.4]
[null,"risk-free rate","r",5.0000000000000001E-3]
[null,"dividends","q",0.01]
[null,"time to maturity in days","t",10]
[]
[]
[]
[null,"Calculation Call-Option"]
[null,"time to maturity in years",{"$f":"D11/365","v":2.7397260273972601E-2}]
[null,"e-qT",{"$f":"EXP(-D10*C16)","v":0.99972606492432659}]
[null,"d1",{"$f":"(LN(D7/D6)+(D9-D10+((D8^2)/2)*C16))/(D8*SQRT(C16))","v":-4.2414801790871356E-2}]
[null,"d2",{"$f":"C18-(D8*SQRT(C16))","v":-0.10862327287906079}]
[null,"N(d1)",{"$f":"NORMSDIST(C18)","v":0.48308401442257159}]
[null,"N(d2)",{"$f":"NORMSDIST(C19)","v":0.45675065044337426}]
[null,"price of Call-Option",{"$f":"(D7*C17*C20)-((D6*EXP(-D9*C16))*C21)","v":0.5252718924015749}]
[]
[]
[null,"Calculation Put-Option"]
[null,"time to maturity in years",{"$f":"D11/365","v":2.7397260273972601E-2}]
[null,"e-qT",{"$f":"EXP(-D10*C26)","v":0.99972606492432659}]
[null,"-d1",{"$f":"-C18","v":4.2414801790871356E-2}]
[null,"-d2",{"$f":"-C19","v":0.10862327287906079}]
[null,"N(-d1)",{"$f":"NORMSDIST(C28)","v":0.51691598557742835}]
[null,"N(-d2)",{"$f":"NORMSDIST(C29)","v":0.54324934955662574}]
[null,"price of Put-Option",{"$f":"(D6*EXP(-D9*C26)*C31)-(D7*C27*C30)","v":0.5280110555315467}]
[]
[null,"distribution function of the standard normal distribution",{"$f":"(1/(SQRT(2*PI())))*EXP(-(0.5*C18^2))","v":0.3985835900927035}]
[]
[null,"Greeks","Call","Put"]
[null,"Delta",{"$f":"$C$20*$C$17","v":0.48295168076652412},{"$f":"C20*C17-1","v":-0.51704831923347583}]
[null,"Gamma",{"$f":"($C$34*$C$17)/($D$7*$D$8*$C$16^0.5)","v":0.30092403397748219},{"$f":"($C$34*$C$17)/($D$7*$D$8*$C$16^0.5)","v":0.30092403397748219}]
[null,"Theta",{"$f":"(D10*D7*C17*C20-(D7*C17*D8)/(2*C16^0.5)*C34-D9*D6*EXP(-D9*C16)*C21)/365","v":-2.6242870026687039E-2},{"$f":"(D9*D6*EXP(-D9*C16)*C31-D10*D7*C27*C30-(D7*C27*D8)/(2*C26^0.5)*C34)/365","v":-2.6516730055938499E-2}]
[null,"Vega",{"$f":"C16^0.5*D7*C17*C34/100","v":1.3191190530519765E-2},{"$f":"C16^0.5*D7*C17*C34/100","v":1.3191190530519765E-2}]
[null,"Rho",{"$f":"C16*D6*EXP(-D9*C16)*C21/100","v":2.5024004720353172E-3},{"$f":"-C26*D6*EXP(-D9*C26)*C31/100","v":-2.976301024297971E-3}]

{"sheet":"Black-Scholes (incl. Greeks)","index":12,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[7,1,7,2]]}
[]
[]
[null,"Black-Scholes model including derivation of Greeks"]
[]
[]
[]
[]
[null,"Assumptions"]
[null,"strike price","K",20]
[null,"price of underlying","S0",20]
[null,"volatility","σ",0.4]
[null,"risk-free rate","r",5.0000000000000001E-3]
[null,"time to maturity of option in days","t",10]
[]
[]
[]
[null,"Calculations",null,null,"Greeks","Call","Put"]
[null,"time to maturity of option in years",{"$f":"D13/365","v":2.7397260273972601E-2},null,"Delta",{"$f":"C23","v":0.51402920388791418},{"$f":"C23-1","v":-0.48597079611208582}]
[null,"d1",{"$f":"(LN(D10/D9)+(D12+(D11^2)/2)*C18)/(D11*SQRT(C18))","v":3.5173250265600642E-2},null,"Gamma",{"$f":"C27/(D10*D11*SQRT(C18))","v":0.30109106352588005},{"$f":"C27/(D10*D11*SQRT(C18))","v":0.30109106352588005}]
[null,"-d1",{"$f":"-C19","v":-3.5173250265600642E-2},null,"Theta",{"$f":"-((D10*C27*D11)/(2*SQRT(C18))-(D12*D9*(EXP(-(D12*C18)))*C25))/365","v":-2.6263448327547144E-2},{"$f":"-(((D10*C27*D11)/(2*SQRT(C18)))+(D12*D9*(EXP(-(D12*C18)))*C26))/365","v":-2.6537383402363807E-2}]
[null,"d2",{"$f":"C19-(D11*SQRT(C18))","v":-3.1035220822588791E-2},null,"Vega",{"$f":"D10*C27*SQRT(C18)/100","v":1.3198512373737209E-2},{"$f":"D10*C27*SQRT(C18)/100","v":1.3198512373737209E-2}]
[null,"-d2",{"$f":"-C21","v":3.1035220822588791E-2},null,"Rho",{"$f":"D9*C18*EXP((-D12*C18))*C25/100","v":2.6715283985455757E-3},{"$f":"-D9*C18*EXP((-D12*C18))*C26/100","v":-2.8071730977877124E-3}]
[null,"N(d1)",{"$f":"NORMSDIST(C19)","v":0.51402920388791418}]
[null,"N(-d1)",{"$f":"NORMSDIST(C20)","v":0.48597079611208577}]
[null,"N(d2)",{"$f":"NORMSDIST(C21)","v":0.48762072551927504}]
[null,"N(-d2)",{"$f":"NORMSDIST(C22)","v":0.51237927448072496}]
[null,"distribution function of the standard normal distribution",{"$f":"(1/(SQRT(2*PI())))*EXP(-(0.5*C19^2))","v":0.39869557948730877}]
[null,"price Call-Option",{"$f":"(D10*C23)-D9*EXP(-D12*C18)*C25","v":0.52950542306693293}]
[null,"price Put-Option",{"$f":"(D9*EXP(-D12*C18)*C26)-(D10*C24)","v":0.5267658846834351}]

{"sheet":"Put-call parity","index":13,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,6,6,7]]}
[]
[null,"Put Call Parity"]
[]
[null,"Price of Call given",null,null,null,null,"Price of Put given"]
[]
[]
[null,"Assumptions",null,null,null,null,"Assumptions"]
[null,"price of Call t=0","c",8.9281000000000006,null,null,"price of Put t=0","p",9.84]
[null,"strike price","K",61,null,null,"strike price","K",25]
[null,"price of underlying","S0",61.73,null,null,"price of underlying","S0",20]
[null,"risk-free rate","r",0.01,null,null,"risk-free rate","r",0.02]
[null,"time to maturity in days","t",365,null,null,"time to maturity in days","t",120]
[]
[]
[]
[null,"Calculation",null,null,null,null,"Calculation"]
[null,"time to maturity in years",{"$f":"D12/365","v":1},null,null,null,"time to maturity in years",{"$f":"I12/365","v":0.32876712328767121}]
[null,"price of the Put-Option",{"$f":"D8-D10+(D9*EXP(-D11*C17))","v":7.5911398586992576},null,null,null,"price of the Call-Option",{"$f":"I8+I10-I9*EXP(-I11*H17)","v":5.0038443051165267}]

{"sheet":"Long call","index":14,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,37,3],[15,2,16,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[23,2,23,3],[24,2,24,3],[20,2,20,3],[21,2,21,3],[35,2,35,3],[36,2,36,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[15,1,16,1],[3,1,3,2],[9,1,9,3],[10,1,11,1],[10,2,11,2],[10,3,11,3]]}
[]
[null,"Long call"]
[]
[null,"Assumptions"]
[null,"price of Call-Option at t=0","c",3]
[null,"strike price ","K",6]
[null,"price of underlying","S0",8]
[]
[]
[null,"Calculations"]
[null,"price of underlying","Exercise option?","profit / loss"]
[]
[null,{"$f":"D7","v":8},{"$f":"IF(D7>D6,\"yes\",\"no\")","v":"yes"},{"$f":"IF(D7<D6,-D5,D7-D6-D5)","v":-1}]
[]
[]
[null,"price of underlying","profit / loss"]
[]
[null,0,{"$f":"IF(B18<$D$6,-$D$5,B18-$D$6-$D$5)","v":-3}]
[null,2,{"$f":"IF(B19<$D$6,-$D$5,B19-$D$6-$D$5)","v":-3}]
[null,4,-3]
[null,6,-3]
[null,8,-1]
[null,10,1]
[null,12,3]
[null,14,5]
[null,16,7]
[null,18,9]
[null,20,11]
[null,22,13]
[null,24,15]
[null,26,17]
[null,28,19]
[null,30,21]
[null,32,23]
[null,34,25]
[null,36,27]
[null,38,29]
[null,40,31]

{"sheet":"Short call","index":15,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,37,3],[15,2,16,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[23,2,23,3],[24,2,24,3],[20,2,20,3],[21,2,21,3],[35,2,35,3],[36,2,36,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[15,1,16,1],[3,1,3,2],[9,1,9,3],[10,1,11,1],[10,2,11,2],[10,3,11,3]]}
[]
[null,"Short call"]
[]
[null,"Assumptions"]
[null,"price of Call-Option at t=0","c",3]
[null,"strike price","K",6]
[null,"price of underlying","S0",8]
[]
[]
[null,"Calculations"]
[null,"price of underlying","Exercise option?","profit / loss"]
[]
[null,{"$f":"D7","v":8},{"$f":"IF(D7>D6,\"yes\",\"no\")","v":"yes"},{"$f":"IF(D7<D6,D5,D5+D6-D7)","v":1}]
[]
[]
[null,"price of underlying","profit / loss"]
[]
[null,0,{"$f":"IF(B18<$D$6,$D$5,$D$6+$D$5-B18)","v":3}]
[null,2,{"$f":"IF(B19<$D$6,$D$5,$D$6+$D$5-B19)","v":3}]
[null,4,3]
[null,6,3]
[null,8,1]
[null,10,-1]
[null,12,-3]
[null,14,-5]
[null,16,-7]
[null,18,-9]
[null,20,-11]
[null,22,-13]
[null,24,-15]
[null,26,-17]
[null,28,-19]
[null,30,-21]
[null,32,-23]
[null,34,-25]
[null,36,-27]
[null,38,-29]
[null,40,-31]

{"sheet":"Long put","index":16,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,37,3],[15,2,16,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[23,2,23,3],[24,2,24,3],[20,2,20,3],[21,2,21,3],[35,2,35,3],[36,2,36,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[15,1,16,1],[3,1,3,2],[9,1,9,3],[10,1,11,1],[10,2,11,2],[10,3,11,3]]}
[]
[null,"Long put"]
[]
[null,"Assumptions"]
[null,"price of Put-Option at t=0","p",2]
[null,"strike price","K",20]
[null,"price of underlying","S0",10]
[]
[]
[null,"Calculations"]
[null,"price of underlying","Exercise option?","profit / loss"]
[]
[null,{"$f":"D7","v":10},{"$f":"IF(D7<D6,\"yes\",\"no\")","v":"yes"},{"$f":"IF(D7>D6,-D5,D6-D7-D5)","v":8}]
[]
[]
[null,"price of underlying","profit /loss"]
[]
[null,0,{"$f":"IF(B18>$D$6,-$D$5,$D$6-B18-$D$5)","v":18}]
[null,2,{"$f":"IF(B19>$D$6,-$D$5,$D$6-B19-$D$5)","v":16}]
[null,4,14]
[null,6,12]
[null,8,10]
[null,10,8]
[null,12,6]
[null,14,4]
[null,16,2]
[null,18,0]
[null,20,-2]
[null,22,-2]
[null,24,-2]
[null,26,-2]
[null,28,-2]
[null,30,-2]
[null,32,-2]
[null,34,-2]
[null,36,-2]
[null,38,-2]
[null,40,-2]

{"sheet":"Short put","index":17,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,37,3],[15,2,16,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[23,2,23,3],[24,2,24,3],[20,2,20,3],[21,2,21,3],[35,2,35,3],[36,2,36,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[15,1,16,1],[3,1,3,2],[9,1,9,3],[10,1,11,1],[10,2,11,2],[10,3,11,3]]}
[]
[null,"Short put"]
[]
[null,"Assumptions"]
[null,"price of Put-Option at t=0","p",2]
[null,"strike price","K",20]
[null,"price of underlying","S0",10]
[]
[]
[null,"Calculations"]
[null,"price of underlying","Exercise option?","profit / loss"]
[]
[null,{"$f":"D7","v":10},{"$f":"IF(D7<D6,\"yes\",\"no\")","v":"yes"},{"$f":"IF(D7>D6,D5,D5+D7-D6)","v":-8}]
[]
[]
[null,"price of underlying","profit / loss"]
[]
[null,0,{"$f":"IF(B18>$D$6,$D$5,B18+$D$5-$D$6)","v":-18}]
[null,2,{"$f":"IF(B19>$D$6,$D$5,B19+$D$5-$D$6)","v":-16}]
[null,4,-14]
[null,6,-12]
[null,8,-10]
[null,10,-8]
[null,12,-6]
[null,14,-4]
[null,16,-2]
[null,18,0]
[null,20,2]
[null,22,2]
[null,24,2]
[null,26,2]
[null,28,2]
[null,30,2]
[null,32,2]
[null,34,2]
[null,36,2]
[null,38,2]
[null,40,2]

{"sheet":"Black 76","index":18,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,5,5,6],[7,1,7,2]]}
[]
[]
[null,"Black 76"]
[]
[]
[]
[]
[null,"Assumptions"]
[null,"future price",40]
[null,"strike price",38]
[null,"risk-free interest rate",2.5000000000000001E-2]
[null,"vola",0.3]
[null,"time to maturity",0.2]
[]
[]
[]
[null,"Calculations"]
[null,"d1",{"$f":"(LN(C9/C10)+(C12^2/2)*C13)/(C12*C13^0.5)","v":0.4493996827932315}]
[null,"-d1",{"$f":"-C18","v":-0.4493996827932315}]
[null,"d2",{"$f":"C18-C12*C13^0.5","v":0.31523560414324414}]
[null,"-d2",{"$f":"-C20","v":-0.31523560414324414}]
[null,"N(d1)",{"$f":"NORMSDIST(C18)","v":0.67342831994981012}]
[null,"N(-d1)",{"$f":"NORMSDIST(C19)","v":0.32657168005018983}]
[null,"N(d2)",{"$f":"NORMSDIST(C20)","v":0.62370861278824363}]
[null,"N(-d2)",{"$f":"NORMSDIST(C21)","v":0.37629138721175631}]
[null,"price Call-Option",{"$f":"EXP(-C11*C13)*(C9*C22-C10*C24)","v":3.2200648697110941}]
[null,"price Put-Option",{"$f":"EXP(-C11*C13)*(C10*C25-C9*C23)","v":1.230039911325731}]

{"sheet":"Garman-Kohlhagen","index":19,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,5,5,6],[7,1,7,2]]}
[]
[]
[null,"Garman-Kohlhagen Model"]
[]
[]
[]
[]
[null,"Assumptions"]
[null,"FX price 1",40]
[null,"FX price 2",38]
[null,"risk-free interest rate",2.5000000000000001E-2]
[null,"foeign risk-free rate",0.04]
[null,"vola",0.3]
[null,"time to maturity",0.2]
[]
[]
[]
[null,"Calculations"]
[null,"d1",{"$f":"(LN(C9/C10)+(C11-C12+C13^2/2)*C14)/(C13*C14^0.5)","v":0.42703900301823355}]
[null,"-d1",{"$f":"-C19","v":-0.42703900301823355}]
[null,"d2",{"$f":"C19-C13*C14^0.5","v":0.29287492436824619}]
[null,"-d2",{"$f":"-C21","v":-0.29287492436824619}]
[null,"N(d1)",{"$f":"NORMSDIST(C19)","v":0.66532454021081322}]
[null,"N(-d1)",{"$f":"NORMSDIST(C20)","v":0.33467545978918678}]
[null,"N(d2)",{"$f":"NORMSDIST(C21)","v":0.61519112184716673}]
[null,"N(-d2)",{"$f":"NORMSDIST(C22)","v":0.38480887815283327}]
[null,"price Call-Option",{"$f":"C9*EXP(-C12*C14)*C23-C10*EXP(-C11*C14)*C25","v":3.140259058130674}]
[null,"price Put-Option",{"$f":"C10*EXP(-C11*C14)*C26-C9*EXP(-C12*C14)*C24","v":1.2694566739701827}]

{"sheet":" Index futures","index":20,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Calculation of futures price - index future"]
[]
[null,"Assumptions"]
[null,"Spot price",400]
[null,"Financing costs",250]
[null,"Income lost",100]
[]
[null,"Calculations"]
[null,"Futures price",{"$f":"(C5+(C6-C7))","v":550}]

{"sheet":"Interest rate futures","index":21,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Calculation of futures price, fixed income futures"]
[]
[null,"Assumptions"]
[null,"Spot position",100]
[null,"Price factor",0.7]
[null,"Coupon return",6.5]
[null,"Financing cost",1]
[]
[null,"Calculations"]
[null,"Futures price",{"$f":"((C5/C6)-(C7+C8))","v":135.35714285714286}]

{"sheet":"Currency futures","index":22,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Calculation of futures price, currency futures"]
[]
[null,"Assumptions"]
[null,"Spot price of currency",1.1200000000000001]
[null,"Financing cost currency",2.0999999999999999E-3]
[null,"Income currency",1E-3]
[]
[null,"Calculations"]
[null,"Futures price",{"$f":"(C5+(C6-C7))","v":1.1211000000000002}]

{"sheet":"Commodity futures","index":23,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Calculation of futures price, commodity futures"]
[]
[null,"Assumptions"]
[null,"Spot price",100]
[null,"Financing cost",2]
[null,"Convenience Yield",0.78]
[null,"Storage cost",0.2]
[]
[null,"Calculations"]
[null,"Futures price",{"$f":"C5+((C6+C8)-C7)","v":101.42}]

{"sheet":"Futures on indiv. securities","index":24,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Single Stock Futures"]
[]
[null,"Assumptions"]
[null,"Spot price",20]
[null,"Financing cost",1.34]
[null,"Income lost",0.2]
[]
[null,"Calculations"]
[null,"Futures price",{"$f":"(C5+(C6-C7))","v":21.14}]

{"sheet":"Swap Valuation","index":25,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Swap Valuation"]
[]
[null,"Assumptions"]
[null,"principal:",10000000]
[null,"fixed rate (p.a.):",0.02]
[null,"LIBOR rate (p.a.):",5.0000000000000001E-3]
[null,"frequency of payments:","annually",{"$f":"IF(C9=\"annually\",12,IF(C9=\"semi-annually\",6,3))","v":12}]
[null,"valuation date:","2022-08-25"]
[null,"next payment dates:","2023-08-20",{"$f":"EDATE(C11,$D$9)","v":"2024-08-20"},{"$f":"EDATE(D11,$D$9)","v":"2025-08-20"},{"$f":"EDATE(E11,$D$9)","v":"2026-08-20"},{"$f":"EDATE(F11,$D$9)","v":"2027-08-20"}]
[]
[]
[null,"days till the next payment",{"$f":"$C$11-$C$10","v":360},{"$f":"D11-C11","v":366},{"$f":"E11-D11","v":365},{"$f":"F11-E11","v":365},{"$f":"G11-F11","v":365}]
[]
[null,"Cash Flow (basis 365)",{"$f":"$C$7*C14/365","v":1.9726027397260273E-2},{"$f":"$C$7*D14/365","v":2.0054794520547946E-2},{"$f":"$C$7*E14/365","v":0.02},{"$f":"$C$7*F14/365","v":0.02},{"$f":"$C$7*G14/365","v":0.02}]
[null,"Cash Flow (basis 360)",{"$f":"$C$7*C14/360","v":0.02},{"$f":"$C$7*D14/360","v":2.0333333333333335E-2},{"$f":"$C$7*E14/360","v":2.0277777777777777E-2},{"$f":"$C$7*F14/360","v":2.0277777777777777E-2},{"$f":"$C$7*G14/360","v":2.0277777777777777E-2}]
[]
[null,"Discount Rates",{"$f":"'Zero Rates'!E8","v":0.99019704921279328},{"$f":"'Zero Rates'!E9","v":0.97174799141496038},{"$f":"'Zero Rates'!E10","v":0.94734190626130788},{"$f":"'Zero Rates'!E11","v":0.91846880253722019},{"$f":"'Zero Rates'!E12","v":0.88684947462282149}]
[]
[null,"PV Fixed (basis 365)",{"$f":"C16*C19*$C$6","v":195326.54121457841},{"$f":"D16*D19*$C$6","v":194882.06293582218},{"$f":"E16*E19*$C$6","v":189468.38125226158},{"$f":"F16*F19*$C$6","v":183693.76050744404},{"$f":"G16*G19*$C$6+$C$6","v":10177369.894924564}]
[null,"PV Fixed (basis 360)",{"$f":"C17*C19*$C$6","v":198039.40984255867},{"$f":"D17*D19*$C$6","v":197588.75825437531},{"$f":"E17*E19*$C$6","v":192099.88654743187},{"$f":"F17*F19*$C$6","v":186245.06273671408},{"$f":"G17*G19*$C$6+$C$6","v":10179833.365687406}]
[]
[null,"Cumulative PV Fixed (basis 365)",{"$f":"C21","v":195326.54121457841},{"$f":"C24+D21","v":390208.60415040061},579676.98540266219,763370.74591010623,10940740.640834671]
[null,"Cumulative PV Fixed (basis 360)",{"$f":"C22","v":198039.40984255867},395628.16809693398,587728.05464436579,773973.11738107982,10953806.483068485]
[]
[null,"PV Variable (basis 365)",{"$f":"(1+C14/365*$C$8)*$C$6","v":10049315.06849315}]
[null,"PV Variable (basis 360)",{"$f":"(1+C14/360*$C$8)*$C$6","v":10049999.999999998}]
[]
[null,"Value Receiver Swap (basis 365)",{"$f":"G24-C27","v":891425.57234152034}]
[null,"Value Receiver Swap (basis 360)",{"$f":"G25-C28","v":903806.48306848668}]
[]
[null,"Value Payer Swap (basis 365)",{"$f":"C27-G24","v":-891425.57234152034}]
[null,"Value Payer Swap (basis 360)",{"$f":"C28-G25","v":-903806.48306848668}]

{"sheet":"Zero Rates","index":26,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Zero Rates"]
[]
[]
[null,"SWAP Maturity ","Yield","Zero Rate","Discount Factor"]
[]
[null,1,9.9000000000000008E-3,{"$f":"C8","v":9.9000000000000008E-3},{"$f":"1/(1+D8)","v":0.99019704921279328}]
[null,2,1.44E-2,{"$f":"((1/E9)^(1/$B9))-1","v":1.4432545936964969E-2},{"$f":"(100-C9*100*(1/(1+D8)))/(C9*100+100)","v":0.97174799141496038}]
[null,3,1.8100000000000002E-2,1.8195289830908346E-2,{"$f":"(100-C10*100*(E8+E9))/(C10*100+100)","v":0.94734190626130788}]
[null,4,2.1299999999999999E-2,2.1489478467835665E-2,{"$f":"(100-C11*100*(E9+E10+E8))/(C11*100+100)","v":0.91846880253722019}]
[null,5,2.4E-2,2.4306709276521454E-2,{"$f":"(100-C12*100*(E10+E11+E9+E8))/(C12*100+100)","v":0.88684947462282149}]
[null,6,2.6200000000000001E-2,2.6632998340627712E-2,{"$f":"(100-C13*100*(E11+E12+E10+E9+E8))/(C13*100+100)","v":0.85409992509249022}]
[null,7,2.8199999999999999E-2,2.8783975467801648E-2,{"$f":"(100-C14*100*(E12+E13+E11+E10+E9+E8))/(C14*100+100)","v":0.81984294377962175}]
[null,8,3.0200000000000001E-2,3.098316086353603E-2,{"$f":"(100-C15*100*(E13+E14+E12+E11+E10+E9+E8))/(C15*100+100)","v":0.78340695747794542}]
[null,9,3.2000000000000001E-2,3.3001481169299574E-2,{"$f":"(100-C16*100*(E14+E15+E13+E12+E11+E10+E9+E8))/(C16*100+100)","v":0.74660604494886329}]
[null,10,3.3700000000000001E-2,3.495268140325325E-2,{"$f":"(100-C17*100*(E15+E16+E14+E13+E12+E11+E10+E9+E8))/(C17*100+100)","v":0.70924300192200018}]
[]
[]
[]
[null,"Note:"]
[null,"Using bootstraping on SWAP rates might give a better approximation."]
[null,"However, using bond yields can be used as a starting point."]

{"sheet":"Random Walk","index":27,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":false,"merged":[[5,1,5,2]]}
[]
[]
[null,"Random Walk"]
[]
[]
[null,"Paramenter"]
[null,"Start",100]
[null,"Drift",0.4,null,null,"With F9 you create a new Random walk"]
[null,"Volatility",11]
[null,"Steps",12]
[]
[null,"Drift",{"$f":"LN(1+C8)/C10","v":2.8039353051767742E-2},null,"Volatility",{"$f":"C9/SQRT(C10)","v":3.1754264805429417}]
[null,"Periods","Random Walk"]
[null,0,{"$f":"C7","v":100},null,"Trend","Random number"]
[null,1,{"$f":"C14*EXP(E15)","v":160.40252287409763},null,{"$f":"$C$12+$F$12*F15","v":0.47251623796213532},{"$f":"NORMINV(RAND(),0,1)","v":0.13997391771903656}]
[null,2,{"$f":"C15*EXP(E16)","v":234.40495854493824},null,{"$f":"$C$12+$F$12*F16","v":0.37936378773083884},{"$f":"NORMINV(RAND(),0,1)","v":0.11063850378264807}]
[null,3,212.02773865173339,null,-0.10033310287135663,-4.0426839263863215E-2]
[null,4,618013.19436031335,null,7.9775479774998033,2.5034459695910862]
[null,5,403991.8369324634,null,-0.42511513518307559,-0.14270665405465849]
[null,6,79635.70165030536,null,-1.6239321666511495,-0.52023610996040426]
[null,7,326556.03451643634,null,1.4111390502941297,0.43556344501034594]
[null,8,36091025.748999834,null,4.7051979634184988,1.4729229724024409]
[null,9,434340839.5370661,null,2.4877853302105426,0.77461909202766421]
[null,10,54123649.574372791,null,-2.0825583345498515,-0.66466589622970706]
[null,11,18429344.596919965,null,-1.077327026586429,-0.34810013282033181]
[null,12,58582954.433249615,null,1.1564995649926009,0.3553728038911757]
[null,13,244370959.55504933,null,1.4282436225223614,0.44094998830871479]
[null,14,1055396.9833443533,null,-5.4447704131330417,-1.7234881045802251]
[null,15,177597.85020810895,null,-1.7821505368612254,-0.57006197466851216]
[null,16,189959.17953889031,null,6.7287478745200996E-2,1.2359954145977433E-2]
[null,17,9496.7645734012876,null,-2.9958580351679083,-0.95228071150387417]
[null,18,305.44222680164876,null,-3.4369457979376934,-1.0911873325428116]
[null,19,275.68045822122883,null,-0.10251821549526183,-4.1114971279293026E-2]
[null,20,506.98011263972666,null,0.60922934233196036,0.18302738005158267]
[null,21,36665.600460414986,null,4.2811225000721702,1.3393738362644125]
[null,22,1783.168402648309,null,-3.023447214882629,-0.96096904986842779]
[null,23,56.005419476795211,null,-3.460698600024751,-1.0986675252767957]
[null,24,30.206787765390029,null,-0.6173818028546032,-0.20325495169266691]
[null,25,3777.2154603218937,null,4.8286757068753259,1.5118083769972006]
[null,26,36962.77047390079,null,2.2809241152111097,0.70947470393776479]
[null,27,888.57511015793705,null,-3.7280473017219058,-1.1828605315817133]
[null,28,933.29132638131716,null,4.9098219099843257E-2,6.6318228991007278E-3]
[null,29,57.306259121209408,null,-2.7903075470516208,-0.88754909533333004]
[null,30,555.0256134399234,null,2.2706044110416341,0.70622483994856267]
[null,31,2681.919349151955,null,1.5752737292068795,0.48725246376687076]
[null,32,170891.28469914402,null,4.1544948790785092,1.2994964775003044]
[null,33,19595.57502517484,null,-2.1657238156007494,-0.69085623052353662]
[null,34,238.41108027488349,null,-4.4090626439341403,-1.39732474493544]
[null,35,5.6360105228893689,null,-3.7448199506548527,-1.1881425461506916]
[null,36,26.106373799157371,null,1.5330030302598816,0.47394064590366197]
[null,37,23.510687821568773,null,-0.1047243727019293,-4.180973061955344E-2]
[null,38,28.691083974944785,null,0.19913129292860929,5.3879987751310761E-2]
[null,39,199.0018133838384,null,1.9367275255586218,0.6010808891977566]
[null,40,82.973639221816001,null,-0.87479097955061047,-0.28431781939665951]
[null,41,6.8680174218311567,null,-2.4916474779146314,-0.79349556552654843]
[null,42,12.30958946833665,null,0.58350311049629866,0.17492571811946231]
[null,43,4.6465562710884097E-2,null,-5.5794224178170868,-1.7658924888445466]
[null,44,3.2442525005019547E-2,null,-0.35924138898287994,-0.12196180399945192]
[null,45,8.8340542750941749E-4,null,-3.6034410983297911,-1.1436197542701854]
[null,46,2.9468622539659279E-3,null,1.2047119975109501,0.37055578255995153]
[null,47,0.21228228028336388,null,4.2771759382092736,1.3381309915986399]
[null,48,7.8065867710199592,null,3.604806214378617,1.1263894419357761]
[null,49,2.0052728516771898,null,-1.359187698040456,-0.43686322438648695]
[null,50,0.39419229066428529,null,-1.6266965784935614,-0.52110667391751375]

{"sheet":"Random NO","index":28,"n_rows":104,"n_cols":6,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Random numbers"]
[]
[]
[null,"Random NO Intervall  [-5 ; 5]","Sum of 5 random NO Intervall   [-5 ; 5]","Sum of  10 random NO Intervall [-5 ; 5]",null,"F9 create a new one"]
[null,{"$f":"10*(RAND()-0.5)","v":-3.3027746996827734},{"$f":"2*(RAND()+RAND()+RAND()+RAND()+RAND()-2.5)","v":1.311247229446141},{"$f":"RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()-5","v":-0.14373717311240064}]
[null,{"$f":"10*(RAND()-0.5)","v":0.89539326265184682},{"$f":"2*(RAND()+RAND()+RAND()+RAND()+RAND()-2.5)","v":-0.70430302309464565},{"$f":"RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()-5","v":-0.36280208996309682}]
[null,-0.40601308638608558,-0.85873405102507316,1.2544470878186917]
[null,-4.2391290623761568,0.13043407092471782,0.18272765081061948]
[null,-3.0509792771110034,1.0610074859072771,0.53974148168582481]
[null,-1.1651882641849098,-0.40870305060999357,0.12712397041021539]
[null,0.84083096323907869,-9.2821381849933715E-2,-0.71222467118616617]
[null,4.2917561733396026,1.3869235752704725,1.5800825924169057]
[null,-3.4005469692525847,-3.0295613927726204,-1.7700901616968814]
[null,-3.9472467311665715,1.0830224512413213,-1.4939398545604479]
[null,4.8073837540453059,1.2520692460145053,0.15594065203147256]
[null,-3.4066827814233234,1.4040877991063043,-0.22076438224943917]
[null,-4.9145259240987311,2.3425986671578691E-2,0.72778224869787067]
[null,-3.8046780254160515,0.95754090806871339,0.67119927883954578]
[null,-4.2792011869160902,-3.0159437288606918,0.7689229318154398]
[null,-0.72226251919311091,2.0650340202801791,0.3151625356621377]
[null,3.0786723807950045,1.5958488732970402,0.23300460818435731]
[null,-4.6889063839048708,0.98903987016888451,-1.1486767156752329]
[null,1.2069776534386834,-1.6369399043782416,0.31015400193137133]
[null,-3.4841221416224464,-0.50626261560420005,-1.1283814910925893]
[null,1.5102024709743245,-0.89272917203882951,-1.143547742325016]
[null,4.7892770433512748,-1.5024702924738342E-2,-1.2158148186625573]
[null,-3.21330303111381,0.39174727032815149,-1.120915061658009]
[null,4.3076349952015311,0.81452338742611996,0.15328889718167282]
[null,-0.70053001051623931,-0.1136484430029352,-1.1506206059982085]
[null,-1.5709744332385256,-1.6832569600056875,-0.91282301508610786]
[null,-0.493727208674134,1.8338795430593757,0.62472423196637106]
[null,-1.1988070182994737,-0.13475498146731546,0.87120020890996397]
[null,-0.54411910948548359,-0.12349174374878302,-0.66815635995686051]
[null,1.8061348568740665,-2.4113280534271899,-0.28348685845428889]
[null,4.7109468205446365,-0.13567716756811521,-1.6617500334508328]
[null,3.582002201752601,1.7365027400548039,-1.838061889707034]
[null,2.1288422553164854,-0.30563362774233571,-1.3155384510310411]
[null,-2.3218405443196,-2.011779849737148,-0.16524133445603795]
[null,-1.3827550953999268,-2.5900737123362103,-7.3089028784439236E-2]
[null,-2.0495675506830455,-0.72928962312524881,-1.4533942438592602]
[null,-3.392360675514019,0.3243400680746138,1.1070988371504225]
[null,4.2120538128207707,1.0366221382096494,-0.51334706801156482]
[null,-1.3912641599480546,-0.73242570527048656,-4.5788340914132419E-3]
[null,-4.8229420708012052,-2.4375375088417295,-1.1716279410383201]
[null,-4.4136664686801286,-1.148335328619317,0.99309549448455492]
[null,0.7259006533779766,-0.11779756562071242,-5.7749625710728836E-2]
[null,-2.0762620739114599,-0.48644689100173188,0.3155650897316038]
[null,4.1067976629218306,-1.8106330151754828,0.60579342783908174]
[null,-4.7063556427756836,1.7568403599836859,-1.2049114059852011]
[null,-2.0018681685685715,2.7677308708623407,1.3537286057911659]
[null,-4.2847443114568833,-0.84892541450305981,-0.10061229817140749]
[null,2.5524151711976395,0.2978094886877054,-0.77820059420180154]
[null,2.8968648315986725,1.4612425106679492,0.14063380616019927]
[null,-1.2874076012909141,-0.73222126206985472,0.67720686007750697]
[null,3.555865496545497,-1.4435079724672732,2.0017130895227737]
[null,0.24450642274099099,0.97740417614686592,-0.27489658455766808]
[null,-1.4285819285891199,-1.7438887281404147,-0.89920427604147068]
[null,4.5856647524004011,4.2580125537778457E-2,0.23532925582816144]
[null,2.5752289600998415,6.1372253670676891E-2,1.9161989330944751]
[null,2.3138533823424567,0.20762635306786326,1.960622005050161]
[null,-0.34563250116341204,0.25223038909685158,0.81691751670982971]
[null,0.45280355298270236,-0.61311215268162655,0.55710873617763301]
[null,-2.3463377235284177,-1.8564955429837484,0.23614589853682588]
[null,-2.1614671219616302,-2.7834980718403646,0.24441812398330232]
[null,0.76901281513481967,1.51748453971181,-0.10081252401292051]
[null,-2.4938493977824971,-0.77448571999259563,-0.19866597413822795]
[null,-0.55585186839729572,1.4415314147867413,-1.5383586480705742]
[null,-4.1595472062338938,0.74368121813259158,0.52397663555651697]
[null,-5.7390096186976658E-2,-0.38993012599660837,2.0977421477663709]
[null,{"$f":"10*(RAND()-0.5)","v":-2.2208726812725201},{"$f":"2*(RAND()+RAND()+RAND()+RAND()+RAND()-2.5)","v":-1.7347749856974839},{"$f":"RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()-5","v":-1.1429319163850922}]
[null,0.85824482698211968,-0.46507460520474808,-0.83650637466500832]
[null,-3.3240493889260669,-2.8677172051503135,0.72190442222545759]
[null,-0.73679872634345722,-2.358935736185976,-1.2097864468611688]
[null,-4.4341173441470811,0.45220416207152869,0.33227008153368587]
[null,3.971637449532758,-0.46100053872777025,-0.94089054115075754]
[null,-4.3051019669985466,-1.1689812072441388,-1.7090795816232474]
[null,1.1123371945131977,-1.4743671384970942,-1.08952133301382]
[null,-1.4483699645376824,0.47384779118535114,4.3575341897460262E-2]
[null,-3.5522998254979674,-1.7252377417701155,-0.59320485092008202]
[null,2.0355412118876206,3.0913006628569892,-0.62898942855438911]
[null,0.71099155006327686,-1.3876927391797724,1.3160226107690622]
[null,-3.4304086804846881,1.8057130542819015,-0.36305809831174329]
[null,3.5621464520220014,1.0417572948154836,2.0594989864392232E-2]
[null,-4.2423197937001058,0.81408009419841321,-0.94260826864273639]
[null,-2.971213030835913,-1.3361424076376389,-1.4512849753508581]
[null,-3.8989630017982755,6.0231754398291315E-2,-0.37480855718892236]
[null,4.2193872522921669,-0.76854652066620766,0.62715654850572555]
[null,-3.0500348443356859,-2.2189879695847736E-2,-0.56081752309916588]
[null,-2.2371311450231901,0.69856439263722514,-1.0819143972003542]
[null,2.3691138984426363,-2.2985583051661362,-0.35799687313814132]
[null,-1.6962431164462943,0.40658497777811409,-0.82814706023784446]
[null,3.1441572562978068,-1.2889509406708308,-0.55027787683542773]
[null,3.9896445324506455,-0.15432661409181136,-0.38590961768306986]
[null,-2.4669654414043265,0.12761385128690073,0.38767122171754753]
[null,-2.1606164426127137,-0.97306043139431964,0.25827358113320287]
[null,1.565194928015653,-0.1455368148756726,0.14827108663132815]
[null,3.1329757676101009,1.844189379767835,-0.17559830845922786]
[null,-1.6962716877782258,-0.43412312389649088,-0.23926473123571768]
[null,-3.349935133499129,-0.12685175366597967,-0.82186004805048629]
[null,0.9598983829281782,-1.450395701242897,0.39593793392696774]
[null,0.31773001698167658,-5.2084689828616249E-2,-0.26160335972069859]
[null,3.234901100448575,1.2355031471529463,-0.1276495869509171]
[null,2.1371846980499742,1.3290655356717291,-0.5161027787044512]

{"sheet":"Disclaimer and Help","index":29,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}