Returns the annual yield of a security that pays interest at maturity.
Söz dizimi
YIELDMAT(settlement, maturity, issue, rate, pr, [basis])Bağımsız değişkenler
settlementzorunlu
The security's settlement date.
maturityzorunlu
The security's maturity date.
issuezorunlu
The security's issue date.
ratezorunlu
The security's interest rate at date of issue.
przorunlu
The security's price per $100 face value.
basisisteğe bağlı
The type of day count basis to use.
YIELDMAT calculates the yield for a security that pays interest only at the maturity date rather than periodically. It is commonly used for bonds or notes where the principal and interest are paid in a single lump sum at the end of the term.
=YIELDMAT("2023-01-01", "2024-01-01", "2022-01-01", 0.05, 98, 1)→0.07142857Calculates the yield for a bond with a 5% coupon rate, priced at 98, using the actual/actual day count basis.
Prepare your data
Ensure your settlement, maturity, and issue dates are entered in a format Excel recognizes as dates.
Apply the formula
Enter the YIELDMAT function with the required parameters, ensuring the price is expressed per $100 of face value.
Excel will return a #NUM! error.