PROJECT AT A GLANCE - TOP SHEET

1 Name of the Beneficiary NARESH KUMAR

2 Constitution (legal Status) Individual :

3 Father's/Spouce's Name FATHER NAME

4 Unit Address : VILLAGE SANKAD

0
Taluk/Block: SANCHORE
District : SANCHORE
Pin: 343041 State: RAJASTHAN
E-Mail : example@gmail.com
Mobile 9876543210
5 Product and By Product

6 Cost of Project : Rs. 19,86,675

Name of the project / business 0
activity proposed :
7 Means of Finance
Term Loan Rs. 18,87,341.00
KVIC Margin Money Rs. 6,95,336.00
Own Capital Rs. 99334.00

8 Debt Service :
Coverage Ratio

9 Pay Back Period : 5 Years

10 Project : 0 Months
Implementation
Period

11 Break Even Point :

12 Employment : 4

13 Power Requirement : 0

14 Major Raw materials : Decorative Items,,

15 Estimated Annual : Rs. 1500000.00

Sales Turnover

PMEGP Project Report Page 1

 DETAILED PROJECT REPORT
1 INTRODUCTION :

2 ABOUT THE BENEFICIARY :

3 COST OF PROJECT
A. Fixed Capital Investment
a. Land : 2000 Sq.ft Own

b. Furniture & Fixtures Qty. Rate Amt. In Rs.

Tent Ceiling (15x15) 70 2500.00 175000.00
Tent Water Proof (15x30) 10 11000.00 110000.00
Carpet (10x5) 20 550.00 11000.00
Trust 45 4500.00 202500.00
Table Set 50 2700.00 135000.00
Chair Steel 50 1000.00 50000.00
Sofa Set 10 15000.00 150000.00
Bister Set 200 1500.00 300000.00
0 0 0.00 0.00
Total 1133500.00
#REF!
C. Plant & Machinery Qty. Rate Amount in Rs.
Tent Cooler 15 18000.00 270000.00
Pipe (Pandal) 140 1600.00 224000.00
Led Lights 20 3000.00 60000.00
Baans 100 150.00 15000.00
Generator 0 70000.00 70000.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 639000.00

PMEGP Project Report Page 2

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

e. Furniture & Fixtures : Rs. 125000.00

f. Contingency/Others/Miscellaneous : Rs. 5000.00

Total Capital Expenditure : Rs. 1912500.00

Working Capital : Rs. 74175.00

Total Cost Project : Rs. 1986675.00

3.1 Means of Financing :

Own Contribution 5% Rs. 99334.00

Bank Finance : 95%

Term Loan Rs. 1816875.00
Working Capital Rs. 70466.00

Total Rs. 1887341.00

Margin Money (Govt. Subsidy) From KVIC 35% Rs. 695336.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
12.00%
1st 1816875 0 1816875 218025
2nd 1816875 363375 1453500 218025
3rd 1453500 363375 1090125 174420
4th 1090125 363375 726750 130815
5th 726750 363375 363375 87210
6th 363375 363375 0 43605
7th 0 0 0 0
8th 0 0 0 0

WORKING CAPITAL

Interest @
Year Opening Balance Installment Closing Balance
12.00%
1st 70466 0 70466 8456
2nd 70466 14093 56373 8456
3rd 56373 14093 42280 6765
4th 42280 14093 28186 5074
5th 28186 14093 14093 3382
6th 14093 14093 0 1691
7th 0 14093 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 1133500 1020150 918135 826322 743689
Depreciation 113350 102015 91814 82632 74369
Closing Balance 1020150 918135 826322 743689 669320
MACHINERY @ 15.00%
Opening Balance 639000 543150 461678 392426 333562
Depreciation 95850 81473 69252 58864 50034
Closing Balance 543150 461678 392426 333562 283528
TOTAL DEPRECIATION
Workshed 113350 102015 91814 82632 74369
Machinery 95850 81473 69252 58864 50034
Total 209200 183488 161065 141496 124403

4 Schedule of Sales Realization :

4.1 Details of Sales
Rate/ No. of Amount in Rs.
Particulars of Product Pair/Unit Pair/Unit
0
Event Management Services 40000.00 20 800000.00
Light Decoration Services 10000.00 25 250000.00
Tent Decoration Services 18000.00 25 450000.00
0 0.00 0 0.00
0 0.00 0 0.00
0 0.00 0 0.00
0 0.00 0 0.00
Total 1500000.00

4.2 Capacity Utilization of Sales

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

Capacity Utilization 80% 90% 100% 100% 100%

Sales / Receipts 1200000 1350000 1500000 1500000 1500000

5 Rawmaterials :
Particulars Unit Rate/unit Reqd.Unit Amount in Rs.
Decorative Items 0 100000.00 1 100000.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
0 0 0.00 0 0.00
Total 100000.00
5.1 Wages :
No. of Wages Amount in Rs.
Particulars Worker Per Month (Per Annum)
Labour Charges 3 5000.00 180000.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 3 180000.00

5.2 Repairs and Maintenance : Rs. 75000.00

PMEGP Project Report Page 4

 5.3 Power and Fuel : Rs. 30000.00

5.4 Other Overhead Expenses : Rs. 4500.00

6 Administrative Expenses :
6.1 Salary
0 1 10000.00 120000.00
0 0 0.00 0.00
0 0 0.00 0.00
0 0.00 0.00
0 0.00 0.00
Total 1 120000.00

6.2 Telephone Expenses 3750.00

6.4 Stationery & Postage 6000.00

6.5 Advertisement & Publicity 15000.00

6.6 Workshed Rent 0.00

6.7 Other Miscellaneous Expenses 7500.00

Total 152250.00
7 Capacity Utilization of Operating & Administrative Expenses :
Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Capacity Utilization 80% 90% 100% 100% 100%
Operating Expenses
Consumables 80000 90000 100000 100000 100000
Wages 144000 162000 180000 180000 180000
Repairs & Maintenance 60000 67500 75000 75000 75000
Power & Fuel 24000 27000 30000 30000 30000
Other Overhead Expenses 3600 4050 4500 4500 4500
Administrative Expenses
Salary 120000 120000 120000 120000 120000
Postage Telephone Expenses 3000 3375 3750 3750 3750
Stationery & Postage 4800 5400 6000 6000 6000
Advertisement & Publicity 12000 13500 15000 15000 15000
Workshed Rent 0 0 0 0 0
Other Miscellaneous Expenses 6000 6750 7500 7500 7500
Total: 457400 499575 541750 541750 541750
8 Assessment of Working Capital :
Particulars Amount in Rs.
Sale 1500000.00

Operating Expenses
Consumables 100000.00
Wages 180000.00
Repair & Maintenance 75000.00
Power & Fuel 30000.00
Other Overhead Expenses 4500.00

Operating Cost 389500.00

Administrative Cost 152250.00
Total Cost 541750.00

PMEGP Project Report Page 5

 Working Capital Estimate :
Element of Working Capital No of Days Basis Amount in Rs.
Consumables 60 Material Cost 20000.00

Stock in process 0 Production Cost 0.00

Finished goods 0 Manufacturing Cost 0.00

Receivable by 30 Total Cost 54175.00

Total Working Capital Requirement Per Cycle 74175.00

9 Financial Analysis
9.1 Projected Profit & Loss Account :
Particulars 0 Year 1st Year 2nd Year 3rd Year 4th Year
Sales / Receipts 1200000 1350000 1500000 1500000
1200000 1350000 1500000 1500000
Operating Expenses
Consumables 80000 90000 100000 100000
Wages 144000 162000 180000 180000
Repairs & Maintenance 60000 67500 75000 75000
Power & Fuel 24000 27000 30000 30000
Other Overhead Expenses 3600 4050 4500 4500
Depreciation 209200 183488 161065 141496
Production Cost 520800 534038 550565 530996
Administrative Expenses
Salary 120000 126000 132300 138915
Postage Telephone Expenses 3000 3375 3750 3750
Stationery & Postage 4800 5400 6000 6000
Advertisement & Publicity 12000 13500 15000 15000
Workshed Rent 0 0 0 0
Other Miscellaneous Expenses 6000 6750 7500 7500
Administrative Cost 145800 155025 164550 171165
Interest on Bank credit @ 12%
Term Loan 218025 218025 174420 130815
Working Capital Loan 8456 8456 6765 5074
Cost of Sale 893081 915543 896300 838050
Net Profit Before Tax 306919 434457 603700 661950
Less Tax 0.00 0.00 0.00 0.00
Net Profit 306919 434457 603700 661950

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 306919 434457 603700 661950
Add :
Depreciation 209200 183488 161065 141496
TOTAL - A 516119 617944 764765 803446
Payments :
On Term Loan :
Interest 218025 218025 174420 130815
Installment 0 363375 363375 363375
On Working Capital
Interest 8456 8456 6765 5074
TOTAL - B 226481 589856 544560 499264
D.S.C.R = A/B
2.28 1.05 1.40 1.61
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 :
Beneficiary's Capital 99334 99334 99334 99334
Profit 306919 434457 603700 661950
Term Loan 1816875 1816875 1453500 1090125
Working Capital Loan 70466 70466 56373 42280
Current Liabilities 0 0 0 0
Sundry Creditors 0 0 0 0
2293594 2421132 2212907 1893689
ASSETS :
Gross Fixed Assets : 1897500 1688300 1504813 1343747
Less : Depreciation 209200 183488 161065 141496
Net Fixed Assets 1688300 1504813 1343747 1202251
Preliminary & Pre-Op. Expenses 10000 7500 5625 4219
Current Assets 70466 70466 56373 42280
Cash in Bank/Hand 534828 845853 812787 649158
Total 2293594 2421132 2212907 1893689

9.4 CASH FLOW STATEMENT :

Particulars 0 Year 1st Year 2nd Year 3rd Year 4th Year
Net Profit 306919 434457 603700 661950
Add : Depreciation 209200 183488 161065 141496
Term Loan 1816875 1816875 1453500 1090125
Working Capital Loan 70466 70466 56373 42280
Beneficiary's Capital 99334 0 0 0
Total 2502794 2505285 2274638 1935851

Total Fixed Capital Invested 1912500

Repayment of Term Loan 0 363375 363375 363375

Repayment of WC Loan 0 14093 14093 14093
Current Assets 70466 70466 56373 42280
Total 70466 447934 433841 419748

Opening Balance 0 2432328 4489679 6330476

Surplus 2432328 2057351 1840797 1516103
Closing Balance 2432328 4489679 6330476 7846579

9.5 BREAK EVEN POINT AND RATIO ANALYSIS :

Particulars 0 Year 1st Year 2nd Year 3rd Year 4th Year
Fixed Cost 573025 556538 500035 443476
Variable Cost 529256 542493 557330 536070
Total Cost 1102281 1099031 1057365 979546

Sales 1200000 1350000 1500000 1500000

Contribution (Sales-VC) 670744 807507 942670 963930

B.E.P in % 85.43% 68.92% 53.04% 46.01%

Break Even Sales in Rs. 1025175 930427 795668 690106

Break Even Units 26 23 20 17

Current Ratio 0.31 0.12 0.10 0.08

Net Profit Ratio 25.58% 32.18% 40.25% 44.13%

PMEGP Project Report Page 7

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

Signature of the Beneficiary

PMEGP Project Report Page 8

PMEGP Project Report Page 9
PMEGP Project Report Page 10
 TRUE

PMEGP Project Report Page 11

PMEGP Project Report Page 12
PMEGP Project Report Page 13
PMEGP Project Report Page 14
PMEGP Project Report Page 15
PMEGP Project Report Page 16