Friday 5 May 2017

Excel - Microsoft Excel Pricemat Function

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