| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ASSUMPTIONS | STUB | YR 2 | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||||
3 | AVG DEAL SIZE | $ 500,000.00 | $ 750,000.00 | |||||||||||||||||||||||||
4 | # DEALS PER location Launch | 3 | 5 | |||||||||||||||||||||||||
5 | Fee % | 7.00% | 7.00% | |||||||||||||||||||||||||
6 | Days to Close | 60 | 60 | |||||||||||||||||||||||||
7 | Deals Per Month Funding After Launch | 0.5 | 1 | |||||||||||||||||||||||||
8 | . | |||||||||||||||||||||||||||
9 | REVENUE | |||||||||||||||||||||||||||
10 | Apr-21 | May-21 | Jun-21 | Jul-21 | Prefund | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | ||||||
11 | Deal #1 | 105,000 | 17,500 | 17,500 | 17,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | |||||||||||
12 | Deal #2 | 105,000 | 17,500 | 17,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | ||||||||||||
13 | Deal #3 | 105,000 | 17,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | |||||||||||||
14 | Deal #4 | 105,000 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | ||||||||||||||
15 | Deal #5 | 262,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | |||||||||||||||
16 | Deal #6 | 262,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | |||||||||||||||||
17 | Deal #7 | 262,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | |||||||||||||||||
18 | Deal #8 | 262,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | ||||||||||||||||||
19 | Deal #9 | 262,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | |||||||||||||||||||
20 | Deal #10 | 262,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | |||||||||||||||||||
21 | Deal #11 | 262,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | ||||||||||||||||||||
22 | Deal #12 | 262,500 | 52,500 | 52,500 | 52,500 | 52,500 | 52,500 | |||||||||||||||||||||
23 | Deal #13 | 262,500 | 52,500 | 52,500 | 52,500 | |||||||||||||||||||||||
24 | Deal #14 | 262,500 | 52,500 | 52,500 | 52,500 | |||||||||||||||||||||||
25 | Deal #15 | 162,500 | 52,500 | |||||||||||||||||||||||||
26 | Deal #16 | 262,500 | 52,500 | |||||||||||||||||||||||||
27 | Deal #17 | 262,500 | ||||||||||||||||||||||||||
28 | ||||||||||||||||||||||||||||
29 | ||||||||||||||||||||||||||||
30 | Monthly Total | 0 | 0 | 0 | 0 | 105,000 | 122,500 | 140,000 | 157,500 | 472,500 | 262,500 | 787,500 | 630,000 | 945,000 | 787,500 | 840,000 | 525,000 | 1,155,000 | 735,000 | 1,160,000 | 1,102,500 | |||||||
31 | ||||||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||||
33 | EXPENSES | Annual Expense | Actual Annual + 30% Load (FICA/Comp or Recruiters/Etc) | % of Expenses | April - 16 | May-16 | Jun-16 | Jul-16 | ||||||||||||||||||||
34 | Staff | |||||||||||||||||||||||||||
35 | CEO | $100,000 | $130,000 | $10,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | $10,833 | ||||
36 | COO | $86,000 | $111,800 | $1,300 | $6,403 | $2,600 | $2,600 | $2,600 | $2,600 | $20,417 | $20,417 | $20,417 | $20,417 | $20,417 | $20,417 | $20,417 | $20,417 | $9,317 | $9,317 | $9,317 | $9,317 | $9,317 | $9,317 | $9,317 | ||||
37 | CIO | $86,000 | $120,400 | $7,167 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | ||||
38 | CSO | $86,000 | $120,400 | $7,167 | $0 | $0 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | $10,033 | ||||
39 | Dir. of Capital Markets | $75,000 | $105,000 | $6,250 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | ||||
40 | CTO | $75,000 | $105,000 | $0 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | ||||
41 | Sr. Devloper - Full Time (US based) | $75,000 | $105,000 | $0 | $0 | $0 | $0 | $0 | $8,750 | $8,750 | $8,750 | $8,750 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | ||||
42 | VP of Sales/Business Development | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
43 | White Label | $36,000 | $36,000 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | ||||
44 | Regional Ecosystem Builder - SE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
45 | Regional Ecosystem Builder - MidWest | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
46 | Regional Ecosystem Builder - West | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $5,833 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | $5,417 | ||||
47 | Admin Assistant | $55,000 | $77,000 | $0 | $0 | $0 | $0 | $6,417 | $6,417 | $6,417 | $6,417 | $6,417 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | ||||
48 | Customer Support (onboarding & investor liason) | $55,000 | $77,000 | $0 | $0 | $0 | $2,125 | $6,417 | $6,417 | $6,417 | $6,417 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | ||||
49 | Advisor (Contractor) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,083 | $2,083 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | ||||
50 | CFO/Payroll/Compliance (Contractor) (payment flows that fit with the portal, with audit & A Round experience) | $60,000 | $84,000 | $0 | $0 | $0 | $1,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $2,000 | $6,417 | $6,417 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | ||||
51 | Intern | $14,000 | $19,600 | $0 | $0 | $0 | $0 | $1,633 | $1,633 | $1,633 | $1,633 | $1,633 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | ||||
52 | Intern | $14,000 | $19,600 | $0 | $0 | $0 | $0 | $1,633 | $1,633 | $1,633 | $1,633 | $1,633 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | ||||
53 | Intern | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | ||||
54 | Intern | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | ||||
55 | Intern | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | $1,167 | ||||
56 | Total | $817,000 | $1,110,800 | $31,883 | $41,936 | $38,133 | $54,292 | $72,267 | $81,017 | $103,750 | $103,750 | $107,333 | $94,568 | $98,984 | $98,984 | $96,734 | $96,734 | $85,634 | $85,634 | $85,634 | $85,634 | $85,634 | $85,634 | $85,634 | ||||
57 | Fixed Expenses | |||||||||||||||||||||||||||
58 | Office Space | $36,000 | 0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |||||
59 | Utilities(Electric, Water, Internet) | $12,000 | 0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |||||
60 | Insurances | $36,000 | 0 | $0 | $0 | $0 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |||||||||||||||||
61 | Office Supplies | $2,500 | 0 | $0 | $0 | $0 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | |||||
62 | Computers | $2,000 | 0 | $0 | $0 | $0 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | |||||
63 | Postage | $3,500 | 0 | $0 | $0 | $0 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | $292 | |||||
64 | Software - CRM | $12,000 | 0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |||||
65 | Cell phones | $0 | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
66 | Corporate Housing | $0 | 0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |||||||||||||||||
67 | Corporate travel, hotel and airfare | $24,000 | 1163.14 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |||||
68 | Total | $128,000 | $1,163 | $0 | $0 | $0 | $14,667 | $14,667 | $14,667 | $14,667 | $14,667 | $7,667 | $7,667 | $7,667 | $7,667 | $7,667 | $7,667 | $7,667 | $7,667 | $7,667 | $7,667 | $7,667 | $7,667 | |||||
69 | ||||||||||||||||||||||||||||
70 | Expenses from Operations | |||||||||||||||||||||||||||
71 | Legal (Contractors) | $48,000 | $0 | $0.00 | $0.00 | $0.00 | $36,500.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | $4,000.00 | |||||
72 | FINRA Application (Legal - Specialty Contractor) | $12,000 | $0 | $1,000.00 | $1,000.00 | $0.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | |||||
73 | Google Ads | $0 | $0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
74 | CMO | $75,000 | $0 | $0.00 | $7,500.00 | $7,500.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | $6,250.00 | |||||
75 | Video | $50,000 | $0 | $0.00 | $0.00 | $0.00 | $15,000.00 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | $4,166.67 | |||||
76 | Tshirts / Swag / giveaways | $10,000 | $0 | $0.00 | $0.00 | $0.00 | $2,000.00 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | $833.33 | |||||
77 | PR | $24,000 | $0 | $0.00 | $0.00 | $0.00 | $8,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | $2,000.00 | |||||
78 | Print Materials | $15,000 | $0 | $0.00 | $0.00 | $0.00 | $2,000.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | |||||
79 | Online & Offline Marketing Tactics | $200,000 | double in Y2 | $0 | $0.00 | $0.00 | $28,125.00 | $28,125.00 | $16,666.67 | $16,666.67 | $16,666.67 | $16,666.67 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | $33,333.33 | ||||
80 | Total | $374,000 | $0 | $0 | $7,500 | $35,625 | $61,375 | $31,167 | $31,167 | $31,167 | $31,167 | $47,833 | $47,833 | $47,833 | $47,833 | $47,833 | $47,833 | $47,833 | $47,833 | $47,833 | $47,833 | $47,833 | $47,833 | |||||
81 | ||||||||||||||||||||||||||||
82 | Expenses Associated with Sales | |||||||||||||||||||||||||||
83 | Airfare | $25,000 | $0.00 | $0.00 | $1,000.00 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | $2,083.33 | ||||||
84 | Car/Uber | $9,000 | $0 | $0 | $0 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | ||||||
85 | Hotel | $25,000 | $0 | $0 | $0 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | ||||||
86 | Food | $24,000 | $0 | $0 | $0 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | ||||||
87 | Entertaining Investors | $15,000 | $0 | $0 | $0 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | ||||||
88 | Courting Entrepreneurs (Food/Drinks/etc...) | $60,000 | $0 | $0 | $0 | $5,000 | $5,000 | $5,000 | $500 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $500 | ||||||
89 | Total | $158,000 | $0 | $0 | $1,000 | $12,367 | $12,367 | $12,367 | $7,867 | $12,367 | $12,367 | $12,367 | $12,367 | $12,367 | $12,367 | $12,367 | $12,367 | $12,367 | $12,367 | $12,367 | $12,367 | $7,867 | ||||||
90 | ||||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||||
92 | Expense Totals | $1,770,800 | $33,046 | $41,936 | $45,633 | $90,917 | $211,533 | $160,675 | $139,217 | $161,950 | $157,450 | $165,533 | $162,434 | $166,851 | $166,851 | $164,601 | $164,601 | $153,501 | $153,501 | $153,501 | $153,501 | $153,501 | $153,501 | $149,001 | $3,070,191 | |||
93 | ||||||||||||||||||||||||||||
94 | Cash Flow | -$41,936.33 | -$87,569.67 | -$178,486.33 | -$339,161.33 | -$478,378.00 | -$640,327.99 | -$797,777.98 | -$963,310.96 | -$1,125,745.45 | $95,648.85 | $620,648.85 | $465,398.86 | $780,398.86 | $633,998.85 | $686,498.85 | $371,498.85 | $1,001,498.85 | $581,498.85 | $1,006,498.85 | $953,498.85 | $2,544,393.32 | ||||||
95 | ||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||||
100 |