Payments are semi-annual, the day count basis is US 30/360, and the redemption value is $100.
Entering dates
In Excel,dates are serial numbers.
To enter valid dates directly inside a function, theDATE functionis the best option.
To illustrate, the formula below has all values hardcoded.
The ODDLPRICE function allows 5 options (0-4) and defaults to zero, which specifies US 30/360basis.
Thisarticle on Wikipediaprovides a detailed explanation of available conventions.
