top of page
Search


MS Excel: ODDFPRICE to calculate the bond price
ODDFPRICE stands for "Odd First Period Price". It calculates the price of a bond when the first period of the bond is shorter or longer than a regular period.
In simple words: If a bond doesn’t start on a perfect schedule (like exactly every 6 months or 1 year), ODDFPRICE helps you figure out what it’s really worth today.
✅ Regular bonds ➔ Use PRICE
✅ Bonds with "weird" first periods ➔ Use ODDFPRICE
Real-world bonds don't always fit neatly into textbook schedules!

Fakhriddinbek
Apr 283 min read
bottom of page