Joseph31 Posted June 3, 2004 Share Posted June 3, 2004 Hello Everyone... I need to ask you all how to do a equation. I have looked in the built in equations and can not find what I am looking for. I need: PV(Future Value, Interest Rate, Period) PV= Present Value Can anyone help me.. Joseph Link to comment Share on other sites More sharing options...
-Queue- Posted June 3, 2004 Share Posted June 3, 2004 PV = FV/(1 + Interest Rate)^Period Link to comment Share on other sites More sharing options...
RalphL Posted June 3, 2004 Share Posted June 3, 2004 PV is one of the Financal functions provided by FileMaker. Link to comment Share on other sites More sharing options...
-Queue- Posted June 3, 2004 Share Posted June 3, 2004 Very true. I figured it must not be or he wouldn't have needed to ask the question. I should know better by now... Perhaps Joseph should try doing his own research before posting. Link to comment Share on other sites More sharing options...
Joseph31 Posted June 3, 2004 Author Share Posted June 3, 2004 sorry...it says it does not rec PV? I am not sure what this equation is telling me...can you explane? Joseph Link to comment Share on other sites More sharing options...
Joseph31 Posted June 3, 2004 Author Share Posted June 3, 2004 I have looked in the PV Funtion guys...but I need Future Value with it...Theres only give me 3 choices I need a 4th FV in the PV function... Joseph Link to comment Share on other sites More sharing options...
Lee Smith Posted June 3, 2004 Share Posted June 3, 2004 Hi Joseph, Open FM Online help, and type in PV (present value) function in the Index HTH Lee Link to comment Share on other sites More sharing options...
-Queue- Posted June 3, 2004 Share Posted June 3, 2004 Then use the formula I already posted. Link to comment Share on other sites More sharing options...
Joseph31 Posted June 3, 2004 Author Share Posted June 3, 2004 I have tried...FM7 does not know that formula...Is there any formula that has PV with a future value in it? Just for the record...Like I said in the main post...I have checked with the default equations and I can not find one with this setup... Joseph Link to comment Share on other sites More sharing options...
-Queue- Posted June 3, 2004 Share Posted June 3, 2004 Just plug your values into the forumla. FV/(1 + Interest Rate)^Period Set Field [field, FV/(1 + Interest Rate)^Period] Just substitute your field names for the appropriate ones. Link to comment Share on other sites More sharing options...
Joseph31 Posted June 3, 2004 Author Share Posted June 3, 2004 what does the set field function have to do with this...I have only used them from global functions? Can you explain this to me ? Joseph Link to comment Share on other sites More sharing options...
-Queue- Posted June 3, 2004 Share Posted June 3, 2004 I think you should try reading the online help before asking a question like this. It could also be used as a calculation. I just presented the example as if you were setting a specific field with its results. I also think you need to read all the FM documentation and help you can find before you ask further questions. You need to have at least a basic understanding of the application before we can be of much help to you. Link to comment Share on other sites More sharing options...
Joseph31 Posted June 3, 2004 Author Share Posted June 3, 2004 thank you for the help...I have read all of the FM documents...But Its alot easier to learn this when you have real examples...But I am sure I will get better at this... Thank you again for the help Joseph Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted June 3, 2004 Share Posted June 3, 2004 Joseph, BTW, ^ is also already included as an operator (kidding) I'd have to agree FM's built in Financial functions aren't as easy to use than Excel's. Though, you can still use FM as a calculator by giving the Math equation, when FM doesn't provide an already built in function... But then please open your Math/Financial book as well... Don't give us the whip Joseph... Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7267 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