Assessment of Working Capital Requirements
Assessment of Working Capital Requirements
Assessment of Working Capital Requirements
FORM - I
PARTICULARS OF EXISTING / PROPOSED LIMITS FROM THE BANKING SYSTEM
(Limits from all Banks and Financial Institutions as on date of application)
Name: JEEVAN CHEMICALS & PHARMACEUTICALS ( Rs.in lakhs )
Sl. No.
NAME OF BANK / FINANCIALNATURE OF FACILITY EXISTING EXTENT TO WHICH LIMITS BAL.O/S LIMITS NOW
INSTITUTION LIMITS WERE UTILISED DURING AS ON REQUESTED
LAST 12 MONTHS 31.3.2019 2019-2020
MAX. MIN.
A. WORKING CAPITAL LIMITS:
Sl. No. Name of the Associate Annual makeup of A/c Limits from all Banks and fincial institutions
Company & Activity (Date of B/S)
Name of Working Capital Term loan Overdues,if
Bank/finan Funds Non-fund & any
cial Instn. Based Based DPG
Contd...2
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
4. OPERATING PROFIT BEFORE INTEREST[1(III) - 2(XI) - 3] 37.29 38.90 48.82 58.67 66.25 77.51
10.95% 10.49% 10.44% 10.48% 10.04% 10.07%
5. INTEREST AND FINANCIAL CHARGES
- Interest on Working Capital 9.78 9.76 7.81 10.50 10.50 10.50
- Interest on Term Loan 5.60 2.12 4.98 4.78 4.60 4.40
7. OPERATING PROFIT AFTER INTEREST [4 - 5 - 6] 21.91 27.02 36.03 43.39 51.15 62.61
9. PROFIT BEFORE TAX / (LOSS) [7 + 8(III)] 22.44 28.56 36.03 43.39 51.15 62.61
11. NET PROFIT/LOSS (9-10) 22.44 28.56 36.03 43.39 51.15 62.61
PBT to Sales % 6.59% 7.70% 7.70% 7.75% 7.75% 8.13%
Contd...3
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
13. RETAINED PROFIT (11-12) 22.44 28.56 36.03 43.39 51.15 62.61
Contd...4
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
Contd...5
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
NET WORTH
19. Share capital 116.73 170.62 206.13 263.50 345.95 453.93
20. General reserve
21. Revaluation Reserve
22. Other reserves ( excluding provisions )
23. Surplus (+) or deficit (-) in
Profit & Loss account - - - - - -
24. NET WORTH 116.73 170.62 206.13 263.50 345.95 453.93
25. TOTAL LIABILITIES ( 18 + 24 ) 510.18 513.46 652.58 674.24 742.03 841.08
Contd...6
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
26. Cash and bank balances 6.01 0.84 0.64 1.89 5.28 13.51
27. Investments (other than long term Investments)
(I) Government & other trustee securities
(II) Fixed deposits with Banks
28. (I) Receivables other than deferred & exports 117.76 107.20 72.01 100.00 145.00 200.00
(Including bills purchased & discounted by bankers)
(II) Export receivables (Including bills - - - - - -
purchased/discounted by bankers
29. Instalments under deferred receivables - - - - - -
(due within one year)
30. Raw Materials( including stores & other items)
- Imported - - - - - -
- Indigeneous
Stocks in Process - - - - - -
Finished goods 42.12 32.48 68.00 65.00 70.00 80.00
Goods in Transit - - - - - -
Other consumable spares - - - - - -
31. Advances to suppliers of merchandise - - - -
32. Advance payment of taxes 1.00 2.00 0.75 2.50 5.00 10.00
33. Other current assets 0.25 2.55 - 6.00 12.00 18.00
(specify major Items)
34. TOTAL CURRENT ASSETS
(Total of 26 to 33) 167.14 145.07 141.40 175.39 237.28 321.51
Contd...7
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
35. Gross Block (land, building, machinery, furniture, fittings & vehicl 73.40 72.29 170.30 166.65 163.49 160.75
36. Depreciation to date 4.38 4.04 3.65 3.16 2.74 2.38
37. NET BLOCK (35-36) 69.02 68.25 166.65 163.49 160.75 158.37
Contd...8
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
10. Sundry Creditors ( Trade ) 46.69 75.07 47.99 24.00 25.00 26.00
(Months' purchases) (2.19) (3.77) (1.63) (0.76) (0.64) (0.59)
11. Advances from customers/deposits from dealers - - - - - -
12. Statutory liabilities [Including Provision for Taxation] - - - - - -
13. Other current liabilities (specify major items) -
Short Term borrowings, unsecured loans, dividend payable,
instalments of TL, DPG,public deposits, debentures etc.) 7.37 5.90 6.48 7.00 1.00 1.50
14. TOTAL ( To agree with sub total B Form - III ) 54.06 80.97 54.47 31.00 26.00 27.50
Contd...9
- - - - - -
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
FORM - V : COMPUTATION OF MAXIMUM PERMISSIBLE BANK FINANCE FOR WORKING CAPITAL [MPBF]
1. TOTAL CURRENT ASSETS (9 in Form -IV) 167.14 141.40 175.39 237.28 321.51
2. Other Current Liabilities (Other than bank borrowing) 54.06 54.47 31.00 26.00 27.50
3. Working capital gap (WCG) (1-2) 113.08 86.93 144.39 211.28 294.01
4. Minimum Stipulated Net Working Capital 28.27 21.73 36.10 52.82 73.50
i.e.25% of WCG
8. Maximum permissible bank finance [MPBF] (251.16) (338.05) (335.36) (344.00) (361.20)
NWC (4-5) - - - - -
Contd…10
ASSESSMENT OF WORKING CAPITAL REQUIREMENTS
RATIO ANALYSIS
EFFICIENCY RATIOS:
Net Sales / Total Tangible Assets (Times) >1.50 1.44 1.74 1.52 1.65 1.66 1.60
PBT / TTA (%) >5.00% 9.50% 13.39% 11.70% 12.80% 12.85% 13.05%
Operating Cost / Net Sales (%) <75.00% 93.57% 92.71% 92.30% 92.25% 92.25% 91.87%
Bank Finance / Current Assets (%) <50.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Inventory+Receivables / Net Sales (Days) <60 Days 45 32 53 42 39 38
LIQUIDITY RATIOS:
Current Ratio >1.33 3.09 1.79 2.32 5.66 9.13 11.69
Acid Test Ratio >1.00 2.31 1.39 1.20 3.56 6.43 8.78
Bank Finance to WCG Ratio <0.75 - - - - - -
LEVERAGE RATIOS:
Debt Equity Ratio <2.00 2.91 1.53 1.87 1.44 1.07 0.79
TOL / TNW <3.00 3.37 2.01 2.17 1.56 1.14 0.85
Debt-Assets Ratio <0.60 1.44 1.23 1.25 1.12 0.93 0.75
Fixed Assets Coverage <0.60 4.92 3.84 2.31 2.32 2.30 2.27
Interest Coverage Ratio >2.00 4.31 4.56 6.72 5.89 6.57 7.61
TURNOVER RATIOS:
Inventory Turnover Period (Days) <30 Days 45 32 53 42 39 38
Average Collection Period (Days) <30 Days - - - - - -
Total Assets Turnover (Times) >1.00 1.44 1.74 1.52 1.65 1.66 1.60
Average Credit Period (Days) - Creditors <30 Days 67 115 50 23 20 18
Bank Finance Turnover (Times) >5.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Current Assets Turnover (Times) >3.00 2.04 2.56 3.31 3.19 2.78 2.39
PROFITABILITY RATIOS:
Net Profit Margin after tax (%) >5.00% 6.59% 7.70% 7.70% 7.75% 7.75% 8.13%
Net Income to Assets Ratio (%) >10.00% 9.50% 13.39% 11.70% 12.80% 12.85% 13.05%
Return on Investment (%) [PBDIT/TTA] >20.00% 17.87% 20.85% 17.03% 18.25% 17.33% 16.65%
Return on Equity (%) >18.00% 19.22% 16.74% 17.48% 16.47% 14.79% 13.79%
Operating Profitability (%) >20.00% 6.43% 7.29% 7.70% 7.75% 7.75% 8.13%
Pre-Tax Profitability (%) >15.00% 6.59% 7.70% 7.70% 7.75% 7.75% 8.13%
PBT / TTA (%) >10.00% 9.50% 13.39% 11.70% 12.80% 12.85% 13.05%
STRUCTURAL RATIOS:
Retained Profit (%) >20.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Raw Material Content (%) <50.00% 88.14% 83.32% 83.87% 83.44% 84.54% 83.17%
Operating Cost / Sales (%) <75.00% 93.57% 92.71% 92.30% 92.25% 92.25% 91.87%
Signs:
< = Less Than
> = More Than
CALCULATION OF TERM LOAN INTEREST AND REPAYMENT SCHEDULE
Rate of Interest on Loan : 18.5
::