ABDEFGHIJKLMNOPQRSTUVWXYZ
1
DeKalb Brilliance Academy
2
Multi-year Projection
3
As of May FY2025
4
5
Year 1Year 2Year 3Year 4Year 5Year 6Assumptions
6
2024-252025-262026-272027-282028-292029-30
9
10
SUMMARY
11
Revenue
12
Local Revenues 949,400 507,702 296,052 335,252 374,508 375,173
13
State Revenues 5,172,202 7,485,837 8,297,935 9,217,206 10,214,723 10,448,003
14
Federal Revenues 803,779 1,096,480 1,283,166 2,223,113 1,664,425 1,670,412
15
Other Revenue - - - - - -
16
Total Revenue 6,925,381 9,090,019 9,877,153 11,775,572 12,253,656 12,493,588
17
18
Expenses
19
Personnel 2,864,150 3,696,820 4,098,917 4,502,249 4,956,955 5,054,294
20
Benefits & Insurances 965,549 1,291,686 1,417,000 1,573,729 1,755,132 1,808,016
21
Purchased Professional & Technical Services 698,550 934,209 1,041,610 1,148,770 1,233,897 1,261,852
22
Purchased Property Services 378,164 356,628 343,260 350,126 357,128 364,271
23
Other Purchased Services 506,566 775,958 881,471 1,005,620 1,136,735 1,159,463
24
Supplies 484,549 661,528 590,813 1,109,002 680,267 693,572
25
Property 11,150 581,746 579,289 571,234 571,234 571,234
26
Other Expenses 608,212 1,087,750 1,088,024 1,278,757 1,058,529 521,374
27
Total Expenses 6,516,889 9,386,325 10,040,383 11,539,486 11,749,877 11,434,077
28
29
Net Income
408,492 (296,306) (163,230) 236,086 503,779 1,059,512
31
32
Fund Balance
33
Beginning Balance (Unaudited) 925,137 1,333,629 1,037,323 874,092 1,110,178 1,613,957
34
Audit Adjustment
35
Beginning Balance (Audited) 925,137 1,333,629 1,037,323 874,092 1,110,178 1,613,957
36
Net Income 408,492 (296,306) (163,230) 236,086 503,779 1,059,512
37
38
Ending Fund Balance
1,333,629 1,037,323 874,092 1,110,178 1,613,957 2,673,469
39
40
Total Revenue Per Student
21,244 18,036 16,798 17,523 16,209 16,526
41
Total Expenses Per Student
19,990 18,624 17,075 17,172 15,542 15,124
42
Net Income Per Student
1,253 (588) (278) 351 666 1,401
43
Fund Balance as a % of Expenses
20%11%9%10%14%23%
44
Debt Service Coverage Ratio
1.73 1.26 1.38 1.54 1.72 3.30
46
47
Key Assumptions
48
50
K 78 84 84 84 84 84
51
1 76 84 84 84 84 84
52
2 79 84 84 84 84 84
53
3 48 84 84 84 84 84
54
4 45 84 84 84 84 84
55
5 - 84 84 84 84 84
56
6 - - 84 84 84 84
57
7 - - - 84 84 84
58
8 - - - - 84 84
63
Enrollment Summary
64
K-3 281 336 336 336 336 336
65
4-6 45 168 252 252 252 252
66
7-8 - - - 84 168 168
68
Total Enrolled 326 504 588 672 756 756
98
REVENUE
99
100
Local Revenues
106
1220Donations 20,000 20,000 20,000 20,000 20,000 20,000 Our fundraising goal for donations is $20,000 annually, which includes contributions from the governing board.
112
1500Investment Income 80,000 5,000 5,500 6,050 6,655 7,321
125
1920.3Contributions - Foundation 699,400 250,800 - - - -
132
1995School Fees 150,000 231,902 270,552 309,202 347,853 347,853
135
SUBTOTAL - Local Revenues 949,400 507,702 296,052 335,252 374,508 375,173
136
137
State Revenues
140
3120Total QBE Formula Earnings (State And Local Funds 5,495,729 8,252,206 9,272,251 10,330,710 11,467,415 11,700,695
144
3140Qbe Contra Account (Debit (400,578) (835,128) (974,316) (1,113,504) (1,252,692) (1,252,692)
150
3800Other Grants From Georgia Department Of Education 77,051 68,759 - - - -
157
SUBTOTAL - State Revenues 5,172,202 7,485,837 8,297,935 9,217,206 10,214,723 10,448,003
158
159
Federal Revenues
163
4300.1Title I 358,242 554,135 646,714 739,293 831,873 831,873
168
4300.6IDEA 134,682 155,274 180,194 207,032 233,869 233,869
169
4510NSLP - Lunch 156,480 244,466 288,162 332,708 378,116 381,897
170
4511NSLP - Breakfast 91,280 142,605 168,095 194,080 220,568 222,773
173
4520Other Federal Grants Through Georgia Department Of Education 44,029 - - - - -
174
4520.1Charter School Program - - - 750,000 - -
187
4999PY Unaccrued Federal Revenues 19,066 - - - - -
189
SUBTOTAL - Federal Revenues 803,779 1,096,480 1,283,166 2,223,113 1,664,425 1,670,412
190
191
Other Revenue
202
SUBTOTAL - Other Revenue - - - - - -
203
204
TOTAL REVENUE
6,925,381 9,090,019 9,877,153 11,775,572 12,253,656 12,493,588
205
206
EXPENSES
207
208
Personnel
211
110Teachers 910,886 1,895,930 2,140,549 2,394,194 2,657,130 2,710,273 SPED & Gen Ed Teachers combined with specified program coding
218
116Teacher Leader Stipends 12,000 12,000 12,000 12,000 34,120 34,802 See payroll tab for salary assumptions
219
118Enrichment Teachers 212,315 296,113 302,035 308,076 384,496 392,186 See payroll tab for salary assumptions
222
130Principal 120,213 133,705 136,379 139,107 141,889 144,727 See payroll tab for salary assumptions
223
131AP of Instruction 260,389 295,823 301,739 406,774 414,910 423,208 See payroll tab for salary assumptions
224
140Assistant Teachers 174,485 247,502 252,452 257,501 309,651 315,844 SPED & Gen Ed Paras combined with specified program coding
225
140.1Reading Teacher 157,728 - - - - -
226
140.2Special Education Personnel 452,072 - - - - -
227
140.3Aftercare Personnel 4,509 71,885 73,322 74,789 76,285 77,810 See payroll tab for salary assumptions