ASSESMENT OF WORKING CAPITAL REQUIREMENTS

FORM I: Particulars of the existing/proposed limits from the Banking system

(Limits from all Banks and Financial Institutions as on date of application

Amt. in lakhs
Name of
Nature of Existing Extent to which limits were utilised during the Balance Limit now
Sr.No. Bank/Financial
Facility Limits last 12 month outsanding as on required
Institutions
Maximum Minimum
1 2 3 4 5 6 7 8
A.Working Capital Limits
1 UBI Over Draft 120.00 275.00
2

Name of
Sanctioned Outstanding
Sr.No. Bank/Financial Over dues, if any Remark
limit as on …….
Institutions
1 2 3 4 5 6
A.Term Loans/DPGs (excluding working capital term loans)

1
2 -- --
 ASSESMENT OF WORKING CAPITAL REQUIREMENTS
FORM II: OPERATING STATEMENT
M/S BHAGYA LAKSHMI INDUSTRIES
Rupees in Lacs
Details/Year Ending 31st March 2019-20 2020-21 2021-22
Audited Audited Audited
-1 -1 -1
1. Gross Sales
(i) Domestic Sales 1035.69 1204.79 1532.75
(ii) Export Sales 0.00 0.00 0.05
TOTAL 1035.69 1204.79 1532.80
2. Less : Excise Duty 0.00 0.00 0.00
3. Net Sales (1-2) 1035.69 1204.79 1532.80
% age rise(+) or fall(-) in net sales as compared to
4. 16% 27%
previous year (annualised)

5. Cost of Sales
(i). Raw material (including stores and other items used in the process of manufacture)
(a) Imported 0.00 0.00 0.00
(b) Indigenous 1090.70 1173.48 775.80
(ii) Other Spares
(a) Imported 0.00 0.00 0.00
(b) Indigenous 0.00 0.00 0.00
(iii) Power and fuel 4.46 12.28 11.86
(iv) Direct labour &employee 0.00 1.47 155.33
(v) Other operational expenses 8.85 2.38 38.53
(vi) Repairs & Maintenance 0.00 0.00 7.53
(vii) Depreciation 3.06 2.63 46.19
(viii) SUB-TOTAL (i to vii) 1107.07 1192.24 1035.24

(ix) Add: Opening stock-in Process 0.00 0.00 0.00

SUB-TOTAL 1107.07 1192.24 1035.24
(x) Deduct: Closing stock-in Process 0.00 0.00 0.00
(xi) Cost of Production 1107.07 1192.24 1035.24
(xii) Add:Opening stock of finished goods 107.26 197.11 570.00
Sub-total 1214.33 1389.35 1605.24
(xiii)Deduct closing stock of finished goods 197.10 206.54 507.69
(xiv) Sub-Total (Total cost of sales) 1017.23 1182.81 1097.55
6. Selling, general and administrative Expenses 0.00 0.00 0.00
7. SUB TOTAL (5+6) 1017.23 1182.81 1097.55
8. Operating profit before Interest ( 3 - 7 ) 18.46 21.98 435.25
9. Interest + BG Commission 7.59 9.72 50.00
10. Operating profit after Interest (8-9) 10.87 12.26 385.25
11. (i) Add: Other non-operating income 9.00
(a) Miscellaneous 0.00 0.00 0.00
Sub Total (Income) 0.00 0.00 0.00
(ii) Deduct: Other non-operating Expenses
(a) Prior Year Adj. 0.00 0.00 0.00
Sub Total (Expenses) 0.00 0.00 0.00
(iii) Net of other non-operating income / expenses 0.00 0.00 0.00

12. Profit before tax/loss [(10+11) (iii)] 10.87 12.26 394.25

1.05% 25.72%
13. Provision for taxes 3.26 1.37 112.80
( inc Defeered taxes)
14. Net profit/Loss (12-13) 7.61 10.89 281.46
0.73% 0.90% 18.36%
(a) Equity dividend paid-amount (Already paid +
15.
B.S.provision) 0.00 0.00 0.00
(b) Dividend Rate 0% 0% 0%

16. Retained Profit (14-15) 7.61 10.89 281.46

17. Retained profit/ Net Profit (% age) 100% 100%

 FORM III
ANALYSIS OF BALANCE SHEET

Details/Year Ending 31st March 2021-22

Audited
###

CURRENT LIABILITIES

Short term borrowings from Banks (Incl

1. bills purchased, discounted & excess
borrowings placed on repayment basis
###
(i). From applicant Bank ###
(ii). From other Banks ###
(iii). (of which BP & BD) ###
(iv) Creditors for Capital Goods ###
Sub Total(A) ###

2. Short term brorrowings from others ###

3. Sundry Creditors (Trade) ###
4. Advance Payments from Customers/depos ###
5. Provision for Taxation ###
6. Dividend Payable ###
7. Other Statutory Liabilities (Due within###
on
Deposits/Instalments of term loans/
DPGs/Debuntures etc. (Due within one
8. year) ###
9. Other Current Liabilities & Provisions###
(D

Sub Total (B) ###

10. TOTAL CURRENT LIABILITIES (total###

of 1 to

TERM LIABILITIES

11. Debentures (Not maturing within one###

yea

12. Preference Shares (Redeemable after

###o

13. Term Loans (Excluding installment payab

###

14. Deffered payment credits ###

15. Term Deposits (Repayable after one###

yea
 FORM III
ANALYSIS OF BALANCE SHEET

Details/Year Ending 31st March 2021-22

Audited
###

16 Other term Liabilities ###

17. TOTAL TERM LIABILITIES ###

18. TOTAL OUTSIDE LIABILITIES (Items

###
10
 FORM III
ANALYSIS OF BALANCE SHEET

Details/Year Ending 31st March 2021-22

Audited
###

NET WORTH

19. Ordinary Share Capital Quasi Capital###

20. General Reserve ###

21. Revaluation Reserve ###

22. Other Reserves (excluding provisions)

###

23. Surplus(+) or Deficit (-) in Profit & Loss

###

23.a Others (Deferred Tax) ###

24. NET WORTH ###

25. TOTAL LIABILITIES ###

 FORM III
ANALYSIS OF BALANCE SHEET

Details/Year Ending 31st March 2021-22

Audited
###

ASSETS

CURRENT ASSETS

26. Cash and Bank balances ###

27. Investments (other than long term investments)
(i) Government & Other trustee securiti
###
(ii) Fixed deposits with Banks (BGs &
###
Col
(i) Receivables other than deffered &
exports (inlcuding bills purchased and
28. discounted by banks) ###
ii) Export Receivables (incl.bills
purchased and discounted by banks)###
Instalments of deferred receivables
29. (due within one year) ###
30. Inventory: ###
(i) Raw materials ( Including stores &
other items used in the process of
manufacture)
a) Imported
b) Indigenous ###
(ii) Stocks-in-process ###
(iii) Finished goods ###
(iv) Other consumable spares
a) Imported
b) Indigenous ###
31. Advances to suppliers of raw materials
###&
32. Advance payment of taxes ###
33. Other Current assets (specify major item
###

34. TOTAL CURRENT ASSETS (Total of###

26 t

FIXED ASSETS

35. Gross Block (Land & building, machinery

###

36. Depreciation to date ###

 FORM III
ANALYSIS OF BALANCE SHEET

Details/Year Ending 31st March 2021-22

Audited
###

37. NET BLOCK (35-36) ###

Capital Work in Progress ###

 FORM III
ANALYSIS OF BALANCE SHEET

Details/Year Ending 31st March 2021-22

Audited
###

NON-CURRENT ASSETS

38. Investments/book debts/advances/deposit

###

(i) a) Investments in subsidiary Compani

###
b) Others
(ii) Advances to suppliers of Capital ###
goo
(iii) Deffered receivables (maturity exce
###
(iv) Others ###
39. Non-consumable Stores & Spares ###
40. Other non-Current assets including dues

41. TOTAL OTHER NON-CURRENT ASSET

Intangible assets (patents, goodwill,

prelim expences, bad/doubtful
42. expenses not provided for etc.) ###

43. TOTAL ASSETS (34+37+41+42) ###

44. TANGIBLE NET WORTH (24-42) ###

45. NET WORKING CAPITAL [(17+24)-(31+4

46. Current Ratio ###

47. Total Outside Liabilities/Tangible Net###

Wo

48 Total Term Liabiliites/Tangible Net Worth

###

Debt Equity Ratio ###

 FORM IV
COMPANY STATEMENT OF CURRENT ASSETS & CURRENT LIABILITES

0.00

Details/Year Ending 31st March

A. CURRENT ASSETS

Raw materials (including stores & other

items used in the process of manufacturing)
1.
(a) Imported:
Months consumption
(b) Indigenous:
Months' consumption
2. Other consumable spares excluding those included in
i) Above
(a) Imported
Amount
Months consumption
(b) Indigenous:
Amount
Months consumption
3. Stocks-in-process:
Amount
Months cost of Production
4. Finished goods:
Amount
Months Cost of sales
5. Receivables other than export & deffered
Receivables (Including bills purchased & discounted by banks)
Amount
Months Domestic sales
6. Export receivables (including bills purchased & discount)
Amount
Months' Export sales:
7. Advances to suppliers of Raw materials & s
Other current assets including Cash & Bank
balances & defer receivables due within
one year (specify major items) Cash & bank
balances, investment, except long term
8. installments of Def.receivables other

9. TOTAL CURRENT ASSETS

B. CURRENT LIABILITIES
(Other than bank borrowings for Working capital)

10. Creditors for purchase of Raw materials, stores and consumable spares
Amount
Months' purchases:
11. Advances from customers
12. Statutory liabilities
13. Other current liabilities - specify major items
a) S.T.borrowings-others
b) Dividend payable
c) Installments of TL, DPG and Public Depos
d) Other current liability and provisions

14. TOTAL CURRENT LIABILITIES

 FORM V
COMPUTATION OF MAXIMUM PERMISSIBLE BANK FINANCE FOR WORKING CAPITAL

0.00

Details/Year Ending 31st March

1. Total Current Assets

2. Other Current Liabilities (Other than Bank Borrowings)

3. Working Capital Gap

4. Min. stipulated net working Capital (25% of WCG excluding Ex

5. Actual/projected net working capital

6. Item 3 minus item 4

7. Item 3 minus item 5

8. Maximum permissible bank finance (Lower of 6 or 7)

9. Excess borrowings representing shortfall in NWC

SECOND METHOD OF LENDING

1 Total Current Assets

2 Other Current Liabilities (Other than Bank Borrowings)

3 Working Capital Gap

Min. stipulated net working Capital (25% of Total current

4
assets excluding Export recivables)

5. Actual/projected net working capital

6. Item 3 minus item 4

7. Item 3 minus item 5

8. Maximum permissible bank finance (Lower of 6 or 7)

9. Excess borrowings representing shortfall in NWC

 FORM VI
FUNDS FLOW STATEMENT
0.00

Details/Year Ending 31st March

1. SOURCES
a) Net profit (after tax)
b) Depreciation
c) Increase in capital, Quasi capital
d) Increase in Term Liabilites, including Public deposits
e) Decrease in
i) Fixed Assets
ii) Other non-current assets
f) Others
G) TOTAL

2. USES

a) Net Loss
b) Decrease in Term Liabilities, including public deposit
c) Increase in:
i) Fixed assets
ii) Other non-current assets
d) Dividend Payment
f) Others
g) TOTAL

3. Long Term Surplus/Deficit

4 Increase/Decrease in Current Assets * ( As per detatils given below)

5. Increase/Decrease in Current liabilities other than bank borrowings

6. Increase/Decrease in Working Capital Gap

7. Net Surplus (+)/deficit (-) (Difference of 3 &6)

8. Increase/Decrease in Bank Borrowings

9. INCREASE /DECREASE IN NET SALES

* Break- up of (4)

i) Increase/Decrease in Raw materials

ii) Increase/Decrease in Stocks-in-process

iii) Increase/Decrease in Finished goods

iv) Increase/Decrease in Receivables

a) Domestic
b) Export
v) Increase/Decrease in stores & spares

vi) Increase/Decrease in other current assets

TOTAL
 1,500.00
( Rs. In Lakhs)
PROFITABILITY PROJECTIONS
1 2 3 4 5 6 7 8 9 10
Particulars/ FY 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28

Lease Rent 10 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00

Total Income (A) 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00

Expenditure

R&M 5% 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50
Goods shed labour
expenses 5% 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50 17.50

Depreciation 74.54 70.61 66.88 63.35 60.00 56.83 53.83 50.99 48.30 45.75
Interest on proposed

term loan 0.72 0.45 0.17 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

Total expenditure (B) 110.26 106.05 102.05 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!
Operating income 239.74 243.95 247.95 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!
Tax ( MAT) 47.95 48.79 49.59 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!
Profit after tax 191.79 195.16 198.36 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!
Depreciation 74.54 70.61 66.88 63.35 60.00 56.83 53.83 50.99 48.30 45.75

Cash Generation 266.33 265.76 265.24 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

0
0

PROJECTED BALANCE SHEET

LIABILITIES 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28

Prop. Capital 356.78 356.78 356.78 356.78 356.78 356.78 356.78 356.78 356.78 356.78

Reserves 191.79 386.95 585.31 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

Term Loan 5.00 2.50 - Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

Un-secured loans 55.00 55.00 55.00 55.00 55.00 55.00 55.00 55.00 55.00 55.00

Total 608.57 801.23 997.09 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

ASSETS 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28

Gross Block 1,411.78 1,411.78 1,411.78 1,411.78 1,411.78 1,411.78 1,411.78 1,411.78 1,411.78 1,411.78

Depreciation 74.54 145.15 212.03 275.37 335.38 392.21 446.04 497.03 545.33 591.08

Net Block 1,337.24 1,266.63 1,199.75 1,136.41 1,076.40 1,019.57 965.74 914.75 866.45 820.70

Other current assets - - - - - - - - - -

Cash Balance 263.83 527.09 789.83 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

Total 1,601.07 1,793.73 1,989.59 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

0
0
0

PROJECTED CASH FLOW STATEMENT

Inflow 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28
Internal cash
generation 266.33 265.76 265.24 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

Prop. Capital 356.78 - - - - - - - - -

Un-secued loans 55.00 - - - - - - - - -

Term Loan 1,000.00 - - - - - - - - -

Total 1,678.11 265.76 265.24 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

Outflow 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28

Railway Track 1,411.78 - - - - - - - - -

Term Loan repayment 2.50 2.50 2.50 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!
Increase in current
assets

Total 1,414.28 2.50 2.50 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

Opening Balance - 263.83 527.09 789.83 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
Add:Surplus 263.83 263.26 262.74 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF!

Less:Deficit - - - - - - - - - -

Closing cash balance 263.83 527.09 789.83 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

0
0
0

DSCR Calculation:(till the end of the year by which Term loan is proposed to be repaid)

2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 TOTAL

Cash Generation 266.33 265.76 265.24 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF! Err:509

Interest on term loan 0.72 0.45 0.17 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF! Err:509

Net Cash flow (A) 267.05 266.21 265.41 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF! Err:509

Proposed term loan

instalments 2.50 2.50 2.50 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF! Err:509

Interest on term loan 0.72 0.45 0.17 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF! Err:509

Net Cash out flow (B) 3.22 2.95 2.67 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF! Err:509

Average DSCR 82.89 90.34 99.33 Err:509 Err:509 Err:509 #REF! #REF! #REF! #REF! Err:509

Average DSCR Err:509

0
0
0

DEPRECIATION SCHEDULE

2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28

Godown

Opening WDV 1,411.78 1,337.24 1,266.63 1,199.75 1,136.41 1,076.40 1,019.57 965.74 914.75 866.45

Depreciation @ 5.28% 74.54 70.61 66.88 63.35 60.00 56.83 53.83 50.99 48.30 45.75

Closing WDV 1,337.24 1,266.63 1,199.75 1,136.41 1,076.40 1,019.57 965.74 914.75 866.45 820.70

Total Fixed assets 1,337.24 1,266.63 1,199.75 1,136.41 1,076.40 1,019.57 965.74 914.75 866.45 820.70