In our spreadsheets, notice that we had to enter two dates, a settlement date and a maturity date. The settlement date is just the date you actually pay for the bond, and the maturity date is the day the bond actually matures. In most of our problems, we don't explicitly have these dates, so we have to make them up. For example, since our bond has 22 years to maturity, we just picked 1/1/2000 (January 1,2000) as the settlement date and 1/1/2022 (January 1, 2022) as the maturity date. Any two dates would do as long as they are exactly 22 years apart, but these are particularly easy to work with. Finally, notice that we had to enter the coupon rate and yield to maturity in annual terms and then explicitly provide the number of coupon payments per year.

0 0

Post a comment