Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

SET UP A SMART XL SIMULATION FOR CDS BELOW. WHEN I CHANGE THE VALUE OF THE INPUT VARIABLES, XL WILL AUTOMATICALLYRECOMPUTE THE CDS SPREAD CORRECTLY

SET UP A SMART XL SIMULATION FOR CDS BELOW. WHEN I CHANGE THE VALUE OF THE INPUT VARIABLES, XL WILL AUTOMATICALLYRECOMPUTE THE CDS SPREAD CORRECTLY TO THE 4TH DECIMAL POINT.

The Hazard rate = conditional probability for a reference entity is 2.95% each year.

Assume payments are made annually in arrears.

Assume that default, if it happens, always happens exactly halfway through a year.

Assume that the expected recovery rate is 24%.

Assume that the Treasury-Spot curve is flat at 6% with continuous compounding.

Assume Notional Principal = $1

Compute the 5-year CDS spread.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Microeconomics

Authors: Hal R. Varian

9th edition

978-0393123975, 393123979, 393123960, 978-0393919677, 393919676, 978-0393123968

Students also viewed these Finance questions

Question

LO 45-2 How can we reduce prejudice and discrimination?

Answered: 1 week ago