PRICE in Collabora Office: Calculate a Regular Coupon Bond’s Price
Use Collabora PRICE with per-100 redemption and regular coupons, reproduce the documented bond price, and audit how yield changes the valuation.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =PRICE(DATE(1999;2;15);DATE(2007;11;15);5.75%;6.5%;100;2;0) has documented result 95.04287 per 100 par. Coupon rate and yield are separate inputs.
Syntax and input roles
=PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency [; Basis])
Settlement is the purchase date and Maturity the expiry date. Rate is the annual nominal coupon rate. Yield is the annual yield used for valuation. Redemption is the maturity value per 100 par. Frequency permits 1,2,4 payments per year. These six arguments are required; Basis is optional.
| 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 or genuine date cells for the inputs. A date-looking subtraction expression is not a date. The examples supply Basis explicitly and do not certify every month-end or multi-year actual/actual boundary.
The output is a quoted price per 100 par, not the cash price of an arbitrary-sized position. There is no issue-date, irregular-coupon date, fee, or tax argument. The worked model is a regular coupon schedule.
Example: reproduce the vendor price
Enter the two dates and 5.75%,6.5%,100,2,0 in B2:B8. Use =PRICE(B2;B3;B4;B5;B6;B7;B8) in B10. The source’s rounded result is 95.04287.
For an independent regular 30/360 reconstruction, each semiannual coupon is 100×5.75%/2=2.875. The settlement is halfway between the November 15 and May 15 coupon dates, and 18 coupons remain through November 2007.
Discount coupons at exponents 0.5,1.5,…,17.5 with per-period yield 6.5%/2=3.25%, discount redemption at exponent 17.5, then subtract accrued coupon 1.4375. The independent result is approximately 95.042874399, matching the documented rounding.
This is an explicit mathematical reconstruction of the control, not a fresh native bond-price test.
Advanced audit: clean quote versus accrued component
The independent discounted total before subtracting accrued coupon is approximately 96.480374399. Subtracting 1.4375 produces the quoted 95.042874399.
Keep these components labeled separately. Treating a clean quoted price and a price including accrued interest as interchangeable can create an unexplained cash discrepancy. The independent reconstruction identifies the components for this example; it does not certify every market settlement convention.
Advanced example: change yield while keeping the coupon fixed
With the same dates, coupon rate, redemption, frequency, and basis, independent regular-coupon valuations are:
| Annual yield input | Independent price per 100 |
|---|---|
| 4% | 112.806107579 |
| 6.5% | 95.042874399 |
| 8% | 86.019139754 |
These expectations show the inverse price/yield relation for the stated positive fixed cash flows. Rate remains 5.75%; changing Yield does not change the contractual coupon amount.
The examples are model calculations, not historical or live market quotes. They do not say that any actual security is available at those prices.
Scale the quote and retain precision
For hypothetical face amount 10000, the source-style clean quote scales to approximately 9504.2874399 by =price/100*10000. Accrued coupon for the independent example scales to 143.75.
Use SUM to combine clearly labeled components when the model requires it. ROUND should follow the reporting rules; retain the unrounded quote for a rate/price reconciliation.
Errors and limitations
Check positive redemption, permitted frequency, dates in order, percentage scales, and the intended basis. Entering 6.5 instead of 6.5% changes the yield by a factor of 100.
The dedicated help does not enumerate all native errors, solver details, irregular-coupon handling, or month-end rules. A regular PRICE formula cannot infer an odd first or last coupon date that is absent from its arguments. This guide does not establish investment suitability, credit risk, taxes, or a transaction 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: PRICE (checked October 17, 2026).
- Editorial testing standards.