Compute the terminal values of the individual bonds

Assignment Help Portfolio Management
Reference no: EM132277263

Exercise 1

BASED ON THE DATA BELOW COMPUTE AND PLOT THE DURATION AS A FUNCTION OF THE COUPON RATE WITH THE COUPON RATE GOING FROM 0% T0 11%, IN ONE-PERCENT INCREMENTS

Current date 4/6/2019
Maturity, in years 21
Maturity date 4/6/2040
YTM 12%
Coupon 3%
Face value      1,000

Exercise 2

BASED ON THE DATA BELOW COMPUTE AND PLOT THE DURATION AS A FUNCTION OF THE TIME TO MATURITY WITH TIME-TO-MATURITY GOING FROM 5 YEARS TO 70 YEARS, IN 5-YEAR INCREMENTS

Current date 4/6/2019
Maturity, in years 21
Maturity date 4/6/2040
YTM 10%
Coupon 5%
Face value      1,000

Exercise 3

DURATION MATCHING

You have a liability (obligation) with one payment of $6,000 due in 10 years.

Show that you can immunize yourself only by Bond 1 and not by Bond 2.

Show that if interest rate changes by 1% (immediately after you buy the bonds) Bond1 terminal value remains almost unchanged, near $6,000. (whereas the terminal values for Bond 2 depart much more significantly from $6,000)

The ongoing rate (YTM) is 6%, so assume the rate could jump to 7% and can go down to 5%.

Reminder: the terminal value includes the value of the re-invested coupons and the price of the bonds at time 10.

Hint: first verify that when the interest rate DOESN'T change (i.e. stays at 6%) you do have terminal values of exactly $6,000 for both Bond 1 and Bond 2. This will assure that you have the correct percentage of face value bought.

Only then can you check whether the terminal value stays constant for Bond 1 while it does not for the Bonds 2.

Yield to maturity 6.0%
Current Date 4/6/2019
Present Value of Future Obligation: $3,350.37




Bond 1 Bond 2
Coupon rate 7.00% 6.000%
Maturity 4/6/2034 4/6/2049
Face value 1,000 1,000
Number of years to Maturity  15.00 30

Exercise 4

DURATION MATCHING

You have a liability (obligation) with one payment of $6,000 due in 10 years.

Form a portfolio of bonds 2 and 3 and immunize yourself from the interest rate risks.

Show that if interest rate changes by 1% your portfolio terminal value still remains almost unchanged.
(whereas the terminal values for individual Bonds depart much more significantly from $6,000)

The ongoing rate (YTM) is 6%, so assume the rate could jump to 7% and can go down to 5%.

Reminder: the terminal value includes the value of the re-invested coupons and the price of the bonds at time 10.

Before starting to compute portfolio weights, first verify that when the interest rate DOESN'T change (i.e. stays at 6%) you do
have terminal values of exactly $6,000 for all Bonds. This will assure that you have the correct percentage of face value bought.

Only then can you start the duration matching (by computing the weights needed), and only then can you check whether the terminal value stays constant for your portfolio (weighted average of Bond2 and Bond3) while it does not for the individual Bonds.

Compute the terminal values of the individual bonds and the Portfolio (made up of Bonds 2 and 3) as a function of the interest rate (let r go from 0 to 10%) by using data tables.

Plot your results graphically to show that individual bonds are no match for the portfolio if rates swing wildly.

Yield to maturity 6.0%

Current Date 4/6/2019

Present Value of Future Obligation: $3,350.37






Bond 1 Bond 2 Bond 3
Coupon rate 7.00% 6.000% 6.700%
Maturity 4/6/2032 4/6/2049 4/6/2029
Face value 1,000 1,000 1000
Number of years to Maturity  15.00 30 10

Exercise 5

Consider a bond that pays $100 annual interest (i.e. the CR =0.10) and has a remaining life of 15 years (matures on 4/6/2034). The bond currently (on 4/6/2019) sells for $985 and has a yield to maturity of 10.20%.

What is this bond's duration?

What is the actual Price change of the bond if interest rate (YTM) changes to 9.5%.

Compute the Price change of the bond using duration if interest rate (YTM) changes to 9.5%.

Compute the Convexity for the bond when interest rate changes from 10.2% to 9.5%.

Exercise 6

You have a liability (obligation) with one payment of $7,000 due in 9 years. Use Bonds 1, 3 and 4 below to immunize the portfolio "completely", i.e., matching the duration AND the convexity of a bond portfolio with the duration of the liability. Show that if the interest rate changes by 4% (large swing immediately after you buy the bonds) your portfolio terminal value still remains almost unchanged.
(whereas the terminal values for all individual Bonds depart much more significantly from it)

Show clearly what weights you obtain for Bond 1, 3 and 4. The ongoing rate (YTM) is 3%, so the rate could jump to 7%.

Reminder: the portfolio terminal value includes the value of the re-invested coupons (see the notes) and the price of the bonds at time 9.

Before starting to compute portfolio weights, first verify that when the interest rate DOESN'T change (i.e. stays at 3%) you do have terminal values of exactly $7,000 for all Bonds. This will assure that you have the correct percentage of face value bought.

Only then can you start the duration/convexity matching (by computing the weights needed), and only then can you check whether the terminal value stays constant for your portfolio (weighted average of Bond 1, Bond 3 and Bond 4) while it does not for the individual Bonds.

Compute the terminal values of both Bond 2 and the Portfolio (made up of Bonds 1, 3 and 4) as a function of the interest rate (let r go from 0 to 10%)

Plot your results graphically to show that even though Bond 2 performs well in the region nearby 3%, it is no match for the portfolio if rates swing wildly.

Yield to maturity 3%
Current Date 4/6/2019

Present Value of Future Obligation:




Bond 1 Bond 2 Bond 3 Bond 4
Coupon rate 9.00% 7.50% 7.00% 5.00%
Maturity 4/6/2049 4/6/2031 4/6/2028 4/6/2032
Face value 1,000 1,000 1,000 1,000

Verified Expert

In this assignment, we have discussed the different level of calculation in excels. As per the case study, we have done all the calculation to find the desired result

Reference no: EM132277263

Questions Cloud

Explain roles and responsibilities of an early childhood : Question - Based on new learning, explain roles and responsibilities of an early childhood or after-school program leader
Implement the new kanban system : Provide a solution on ways to cut down cost with minimum spending, you will also include speaker notes and useful resources to back your statement up
Use desmos or another graphing utility to graph : By looking at the behavior of f'(x) where is f(x) increasing and where is it decreasing? Give answers using interval notation for x
How organizations are becoming effective using expert system : How organizations are becoming more effective using expert systems: an analytical study - dentify How organizations are becoming more effective using systems
Compute the terminal values of the individual bonds : Compute the terminal values of the individual bonds and the Portfolio (made up of Bonds 2 and 3) as a function of the interest rate (let r go from 0 to 10%)
Develop an application program for a cashless store : IFN501 - You must develop your program based on the given system requirement specifications. (A system requirement specificationestablishes the basis
Build a garch model for the transformed series : Build a GARCH model for the transformed series and compute 1-step- to 5-step-ahead volatility forecasts at the forecast origin December 2008
Potential market segments for the mother care company : ACC 399-P Project in Accounting - Abu Dhabi University - Case - The Potential Market Segments for the Mother Care Company -
Analysis of entrepreneur traits : MNG91002 - Entrepreneurship - Case Analysis – Fairphone - what we might consider 'social entrepreneurship', whereby an entrepreneur establishes

Reviews

len2277263

4/8/2019 4:20:51 AM

You can find the assignment from my Portfolio Management class, in the excel file bellow. This file include six exercise about: Duration portfolio, bond, duration matching, Duration + convexity

Write a Review

Portfolio Management Questions & Answers

  Portfolio analysis

The stock with the lowest beta (0.76) is Apple Inc. stock. The stock with the highest beta (3.29) is Facebook Inc. stock. Beta for Apple Inc. stock is less that 1, it tells us that stock price is less volatile and risky than mark..

  Provide investment portfolio advice

Provide investment portfolio advice and management to a client.

  Evaluate total number of shares

EBV proposes to structure the investment as 5m shares of CP with FV of $5m, one-to one conversion to common, and no dividends. Total Valuation Estimated from Newco.

  Role of the imf and world bank

Economic and territorial logic of empire are not always aligned. Explain his argument in light of the role of the IMF and World Bank as forms of neo imperialism.

  Prepare a portfolio of stocks

Prepare a portfolio of stocks

  Which critically examines the benefits and risks to company

Which critically examines the benefits and risks to a company, of incorporating corporate debt into a portfolio of equity and debt.

  Compute the variance-covariance matrix

Compute the sample mean, variance, and standard deviation of these shares and compute the variance-covariance matrix V and Plot the daily share prices and daily returns for each individual asset.

  Net nominal rate of interest and net real rate of interest

What bank portfolio can guarantee the rate of return 1 to all type 1 people and the rate of return 1.2 to all type 2 people? How many goods are placed in storage? In capital?

  Right issue to improve financial status

If you are the CEO of a British company that now faces the loss of a lucrative contract in Malaysia because of the dispute. What action should you take and How do you think British government should respond to the Malaysian action?

  Calculate the cost of reinvested profits

Calculate the cost of reinvested profits and the cost of new common shares using the constant-growth DVM - Cost of reinvested profits versus new common shares-DVM

  Calculate the after-tax cost of debt

Cost of debt For each of the following bonds, calculate the after-tax cost of debt. Assume the coupons are paid semi-annually, that the tax rate is 40 percent, and that we are dealing with $1,000 of par value.

  Calculate the overall cost of capital for cartwell products

Calculate the overall cost of capital for Cartwell Products. Which projects should the firm select? Does your answer differ from your answer topart d? If so, explain why.

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