Bond valuation-Semiannual interest Calculate the value of each of the bonds shown in the following table, all of which pay interest semiannually. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.)Couponinterest rate11%Years tomaturity9Required statedannual return11%11151415615The value of bond A is $. (Round to the nearest cent.)BondABCPar Value$1,0001,000100 Bond valuation-Semiannual interest Find the value of a bond maturing in 7 years, with a $1,000 par value and a coupon interest rate of 11% (5.5% paid semiannually) if the required return on similar-risk bonds is 12% annual interest.The present value of the bond is $(Round to the nearest cent.)

The price of a bond is equal to the sum of the present value of coupon payments and the present…

Bond valuation-Semiannual interest Calculate the value of each of the bonds shown in the following table, all of which pay interest semiannually. (Click on the icon here Coupon interest rate The value of bond A is $. (Round to the nearest cent.) Bond A B C Par Value $1.000 1.000 100 11% 11 15 in order to copy the contents of the data table below into a spreadsheet.) Required stated annual return 11% 14 15 Years to maturity 9 15 6

Bond valuation-Semiannual interest Calculate the value of each of the bonds shown in the following table, all of which pay interest semiannually. (Click on the icon here Coupon interest rate The value of bond A is $. (Round to the nearest cent.) Bond A B C Par Value $1.000 1.000 100 11% 11 15 in order to copy the contents of the data table below into a spreadsheet.) Required stated annual return 11% 14 15 Years to maturity 9 15 6

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

Bond valuationSemiannual interest Calculate the value of each of the bonds shown in the following table all of which pay interest semlannua below in order to copy its contents into a spreadsheet Coupon interest rate Years to maturity Required stated annual retum Bond Par Value $1.000 500 500 A B 12 14 The value of bond A is S710 98| (Round to the nearest cent.)
Bond valuation-Semiannual interest Calculate the value of each of the bonds shown in the following table, all of which pay interest semiannually. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Bond A B C The value of bond A is $ Par Value $500 500 100 Coupon interest rate 9% 12 13 (Round to the nearest cent.) Years to maturity 10 15 5 Required stated annual return 10% 10 16
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
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%
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.
Show all workings. Complete the following table and draw a graph showing how bond pricefor each bond changes over time as they move towards their maturitydates. Describe the relationship between bond prices and timeremaining for maturity.YearsreminingtomaturityBOND ACoupon rate = 8% p.a.Market interest rate =6% p.a.BOND BCoupon rate = 6% p.a.Market interest rate =6% p.a.BOND CCoupon rate = 4% p.a.Market interest rate =6% p.a.109876543210
Bond valuation-Semiannual interest Calculate the value of each of the bonds shown in the following table, all of which pay interest semiannually. below in order to copy its contents into a spreadsheet.) Coupon interest rate Years to Required stated annual return Bond Par Value maturity 11 A $1,000 8% 10 % 500 11 15 12 C 500 15 14 The value of bond A is $710.98 (Round to the nearest cent.)
Calculate the purchase price of the following bonds. Indicate whether the bonds are priced at a discount, at par or at a premium. Give your answers in dollars and cents to the nearest cent. Face Value Coupon Rate Years to Maturity Market Rate a) $100 r = 6.75% 5 j2 = 6.75% b) $1,000 r = 8% 11 j2 = 6.25% c) $10,000 r = 7% 20 j2 = 8.75% Quoted coupon rates and market rates are nominal annual rates compounded semi-annually. a)Price = $ This bond is priced at:a discountpara premium b)Price = $ This bond is priced at:a discountpara premium c)Price = $ This bond is priced at:a discountpara premium
Calculate the accrued interest (in $) and the total purchase price (in $) of the bond purchase. (Round your answers to the nearest cent.) Time Coupon Market Rate Accrued Commission Bonds Total Interest per Bond Purchased Price Company Since Last Price Interest Company 2 9.4 79.75 23 days $9.95 15
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 {
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.
Thebond shown in the following table pays interest annually. Par value Coupon interest rate Years to maturity Current value $1,000 8% 9 $700 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.