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.