CS计算机代考程序代写 Excel Financial Engineering – IC302

Financial Engineering – IC302
Autumn Term 2020/1
Seminar 4: Credit Derivatives Questions
1. Use the credit default swap confirmation at the end of this exercise to answer the following questions.
(a) Which institution is buying credit protection and which is selling protection?
(b) Which entity’s credit risk is being transferred?
(c) Suppose that on the trade date the par spread for the reference entity is 90 basis points. Given that the CDS has a fixed coupon of 100 bp, which counterparty would be required to make an upfront payment?
(d) According to the confirmation, which of the following constitutes a credit event?
Bankruptcy
Obligation Acceleration / default Failure to pay
Repudiation / moratorium Restructuring
(e) Suppose a credit event is declared and as a result of the auction the deliverable obligations are valued at 38.00. How much would the protection buyer receive on this transaction?
2. The calculations required by the questions in this exercise may be performed using the Excel workbook CDS-Simplified Pricing.
In the course notes, we described the pricing and revaluation of a five-year CDS under the following assumptions:
• Annual premium payments
• Fixed coupon 100 basis points per year
• Recovery rate 40%
• Risk-free interest rate 1% per year
• Conditional default probability 0.016393 per year

We showed that, under these assumptions, the risky PV01 of the CDS would be approximately 4.621. The intermediate values leading to this result are shown below:
(a) Suppose that we were to repeat the risky PV01 calculation performed above for a 5-year CDS on a reference entity with constant conditional default probability of 2% per year. Other things remaining equal, what effect will this increase in the conditional default probability have on the risky PV01? What explanation can you offer for this result?
(b) The constant conditional default probability of 1.6393% per year in our original example was consistent with a par spread of 100 bp per year and resulted in a risky PV01 of approximately 4.621. Suppose instead that the par spread on the reference entity were 75 bp per year. Will this result in a risky PV01 greater than, less than, or equal to 4.621? What explanation can you offer for this result?
[Hint: You can calculate the risky PV01 that is consistent with a breakeven spread of 75 bp per year by using Goal Seek in Excel to set the spread (cell K12) equal to 75 by choosing an appropriate value for the conditional default probability (cell B6).]
(c) With a par spread of 75 bp and a fixed coupon of 100 bp as in part (b) of the question, the CDS will require an upfront payment in order to be fairly valued. How large is this payment and which party will make it? What explanation can you offer for this result?
3. Suppose that you sell protection on a 4-6% tranche of a 100-name equally weighted CDS index.
(a) If the recovery rate on each entity is 50%, what is the maximum number of defaults that can occur before you suffer any losses?
(b) For the same parameters as in the previous question, how many defaults will it take to exhaust your tranche (i.e. for you to suffer a complete loss)?

(c) Suppose that we create a 4-5% tranche on the portfolio described in the previous questions. How would you expect the spread on this tranche to compare with the spread on the 4-6% tranche described earlier?
(d) Suppose that we wanted to create a tranche with 1% width that had similar credit risk (in terms of expected losses) to the 4-6% tranche described earlier in this question. Would this tranche need to have attachment point higher or lower than 4%? Explain your answer.

Credit Default Swap Confirmation
The purpose of this agreement is to confirm the conditions of the credit derivative transaction entered into between Barclays Bank plc (“Party A”) and Deutsche Bank AG (“Party B”) on the trade date specified below.
The terms of the transaction to which this confirmation relates are as follows:
General Terms
Trade date
Effective date
Scheduled Termination date Floating rate payer
Fixed rate payer
Calculation agent Calculation agent City Business Days
Business day convention
Reference Entity Reference Obligation Maturity
Original issue amount Reference price
Fixed payments
Fixed rate payer calculation amount Fixed rate payer payment dates
Par spread
Fixed coupon
Fixed rate day count fraction Initial upfront adjustment
Floating Payment
Floating rate payer calculation amount
Friday 18th September 2018 Monday 21st September 2018 Sunday 20th December 2023 Barclays Bank plc (the “seller”) Deutsche Bank AG (“the “buyer”) Seller
London
London and New York and solely for the purposes of physical settlement, if applicable a day in any other jurisdiction in which banks must be open in order to effect the settlement of any deliverable obligation being delivered in the portfolio.
Following
Sandridge Energy Inc 5.00% senior note 1st October 2025 $650,000,000
100%
$ 10,000,000
20th December 2018 and then June 20 and December in each year thereafter. 90 bps
100 basis points p.a.
Actual / 360
$42,060
$10,000,000 minus auction recovery amount

Credit events
The following credit events shall apply to this transaction:
1. Bankruptcy
2. Failure to pay
Grace period extension: Payment requirement:
Obligations
Obligation category Obligation characteristics Excluded obligations
Settlement terms
Settlement method
Deliverable Obligations
Deliverable Obligation Category Deliverable obligation characteristics
Not applicable
USD1, 000,000 or its equivalent in the relevant obligation currency as of the occurrence of the relevant failure to pay
Borrowed money None
None
Auction with option to physically settle Exclude accrued interest
Bond or Loan
Bond or loan
Not subordinated
Specified currency: standard specified currencies
Transferable
Assignable loan
Consent required loan
Not contingent
Maximum maturity of 30 years
Not bearer
None
Excluded deliverable obligations