You are considering a ten year bond with floating rate adjustable once a year at the end of each year. This means that the fixed rate period is one year.

The bond pays 10% coupon ($50 coupon semiannually). The bond will pay two CFs in each one-year fixed rate period: one coupon 6 months from now and then the next coupon one year from now.

Assume the yield to maturity of this bond today is 12% and that today is the beginning of the year. Use the average time method to calculate the Maculay Duration for this floating rate bond (average time to receive CF during the one year fixed rate period). May use Excel.