Suppose a bond with no expiration date has a face value of $10,000 and annually pays a fixed amount of interest of $700. a. In the table provided below, calculate and enter either the interest rate that the bond would yield to a bond buyer at each of the bond prices listed below or the bond price at each of the interest yields shown. Instructions: Enter your answers in the gray-shaded cells. For bond prices, round your answers to the nearest hundred dollars. For interest yields, round your answers to 2 decimal places.

Suppose a bond with no expiration date has a face value of $10,000 and annually pays a fixed amount of interest of $700. a. In the table provided below, calculate and enter either the interest rate that the bond would yield to a bond buyer at each of the bond prices listed below or the bond price at each of the interest yields shown. Instructions: Enter your answers in the gray-shaded cells. For bond prices, round your answers to the nearest hundred dollars. For interest yields, round your answers to 2 decimal places.

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

Excel Activity: Bond Valuation Clifford Clark is a recent retiree who is interested in investing some of his savings in corporate bonds. His financial planner has suggested the following bonds: • Bond A has a 10% annual coupon, matures in 12 years, and has a $1,000 face value. • Bond B has an 8% annual coupon, matures in 12 years, and has a $1,000 face value. • Bond C has a 12% annual coupon, matures in 12 years, and has a $1,000 face value. Each bond has a yield to maturity of 10%.
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
The bond shown in the following table pays interest annually in the table attached. 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.
The bond shown in the following table attached pays interest annually. 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.
All computations must be done and shown manually Question 4 Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity. Years remaining to maturity BOND A Coupon. rate = 8% p.a. Market interest rate = 6% p.a. BOND B Coupon rate = 6% p.a. Market interest rate = 6% p.a. BOND C Coupon rate = 4% p.a. Market interest rate = 6% p.a. 10 9 8 7 6 5 4 3 2 1 0
All computations must be done and shown manually Question 4 Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity. Please include graph as per above information Years remaining to maturity BOND A Coupon. rate = 8% p.a. Market interest rate = 6% p.a. BOND B Coupon rate = 6% p.a. Market interest rate = 6% p.a. BOND C Coupon rate = 4% p.a. Market interest rate = 6% p.a. 10 9 8 7 6 5 4 3 2 1 0
The prices of several bonds with face values of $1,000 are summarized in the following table: state whether it trades at a discount, at par, or at a premium. Bond A is selling at (Select from the drop-down menu.) . For each bond,
Calculate the accrued interest (in $) and the total proceeds (in $) of the bond sale. (Round your answers to the nearest cent.)
Create a table with the price of the two bonds in the case where the discount rate is 8%, 11% and 14% respectively and briefly comment on the results.
The following table summarizes prices of various default-free zero-coupon bonds ($100 face value): (Click on the following icon in order to copy its contents into a spreadsheet.) Maturity (years) 1 2 3 4 5 Price (per $100 face value) $95.51 $91.05 $86.38 $81.65 $76.51 a. Compute the yield to maturity for each bond. b. Plot the zero-coupon yield curve (for the first five years). c. Is the yield curve upward sloping, downward sloping, or flat? Note: Assume annual compounding. Question content area bottom Part 1 a. Compute the yield to maturity for each bond. The yield on the 1-year bond is enter your response here%. (Round to two decimal places.)
The prices of several bonds with face values of $1,000 are summarized in the following table: For each bond, state whether it trades at a discount, at par, or at a premium.
Assume coupons are paid annually. Here are the prices of three bonds with 10 year maturities. Assume face value is $100. Bond Coupon a. What is the yield to maturity of each bond? b. What is the duration of each bond? Complete this question by entering your answers in the tabs below. Required A Required B What is the duration of each bond? Note: Do not round intermediate calculations. Round your answers to 2 decimal places.