Create a line graph of the actual and predicted percentage

Assignment Help Finance Basics

Reference no: EM13389015

1.Allow the user to input the current price of the bond as a percentage of par with 3 decimal places (usewhole numbers so that 100.000 represents a bond trading at par or face value), the annual coupon rate, the settlement date (day traded), the maturity date, and the percentage increment to use in the table and graph for changes in the discount rate. All calculations in the remaining steps should reference these inputs.

2. Using the inputs, calculate the yield to maturity (YTM), maturity, Macaulay’s duration, modified duration, and accrued interest (as of the settlement date) of the bond. You will find the yield() function useful for calculating YTM, the yearfrac() function useful for calculating maturity, the duration() function useful for calculating Macaulay’s duration, and the couppcd() function useful for calculating
accrued interest. Assume 2 payments per year and a 30/360 basis. Do not use the mduration() function for modified duration, as it is incorrect. Instead, calculate the modified duration as the duration divided by (one plus the YTM that is calculated) or MD = D / (1+ytm).

3. Create a table in which each row contains a change in interest rates, the value of the bond given the change in interest rates, the actual percentage change in the bond value given the change in interest rates, and the percentage change in the bond price predicte by the duration model for the change in interest rates. You will find the price() function useful for calculating values. The chang predicted by the duration model is the negative of the modified duration multiplied by the change in interest rates or ?PV/PV ≈ -MD × ?i. Your table should include a change of 0% and then +/- 1, 2, 3, and 4 times theinterest rate increment input from step one. For example, if the interest rate increment is 0.50%, the interest rate changes in the table from top row to bottom row would be -2.00%, -1.50%, -1.00%, -0.50%, 0.00%, +0.50%, +1.00%, +1.50%, and +2.00%.

4.Create a line graph of the actual and predicted percentage changes in value, with appropriate formatting of the axes, labels on the x and y axes, title and legend, etc. In particular, keep the font sizes small, so that most of the graph space is the actual graph, not the labeling.

Reference no: EM13389015

Questions Cloud

Which of the following would be an illustration of an : question 1 which of the following would be an example of an innovation and learning performance measure?question 2 the

Briefly outline at least one other strategy the firm could : 1q. determine which strategy is most likely to benefit the firm? explain your rationale.2q. briefly outline at least

Find the profit-maximizing price and output level solve : a small business which produces plastic vacuum-suction covers for round household dishes has a monopoly that is

Explain an orientation experience you have had or are : describe an orientation experience you have had or are familiar with that was effective or ineffective in aligning

Create a line graph of the actual and predicted percentage : 1.allow the user to input the current price of the bond as a percentage of par with 3 decimal places usewhole numbers

From the e-activity and the case study determine how market : 1q. from the e-activity and the case study determine how market commonality and resource similarity impact applersquos

Create a 95 confidence interval for population proportion : you are told that a random sample of 150 people from iowa has been given cholesterol tests and 60 of these people had

Determine why given the advantages of international : 1q. determine why given the advantages of international diversification some firms choose not to expand

Describe the relationship between logistics systems and : as a supply chain manager you have been asked by senior management to write a memo outlining supply chain logistics

User Account

All Pages