Microsoft Office Tutorials and References
In Depth Information
The salvage value of the asset at the end of the asset life.
The period of depreciation.
The rate of the asset depreciation.
The year basis to use.
function returns the
depreciation of an
asset for each
Building a function
with cell referencing
COUPDAYBS returns the number of days from the beginning of the period to the coupon-period
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
The security’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
The security’s maturity date. The date when the security expires.
The number of payments per year—Annual = 1; Semiannual = 2;
Quarterly = 4.
The day count basis to use. If omitted, 0 is used. See additional choices
in Figure 6.5.