{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Spreadsheet17.1"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":17,"defined_names":911,"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":"Spreadsheet17.1","index":0,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Parameters"]
[null,"Mu ",0,null,null,"Mu(t)","Sigma(t)","Normal EE","survival","s'(t)","Sigma'(t)","Mu'(t)","Wrong-way EE"]
[null,"Sigma",0.1,null,9.9999999999999995E-8,{"$f":"E11*Mu","v":0},{"$f":"SQRT(E11)*Sigma","v":3.1622776601683795E-5},{"$f":"F11*NORMSDIST(F11/G11)+G11*NORMDIST(F11/G11,0,1,FALSE)","v":1.2615662610100801E-5},{"$f":"EXP(-Spread*E11/10000/LGD)","v":0.99999999833333331},{"$f":"NORMSINV(I11)","v":5.9142785650470753},{"$f":"SQRT(1-Correlation^2)*G11","v":2.7386127875258307E-5},{"$f":"F11+Correlation*G11*J11","v":9.3512954911305338E-5},{"$f":"L11*NORMSDIST(L11/K11)+K11*NORMDIST(L11/K11,0,1,FALSE)","v":9.3515196914531815E-5}]
[null,"Spread",100,null,0.05,0,2.2360679774997897E-2,{"$f":"F12*NORMSDIST(F12/G12)+G12*NORMDIST(F12/G12,0,1,FALSE)","v":8.920620580763856E-3},0.99916701379245831,3.1441022074427916,1.9364916731037084E-2,3.5152131320246138E-2,3.5418143384872272E-2]
[null,"LGD",0.6,null,0.1,0,3.1622776601683798E-2,{"$f":"F13*NORMSDIST(F13/G13)+G13*NORMDIST(F13/G13,0,1,FALSE)","v":1.2615662610100803E-2},0.99833472145093871,2.9354579866460782,2.738612787525831E-2,4.6413666067668717E-2,4.6920894714965515E-2]
[null,"Correlation",0.5,null,0.15,0,3.8729833462074176E-2,1.5450968080927587E-2,0.99750312239746008,2.8074363201932515,3.3541019662496847E-2,5.436577056823149E-2,5.5107764309742714E-2]
[null,null,null,null,0.2,0,4.4721359549995794E-2,1.7841241161527712E-2,0.99667221605452327,2.7136039725271401,3.8729833462074169E-2,6.0678029465841575E-2,6.1651286396035267E-2]
[null,null,null,null,0.25,0,0.05,1.9947114020071637E-2,0.99584200184510996,2.6389633811680153,4.3301270189221933E-2,6.597408452920038E-2,6.717636125304613E-2]
[null,null,null,null,0.3,0,5.4772255750516613E-2,2.1850968611841583E-2,0.99501247919268232,2.5766932943916601,4.7434164902525687E-2,7.05656520555306E-2,7.19953883929038E-2]
[null,null,null,null,0.35,0,5.9160797830996162E-2,2.3601743597065742E-2,0.99418364752118304,2.5230947602990956,5.1234753829797988E-2,7.4634149511250261E-2,7.6290206775738945E-2]
[null,null,null,null,0.4,0,6.3245553203367597E-2,2.5231325220201606E-2,0.99335550625503444,2.475929342094672,5.477225575051662E-2,7.8295760466613754E-2,8.0177281907081607E-2]
[null,null,null,null,0.5,0,7.0710678118654766E-2,2.8209479177387822E-2,0.99170129263887596,2.395506615560175,6.1237243569579464E-2,8.4693948611991796E-2,8.7024573686969253E-2]
[null,null,null,null,0.6,0,7.7459666924148352E-2,3.0901936161855173E-2,0.99004983374916811,2.3282217375371772,6.7082039324993695E-2,9.017164015759585E-2,9.2949751545537598E-2]
[null,null,null,null,0.8,0,8.9442719099991588E-2,3.5682482323055424E-2,0.98675516180719569,2.2189566131495364,7.7459666924148338E-2,9.9234756522501341E-2,0.1029053245019929]
[null,null,null,null,1,0,0.1,3.9894228040143274E-2,0.98347145382161749,2.1313891941426215,8.6602540378443865E-2,0.10656945970713108,0.11113130894272015]
[null,null,null,null,1.2,0,0.10954451150103323,4.3701937223683165E-2,0.98019867330675525,2.0578695923363037,9.4868329805051374E-2,0.11271415961265539,0.11816759318543202]
[null,null,null,null,1.4,0,0.11832159566199232,4.7203487194131484E-2,0.97693678389834759,1.9942345120077234,0.10246950765959598,0.11798050479248422,0.12432666260154597]
[null,null,null,null,1.6,0,0.12649110640673519,5.0462650440403212E-2,0.973685749353145,1.9379567342638262,0.10954451150103324,0.12256714574270734,0.12980767800856935]
[null,null,null,null,1.8,0,0.13416407864998739,5.352372348458314E-2,0.97044553354850815,1.8873822342171682,0.1161895003862225,0.12660944925705053,0.13474633244135162]
[null,null,null,null,2,0,0.14142135623730953,5.6418958354775645E-2,0.9672161004820059,1.8413669747940886,0.12247448713915893,0.13020430745298589,0.13923973277573617]
[null,null,null,null,2.2000000000000002,0,0.14832396974191328,5.9172702727031991E-2,0.96399741427101526,1.799085408325908,0.12845232578665131,0.13342374483382485,0.14336004710713243]
[null,null,null,null,2.4,0,0.1549193338482967,6.1803872323710346E-2,0.96078943915232318,1.7599214745707923,0.13416407864998739,0.13632293123290959,0.14716254157167274]
[null,null,null,null,2.6,0,0.16124515496597103,6.4327509825806886E-2,0.95759213948172861,1.7234027329629276,0.13964240043768944,0.13894517037269263,0.15069058377313649]
[null,null,null,null,2.8,0,0.16733200530681513,6.6755811781245469E-2,0.95440547973364664,1.6891585992173552,0.14491376746189441,0.14132514784414546,0.15397890039961287]
[null,null,null,null,3,0,0.17320508075688773,6.9098829894267105E-2,0.95122942450071402,1.6568927965620148,0.15,0.14349112531701466,0.15705577788901731]
[null,null,null,null,3.2,0,0.17888543819998318,7.1364964646110848E-2,0.94806393849339554,1.6263645708801753,0.15491933384829668,0.14546646946741387,0.15994459580008225]
[null,null,null,null,3.4,0,0.18439088914585777,7.3561321801096285E-2,0.94490898653959177,1.5973755153441924,0.15968719422671313,0.1472707457870692,0.16266492375110347]
[null,null,null,null,3.6,0,0.18973665961010278,7.5693975660604818E-2,0.94176453358424872,1.5697601021732448,0.16431676725154984,0.14892051908778256,0.16523332417184511]
[null,null,null,null,3.8,0,0.19493588689617927,7.7768167250437517E-2,0.93863054468896767,1.5433787329703086,0.16881943016134129,0.15042995106413426,0.16766395150731458]
[null,null,null,null,4,0,0.2,7.9788456080286549E-2,0.93550698503161778,1.5181125419669601,0.17320508075688773,0.15181125419669603,0.16996900733652082]
[null,null,null,null,4.2,0,0.20493901531919201,8.1758838114662613E-2,0.93239381990594827,1.4938594455092422,0.1774823934929885,0.15307504189396914,0.17215909142590241]
[null,null,null,null,4.4000000000000004,0,0.20976176963403034,8.3682838718840066E-2,0.92929101472120357,1.4705310944665266,0.18165902124584951,0.15423060233858304,0.17424347626627662]
[null,null,null,null,4.5999999999999996,0,0.21447610589527219,8.556358677747905E-2,0.92619853500173854,1.4480504919701216,0.18574175621006711,0.1552861153287424,0.17623032444251224]
[null,null,null,null,4.8,0,0.21908902300206645,8.7403874447366331E-2,0.92311634638663576,1.4263501089171913,0.18973665961010275,0.15624882591077927,0.17812686267313663]
[null,null,null,null,5,{"$f":"E43*Mu","v":0},{"$f":"SQRT(E43)*Sigma","v":0.22360679774997899},8.9206205807638564E-2,{"$f":"EXP(-Spread*E43/10000/LGD)","v":0.92004441462932329},1.4053703770327861,{"$f":"SQRT(1-Correlation^2)*G43","v":0.19364916731037085},{"$f":"F43+Correlation*G43*J43","v":0.15712518483049095},0.17993952257737494]
[null,null,null,null,5.2,0,0.22803508501982761,9.0972836829344608E-2,0.9169827055971943,1.3850584719139782,0.19748417658131498,0.15792096320016827,0.18167405558831434]
[null,null,null,null,5.4,0,0.23237900077244503,9.2705808485565505E-2,0.91393118527122819,1.3653673213500115,0.20124611797498107,0.15864134691133275,0.18333562755832694]
[null,null,null,null,5.6,0,0.23664319132398465,9.4406974388262968E-2,0.91088981974561212,1.3462547904912792,0.20493901531919195,0.15929101497852932,0.18492889725415051]
[null,null,null,null,5.8,0,0.24083189157584595,9.6078024018658573E-2,0.90785857522736457,1.3276830071932519,0.20856653614614212,0.15987420501772917,0.18645808195428404]
[null,null,null,null,6,0,0.2449489742783178,9.7720502380583982E-2,0.90483741803595952,1.3096177994584928,0.21213203435596423,0.16039476833699276,0.18792701263328856]
[null,null,null,null,6.2,0,0.24899799195977465,9.9335826727810106E-2,0.90182631460295293,1.292028223264621,0.21563858652847823,0.16085621657412302,0.18933918067305755]
[null,null,null,null,6.4,0,0.25298221281347039,0.10092530088080642,0.89882523147160887,1.274886163830695,0.21908902300206648,0.16126176140558288,0.19069777762946405]
[null,null,null,null,6.6,0,0.25690465157330261,0.10249012754438885,0.89583413529652822,1.2581659969785801,0.22248595461286991,0.16161434853757953,0.19200572926850995]
[null,null,null,null,6.8,0,0.26076809620810598,0.104031418957202,0.89285299284327846,1.2418442999981492,0.22583179581272431,0.1619166869487027,0.19326572484389715]
[null,null,null,null,7,0,0.26457513110645908,0.10555020614111882,0.88988177098802379,1.2258996035462162,0.229128784747792,0.16217127416579818,0.19448024239970002]
[null,null,null,null,7.2,0,0.26832815729997478,0.10704744696916628,0.88692043671715748,1.210312177757255,0.232379000772445,0.16238041820766189,0.19565157073431311]
[null,null,null,null,7.4,0,0.27202941017470889,0.10852403323135507,0.88396895712693502,1.1950638470348554,0.23558437978779492,0.16254625671500511,0.19678182854539136]
[null,null,null,null,7.6,0,0.27568097504180444,0.10998079684646792,0.8810272994231082,1.1801378290114515,0.23874672772626643,0.16267077369279762,0.19787298118290597]
[null,null,null,null,7.8,0,0.27928480087537882,0.11141851534268368,0.8780954309205613,1.1655185939731532,0.24186773244895649,0.16275581421717178,0.19892685536331667]
[null,null,null,null,8,0,0.28284271247461906,0.11283791670955129,0.87517331904294748,1.1511917416937578,0.24494897427831785,0.16280309739952173,0.19994515213815561]
[null,null,null,null,8.1999999999999993,0,0.28635642126552707,0.11423968370726269,0.87226093132232685,1.1371438931428837,0.24799193535274489,0.16281422785217256,0.20092945836193371]
[null,null,null,null,8.4,0,0.28982753492378882,0.11562445770562219,0.86935823539880586,1.1233625949548109,0.2509980079602227,0.16279070586067176,0.20188125686485811]
[null,null,null,null,8.6,{"$f":"E61*Mu","v":0},{"$f":"SQRT(E61)*Sigma","v":0.29325756597230362},{"$f":"F61*NORMSDIST(F61/G61)+G61*NORMDIST(F61/G61,0,1,FALSE)","v":0.11699284211396441},0.86646519902017771,{"$f":"NORMSINV(I61)","v":1.109836234887783},{"$f":"SQRT(1-Correlation^2)*G61","v":0.25396850198400589},{"$f":"F61+Correlation*G61*J61","v":0.16273393643552855},{"$f":"L61*NORMSDIST(L61/K61)+K61*NORMDIST(L61/K61,0,1,FALSE)","v":0.2028019355035407}]
[null,null,null,null,8.8000000000000007,0,0.29664793948382656,0.11834540545406398,0.8635817900415641,1.0965539667843489,0.25690465157330261,0.16264523738969675,0.20369279523628547]
[null,null,null,null,9,0,0.30000000000000004,0.11968268412042983,0.86070797642505781,1.0835056437742632,0.25980762113533162,0.1625258465661395,0.20455505734752982]
[null,null,null,null,9.1999999999999993,0,0.30331501776206204,0.12100518486599809,0.85784372623936678,1.070681758652291,0.26267851073127396,0.16237692832156772,0.20538986992772718]
[null,null,null,null,9.4,0,0.30659419433511786,0.12231338704589194,0.85498900765945951,1.058073390521632,0.26551836094703507,0.16219957935720314,0.2061983136996825]
[null,null,null,null,9.6,0,0.30983866769659341,0.12360774464742069,0.85214378896621135,1.0456721569257323,0.26832815729997478,0.16199483397464604,0.20698140726955216]
[null,null,null,null,9.8000000000000007,0,0.31304951684997057,0.12488868813069399,0.84930803854605186,1.0334701708017888,0.27110883423451915,0.16176366882417828,0.20774011186994695]
[null,null,null,null,10,0,0.316227766016838,0.12615662610100803,0.84648172489061402,1.0214600016820803,0.27386127875258309,0.16150700720373992,0.20847533565346685]