EBK INVESTMENTS
11th Edition
ISBN: 9781259357480
Author: Bodie
Publisher: MCGRAW HILL BOOK COMPANY
expand_more
expand_more
format_list_bulleted
Question
Chapter 16, Problem 19PS
Summary Introduction
To calculate: The duration of a bond with a settlement date of May 27,2020 and maturity date November 15, 2031.
Introduction:
Modified duration: It states how changes in interest rate affects the bond’s durations. The syntax used in Excel is
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Find the YTM of a Treasury bond which you are considering purchasing. The settlement
date is Oct. 1, 2023. The bond matures on Dec. 15, 2026 and has a 4.25% coupon rate
(the maturity date tells you when the coupon payments are made). The quoted price for
the bond is 102:12.
An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8.9%. Bond C pays a 11% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
Assuming that the yield to maturity of each bond remains at 8.9% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent.
Years to Maturity
Price of Bond C
Price of Bond Z
4
$ fill in the blank 2
$ fill in the blank 3
3
$ fill in the blank 4
$ fill in the blank 5
2
$ fill in the blank 6
$ fill in the blank 7
1
$ fill in the blank 8
$ fill in the blank 9
0
$ fill in the blank 10
$ fill in the blank 11
Consider a bond with semiannual interest payments that has a Settlement Date of 8/15/2020, a Maturity Date of 2/15/2031, a Coupon Rate of 5.00%, a Market Price of $975, a Face Value of $1,000, and a Required Return of 5.35%. What is the Macaulay Duration using the Duration function on these bonds expressed as a decimal calculated to two decimal places if you purchase them at the current market price? For example, if your answer is 12.345 then enter as 12.35 in the answer
Chapter 16 Solutions
EBK INVESTMENTS
Ch. 16 - Prob. 1PSCh. 16 - Prob. 2PSCh. 16 - Prob. 3PSCh. 16 - Prob. 4PSCh. 16 - Prob. 5PSCh. 16 - Prob. 6PSCh. 16 - Prob. 7PSCh. 16 - Prob. 8PSCh. 16 - Prob. 9PSCh. 16 - Prob. 10PS
Ch. 16 - Prob. 11PSCh. 16 - Prob. 12PSCh. 16 - Prob. 13PSCh. 16 - Prob. 14PSCh. 16 - Prob. 15PSCh. 16 - Prob. 16PSCh. 16 - Prob. 17PSCh. 16 - Prob. 18PSCh. 16 - Prob. 19PSCh. 16 - Prob. 20PSCh. 16 - Prob. 21PSCh. 16 - Prob. 22PSCh. 16 - Prob. 23PSCh. 16 - Prob. 24PSCh. 16 - Prob. 25PSCh. 16 - Prob. 1CPCh. 16 - Prob. 2CPCh. 16 - Prob. 3CPCh. 16 - Prob. 4CPCh. 16 - Prob. 5CPCh. 16 - Prob. 6CPCh. 16 - Prob. 7CPCh. 16 - Prob. 8CPCh. 16 - Prob. 9CPCh. 16 - Prob. 10CPCh. 16 - Prob. 11CPCh. 16 - Prob. 12CPCh. 16 - Prob. 13CP
Knowledge Booster
Similar questions
- Subject:- financearrow_forwardPls help with below homework.arrow_forwardYou are interested in purchasing a bond maturing on November 1st, 2029. The bond pays semiannual coupons at a 6% annual coupon rate. It has a discount rate of 4% and a $1,000 par value. Today is November 1st, 2023. What is the price (in terms of dollars) of the bond?arrow_forward
- Calculate the duration (and price ) of a bond with the following characteristics: A semi - annual payment bond with a $1,000 face value, a 4.5% coupon rate, a 7.8% YTM, and 8 years to maturity. Show your table of calculations or show Excel inputs if using the Excel commands.arrow_forwardAssume coupons are paid annually. Here are the prices of three bonds with 10 year maturities. Assume face value is $100. Bond Coupon a. What is the yield to maturity of each bond? b. What is the duration of each bond? Complete this question by entering your answers in the tabs below. Required A Required B What is the duration of each bond? Note: Do not round intermediate calculations. Round your answers to 2 decimal places.arrow_forwardYou purchase a bond with an invoice price of $1,014. The bond has a coupon rate of 9 percent, and there are 2 months to the next semiannual coupon date. What is the clean price of the bond? Enter the answer with 2 decimals (e.g. 954.23).arrow_forward
- Find the duration of a bond with settlement date June 2, 2023, and maturity date November 27, 2032. The coupon rate of the bond is 6%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 7%.arrow_forwardConsider a 25-year bond with a face value of $1,000 that has a coupon rate of 5.8%, with semiannual payments. a. What is the coupon payment for this bond? b. Draw the cash flows for the bond on a timeline. a. What is the coupon payment for this bond? The coupon payment for this bond is $ *** (Round to the nearest cent.)arrow_forwardSuppose a bond with no expiration date has a face value of $10,000 and annually pays a fixed amount of interest of $700. a. In the table provided below, calculate and enter either the interest rate that the bond would yield to a bond buyer at each of the bond prices listed below or the bond price at each of the interest yields shown. Instructions: Enter your answers in the gray-shaded cells. For bond prices, round your answers to the nearest hundred dollars. For interest yields, round your answers to 2 decimal places.arrow_forward
- Can someone help me pls. Thank you!arrow_forwardRequired: Find the duration of a bond with settlement date May 29, 2018, and maturity date November 19, 2027. The coupon rate of the bond is 6%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 7%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified durationarrow_forwardPlease answer fast i give upvote.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author: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 ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
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