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

Frequently Asked Questions

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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV