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
67
9-12 - - - - - -
68
Total Enrolled 326 504 588 672 756 756
69
70
ADM %
71
K-30.0%0.0%0.0%0.0%0.0%0.0%
72
4-60.0%0.0%0.0%0.0%0.0%0.0%
73
7-80.0%0.0%0.0%
74
9-12
75
Average ADM %0.0%0.0%0.0%0.0%0.0%0.0%
76
77
ADM
78
K-3 - - - - - -
79
4-6 - - - - - -
80
7-8 - - - - - -
81
9-12 - - - - - -
82
Total ADM - - - - - -
83
84
Demographic Information
85
# Free & Reduced Lunch 267 413 482 551 620 620
86
# ELL 7 10 12 13 15 15
87
# SpEd 52 81 94 108 122 122
88
# New Students 75 178 84 84 84 -
89
90
School Information
91
FTE's 40 49 52 56 61 61
92
Teachers 17 28 31 34 38 38
93
Annual Pay Increase % - Teacher8%2%2%2%2%
94
Annual Pay Increase % - Other2%8%2%2%2%2%
95
# of school days 180 180 180 180 180 180
96
Default Expense Inflation Rate2%2%2%2%2%
97
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)