Advisor calculator: what is a client worth over five years?

1. Ad enquiries = ad spend ÷ cost per enquiry, or (ad spend ÷ cost per click) × click to enquiry rate. Enquiries = ad enquiries + enquiries from other channels. Spend = ad spend + other channels.
2. MQLs = enquiries × % MQL. SQLs (meetings) = MQLs × % met. Fee proposals = meetings × % with a fee proposal. Clients = fee proposals × % signed.
3. Cost per enquiry = spend ÷ enquiries. Cost per meeting = spend ÷ SQLs. Cost per client = spend ÷ clients.
4. Year-one gross profit per client = first fee × gross margin. Year-one profit per client = that − cost per client.
5. Years to count are whole years, at least 1. Client value = first fee + yearly compliance fee × (r + r² + … + r^(years − 1)), where r = % who renew each year: in year k only r^(k − 1) of the clients are still with you. Gross profit over those years = client value × gross margin. LTV:CAC = that ÷ cost per client.
6. Still with you in the last year = 100 × r^(years − 1).
7. Payback: when year one's gross profit covers the cost per client, payback = cost ÷ (year-one gross profit ÷ 12). Otherwise the rest is earned from each later year's gross profit (yearly compliance fee × r^(k − 1) × gross margin in year k), spread over that year's 12 months. 0 when the cost is 0; never when the years you count do not cover it; no answer when the cost has none.
8. The month: first fee = clients × first fee; year-one gross profit = clients × year-one gross profit per client; after marketing = that − spend. Over the years = clients × client value; gross profit after marketing = clients × gross profit over those years − spend.

Green, amber and red compare each result with the break-even your own numbers imply, never with an outside benchmark. Every starting number is an editable example, not an industry average.