CheckBook Debts and PayOff.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2	Debts and Payoffs
3	For More Free Financial Resources go to Linktr.ee/GQ_accountant
4
5	Debt Sources by Category		Amount of Debt		Interest Rate		Monthly Payment		Months to Payoff		Total Payments		Total Interest from PMTs		Total Payoff (In years)
6	Credit Card #1	1	$3,500.00	2	19.24%	3	$103.67	4	49		$5,079.65	5	$1,571.00	6	4.08
7	Credit Card #2		$4,192.00		14.99%		$114.91		49		$5,630.35		$1,437.00		4.08
8	Credit Card #3		$1,154.00		16.99%		$32.82		49		$1,608.05		$450.00		4.08
9	Total Credit Card Debt		$8,846.00				$251.39				$12,318.05		$3,458.00		4.08
10
11	Auto Loan #1	7	$10,000.00	8	3.93%		$183.85	9	60		$11,030.97	10	$1,030.00	11	5.00
12	Auto Loan #2		$18,000.00		3.71%		$329.15		60		$19,748.82		$1,750.00		5.00
13	Total Auto Loans		$28,000.00				$513.00				$30,779.79		$2,780.00		5.00
14
15	Student Loans #1	12	$31,000.00	13	5.99%		$221.91	14	240		$53,259.56	15	$22,241.00	16	20.00
16	Student Loans #2		$27,000.00		5.99%		$193.28		240		$46,387.36		$19,450.00		20.00
17	Total Student Loans		$58,000.00				$415.20				$99,646.91		$41,691.00		20.00
18
19	Mortgage	17	$189,000.00	18	3.99%		$901.23	19	360		$324,441.23	20	$135,440.00	21	30.00
20	Investment Property or Other property (if Any)		$0.00		0.00%		$0.00		180		$0.00		$0.00		15.00
21	Total Mortgage		$189,000.00				$901.23				$324,441.23		$135,440.00		22.50
22
23	Total Debts	22	$283,846.00			23	$2,080.81		143	24	$467,185.98	25	$183,369.00		11.92
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