Consider two bonds A and B with payments Ct, where t = 1,2, ...,10. Both bonds...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider two bonds A and B with payments Ct, where t = 1,2, ...,10. Both bonds have $1,000 face value. Bond A has just been issued, it bears coupon rate of 7%, and it will mature in 10 years. Bond B was issued 5 years ago, when interest rates were higher. This bond has $1,000 face value and bears a 13% coupon rate. When issued, this bond had a 15-year maturity, so its remaining maturity is 10 years. The yield to maturity is 7% (see Cell B2). Using the Excel spreadsheet below, estimate the duration of each of the two bonds A (Cell B20) and B (Cell E20), using the mathematical formula of the Macaulay duration measure. Which bond has the longest duration? Show your calculations and interpret your results. 4 5 6 7 8 9 10 11 A Yield to Maturity (YTM) Year 1 8600 VUAWN 6 9 10 B 20 Duration 21 C₁A 7% R RRRRRR PR6 70 70 1,070 C D BOND DURATION CALCULATION Time-Weighted Average Maturity of the Payments Received From the Bond A 1,000.00 12 13 14 15 16 17 Bond price 18 19 Estimation of the Macaulay duration using the mathematical formula ? ? 0.0654 0.1223 0.1714 0.2136 0.2495 0.2799 0.3051 E 0.3259 0.3427 5.4393 CLR 130 130 130 130 130 130 130 130 130 1,130 Time-Weighted Average Maturity of the Payments Received From the Bond B 1,421.41 0.0855 0.1598 0.2240 0.2791 0.3260 0.3657 0.3987 0.4258 0.4477 4.0413 G H 1 Question e Consider two bonds A and B with payments Ct, where t = 1,2, ...,10. Both bonds have $1,000 face value. Bond A has just been issued, it bears coupon rate of 7%, and it will mature in 10 years. Bond B was issued 5 years ago, when interest rates were higher. This bond has $1,000 face value and bears a 13% coupon rate. When issued, this bond had a 15-year maturity, so its remaining maturity is 10 years. The yield to maturity is 7% (see Cell B2). Using the Excel spreadsheet below, estimate the duration of each of the two bonds A (Cell B20) and B (Cell E20), using the mathematical formula of the Macaulay duration measure. Which bond has the longest duration? Show your calculations and interpret your results. 4 5 6 7 8 9 10 11 A Yield to Maturity (YTM) Year 1 8600 VUAWN 6 9 10 B 20 Duration 21 C₁A 7% R RRRRRR PR6 70 70 1,070 C D BOND DURATION CALCULATION Time-Weighted Average Maturity of the Payments Received From the Bond A 1,000.00 12 13 14 15 16 17 Bond price 18 19 Estimation of the Macaulay duration using the mathematical formula ? ? 0.0654 0.1223 0.1714 0.2136 0.2495 0.2799 0.3051 E 0.3259 0.3427 5.4393 CLR 130 130 130 130 130 130 130 130 130 1,130 Time-Weighted Average Maturity of the Payments Received From the Bond B 1,421.41 0.0855 0.1598 0.2240 0.2791 0.3260 0.3657 0.3987 0.4258 0.4477 4.0413 G H 1 Question e
Expert Answer:
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date:
Students also viewed these finance questions
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Choose the alternative the best answers the question. 1. Calculate the yield to worst on the following bond, which makes semi-annual coupon payment: Coupon rate = 6% Maturity = 30 years Par Value =...
-
Compute the given derivatives with the help of formulas (1)(4). (a) (b) d dx (1) - x=e
-
A five-year bond with a yield of 7% (continuously compounded) pays an 8% coupon at the end of each year. a) What is the bond's price? b) What is the bond's duration? c) Use the duration to calculate...
-
Which of the following is not a good general purpose for a blog? a. Sharing news from the racing circuit, describing how the racers we sponsor are faring and how they use our products. b. Commenting...
-
The defendant is a highly respected corporation with no record of civil or criminal acts by its employees. Hanna, the CEO, suggested to the board of directors that the company should have an ethics...
-
The Daisy Company received a bank statement for February 2007, as follows: From: Central Bank, Denver, Co. 80222 To: Daisy Company, 1313 Williams St., Denver, Co. 80218 The receipt of $460 on...
-
a. Real Estate exhibits a number of features which make them distinct from other types of investments. Identify and explain any five of the features given by international real estate investors...
-
Management of Ebony, a leading manufacturer of bath soap, is trying to control its inventory costs. The weekly cost of holding one unit of soap in inventory is $30 (one unit is 1000 cases of...
-
The donar concentration of n-type &/C (Eg = 21303 ev i N = 2 x 1016 1 cm. Find the temp. (in terms of Boltzma constant KB) at which the sc starts behaving like an intrinsic Sc. The density of states...
-
Suppose that farmers have a mandatory demand expansion program where all farmers pay a certain amount to fund a promotion program. You have estimated the following market supply and demand functions...
-
Imagine that you lend $5,000 to a friend at 7%, and say, "Pay me back when you get a job." Five years later, your friend gets a job and pays you back. Your friend assumed that you meant simple...
-
In late 2007, some observers were concerned that the U.S economy was experiencing a dangerous combination or reduced output growth (resulting in increased unemployment) and higher inflation, as had...
-
Q TR TC MR MC 0 0 3 - - 1 6 5 6 2 2 12 8 3 18 12 4 24 17 5 30 23 6 36 30 7 42 38 8 48 47 TO CALCULATE MAXIMAZING LEVEL OF OUTPUT AND THEN SKETCH A GRAPH TO REPRESENT MR AND MC DATA
-
4 5 Miso Corp. borrowed $575,000 from the bank on August 1, 2024. The note had an 4 percent annual rate of interest and matured on April 30, 2025. Interest and principal were paid in cash on the...
-
The Lessor Corporation leases equipment to Lessee Corporation beginning January 1, 2018. The following Info is available. 1. The lease term is 6 years; the lease requires equal payments of $91,843 to...
-
Interview managers at three companies in your area about their use of ERP. How have their experiences been similar? What accounts for the similarities and differences?
-
The Mountain Top Hotel is a luxury hotel in a popular ski resort area. The hotel always is essentially full during winter months, so reservations and payments must be made months in advance for...
-
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be...
-
AmeriBank will soon begin offering Web banking to its customers. To guide its planning for the services to provide over the Internet, a survey will be conducted with four different age groups in...
-
Diehl Cleaners has the following statement of financial position items. Instructions Classify each item as an asset, liability, or equity. Analyze the effect of transactions. Accounts payable Cash...
-
Erin Danielle, the bookkeeper for Liverpool Ltd., has been trying to determine the correct statement of financial position for the company. The companys statement of financial position is shown...
-
Which of the following is true? a. Financial frauds have not occurred in U.S. companies because GAAP has detailed accounting and disclosure requirements. b. Transaction analysis is basically the same...
Study smarter with the SolutionInn App