writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <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>+ + + + + + − <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'V' '''</font></font><font face="Arial, sans-serif"><font size="2">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 and 'G' is a number that you guess is close to the result of this function.</font></font></font>+ + + + + − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function computes the internal rate of return for a schedule of cash flows that is not essentially periodic. </font></font></font></div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − * <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function suppose at least one positive cash flow and one negative cash flow.</font></font></font> − − * <font color="#000000"><font face="Arial, sans-serif"><font size="2">The numbers in dates should be valid dates. </font></font></font> − * <font color="#000000"><font face="Arial, sans-serif"><font size="2">XIRR shows the error value whenever any number in dates precedes the starting date or values and dates contain a different number of values.</font></font></font> − * <font color="#000000"><font face="Arial, sans-serif"><font size="2">In most cases no need to provide guess</font></font></font> − − <br /><br /> − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − XIRR − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font> − − <font color="#000000"><font face="Arial, sans-serif"><font size="2">XIRR(V, dates, G)</font></font></font> + Line 45:
Line 29: − +
no edit summary
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>
<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"><nowiki>=XIRR(B2:B6,C2:C6,0.5) is 0.3593</nowiki></font></font></font>
<font color="#000000"><font face="Arial, sans-serif"><font size="2">UNIQ2b4aa68f40f8e8e8-nowiki-00000002-QINU</font></font></font>
</div>
</div>