Money Flow Planner

	A	B	C	D	E	F
1	Money Flow Planner by Evans Musomi (www.evansmusomi.com). Use either of the 3 calculators below (titled with blue-background). Enter an amount in the cell specified and the rest of the fields update to show how much you should spend on various items using the percentages in column 'C'. Adjust the percentages to suite your needs.
2	Enter your gross income in Cell 'E3' to see new amounts to spend per item. Adjust percentages in Column C to suite your situation.
3	TAXABLE INCOME	Item	Percent	Big Picture %	KES	Adjusted
4	GROSS		100	100	100,000.00
5		God	10	10	10,000.00
6		Government	25	25	25,094.40
7	NET		65	65	64,905.60
8		Investment	15	9.75	9,750.00
9		Savings	15	9.75	9,750.00
10		Expenses	70	45.5	45,500.00
11
12
13	EXPENSE ONLY	Item	Percent	Big Picture %	KES	Adjusted
14	Taxed Income		100	45.5	45,500.00
15		Base Expenses	60	27.3	27,300.00
16		Extras	25	11.375	11,375.00
17		Charity	15	6.825	6,825.00
18		Family	7	3.185	3,185.00
19		Friends	4	1.82	1,820.00
20		Other Charity	4	1.82	1,820.00
21
22	Enter your net income minus tithe in cell 'E3' to see new amounts to spend per item. Adjust percentages in column C to suite your situation.
23	NET INCOME AFTER TITHE	Item	Percent	Big Picture %	KES	Adjusted
24			100	100	50,000.00
25		Investment	15	15	7,500.00
26		Savings	15	15	7,500.00
27		Expenses	70	70	35,000.00
28
29
30	EXPENSE ONLY	Item	Percent	Big Picture %	KES	Adjusted
31	Income After Tax & Tithe		100	70	35,000.00
32		Base Expenses	60	42	21,000.00
33		Extras	25	17.5	8,750.00
34		Charity	15	10.5	5,250.00
35		Family	7	4.9	2,450.00
36		Friends	4	2.8	1,400.00
37		Other	4	2.8	1,400.00
38
39	Enter your tax-exempt income in cell 'E40' to see new amounts to spend per item. Adjust percentages in column C to suite your situation.
40	TAX-EXEMPT INCOME	Item	Percent	Big Picture %	KES	Adjusted
41			100	100	25,000.00
42		God	10	10	2,500.00
43		Investment	15	15	3,750.00
44		Savings	15	15	3,750.00
45		Expenses	60	60	15,000.00
46
47
48	EXPENSE ONLY	Item	Percent	Big Picture %	KES	Adjusted
49	Tax-exempt Income		100	60	15,000.00
50		Base Expenses	60	36	9,000.00
51		Extras	25	15	3,750.00
52		Charity	15	9	2,250.00
53		Family	7	4.2	1,050.00
54		Friends	4	2.4	600.00
55		Other	4	2.4	600.00
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