Bonds and term structure1 graph the bond yield to maturity

Assignment Help Database Management System

Reference no: EM13373980

Bonds and Term Structure

1. Graph the bond yield to maturity (YTM) on the y-axis of an XY-scatter plot, with the bond to maturity in years on the x-axis.

2. Use a polynomial regression of order three to determine the relation between the YTM and the bond maturity.

3. Identify two possibly mispriced bond issues, one overpriced and one underpriced. For each of these bonds estimate for how much it is mispriced relatively to the values represented by the model of the yield curve estimated in question 2.

4. Compute the Macauley Duration for the following bond issues that are included in the dataset (use the DURATION function) :

1174_Bonds and Term Structure.png

5. Assume that immediately after these calculations were done there was a parallel shift upwards in the term structure such that all rates were increased by 0.2%. Estimate the change in the prices of the bonds listed in question 4 (use the PRICE function).

Compute the actual change in price by estimating the new price for the new interest rate and compare with the value obtained from

277_Bonds and Term Structure1.png

Reference no: EM13373980

Questions Cloud

Bonds and term structure1 graph the bond yield to : bonds and term structure1. graph the bond yield to maturity ytm on the y-axis of an xy-scatter plot with the bond to

Write an essay addressing what is packed into this : write an essay addressing what is packed into this indicating what marcher sees about himself and his life and what he

Write a four to five 4-5 paragraph form letter to potential : write a four to five 4-5 paragraph form letter to potential customers on the range of services your business or

Trend micro is an internet antivirus software company the : trend micro is an internet antivirus software company. the main virus response center is in the philippines where

Bonds and term structure1 graph the bond yield to maturity : bonds and term structure1. graph the bond yield to maturity ytm on the y-axis of an xy-scatter plot with the bond to

You are to turn in a powerpoint presentation with detailed : you are to turn in a powerpoint presentation with detailed notes which fully detail the stakeholder issues that are of

Subjecct title conflict in martial relationships and : subjecct title conflict in martial relationships and forgiveness in marital infidelity.divided into the following

Answer one of the following questions1 what reasons do : answer one of the following questions1. what reasons do epicurus and socrates give for not fearing death?2. why does

Case study gap fillergap filler is a recruitment and labour : case study gap fillergap filler is a recruitment and labour hire company i.e. lsquostaffing solutions that services the

User Account

All Pages