{"id":929,"date":"2019-04-22T17:58:43","date_gmt":"2019-04-22T14:58:43","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=929"},"modified":"2019-04-22T17:59:37","modified_gmt":"2019-04-22T14:59:37","slug":"the-pricemat-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-pricemat-function\/","title":{"rendered":"The PRICEMAT Function"},"content":{"rendered":"\n

It calculates the price per $100 face value of a security that pays interest at maturity.<\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

PRICEMAT<\/strong>(settlement<\/strong>, maturity, issue, rate, yield, [basis]<\/b><\/span><\/em>) <\/p>settlement<\/strong>: The settlement date of the security.
maturity<\/strong>: The maturity date of the security.
issue<\/strong>: The issue date of the security.
rate<\/strong>: The annual interest rate of the security at the date of issue.
yield<\/strong>: The annual yield of the security.
[basis]<\/strong>: Optional. The type of day count basis (default is 0).
<\/cite><\/blockquote>\n\n\n\n

If the dates entered are not valid dates the function returns a #VALUE! error.<\/p>\n\n\n\n

If yield or rate are less than or equal to zero the #NUM! error is returned.<\/p>\n\n\n\n

If basis is not inside the valid values (between 0 and 4) the #NUM! error is returned.<\/p>\n\n\n\n

If the settlement date is after the maturity date the #NUM! error is returned<\/p>\n\n\n\n

<\/div>\n\n\n\n\n
<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the PRICEMAT function:<\/strong><\/p>\n\n\n\n

Use the proper function in the cell C2, to calculate the price per 100 dollars face value of a security that pays interest at maturity. All the information you need is displayed in the current worksheet.<\/p>\n\n\n\n

\n