In: Finance
You are considering buying a 10-year U.S. Treasury bond at the upcoming Treasury auction. Assume that the bond has the following features: coupon rate: 2.27%, with semi-annual coupon payments Face value: $1,000 matures in 10 years In the auction, the annual yield to maturity determined by the auction is 2.92%. What is the price that you will pay for this bond? Do not round at intermediate steps in your calculation. Round your answer to the nearest penny. Do NOT include a minus sign! Do not type the $ symbol.
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.
Bond Price Today:
Period | Cash Flow | PVF/ PVAF @1.46 % | Disc CF |
1 - 20 | $ 11.35 | 17.2365 | $ 195.63 |
20 | $ 1,000.00 | 0.7483 | $ 748.35 |
Bond Price | $ 943.98 |
As Coupon Payments are paid periodically with regular intervals,
PVAF is used.
Maturity Value is single payment. Hence PVF is used.
Periodic Cash Flow = Annual Coupon Amount / No. times coupon
paid in a year
Disc Rate Used = Disc rate per anum / No. of times coupon paid in a
Year
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