Reference no: EM13315970
Bonds and Term Structure
The excel notebook BondsSreener.xlsx includes data for non-callable BB-rated bonds. The data was extracted from Yahoo's bond screener and reports transactions that occurred on May 15, 2014 (Settlement Date).
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 in Yahoo_bond_screener.xlsx (use the DURATION function) :
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
Attachment:- BondScreener.xlsx
|
Determine what are the discharge and mass flow rate
: Water enters the lock of a ship canal through 180 ports, each port having a 2 ft by 2 ft cross section. The lock is 900 ft long and 105 ft wide. The lock is designed so that the water surface in it will rise at a maximum rate of 6 ft/min.
|
|
How much did the sound level change
: You are standing 5 m from a tractor when the operator starts it ip the intensity is 3 x10^-5 W/m^2. How much did the sound level change
|
|
What assumptions can you make regarding the system
: The flow is assumed to be laminar and the film thickness, H, constant. Using a coordinate system located on the plate at the surface of the pool, complete the following: a. Dram and sketch the system. Include coordinate system in your sketch.
|
|
Determine the resistance of the resistor
: A capacitor that is initially uncharged is connected in series with a resistor and an emf source with E=110V, What is the resistance of the resistor
|
|
Graph the bond yield to maturity
: 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 and use a polynomial regression of order three to determine the relation between the YTM and the bond maturity.
|
|
Explain how to estimate the long-term safety factors
: A 2.0m-wide strip at a depth of 1 m in a stiff clay carries a wall load of 425 kN/m. The saturated unit weight of the caly is 20kN/m^3. TRiaixal tests give the following results: c'=10 kPa, phi'=28 degree, cu=105kPa, and phi_u = 0.
|
|
How the project teams and coaches master agile methodology
: Analyze how the project teams and coaches master the agile methodology to solve business problems. Highlight the one that you believe is the most effective and support your answer.
|
|
Determine the temperature of the liquid
: The length of the mercury column at the ice point and steam point are 5.0 cm and 40.0cm respectively. What is the temperature of the liquid
|
|
Explain the different elements of property rights
: Property rights are protected in the current laws of states usually found in the form of a constitution or a bill of rights. The United States Constitution provides explicitly for the protection of private property in the Fifth Amendment and Fourteen..
|