Debt Sucks Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
DebtsPriority to Pay
Starting Balance
Interest Rate
**PLEASE READ: Create a copy or download this spreadsheet so you can edit your own version**
2
AMEX2$5,000.0010.00%Step 1: Enter each of your debts, their current balances, interest rates and prioritize them according to how quickly you want to pay them off in cells A2 through D6
3
Citi Card1$3,000.0012.00%Step 2: Create a Debt Grid for each of your debts and enter the starting balance (ex. Cell 15C)
4
Student Loan3$25,000.005.00%Step 3: Adjust the monthly payments under "Amount Paid" column until you can see how many months of payments will get you to a $0 Balance.
5
$XXXStep 4: Adjust the interest for each balance by changing the formula to your interest rate (ex. Cell 16D formula is =(A16-A15)*(.1/365)*C15+C16) You will want to change the pink portion to whatevery your rate is. If your rate is 5% you will change it to .05/365.
6
$XXXStep 5: As you make actual payments, update the Amount Paid column accordingly so you can see how it affects your payoff schedule.
7
8
Total Debt$33,000.00Payment made
9
Final Payment
10
PAID OFF!
11
12
AMEX - EXAMPLE DEBT GRID
Citi CardStudent Loan
13
14
DateAmount PaidBalanceBalance Plus InterestDateAmount PaidBalanceBalance Plus InterestDateAmount PaidBalanceBalance Plus Interest
15
1/1/2016-$5,000.00$5,150.001/1/2016-$3,000.00$3,000.001/1/2016-$25,000.00$25,000.00
16
1/8/2016$250.00$4,900.00$4,909.591/8/2016$250.00$2,750.00$2,756.901/8/2016$250.00$24,750.00$24,773.97
17
2/8/2016$700.00$4,209.59$4,251.212/8/2016$0.00$2,756.90$2,784.932/8/2016$0.00$24,773.97$24,879.08
18
3/8/2016$700.00$3,551.21$3,584.653/8/2016$0.00$2,784.93$2,811.223/8/2016$0.00$24,879.08$24,977.49
19
4/8/2016$700.00$2,884.65$2,914.814/8/2016$0.00$2,811.22$2,839.604/8/2016$0.00$24,977.49$25,083.14
20
5/8/2016$700.00$2,214.81$2,238.525/8/2016$0.00$2,839.60$2,867.335/8/2016$0.00$25,083.14$25,185.79
21
6/8/2016$700.00$1,538.52$1,557.336/8/2016$0.00$2,867.33$2,896.276/8/2016$0.00$25,185.79$25,292.31
22
7/8/2016$700.00$857.33$869.987/8/2016$0.00$2,896.27$2,924.557/8/2016$0.00$25,292.31$25,395.81
23
8/8/2016$700.00$169.98$177.268/8/2016$0.00$2,924.55$2,954.078/8/2016$0.00$25,395.81$25,503.22
24
9/8/2016$18.35$158.91$308.919/8/2016$0.00$2,954.07$2,983.879/8/2016$0.00$25,503.22$25,611.06
25
10/8/2016$0.00$2,983.87$3,013.0110/8/2016$0.00$25,611.06$25,715.87
26
11/8/2016$0.00$3,013.01$3,043.4211/8/2016$0.00$25,715.87$25,824.63
27
12/8/2016$0.00$3,043.42$3,073.1412/8/2016$0.00$25,824.63$25,930.31
28
1/8/2017$0.00$3,073.14$3,104.151/8/2017$0.00$25,930.31$26,039.98
29
2/8/2017$0.00$3,104.15$3,135.482/8/2017$0.00$26,039.98$26,150.09
30
3/8/2017$0.00$3,135.48$3,164.053/8/2017$0.00$26,150.09$26,249.97
31
4/8/2017$0.00$3,164.05$3,196.014/8/2017$0.00$26,249.97$26,361.02
32
5/8/2017$0.00$3,196.01$3,227.215/8/2017$0.00$26,361.02$26,468.90
33
6/8/2017$0.00$3,227.21$3,259.796/8/2017$0.00$26,468.90$26,580.84
34
7/8/2017$0.00$3,259.79$3,291.627/8/2017$0.00$26,580.84$26,689.62
35
8/8/2017$0.00$3,291.62$3,324.848/8/2017$0.00$26,689.62$26,802.49
36
9/8/2017$0.00$3,324.84$3,358.399/8/2017$0.00$26,802.49$26,915.83
37
10/8/2017$0.00$3,358.39$3,391.1810/8/2017$0.00$26,915.83$27,025.98
38
11/8/2017$0.00$3,391.18$3,425.4111/8/2017$0.00$27,025.98$27,140.28
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu