As bond ratings drop, what happens to the standard deviation of yields to maturity? Pivot Table Average
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Pivot Table Average of Credit Spread Years to Maturity Rating AAA AA A ВВВ ВВ B CCC CC Grand Total V 3.000 4.000 5.000 6.000 0.008296154 0.007601818 0.011565 0.013528182 0.012418333 7.000 Grand Total 0.01019 0.010310588 0.021664 0.01814509 0.01049 0.014865645 0.0152975 0.01944 0.020461622 0.020050909 0.021979667 0.020026667 0.018989186 0.020972941 0.021506723 0.020802111 0.021336957 0.0199875 0.020593115 0.026459732 0.026777439 0.031787944 0.03069843 0.028025176 0.029100693 0.026005714 0.028875322 0.053530952 0.053429556 0.054054 0.052817 0.055784286 0.049188519 0.04502 0.05295761 0.06062 0.072980244 0.080037059 0.077369545 0.075367692 0.070026809 0.067518056 0.062456923 0.1128084 0.114232083 0.112488333 0.1230925 0.11694 0.114476 0.188656667 0.188656667 0.03828615 0.039674726 0.040025559 0.03542658 0.031392792 0.031461914 0.026874054 0.036183364 1.000 2.000 Pivot Table Average of Credit Spread Years to Maturity Rating AAA AA A ВВВ ВВ B CCC CC Grand Total V 3.000 4.000 5.000 6.000 0.008296154 0.007601818 0.011565 0.013528182 0.012418333 7.000 Grand Total 0.01019 0.010310588 0.021664 0.01814509 0.01049 0.014865645 0.0152975 0.01944 0.020461622 0.020050909 0.021979667 0.020026667 0.018989186 0.020972941 0.021506723 0.020802111 0.021336957 0.0199875 0.020593115 0.026459732 0.026777439 0.031787944 0.03069843 0.028025176 0.029100693 0.026005714 0.028875322 0.053530952 0.053429556 0.054054 0.052817 0.055784286 0.049188519 0.04502 0.05295761 0.06062 0.072980244 0.080037059 0.077369545 0.075367692 0.070026809 0.067518056 0.062456923 0.1128084 0.114232083 0.112488333 0.1230925 0.11694 0.114476 0.188656667 0.188656667 0.03828615 0.039674726 0.040025559 0.03542658 0.031392792 0.031461914 0.026874054 0.036183364 1.000 2.000
Expert Answer:
Answer rating: 100% (QA)
To determine the relationship between bond ratings and the standard deviation of yields to maturity ... View the full answer
Related Book For
Statistics For Business And Economics
ISBN: 9780321826237
12th Edition
Authors: James T. McClave, P. George Benson, Terry T Sincich
Posted Date:
Students also viewed these finance questions
-
Now suppose the investor in Problem 3 also sells forward 5,000 at a forward exchange rate of $2.10/. a. Recalculate the dollar-denominated returns for each scenario. b. What happens to the standard...
-
The mean and the standard deviation of the sample of 65 customer satisfaction ratings are and = 42.95 and s = 2.6424. a. What does the histogram in Figure 2.15 say about whether the Empirical Rule...
-
Explain what happens to the standard deviation of returns of a portfolio as the number of stocks in the portfolio increases.
-
1) Identify the population and sample from the following statements: a) A survey conducted at NSU has found that out of 371 students, 52 are left-handed b) In a rescue shelter, the height and weight...
-
Truck drivers for a hauling company, while loading a desk, found a $100 bill that had fallen out of the desk. They agreed to get it exchanged for small bills and divide the proceeds. En route to a...
-
In 1988, Nandalal's family immigrated to Canada- he was 2 years old. His grandparents and parents pooled their money and invested in a plot of land located in the greater Vancouver area. They started...
-
State Daltons law of partial pressures.
-
Hudson Companys trial balance as of January 1, the beginning of its fiscal year, is given below: Hudson Company uses a job-order costing system. During the year, the following transactions took...
-
Which do you think are more important to emphasize in a literature review, the opinions of experts in the field or related studies and why? Describe the kind of behaviours that individual team...
-
A rod on a ball and socket joint is attached to cables A and B as in Figure. (a) If a 50-N force is exerted on the massless rod at G, what is the tensile force at cables A and B? (b) Solve for the...
-
Since the grades are low, the professor decides to grade on a curve, giving an A to the top 7%, and a C to the top 55%. What is the cutoff score for an A? How many students would you expect to get an...
-
Can you think of an example of an ex post facto law?
-
Why has the common-law doctrine distinguishing between principals and accessories before the fact diminished in importance in contemporary criminal law?
-
Is it possible for the criminal law to define the crime of obscenity precisely enough to avoid the vice of vagueness or the problem of overbreadth?
-
Give an example of a law that would be constitutional per se, and point out how such a law may be unconstitutional in its application to a specific conduct.
-
How does the crime of burglary as it is typically defined under modern statutes differ from the definition of this offense under English common law?
-
What is Wisconsin's opportunity cost of 2 Cheeses? Assume that Wisconsin and Michigan can switch between producing icecreams and cheese. Wisconsin Michigan Output Produced in One Day Icecream 4...
-
A Bloomberg Businessweek subscriber study asked, In the past 12 months, when traveling for business, what type of airline ticket did you purchase most often? A second question asked if the type of...
-
While waiting in a long line for service (e.g., to use an ATM or at the post office), at some point you may decide to leave the queue. The Journal of Consumer Research (Nov. 2003) published a study...
-
Determine which pairs of the following models are "nested" models. For each pair of nested models, identify the complete and reduced model. a. E(y) = 0 + 1x1 + 2x2 b. E(y) = 0 + 1x1 c. E(y) = 0 + 1x1...
-
Write a regression model relating the mean value of y to a qualitative independent variable that can assume two levels. Interpret all the terms in the model.
-
Equity balances for Sen Widyaya appearing in the statement of financial positions of Widyayas Window Washing Services as at 30 June 2024, 2023 and 2022 are set out below. During 20222023, Sen...
-
A friend who has established a new Pilates studio, Core Strength, has asked you to give some advice as to the contents of financial statements. Transactions of Core Strength include: (a) contribution...
-
Month-end statement of financial position amounts for the practice of David Wei, an immigration lawyer, for 3 consecutive years are shown below. The information is complete except for the balance in...
Study smarter with the SolutionInn App