KSPE Charter_BudgetTemplate_FY17.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Call for Quality Schools
3
Charter School Budget Template Instructions
4
5
The following budget template is intended for use by any charter school participating in the Call for Quality Schools process with Denver Public Schools.
6
The template has 14 tabs. Below is a description of the purpose of each tab:
7
·         Instructions
8
o   Provides information on how to complete the budget template in order to provide the necessary financial information for the district to thoroughly and effectively review the financial portion of your application.
9
·         DPS Forecast Information
10
o   Provides the current assumptions on revenue and expenses applicable to DPS charter schools. The information on this tab is referenced throughout the file to help you build an accurate budget. Do not change the information in this tab.
11
·         Step 1 Enrollment
12
o   Enter your enrollment assumptions by grade level and by year.
13
o   Enter your FRL and FL assumptions by year.
14
o   Enter your LEP, NEP, and FEP percentages assumptions by year.
15
o   Enter your facility assumptions.
16
§  District Facility: Enter an estimated annual rent amount the school expects to pay if not placed in a district facility, row 28.
17
§  Non-District Facility: Enter an estimated annual rent amount the school expects to pay, row 28 and select ‘No’ from the dropdown in row 27.
18
·         Step 2 Staff
19
o   This is where you will complete a staffing plan by position and by year.
20
o   Please complete this document from left to right:
21
§  Column A, enter the position title
22
·         Every position will be on its own row
23
§  Column B is a drop down menu to select the category of the position.
24
§  Column C is a drop down menu to select the year the position will begin.
25
§  ‘FTE’ is an open cell to select the FTE the position will fill. This allocation is usually between .5 and 1.0. There should not be an FTE greater than 1.0.
26
§  ‘FTE Eligible for Benefits’ column is an open cell to enter the amount of benefits the position is eligible for. This allocation is usually between .5 and 1.0. There should not be an FTE greater than 1.0.
27
§  ‘Annual Wage’ is an open cell to enter the amount the position is expected to be paid each year.
28
·         Please complete the information for each year the position is available and increase salary accordingly.
29
§  ‘Benefit Expenses’ is an open cell for the school to enter the amount they expect to pay in each benefit category per employee.
30
§  Charter schools have the option of purchasing PSN days from the district or hiring their own psychologist, social worker, or nurse (PSN) as a staff member of the school.
31
·         If you plan on purchasing days from the district enter the number of days in the ‘# of Days’ cell for each year. These must be in whole number increments (1, 2, 3, 4, or 5)
32
o   When purchasing “Days” from the district you are purchasing that individual to come 1-5 (depending on your election) days every week for the entire school year.
33
·         If you are hiring your own psychologist, social worker, or nurse you must enter the salary and position of this individual in the Admin Staff section on rows 31-45.
34
·         Step 3 Revenue
35
o   The Blue Rows have been automatically populated based off “Step 1 Enrollment” tab. Do not change any of the automatic calculations in the blue rows.
36
o   The Yellow row indicates you need to enter the per pupil amount you expect to charge for the before and after school care.
37
o   The Grey rows indicate a category where the school must fill in the total amount expected to be received in each school year. Please enter these amounts in categories applicable to your school.
38
·         Step 4 Expenses
39
o   The Blue Rows have been automatically populated based on the data in the enrollment and staffing tabs. Do not change any of the automatic calculations in the blue rows.
40
o   The Grey rows indicate a category where the school must fill in the total amount expected in expenses for each year. Please enter these amounts in categories applicable to your school.
41
·         Year 0 – Year 5 & Summary Tabs
42
o   These tabs provide the annual budget of the school.
43
o   Column D is auto populated from information and data entered in the prior 4 tabs. Do not change any of the automatic calculations in column D.
44
o   Column E is available for the school to enter revenue and expenses relevant to grant funding. Please update this for each year and category applicable.
45
§  Please note that all grant revenue and expenses must total zero in row 155.
46
§  If the school is expecting grant income, input is required in this column.
47
Please direct any questions to LeVar Cypress, LEVAR_CYPRESS@dpsk12.org.
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
Loading...
 
 
 
Instructions
DPS Forecast Information
Step 1. Enrollment
Step 2. Staff
List
Step 3. Revenue
Step 4. Expenses
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 0-5
Summary