PRICEMAT Function (Calligra Sheets)

• Introduced: Original introduction release not established; the inspected release is not an introduction date.
• Available: Registered in Calligra Sheets 26.08.2, verified from first-party released source retrieved on October 18, 2026.
• Retired or deprecated: Neither is established by the inspected sources. The function remains registered; retirement and deprecation are different claims.
• Evidence: Selected formulas were executed in the Calligra Sheets 25.04.2 GUI on October 18, 2026. The native-results section lists those observations separately from independent arithmetic and source analysis. 26.08.2 was source-checked only.
• Entry style: English function names, semicolon argument separators and decimal points. Use DATE constructors instead of ambiguous date text. Optional-argument brackets shown in syntax are not entered literally.

=PRICEMAT(settlement; maturity; issue; rate; yield[; basis])

Five or six arguments are accepted. Use an economically sensible date order issue ≤ settlement < maturity. The body explicitly checks settlement before maturity but does not enforce all relationships involving issue. There is no frequency argument, because the modeled interest is paid at maturity rather than through periodic coupons.

The inspected XML description lists 4 for actual/365 and 5 for European 30/360. Those labels do not match the implementation’s date helpers. For this released code, use 3 for actual/365 and 4 for the European-style helper; the intended helper choices are 0–4. Do not copy basis 5 from the stale description and expect a valid European calculation.

The fourth parameter is labeled “Discount rate” in part of the XML, but the body uses rate to accrue issue-to-maturity interest and separately uses the fifth yield to discount the remaining interval. Keep those roles distinct. See function implementation and date helpers.

On a fresh worksheet enter:

1. In B8 enter =PRICEMAT(B1;B2;B3;B4;B5;B6).
2. Expect 100.2280300180. A two-decimal price display is 100.23.
3. Independently count the actual intervals: issue-to-maturity 181 days, issue-to-settlement 90 days, settlement-to-maturity 91 days.
4. Divide each interval by 365 for basis 3. Keep full precision while reconciling.

The independent calculation is:

100 * ((1 + (181/365)*0.06) / (1 + (91/365)*0.05) - (90/365)*0.06)

First form the principal-plus-maturity-interest amount per face unit, then discount it across the remaining interval using the simple yield denominator, then subtract the issue-to-settlement accrued interest. This reproduces the source’s equation without running Calligra.

For a holding of 5,000 face units, multiply the quoted price by 5000/100. The independently expected quoted-price amount is approximately 5011.40150090.

The model’s accrued interest is 5000 × 0.06 × 90/365, approximately 73.97260274. Adding that to the quoted-price amount gives approximately 5085.37410364 for the model’s discounted principal-plus-interest amount before separate fees or adjustments. This decomposition explains why multiplying PRICEMAT by face/100 is not automatically the entire settlement invoice.

Keep quoted price, face amount, accrued interest and any external charges in separate labeled cells. Do not silently add accrued interest twice. The function does not calculate commissions, taxes, business-day settlement changes or other contractual adjustments.

For the same three dates with basis 0, the helper intervals are 180, 90 and 90 days over 360. The independently expected price is 100.2283950617. The small difference from basis 3 is due to day fractions, not a rounding defect.

If issue equals settlement and both rate and yield are zero, the independent expectation is 100. The source permits zero rate and zero yield; it rejects negative values. Zero yield means the remaining maturity amount is not discounted by yield, while positive interest can still accrue from issue. Do not confuse rate and yield merely because both are entered as percentages.

For this function, basis 0 defaults to the financial helper’s simplified US 30/360 method; 1 counts actual days divided by the number of days in the settlement year; 2 uses actual/360; 3 uses actual/365; 4 uses a simplified European 30/360 calculation.

The 0/4 helpers are not full end-of-month normalization algorithms. Basis 0 has a special February-start adjustment; basis 4 is simply 30 times the month difference plus the day difference. Basis 1 uses the settlement year’s 365/366 denominator even across a year boundary. Do not infer full market-convention correctness from the labels. These helpers also differ from the shared YEARFRAC implementation used by DISC. See released date helpers.

• Negative rate, negative yield, or settlement on/after maturity explicitly returns the internal errorVALUE. Equal settlement and maturity displayed #VALUE! in the selected native test; the negative-rate/yield cases were source-checked only.
• The year-denominator check tests only whether the returned value is zero. An invalid basis can produce the helper’s −1 sentinel, which passes that check. Therefore a numeric answer for an out-of-range basis is not a validated price. Restrict basis to 0–4 yourself.
• The body does not explicitly require issue on/before settlement. Validate the three-date order rather than interpreting any accepted date combination as a legitimate instrument.
• Imported date strings, blank cells, fractional selectors and coercion errors need native tests; the ordinary DATE-based example does not establish those rules.
• This is a simple maturity-interest pricing model. It is not a periodic-coupon bond pricer and does not infer a schedule from maturity.

The Financial module registers COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETPRICEMAT as an alternate name for PRICEMAT. It invokes the same implementation. An alias registration does not establish a workbook import/export guarantee, identical error behavior in other products or availability in every packaged build.

• DATE constructs the three date inputs.
• YEARFRAC is a different date-fraction implementation; it should not silently replace PRICEMAT’s helpers.
• SUM can combine separately checked invoice components.
• KDE PRICEMAT handbook documents the function interface.
• Released function implementation provides the actual validation and calculation rules.

These formulas were recalculated in Calligra Sheets 25.04.2 from a prepared ODS workbook and saved by the application. The table records the native-saved results. Other scenarios remain independent expectations or source analysis unless listed here.

Screenshot: Native Calligra Sheets 25.04.2. Selected cell B2 evaluates =PRICEMAT(DATE(2025;4;1);DATE(2025;7;1);DATE(2025;1;1);0.06;0.05;0) and displays 100.2283950617. Column B contains application results; column C contains the corresponding formula text.

These observations cover only the listed cases in 25.04.2. They do not establish execution in 26.08.2, another locale, general workbook compatibility or the economic validity of unsuitable inputs.