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

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

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 Valuation-Semiannual Interest: Calculate the value of each of the bonds shown in the following table, all of which pay interest semiannually. Bond Per Value Coupon Interest Rate Years to Maturity Required stated annaul return A $1,000 9% 9 11% B 500 13 20 12 C 500 12 5 15 The value of bond A is? The value of Bond B is? The value of Bond C is? Remember to round all answers 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.) 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 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. 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.)
Listen Assume that there is a bond that pays $20.00 at the and of year 2, and $105.00 at the end of year 7. It sells at a total =$(20.00+105.00). The Macauley duration of the bond is? Answer with two digits decimal accuracy. Blank Excel Worksheet Your Answer
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.
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%
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
Give typing answer with explanation and conclusion 1- Imagine the bond above displayed the following details: $10,000 Matures: January 31, 2030; Interest of $200 payable June 30 and December 31 of each year. Can you calculate the annual effective interest rate for this bond? a)2% b)4% c)6% d)One cannot tell.
Would you please help me understand how you got 16 for semiannual periods (number of period)? Bond premium amortised = Total bond premium ÷ Number of period = $407,830 ÷16 semiannual periods = $25,489 (Rounded to the nearest dollars).
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)…
g bond if interest (coupon) is paid semiannually? (Round to two decimal places.) Years to Maturity i Data Table Rate 20 (Click on the following icon in order to copy its contents into a spreadsheet.) Yeld to Maturity $1.000,00 $1.000 00 S5.000.00 $1.000.00 6% 12% 7% 8% Years to Mahurity 20 10 20 15 Price $800 00 $1.000.00 $3.110.00 $1,130.00 Print Done answer.box and then click Check Answer