Question

ABC HAS A BOND WITH A 10-YEAR MATURITY, SEMI ANNUAL COUPON OF 8% HAS A PRICE...

ABC HAS A BOND WITH A 10-YEAR MATURITY, SEMI ANNUAL COUPON OF 8% HAS A PRICE OF 933.00 WHAT IS YTM ON THIS BOND? **PLEASE USE EXCEL**

Homework Answers

Answer #1
                  K = Nx2
Bond Price =∑ [(Semi Annual Coupon)/(1 + YTM/2)^k]     +   Par value/(1 + YTM/2)^Nx2
                   k=1
                  K =10x2
933 =∑ [(8*1000/200)/(1 + YTM/200)^k]     +   1000/(1 + YTM/200)^10x2
                   k=1
YTM% = 9.03

=RATE(10*2,8*1000/(2*100),-933,1000,,)*2

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
On the issue date, you bought a 30-year maturity, 8% semi-annual coupon bond. The bond then...
On the issue date, you bought a 30-year maturity, 8% semi-annual coupon bond. The bond then sold at YTM of 7%. Now, five years later, the similar bond sells at YTM of 6%. If you hold the bond now, what is your realized rate of return for the 5-year holding period? (do not solve using excel)
AbC Corporations (ABC) issues a bond that pays 10% semi-annual coupon, have a $1,000 face value,...
AbC Corporations (ABC) issues a bond that pays 10% semi-annual coupon, have a $1,000 face value, and mature in 10 years. If ABC bonds are sold to yield 8%, what is the price of ABC bond at the end of year 2. If ABC issue the same bond (same coupon rate, face value and maturity) with ‘callable’ feature, would the price of ABC bond be lower or higher? Explain.
Price the following: 12-year, $1000 par value, 6% semi-annual coupon bond whose current nominal yield-to-maturity (YTM)...
Price the following: 12-year, $1000 par value, 6% semi-annual coupon bond whose current nominal yield-to-maturity (YTM) is 8%. 10-year, $1000 par value, 8% quarterly coupon bond whose current nominal YTM is 7%. 30-year, $1000 par value, zero-coupon bond whose current nominal YTM is 9.5%. 13-year, $1000 par value, 8% monthly coupon bond whose current nominal YTM is 10%. 5-year, $500 par value, 8% semi-annual coupon bond whose current nominal YTM is 8.25%
Suppose that a 9% semi-annual coupon bond with a time to maturity of 10 years and...
Suppose that a 9% semi-annual coupon bond with a time to maturity of 10 years and a par value of $100 has a price of $107,5. This bond is first callable in 7 years at a redemption price of $105,5. What is the yield to maturity for this bond? What is the yield to first call for this bond? You will need to use Excel for this problem
a 10-year bond, $1,000 face value bond with a 8% coupon rate and semi-annual coupons has...
a 10-year bond, $1,000 face value bond with a 8% coupon rate and semi-annual coupons has a yield to maturity of 12%. the bond should be trading at the price of? round to nearest cent
A bond pays a 5% coupon and makes semi-annual payments. The bond has 10 years to...
A bond pays a 5% coupon and makes semi-annual payments. The bond has 10 years to maturity and a YTM of 6%. What is the current bond price?
#10 A $1,000 par bond with a 8% semi-annual coupon trades at a price of $1,288....
#10 A $1,000 par bond with a 8% semi-annual coupon trades at a price of $1,288. If the bond has 10 years to maturity, what is the yield to maturity? A. 5.58% B. 4.41% C. 8.9% D. 4.38%
Stealers Wheel Software has 8 percent coupon bond on the market with 10 years to maturity,...
Stealers Wheel Software has 8 percent coupon bond on the market with 10 years to maturity, and the par value of $1,000. The bonds make semi-annual coupon payments and currently sell for $980. What is the YTM? If the bond with the same maturity and similar risk pays 6% annual coupon (pays semi-annually), what should be the market price of the second bond?
Calculate the price of a 3.5 percent coupon bond, with 3.5 years to maturity, and semi-annual...
Calculate the price of a 3.5 percent coupon bond, with 3.5 years to maturity, and semi-annual payments. Zero-coupon spot (strip) rates are as follows. YTM on a zero coupon security is a nominal annual rate with semi-annual compounding. Maturity YTM 6 months 1.20% per year 12 months 1.30% 18 months 1.40% 24 months 1.50% 30 months 1.50% 36 months 1.70% 42 months 1.90% a. Calculate the price of this bond. b. What is the yield to maturity of this coupon...
16. A 10-year bond, $100 face value bond with a 8% coupon rate and semi-annual coupons...
16. A 10-year bond, $100 face value bond with a 8% coupon rate and semi-annual coupons has a yield maturity of 5%. The bond should be trading at a price of $.___ Round to the nearest cent. 17. XYZ company has just issued a 30-year bond with a coupon rate of %7.5 (annual coupon payments) and a face value of $1,00. If the yield to maturity is 11%, what is the price of the bond. Round to the nearest cent....