Consolidation Associates
Consolidation Associates
Below are the income statements of Barbie Group and its associated companies, as at 31st December, 200
Barbie Ken Shelly
$1,000 $1,000 $1,000
Revenue 385 100 60
Cost of Sales 185 60 20
Gross Profit 200 40 40
Operating Expenses 50 15 10
Profit before Tax 150 25 30
Tax 50 12 10
Profit for the Year 100 13 20
Additional Information:
1. Barbie acquired 60,000 ordinary shares in Shelly for $80,000 when the company had a credit
2. Barbie acquired 45,000 ordinary shares in Ken, a number of years ago, for $70,000 when the r
3. During the year Shelly sold goods to Barbie for $28,000. Barbie still holds some of these good
4. Non controlling interests are valued using proportion of net assets method.
5. Goodwill and investment in associate were impaired for the first time during the year as follow
Shelly $2,000
Ken $3,000
Impairment of the subsidiary’s goodwill should be charged to operating expenses.
Required:
Prepare the consolidated income statement for Barbie including the results of its associated company.
SOLUTION
WORKINGS
W1) OWNERSHIP STRUCTURE
a) Barbie in Shelly
60000 x100
200000 30% Shelly is an Associate
b) Barbie in Ken
45000 x100
50000 90% Ken is a Subsidiary
W2) GOODWILL
a) Barbie in Ken
Purchase Consideration 70000
Net Assets
Ord shares 50000
RE (pre) 20000
Total Net Assets 70000
% of TNA=90% x 70000 63000
Goodwill 7000
Less: Impairment of GW 3000
Net Goodwill 4000
BABBIE GROUP
CONSOLIDATED INCOME STATEMENT FOR THE YEAR ENDED 31 DECEMBER 2008
RWF000
Revenue (385 +100) 485
Less: COS (185 +60) 245
G. Profit (P +S) 240
Less: O. Exp(50 + 15 + 3 impairm of Ken) 68
Operating Profit 172
Add: Share of Profits from Associates (W5) 3.4
Profit before Tax 175.4
Less: Tax (50 +12) 62
Profit 4 the year 113.4
Profit Attributable to :
Parent (Balancing Figure)(Profit 4 yr-NCI)(113.4-1) 112.4
Non Cont Interest (profit -Adj) x NCI% W3 1
Total Profit for the year 113.4
XYZ GROUP
CONSOLIDATED IS FOR THE YEAR ENDED XXX
at 31st December, 2008. Revenue (P+S)
COS (P+S)
G. Profit (P +S)
Less: O. Exp(P+S)
Operating Profit
Add: Share of Profits from Associates (Working)
Profit before Tax
Less: Tax (P+S)
Profit 4 the year
Profit Attributable to :
Parent (Balancing Figure)(Profit 4 yr-NCI)
Non Cont Interest (profit -Adj) x NCI%
Total Profit for the year
company had a credit balance on its retained earnings of $50,000 a number of years ago. Shelly has 200,000 $1 ordinary shares.
for $70,000 when the retained earnings were $20,000. Ken has 50,000 $1 ordinary shares.
lds some of these goods in inventory at the year end. The profit element included in these remaining goods is $2,000.
sociated company.
Shelly is an Associate
Ken is a Subsidiary
b) Barbie in Shelly
P. Consideration 80000
Ord Shares 200000
RE (Pre) 50000
TNA 250000
% of TNA 75000
GW 5000
Less: Impair 2000
Net Goodwill 3000 Goes to NCA in SOFP
1000
CEMBER 2008
THE YEAR ENDED XXX
xx WORKING
(xx) Profit from Associate
xx % of profit of the year xx
(xx) Less: % of Unreal Profit (xx)
xx Less: Impairment (xx)
ssociates (Working) xx Share of profit of associate xx
xx
(xx)
xx
ofit 4 yr-NCI) xx
j) x NCI% xx
xx
as 200,000 $1 ordinary shares.
ng goods is $2,000.
Example 1
P acquired 80% of S on 1st December, 2004 paying $4.25 in cash per share.
At this date the balance on S’s retained earnings were $870,000.
On 1st March 2007 P acquired 30% of A’s ordinary shares.
The consideration was settled by share exchange of 4 new shares in P for every 3 shares acquired in A.
the share price of P at the date of acquisition was $5.00.
P has not yet recorded the acquisition of A in its books.
The statement of financial position of the three companies as at 30th November, 2007 is as follows:
P
$1,000
Non Current Assets
Property 1300
Plant and Equipment 450
Investments 1825
Current Assets
Inventory 550
Receivables 300
Cash 120
Total Assets 4545
Current Liabilities
Trade Payables 520
Income Tax 330
Total Equity and Liabilities 4545
Additional Information
1. As at 1st December, 2004, plant in the books of S was determined to
have a fair value of $50,000 in excess of its carrying value. The plant had
a remaining life of 5 years at this time.
2. During the year, S sold goods to P for $400,000 at a mark-up of 25%.
P has a quarter of these goods still in inventory at the year end.
3. In September A sold goods to P for $150,000. These goods had cost
A $100,000. P had $90,000 (at cost to P) in inventory at the year end.
WORKINGS
W1) COST OF INVESTMENT (PURCHASE CONSIDERATION)
a) Cost of Investment in S
Immediate Cash = (4.25 x 500000shares)x 80%=
b) Cost of Investment in A
Share Exchange= {250000 x (4/3) x 5}x30%=
W6) GOODWILL in S
Purchase Consideration (W1a)
Net Assets
Share Capital 500,000
Share Premium 80,000
R Earnings (Pre Acq) 870,000
FVA (W2a) 50,000
Total Net assets 1,500,000
80% of 1500000=
Goodwill
Less: Impairment on Goodwill (30% of 500000)
Net Goodwill
W7) GOODWILL in A
Purchase Consideration (W1b)
Net Assets
Share Capital 250,000
Share premium
R Earnings (Pre)= 1200000-(9/12 x 600000)= 750,000
Total Net Assets 1,000,000
30% of 1000000
Goodwill
Less: Impairment of A
Net Goodwill
W8) CONSOLIDATED RETAINED EARNINGS
P
RE in SOFP 1,145,000
Less: Depreciation Undercharge ( W2b)
Less: Unreal profit on sale of Invent (w3)
Ajusted RE of S
Less: Pre Acq RE of S
Post Acq Retained Loss of S
Less: Share of Post Acq Loss = 80% x 520000 416,000
Less: Impairment of GW of S ( W6) 150,000
less: Impairm of GW of A 15,000
Add: Post Acq Profit of Assoc {(600,000 x9/12) x30%}- 9000( W4) 126,000
Consolidated RE 690,000
P GROUP
CONSOLIDATED SOFP AS AT 30 NOVEMBER 2007
NON CURRENT ASSETS FRW000
Property(1300 + 850)
Plant & Equipt (450+210+50(w2a) -30(w2b)
Investments (1825-1700 (w1a))
Goodwill of S (W6)
Investment in Associate (w10)
Total NCA
CURRENT ASSETS
Inventory (550+230-20 (w3) 760
Receivables (300+340 -50(w5) 590
Cash (120+50) 170
TOTAL ASSETS
EQUITY
Ord Shares ( 1800 +100 (w1c)
Share Premium (250 +400(w1c)
RE ( W8 )
CURRENT LIABILITIES
Payables (520 +330-50(w5) 800
Income Tax (330 +70) 400
TOTAL EQUITY AND LIABILITIES
FORMAT
XYZ GROUP
CONSOLIDATED SOFP AS AT XXX
NON CURRENT ASSETS
ry 3 shares acquired in A. Property (P+S +/- Adj related to Subsidiary)
Plant & Equipt (P + S +/-Adj related to Subsidiary)
Investments (Other Investments ) (not Invest in S or A)
Goodwill of S if Positive ( Don’t include GW of Assoc)
er, 2007 is as follows: Investment in Associate (Calculated)
S A Total NCA
$1,000 $1,000 CURRENT ASSETS
Inventory (P + S - Adj related to S)
850 900 Receivables (P + S - inter co balance btwn P& S onl
210 150 Cash (P +S- Cash in transit related to S)
- - TOTAL ASSETS
EQUITY
230 200 Ord Shares ( P + New shares in Parent)
340 400 Share Premium (P + New shares in Parent)
50 140 RE ( Workings)
1680 1790
Non Controlling Interest ( Working)
500 250
80 - NON CURRENT LIABILITIES
400 1200 Loan (P +S - Acquired Loan)
980 1450 Debenture (P + S)
500,000
100,000
400,000 500,000
Sales 400,000
COS ( Bal fig) 380,000
Margin Profit 20,000
Eliminated from both Receivable and Payables
Not Eliminated
1,700,000
1,200,000
500,000
150,000
350,000 Goes to NCA in SOFP
500,000
300,000
200,000
15,000
185,000
S
400,000
30,000
20,000
350,000 A: Goes to NCI
870,000
(520,000)
FRW000
2,150
680
125
350
611
3,916
1,520
5,436
1,900
650
690
3,240
196
800
1,200
5,436
to Subsidiary) xx
related to Subsidiary) xx
nts ) (not Invest in S or A) xx
on’t include GW of Assoc) xx
xx
xx
xx
balance btwn P& S onl xx Don’t deduct inter co balances related to Associate
xx xx
xx
xx
res in Parent) xx
xx
xx
xx
xx
xx xx
related to S) xx
xx
(% of P in S)) xx xx
ABILITIES xx
Example 2
H Ltd, a Public listed company acquired 80% of S Ltd ordinary shares on 1st January, 2006.
H Ltd paid $47 million for the acquisition when the retained earnings of S Ltd stood at $5 M.
As part of the acquisition H Ltd acquired $5 M of the 10% loan notes.
The summarized SOFP of the Two Companies at 31st December 2006 are shown below:
H Ltd S Ltd
$1,000 $1,000 $1,000 $1,000
Non Current Assets
PPE 44,500 52,200
Development 4,000 6,800
Investments - in S Ltd 47,000 -
- Others 24,500 4,000
120,000 63,000
Current Assets
Inventory 12,500 4,500
Accounts Receivables 32,000 4,000
Bank Balance 4,000 48,500 3,500 12,000
Total Assets 168,500 75,000
Required:
Prepare the Consolidated Balance Sheet for H Company.
SOLUTION
nuary, 2006. WORKINGS
tood at $5 M. W1) GOODWILL (Proportion of Net Assets)
FRW000 FRW000
Purchase Consideration (47,000-5,000) 42,000
Net Assets
Share Capital 22,000
Share Premium 10,000
Revaluation Reserve 8,000
Retained Earnings (Pre Acq) 5,000
Total Net Assets 45,000
80% of Net Assets (80% x 45000) 36,000
Goodwill (PC- NA80%) 6,000
Consolidated RE 22,000
H GROUP
STATEMENT OF FINANCIAL POSITION AS AT 31ST DECEMBER 2006
FRW000 FRW000
NON CURRENT ASSETS
PPE (44500 + 52200) 96,700
Development (4000+6800) 10,800
Investment - Other (24500 +4000) 28,500
Goodwill (W1) 6,000
Total NCA 142,000
CURRENT ASSETS
Inventory (12500+4500) 17,000
Receivables (32000 +4000) 36,000
Bank(4000+3500) 7,500 60,500
TOTAL ASSETS 202,500
CURRENT LIABILITIES
Payables (26000+9000) 35,000
Taxation (22500+4000) 26,500
Bank OD 2,000 63,500
B
Example 3
The following relates to H Ltd and its Subsidiary S at 31st December, 2006.
H LTD S LTD
NON CURENT ASSETS
Tangible PPE $ 150,000 $ 120,000
Investment in S Ltd $ 80,000 -
CURRENT ASSETS
Inventory $ 10,000 $ 12,000
Accounts Receivables $ 30,000 $ 26,000
Cash at Bank $ 13,000 $ 10,000
TOTAL ASSETS $ 283,000 $ 168,000
90%
H GROUP
CONSOLIDATED SOFP AS AT 31ST DECEMBER. 2006
FRW FRW
NON CURRENT ASSETS
PPE (150000+120000-8000(w2a)+3200 (w2b)) 265200
CURRENT ASSETS
Inventory (10000+12000-1000(w3) 21000
Receivables (30000+26000) 56000
Bank (13000+10000) 23000 100000
TOTAL ASSETS 365200
Current Liabilities
Payables (12000+18000) 30000
Proposed Dividends (6000 +1000{10000-9000}) 7000 37000
8000
CURRENT LIABILITIES
Bank Overdraft - 10000
Accounts Payable 80000 30000
Proposed Dividends 25000 20000
595000 270000
Additional Information
1) H acquired investment in S Ltd on 1st January 2004 as follows:
a) 60% ordinary shares 90000
b) Loan stock 10000
2) On date of acquisition the capital reserves of S Ltd amounted to $. 10000 and retained profits $. 500
On the same date the fair values of land and buildings were shs. 10000 and shs. 20000 respectively
above the carrying amounts, no depreciation is provided on land and buildings are charged depreciat
3) Included in the inventory of H Ltd are goods purchased from S Ltd.
They have a selling price of $. 15000. S reports a profit of 50% on cost.
4) Included in the plant of S Ltd is plant bought from H Ltd on 1st January, 2005 at a price of $. 20000
H Ltd reported a profit of a third on cost. The group provides depreciation on 30% on reducing balan
5) H Ltd has not accounted for its share of proposed dividends in S Ltd.
6) Included in accounts payable of H Ltd is an amount of $. 25000 due to S Ltd.
This amount stands at $. 28000 in the books of S Ltd.
7) Goodwill has been impaired by 60%
Required:
Prepare the Consolidated SOFP of H Ltd as at 31st December, 2006.
mber, 2006. H GROUP
CSOFP AS AT 31 DEC 2006
NCA
Land (100000+50000+10000(W2a)= 160,000
Buidling (150000+80000+20000(w2a) -3000(w2b))= 247,000
Plant (80000+50000-5000(w4a)+2550(w4b)= 127,550
Goodwill (W7) 1,200
Total NCA 535,750
Current Assets
Inventory (60000+40000-5000(w3) 95,000
Receivables (80000+50000-28000(w6) 102,000
Cash at Bank (25000+0) 25000 222,000
TOTAL ASSETS 757,750
EQUITY
Ord Share Capital 200000
Capital Reserves (W1) 118,000
Retained Earnings (W8) 118,930
Non Controlling Interest (W9) 85,820
Total Equity ( Including NCI) 522750
NON CURRENT LIABILITIES
10% Loan Notes (100000+20000-10000(Loan acq)) 110000
CURRENT LIABILITIES
Bank OD (10000-3000(w6) 7,000
Acc Payable (80000+30000-25000(w6) 85,000
Proposed Dividends (25000+20000-12000(w5)) 33,000 125,000
TOTAL EQUITY & LIABILITIES 757,750
0% on cost.
b) Depreciation Overcharge
Deprec 1st Year (Jan - Dec 2005) 5000x 30%= 1,500
Deprec 2nd Year (Jan - Dec 2006) (5000-1500)x30%= 1,050
Total Depreciation Overcharge 2,550 Add to Profit of S Ltd
W7) GOODWILL
H GROUP
CONSOLIDATED SOFP AS AT 31ST DEC 2006
s in Goodwill, NCI
25%
Add to Profit of S Ltd
Double Entry
Dr. Cost of Control 50,000,000
Cr. Ordinary Share Capital 16,000,000
Cr. Share Premium 16,000,000
Cr. Deferred Consideration 18,000,000
Is Divided into two: Ordinary share capital and Share premium
16,000,000
16,000,000
ed Earnings
Current Liabilities
Example 6
Statement of Financial Position of P and S as at 30th June 20X8 are given below:
P LTD S LTD
$ $
Property Plant and Equipmen 15000 9500
Investment in S Ltd 5000
Additional Information
1. P acquired 60% of S on 1st July 20X7 when the retained earnings of S were $5800.
P paid $5000 in cash. P also issued 2 $1 shares for every 5 acquired in S and
agreed to pay a further $2000 in 3 years time.
The market value of P’s shares at 1st July 20X7 was $1.8.
P has only recorded the cash paid in respect of the investment in S. Current Interest ra
2. The P Group uses the fair value method to value Non Controlling Interests.
At the date of acquisition, the fair value of NCI was $5750.
Required:
Prepare the consolidated Statement of Financial Position of P Group as at 30 June 20X8.
SOLUTION
8 are given below: WORKINGS
W1) COST OF INVESTEMENT (Purchase Consid
a) Immediate Cash
b) New Shares
Ordinary Share Capital = (1/1.8) x 2160=
P GROUP
CONSOLIDATED SOFP AS AT 30 JUNE 20X8
Equity
Ord Share Capital (6000 +1200{w1b})
Share Premium (4000+960{w1b})
Retained Earnings (W3)
Total Equity
Non Controlling Interest (W4)
8,839
8 x 2160= 960
2,160
lue Method)
8,839
5,750
14,589
5,000
5,800
10,800 10,800
3,789
TAINED EARNINGS
P LTD S LTD
12,500 7,200
5,800
1,400
840
101
13,239
AS AT 30 JUNE 20X8
24,500
3,789
28,289
12,500
40,789
200{w1b}) 7,200
4,960
13,239
25,399
6,310
00+500+1780{W1c} 3,280
5,800
IABILITIES 40,789
Example 1
P Co acquired 75% of the ordinary shares of S Co on that company’s incorporation in 20X3.
The summarized income statement of the two companies for the year ending 31st December,
20X6 is set out below:
P Co S Co
$ $
Revenue 75,000 38,000
Cost of Sales 30,000 20,000
Gross Profit 45,000 18,000
Administration Expenses 14,000 8,000
Profit before Taxation 31,000 10,000
Income Taxes 10,000 2,000
Profit for the year 21,000 8,000
Additional Information
1. The issued share capital of the group was as follows.
Wheeler Co: 5000000 ordinary shares of $1 each.
Brookes Co: 100000 ordinary shares of $1 each.
2. Wheeler Co purchased 80% of the issued share capital of Brookes Co in 20X0.
At that time, the retained earnings of Brookes amounted to $56000.
SOLUTION
WHEELER GROUP
CONSOLIDATED INCOME STATEMENT FOR THE YEAR ENDED 30TH APRIL 20X7
$Thousands
Revenue (1100+500) 1600
Cost of Sales (630+300) 930
Gross Profit 670
Administration Expenses (105+150) 255
Profit before Tax 415
Income Tax (65+10) 75
Profit for the year 340
Movement on R/Earnings
R/E brought forward (460 + {106-56}x80%) 500
Profit for the year 332
R/E Carried Forward 832
0TH APRIL 20X7
Example 1
P Co acquired 75% of the ordinary shares of S Co on that company’s incorporation in 20X3.
The summarized income statement of the two companies for the year ending 31st December,
20X6 is set out below:
P Co S Co
$ $
Revenue 75,000 38,000
Cost of Sales 30,000 20,000
Gross Profit 45,000 18,000
Administration Expenses 14,000 8,000
Profit before Taxation 31,000 10,000
Income Taxes 10,000 2,000
Profit for the year 21,000 8,000
Example 3
Suppose in our earlier example (Example 1) that S Co has recorded sales of $5000 at
a gross margin of 40% to P Co during 20X1.
50% of the goods remained in P Co’s inventories at 30th December, 20X1.
Required:
Prepare a revised consolidated income statement.
SOLUTION
poration in 20X3. Workings
g 31st December, Unsold Goods = 50%
Margin (Profit on Sales)= 40% x 5000= 2000
Unrealised profit on unsold Good = 50% x 2000=
P GROUP
CONSOLIDATED INCOME STATEMENT FOR THE YEAR ENDED 31ST DECEMBER 2
Movement on R/E
R/E Brought Froward (87000+{17000x75%}) 99750
Profit for the year 26,250
R/E Carried Forward 126,000
1000
Required:
Prepare the consolidated income statement and movements on retained earnings.
SOLUTION
P GROUP
CONSOLIDATED INCOME STATEMENT FOR THE YEAR ENDED 31ST DECEMBER 20X5
Profit Attributable to
Parent 49,800
NCI (40% x18,000) 7,200
Total Profit for the year 57,000
Movement on RE
R/E Brought Forward 81,000
Profit for the year 49,800
R/E Carried Forward 130,800
31ST DECEMBER 20X5