Homework Help Question & Answers

Consider a bond with market value $92.37 (face value = $100) and a coupon of $5.059 dollars paid ...

Consider a bond with market value $92.37 (face value = $100) and a coupon of $5.059 dollars paid every six months (Semi-annually - December and June). The time to maturity is 10 semiannual periods. Assume today is January 1st, 2015. Therefore, the face value of the bond will be repaid on December 2019.

Upload your spreadsheet on the course website (you might want to use the spreadsheet “11 Bond Yield and Duration Example” that we analyzed in class as a starting point for your calculations) and provide the answers to the following questions on paper.

  1. Compute the annual YTM of the bond, using Excel Solver (note: the question asks for the annual YTM, not the semiannual. If you compute the semiannual YTM, you must compound it using the effective annual rate formula). [1.25 points]
  2. Compute the duration of the bond. Please say clearly what unit you are using, e.g. duration is N years or duration is N semiannual periods. [1 point]
  3. Four years from now, if the YTM remains constant, what will be the resale price of the bond? (HINT: since time to maturity is now 10 semiannual periods, the bond will have a time to maturity of two semiannual periods, four years from now; the cash-flow that you must consider to compute the price are two coupon payments, and the face value repaid at maturity). [1.25 points]
  4. If the reinvestment rate is equal to the YTM, what is the terminal value of the portfolio after 4 years? (HINT: the terminal value of the portfolio is the sum of the coupons reinvest at the reinvestment rate, plus the revenues from selling the bond 4 years from now) [1.25 points]
  5. If the reinvestment rate is now 5% (semiannual), what is the terminal value of the portfolio after 4 years? Why is it almost the same as your previous answer? Why isn’t it exactly the same as your previous answer? (HINT: the change in the reinvestment rate affects both the value of the reinvest coupons, and the resale price of the bond). [1.25 points]
0 0
ReportAnswer #1
Pv Current Market Value $92.37
Nper Number of semi annual period to maturity                 10
Pmt Semi annual coupon payment $5.059
Fv Redemption payment at end of 10 periods $100
RATE Semi annual Yield to maturity 6.10% (Using RATE function of excel with Nper=10,Pmt=5.059,Pv=-92.37,Fv=100)
Annual YTM =((1+0.0610)^2)-1 0.125721
Annual YTM in percentage 12.5721%
N A B=A/(1.125721^N) C=A*N D=C/(1.125721^N)
Annual Period Cash Flow Present Value Cash flow* PV of (cash
(PV)of Cash flow Period flow*Period)
0.5 $5.059 4.768 $2.530 2.384
1.0 $5.059 4.494 $5.059 4.494
1.5 $5.059 4.236 $7.589 6.353
2.0 $5.059 3.992 $10.118 7.984
2.5 $5.059 3.763 $12.648 9.406
3.0 $5.059 3.546 $15.177 10.639
3.5 $5.059 3.342 $17.707 11.698
4.0 $5.059 3.150 $20.236 12.601
4.5 $5.059 2.969 $22.766 13.361
Cashflow= (100+5.059) 5.0 $105.059 58.114 $525.295 290.569
SUM 92.37 369.49
l Bond Duration in years 3.999926 (369.49/92.37)
CF PV=CF/(1.125721^N)
Annual Period after 4 years Cash flow PV of cash Flow
0.5 $5.059 4.768
Cashflow= (100+5.059) 1 $105.059 93.326
SUM 98.09
Resale Price After 4 years $98.09

TERMINAL VALUE AT REINVESTMENT RATE-YTM Future Value(FV) of Cash Flow after 4 years (Cash Flow) ((1)A(4-N)) i-Interest rate 0TERMINAL VALUE AT REINVESTMENT RATE-5% 4 years-8semiannual period BA (1.05 (8-N) Cash flow FV of Cash flow Semi annual period
Add Homework Help Answer
Add Answer of:
Consider a bond with market value $92.37 (face value = $100) and a coupon of $5.059 dollars paid ...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
More Homework Help Questions Additional questions in this topic.
Need Online Homework Help?
Ask a Question
Related Questions