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.) Required stated annual return Years to Coupon interest rate Bond Par Value maturity A $500 8% 10 7% 500 12 15 13 C 100 15 6. 14 The value of bond A is $ 535.53'. (Round to the nearest cent.) The value of bond B is $ (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. below in order to copy its contents into a spreadsheet.) Required stated annual return Years to Coupon interest rate Bond Par Value maturity A $500 8% 10 7% 500 12 15 13 C 100 15 6. 14 The value of bond A is $ 535.53'. (Round to the nearest cent.) The value of bond B is $ (Round to the nearest cent.)

Financial Accounting: The Impact on Decision Makers

10th Edition

ISBN:9781305654174

Author:Gary A. Porter, Curtis L. Norton

Publisher:Gary A. Porter, Curtis L. Norton

Chapter10: Long-term Liabilities

Section: Chapter Questions

Problem 10.1E

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.)
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%
Assume bonds payable are amortized using the straight-line amortization method unless stated otherwise. Pricing bonds Bond prices depend on the market rate of interest, stated rate of interest and time. Requirements Compute the price of the following 8% bonds of Country Telecom. a. $100,000 issued at 75.25 $100,000 issued at 94.50 b. $100,000 issued at 103 50 c. $100,000 issued at 94.50 d. $100,000 issued at 103.25 2. Which bond will Country Telecom have to pay the most to retire at maturity? Explain your answer.
1. Calculate the price of a bond using the Excel PV function. Bond Pricing - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In fx Calculate Now Calculation a Calculate Sheet Function Defined Formula Library Names Auditing Options Calculation B14 fe A B D E F G 1 On January 1, Ruiz Company issued bonds as follows: 2 Face Value: 3 Number of Years: 4 Stated Interest Rate: 5 Interest payments per year 6 (Note: the bonds pay interest annually.) $ 500,000 30 7% 7 8 Required: 9 1) Given the different market interest rates below, calculate the following items. 10 Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all 11 function arguments as cell references. 12 13 a) Market Interest Rate: 9% 14 Annual Interest Payment: 15 Bond Selling Price: 16 17 b) Market Interest Rate: 5.5% 18 Annual Interest Payment: 19 Bond Selling Price: 20 21 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. 22 23 The bond in (a)…
Assume bonds payable are amortized using the straight-line amortization method unless stated otherwise. Pricing bonds Bond prices depend on the market rate of interest, stated rate of interest and time. Requirements Compute the price of the following 8% bonds of Country Telecom. $100,000 issued at 75.25 $100,000 issued at 94.50 $100,000 issued at 103 50 $100,000 issued at 94.50 $100,000 issued at 103.25 2. Which bond will Country Telecom have to pay the most to retire at maturity? Explain your answer.
Sheridan Inc. is building a new hockey arena at a cost of $2,150,000. It received a down payment of $430,000 from local businesses to support the project, and now needs to borrow $1,720,000 to complete the project. It therefore decides to issue $1,720,000 of 10- year, 10.5% bonds. These bonds were issued on January 1, 2023, and pay interest annually on each January 1. The bonds yield 10.5% to the investor and have an effective interest rate to the issuer of 10.40530%. (There is an increased effective interest rate due to the capitalization of the bond issue costs.) Any additional funds that are needed to complete the project will be obtained from local businesses. Sheridan paid and capitalized $43,000 in bond issuance costs related to the bond issue. Sheridan prepares financial statements in accordance with IFRS.
5 On January 1, Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year 7 B 9 0 1 2 AWN IC $500,000 a) Required: 1) Calculate the bond selling price given the two market interest rates below. Use formulas that reference data from this worksheet and from the appropriate future or present value tables (found by clicking the tabs at the botto this worksheet). Note: Rounding is not required. 15 7% 2 Annual Market Rate Semiannual Interest Payment: PV of Face Value: +PV of Interest Payments: Bond Selling Price: Annual Market Rate Semiannual Interest Payment: PV of Face Value: +PV of Interest Payments: = Bond Selling Price: 9% $17,500 133,500.01 285,055.55 418,555.56 6.00% $17,500 205,993.38 5343,007.72 $549,001.10 +
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.
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.) Coupon interest rate 11% Years to maturity 9 Required stated annual return 11% 11 15 14 15 6 15 The value of bond A is $. (Round to the nearest cent.) Bond A B C Par Value $1,000 1,000 100
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 accrued interest (in $) and the total purchase price (in $) of the bond purchase. (Round your answers to the nearest cent.) Time Coupon Market Accrued Commission Bonds Total Company Since Last Rate Price Interest per Bond Purchased Price Interest Company 1 9.25 102.50 78 days $2.05 X $5.50 15 $ 1651 X
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.