The balances below are from the records of Little Joy Junior School on 31 December 2022. Imagine that the…

Question

The balances below are from the records of Little Joy Junior School on 31 December 2022. Imagine that the School Board asked you to prepare the Receipts and Payments account and the Income and Expenditure accounts that they will present to the parents at the AGM.

ScanSolve AI Tutor · Accepted Answer

To prepare the Receipts and Payments Account and the Income and Expenditure Account, we first need to identify and adjust the relevant figures. The "Balance in the Bank account M212 060" on 31 December 2022 is the closing balance. We will calculate the opening bank balance for the Receipts and Payments Account.

Calculate total cash receipts (excluding opening balance) and total cash payments (excluding closing balance).
Total Cash Receipts:
$\text{M}94\,800 \text{ (School fees)} + \text{M}20\,000 \text{ (Donations)} + \text{M}15\,000 \text{ (Sales of uniform)} = \text{M}129\,800$
Total Cash Payments:
$\text{M}7\,300 \text{ (Stationery)} + \text{M}102\,000 \text{ (Equipment)} + \text{M}12\,344 \text{ (Sundry expenses)} + \text{M}50\,000 \text{ (Salaries)} + \text{M}22\,000 \text{ (Rent)} + \text{M}5\,367 \text{ (Electricity)} = \text{M}199\,011$
Calculate the opening bank balance for the Receipts and Payments Account.
Given the closing bank balance of M212 060, we can find the opening balance:
$\text{Opening Balance} = \text{Closing Balance} - \text{Total Receipts} + \text{Total Payments}$ $\text{Opening Balance} = \text{M}212\,060 - \text{M}129\,800 + \text{M}199\,011 = \text{M}281\,271$
Prepare the Receipts and Payments Account for the year ended 31 December 2022.
This account summarizes all cash inflows and outflows during the year.
$\begin{array}{|l|r|l|r|} \hline \textbf{Receipts} & \textbf{Amount (M)} & \textbf{Payments} & \textbf{Amount (M)} \\ \hline \text{To Balance b/d (1 Jan 2022)} & 281\,271 & \text{By Stationery bought} & 7\,300 \\ \text{To School fees received} & 94\,800 & \text{By Equipment purchased} & 102\,000 \\ \text{To Donations received} & 20\,000 & \text{By Sundry expenses} & 12\,344 \\ \text{To Sales of uniform} & 15\,000 & \text{By Instructor salaries} & 50\,000 \\ & & \text{By Building rent} & 22\,000 \\ & & \text{By Electricity expense} & 5\,367 \\ & & \text{By Balance c/d (31 Dec 2022)} & 212\,060 \\ \hline \textbf{Total} & \textbf{411\,071} & \textbf{Total} & \textbf{411\,071} \\ \hline \end{array}$
Calculate adjusted expenditure items for the Income and Expenditure Account.
- Stationery consumed: Stationery bought (M7 300) less closing inventory (M1 100). $\text{M}7\,300 - \text{M}1\,100 = \text{M}6\,200$
- Depreciation on equipment: 10% of the cost of equipment purchased (M102 000). $10\% \times \text{M}102\,000 = \text{M}10\,200$
- Building rent expense: Rent paid (M22 000) plus rent owing (accrued) at year-end (M2 000). $\text{M}22\,000 + \text{M}2\,000 = \text{M}24\,000$
Calculate total income for the Income and Expenditure Account.
Income items are recognized when earned. No adjustments are specified for these.
$\text{M}94\,800 \text{ (School fees)} + \text{M}20\,000 \text{ (Donations)} + \text{M}15\,000 \text{ (Sales of uniform)} = \text{M}129\,800$
Calculate total expenditure for the Income and Expenditure Account.
This includes the adjusted expenditure items and other expenses.
$\text{M}6\,200 \text{ (Stationery)} + \text{M}10\,200 \text{ (Depreciation)} + \text{M}12\,344 \text{ (Sundry expenses)} + \text{M}50\,000 \text{ (Salaries)} + \text{M}24\,000 \text{ (Rent)} + \text{M}5\,367 \text{ (Electricity)} = \text{M}108\,111$
Determine the surplus or deficit for the Income and Expenditure Account.
$\text{Surplus} = \text{Total Income} - \text{Total Expenditure}$ $\text{Surplus} = \text{M}129\,800 - \text{M}108\,111 = \boxed{\text{M}21\,689}$
Prepare the Income and Expenditure Account for the year ended 31 December 2022.
This account shows the financial performance on an accrual basis.
$\begin{array}{|l|r|l|r|} \hline \textbf{Expenditure} & \textbf{Amount (M)} & \textbf{Income} & \textbf{Amount (M)} \\ \hline \text{To Stationery consumed} & 6\,200 & \text{By School fees} & 94\,800 \\ \text{To Depreciation} & 10\,200 & \text{By Donations} & 20\,000 \\ \text{To Sundry expenses} & 12\,344 & \text{By Sales of uniform} & 15\,000 \\ \text{To Instructor salaries} & 50\,000 & & \\ \text{To Building rent} & 24\,000 & & \\ \text{To Electricity expense} & 5\,367 & & \\ \text{To Surplus} & 21\,689 & & \\ \hline \textbf{Total} & \textbf{129\,800} & \textbf{Total} & \textbf{129\,800} \\ \hline \end{array}$

The balances below are from the records of Little Joy Junior School on 31 December 2022. Imagine that the School Board asked you to prepare the Receipts and Payments account and the Income and Expenditure accounts that they will present to the parents at the AGM.

Answer

Step-by-step solution

Calculate total cash receipts (excluding opening balance) and total cash payments (excluding closing balance).

Calculate the opening bank balance for the Receipts and Payments Account.

Prepare the Receipts and Payments Account for the year ended 31 December 2022.

Calculate adjusted expenditure items for the Income and Expenditure Account.

Calculate total income for the Income and Expenditure Account.

Calculate total expenditure for the Income and Expenditure Account.

Determine the surplus or deficit for the Income and Expenditure Account.

Prepare the Income and Expenditure Account for the year ended 31 December 2022.

Still stuck on this one?

More Accounting Questions