hardgrafting
New Member
- Joined
- Feb 6, 2017
- Messages
- 25
Hi,
I am trying to work out the IRR of the below set of cash flows, with the formula being =(1+IRR(A94:AJ94))^12-1
[TABLE="width: 5317"]
<tbody>[TR]
[TD="class: xl93, width: 92"] [/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 5317"]
<tbody>[TR]
[TD="class: xl93, width: 92"] 660,512 [/TD]
[TD="class: xl93, width: 91"] 660,512 [/TD]
[TD="class: xl93, width: 91"] (3,672,280)[/TD]
[TD="class: xl93, width: 91"] 162,754 [/TD]
[TD="class: xl93, width: 91"] 163,090 [/TD]
[TD="class: xl93, width: 91"] (3,672,280)[/TD]
[TD="class: xl93, width: 90"] 38,606 [/TD]
[TD="class: xl93, width: 90"] 38,624 [/TD]
[TD="class: xl93, width: 90"] 38,906 [/TD]
[TD="class: xl93, width: 90"] 52,133 [/TD]
[TD="class: xl93, width: 90"] 163,169 [/TD]
[TD="class: xl93, width: 90"] 163,519 [/TD]
[TD="class: xl93, width: 90"] 48,625 [/TD]
[TD="class: xl93, width: 90"] 55,885 [/TD]
[TD="class: xl93, width: 90"] 55,993 [/TD]
[TD="class: xl93, width: 90"] 56,161 [/TD]
[TD="class: xl93, width: 90"] 56,279 [/TD]
[TD="class: xl93, width: 90"] 56,422 [/TD]
[TD="class: xl93, width: 90"] 56,600 [/TD]
[TD="class: xl93, width: 90"] 56,710 [/TD]
[TD="class: xl93, width: 90"] 151,806 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] (42,353)[/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 22,912 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 88,178 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] (511,564)[/TD]
[/TR]
</tbody>[/TABLE]
The result returns 435731.6% which is not sensible. Any ides why this could be? I deleted the last cash flow - 511k and the number becomes sensible (around 20%), however I need the IRR with the last cash flow included
I am trying to work out the IRR of the below set of cash flows, with the formula being =(1+IRR(A94:AJ94))^12-1
[TABLE="width: 5317"]
<tbody>[TR]
[TD="class: xl93, width: 92"] [/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 91"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[TD="class: xl93, width: 90"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 5317"]
<tbody>[TR]
[TD="class: xl93, width: 92"] 660,512 [/TD]
[TD="class: xl93, width: 91"] 660,512 [/TD]
[TD="class: xl93, width: 91"] (3,672,280)[/TD]
[TD="class: xl93, width: 91"] 162,754 [/TD]
[TD="class: xl93, width: 91"] 163,090 [/TD]
[TD="class: xl93, width: 91"] (3,672,280)[/TD]
[TD="class: xl93, width: 90"] 38,606 [/TD]
[TD="class: xl93, width: 90"] 38,624 [/TD]
[TD="class: xl93, width: 90"] 38,906 [/TD]
[TD="class: xl93, width: 90"] 52,133 [/TD]
[TD="class: xl93, width: 90"] 163,169 [/TD]
[TD="class: xl93, width: 90"] 163,519 [/TD]
[TD="class: xl93, width: 90"] 48,625 [/TD]
[TD="class: xl93, width: 90"] 55,885 [/TD]
[TD="class: xl93, width: 90"] 55,993 [/TD]
[TD="class: xl93, width: 90"] 56,161 [/TD]
[TD="class: xl93, width: 90"] 56,279 [/TD]
[TD="class: xl93, width: 90"] 56,422 [/TD]
[TD="class: xl93, width: 90"] 56,600 [/TD]
[TD="class: xl93, width: 90"] 56,710 [/TD]
[TD="class: xl93, width: 90"] 151,806 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] (42,353)[/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 22,912 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 227,677 [/TD]
[TD="class: xl93, width: 90"] 88,178 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] 273,212 [/TD]
[TD="class: xl93, width: 90"] (511,564)[/TD]
[/TR]
</tbody>[/TABLE]
The result returns 435731.6% which is not sensible. Any ides why this could be? I deleted the last cash flow - 511k and the number becomes sensible (around 20%), however I need the IRR with the last cash flow included