Microsoft Office Tutorials and References
In Depth Information
The redemption value of the security per $100 face value.
The number of payments per year—Annual = 1; Semiannual = 2;
Quarterly = 4.
The day count basis to use.
PRICE is calculated as follows:
Return the value of a
security based on price
per $100 face value
and periodic interest
payments with the
PRICEDISC returns the value of a discounted security based on a price per $100 face value.
The PRICEDISC function returns the value of a discounted security based on a $100 face value.
The PRICEDISC function is found only if the Analysis Toolpak is installed. It must be turned on
using the Add-Ins command from the Tools menu. As you’ll notice in Figure 6.30, the
settlement date of the security is 11/11/1999 and the security’s maturity date is 12/15/1999. With a
discount rate of 5.3%, the redemption value of the security is $100 per face value. The day
count basis is Actual/actual.
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.