Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show work Use an Excel function to calculate the modified duration of Bond A and Bond B from the previous question. Note: When using
Please show work
Use an Excel function to calculate the modified duration of Bond A and Bond B from the previous question. Note: When using the =mDuration function in Excel, enter the coupon rate in percent form, not dollars. Enter the coupon and yield on an annual basis, then enter the 'frequency' as 2 where indicated. Bond A: 8% coupon, 8% YTM, 2 years maturity, par 100, price $100 Bond B: 9% coupon, 8% YTM, 5 years maturity, par 100, price $104.055 The modified duration of Bond A is: Choose... The modified duration of Bond B is: Choose... - The correct answer is: The modified duration of Bond A is: + 1.8149, The modified duration of Bond B is: 3.9944 Using only the duration figures below, what is the estimated new price of Bonds A and B, given a 100 basis point (1%) increase in market interest rates? (Do not solve for PV on your calculator or spreadsheet.) Bond A: duration = 3 years, price = 100 Bond B: duration = 5 years, price = 104.055 [Note that the duration figures above ARE NOT the correct answers from the previous question.] Expected % change in value = -mDuration x expected change in yield-to-maturity After you determine the expected percent price change, apply this percent change to the original prices listed above to calculate the expected new prices. The estimated new price of Bond A is: Choose... - The estimated new price of Bond B is: ChooseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started