Is it possible to formulate "Future Value" in forms?

I am working with a financial client that want to create a Retirement Income Calculator.  In order to do the necessary calculations, I will need to use the FV (future value) formula, PV (present value) formula and the exponential formula.  Is there any way the JotForm can do these complex financial calculations?

FV = Financial Future Value  

PV = Financial Present Value

Exponential 

Thanks,
Terry

There are two ways you can perform calculations in your form. 

First: Using the Form Calculation widget

https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

Second: Using Update/Calculate Field conditional logic.

https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-Conditional-Logic

Then, use the available Math Functions to perform complex calculations in your form.

https://www.jotform.com/help/267-Form-Calculation-Math-Function-Reference

Check #13 pow from the guide above. It's the one used to perform exponential computations.

I hope this helps. If you have any further questions regarding this, please feel free to contact us again anytime and we will be glad to help you.

Thank you.

Mike,

Thanks for the reply.  Based on looking at the available formulas, the exponential formula is available, but not PV (present value) or FV (future value).  Does anyone see something that I am missing?
Terry

Are you referring to the same computation found in these articles I found over the internet?

http://www.investinganswers.com/financial-dictionary/stock-valuation/present-value-926

http://www.investinganswers.com/financial-dictionary/time-value-money/future-value-fv-2164

If you can give us your sample computation involving each formula maybe we can give you a sample form that is if it can possibly be handled by our forms.

We will wait for your response.

Thank you.

Yes, here is the Life Insurance Calculator:

https://docs.google.com/spreadsheets/d/1tzkD6G4EMZXFMB62kQiuR0YZMcqfA2DzAYjzjnAp8Ww/edit?usp=sharing

This sheet actually has all 3 of the formulas that I am trying to create.

https://docs.google.com/spreadsheets/d/1qcwi4QmmNhQ3rKRChDbvJFyDeAtH9EiJgHK6QlMUhm0/edit?usp=sharing 

Thanks, the sheet helped a bit but without financial backgrounds, we may not be able to give you the actual formula needed. If you can give us the actual formula, it would help a lot.

All I got from your sheet was that you're using the Financial formula for PV in Google Sheets and you're feeding 4 values in it:

=-PV(C36,C35,C34,C34*C35)

If my understanding is correct, this is how PV was supposed to be calculated:

PV = CF/(1+r)n

Where:

CF = cash flow in future period

r = the periodic rate of return or interest (also called the discount rate or the required rate of return)

n = number of periods

Source: http://www.investinganswers.com/financial-dictionary/stock-valuation/present-value-926

If you could point feed the exact values, along with the corresponding formula, we would have a better understanding on how to craft the calculation within JotForm (in case it's plausible). Hoping to hear from you soon.

Mike,

You are correct.  I think that either JotForm has the PV and FV financial formulas or it doesn't.  It is too complicated to calculate them manually and would be an existing built in formula (similar to SIN, COS, TAN etc.) within JotForm.

I appreciate your efforts, but I don't think JotForm has this functionality already built into it.

Terry

Yes, we don't have an innate or built in formula for financial calculations. Nonetheless, if you still need help, just get back to us with the actual formula you're using and we'll see if we can come up with a respective calculation.