Graph the bond yield to maturity

Assignment Help Financial Management
Reference no: EM13124740

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

Attachment:- Bond.xlsx

Reference no: EM13124740

Questions Cloud

Difference between identity and conditional : What is the difference between identity, conditional, and inconsistent equations? Support your answer with an example of each. What is the necessary condition for the following fraction to be valid? What value(s) of "x" that cannot be used in this ..
What is the dollar value of the ending inventory : A company manufactures a single product. During year 2012, a total of 20,000 units of this product were produced and 15,000 units were sold. The sales price was $20.00 per unit.
Little cabbage firm acquired an adjacent lot to construct : Little Cabbage Firm acquired an adjacent lot to construct. Fees paid to remove an old building from the land were $9,000. Materials salvaged from the demolition of the building were sold for $3,000. A contractor was paid $800,000 to construct a new..
India''s freedom struggle : Chapter three of Wolpert's A New History of India repeatedly refers to an Aryan "invasion" or "conquest" of India. Why is this controversial?
Graph the bond yield to maturity : Identify two possibly mispriced bond issues, one overpriced and one underpriced. and 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.
How much energy (in calories) is needed : How much energy (in calories) is needed to heat 12cm^3 of fat from room temperature (25C ) to its melting point (35C)?  Specific heat of fat 0.45 cal/(g*C, and the density of fat is .94g/cm^3)
Find test statistic-degrees of freedom and the p-value : State appropriate null and alternative hypotheses. Report the test statistic, its degrees of freedom, and the P-value. What do you conclude?
Compute the cost of the units transferred : Beginning inventory was 20% complete for conversion cost. Ending inventory was 70% complete for concersion costs. Compute the cost of the units transferred out during July and the ending inventory July 31 using the weighted-average method.
Is histogram approximately bell shaped and symmetric : Use 9 classes. Is the histogram approximately bell shaped and symmetic? Does this agree with the results predicted by the Central Limite Theorem?

Reviews

Write a Review

Financial Management Questions & Answers

  Examine the decision metric profit margin

Compare the decision metrics NPV & IRR for the "no recovery of NWC" and "recovery of NWC" scenarios, stating which scenario best captures reality. Based on your answer, give the project a green or red light - calculate the K-wacc for HCA using..

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  What is the equipment''s after-tax net salvage value

Allen Air Lines must liquidate some equipment that is being replaced. The equipment originally cost $12 million, of which 75% has been depreciated. The used equipment can be sold today for $4 million, and its tax rate is 40%. What is the equipment's ..

  Develop the executive summary

Develop the Executive Summary and Section 5, 'Summary, Recommendations and Conclusion', which includes your formal recommendation to the company.

  Complete the financial reporting for each period

Complete the financial reporting for each period

  Incremental cash flows

Discuss qualitatively how you might have incorporated the likely growth of digital photography in the sales projections developed above?  (Remember hindsight is 20-20.)

  Wal-mart cost of capital

Estimate the market value and weight of each component of the capital structure and estimate the book value and weight of each component in the capital structure.

  Develop a balanced scorecard

Develop a BSC that is aligned to the key goal in the strategic plan, i.e. exceeding revenue of $25 million dollars by 2015. Develop, quantify and justify suitable key performance measurement criteria for Anthony's Orchard in each of these four key..

  Does this change have an impact on their decision

Recalculate the NPV assuming the machine press can only be sold for $45,000 at the end of year four.  Does this change have an impact on their decision?

  What is the need of international financial management

What is the need of International Financial Management? List out the difference between domestic Finance & International Finance.

  Determine the proposed alternatives regarding insulin

Determine the two proposed alternatives regarding the insulin pump. Based upon your evaluation recognize which alternative should be selected and support your decision.

  Determine the constant growth rate in dividends

Arbitrage Financial is offering two possible investments with the same level of risk.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd