A bondholder owns 15-year government bonds with a $1 million face value and a 6% annual coupon rate that id paid semiannually. The bonds are currently quoted at 110 per $100 par with a asked yield of 5.034%. What is the duration of the bonds?© BrainMass Inc. brainmass.com October 10, 2019, 6:54 am ad1c9bdddf
Using solver in excel, the duration was computed as the number of ...
I did not use a formula to solve. I set this up in Excel and used the "solver" function so that it would do the math.