### 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) :

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:- Bond.xlsx

#### 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?

### Write a Review

#### Analysis of the investment

Analysis of the Investment,  To prepare for this Individual Assignment: Review the Anthony's Orchard case study in the unit resources.

#### Describe vernons product life-cycle theory of fdi

Describe Vernon's product life-cycle theory of FDI

#### Prepare a statement of revenues and expenses

Prepare a statement of revenues and expenses and a statement of changes in net assets for Wise Owls for 20X1.

#### What is the default risk premium on corporate bonds

There are questions on Financial Management and Markets. Like What is the default risk premium on corporate bonds?

#### Evaluate sharpe''s beta coefficient

Evaluate Sharpes Beta Coefficient,  Evaluate the Beta Coefficient for Stock X and Stock Y using both regression and the formula given in your text. Highlight your answers in red.

#### Requirement for a code of ethics in the civil service

Requirement for a Code of Ethics in the Civil Service

#### Complute the capital asset pricing model

Compute the CAPM-β of the portfolio with respect to the market

#### Problem on financial system

Problem on financial system

#### Do dividends grow at the same rate as earnings

Prepare a term paper on Do dividends grow at the same rate as earnings and is the Gordon Model fact or fiction

#### Evaluate the depreciation on the building

Evaluate the depreciation and what was Happe's Interest Expense on the bond during fiscal year 2012? What was Andersen Telecom's depreciation expense for tax purposes in fiscal year 2012?

#### Capital budgeting case

Your company is thinking about acquiring another corporation. You have two choices—the cost of each choice is \$250,000. You cannot spend more than that, so acquiring both corporations is not an option. The following are your critical data:

#### Draw a time line to show the cash flows of the project

Draw a time line to show the cash flows of the project and compute the project's payback period, net present value, profitability index, and internal rate of return.