pls use excel formula to arrive to answer. pls show the excel steps

Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 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? Complete the following analysis. Do not hard code values in your calculations. All answers should be positive