YIELDMAT Function

Returns the annual yield of a security that pays interest at maturity.

Category

Financial

Available in

All versions, Microsoft 365

Returns

An annual yield

Want to practice YIELDMAT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

YIELDMAT is the reverse of PRICEMAT: from the price you pay, it finds the annual yield on a security that pays its interest at maturity.

Prices are quoted per $100 of face value, so 95.10 means you pay $951 for a $1,000 bond.

Syntax

=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])

Arguments

ArgumentRequired?What it does
settlementYesThe date the buyer takes ownership (after the issue date).
maturityYesThe date the security is repaid.
issueYesThe date the security was first issued.
rateYesThe interest rate at issue.
prYesThe price per $100 of face value.
basisNoDay count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.

Examples

Example 1 — Yield on the at-maturity note

The same 4.8% note, bought at 99.60 on 3/15/2026.

B7fx=YIELDMAT(B1,B2,B3,B4,B5,B6)
AB
1Settlement3/15/2026
2Maturity12/1/2026
3Issue12/1/2025
4Rate4.8%
5Price99.6
6Basis0
7Yield5.31%

Common mistakes

  • #VALUE! or #NUM!. A date isn't a real date, settlement is on or after maturity, or frequency isn't 1, 2 or 4.

Notes

  • Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
  • Related functions: PRICEMAT, YIELD.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.