PRICEDISC

Formulas / PRICEDISC
Calculate the price per $100 face value of a discounted security.
=PRICEDISC(sd, md, discount, redemption, [basis])
  • Settlement - the security's settlement date or the date the coupon is purchased
  • Maturity - the security's expiration date or the date it was issued
  • Discount - the security's discount rate
  • Redemption - the security's redemption value per $100 face value
  • Basis - [OPTIONAL] the financial day count basis used by the security

Examples

  • =PRICEDISC(A2,A3,A4,A5,A6)

    The PRICEDISC function is used to calculate the price of a bond within a given range. For example, this returns the price of a bond within the range specified in cells A2 to A6. The range must include the bond's face value, coupon rate, and redemption value.

  • =PRICEDISC(1000,5%,1050,0,2)

    If you want to calculate the price of a bond with a face value of $1000, a coupon rate of 5%, and a redemption value of $1050, use the formula above. This formula returns the price of the bond within the range of 0 to 2, which is the range specified in the last two arguments of the function.

  • =PRICEDISC(1000,5%,1050,0,2,TRUE)

    In addition to calculating the price of a bond, the PRICEDISC function can also be used to calculate the yield to maturity of the bond. This formula returns the yield to maturity of the bond within the range specified in the last two arguments of the function.

  • =PRICEDISC(1000,5%,1050,0,2,TRUE,TRUE)

    The PRICEDISC function can also be used to calculate the yield to call of a bond. This formula returns the yield

Summary

The PRICEDISC function calculates the discounted price of a security per $100 face value. It is useful for determining the price of a discounted security.

  • The PRICEDISC function returns the price per $100 face value of a discounted security, based on the arguments of settlement date, maturity date, discount rate, redemption value per $100 face value, and basis.
  • The basis argument controls how days are counted in a data set.


Frequently Asked Questions

What is the PRICEDISC Function?
The PRICEDISC function is a financial function used to return the price per $100 face value of a discounted security.
What are the Arguments for the PRICEDISC Function?
The arguments for the PRICEDISC function are settlement, maturity, discount, and redemption.
Can the PRICEDISC Function be Used with Dates Entered as Text?
Yes, the PRICEDISC function can be used with dates entered as text.
What Types of Data Does the PRICEDISC Function Calculate?
The PRICEDISC function calculates the price per $100 face value of a discounted security.
What is the Syntax of the PRICEDISC Function?
The syntax of the PRICEDISC function is:
  • PRICEDISC(settlement, maturity, discount, redemption)

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.