Spreadsheet: 874790d1721300389-balance-sheet-figures-from-the-excel-table-b_s
Sheet: Sheet1

 | I'm kindly requesting a formula to produce [NAME] using information from table B_S.  Please not that the table can expand or
 | contract depending on the number accounts entered  in the B_S table for example if I add loan, the balance sheet  contents will  increase
 | and balance sheet sections also increase - long term liabilities.
↓ | Desired solution
 |  | Notes | USD
 | Non-current Assets |  |  |  |  |  | Trial Balance:  01/01/2024 - 31/12/2024
 | Property, Plant and Equipment | 1 | 276987321.2511833 |  |  |  | Balance Sheet |  |  |  |  |  |  |  | ADJUSTED FORMULA
 |  |  |  |  |  |  | Details | Debit | Credit | Balance Sheet Contents | Balance Sheet Sections
 | Current Assets |  |  |  |  |  | Accumulated Funds |  | 54105192 | Accumulated funds | Equity
Inventory | Trade and other receivables | 2 | 210217248.8298378 |  |  |  | Revaluation surplus |  | 228020401.55 | Revaluation surplus | Equity |  |  |  | Property, Plant and Equipment | 339027212.9708167
 | Cash and cash equivalents | 3 | 31825333.93 |  |  |  | Buildings @ Cost | 136866780 |  | Property, Plant and Equipment | Non-current Assets
 |  |  |  |  |  |  | Equipment @ Cost | 65674327.51 |  | Property, Plant and Equipment | Non-current Assets |  |  |  |  | 339027212.9708167
 |  |  |  |  |  |  | Equipment Accum depreciation |  | 11099853.22066667 | Property, Plant and Equipment | Non-current Assets |  |  |  | Current Assets
 | Total Assets |  |  |  |  |  | Motor Vehicle @ Cost | 90473176.05 |  | Property, Plant and Equipment | Non-current Assets |  |  |  | Trade and other receivables | 210217248.8298378
 |  |  |  |  |  |  | Motor Vehicle Accum depreciation |  | 13923699.21875 | Property, Plant and Equipment | Non-current Assets |  |  |  | Cash and cash equivalents | 31825333.93
 | Equity |  |  |  |  |  | Furniture @ Cost | 14992983.551 |  | Property, Plant and Equipment | Non-current Assets |  |  |  | Inventory | 40000
 | Accumulated funds |  | 54105192 |  |  |  | Equipment Accum depreciation |  | 5996393.4204 | Property, Plant and Equipment | Non-current Assets
 | Net Surplus for the year |  | 30548039.02093157 |  |  |  | Accounts receivable | 210217248.8298378 |  | Trade and other receivables | Current Assets |  |  |  |  | 242082582.7598378
 | Revaluation surplus |  | 228020401.55 |  |  |  | Bank Account ZWL | 17767745.01 |  | Cash and cash equivalents | Current Assets |  |  |  | Total Assets | 581109795.7306545
 |  |  |  |  |  |  | Bank Account US$ | 14057588.92 |  | Cash and cash equivalents | Current Assets
Long-term liabilities | → |  |  |  |  |  | Inventory | 40000 |  | Inventory | Current Assets | ↗ |  |  | Equity
Loan | Current Liabilities |  |  |  |  |  | Water and Rates |  | 70228076.44319999 | Provisions | Current Liabilities | ↘ |  |  | Accumulated funds | 54105192
 | Provisions | 4 | 102792157.9079245 |  |  |  | Telone Payable |  | 373364.85 | Provisions | Current Liabilities |  |  |  | Revaluation surplus | 228020401.55
 | Other obligations | 5 | 103564113.532165 |  |  |  | Accountant Fees Payable |  | 32190716.61472448 | Provisions | Current Liabilities |  |  |  | Net Surplus for the year
 |  |  |  |  |  |  | Net salaries Payable |  | 12000 | Other obligations | Current Liabilities
 |  |  |  |  |  |  | NEC Payable |  | 3490894.05 | Other obligations | Current Liabilities |  |  |  |  | 282125593.55
 | Total Equity and Liabilities |  |  |  |  |  | NSSA Payable |  | 271660.16 | Other obligations | Current Liabilities |  |  |  | Long-term Liabilities
 |  |  |  |  |  |  | Funeral Payable |  | 35380844.852716 | Other obligations | Current Liabilities |  |  |  | Loan | 40000
 | Check |  |  |  |  |  | Pension & Life Cover Payable |  | 32190716.61472452 | Other obligations | Current Liabilities
 |  |  |  |  |  |  | Trade Union Payable |  | 32190716.61472452 | Other obligations | Current Liabilities |  |  |  |  | 40000
 |  |  |  |  |  |  | PAYE Payable |  | 27281.24 | Other obligations | Current Liabilities |  |  |  | Total Equity & Liabilities | 282165593.55
 |  |  |  |  |  |  | Loan |  | 40000 | Loan | Long-term liabilities
 |  |  |  |  |  |  | Net Surplus / (Deficit) for the year |  | 30548039.02093157 | Net Surplus for the year | Equity
 |  |  |  |  |  |  | Revaluation surplus |  | 228020401.55 | Revaluation surplus | Equity