Microsoft Office Tutorials and References
In Depth Information
DISC
A
This function is a result of cell referencing
Figure 6.14
The DDB function
returns the asset
depreciation for a
period using the
double-declining
balance method,
or another method
specified by you.
DIS DISC returns the security discount rate.
=DISC(settlement,maturity,pr,redemption,basis)
The DISC function is found only if the Analysis Toolpak is installed. It must be turned on using
the Add-Ins command from the Tools menu. You’ll notice in Figure 6.15 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 11/15/1999. The security price per $100 face value is $95. The
redemption value is $100. And the basis is Actual/360. The bond discount rate equals 9.92%.
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 security price per $100 face value.
PR
The security redemption value per $100 face value.
REDEMPTION
The day count basis to use.
BASIS
Search JabSto ::




Custom Search