Casino : Internal VIP and Loyalty Model

Active players

Total active players in this portfolio, split across VIP tiers.

Total active players

VIP tier distribution & deposit

Tier % splits total actives into headcount. Average deposit per tier drives deposit volume — treated as a monthly figure throughout this model. Tier % should sum to 100.

Tier	% of actives	Headcount	Avg deposit (monthly)	Deposit volume
Total

Product split, GGR & game weights

Portfolio deposit volume is split across verticals. Wagered = deposit alloc × wager factor. GGR = wagered × hold%. Weighted wager = wagered × game weight (bonus-eligible portion of turnover). Split % should sum to 100.

Vertical	Split %	Deposit alloc	Wager factor	Wagered	Hold %	GGR	Game weight	Weighted wager
Total

Net loss by tier

Net loss = deposits − withdrawals. WD/Dep ratio is editable per tier and expressed as a % of deposits withdrawn. Feeds Rakeback, Reload, Weekly, and Monthly bonus calculations.

Tier	Deposit (monthly)	WD/Dep ratio %	Withdrawals	Net loss (monthly)	Net loss (weekly)	Net loss (daily)

Transaction costs Placeholder

Payment/on-chain processing costs. Withdrawal volume is sourced from the NetLoss tab.

Deposit processing fee %

Withdrawal processing fee %

Bonus cost uplift Defined

Rev share + platform uplift on GGR, plus WD leakage impact.

Blended rev share + platform %

WD leakage % of GGR

Affiliate commissions Placeholder

Flat CPA per active ($)

Ongoing affiliate rev share %

Referral commissions Placeholder

Referral commission %

Applied against

Cost stack summary

Cost line	Amount
Total cost stack

Rakeback Real-time, uses monthly weighted wager

rakeback = weighted wager × house edge % × rakeback rate %, capped per tier.

Tier	House edge %	Rakeback rate %	Cap $	Per player	Tier total
Total

Daily Reload

reload = (net loss daily × loss rate %) + (weighted wager daily × wager rate %), capped per tier. Shown daily and as a monthly-equivalent (×30) for comparison.

Tier	Loss rate %	Wager rate %	Cap $ (daily)	Per player / day	Tier total / day	Tier total (monthly equiv)
Total

Weekly Bonus

weekly = [(net loss 7d × loss rate %) + (weighted wager 7d × wager rate %)] × VIP multiplier, capped per tier. Shown weekly and as a monthly-equivalent (×4.33).

Tier	Loss rate %	Wager rate %	VIP multiplier	Cap $ (weekly)	Per player / week	Tier total / week	Tier total (monthly equiv)
Total

Monthly Bonus

monthly = [(net loss 30d × loss rate %) + (weighted wager 30d × wager rate %)] × VIP multiplier × activity factor, capped per tier.

Tier	Loss rate %	Wager rate %	VIP multiplier	Activity factor	Cap $	Per player	Tier total
Total

Profit by VIP tier

Reward cost = Rakeback + Reload (monthly equiv) + Weekly (monthly equiv) + Monthly. Profit = reward ceiling minus reward cost.

Tier	Allocated GGR	Allocated cost	Reward ceiling	Reward cost (computed)	Profit	Profit % of GGR

Profit by VIP tier

Tier	Allocated GGR	Reward ceiling	Reward cost	Profit

1. Player pool

Total actives × tier % = headcount per tier. Headcount × average deposit per tier = deposit volume per tier, treated as a monthly figure.

2. Product split, GGR & game weights

Portfolio deposit volume × vertical split % = deposit allocated per vertical. Deposit alloc × wager factor = wagered. Wagered × hold % = GGR. Wagered × game weight = weighted wager. All summed to portfolio totals.

3. NetLoss

Withdrawals per tier = deposit × that tier's WD/Dep ratio %. Net loss = deposit − withdrawals. Weekly = monthly ÷ 4.33. Daily = monthly ÷ 30. Weighted wager is allocated to tiers by deposit share and time-scaled the same way.

4. Cost stack

Transaction cost = deposit volume × deposit fee % + withdrawal volume (from NetLoss) × withdrawal fee %. Bonus cost = GGR × blended rev share + platform %. WD leakage = GGR × WD leakage %. Affiliate cost = (actives × flat CPA) + (GGR × affiliate rev share %). Referral commission = referral % × chosen base. Summed to total cost stack.

5. Rakeback, Reload, Weekly, Monthly

Rakeback = weighted wager (monthly) × house edge % × rakeback rate %, capped. Reload = (net loss daily × loss rate %) + (weighted wager daily × wager rate %), capped, shown daily and ×30 monthly-equivalent. Weekly = same shape over 7d × VIP multiplier, capped, ×4.33 monthly-equivalent. Monthly = same shape over 30d × VIP multiplier × activity factor, capped.

6. Profit per VIP tier

Reward ceiling (GGR minus allocated cost stack) minus computed reward cost (Rakeback + Reload + Weekly + Monthly, monthly-equivalent) = profit.