Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Verify that if the CDS spread for the example in Tables 24.1 to 24.4 (Lecture 6

ID: 2760648 • Letter: V

Question

Verify that if the CDS spread for the example in Tables 24.1 to 24.4 (Lecture 6 - Textbook 1) is 100 basis points and the probability of default in a year (conditional on no earlier default) must be 1.61%. How does the probability of default change when the recovery rate is 20% instead of 40%? Verify that your answer is consistent with the implied probability of default being approximately proportional to 1/ (1 R) where R is the recovery rate.

I have the answer, but i want to know how to use solver in Excel to figure this out.

Explanation / Answer

Use this link to get answer

https://financeaccountsonlinetutoring-cdsspread.googledrives/