trial balance

Nominal ledger closing balances as at 31 march 2013

Capital £223,800

8% loan (repayable in 10years) liability £65,000

Plant and equipment at cost £460,000

Accumulated depreciation on plant and equipment £110,000

Motor vehicles at cost £90,000

Accumulated depreciation on motor vehicles £55,000

Inventory as at 1st April £88,000

Receivables £103,600

Payables £64,000

Bank (debit balance) £64,000

Sales £1,450,000

Purchases £872,000

Heating and lighting £22,000

Rent £95,000

Salaries and wages £66,640

Administration expenses £24,000

Advertising £ ?

Distribution costs £76,000

Suspense account £2,640

Allowance for receivables £13,600

Relevant additional information regarding post trial balance adjustments is below.

1. Closing inventory as at 31 March 2013 had a cost of £95,000. Included in this amount were some items, costing £9,000, that were out of fashion. John decided to mark these items down to £6,000 for a quick sale.

2. On further investigation of the suspense account in the trial balance, John discovered: l Cash expenses of £9,360 had been posted to the suspense account. This was a cash payment for advertising. l A cash receipt of £12,000 had been posted to the suspense account. This represented an amount of income not recorded previously in any nominal ledger account.

3. During 2013, John hired a truck with special lifting equipment to help with deliveries. £36,000 has been paid in advance under the truck hire agreement, which covers two years’ hire and began on 1 January 2013. The £36,000 has been debited in error to the purchases account in the nominal ledger

4. John depreciates non-current assets as follows: l plant and equipment at 10 per cent on a straight-line basis l motor vehicles at 20 per cent on a straight-line basis.

There are no non-current assets that have a residual value. No depreciation for the year ended 2013 has been entered into the accounting records. A full year’s depreciation is charged in the year of acquisition. No depreciation is charged in the year of disposal. In November 2012, John sold a delivery van for £2,000 in cash. The vehicle had originally cost £20,000 and on 1 April 2012 the net book value of the van was £4,800. In January 2013, the cash received from the disposal of the delivery van was used to buy a second-hand car costing £2,000. No entries have been made in the nominal ledger accounts for the disposal of the van or the purchase of the company car.

5. A full year’s loan interest is to be accrued.

6. No heat and lighting costs for the month of March 2013 have been recorded in the accounting records. The next quarter’s charge for heat and lighting is expected to be £10,380.

7. John has been advised to write-off a trade receivable of £9,300 and to make an allowance for irrecoverable receivables of 5 per cent of the outstanding receivables at the year-end. No entries have been made in the nominal ledger accounts.

8. John paid a year’s rent in advance on 1 November 2012. The rental payment was £60,000 and this was included in the rent total in the trial balance as at 31 March 2013.

Required:

(a) Using the list of closing balances as at 31 March 2013, prepare a trial balance and identify the closing balance of the ledger account, which has been omitted from the list of closing balances

(b) Using the trial balance prepared in Question 2(a) and the further information provided about the necessary post-trial balance adjustments, prepare an income statement and a balance sheet for John Porter for the year ended 31 March 2013.

Show all your workings. You are advised not to present an extended trial balance, as this is not required in order to gain marks.