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

Chapter 19. Working with Bonds > Calculating the Remaining Bond Interest

Calculating the Remaining Bond Interest

If you plan to hold the bond to maturity, you probably want to know how much interest you'll earn over the remaining lifetime of the bond. To figure that, you first need to know how many coupon periods are left on the bond. You can calculate that by using the Analysis ToolPak's COUPNUM() function:

COUPNUM(settlement, maturity, frequency, [basis])


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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