Tutorial Solutions

Download as pdf or txt
Download as pdf or txt
You are on page 1of 31
At a glance
Powered by AI
The document provides examples of consolidated financial statements and reconciliations, including minority interest, goodwill, and constructing consolidated balance sheets.

Minority interest is reconciled by showing the shares held by minority shareholders and their share of post-acquisition and pre-acquisition retained earnings.

Goodwill is calculated as the excess of consideration over the fair value of identifiable net assets acquired. It shows examples of calculating goodwill using the full and partial goodwill methods.

Tutorial 1

Question 6

(a) Balance sheet as at 30 June 20X2

Property 43,400

Plant and equipment 12,320

Current assets

Inventory 51,324

Trade receivables 22,829

Cash 63,500

137,713

Current liabilities

Trade payables 63,700

Income tax 6,440

70,140

Net current assets 67,573

123.293

Share capital 56,000

Retained earnings 67,293

123.293

Reserves at date of acquisition

Investment 151,200

Less shares 50,400

Goodwill 100,800

85,680

Reserves 15.120

Step 1: Calculate the retained earnings balance

Consolidated balance 79,884


Less Parent 35,280

44,604

Add profit on stock (4,200 – 3,360) 840

45,444

Add Minority interest (10% of 50,493 or 1/9 of 45,444)) 5,049

Add Pre-acquisition

Parent (90% o £16,800) 15,120

Minority (10% of 16,800) subsidiary retained earnings 1,680

67,293

Step 2: Reconcile the minority interest

Shares 5,600

Retained earnings post-acquisition 5,049

Retained earnings pre-acquisition 1,680

12,329

Worksheet

Non-current assets

Group Parent Subsidiary Adjustment Subsidiary

Property 127,400 84,000 43,400 43,400


Plant 62,720 50,400 12,320 12,320

Current assets
Inventory 121,604 71,120 50,484 840 51,324
Receivables 70,429 51,800 18,629 4,200 22,829
Cash 24,360 24,360 39,200 63,560

Current liabilities
Payables 140,420 80,920 59,500 4,200 63,700
Income tax 27,160 20,720 6,440 6,440
Question 9 – Berlin plc

Berlin plc
Balance sheet as at 1 January 20X0
(a) (b)

Cash acquisition Share exchange

ASSETS £000 £000

Non-current assets
Property, plant and equipment 250 250
Investment in Hanover 100 100

Current assets 50 150

400 500

Share capital 200 250


Share premium – 50

Retained earnings 80 80

Share capital and reserves 280 380

Current liabilities 120 120

400 500
Question 10 – Bleu plc

Bleu plc

Balance sheet as at January 20X0

ASSETS £ Million

Non-current assets
Property, plant and equipment [150 + 120] 270
Goodwill [210 – (80%  180) ] 66
Current assets [108 + 105] 213
549
Share capital 300

Retained earnings 78
Share capital and reserves 378
Minority interest [20%  180] 36
Current liabilities [90 + 45] 135
549
Question 11 – Base plc

Base plc

Balance sheet as at January 20X0

ASSETS £000
Non-current assets
Property, plant and equipment [250 + 120] 370
Goodwill [90 – (60%  110) + (60%  20)] 12
Current assets [100 + 70] 170
Total assets 552

Common £5 shares 200


Retained earnings 160
Share capital and reserves 360
Minority interest [(40%  110) + (40%  20)] 52
Current liabilities [80 + 60] 140
Total equity and liabilities 552
Tutorial 2
Question 2 – Summer plc

Summer plc

Balance sheet as at 31 December 20X1


ASSETS £000

Non-current assets
Property, plant and equipment [200 + 200] 400

Goodwill [141 – 60% (20 + 35 + 160) – 1] 11

Current assets [100 + 140] 240

651

Equity shares 200


Retained earnings [161 + 60% (40 – 35) – 1] 163

Share capital and reserves 363

Minority interest [40% × 220] 88

Current liabilities [80 + 120] 200

651
Question 3 – Gold plc

Gold plc
Balance sheet as at 31 December 20X1

ASSETS £

Non-current assets

Property, plant and equipment (including land) [82,300 + 108,550 + 3,000] 193,850

Goodwill (Note 1) 1,240


Current assets
Inventories [23,200 +10,000 – 300] 32,900
Other current assets [5,000 + 7,500] 12,500

Total assets 240,490

Equity shares
Preferred shares 10,000

Retained earnings

[(75,000 + 75% (21,200 – 16,000)) – 300 – 310)] 78,290

Share capital and reserves 148,290


Minority interest (Note 2) 26,950
Non-current liabilities [12,500 +14,000] 26,500

Current liabilities
Bond interest payable [625 + 700] 1,325
Other current liabilities [18,550 + 18,875] 37,425 38,750
240,490
Note 1: Goodwill
£ £
Investment in Silver 46,000
Acquired 75% × 27,600 20, 700
30% × 20,000 6,000
20% × 17,500 3,500
30,200
75% × 3,000 2,250
75% × 16,000 12,000 44,450
Goodwill 1,550
Impairment @ 20% = £310
Goodwill at 31.12.20X1 = £1,550 – 310 = £1,240
Note 2: Minority interest
£
25% × 24,000 6,000

70% × 20,000 14,000

25% × 3,600 900


25% × 3,000 750

25% × 21,200 5,300

26,950
Tutorial 3
Question 3 – River plc

River A/S

Consolidated income statement for the year ended 31 December 20X1


£
Sales [100,000 + [(9/12 × 60,000)] 145,000
Cost of sales [30,000 +[(9/12 × 30,000]) 52,500

Gross profit 92,500


Expenses [20,541 + (9/12 × 15,000)] 31,791

Interest payable on 5% bonds [9/12 × (5,000 – 500)] 3,375

Impairment of goodwill 4,000

Profit before taxation 53,334

Taxation [7,002 + (9/12 × 3,000)] 9,252

Profit after taxation 44,082


Attributable to:
Equity shareholders of bill 43,557

Minority interest [10% × 7,000 × 9/12] 525

44,082
Question 4 – Mars plc

Balance sheet as at 31 December 20X2

Assets
£ £

Non-current assets [330,000 + 157,500] 487,500


Goodwill 37,100

Current assets
Inventories [(225,000 + 67,500) – 3,000] 289,500

Trade receivables [180,000 + 90,000] 270,000

Bank [36,000 + 18,000] 54,000 613,500

Total assets 1,138,100

Equity and liabilities


Capital and reserves
Issued capital 196,000

General reserve [245,000 + 10,800] 255,800

Retained earnings [222,000 + 44,000] 266,000


717,800

Minority interest 51,300

Current liabilities
Trade payables [283,500 + 40,500] 324,000

Taxation [31,500 + 13,500] 45,000

369,000

1,138,100
Consolidated income statement for the year ending 31 December 20X2
W1: Cancel inter-company balances
 Current accounts of £22,500
£
Sales [1,440,000 + 270,000 – 18,000] 1,692,000

Cost of sales [1,045,000 + 135,000 – 18,000 + 3,000] 1,165,000

Gross profit 527,000

Expenses [123,500 + 90,000] 213,500

Profit before tax 313,500

Taxation [31,500 + 13,500] 45,000

Profit after tax 268,500

Attributable to:

Equity shareholders in Mars 262,200

Minority interest [20% × £31,500] 6,300

268,500
W2: Goodwill

£ £
Investment in Jupiter 187,500
£1 Ordinary shares [80% × 90,000] 72,000
Accumulated profits [80% × 80,000] 64,000

General reserve [80% × 18,000] 14,400

150,400

Goodwill 37,100

W3: Unrealised profit on inter-company sales


50/150 × 18,000 = 6,000.

Only half the stock is unsold at the year end, so 6,000/2 is the provision required against the closing
stock figure.
Extracts from the consolidated statement of changes in equity for the year ended 31
December 20X2

Mars group Minority Total


£ £ £

Opening balance (Note) 183,800 22,950 206,750

Profit for the period (from the

consolidated income statement) 262,200 6,300 268,500

Dividends paid (180,000) (2,250) (182,250)

Closing balance 266,000 27,000 293,000

Note Opening balance for the Mars group

Ante’s retained earnings at the start of the year 156,000

The group share of Jupiter’s retained earnings

since acquisition (80% × (114,750 – 80,000)) 27,800

183,800
W4: The income statement of Jupiter
£ £
Balance at 31/12/20X2 as per the balance sheet 135,000

Pre-acquisition profit held by Mars 64,000

Minority interest [20% × 135,000] 27,000 91,000

44,000

W5: The income statement of Mars


£
Balance at 31/12/20X2 as per the balance sheet 225,000

Less: Provision for unrealised profit 3,000

222,000

W6: The minority interest


£
20% × 90,000 Shares 18,000

20% × 31,500 General reserve 6,300

20% × 135,000 27,000

51,300

W7: Jupiter general reserve


£
Balance at 31/12/20X2 as per balance sheet 31,500

Less:

Mars share of pre-acquisition 80% × 18,000 = (14,400)


Minority interest 20% × 31,500 (6,300)

10,800
Tutorial 4
Question 1 – Swish Ltd

Consolidated Income Statement


for the year ended 31 Dec 20X3

Swish &
Subsidiary Handle Group
£ £ £
Sales 444,000 (N1) 100,000 444,000
-
(N2)
Cost of Sales -157,200 -40,000 157,200
Gross Profit 286,800 60,000 286,800
-
Expenses -145,000 -40,000 145,000
Profit from operations 141,800 20,000 141,800
Dividends received 2,000 (N3) 10,000 -
Share of associates profit - - 5,500 (N4)
Profit before tax 143,800 30,000 147,300
Income tax expenses -37,000 -8,000 -37,000
Profit for the period 106,800 22,000 110,300

Consolidated Balance Sheet


as at 31 December 20X3

Swish &
Subsidiary Handle Group
ASSETS £ £ £
Non-current Assets
Property, Plant & Equipment 230,000 79,000 230,000
Goodwill on consolidation 17,600 (N5) - 17,600
Investment in Handle 40,000 - 46,000 (N10)

Current assets
Inventories 176,800 (N6) 36,000 176,800
Trade Receivables 200,000 36,000 200,000
Current Account - Handle 3,000 - 3,000
Bank 31,000 6,000 31,000
Total Assets 698,400 157,000 704,400

EQUITY & LIABILITIES


Capital & Reserves
£1 Common Shares 250,000 50,000 250,000
General Reserves 33,600 (N8) 12,000 34,600 (N11)
Retained Earnings 200,800 (N7) 50,000 205,800 (N12)
Minority Interest 20,000 (N9) - 20,000

Current Liabilities
Trade Payable 157,000 34,000 157,000
Taxation 37,000 8,000 37,000
Current Account - Swish - 3,000 -
Total Equity and Liabilities 698,400 157,000 704,400

Note 1: Calculation of Sales

Sales = 300,000 + 160,000 + 16,000


= 444,000

Note 2: Calculation of Cost of Sales

COS = 90,000 + 80,000 - 16,000 + 3,200


= 157,200

Note 3: Calculation of Dividends received

Dividends Received = 11,000 - (10,000 x 90%)


= 11,000 - 9,000
= 2,000

Note 4: Calculation of Share of associates profits

Share of associates profits = 22,000 x 25%


= 5,500

Note 5: Calculation of Goodwill


£ £
Investment in Broom 140,000
Value acquires:
Shares
90% x 60,000 54,000
Pre-acquisition General Reserves
90% x 16,000 14,400
Pre-acquisition Retained Earnings
90% x 60,000 54,000 122,400
17,600

Note 6: Calculation of Inventory


£
Swish 120,000
Broom 60,000
180,000
Less: Unrealised Profit -3,200
176,800

Note 7: Calculation of Retained Earnings


£
Swish 150,000
Broom: Post-acquisition
90% (120,000 - 60,000) 54,000
204,000
Less: Unrealised Profit -3,200
200,800

Note 8: Calculation of General Reserves


£
Swish 30,000
Broom: Post-acquisition
90% (120,000 - 16,000) 3,600
33,600

Note 9: Calculation of Minority Interest

Broom: £
Shares (10% x 60,000) 6,000
General Reserves (10% x 20,000) 2,000
Retained Earnings (10% x 120,000) 12,000
20,000

Note 10: Calculation of Investment in associates


£
Initial cost of 25% holding 40,000
Share of Post-acquisition reserve of Handle:
Retained Earnings [25% x (50,000-
30,000)] 5,000
General Reserves [25% x (12,000-8,000)] 1,000
46,000

Note 11: Calculation of General Reserves (Group + Associates)


£
Parent's General Reserves 33,600
Handle: Post-acquisition
25% (12,000 - 8,000) 1,000
34,600

Note 12: Calculation of Retained Earnings (Group + Associates)


£
Parent's Retained Earnings 200,800
Handle: Post-acquisition
25% (50,000 - 30,000) 5,000
205,800
Question 2 – Ant Co

Consolidated Income Statement


for the year ended 31 Dec 20X9

Ant &
Subsidiary Nit Group
£ £ £
Sales 333,000 (N1) 75,000 333,000
-
(N2)
Cost of Sales -118,200 -30,000 118,200
Gross Profit 214,800 45,000 214,800
-
Expenses -108,000 -30,000 108,000
Profit from operations 106,800 15,000 106,800
Dividends received 1,500 (N3) 7,500 -
Share of associates profit - - 4,125 (N4)
Profit before tax 108,300 22,500 110,925
Income tax expenses -27,750 -6,000 -27,750
Profit for the period 80,550 16,500 83,175

Consolidated Balance Sheet


as at 31 December 20X9

Ant &
Subsidiary Nit Group
ASSETS £ £ £
Non-current Assets
Property, Plant & Equipment 172,500 59,250 172,500
Goodwill on consolidation 8,400 (N5) - 8,400
Investment in Nit 30,000 - 34,500 (N10)

Current assets
Inventories 147,300 (N6) 27,000 147,300
Trade Receivables 150,750 27,000 150,750
Current Account - Nit 2,250 - 2,250
Bank 22,500 4,500 22,500
Total Assets 533,700 117,750 538,200

EQUITY & LIABILITIES


Capital & Reserves
£1 Common Shares 187,500 37,500 187,500
General Reserves 24,900 (N8) 9,000 25,650 (N11)
Retained Earnings 145,800 (N7) 37,500 149,550 (N12)
Minority Interest 30,000 (N9) - 30,000

Current Liabilities
Trade Payable 117,750 25,500 117,750
Taxation 27,750 6,000 27,750
Current Account - Ant - 2,250 -
Total Equity and Liabilities 533,700 117,750 538,200

Note 1: Calculation of Sales

Sales = 225,000 + 120,000 - 12,000


= 333,000

Note 2: Calculation of Cost of Sales

COS = 67,500 + 60,000 - 12,000 + 2,700


= 118,200

Note 3: Calculation of Dividends received

Dividends Received = 7,500 - (7,500 x 80%)


= 1,500

Note 4: Calculation of Share of associates profits

Share of associates profits = 16,500 x 25%


= 4,125

Note 5: Calculation of Goodwill


£ £
Investment in Bug 90,000
Value acquires:
Shares
80% x 45,000 36,000
Pre-acquisition General Reserves
80% x 12,000 9,600
Pre-acquisition Retained Earnings
80% x 45,000 36,000 81,600
8,400

Note 6: Calculation of Inventory


£
Ant 105,000
Bug 45,000
150,000
Less: Unrealised Profit -2,700
147,300

Note 7: Calculation of Retained Earnings


£
Ant 112,500
Bug: Post-acquisition
80% (90,000 - 45,000) 36,000
148,500
Less: Unrealised Profit -2,700
145,800

Note 8: Calculation of General Reserves


£
Ant 22,500
Bug: Post-acquisition
80% (15,000 - 12,000) 2,400
24,900

Note 9: Calculation of Minority Interest

Bug: £
Shares (20% x 45,000) 9,000
General Reserves (20% x 15,000) 3,000
Retained Earnings (20% x 90,000) 18,000
30,000

Note 10: Calculation of Investment in associates


£
Initial cost of 25% holding 30,000
Share of Post-acquisition reserve of Nit:
Retained Earnings [25% x (37,500-
22,500)] 3,750
General Reserves [25% x (9,000-6,000)] 750
34,500

Note 11: Calculation of General Reserves (Group + Associates)


£
Parent's General Reserves 24,900
Nit's General Reserve: Post-acquisition
25% (9,000 - 6,000) 750
25,650
Note 12: Calculation of Retained Earnings (Group + Associates)
£
Parent's Retained Earnings 145,800
Nit's Retained Earnings: Post-acquisition
25% (37,500 - 22,500) 3,750
149,550
Tutorial 5
Question 6 – Delta NV

(a) Calculate theoretical ex-rights value of a share

Market value of a share prior to rights issue was €1.10.

4 shares at €1.10 per share = 4.40


1 share at 60p = .60

5 shares = 5.00
Theoretical ex-rights value = 1.00

(b) Bonus issue factor =110/100

(c) BEPS 20X8

440,000/(4,000,000 × 11/10) = €0.10


previously calculated as:

440,000/4,000,000 = €0.11

(d) BEPS 20X9

Uplift shares prior to issue by 110/100

4,000,000 × (110/100) × 6/12 months = 2,200,000


Weight shares after issue:

5,000,000 × 6/12 months = 2,500,000

Total shares for BEPS calculation = 4,700,000

BEPS = €500,000/4,700,000 = €0.106


Question 7 – X Ltd

(a)

Ordinary

shares Profit EPS Effect

Net profit after tax 18,160

Less preference dividend (160)

40,000 18,000 45p

Options (W1) 400

40,400 18,000 44.6p dilutive

Convertible preference

shares 3,200 160

43,600 18,160 41.7p dilutive

Convertible loan stock

Interest [6% × £20m × 0 .67] 804

Discount 200

Shares converted

[(20m/200) × 23] 2,300 _____

45,900 19,164 41.8p anti-dilutive

 Since the loan stock is anti-dilutive, it is ignored in the calculation of diluted EPS.
 Diluted EPS will be reported as 41.7p.

W1

Fair value of one ordinary share £1.50

Number of options 2,000,000

Exercise price £1.20

Proceeds from exercise of options £2,400,000

Number of shares assumed to be issued at fair value 1,600,000

Number of shares issued for no consideration (2m – 1.6m)

= 400,000

(b)
 An option is treated as if
– there was an issue of shares for full market value/fair value; and
– an issue for no consideration (a bonus issue).
– the bonus element is treated as being the dilutive effect.
 IAS 33 is saying that by issuing options to directors/employees the company is making a
bonus issue of shares plus a full issue of shares, the latter being assumed not to have a
dilutive effect.
 Only potential ordinary shares that would dilute EPS should be taken into account and
any anti-dilutive potential ordinary shares will be ignored.
 This procedure essentially means that certain categories of potential
 ordinary shares will not be used in the calculation.
 Thus, the calculation will be based on the concept of prudence rather than on the
substance of what is realistically going to occur. All items of income or expense that
would cease on conversion are to be added back.
 Prudent disclosure.
As regards the ranking of potential ordinary shares from most to least dilutive and the
subsequent calculations, an alternative solution would be to disclose both the fully diluted
EPS and the maximum dilution of EPS. This would essentially mean that the more realistic
calculation and the prudent calculation of IAS 33 would be disclosed.
Tutorial 6
Question 1 – Saddam Ltd

(a) Profitability – ROCE

 Camel Ltd is the most profitable of the three companies.


 An inspection of the secondary ratios shows that this is due to efficient utilisation of assets since
its net profit ratio is well below that of the other two companies.
 Examination of gross profit percentages confirms the observation that Camel Ltd seems a high
volume, low margin business compared with the others.

Liquidity

 Ali Ltd has a current ratio which is out of line with the other two, being very much higher
suggesting surplus investment in working capital.
 The acid test ratio reinforces this view and also indicates that Baba Ltd appears to have a
liquidity problem with current liabilities considerably greater than cash and debtors (despite
having the greatest number of weeks’ debtors outstanding of the three companies).
 Baba Ltd also has considerably more weeks of stock outstanding than the other two companies
which may be linked with the high level of creditors.
 Ali Ltd also has stock levels well in excess of Camel Ltd explaining, in part at least, the high
current ratio.

Dividends

Camel Ltd is paying out a higher proportion of profits in dividends, which may have the effect of
raising shareholder loyalty and the bid price.

Conclusion

 Baba Ltd appears to have considerable liquidity problems arising out of excess investment in
stock.
 Camel Ltd is a lean enterprise able to survive on a lower gross profit margin because of superior
asset utilisation. Why is the gross profit margin low?
Before a final decision is made the absolute figures in the financial statements should be studied and
questions raised such as the following:

 Are the activities of the firms really the same?


 What are the relative turnovers?
 What is the growth over a period of years?
 What are the trends of all the ratios?
 How old are the assets?
 Are asset ages distorting ROCE comparisons between the companies?
Also need to assess managerial skills, product potential etc. which are not shown in the financial
statements.

(b) Why balance sheet is unlikely to show the true market value of the
business

The accounting policy is to state fixed assets at cost less depreciation or at historical cost (HC)
modified by revaluation of all or selected classes of fixed assets.
The true market value of a listed company is available from the market capitalisation figure based on
current share prices.

The true market value of an unquoted company is not readily available and would require the future
cash flows to be evaluated.
Question 2 – Esrever Ltd

Forecast profit and loss account for year ended 30 June 20X1

£ £

Turnover [87,007 × 100/32] (S3) 271,897

Opening stock 22,040

Purchases (S5) 194,205

216,245

Closing stock [184,890 × 61.9/365] (S5) 31,355

Cost of sales [271,897 × 68%] (S4) 184,890

Gross profit [20,290 × 100/23.32] (S2) 87,007

Depreciation
– buildings [132,000 × 2%] (S6) 2,640

– fixtures etc. [96,750 × 20%] (S6) 19,350

Loan interest [50,000 × 12%] (S7) 6,000

Credit expenses (balancing figure) (S8) 33,655

61,645

Profit before tax 25,362

Corporation tax [20,290 × 20/80] (S9) 5,072

Profit after tax [181,808 × 11.16%] (S1) 20,290


Dividends [200,000 × 2.5p] (S10) 5,000

Profit retained (S11) 15,290

Profit retained b/f (S12) 66,518

Retained profit c/f (S13) 81,808

Forecast balance sheet as at 30 June 20X1

£ £
Fixed assets (NBV)

Land and buildings [132,000 – 2,640] 129,360

Fixtures, fittings [96,750 – 19,350] 77,400

(S14) 206,760

Current assets
Stock (S15) 31,355

Debtors [(271,897 × 42.6/365) × 1.15] (S16) 36,494

67,849
Creditors: amounts falling due in less than one year
Bank overdraft (a balance figure based on Note 2) (S20) 9,756

Creditors [(194,205 + 33,655) × (29.7/365) × 115%] (S17) 21,321

Other creditors [5,072 tax + 5,000 dividends

+ 1,652 VAT] (S18, S19) 11,724

42,801

Net current assets 25,048

Total assets less current liabilities (per Note 3) 231,808

Creditors: amounts falling due in more than one year

12% loan (S23) 50,000

181,808

Ordinary shares (S21) 100,000


Profit and loss account (balancing figure) (S22) 81,808

181,808

VAT: Output tax [271,897 × 15%] 40,785


Input tax [(194,205 + 33,655) × 15%] 34,179

Net amount for year 6,606

6,606 × 0.25 1,652

Approach to Esrever profit and loss account

(S1) Start with post-tax profit, i.e. 11.16% of (231,808 – 50,000) per Notes 3 and 4
= £20,290

(S2) From post-tax profit 20,290 derive gross profit as

100/23.32 × 20,292 based on Note 4 = £87,007


(S3) Next, derive turnover as 100/32 × 87,007 based on Note 6

Cost of goods sold = 68% of turnover

Therefore, turnover = 100/32 × gross profit = £271,897

(S4) From sales and gross profit derive cost of goods sold as

271,897 – 87,007 = £184,890

(S5) You can now find components of cost of sales (£184,890) as

£
(a) Opening stock 22,040 (given in question)

(b) Purchases 194,205 (balance figure)

216,245

(c) Closing stock (31,355) (61.9 × 184,890)

365

Total costs of goods sold 184,890

Note: Start with closing stock 61.9 days based on Note 7; all other figures are derived and the
opening stock is given as £22,040.

(S6) Depreciation: 2% × 132,000 for buildings = £2,640


20% × 96,750 for fixtures etc. = £19,350
based on Note 1 and opening asset given

(S7) Loan interest is 12% of 50,000 = 6,000

(S8) Expenses – this is a balancing figure as we already have all the other figures in the profit and
loss account = 33,655

(S9) Taxation charge is 20/80 × 20,290 based on Note 5 = 5,072

(S10) Dividend – see Note 9 (200,000 × 2.5p) = 5,000

(S11) Retained profit = 15,290

(S12) Retained profit b/f is a balancing figure = 66,518


(S13) Retained profit c/d (see S22 below) = 81,808

Approach to Esrever balance sheet

Projected balance sheet as at 30/6/20X1 is built up as follows:

(S14) Fixed assets are derived from the opening figure


less depreciation = 206,760

(S15) Stock has already been computed at = 31,355

(S16) Debtors, based on Note 10, assuming 42.6 days’

credit, are 42.6/365 × 271,897 = 31,734 × 1.15

to cover VAT = 36,494

(S17) Creditors, assuming credit of 29.7 days, are


29.7/365 × 227,860 × 1.15 = (21,321)
(S18) Other creditors (dividends 5,000 + tax 5,072) = (10,072)

(S19) VAT 15% net of sales – purchases and expenses is

15% (271,897 – 194,205 – 33,655) × 0.25 = (1,652)

(11,724)

(S20) Overdraft is balancing figure based on Note 2 = (9,756)

Current liabilities 42,801

Total assets less current liabilities per Note 3 231,808

(S21) Share capital given in question 100,000

(S22) Retained profit (balancing figure) 81,808


(S23) 12% loan 50,000

231,808

Note: Retained profit is the balancing figure to make up £231,808.

The bank overdraft of £9,756 is the overall balance sheet balancing figure.

You might also like