Manuals/calci/IRR - Revision history

Devika: /* Examples */

2022-05-27T10:52:25Z

Examples

Devika at 22:57, 23 July 2018

2018-07-23T22:57:36Z

Devika at 22:56, 23 July 2018

2018-07-23T22:56:36Z

Devika at 22:52, 23 July 2018

2018-07-23T22:52:31Z

Swapna at 02:18, 2 March 2018

2018-03-02T02:18:54Z

Jayaram at 10:52, 14 March 2017

2017-03-14T10:52:05Z

Swapna at 18:08, 19 July 2015

2015-07-19T18:08:06Z

Devika: /* References */

2015-06-03T17:19:15Z

References

Devika: /* Examples */

2014-12-21T10:24:55Z

Examples

Devika: /* Examples */

2014-03-31T06:39:04Z

Examples

@@ Line 50: / Line 50: @@
 |}
 #=IRR(A1:A6)=11.88%
 #=IRR(A1:A5,20%) = -3.45%
 #=IRR(B1:B7) = 7.31%%
 #=IRR(B1:B5,5%)= -12.47%
 ==Related Videos==

@@ Line 4: / Line 4: @@
 *<math>Accuracy</math> is the correct of decimal places of the result.
 *<math>NoOfIterations</math> is the number of iterations.
 ==Description==

@@ Line 2: / Line 2: @@
 *<math>CashFlowEvents</math>  is the array of values.
 *<math>StartGuess</math> is the number is close to the result of IRR.
 ==Description==
@@ Line 8: / Line 10: @@
 *<math>IRR</math> is similar to the  net present value calculation.
 *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>StartGuess</math> is the guess which is indicating the number that you guess is close to the result of <math>IRR</math>.
 *<math>CashFlowEvents</math> must have atleast one positive and one negative value to find the internal rate of return.
 *The value of <math>CashFlowEvents</math> can be array or reference argument contains text, logical values or empty cells, the values which are ignored.

@@ Line 1: / Line 1: @@
-<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==
@@ Line 7: / Line 7: @@
 *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.
-*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>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 value is starting from g value and doing the calculation until the result is accurate within 0.00001%.

@@ Line 47: / Line 47: @@
 |}
-#=IRR(A1:A6)=12.04%
+#=IRR(A1:A6)=11.88%
-#=IRR(A1:A5,20%) = 11.88%
+#=IRR(A1:A5,20%) = -3.45%
 #=IRR(B1:B7) = 7.31%%
 #=IRR(B1:B5,5%)= -12.47%

← Older revision		Revision as of 10:52, 14 March 2017
Line 65:		Line 65:
	==References==		==References==
	[http://www.techonthenet.com/excel/formulas/irr.php Internal rate of return]		[http://www.techonthenet.com/excel/formulas/irr.php Internal rate of return]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 17:19, 3 June 2015
Line 59:		Line 59:
	*[[Manuals/calci/XNPV \| XNPV ]]		*[[Manuals/calci/XNPV \| XNPV ]]

−	==References==	+	==References==
		+	[http://www.techonthenet.com/excel/formulas/irr.php Internal rate of return]

@@ Line 22: / Line 22: @@
 ==Examples==
 {| class="wikitable"
 |-
 ! !! A !! B
@@ Line 48: / Line 47: @@
 |}
-#=IRR(A1:A6)=11.88%
+#=IRR(A1:A6)=12.04%
-#=IRR(A1:A5,20%) = -3.45%
+#=IRR(A1:A5,20%) = 11.88%
-#=IRR(B1:B7) = 6.7%
+#=IRR(B1:B7) = 7.31%%
-#=IRR(B1:B5,5%)= -160.99%
+#=IRR(B1:B5,5%)= -12.47%
 ==See Also==

@@ Line 24: / Line 24: @@
 |+1..10@SQRT
 |-
 ! !! A !! B
 |-
-| -100000 || -500000
+! 1
-! 2
+| -100000 || -500000
 |-
 | 10000 || 32000
 ! 3
 |-
 ! 4
 |-
 ! 5
 |-
 ! 6
 |-
-| 59000 || 275000
+! 7
 |1000 ||67000
 |}
@@ Line 52: / Line 52: @@
 #=IRR(B1:B7) = 6.7%
 #=IRR(B1:B5,5%)= -160.99%
 ==See Also==