(a) Using the list of transactions at question A5.5 prepare a spreadsheet similar to that presented in Table 5.3.
Refer to A5.5,
Apr. 1 Jane Gate commenced her dental practice on 1 April by depositing £60,000 in a business bank account.
Apr. 1 Rent for a surgery was paid, £800, for the month of April.
Apr. 2 Dental equipment was purchased for £35,000, paying in cash.
Apr. 3 Dental supplies were purchased for £5,000, taking 30 days' credit from a supplier.
Apr. 4 Fees of £1,200 were collected in cash from patients and paid into the bank account.
Apr. 15 Dental assistant was paid wages for two weeks, £700.
Apr. 20 Jane Gate withdrew £500 cash for personal use.
Apr. 21 Fees of £2,400 were collected in cash from patients and paid into the bank.
Apr. 29 Dental assistant was paid wages for two weeks, £700.
Apr. 29 Invoices were sent to patients who are allowed 20 days' credit, for work done during April amounting to £1,900.
Apr. 30 Telephone bill for April was paid, £80.
Apr. 30 Dental supplies unused were counted and found to be worth £3,500, measured at cost price.
Table 3.10
Spreadsheet of transactions for P. Mason's legal practice, during the month of September


(b) Show that the spreadsheet totals satisfy the accounting equation?