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
| Argument | Required? | What it does |
|---|---|---|
| settlement | Yes | The date the buyer takes ownership (after the issue date). |
| maturity | Yes | The date the security is repaid. |
| issue | Yes | The date the security was first issued. |
| rate | Yes | The interest rate at issue. |
| yld | Yes | The annual yield. |
| basis | No | Day 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)
| A | B | |
|---|---|---|
| 1 | Settlement | 3/15/2026 |
| 2 | Maturity | 12/1/2026 |
| 3 | Issue | 12/1/2025 |
| 4 | Rate | 4.8% |
| 5 | Yield | 5.2% |
| 6 | Basis | 0 |
| 7 | Price | 99.68 |
| 8 | Yield at 99.60 | 5.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.

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.