PRICEMAT Function

Returns the price of a security that pays interest at maturity.

Category

Financial

Available in

All versions, Microsoft 365

Returns

A price per $100 face value

Want to practice PRICEMAT 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

PRICEMAT prices a security that pays all its interest in one go at maturity, given the yield you want.

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

Syntax

=PRICEMAT(settlement, maturity, issue, rate, yld, [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.
yldYesThe annual yield.
basisNoDay count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360.

Examples

Example 1 — A note paying at maturity

A 4.8% note issued 12/1/2025 and maturing 12/1/2026. Northstar buys it on 3/15/2026 wanting a 5.2% yield.

B7fx=PRICEMAT(B1,B2,B3,B4,B5,B6)
AB
1Settlement3/15/2026
2Maturity12/1/2026
3Issue12/1/2025
4Rate4.8%
5Yield5.2%
6Basis0
7Price99.68
8Yield at 99.605.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: YIELDMAT, ACCRINTM, PRICE.
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.