{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["1","3","3b"],"not_rendered":{"charts":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"1","index":0,"n_rows":3,"n_cols":8,"rows_kept":3}
["Number of Draws:",null,10000,{"$nulls":4},"#1 is solved in Module 1 Sub Normdraws()"]
["Population Mean:",null,100,null,"Sample Mean:",null,99.95472198230134]
["Population Standard Deviation:",null,20,null,"Sample Std dev:",null,19.942000531097634]

{"sheet":"3","index":1,"n_rows":90,"n_cols":2,"rows_kept":90}
["The plotting part of Question 2 uses the subroutine IRPath() in  Module 2."]
["sigma:",0.025]
["delta-t",0.25]
["T",20]
["Cap:",0.15]
["Floor:",0.005]
[]
[]
["Time (Yrs)","Rate"]
[0,0.04]
[0.25,0.04192008471188644]
[0.5,0.04827764252335288]
[0.75,0.06532774981867795]
[1,0.07749497006533887]
[1.25,0.05246690928010649]
[1.5,0.05382820637791701]
[1.75,0.07107474024190713]
[2,0.06887837306217406]
[2.25,0.0746529672835221]
[2.5,0.07472985618514018]
[2.75,0.07516037635067795]
[3,0.07399876537963238]
[3.25,0.06929924296060724]
[3.5,0.06628856839907517]
[3.75,0.05861825595672938]
[4,0.03870724857018622]
[4.25,0.030032410431744743]
[4.5,0.055470748221867525]
[4.75,0.0361316537499483]
[5,0.03264966012490174]
[5.25,0.028335438669884826]
[5.5,0.02801877841544684]
[5.75,0.015363237221680131]
[6,0.014562422713262796]
[6.25,6.4150216419735315E-3]
[6.5,0.010521889925467712]
[6.75,0.011842522367824774]
[7,0.005]
[7.25,0.024283436752066147]
[7.5,0.02925214622632505]
[7.75,0.029442888073714656]
[8,0.02596675729165971]
[8.25,0.010459159062669475]
[8.5,0.020281130181941068]
[8.75,0.019014396522607852]
[9,0.027591166806124584]
[9.25,0.03063180524482861]
[9.5,0.04269443401858074]
[9.75,0.01669323193580017]
[10,0.006628946645757604]
[10.25,0.005]
[10.5,0.005]
[10.75,0.005]
[11,0.005]
[11.25,0.005]
[11.5,0.006154502387959001]
[11.75,0.011209987296906176]
[12,0.012591880465824658]
[12.25,0.02439171680007579]
[12.5,6.98613120500155E-3]
[12.75,0.005]
[13,0.010808279097975139]
[13.25,0.009370314708942527]
[13.5,0.005]
[13.75,0.005]
[14,0.011713570528063197]
[14.25,0.030048682119422132]
[14.5,0.030996233326858563]
[14.75,0.014209150645772037]
[15,0.02294686295914829]
[15.25,0.01983958766782481]
[15.5,0.018643178564400394]
[15.75,0.018397689464020782]
[16,0.00821416956375536]
[16.25,0.005]
[16.5,0.005]
[16.75,0.007837642128240684]
[17,0.005]
[17.25,0.02322833911985972]
[17.5,0.007060366149916838]
[17.75,0.005295572637491051]
[18,0.005]
[18.25,0.01923141360585011]
[18.5,0.027689607229994428]
[18.75,0.02014037969221124]
[19,0.025765445871432778]
[19.25,0.017593279435886622]
[19.5,0.005]
[19.75,0.005]
[20,0.005]

{"sheet":"3b","index":2,"n_rows":15,"n_cols":4,"rows_kept":15}
["The Monte Carlo part of Question 3 is answered with Subroutine MontePaths() inModule 2."]
["sigma:",0.025]
["delta-t",0.25]
["T",20]
["Cap:",0.15]
["Floor:",0.005]
["Ndraws:",10000]
["y(0):",0.03]
[]
[]
[]
["Mean of means:",null,0.058325166031590596,"  This is the mean of the Ndraws means of the interest rate."]
["Mean of std devs:",null,0.027324761632495077,"  standard deviation of the sample mean."]
[null,null,0.030403385506229536,"  This is the mean of the Ndraws standard deviations of the interest rate."]
[null,null,0.010422948089658973,"  This is the standard deviation of the Ndraws standard deviations of the interest rate."]