ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1
2
3
SUBSCRPTION COMPANY - SAMPLE PRO FORMA
4
5-Year Forecast
YR 1YRS 2-5
5
6
ANNUAL TOTAL MEMBERSHIP ASSUMPTIONS
OPERATIONAL P&LMO-1MO-2MO-3MO-4MO-5MO-6MO-7MO-8MO-9MO-10MO-11MO-12TOTALYR-2YR-3YR-4YR-5Total
7
8
Revenue
9
YR-11,000Subscription Revenue
10
YR-21,250Individual Dues - - - 120,000 80,000 40,000 32,000 32,000 32,000 32,000 32,000 32,000 432,000 625,000 937,500 1,367,188 1,953,125 5,314,813
11
YR-31,563Annual Revenue
12
YR-41,953Sponsorship 10,000 - - - - - - - - - - - 10,000 15,000 20,000 25,000 30,000 100,000
13
YR-52,441Business Listings - - - 4,000 4,000 4,000 4,000 4,000 4,000 5,000 10,000 15,000 54,000 150,000 218,750 312,500 439,453 1,220,703
14
Non-Annual Revenue
15
PER-CAP ANNUAL MEMBERSHIP YIELD ASSUMPTIONS
Employment Advertising - - - 2,160 2,592 3,024 3,456 3,888 4,320 4,752 5,184 5,616 34,992 125,000 234,375 410,156 683,594 1,518,357
16
Educational - - - - - - - - - 12,960 12,960 12,960 38,880 187,500 328,125 546,875 878,906 2,019,166
17
YR-1 $ 400.00 Events - - - - - - - - - - - - - 20,000 25,000 30,000 35,000 110,000
18
YR-2 $ 500.00 TOTAL REVENUE 10,000 - - 126,160 86,592 47,024 39,456 39,888 40,320 54,712 60,144 65,576 569,872 1,122,500 1,763,750 2,691,719 4,020,078 10,283,039
19
YR-3 $ 600.00
20
YR-4 $ 700.00 Operational Expenses
21
YR-5 $ 800.00 Web Services - Product
22
Web Hosting 500 500 500 500 500 500 500 500 500 500 500 500 6,000 7,200 8,640 10,368 12,442 44,650
23
App Hosting 500 500 500 500 500 500 500 500 500 500 500 500 6,000 7,200 8,640 10,368 12,442 44,650
24
Operational Design 700 700 700 700 700 700 700 700 700 700 700 700 8,400 10,080 12,096 14,515 17,418 62,509
25
ANNUAL TOTAL BUSINESS LISTINGS
Web Services - Administration -
26
G-Suite 75 75 75 75 75 75 75 75 75 75 75 75 900 1,080 1,296 1,555 1,866 6,697
27
YR-1100CRM 50 50 50 50 50 50 50 50 50 50 50 50 600 780 1,014 1,318 1,714 5,426
28
YR-2250Tech Support 200 200 200 200 200 200 200 200 200 200 200 200 2,400 3,120 4,056 5,273 6,855 21,703
29
YR-3313Billing Services / Transaction Fees - - - 2,523 1,732 940 789 798 806 1,094 1,203 1,312 11,197 22,150 34,875 53,334 79,802 201,358
30
YR-4391Business Administration -
31
YR-5488Legal 150 150 150 150 150 150 150 150 150 150 150 150 1,800 2,340 3,042 3,955 5,141 16,278
32
Accounting 350 350 350 350 350 350 350 350 350 350 350 350 4,200 5,460 7,098 9,227 11,996 37,981
33
Insurance 28,494 - - - - - - - - - - - 28,494 56,125 88,188 134,586 201,004 508,396
34
PER-CAP ANNUAL BUSINESS LISTING YIELD ASSUMPTIONS
Office Supplies 50 50 50 50 50 50 50 50 50 50 50 50 600 720 864 1,037 1,244 4,465
35
Utilities (Phone / Internet) 400 400 400 400 400 400 400 400 400 400 400 400 4,800 5,280 5,808 6,389 7,028 29,304
36
Software Subscriptions 75 75 75 75 75 75 75 75 75 75 75 75 900 1,170 1,521 1,977 2,570 8,139
37
YR-1 $ 500.00 Marketing -
38
YR-2 $ 600.00 Advertising - Social Media 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 60,000 20,000 20,000 20,000 20,000 140,000
39
YR-3 $ 700.00 Advertising - SEO 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 60,000 20,000 20,000 20,000 20,000 140,000
40
YR-4 $ 800.00 Advertising - Google Ad Words 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 60,000 20,000 20,000 20,000 20,000 140,000
41
YR-5 $ 900.00 Advertising - Industry Publications 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 13,200 14,520 15,972 17,569 73,261
42
Creative 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000 28,800 34,560 41,472 49,766 178,598
43
Printing 50 50 50 50 50 50 50 50 50 50 50 50 600 660 726 799 878 3,663
44
Business Development -
45
Travel 167 167 167 167 167 167 167 167 167 167 167 167 6,000 6,600 7,260 7,986 8,785 36,631
46
Conference Fees 250 250 250 250 250 250 250 250 250 250 250 250 10,000 11,000 12,100 13,310 14,641 61,051
47
M&E 83 83 83 83 83 83 83 83 83 83 83 83 3,000 3,300 3,630 3,993 4,392 18,315
48
Human Capital - -
49
Part-Time Administrator - - - - - - - - - - - - - 50,000 52,000 54,000 56,000 212,000
50
Full-Time Administrator - - - - - - - - - - - - - 100,000 105,000 110,000 315,000
51
On Cost - - - - - - - - - - - - - 7,500 7,800 8,100 8,400 31,800
52
Third-Party Educators - - - - - - - - - 6,480 6,480 6,480 19,440 93,750 164,063 273,438 439,453 990,143
53
R&D -
54
Industry Studies 5,000 10,000 20,000 30,000 40,000 105,000
55
Market Research 2,000 4,000 6,000 8,000 1,000 21,000
56
57
TOTAL EXPENSES 50,094 21,600 21,600 24,123 23,332 22,540 22,389 22,398 22,406 29,174 29,283 29,392 338,331 411,515 659,796 875,972 1,172,405 3,635,602
58
59
Taxes 5,982 24,799 44,158 72,630 113,907 258,977
60
61
NOI (40,094) (21,600) (21,600) 102,037 63,260 24,484 17,067 17,490 17,914 25,538 30,861 36,184 225,559 686,186 1,059,796 1,743,117 2,733,766 6,388,460
62
Margin-401%--81%73%52%43%44%44%47%51%55%40%61%60%65%68%62%
63
64
DEVELOPMENT EXPENSES
65
66
Software
67
MVP Development 20,000 20,000
68
MVP Licensing 5,000 5,000
69
Phase 2 Development 75,000 75,000
70
Phase 2 Licensing 5,000 5,000
71
Business Startup -
72
Single-Member LLC Incorporation 5,000 5,000
73
S-Corp Incorporation 1,000 1,000
74
Hardware -
75
Phase 1 Computer Equipment 10,000 10,000
76
Phase 2 Computer Equipment 10,000 10,000
77
Brand Development -
78
Brandmark 12,000 12,000
79
Masterbrand 20,000 20,000
80
Sponsorship Procurement 10,000 10,000
81
 -
82
TOTAL DEVELOPMENT EXPENSES 82,000 91,000 173,000
83
84
85
DEVELOPMENT DEFERRAL BALANCE SHEET
86
Development capital deferred over 5 years
87
88
Revenue 569,872 1,122,500 1,763,750 2,691,719 4,020,078 10,167,919
89
90
Operational Expenses 338,331 411,515 659,796 875,972 1,172,405 3,458,019
91
Development 16,400 39,150 39,150 39,150 39,150 173,000
92
93
TOTAL DEFERRED NOI - 215,141 671,835 1,064,804 1,776,597 2,808,523 6,536,900
94
95
96
97
CASH BALANCE SHEET
98
99
100
Revenue 569,872 1,122,500 1,763,750 2,691,719 4,020,078 10,167,919