Returns the price per $100 face value of a security that pays interest at maturity.
Syntaxis
PRICEMAT(settlement, maturity, issue, rate, yld, [basis])Argumenten
settlementvereist
The security's settlement date.
maturityvereist
The security's maturity date.
issuevereist
The security's issue date.
ratevereist
The security's interest rate at date of issue.
yldvereist
The security's annual yield.
basisoptioneel
The type of day count basis to use.
The PRICEMAT function calculates the price of a bond that pays interest only at the maturity date. It is commonly used for securities where the interest is not paid periodically but is instead accumulated and paid out when the bond matures.
=PRICEMAT("2023-01-01", "2024-01-01", "2022-01-01", 0.05, 0.04, 0)→100.9524Calculates the price for a bond with a 5% coupon rate and 4% yield, using the US 30/360 basis.
Enter dates
Ensure your settlement, maturity, and issue dates are entered in a format Excel recognizes as dates.
Input rates
Provide the annual interest rate and the desired annual yield as decimal values or percentages.
Calculate price
Apply the PRICEMAT function to return the price per $100 face value.
If omitted, Excel defaults to 0, which corresponds to the US (NASD) 30/360 day count basis.
No, PRICEMAT is specifically for securities that pay interest only at maturity.