Question

. Example: . Suppose a firm issued a 9% coupon bond (semiannual coupon) 20 years ago. The bond n ow has 10 years left until i

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

With expected final payment of $750, using the RATE function of Excel,

Expected YTM=11.630275% (Annual) or 5.815138% Semiannual as follows:

Align Clipboard Font fRATE(C7,C8,C9*-1,C2) C10 A В С Formula Values 1 2 Final Payment $700 Given 3 Coupon rate (R) 4 Interest

Stated YTM=13.656904% (Annual) or 6.628452% Semiannual as follows:

Clipboard Font Alic fiRATE(C7,C8, C9*-1, C2) C10 A B Formula Values 1 $1,000 2 Final Payment Given 3 Coupon rate (R) 9% Given

Expecting final payment of 55% only and required YTM (Annual) of 12%, Price of the bond, using PV function of Excel is $687.64 as follows:

clipboard Font Alignm fPV(C7,C5,C6, C2) C8 A. C Formula Values 2 Final Payment (FV) 3 Coupon rate (R) 4 Time to maturity (no.

As the Face Value is $1,000 using RATE function of Excel, stated YTM =15.166977% (Annual) or 7.583489% (Semiannual) as given below:

fixRATE(C5,C6, C7*-1, C2) С8 A Formula Values 1 $1,000 2 Final Payment (FV) Given 3 Coupon rate (R) 9% Given 4 Time to maturi

Add a comment
Know the answer?
Add Answer to:
. Example: . Suppose a firm issued a 9% coupon bond (semiannual coupon) 20 years ago....
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
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