Calculate modified duration and convexity measure in years

Reference no: EM132178177

Question - Use the following information as your starting point. There are five notes and one bond. Theoretical on-the-run Treasury yields for a 9/12/18 settlement date are given with the maturity. Assume each security is priced at par.

Note/Bond Maturity Yield (%)

2-Year Note 9/12/2020 2.70%

3-Year Note 9/12/2021 2.80%

5-Year Note 9/12/2023 2.90%

7-Year Note 9/12/2025 3.00%

10-Year Note 9/12/2028 3.10%

30-Year Bond 9/12/2048 3.15%

1) Calculate the modified duration in years for each security using the MDURATION function in excel. (Please show work and what you put in for the function)

2) Calculate the modified duration and convexity measure in years using the approximation in the chapter 4 notes and book.

3) Calculate the portfolio weighted average duration, convexity, and yield for two different portfolios:

Portfolio 1: 22% weight in 3-year, 52.0% weight in 5-year, 26.0% weight in 7-year.

Portfolio 2: 75% weight in 2-year, 15% weight in 10-year, 10% weight in 30-year.

4) Calculate the approximate percent change in price for each portfolio using duration and convexity for two scenarios: a parallel shift in all yields of -0.97 % and +0.62 %. Which portfolio has a more favorable price change and why? Discuss the difference in weighted average yield between the two portfolios. Which portfolio earns a higher return if there were no parallel shift in yields and why? Include your comments in the spreadsheet.

Reference no: EM132178177

Questions Cloud

Why an oligopolist pays more attention : Explain why an oligopolist (with few competitors) pays more attention to what its competitors are doing than a producer in a competitive market.

Operational databases and data warehouses : What is the relationship between operational databases and data warehouses? What types of decisions do data warehouses support?

What is the net present value of the growth opportunities : If the required rate of return on the stock is 10%, what is the net present value of the growth opportunities for MMC

Make similar attacks against similar targets : Suppose two terrorist groups make similar attacks against similar targets: both destroy office buildings containing government and military offices,

Calculate modified duration and convexity measure in years : Assume each security is priced at par. Calculate the modified duration and convexity measure in years using the approximation in the chapter 4 notes and book

How would you expect mcdonald to set prices : McDonald's, Burger King, and Wendy's all produce hamburgers, among other things. However, if you prefer burgers from McDonald's, you might consider other burger

Provide brief context for the crisis or challenge : Provide brief context for the crisis or challenge. Identify the leadership models and approaches that were employed in the handling of the situation.

Develop statement of your target market-competitor targets : Develop statement of your target market, competitor targets and value proposition. Be prepared to discuss and defend your strategy decisions with your classmate

What is the fund required rate of return : Suppose you are the money manager of a $4.88 million investment fund. What is the fund's required rate of return

User Account

All Pages