Nice — thanks for confirming the LTV = 6 × FTD rule. I ran the numbers using that and here’s the clean breakdown and what it means for your $20,250,000 target.
Per-bracket (LTV = 6×FTD),
| Bracket | Clients | FTD | LTV (6×FTD) | Bracket contribution |
|---|---|---|---|---|
| 1 | 1,000 | $250 | $1,500 | $1,500,000 |
| 2 | 750 | $1,000 | $6,000 | $4,500,000 |
| 3 | 500 | $2,500 | $15,000 | $7,500,000 |
| 4 | 400 | $5,000 | $30,000 | $12,000,000 |
| 5 | 350 | $7,500 | $45,000 | $15,750,000 |
| Total | 3,000 | — | — | $41,250,000 |
Key takeaway
With LTV = 6 × FTD across all brackets, your total projected revenue = $41,250,000.
That exceeds your stated target ($20,250,000) by $21,000,000, which is 103.70% over the target.
If you must hit the $20,250,000 target
You have two straightforward choices:
Keep brackets 1 & 2 at 6× and lower the LTV multiplier for brackets 3–5
Required common multiplier for brackets 3–5 = ≈ 2.4255× FTD (so e.g. bracket3 LTV ≈ $2,500×2.4255 ≈ $6,064).
That was the multiplier I computed earlier to make the grand total exactly $20,250,000 while leaving brackets 1 & 2 unchanged.
Keep a flat multiplier across all brackets but smaller than 6×
Scale factor needed = $20,250,000 ÷ $41,250,000 = 0.49.
So a universal multiplier would be 6 × 0.49 ≈ 2.94× (i.e., LTV ≈ 2.94 × FTD for every bracket).
Quick suggestions
If bracket 1 & 2 are historically 6× (you’ve observed that), prefer option (1) and model realistic LTVs for higher-FTD clients (3–5) separately — it’s common for larger FTD clients to have lower multiples.
If you want, I can:
Recalculate the full bracket table using the required 2.4255× for brackets 3–5 (showing exact LTVs & contributions).
Show scenarios: e.g., what happens if bracket 3 = 4×, bracket 4 = 3×, bracket 5 = 2×, etc.
Export a CSV or quick spreadsheet with these scenarios.
Which of those would you like me to do next?
