PROJECTED PROFITABILITY STATEMENT PLC CAPS(INDIA) (Rs in Lakh)

Particulars 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030

ACTUAL PROJ PROJ PROJ PROJ PROJ PROJ
1. Gross Sales
a. Local Sales 190.71 209.78 251.74 302.08 362.50 435.00 522.00
b. Export Sales 0.00 0.00 0.00 0.00 0.00 0.00 0.00
c. Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
d. Misc. Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Sales 190.71 209.78 251.74 302.08 362.50 435.00 522.00

Total 190.71 209.78 251.74 302.08 362.50 435.00 522.00

2. Less Excise Duty 0.00 0.00 0.00 0.00 0.00 0.00 0.00
3. Net Sales 190.71 209.78 251.74 302.08 362.50 435.00 522.00
4. Percentage of rise 10.00 20.00 20.00 20.00 20.00 20.00
5. Cost of Sales
a. Raw Materials consumed 179.15 178.31 213.98 256.77 308.13 369.75 443.70
I. Imported 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ii. Indigenous 179.15 178.31 213.98 256.77 308.13 369.75 443.70
b. Stores and Spares 0.00 0.00 0.00 0.00 0.00 0.00 0.00
I. Imported
ii. Indigenous ( packing material)
c. Power and Fuel 0.00 0.00 0.00 0.00 0.00 0.00 0.00
d. Direct Labour 0.05 0.09 0.15 0.27 0.47 0.82 1.44
e. Repairs and Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00
f. Other Manufacturing Expenses 6.64 7.64 8.78 10.10 11.61 13.36 15.36
g. Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00
h. Sub-Total 185.84 186.04 222.91 267.14 320.21 383.93 460.50
Add Opening Stock in Process 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less Closing Stock in Process 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6. Cost Of Production 185.84 186.04 222.91 267.14 320.21 383.93 460.50
Add Opening Stock of Finished Goods 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less Closing Stock of Finished Goods 0.00 0.00 0.00 0.00 0.00 0.00 0.00
7. Cost of Sales 185.84 186.04 222.91 267.14 320.21 383.93 460.50
8. Gross Profit 4.87 23.74 28.83 34.95 42.29 51.07 61.51
9. Selling, General & Admn. Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10. Financial Charges/Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00
11. Sub-Total 185.84 186.04 222.91 267.14 320.21 383.93 460.50
12. Operating Profit 4.87 23.74 28.83 34.95 42.29 51.07 61.51
13. Add-Income
i. Interest Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ii. Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
iii.Remuneration & share from P Firm 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-Total(Income) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Deduct Non-operating Expenses
I. Directors remuneration 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ii. Other 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net off other Non-operating Income/exp. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
14. Profit Before Tax 4.87 23.74 28.83 34.95 42.29 51.07 61.51
15. Provision for Taxes 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Defferred Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00
16. Profit After Taxes 4.87 23.74 28.83 34.95 42.29 51.07 61.51
17 Withdrawal
NP RATIO 2.55 11.32 11.45 11.57 11.67 11.74 11.78

LIABILITIES 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030

ACTUAL PROJ PROJ PROJ PROJ PROJ PROJ
1. Share Capital 7.97 12.84 36.58 65.41 100.36 142.65 193.72
2. Share premium 0.00 0.00 0.00 0.00 0.00 0.00 0.00
3. Reserves-General 0.00 0.00 0.00 0.00 0.00 0.00 0.00
4. Drawing 0.00 0.00 0.00 0.00 0.00 0.00 0.00
5. Share application money 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6. P & L Account (profit) 4.87 23.74 28.83 34.95 42.29 51.07 61.51
Sub-Total 12.84 36.58 65.41 100.36 142.65 193.72 255.23
TERM LIABILITIES
7. Term Loans-Banks 0.00 0.00 0.00 0.00 0.00 0.00 0.00
8. Term Loans-Fis. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
9. Deposits payable after one year. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10.Deferred Payment Credits 0.00 0.00 0.00 0.00 0.00 0.00 0.00
11. Deferred Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00
12. Advance from Dealers 0.00 0.00 0.00 0.00 0.00 0.00 0.00
13. Term Deposits 0.00 0.00 0.00 0.00 0.00 0.00 0.00
14. Dprovision for Gratuity 0.00 0.00 0.00 0.00 0.00 0.00 0.00
15. Unsecured Loans 8.15 8.15 8.15 8.15 8.15 8.15 8.15
16. Other Term Liabilities 7.76 7.76 7.76 7.76 7.76 7.76 7.76
Sub-Total 15.91 15.91 15.91 15.91 15.91 15.91 15.91
CURRENT LIABILITIES
17. Bank Borrowings 0.00 0.00 0.00 0.00 0.00 0.00 0.00
18. Short Term Borrowings from Others 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Short Term Borrowings from Banks 0.00 10.00 10.00 10.00 10.00 10.00 10.00
19. Deposits 0.00 0.00 0.00 0.00 0.00 0.00 0.00
20. Advance Payment from Customers 0.00 0.00 0.00 0.00 0.00 0.00 0.00
21. Sundry Creditors-For Goods 13.55 14.91 16.40 18.04 19.84 21.82 24.00
-For Others 0.00 0.00 0.00 0.00 0.00 0.00 0.00
22. Provisions-
-For Tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-For Others 0.00 0.00 0.00 0.00 0.00 0.00 0.00
23. Term Loan Instalments due 0.00 0.00 0.00 0.00 0.00 0.00 0.00
24. Mobilisation Advances 0.00 0.00 0.00 0.00 0.00 0.00 0.00
25. Other Current liabilities 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other statutory liabilities 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Interest charges funded 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-Total 13.55 24.91 26.40 28.04 29.84 31.82 34.00
Total Outside Liabilities 29.46 40.82 42.31 43.95 45.75 47.73 49.91
Grand Total-Total Liabilities 42.30 77.40 107.72 144.30 188.40 241.46 305.14

ASSETS 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030

ACTUAL PROJ PROJ PROJ PROJ PROJ PROJ

FIXED ASSETS
1.Gross Block 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Less: Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Block 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2. Capital Work in Progress
3. Adv.for Capital Goods
Sub-Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Non-Current Assets
4. Investment in subsidiary Companies
5. Investment/Deposits 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6. P&OP
7. Goodwill/Misc.Exp
8. Profit & Loss (loss)
9. Other Non-Current Assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
a. Deffered Receivables
b. Other Advances 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CURRENT ASSETS
10. Inventory
a. Raw Materials-Imported
- Indigenous 0.00 0.00 0.00 0.00 0.00 0.00 0.00
b. Work in Process & Raw Material 0.00 0.00 0.00 0.00 0.00 0.00 0.00
c. Finished Goods 0.00 0.00 0.00 0.00 0.00 0.00 0.00
d. Stores & Spares-Impored
-Indigenous 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-total 0.00 0.00 0.00 0.00 0.00 0.00 0.00
11. Sundry Debtors less than six months- Local 39.73 52.45 62.93 75.52 90.63 108.75 130.50
-Exports
11. Sundry Debtors more than six months- Local
-Exports
12. Loans and Advances 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Export Incentive/ service tax receivable/other adv
share application money
13. Advances to suppliers/customers 0.00 0.00 0.00 0.00 0.00 0.00 0.00
14. Advance Payment of Taxes 0.00 0.00 0.00 0.00 0.00 0.00 0.00
15. Deposits 0.00 0.00 0.00 0.00 0.00 0.00 0.00
16. Cash and Bank Balances 2.57 24.95 44.78 68.78 97.77 132.70 174.64
17. Other Current Assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
a. Other Advances 0.00 0.00 0.00 0.00 0.00 0.00 0.00
b. Advances recovered in cash or kind 0.00 0.00 0.00 0.00 0.00 0.00 0.00
c. Others 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Current Assets 42.30 77.40 107.71 144.30 188.40 241.45 305.14
TOTAL ASSETS 42.30 77.40 107.71 144.30 188.40 241.45 305.14

0.00 0.00 0.00 0.00 0.00 0.00 0.00

SELECT FINANCIAL INDICATORS

2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030
ACTUAL PROJ PROJ PROJ PROJ PROJ PROJ
Capital 7.97 12.84 36.58 65.41 100.36 142.65 193.72
Share premium 0.00 0.00 0.00 0.00 0.00 0.00 0.00
share application 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Reserves and Surplus 4.87 23.74 28.83 34.95 42.29 51.07 61.51
Accumulated Losses 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Tangible Net Worth 12.84 36.58 65.41 100.36 142.65 193.72 255.23
Long Term loans from Banks / FIs 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Debenture /Bonds/ FCCB etc. 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Capital emplyed 12.84 36.58 65.41 100.36 142.65 193.72 255.23
Unsecured Loans 8.15 8.15 8.15 9.15 8.15 10.15 8.15
Current Assets 42.30 77.40 107.71 144.30 188.40 241.45 305.14
Current liabilities (CL) 13.55 24.91 26.40 28.04 29.84 31.82 34.00
Out of CL, Bank Borrowings – OD/CC 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Out of CL, Bank Borrowings-Bills Purchased 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Working Capital 28.75 52.49 81.32 116.27 158.56 209.63 271.14
Gross Block 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Depreciation (Cumulative) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Block 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Non-Current Assets 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Gross Sales 190.71 209.78 251.74 302.08 362.50 435.00 522.00
Net Sales 190.71 209.78 251.74 302.08 362.50 435.00 522.00
of the above Export Sales 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Income 190.71 209.78 251.74 302.08 362.50 435.00 522.00
Operating Profit 4.87 23.74 28.83 34.95 42.29 51.07 61.51
PBDIT 4.87 23.74 28.83 34.95 42.29 51.07 61.51
Net Profit Before Tax 4.87 23.74 28.83 34.95 42.29 51.07 61.51
Net Profit After Tax 4.87 23.74 28.83 34.95 42.29 51.07 61.51
Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Depreciation(year wise) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Cash Accruals 4.87 23.74 28.83 34.95 42.29 51.07 61.51
Ratios
Current Ratio 3.12 3.11 4.08 5.15 6.31 7.59 8.97
TOL: TNW 2.29 1.12 0.65 0.44 0.32 0.25 0.20
Debt Equity Ratio 1.24 0.43 0.24 0.16 0.11 0.08 0.06
PBDIT: Sales % 2.55 11.32 11.45 11.57 11.67 11.74 11.78
NPBT: NS % 2.55 11.32 11.45 11.57 11.67 11.74 11.78
Term Debt / PBDIT 0.00 0.00 0.00 0.00 0.00 0.00 0.00
PBDIT/ Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00
PAT/Equity (Return on Equity) 0.61 1.85 0.79 0.53 0.42 0.36 0.32
Operating Profit: Net Sales 2.55 11.32 11.45 11.57 11.67 11.74 11.78
NPBT: Net Sales% 2.55 11.32 11.45 11.57 11.67 11.74 11.78
NPAT: Net Sales% 2.55 11.32 11.45 11.57 11.67 11.74 11.78
Bank Borrowings: Net Sales% 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Inventory Turnover-- RM 0 0 0 0 0 0 0
Inventory Turnover-- FG 0 0 0 0 0 0 0
Debtors Velocity (local) (In Days) 75 90 90 90 90 90 90
Debtors Velocity (Exports)(In Days) 0 0 0 0 0 0 0
Creditors Velocity (In Days) 27 30 28 25 23 21 19
Inventory+ receivables –Bills discounted/Sales 0.21 0.25 0.25 0.25 0.25 0.25 0.25
TOL:TNW 2.29 1.12 0.65 0.44 0.32 0.25 0.20
TOL:TNW * 1.02 0.73 0.46 0.33 0.25 0.20 0.16
Debt:Equity 1.24 0.43 0.24 0.16 0.11 0.08 0.06
Debt:Equity* 0.37 0.17 0.11 0.07 0.05 0.04 0.03

DEBT SERVICE COVERAGE RATIO 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030
PROFIT AFTER TAX 4.87 23.74 28.83 34.95 42.29 51.07 61.51
DEPRECIATION 0.00 0.00 0.00 0.00 0.00 0.00 0.00
INTEREST(CC+TL) 0.00 0.00 0.00 0.00 0.00 0.00 0.00
INSTALLMENT 0.54 0.54 0.54 0.54 0.54 0.54 0.54

PAT+DEP+INTEREST
INTEREST+INSTALLMENT 9.02 43.97 53.38 64.72 78.32 94.58 113.90

Fund Position
Particulars 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030
ACTUAL PROJ PROJ PROJ PROJ PROJ PROJ
LTS 28.75 52.49 81.32 116.27 158.56 209.63 271.14
LTU 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus/Deficit*# 28.75 52.49 81.32 116.27 158.56 209.63 271.14
Short Term Sources 13.55 24.91 26.40 28.04 29.84 31.82 34.00
Less Short Term uses 42.30 77.40 107.71 144.30 188.40 241.45 305.14
Surplus/Deficit# -28.75 -52.49 -81.32 -116.27 -158.56 -209.63 -271.14

Fund Flow Statement 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030
ACTUAL PROJ PROJ PROJ PROJ PROJ PROJ
LTS 28.75 23.74 52.57 63.77 77.24 93.37 112.58
LTU 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus/Deficit*# 28.75 23.74 52.57 63.77 77.24 93.37 112.58
Short Term Sources 13.55 11.36 12.85 3.13 3.44 3.79 4.17
Less Short Term uses 42.30 35.09 65.41 66.91 80.68 97.15 116.75
Surplus/Deficit# -28.75 -23.74 -52.57 -63.78 -77.24 -93.36 -112.58
NWC 28.75 52.49 81.32 116.27 158.56 209.63 271.14
Last year NWC + difff of Long term funds 28.75 52.49 81.32 116.26 158.56 209.63 271.14

Maximum Permissible Bank Finance

Particulars 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030
ACTUAL PROJ PROJ PROJ PROJ PROJ PROJ
1. Gross Sales 190.71 209.78 251.74 302.08 362.50 435.00 522.00
2. Net Sales 190.71 209.78 251.74 302.08 362.50 435.00 522.00
3. Of the above Export Sales 0.00 0.00 0.00 0.00 0.00 0.00 0.00
4. Raw Materials Consumed-Imported 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-Indigenous 179.15 178.31 213.98 256.77 308.13 369.75 443.70
5. Stores and Spares 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6. Cost of Production 185.84 186.04 222.91 267.14 320.21 383.93 460.50
7. Cost of Sales 185.84 186.04 222.91 267.14 320.21 383.93 460.50
8. Net Working Capital 28.75 52.49 81.32 116.27 158.56 209.63 271.14

Current Assets
1. Raw Materials-Imported 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- Indigenous 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2. Work in Process 0.00 0.00 0.00 0.00 0.00 0.00 0.00
3. Finished Goods 0.00 0.00 0.00 0.00 0.00 0.00 0.00
4. Stores and Spares 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-total 0.00 0.00 0.00 0.00 0.00 0.00 0.00
5. Sundry Debtors-Local 39.73 52.45 62.93 75.52 90.63 108.75 130.50
-Exports 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6. Other Current Assets 2.57 24.95 44.78 68.78 97.77 132.70 174.64
8. Total Current Assets 42.30 77.40 107.71 144.30 188.40 241.45 305.14
9. Sundry Creditors 13.55 14.91 16.40 18.04 19.84 21.82 24.00
10. Other Current Liabilities 0.00 0.00 0.00 0.00 0.00 0.00 0.00
11. Total Current Liablities 13.55 14.91 16.40 18.04 19.84 21.82 24.00
12. Working Capital Gap 28.75 62.49 91.32 126.27 168.56 219.63 281.14
13. 25% of the Current Assets 10.58 19.35 26.93 36.08 47.10 60.36 76.29
14. Actual/Projected NWC 28.75 52.49 81.32 116.27 158.56 209.63 271.14
15. M P B F 21.56 46.87 68.49 94.70 126.42 164.72 210.85
16. Actual/Projected Bank Borrowings 0.00 0.00 0.00 0.00 0.00 0.00 0.00
17. Excess Borrowings 21.56 46.87 68.49 94.70 126.42 164.72 210.85
 INVENTORIES/DEBTORS/CREDITORS LEVELS ( In Months)
Particulars 2023-2024 2024-2025 2025-2026 2026-2027 2027-2028 2028-2029 2029-2030
ACTUAL PROJ PROJ PROJ PROJ PROJ PROJ
1. Raw Materials 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0 0 0 0 0 0 0
2. Work In Process 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0 0 0 0 0 0 0
3. Finished Goods 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0 0 0 0 0 0 0
4. Stores and Spares 0.00 0.00 0.00 0.00 0.00 0.00 0.00

5. Recievables-Local 2.50 3.00 3.00 3.00 3.00 3.00 3.00

75 90 90 90 90 90 90
-Exports 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0 0 0 0 0 0 0
6. Sundry Creditors 0.91 1.00 0.92 0.84 0.77 0.71 0.65
27 30 28 25 23 21 19

CALCULATION OF DRAWING POWER

Stock 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Creditors 13.55 14.91 16.40 18.04 19.84 21.82 24.00
NET for DP -13.55 -14.91 -16.40 -18.04 -19.84 -21.82 -24.00
DP with 25% Margin -10.16 -11.18 -12.30 -13.53 -14.88 -16.37 -18.00

Bood Debts 39.73 52.45 62.93 75.52 90.63 108.75 130.50

DP with 40% Margin 23.84 31.47 37.76 45.31 54.38 65.25 78.30

Total DP 13.68 20.29 25.46 31.79 39.50 48.88 60.30