Newbies abeautifulday Posted April 21, 2004 Newbies Posted April 21, 2004 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
Fitch Posted April 21, 2004 Posted April 21, 2004 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.
Newbies abeautifulday Posted April 22, 2004 Author Newbies Posted April 22, 2004 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
Fitch Posted April 22, 2004 Posted April 22, 2004 From the online help: 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.
Newbies abeautifulday Posted April 23, 2004 Author Newbies Posted April 23, 2004 hehehe got it this time
Recommended Posts
This topic is 7780 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now