Returns the yield on a security that pays periodic interest.
Syntax
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])Argumente
settlementerforderlich
The security's settlement date.
maturityerforderlich
The security's maturity date.
rateerforderlich
The security's annual coupon rate.
prerforderlich
The security's price per $100 face value.
redemptionerforderlich
The security's redemption value per $100 face value.
frequencyerforderlich
The number of coupon payments per year (1, 2, or 4).
basisoptional
The type of day count basis to use.
The YIELD function calculates the annual yield for a security based on its settlement date, maturity date, coupon rate, market price, and redemption value. It is commonly used to evaluate the return on investment for bonds or other fixed-income securities.
=YIELD("2023-01-01", "2033-01-01", 0.05, 95, 100, 2)→0.0565Calculates the yield for a bond with a 5% coupon, priced at 95, maturing in 10 years with semi-annual payments.
Prepare input data
Ensure your settlement and maturity dates are in a recognized date format.
Enter the formula
Input the YIELD function with the required financial parameters.
It represents the number of coupon payments per year: 1 for annual, 2 for semi-annual, and 4 for quarterly.
This usually happens if the settlement date is after the maturity date or if invalid frequency values are provided.