Equivalent of Lotus 123 PVAmount

R

RAK

I am attempting to convert a Lotus 123 spreadsheet to
EXCEL and can not convert the Lotus PVAmount financial
function to excel. The PV and NPV functions do not
return the same values.

Any thoughts?
 
T

Tushar Mehta

123's @PVAMOUNT function is a pure convenience function, meaning it serves
no vital purpose.

@PVAMOUNT(FV,Rate,NPer,Freq) = FV/(1+Rate/Freq)^(NPer*Freq)
Click to expand...
OK, so the XL PV function with PMT=0 and FV=<whatever> will yield the
same result.
 
Top