YIELDDISC
Returns the annual yield for a discounted security; for example, a Treasury bill.
FinancialFinance & Accounting
What it does
Calculates annual yield of a discounted security.
Syntax
YIELDDISC(settlement, maturity, pr, redemption, [basis])
Arguments
settlement(date) — Settlement.maturity(date) — Maturity.pr(number) — Price.redemption(number) — Redemption.
Examples
Discounted Yield
Calculate yield.
FORMULA
=YIELDDISC(A2, B2, 98, 100)
RESULT
0.04
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Set | Mat |
| 2 | 2023-01-01 | 2023-07-01 |