# YIELDMAT

Formulas / YIELDMAT
Calculate the annual yield of a security with interest at maturity.
`YIELDMAT(settlement, maturity, issue, rate, pr, [basis])`
• Settlement - required, the settlement date of the security
• Maturity - required, the date the security matures
• Issue - required, the date of the security
• Rate - required, the interest rate of the security at the date of purchase
• Pr - required, the security's price per \$100 face value
• Basis - [OPTIONAL] specifies the type of count day basis to use

## Examples

• `=YIELDMAT(settlement, maturity, rate, pr, redemption, frequency)`

The YIELDMAT function is used to calculate the yield to maturity of a bond.

• `=YIELDMAT(C9,C7,C8,C6,C5,C10)`

For example, if you have the following data in cells C9, C7, C8, C6, C5 and C10: settlement = 4/1/20, maturity = 8/1/20, rate = 0.05, pr = 100, redemption = 100 and frequency = 2, the formula returns 0.081 which is 8.10% when formatted with the percentage number format.

• `=YIELDMAT(C9,C7,C8,C6,C5,C10)`

If you have the following data in cells C9, C7, C8, C6, C5 and C10: settlement = 4/1/20, maturity = 8/1/20, rate = 0.05, pr = 100, redemption = 110 and frequency = 2, the formula returns 0.092 which is 9.20% when formatted with the percentage number format.

• `=YIELDMAT(C9,C7,C8,C6,C5,C10)`

If you have the following data in cells C9, C7, C8, C6, C5 and C10: settlement = 4/1/20, maturity = 8/1/20, rate = 0.05, pr = 100, redemption = 90 and frequency = 2, the formula returns 0.071 which is 7.10% when formatted with the percentage number format.

## Summary

YIELDMAT is a function which calculates the annual yield of a security based on the interest paid at maturity.

• The YIELDMAT function returns the annual yield of a security that pays interest at maturity. It takes 6 arguments: sd (settlement date), md (maturity date), id (issue date), rate (interest rate), pr (price per \$100 face value) and [basis] (which controls how days are counted).

What is the YIELDMAT function?
The YIELDMAT function is a mathematical formula used to calculate the annual yield of a security.
What are the arguments for the YIELDMAT function?
The arguments for the YIELDMAT function are:
• Settlement
• Maturity
• Issue
• Rate
• Pr
• Basis
What does the YIELDMAT function calculate?
The YIELDMAT function calculates the annual yield of a security that pays interest at maturity.