Through poor financial management, Debbie has amassed $2,000,000 in credit card debt. This card charges a 43% annual rat
Posted: Thu Apr 28, 2022 1:50 pm
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?
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?