ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
S&R Collaboration
2
3-Year Pro Forma
3
Year 1Year 2Year 3
4
5
Q1Q2Q3Q4TotalQ1Q2Q3Q4TotalQ1Q2Q3Q4Total
6
EXPENSES
7
Staffing
8
Payroll $ 197,381 $ 197,381 $ 197,381 $ 197,381 $ 230,410 $ 230,410 $ 230,410 $ 230,410 $ 263,175 $ 263,175 $ 263,175 $ 263,175
9
Benefits $ 39,476 $ 39,476 $ 39,476 $ 39,476 $ 46,082 $ 46,082 $ 46,082 $ 46,082 $ 52,635 $ 52,635 $ 52,635 $ 52,635
10
11
AI/Software Dev
12
AI Engine $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000
13
Online Facilitator Training/Community $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000
14
App $ 30,000 $ 30,000 $ 10,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000
15
16
Content Development
17
Video Production $ 10,000 $ 20,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000
18
Online Course Prod $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000
19
Book Production $ 10,000 $ 10,000 $ 10,000 $ 10,000
20
21
22
Content Distribution
23
Online ads $ 6,000 $ 6,000 $ 6,000 $ 10,000 $ 7,000 $ 8,000 $ 10,000 $ 12,000 $ 10,000 $ 10,000 $ 15,000 $ 18,000
24
Social Media $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 12,000 $ 12,000 $ 12,000 $ 12,000 $ 14,000 $ 14,000 $ 14,000 $ 14,000
25
Email $ 1,000 $ 2,000 $ 2,000 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 4,000 $ 4,000 $ 4,000 $ 5,000 $ 5,000
26
PR/Events $ 15,000 $ 15,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000
27
SEO Exp $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500
28
29
Donor Development
30
Meals & Events $ 2,000 $ 2,000 $ 4,000 $ 8,000 $ 10,000 $ 12,000 $ 20,000 $ 10,000 $ 12,000 $ 15,000 $ 40,000
31
Online Fundraising $ 3,000 $ 10,000 $ 10,000 $ 12,000 $ 15,000 $ 25,000 $ 30,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000
32
33
Ops
34
Travel/Meals $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 7,000 $ 7,000 $ 7,000 $ 7,000
35
Misc $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000
36
Legal $ 3,000 $ 3,000 $ 3,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 7,000 $ 7,000 $ 7,000 $ 7,000
37
Software (subscription) $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,000 $ 9,500 $ 9,500 $ 9,500 $ 9,500
38
Hardware $ 10,000 $ 5,000 $ 2,500 $ 2,500 $ 2,500 $ 2,500 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000
39
3 Yr Total
40
TOTAL EXPENSES $ 336,358 $ 347,358 $ 399,858 $ 418,858 $ 1,502,430 $ 466,492 $ 477,492 $ 498,992 $ 529,992 $ 1,972,967 $ 519,810 $ 524,810 $ 543,810 $ 571,810 $ 2,160,240 $ 5,635,637
41
42
43
44
REVENUE
45
46
Major Donor $ 10,000 $ 25,000 $ 30,000 $ 40,000 $ 50,000 $ 75,000 $ 125,000 $ 175,000 $ 225,000 $ 400,000
47
Mid Major $ 5,000 $ 5,000 $ 5,000 $ 10,000 $ 25,000 $ 25,000 $ 50,000 $ 75,000 $ 100,000 $ 175,000
48
General File $ 20,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 30,000 $ 30,000 $ 40,000 $ 60,000 $ 70,000 $ 100,000 $ 150,000
49
Material Sales $ 1,500 $ 3,000 $ 3,000 $ 4,000 $ 4,000 $ 5,000 $ 7,500 $ 10,000 $ 10,000 $ 15,000
50
3 Yr Total
51
Total Revenue $ 20,000 $ 25,000 $ 41,500 $ 58,000 $ 144,500 $ 63,000 $ 84,000 $ 109,000 $ 145,000 $ 401,000 $ 242,500 $ 330,000 $ 435,000 $ 740,000 $ 1,747,500 $ 2,293,000
52
53
54
Cash BalanceTotal Cash Infusion
55
Cash Infusion $ 500,000 $ 400,000 $ 350,000 $ 350,000 $ 1,600,000 $ 400,000 $ 400,000 $ 400,000 $ 400,000 $ 1,600,000 $ 500,000 $ 400,000 $ 350,000 $ 350,000 $ 1,600,000 $ 4,800,000
56
Prev Qtr Balance $ 183,643 $ 261,285 $ 252,928 $ 242,070 $ 238,578 $ 245,087 $ 255,095 $ 270,103 $ 492,793 $ 697,983 $ 939,173
57
Expense $ 336,358 $ 347,358 $ 399,858 $ 418,858 $ 466,492 $ 477,492 $ 498,992 $ 529,992 $ 519,810 $ 524,810 $ 543,810 $ 571,810
58
Revenue $ 20,000 $ 25,000 $ 41,500 $ 58,000 $ 63,000 $ 84,000 $ 109,000 $ 145,000 $ 242,500 $ 330,000 $ 435,000 $ 740,000
59
Bank Acct. Balance $ 183,643 $ 261,285 $ 252,928 $ 242,070 $ 238,578 $ 245,087 $ 255,095 $ 270,103 $ 492,793 $ 697,983 $ 939,173 $ 1,457,363
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100