ODDLYIELD in Collabora Office: Find Yield for an Irregular Final Coupon Period

=ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price;
           Redemption; Frequency [; Basis])

All inputs except Basis are required. Rate is the known coupon rate; the function’s result is the yield. Price and Redemption must be on the same quote scale. A total purchase amount for a holding should not be mixed with a redemption quote per 100.

The documented basis choices are 0 or omitted for US NASD 30/360, 1 for actual days and actual year length, 2 for actual/360, 3 for actual/365, and 4 for European 30/360. Frequency 1 means annual, 2 semiannual, and 4 quarterly payments.

Enter the following input block. Use actual spreadsheet dates rather than locale-dependent date text.

In B11 enter:

=ODDLYIELD(B2;B3;B4;B5;B6;B7;B8;B9)

The documented result is 0.044873, reported as 4.4873%. An equivalent explicit formula is:

=ODDLYIELD(DATE(1999;4;20);DATE(1999;6;15);DATE(1998;10;15);
           0.0375;99.875;100;2;0)

Format B11 as a percentage to display the yield conveniently. Percentage formatting changes the display, not the numeric result. Do not multiply by 100 and then also apply percentage formatting, which would scale the display twice. See DATE for constructing the input dates.

The dedicated help gives the result but does not publish the full algorithm. This reconstruction checks only the stated fixture under an explicit 30/360 cash-flow model; it is not evidence for every native odd-period convention.

For these dates, the 30/360 intervals are 240 days from October 15 to June 15, 185 from October 15 to April 20, and 55 from April 20 to June 15. A regular semiannual period has 180 days. The regular coupon per 100 is 100×0.0375÷2=1.875.

The reconstruction gives:

• Final coupon: 1.875×240/180=2.5.
• Final cash payment: 100+2.5=102.5.
• Accrued amount at settlement: 1.875×185/180≈1.927083333333.
• Price plus that accrued amount: 99.875+1.927083333333≈101.802083333333.

Solving the model’s simple final-period discount relationship for the annual yield gives:

2 * (102.5 / (99.875 + 1.875*185/180) - 1) / (55/180)

The independent result is approximately 0.044873166330242, or 4.4873166330242%, consistent with the vendor’s rounded display.

This establishes a useful numerical check, not a general implementation contract. Exact treatment of different odd periods, boundary dates and other bases still requires target-application evidence.

A useful audit is to substitute the independently calculated yield back into the same model:

102.5 / (1 + yield/2 * 55/180) - 1.875*185/180

Using the unrounded independent yield reproduces 99.875. Using only the printed 0.044873 gives approximately 99.875002569336, a small difference caused by rounding the yield. Keep the stored result during reconciliation instead of copying its displayed digits into another formula.

You can also compare the yield with the input coupon as a clearly labeled arithmetic difference. With yield in B11 and coupon rate in B5, (B11-B5)*10000 expresses the difference in basis points. The independent fixture gives about 73.731663 basis points. This is a difference between two quoted annual rates, not a forecast of profit or a complete holding-period return.

LastInterest is essential to the irregular-period model. Preserve the date specified for the instrument rather than substituting a date generated from a regular schedule without checking. Verify the settlement date too: the vendor’s separate ODDLPRICE example uses February 7, 1999, whereas this yield example uses April 20, 1999. Their different inputs mean they are not an unchanged-input inverse pair.

If a result differs, inspect dates, percentage scaling, per-100 price and redemption units, frequency and basis before changing precision. Use ROUND only for an explicit reporting requirement, while retaining an unrounded result for comparisons.

The dedicated section does not give a complete native error-code matrix, date coercion rules, unsupported-input behavior or numerical convergence guarantees. Such rules are not borrowed here from another spreadsheet. The documented fixture is also not a claim of compatibility with other applications or proof of an investment’s actual market yield.

The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.

The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.

• Collabora Office 26.04: ODDLYIELD (checked October 17, 2026).
• Editorial testing standards.