Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

I need a compound interest calculation for 5% annual. None of the below standard included FM Financial calculation scripts seem to work for what I need, an increase of x% per year.

FV (payment, interest

Posted

Four fields: BaseAmount, Interest, Term, and EndResult

BaseAmount is the starting figure.

Interest is the interest rate -- let 'em put in the percentage, such as "5" for 5%.

Term is the number of years.

EndResult has the following calc:

BaseAmount * ((1+(Interest/100)) ^ Term)

That'll do it.

Posted

Thanks Old Hand, that did it.

I am wanting to put a FM file on a Palm that will let me create records and do this kind of calculations, have you used FM mobile, if so do you recommend it, if not have you heard good/bad about it.

Thanks again!

Posted

as far as i know, FM Mobile only holds data but does not calculate - so it's not of any use here. but I may be wrong. Anybody using FM Mobile?

Any financial calculator should have the interest calc function - and they are a lot cheaper than a palm.

This topic is 7919 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.