Advanced Budget Tool.xlsx

	C	D	F	G	I	J	L	M
1
2
3
4	PERSONAL INCOME & BALANCE SHEET
5	(Enter Month Here)
6
7	INCOME STATEMENT		BALANCE SHEET		LIABILITY TABLE		INVESTMENT COLUMN
8	Monthly Income:	Amount	Liquid Assets (First of Month)	Market Value	Short-Term Liability (<30 Days)	Balance	Investment Assets	Est. Market Value
9	Income 1	$3,000.00	Checking Acct 1	$5,000.00	Credit Card 1	$300.00	Real Estate	$250,000.00
10	Income 2	$1,400.00	Savings Acct	$13,000.00	Credit Card 2	$60.00	Personal Collection	$20,000.00
11	Cash in Possession	$500.00	Investment Acct	$20,000.00	Credit Card 3	$40.00	Stocks	$20,000.00
12	Surplus from Previous Month	$300.00	Checking Acct 2	$500.00	OTHER	$0.00	Small Business	$55,000.00
13	Total	$5,200.00	Cash	$500.00	OTHER	$0.00	Bonds	$8,200.00
14			OTHER	$0.00	OTHER	$0.00	Gold/Silver	$3,900.00
15	Monthly Expenses:	Payment	Total	$39,000.00	OTHER	$0.00	OTHER	$0.00
16	Rent/Mortgage	$2,000.00			Total	$400.00	OTHER	$0.00
17	Investment Account	$500.00	Possessions:	<30 Day Sale Value			OTHER	$0.00
18	Groceries/Dining/Delivery	$400.00	Vehicle	$20,100.00	Long-Term Liability (>30 Days)	Balance	OTHER	$0.00
19	Vehicle Payment	$400.00	Tools	$6,000.00	Mortgage	$100,000.00	OTHER	$0.00
20	Credit Card Bills Total	$400.00	Household Goods	$1,500.00	Vehicle Payment	$400.00	OTHER	$0.00
21	Recreation/Hobbies/Tech	$300.00	Hobby Items	$1,200.00	JetSki Payment	$0.00	Total	$357,100.00
22	Fuel/Natural Gas/Propane	$250.00	Clothing	$1,200.00	Motorcycle Payment	$0.00	Total Assets	$430,200.00
23	Electric Bill	$250.00	Camera	$1,000.00	Rocketship Payment	$0.00
24	Car Insurance	$120.00	Kayak	$800.00	OTHER	$0.00	CRITICAL RATIO MONITOR
25	Clothing/Accessories	$120.00	Furniture	$700.00	Total	$100,400.00	Savings %	0.19%
26	Phone and Internet Bill	$105.00	Bicycle	$700.00	Total Liabilities	$105,990.00	I-E/I	Goal > 30%
27	Fees/Tolls/Registrations	$80.00	Gaming System	$500.00			Liquidity Ratio	7.51
28	Subscriptions/Dues	$100.00	Guitar	$200.00	Overspending Monitor (Goal <20%)		LA/E	Goal > 3
29	Health Insurance	$140.00	TV	$200.00	Groceries/Dining/Delivery	$400.00	Net Worth	$ 324,210.00
30	Water/Sewer	$25.00	OTHER	$0.00	Clothing/Accessories	$120.00	TA-TL	Goal > $3M
31	OTHER	$0.00	OTHER	$0.00	Recreation/Hobbies/Tech	$300.00	Debt to Equity Ratio	32.69%
32	OTHER	$0.00	OTHER	$0.00	Subscriptions/Dues	$100.00	TL/(TA-TL)	Goal < 50%
33	Monthly Expenses	$5,190.00	OTHER	$0.00	Monthly Total	$920.00	Debt to Asset Ratio	24.64%
34	Net Amount=	$10.00	Total	$34,100.00	% of Monthly Budget	18%	TL/TA	Goal < 25%
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