Returns the annual yield of a security that pays interest at maturity.
構文
YIELDMAT(settlement, maturity, issue, rate, pr, [basis])引数
settlement必須
The security's settlement date.
maturity必須
The security's maturity date.
issue必須
The security's issue date.
rate必須
The security's interest rate at date of issue.
pr必須
The security's price per $100 face value.
basis省略可能
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.