ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Dashboard
2
Hogan Prep
3
July 2021 through May 2022
4
5
Key Performance Indicators
6
10
Days of CashGross Margin
11
(At Year End)Margin
12
22618%
13
Target > 45 days
Target > -5.0%
14
15
Cash Forecast
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Financial Snapshot
Year-To-Date Financials
Annual Forecast
36
ActualBudgetVarianceForecastBudgetVarianceRemaining
37
Revenue
38
Local Revenue
 1,247,825 1,150,323 97,502 1,440,298 1,264,091 176,207 192,473
39
State Revenue
 8,726,337 9,083,203 (356,865) 9,541,452 10,081,271 (539,818) 815,115
40
Federal Revenue
 2,582,556 3,569,878 (987,322) 5,299,991 4,025,639 1,274,352 2,717,434
41
Private Grants and Donations
 981,466 1,004,250 (22,784) 981,466 1,030,000 (48,534) -
42
Earned Fees
 689,182 - 689,182 1,130,819 - 1,130,819 441,637
43
Total Revenue
 14,227,367 14,807,654 (580,287) 18,394,027 16,401,001 1,993,026 4,166,659
44
45
Expenses
46
Salaries
 5,956,722 6,719,329 762,606 6,463,793 7,330,177 866,384 507,071
47
Benefits and Taxes
 1,618,901 1,902,321 283,419 1,764,640 2,075,259 310,619 145,738
48
Staff-Related Costs
 116,038 254,742 138,703 224,451 277,900 53,449 108,413
49
Rent 195,161 183,333 (11,828) 211,828 200,000 (11,828) 16,667
50
Occupancy Service
 969,709 964,276 (5,434) 1,100,139 1,051,937 (48,202) 130,430
51
Student Expense, Direct
 1,192,952 1,034,210 (158,743) 1,343,023 1,128,229 (214,794) 150,071
52
Student Expense, Food
 388,670 708,538 319,867 772,950 772,950 (0) 384,280
53
Office & Business Expense
 921,794 833,530 (88,264) 1,126,819 909,305 (217,515) 205,026
54
Transportation
 716,578 725,416 8,838 808,578 791,363 (17,216) 92,000
55
Total Ordinary Expenses
 12,076,527 13,325,693 1,249,165 13,816,221 14,537,119 720,898 1,739,694
56
Net Operating Income
 2,150,840 1,481,961 668,879 4,577,805 1,863,882 2,713,924 2,426,966
57
58
Extraordinary Expenses
59
Depreciation and Amortization
 - - - - - - -
60
Interest
 77,214 79,147 1,933 86,342 86,342 (0) 9,128
61
Facility Improvements
 1,125,000 - (1,125,000) 1,125,000 - (1,125,000) -
62
Total Extraordinary Expenses
 1,202,214 79,147 (1,123,067) 1,211,342 86,342 (1,125,000) 9,128
63
Total Expenses
 13,278,741 13,404,840 126,098 15,027,564 14,623,462 (404,102) 1,748,822
64
Net Income
 948,626 1,402,814 (454,188) 3,366,463 1,777,539 1,588,924 2,417,837
65
Cash Flow Adjustments
 9,233 - 9,233 0 - 0 (9,233)
66
Change in Cash
 957,859 1,402,814 (444,955) 3,366,463 1,777,539 1,588,924 2,408,604
67
68
69
70
Revenue Drivers
71
CurrentForecastBudgetedChangeGain/(Loss)
72
Total Enrollment
10301176-1460
73
Attrition
7.00%7.00%0.00%0
74
Attendance %
91.0%91.0%0.0%0
75
Pre-K ADA
 26.0 26.0 #DIV/0!
76
Regular Term ADA: K-5
 293.0
77
Regular Term ADA: 6-8
 170.0
78
Regular Term ADA: 9-12
 303.3
79
Regular Term ADA: K-12
 766.3 1,033.0 (266.7)0
80
Remedial ADA
 - #DIV/0!
81
Summer ADA
 20.6 21.2 (0.6)0
82
Total K-12 ADA
 - 786.9 1,054.2 (267.3)0
83
FRL: % of ADA
96.6%97.0%-0.4%0
84
FRL: Count
 740.40 979.95 (239.55)0
85
FRL: Weight
 - 128.7 168.9 (40.3)0
86
IEP: % of ADA
12.58%0.00%12.58%#DIV/0!
87
IEP: Count
99.000.0099.00#DIV/0!
88
IEP: Weight
 - - - - #DIV/0!
89
LEP: % of ADA
2%0%2%#DIV/0!
90
LEP: Count
17017#DIV/0!
91
LEP: Weight
 0.4 - 0.4 #DIV/0!
92
Total WADA
 - 1,185.8 1,223.1 (37.3)-3.05%
93
Per Wada Payment
 $ 8,111 $ 8,266 $ (155)-1.88%
94
State Aid Projection
 $ 9,473,281 $ 9,958,760 $ (485,479)-4.87%
95
Prior Year Adjustment
 $ - $ - $ - #DIV/0!
96
Net State Rev Projection
 $ 9,473,281 $ 9,958,760 $ (485,479)-4.87%
97
Classroom Trust Fund
 $ 451,770 $ 478,679 $ (26,909)-5.62%
98
Basic Formula
 $ 9,021,511 $ 9,480,081 $ (458,570)-4.84%
99
100
101
102
103