Financial Results for the 1st Quarter
Year ending June 30, 2013 (FY14)

Financial Results

1Results Overview for the 1st Quarter Year ending June 30, 2013 (FY14)✓ Achieved record quarterly sales and double-digit growth in both sales and income（million yen）

1st Quarter

Full-year forecast（ July 1 - Sept 30）（July 1 - June 30）

FY2013/6
Net Sales

FY2012/6

YoY（% achieved）

Consolidated
Non-NonConsolidated

3,978

3,204

124.2%

16,800

23.7%

881

661

133.1%

3,900

22.6%

22.1%

20.7%

＋1.4pt23.2%－Extraordinary loss

113296.6%－－Net income

648

342

189.1%

2,100

30.9%

Net sales

3,607

3,185

113.3%

909

790

115.1%

25.2％

24.8％

+0.4ptOrdinary income
Ordinary income rate

Ordinary income
Ordinary income rate2

Topics
Domestic business domains
 Maintained doubledouble-digit growth in sales and income
Achieved particularly robust sales growth from food & drink
manufacturers by integrating research and database businesses Strong growth in the QPR service, which rose 68.8% year on year

Overseas business domain
 Macromill EMBRAIN in South Korea achieved quarterly sales of¥310M→Became profitable in JulyJuly-Sept for the first time in 3 years
 Launched a research service using product samples in China in analliance with Shanghai UC3

Macromill Strategy Map

ResearchDomain

Overseas
Business
DomainDatabase
DomainNew
Business
Domain4

Change in Income and Cost Structure(1st Quarter)
Nonconsolidated

1Q (FY14)
Amount1Q (FY13)%

Amount%Net Sales

3,607

100.0

3,185

100.0

Cost of sales

1,838

50.9

1,541

48.4

503

13.9

422

13.3

・Upfront investment in consolidated
subsidiaries
M-WarpM-Promo
Macromill China（million yen）

Personnel-28

Panelists andoutsourcing

1,063

29.5

827

26.0

Other

271

7.5

291

9.2

861

23.9

847

26.6

Personnel

493

13.7

525

16.5

Other

367

10.2

322

10.1

790

Non
Non--Consolidated
24.8 Ordinary Income

SG&A

881

＋119

Ordinary Income

909(Consolidatedordinary income)881

Net Income

909

25.2

790

2012/6
１Ｑ

2013/6
１Ｑ

Non-Consolidated
NonOrdinary Income

Consolidated
Ordinary Income

25.2%

22.1%

661

24.8%
544

2013/6
１Ｑ

15.1

457

14.4
5

Breakdown of Sales by Category（non-consolidated）✓ Strong growth in orders from food & drink manufacturers driven bysynergies in the QPR service and online research
Industries in whichsales increased（％）(1Q YoY change of sales)
1.7¥3,607Ｍ¥3,185Ｍ■ Government
agencies, associations, schools, etc.
■ General companies■ Researchcompanies, Consulting firms■ Advertising agencies

2.2

１．Food & drink＋32.6%

65.3＋¥150M

69.2

Research companies/
２．consulting firms＋29.4%
14.5

16.6

18.0

12.5

３．IT/ telecommunications＋29.9%

1Q (FY13)＋¥130M＋¥90M1Q (FY14)
6

Breakdown of Changes by Service（non-consolidated）✓ Increased sales in almost all services, especially in the following:→QPR Service ＋68.8% year on year
→Global Research＋51.6% year on year
→Qualitative Research＋33.2% year on year
Service

1Q (FY14)%（million yen）
1Q (FY13)

%

YoY

1,874

52.0

1,761

55.3

106.2%

Tabulation

224

6.2

195

6.1

114.7%

Analysis

351

9.8

306

9.6

114.9%

Qualitative researchservices

347

9.6

260

8.2

133.2%

Customized research

329

9.1

316

9.9

104.7%

Global research

1434.094

3.0

151.6%

QPR

235

6.5

139

4.4

168.8%

Other services

101

2.8

110

3.5

94.0%

3,607

100.0

3,185

100.0

113.3％

Automatic research

Total*Changed the disclosure classification since the quarter under review. The quarterly year-on-year comparison has been adjusted to the new classification.
*Other Services include the mobile research service.

7

Status of the QPR Service✓ The number of client companies increased solidly, resulting
in sales growth of 68.8% year on year.
✓ Improved sales efficiency through organizational integration with theresearch domain
Change in annual sales
FY2008/6FY2009/667（million yen）
FY2010/6179

FY2011/6283410746

Change in quarterly sales
400006253529383971

1,150（million yen）

600

200

FY2013/6（forecast）

FY2012/6566871878799

78145 139 178 190（forecast）
237 235

１Q ２Q ３Q ４Q １Q ２Q ３Q ４Q １Q ２Q ３Q ４Q １Q ２Q ３Q ４Q １Q ２Q ３Q ４Q １Q ２Q ３Q ４Q
2008.06

2009.06

2010.06

2011.06

2012.06

2013.068

Overseas Business Domain
South Korea (Macromill EMBRAIN)✓ Achieved sales of ¥310M (up 41% YoY) byengaging in organizational management andstrengthening the sales force→Became profitable in July-Sept for the first timein 3 years
China (Macromill China, Shanghai UC)✓ Macromill China achieved sales of ¥44M (up 1,337%YoY) driven by increased orders from Japanesecorporations✓ Increased enquiries for the Sampling service in China
offered in alliance with Shanghai UCEurope & USA✓ Actively seeking M&A opportunities

9

New Business Domain
Readily accessible Promotion Service for broader users utilizing smartphones

Promotion￥couponSmartphones

Long-tailDeveloping service to release in the next spring10業績目標

2012-2014 Performance Targets（million yen）

FY2012/6（achieved）

FY2013/6（forecast）（forecast）※after upward adjustment

FY2014/6

Net sales (Consolidated)

14,22916,80020,000Ordinary income

2,975

3,900

4,700

Ordinary income rate

20%

23%

24%

11

New Mission Statement
Macromill’s mission is
to become the leading innovation company in our society
by providing quality marketing services on the cutting edge
and to grow without compromising our beliefs.
The three policies below are our guideline for decision making andjudgments:

Offer services that truly satisfy and impress our customers.
Create a field where our employees can challenge the extent of theircapabilities.
Pursue profit for sustainable growth.
12We aspire to become Japan’s largest andstrongest IT marketing company andone of the world’s most uniquecompanies.

13

Financial Results Details

14Unit price, Number of Active Client Companies (servers) & VIP Clients
2Ｑ

FY2011/6
3Ｑ

4Ｑ

1Ｑ

FY2012/6
2Ｑ
3Ｑ

4Ｑ

FY2013/6
1Ｑ

Indicator

Unit

Quarterly average unit
price per order（*1）¥ tenthousand

79.1

80.0

75.5

78.3

79.7

83.777.2

77.9

Quarterly average unit priceper order (automatic researchonly)¥ ten
thousand

52.2

52.0

49.8

52.5

52.0

54.9

49.7

50.8

Quarterly average unit price¥ ten
per order (for reference)
thousand

82.2

83.5

78.7

81.3

83.3

87.5

80.7

81.7

Number of active clientcompanies (annual)Companies

1,386

1,675

1,895

985

1,371

1,711

1,924

996

Number of active servers(annual)Servers

3,870

4,988

6,067

2,485

3,988

5,382

6,327

2,672

Number of VIP clients

Companies

240

240

229

254

256

251

249

281

Companies（58）（55）

（53）

（61）

（63）

（67）

（64）

（67）

（*１）

（*1）

（*2）

（*2）

（*３）

Number of VIP clients withaverage quarterly sales of¥10m or more

（Full-year）(Full-year)（*４）*1The services of the former YVI were not included in the calculation of the average unit price for the year ended June 30, 2011. Orders for qualitative researchwere not included in the calculation of the quarterly average unit price per order (for reference). To calculate realistic unit prices, going forward, overall unit prices will be calculatedusing a method that counts qualitative research as one order, as shown in the top row above.
*2 Year-to-date total for each fiscal year; number of companies/servers that posted sales at least once between the beginning of the fiscal year and the end of the quarter.
*3 Year-to-date total for each fiscal year; priority clients with annual sales of ¥10 million or more are defined as VIP clients.
*4 Year-to-date total for each fiscal year

15

Status of Personnel
FY2011/6

FY2012/6

FY2013/6

2Ｑ

3Ｑ

4Ｑ

1Ｑ

2Ｑ

3Ｑ

4Ｑ

people

553

545

557

566

594

735

768

788people

542

528

542

541

550

560

582

567

Indicator

Unit

Number of employees(consolidated)*
Number of employees(non-consolidated)**Number of employees includes contract employees and those on leave.

1Ｑ*35 new graduates will join the company in April 2013

✓ Breakdown of personnel by job type
Sales
Operations
Researchers
151
113
134
（including 20 assistants）*Executive officers and those at higher levels, employees on leave are not included.
*As of October 1, 2012

✓ Number of employees at consolidated subsidiaries

Others include those inbusiness planning,business administration,
panelists support andregular staff, etc.

186→221

M-Cube: 6→ 12
M-Warp: 20→17
Macromill China: 20→21
Macromill EMBRAIN: 139→164
M-Promo: 1→7
16

Status of Panelists
FY2011/6

FY2012/6

FY2013/6

Indicator

Unit

2Ｑ

3Ｑ

4Ｑ

1Ｑ

2Ｑ

3Ｑ

4Ｑ

1Ｑ

MacromillPanelists

Tenthousandpeople

100.2

98.5

104.0

105.9

107.1

108.6

109.5

110.7

*As of October 2012

PC Panelists
Macromill Panelists
1.1M people（including smartphone panelists）
panelists）

Mobile Panelists

Yahoo!
Research Panelists

1.46M people(approximately)

330k people(approximately)

To be terminated（End November 2012）
2012）

Mobile here refers to feature phones only

17

Changes in Balance Sheets (Consolidated） / Capital policy
Liabilities¥8.8bnTotal assets¥18.7bn

CB¥5bn

Cash and deposits¥8.4bnLiabilities¥8.2bnTotal assets¥18.3bn

CB¥5bn

Cash and deposits

Net assets¥9.8bnEnd of June 2012

¥7.6bnNet assets¥10bn

End of September 2012

Considering investments including M&A for new business and overseas business expansion→To actively promote business expansion to establish a new pillar of businessusing cash generated in existing business domains
18Reference19

Company History & Business Results(million yen)
16,0002010年8月
August2010
Successor to marketing research
ヤフーバリューインサイト株式
business of Yahoo
Value Insight, Inc.
会社のby absorption-type demerger
マーケティングリサー業を吸収分割により承継

14,000January 2004
12,00014,22912,210Listed on MOTHERS
market of theTokyo Stock Exchange

10,000April 2005
Transferred to 1st Section ofTokyo Stock Exchange

8,000

7,413

7,755

7,353

売上高Netsales

6,392
6,000

4,000

経常利益
Ordinaryincome

January 2000
5,179

Company establishedAugust 2000

3,613
2,975

AIRs completed,operations start-up

2,077

2,000
10637929851
201

1,259

1,653

1,984

2,157

1,753

2,1352,5226140-87
FY2001/6
FY2002/6
FY2003/6
FY2004/6
FY2006/6
FY2007/6
FY2008/6
FY2009/6
FY2010/6
FY2012/6
FY2011/6
FY2005/6(Non(Non(Non(Non(Consolidated) (Consolidated) (Consolidated) (Consolidate ) (Consolidated) (Consolidated)(Consolidated)(NonConsolidated)Consolidated) Consolidated) Consolidated) Consolidated)-2,00020

Service Flow of the Online Research
ClientMacromill① Request research.

④ Sendquestionnaires.

People surveyed
Macromillpanel members

Automatic Internet Research System

・Computer panelists
・Mobile panelists
・Cell phone panelists

Domestic corporations
Overseas corporations ⑤ View tabulationof responses inreal time.
・Advertising agencies
・Manufacturers
・Consulting・Service companies
・IT companies
・Mass media
・Public sector…etc.

② Prepare researchforms.
③ Select people tobe surveyed.

⑤ Respond toquestionnaires.

⑤ Perform real-time
tabulation.
⑦ Deliverresearch results.

⑥ Generate data fordelivery.

⑤ Offer reward points(real time).

OutsidePanel members

・Doctor panelists(business tie
tie--uppanelists)
・Overseas researchpanelists
・Member lists ofclients…etc.

*For Macromill panelists*This is a representative example of the service flow of the online research using AIRs. Depending on the subject of the research, AIRs may not be used or the flow
may change.
* If a research plan is required, this happens before step ① in the flow chart. If an analysis of research results is required, this happens after
step ⑦ in the flow chart.

21

Share Information
As of June 30, 2012

Total number ofauthorized shares
Total number ofissued shares
Number ofshareholders
Round lot

Ownership(%)

Yahoo Japan Corporation

7,071,100

22.91

Vanillasky Corporation

2,402,000

7.78

Goldman Sachs International

2,369,426

7.68

Japan Trustee Services Bank, Ltd.
(Trust account)

1,079,800

3.50

Tetsuya Sugimoto

912,400

2.96

Goldman Sachs & Co. Regular Account738,100

2.39

Satoshi Shibata

732,000

2.37

Yasunori Fukuha

709,600

2.30

INTEC Inc.

514,400

1.67

The Master Trust Bank of Japan, Ltd.
(Trust account)

507,300

1.64

83,712,000
30,868,400
9,467
100

Financial products
Treasury stock
traders
Individuals, others
9.19％
0.47％30.34％
Othercorporations
33.45％

Overseas
corporations, etc
17.11％

Number ofshares held

Major shareholders

Financialinstitutions
9.44％

Note 1. The Company’s total treasury stock ownership of 2,835,700 is notincluded in the list of major shareholders above.
Note 2. The ownership ratio is calculated based on the number of shares issued.
Note 3. Vanillasky Corporation listed above is represented by director Tetsuya
Sugimoto.

22

(Reference) Status of Capital/Business Alliances,Group Companies

Consolidated subsidiaries
DomesticOverseas(million yen)

Equity-method affiliatesDentsu Macromill⇒40.0% stake⇒Construction of QPR panels
Collection of consumer purchase data
Shareholders：
HAKUHODO DY HOLDINGSINCORPORATED. etc.

⇒Integration of EMBRAIN andMacromill Korea (August 2012)

Capital/business alliances⇒10.66% stake (ratio of voting rights)

Shanghai United-Cities Industry Co., Ltd.
⇒Marketing solutions business, mainly inthe smartphone area
Next-generation marketing platformbusiness (app development, etc.)⇒Marketing support business using the Internet
Accepted transfer of business from regain, Inc.

⇒Research business in China
Sales launched in
September 2011

⇒6.9% stakeBusiness alliances

Dentsu marketing insight23

Cautionary Statement
Macromill does not guarantee the accuracy of the information
contained in this presentation, which reflects judgments madeby Macromill management based on information currently
available.
Given that the business environment may vary significantly inthe future due to a number of factors, please be aware that
Macromill’s actual performance and results may differ fromthose expressed today.

Inquiries regarding information contained in this presentation:
IR Group, Corporate Strategy Unit, Macromill Inc.
Tel: 03-6716-0706 Fax: 03-6716-0701
E-mail： ir@macromill.com
24