Question

Complete each of the following TVOM calculations using Excel. The assignment MUST be completed on an excel spreadsheet and submitted through blackboard. There are 10 calculations to answer.

The TVOM functions are under the Fx button in Excel. The Fx Function is located just above the actual number section of your spreadsheet, right above the C or D column in most blank spreadsheets. Click on the Fx button and search for the specific function (present value, future value, Rate, payment, etc., whatever you are trying to calculate).

1. What is the present value of each of the following single amounts:
   1. $20,000 to be received in 10 years at 8% compounded annually? __________________
2. 2. $20,000 to be received in 10 years at 6% compounded annually? __________________
3. 3. $20,000 to be received in 15 years at 8% compounded annually?___________________
4. 4. $20,000 to be received in 15 years at 6% compounded annually? __________________

2. What is the future value of a single amount of
   1. $5,000 invested for 10 years at 5% compounded annually? ______________________
   2. $5,000 invested for 10 years at 8% compounded annually? _______________________
   3. $5,000 invested for 15 years at 5% compounded annually? ______________________

1. 4. $5,000 invested for 15 years at 8% compounded annually? _______________________

3. What is the future value of an amount of:
   1. $5,000 invested each year for 25 years at 5% compounded annually? ________________

1. 2. $5,000 invested each year for 25 years at 8% compounded annually? ____________

Answer 1