YIELDDISC Function (Calligra Sheets)

• Introduced: Original introduction release is not established. A checked release is not an introduction date.
• Source checked: Calligra Sheets 26.08.2, first-party implementation retrieved on October 18, 2026.
• Retired or deprecated: Neither is established. The function remains registered in the inspected source.
• Numerical evidence: The selected formulas below were executed in Calligra Sheets 25.04.2 on October 18, 2026, and their formulas and results read back from native-saved ODS files. Independent calculations provide separate checks. Version 26.08.2 was source-checked only; no general import/export or cross-version runtime compatibility is established.
• Entry style: English names, semicolon separators, decimal points and DATE(year;month;day) values. Brackets in syntax indicate optional arguments; do not type them.

YIELDDISC computes an annualized simple yield for a discounted security, based on the amount paid rather than the redemption amount. It is not a periodic-compounding calculation, and it is not the same percentage as a discount rate quoted against face value.

=YIELDDISC(settlement; maturity; price; redemption[; basis])

The registration accepts four or five arguments. Use basis 0 for US 30/360, 1 for actual/actual, 2 for actual/360, 3 for actual/365 and 4 for European 30/360. These labels do not establish that every function uses the same underlying day-count implementation. Date boundaries, leap days and coupon schedules need their own checks. Use actual spreadsheet dates rather than ambiguous text such as 1/4/25.

1. On a fresh worksheet, enter =DATE(2025;1;1) in A2 and =DATE(2025;7;1) in B2.
2. Put 95 in C2 and 100 in D2.
3. Enter =YIELDDISC(A2;B2;C2;D2;0) in E2.
4. The independently calculated result is 0.105263157895, or 10.5263157895% with percentage formatting.

Under basis 0 these dates span half a 360-day year. The holding-period gain is 5 and the amount invested is 95, giving 5/95. Dividing by 0.5 annualizes that return. This is a simple annualization; it does not mean reinvestment for a full year will necessarily earn that amount.

The inspected body evaluates:

yield = (redemption/price − 1) / YEARFRAC(settlement; maturity; basis)

For this example the corresponding face-value discount rate would instead use 5/100/0.5 = 0.10, or 10%. The two percentages differ because their denominators differ. Keep this distinction explicit when reconciling a quote with an investment-return calculation.

Using basis 3 changes the year fraction to 181/365, so the same 95-to-100 transaction has an independent annual yield of approximately 0.106135504507, or 10.6135504507%. Only the annualizing fraction changes; the holding-period cash gain is still 5.

Now use price 105 with redemption 100 and basis 0. The result is −0.0952380952381, or −9.52380952381%. The function accepts a premium purchase as long as both price and redemption are positive; a negative yield is therefore a legitimate calculated output, not automatically an error. At price equal to redemption, the result is exactly 0 for a positive time interval.

To scale to a position, first compute the quoted return on the common per-100 basis. Scaling both purchase and redemption by the same factor leaves the ratio unchanged. Fees or taxes that change the effective cost should be modeled explicitly rather than assumed to be included in the function.

The implementation calls ValueCalc’s YEARFRAC helper, not the simplified daysBetweenDates/daysPerYear pair used by some other financial functions. Basis 0 uses NASD-style days360; basis 4 uses European days360. Basis 1 accounts for actual dates and leap-year denominators using that helper’s rules; it is not always a fixed 365 denominator.

Price or redemption less than or equal to zero, and settlement greater than or equal to maturity, explicitly return internal errorVALUE. The comparison table includes an equal-date case to distinguish this from a valid zero yield. The equal-date example below displayed #VALUE! in the native application.

The wrapper does not explicitly reject all unsupported basis integers. YEARFRAC’s default switch branch uses US/NASD 30/360, so an unrecognized code can silently fall back instead of returning an error. Supply only a documented basis and verify dates before using the output. Text-date parsing, blank coercion and mixed-type imports are not established by these examples.

Enter each formula on a fresh worksheet. Format numeric results with at least ten decimal places before comparing; percentage formatting multiplies the displayed number by 100. The displayed errors for these selected formulas were also observed in the native application.

The following selected formulas were recalculated in the native application. Display rounding can differ from the independent values above.

Calligra Sheets 25.04.2: selected cell B2 evaluates =YIELDDISC(DATE(2025;1;1);DATE(2025;7;1);95;100;0) to 0.1052631579. Column B contains calculated results and column C shows entered formula text.

The registered alternate spelling is COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETYIELDDISC. It uses the same handler; it is not a separate calculation. Matching names in other spreadsheet products do not guarantee matching argument order, day counts, validation or file-import behavior. This guide does not establish general XLSX/ODS round-trip compatibility. Check a small workbook with known results before relying on a migrated model.

Related guides: DURATION and PDURATION cover compound-growth periods; PMT handles equal periodic payments; DATE constructs date values. Bond duration and annualized yield are different quantities.

• Calligra released function implementation, including the actual argument reads and return expressions.
• Calligra function descriptions, useful for terminology but subordinate to the inspected implementation where they differ.
• Calligra year-fraction implementation, relevant to basis-dependent year fractions.

References checked October 18, 2026. Numerical examples are spreadsheet calculations, not a recommendation to buy, sell or price a particular security without checking its contractual terms.