writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + +
no edit summary
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.