Calculate payments based on APR
Kenneth Brody
kenbrody at spamcop.net
Sun Apr 12 20:20:22 PDT 2009
Robert T. Repko (R Squared Consultants) wrote:
> Believe it or not at 4/12/2009 10:46 PM, Kenneth Brody said:
>> Robert T. Repko (R Squared Consultants) wrote:
>>> Does anyone have a routine that calculates monthly payments based on an APR.
>> Would the TVM_PMT() function do what you're looking for?
>
> I looked at that function but it gives me a different answer than the
> calculators I've used for finding payments based on an APR. Before I
> started working on the program I used calculators on the Internet so
> I would know what answers I was supposed to get. I used $1000.00,
> 13.9%, for 12 months, compounded monthly. Using TVM_PMT() I get a
> monthly payment of 84.09, with a calculator I get 89.74. The
> description doesn't mention if it's simple or compound interest.
Hmm...
xx(8,.2) = tvm_pmt("12","13.9"/"12","1000","0")
gives me "-89.74", just like your calculator.
What did you do that gave you a different number?
--
Kenneth Brody
More information about the Filepro-list
mailing list