Jump to content
  • 0

Future Value (FV) Calculation


neilcovert

Question

Is it possible to do a FV (future value) calculation inside of either a Calculated or the new Formula Field?

This function returns the future value of an investment based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and at a fixed interest rate.

The formula is: FV(periodic-rate, num-periods, payment, present-value, when-due).

 

Thanks.

Neil

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0
2 hours ago, neilcovert said:

Is it possible to do a FV (future value) calculation inside of either a Calculated or the new Formula Field?

This function returns the future value of an investment based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and at a fixed interest rate.

The formula is: FV(periodic-rate, num-periods, payment, present-value, when-due).

 

Thanks.

Neil

Hi Neil,

I calculated future value using this formula. I have all the data in one table, so I used formula field with the following formula:

[@field:Cash_flow]*power((1+[@field:rate]),[@field:number_of_periods])

It's possible to calculate the same in calculated field on report, if you need to take values from different tables.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...