Suppose the interest rate decreases to 9%. What will happen to the price and duration of each
Question:
Suppose the interest rate decreases to 9%. What will happen to the price and duration of each bond in Spreadsheet 11.1?
Transcribed Image Text:
SPREADSHEET 11.1 Calculation of the duration of two bonds using Excel spreadsheet excel Please visit us at www.mhhe.com/bkm 1 Interest rate: 2 3 4 1 2 3 4 2|3|4 5 6 A. 8% coupon bond 7 12 ■ 8 9 10 11 B. Zero-coupon 13 A 5 6 A. 8% coupon bond 7 8 9 10 11 B. Zero-coupon bond 12 13 14 15 16 *Weight Present value of each payment (column D) divided by bond price A Interest rate: 14 Sum: Sum: Sum: Sum: 0.1 1 2 3 1 2 3 B Time until Payment (Years) 1 2 3 B 10% 1 2 3 me until Payment (Years) 80 80 1080 0 OOF 0 C 1000 Payment Discounted Payment at 10% C 80 80 1080 Payment D 0 0 1000 72.727 66.116 811.420 950.263 0.000 0.000 751.315 751.315 D Payment Discounted at 10% -C6/(1+$B$1)^B6 =C7/(1+$B$1)^B7 -C8/(1+$B$1)^B8 =SUM(D6:D8) E Weight 0.0765 0.0696 0.8539 1.0000 0.0000 0.0000 1.0000 1.0000 F Column (B) X Column (E) E 0.0765 0.1392 2.5617 2.7774 0.0000 0.0000 3.0000 3.0000 Weight -D6/D$9 =D7/D$9 =D8/D$9 -D9/D$9 F Column (B) times Column (E) -E6*B6 =E7*B7 -E8*B8 -SUM(F6:F8) -C11/(1+$B$1)^B11 -D11/D$14 -E11 B11 |=C12/(1+$B$1)^B12 =D12/D$14 |=E12*B12 -C13/(1+$B$1)^B13 -D13/D$14 -E13*B13 -SUM(D11:D13) -D14/D$14 -SUM(F11:F13)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (2 reviews)
Interest rate 009 The duration of the 8 coupon bond r...View the full answer
Answered By
Hamza Amjad
Currently I am student in master degree program.from last two year I am tutring in Academy and I tought many O/A level student in home tution.
4.80+
3+ Reviews
10+ Question Solved
Related Book For
Essentials Of Investments
ISBN: 9780073368719
7th Edition
Authors: Zvi Bodie, Alex Kane, Alan J. Marcus
Question Posted:
Students also viewed these Business questions
-
which of the following is not required to be proven to hold a defendant liable for negligent conduct? a. intent to do the harm. b. duty. c. breach of duty. d. physical injury or financial loss. e....
-
a. In Concept Check 11.1, you calculated the price and duration of a three-year maturity, 8% coupon bond for an interest rate of 9%. Now suppose the interest rate increases to 9.05%. What is the new...
-
One of most common and significant financial decisions people make is whether to buy or to rent a home. In Melbourne, a family-sized home in a suburb within 20km of the CBD costs roughly $1 million...
-
find the steady state expression for vo in the circuit fig 9.32 if ig = 500cos2000tmA 3) 9.32 Find the steady-state expression for u,, in the circuit of Fig. P9.32 if i = 500 cos 2000 mA. Figure...
-
Give an example of each type of error listed inExhibit. Narresponse error Acquiescance bias Respondent Handem samp ing Extremity bias error Deliberate alsification Total eror Response Interviewer...
-
Three boys take turns shooting a basketball and have probabilities 0.2, 0.3, and 0.5 of scoring a basket. Compute the probabilities for each boy to get the first basket.
-
Mavis Stores had two billing clerks during the year. Snow worked three months and White worked nine months. As the auditor for Mavis Stores, Jones, CPA, uses attributes sampling to test clerical...
-
Bob Jones owns a catering company that stages banquets and parties for both individuals and companies. The business is seasonal, with heavy demand during the summer months and year-end holidays and...
-
What the legal framework for cryptocurrencies in South Africa is. I need legal questions to help me get information to speak about the legal framework of cryptocurrencies in South Africa. I need all...
-
Figure 11.2 illustrates a 9% coupon, 8-year maturity bond with annual payments, selling at a yield to maturity of 10%. Confirm using Spreadsheet 11.2 that the bonds duration is 5.97 years. What would...
-
On May 30, 2006, Janice Kerr is considering the newly issued 10-year AAA corporate bonds shown in the following exhibit: a. Suppose that market interest rates decline by 100 basis points (i.e., 1%)....
-
Consider a small protein containing 101 amino acid residues. The protein will have 200 bonds about which rotation can occur. Assume that three orientations are possible about each of these bonds. a....
-
Are stock valuation models like the Dividend Discount and Constant Growth models better methods to determine a stock's intrinsic value than using a simple P/E Multiple approach? Growth investorsseek...
-
Describe the financing mechanism for providing health insurance in Italy - that is, what is the distribution/sources of funds used to provide health care coverage?
-
1. Define the unique characteristics of perfect competition. Does perfect competition exist in the real world? 2. How do monopolies maximize profits? 3. What are the unique characteristics of...
-
Why is it important not to judge people with the accent they have when they speak English ?
-
Gender inequalities are still deep-rooted in every society. What do you think will be the solution to end discrimination especially in the workplace?
-
In Chapters 4 and 13 we considered what factors might contribute to the price of a home. In Chapter 4 we looked at living area and in Chapter 13 we considered such features as whether the home had a...
-
The graph of the sequence whose general term is an = n - 1 is which of the following? [8.1] A. B. TITTT 3-2-1 23.45 2.3.4
-
DRK, Inc., has just sold 100,000 shares in an initial public offering. The underwriter's explicit fees were $60,000. The offering price for the shares was $40, but immediately upon issue, the share...
-
What are some different components of the effective costs of buying or selling shares of stock?
-
How do security dealers earn their profits?
-
The balance sheet of River Electronics Corporation as of December 31, 2023, included 12.50% bonds having a face amount of $91.8 million. The bonds had been issued in 2016 and had a remaining discount...
-
The figure below shows two lines of charge in cross- section coming out of the page. Each line of charge has a linear charge density of 8.00 nC/cm and they are separated by a distance d= 16.8 cm....
-
Chipman Sofware recently reported the following amounts in its unadjusted trial balance at its year-end: Accounts Receivable Allowance for Doubtful Accounts Sales (assume all on credit) Debits $...
Study smarter with the SolutionInn App