Fantastic Return Good Return Flat Poor Return Horrible Return Return (discrete annual compounding) 10.00% 4.00% 0.00% -2.00% -10.00% $ $ Investment Years Return Future Value 25,000.00 10 10.00% Use a formula to bring in the appropriate rate based on what the user selected above. $64,843.56 (Use a simple future value calculation to solve - assume discrete annual compounding) Create a Data Table to depict the future value when you vary the interest rate and the investment amount. Use the following assumptions: Interest Rates: Investment Amounts: -15.0% $ 25,000.00 -13.0% $ 50,000.00 -11.0% $ 75,000.00 -9.0% $ 100,000.00 -7.0% -5.0% -3.0% -1.0% 1.09% 3.0% 5.0% 7.0% 9.0% 11.0% 13.0% 15.0% Fantastic Return Good Return Flat Poor Return Horrible Return Return (discrete annual compounding) 10.00% 4.00% 0.00% -2.00% -10.00% $ $ Investment Years Return Future Value 25,000.00 10 10.00% Use a formula to bring in the appropriate rate based on what the user selected above. $64,843.56 (Use a simple future value calculation to solve - assume discrete annual compounding) Create a Data Table to depict the future value when you vary the interest rate and the investment amount. Use the following assumptions: Interest Rates: Investment Amounts: -15.0% $ 25,000.00 -13.0% $ 50,000.00 -11.0% $ 75,000.00 -9.0% $ 100,000.00 -7.0% -5.0% -3.0% -1.0% 1.09% 3.0% 5.0% 7.0% 9.0% 11.0% 13.0% 15.0%