COUPDAYBS: Calculating total days between coupon beginning and settlement


show more COUPDAYBS: Calculating total days between coupon beginning and settlement 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 ...

COUPDAYBS: Calculating total days between coupon beginning and settlement

Bonds that pay interest prior to maturity are know as coupon bonds. When you purchase a bond you should know how far into a coupon period you are buying the bond so you can tell how long enough you'll have to wait to receive your first interest payment. You can calculate the number of days between the coupon beginning and settlement date using the coupon days between beginning settlement function, which is abbreviated COUPDAYBS. So to create the formula you need to now the following are four values. The first is the settlement date. That is the date that you take possession of the investment or you basically by in.

Then you have the maturity date, which is the date that proceeds from the investment are due to you. Then you have coupon frequency. Now I mentioned that coupons are payments for a bond. Coupons can occur within Excel either once a year, twice a year, or four times a year. So annually, semiannually or quarterly. And then finally we have the basis and the basis is the method t...

COUPDAYBS: Calculating total days between coupon beginning and settlement
Video duration: 3m 2s 2h 18m Intermediate

Viewers:

COUPDAYBS: Calculating total days between coupon beginning and settlement 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 ...