Learn How to Use Microsoft Excel ODDFPRICE Function

Microsoft Excel ODDFPRICE Function

The main purpose of the Microsoft Excel ODDFPRICE function is to get the price per $100 odd first period. That implies, with the help of the ODDFPRICE function you can able to return the price per $100 face value of a security with an odd or irregular first period. So, with the help of the ODDFPRICE function, you can able to the price per $100 odd first period.

Return Value of ODDFPRICE Function

The return value will be the bond price. 

Syntax of ODDFPRICE Function

=ODDFPRICE(sd, md, id, fd, rate, yld, redem, freq, [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.
• fd - This is the date of the first coupon.
• rate - This is the annual coupon rate of security.
• yld - This is the annual required rate of return.
• redem - This is the redemption value per $100 face value.
• freq - This is the coupon payments per year, where, annual = 1, semiannual = 2; quarterly = 4.
• basis - This is the day count basis, that's defaults to 0 (optional).

How to Use Microsoft Excel ODDFPRICE Function?

So we know that Microsoft Excel ODDFPRICE function you can able to get the price per $100 odd first period. That implies, with the help of the ODDFPRICE function you can able to return the price per $100 face value of a security with an odd or irregular first period. So, with the help of the ODDFPRICE function, you can able to the price per $100 odd first period.

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