Cost of Project & Means of Finance
Annexure- 1
Rs. in lakhs
COST OF PROJECT Total
Working Capital Requirement 282.68
Total 282.68
MEANS OF FINANCE Amount
Promoter's Contribution & Internal
accruals 82.68
Working Capital Loan 200.00
Total 282.68
0
Annexure- 2
Projected Balance Sheet Figures in Rs. Lacs
Particulars 2021-22 2022-23 2023-24 2024-25 2025-26
AUDITED AUDITED ESTIMATED PROJECTED PROJECTED
Liabilities
Proprietor's Capital 14.27 14.27 14.27 14.27 14.27
Profit & Loss A/c 37.51 70.63 123.70 186.43 266.62
Drawings -11.87 -35.36 -45.36 -50.36 -60.36
39.90 49.54 92.61 150.34 220.53
Unsecured Loan 13 5.00 0.00 0.00
Sundry Creditors 8.29 38.57 19.20 22.30 25.45
CC (working capital loan) 200.00 200.00 200.00
Other Current liabities & Provisions 6.07 39.93 35.00 40.00 40.00
Total 54.26 141.05 351.81 412.64 485.99
Assets
Fixed Assets
-Gross block 6.11 7.31 5.89 5.89 5.89
-Less: Dep. 0.98 1.42 1.14 1.97 2.62
5.13 5.89 4.75 3.92 3.27
Current Assets
Cash & Bank balances 8.08 27.28 20.06 16.47 28.13
Debtors 27.67 84.11 258.75 310.50 357.08
Other Current assets 13.39 22.31 25.12 30.00 38.00
Closing Stock 0 1.46 43.13 51.75 59.51
Total 54.26 141.05 351.81 412.64 485.99
0
Annexure- 3
Projected Profitability Statement Figures in Rs. Lacs
Particulars 2021-22 2022-23 2023-24 2024-25 2025-26
AUDITED AUDITED ESTIMATED PROJECTED PROJECTED
A. Receipt
Gross Receipts 331.14 314.76 1035.00 1242.00 1428.30
331.14 314.76 1035.00 1242.00 1428.30
B Direct Expenses
Cost of Goods Sold 267.45 246.69 879.75 1061.91 1214.06
C. Gross Margin (A-B) 63.69 68.06 155.25 180.09 214.24
Administrative & Selling expenses 25.20 33.53 61.35 73.62 84.67
(i) Staff Salary 12.32 24.49 31.84 38.21 43.94
(ii) Vehicle Running & Maintenance Charges 2.27 2.12 2.76 3.31 3.81
(iii) Accounting & Auditing expenses 0.10 0.12 0.16 0.19 0.22
(iv) Business Promotion expense 0.29 0.98 1.27 1.53 1.76
(v) Telephone & internet expenses 0.05 0.16 0.20 0.24 0.28
(vi) Office Expenses 0.27 1.17 1.52 1.83 2.10
(vii) Bank Charges 0.02 0.07 0.09 0.11 0.13
(viii) Designing Services 0.00 0.00 15.20 18.24 20.97
(ix) Other expenses 9.88 4.41 8.30 9.97 11.46
E. Profit before Depreciation. & Interest 38.50 34.53 93.90 106.47 129.58
F. Financial Expenses
-Interest on Working capital - - 22.00 22.00 22.00
Profit before Depreciation & Tax 38.50 34.53 71.90 84.47 107.58
Depreciation 0.98 1.42 1.14 0.83 0.65
Profit before Tax 37.51 33.12 70.76 83.63 106.93
Taxation 10.46 8.02 17.69 20.91 26.73
Profit after Tax. 27.05 25.10 53.07 62.72 80.19
Cash Accruals 28.03 26.51 54.21 63.56 80.84
0
Annexure- 5
OPERATING STATEMENT
Figures in Rs. Lacs
YEAR 2023-24 2024-25 2025-26
ESTIMATED PROJECTED PROJECTED
1.GROSS RECEIPT
i) Domestic 1035.00 1242.00 1428.30
ii) Export
TOTAL 1035.00 1242.00 1428.30
2.Less Excise duty 0.00 0.00 0.00
3.Net sales(1-2) 1035.00 1242.00 1428.30
4.% age rise(+) or fall(-) in net sales as 20.00 15.00
compared to previous year
5.Cost of Sales
i) Purchases of Finished Goods 894.58 1039.35 1186.23
ii) Direct expenses 26.83 31.18 35.58
vii) Depreciation 1.14 0.83 0.65
viii)SUB-TOTAL( i to vii) 922.54 1071.36 1222.47
viii)Add:Opening stock-in-process. 0.00 0.00 0.00
922.54 1071.36 1222.47
ix)Deduct Closing stock-in-process 0.00 0.00 0.00
x)Cost of production 922.54 1071.36 1222.47
xi)Add: Opening stock of finished goods 1.46 43.13 51.75
SUB-TOTAL 924.01 1114.49 1274.22
xii)Deduct Closing stock of finished goods 43.13 51.75 59.51
xiii)SUB-TOTAL(COST OF SALES) 880.88 1062.74 1214.70
6.Selling,administrative and general expenses 61.35 73.62 84.67
7.SUB-TOTAL(5+6) 942.23 1136.36 1299.37
8.Operating profit before interest (3-7) 92.77 105.64 128.93
9. Interest Working capital 22.00 22.00 22.00
10.Operating profit after interest(8-9) 70.77 83.64 106.93
11.Add: Other non operative income
Deduct:Other non operative expenses
Net other non-operative income/expenses 0.00 0.00 0.00
12.Profit/Loss Before Tax 70.77 83.64 106.93
13.Provision for tax 17.69 20.91 26.73
14.Net Profit/Loss 53.08 62.73 80.20
15 Equity dividend/ (withdrawals) 10.00 5.00 10.00
.Rate of dividend
16.Retained Profit 43.08 57.73 70.20
17.Retained Profit/Net Profit(%age) 81.16 92.03 87.53
ANALYSIS OF BALANCE SHEET
LIABILITIES 1st Year 2nd Year 3rd Year
CURRENT LIABILITIES ESTIMATED PROJECTED PROJECTED
1. Short term borrowings from banks (incl.bills pur.
disc. & excess borrowings, on repayment basis)
i) From Applicant Bank. 200.00 200.00 200.00
ii) From Other Banks.
iii) (of which BP & BD).
Sub-total (A) 200.00 200.00 200.00
2. Short term borrowings from others.
3. Sundry creditors (trade] 19.20 22.30 25.45
4. Advance payments from customers
5. Provision for taxation.
6. Dividend payable.
7. Other statutory liabilities (due within one year)
8. Deposits/instalments of TLs/Debentures, etc.
(due within one year).
9. Other Current Liabilities and provisions 35.00 40.00 40.00
(due within one year)
Sub-total (B). 54.20 62.30 65.45
10. TOTAL CURRENT LIABILITIES 254.20 262.30 265.45
TERM LIABILITIES;
13. Term loans (excl. inst. payable within one yr) 0.00 0.00 0.00
14. Defferred payment credits ( ")
15. Terms deposits (repayable after one year).
16. Other term liabilities. 5.00 0.00 0.00
17. Total term Liabilities 5.00 0.00 0.00
18. TOTAL OUTSIDE LIABILITIES 259.20 262.30 265.45
NET WORTH
19.Share Capital -31.09 -36.09 -46.09
20. Profit & Loss a/c 123.70 186.43 266.62
24. NET WORTH. 92.61 150.34 220.53
25. TOTAL LIABILITIES 351.81 412.64 485.99
ASSETS 1st Year 2nd Year 3rd Year
CURRENT ASSETS. ESTIMATED PROJECTED PROJECTED
26. Cash and bank balances. 20.06 16.47 28.13
27. Investments (other than long term investments)
i) Government and other trustee securities.
ii) Fixed deposits with banks. (Margin on BGs)
28. i) Receivables other than deferred and Exports 258.75 310.50 357.08
(incl.bills purchased/discountinued by banks)
ii) Export Receivables (incl. bills purchased/disc.)
29. Instalments of deferred receiv, (due within one yr)
30. Inventory:
i) Raw Materials (incl. stocks and other items used
in the process of manufacture)
a) Imported.
b) Indigenous. 0.00 0.00 0.00
ii) Stocks-in-Process. 0.00 0.00 0.00
iii) Finished goods. 43.13 51.75 59.51
iv) Other consumable spares.
a) Imported.
b) Indigenous.
31. Advances to suppliers of RMs and stores/spares.
32. Advance payment of taxes.
33. Other Current Assets (specify major items) 25.12 30.00 38.00
34. TOTAL CURRENT ASSETS 347.05 408.72 482.72
35. Gross Block (Laptops & Furniture) 5.89 5.89 5.89
36. Depreciation to date. 1.14 1.97 2.62
37. Net Block 4.75 3.92 3.27
OTHER NON-CURRENT ASSETS
38. Investment/book debts/advances/deposits which
are not current assets.
i) a) Investments in Subsidiary companies/ affilliates.
b) others.
ii) Advances to Suppliers of Capital good
iii) Deferred receivables(Maturity exceeding one year)
iv) Others. 0.00 0.00 0.00
39. Non -consumable stores and spares.
40. Other non-current assets incl. dues from Directors.
41. TOTAL OTHER NON-CURRENT ASSETS 0.00 0.00 0.00
42. Intangible Assets (Patents, goodwill, prel.expenses,
bad/doubtful, debts not provided for etc.)
43. TOTAL ASSETS 351.81 412.64 485.99
44. TANGIBLE NET WORTH 92.61 150.34 220.53
45. NET WORKING CAPITAL 92.86 146.42 217.26
46. WORKING CAPITAL Ratio 1.37 1.56 1.82
47. Total outside Liabilities/Tangible Net Worth 2.80 1.74 1.20
COMPARATIVE STATEMENT OF CURRENT ASSETS 2023-24 2024-25 2025-26
AND LIABILITIES AS PER BALANCE SHEET ESTIMATED PROJECTED PROJECTED
A ) CURRENT ASSETS
1) Raw materials(incl. stores and other items used
in the process of manufacture)
a)Imported: 0.00 0.00 0.00
(month`s consumption)
b)Indegenous 0.00 0.00 0.00
(month`s consumption) 0.00 0.00 0.00
2)Other consumable spares
a)Imported:
(month`s consumption)
b)Indegenous 0.00 0.00 0.00
(month`s consumption)
3)Stock -in -process: 0.00 0.00 0.00
Month's cost of production 0.00 0.00 0.00
4)Finished Goods. 43.13 51.75 59.51
(Month`s cost of sales) 0.59 0.58 0.59
5)Receivables other than export & deffered receivables 258.75 310.50 357.08
incl. bills purchased and discounted by bankers)
6)Export receivables(incl.bills purchased and discounted) 0.00 0.00 0.00
Month`s export sales
7)Advances to raw suppliers of raw material and stores/spar 0.00 0.00 0.00
8)Other current assets(incl. cash & bank balances) 45.18 46.47 66.13
9)Total current assets 347.05 408.72 482.72
B. CURRENT LIABILITIES
Other than bank borrowings.
(Net working Capital)
10. Creditors for purchase of raw materials,
stores and consumables stores and 19.20 22.30 25.45
month's purchases. 0.00 0.00 0.00
11. Advances from customers. 0.00 0.00 0.00
12. Statutory Liabilities. 0.00 0.00 0.00
13. Other Current Liabilities; 35.00 40.00 40.00
specify major items ; short term borrowings,
unsecured loans, dividends payable, instalments
of TL, DPG, Public deposits, debentures etc.
Expenses Provision. 0.00 0.00 0.00
T/L Instalments. 0.00 0.00 0.00
14. T O T A L 54.20 62.30 65.45
FORM VI 2024-25 2025-26
FUNDS FLOW STATEMENT PROJECTED PROJECTED
1. S O U R C E S ;
a) Net Profit (after tax) 62.73 80.20
b) Depreciation. 0.83 0.65
c) Increase in capital.&reserves 0.00 0.00
d) increase in Term Liabilities 0.00 0.00
(including Public deposits)
e) Decrease in
i) Fixed Assets. 0.00 0.00
ii) Other Non-Current Assets. 0.00 0.00
f) Others. 0.00 0.00
g) T O T A L. 63.56 80.85
2. U S E S
a) Net loss. 0.00 0.00
b) Decrease in term liabilities. 5.00 0.00
(including public deposits).
c) Increase in:
i) Fixed assets. 0.00 0.00
ii) Other Non-current assets. 0.00 0.00
d) Dividend payments.(Drawings) 5.00 10.00
e) Others. 0.00 0.00
f) T O T A L. 10.00 10.00
3. Long Term surplus (+)/deficit(-) (1-2). 53.56 70.85
4. Increase/Decrease in current assets. 61.66 74.00
(as per details given below)
5. Increase/Decrease in Current liabilities 8.11 3.15
other than Bank borrowings.
6. Increase/Decrease in Working Gap. 53.56 70.84
7. Net surplus (+)/Deficit(-)
(Difference of 3 and 6) 0.00 0.00
8. Increase/Decrease in bank borrowings. 0.00 0.00
BREAKUP OF (4)
I) Decrease/Increase in Raw materials. 0.00 0.00
ii) Increase/Decrease in Stocks-in-process. 0.00 0.00
iii) Increase/Decrease in Finished Goods. 8.63 7.76
iv) Increase/Decrease in Receivables.
a) Domestic. 51.75 46.57
b) Export. 0.00 0.00
v) Increase/Decrease in stores and spares. 0.00 0.00
vi) Increase/Decrease in other current assets. 1.29 19.66
Total 61.66 74.00
0
Annexure- 4
Projected Cash Flow Statement
Figures in Rs. Lacs
Particulars 2023-24 2024-25 2025-26
ESTIMATED PROJECTED PROJECTED
Cash Inflows
Cash Accruals 54.21 63.56 80.84
Increase in Capital 0.00 0.00 0.00
Increase in Creditors -19.37 3.11 3.15
CC ( Working capital loan) 200.00 0.00 0.00
Increase in other Current liabilities -4.93 5.00 0.00
Total 229.90 71.66 84.00
Cash Out Flows
Drawings from Capital 10.00 5.00 10.00
Decrease in Unsecured Loans 8.00 5.00 0.00
Increase in Debtors 174.64 51.75 46.57
Increase in Other Current Assets 2.81 4.88 8.00
Increase in Inventory 41.66 8.63 7.76
Total 237.12 75.26 72.34
Opening Balance 27.28 20.06 16.47
Surplus / Defecit -7.22 -3.59 11.66
Closing Balance 20.06 16.47 28.13
0
Annexure- 6
Calculation of Depreciation
Figures in Rs. Lacs
car Furniture & Air
PARTICULARS Fixtures Conditioner Computer Mobile Total
Rate of Depreciation 15.00 10.00 15.00 40.00 15.00
2023-24
GROSS BLOCK 3.09 0.69 0.12 1.00 0.98 5.89
LESS:DEP 0.50 0.07 0.02 0.40 0.15 1.14
NET BLOCK 2.59 0.63 0.10 0.60 0.83 4.75
2024-25
WDV 2.59 0.63 0.10 0.60 0.83 4.75
LESS:DEP 0.39 0.06 0.02 0.24 0.12 0.83
NET BLOCK 2.20 0.56 0.09 0.36 0.71 3.92
2025-26
WDV 2.20 0.56 0.09 0.36 0.71 3.92
LESS:DEP 0.33 0.06 0.01 0.14 0.11 0.65
NET BLOCK 1.87 0.51 0.07 0.22 0.60 3.27
0
Annexure- 8
Calculation of Working capital
Figures in Rs. Lacs
Sr. No. PARTICULARS Requirements 2023-24 2024-25 2025-26
(in months) ESTIMATED PROJECTED PROJECTED
1 Stock in Trade 0.50 43.13 51.75 59.51
2 Receivables 3.00 258.75 310.50 357.08
3 Less :Creditors 0.25 19.20 22.30 25.45
Total Working Capital Reqd. 282.68 339.95 391.13
Eligible Bank Finance
75% on item (1-3) & 75%on item 4 212.01 254.96 293.35
Working capital limit from bank 200.00 200.00 200.00
Margin 82.68 139.95 191.13
Interest on Working Capital Loan @ 11.00% 22.00 22.00 22.00
0
Annexure- 7
Calculation of Debt Service Coverage Ratio
Figures in Rs. Lacs
Particulars 2023-24 2024-25 2025-26 Total
ESTIMATED PROJECTED PROJECTED
Cash Accruals 54.21 63.56 80.84 198.61
Interest on Working Capital 22.00 0.50 22.00 44.50
Net operating Income 76.21 64.06 102.84 243.11
Interest on Working Capital 22.00 22.00 22.00 66.00
Debts to be served 22.00 22.00 22.00 66.00
Average DSCR 3.46 2.91 4.67 3.68
Average DSCR = Net Operating Income
Total Debts to be served
= 243.11
66.00
= 3.68 Times