Question

a. Several years ago, Castles in the Sand Inc. issued bonds at face value of $1,000 at a yield to maturity of 7.8%. Now, with

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a. To find the bond price, we have to use PV function in EXCEL

=PV(rate,nper,pmt,fv,type)

rate=yield to maturity=15%

nper=maturity period=8

pmt=coupon rate*face value=7.8%*1000=78 (bond is issued at face value, hence yield to maturity=coupon rate=7.8%)

fv=1000

=PV(15%,8,78,1000,0)

PV=$676.91

The bond price=$676.91

b. If they buy the bond today, price of the bond=$676.91.

Face value becomes 90%*face value=90%*1000=900

Yield to maturity needs to be found using RATE function in EXCEL

=RATE(nper,pmt,pv,fv,type)

nper=maturity period=8

pmt=78

pv=$676.91

fv=900

=RATE(8,78,-676.91,900,0)

RATE=14.01%

Yield to maturity=14.01%

Add a comment
Know the answer?
Add Answer to:
a. Several years ago, Castles in the Sand Inc. issued bonds at face value of $1,000...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • a. Several years ago, Castles in the Sand Inc. issued bonds at face value of $1,000 at a yield to maturity of 7%. N...

    a. Several years ago, Castles in the Sand Inc. issued bonds at face value of $1,000 at a yield to maturity of 7%. Now, with 8 years left until the maturity of the bonds, the company has run into hard times and the yield to maturity on the bonds has increased to 15%. What price of the bond now? (Assume semiannual coupon payments.) (Do not round Intermediate calculations. Round your answer to 2 decimal places.) Bond price 5 641,01 b....

  • King a. Several years ago, Castles in the Sand Inc issued bonds at face value of...

    King a. Several years ago, Castles in the Sand Inc issued bonds at face value of $1,000 at a yield to maturity of 56% Now, with 5 years left until the maturity of the bonds, the company has run into hard times and the yield to maturty on is the price of the bond now? (Assume semiannual coupon to 2 decimal places.) Check m (Do not round intermediate calculations. Round your answer Bond price Ces b. Suppose that investors believe...

  • using a finance calculator if possble. no excel 5. Several years ago, Astra-Zeneca issued new bonds...

    using a finance calculator if possble. no excel 5. Several years ago, Astra-Zeneca issued new bonds at face value witha yield- to-maturity of 7%. Now, with 8 years left until the maturity of the bonds, the company has run into some hard times and the rating on their bonds has had a negative impact on their bond prices. The yield-to-maturity is now at 15%. What has happened to the price of the bond? If investors believe that the company will...

  • A firm's bonds have a maturity of 10 years with a $1,000 face value, have an...

    A firm's bonds have a maturity of 10 years with a $1,000 face value, have an 8% semiannual coupon, are callable in 5 years at $1,056.00, and currently sell at a price of $1,107.18. What is their nominal yield to maturity? Do not round intermediate calculations. Round your answer to two decimal places.   % What is their nominal yield to call? Do not round intermediate calculations. Round your answer to two decimal places.   % What return should investors expect to...

  • Consider the following $1,000 par value zero-coupon bonds: Bond Years to Maturity MOA YTM(%) 5.8% 6.8...

    Consider the following $1,000 par value zero-coupon bonds: Bond Years to Maturity MOA YTM(%) 5.8% 6.8 7.3 7.8 According to the expectations hypothesis, what is the market's expectation of the yield curve one year from now? Specifically, what are the expected values of next year's yields on bonds with maturities of (a) one year? (b) two years? (c) three years? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Bond Years to Maturity YTM (%) 1 ID...

  • A 8.6 percent coupon (paid semiannually) bond, with a $1,000 face value and 10 years remaining...

    A 8.6 percent coupon (paid semiannually) bond, with a $1,000 face value and 10 years remaining to maturity. The bond is selling at $915. value: 25.00 points Calculate the yield to maturity on the following bonds. a. A 8.6 percent coupon (paid semiannually) bond, with a $1,000 face value and 10 years remaining to maturity. The bond is selling at $915. (Do not round intermediate calculations. Round your answer to 3 decimal places. (e.g., 32.161)) Yield to maturity % per...

  • A firm's bonds have a maturity of 8 years with a $1,000 face value, have an...

    A firm's bonds have a maturity of 8 years with a $1,000 face value, have an 11% semiannual coupon, are callable in 4 years at $1,152.08, and currently, sell at a price of $1,279.03. What are their nominal yield to maturity and their nominal yield to call? Do not round intermediate calculations. Round your answers to two decimal places. YTM:   % YTC:   % What return should investors expect to earn on these bonds? Investors would not expect the bonds to...

  • A firm's bonds have a maturity of 14 years with a $1,000 face value, have an...

    A firm's bonds have a maturity of 14 years with a $1,000 face value, have an 11% semiannual coupon, are callable in 7 years at $1,238.44, and currently sell at a price of $1,411.89. What are their nominal yield to maturity and their nominal yield to call? Do not round intermediate calculations. Round your answers to two decimal places. YTM:   % YTC:   % What return should investors expect to earn on these bonds? Investors would not expect the bonds to be called...

  • YIELD TO MATURITY A firm's bonds have a maturity of 14 years with a $1,000 face...

    YIELD TO MATURITY A firm's bonds have a maturity of 14 years with a $1,000 face value, have an 11% semiannual coupon, are callable in 7 years at $1,238, and currently sell at a price of $1,407.26. What is their nominal yield to maturity? Do not round intermediate calculations. Round your answer to two decimal places. % What is their nominal yield to call? Do not round intermediate calculations. Round your answer to two decimal places. % What return should...

  • Thatcher Corporation's bonds will mature in 17 years. The bonds have a face value of $1,000...

    Thatcher Corporation's bonds will mature in 17 years. The bonds have a face value of $1,000 and an 11% coupon rate, paid semiannually. The price of the bonds is si,050. The bonds are callable in 5 years at a call price of $1,050. Do not round intermediate calculations. Round your answers to two decimal places. What is their yield to maturity? What is their yield to call? 10.48 | ⓥ % 99%

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
ADVERTISEMENT