AnsweredAssumed Answered

FileMaker PV versus Excel PV

Question asked by jrpmedia on Dec 13, 2017
Latest reply on Dec 14, 2017 by srzuch

When I use the PV Function in Filemaker it is WRONG and works it out as PMT made at the end

end Screen Shot 2017-12-13 at 13.31.13 copy.png

 

Screen Shot 2017-12-13 at 15.43.09.png

 

 

Instead of what Excel does CORRECT which is PMT made at the beginning

beginning Screen Shot 2017-12-13 at 13.31.05 copy.png

 

Screen Shot 2017-12-13 at 15.38.54.png

Screen Shot 2017-12-13 at 15.38.34.png

 

Here are those two calculators for reference: Present Value Calculator

 

How can I get Filemaker PV Function to work out PMT made at the beginning.

 

Thanks.

Outcomes