Debt Sucks Spreadsheet

	A	B	C	D	F	G	H	I	K	L	M	N
1	Debts	Priority to Pay	Starting Balance	Interest Rate	PLEASE READ: Create a copy or download this spreadsheet so you can edit your own version
2	AMEX	2	$5,000.00	10.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 Card	1	$3,000.00	12.00%	Step 2: Create a Debt Grid for each of your debts and enter the starting balance (ex. Cell 15C)
4	Student Loan	3	$25,000.00	5.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			$XXX		Step 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			$XXX		Step 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.00				Payment made
9							Final Payment
10							PAID OFF!
11
12	AMEX - EXAMPLE DEBT GRID				Citi Card				Student Loan
13
14	Date	Amount Paid	Balance	Balance Plus Interest	Date	Amount Paid	Balance	Balance Plus Interest	Date	Amount Paid	Balance	Balance Plus Interest
15	1/1/2018	-	$5,000.00	$5,000.00	1/1/2018	-	$3,000.00	$3,000.00	1/1/2018	-	$25,000.00	$25,000.00
16	2/1/2018	$250.00	$4,750.00	$4,792.47	2/1/2018	$250.00	$2,750.00	$2,780.58	2/1/2018	$250.00	$24,750.00	$24,856.16
17	3/1/2018	$700.00	$4,092.47	$4,128.90	3/1/2018	$0.00	$2,780.58	$2,805.89	3/1/2018	$0.00	$24,856.16	$24,951.10
18	4/1/2018	$700.00	$3,428.90	$3,463.66	4/1/2018	$0.00	$2,805.89	$2,834.23	4/1/2018	$0.00	$24,951.10	$25,056.65
19	5/1/2018	$700.00	$2,763.66	$2,791.84	5/1/2018	$0.00	$2,834.23	$2,861.90	5/1/2018	$0.00	$25,056.65	$25,159.19
20	6/1/2018	$700.00	$2,091.84	$2,115.32	6/1/2018	$0.00	$2,861.90	$2,890.79	6/1/2018	$0.00	$25,159.19	$25,265.59
21	7/1/2018	$700.00	$1,415.32	$1,432.51	7/1/2018	$0.00	$2,890.79	$2,919.02	7/1/2018	$0.00	$25,265.59	$25,368.99
22	8/1/2018	$700.00	$732.51	$744.53	8/1/2018	$0.00	$2,919.02	$2,948.48	8/1/2018	$0.00	$25,368.99	$25,476.28
23	9/1/2018	$700.00	$44.53	$50.75	9/1/2018	$0.00	$2,948.48	$2,978.23	9/1/2018	$0.00	$25,476.28	$25,584.01
24	10/1/2018	$360.00	-$309.25	-$308.88	10/1/2018	$0.00	$2,978.23	$3,007.31	10/1/2018	$0.00	$25,584.01	$25,688.71
25					11/1/2018	$0.00	$3,007.31	$3,037.66	11/1/2018	$0.00	$25,688.71	$25,797.35
26					12/1/2018	$0.00	$3,037.66	$3,067.32	12/1/2018	$0.00	$25,797.35	$25,902.92
27					1/1/2019	$0.00	$3,067.32	$3,098.28	1/1/2019	$0.00	$25,902.92	$26,012.47
28					2/1/2019	$0.00	$3,098.28	$3,129.55	2/1/2019	$0.00	$26,012.47	$26,122.47
29					3/1/2019	$0.00	$3,129.55	$3,158.07	3/1/2019	$0.00	$26,122.47	$26,222.25
30					4/1/2019	$0.00	$3,158.07	$3,189.96	4/1/2019	$0.00	$26,222.25	$26,333.18
31					5/1/2019	$0.00	$3,189.96	$3,221.11	5/1/2019	$0.00	$26,333.18	$26,440.94
32					6/1/2019	$0.00	$3,221.11	$3,253.62	6/1/2019	$0.00	$26,440.94	$26,552.76
33					7/1/2019	$0.00	$3,253.62	$3,285.39	7/1/2019	$0.00	$26,552.76	$26,661.43
34					8/1/2019	$0.00	$3,285.39	$3,318.55	8/1/2019	$0.00	$26,661.43	$26,774.18
35					9/1/2019	$0.00	$3,318.55	$3,352.04	9/1/2019	$0.00	$26,774.18	$26,887.40
36					10/1/2019	$0.00	$3,352.04	$3,384.77	10/1/2019	$0.00	$26,887.40	$26,997.43
37					11/1/2019	$0.00	$3,384.77	$3,418.93	11/1/2019	$0.00	$26,997.43	$27,111.61
38					12/1/2019	$0.00	$3,418.93	$3,452.31	12/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