YIELDMAT Function in Excel: Yield of a Security Paying Interest at Maturity

YIELDMAT Function in Excel: Yield of a Security Paying Interest at Maturity 1
⏱ 1 min readUpdated 5 October 2026

FinanceLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. YIELDMAT in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

YIELDMAT returns the yield of a security that pays interest at maturity.

Advertisement

Syntax

=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
Argument What it means
dates Settlement, maturity and other dates as real dates
rates / prices Per 100 of face value where relevant
basis Day-count basis (0 = 30/360, 3 = actual/365)

Examples

Example 1

=ROUND(YIELDMAT(DATE(2026,10,5),DATE(2027,9,30),DATE(2026,4,1),A2,B2,3)*100,3)

Result: 7.014. See the worked example table below for more cases.

YIELDMAT in practice

Where you will use it

  • Treasury and bond desks
  • Valuing debentures and money-market instruments
  • Accrual and audit checks

Worked example

RatePriceFormulaResult
0.075100.2=ROUND(YIELDMAT(DATE(2026,10,5),DATE(2027,9,30),DATE(2026,4,1),A2,B2,3)*100,3)7.014
0.0799=ROUND(YIELDMAT(DATE(2026,10,5),DATE(2027,9,30),DATE(2026,4,1),A3,B3,3)*100,3)7.812
0.08100=ROUND(YIELDMAT(DATE(2026,10,5),DATE(2027,9,30),DATE(2026,4,1),A4,B4,3)*100,3)7.685

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Dates as textUse DATE() or real date cells
Wrong basisIndian money-market instruments usually use actual/365 (3)

PRICE · YIELD · DISC

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZFIND Function in Excel: Position of Text (Case-Sensitive)Excel Functions A–ZF.INV Function in Excel: F Value for a Left-Tail ProbabilityExcel Functions A–ZEXPAND Function in Excel: Grow an Array to a Fixed Size
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong