Microsoft Office Tutorials and References
In Depth Information
COUPDAYBS
The salvage value of the asset at the end of the asset life.
SALVAGE
The period of depreciation.
PERIOD
The rate of the asset depreciation.
RATE
The year basis to use.
BASIS
Figure 6.4
The AMORLINC
function returns the
depreciation of an
asset for each
accounting period.
A
Building a function
with cell referencing
COUPDAYBS
COUPDAYBS returns the number of days from the beginning of the period to the coupon-period
settlement date.
=COUPDAYBS(settlement,maturity,frequency,basis)
The COUPDAYBS function is found only if the Analysis Toolpak is installed. It must be turned on
using the Add-Ins command from the Tools menu. Notice in Figure 6.5, the bond settlement
date (the date a buyer purchases a coupon such as a bond) is 5/15/1999 and the maturity
date (the date the bond expires) is 7/15/2000. The frequency is semiannual and the basis is
Actual/actual. And the number of days between the coupon day and the settlement is 120. By
using cell referencing instead of applying the dates in the formula, your formula becomes
more flexible.
The security’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
SETTLEMENT
The security’s maturity date. The date when the security expires.
MATURITY
The number of payments per year—Annual = 1; Semiannual = 2;
Quarterly = 4.
FREQUENCY
The day count basis to use. If omitted, 0 is used. See additional choices
in Figure 6.5.
BASIS
Search JabSto ::




Custom Search