Learn How to Use Microsoft Excel PRICEDISC Function

Microsoft Excel PRICEDISC Function

The main purpose of the Microsoft Excel PRICEDISC function is to get the price per $100 discounted security. That implies, with the help of the PRICEDISC function you can able to return the price per $100 face value of a discounted security. So, with the help of the PRICEDISC function, you can able to get the price per $100 discounted security.

Return Value of PRICEDISC Function

The return value will be the bond price. 

Syntax of PRICEDISC Function

=PRICEDISC(sd, md, discount, redemption, [basis])

Where the arguments:

• sd: This is the settlement date of the security.
• md: This is the maturity date of the security.
• discount: This is the discount rate of the security.
• redemption: This is the redemption value per $100 face value.
• basis: This is the day count basis, and defaults to 0 (optional).

How to Use Microsoft Excel PRICEDISC Function?

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

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