I need the following answered and broken down in EXCEL. I need it as a template so if the numbers change , it produces the correct answer. Please read this!

On June 1, Mia deposited $2,400 in an MMDA that pays 6% interest. On October 31, Mia invested $1,900 in a three-month CD that pays 8%. At the end of the year, how much interest will Mia have earned, assuming she hasn't taken anything out of the money market deposit account?