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),

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:

1. 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.

2. 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?

Perfect — let’s carefully calculate the adjusted revenue after all the deductions you mentioned. We’ll go step by step, using your LTV = 6×FTD for each bracket.

1️⃣ Original total projected revenue (LTV = 6×FTD)

2️⃣ Deduct clients who will not fulfill their LTV (10%)

10% of total projected revenue = 10% × 41,250,000 = 4,125,000

Revenue after LTV defaults:
41,250,000 − 4,125,000 = 37,125,000

3️⃣ Deduct withdrawals (25% of remaining balance)

25% of remaining revenue = 25% × 37,125,000 = 9,281,250

Revenue after withdrawals:
37,125,000 − 9,281,250 = 27,843,750

4️⃣ Deduct processing fees (3% of remaining revenue)

3% × 27,843,750 = 835,312.50

Revenue after processing fees:
27,843,750 − 835,312.50 = 26,998,437.50

✅ 5️⃣ Adjusted projected revenue

$26,998,438 (rounded to the nearest dollar)

Summary of deductions

If you want, I can also show this per bracket, i.e., how much revenue remains per client tier after LTV defaults, withdrawals, and fees — which is often very useful for cashflow and forecasting.

Do you want me to do that next?

Perfect — let’s break it down per bracket, applying the deductions step by step:

• Step 1: Original LTV = 6×FTD

• Step 2: Deduct 10% of clients who will not fulfill LTV

• Step 3: Deduct 25% withdrawal of remaining revenue

• Step 4: Deduct 3% processing fees

1️⃣ Original LTV per bracket

2️⃣ Deduct 10% of clients who will not fulfill LTV

• 10% reduction per bracket:

3️⃣ Deduct 25% withdrawals of remaining revenue

• 25% of each bracket’s remaining contribution:

4️⃣ Deduct 3% processing fees

• 3% of each bracket after withdrawal:

✅ Final Adjusted Revenue per Bracket

This shows exactly how each client tier contributes to the final revenue after accounting for:

• 10% LTV default

• 25% withdrawal of remaining balance

• 3% processing fees

If you want, I can also show this as a per-client average contribution per bracket after all deductions — which is very useful for forecasting and planning incentives for high-value clients.

Do you want me to do that next?

Perfect! Let’s calculate the average revenue per client per bracket after all deductions (LTV defaults, withdrawals, and processing fees).

Step 1: Recall final revenue per bracket and client counts

Step 2: Calculate average revenue per client

Average per client=Final RevenueNumber of Clients\text{Average per client} = \frac{\text{Final Revenue}}{\text{Number of Clients}}Average per client=Number of ClientsFinal Revenue​

✅ Observations

1. Tiered effect: Higher FTD brackets maintain much higher average revenue per client even after deductions.

2. Bracket 1 clients contribute under $1,000 each on average.

3. Bracket 5 clients contribute almost $30k each on average after all deductions.

If you want, I can create a complete chart showing total contribution, deductions, and average per client all in one table — making it super clear for forecasting or presentations.