Slacker:
The equipment cost. That was the only number I missed. The rest were fine. Here is an old post of mine.
Message 17341331
The Q1 2002 actual numbers are also listed below for comparison.
>Do you think we can do a consolidated 37 million EBITDA loss in Q1?> In Thousand of Dollars
Service Revenue 135,500 <Actual 128,000>
(Based on $36 ARPU, and average 1,255,000 <Actual 1,260,679> average subs)
Equipment Rev. 10,300 <Actual 12,200>
(Based on gross adds of 395000 <Actual 391,417> and $26/gross add)
Total Revenue 145,800 <Actual 140,200>
Cost of Service 44,000 <Actual 41,891>
(Based on about $11.7/sub/month, Q4 2001 was $13.9/sub/month)
Cost of Equipment 63,000 <Actual 84,011> BIG MISS!
(Based on $160/unit) <Actual $215>
Selling & Marketing 32,000 <Actual 30,159>
Q4 2001 S&M was 44,000. 8,500 of it was related to startup costs ($18/gross add, $246-$228=$18). That leaves 35,500. About half of S&M is advertizing. The costs should come down as markets mature. With some more efficiencies in reseller sales, 32,000 seems reasonable.
G&A 44,000 <Actual 49,994>
(PCSTEL, you have been suggesting 40,000. I am being a little more cautious here. So the 44,000)
Expenses (w/o D&A) 183,000 <Actual 205,000>
EBITDA (37,200) <Actual 65,800>
Comments?
Arun |