Returns the yield on a security that pays periodic interest.
Składnia
YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])Argumenty
settlementwymagane
The security's settlement date.
maturitywymagane
The security's maturity date.
ratewymagane
The security's annual coupon rate.
prwymagane
The security's price per $100 face value.
redemptionwymagane
The security's redemption value per $100 face value.
frequencywymagane
The number of coupon payments per year (1, 2, or 4).
basisopcjonalne
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.