Question

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]

Answer 1

		CALCULATION OF YTM
	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%
		DURATION OF BOND
		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)
		RESALE PRICE AFTER 4 YEARS
			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