top of page
Search


MS Excel: ODDLPRICE function when the last period is irregular
ODDLPRICE stands for "Odd Last Period Price".It calculates the price per $100 face value of a bond when the last period is irregular — that is, the final payment doesn’t align perfectly with a normal coupon schedule.
In plain English:If a bond’s final interest payment happens earlier or later than expected, ODDLPRICE gives you the correct bond price.

Fakhriddinbek
Apr 283 min read
bottom of page