Microsoft Office Tutorials and References
In Depth Information
This function is a result of cell referencing
The DDB function
returns the asset
depreciation for a
period using the
or another method
specified by you.
DIS DISC returns the security discount rate.
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
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 security price per $100 face value.
The security redemption value per $100 face value.
The day count basis to use.