Question

Bond Spreadsheet

You initiated a transaction to purchase a 4.000% coupon 30-year corporate bond on Friday  8/30/2019.  The maturity date of the bond is 3/25/2031 and its yield to maturity is 3.774%.   Please answer the following questions about this bond.  (Note: you can check your work in parts (f), (g) and (h) using the BOND spreadsheet in your calculator, but I want to see the equations setup and worked through in those parts for full credit.)

(a)  What are the two dates every year on which the bond pays its coupons.

(b)  On what date was the last (previous) coupon paid?

(c)  What is the settlement date (SDT) for this bond? (Remember the Labor Day holiday!)

(d)  How many days are there in the current coupon period?

(e)  How many days between the last coupon and the SDT?

 (f)  What is the full price of the bond on the SDT?  Draw a timeline for just the current coupon period (like we did in class) and calculate the bond’s full price using “Method 2” in the handout, which is the method used in the text and slides).   

(g)  What is the accrued interest on the SDT?

(h)  What is the clean price of the bond on the SDT?


0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 9 more requests to produce the answer.

1 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Bond Spreadsheet
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Bond Spreadsheet

    5. (6 pts)  You initiated a transaction to purchase a 4.000% coupon 30-year corporate bond on Friday  8/30/2019.  The maturity date of the bond is 3/25/2031 and its yield to maturity is 3.774%.   Please answer the following questions about this bond.  (Note: you can check your work in parts (f), (g) and (h) using the BOND spreadsheet in your calculator, but I want to see the equations setup and worked through in those parts for full credit.)(a)  What are the two dates every year on which...

  • Bond Spreadsheet

    3. You initiated a transaction to purchase a 2.875% coupon 10-year U.S. Treasury Note on Wednesday 9/6/2018.  The maturity date of the note is 5/15/2026 and its yield to maturity is 2.950%.   Please answer the following questions about this note.  (Note: you can check your work in parts (f), (g) and (h) using the BOND spreadsheet in your calculator, but I want to see the equations setup and worked through in those parts for full credit.)(a)  What are the two dates every year on...

  • Bond Calculations

    12. (6 pts)  An 8.000% semi-annual coupon corporate bond that matures on 3/15/25, is purchased for settlement on 4/15/21.  The yield to maturity is 6.333% quoted on a street convention semiannual bond basis (APR2).  Accrued interest is calculated using the 30/360 day count convention.  (a)  What is the flat (clean) price of the bond on the SDT?  (use the BA II Plus BOND spreadsheet)(b)  What is the accrued interest on the SDT? (use the BA II Plus BOND spreadsheet)(c)  How many days are there (“T”) in the current...

  • A bond was purchased on March 20, 2009 and the quoted bond price was $1075. The...

    A bond was purchased on March 20, 2009 and the quoted bond price was $1075. The previous coupon date was January 1, 2009. The next coupon date is January 1, 2010. The bond will mature on January 1, 2018. The bond’s annual coupon rate is 10% and the face value of the bond is $1,000. Coupons will be paid annually. Compute the bond’s yield to maturity on an accrued interest payment basis.

  • A bond was purchased on March 20, 2009 and the quoted bond price was $1075. The...

    A bond was purchased on March 20, 2009 and the quoted bond price was $1075. The previous coupon date was January 1, 2009. The next coupon date is January 1, 2010. The bond will mature on January 1, 2018. The bond’s annual coupon rate is 10% and the face value of the bond is $1,000. Coupons will be paid annually. a. Compute the bond’s yield to maturity on an accrued interest payment basis. PLEASE USE EXCEL

  • The spreadsheet shows you how to calculate invoice price for 6-year maturity bond with a coupon r...

    The spreadsheet shows you how to calculate invoice price for 6-year maturity bond with a coupon rate of 2.25% (paid semiannually). The market interest rate given is 7.9%. Now, please modify the spreadsheet and calculate invoice price of bond with 6.25% coupon (paid semiannually), settlement date July 31,2012, maturity date May 15, 2030, YTM 7.9%.                                                 2.25% coupon bond,                                                     maturing July 31, 2018                 Formula in column B                         Settlement date                                     7/31/2012                     =DATE(2012,7,31) Maturity date                                        7/31/2018                     =DATE(2018,7,31) Annual coupon rate                               0.0225 Yield to...

  • 1) Consider a 10-year bond trading at $1150 today. The bond has a face value of...

    1) Consider a 10-year bond trading at $1150 today. The bond has a face value of $1,000, and has a coupon rate of 8%. Coupons are paid semiannually, and the next coupon payment is exactly 6 months from now. What is the bond's yield to maturity? 2)A coupon-paying bond is trading below par. How does the bond's YTM compare to its coupon rate? a. Need more info b. YTM = Coupon Rate c. YTM > Coupon Rate d. YTM <...

  • 8. You buy an eight-year bond that has a 6% current yield and a 6% coupon...

    8. You buy an eight-year bond that has a 6% current yield and a 6% coupon rate (coupons will be paid annually). The face value is $1000. In one year, the yield-to-maturity of this bond has dropped to 5%. What is the bond’s holding-period return? ____%

  • Suppose a five-year, $1000 bond with annual coupons has a price of $900 and a yield...

    Suppose a five-year, $1000 bond with annual coupons has a price of $900 and a yield to maturity of 6%. What is the bond’s coupon rate?

  • Consider a 5-year bond with a face value of 100 USD/bond that pays coupons every six...

    Consider a 5-year bond with a face value of 100 USD/bond that pays coupons every six months. It has a yield to maturity of 4.0400% and an annual coupon rate of 4.0000%. What is the bond’s price if there are no arbitrage opportunities? (Input your answer with 4 decimals)

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