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?
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.
