Data: Face amount of bond: 10 000$ Purchase date: 7/1/89 Maturity value: 11 000$ Maturity date: 12/31/94 Coupon rate: 6% per year, compounded semiannually Coupon dates: 6/30 and 12/31 Purchaser's yield to maturity: 8% per year, compounded semiannually Question: In what range is the purchase price of the bond? A. Less than 9 400 В. 9 400, but less than 9 800 С. 9 800, but less than 10 200 D. 10 200 but less than 10 600 Е. 10 600 or more

Data: Face amount of bond: 10 000$ Purchase date: 7/1/89 Maturity value: 11 000$ Maturity date: 12/31/94 Coupon rate: 6% per year, compounded semiannually Coupon dates: 6/30 and 12/31 Purchaser's yield to maturity: 8% per year, compounded semiannually Question: In what range is the purchase price of the bond? A. Less than 9 400 В. 9 400, but less than 9 800 С. 9 800, but less than 10 200 D. 10 200 but less than 10 600 Е. 10 600 or more

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 8R: a. Reset the Data Section to its initial values. The price of this bond is 1,407,831. What would it...

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.
Bond A: 10 Year annual bond, price $1010, coupon rate 6%, par $1000 Bond B: 10 year semi-annual bond, price $1010, coupon rate 6%, par $1000 Does Bond A have a higher cost of debt than Bond B?
Bond A Bond B Years to maturity 5 years 10 years Coupon rate 5% 5% Par value 1000 1000 Yield to maturity 8% 6% Par amount owned R3,45 million R2 million Market value R30 367.59 (in 000’s) R18 528 (in 000’s) How do you work out the duration using Macauly's duration.
What is the Holding period return____% Purchase price of the bond (pv) $910 Sale price of the bond after 2 years (fv) $966.98 Number of coupon payments received (nper) 2 Coupon payment (pmt) $82.00
A $100 000 face value strip bond has 6 years remaining until maturity. If the current market return rate is 4% compounded semi- annually, what is the fair market value of the strip bond? Select one: O A. $126 824 O B. $79 031 OC. $88 797 O D. $100 000 OE $78 849
Which bond should an investor choose: Dollar-denominated bond Euro-denominated bond i$ = 6% i€ = 8% spot exchange rate = .90 euro/$1 expected future spot exchange rate = .96 euro/$1 Assume a 1-year time horizon. Show all calculations. Also, explain in words.
Bond A Bond B Years to maturity 5 years 10 years Coupon rate 5% 5% Par value 1000 1000 Yield to maturity 8% 6% Par amount owned R3,45 million R2 million Market value R30 367.59 (in 000’s) R18 528 (in 000’s) Required: Without doing any calculations, which bond would have a higher duration Assuming that Bond A is an option-free bond, calculate the bond’s modified duration using Macauly’s Duration. Assume that the duration of Bond A and B is 4.2 and 7.5 respectively; determine the duration of the portfolio.
What is assumed the be the face value aka par value aka principal aka loan amount of a bond? It's also assumed to be a bond's FV. 10% $0 $100 $1,000
The following information relates to a forward contract written on a bond: Bond price = $95 Maturity = 1 year Coupon 1, paid in 6 months = $3; Coupon 2, paid immediately prior to maturity of forward = $2 Riskless rate of interest = 5% What is the forward price? A) $94.43 B $85.77 c) $94.79 D) $93.79
Given: Bond Face or Par Value: $1,000 Current Market Price: $995.34 Time to Maturity: 11 years Coupon: $30 per year, paid semiannually Bond is callable in five years at $1,030 a. What is the bond's coupon rate? b. What is the bond's current yield? c. What is the bond's yield to maturity? (Use financial calculator to solve, list all keystrokes)
A$10,000 bond issue with a stated rate of interest of 10%, when the market rate of interest is 12%, means that the bond will be sold for: O A. $10,000 B. more than $10,000. OC. less than $10,000. O D. the maturity value.
2. Determine the purchase price and the amount of premium/discount of the given bonds. Face Value Coupon Rate Yield Rate Redemption Date Purchase Date Purchase Price ? a. $1000.00 5.25% 5.25% January 01, 2024 January 01, 2019 b. $5000.00 4.75% 6.75% October 20, 2028 October 20, 2018 ? c. $10,000.00 7.85% 4.15% August 16, 2034 August 16, 2014 ? Amount of Premium/Discount ? ? ?