# Simple Calculation scripts help

This topic is 6486 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

• Newbies

I am a novice user of filemaker so you anyone out there who can advise me on this. This calcution is to simply determine the monthly payment for a loan scheme with the (amount loan) and the (payable periods) of 12 , 24 ,36 or 48 months with an (interest) of 3.5% or 5%. Finally, the results would then be the (monthly payment). How would I go about stating the script? Thanks a million for those who help me out.

FileMaker Version: 5

Platform: Windows XP

##### Share on other sites

Set field [monthly payment, PMT (amount loan, interest, payable periods) ]

Set your amount loan, interest, and payable periods, and run the script. Or you could just make monthly payment a calculated field.

##### Share on other sites

• Newbies

Thanks again Fitch!

##### Share on other sites

• Newbies

seems like the calculation is wrong. I set this script in the scriptmaker and set its field under (monthly payment). The results is not right

##### Share on other sites

PMT (Payment) function

Format

PMT (principal, interest rate, term)

Parameters

principal - principal amount

interest rate - interest rate. If the interest rate is annual, divide the rate by 12.

term - length of time, expressed in number of months

Data type returned

number

Description

Calculates the payment required to meet the requirements of the term, interest rate, and principal you supply.

Examples

In the following example, PMT is being used to calculate payments for purchasing a sports car costing \$21,000, at an annual rate of 6.9% over 48 monthly payments.

PMT(21000, .069/12, 48) returns the payment amount \$501.90.

PMT(Cost, .13, Years) returns a payment amount, based on the purchase value stored in Cost, at a 13 percent rate, over the duration stored in Years.

"Your payment will be " & PMT(150000, .13 / 12, Months) & "." returns Your payment will be, followed by the payment amount, based on a total cost of \$150,000, at a 13 percent annual percentage rate, over the duration stored in Months.

##### Share on other sites

• Newbies

hehehe got it this time

##### Share on other sites

This topic is 6486 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 3,400 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 4,146 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 2,735 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 2,333 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,284 views
×
×
• Create New...