YIELDMAT Function in Google Sheets

Calculate the annual yield of a bond that pays interest at maturity using the YIELDMAT function.

YIELDMAT Function

The YIELDMAT function in Google Sheets calculates the annual yield of a bond that pays interest at maturity.

Syntax

YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
  • settlement: The settlement date of the bond. This is a required parameter.
  • maturity: The maturity date of the bond. This is a required parameter.
  • issue: The issue date of the bond. This is a required parameter.
  • rate: The bond’s annual coupon rate. This is a required parameter.
  • price: The price of the bond. This is a required parameter.
  • day_count_convention: (Optional) The day-count convention to use. Default is 0 (actual/actual).

Examples

  1. Basic Calculation

Calculate the annual yield of a bond that pays interest at maturity:

=YIELDMAT(DATE(2023,1,1), DATE(2030,1,1), DATE(2020,1,1), 0.05, 95)

This will output the bond’s annual yield.

Notes

  • YIELDMAT is specific to bonds that pay interest at maturity, rather than periodically.
  • The settlement date must be after the issue date.
  • YIELD: Calculate the annual yield of a bond.
  • YIELDDISC: Calculate the annual yield of a discounted security.