PRICEMAT function
the price per $100 face value of a security that pays interest at maturity.
Financial · Guided Excel example
Where can you use it?
Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.
Scenario in the workbook
Price 100 face value with 5% interest paid entirely at maturity.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Input |
| 7 | 0.05 |
| 8 | 0.1 |
| 9 | 0 |
Record 1
=PRICEMAT(DATE(2026,1,1),DATE(2027,1,1),DATE(2026,1,1),0.05,A7,3)Illustrative output100
See the inputs and instructions for all 3 examplesWorked examples
Price 100 face value with 5% interest paid entirely at maturity.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A |
|---|---|
| 6 | Input |
| 7 | 0.05 |
| 8 | 0.1 |
| 9 | 0 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =PRICEMAT(DATE(2026,1,1),DATE(2027,1,1),DATE(2026,1,1),0.05,A7,3) |
100 |
| Record 2 | =PRICEMAT(DATE(2026,1,1),DATE(2027,1,1),DATE(2026,1,1),0.05,A8,3) |
95.45454545 |
| Record 3 | =PRICEMAT(DATE(2026,1,1),DATE(2027,1,1),DATE(2026,1,1),0.05,A9,3) |
105 |