# Investment interest calculator [closed]

Financial planners often have tables that show investment growth on an "average" rate of return over a number of years. But the market doesn't work like that. Annual rates of return vary greatly which, over time, produce an average. An investment that receives the same rate of return each year compared to one that has yearly variable growth rates can have a very different outcome at the end of the investment period, particularly if a draw down is occurring in retirement years. I would like to create a spreadsheet that can demonstrate this.

I can't figure out how to have the spreadsheet produce a column for each year's rate of return. These random rates would need to be within a specified range **and**average the specified rate of return over the term of the investment. I'd like to:
1. Enter the investment amount.
2. Enter the number of years for the investment period. Example 30 years.
3. Enter a range of the expected rate of return on investment. Example -5 to 20 percent.
4. Enter a variable for the average percent of return on investment over the time period specified above. Example 8%.

So in this case have the spreadsheet fill 30 cells in a column, each with a rate of return randomly selected within -5 and 20 percent and when all cells are averaged equals 8%.

Thanks in advance for any assistance.

(Spoken aside:) Why do we talk about investments where the matter is gambling?