CAN YOU SHOW ME HOW TO WORK THESE IN EXCEL PLEASE?

Find the present value of the following ordinary annuity. Discounting occurs once a year.

a. $400 per year for 12 years at 10%.

b. $200 per year for 6 years at 5%.

c. $900 per year for 6 years at 0%.

Rework previous parts assuming that they are annuities due.

d. $400 per year for 12 years at 10%.

Rework previous parts assuming that they are annuities due.

e.$200 per year for 6 years at 5%.

Rework previous parts assuming that they are annuities due.

f. $900 per year for 6 years at 0%.