ExcelFlux

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

RowA
6Input
70.05
80.1
90
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 examples

Worked 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
Microsoft Excel reference