ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Quarterly Dashboard example
3
4
Target and CriteriaRedYellowGreenNotes (examples)
5
6
Standard Metrics: to use at every Finance Committee meeting
7
*CASH132 Days+ Dec 31 cash balance was $5.0M (103 days of current expenses)
+ Forecasted 6/30 cash of $5.2M is 103 days of FYYY expenses.
+ Higher cash inflow are expected April-June with reimburseable grants being funded, and philanthropy grant X being funded.
+ See tab in workbook for monthly cash detail.
8
Target criteria:
Maintain cash to cover monthly operating expenses		< 45 days45 days - 90 days>= 90 days
9
10
*ENROLLMENT95%See following tab for year over year enrollment details and performance compared to budget.
11
Target:
Reach enrollment as % of budget targets		90% - 95%95% - 97%>= 98%
12
13
*NET ASSETSNet Assets forecasted to be 30% of Budget+- Net Income budget target for the year is $900K, and forecasted net income estimated to have a favorable variance of approximately $100K
+ Increased liabilities are forecasted for end of year borrowing will lower net assets
14
Target criteria:
Grow Net Assets to $X.XM
(~35% of expenses)		<35%25% - 35%Net Assets >35% of expenses
15
16
FUNDRAISING 35% of annual target through December+ First 6 months of collections are $1.7M, >50% of $2.9M target;
+ $2.3M is committed for the entire year
+ The annual fundraising target was $2.2M without facility
+ “Phase I” (FY20-FY25) goal of $8.3M is 75% complete with $6.2M of collections and commitments FY20 - FY25
17
Target: Meet annual fundraising target of [$X.XM]< 40% through mid-year
<100% through end of year		> 40% through mid-year
>100% through end of year		> 50% through mid-year
>100% through end of year
18
19
BUDGETExpenses tracking to
98% of budget		+ Through the first 6 months of the year, consolidated expenses are tracking to 98% of pro-rated full year budget.
+ On a school level basis, school 2 is 105% and school 3 is 96% of pro-rated full-year budget.
+ Lower expenses are expected in the second half of year.
20
Target: keep expenses within sustainbaility, and sufficient to invest in missionForecast more than +/- 5%
of annual budget		Forecast within +/- 2% to 5%
of annual budget		Forecast within +/- 2%
of annual budget
21
22
RISK MANAGEMENTAuthorizer has asked for increased reporting+ Authorizer charter renewal process for School 2 will be conducted in March.
+ Business insurance will be renewed in April: new umbrella policy and new D&O coverage to be underwritten.
+ Report card submitted on time 8 of last 10 months.
23
Target: Monitor existential issues; Special Ed; Insurance; FacilitiesImmediate issuesConcerns to be addressedNo outstanding issues
24
25
26
Customized dashboard metrics for relevant situations
27
Target and CriteriaRedYellowGreenNotes (example)
28
29
COVENANTS1.45xDefinition from Lender:
Money available for debt service (net operating income)
÷
Debt service ($X.X annually)
30
Target: Debt Service Coverage Ratio< 1.1x days1.1 x - 1.3x>1.3x
31
32
GRANT FUNDING YTD55% fundedTotal ESSER funding expected this year: $X.XM
Previous year's process led to 40% funded by April.

Total CSP funding expected this year: $X.XM
Previous year's process led to 55% funded by April.
33
Target: 80% of all ESSER and CSP grants will be funded by April 30<60% funded by April60% - 80% funded by April>80% funded by April
34
35
FACILITY GREENLIGHTING3 metrics met as of DecemberExamples:
+ Enrollment is >90% of capacity for existing schools
+ Attendance is greater than 95% for all schools
+ NWEA Growth scores met benchmarks in X schools
+ ELL growth in grade levels X - Y is above district average

36
Target criteria:
5 academic & operational performance metrics		< 3 metrics met3-4 metrics met5 metrics met
37
38
* = standard metrcs to always elevate; additional metrics to chose from are on a separate sheet in this workbook.
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
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