Revenue Projection Calculator
Try Change Monthly Churn (%), then press Calculate revenue.
Observe After Calculate revenue, watch Final Customers, Monthly Revenue, and Total Profit.
Explain Explain why Monthly Churn (%) changes Final Customers after Calculate revenue.
Calculate revenue
Reset
Technical boundaries. The projection uses one set of assumptions throughout the period. New customers, churn, ARPU, and gross margin remain constant.
Revenue Projection Calculator
Model revenue growth with customer acquisition and churn:
viewof initialCustomers = Inputs. range ([0 , 1000 ], {
label : "Initial Customers" ,
step : 10 ,
value : 10
})
viewof newCustomersPerMonth = Inputs. range ([1 , 100 ], {
label : "New Customers per Month" ,
step : 1 ,
value : 5
})
viewof proj_arpu = Inputs. range ([10 , 1000 ], {
label : "Monthly ARPU ($)" ,
step : 10 ,
value : 500
})
viewof proj_churn = Inputs. range ([0.5 , 10 ], {
label : "Monthly Churn (%)" ,
step : 0.5 ,
value : 3
})
viewof proj_margin = Inputs. range ([50 , 95 ], {
label : "Gross Margin (%)" ,
step : 5 ,
value : 75
})
viewof projectionMonths = Inputs. range ([6 , 36 ], {
label : "Projection Period (months)" ,
step : 6 ,
value : 12
})
projectionChurnRate = proj_churn / 100
projectionMarginRate = proj_margin / 100
revenueProjectionData = {
let customers = initialCustomers
let data = []
for (let month = 1 ; month <= projectionMonths; month++ ) {
const churned = customers * projectionChurnRate
customers = customers - churned + newCustomersPerMonth
const revenue = customers * proj_arpu
const profit = revenue * projectionMarginRate
data. push ({
month : month,
customers : Math . round (customers),
revenue : revenue,
profit : profit
})
}
return data
}
projectionFinalCustomers = revenueProjectionData[revenueProjectionData. length - 1 ]. customers
projectionFinalRevenue = revenueProjectionData[revenueProjectionData. length - 1 ]. revenue
projectionFinalProfit = revenueProjectionData[revenueProjectionData. length - 1 ]. profit
projectionTotalRevenue = d3. sum (revenueProjectionData, d => d. revenue )
projectionTotalProfit = d3. sum (revenueProjectionData, d => d. profit )
// Create chart
Plot. plot ({
title : "Customer Growth & Revenue Projection" ,
width : 700 ,
height : 300 ,
marginLeft : 60 ,
marginBottom : 40 ,
grid : true ,
x : {
label : "Month" ,
domain : [0 , projectionMonths]
},
y : {
label : "Customers" ,
domain : [0 , Math . max (... revenueProjectionData. map (d => d. customers )) * 1.1 ]
},
marks : [
Plot. line (revenueProjectionData, {
x : "month" ,
y : "customers" ,
stroke : "#0F766E" ,
strokeWidth : 3
}),
Plot. dot (revenueProjectionData, {
x : "month" ,
y : "customers" ,
fill : "#1F2937" ,
r : 4
}),
Plot. ruleY ([0 ])
]
})
html `
<div style="background: linear-gradient(135deg, #B45309 0%, #B91C1C 100%); padding: 25px; border-radius: 8px; color: white; margin: 15px 0;">
<h3 class="fm-panel-title">Projection Results ( ${ projectionMonths} months)</h3>
<div class="fm-kpi-grid">
<div class="fm-card" style="background: rgba(255,255,255,0.15); padding: 15px; border-radius: 6px;">
<div style="font-size: 13px; opacity: 0.9;">Final Customers</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;"> ${ projectionFinalCustomers. toLocaleString ()} </div>
<div style="font-size: 12px; opacity: 0.8; margin-top: 3px;">from ${ initialCustomers} </div>
</div>
<div class="fm-card" style="background: rgba(255,255,255,0.15); padding: 15px; border-radius: 6px;">
<div style="font-size: 13px; opacity: 0.9;">Monthly Revenue</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;"> ${ "$" }${ projectionFinalRevenue. toLocaleString (undefined , {maximumFractionDigits : 0 })} </div>
<div style="font-size: 12px; opacity: 0.8; margin-top: 3px;">at month ${ projectionMonths} </div>
</div>
<div class="fm-card" style="background: rgba(255,255,255,0.15); padding: 15px; border-radius: 6px;">
<div style="font-size: 13px; opacity: 0.9;">Monthly Profit</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;"> ${ "$" }${ projectionFinalProfit. toLocaleString (undefined , {maximumFractionDigits : 0 })} </div>
<div style="font-size: 12px; opacity: 0.8; margin-top: 3px;">at ${ projectionMarginRate * 100 } % margin</div>
</div>
<div class="fm-card" style="background: rgba(255,255,255,0.15); padding: 15px; border-radius: 6px;">
<div style="font-size: 13px; opacity: 0.9;">Total Revenue</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;"> ${ "$" }${ projectionTotalRevenue. toLocaleString (undefined , {maximumFractionDigits : 0 })} </div>
<div style="font-size: 12px; opacity: 0.8; margin-top: 3px;">cumulative</div>
</div>
<div class="fm-card" style="background: rgba(255,255,255,0.15); padding: 15px; border-radius: 6px;">
<div style="font-size: 13px; opacity: 0.9;">Total Profit</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;"> ${ "$" }${ projectionTotalProfit. toLocaleString (undefined , {maximumFractionDigits : 0 })} </div>
<div style="font-size: 12px; opacity: 0.8; margin-top: 3px;">cumulative</div>
</div>
<div class="fm-card" style="background: rgba(255,255,255,0.15); padding: 15px; border-radius: 6px;">
<div style="font-size: 13px; opacity: 0.9;">Customer Growth</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;"> ${ ((projectionFinalCustomers - initialCustomers) / initialCustomers * 100 ). toFixed (0 )} %</div>
<div style="font-size: 12px; opacity: 0.8; margin-top: 3px;">over period</div>
</div>
</div>
<div style="margin-top: 20px; padding: 15px; background: rgba(0,0,0,0.2); border-radius: 6px; font-size: 13px;">
<strong>Business Dynamics:</strong> ${
projectionFinalCustomers < initialCustomers ? "Negative growth - churn exceeds acquisition. Need to reduce churn or increase new customer acquisition." :
newCustomersPerMonth < (projectionFinalCustomers * projectionChurnRate) ? "Approaching equilibrium - acquisition and churn will balance soon." :
"Positive growth trajectory - acquisition exceeds churn losses."
}
</div>
</div>
`
The projection calculator checks growth under one set of assumptions. The next financial question is whether the platform cost structure still works when device count, message volume, storage, support, and integrations arrive.
Back to the chapter