Compounded Growth calculation Excel
There are a ton of financial functions built right in to Excel that should
handle all three of these. Just go to help and type Financial Functions.
PV = Present Value function
FV = Future Value function
etc.
"Andre" wrote:
Greetings, some assistance would be much appreciated with the following
calculations:
1. Say you decided to invest 24 280 for 10 years and say on maturity it is
worth 68 941 - How do I calculate that in Excel with an Excel
function/formula?
2. If I said that the maturity value (68 941) is 29 121 in todays money -
How would I calculate that in Excel with an Excel function/formula?
3. Lastly if I said that the final amount (29 121) would give me a monthly
pension of 291 per month. How would I calculate that in Excel with an Excel
function/formula?
Andre
|