In this assignment, you need to create an Excel spreadsheet that will enable you to answer the following kinds of problems using cell references to account for changes in each of the variables that go into the problem.

1. FV of a single amount

2. PV of a single amount

3. FV of multiple, different amounts (use 5) when the first amount begins today

4. FV of multiple, different amounts (use 5) when the first amount begins at the end of the next compounding period

5. PV of multiple, different amounts (use 5) when the first amount begins today

6. PV of multiple, different amounts (use 5) when the first amount begins at the end of the next period

7. FV of an annuity

8. PV of an annuity

9. Periodic payments needed to get to some amount in the future

10. Periodic payments that can be taken from some amount you have today. You are welcome to use the spreadsheet I created as a model when creating your own spreadsheet.

Test your spreadsheet before submitting, since grades will be determined by me seeing if it works for 1 through 10.