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.