directions: please provide the google link to your completed excel spreadsheet of the duration. Do not send a photo attachment of the solutions.

attach your excel file here

DURATION CALCULATE THE DURATIONS OF THE FOLLOWING 10-YEAR BONDS: 1) 25% coupon yield 3.259) 2) 1200% coupon yield 12.00%) 3) coupon yield 3255) which of the three has the highest duration? Why? coupon 3.25% yield 125% Cash Flow (5) discount fedor ime 2 3 4 5 0 7 B 0.00 10 11 12 13 14 SS 16 17 18 19 20 PV prosent value (5) Tumyrs) PVXT 0.00 0.50 0.00 1.00 0.00 150 0.00 200 000 250 3.00 0.00 3.50 0.00 4.00 0.00 4.50 0.00 5.00 0.00 5.00 0.00 0.00 0.00 0.50 0.00 7.00 0.00 7:50 0.00 8.00 0.00 B 50 0.00 0.00 0.00 50 000 10.00 0.00 10413 0.00 0.00 HOVIOI years 0 DURATION CALCULATE THE DURATIONS OF THE FOLLOWING 10-YEAR BONDS: 1) 25% coupon yield 3.259) 2) 1200% coupon yield 12.00%) 3) coupon yield 3255) which of the three has the highest duration? Why? coupon 3.25% yield 125% Cash Flow (5) discount fedor ime 2 3 4 5 0 7 B 0.00 10 11 12 13 14 SS 16 17 18 19 20 PV prosent value (5) Tumyrs) PVXT 0.00 0.50 0.00 1.00 0.00 150 0.00 200 000 250 3.00 0.00 3.50 0.00 4.00 0.00 4.50 0.00 5.00 0.00 5.00 0.00 0.00 0.00 0.50 0.00 7.00 0.00 7:50 0.00 8.00 0.00 B 50 0.00 0.00 0.00 50 000 10.00 0.00 10413 0.00 0.00 HOVIOI years 0