writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + Line 7:
Line 7: − + − + − + − +
no edit summary
<div style="font-size:30px">'''IRR(v,g)'''</div><br/>
<div style="font-size:30px">'''IRR (CashFlowEvents,StartGuess,Accuracy,NoOfIterations)'''</div><br/>
*<math>v</math> is the array of values.
*<math>CashFlowEvents</math> is the array of values.
*<math>g</math> is the number is close to the result of IRR.
*<math>StartGuess</math> is the number is close to the result of IRR.
==Description==
==Description==
*The Internal Rate of Return is the interest rate that makes the Net Present Value zero.
*The Internal Rate of Return is the interest rate that makes the Net Present Value zero.
*<math>IRR</math> is similar to the net present value calculation.
*<math>IRR</math> is similar to the net present value calculation.
*In <math>IRR(v,g)</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>IRR (CashFlowEvents,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>g</math> is the guess which is indicating the number that you guess is close to the result of <math>IRR</math>.
*<math>g</math> is the guess which is indicating the number that you guess is close to the result of <math>IRR</math>.
*<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.
*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>CashFlowEvents</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).
*The calculation of <math>IRR</math> uses an iterative method.
*The calculation of <math>IRR</math> uses an iterative method.
*The value is starting from g value and doing the calculation until the result is accurate within 0.00001%.
*The value is starting from g value and doing the calculation until the result is accurate within 0.00001%.