• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Working with Bonds > Working with Coupon Dates

Working with Coupon Dates

If you want to calculate values such as the number of days since the last coupon payment or the number of days until the next payment, you can always use Excel's data functions. However, the Analysis ToolPak also offers a few functions designed specifically to work with coupon dates:

  • COUPDAYS()— Returns the number of days in the coupon period that includes the settlement date

  • COUPPCD()— Returns the date of the most recent coupon payment

  • COUPDAYBS()— Returns the number of days from the most recent coupon payment to the settlement date

  • COUPNCD()— Returns the date of the next coupon payment

  • COUPDAYSNC()— Returns the number of days from the settlement date to the next coupon payment


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint