Assessment of Working Capital Requirements Rs.

in Lakhs
FORM - I
Particulars of Existing / Proposed Limits from the Banking System
(Limits from all Banks and Financial Institutions as on date of application)
Name: CREATIVE MIND
Extent to which Balance Limits
Sr. Nature of Existing Limits were utilised outstanding as now
Name of Bank / Financial Institution
No. Facility Limits during last 12 on requeste
months 31-Mar-18 2018-19
Maximum Minimum
A. Working Capital Limits:

1 Fund based
Cash Credit - - - - 10.00

2 Non-fund based Letter of Credit - - - - -

- - - -
B. Term Loans/DPGS excluding Working Term Loan -
Capital Loans

Total: - - - - - 10.00

Information about Associate Companies

(Companies / Firms / Concerns in which Directors / Partners / Proprietor and / or their family members or the
brorower Company is / are asssociated with the other Unit as Directors / Partners / Proprietor or has / have
Name: CREATIVE MIND
Annual Limits from all Banks and financial institutions
Sr. Name of the Associate Company & makeup of A/c Name of Working Capital Overdues
Term Loan &
No. Activity Date of Bank / Fund Non-fund , if any
DPG
Balance Sheet Financial based based

1 - - - -

2 - - - -

3 - - - -
NOT APPLICABLE

- - - -
Page 2of 14 Assessment of Working Capital Requirements Rs. in Lakhs
FORM II : OPERATING STATEMENT
Name: CREATIVE MIND
Amount

Audited PROJECTIONS
Sr. No. Particulars
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
A Quantities:
i Raw Material Consumption - - - - -
ii Sales - - - - -
iii Rejects and Scraps - - - - -

1 Gross Income
a Sales (net of returns)
i Domestic Sales 39.60 50.00 62.50 78.13 97.66
ii Export Sales - - - - -
T1 Sub-total [ a(i+ii) ] 39.60 50.00 62.50 78.13 97.66
iii Less: Excise Duty - - - - -
T2 Net Sales [ T1-iii ] 39.60 50.00 62.50 78.13 97.66
iv % rise or fall in sales turnover [compared to previous -year] 0.26 0.25 0.25 0.25
b Other Income
i - - - - -
ii - - - - -
iii - - - - -
iv - - - - -
v - - - - -
T3 Total Other income [ b(i to iv) ] - - - - -

T4 Total Gross Income [ T2+T3 ] 39.60 50.00 62.50 78.13 97.66

2 Cost of Production & Cost of Sales

a Raw Materials [Including Stores and other
items used in the process of manufacture)
i Imported - - - - -
ii Indegenous 4.41 5.05 9.93 12.72 22.50
T5 sub-total [ a(i+ii) ] 4.41 5.05 9.93 12.72 22.50
b Other Consumable Spares
i Imported - - - - -
ii Indegeneous - - - - -
T6 sub-total [ b(i+ii) ] - - - - -
c Direct Expenses
i Power & Fuel 0.52 0.60 1.00 1.50 2.00
ii Direct Labour - - - - -
x Depreciation - 1.23 1.23 1.23 1.23
T7 Total Direct Expenses [ c(i to x) ] 0.52 1.82 2.23 2.73 3.23
T8 sub-total
[ T5+T6+T7 ] 4.93 6.87 12.16 15.45 25.73
d Add : Opening stock of W.I.P. - - - - -
T9 Sub-total [ T8+2(d) ] 4.93 6.87 12.16 15.45 25.73
e Less : Closing Stock W.I.P. - - - - -
T10 Total Cost of Production [ T9-2(e) ] 4.93 6.87 12.16 15.45 25.73
f Add : Opening stock of Finished Goods - 3.80 3.80 4.10 4.80
T11 sub-total [ T10+2(f) ] 4.93 10.67 15.96 19.55 30.53
g Less : Closing Stock of Finished Goods 3.80 3.80 4.10 4.80 5.00
T12 Total Cost of Sales [ T11-2(g) ] 1.13 6.87 11.86 14.75 25.53
Page 3of 14 Assessment of Working Capital Requirements Rs. in Lakhs
FORM II : OPERATING STATEMENT
Name: CREATIVE MIND
Amount

Audited PROJECTIONS
Sr. No. Particulars
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5

3 General, Administrative & Selling Expenses

i Rent 14.45 14.45 15.46 18.00 20.00
ii Royalty 4.27 5.50 6.88 8.59 10.74
iii Advertisement expenses 3.24 4.00 5.00 8.00 8.50
iv Salaries 13.89 14.58 18.00 22.00 25.00
iv Other office expenses 1.88 2.16 2.49 2.86 3.29
v Travelling Expenses 0.42 0.48 0.53 0.90 0.99
T13 Total General, Administrative &
Selling Expenses [ 3(i to x) ] 38.15 41.18 48.35 60.35 68.52

4 Operating Profit before Interest

[ T4-T12-T13 ] 0.32 1.95 2.28 3.02 3.61

5 Finance Charges
i Interest on Term Loan & CC 1.03 1.03 1.03 1.03
T14 Total Finance Charges [ 5(i to v) ] - 1.03 1.03 1.03 1.03

6 Operating Profit after Interest [ 4-T14 ] 0.32 0.92 1.25 1.99 2.58

7 Non-Operating Income
i - - - - -
T15 Total Non-Operating Income [ 7(i to iii) ] - - - - -

8 Non-Operating Expenses
i - - - - -
9 T16 Total Non-Operating Expenses[ 8(i to iii) ] - - - - -
T17 Net Non-Operating Income (+) /
Expenses (-) [ T15-T16 ] - - - - -

10 Net Profit before Tax / (Loss) [PBT

6+/(-)T17 ] 0.32 0.92 1.25 1.99 2.58
11 Provision for Taxes -
12 Net Profit / Loss after Tax PAT [ 10-11 ] 0.32 0.92 1.25 1.99 2.58
PAT to Net Sales % [ 12/T2 ] % {0.81%} {1.83%} {2.01%} {2.55%} {2.64%}

13 Equity Dividend & Dividend Tax - - - - -

Dividend Rate % {0.00%} - - - -
Dividend Distribution Tax % {0.00%} - - - -
14 Retained Profit [ 12-13 ] 0.32 0.92 1.25 1.99 2.58
15 Retained Profit / PAT % [ 14/12 ] % {100.00%} {100.00%} {100.00%} {100.00%} {100.00%}
 Assessment of Working Capital Requirements Rs. in Lakhs
FORM III : ANALYSIS OF BALANCE SHEET
Name: CREATIVE MIND

Audited PROJECTIONS
Sr.
Particulars
No.
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
Current Liablities
1 Short term borrowings
a from Banks (including bills purchased, discounted
& excess borrowings placed on repayment basis)
i from Applicant Bank - 10.00 10.00 10.00 10.00
ii from Other Banks - - - - -
T1 sub-total [ a(i + ii) ] - 10.00 10.00 10.00 10.00
of which BP & BD
iii from Applicant Bank - - - - -
iv from Other Banks - - - - -
T2 sub-total[ b(iii + iv) ] - - - - -
T3 Total short term borrowings from banks T1 - 10.00 10.00 10.00 10.00
b from Others
i Sundry Trade Creditors - Indigenous 3.20 0.83 0.90 2.09 2.50
ii Sundry Trade Creditors - Import - - - - -
iii Advance payments from Customers / 1.70 2.32 2.70 2.96 2.18
Deposits from Dealers / Stockists -
iv Provision for Taxation - - - - -
v Dividend payable - - - - -
vi Other Statutory Liabilities (due within 1 year) - - - - -
vii Deposits / Debentures / Instalments of Term
Loans / DPGs etc. (due within 1 year)
T4 Total short term borrowings from others [ b(i to vii) ] 4.90 3.15 3.60 5.05 4.68
2 Other Current Liabilities and Provisions
(due within one year-specify major items )

i Salary Payable 1.16 1.22 1.50 1.83 2.08

i Royalty Payable 0.36 0.46 0.57 0.72 0.90
i Other Payables 0.74 0.96 0.98 1.10 1.15
- - - -
T5 sub-total[ 2(i to v) ] 2.25 2.64 3.05 3.65 4.13
T6 Current Liabilities excl. bank borrowings
[ T4+T5 ] 7.15 5.79 6.65 8.70 8.81
T7 Total Current Liabilities [ T3+T6 ] 7.15 15.79 16.65 18.70 18.81

3 Term Liabilities
a Debentures (maturing after 1 year) - - - - -
b Preference Shares (redeemable after 1 year) - - - - -
c Term loans (repayable after 1 year)
d Deferred Payment Credits (repayable after 1 year) - - - - -
e Term deposits (repayable after 1 year) - - - - -
f Other term liabilities
i Unsecured Loans- Ffrom relatives & friends 7.54 7.54 6.54 5.54 1.54
ii -
T8 Total Term Liabilities [ 3(a to f) ] 7.54 7.54 6.54 5.54 1.54
T9 Total Outside Liabilities [ T7+T8 ] 14.69 23.33 23.19 24.24 20.35

4 Net Worth
a Capital 2.90 3.22 4.14 5.39 7.38
b General reserve - - - - -
c Revaluation Reserve - - - - -
d Other reserves (excluding provisions) - - - - -
e Surplus (+) or deficit (-) in P & L A/c 0.32 0.92 1.25 1.99 2.58
f Others
i Share Premium Account - - - - -
ii Capital Redemption Reserve - - - - -
iii - - - - -
iv - - - - -
v - - - - -
T10 Net Worth [ 4(a to f) ] 3.22 4.14 5.39 7.38 9.96
T11 Total Liabilities [ T9+T10 ] 17.91 27.46 28.58 31.62 30.31
Page 5 of 14 Assessment of Working Capital Requirements Rs. in Lakhs
FORM III : ANALYSIS OF BALANCE SHEET
Name: CREATIVE MIND

Audited PROJECTIONS
Sr. No. Particulars
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
Current Assets
5 Cash and bank balances 2.43 4.50 4.50 4.50 4.00
6 Investments
[other than long term Investments]
i Government & other trustee securities - - - - -
ii Fixed deposits with Banks & Others - - - - -
T12 sub-total [ 6(i+ii) ] - - - - -
7 i Receivables other than deferred & exports 3.51 12.22 14.27 17.84 18.05
[Including bills purchased & discounted
by bankers]
ii Export receivables (Including bills - - - - -
purchased/discounted by bankers)
T13 sub-total [ 7(i+ii) ] 3.51 12.22 14.27 17.84 18.05
8 Instalments under deferred receivables - - - - -
(due within one year)
9 Inventory
a Raw Materials [Including Stores and other
items used in the process of manufacture)
i Imported - - - - -
ii Indigeneous - - - - -
b Work [ Stock ] in Process - - - - -
c Finished Goods 3.80 3.80 4.10 4.80 5.00
d Goods in Transit - - - - -
e Other consumable spares
i Imported - - - - -
ii Indigeneous
T14 sub-total [ 9(a to e) ] 3.80 3.80 4.10 4.80 5.00
10 Advances to suppliers of of raw materials /
stores & spares - - - - -
11 Advance payment of taxes - - - - -
12 Other current assets [specify major items]
i Security Deposits
ii - - - - -
iii - - - - -
iv - - - - -
v - - - - -
T15 sub-total [ 12(i to v) ] - - - - -

T16 Total Current Assets [ 5 to 12 ] 9.74 20.52 22.87 27.14 27.05

13 Fixed Assets
i Gross Block 8.17 8.17 8.17 8.17 8.17
ii Depreciation to date - 1.23 2.46 3.69 4.92
T17 Net Block [ 13(i-ii) ] 8.17 6.94 5.71 4.48 3.25
Page 6 of 14 Assessment of Working Capital Requirements Rs. in Lakhs
FORM III : ANALYSIS OF BALANCE SHEET
Name: CREATIVE MIND

Audited PROJECTIONS
Sr. No. Particulars
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
Other Non-Current Assets
14 Investments / book debts /advances /
deposits which are non-current
a Investments in subsidiary
companies / affiliates - - - - -
b Other investments - - - - -
c Advances to suppliers of
capital goods and contractors - - - - -
d Deferred receivables
[maturity exceeding one year] - - - - -
e Security deposits / Tender Deposits - - - - -
f Others
i Receivables exceeding one year
ii - - - - -
iii - - - - -
T18 sub-total [ 14(a to f) ] - - - - -
15 Obsolete Stocks - - - - -
16 Non-consumable consumables & spares - - - - -
17 Other non-current assets - - - - -
(Including dues from directors)
T19 Total Other Non-Current Assets [ 14 to 17 ] - - - - -

18 Intangible assets
(Patents, Goodwill, Preliminary Expenses,
Bad / Doubtful Debts not provided for etc)

T20 Total Assets [ T16+T17+T19+18 ] 17.91 27.46 28.59 31.63 30.31

T21 Tangible Net Worth [ T10-18 ] 3.22 4.14 5.39 7.38 9.96
T22 Net Working Capital [ T16-T7 ] 2.59 4.73 6.22 8.44 8.24
19 Current Ratio [ T16/T7 ] 1.36 1.30 1.37 1.45 1.44
20 Total Outside Liabilities/
Tangible Net Worth [ T9/T21 ] 4.56 5.64 4.30 3.28 2.04
21 Total Term Liabilities/
Tangible Net Worth [ T8/T21 ] 2.34 1.82 1.21 0.75 0.15

22 Additional Information
a Arrears of depreciation - - - - -
b Contingent Liabilities :
i Arrears of cumulative dividends - - - - -
ii Gratuity liability not provided for - - - - -
iii Disputed excise/customs tax liabilities - - - - -
iv Bills accepted / guarnatees extended to
accommodate associate / sister concerns /
other third parties - - - - -
 Assessment of Working Capital Requirements Rs. in Lakhs

FORM - IV : COMPARATIVE STATEMENT OF CURRENT ASSETS AND CURRENT LIABILITIES

Name: CREATIVE MIND

Audited PROJECTIONS
Sr.
Particulars
No.
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
CURRENT ASSETS
1 Raw Materials [Including Stores and other
items used in the process of manufacture)
i Imported - - - - -
[Months' Consumption] {00.00} {00.00} {00.00} {00.00} {00.00}

ii Indigeneous - - - - -
[Months' consumption] {00.00} {00.00} {00.00} {00.00} {00.00}

2 Stocks in Process - - - - -
[Months' Cost of Production] {00.00} {00.00} {00.00} {00.00} {00.00}

3 Finished Goods 3.80 3.80 4.10 4.80 5.00

[Months' Cost of Sales] {40.35} {06.63} {04.15} {03.91} {02.35}

4 Other consumable spares

i Imported - - - - -
[Months' Consumption] {00.00} {00.00} {00.00} {00.00} {00.00}

ii Indigeneous - - - - -
[Months' consumption] {00.00} {00.00} {00.00} {00.00} {00.00}

5 Receivables other than export & deferred

receivables (including bills purchased &
discounted by bankers) 3.51 12.22 14.27 17.84 18.05
[Months' domestic sales including deferred payment
{01.06}
sales] {02.93} {02.74} {02.74} {02.22}

6 Export receivables [including bills purchased &

discounted] - - - - -
[Months' export sales] {00.00} {00.00} {00.00} {00.00} {00.00}

7 Advances to suppliers of of raw materials /

stores & spares - - - - -
8 Other current assets incl.cash & bank balances
& deferred receivables due within 1 year [major items only]
i Cash & bank balances 2.43 4.50 4.50 4.50 4.00
ii Investments [ other than long term ] - - - - -
iii Instalments under deferred receivables [ due within 1 year
- ] - - - -
iv Advance payment of taxes - - - - -
v Other current assets as per T15 of Form-III - - - - -
vi - - - - -
vii - - - - -
T1 Total Current Assets 9.74 20.52 22.87 27.14 27.05

CURRENT LIABILITIES
[Other than bank borrowings for working capital]

9 Sundry Trade Creditors [for raw materials, stores, 3.20 0.83 0.90 2.09 2.50
spares & consumables]
[Months' purchases] 8.71 1.97 1.09 1.97 1.33

10 Advances from customers / deposits from dealers - - - - -

11 Statutory liabilities [Including Provision for Taxation] - - - - -
12 Other current liabilities [specify major items]
[Short Term borrowings, unsecured loans,
dividend payable, instalments of TL,
DPG, public deposits, debentures etc.]
i Deposits / Debentures / Instalments of Term
Loans / DPGs etc. (due within 1 year) - - - - -

Salary Payable
Royalty Payable
ii Other Payables 0.74 0.96 0.98 1.10 1.15

v Other Payables 0.74 0.96 0.98 1.10 1.15

vi - - - - -
sub-total [ 12(i to vi) ] 1.48 1.92 1.96 2.20 2.30
T2 Total Current Liabilities 4.68 2.75 2.86 4.29 4.80
 Assessment of Working Capital Requirements Rs. in Lakhs
FORM-V: COMPUTATION OF MAXIMUM PERMISSIBLE BANK FINANCE (MPBF) FOR WORKING CAPITAL
Name: CREATIVE MIND
PROVISION
PROJECTIONS
Sr. AL
Particulars
No.
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5

FIRST Method of Lending

1 Total Current Assets 10 21 23 27 27
[ T1 in Form-IV ]

2 Current Liabilities [Other than bank borrowing] 5 3 3 4 5

[ T2 in Form-IV ]

3 Working Capital Gap [WCG] 5 18 20 23 22

[1-2]

4 Minimum Stipulated Net Working Capital 1 4 5 6 6

[ 25% of WCG excluding export receivables]
[ (item 3 above - item no. 6 in Form - IV)*0.25 ]

5 Actual / Projected Net Working Capital [ NWC ] 3 5 6 8 8

[ T22 in Form-III ]

6 Item no. 3 minus Item no. 4 4 13 15 17 17

7 Item no. 3 minus Item no. 5 2 13 14 14 14

8 Maximum permissible bank finance [MPBF] 2 13 14 14 14

[ least of item 6 or 7 above ]

SECOND Method of Lending

1 Total Current Assets 10 21 23 27 27
[ T1 in Form-IV ]

2 Current Liabilities [other than bank borrowings] 5 3 3 4 5

[ T2 in Form-IV ]

3 Working Capital Gap (WCG) (1-2) 5 18 20 23 22

[1-2]
4 Minimum Stipulated Net Working Capital 2 5 6 7 7
[25% of total Current Assets excluding export receivables]
[ (1 above - item 6 in Form-IV)*0.25 ]

5 Actual / Projected net working capital 3 5 6 8 8

[ T22 in Form-III ]

6 Item no. 3 minus Item no. 4 3 13 14 16 15

7 Item no. 3 minus Item no. 5 2 13 14 14 14

8 Maximum permissible bank finance [MPBF] 2 13 14 14 14

[ least of item 6 or 7 above ]
 Assessment of Working Capital Requirements Rs. in Lakhs
FORM-V: FUNDS FLOW STATEMENT
Name: CREATIVE MIND
PROVISION
PROJECTIONS
Sr. AL
Particulars
No.
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
A SOURCES OF FUNDS
1 Net profit for the year after tax 0.92 1.25 1.99 2.58
2 Depreciation 1.23 1.23 1.23 1.23
3 Increase in capital 0.32 0.92 1.25 1.99
4 Increase in long-term funds / term liabilities - - - -
5 Decrease in fixed assets - - - -
6 Decrease in other non-current assets - - - -
7 Others - - - -
8 - - - -
9 - - - -
10 - - - -
T1 Total 2.46 3.40 4.48 5.80

B APPLICATION OF FUNDS
1 Net loss for the year - - - -
2 Decrease in capital - - - -
3 Decrease in long-term funds / term liabilities - 1.00 1.00 4.00
4 Increase in fixed assets - - - -
5 Increase in other non-current assets - - - -
6 Dividend payments - - - -
7 Others 0.32 0.92 1.25 1.99
8 - - - -
9 - - - -
10 - - - -
T2 Total 0.32 1.92 2.25 5.99
a Long term surplus (+) / deficit (-) [ T1-T2 ] 2.14 1.48 2.22 (0.19)
b Increase / (decrease) in current assets * 10.78 2.35 4.27 (0.09)
* as per details given below at "h"
c Increase / (decrease) in current liabilities other
than bank borrowings (1.37) 0.87 2.05 0.11
d Increase / (decrease) in working capital gap 12.71 2.25 2.84 (0.60)
e Net surplus / (deficit) (10.56) (0.76) (0.62) 0.40
f Increase / (decrease) bank borrowings 10.00 - - -
g Increase / (decrease) net sales 10.40 12.50 15.63 19.53

h Break-up of "b" above:

Increase / (decrease) in inventory of:
i Raw materials - - - -
ii Work [ Stock ] in Process - - - -
iii Finished Goods - 0.30 0.70 0.20
iv Goods in Transit - - - -
v Other consumable spares - - - -
Increase / (decrease) in receivables
vi Domestic 8.71 2.05 3.57 0.21
vii Export - - - -
viii Increase / (decrease) in other current assets 2.07 - - (0.50)
Net total of [ h(i to viii) ] 10.78 2.35 4.27 (0.09)
Page 10 of 14 Assessment of Working Capital Requirements Rs. in Lakhs
SUMMARY OF FINANCIAL STATEMENTS FOR RATIO ANALYSIS
Name:CREATIVE MIND

PROVISIONAL PROJECTIONS
Sr.
Particulars
No.
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
OPERATING STATEMENT
INCOME
Domestic sales 39.60 50.00 62.50 78.13 97.66
Export sales - - - - -
Gross Sales 39.60 50.00 62.50 78.13 97.66
Excise duty - - - - -
Net Sales 39.60 50.00 62.50 78.13 97.66
Other Income - - - - -
Gross Income 39.60 50.00 62.50 78.13 97.66
EXPENSES
Raw material [Imported] - - - - -
Raw material [Indigenous] 4.41 5.05 9.93 12.72 22.50
Consumables [Imported] - - - - -
Consumables [Indigenous] - - - - -
Total Material Cost 4.41 5.05 9.93 12.72 22.50
Total Consumables Cost - - - - -
Total purchases 4.41 5.05 9.93 12.72 22.50
Direct Labour 0.52 0.60 1.00 1.50 2.00
Depreciation - 1.23 1.23 1.23 1.23
Other direct overheads - - - - -
Total direct expenses 0.52 1.82 2.23 2.73 3.23
Inventory [opening] of WIP - - - - -
Inventory [closing] of WIP - - - - -
Total cost of production 4.93 6.87 12.16 15.45 25.73
Inventory [opening] of finished goods - 3.80 3.80 4.10 4.80
Inventory [closing] of finished goods 3.80 3.80 4.10 4.80 5.00
Average inventory of finished goods 1.90 3.80 3.95 4.45 4.90
Total cost of sales 1.13 6.87 11.86 14.75 25.53
Gross Profit 38.47 43.13 50.64 63.38 72.13
Total indirect expenses 38.15 41.18 48.35 60.35 68.52
Opearting profit before finance
0.32 1.95 2.28 3.02 3.61
charges
Total finance charges [only interest
- 1.03 1.03 1.03 1.03
element]
Opearting profit after finance
0.32 0.92 1.25 1.99 2.58
charges
Non-operating income - - - - -
Non-operating expenses - - - - -
Profit before Tax / (Loss) PBT 0.32 0.92 1.25 1.99 2.58
Provision for Taxes - - - - -
Net Profit / Loss after Tax PAT 0.32 0.92 1.25 1.99 2.58
Equity divident payout - - - - -
Retained Profit 0.32 0.92 1.25 1.99 2.58
Net profit before depreciation, interest & tax [PBDIT]0.32 3.17 3.51 4.25 4.84
Net profit before interest & tax [PBIT] 0.32 1.95 2.28 3.02 3.61
Page 11 of 14 Assessment of Working Capital Requirements Rs. in Lakhs
SUMMARY OF FINANCIAL STATEMENTS FOR RATIO ANALYSIS
Name:CREATIVE MIND

PROVISIONAL PROJECTIONS
Sr.
Particulars
No.
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5

BALANCE SHEET
Liabilities
Short-term borrowings from banks - 10.00 10.00 10.00 10.00
Sundry creditors 3.20 0.83 0.90 2.09 2.50
Opening creditors for FIRST year  - NA NA NA NA
Average creditors 1.60 2.02 0.87 1.50 2.30
Short-term borrowings from others 4.90 3.15 3.60 5.05 4.68
Other current liabilities 2.25 2.64 3.05 3.65 4.13
Total current liabilities 7.15 15.79 16.65 18.70 18.81
Total term liabilities 7.54 7.54 6.54 5.54 1.54
Total outside liabilities 14.69 23.33 23.19 24.24 20.35
Total liabilities 17.91 27.46 28.58 31.62 30.31

Assets
Cash, bank & investments 2.43 4.50 4.50 4.50 4.00
Receivables-other than export 3.51 12.22 14.27 17.84 18.05
Receivables-export - - - - -
Total Receivables 3.51 12.22 14.27 17.84 18.05
Opening debtors for FIRST year  - NA NA NA NA
Average receivables 1.75 7.86 13.25 16.06 17.95
Inventory 3.80 3.80 4.10 4.80 5.00
Other current assets - - - - -
Total current assets 9.74 20.52 22.87 27.14 27.05

Fixed assets
Gross block 8.17 8.17 8.17 8.17 8.17
Depreciation upto date - 1.23 2.46 3.69 4.92
Net block 8.17 6.94 5.71 4.48 3.25

Total other non-current assets - - - - -

Intangible Assets - - - - -
Total assets 17.91 27.46 28.59 31.63 30.31

Total Tangible Assets 17.91 27.46 28.59 31.63 30.31

Net worth 3.22 4.14 5.39 7.38 9.96
Tangible net worth 3.22 4.14 5.39 7.38 9.96
Net working capital 2.59 4.73 6.22 8.44 8.24
Page 12 of 14 Assessment of Working Capital Requirements

RATIO ANALYSIS
Name: CREATIVE MIND

Audited PROJECTIONS
Sr. No. Particulars Ideal Levels
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
A Long-term Solvency Ratios
1 Debt Equity Ratio 2.34 1.82 1.21 0.75 0.15

2 Net Worth to Total Assets Ratio 0.18 0.15 0.19 0.23 0.33

3 Debt to Net Worth Ratio 2.34 1.82 1.21 0.75 0.15

4 Capital Gearing Ratio 2.34 1.82 1.21 0.75 0.15

5 Fixed Assets to Long Term Funds 1.08 0.92 0.87 0.81 2.11

6 Propriety Ratio 0.18 0.15 0.19 0.23 0.33

7 Interest Coverage - 3.08 3.41 4.13 4.70

8 Debt Service Coverage 0.04 0.26 0.35 0.55 2.34

B Short-term Solvency Ratios

1 Current Ratio 1.36 1.30 1.37 1.45 1.44

2 Quick Ratio or Liquid Ratio or Acid Test Ratio 0.83 1.06 1.13 1.19 1.17

3 Absolute Liquid Ratio 0.34 0.29 0.27 0.24 0.21

C Profitability Ratios
1 Return on Capital Employed or Return on
Investment 1.79% 3.34% 4.39% 6.30% 8.50%

2 Gross Profit Margin 97.15% 86.25% 81.02% 81.12% 73.86%

3 Net Profit Margin 0.81% 1.83% 2.01% 2.55% 2.64%

4 Cash Profit Ratio 0.81% 4.28% 3.98% 4.12% 3.90%

5 Return on Net Worth 9.94% 22.15% 23.28% 26.98% 25.87%

6 Operating Profit (before interest) Margin 0.81% 3.89% 3.66% 3.87% 3.69%

7 Operating Profit (after interest) Margin 0.81% 1.83% 2.01% 2.55% 2.64%
 Page 13 of 14 Assessment of Working Capital Requirements

RATIO ANALYSIS
Name: CREATIVE MIND

Audited PROJECTIONS
Sr. No. Particulars Ideal Levels
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5
D Activity Ratios
1 Inventory Turnover Ratio 10.42 13.16 15.24 16.28 19.53
[Based on closing inventory]

2 Inventory Turnover Ratio 20.84 13.16 15.82 17.56 19.93

[Based on average inventory]

3 Inventory Turnover Ratio 0.59 1.81 3.00 3.31 5.21

[Based on cost of sales / average inventory]

4 Inventory Turnover Period

Based on net sales i & closing inventory 35.03 27.74 23.94 22.43 18.69
Based on net salesii& average inventory 17.51 27.74 23.07 20.79 18.31
Based on net cost of salesiii& average inventory 613.72 201.76 121.55 110.12 70.05

5 Debtors Turnover Ratio 11.28 4.09 4.38 4.38 5.41

[Based on closing debtors]

6 Debtors Turnover Ratio 22.57 6.36 4.72 4.87 5.44

[Based on average debtors]

7 Debtors Turnover Period

Based on net sales
i & closing debtors 32.35 89.20 83.36 83.36 67.48
Based on net sales
ii & average debtors 16.17 57.41 77.36 75.02 67.08

8 Creditors Turnover Ratio 1.38 6.08 11.03 6.08 9.00

[Based on closing creditors]

9 Creditors Turnover Ratio 2.76 2.51 11.48 8.51 9.80

[Based on average creditors]

10 Creditors Turnover Period

i Based on purchases & closing creditors 264.85 60.00 33.08 60.00 40.56
ii Based on purchases & average creditors 132.43 145.62 31.80 42.91 37.24

11 Fixed Assets Turnover Ratio 4.85 7.20 10.94 17.42 30.01

12 Assets Turnover Ratio 2.21 1.82 2.19 2.47 3.22

13 Working Capital Turnover Ratio 15.31 10.56 10.05 9.25 11.84

14 Sales to Capital Employed 12.30 12.09 11.59 10.58 9.81

E Operating Ratios
1 Domestic Sales Proportion 100.00% 100.00% 100.00% 100.00% 100.00%

2 Export Sales Proportion 0.00% 0.00% 0.00% 0.00% 0.00%

3 Material Cost Ratio 11.14% 10.10% 15.89% 16.28% 23.04%

4 Consumables Cost Ratio 0.00% 0.00% 0.00% 0.00% 0.00%

5 Direct Labour Cost Ratio 1.31% 1.20% 1.60% 1.92% 2.05%

6 Other Direct Cash Overheads Cost Ratio 0.00% 0.00% 0.00% 0.00% 0.00%

7 Total Direct Cost Ratio [excl material & consumables]

1.31% 3.65% 3.57% 3.49% 3.31%

8 Total Direct Cost Ratio [incl material & consumables]

12.45% 13.75% 19.46% 19.78% 26.35%

9 Indirect Cost Ratio 96.34% 82.36% 77.37% 77.25% 70.16%

10 Interest Cost Ratio 0.00% 2.06% 1.65% 1.32% 1.05%

11 Operating Cost Ratio 99.19% 98.17% 97.99% 97.45% 97.36%

 Assessment of Working Capital Requirements Rs. in Lakhs
STATEMENT OF CHANGES IN WORKING CAPITAL
Name: CREATIVE MIND
PROVISIO
PROJECTIONS
Sr. NAL
Particulars
No.
31-Mar-18 31-Mar-19 31-Mar-20 31-Mar-21 31-Mar-22
Year 1 Year 2 Year 3 Year 4 Year 5

Current Assets
Cash and bank balances 2.43 4.50 4.50 4.50 4.00
Investments
Investments [other than long term] - - - - -
Government & other trustee securities - - - - -
Fixed deposits with Banks & Others - - - - -
Receivables
Receivables other than deferred & exports 3.51 12.22 14.27 17.84 18.05
Export receivables - - - - -
Instalments under deferred receivables - - - - -
Inventory
Raw Materials
Imported - - - - -
Indigeneous - - - - -
Work [ Stock ] in Process - - - - -
Finished Goods 3.80 3.80 4.10 4.80 5.00
Goods in Transit - - - - -
Other consumable spares
Imported - - - - -
Indigeneous - - - - -
Advances to suppliers - - - - -
Advance payment of taxes - - - - -
Security Deposits - - - - -
- - - - -
- - - - -
- - - - -
- - - - -
Total Current Assets 9.74 20.52 22.87 27.14 27.05
Change in the current assets 10.78 2.35 4.27 (0.09)

Current Liabilities
Short term borrowings from Banks
from Applicant Bank - 10.00 10.00 10.00 10.00
from Other Banks - - - - -
of which BP & BD
from Applicant Bank - - - - -
from Other Banks - - - - -
Short term borrowings from Others
Sundry Trade Creditors - Indigenous 3.20 0.83 0.90 2.09 2.50
Sundry Trade Creditors - Import - - - - -
Advance from Customers / deposits from dealers - - - - -
Provision for Taxation - - - - -
Dividend payable - - - - -
Other Statutory Liabilities - - - - -
Deposits / Debentures / Instalments of Term
Loans / DPGs etc. - - - - -
Other Current Liabilities and Provisions
Salary Payable 1.16 1.22 1.50 1.83 2.08
Royalty Payable 0.36 0.46 0.57 0.72 0.90
Other Payables 0.74 0.96 0.98 1.10 1.15
Other Payables 0.74 0.96 0.98 1.10 1.15
- - - - -
Total Current Liabilities 6.19 14.43 14.93 16.84 17.78
Change in the current liabilities 8.23 0.50 1.91 0.94
Net Working Capital as calculated above 3.55 6.09 7.94 10.30 9.27
Increase / (Decrease) in Net Working Capital - 2.54 1.85 2.36 (1.03)