| | | | | | | | |
| Year | 1 | 2 | 3 | 4 | 5 | Budget Notes | |
| | | | | | | | |
| Education & Learning | | | | | | | |
| Project Facilitators (expatriates) | 4 | 6 | 8 | 9 | 9 | Summer Budget | |
| TA (local) | 4 | 6 | 8 | 9 | 9 | Summer Budget | |
| | | | | | | | |
| Total Educational Staff | 8 | 12 | 16 | 18 | 18 | | |
| Student Capacity | 66 | 99 | 124 | 142 | 142 | | |
| Student to Staff Ratio | 8.25 | 8.25 | 7.75 | 7.8 | 7.8 | | |
| | | | | | | | |
| Admin & Mangagement | | | | | | | |
| Summer Program Head | 1 | 1 | 1 | 1 | 1 | Summer Budget | |
| | | | | | | | |
| Support and Logistics | | | | | | | |
| Summer Program Secretary | 1 | 1 | 1 | 1 | 1 | Yearly School Budget | |
| Nurse | 1 | 1 | 1 | 1 | 1 | Summer Budget | |
| IT (tech support) | 1 | 1 | 1 | 1 | 1 | Yearly School Budget | |
| Facility Based Support Staff | 4 | 4 | 4 | 4 | 4 | Yearly School Budget | |
| (e.g. equestrian coach, lifeguard, etc.) | | | | | | | |
| | | | | | | | |
| Marketing & Enrollment | | | | | | | |
| Admin officer | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | Yearly School Budget | |
| Marketing officer | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | Yearly School Budget | |
|
| | | | | |
2.1 | | | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
HR Unit Costs | | | USD | | | | | |
Head of Summer Program | | | 8,000 | 8,160 | 8,323 | 8,490 | 8,660 | 2% inflation |
| | | | | | | | |
Project Facilitators | | | 19,200 | 29,376 | 39,951 | 45,828 | 46,745 | |
| salary/wk | | 1,200 | 1,224 | 1,248 | 1,273 | 1,298 | 2% inflation |
| | | | | | | | |
Teacher Assisstants | | | 9,600 | 14,688 | 19,968 | 22,932 | 23,390 | |
| salary/wk | | 600 | 612 | 624 | 637 | 650 | 2% inflation |
| | | | | | | | |
Nurse | | | 3,200 | 3,264 | 3,329 | 3,396 | 3,464 | 2% inflation |
| | | | | | | | |
Summer Program Secretary | | | 0 | 0 | 0 | 0 | 0 | Year round staff |
| | | | | | | | |
Facilities/Cleaning/Maintenance/Security | | | 0 | 0 | 0 | 0 | 0 | Year round staff |
| | | | | | | | |
Techer release time for planning | | | 800 | 1,200 | 1,600 | 1,800 | 1,800 | Floating staff |
Totals | | | 40,800 | 56,688 | 73,172 | 82,446 | 84,058 | |
| | | | | | | | |
| | | | | | | | |
2.2 | | | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
Materials Resources | | | USD | | | | | |
Oil, Gas, Water, Electricity | | | 5,000 | 6,000 | 7,000 | 8,000 | 8,000 | |
| | | | | | | | |
Maintenance | | | 0 | 0 | 0 | 0 | 0 | in School Budget |
Totals | | | 5,000 | 6,000 | 7,000 | 8,000 | 8,000 | |
| | | | | | | | |
| | | | | | | | |
2.3 | | | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
Management | | | USD | | | | | |
Office Costs | | | | | | | | |
| | | | | | | | |
Photo Copying | | | 700 | 1,000 | 1,300 | 1,600 | 1,600 | |
| | | | | | | | |
Other Office Costs | | | 300 | 450 | 600 | 750 | 750 | |
Totals | | | 1,000 | 1,450 | 1,900 | 2,350 | 2,350 | |
| | | | | | | | |
| | | | | | | | |
2.4 | | | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
Marketing & Student Recruitment | | | USD | | | | | |
| | | | | | | | |
Promotional Materials | | | | | | | | |
| | | | | | | | |
Magazine Ad | | | 9,600 | 9,600 | 10,600 | 10,600 | 10,600 | |
| | | | | | | | |
City banners | | | 200 | 200 | 800 | 800 | 800 | |
| | | | | | | | |
Flyer/Brochure | | | 100 | 200 | 600 | 600 | 600 | |
| | | | | | | | |
Promotional Video | | | | 5,000 | | | | |
Totals | | | 9,900 | 15,000 | 12,000 | 12,000 | 12,000 | |
| | | | | | | | |
| | | | | | | | |
2.5 | | | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
Education & Learning | | | USD | | | | | |
| | | | | | | | |
Student Books & Supplies | | | | | | | | |
| | | | | | | | |
Local Textbooks | | | 5,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 |
| | | | | | | | |
Imported Textbooks | | | 20,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 |
| | | | | | | | |
Academic Departments, Special Programs, IB | | | | | | | | |
| | | | | | | | |
N/A | | | 0 | 0 | 0 | 0 | 0 | |
| | | | | | | | |
Activities, Sports, Travel | | | | | | | | |
| | | | | | | | |
N/A | | | 0 | 0 | 0 | 0 | 0 | |
Totals | | | 0 | 0 | 0 | 0 | 0 | |
| | | | | | | | |
| | | | | | | | |
| | | | | | | | |
| | | | | | | | |
2.6 | | | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Notes |
Student Support & Logistics | | | USD | | | | | |
| | | | | | | | |
Learning Resource & Library | | | | | | | | |
| | | | | | | | |
Learning Resources | | | 3,200 | 4,800 | 6,400 | 7,200 | 7,200 | |
| | | | | | | | |
Library | | | 0 | 0 | 0 | 0 | 0 | in school budget |
| | | | | | | | |
Information Technology | | | | | | | | |
| | | | | | | | |
Hardware | | | 0 | 0 | 0 | 0 | 0 | in school budget |
| | | | | | | | |
Software | | | 0 | 0 | 0 | 0 | 0 | in school budget |
| | | | | | | | |
Network | | | 0 | 0 | 0 | 0 | 0 | in school budget |
| | | | | | | | |
Health Center | | | | | | | | |
| | | | | | | | |
Supplies | | | 0 | 0 | 0 | 0 | 0 | in school budget |
Totals | | | 3,200 | 4,800 | 6,400 | 7,200 | 7,200 | |
| | | | | | | | |
2.7 | | | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Notes |
Support Services | | | USD | | | | | |
| | | | | | | | |
Transportation | | | | | | | | |
| | | | | | | | |
Rental of Buses | | | 4,000 | 6,000 | 8,000 | 9,000 | 9,000 | |
| | | | | | | | |
Insurances | | | 0 | 0 | 0 | 0 | 0 | in school budget |
| | | | | | | | |
Insurances - Non Personal, Non-Student | | | | | | | | |
| | | | | | | | |
Building | | | 0 | 0 | 0 | 0 | 0 | in school budget |
| | | | | | | | |
Kitchen | | | | | | | | |
| | | | | | | | |
Contracted food service | | | 6,600 | 10,395 | 13,640 | 17,040 | 17,750 | |
Totals | | | 10,600 | 16,395 | 21,640 | 26,040 | 26,750 | |
| | | | | | | | |
Total Expenditures | | | 70,500 | 100,333 | 122,112 | 138,036 | 140,358 | |
| | | | | | | | |
| | | | | | | | |
| Initial Investment | | | | | | |
| Teacher release time for planning | | 800 | | | | | |
| Promotional Materials | | 9,900 | | | | | |
| Learning Resources | | 3,200 | | | | | |
| 1/2 Food Contract | | 3,300 | | | | | |
| | Total | 17,200 |
| | | | | | |
| | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| | USD | | | | |
Income Summary | | | | | |
Income from Tuition | | 158,400 | 237,600 | 297,600 | 340,800 | 340,800 |
| | | | | | |
Expenditure Summary | | | | | |
2.1 Human Resources | | 40,800 | 56,688 | 73,172 | 82,446 | 84,058 |
2.2 Material Resources | | 5,000 | 6,000 | 7,000 | 8,000 | 8,000 |
2.3 Management | | 1,000 | 1,450 | 1,900 | 2,350 | 2,350 |
2.4 Marketing & Recruitment | | 9,900 | 15,000 | 12,000 | 12,000 | 12,000 |
2.5 Education & Learning | | 0 | 0 | 0 | 0 | 0 |
2.6 Student Support & Logistics | | 3,200 | 4,800 | 6,400 | 7,200 | 7,200 |
2.7 Support Services | | 10,600 | 16,395 | 21,640 | 26,040 | 26,750 |
Total Expenditures | | 70,500 | 100,333 | 122,112 | 138,036 | 140,358 |
| | | | | | |
Net Income | 87,900 | 137,267 | 175,488 | 202,764 | 200,442 |
EBITDA | | 55% | 58% | 59% | 59% | 59% |
| | | | | | |
| | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| | USD | | | | |
Break Even | | | | | | |
Number of Students | | 30 | 42 | 51 | 58 | 59 |
Target Capacity | | 66 | 99 | 124 | 142 | 142 |
| | 45% | 42% | 41% | 41% | 42% |
| | | | | | |
Income | 72,000 | 100,800 | 122,400 | 139,200 | 141,600 |
Expenditures | 70,500 | 100,333 | 122,112 | 138,036 | 140,358 |
Net Income | | 1,500 | 467 | 288 | 1,164 | 1,242 |
| | | | | | |
| | | | | | |
| | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| | USD | | | | |
At 75% Capacity | | | | | | |
Number of Students | | 50 | 75 | 93 | 107 | 107 |
Target | | 66 | 99 | 124 | 142 | 142 |
| | | | | | |
Income | | 120,000 | 180,000 | 223,200 | 256,800 | 256,800 |
Expenditures | 70,500 | 100,333 | 122,112 | 138,036 | 140,358 |
Net Income | | 49,500 | 79,667 | 101,088 | 118,764 | 116,442 |
EBITDA | | 31% | 34% | 34% | 35% | 34% |
| | | | |
| | | | Discount Rate | | |
| | | | Bank Rate in Dubai | | 3% |
| | | | Risk | | 1% |
| | | | | Total Rate | 4% |
| | | | | | |
Year | 0 | 1 | 2 | 3 | 4 | 5 |
| I n t i a l I n v e s t m e n t | O v e r a g e | O v e r a g e | O v e r a g e | O v e r a g e | O v e r a g e |
Net Income | 8,000,000 | 87,900 | 137,267 | 175,488 | 202,764 | 200,442 |
Present Value | 8,000,000 | 81,268 | 126,911 | 156,008 | 173,324 | 164,748 |
| | | | | | |
| | Net Present Value (NPV)= | | | 685,059 |
|
| | | | | | | |
| | | | | | |
Comments
Post a Comment