Question 2 The following transactions and events affected the consolidated funds of Berjaya Nasional Local Government during 2021. Berjaya Nasional Local Government Trial Balance Council Fund As at 1 January 2021 Items Debit (RM) Credit (RM) Cash 100,000 Assessment Taxes Receivable 400,000 Uncollectible Assessment Taxes Receivable 40,000 Interest and Penalties Receivable on Assessment Tax 25,000 10,000 Uncollectible Interest and Penalties Receivable on Assessment Taxes Voucher Payable 135,000 Deferred Revenues (Permit and Licenses) 20,000 Due to Federal Government 30,000 Account Payable (2015) 45,000 Fund Balances 245,000 Total 525,000 525,000 The following information summaries the transaction of Berjaya Nasional Local Government during 2021: 1. Recording the budget At the beginning of the fiscal year, the budget approved for 2016 are as follows: a. Estimated Revenue RM6,200,000 b. Estimated Expenditure RM5,200,000 c. Estimated Transfer to Debt Service Fund RM650,000 d. Estimated Equity Transfer Fund RM150,000 2. The Berjaya Nasional Local Government liabilities that are Voucher Payable and Due to Federal Government amounted to RM165,000, while the Cash amounted to RM100,000 (as shown in the above Trial Balance). Although some collections of Taxes Receivable are expected early in the year, payrolls and other liabilities are incurred and must be paid before substantial amount of cash can be collected accordingly. Therefore, it is desirable for Berjaya Nasional Local Government to arrange a short term loan amounting to RM200,000. 3. Cheques were drawn to pay the Vouchers Payable and the amount Due to Federal Government as at the end of 2021. 4. Account Payable of 2020 In the Trial Balances as at 1st January 2021, the items of Account Payable (2020) indicates that purchase orders or contracts issued in 2020 were charge to 2020 allocation and will be paid in 2021. 5. Commitment Entry Purchase order for materials and supplies are issued with a total of RM800,000. 6. At the end of 2020, Berjaya Nasional Local Government Deferred Revenues (Permit and Licenses) amounted to RM20,000 is reflected in the beginning Trial Balance as revenue. 7. Recording Assessment Taxes Levy Budget revenue from assessment taxes was RM3,200,000. In order to generate tax collection, 2% of these taxes are estimated to be uncollectable due to the tax collection policy and local economic condition. In order to generate revenues of RM3,200,000, the gross levy must be RM3,265,306. 8. Collection of Assessment Taxes Receivable Berjaya Nasional Local Government received late payment of Assessment Taxes by tax payers amounting to RM330,000 and the Interest and Penalties on this Assessment Taxes of RM20,000 had been recorded as receivable at the end of 2020. Another additional Interest and Penalties on this Assessment Taxes of RM5,000 is assumed to be paid on the 1st January of 2021. 9. Collection of current Taxes Collections during 2021 of Assessment Taxes for 2021 are RM 2,700,000. 10. Revenue recognized on Cash Basis Revenue for Permit and Licenses is recognized on cash basis. Collections during the year of 2021 amounted to RM2,800,000. 11. Repayment of Notes Payable Berjaya Nasional Local Government will have to pay the local bank for the money borrowed (as stated in no. 2 information) with interest. 12. Recognition of expenditures for Commitment items As stated in information no. 5 earlier, the invoices for materials and supplies amounted to RM800,000 were received. After the materials and supplies have been inspected, they were approved for payment and voucher was then issued. 13. Payrolls and Payroll Taxes The gross payment of payroll for employees amounted to RM3,345,000. This includes the deduction of insurance for RM78,000 and Employee Provident Fund (EPF) of RM430,000. The gross pay is chargeable to the appropriation of the individual department of the employees. 14. Inter Fund Transfer The SADA Water Utility Department (government owned) provides water utilities with fire hydrants and water service for the fire protection at a flat annual charge. As such, a government owned water utility is expected to support the cost of its operation by charging the users under Water Utility Fund. The amount charged by SADA Water Utility Department to the Berjaya Nasional Local Government Water Utility Fund was RM80,000. 15. Write-off of Uncollectible Taxes Receivables The age of receivables periodically were reviewed to determine the adequacy of allowance account and to authorise the write-off of items judged to be uncollectable. The accountant of Berjaya Nasional Local Government has received the approval to write-off Uncollectable Assessment Taxes amounting to RM30,000 and the related Interest and Penalties of RM3,000. 16. Deferred Revenues of Permit and Licenses A review on the Permit and Licenses Revenue Ledger indicated that approximately RM40,000 would probably will be received more than sixty days beyond the end of the fiscal year. REQUIRED: (a) Prepare the Statement of Financial Performance (Consolidated Council Fund) for the year ended 31st December 2021 for Berjaya Nasional Local Government. Question 2 The following transactions and events affected the consolidated funds of Berjaya Nasional Local Government during 2021. Berjaya Nasional Local Government Trial Balance Council Fund As at 1 January 2021 Items Debit (RM) Credit (RM) Cash 100,000 Assessment Taxes Receivable 400,000 Uncollectible Assessment Taxes Receivable 40,000 Interest and Penalties Receivable on Assessment Tax 25,000 10,000 Uncollectible Interest and Penalties Receivable on Assessment Taxes Voucher Payable 135,000 Deferred Revenues (Permit and Licenses) 20,000 Due to Federal Government 30,000 Account Payable (2015) 45,000 Fund Balances 245,000 Total 525,000 525,000 The following information summaries the transaction of Berjaya Nasional Local Government during 2021: 1. Recording the budget At the beginning of the fiscal year, the budget approved for 2016 are as follows: a. Estimated Revenue RM6,200,000 b. Estimated Expenditure RM5,200,000 c. Estimated Transfer to Debt Service Fund RM650,000 d. Estimated Equity Transfer Fund RM150,000 2. The Berjaya Nasional Local Government liabilities that are Voucher Payable and Due to Federal Government amounted to RM165,000, while the Cash amounted to RM100,000 (as shown in the above Trial Balance). Although some collections of Taxes Receivable are expected early in the year, payrolls and other liabilities are incurred and must be paid before substantial amount of cash can be collected accordingly. Therefore, it is desirable for Berjaya Nasional Local Government to arrange a short term loan amounting to RM200,000. 3. Cheques were drawn to pay the Vouchers Payable and the amount Due to Federal Government as at the end of 2021. 4. Account Payable of 2020 In the Trial Balances as at 1st January 2021, the items of Account Payable (2020) indicates that purchase orders or contracts issued in 2020 were charge to 2020 allocation and will be paid in 2021. 5. Commitment Entry Purchase order for materials and supplies are issued with a total of RM800,000. 6. At the end of 2020, Berjaya Nasional Local Government Deferred Revenues (Permit and Licenses) amounted to RM20,000 is reflected in the beginning Trial Balance as revenue. 7. Recording Assessment Taxes Levy Budget revenue from assessment taxes was RM3,200,000. In order to generate tax collection, 2% of these taxes are estimated to be uncollectable due to the tax collection policy and local economic condition. In order to generate revenues of RM3,200,000, the gross levy must be RM3,265,306. 8. Collection of Assessment Taxes Receivable Berjaya Nasional Local Government received late payment of Assessment Taxes by tax payers amounting to RM330,000 and the Interest and Penalties on this Assessment Taxes of RM20,000 had been recorded as receivable at the end of 2020. Another additional Interest and Penalties on this Assessment Taxes of RM5,000 is assumed to be paid on the 1st January of 2021. 9. Collection of current Taxes Collections during 2021 of Assessment Taxes for 2021 are RM 2,700,000. 10. Revenue recognized on Cash Basis Revenue for Permit and Licenses is recognized on cash basis. Collections during the year of 2021 amounted to RM2,800,000. 11. Repayment of Notes Payable Berjaya Nasional Local Government will have to pay the local bank for the money borrowed (as stated in no. 2 information) with interest. 12. Recognition of expenditures for Commitment items As stated in information no. 5 earlier, the invoices for materials and supplies amounted to RM800,000 were received. After the materials and supplies have been inspected, they were approved for payment and voucher was then issued. 13. Payrolls and Payroll Taxes The gross payment of payroll for employees amounted to RM3,345,000. This includes the deduction of insurance for RM78,000 and Employee Provident Fund (EPF) of RM430,000. The gross pay is chargeable to the appropriation of the individual department of the employees. 14. Inter Fund Transfer The SADA Water Utility Department (government owned) provides water utilities with fire hydrants and water service for the fire protection at a flat annual charge. As such, a government owned water utility is expected to support the cost of its operation by charging the users under Water Utility Fund. The amount charged by SADA Water Utility Department to the Berjaya Nasional Local Government Water Utility Fund was RM80,000. 15. Write-off of Uncollectible Taxes Receivables The age of receivables periodically were reviewed to determine the adequacy of allowance account and to authorise the write-off of items judged to be uncollectable. The accountant of Berjaya Nasional Local Government has received the approval to write-off Uncollectable Assessment Taxes amounting to RM30,000 and the related Interest and Penalties of RM3,000. 16. Deferred Revenues of Permit and Licenses A review on the Permit and Licenses Revenue Ledger indicated that approximately RM40,000 would probably will be received more than sixty days beyond the end of the fiscal year. REQUIRED: (a) Prepare the Statement of Financial Performance (Consolidated Council Fund) for the year ended 31st December 2021 for Berjaya Nasional Local Government