Loading...
HomeMy WebLinkAboutBalance SheetsBig Brothers Big Sisters of Johnson County FY 2022 Monthly Balance Sheet Summary 7/31/2021 8/31/2021 9/30/2021 10/31/2021 11/30/2021 12/31/2021 1/31/2022 2/28/2022 3/31/2022 4/30/2022 5/31/2022 6/30/2022 Assets Cash HB&T Checking 70,796 67,425 68,466 60,291 55,341 56,276 57,643 78,845 88,548 77,762 71,836 76,737 HB&T Money Market 205,521 189,191 184,715 203,521 192,518 180,493 177,603 185,969 186,225 187,914 176,185 142,599 GreenState Money Market 22,530 22,530 22,530 22,530 22,530 22,589 22,589 22,589 22,617 22,617 22,617 22,645 Total Cash 298,847 279,146 275,711 286,342 270,389 259,358 257,835 287,403 297,390 288,293 270,638 241,981 Certificates of Deposit - - - - - - - - - - - - Total Certificates of Deposit - - - - - - - - - - - - Other Assets Community Fund of Johnson Co.208,124 208,124 206,442 206,442 206,442 217,262 217,262 217,262 201,990 201,990 201,990 165,367 Community Fund of Johnson Co. - Ron Bohlkom 19,599 19,599 19,440 19,440 19,440 20,364 20,364 20,364 18,886 18,886 18,886 15,411 Other/4-H Foundation - - - - - 16,106 16,106 16,106 Total Other Assets 227,723 227,723 225,882 225,882 225,882 237,626 237,626 237,626 220,876 236,982 236,982 196,884 Total Assets 526,570 506,869 501,593 512,224 496,271 496,984 495,461 525,029 518,266 525,275 507,620 438,865 Liabilities Payroll Liabilities HB&T Visa Card - 2796 2,931 425 1,313 1,003 3,777 545 1,094 1,111 2,151 906 2,507 Accrued Vacation Total Payroll Liabilities 2,931 425 1,313 1,003 3,777 545 1,094 1,111 2,151 906 2,507 - Total Liabilities 2,931 425 1,313 1,003 3,777 545 1,094 1,111 2,151 906 2,507 - Net Assets With Restrictions Unrestricted YTD Net Income Total Net Assets - - - - - - - - - - - - Total Liabilities & Net Assets Prepared by Big Brothers Big Sisters of Johnson County Big Brothers Big Sisters of Johnson County Statement of Changes in Net Assets For the One Month Periods Ending August 31, 2021 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 YTD Total Annual Budget $ Long /(Short) % Long /(Short) Revenues Local Funding Sources Johnson County 11,692$ -$ -$ 11,692$ -$ -$ 11,692$ -$ -$ 11,692$ -$ -$ 46,768$ 46,768$ -$ 0.00% City of Iowa City - CDBG - - 6,530 - 6,530 - - - 6,530 - 6,530 - 26,120 24,924 1,196 4.80% City of Coralville 5,167 - - - - - - - - - - - 5,167 5,167 - 0.00% City of North Liberty 4,375 - - - - - - - - - - - 4,375 4,375 - 0.00% Total Local Funding Sources 21,234 - 6,530 11,692 6,530 - 11,692 - 6,530 11,692 6,530 - 82,430 81,234 1,196 1.47% - Contributions Corporate Gifts 500 21 1,000 100 100 13,470 600 3,100 834 1 520 7,300 27,546 16,073 11,473 71.38% Individual Giving 347 1,142 397 233 442 6,939 1,398 82 696 256 1,185 253 13,370 12,483 887 7.11% United Way Allocation w/focus area funds 3,699 3,688 3,688 3,688 3,688 3,688 3,688 3,688 3,688 3,840 3,688 3,688 44,419 44,268 151 0.34% United Way Donor Designations - 30 - 9,127 - - - 141 - 720 - 469 10,487 9,711 776 7.99% Total Contributions 4,546 4,881 5,085 13,148 4,230 24,097 5,686 7,011 5,218 4,817 5,393 11,710 95,822 82,535 13,287 16.10% - BBBS Sponsored Events BFKS Pledges/50/50/- - - - - - 1,797 39,423 20,650 90 175 100 62,235 96,395 (34,160) -35.44% BFKS Corporate Sponsors 250 - 1,500 - - 1,500 8,000 1,500 2,250 - - - 15,000 18,250 (3,250) -17.81% Breakfast (RMM)166 166 89 716 616 116 116 116 39 116 716 1,522 4,494 5,000 (506) -10.12% Breakfast Corporate Sponsors - - - - - - - - - - - - - - - 0.00% Grocery Grab - - - - - - - - - - - - - - - 0.00% Alternative Event/Big Bash - - 5,398 4,125 4,267 166 - - - - - - 13,956 20,000 (6,044) -30.22% Total BBBS Sponsored Events 416 166 6,987 4,841 4,883 1,782 9,913 41,039 22,939 206 891 1,622 95,685 139,645 (43,960) -31.48% Grants West Branch - - - - - - - - - - - 7,000 7,000 3,300 3,700 112.12% Juvenile Justice 6,280 - 1,120 2,160 - 6,481 2,820 2,553 7,295 4,394 6,937 20,533 60,573 61,536 (963) -1.56% Community Foundation - - - 3,900 - - - - - - - - 3,900 18,613 (14,713) -79.05% 4-H Mentoring - - - - - - - - - - - - - - 0.00% Misc. Grants - 2,000 2,780 - - 500 - - - - - 500 5,780 6,300 (520) -8.25% PPP - - - - - - - - - - - - - - 0.00% IDPH 2,206 1,861 5,941 12,714 6,084 - - 12,680 5,023 11,408 - 8,168 66,085 62,004 4,081 6.58% Total Grants 8,486 3,861 9,841 18,774 6,084 6,981 2,820 15,233 12,318 15,802 6,937 36,201 143,338 151,753 (8,415) -5.55% Other Income Grants/Contracts/BBBSA - - - - - - 73 - - - - 2,548 2,621 - 2,621 0.00% Other Income 125 - - - - - - - 1,355 - 431 1,911 900 1,011 112.33% Interest Income - 45 20 21 21 79 20 19 51 - 43 47 366 552 (186) -33.70% Volunteer Checks 139 69 274 374 33 210 104 174 138 174 274 132 2,095 3,148 (1,053) -33.45% Total Other Income 264 114 294 395 54 289 197 193 189 1,529 317 3,158 6,993 4,600 2,393 52.02% Total Revenues 34,946$ 9,022$ 28,737$ 48,850$ 21,781$ 33,149$ 30,308$ 63,476$ 47,194$ 34,046$ 20,068$ 52,691$ 424,268$ 459,767$ (35,499)$ -7.72% Acutal Results for the One Month Period Ending:Variance from Budget Prepared by Big Brothers Big Sisters of Johnson County $16,106 revenue not reflected diverted to Endowment Big Brothers Big Sisters of Johnson County Statement of Changes in Net Assets For the One Month Periods Ending August 31, 2021 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 YTD Total Annual Budget $ Long /(Short) % Long /(Short) Acutal Results for the One Month Period Ending:Variance from Budget Expenses Costs of Employment Salaries & Wages 22,268$ 18,902$ 24,234$ 23,942$ 24,651$ 25,019$ 25,837$ 25,397$ 24,353$ 27,896$ 27,521$ 28,378$ 298,398$ 313,427$ (15,029)$ -4.80% Health/Life/ADD Insurance 2,223 2,223 2,223 2,223 2,223 2,331 2,331 2,331 2,331 2,914 3,497 2,914 29,764 35,568 (5,804) -16.32% Payroll Taxes 1,699 1,442 1,850 1,842 1,894 1,930 1,993 1,959 1,878 2,139 2,102 2,188 22,916 23,676 (760) -3.21% IPERS/Retirement Contributions 2,001 1,784 2,288 2,279 2,342 2,384 2,462 2,420 2,320 2,660 2,633 2,721 28,294 29,292 (998) -3.41% Contracted Serices - - - - - - - - - - - - - 0.00% Total Costs of Employment 28,191 24,351 30,595 30,286 31,110 31,664 32,623 32,107 30,882 35,609 35,753 36,201 379,372 401,963 (22,591) -5.62% - Programs & Services Promotion 5 75 - 510 645 250 - - - - 125 618 2,228 2,085 143 6.86% Volunteer Screening - - - 470 343 86 513 161 281 221 263 358 2,696 6,348 (3,652) -57.53% Mileage, Parking & Meals - 41 102 301 106 35 215 130 78 302 137 167 1,614 5,172 (3,558) -68.79% Grant Expense (JJYD)1,059 521 - 17 299 2,511 247 572 871 364 431 13,959 20,851 12,660 Supplies & Program Expenses 225 175 735 67 79 191 - 224 385 470 154 1,073 3,778 1,956 1,822 93.15% Total Programs & Services 1,289 812 837 1,365 1,472 3,073 975 1,087 1,615 1,357 1,110 16,175 31,167 28,221 (5,245) -18.59% BBBS Sponsored Events Expense BFKS Direct Expenses - - - - - - - 576 2,517 2,008 - - 5,101 6,000 (899) -14.98% BFKS Promotion - - - - - - - 72 - - - 72 1,000 (928) -92.80% Grocery Grab - - - - - - - - - - - - - 500 (500) -100.00% Alternative Event - - - - 4,594 4,517 - - - - - - 9,111 10,000 (889) -8.89% Breakfast Direct Expenses - 1,783 - - - - - - - - - - 1,783 - 1,783 0.00% Breakfast Promotion - - - - - - - - - - - - - - - 0.00% Miscellaneous 314 70 51 34 133 280 30 190 2,149 30 30 30 3,341 1,450 1,891 130.41% Totoal BBBS Sponsored Events Expense 314 1,853 51 34 4,727 4,797 30 766 4,738 2,038 30 30 19,408 18,950 458 2.42% purple = 4-H Endowment Start-up General & Administrative Bank Charges - 2 1 9 2 1 1 2 1 - 2 1 22 36 (14) -38.89% Board Expenses - - - - - - - - - - - - - 50 (50) -100.00% Computer Expense - 829 49 750 - - - - - 28 - 1,950 3,606 2,500 1,106 44.24% Dues & Memberships 372 - - 5,388 - 5,388 - - - 4,381 - 4,761 20,290 21,932 (1,642) -7.49% Equipment Maint/Purch 2,148 - 19 - 117 - - 94 - - 125 - 2,503 1,500 1,003 66.87% Job Advertising - 292 83 - - - - - - - - - 375 350 25 7.14% Miscellaneous - - - - 139 - 215 - - - 46 34 434 544 (110) -20.22% Postage - 220 - - - 589 - 175 - 237 10 - 1,231 1,465 (234) -15.97% Printing & Copying - 46 - - - 1,215 - - - 311 135 - 1,707 1,725 (18) -1.04% Staff Development - - - - - - 93 - - - 569 1,964 2,626 2,000 626 31.30% Meetings - - 83 - - - - - - - - - 83 50 33 66.00% Telephone - 5 - 192 5 5 5 - 10 5 5 342 574 636 (62) -9.75% Total General & Administrative 2,520 1,394 235 6,339 263 7,198 314 271 11 4,962 892 9,052 33,451 32,788 663 2.02% Total Expenses 32,314$ 28,410$ 31,718$ 38,024$ 37,572$ 46,732$ 33,942$ 34,231$ 37,246$ 43,966$ 37,785$ 61,458$ 463,398$ 481,922$ (18,524)$ -3.84% Change in Net Assets 2,632$ (19,388)$ (2,981)$ 10,826$ (15,791)$ (13,583)$ (3,634)$ 29,245$ 9,948$ (9,920)$ (17,717)$ (8,767)$ (39,130)$ (22,155)$ (16,975)$ 76.62% Prepared by Big Brothers Big Sisters of Johnson County Please note, $16,106 was diverted to our Endowment @ Iowa 4-H Foundation, adjusting actual deficit = $23,024 Big Brothers Big Sisters of Johnson County Statement of Changes in Net Assets For the One Month Periods Ending August 31, 2021 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 YTD Total Annual Budget $ Long /(Short) % Long /(Short) Acutal Results for the One Month Period Ending:Variance from Budget Total Revenues 34,946 9,022 28,737 48,850 21,781 33,149 30,308 63,476 47,194 34,046 20,068 52,691 424,268 0.00% Total Expenses 32,314 28,410 31,718 38,024 37,572 46,732 33,942 34,231 37,246 43,966 37,785 61,458 463,398 0.00% Total Change in Net Assets 2,632 (19,388) (2,981) 10,826 (15,791) (13,583) (3,634) 29,245 9,948 (9,920) (17,717) (8,767) (39,130) 0.00% Prepared by Big Brothers Big Sisters of Johnson County