ODDLPRICE

Formulas / ODDLPRICE
Calculate the price per $100 face value of a security with an odd last period.
=ODDLPRICE(sd, md, id, rate, yld, redem, freq, [basis])
  • Settlement - date of settlement
  • Maturity - date of maturity
  • Last_interest - date of last interest
  • Rate - security's coupon rate
  • Yld - security's yield
  • Redemption - security's redemption value at maturity
  • Basis - day count basis
  • European 30/360 - European day count basis
  • Leveraged Buyout Modeling - used in leveraged buyout modeling
  • FMVA Prep Course - used in a FMVA Prep Course
  • FMVA Required - FMVA required argument

Examples

    The ODDLPRICE function can be used to calculate the price of a bond with a given face value. The function takes eight parameters: settlement date, maturity date, last interest date, coupon rate, yield rate, face value, frequency, and basis. The function returns the price per $100 face value of the bond.

  • =ODDLPRICE(DATE(2018,2,5),DATE(2018,6,15),DATE(2017,10,15),0.05,0.06,100,2,0)

    For example, consider a bond with a settlement date of 5-Feb-2018, a maturity date of 15-Jun-2018, and a last interest date of 15-Oct-2017. The coupon rate is 0.05, the yield rate is 0.06, the face value is 100, the frequency is 2, and the basis is 0. To calculate the price of this bond, the ODDLPRICE function could be used with the above arguments.


Summary

The ODDLPRICE function calculates the price per $100 face value of a security with an odd last coupon period. This can help investors make informed decisions about investments with an odd last coupon period.

  • The ODDLPRICE function returns the price per $100 face value of a security with an irregular last period.
  • The basis argument controls how days are counted in the data set.
  • The ODDLPRICE function is useful for calculating the price of a bond with an irregular last payment, and returns a bond price.

Frequently Asked Questions

What is the ODDLPRICE function?
The ODDLPRICE function returns the price per $100 face value of a security with an odd last coupon period.
How is the ODDLPRICE function used in Sourcetable?
The ODDLPRICE function is used to calculate the price per $100 face value of a security with an odd last coupon period in Sourcetable. It takes the following parameters: settlement date, maturity date, issue date, rate, yield, redemption, frequency, and basis.
What are the parameters used in the ODDLPRICE function?
  • Settlement Date: The date when the security is purchased.
  • Maturity Date: The date when the security matures.
  • Issue Date: The date when the security was originally issued.
  • Rate: The interest rate paid by the security.
  • Yield: The yield of the security.
  • Redemption: The redemption value of the security.
  • Frequency: The frequency of interest payments.
  • Basis: The type of day count used.
How does Sourcetable calculate dates?
Sourcetable calculates dates as sequential serial numbers. A serial number is a unique number assigned to an item in a series. For example, the first day of January 1, 1900 is serial number 1, and the next day, January 2, 1900, is serial number 2.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV