Question

In: Finance

Find the Modified duration of Bond ABC in years by using an excel table. (4 digits...

Find the Modified duration of Bond ABC in years by using an excel table. (4 digits after the decimal)

  

Bond ABC

Coupon

8%

Yield to maturity

9%

Maturity (years)

5

Par

$100.00

Price

$96.0436

Solutions

Expert Solution

Period Cash Flow Discounting factor PV Cash Flow Duration Calc
0 ($96.04) =(1+YTM/number of coupon payments in the year)^period =cashflow/discounting factor =PV cashflow*period
1               8.00                                                             1.09                      7.34                    7.34
2               8.00                                                             1.19                      6.73                  13.47
3               8.00                                                             1.30                      6.18                  18.53
4               8.00                                                             1.41                      5.67                  22.67
5          108.00                                                             1.54                    70.19                350.96
      Total                412.97
           
Macaulay duration =(∑ Duration calc)/(bond price*number of coupon per year)
=412.97/(96.0436*1)
=4.2998
Modified duration = Macaulay duration/(1+YTM)
=4.3/(1+0.09)
=3.9448

Related Solutions

Find the Macaulay duration of Bond ABC in years by using an excel table. (4 digits...
Find the Macaulay duration of Bond ABC in years by using an excel table. (4 digits after the decimal)    Bond ABC Coupon 8% Yield to maturity 9% Maturity (years) 5 Par $100.00 Price $96.0436
The McCauley’s duration of a 5-year zero-coupon bond yielding 4% is ________ years and the modified...
The McCauley’s duration of a 5-year zero-coupon bond yielding 4% is ________ years and the modified duration of a 5-year zero-coupon bond yielding 4% is ________ years.
​​​​​​using excel functions Using Table 13.1, (a) find the value of an investment after 4 years...
​​​​​​using excel functions Using Table 13.1, (a) find the value of an investment after 4 years on an ordinary annuity of $5,000 made semiannually at 4%; and (b) recalculate, assuming an annuity due. Wally Beaver won a lottery and will receive a check for $2,500 at the beginning of each 6 months for the next 6 years. If Wally deposits each check into an account that pays 6%, how much will he have at the end of the 6 years?...
What is the modified duration of an 5% bond with 15 years to maturity that is...
What is the modified duration of an 5% bond with 15 years to maturity that is trading at a yield of 8%? Assume that coupon is paid semi-annually. (Keep your answer to 2 decimal places, xx.12.)
4. a) Compute the modified duration of a 10% coupon, 4-year corporate bond with a yield...
4. a) Compute the modified duration of a 10% coupon, 4-year corporate bond with a yield to maturity of 8%. b) Using the modified duration, If the market yield drops by 25 basis points, there will be a __________% (increase/decrease) in the bond's price.
A manager is holding a $1.8 million bond portfolio with a modified duration of nine years....
A manager is holding a $1.8 million bond portfolio with a modified duration of nine years. She would like to hedge the risk of the portfolio by short-selling Treasury bonds. The modified duration of T-bonds is 10 years. How many dollars' worth of T-bonds should she sell to minimize the risk of her position? (Enter your answer in dollars not in millions.)
a) Compute the modified duration of a 9% coupon, 4-year corporate bond with a yield to...
a) Compute the modified duration of a 9% coupon, 4-year corporate bond with a yield to maturity of 10%. b) Using the modified duration, If the market yield drops by 25 basis points, there will be a __________% (increase/decrease) in the bond's price.
1)Find the Macaulay duration and the modified duration of a15​-year,11.5​%corporate bond priced to yield9.5​%.According to the...
1)Find the Macaulay duration and the modified duration of a15​-year,11.5​%corporate bond priced to yield9.5​%.According to the modified duration of this​ bond, how much of a price change would this bond incur if market yields rose to10.5​%?Using annual​ compounding, calculate the price of this bond in one year if rates do rise to10.5​%.How does this price change compare to that predicted by the modified​ duration? Explain the difference. 2) An investor is considering the purchase of​ a(n)6.75%​,​18-year corporate bond​ that's being...
An investment fund owns $15,000,000 principal of a corporate bond whose modified duration ​is -8.3 (years)....
An investment fund owns $15,000,000 principal of a corporate bond whose modified duration ​is -8.3 (years). The bond's current percentage-of-par price is 108.58% (1.0858). The fund ​may sell the bond in several weeks as part of a portfolio restructuring, and is worried that ​bond yields will rise and prices decline. So it decides to hedge its risk using another bond ​whose modified ​duration is -9.0 (years), the most liquid bond available. ​These are the relevant prices today: ​​Target bond: ModDur...
Compute the Macaulay duration and modified duration of a 6%, 25-year bond selling at a yield...
Compute the Macaulay duration and modified duration of a 6%, 25-year bond selling at a yield of 9%. Coupon frequency and compounding frequency are assumed to be semiannual.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT