Page 1
Page 2
10,000 60,000 70,000
12,500 12,500 82,500 105,559 7,070 4,300 15,750 1,200 500 17,244 7,147 158,770 (76,270)
(76,270)
14,956 18,923 (91,226)
147,500 23,000 12,500 635,675 1,700 820,375 1,236,575 529,000 400,350 35,000 35,750 21,775 15,000 97,000 40,200 1,174,075 62,500 50,000
12,500 Use of FY 2014 Fund Balances less projected FY 2015 Fund Balances
Share of G&A Expense Share of FR Expense Total contribution to fund balances
Fanfare
145,000 65,000 202,700 3,500 416,200
Summary Page Income Contributed Income Individual Donations Corporate Donations Foundation Grants Workplace Giving Campaigns Total Contributed Income Earned Income Program Income County & State Contracts Consulting Income Education Fees Service Fees Other Income Total Earned Income Total Income Expense Compensation Consultants & Prof. Services Program Investments Communication Supplies & Eqpt. Travel Occupancy Insurance/Fees/Business Costs Total Expense Net Operating Income Contribution to Reserves Net addition to Fund Balance after Reserves
17,312 21,903 (15,384)
1,927
121,153 3,270 14,975 2,300 8,750 3,500 25,328 4,497 183,773 1,927
45,000 23,000 68,000 185,700
50,000 67,700 117,700
Prosper
-
9,763 12,353 (18,409)
(8,645)
76,134 3,510 1,500 2,520 1,700 750 12,394 5,137 103,645 (8,645)
95,000 95,000 95,000
Thrive
Root to Canopy Summary FY 2015 Budget for Board of Directors
-
49,119 62,146 72,622
121,741
105,781 345,000 12,000 9,700 8,025 9,250 18,861 12,817 521,434 121,741
7,500 635,675 643,175 643,175
Flourish
2,149
113,175
71,639 20,500 500 2,755 900 500 12,394 6,137 115,325 113,175
228,500
135,000 15,000 75,000 3,500 228,500
Fundraising
-
23,725
(89,451)
48,756 21,000 1,725 2,725 1,200 500 10,778 4,467 91,151 (89,451)
1,700 1,700 1,700
General & Admin
Page 3
Case 15
Case 2 Page 4
Page 5
Outcomes Alignment Screen – Root 2 Canopy Example
Page 6
Long Term (Conditions Δ)
Short Term (Immediate Gains)
Systems & Activities (Actions)
Constituents (Entities Reached)
©2018 Orgforward LLC (available online at www.orgforward.net/usefulstuff)
Mid Term (Actions Δ)
Execution (what will be done) - Internal
The model / philosophy / theory that is the basis for the program’s approach to creating the outcomes above (a.k.a: what will it take to create the outcomes/conditions above?)
Outcomes (what will be different for community/individuals) - External
Strategy
Program Outcomes / Benefits - What specific organizational outcomes will this program advance (links to organization’s strategy)
Program Modeling
Financial & NonFinancial (in-kind)
Assets Required
Page 7 Insurance/Government Fees, etc:
Evaluation/Data:
Travel:
Facilities:
Equipment / Supplies:
IT:
Communications:
Contractor / Professional Fees:
Special program costs:
Direct Expenses Salaries/Benefits:
Expense/Cost Drivers What will determine the scale of direct expenses for this program (Salary/Hrs Worked, # of sessions, ???)
Special capital cost requirements? (equipment replacement, etc.)
Carrying portion of fundraising & administration costs (based on allocation policy)
Common Costs & Special Expenses Allocation of Indirect Costs – Factors the will influence these costs Allocation Policy Special factors – exceptions or extraordinary allocations Special funder requirements Established indirect rate
Other Financial Drivers Are there any other factors that may impact the financial viability of the program (# of volunteers, environmental factors, partnerships, calendars, ???)
©2018 Orgforward LLC (available online at www.orgforward.net/usefulstuff)
Restricted Contributions, such as grants or donations:
Program Quick Budget Direct Revenue Earned revenue, such as fees for service:
Revenue/Profit Drivers What will determine the scale/amount of revenue this program will directly earn (# of participants, # of sessions, ???)
Financial Modeling
Program Modeling
Page 8
Indicator(s)
©2018 Orgforward LLC (available online at www.orgforward.net/usefulstuff)
Effectiveness Metrics – How will you measure the effectiveness of the program’s outcomes (Indicators = what you are looking for; measure = how you will measure for that) Outcomes Long Term Mid Term Indicator(s) Method(s) Indicator(s) Method(s)
Evaluation
Program Modeling
Short Term Method(s)
Page 9 Change in Assumptions (How will you assess whether the underlying assumptions behind the program are valid/appropriate)
Change in Financial Model (What do you need to monitor that could alter the basis of the program’s financial model and how will you monitor it)
©2018 Orgforward LLC (available online at www.orgforward.net/usefulstuff)
Sustainability Measures Change in Community (Scenario) (How will you track environmental/community changes that may impact the benefit the program is designed to create)
Efficiency Measures – How will you measure the efficiency of resources used by the program Resources (Effort) Allocated Mission Outcomes Achieved (What measures will you use to determine how much of the organization’s (How will you measure this program’s contribution resources are being allocated and consumed by the program) to overall vision / mission fulfillment)
Program Modeling
Model Statement of Activities – Organizational Level (aka Profit & Loss, P&L)
Provided Courtesy of Bess Foley
Page 10
Model Statement of Activities – Program Level (aka Profit & Loss, P&L)
ORG P&L By Activity
Program To Date:
Revenue and Support
3/31/16 95,843
Cmty Programs
Support
Embassy
Preschool
G&A
Devel
2,451
29,025
31,053
260
48,634 10,000 13,672 72,306
23,542 9,242 32,784
1,500 1,500
12,791 2,849 15,640
Total Non-Personnel TOTAL EXPENSES
1,067 97 7,500 1,038 1,943 150 11,795 84,100
3,500 279 1,752 80 5,611
-
38,395
Net Income / per Activity
11,742
(35,944)
Personnel Salaries & Related Exp Program Fees & Services Professional & Other Fees Total Personnel
Annual Budget
Var Bud v Actual todate
33,054
511,700
415,857
12,301 10,000 81 22,382
-
395,000
346,366
3,800
(6,200)
535 97 4,000 191 20 4,843
532 759 50 1,341
-
2,000
933
4,000
3,903
47,000
39,500
87,200
75,405
1,500
20,483
23,723
-
500,000
415,900
27,525
10,570
(23,463)
33,054
11,700
(42)
14,000
328
412,800
340,494
Non-Personnel Business & Organizational Equipment, Depreciation, Repairs Occupancy Office & General Expenses Sullpies & Materials Travel, Parking, Accommodations
% Total Expenses
100%
Total Budgeted Income per class Total Budgeted Expense per class Budgeted Net Income per class
46%
125,000 240,000 (115,000)
2%
25,000 21,000 4,000
% Expenses per Activity to Date G&A 28%
24%
28%
100,000 154,000 (54,000)
350 81,000 (80,650)
261,350 4,000 257,350
Government Grants 17% Foundations 1% Cmty Programs 46%
Earned Revenue 65%
Corporations 13%
Churches & Orgs 3% Preschool 24%
Special Event In-Kind 0% Contrib 0%
Embassy 2%
Provided Courtesy of Bess Foley
Page 11
4,462
20,000
18,057
8,700
8,550
0%
% Revenue by Source to Date
Devel 0%
5,500
Individuals 1%
511,700 500,000 11,700
Model Statement of Position (aka Balance Sheet)
Current Year TOTAL to 3/31/16 ASSETS Current Assets Checking/Savings Accounts Receivable Other Current Assets Total Current Assets Fixed Assets Building & Improvements Furniture & Equipment Accum. Depreciation & Amort. Total Fixed Assets Other Assets
TOTAL ASSETS
60,516 192,834 2,010 255,360
Unrestricted Key Board Temp to Operations Designated Restricted Notes
25,516 192,834 2,010 220,360
3,500 3,500 -
-
258,860
220,360
2,440 10,233 15,189 27,862
2,440 10,233
27,862
27,862
192,498 25,000 3,500 220,998 10,000 230,998
192,498
25,000
10,000 A B
25,000
10,000
Prior Year
12/31/15
50,516 192,834 2,010 245,360
3,500 3,500
-
28,500
10,000
248,860
-
-
2,440 10,233 15,189 27,862
-
-
27,862
3,500 3,500 -
LIABILITIES & EQUITY Liabilities Current Liabilities Accounts Payable Payroll Liabilities / Accrued Wages Due to / Due from Operating Reserve Other Current Liabilities Total Current Liabilities Long Term Liabilities/Mortgage Total Liabilities Net Assets Unrestricted UR-Undesignated UR-Board Designated Reserve UR-Property, Plant & Equipment Total Unrestricted Temporarily Restricted Total Net Assets
TOTAL LIABILITIES & NET ASSETS
258,860
15,189 27,862
C
25,000 3,500
192,498
28,500
-
192,498
28,500
10,000 10,000
220,360
28,500
10,000
Notes A B C D E
D
Two gov't grants; payments expected within next 3 months. Deposits for rent and utilities Deferred Revenue; Pass through (funds temporarily held for others) Non-liquid fixed assets net of any related debt; purchase authorized by board Grant for next fiscal year
Provided Courtesy of Bess Foley
Page 12
E
194,998 15,000 3,500 213,498 7,500 220,998 248,860