Question

Using calculating formula Credit Rating Yield AAA 3% AA 3.2% A 3.5% BBB 3.8% BB 4.5%...

Using calculating formula

Credit Rating Yield

AAA 3%

AA 3.2%

A 3.5%

BBB 3.8%

BB 4.5%

B 5.25%

a. Given the yields for bonds with different credit ratings, what would be the fair price of a 5-year maturity bond, which currently has identical risk to a bond rated ‘A’, if it has a coupon rate of 12% paid annually, and a par value of $1,000?

b. What would be the price of the bond 3 years from today if the bond is expected to be downgraded to ‘BBB’ at the end of the 3rd year?

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

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

File Home Page Layout FormulasData Review View dd-Ins Define Name PUse in Formula Trace Precedents t Trace Dependents Remove Arrows Show Formulas Calculate Now - 曙 ◆ Error Checking Insert Autosum Recently Financial Logical Tet Date & Lookup & Math More Function Watch Calculation Calculate Sheet wndow Name ? Create from Selection Defined Names Used Time Reterence &Tnig Functions Manager | Evaluate Formula options . Function Library Formula Auditing Calculation EL56 EJ EK EL EM EN EO EP 45 46 47 48 49 a 50 51 b 52 53 54 YEARS COUPON RATE PAR VALUE YTM FAIR PRICE 12% 1000 3.50% A RATING 1,383.78 EXCEL PV(EL48,EL45,-EL46*EL47,-EL47) YEARS YTM FAIR PRICE 3.80% BBB RATING $1,155.10 EXCEL PV(EL52,EL51,-EL46 EL47,-1000) 56 57 58 59 60 61 62 /4 YIELD SPOT Sheet2 AFN BANKING NOTE BIDDING, UNDERWRITING EUAC AwPM LIFE LP IP MRP, INFLATION YIELD WARRANT fund bond- CLEAN INVOICE PRICE 福 130% 11:20 31-01-2019

Add a comment
Know the answer?
Add Answer to:
Using calculating formula Credit Rating Yield AAA 3% AA 3.2% A 3.5% BBB 3.8% BB 4.5%...
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