a. Use a spreadsheet to calculate the durations of the two bonds in Spreadsheet 1 if the
Question:
a. Use a spreadsheet to calculate the durations of the two bonds in Spreadsheet 1 if the annual interest rate increases to 12%. Why does the duration of the coupon bond fall while that of the zero remains unchanged? (Examine what happens to the weights computed in column F.)
b. Use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8% and the semiannual interest rate is again 5%. Explain why duration is lower than in Spreadsheet. (Again, start by looking at columnF.)
Time until Column (C) times Column (F) 0.0197 0.0376 0.0537 1.7741 1.8852 (Discount rate 5% per period)Weight 0.0395 0.0376 0.0358 Period | Cash Flow | (Years) 0.5 38.095 36.281 34.554 2.0 1040 Sum 964.540 1.0000 0.000 0.0000 0.0000 0.0000 10 B. Zero-coupon 0.5 0.0000 0.0000 0.000 822.702 822.702 2.0 1000 Sum 1.0000 2.0000 15 16 Semiannual int rate: 0.05 17 18 Weight Present value of each payment (column E) divided by the bond price
Step by Step Answer:
a Period Time until Payment Years Cash Flow PV of CF Discount rate 6 per period Weight Years Weight ...View the full answer
Related Video
Bond valuation is the process of determining the worth of a bond. It is based on the present value of the bond\'s future cash flows, which include coupon payments and the return of the bond\'s face value (or \"principal\") at maturity. The discount rate used in the calculation is directly tied to prevailing interest rates, and a rise in interest rates will decrease the present value of the bond and thus lower its price. Conversely, a fall in interest rates will increase the present value of the bond and raise its price. Interest rates serve as a benchmark for determining the value of a bond, as they determine the discount rate used in the bond valuation calculation. The most commonly used measure of interest rates is the yield to maturity (YTM), which represents the internal rate of return of an investment in a bond if the investor holds the bond until maturity and receives all scheduled payments. Yield to maturity is a function of the coupon rate, the current market price of the bond, the face value of the bond, and the number of years remaining until maturity. By comparing the yield to maturity of a bond to prevailing market interest rates, an investor can assess the relative value of the bond.
Students also viewed these Accounting questions
-
Use a spreadsheet to calculate the k values asked for in Prob. 13.22 In Problem 22 (a) Use Mathcad to create an animation showing how contours and three-dimensional plots of the H+2 LCAO MOs 1 and 2...
-
The following are sales, cost of sales, and inventory data for Aladdin Products Supply Company, a wholesale distributor of cleaning supplies. Dollar amounts are in millions. Required: a. Use a...
-
Use a spreadsheet to calculate the 2-day and 5-day SMA for ten consecutive day closing prices of Yahoo! Inc. Graph the closing prices and averages. 21-Apr 28.55 1-May 26.81 22-Apr 28.54 2-May 28.67...
-
When the wavelength of radiation falling on a metal is changed from 500 nm to 200 nm, the maximum kinetic energy of the photoelectrons becomes three times larger. The work function of the metal is...
-
The second hand of a wristwatch is 0.5 cm long. a. What is the speed, in meters per hour, of the tip of the second hand? b. How long would the minute hand of the same watch have to be for its tip to...
-
A viscosity motor/pump is shown in Fig. P6.84. The rotor is concentric within a stationary housing. The clearance \(h\) between the housing and the rotor is small compared to the width \(w\) and...
-
a. State the second standard of field work. b. Indicate the scope and objectives of this standard.
-
Noir Company produces four versions of its model J17-21 bicycle seat. The four versions have different shapes, but their processing operations and production costs are identical. During July, these...
-
6. A jellyfish is floating in a water-filled aquarium 1.00 m behind a flat plane of glass 6.00 cm thick and having an index of refraction of 1.50. a. Where is the image of the jellyfish located? b....
-
Exercise 14-17 (Algorithmic) (LO. 1, 4) Prance, Inc., earned pretax book net income of $1,925,000 in 2020. Prance acquired a depreciable asset in 2020, and first-year tax depreciation exceeded book...
-
A 30-year maturity bond has a 7% coupon rate, paid annually. It sells today for $867.42. A 20-year maturity bond has 6.5% coupon rate, also paid annually. It sells today for $879.50. A bond market...
-
a. Footnote 6 presents the formula for the convexity of a bond. Build a spreadsheet to calculate the convexity of a 5-year, 8% coupon bond making annual payments at the initial yield to maturity of...
-
KG Spring Skating School Inc. had the following account balances as at April 30, 2012: Cash $23,000; Equipment $2,000; Accounts Payable $500; Unearned Revenue (for advance registration fees) $17,500;...
-
Compute the current - year income tax liability for each of the following unrelated calendar year C corporations.a . Darter Corporation has taxable income of $ 6 9 , 5 0 0 . b . Owl Corporation has...
-
George transfers land ( basis of $ 1 4 0 K and fair market value of $ 3 2 0 K ) to EB Corporation for 8 0 % of its stock and a note payable in the amount of $ 8 0 K . EB assumes George s mortgage on...
-
During 2 0 2 4 , its first year of operations, Riley Construction provides services on account of $ 1 2 6 , 0 0 0 . By the end of 2 0 2 4 , cash collections on these accounts total $ 9 3 , 0 0 0 ....
-
What is the Christian's appropriate attitude towards poverty and work? Have efforts to alleviate poverty been successful? Is poverty a problem that is best addressed by non-government actors? What...
-
Wilma is the Chief Executive Officer of Flintstone Corporation, a publicly traded, calendar year C corporation. For the current year, Wilma's compensation package consists of: Cash compensation $ 2 ,...
-
What issues of confidentiality and liability does the hospitals peer review function present?
-
Pappa's Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are...
-
Compare the two projects in the Learning point. Calculate the two scenarios in which the discount rates are 4% and 10%. 140 120 100 80 60 40 60 40 20 20 0 This Year After 1 Year After 2 Years Net...
-
What do we mean when we say that financial accounting information is general-purpose?
-
How does managements explanation enhance the usefulness of financial accounting information?
-
What are several examples of internal, management-prepared information that ordinarily would not be communicated externally?
-
A couple obtained a $20,000 mortgage loan at an interest rate of 10.5% compounded monthly. (Original principal equals to PV of all payments discounted at the interest rate on the loan contract) (1)...
-
What strategies and tactics are employed to manage strategic risks and uncertainties, including geopolitical instability, supply chain disruptions, and emerging competitive threats, while preserving...
-
How do strategic planners integrate ethical considerations and sustainability imperatives into strategic planning processes, balancing short-term financial objectives with long-term societal and...
Study smarter with the SolutionInn App