ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
DebtsPriority to PayStarting BalanceInterest 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 Starting 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/2018-$5,000.00$5,000.001/1/2018-$3,000.00$3,000.001/1/2018-$25,000.00$25,000.00
16
2/1/2018$250.00$4,750.00$4,792.472/1/2018$250.00$2,750.00$2,780.582/1/2018$250.00$24,750.00$24,856.16
17
3/1/2018$700.00$4,092.47$4,128.903/1/2018$0.00$2,780.58$2,805.893/1/2018$0.00$24,856.16$24,951.10
18
4/1/2018$700.00$3,428.90$3,463.664/1/2018$0.00$2,805.89$2,834.234/1/2018$0.00$24,951.10$25,056.65
19
5/1/2018$700.00$2,763.66$2,791.845/1/2018$0.00$2,834.23$2,861.905/1/2018$0.00$25,056.65$25,159.19
20
6/1/2018$700.00$2,091.84$2,115.326/1/2018$0.00$2,861.90$2,890.796/1/2018$0.00$25,159.19$25,265.59
21
7/1/2018$700.00$1,415.32$1,432.517/1/2018$0.00$2,890.79$2,919.027/1/2018$0.00$25,265.59$25,368.99
22
8/1/2018$700.00$732.51$744.538/1/2018$0.00$2,919.02$2,948.488/1/2018$0.00$25,368.99$25,476.28
23
9/1/2018$700.00$44.53$50.759/1/2018$0.00$2,948.48$2,978.239/1/2018$0.00$25,476.28$25,584.01
24
10/1/2018$360.00-$309.25-$308.8810/1/2018$0.00$2,978.23$3,007.3110/1/2018$0.00$25,584.01$25,688.71
25
11/1/2018$0.00$3,007.31$3,037.6611/1/2018$0.00$25,688.71$25,797.35
26
12/1/2018$0.00$3,037.66$3,067.3212/1/2018$0.00$25,797.35$25,902.92
27
1/1/2019$0.00$3,067.32$3,098.281/1/2019$0.00$25,902.92$26,012.47
28
2/1/2019$0.00$3,098.28$3,129.552/1/2019$0.00$26,012.47$26,122.47
29
3/1/2019$0.00$3,129.55$3,158.073/1/2019$0.00$26,122.47$26,222.25
30
4/1/2019$0.00$3,158.07$3,189.964/1/2019$0.00$26,222.25$26,333.18
31
5/1/2019$0.00$3,189.96$3,221.115/1/2019$0.00$26,333.18$26,440.94
32
6/1/2019$0.00$3,221.11$3,253.626/1/2019$0.00$26,440.94$26,552.76
33
7/1/2019$0.00$3,253.62$3,285.397/1/2019$0.00$26,552.76$26,661.43
34
8/1/2019$0.00$3,285.39$3,318.558/1/2019$0.00$26,661.43$26,774.18
35
9/1/2019$0.00$3,318.55$3,352.049/1/2019$0.00$26,774.18$26,887.40
36
10/1/2019$0.00$3,352.04$3,384.7710/1/2019$0.00$26,887.40$26,997.43
37
11/1/2019$0.00$3,384.77$3,418.9311/1/2019$0.00$26,997.43$27,111.61
38
12/1/2019$0.00$3,418.93$3,452.3112/1/2019$0.00$27,111.61$27,222.56
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