Studio Budget.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Income	January	February	March	April	May	June	July	August	September	October	November	December
2	5 students at 129	645	645	645	645	645	258	258	645	645	645	645	645
3	12 students at 149	1788	1788	1788	1788	1788	894	894	1788	1788	1788	1788	1788
4	4 students at 119	476	476	476	476	476	238	238	476	476	476	476	476
5	1 student at 100	100	100	100	100	100	100	100	100	100	100	100	100	TOTAL INCOME
6		3009	3009	3009	3009	3009	1490	1490	3009	3009	3009	3009	3009	33070
7	Summer months=1/2 students
8
9
10	Expenses	January	February	March	April	May	June	July	August	September	October	November	December	Totals
11	Advertising	20	20	20	20	20	20	20	20	20	20	20	20	240
12	Equipment/Home Office	30	30	30	30	30	30	30	30	30	30	30	30	360
13	Books/Studio Licenses	50	50	50	50	50	50	50	50	50	50	50	50	600
14	Liability Insurance	15	15	15	15	15	15	15	15	15	15	15	15	180
15	Memberships and Dues	70	70	70	70	70	70	70	70	70	70	70	70	840
16	Office Supplies	35	35	35	35	35	35	35	35	35	35	35	35	420
17	Quarterly Taxes	900			900			900			900			3600
18	Repairs & Maintenance	125						125						250
19	Studio Mngmt Programs	75	75	75	75	75	75	75	75	75	75	75	75	900
20	Subscriptions	30.95	30.95	30.95	30.95	30.95	30.95	30.95	30.95	30.95	30.95	30.95	30.95	371.4
21	Training & Education	100	100	100	100	100	100	100	100	100	100	100	100	1200
22	Travel	85	85	85	85	85	85	85	85	85	85	85	85	1020
23	Retirement Investing	900	900	900	900	900	900	900	900	900	900	900	900	10800
24		2435.95	1410.95	1410.95	2310.95	1410.95	1410.95	2435.95	1410.95	1410.95	2310.95	1410.95	1410.95	20781.4
25
26													TOTAL INCOME:	12288.6
27	All amounts are from 2019's expenditures divided by 12
28	Quarterly taxes	estimated at 10% of income
29	Studio Mngmt Programs	Tonara, MMS, bank fees
30	Annual Memberships	MTNA, NFMC
31	Annual Subscriptions	VMT, SS, Piano Book Club
32
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