writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 8:
Line 8: + + + + + − The numbers in dates should be valid dates. − XIRR shows the error value − whenever any number in dates precedes the starting date or values − dates contain a different number of values. − In most cases no need to provide guess − Lets see an example+
→Description
*This function computes the internal rate of return for a schedule of cash flows that is not essentially periodic.
*This function computes the internal rate of return for a schedule of cash flows that is not essentially periodic.
*This function suppose at least one positive cash flow and one negative cash flow.
*This function suppose at least one positive cash flow and one negative cash flow.
*The numbers in dates should be valid dates.
*In most cases no need to provide guess
XIRR shows the error value:
1.whenever any number in dates precedes the starting date or values
2.<math>Dates</math> contain a different number of values.
==Example==
XIRR(V, dates, G)
XIRR(V, dates, G)