Excel

ODDLYIELD: Excel Formulae Explained

How do you use ODDLYIELD in Excel?

ODDLYIELD is a function in Excel that calculates the yield of an investment that pays periodic dividends. The function takes four arguments: the number of periods, the annual dividend, the present value, and the future value. The function returns the yield as a decimal value.

What is the syntax of ODDLYIELD in Excel?

ODDLYIELD is an Excel function that calculates the yield from a bond that pays odd coupons. The syntax for ODDLYIELD is as follows:

=ODDLYIELD(bond_price,coupon_rate,maturity_date,yield_to_maturity)

In this function, bond_price is the price of the bond, coupon_rate is the annual coupon rate, maturity_date is the date of maturity, and yield_to_maturity is the yield to maturity.

What is an example of how to use ODDLYIELD in Excel?

ODDLYIELD is a function in Excel that calculates the yield of an investment that pays dividends at odd intervals. The function takes four arguments: the number of years for the investment, the number of payments per year, the payment amount, and the yield. The function returns the yield for the investment. An example of how to use the function is shown below:

ODDLYIELD(5,4,1000,8)

This function calculates the yield for an investment that pays dividends at odd intervals over a five-year period. The investment pays four payments per year, with a payment amount of 1000, and an 8% yield. The function returns a yield of 9.5%.

When should you not use ODDLYIELD in Excel?

ODDLYIELD should not be used in Excel under the following circumstances:

1. When the calculation results in an error.

2. When the function is used to calculate a bond's yield to maturity.

3. When the function is used to calculate a bond's yield to call.

4. When the function is used to calculate a bond's yield to Worst.

What are some similar formulae to ODDLYIELD in Excel?

There are a few similar formulae to ODDLYIELD in Excel. The first is DIVIDENDYIELD, which calculates the annual dividend payment as a percentage of the current share price. The second is NOMINALYIELD, which calculates the annual nominal dividend payment as a percentage of the current share price. The third is CURRENTYIELD, which calculates the annual dividend payment as a percentage of the current market value of the shares. The fourth is YIELD, which calculates the annual dividend payment as a percentage of the current share price divided by the current market value of the shares. The fifth is GAYLORD, which calculates the annual dividend payment as a percentage of the current share price multiplied by the number of days since the last dividend payment. The sixth is DIVIDENDGROWTH, which calculates the annual dividend payment growth as a percentage of the current share price. The seventh is EARNINGSYIELD, which calculates the annual earnings payment as a percentage of the current share price. The eighth is PRICE/Earning, which calculates the current share price as a multiple of the annual earnings payment. The ninth is BOOKVALUE/Earning, which calculates the current market value of the shares as a multiple of the annual earnings payment. The tenth is RETURN, which calculates the annual return on investment as a percentage of the initial investment.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.