M DAS Cma

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 16

INSTRUCTIONS

WHILE OPENING THIS FILE, IF YOU GET A MESSAGE ASKING YOU WHETHER TO
'Disable Macros' OR 'Enable Macros', SELECT "Disable Macros".

This File should be saved separately in any Computer. To use it for an analysis, a copy
(named as, say, "CMA-XYZ LTD") should be taken out and all data entry should be made
ONLY in this new File. This would ensure that the Mother File ("CMA-MAIN") remains
untouched and uncorrupted for ready reference and copying.

1 Name of the Borrower must be entered only once in Cell No.C4 of FORM-II.
Enter the YEARS in FORM-II. In case the number of months covered in any period(s) is(are)
NOT 12, then change the "No. of Months" appropriately under the said YEAR(S)

2 Cell No.G6 of Form-II should be filled in to indicate whether the Amounts incorporated
in the ENTIRE WORKSHEET are in LACS or CRORES.
Modify the column-head labels "Actuals", "Estimates" and "Projections
as may be required for your analysis.
While printing, select "Gridlines" in Page Set Up (Sheet) Menu, for easy reading.

3 You need NOT enter or change the NAME, Lacs/Crores,YEAR or NO. OF MONTHS cells
other Worksheet. These would be auto-generated from what have been entered in FORM-II.

4 Fill in all data in FORM-II and FORM-III. DO NOT ENTER ANY DATA IN THE CELLS
COLOURED IN YELLOW. These cells contain Formulae, which would be auto-generated.
All yellow cells have been protected to avoid corruption of standard Format & Formulae.

5 YOU NEED NOT ENTER ANY DATA IN THE REMAINING WORKSHEETS ( "FORM-IV"
to "ANALYSIS"). All these data would be automatically extracted from what you have entered
in FORM-II and FORM-III. Accordingly the LAST SIX WORKSHEETS HAVE BEEN
PROTECTED TO AVOID ANY CORRUPTION OF STANDARD FORMULAE.

6 Depreciation for any specific year may be different in FORM-II and FORM-III (owing to
sale of assets, etc.). If so, a difference would appear in the Worksheet "CHECK". This is not an
error, but you should reconcile the difference separately and keep it for record. Please note
that the Depreciation for the Year, as appearing in FORM-VI, is auto-extracted from FORM-III
(by computing the incremental cumulative depreciation during any year) and NOT from FORM-
7 If there is any Capital Works in Progress, it should be added manually to Gross Block.

8 Cell E69 of Form-IV is UNPROTECTED. Please fill in the data manually.

This is a Beta version. In case you come across any error / inconsistency / difficulty
OR if you have any suggestions for imrpoving this Spreadsheet, please refer back to the
appropriate person. This will help us to gradually perfect this Spreadsheet for the
benefit of all concerned.
WHETHER TO

n analysis, a copy
ry should be made
A-MAIN") remains

n any period(s) is(are)


d YEAR(S) in FORM-II only.

nts incorporated

Projections"

u, for easy reading.

OF MONTHS cells in any


n entered in FORM-II.

THE CELLS
be auto-generated.
ormat & Formulae.

S ( "FORM-IV"
what you have entered
AVE BEEN TOTALLY

RM-III (owing to
"CHECK". This is not an
or record. Please note
xtracted from FORM-III
ar) and NOT from FORM-II.
y to Gross Block.

sistency / difficulty
lease refer back to the
preadsheet for the
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
FORM II - OPERATING STATEMENT

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS

Amounts in Rs. Lacs

Actuals Provisional Esimated Projected


Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12
1. Gross Sales
i. Domestic Sales 136.34 155.98 180.00 210.00
ii. Export Sales
Total 136.34 155.98 180.00 210.00
2. Less Excise Duty
3. Net Sales (1 - 2) 136.34 155.98 180.00 210.00
4. % age rise (+) or fall (-) in net sales
as compared to previous year (annualised) 14.41% 15.40% 16.67%
5. Cost of Sales
i. Raw materials (including stores and
other items used in the process of
manufacture) 76.95 82.14 98.90 113.00
a. Imported 0.00 0.00 0.00 0.00
b. Indigenous 76.95 82.14 98.90 113.00
ii. Other Spares 0.00 0.00 0.00 0.00
a. Imported 0.00 0.00 0.00 0.00
b. Indigenous 0.00 0.00 0.00 0.00
iii. Power and Fuel 0.00
iv. Direct Labour (Factory wages & salaries) 31.70 34.20 45.00 48.90
v. Other manufacturing expenses 17.31 22.36 26.40 30.24
vi. Depreciation 0.02 0.26 0.30 0.35
vii. Sub-total (i to vi) 125.98 138.96 170.60 192.49

viii. Add: Opening Stock-in-process 0.00 0.00 0.00


Sub-total (vii + viii) 125.98 138.96 170.60 192.49
ix. Deduct: Closing Stock-in-process
x. Cost of Production 125.98 138.96 170.60 192.49
xi. Add: Opening Stock of finished goods 18.69 21.37 18.24 25.00
Sub-total (x + xi) 144.67 160.33 188.84 217.49
xii. Deduct: Closing Stock of finished goods 21.37 18.24 25.00 26.00
xiii. Sub-total (Total Cost of Sales) 123.30 142.09 163.84 191.49

6. Selling, general and administrative expenses 4.54 4.80 5.60 6.51


7. Sub-total (5 + 6) 127.84 146.89 169.44 198.00
8. Operating Profit before Interest (3 - 7) 8.50 9.09 10.56 12.00
9. Interest 3.19 3.01 3.50 3.70

10. Operating Profit after Interest (8 - 9) 5.31 6.08 7.06 8.30


11. i. Add: Other non-operating Income
a. Sale of Fixed Assets
b. Others
c.
d.
Sub-total (Income) 0.00 0.00 0.00 0.00
ii. Deduct: Other non-operating expenses 0.00 0.00 0.00 0.00
a. Miscellaneous Expenses 0.00 0.00 0.00 0.00
b.
c.
d.
Sub-total (Expenses) 0.00 0.00 0.00 0.00
iii. Net of other non-operating income /
expenses [net of 11(i) & 11(ii)] 0.00 0.00 0.00 0.00
12. Profit before tax/loss [10 + 11(iii)] 5.31 6.08 7.06 8.30
13. a) Provision for taxes
b) Deferred for Tax Liability(+) Assets(-) 0.00 0.00 0.00
14. Net Profit / Loss (12 -13) 5.31 6.08 7.06 8.30
15. a. Equity dividend paid-amount
(Already paid + B.S. provision) 0.00 0.00 0.00 0.00
b. Dividend Rate (% age) 0.0% 0.0% 0.0% 0.0%
c. Other Appropriations 3.60 4.00 4.40 4.40
16. Retained Profit (14 - 15) 1.71 2.08 2.66 3.90
17. Retained Profit / Net Profit (% age) 32.20% 34.21% 37.68% 46.99%

CASH ACCRUAL 5.33 6.34 7.36 8.65


FORM III - ANALYSIS OF BALANCE SHEET
LIABILITIES

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS

Amounts in Rs. Lacs

Actuals Provisional Esimated Projected


Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12
CURRENT LIABILITIES
1. Short-term borrowing from banks (including
bills purchased, discounted & excess
borrowing placed on repayment basis)
i. State Bank of India 20.26 14.08 25.00 25.00
ii. Others
iii. (of which BP & BD) 0.00 0.00 0.00 0.00
Sub-total [i + ii] (A) 20.26 14.08 25.00 25.00
2. Short term borrowings from others
3. Sundry Creditors (Trade) 4.47 6.20 6.00 6.00
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 1 year) 0.00 0.00 0.00 0.00
8. Deposits / instalments of term loans /
DPGs / debentures etc. (due within 1 year) 0.00 0.00 0.00 0.00
9. Other current liabilities & provisions
(due within 1 year) - specify major items 0.00 0.00 0.00 0.00
a. Other Outstanding Liabilities payable 0.00 0.00 0.00 0.00
b. Other Liabilities
c. PROVISIONS 0.00 0.00 0.00
d. OTHERS 0.00 0.00 0.00 0.00
Sub total [2 to 9] (B) 4.47 6.20 6.00 6.00
10. Total current liabilities [A + B] 24.73 20.28 31.00 31.00

TERM LIABILITIES
11. Debentures (not maturing within 1 year) 0.00 0.00 0.00 0.00
12. Preference Shares (redeemable after 1 year) 0.00 0.00 0.00 0.00
13. Term loans (excluding instalments
payable within 1 year)
14. Deferred Payment Credits (excluding
instalments due within 1 year) 0.00 0.00 0.00 0.00
15. Term deposits (repayable after 1 year) 0.00 0.00 0.00 0.00
16. Other term liabilities
17. Total Term Liabilities [11 to 16] 0.00 0.00 0.00 0.00
18. Total Outside Liabilities [10 + 17] 24.73 20.28 31.00 31.00

NET WORTH
19. Ordinary Share Capital 13.74 13.75 13.74 13.74
20. General Reserve
21. Revaluation Reserve 0.00 0.00 0.00 0.00
22. Other Reserves (excluding Provisions) 0.00 0.00 0.00 0.00
23. Surplus (+) or deficit (-) in Profit & Loss a/c
(EXCLUDING Deferref Tax Liability A/c) 0.00 2.08 4.74 8.64
23. a. Share Application money 0.00 0.00
b. Share Premium Account 0.00 0.00 0.00 0.00
c. Deferred Tax Liability A/c 0.00 0.00 0.00 0.00
d. Others 0.00 0.00 0.00 0.00
e. 0.00 0.00 0.00 0.00
24. Net Worth 13.74 15.83 18.48 22.38

25. TOTAL LIABILITIES [18 + 24] 38.47 36.11 49.48 53.38


FORM III - ANALYSIS OF BALANCE SHEET (Continued)
ASSETS

Amounts in Rs. Lacs

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS

Actuals Provisional Esimated Projected


Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12
CURRENT ASSETS
26. Cash and Bank Balances 2.85 2.99 3.09 3.73
27. Investments (other than long term) 1.39 3.96 6.00 7.00
i. Govt. and other trustee securities 1.39 3.96 6.00 7.00
ii. Fixed Deposits with banks 0.00 0.00 0.00 0.00
28. i. Receivables other than deferred &
exports (incldg. bills purchased and
discounted by banks)
ii. Export receivables (incldg. bills
purchased/discounted by banks) 0.00 0.00 0.00 0.00
29. Instalments of deferred receivables
(due within 1 year) 0.00 0.00 0.00 0.00
30. Inventory: 21.37 18.24 25.00 26.00
i. Raw materials (including stores and
other items used in the process of
manufacture) 0.00 0.00 0.00 0.00
a. Imported 0.00 0.00 0.00 0.00
b. Indigenous
ii. Stocks-in-process 0.00 0.00 0.00 0.00
iii. Finished goods 21.37 18.24 25.00 26.00
iv. Other consumable spares 0.00 0.00 0.00 0.00
a. Imported 0.00 0.00 0.00 0.00
b. Indigenous 0.00 0.00 0.00 0.00
31. Advances to suppliers of raw materials
and stores/spares 0.00 0.00 0.00 0.00
32. Advance payment of taxes 5.42 3.49 5.00 5.50
33. Other current assets (specify major items) 7.27 5.73 8.50 9.00
a.
b. Sundry debtors 7.27 5.73 8.50 9.00
c. 0.00 0.00 0.00 0.00
d. 0.00 0.00 0.00 0.00
34. Total Current Assets (26 to 33) 38.30 34.41 47.59 51.23

FIXED ASSETS
35 Gross Block (land, building, machinery,
work-in-progress) 0.19 1.96 2.19 2.50
36 Depreciation to date 0.02 0.26 0.30 0.35
37 Net Block (35 - 36) 0.17 1.70 1.89 2.15

OTHER NON-CURRENT ASSETS


38 Investments/book debts/advances/deposits
which are not current assets 0.00 0.00 0.00 0.00
i. a. Investments in subsidiary
companies / affiliates 0.00 0.00 0.00 0.00
b. Others 0.00 0.00 0.00
ii. Advances to suppliers of capital goods
and contractors 0.00 0.00 0.00 0.00
iii. Deferred receivables (maturity
exceeding 1 year) 0.00 0.00 0.00 0.00
iv. Others 0.00 0.00 0.00 0.00
a. Security Deposit 0.00 0.00 0.00 0.00
b. Sales Tax under Appeal 0.00 0.00 0.00 0.00
c. Tax Deducted at Source 0.00 0.00 0.00 0.00
d. Others 0.00 0.00 0.00 0.00
39 Non-consumable stores and spares 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 (38 to 40) 0.00 0.00 0.00 0.00

42 Intangible Assets (patents, good will,


prelim.expenses, bad / doubtful debts not
provided for, etc.
43 Total Assets (34+37+41+42) 38.47 36.11 49.48 53.38
44 Tangible Net Worth (24 - 42) 13.74 15.83 18.48 22.38
45 Net Working Capital (34 - 10) 13.57 14.13 16.59 20.23

46 Current Ratio (34 / 10) 1.55 1.70 1.54 1.65


47 Total OUTSIDE Liabilities / Tangible
Net Worth (18 / 44) 1.80 1.28 1.68 1.39
48 Total TERM Liabilities / Tangible
Net Worth (17 / 44)

RATIOS NET OF REVALUATION


RESERVES
49 TANGIBLE NET WORTH (24-21-42) 13.74 15.83 18.48 22.38
50 TOTAL OUTSIDE LIAB/TNW 1.80 1.28 1.68 1.39
51 TOTAL TERM LIAB/TNW 0.00 0.00 0.00 0.00

ADDITIONAL INFORMATION
A. Arrears of depreciation 0.00 0.00 0.00 0.00
B. Contingent Liabilities:
i. Arrears of cumulative dividends 0.00 0.00 0.00 0.00
ii. Gratuity liability not provided for 0.00 0.00 0.00 0.00
iii. Disputed excise / customs /
tax liabilities 0.00 0.00 0.00 0.00
iv. Other liabilities not provided for 0.00 0.00 0.00 0.00
FORM IV
COMPARATIVE STATEMENT OF CURRENT ASSETS AND CURRENT LIABILITIES

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS

Amounts in Rs.Lacs

Actuals Provisional Esimated Projected


Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12
A. CURRENT ASSETS
1. Raw materials (incl. stores & other items
used in the process of manufacture)
a. Imported 0.00 0.00 0.00 0.00
Month's Consumption
b. Indigenous 0.00 0.00 0.00 0.00
Month's Consumption
2. Other Consumable spares, excluding
those included in 1 above
a. Imported 0.00 0.00 0.00 0.00
Month's Consumption
b. Indigenous 0.00 0.00 0.00 0.00
Month's Consumption
3. Stock-in-process 0.00 0.00 0.00 0.00
Month's cost of production
4. Finished goods 21.37 18.24 25.00 26.00
Month's cost of sales (2.08) (1.54) (1.83) (1.63)
5. Receivables other than export & deferred
receivables (incl. bills purchased &
discounted by bankers) 0.00 0.00 0.00 0.00
Month's domestic sales: excluding
deferred payment sales
6. Export receivables (incl. bills purchased
and discounted) 0.00 0.00 0.00 0.00
Month's export sales
7. Advances to suppliers of raw materials &
stores / spares, consumables 0.00 0.00 0.00 0.00
8. Other current assets incl. cash & bank
balances & deferred receivables due
within one year 16.93 16.17 22.59 25.23
Cash and Bank Balances 2.85 2.99 3.09 3.73
Investments (other than long term): 1.39 3.96 6.00 7.00
i. Govt. and other trustee securities 1.39 3.96 6.00 7.00
ii. Fixed Deposits with banks 0.00 0.00 0.00 0.00
Instalments of deferred receivables
(due within 1 year) 0.00 0.00 0.00 0.00
Advance payment of taxes 5.42 3.49 5.00 5.50
Other current assets 7.27 5.73 8.50 9.00
9. Total Current Assets 38.30 34.41 47.59 51.23
(To agree with item 34 in Form III)

FORM IV
COMPARATIVE STATEMENT OF CURRENT ASSETS AND CURRENT LIABILITIES

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS

Amounts in Rs.Lacs

Actuals Provisional Esimated Projected


Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12
B. CURRENT LIABILITIES
(Other than bank borrowings for working capital)

10. Creditors for purchase of raw materials,


stores & consumable spares 4.47 6.20 6.00 6.00
Month's purchases (0.91) (0.73) (0.64)
11. Advances from customers 0.00 0.00 0.00 0.00
12. Statutory liabilities 0.00 0.00 0.00 0.00
13 Other current liabilities: 0.00 0.00 0.00 0.00
Short term borrowings from others 0.00 0.00 0.00 0.00
Provision for taxation 0.00 0.00 0.00 0.00
Dividend payable 0.00 0.00 0.00 0.00
Deposits / instalments of term loans / DPGs
/ debentures etc. (due within 1 year) 0.00 0.00 0.00 0.00
Other current liabilities & provisions
(due within 1 year) 0.00 0.00 0.00 0.00
14. Total (To agree with total B of Form-III) 4.47 6.20 6.00 6.00
FORM VI
FUNDS FLOW STATEMENT

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS

Amounts in Rs. Lacs

Provisional Esimated Projected


Financial Year ended / ending 2013 2014 2015
No.of months 12 12 12
1. SOURCES
a. Net Profit 6.08 7.06 8.30
b. Depreciation 0.24 0.04 0.05
c. Increase in Capital 0.01 -0.01 0.00
d. Increase in Term Liabilities
(including Public Deposits) 0.00 0.00 0.00
e. Decrease in
i. Fixed Assets
ii. Other non-current Assets
f. Others 0.00 0.00 0.00
g. TOTAL 6.33 7.09 8.35

2. USES
a. Net loss
b. Decrease in Term Liabilities
(including Public Deposits) 0.00 0.00 0.00
c. Increase in
i. Fixed Assets 1.77 0.23 0.31
ii. Other non-current Assets 0.00 0.00 0.00
d. Dividend Payments 0.00 0.00 0.00
e. Others 0.00 0.00 0.00
f. TOTAL 1.77 0.23 0.31

3. Long Term Surplus (+) / Deficit (-) [1-2] 4.56 6.86 8.04
4. Increase/decrease in current assets
* (as per details given below) -3.89 13.18 3.64
5. Increase/decrease in current liabilities
other than bank borrowings 1.73 -0.20 0.00
6. Increase/decrease in working capital gap -5.62 13.38 3.64
7. Net Surplus / Deficit (-) [3-6] 10.18 -6.52 4.40
8. Increase/decrease in bank borrowings -6.18 10.92 0.00
9. Increase/decrease in NET SALES 19.64 24.02 30.00

* Break up of item-4
i. Increase/decrease in Raw Materials 0.00 0.00 0.00
ii. Increase/decrease in Stocks-in-Process 0.00 0.00 0.00
iii. Increase/decrease in Finished Goods -3.13 6.76 1.00
iv. Increase/decrease in Receivables
a) Domestic 0.00 0.00 0.00
b) Export 0.00 0.00 0.00
v. Increase/decrease in Stores & Spares 0.00 0.00 0.00
vi. Increase/decrease in other current assets -0.76 6.42 2.64
TOTAL -3.89 13.18 3.64
ASSESSED BANK FINANCE

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS

Amounts in Rs. Lacs


Provisional Esimated Projected
Financial Year ended / ending 2013 2014 2015
No.of months 12 12 12

Total Current Assets 34.41 47.59 51.23


Current Liabilities (Other than Bank
Borrowing) 6.20 6.00 6.00
Working Capital Gap 28.21 41.59 45.23
Net Working Capital (Actual /Projected) 14.13 16.59 20.23
Assessed Bank Finance (ABF) 14.08 25.00 25.00
NWC/TCA (%) 41.06% 34.86% 39.49%
Bank Finance to TCA (%) 40.92% 52.53% 48.80%
Other CL/TCA (%) 18.02% 12.61% 11.71%
S. Creditors /TCA (%) 18.02% 12.61% 11.71%
Inv./NS (Days) 42.68 50.69 45.19
Rec./ Gross Sales (Days) 0.00 0.00 0.00
S. Creditors /Purchase (Days) 27.55 22.14 19.38
CHECK

M/S. M. DAS &Name:


SONS, PROP: MR. MADHABANANDA DAS

Amounts in Rs. Lacs

Actuals Provisional Esimated Projected


Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12
1. Closing Stock in Process
of Operating Stament tallies Yes Yes Yes Yes
with that of Balance Sheet

2. Closing Stock of F.G.


of Operating Stament tallies Yes Yes Yes Yes
with that of Balance Sheet

3. Net Profit 5.31 6.08 7.06 8.30

4. Depreciation Reported in
Operating Statement tallies No No No
with that of Balance Sheet
a. As per Op Statement 0.26 0.30 0.35
b. As per Form-III 0.24 0.04 0.05
c. Difference 0.02 0.26 0.30

5. Balance Sheet Assets is Yes Yes Yes Yes


equal to Liabilities

a. Total Assets 38.47 36.11 49.48 53.38


b. Total Liabilities 38.47 36.11 49.48 53.38
c. Difference - - - -

6 Net Funds Outflow/Inflow :


a.Net Surplus/Deficit 10.18 6.52 4.40
(Item-8 of Form-VI)
b.Increase/Decrease in Bank Borrowing
(Item-9 of Form-VI) 6.18 10.92 0.00
c. Difference 4.00 -4.40 4.40

*** In case there are Differences under Checks- 5 or 6 above, these should be zeroised.
Any Diffence under Check-4 should be explained at the appropriate place in the Appraisal Memorandum.
PERFORMANCE & FINANCIAL INDICATORS

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS


Amounts in Rs. Lacs
Actuals Provisional Esimated Projected
Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12

Net sales 136.34 155.98 180.00 210.00


Operating Profit 8.50 9.09 10.56 12.00
Net Other Income 0.00 0.00 0.00 0.00
Profit Before Tax 5.31 6.08 7.06 8.30
PBT/NS (%) 3.89% 3.90% 3.92% 3.95%
Profit After Tax 5.31 6.08 7.06 8.30
Cash Accruals 5.33 6.34 7.36 8.65
Paid Up Capital 13.74 13.75 13.74 13.74
Tangible Net Worth 13.74 15.83 18.48 22.38
Adj TNW (Excl. Invest/Loans in Subsidiaries) 13.74 15.83 18.48 22.38
TOL/TNW 1.80 1.28 1.68 1.39
Total Term Lia./TNW 0.00 0.00 0.00 0.00
Current Ratio 1.55 1.70 1.54 1.65
Total Tangible Assets (TTA) 38.47 36.11 49.48 53.38

EFFICIENCY RATIOS : 2012 2013 2014 2015


Net Sales/TTA (Times) 3.54 4.32 3.64 3.93
PBT/TTA (%) 13.80% 16.84% 14.27% 15.55%
Operating Cost/NS (%) 93.77% 94.17% 94.13% 94.29%
Bank Fin./Curr. Assets (%) 52.90% 40.92% 52.53% 48.80%
Inv. +Rec./NS (Days) 57 43 51 45

LIQUIDITY RATIOS 2012 2013 2014 2015


Current Ratio 1.55 1.70 1.54 1.65
Acid Test Ratio 0.68 0.80 0.73 0.81
Bank Finance to WCG (%) 59.89% 49.91% 60.11% 55.27%

LEVERAGE RATIOS 2012 2013 2014 2015


Debt : Equity Ratio 0.00 0.00 0.00 0.00
TOL/TNW 1.80 1.28 1.68 1.39
Debt : Assets Ratio 0.00 0.00 0.00 0.00
Fixed Assets Coverage Ratio 0.00 0.00 0.00 0.00
Interest Coverage Ratio 2.67 3.11 3.10 3.34

TURNOVER RATIOS 2012 2013 2014 2015


Inventory Turnover Period (DAYS) 57 43 51 45
Average Collection Period (DAYS) 0 0 0 0
Total Assets Turnover (TIMES) 3.54 4.32 3.64 3.93
Average Credit Period (DAYS) 28 22 19
Bank Finance Turnover 6.73 11.08 7.20 8.40
Current Assets Turnover 3.56 4.53 3.78 4.10

PROFITABILITY RATIOS 2012 2013 2014 2015


Net Profit Margin (%) 3.89% 3.90% 3.92% 3.95%
Net Income : Assets Ratio (%) 13.80% 16.84% 14.27% 15.55%
Return on Investment (ROCE)(%) 22.15% 25.89% 21.95% 23.14%
Return on Equity (%) 38.65% 44.22% 51.38% 60.41%
Operating Profitability (%) 6.23% 5.83% 5.87% 5.71%
Pre-Tax Profitability (%) 3.89% 3.90% 3.92% 3.95%
PBT/TTA (%) 13.80% 16.84% 14.27% 15.55%

STRUCTURAL RATIOS 2012 2013 2014 2015


Retained Profit (%) 32.20% 34.21% 37.68% 46.99%
Raw Material Content (%) 61.08% 59.11% 57.97% 58.70%
Operating Cost/Sales (%) 93.77% 94.17% 94.13% 94.29%
FINANCIAL SUMMARY

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS

Amounts in Rs. Lacs


2012 2013 2014 2015
1. Gross Sales - Domestic 136.34 155.98 180.00 210.00
- Exports 0.00 0.00 0.00 0.00
2. Less Excise Duty 0.00 0.00 0.00 0.00
3. Net Sales (1 - 2) 136.34 155.98 180.00 210.00
4. Depreciation 0.02 0.26 0.30 0.35
5. Operating Profit (before Interest) 8.50 9.09 10.56 12.00
6. Interest 3.19 3.01 3.50 3.70
7. PBT 5.31 6.08 7.06 8.30
8. Tax 0.00 0.00 0.00 0.00
9. PAT 5.31 6.08 7.06 8.30
10. PBDIT (4+6+7) 8.52 9.35 10.86 12.35
11. Paid Up Capital (PUC) 13.74 13.75 13.74 13.74
12. Total Outside Liabilities (TOL) 24.73 20.28 31.00 31.00
13. Tangible Net Worth (TNW) 13.74 15.83 18.48 22.38
14. Adjusted TNW 13.74 15.83 18.48 22.38
15. Total Assets 38.47 36.11 49.48 53.38
16.. Intangible Assets 0.00 0.00 0.00 0.00
17. TTA (15-16) 38.47 36.11 49.48 53.38
18. PBDIT/INT (10/6) 2.67 3.11 3.10 3.34
19. PBT/Net Sales 3.89% 3.90% 3.92% 3.95%
20. PAT/Net Sales 3.89% 3.90% 3.92% 3.95%
21. ROCE (PBDIT/TTA) 22.15% 25.89% 21.95% 23.14%
22. (INV+RECV)/NET SALES (Days) 57 43 51 45
24. Current Ratio 1.55 1.70 1.54 1.65
25. TOL/TNW 1.80 1.28 1.68 1.39
26. TOL/TNW (Adjusted) 1.80 1.28 1.68 1.39
27. Cash Accrual 5.33 6.34 7.36 8.65

FUNDS FLOW ANALYSIS

2013 2014 2015


1. Long Term Sources 6.33 7.09 8.35
2. Long Term Uses 1.77 0.23 0.31
3. Surplus/Deficit 4.56 6.86 8.04
DATA ANALYSIS

Name: M/S. M. DAS & SONS, PROP: MR. MADHABANANDA DAS


OPERATING STATEMENT

Amounts in Rs. Lacs

Actuals Provisional Esimated Projected


Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12

Excise Duty : Gross Sales 0.00% 0.00% 0.00% 0.00%


Annual Growth in Net Sales 14.41% 15.40% 16.67%

1 RATIO OF NET SALES TO :


i. Raw materials (including stores and
other items used in the process of
manufacture) 56.44% 52.66% 54.94% 53.81%
a. Imported 0.00% 0.00% 0.00% 0.00%
b. Indigenous 56.44% 52.66% 54.94% 53.81%
ii. Other Spares 0.00% 0.00% 0.00% 0.00%
a. Imported 0.00% 0.00% 0.00% 0.00%
b. Indigenous 0.00% 0.00% 0.00% 0.00%
iii. Power and Fuel 0.00% 0.00% 0.00% 0.00%
iv. Direct Labour (Factory wages & salaries) 23.25% 21.93% 25.00% 23.29%
v. Other manufacturing expenses 12.70% 14.34% 14.67% 14.40%
vi. Depreciation 0.01% 0.17% 0.17% 0.17%
vii. Selling, general and administrative expenses 0.73% 0.64% 0.56% 0.48%
viii. Interest 2.34% 1.93% 1.94% 1.76%

2 COMPOSITION OF COST OF SALES : 2012 2013 2014 2015

i. Raw materials (including stores and


other items used in the process of
manufacture) 62.41% 57.81% 60.36% 59.01%
a. Imported 0.00% 0.00% 0.00% 0.00%
b. Indigenous 62.41% 57.81% 60.36% 59.01%
ii. Other Spares 0.00% 0.00% 0.00% 0.00%
a. Imported 0.00% 0.00% 0.00% 0.00%
b. Indigenous 0.00% 0.00% 0.00% 0.00%
iii. Power and Fuel 0.00% 0.00% 0.00% 0.00%
iv. Direct Labour (Factory wages & salaries) 25.71% 24.07% 27.47% 25.54%
v. Other manufacturing expenses 14.04% 15.74% 16.11% 15.79%
vi. Depreciation 0.02% 0.18% 0.18% 0.18%
vii. Accretion/Depletion in SIP & FG Stocks -2.17% 2.20% -4.13% -0.52%
CHECK TOTAL 100.00% 100.00% 100.00% 100.00%

3 PERCENTAGE GROWTHS : 2012 2013 2014 2015

i. Gross Sales 14.41% 15.40% 16.67%


ii. Gross Domestic Sales 14.41% 15.40% 16.67%
iii. Gross Exports
iv. Net Sales 14.41% 15.40% 16.67%
v. Total Raw Materials 6.74% 20.40% 14.26%
vi. Imported Raw Materials
vii. Indegenous Raw Materials 6.74% 20.40% 14.26%
viii. Other Spares
ix. Imported Spares
x. Indegenous Spares
xi. Power and Fuel #DIV/0! #DIV/0! #DIV/0!
xii. Direct Labour (Factory wages & salaries) 7.89% 31.58% 8.67%
xiii. Other manufacturing expenses 29.17% 18.07% 14.55%
xiv. Depreciation 1200.00% 15.38% 16.67%
xv. Selling, general and administrative expenses 5.73% 16.67% 16.25%
xvi. Interest -5.64% 16.28% 5.71%

4 Non-Operating Income / Net Sales 0.00% 0.00% 0.00% 0.00%


5 Non-Operating Income / PBT 0.00% 0.00% 0.00% 0.00%
6 Net Profit / PBT 100.00% 100.00% 100.00% 100.00%
7 Retained Profit / Net Profit 32.20% 34.21% 37.68% 46.99%
8 Cash Accrual / Net Sales 3.91% 4.06% 4.09% 4.12%
9 Average Cost of Borrowings 15.75% 21.38% 14.00% 14.80%
BALANCE SHEET

Actuals Provisional Esimated Projected


Financial Year ended / ending 2012 2013 2014 2015
No.of months 12 12 12 12

1 COMPOSITION OF CURRENT LIABILITIES


i. Short-term borrowing from banks 81.92% 69.43% 80.65% 80.65%
ii. Short term borrowings from others 0.00% 0.00% 0.00% 0.00%
iii. Sundry Creditors (Trade) 18.08% 30.57% 19.35% 19.35%
iv. Advance payments from customers 0.00% 0.00% 0.00% 0.00%
v. Provision for taxation 0.00% 0.00% 0.00% 0.00%
vi. Dividend payable 0.00% 0.00% 0.00% 0.00%
vii. Other statutory liabilities (due within 1 year) 0.00% 0.00% 0.00% 0.00%
viii. Instalments payable within 1 year 0.00% 0.00% 0.00% 0.00%
ix. Other current liabilities & provisions 0.00% 0.00% 0.00% 0.00%
CHECK TOTAL 100.00% 100.00% 100.00% 100.00%

2 ANNUAL GROWTH : LIABILITIES 2012 2013 2014 2015

i. Short-term borrowing from banks -30.50% 77.56% 0.00%


ii. Short term borrowings from others
iii. Sundry Creditors (Trade) 38.70% -3.23% 0.00%
iv. Advance payments from customers
v. Provision for taxation
vi. Dividend payable
vii. Other statutory liabilities (due within 1 year)
viii. Instalments payable within 1 year #DIV/0! #DIV/0! #DIV/0!
ix. Other current liabilities & provisions 38.70% -3.23% 0.00%
x. Total Current Liabilities -17.99% 52.86% 0.00%
xi. Total Term Liabilities #DIV/0! #DIV/0! #DIV/0!
xii. Total Outside Liabilities -17.99% 52.86% 0.00%
xiii. Net Worth 15.21% 16.74% 21.10%
xiv. Tangible Net Worth 15.21% 16.74% 21.10%

3 COMPOSITION OF CURRENT ASSETS 2012 2013 2014 2015

i. Cash and Bank Balances 7.44% 8.69% 6.49% 7.28%


ii. Investments (other than long term) 3.63% 11.51% 12.61% 13.66%
iii. Receivables 0.00% 0.00% 0.00% 0.00%
iv. Instalments of deferred receivables 0.00% 0.00% 0.00% 0.00%
v. Inventory: 55.80% 53.01% 52.53% 50.75%
vi. Raw materials 0.00% 0.00% 0.00% 0.00%
vii. Stocks-in-process 0.00% 0.00% 0.00% 0.00%
viii. Finished goods 55.80% 53.01% 52.53% 50.75%
ix. Other consumable spares 0.00% 0.00% 0.00% 0.00%
x. Advances to suppliers of raw materials 0.00% 0.00% 0.00% 0.00%
xi. Advance payment of taxes 14.15% 10.14% 10.51% 10.74%
xii. Other current assets 18.98% 16.65% 17.86% 17.57%
CHECK TOTAL 100.00% 100.00% 100.00% 100.00%

4 ANNUAL GROWTH : ASSETS 2012 2013 2014 2015

i. Cash and Bank Balances 4.91% 3.34% 20.71%


ii. Investments (other than long term) 184.89% 51.52% 16.67%
iii. Receivables #DIV/0! #DIV/0! #DIV/0!
iv. Instalments of deferred receivables
v. Inventory: -14.65% 37.06% 4.00%
vi. Raw materials #DIV/0! #DIV/0! #DIV/0!
vii. Stocks-in-process
viii. Finished goods -14.65% 37.06% 4.00%
ix. Other consumable spares
x. Advances to suppliers of raw materials #DIV/0! #DIV/0! #DIV/0!
xi. Advance payment of taxes -35.61% 43.27% 10.00%
xii. Other current assets -21.18% 48.34% 5.88%
xiii. Total Current Assets -10.16% 38.30% 7.65%
xiv. Gross Block 931.58% 11.73% 14.16%
xv. Net Block 900.00% 11.18% 13.76%
xvi. Total Other Non-current Assets
xvii. Intangible Assets #DIV/0! #DIV/0! #DIV/0!
xviii. Net Working Capital 4.13% 17.41% 21.94%

2012 2013 2014 2015


5 TOL / TNW 1.80 1.28 1.68 1.39
6 (TL + Net Worth) : Net Block 8082.35% 931.18% 977.78% 1040.93%
7 (TL + TNW) : Tangible Non Current Assets 8082.35% 931.18% 977.78% 1040.93%
8 Net Block : TL #DIV/0! #DIV/0! #DIV/0! #DIV/0!
9 (Inventories + Rec) : S.T. Bank Borrowings 105.48% 129.55% 100.00% 104.00%
10 Current Assets : S.T. Bank Borrowings 189.04% 244.39% 190.36% 204.92%
11 PL Depreciation : Average Gross Block 10.53% 24.19% 14.46% 14.93%

You might also like