Total profit
$176,775
Overall margin
31%
Loss-making customers
1
Customer Profitability Analysis
Revenue, direct costs and cost to serve by customer, with margin, ranking and who is unprofitable.
4 free customer analysis templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 4 spreadsheets from Accounts & Customers, Business Finance and Dashboards & Reporting. Start with Customer Profitability Analysis, Sales Funnel Conversion Analysis and RFM Customer Segmentation: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Total profit
$176,775
Overall margin
31%
Loss-making customers
1
Revenue, direct costs and cost to serve by customer, with margin, ranking and who is unprofitable.
Lead to customer
2%
Proposal win rate
39%
Revenue per lead
$306
Count leads at each funnel stage, see where they drop out and what fixing one stage is worth.
Customers
14
Champions’ share of revenue
48%
Revenue from at-risk customers
$4,600
Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.
Monthly recurring revenue
$197,455
Blended ARPU
$78
Blended monthly churn
4%
Calculate LTV, LTV:CAC and payback by plan, and track how many customers each monthly cohort keeps over time.