Through poor financial management, Debbie has amassed $2,000,000 in credit card debt. This card charges a 43% annual rate and compounds monthly. Debbie plans to clear her balance over 3 years. a. Using Excel formulas, compute the monthly payment required to clear the debt within the projected period. b. Using Excel, prepare the amortization spreadsheet c. How much interest would Debbie have paid at the end of two years? d. What proportion of the 10th payment is interest? e. What is the effective rate being charged by the card company?