Asian Pay Television Trust (APTT) IPO balloting ratio - Part 2

Someone by the nickname of "Koopa" left an interesting comment on my previous post (Asian Pay Television Trust (APTT) IPO balloting ratio).

To ensure a reasonable spread of unit holders, the Joint Bookrunners and the Joint Underwriters, in consultation with the Trustee Manager, have decided to... allocate 66% of the units available for IPO to... 8.5% of the (successful) applicants with the deepest pockets.
--Koopa

I chuckled at the part on the "reasonable spread of unit holders". The numbers were quite interesting and I decided to do a breakdown to verify Koopa's calculations. The break down is as follows:

Range of units applied for ('000s)	balloting ratio	no. of successful applicants	no. of applicants	units alloted per successful appplicant	total units alloted
1	0.06	42	700	1	42
2 to 9	0.08	152	1900	1	152
10 to 49	0.1	441	4410	6	2646
50 to 99	0.12	160	1333	36	5760
100 to 499	0.14	187	1336	80	14960
500 to 999	0.66	60	91	374	22440
1000 and above	0.72	32	44	750	24000
		1074	9814		70000

% of units allocated in the last 2 bands:
(22440 + 24000)/70000 = 66.3%

% of unit holders in last 2 bands against no. of successful applicants:
(60+32)/1074 = 8.57%

Koopa's calculations were accurate. His/her sarcasm on the "reasonable spread of unit holders"was simply brilliant.

I shall provide another calculation to add on to the above.
% of unit holders in last 2 bands against no. of ALL applicants:
(60+32) / 9814 = 0.937%

Less than 1% of all applicants got allocated 66% of the APTT units in the public offer!!


Other thoughts
It seems this balloting ratio turns out to be bad for APTT. When APTT opened today at 2pm, the opening price was $1. It briefly went up to $1.005 for a while and then came tumbling down. At the end of the day, it closed at $0.92 (5c below the IPO price).

I think there are a couple of reasons that could have caused this
1) The higher bands were allocated much more units than they expected. Some of them may have started selling off a large part of their allocated units and triggered other investors to follow suit.

2) There is a sudden fear of rising interest rates. Many REITs and business trusts suffered a 3-6% drop today as well.

In a way, many of us were glad that we were not allocated any units from the IPO. For my APTT units allocated from my MIIF dividend, I will continue to hold them for a while for now.



Related Post:
Asian Pay Television Trust (APTT) IPO balloting ratio

Asian Pay Television Trust (APTT) IPO balloting ratio

The Asian Pay Television Trust (APTT) IPO balloting ratio are out:

The balloting ratios are very disappointing. A few points to note as follows:
1) Some bands are merged as a single band. For example, for most IPO, we will see a 10-19 and 20-49 band. But in this IPO, they are merged as a 10-49 band

2) The balloting ratio jumped significantly from the 100-499 band to the 500-999 band. That is a jump from 14% chance to 66% chance!

3) The number of units allocated are also very high on the higher bands. We seldom see a 75% allocated units in the highest band. It seems that this IPO is favoring the richer folks out there.

For me, I was not allocated any units for this IPO. However, I will be allocated some units from my MIIF as dividends. Good luck to those holding APTT units!

Soilbuild IPO balloting ratio

IPO balloting ratios for Soilbuild is out as follows:

I did not apply for this IPO. The public offer of 2000 lots was just too small. The chances of getting allotted some units is likely to be low. In addition to this, if one is only allotted 1 or 2 lots, he will have problems selling. The IPO price was a $0.25. Selling 1 lot will incur a commission of about 10%!

The balloting results showed that there was only a 8-16% chance of being allotted units. if you applied for less than 50 lots and are allotted units, you will only be allotted 1 lot. Unless the opening price of soilbuild opens high, some share holders may find themselves stuck with their allotted shares.

Asian Pay TV Trust IPO part 2

The pricing for the IPO has been finalized to be $0.97. With this price, the yields work out to be as follows:

In this yield hungry environment, we could see APTT rising on the first day. A recent example was the Croesus Retail Trust (CRT). CRT IPOed at a price of $0.93 for a projected yield of 7.96%. On the 1st day of listing, it closed at $1.145. This is an 23% increase! At this price, it also translate to a yield of 6.46%.

If we were to see a similar yield compression for APTT,
a yield of 7% will result in a price of $1.04 (up 7.2% from IPO price)
a yield of 6.5% will result in a price of $1.12 (up 15.5% from IPO price)

The IPO will close on 27th May 2013 at 12pm. It will then list on 29th May 2013 2pm.
Good luck to those who are applying!


Related post:
Asian Pay TV Trust IPO
APTT offering price and MIIF APTT Units

APTT offering price and MIIF APTT Units

APTT IPO 's price has been fixed at $0.97.
The number of units for MIIF APTT units has been fixed at 525,866,849. Unit holders of MIIF (as of 6 May) could either choose to receive dividends in the form of Asian Pay TV Trust (APTT) units or receive the dividend in cash. The trust will be listed on 29th May.

The calculations for the number of APTT units or cash dividend as as follows:

Units:
APTT units = (S * U) / I  (rounded down to nearest whole number)

S is the number of Shares held by the Shareholder as at the Record Date for which such Notice of Cash Election relates;
U is the number of MIIF APTT Units which equates to 525,866,849 Units;
I is the total issued Shares of MIIF as at Record Date of 1,149,857,154

If you own 1000 MIIF units, you are entitled to:
1000 * 525866849 / 1149857154
= 457.33
= 457 units

If you own 1000 MIIF units, you are entitled to:
4573 units


Cash:
If you are opting for cash, simply calculate the number of entitled APTT units and multiply by the APTT IPO price ($0.97)

If you own 1000 MIIF units, you are entitled to:
457 * $0.97 = $443.29

 If you own 10000 MIIF units, you are entitled to:
4573 * 0.97 = $4435.81



Other notes:
The default option is to receive in APTT units. If you would like to receive the dividend in cash, you need to mail back the notice of cash election.

For unit holders who are interested to apply for the APTT IPO, I would suggest to go for the units option as you are guaranteed the APTT units. If the total units received is not too little for your liking, you could apply additonal units via the IPO.

Asian Pay TV Trust IPO

Asian Pay TV Trust IPO is set to complete in the next few weeks. Details are as follows

Indicative timetable

Other related dates relating to MIIF to note:
Despatch of election form in relation to cash election: 13 May 2013
Expected deadline of cash election: 21st May 2013.
Expected date of crediting APTT units for MIIF unit holders who opt for units: 28 May 2013


Price
offering price of a maximum of $1.
The price will be confirmed on 16th May.

Distributions

Distributions to Unitholders on a semi-annual basis, with the amount calculated as at 30 June and 31 December each year for the six-month period ending on each of the said dates. However, the Trust’s first distribution period will be for the period from the Listing Date to 30 June 2013. The first distribution payment, which will be paid on or before 8 October 2013,

Yield

Gearing 
(based on page A-4 of preliminary prospectus)
1,1103,33 / 2,494,190 = 44.52%

Net asset:
$1,383,857,000

Total units including sponsor and cornerstone investors
1,436,800,000

NAV
$1,383,857,000/1,436,800,000 = $0.96

** to recompute after price is confirmed

Cornerstone investors:

• Asian Century Quest Capital LLC
• Capital Research and Management Company
• Eastspring Investments (Singapore) Limited
• Indus Capital Partners, LLC
• Lion Global Investors Limited
• Signature Global Advisors
• OZ Master Fund, Ltd., Goldman Sachs Profit Sharing Master Trust, Gordel Capital Limited,
  Ozea, L.P., OZ Equity Long-Short Master Fund, Ltd., and OZ Asia Master Fund, Ltd. (the “OZ
  Funds”)
• Quantum Partners LP
• Neuberger Berman LLC

Trust structure

 

Pros

• High yield
• Strong cornerstone investors (e.g. Quantum Vehicle, the investing vehicle of the Soros family;)
• TBC Group is Taiwan’s third-largest cable TV operator. This allows room for growth: the two largest cable TV providers in Taiwan, CNS and Kbro, which as at 31 December 2012, held 26.0% and 23.0% of Taiwan’s paying cable TV market share, respectively, face more stringent growth limitations than the TBC Group as their subscriber base is nearing the one-third national cable TV subscriber cap imposed by Article 21 of the CRTA. The TBC Group is
  below this cap and is well positioned to acquire independent system operators with the capacity to take on an additional 911,659 Cable TV subscribers, which would represent up to 121.3% increase over its existing Basic Cable TV subscriber base.

Cons

• Hard to gauge value of pay tv trust as there isn't much of such business trusts available
• Currency risks (TWD weakening, SGD strengthening)
• Unauthorized usage of pay TV services and piracy

Other thoughts
As a unit holder for MIIF, I am likely to opt for APTT units. In additon to this, I will apply for the IPO as well. I shall wait for the price determination to complete before deciding.

Croesus Retail Trust IPO: balloting ratio

The balloting ratios for Croesus Retail Trust IPO are out:

It seems somewhat weird that the lower bands got a higher balloting ratio than the higher bands. The Croesus Retail Trust will list tomorrow (10th May 2013) at 2pm. Good luck to those who were successful.


Related Posts:
How to read an IPO balloting ratio table
Croesus Retail Trust IPO

CPF minimum sum for Jul 2013 and projections for 30 years

EDIT 2020
This projection is outdated. Please refer to new projection at:
http://madstranger.blogspot.com/2020/02/cpf-full-retirement-sum-projection.html

This post contains the predicted CPF minimum sum which I computed in May 2013.

On May 2014, I did a small revamp to this post as I find it useful to compare my predicted values to the actual values. From 2014 onwards, I will add in the actual inflation rate for the previous year and actual announced minimum sum value in the 2 new columns.

Notes:

1) Every year, the CPF minimum sum is increased to account for inflation.

 2) CPF has set a 120k (in 2003 dollars to hit) by 2015. Before 2015, the CPF minimum sum will also increase by a certain ratio to account for this target

As the CPF minimum sum is largely dependent on the inflation, any changes to inflation rate will affect the CPF minimum sum which will in turn affect our plans for retirement. This projection serves to give us a rough idea of the CPF minimum sum when we retire so that we can better plan for our retirement.

The projected CPF minimum sum are as follows:

 

	CPF Min sum for inflation rate			Actual
Year	3%	4%	5%	Actual inflation	Actual min sum
2014	155,800	157,300	158,800	2.4%	155,000
2015	163,900	167,100	170,300	1.0%	161,000
2016	168,800	173,800	178,800
2017	173,900	180,800	187,700
2018	179,100	188,000	197,100
2019	184,500	195,500	207,000
2020	190,000	203,300	217,400
2021	195,700	211,400	228,300
2022	201,600	219,900	239,700
2023	207,600	228,700	251,700
2024	213,800	237,800	264,300
2025	220,200	247,300	277,500
2026	226,800	257,200	291,400
2027	233,600	267,500	306,000
2028	240,600	278,200	321,300
2029	247,800	289,300	337,400
2030	255,200	300,900	354,300
2031	262,900	312,900	372,000
2032	270,800	325,400	390,600
2033	278,900	338,400	410,100
2034	287,300	351,900	430,600
2035	295,900	366,000	452,100
2036	304,800	380,600	474,700
2037	313,900	395,800	498,400
2038	323,300	411,600	523,300
2039	333,000	428,100	549,500
2040	343,000	445,200	577,000
2041	353,300	463,000	605,900
2042	363,900	481,500	636,200
2043	374,800	500,800	668,000

** each year's value rounded to nearest $100



My other thoughts:

Depending on the inflation rate for the next 30 years, the CPF minimum sum can end up very differently. As seen from the figures above, it works out to a difference of almost 300k! We should plan for our retirement using a higher inflation rate to allow more buffer for ourselves. If inflation rates remain at a level that is higher than the 2.5% and 4% interest rates, Singaporeans are likely to find themselves drifting further and further away from the specified CPF minimum sum.

I would suggest Singaporeans to plan for their own retirements separately and not rely on the the CPF scheme alone for your retirement needs. 

I will try to come up with a more accurate CPF minimum sum estimate for subsequent years when the inflation rates for 2013 are announced. Until then, the above estimates should serve as a good estimate for you.

Other posts relating to CPF minimum sum can be found here:
CPF min sum related posts

REIT Ranking - Apr 2013

REIT ranking for Apr 2013 is as follows:

REIT	Mkt	Yield	NAV	Gearing	P/B	Total	P/B score	Gearing score	Yield score
SaizenREIT	$0.200	6.600%	$0.270	32.00%	0.741	5	3	1	1
LippoMalls	$0.525	5.638%	$0.562	24.50%	0.934	5	2	2	1
Far East HTrust	$1.130	5.358%	$0.970	29.20%	1.165	4	1	2	1
Fortune Reit HK$	$7.200	4.592%	$8.810	23.40%	0.817	4	2	2	0
AscendasHT	$1.020	7.180%	$0.820	35.30%	1.244	3	0	1	2
Sabana REIT	$1.365	7.158%	$1.060	37.70%	1.288	3	0	1	2
CACHE	$1.415	6.403%	$0.960	29.20%	1.474	3	0	2	1
AscottREIT	$1.405	6.231%	$1.320	36.00%	1.064	3	1	1	1
CapitaRChina	$1.685	5.561%	$1.310	25.40%	1.286	3	0	2	1
CDL Htrust	$2.000	5.455%	$1.590	28.30%	1.258	3	0	2	1
Frasers Comm	$1.560	5.173%	$1.500	31.70%	1.040	3	1	1	1
SuntecReit	$1.945	4.646%	$2.035	36.10%	0.956	3	2	1	0
AIMSAMPI Reit	$1.820	6.242%	$1.476	34.00%	1.233	2	0	1	1
MapletreeInd	$1.570	6.038%	$1.100	34.80%	1.427	2	0	1	1
Cambridge	$0.855	5.854%	$0.655	35.30%	1.305	2	0	1	1
Kep REIT	$1.510	5.291%	$1.290	43.30%	1.171	2	1	0	1
MapletreeLog	$1.310	5.282%	$0.900	34.10%	1.456	2	0	1	1
Ascendasreit	$2.750	4.996%	$1.913	28.30%	1.438	2	0	2	0
Starhill Gbl	$0.965	4.964%	$0.960	30.50%	1.005	2	1	1	0
First REIT	$1.435	4.920%	$0.836	27.10%	1.717	2	0	2	0
CapitaComm	$1.710	4.649%	$1.620	30.40%	1.056	2	1	1	0
FrasersCT	$2.250	4.800%	$1.540	30.50%	1.461	1	0	1	0
CapitaMall	$2.320	4.302%	$1.640	35.20%	1.415	1	0	1	0
PLife REIT	$2.670	4.030%	$1.550	32.90%	1.723	1	0	1	0
MapletreeCom	$1.465	4.743%	$1.060	40.90%	1.382	0	0	0	0
MapletreeGCC	$1.115	4.700%	$0.910	43.00%	1.225	0	0	0	0

For how the scores are being calculated:
Reit Rankings - Mad Stranger's scoring system

Disclaimers:

It doesn't mean that if you see a high score for a particular REIT, you rush in to buy. The score system only serves as an indicator on how the REIT is with respect to its yield, P/B and gearing. The ranking is also heavily dependent on the accuracy of the data shown on reitdata.com , investors are advised to do your own cross checking. It is always prudent to do your own research before making any buys or sells.