ExcelFlux

YIELD function

the yield on a security that pays periodic interest.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

On a coupon date, yield equals coupon rate when the price is at par.

A worked example from the workbook

RowAB
6Settlement serialMaturity serial
74602346388
84602346753
94602347119
Record 1
=YIELD(A7,B7,0.05,100,100,2,0)

Expected result0.05

See the inputs and instructions for all 3 examples

Syntax

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

Copyable formulas

English Excel · en-US
=YIELD(A7,B7,0.05,100,100,2,0)
Turkish Excel · tr-TR
=ÖDEME(A7;B7;0,05;100;100;2;0)

Worked examples

On a coupon date, yield equals coupon rate when the price is at par.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Settlement serial Maturity serial
7 46023 46388
8 46023 46753
9 46023 47119
Case Formula Expected result
Record 1 =YIELD(A7,B7,0.05,100,100,2,0) 0.05
Record 2 =YIELD(A8,B8,0.05,100,100,2,0) 0.05
Record 3 =YIELD(A9,B9,0.05,100,100,2,0) 0.05
Microsoft Excel reference