Adobe LiveCycle (Archived)

VVingeD · ‎17-02-2011

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 · ‎21-02-2011

Have you reviewed the APR doc? It provides samples.

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

Steve

VVingeD · ‎22-02-2011

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 · ‎22-02-2011

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.

NY2CA · ‎15-11-2012

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.

NY2CA · ‎22-11-2012

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

SER · ‎28-04-2014

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

NY2CA · ‎28-04-2014

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.