Use Excel to calculate the following assuming you want to set up a college account for your kid and that you want to accumulate $50,000 in the fund at the end of 10 years.

a) If you can invest at 6% per year, how much would you need to put into the fund at the end of each year? Be prepared to describe how you did the calculation.

b) If you can invest at 6% per year, how much would you need to put into the fund at the beginning of each year? Be prepared to describe how you did the calculation.

c) If you can invest $1,000 at the end of every six months, approximately what interest rate would you need to find for the investment to meet your $50,000 goal in 10 years? Be prepared to describe how you did the calculation.