題目 1 · Financial Statement Preparation and Forecast Analysis
55 分Karan is a sole trader who runs a wholesaling business. The following trial balance was prepared from his books of account at 30 April 2023:
| Account | Debit (£) | Credit (£) |
| :--- | :---: | :---: |
| Revenue | | 480,000 |
| Purchases | 290,000 | |
| Inventory (1 May 2022) | 42,000 | |
| Trade receivables | 54,000 | |
| Allowance for doubtful debts (1 May 2022) | | 2,400 |
| Trade payables | | 36,500 |
| Cash at bank (overdraft) | | 4,200 |
| Premises (cost) | 200,000 | |
| Equipment (cost) | 80,000 | |
| Accumulated depreciation (1 May 2022): | | |
| - Premises | | 20,000 |
| - Equipment | | 32,000 |
| Wages and salaries | 48,500 | |
| Rent and rates | 24,000 | |
| General expenses | 18,600 | |
| Drawings | 25,000 | |
| Capital (1 May 2022) | | 207,000 |
| **Total** | **782,100** | **782,100** |
**Additional information at 30 April 2023:**
1. Inventory at 30 April 2023 was valued at cost of \(£46,000\). This included some damaged goods costing \(£4,000\). These goods can be repaired for \(£800\) and then sold for \(£3,500\).
2. Rent and rates includes \(£3,000\) paid for rent for the three months ending 31 May 2023.
3. General expenses accrued but unpaid at 30 April 2023 amounted to \(£1,400\).
4. During the year, Karan took goods costing \(£1,500\) for his personal use. No entry has been made in the books.
5. A trade debt of \(£3,000\) is irrecoverable and must be written off. The allowance for doubtful debts is to be adjusted to 5% of trade receivables.
6. Depreciation is to be charged as follows:
- Premises: 2% per annum using the straight-line method.
- Equipment: 15% per annum using the reducing balance method.
**Required:**
(a) Prepare Karan's Statement of Profit or Loss for the year ended 30 April 2023. *(22 marks)*
(b) Prepare Karan's Statement of Financial Position as at 30 April 2023. *(15 marks)*
(c) Calculate the following ratios for the year ended 30 April 2023 (rounding answers to two decimal places):
(i) Gross profit margin % *(3 marks)*
(ii) Profit for the year margin % *(3 marks)*
(iii) Liquid (acid test) ratio *(4 marks)*
(d) Karan is considering moving from his manual bookkeeping system to a cloud-based computerized accounting system. Evaluate whether Karan should adopt a computerized accounting system. *(8 marks)*
| Account | Debit (£) | Credit (£) |
| :--- | :---: | :---: |
| Revenue | | 480,000 |
| Purchases | 290,000 | |
| Inventory (1 May 2022) | 42,000 | |
| Trade receivables | 54,000 | |
| Allowance for doubtful debts (1 May 2022) | | 2,400 |
| Trade payables | | 36,500 |
| Cash at bank (overdraft) | | 4,200 |
| Premises (cost) | 200,000 | |
| Equipment (cost) | 80,000 | |
| Accumulated depreciation (1 May 2022): | | |
| - Premises | | 20,000 |
| - Equipment | | 32,000 |
| Wages and salaries | 48,500 | |
| Rent and rates | 24,000 | |
| General expenses | 18,600 | |
| Drawings | 25,000 | |
| Capital (1 May 2022) | | 207,000 |
| **Total** | **782,100** | **782,100** |
**Additional information at 30 April 2023:**
1. Inventory at 30 April 2023 was valued at cost of \(£46,000\). This included some damaged goods costing \(£4,000\). These goods can be repaired for \(£800\) and then sold for \(£3,500\).
2. Rent and rates includes \(£3,000\) paid for rent for the three months ending 31 May 2023.
3. General expenses accrued but unpaid at 30 April 2023 amounted to \(£1,400\).
4. During the year, Karan took goods costing \(£1,500\) for his personal use. No entry has been made in the books.
5. A trade debt of \(£3,000\) is irrecoverable and must be written off. The allowance for doubtful debts is to be adjusted to 5% of trade receivables.
6. Depreciation is to be charged as follows:
- Premises: 2% per annum using the straight-line method.
- Equipment: 15% per annum using the reducing balance method.
**Required:**
(a) Prepare Karan's Statement of Profit or Loss for the year ended 30 April 2023. *(22 marks)*
(b) Prepare Karan's Statement of Financial Position as at 30 April 2023. *(15 marks)*
(c) Calculate the following ratios for the year ended 30 April 2023 (rounding answers to two decimal places):
(i) Gross profit margin % *(3 marks)*
(ii) Profit for the year margin % *(3 marks)*
(iii) Liquid (acid test) ratio *(4 marks)*
(d) Karan is considering moving from his manual bookkeeping system to a cloud-based computerized accounting system. Evaluate whether Karan should adopt a computerized accounting system. *(8 marks)*
查看答案詳解收起答案詳解
解題
**(a) Karan - Statement of Profit or Loss for the year ended 30 April 2023**
| | £ | £ |
| :--- | :---: | :---: |
| **Revenue** | | **480,000** |
| **Cost of Sales** | | |
| Opening Inventory | 42,000 | |
| Purchases \((290,000 - 1,500)\) | 288,500 | |
| | 330,500 | |
| Less: Closing Inventory *[W1]* | (44,700) | |
| **Cost of Sales** | | **(285,800)** |
| **Gross Profit** | | **194,200** |
| | | |
| **Expenses** | | |
| Wages and salaries | 48,500 | |
| Rent and rates \((24,000 - 1,000\text{ prepayment } [W2])\) | 23,000 | |
| General expenses \((18,600 + 1,400\text{ accrual})\) | 20,000 | |
| Irrecoverable debts | 3,000 | |
| Increase in allowance for doubtful debts *[W3]* | 150 | |
| Depreciation - Premises \((200,000 \times 2\%)\) | 4,000 | |
| Depreciation - Equipment *[W4]* | 7,200 | |
| **Total Expenses** | | **(105,850)** |
| **Profit for the year** | | **88,350** |
**Workings:**
- **[W1] Closing Inventory:** Cost \(£46,000\). Damaged goods cost \(£4,000\), Net Realisable Value (NRV) \(= 3,500 - 800 = £2,700\). Because NRV is lower, write down by \(4,000 - 2,700 = 1,300\). Adjusted inventory \(= 46,000 - 1,300 = £44,700\).
- **[W2] Rent Prepayment:** \(£3,000\) for 3 months (March, April, May). Prepaid for May (1 month) \(= £3,000 \div 3 = £1,000\).
- **[W3] Allowance for Doubtful Debts:** Trade Receivables \(= 54,000 - 3,000\text{ (irrecoverable)} = £51,000\). New allowance \(= 51,000 \times 5\% = £2,550\). Increase \(= 2,550 - 2,400 = £150\).
- **[W4] Depreciation - Equipment:** Net book value \(= 80,000 - 32,000 = £48,000\). Depreciation \(= 48,000 \times 15\% = £7,200\).
---
**(b) Karan - Statement of Financial Position as at 30 April 2023**
| Non-Current Assets | Cost (£) | Accum. Dep. (£) | Carrying Value (£) |
| :--- | :---: | :---: | :---: |
| Premises | 200,000 | 24,000 | 176,000 |
| Equipment | 80,000 | 39,200 | 40,800 |
| **Total Non-Current Assets** | **280,000** | **63,200** | **216,800** |
| Current Assets | £ | £ |
| :--- | :---: | :---: |
| Inventory | | 44,700 |
| Trade receivables \((51,000 - 2,550)\) | 48,450 | |
| Prepayments (Rent) | 1,000 | |
| **Total Current Assets** | | **94,150** |
| **Total Assets** | | **310,950** |
| Equity and Liabilities | | |
| :--- | :---: | :---: |
| **Equity** | | |
| Opening Capital | | 207,000 |
| Add: Profit for the year | | 88,350 |
| | | 295,350 |
| Less: Drawings \((25,000\text{ cash} + 1,500\text{ goods})\) | | (26,500) |
| **Closing Capital** | | **268,850** |
| | | |
| **Current Liabilities** | | |
| Trade payables | 36,500 | |
| Bank overdraft | 4,200 | |
| Accruals (General expenses) | 1,400 | |
| **Total Current Liabilities** | | **42,100** |
| **Total Equity and Liabilities** | | **310,950** |
---
**(c) Ratios (Rounding to two decimal places)**
(i) **Gross profit margin %**
$$\text{Formula} = \left( \frac{\text{Gross Profit}}{\text{Revenue}} \right) \times 100$$
$$\text{Gross profit margin %} = \left( \frac{194,200}{480,000} \right) \times 100 = 40.4583\% \approx 40.46\%$$
(ii) **Profit for the year margin %**
$$\text{Formula} = \left( \frac{\text{Profit for the Year}}{\text{Revenue}} \right) \times 100$$
$$\text{Profit for the year margin %} = \left( \frac{88,350}{480,000} \right) \times 100 = 18.4062\% \approx 18.41\%$$
(iii) **Liquid (acid test) ratio**
$$\text{Formula} = \frac{\text{Current Assets} - \text{Inventory}}{\text{Current Liabilities}}$$
$$\text{Liquid ratio} = \frac{94,150 - 44,700}{42,100} = \frac{49,450}{42,100} = 1.1745 \approx 1.17 : 1$$
---
**(d) Evaluation: Adopting a Cloud-Based Computerized Accounting System**
**Arguments for adoption (Advantages):**
- **Efficiency & Speed:** Software automates major calculations and updates ledgers instantly, saving significant time compared to manual recording.
- **Accuracy:** Reduces human arithmetical mistakes and transcription errors.
- **Real-Time Financial Reporting:** Karan will be able to retrieve instant statements, outstanding receivable lists, and cash flow positions to support faster business decisions.
- **Data Security & Cloud Backups:** Remote storage eliminates risks of records being lost due to physical fires or damage at the office.
**Arguments against adoption (Disadvantages):**
- **Costs:** Initial investment in software licenses/subscription, hardware upgrades, and recurring monthly maintenance fees.
- **Staff Training:** Karan and his employees may require time and training to become proficient with the new software, temporarily lowering productivity.
- **Cybersecurity & Downtime:** Relying on internet connectivity means any service outages can stop updates. Additionally, cloud data is exposed to security breaches/hacking risks if passwords/systems are not well managed.
**Conclusion:**
Karan should move to a computerized accounting system. Given his turnover is substantial (\(£480,000\)) and he deals with complexities such as credit transactions (trade receivables and payables), the benefits of time saved, enhanced tracking of debts, and accuracy outweigh the initial setup costs and learning curve.
| | £ | £ |
| :--- | :---: | :---: |
| **Revenue** | | **480,000** |
| **Cost of Sales** | | |
| Opening Inventory | 42,000 | |
| Purchases \((290,000 - 1,500)\) | 288,500 | |
| | 330,500 | |
| Less: Closing Inventory *[W1]* | (44,700) | |
| **Cost of Sales** | | **(285,800)** |
| **Gross Profit** | | **194,200** |
| | | |
| **Expenses** | | |
| Wages and salaries | 48,500 | |
| Rent and rates \((24,000 - 1,000\text{ prepayment } [W2])\) | 23,000 | |
| General expenses \((18,600 + 1,400\text{ accrual})\) | 20,000 | |
| Irrecoverable debts | 3,000 | |
| Increase in allowance for doubtful debts *[W3]* | 150 | |
| Depreciation - Premises \((200,000 \times 2\%)\) | 4,000 | |
| Depreciation - Equipment *[W4]* | 7,200 | |
| **Total Expenses** | | **(105,850)** |
| **Profit for the year** | | **88,350** |
**Workings:**
- **[W1] Closing Inventory:** Cost \(£46,000\). Damaged goods cost \(£4,000\), Net Realisable Value (NRV) \(= 3,500 - 800 = £2,700\). Because NRV is lower, write down by \(4,000 - 2,700 = 1,300\). Adjusted inventory \(= 46,000 - 1,300 = £44,700\).
- **[W2] Rent Prepayment:** \(£3,000\) for 3 months (March, April, May). Prepaid for May (1 month) \(= £3,000 \div 3 = £1,000\).
- **[W3] Allowance for Doubtful Debts:** Trade Receivables \(= 54,000 - 3,000\text{ (irrecoverable)} = £51,000\). New allowance \(= 51,000 \times 5\% = £2,550\). Increase \(= 2,550 - 2,400 = £150\).
- **[W4] Depreciation - Equipment:** Net book value \(= 80,000 - 32,000 = £48,000\). Depreciation \(= 48,000 \times 15\% = £7,200\).
---
**(b) Karan - Statement of Financial Position as at 30 April 2023**
| Non-Current Assets | Cost (£) | Accum. Dep. (£) | Carrying Value (£) |
| :--- | :---: | :---: | :---: |
| Premises | 200,000 | 24,000 | 176,000 |
| Equipment | 80,000 | 39,200 | 40,800 |
| **Total Non-Current Assets** | **280,000** | **63,200** | **216,800** |
| Current Assets | £ | £ |
| :--- | :---: | :---: |
| Inventory | | 44,700 |
| Trade receivables \((51,000 - 2,550)\) | 48,450 | |
| Prepayments (Rent) | 1,000 | |
| **Total Current Assets** | | **94,150** |
| **Total Assets** | | **310,950** |
| Equity and Liabilities | | |
| :--- | :---: | :---: |
| **Equity** | | |
| Opening Capital | | 207,000 |
| Add: Profit for the year | | 88,350 |
| | | 295,350 |
| Less: Drawings \((25,000\text{ cash} + 1,500\text{ goods})\) | | (26,500) |
| **Closing Capital** | | **268,850** |
| | | |
| **Current Liabilities** | | |
| Trade payables | 36,500 | |
| Bank overdraft | 4,200 | |
| Accruals (General expenses) | 1,400 | |
| **Total Current Liabilities** | | **42,100** |
| **Total Equity and Liabilities** | | **310,950** |
---
**(c) Ratios (Rounding to two decimal places)**
(i) **Gross profit margin %**
$$\text{Formula} = \left( \frac{\text{Gross Profit}}{\text{Revenue}} \right) \times 100$$
$$\text{Gross profit margin %} = \left( \frac{194,200}{480,000} \right) \times 100 = 40.4583\% \approx 40.46\%$$
(ii) **Profit for the year margin %**
$$\text{Formula} = \left( \frac{\text{Profit for the Year}}{\text{Revenue}} \right) \times 100$$
$$\text{Profit for the year margin %} = \left( \frac{88,350}{480,000} \right) \times 100 = 18.4062\% \approx 18.41\%$$
(iii) **Liquid (acid test) ratio**
$$\text{Formula} = \frac{\text{Current Assets} - \text{Inventory}}{\text{Current Liabilities}}$$
$$\text{Liquid ratio} = \frac{94,150 - 44,700}{42,100} = \frac{49,450}{42,100} = 1.1745 \approx 1.17 : 1$$
---
**(d) Evaluation: Adopting a Cloud-Based Computerized Accounting System**
**Arguments for adoption (Advantages):**
- **Efficiency & Speed:** Software automates major calculations and updates ledgers instantly, saving significant time compared to manual recording.
- **Accuracy:** Reduces human arithmetical mistakes and transcription errors.
- **Real-Time Financial Reporting:** Karan will be able to retrieve instant statements, outstanding receivable lists, and cash flow positions to support faster business decisions.
- **Data Security & Cloud Backups:** Remote storage eliminates risks of records being lost due to physical fires or damage at the office.
**Arguments against adoption (Disadvantages):**
- **Costs:** Initial investment in software licenses/subscription, hardware upgrades, and recurring monthly maintenance fees.
- **Staff Training:** Karan and his employees may require time and training to become proficient with the new software, temporarily lowering productivity.
- **Cybersecurity & Downtime:** Relying on internet connectivity means any service outages can stop updates. Additionally, cloud data is exposed to security breaches/hacking risks if passwords/systems are not well managed.
**Conclusion:**
Karan should move to a computerized accounting system. Given his turnover is substantial (\(£480,000\)) and he deals with complexities such as credit transactions (trade receivables and payables), the benefits of time saved, enhanced tracking of debts, and accuracy outweigh the initial setup costs and learning curve.
評分準則
**(a) Statement of Profit or Loss (22 marks):**
- **Revenue:** £480,000 (1 mark)
- **Opening Inventory:** £42,000 (1 mark)
- **Purchases:** £288,500 (2 marks) [1 mark for £290,000, 1 mark for subtracting £1,500]
- **Closing Inventory:** £44,700 (3 marks) [1 mark for recognizing £46,000, 1 mark for subtracting £4,000 cost of damaged items, 1 mark for adding NRV £2,700]
- **Cost of Sales:** £285,800 (1 mark of)
- **Gross Profit:** £194,200 (1 mark of)
- **Wages and salaries:** £48,500 (1 mark)
- **Rent and rates:** £23,000 (2 marks) [1 mark for £24,000, 1 mark for subtracting prepayment £1,000]
- **General expenses:** £20,000 (2 marks) [1 mark for £18,600, 1 mark for adding accrual £1,400]
- **Irrecoverable debts:** £3,000 (1 mark)
- **Increase in allowance for doubtful debts:** £150 (2 marks) [1 mark for calculating new allowance £2,550, 1 mark for subtracting old allowance £2,400]
- **Depreciation - Premises:** £4,000 (2 marks) [1 mark for using straight line on cost, 1 mark for calculation]
- **Depreciation - Equipment:** £7,200 (2 marks) [1 mark for using carrying value £48,000, 1 mark for calculation]
- **Profit for the year:** £88,350 (1 mark of)
**(b) Statement of Financial Position (15 marks):**
- **Premises carrying value:** £176,000 (2 marks) [1 mark for accumulated depreciation £24,000, 1 mark for Net Book Value]
- **Equipment carrying value:** £40,800 (2 marks) [1 mark for accumulated depreciation £39,200, 1 mark for Net Book Value]
- **Closing Inventory:** £44,700 (1 mark of)
- **Trade Receivables net of allowance:** £48,450 (2 marks) [1 mark for receivables £51,000, 1 mark for net of allowance £2,550]
- **Prepayment (Rent):** £1,000 (1 mark)
- **Equity Section:** (4 marks) [1 mark for opening capital £207,000, 1 mark for profit of £88,350, 1 mark for drawings £26,500 (showing cash + goods), 1 mark for correct closing capital total £268,850 of]
- **Current Liabilities:** (3 marks) [1 mark for Trade payables £36,500, 1 mark for Bank overdraft £4,200, 1 mark for Accruals £1,400]
**(c) Ratios (10 marks):**
- **(i) Gross profit margin %:** (3 marks) [1 mark for correct formula or values, 1 mark for correct math, 1 mark for 40.46% (to 2 d.p.)]
- **(ii) Profit for the year margin %:** (3 marks) [1 mark for formula/values, 1 mark for correct math, 1 mark for 18.41% (to 2 d.p.)]
- **(iii) Liquid ratio:** (4 marks) [1 mark for liquid assets formula/values (94,150 - 44,700), 1 mark for current liabilities, 1 mark for correct division, 1 mark for expression as a ratio 1.17 : 1]
**(d) Evaluation (8 marks):**
- **Level 1 (1–2 marks):** Basic points identified (e.g. computer is fast, but expensive). No specific application to Karan's business or a weak/non-existent conclusion.
- **Level 2 (3–5 marks):** Balanced points discussing benefits (speed, fewer math errors, reporting) and disadvantages (costs, training, data loss risks) applied to Karan. A basic conclusion is provided.
- **Level 3 (6–8 marks):** In-depth evaluation showing balanced understanding. Excellent application to a wholesaler context (handling numerous receivables/payables, inventory control). Clear, fully supported and justified recommendation.
- **Revenue:** £480,000 (1 mark)
- **Opening Inventory:** £42,000 (1 mark)
- **Purchases:** £288,500 (2 marks) [1 mark for £290,000, 1 mark for subtracting £1,500]
- **Closing Inventory:** £44,700 (3 marks) [1 mark for recognizing £46,000, 1 mark for subtracting £4,000 cost of damaged items, 1 mark for adding NRV £2,700]
- **Cost of Sales:** £285,800 (1 mark of)
- **Gross Profit:** £194,200 (1 mark of)
- **Wages and salaries:** £48,500 (1 mark)
- **Rent and rates:** £23,000 (2 marks) [1 mark for £24,000, 1 mark for subtracting prepayment £1,000]
- **General expenses:** £20,000 (2 marks) [1 mark for £18,600, 1 mark for adding accrual £1,400]
- **Irrecoverable debts:** £3,000 (1 mark)
- **Increase in allowance for doubtful debts:** £150 (2 marks) [1 mark for calculating new allowance £2,550, 1 mark for subtracting old allowance £2,400]
- **Depreciation - Premises:** £4,000 (2 marks) [1 mark for using straight line on cost, 1 mark for calculation]
- **Depreciation - Equipment:** £7,200 (2 marks) [1 mark for using carrying value £48,000, 1 mark for calculation]
- **Profit for the year:** £88,350 (1 mark of)
**(b) Statement of Financial Position (15 marks):**
- **Premises carrying value:** £176,000 (2 marks) [1 mark for accumulated depreciation £24,000, 1 mark for Net Book Value]
- **Equipment carrying value:** £40,800 (2 marks) [1 mark for accumulated depreciation £39,200, 1 mark for Net Book Value]
- **Closing Inventory:** £44,700 (1 mark of)
- **Trade Receivables net of allowance:** £48,450 (2 marks) [1 mark for receivables £51,000, 1 mark for net of allowance £2,550]
- **Prepayment (Rent):** £1,000 (1 mark)
- **Equity Section:** (4 marks) [1 mark for opening capital £207,000, 1 mark for profit of £88,350, 1 mark for drawings £26,500 (showing cash + goods), 1 mark for correct closing capital total £268,850 of]
- **Current Liabilities:** (3 marks) [1 mark for Trade payables £36,500, 1 mark for Bank overdraft £4,200, 1 mark for Accruals £1,400]
**(c) Ratios (10 marks):**
- **(i) Gross profit margin %:** (3 marks) [1 mark for correct formula or values, 1 mark for correct math, 1 mark for 40.46% (to 2 d.p.)]
- **(ii) Profit for the year margin %:** (3 marks) [1 mark for formula/values, 1 mark for correct math, 1 mark for 18.41% (to 2 d.p.)]
- **(iii) Liquid ratio:** (4 marks) [1 mark for liquid assets formula/values (94,150 - 44,700), 1 mark for current liabilities, 1 mark for correct division, 1 mark for expression as a ratio 1.17 : 1]
**(d) Evaluation (8 marks):**
- **Level 1 (1–2 marks):** Basic points identified (e.g. computer is fast, but expensive). No specific application to Karan's business or a weak/non-existent conclusion.
- **Level 2 (3–5 marks):** Balanced points discussing benefits (speed, fewer math errors, reporting) and disadvantages (costs, training, data loss risks) applied to Karan. A basic conclusion is provided.
- **Level 3 (6–8 marks):** In-depth evaluation showing balanced understanding. Excellent application to a wholesaler context (handling numerous receivables/payables, inventory control). Clear, fully supported and justified recommendation.