{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Spreadsheet10.1","Spreadsheet10.2","Spreadsheet10.3 (new)"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":20,"defined_names":1617,"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":"Spreadsheet10.1","index":0,"n_rows":98,"n_cols":19,"rows_kept":98,"cut":false,"hidden":false,"merged":[[17,3,17,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7]
[null,1,"AAA","AA","A","BBB","BB","B","CCC","Def",null,null,{"$f":"TRANSPOSE(B11:B17)","v":"AAA"},"AA","A","BBB","BB","B","CCC"]
[null,"AAA",0.93400000000000005,5.9400000000000001E-2,6.4000000000000003E-3,0,2.0000000000000001E-4,0,0,{"$f":"1-SUM(C11:I11)","v":0},null,1,{"$f":"OFFSET($J$10,($L11-1)*9+M$9,0,1,1)","v":0},{"$f":"OFFSET($J$10,($L11-1)*9+N$9,0,1,1)","v":1.9999999999997797E-4},0,1.4999999999999458E-3,1.2900000000000023E-2,6.8100000000000049E-2,0.24050000000000005]
[null,"AA",1.61E-2,0.90549999999999997,7.46E-2,2.5999999999999999E-3,8.9999999999999998E-4,1E-4,0,1.9999999999997797E-4,null,{"$f":"L11+1","v":2},{"$f":"OFFSET($J$10,($L12-1)*9+M$9,0,1,1)","v":1.4459999999827389E-5},4.0342000000004319E-4,2.3783000000010546E-4,4.1176699999998512E-3,2.8790800000000005E-2,0.13087470000000001,0.40997823]
[null,"A",6.9999999999999999E-4,2.2800000000000001E-2,0.9244,4.6300000000000001E-2,4.4999999999999997E-3,1.1999999999999999E-3,1E-4,0,null,{"$f":"L12+1","v":3},4.4749059999849017E-5,6.3297686599983471E-4,7.4731233400004982E-4,7.7851100049997068E-3,4.6854402061999978E-2,0.18800417829799998,0.53016036387400001]
[null,"BBB",5.0000000000000001E-4,2.5999999999999999E-3,5.5100000000000003E-2,0.88480000000000003,4.7600000000000003E-2,7.1000000000000004E-3,8.0000000000000004E-4,1.4999999999999458E-3,null,4,9.354812723028072E-5,9.1084117784390184E-4,1.5551951712919898E-3,1.2420337851574925E-2,6.6409768469099517E-2,0.23958170073431373,0.61605032519966851]
[null,"BB",2.0000000000000001E-4,5.0000000000000001E-4,4.1999999999999997E-3,5.16E-2,0.86909999999999998,5.91E-2,2.3999999999999998E-3,1.2900000000000023E-2,null,5,1.6471311958687895E-4,1.2583102112742051E-3,2.6814637529263274E-3,1.7932596460640049E-2,8.6902424453446758E-2,0.28592874578213279,0.6780201647764269]
[null,"B",0,4.0000000000000002E-4,1.2999999999999999E-3,5.4000000000000003E-3,6.3500000000000001E-2,0.84219999999999995,1.9099999999999999E-2,6.8100000000000049E-2,null,6,2.6312753315349546E-4,1.6955187808863625E-3,4.139806502790222E-3,2.4226929595127955E-2,0.10788978058653886,0.32747850404558665,0.72324852865255007]
[null,"CCC",0,0,0,6.1999999999999998E-3,2.0500000000000001E-2,4.0800000000000003E-2,0.69199999999999995,0.24050000000000005,null,7,3.9454764928503749E-4,2.2411968443643016E-3,5.93818905927046E-3,3.1207880314234604E-2,0.12902518150493869,0.36470432944748177,0.75671105225813839]
[null,null,null,null,null,null,null,null,null,null,null,8,5.6544404326774877E-4,2.9124784486630473E-3,8.0794919136797372E-3,3.8782319325339265E-2,0.15004238416792326,0.39807740506257472,0.78186248988288853]
[null,{"$f":"B10+1","v":2},"AAA","AA","A","BBB","BB","B","CCC","Def",null,9,7.8284318134391739E-4,3.7247628976248004E-3,1.0562173893047477E-2,4.6861488363735826E-2,0.17074135156651715,0.42804314835035084,0.80110672038077158]
[null,"AAA",{"$f":"MMULT(C11:I17,$C$11:$I$17)","v":0.87331686000000008},0.10941232000000001,1.6325839999999998E-2,4.6108000000000005E-4,4.4287999999999999E-4,2.544E-5,1.1199999999999999E-6,{"$f":"1-SUM(C20:I20)","v":1.4459999999827389E-5},null,10,1.0541726307228272E-3,4.6916261524309055E-3,1.3380931574374588E-2,5.5362376555023185E-2,0.19097574772288439,0.45500942649279619,0.81612074989115702]
[null,"AA",2.9669649999999999E-2,0.82259472,0.13676075000000001,8.1557399999999999E-3,2.06617E-3,3.3593999999999996E-4,1.361E-5,{"$f":"1-SUM(C21:I21)","v":4.0342000000004319E-4}]
[null,"A",1.6920100000000001E-3,4.1886410000000006E-2,0.85879230999999989,8.4064540000000007E-2,1.0373539999999999E-2,2.7209599999999997E-3,2.3240000000000001E-4,2.3783000000010546E-4]
[null,"BBB",9.9935000000000019E-4,5.9673999999999994E-3,0.10009323000000002,0.78792839000000015,8.4203280000000019E-2,1.5173880000000001E-2,1.5168E-3,4.1176699999998512E-3]
[null,"BB",3.9741000000000006E-4,1.15274E-3,1.0491269999999999E-2,9.103101999999999E-2,0.76161241000000002,0.10160719999999999,4.9171499999999995E-3,2.8790800000000005E-2]
[null,"B",2.2750000000000001E-5,7.7450999999999996E-4,2.8906599999999998E-3,1.2782050000000001E-2,0.10932235,0.71387290999999997,2.9460069999999998E-2,0.13087470000000001]
[null,"CCC",7.2000000000000005E-6,4.269E-5,4.8076E-4,1.105428E-2,3.4888469999999998E-2,6.385093E-2,0.47969743999999997,0.40997823]
[]
[null,{"$f":"B19+1","v":3},"AAA","AA","A","BBB","BB","B","CCC","Def"]
[null,"AAA",{"$f":"MMULT(C20:I26,$C$11:$I$17)","v":0.81745123279600007},0.15132153682000002,2.8870292147999996E-2,1.4713189360000001E-3,7.5509355600000003E-4,8.1451380000000003E-5,4.3253039999999992E-6,{"$f":"1-SUM(C29:I29)","v":4.4749059999849017E-5}]
[null,"AA",4.1055451721000003E-2,0.74976241365500007,0.18843558508200001,1.5795480579000001E-2,3.5672253190000003E-3,7.0987272899999986E-4,4.0994048999999995E-5,{"$f":"1-SUM(C30:I30)","v":6.3297686599983471E-4}]
[null,"A",2.8999701360000003E-3,5.7833957275E-2,0.80168222868399985,0.114802702339,1.7097262443999998E-2,4.5457482929999998E-3,3.90818495E-4,7.4731233400004982E-4]
[null,"BBB",1.5103381520000004E-3,9.841752740000001E-3,0.13676597980100003,0.70624510362100024,0.11213708785700002,2.3532741209000001E-2,2.1818866150000002E-3,7.7851100049997068E-3]
[null,"BB",5.9492193500000016E-4,1.964742917E-3,1.8133338499999999E-2,0.12091135498699998,0.67285160852100001,0.13144452203099999,7.245109046999999E-3,4.6854402061999978E-2]
[null,"B",6.3997068000000003E-5,1.1420208719999999E-3,4.8215297579999993E-3,2.1124008532000003E-2,0.14156905076400003,0.60898098534099998,3.4294229366999995E-2,0.18800417829799998]
[null,"CCC",2.0253475E-5,1.2177053799999999E-4,1.2862739089999999E-3,1.4922361328000001E-2,4.4738287861000002E-2,7.5487883943999995E-2,0.33326280507099998,0.53016036387400001]
[]
[null,{"$f":"B28+1","v":4},"AAA","AA","A","BBB","BB","B","CCC","Def"]
[null,"AAA",{"$f":"MMULT(C29:I35,$C$11:$I$17)","v":0.76595682405694898},0.18624073303613042,4.3292319551380409E-2,3.0713829985836E-3,1.1611433665984002E-3,1.7362372250400002E-4,1.0425140623999999E-5,{"$f":"1-SUM(C38:I38)","v":9.354812723028072E-5}]
[null,"AA",5.0557482862170197E-2,0.68568802654795602,0.23127112196026861,2.4837947383399599E-2,5.4290150921020011E-3,1.2235972414906999E-3,8.196773476889999E-5,{"$f":"1-SUM(C39:I39)","v":9.1084117784390184E-4}]
[null,"A",4.2616971828886002E-3,7.1128115309206694E-2,0.75181137209099946,0.13975487536409298,2.4280706801822496E-2,6.6377240741561988E-3,5.7031400554149992E-4,1.5551951712919898E-3]
[null,"BBB",2.0403942083246007E-3,1.4021404441588304E-2,0.16658600618870947,0.63717039933873409,0.13323927428545823,3.1715041099204797E-2,2.8071425864056006E-3,1.2420337851574925E-2]
[null,"BB",7.950087844014001E-4,2.9312263281216001E-3,2.6571905725604399E-2,0.1433009118913742,0.59910945262367654,0.1516441340681163,9.2375921096060978E-3,6.6409768469099517E-2]
[null,"B",1.2041068280060002E-4,1.5171315456191997E-3,7.092824610846901E-3,2.9722813393515405E-2,0.16343922659840202,0.52280560181089009,3.5720290623612094E-2,0.23958170073431373]
[null,"CCC",3.8186481284300001E-5,2.3215576066009999E-4,2.3065024731705997E-3,1.8045536006765301E-2,5.1223620390377096E-2,7.992455558829209E-2,0.23217911809978206,0.61605032519966851]
[]
[null,{"$f":"B37+1","v":5},"AAA","AA","A","BBB","BB","B","CCC","Def"]
[null,"AAA",{"$f":"MMULT(C38:I44,$C$11:$I$17)","v":0.71843422201493068},0.21513451961593896,5.8989438267956787E-2,5.2671371799594899E-3,1.6822098149301638E-3,3.0765649385150652E-4,2.010349284547548E-5,{"$f":"1-SUM(C47:I47)","v":1.6471311958687895E-4}]
[null,"AA",5.8435660782771362E-2,0.62923438671152077,0.26665588325149375,3.4754510464429171E-2,7.6479728446798958E-3,1.877156247734522E-3,1.3611948609634249E-4,{"$f":"1-SUM(C48:I48)","v":1.2583102112742051E-3}]
[null,"A",5.7265893648022906E-3,8.2179110627802254E-2,0.7081189662673828,0.15994117747757555,3.1635900082241639E-2,8.9500958717933336E-3,7.6669655547584965E-4,2.6814637529263274E-3]
[null,"BBB",2.5933160609433042E-3,1.835169077079838E-2,0.19076008292411095,0.57858156913209835,0.1489616801935246,3.9424595324721833E-2,3.3944691331624453E-3,1.7932596460640049E-2]
[null,"BB",9.9980362899201088E-4,4.0400831633079894E-3,3.5396104513569462E-2,0.15982074641546556,0.53744829251405635,0.16454856800423104,1.0843977306930923E-2,8.6902424453446758E-2]
[null,"B",1.8940362486426048E-4,1.9107525790905474E-3,9.674374763990138E-3,3.8109167756206E-2,0.17742356663825454,0.45164321907232208,3.5120769783139626E-2,0.28592874578213279]
[null,"CCC",6.0285925078841298E-5,3.6957360070239277E-4,3.4630442613014967E-3,2.0588326872810342E-2,5.5222893034710958E-2,7.9943599024193901E-2,0.16233211250477517,0.6780201647764269]
[]
[null,{"$f":"B46+1","v":6},"AAA","AA","A","BBB","BB","B","CCC","Def"]
[null,"AAA",{"$f":"MMULT(C47:I53,$C$11:$I$17)","v":0.67452549174510235},0.23883891821660191,7.547453541242434E-2,8.0395117328088336E-3,2.335432973147917E-3,4.8904457355306128E-4,3.3937813208228469E-5,{"$f":"1-SUM(C56:I56)","v":2.6312753315349546E-4}]
[null,"AA",6.4915146765241127E-2,0.57941750613204168,0.29576110727102978,4.513858364225809E-2,1.0201107323442886E-2,2.6681573848657187E-3,2.0287270023432283E-4,{"$f":"1-SUM(C57:I57)","v":1.6955187808863625E-3}]
[null,"A",7.2536991929753603E-3,9.1333701562472058E-2,0.66970964902633057,0.17620102413856628,3.8953651042296145E-2,1.1432276688222666E-2,9.7619184634671922E-4,4.139806502790222E-3]
[null,"BBB",3.1702346009825316E-3,2.2715391615617801E-2,0.21028098949925333,0.52872923982483599,0.16045158292529418,4.6484200231974963E-2,3.9414317069131483E-3,2.4226929595127955E-2]
[null,"BB",1.2110392332778394E-3,5.2747923369858242E-3,4.4305267054008619E-2,0.17174686710385795,0.48553803266228712,0.17196603896814927,1.2068182054894475E-2,0.10788978058653886]
[null,"B",2.6897746168712407E-4,2.3304656874165949E-3,1.2518876665473407E-2,4.5983561333149389E-2,0.18545743058663336,0.39257495471422632,3.3387229505827148E-2,0.32747850404558665]
[null,"CCC",8.602006202120472E-5,5.3030582453971386E-4,4.6994737758490942E-3,2.2665507270574016E-2,5.7394375912598772E-2,7.7365691997992939E-2,0.1140100965038742,0.72324852865255007]
[]
[null,{"$f":"B55+1","v":7},"AAA","AA","A","BBB","BB","B","CCC","Def"]
[null,"AAA",{"$f":"MMULT(C56:I62,$C$11:$I$17)","v":0.63390943489046259},0.2580785401270167,9.2356428654282841E-2,1.1352171754701179E-2,3.1336511451358151E-3,7.2281595895783786E-4,5.2409820158002072E-5,{"$f":"1-SUM(C65:I65)","v":3.9454764928503749E-4}]
[null,"AA",7.0191011215836624E-2,0.53538539290028409,0.31957501967213497,5.568088658777133E-2,1.3053349608060994E-2,3.5916238217174154E-3,2.8151934983025899E-4,{"$f":"1-SUM(C66:I66)","v":2.2411968443643016E-3}]
[null,"A",8.8101156379909607E-3,9.8885088893638229E-2,0.63582666109544284,0.18922548560913122,4.6085092864270885E-2,1.4034065051123441E-2,1.1953017891319796E-3,5.93818905927046E-3]
[null,"BBB",3.7703685514760854E-3,2.7025021098923269E-2,0.22596591163201746,0.48616945446581167,0.16861587095287839,5.2801078729213254E-2,4.4444142554451206E-3,3.1207880314234604E-2]
[null,"BB",1.4300295275291664E-3,6.6165175668171971E-3,5.308310698942046E-2,0.18008387816271268,0.44152785949023321,0.17529057413329208,1.2942852625056601E-2,0.12902518150493869]
[null,"B",3.5759192723291386E-4,2.7809602857979312E-3,1.5570986664648579E-2,5.3168447264632511E-2,0.18904130443112943,0.34329109895586185,3.1085281023215092E-2,0.36470432944748177]
[null,"CCC",1.1498192216379575E-4,7.1102330155311882E-4,5.9748061303414347E-3,2.4359592396172785E-2,5.8231900783166701E-2,7.3367622855236847E-2,8.0529020353226885E-2,0.75671105225813839]
[]
[null,{"$f":"B64+1","v":8},"AAA","AA","A","BBB","BB","B","CCC","Def"]
[null,"AAA",{"$f":"MMULT(C65:I71,$C$11:$I$17)","v":0.59629742899990146},0.2734814366893431,0.1093235677840337,1.5157432965735502E-2,4.0854493025050554E-3,1.0133286918304837E-3,7.5911523382947318E-5,{"$f":"1-SUM(C74:I74)","v":5.6544404326774877E-4}]
[null,"AA",7.4432262928271986E-2,0.49639986341541353,0.33893163099737239,6.6149466913602836E-2,1.6162888249672332E-2,4.6401673916296529E-3,3.7124165537411882E-4,{"$f":"1-SUM(C75:I75)","v":2.9124784486630473E-3}]
[null,"A",1.0369606361215361E-2,0.1050812591700985,0.60582950381983547,0.19958377092096682,5.2927332718817374E-2,1.6708268337359881E-2,1.4207667580268869E-3,8.0794919136797372E-3]
[null,"BBB",4.3916111063372221E-3,3.1216608230821931E-2,0.23848785064676237,0.44970848020945986,0.1741716216643043,5.8341263303456251E-2,4.9002455135187554E-3,3.8782319325339265E-2]
[null,"BB",1.6576791974099957E-3,8.0455934926684774E-3,6.1577684943478747E-2,0.18562281853394325,0.40394525007295257,0.17559504333313292,1.3513546258490716E-2,0.15004238416792326]
[null,"B",4.5405649582068441E-4,3.2644940499076034E-3,1.8773401649990581E-2,5.9572641304415024E-2,0.18933549263819785,0.30195684335385886,2.8565665445234686E-2,0.39807740506257472]
[null,"CCC",1.4684913110194921E-4,9.0868504526839071E-4,7.259054443515562E-3,2.5732080706572215E-2,5.8106100082199054E-2,6.8697495311076662E-2,5.7287245397377597E-2,0.78186248988288853]
[]
[null,{"$f":"B73+1","v":9},"AAA","AA","A","BBB","BB","B","CCC","Def"]
[null,"AAA",{"$f":"MMULT(C74:I80,$C$11:$I$17)","v":0.56142977212039857},0.28559194293210916,0.12613037555296702,1.9400781422265947E-2,5.1954091899852799E-3,1.3641268672582032E-3,1.0474873367196568E-4,{"$f":"1-SUM(C83:I83)","v":7.8284318134391739E-4}]
[null,"AA",7.7785330828799099E-2,0.46182092005239322,0.35453494796269913,7.6373586121075421E-2,1.948498055532907E-2,5.8043414909503604E-3,4.7113009112884963E-4,{"$f":"1-SUM(C84:I84)","v":3.7247628976248004E-3}]
[null,"A",1.1911478618691865E-2,0.11013201226156151,0.57917530206986001,0.2077449215827846,5.9412312941438693E-2,1.9412224545173769E-2,1.6495740874420981E-3,1.0562173893047477E-2]
[null,"BBB",5.0309822257255232E-3,3.5244687812169995E-2,0.24840133613579282,0.41835789397757589,0.17768597389675322,6.3110722102569169E-2,5.3069154856775665E-3,4.6861488363735826E-2]
[null,"BB",1.8945112643548956E-3,9.5425522392067561E-3,6.9685883291028011E-2,0.1889866073193629,0.37161644810280037,0.17370328225469492,1.3829363962035003E-2,0.17074135156651715]
[null,"B",5.5744192163487225E-4,3.7813432267149905E-3,2.2070775204261366E-2,6.5164954707073036E-2,0.18723449923591429,0.26710908052234933,2.6038756831701312E-2,0.42804314835035084]
[null,"CCC",1.8135551615822848E-4,1.1204790461927562E-3,8.5301876775836227E-3,2.6830623971412591E-2,5.7295051037334434E-2,6.3819920184913129E-2,4.1115662185633742E-2,0.80110672038077158]
[]
[null,{"$f":"B82+1","v":10},"AAA","AA","A","BBB","BB","B","CCC","Def"]
[null,"AAA",{"$f":"MMULT(C83:I89,$C$11:$I$17)","v":0.52907246817709552},0.29488179073862392,0.14258580578536081,2.4024285683581968E-2,6.4644821208785664E-3,1.7778512721216646E-3,1.3914359161470606E-4,{"$f":"1-SUM(C92:I92)","v":1.0541726307228272E-3}]
[null,"AA",8.0377074059687401E-2,0.43109332412301116,0.36697933980747383,8.6230740930007849E-2,2.2974616311588231E-2,7.0730773532365118E-3,5.8020126256423579E-4,{"$f":"1-SUM(C93:I93)","v":4.6916261524309055E-3}]
[null,"A",1.3419624062097926E-2,0.11421488366239108,0.55540324359672488,0.21409559505382672,6.5498181938229524E-2,2.2108558336499773E-2,1.8789817758554173E-3,1.3380931574374588E-2]
[null,"BBB",5.68497394966677E-3,3.9078273422155203E-2,0.25616349210822353,0.39129797967119556,0.17960757071605751,6.7141560483282459E-2,5.6637730943957946E-3,5.5362376555023185E-2]
[null,"BB",2.1407053235426624E-3,1.1088807876723457E-2,7.7341395195622761E-2,0.1906657656912133,0.34360383161301811,0.17024605667457121,1.3937689902424208E-2,0.19097574772288439]
[null,"B",6.6700930060078437E-4,4.3302217806579805E-3,2.5412096137660226E-2,6.9954789796915398E-2,0.18342540944391639,0.23757674204248655,2.3624305004966456E-2,0.45500942649279619]
[null,"CCC",2.1827121830297051E-4,1.3437896889545511E-3,9.7720263927297182E-3,2.7693566332974002E-2,5.6007133110927997E-2,5.9013639016528903E-2,2.9830824348424878E-2,0.81612074989115702]

{"sheet":"Spreadsheet10.2","index":1,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":false,"merged":[[10,1,10,2],[8,5,8,6],[8,12,8,13],[9,5,9,6],[9,12,9,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Price CDS"]
[null,null,null,null,null,"Market Premium",null,null,null,null,null,null,"Price CDS"]
[null,"Inputs",null,null,null,"Running","Up-front","Hazard Rate","Risky Annuity","Default Leg","MTM",null,"Premium","MTM"]
[null,"Interest Rate",0.05,null,"1Y CDS",300,0,4.9442860581613443E-2,{"$f":"SUM($G$32:$G$51)","v":0.94010328019388978},{"$f":"SUM($H$32:$H$51)","v":2.8203098405816692E-2},{"$f":"J12-I12*F12/10000-G12","v":-3.4694469519536142E-18},null,500,{"$f":"J12-M12*I12/10000","v":-1.8802065603877798E-2}]
[null,"Recovery",0.4,null,"2Y CDS",350,0,6.6737903612969246E-2,{"$f":"SUM($G$32:$G$71)","v":1.7821904179800345},{"$f":"SUM($H$32:$H$71)","v":6.237666462930104E-2},{"$f":"J13-I13*F13/10000-G13","v":-1.6653345369377348E-16},null,500,{"$f":"J13-M13*I13/10000","v":-2.6732856269700678E-2}]
[null,null,null,null,"3Y CDS",400,0,8.5363306886951248E-2,{"$f":"SUM($G$32:$G$91)","v":2.5229588602275124},{"$f":"SUM($H$32:$H$91)","v":0.10091835440910034},{"$f":"J14-I14*F14/10000-G14","v":-1.5265566588595902E-16},null,500,{"$f":"J14-M14*I14/10000","v":-2.5229588602275296E-2}]
[null,null,null,null,"4Y CDS",450,0,0.10595204307066486,{"$f":"SUM($G$32:$G$111)","v":3.1618224883555319},{"$f":"SUM($H$32:$H$111)","v":0.14228201197599838},{"$f":"J15-I15*F15/10000-G15","v":-5.5511151231257827E-16},null,500,{"$f":"J15-M15*I15/10000","v":-1.5809112441778211E-2}]
[null,null,null,null,"5Y CDS",500,0,0.12945272311711337,{"$f":"SUM($G$32:$G$131)","v":3.7006302204428034},{"$f":"SUM($H$32:$H$131)","v":0.18503151102214016},{"$f":"J16-I16*F16/10000-G16","v":0},null,500,{"$f":"J16-M16*I16/10000","v":0}]
[]
[null,null,null,null,null,"Fair Prem","Def prob","Def prob (approx)","1Y def prob"]
[null,null,null,null,"1Y",{"$f":"J12/I12*10000","v":300},{"$f":"1-D51","v":4.824046043068031E-2},{"$f":"1-EXP(-F12/10000/(1-Recovery))","v":4.8770575499285984E-2},{"$f":"G19","v":4.824046043068031E-2}]
[null,null,null,null,"2Y",{"$f":"J13/I13*10000","v":349.99999999999903},{"$f":"1-D71","v":0.10968572819149203},{"$f":"EXP(-F12/10000/(1-Recovery))-EXP(-2*F13/10000/(1-Recovery))","v":6.1347653512690226E-2},{"$f":"G20-G19","v":6.1445267760811717E-2}]
[null,null,null,null,"3Y",{"$f":"J14/I14*10000","v":399.99999999999937},{"$f":"1-D91","v":0.18253244991283168},{"$f":"EXP(-2*F13/10000/(1-Recovery))-EXP(-3*F14/10000/(1-Recovery))","v":7.1151017910041969E-2},{"$f":"G21-G20","v":7.2846721721339658E-2}]
[null,null,null,null,"4Y",{"$f":"J15/I15*10000","v":449.99999999999824},{"$f":"1-D111","v":0.26471427524933344},{"$f":"EXP(-3*F14/10000/(1-Recovery))-EXP(-4*F15/10000/(1-Recovery))","v":7.7912532396263945E-2},{"$f":"G22-G21","v":8.2181825336501757E-2}]
[null,null,null,null,"5Y",{"$f":"J16/I16*10000","v":499.99999999999994},{"$f":"1-D131","v":0.35399551808152807},{"$f":"EXP(-4*F15/10000/(1-Recovery))-EXP(-5*F16/10000/(1-Recovery))","v":8.1577590481274109E-2},{"$f":"G23-G22","v":8.9281242832194629E-2}]
[]
[]
[]
[]
[]
[]
[null,null,"Disc Factor","Cumulative Survival Probability","Cumulative Default Probability","Marginal Def Probability","Premiums","Defaults","Accr"]
[null,0,{"$f":"EXP(-IRate*B31)","v":1},1,{"$f":"1-D31","v":0}]
[null,{"$f":"B31+0.05","v":0.05},0.99750312239746008,{"$f":"D31*EXP(-0.05*HazardRate1)","v":0.99753091019997286},2.4690898000271355E-3,{"$f":"D31-D32","v":2.4690898000271355E-3},null,{"$f":"F32*C32*(1-Recovery)","v":1.4777548710040726E-3},0.05,{"$f":"I32*F32","v":1.2345449000135679E-4}]
[null,0.1,0.99501247919268232,0.99506791680438633,4.9320831956136679E-3,2.4629933955865324E-3,null,1.470425498866655E-3,{"$f":"I32+0.05","v":0.1},{"$f":"I33*F33","v":2.4629933955865323E-4}]
[null,0.15000000000000002,0.99252805481913842,0.99261100476067032,7.3889952393296765E-3,2.4569120437160086E-3,null,1.4631324789666984E-3,{"$f":"I33+0.05","v":0.15000000000000002},{"$f":"I34*F34","v":3.6853680655740136E-4}]
[null,0.2,0.99004983374916811,0.99016015905342103,9.8398409465789705E-3,2.450845707249294E-3,null,1.4558756310042156E-3,0.2,{"$f":"I35*F35","v":4.9016914144985881E-4}]
[null,0.25,0.98757780049388144,0.98771536470430898,1.2284635295691015E-2,2.444794349112045E-3,{"$f":"C36*D36*0.25","v":0.24386144184717334},1.4486547755735663E-3,0,{"$f":"I36*F36","v":0}]
[null,0.3,0.98511193960306265,0.98527660677198747,1.4723393228012527E-2,2.4387579323215114E-3,null,1.441469734158959E-3,0.05,{"$f":"I37*F37","v":1.2193789661607557E-4}]
[null,0.35,0.9826522356650732,0.98284387035200138,1.7156129647998619E-2,2.4327364199860924E-3,null,1.434320329129908E-3,0.1,2.4327364199860924E-4]
[null,0.39999999999999997,0.98019867330675525,0.98041714057669604,1.9582859423303955E-2,2.4267297753053363E-3,null,1.4272063837369746E-3,0.15000000000000002,3.6400946629580052E-4]
[null,0.44999999999999996,0.97775123719333634,0.97799640261512633,2.2003597384873674E-2,2.4207379615697189E-3,null,1.4201277221074008E-3,0.2,4.8414759231394381E-4]
[null,0.49999999999999994,0.97530991202833273,0.97558164167296613,2.4418358327033873E-2,2.414760942160199E-3,{"$f":"C41*D41*0.25","v":0.23787361127912926},1.4130841692406306E-3,0,0]
[null,0.54999999999999993,0.972874682553454,0.97317284299241769,2.6827157007582314E-2,2.4087986805484407E-3,null,1.4060755510042458E-3,0.05,1.2043993402742205E-4]
[null,0.6,0.97044553354850815,0.97076999185212165,2.923000814787835E-2,2.4028511402960362E-3,null,1.3991016941293367E-3,0.1,2.4028511402960362E-4]
[null,0.65,0.96802244983130603,0.96837307356706714,3.1626926432932856E-2,2.3969182850545057E-3,null,1.3921624262063492E-3,0.15000000000000002,3.5953774275817592E-4]
[null,0.70000000000000007,0.96560541625756646,0.96598207348850174,3.4017926511498264E-2,2.3910000785654084E-3,null,1.385257575681015E-3,0.2,4.7820001571308168E-4]
[null,0.75000000000000011,0.96319441772082182,0.96359697700384217,3.640302299615783E-2,2.3850964846595657E-3,{"$f":"C46*D46*0.25","v":0.23203280729568998},1.3783869718497896E-3,0,0]
[null,0.80000000000000016,0.96078943915232318,0.961217769536585,3.8782230463415002E-2,2.3792074672571717E-3,null,1.3715504448558223E-3,0.05,1.1896037336285859E-4]
[null,0.8500000000000002,0.95839046552094687,0.95884443654621743,4.1155563453782573E-2,2.3733329903675715E-3,null,1.3647478256847586E-3,0.1,2.3733329903675716E-4]
[null,0.90000000000000024,0.95599748183309985,0.95647696352812839,4.3523036471871612E-2,2.3674730180890391E-3,null,1.357978946160558E-3,0.15000000000000002,3.5512095271335591E-4]
[null,0.95000000000000029,0.95361047313262626,0.95411533601352017,4.5884663986479834E-2,2.3616275146082222E-3,null,1.351243638941145E-3,0.2,4.7232550292164444E-4]
[null,1.0000000000000002,0.95122942450071402,0.95175953956931969,4.824046043068031E-2,2.3557964442004753E-3,{"$f":"C51*D51*0.25","v":0.22633541977189714},1.3445417375145879E-3,0,0]
[null,1.0500000000000003,0.94885432105580125,{"$f":"D51*EXP(-0.05*HazardRate2)","v":0.94858891071870455},5.1411089281295452E-2,3.1706288506151425E-3,null,1.8050789312222199E-3,0.05,1.5853144253075713E-4]
[null,1.1000000000000003,0.94648514795348382,0.9454288442915697,5.4571155708430297E-2,3.1600664271348444E-3,null,1.7945735638977361E-3,0.1,3.1600664271348445E-4]
[null,1.1500000000000004,0.94412189038642214,0.94227930510095548,5.7720694899044522E-2,3.1495391906142256E-3,null,1.7841293366932945E-3,0.15000000000000002,4.7243087859213392E-4]
[null,1.2000000000000004,0.94176453358424872,0.93914025807712154,6.0859741922878463E-2,3.1390470238339407E-3,null,1.7737458937799972E-3,0.2,6.2780940476678824E-4]
[null,1.2500000000000004,0.93941306281347581,0.93601166826715665,6.3988331732843351E-2,3.1285898099648879E-3,{"$f":"C56*D56*0.25","v":0.21982539702900017},1.7634228813996873E-3,0,0]
[null,1.3000000000000005,0.93706746337740343,0.93289350083458944,6.710649916541056E-2,3.1181674325672093E-3,null,1.7531599478530712E-3,0.05,1.5590837162836048E-4]
[null,1.3500000000000005,0.93472772061602749,0.92978572105900037,7.021427894099963E-2,3.1077797755890701E-3,null,1.7429567434877765E-3,0.1,3.1077797755890701E-4]
[null,1.4000000000000006,0.93239381990594816,0.92668829433563527,7.3311705664364735E-2,3.0974267233651043E-3,null,1.7328129206862924E-3,0.15000000000000002,4.6461400850476571E-4]
[null,1.4500000000000006,0.93006574666027841,0.92360118617501996,7.6398813824980039E-2,3.0871081606153039E-3,null,1.7227281338542267E-3,0.2,6.1742163212306087E-4]
[null,1.5000000000000007,0.92774348632855286,0.92052436220257627,7.9475637797423726E-2,3.0768239724436874E-3,{"$f":"C61*D61*0.25","v":0.21350262026004641},1.7127020394085042E-3,0,0]
[null,1.5500000000000007,0.92542702439663682,0.91745778815823908,8.2542211841760915E-2,3.0665740443371892E-3,null,1.702734295765755E-3,0.05,1.5332870221685947E-4]
[null,1.6000000000000008,{"$f":"EXP(-IRate*B63)","v":0.92311634638663576},0.91440142989607509,8.5598570103924909E-2,3.056358262163994E-3,null,1.6928245633304601E-3,0.1,3.056358262163994E-4]
[null,1.6500000000000008,0.92081143785680453,0.91135525338390255,8.8644746616097447E-2,{"$f":"D63-D64","v":3.0461765121725382E-3},null,{"$f":"F64*C64*(1-Recovery)","v":1.6829725044835322E-3},0.15000000000000002,4.5692647682588078E-4]
[null,1.7000000000000008,0.91851228440145727,0.90831922470291215,9.1680775297087846E-2,3.0360286809903991E-3,null,1.6731777835709007E-3,0.2,6.0720573619807991E-4]
[null,1.7500000000000009,0.91621887165087756,0.90529331004728952,9.4706689952710477E-2,3.0259146556226302E-3,{"$f":"C66*D66*0.25","v":0.20736170376115393},1.6634400668918518E-3,0,0]
[null,1.8000000000000009,0.91393118527122819,0.90227747572383876,9.7722524276161238E-2,3.0158343234507612E-3,null,1.653759022687804E-3,0.05,1.5079171617253808E-4]
[null,1.850000000000001,0.91164921096446172,0.8992716881516073,0.1007283118483927,3.0057875722314664E-3,null,1.6441343211309608E-3,0.1,3.0057875722314667E-4]
[null,1.900000000000001,0.90937293446823142,0.89627591386151184,0.10372408613848816,2.9957742900954543E-3,null,1.6345656343131516E-3,0.15000000000000002,4.4936614351431819E-4]
[null,1.9500000000000011,0.90710234155580172,0.89329011949596582,0.10670988050403418,2.985794365546024E-3,null,1.6250526362345506E-3,0.2,5.9715887310920481E-4]
[null,2.0000000000000009,0.90483741803595952,0.89031427180850797,0.10968572819149203,2.9758476874578443E-3,{"$f":"C71*D71*0.25","v":0.20139741673594394},1.615595002792582E-3,0,0]
[null,2.0500000000000007,0.9025781497529255,{"$f":"D71*EXP(-0.05*HazardRate3)","v":0.88652236129502693},0.11347763870497307,3.7919105134810449E-3,null,2.0534973451718321E-3,0.05,1.8959552567405225E-4]
[null,2.1000000000000005,0.90032452258626561,0.88274660079261225,0.11725339920738775,3.7757605024146823E-3,null,2.0396458630419462E-3,0.1,3.7757605024146823E-4]
[null,2.1500000000000004,0.89807652245080249,0.87898692151724156,0.12101307848275844,3.7596792753706865E-3,null,2.0258878134931553E-3,0.15000000000000002,5.6395189130560304E-4]
[null,2.2000000000000002,0.89583413529652822,0.87524325497784861,0.12475674502215139,3.7436665393929536E-3,null,2.0122225662933795E-3,0.2,7.487333078785908E-4]
[null,2.25,0.89359734710851568,0.87151553297507511,0.12848446702492489,3.7277220027734925E-3,{"$f":"C76*D76*0.25","v":0.1946959920575978},1.9986494954618616E-3,0,0]
[null,2.2999999999999998,0.89136614390683133,0.86780368760002868,0.13219631239997132,3.7118453750464298E-3,null,1.9851679792401255E-3,0.05,1.855922687523215E-4]
[null,2.3499999999999996,0.88914051174644804,0.86410765123304578,0.13589234876695422,3.6960363669829022E-3,null,1.971777400063596E-3,0.1,3.6960363669829026E-4]
[null,2.3999999999999995,0.88692043671715748,0.86042735654245961,0.13957264345754039,3.6802946905861722E-3,null,1.9584771445335142E-3,0.15000000000000002,5.5204420358792594E-4]
[null,2.4499999999999993,0.88470590494348356,0.85676273648337353,0.14323726351662647,3.6646200590860767E-3,null,1.9452666033886738E-3,0.2,7.3292401181721542E-4]
[null,2.4999999999999991,0.88249690258459546,0.85311372429644006,0.14688627570355994,3.6490121869334757E-3,{"$f":"C81*D81*0.25","v":0.18821755481100422},1.9321451714773398E-3,0,0]
[null,2.5499999999999989,0.88029341583422116,0.84948025350664413,0.15051974649335587,3.6334707897959229E-3,null,1.919112247729991E-3,0.05,1.8167353948979616E-4]
[null,2.5999999999999988,0.87809543092056142,0.84586225792209258,0.15413774207790742,3.6179955845515588E-3,null,1.9061672351312936E-3,0.1,3.6179955845515592E-4]
[null,2.6499999999999986,0.87590293410620323,0.84225967163280813,0.15774032836719187,3.6025862892844485E-3,null,1.8933095406930165E-3,0.15000000000000002,5.403879433926674E-4]
[null,2.6999999999999984,0.87371591168803453,0.83867242900952865,0.16132757099047135,3.5872426232794741E-3,null,1.8805385754268812E-3,0.2,7.1744852465589488E-4]
[null,2.7499999999999982,0.87153434999715795,0.83510046470251154,0.16489953529748846,3.571964307017117E-3,{"$f":"C86*D86*0.25","v":0.18195468517170699},1.8678537543175269E-3,0,0]
[null,2.799999999999998,0.86935823539880586,0.83154371364034341,0.16845628635965659,3.5567510621681286E-3,null,1.8552544962955877E-3,0.05,1.7783755310840643E-4]
[null,2.8499999999999979,0.86718755429225503,0.82800211102875454,0.17199788897124546,3.5416026115888677E-3,null,1.8427402242112878E-3,0.1,3.5416026115888679E-4]
[null,2.8999999999999977,0.86502229311074141,0.82447559234943846,0.17552440765056154,3.5265186793160819E-3,null,1.8303103648079162E-3,0.15000000000000002,5.2897780189741232E-4]
[null,2.9499999999999975,0.86286243832137555,0.82096409335887666,0.17903590664112334,3.511498990561801E-3,null,1.8179643486955226E-3,0.2,7.0229979811236025E-4]
[null,2.9999999999999973,0.86070797642505792,0.81746755008716832,0.18253244991283168,3.4965432717083411E-3,{"$f":"C91*D91*0.25","v":0.17590021020716909},1.8057016103248426E-3,0,0]
[null,3.0499999999999972,0.85855889395639473,{"$f":"D91*EXP(-0.05*HazardRate4)","v":0.81314838294924796},0.18685161705075204,4.3191671379203544E-3,null,2.2249556164474237E-3,0.05,2.1595835689601774E-4]
[null,3.099999999999997,0.85641517748361362,0.80885203653951843,0.19114796346048157,4.2963464097295345E-3,null,2.2076737638117632E-3,0.1,4.2963464097295345E-4]
[null,3.1499999999999968,0.85427681360847962,0.80457839028250322,0.19542160971749678,4.2736462570152067E-3,null,2.1905261441596538E-3,0.15000000000000002,6.4104693855228107E-4]
[null,3.1999999999999966,{"$f":"EXP(-IRate*B95)","v":0.85214378896621146},0.80032732423979802,{"$f":"1-D95","v":0.19967267576020198},4.2510660427051983E-3,null,2.1735117148658435E-3,0.2,8.5021320854103974E-4]
[null,{"$f":"B95+0.05","v":3.2499999999999964},0.85001609022539826,0.79609871910670416,0.20390128089329584,{"$f":"D95-D96","v":4.2286051330938657E-3},{"$f":"C96*D96*0.25","v":0.16917418016213207},{"$f":"F96*C96*(1-Recovery)","v":2.1566294414036985E-3},0,0]
[null,3.2999999999999963,0.84789370408791598,0.79189245620888093,0.20810754379111907,4.2062628978232208E-3,null,2.1398782972817409E-3,0.05,2.1031314489116106E-4]
[null,3.3499999999999961,0.84577661728884435,0.78770841749901455,0.21229158250098545,4.1840387098663889E-3,null,2.123257263981825E-3,{"$f":"I97+0.05","v":0.1},4.184038709866389E-4]
[null,3.3999999999999959,0.84366481659638382,0.78354648555350537,0.21645351444649463,4.1619319455091786E-3,null,2.1067653308967792E-3,0.15000000000000002,6.2428979182637691E-4]
[null,3.4499999999999957,0.84155828881177341,0.77940654356917249,0.22059345643082751,4.1399419843328733E-3,null,2.0904014952691143E-3,0.2,8.2798839686657475E-4]
[null,3.4999999999999956,0.83945702076920758,0.77528847535997558,0.22471152464002442,4.1180682091969123E-3,{"$f":"C101*D101*0.25","v":0.16270533844059656},2.0741647621300954E-3,0,{"$f":"I101*F101","v":0}]
[null,3.5499999999999954,0.83736099933575403,0.77119216535375446,0.22880783464624554,4.0963100062211266E-3,null,2.0580541442390228E-3,0.05,2.0481550031105635E-4]
[null,3.5999999999999952,0.83527021141127222,0.76711749858898515,0.23288250141101485,4.074666764769308E-3,null,2.0420686620236067E-3,0.1,4.0746667647693083E-4]
[null,3.649999999999995,0.83318464392833069,0.76306436071155392,0.23693563928844608,4.0531378774312232E-3,null,2.026207343519978E-3,0.15000000000000002,6.0797068161468353E-4]
[null,3.6999999999999948,0.83110428385212587,0.75903263797154785,0.24096736202845215,4.0317227400060718E-3,null,2.0104692243138461E-3,0.2,8.0634454800121436E-4]
[null,3.7499999999999947,0.82902911818040059,0.75502221722006224,0.24497778277993776,4.0104207514856105E-3,{"$f":"C106*D106*0.25","v":0.15648385073713977},1.994853347481897E-3,0,0]
[null,3.7999999999999945,0.82695913394336251,0.75103298590602552,0.24896701409397448,3.989231314036723E-3,null,1.9793587635333299E-3,0.05,1.9946156570183616E-4]
[null,3.8499999999999943,0.82489431820360359,0.74706483207304031,0.25293516792695969,3.9681538329852106E-3,null,1.9639845303524111E-3,0.1,3.9681538329852108E-4]
[null,3.8999999999999941,0.82283465805601863,0.74311764435624128,0.25688235564375872,3.9471877167990277E-3,null,1.9487297131411468E-3,0.15000000000000002,5.9207815751985426E-4]
[null,3.949999999999994,0.82078014062772497,0.73919131197917021,0.26080868802082979,3.9263323770710734E-3,null,1.9335933843621512E-3,0.2,7.8526647541421468E-4]
[null,3.9999999999999938,0.81873075307798215,0.73528572475066656,0.26471427524933344,3.9055872285036486E-3,{"$f":"C111*D111*0.25","v":0.15050025878815079},1.9185746236827245E-3,0,0]
[null,4.0499999999999936,0.81668648259811105,{"$f":"D111*EXP(-0.05*HazardRate5)","v":0.73054185701071106},0.26945814298928894,4.7438677399554985E-3,null,2.3245515950729438E-3,0.05,2.3719338699777494E-4]
[null,4.0999999999999934,0.81464731641141486,0.72582859544244727,0.27417140455755273,4.7132615682637935E-3,null,2.3037875328786933E-3,0.1,4.7132615682637935E-4]
[null,4.1499999999999932,0.81261324177309791,0.72114574258300379,0.27885425741699621,4.682852859443476E-3,null,2.2832089457152705E-3,0.15000000000000002,7.0242792891652155E-4]
[null,4.1999999999999931,0.81058424597018741,0.71649310224348706,0.28350689775651294,4.6526403395167337E-3,null,2.2628141768265891E-3,0.2,9.3052806790334681E-4]
[null,4.2499999999999929,0.80856031632145275,0.71187047950076199,0.28812952049923801,4.6226227427250688E-3,{"$f":"C116*D116*0.25","v":0.14389755502126009},2.2426015842555136E-3,0,0]
[null,4.2999999999999927,0.80654144017732721,0.70727768068928576,0.29272231931071424,4.5927988114762286E-3,null,2.2225695407116523E-3,0.05,2.2963994057381145E-4]
[null,4.3499999999999925,0.80452760491982811,0.70271451339299396,0.29728548660700604,4.5631672962918035E-3,null,2.2027164334404792E-3,0.1,4.5631672962918038E-4]
[null,4.3999999999999924,0.80251879796247882,0.69818078643723958,0.30181921356276042,4.5337269557543802E-3,null,2.1830406640932559E-3,0.15000000000000002,6.8005904336315714E-4]
[null,4.4499999999999922,0.80051500675022902,0.69367630988078333,0.30632369011921667,4.5044765564562494E-3,null,2.1635406485986937E-3,0.2,9.0089531129124991E-4]
[null,4.499999999999992,0.79851621875937739,0.68920089500783621,0.31079910499216379,4.4754148729471144E-3,{"$f":"C121*D121*0.25","v":0.137584523161809},2.1442148170351255E-3,0,0]
[null,4.5499999999999918,0.79652242149749219,0.68475435432015352,0.31524564567984648,4.4465406876826874E-3,null,2.1250616135040827E-3,0.05,2.2232703438413438E-4]
[null,4.5999999999999917,0.79453360250333438,0.68033650152917902,0.31966349847082098,4.417852790974508E-3,null,2.1060794960054315E-3,0.1,4.4178527909745081E-4]
[null,4.6499999999999915,0.79254974934677846,0.67594715154824081,0.32405284845175919,4.3893499809382064E-3,null,2.0872669363127174E-3,0.15000000000000002,6.5840249714073102E-4]
[null,4.6999999999999913,0.79057084962873592,0.67158612048479693,0.32841387951520307,4.3610310634438765E-3,null,2.0686224198504808E-3,0.2,8.7220621268877538E-4]
[null,4.7499999999999911,0.78859689098107699,0.66725322563273104,0.33274677436726896,4.3328948520658939E-3,{"$f":"C126*D126*0.25","v":0.1315484548077667},2.0501444455722465E-3,0,0]
[null,4.7999999999999909,{"$f":"EXP(-IRate*B127)","v":0.7866278610665538},0.66294828546469808,0.33705171453530192,4.3049401680329558E-3,null,2.0318315258395529E-3,0.05,2.1524700840164779E-4]
[null,4.8499999999999908,{"$f":"EXP(-IRate*B128)","v":0.78466374757872281},0.65867111962451919,0.34132888037548081,4.2771658401788981E-3,null,2.0136821863022823E-3,0.1,4.2771658401788984E-4]
[null,4.8999999999999906,{"$f":"EXP(-IRate*B129)","v":0.78270453824186847},0.65442154891962534,0.34557845108037466,4.2495707048938458E-3,null,1.9956949657800654E-3,0.15000000000000002,6.3743560573407694E-4]
[null,4.9499999999999904,{"$f":"EXP(-IRate*B130)","v":0.78075022081092615},0.65019939531355031,0.34980060468644969,4.2221536060750298E-3,null,1.9778684161444364E-3,0.2,8.4443072121500597E-4]
[null,4.9999999999999902,{"$f":"EXP(-IRate*B131)","v":0.77880078307140521},0.64600448191847193,{"$f":"1-D131","v":0.35399551808152807},4.1949133950783812E-3,{"$f":"C131*D131*0.25","v":0.12577719909643584},1.9602011022022622E-3,0.25,1.0487283487695953E-3]

{"sheet":"Spreadsheet10.3 (new)","index":2,"n_rows":213,"n_cols":8,"rows_kept":213,"cut":false,"hidden":false,"merged":[[8,1,8,2],[8,6,8,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Credit Curve",null,null,null,null,"Default probability"]
[null,"Recovery",0.4,null,null,"Credit spread","Actual","Flat curve"]
[null,"1Y",250,null,0,{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E11)","v":169.80633783340454}]
[null,"3Y",400,null,{"$f":"E11+0.05","v":0.05},{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E12)","v":173.65566662234068},{"$f":"1-EXP(-E12*F12/(1-RecoveryRate)/10000)","v":1.4460839666752268E-3},{"$f":"1-EXP(-E12*fiveyrspread/(1-RecoveryRate)/10000)","v":4.1579981548900413E-3}]
[null,"5Y",500,null,{"$f":"E12+0.05","v":0.1},{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E13)","v":177.52966530656815},2.9544547383316688E-3,8.2987073611240358E-3]
[null,"7Y",600,null,{"$f":"E13+0.05","v":0.15000000000000002},181.42703547054529,4.5254052428601588E-3,1.2422199506118559E-2]
[null,"10Y",700,null,{"$f":"E14+0.05","v":0.2},185.34647869873046,6.1591700239019831E-3,1.6528546178382508E-2]
[null,null,null,null,{"$f":"E14+0.05","v":0.2},185.34647869873046,6.1591700239019831E-3,1.6528546178382508E-2]
[null,null,null,null,{"$f":"E15+0.05","v":0.25},189.28669657558203,7.8559253399973494E-3,2.0617818668759891E-2]
[null,null,null,null,{"$f":"E16+0.05","v":0.25},189.28669657558203,7.8559253399973494E-3,2.0617818668759891E-2]
[null,null,null,null,{"$f":"E18+0.05","v":0.3},193.24639068555831,9.6157893087800428E-3,2.4690087971667385E-2]
[null,null,null,null,0.35,197.2242626131177,1.143882209667435E-2,2.8745424786327134E-2]
[null,null,null,null,0.39999999999999997,201.2190139427185,1.3325026154438202E-2,3.2783899517994097E-2]
[null,null,null,null,0.44999999999999996,205.22934625881911,1.5274346498785007E-2,3.6805582279178184E-2]
[null,null,null,null,0.49999999999999994,209.25396114587784,1.7286671040206314E-2,4.0810542890861834E-2]
[null,null,null,null,0.54999999999999993,213.29156018835306,1.9361830957004389E-2,4.4798850883711605E-2]
[null,null,null,null,0.6,217.34084497070313,2.149960111543503E-2,4.8770575499285984E-2]
[null,null,null,null,0.65,221.40051707738638,2.3699700535750656E-2,5.2725785691237093E-2]
[null,null,null,null,0.70000000000000007,225.46927809286117,2.596179290382461E-2,5.666455012650784E-2]
[null,null,null,null,0.75000000000000011,229.54582960158589,2.8285487127930997E-2,6.0586937186524192E-2]
[null,null,null,null,0.80000000000000016,233.62887318801882,3.0670337940147618E-2,6.4493014968382223E-2]
[null,null,null,null,0.8500000000000002,237.71711043661836,3.3115846541746929E-2,6.8382851286030499E-2]
[null,null,null,null,0.90000000000000024,241.80924293184287,3.5621461291835521E-2,7.2256513671447142E-2]
[null,null,null,null,0.95000000000000029,245.90397225815065,3.8186578438405672E-2,7.6114069375812554E-2]
[null,0,{"$f":"fiveyrspread","v":500},null,1.0000000000000002,250.00000000000006,4.0810542890861834E-2,7.9955585370676818E-2]
[null,{"$f":"LEFT(B11,LEN(B11)-1)*1","v":1},500,null,1.0500000000000003,254.09602774184947,4.3492649032991992E-2,8.3781128349122436E-2]
[null,{"$f":"LEFT(B12,LEN(B12)-1)*1","v":3},500,null,1.1000000000000003,258.19075706815727,4.6232141575261343E-2,8.7590764726922177E-2]
[null,{"$f":"LEFT(B13,LEN(B13)-1)*1","v":5},500,null,1.1500000000000004,262.28288956338173,4.9028216445215933E-2,9.138456064369227E-2]
[null,{"$f":"LEFT(B14,LEN(B14)-1)*1","v":7},500,null,1.2000000000000004,266.37112681198124,5.1880021714698632E-2,9.5162581964040482E-2]
[null,{"$f":"LEFT(B15,LEN(B15)-1)*1","v":10},500,null,1.2500000000000004,270.45417039841425,5.4786658562496537E-2,9.892489427870943E-2]
[null,null,null,null,1.3000000000000005,274.53072190713897,5.7747182270960096E-2,0.102671562905716]
[null,null,null,null,1.3500000000000005,278.59948292261373,6.0760603255059609E-2,0.10640265289148432]
[null,null,null,null,1.4000000000000006,282.65915502929698,6.3825888122270968E-2,0.11011822901197621]
[null,null,null,null,1.4500000000000006,286.70843981164705,6.6941960761617181E-2,0.11381835577381472]
[null,null,null,null,1.5000000000000007,290.74603885412228,7.0107703460126847E-2,0.11750309741540466]
[null,null,null,null,1.5500000000000007,294.77065374118104,7.3321958044912039E-2,0.12117251790804762]
[null,null,null,null,1.6000000000000008,298.78098605728167,7.6583527049012501E-2,0.12482668095705263]
[null,null,null,null,1.6500000000000008,302.7757373868825,7.9891174899101802E-2,0.12846565000284216]
[null,null,null,null,1.7000000000000008,306.75360931444186,8.3243629123104901E-2,0.13208948822205369]
[null,null,null,null,1.7500000000000009,310.71330342441814,8.6639581575735036E-2,0.13569825852863604]
[null,null,null,null,1.8000000000000009,314.65352130126973,9.0077689679917139E-2,0.1392920235749423]
[null,null,null,null,1.850000000000001,318.57296452945496,9.3556577682035513E-2,0.14287084575281683]
[null,null,null,null,1.900000000000001,322.47033469343211,9.7074837918913137E-2,0.14643478719467906]
[null,null,null,null,1.9500000000000011,326.34433337765955,0.10063103209440294,0.14998390977460196]
[null,null,null,null,2.0000000000000009,330.19366216659563,0.10422369256345754,0.15351827510938598]
[null,null,null,null,2.0500000000000007,334.01702264469873,0.1078513236215205,0.15703794455962927]
[null,null,null,null,2.1000000000000005,337.81311639642729,0.11151240279707886,0.16054297923079264]
[null,null,null,null,2.1500000000000004,341.58064500623948,0.11520538214520248,0.16403343997426056]
[null,null,null,null,2.2000000000000002,345.31831005859374,0.11892868953989999,0.16750938738839738]
[null,null,null,null,2.25,349.02481313794851,0.1226807299631153,0.17097088181959963]
[null,null,null,null,2.2999999999999998,352.69885582876202,0.1264598867881993,0.17441798336334391]
[null,null,null,null,2.3499999999999996,356.33913971549265,0.13026452305569924,0.17785075186522947]
[null,null,null,null,2.3999999999999995,359.94436638259879,0.13409298273931747,0.18126924692201818]
[null,null,null,null,2.4499999999999993,363.51323741453876,0.13794359199991468,0.18467352788266811]
[null,null,null,null,2.4999999999999991,367.04445439577086,0.14181466042544422,0.18806365384936496]
[null,null,null,null,2.5499999999999989,370.53671891075351,0.14570448225473542,0.19143968367854747]
[null,null,null,null,2.5999999999999988,373.9887325439451,0.14961133758306255,0.19480167598192932]
[null,null,null,null,2.6499999999999986,377.39919687980387,0.15353349354747059,0.19814968912751707]
[null,null,null,null,2.6999999999999984,380.76681350278824,0.15746920548985777,0.20148378124062283]
[null,null,null,null,2.7499999999999982,384.09028399735655,0.16141671809584957,0.20480401020487415]
[null,null,null,null,2.799999999999998,387.36830994796713,0.16537426650753573,0.20811043366321824]
[null,null,null,null,2.8499999999999979,390.59959293907838,0.16934007740818025,0.21140310901892323]
[null,null,null,null,2.8999999999999977,393.78283455514867,0.17331237007705269,0.21468209343657452]
[null,null,null,null,2.9499999999999975,396.91673638063622,0.17728935741257523,0.21794744384306741]
[null,null,null,null,2.9999999999999973,399.99999999999932,0.18126924692201773,0.22119921692859501]
[null,null,null,null,3.0499999999999972,403.03184359939542,0.18525045563405751,0.22443746914763285]
[null,null,null,null,3.099999999999997,406.01355665956038,0.18923227449740621,0.2276622567199188]
[null,null,null,null,3.1499999999999968,408.94694081910347,{"$f":"1-EXP(-E76*F76/(1-RecoveryRate)/10000)","v":0.19321425685938198},{"$f":"1-EXP(-E76*fiveyrspread/(1-RecoveryRate)/10000)","v":0.23087363563142926}]
[null,null,null,null,3.1999999999999966,{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E77)","v":411.83380336106131},0.19719601253543806,0.23407166163535109]
[null,null,null,null,3.2499999999999964,414.67594638839273,0.20117720207170853,0.23725639025304934]
[null,null,null,null,3.2999999999999963,417.47517576838396,0.20515753935284575,0.2404278767750313]
[null,null,null,null,3.3499999999999961,420.23329693492821,0.20913678864763141,0.2435861762619066]
[null,null,null,null,3.3999999999999959,422.95211264107382,0.21311476241142646,0.24673134354534298]
[null,null,null,null,{"$f":"E81+0.05","v":3.4499999999999957},425.63342908637486,0.21709132280220689,0.24986343322901794]
[null,null,null,null,3.4999999999999956,428.27904942631608,0.22106637762156511,0.25298249968956721]
[null,null,null,null,3.5499999999999954,430.89077899418157,0.22503988146279352,0.25608859707752862]
[null,null,null,null,3.5999999999999952,433.47042275177586,0.22901183339625952,0.25918177931828179]
[null,null,null,null,3.649999999999995,436.01978441180302,0.23298227537293359,0.26226210011298534]
[null,null,null,null,3.6999999999999948,438.54066924511812,0.23695129234304202,0.26532961293950807]
[null,null,null,null,3.7499999999999947,441.03488130494816,0.24091900979409375,0.26838437105335788]
[null,null,null,null,3.7999999999999945,443.50424072675611,0.24488560082621857,0.27142642748860679]
[null,null,null,null,3.8499999999999943,445.95050630128208,0.24885124796179003,0.27445583505881077]
[null,null,null,null,3.8999999999999941,448.37552832246996,0.2528162150668728,0.27747264635792745]
[null,null,null,null,3.949999999999994,450.78108076968067,0.25678076575309394,0.28047691376122885]
[null,null,null,null,3.9999999999999938,453.16901421546777,0.26074523617935996,0.2834686894262104]
[null,null,null,null,4.0499999999999936,455.54108724754769,0.26470995156530897,0.28644802529349722]
[null,null,null,null,4.0999999999999934,457.89911977462566,0.26867530002832274,0.289414973087745]
[null,null,null,null,4.1499999999999932,460.24491656425334,0.27264169399933114,0.29236958431853866]
[null,null,null,null,4.1999999999999931,462.58028184224122,0.27660957617953119,0.29531191028128612]
[null,null,null,null,4.2499999999999929,464.90702034905377,0.28057941888976534,0.29824200205810958]
[null,null,null,null,4.2999999999999927,467.2269366631491,0.28455172254815919,0.30115991051873126]
[null,null,null,null,4.3499999999999925,469.54183536298535,0.28852701456292817,0.30406568632135766]
[null,null,null,null,4.3999999999999924,471.85352895772655,0.2925058522537225,0.30695937991355804]
[null,null,null,null,4.4499999999999922,474.16379855282469,0.29648880124540211,0.30984104153314129]
[null,null,null,null,4.499999999999992,476.47447189688484,0.30047647475213424,0.31271072120902732]
[null,null,null,null,4.5499999999999918,478.78734593897059,0.30446949218673602,0.31556846876211597]
[null,null,null,null,4.5999999999999917,481.10422543915234,0.30846849797186393,0.31841433380615169]
[null,null,null,null,4.6499999999999915,483.42691461846812,0.31247415596843875,0.32124836574858517]
[null,null,null,null,4.6999999999999913,485.7572222375544,0.31648715094587176,0.32407061379143109]
[null,null,null,null,4.7499999999999911,488.09694105013978,0.32050817633382345,0.32688112693212235]
[null,null,null,null,4.7999999999999909,490.44788736628402,0.32453795413787767,0.32967995396436023]
[null,null,null,null,4.8499999999999908,492.81186375971214,0.3285772137092281,0.33246714347896222]
[null,null,null,null,4.8999999999999906,495.19066903446816,0.33262669571965653,0.3352427438647051]
[null,null,null,null,4.9499999999999904,497.58611356627097,0.33668715921122705,0.33800680330916544]
[null,null,null,null,4.9999999999999902,499.99999999999699,0.34075936979955412,0.34075936979955568]
[null,null,null,null,5.0499999999999901,502.433626994777,0.34484382460718199,0.34350049112355774]
[null,null,null,null,5.0999999999999899,504.88626748801289,0.3489399038012192,0.34623021487015215]
[null,null,null,null,5.1499999999999897,507.35669023098819,0.35304669530287169,0.34894858843044496]
[null,null,null,null,5.1999999999999895,509.84366177461646,0.35716327048522167,0.35165565899848972]
[null,null,null,null,5.2499999999999893,512.3459506891636,0.36128868752544063,0.35435147357210739]
[null,null,null,null,5.2999999999999892,514.86232407744558,0.36542199047752955,0.35703607895370204]
[null,null,null,null,5.349999999999989,517.39154921122872,0.36956221118365118,0.3597095217510734]
[null,null,null,null,5.3999999999999888,519.93239440735397,0.37370837076663554,0.36237184837822611]
[null,null,null,null,5.4499999999999886,522.4836266391095,0.37785947927687336,0.36502310505617541]
[null,null,null,null,5.4999999999999885,525.04401406645434,0.38201453809553509,0.3676633378137496]
[null,null,null,null,5.5499999999999883,527.61232400037488,0.38617253975613852,0.37029259248838942]
[null,null,null,null,5.5999999999999881,530.18732389667196,0.39033246946198874,0.37291091472694327]
[null,null,null,null,5.6499999999999879,532.76778169808358,0.3944933062271283,0.37551834998646039]
[null,null,null,null,5.6999999999999877,535.352464739933,0.39865402318487075,0.37811494353497932]
[null,null,null,null,5.7499999999999876,537.9401408322118,0.40281358911970422,0.3807007404523145]
[null,null,null,null,5.7999999999999874,540.52957746390746,0.40697096891353302,0.38327578563083853]
[null,null,null,null,5.8499999999999872,543.11954224468514,0.41112512468050899,0.38584012377626165]
[null,null,null,null,5.899999999999987,545.70880280351946,0.41527501657399879,0.38839379940840735]
[null,null,null,null,5.9499999999999869,548.29612677742955,0.41941960362572273,0.39093685686198654]
[null,null,null,null,5.9999999999999867,550.88028168677886,0.42355784449935241,0.39346934028736591]
[null,null,null,null,6.0499999999999865,553.4600352203779,0.42768869845909907,0.39599129365133523]
[null,null,null,null,6.0999999999999863,556.03415495561103,0.43181112599111948,0.3985027607378705]
[null,null,null,null,6.1499999999999861,558.60140842400449,0.43592408960085394,0.40100378514889401]
[null,null,null,null,6.199999999999986,561.16056336827148,0.44002655469783825,0.40349441030503097]
[null,null,null,null,6.2499999999999858,563.71038733049795,0.44411749006949197,0.40597467944636423]
[null,null,null,null,6.2999999999999856,566.2496479159247,0.44819586872016026,0.40844463563318423]
[null,null,null,null,6.3499999999999854,568.77711272979229,{"$f":"1-EXP(-E140*F140/(1-RecoveryRate)/10000)","v":0.45226066849541291},{"$f":"1-EXP(-E140*fiveyrspread/(1-RecoveryRate)/10000)","v":0.41090432174673674}]
[null,null,null,null,6.3999999999999853,{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E141)","v":571.29154925988098},0.45631087264817516,0.41335378048996751]
[null,null,null,null,6.4499999999999851,573.79172533941323,0.46034547071423926,0.41579305438826353]
[null,null,null,null,6.4999999999999849,576.27640846371196,0.464363458695364,0.41822218579019099]
[null,null,null,null,6.5499999999999847,578.74436623801785,0.46836383986989039,0.4206412168682313]
[null,null,null,null,6.5999999999999845,581.19436619677333,0.47234562521007639,0.42305018961951257]
[null,null,null,null,{"$f":"E145+0.05","v":6.6499999999999844},583.62517608455266,0.47630783403796861,0.42544914586653881]
[null,null,null,null,6.6999999999999842,586.035563363341,0.48024949420246754,0.42783812725791626]
[null,null,null,null,6.749999999999984,588.42429578676354,0.48416964284547315,0.43021717526907621]
[null,null,null,null,6.7999999999999838,590.79014084798052,0.4880673264837565,0.4325863312029955]
[null,null,null,null,6.8499999999999837,593.13186619019643,0.49194160161864287,0.43494563619091287]
[null,null,null,null,6.8999999999999835,595.44823943906636,0.49579153497897643,0.43729513119304353]
[null,null,null,null,6.9499999999999833,597.73802817051035,0.49961620381126659,0.43963485699929061]
[null,null,null,null,6.9999999999999831,599.99999999999602,0.50341469620858725,0.44196485422995213]
[null,null,null,null,7.0499999999999829,602.23320811194617,0.50718627669334215,0.44428516333642776]
[null,null,null,null,7.0999999999999828,604.43785300993261,0.51093088469122194,0.44659582460191993]
[null,null,null,null,7.1499999999999826,606.61441500104263,0.51464863085112156,0.44889687814213364]
[null,null,null,null,7.1999999999999824,608.76338021357549,0.5183396379005627,0.45118836390597272]
[null,null,null,null,7.2499999999999822,610.88523280108586,0.5220040358057767,0.45347032167623391]
[null,null,null,null,7.2999999999999821,612.98045840273187,0.52564196345314551,0.4557427910702968]
[null,null,null,null,7.3499999999999819,615.04953810822667,0.52925356485277464,0.4580058115408121]
[null,null,null,null,7.3999999999999817,617.09295765109368,0.53283899414017177,0.46025942237638651]
[null,null,null,null,7.4499999999999815,619.11120118488759,0.53639841168267499,0.46250366270226484]
[null,null,null,null,7.4999999999999813,621.10475398862013,0.53993198534615949,0.46473857148100894]
[null,null,null,null,7.5499999999999812,623.07409787922302,0.54343988756950024,0.4669641875131747]
[null,null,null,null,7.599999999999981,625.01971822314761,0.54692229911828272,0.46918054943798526]
[null,null,null,null,7.6499999999999808,626.94212969152636,0.55037942356449854,0.47138769573400185]
[null,null,null,null,7.6999999999999806,628.84172567819428,0.55381140069715318,0.47358566471979202]
[null,null,null,null,7.7499999999999805,630.71908022462867,0.55721847934508428,0.47577449455459475]
[null,null,null,null,7.7999999999999803,632.57464784033414,0.56060084503604513,0.47795422323898307]
[null,null,null,null,7.8499999999999801,634.40888272314987,0.56395868817494532,0.48012488861552349]
[null,null,null,null,7.8999999999999799,636.22235938205131,0.56729227252995318,0.48228652836943342]
[null,null,null,null,7.9499999999999797,638.01547105504062,0.57060176294551701,0.48443918002923503]
[null,null,null,null,7.9999999999999796,639.78873241325027,0.57388739779595233,0.48658288096740721]
[null,null,null,null,8.0499999999999794,641.54262788813617,0.5771494022289394,0.48871766840103359]
[null,null,null,null,8.0999999999999801,643.27764101078844,0.58038800468330165,0.49084357939245005]
[null,null,null,null,8.1499999999999808,644.9942562810561,0.58360343773164958,0.49296065084988661]
[null,null,null,null,8.1999999999999815,646.69295785249358,0.58679593712012823,0.4950689195281095]
[null,null,null,null,8.2499999999999822,648.3742299002987,0.58996574176876937,0.49716842202905831]
[null,null,null,null,8.2999999999999829,650.03855647500325,0.59311309348516406,0.49925919480248204]
[null,null,null,null,8.3499999999999837,651.68642181327232,0.59623823694042866,0.50134127414657148]
[null,null,null,null,8.3999999999999844,653.31834058623883,0.59934143644049265,0.50341469620858981]
[null,null,null,null,8.4499999999999851,654.93470518781169,0.60242289007686745,0.5054794969855001]
[null,null,null,null,8.4999999999999858,656.53609168529181,0.60548290115441517,0.50753571232458972]
[null,null,null,null,8.5499999999999865,658.12295340688627,0.60852170613670331,0.50958337792409347]
[null,null,null,null,8.5999999999999872,659.6957747922753,0.61153956076444671,0.51162252933381236]
[null,null,null,null,8.6499999999999879,661.25503966127224,0.61453672208578469,0.51365320195573227]
[null,null,null,null,8.6999999999999886,662.80123255225124,0.61751344903165006,0.51567543104463709]
[null,null,null,null,8.7499999999999893,664.33483718979437,0.62047000139704989,0.51768925170872149]
[null,null,null,null,8.7999999999999901,665.85633820404405,0.62340664063225637,0.51969469891020026]
[null,null,null,null,8.8499999999999908,667.36621923127723,0.62632362863111224,0.52169180746591559]
[null,null,null,null,8.8999999999999915,668.86496498647853,0.62922122872046127,0.52368061204794114]
[null,null,null,null,8.9499999999999922,670.35305902454547,0.6320997042721257,0.52566114718418422]
[null,null,null,null,8.9999999999999929,671.8309861383791,0.63495931987311116,0.52763344725898498]
[null,null,null,null,9.0499999999999936,673.29922980842377,0.63780033977780648,0.52959754651371393]
[null,null,null,null,9.0999999999999943,674.75827489857045,0.64062302924162406,0.53155347904736572]
[null,null,null,null,9.149999999999995,676.20860482173657,0.64342765282986236,0.53350127881715137]
[null,null,null,null,9.1999999999999957,677.65071976466652,0.64621448417504257,0.53544097963908843]
[null,null,null,null,9.2499999999999964,679.08505730330853,0.64898376277148673,0.53737261518858659]
[null,null,null,null,9.2999999999999972,680.51214798182457,0.65173577824164064,0.53929621900103397]
[null,null,null,null,9.3499999999999979,681.93246049196466,0.65447078621904908,0.5412118244723787]
[null,null,null,null,9.3999999999999986,683.34647898858168,0.65718905016131823,0.54311946485970797]
[null,null,null,null,9.4499999999999993,684.75468762652895,0.65989083283560968,0.54501917328182647]
[null,null,null,null,9.5,686.15757056065956,0.66257639619458675,0.54691098271983107]
[null,null,null,null,9.5500000000000007,687.5556119458264,{"$f":"1-EXP(-E204*F204/(1-RecoveryRate)/10000)","v":0.66524600125444389},{"$f":"1-EXP(-E204*fiveyrspread/(1-RecoveryRate)/10000)","v":0.54879492601768298}]
[null,null,null,null,9.6000000000000014,{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E205)","v":688.94930356627731},0.66789991202889287,0.55067103588277844]
[null,null,null,null,9.6500000000000021,690.33910656412388,0.67053837507533176,0.55253934488651657]
[null,null,null,null,9.7000000000000028,691.72552823011154,0.67316166018164991,0.55439988546486441]
[null,null,null,null,9.7500000000000036,693.10904496676426,0.67577001931801817,0.5562526899189203]
[null,null,null,null,9.8000000000000043,694.49014474363253,0.67836370906003673,0.5580977904154748]
[null,null,null,null,{"$f":"E209+0.05","v":9.850000000000005},695.86930020703403,0.68094297630454848,0.55993521898756915]
[null,null,null,null,9.9000000000000057,697.2470089918786,0.68350807933122404,0.56176500753505099]
[null,null,null,null,{"$f":"E211+0.05","v":9.9500000000000064},698.62374657344787,0.686059262951489,0.56358718782512862]
[null,null,null,null,10.000000000000007,700.00000000000023,0.68859677608540271,0.56540179149292202]