Compute the Duration and Convexity. i = 5% and v = (1+i)^-1

n The Duration (Macaulay Duration) of a cash flow is a weighted average of various times of payments with the present value of each cash flow is used as the weight. It is defined as t*vt Rt d t Ri t=1 n n t(t+1)Rtvt+2 t=1 The convexity of a set of cash flows is defined to be c= n Rtut t=1 In the spreadsheet there are a list of payments at certain time intervals. Set up a table that will allow you to compute the above summations and thus compute the duration and the convexity of the cash flow. t Rt 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 290 140 300 190 190 300 240 210 140 230 120 270 260 190 200 210 260 140 160 290 110 290 200 170 260