Microsoft Office Tutorials and References
In Depth Information
ODDFYIELD
Figure 6.26
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
function.
A
The function
built with cell
referencing
ODDFYIELD
ODDFYIELD returns the security yield with an odd first period.
=ODDFYIELD(settlement,maturity,issue,first_coupon,pr,yield,redemption,frequency,
basis)
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.
SETTLEMENT
The security’s maturity date—the date when the security expires.
MATURITY
The security’s actual issue date.
ISSUE
The date of the security’s first coupon.
FIRST_COUPON
The price of the security.
PR
The annual yield of the security.
YIELD
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
ODDLPRICE
ODDLPRICE returns the per $100 face value of a security having an odd last coupon period.
=ODDLPRICE(settlement,maturity,last_interest,rate,yield,redemption,frequency,basis)
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.
Search JabSto ::




Custom Search