ATreasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate...

Question

Question

business finance

Answer 1

Answer #1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

B C D Settlement date Maturity date Coupon rate Yield to maturity 10/18/2016 3/30/2035 5.75% 5.08% Macaulay Duration Modified

Cell reference -

A в C -Nm Settlement date Maturity date Coupon rate Yield to maturity =DATE(2016,10,18) =DATE(2035,3,30) 0.0575 0.0508 Macaul

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.

Answer 2

Similar Homework Help Questions

porte A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The...

porte A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 5.75 percent and the bond has a yield to maturity of 5.08 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not found intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon...

A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 6.30 percent and the bond has a yield to maturity of 5.85 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon...

A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 5.95 percent and the bond has a yield to maturity of 5.36 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.)

Problem 10-35 Duration (LO4, CFA6) A Treasury bond that settles on October 18, 2016, matures on...

Problem 10-35 Duration (LO4, CFA6) A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 6.15 percent and the bond has a yield to maturity of 5.64 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Answer is complete but not entirely correct. 11.3694 Macaulay duration Modified duration 10.7624
Problem 10-35 Duration (LO4, CFA6) A Treasury bond that settles on October 18, 2016, ma yield...

Problem 10-35 Duration (LO4, CFA6) A Treasury bond that settles on October 18, 2016, ma yield to maturity of 5.64 percent. What are the Macau the problem. Do not round intermediate calculation & Answer is complete but not entirely correct. 11.3694 Macaulay duration Modified duration 10.7624 X
A bond with a coupon rate of 9 percent sells at a yield to maturity of...

A bond with a coupon rate of 9 percent sells at a yield to maturity of 10 percent. If the bond matures in 11 years, what is the Macaulay duration of the bond? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.)

Find the duration of a bond with settlement date May 30, 2016, and maturity date November...

Find the duration of a bond with settlement date May 30, 2016, and maturity date November 21, 2025. The coupon rate of the bond is 5%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 6%. ( Round your answers to 4 decimal places.) Macaulay duration Modified duration
Problem 10-23 Calculating Duration (LO4, CFA6) What is the Macaulay duration of a bond with a...

Problem 10-23 Calculating Duration (LO4, CFA6) What is the Macaulay duration of a bond with a coupon of 5.6 percent, ten years to maturity, and a current price of $1,057.70? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.)
A 30-year maturity bond making annual coupon payments with a coupon rate of 7.5% has duration...

A 30-year maturity bond making annual coupon payments with a coupon rate of 7.5% has duration of 12.27 years and convexity of 216.28. The bond currently sells at a yield to maturity of 8%. e-1. Find the price of the bond if its yield to maturity increases to 9%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) e-2. What price would be predicted by the duration rule? (Do not round intermediate calculations. Round your answers to...

Calculate the Macaulay duration of a 10%, $1,000 par bond that matures in three years if...

Calculate the Macaulay duration of a 10%, $1,000 par bond that matures in three years if the bond's YTM is 12% and interest is paid semiannually. Calculate this bond's modified duration (years). Do not round intermediate calculations. Round your answer to two decimal places. Assuming the bond's YTM goes from 12% to 10.5%, calculate an estimate of the price change. Do not round intermediate calculations. Round your answer to three decimal places (in %). Use a minus sign to enter...