• 0
Followers 0

# Future Value (FV) Calculation

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

## 2 answers to this question

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

##### Share on other sites
• 0

Thanks so much Mathilda.

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