Topic: Preparation and presentation of financial statements for local government

Search 500 + past questions and counting.
Professional Bodies Filter
Program Filters
Subject Filters
More
Tags Filter
More
Check Box – Levels
Series Filter
More
Topics Filter
More

a) The following details relate to Eminaa District Assembly for the year 2018.

Details GH¢’000
Dividend Received 93,250
Central Government Salaries 12,000,000
Basic Rates 370,900
Districts Development Facility 15,000,600
Rent from Land and Building 6,120,800
Established Posts 1,140,700
Other Expenditure 600,000
Non-Established Posts 580,000
Allowances 390,470
Court Fees 240,000
Inventory and Consumables 800,000
Sanitation Fees 370,000
General Cleaning 350,000
Common Fund 2,930,000
Social Benefit 840,300
Equity Investment Acquired 420,000
Infrastructure, Plant, and Equipment 980,000
Work-In-Progress 490,000
Loans Received 2,330,000
Interest Expense 200,000
Advances to Staff 660,000
Royalties 430,000
Consultancies cost 470,000
Training and Workshop cost 275,000
Transport and Travelling cost 620,000
Consumption of Fixed Assets 960,000
Special Services 820,000
Utilities 630,000
Market Tolls 870,000
Permit Fees 990,000
Fines and Penalties 330,000
Development Bonds Issued 1,300,000
Hostel License 630,920
Business Income 2,300,600
Chop Bar License 300,400
Proceeds from Sale of Equity 990,320
Accumulated Fund (1/1/2018) 370,600
Herbalist License 530,370
Cash and Cash Equivalent @ (1/1/2018) 12,300,240
Stool Land Revenue 600,000
Lorry Park Fees 720,400
Market Store Rent 300,750
Recoveries 194,000
Loan Repayment 143,000
Property Rate 820,900

Additional Information:

  1. Eminaa District Assembly adopts the accrual basis of accounting in the preparation of its financial statements.
  2. Established Post salaries outstanding as at 31/12/2018 were GH¢180,000,000.
  3. Inventory at 31/12/2018 was GH¢170,000,000.

Required:
Prepare for Eminaa District Assembly:

  • Statement of Financial Performance for the year ended 31/12/2018.

(7 marks)

b) Prepare a statement of cash flow for Eminaa District Assembly for the year ended 31/12/2018. (8 marks)

c) Subject to IPSAS 6: Consolidated and Separate Financial Statements, a Controlling Entity that presents Consolidated Financial Statements shall disclose certain basic information.

 

Explain FIVE (5) basic information that an institution preparing Consolidated Financial Statements needs to disclose. (5 marks)

a) Statement of Financial Performance:

EMINAA DISTRICT ASSEMBLY
STATEMENT OF FINANCIAL PERFORMANCE FOR THE YEAR ENDED 31ST DECEMBER 2018

Revenue GH¢’000
Decentralized Transfers 30,530,600
Internally Generated Funds (IGF) 14,888,920
Total Revenue 45,419,520
Expenditure GH¢’000
Compensation of Employees 2,291,170
Goods and Services 3,520,000
Consumption of Fixed Capital 960,000
Interest 200,000
Social Benefits 840,300
Other Expenditure 600,000
Total Expenditure 8,411,470

| Net Operating Result – Surplus | 37,008,050 |

Notes:

  1. Decentralized Transfers:
    • Government of Ghana Salaries: GH¢12,000,000
    • District Development Facility: GH¢15,000,600
    • Common Fund: GH¢2,930,000
    • Stool Land Revenue: GH¢600,000
    • Total: GH¢30,530,600
  2. Internally Generated Funds (IGF):
    • Basic Rates: GH¢370,900
    • Rent from Land and Building: GH¢6,120,800
    • Court Fees: GH¢240,000
    • Royalties: GH¢430,000
    • Market Tolls: GH¢870,000
    • Market Store Rent: GH¢300,750
    • Permit Fees: GH¢990,000
    • Fines and Penalties: GH¢330,000
    • Hostel License: GH¢630,920
    • Business Income: GH¢2,300,600
    • Chop Bar License: GH¢300,400
    • Dividend Received: GH¢93,250
    • Herbalist License: GH¢530,370
    • Property Rate: GH¢820,900
    • Sanitation Fees: GH¢370,000
    • Lorry Park Fees: GH¢720,400
    • Total: GH¢14,888,920
  3. Compensation of Employees:
    • Established Posts: GH¢1,320,700 (including GH¢180,000 outstanding)
    • Non-Established Posts: GH¢580,000
    • Allowances: GH¢390,470
    • Total: GH¢2,291,170
  4. Goods and Services:
    • Inventory and Consumables: GH¢630,000 (GH¢800,000 – GH¢170,000)
    • General Cleaning: GH¢350,000
    • Consultancies Cost: GH¢470,000
    • Training and Workshop Cost: GH¢275,000
    • Transport and Travelling Cost: GH¢620,000
    • Special Services: GH¢820,000
    • Utilities: GH¢630,000
    • Total: GH¢3,520,000

b) Statement of Cash Flow:

ELMINA DISTRICT ASSEMBLY
STATEMENT OF CASH FLOW FOR THE YEAR ENDED DECEMBER 31, 2018

Description Amount (GH¢’000) Amount (GH¢’000)
Cash Flow from Operating Activities
Inflows
Decentralised transfer 30,530,600
Internally generated fund 14,888,920
Total Inflows 45,419,520
Outflows
Compensation of employees 2,111,170
Goods and services 3,690,000
Interest 200,000
Social Benefits 840,300
Other expenditure 600,000
Total Outflows 7,441,470
Net cash flow from operating activities 37,978,050
Net Cash Flow from Investing Activities
Equity investment acquired (420,000)
Infrastructure, plant and equipment (980,000)
Work-in-progress (490,000)
Advanced to staff (660,000)
Sale of equity 990,320
Recoveries 194,000
Net Cash Flow from Investing Activities (1,365,680)
Cash Flow from Financing Activities
Development bonds issued 1,300,000
Loans received 2,330,000
Loan repayment (143,000)
Net Cash Flow from Financing Activities 3,487,000
Net increase in Cash and Cash equivalent 40,099,370
Cash and cash equivalent (1/1/2018) 12,300,240
Cash and cash equivalent (31/12/2018) 52,399,610

c) Basic Disclosures in Consolidated Financial Statements:

The following disclosures shall be made in consolidated financial statements:

  1. A list of significant controlled entities: This includes a summary of entities over which control is exercised.
  2. The fact that a controlled entity is not consolidated: As required by IPSAS 6, reasons for not consolidating a controlled entity should be disclosed.
  3. Summarized financial information of controlled entities not consolidated: This includes details such as total assets, liabilities, revenues, and surplus or deficit for unconsolidated entities.
  4. The name and explanation for control: Any controlled entity where the controlling entity holds 50% or less ownership interest should be disclosed with reasons for control.
  5. Significant restrictions on the ability of controlled entities: Any limitations on transferring funds to the controlling entity in the form of cash dividends or similar distributions should be disclosed.

The Trial Balance was extracted from the books of Bokom Municipal Assembly (BMA) as at 31st December 2015.

Debit GH¢’000 Credit GH¢’000
Property rate 450 Sundry payables 60
Basic rates 200 Short term loans 120
Special rates 50 Deposits 100
Lorry park fees 40 Accumulated Fund 43
Marriage and divorce registration 10
Building permits 110
Penalties 80
Market toll 620
Share of District Assembly Common Fund 980
District Development Facility 350
Compensation for employees 1,000
Herbalist licenses 20
Hawkers licenses 15
Other licenses 12
Royalties 50
Share of stool land revenue 150
Market Store rent 70
Other rentals 40
Interest on investment 10
Gains from business 30
Established post 1,080
Non-established post 700
Goods and services 950
Interest expense 20
Social benefits 180
Other expenditure 260
Bank and Cash 40
Advances and loans 80
Investment 100
Property, Plant, and equipment 1,200
4,610 4,610

Additional Information:

  1. Revenues are classified as follows: Rate, Land Revenue, Fees and Fines, Licenses, Rent income, investment income, and Grants.
  2. The expenditure classification should comply with the harmonized Chart of Accounts.
  3. Consumption of fixed capital for the year is computed as GH¢260,000.

Required:

a) Prepare:

i)  A Statement of Financial Performance for the year ended 31st December 2015.

ii) A Statement of Financial Position as at 31st December 2015. (Please show all workings clearly). (16 marks)

i) Statement of Financial Performance for the year ended 31st December 2015:

Revenues GH¢’000
Rates (Property, Basic, Special) 700
Land Revenue (Royalties, Stool Land) 200
Fees and Fines (Lorry park fees, Marriage registration, Building permits, Penalties, Market toll) 860
Licenses (Herbalist, Hawkers, Other licenses) 47
Rent Income (Market Store, Other rentals) 110
Investment Income (Interest, Gains from business) 40
Grants (DACF, DDF, Compensation) 2,330
Total Revenue 4,287
Expenditures GH¢’000
Compensation (Established and Non-Established Posts) 1,780
Goods and Services 950
Consumption of Fixed Capital 260
Interest Expense 20
Social Benefits 180
Other Expenditure 260
Total Expenditure 3,450

Surplus: GH¢837,000

ii) Statement of Financial Position as at 31st December 2015:

Assets GH¢’000
Property, Plant, and Equipment (1,200 – 260) 940
Investment 100
Advances and Loans 80
Bank and Cash 40
Total Assets 1,160
Liabilities and Fund GH¢’000
Sundry Payables 60
Short Term Loans 120
Deposits 100
Accumulated Fund (837 + 43) 880
Total Liabilities and Fund 1,160

Workings:

  1. Rates:
    • Basic Rate: GH¢200,000
    • Property Rate: GH¢450,000
    • Special Rate: GH¢50,000
  2. Land Revenue:
    • Royalties: GH¢50,000
    • Share of Stool Land Revenue: GH¢150,000
  3. Fees and Fines:
    • Lorry Park Fees: GH¢40,000
    • Marriage and Divorce Registration: GH¢10,000
    • Building Permits: GH¢110,000
    • Penalties: GH¢80,000
    • Market Toll: GH¢620,000
  4. Licenses:
    • Herbalist Licenses: GH¢20,000
    • Hawkers Licenses: GH¢15,000
    • Other Licenses: GH¢12,000
  5. Rent Income:
    • Market Store Rent: GH¢70,000
    • Other Rentals: GH¢40,000
  6. Investment Income:
    • Interest on Investment: GH¢10,000
    • Gains from Business: GH¢30,000
  7. Grants:
    • Share of District Assembly Common Fund: GH¢980,000
    • District Development Facility: GH¢350,000
    • Compensation for Employees: GH¢1,000,000

a) Below are items of transactions obtained from the financial records of Ganigani Municipal Assembly for the year ended 31 December 2022.

Transaction Items GH¢’000
Share of District Assembly Common Fund received 68,000
Share of District Assembly Common Fund in arrears 120,000
District Development Facility 60,000
Clean Ghana grant (i) 40,000
Hawkers licenses 5,000
Dog licenses 2,000
Hotel and Restaurant licenses 43,000
Akpeteshie Distillers or sellers’ licenses 9,000
Non-established post salaries (Paid from Consolidated Fund) 87,000
Casual labour 77,000
Pensions contribution 8,000
Assembly members sitting allowances 7,000
Salary related allowances (ii) 20,000
Training, Seminar and Conferences (iii) 45,000
Travel and transport 12,000
Utility expenses (iv) 1,000
Consumables 200
Interest expense (v) 500
Consumption of fixed asset (Accumulated) 44,000
Consumption of fixed asset (charged for the year) 4,800
Purchase of motor vehicle (vi) 30,000
Premises (old premises revalued by experts) 167,000
Cash proceeds from auction of old furniture 300
Recoveries from loan and advances 1,200
Loans and advances granted during the year 5,000
Issue of Municipal Bonds 100,000
Redemption of Municipal Bonds 28,000
Bank loan borrowed during the year 12,000
Loan repayment 3,400
Investment income received 100
Property rates 65,000
Basic rate 21,000
Market tolls and fees 12,400
Fees and miscellaneous charges 11,400
Cash and cash equivalent at 31 December 2022 (Debit) 70,000
Accumulated Fund Balance (Debit) 123,500
Donation of Cement from Concerned Citizens 3,500

Additional Information:

i) Clean Ghana grant of GH¢40,000 has a component of 40% in kind. ii) The Assembly paid 40% of the GH¢20,000 salary related allowances. iii) 60% of the GH¢45,000 representing Training, Seminar and Conferences expenses was funded by donors. iv) 25% of the GH¢1,000 representing utility expenses was in arrears. v) 90% of the GH¢500 representing interest expense has been paid. vi) 80% of the GH¢30,000 representing Motor Vehicle has been paid.

Required:

a) Prepare a Cash Flow Statement for the year ended 31 December, 2022 for Ganigani Municipal Assembly in compliance with the International Public Sector Accounting Standards 2: Cash Flow Statement and the current Chart of Accounts of Government of Ghana. (16 marks)

b) Explain FOUR (4) benefits of Cash Flow Information to the users of the financial statements of Ganigani Municipal Assembly. (4 marks)

a) Ganigani Municipal Assembly

Cash Flow Statement for the year ended 31st December 2022

Cash Flow From Operating Activities GH¢’000 GH¢’000
Receipts:
Decentralised Transfer 152,000
Internally Generated Fund 168,900
320,900
Payments
Compensation for employees 93,000
Goods and Services 37,950
Interest 450
131,400
Net Cash Flow from Operating Activities 189,500
Cash Flow from Investing Activities
Purchase of Motor vehicle (24,000)
Auction proceeds 300
Recoveries of loan and advances 1,200
Loan and advances granted (5,000)
Net Cash Flow from Investing Activities (27,500)
Cash Flow from Financing Activities
Issue of Municipal Bonds 100,000
Bank loan 12,000
Redemption of Municipal Bonds (28,000)
Loan repayment (3,400)
Net Cash Flow from Financing Activities 80,600
Net increase in cash and cash equivalent 242,600
Cash and Cash equivalent as Dec 31, 2021 (172,600)
Cash and Cash equivalent as Dec 31, 2022 70,000

Notes:

  1. Decentralised Transfer GH¢’000
    • District Assembly Common Fund received: 68,000
    • District Development Facility: 60,000
    • Clean Ghana Grant (60% in cash): 24,000
    • Total: 152,000
  2. Internally Generated Fund
    • Hawkers licenses: 5,000
    • Dog licenses: 2,000
    • Hotel and Restaurant: 43,000
    • Akpeteshi distillers and sellers: 9,000
    • Investment income: 100
    • Property rate: 65,000
    • Basic rate: 21,000
    • Market tolls and fees: 12,400
    • Fees and charges: 11,400
    • Total: 168,900
  3. Compensation for employees
    • Casual labour: 77,000
    • Pension contribution: 8,000
    • Salary related allowances: 8,000
    • Total: 93,000
  4. Goods and Services
    • Assembly members allowances: 7,000
    • Training, seminar and conferences: 18,000
    • Travel and transport: 12,000
    • Utility expenses: 750
    • Consumable: 200
    • Total: 37,950

(Marks are evenly spread using ticks = 16 marks)

b)

Cash Flow Information about a reporting entity is beneficial to the users in the following ways:

  • Information about the cash flows of an entity is useful in assisting users to predict the future cash requirements of the entity, its ability to generate cash flows in the future, and its ability to fund changes in the scope and nature of its activities.
  • A cash flow statement also provides a means by which an entity can discharge its accountability for cash inflows and cash outflows during the reporting period.
  • A cash flow statement, when used in conjunction with other financial statements, provides information that enables users to evaluate the changes in net assets/equity of an entity, its financial structure (including its liquidity and solvency), and its ability to affect the amounts and timing of cash flows in order to adapt to changing circumstances and opportunities.
  • It also enhances the comparability of the reporting of operating performance by different entities because it eliminates the effects of using different accounting treatments for the same transactions and other events.
  • Historical cash flow information is often used as an indicator of the amount, timing, and certainty of future cash flows. It is also useful in checking the accuracy of past assessments of future cash flows.

(Any 4 points @ 1 mark each = 4 marks)

Total: 20 marks

a) Below are extracts from the books of a Local Government Authority for the period ended 31 December 2015.

GH¢
Rates 27,115.16
Non-Governmental Agencies 1,000.00
Grants – District Development Facility 888,828.37
Lands and Royalties 113,563.50
Rents of Lands, Buildings 14,855.20
Licences 55,394.22
Fees 139,784.70
Fines, Penalties and Forfeits 14,231.00
Miscellaneous and Unidentified Revenue 27,345.50
Established Posts
Non-Established Posts 41,503.62
Other Allowances 40,231.05
Casual labour 7,576.45
Materials /Office Supplies 34,628.40
Utilities 5,286.20
General Cleaning 358.50
Rentals 6,260.07
Transport 90,724.05
Repairs and Maintenance 10,568.40
Training, Seminars, Conferences 46,013.70
Consulting Services 1,500.00
Special Services 37,904.00
Other Charges / Fees 1,735.40
Grants – DACF 459,992.60
Constituency’s Share of the Common Fund 39,000.00
GOG – Grant 206,845.97
Donors 595,086.20
Other expenses 11,163.44

Below The Line Accounts

GH¢
Cash and Bank 200,740.71
Receivables 29,100.97
Equity Investment
Infrastructure, Plants and Equipment 322,929.71
Work-in-progress 125,064.79
Accounts Payables 5,000.00
Deposits and Other Trust Monies 25,000.00
Accumulated Fund 1,002,096.58

Required: Prepare a Revenue and Expenditure Statement for the year ended 31 December 2015 and a Statement of Financial Position as at that date. (Show workings) (20 marks)

Revenue and Expenditure Statement for the Period Ended 31 December 2015

Revenue Note GH¢
Rates 27,115.16
Donors, Grants and Relief
Non-Governmental Agencies 1,000.00
Grants – Districts 888,828.37
Interest
Lands and Royalties 113,563.50
Rents of land, buildings 14,855.20
Licenses 55,394.22
Fees 139,784.70
Fines, Penalties and Forfeits 14,231.00
Miscellaneous unidentifiable revenue 27,345.50
Total Revenue 1,282,117.65
Expenditure
Compensation of Employees (1) 89,311.12
Goods and services (2) 234,978.72
Consumption of fixed capital
Interest
Grants*** (3) 1,300,924.97
Other expenses 11,163.44
Total Expenditure 1,636,378.25
Surplus / deficit for the period (354,260.40)
Accumulated surplus as at 31/12/13 1,002,096.58
Accumulated surplus as at 31/1/14 647,836.18

STATEMENT OF FINANCIAL POSITION AS AT 31ST DECEMBER, 2015

Assets GH¢ GH¢
Current Assets
Cash Balances 200,740.71
Receivables 29,100.97
Prepayments
Total Current Assets 229,841.68

| Non-Current Assets | | | | Equity Investment | | – | | Infrastructure, Plant & Equipment | | 322,929.71 | | Work-in-progress | | 125,064.79 | | Total Non-Current Assets | | 447,994.50 | | Total Assets | | 677,836.18 |


LIABILITIES GH¢ GH¢
Current Liabilities
Accounts Payables 5,000.00
Deposits & Other Trust Monies 25,000.00
Short-term Borrowings
Total Current Liabilities 30,000.00

| Non-Current Liabilities | | – | | Total Liabilities | | 30,000.00 |

| NET ASSETS | | 647,836.18 |


Workings

  1. Compensation of Employees
Compensation of Employees GH¢
Non-Established Post 41,503.62
Other Allowances 40,231.05
National Insurance Contribution 7,576.45
Total 89,311.12
  1. Goods & Services
Goods & Services GH¢
Materials / office supplies 34,628.40
Utilities 5,286.20
General Cleaning 358.50
Rentals 6,260.07
Transport 90,724.05
Repairs & Maintenance 10,568.40
Training, Seminars, Conference 46,013.70
Consulting Services 1,500.00
Special Services 37,907.00
Other Charges/Fees 1,735.40
Total 234,978.72
  1. Grants**
Grants**** GH¢
Grant – DACF 459,992.60
MP’s Common Fund 39,000.00
GOG Grant 206,845.97
Donors 595,086.20
Total 1,300,924.97

*** An alternative treatment is to treat grant*** as revenue to the Assembly since the question was not clear on whether the grant is expenditure or revenue.

(20 marks evenly spread using ticks)

The following Trial Balance is the financial details of Nsuta-Appiah Krom Municipal Assembly for the year ended 31 December 2021.

Additional Information:

  1. It is the policy of the Assembly to adopt Accrual Basis in preparing its Financial Statements in compliance with Public Financial Management Act, 2016 (Act 921), Public Financial Management Regulation 2019 L.I 2378 and the International Public Sector Accounting Standards (IPSAS) and Local Governance Act 2016, (Act 936).
  2. Office consumables in respect of stationery and other items bought for GH¢1,800,000 remained unused during the year. The current replacement cost of the inventories is GH¢1,550,000. Meanwhile, the net realizable value of the inventories is estimated at GH¢1,400,000. No market exists for unused office consumables and other items.
  3. Property Rates received in respect of the 2022 financial year amounted to GH¢2,050,000.
  4. Salaries outstanding during the year amounted to GH¢750,000, and other expenses amounting to GH¢1,105,000 paid in respect of the 2022 financial year.
  5. Consumption of fixed assets is charged on a straight-line basis for the year as follows:
    • Motor vehicles: 10 years
    • Furniture, Fixtures & Fittings: 5 years
    • Building and Structures: 50 years
  6. Included in the Work in Progress is an amount of GH¢2,000,000 relating to a Building that was completed, commissioned, and put to use on 5 July 2021, after an additional amount of GH¢800,000 was spent to complete the pavement aspect of the building. This expenditure has not yet been paid.
  7. Interest on Loans to staff is at the rate of 15% per annum and interest on long-term Loans is at the rate of 10% per annum.

Required:

a) Prepare a Statement of Financial Performance for Nsuta-Appiah Krom Municipal Assembly for the year ended 31 December 2021.
(9 marks)

b) Prepare a Statement of Financial Position for Nsuta-Appiah Krom Municipal Assembly as at 31 December 2021.
(9 marks)

c) State TWO (2) Accounting Policies adopted and applied in preparing the financial statements.
(2 marks)

a) Nsuta-Appiah Krom Municipal Assembly
Statement of Financial Performance for the Year Ended 31/12/2021

b) Nsuta-Appiah Krom Municipal Assembly
Statement of Financial Position as at 31/12/2021


c) Accounting Policies

  1. General Statement: The Assembly prepares its financial statements in compliance with the Public Financial Management Act, 2016 (Act 921) and its Regulation 2019, L.I 2378, International Public Sector Accounting Standards (IPSAS), and the Local Government Act, 2016 (Act 936).
  2. Basis of Accounting: The Assembly uses Accrual Accounting Basis in the preparation of its Financial Statements.