ExcelFlux

ODDFYIELD function

the yield 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

Solve for yield on a bond with an irregular first coupon. Yield falls as price rises.

A worked example from the workbook

RowA
6Input
795
8100
9105
Record 1
=ODDFYIELD(DATE(2026,1,1),DATE(2027,1,1),DATE(2025,12,1),DATE(2026,7,1),0.05,A7,100,2,0)

Illustrative outputAnnual yield

See the inputs and instructions for all 3 examples

Worked examples

Solve for yield on a bond with an irregular first coupon. Yield falls as price 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 95
8 100
9 105
Trial Expression Sample output
Record 1 =ODDFYIELD(DATE(2026,1,1),DATE(2027,1,1),DATE(2025,12,1),DATE(2026,7,1),0.05,A7,100,2,0) Annual yield
Record 2 =ODDFYIELD(DATE(2026,1,1),DATE(2027,1,1),DATE(2025,12,1),DATE(2026,7,1),0.05,A8,100,2,0) Annual yield
Record 3 =ODDFYIELD(DATE(2026,1,1),DATE(2027,1,1),DATE(2025,12,1),DATE(2026,7,1),0.05,A9,100,2,0) Annual yield
Microsoft Excel reference