Group 2- Members

Name Roll No
Input

Table - 1 No of colleges / Institutions

Year 1-Q1 Year 1-Q2 Year 1-Q3 Year 1-Q4
SDP (S1-S6) 4 8 14 11
SDP (S7-S8) 5 9 16 16
FDP 1 3 4 3
Placement 2 7 13 12
APP 0 8 13 13

Quarterly or Yearly data/ no of months in Training Days/ per month

quarter or year Year 1-Q1 Year 1-Q2 Year 1-Q3 Year 1-Q4
SDP (S1-S6) 12.00 24.00 42.00 33.00
SDP (S7-S8) 13.33 54.00 128.00 128.00
FDP 0.75 2.00 4.00 9.00
Total 26.08 80.00 174.00 170.00

Table - 2 Year 1-Q1 Year 1-Q2

SDP (S1-S6) SDP (S7-S8) FDP SDP (S1-S6)

# batches / College 3 2 1 3
# Training days / batch 3 4 3 3
# Participants / batch 50 50 50 50
Billing Per Training day (Rs) 7,500 7,500 9,000 7,500

Year 2 Year 3

SDP (S1-S6) SDP (S7-S8) FDP SDP (S1-S6)

# batches / College 3 4 1 3
# Training days / batch 3 6 3 3
# Participants / batch 50 50 50 50
Billing Per Training day (Rs) 7,500 7,500 9,000 7,500

Table - 3
Year 1 - Q1 Year 1 - Q2
Placement APP Placement APP

# Participants 80 - 560 240

Revenue Per Participant 8,000 10,870 8,000 10,870

Table - 4
Year 1 - Q1 Year 1 - Q2
 Salary/month Salary/mont
/resource No of h/resource No of
(Rs) Resources (Rs) Resources
Business Development
Head - Business Development - - - -
Head - Marketing & Communication 60,000 1 70,000 1
Regional Business Development Manager 50,000 - 60,000 2
Territory Manager 30,000 1 40,000 4
Operations Manager - - - -

Content Delivery Team

New Content Developer 180,000 1 180,000 1
Permenant Facilitators 40,000 4 40,000 4
Temporary Facilitators 3,500 per day
Travel and other exp. 750 per day

Accounts, HR & Admin

GM - HR 60,000 1 60,000 1
GM Finance & Admin - - - -
Asst Manager 30,000 1 30,000 1
Directors Salary 200,000 2 200,000 2

Table - 5
Year 1 - Q1 Year 1 - Q2 Year 1 - Q3 Year 1 - Q4
Admin Overhead (Rs)
Facilities, rent and electricity 150,000 150,000 300,000 600,000
Communication, courier 30,000 30,000 60,000 120,000
Repair and consumables 30,000 30,000 60,000 120,000
Staff welfare charges 30,000 30,000 60,000 120,000
Misc Expenses 60,000 60,000 120,000 240,000

Travel Overhead (Rs) 900,000 1,200,000 1,800,000 1,950,000

Corporate Overhead (Rs) 90,000 90,000 90,000 90,000

Table - 6
Sales & Marketing Overheads Year 1 - Q1 Year 1 - Q2 Year 1 - Q3 Year 1 - Q4

Percentage of Revenue

BTL Promotion campaign 2.0% 4.0% 4.0% 3.0%

Advertising & PR Campaign 5.0% 4.0% 4.0% 3.0%
Digital Marketing Campaign 5.0% 4.0% 2.0% 2.0%
Incentives 0.0% 0.0% 0.0% 5.0%
Bonuses 0.0% 0.0% 0.0% 4.0%
Table - 7 Other Input

Closing Cash 2015-16 150,000

Assessment cost 300 per participant for Placement and APP
LMS cost 200 per participant for Placement and APP, SDP (7-8)
Courseware cost 100 per participant for APP, SDP (7-8), SDP (1-6) and FDP
Permenant Facilitators 10 Max Traning Days
Institutions
Year 2 Year 3
72 114
81 162
16 28
64 113
66 120

per month
Year 2 Year 3
54.00 85.50
162.00 324.00
4.00 7.00
220.00 416.50

Year 1-Q2 Year 1-Q3 Year 1-Q4

SDP (S1- SDP (S1-
SDP (S7-S8) FDP SDP (S7-S8) FDP SDP (S7-S8) FDP
S6) S6)
3 1 3 4 1 3 4 1
6 2 3 6 3 3 6 3
50 50 50 50 50 50 50 50
7,500 9,000 7,500 7,500 9,000 7,500 7,500 9,000

Year 3

SDP (S7-S8) FDP

4 1
6 3
50 50
7,500 9,000

Year 1 - Q3 Year 1 - Q4 Year - 2 Year - 3

Placement APP PlacementAPP Placement APP Placement APP

1,040 390 960 390 5,120 1,980 9,040 3,600

8,000 10,870 8,000 10,870 8,000 10,870 8,000 10,870

Year 1 - Q3 Year 1 - Q4 Year 2 Year 3

 Salary/m
Salary/mon onth/res Salary/mon No of Salary/mont No of
th/resource No of ource No of th/resource Resourc h/resource Resourc
(Rs) Resources (Rs) Resources (Rs) es (Rs) es

- - - - - - 150,000 1
60,000 1 60,000 1 80,000 1 90,000 1
60,000 3 60,000 3 70,000 4 85,000 4
40,000 6 40,000 8 45,000 8 55,000 10
- - - - 40,000 1 900,000 1

180,000 1 180,000 1 220,000 1 260,000 1

40,000 4 40,000 4 35,000 4 40,000 4

70,000 1 70,000 1 80,000 1 100,000 1

- - - - 80,000 1 100,000 1
35,000 1 35,000 1 40,000 1 50,000 1
200,000 2 200,000 2 200,000 2 200,000 2

Year - 2 Year - 3

3,000,000 3,960,000
720,000 900,000
720,000 900,000
720,000 900,000
1,440,000 1,800,000

9,600,000 12,000,000

420,000 480,000

Year 2 Year 3

Revenue

2.0% 1.5%
3.0% 1.5%
1.5% 1.5%
3.0% 2.0%
3.0% 2.0%
t and APP, SDP (7-8)
7-8), SDP (1-6) and FDP
Model

Calculation of EBITDA, EBITDA % and Closing Cash Balance for the following years:

Particulars Basis Year 1

Q1 Q2
A) Revenue
SDP (S1- S6) No of colleges * Batches/ college * 270,000 540,000
SDP (S7- S8) Training Days/ batch * Billing Rate / 300,000 1,215,000
FDP Day 27,000 54,000
Placement 640,000 4,480,000
Participants * Revenue/ participant
APP - 2,608,800
Total Revenue 1,237,000 8,897,800

B) Direct Cost
Assessment cost
Placement Program 24,000 168,000
Participants * Cost per participant
APP Program - 72,000
LMS cost
Placement Program 16,000 112,000
Participants * Cost per participant
APP Program - 48,000

No of college * Batches/ college *

SDP (S7-8) 100,000 270,000
Participants/ batch * Cost/ participant

Courseware cost
APP Program Participants * Cost per participant - 24,000
SDP (S7-8) 50,000 135,000
SDP (S1-6) No of college * Batches/ college * 60,000 120,000
Participants/ batch * Cost/ participant
FDP 5,000 15,000
Total Direct Cost 255,000 964,000

Gross Profit 982,000 7,933,800

C) Operating Costs

Business Development
Head - Business Development - -
Head - Marketing & Communication 180,000 210,000
Salary/month/resource * No of
Regional Business Development Manager months * No of Resources - 360,000
Territory Manager 90,000 480,000
Operations Manager - -

Content Delivery Team

New Content Developer Salary/month/resource * No of 540,000 540,000
Permenant Facilitators months * No of Resources 480,000 480,000
Temporary Facilitators
SDP (S1-6) No of training days in excess of 10 / 21,000 147,000
SDP (S7-8) month * Rate per training day * No of 35,000 462,000
FDP months - -
Travel and other exp. No of training days /month* Rate per 58,688 180,000
training day * No of months

Accounts, HR & Admin

GM - HR 180,000 180,000
GM Finance & Admin Salary/month/resource * No of - -
Asst Manager months * No of Resources 90,000 90,000
Directors Salary 1,200,000 1,200,000

Admin Overhead (Rs)

Facilities, rent and electricity 150,000 150,000
Communication, courier 30,000 30,000
Repair and consumables 30,000 30,000
Staff welfare charges 30,000 30,000
Misc Expenses 60,000 60,000

Travel Overhead (Rs) 900,000 1,200,000

Given
Corporate Overhead (Rs) 90,000 90,000

Sales & Marketing Overheads

BTL Promotion campaign 24,740 355,912
Advertising & PR Campaign 61,850 355,912
Digital Marketing Campaign 61,850 355,912
Incentives - -
Bonuses - -
Total Operating Cost 4,313,128 6,986,736

EBITDA (3,331,128) 947,064

EBITDA % -269.29% 10.64%

Cash Balance
Opening Balance 150,000 (3,181,128)
Revenue 1,237,000 8,897,800
Direct Cost 255,000 964,000
Operating Cost 4,313,128 6,986,736

Closing Balance (3,181,128) (2,234,064)

 Assumptions
1 All the transactions are in cash
2 Training Days have been considered only for SDP (1-6), SDP (7-
years:

Year 1 Year 2 Year 3

Q3 Q4 Total

945,000 742,500 2,497,500 4,860,000 7,695,000

2,880,000 2,880,000 7,275,000 14,580,000 29,160,000
108,000 81,000 270,000 432,000 756,000
8,320,000 7,680,000 21,120,000 40,960,000 72,320,000
4,239,300 4,239,300 11,087,400 21,522,600 39,132,000
16,492,300 15,622,800 42,249,900 82,354,600 149,063,000

312,000 288,000 792,000 1,536,000 2,712,000

117,000 117,000 306,000 594,000 1,080,000

208,000 192,000 528,000 1,024,000 1,808,000

78,000 78,000 204,000 396,000 720,000

640,000 640,000 1,650,000 3,240,000 6,480,000

39,000 39,000 102,000 198,000 360,000

320,000 320,000 825,000 1,620,000 3,240,000
280,000 220,000 680,000 720,000 1,710,000
20,000 15,000 55,000 80,000 140,000
2,014,000 1,909,000 5,142,000 9,408,000 18,250,000

14,478,300 13,713,800 37,107,900 72,946,600 130,813,000

- - - - 1,800,000
180,000 180,000 750,000 960,000 1,080,000
540,000 540,000 1,440,000 3,360,000 4,080,000
720,000 960,000 2,250,000 4,320,000 6,600,000
- - - 480,000 10,800,000
 540,000 540,000 2,160,000 2,640,000 3,120,000
480,000 480,000 1,920,000 1,680,000 1,920,000

336,000 241,500 745,500 1,848,000 3,171,000

1,239,000 1,239,000 2,975,000 6,384,000 13,188,000
- - - - -
391,500 382,500 1,012,688 1,980,000 3,748,500

210,000 210,000 780,000 960,000 1,200,000

- - - 960,000 1,200,000
105,000 105,000 390,000 480,000 600,000
1,200,000 1,200,000 4,800,000 4,800,000 4,800,000

300,000 600,000 1,200,000 3,000,000 3,960,000

60,000 120,000 240,000 720,000 900,000
60,000 120,000 240,000 720,000 900,000
60,000 120,000 240,000 720,000 900,000
120,000 240,000 480,000 1,440,000 1,800,000

1,800,000 1,950,000 5,850,000 9,600,000 12,000,000

90,000 90,000 360,000 420,000 480,000

659,692 468,684 1,509,028 1,647,092 2,235,945

659,692 468,684 1,546,138 2,470,638 2,235,945
329,846 312,456 1,060,064 1,235,319 2,235,945
- 781,140 781,140 2,470,638 2,981,260
- 624,912 624,912 2,470,638 2,981,260
10,080,730 11,973,876 33,354,470 57,766,325 90,917,855

4,397,570 1,739,924 3,753,431 15,180,275 39,895,145

26.66% 11.14% 8.88% 18.43% 26.76%

(2,234,064) 2,163,507 (3,101,685) 651,746 15,832,021

16,492,300 15,622,800 42,249,900 82,354,600 149,063,000
2,014,000 1,909,000 5,142,000 9,408,000 18,250,000
10,080,730 11,973,876 33,354,470 57,766,325 90,917,855

2,163,507 3,903,431 651,746 15,832,021 55,727,166

or SDP (1-6), SDP (7-8) and FDP program. This is in relation to calculation of salary of permenant and tempora
enant and temporary facilitators
Output

Particulars Year 1
Q1 Q2 Q3
EBITDA (3,331,128) 947,064 4,397,570
EBITDA% -269% 11% 27%
Closing Cash Balance (3,181,128) (2,234,064) 2,163,507
ear 1 Year 2 Year 3
Q4 Total
1,739,924 3,753,431 15,180,275 39,895,145
11% 9% 18% 27%
3,903,431 651,746 15,832,021 55,727,166