Tag Archive for "Postpaid" tag

Our POV: How to estimate AT&T Prepaid Subscribers, ARPU, and Churn

March 10th, 2009 by david | 2 comments

As an analyst in the wireless industry, I was often asked to compare KPIs (Key Performance Indices - subscriber counts, ARPU, Churn, etc.) of various carriers.  Unfortunately, most carriers earnings reports do not provide breakout of KPIs for their prepaid and/or reseller (aka. MVNO) businesses.  Unless they are from a pure-play prepaid provider like Virgin Mobile (now less true with their acquisition of Helio) or Tracfone, prepaid KPIs are not easy to come.

In this article, I will share the method I use to estimate prepaid subscriber count, prepaid ARPU, and prepaid churn for AT&t using its latest 4Q 2008 earnings report.

First, you will have to be fairly familiar with AT&T’s Statement of Segment Income — GAAP for the Wireless segment [master.xls].  Under the tab, Wireless Segment, AT&T provides total Subscriber count, Net adds, Postpaid sub count, churn and its ARPU.  This is great especially AT&T is doing quite well in its postpaid business.  But if you want to get to Prepaid/Reseller ARPU and churn, you’ll have to do some math.   Let’s calculate AT&T’s Prepaid + Reseller :

  • Subscribers (row 40, 41)
  • ARPU (row 59, 60)
  • Churn (row 51, 52)

You can download the work file here in Excel format (see the red Wireless Segment tab).

Prepaid Subscribers

All you need is ONE reasonable assumption, the number of Reseller subscriber in 4Q 2008 to get to the estimated prepaid subscriber count.  Fortunately, we can make one fairly easily since most of their reseller subscribers come from the Tracfone, the largest MVNO in the US.  As of 3Q 2008, Tracfone reported 10.449M subs.  If in 4Q 2008, Tracfone added the same number of subs in as in 4Q 2007, then 10.499M + 711k  = 11.16M (see cell I41).  AT&T has 77M total subs, 60M postpaid subs, and 11.16M reseller subs (est).  So AT&T prepaid subscriber count is 77M - 60M - 11.16M = 5.7M.  We will use this estimate for the rest of the calculation.

Prepaid/Reseller Churn

To estimate the churn, you first calculate the number of disconnects for total subscribers and postpaid subscribers using the reported churn rate (see row 53-55).  As you can see, it looks like the disconnects for Prepaid + Reseller segement would have to be 1.479M for AT&T to have a consolidated total churn of 1.6%.  Hence, the Prepaid + Reseller churn is about 3.1%.  [Gut check: Tracfone's last reported churn rate was 3.6% in 4Q 2007 and 3.8% in 3Q 2008.]  If AT&T’s composite Prepaid + Reseller churn is 3.1% and the Reseller churn (Tracfone’s churn) is ~3.8%, the true AT&T Prepaid churn rate is likely lower than 3%.  This would be quite good for US Prepaid providers.

Prepaid + Reseller ARPU

Estimating ARPU can be done in a similar fashion.   The only thing you need to do is read the Investor Briefing (the pdf file they released).  It states that the Postpaid ARPU was $59.59 in 4Q 2008.  With that plus the total service revenue, you can back out the postpaid only service revenue which you can use to calculate the remainder of the service revenue for the prepaid and reseller segments.  The Prepaid + Reseller service revenue was 955M so using the Prepaid + Reseller subscriber count for 3Q and 4Q we calculated earlier, you can estimate the ARPU.  It turns out the Prepaid + Reseller ARPU was about $19.27.  The true Prepaid-only ARPU for AT&T is likely to be much higher.  Tracfone (reseller) reports ARPU of $11 in 3Q 2008.  Don’t forget that this is at the retail level.  As a wholesaler (AT&T in this case), the ARPU AT&T takes is likely in the $4-6 range depending on the price of the wholesale minute which can range from $0.03-0.08 per minute based on a Tracfone average of 78 MOU (minutes of use).

I hope this has been helpful in estimating AT&T’s prepaid KPIs .  All of these estimates are done using assumptions and should be use for “back-of-the-envelope” calculations only.

T-Mobile USA revenue jumps despite weak subscriber growth

February 27th, 2009 by admin | 0

T-Mobile USA reported a boost in net income and revenue despite a significant drop in subscriber additions. The carrier, a unit of Deutsche Telekom, reported net income for the fourth quarter of 2008 of $483 million, up from $383 million in the year-ago quarter and up from $442 million in the third quarter of 2008.

Revenue: The carrier, the nation’s fourth largest, has service revenues of $4.90 billion in the quarter, up from $4.37 billion in the fourth quarter of 2007. Total revenues were $5.72 billion in the fourth quarter of 2008, up from $5.51 billion in the third quarter of 2008 and $5.07 billion in the year-ago period. T-Mobile said that higher total revenues were driven in part by a jump in demand for new devices like the T-Mobile G1 as well as higher contract revenues stemming from T-Mobile’s February 2008 acquisition of SunCom Wireless.  

Net adds: T-Mobile reported 621,000 net new subscriber additions in the quarter, down from 670,000 in the third quarter of 2008 and 951,000 in the fourth quarter of 2007. The number was the lowest quarterly net subscriber additions since the second quarter of 2006. T-Mobile ended the year with 32.8 million subscribers. The carrier added 4.07 million net new customers in 2008, compared to 3.64 million added in all of 2007. This past year’s total included 2.94 million organic net new customers and 1.13 million that were acquired as part the SunCom acquisition.

Churn: Contract, or postpaid, churn for the fourth quarter was 2.4 percent, the same as the third quarter of 2008 and up from 1.8 percent in the fourth quarter of 2007. Blended churn, including both postpaid and prepaid subscribers, was 3.3 percent in the quarter and up from 3 percent in the third quarter of 2008 and 2.8 percent in the year-ago period. The carrier said its contract churn continues to be affected by the end of two-year contracts, which were first introduced in April 2006, and increased competition.

ARPU: Contract ARPU at the carrier was $54 in the quarter, down from $55 in the third quarter of 2008 and $56 in the fourth quarter of 2007. Blended ARPU was $50 in the fourth quarter of 2008, down from $52 in both the the third quarter of 2008 and the year-ago period.

Data revenue: Data services revenue was $905 million in the quarter, representing 18.5 percent of blended ARPU, up from 15.8 percent of blended ARPU in the fourth quarter of 2007. Data services revenue jumped 31 percent in the fourth quarter of 2008 as compared to the year-ago quarter.

For more:
-see this release
- click here to see all the carrier metrics

Related Articles:
T-Mobile USA has 670K net adds in Q3
T-Mobile adds 668,000 subs, lowest number since 2006
T-Mobile
will have 3G in 27 markets by year’s end
With little fanfare, T-Mobile launches 3G in New York
T-Mobile launches UMTS in Las Vegas

See source article.

MetroPCS, Leap, Virgin stay strong despite economic downturn

February 12th, 2009 by admin | 0

Some wireless segments, such as prepaid are thriving as consumers turn to wireless providers that don’t require two-year contracts and credit checks. 

By Jim Barthold

The wireless industry is happily bobbing like a buoyant cork while most others sink in the economic red ink sea. In fact, some parts of the industry-prepaid or pay-in-advance–are actually exuberantly hanging five on the market’s turbulent waves.

But this positive picture does not necessarily hold true for all of telecom. Some wireless industry segments such as handsets and all the pieces that contribute to a handset, are taking on water. The wireline space is sinking like a rock with no bottom in sight. Still, considering the daily doses of bad news coming from Wall Street, Pennsylvania Ave., and Main Street, the wireless guys are doing pretty well.

“We’re going through the worst economic downturn in our lifetime (and) we’re seeing more innovation in electronics and mobile products than ever before,” said Jim McGregor, chief technology strategist for In-Stat.

This innovation is driven partially a way to build orders by creating “device envy” among wireless users and partially by the circumstances of a product development cycle where chipmakers start product designs up to four years in advance. It’s also leading industry bifurcation.

“On the high end you’re seeing a lot of device envy that’s prying people away from their existing plans and getting them to move across carriers. On the other end of the spectrum you’re seeing people seeking out value who want a good handset with a camera, QWERTY keyboard, great pricing and lots of flexibility so they can adjust their spending on a monthly basis,” said Bob Stohrer, chief marketing officer of prepaid giant Virgin Mobile.

As for the rest, “a lot of people would tell you the middle of the market, maybe having a decent phone on a postpaid plan, is going away right now,” he continued.

The big carriers, AT&T, Verizon Wireless, T-Mobile USA and to some extent Sprint Nextel are all doing pretty well convincing consumers, at least now, that they need the latest bells and whistles to match the iPhone. The plan is working as long as these subscribers take those services at the expense of something else and right now that something else is wireline.

The market’s real winners, though, are the non-traditional carriers who have earned their niche via a Statue of Liberty strategy of welcoming the poor, the tired and the huddled masses yearning to breathe free.

“As the economy has worsened, we’ve actually found our service to be in demand by a lot more segments,” said Tom Keys, chief operating officer of MetroPCS.  

Some sort of mobile phone is becoming as necessary as breathing in a connectivity-conscious society. People will discard their wired phones in favor of the flexibility of wireless. That starts with a good basic phone but, more and more, includes a lot of the features that used to be associated with high-end contract carriers.

“Even though we have customers that are earning $50,000 and under a year (some as low as $15,000), they want as much technology as they can afford,” said Greg Lund, a spokesman for Leap Wireless. “They’re not coming in and looking for the rock-bottom price on handsets all the time.”

You won’t get a $500 combo WiFi, WiMAX, 3G smartphone from Leap. But you also won’t get the wireless equivalent of a basic phone either, he said.

At Virgin, the rate plan is the draw. “You look at the impact of the economy on somebody like Virgin Mobile and you’ll see that our active customers are self-optimizing and as a result some of them are using less,” said Stohrer, who also said, surprisingly, that a greater number of customers are “looking for something that looks like a traditional contract plan” that Virgin offers with a monthly deal.

Flexibility, he said, is as important as understanding what your customer base can handle.”We see a lot of customers out there today who are no longer eligible for contract plans move into the category. People who would typically pass a credit check can’t anymore and they’re coming into this category,” he said.  Once there, they can “easily move” between plans that meet their financial needs “and take their spending down $10 or $15 a month until they’re ready to start spending more.”

The trick for these carriers is not attracting new customers, but keeping them when things improve. Key’s predicts that could be as far as three years out. When that day comes, though, these new subs might wander off to carriers with more full-featured devices and plans. “The need for a wireless phone is only going to increase. It’s no longer a luxury; it’s a must-have category,” he agreed.

To fight this potential loss, carriers are offering full-featured phones and better networks and some are even perusing femtocells as a way to make a wireless subscriber really attached to that phone. “We see a lot of interest from the MVNOs who want their offering to be a little bit different and will focus on an offering that might be placed in a retail environment or in the home,” said Simon Saunders, chairman of the Femto Forum. The Femto Forum believes the femtocell proposition of boosting the value of a device by increasing its capabilities will be a big seller in a down economy.

The prepaid carriers, though, are somewhat wary. These are not companies that go out of their way to add cap ex to the budget by committing to cutting-edge devices. “I don’t like the term fast-follower, but you’re not going to see us with the latest and greatest,” admitted Lund, whose company is offering a broadband product designed for laptops and desktops where the uptake has been “a pleasant surprise for us,” he said.

Virgin Mobile is finding similar success with texting services. “Text is the new talk,” Stohrer said. “Our customers are sending and receiving as many text messages as they are using minutes of call time right now” and the carrier might be interested in femtos if they helped consumers better use this capability.

MetroPCS is probably the least interested of the three when it comes to a device intended to boost a mobile signal or offload data traffic. However, the company doesn’t totally dismiss femtocells. “A lot of our new market builds, Philadelphia, New York or Boston were built with DAS (distributed antenna systems) that are nodes on telephone poles right close to the home to improve in-building penetration,” Keys said. “We think the in-building penetration we provide gives us phenomenal coverage where you can utilize our phone in the home as well as throughout the area that you live in.”

Femtocells might help, however. “We just think that at some point in time the retail price has to come down the curve to be a bit more affordable… a sub-$90 price,” he said.

These types of carriers, despite wishful thinking by the Femto Forum, “won’t drive innovation,” McGregor said. What will is an industry-wide urge to continue to move forward with plans that have been in preparation for years. “There’s a lot of innovation that’s enabled both from the silicon content, from the applications on the Web… and in terms of the business model. Service providers can look at different models and maybe find one that may be more attractive to consumers,” said McGregor. “The main part of the ecosystem from the service providers to the device OEMs and ODMs to the service and technology companies are going to be pushing innovation to new levels. If nothing else the downturn makes them focus on that even further.” Click here for more MetroPCS pics…

See source article.

Boost Mobile chief: Unlimited plan picking off T-Mobile customers

February 9th, 2009 by admin | 0

The head of Boost Mobile, Sprint Nextel’s prepaid unit, said that Boost’s $50 per month unlimited plan has been doing well since it was introduced nearly a month ago. Matt Carter, the unit’s president, said that the unlimited plan has not resulted in cannibalization of Sprint customers. Instead, he said postpaid subscribers are migrating from T-Mobile USA over to the Boost plan. Article

See source article.

Our POV: Verizon and others losing market shares to AT&T

February 3rd, 2009 by david | 0

The recent 4Q 2008 earnings simply reinforced the facts.  Verizon, T-Mobile, and Sprint are not losing market share to AT&T.

Take a look at their respective net adds (show below).  Clearly, no one expected net adds will grow in a saturating mobile market.  As can be seen in the yearly numbers, net adds across the carriers dropped YOY.   But AT&T dropped the least among the three here.

4q2008-report-card1

What is more impressive is when you look closer at the postpaid net adds.  AT&T increased the number of postpaid net adds from 4Q 2007 while Verizon and T-Mobile dropped significantly.  The effect of adding more new subs into your base also helps reduce churn which can be seen at AT&T while again Verizon and T-Mobile showed higher churn than the previous year.

If this continues and Verizon is not able to introduce new devices that will slow the iPhone love affair, I might want to entice consumers with more attractive offers on their rate plans.  They are currently the most expensive among the four national carriers (given others offer bonuses like 7pm nights, rollovers, etc.).

Our POV: Are iPhone subs too costly for AT&T?

February 3rd, 2009 by david | 0

Some have criticized AT&T’s increase in acquisition cost in 2008 especially when it picked up fewer net subscribers for dollars spent than it did in 2007.  However, 2007 was the year when it acquired massive number of low quality subscribers from prepaid.  With higher churn, lower ARPU, and intense competition, these prepaid subscribers can have a lifetime value 3-5x lower than an average postpaid subscriber.

Let’s look at the numbers more closely…..

AT&T spent $13B in 2007 for Selling, General, and Administrative expense vs. $14B.  So roughly the same.  However, in 2007 it picked up roughly 5.3M net additional subscribers while only 4.7M in 2008.  But of the 5.3M in 2007, one out of four were prepaid subscribers whereas in 2008 nearly all net adds were postpaid.

Not only were they postpaid subscribers, they were mostly iPhone postpaid subscribers that have a reportedly 1.6x ARPU than the average postpaid subscriber.  Extracting the numbers from the Investor Briefing, more than 50% of all postpaid gross adds where iPhones (1.9M out of the 3.5M total in postpaid) coupled with 60% of the net adds being smartphone subscribers……I would say the increase in acquisition cost was money well spent.  (I don’t buy the lower churn rate of iPhone subs yet since these subs have not been around long enough.)

But don’t iPhone subs cost more to acquire and it is hurting AT&T’s CPGA and bottom line as can be seen in the recent earnings??

Not true.  Despite the heavy acquisition cost for a iPhone sub as can be seen by the earnings shortfall at AT&T, in the long run, the residual value from higher iPhone ARPU and lower churn should justify the investment.  Assume that the iPhone is subsidized an additional $200 in CPGA. If ARPU was truly 1.6x higher than average postpaid ARPU, $60x.6 = $36.  $36 x 40% margin = $14.40 in additional gross contribution per month.  Hence, the breakeven point for the additional $200 in CPGA is a little more than 1 year ($200/14.40 = 14 months). This seems well worth the investment given that the subs are under a 2-year contract.

-->