Automated Savings & Spendings Template

	B	C	D	E	G	H	J	K
1
2	Spouse 1	Pay post-tax (monthly):	$5,000.00
3	Spouse 2	Pay post-tax (monthly):	$4,000.00		Monthly Fixed Costs		Potential Mortgage Payment
4		Total Pay post-tax	$9,000.00		Student Loans	$600.00	Income After Tax	$9,000.00
5					Car Loan	$400.00
6					Car Insurance	$180.00
7	Goal	Percent	Dollars	Destination Account	Gym	$27.00	Automobile Gas	$300
8	Rent	19%	$1,730.00	Account	Internet	$81.00	Fixed Expenses	$1,476.00
9	Fixed Costs	16%	$1,476.00	Account	Utilities	$110.00	General Savings	$1,260.00
10	General Savings	14%	$1,260.00	Account	Subscription	$5.00	Tithe	$900.00
11	Tithe / Donate	10%	$900.00	Account	Subscription 2	$5.00	Retirement	$1,080.00
12	Fun Money - Spouse 1	2%	$180.00	Account	Subscription 3	$6.00	Food	$540.00
13	Fun Money - Spouse 2	2%	$180.00	Account	Gym 2	$25	Fun Money	$360.00
14	Retirement - Spouse 1	8%	$720.00	Account	Netflix	$14.00
15	Retirement - Spouse 2	4%	$360.00	Account	Spotify	$6.00
16	Food - Groceries	4%	$360.00	Account	Amazon Prime	$8.00	Mortgage Payment	$3,084.00
17	Food - Eating Out	2%	$180.00	Account	Hulu	$9.00
18	Remainder	18%	$1,654.00	Account
19
20	General Savings Breakdown						Gross Monthly Income	$12,916.00
21	Goal	Percent	Dollars	Destination Location	Total FC	$1,476.00	Max Mortgage via 28% rule	$3,616.48
22	Emergency Savings	20%	$252.00	Account			Student Loan	$600.00
23	Travel	15%	$189.00	Account			Car Loan	$400.00
24	New Car	15%	$189.00	Account			Current Debt Total	$4,616.48
25	House	30%	$378.00	Account
26	Remaining	20.00%	$252.00	Account			Max Debt Limit (36%)	$3,358.16
27	Total	14%	$1,260.00				Loans Totals	$1,000.00
28							Max Mortgage	$2,358.16
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