Changes

<div style="font-size:30px">'''XIRR(v,d,g,ac,nt)'''</div><br/>

<div style="font-size:30px">'''XIRR(v,d,g,ac,nt)'''</div><br/>

*<math>v</math> is the array of values.

*<math>d</math>  is the date value.

 

*<math>g</math> is the starting number is close to the result of XIRR.

*<math>CashFlowEvents</math> is the array of values.

*<math>ac </math> is the accuracy value.

*<math>Dates</math>  is the date value.

*<math>nt </math> is the number of iterations.

*<math>StartGuess</math> is the starting number is close to the result of XIRR.

*<math>Accuracy</math> is the accuracy value.

*<math>NoOfIterations </math> is the number of iterations.

==Description==

==Description==

*<math>XIRR</math> function uses the iterative process to calculate the returns, so it is not possible to trial by hand.  

*<math>XIRR</math> function uses the iterative process to calculate the returns, so it is not possible to trial by hand.  

*So this is most powerful function in CALCI.  

*So this is most powerful function in CALCI.  

*In  <math>XIRR(v,d,g,ac,nt)</math> ,<math>v</math> is an values which is the array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.

*In  <math>XIRR (CashFlowEvents,Dates,StartGuess,Accuracy,NoOfIterations)</math> ,<math>CashFlowEvents</math> is an values which is the array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.

*<math>v</math> must have atleast one positive and one negative value to find the internal rate of return.

*<math>CashFlowEvents</math> must have atleast one positive and one negative value to find the internal rate of return.

*Normally the first payment is optional,so the corresponding payment that occurs at the beginning of the investment.  

*Normally the first payment is optional,so the corresponding payment that occurs at the beginning of the investment.  

*Then the first payment should be negative value.

*Then the first payment should be negative value.

*<math>d</math> is the date value which is indicating the schedule of the payment.

*<math>Dates</math> is the date value which is indicating the schedule of the payment.

*Also the first payment date is the beginning of the schedule of payments.

*Also the first payment date is the beginning of the schedule of payments.

*And date should entered in [[Manuals/calci/DATE | DATE ]] function format.  

*And date should entered in [[Manuals/calci/DATE | DATE ]] function format.  

*<math>g</math> is the guess which is indicating the number that you guess is close to the result of <math>XIRR</math>.  

*<math>StartGuess</math> is the guess which is indicating the number that you guess is close to the result of <math>XIRR</math>.  

*<math>ac</math> is the accuracy value .

*<math>Accuracy</math> is the accuracy value .

*<math>nt</math> is the number of iterations.  

*<math>NoOfIterations</math> is the number of iterations.  

*suppose when we are omitting the value of <math>nt</math>,by default it will consider as 10.  

*suppose when we are omitting the value of <math>NoOfIterations</math>,by default it will consider as 10.  

*The value of <math>v</math> can be array or reference argument contains text, logical values or empty cells, the values which are ignored.

*The value of <math>v</math> can be array or reference argument contains text, logical values or empty cells, the values which are ignored.

*The <math>g</math> value is optional, when we are omitting the <math>g</math> value,by default it will consider the value as 10%(0.1).

*The <math>StartGuess</math> value is optional, when we are omitting the <math>StartGuess</math> value,by default it will consider the value as 10%(0.1).

*This function is using iterative technique, so we can't find a result after 100 iterations.  

*This function is using iterative technique, so we can't find a result after 100 iterations.  

*So the rate is changed until:

*So the rate is changed until:

   1. Any date is not a valid date or not in a date function format.

   1. Any date is not a valid date or not in a date function format.

   2. Any date is precedes the starting date.

   2. Any date is precedes the starting date.

   3. Also v and d is having different number of values.

   3. Also CashFlowEvents and Dates is having different number of values.

==Examples==

==Examples==