case study

profilerayatita007
Senior_Finance_Associate_-_Business_Case.xlsx

1. Cash Flow Forecast

Category 2019-01 2019-02 2019-03 2019-04 2019-05 2019-06 2019-07 2019-08 2019-09 2019-10 2019-11 2019-12 January February March April May June Actual YTD Budget YTD Diff Forecast FY Budget FY Diff
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Colour code
LOCAL CURRENCY Forecast
INCOME - - - - - - - - - - - - ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! - - - - - - - Actual
School fees ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! - - Budget
Registration fees ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! -
Other income ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! - - Month
EXPENSES - - - - - - - - - - - - - - - - - - - - - - - - - 1
Other income related expenses ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! - -
Salaries - Teaching staff forecasted forecasted forecasted forecasted forecasted forecasted - -
Salaries - Admin staff forecasted forecasted forecasted forecasted forecasted forecasted - -
Travel costs forecasted forecasted forecasted forecasted forecasted forecasted - -
Quality / accreditation forecasted forecasted forecasted forecasted forecasted forecasted - -
Academics forecasted forecasted forecasted forecasted forecasted forecasted - -
Scholarships forecasted forecasted forecasted forecasted forecasted forecasted - -
Marketing and student recruitment forecasted forecasted forecasted forecasted forecasted forecasted - -
Communication and IT/IS costs forecasted forecasted forecasted forecasted forecasted forecasted - -
Office costs forecasted forecasted forecasted forecasted forecasted forecasted - -
Property expenses forecasted forecasted forecasted forecasted forecasted forecasted - -
Depreciation forecasted forecasted forecasted forecasted forecasted forecasted - -
Professional costs forecasted forecasted forecasted forecasted forecasted forecasted - -
Bad debt forecasted forecasted forecasted forecasted forecasted forecasted - -
Platform Costs forecasted forecasted forecasted forecasted forecasted forecasted - -
Interests on loans forecasted forecasted forecasted forecasted forecasted forecasted - -
Tax forecasted forecasted forecasted forecasted forecasted forecasted - -
INVESTMENTS - - - - - - - - - - - - - - - - - -
Building and structures - -
Equipment - -
Vehicle - -
General installations - -
IT - Laptop - -
INTERBANK TRANSFERS - - - - - - - - - - - - - - - - - -
Loan -
Withdrawal of Petty Cash -
Deposit from Petty Cash -
Transfer from bank account -
TOTAL - - - - - - - - - - - - - - - - - -
Opening Balance 200,000
Closing balance

Please complete this table using inputs from the following tabs. Additional comments: - Please implement formula checks to ensure completeness of the information inputted. - Implement automated color coded cells for column W and AA, depending if YTD Actuals and FY Forecast are over/under budget

2. Forecast 2019

2019-01 2019-02 2019-03 2019-04 2019-05 2019-06 2019-07 2019-08 2019-09 2019-10 2019-11 2019-12
1 2 3 4 5 6 7 8 9 10 11 12 TOTAL
Income - 0 897,473 90,525 303,900 90,525 90,525 90,525 90,525 303,900 90,525 - 0 - 0 2,048,425
400000 School fees - 0 897,473 90,525 303,900 90,525 90,525 90,525 90,525 303,900 90,525 - 0 - 0 2,048,425
400020 Foundation Course 1 806,948 - 0 806,948
400030 Foundation Course 2 - 0 - 0
400040 Cambridge Secondary 1 - 0 - 0
400050 Cambridge Secondary 2 11,130 11,130 11,130 11,130 11,130 11,130 11,130 11,130 11,130 - 0 100,170
400060 AS level 69,199 69,199 264,574 69,199 69,199 69,199 69,199 264,574 69,199 - 0 1,013,538
400070 A level 10,197 10,197 28,197 10,197 10,197 10,197 10,197 28,197 10,197 - 0 127,770
400200 Registration fees - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
400210 Registration fees - 0
Other income - 0 213,417 140,000 140,000 80,000 80,000 110,000 50,000 287,500 50,000 - 0 - 0 1,150,917
700000 Other income - 0 213,417 140,000 140,000 80,000 80,000 110,000 50,000 287,500 50,000 - 0 - 0 1,150,917
700010 Books - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
700020 Calculators - - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
700030 Canteen - - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
700040 Examination fee 133,417 - 0 - 0 - 0 - 0 237,500 - 0 - 0 - 0 370,917
700050 Study tour - - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
700060 Uniforms - - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
700070 Transport - - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
700080 Other extra-curriculum activities - - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
700090 Homestay 80,000 80,000 80,000 80,000 80,000 50,000 50,000 50,000 50,000 - 0 - 0 600,000
700100 Other 60,000 60,000 - 0 60,000 - 0 - 0 - 0 - 0 180,000
Expenses - 0 - 832,945 - 612,986 - 495,735 - 495,735 - 528,086 - 464,058 - 464,058 - 533,090 - 457,808 - 411,308 - 191,026 - 5,486,836
600000 Other income related expenses - 0 - 96,545 - 177,518 - 74,400 - 74,400 - 74,400 - 46,500 - 46,500 - 155,821 - 46,500 - 0 - 0 - 792,584
600010 Books - - 22,145 - 31,640 - 53,785
600020 Calculators - - 0 - 0 - 0
600030 Canteen - 0 - 0 - 0
600040 Examination fee - - 0 - 71,478 - 109,321 - 180,799
600050 Study tour - - 0 - 0 - 0
600060 Uniforms - 0 - 0 - 0
600070 Homestay - 74,400 - 74,400 - 74,400 - 74,400 - 74,400 - 46,500 - 46,500 - 46,500 - 46,500 - 558,000
600080 Other extra-curriculum activities - - 0 - 0 - 0
600100 Salaries - Teaching staff - 0 - 440,564 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 0 - 2,423,102
600110 Basic salaries - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 220,282 - 2,202,820
600120 Staff salary - foreign component - 220,282 - 0 - 220,282
600130 Other employee costs - 0
600140 Transport allowance - 0
600150 PAYE - 0
600180 UIF - 0
600190 SDL - 0
600200 Salaries - Admin staff - 0 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 0 - 66,167 - 66,167 - 66,167 - 661,670
600210 Basic Salaries - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 66,167 - 727,837
600220 Staff salary - foreign component - 0 - 0 - 0
600230 Employee benefits(rent,medical aid, flight) - 0
600240 Transport allowance - 0
600250 PAYE - 0
600260 SDL - 0
600270 UIF - 0
600280 Bonuses - 0
600290 Other employee costs - 0
600300 Travel costs - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
600310 Accommodation - 0 - 0 - 0 - 0 - 0 - 0 - 0
600320 Car hire / rental expenses - 0 - 0 - 0 - 0 - 0 - 0 - 0
600330 Flights - 0 - 0 - 0 - 0 - 0 - 0 - 0
600340 Vehicle expenses - 0 - 0 - 0 - 0 - 0 - 0 - 0
600350 Visa costs - 0 - 0 - 0
600400 Quality / accreditation - 0 - 22,000 - 15,000 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 37,000
600410 Accreditation costs - 10,000 - 15,000 - 0 - 0 - 0 - 0 - 0 - 0 - 25,000
600420 Quality costs / training - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
600430 Seminar, Conference and Workshop Costs - 12,000 - 0 - 0 - 0 - 0 - 0 - 0 - 12,000
600500 Academics - 0 - 14,250 - 7,250 - 7,250 - 7,250 - 7,250 - 7,250 - 7,250 - 1,000 - 1,000 - 1,000 - 1,000 - 61,750
600510 Art and Music - 0 - 0 - 0 - 0 - 0 - 0 - 0
600520 Laboratory - 6,250 - 6,250 - 6,250 - 6,250 - 6,250 - 6,250 - 6,250 - 43,750
600530 Library - 7,000 - 0 - 0 - 0 - 0 - 0 - 0 - 7,000
600540 Physical and Health Education - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 11,000
600550 Other educational costs - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
600600 Scholarships - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
600610 Cost of Scholarship Students - 0 - 0 - 0 - 0 - 0 - 0 - 0
600620 Cost of Scholarship Students Recruitment - 0 - 0 - 0 - 0 - 0 - 0 - 0
600700 Marketing and student recruitment - 0 - 15,000 - 11,500 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 116,500
600710 Advertising - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 10,000 - 110,000
600720 Events - 0
600730 Online Marketing - 0 - 0 - 0
600740 Marketing material - 0
600750 Open days - 0
600760 Partnerships - 0
600770 Other marketing costs - 5,000 - 1,500 - 6,500
600800 Communication and IT/IS costs - 0 - 18,067 - 10,266 - 12,633 - 12,633 - 17,856 - 7,856 - 7,856 - 7,856 - 7,856 - 7,856 - 7,856 - 118,591
600810 Internet - 2,981 - 2,981 - 2,981 - 2,981 - 2,981 - 2,981 - 2,981 - 2,981 - 2,981 - 26,829
600820 Landline - 4,555 - 1,754 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 33,309
600830 Licences - - 4,777 - 4,777 - 4,777 - 4,777 - 10,000 - 29,108
600840 Mobile communications - 2,735 - 2,735 - 875 - 875 - 875 - 875 - 875 - 875 - 875 - 875 - 875 - 13,345
600850 Non Capital IT Equipment - 5,000 - 5,000
600860 IT Repairs and Maintenance - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 11,000
600900 Office costs - 0 - 24,677 - 10,777 - 10,777 - 10,777 - 37,905 - 11,777 - 11,777 - 43,905 - 11,777 - 11,777 - 11,777 - 197,703
600910 Bank charges - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 22,000
600920 Courier and postage - 900 - 26,128 - 26,128 - 53,156
600930 Entertainment - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 8,000
600940 Health and Safety - 12,000 - 6,000 - 18,000
600950 Insurance - 1,277 - 1,277 - 1,277 - 1,277 - 1,277 - 1,277 - 1,277 - 1,277 - 1,277 - 1,277 - 1,277 - 14,047
600960 Printing and stationery - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 55,000
600970 Other office costs - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 16,500
600980 Vehicle and fuel - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 11,000
601000 Property expenses - 0 - 114,826 - 93,726 - 93,726 - 93,726 - 93,726 - 93,726 - 93,726 - 93,726 - 93,726 - 93,726 - 93,726 - 1,052,087
601010 Cleaning 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 22,000
601020 Property repairs / maintenance / improvements - 21,100 - 21,100
601030 Rent - 72,726 - 72,726 - 72,726 - 72,726 - 72,726 - 72,726 - 72,726 - 72,726 - 72,726 - 72,726 - 72,726 - 799,987
601040 Security - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 11,000
601050 Utilities - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 242,000
601100 Depreciation - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
601110 Depreciation of buildings and structures - 0 - 0 - 0 - 0 - 0 - 0 - 0
601120 Depreciation of equipment and furnishings - 0 - 0 - 0 - 0 - 0 - 0 - 0
601130 Depreciation of vehicles - 0 - 0 - 0 - 0 - 0 - 0 - 0
601200 Professional costs - 0 - 20,849 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 25,849
601210 Accounting fees - 0 - 0 - 0
601220 Audit fees - 20,349 - 0 - 20,349
601230 Consulting fees - 0
601240 Legal fees - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 5,500
601300 Bad debt - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
601310 Bad debt provisions - 0 - 0
601320 Write offs - 0 - 0 - 0
601400 Platform Costs - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
601410 Platform management fees - 0
601420 Licence fees - 0
601500 Interests on loans - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
601510 External loans - 0
601520 Intercompany loans - 0
601600 Tax - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
601610 Corporate tax - 0
601620 Tax risk provision - 0
601630 Withholding tax-local - 0
EBITDA - 0 277,945 - 382,461 - 51,835 - 325,210 - 357,561 - 263,533 - 323,533 58,310 - 317,283 - 411,308 - 191,026 - 2,287,494
INVESTMENTS - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Building and structures - 0
Equipment - 0
Vehicle - 0
General installations - 0
IT - Laptop - 0

SOURCE OF INFO FOR REFORECASTED NUMBERS - NO INPUT REQUIRED IN THIS TAB.

3. Budget 2019

Enko Sandton 2019-01 2019-02 2019-03 2019-04 2019-05 2019-06 2019-07 2019-08 2019-09 2019-10 2019-11 2019-12
1 2 3 4 5 6 7 8 9 10 11 12 TOTAL 2019 H1 2019
Assets - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
100000 Non currents assets - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
100010 Buildings and structures - 0 - 0
100030 Equipment and furnishings - 0 - 0
Income 852,050 89,550 89,550 259,550 89,550 89,550 89,550 89,550 259,550 89,550 - 0 - 0 1,998,000 1,469,800
400000 School fees 829,550 89,550 89,550 259,550 89,550 89,550 89,550 89,550 259,550 89,550 - 0 - 0 1,975,500 1,447,300
400020 Foundation Course 1 - 0 - 0 - 0 - 0
400030 Foundation Course 2 - 0 - 0 - 0 - 0
400040 Cambridge Secondary 1 529,550 29,550 29,550 199,550 29,550 29,550 29,550 29,550 199,550 29,550 - 0 - 0 1,135,500 847,300
400050 Cambridge Secondary 2 60,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 - 0 - 0 168,000 120,000
400060 AS level 60,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 - 0 - 0 168,000 120,000
400070 A level 180,000 36,000 36,000 36,000 36,000 36,000 36,000 36,000 36,000 36,000 - 0 - 0 504,000 360,000
400200 Registration fees 22,500 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 22,500 22,500
400210 Registration fees 22,500 22,500 22,500
Other income 60,000 20,000 385,000 20,000 20,000 20,000 20,000 20,000 270,000 20,000 - 0 - 0 855,000 525,000
- 0 - 0
700000 Other income 60,000 20,000 385,000 20,000 20,000 20,000 20,000 20,000 270,000 20,000 - 0 - 0 855,000 525,000
700010 Books 40,000 15,000 55,000 55,000
700020 Calculators - 0 - 0
700030 Canteen - 0 - 0 - 0 - 0 - 0
700040 Examination fee - 0 - 0 350,000 175,000 525,000 350,000
700050 Study tour - 0 - 0
700060 Uniforms - 0 - 0
700070 Transport - 0 - 0
700080 Other extra-curriculum activities - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
700090 Homestay 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 - 0 200,000 120,000
700100 Annual award cocktail - 0 - 0 - 0 - 0 - 0 75,000 75,000 - 0
Expenses - 696,757 - 478,357 - 429,257 - 433,657 - 439,257 - 433,257 - 427,257 - 427,257 - 792,657 - 482,257 - 344,376 - 527,176 - 5,911,522 - 2,910,542
- 0 - 0
600000 Other income related expenses - 168,000 - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 368,000 - 73,000 - 0 - 0 - 735,000 - 258,000
600010 Books - 50,000 - 50,000 - 50,000
600020 Calculators - 0 - 0
600030 Canteen - 0 - 0
600040 Examination fee - 100,000 - 350,000 - 450,000 - 100,000
600050 Study tour - 0 - 0 - 0
600060 Uniforms - 0 - 0
600070 Transport - 0 - 0
600080 Other extra-curriculum activities - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
600090 Homestay - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 18,000 - 0 - 0 - 180,000
xxxx Annual award cocktail - 55,000
600100 Salaries - Teaching Staff - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 0 - 0 - 540,000 - 324,000
600110 Basic salaries - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 54,000 - 540,000 - 324,000
600120 Staff salary - foreign component - 0 - 0
600130 Employee benefits (rent, medical aid, flight) - 0 - 0
600140 Transport allowance - 0 - 0
600150 PAYE - 0 - 0
600160 SDL - 0 - 0
600170 UIF - 0 - 0
600180 Bonuses - 0 - 0
600190 Other Employee costs - 0 - 0
600200 Salaries - Admin Staff - 192,150 - 192,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 1,845,800 - 968,900
600210 Basic salaries - 192,150 - 192,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 146,150 - 1,845,800 - 968,900
600220 Staff salary - foreign component - 0 - 0
600230 Employee benefits (rent, medical aid, flight) - 0 - 0
600240 Transport allowance - 0 - 0
600250 PAYE - 0 - 0
600260 SDL - 0 - 0
600270 UIF - 0 - 0
600280 Bonuses - 0 - 0
600290 Other Employee costs - 0 - 0
600300 Travel costs - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
600310 Accommodation - 0 - 0
600320 Car hire / rental expenses - 0 - 0
600330 Flights - 0 - 0
600340 Vehicle expenses - 0 - 0
600350 Visa costs - 0 - 0
600400 Quality / accreditation - 16,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 27,000 - 21,000
600410 Accreditation costs - 0 - 0
600420 Quality costs / training - 0 - 0
600430 Seminar, Conference and Workshop Costs - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 12,000 - 6,000
xxxx Memberships - 15,000 - 15,000 - 15,000
600500 Academics - 25,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 5,000 - 80,000 - 50,000
600510 Art and Music - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 12,000 - 6,000
600520 Laboratory - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 36,000 - 18,000
600530 Library - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 12,000 - 6,000
600540 Physical and Health Education - 0 - 0 - 0
600550 Other educational costs - 20,000 - 20,000 - 20,000
600600 Scholarships - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 0 - 0 - 250,900 - 150,540
600610 Cost of Scholarship Students - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 25,090 - 250,900 - 150,540
600620 Cost of Scholarship Students Recruitment - 0 - 0
600700 Marketing and student recruitment - 30,000 - 17,500 - 17,500 - 17,500 - 17,500 - 17,500 - 17,500 - 17,500 - 17,500 - 17,500 - 17,500 - 17,500 - 222,500 - 117,500
600710 Advertising - 25,000 - 12,500 - 16,000 - 16,000 - 16,000 - 16,000 - 16,000 - 16,000 - 16,000 - 16,000 - 16,000 - 16,000 - 197,500 - 101,500
600720 Events - 0 - 0
600730 Online Marketing - 0 - 0
600740 Printing - 0 - 0
600750 Telemarketers - 0 - 0
600760 Commissions - 0 - 0
600770 Other marketing costs - 5,000 - 5,000 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 25,000 - 16,000
600800 Communication and IT/IS costs - 15,635 - 15,635 - 15,635 - 15,635 - 12,635 - 12,635 - 12,635 - 12,635 - 12,635 - 12,635 - 12,635 - 12,635 - 163,620 - 87,810
600810 Internet - 1,900 - 1,900 - 1,900 - 1,900 - 1,900 - 1,900 - 1,900 - 1,900 - 1,900 - 1,900 - 1,900 - 1,900 - 22,800 - 11,400
600820 Landline - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 24,000 - 12,000
600830 Licences - 5,000 - 5,000 - 5,000 - 5,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 36,000 - 24,000
600840 Mobile communications - 2,735 - 2,735 - 2,735 - 2,735 - 2,735 - 2,735 - 2,735 - 2,735 - 2,735 - 2,735 - 2,735 - 2,735 - 32,820 - 16,410
600850 Non Capital IT Equipment - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 24,000 - 12,000
600860 IT Repairs and Maintenance - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 24,000 - 12,000
600900 Office costs - 22,200 - 16,100 - 13,000 - 14,000 - 26,000 - 20,000 - 14,000 - 14,000 - 26,000 - 14,000 - 30,000 - 13,000 - 222,300 - 111,300
600910 Bank charges - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 24,000 - 12,000
600920 Courier and postage - 0 - 900 - 1,000 - 13,000 - 7,000 - 1,000 - 1,000 - 13,000 - 1,000 - 17,000 - 0 - 54,900 - 21,900
600930 Entertainment - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 18,000 - 9,000
600940 Health and Safety - 9,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 31,000 - 19,000
600950 Insurance - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 24,000 - 12,000
600960 Printing and stationery - 5,200 - 5,200 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 40,400 - 22,400
600970 Other office costs - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 1,500 - 18,000 - 9,000
600980 Vehicle and fuel - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 12,000 - 6,000
601000 Property expenses - 95,091 - 95,091 - 95,091 - 95,091 - 95,091 - 95,091 - 95,091 - 95,091 - 95,091 - 95,091 - 95,091 - 95,091 - 1,141,092 - 570,546
601010 Cleaning - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 36,000 - 18,000
601020 Property repairs / maintenance / improvements - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 2,000 - 24,000 - 12,000
601030 Rent - 67,091 - 67,091 - 67,091 - 67,091 - 67,091 - 67,091 - 67,091 - 67,091 - 67,091 - 67,091 - 67,091 - 67,091 - 805,092 - 402,546
601040 Security - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 1,000 - 12,000 - 6,000
601050 Utilities - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 22,000 - 264,000 - 132,000
601100 Depreciation - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
601110 Depreciation of buildings and structures - 0 - 0
601120 Depreciation of equipment and furnishings - 0 - 0
601130 Depreciation of vehicles - 0 - 0
601200 Professional costs - 9,000 - 9,000 - 9,000 - 9,000 - 9,000 - 9,000 - 9,000 - 9,000 - 9,000 - 9,000 - 9,000 - 9,000 - 108,000 - 54,000
601210 Accounting fees - 0 - 0
601220 Audit fees - 6,000 - 6,000 - 6,000 - 6,000 - 6,000 - 6,000 - 6,000 - 6,000 - 6,000 - 6,000 - 6,000 - 6,000 - 72,000 - 36,000
601230 Consulting fees - 0 - 0
601240 Legal fees - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 3,000 - 36,000 - 18,000
601300 Bad debt - 16,591 - 1,791 - 1,791 - 5,191 - 1,791 - 1,791 - 1,791 - 1,791 - 5,191 - 1,791 - 0 - 0 - 39,510 - 28,946
601310 Bad debt provisions - 16,591 - 1,791 - 1,791 - 5,191 - 1,791 - 1,791 - 1,791 - 1,791 - 5,191 - 1,791 - 0 - 0 - 39,510 - 28,946
601320 Write offs - 0 - 0
601400 Platform Costs - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 227,800 - 535,800 - 168,000
601410 Platform management fees - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 28,000 - 336,000 - 168,000
601420 Licence fees - 199,800 - 199,800 - 0
601500 Interests on loans - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
601510 External loans - 0 - 0
601520 Intercompany loans - 0 - 0
601600 Tax - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
601610 Corporate tax - 0 - 0
601620 Tax risk provision - 0 - 0
EBITDA 215,293 - 368,807 45,293 - 154,107 - 329,707 - 323,707 - 317,707 - 317,707 - 263,107 - 372,707 - 344,376 - 527,176 - 3,058,522 - 915,742

SOURCE OF INFO FOR BUDGETED NUMBERS - NO INPUT REQUIRED IN THIS TAB.

4. Actual (Jan 19) - Bank

YYYY-MM Date Amount Balance Category Sub-category Account Description Hard data
2019-01 03 Jan 1500 237083.25 Income Registration fees Registration fees registration fees
2019-01 03 Jan -8576.59 228506.66 Expenses Property expenses Cleaning property cleaning
2019-01 03 Jan -1.1 228505.56 Expenses Office costs bank charges bank charges
2019-01 04 Jan -6800 221705.56 Expenses Marketing and student recruitment Other marketing costs Angels car rental
2019-01 04 Jan -534.65 221170.91 Expenses Office costs bank charges bank charges
2019-01 04 Jan -1.1 221169.81 Expenses Office costs bank charges bank charges
2019-01 05 Jan -993.37 220176.44 Expenses Office costs Other office costs decorative plant supplier
2019-01 07 Jan 740 220916.44 Income School fees School fees outstanding school fee balance 2018
2019-01 07 Jan 1960 222876.44 Income School fees School fees outstanding school fee balance 2018
2019-01 07 Jan -187.8 222688.64 Expenses Other income related expenses Canteen petty cash box and receipt book for tuckshop
2019-01 07 Jan -2359.6 220329.04 Expenses Communication and IT/IS costs Internet internet and telephone lines
2019-01 07 Jan -1089 219240.04 Expenses Communication and IT/IS costs Mobile communications purchase of airtime
2019-01 07 Jan -420.44 218819.6 Expenses Marketing and student recruitment Other marketing costs fuel
2019-01 07 Jan -6.2 218813.4 Expenses Office costs bank charges bank charges
2019-01 07 Jan -6.2 218807.2 Expenses Office costs bank charges bank charges
2019-01 07 Jan -6.2 218801 Expenses Office costs bank charges bank charges
2019-01 07 Jan -1.1 218799.9 Expenses Office costs bank charges bank charges
2019-01 08 Jan -671.42 218128.48 Expenses Marketing and student recruitment Other marketing costs fuel
2019-01 08 Jan -6.2 218122.28 Expenses Office costs bank charges bank charges
2019-01 09 Jan 500 218622.28 Expenses School fees School fees outstanding school fees-2016
2019-01 09 Jan -1576 217046.28 Expenses Property expenses Cleaning house cleaning items
2019-01 09 Jan -144 216902.28 Expenses Office costs Other office costs cabinet paper and sello tape
2019-01 09 Jan -4006 212896.28 Investments IT - Laptop IT - Laptop purchase of computer for Examinations officer
2019-01 09 Jan -6.2 212890.08 Expenses Office costs bank charges bank charges
2019-01 09 Jan -6.2 212883.88 Expenses Office costs bank charges bank charges
2019-01 09 Jan -6.2 212877.68 Expenses Office costs bank charges bank charges
2019-01 10 Jan 7428.98 220306.66 Income School fees School fees outstanding school fee balance 2018
2019-01 10 Jan 3500 223806.66 Other income Other income Other refund from car hire-Rent my ride
2019-01 10 Jan -354 223452.66 Expenses Property expenses Improvements purchase of locks
2019-01 10 Jan -1465.25 221987.41 Expenses Other income related expenses Canteen items purchased for tuckshop
2019-01 10 Jan -1499 220488.41 Expenses Academics Other educational costs platters for the orientation day
2019-01 10 Jan -6.2 220482.21 Expenses Office costs bank charges bank charges
2019-01 10 Jan -6.2 220476.01 Expenses Office costs bank charges bank charges
2019-01 10 Jan -6.2 220469.81 Expenses Office costs bank charges bank charges
2019-01 10 Jan -1277.3 219192.51 Expenses Property expenses Insurance property insurance
2019-01 11 Jan 1500 220692.51 Income Registration fees Registration fees Registration fees-2019
2019-01 11 Jan -205 220487.51 Expenses Property expenses Improvements purchase of locks
2019-01 11 Jan -26128.05 194359.46 Expenses Office costs Courier and postage examination papers to cambridge
2019-01 11 Jan -4545 189814.46 Expenses Academics Other educational costs student tour around johannesburg
2019-01 11 Jan -6.2 189808.26 Expenses Office costs bank charges bank charges
2019-01 12 Jan -112.51 189695.75 Expenses Office costs Other office costs juice for lunch-orientation week
2019-01 12 Jan -1220 188475.75 Expenses Academics Other educational costs parents day- refreshments served
2019-01 12 Jan -6.2 188469.55 Expenses Office costs bank charges bank charges
2019-01 12 Jan -6.2 188463.35 Expenses Office costs bank charges bank charges
2019-01 14 Jan 3383.04 191846.39 Income School fees School fees outstanding school fee balance 2018
2019-01 14 Jan 4260 196106.39 Income School fees School fees school fees-2019
2019-01 14 Jan 326.5 196432.89 Income School fees School fees outstanding school fee balance 2018
2019-01 14 Jan 18850 215282.89 Income School fees School fees outstanding school fee balance 2018
2019-01 14 Jan -341.65 214941.24 Expenses Office costs bank charges bank charges
2019-01 14 Jan -40.35 214900.89 Expenses Office costs bank charges bank charges
2019-01 15 Jan 4238.5 219139.39 Income School fees School fees outstanding school fee balance 2018
2019-01 15 Jan -510.1 218629.29 Expenses Marketing and student recruitment Other marketing costs fuel
2019-01 15 Jan -6.2 218623.09 Expenses Office costs bank charges bank charges
2019-01 43481 90000 308623.09 Income School fees School fees Registration fees-2019
2019-01 16 Jan 1500 310123.09 Income Registration fees Registration fees Registration fees-2019
2019-01 16 Jan 1500 311623.09 Income Registration fees Registration fees Registration fees-2019
2019-01 17 Jan 86300 397923.09 Income School fees School fees school fees-2019
2019-01 17 Jan -1499.44 396423.65 Expenses Property expenses Cleaning purchase to hoover
2019-01 17 Jan -2600 393823.65 Expenses Academics Other educational costs university consulting fee
2019-01 17 Jan -9605 384218.65 Expenses Other income related expenses uniforms uniform supplier
2019-01 17 Jan -6.2 384212.45 Expenses Office costs bank charges bank charges
2019-01 18 Jan 143925 528137.45 Other income Other income Other
2019-01 18 Jan -1218.99 526918.46 Expenses Academics Art and Music purchase of material for art
2019-01 18 Jan -554.82 526363.64 Expenses Office costs bank charges bank charges
2019-01 18 Jan -6.2 526357.44 Expenses Office costs bank charges bank charges
2019-01 19 Jan -1500 524857.44 Expenses Salaries - Admin staff Basic salaries salary advance-mazvita akintola
2019-01 21 Jan 17860 542717.44 Income School fees School fees outstanding school fee balance 2018
2019-01 21 Jan -545.7 542171.74 Expenses Marketing and student recruitment Other marketing costs fuel
2019-01 21 Jan -6.2 542165.54 Expenses Office costs bank charges bank charges
2019-01 22 Jan -604.9 541560.64 Expenses Marketing and student recruitment Marketing material printing of flyers
2019-01 22 Jan -164 541396.64 Expenses Property expenses Improvements new lock purchased for property
2019-01 22 Jan -6.2 541390.44 Expenses Office costs bank charges bank charges
2019-01 22 Jan -6.2 541384.24 Expenses Office costs bank charges bank charges
2019-01 22 Jan -120 541264.24 Expenses Office costs bank charges bank charges
2019-01 24 Jan -18609.2 522655.04 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 24 Jan -49 522606.04 Expenses Property expenses Cleaning dust masks
2019-01 24 Jan -1790.6 520815.44 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 24 Jan -2509.32 518306.12 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 24 Jan -14000 504306.12 Expenses Salaries - Admin staff Basic salaries Teachers salary
2019-01 24 Jan -22211.54 482094.58 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 24 Jan -21903.67 460190.91 Expenses Salaries - Admin staff Basic salaries Teachers salary
2019-01 24 Jan -24303.57 435887.34 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 24 Jan -900 434987.34 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 24 Jan -2025 432962.34 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 24 Jan -2850 430112.34 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 24 Jan -6.2 430106.14 Office costs Office costs bank charges bank charges
2019-01 24 Jan -1.1 430105.04 Expenses Office costs bank charges bank charges
2019-01 24 Jan -1.25 430103.79 Expenses Office costs bank charges bank charges
2019-01 24 Jan -1.1 430102.69 Expenses Office costs bank charges bank charges
2019-01 24 Jan -1.25 430101.44 Expenses Office costs bank charges bank charges
2019-01 24 Jan -1.25 430100.19 Expenses Office costs bank charges bank charges
2019-01 24 Jan -1.1 430099.09 Expenses Office costs bank charges bank charges
2019-01 24 Jan -1.1 430097.99 Expenses Office costs bank charges bank charges
2019-01 24 Jan -1.25 430096.74 Expenses Office costs bank charges bank charges
2019-01 24 Jan -1.25 430095.49 Expenses Office costs bank charges bank charges
2019-01 25 Jan 1500 431595.49 Income Registration fees Registration fees Registration fee-2019
2019-01 25 Jan 1500 433095.49 Income Registration fees Registration fees Registration fee-2019
2019-01 25 Jan -3000 430095.49 Expenses Salaries - Admin staff Basic salaries Irene part time staff
2019-01 25 Jan -1500 428595.49 Expenses Salaries - Admin staff Basic salaries Primrose staff
2019-01 25 Jan -2529.6 426065.89 Expenses Office costs entertainment staff lunch-mazvita marketing offices resignation
2019-01 25 Jan -6.2 426059.69 Expenses Office costs bank charges bank charges
2019-01 25 Jan -52.1 426007.59 Expenses Office costs bank charges bank charges
2019-01 25 Jan -1.25 426006.34 Expenses Office costs bank charges bank charges
2019-01 25 Jan -1.25 426005.09 Expenses Office costs bank charges bank charges
2019-01 26 Jan -4777.13 421227.96 Expenses Property expenses Cleaning cleaning of school toilet and suppliers of all toilet sanitation
2019-01 26 Jan -8500 412727.96 Expenses Salaries - Admin staff Basic salaries staff salary
2019-01 26 Jan -405.34 412322.62 Expenses Marketing and student recruitment Other marketing costs fuel
2019-01 26 Jan -6.2 412316.42 Expenses Office costs bank charges bank charges
2019-01 26 Jan -1.25 412315.17 Expenses Office costs bank charges bank charges
2019-01 28 Jan 27730 440045.17 Income School fees School fees school fees-2019
2019-01 28 Jan 4088.5 444133.67 Other income Other income Examination fee examination fee-2019
2019-01 28 Jan 8000 452133.67 Other income Other income Laboratory lab workshop sessions
2019-01 28 Jan 2000 454133.67 Other income Other income Examination fee examination fee-2019
2019-01 28 Jan 500 454633.67 Income School fees School fees outstanding school fee balance 2016
2019-01 28 Jan 92730 547363.67 Income School fees School fees school fees-2019
2019-01 29 Jan 2000 549363.67 Other income Other income Examination fee examination fee-2019
2019-01 29 Jan 517.9 549881.57 Income School fees School fees outstanding school fee balance 2016
2019-01 29 Jan 5873 555754.57 Other income Other income Examination fee examination fee-2019
2019-01 29 Jan 1500 557254.57 Income Registration fees Registration fees registration fees-2019
2019-01 29 Jan 8272.5 565527.07 Other income Other income Examination fee examination fee-2019
2019-01 29 Jan 2419.25 567946.32 Income School fees School fees school fees-2019
2019-01 29 Jan 4338.5 572284.82 Income School fees School fees school fees-2019
2019-01 29 Jan 4500 576784.82 Income School fees School fees school fees-2019
2019-01 29 Jan 6257.75 583042.57 Income School fees School fees school fees-2019
2019-01 29 Jan -570 582472.57 Expenses Professional costs Accounting fees SARS submission
2019-01 29 Jan -3519.96 578952.61 Expenses Office costs Printing and stationary printer rental with supplier
2019-01 29 Jan -10373 568579.61 Expenses Office costs Health and Safety service of fire extinguishers
2019-01 29 Jan -115 568464.61 Expenses Property expenses security call out fee for ADT
2019-01 29 Jan -1550.32 566914.29 Expenses Office costs Health and Safety service of fire extinguishers
2019-01 29 Jan -3230 563684.29 Expenses Marketing and student recruitment Other marketing costs canvas Printing
2019-01 29 Jan -1105 562579.29 Expenses Office costs Other office costs once of assistance of a general worker wage
2019-01 29 Jan -591.1 561988.19 Expenses Office costs Other office costs provider for the water dispensers
2019-01 29 Jan -2100 559888.19 Expenses Communication and IT/IS costs landline landline installation
2019-01 29 Jan -1070 558818.19 Expenses Communication and IT/IS costs Mobile communications airtime
2019-01 29 Jan -11822 546996.19 Expenses Marketing and student recruitment advertising Enko Sandton signage installed
2019-01 29 Jan -3641 543355.19 Expenses Communication and IT/IS costs landline purchase of corded phone x 4
2019-01 29 Jan -4971.21 538383.98 Expenses Office costs Printing and stationary groceries and stationery purchases
2019-01 29 Jan -287.5 538096.48 Expenses Professional costs Accounting fees monthly fee for SARS submission
2019-01 29 Jan -359.72 537736.76 Expenses Property expenses Improvements purchase of locks
2019-01 29 Jan -20349.01 517387.75 Expenses Professional costs audit fees auditors fees
2019-01 29 Jan -7071.25 510316.5 Expenses Academics Laboratory purchase of chemicals for the lab
2019-01 29 Jan -1586.74 508729.76 Expenses Salaries - Teaching Staff Basic salaries Teachers salary
2019-01 29 Jan -6.2 508723.56 Expenses Office costs bank charges bank charges
2019-01 29 Jan -6.2 508717.36 Expenses Office costs bank charges bank charges
2019-01 30 Jan -5015 503702.36 Expenses Academics Other educational costs tutor for chemistry
2019-01 30 Jan -1460.5 502241.86 Expenses Office costs Other office costs provider for the water dispensers
2019-01 31 Jan -996 501245.86 Expenses Property expenses Property repairs / maintenance / improvements
2019-01 31 Jan 72.13 501317.99 Other income Other income Other donation
2019-01 31 Jan 1499 502816.99 Other income Other income Other refund for hoover
xxx
??? previously bank charges
??? To check?
xxx Category to create: Expenses/Investment/Equipment
xxx Category to create: Expenses/Investment/General Installations
xxx Category to create: Expenses/Investment/General Installations
xxx
xxx

SOURCE OF INFO FOR JAN ACTUAL NUMBERS - NO INPUT REQUIRED IN THIS TAB.