Question

A bond with 20 years to maturity, a 10% coupon rate that pays coupons semi-anually, and...

A bond with 20 years to maturity, a 10% coupon rate that pays coupons semi-anually, and is selling for $875 will have a yield to maturity of? Please Answer Using Excel!!!

Homework Answers

Answer #1

Please see the picture below. I have done the working in excel. Inputs are hard coded figures on the left hand side (column A, B & C).

Outputs are in column E and I have shown the formula used in each cell of column E in the corresponding cell in column F. So, please pay special attention to column F.

The final answer is 11.62% highlighted in cell with yellow color.

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
A bond has a coupon rate of 4.6% and pays coupons semi-annually. The bond matures in...
A bond has a coupon rate of 4.6% and pays coupons semi-annually. The bond matures in 5 years and the yield to maturity on similar bonds is 2%. Is this a par, premium or discount bond? What is the price of the bond?   What is the coupon rate for the bond? Assume semi-annual payments. Answer as a percent! Bond Coupon Rate Yield Price Quote t Apple B ? 3.7% 99.09 21
A bond has a coupon rate of 3.6% and pays coupons semi-annually. The bond matures in...
A bond has a coupon rate of 3.6% and pays coupons semi-annually. The bond matures in 3 years and the yield to maturity on similar bonds is 4.3%. What is the price of the bond?
A bond has a coupon rate of 2.1% and pays coupons semi-annually. The bond matures in...
A bond has a coupon rate of 2.1% and pays coupons semi-annually. The bond matures in 4 years and the yield to maturity on similar bonds is 3.7%. What is the price of the bond?
A 9.5% coupon bearing bond pays interest semi-annually and has a maturity of 20 years. If...
A 9.5% coupon bearing bond pays interest semi-annually and has a maturity of 20 years. If the annual yield to maturity is 5.8%, what is the current price of this bond? (Answer to the nearest penny.)
Bond A pays annual coupons pays ins next coupon in one year, matures in 23 years...
Bond A pays annual coupons pays ins next coupon in one year, matures in 23 years and has a face value of one thousand. Bond B pays semi annual coupons pays its next coupon in six months, matures in three years and has a face value of one thousand. The two bonds have the same yield to maturity. Bond A has a coupon rate of 7.70 percent and is priced at $736.19. Bond B has a coupon rate of 6.40...
Bond A pays annual coupons, pays its next coupon in 1 year, matures in 17 years,...
Bond A pays annual coupons, pays its next coupon in 1 year, matures in 17 years, and has a face value of 1,000 dollars. Bond B pays semi-annual coupons, pays its next coupon in 6 months, matures in 15 years, and has a face value of 1,000 dollars. The two bonds have the same yield-to-maturity. Bond A has a coupon rate of 9.28 percent and is priced at 998.32 dollars. Bond B has a coupon rate of 9.62 percent. What...
A bond that pays coupons annually is issued with a coupon rate of 4 percent, maturity...
A bond that pays coupons annually is issued with a coupon rate of 4 percent, maturity of 30 years, and a yield to maturity of 7 percent. What annual rate of return will be earned in the following situations by an investor who purchases the bond and holds it for 4 year if the bond’s yield to maturity when the investor sells is 8 percent? a) All coupons were immediately consumed when received. b) All coupons were reinvested in your...
A bond pays a semi-annual coupon at an APR of 10.00%. The bond will mature in...
A bond pays a semi-annual coupon at an APR of 10.00%. The bond will mature in 7.00 years and has a face value of $1,000.00. The bond has a yield-to-maturity of 12.50% APR. What is the current yield for the bond? What is the current yield for the bond? A bond has ten years until maturity. The face value on the bond is $1,000.00, while the coupon rate attached to the bond is 9.75%. The bond pays coupons on an...
HW9 #6) Bond A pays annual coupons, pays its next coupon in 1 year, matures in...
HW9 #6) Bond A pays annual coupons, pays its next coupon in 1 year, matures in 12 years, and has a face value of 1,000 dollars. Bond B pays semi-annual coupons, pays its next coupon in 6 months, matures in 13 years, and has a face value of 1,000 dollars. The two bonds have the same yield-to-maturity. Bond A has a coupon rate of 8.46 percent and is priced at 836.24 dollars. Bond B has a coupon rate of 7.72...
A 7 year maturity corporate bond has coupon rate of 7% and pays coupon semi-annually. Considering...
A 7 year maturity corporate bond has coupon rate of 7% and pays coupon semi-annually. Considering Par value of $1000, what would be the bond price if Effective Annual Yield is 10%? Please explain all steps, Thanks!
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT