CONSOLIDATED FINANCIAL HIGHLIGHTS

Aug 10th, 2007

Company code number:
Shares traded:Company Representative:
Contact for further Information:
Telephone:
Date of annual general meeting of shareholders:Planned date of dividend payments:
Planned FSA filing submission date:
Adoption of U.S. accounting standards:

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

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

Net sales

Operating income(Millions of yen)%

(Millions of yen)

Ordinary income

Net income%(Millions of yen)%

(Millions of yen)%

June 30, 2007

6,392

23.4

1,969

20.0

1,984

20.0

1,056

6.9

June 30, 2006

5,179

-

1,641

-

1,653

-

988

-

Net income per

Net income per

Return on equity

Ratio of ordinary

Ratio of operating

share

share (diluted)

ratio

income to total assets

income to net sales(Yen)

June 30, 2007
June 30, 2006

％

(Yen)

8,293.19
7,935.32

8,220.60
7,684.53

％

24.9
28.8

％

34.8
36.9

(Note) Gains or losses on investments through equity method accounting:June 2007 term:- million yen
June 2006 term:

30.8
31.7

- million yen(2) Consolidated financial position
Total assets(Millions of yen)

Net assets

Equity ratio

Net assets per share(Millions of yen)

％

(yen)

June 30, 2007

6,330

4,992

73.0

35,953.11

June 30, 2006

5,066

4,175

76.5

30,791.58(Note) Total equity

June 2007 term: 4,618 million yen

June 2006 term: 3,876million yen(3) Consolidated cash flow statements
Cash flows fromoperating activities(Millions of yen)

Cash flows frominvesting activities

Cash flows fromfinancing activities

Cash and cash
equivalents , End ofyear(Millions of yen)

(Millions of yen)

(Millions of yen)

June 30, 2007

1,695

(269)

(312)

3,613

June 30, 2006

1,047

(947)

(106)

2,485

-1-

2.

Dividends
Annual dividend per share(Record date)June 30, 2006
June 30, 2007
June 30, 2008
(Forecast)
3.

InterimEnd of term

AnnualTotal dividend
paid(annual)Dividend
payout ratio(Consolidated)

Dividend/net
assets(Consolidated)(Millions of yen)

%

%

(Yen)

(Yen)

(Yen)

1,200.00

1,600.00
1,400.00

1,600.00
2,600.00

201
332

20.4
31.4

5.8
7.8

1,200.00

1,600.00

2,800.00

-

29.7

-

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

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.9
10.9

520
1,200

per share
％

(Yen)

2.9
13.6

4,080.87
9,417.39

Others(1) Changes in major subsidiary status during period under review (affecting specific subsidiaries due to changes in scopeof consolidation): Yes
New: 1 (Company name: AIP Marketing Korea)(2) Changes in principles/methods of accounting treatment, presentation method or other items related to preparation of
consolidated financial statements (basis of presentation and significant accounting policies)
1) Changes related to revision of accounting standards: Yes
2) Changes other than those included in 1) above: Yes(Note) Please refer to p.9 (“Change in assumptions underlying preparation of consolidated financial statements”) for
further details.
(3) Number of outstanding shares (Common share)
1) Number of outstanding shares at end of term (including treasury stock):
June 30, 2007:
128,448 shares
June 30, 2006:
125,894 shares
2) Number of treasury stock at end of term:
June 30, 2007:- shares
June 30, 2006:- shares(Note) Please refer to p.11 (“Per share information”) regarding the number of shares used as the basis for the
calculation of net income per share (consolidated).

-2-

(Reference) NonNon-consolidated operating results
results
1. NonNon-consolidated operating results (July 1, 2006 to June 30, 2007)(1) Non-consolidated financial results(Percentage figures show projected year-on-year change for previous year)
Net sales(Millions of yen)

June 30, 2007
June 30, 2006

Operating income
%

5,434
4,521

(Millions of yen)

20.2
25.1

1,853
1,566

(Millions of yen)

18.3
24.2

1,857
1,577

Net income%(Millions of yen)

17.7
25.2

%

1,087
977

11.3
30.5

Net income per share

Net income per share(diluted)(Yen)

June 30, 2007
June 30, 2006

Ordinary income

%

(Yen)

8,535.82
7,843.44

8,461.11
7,595.56(2) Non-consolidated financial position
Total assets

Equity ratio(Millions of yen)

(Millions of yen)

5,889
4,707

4,649
3,865

June 30, 2007
June 30, 2006
(Note) Total equity

Net assets

June 2007 term: 4,637 million yen

Net assets per share
%

(Yen)

78.7
82.1

36,101.49
30,700.64

June 2006 term: 3,865 million yen

2. NonNon-consolidated forecasts for June 2008 term (From July 1, 2007 to June 30,2008)(Percentage figures show projected year-on-year change for relevant period)
Net
Net sales

Operating income

Ordinary income

Net income

incomeper share

Interim term
Annual(Millions of yen)%

(Millions of yen)%

(Millions of yen)%

(Millions of yen)

%

(Yen)

3,200
6,800

19.6
25.1

930
2,090

3.9
12.8

930
2,090

3.8
12.5

540
1,230

2.4
13.1

4,237.82
9,652.82* Disclaimer regarding appropriate use of forecasts and related points of note
The above forecasts were 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 financial
performance. Actual results could differ considerably depending on a variety of factors hereafter.

-3-

Consolidated Balance Sheets
SheetsDescription(Thousands of yen)
As of June 30, 2006
AmountIncrease(Decrease)

As of June 30, 2007%

Amount%Amount（Assets）
Assets）
Ⅰ Current assets
1. Cash and deposits

2,485,391

2,613,347

127,956

2. Notes and accounts receivable

1,091,625

1,204,635

113,010

3. Investment securities-

999,825

999,825

8,911

5,765

(3,146)

5. Deferred tax assets

176,207

177,591

1,384

6. Others

54,862

74,94620,084

4. Inventories

Allowance for doubtful accounts(3,094)

Total current assets

3,813,904(2,938)75.3

1555,073,073

80.1

1,259,269

202,144

3.2

3,587

790,446

12.5(53,529)

Ⅱ Fixed assets
1. Tangible fixed assets(1) Buildings and structures

40,33155,435(2) Furniture and fixtures

158,225

143,746(3) Construction in progress-

198,557

3.9

2,962

2. Intangible fixed assets(1) Software

394,449(2) Goodwill

435,829(3) Others

13,967442,113329,483
843,97616.7

210,5424.1

264,406

4.2

53,864

Total fixed assets

1,253,076

24.7

1,256,998

19.9

3,921

Total assets

5,066,980

100.0

6,330,172

100.0

1,263,191

18,8493. Investments and other assets(1) Investment securities(2) Others

92,702
117,840

92,777-4-

171,628

Description

As of June 30, 2006
AmountIncrease(Decrease)

As of June 30, 2007%

Amount%Amount（Liabilities）
Liabilities）
Ⅰ Current Liabilities
1. Accounts payable

244,864

290,540

45,676

2. Income taxes payable
3. Allowance for panelists-points

292,324

536,591

244,266

268,153

329,491

61,388

4. Others

86,215

180,892

94,677

891,558

17.6

1,337,517

21.1

445,958

891,558

17.6

1,337,517

21.1

445,958

1. Common stock

897,38117.7

928,616

14.7

31,235

2. Capital surplus
3. Retained earnings

956,301

18.9

963,539

15.2

7,238

2,022,792

39.9

2,725,538

43.1

702,746

3,876,475

76.5

4,617,695

73.0

741,220

-

-

409

0.0

409

-

-

12,1250.2

12,125298,947

5.9

362,423

5.7

63,475

4,175,422

82.4

4,992,654

78.9

817,232

5,066,980

100.0

6,330,172

100.0

1,263,191

Total current liabilities
Total liabilities（Net assets）
assets）
Shareholders’’ equity
Ⅰ Shareholders

Total shareholders’shareholders’ equity
Ⅱ Valuation and translation adjustments
1. Translation adjustments
Ⅲ Stock acquisition rights
Ⅳ Minority interests
Total net assets
Total liabilities and net assets-5-Consolidated Statements
Statements of Income
Description(Thousands of yen)
As of June 30, 2006
AmountⅠ Net Sales
Ⅱ Cost of sales
Gross profit
Ⅲ Selling, general andadministrative expenses
Operating income
Ⅳ NonNon-operating income
1. Interest income
2. Gains on sales of investments in securities%%

Amount

6,392,988

100.0

1,213,374

2,765,656

43.3

619,583

3,033,540

58.6

3,627,331

56.7

593,791

1,392,454

26.9

1,657,831

25.9

265,376

1,641,086

31.7

1,969,500

30.8

328,414

21,424

0.3

4,557

6,307

0.1

1,860

1,984,616

31.0

331,111

7,186

0.1

(18,823)

1,977,430

30.9

349,934

860,270

13.4

314,679

5,179,614

100.0

2,146,073

41.4

Amount

5,469

7,037

3,673

1,967

3. Interest on refund
4.. Foreign exchange gains

4,865

-

5. Others

2,858

Ⅴ Non
Non--operating expenses
1. Loss on transfer of accounts receivable
2. Others
Ordinary income
Ⅵ Extraordinary losses
1. Losses on disposal of fixed assets
Income before income taxes
and minority interests
Income taxes – current
Income taxes – deferred

Increase(Decrease)

As of June 30, 2007-

11,187
16,866

0.3

3,562

1,231
4,800

4,447

0.1

1,653,505

31.9

26,0090.5

1,627,495

31.4

884

26,009573,164

1,507

7,186

855,281545,590

10.5

Minority interests in net income

93,042

1.8

60,4101.0(32,631)

Net income

988,86319.1

1,056,749

16.5

67,886(27,574)

-6-

4,988

Consolidated Statements of Changes
Changes in Shareholders’Shareholders’ equity(Thousands of yen)

Shareholders’ equity

June,30 2006
Balance as of June 30, 2005

Commonstock

Capitalsurplus875,807937,787

21,574

18,514Retainedearnings

Minority
interests

Total
shareholders’equityTotal net assets

1,181,788

2,995,382-

2,995,382

40,08840,088Dividends(147,859)(147,859)(147,859)

Net income

988,863

988,863

988,863

Changes during the term
Issuance of new share

Change in items other thanshareholders’ equity

298,947

298,947

Total changes during the term

21,574

18,514

841,004

881,092

298,947

1,180,040

Balance as of June 30, 2006

897,381956,301

2,022,792

3,876,475

298,947

4,175,422

Valuationandtranslation
adjustments

Shareholders’ equity

June,30 2007

Commonstock

CapitalsurplusRetainedearnings

Total
shareholders’ equitytranslation
adjustments

Balance as of June 30, 2006

897,381956,301

2,022,792

3,876,475-

31,235

7,238

Stock
acquisitionrightsMinority
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
Total changes during the term
Balance as of June 30, 2007

31,235
928,616

7,238
963,539702,746
2,725,538

-7-

409

12,12563,47576,011

741,220409

12,12563,475817,232

4,617,695

409

12,125362,423

4,992,654

Consolidated statements
statements of cash flow

(Thousands of yen)

As of June 30,
2006

As of June 30,
2007

Increase(Decrease)

AmountAmountAmountIncome before income taxes and minority interests

1,627,495

1,977,430

349,934

Depreciation
Amortization of goodwill
CountsIncrease (decrease) in allowance for doubtful accounts

116,081

170,986

54,904

108,957

109,094

137

974

(155)

(1,130)

Increase in allowance for panelists-points

81,114

61,338(19,776)

Interest income
Interest expenses(5,469)413(7,037)-(1,568)(413)

Foreign exchange gain
Gains on sales of investments in securities(137)(3,673)(13,813)(1,967)(13,676)
1,706

Loss on disposal of fixed assets

26,0097,186(18,823)

Increase in accounts receivable(205,350)(98,119)

107,231

4,299

3,146

(1,153)42,985(45,385)

19,08144,882(23,903)
90,268Description
Ⅰ Operating activities

Decrease in inventories
Increase in accounts payable
Increase (decrease) in consumption tax payable
OthersSubtotalInterest income
Interest expenses
Taxes paid
Net cash provided by operating activities
Ⅱ Investing activities
Payments for acquisition of a new consolidated company share

Payments for purchases of investment securities

30,89339,7008,807

1,779,209
5,353
(413)

2,311,754
6,149-

532,545795
413(736,999)(622,561)

114,438

1,047,150

1,695,342

648,192(495,380)-

495,380(6,886)(3,773)

3,113

Proceed from sale or refund of investment securities

107,513

6,257(101,256)

Payments for purchases of tangible fixed assets
Payments for purchases of software(140,584)(392,892)(57,852)(153,989)

82,732238,903

Payments for purchases of other intangible fixed assets
Payments for deposit(12,085)-(69,279)

12,085(69,279)

Others(7,444)

9,146

16,590(947,761)(269,490)

678,270

Net cash used in investing activities
Ⅲ Financing activities
Increase in short-term loans payable

200,000-(200,000)

Repayment of short-term loans payable
Cash dividends paid

(200,000)(146,398)(350,381)

200,000(203,982)

Proceeds from issuance of new share

40,08838,214(1,874)

Net cash used in financing activities
Ⅳ Effect of exchange rate changes on cash and cash
equivalents
Ⅴ Net increase (decrease) in cash and cash equivalents(106,310)(312,167)(205,857)

137

14,096

13,959(6,783)

1,127,781

1,134,565

Ⅵ Cash and cash equivalents
equivalents , Beginning of year

2,492,175

2,485,391(6,783)

Ⅶ Cash and cash equivalents , End of year

2,485,391

3,613,173

1,127,781-8-

Changes in assumptions underlying preparation of consolidated financial statements
Starting with this fiscal year, the new depreciation method has been applicable. Its impact on operating income, income
before income taxes, extraordinary income, and net income before income taxes is negligible.

(Per share information)(Yen)
Net assets per share
Net income per share
Fully diluted net income per share

June 30, 2006
30,791.58
7,935.32
7,684.53

June 30, 2007
35,953.11
8,293.19
8,220.60(Note) The basic facts underlying calculations of net income per share are as follows.
(Thousands of yen)
Net income
Amount not attributable to common shareholders
Net income per common share
Average number of shares outstanding during term
(number of shares)

Supplementary
Supplementary Information
Description

June 30, 2006
988,863
988,863

June 30, 2007
1,056,749
1,056,749

124,615

127,424(Thousands of yen)

June 30, 2007
AmountIncrease(Decrease)%

Automatic research

3,783,060

27.8

Tabulation
Analysis285,279
475,312

4.6
23.3

Customized research
Global research

659,051
799,432

(5.4)
66.0

Mobile research
Other

61,601
328,950(14.3)
6.0

6,392,988

23.4

Total
Note: Consumption tax is excluded from the amounts.

-9-

NonNon-Consolidated Balance sheets
Description(Thousands of yen)
As of June 30, 2006
AmountIncrease(Decrease)

As of June 30, 2007%

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

2,009,929

2,049,789

39,85951,365

44,117(7,248)898,073

980,544

82,470-999,825

999,825

4. Securities
5. Work in Progress

234

276

42

6. Inventories

299

1,738

1,439

7. Prepaid Expenses

39,49055,213

15,722

8. Deferred tax assets

140,642

175,682

35,0399. Others
Allowance for doubtful accounts
Total current assets
Ⅱ Fixed assets
1. Tangible fixed assets
55,948

Accumulated depreciation(2) Furniture and fixtures(17,737)

Total tangible assets
2. Intangible fixed assets(1) Goodwill(2) Software

1,093

813

(1,601)

1,492

3,137,222(1) Buildings

Accumulated depreciation(3) Construction in progress

280(3,094)73.1

1,169,457

72,138(25,013)150,599(113,546)

229,859(79,260)

4,306,679

38,211

47,124

8,913

125,930(24,668)

239,477
188,810

2,962
4.0

270

176,017

2,962
3.0(12,792)

220

(50)

392,249

366,620(25,629)

5,059

10,833

5,774(3) Software in progress
Total intangible assets
3. Investments and other assets

66.6

397,579

8.5

377,674

6.4(19,905)(1) Investment securities

77,469(2) Stock of affiliated company

811,250

811,250-(3) Deposit and guarantee

91,822

136,877

45,054(4) Deferred tax assets

3,520

Total investments and other assets
Total fixed assets
Total assets

78,306836

2,320(1,200)984,06220.9

1,028,753

1,570,452

33.4

1,582,445

26.9

11,993

4,707,674

100.0

5,889,125

100.0

1,181,450- 10 -

17.5

44,691

Description

As of June 30, 2006
AmountIncrease(Decrease)

As of June 30, 2007%

Amount%Amount（Liabilities）
Liabilities）
Ⅰ Current Liabilities
1. Accounts payable
2. Accrued expenses
3. Income taxes payable

204,807245,852

41,044

7,554

19,288

11,734292,252

522,255

230,003

4. Consumption tax payable
5. Advance received

32,921

78,46945,547

27,911-(27,911)

6. Deposits received

9,047

-

(9,047)

268,153

329,491

61,338-44,47744,477

7. Allowance for panelists-points
8. Others
Total current liabilities
Total liabilities（Net assets
assets））
Ⅰ Shareholders’Shareholders’ equity
1. Common stock

842,647

17.9

1,239,835

21.1

397,187

842,647

17.9

1,239,835

21.1

397,187

897,38119.1

928,616

15.8

31,235

2. Capital surplus(1) Legal capital surplus

956,301

Total capital surplus
3. Retained earnings(1) Other retained earnings

956,301

Retained earnings brought forward
Total retained earnings
Total shareholders’shareholders’ equity
Ⅱ Stock acquisition rights
Total net assets
Total liabilities and net assets

2,011,343

963,53920.3

2,011,343

963,539

2,745,007

7,238
16.3

2,745,007

7,238

733,6632,011,343

42.7

2,745,007

46.6

733,6633,865,026

82.1

4,637,164

78.7

772,137--

12,1250.2

12,125

3,865,026

82.1

4,649,290

78.9

784,263

4,707,674

100.0

5,889,125

100.0

1,181,450- 11 -

NonNon-Consolidated Statements
Statements of income
Description(Thousands of yen)
As of June 30, 2006
AmountⅠ Net Sales
Ⅱ Cost of sales
Gross profit
Ⅲ Selling, generalgeneral andadministrative expenses
Operating income
Ⅳ NonNon-operating income
1. Interest income
2. Interest income on securities
3. Commission income
4. Gains on sales of supplies
5. Interest on refund
6. Gains on sales of investments in securities
7. Others
Ⅴ Non
Non--operating expenses
expenses
1. Interest expenses
2. Loss on transfer of accounts receivable
3. Stock issuance expenses
4. Others
Ordinary income
Ⅵ Extraordinary losses
1. Losses on disposal of fixed assets
Income before income taxes
and minority interests
Income taxes – current
Income taxes – deferred
Net income%%

Amount5,434,767

100.0

913,334

2,263,121

41.6

398,341

2,656,653

58.8

3,171,646

58.4

514,992

1,089,814

24.1

1,318,313

24.3

228,498

1,566,839

34.7

1,853,333

34.1

286,493

9,423

0.2

(5,792)

5,520

0.1

1,306

1,857,236

34.2

279,394

4,459

0.1

(20,919)

1,852,776

34.1

300,313765,10914.1

190,061

1,087,666

20.0

110,2524,521,433

100.0

1,864,779

41.2

Amount

4

1,595

5,428

4,774

709

-

22

-

4,865

-

3,673

1,967
15,215

511

0.3

1,086

413

-

3,562

4,800

237

4,213

0.1

1,577,841

34.9

25,3780.6

1,552,462

34.3

575,048

12.7

977,41421.6-

25,378572,874
2,173

Increase(Decrease)

As of June 30, 2007

719

4,459

798,949- 12 -(33,839)