Calculate payments based on APR

Kenneth Brody kenbrody at spamcop.net
Mon Apr 13 11:33:19 PDT 2009


Robert T. Repko (R Squared Consultants) wrote:
> I followed the example Laura had in her help file.
> Interpreting the numbers in her example $200,000, 360 months (30 yr 
> loan), at 7.25%
> 
>       if: ' What would be the payment for this loan?
>     then: PMT = TVM_PMT("360",".0725","200000","0") ' PMT will be -631.40595650

It looks like you found an error in Laura's help files, since 7.25% should 
be "7.25" (and divided by 12 for monthly interest).  Of course, if you give 
the same "wrong" numbers to a financial calculator, you get the same "wrong" 
answer.

> I used:
> eh=TVM_PMT("12",".139","1000","0")
> 
> I see my mistake, instead of using a monthly rate (.139/12) I used 
> the APR of .139 in the calculations.
> 
> Thanks Ken I never would have seen my error.  I hate when I do that, 
> spend days on a problem and the solution is right under my nose and I 
> can't see it. 

Just plug the same numbers into filePro as you would your calculator.  :-)

-- 
Kenneth Brody



More information about the Filepro-list mailing list