Problem: Using the present value function in MS Excel, verify that the present value of $100,000 to be received in five years at an interest rate of 16%, compounded annually, is $47,610. Calculate the present value of $100,000 for each of the following items (parts a-f) using these facts:
a. Interest is compounded semiannually
b. Interest is compounded quarterly
c. A discount rate of 12% is used
d. A discount rate of 20% is used
e. The cash will be received in three years
f. The cash will be received in seven years