ACCA F3 Trading Account 3

You have been provided with the following trial balance as at 31 May 2014 for a limited liability company.

 

ACCOUNT DEBIT CREDIT
BUILDING 180,000
ACC DEP BUILDING 36,000
PLANT 600
ACC DEP PLANT 120
MOTOR VEHICLES 500
ACC DEP MOTOR VEHICLES 100
BANK 261
REVENUE 300,000
DISCOUNT RECEIVED 1,250
PURCHASE 195,000
GENERAL EXPENSES 1,824
HEATING & LIGHTING 50
MARKETING & ADVERTISING 4,500
WAGES 5,600
LOAN INTEREST EXPENSES 450
INVENTORY 3,920
PAYABLES 28,350
RECEIVABLES 31,500
SHARE CAPITAL 54,679
RETAINED EARNINGS 1,206
5 % LOAN NOTE 2,500
424,205 424,205

The following notes are relevant.

1. Inventory at 31 May was valued at $4,704.

2. Marketing and advertising expenses include $1,000 paid in advance for a marketing campaign which will begin in June 2014. Marketing and advertising should be allocated to administrative expenses.

3. There are wages outstanding of $6,800 for the year ended 31 May 2014.

4. A customer ceased trading owing the company $1,500; the debt is not expected to be recovered.

5. An allowance for receivables is to be established amounting to 5% of trade receivables.

6. Depreciation is to be provided for as follows

Buildings at 5% per annum on their original cost, allocated 50% to cost of sales, 20% to distribution costs and 30% to administrative expenses.

Motor vehicles at 25% per annum of their written down value, allocated to distribution costs.

Plant and equipment at 20% per annum of their written down value, allocated to cost of sales.

7. No dividends have been paid or declared.

8. Income tax of $400 is to be provided for the year.

9. The audit fee accrual is estimated to be $250.

10. The expenses listed below should be apportioned as follow

COST OF SALES DISTRIBUTION COSTS ADMIN EXPENSES
% % %
GENERAL EXPENSES 10 40 50
HEATING 50 30 20
WAGES 60 30 10

Required

1. Prepare a statement of profit or loss for the year ended 31 May 20X6.

2. Prepare a statement of financial position as at that date.

Suggested solutions:

Working:

1. Inventory at 31 May was valued at $4,704.

Debit inventory in financial position and Credit inventory in Income statement.$4,704.

2. Marketing and advertising expenses include $1,000 paid in advance for a marketing campaign which will begin in June 2014. Marketing and advertising should be allocated to administrative expenses.

Debit Prepayment and Credit Marketing and advertising expenses $1,000

3. There are wages outstanding of $6,800 for the year ended 31 May 2014.

Debit wages and credit Accrual $6,800

4. A customer ceased trading owing the company $1,500; the debt is not expected to be recovered.

Debit Irrecoverable debt expenses and Credit Receivables $1,500

5. An allowance for receivables is to be established amounting to 5% of trade receivables.

(Receivables - debt written off ) X 5 %

( 31,500 - 1,500) X0.05

= $1,500

Debit irrecoverable debt expenses and Credit allowance for receivables $1,500

6. Depreciation is to be provided for as follows

Buildings at 5% per annum on their original cost, allocated 50% to cost of sales, 20% to distribution costs and 30% to administrative expenses.

Buildings X 0.05

$180,000 X 0.05

= $9,000

Debit Cost of sales $4,500

Debit distribution cost $1,800

Debit administrative expenses $2,700

And credit Acc Dep Building $9,000

Motor vehicles at 25% per annum of their written down value, allocated to distribution costs.

(Motor Vehicles minus Acc Motor vehicles) X 0.25

=(500 -100) X0.25

=$100

Debit distribution costs and credit Acc Dep Motor Vehicles $100.

Plant and equipment at 20% per annum of their written down value, allocated to cost of sales.

(plant minus acc plant) X O.2

= $(600 -120) X 0.2

=$96

Debit cost of sales and credit Acc Dep Plant $96

7. No dividends have been paid or declared.

No action to be taken.

8. Income tax of $400 is to be provided for the year.

Debit Income tax expenses and Credit Income tax payable $400.

9. The audit fee accrual is estimated to be $250.

Debit audit expenses and credit Accrual $250.

Income statement

REVENUE 300,000
COST OF SALES 205,209
GROSS PROFIT 94,791
DISTRIBUTION COST 6,365
ADMIN EXPENSES 11,612
FINANCING COST 450
PROFIT BEFORE TAX 76,364
INCOME TAX 400
PROFIT FOR THE PERIOD 75,964
ITEM AMOUNT % APPORTIONED CREDIT
OPENING INVENTORY 3,920
PURCHASES 195,000
LESS CLOSING INVENTORY (4,704)
GENERAL EXPENSES 1824 0.1 182.4
HEAT 50 0.5 25
WAGES 5600 +6800 0.6 7,440
DEP BUILDINGS 9000 0.5 4,500
DEP PLANT 96 1.0 96
LESS DISCOUNT RECEIVED (1,250)
FINAL COST OF SALES 205,209
ITEM AMOUNT % APPORTIONED CREDIT
GENERAL EXPENSES 1824 0.4 729.6
HEAT 50 0.3 15
WAGES 5600 +6800 0.3 3,720
DEP BUILDINGS 9000 0.2 1,800
MOTOR VEHICLES 100 1.0 100
DISTRIBUTION COST 6,365
ITEM AMOUNT % APPORTIONED CREDIT
GENERAL EXPENSES 1824 0.5 912
HEAT 50 0.2 10
WAGES 5600 +6800 0.1 1,240
DEP BUILDINGS 9000 0.3 2,700
AUDIT FEE 250
MARKETING COST 4500 -1000 3500
IRRECOVERABLE DEBTS AND ALLOWANCE 1500 +1500 3000
ADMINISTRATIVE EXPENSES 11,612

Financial position

ACCOUNT WORKING DEBIT CREDIT
NON CURRENT ASSETS 180000 +500 +600 181,100
LESS ACC DEP EQUIPMENT 200 + 216 +45000 (45,416)
TOTAL NON CURRENT ASSETS 135,684
CURRENT ASSETS
INVENTORY 4,704
RECEIVABLES 31,500
less allowance and bad debt for receivables (1500 + 1500)
Receivables 28500
PREPAYMENT 1000
BANK 261
TOTAL CURRENT ASSETS 34,465
TOTAL ASSETS 170,149
ACCOUNT WORKING DEBIT CREDIT
PAYABLES 28,350
ACCRUAL 7050
TAXATION 400
5% LOAN NOTES 2500
TOTAL CURRENT LIABILITY 38,300
$1 Ordinary shares 54,679
Profit 75,964
RETAINED EARNINGS 1206
TOTAL EQUITY 131,849
TOTAL LIABILITIES & EQUITY 170,149

To do the same topic again in ACCA F3 Trading Account

To do another topic in ACCA F3