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?
Through poor financial management, Debbie has amassed $2,000,000 in credit card debt. This card charges a 43% annual rat
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Through poor financial management, Debbie has amassed $2,000,000 in credit card debt. This card charges a 43% annual rat
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!