Calculate payments based on APR
Robert T. Repko (R Squared Consultants)
rtr at rsquared.com
Mon Apr 13 16:41:05 PDT 2009
Believe it or not at 4/13/2009 02:33 PM, Kenneth Brody said:
>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. :-)
>
>--
I was going to ask you about the discrepancy between what you stated
and what Laura had in her help file.
Is it possible to get a daily payment amount instead of monthly. I
can see the need to calculate a daily rate so when people make
payments I can calculate the principal and interest for x number of
days. I tried substituting 365 in place of 12 but the numbers didn't
come out right.
More information about the Filepro-list
mailing list