Graph the bond yield to maturity

Assignment Help Database Management System
Reference no: EM13124708

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: EM13124708

Questions Cloud

Explain how would auditor interpret negative information : the company's stock price is in a downward trend. Explain how would an auditor interpret this negative information with regard to a potential audit client? Explain how would your answer be different if this was a continuing client?
Internet antivirus software : Devise a list of deliverables and a timeline- take into account different time zones, formats, expectations, etc. How will you deal with different cultural beliefs related to the concept of time, teamwork, authority, and perception of deadlines
Which of the two reactants will be left over : If 20.0 mL of 0.12 M cobalt(II) nitrate is reacted with 15.13 mL of 0.097 M sodium phosphate, which of the two reactants will be left over and which will be completely consumed.
How would that revenue be measured : Change of mind gives gallery a $1m surprise' and determine whether the gallery should treat the donation as revenue. Further, if the donation is treated as revenue, how would that revenue be measured?
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.
Find the mean and standard deviation of the daily sales : The probabilities .9 and .1 respectively. Give the probability distribution for daily sales. Find the mean and standard deviation of the daily sales.
Effect of the intra-entity sale : Senior sold all of these goods in 2011. How should Perez report the effect of the intra-entity sale on its 2011 income statement?
How to specific country or region of the world : Thus far in class we've talked about many interesting topics in international accounting including international accounting standards, the history of accounting, IFRS vs. US GAAP, the FASB Codification, convergence, harmonization, foreign currency..
Illustrate what is the amount of owner equity : Illustrate what is the amount of owner's equity as of July 1 of the current year?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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