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
Active Questions
  • Your company is thinking of introducing a Bring Your Own Device (BYOD) policy. You have been...
    asked 6 minutes ago
  • Attached is the file GeometricObject.java. Include this in your project, but do not change. Create a...
    asked 8 minutes ago
  • Suppose the number of cars in a household has a binomial distribution with parameters n =...
    asked 11 minutes ago
  • HR needs some information on the new interns put into a database. Given an id, email,...
    asked 32 minutes ago
  • Problem solving strategies Questions years = input("Enter a number of years and I'll tell you how...
    asked 37 minutes ago
  • Calculate ?Hrxn for the following reaction: CH4(g)+4Cl2(g)?CCl4(g)+4HCl(g) Use the following reactions and given ?H?s. C(s)+2H2(g)?CH4(g)?H=?74.6kJC(s)+2Cl2(g)?CCl4(g)?H=?95.7kJH2(g)+Cl2(g)?2HCl(g)?H=?184.6kJ Express...
    asked 43 minutes ago
  • ASCII (American Standard Code for Information Interchange) has an encoding for every character of the alphabet,...
    asked 58 minutes ago
  • Is home confinement with electronic monitoring a deterrent? Are there negatives to being confined to one’s...
    asked 1 hour ago
  • Social hostility can have severe lasting effects of interperpersonal relationship during our adolescence years, which if...
    asked 1 hour ago
  • - A series RLC circuit has R=15 ?, L=1.5 H, and C=15 ?F. (a) For what...
    asked 1 hour ago
  • TV Circuit has 30 large-screen televisions in a warehouse in Erie and 60 large-screen televisions in...
    asked 1 hour ago
  • Charges q1, q2, q3, and q4 are placed in sequential order at the corners of a...
    asked 1 hour ago