10 Replies Latest reply on Sep 8, 2014 12:39 PM by radzmar

# Apr calculation in FormCalc

Hi! Please, describe how to calculate Apr (annual percentage of rate). If you can, write a formula based on starting input values (principal amount of the loan, payment amount on the loan, number of periods in the loan’s duration).

• ###### 1. Re: Apr calculation in FormCalc

Have you reviewed the APR doc? It provides samples.

Steve

• ###### 2. Re: Apr calculation in FormCalc

Thanks for the reply. I already read that documentation, but my question is slightly different. I meant what formula should i use with theese input values, to get the result which FormCalc shows. Because i haven't found this one in the internet, which can give you the APR based on theese values.

Thanks.

• ###### 3. Re: Apr calculation in FormCalc

I am also interested in this problem. Did you find that formula yet? If you have it, please post it in this thread.

Many thanks.

• ###### 4. Re: Apr calculation in FormCalc

Steve, Do you know how to reverse a loan Payment? I have successfully coded the loan payment based on loan size, interest rate and term. I'm trying to calculate the loan size based on the monthly payment, term and interest rate. I can do it in excel but not in livecycle.

--Thanks.

• ###### 6. Re: Apr calculation in FormCalc

Do you have a working Loan Payment formula for a forms custom calc script?    This is what I have so far.  Would appreciate a "dumb down" response-my first go of it.

var AnnualRate = this.getField("Rate");

if(AnnualRate == null) app.alert("error interest rate field");

var NumberPayments = this.getField("Amortization");

if(NumberPayments == null) app.alert("error getting number of payments field");

var PresentValue = this.getField("Loan Amount");

if(PresentValue == null) app.alert("error getting present value field");

event.value = PMT( AnnualRate.value / 12, NumberPayments.value, PresentValue.value);

• ###### 7. Re: Apr calculation in FormCalc

I can send you my form which has all the formula's needed to calculate mortgage payments as well as blended rates. I will need an email address to do so.

• ###### 8. Re: Apr calculation in FormCalc

scottr@titanbank.com

• ###### 9. Re: Apr calculation in FormCalc

There is no PMT function in Acrobat, but you can write a function to perform that calculation.

• ###### 10. Re: Apr calculation in FormCalc

Well, there is a PMT function in FormCalc you can use: