Modeling lifetime value for postpaid, prepaid and IoT lines

# Modeling lifetime valuelifetime valueLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.View full definition → for postpaid, prepaid and IoT lines

A telecom marketing team runs one LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.View full definition → number across the whole subscriber base: $1,850. It gets used to set acquisition budgets for a family postpaid plan, a $20 prepaid top-up user, and a connected car SIM. The problem: those three customers have wildly different margins, churn patterns and revenue trajectories. Blending them into one figure means overspending on the low-value segment and underspending on the high-value one. This lesson builds separate LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.View full definition → models for each.

Why one blended LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.View full definition → 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.View full definition → 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.View full definition → 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.View full definition → 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.View full definition →: 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.View full definition → = ($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.View full definition → 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.View full definition →, 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.View full definition →: 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.View full definition →: 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.View full definition → = ($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.View full definition → (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.View full definition →) target derived from blended LTVLTVLifetime Value: the total revenue (or profit) a customer generates throughout their entire relationship with your business.View full definition →, 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.View full definition →: 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.View full definition → = ($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.View full definition → 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.View full definition →.

Building a three-line model

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

Segment      | ARPU  | Margin% | Monthly Churn | LTV
Postpaid     | $50   | 60%     | 1.2%          | $2,500
Prepaid      | $32   | 50%     | 4.0%          | $400
IoT (per SIM)| $4    | 70%     | 0.3%          | $933

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.View full definition → 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.View full definition → 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.View full definition → 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. 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.View full definition →, 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.View full definition → 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.View full definition → 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