ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
 The Lynch Foundation EEC Financial Tool 2.0
2
3
How does the model work?*Using the blue S1-S4 worksheets, this model looks at the current year's budget and assumptions you load to project financials
4
*Adds funding opportunities like C3 funding, vouchers and other grant opportunities to determine impact on bottom line
5
*Allows you to make different assumptions on enrollment growth and size to see impact of opening a classroom.
6
7
How can this model be useful?*Decision-making
8
*Helps you evaluate possibilities of accepting (more) vouchers, opening classrooms, or other changes to revenue/expenses
9
*Supports moving to strategic goals and creating 3 year budget
10
11
What information do I need to complete the model?*If you use Adaptive, export your annual budget from Adaptive into Excel to support with completing this tool
12
*If you use Intacct, export 3 year profit and loss for the most recent fiscal year
13
*Current Year Enrollment
14
*Tuition, voucher, financial aid, & grant information
15
*Total teacher, other staff and administrative salaries and benefits
16
*Fundraising data
17
*Facility and operations costs
18
*After school and summer programming costs and revenues
19
*Cafeteria costs and revenues
20
21
How do I complete this model?Complete the blue S1-S4 worksheets tab then review the results in either the green summary or detail models.
22
23
How does this model differ from the financials required in past years?This model helps create a 3 year strategic budget with ability to plan for enrollment changes or different revenue streams.
24
25
If I have questions or need help who can I contact?Reach out to Annie Smith at asmith@thelynchfoundation.com. We will be hosting webinars the week of October 14 and have in person session at November 5 Summit on the Tool.
26
27
28
29
30
31
32
33
34
35
36
37
38
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