Spreadsheet: 1c7ece60-14ee-4d3e-b644-565a9baaa9d3
Sheet: Sheet1

Charter School Financing Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Below is an example of the information that needs to be collected to begin a financing discussion.
Should your charter organization have multiple campuses, please complete 1 worksheet per campus.
Please overwrite the cells with the information for your particular charter school.
Call Greg McKenna ([PHONE]) with any questions and when complete,  please email to [EMAIL]
 |  |  |  |  |  |  | 2010-12-10 00:00:00
QUESTIONS
1.  What is the Name of your School and your [NAME]? |  |  | School:                                      Renaissance CS |  |  | [NAME]: | Big City SD
2.  When was your original charter [NAME] and Renewed? |  |  | Received:                                2007 |  |  | Renewed: | 2012
3.  Does your charter school have a current waiting list for enrollment? |  |  |  | Yes - See detailed breakdown below
4.  What is the Address (including Street Address, City, State, [NAME]) of this School? |  |  |  | 123 Main Street, Anytown, USA
5.  What is the CURRENT & UPON COMPLETION sq. footage of this School? |  |  |  | Current:         24,000   sq. ft.                Upon Completion:      52,000 sq. ft
USE OF FUNDS TABLE |  |  |  | CURRENT SCHOOL STATISTICS
Acquisition |  | 1000000 | Student to Teacher [NAME]  _________________ |  |  | Free & Reduced Lunch %  ____________
[NAME] |  | 0 | Regular Education %  _____________________ |  |  | [NAME]. PPR $  ___________________
Renovations |  | 2000000 | Special Education %  _____________________ |  |  | Special Ed PPR $  ____________________
New Construction |  | 6000000 | Avg. Daily Attendance %:  _________________ |  |  | Proficiency in Math %  _______________
Soft Costs |  | 425000 | Student Retention Rate %:  _______________ |  |  | Proficiency in Reading %  ____________
TOTAL PROJECT COST |  | 9425000 | Teacher [NAME] % :  _______________ |  |  | Met AYP - Yes or No:  ________________
Briefly describe your financing needs and project below:
We are currently renting our 24,000 sq ft building and have the option to buy the building for $1.0 mm, but it will need $2.0 mm for renovations to the existing
building.  We would also like to put a 28,000 sq ft addition on the building to accommodate our future growth from current enrollment of 390 students up to
a full enrollment of 600 students.
ENROLLMENT TABLE
Actual and Future Enrollment by Academic Year
Grades Served | Actual Enrollment |  | Estimated Enrollment in September of the following academic years
 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | Waiting List
Kindergarten | 50 | 50 | 75 | 75 | 75 | 75 | 75
1st Grade | 50 | 50 | 75 | 75 | 75 | 75 | 60
2nd Grade | 50 | 50 | 75 | 75 | 75 | 75 | 50
3rd Grade | 50 | 50 | 50 | 75 | 75 | 75 | 40
4th Grade | 50 | 50 | 50 | 50 | 75 | 75 | 25
5th Grade | 45 | 50 | 50 | 50 | 50 | 75 | 15
6th Grade | 45 | 45 | 50 | 50 | 50 | 50 | 10
7th Grade | 0 | 45 | 45 | 45 | 50 | 50 | 0
8th Grade | 0 | 0 | 45 | 45 | 45 | 50 | 0
9th Grade | 0 | 0 | 0 | 0 | 0 | 0 | 0
10th Grade | 0 | 0 | 0 | 0 | 0 | 0 | 0
11th Grade | 0 | 0 | 0 | 0 | 0 | 0 | 0
12th Grade | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 340 | 390 | 515 | 540 | 570 | 600 | 275
 | Example of a School that opened as a K-4 and grew organically to a K-8 School with total enrollment of 600 students
Total Revenues | 2448000 | 2864160 | 3857803.2 | 4125976.704 | 4442301.584640001 | 4769629.069824001
Building Operating Expenses | -97920 | -114566.4 | -154312.128 | -165039.06816 | -177692.0633856 | -190785.16279296
Instructional Expenses | -1346400 | -1603929.6 | -2237525.856 | -2393066.48832 | -2576534.9190912 | -2766384.86049792
Administrative Expenses | -367200 | -429624 | -694404.576 | -742675.80672 | -799614.2852352002 | -858533.2325683201
Subtotal = | 636480 | 716040 | 771560.64 | 825195.3408000006 | 888460.3169280001 | 953925.8139648002
Annual Rent or Debt Pymt | -367200 | -429624 | -578670.48 | -618896.5056 | -666345.2376960001 | -715444.3604736001
Net Surplus / (Deficit) = | 269280 | 286416 | 192890.16 | 206298.8352000006 | 222115.0792319999 | 238481.4534912001
Ending Fund Balance = | 369280 | 655696 | 848586.16 | 1054884.995200001 | 1277000.074432001 | 1515481.527923201
Assumptions:
Average PPR | 7200 | 7344 | 7490.88 | 7640.6976 | 7793.511552000001 | 7949.381783040001
Instructional Expenses | 0.55 | 0.56 | 0.58 | 0.58 | 0.58 | 0.58
Administrative Costs | 0.15 | 0.15 | 0.18 | 0.18 | 0.18 | 0.18
Debt Service as % of Revenues | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
Building operating costs | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
Surplus | 0.11 | 0.11 | 0.05 | 0.05 | 0.05 | 0.05
Total | 1 | 1.01 | 1 | 1 | 1 | 1