PROJECT AT A GLANCE - TOP SHEET

1 Name of the Entreprenuer BIPLAB MANDAL

2 Constitution (legal Status) Individual :

3 Father's/Spouce's Name CHARU MANDAL

4 Unit Address : Hingalganj Bazar

0
Taluk/Block: Hingalganj
District : Hingalganj
Pin: 743435 State: WB
E-Mail : [email protected]
Mobile 9932814439
5 Product and By Product

6 Cost of Project : Rs. 9,90,639

Name of the project / business
MA TARULATA BHANDER
activity proposed :
7 Means of Finance
Term Loan Rs. 8,91,575.00
KVIC Margin Money Rs. 2,47,660.00
Own Capital Rs. 99064.00

8 Debt Service :
Coverage Ratio

9 Pay Back Period : 5 Years

10 Project : 0 Months
Implementation
Period

11 Break Even Point :

12 Employment : 6

13 Power Requirement : 0

14 Major Raw materials : Turmeric,Raw Mustard ,Red Chili

15 Estimated Annual : Rs. 7000000.00

Sales Turnover

PMEGP Project Report Page 1

 DETAILED PROJECT REPORT
1 INTRODUCTION :

MA TARULATA BHANDER is a gnereations old business enterprise, conducting business in spices and groceries for
more than 5 decades. This instituion is situated at the heart of Hingalganj Bazar. It has a certain base of customers
with proven goodwill.

2 ABOUT THE PROMOTER :

Biplab Mandal is the current promoter of the business. He is running it for almost 2 decades. He is man of high
ambition with long term vision. As the locality has almost no process facility of spices, he wants to introduce it.

3 COST OF PROJECT
A. Fixed Capital Investment
a. Land : 3000 Own

b. Workshed Area Sq.ft Rate in Rs. Amt. In Rs.

Warehouse 900 100.00 90000.00
Showroom 600 100.00 60000.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
Total 150000.00
#REF!
C. Machinery Qty. Rate Amount in Rs.
GRINDERS 10 20000.00 200000.00
PACKGERS 3 10000.00 30000.00
ROLLERS 2 10000.00 20000.00
WEIGHT MACHINES 2 15000.00 30000.00
OTHERS 1 20000.00 20000.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
Total 300000.00

PMEGP Project Report Page 2

 d. Preliminary & Pre-operative Cost : Rs. 50000.00

e. Furniture & Fixtures : Rs. 50000.00

f. Contingency/Others/Miscellaneous : Rs. 50000.00

Total Capital Expenditure : Rs. 600000.00

Working Capital : Rs. 390639.00

Total Cost Project : Rs. 990639.00

3.1 Means of Financing :

Own Contribution 10% Rs. 99064.00

Bank Finance : 90%

Term Loan Rs. 540000.00
Working Capital Rs. 351575.00

Total Rs. 891575.00

Margin Money (Govt. Subsidy) From KVIC 25% Rs. 247660.00

Margin Money Subsidy received From KVIC will be kept in term deposit as per norms of
PMEGP in the name of Beneficiary for three years in the financing branch.

3.2 STATEMENT SHOWING THE REPAYMENT OF TERM LOAN & WORKING CAPITAL :
TERM LOAN

Interest @
Year Opening Balance Installment Closing Balance
10.00%
1st 540000 0 540000 54000
2nd 540000 108000 432000 54000
3rd 432000 108000 324000 43200
4th 324000 108000 216000 32400
5th 216000 108000 108000 21600
6th 108000 108000 0 10800
7th 0 0 0 0
8th 0 0 0 0

WORKING CAPITAL

Interest @
Year Opening Balance Installment Closing Balance
10.00%
1st 351575 0 351575 35158
2nd 351575 70315 281260 35158
3rd 281260 70315 210945 28126
4th 210945 70315 140630 21095
5th 140630 70315 70315 14063
6th 70315 70315 0 7032
7th 0 0 0 0
8th 0 0 0 0

PMEGP Project Report Page 3

 3.3 STATEMENT SHOWING THE DEPRECIATION ON FIXED ASSETS:
WORKSHED @ 10.00%
Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Opening Balance 150000 135000 121500 109350 98415
Depreciation 15000 13500 12150 10935 9842
Closing Balance 135000 121500 109350 98415 88574
MACHINERY @ 10.00%
Opening Balance 300000 270000 243000 218700 196830
Depreciation 30000 27000 24300 21870 19683
Closing Balance 270000 243000 218700 196830 177147
TOTAL DEPRECIATION
Workshed 15000 13500 12150 10935 9842
Machinery 30000 27000 24300 21870 19683
Total 45000 40500 36450 32805 29525

4 Schedule of Sales Realization :

4.1 Details of Sales
Rate/ No. of Amount in Rs.
Particulars of Product
Pair/Unit Pair/Unit
0
Turmeric Powder 100.00 10000 1000000.00
Mustard Seeds 200.00 5000 1000000.00
Chili Powder 200.00 5000 1000000.00
Cumin Seeds 200.00 5000 1000000.00
Coriander Seeds 200.00 5000 1000000.00
Garam Masala 200.00 5000 1000000.00
Long Pepper 200.00 5000 1000000.00
Total 7000000.00

4.2 Capacity Utilization of Sales

Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year

Capacity Utilization 70% 80% 90% 90% 90%

Sales / Receipts 4900000 5600000 6300000 6300000 6300000

5 Rawmaterials :
Particulars Unit Rate/unit Reqd.Unit Amount in Rs.
Turmeric KG 80.00 10000 800000.00
Raw Mustard KG 80.00 6000 480000.00
Red Chili KG 80.00 6000 480000.00
Raw Cumin KG 80.00 6000 480000.00
Raw Coriander KG 80.00 6000 480000.00
Others KG 80.00 2000 160000.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
Total 2880000.00
5.1 Wages :
No. of Wages Amount in Rs.
Particulars
Worker Per Month (Per Annum)
Skilled Labor 1 20000.00 240000.00
Un-Skilled Labor 2 15000.00 360000.00
Assistant 1 10000.00 120000.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0 0.00 0.00
Total 4 720000.00

5.2 Repairs and Maintenance : Rs. 7000.00

PMEGP Project Report Page 4

 5.3 Power and Fuel : Rs. 35000.00

5.4 Other Overhead Expenses : Rs. 70000.00

6 Administrative Expenses :
6.1 Salary
Manager 1 30000.00 360000.00
Sales Person 1 20000.00 240000.00
0 0 0.00 0.00
0 0.00 0.00
0 0.00 0.00
Total 2 600000.00

6.2 Telephone Expenses 7000.00

6.4 Stationery & Postage 700.00

6.5 Advertisement & Publicity 7000.00

6.6 Workshed Rent 60000.00

6.7 Other Miscellaneous Expenses 7000.00

Total 681700.00
7 Capacity Utilization of Manufacturing & Administrative Expenses :
Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Capacity Utilization 70% 80% 90% 90% 90%
Manufacturing Expenses
Rawmaterials 2016000 2304000 2592000 2592000 2592000
Wages 504000 576000 648000 648000 648000
Repairs & Maintenance 4900 5600 6300 6300 6300
Power & Fuel 24500 28000 31500 31500 31500
Other Overhead Expenses 49000 56000 63000 63000 63000
Administrative Expenses
Salary 600000 600000 600000 600000 600000
Postage Telephone Expenses 4900 5600 6300 6300 6300
Stationery & Postage 490 560 630 630 630
Advertisement & Publicity 4900 5600 6300 6300 6300
Workshed Rent 60000 60000 60000 60000 60000
Other Miscellaneous Expenses 4900 5600 6300 6300 6300
Total: 3273590 3646960 4020330 4020330 4020330
8 Assessment of Working Capital :
Particulars Amount in Rs.
Sale 7000000.00

Manufacturing Expenses
Raw Material 2880000.00
Wages 720000.00
Repair & Maintenance 7000.00
Power & Fuel 35000.00
Other Overhead Expenses 70000.00

Production Cost 3712000.00

Administrative Cost 681700.00
Manufacturing Cost 4393700.00

PMEGP Project Report Page 5

 Working Capital Estimate :
Element of Working Capital No of Days Basis Amount in Rs.
0 0 Material Cost 0.00

Stock in process 15 Production Cost 185600.00

Finished goods 6 Manufacturing Cost 87874.00

Receivable by 8 Manufacturing Cost 117165.00

Total Working Capital Requirement Per Cycle 390639.00

9 Financial Analysis
9.1 Projected Profit & Loss Account :
Particulars 0 Year 1st Year 2nd Year 3rd Year 4th Year
Sales / Receipts 4900000 5600000 6300000 6300000
4900000 5600000 6300000 6300000
Manufacturing Expenses
Rawmaterials 2016000 2304000 2592000 2592000
Wages 504000 576000 648000 648000
Repairs & Maintenance 4900 5600 6300 6300
Power & Fuel 24500 28000 31500 31500
Other Overhead Expenses 49000 56000 63000 63000
Depreciation 45000 40500 36450 32805
Production Cost 2643400 3010100 3377250 3373605
Administrative Expenses
Salary 600000 630000 661500 694575
Postage Telephone Expenses 4900 5600 6300 6300
Stationery & Postage 490 560 630 630
Advertisement & Publicity 4900 5600 6300 6300
Workshed Rent 60000 60000 60000 60000
Other Miscellaneous Expenses 4900 5600 6300 6300
Administrative Cost 675190 707360 741030 774105
Interest on Bank credit @ 10%
Term Loan 54000 54000 43200 32400
Working Capital Loan 35158 35158 28126 21095
Cost of Sale 3407748 3806618 4189606 4201205
Net Profit Before Tax 1492253 1793383 2110394 2098796
Less Tax 0.00 0.00 0.00 0.00
Net Profit 1492253 1793383 2110394 2098796

9.2 CALCULATION OF DEBT SERVICE CREDIT RATIO (D.S.C.R) :

Particulars 0 Year 1st Year 2nd Year 3rd Year 4th Year
Net Profit 1492253 1793383 2110394 2098796
Add :
Depreciation 45000 40500 36450 32805
TOTAL - A 1537253 1833883 2146844 2131601
Payments :
On Term Loan :
Interest 54000 54000 43200 32400
Installment 0 108000 108000 108000
On Working Capital
Interest 35158 35158 28126 21095
TOTAL - B 89158 197158 179326 161495
D.S.C.R = A/B
17.24 9.30 11.97 13.20
Average D.S.C.R

PMEGP Project Report Page 6

 9.3 PROJECTED BALANCE SHEET :
Particulars 0 Year 1st Year 2nd Year 3rd Year 4th Year
LIABILITIES :
Promoters Capital 99064 99064 99064 99064
Profit 1492253 1793383 2110394 2098796
Term Loan 540000 540000 432000 324000
Working Capital Loan 351575 351575 281260 210945
Current Liabilities 0 0 0 0
Sundry Creditors 0 0 0 0
2482892 2784022 2922718 2732805
ASSETS :
Gross Fixed Assets : 500000 455000 414500 378050
Less : Depreciation 45000 40500 36450 32805
Net Fixed Assets 455000 414500 378050 345245
Preliminary & Pre-Op. Expenses 50000 37500 28125 21094
Current Assets 351575 351575 281260 210945
Cash in Bank/Hand 1676317 2017947 2263408 2176615
Total 2482892 2784022 2922718 2732805

9.4 CASH FLOW STATEMENT :

Particulars 0 Year 1st Year 2nd Year 3rd Year 4th Year
Net Profit 1492253 1793383 2110394 2098796
Add : Depreciation 45000 40500 36450 32805
Term Loan 540000 540000 432000 324000
Working Capital Loan 351575 351575 281260 210945
Promoters Capital 99064 0 0 0
Total 2527892 2725458 2860104 2666546

Total Fixed Capital Invested 600000

Repayment of Term Loan 0 108000 108000 108000

Repayment of WC Loan 0 70315 70315 70315
Current Assets 351575 351575 281260 210945
Total 351575 529890 459575 389260

Opening Balance 0 2176317 4371884 6772413

Surplus 2176317 2195568 2400529 2277286
Closing Balance 2176317 4371884 6772413 9049699

9.5 BREAK EVEN POINT AND RATIO ANALYSIS :

Particulars 0 Year 1st Year 2nd Year 3rd Year 4th Year
Fixed Cost 774190 801860 820680 839310
Variable Cost 2678558 3045258 3405376 3394700
Total Cost 3452748 3847118 4226056 4234010

Sales 4900000 5600000 6300000 6300000

Contribution (Sales-VC) 2221443 2554743 2894624 2905301

B.E.P in % 34.85% 31.39% 28.35% 28.89%

Break Even Sales in Rs. 1707688 1757679 1786168 1820002

Break Even Units 17077 17577 17862 18200

Current Ratio 3.94 1.31 1.13 0.91

Net Profit Ratio 30.45% 32.02% 33.50% 33.31%

PMEGP Project Report Page 7

 This Project Report has been prepared based on the data furnished by the entrepreneur whose details are
given in the application.
Place :
Date:
Prepared by :
Full Name : BIPLAB MANDAL

Signature of the Beneficiary

PMEGP Project Report Page 8