6 model project report by R5Gx2o

VIEWS: 19 PAGES: 19

									       Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                    Project Report


I     BLOCK CAPITAL                                                         TOTAL
                                                                        Rs in lacs
    1 LAND & BUILDING
      Land ( 10 Bighas )                                                    30.00
      Land Development
      Factory Shed including
      Office Building, Laboratory
      Guard Room, Generator Room                                            20.00
      Boundary Wall, Gate & Deep Tube Well
                                                     Sub total      A       50.00
    2 PLANT & MACHINERIES
      Hopper
      Feeder
      Jaw Crusher                                                          255.94
      Conveyor
      Vibrating Screen
      Electrical Control Panel
                                                     Sub total      B     255.94
    3 OTHER ASSETS & ACCESSORIES
      Electrical Connection & Fittings                                      35.00
      Furniture & Fittings incl.Office Equipments                            1.20
      Dumper & Payloader                                                    60.00
      Office Vehicles and Motor Cycles                                      10.20
      Pollution Control Equipment                                            2.60
                                                     Sub total      C       74.00
    4 PREL & PREOPERATIVE EXPENSES
      Prel.,Preop.,Know how and Other Exp                                    0.22
      Contingencies @ 1 % of each cost element                               3.80
                                                     Sub total      D        4.02
    A TOTAL FIXED ASSETS                                                   383.96
      Add: Margin Money for W.C.                                    E        4.23
    B TOTAL BLOCK CAPITAL                                                  388.18
      Add: W.C. less Margin Money                                   F       12.68

    C TOTAL PROJECT COST                                                   400.86
   Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                           Project Report


II COST OF PROJECT

   Land and Building                                                A          50.00
   Plant and Machineries                                            B         255.94
   Other Assets & Accessories                                       C          74.00
   Prel & Preoperartive Expenses                                    D           4.02

   TOTAL FIXED ASSETS                                                         383.96

   WORKING CAPITAL                                                             16.90
                                     Reqd /mth       Amount          Total
        Raw Material                                1500000         15.00
        Other Material                               190100          1.90

   TOTAL PROJECT COST                                                         400.86


III MEANS OF FINANCE

   Promoter's Contribution                                                     99.86
   Loan from Institute                                                        288.00
   Unsecured Loan                                                               0.00
   Cash Credit                                                                 13.00

   MEANS OF FINANCE                                                           400.86

   Cost of Finance                      Intt %      LOAN        Term (yrs) Instalment

   Loan from Institute                    13.75       288.00      3.00       96.00
   Cash Credit                            13.75        13.00      N/A         N/A

                                                      301.00
Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                                     Project Report
IV   Monthly Expenses              (At 100% capacity utilisation)



IVA RAW MATERIAL                              Quantity requirement chart
                                                                                         Total
                                                Quantity      Rate        Quantity     Value in   Rs in lacs
                                                 for the       in          for the      Rupees
                                                  year       Rupees        month      per month
                                                               1              2           3           4

     Stone Bolders (Chelly)        MT          720000.00            100      60000     6000000



     Total Requirement                                            100        60000     6000000        60.00
                                                              Av.Rate



IVB MAN POWER
    SALARY
    POST                                                        RATE           Nos.     SALARY Rs in lacs
    Manager and Supervisor                                     10000             2       20000
    Machineman, Drivers and Skilled Workers                     8000            18      144000
    Semiskilled Workers                                         6000             4       24000
    Unskilled Workers                                           3500            24       84000
    Office Staffs                                               4000             5       20000
    Security Guards                                             5000             9       45000
    TOTAL                                                                       62      337000
    Add : Perks @ 15%                                                                    50550
    TOTAL                                                                               387550       3.88
Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                                   Project Report


IVC DIRECT EXPENSES                              Quantity requirement chart
                                                                          Quantity    Total
                                                                Rate    for the mth Value in    Rs in lacs
                                                                 in                  Rupees
                                                              Rupees                per month
                                                                 1            2         3           4

         Electricity (438 KW x 8 hrs x 25 days x Rs 4/- )            4      87600     350400
         Fuel for Payloader @ 100 lts per day                       37       2500      92500
         Fuel for Dumpers @ 300 lts per day                         37       7500     277500
         Mobile & Lubricants                                       100        200      20000
         Other Utilities, Tools etc                                                    20000
         Total Requirement                                                            760400            7.60


IVD ADMINISTRATIVE EXPENSES                                                Annual    Monthly
    Consumable Stores                                                     240000      20000
    Lease Rent, Rates and Taxes                                            66000       5500
    Repairs & Maintenance                                                 600000      50000
    Telephone & Postage                                                    96000       8000
    Travelling & Allowance                                                 60000       5000
    Sales Promotion & Advertisement                                       240000      20000
    Consultancy & Expert Fees                                              60000       5000
    Miscellaneous Expenses                                                240000      20000
    -including Staff welfare, Safety wears,
     insurance and Office Expenses
    TOTAL                                                                1602000      133500            1.34


IV       TOTAL EXPENSES PER MONTH
     A   RAW MATERIAL                                                                6000000
     B   MAN POWER                                                                    387550
     C   DIRECT EXPENSES                                                              760400
     D   ADMINISTRATIVE EXPENSES                                                      133500
                                                                                     7281450        72.81
Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                   Project Report




CAPACITY UTILISATION WISE WORKING CAPITAL REQUIREMENT

YEAR                                                  1st      2nd      3rd      4th      5th
Capacity Utilisation                     100           80        90     100      100      100

RAW MATERIAL

a    Raw Material Requirement        720000       576000     648000   720000   720000   720000

     Balance b/f                       MT              0      12000    13500    15000    15000
     Quantity Purchased                MT         588000     649500   721500   720000   720000
     Used for production               MT         576000     648000   720000   720000   720000
     Balance c/f                       MT          12000      13500    15000    15000    15000

     Value of Inputs               Rs in lacs
     Used                                             576       648     720      720      720
     Others                                             0         0       0        0        0
     TOTAL                                            576       648     720      720      720

     Raw Material c/f              Schedule             12      14       15       15       15
     Other Material                1 month               0       0        0        0        0
     Work in Progress                                    0       0        0        0        0
     Finished Goods                                      0       0        0        0        0
     Stock C/f                              0           12      14       15       15       15
    Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                       Project Report




V   PROFITABILITY STATEMENT
                                                         1st       2nd        3rd       4th       5th
    Capacity Utilisation                 100.00        80.00      90.00    100.00    100.00    100.00
    Annual Production MT                 720000       576000     648000    720000    720000    720000
    Annual Production MT                      0            0          0         0          0         0
    TOTAL                                720000       576000     648000    720000    720000    720000

    INCOME                                 Initial       1st        2nd        3rd      4th       5th
    Sales                                   0.00     1382.40     1555.20   1728.00   1728.00   1728.00

    Opening Stock                            0.00        0.00      12.00     13.50     15.00     15.00
    Purchases                                0.00      588.00     649.50    721.50    720.00    720.00
    Closing Stock                            0.00       12.00      13.50     15.00     15.00     15.00
    Raw Material Consumed                    0.00      576.00     648.00    720.00    720.00    720.00

                                                                                                       Fixed
    RECURRING EXPENSE                                     1st       2nd        3rd      4th       5th Cost %

    Salary & Wages                         46.51        46.51      48.83     51.16     53.48     55.81     40
    Raw Material Consumed                 720.00       576.00     648.00    720.00    720.00    720.00      0
    Direct Expenses                        91.25        78.47      84.86     91.25     91.25     91.25     30
    DIRECT COST OF PRODUCTION             857.75       700.98     781.69    862.40    864.73    867.06
    Administrative Exp                     16.02        15.06      15.54     16.02     16.02     16.02     70
    Interest on Loan                                    41.39      34.79     21.59      8.39      1.79    100
    Depr & W/Offs                                       74.69      57.83     45.10     36.13     28.59    100
    TOTAL EXPS                               0.00      832.11     889.85    945.11    925.27    913.46

    NET PROFIT BEFORE TAX                    0.00      550.29     665.35    782.89    802.73    814.54
    Less Income Tax                          0.00      165.09     199.61    234.87    240.82    244.36
    NET PROFIT AFTER TAX                     0.00      385.20     465.75    548.02    561.91    570.18
   Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                   Project Report




VI CASH FLOW STATEMENT                                   1st      2nd       3rd     4th      5th

  NET PROFIT AFTER TAX                     0.00       385.20    465.75   548.02   561.91   570.18
  ADD: Depr & W/Offs                       0.00        74.69     57.83    45.10    36.13    28.59
  Less Repayment of TL                     0.00         0.00     96.00    96.00    96.00     0.00
  Less Drawings                            0.00       116.00    140.00   164.00   169.00   171.00
  Total Cash Inflow                        0.00       343.89    287.58   333.12   333.04   427.77
  Promoters Contr.                        99.86         0.00      0.00     0.00     0.00     0.00
  Increase in S/Creditors                  0.00         0.00      0.00     0.00     0.00     0.00
  Secured Loan                           301.00         0.00      0.00     0.00     0.00     0.00
  TOTAL INFLOW                           400.86       343.89    287.58   333.12   333.04   427.77
  Increase in F.Asset                    383.96         0.00      0.00     0.50     3.00     0.50
  Investments                              0.00       150.00    110.00   200.00   350.00   410.00
  Increase in Stock                        0.00        12.00      1.50     1.50     0.00     0.00
  Increase in S/Debtors                    0.00        28.80      3.60    21.60     0.00     0.00
  TOTAL OUTFLOW                          383.96       190.80    115.10   223.60   353.00   410.50
  Net increase in Cash                    16.90       153.09    172.48   109.52   -19.96    17.27

  NET PROFIT BEFORE TAX                     0.00      550.29    665.35   782.89   802.73   814.54
  RETURN ON SALES (%)                       0.00       39.81     42.78    45.31    46.45    47.14
  (Profit before tax)
  RETURN ON INVESTMENTS (%)                 0.00      137.28    165.98   195.30   200.25   203.20
  (Profit before tax)

  NET CASH and OTHER BALANCE
  Balance b/f                              0.00        16.90    169.99   342.46   451.98   432.03
  Addition during the year                16.90       153.09    172.48   109.52   -19.96    17.27
  Balance c/f                             16.90       169.99    342.46   451.98   432.03   449.30

  Stock in trade                           0.00        12.00     13.50    15.00    15.00    15.00
  Sundry Debtors                           0.00        28.80     32.40    54.00    54.00    54.00
  Cash Balance                            16.90       169.99    342.46   451.98   432.03   449.30
  Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                          Project Report




 WORKING NOTES


1 SUNDRY DEBTORS                         Period     1 mth        1 mth   1.5 mths   1.5 mths   1.5 mths
      Sales                                        1382.40     1555.20    1728.00    1728.00    1728.00
      Cash Sales                           0.75    1036.80     1166.40    1296.00    1296.00    1296.00
      Credit Sales                         0.25     345.60      388.80     432.00     432.00     432.00
      Debtors                                        28.80       32.40      54.00      54.00      54.00

2 LOAN DETAILS                       Loan Yr            1st       2nd         3rd       4th        5th
  Interest on Term Loan
  Interest Rate                          13.75        13.75      13.75     13.75      13.75      13.75
  Balance b/f                             0.00       288.00     288.00    192.00      96.00       0.00
  Addition                              288.00         0.00       0.00      0.00       0.00       0.00
  Add Interest                            0.00        39.60      33.00     19.80       6.60       0.00
  Less Repayment                          0.00         0.00      96.00     96.00      96.00       0.00
  Less Interest Repaid                    0.00        39.60      33.00     19.80       6.60       0.00
  Balance c/f                           288.00       288.00     192.00     96.00       0.00       0.00

 Cash Credit
 Interest Rate                           13.75        13.75      13.75     13.75      13.75      13.75
 Balance b/f                              0.00        13.00      13.00     13.00      13.00      13.00
 Addition                                13.00         0.00       0.00      0.00       0.00       0.00
 Add Interest                             0.00         1.79       1.79      1.79       1.79       1.79
 Less Interest Repaid                     0.00         1.79       1.79      1.79       1.79       1.79
 Balance c/f                             13.00        13.00      13.00     13.00      13.00      13.00

 SUMMARY OF LOANS
 Total Interest                           0.00        41.39      34.79     21.59       8.39       1.79
 Total Instalments                        0.00         0.00      96.00     96.00      96.00       0.00
 Total Loan C/f                         301.00       301.00     205.00    109.00      13.00      13.00
      Term Loan                         288.00       288.00     192.00     96.00       0.00       0.00
      Cash Credit                        13.00        13.00      13.00     13.00      13.00      13.00
  Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                   Project Report


3 TAX COMPUTATION
  Net Profit / Loss                                  550.29    665.35   782.89   802.73   814.54
  Tax on above                                       165.09    199.61   234.87   240.82   244.36

4 Depreciation on :-
  LAND & BUILDING                    WDV B/f          50.00     47.50    45.13    42.87    40.73
                                     Addition          0.00      0.00     0.00     0.00     0.00
  @ 05% W.D.V.                       Depr.             2.50      2.38     2.26     2.14     2.04
                                     WDV C/f          47.50     45.13    42.87    40.73    38.69

  PLANT & MACHINERIES                WDV B/f         255.94    191.96   143.97   107.97    83.23
                                     Addition          0.00      0.00     0.00     3.00     0.00
  @ 25% W.D.V.                       Depr.            63.99     47.99    35.99    27.74    20.81
                                     WDV C/f         191.96    143.97   107.97    83.23    62.42

  OTHER ASSETS & ACCESSORIES WDV B/f                  74.00     66.60    59.94    54.40    48.96
                             Addition                  0.00      0.00     0.50     0.00     0.50
  @ 10% W.D.V.               Depr.                     7.40      6.66     6.04     5.44     4.95
                             WDV C/f                  66.60     59.94    54.40    48.96    44.51

  Gross Block                                        379.94    379.94   380.44   383.44   383.94
  Depreciation                                        73.89    130.91   175.20   210.53   238.32
  Net Block                                          306.06    249.03   205.24   172.91   145.62

                                  B/f
  Prel.,Preop.,Know how and Other Exp                  0.22      0.18     0.13     0.09     0.04
                                  Addition             0.00      0.00     0.00     0.00     0.00
                    @ 20% St.Line W/off                0.04      0.04     0.04     0.04     0.04
                                  C/f                  0.18      0.13     0.09     0.04     0.00

  Contingencies                   B/f                  3.80      3.04     2.28     1.52     0.76
                                  Addition             0.00      0.00     0.00     0.00     0.00
                    @ 20% St.Line W/off                0.76      0.76     0.76     0.76     0.76
                                  C/f                  3.04      2.28     1.52     0.76     0.00

  Depreciation & W/off                                74.69     57.83    45.10    36.13    28.59
    Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                                 Project Report


VII BALANCE SHEET AS AT                             1st Year     2nd Year   3rd Year    4th Year    5th Year
    LIABILITIES
 1 CAPITAL b/f                             99.86        99.86      369.06     694.81     1078.83     1471.74
    Add:Profit (-Tax)                       0.00       385.20      465.75     548.02      561.91      570.18
    Less:Drawings                           0.00       116.00      140.00     164.00      169.00      171.00
    Capital c/f                            99.86       369.06      694.81    1078.83     1471.74     1870.93

 2 Secured Loan                           288.00       288.00      192.00      96.00         0.00        0.00

 3 CURRENT LIABILITIES
   Sundry Creditors                         0.00         0.00        0.00       0.00        0.00        0.00
   Cash Credit                             13.00        13.00       13.00      13.00       13.00       13.00

   TOTAL                                  400.86       670.06      899.81    1187.83     1484.74     1883.93

   ASSETS
 1 FIXED ASSETS
   LAND & BUILDING                         50.00        47.50       45.13      42.87       40.73       38.69
   PLANT & MACHINERIES                    255.94       191.96      143.97     107.97       83.23       62.42
   OTHER ASSETS & ACCESSORIES              74.00        66.60       59.94      54.40       48.96       44.51
   NET BLOCK                              379.94       306.06      249.03     205.24      172.91      145.62

 2 INVESTMENTS                               0.00      150.00      260.00     460.00      810.00     1220.00

 3 CURRENT ASSETS
   Stock in trade                           0.00        12.00       13.50      15.00       15.00       15.00
   Sundry Debtors                           0.00        28.80       32.40      54.00       54.00       54.00
   Cash Balance                            16.90       169.99      342.46     451.98      432.03      449.30

 4 PREL. & PREOPERATIVE
   Prel.,Preop.,Know how and Other Exp       0.22        0.18        0.13        0.09        0.04        0.00
   Contingencies                             3.80        3.04        2.28        1.52        0.76        0.00

   TOTAL                                  400.86       670.06      899.81    1187.83     1484.74     1883.93
  Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                                    Project Report


 EXPECTED PRODUCTION AND SALES AND OTHER DIRECT EXPENSES


5 SALES (At 100% Capacity)           Daily          Monthly      Annual
  Production in MT
       Chips                                 2400       60000       720000
                                                0           0            0

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

 Capacity Utilisation                   100.00          80.00        90.00     100.00      100.00      100.00

    A STONE CHIPS                       720000         576000       648000     720000      720000      720000
      Annual Production MT              720000         576000       648000     720000      720000      720000
      Sale Price per MT                 240.00         240.00       240.00     240.00      240.00      240.00
      Sales in Amount (lacs)           1728.00        1382.40      1555.20    1728.00     1728.00     1728.00

    B                                        0.00         0.00        0.00        0.00        0.00        0.00
        Annual Production MT                 0.00         0.00        0.00        0.00        0.00        0.00
        Sale Price per MT                    0.00         0.00        0.00        0.00        0.00        0.00
        Sales in Amount (lacs)               0.00         0.00        0.00        0.00        0.00        0.00

 Total Annually (Rs in lacs)           1728.00        1382.40      1555.20    1728.00     1728.00     1728.00



6 Purchases & Direct Expenses
  Value in Rs
  Total Annually                        720.00         576.00       648.00     720.00      720.00      720.00
  Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                                  Project Report



7 SALARY                                          1st Year     2nd Year   3rd Year   4th Year      5th Year

 POST                                  SALARY

 Manager and Supervisor             10000                  2          2          2           2            2
                                     8000
 Machineman, Drivers and Skilled Workers                  18         18         18          18           18
 Semiskilled Workers                 6000                  4          4          4           4            4
 Unskilled Workers                   3500                 24         24         24          24           24
 Office Staffs                       4000                  5          5          5           5            5
 Security Guards                     5000                  9          9          9           9            9



 TOTAL                               36500.00         62.00       62.00      62.00       62.00        62.00

      MONTHLY SALARY                 Rs in lacs        3.37        3.37       3.37        3.37         3.37
      Add:Increments @ 5%                do            0.00        0.17       0.34        0.51         0.67
      YEARLY SALARY                      do           40.44       42.46      44.48       46.51        48.53
      Add : Bonus & Medical              do            4.04        4.25       4.45        4.65         4.85
                                         do           44.48       46.71      48.93       51.16        53.38
      Add : Benefits                     do            2.02        2.12       2.22        2.33         2.43
      TOTAL                              do           46.51       48.83      51.16       53.48        55.81


      Initial year office staff shall be subsequently promoted to look after sales and accounts.
Project Report 0f 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls                                          Project Report



VIII Break Even Anaylsis ::

Calculation of Fixed Cost :-                          1st       2nd         3rd       4th        5th     % of
                                                                                                       Total Cost
RECURRING EXPENSE

Salary & Wages                                      18.60      19.53      20.46      21.39      22.32       40
Raw Material                                         0.00       0.00       0.00       0.00       0.00        0
Direct Expenses                                     27.37      27.37      27.37      27.37      27.37       30
Administrative Exp                                  11.21      11.21      11.21      11.21      11.21       70
Interest on Loan                                    41.39      34.79      21.59       8.39       1.79      100
Depr & W/Offs                                       74.69      57.83      45.10      36.13      28.59      100

Fixed Expenses                         A           173.27     150.74     125.73     104.50      91.29

Total Expenses                         B           832.11     889.85     945.11     925.27     913.46

Variable Expenses                   C=(B-A)        658.85     739.11     819.37     820.77     822.16

Sales                                  D         1382.40     1555.20    1728.00    1728.00    1728.00

Contribution                        E=(D-C)        723.55     816.09     908.63     907.23     905.84
Contribution/MT                    Rs              125.62     125.94     126.20     126.00     125.81


Break Even Point                   MT         137933.14 119689.02      99632.42   82933.05   72563.32
Break Even Sales                   Rs in lacs    331.04    287.25        239.12     199.04     174.15
Break Even Percentage              Percent        23.95     18.47         13.84      11.52      10.08
                                       CMA
  6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls Data
Year                            1st            2nd         3rd            4th            5th

GROSS INCOME
Capacity Utilisation                80.00          90.00      100.00         100.00         100.00
Sales          Domestic          1,382.40       1,555.20    1,728.00       1,728.00       1,728.00
Percentage Increase                                12.50       11.11            -              -

Other Income                          -              -           -              -
Sub-total                             -              -           -              -
TOTAL                            1,382.40       1,555.20    1,728.00       1,728.00       1,728.00

COST OF SALES
Purchase                              588.00     649.50          721.50         720.00     720.00
Other Trading                         124.98     133.69          142.40         144.73     147.06
Sub-total                             712.98     783.19          863.90         864.73     867.06
Add Opening Stock                        -        12.00           13.50          15.00      15.00

Sub-total                             712.98     795.19          877.41         879.73     882.06
Less Closing Stock                     12.00      13.50           15.00          15.00      15.00

Sub-total                             700.98     781.69          862.40         864.73     867.06
SELLING,GENERAL,ADM EXP                15.06      15.54           16.02          16.02      16.02
OPERATING PROFIT                      666.36     757.97          849.58         847.25     844.92
Interest                               41.39      34.79           21.59           8.39       1.79
Depreciation                           74.69      57.83           45.10          36.13      28.59

OPERATING PROFIT after I & D          550.29     665.35          782.89         802.73     814.54
add Other Non operating                  -          -               -              -          -
less Other non oper.exp                  -          -               -              -          -
NET of Non Operating                     -          -               -              -          -
Profit before tax                     550.29     665.35          782.89         802.73     814.54
Partners Salary                          -          -               -              -          -
Interest on Capital                      -          -               -              -          -
Profit subject to tax                 550.29     665.35          782.89         802.73     814.54
Tax                                   165.09     199.61          234.87         240.82     244.36

NET PROFIT                            385.20     465.75          548.02         561.91     570.18
Drawing                               116.00     140.00          164.00         169.00     171.00
Retained Profit                       269.20     325.75          384.02         392.91     399.18
Percentage of retained profit          69.89      69.94           70.07          69.92      70.01
                                       CMA
  6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls Data


BALANCE SHEET ANALYSIS
Short Term Borrowing               13.00    13.00     13.00      13.00      13.00
Others                               -        -         -          -
Sundry Creditors                     -        -         -          -           -
Advance from Customers               -        -         -          -          -
Sub Total                            -        -         -          -          -
CURRENT LIABILITIES                13.00    13.00     13.00      13.00      13.00
TERM LOAN                         288.00   192.00     96.00       0.00       0.00
Outside Liabilities               301.00   205.00    109.00      13.00      13.00
NET WORTH
Capital                           369.06   694.81   1,078.83   1,471.74   1,870.93
NET WORTH                         369.06   694.81   1,078.83   1,471.74   1,870.93
TOTAL LIABILITIES                 670.06   899.81   1,187.83   1,484.74   1,883.93

Cash and Bank                     169.99   342.46    451.98      432.03     449.30
Investment                        150.00   260.00    460.00      810.00   1,220.00
Receivables                        28.80    32.40     54.00       54.00      54.00
Stock                              12.00    13.50     15.00       15.00      15.00
Advance to Suppliers                 -        -         -           -          -
Others     Security as advance       -        -         -           -          -
Others     Tax Refundable            -        -         -           -          -
CURRENT ASSETS                    360.79   648.36    980.99    1,311.03   1,738.30

Gross Bock                        379.94   379.94    380.44     383.44     383.94
Depreciation                       73.89   130.91    175.20     210.53     238.32
Net Block                         306.06   249.03    205.24     172.91     145.62

Security Deposit                     -        -          -          -          -
Intangible Assets                   3.22     2.41       1.61       0.80       0.00
TOTAL ASSETS                      670.06   899.81   1,187.83   1,484.74   1,883.93
Diff of Liab to Assets               -        -          -          -          -
Tangible Net Worth                369.06   694.81   1,078.83   1,471.74   1,870.93
Net Working Capital
(34-10)                           347.79   635.36    967.99    1,298.03   1,725.30
(17+24)-(37+41+42)                347.79   635.36    967.99    1,298.03   1,725.30

CURRENT RATIO                      27.75    49.87     75.46     100.85     133.72
Outsd Liab./ Tangible Net Worth     0.82     0.30      0.10       0.01       0.01
                                            A
     6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls nalysis


     YEAR                              1st Year    2nd Year     3rd Year     4th Year



 1   Capital                          369.06       694.81     1,078.83     1,471.74
 2   Reserves & Surplus                  -            -            -            -
 3   Intangible                         3.22         2.41         1.61         0.80
 4   Tangible                         365.84       692.40     1,077.22     1,470.94
 5   Term Loan                        288.00       192.00        96.00         0.00
 6   Other Term Loan                     -            -            -            -
 7   Unsecured Loan                      -            -            -            -
 8   Total Term Liabilities           288.00       192.00        96.00         0.00
 9   Capital Employed                 653.84       884.40     1,173.22     1,470.94
10   Net Block                        306.06       249.03       205.24       172.91
11   Investment in allied                -            -            -            -
12   Investment in Others             150.00       260.00       460.00       810.00
13   Drs>6 mths                          -            -            -            -
14   Other Non C Assets                  -            -            -            -
15   Total Non Current Ast            150.00       260.00       460.00       810.00
16   Inventory                         12.00        13.50        15.00        15.00
17   Drs<6 mths                        28.80        32.40        54.00        54.00
18   Other Current                    169.99       342.46       451.98       432.03
19   Total Current Assets             210.79       388.36       520.99       501.03
20   Bank Borrowings                   13.00        13.00        13.00        13.00
21   Sundry Creditors                    -            -            -            -
22   Other Current Liab                  -            -            -            -
23   Total Current Liab                13.00        13.00        13.00        13.00
     Working Capital                  197.79       375.36       507.99       488.03

     Total Liabilities                666.84       897.40     1,186.22     1,483.94
     Total Assets                     516.84       637.40       726.22     1,483.94
                                      150.00       260.00       460.00          -
     Working Capital available        210.79       388.36       520.99       501.03
           25%                         52.70        97.09       130.25       125.26
     Balance (MPBF)                   158.09       291.27       390.74       375.77
                                           A
    6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls nalysis


    YEAR                                 1st Year    2nd Year     3rd Year     4th Year




OPERATION ANALYSIS
    Net Sales                        1,382.40       1,555.20    1,728.00     1,728.00
    Other Income                          -              -           -            -
    Gross Profit                       681.42         773.51      865.60       863.27
    Profit before tax                  550.29         665.35      782.89       802.73
    Tax                                165.09         199.61      234.87       240.82
    PAT                                385.20         465.75      548.02       561.91
    Depr & Other non                    74.69          57.83       45.10        36.13
    Cash Accrual                       459.89         523.58      593.12       598.04


RATIO ANALYSIS
    Current Ratio                        16.21        29.87       40.08        38.54
    Debt Equity                           0.79         0.28        0.09         0.00
    Leverage                              0.82         0.30        0.10         0.01
    Gross Profit %                       49.29        49.74       50.09        49.96
    Net Profit %                         39.81        42.78       45.31        46.45
    Return on Tangible                   10.88         6.18        4.21         3.16

Computation of Limit on Turnover Basis

a   Annual turnover as projected     1,382.40       1,555.20    1,728.00     1,728.00
b   Turnover as accepted             1,382.40       1,555.20    1,728.00     1,728.00
c   Working Capital 25% of sales       345.60         388.80      432.00       432.00
d   Margin reqd 5% of sales             69.12          77.76       86.40        86.40
e   Actual Margin available            210.79         388.36      520.99       501.03
f   c-d                                276.48         311.04      345.60       345.60
g   c-e                                134.81           0.44      (88.99)      (69.03)
h   f-g        MPBF                    141.67         310.60      434.59       414.63
                                        A
 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls nalysis


  5th Year



1,870.93
     -
    0.00
1,870.93
    0.00
     -
     -
    0.00
1,870.93
  145.62
     -
1,220.00
     -
     -
1,220.00
   15.00
   54.00
  449.30
  518.30
   13.00
     -
     -
   13.00
  505.30

1,883.93
1,883.93
     -
  518.30
  129.58
  388.73
                                        A
 6f73e65e-5205-405f-9b3a-b3f831b0fa0b.xls nalysis


  5th Year




1,728.00
     -
  860.94
  814.54
  244.36
  570.18
   28.59
  598.77



  39.87
   0.00
   0.01
  49.82
  47.14
   2.52



1,728.00
1,728.00
  432.00
   86.40
  518.30
  345.60
  (86.30)
  431.90

								
To top