Xever provided the following information for the year ended 31 March 2015. $ Capital 40000 Bank loan (repayable 1 Jan 2020) 10000 Inventory 1 April 2014 15000 Inventory 31 March 2015 35000 Cost of sales 125000 Trade receivables 25000 Trade payables 70000 Bank overdraft 30000 Mark up 20% Profit margin (profit for the year to revenue) 5% REQUIRED
- (a)(i)Calculate the following for the year ended 31 March 2015. Revenue[2]
- (a)(ii)Purchases[2]
- (a)(iii)Expenses for the year[2]
- (b)Calculate the following ratios, correct to two decimal places. The previous year's ratios are shown in the last column. Gross profit margin (gross profit to revenue) Return on capital employed (ROCE) Rate of turnover of inventory Quick ratio (acid test ratio) Workings 31 March 2015 31 March 2014 25.61% 12.00% 2.82 times 0.91:1[8]
- (c)(i)Comment on the changes to Xever's business over the two years under the following headings. Profitability[3]
- (c)(ii)Liquidity[3]
Mark scheme
Marking points from the official mark scheme (May/June 2015). The mark or mark type is shown in brackets.
- [2] (a)(i) Revenue: 125000 × 120/100 = 150000 (1)
- [2] (a)(ii) Purchases: 125000 + 35000 (1) – 15000 = 145000 (1)
- [2] (a)(iii) Expenses: Gross profit 25000 – (150000 of × 5/100) (1) = 17500 (1)of
- [8] (b) Gross profit margin: 25000 / 150000 (1)of × 100 = 16.67% (1)of
- [8] (b) Return on capital employed (ROCE): 7500 / (40000 + 10000) (1) = 15.00% (1)of
- [8] (b) Rate of turnover of inventory: 125000 / ((15000 + 35000)/2) (1) = 5.00 times (1)of
- [8] (b) Quick ratio (acid test ratio): 25000 / (70000 + 30000) (1) = 0.25:1 (1)of
- [3] (c)(i) Own figures applied where appropriate
- [3] (c)(i) Gross profit percentage has decreased (1)
- [3] (c)(i) ROCE has increased (1)
- [3] (c)(i) Selling prices may have been cut to increase sales (1)
- [3] (c)(i) Expenses have been controlled or reduced (1)
- [3] (c)(i) Max (1) × 3
- [3] (c)(ii) Own figures applied where appropriate
- [3] (c)(ii) Quick ratio has deteriorated to a dangerous level (1)
- [3] (c)(ii) Inventory levels increased substantially in the year (1)
- [3] (c)(ii) Bank overdraft so no cash to pay trade payables (1)
- [3] (c)(ii) Possible overtrading (1)
- [3] (c)(ii) Risk of bankruptcy because trade payables cannot be paid (1)
- [3] (c)(ii) Max (1) × 3
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →