incomplete records?

Question

Hello

I am doing a course of advanced bookkeeping and was wondering anyone knew how to get the sales figure for the P/L

Arthur is a sole owner of an electrical spares shop. He keeps minimal records. You are asked to prepare his accounts for the year ending 31 march 2002. You are told that all receipts have been banked with the exception of £11,000 which he has retained for his own use.

His assets and liabilities at 31 march 2001/2002 were:

Bank
Year 2001: 1500
Year 2002: 2000
Debtors
Year 2001: 9100
Year 2002: 9900
Rent paid in advanced
Year 2001: 100
Year 2002: 200
Stock
Year 2001: 4400
Year 2002: 5300
Expenses unpaid wages
Year 2001: 350
Year 2002: 440
Heating
year 2001: 135
Year 2002: 145
Creditors
Year 2001: 5215
Year 2002: 6205
Vehicle
year 2001: 9000
year 2002: 9000
Provision for depreciation
Year 2001: 900
year 2002:
Capital
Year 2001: 17500
Year 2002:


1, the vehicle is to be depreciated using the straight line method at 10% per annum; new fittings purchased during the year are also to be depreciated at 10% per annum.
2, Arthur took £100 worth of goods from stock for his personal use.
3, payments made during the year included:

Purchases of electrical goods 34000
Rent/rates 3000
Light/heat 805
Motor expenses 1150
New fittings 750
Wages 2000
Bank Charges 105


Prepare a bank account/ trading profit and loss and balance sheet.

Can anyone tell me how I begin as you can see there are not much receipts coming in to the bank and how do I calculate my sales for the profit and loss account. There are a lot of things that are confusing me about this.

Answer 1

Bank A/c
Bal. 1.1.2002 $1,500
Receipts:
From sales 42,310
Payments:
Purchases of electrical goods 34000
Rent/rates 3000
Light/heat 805
Motor expenses 1150
New fittings 750
Wages 2000
Bank Charges 105
Bal. at 31.12.2002 $2,000


Profit & Loss A/c
Sales 54,110
COGS 33,990
Gross Profit 20,120
Less:
Op'g Exp.
Bank charges 105
Depn 975
Heating 815
Motor exp. 1,150
Rent 2,900
Wages 2,090

Profit for 2002 $12,085

Balance Sheet
Non-current assets -
Vehicle(nbv) 7,200
Fittings(nbv) 675
Sub-total 7,875
Current Assets
Stocks 5,300
Debtors 9,900
Prepaid rent 200
Bank 2,000
Sub-total 17,400
Total assets $25,275

Liabilities
Creditors 6,205
Unpaid wages 440
Unpaid heating 145
Total liabilities 6,790

Owner's Equity
Bal. at 1.1.2002 17,500
Profit for 2002 12,085
Drawings-
From sales (11,000)
From stocks (100)
Bal. at 31.12.2002 18,485

Total Liabilities & Equity $25,275

This was a very long exercise. If you want the detailed working, pls email me with your email address and I'll forward you an Excel worksheet.