ODDLYIELD: Calculating the yield of a security with an odd last period


show more ODDLYIELD: Calculating the yield of a security with an odd last 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 ...

ODDLYIELD: Calculating the yield of a security with an odd last period

The bond related formulas and functions in the previous chapters assume that every period is of the same length. For example, that coupon payments occur every 3, 6 or 12 months. Some bonds have irregular first or last periods though, which means that the payments dates don't fit any of those patterns. For those securities Excel includes a set of functions you can use to evaluate them. In this movie, I'll show you how to calculate the yield of a security with an odd, meaning unusual, last period. To make that calculation, the first thing we need to no know is the settlement date and that that is the date that you take possession of the security.

Next we have the maturity date and that is the last day of the investment, when all principle and any other proceeds are returned to you. The last interest date is the last day that any interests through coupons are paid to you. The rate is the annual percentage rate of the investment. Then we have the price which is the price per $100 of...

ODDLYIELD: Calculating the yield of a security with an odd last period
Video duration: 2m 57s 2h 18m Intermediate

Viewers:

ODDLYIELD: Calculating the yield of a security with an odd last 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 ...