Trial Balance as at 30 June 2023:
Revenue: Credit £380 000
Purchases: Debit £210 000
Inventory at 1 July 2022: Debit £34 000
Trade Receivables: Debit £48 000
Allowance for Doubtful Debts (1 July 2022): Credit £1 800
Trade Payables: Credit £31 400
Cash and Bank: Debit £7 300
Leasehold Premises (at cost): Debit £150 000
Equipment (at cost): Debit £80 000
Provision for Depreciation (1 July 2022):
- Leasehold Premises: Credit £30 000
- Equipment: Credit £32 000
Carriage Inwards: Debit £4 500
Carriage Outwards: Debit £6 200
Wages and Salaries: Debit £42 000
Rent, Rates and Insurance: Debit £22 000
General Expenses: Debit £11 800
Capital (1 July 2022): Credit £159 000
Drawings: Debit £18 400
Total: Debit £634 200 / Credit £634 200
Additional information:
1. Inventory at 30 June 2023 was valued at a cost of £38 500. This includes some damaged goods which cost £3 000 but can only be sold for £1 800 after incurring repair costs of £200.
2. On 30 June 2023, Sanjay took goods costing £1 500 for his own use. No entry has been made in the books of account.
3. Wages and Salaries of £1 200 were accrued (outstanding) as at 30 June 2023.
4. Rent, Rates and Insurance includes an insurance premium of £3 600 paid for the 12 months ending 31 October 2023.
5. A trade receivable owing £2 000 has been declared bankrupt and the debt is irrecoverable. It must be written off. The allowance for doubtful debts is to be adjusted to 5% of the remaining trade receivables.
6. Depreciation for the year is to be charged as follows:
- Leasehold Premises: 2% per annum on cost (Straight-line).
- Equipment: 15% per annum using the reducing balance method.
Required:
(a) Prepare Sanjay's Statement of Profit or Loss for the year ended 30 June 2023. [22 marks]
(b) Prepare Sanjay's Statement of Financial Position as at 30 June 2023. [18 marks]
(c) Calculate the following ratios to two decimal places:
(i) Gross Profit Margin,
(ii) Profit for the year as a percentage of revenue,
(iii) Liquid (Acid Test) ratio. [6 marks]
(d) Sanjay has saved £40 000 and is considering two alternative investment options to expand his business:
- Option A: Refurbish the existing physical retail store. This is expected to increase revenue by 10% next year, with an estimated gross profit margin of 45%. Operating expenses will increase by £8 000 per year.
- Option B: Launch an e-commerce website and transition part of the sales online. This is expected to generate £60 000 of new online sales next year. The online sales will have a lower gross profit margin of 35% due to high delivery and packaging costs, and additional digital marketing/hosting expenses will be £10 000 per year.
Evaluate these two options and recommend which option Sanjay should choose. [9 marks]
Show answer & marking schemeHide answer & marking scheme
Worked solution
Revenue: £380 000
Less: Cost of Sales:
- Opening Inventory: £34 000
- Purchases (£210 000 - £1 500): £208 500
- Carriage Inwards: £4 500
- Cost of Goods Available for Sale: £247 000
- Less: Closing Inventory (see note): (£37 100)
Cost of Sales: (£209 900)
Gross Profit: £170 100
Less: Expenses:
- Carriage Outwards: £6 200
- Wages and Salaries (£42 000 + £1 200): £43 200
- Rent, Rates and Insurance (£22 000 - £1 200): £20 800
- General Expenses: £11 800
- Irrecoverable debts: £2 000
- Increase in Allowance for Doubtful Debts (£2 300 - £1 800): £500
- Depreciation - Leasehold Premises: £3 000
- Depreciation - Equipment: £7 200
Total Expenses: (£94 700)
Profit for the Year: £75 400
Note on Closing Inventory: Cost of undamaged goods = £35 500. NRV of damaged goods = £1 800 - £200 = £1 600. Valuation = £35 500 + £1 600 = £37 100.
(b) Statement of Financial Position as at 30 June 2023:
Non-Current Assets:
- Leasehold Premises: Cost £150 000, Accumulated Depreciation £33 000, NBV £117 000
- Equipment: Cost £80 000, Accumulated Depreciation £39 200, NBV £40 800
Total Non-Current Assets: £157 800
Current Assets:
- Inventory: £37 100
- Trade Receivables (£48 000 - £2 000 - £2 300): £43 700
- Prepayments (Insurance): £1 200
- Cash and Bank: £7 300
Total Current Assets: £89 300
Total Assets: £247 100
Capital:
- Opening Capital: £159 000
- Add: Profit for the year: £75 400
- Less: Drawings (£18 400 + £1 500): (£19 900)
Closing Capital: £214 500
Current Liabilities:
- Trade Payables: £31 400
- Accruals (Wages): £1 200
Total Current Liabilities: £32 600
Total Capital and Liabilities: £247 100
(c) Ratio Calculations:
(i) Gross Profit Margin = (\(170 100 / 380 000\)) * 100 = 44.76% (or 44.80%)
(ii) Profit for the Year % = (\(75 400 / 380 000\)) * 100 = 19.84% (or 19.80%)
(iii) Liquid (Acid Test) Ratio = (\(43 700 + 1 200 + 7 300\)) / 32 600 = 52 200 / 32 600 = 1.60 : 1
(d) Evaluation and Recommendation:
Option A (Refurbishment):
- Increased sales = 10% * £380 000 = £38 000.
- Increased Gross Profit = 45% * £38 000 = £17 100.
- Increased Net Profit = £17 100 - £8 000 = £9 100.
- Sanjay already has experience running the physical store, making this lower risk. However, it does not expand the geographical reach of the business.
Option B (E-commerce):
- Online sales = £60 000.
- Increased Gross Profit = 35% * £60 000 = £21 000.
- Increased Net Profit = £21 000 - £10 000 = £11 000.
- This gives a higher net financial benefit by £1 900 (£11 000 - £9 100). It unlocks a wider customer base, but comes with logistics complexities, shipping costs, and tech management risks.
Recommendation: Sanjay should choose Option B because it yields a higher profit return and has greater growth potential in the digital era, provided he can manage the online logistics and security risks.
Marking scheme
- Revenue: £380 000 [1]
- Opening inventory: £34 000 [1]
- Adjusted purchases: £208 500 [2] (1 mark for showing £210 000 - £1 500)
- Carriage inwards: £4 500 [1]
- Closing inventory: £37 100 [3] (1 mark for undamaged cost £35 500, 1 mark for NRV £1 600, 1 mark for final addition)
- Cost of sales: £209 900 [1]
- Gross Profit: £170 100 [1 OF]
- Carriage outwards: £6 200 [1]
- Wages and salaries: £43 200 [2] (1 mark for showing £42 000 + £1 200)
- Rent, rates and insurance: £20 800 [2] (1 mark for prepaying £1 200)
- General expenses: £11 800 [1]
- Irrecoverable debts: £2 000 [1]
- Allowance for doubtful debts increase: £500 [2] (1 mark for calculating ending allowance £2 300, 1 mark for difference)
- Leasehold Premises Depreciation: £3 000 [1]
- Equipment Depreciation: £7 200 [1]
- Profit for the Year: £75 400 [1 OF]
(b) Statement of Financial Position [Total: 18 marks]
- Non-Current Assets Leasehold Premises NBV: £117 000 [1 OF]
- Non-Current Assets Equipment NBV: £40 800 [1 OF]
- Closing Inventory: £37 100 [1 OF]
- Trade Receivables (net of write-off and allowance): £43 700 [2] (1 mark for subtracting £2 000, 1 mark for subtracting £2 300)
- Prepayments: £1 200 [1]
- Cash and Bank: £7 300 [1]
- Total Assets: £247 100 [1 OF]
- Opening Capital: £159 000 [1]
- Profit for the Year: £75 400 [1 OF]
- Drawings: £19 900 [2] (1 mark for showing £18 400 + £1 500)
- Closing Capital: £214 500 [1 OF]
- Trade Payables: £31 400 [1]
- Accruals: £1 200 [1]
- Total Capital and Liabilities: £247 100 [2 OF] (1 mark if matches Total Assets, 1 mark for details correct)
(c) Ratios [Total: 6 marks]
- Gross Profit Margin: 44.76% (Accept 44.80%) [2] (1 mark for correct formula/working)
- Profit for the Year %: 19.84% (Accept 19.80%) [2] (1 mark for correct formula/working)
- Liquid (Acid Test) Ratio: 1.60 : 1 [2] (1 mark for correct formula/working)
(d) Evaluation & Decision [Total: 9 marks]
- Up to 4 marks for financial calculations of Option A and Option B (2 marks each for finding net profits: £9 100 for Option A, £11 000 for Option B).
- Up to 4 marks for balanced qualitative arguments (advantages/disadvantages of each choice).
- 1 mark for a clear, justified recommendation based on arguments presented.