Returns the yield on a security that pays periodic interest.
Sintaxe
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])Argumentos
settlementobrigatório
The security's settlement date.
maturityobrigatório
The security's maturity date.
rateobrigatório
The security's annual coupon rate.
probrigatório
The security's price per $100 face value.
redemptionobrigatório
The security's redemption value per $100 face value.
frequencyobrigatório
The number of coupon payments per year (1, 2, or 4).
basisopcional
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.