# PRICE function in Excel

## Use

If you purchased a security that pays periodic interest, you can calculate the price per \$100 face value of that security by using the PRICE function in Excel.

## Syntax

PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])

The PRICE function has the following arguments:

settlement – Required. The security’s settlement date, it comes after the issuance date when the security is traded to the buyer.

maturity – Required. The expiry date of the security.

rate – Required. The annual coupon rate of the security.

yld – Required. The annual yield of the security.

redemption – Required. The redemption value per \$100 face value of the security.

frequency – Required. The frequency of coupon payments per year. It must be one of the following:

 For Frequency Annual Payments 1 Semiannual 2 Quarterly 4

[basis] – Optional. The day count basis that is used in the calculation. Available options are:

 Basis Day count basis 0 or omitted US (NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360

## Example

Suppose, a 10-year bond (with a redemption value of \$100 on maturity) is issued on February 10, 2020. It pays 6.5% coupon annually and has an annual yield of 6.9%. If you purchased the bond on June 30, 2020, the price of the bond can be calculated as mentioned hereunder:

The bond with the above terms has the price of \$97.204.

## Function Errors

 Error Occurs #VALUE! If the settlement or maturity date is not valid. #NUM! If the annual yield or the coupon rate is smaller than zero. #NUM! If the redemption value is equal to or smaller than zero. #NUM! If frequency is any number other than 1, 2, or 4 #NUM! If the [basic] argument is either smaller than zero or greater than 4. #NUM! If settlement ≥ maturity.

## Related Functions

The PRICE function is a Financial function, it has the following similar functions:

PRICEDISC function calculates the price per \$100 face value of a discounted security.

PRICEMAT function calculates the price per \$100 face value of a security (e.g. a bond) that pays interest at maturity.

TBILLPRICE function calculates the price of a Treasury bill.

DOLLARDE function converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.