Adobe LiveCycle (Archived)

VVingeD · 2/17/11

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

Thanks for your time

Report · 2/21/11

Have you reviewed the APR doc? It provides samples.

http://help.adobe.com/en_US/livecycle/9.0/designerHelp/001486.html

Steve

VVingeD · 2/22/11

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.

Report · 2/22/11

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.

Report · 11/15/12

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.

Report · 11/22/12

I can help you with that if you still need it.

SER · 4/28/14

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

Report · 4/28/14

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.