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

`=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.

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).

The YIELDMAT function is a mathematical formula used to calculate the annual yield of a security.

The arguments for the YIELDMAT function are:

- Settlement
- Maturity
- Issue
- Rate
- Pr
- Basis

The YIELDMAT function calculates the annual yield of a security that pays interest at maturity.

Drop CSV