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.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.


Drop CSV