Lesson Amortizing a debt on a credit card

Algebra ->  Finance -> Lesson Amortizing a debt on a credit card      Log On


   


This Lesson (Amortizing a debt on a credit card) was created by by ikleyn(52808) About Me : View Source, Show
About ikleyn:

Amortizing a debt on a credit card


Problem 1

You have  $2,000  debt on a credit card that charges a  18%  interest rate
If you want to pay off the credit card in  4  years,  how much will you need to pay at the end of each month ?

Solution

Use the same formula as for the monthly payment for a loan

    M = P%2A%28r%2F%281-%281%2Br%29%5E%28-n%29%29%29


where P is the loan amount; r = 0.18%2F12 is the nominal interest rate per month;
n is the number of payments (same as the number of months); M is the monthly paymemt.


In this problem  P = $2000;  r = 0.18%2F12.


Substitute these values into the formula and get for monthly payment

    M = 2000%2A%28%28%280.18%2F12%29%29%2F%281-%281%2B0.18%2F12%29%5E%28-48%29%29%29 = $58.75.


ANSWER.  The monthly payment is $58.75.


In total, you will pay  4*12*58.75 = 2,820 dollars in 4 years.


The difference $2,820 - $25,000 = $2,000 = $820  is the interest you pay to the financial company.

Problem 2

Monthly payments of  $600  were not paid for  19  months.
If interest was  19.8%  compounded monthly,  how much was owed?

Solution

In this problem, the debt is numerically equal to the future value of the ordinary annuity 
with the monthly deposits of $600 and the interest of 19.8% per year compounded monthly.


To calculate the future value of an ordinary annuity, use the general formula 


    FV = P%2A%28%28%281%2Br%29%5En-1%29%2Fr%29,    (1)


where  FV is the future value of the account;  P is the monthly payment (deposit); 
r is the monthly percentage yield presented as a decimal; 
n is the number of deposits (19 in this case).


Under the given conditions, P = 600;  r = 0.198/12;  n = 19.  
So, according to the formula (1), you get at the end of the 20-th year


    FV = 600%2A%28%28%281%2B0.198%2F12%29%5E19-1%29%2F%28%280.198%2F12%29%29%29 = $13262.17.


ANSWER.  $13,262.17.

On Ordinary Annuity saving plans,  see the lessons
    - Ordinary Annuity saving plans and geometric progressions
    - Solved problems on Ordinary Annuity saving plans
in this site.

The lessons contain  EVERYTHING  you need to know about this subject,  in clear and compact form.

When you learn from these lessons,  you will be able to do similar calculations in semi-automatic mode.


/////////////////////


To make such complicated calculations as they are in this problem,
you should have/use an appropriate calculator for such long formulas.

Ideal choice is MS Excel, if you have it in your computer.

Then you write a formula in a text editor, copy-paste it
into an Excel work-sheet cell and click "enter" - the result is ready
in the next second.

If you have no MS Excel in your computer, you may find similar
free of charge calculators in the Internet. One such calculator is

www.desmos.com/calculator

It allows you to do the same thing: you write a formula in a text editor,
copy-paste it into this calculator and click "enter" - the result is ready
in the next second.


Problem 3

James has  $3,000  in credit card debt,  which charges  14% interest. How long will it take
to pay off the card if he makes the minimum payment of  $60  a month?

Solution

Use the formula which connects the loan amount with the monthly payment

    PMT = L%28r%2F%281-%281%2Br%29%5E%28-n%29%29%29.


Here L is the loan amount, 'r' is the monthly effective interest rate, 
PMT is the monthly payments, n is the number of monthly payments (same as the number of months).


Substitute the given numbers into this equation.  You will get

    60 = 3000%2A%28%28%280.14%2F12%29%29%2F%281-%281%2B0.14%2F12%29%5E%28-n%29%29%29.


         This equation is to find 'n'.


Simplify it step by step

    %2860%2F3000%29%2A%2812%2F0.14%29 = 1%2F%281-%281%2B0.14%2F12%29%5E%28-n%29%29

    1.7142857 = 1%2F%281-1.011666667%5E%28-n%29%29    (*)

    1%2F1.7142857 = 1 - 1.011666667^(-n)

    0.583333333 = 1 - 1.011666667^(-n)

    1.011666667^(-n) = 1 - 0.583333333

    1.011666667^(-n) = 0.416666667

    1.011666667^n = 1/0.416666667

    1.011666667^n = 2.4

    n*log(1.011666667^n) = log(2.4)

    n = log%28%282.4%29%29%2Flog%28%281.011666667%29%29 = 75.47706349.


We must round this decimal value to the closest greater integer.


ANSWER.  It requires 76 months, or 6 years and 4 months.

As an alternative to these long calculations, you can solve equation (*) numerically,
using online solver/solvers for non-linear equations.


I did it using online calculator https://comnuan.com/cmnn03/cmnn03007/cmnn03007.php

It produced an output 75.4771, which is quite close to my answer.


You may consider it as a confirming check.


My other lessons on Finance problems in this site are
    - Problems on simple interest accounts
    - Problems on discretely compounded accounts
    - Problems on continuously compounded accounts
    - Find future value of an Ordinary Annuity
    - Find regular deposits for an Ordinary Annuity
    - How long will it take for an ordinary annuity to get an assigned value?
    - Find future value for an Annuity Due saving plan
    - Regular withdrawals from an annuity account
    - Ordinary annuity account with non-zero initial deposit as a combined total of two accounts
    - Annual depositing and semi-annual compounding in ordinary annuity saving plan
    - Variable withdrawals from a compounded account (sinking fund)
    - Present value of an ordinary annuity cumulative saving plan
    - Problems on sinking funds
    - Find the compounding rate of an ordinary annuity
    - Accumulate money using ordinary annuity; then spend money via sinking fund
    - Calculating a retirement plan
    - Accumulating money via ordinary annuity and spending simultaneously via sinking fund
    - Loan problems
    - Mortgage problems
    - One level more complicated non-standard problems on ordinary annuity plans
    - One level more complicated problems on sinking funds
    - One level more complicated non-standard problems on loans
    - Using Excel to find the principal part of a certain loan payment
    - Using Excel to find the interest part of a certain loan payment
    - Tricky problems on present values of annuities
    - OVERVIEW of my lessons on Finance section in this site

Use this file/link  ALGEBRA-I - YOUR ONLINE TEXTBOOK  to navigate over all topics and lessons of the online textbook  ALGEBRA-I.

Use this file/link  ALGEBRA-II - YOUR ONLINE TEXTBOOK  to navigate over all topics and lessons of the online textbook  ALGEBRA-II.



This lesson has been accessed 834 times.