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 B or C 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. $10,000 to be received in 10 years at 8% compounded annually? __________________
b. $10,000 to be received in 10 years at 6% compounded annually? __________________
c. $10,000 to be received in 15 years at 8% compounded annually___________________
d. $10,000 to be received in 15 years at 6% compounded annually? __________________