ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Revenue Expense Profit
2
$ 53,000.00 $ 36,468.84 $ 16,531.16
3
100%69%31%
example 70k salary with 5k bonus
4
5
Fixed Revenues Spring Summer Winter
6
Type Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
7
Full-time work $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 9,000.00 $ 53,000.00
8
9
Fixed Expenses
10
Type Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total % fix % tot exp
11
Rent $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 18,000.00 90.8%49.4%
12
Phone $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 28.25 $ 339.00 1.7%0.9%
13
Rental Insurance $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 17.42 $ 209.04 1.1%0.6%
14
Gym/ sports $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 106.00 $ 1,272.00 6.4%3.5%
15
internet, electricity, laundry
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 0.0%0.0%
16
Total $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 1,651.67 $ 19,820.04 100.0%54.3%
17
Variable Expenses $ -
18
Type Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total % var % tot exp
19
Transportation $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 82.40 $ 988.80 5.9%2.7%
20
Grocery $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 5,400.00 32.4%14.8%
21
Restaurant $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 6,000.00 36.0%16.5%
22
Entertainment $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 600.00 3.6%1.6%
23
Hobby $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 125.00 $ 1,500.00 9.0%4.1%
24
Haircut $ 100.00 $ - $ 40.00 $ - $ 100.00 $ - $ 40.00 $ - $ 100.00 $ - $ 40.00 $ - $ 420.00 2.5%1.2%
25
Cosmetic (Face, Hair) $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 600.00 3.6%1.6%
26
Utilities (Hygiene) $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 40.00 $ 480.00 2.9%1.3%
27
Utilities (House) $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 360.00 2.2%1.0%
28
Health Pills $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 300.00 1.8%0.8%
29
Total $ 1,452.40 $ 1,352.40 $ 1,392.40 $ 1,352.40 $ 1,452.40 $ 1,352.40 $ 1,392.40 $ 1,352.40 $ 1,452.40 $ 1,352.40 $ 1,392.40 $ 1,352.40 $ 16,648.80 100.0%45.7%
30
31
Revenue $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 9,000.00 $ 53,000.00
32
Expenses $ 3,104.07 $ 3,004.07 $ 3,044.07 $ 3,004.07 $ 3,104.07 $ 3,004.07 $ 3,044.07 $ 3,004.07 $ 3,104.07 $ 3,004.07 $ 3,044.07 $ 3,004.07 $ 36,468.84
33
Profit/loss $ 895.93 $ 995.93 $ 955.93 $ 995.93 $ 895.93 $ 995.93 $ 955.93 $ 995.93 $ 895.93 $ 995.93 $ 955.93 $ 5,995.93 $ 16,531.16
34
35
avg exp $ 3,039.07
36
avg savings w.Bonus
$ 1,377.60
Emergency funds
37
Avg savings no bonus
$ 957.75 $ 9,117.21
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