Page 9 - Dec 2021 Report

30 years - Our Journey Continues Theodore R. and Vivian M. Johnson Scholarship Foundation, Inc.
Statements of Revenue, Expenses and Changes in Fund Balance
Statements of Revenue, Expense and Changes in Fund Balance
as of November 30, 2021
Eleven Months Ending November 30, 2021
#
LINE
YEAR ENDING 12/31/20 ACTUAL
APPROVED 2021 ANNUAL BUDGET
11 Month Actual Ending 11/30/20
11 Month Actual Ending 11/30/21
1 2 3 4 5 6 7 8 9
10 11 12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Cash Received Miscellaneous
11,354,752 -
- -
8,154,752 -
10,219,117 -
TOTAL RECEIVED
11,354,752
-
8,154,752
10,219,117
EXPENSES
Director Fees
Staff salaries
Deferred Compensation Employee benefits Legal fees
Accounting fees
Other professional fees
Prime Buchholz
Other Consultants Rent
Travel, conferences and meetings
Printing and publications
Office - Grant Making Support and Insurance
170,000 755,928 115,163 208,265
5,244 45,750
274,856
294,157 100,646 46,467 13,580 103,481
180,000 717,726 120,000 219,871
5,000 45,950
265,000
445,772 108,984 182,000
15,000 85,423
125,000 697,859
188,756 5,244
35,888
274,856
265,614 91,748 46,417 12,899 92,413
135,000 675,876
180,870 43,862
55,664
256,148
297,288 97,906 139,403 11,882 53,250
TOTAL EXPENSES
2,133,536
2,390,727
1,836,695
1,947,148
Contributions, Gifts, Grants Paid
Taxes
TOTAL DISBURSEMENTS
Excess Expenses over Revenue
NET APPRECIATION OF INVESTMENTS
NET INCREASE(DECREASE)/FUND BALANCE FUND BALANCE, beginning of period
8,367,413 325,230 10,826,180 528,572 31,711,400 32,239,972 230,021,538
8,650,923 - 11,041,650
(11,041,650) 12,545,338 1,503,688 250,906,758
5,003,359 1,148,551 7,988,605
166,147 4,325,256 4,491,402
230,021,538
7,951,214 625 9,898,987 320,129 40,622,678 40,942,807 250,906,758
FUND BALANCE, end of period
250,906,758
252,410,446
226,358,188
281,630,449
Notes:
1. Appreciation of investments (line 22) is estimated at 5% for 12 months ending 12/31/21. Actual for 2020 was 13.79% for the Foundation.
2. FFOG's 2020 Admin Costs Survey of 123 grant making foundations found that the average of all 123 foundations surveyed for Charitable Administrative Expenses as % of Average Assets for Payout Calculation was .95%. In that same survey 14 grant making foundations with assets between $150,000,000 and $250,000,000 surveyed had an average of .79%. Johnson Scholarship Foundation in 2020 was .76%.
November 2021 Financial.xlsx
12/14/21
7