Credit Card Debt Calculator (Blueprint)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJ
1
2
Credit Card can be rather convenient to help you out when you have a cash crunch, but you have to be careful if you pay the minimum sum and roll over your debt.

This calculator, helps you visualize
1) How much total interest you will pay
2) How long it takes you to pay off
3) What if you add more debt to the debt you rolled over
4) What if you pay off more debt monthly

Instructions
1) Only enter information into the GREY cells, the blue cells auto-computes value, be careful not to override them
2) Starting Debt Balance: The initial debt you bring forward.
3) Start Date: Date where you start planning the credit card debt
4) APR Rate: The Annual Payment Rate or annual interest you will have to pay. Go to your credit card website and search its APR Rate. It should be very high typically greater than 10%
5) Min Payment: The minimum payment your credit card company allow you to pay
6) Min Payment %: If what you owe is larger than this percentage, the credit card company will not let you pay the Min Payment in (5) but this percentage amount.
3
Visit InvestmentMoats.com today for more useful resources and wealth building articles like this
4
5
Starting Debt Balance$5,000.00Total Interest$3,143.75
6
Start Date1-Jan-2014Total Debt$5,000
7
APR Rate25.00%Months to pay off81Years6.75
8
Min Payment$50.00Month paid offOct-20
9
Min Payment %5.00%Interest % of Debt62.88%
10
11
NoYear/MonthAdd more debtMin payment monthlyAdditional payment monthlyTotal payment monthlyEIRInterest on last mth debt balanceDebt Balance
12
0Jan-14$5,000.00
13
1Feb-140$250.00$0.00$250.002.08%$103.77$4,853.77
14
2Mar-140$242.69$0.00$242.692.08%$100.73$4,711.81
15
3Apr-140$235.59$0.00$235.592.08%$97.79$4,574.01
16
4May-140$228.70$0.00$228.702.08%$94.93$4,440.24
17
5Jun-140$222.01$0.00$222.012.08%$92.15$4,310.38
18
6Jul-140$215.52$0.00$215.522.08%$89.45$4,184.31
19
7Aug-140$209.22$0.00$209.222.08%$86.84$4,061.93
20
8Sep-140$203.10$0.00$203.102.08%$84.30$3,943.13
21
9Oct-140$197.16$0.00$197.162.08%$81.83$3,827.80
22
10Nov-140$191.39$0.00$191.392.08%$79.44$3,715.85
23
11Dec-140$185.79$0.00$185.792.08%$77.12$3,607.18
24
12Jan-150$180.36$0.00$180.362.08%$74.86$3,501.68
25
13Feb-150$175.08$0.00$175.082.08%$72.67$3,399.27
26
14Mar-150$169.96$0.00$169.962.08%$70.55$3,299.86
27
15Apr-150$164.99$0.00$164.992.08%$68.48$3,203.35
28
16May-150$160.17$0.00$160.172.08%$66.48$3,109.66
29
17Jun-150$155.48$0.00$155.482.08%$64.54$3,018.72
30
18Jul-150$150.94$0.00$150.942.08%$62.65$2,930.43
31
19Aug-150$146.52$0.00$146.522.08%$60.82$2,844.73
32
20Sep-150$142.24$0.00$142.242.08%$59.04$2,761.53
33
21Oct-150$138.08$0.00$138.082.08%$57.31$2,680.76
34
22Nov-150$134.04$0.00$134.042.08%$55.63$2,602.35
35
23Dec-150$130.12$0.00$130.122.08%$54.01$2,526.24
36
24Jan-160$126.31$0.00$126.312.08%$52.43$2,452.36
37
25Feb-160$122.62$0.00$122.622.08%$50.89$2,380.63
38
26Mar-160$119.03$0.00$119.032.08%$49.41$2,311.01
39
27Apr-160$115.55$0.00$115.552.08%$47.96$2,243.42
40
28May-160$112.17$0.00$112.172.08%$46.56$2,177.81
41
29Jun-160$108.89$0.00$108.892.08%$45.20$2,114.12
42
30Jul-160$105.71$0.00$105.712.08%$43.88$2,052.29
43
31Aug-160$102.61$0.00$102.612.08%$42.59$1,992.27
44
32Sep-160$99.61$0.00$99.612.08%$41.35$1,934.01
45
33Oct-160$96.70$0.00$96.702.08%$40.14$1,877.45
46
34Nov-160$93.87$0.00$93.872.08%$38.96$1,822.54
47
35Dec-160$91.13$0.00$91.132.08%$37.82$1,769.23
48
36Jan-170$88.46$0.00$88.462.08%$36.72$1,717.49
49
37Feb-170$85.87$0.00$85.872.08%$35.64$1,667.26
50
38Mar-170$83.36$0.00$83.362.08%$34.60$1,618.50
51
39Apr-170$80.93$0.00$80.932.08%$33.59$1,571.16
52
40May-170$78.56$0.00$78.562.08%$32.61$1,525.21
53
41Jun-170$76.26$0.00$76.262.08%$31.65$1,480.60
54
42Jul-170$74.03$0.00$74.032.08%$30.73$1,437.30
55
43Aug-170$71.87$0.00$71.872.08%$29.83$1,395.26
56
44Sep-170$69.76$0.00$69.762.08%$28.96$1,354.46
57
45Oct-170$67.72$0.00$67.722.08%$28.11$1,314.85
58
46Nov-170$65.74$0.00$65.742.08%$27.29$1,276.40
59
47Dec-170$63.82$0.00$63.822.08%$26.49$1,239.07
60
48Jan-180$61.95$0.00$61.952.08%$25.71$1,202.83
61
49Feb-180$60.14$0.00$60.142.08%$24.96$1,167.65
62
50Mar-180$58.38$0.00$58.382.08%$24.23$1,133.50
63
51Apr-180$56.68$0.00$56.682.08%$23.52$1,100.34
64
52May-180$55.02$0.00$55.022.08%$22.84$1,068.16
65
53Jun-180$53.41$0.00$53.412.08%$22.17$1,036.92
66
54Jul-180$51.85$0.00$51.852.08%$21.52$1,006.59
67
55Aug-180$50.33$0.00$50.332.08%$20.89$977.15
68
56Sep-180$50.00$0.00$50.002.08%$20.28$947.43
69
57Oct-180$50.00$0.00$50.002.08%$19.66$917.09
70
58Nov-180$50.00$0.00$50.002.08%$19.03$886.12
71
59Dec-180$50.00$0.00$50.002.08%$18.39$854.51
72
60Jan-190$50.00$0.00$50.002.08%$17.73$822.24
73
61Feb-190$50.00$0.00$50.002.08%$17.06$789.30
74
62Mar-190$50.00$0.00$50.002.08%$16.38$755.68
75
63Apr-190$50.00$0.00$50.002.08%$15.68$721.36
76
64May-190$50.00$0.00$50.002.08%$14.97$686.33
77
65Jun-190$50.00$0.00$50.002.08%$14.24$650.57
78
66Jul-190$50.00$0.00$50.002.08%$13.50$614.07
79
67Aug-190$50.00$0.00$50.002.08%$12.74$576.81
80
68Sep-190$50.00$0.00$50.002.08%$11.97$538.78
81
69Oct-190$50.00$0.00$50.002.08%$11.18$499.96
82
70Nov-190$50.00$0.00$50.002.08%$10.38$460.34
83
71Dec-190$50.00$0.00$50.002.08%$9.55$419.89
84
72Jan-200$50.00$0.00$50.002.08%$8.71$378.60
85
73Feb-200$50.00$0.00$50.002.08%$7.86$336.46
86
74Mar-200$50.00$0.00$50.002.08%$6.98$293.44
87
75Apr-200$50.00$0.00$50.002.08%$6.09$249.53
88
76May-200$50.00$0.00$50.002.08%$5.18$204.71
89
77Jun-200$50.00$0.00$50.002.08%$4.25$158.96
90
78Jul-200$50.00$0.00$50.002.08%$3.30$112.26
91
79Aug-200$50.00$0.00$50.002.08%$2.33$64.59
92
80Sep-200$50.00$0.00$50.002.08%$1.34$15.93
93
81Oct-200$50.00$0.00$50.002.08%$0.33-$33.74
94
0$0.00
95
0$0.00
96
0$0.00
97
0$0.00
98
0$0.00
99
0$0.00
100
0$0.00
Loading...
 
 
 
Main
XIRR
 
 
Main menu