Question

1. Please watch these videos on bonds, TeachMeFinance Bond Valuation (3:59) and Calculating YTM in EXCEL...

1. Please watch these videos on bonds, TeachMeFinance Bond Valuation (3:59) and Calculating YTM in EXCEL and TI w/ Bionic Turtle (8:57), and answer the following questions: A $1,000 par value bond, has an annual coupon rate of 6 percent, an annual yield to maturity of 7.5 percent, and 10 years until maturity. Assuming semi-annual coupon payments:

a. What is the bond’s coupon payment per period?

b. What is the bond’s price?

c. If the bond were selling for $929, what would the annual yield-to-maturity be?

d. What is the effective yield-to-maturity if you reinvest coupon payments at 9 percent?

Homework Answers

Answer #1

a)
Coupon payment per period = Face value * semiannual coupon rate
= $1000 * 6% / 2
= $1000 * 3%
= $30

Coupon payment per period = $30

b)
Rate = 7.5% / 12 = 3.75%
Nper = 10 * 2 = 20
PMT = $30
FV = 1000

Bond's price can be calculated by using the following excel formula:
=PV(rate,nper,pmt,fv)
=PV(3.75%,20,-30,-1000)
= $895.78

Bond's price = $895.78

c)
Nper = 20
PMT = 30
PV = 929
FV = 1000

Annual yield to maturity calculated by using the following excel formula:
=RATE(nper,pmt,pv,fv)*2
=RATE(20,30,-929,1000)*2
= 7.00%

Annual yield to maturity = 7.00%

d)
Nper = 20
PV = 929
FV = 1941.14
PMT = 0

Effective yield to maturity can be calculated by using the following excel formula:
=RATE(nper,pmt,pv,fv)*2
=RATE(20,0,-929,1941.14)*2
= 7.50%

Effective yield to maturity = 7.50%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
BOND VALUATION Callaghan’s Motors’ bonds have 15 years remaining to maturity. Interest is paid semi-annually, they...
BOND VALUATION Callaghan’s Motors’ bonds have 15 years remaining to maturity. Interest is paid semi-annually, they have a $1,000 par value, the coupon interest rate is 9%, and the yield to maturity is 8%. What is the bond’s current market price? BOND VALUATION Nungesser Corporation’s outstanding bonds have a $1,000 par value, a 9% semiannual coupon, 8 years to maturity, and an 8.5% YTM. What is the bond’s price? BOND VALUATION and YIELD TO MATURITY Suppose a 10-year, $1000 bond...
Module 3 Bond Valuation Worksheet – Complete in Excel. Please answer the following questions. 1. Renfro...
Module 3 Bond Valuation Worksheet – Complete in Excel. Please answer the following questions. 1. Renfro Rentals has issued bonds that have an 7% coupon rate, payable semiannually. The bonds mature in 10 years, have a face value of $1,000, and a yield to maturity of 8%. What is the price of the bonds? 2. Thatcher Corporation’s bonds will mature in 30 years. The bonds have a face value of $1,000 and an 7% coupon rate, paid semiannually. The price...
****PLEASE SHOW IN EXCEL*** 1. Boeing Corporation issues a 3 percent coupon bond with 13 years...
****PLEASE SHOW IN EXCEL*** 1. Boeing Corporation issues a 3 percent coupon bond with 13 years maturity, $1,000 face (par) value, and semi-annual payments. If the yield to maturity of this bond is 7 percent, find the bond's price. A. $388.49 B. $582.73 C. $529.75 D. $662.19 E. none of the answers is correct
1. Today, a bond has a coupon rate of 8.18 percent, par value of 1,000 dollars,...
1. Today, a bond has a coupon rate of 8.18 percent, par value of 1,000 dollars, YTM of 6 percent, and semi-annual coupons with the next coupon due in 6 months. One year ago, the bond’s price was 1,022.04 dollars and the bond had 19 years until maturity. What is the current yield of the bond today? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098. 2....
Today, a bond has a coupon rate of 9.82 percent, par value of 1,000 dollars, YTM...
Today, a bond has a coupon rate of 9.82 percent, par value of 1,000 dollars, YTM of 5.44 percent, and semi-annual coupons with the next coupon due in 6 months. One year ago, the bond’s price was 986.71 dollars and the bond had 11 years until maturity. What is the current yield of the bond today? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098. Help on...
Seven years ago Hangar Corp. issued a 25-year bond with a 6 percent semi-annual coupon. The...
Seven years ago Hangar Corp. issued a 25-year bond with a 6 percent semi-annual coupon. The bond currently sells for $815. (a) What is the bond’s yield to maturity (YTM)? (b) If the bond can be called in six years for redemption price of $1,075, what is the bond’s yield to call (YTC)?
****PLEASE SHOW IN EXCEL*** 2. Xerox Corporation issues a 4 percent coupon bond with 28 years...
****PLEASE SHOW IN EXCEL*** 2. Xerox Corporation issues a 4 percent coupon bond with 28 years maturity, $1,000 face (par) value, and semi-annual coupon payments. If the current market price of this bond is $1271, find its yield to maturity. A.                 5.97%   B. 2.05% C. 2.63% D. 4.31% E. none of the answers is correct
****PLEASE SHOW IN EXCEL*** 4. Johnson Jay Inc. issues a 9 percent coupon bond with 24...
****PLEASE SHOW IN EXCEL*** 4. Johnson Jay Inc. issues a 9 percent coupon bond with 24 years maturity, $1,000 face (par) value, and semi-annual coupon payments. If the current market price of this bond is $751, find its yield to maturity. A. 12.23% B. 8.34% C. 12.95% D. 7.98% E. none of the answers is correct
3) A bond currently sells for $850.  It has an eight-year maturity, an annual coupon of $80...
3) A bond currently sells for $850.  It has an eight-year maturity, an annual coupon of $80 but paid semi-annually, and a par value of $1,000. This bond has a callable feature. If this bond can be called after 5 years, for $1,025. (1) What is its annual yield to maturity?   (2) What is its current yield?     (3) What is the bond’s nominal yield to call (YTC)? (4)   If you bought this bond, would you be more likely to earn the YTM...
1A) Calculate the yield to maturity (i.e., YTM) for the following bond. The bond matures in...
1A) Calculate the yield to maturity (i.e., YTM) for the following bond. The bond matures in 18 years, has a coupon rate of 8.8% with semi-annual payments. The par value of the bond is $1000, while the current market value equals $653.08. (Round to 100th of a percent and enter your answer as a percentage, e.g., 12.34 for 12.34%) 1B) How much would you pay for a zero coupon bond with a par value of $1000, a maturity of 5...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT