Learn How to Use Microsoft Excel PRICEMAT Function

Microsoft Excel PRICEMAT Function

The main purpose of the Microsoft Excel PRICEMAT function is to get the price per $100 interest at maturity. That implies, with the help of the PRICEMAT function you can able to return the price per $100 face value of a security that pays interest at maturity. So, with the help of the PRICEMAT function, you can able to get the price per $100 interest at maturity.

Return Value of PRICEMAT Function

The return value will be the bond price. 

Syntax of PRICEMAT Function

=PRICEMAT(sd, md, is, rate, yld, [basis])

Where the arguments:

• sd: This is the settlement date of the security.
• md: This is the maturity date of the security.
• id: This is the issue date of the security.
• rate: This is the interest rate of the security on issuing date.
• yld: This is the annual yield of the security.
• basis: This is the day count basis, and defaults to 0 (optional).

How to Use Microsoft Excel PRICEMAT Function?

So we know that Microsoft Excel PRICEMAT function you can able to get the price per $100 interest at maturity. That implies, with the help of the PRICEMAT function you can able to return the price per $100 face value of a security that pays interest at maturity. So, with the help of the PRICEMAT function, you can able to get the price per $100 interest at maturity.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel