# PV Calculation Help...

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

## Recommended Posts

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

##### Share on other sites

PV = FV/(1 + Interest Rate)^Period

##### Share on other sites

PV is one of the Financal functions provided by FileMaker.

##### Share on other sites

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.

##### Share on other sites

sorry...it says it does not rec PV?

I am not sure what this equation is telling me...can you explane?

Joseph

##### Share on other sites

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

##### Share on other sites

Hi Joseph,

Open FM Online help, and type in PV (present value) function in the Index

HTH

Lee

##### Share on other sites

Then use the formula I already posted.

##### Share on other sites

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

##### Share on other sites

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.

##### Share on other sites

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

##### Share on other sites

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.

##### Share on other sites

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

##### Share on other sites

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...

Don't give us the whip Joseph...

##### Share on other sites

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

## Create an account

Register a new account