Question

In: Finance

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

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.3

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

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
What is the Macaulay duration in years of a 3% coupon bond with 2 years to...
What is the Macaulay duration in years of a 3% coupon bond with 2 years to maturity and a face value of $100? Assume the bond is trading at a yield of 8%, and that the next coupon payment is to be made exactly 6 months from today. Round your answer to 3 decimal places. For example if your answer is 5.5175, then please write down 5.518.
What is the Macaulay duration of a bond with a coupon of 5.4 percent, nine years...
What is the Macaulay duration of a bond with a coupon of 5.4 percent, nine years to maturity, and a current price of $1,055.40? (Do not round intermediate calculations. Round your answers to 3 decimal places.) (7.410 is not correct of Macaulay )
What is the Macaulay duration of a bond with a coupon of 7 percent, five years...
What is the Macaulay duration of a bond with a coupon of 7 percent, five years to maturity, and a current price of $1,025.30? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.)
What is the Macaulay duration of a bond with a coupon of 5.4 percent, nine years...
What is the Macaulay duration of a bond with a coupon of 5.4 percent, nine years to maturity, and a current price of $1,055.40? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.)                   
What is the Macaulay duration of a bond with a coupon of 6.6 percent, seven years...
What is the Macaulay duration of a bond with a coupon of 6.6 percent, seven years to maturity, and a current price of $1,069.40? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.)
What is the Macaulay duration of a bond with a coupon of 6.2 percent, five years...
What is the Macaulay duration of a bond with a coupon of 6.2 percent, five years to maturity, and a current price of $1,064.70? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.)
​​​​​​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?...
A bond with Macaulay duration of 2.1 years has a yield of 4.88% and makes coupon...
A bond with Macaulay duration of 2.1 years has a yield of 4.88% and makes coupon payments semiannually. If the yield changes to 5.51%, what percentage price change would the duration measure predict? (Round to the nearest 0.001%, drop the % symbol. E.g., if your answer is -5.342%, record it as -5.342.)
What is the Macaulay Duration of a 4.4% annual coupon bond with 3 years to maturity,...
What is the Macaulay Duration of a 4.4% annual coupon bond with 3 years to maturity, $1,000 face value, and yield to maturity of 4.4%? Round to three decimal places. a. 2.865 b. 2.821 c. 2.886 d. 2.875 e. 2.908
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT