Question

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: a. $20,000 to be received in 10 years at 8% compounded annually? __________________ b. $20,000 to be received in 10 years at 6% compounded annually? __________________ c. $20,000 to be received in 15 years at 8% compounded annually?___________________ d. $20,000 to be received in 15 years at 6% compounded annually? __________________ 2. What is the future value of a single amount of a. $5,000 invested for 10 years at 5% compounded annually? ______________________ b. $5,000 invested for 10 years at 8% compounded annually? _______________________ c. $5,000 invested for 15 years at 5% compounded annually? ______________________ d. $5,000 invested for 15 years at 8% compounded annually? _______________________ 3. What is the future value of an amount of: a. $5,000 invested each year for 25 years at 5% compounded annually? ________________ b. $5,000 invested each year for 25 years at 8% compounded annually? ____________

Answer 1

1)

2)

3)