Year 2015-16 2016-2017
Head-count
Onsite
Offshore 120 120
TOTAL HEAD-COUNT 120 120
Revenue
Onsite - -
Offshore 110,678,291 108,309,868
Other Income 2,348,233 -
TOTAL INCOME 113,026,524 108,309,868
Payroll Costs 62,982,101 66,131,206
Operating Expenses
Rent 4,539,895 4,993,884
Travelling 784,898 863,388
Communication 1,275,061 1,402,567
Administrative Salaries 3,314,847 3,480,590
Contribution to PF & other funds 2,287,563 2,401,941
Travelling 3,139,594 3,453,553
Office Maint 7,723,076 8,487,384
Selling Expenses
Salaries - -
Publicity Expenses - -
Commision - -
Communication - -
Misc. - -
Interest - -
Depreciation 15 2,967,981
TOTAL EXPENDITURE 86,047,050 94,182,494
-
Capex (INR)
Tangible Assets
Air Conditioner - -
Furniture & Fixtures - -
Vehicles - -
Computers - -
Office Equipment - -
Electrical Equipments - -
Intangible Assets
Computer Software - -
- -
PROJECTED P & L
2015-16 2016-2017
Head-count (STPI Unit) 120 120
Revenue 113,026,524 108,310,000
Payroll Costs 62,982,101 66,131,206
Administrative Expenses 23,064,934 25,083,307
Selling Expenses - -
Interest -
Depreciation 1,480,692 2,967,981
87,527,727 94,182,494
Net Profit Before Tax 25,498,797 14,127,506
Provsion for Income Tax 8,330,507 4,379,527
Deffered Tax 211774 -
Net Profit after Taxation 16,956,516 9,747,979
15.00% 9.00%
PROJECTED BALANCE SHEET
2015-16 2016-2017
A. SOURCES OF FUNDS
EQUITY SHARE CAPITAL 100,000 100,000
RESERVES & SURPLUS 31,563,530 48,520,046
Profit&Loss A/c 16,956,516 9,747,979
TOTAL SHAREHOLDERS FUNDS 48,620,046 58,368,025
- -
NON CURRENT LIABILITIES
Deferred tax liabilities 516,535 516,535
TOTAL EQUITY & LIABILITIES 49,136,581 58,884,560
B. USE OF FUNDS
GROSS FIXED ASSETS 11,255,461 11,255,461
Less:Depreciation 4,038,389 7,006,370
NET FIXED ASSETS 7,217,072 4,249,091
SECURITY DEPOSIT 3,420,598 3,420,598
CURRENT ASSETS
Sundry Debtors 31,836,931 13,538,750
Loans & Advances 15,884,942 15,884,942
Cash & Bank Balances 9,055,807 24,881,455
CURRENT LIABILITIES
Sundry Creditors 279,356 2,090,276
Provisions 17,999,413 1,000,000
NET CURRENT ASSETS 38,498,911 51,214,871
TOTAL ASSETS 49,136,581 58,884,561
- 0
CASH FLOW STATEMENT
2015-16 2016-2017
INFLOW
EQUITY -
LOANS -
PROFIT 16,956,516 9,747,979
DECREASE IN WORKING CAPITAL 2,605,901 3,109,688
DEPRECIATION 1,480,692 2,967,981
OTHER INCOME 12,670,003
TOTAL INFLOW* 21,043,109 15,825,648
OUTFLOW
FIXED ASSETS 2,661,158 -
INCOME TAX PAID 8,330,507
REPAYMENT OF LOANS -
DIVIDEND 20,000,000
TOTAL OUTFLOW 30,991,665 -
CASH & BANK BALANCES
OPENING BALANCES 19,004,363 9,055,807
NET INFLOW/OUTFLOW (9,948,556) 15,825,648
CLOSING BALANCE 9,055,807 24,881,455
Balance as per Balance Sheet 9,055,807 24,881,455
Difference - -
WORKINGS:
FIXED ASSETS:
Opening 86 11,255,461
Additions 27 -
Sold - -
Closing 113 11,255,461
DEPRECIATION:
Opening 26 4,038,389
Additions 15 2,967,981
Sold - -
Closing 40 7,006,370
CASH & BANK BALANCES:
Opening Cash Balance
Profit / Loss for the period
Depreciation
Dividend Paid
Addition to Equity
Repayment of working capital loan
Additions to Fixed Assets
Change in working capital
Closing Cash Balance - -
Equity
Initial Investment for capex
Rental deposits
Working capital
Others
Total
WORKING CAPITAL LOAN:
Opening balance of working capital loan -
Additions - -
Repayment - -
Closing balance of working capital loan - -
Interest -
SUNDRY DEBTORS:
Revenue 113,026,524 108,310,000
Debtors Turnover (months) 1.50
Sundry Debtors - 13,538,750
SUNDRY CREDITORS:
Expenses 23,064,934 25,083,307
Credit Period (months) 1.00
Sundry Creditors - 2,090,276
DEPRECIATION:
Type of Assets Expected Life Rate of Depreciation
Tangible Assets
Air Conditioner 5 years 20%
Furniture & Fixtures 5 years 20%
Vehicles 5 years 20%
Computers 3 years 33%
Office Equipment 5 years 20%
Electrical Equipments 5 years 20%
Intangible Assets
Computer Software 3 years 33%
Total
Head-count 120 120
Expenditure Details: 2015-16 2016-2017
Personal Expenses:
Salaries - Technical staff 62,982,101 66,131,206
Salaries - Support staff 3,314,847 3,480,590
Staff Welfare 290,920 320,012
Contribution to PF & other funds 2,287,563 2,401,941
68,875,431 72,333,749
Operating & Administration Expenses:
Rent 4,539,895 4,993,884
Power 1,945,669 2,140,236
Security Services
Professional charges 947,722 1,042,494
General Expenses 2,552,422 2,807,664
Internet Charges 1,205,043 1,325,547
Telephone 70,018 77,020
Travel - Domestic 19,284 21,212
Travel - Foreign 3,905,208 4,295,729
Rates & Taxes 92,306 101,537
Repairs & Maintenance 201,999 222,199
Audit fee 80,000 80,000
Consumables 473,652 521,017
Printing & Stationery
Bank charges 96,107 105,718
Books & Periodicals
Office Insurance 632,279 695,507
Directors Remuneration 360,000 396,000
Donations 50,000 55,000
17,171,604 18,880,764
Total 86,047,035 91,214,513
Per resouce cost - Personal expenses 573,962 602,781
Per resouce cost - operating expenses 143,097 157,340
Per resouce cost - per annum 717,059 760,121
Per resouce cost - per month 59,755 63,343
PROJECT COST AND MEANS OF FINANCE
Particulars 5 years [Link] Lakhs
PROJECT COST:
OFFICE EQUIPMENT
FURNITURE
HARDWARE
SOFTWARE
Rent Deposit
TOTAL
MEANS OF FINANCING
EQUITY
- PROMOTERS
Internal Accruals
Loan from Director
TOTAL
2017-2018 2018-2019 2019-2020 2020-2021
120 120 120 120
120 120 120 120
- - - -
114,424,328 120,831,975 127,593,485 133,688,267
- - - -
114,424,328 120,831,975 127,593,485 133,688,267
69,437,766 72,909,654 76,555,137 80,382,894
5,493,273 6,042,600 6,646,860 7,311,546
949,727 1,091,953 1,201,148 1,321,263
1,542,824 1,697,106 1,866,817 2,053,498
3,654,619 3,837,350 4,029,218 4,230,679
2,522,038 2,648,140 2,780,547 2,919,574
3,798,908 4,367,811 4,804,592 5,285,051
9,328,122 10,252,934 11,270,228 12,389,251
- - - -
- - - -
- - - -
- - - -
- - - -
- - - -
2,772,139 2,223,734 1,796,309 356,910
99,499,416 105,071,283 110,950,856 116,250,667
- - - -
- - - -
- - - -
- - - -
1,500,000 900,000 - -
- - - -
- - - -
400,000 150,000 - -
1,900,000 1,050,000 - -
2017-2018 2018-2019 2019-2020 2020-2021
120 120 120 120
114,420,000 120,830,000 127,590,000 133,690,000
69,437,766 72,909,654 76,555,137 80,382,894
27,289,512 29,937,895 32,599,410 35,510,863
- - - -
- - - -
2,772,139 2,223,734 1,796,309 356,910
99,499,416 105,071,283 110,950,856 116,250,667
14,920,584 15,758,717 16,639,144 17,439,333
4,923,793 5,200,377 5,490,917 5,754,980
- - - - 51.89371438
9,996,791 10,558,340 11,148,227 11,684,353
8.74% 8.74% 8.74% 8.74%
2017-2018 2018-2019 2019-2020 2020-2021
100,000 100,000 100,000 100,000
58,268,025 68,264,816 78,823,156 89,971,383
9,996,791 10,558,340 11,148,227 11,684,353
68,364,816 78,923,156 90,071,383 101,755,736
- - -
- - -
516,535 516,535 516,535 516,535
68,881,351 79,439,691 90,587,918 102,272,271
13,155,461 14,205,461 14,205,461 14,205,461
9,778,508 12,002,242 13,798,552 14,155,462
3,376,953 2,203,219 406,909 49,999
3,420,598 3,420,598 3,420,598 3,420,598
14,302,500 15,103,751 15,948,750 16,711,250
15,884,942 15,884,942 15,884,942 15,884,942
35,170,485 46,322,007 58,643,337 70,164,722
2,274,126 2,494,825 2,716,617 2,959,239
1,000,000 1,000,000 1,000,000 1,000,000
62,083,801 73,815,875 86,760,412 98,801,675
68,881,352 79,439,692 90,587,919 102,272,272
0 1 1 1
2017-2018 2018-2019 2019-2020 2020-2021
- - - - 169.5652
- - -
9,996,791 10,558,340 11,148,227 11,684,353
(579,900) (580,552) (623,206) (519,879)
2,772,139 2,223,734 1,796,309 356,910
12,189,030 12,201,522 12,321,330 11,521,385
1,900,000 1,050,000 - -
1,900,000 1,050,000 - -
24,881,455 35,170,485 46,322,007 58,643,337
10,289,030 11,151,522 12,321,330 11,521,385
35,170,485 46,322,007 58,643,337 70,164,722
35,170,485 46,322,007 58,643,337 70,164,722
- - - -
11,255,461 13,155,461 14,205,461 14,205,461
1,900,000 1,050,000 - -
- - - -
13,155,461 14,205,461 14,205,461 14,205,461
7,006,370 9,778,508 12,002,242 13,798,552
2,772,139 2,223,734 1,796,309 356,910
- - - -
9,778,508 12,002,242 13,798,552 14,155,462
- - - -
- - - -
- - - -
- - - -
- - - -
- -
114,420,000 120,830,000 127,590,000 133,690,000
1.50 1.50 1.50 1.50
14,302,500 15,103,750 15,948,750 16,711,250
27,289,512 29,937,895 32,599,410 35,510,863
1.00 1.00 1.00 1.00
2,274,126 2,494,825 2,716,617 2,959,239
Gross Block (INR in Lakhs)
Opening
2015-16 2016-2017 2017-2018 2018-2019 2019-2020 2020-2021 2015-16
0.51 1.36 1.36 1.36 1.36 1.36 0.86
26.42 35.15 35.15 35.15 35.15 35.15 8.73
9.72 9.72 9.72 9.72 9.72 9.72 -
22.55 34.96 34.96 49.96 58.96 58.96 12.41
2.53 3.42 3.42 3.42 3.42 3.42 0.89
8.34 9.13 9.13 9.13 9.13 9.13 0.78
15.87 18.81 18.81 22.81 24.31 24.31 2.94
85.94 112.55 112.55 131.55 142.05 142.05 26.61
120 120 120 120
2017-2018 2018-2019 2019-2020 2020-2021
69,437,766 72,909,654 76,555,137 80,382,894
3,654,619 3,837,350 4,029,218 4,230,679
352,013 387,215 425,936 468,530
2,522,038 2,648,140 2,780,547 2,919,574
75,966,437 79,782,359 83,790,838 88,001,676
5,493,273 6,042,600 6,646,860 7,311,546
2,354,260 2,589,686 2,848,654 3,133,520
1,146,744 1,261,418 1,387,560 1,526,316
3,088,431 3,397,274 3,737,001 4,110,701
1,458,102 1,603,912 1,764,303 1,940,734
84,722 93,194 102,513 112,765
23,334 25,667 28,234 31,057
4,725,302 5,434,097 5,977,507 6,575,257
111,690 122,859 135,145 148,660
244,419 268,861 295,747 325,321
80,000 80,000 80,000 80,000
573,119 630,431 693,474 762,821
116,289 127,918 140,710 154,781
765,058 841,563 925,720 1,018,292
435,600 479,160 527,076 579,784
60,500 66,550 73,205 80,526
20,760,841 23,065,190 25,363,709 27,892,080
96,727,277 102,847,549 109,154,547 115,893,756
633,054 664,853 698,257 733,347
173,007 192,210 211,364 232,434
806,061 857,063 909,621 965,781
67,172 71,422 75,802 80,482
:
n Lakhs)
Depreciation (INR in Lakhs)
Addition
2016-2017 2017-2018 2018-2019 2019-2020 2020-2021 2015-16 2016-2017 2017-2018
- - - - - 0.22 0.27 0.27
- - - - - 3.19 7.03 7.03
- - - - - 0.39 1.94 0.64
- 15.00 9.00 - - 7.00 11.65 9.66
- - - - - 0.50 0.68 0.68
- - - - - 0.88 1.83 1.83
- 4.00 1.50 - - 2.63 6.27 7.60
- 19.00 10.50 - - 14.81 29.68 27.72
- 1,899,981.00 1,049,989.50
epreciation (INR in Lakhs) Accumulated Depreciation (INR in Lakhs)
2018-2019 2019-2020 2020-2021 2015-16 2016-2017 2017-2018 2018-2019 2019-2020
0.27 0.16 - 0.16 0.43 0.71 0.98 1.14
7.03 6.12 - 4.76 11.79 18.82 25.85 31.97
- - - 6.75 8.70 9.34 9.34 9.34
8.00 8.00 3.00 11.64 23.29 32.95 40.95 48.95
0.68 0.03 - 0.84 1.52 2.21 2.89 2.92
1.83 1.83 0.07 0.88 2.71 4.53 6.36 8.18
4.43 1.83 0.50 0.55 6.82 14.42 18.84 20.68
22.24 17.96 3.57 25.58 55.26 82.98 105.22 123.18
n Lakhs) Net Block (INR in Lakhs)
2020-2021 2015-16 2016-2017 2017-2018 2018-2019 2019-2020 2020-2021
1.14 0.98 0.93 0.66 0.38 0.22 0.22
31.97 27.21 23.36 16.33 9.30 3.19 3.19
9.34 2.59 1.03 0.39 0.39 0.39 0.39
51.95 16.32 11.67 17.00 18.00 10.00 7.00
2.92 2.08 1.89 1.21 0.53 0.50 0.50
8.25 7.37 6.42 4.60 2.77 0.94 0.88
- - - - -
21.18 15.63 12.00 8.39 5.47 3.63 3.13
126.75 72.17 57.30 48.58 36.84 18.88 15.31
PROJECTED P & L `
2015-16 2016-2017 2017-2018 2018-2019 2019-2020
Head-count (STPI Unit) 120 120 120 120 120
Revenue 113026524 108310000 114420000 120830000 127590000
Payroll Costs 62982100.6 66131205.63 69437765.912 72909654.207 76555136.917
Administrative Expenses 23064934.4 25083307.32 27289511.506 29937894.867 32599409.837
Selling Expenses 0 0 0 0 0
Interest 0 0 0 0
Depreciation 1480692 2967980.8827 2772138.5527 2223733.8827 1796309.4852
87527727 94182493.833 99499415.97 105071282.96 110950856.24
Net Profit Before Tax 25498797 14127506.167 14920584.03 15758717.043 16639143.76
Provsion for Income Tax 8330507 4379527 4923793 5200377 5490917
Deffered Tax 211774 0 0 0 0
Net Profit after Taxation 16956516 9747979.1673 9996791.0298 10558340.043 11148226.76
2020-2021
120
133690000
80382893.763
35510862.578
0
0
356910.2
116250666.54
17439333.459
5754980
0
11684353.459
PROJECTED PROFIT AND LOSS STATEMENT
(INR in Lakhs)
2016-2017 2017-2018 2018-2019 2019-2020
REVENUE:
EXPORTS SERVICES
* ONSITE 0 0 0 0
* OFFSHORE 1083 1144 1208 1276
TOTAL 1083 1144 1208 1276
EXPENDITURE:
MANPOWER COST 661 694 729 766
ADMINISTRATIVE EXPENSES 216 235 256 278
SELLING EXPENSES 35 38 44 48
DEPRECI ATION 30 28 22 18
OP. PROFIT BEFORE INTEREST 141 149 158 166
INTEREST 0 0 0 0
NET PROFIT 141 149 158 166
DIVIDEND
TRANSFER TO RESERVES & SURPLUS 141 149 158 166
2020-2021 Total
0 0
1337 6048
1337 6048
804 3654
302 1287
53 217
4 101
174 789
0 0
174 789
174 789
2016-2017 2017-2018 2018-2019 2019-2020
INFLOW
EQUITY - - -
LOANS - -
PROFIT 9,747,979 9,996,791 10,558,340 11,148,227
DECREASE IN WORKING CAPITAL 3,109,688 (579,900) (580,552) (623,206)
DEPRECIATION 2,967,981 2,772,139 2,223,734 1,796,309
OTHER INCOME
TOTAL INFLOW* 15,825,648 12,189,030 12,201,522 12,321,330
OUTFLOW
FIXED ASSETS - 1,900,000 1,050,000 -
INCOME TAX PAID
REPAYMENT OF LOANS
DIVIDEND
TOTAL OUTFLOW - 1,900,000 1,050,000 -
CASH & BANK BALANCES
OPENING BALANCES 9,055,807 24,881,455 35,170,485 46,322,007
NET INFLOW/OUTFLOW 15,825,648 10,289,030 11,151,522 12,321,330
CLOSING BALANCE 24,881,455 35,170,485 46,322,007 58,643,337
2016-2017 2017-2018 2018-2019 2019-2020
INFLOW
EQUITY - - -
LOANS - -
PROFIT 97 100 106 111
DECREASE IN WORKING CAPITAL 31 (6) (6) (6)
DEPRECIATION 30 28 22 18
OTHER INCOME
TOTAL INFLOW* 158 122 122 123
OUTFLOW
FIXED ASSETS - 19 11 -
INCOME TAX PAID
REPAYMENT OF LOANS
DIVIDEND
TOTAL OUTFLOW - 19 11 -
CASH & BANK BALANCES
OPENING BALANCES 91 249 352 463
NET INFLOW/OUTFLOW 158 103 112 123
CLOSING BALANCE 249 352 463 586
2020-2021
-
-
11,684,353
(519,879)
356,910
11,521,385
58,643,337
11,521,385
70,164,722
2020-2021
0.00001
-
-
117
(5)
4
115
586
115
702
BREAK EVEN ANALYSIS
2016-2017 2017-2018 2018-2019
Gross Revenue 1,083.10 1,144.24 1,208.32
1. Variable Cost (Rs)
Manpower Cost ( 80% of total annual bill) 529.05 555.50 583.28
Administartive Cost 140.59 152.69 166.21
Selling Cost 25.90 28.49 32.76
Total 695.54 736.68 782.24
Contribution 387.55 407.56 426.08
II. Fixed Cost(Rs)
Manpower cost (20% of total annual bill) 132.26 138.88 145.82
Other Adminsitrative Expenses 75.70 82.22 89.50
Other Selling Expenses 8.63 9.50 10.92
Interest on Term Loan - - -
Interest on Working Capital - - -
Depreciation 29.68 27.72 22.24
Total 246.28 258.31 268.47
Profilt after Tax 141.27 149.25 157.61
Break Even Point 688.28 725.22 761.36
Cash Break Even Point 605.33 647.39 698.30
III. Revenue per Billable Resource Rs. 9.0258223333 9.5353606667 10.06933125
Variable Cost per Billable Resource 5.7962057965 6.1390238361 6.518678012
IV. Contribution per Billable Resource Rs.(III - I)
(Selling price less variable cost) 3.2296165368 3.3963368305 3.550653238
V. Break-even Billable Resources
Fixed Cost (Rs.)/ Contribution per Billable Resource (Rs.) 76.256806323 76.055854367 75.61185228
(INR in Lakhs)
2019-2020 2020-2021
1,275.93 1,336.88
612.44 643.06
180.67 196.47
36.03 39.64
829.14 879.17
446.79 457.71
153.11 160.77
97.28 105.79
12.01 13.21
- -
- -
17.96 3.57
280.37 283.34
166.43 174.38
800.66 827.57
749.36 817.14
10.632790417 11.140688917
6.9095154295 7.3264067363
3.7232749871 3.8142821804
75.301102342 74.283402134
(All the figures are in Lacs)
EXPORT PROJECTIONS
Company Name SD SOFTECH PRIVATE LIMITED
Promoter/Director NAGENDRA KUMAR
Request by Applicant Renewal of STPI Registration
Particulars 2016-2017 2017-2018 2018-2019 2019-2020 2020-2021
Capital Goods - - 19.00 10.50 -
Exports 1,083.10 1,144.24 1,208.32 1,275.93 1,336.88
FE Outgo 34.54 37.99 43.68 48.05 52.85
Total FE Outgo 34.54 37.99 47.48 53.95 58.75
NFEE 1,048.56 1,106.25 1,160.84 1,221.99 1,278.13
Positive NFE=A-B>0 1,048.56 1,106.25 1,160.84 1,221.99 1,278.13
NFEP 96.81 96.68 96.07 95.77 95.61
Wage Bill 75.00 990.00 1,800.00 2,730.00 3,780.00
Man Year 25.00 75.00 125.00 175.00 225.00
Avg Salary 3.00 13.20 14.40 15.60 16.80
Productivity 14.44 1.16 0.67 0.47 0.35
CG Export Obligation
As per IMSC Guidelines LOP issued w.e.f 1/4/2003 Export Obligation applicable cumulative for 5 years is Positive
NFE=A-B>0
As per above projections -
Total Exports (A) 6,048.48
Total FE Outgo (B) 232.70
Export Obligations Calculation POSITIVE 5,815.78
Approximate Man hour : $ 10.62 per hour
the figures are in Lacs)
Total
29.50
6,048.48
217.10
232.70
5,815.78
5,815.78
9,375.00
625.00
15.00
0.65
or 5 years is Positive
6,048.48
232.70