I am trying to use IRR function for my string of cash flows for 10 years:
Year | Cash Flows
2009 | -272,895,028,812
2010 | -207,524,139,910
2011 | -185,716,940,803
2012 | -9,306,121,279
2013 | 326,372,394,532
2014 | 245,782,146,138
2015 | 501,268,808,310
2016 | 497,663,783,563
2017 | 493,577,645,807
2018 | 488,974,344,794

The formula I am using is simply:
=IRR("Range of Data")

I am getting the #NUM! error...any assistance please?

Thanks!

bakbuk -

With the years in A2:A11 and the cash flows in B2:B11, in another cell
=IRR(B2:B11) returns 34%.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"bakbuk" wrote in message
...
I am trying to use IRR function for my string of cash flows for 10 years:
Year | Cash Flows
2009 | -272,895,028,812
2010 | -207,524,139,910
2011 | -185,716,940,803
2012 | -9,306,121,279
2013 | 326,372,394,532
2014 | 245,782,146,138
2015 | 501,268,808,310
2016 | 497,663,783,563
2017 | 493,577,645,807
2018 | 488,974,344,794

The formula I am using is simply:
=IRR("Range of Data")

I am getting the #NUM! error...any assistance please?

Thanks!

It worked? oww...I wonder why mine didn't...
I'll try to troubleshoot then, thanks for the result

"Mike Middleton" wrote:

bakbuk -

With the years in A2:A11 and the cash flows in B2:B11, in another cell
=IRR(B2:B11) returns 34%.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"bakbuk" wrote in message
...
I am trying to use IRR function for my string of cash flows for 10 years:
Year | Cash Flows
2009 | -272,895,028,812
2010 | -207,524,139,910
2011 | -185,716,940,803
2012 | -9,306,121,279
2013 | 326,372,394,532
2014 | 245,782,146,138
2015 | 501,268,808,310
2016 | 497,663,783,563
2017 | 493,577,645,807
2018 | 488,974,344,794

The formula I am using is simply:
=IRR("Range of Data")

I am getting the #NUM! error...any assistance please?

Thanks!

I still have the problem with this matter. I tried it at my friend's computer
and the result is still the same (#NUM!). I also tried by creating a new
excel file but contain the same value, and it happened again. Both of us use
Office2007, saved and tried the file in .xls and .xlsx format. Is there
something wrong? thanks again.

"bakbuk" wrote:

It worked? oww...I wonder why mine didn't...
I'll try to troubleshoot then, thanks for the result

"Mike Middleton" wrote:

bakbuk -

With the years in A2:A11 and the cash flows in B2:B11, in another cell
=IRR(B2:B11) returns 34%.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"bakbuk" wrote in message
...
I am trying to use IRR function for my string of cash flows for 10 years:
Year | Cash Flows
2009 | -272,895,028,812
2010 | -207,524,139,910
2011 | -185,716,940,803
2012 | -9,306,121,279
2013 | 326,372,394,532
2014 | 245,782,146,138
2015 | 501,268,808,310
2016 | 497,663,783,563
2017 | 493,577,645,807
2018 | 488,974,344,794

The formula I am using is simply:
=IRR("Range of Data")

I am getting the #NUM! error...any assistance please?

Thanks!

I get #NUM too.
Your numbers are quite big. If I divide all numbers by 100, I get 26.43%.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bakbuk" wrote in message
...
I still have the problem with this matter. I tried it at my friend's
computer
and the result is still the same (#NUM!). I also tried by creating a new
excel file but contain the same value, and it happened again. Both of us
use
Office2007, saved and tried the file in .xls and .xlsx format. Is there
something wrong? thanks again.

"bakbuk" wrote:

It worked? oww...I wonder why mine didn't...
I'll try to troubleshoot then, thanks for the result

"Mike Middleton" wrote:

bakbuk -

With the years in A2:A11 and the cash flows in B2:B11, in another cell
=IRR(B2:B11) returns 34%.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"bakbuk" wrote in message
...
I am trying to use IRR function for my string of cash flows for 10
years:
Year | Cash Flows
2009 | -272,895,028,812
2010 | -207,524,139,910
2011 | -185,716,940,803
2012 | -9,306,121,279
2013 | 326,372,394,532
2014 | 245,782,146,138
2015 | 501,268,808,310
2016 | 497,663,783,563
2017 | 493,577,645,807
2018 | 488,974,344,794

The formula I am using is simply:
=IRR("Range of Data")

I am getting the #NUM! error...any assistance please?

Thanks!

Oh I see...so the problem is that the numbers are big...
I followed your step but divide by 1000...yup, it returned 26.43%. They're
big because they're in IDR currency. This really helped me, thanks a lot!
Now, I have better knowledge to handle big numbers. Phew...case closed then.
Thanks again, really!

Best Regards,

"Niek Otten" wrote:

I get #NUM too.
Your numbers are quite big. If I divide all numbers by 100, I get 26.43%.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bakbuk" wrote in message
...
I still have the problem with this matter. I tried it at my friend's
computer
and the result is still the same (#NUM!). I also tried by creating a new
excel file but contain the same value, and it happened again. Both of us
use
Office2007, saved and tried the file in .xls and .xlsx format. Is there
something wrong? thanks again.

On Thu, 11 Dec 2008 12:37:44 +0100, "Niek Otten" wrote:

I get #NUM too.
Your numbers are quite big. If I divide all numbers by 100, I get 26.43%.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Niek,

Why do you think these "large" numbers result in the #NUM error (which I get
also in Excel 2007).

I thought Excel uses an iterative technique to solve for IRR, finding the
interest rate for which the NPV is zero.

It must have something to do with the way Excel calculates IRR internally, but
....

I set up to solve the IRR iteratively.

I used the OP's original data in B2:B11

E3 will be my "guess" for the IRR.

I then set up these formulas:

E3: 10%
G2: =B2
G3: =B3*(1/(1+$E$3)^ROWS($1:1))

Fill down to G11

G13: =SUM(G2:G11)

I then used Goal Seek to set G13 to 0 by varying E3. And that comes up with
the proper answer. The answer is the same as the IRR answer to 15 decimals.

In other words, implementing what I thought was the IRR technique in a
different way did not result in any error, and returned the correct answer.
--ron