ON EXCEL

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)