3) Answer the below questions for bonds A and B.Bond A 8% 8%2$100.00 $100.00 $100.00 $104.055CouponYield to maturity Maturity (years) ParPriceBond B 9%8%(a) Calculate the actual price of the bonds for a 100-basis-point (1% annual) increase in interest rates.(b) Using (modified) duration, estimate the price of the bonds for a 100-basis-5point (1% annual) increase in interest rates.(c) Explain why your answers in parts (a) and (b) differ. Answer the below questions for bonds A and B.CouponYield to maturityMaturity (years)ParPriceBond B9%8%Bond A8%8%25$100.00 $100.00$100.00 $104.055(a) Calculate the actual price of the bonds for a 100-basis-point (1% annual)increase in interest rates.(b) Using (modified) duration, estimate the price of the bonds for a 100-basis-point (1% annual) increase in interest rates.(c) Explain why your answers in parts (a) and (b) differ.

Modified duration:Modified duration takes into account both the bond's coupon rate and its time to…

Bond A Coupon 8% Yield to maturity 8% Maturity (years) 2 Par Price Bond B 9% 8% 5 $100.00 $100.00 $100.00 $104.055 (a) Calculate the actual price of the bonds for a 100-basis-point (1% annual) increase in interest rates. (b) Using (modified) duration, estimate the price of the bonds for a 100-basis-

Bond A Coupon 8% Yield to maturity 8% Maturity (years) 2 Par Price Bond B 9% 8% 5 $100.00 $100.00 $100.00 $104.055 (a) Calculate the actual price of the bonds for a 100-basis-point (1% annual) increase in interest rates. (b) Using (modified) duration, estimate the price of the bonds for a 100-basis-

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

Similar questions

a. Reset the Data Section to its initial values. The price of this bond is 1,407,831. What would it be if there were only 9 or 8 years to maturity? Use the worksheet to compute the bond issue prices and enter them in the spaces provided. Bond issue price (9 years to maturity) __________________ Bond issue price (8 years to maturity) __________________ b. Compare these prices to the bond-carrying values found in the effective interest amortization schedule you originally printed out in requirement 3. Explain the similarity. c. Click the Chart sheet tab. The chart presented shows the price behavior of this bond based on years to maturity. Explain what effect years to maturity has on bond prices. Check your explanation by trying 8% as the effective rate (cell E10) and clicking the Chart sheet tab again. Also try 9%. When the assignment is complete, close the file without saving it again. Worksheet. Modify the BONDS3 worksheet to accommodate bonds with up to 20-year maturity. Use your new model to determine the issue price and amortization schedules of a 2,000,000, 18-year, 10% bond issued to yield 9%. Preview the printout to make sure that the worksheet will print neatly, and then print the worksheet. Save the completed file as BONDST. Hint: Expand both amortization schedules to 20 years. Expand the scratch pad to 20 years. Modify FORMULA1 in cell F17 to include the new ranges. Chart. Using the BONDS3 file, prepare a line chart that plots annual interest expense over the 10-year life of this bond under both the straight-line and effective interest methods. No Chart Data Table is needed. Put A23 to A32 in the Label format and then select A23 to A32, D23 to D32, and B40 to B49 as a collection. Enter all appropriate titles, legends, formats, and so forth. Enter your name somewhere on the chart. Save the file again as BONDS3. Print the chart.
B. Complete the information below using Bonds. Redemption Value (F) Conversion per year (m) Bimonthly Coupon Payments (k) Bond Rate (r) 11. 18% P7.50 P680 Quarterly 11% 12. P900 Quarterly 12.8% 13. P1,300 Bimonthly 12% 14. 15. Annually 15% P105.00
The following table gives the prices of bonds Bond Principal ($) Time to maturity Annual coupon ($) Bond Price ($) 100 (years) 0.5 100 1 100 100 1.5 2 The bonds provide coupon are semiannual coupon bond a. Calculate 6-month, 12-month, 18-month and 24-month zero rates. 1567 0 98 100 100 101 b. What is the forward rate for the six-month period beginning in 12 months. c. Estimate the price of a two-year bond providing annual coupon of 7% annually.
1. Calculate the total annual interest, total cost, and current yield for the bonds. (Round the"Current yield" to the nearest tenth percent and other answers to the nearest whole dollar.)Bond Number of bonds purchased Selling price Total annual interest Total cost Current yieldMuni 5 22 6 81.375 $ $ %
The table below shows current and expected future one-year interest rates, as well as current interest rates on multiyear bonds. Use the table to calculate the liquidity premium for each multiyear bond. Year One-Year Bond Rate Multlyear Bond Rate 1 2.00% 2.00% 2 5.00% 5.00% 6.00% 7.00% 7.00% 9.00% 9.00% 11.00% The liquidity premiums for each year are given as: (Enter your responses rounded to two decimal places) 111 = 121= ly= 141. = 151 135 %
For the following bond redeemed at par, in the table below, determine (a) the premium or discount and (b) the purchase price. Yield Rate Bond Rate Payable Semi- Annually Time Before Compounded Semi- Annually Par Value Maturity $22,000 8.4% 12 years 5.3%
Using Table 2 (PV$1), find the Present Value (PV) Factor used to calculate the PV of the lump sum bond payment for this bond: Bond #1 Face Value $100 Stated Rate = 8% Market Rate = 6% Time to Maturity = 5-Years Quarterly Payments
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
The Excel file Immunization Using Individual Bonds contains information about three bonds. Use this data to: Yield to maturity (Expected/Current) 7% Number of Years to Future Liability 8 Future Liability $ 3,000.00 Bond 1 Bond 2 Bond 3 Coupon rate 8.00% 9.000% 7.00% Maturity 9 24 15 Face value 1,000 1,000 1,000 Explain which bond you prefer to use to attempt to immunize this obligation which is due in 8 years. Analyze each bond’s performance in attempting to achieve immunization Please show work in excel and functions/equations used.
The table below shows current and expected future one-year interest rates, as well as current interest rates on multiyear bonds. Use the table to calculate the liquidity premium for each multiyear bond. Year One-Year Bond Rate Multiyear Bond Rate 1 2.00% 2.00% 2 3.00% 4.00% 3 6.00% 6.00% 4 9.00% 7.00% 5 11.00% 9.00% Part 2 The liquidity premiums for each year are given as: (Enter your responses rounded to two decimal places.)
4. What is the carrying value of the bonds at the end of the second period (third number)? Premium 57,913.01 Carrying value (bonds) 432,913.01 Face Rate Market Rate Semiannual payments a. b. Cash Payment C. d. e. 14% 10% 0 or 1 2 or 3 4 or 5 6 or 7 8 or 9 Interest Expense Today Period #1 26,250.00 Period #2 26,250.00 Carrying value at end of second period (third number) ___________?__ 2. Disc. or Prem. Amort. 21,645.65 21,415.43 Disc. or Prem. 4,604.35 4,834.57 57,913.01 53,308.66 48,474.10 Face Value 375,000.00 375,000.00 375,000.00 Carrying Value 432,913.01 428,308.66 423,474.10
Calculate the value of each bond and discuss whether it sells at par, discount, or premium. (Annual interest rate) O A. Bond Bond Value A B C O B. Bond A B C O C. Bond A B с O D. Bond A B C $1,149.39 Discount $1,000.00 Par $85.60 Premium Bond Value Sells at par/discount/premium Bond Value $1,149.39 Premium $1,000.00 Par $85.60 Discount Sells at par/discount/premium Bond Value Sells at par/discount/premium $1,149.39 Premium $1,000.00 Par $85.60 Premium Sells at par/discount/premium $1,049.39 Premium $1,100.00 Premium $85.60 Discount Bond Par value Coupon interest Years to rate maturity JA B IC $1000 14% $1000 18% $100 10% 120 16 18 Required return 12% 8% 13%