Present value calculations- effects of compounding frequency, discount rates, and time periods. Using a present value table, your calculator, or a computer program present value function, 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, using these facts, except;

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.

Write out the EXCEL Function for Present Value and for Future Value and briefly explain what each item means