Question

****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

Homework Answers

Answer #1

par value of bond 1000

Coupon rate 3.00%

Semi-annual coupon rate = 1.50%

Coupon amount = 1000*3%/2= 15.00

years to maturity= 13

no. of periods = 13*2= 26

YtM rate = 7%

Semi-annual YtM = 3.50%

Price of bond = $662.19

So price of bond is $662.19

Excel function = -PV(3.5%,26,15,1000)

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
****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
A corporation issues a 9 percent coupon bond with 13 years maturity and $1,000 face (par)...
A corporation issues a 9 percent coupon bond with 13 years maturity and $1,000 face (par) value. If the current market price of this bond is $1000, find its yield to maturity. a. 6.43% b. 6.04% c. 9.00% d. 10.07% e. none of the answers is correct
Boeing Corporation has just issued a callable​ (at par)​ three-year, 4.9 % coupon bond with​ semi-annual...
Boeing Corporation has just issued a callable​ (at par)​ three-year, 4.9 % coupon bond with​ semi-annual coupon payments. The bond can be called at par in two years or anytime thereafter on a coupon payment date. It has a price of $ 98.56 a. What is the​ bond's yield to​ maturity? b. What is its yield to​ call? c. What is its yield to​ worst?
1. A 9-year zero coupon bond has a yield to maturity of 11.8 percent, and a...
1. A 9-year zero coupon bond has a yield to maturity of 11.8 percent, and a par value of $1,000.  What is the price of the bond? 2. A 7-year bond has a 8 percent coupon rate with the interest paid in semi annual payments.  The yield to maturity of the bond is 2.3 percent, and a face value of $1,000.  What is the price of the bond? 3. A 12-year bond has a 9 percent annual coupon, a yield to maturity of...
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,...
1) Caribbean Reef Software has 8.4 percent coupon bonds on the market with 9 years to...
1) Caribbean Reef Software has 8.4 percent coupon bonds on the market with 9 years to maturity. The bonds make semiannual payments and currently sell for 95.5 percent of par. What is the YTM? 2) Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1000, and a coupon rate of 7% (annual payments). The yield to maturity on this bond when it was issued was 6%. Assuming the yield to maturity...
1.A 12-year bond has a 9 percent annual coupon, a yield to maturity of 11.4 percent,...
1.A 12-year bond has a 9 percent annual coupon, a yield to maturity of 11.4 percent, and a face value of $1,000. What is the price of the bond? 2.You just purchased a $1,000 par value, 9-year, 7 percent annual coupon bond that pays interest on a semiannual basis. The bond sells for $920. What is the bond’s nominal yield to maturity? a.         7.28% b.         8.28% c.         9.60% d.         8.67% e.         4.13% f.          None of the above 3.A bond with...
A 5 percent coupon bond has 20 years left to maturity and has a price quote...
A 5 percent coupon bond has 20 years left to maturity and has a price quote of 95 (quoted bond price is $950). The bond can be called in five years and if called would generate a yield to call of 8 percent. Compute the bond's current yield, yield to maturity and call price. (Assume interest payments are paid semi-annually and a par value of $1,000.)
A 5 percent coupon bond has 20 years left to maturity and has a price quote...
A 5 percent coupon bond has 20 years left to maturity and has a price quote of 95 (quoted bond price is $950). The bond can be called in five years and if called would generate a yield to call of 8 percent. Compute the bond's current yield, yield to maturity and call price. (Assume interest payments are paid semi-annually and a par value of $1,000.)