deepcalc
DocsYIELD

YIELD

View as markdown/docs/functions/yield.md Ask Claude about this pageOpens Claude with this page's address

Returns the yield of a security paying periodic interest.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=YIELD(DATE(2026,1,1), DATE(2030,1,1), 0.05, 95, 100, 2)
Result 0.06437746721925425

Syntax

YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
settlement
number required
maturity
number required
rate
number required
pr
number required
redemption
number required
frequency
number required
basis
number optional

Errors

#ERROR!
=YIELD(1, 2, 3, 4, 5)
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.