Tokyo IPO

Japanese

Azplanning Co.,Ltd.

Code Sector Market
3490 Real Estate JQS
Date of listing approval 2018/02/23
Expected Date 2018/03/29
Lead Underwriter Mizuho    
Description Sale, lease, and management of real estate
Listed Shares(total) 310,500
Trading Unit 100
New Shares 200,000
Existing Shares 110,500° incl. O.A.°ň
Shares Outstanding PreIPO 800,000.00
PostIPO 900,000.00
Paid Up Capital PreIPO Y30,000,000
PostIPO Y129,360,000
Expected Pricing Date 2018/03/08
Book Building Start 2018/03/12
Book Building End 2018/03/16
Fix Date 2018/03/19
Offering Starts 2018/03/20
Offering Ends 2018/03/26
Expect Pricing Y2,060-Y2,160
Notional PER
(based on previous period)
9.19-9.64
Offering Price Y2,160
Offering Price PER
(based on previous period)
 - 
Offering Price PBR
(based on previous period)
2.85
Use of Funds Raised  

Financial Data

Units:Y1,000

Fiscal Year End:2015/02
Consolidated Non-consolidated
Revenue - 1,777,584
Current Profit - 243,167
Net Profit - 163,218
Net Assets - 367,561
Fiscal Year End:2016/02
Consolidated Non-consolidated
Revenue - 2,883,749
Current Profit - 26,871
Net Profit - 6,729
Net Assets - 374,153
Fiscal Year End:2017/02
Consolidated Non-consolidated
Revenue - 4,742,250
Current Profit - 259,452
Net Profit - 156,832
Net Assets - 531,144
Recent Quarter
2017/11
Consolidated Non-consolidated
Revenue - 3,507,822
Current Profit - 141,685
Net Profit - 141,131
Net Assets - 672,374

Per Share Units:Y1

Fiscal Year End:2015/02
Consolidated Non-consolidated
Dividend 0.00
Net Earning - -
Equity 233.17 525.09
Fiscal Year End:2016/02
Consolidated Non-consolidated
Dividend 0.00
Net Earning - -
Equity 9.61 534.50
Fiscal Year End:2017/02
Consolidated Non-consolidated
Dividend 0.00
Net Earning - -
Equity 224.05 758.78
Fiscal Year End:Recent Quarter
2017/11
Consolidated Non-consolidated
Dividend
Net Earning - 201.62
Equity - -

Comment

Ę£Over allotment(40,500)

Consolidated Subsidiaries

Name Address

Underwriters

Allocation Underwriter Tel
0% Nomura 03-3211-1811
90% Mizuho 03-5208-3210
3% Nomura 03-3211-1811
3% SBI SECURITIES Co.,Ltd. 03-5562-7210
1% Okasan 03-3272-2211
1% Tokai Tokyo 03-3566-8811
1% Marusan 03-3272-5211
1% Mito 03-6739-0310

Data

Date of incorporation 1989/04/26
Company address  Saitama 333-0811
Telephone 048-298-1720
President  
Homepage https://www.azplan.co.jp/
Auditor EY Shin Nihon
Major Shareholders
Shareholder Name Ratio
86.62%
  60.24%
  24.10%
  12.05%
  0.90%
  0.48%
  0.30%
  0.30%
  0.30%
  0.24%
  0.18%
Number of Employees 37 as of 2018/01/31
Birth Date of Representative 1960/04/09

Comment