nepa projection amit

8/8/2019 Nepa Projection Amit

1/47

NEPA LTD. NEPANAGAR

Cost of Project & Means of Finance

Cost of Project

S. No. Particulars

1 Land

2 Building:

Factory Building 1070.00

Auxilliary Building 30.003 Railway Siding

4 Water Works

5 Roads and Bridges

6 Tools and Implements

7 Furniture, Fiztures & Equipments

8 Library Books\

9 Vehical

10 Discard Assets

11 Plant &Machinery12 Electric Installation

13 Preoperative Expenses

14 Preliminary Expenses

15 Contingencies

16 Working capital Margin

Total

Means of Finance

S. No. Particulars

1 Own Capital:

Equity Capital 1060.98

Unsecured Loan 0.00

2 Debts:

Term Loan 2121.97


2/47

Total

Capitalisation of contingencies and Electric Installation in their respective Ratios

Building Plant & Machinery TotalBalance 1100.00 1000.00 2100.00

Contingencies 151.33 137.57 288.90

Electric Installation 5.24 4.76 10.00

Total 1256.57 1137.57 2398.90


3/47

(Amount in Lacs)

Proposed Tangible balance sheet

Amount Assets

3.00 3.00 2.58

1066.92

1100.00 1100.00205.00 205.00 206.39

230.00 230.00 229.4

35.00 35.00 34.32

10.00 10.00 5.37

180.00 180.00 186.35

1.00 1.00 0.31

40.00 40.00 37.77

50.00 50.00 45.38

1000.00 15.00 9102.710.00 10.00 Assume

10.00 Assume

Assume

4.95 @10% on item 1 to 13

3182.95 1879.00

1060.98

2121.97

15.00

288.90

5.05


4/47

3182.95


5/47

NEPA LTD. NEPANAGAR

ASSUMPTIONS:

1. Number of Working Days in a year 300

I II III

Calculation of Sales

Capacity Utilisation 100% 50% 55% 60%

Units (produced) MT 88000 44000 48400 52800

Opening stock 0 2200.00 2420.00

Closing Stock (15 days) 15 2200 2420 2640

Units available fior sale 41800 45980 50160

Sale Price Rs. Per MT 23750 23750 23750 23750

Sales (Rs. In lakhs) 9927.50 10920.25 11913.00

Purchase of Raw Material

Units Produced ( Finished Goods) 44000 48400 52800

Rate of raw material to produce 1 MT Newsprint (R.s.) 9000 9000 9000 9000

Purchase (Rs. In lakhs) 3960.00 4356.00 4752.00

Closing Stock of Raw Material

14400 16800 19200

10 days closing stock @ 9000/ MT (Purchase*10/300) 132.00 145.20 158.40

Consumption for the year

Meters

Opening Stock 0.00 14400 16800

Add: Purchase 288000 336000 384000

Less: Closing Stock 14400 16800 19200

Consumption (in metres) 273600 333600 381600

Consumption

Opening Stock 0.00 132.00 145.20

Add: Purchase 3960.00 4356.00 4752.00Less: Closing Stock 132.00 145.20 158.40

Consumption (in Rs. lakhs) 4092.00 4633.20 5055.60

Calculation of Work in Process

Production of Finished Goods 44000 48400 52800


6/47

Prime Cost Per Unit 20625.96 20625.96 20625.96

Closing stock of WIP Rs. In lakhs (3 Days) 90.75 99.83 108.91

Calculation of Finished Goods

Units produced Days 44000 48400 52800Cost of production 21208.4 21208.4 21208.4

Closing stock of Finished Goods 15 466.58 513.24 559.90

(Rs. In lakhs)

Calculation of Wages

Units 44000 48400 52800

Wages in lacs (4382.095 per unit) 4382.09 1928.12 2120.93 2313.75

Calculation of Power and Fuel

Units 44000 48400 52800Power & Fuel in lacs 6139.23 2701.26 2971.39 3241.51

Calculation of Other Direct Expenses

Units 44000 48400 52800

Other Direct Expenses in lacs 11625.96 5115.42 5626.97 6138.51

Calculation of Administrative Expenss

Units 44000 48400 52800

Administrative Expenses in lacs 582.43 256.27 281.90 307.53

Calculation of Selling Expenss

Units 44000 48400 52800

Selling Expenses 421.48 185.45 204.00 222.54

Cost Sheet per unit of Newsprint manufacturer

Material Consumed 9000

11625.96

Wages 4382.09

Stores and Spares consumed 228.76

Chemical consumed 214.14

Power and Fuel 6139.23Water cess 31.89

Insurance 10.81

Obsolescence Allowance 52.02

Research & Development 217.64

Repair & Maintainance 328.79

Excise Duty and Cesss on paper 20.59

Prime Cost 20625.96

Direct expenses:


7/47

Add Administrative expenses 582.43

Cost of production 21208.40

Selling expenses 421.48

Cost of sales 21629.87

Profit 2120.13

Selling price 23750.00

Calculation of Depreciation

Depreciation is calculated according to WDV Method

Land

Particulars I II III

Op Balance 0.00 3.00 3.00

Addition 3.00 0.00 0.00

Deduction 0.00 0.00 0.00

Gross Block 3.00 3.00 3.00Less: Dep 0.00 0.00 0.00

Net Block 3.00 3.00 3.00

Depreciation - % 0.00 0.00 0.00

Depreciation - Rs. 0.00 0.00 0.00

Building


Op Balance 0.00 1193.74 1134.05

Addition 1256.57 0.00 0.00

Deduction 0.00 0.00 0.00

Gross Block 1256.57 1193.74 1134.05

Less: Dep 62.83 59.69 56.70Net Block 1193.74 1134.05 1077.35

Depreciation % 5% 5% 5%

Depreciation - Rs. 62.83 59.69 56.70

Plant & Machinery


Op Balance 0.00 966.94 821.90

Addition 1137.57 0.00 0.00

Deduction 0.00 0.00 0.00

Gross Block 1137.57 966.94 821.90

Less: Dep 170.64 145.04 123.28Net Block 966.94 821.90 698.61

Depreciation - % (@15% by WDV method (in lacs) 15% 15% 15%

Depreciation - Rs. 170.64 145.04 123.28

Furniture & Fixtures



8/47

Op Balance 0.00 162.00 144.00

Addition 180.00 0.00 0.00

Deduction 0.00 0.00 0.00

Gross Block 180.00 162.00 144.00

Less: Dep 18.00 18.00 18.00

Net Block 162.00 144.00 126.00

Depreciation - % WDV 10%Depreciation - Rs. Lacs 18.00 18.00 18.00

Total Dep. 251.46 222.73 197.99

Total Op. Balance 0.00 1627.54 1404.81

Total Additions 1879.00 0.00 0.00

Closing Balance 1627.54 1404.81 1206.82

Calculation of Creditors

Purchase 3960.00 4356.00 4752.00

Months 0.5 0.5 0.5

Creditors (Rs. In lakhs) 165.00 181.50 198.00

Calculation of Debtors (on sales)

Sales 9927.50 10920.25 11913.00

Months 0.75 0.75 0.75

Debtors (Rs. In lakhs) 620.47 682.52 744.56

Total Inventory

Raw Material 132.00 145.20 158.40Work in Process 90.75 99.83 108.91

Finished Goods 466.58 513.24 559.90

Inventory 689.34 758.27 827.21

Add Debtors 620.47 682.52 744.56

Total Current Assets 1,309.81 1,440.79 1,571.77

Less Creditors 165.00 181.50 198.00

Working Capital 1,144.81 1,259.29 1,373.77

Margin for Working Capital 25% of WC 25% 286.20 314.82 343.44

Working Capital Loan 858.61 944.47 1,030.33

Interest @ 12.5% 12.5% 107.33 118.06 128.79


9/47

IV V VI VII VIII

65% 70% 75% 80% 80%

57200 61600 66000 70400 70400 88000

2640.00 2860.00 3080.00 3300.00 3520.00

2860 3080 3300 3520 3520

54340 58520 62700 66880 66880

23750 23750 23750 23750 23750

12905.75 13898.50 14891.25 15884.00 15884.00

57200 61600 66000 70400 70400

9000 9000 9000 9000 9000

5148.00 5544.00 5940.00 6336.00 6336.00

19200 19200 19200 19200 19200

171.60 184.80 198.00 211.20 211.20

19200 19200 19200 19200 19200

384000 384000 384000 384000 384000

19200 19200 19200 19200 19200

384000 384000 384000 384000 384000

158.40 171.60 184.80 198.00 211.20

5148.00 5544.00 5940.00 6336.00 6336.00171.60 184.80 198.00 211.20 211.20

5478.00 5900.40 6322.80 6745.20 6758.40

57200 61600 66000 70400 70400


10/47

20625.96 20625.96 20625.96 20625.96 20625.96

117.98 127.06 136.13 145.21 145.21

57200 61600 66000 70400 7040021208.4 21208.4 21208.4 21208.4 21208.4

606.56 653.22 699.88 746.54 746.54

57200 61600 66000 70400 70400

2506.56 2699.37 2892.18 3084.99 3084.99

57200 61600 66000 70400 704003511.64 3781.77 4051.89 4322.02 4322.02

57200 61600 66000 70400 70400

6650.05 7161.59 7673.13 8184.68 8184.68

57200 61600 66000 70400 70400

333.15 358.78 384.41 410.03 410.03

57200 61600 66000 70400 70400

241.09 259.63 278.18 296.72 296.72

1702.4 38849

88.87 38849

83.19 38849

2385.03 3884912.39 38849

4.2 38849

20.21 38849

84.55 38849

127.73 38849

8 38849


11/47

226.27 38849

163.74 38849

IV V VI VII VIII

3.00 3.00 3.00 3.00 3.00

0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

3.00 3.00 3.00 3.00 3.000.00 0.00 0.00 0.00 0.00

3.00 3.00 3.00 3.00 3.00

0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

IV V VI VII VIII

1077.35 1023.48 972.31 923.69 877.51

0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

1077.35 1023.48 972.31 923.69 877.51

53.87 51.17 48.62 46.18 43.881023.48 972.31 923.69 877.51 833.63

5% 5% 5% 5% 5%

53.87 51.17 48.62 46.18 43.88

IV V VI VII VIII

698.61 593.82 504.75 429.03 364.68

0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

698.61 593.82 504.75 429.03 364.68

104.79 89.07 75.71 64.36 54.70593.82 504.75 429.03 364.68 309.98

15% 15% 15% 15% 15%

104.79 89.07 75.71 64.36 54.70

IV V VI VII VIII


12/47

126.00 108.00 90.00 72.00 54.00

0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

126.00 108.00 90.00 72.00 54.00

18.00 18.00 18.00 18.00 18.00

108.00 90.00 72.00 54.00 36.00

18.00 18.00 18.00 18.00 18.00

176.66 158.25 142.33 128.54 116.58

1206.82 1030.16 871.92 729.59 601.05

0.00 0.00 0.00 0.00 0.00

1030.16 871.92 729.59 601.05 484.47

5148.00 5544.00 5940.00 6336.00 6336.00

0.5 0.5 0.5 0.5 0.5

214.50 231.00 247.50 264.00 264.00

12905.75 13898.50 14891.25 15884.00 15884.00

0.75 0.75 0.75 0.75 0.75

806.61 868.66 930.70 992.75 992.75

171.60 184.80 198.00 211.20 211.20117.98 127.06 136.13 145.21 145.21

606.56 653.22 699.88 746.54 746.54

896.14 965.07 1,034.01 1,102.94 1,102.94

806.61 868.66 930.70 992.75 992.75

1,702.75 1,833.73 1,964.71 2,095.69 2,095.69

214.50 231.00 247.50 264.00 264.00

1,488.25 1,602.73 1,717.21 1,831.69 1,831.69

372.06 400.68 429.30 457.92 457.92

1,116.19 1,202.05 1,287.91 1,373.77 1,373.77

139.52 150.26 160.99 171.72 171.72


13/47

TERM LOAN 2,121.97 LACS 163.23

12%

2,121.97

I I Half Year II Half Year Total

Opening Balance 0.00 2,121.97

Disbursement 2,121.97 0.00

Repayment 0.00 0.00 0.00

Closing Balance 2,121.97 2,121.97

nterest 127.32 127.32 254.64

II

Opening Balance 2,121.97 2,121.97

Disbursement 0.00 0.00

Repayment 0.00 163.23 163.23

Closing Balance 2,121.97 1,958.74nterest 127.32 127.32 254.64

III



Repayment 163.23 163.23 326.46

Closing Balance 1,795.51 1,632.28

nterest 117.52 107.73 225.26

IV



Repayment 163.23 163.23 326.46

Closing Balance 1,469.06 1,305.83nterest 97.94 88.14 186.08

V



Repayment 163.23 163.23 326.46

Closing Balance 1,142.60 979.37

nterest 78.35 68.56 146.91

VI

Opening Balance 979.37 816.14


Repayment 163.23 163.23 326.46

Closing Balance 816.14 652.91

nterest 58.76 48.97 107.73

VII



Repayment 163.23 163.23 326.46

Closing Balance 489.69 326.46

nterest 39.17 29.38 68.56

VIII



Repayment 163.23 163.23 326.46Closing Balance 163.23 0.00


14/47

nterest 19.59 9.79 29.38

DSCR

I II III IV V VI VIIProfit after taxes 9.73 9.51 12.32 12.62 13.42 14.59 15.32

Add Depreciation 251.46 222.73 197.99 176.66 158.25 142.33 128.54

Add expenses W/off 5.00 5.00 5.00 5.00 5.00 0.00 0.00

Add Interest on Loan 254.64 254.64 225.26 186.08 146.91 107.73 68.56

Total 520.83 491.88 440.56 380.36 323.57 264.65 212.42

nterest 254.64 254.64 225.26 186.08 146.91 107.73 68.56

nstallment 0.00 163.23 326.46 326.46 326.46 326.46 326.46

Total 254.64 417.86 551.71 512.54 473.36 434.19 395.01

DSCR 2.05 1.18 0.80 0.74 0.68 0.61 0.54


15/47


16/47

VIII16.02

116.58

0.00 10.00

29.38 15.00

161.98 2796.25

29.38

326.46

355.84 3,395.15

0.46 0.82


17/47

Name - XYZ IndustriesESTIMATE OF PROFITABILITY OF PROPOSED PROJECT (Rs. In lacs)

Particulars I II III IV V VI VII VIII

(Proj.) (Proj) (Proj) (Proj) (Proj) (Proj) (Proj) (Proj)

Sales Revenue

Sales 9927.50 10920.25 11913.00 12905.75 13898.50 14891.25 15884.00 15884.00

Total Sales 9927.50 10920.25 11913.00 12905.75 13898.50 14891.25 15884.00 15884.00

Cost of Production :

Material consumption 4092.00 4633.20 5055.60 5478.00 5900.40 6322.80 6745.20 6758.40

Wages 1928.12 2120.93 2313.75 2506.56 2699.37 2892.18 3084.99 3084.99

Power & Fuel 2701.26 2971.39 3241.51 3511.64 3781.77 4051.89 4322.02 4322.02

Other direct expenses 5115.42 5626.97 6138.51 6650.05 7161.59 7673.13 8184.68 8184.68

13836.81 15352.49 16749.37 18146.25 19543.13 20940.01 22336.89 22350.09

Less : Stock Adjusted 90.75 9.08 9.08 9.08 9.08 9.08 9.08 0.00

Op.Stock of WIP - Rs. 0 90.75 99.83 108.91 117.98 127.06 136.13 145.21

Cl. Stock OF WIP- Rs. 90.75 99.83 108.91 117.98 127.06 136.13 145.21 145.21

Prime Cost 13746.05 15343.41 16740.29 18137.17 19534.05 20930.93 22327.82 22350.09

Administrative Expenses 256.27 281.90 307.53 333.15 358.78 384.41 410.03 410.03

Depreciation 251.46 222.73 197.99 176.66 158.25 142.33 128.54 116.58

Total Cost of Production 14253.79 15848.04 17245.81 18646.99 20051.08 21457.67 22866.39 22876.70

Less : Stock Adjusted 466.58 46.66 46.66 46.66 46.66 46.66 46.66 0.00

Op.Stock - Rs. 0 466.58 513.24 559.90 606.56 653.22 699.88 746.54

Cl. Stock - Rs. 466.58 513.24 559.90 606.56 653.22 699.88 746.54 746.54

Cost of Goods Sold 13787.20 15801.38 17199.15 18600.33 20004.42 21411.01 22819.73 22876.70

Gross Profit -3859.70 -4881.13 -5286.15 -5694.58 -6105.92 -6519.76 -6935.73 -6992.70

Selling & Admn. Expenses:

Selling & Distribution Exp. 185.45 204.00 222.54 241.09 259.63 278.18 296.72 296.72

Interest on Term Loan 254.64 254.64 225.26 186.08 146.91 107.73 68.56 29.38

Interest on Working Capital 107.33 118.06 128.79 139.52 150.26 160.99 171.72 171.72

Preliminary exp. Written off 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00

Total Cost of Sales 14339.62 16383.07 17780.73 19172.02 20566.21 21957.91 23356.73 23374.52

PBT 11.82 11.51 15.51 15.94 17.08 18.76 19.80 20.80

Total Net Profit Before Tax 11.82 11.51 15.51 15.94 17.08 18.76 19.80 20.80

Income Tax Liability 2.09 1.99 3.19 3.32 3.66 4.17 4.48 4.78

Net Profit After Tax 9.73 9.51 12.32 12.62 13.42 14.59 15.32 16.02

% of Net Profit to Sales 6.78 5.43 6.15 6.26 6.65 7.24 7.60 7.95


18/47

Profit before dep. , int. 23.13 22.51 25.70 24.94 24.94 25.54 25.54 25.54

Total Interest 6.39 6.69 6.41 5.68 4.94 4.20 3.47 2.73

Cash accruals 15.26 14.42 16.69 16.53 16.93 17.16 17.59 18.03


19/47

`

ROE

Return on own capital

0.49

ROCE

Return on capital employed

0.16


20/47


21/47

PROJECTED BALANCE SHEET

I II III IV V VI VII

(Proj.) (Proj) (Proj) (Proj) (Proj) (Proj) (Proj)

LIABILITIES :

(A) Opening Capital 20.00 29.74 39.25 51.57 64.19 77.61 92.20

Add: Profit/ (loss) f 9.73 9.51 12.32 12.62 13.42 14.59 15.32

Closing Balance 29.74 39.25 51.57 64.19 77.61 92.20 107.52

(B) Term Loan 40.00 36.92 30.77 24.62 18.46 12.31 6.15

(C) Working Capital Lo 12.69 15.16 17.33 17.39 17.39 17.39 17.39

(E) Unsecured Loan 0.00 0.00 0.00 0.00 0.00 0.00 0.00

(F) Creditors 4.20 4.90 5.60 5.60 5.60 5.60 5.60

(G) Other Current Liab. 0.00 0.00 0.00 0.00 0.00 0.00 0.00

TOTAL LIABILIT 86.63 96.23 105.27 111.80 119.06 127.50 136.67

ASSETS :

(A) Fixed Assets (Gros 51.95 51.95 51.95 51.95 51.95 51.95 51.95

Less : Depreciation 4.93 9.24 13.01 16.32 19.23 21.80 24.07

Net Block 47.02 42.71 38.94 35.63 32.72 30.15 27.88

(B) Investments 0.00 0.00 0.00 0.00 0.00 0.00 0.00

(C) Current Assets

- Inventory 12.14 14.17 16.19 16.19 16.19 16.19 16.19

- Loans & Advance 0.00 0.00 0.00 0.00 0.00 0.00 0.00

- Sundry Debtors 8.98 10.95 12.52 12.60 12.60 12.60 12.60

- Cash And Bank B 16.08 26.61 36.42 46.78 57.55 68.56 80.00

- Priliminary exp. n 2.40 1.80 1.20 0.60 0.00 0.00 0.00

TOTAL ASSETS 86.63 96.23 105.27 111.80 119.06 127.50 136.67

0.00 0.00 0.00 0.00 0.00 0.00 0.00

the cash balance is availble for replacement of plant and machinerires and for expansion purposes.


22/47

VIII

(Proj)

107.52

16.02

123.54

0.00

17.39

0.00

5.60

0.00

146.53

51.95

26.08

25.87

0.00

16.19

0.00

12.60

91.87

0.00

146.53

0.00


23/47

ASH FLOW STATEMENT

(Rs. in Lakhs)

ARTICULARS

0 I II III IV V VI VII V

OURCES OF FUNDS

Net Profit after Tax before , Dep. 0.00 15.26 14.42 16.69 16.53 16.93 17.16 17.59 18hare Capital 20.00 20.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

erm Loan 40.00 40.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

nsecured Loan 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

crease in WC Loan 12.69 2.47 2.17 0.06 0.00 0.00 0.00 0.00

OTAL FUNDS AVAILABLE 60.00 87.95 16.89 18.87 16.59 16.93 17.16 17.59 18.03

PPLICATION OF FUNDS

xed Assets 51.95 51.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00

e-op Exp 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

cre.in Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00cre.In Woking Capital 5.05 16.92 3.29 2.90 0.08 0.00 0.00 0.00 0.00

epayment of Term Loan 0.00 3.08 6.15 6.15 6.15 6.15 6.15 6.15

OTAL APPL. OF FUNDS 60.00 71.87 6.37 9.05 6.23 6.15 6.15 6.15 6.15

pening Balance of Cash 0.00 16.08 26.61 36.42 46.78 57.55 68.56 80.00

ash accrued during the year 16.08 10.52 9.81 10.36 10.77 11.01 11.44 11.88

osing Balance of Cash 16.08 26.61 36.42 46.78 57.55 68.56 80.00 91.87


24/47

Assessment of Working Capital Requirements

I II III IV V VI

A. CURRENT ASSETS

Stock-in-trade 12.14 14.17 16.19 16.19 16.19 16.19

Receivables 8.98 10.95 12.52 12.60 12.60 12.60

Advances 0.00 0.00 0.00 0.00 0.00 0.00

Cash and Bank 16.08 26.61 36.42 46.78 57.55 68.56

Other current assets

Total current assets 37.20 51.72 65.13 75.57 86.34 97.35

B. Current Liabilities

Sundry creditors 4.20 4.90 5.60 5.60 5.60 5.60

Statutory liablities 0.00 0.00 0.00 0.00 0.00 0.00

Other Current Liabilities 0.00 0.00 0.00 0.00 0.00 0.00

Total Current Liabilities 4.20 4.90 5.60 5.60 5.60 5.60

Current Assets 37.20 51.72 65.13 75.57 86.34 97.35

Less - Current Liabilities(Exluding Bank 4.20 4.90 5.60 5.60 5.60 5.60

Working Capital Gap 33.00 46.82 59.53 69.97 80.74 91.75Less - 25% of Total Current Asse 9.30 12.93 16.28 18.89 21.59 24.34

Permissible Bank Finance 23.70 33.89 43.25 51.07 59.16 67.41


25/47

VII VIII

16.19 16.19

12.60 12.60

0.00 0.00

80.00 91.87

108.79 120.66

5.60 5.60

0.00 0.00

0.00 0.00

5.60 5.60

108.79 120.66

5.60 5.60

103.19 115.0627.20 30.17

75.99 84.90


26/47

APPENDIX 17.11

Assessment of Working Capital Requirements

FORM II

OPERATING STATEMENT

Name - XYZ Industries

(Amount - RAs Per Profit & Loss AccountsActuals/estimates for the year ended/ending

I II III IV

1. GROSS SALES

I)Gross Sales 143.64 175.14 200.34 201.60

Total 143.64 175.14 200.34 201.60

percentage rise

(+) or fall ( - )

in Receipts as compared to previous year

ii) OTHER INCOME

a. Duty draw back 0.00 0.00 0.00 0.00

b. Insurance Claim 0.00 0.00 0.00 0.00

c. Commission & Brokerage received 0.00 0.00 0.00 0.00

d. Sub total (a+b+c) 0.00 0.00 0.00 0.00

iii) Total (I) + (ii) 143.64 175.14 200.34 201.60

2. COST OF SALES

(I) Consumption 95.76 116.76 133.56 134.40

(ii) Other Trading Expenses

(Carrige Inword, Commission

Brokerage on Purchases) 18.64 22.55 25.79 25.92

(iii) Sub Total (i+ii) 114.40 139.31 159.35 160.32(iv) Add - Opening Stock 0.00 6.30 7.35 8.40

(v) Sub Total (iii+iv) 114.40 145.61 166.70 168.72

(vi) Less Closing Stock 6.30 7.35 8.40 8.40

(vii) Sub-Total (Total Cost of Sales)(v-vi) 108.10 138.26 158.30 160.32

3. SELLING GENERAL &

ADMINISTRATIVE EXPENSES

(Including Bonus Payment) 11.81 13.78 15.74 15.74

4. OPERATING PROFIT

(Before intrerst & Depreciation)

[1(iii) - 2 (vii) - 3 ] 23.73 23.11 26.30 25.54

5. INTEREST on working capital 1.59 1.89 2.17 2.17

on term loan 4.80 4.80 4.25 3.51

6. DEPRECIATION 4.93 4.31 3.77 3.31


27/47

7. OPERATING PROFIT

(after interest & depreciation)

(4-5-6) 12.42 12.11 16.11 16.54

8. (i) Add : Other non Operating Income 0.00 0.00 0.00 0.00

a.C & A Commission 0.00 0.00 0.00 0.00

b. Interest 0.00 0.00 0.00 0.00c. Discount 0.00 0.00 0.00 0.00

d. Sub - Total (INCOME) 0.00 0.00 0.00 0.00

(ii) Less - Non operating Expenses 0.60 0.60 0.60 0.60

a. 0.00 0.00 0.00 0.00

b. 0.00 0.00 0.00 0.00

c. Sub - Total (EXPENSES) 0.00 0.00 0.00 0.00

(iii) Net of other Non operating 0.00 0.00 0.00 0.00

Income /expenses [Net of 0.00 0.00 0.00 0.00

8(I) & 8 (ii) 0.00 0.00 0.00 0.00

09. PROFIT/(LOSS) BEFORE TAX [7+8(iii)] 11.82 11.51 15.51 15.94

10. PROVISION FOR TAXES 2.09 1.99 3.19 3.32

11. NET PROFIT/(LOSS) (9-10) 9.73 9.51 12.32 12.62

12. (a) Equity Dividend paid ** 0.00 1.00 2.00 3.00

(b) Dividend Rate 0% 100% 200% 300%

13. RETAINED PROFIT 9.73 8.51 10.32 9.62

14. RETAINED PROFIT/NET PROFIT 100% 89% 84% 76%

( %AGE ) (13 - 11)

ADDITIONAL DATA

Break-up of Sales Turnover

(inclusiv of other income)a. Domestic Sales

1st Quarter 0.00 0.00 0.00 0.00

2nd Quarter 0.00 0.00 0.00 0.00

3rd Quarter 0.00 0.00 0.00 0.00

4th Quarter 0.00 0.00 0.00 0.00

Sub Total 0.00 0.00 0.00 0.00

b. Expotr sales

1st Quarter 0.00 0.00 0.00 0.00

2nd Quarter 0.00 0.00 0.00 0.00

3rd Quarter 0.00 0.00 0.00 0.00

4th Quarter 0.00 0.00 0.00 0.00

Sub Total 0.00 0.00 0.00 0.00

Total (a + b)

[To agree with 1 (iii)] 0.00 0.00 0.00 0.00


28/47

APPENDIX 1/.IV

Assessment in working Capital Requirements

FORM - III

Analysis Of Balance Sheet

Name - XYZ Industries(Amount -

As Per Profit & Loss AccountsActuals/estimates for the year ended/ending

I II III IV

CURRENT LIABILITIES

1. Short term borrowings from banks(incldg.

bills purchased, discounted & excess

borowings palace on repayment basis)

(a) from applicant bank (CC Limit) 12.69 15.16 17.33 17.39

Against Bank FDR 0.00 0.00 0.00 0.00

(b) from other banks 0.00 0.00 0.00 0.00

(c) ( of which BP & BD)

sub - total (A) 12.69 15.16 17.33 17.39

2. Short term borrowings from others 0.00 0.00 0.00 0.00

3. Sundry Creditors (Trade)

( month's purchases) 4.20 4.90 5.60 5.60

4. Advance payments from customers

/deposits from dealers 0.00 0.00 0.00 0.00

5. Provision for taxation 0.00 0.00 0.00 0.00

6. Dividend Payable 0.00 0.00 0.00 0.00

7. Other statutory liabilities(due within one year) 0.00 0.00 0.00 0.00

8. Deposits/ Debentures/ Instalments

under term loan/ DPGs, etc.

(due within one year) 0.00 0.00 0.00 0.00

9. Other current liabilities & provisions

(due within one year) 0.00 0.00 0.00 0.00

(specify major items)

sub - total (B) 4.20 4.90 5.60 5.60

10. Total Current liabilities ( total of 1 to 9) 16.89 20.06 22.93 22.99

TERM LIABILITIES

11.Debentures(not maturing within one ye 0.00 0.00 0.00 0.00

12.Prefereance shares ( redeemable after

one year) 0.00 0.00 0.00 0.00

13.Term loan (excluding instalment payable

within one year)(Unsecured Loans) 40.00 36.92 30.77 24.62


29/47

14. Deferred Payment Credits

(excluding instalment due

within one year) 0.00 0.00 0.00 0.00

15. Term loan (repayable after one year) 0.00 0.00 0.00 0.00

16. Other term liabilities 0.00 0.00 0.00 0.0017. Total term liabilities 40.00 36.92 30.77 24.62

18. Total outside liabilities (10 + 17) 56.89 56.98 53.70 47.61

NET WORTH

19. Share Capital 20.00 29.74 39.25 51.57

20. General Reserve 0.00 0.00 0.00 0.00

21. Revaluation Reserve 0.00 0.00 0.00 0.00

22. Other reserve ( excluding Provision) 0.00 0.00 0.00 0.00

23. Surplus (+) or deficit ( - ) in 0.00 0.00 0.00 0.00

Profit & Loss Account) 9.73 9.51 12.32 12.62

24. Net Worth 29.74 39.25 51.57 64.19

25. Total Liabilities (18 + 24) 86.62 96.24 105.27 111.80

CURRENT ASSETS

26. Cash & Bank Balance 16.08 26.61 36.42 46.78

27. Investments

(Other then long term Investments)

( I ) Governmrnts & other Trustees

Securities) 0.00 0.00 0.00 0.00

( ii ) Fixed deposite with banks 0.00 0.00 0.00 0.00

28. ( I ) Receivable other then deferred &

Exports (Including bills purchased

& discounted by bankers(Month's domestic Sales) 8.98 10.95 12.52 12.60

( ii )Export receivables

Exports (Including bills purchased

& discounted by bankers

(Month's domestic Sales) 0.00 0.00 0.00 0.00

29. Instalments under deferred receivables

( due within one year) 0.00 0.00 0.00 0.00

30. Stock-in-trade (Month's cost of sales) 12.14 14.17 16.19 16.19

31. Advances to suppliers of merchandise 0.00 0.00 0.00 0.00

32. Advances payment of taxes 0.00 0.00 0.00 0.00

33. Other current Assets

(Specify major Items) 0.00 0.00 0.00 0.00

34. Total Current Assets (Total of 26 to 33) 37.20 51.72 65.13 75.57

FIXED ASSETS

35. Gross Block(Land & Building machinery

furniture & fitings vehicles) 51.95 47.02 42.71 38.94

36. Depreciation to date 4.93 4.31 3.77 3.31


30/47

37. Net Block (35-36) 47.02 42.71 38.94 35.63

OTHER NON CURRENT ASSETS

38. Investments/book debt/advances/

deposites which are not Current Assets

( I ) (a) Investments in subsidiarycompany/affiliates 0.00 0.00 0.00 0.00

(b) Others 0.00 0.00 0.00 0.00

( ii ) Advances to suppliers of Capital

goods & contractors 0.00 0.00 0.00 0.00

( iii ) Deferred receivables (Maturity

exceeding one year) 0.00 0.00 0.00 0.00

( iv ) Security deposit/tender deposits 0.00 0.00 0.00 0.00

( v ) Others 0.00 0.00 0.00 0.00

39. Obsolete Stocks 0.00 0.00 0.00 0.00

40. Other non-current assets

(Including dues from directors) 0.00 0.00 0.00 0.00

41. Total other non-current assets

(Total of 38 to 40) 0.00 0.00 0.00 0.00

42. Intangible assets (Patents, Goodwill,

preliminary expenses, bad/doubtful

debts not provided for, etc. 2.40 1.80 1.20 0.60

43. Total Assets( Total of 34,37,41 & 42) 86.63 96.23 105.27 111.80

44. Tangible Net Worth (24 - 42) 27.34 37.45 50.37 63.59

45. Net working Capital

[(17+24) - (37+41+42)]

To tally with (34 -10 ) 20.31 31.66 42.20 52.5746. Current Ratio (34 - 10) 2.20 2.58 2.84 3.29

47. Total outside Libilities/ tangiable

net worth ( 18 / 44) 2.08 1.52 1.07 0.75

ADDITIONAL INFORMATION

(A) Arrears of Depreciation 0.00 0.00 0.00 0.00

(B) Contingent liabilities :

(a) Arrears of cumulative dividends)

(b) Gratuity liability not provided for 0.00 0.00 0.00 0.00

(c) Disputed excise/customs/tax

liabilities 0.00 0.00 0.00 0.00

(d) Bills accepted/guarantees extended

to accommodate associate/sister

concerns or other third parties 0.00 0.00 0.00 0.00

(e) Other liabilities not provided for 0.00 0.00 0.00 0.00


31/47

APPENDIX 1/.IV

Assessment in Working Capital RequirementsFORM - IV

Comparative Statement of Current Assets and Current Liabilitie


I II III IV

A. CURRENT ASSETS

1) Stock-in-trade

(month's cost of sales) 12.14 14.17 16.19 16.19

2) Receivables other

then export and deferr

ed receivables (inclu-

ding bills purchased

and discounted by

bankers)

(month's domestics -

Sales) 8.98 10.95 12.52 12.60

3) Export receivable

(including bills purch-

ased and discounted)

(Month's export Sales) 0.00 0.00 0.00 0.00

4) Advances to supp-liers of merchandies 0.00 0.00 0.00 0.00

5)Other current assets

(including cash &

Bank balances &

diferred receivables

due with in one year )

(specify major items) 16.08 26.61 36.42 46.78

6)Total current assets

(To agree with item 34

in From III) 37.20 51.72 65.13 75.57

B. Current Liabilities

(Other then bank

borrowings for working

capital )

7) Sundry creditors

(Trade)


32/47

(Month's Purchases) 4.20 4.90 5.60 5.60

8) Advance payments

from customers/

deposits from dealers 0.00 0.00 0.00 0.00

9) Statutory liablities 0.00 0.00 0.00 0.00

10) Other Currentliabilities (Specify

major items such as

short term borrowing,

unsecured loans,

dividend payable,

instalments of TL ,

DPG, Public deposits

debentures etc.) 0.00 0.00 0.00 0.00

11) Total

(To agree with sub-

total B-Form III) 4.20 4.90 5.60 5.60

4.20 4.90 5.60 5.60

Current Assets 37.20 51.72 65.13 75.57

Less - Current Liabilities(Exluding Bank fin) 4.20 4.90 5.60 5.60

Working Capital Gap 33.00 46.81 59.53 69.97

Less - 25% of Total Current Assets 9.30 12.93 16.28 18.89

Permissible Bank Finance 23.70 33.88 43.25 51.07

APPENDIX 17.V

Assessment in Working Capital Requirements

FORM - V

Computation of Maximum Permissible Bank Finance for Working Ca

Name - XYZ IndustriesI II III IV

01. Total current Assets (34 of form III ) 37.20 51.72 65.13 75.57

02. Current Liabilities (2 to 9 of form III )

Other then bank borrowings) 4.20 4.90 5.60 5.60


33/47

03. Working Capital Gap (WCG) (1 - 2) 33.00 46.81 59.53 69.97

04. Min. stipulated Net Working Capital

25% of total current assets other then

Export Receivables

[ as at 28 (ii) of form III] 9.30 12.93 16.28 18.89

05. Actual/projected net working capital(45 of form III) 20.31 31.66 42.20 52.57

06. Item 3 minus item 4 23.70 33.88 43.25 51.07

07. Item 3 minus item 5 12.69 15.16 17.33 17.39

08. Maximum permissible bank finance

(Item 6 or 7, which ever is lower) 12.69 15.16 17.33 17.39

09.Excess borrowings, if any representing

shortfall in NWC (4 - 5) 0.00 0.00 0.00 0.00


34/47

APPENDIX 17.VI

Assessment in Working Capital Requirements

FORM - VI


I II III IV

1. Sources

a) Net Profit (after tax) 9.73 9.51 12.32 12.62

b) Depreciation 4.93 4.31 3.77 3.31

c) Increase in capital 20.00 0.00 0.00 0.00

d) Increase in term Liabilities (Includings Public

deposits) 40.00 0.00 0.00 0.00

e) Decrease in

I) Fixed Assets 0.00 0.00 0.00 0.00

ii) Other non-current assets 0.60 0.60 0.60 0.60

f) Others

g) Total 75.26 14.42 16.69 16.53

2. Uses

a) Net Loss 0.00 0.00 0.00 0.00

b) Decrease in Term Liabilities

(including public deposits) 0.00 3.08 6.15 6.15

c) Increase in :

I) Fixed Assets 51.95 0.00 0.00 0.00

ii) Other non-current assets 3.00 0.00 0.00 0.00

d) Dividend payments 0.00 0.00 0.00 0.00

e) Others 0.00 0.00 0.00 0.00f) Total 54.95 3.08 6.15 6.15

3. Long Tern Surplus (+)/Deficit ( - ) (1 - 2) 20.31 11.34 10.54 10.38

4. Increase/decrease in current assets

*(as per details given below) 37.20 14.51 13.41 10.44

5. Increase/decrease in current liabilities

Other then bank borrowings 4.20 0.70 0.70 0.00

6. Increase/decrease in working capital gap 33.00 13.81 12.72 10.44

7. Net Surplus ( + )/deficit 9 ( - )

(Difference of 3 & 6 ) -12.69 -2.47 -2.17 -0.06

8. Increase/decrease in Bank borrowings 12.69 2.47 2.17 0.06

INCREASE/DECREASE IN NET SALES

I). Increase/decrease in stock-in-trade 0.00 0.00 2.02 2.02

ii). Increase/decrease in Receivables

(a) Domestic 0.00 0.00 1.97 1.58

(b) Exports


35/47

s. In lacs)

V

201.60

201.60

0.000.00

0.00

0.00

201.60

134.40

25.92

160.328.40

168.72

8.40

160.32

15.74

25.54

2.17

2.77

2.91


36/47

17.68

0.00

0.00

0.000.00

0.00

0.60

0.00

0.00

0.00

0.00

0.00

0.00

17.08

3.66

13.42

4.00

400%

9.42

70%

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00


37/47

s. In lacs

V

17.39

0.00

0.00

17.39

0.00

5.60

0.00

0.00

0.00

0.00

0.00

0.00

5.60

22.99

0.00

0.00

18.46


38/47

0.00

0.00

0.0018.46

41.45

64.19

0.00

0.00

0.00

0.00

13.42

77.61

119.06

57.55

0.00

0.00

12.60

0.00

0.00

16.19

0.00

0.00

0.00

86.34

35.63

2.91


39/47

32.72

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

119.06

77.61

63.353.76

0.53

0.00

0.00

0.00

0.00

0.00


40/47

V

16.19

12.60

0.00

0.00

57.55

86.34


41/47

5.60

0.00

0.00

0.00

5.60

5.60

86.34

5.60

80.74

21.59

59.16

ital

V

86.34

5.60


42/47

80.74

21.59

63.35

59.16

17.39

17.39

0.00


43/47

V

13.42

2.91

0.00

0.00

0.00

0.60

16.93

0.00

6.15

0.00

0.00

0.00

0.006.15

10.77

10.77

0.00

10.77

0.00

0.00

0.00

0.08


44/47

APPENDIX 17.1

FORM - I

Particular of the Existing/Proposed Limits from the Banking System

(Limits from all Banks & Financial Institutions as on date of application)S. No. Name of Bank/ Nature of Exisiting Extent to which limiBalance Limits now

Financial Institutionfacility Limits were utilised duringOut Standin requested

the last 12 Months As on date

Max. Min.

A. WORKING CAPITAL LIMITS

1 C.C A/c 0.00 0.00 12.69

S.No. Name of Bank/ Sanctioned LimitOut Standing OverduesRemarks

Financial Institutions As on if any

B. TERM LOANS 0.00 0.00 0.00

(excluding working capital term loans)

ANNEXURE TO FORM 1

INFORMATION ON ASSOCIATE COMPANIES

(Companies/firms/concerns in which directors/partners/proprietor and / or their family members of the borrower

company is/are associated with the other unit as director/partners/proprietor or has/have furnished guarantees)

(Amount - Rs. In lacs)

S.No. Name of Line of Annual Limits from all Banks and Financial Institutions

the asso- Activity make up

ciates co. of accounName of Working Capital Term DGP Over

(Date of Banks/ loan dues

Balance Financial Fund Non fund if any

Sheet) Institutionbase base

1 2 3 4 5 6 7 8 9 10

None None None None No

None None None None No


45/47


46/47


47/47

nepa projection amit

Documents