Microsoft Office Tutorials and References
In Depth Information
XIRR
Figure 6.40
For a period you
specify, VDB returns
the depreciation of
an asset.
A
Building the
function with
cell referencing
XIR For a schedule of cash flows that are not necessarily periodic, XIRR returns the internal rate
of return.
=XIRR(values,dates,guess)
The XIRR function returns the internal rate of return for a schedule of cash flows. The XIRR
function is found only if the Analysis Toolpak is installed. It must be turned on using the
Add-Ins command from the Tools menu.
A series of cash flows that corresponds to a series of dates.
VALUES
A series of payment dates that corresponds to a series of payments.
DATES
A guess number of the result.
GUESS
XIRR is calculated as follows:
XNP For a schedule of cash flows that are not necessarily periodic, XNPV returns the present value.
=XNPV(rate,values,dates)
The XNPV function returns the present value for a series of cash flows. This function is found
only if the Analysis Toolpak is installed. It must be turned on using the Add-Ins command
from the Tools menu.
Search JabSto ::




Custom Search