Calculate the modified duration in years for each security

Assignment Help Finance Basics

Reference no: EM132177209

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 (not the long formula, the short one). Use 10 basis points (0.10%) as the plus and minus change in yield.

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

Questions Cloud

Which could be made with intention of increasing global sale : which could be made with the intention of increasing global sales - They also want the general public to be aware of this policy and, like any business

Reflect on the changes to the idea of what is considered : Is deviance just a label imposed by others, or is it an objective reality based on societal norms? How should it be studied?

What is a reversal of fortune : a) What is a 'reversal of fortune'? Explain briefly. b) At what specific point in time does it happen?

Discuss the impact globalization : Discuss future trends and challenges facing the security profession including legislative trends in security and the new counterterrorism role.

Calculate the modified duration in years for each security : 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)

What effect will foreign government budget deficit financed : In the portfolio balance model, what effect, other things equal, will a foreign government's budget deficit financed by issuing bonds have on the home country's

Initial population density of former colonies : Why is the rate of mortality of European settlers a better IV than the initial population density of former colonies?

What is the nominal dollar amount of your last withdrawal : You are planning to save for retirement over the next 30 years. What is the nominal dollar amount of your last withdrawal

The advantages the associated with the us dhs reorganization : Chronologize the establishment and reorganization of the U.S. Department of Homeland Security (U.S. DHS).

User Account

All Pages