Using the totals from the columns of the spreadsheet of question B5.1, prepare for the dental practice in the month of April:

(a) a cash flow statement;

(b) a balance sheet; and

(c) a profit and loss account.

Data from question B5.1

(a) Using the list of transactions at question A5.5 prepare a spreadsheet.

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

Data from Question A5.5

Analyse each of the following transactions to show the two aspects of the transaction
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.