On Thu, 3 Sep 2009 12:26:43 -0700 (PDT), Seth M
wrote:

Hi:

I am trying to figure out how to calculate the IRR of a series of
cashflows. There are 177 cashflows of $41,422, and the up-front cost
is $3,330,786. I tried using an IRR, but that just gives me an error I
think because there are too many cashflows. I used an XIRR, but this
compounds daily, and thus gives me a different result than an HP-12C.
Please advise!

When you get the #NUM error, it usually means you need to use a guess that is
closer to your expected return than the default of 10%. (See HELP for the IRR
worksheet function).

Using a guess of 1%, I get a result of 1.0467%

However, since your cashflows are all the same, you could also use the RATE
function:


=RATE(177,41422,-330786,0)

--ron