Returns the price per $100 face value of a security that pays interest at maturity.
תחביר
PRICEMAT(settlement, maturity, issue, rate, yld, [basis])ארגומנטים
settlementחובה
The security's settlement date.
maturityחובה
The security's maturity date.
issueחובה
The security's issue date.
rateחובה
The security's interest rate at date of issue.
yldחובה
The security's annual yield.
basisאופציונלי
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.