6-December (2).xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	X	Y	Z
1
2										Financial Summary
3										12/31/2022
4
5
6
7
8
9		50.0%	Through The Year		BUDGET REPORT						EXPENSES											RATIOS
10
11				Year-to Date	Approved	Forecast	% of
12				Actuals	Budget	Forecast	Forecast
13
14		Enrollment			83	65																	Forecast	Goal
15	Revenue
16		1000	Local	$ 9,309	$ 7,000	$ 17,801	52%													Operating Margin			14.5%	5.0%
17		3000	State	$ 478,338	$ 932,052	$ 880,785	54%
18		4000	Federal	$ 29,207	$ 778,762	$ 370,936	8%													Debt Service Coverage			5.99	1.10
19		Total Revenue		$ 516,854	$ 1,717,814	$ 1,269,522	41%
20																				Days Cash on Hand			217	90
21	Expenses
22		100	Salaries	$ 347,036	$ 932,863	$ 813,693	43%													Building Payment %			3.8%	< 20%
23		200	Benefits	$ (345,253)	$ 170,624	$ (240,584)	144%
24		300	Prof & Technical Services	$ 48,497	$ 103,799	$ 101,000	48%
25		400	Purchased Property Services	$ 22,528	$ 74,500	$ 46,000	49%
26		500	Other Purchase Services	$ 7,869	$ 18,500	$ 18,500	43%
27		600	Supplies and Materials	$ 110,768	$ 170,470	$ 217,304	51%
28		700	Property, Equipment	$ 25,389	$ -	$ 37,000	69%
29		800	Debt Service and Misc	$ 15,370	$ 41,888	$ 92,388	17%
30		Total Expenses		$ 232,204	$ 1,512,644	$ 1,085,301	21%
31
32	Net Income from Operations			$ 284,650	$ 205,170	$ 184,221
33
34		Operating Margin		55.1%	11.9%	14.5%
35
36
37	CASH					RESERVES						*ENROLLMENT
38
39	Month Ending Cash Balance			$ 643,806									S	O	N	D	J	F	M	A	M
40		Days Cash on Hand		217								K	13	13
41								Actual Ytd	Forecast			1	8	8
42						Last Year Reserve Balance		$ 216,219	$ 216,219			2	8	8
43												3	11	12
44						Reserves Added this Year		$ 284,650	$ 184,221			4	13	12
45												5	3	3
46												6	6	6
47												Total	62	62	0	0	0	0	0	0	0
48													* as of the end of the month
49						New Reserve Balance		$ 500,869	$ 400,440
50
51
52
53
54
55
56																							Created by Red Apple
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