All in One
All in One
PURCHASES 500000
SALES 800000
EXPENSES 96000
CREDITORS 50000
RECEIVABLES 100000
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
Dharapuram (Taluk),
2
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
4 Operating Profit (before 337333.33 Dharapuram
328844.44 (Taluk),
368988.15 447506.72 487730.64 534994.79 587991.29
Interest
and Depriciation [1(iii) - 2(vii) -
3]
8
(i.)Add: Other non-operating
9 ProfitIncome
Before TAX/Loss [7 + 308333.33 262844.44 303888.15 383216.72 424169.64 472089.89 525676.88
10 8(iii)]
Provision for Taxes 0.00 0.00 0.00 0.00 0.00 0.00 0.00
11 Net Profit/Loss (9 - 10) 308333.33 262844.44 303888.15 383216.72 424169.64 472089.89 525676.88
12
(i.) Equity dividend paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(ii.) Dividend Rate 0.00 0.00 0.00 0.00 0.00 0.00 0.00
13 Retained Profit (11 - 12) 308333.33 262844.44 303888.15 383216.72 424169.64 472089.89 525676.88
14 Retained Profit/Net Profit (%) 100 100 100 100 100 100 100
(13/11)** In Case of firms,
drawing made during the year
by
proprietors/partners
3
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
Dharapuram (Taluk),
4
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
Dharapuram (Taluk),
20 Ordinary share capital 308333.33 571177.78 566732.59 687104.86 807386.35 896259.52 997766.77
21 General reserve
22 Revaluation Reserve
23 Other reserves(excluding
provision)
5
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
24 Surplus (+) or deficit (-) in 0.00 Dharapuram
0.00 (Taluk),
0.00 0.00 0.00 0.00 0.00
profit and
25 Loss account
Net Worth 308333.33 571177.78 566732.59 687104.86 807386.35 896259.52 997766.77
26 Total Liabilities (19+25) 833333.33 1146177.78 1191732.59 1362104.86 1532386.35 1671259.52 1822766.77
34 Other current assets (specify 0.00 0.00 0.00 0.00 0.00 0.00 0.00
major
items)
6
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
35 Total Current Assets(add 27 580000.00 Dharapuram
657200.00 (Taluk),
747464.00 854259.68 982420.84 1138786.34 1333153.20
To 34)
Fixed Assets
36 Gross Block (land & bulding, 96000.00 86400.00 77760.00 72900.00 65610.00 59049.00 53144.10
machinery,[Link]-in-
progress)
37 Depreciation to date 9600.00 8640.00 7776.00 7290.00 6561.00 5904.90 5314.41
46 Net Working Capital 221933.33 493417.78 496748.59 621494.86 748337.35 843115.42 949937.08
[(18+25) -
(38+42+43)] Tally With
Net Working Capital (35-10) 55000.00 935250.49 1498266.92 2250446.34 3096686.19 3516427.39 4073623.94
47 Current Ratio (Items 35/10) 1.10 1.14 1.20 1.27 1.36 1.47 1.62
48 Total Outside Liabilities/ 1.70 1.01 1.10 0.98 0.90 0.86 0.83
Tangible Net
worth(19/45)
7
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
Dharapuram (Taluk),
(Months' cost of Sales:) 6.38 6.62 5.96 6.72 6.36 6.41 6.92
2 Receivables other than 0.00 0.00 0.00 0.00 0.00 0.00 0.00
export and deferred
receivables (including bills
purchased & discounted by
(Months' domestic
bankers 1.50 1.09 1.70 2.14 2.37 2.37 2.51
3 Exportsales:)
receivables (including 0.00 0.00 0.00 0.00 0.00 0.00 0.00
bills
purchased & discounted)
8
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
Dharapuram (Taluk),
10 Other current liabilities 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(Specify major items
such as Short-term
borrowing, unsecured
loans, dividend
payable, instalments of
TL. DPG, Public
deposits,debentures,et
11 Total (To agree with 50000.00 100000.00 150000.00 200000.00 250000.00 300000.00 350000.00
sub-total B-
Form III)
9
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
Dharapuram (Taluk),
2 Current Liabilities (Other than 50000.00 100000.00 150000.00 200000.00 250000.00 300000.00 350000.00
bank
borrowing) (2 to 9 of Form III)
3 Working Capital Gap (WCG)(1- 530000.00 557200.00 597464.00 654259.68 732420.84 838786.34 983153.20
2)
4 Minimum stipulated net 132500.00 139300.00 149366.00 163564.92 183105.21 209696.59 245788.30
working Capital i.e. 25% of
WCG/25% of total current asset
as the case may be depending
upon the method of lending
being applied (Export
receivables to be excluded
under
both methods)
5 Actual/projected net working 0.00 0.00 0.00 0.00 0.00 0.00 0.00
capital (46 in Form III)
10
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
6 Assessed Bank Finance (3-4) 397500.00 Dharapuram
417900.00 (Taluk),
448098.00 490694.76 549315.63 629089.76 737364.90
(c.) Increase in: 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(i.) Fixed Assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(ii.) Other non-current 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(d.) assets
Dividend payments 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(e.) Others 0.00 0.00 0.00 0.00 0.00 0.00 0.00
11
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
(f.) Total 0.00 Dharapuram
0.00 (Taluk),
0.00 0.00 0.00 0.00 0.00
3 Long-term Surplus (+)/Deficit 0.00 271844.44 311988.15 390506.72 430730.64 477994.79 530991.29
(-)(1-
2) * (as per details given
below)
FINANCIAL RATIOS
PARTICULARS ESTIMATE PROJECTED YEARS
D
31/03/2025 31/03/2026 31/03/2027 31/03/2028 31/03/2029 31/03/2030 31/03/2031
1 General Parameter
(i) Growth In Net Sale 0.00 20.00 15.00 15.00 10.00 10.00 10.00
(ii) Growth In Net Profit 0.00 9.70 15.62 26.10 10.69 11.30 11.35
(iii) Growth In Net Worth 0.00 85.25 18.23 21.24 17.51 11.01 11.33
(iv) Export Sales/Total Sales 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(v) Domestic Sales/Total Sales 100.00 100.00 100.00 100.00 100.00 100.00 100.00
2 Liquidity Ratio
(i) Current Ratio 1.36 1.74 2.11 2.61 3.18 3.43 3.33
(ii) Quick Ratio 0.35 0.32 0.70 1.09 1.67 1.91 1.98
3 Turnover Ratio
(i) Stock Turnover Ratio:-
(a) Raw Material N.A. N.A. N.A. N.A. N.A. N.A. N.A.
(b) Work in Process N.A. N.A. N.A. N.A. N.A. N.A. N.A.
(c) Finished Goods/ Traded 2.63 3.08 2.87 2.79 2.89 3.03 3.15
Goods
(ii) Debtor Turnover Ratio 8.00 11.32 9.07 6.42 5.56 5.23 5.12
(iii) Average Collection Period 45.00 31.80 39.69 56.07 64.75 68.83 70.31
(iv) Creditors Turnover Ratio 14.00 13.51 10.91 9.42 8.88 8.59 6.54
(v) Average Payment Period 25.71 26.65 33.00 38.22 40.54 41.91 55.05
(vi) Fixed Assets Turnover Ratio 35.56 57.28 72.76 85.57 104.59 124.07 149.96
(vii) Total Assets Turnover Ratio 1.85 2.03 1.82 1.51 1.35 1.31 1.22
4 Solvency Ratio
12
Dhanaseelan P
93 anthoniyar kovil street,Alangiyam,
31/03/2025 Dharapuram
31/03/2026 (Taluk), 31/03/2028
31/03/2027 31/03/2029 31/03/2030 31/03/2031
(i) Debt-Equity Ratio 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(ii) Total Outside Liability/Total 2.28 1.25 0.86 0.60 0.45 0.41 0.42
Net Loan/Cash Profit
(iii) Term 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(iv) Term Loan Interest/Term
(v) WC Interest/WC Borrowing 0.07 0.14 0.14 0.14 0.14 0.14 0.14
5 Coverage Ratio
(i) Interest Coverage Ratio 6.02 4.76 5.27 6.73 7.46 8.03 9.09
6 Profitability Ratio
(i) Gross Profit Ratio 18.83 19.14 18.21 21.55 22.17 23.37 25.46
(ii) Operating Profit Ratio 10.23 10.54 10.46 13.27 13.60 13.86 14.66
(iii) Net Profit Ratio 10.23 10.54 10.46 13.27 13.60 13.86 14.66
(iv) Return On Capital Employed 33.93 25.05 18.08 16.31 13.43 12.90 12.84
(v) Return On Net Worth 62.07 48.11 35.32 32.16 26.61 25.60 25.52
(vi) Retention Ratio 100.00 100.00 100.00 100.00 100.00 100.00 100.00
(vii) Payout Ratio 0.00 0.00 0.00 0.00 0.00 0.00 0.00
7 Funding of Current Assets
(i) Bank Borrowing 58.02 43.08 33.35 26.02 21.03 19.13 16.31
(ii) Trade Creditors 15.27 14.51 14.04 12.33 10.41 10.07 13.74
(iii) Net Wroking Capital 26.71 42.41 52.60 61.65 68.56 70.80 69.95
(iv) Other Current Liability 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(v) Toatl Current Assets 100.00 100.00 100.00 100.00 100.00 100.00 100.00
13
FORM III (ANALYSIS OF BALANCE SHEET)
PARTICULARS ESTIMATE PROJECTED YEARS
D
31/03/2025 31/03/2026 31/03/2027 31/03/2028 31/03/2029 31/03/2030 31/03/2031
Current Liabilites
1 Short-Term borrowings from
banks (including bills purchased
Discount & excess borrowings
placed on
repayment basis)
(i.) From applicant bank 475000.00 475000.00 475000.00 475000.00 475000.00 475000.00 475000.00
(ii.) From other banks 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(iii.) (Of which BP & BD) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-Total(A) 475000.00 475000.00 475000.00 475000.00 475000.00 475000.00 475000.00
2 Short-term borrowing from others 0.00 0.00 0.00 0.00 0.00 0.00 0.00
3 Sundry creditors(trade) 50000.00 100000.00 150000.00 200000.00 250000.00 300000.00 350000.00
4 Advance payments from
customers/deposits from dealers
5 Provision for taxation 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6 Dividend payable
7 Other statutory liabilities (due
within
one year)
8 Deposits/Instalments of term 0.00 0.00 0.00 0.00 0.00 0.00 0.00
loans/DPGs/debentures,etc. (due
within one year)
9 Other current liabilites & 0.00 0.00 0.00 0.00 0.00 0.00 0.00
provisions
(Due within 1 year)(Specify major
items)
31/03/2025 31/03/2026 31/03/2027 31/03/2028 31/03/2029 31/03/2030 31/03/2031
Sub-Total(B) 50000.00 100000.00 150000.00 200000.00 250000.00 300000.00 350000.00
10 Total current Liabilites(Total 1 To 525000.00 575000.00 625000.00 675000.00 725000.00 775000.00 825000.00
9)
Term Liabilites
11 Debentures(not maturing within
one
Year
12 Preference Shares (redeemable
after
one year)
13 Term loans (excluding 0.00 0.00 0.00 0.00 0.00 0.00 0.00
instalments
payable within one years)
14 Deferred Payment Credits
(excluding
instalments due within one year)
15 Terms deposits (repayment after
1
year)
16 From Directors & relatives
17 Other terms liabilities
18 Total terms liabilities(Add 11 to 0.00 0.00 0.00 0.00 0.00 0.00 0.00
19 17)
Total Outside Liabilites(10+18) 1200000.00 1270000.00 1350000.00 1400000.00 1420000.00 1450000.00 1750000.00
Net worth
20 Ordinary share capital 557333.33 820177.78 1124065.93 1507282.64 1931452.28 2403542.17 2929219.05
21 General reserve
22 Revaluation Reserve
23 Other reserves(excluding
24 provision)
Surplus (+) or deficit (-) in profit 0.00 0.00 0.00 0.00 0.00 0.00 0.00
and
Loss account
25 Net Worth 557333.33 820177.78 1124065.93 1507282.64 1931452.28 2403542.17 2929219.05
26 Total Liabilities (19+25) 1757333.33 2090177.78 2474065.93 2907282.64 3351452.28 3853542.17 4679219.05
Current Assets
27 Cash and bank balances 20000.00 55720.00 -11780.00 402460.00 104720.00 307380.00 144600.00
28 Investment(other than long-term
(i.) Government & other Trust 0.00 0.00 0.00 500000.00 500000.00 1000000.00 1200000.00
securities
(ii.) Fixed deposits with banks 0.00 0.00 0.00 0.00 0.00 0.00 0.00
29
(i.) Receivables other than 100000.00 110000.00 150000.00 175000.00 220000.00 300000.00 350000.00
deferred and
exports(including bills
purchased & discounted by
banks)
(ii.) Export receivables 0.00 0.00 0.00 0.00 0.00 0.00 0.00
(including bills purchased/
discounted by
banks)of deferred
30 Instalments
31 receivables
Inventory
(i.) Finished goods 1215000.00 1800000.00 1900000.00 2120000.00 2150000.00 2200000.00 2360000.00
32 Advance to suppliers of raw
33 material
Advances payment of taxes
34 Other current assets (specify 0.00 0.00 0.00 0.00 0.00 0.00 0.00
35 major
Total Current Assets(add 27 To 1335000.00 1965720.00 2038220.00 3197460.00 2974720.00 3807380.00 4054600.00
34)
Fixed Assets
36 Gross Block (land & bulding, 100000.00 90000.00 81000.00 72900.00 65610.00 59049.00 53144.10
37 Depreciation to date 10000.00 9000.00 8100.00 7290.00 6561.00 5904.90 5314.41
38 Net Block(36-37) 90000.00 81000.00 72900.00 65610.00 59049.00 53144.10 47829.69
Other Non-Current Assets
39 Investments
40 Obsolete stock
41 Other non-current assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
42 Total other non-current Assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
43 (Total
Intangible assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
44 Total Assets (35+38+42+43) 1425000.00 2046720.00 2111120.00 3263070.00 3033769.00 3860524.10 4102429.69
45 Tangible Net worth(25-43) 557333.33 820177.78 1124065.93 1507282.64 1931452.28 2403542.17 2929219.05
467333.33 739177.78 1051165.93 1441672.64 1872403.28 2350398.07 2881389.36
46 Net Working Capital [(18+25) - 467333.33 739177.78 1051165.93 1441672.64 1872403.28 2350398.07 2881389.36
(38+42+43)] Tally With
Net Working Capital (35-10) 810000.00 935250.49 1498266.92 2250446.34 3096686.19 3516427.39 4073623.94
47 Current Ratio (Items 35/10) 2.54 3.42 3.26 4.74 4.10 4.91 4.91
48 Total Outside Liabilities/ Tangible 2.15 1.55 1.20 0.93 0.74 0.60 0.60
Net
FORM IV (COMPARATIVE STATEMENT OF CURRENT ASSETS AND CU
PARTICULARS ESTIMATED PRO
31/03/2025 31/03/2026 31/03/2027
A. Current Assets
1 Stock-in-Trade: 1215000.00 1800000.00 1900000.00
(Months' cost of Sales:) 6.38 6.62 5.96
2 Receivables other than export and 100000.00 110000.00 150000.00
deferred receivables (including bills
purchased & discounted by bankers
6 Profitability Ratio
(i) Gross Profit Ratio 18.83 19.14 18.21 21.55 22.17
(ii) Operating Profit Ratio 10.23 10.54 10.46 13.27 13.60
(iii) Net Profit Ratio 10.23 10.54 10.46 13.27 13.60
(iv) Return On Capital 33.93 25.05 18.08 16.31 13.43
Employed
(v) Return On Net Worth 62.07 48.11 35.32 32.16 26.61
(vi) Retention Ratio 100.00 100.00 100.00 100.00 100.00
(vii) Payout Ratio 0.00 0.00 0.00 0.00 0.00
7 Funding of Current Assets
(i) Bank Borrowing 58.02 43.08 33.35 26.02 21.03
(ii) Trade Creditors 15.27 14.51 14.04 12.33 10.41
(iii) Net Wroking Capital 26.71 42.41 52.60 61.65 68.56
(iv) Other Current Liability 0.00 0.00 0.00 0.00 0.00
(v) Toatl Current Assets 100.00 100.00 100.00 100.00 100.00
D YEARS
31/03/2030 31/03/2031
6.76 8.79
8.83 15.11
13.11 15.46
0.00 0.00
100.00 100.00
3.43 3.33
1.91 1.98
N.A. N.A.
N.A. N.A.
3.03 3.15
5.23 5.12
68.83 70.31
8.59 6.54
41.91 55.05
124.07 149.96
1.31 1.22
31/03/2030 31/03/2031
0.00 0.00
0.41 0.42
0.00 0.00
0.14 0.14
8.03 9.09
23.37 25.46
13.86 14.66
13.86 14.66
12.90 12.84
25.60 25.52
100.00 100.00
0.00 0.00
19.13 16.31
10.07 13.74
70.80 69.95
0.00 0.00
100.00 100.00
FORM VI (FUNDS FLOW STATEMENT)
PARTICULARS ESTI PROJECTED YEARS
MATE
D
31/03/2025 31/03/2026 31/03/2027 31/03/2028 31/03/2029 31/03/2030 31/03/2031