### Bond Duration CalculationA Treasury bond that settles on October 18, 2019, matures on March 30, 2038. The coupon rate is 5.35 percent, and the bond has a yield to maturity of 4.52 percent. We need to determine the Macaulay duration and modified duration of the bond. (Use the duration functions in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.)**Table: Duration Results**| Duration Type | Value ||----------------------|----------|| Macaulay Duration | 12.2600 || Modified Duration | |**Notes:**- The Macaulay duration has been calculated as 12.2600 years.- The modified duration is not provided in the table and needs to be calculated.### Explanation:- **Macaulay Duration:** This measures the weighted average time until the bond's cash flows are paid.- **Modified Duration:** This reflects the percentage change in the bond's price for a 1% change in yield, derived from the Macaulay duration.For precise calculation, use Excel functions and ensure answers are rounded to four decimal places.

Bonds are the financial instruments issued by firms to holders for a specific time period. This is a…

A Treasury bond that settles on October 18, 2019, matures on March 30, 2038. The coupon rate is 5.35 percent, and the bond has a yield to maturity of 4.52 percent. What are the Macaulay duration and modified duration? (Use the duration functions in Excel to solve the problem. Do not round intermediate calculations, Round your answers to 4 decimal places.) Answer is not complete. Macaulay duration Modified duration 12.2800

A Treasury bond that settles on October 18, 2019, matures on March 30, 2038. The coupon rate is 5.35 percent, and the bond has a yield to maturity of 4.52 percent. What are the Macaulay duration and modified duration? (Use the duration functions in Excel to solve the problem. Do not round intermediate calculations, Round your answers to 4 decimal places.) Answer is not complete. Macaulay duration Modified duration 12.2800

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

a. Assuming that the expectations hypothesis is valid, compute the expected price of the four-year zero coupon bond shown below at the end of (i) the first year; (ii) the second year; (iii) the third year; (iv) the fourth year. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Beginning of Year Price of Bond Expected Price 1 955.00 2 $ 901.47 3 838.62 779.89 4 b. What is the rate of return of the bond in years 1, 2, 3, and 4? Conclude that the expected return equals the forward rate for each year. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Beginning of Year Expected Rate of Return 1 2 % 3 % % 4 LA
The answers I got were wrong
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.) Macaulay Modified Duration 8.046 Years 7.082 Years
Bond J has a coupon of 6.4 percent. Bond K has a coupon of 10.4 percent. Both bonds have 20 years to maturity and have a YTM of 7.8 percent. a. If interest rates suddenly rise by 1.2 percent, what is the percentage price change of these bonds? Note: A negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Bond J Bond K %A in Price % % b. If interest rates suddenly fall by 1.2 percent, what is the percentage price change of these bonds? Note: Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. %A in Price Bond J % Bond K %
You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2022. All of the bonds have a par value of $1,000 and pay semiannual coupons. Rate ?? 6.252 6.163 Maturity Month/Year May 36 May 41 May 51 Bid 103.5462 104.4952 ?? Asked 103.6340 104.6409 ?? Change Ask Yield +.3015 2.329 +.4293 +.5405 ?? 4.031 In the above table, find the Treasury bond that matures in May 2036. What is the coupon rate for this bond? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.
Compute the price of a 6.1 percent coupon bond with 15 years left to maturity and a market interest rate of 9.0 percent. (Assume interest payments are semiannual.) (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Is this a discount or premium bond?
Suppose 1-year Treasury bonds yield 4.40% while 2-year T-bonds yield 5.70%. Assuming the pure expectations theory is correct, and thus the maturity risk premium for T-bonds is zero, what is the yield on a 1-year T-bond expected to be one year from now? Do not round your intermediate calculations. Round your final answer to 2 decimal places. a. 7.02% b. 5.66% c. 5.05% Od. 4.92% e. 7.32%
Both Bond A and Bond B have 6.2 percent coupons and are priced at par value. Bond A has 6 years to maturity, while Bond B has 15 years to maturity. a. If interest rates suddenly rise by 1 percent, what is the percentage change in price of Bond A and Bond B? (A negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) b. If interest rates suddenly fall by 1 percent instead, what would be the percentage change in price of Bond A and Bond B? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.)
What is the Macaulay duration of a bond with a coupon of 8.6 percent, twelve years to maturity, and a current price of $1,043.70? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.) Macaulay Modified Duration Years Years
Bond j has a coupon of 6.2 percent. Bond k has a coupon of 10.2 percent. Both bonds have 20 years to maturity and have a YTM of 6.9 percent. a. If interest rates suddenly rise by 1 percent, what is the percentage price change of these bonds? Note: A negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. \table[[,%delta in Price],[Bond j,,%
A Treasury bond that settles on October 18, 2019, matures on March 30, 2038. The coupon rate is 6.20 percent, and the bond has a yield to maturity of 5.71 percent. What are the Macaulay duration and modified duration? (Use the duration functions in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
Both Bond A and Bond B have 7.8 percent coupons and are priced at par value. Bond A has 9 years to maturity, while Bond B has 16 years to maturity. a. If interest rates suddenly rise by 2.2 percent, what is the percentage change in price of Bond A and Bond B? (A negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) %A in Price Bond A % Bond B % b. If interest rates suddenly fall by 2.2 percent instead, what would be the percentage change in price of Bond A and Bond B? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) %A in Price Bond A Bond B %

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS