Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.

## Apr calculation in FormCalc

Level 1

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).

10 Replies

Former Community Member

Have you reviewed the APR doc? It provides samples.

Steve

Level 1

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.

Former Community Member

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.

Former Community Member

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.

Former Community Member

Level 1

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);

Former Community Member

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.

Level 1

scottr@titanbank.com

Level 7

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

Level 10

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