Quizzes & Puzzles0 min ago
How long will it take for me to repay my credit card?
4 Answers
Does anyone know of a site where i can work out how long it will take to repay my credit card bill?
Answers
1 to 4 of 4
Best Answer
No best answer has yet been selected by splodge24. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
It is fairly simple to work this out on excel - if you know your way round excel -give me a shout and I will walk you through it.
Credit cards are a very expensive way to borrow - if you had a �1000.00 balance and only paid off the minimum (lets say 5% of the balance OR �10) and if the APR is 19.9% - it will take you 54 months to clear it!!!!
Credit cards are a very expensive way to borrow - if you had a �1000.00 balance and only paid off the minimum (lets say 5% of the balance OR �10) and if the APR is 19.9% - it will take you 54 months to clear it!!!!
well, since you said please....
In A1, put in your balance (eg �1000.00).
In B1 put in the following formula: =MAX(A1*x%,y)
where x is the minimum percentage payment you plan on making eg 5%
y is the physical minimum payment eg �10.00
The answer in B1 (if you follow the above example) is 50. This is your minimum payment
Now in column A2 you need to add the interest.Put in the following:
=SUM(A1-B1)+(A1-B1)*(z%/12)
where z% is your APR (APR is the yearly iterest rate - if you know the monthly interest rate you can put this in instead of z/12)
Now extend the formulas down, and you will see how many months it will take you to pay it off.
If you follow the above example, it month 60 there will be a balance of �103.08
Hope this helps - any problems, repost
1 to 4 of 4
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.