CONSOLIDATED FINANCIAL HIGHLIGHTS

October 31, 2007

Company code number:

3730( URL : http://www.macromill.com)
Tokyo Stock Exchange , 1st section
Yasunori Fukuha, Chairman
Yasuhiro Ogino, Manager of Accounting and Finance Department+81-3-6716-0700

Shares traded:Company Representative:
Contact for further Information:
Telephone:

1. Consolidated operating results ( July 1, 2007 to September 30,30, 2007 )(1) Consolidated financial results(In millions of yen, with fractional amounts discarded)(Percent figures show projected quarter-on-quarter change for previous year)

Net sales(Millions of yen)

1,656
1,536
6,392

September 30, 2007
September 30, 2006
June 30, 2006

Operating income
464456
1,969

Net income(Millions of yen)

239
245
1,056

September 30, 2007
September 30, 2006
June 30, 2006

(Millions of yen)

％

7.8
32.2

Ordinary income(Millions of yen)

％

1.8
22.9

460
460
1,984％

0.0
23.2

Net income per share(Diluted)

Net income per share
％

(yen)

(yen)

(2.4)
17.5

1,863.89
1,947.32
8,293.19

1,862.54
1,911.31
8,220.60(2) Consolidated financial position
Total assets

Net assets(Millions of yen)

Equity ratio(Millions of yen)

Net assets per share
(yen)

％

September 30, 2007

6,494

5,078

72.0

36,388.05

September 30, 2006

5,253

4,246

74.9

31,011.04

June 30, 2006

6,330

4,992

73.0

35,953.11

Cash flows fromoperating activities

Cash flows frominvesting activities

Cash flows fromfinancing activities

equivalents , End of(Millions of yen)

(Millions of yen)

(Millions of yen)

(3) Consolidated cash flow position(Millions of yen)

Cash and cashyear

September 30, 2007

(9)

(70)

153

3,685

September 30, 2006

324

(75)

(135)

2,5991,695(269)

(312)

3,613

June 30, 2006

-1-2.

Dividends(Record date)dividend per share
1st quarter ended(Yen)

September 30, 2007
September 30, 20063.

-Forecasts for June
June 2008 term ( From
From July 1, 2007 to June 30, 2008)
2008)(Percent figures show projected year-on-year change for relevant period)
Net sales(Millions of yen)Interim term
Annual

3,760
8,000

Operating income％ (Millions of yen)

20.1
25.1

980
2,200

Ordinary income％ (Millions of yen)

4.7
11.7

980
2,200

Net income

Net income％ (Millions of yen)

3.910.9520
1,200per share％

(Yen)

2.9
13.6

4,080.87
9,417.39

The consolidated earnings forecast, the fiscal year ending June 2008, remains unchanged from the forecast announced
on August 10, 2007.
4.

Others(1) Changes in major subsidiaries during the three months period ended September 30, 2007.: None
(2) Application of simplified methods for accounting procedures: None
(3) Changes in accounting procedures since the previous consolidated fiscal year: None

※ Note with respect to financial forecast
The above forecasts ware based on information that was available as of the day of this announcement and on
assumptions made as of the same day regarding a number of uncertainties that could affect future financialperformance. Actual results could differ considerably depending on a variety of factors hereafter.

-2-

Consolidated Balance Sheets
SheetsDescription(Thousands of yen)
As of September 30, 2006

Amount（Assets）
Assets）
Ⅰ Current assets
assets
1. Cash and deposits
2. Notes and accounts receivable
3. Securities

Ratio

As of September 30, 2007

Amount％Ratio

As of June 30, 2007

AmountRatio％％

2,599,669

2,686,029

2,613,347

1,192,700

1,281,572

1,204,635-

999,878

999,825

4. Deferred tax assets

152,300

172,129

177,591

5. Others

47,139107,851

80,712(2,548)(1,972)(2,938)

Allowance for doubtful accounts
Total current assets
Ⅱ Fixed assets
1. Tangible fixed assets
2. Intangible fixed assets(1) Software

3,989,261

75.9

5,245,488

80.8

5,073,173

80.1

202,2393.9

207,1543.2

202,1443.2

399,804

440,954442,113(2) Goodwill

408,590

302,106

329,483(3) Others

23,284

34,97018,849Total Intangible assets
3. Investments and other assets
Total fixed assets
Total assets（Liabilities）
Liabilities）
Ⅰ Current Liabilities
1. Short-term loans payable

831,679
229,91015.8
4.4

778,031264,29912.0
4.0

790,446
264,406

1,263,829

24.1

1,249,484

19.2

1,256,998

19.9

5,253,091

100.0

6,494,973

100.0

6,330,172

100.0

-

300,000-

2. Accounts payable

400,271373,444

290,540

3. Income taxes payable

178,416

218,553

536,591

4. Allowance for panelists-points
5. Others

297,589
129,832

370,603
153,934

329,491
180,892

Total current liabilities
Total liabilities（Net assetsassets））

12.5
4.2

1,006,109

19.2

1,416,536

21.8

1,337,517

21.1

1,006,109

19.2

1,416,536

21.8

1,337,517

21.1

Ⅰ Shareholders’ equity
1. Common stock

910,23917.3

930,358

14.3

928,616

14.7

2. Capital surplus
3. Retained earnings

957,161
2,066,845

18.2
39.4

963,899
2,785,200

14.8
42.9

963,5392,725,538

15.2
43.1

3,934,246

74.9

4,679,458

72.0

4,617,695

73.0

--

(463)
16,673

(0.0)
0.3

409
12,1250.0
0.2

Total shareholders’ equity
Ⅱ Valuation and translation
adjustments
1. Translation adjustments
Ⅲ Stock acquisition rights
Ⅳ Minority interests

312,7345.9

382,769

5.9

362,423

5.7

Total net assets

4,246,981

80.8

5,078,437

78.2

4,992,654

78.9

Total liabilities and net assets

5,253,091

100.0

6,494,973

100.0

6,330,172

100.0-3-Consolidated Statements
Statements of Income(Thousands of yen)
As of September 30, 2006

As of September 30, 2007

AmountRatio

AmountRatio

1,536,149

100.0

1,656,581659,527

43.0

876,62157.0

419,912

Operating income
Ⅳ NonNon--operating income
Ⅴ NonNon-operating expenses

456,709
5,481
1,411

0.1

8,750

0.5

6,307

0.1

Ordinary income
Ⅵ Extraordi
Extraordinary
nary losses

460,778
2,412

30.0
0.2

460,987-27.8-

1,984,616
7,186

31.0
0.1

Income before income taxes
and minority interests

458,36629.8

460,98727.8

1,977,430

30.9

Income taxes – current
Income taxes – deferred

173,479
25,615

11.3
1.7

194,611
5,865

11.7
0.3

855,2814,988

13.3
0.1Minority interests in net income

13,7870.9

21,021

1.3

60,410

1.0

Net income

245,483

15.9

239,48814.5

1,056,749

16.5

Description

Amount

Ratio

100.0

6,392,988

100.0

730,97844.1

2,765,656

43.3

925,60355.9

3,627,331

56.7

27.3

460,80927.8

1,657,831

25.9

29.7
0.4

464,794
4,944

28.1
0.2

1,969,500
21,424

30.8
0.3％

Ⅰ Net
Net Sales
Ⅱ Cost of sales
Gross profit
Ⅲ Selling, general andadministrative expenses-4-As of June 30, 2007％％Consolidated Statements of Changes
Changes in Shareholders’ Equity (July 1, 2006 to September 30, 2006)(Thousands of yen)

Shareholders’ equity
September 30, 2006

Capitalsurplus

Common stock

Balance as of June 30, 2006

897,381956,301

12,858860

Minority
interests

Total
shareholders’equityRetainedearnings
2,022,792

3,876,475

Total net
assets298,947

4,175,422

Changes during the term
Issuance of new share

13,71813,718Dividends(201,430)(201,430)(201,430)

Net income

245,483

245,483

245,483

Change in items other thanshareholders’ equity

13,787

13,787

Total changes during the term

12,858860

44,053

57,771

13,78771,559Balance as of September 30, 2006

910,239

957,161

2,066,845

3,934,246

312,734

4,246,981

Consolidated Statements of Changes
Changes in Shareholders’ Equity (July 1, 2007 to September 30, 2007)(Thousands of yen)
Shareholders’ equity

September 30, 2007

Commonstock

CapitalsurplusRetainedearnings

Balance as of June 30, 2007

928,616

963,5392,725,538

1,741

360

Valuation
andtranslationStockadjustments acquisitionrightsTotaltranslation
shareholders’adjustments
equity4,617,695

409

12,125

Minorityinterests

Total net
assets362,423

4,992,654

Changes during the term
Issuance of new share

2,101

2,101

Dividends(179,827)(179,827)(179,827)

Net income

239,488239,488239,488

Change in items other thanshareholders’ equity

(873)

4,547

20,34624,019Total changes during the term

1,741

360

59,661

61,762

(873)

4,547

20,34685,782

Balance as of September 30, 2007

930,358

963,899

2,785,200

4,679,458(463)

16,673382,769

5,078,437

Consolidated Statements ofof Change in Shareholders’ Equity (July 1, 2006 to June 30, 2007)
Valuation
andtranslation
adjustments

Shareholders’ equity

June,30 2007

Commonstock

CapitalsurplusRetainedearnings

Balance as of June 30, 2006

897,381956,301

2,022,792

31,235

7,238

Total
translation
shareholders’adjustments
equity3,876,475-(Thousands of yen)StockacquisitionrightsMinority
interests

Total net
assets-298,947

4,175,422

Changes during the term
Issuance of new share

38,47338,473

Dividends(354,003)(354,003)(354,003)

Net income

1,056,749

1,056,749

1,056,749

Change in items other thanshareholders’ equity

409

12,12563,47576,011

Total changes during the term

31,235

7,238

702,746

741,220409

12,12563,475817,232

Balance as of June 30, 2007

928,616

963,5392,725,538

4,617,695

409

12,125362,423

4,992,654-5-

Consolidated statements
statements of cash flow

(Thousands of yen)
As of September As of September
30, 2006
30, 2007

Description

AmountAmountAs of June 30,2006

AmountⅠ Operating activities
Income before income taxes and minority interests

458,366

460,987

1,977,430

Depreciation

38,02645,281

170,986

Amortization of goodwill
Increase in allowance for panelists-points

27,23929,43627,376
41,111109,094
61,338

Increase in accounts receivable(86,570)(64,294)(98,119)

Increase in accounts payable

86,071

43,49419,081

Increase (decrease) in consumption tax payable

14,503(25,758)

44,882Others49,814(35,931)

27,059SubtotalInterest income

616,888194

492,267
3,559

2,311,754
6,149

Taxes paid

(292,256)(505,530)(622,561)

324,826(9,703)

1,695,342(19,339)(30,037)(57,852)

Payments for purchases of software(37,024)(39,817)(153,989)

Others(19,252)(161)(57,649)(75,616)(70,016)(269,490)

Net cash provided by (used in) operating activities
Ⅱ Investing activities
Payments for purchases of tangible fixed assets

Net cash used in investing activities
Ⅲ Financing activities
Increase in short-term loans payable
Cash dividends paid
Proceeds from issuance of new share
Net cash (used in) provided by financing activities
Ⅳ Effect of exchange rate changes on cash and cash equivalents
increase
Ⅴ Net increase in cash and cash equivalents
Ⅵ Cash and cash equivalents , Beginning
EndingⅦ Cash and cash equivalents , End
ing

-6--

300,000-(148,820)(148,122)(350,381)

13,7182,044

38,214(135,102)

153,922(312,167)

170(1,467)

14,096114,277

72,734

1,127,781

2,485,391

3,613,173

2,485,391

2,599,669

3,685,907

3,613,173

Supplementary Information
Information
Description(Thousands of yen)

September 30, 2006

September 30, 2007

AmountAmount

Ratio％

Automatic research

912,768

59.4

Ratio

June 30, 2007
Amount％Ratio％

1,011,749

61.1

3,783,060

59.2

Tabulation

58,4753.8

76,404

4.6

285,579

4.5

Analysis

109,773

7.2

107,295

6.5

475,312

7.4

Customized research

159,668

10.4

130,6857.9

659,051

10.3

Global research

192,960

12.6

203,082

12.3

799,432

12.5

Mobile research

14,3420.9

20,783

1.2

61,6011.0

Other88,1595.7

106,5816.4

328,950

5.1

Total

1,536,149

100.0

1,656,581

100.0

6,392,988

100.0-7-NonNon-Consolidated Balance sheets
Description(Thousands of yen)
As of September 30, 2006

AmountRatio（Assets）
Assets）
Ⅰ Current assets
1. Cash and depositsAs of September 30, 2007

Amount％Ratio

As of June 30, 2007

Amount％％2,144,550

2,109,575

2,049,789

2. Notes

32,22632,933

44,117

3. Accounts receivable

937,909

1,007,857

980,544-

999,878

999,825

4. Securities
5. Prepaid Expenses

29,64569,18355,213

6. Deferred tax assets
7. Others

138,330
2,589

167,199
2,023

175,682
3,109(2,548)(1,258)(1,601)

Allowance for doubtful accounts
Total current assets
Ⅱ Fixed assets
1. Tangible fixed assets(1) Buildings(2) Furniture and fixtures(3) Construction in progress
Total tangible assets
2. Intangible fixed assets(1) Software(2) Software in progress(3) Others
Total intangible assets
3. Investments and other assets

3,282,703

67.8

4,387,393

73.3

4,306,679

36,60745,35947,124140,170

118,843

125,930

176,778

13,095
3.7

177,299

176,017362,679

366,6202,437
258

28,935208

10,833220

8.2

391,8236.5

377,674(1) Investment securities

77,67878,51578,306(2) Stock of affiliated company(3) Deposit and guarantee

811,250
91,822811,250
136,877

811,250
136,877

3,119

2,434

2,320(4) Deferred tax assets
Total investments and other assets
Total fixed assets
Total assets

73.1

2,962
3.0

393,004

395,699

Ratio

3.0

6.4

983,87020.3

1,029,077

17.2

1,028,753

17.5

1,556,348
4,839,052

32.2
100.0

1,598,199
5,985,593

26.7
100.0

1,582,445
5,889,12526.9
100.0-8-Description

As of September 30, 2006

AmountRatio

As of September 30, 2007

AmountRatio

As of June 30, 2007

Amount

Ratio（Liabilities）
Liabilities）
Ⅰ Current Liabilities
1. Short-term loans payable
2. Accounts payable311,560

300,000
312,534

245,852

3. Accrued expenses
4. Income taxes payable

11,606
178,385

20,144
170,747

19,288522,255

5. Consumption tax payable
6. Allowance for panelists-points

47,425297,589

48,865
370,60378,469329,491

9. Others
Total current liabilities
Total liabilities（Net assets）
assets）
Ⅰ Shareholders’ equity
1. Common stock
2. Capital surplus(1) Legal capital surplus
Total capital surplus
3. Retained earnings(1) Other retained earnings
Retained earnings brought forward

60,28946,92444,477

906,856

18.7

1,269,820

21.2

1,239,835

21.1

906,856

18.7

1,269,820

21.2

1,239,835

21.1

910,23918.8

930,358

15.5

928,616

15.8

957,161
957,161

963,89919.8

2,064,794

963,899

963,53916.1

2,804,841

963,53916.3

2,745,007

Total retained earnings

2,064,794

42.7

2,804,841

46.9

2,745,007

46.6

Total shareholders’ equity

3,932,195

81.3

4,699,099

78.5

4,637,164

78.7

--

16,6730.3

12,125

0.2

Ⅱ Stock acquisition rights
Total net assets

3,932,195

81.3

4,715,772

78.8

4,649,290

78.9

Total liabilities and net assets

4,839,052

100.0

5,985,593

100.0

5,889,125

100.0-9-

NonNon-Consolidated Statements
Statements of income
Description(Thousands of yen)
As of September 30, 2006

AmountRatio

As of September 30, 2007

Amount％Ⅰ Net Sales
Ⅱ Cost of sales

Ratio

As of June 30, 2007

Amount％Ratio％

1,298,754

100.0

1,382,788

100.0

5,434,767

100.0

556,96742.9

606,01543.8

2,263,121

41.6

741,78757.1

776,77356.2

3,171,646

58.4

312,34424.0

367,959

26.6

1,318,313

24.3

429,442
2,699

33.1
0.2

408,813
3,598

29.6
0.2

1,853,333
9,423

34.1
0.2

1,140

0.1

1,632

0.1

5,520

0.1

431,001-

33.2-

410,779-29.7-

1,857,236
4,459

34.2
0.1

Income before income taxes
and minority interests

431,001

33.2

410,77929.7

1,852,776

34.1

Income taxes – current

173,407

13.4

162,74911.8

798,949

14.7

Income taxes – deferred

2,713

0.2

8,369

0.6

(33,839)(0.6)

254,880

19.6239,660

17.3

1,087,666

20.0

Gross profit
Ⅲ Selling, general andadministrative expenses
Operating Income
Ⅳ Non
Non--operating income
Non--operating expenses
Ⅴ Non
Ordinary income
Ⅵ Extraordinary losses

Net income- 10 -