Trading, Profit & Loss Account of IDS plc. For the year ending 31 December 2003
£1000 £1000 £1000 Sales 3550 Less Cost of Goods Sold
Opening Stock 600
Add Purchase 2,000
2,600
Less Closing Stock 290
Cost of Goods Sold 2,310 Gross profit 1,240 Add Any Other Business Income
Discount received 220
1,460 Less Expenses
Administration Expenses 220
Add Accruals 25
245
Distribution Costs 340
Less Prepayments 15
325
Debenture Interest Due 160
Depreciation
Land and Buildings 50
Plant and Machinery 40
Fixtures and Fittings 30
Motor Vehicles 60
180
910 Net Profit Before Taxation 550 Add Corporation Tax 190 Net Profit After Taxation 360 Add Unappropriated Profit B/F 1,090
1,450 Less Appropriations
Preference Share Capital 10
Ordinary Share Capitals 27
37 Unappropriated Profit B/F 1,413
Income and expenditure budget for six months
Income Jan Feb May Apr May Jun Total £££££££Sales 8,000 8,000 10,400 12,000 14,000 16,000 68,400
Expenditure
Variable Cost
Materials 400 400 520 600 700 800 3,420 Labour 2,400 2,400 3,120 3,600 4,200 4,800 20,520 Overheads 400 400 520 600 700 800 3,420
Fixed Cost
1000 1000 1000 1000 1000 1000 6,000 Rent and
Rates
Insurance 400 400 400 400 400 400 2,400 800 800 800 800 800 800 4,800 Heat and
Light
Depreciation 200 200 200 200 200 200 1,200 Other 250 250 250 250 250 250 1,500 Manager’s
2,000 2,000 2,000 2,000 2,000 2,000 12,000 Salary
1,000 1,000 1,000 1,000 1,000 1,000 6,000 Selling and
Distribution
Total 8,850 8,850 9,810 10,450 11,250 12,050 61,260
Cash Budget for six months
Jan Feb May Apr May Jun Receipts ££££££Credit sales 0 8,000 8,000 10,400 12,000 14,000 Payments
Materials 0 0 400 400 520 600 Labour 2,400 2,400 3,120 3,600 4,200 4,800 Overheads 400 400 520 600 700 800 Fixed Cost
Rent and
1,000 1,000 1,000 1,000 1,000 1,000 Rates
Insurance 400 400 400 400 400 400 800 800 800 800 800 800 Heat and
Light
Other 250 250 250 250 250 250 2,000 2,000 2,000 2,000 2,000 2,000 Manager’s
Salary
Selling/
1,000 1,000 1,000 1,000 1,000 1,000 Distirbution
8,250 8,250 9,490 10,050 10,870 11,650 Opening
0 (8,250) (8,500) (9,990) (9,640) (8,510) Balance
0 8,000 8,000 10,400 12,000 14,000
Add
Receipts
0 (250) (500) 410 2,360 5,490
8,250 8,250 9,490 10,050 10,870 11,650 Less
Payments
Closing
(8,250) (8,500) (9,990) (9,640) (8,510) (6,160) Banance
Break-even point
1. Selling price £40
2. Variable Cost Per Unit:
Materials £2
Labour £12
Overheads £2
£16
3. Fixed Cost
Rent and Rates £1000*6
Insurance £400*6
Heat and Light £800*6
Depreciation £200*6
Other £250*6
Manager’s Salary £2,000*6
Selling/ Distribution £1,000*6
£33,900
4. Contribution Per Unit
Selling Price – Variable Price
=£40 –£16 £24
5. Break—even Point
= Fixed Cost%Contribution
=£33,900%£24
=1,413