Equivalent of Lotus 123 PVAmount

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

 

[Tushar Mehta]

How about starting with an explanation of PVAmount?

 

[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)

OK, so the XL PV function with PMT=0 and FV=<whatever> will yield the
same result.