Question

Bond X is noncallable and has 20 years to maturity, an 8% annual coupon, and a $1,000 par value. Your required return on Bond X is 9%; if you buy it, you plan to hold it for 5 years. You (and the market) have expectations that in 5 years, the yield to maturity on a 15-year bond with similar risk will be 6.5%. How much should you be willing to pay for Bond X today? (Hint: You will need to know how much the bond will be worth at the end of 5 years.) Do not round intermediate calculations. Round your answer to the nearest cent.

Answer 1

Value of Bond after 5 Years = PV of Future CFs from it.

Bond Price:
It refers to the sum of the present values of all likely coupon payments plus the present value of the par value at maturity. There is inverse relation between Bond price and YTM ( Discount rate ) and Direct relation between Cash flow ( Coupon/ maturity Value ) and bond Price.

Price of Bond = PV of CFs from it.

Year	Cash Flow	PVF/ PVAF @6.5 %	Disc CF
1 - 15	$      80.00	9.4027	$    752.21
15	$ 1,000.00	0.3888	$    388.83
Bond Price			$ 1,141.04

As Coupon Payments are paid periodically with regular intervals, PVAF is used.
Maturity Value is single payment. Hence PVF is used.

What is PVAF & PVF ???
PVAF = Sum [ PVF(r%, n) ]
PVF = 1 / ( 1 + r)^n
Where r is int rate per Anum
Where n is No. of Years

How to Calculate PVAF using Excel ???
+PV(Rate,NPER,-1)
Rate = Disc rate
Nper = No. of Periods

Price Today:

Year	Cash Flow	PVF/ PVAF @9 %	Disc CF
1 - 5	$      80.00	3.8897	$    311.17
5	$ 1,141.04	0.6499	$    741.60
Bond Price			$ 1,052.77

As Coupon Payments are paid periodically with regular intervals, PVAF is used.
Maturity Value is single payment. Hence PVF is used.

What is PVAF & PVF ???
PVAF = Sum [ PVF(r%, n) ]
PVF = 1 / ( 1 + r)^n
Where r is int rate per Anum
Where n is No. of Years

How to Calculate PVAF using Excel ???
+PV(Rate,NPER,-1)
Rate = Disc rate
Nper = No. of Periods