Replicate the figure, You have to use these numbers and

Replicate the figure

Reference no: EM131050662

The file I am sending you, contains everything you need for the solution. The goal of this assignment, is in page 16. You have to use these numbers and some of the formulas including here, to replicate the figures in page 12. The final figures should be similar to the figures in page 12. In the end, I want an Excel file with the numbers and the formulas(with nice tables etc) WITH explanations what you used to derive the figures.

Assignment description-

-maturity T = 5 years

-interest rate r = 0%

-recovery rate R = 40%

-average dirty spread s = 35 bp

-average clean spread λ = s/(1-R)

-term default probability p^-_T = 1 - e^-λT

Tranche	Equity	BBB	AAA	Junior	Senior
Range	0-3%	3-6%	6-9%	9-12%	12-22%
Spread (bp)	1027	106	43	27	17

Replicate the figure on page 12.

Attachment:- Credit Risk.rar

Reference no: EM131050662

Questions Cloud

Meeting fcc specifications : A radio station must broadcast at exactly 103.1 MHz. In a random sample of 25 days they average 103.8 MHz. The SD at radio stations with similar equipment is .1 MHz. At level of significance a = .05, are they meeting FCC specifications? Do ..

Calculate a confidence interval for a population mean : A sample survey of 54 discount brokers showed that the mean price charged for a trade of 100 shares at $50 per share was $33.77 (AAII Journal, February 2006).

Normally distributed population with mean : An observation was drawn from a normally distributed population with mean 2.397 and standard deviation 0.612. If the observed value is 3.144, find the z-score. Give your answer accurate to 3 decimal places.

Replicate the figure : You have to use these numbers and some of the formulas including here, to replicate the figures. The final figures should be similar to the figures

Test the claim that there is no difference : That way you will have evidence to present to the director if you implement the cut in hours. Test the claim that there is no difference at the .01 significance level. Can you implement your staffing changes?

Difference between mean gpa for four sororities : The Greek Council is comparing the mean GPAs of four sororities on campus. The GPAs for 10 girls in each sorority are given in the following table. Based on these data, can you conclude that there is a difference between the mean GPAs for these fo..

How one can become a more effective speaker and communicator : Reflection and analysis are important parts of the communication process. Self evaluation is vital to understanding how one can become a more effective speaker and communicator.

Study the ages of couples applying for marriage licenses : A student wanted to study the ages of couples applying for marriage licenses in his county. He studied a sample of 94 marriage licenses and found that in 67 cases the husband was older than the wife.

User Account

All Pages