HomeworkLib
Question

​(Bond valuation​) National​ Steel's 20​-year, ​$1,000 par value bonds pay 12 percent interest annually. The market...

​(Bond valuation​) National​ Steel's 20​-year, ​$1,000 par value bonds pay 12 percent interest annually. The market price of the bonds is

​$1 200​, and your required rate of return is11 percent.

a. Compute the​ bond's expected rate of return.

b. Determine the value of the bond to​ you, given your required rate of return.

c. Should you purchase the​ bond?

(What function is used to calculate in excel??)))

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

a. Par Value =1000
Number of Years =20
Coupon =12%*1000 =120
Price of Bond =1200
a. Bond's Expected Return using Excel Function=RATE(20,120,-1200,1000) =9.70%

b. Price of Bond at 11% using excel function =PV(11%,20,-120,-1000) =1079.63


c. No the bond should not be bought because YTM is less than required rate

0 0
Add a comment
Know the answer?
Add Answer to:
​(Bond valuation​) National​ Steel's 20​-year, ​$1,000 par value bonds pay 12 percent interest annually. The market...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  •  ​(Bond valuation) ​Fingen's 15​-year, ​$1,000 par value bonds pay 9 percent interest annually. The market price...

     ​(Bond valuation) ​Fingen's 15​-year, ​$1,000 par value bonds pay 9 percent interest annually. The market price of the bonds is ​$930 and the​ market's required yield to maturity on a​ comparable-risk bond is 8 percent. a.  Compute the​ bond's yield to maturity. b.  Determine the value of the bond to​ you, given your required rate of return. c.  Should you purchase the​ bond?

  • (Bond valuation)  ​Fingen's 14​-year, $1,000 par value bonds pay 8 percent interest annually. The market price...

    (Bond valuation)  ​Fingen's 14​-year, $1,000 par value bonds pay 8 percent interest annually. The market price of the bonds is ​$1,130 and the​ market's required yield to maturity on a​ comparable-risk bond is 5 percent. a.  Compute the​ bond's yield to maturity. b.  Determine the value of the bond to​ you, given your required rate of return. c.  Should you purchase the​ bond? round to two decimal places.

  • Fingen's 14​-year, ​$1,000 par value bonds pay 12 percent interest annually. The market price of the...

    Fingen's 14​-year, ​$1,000 par value bonds pay 12 percent interest annually. The market price of the bonds is ​$1,130 and the​ market's required yield to maturity on a​ comparable-risk bond is 9 percent. a.  Compute the​ bond's yield to maturity. b.  Determine the value of the bond to​ you, given your required rate of return. c.  Should you purchase the​ bond?

  •  ​Fingen's 15​-year, ​$1,000 par value bonds pay 13 percent interest annually. The market price of the...

     ​Fingen's 15​-year, ​$1,000 par value bonds pay 13 percent interest annually. The market price of the bonds is ​$890 and the​ market's required yield to maturity on a​ comparable-risk bond is 16 percent. a.  Compute the​ bond's yield to maturity. b.  Determine the value of the bond to​ you, given your required rate of return. c.  Should you purchase the​ bond?

  • (Bond valuation) You own a 10-year, $1,000 par value bond paying 8 percent interest annually. The...

    (Bond valuation) You own a 10-year, $1,000 par value bond paying 8 percent interest annually. The market price of the bond is $900, and your required rate of return is 11 percent. a. Compute the bond's expected rate of return. b. Determine the value of the bond to you, given your required rate of return c. Should you sell the bond or continue to own it? a. What is the expected rate of return of the 10-year, $1,000 par value...

  • 1. Barasa Trading company has a 20-year, $1,000 par value bonds that pay 6 percent interest...

    1. Barasa Trading company has a 20-year, $1,000 par value bonds that pay 6 percent interest annually. The market price of the bonds is $1,200, and your required rate of return is 8 percent. Required: a. Compute the bond's expected rate of return. b. Determine the value of the bond to you given your required rate of return. c. Should you purchase the bond? d. Without doing any computations, if interest was paid semi-annually, would you buy the bond or...

  • The 15-year, $1,000 par value bonds of Waco Industries pay 11 percent interest annually

    (Related to Checkpoint 9.2 and Checkpoint 9.3) (Bond valuation relationships) The 15-year, $1,000 par value bonds of Waco Industries pay 11 percent interest annually. The market price of the bond is $1,145, and the market's required yield to maturity on a comparable-risk bond is 8 percent. a. Compute the bond's yield to maturity. b. Determine the value of the bond to you given the market's required yield to maturity on a comparable-risk bond. c. Should you purchase the bond? a. What is your yield to...

  • (Bond valuation) You own a 15-year $1.000 par value bond paying 7.5 percent interest annually. The...

    (Bond valuation) You own a 15-year $1.000 par value bond paying 7.5 percent interest annually. The market price of the bord is $825, and your required rate of return is 11 percent a. Compute the bond's expected rate of return b. Determine the value of the bond to you, given your required rate of return c. Should you sell the bond or continue to own it? a. What is the expected rate of return of the 15-year, $1,000 par value...

  • The 16-year, $1,000 par value bonds of Waco Industries pay 7 percent interest annually. The market...

    The 16-year, $1,000 par value bonds of Waco Industries pay 7 percent interest annually. The market price of the bond is $875, and the market's required yield to maturity on a comparable -risk bond is 10 percent. a. Compute the bond's yield to maturity. b. Determine the value of the bond to you given the market's required yield to maturity on a comparable-risk bond. c. Should you purchase the bond?.

  • ( Bond Valuation) You own a 20-year, $1,000 par value bond paying 6 percent interest annually....

    ( Bond Valuation) You own a 20-year, $1,000 par value bond paying 6 percent interest annually. The market price of the bond is $750, and your required rate of return is 10 percent. 1) What is the value of the bond to you, given your 10 percent required rate of return?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT