Find the following values. On questions asking about multiple years, assume a regular, or ordinary, annuity.

a. The present value of $1,500 paid five years from now with a 4% discount rate

b. The future value of a $3,000 lump sum invested for 7 years at 5%

c. The present value of an annuity paying $30,000 per year for 5 years at a 6% discount rate

d. The future value of an annuity paying $20,000 per year for 7 years at a 4% discount rate

PLEASE USE EXCEL TO ANSWER THE QUESTION. PLEASE EXPLAIN WORK.