Please show excel work. thanks!

4.

b.

Brenda Young desires to have $12,000 eight years from now for her daughters college fund. If she will earn 4 percent (compounded annually) on her money, what amount should she deposit now? Use the present value of a single amount calculation. (Round time value factor to 3 decimal places and final answer to the nearest whole dollar.)

Present value

$

c.	What future value amount would you have if you deposited $2,700 a year for 25 years at 8 percent (compounded annually)? (Round time value factor to 3 decimal places and final answer to the nearest whole dollar.)

Future value

$