ODDLPRICE
Formulas / ODDLPRICECalculate 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
=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.
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.
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?
How is the ODDLPRICE function used in Sourcetable?
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?
