Debt - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2		Interest Rate	Monthly Payment	Balance as of 1/01/2022	Balance as of 1/01/2023	Balance as of xx	Balance as of xx	Balance as of xx	Balance as of xx	Balance as of xx	Balance as of xx	Balance as of xx	Balance as of xx	Balance as of xx
3
4	Discover	27%		$ 1,500.00	$ 1,000.00
5	American Express	20%		$ 875.30	$ 500.00
6	Home Depot	18%		$ 425.50	$ -
7
8
9
10
11
12	Mortgage	5%	$ 950.00	$ 150,000.00	$ 140,000.00
13	Car Loan	3%	$ 300.00	$ 25,000.00	$ 22,000.00
14
15
16
17				$ 177,800.80	$ 163,500.00	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
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