(a) Using the information provided in question C12.1, prepare a spreadsheet containing a trial balance, adjustment and resulting figures for income statement (profit and loss account) and statement of financial position (balance sheet) items. (Table 12.7 provides a pattern to follow.)
Refer to C12.1,
Set out below is a summary of the accounting records of Titan Ltd at 31 December Year 1:

The summary of the accounting records includes all transactions which have been entered in the ledger accounts up to 31 December, but investigation reveals further adjustments which relate to the accounting period up to, and including, that date.
The adjustments required relate to the following matters:
(I) No depreciation has been charged for the year in respect of buildings, plant and machinery. The depreciation of the building has been calculated as £2,000 per annum and the depreciation of plant and machinery for the year has been calculated as £55,000.
(ii) The company is aware that electricity consumption during the months of November and December, Year 1, amounted to around £5,000 in total, but no electricity bill has yet been received.
(iii) Overhead expenses include insurance premiums of £36,000 which were paid at the start of December, Year 1, in respect of the 12-month period ahead.
(iv) The stock amount is as shown in the accounting records of items moving into and out of stock during the year. On 31 December a check of the physical stock was made. It was discovered that raw materials recorded as having a value of £3,000 were, in fact, unusable.
(v) The company proposes to pay a dividend of £30,000.
Table 12.7
Trial balance of M. Carter at the end of May, before month-end adjustments

Transcribed Image Text:

£000s £000s Assets Land and buildings 200 Plant and machinery 550 Investment in shares 150 Stock 250 Trade receivables (debtors) 180 Cash 150 Liabilities Trade payables (creditors) 365 Debenture loan 10% nominal rate of interest 250 Ownership interest Share capital 600 Retained eamings at 1 Jan. Year 1 125 Revenue Sales 1,815 Cost of goods sold 1,505 Expenses Overhead expenses 145 Debenture interest paid 25 Totals 3,155 3,155