Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

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

0 Replies

Level 10

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.

Level 1

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.

Level 3

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.

Level 3

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

Level 3

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: