Microsoft Office Tutorials and References
In Depth Information
The discount rate applied to the cash flows.
A series of cash flows that corresponds to a series of dates.
A series of payment dates that corresponds to a series of payments.
XNPV is calculated as follows:
Based on a yield that pays periodic interest, YIELD returns the yield of the security.
The YIELD function returns the yield on a security that pays on period interest. This is a
function found only if the Analysis Toolpak is installed. It must be turned on using the Add-Ins
command from the Tools menu. In Figure 6.41, for example, the settlement date of the security is
11/15/1999 and the maturity date is 2/9/2009. The rate is 5.8% and the security’s price per $100
face value is $98. The frequency is semiannually, and the basis is 30/360(4), resulting with 6.08%.
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—when the security expires.
The interest rate of the security.
The price of the security.
The redemption value of the security per $100 face value.
The number of the payments per year—Annual = 1; Semiannual = 2;
Quarterly = 4.
The day count basis to use.
YIELD can be calculated as: