ExcelFlux

ODDLYIELD function

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

Calculate yield from price for a bond with an irregular final coupon.

A worked example from the workbook

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

Illustrative outputAnnual yield

See the inputs and instructions for all 3 examples

Worked examples

Calculate yield from price for a bond with an irregular final coupon.

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