SAIL by kareshruti

VIEWS: 50 PAGES: 41

IT CONTAINS THE FUTURE OF STEEL AUTHORITY OF INDIA LIMITED

More Info
									                                             M/s XYZ Industries


Cost of Project & Means of Finance
                                                                                      (Amount in crores)
Cost of Project

       S. No.                  Particulars                                             Proposed
                                                                                        Amount

                    1 Land                                                                   0.50
                    2 Building:
                          Factory Building                                    0.30
                          Auxilliary Building                                 0.20           0.50
                    3 Plant &Machinery                                                       6.10
                    4 Misc.Fixed Assets                                                      2.00
                    5 Electric Installation                                                  0.90
                    6 Preoperative Expenses                                                  0.25
                    7 Preliminary Expenses                                                   0.25
                    8 Contingencies                                                          1.05
                    9 Working capital Margin                                                 0.45

                                   Total                                                    12.00

Means of Finance

       S. No.                  Particulars

                    1 Own Capital:
                               Equity Capital                                 4.00
                              Unsecured Loan                                  0.00           4.00
                    2 Debts:
                               Term Loan                                      8.00           8.00


                                   Total                                                    12.00


Capitalisation of contingencies and Electric Installation in their respective Ratios

                        Building                       Plant & Machinery Total
Balance                                         0.50                 6.10      6.60
Contingencies                                   0.38                 4.58      4.95
Electric Installation                           0.76                 9.24    10.00
Total                                           1.63                19.92    21.55
(Amount in crores)




                        2009-2010


                            10.72



                            17.65
                             69.2
                              33
               10.00        17.43


                              10
                11.05
                              0.5
                                M/s XYZ Industries

ASSUMPTIONS:
1. Number of Working Days in a year        300

                                                   I         II         III        IV         V          VI
Calculation of Sales

Capacity Utilisation                      100%    60%        70%        80%        80%        80%        80%

Units (produced)                         600000   360000     420000     480000     480000     480000     480000
Opening stock                                          0      18000      21000      24000      24000      24000
Closing Stock (15 days)             15             18000      21000      24000      24000      24000      24000

Units available fior sale                         342000     417000     477000     480000     480000     480000

Sale Price Rs. per unit                     15          15         15         15         15         15         15

Sales (Rs. In lakhs)                               51.30      62.55      71.55       72.00     72.00      72.00

Purchase of Raw Material
Units Produced ( Finished Goods)                  360000     420000     480000     480000     480000     480000
4 Mts cloth required for each garment         1   360000     420000     480000     480000     480000     480000
Rate of cloth Rs. per Metre                5.75
Purchase (Rs. In lakhs)                            20.70      24.15      27.60       27.60     27.60      27.60

Closing Stock of Raw Material
Metres
15 days closing ( metres)                          18000     21000       24000      24000     24000       24000
Rate of cloth per Metre                    5.75      1.04      1.21        1.38       1.38      1.38        1.38
Consumption for the year

Meters
Opening Stock                                        0.00     18000      21000      24000      24000      24000
Add: Purchase                                     360000     420000     480000     480000     480000     480000
Less: Closing Stock                                18000      21000      24000      24000      24000      24000

Consumption (in metres)                           342000     417000     477000     480000     480000     480000

Consumption

Meters
Opening Stock                                       0.00       1.04       1.21        1.38      1.38       1.38
Add: Purchase                                      20.70      24.15      27.60       27.60     27.60      27.60
Less: Closing Stock                                 1.04       1.21       1.38        1.38      1.38       1.38

Consumption (in Rs. lakhs)                         19.67      23.98      27.43       27.60     27.60      27.60

Calculation of Work in Process

Production of Finished Goods                      360000     420000     480000     480000     480000     480000
Prime Cost Per Unit                                     11.9      11.9      11.9            11.9        11.9        11.9
Closing stock of WIP Rs. In lakhs (2 Days)              0.29      0.33      0.38            0.38        0.38        0.38


Calculation of Finished Goods

Units produced                           Days         360000    420000    480000         480000      480000      480000
Cost of production                                       12.4      12.4      12.4           12.4        12.4        12.4
Closing stock of Finished Goods                 15       2.23      2.60      2.98           2.98        2.98        2.98
(Rs. In lakhs)

Calculation of Wages

Units                                                 360000    420000    480000         480000      480000      480000
Wages (Rs. 10 unit )                         4.15       14.94     17.43     19.92          19.92       19.92       19.92

Calculation of Power and Fuel

Units                                                 360000    420000    480000         480000      480000      480000
Power & Fuel (Rs. 6 per Unit)                    1       3.60      4.20      4.80           4.80        4.80        4.80

Calculation of Other Direct Expenses

Units                                                 360000    420000    480000         480000      480000      480000
Other Direct Expenses (Rs. 8 per Unit)           1       3.60      4.20      4.80           4.80        4.80        4.80

Calculation of Administrative Expenss

Units                                                 360000    420000    480000         480000      480000      480000
Administrative Expenses (Rs. 10 unit )          0.5      1.80      2.10      2.40           2.40        2.40        2.40

Calculation of Selling Expenss

Units                                                 360000    420000    480000         480000      480000      480000
Selling Expenses                                0.6      2.16      2.52      2.88           2.88        2.88        2.88

Cost Sheet per unit of garment:
Material Consumed            Mts.            5.75          1      5.75
Direct expenses:Power        Units              1          1         1
Wages                                                             4.15              120000 garments in 300 days = 400 garments
Other Direct Expenses                                                1              = Rs. 4000 per day for 400 garments = Rs. 10
Prime Cost                                                        11.9
Add Administrative expenses                                        0.5
Cost of production                                                12.4
Selling expenses                                                   0.6
Cost of sales                                                       13
Profit                                                               2
Selling price                                                       15
Calculation of Depreciation
Depreciation is calculated according to WDV Method
Land
Particulars                                        I      II      III     IV      V       VI

Op Balance                                       0.00    0.50    0.50    0.50    0.50    0.50
Addition                                         0.50    0.00    0.00    0.00    0.00    0.00
Deduction                                        0.00    0.00    0.00    0.00    0.00    0.00
Gross Block                                      0.50    0.50    0.50    0.50    0.50    0.50
Less: Dep                                        0.00    0.00    0.00    0.00    0.00    0.00
Net Block                                        0.50    0.50    0.50    0.50    0.50    0.50
Depreciation - %                                 0.00    0.00    0.00    0.00    0.00    0.00
Depreciation - Rs.                               0.00    0.00    0.00    0.00    0.00    0.00
Building
Particulars                                        I      II      III     IV      V       VI

Op Balance                                       0.00    1.55    1.47    1.40    1.33    1.26
Addition                                         1.63    0.00    0.00    0.00    0.00    0.00
Deduction                                        0.00    0.00    0.00    0.00    0.00    0.00
Gross Block                                      1.63    1.55    1.47    1.40    1.33    1.26
Less: Dep                                        0.08    0.08    0.07    0.07    0.07    0.06
Net Block                                        1.55    1.47    1.40    1.33    1.26    1.20
Depreciation - %                                 5.00    5.00    5.00    5.00    5.00    5.00
Depreciation - Rs.                               0.08    0.08    0.07    0.07    0.07    0.06

Plant & Machinery
Particulars                                        I      II      III     IV      V       VI

Op Balance                                        0.00   16.93   14.39   12.23   10.40    8.84
Addition                                         19.92    0.00    0.00    0.00    0.00    0.00
Deduction                                         0.00    0.00    0.00    0.00    0.00    0.00
Gross Block                                      19.92   16.93   14.39   12.23   10.40    8.84
Less: Dep                                         2.99    2.54    2.16    1.83    1.56    1.33
Net Block                                        16.93   14.39   12.23   10.40    8.84    7.51
Depreciation - %                                 15.00   15.00   15.00   15.00   15.00   15.00
Depreciation - Rs.                                2.99    2.54    2.16    1.83    1.56    1.33

Furniture & Fixtures
Particulars                                        I      II      III     IV      V       VI

Op Balance                                        0.00    1.80    1.62    1.46    1.31    1.18
Addition                                          2.00    0.00    0.00    0.00    0.00    0.00
Deduction                                         0.00    0.00    0.00    0.00    0.00    0.00
Gross Block                                       2.00    1.80    1.62    1.46    1.31    1.18
Less: Dep                                         0.20    0.18    0.16    0.15    0.13    0.12
Net Block                                         1.80    1.62    1.46    1.31    1.18    1.06
Depreciation - %                                 10.00   10.00   10.00   10.00   10.00   10.00
Depreciation - Rs.                                0.20    0.18    0.16    0.15    0.13    0.12

Total Dep.                                        3.27    2.80    2.39    2.05    1.76    1.51
Total Op. Balance                                 0.00   20.28   17.48   15.09   13.04   11.28
Total Additions                                  24.05    0.00    0.00    0.00    0.00    0.00
Closing Balance                             20.78     17.98     15.59     13.54      11.78     10.27

Calculation of Creditors

Purchase                                      20.70     24.15     27.60      27.60     27.60     27.60
Months                                          0.5       0.5       0.5        0.5       0.5       0.5
Creditors (Rs. In lakhs)                       0.86      1.01      1.15       1.15      1.15      1.15



Calculation of Debtors (on sales)

Sales                                         51.30     62.55     71.55      72.00     72.00     72.00
Months                                         0.75      0.75      0.75       0.75      0.75      0.75
Debtors (Rs. In lakhs)                         3.21      3.91      4.47       4.50      4.50      4.50


Total Inventory
Raw Material                                  1.04      1.21       1.38      1.38      1.38       1.38
Work in Process                               0.29      0.33       0.38      0.38      0.38       0.38
Finished Goods                                2.23      2.60       2.98      2.98      2.98       2.98
Inventory                                     3.55      4.14       4.74      4.74      4.74       4.74
Add Debtors                                   3.21      3.91       4.47      4.50      4.50       4.50
Total Current Assets                          6.76      8.05       9.21      9.24      9.24       9.24
Less Creditors                                0.86      1.01       1.15      1.15      1.15       1.15
Working Capital                               5.90      7.05       8.06      8.09      8.09       8.09
Margin for Working Capital                    1.47      1.76       2.01      2.02      2.02       2.02

Working Capital Loan                           4.42      5.29      6.04       6.07      6.07      6.07



Interest @ 12.5%                    12.5%      0.55      0.66      0.76       0.76      0.76      0.76
 VII        VIII


80%         80%

480000      480000
 24000       24000
 24000       24000

480000      480000

       15          15

 72.00        72.00


480000      480000
480000      480000

 27.60        27.60



24000        24000
  1.38         1.38



 24000       24000
480000      480000
 24000       24000

480000      480000




  1.38         1.38
 27.60        27.60
  1.38         1.38

 27.60        27.60



480000      480000
       11.9        11.9
       0.38        0.38




    480000       480000
       12.4         12.4
       2.98         2.98




    480000       480000
      19.92        19.92



    480000       480000
       4.80         4.80



    480000       480000
       4.80         4.80



    480000       480000
       2.40         2.40



    480000       480000
       2.88         2.88




0 garments/day, 8 employees @ Rs. 500/day
ts = Rs. 10/ garment
VII     VIII

0.50    0.50
0.00    0.00
0.00    0.00
0.50    0.50
0.00    0.00
0.50    0.50
0.00    0.00
0.00    0.00

VII     VIII

1.20    1.14
0.00    0.00
0.00    0.00
1.20    1.14
0.06    0.06
1.14    1.08
5.00    5.00
0.06    0.06


VII     VIII

 7.51    6.39
 0.00    0.00
 0.00    0.00
 7.51    6.39
 1.13    0.96
 6.39    5.43
15.00   15.00
 1.13    0.96


VII     VIII

 1.06    0.96
 0.00    0.00
 0.00    0.00
 1.06    0.96
 0.11    0.10
 0.96    0.86
10.00   10.00
 0.11    0.10

1.29    1.11
9.77    8.48
0.00    0.00
8.98    7.87



27.60     27.60
  0.5       0.5
 1.15      1.15




72.00     72.00
 0.75      0.75
 4.50      4.50



 1.38      1.38
 0.38      0.38
 2.98      2.98
 4.74      4.74
 4.50      4.50
 9.24      9.24
 1.15      1.15
 8.09      8.09
 2.02      2.02

 6.07      6.07



 0.76      0.76
TERM LOAN                8.00 LACS                        0.615385

                          12%

          I       I Half Year   II Half Year   Total


Opening Balance          0.00          8.00
Disbursement             8.00          0.00
Repayment                0.00          0.00        0.00
Closing Balance          8.00          8.00
Interest                 0.48          0.48        0.96
           II
Opening Balance          8.00          8.00
Disbursement             0.00          0.00
Repayment                0.00          0.62        0.62
Closing Balance          8.00          7.38
Interest                 0.48          0.48        0.96
          III
Opening Balance          7.38          6.77
Disbursement             0.00          0.00
Repayment                0.62          0.62        1.23
Closing Balance          6.77          6.15
Interest                 0.44          0.41        0.85
          IV
Opening Balance          6.15          5.54
Disbursement             0.00          0.00
Repayment                0.62          0.62        1.23
Closing Balance          5.54          4.92
Interest                 0.37          0.33        0.70
           V
Opening Balance          4.92          4.31
Disbursement             0.00          0.00
Repayment                0.62          0.62        1.23
Closing Balance          4.31          3.69
Interest                 0.30          0.26        0.55
VI
Opening Balance          3.69          3.08
Disbursement             0.00          0.00
Repayment                0.62          0.62        1.23
Closing Balance          3.08          2.46
Interest                 0.22          0.18        0.41
VII
Opening Balance          2.46          1.85
Disbursement             0.00          0.00
Repayment                0.62          0.62        1.23
Closing Balance          1.85          1.23
Interest                 0.15          0.11        0.26
VIII
Opening Balance          1.23          0.62
Disbursement             0.00          0.00
Repayment                0.62          0.62        1.23
Closing Balance          0.62          0.00
Interest                 0.07          0.04        0.11
DSCR
                         I      II    III    IV     V      VI     VII
Profit after taxes     3.68   4.28   5.41   5.65   5.96   6.31   6.56
Add Depreciation       3.27   2.80   2.39   2.05   1.76   1.51   1.29
Add Interest on Loan   0.96   0.96   0.85   0.70   0.55   0.41   0.26
Total                  7.91   8.03   8.65   8.40   8.27   8.22   8.11

Interest               0.96   0.96   0.85   0.70   0.55   0.41   0.26
Installment            0.00   0.62   1.23   1.23   1.23   1.23   1.23
Total                  0.96   1.58   2.08   1.93   1.78   1.64   1.49

DSCR                   8.24   5.10   4.16   4.35   4.64   5.02   5.45
VIII
6.79
1.11
0.11
8.02    65.63

0.11
1.23
1.34    12.80

5.97   5.13
                                         Name - XYZ Industries
ESTIMATE 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                          51.30      62.55    71.55    72.00    72.00       72.00        72.00    72.00

Total Sales                     51.3      62.55    71.55     72       72           72          72       72

Cost of Production :
Material consumption           19.67      23.98    27.43    27.60    27.60       27.60        27.60    27.60
Wages                          14.94      17.43    19.92    19.92    19.92       19.92        19.92    19.92
Power & Fuel                    3.60      4.20     4.80     4.80     4.80        4.80          4.80    4.80
Other direct expenses           3.60      4.20     4.80     4.80     4.80        4.80          4.80    4.80

                               41.81      49.81    56.95    57.12    57.12       57.12        57.12    57.12
Less : Stock Adjusted           0.29      0.05     0.05     0.00     0.00        0.00          0.00    0.00

Op.Stock of WIP - Rs.            0         0.29     0.33    0.38     0.38         0.38        0.38     0.38
Cl. Stock OF WIP- Rs.           0.29       0.33     0.38    0.38     0.38         0.38        0.38     0.38

Prime Cost                     41.52      49.76    56.90    57.12    57.12       57.12        57.12    57.12

Administrative Expenses         1.80       2.10     2.40    2.40     2.40         2.40        2.40     2.40
Depreciation                    3.27       2.80     2.39    2.05     1.76         1.51        1.29     1.11

Total Cost of Production       46.59      54.66    61.69    61.57    61.28       61.03        60.81    60.63

Less : Stock Adjusted          2.232      0.372    0.372      0        0           0            0        0

Op.Stock - Rs.                   0         2.23     2.60    2.98     2.98         2.98        2.98     2.98
Cl. Stock - Rs.                 2.23       2.60     2.98    2.98     2.98         2.98        2.98     2.98

Cost of Goods Sold             44.36      54.28    61.32    61.57    61.28       61.03        60.81    60.63

Gross Profit                    6.94       8.27    10.23    10.43    10.72       10.97        11.19    11.37

Selling & Admn. Expenses:

Selling & Distribution Exp.      2.16     2.52     2.88     2.88     2.88        2.88         2.88     2.88
Interest on Term Loan            0.96     0.96     0.85     0.70     0.55        0.41         0.26     0.11
                                 Loan
Interest on Working Capital Term 0.55     0.66     0.76     0.76     0.76        0.76         0.76     0.76
Preliminary exp. Written off     0.10     0.10     0.10     0.10     0.10        0.00         0.00     0.00

Total Cost of Sales            48.13      58.53    65.91    66.01    65.57       65.07        64.71    64.38

PBT                             3.17      4.02      5.64    5.99     6.43         6.93        7.29     7.62
Total Net Profit Before Tax     3.17      4.02      5.64    5.99     6.43         6.93        7.29     7.62
Income Tax Liability           -0.51      -0.25     0.23    0.34     0.47         0.62        0.73     0.83
Net Profit After Tax            3.68      4.28      5.41    5.65     5.96         6.31        6.56     6.79
% of Net Profit to Sales        7.17      6.84      7.56    7.85     8.28         8.76        9.12     9.44
Profit before dep. , int. and tax   7.95    8.44    9.64    9.50    9.50    9.60    9.60    9.60
Total Interest                      1.51    1.62    1.60    1.46    1.31    1.16    1.02    0.87
Cash accruals                        6.95    7.07    7.80    7.70    7.72    7.82    7.86    7.90
ROE
Return on own capital
   0.92
ROCE
Return on capital employed
   0.31
PROJECTED BALANCE SHEET


                               I           II         III         IV           V          VI          VII
                            (Proj.)      (Proj)      (Proj)      (Proj)      (Proj)      (Proj)      (Proj)
LIABILITIES :

(A) Opening Capital               4.00       7.68       11.96       17.37       23.02       28.98       35.29
                                  3.68
    Add: Profit/ (loss) for the year         4.28        5.41        5.65        5.96        6.31        6.56
    Closing Balance               7.68      11.96       17.37       23.02       28.98       35.29       41.85

(B) Term Loan                   8.00         7.38        6.15        4.92        3.69        2.46        1.23

(C) Working Capital Loan         4.42         5.29        6.04        6.07        6.07        6.07        6.07

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

(F) Creditors                    0.86         1.01        1.15        1.15        1.15        1.15        1.15

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

   TOTAL LIABILITIES            20.96       25.63       30.71       35.16       39.89       44.97       50.30

ASSETS :

(A) Fixed Assets (Gross)        24.05       24.05       24.05       24.05       24.05       24.05       24.05
    Less : Depreciation          3.27        6.07        8.46       10.51       12.27       13.78       15.07
    Net Block                   20.78       17.98       15.59       13.54       11.78       10.27        8.98

(B) Investments                  0.00         0.00        0.00        0.00        0.00        0.00        0.00

(C) Current Assets
    - Inventory                  3.55        4.14        4.74        4.74        4.74        4.74        4.74
    - Loans & Advances           0.00        0.00        0.00        0.00        0.00        0.00        0.00
    - Sundry Debtors             3.21        3.91        4.47        4.50        4.50        4.50        4.50
    - Cash And Bank Balances 6.02           12.30       18.72       25.28       31.87       38.46       45.08
                                 0.40
    - Priliminary exp. not written off       0.30        0.20        0.10        0.00        0.00        0.00

   TOTAL ASSETS                 33.96       38.63       43.71       48.16       52.89       57.97       63.30


                               13.00        13.00       13.00       13.00       13.00       13.00       13.00

the cash balance is availble for replacement of plant and machinerires and for expansion purposes.
 VIII
(Proj)


   41.85
    6.79
   48.65

    0.00

    6.07

    0.00

    1.15

    0.00

   55.86



   24.05
   16.18
    7.87

    0.00


    4.74
    0.00
    4.50
   51.76
    0.00

   68.86


   13.00
CASH FLOW STATEMENT
                                  (Rs. in Lakhs)
PARTICULARS
                                      0                I           II           III           IV            V           VI          VII       VIII

SOURCES OF FUNDS
                                    0.00
Net Profit after Tax before , Dep. & prel. Exp. 7.05       7.17         7.90          7.80         7.82         7.82         7.86         7.90
Share Capital                       4.00        4.00       0.00         0.00          0.00         0.00         0.00         0.00         0.00
Term Loan                           8.00        8.00       0.00         0.00          0.00         0.00         0.00         0.00         0.00
Unsecured Loan                                  0.00       0.00         0.00          0.00         0.00         0.00         0.00         0.00
Increase in WC Loan                             4.42       0.86         0.76          0.02         0.00         0.00         0.00         0.00


TOTAL FUNDS AVAILABLE              12.00      23.47        8.04         8.66          7.82         7.82         7.82         7.86         7.90

APPLICATION OF FUNDS
Fixed Assets                       11.05      11.05        0.00         0.00          0.00          0.00         0.00         0.00         0.00
Pre-op Exp                          0.50       0.50        0.00         0.00          0.00          0.00         0.00         0.00         0.00
Incre.in Investment                            0.00        0.00         0.00          0.00          0.00         0.00         0.00         0.00
Incre.In Woking Capital             0.45       5.90        1.15         1.01          0.03         (0.00)       (0.00)       (0.00)       (0.00)
Repayment of Term Loan                         0.00        0.62         1.23          1.23          1.23         1.23         1.23         1.23

TOTAL APPL. OF FUNDS               12.00      17.45        1.77         2.24          1.26         1.23         1.23         1.23         1.23

Opening Balance of Cash                        0.00         6.02        12.30         18.72        25.28        31.87        38.46        45.08
Cash accrued during the year                   6.02         6.27         6.42          6.57         6.59         6.59         6.63         6.67
Closing Balance of Cash                        6.02        12.30        18.72         25.28        31.87        38.46        45.08        51.76
                         Assessment in Working Capital Requirements



                                                I          II      III      IV      V

A. CURRENT ASSETS
Stock-in-trade                                   3.55       4.14    4.74     4.74    4.74
Receivables                                      3.21       3.91    4.47     4.50    4.50
Advances                                         0.00       0.00    0.00     0.00    0.00
Cash and Bank                                    6.02      12.30   18.72    25.28   31.87
Other current assets
Total current assets                            12.78      20.35   27.92    34.52   41.11

B. Current Liabilities
Sundry creditors                                 0.86       1.01    1.15     1.15    1.15
Statutory liablities                                0.00    0.00     0.00    0.00       0.00
Other Current Liabilities                        0.00       0.00    0.00     0.00    0.00

Total Current Liabilities                        0.86       1.01    1.15     1.15    1.15

Current Assets                                  12.78      20.35   27.92    34.52   41.11
Less - Current Liabilities(Exluding Bank fin)    0.86       1.01    1.15     1.15    1.15
Working Capital Gap                             11.92      19.34   26.77    33.37   39.96
Less - 25% of Total Current Assets               3.20       5.09    6.98     8.63   10.28
Permissible Bank Finance                         8.73      14.26   19.79    24.74   29.68
VI      VII      VIII



 4.74    4.74     4.74
 4.50    4.50     4.50
 0.00    0.00     0.00
38.46   45.08    51.76

47.69   54.32    60.99


 1.15    1.15      1.15
 0.00     0.00     0.00
 0.00    0.00      0.00

 1.15    1.15      1.15

47.69   54.32    60.99
 1.15    1.15     1.15
46.54   53.17    59.84
11.92   13.58    15.25
34.62   39.59    44.59
                                                        APPENDIX 17.11
                                           Assessment of Working Capital Requirements
                                                          FORM II
                                                  OPERATING STATEMENT
                                                     Name - XYZ Industries
                                                                                            (Amount - Rs. In lacs)
                    As Per Profit & Loss AccountsActuals/estimates for the year ended/ending
                                                           I           II           III          IV

1. GROSS SALES
I)Gross Sales                                                  51.30        62.55     71.55       72.00
Total                                                          51.30        62.55     71.55       72.00
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)                                          51.30        62.55     71.55       72.00
2. COST OF SALES
(I) Consumpsion                                                19.67        23.98     27.43       27.60
(ii) Other Trading Expenses
   (Carrige Inword, Commission,
    Brokerage on Purchases)                                    21.85        25.78     29.47       29.52
(iii) Sub Total (i+ii)                                         41.52        49.76     56.90       57.12
(iv) Add - Opening Stock                                        0.00         2.23      2.60        2.98
(v) Sub Total (iii+iv)                                         41.52        51.99     59.50       60.10
(vi) Less Closing Stock                                         2.23         2.60      2.98        2.98
(vii) Sub-Total (Total Cost of Sales)(v-vi)                    39.29        49.39     56.53       57.12
3. SELLING GENERAL &
ADMINISTRATIVE EXPENSES
(Including Bonus Payment)                                       3.96         4.62         5.28        5.28


4. OPERATING PROFIT
(Before intrerst & Depreciation)
[1(iii) - 2 (vii) - 3 ]                                         8.05         8.54         9.74        9.60
5. INTEREST on working capital                                  0.55         0.66         0.76        0.76
                     on term loan                               0.96         0.96         0.85        0.70
6. DEPRECIATION                                                 3.27         2.80         2.39        2.05


7. OPERATING PROFIT
(after interest & depreciation)
(4-5-6)                                        3.27      4.12      5.74    6.09
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.00
  c. 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.10      0.10      0.10    0.10
  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)]        3.17      4.02      5.64    5.99
10. PROVISION FOR TAXES                       -0.51     -0.25      0.23    0.34
11. NET PROFIT/(LOSS) (9-10)                   3.68      4.28      5.41    5.65
12. (a) Equity Dividend paid **                0.00      1.00      2.00    3.00
   (b) Dividend Rate                            0%     100%       200%    300%
13. RETAINED PROFIT                            3.68      3.28      3.41    2.65
14. RETAINED PROFIT/NET PROFIT               100%        77%       63%     47%
   ( %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




                                          APPENDIX 1/.IV
                                       Assessment in working Capital Requirements
                                                      FORM - III
                                               Analysis Of Balance Sheet
                                                 Name - XYZ Industries
                                                                                   (Amount - Rs. In lacs)
             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)                         4.42         5.29         6.04        6.07
   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)                               4.42         5.29         6.04        6.07
2. Short term borrowings from others                       0.00         0.00         0.00        0.00
3. Sundry Creditors (Trade)
  ( month's purchases)                                     0.86         1.01         1.15        1.15
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)                               0.87         1.01         1.15        1.15
10. Total Current liabilities ( total of 1 to 9)           5.29         6.30         7.19        7.22

TERM LIABILITIES
11.Debentures(not maturing within one year)                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)                       8.00         7.38         6.15        4.92

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.00
17. Total term liabilities                      8.00    7.38    6.15    4.92
18. Total outside liabilities (10 + 17)        13.29   13.68   13.35   12.14
NET WORTH
19. Share Capital                               4.00    7.68   11.96   17.37
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)                      3.68    4.28    5.41    5.65
24. Net Worth                                   7.68   11.96   17.37   23.02
25. Total Liabilities (18 + 24)                20.96   25.64   30.71   35.16
CURRENT ASSETS
26. Cash & Bank Balance                         6.02   12.30   18.72   25.28
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)                 3.21    3.91    4.47    4.50
    ( 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)      3.55    4.14    4.74    4.74
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)   12.78   20.35   27.92   34.52
FIXED ASSETS
35. Gross Block(Land & Building machinery
    furniture & fitings vehicles)              24.05   20.78   17.98   15.59
36. Depreciation to date                        3.27    2.80    2.39    2.05
37. Net Block (35-36)                          20.78   17.98   15.59   13.54

OTHER NON CURRENT ASSETS
38. Investments/book debt/advances/
   deposites which are not Current Assets
   ( I ) (a) Investments in subsidiary
           company/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.                  0.40      0.30       0.20    0.10
43. Total Assets( Total of 34,37,41 & 42)       33.96     38.63      43.71   48.16
44. Tangible Net Worth (24 - 42)                 7.28     11.66      17.17   22.92
45. Net working Capital
   [(17+24) - (37+41+42)]
   To tally with (34 -10 )                       -5.50        1.06    7.73   14.30
46. Current Ratio (34 - 10)                       2.42        3.23    3.88    4.78
47. Total outside Libilities/ tangiable
   net worth ( 18 / 44)                          1.83         1.17    0.78    0.53




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




                                             APPENDIX 1/.IV
                                 Assessment in Working Capital Requirements
                                                   FORM - IV
                          Comparative Statement of Current Assets and Current Liabilities
                                            Name - XYZ Industries
                                                    I           II           III            IV

A. CURRENT ASSETS
1) Stock-in-trade
(month's cost of sales)                                  3.55         4.14         4.74          4.74
2) Receivables other
then export and deferr
ed receivables (inclu-
ding bills purchased
and discounted by
bankers)
(month's domestics -
Sales)                                                   3.21         3.91         4.47          4.50
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)                                    6.02        12.30     18.72         25.28
6)Total current assets
(To agree with item 34
in From III)                                            12.78        20.35     27.92         34.52

B. Current Liabilities
(Other then bank
borrowings for working
capital )
7) Sundry creditors
(Trade)
(Month's Purchases)                                      0.86         1.01         1.15          1.15
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 Current
liabilities (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)                                     0.86         1.01         1.15        1.15
                                                      0.86         1.01         1.15        1.15

Current Assets                                       12.78        20.35     27.92       34.52
Less - Current Liabilities(Exluding Bank fin)         0.87         1.01      1.15        1.15
Working Capital Gap                                  11.92        19.34     26.77       33.37
Less - 25% of Total Current Assets                    3.20         5.09      6.98        8.63
Permissible Bank Finance                              8.72        14.25     19.79       24.74




                                              APPENDIX 17.V
                                Assessment in Working Capital Requirements
                                                FORM - V
                    Computation of Maximum Permissible Bank Finance for Working Capital
                                          Name - XYZ Industries
                                                 I           II           III          IV



01. Total current Assets (34 of form III )           12.78        20.35     27.92       34.52
02. Current Liabilities (2 to 9 of form III )
    Other then bank borrowings)                       0.87         1.01      1.15        1.15
03. Working Capital Gap (WCG) (1 - 2)                11.92        19.34     26.77       33.37
04. Min. stipulated Net Working Capital
    25% of total current assets other then
    Export Receivables
    [ as at 28 (ii) of form III]                      3.20         5.09         6.98        8.63
05. Actual/projected net working capital
   (45 of form III)                                  -5.50         1.06         7.73    14.30
06. Item 3 minus item 4                      8.72   14.25   19.79   24.74
07. Item 3 minus item 5                     17.42   18.28   19.04   19.07
08. Maximum permissible bank finance
   (Item 6 or 7, which ever is lower)        8.72   14.25   19.04   19.07
09.Excess borrowings, if any representing
  shortfall in NWC (4 - 5)                   0.00    0.00    0.00    0.00
                                            APPENDIX 17.VI
                               Assessment in Working Capital Requirements
                                              FORM - VI

                                              Name - XYZ Industries

                                                         I            II           III           IV
1. Sources
  a) Net Profit (after tax)                                   3.68         4.28          5.41         5.65
  b) Depreciation                                             3.27         2.80          2.39         2.05
  c) Increase in capital                                      4.00         0.00          0.00         0.00
  d) Increase in term Liabilities (Includings Public
     deposits)                                                8.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.10         0.10          0.10         0.10
  f) Others
  g) Total                                                   19.05         7.17          7.90         7.80
2. Uses
  a) Net Loss                                                 0.00         0.00          0.00         0.00
  b) Decrease in Term Liabilities
     (including public deposits)                              0.00         0.62          1.23         1.23
  c) Increase in :
     I) Fixed Assets                                         24.05         0.00          0.00         0.00
    ii) Other non-current assets                              0.50         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.00
  f) Total                                                   24.55         0.62          1.23         1.23
3. Long Tern Surplus (+)/Deficit ( - ) (1 - 2)               -5.50         6.56          6.67         6.57
4. Increase/decrease in current assets
  *(as per details given below)                              12.78         7.57          7.58         6.59
5. Increase/decrease in current liabilities
  Other then bank borrowings                                  0.86         0.14          0.14         0.00
6. Increase/decrease in working capital gap                  11.92         7.42          7.43         6.59
7. Net Surplus ( + )/deficit 9 ( - )
  (Difference of 3 & 6 )                                 -17.42            -0.86         -0.75        -0.02
8. Increase/decrease in Bank borrowings                    4.42             0.86          0.76         0.02
INCREASE/DECREASE IN NET SALES
  I). Increase/decrease in stock-in-trade                     0.00         0.00          0.59         0.59
  ii). Increase/decrease in Receivables
     (a) Domestic                                             0.00         0.00          0.70         0.56
     (b) Exports
(Amount - Rs. In lacs)

                V



                72.00
                72.00




                 0.00
                 0.00
                 0.00
                 0.00
                72.00

                27.60


                29.52
                57.12
                 2.98
                60.10
                 2.98
                57.12


                    5.28




                    9.60
                    0.76
                    0.55
                    1.76
 6.53
 0.00
 0.00
 0.00
 0.00
 0.00
 0.10
 0.00
 0.00
 0.00
 0.00
 0.00
 0.00
 6.43
 0.47
 5.96
 4.00
400%
 1.96
 33%




 0.00
 0.00
 0.00
 0.00
 0.00

 0.00
 0.00
 0.00
 0.00
 0.00

 0.00
Amount - Rs. In lacs)

                 V




                     6.07
                     0.00
                     0.00

                     6.07
                     0.00

                     1.15

                     0.00
                     0.00
                     0.00

                     0.00


                     0.00


                     0.00

                     1.15
                     7.22


                     0.00

                     0.00

                     3.69
 0.00
 0.00
 0.00
 3.69
10.91

23.02
 0.00
 0.00
 0.00
 0.00
 5.96
28.98
39.89

31.87




 0.00
 0.00




 4.50




 0.00

 0.00
 4.74
 0.00
 0.00

 0.00
41.11


13.54
 1.76
11.78
 0.00
 0.00

 0.00

 0.00
 0.00
 0.00
 0.00

 0.00

 0.00


 0.00
52.89
28.98


20.89
 5.70

 0.38




 0.00


 0.00

 0.00


 0.00
 0.00
ties

       V




           4.74




           4.50




           0.00

           0.00




       31.87


       41.11




           1.15


           0.00
           0.00
              0.00


              1.15
              1.15

          41.11
           1.15
          39.96
          10.28
          29.68




Capital

          V



          41.11

           1.15
          39.96




          10.28

          20.89
29.68
19.07

19.07

 0.00
V


    5.96
    1.76
    0.00

    0.00

    0.00
    0.10

    7.82

    0.00

    1.23

    0.00
    0.00
    0.00
    0.00
    1.23
    6.59

    6.59

    0.00
    6.59

    0.00
    0.00

    0.00

    0.03
                                       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 limits Balance      Limits now
           Financial Institution    facility  Limits          were utilised during   Out Standing requested
                                                              the last 12 Months     As on date
                                                              Max.           Min.

           A. WORKING CAPITAL LIMITS
    1                               C.C A/c            0.00                                   0.00          4.42




 S.No.     Name of Bank/            Sanctioned Limits Out Standing                   Overdues Remarks
           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 account Name of       Working Capital Term                      DGP         Over
                                    (Date of   Banks/                        loan                                  dues
                                    Balance    Financial Fund       Non fund                                       if any
                                    Sheet)     Institutions base    base

    1           2           3           4          5              6           7           8             9               10

                                                              None       None        None            None          No




                                                              None       None        None            None          No

								
To top