YIELD function
Returns the yield on a security that pays periodic interest
Syntax
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| settlement | Yes | The security's settlement date."2008-11-11" |
| maturity | Yes | The security's maturity date."2021-3-1" |
| rate | Yes | The security's interest rate.7.85% |
| pr | Yes | The security's price per $100 face value.98.45 |
| redemption | Yes | The security's redemption value per $100 face value.100 |
| frequency | Yes | The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.2 |
| basis | No | The type of day count basis to use.1 |
Try YIELD
Invert the final simple-discount period with basis 2
=YIELD(DATE(2026,7,15),DATE(2026,9,30),A2,B2,C2,D2,E2)The previous coupon is March 31, with 106 accrued calendar days. The coupon-period denominator is 180.0. The final coupon plus redemption is 103; the independent clean quote uses simple discounting with remaining fraction 1-106/180.0, then subtracts accrued interest. YIELD recovers 0.06 under the same convention.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
YIELD · top-level call
=YIELD(DATE(2026,7,15),DATE(2026,9,30),A2,B2,C2,D2,E2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.