Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

/t5/acrobat/calculate-term-loan/td-p/11991644
Apr 24, 2021
Apr 24, 2021

Copy link to clipboard

Copied

Hi, I want this formula in pdf form. Can someone simplify, please?

I want to calculate the loan monthly payment.

https://www.calculatorsoup.com/calculators/financial/loan-calculator-simple.php

https://www.thebalance.com/loan-payment-calculations-315564

https://www.kasasa.com/blog/how-to-calculate-loan-payments-in-3-easy-steps

TOPICS

PDF forms

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

Adobe Community Professional
,
Apr 28, 2021
Apr 28, 2021

You can use this,just change field names if neccessary: var a = Number(this.getField("Amount").value); var ir = Number(this.getField("Interest Rate").value); var lt = Number(this.getField("Loan Term").value); var n = lt*12; var i = ir/100/12; var total = (a*i*Math.pow(1+i, n))/(Math.pow(1+i, n)-1); if(a == "" || ir == "" || lt == "") event.value = ""; else event.value = total;

12
Replies
12

/t5/acrobat/calculate-term-loan/m-p/11991646#M309852
Apr 24, 2021
Apr 24, 2021

Copy link to clipboard

Copied

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

arshadsolehry
AUTHOR

Explorer
,

/t5/acrobat/calculate-term-loan/m-p/11993071#M309920
Apr 25, 2021
Apr 25, 2021

Copy link to clipboard

Copied

I want to simplify it. I have three fields

TermMonths

Principal

Rate %

Community Guidelines

Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

/t5/acrobat/calculate-term-loan/m-p/11993091#M309921
Apr 25, 2021
Apr 25, 2021

Copy link to clipboard

Copied

Not everything can be simplified. Just use the formula from those sites.

Community Guidelines

/t5/acrobat/calculate-term-loan/m-p/11993187#M309927
Apr 25, 2021
Apr 25, 2021

Copy link to clipboard

Copied

Is rate added to monthly rate?

5 years * 12 month = 60 = 20000/ 60 =333.33*1.05(5%)= 350$ monthly rate?

Community Guidelines

/t5/acrobat/calculate-term-loan/m-p/11993217#M309930
Apr 25, 2021
Apr 25, 2021

Copy link to clipboard

Copied

Stop trying to simplify it. Use the formula as shown. Is the problem that you don't understand how to read it? You CANNOT implement a formula that you do not understand, and this is where I sometimes get stuck and need to go do more study.

Is it that you don't understand Especially the n Superscript, also written as ^n? Which means "to the power of n"?

Community Guidelines

arshadsolehry
AUTHOR

Explorer
,

/t5/acrobat/calculate-term-loan/m-p/12001679#M310575
Apr 28, 2021
Apr 28, 2021

Copy link to clipboard

Copied

Community Guidelines

/t5/acrobat/calculate-term-loan/m-p/12001686#M310576
Apr 28, 2021
Apr 28, 2021

Copy link to clipboard

Copied

Use:

Math.pow(x,y)

to calculate x^y.

Community Guidelines

arshadsolehry
AUTHOR

Explorer
,

/t5/acrobat/calculate-term-loan/m-p/12001699#M310578
Apr 28, 2021
Apr 28, 2021

Copy link to clipboard

Copied

I will try out this.

Thank you.

Community Guidelines

Adobe Community Professional
,

LATEST
/t5/acrobat/calculate-term-loan/m-p/12002439#M310626
Apr 29, 2021
Apr 29, 2021

Copy link to clipboard

Copied

++ In addition to the guidance provided by all others here,

Just curious, would you mind providing the formula that you're using in MS Excel?

Sometimes formulas in MS Excel have nested IF / IF ELSE functions to evaluate one or more conditions.

Community Guidelines

arshadsolehry
AUTHOR

Explorer
,

/t5/acrobat/calculate-term-loan/m-p/12001687#M310577
Apr 28, 2021
Apr 28, 2021

Copy link to clipboard

Copied

Yes, it is a monthly rate. The result of your calculation should be

Monthly Payment = $ 377.42 not $350. Thank you

Community Guidelines

/t5/acrobat/calculate-term-loan/m-p/11993960#M309959
Apr 25, 2021
Apr 25, 2021

Copy link to clipboard

Copied

Let's begin by defining which of the three loan payment calculation formulas do you really need to use.

In the links that you've shared, you have one formula that breaks down an example for a mortgage payment, the other one to calculate a vehicle loan.

The other link is an online loan calculator.

So first of all, which of these tasks are you inquiring about:

- Are you asking to create a script that calculates monthly payments for a mortgage?
- or a script to calculate monthly payments for a vehicle loan?
- Or are you trying to outsource for a developer in these forums to write from scratch a code for a PDF claculator entirely in Acrobat JavaScript, and with that, be able to calculate both mortgages and vehicle loans when a PDF is filled with some information?

Community Guidelines

/t5/acrobat/calculate-term-loan/m-p/12002245#M310614
Apr 28, 2021
Apr 28, 2021

Copy link to clipboard

Copied

You can use this,just change field names if neccessary:

```
var a = Number(this.getField("Amount").value);
var ir = Number(this.getField("Interest Rate").value);
var lt = Number(this.getField("Loan Term").value);
var n = lt*12;
var i = ir/100/12;
var total = (a*i*Math.pow(1+i, n))/(Math.pow(1+i, n)-1);
if(a == "" || ir == "" || lt == "")
event.value = "";
else
event.value = total;
```

Community Guidelines

Resources

About Adobe Acrobat

Adobe Inc

Adobe Inc

Adobe Inc

Adobe Acrobat Feature & Workflow

FAQs

Using the Community
Experience League
Terms of Use
Privacy Policy
Cookie preferences
AdChoices
Language:

- Deutsch
- English
- Español
- Français
- 日本語コミュニティ
- Português

Copyright © 2021 Adobe. All rights reserved.