Difference between revisions of "Manuals/calci/XIRR"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">XIRR(V, dates, G)</font></font>'''</font> ...") |
|||
| Line 1: | Line 1: | ||
| − | + | XIRR(V, dates, G) | |
| − | + | *'''Where 'V' '''is a series of cash flows which equivalent to a schedule of payments in dates, | |
| + | * 'dates' is a schedule of payment dates which equivalent to the cash flow payments | ||
| + | *'G' is a number that you guess is close to the result of this function. | ||
| + | |||
| + | *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. | ||
| − | + | 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 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | XIRR(V, dates, G) | ||
<font color="#000000"><font face="Arial, sans-serif"><font size="2">B C</font></font></font> | <font color="#000000"><font face="Arial, sans-serif"><font size="2">B C</font></font></font> | ||
| Line 45: | Line 29: | ||
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2200 05-01-2010</font></font></font> | <font color="#000000"><font face="Arial, sans-serif"><font size="2">2200 05-01-2010</font></font></font> | ||
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2"> | + | <font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQ2b4aa68f40f8e8e8-nowiki-00000002-QINU</font></font></font> |
</div> | </div> | ||
Revision as of 06:23, 27 February 2014
XIRR(V, dates, G)
- Where 'V' is a series of cash flows which equivalent to a schedule of payments in dates,
- 'dates' is a schedule of payment dates which equivalent to the cash flow payments
- 'G' is a number that you guess is close to the result of this function.
- 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.
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
XIRR(V, dates, G) B C
-10000 &!02-01-2009&!
3000 04-01-2009
4300 11-30-2009
3250 03-15-2010
2200 05-01-2010
?UNIQ2b4aa68f40f8e8e8-nowiki-00000002-QINU?
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | -10000 | 02-01-2009 | ||
| Row2 | 3000 | 04-01-2009 | ||
| Row3 | 4300 | 11-30-2009 | ||
| Row4 | 3250 | 03-15-2010 | ||
| Row5 | 2200 | 05-01-2010 | ||
| Row6 | 0.3593 |
