ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Open Source Initiative
2
Budget Scenarios: 2020
3
Income Statement Summary
4
Updated 06/11/20
5
Scenario 1Scenario 2Scenario 3Scenario 4Scenario 5Comments
6
2020 BudgetNo additional revenueRemove $50K in expenseRetraction to 1 staff/core servicesWith Potential New Revenue
7
REVENUE
8
 Contributions, Sponsorship, and Membership Revenue
12
 Total Contributions - Temporarily Restricted $ 199,025 $ 199,025 $ 199,025 $ 199,025 $ 199,025
13
14
 Contributions - Unrestricted $ 163,435 $ 3,745 $ 163,435 $ 163,435 $ 883,000
15
 Membership Revenue $ 23,000 $ 14,040 $ 23,000 $ 23,000 $ 23,000
see: https://docs.google.com/spreadsheets/d/1sp8Dtqk1kS6ouCZQdcznKS4L1w_bEIrY33T1dCKB1Nc/edit?usp=sharing
16
 Total Contributions, Sponsorship, and Membership Revenue $ 385,460 $ 216,810 $ 385,460 $ 385,460 $ 1,105,025
17
18
 Other Revenue
19
 Commissions $ 2,556 $ 2,526 $ 2,556 $ 2,556 $ 2,556
20
 Tuition Referral Revenue Share $ 2,262 $ 1,131 $ 2,262 $ 2,262 $ 2,262
21
 Total Other Revenue $ 4,818 $ 3,657 $ 4,818 $ 4,818 $ 4,818
22
23
 TOTAL REVENUE $ 390,278 $ 220,466 $ 390,278 $ 390,278 $ 1,109,843
24
25
EXPENSES
26
 Compensation $ 131,471 $ 131,471 $ 131,471 $ 124,180 $ 131,471
27
28
 Fundraising Expenses $ 1,750 $ 1,750 $ 1,750 $ 1,750 $ 1,750
29
30
 Insurance Expenses $ 3,071 $ 3,071 $ 3,071 $ 3,071 $ 3,071
31
32
 Internet Expenses $ 12,443 $ 12,443 $ 12,443 $ 12,443 $ 12,443
33
34
 Legal & Professional Fees $ 110,262 $ 110,262 $ 85,911 $ 24,522 $ 110,262
35
36
 Marketing & Promotion Expense $ 3,860 $ 3,860 $ 2,360 $ 2,360 $ 3,860
37
38
 Office Expenses $ 4,607 $ 4,607 $ 4,607 $ 4,607 $ 4,607
39
40
 Other Expenses $ 2,478 $ 2,478 $ 2,478 $ 2,478 $ 2,478
41
42
 Program Service Expense
43
 ClearlyDefined Expense $ 257,398 $ 257,398 $ 257,398 $ 257,398 $ 257,398
44
 Snowdrift Expense $ - $ - $ - $ - $ -
45
 Grant expense $ - $ - $ - $ - $ -
46
 Program Service Expense $ 257,398 $ 257,398 $ 257,398 $ 257,398 $ 257,398
47
48
 Travel & Entertainment Expense $ 28,006 $ 28,006 $ 3,857 $ 3,857 $ 28,006
49
50
 TOTAL EXPENSES $ 555,347 $ 555,347 $ 505,347 $ 436,666 $ 555,347
51
52
 NET OPERATING INCOME $ (165,069) $ (334,880) $ (115,069) $ (46,389) $ 554,496
53
54
 Interest Income $ 41 $ 41 $ 41 $ 41 $ 41
55
56
 NET INCOME $ (165,028) $ (334,839) $ (115,028) $ (46,347) $ 554,538
57
58
59
60
CASH
61
 Beginning balance, Cash $ 323,041 $ 323,041 $ 323,041 $ 323,041 $ 323,041
62
 Net Income $ (165,028) $ (334,839) $ (115,028) $ (46,347) $ 554,538
63
 Cash timing difference $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 30 year, 2.75% interest
64
 SBA EID Loan
65
 Ending balance, Cash $ 308,013 $ 138,202 $ 358,013 $ 426,693 $ 1,027,578
66
~5 months operating reserveWould need loan~7 months operating reserve~12 months operating reserve~6 months operating reserve
67
 $ 0
68
$46,278.89$42,112.22$36,388.86$46,278.89
69
6.668.5011.7322.20
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
101
102
103