Returns the yield on a security that pays periodic interest.
Sintassi
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])Argomenti
settlementobbligatorio
The security's settlement date.
maturityobbligatorio
The security's maturity date.
rateobbligatorio
The security's annual coupon rate.
probbligatorio
The security's price per $100 face value.
redemptionobbligatorio
The security's redemption value per $100 face value.
frequencyobbligatorio
The number of coupon payments per year (1, 2, or 4).
basisfacoltativo
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.