Please solve with Excel formula and demonstrate the procedure. Thanks!

Today is Dec. 31, 2017. You have been saving money each month over the past year, and have just made your last deposit into a bank account that pays interest of 0.5% per year, compounded monthly. You did not have a set amount that you saved each month, instead, you saved any extra income that you had for the month. Your savings history is given below in chronological order. Assume that you started the year with $0 in savings, and deposited your savings at the end of each month into a checking account beginning on Jan. 31, 2017. 1) What is the value of your total savings today? 2) What is the dollar amount of interest that you have earned over the year? (Hint: today is time 0) a Use the appropriate formulas and Excel function to solve the problem (typed-in solutions receive 0 credit) Answer Month Jan 1) Total account value 2) Total dollar amount of interest earned Feb Year 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 M Mar Apr May Jun Jul Aug Sep Oct Nov Dec Savings 21.32 116.13 3.48 463.15 51.06 129.09 388.07 340.14 404.74 362.44 43.44 67.00