Competitor Subscriber Conversion Simulator: Forecast Revenue, CAC and FAT Port Demand

FTTH Strategy • Commercial tools
Competitor Subscriber Conversion Simulator: Forecast Revenue, CAC and FAT Port Demand
Most competitor-acquisition plans answer one question, how many customers can we win, and stop. The board then asks three more. What does it do to revenue and ARPU? Which offer pays back fastest? Will the network in those streets cope? This page works through all four with one illustrative FTTH footprint, shows each result as a moving chart, and explains how to run the same model with your own numbers in the Competitor Subscriber Conversion Simulator.
Quick answer: A competitor subscriber conversion simulator forecasts what winning a rival ISP’s subscribers does to your business. It links three models. Revenue: switch rate, churn and promotion terms give subscriber growth, switcher ARPU and incremental revenue. Acquisition: the promotion, marketing and installation costs give CAC and payback. Capacity: switchers by coverage area give market share and the ODP and PON ports you must add. In our illustrative footprint, 276 switchers over 12 months add Rp 368 juta of revenue, pay back in 6.5 to 9.8 months depending on the offer, lift market share from 34.4% to 40.1%, and need 21 new ODPs costing about Rp 247,5 juta. Run your own numbers on our Tools page.
In this page, a switcher is a household that moves from a competitor to your network. ARPU is average monthly revenue per subscriber; blended ARPU covers all subscribers. CAC is the cost to acquire one switcher, including marketing, installation net of any fee, and the value of the promotion. Payback is the month in which cumulative cash per switcher turns positive. An ODP (optical distribution point), often called a FAT, is the street box with the final splitter and the ports that drop cables connect to. A PON port on the OLT feeds a group of ODPs.
How does converting competitor subscribers change subscriber growth, ARPU and revenue?
Switchers add revenue month by month as they arrive and again when their promotional price ends, while the company’s blended ARPU barely moves. A forecast therefore needs four inputs per month: gross wins, churn among switchers, the promotional price and how long it lasts. The model below uses a Rp 250.000 plan, close to Indonesian list prices for 75 to 100 Mbps plans, which Bisnis.com reported at Rp 233.100 to Rp 279.000 a month in January 2026 (Bisnis.com: home internet prices 2026).
Figure 1 shows why a win count alone misleads. The campaign stops at month 12, yet incremental MRR keeps rising to month 18, from Rp 58,6 juta to Rp 61,5 juta, because cohorts on the six-month promotion move to the full price even as churn takes 1% a month. Over the first 12 months the switchers add Rp 368 juta of revenue. The figures are illustrative; the shape is the point. Switchers are one part of take-rate growth; our FTTH growth strategy guide covers the rest.
Figure 2 separates two ARPU lines that are often confused. Revenue per switcher starts at Rp 200.000 and climbs back to Rp 250.000 as promotions expire. Blended ARPU across 1,650 existing subscribers and the new switchers never falls more than 1.5%, to Rp 246.229. A finance team watching blended ARPU will conclude the promotion is nearly free. It is not; its cost sits in payback, which the next section measures. For reference, IndiHome reported ARPU of Rp 224.000 in Q1 2025 (Bisnis.com), below the list prices above, so use the price switchers actually pay, not a list price. For the wider pricing question, see how fiber providers can grow ARPU without increasing churn.
| Input | Model value | Where to get yours |
|---|---|---|
| Gross wins per month | 23 for 12 months (276) | Past campaign results by area, not a national survey |
| Churn among switchers | 1% a month | Churn of customers acquired in your last promotion |
| Promotional price and length | Rp 200.000 for 6 months | The offer you plan to run |
| Full price | Rp 250.000 | The plan switchers actually choose |
Which promotion gives the best customer acquisition cost and payback?
No promotion gives the lowest CAC and fastest payback per switcher, but richer offers win more households, so the best offer is the one whose extra switchers outweigh its cost and its promotion-end losses. Indonesian operators use all three common incentives. Internet Rakyat, a 5G fixed wireless service, waived the first month and offered free installation and modem rental (Bisnis.com, November 2025). MyRepublic offered new customers a second-month bill of Rp 17.845 before VAT with free installation in August 2026 (Bisnis.com, August 2026). IndiHome and XL SATU listed free installation and a free router or modem in January 2026 (Bisnis.com).
Figure 3 compares four offers per switcher. Marketing cost per switcher falls as the offer improves, because the same Rp 15.000 spent on each targeted household produces more yeses: Rp 300.000 per switcher at a 5% switch rate, Rp 125.000 at 12%. Installation is the largest line in every case. That is why a failed or delayed installation is so expensive in a conversion campaign: the cost is spent and the subscriber never pays. Our ISP Failed Installation Cost Calculator puts a number on that loss.
| Offer | Switch rate | CAC | Payback | Cash after 24 months, per 1,000 targeted |
|---|---|---|---|---|
| No promotion | 5% | Rp 900.000 | 6.5 months | Rp 120,0 juta |
| Free installation | 8% | Rp 1.087.500 | 7.9 months | Rp 177,0 juta |
| Two free months | 11% | Rp 1.236.364 | 9.8 months | Rp 193,7 juta |
| 20% off for 12 months | 12% | Rp 1.325.000 | 8.3 months | Rp 221,2 juta |
The table shows the trade-off a single CAC figure hides. The offer with the highest CAC, 20% off for a year, returns the most cash per 1,000 targeted households by month 24, because it wins more than twice as many switchers as no promotion. Two free months wins almost as many but pays back last, since the network carries the Rp 112.500 monthly service cost while billing nothing, and 10% of those switchers leave when billing starts. All of this depends on the switch rates, which are our assumptions. Test the lift of each offer in one area before rolling it out.
How do you plan market share gains and network capacity for competitor migration?
Model migration by coverage area: each area’s switch rate gives its market share gain, and each area’s spare ODP ports decide whether those switchers can be connected without new build. National figures are a poor guide. Bisnis.com, citing Opensignal, reported Telkomsel at 67% of Indonesia’s fixed broadband market, with ICON+ at about 9% and MyRepublic at about 6.5% (Bisnis.com, November 2025), and national fixed broadband penetration is about 21% (Bisnis.com, October 2025). Inside your footprint the competitor mix can look completely different, street by street.
Figure 5 uses three areas in one illustrative footprint of 9,000 homes passed and 4,800 broadband households. The same campaign produces different switch rates: 12% of competitor customers in the dense estate, 8% on mixed streets, 15% in the new estate. Footprint share rises 5.7 points, from 34.4% to 40.1%, and the competitor falls from 52.1% to 46.3%. Area B, where you are weakest, gains least, which is a messaging question as much as a pricing one. Competing street by street is the core of an FTTH overbuild strategy.
Figure 6 turns those switchers into ports. A study of an Indonesian FTTH design describes splitting 1:4 at the ODC and 1:8 at the ODP (Darsono, Anshori and Hudiono, Jurnal Jartel, 2025), so each ODP offers eight drop ports and four ODPs share one PON port. With an 80% planning threshold, which is our assumption, Areas A and C cross the line and need 14 and 7 new ODPs; Area B absorbs its switchers in existing ports. In total that is 21 ODPs and 6 PON ports, about Rp 247,5 juta at illustrative unit costs.
| Area | Switchers | Share before → after | New ODPs | Capex per switcher |
|---|---|---|---|---|
| A, dense estate | 144 | 37.5% → 43.5% | 14 | about Rp 1,09 juta |
| B, mixed streets | 72 | 28.1% → 32.6% | 0 | Rp 0 |
| C, new estate | 60 | 37.5% → 45.0% | 7 | about Rp 1,31 juta |
The capacity view changes the commercial priority. Area C converts best but needs the most build per switcher; Area B converts worst but every switcher there is connected with no capex. The 276 switchers add Rp 69 juta of MRR at full price, or about Rp 38 juta of monthly gross profit at a 55% margin, so the Rp 247,5 juta build is recovered in about six and a half months on top of each switcher’s own CAC. Capex per switcher allocates PON ports in proportion to new ODPs; it is our arithmetic.
How should an FTTH team run a conversion simulation in a planning meeting?
Agree the inputs by area first, then compare offers, then check capacity before anyone commits budget. This order stops a sales target from being set before the network team has seen it.
- Map the areas. Homes passed, your subscribers, competitor subscribers and ODP ports in use, area by area.
- Set switch rates from evidence. Use past campaigns or door-to-door samples, one rate per area.
- Enter the offers. Installation fee waived or not, free months, discount and length, and expected drop-off at promotion end.
- Read revenue and payback together. Watch switcher ARPU, not only blended ARPU.
- Check ports before launch. Any area over the threshold needs build dates before sales targets.
- Save two scenarios. Compare a discount-led plan with a proof-led plan and take both to the board.
The Competitor Subscriber Conversion Simulator on our Tools page follows this order and keeps assumptions in your browser, so commercially sensitive numbers are not sent to a server.
Competitor subscriber conversion: frequently asked questions
What does a competitor subscriber conversion simulator do?
It forecasts what happens when an FTTH operator wins subscribers from a rival ISP. It turns switch rates, promotion terms and coverage-area data into subscriber growth, ARPU, incremental revenue, customer acquisition cost, payback period, market share and the ODP and PON ports the new customers will need.
How much revenue can converting competitor subscribers add?
In our illustrative model, 23 switchers a month for 12 months, with 1% monthly churn and a six-month Rp 200.000 promotion on a Rp 250.000 plan, add Rp 368 juta of revenue in the first 12 months and Rp 61,5 juta of MRR by month 18. Your result depends on your own switch rate, price and churn.
Does a promotional price lower ARPU?
It lowers the switchers’ ARPU far more than the company’s. In the same model, revenue per switcher starts at Rp 200.000 and reaches Rp 250.000 by month 18, while blended ARPU across 1,650 existing subscribers never falls more than 1.5%. The cost of the promotion appears in payback, so track switcher ARPU separately.
Which promotion has the lowest customer acquisition cost?
In our model, no promotion has the lowest CAC per switcher, Rp 900.000, and the fastest payback, 6.5 months, but it wins only 5% of targeted households. Free installation costs Rp 1.087.500 and pays back in 7.9 months; 20% off for 12 months costs Rp 1.325.000 and pays back in 8.3; two free months costs Rp 1.236.364 and pays back in 9.8.
Are free months or a discount better for winning switchers?
In the model, a 20% discount for 12 months pays back faster than two free months of similar value, 8.3 against 9.8 months, because service costs run during free months while nothing is billed. Real Indonesian offers use both: Internet Rakyat waived the first month, and MyRepublic offered a Rp 17.845 second-month bill in August 2026.
How do you forecast market share gains from competitor conversion?
Model each coverage area separately. Divide your subscribers by the broadband households in the area before and after conversion. In our three-area example, 276 switchers lift footprint share from 34.4% to 40.1% and cut the competitor’s share from 52.1% to 46.3%, with the largest gain in the area with the highest switch rate.
How many ODP ports does competitor migration need?
Add switchers to the subscribers already using each area’s ODP ports and compare the result with a planning threshold. With 8-port ODPs and an 80% threshold, our example needs 14 new ODPs in one area, 7 in another and none in the third: 21 ODPs and 6 PON ports, about Rp 247,5 juta at illustrative unit costs.
Where can I run the simulator?
TheWriter.id publishes its free FTTH planning tools on its Tools page, including the Competitor Subscriber Conversion Simulator. It runs in the browser, stores assumptions locally, and is a planning model only; results are estimates and not guaranteed subscriber, revenue or financial outcomes.
Sources
- Bisnis.com: Home internet prices 2026, Internet Rakyat vs MyRepublic vs IndiHome vs XL SATU (29 January 2026)
- Bisnis.com: MyRepublic Fiber offers Rp 17.845 Merdeka promotion (22 August 2026)
- Bisnis.com: How to get Internet Rakyat’s Rp 0 one-month trial (21 November 2025)
- Bisnis.com: IndiHome (Telkomsel) serves 9.8 million customers in Q1 2025 (6 May 2025)
- Bisnis.com: Opensignal report, Telkomsel holds 67% of Indonesia fixed broadband market (25 November 2025)
- Bisnis.com: Komdigi targets fixed broadband penetration rising from 21% to 50% by 2029 (1 October 2025)
- EY: Households worried about annual broadband price increases (4 December 2025)
- Ofcom: Around 3.5 million Brits hit switch amidst cost-of-living concerns (12 September 2026)
- Darsono, Anshori and Hudiono: Analysis of implementation of branching method in ODP in FTTH, Jurnal Jartel 15(3), 30 September 2025
Figures 1 to 6 and every subscriber, revenue, ARPU, CAC, payback, market share, port and capex figure on this page come from our illustrative model, not from any operator’s data. Its inputs are our assumptions: a Rp 250.000 plan, a 55% gross margin and Rp 112.500 monthly service cost, 23 gross wins a month for 12 months, 1% monthly churn among switchers, Rp 15.000 campaign cost per targeted household, Rp 900.000 installation and ONT cost, a Rp 300.000 installation fee, the switch rates and promotion-end drop-offs shown, three coverage areas, an 80% port threshold, Rp 7,5 juta per ODP and Rp 15 juta per PON port. The Jurnal Jartel study describes one case design, not a national standard; ODP sizes vary by operator. Bisnis.com articles report provider prices and promotions as published at the time and an Opensignal market-share figure without a stated basis. Internet Rakyat is fixed wireless, not fiber. EY’s survey covers 14 countries, not Indonesia, and Ofcom counts switches started in the UK. The simulator is a planning model only; its results are estimates and not guaranteed outcomes.









