how to calculate IRR/NPV

[wonka1234]

I want to calculate IRR (IRR will be used in my NPV)

In excel IRR is done like so:=IRR(M31:M1048576)

I tried using this:

but this value doesnt make sense

calculate NPV I want to use these two values IRR and the column EIR-Recalc.

in excel NPV is like this =NPV(C78,M7:M65) , where C78 is IRR and the M7:M86 is the EIR-Recalc column

How can I calculate both of these?

[FrederikE]

I don't know anything about the formulas behind the calculations, but the Summarize Tool offers this calculation options for numbers, take a look into theese.