Your colleague is constructing a table to calculate the duration of 5 yearannualcoupon paying bonds issued by American Expresso at an effective annual yield of4% pa. The bonds have a face value of $100,000 and an effective annual coupon rate of11% pa. Unfortunately your colleague is unwell and has taken the day off work. You have been asked to complete the calculations to present at a meeting.

a)Complete the table for your colleague. Give your answers to 4 decimal places.

(table in picture)