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 400
ACC DEP PLANT 80
MOTOR VEHICLES 200
ACC DEP MOTOR VEHICLES 40
BANK 348
REVENUE 250,000
DISCOUNT RECEIVED 750
PURCHASE 162,500
GENERAL EXPENSES 912
HEATING & LIGHTING 100
MARKETING & ADVERTISING 500
WAGES 800
LOAN INTEREST EXPENSES 150
INVENTORY 6,860
PAYABLES 32,400
RECEIVABLES 36,000
SHARE CAPITAL 65,928
RETAINED EARNINGS 1,072
5 % LOAN NOTE 2,500
388,770 388,770

The following notes are relevant.

1. Inventory at 31 May was valued at $8,232.

2. Marketing and advertising expenses include $500 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 $1,700 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 $1,500.

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 $8,232.

Debit inventory in financial position and Credit inventory in Income statement.$8,232.

2. Marketing and advertising expenses include $500 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 $500

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

Debit wages and credit Accrual $1,700

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 %

( 36,000 - 1,500) X0.05

= $1,725

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

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

=(200 -40) X0.25

=$40

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

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

(plant minus acc plant) X O.2

= $(400 -80) X 0.2

=$64

Debit cost of sales and credit Acc Dep Plant $64

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 $1,500.

Debit audit expenses and credit Accrual $1,500.

Income statement

REVENUE 250,000
COST OF SALES 166,583
GROSS PROFIT 83,417
DISTRIBUTION COST 2,985
ADMIN EXPENSES 8,151
FINANCING COST 150
PROFIT BEFORE TAX 72,131
INCOME TAX 400
PROFIT FOR THE PERIOD 71,731
ITEM AMOUNT % APPORTIONED CREDIT
OPENING INVENTORY 6,860
PURCHASES 162,500
LESS CLOSING INVENTORY (8,232)
GENERAL EXPENSES 912 0.1 91.2
HEAT 100 0.5 50
WAGES 800 +1700 0.6 1,500
DEP BUILDINGS 9000 0.5 4,500
DEP PLANT 64 1.0 64
LESS DISCOUNT RECEIVED (750)
FINAL COST OF SALES 166,583
ITEM AMOUNT % APPORTIONED CREDIT
GENERAL EXPENSES 912 0.4 364.8
HEAT 100 0.3 30
WAGES 800 +1700 0.3 750
DEP BUILDINGS 9000 0.2 1,800
MOTOR VEHICLES 40 1.0 40
DISTRIBUTION COST 2,985
ITEM AMOUNT % APPORTIONED CREDIT
GENERAL EXPENSES 912 0.5 456
HEAT 100 0.2 20
WAGES 800 +1700 0.1 250
DEP BUILDINGS 9000 0.3 2,700
AUDIT FEE 1500
MARKETING COST 500 -500 0
IRRECOVERABLE DEBTS AND ALLOWANCE 1500 +1725 3225
ADMINISTRATIVE EXPENSES 8,151

Financial position

ACCOUNT WORKING DEBIT CREDIT
NON CURRENT ASSETS 180000 +200 +400 180,600
LESS ACC DEP EQUIPMENT 80 + 144 +45000 (45,224)
TOTAL NON CURRENT ASSETS 135,376
CURRENT ASSETS
INVENTORY 8,232
RECEIVABLES 36,000
less allowance and bad debt for receivables (1725 + 1500)
Receivables 32775
PREPAYMENT 500
BANK 348
TOTAL CURRENT ASSETS 41,855
TOTAL ASSETS 177,231
ACCOUNT WORKING DEBIT CREDIT
PAYABLES 32,400
ACCRUAL 3200
TAXATION 400
5% LOAN NOTES 2500
TOTAL CURRENT LIABILITY 38,500
$1 Ordinary shares 65,928
Profit 71,731
RETAINED EARNINGS 1072
TOTAL EQUITY 138,731
TOTAL LIABILITIES & EQUITY 177,231

To do the same topic again in ACCA F3 Trading Account

To do another topic in ACCA F3