I'm busy with my first project and I have a load of financial calculations to do. One of the calculations is to calculate the future value of an investment.
Future Value Formula
Future Value (FV) = PV × (1 + r) ^ n
Where:
PV = Present Value
r = Interest Rate (%)
n = Number of Compounding Periods
I use formula fields in my tables to calculate these values=>
I've tried to write the following formula to calculate the Future value but it returns syntax errors and cant figure this out. Any assistance will be appreciated.
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.
Question
JacoStander
Good day,
I'm busy with my first project and I have a load of financial calculations to do. One of the calculations is to calculate the future value of an investment.
Future Value Formula
Where:
I use formula fields in my tables to calculate these values=>
To calculate my present value I use the formula:
[@field:nett_income_required_from_pip] / (100 - [@field:estimated_tax_rate_retirement]) * 100
My Interest rate is a fixed vale of 5
My number of compound periods are calculate with this formula:
[@field:retirement_age] - Datediff(year,[@field:dob],[@field:timestamp])
I've tried to write the following formula to calculate the Future value but it returns syntax errors and cant figure this out. Any assistance will be appreciated.
([@field:nett_income_required_from_pip] / (100 - [@field:estimated_tax_rate_retirement]) * 100)*(Power((100 + ([@field:inflation])),([@field:retirement_age] - Datediff(year,[@field:dob],[@field:timestamp]))))
UPDATE: The above formula verifies but when I'm trying to save my table I get the error =>
Many thank
Jaco
Edited by JacoStanderProblem Solved
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
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.