ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
July 2023August 2023September 2023October 2023November 2023December 2023January 2024February 2024March 2024April 2024May 2024June 2024Year to DateBudgetActual/Budget
2
Revenues
3
Enrollment for PPR $ 1,355,370.00 $ 1,355,370.00 $ 1,355,370.00 $ 1,355,370.00 $ 1,355,370.00 $ 1,355,370.00 $ 1,525,208.00 $ 1,379,632.00 $ 1,379,632.00 $ 1,379,632.00 $ 1,379,632.00 $ 1,379,632.00 $ 16,555,588.00 $ 16,511,781.00 100.27%
4
Eagle's Landing Tuition $ 39,450.00 $ 29,375.00 $ 53,230.00 $ 35,546.00 $ 31,229.00 $ 41,685.00 $ 31,795.00 $ 30,020.00 $ 55,035.00 $ 23,577.00 $ 50,235.00 $ 54,815.00 $ 475,992.00 $ 500,000.00 95.20%
5
Federal Grant Revenue $ 160,031.00 $ 160,031.00 $ 178,180.00 89.81%
6
Lunch Revenue $ 34,329.00 $ 183,579.00 $ 81,399.00 $ 60,198.00 $ 359,505.00 $ 420,000.00 85.60%
7
Mill Levy Funding $ 206,362.00 $ 206,364.00 $ 206,363.00 $ 206,364.00 $ 206,364.00 $ 206,364.00 $ 208,634.00 $ 206,687.00 $ 206,687.00 $ 206,687.00 $ 206,687.00 $ 275,874.00 $ 2,549,437.00 $ 2,513,904.00 101.41%
8
Grant Funding $ 18,568.00 $ 261,947.00 $ 1,927.00 $ 282,442.00 $ 290,196.00 97.33%
9
Local Sources $ 4,795.00 $ 142,575.00 $ 129,461.00 $ 89,967.00 $ 31,889.00 $ 102,428.00 $ 16,110.00 $ 14,437.00 $ 33,987.00 $ 17,001.00 $ 17,021.00 $ 43,871.00 $ 643,542.00 $ 567,450.00 113.41%
10
Capital Construction Funding $ 103,547.00 $ 51,774.00 $ 51,774.00 $ 51,774.00 $ 51,774.00 $ 50,546.00 $ 50,546.00 $ 50,547.00 $ 50,546.00 $ 50,546.00 $ 50,546.00 $ 613,920.00 $ 621,287.00 98.81%
11
Interest/Investment Income $ 31,503.00 $ 30,969.00 $ 29,448.00 $ 37,290.00 $ 36,457.00 $ 37,887.00 $ 37,894.00 $ 38,975.00 $ 42,166.00 $ 40,812.00 $ 42,986.00 $ 38,651.00 $ 445,038.00 $ 415,000.00 107.24%
12
Zion's Interest $ 84,539.00 $ 65,070.00 $ 149,609.00 $ 150,000.00 99.74%
13
GT Funding $ 16,198.00 $ 16,198.00 $ 16,198.00 100.00%
14
Zion's Interest $ 42,545.00 $ 42,545.00 $ 500,000.00 8.51%
15
Fund Transfers (In) $ (40,000.00) $ (40,000.00) $ (12,000.00) $ (5,500.00) $ (97,500.00) $ 175,000.00
16
17
TOTAL REVENUES $ 1,637,480.00 $ 1,828,200.00 $ 1,825,646.00 $ 1,776,311.00 $ 1,747,849.00 $ 2,141,994.00 $ 1,904,516.00 $ 1,863,876.00 $ 1,768,054.00 $ 1,799,654.00 $ 1,735,107.00 $ 2,167,660.00 $ 22,196,347.00 $ 22,858,996.00 97.10%
18
 $ -
19
Expenses $ -
20
Salaries $ 167,826.00 $ 247,239.00 $ 843,397.00 $ 851,330.00 $ 943,058.00 $ 860,134.00 $ 785,767.00 $ 871,386.00 $ 832,917.00 $ 828,419.00 $ 1,806,242.00 $ 1,826,255.00 $ 10,862,500.00 $ 11,143,552.00 97.48%
21
Benefits $ 55,890.00 $ 77,110.00 $ 265,220.00 $ 270,488.00 $ 290,672.00 $ 269,734.00 $ 249,836.00 $ 273,528.00 $ 264,303.00 $ 260,094.00 $ 395,052.00 $ 527,200.00 $ 3,226,352.00 $ 4,104,526.00 78.60%
22
Purchased/Professional Services $ 92,564.00 $ 33,308.00 $ 42,698.00 $ 28,332.00 $ 22,766.00 $ 25,651.00 $ 27,090.00 $ 37,479.00 $ 28,062.00 $ 3,375.00 $ 28,791.00 $ 42,968.00 $ 373,434.00 #REF!#REF!
23
Purchased Property Services $ 95,365.00 $ 14,047.00 $ 29,208.00 $ 41,252.00 $ 34,863.00 $ 34,974.00 $ 38,431.00 $ 21,839.00 $ 20,065.00 $ 31,960.00 $ 22,023.00 $ 27,872.00 $ 408,111.00 $ 479,614.00 85.09%
24
Other Purchased Services $ 24,049.00 $ 7,729.00 $ 91,848.00 $ 40,863.00 $ 34,273.00 $ 16,520.00 $ 35,602.00 $ 309,873.00 $ 168,640.00 $ 69,415.00 $ 142,087.00 $ 29,806.00 $ 951,799.00 $ 952,488.00 99.93%
25
Centralized Administrative Services $ 41,638.00 $ 41,638.00 $ 41,638.00 $ 41,638.00 $ 26,452.00 $ 41,638.00 $ 42,170.00 $ 42,170.00 $ 42,170.00 $ 42,170.00 $ 42,170.00 $ (47,484.00) $ 398,008.00 $ 515,577.00 77.20%
26
Supplies $ 172,684.00 $ 112,290.00 $ 79,851.00 $ 41,852.00 $ 71,711.00 $ 45,562.00 $ 49,944.00 $ 47,171.00 $ 31,587.00 $ 56,561.00 $ 78,551.00 $ 56,691.00 $ 905,947.00 $ 1,009,383.00 89.75%
27
Dues and Fees $ 32,336.00 $ 150.00 $ 38,410.00 $ 70,396.00 $ 70,973.00 99.19%
28
Capital $ 3,394.00 $ 8,132.00 $ 7,239.00 $ 2,318.00 $ 4,336.00 $ 21,595.00 $ 1,201.00 $ 6,453.00 $ 301.00 $ 594,548.00 $ 649,517.00 $ 650,000.00 99.93%
29
Lease Principle $ 9,963.00 $ 5,019.00 $ 5,173.00 $ 10,582.00 $ 5,412.00 $ 5,494.00 $ 5,578.00 $ 5,663.00 $ 5,749.00 $ 5,836.00 $ 64,469.00 $ 78,200.00 82.44%
30
Other Expenses $ 12,398.00 $ 1,225.00 $ 1,361.00 $ 1,816.00 $ 4,537.00 $ 1,305.00 $ 230.00 $ 454.00 $ 23,326.00 $ 201,911.00 11.55%
31
Insurance $ 10,104.00 $ 34,660.00 $ 15,186.00 $ 19,824.00 $ 15,186.00 $ 44,399.00 $ 5,442.00 $ 5,442.00 $ 5,442.00 $ 155,685.00 $ 165,000.00 94.35%
32
Rent $ 208,568.00 $ 208,318.00 $ 208,318.00 $ 208,318.00 $ 208,318.00 $ 208,088.00 $ 208,088.00 $ 208,088.00 $ 208,088.00 $ 208,088.00 $ 208,088.00 $ 169,678.00 $ 2,460,046.00 $ 2,460,046.00 100.00%
33
Fund Transfers (Out)
34
 $ -
35
TOTAL EXPENSES $ 901,024.00 $ 802,094.00 $ 1,631,740.00 $ 1,551,136.00 $ 1,656,151.00 $ 1,563,434.00 $ 1,473,914.00 $ 1,824,976.00 $ 1,606,852.00 $ 1,512,428.00 $ 2,729,204.00 $ 3,272,234.00 $ 20,549,590.00 #REF!#REF!
36
37
38
NET PROFIT/(LOSS) $ 736,456.00 $ 1,026,106.00 $ 193,906.00 $ 225,175.00 $ 91,698.00 $ 578,560.00 $ 430,602.00 $ 38,900.00 $ 161,202.00 $ 287,226.00 $ (994,097.00) $ (1,104,574.00) $ 1,646,757.00 #REF!#REF!
39
40
 DSCR 1.67
41
 DCOH #REF!
42
 Rev Distribution
43
6/30/20236/30/2024 Salaries 48.72%
44
General Fund $ 7,967,510.00 $ 1,859,427.00 $ 9,826,937.00 Benefits 14.47%
45
SRF Fund Raising $ 420,989.00 $ (178,047.00) $ 242,942.00 Rent 11.08%
46
SRF Athletics $ 3,149.00 $ (2,755.00) $ 394.00 Parking Lot 0.00%
47
SRF Pupil $ 62,361.00 $ (4,790.00) $ 57,571.00 Other Expenses 14.59%
48
 $ - Surplus 11.13%
49
Escrow Account $ - 6/30/2024
50
 $ - $ 199,522.00
51
Restricted for Tabor $ 624,976.00 $ 624,976.00 $ 465,356.00
52
Stargate Foundation $ 3,115,281.00 $ 3,975.00 $ 3,119,256.00 $ 2,454,378.00
53
SPED Reserve Account (GF component) $ 200,029.00 $ 11,263.00 $ 211,292.00
54
Capital Projects Reserve $ 600,086.00 $ 334,678.00 $ 934,764.00 $ 3,119,256.00
55
 ColoTrust (GF component) $ 6,202,110.00 $ 1,426,987.00 $ 7,629,097.00
56
57
58
Reserve Calc
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