ODDFYIELD: Calculating the yield of a security with an odd first period


show more ODDFYIELD: Calculating the yield of a security with an odd first period provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Financial Functions in Depth show less
please wait ...

ODDFYIELD: Calculating the yield of a security with an odd first period

The bond related formulas and functions in the previous chapters assume that every period is the same length. For example, that coupon payments occur every 3, 6 or 12 months. Some bonds have irregular first or last periods where the payment dates don't fit any of those patterns. So, Excel includes a set of functions you can use to evaluate those securities. In this movie, I'll show you how to calculate the yield of a security with an odd, meaning unusual, first period. We're calculating yield, so we need to know the following things. In the worksheet you can see that we have the settlement date and that is the date that you actually take possession of a security.

The maturity date is when the investment ends and all monies and interest are due to you. Then the issue date. That is the date that the security was first offered. Then we have a first coupon date and that is the date when the first interest was paid to investors. Next have the rate that is the annual interest rates a...

ODDFYIELD: Calculating the yield of a security with an odd first period
Video duration: 3m 3s 2h 18m Intermediate

Viewers:

ODDFYIELD: Calculating the yield of a security with an odd first period provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Financial Functions in Depth

Subjects:
Business IT
Software:
Excel
Author:
please wait ...