ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Monthly take-home pay (after taxes + 401k contributions)
$4,000
*File --> Make a Copy or Download in order to edit
3
4
CurrentTarget
5
50%50%(Range 50-60%)
6
1. Fixed Costs$2,000$2,000Instructions:
7
Rent/Mortgage$1,050
1. Enter your monthly take-home pay (after taxes) into cell B2
8
Utilities$200
2. Adjust the target weights if necessary between the ranges provided.
9
Medical Insurance and bills$125
3. Enter your spending in each category. You can replace "Other" with whatever you like.
10
Transportation (Cay payment, gas, etc.)$350
4. Make sure the percentages in row 50 both equal 100%
11
Debt Payments$125
12
Groceries$100
13
Internet$50
14
Other
15
Other
16
Other
17
Other
18
19
20%20%(Range 10-20%)
20
2. Investments$800$800
21
401K$300
22
IRA$400
23
HSA$100
24
Other
25
Other
26
Other
27
28
10%10%(Range 5-10%)
29
3. Savings$400$400
30
Vacations$200
31
House Down Payment$100
32
Emergency Fund$100
33
Other
34
Other
35
36
20%20%(Range 20-30%)
37
4. Guilt-Free Spending$800$800
38
Dining Out$200
39
Movies$50
40
Clothes$150
41
Video Games$50
42
Netflix$15
43
Gym$50
44
Other$285
45
Other
46
Other
47
Other
48
49
Total Spending$4,000$4,000
50
100%100%
<-- Make sure these both equal 100%
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