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

Chapter 19. Working with Bonds > The ODDFPRICE() and ODDLPRICE() Functions

The ODDFPRICE() and ODDLPRICE() Functions

If you're dealing with a bond that has an odd first or last period, as explained earlier, the Analysis ToolPak offers two functions that can calculate the prices: Use ODDFPRICE() to calculate the price for a bond with an odd first coupon period, and use ODDLPRICE() to calculate the price for a bond with an odd last coupon period:

ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])
ODDLPRICE(settlement, maturity, last_coupon, rate, yld, redemption, frequency, [basis])


					  


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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