Microsoft Office Tutorials and References
In Depth Information
PRICEDISC
The redemption value of the security per $100 face value.
REDEMPTION
The number of payments per year—Annual = 1; Semiannual = 2;
Quarterly = 4.
FREQUENCY
The day count basis to use.
BASIS
PRICE is calculated as follows:
Figure 6.29
Return the value of a
security based on price
per $100 face value
and periodic interest
payments with the
PRICE function.
A
Generate
the function
results with
cell referencing
PRICEDISC
PRICEDISC returns the value of a discounted security based on a price per $100 face value.
=PRICEDISC(settlement,maturity,discount,redemption,basis)
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.
SETTLEMENT
The security’s maturity date—the date when the security expires.
MATURITY
Search JabSto ::




Custom Search