Use Excel or your FIN calculator to do the following exercise. It will be rather time consuming if you use the formulas in the text.

(a) In the Table below is a bond with Coupon = YTM initially (columns 1 and 3). Then, in Col 2, I am increasing the time to maturity. Calculate the Duration for each maturity and report them in Col 4. Assume annual coupon cash flows, i.e., this is an annual bond (not semiannual).

Col 1	Col 2	Col 3	Col 4
CPN%	MATURITY	YTM%	DUR
11.75	3	11.75
11.75	7	11.75
11.75	10	11.75
11.75	20	11.75
11.75	30	11.75

(b) Next, I have reduced YTM to 6.75% (in Col 3). For the same maturities, now calculate the durations and report in Col 4. Once you have done that answer the following questions:

Col 1	Col 2	Col 3	Col 4
CPN%	MATURITY	YTM%	DUR
11.75	3	6.75
11.75	7	6.75
11.75	10	6.75
11.75	20	6.75
11.75	30	6.75

(c) What do you conclude about the relationship between duration and time to maturity based on part (a) Col 4 results? Examine the change in time relative to change in duration and discuss that in your answer.

(d) What do you conclude about duration when comparing part (a) Col 4 to part (b) Col 4 results?