Post Reply 
(Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR%
02-09-2022, 10:54 AM
Post: #10
RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR%
Read the book, and indeed, I learned a few things more, namely the rules governing the use of the direct vs. iterative solver. So my question..
Take this simplified equation performing NPV and IRR% only:

Code:
NPVIRR:0*(
  L(N:MROWS(CF))+
  L(M:MCOLS(CF))+
  IRR%+NPV+
  L(P:0)+
  L(R:1+IRR%/100)+
  IF(G(M)=1:
      Σ(I:G(N):1:-1:L(P:(G(P)+CF[I])/G(R))):
      Σ(I:G(N):1:-1:L(Nj:CF[I:2])+L(P:G(P)*SPPV(IRR%:G(Nj))+CF[I:1]*USPV(IRR%:G(Nj))))
  )
)+
G(NPV)-G(P)*G(R)

If I understood the rules correctly, it should use the direct solver for NPV and the iterative one for IRR%, but how can I tell?

Cheers, Werner

41CV†,42S,48GX,49G,DM42,DM41X,17BII,15CE,DM15L,12C,16CE
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-09-2022 10:54 AM



User(s) browsing this thread: 4 Guest(s)