Monthly Mortgage Payment Calculator

Forum|Forum|2 years ago
August 14, 2023
1 reply
1439 views

Hi there- I'm BRAND NEW to JS and I'm working on a fillable pdf that calculates monthly mortgage payment. I've figured out the "easy" stuff like if the end-user inputs the listing price and the down payment I have the form calculating the loan amount. I'm stuck on the monthly mortgage payment though. Essentially I have a field for rate & loan amount (term is always 360). Can anyone help me? Also- once I have the formula do I put it in the "simplified Field Notation" box or the "Custom Calculation Script" box?

This topic has been closed for replies.

try67

Community Expert

What's the formula for this calculation?

L

Laura31662395g6unAuthor

Participant

In excel the formula is:

=-PMT("InterestRate"/12,360,"LoanAmount",0)

But I can't figure out the formula in Adobe...that's the problem 😞

try67

Community Expert

This is a built-in function of Excel. If you want us to help you you need to specify the actual function you want to implement, and then we could help write it in JS.

If you want someone to do the legwork for you, you'll probably need to hire them for the job.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded