Please show the work in excel be sure to use appropriate formulas to solve each exercise or problem.

A1 If you deposit $12,000 in a bank account that pays 10% interest annually, how much will be in your account after 7 years?

A2. What is the present value of a security that will pay $10,000 in 20 years at an interest rate of 8%?

A3. Find the future value of the following ordinary annuities:

$600 per year for 10 years at 10%

$300 per year for 5 years at 5%

$600 per year for 5 years at 0%

A 4 Find the present value of the following ordinary annuities:

$600 per year for 10 years at 10%

$300 per year for 5 years at 5%

$600 per year for 5 years at 0%