lzhao Wrote:
——————————————————-
> How to calculate it, say for 20-year T-bond, 8%
> coupon, priced at 114?
>
> Thx!
First calculate YTM of the bond using IRR function. Then choose a delta (for example, 20 bp = 0.2%), calculate bond price (as PV) for yield = YTM - delta, YTM+delta and calculate duration as (PV(YTM-delta)-PV(YTM+delta)/(2*delta*PV(YTM)). Obviously, PV(YTM)=114.