ODDFYIELD

Formulas / ODDFYIELD
Calculate the yield of a security with an odd first period.
=ODDFYIELD(sd, md, id, fd, rate, pr, redem, freq, [basis], [numeric])
  • first_coupon - required, the first coupon date
  • rate - required, the security's interest rate
  • yld - required, the security's annual yield
  • redemption - required, the security's redemption value per $100 face value
  • frequency - required, the number of coupon payments per year
  • basis - [OPTIONAL] the type of day count basis to use for the calculation

Examples

  • =ODDFYIELD(C10,C12,C9,C11,C7,C5,C6,C13,C14)

    The ODDFYIELD function can be used to calculate the yield of a bond. For example, the formula will return the yield of a bond with a settlement date of 1-Feb-2019, maturity date of 15-Feb-2022, and coupon rate of 5%, with the first coupon paid on 15-Feb-2019.

  • =ODDFYIELD(C10,C12,C9,C11,C7,C5,C6,C13,C14)

    To calculate the yield of a bond, you can use the ODDFYIELD function. For example, if you have the settlement date of the bond in cell C10, the maturity date of the bond in cell C12, the coupon rate of the bond in cell C9, the first coupon paid on the bond in cell C11, the frequency of the coupon payments in cell C7, the Basis in C5, the Yield in C6, the accrued interest in cell C13, and the redemption value in cell C14, you can use the formula above to calculate the yield of the bond.

Summary

The ODDFYIELD function is used to calculate the yield of a security with an odd first period.

  • The ODDFYIELD function returns the yield of a security with an odd first period as a percentage. The required arguments for the ODDFYIELD function are sd (settlement date), md (maturity date), id (issue date), fd (first coupon date), rate (interest rate), pr (price), redem (redemption value), freq (coupon frequency), and [basis] (optional).
  • The basis argument controls how days are counted in the calculation and is an optional parameter.


Frequently Asked Questions

What is the ODDFYIELD function?
The ODDFYIELD function calculates the return on a security.
What type of return does the ODDFYIELD function calculate?
The ODDFYIELD function calculates the return on a security.
What kind of data does the ODDFYIELD function require?
The ODDFYIELD function requires the following data:
  • The security's settlement date and maturity date
  • The security's issue date
  • The security's investment rate
  • The security's redemption value
  • The security's frequency
  • The security's basis
What type of value does the ODDFYIELD function return?
The ODDFYIELD function returns a numeric value.
How accurate is the ODDFYIELD function?
The ODDFYIELD function is very accurate and should be used for accurate calculations.
What are some common uses for the ODDFYIELD function?
The ODDFYIELD function is commonly used to calculate the return on investment for certain securities.
What are some advantages of using the ODDFYIELD function?
The ODDFYIELD function provides a quick and accurate way to calculate the return on investment for a security. It is also easy to use and requires minimal input data.

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