| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Instructions: Make a copy of this sheet. Enter in values in the two blocks directly below to calculate approximations for per unit and rough volume. NOTE This is a very rough tool that doesn't factor in a lot of considerations, including but not limited to: - Rev Split Conversions Thresholds / Caps / Minimums - Chargebacks / Returns / Refunds* (Can approximate with Gross Adjustment or Net Units Sold) - Total Spend - And much much more! Additional disclaimer: I am not a financial professional and this should not be taken as financial advice! Just a little tool to help get a sense of things ๐ | |||||||
2 | Sale Price | $19.99 | Per Unit | |||||
3 | VAT / Sales Tax | 0% | Gross | $19.99 | ||||
4 | Company Tax | 30% | VAT / Sales Tax | $0.00 | ||||
5 | Platform | 30% | Platform Split | -$6.00 | ||||
6 | Units Sold | 50000 | Rev Split | -$7.30 | ||||
7 | Gross Adj. | 50% | Developer Split | $6.70 | ||||
8 | *Order dependent based on first-served | Company Tax | -$2.01 | |||||
9 | Net | $4.69 | ||||||
10 | ||||||||
11 | Rev Splits (Gross) | Per Unit | Total | Volume* (here be dragons) | ||||
12 | Publisher | 50.00% | $7.00 | $174,912.50 | Gross | $499,750.00 | ||
13 | Agency | 5.00% | $0.30 | $7,496.25 | VAT / Sales Tax | $0.00 | ||
14 | Platform Split | -$149,925.00 | ||||||
15 | Rev Split | -$182,408.75 | ||||||
16 | Developer Split | $167,416.25 | ||||||
17 | Company Tax | -$50,224.88 | ||||||
18 | Net | $117,191.38 | ||||||
19 | ||||||||
20 | ||||||||
21 | ||||||||
22 | Updates April 12, 23 - Rev Splits are now order dependent. - Added notes to most fields with some guidance - Added a "Gross Adjustment" field to factor in things like refunds and discounts, if not factored in elsewhere; baseed on feedback from Callum Underwood and Maeva Sponbergs Have some suggestions? Found a bug? Reach out on one of my socials at esdin.net | |||||||