Microsoft Office Tutorials and References
In Depth Information
To return the value of a
security based on a per
$100 face value and
an odd (short or long)
first period you should
use the ODDFPRICE
built with cell
ODDFYIELD returns the security yield with an odd first period.
The ODDFYIELD 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.
The security’s maturity date—the date when the security expires.
The security’s actual issue date.
The date of the security’s first coupon.
The price of the security.
The annual yield of the security.
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.
ODDLPRICE returns the per $100 face value of a security having an odd last coupon period.
The ODDLPRICE function is used to return the price per $100 face value with an odd last
period. As with many other functions, it is found only if the Analysis Toolpak is installed.
You must turn it on using the Add-Ins command from the Tools menu.