Explore BrainMass

Explore BrainMass

    Duration for Bonds

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    Solution Preview

    Using solver in excel, the duration was computed as the number of ...

    Solution Summary

    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.