Use Data Validation in cell B46 to create a list with the following six choices:
Return (discrete annual compounding)
Fantastic Return 12.00%
Good Return 8.00%
Moderate Return 4.00%
Relatively Flat 1.00%
Poor Return -5.00%
Horrible Return - 10.00%
What is your feeling about market performance over the upcoming year?
............? (you should create a list that reads: Fantastic Return, Good Return, Moderate Return, Relatively Flat, Poor Return, Horrible Return)
Investment = $100,000.00
Years= 1
Return= ..........? Use a formula to bring in the appropriate rate based on what the user selected above.
Future Value=.......? (Use a simple future value calculation to solve)