Feasibility Calculations & Formulas - Online School India.xlsx

	A	B	C	D	E
1	Comprehensive Online School Feasibility Model (India)
2
3	This model uses dynamic formulas. You can change any value in the Value column (Column C) to see the immediate impact on the Annual Total and Profitability sections.
4
5	Category	Variable	Value	Unit	Calculation Logic / Formula
6	Scaling	Number of Classes	10	Grades	Input (e.g., Grade 1 to 10)
7	Scaling	Students per Class	30	Students	Input (Affects total capacity)
8	TOTAL CAPACITY	Total Student Base	300	Students
9	Revenue	Monthly Fee	3,000	INR	Input
10	Revenue	Annual Reg. Fee	2,500	INR	Input (One-time)
11	ANNUAL REVENUE	Gross Revenue	11,550,000	INR
12	Direct Costs	Teacher Salary (Avg)	35,000	INR / Mo	Input
13	Direct Costs	Teacher-Student Ratio	20	Students/Teacher	Input (Lower number = higher quality/cost)
14	STAFFING COST	Annual Salary Outgo	8,400,000	INR
15	Overheads	Delhi Hub Rent	60,000	INR / Mo	Input
16		LMS & Tech Fees	100	INR / Stud / Mo	Input (Variable based on student count)
17		Marketing (CAC)	1,500	INR / Student	Input (Cost to acquire one student)
18	TOTAL OPEX	Annual Operating Cost	1,200,000	INR
19	PROFITABILITY	Annual Net Profit	1,950,000	INR
20	Breakeven Analysis Logic
21
22	To find the Cash Breakeven Point (the number of students needed to cover monthly fixed costs), use the following formula:
23
24	Fixed Monthly Costs / (Monthly Revenue per Student - Variable Cost per Student)
25
26	In this model:
27
28	Fixed Costs: (Teacher Salaries + Rent + Admin)
29	Contribution Margin: (Monthly Fee - LMS per student - Amortized CAC)
30
31
32	Pre-Launch (2 Mo)	Salaries and marketing before revenue starts.	₹10,00,000
33	Months 1-3	High marketing spend (CAC) and low initial tuition volume.	₹20,00,000
34	Months 4-6	Deficit narrows as enrollment grows.	₹12,00,000
35	Contingency (15%)	Buffer for unexpected marketing costs or slower growth.	₹6,30,000
36	Total Cash Needed	Total Working Capital to reach breakeven.	₹48,30,000
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100