View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Compounded Growth calculation Excel

For items 1 and 2

=(FV/PV)^(1/years)-1

=(68.942/24.28)^(1/10)-1

=11%

Don't have enough information for #3

"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