Tag Archive for "Virgin" 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.

Our POV: Economy and CPGA Power Virgin Mobile

March 9th, 2009 by arif | 0

<!– /* Font Definitions */ @font-face {font-family:”Cambria Math”; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:”"; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:”Calibri”,”sans-serif”; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:”Times New Roman”; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:”Times New Roman”; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} –>

Virgin Mobile’s recent earning report and the associated announcements point towards a renewed future for prepaid and MVNO wireless programs in the U.S.

While many key components contribute towards the recent surge in this wireless segment, the current economic conditions certainly play an important role on several fronts.

Consider the recent flat monthly prepaid or pay as you go rate products announced by Virgin, Boost and others. But many existing prepaid customers, who make up the majority of Virgin subscribers, spend less than half of the going flat rate plans recently announced for their wireless voice and data needs. Therefore, there is little chance in this economic climate that these subscribers would upgrade their plans and double their monthly spend. Perhaps the silver lining is that some of the lower end of the postpaid subscribers would be encouraged to sign for plans that offer ‘unlimited’ minutes for a flat monthly rate.

Another economic climate contributing factor could be lower churn specifically from ‘switchers,’ who may think twice about an incremental spend on a new handset. Witness Virgin’s quarterly (period ending December 31, 2008) churn drop to 4.8% from 5.1%. The annual churn rate for 2008 compared to 2007, however, rose to 5.2% from 4.9%.

While much is being made about Virgin’s recent quarterly financial performance, especially about the growth in service revenue, the company should also be given credit for dramatically reducing its CPGA (Cost Per Gross Addition). While quarterly and year-over-year gross addition were roughly the same, the company reduced its quarterly CPGA to $101.93 from $120.68 for the same quarter in 2007 or improving a key metric for prepaid MVNOs by more than $17 million.

And while monthly ARPU (Average Revenue Per User) in 2008 increased by $0.78 over the same quarter in 2007, there was a corresponding increase in CCPU (Cash Cost Per User) of $2.22. For the full year, while CCPU was down, so was ARPU.

<!– /* Font Definitions */ @font-face {font-family:”Cambria Math”; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:”"; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:”Calibri”,”sans-serif”; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:”Times New Roman”; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:”Times New Roman”; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} –>

Three Months Ended Year Ended

December 31, December 31,

——————– ——————–

2008 2007 2008 2007

——— ——— ——— ———

(Unaudited) (Unaudited)

Gross additions 960,421 957,541 3,305,857 3,384,460

Churn 4.8% 5.1% 5.2% 4.9%

Net customer additions 216,005 209,669 119,237 511,796

End-of-period customers 5,380,310 5,085,886 5,380,310 5,085,886

ARPU $ 21.14 $ 20.36 $ 20.30 $ 21.24

CCPU $ 13.99 $ 11.77 $ 12.74 $ 13.05

CPGA $ 101.93 $ 120.68 $ 108.68 $ 111.66

Free cash flow $ 25,720 $ 11,206

Unlevered cash flow $ 57,776 $ 62,657

Virgin Mobile reports $4.4M Q4 loss, but boosts revenue

March 3rd, 2009 by admin | 0

Virgin Mobile USA reported a net loss in the fourth quarter of 2008 of $4.4 million, compared to a net loss of $14.7 million in the year-ago quarter. However, the prepaid MVNO had a positive net income of $7.9 million for the full year, compared to $4.2 million for 2007, and increased its subscriber base for the year by 6 percent. 

Revenue: Virgin Mobile had a net service revenue of $326.7 million in the quarter, a 10 percent increase compared to the year-ago quarter. For all of 2008, Virgin Mobile’s net service revenue was $1.2 billion, consistent with net service revenue in 2007.

Subscriber additions: The carrier had 216,000 net additions in the quarter, up 3 percent from the year-ago period. Virgin also reported that it ended 2008 with 5.38 million total subscribers, compared to 5.1 million at the end of 2007. The company said it had more than 3.3 million gross additions during the year.

Churn: The carrier said churn for the fourth quarter was 4.8 percent, down from 5.5 percent in the third quarter of 2008 and 5.1 percent in the year-ago period.

ARPU:
Virgin Mobile reported ARPU of $21.14, a 4 percent increase from $20.36 in the year-ago quarter and a 3 percent bump from the third quarter of 2008. ARPU for the full year was $20.30, a 4 percent decline compared to $21.24 in 2007. The company said ARPU in the fourth quarter benefited from the launch of its revised hybrid plans in the second quarter of 2008.

For more:
- see this release

Related Articles:
Virgin Mobile USA
cuts 10 percent of workforce
Virgin Mobile
launch of Helio Ocean 2 imminent
Virgin Mobile
USA has 216K net adds in Q4
Virgin Mobile USA Q3 earnings beat expectations

See source article.

Versus Technology, Inc. Announces Sale of Real-Time Location System to Virginia Mason Kirkland Clinic

February 26th, 2009 by admin | 0

To complement its process improvement work, Virginia Mason Medical Center has selected Versus Technology, Inc.’s hybrid infrared (IR) and RFID real-time locating system (RTLS), Enterprise VISion: Clinic, to optimize patient flow, staff working environment and overall efficiencies at the Virginia Mason Kirkland clinic in Kirkland, Wash. The primary care clinic, set to open this month in a new location, expects between 300 and 400 patient visits each day and will utilize Versus’ real-time patient tracking to manage the patient experience by reducing wait times and increas

See source article.

Virgin Media shares up on lower customer turnover (AP via Yahoo! Finance)

February 25th, 2009 by admin | 0

Shares of the cable and telecommunications company Virgin Media Inc. made gains Wednesday, helped by fourth-quarter results that showed lower customer turnover.

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.

Virgin Mobile Gets Helio Ocean 2 in Time for V-Day (MobileMag)

January 29th, 2009 by admin | 0

With Virgin Mobile’s relatively recent acquisition of Helio, many of us were left wondering when the MVNO would bring the highly anticipated Helio Ocean 2 into the fray. Well, the wait is about to end.

See source article.

Virgin Mobile tops user satisfaction (CIOL)

January 16th, 2009 by admin | 0

NEW DELHI, INDIA: A nation-wide mobile users’ satisfaction survey, conducted by Voice&Data, reveals that Virgin Mobile topped user satisfaction in 2008 while players like Airtel, BPL, Idea, MTNL and Spice fell short of the benchmark set by telecom watchdog Telecom Regulatory Authority of India (TRAI).

See source article.
-->