Next Year Revenue Outlook

Confirmed students only. Pending shown separately.

Live from Google Sheet

—

—Confirmed Students

—Required Classes

—Available Seats

—Returning Revenue

ReturningNew

👥 Total Confirmed

—

—

💰 Net Confirmed Revenue

—

—

🏫 Classes Needed

—

—

🏷️ Average Discount

—

—

Click for grade details

🎯 Actual Enrollment vs Target

—

—

—

—Actual / Target

›

Enrollment by Grade

Blue = returning · Yellow = new students

Admission Priorities

Grades with most open seats need marketing focus.

Expected Collections Timeline

Based on Payment_Plan sheet.

EGP Cashflow

Student Mix

Returning vs new confirmed students.

Admissions Mix

—Returning

Grade-Level CEO Summary

Students, revenue, classes and available seats by grade.

Grade	Returning	New	Total	Pending	Net Revenue	Target	Achievement	Classes	Capacity	Open Seats	Utilization

Admissions Data

Loaded from Google Sheet. Local edits here are temporary only — refresh to reload from sheet.

Grade	Returning Confirmed	Returning Pending	New Confirmed	New Pending	Waitlisted	Target

Fees & Capacity Settings

Loaded from Google Sheet. Use the sheet for official changes.

Bulk Average Discount %

Bulk Class Capacity

Bulk Payment PlanGoogle Sheet Plan

Update Local View

Grade	Returning Fee	New Fee	Class Capacity	Average Discount %	Payment Plan	Direct Cost / Class

🚨 Near Full Grades

—

Utilization above 85%

📣 Marketing Focus

—

Grade with most open seats

📌 Class Cost Estimate

—

Based on direct cost / class

Density & Class Report

Operational report for class opening decisions.

Grade	Total Students	Max Density	Classes	Total Seats	Open Seats	Utilization	Decision Signal

Expected Cash Flow

Monthly collections based on Payment_Plan sheet.

Payment Date	Expected Collections	% of Annual Revenue	Notes

Scenario Controls

Temporary only. Not saved to Google Sheet.

Pending Conversion 70%

Fee Increase 0%

Capacity Change +0 seats

Projected Students

—

Confirmed + converted pending

Class Impact

—

—

What-If by Grade

Adjusted students, revenue and classes after scenario assumptions.

—

Grade	Projected Students	Adjusted Capacity	Adjusted Classes	Projected Revenue	Open Seats

💰 Net Tuition Revenue

—

Core operating revenue

📤 Operating Expenses

—

From Expenses sheet

✅ Operating Profit

—

Before other income / expenses

📊 Net Profit

—

Margin shown after other items

Revenue vs Expenses by Grade

■ Revenue   ■ Allocated Expenses

Expense Breakdown by Category

Loaded from the Expenses sheet in Google Sheet.

Mini Income Statement

A compact P&L view for the school.

Google Sheet

Line Item	Amount	% of Net Tuition Revenue

Other Income & Expenses Breakdown

Loaded from Other_Income and Other_Expenses sheets.

Other Income

Other Expenses

Grade-Level Profitability

Tuition revenue plus allocated other income versus allocated expenses.

Live P&L

Grade	Total Revenue	Allocated Expenses	Net Profit	Margin %	Students	Revenue / Student