Maple Bear Adam · Financial Year 2026
Revenue and expense lines above, monthly surplus or deficit below. The shaded band is the forecast; everything to its left is from your JOIIN reports.
Revenue is driven by headcount × average net fee. July–December is pre-filled with your own enrolment projections. Changing a month carries the same change through to every later month (e.g. +2 in July also adds 2 to Aug–Dec).
Headcounts from your Enrolment Table (per-child registry): June actual 65; July dips to 62 on withdrawals, then September intakes take you to 68 — 93% of capacity — through year-end. Historical average net fee per student on this basis: $1,564–$1,705/mo this year, rising as new students join at current rates.
Avg fee is school fees only, exclusive of subsidies. Subsidy: the government pays $300/mo per local child; with ~75–86% of children local, that averages ≈$250 across all students — raise it toward $300 if the local mix grows. Other income = additional subsidy + bus fees + registration & misc (recent run-rate ≈ $3,530). MBIS royalty has run at 4.7% of total revenue.
Monthly run-rates, defaulted from your last six months of actuals. Edit any line.
The baseline is the school’s total June 2026 staffing cost (salaries, employer CPF, and management cost-shares). To plan a change, add a row: choose new hire or departure, enter that person’s monthly gross salary and when it takes effect — the tool adds 17% employer CPF automatically. Individual payroll details are not shown in this view.
A departure’s savings start the month after their last month worked; a hire’s cost starts in their first month. The December figure above drives the year-end forecast.
Base staff costs: management + staff salaries and employer CPF. Bonuses are excluded from every month — both the 2025 actuals and the 2026 forecast — so the year-on-year comparison is like-for-like (the bonus itself lives under One-off & seasonal items). Dec 2025 is shown ex-bonus at $68,680 rather than the $81,580 booked. The lower panel shows each 2026 month against the same month in 2025; forecast months follow your staffing plan above. Note: Jan–May 2026 actuals are as booked, where the seconded and HQ recharges aren’t yet visible; forecast months include them per your cost-sharing policy.
Events that don’t recur monthly. The pre-filled rows are all expenses, taken from what FY2025 actually cost — set any to zero if it won’t happen. You can also add your own one-off items and mark them as income (e.g. a grant or a lump-sum refund) or expense.
June–December 2026, plus the full-year landing including January–May actuals.