jagomart
digital resources
picture1_Spreadsheet For Expenses 33143 | Project Report A&b


 197x       Filetype XLS       File size 0.37 MB       Source: www.wirc-icai.org


File: Spreadsheet For Expenses 33143 | Project Report A&b
blue chip projected balance sheet sr no particulars 202223 202324 202425 202526 202627 i sources of funds 1 share capital 1920 1920 1920 1920 1920 2 unsecured loan quasi equity ...

icon picture XLS Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
                                                                                       Blue Chip
                                                       PROJECTED BALANCE SHEET
        Sr.                                    
        No.   Particulars                      2022-23    2023-24   2024-25    2025-26   2026-27
          I   SOURCES OF FUNDS :
            1 Share Capital                        19.20      19.20     19.20      19.20     19.20
            2 Unsecured Loan (Quasi Equity)         5.00       5.00      5.00       5.00      5.00
            3 Reserves & Surplus                    3.98       9.25     15.94      23.32     31.40
                                                   28.18      33.45     40.15      47.52     55.60
            4 Loan Funds
              a. Term Loan                         19.90      16.58     13.27       9.95      6.63
              b. Working Capital Loan              24.66      28.77     32.87      32.87     32.87
                                                   44.56      45.35     46.14      42.82     39.50
            5 Sundry Creditors                      7.88       9.19     10.50      10.50     10.50
                                                   80.62      87.98     96.78    100.84     105.61
          II  APPLICATION OF FUNDS:
            1 Fixed Assets                         28.30      28.30     28.30      28.30     28.30
              Less: Depreciation                    1.57       3.06      4.48       5.82      7.10
                            Net Fixed Assets ::    26.73      25.24     23.82      22.48     21.20
            2 Current Assets :
               - Inventory                         14.84      17.30     19.77      19.77     19.77
               - Sundry Debtors                    32.40      37.80     43.20      43.20     43.20
               - Cash & Bank Balances               5.75       6.94      9.49      15.10     21.34
                                                   52.99      62.05     72.46      78.07     84.31
            3 Preliminary Expenses                        0.90             0.70             0.50             0.30             0.10 
                                                   80.62      87.98     96.78    100.84     105.61
                                                 Page 37
The words contained in this file might help you see if this file matches what you are looking for:

...Blue chip projected balance sheet sr no particulars i sources of funds share capital unsecured loan quasi equity reserves surplus a term b working sundry creditors ii application fixed assets less depreciation net current inventory debtors cash bank balances preliminary expenses page...

no reviews yet
Please Login to review.