Returns the annual yield of a security that pays interest at maturity.
Syntax
YIELDMAT(settlement, maturity, issue, rate, pr, [basis])Argumente
settlementerforderlich
The security's settlement date.
maturityerforderlich
The security's maturity date.
issueerforderlich
The security's issue date.
rateerforderlich
The security's interest rate at date of issue.
prerforderlich
The security's price per $100 face value.
basisoptional
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.