Im confused on how to do this in Excel. Can someone please help me do this in EXCEL. EXCEL ONLY.

IF you can please also include the functions used Ex.. =FV(B1,B2,,B3)

B D E F $ 1 Simple Interest Example 2 3 Investment Amount 4 Annual Interest Rate 5 Investment Term (Years) 6 Investment Term (Months) 7 8 Interest 9 Investment at End of Term 10 2,000.00 3.62% 1 12 11 12 Compound Interest Example 13 Interest Earned 14 Month 15 Beginning Balance 16 Balance $1,500.00 1 17 2 18 3 19 4 20 5 6 21 22 7 8 23 24 9 10 11 25 26 27 28 12 Problem #2 This problem is designed to allow you to calculate simple and compound interest (and compare the result). (6) A. Calculate the simple interest earned and the investment at the end of the term. B. Calculate the interest earned and the balance for all 12 months of the investment period. You should use the 3.62% annual interest rate and assume monthly compounding