{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Spreadsheet12.1","Spreadsheet12.2"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":20,"defined_names":1612,"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":"Spreadsheet12.1","index":0,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":false,"merged":[[10,1,10,2],[8,5,8,6],[9,5,9,6],[9,12,9,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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","PD (approx)","PD"]
[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":"Spreadsheet12.2","index":1,"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",150,null,0,{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E11)","v":140.09683084487915}]
[null,"3Y",175,null,{"$f":"E11+0.05","v":0.05},{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E12)","v":140.67216645497084},{"$f":"1-EXP(-E12*F12/(1-RecoveryRate)/10000)","v":1.171581216008688E-3},{"$f":"1-EXP(-E12*fiveyrspread/(1-RecoveryRate)/10000)","v":1.8316538043133823E-3}]
[null,"5Y",220,null,{"$f":"E12+0.05","v":0.1},{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E13)","v":141.23516711854936},2.3511511561238319E-3,3.6599526529679238E-3]
[null,"7Y",240,null,{"$f":"E13+0.05","v":0.15000000000000002},141.78648204332589,3.5383871528756883E-3,5.4849026910809284E-3]
[null,"10Y",250,null,{"$f":"E14+0.05","v":0.2},142.32676043701173,4.7329892866494472E-3,7.3065100525139259E-3]
[null,null,null,null,{"$f":"E14+0.05","v":0.2},142.32676043701173,4.7329892866494472E-3,7.3065100525139259E-3]
[null,null,null,null,{"$f":"E15+0.05","v":0.25},142.85665150731802,5.9346802788688979E-3,9.1247808598934332E-3]
[null,null,null,null,{"$f":"E16+0.05","v":0.25},142.85665150731802,5.9346802788688979E-3,9.1247808598934332E-3]
[null,null,null,null,{"$f":"E18+0.05","v":0.3},143.37680446195603,7.1432053819635577E-3,1.0939721224631271E-2]
[null,null,null,null,0.35,143.88786850863696,8.3583322663343118E-3,1.2751337246945438E-2]
[null,null,null,null,0.39999999999999997,144.39049285507201,9.5798509045116331E-3,1.4559635015880423E-2]
[null,null,null,null,0.44999999999999996,144.88532670897246,1.0807573452687569E-2,1.636462060932764E-2]
[null,null,null,null,0.49999999999999994,145.37301927804947,1.2041334129779924E-2,1.8166300094045851E-2]
[null,null,null,null,0.54999999999999993,145.85421977001428,1.3280989094174522E-2,1.9964679525681706E-2]
[null,null,null,null,0.6,146.32957739257813,1.4526416318271229E-2,2.175976494878995E-2]
[null,null,null,null,0.65,146.79974135345222,1.5777515460944191E-2,2.3551562396853964E-2]
[null,null,null,null,0.70000000000000007,147.26536086034776,1.70342077380079E-2,2.5340077892305635E-2]
[null,null,null,null,0.75000000000000011,147.72708512097597,1.8296435790767229E-2,2.7125317446546005E-2]
[null,null,null,null,0.80000000000000016,148.1855633430481,1.9564163552709291E-2,2.8907287059965259E-2]
[null,null,null,null,0.8500000000000002,148.64144473427538,2.0837376114381745E-2,3.0685992721962929E-2]
[null,null,null,null,0.90000000000000024,149.09537850236896,2.2116079586485204E-2,3.246144041096799E-2]
[null,null,null,null,0.95000000000000029,149.5480138550401,2.3400300961188614E-2,3.4233636094459174E-2]
[null,0,{"$f":"fiveyrspread","v":220},null,1.0000000000000002,150.00000000000003,2.4690087971667385E-2,3.6002585728984737E-2]
[null,{"$f":"LEFT(B11,LEN(B11)-1)*1","v":1},220,null,1.0500000000000003,150.45198614495996,2.5985508949839198E-2,3.7768295260182438E-2]
[null,{"$f":"LEFT(B12,LEN(B12)-1)*1","v":3},220,null,1.1000000000000003,150.9046214976311,2.7286652682267154E-2,3.9530770622800193E-2]
[null,{"$f":"LEFT(B13,LEN(B13)-1)*1","v":5},220,null,1.1500000000000004,151.35855526572468,2.859362826417533E-2,4.1290017740714835E-2]
[null,{"$f":"LEFT(B14,LEN(B14)-1)*1","v":7},220,null,1.2000000000000004,151.81443665695193,2.9906564951514558E-2,4.3046042526953321E-2]
[null,{"$f":"LEFT(B15,LEN(B15)-1)*1","v":10},220,null,1.2500000000000004,152.27291487902406,3.1225612010995052E-2,4.4798850883711605E-2]
[null,null,null,null,1.3000000000000005,152.7346391396523,3.2550938567994181E-2,4.6548448702374956E-2]
[null,null,null,null,1.3500000000000005,153.20025864654784,3.3882733452226921E-2,4.829484186353783E-2]
[null,null,null,null,1.4000000000000006,153.67042260742193,3.5221205041058301E-2,5.0038036237023187E-2]
[null,null,null,null,1.4500000000000006,154.14578022998577,3.6566581100318296E-2,5.17780376819027E-2]
[null,null,null,null,1.5000000000000007,154.62698072195059,3.7919108622470277E-2,5.3514852046516181E-2]
[null,null,null,null,1.5500000000000007,155.1146732910276,3.9279053661966712E-2,5.5248485168491346E-2]
[null,null,null,null,1.6000000000000008,155.60950714492805,4.0646701167616039E-2,5.697894287476335E-2]
[null,null,null,null,1.6500000000000008,156.1121314913631,4.2022354811769302E-2,5.8706230981594443E-2]
[null,null,null,null,1.7000000000000008,156.62319553804403,4.3406336816123714E-2,6.0430355294593507E-2]
[null,null,null,null,1.7500000000000009,157.14334849268204,4.4798987773927768E-2,6.2151321608735488E-2]
[null,null,null,null,1.8000000000000009,157.67323956298836,4.6200666468359741E-2,6.3869135708381153E-2]
[null,null,null,null,1.850000000000001,158.2135179566742,4.7611749686841232E-2,6.558380336729619E-2]
[null,null,null,null,1.900000000000001,158.76483288145073,4.9032632031032142E-2,6.7295330348670523E-2]
[null,null,null,null,1.9500000000000011,159.32783354502928,5.0463725722249442E-2,6.9003722405138301E-2]
[null,null,null,null,2.0000000000000009,159.90316915512091,5.1905460402030812E-2,7.0708985278796432E-2]
[null,null,null,null,2.0500000000000007,160.49148891943699,5.3358282927565504E-2,7.2411124701224905E-2]
[null,null,null,null,2.1000000000000005,161.09344204568868,5.4822657161693655E-2,7.4110146393504661E-2]
[null,null,null,null,2.1500000000000004,161.7096777415872,5.6299063757174306E-2,7.5806056066238137E-2]
[null,null,null,null,2.2000000000000002,162.34084521484374,5.7787999934905576E-2,7.74988594195678E-2]
[null,null,null,null,2.25,162.98759367316961,5.9289979255778835E-2,7.9188562143195473E-2]
[null,null,null,null,2.2999999999999998,163.65057232427597,6.0805531385832667E-2,8.0875169916401202E-2]
[null,null,null,null,2.3499999999999996,164.33043037587402,6.2335201854370137E-2,8.2558688408062686E-2]
[null,null,null,null,2.3999999999999995,165.02781703567499,6.3879551804691403E-2,8.4239123276674377E-2]
[null,null,null,null,2.4499999999999993,165.74338151139014,6.5439157737089859E-2,8.5916480170366016E-2]
[null,null,null,null,2.4999999999999991,166.47777301073066,6.7014611243748634E-2,8.7590764726922177E-2]
[null,null,null,null,2.5499999999999989,167.23164074140777,6.8606518735173205E-2,8.9261982573800802E-2]
[null,null,null,null,2.5999999999999988,168.00563391113269,7.0215501157787075E-2,9.0930139328152304E-2]
[null,null,null,null,2.6499999999999986,168.80040172761667,7.1842193702312485E-2,9.2595240596838546E-2]
[null,null,null,null,2.6999999999999984,169.61659339857087,7.3487245502555143E-2,9.4257291976451496E-2]
[null,null,null,null,2.7499999999999982,170.45485813170657,7.5151319324207044E-2,9.5916299053331877E-2]
[null,null,null,null,2.799999999999998,171.31584513473493,7.6835091243278586E-2,9.7572267403588597E-2]
[null,null,null,null,2.8499999999999979,172.2002036153672,7.8539250313768183E-2,9.9225202593116735E-2]
[null,null,null,null,2.8999999999999977,173.10858278131462,8.0264498224177472E-2,0.10087511017761674]
[null,null,null,null,2.9499999999999975,174.0416318402884,8.2011548942475976E-2,0.10252199570261278]
[null,null,null,null,2.9999999999999973,174.99999999999972,8.3781128349122214E-2,0.10416586470347167]
[null,null,null,null,3.0499999999999972,175.98400009796626,8.5573817501690463E-2,0.10580672270542135]
[null,null,null,null,3.099999999999997,176.99259671325368,8.7389563884484378E-2,0.10744457522356943]
[null,null,null,null,3.1499999999999968,178.02442027664657,{"$f":"1-EXP(-E76*F76/(1-RecoveryRate)/10000)","v":8.922812129249047E-2},{"$f":"1-EXP(-E76*fiveyrspread/(1-RecoveryRate)/10000)","v":0.10907942776292179}]
[null,null,null,null,3.1999999999999966,{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E77)","v":179.07809839671617},9.1089199738443205E-2,0.11071128581840084]
[null,null,null,null,3.2499999999999964,180.15226127207239,9.2972468493912053E-2,0.1123401548748646]
[null,null,null,null,3.2999999999999963,181.24553721916158,9.4877554437804879E-2,0.11396604040712432]
[null,null,null,null,3.3499999999999961,182.35655477112653,9.680404355761163E-2,0.11558894787996343]
[null,null,null,null,3.3999999999999959,183.4839438015324,9.8751482048429873E-2,0.11720888274815588]
[null,null,null,null,{"$f":"E81+0.05","v":3.4499999999999957},184.62633246069171,0.10071937530261288,0.11882585045648442]
[null,null,null,null,3.4999999999999956,185.78235042095136,0.10270719009659734,0.12043985643975841]
[null,null,null,null,3.5499999999999954,186.95063389515329,0.10471435785209993,0.12205090612283287]
[null,null,null,null,3.5999999999999952,188.12978876430108,0.10674025564335199,0.12365900492062654]
[null,null,null,null,3.649999999999995,189.31846731031561,0.10878424742962722,0.12526415823813941]
[null,null,null,null,3.6999999999999948,190.51528288906979,0.11084563929165436,0.12686637147047186]
[null,null,null,null,3.7499999999999947,191.71888761222306,0.11292372189186417,0.12846565000284194]
[null,null,null,null,3.7999999999999945,192.92789503273877,0.11501772892109496,0.13006199921060402]
[null,null,null,null,3.8499999999999943,194.14091885836376,0.1171268584626316,0.13165542445926681]
[null,null,null,null,3.8999999999999941,195.35661096858257,0.11925029537601095,0.13324593110451088]
[null,null,null,null,3.949999999999994,196.57358510622601,0.12138716890905576,0.13483352449220742]
[null,null,null,null,3.9999999999999938,197.79049301147393,0.12353659666382977,0.13641820995843568]
[null,null,null,null,4.0499999999999936,199.00594086419036,0.12569763701573711,0.13799999282950104]
[null,null,null,null,4.0999999999999934,200.21856521890109,0.12786933364899078,0.13957887842195316]
[null,null,null,null,4.1499999999999932,201.42699494191976,0.13005069414913883,0.14115487204260313]
[null,null,null,null,4.1999999999999931,202.62985917043051,0.13224069522224247,0.14272797898854239]
[null,null,null,null,4.2499999999999929,203.82578678429047,0.13443828298142868,0.14429820454715947]
[null,null,null,null,4.2999999999999927,205.01340674436005,0.13664237374518895,0.14586555399615841]
[null,null,null,null,4.3499999999999925,206.19134419680228,0.13885185219585461,0.14743003260357646]
[null,null,null,null,4.3999999999999924,207.35824321061094,0.14106558617468568,0.14899164562780154]
[null,null,null,null,4.4499999999999922,208.51271015087403,0.1432823917924525,0.15055039831758987]
[null,null,null,null,4.499999999999992,209.65338909625922,0.14550108127994377,0.15210629591208391]
[null,null,null,null,4.5499999999999918,210.77890519292961,0.14772042795212392,0.15365934364082989]
[null,null,null,null,4.5999999999999917,211.88788731093945,0.14993918098210235,0.15520954672379539]
[null,null,null,null,4.6499999999999915,212.97896458985912,0.15215606374058965,0.15675691037138639]
[null,null,null,null,4.6999999999999913,214.05076771415705,0.1543697751367421,0.15830143978446554]
[null,null,null,null,4.7499999999999911,215.10192011296658,0.15657898425099082,0.15984314015436951]
[null,null,null,null,4.7999999999999909,216.13105632543895,0.15878234294825433,0.16138201666292573]
[null,null,null,null,4.8499999999999908,217.1368044074525,0.16097847465961523,0.16291807448247075]
[null,null,null,null,4.8999999999999906,218.11779048502873,0.16316597771875518,0.16445131877586694]
[null,null,null,null,4.9499999999999904,219.07264634244348,0.16534343090453862,0.1659817546965201]
[null,null,null,null,4.9999999999999902,219.99999999999883,0.16750938738839627,0.16750938738839705]
[null,null,null,null,5.0499999999999901,220.89881126654461,0.16966260944986644,0.16903422198604223]
[null,null,null,null,5.0999999999999899,221.76936632832104,0.1718027773710018,0.17055626361459575]
[null,null,null,null,5.1499999999999897,222.61227974865668,0.17392981564464072,0.17207551738981008]
[null,null,null,null,5.1999999999999895,223.42816922879874,0.17604366885886713,0.17359198841806722]
[null,null,null,null,5.2499999999999893,224.21764959022275,0.17814429721388914,0.1751056817963963]
[null,null,null,null,5.2999999999999892,224.98133774711474,0.18023167981945931,0.17661660261249046]
[null,null,null,null,5.349999999999989,225.71985037272378,0.18230581281904668,0.17812475594472377]
[null,null,null,null,5.3999999999999888,226.43380264993095,0.18436670824384371,0.1796301468621686]
[null,null,null,null,5.4499999999999886,227.12381167764076,0.18641439627464107,0.18113278042461256]
[null,null,null,null,5.4999999999999885,227.7904928624616,0.1884489223903526,0.18263266168257541]
[null,null,null,null,5.5499999999999883,228.43446282171067,0.1904703492898252,0.18412979567732601]
[null,null,null,null,5.5999999999999881,229.0563379661877,0.19247875564699768,0.18562418744089959]
[null,null,null,null,5.6499999999999879,229.65673401227727,0.19447423553335441,0.18711584199611431]
[null,null,null,null,5.6999999999999877,230.23626754259018,0.19645689939403532,0.18860476435658824]
[null,null,null,null,5.7499999999999876,230.79555446281881,0.19842687268881765,0.19009095952675625]
[null,null,null,null,5.7999999999999874,231.33521113643584,0.20038429656216716,0.19157443250188688]
[null,null,null,null,5.8499999999999872,231.8558537548162,0.2023293271773029,0.19305518826809909]
[null,null,null,null,5.899999999999987,232.35809848179906,0.20426213564177453,0.19453323180237869]
[null,null,null,null,5.9499999999999869,232.84255384035592,0.20618290183366672,0.19600856807259592]
[null,null,null,null,5.9999999999999867,233.3098590373977,0.20809184439500528,0.19748120203752106]
[null,null,null,null,6.0499999999999865,233.76060726324806,0.20998916017976921,0.19895113864684211]
[null,null,null,null,6.0999999999999863,234.19542238471266,0.21187508445665604,0.20041838284118063]
[null,null,null,null,6.1499999999999861,234.61492070459971,0.21374986064089208,0.20188293955210856]
[null,null,null,null,6.199999999999986,235.01971822454615,0.21561374584014059,0.20334481370216539]
[null,null,null,null,6.2499999999999858,235.41043123230168,0.21746701116456313,0.20480401020487382]
[null,null,null,null,6.2999999999999856,235.78767592555138,0.21930994126584125,0.20626053396475685]
[null,null,null,null,6.3499999999999854,236.15206850198044,{"$f":"1-EXP(-E140*F140/(1-RecoveryRate)/10000)","v":0.22114283425242831},{"$f":"1-EXP(-E140*fiveyrspread/(1-RecoveryRate)/10000)","v":0.20771438987735402}]
[null,null,null,null,6.3999999999999853,{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E141)","v":236.50422532678257},0.22296600167358671,0.20916558282923792]
[null,null,null,null,6.4499999999999851,236.84476227252125,0.22477976782015807,0.21061411769803073]
[null,null,null,null,6.4999999999999849,237.17429569363412,0.22658447037876361,0.21205999935242037]
[null,null,null,null,6.5499999999999847,237.49344178780635,0.2283804597550505,0.21350323265217719]
[null,null,null,null,6.5999999999999845,237.80281685368706,0.23016809913999803,0.21494382244817012]
[null,null,null,null,{"$f":"E145+0.05","v":6.6499999999999844},238.10303689026009,0.23194776402376993,0.21638177358238264]
[null,null,null,null,6.6999999999999842,238.39471829950509,0.23371984264378043,0.21781709088792978]
[null,null,null,null,6.749999999999984,238.67847706749842,0.23548473514331558,0.21924977918907385]
[null,null,null,null,6.7999999999999838,238.95492955176124,0.23724285409736434,0.22067984330124069]
[null,null,null,null,6.8499999999999837,239.22469189583941,0.23899462386655068,0.22210728803103608]
[null,null,null,null,6.8999999999999835,239.48838026830489,0.24074048065536136,0.22353211817626173]
[null,null,null,null,6.9499999999999833,239.74661090865723,0.24248087240672433,0.22495433852593139]
[null,null,null,null,6.9999999999999831,239.99999999999861,0.24421625854427276,0.22637395386028691]
[null,null,null,null,7.0499999999999829,240.24907268746131,0.24594702921233125,0.22779096895081463]
[null,null,null,null,7.0999999999999828,240.49399072600386,0.24767326073390261,0.22920538856026107]
[null,null,null,null,7.1499999999999826,240.7348239784688,0.24939495066663586,0.23061721744264885]
[null,null,null,null,7.1999999999999824,240.97164315442043,0.25111209917446409,0.23202646034329333]
[null,null,null,null,7.2499999999999822,241.20451867618743,0.25282470800074308,0.23343312199881761]
[null,null,null,null,7.2999999999999821,241.43352118218633,0.25453278089802511,0.23483720713716905]
[null,null,null,null,7.3499999999999819,241.65872064909621,0.25623632281217146,0.23623872047763528]
[null,null,null,null,7.3999999999999817,241.8801877290594,0.25793534107216509,0.23763766673085973]
[null,null,null,null,7.4499999999999815,242.09799284440462,0.25962984455155136,0.23903405059885741]
[null,null,null,null,7.4999999999999813,242.31220658116339,0.26131984400700992,0.24042787677503097]
[null,null,null,null,7.5499999999999812,242.52289902179214,0.26300535144292825,0.24181914994418641]
[null,null,null,null,7.599999999999981,242.73014076504077,0.26468638103141684,0.24320787478254879]
[null,null,null,null,7.6499999999999808,242.93400223323809,0.26636294845513908,0.24459405595777772]
[null,null,null,null,7.6999999999999806,243.1345539640603,0.26803507115841207,0.24597769812898362]
[null,null,null,null,7.7499999999999805,243.33186613768177,0.26970276788416492,0.24735880594674275]
[null,null,null,null,7.7999999999999803,243.52600930348981,0.27136605933613667,0.24873738405311341]
[null,null,null,null,7.8499999999999801,243.71705396553861,0.2730249677728751,0.25011343708165101]
[null,null,null,null,7.8999999999999799,243.90507037200226,0.27467951678693314,0.2514869696574239]
[null,null,null,null,7.9499999999999797,244.09012903789034,0.27632973178245579,0.25285798639702906]
[null,null,null,null,7.9999999999999796,244.27230038553168,0.27797563961570326,0.25422649190860724]
[null,null,null,null,8.0499999999999794,244.4516548776769,0.27961726870352832,0.25559249079185908]
[null,null,null,null,8.0999999999999801,244.62826284611452,0.28125464883960849,0.2569559876380596]
[null,null,null,null,8.1499999999999808,244.80219476354324,0.28288781143869568,0.25831698703007466]
[null,null,null,null,8.1999999999999815,244.97352105229183,0.28451678933427826,0.25967549354237573]
[null,null,null,null,8.2499999999999822,245.14231213783705,0.2861416168123383,0.26103151174105532]
[null,null,null,null,8.2999999999999829,245.30863842752251,0.28776232957275127,0.26238504618384251]
[null,null,null,null,8.3499999999999837,245.47257035576573,0.28937896475609881,0.26373610142011839]
[null,null,null,null,8.3999999999999844,245.63417834489542,0.29099156088786171,0.26508468199093083]
[null,null,null,null,8.4499999999999851,245.79353278714407,0.29260015784294879,0.26643079242901035]
[null,null,null,null,8.4999999999999858,245.95070415735125,0.2942047969406566,0.26777443725878503]
[null,null,null,null,8.5499999999999865,246.10576283307927,0.29580552074858502,0.26911562099639552]
[null,null,null,null,8.5999999999999872,246.25877927827503,0.29740237324889274,0.2704543481497107]
[null,null,null,null,8.6499999999999879,246.40982386672312,0.29899539964458355,0.27179062321834269]
[null,null,null,null,8.6999999999999886,246.55896707672596,0.30058464653860872,0.27312445069366142]
[null,null,null,null,8.7499999999999893,246.70627926821632,0.30217016169226585,0.27445583505881088]
[null,null,null,null,8.7999999999999901,246.85183093284471,0.30375199426197741,0.27578478078872271]
[null,null,null,null,8.8499999999999908,246.99569241769947,0.3053301945020821,0.27711129235013277]
[null,null,null,null,8.8999999999999915,247.1379342267719,0.30690481405593129,0.27843537420159492]
[null,null,null,null,8.9499999999999922,247.27862669531328,0.30847590560645333,0.27975703079349656]
[null,null,null,null,8.9999999999999929,247.41784033864815,0.31004352321810902,0.28107626656807361]
[null,null,null,null,9.0499999999999936,247.55564548119835,0.31160772193870501,0.28239308595942547]
[null,null,null,null,9.0999999999999943,247.6921126486142,0.31316855818865452,0.28370749339352952]
[null,null,null,null,9.149999999999995,247.82731215549538,0.31472608931761059,0.28501949328825649]
[null,null,null,null,9.1999999999999957,247.96131453681068,0.31628037403738352,0.28632909005338503]
[null,null,null,null,9.2499999999999964,248.09419009834497,0.31783147193705485,0.28763628809061648]
[null,null,null,null,9.2999999999999972,248.22600935177095,0.31937944392246886,0.28894109179359018]
[null,null,null,null,9.3499999999999979,248.35684268988786,0.32092435186030133,0.29024350554789746]
[null,null,null,null,9.3999999999999986,248.48676053521319,0.32246625871824941,0.29154353373109676]
[null,null,null,null,9.4499999999999993,248.61583331026458,0.32400522851833768,0.29284118071272869]
[null,null,null,null,9.5,248.74413143755964,0.32554132632142607,0.29413645085432993]
[null,null,null,null,9.5500000000000007,248.87172533961589,{"$f":"1-EXP(-E204*F204/(1-RecoveryRate)/10000)","v":0.32707461821175954},{"$f":"1-EXP(-E204*fiveyrspread/(1-RecoveryRate)/10000)","v":0.2954293485094488}]
[null,null,null,null,9.6000000000000014,{"$f":"CubicSpline($B$34:$B$38,$C$11:$C$15,E205)","v":248.99868543895099},0.32860517128155708,0.29671987802365918]
[null,null,null,null,9.6500000000000021,249.12508213996492,0.330133053596113,0.29800804373457512]
[null,null,null,null,9.7000000000000028,249.25098590120569,0.33165833425624669,0.29929384997186603]
[null,null,null,null,9.7500000000000036,249.37646712730952,0.33318108326672691,0.30057730105727098]
[null,null,null,null,9.8000000000000043,249.50159624079396,0.33470137159814339,0.30185840130461261]
[null,null,null,null,{"$f":"E209+0.05","v":9.850000000000005},249.62644365480298,0.33621927114219219,0.30313715501981242]
[null,null,null,null,9.9000000000000057,249.75107981056203,0.33773485473718035,0.30441356650090512]
[null,null,null,null,{"$f":"E211+0.05","v":9.9500000000000064},249.87557511655194,0.33924819608652435,0.30568764003805249]
[null,null,null,null,10.000000000000007,250.00000000000003,0.34075936979955657,0.30695937991355871]