ODDFPRICE Function

Returns the price of a bond with an odd (short or long) first coupon period.

Category

Financial

Available in

All versions, Microsoft 365

Returns

A price per $100 face value

Want to practice ODDFPRICE in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

New bonds often have a first coupon period that isn't a normal length — the issue date doesn't line up with the coupon schedule. ODDFPRICE prices them correctly, where PRICE would assume a regular first period.

Prices are quoted per $100 of face value, so 95.10 means you pay $951 for a $1,000 bond.

Syntax

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

Arguments

ArgumentRequired?What it does
settlementYesThe date the buyer takes ownership (after the issue date).
maturityYesThe date the security is repaid.
issueYesThe date the security was first issued.
first_couponYesThe first coupon date.
rateYesThe annual coupon rate.
yldYesThe annual yield.
redemptionYesThe value paid at maturity per $100 of face value (usually 100).
frequencyYesCoupon payments per year: 1 = annual, 2 = semiannual, 4 = quarterly.
basisNoDay count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.

Examples

Example 1 — A new issue with a long first coupon

A 5.5% bond issued 2/1/2026, first coupon 12/1/2026 (a 10-month first period), maturing 6/1/2034. Northstar buys on 3/15/2026 at a 5.8% yield.

B10fx=ODDFPRICE(B1,B2,B3,B4,B5,B6,B7,B8,B9)
AB
1Settlement3/15/2026
2Maturity6/1/2034
3Issue2/1/2026
4First coupon12/1/2026
5Rate5.5%
6Yield5.8%
7Redemption100
8Frequency2
9Basis0
10Price98.01

Common mistakes

  • #NUM! error. The dates must run issue < settlement < first coupon < maturity.

Notes

  • Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
  • Related functions: ODDFYIELD, ODDLPRICE, PRICE.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.