These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Loan Calculations in LiveCycle Designer

Forum Index > Forms: LiveCycle Designer > Loan Calculations in LiveCycle Designer
2009-01-13 18:07:53
jblush
Registered: Jan 13 2009
Posts: 4

Does anyone know if Formcalc can be used to calculate the remaining payments to amortize a loan?

I have established a form in Livecycle Designer that calculates the monthly payment amount of principal and interest, but I'm not sure how to calculate the remaining term. I appreciate any insight into the issue. Thank you in advance for your help.

My Product Information:
LiveCycle Designer, Windows
Top
2009-01-14 12:48:24
#1
radzmar
Expert
Registered: Nov 3 2008
Posts: 1202
Have you looked into the FormCalc Reference and Specification?

It contains many examples for financial calculations.

http://help.adobe.com/en_US/livecycle/8.2/FormCalc.pdf
http://partners.adobe.com/public/developer/en/xml/formcalc_2.0.pdf

radzmar
• LoveCycle Blog
Documents you need:
• LiveCycle Designer ES2 Docs

Top
2009-01-14 19:26:40
#2
jblush
Registered: Jan 13 2009
Posts: 4
I appreciate the information, but I checked those sources prior to posting my inquiry. I didn't know if there was a way to manipulate the Formcalc formulas or derive a formula based on those calculations.
Top
2009-01-15 08:32:16
#3
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4308
Do you know the total periods for the loan?

If I remember correctly, one needs this value to compute the period payment along with the principal amount of the loan and the interest rate per period.

George Kaiser

Top
2009-01-16 18:00:25
#4
jblush
Registered: Jan 13 2009
Posts: 4
I work at a bank in the loan department, and have no problem calculating the remaining payments by hand or in Excel, just having found the right script for calculating the remaining term.

All you need to calculate the remaining term are the following components:

1)Principal and Interest payment
2)Principal Balance
3)Interest Rate

There is a Formcalc function in Livecycle that I am using for the total payment, but the "Term" function in Livecycle cannot be manipulated to allow the user to calculate the payments for a loan. It only calculates the number of payments for an investment product, depicting the number of periods for a relevant rate of return.
Top