. Duration Calculate durations and modified durations for the 3% bonds in Table 3.2. You can follow the procedure set out in Table 3.4 for the 9% coupon bonds. Confirm that modified duration closely predicts the impact of a 1% change in interest rates on the bond prices.

. Duration Calculate durations and modified durations for the 3% bonds in Table 3.2. You can follow the procedure set out in Table 3.4 for the 9% coupon bonds. Confirm that modified duration closely predicts the impact of a 1% change in interest rates on the bond prices.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 3R

See similar textbooks

Related questions

Q: Manually compute the modified duration for a 3-years to maturity, 5% annual coupon bond, when the…

A: Part A Coupon rate=5% YTM=7% Time Period = 3 Years Part B Coupon rate=5% YTM=5% Time Period = 3…

Q: Refer to Figure 2.3 and look at the Treasury bond maturing in May 2018. a. How much would you have…

A: Treasury bonds are a kind of debt financial component that is being used by companies and the…

Q: PLEASE READ THIS DIRECTION) Rules for Bond Valuation Problem Solving: a. For the "PV FACTOR in…

A: Calculation of difference between issue price of the two Bonds Difference between issue price =…

Q: Consider the coupon bond issued by XYZinc Term:3years Payment:175 Facevalue:500 Currently the…

A: Bond's risk-free rate and its price will always be inversely related with each other.

Q: 9. Consider price quotes and characteristics for two different bonds: Bond A Bond B Annual Coupon…

A: According to the information, for Bond A, Coupon is $10 (10%*$100) and ytm is 10.65% Price of Bond A…

Q: How to calculate the accrued interest for a 1000 par bond if the next coupon is payable in 74 days…

A: Accrued interest refers to the interest amount that shall be paid by investor for purchasing the bod…

Q: 1.Calculate the yields to maturity for the following bonds. The prices are stated per 100 of par…

A: Bond It is the instrument of the indebtedness of an issuer of the bond to the holders of the bond.

Q: Charlie Corporation is a chemical company. The company issued an outstanding bond with a P100,000…

A: Answer) Calculation of Selling Price of Bonds Face Value of Bonds = P 100,000 Annual rate of…

Q: Calculate the value of Macaulay’s duration for a 10-year, $1000 par value bond purchased today at a…

A: A coupon bond is a kind of bond that pays fixed interest payments in return to the bondholders till…

Q: 1. Identify whether each of the following bonds is trading at a discount, at par value, or at a…

A: Bond price is referred as the present discounted cash flow that are generated through the bond. It…

Q: ) A bond has a $11,000 face value, an 8-year maturity, and a 2.75% coupon. Find the total of the…

A: Calculation of total interest to bondholder: = Face value × Coupon rate × Time period

Q: The equivalent annual-pay yield-to-maturity (YTM) for a 5.28% coupon monthly-pay bond is closest to…

A: Annual yield to maturity = 0.0528 Monthly yield to maturity (YTM) = 0.0044 (i.e. 0.0528 / 12) Number…

Q: Assuming the bonds will be rated AA, what will the price of the AA-rated bonds be? b. How much…

A: Face Value = $1,000 Coupon Rate = 10.2% Time Period = 5 Years AA rated yield = 9.8%

Q: Calculating the risk premium on bonds The text presents a formula where (1+) = (1-pX1+i+x)+ p(0)…

A: In the given formula:(1+i)= (1-p)(1+i+x)+p(0)a) Rate of interest on risky bond , when the…

Q: 1) Compute the yield to maturity of a 3-year maturity 16% bond purchased at 970 b, whose nominal…

A: “Since you have posted a many questions, we will solve first question for you. To get the remaining…

Q: The table below provides information about treasury bonds. Bond Bond Time to Annual Market Maturity…

A: Here, Bond Number Bond Principal ($) Time to Maturity (Months) Annual Coupon (%) Market price ($)…

Q: Based on a modified duration of 4.1141, the price of the bond should increase by approximately…

A: Modified duration = 4.1141 Increase in YTM = 1.00% Modified duration means expected percentage…

Q: 3. Using Excel, compute the yield-to-maturity for the following bonds (report your Excel formulas a…

A: Yield to maturity is the internal rate of return offered by the bond if the bond is held till…

Q: (3) Use a 1 bps shock to compute duration and convexity (using approximating measures for duration…

A: Bond Duration and convexity: Bond duration is the time-weighted average of all the cash flow…

Q: The current zero-coupon yield curve for risk-free bonds is as follows: . What is the price per $100…

A: Bond payable is a written note promising to pay a certain amount on a specific date. Its maturity is…

Q: Complete the below table to calculate the price of a $1.0 million bond issue under each of the…

A: You have posted multiple part question, so as per our policy only first three parts are answered. If…

Q: Calculate the convexity of the Bond portfolio Bond Maturity Coupon YTM Bonds owned Bond_A 5 years…

A: Here,

Q: For a bond that is currently selling for par value (e, $1000), which one of the following…

A: Financial Management: Financial management comprises of two words i.e. Finance and management.…

Q: For an 18-year, 3.09% annual-pay bond currently trading at par, calculate the approximate modified…

Q: Explain what you see from the pricing calculations. How do the two bonds differ

A: Bond: It is a debt instrument issued by the company for the purpose of raising capital. The holders…

Q: 1.Identify whether each of the following bonds is trading at a discount, at par value,or at a…

A: BondIt is the instrument of the indebtedness of an issuer of the bond to the holders of the bond.

Q: From page 9-2 of the VLN, what is the first thing you want to identify when approaching a bond…

A: When a firm issues bonds to earn cash, bonds payable are documented. Money market securities and…

Q: 15. A Treasury bond has an 8 percent annual coupon and a yield to maturity equal to 7.5 percent.…

A: Please find the answer to the above question below:

Q: Consider a newly issued 7-yr, 8% coupon annual-pay bond priced at $1,112.96. If the…

A: A financial instrument that doesn’t affect the ownership of the common shareholders or management of…

Q: 27. The following is a list of YTM(yield to maturity) of coupon bonds with different maturities.…

A: The forward rate is the rate of interest that applies to a future financial transaction. It is…

Q: Which of the following statements on the value of Bonds A and B is correct?

A: Yield: It is the rate of return for the bondholders given all the interest payments are made and the…

Q: If 10-year Treasury bonds have a yield of 4.3%, 10-year corporate bonds yield 6.7%, the maturity…

A: The return on the investment of the bonds more than the risk-free rate is referred to as risk…

Q: a. Calculate the value of Macaulay’s duration for a 10-year, $1000 par value bond purchased today at…

A: A financial instrument that doesn’t affect the ownership of the common shareholders or management of…

Q: A bond has a MacD of 14.6, ModD of 13.8 and DV01 of $2.5. Suppose its yield to maturity goes up one…

A: D. The bond's price should increase by approximately 13.8%.

Q: 2. Your sister has been offered a 5-year bond with a P1,000 par value and a 7 percent coupon rate.…

A: Calculation of amount to be paid for Bonds Face Value of Bonds = P 1,000 Annual rate of interest =…

Q: 3. Assume that the real risk-free rate, k*, is 3 percent and that inflation is expected to be 8…

A: Market risk premium can be calculated using the following formula:…

Q: Find the Yield to Maturity for Zero-Coupon Bonds for the following 1 year Maturity, Price $96.62 2…

A: Face value = $100 Present value = Face value/(1+ YTM)^time Present value = 100/(1+ YTM)^1 96.62 =…

Q: Given the following spot rates, calculate the value of a 3-year, 6% annual-coupon bond. Spot rates:…

A: Time period is 3 years Annual Coupon rate is 6% To Find: Value of the bond

Q: Rules for Bond Valuation Problem Solving: a. For the "PV FACTOR in computing the PV of the coupon…

A: Current Price of Bond: Because of the fluctuating nature of the bond's price, it is defined in terms…

Q: i. Calculate the value of Macaulay’s duration for a 10-year, $1000 par value bond purchased today at…

A: BOND Bonds are debts instruments that are issued by entities to raise funds and meet their capital…

Q: Consider each of the bonds below: 7A-2. Bond A has an 8-year maturity and a 7% annual coupon. Bond B…

A: Please find the answer to the above question below:

Q: Given the following spot rates, calculate the value of a 3-year, 4% annual-coupon bond. Spot rates:…

Concept explainers

Characteristics of Bonds

Question

14. Duration Calculate durations and modified durations for the 3% bonds in Table 3.2. You can follow the procedure set out in Table 3.4 for the 9% coupon bonds. Confirm that modified duration closely predicts the impact of a 1% change in interest rates on the bond prices.

Definition Definition Calculates the present value of a bond's expected future periodic coupon payments. Bond valuation determines the theoretical fair value of a particular bond and helps investors estimate what rate of return they could expect. The bond's theoretical fair value is computed by discounting the future cash flows or coupon payments by an applicable discount rate.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

what is the Fraction of the total value? I do not understand how do you get the number that divides example =b3/5153 where do you get 5153

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

This first table describes prevailing market interest rates. Market Data Yield 0.05 Required: Using the yield above and the information contained in the table below, please calculate the price and duration of the bond as well as all necessary steps. (Use cells A5 to B5 from the given information to complete this question.) Time Until Payment Payment Discounted Payment Weight Time × Weight 1.00 $30.00 2.00 $30.00 3.00 $30.00 4.00 $1,030.00 Price: Duration
All computations must be done and shown manually Question 4 Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity. Years remaining to maturity BOND A Coupon. rate = 8% p.a. Market interest rate = 6% p.a. BOND B Coupon rate = 6% p.a. Market interest rate = 6% p.a. BOND C Coupon rate = 4% p.a. Market interest rate = 6% p.a. 10 9 8 7 6 5 4 3 2 1 0
All computations must be done and shown manually Question 4 Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity. Please include graph as per above information Years remaining to maturity BOND A Coupon. rate = 8% p.a. Market interest rate = 6% p.a. BOND B Coupon rate = 6% p.a. Market interest rate = 6% p.a. BOND C Coupon rate = 4% p.a. Market interest rate = 6% p.a. 10 9 8 7 6 5 4 3 2 1 0
еВook Problem Walk-Through Last year Carson Industries issued a 10-year, 13% semiannual coupon bond at its par value of $1,000. Currently, the bond can be called in 6 years at a price of $1,065 and it sells for $1,200. a. What are the bond's nominal yield to maturity and its nominal yield to call? Do not round intermediate calculations. Round your answers to two decimal places. YTM: % YTC: % Would an investor be more likely to earn the YTM or the YTC? -Select- -Select- ent yield and to Table 7.1) Round your answer to two decimal places. b. Since the YTM is above the YTC, the bond is likely to be called. Since the YTC is above the YTM, the bond is likely to be called. Since the YTM is above the YTC, the bond is not likely to be called. Since the YTC is above the YTM, the bond is not likely to be called. Since the coupon rate on the bond has declined, the bond is not likely to be called. I. If the bond is called, the capital gains yield will remain the same but the current yield will be…
The following information about bonds A, B, C, and D are given. Assume that bond prices admit noarbitrage opportunities. What is the convexity of Bond D?Cash Flow at the end ofBond Price Year 1 Year 2 Year 3A 91 100 0 0B 86 0 100 0C 78 0 0 100D ? 5 5 105
K Assume that a bond will make payments every six months as shown on the following timeline (using six-month periods): 0 2 5 Period $19.53 a. What is the maturity of the bond (in years)? b. What is the coupon rate (as a percentage)? c. What is the face value? Cash Flows View an example Get more help. ★ a. What is the maturity of the bond (in years)? The maturity is years. (Round to the nearest integer.) A 6 1 MacBook Pro & 7 $19.53 * 8 9 C 59 $19.53 60 $19.53+$1,000 Clear all BUB 0 {
Calculating the risk premium on bonds The text presents a formula where (1+1) = (1-p)(1 +i+x) + p(0) where i is the nominal interest rate on a riskless bond x is the risk premium p is the probability of default (bankruptcy) If the probability of bankruptcy is zero, the rate of interest on the risky bond is When the nominal interest rate for a risky borrower is 8% and the nominal policy rate of interest is 3%, the probability of bankruptcy is %. (Round your response to two decimal places.) When the probability of bankruptcy is 6% and the nominal policy rate of interest is 4%, the nominal interest rate for a risky borrower is %. (Round your response to two decimal places.) When the probability of bankruptcy is 11% and the nominal policy rate of interest is 4%, the nominal interest rate for a risky borrower is %. (Round your response to two decimal places.) The formula assumes that payment upon default is zero. In fact, it is often positive. How would you change the formula in this case?…
Suppose the term structure of interest rate is flat. Consider the following four bonds: Bond Term to Maturity (year) Coupon rate YTM 1 5 10% 7% 2 3 7 7 10% O a. 2,3,4,1 O b. 2,1,4,3 O c. 1,2,3,4 O d. 4,3,2,1 3% 3% 7% 4 7 If the yield-to-maturity for all bonds changes by 1%, rank the bonds from the lowest percentage change in price to the largest percentage change in price based on duration approximation. 7% 5%
1. You examine the following 4 bonds. Rank each bond from highest Duration to lowest, explaining your rationale. Bond Maturity YTM Coupon A 20 8% 10% B 20 4% 5% C 10 8% 10% 20 8% 5% Accumo
Assume the following: Bond A coupon = 6%, maturity = 5 years, yield to maturity = 6% Bond B coupon = 0%, maturity = 5 years, yield to maturity = 6% Bond C coupon = 6%, maturity = 5 years, yield to maturity = 6.5% Which of the following statements concerning duration is correct? Group of answer choices A. Duration of C<Duration of A=Duration of B. B. Duration of A>Duration of B>Duration of C. C. Duration of C < Duration of A < Duration of B. D. Duration of A< Duration of B<Duration of C.
The bond shown in the following table attached pays interest annually. a. Calculate the yield to maturity (YTM)for the bond. b. What relationship exists between the coupon interest rate and yield to maturity and the par value and market value of a bond? Explain.
(PLEASE READ THIS DIRECTION)Rules for Bond Valuation Problem Solving:a. For the "PV FACTOR in computing the PV of the coupon and PV for the maturity value/ principal use until 8-9th decimal place" before multiplying the coupon payment or future value.Example: ___x 2.123456789 or 22.12345678b. For "COMPOUNDED RATES" include all decimals in the rate (do not round off).Example semi-annual: 13%/2 =0.065c. For the "VALUE OF THE BOND/ PRICE OF THE BOND" round off your answers and final answers into whole numbers.Example: 824.59= 825 1. A bond issued by Delta Corporation matures in 12 years. It has a 12.5 percent annual coupon rate and a face value of P10,000. The bond has a discount rate to maturity of 9.5 percent. What is the price of Omega's bond today?