Spreadsheet: rick_buy__32847__Sum 10-17 E11
Sheet: Survival Rates

Eff. Date
 |  |  | 2000-12-01 00:00:00 |  |  | 2001-04-01 00:00:00 |  |  | 2001-06-29 00:00:00 |  |  | Change
S&P | E-Rating | Year
AAA | 1 | 1 | 0.9885389388253976 |  |  | 0.9924777312670574 |  |  | 0.9916539386215432
[NAME] | 1 | 2 | 0.9716494628050947 |  |  | 0.9821621465828595 |  |  | 0.9880856715141784
 | 1 | 3 | 0.9569297739371645 |  |  | 0.9710169777969877 |  |  | 0.9748777105729789
 | 1 | 4 | 0.937757326846118 |  |  | 0.95863995902347 |  |  | 0.9633904679319447
 | 1 | 5 | 0.9104290874849932 |  |  | 0.9428303505090203 |  |  | 0.9520846407259327
 | 1 | 6 | 0.8917083887984456 |  |  | 0.9294787019086626 |  |  | 0.9361237482786402
 | 1 | 7 | 0.8725915804146323 |  |  | 0.9154260591886718 |  |  | 0.9179693475300493
 | 1 | 8 | 0.8460456056360934 |  |  | 0.9093496753059631 |  |  | 0.9187051762102696
 | 1 | 9 | 0.81764053087953 |  |  | 0.9046760731498982 |  |  | 0.9226055243983063
 | 1 | 10 | 0.7875343768180907 |  |  | 0.9014520540421802 |  |  | 0.9299357957475575
 | 1 | 11 | 0.7698647444030099 |  |  | 0.8876798957712102 |  |  | 0.916216421891296
 | 1 | 12 | 0.752588210708449 |  |  | 0.8731689300378234 |  |  | 0.9013814244678582
 | 1 | 13 | 0.7355921045020337 |  |  | 0.8579150375273823 |  |  | 0.8854308035254064
 | 1 | 14 | 0.7188954185078926 |  |  | 0.841884724935559 |  |  | 0.868344815272833
 | 1 | 15 | 0.7024716050350264 |  |  | 0.8250631061412403 |  |  | 0.850122572828248
AA-/A+ | 2 | 1 | 0.986832451712299 |  |  | 0.9896466355448723 |  |  | 0.9888269849597618
 | 2 | 2 | 0.9668062171874136 |  |  | 0.9770598373824282 |  |  | 0.9835899599491055
 | 2 | 3 | 0.9484117257862852 |  |  | 0.9632305903357015 |  |  | 0.9655873546256069
 | 2 | 4 | 0.922601123051114 |  |  | 0.9474292253833678 |  |  | 0.9502017073960396
 | 2 | 5 | 0.8893876706094338 |  |  | 0.9253964960223925 |  |  | 0.9337289127443514
 | 2 | 6 | 0.8668738328742099 |  |  | 0.9078290141403842 |  |  | 0.9158005647141684
 | 2 | 7 | 0.8440594840211181 |  |  | 0.8893193974116664 |  |  | 0.8962441228977339
 | 2 | 8 | 0.8148650320742556 |  |  | 0.8819217940541693 |  |  | 0.8984491310073329
 | 2 | 9 | 0.784160153541793 |  |  | 0.8764340501568089 |  |  | 0.9049754128582257
 | 2 | 10 | 0.7521187639663536 |  |  | 0.8729154424348659 |  |  | 0.9162100761072292
 | 2 | 11 | 0.7300136228087717 |  |  | 0.8535029498595703 |  |  | 0.8981395931460663
 | 2 | 12 | 0.7081671320140874 |  |  | 0.8329170439739513 |  |  | 0.8785445902953377
 | 2 | 13 | 0.6864519919199215 |  |  | 0.8111672406361411 |  |  | 0.8574426236751966
 | 2 | 14 | 0.6648894411313224 |  |  | 0.788227213587831 |  |  | 0.8348296810480156
 | 2 | 15 | 0.6434473797536373 |  |  | 0.7640952654042893 |  |  | 0.8107272152914058
A/A- | 3 | 1 | 0.9816868386374423 |  |  | 0.9859164579910064 |  |  | 0.9857726695973921
 | 3 | 2 | 0.9534752349059439 |  |  | 0.9687675930268529 |  |  | 0.9745376703192546
 | 3 | 3 | 0.925385737232917 |  |  | 0.9474773931700511 |  |  | 0.9504461221845375
 | 3 | 4 | 0.8908130823773186 |  |  | 0.9230751550497116 |  |  | 0.9346011235949865
 | 3 | 5 | 0.8513316766720836 |  |  | 0.9034053735296612 |  |  | 0.9153948881602629
 | 3 | 6 | 0.818025193083694 |  |  | 0.8795176101201682 |  |  | 0.8922114611483829
 | 3 | 7 | 0.7835717035136172 |  |  | 0.8541770794344155 |  |  | 0.8669607964421193
 | 3 | 8 | 0.748950608614342 |  |  | 0.8400647901126441 |  |  | 0.8611351702073076
 | 3 | 9 | 0.7135595859094276 |  |  | 0.827315988593456 |  |  | 0.8583763146868048
 | 3 | 10 | 0.6775976621499956 |  |  | 0.8159173249298027 |  |  | 0.8588608583929096
 | 3 | 11 | 0.6501792141950736 |  |  | 0.7914599948893533 |  |  | 0.8349670463225669
 | 3 | 12 | 0.6233294152006496 |  |  | 0.7659619403718617 |  |  | 0.8095677384597262
 | 3 | 13 | 0.5968885207044718 |  |  | 0.7394598350338153 |  |  | 0.7827217324743014
 | 3 | 14 | 0.5708783902321111 |  |  | 0.711943845346314 |  |  | 0.7544560604725692
 | 3 | 15 | 0.5452570187291835 |  |  | 0.6834377641776539 |  |  | 0.7248336384608762
BBB+/BBB | 4 | 1 | 0.9766500128423616 |  |  | 0.9792141679951331 |  |  | 0.9805068000545196
 | 4 | 2 | 0.9444543375806779 |  |  | 0.9545614921298549 |  |  | 0.964639394034037
 | 4 | 3 | 0.9138948039367756 |  |  | 0.9292856199179356 |  |  | 0.9329984335492973
 | 4 | 4 | 0.8785551779876359 |  |  | 0.902870122133596 |  |  | 0.911203353682521
 | 4 | 5 | 0.8353197613070638 |  |  | 0.8778818477996873 |  |  | 0.8904580774134454
 | 4 | 6 | 0.8024280646275694 |  |  | 0.850578837286625 |  |  | 0.8615797467689498
 | 4 | 7 | 0.7694205132786933 |  |  | 0.8223833706542931 |  |  | 0.8305198883926201
 | 4 | 8 | 0.7296466575012709 |  |  | 0.8030012360988195 |  |  | 0.8255250786663648
 | 4 | 9 | 0.688720351476754 |  |  | 0.7847568510175685 |  |  | 0.8249340346384708
 | 4 | 10 | 0.6469519381300168 |  |  | 0.7675965966800122 |  |  | 0.8290215398874086
 | 4 | 11 | 0.6192533494600205 |  |  | 0.7410279077089084 |  |  | 0.8008257089651593
 | 4 | 12 | 0.5924555663378581 |  |  | 0.7138712908073224 |  |  | 0.7710939722339377
 | 4 | 13 | 0.5663756004983643 |  |  | 0.6861715884000016 |  |  | 0.7399222888417032
 | 4 | 14 | 0.5410241754924197 |  |  | 0.6579176132410527 |  |  | 0.7073690915229407
 | 4 | 15 | 0.5163464262492798 |  |  | 0.6291378747471583 |  |  | 0.6735356432529631
BBB- | 5 | 1 | 0.9704453861538808 |  |  | 0.9708115783827742 |  |  | 0.9710149648376419
 | 5 | 2 | 0.9328439058127318 |  |  | 0.9407082527588412 |  |  | 0.9400174440755091
 | 5 | 3 | 0.8976220572041447 |  |  | 0.9111662818206728 |  |  | 0.9143336155368263
 | 5 | 4 | 0.8567245465377255 |  |  | 0.8809209501581251 |  |  | 0.8885972730085677
 | 5 | 5 | 0.809873903533891 |  |  | 0.8512003792512156 |  |  | 0.8557773742958011
 | 5 | 6 | 0.7744122653108165 |  |  | 0.8199967009030174 |  |  | 0.8234293515252941
 | 5 | 7 | 0.7395468749910541 |  |  | 0.7883925110843798 |  |  | 0.7900088116616026
 | 5 | 8 | 0.6994964616660189 |  |  | 0.7659032501704724 |  |  | 0.776181869122203
 | 5 | 9 | 0.659091472625419 |  |  | 0.7448823001864538 |  |  | 0.7657260312868569
 | 5 | 10 | 0.618576906834711 |  |  | 0.7252517432196165 |  |  | 0.7587044102507853
 | 5 | 11 | 0.587670086673561 |  |  | 0.6951706579540173 |  |  | 0.7278162136122911
 | 5 | 12 | 0.5577073009965137 |  |  | 0.6646919154307087 |  |  | 0.6961077601151586
 | 5 | 13 | 0.5284992548238195 |  |  | 0.633876369166535 |  |  | 0.6636839982588236
 | 5 | 14 | 0.5000611789270037 |  |  | 0.6027213908304135 |  |  | 0.6305960830599145
 | 5 | 15 | 0.4723383864998142 |  |  | 0.5712690604685816 |  |  | 0.5969426263174027
BB+ | 6 | 1 | 0.945253727436901 |  |  | 0.9538320282523371 |  |  | 0.9534633435158728
 | 6 | 2 | 0.887382039259099 |  |  | 0.9040430820930574 |  |  | 0.9143720644226517
 | 6 | 3 | 0.8366959134645976 |  |  | 0.861111341253876 |  |  | 0.8719165397264329
 | 6 | 4 | 0.7806577570450666 |  |  | 0.813560439479598 |  |  | 0.8323333834392983
 | 6 | 5 | 0.7216196232709614 |  |  | 0.7678795578848272 |  |  | 0.7871455753001086
 | 6 | 6 | 0.6745294327616186 |  |  | 0.7266326302733264 |  |  | 0.7468680056420114
 | 6 | 7 | 0.6297452541385351 |  |  | 0.6868621237166109 |  |  | 0.7072152313167271
 | 6 | 8 | 0.5789012188793117 |  |  | 0.6500876861918548 |  |  | 0.6874089870540803
 | 6 | 9 | 0.5292048072245565 |  |  | 0.6147612401610546 |  |  | 0.6717659541080914
 | 6 | 10 | 0.4809592111544356 |  |  | 0.5807355845608336 |  |  | 0.6602427461655316
 | 6 | 11 | 0.4472421926705171 |  |  | 0.5460302166175959 |  |  | 0.6262539483564119
 | 6 | 12 | 0.415685308800238 |  |  | 0.5122577447889859 |  |  | 0.592554377479392
 | 6 | 13 | 0.3859734250304401 |  |  | 0.4794427521455683 |  |  | 0.5592281380540469
 | 6 | 14 | 0.3580359879267703 |  |  | 0.4475299332742907 |  |  | 0.5262861208266206
 | 6 | 15 | 0.3317322290379036 |  |  | 0.416520685071918 |  |  | 0.4937937394041464
BB | 7 | 1 | 0.9388508922640375 |  |  | 0.9498796281601928 |  |  | 0.9505204601190888
 | 7 | 2 | 0.8747773228267771 |  |  | 0.900026350839207 |  |  | 0.906135454658482
 | 7 | 3 | 0.8180110570755836 |  |  | 0.8548979661211782 |  |  | 0.8597969863681013
 | 7 | 4 | 0.7569422086976795 |  |  | 0.8073815268258818 |  |  | 0.8186758993056402
 | 7 | 5 | 0.6973079734530689 |  |  | 0.7570913865922515 |  |  | 0.7653954808013999
 | 7 | 6 | 0.6455306860737602 |  |  | 0.7136070191475153 |  |  | 0.7272691217107391
 | 7 | 7 | 0.59624619247192 |  |  | 0.6716001318715851 |  |  | 0.691374527265602
 | 7 | 8 | 0.5471177162535904 |  |  | 0.6336270263333804 |  |  | 0.6658629810756581
 | 7 | 9 | 0.5000524528194497 |  |  | 0.5972651862620735 |  |  | 0.6437371050908731
 | 7 | 10 | 0.4551815660868418 |  |  | 0.5623540656628189 |  |  | 0.6248459645699196
 | 7 | 11 | 0.4204108067296457 |  |  | 0.52748464048339 |  |  | 0.5898867323146926
 | 7 | 12 | 0.3880334920090182 |  |  | 0.4937369600700194 |  |  | 0.5555320028860904
 | 7 | 13 | 0.3577074114287027 |  |  | 0.4611226402591129 |  |  | 0.5218549485247411
 | 7 | 14 | 0.3293415862459697 |  |  | 0.429572671802673 |  |  | 0.4888515501871418
 | 7 | 15 | 0.3027758359860052 |  |  | 0.3990764008843123 |  |  | 0.4565740750113842
BB- | 8 | 1 | 0.9283152689765366 |  |  | 0.9359421190783818 |  |  | 0.9443925613355763
 | 8 | 2 | 0.8552300899878121 |  |  | 0.8726905139005378 |  |  | 0.8933806034669831
 | 8 | 3 | 0.7898255531500145 |  |  | 0.8142739740805106 |  |  | 0.8413406271754855
 | 8 | 4 | 0.7229951936746747 |  |  | 0.7513890264081481 |  |  | 0.7920204151814307
 | 8 | 5 | 0.6584191853267313 |  |  | 0.6952917222931687 |  |  | 0.7343867990694927
 | 8 | 6 | 0.6037202726516978 |  |  | 0.644971673729172 |  |  | 0.6921237862909702
 | 8 | 7 | 0.5526747091543572 |  |  | 0.5975629280761776 |  |  | 0.6525704979971848
 | 8 | 8 | 0.500543121955103 |  |  | 0.5548684254998826 |  |  | 0.6194186072117434
 | 8 | 9 | 0.4512178960994531 |  |  | 0.5148019479688429 |  |  | 0.5890786892384652
 | 8 | 10 | 0.4047917299476634 |  |  | 0.477103581751559 |  |  | 0.5613001069956124
 | 8 | 11 | 0.368477509061768 |  |  | 0.4402312923417248 |  |  | 0.5237731184742934
 | 8 | 12 | 0.3349526082708496 |  |  | 0.4052688653978356 |  |  | 0.4873266342251511
 | 8 | 13 | 0.3038330556576208 |  |  | 0.3721683727669526 |  |  | 0.4520226259510359
 | 8 | 14 | 0.2749911404823492 |  |  | 0.3408003477526551 |  |  | 0.4178404915825405
 | 8 | 15 | 0.2482342114783727 |  |  | 0.3110995940875479 |  |  | 0.3848172005870319
B+/B | 9 | 1 | 0.9097645469243529 |  |  | 0.9318752353482772 |  |  | 0.934628138506791
 | 9 | 2 | 0.8218049640612688 |  |  | 0.8653498922991236 |  |  | 0.8755135166887059
 | 9 | 3 | 0.7456145770525406 |  |  | 0.8027009194749795 |  |  | 0.8144743908594663
 | 9 | 4 | 0.6712676223874185 |  |  | 0.7370199088969115 |  |  | 0.7596383188588303
 | 9 | 5 | 0.5994558697235202 |  |  | 0.6776241362230777 |  |  | 0.7006129573674568
 | 9 | 6 | 0.536537060175841 |  |  | 0.6256514969541884 |  |  | 0.655917661906801
 | 9 | 7 | 0.4784584446369911 |  |  | 0.5770137408508611 |  |  | 0.6149381841745951
 | 9 | 8 | 0.4222063155524702 |  |  | 0.5345157563210329 |  |  | 0.579252640580159
 | 9 | 9 | 0.3701155095246211 |  |  | 0.4950710140167349 |  |  | 0.5468254374130255
 | 9 | 10 | 0.3221858751344602 |  |  | 0.4583633228101623 |  |  | 0.5173388957738061
 | 9 | 11 | 0.286947916281888 |  |  | 0.4199268977701864 |  |  | 0.4782274589799639
 | 9 | 12 | 0.2551585966801713 |  |  | 0.3835419338075006 |  |  | 0.4406375318243886
 | 9 | 13 | 0.2263249083012197 |  |  | 0.3491588815785978 |  |  | 0.4046071805426863
 | 9 | 14 | 0.2002155094766628 |  |  | 0.3166461202695161 |  |  | 0.3700890542987053
 | 9 | 15 | 0.1765529832293137 |  |  | 0.2859352469360191 |  |  | 0.3370946059162238
B- | 10 | 1 | 0.8679158895774036 |  |  | 0.902150304798725 |  |  | 0.9076147573156008
 | 10 | 2 | 0.7514304340189031 |  |  | 0.8098587602976605 |  |  | 0.825618179265021
 | 10 | 3 | 0.6553468525079889 |  |  | 0.726251190235115 |  |  | 0.7461240542254649
 | 10 | 4 | 0.5626584523477627 |  |  | 0.6472886358687308 |  |  | 0.674766773221193
 | 10 | 5 | 0.4794968313695128 |  |  | 0.573661557142864 |  |  | 0.6019620441901881
 | 10 | 6 | 0.4150156057763506 |  |  | 0.5101074218890999 |  |  | 0.5444725623093417
 | 10 | 7 | 0.359305014666932 |  |  | 0.4522483239551787 |  |  | 0.492303417119588
 | 10 | 8 | 0.3071688195635073 |  |  | 0.4046187243802191 |  |  | 0.4469318993926891
 | 10 | 9 | 0.2615602054958398 |  |  | 0.361804627003749 |  |  | 0.4058052925639504
 | 10 | 10 | 0.2218322995421381 |  |  | 0.3232187133892065 |  |  | 0.3683831236435501
 | 10 | 11 | 0.1922081684390413 |  |  | 0.2893364927907469 |  |  | 0.3308652396479524
 | 10 | 12 | 0.1667085128098891 |  |  | 0.2587773094688243 |  |  | 0.2963382204557116
 | 10 | 13 | 0.1446172716152458 |  |  | 0.2312584389327346 |  |  | 0.2646428389539445
 | 10 | 14 | 0.1255076163859364 |  |  | 0.2064467951070084 |  |  | 0.2355483305903702
 | 10 | 15 | 0.1089548449049927 |  |  | 0.1840969777332123 |  |  | 0.2088948946960434
CCC | 11 | 1
interp | 11 | 2
 | 11 | 3
 | 11 | 4
 | 11 | 5
 | 11 | 6
 | 11 | 7
 | 11 | 8
 | 11 | 9
 | 11 | 10
 | 11 | 11
 | 11 | 12
 | 11 | 13
 | 11 | 14
 | 11 | 15
CC | 12 | 1 | 0 |  |  | 0 |  |  | 0
 | 12 | 2 | 0 |  |  | 0 |  |  | 0
 | 12 | 3 | 0 |  |  | 0 |  |  | 0
 | 12 | 4 | 0 |  |  | 0 |  |  | 0
 | 12 | 5 | 0 |  |  | 0 |  |  | 0
 | 12 | 6 | 0 |  |  | 0 |  |  | 0
 | 12 | 7 | 0 |  |  | 0 |  |  | 0
 | 12 | 8 | 0 |  |  | 0 |  |  | 0
 | 12 | 9 | 0 |  |  | 0 |  |  | 0
 | 12 | 10 | 0 |  |  | 0 |  |  | 0
 | 12 | 11 | 0 |  |  | 0 |  |  | 0
 | 12 | 12 | 0 |  |  | 0 |  |  | 0
 | 12 | 13 | 0 |  |  | 0 |  |  | 0
 | 12 | 14 | 0 |  |  | 0 |  |  | 0
 | 12 | 15 | 0 |  |  | 0 |  |  | 0