Description
The Excel Pricemat function calculates the price, per $100 face value of a security that pays interest at maturity.
The syntax of the function is :
PRICEMAT( settlement, maturity, issue, rate, yld, [basis] )
Where the arguments are as follows:
Excel Pricemat Function Example
In the following example, the Excel Pricemat function is used to calculate the price per $100 face value of a security that pays interest at maturity. The security's issue date is 01-Jan-2011, the settlement date is 01-Apr-2011, and the maturity date is 31-Mar-2015. The rate of interest at issue is 4.5% and the annual yield is 2.5%. The US (NASD) 30/360 day count basis is used:
Pricemat Function Errors
If you get an error from the Pricemat function, this is likely to be one of the following:
Common Errors
No comments:
Post a Comment