Cleancode
Franchisee Calculations
Get your ROI within 8-12 months with a 27% Annual Average Return
The estimated ROI Period is within 8-12 months of your
operations. Get a 27% Annual Average Growth Return on your business, more than FDs,
Gold, Stock, and Real Estate.
Capex
The following are the estimated Capex and might vary depending
upon the location, materials, vendors, etc.
| DETAILS | TOTAL |
|---|---|
| Interiors (Classroom Benches, Paint, Projector, Whiteboard, Counseling Rooms, Reception, etc) | Rs.3,50,000/- |
| Branding, Signage, and other marketing materials | Rs.1,50,000/- |
| Software License & Franchise Fee | Rs.5,00,000/- |
| Advertising, Marketing, and Lead Generation | Rs.5,00,000/- |
| Student Counseling, Sales and Student Engagement | Rs.3,00,000/- |
| Student Placement | Rs.2,00,000/- |
| TOTAL ESTIMATED CAPEX | Rs.20,00,000/- |
Note: The franchisee needs to renew the Software
License and Franchise Fee after one year of completion from the date of signing the
franchisee agreement. During the renewal, the franchisee can opt for any of the marketing
and sales plans provided by the company from the second year.
- Payable by the Franchise to its Vendors
- Payable by the Franchise to the Company
- Payable by the Franchise to its Vendors
- Payable by the Franchise to the Company
Opex
The following are the estimated Opex and might vary depending
upon the location, quality, and experience of the staff, etc.
| DETAILS | PER MONTH | PER YEAR |
|---|---|---|
| Books and Stationery | Sales Dependency | Sales Dependency |
| Salaries | Rs.1,40,000 | Rs.16,80,000/- |
| Rent | Rs.30,000/- | Rs.3,60,000/- |
| Maintenance | Rs.10,000/- | Rs.1,20,000/- |
| Electricity | Rs.5,000/- | Rs.60,000/- |
| Miscellaneous Expenses | Rs.20,000/- | Rs.2,40,000/- |
| Royalty | Sales Dependency | Sales Dependency |
| TOTAL ESTIMATED OPEX | Rs.2,05,000/- | Rs.24,60,000/- |
P&L Sheet - 12 months of Operations
Note: These calculations are based only on collections
of 285 Students annually.
| Collection | Rs.1,45,28,160/- |
|---|---|
| GST Payable (Minus) | Rs.2,216,160/- |
| Operating Expenses including Books, Stationery, and Royalty (Minus) | Rs.6,310,400/- |
| Estimated Net Revenue | Rs.6,001,600/- |
Estimated Month-Wise Business Plan
Note: These are estimated month-wise business plans for
a franchisee unit.
| P&L Statement | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Collection | - | ₹764,640.00 | ₹764,640.00 | 0 | ₹1,274,400.00 | ₹1,529,280.00 | 0 | ₹1,529,280.00 | ₹3,058,560.00 | ₹1,529,280.00 | ₹2,548,800.00 | ₹1,529,280.00 | ₹14,528,160.00 |
| GST Payable | - | ₹116,640.00 | ₹116,640.00 | 0 | ₹194,400.00 | ₹233,280.00 | 0 | ₹233,280.00 | ₹466,560.00 | ₹233,280.00 | ₹388,800.00 | ₹233,280.00 | ₹2,216,160.00 |
| Operating Expense | ₹90,000.00 | ₹509,200.00 | ₹250,000.00 | ₹205,000.00 | ₹712,000.00 | ₹813,400.00 | ₹205,000.00 | ₹295,000.00 | ₹1,421,800.00 | ₹295,000.00 | ₹1,219,000.00 | ₹295,000.00 | ₹6,310,400.00 |
| Net Revenue | -₹90,000.00 | ₹138,800.00 | ₹398,000.00 | -₹205,000.00 | ₹368,000.00 | ₹482,600.00 | -₹205,000.00 | ₹1,001,000.00 | ₹1,170,200.00 | ₹1,001,000.00 | ₹941,000.00 | ₹1,001,000.00 | ₹6,001,600.00 |
Month Wise Fee Collection Estimations
Note: These are estimated month-wise fee collection
plans for a franchisee unit.
| Collection | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Total Students | - | 15 | 15 | - | 25 | 30 | - | 30 | 60 | 30 | 50 | 30 | 285 |
| Coaching Fees per student | - | ₹43,200.00 | ₹43,200.00 | - | ₹43,200.00 | ₹43,200.00 | - | ₹43,200.00 | ₹43,200.00 | ₹43,200.00 | ₹43,200.00 | ₹43,200.00 | ₹43,200.00 |
| Books | - | ₹3,000.00 | ₹3,000.00 | - | ₹3,000.00 | ₹3,000.00 | - | ₹3,000.00 | ₹3,000.00 | ₹3,000.00 | ₹3,000.00 | ₹3,000.00 | |
| Total Value of Invoice (Before Tax) | - | ₹46,200.00 | ₹46,200.00 | - | ₹46,200.00 | ₹46,200.00 | - | ₹46,200.00 | ₹46,200.00 | ₹46,200.00 | ₹46,200.00 | ₹46,200.00 | |
| GST at 18% (applicable only on tuition fees) | - | ₹7,776.00 | ₹7,776.00 | - | ₹7,776.00 | ₹7,776.00 | - | ₹7,776.00 | ₹7,776.00 | ₹7,776.00 | ₹7,776.00 | ₹7,776.00 | |
| Total Payable Amount per student | - | ₹50,976.00 | ₹50,976.00 | - | ₹50,976.00 | ₹50,976.00 | - | ₹50,976.00 | ₹50,976.00 | ₹50,976.00 | ₹50,976.00 | ₹50,976.00 | |
| Total Collection including GST | - | ₹764,640.00 | ₹764,640.00 | - | ₹1,274,400.00 | ₹1,529,280.00 | - | ₹1,529,280.00 | ₹3,058,560.00 | ₹1,529,280.00 | ₹2,548,800.00 | ₹1,529,280.00 | ₹14,528,160.00 |
Month Wise Operating Expense Estimations
Note: These are estimated month-wise operating expense
plans for a franchisee unit.
| Operating Expense | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Books and Stationery | - | ₹45,000.00 | ₹45,000.00 | ₹0.00 | ₹75,000.00 | ₹90,000.00 | ₹0.00 | ₹90,000.00 | ₹180,000.00 | ₹90,000.00 | ₹150,000.00 | ₹90,000.00 | |
| Salaries | ₹25,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | ₹140,000.00 | |
| Rent | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | ₹30,000.00 | |
| Maintainance | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | ₹10,000.00 | |
| Electricity | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | ₹5,000.00 | |
| Miscellaneous Expenses | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | ₹20,000.00 | |
| Royalty (40% on Coaching Fees) | - | ₹259,200.00 | ₹259,200.00 | - | ₹432,000.00 | ₹518,400.00 | - | ₹518,400.00 | ₹1,036,800.00 | ₹518,400.00 | ₹864,000.00 | ₹518,400.00 | ₹4,924,800.00 |
| Total Operating Expenses | ₹90,000.00 | ₹509,200.00 | ₹250,000.00 | ₹205,000.00 | ₹712,000.00 | ₹813,400.00 | ₹205,000.00 | ₹295,000.00 | ₹1,421,800.00 | ₹295,000.00 | ₹1,219,000.00 | ₹295,000.00 | ₹6,310,400.00 |