PRICEDISC in Collabora Office: Price a Discount Security per 100 Par
Calculate Collabora PRICEDISC from discount and redemption, reproduce the short-dated control, and audit quoted prices without confusing discount with yield.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =PRICEDISC(DATE(1999;2;15);DATE(1999;3;1);5.25%;100;2) has documented result approximately 99.79583 per 100 par. It prices a non-interest-bearing security using the supplied discount.
Syntax and input scale
=PRICEDISC(Settlement; Maturity; Discount; Redemption [; Basis])
Settlement and Maturity are the purchase and expiry dates. Discount is a percentage rate. Redemption is the maturity amount per 100 par. All four are required; Basis is optional and defaults to zero.
| Basis | Documented convention |
|---|---|
| 0 or omitted | US NASD, twelve 30-day months |
| 1 | Actual days in months and actual days in year |
| 2 | Actual days in months, 360-day year |
| 3 | Actual days in months, 365-day year |
| 4 | European method, twelve 30-day months |
Use DATE for explicit date values. Enter 5.25% as 0.0525 or 5.25%, and Redemption as 100 for a redemption quote of 100 per 100 par. The output is a price, not a percentage.
Example: reproduce the vendor’s 14-day control
Enter dates 1999-02-15 and 1999-03-01 in A2:B2, Discount 5.25% in C2, Redemption 100 in D2, and Basis 2 in E2. Use =PRICEDISC(A2;B2;C2;D2;E2) in F2.
The actual interval is 14 days. Independent arithmetic under the stated actual/360 basis is:
=D2*(1-C2*(B2-A2)/360)
It gives 99.795833333333, consistent with the documented rounded 99.79583. The discount amount is approximately 0.204166667 per 100 par.
Example: an exact half-year price
For settlement 2026-01-15, maturity 2026-07-15, discount 4%, redemption 100, and basis 0, the ordinary mid-month 30/360 fraction is 0.5.
=PRICEDISC(DATE(2026;1;15);DATE(2026;7;15);4%;100;0) has independently expected price 98. This is 100×(1−0.04×0.5), with no intermediate coupon cash flow.
The actual calendar interval is 181 days, but basis zero uses the selected 30/360 convention here. A manual actual-day subtraction would need the corresponding actual-day basis before replacing the model’s time fraction.
Advanced application: scale a quote to a face amount
For a face amount of 2500, a quote of 98 per 100 gives an independent cash price of 2450. At redemption 100 per 100, the cash receipt is 2500, a difference of 50 before any external fees or taxes.
Use =quoted_price/100*face_amount, keeping the quote and face amount separate. The function itself does not infer the size of a position from the per-100 Redemption input.
Advanced comparison: recover the discount and distinguish yield
From price 98, redemption 100, and year fraction 0.5, the independent inverse discount is (1−98/100)/0.5=4%.
The simple annual gain relative to the invested price is instead (100−98)/98/0.5, approximately 4.081632653%. Discount uses redemption as the base; investment yield uses purchase price. Treating them as the same percentage can misstate a comparison.
ROUND can control a displayed quote, but reconstruct a rate from unrounded values if you want the arithmetic to reconcile precisely. The vendor’s separate YIELDDISC example uses price 99.795, not the exact 99.795833333 price here, so those printed examples are not an exact inverse pair.
Errors and limitations
Check settlement before maturity, a valid basis, consistent per-100 redemption units, and a rate on the correct scale. A discount/time fraction that makes the independent price nonpositive is outside the ordinary positive-price model used in these controls.
The dedicated section does not enumerate every native error code, date coercion, or month-end adjustment. The examples avoid those boundaries and do not include coupons, taxes, fees, compounding, or live market pricing. The supplied inputs and chosen convention determine the mathematical quote; a successful formula does not establish that the security can be bought at that price.
Availability and verification
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.
References
- Collabora Office 26.04: PRICEDISC (checked October 17, 2026).
- Editorial testing standards.