answers must be in excel format.

Getx You x G you C XFX CAB X E Am a wh eztomheducation.com/ext/map/index.html?_con contexternal browser-Olaunchurl https253A252F%252Fnewconnect me Excel Sim Problems D E 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 57,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? 5 6 7 8 9 10 First APR Periods for first APR Second APR Periods for second APR Balance transferred Months per year 0.5% 6 18.5% 6 7.000 12 13 14 Complete the following analysis. Do not hard code values in your calculations All answers should be positive. 15 16 Balance in six months 5 7,017,52 12 18 19 20 Balance in one year $ 7,692.18 Accrued interest