ACCOUNTING ANALYSIS

Accounting Analysis

Accounting Analysis

CONSOLIDATED WORKSHEET



 

 

 

 

Eliminations/Adjustments

 

Account

H Ltd

D Ltd

S Ltd

 

Debit (000)

Credit (000)

 

 

Income Statement

 

 

 

 

 

 

 

 

Sales revenue

30,000,000

16,000,000

14,000,000

 

53,110

 

 

 

Cost of goods sold

24,400,000

13,040,000

11,600,000

 

 

43,298

 

 

 

 

 

 

 

 

 

 

 

Gross Profit

5,600,000

2,960,000

2,400,000

 

9,813

 

 

618-50

Dividend revenue

618,000

0

0

 

 

568

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Gain on sale of property

80,000

 

 

 

 

80

 

 

Other revenue

600,000

 

 

 

 

600

 

 

 

 

 

 

 

 

 

 

 

 

6,898,000

2,960,000

2,400,000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Less Other expenses

 

 

 

 

 

 

 

 

Selling expenses

565,000

278,000

89,000

 

 

932

 

 

Marketing expenses

135,000

254,000

184,000

 

 

573

 

 

Occupancy expenses

186,000

201,000

134,000

 

 

521

 

 

Administrative expenses

167,000

123,000

98,000

 

 

388

 

 

 

 

 

 

 

 

 

 

 

Operating expenses

1,690,000

831,000

417,000

 

 

 

 

 

Finance costs

259,000

247,000

126,000

 

 

8,647

 

 

Depreciation expense

520,000

200,000

72,000

 

 

824

 

(520+200+72+32)

Impairment loss expense

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3,522,000

2,134,000

1,120,000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Operating profit before tax

3,376,000

826,000

1,280,000

 

 

7,191

 

 

Income tax expense

1,216,000

448,000

512,000

 

 

2,176

 

 

 

 

 

 

 

 

 

 

 

Operating profit after tax

2,160,000

378,000

768,000

 

5,015

 

 

 

NCI in operating profit after tax

 

 

 

 

42

 

 

 

PEI in operating profit after tax

 

 

 

 

4,973

 

 

 

Retained Profits - 1 July 2012

2,880,000

1,920,000

2,680,000

 

5,015

 

 

 

Balance Sheet

 

 

 

 

 

 

 

 

Retained profits - 30 June 2013

0

0

0

 

 

12,150

 

 

Share capital

13,200,000

2,240,000

640,000

 

 

13,200

 

 

 

 

 

 

 

 

4,459

 

 

 

 

 

 

 

 

 

 

 

General reserve

0

0

50,000

 

 

50

 

 

Foreign currency translation reserve

 

45,000

27,000

 

 

72

 

 

Non-controlling interest

 

 

 

 

 

914

 

 

Accounts payable

3,640,000

2,860,000

1,276,000

 

 

7,776

 

 

Dividends payable

1,040,000

360,000

50,000

 

 

1,450

 

 

 

 

 

 

 

 

 

 

 

Deferred tax liability

 

 

 

 

 

 

 

 

Borrowings

3,139,500

850,000

0

 

 

3,989

 

 

Other non-current liabilities

0

0

0

 

 

 

 

 

Total Liabilities and Equity

21,019,500

6,355,000

2,043,000

 

 

 

 

0

 

 

 

 

 

 

 

 

 

Cash at bank

294,000

54,000

371,000

 

719

 

 

 

Accounts receivable

688,000

208,000

272,000

 

1,168

 

 

 

Dividends ...