YIELD in Collabora Office: Infer a Regular Coupon Bond’s Yield from Price
Use Collabora YIELD with a per-100 bond quote, reproduce the documented 6.5% result, and verify the rate by rebuilding discounted coupon cash flows.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =YIELD(DATE(1999;2;15);DATE(2007;11;15);5.75%;95.04287;100;2;0) has documented result about 6.50%. Rate is the coupon rate; Price is the per-100 quote from which the yield is calculated.
Syntax and units
=YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency [; Basis])
Settlement is the purchase date, Maturity the expiry date, and Rate the annual coupon rate. Price and Redemption are per 100 par. Frequency is 1,2,4 payments per year. All six 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 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.
Enter the quote as 95.04287, not 95.04287%. The result is a decimal yield rate and should be formatted as a percentage when displayed. The function has no separate input for fees, taxes, or irregular coupon dates.
Example: reproduce the source control
Enter the documented inputs in B2:B8 and use =YIELD(B2;B3;B4;B5;B6;B7;B8) in B10. The vendor gives 0.065, or 6.50%.
An independent regular-coupon price inversion for the rounded input quote gives approximately 0.065000006881, or 6.5000006881%. The tiny difference from exactly 6.5% is consistent with the source price being printed to only five decimals.
Do not treat that later-digit difference as an observed native accuracy defect. It is an independent calculation using a rounded quote, while the documentation reports a rounded yield.
Audit the coupon cash flows
The semiannual coupon magnitude is 2.875 per 100 par. Under the source’s regular 30/360 schedule, 18 coupons remain and settlement is half a coupon period before the next payment.
A transparent independent valuation discounts coupons at exponents 0.5 through 17.5 using the semiannual yield, adds discounted redemption 100 at the final exponent, and subtracts accrued coupon 1.4375. At annual yield 6.5%, this gives approximately 95.042874399.
This reconstructs why the stated quote corresponds to about 6.5% and separates coupon rate from yield. It is not a native implementation trace or a certification of every bond schedule.
Advanced example: compare prices under the same cash-flow schedule
Independent prices at annual yields 4%,6.5%,8% are approximately 112.806107579, 95.042874399, and 86.019139754. Supplying those unrounded model prices to the inverse calculation should recover the corresponding model yields.
Higher quoted price implies a lower yield for these fixed positive future receipts. The coupon rate remains 5.75% in every row. A high yield is not an assurance of a desirable investment; this formula does not quantify credit, liquidity, or reinvestment risk.
Advanced interpretation: nominal yield and compounded equivalent
The source model’s 6.5% annual yield with semiannual frequency uses a periodic discount rate 3.25%. Under a separate assumption of compounding twice per year at that rate, the equivalent annual growth factor is (1+0.065/2)^2−1, or 6.605625%.
That is a different rate expression. Do not silently relabel YIELD’s 6.5% nominal-frequency input/output as 6.605625%, and do not assume actual coupon reinvestment will occur at that rate.
Errors and troubleshooting
Verify the quote is per 100, the coupon rate is entered as a rate, the frequency is 1/2/4, and the basis matches the intended convention. Use the unrounded result when checking a reverse valuation; ROUND is for a separately chosen reporting precision.
The dedicated section does not specify every native convergence/error outcome or the exact treatment of unusual dates. This guide does not import IRR’s error codes into YIELD. A regular-coupon model does not reconstruct special first/last coupons from missing dates.
PV is related to present-value reasoning, but a generic annuity calculation does not automatically reproduce bond accrual and coupon-date conventions. The supplied independent schedule explains this particular documented control.
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: YIELD (checked October 17, 2026).
- Editorial testing standards.