ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
2
3
4
5
6
7
8
9
10
11
12
There is a minimum of 1 Input required for the 50/30/20 Simple Budget Spreadsheet to work
13
14
Cells indicate which cells require input for the spreadsheet to function or which cells can be customised.
15
16
1. Calculationg Weekly, Bi-Weekly and Monthly Amounts
17
18
Enter either the After Tax hourly rate and number of hours worked each week, or
19
20
The Weekly After Tax wage you earn
21
22
If amounts are entered into $/hour and Hours/Week cells, Monthly, Bi-Weekly and Weekly cells will automatically be calculated.
23
If amount is entered into Weekly cell, the Monthly and Bi-Weekly cells will be automatically calculated.
24
25
26
27
28
29
30
31
2. Customising Budget Ratio
32
33
These 3 amounts should always total 100
34
35
For example:
503020= 100
36
602020= 100
37
602515= 100
38
39
40
41
42
43
Should the combined value be less or exceed 100 the values will be highlighted Red
44
45
46
47
48
49
50
3. Understanding the Output
51
52
The percentage spilts on the left are automatically updated as per the cell inputs in Step 2.
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
Based upon the Hourly or Weekly inputs in Step 1. the Weekly, Bi-Weekly or Monthly budget value allocation is displayed
78
In this example, Weekly $308.75 should be allocated to Needs, $185.25 to Wants and $123.5 to Savings
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
budg
94
95
96
97
98
99
100