Please show how to answer the questions with excel functions. Thank you

A B C D E F G H - 3 You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate of 5 percent per year, compounded monthly for the first six months, increasing thereafter to 18.5 percent compounded monthly. Assuming you transfer the $7,000 balance from your existing credit card and make no subsequent payments, how much interest will you owe at the end of the first year? 4 5 6 0.5% 7 8 9 First APR Periods for first APR Second APR Periods for second APR Balance transferred Months per year 10 18.5% 6 7,000 12 11 12 13 14 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 15 16 17 Balance in six months =FV FV(ratenper, pt, (pvi. [type] 18 Balance in one year 19 20 11 Accrued interest Sheet1 READY Attempt(s) 2/3 Step: Use the FV function to calculate the future value. IH