Excel Activity: Time value of money

Enter your answers as positive values.

$x$

Download spreadsheet Time value of money$-$a$2$ea$6$e$.$xlsx

a$.$ Find the FV of $$1,000$ invested to earn $8\%$ after $5$ years. Round your answer to the nearest cent.

$

b$.$ What is the investment's FV at rates of $0\%,6\%,$ and $30\%$ after $0,1,2,3,4,$ and $5$ years? Round your answers to the nearest cent.

Choose the correct graph of future value as a function of time and rate. Note: blue line is for $0\%,$ orange line is for $6\%,$ and grey line is for $30\%.$

The correct graph is