Idk wat to do? Please help.

6. How much would your parents have to deposit each month into an account that grows at a rate of 12% per year, compounded semiannually, if they want to have $80,000 at the end of year 3 to cover part of your college expenses? Assume no interperiod compounding. Also, write the spreadsheet function to display the monthly amount