Returns the annual yield of a security that pays interest at maturity.
Cú pháp
YIELDMAT(settlement, maturity, issue, rate, pr, [basis])Đối số
settlementbắt buộc
The security's settlement date.
maturitybắt buộc
The security's maturity date.
issuebắt buộc
The security's issue date.
ratebắt buộc
The security's interest rate at date of issue.
prbắt buộc
The security's price per $100 face value.
basistùy chọn
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.