Solving the below problem on Excel; 1) Find the future values of these ordinary annuities

 Solving the below problem on Excel;

1) Find the future values of these ordinary annuities. Compounding occurs once a year.

a) $400 per year for 10 years at 10%

b) $200 per year for 5 years at 5%

c) $400 per year for 5 years at 0%

d) Rework parts a, b, and c assuming they are annuities due.

2) Find the present values of these ordinary annuities. Discounting occurs once a year.

a) $400 per year for 10 years at 10%

b) $200 per year for 5 years at 5%

c) $400 per year for 5 years at 0

d) Rework parts a, b, and c assuming they are annuities due

3) An investment will pay $100 at the end of each of the next 3 years, $200 at the end of Year 4, $300 at the end of Year 5, and $500 at the end of Year 6. If other investments of equal risk earn 8% annually, what is its present value? Its future value?