ExcelFlux

ODDLPRICE function

the price per $100 face value of a security with an odd last 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

Price an irregular-last-coupon bond at three annual yields.

A worked example from the workbook

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

Illustrative outputClean price

See the inputs and instructions for all 3 examples

Worked examples

Price an irregular-last-coupon bond at three annual yields.

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 =ODDLPRICE(DATE(2026,1,1),DATE(2026,10,1),DATE(2025,12,1),0.05,A7,100,2,0) Clean price
Record 2 =ODDLPRICE(DATE(2026,1,1),DATE(2026,10,1),DATE(2025,12,1),0.05,A8,100,2,0) Clean price
Record 3 =ODDLPRICE(DATE(2026,1,1),DATE(2026,10,1),DATE(2025,12,1),0.05,A9,100,2,0) Clean price
Microsoft Excel reference