(Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR%

[Vincent Weber]

My simpler version, that only deals with IRR%, NPV, NUS, NFV and TOTAL, as in the 17BII.
I used to have a separate CF0 variable, now that FLOW() and #T() are 0-based, I put it as the first element of the matrix (index 1 in the MATRIX editor). It expects a Cash Flow matrix (N*2) named CF.

Cheers

CFLOW:IF(S(IRR%):0:L(IRR%:I%)-I%)+L(Z:FLOW(CF:0)+Σ(J:1:SIZEC(G(CF)):1:FLOW(CF:J)×USPV(IRR%:#T(CF:J))×SPPV(IRR%​:IF(J=1:0:Σ(L:1:J-1:1:#T(CF:L))))))-G(Z)+IF(S(IRR%):G(Z):NPV-G(Z)+L(N:1+Σ(J:1:SIZEC(G(CF)):1:#T(CF:J)))-G(N)+L(NFV:NPV×SPFV(I%:G(N)))-NFV+L(NUS:NPV÷USPV(I%:G(N)))-NUS+L(TOTAL:FLOW(CF:0)+Σ(J:1:SIZEC(G(CF)):1:FLOW(CF:J)×#T(CF:J)))-TOTAL)=0