Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/XIRR
(view source)
Revision as of 11:25, 27 February 2014
81 bytes added
,
11:25, 27 February 2014
no edit summary
Line 1:
Line 1:
−
XIRR(V,
dates
, G)
+
<div style="font-size:30px">'''
XIRR(V,
Dates
, G)
'''</div><br/>
−
*
'''Where '
V
' '''
is a series of cash flows which equivalent to a schedule of payments in dates
,
+
*
<math>
V
</math>
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
+
*
<math>Dates</math>
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.
+
*
<math>
G
</math>
is a number that you guess is close to the result of this function.
−
+
+
==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.
Abin
writer
5,435
edits