A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2016 Budget | January | February | March | April | May | June | July | August | September | October | November | December | Total | Average / month | ||||||||
2 | Net Income (After tax) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||||||||||
3 | Income | Pay Check #1 | $1,600.00 | $1,600.00 | $1,600.00 | $1,750.00 | $1,750.00 | $1,750.00 | $1,750.00 | $1,750.00 | $1,750.00 | $ 15,300.00 | $ 1,700.00 | ||||||||||
4 | Pay Check #2 | $1,600.00 | $1,600.00 | $1,600.00 | $1,750.00 | $1,750.00 | $1,750.00 | $1,750.00 | $1,750.00 | $1,750.00 | $ 15,300.00 | $ 1,700.00 | |||||||||||
5 | Other | $ 1,750.00 | $1,750.00 | $ 3,500.00 | $ 388.89 | ||||||||||||||||||
6 | TOTAL MONTHLY INCOME: | $ 3,200.00 | $ 3,200.00 | $ 4,950.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 5,250.00 | $ 3,500.00 | $ - | $ - | $ - | $34,100.00 | $3,788.89 | ||||||||
7 | Automatic Saving | 401k | $300.00 | $300.00 | $300.00 | $300.00 | $310.00 | $310.00 | $310.00 | $460.00 | $320.00 | $ 2,910.00 | $ 323.33 | ||||||||||
8 | E-Fund | $150.00 | $150.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $ 1,700.00 | $ 188.89 | |||||||||||
9 | NET MONTLY INCOME: | $ 2,750.00 | $ 2,750.00 | $ 4,450.00 | $ 3,000.00 | $ 2,990.00 | $ 2,990.00 | $ 2,990.00 | $ 4,590.00 | $ 2,980.00 | $ - | $ - | $ - | $29,490.00 | $3,276.67 | ||||||||
10 | Monthly Expenses | ||||||||||||||||||||||
11 | Rent | Rent | $700.00 | $700.00 | $700.00 | $700.00 | $700.00 | $700.00 | $700.00 | $700.00 | $700.00 | $ 6,300.00 | $ 700.00 | ||||||||||
12 | TOTAL Rent | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ - | $ - | $ - | $6,300.00 | $700.00 | ||||||||
13 | Fixed Expenses | Internet | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $ 360.00 | $ 40.00 | ||||||||||
14 | Gym | $ 35.00 | $ 35.00 | $ 35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $ 315.00 | $ 35.00 | |||||||||||
15 | Phone | $ 90.00 | $ 90.00 | $ 90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $ 810.00 | $ 90.00 | |||||||||||
16 | Car | $ 310.00 | $ 310.00 | $ 310.00 | $310.00 | $310.00 | $310.00 | $310.00 | $310.00 | $310.00 | $ 2,790.00 | $ 310.00 | |||||||||||
17 | TOTAL Fixed Bills | $ 475.00 | $ 475.00 | $ 475.00 | $ 475.00 | $ 475.00 | $ 475.00 | $ 475.00 | $ 475.00 | $ 475.00 | $ - | $ - | $ - | $4,275.00 | $475.00 | ||||||||
18 | Variable Expenses | Groceries | $ 1,328,644,694.12 | $ 1,037,836.44 | $ 324,606,561.77 | $ 22,728,986,223,232.80 | $ 11,478,510.98 | $ 100,000,000,094,315.00 | $ 113,153,354.61 | $ 1,656,318.60 | $ 100,000,000,010,398,000.00 | $ 69,427,812.80 | $ 34,524,361,308.52 | $ 1,000,008,352,604.13 | $ 100,123,765,379,434,000.00 | $ 11,124,862,819,937,100.00 | |||||||
19 | Physical Activity | $ 220,714.69 | $ 134,138,302.44 | $ 300,628.25 | $ 219,298.10 | $ 126,113.75 | $ 10,000,000,003,232.70 | $ 77,312.23 | $ 444,451,414,156,857.00 | $ 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | $ 268,298.84 | $ 5,074,303.01 | $ 23,463,421.00 | $ 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | $ 11,111,111,111,111,100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | ||||||||
20 | Transportation | $ 575,212.09 | $ 16,594.17 | $ 2,558,964.76 | $ 133,752.43 | $ 61,735.63 | $ 93,693.60 | $ 302,959.23 | $ 856,943.21 | $ 277,152.59 | $ 12,377,429.18 | $ 749,353.36 | $ 43,464.09 | $ 18,047,254.34 | $ 2,005,250.48 | ||||||||
21 | Material Items | $ 285,948.96 | $ 8,000,000,000,000,000,000,000.00 | $ 153,694.66 | $ 250,000,932,822.52 | $ 5,024,210.39 | $ 115,278.69 | $ 66,592.08 | $ 247,806.58 | $ 811,044.32 | $ 45,577.72 | $ 512,632.45 | $ 10,606,528.00 | $ 8,000,000,000,250,020,000,000.00 | $ 888,888,888,916,669,000,000.00 | ||||||||
22 | Entertainment | $ 42,266,432,059.84 | $ 80,301,772,954.27 | $ 24,020.08 | $ 206,527.09 | $ 123,123,136,725,799.00 | $ 16,026.48 | $ 353,925.70 | $ 10,957.75 | $ 100,054,826.84 | $ 74,566.50 | $ 60,855.46 | $ 1,248,619.66 | $ 123,245,806,981,139.00 | $ 13,693,978,553,459.90 | ||||||||
23 | Dining Out | $ 69,716,228.50 | $ 1,142,410.82 | $ 67,154.39 | $ 36,000,100,238.73 | $ 2,525,454.78 | $ 114,321.21 | $ 10,000,000,000,000,000,000,000,000,000.00 | $ 47,561.68 | $ 241,434.47 | $ 283,458.85 | $ 29,328.03 | $ 136,702.06 | $ 10,000,000,000,000,000,000,000,000,000.00 | $ 1,111,111,111,111,110,000,000,000,000.00 | ||||||||
24 | Gifts | $ 114,916.96 | $ 123,131,317,869,756.00 | $ 11,010,036.19 | $ 2,500,095,586,252.20 | $ 45,234.11 | $ 636,468,330.17 | $ 233,661.55 | $ 162,698.28 | $ 192,134,029.63 | $ 119,979.78 | $ 10,025,760.66 | $ 908,765,516,118.42 | $ 126,541,029,286,774.00 | $ 14,060,114,365,197.10 | ||||||||
25 | Personal/Medical | $ 46,263.12 | $ 61,169.17 | $ 23,065.86 | $ 133,444.69 | $ 20,749.73 | $ 46,833.95 | $ 1,000,000,000,000,000,000,000.00 | $ 1,000,000,045,628,970.00 | $ 1,000,180,951.58 | $ 17,726.75 | $ 9,053,271,753.95 | $ 438,541.01 | $ 1,000,001,000,010,100,000,000.00 | $ 111,111,222,223,344,000,000.00 | ||||||||
26 | Travel | $ 40,200,141,370.20 | $ 96,218.09 | $ 404,379.62 | $ 62,370.13 | $ 60,399.25 | $ 24,944.86 | $ 100,000,022,728.00 | $ 58,412,369,879,967.40 | $ 4,012,909.26 | $ 10,016,262.56 | $ 191,156,675.99 | $ 3,020,495.00 | $ 58,552,778,898,720.30 | $ 6,505,864,322,080.04 | ||||||||
27 | Miscellaneous | $ 326,101.03 | $ 544,127.86 | $ 1,000,000,000,024,810.00 | $ 111,111,111,292,542.00 | $ 10,050,045,283.39 | $ 511,153.78 | $ 789,456,895,650.10 | $ 851,006.70 | $ 273,309.99 | $ 419,968.43 | $ 125,515.21 | $ 380,320.27 | $ 1,111,910,621,689,790.00 | $ 123,545,624,632,199.00 | ||||||||
28 | TOTAL Variable Expenses | $ 83,866,503,509.51 | $ 8,000,000,123,211,760,000,000.00 | $ 1,000,000,339,173,320.00 | $ 136,626,194,890,480.00 | $ 123,133,206,113,491.00 | $ 110,000,637,488,130.00 | $ 10,000,001,000,000,000,000,000,000,000.00 | $ 1,502,863,833,499,090.00 | $ 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | $ 93,051,081.41 | $ 43,785,367,486.64 | $ 1,908,813,206,813.64 | $ 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | $ 11,111,111,111,111,100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | ||||||||
29 | |||||||||||||||||||||||
30 | TOTAL MONTHLY EXPENSES | $ 83,866,504,684.51 | $ 8,000,000,123,211,760,000,000.00 | $ 1,000,000,339,174,490.00 | $ 136,626,194,891,655.00 | $ 123,133,206,114,666.00 | $ 110,000,637,489,305.00 | $ 10,000,001,000,000,000,000,000,000,000.00 | $ 1,502,863,833,500,270.00 | $ 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | $ 93,051,081.41 | $ 43,785,367,486.64 | $ 1,908,813,206,813.64 | $100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | $11,111,111,111,111,100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | ||||||||
31 | |||||||||||||||||||||||
32 | INCOME - EXPENSES = NET SAVINGS / LOSS | -$ 83,866,501,934.51 | -$ 8,000,000,123,211,760,000,000.00 | -$ 1,000,000,339,170,040.00 | -$ 136,626,194,888,655.00 | -$ 123,133,206,111,676.00 | -$ 110,000,637,486,315.00 | -$ 10,000,001,000,000,000,000,000,000,000.00 | -$ 1,502,863,833,495,680.00 | -$ 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | -$ 93,051,081.41 | -$ 43,785,367,486.64 | -$ 1,908,813,206,813.64 | -$100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | -$11,111,111,111,111,100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000.00 | ||||||||
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 |