Modeling lifetime value for postpaid, prepaid and IoT lines

Why one blended LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → breaks

LTV (customer lifetime value) is the total gross profit a company expects to earn from a customer over the relationship, discounted for time and adjusted for the probability they stay.

The generic formula:

LTV = (ARPU × Gross Margin %) ÷ Churn Rate

Where ARPU (Average Revenue Per User) is monthly revenue per subscriber, gross margingross marginGross margin is the share of revenue left after subtracting the direct cost of producing goods or services, expressed as a percentage of revenue.Voir la définition complète → strips out network and service costs, and churn ratechurn rateChurn rate is the percentage of customers or revenue lost over a period. It measures how fast a business loses its existing customer base.Voir la définition complète → is the monthly probability a customer leaves.

This formula works fine for a single, homogeneous base. Telecom bases are not homogeneous. Postpaid, prepaid and IoT lines differ on every input: ARPU level, margin structure, tenure, and even what "churn" means.

Postpaid: high ARPU, sticky, contract-bound

Postpaid customers pay a monthly bill, often under contract or device financing, frequently bundled into family or multi-line plans.

Key characteristics (US market estimates, as of 2025):

• Postpaid ARPU: roughly $45 to $55 per line (FCC and carrier 10-K disclosures, figures vary by carrier)
• Monthly churn: often below 1% for major US carriers
• Gross marginGross marginGross margin is the share of revenue left after subtracting the direct cost of producing goods or services, expressed as a percentage of revenue.Voir la définition complète → on service revenue: commonly cited in the 55 to 65% range once network and customer service costs are allocated

Worked example:

• ARPU: $50/month
• Gross marginGross marginGross margin is the share of revenue left after subtracting the direct cost of producing goods or services, expressed as a percentage of revenue.Voir la définition complète →: 60%
• Monthly churn: 1.2% (average tenure ≈ 1 ÷ 0.012 ≈ 83 months)

LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → = ($50 × 0.60) ÷ 0.012 = $30 ÷ 0.012 = $2,500

Family plans complicate this further: a fourth line added to an existing account often has near-zero incremental acquisition costacquisition costCustomer Acquisition Cost (CAC) is the total sales and marketing spend divided by the number of new customers gained in a period. It measures how efficiently you grow.Voir la définition complète → and lower standalone ARPU, but it raises household stickiness (multi-line households churn less because switching means moving the whole family). Model family lines as an *increment* to household LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète →, not a standalone customer.

Prepaid: low ARPU, no contract, volatile tenure

Prepaid users pay in advance, often with no credit check and no annual contract. This segment includes cost-sensitive consumers and, in the US, a meaningful share of subscribers without a bank-linked payment method.

Key characteristics (estimates, US, 2025):

• Prepaid ARPU: roughly $30 to $38 per month
• Monthly "churn" is harder to define: many prepaid users simply stop topping up rather than formally canceling. Operators use base management churn, typically inactive after 60 to 90 days without a recharge
• Effective monthly churn: often 3 to 5%, several multiples of postpaid
• Gross marginGross marginGross margin is the share of revenue left after subtracting the direct cost of producing goods or services, expressed as a percentage of revenue.Voir la définition complète →: often thinner (45 to 55%) because prepaid leans on lower-cost distribution but also carries promotional discounting

Worked example:

• ARPU: $32/month
• Gross marginGross marginGross margin is the share of revenue left after subtracting the direct cost of producing goods or services, expressed as a percentage of revenue.Voir la définition complète →: 50%
• Monthly churn: 4% (average tenure ≈ 25 months)

LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → = ($32 × 0.50) ÷ 0.04 = $16 ÷ 0.04 = $400

That is roughly one-sixth of the postpaid figure. If a marketing team applies a $150 CACCACCustomer Acquisition Cost (CAC) is the total sales and marketing spend divided by the number of new customers gained in a period. It measures how efficiently you grow.Voir la définition complète → (customer acquisition costcustomer acquisition costCustomer Acquisition Cost (CAC) is the total sales and marketing spend divided by the number of new customers gained in a period. It measures how efficiently you grow.Voir la définition complète →) target derived from blended LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète →, it will happily overspend acquiring prepaid users whose payback never arrives, while underspending on postpaid customers worth six times more.

IoT/Connected-device sims: low ARPU, extreme tenure, different margin logic

IoT (Internet of Things) lines cover connected cars, smart meters, asset trackers, POS terminals, and industrial sensors. This is one of the fastest-growing connection categories for operators like Verizon, AT&T, T-Mobile, Vodafone and Deutsche Telekom, even though per-unit revenue is small.

Key characteristics (estimates, 2025):

• ARPU: often $2 to $10/month per SIM, sometimes less on high-volume enterprise contracts
• Churn: extremely low at the connection level (a smart meter or car module rarely "switches carriers" individually; churn happens at the fleet/contract level when an enterprise renegotiates or migrates)
• Contract tenure: often 3 to 10 years, tied to hardware lifecycle (a car's connectivity module lasts as long as the car)
• Margin: high in percentage terms (data volumes are tiny) but the absolute dollar profit per line is small; profitability instead comes from volume and contract renewal value, not per-user monetization

Worked example:

• ARPU: $4/month
• Gross marginGross marginGross margin is the share of revenue left after subtracting the direct cost of producing goods or services, expressed as a percentage of revenue.Voir la définition complète →: 70% (low servicing cost per connection)
• Effective monthly churn: 0.3% (driven by contract-level events, not individual disconnects)

LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → = ($4 × 0.70) ÷ 0.003 = $2.80 ÷ 0.003 = ≈ $933

Notice this is close to the prepaid figure despite ARPU being 8x lower. The entire driver is tenure. IoT economics reward radically different marketing behavior: acquisition happens at the enterprise contract level (a single deal can add hundreds of thousands of SIMs), so CACCACCustomer Acquisition Cost (CAC) is the total sales and marketing spend divided by the number of new customers gained in a period. It measures how efficiently you grow.Voir la définition complète → should be measured per contract or per fleet, not per connection. A B2B sales cycle and channel partnership matter more than a consumer acquisition funnelfunnelThe customer journey from awareness to purchase, typically Awareness, Interest, Consideration, Decision, Action, with prospects narrowing at each stage.Voir la définition complète →.

Building a three-line model

A practical approach: keep one spreadsheet, three tabs, one shared structure.

Then apply segment-specific CACCACCustomer Acquisition Cost (CAC) is the total sales and marketing spend divided by the number of new customers gained in a period. It measures how efficiently you grow.Voir la définition complète → targets. A common industry heuristic is to keep LTV:CAC ratio above 3:1, though this originated in SaaS (software-as-a-service) marketing and should be treated as a directional benchmark, not a telecom-specific rule. Applied here:

• Postpaid: CACCACCustomer Acquisition Cost (CAC) is the total sales and marketing spend divided by the number of new customers gained in a period. It measures how efficiently you grow.Voir la définition complète → ceiling ≈ $833
• Prepaid: CACCACCustomer Acquisition Cost (CAC) is the total sales and marketing spend divided by the number of new customers gained in a period. It measures how efficiently you grow.Voir la définition complète → ceiling ≈ $133
• IoT per SIM: CACCACCustomer Acquisition Cost (CAC) is the total sales and marketing spend divided by the number of new customers gained in a period. It measures how efficiently you grow.Voir la définition complète → ceiling ≈ $311 (but realistically measured per enterprise contract, spread across thousands of SIMs)

This is why prepaid marketing in Europe and the US leans on low-cost channels (retail top-up displaysdisplaysThe total number of times an ad or piece of content is displayed, regardless of clicks. Each display counts as one impression, even to the same person.Voir la définition complète →, SMS retention offers) while postpaid can sustain paid device subsidies and higher-touch retail acquisition.

Adjusting for discounting and cross-sell

Two refinements matter for MBA-level rigor:

1. Discount future cash flows. A customer worth $2,500 over 83 months is not worth $2,500 today. Applying a simple annual discount rate (many telecom finance teams use figures in the 8 to 12% range for internal modeling, always an estimate specific to the firm's cost of capital) reduces long-tenure LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → meaningfully. IoT's multi-year tenure is especially sensitive to this adjustment.

2. Layer in cross-sell and upsell. Postpaid LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → should include the probability of upgrading a line to unlimited data, adding a streaming bundle, or adding a family member. European operators (Vodafone, Orange, Deutsche Telekom) increasingly model household LTV across mobile, broadband and TV bundles rather than single-product LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète →, since bundled customers churn at roughly half the rate of single-play customers in several published operator disclosures.

🎬 [VIDEO: "Customer Lifetime ValueCustomer Lifetime ValueLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → Explained" - https://www.youtube.com/results?search_query=customer+lifetime+value+explained+telecom - a primer on CLVCLVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → mechanics applicable across subscription industries, useful for reinforcing the core formula before applying it to telecom segmentssegmentsDividing a market into distinct groups of customers who share similar needs, characteristics or behaviours, so each group can be served with a tailored approach.Voir la définition complète →]

Key Takeaways

• Never use one blended LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → across postpaid, prepaid and IoT: ARPU, margin and churn differ by multiples across segmentssegmentsDividing a market into distinct groups of customers who share similar needs, characteristics or behaviours, so each group can be served with a tailored approach.Voir la définition complète →, and a shared number misallocates acquisition budget.
• Postpaid LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.Voir la définition complète → is driven by high ARPU and low churn (US estimate: roughly $2,000 to $2,500 per line); prepaid is driven down by high churn despite lower ARPU (often under $500); IoT depends almost entirely on multi-year contract tenure, not per-unit revenue.