1d0isrdl9 21588
1d0isrdl9 21588
1d0isrdl9 21588
(x $1,000) 1 2 3 4 5 6 7 8 9 10 11
Pricing
Type Price/yr Y/Y%↗
A $35 5.0% $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3
B $50 5.0% $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4
C $90 5.0% $7 $7 $7 $7 $7 $7 $7 $7 $7 $7 $7
D $100 5.0% $8 $8 $8 $8 $8 $8 $8 $8 $8 $8 $8
E $110 5.0% $9 $9 $9 $9 $9 $9 $9 $9 $9 $9 $9
F $150 5.0% $12 $12 $12 $12 $12 $12 $12 $12 $12 $12 $12
Clients
Type 1st Mo Start # M/M%↗
A 1 2 8.5% 2 2 2 3 3 3 3 4 4 4 5
B 2 3 7.5% 0 3 3 3 4 4 4 5 5 5 6
C 5 2 7.0% 0 0 0 0 2 2 2 2 3 3 3
D 12 2 5.0% 0 0 0 0 0 0 0 0 0 0 0
E 15 1 4.0% 0 0 0 0 0 0 0 0 0 0 0
F 18 1 3.0% 0 0 0 0 0 0 0 0 0 0 0
Total: 2 5 5 6 9 9 9 11 12 12 14
New Clients
Type 1 2 3 4 5 6 7 8 9 10 11
A 2 0 0 1 0 0 0 1 0 0 1
B 0 3 0 0 1 0 0 1 0 0 1
C 0 0 0 0 2 0 0 0 1 0 0
D 0 0 0 0 0 0 0 0 0 0 0
E 0 0 0 0 0 0 0 0 0 0 0
F 0 0 0 0 0 0 0 0 0 0 0
Total: 2 3 0 1 3 0 0 2 1 0 2
Revenue
Type
A $6 $6 $6 $9 $9 $9 $9 $12 $12 $12 $14
B $0 $12 $12 $12 $17 $17 $17 $21 $21 $21 $25
C $0 $0 $0 $0 $15 $15 $15 $15 $22 $22 $22
D $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
E $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
F $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total: $6 $18 $18 $21 $40 $40 $40 $47 $55 $55 $62
New Revenue
Type 1 2 3 4 5 6 7 8 9 10 11
A $6 $0 $0 $3 $0 $0 $0 $3 $0 $0 $3
B $0 $12 $0 $0 $4 $0 $0 $4 $0 $0 $4
C $0 $0 $0 $0 $15 $0 $0 $0 $7 $0 $0
D $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
E $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
F $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total: $6 $12 $0 $3 $19 $0 $0 $7 $7 $0 $7
Unadj. Commissions
Type Schedule
A Yr BD1 BD2 BD2 % $1 $1 $1 $2 $2 $2 $2 $2 $2 $2 $3
B 1 20.0% 10.0% 80% $0 $2 $2 $2 $3 $3 $3 $4 $4 $4 $5
C 2 15.0% 7.5% 80% $0 $0 $0 $0 $3 $3 $3 $3 $4 $4 $4
D 3 12.0% 6.0% 60% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
E 4 10.0% 5.0% 40% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
F 5 5.0% 2.5% 40% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total: $1 $4 $4 $4 $8 $8 $8 $9 $11 $11 $12
Year 2 Year 3 Year 4 Year 5
12 Year 1 Year 2 Year 3 Year 4 Year 5
5 5 13 35 93 246
6 6 15 35 84 199
3 3 7 16 37 83
2 2 4 6 12 21
0 0 1 2 4 6
0 0 1 2 2 3
16 16 41 96 232 558
11 11 11 11 11 11
0 5 8 22 58 153
0 6 9 20 49 115
0 3 4 9 21 46
2 2 2 2 6 9
0 0 1 1 2 2
0 0 1 1 0 1
2 16 25 55 136 326
11 11 11 11 11
$0 $14 $24 $70 $194 $538
$0 $25 $39 $91 $234 $578
$0 $22 $31 $74 $181 $416
$17 $17 $17 $18 $57 $90
$0 $0 $10 $10 $21 $22
$0 $0 $13 $14 $0 $15
$17 $78 $135 $277 $688 $1,659
Total COGS: $13,341 $13,341 $13,341 $13,341 $13,341 $13,341 $13,341 $13,341 $13,341 $13,341 $13,341 $13,341
COGS Year 2
(x $1,000) Year 1 Year 2
Staff
Hourly
Hourly rate
Seats: 1 2
Add'l/Client
Total Hourly: $105,408 $180,950
Salaried