Microsoft Office Tutorials and References
In Depth Information
ODDLYIELD
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 last security coupon date.
LAST_INTEREST
The annual yield of the security.
YIELD
The redemption value of the security per $100 face value.
ReEDEMPTION
The number of payments per year—Annual = 1; Semiannual = 2;
Quarterly = 4.
FREQUENCY
The day count basis to use.
BASIS
ODDLYIELD
ODDLYIELD returns the security yield that has an odd last period.
=ODDLYIELD(settlement,maturity,last_interest,rate,pr,redemption,frequency,basis)
Using the ODDLYIELD function returns the yield of a security with an odd last period. The
ODDLYIELD function is found only if the Analysis Toolpak is installed. It must be turned on
using the Add-Ins command from the Tools menu.
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 last security coupon date.
LAST_INTEREST
The interest rate of the security.
RATE
The price of the security.
PR
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
ODDLYIELD is calculated as follows:
Search JabSto ::




Custom Search