PROJECTED BALANCE SHEET WITH CMA DATA
Click to Download PDF : Projected Balance Sheet
| M/S ABC PHARMACEUTICALS | |||
| PROP : RAM KUMAR | |||
| ADD : B/2, GALI NO. 6, LAXMI NAGAR, NEAR METRO, EAST DELHI, DELHI-110092 | |||
| BALANCE SHEET AS ON | |||
| YEAR | ESTIMATED 2021-22 |
PROJECTED 2022-23 |
PROJECTED 2023-24 |
| LIABILITIES | |||
| OPENING CAPITAL | 825920.00 | 1155434.00 | 1434945.30 |
| ADD : PROFIT DURING THE YEAR | 579514.00 | 629511.30 | 745957.50 |
| LESS : DRAWINGS | (250000.00) | (350000.00) | (450000.00) |
| CLOSING CAPITAL | 1155434.00 | 1434945.30 | 1730902.80 |
| SECURED/UNSECURED LOAN | |||
| CASH CREDIT | 800000.00 | 800000.00 | 800000.00 |
| TERM LOAN | 0.00 | 0.00 | 0.00 |
| OTHER BORROWINGS | 0.00 | 0.00 | 0.00 |
| SUNDRY CREDITORS FOR GOODS | 106320.00 | 116952.00 | 128647.20 |
| SUNDRY CREDITORS FOR EXPS. | 0.00 | 0.00 | 0.00 |
| OTHER LIABILITIES & PROVISION | 2500.00 | 2750.00 | 3025.00 |
| TOTAL | 2064254.00 | 2354647.30 | 2662575.00 |
| ASSETS | |||
| FIXED ASSETS | |||
| GROSS BLOCK | 360000.00 | 324000.00 | 291600.00 |
| LESS : DEP. | 36000.00 | 32400.00 | 29160.00 |
| NET BLOCK | 324000.00 | 291600.00 | 262440.00 |
| SUNDRY DEBTORS | 143950.00 | 215925.00 | 323887.50 |
| CLOSING STOCK | 688200.00 | 757020.00 | 832722.00 |
| INVESTMENTS & DEPOSITS | 100000.00 | 120000.00 | 144000.00 |
| LOANS & ADVANCES | 50000.00 | 50000.00 | 50000.00 |
| ADVANCE TO SUPPLIERS | 250000.00 | 275000.00 | 302500.00 |
| CASH IN HAND & AT BANK | 508104.00 | 645102.30 | 747025.49 |
| TOTAL | 2064254.00 | 2354647.30 | 2662575.00 |
SIR KINDLY SENT THIS FORMAT IN MICROSOFT OFFICE WORD
Sir,
Kindly Send me PROJECTED BALANCE SHEET WITH CMA DATA in Excel Format….
Kindly share the CMA report in excel format