ExcelFlux

ODDFPRICE function

the price per $100 face value of a security with an odd first period.

Financial · Guided Excel example

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Compare clean prices at three yields for a bond with an irregular first coupon. Check that price falls as yield rises.

A worked example from the workbook

RowA
6Input
70.04
80.05
90.06
Record 1
=ODDFPRICE(DATE(2026,1,1),DATE(2027,1,1),DATE(2025,12,1),DATE(2026,7,1),0.05,A7,100,2,0)

Illustrative outputClean price

See the inputs and instructions for all 3 examples

Worked examples

Compare clean prices at three yields for a bond with an irregular first coupon. Check that price falls as yield rises.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 0.04
8 0.05
9 0.06
Trial Expression Sample output
Record 1 =ODDFPRICE(DATE(2026,1,1),DATE(2027,1,1),DATE(2025,12,1),DATE(2026,7,1),0.05,A7,100,2,0) Clean price
Record 2 =ODDFPRICE(DATE(2026,1,1),DATE(2027,1,1),DATE(2025,12,1),DATE(2026,7,1),0.05,A8,100,2,0) Clean price
Record 3 =ODDFPRICE(DATE(2026,1,1),DATE(2027,1,1),DATE(2025,12,1),DATE(2026,7,1),0.05,A9,100,2,0) Clean price
Microsoft Excel reference