IPSAS 33, gives a transition relief (exemption) of up to three years within which to develop models for transiting to IPSAS accrual. However, the government of Nigeria adopted accrual IPSAS on revenue from exchange transactions effective January 1, 2016. Oranta State Government mandated the Accountant-General of the State to implement the IPSAS accrual in the preparation of their financial statements with effect from January 2018 which was complied with accordingly. For the smooth implementation of IPSAS accrual, the State Executive Council approved the following: (i) Asset valuation committee to be chaired by the Deputy Governor with the Commissioner of Finance, Commissioner of Budget and Planning, Chairman State Internal Revenue Service, Accountant-General of the State and Head of Service as members while a Director in the Office of the Secretary to the State Government was appointed as the Secretary. (ii) The Committee was mandated to value all the State assets and liabilities on or before the implementation of IPSAS accrual. (iii) The Committee was allowed to engage the services of competent valuers for the job. (iv) The valuation of the assets and liabilities should be on continuous basis and any value agreed and approved by the State Executive Council should be brought into the books in the year of valuation. (v) All assets and liabilities incurred after implementation of IPSAS accrual should be recognised in the year they occurred. 89 The consolidated trial balance for the year ended December 31, 2017 based on IPSAS cash is as follows: Dr Cr N'million N'million Liquid assets: CRF Bank balance 55,000.00 Investments: Treasury bills 100,000.00 Advances 95,000.00 Revolving loans granted 250,000.00 Fund balance: Consolidated Revenue Fund (CRF) 75,000.00 Loans: External loans 150,000.00 State bonds 275,000.00 Total 500,000.00 500,000.00 Extracted consolidated cashbook for the year 2018: Dr Cr N’million N’million Receipts: Share of federation account allocation 324,000 Value added tax allocation 234,000 Tax revenue - Personal income tax 185,000 Non- Tax Revenue: - Fees 35,000 - Fines 36,000 - Penalty 33,000 Revolving loan repayment including interest of N2billion 52,000 Interest on treasury bills 10,000 Aids and grants 51,800 960,800 Payments: Salaries and wages 750,000 Motor vehicles 25,000 Building 23,000 Plant & machinery 15,000 Equipment 7,000 Loan repayment- Bonds and interest 13,000 - Foreign and Interest 32,000 Transport and Travelling 1,900 Hotel accommodation 2,600 Office consumables 750 90 Rent expenses 1,200 General repairs and maintenance 800 Utilities 3050 Consultancy 6,700 Other overheads 2,100 Pension and gratuity 35,000 Finance charge- Insurance 350 Revolving loan 500 Miscellaneous expenses 450 920,400 The following information is relevant: (i) The employees’ salaries and wages bill for the month of December 2018 amounting to N6.5billion was outstanding at the end of the year. (ii) The following information was extracted from the unit in charge of accounting for property, plant and equipment (PPE): 100 sets of HP computers were received from Koko Computers Limited to assist the State government to eradicate ghost workers from the payroll- the HP series P1120, 2016 model. Based on this information, a call was made to three of their computer suppliers to find out the current price of the HP P1120. Two of the suppliers quoted N450,000 each, while one quoted N500,500 each. Based on this information, the fair value of the computers, were taken as N500,000 each. (iii) The government during the year received an asset valuation report from the Asset Valuation Committee that was set up to carry out the valuation of the old assets and liabilities of the State. (iv) The following values were recommended and approved by the State Executive Council respectively: Details Committee valuation State Executive Council approval N’million N’million Vacant land 116,000 95,000 Land and building (Cost of land N30billion) 150,000 135,000 Plant and machinery 75,000 75,000 Motor vehicle 20,000 15,000 Equipment 55,000 50,000 Furniture and fittings 85,000 80,000 Total 501,000 450,000 91 (v) Pension and gratuity of N15 billion was outstanding at the end of the year (vi) Some of the accounting policies adopted by the government for depreciation include the following rates; % p
Motor vehicle 20 Building 2 Furniture 10 Equipment 15 Plant & machinery 15 Investment property 5 (vii) During the year, one of the contractors took the State to court for breach of contract. The case was still in court as at the end of the year and from all indications, judgment will eventually be in his favour. The legal adviser estimated the judgment debt to be N50million. (viii) Value of office consumables based on inventory sheet as at December 31, 2018 was N550million. (ix) The following expenses were incurred but not settled as at end of the year. N’million Consultancy 150 Utility 28 Repairs & maintenance 20 (x) An extract from the foreign loan amortisation schedule indicates that a total sum of N32billion comprising principal and interest of N2billion was due and paid during the year. Also domestic loan of N13billion comprising principal and interest of N1billion was paid during the year. The interest payable on domestic and external loans at the end of the year amounted to N3billion and N5 billion respectively. (xi) The investment of 10% treasury bills for 360 days was due to mature on January 1, 2018 and reinvested immediately for another term. (xii) The revolving loan attracts interest of 4% per annum and it is paid along with the principal.
Prepare in vertical form: i. Statement of financial performance for the year December 31, 2018. (17 Marks) ii. Statement of financial position for the year December 31, 2018. (17 Marks)
Revise this question
IPSAS 33: first-time adoption of accrual basis IPSAS › RevenueSuggested answer
a. Revenue from exchange transactions
i. Aid and grants receivable as at December 31, 2015 If on or before December 31, 2015, a public sector entity is entitled to an un-conditional aid/grants and funds have not been received as at January 1, 2016, the amount due to that entity and not yet received shall be recognised as receivable in the opening statement of financial position.
ii. Debt forgiveness approved on or after January 1, 2016 Debt forgiven on or after January 1, 2016 shall be immediately recognised as revenue in the books of the recipient when both the grantor and the recipient have approved a debt forgiveness agreement/MoU and no conditions are attached. Where there are conditions attached to the debt forgiven to the extent that if not met the amount will be repayable, and there is a possibility of failure to meet such condition(s), the amount forgiven (or portion with conditions) will remain a liability until such conditions are met.
iii. Personal income on or after January 1, 2016 The personal income tax is recognised at the point when the taxpayer has earned assessable income. In Nigeria, the recognition of personal income tax is to be considered in two-folds:
• At the point of collection in the books of Relevant Tax Authority (RTA), personal income tax is recognised when taxpayer or employer has submitted returns.
• In the books of the government (Federal/State treasury), personal income tax is recognised upon remittance of tax by RTA to Consolidated Revenue Fund (CRF) of the respective treasury. 97
b. Oranta State Government Statement of financial performance for the year ended December 31 2018 Working notes N’ million N’ million Revenue: Share of federation account allocation 324,000.00 Value added tax allocation 234,000.00 Tax revenue - Personal income tax 185,000.00 Non- tax revenue
- Fees. 35,000.00 - Fines. 36,000.00 - Penalty 33,000.00 Revolving loan interest iii. 2,020.00 Interest on treasury bills 10,000.00 Aids and grants 51,800.00 Donation of computers 50.00 Total revenue 910,870.00 Expenditures: Salaries & wages ii. 756,500.00 Bonds interest iii. 4,000.00 External loan interest iii. 7,000.00 Transport and travelling 1,900.00 Hotel accommodation 2,600.00 Office consumables ii. 200.00 Rent expenses 1,200.00 General repairs and maintenance ii. 820.00 Utilities ii. 3,078.00 Consultancy ii. 6,850.00 Other overheads 2,100.00 Pension and gratuity ii. 50,000.00 Finance charge- Insurance 350.00 Miscellaneous expenses 450.00 Contingency - Judgement debt 50.00 Depreciation: - Motor vehicles i. 5,000.00 - Building i. 460.00 - Plant and machinery i. 2,250.00 - Equipment i. 1,057.50 845,865.50 Surplus for the year 65,004.50 98 Working Notes
i. Depreciation on new PPE Land & building Equipment Motor vehicles Plant and machinery Rate 2% 15% 20% 10% 15% N’ million N’ million N’ million N’ million N’ million Depreciation to be charged N460.00 1,057.50 5,000.00 00 2,250.00
ii. Analysis of expenses Salaries and wages Pension and gratuity Consultancy Utility Repairs and maintenance Office consumables N’ million N’ million N’ million N’ million N’ million N’ million Bank 750,000 35,000 6,700 3,050 800 750 Value of consumable b/f -- -- -- -- -- -- Accrued c/f 6,500 15,000 150 28 20 -- Prepaid c/f -- -- -- -- -- -550 Amount charged 756,500 50,000 6,850 3,078 820 200
iii. Interest credited and charged on revolving/ domestic and external loans Revolving loan Bonds External loan N’ million N’ million N’ million Bank 2,000 (1,000) (2,000) Interest receivable/payable 20 (3,000) (5,000) Credited/(charged) 2,020 (4,000) (7,000) 99 Furniture and fittings Oranta State Government Statement of financial position as at December 31 2018 Non-current assets: Working notes Cost/ valuation Accumulated depreciation Carrying amount N’ million N’ million N’ million Land & buildings iv. 253,000.00 460.00 252,540.00 Motor vehicles iv. 40,000.00 5,000.00 35,000.00 Furniture and fittings iv. 80,000.00 00 80,000.00 Equipment iv. 57,050.00 1,057.50 55,992.50 Plant & machinery iv. 90,000.00 2,250.00 87,750.00 Total non- current assets 520,050.00 8,767.50 511,282.50 Current assets: Office consumables ii. 550.00 Cash and cash equivalents v. 95,400.00 Investment: Treasury Bills 100,000.00 Advances 95,000.00 Revolving loan vi. 200,500.00 Revolving loan interest (4% of 500) iii. 20.00 Total current assets 491,470.00 Total assets 1,002,752.50 Non- current liabilities: Long term borrowing - Bonds vi. 263,000.00 - Foreign vi. 120,000.00 Total non- current liabilities: 383,000.00 Current liabilities Salaries & wages ii. 6,500.00 Consultancy ii. 150.00 Utility ii. 28.00 Repairs & maintenance ii. 20.00 Pensions & gratuity ii. 15,000.00 Contingent liability 50.00 Interest payable - Domestic iii. 3,000.00 - External iii. 5,000.00 Total current liabilities 29,748.00 Total liabilities 412,748.00 Net assets 590,004.50 Equity Reserves vii & viii 525,000.00 Surplus for the year 65,004.50 Total equity 590,004.50 100 Working notes:
iv. Property, plant & equipment. Land building and Equipment vehicles Motor Plant and machinery New property, plant & equipment N’ million N’ million N’ million N’ million N’ million Bank 23,000 7,000 25,000 -- 15,000 Donation of computers -- 50 -- -- -- Valuation of old assets 230,000 50,000 15,000 80,000 75,000 Balance as at December 31 2018 253,000 57,050 40,000 80,000 90,000
v. Calculation of cash and its equivalents as at December 31, 2018 N’ million Balance b/f 55,000 Total receipts 960,800 1,015,800 Total payments -920,400 Balance c/f 95,400
vi. Revolving/domestic and external loans Revolving loan receivable Bonds payable External loan payable N’ million N’ million N’ million Balance b/f 250,000 275,000 150,000 Repayment -50,000 -12,000 -30,000 Additions 500 - - Balance c/f 200,500 263,000 120,000
vii. Revaluation surplus Land building and Equipment vehicles. Motor Furniture and Fittings Plant and machinery Old property plant & equipment N’ million N’ million N’ million N’ million N’ million Valuation 135,000 50,000 15,000 80,000 75,000 Vacant Land Valuation 95,000 - - - - Revaluation surplus 230,000 50,000 15,000 80,000 75,000 101 Furniture and Fittings viii Reserves Revaluation N’ million Land and building 230,000.00 Equipment 50,000.00 Motor vehicles. 15,000.00 Furniture and fittings 80,000.00 Plant and machinery 75,000.00 Sub-total 450,000.00 CRF balance 75,000.00 Total 525,000.00
Marking Guide Marks Marks a. Revenue from exchange transactions: Aid and grants receivable as at December 31, 2015 2 Debt forgiveness approved on or after January 1, 2016 2 Personal income on or after January 1 2016 2 6 b. Statement of financial performance: Correct title ½ Calculation of total revenue 3 Calculation of total expenditure 5 Calculation of net surplus for the year 1½ 10
Workings: i. Property, plant and equipment: Calculation of depreciation charges for the year on PPE 2½ ii. Analysis of expenses: Calculation of expenses to be charged during the year 3 iii. Interest on revolving credited/domestic and external loans interests charged Calculation of interest on revolving credited/domestic and external loans interests charged 1½ 7 Sub-total 17 Statement of financial position: Correct title ½ Calculation of total non-current assets 4½ Calculation of total current assets 1¾ Calculation of total assets ¼ Calculation of non- current liabilities ¾ Calculation of total current liabilities 2¼ Calculation of total liabilities ¼ Calculation of total net assets ¼ Calculation of total net assets/equity 1½ 12 102
Workings iv. Property, plant and equipment: Calculation of the cost of PPE at the end of the year 1¼ v. Cash and its equivalents c/f: Calculation of cash & its equivalents 1 vi. Revolving receivable/domestic and external loans payable: Calculation of revolving/domestic and external loans c/f ¾ vii. Calculation of revaluation surplus 1¼ viii. Calculation of reserves ¾ 5 Sub- Total 17 Total 40
Examiner’s Report The question tests candidates’ knowledge of recognition of revenue on exchange transactions under IPSAS 33 First-Time Adoption of Accrual Basis in part (a) of the question, while part (b) tests candidates’ knowledge on the preparation of statement of financial performance and statement of financial position using vertical format. All the candidates attempted the question and their performance was average. The commonest pitfalls was the inability of the candidates to understand the treatment aids and grant; debt forgiveness; and personal income tax under IPSAS 33. Candidates were unable to incorporate the additional information given in the notes to the question in the preparation of financial statement. Candidates are advised to acquire adequate knowledge of relevant provisions of International Public Sector Accounting Standards (IPSAS) for better performance in the Institute’s future examinations.