Returns the yield on a security that pays periodic interest.
الصيغة
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])المعاملات
settlementمطلوب
The security's settlement date.
maturityمطلوب
The security's maturity date.
rateمطلوب
The security's annual coupon rate.
prمطلوب
The security's price per $100 face value.
redemptionمطلوب
The security's redemption value per $100 face value.
frequencyمطلوب
The number of coupon payments per year (1, 2, or 4).
basisاختياري
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.