20-30-50 Guide
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXY
1
Instructions:
2
Step 1: Enter Monthly Take Home Pay in cell B6
3
Step 2: Enter 3 month average Income/spending in GREEN cells in column B
4
Step 3: Evaluate Difference between Actual and 20/30/50 model in Column D
5
6
Monthly Take Home Pay:
$0
7
8
ActualModeledDifference
9
Pay Yourself (20%)$0$0$0
10
Monthly IRA/401K
11
Mutual Fund/Stocks
12
Monthly Savings
13
Flexible Spending (30%)
$0$0$0
14
Groceries
15
Dining Out
16
Entertainment
17
Hobbies (Golf, etc.)
18
Auto Gas
19
20
Fixed Spending (50%)$0$0$0
21
Monthly Mortgage/Rent
22
Utilities
23
Car Payment
24
Gym Membership
25
Cable/Internet/Phone
26
Misc (Netflix, Hulu, etc)
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
Loading...
 
 
 
Sheet1