Insight PA Cyber Charter School Financial Summary September 2021

insight pa cyber charter school september 2021 n.w
1 / 20
Embed
Share

"Explore the financial details of Insight PA Cyber Charter School for September 2021, including revenue, enrollment projections, expenditure breakdown, surplus/deficit, and more. Understand the key financial metrics and forecast variations."

  • Financials
  • School
  • Enrollment
  • Budget
  • Revenue

Uploaded on | 0 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

E N D

Presentation Transcript


  1. Insight PA Cyber Charter School September 2021 Financials

  2. Key Financial Summary September 30, 2021 Revenue: Board Budget FY22 Variance Inc/(Dec) % 14% average enrollment increase vs Board Budget Prior Forecast Current Forecast Change 4% average enrollment decrease vs Prior Forecast. 4,088 4,888 4,675 -213 -4% Average Enrollment $ 60,351,565 78,743,770 $ $ 79,728,365 $ 984,596 1% Total Revenue Title and IDEA Grants including prior year carryovers $ 57,854,965 64,614,948 $ $ 64,070,570 $ (544,378) -1% Total Expenditures New ESSERS II FY22 Grant Increased average PPR $ 2,496,600 14,128,821 $ $ 15,657,795 $ 1,528,974 Surplus/(Deficit) Expenditures: Enrollment related expenses increase Action Items & Key Deadlines Additional Grants funded programs and staff positions. Board Financial Action Items: Board Acceptance of the September 2021 Financial Statements Budget assumed all vacant and new staff positions would be filled 8/1/21. Board Approval of K12 payment and Non-K12 disbursements Surplus forecasted $15.7M, $13.2M increase versus budget. COMPANY CONFIDENTIAL 2

  3. Enrollment Projections ACTUAL FORECAST Average Daily Membership Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 K5 MS HS 1,642 889 1,331 1,794 958 1,403 1,879 1,035 1,507 1,909 1,055 1,517 1,952 1,075 1,532 2,016 1,108 1,560 2,098 1,146 1,585 2,094 1,139 1,562 2,091 1,134 1,547 2,092 2,098 2,098 2,025 1,133 1,135 1,135 1,107 1,541 1,539 1,539 1,543 ADM 3,862 4,155 4,421 4,480 4,559 4,683 4,830 4,796 4,772 4,766 4,771 4,771 4,675 10/1 Enrollment 4,421 ADM 21.4% Current Special Ed Population COMPANY CONFIDENTIAL 3

  4. Financial Summary Full Year Budget Comparison September 2021 Variance Current v. Budget Inc./(Dec) 432 132 23 587 % Prior Year Actual/ADM 2,010 997 1,259 4,266 Full Year Budget 1,593 2,287 2,025 974 1,092 1,107 1,520 1,510 1,543 4,088 4,888 4,675 Prior Forecast Current Forecast Variance to Prior Year % Variance to Budget K-8 Ending Enrollment MS Ending Enrollment HS Ending Enrollment Total Ending Enrollment 0.8% 11.0% 22.6% 9.6% 27.1% 13.6% 1.5% 14.4% 65,492,910 $ Total Funding 60,351,565 $ 78,743,770 $ 79,728,365 $ 21.7% 19,376,800 $ 32.1% INSTRUCTION Teachers Related Expenses Students Related Expenses Student and Family Services Total Instruction 18,427,875 $ 15,091,066 2,257,012 35,775,953 $ 24,089,614 $ 15,800,487 2,318,941 42,209,042 $ 26,117,877 $ 18,702,470 2,664,610 47,484,956 $ 26,193,765 $ 17,962,031 2,667,421 46,823,217 $ 42.1% 19.0% 18.2% 30.9% $ 2,104,151 2,161,544 348,480 4,614,175 $ 8.7% 13.7% 15.0% 10.9% SUPPORT SERVICES Admin & Governance Technology Insurance/Facilities/Ops Total Support Services 11,484,856 $ 2,098,493 709,426 14,292,774 $ 12,874,174 $ 2,047,100 724,649 15,645,923 $ 14,056,981 $ 2,336,362 736,649 17,129,992 $ 14,081,121 $ 2,283,882 882,350 17,247,353 $ 22.6% 8.8% 24.4% 20.7% $ 1,206,947 236,782 157,702 1,601,430 $ 9.4% 11.6% 21.8% 10.2% 50,068,728 $ Total School Expenditures 57,854,965 $ 64,614,948 $ 64,070,570 $ 28.0% $ 6,215,605 10.7% 15,424,182 $ Increase/(Decrease) to Fund Balance 2,496,600 $ 14,128,821 $ 15,657,795 $ 1.5% 13,161,195 $ 527.2% Comparison to Original Budget: Revenue: Current Forecast $19.4M higher than budget primarily due to increased enrollment, ESSER II, Title & IDEA Funds Expenses: Forecast $64.1M, 10.7% higher than original budget in direct relation to higher enrollment forecast & additional Grant related expenditures. Budget assumed open and new positions would be staffed by 8/1/21. Surplus: Projected YE: $15.7M COMPANY CONFIDENTIAL 4

  5. Statement of Revenues & Expenditures FY22YTD Through September 2021 REVENUES ACCOUNT 8741 8743 8749 7330 8512 6510 7506 6944 8514 8515 8516 8517 ACCOUNT NAME AMOUNT ESSER I ESSER II Other CARES Funding Pennsylvania Health Services Revenue Pennsylvania IDEA Part B Pennsylvania Interest Income Pennsylvania PAsmart Grants Pennsylvania Receipts from other LEA's in PA Pennsylvania Title I Pennsylvania Title II Pennsylvania Title III Pennsylvania Title IV 57,624 611,543 149,074 17,435,707 346,400 29,891 1,719 5,002 TOTAL REVENUES $ 18,636,959 COMPANY CONFIDENTIAL 5

  6. Statement of Revenues & Expenditures FY22 YTD Through September 2021 EXPENDITURES PDE FUNCTION CODE DESCRIPTION AMOUNT 1000 1190 1200 1490 2100 2200 2300 2400 2500 2600 2800 2900 3200 3300 Regular Instruction Federally Funded Regular Programs Special Programs - Elementary / Secondary Additional Other Instructional Pograms Support Services - Students Support Services - Instructional Staff Support Services - Administration Support Services-Pupil Health Support Services-Business Operation and Maintenance of Plant Services Support Services Central Other Support Services Student Activities Community Services $ 5,799,255 330,325 1,388,974 6,002 1,307,537 519,117 1,079,125 57,584 128,048 156,900 757,471 28,444 - - TOTAL YTD EXPENDITURES $ 11,558,782 TOTAL YTD SURPLUS $ 7,078,178 COMPANY CONFIDENTIAL 6

  7. 2022 Cash Flow Projection Actual 21-Jul Actual 21-Aug Actual 21-Sep Budget 21-Oct Budget 21-Nov Budget 21-Dec Budget 22-Jan Budget 22-Feb Budget 22-Mar Budget 22-Apr Budget 22-May Budget 22-Jun Beginning cash balance 22,331,682 $ 24,068,092 $ 26,296,526 $ 22,521,253 $ 22,548,174 $ 22,031,944 $ 21,340,694 $ 20,783,677 $ 20,278,077 $ 19,193,778 $ 18,263,143 $ 17,861,455 $ Tuition Deposits Other Funding - Cash Advance Total Funding Received 3,924,267 1,358 3,925,625 $ 5,128,917 4,248,798 424,452 4,673,250 $ 6,173,413 869,107 7,042,520 $ 5,895,098 849,105 6,744,203 $ 5,895,098 845,318 6,740,416 $ 5,895,098 845,318 6,740,416 $ 5,895,098 845,318 6,740,416 $ 5,895,098 845,318 6,740,416 $ 5,895,098 845,318 6,740,416 $ 5,895,098 845,318 6,740,416 $ 5,895,098 967,087 6,862,185 $ 5,128,917 $ Payments - non K12 - Payroll - Psers Employer Funding - Rent - Other Payments - K12 Total Disbursements (1,539,007) $ (1,545,009) $ (1,637,365) $ (179,499) (38,380) (807,139) (5,786,139) (8,448,523) $ (2,749,967) $ (2,756,532) $ (2,756,532) $ (330,784) (38,862) (2,017,948) (2,287,540) (7,431,666) $ (2,756,532) $ (2,756,532) $ (2,756,532) $ (330,784) (38,862) (2,368,496) (2,330,042) (7,824,716) $ (2,756,532) $ (2,756,532) $ (2,878,301) $ (345,396) (38,862) (1,435,111) (2,210,662) (6,908,332) $ (37,999) (612,209) (2,189,214) $ (38,532) (1,316,942) (2,900,484) $ (50,862) (2,058,052) (2,156,719) (7,015,600) $ (38,862) (1,962,802) (2,502,236) (7,260,432) $ (38,862) (2,160,473) (2,341,566) (7,297,433) $ (38,862) (1,976,484) (2,474,138) (7,246,016) $ (38,862) (2,608,676) (2,266,980) (7,671,051) $ (38,862) (2,117,681) (2,229,029) (7,142,105) $ - - Ending cash balance - Current Ending cash balance - Prior Year 24,068,092 $ 9,226,866 $ 26,296,526 $ 8,396,215 $ 22,521,253 $ 8,022,363 $ 22,548,174 $ 7,531,052 $ 22,031,944 $ 11,560,094 $ 21,340,694 $ 14,026,606 $ 20,783,677 $ 17,334,139 $ 20,278,077 $ 18,780,013 $ 19,193,778 $ 20,223,910 $ 18,263,143 $ 22,077,460 $ 17,861,455 $ 22,008,687 $ 17,815,308 $ 22,331,682 $ Net Cash per Month - Current Net Cash per Month - Prior Year 1,736,410 $ 576,469 $ 2,228,434 $ (830,651) $ (3,775,272) $ (373,852) $ 26,920 (491,311) $ $ (516,229) $ 4,029,042 $ (691,250) $ 2,466,512 $ (557,017) $ 3,307,533 $ (505,600) $ 1,445,873 $ (1,084,300) $ 1,443,897 $ (930,635) $ 1,853,550 $ (401,688) $ (68,773) $ $ $ (46,147) 322,994 Days Cash on Hand - Current Days Cash on Hand - Prior Year 185.7 67.0 230.4 67.0 151.4 48.1 111.7 45.3 88.2 203.5 89.5 30.4 86.0 71.5 84.0 86.0 78.1 81.3 73.1 82.0 71.8 96.5 74.6 67.0 Goal: Maintain 2-3 months of working capital at all times, approximately $13M - $19M covering all disbursements Days Cash on Hand = current month ending cash/total disbursements COMPANY CONFIDENTIAL 7

  8. Disbursements September 2021 Date 09/01/21 09/29/21 09/08/21 09/08/21 09/29/21 09/15/21 09/01/21 09/29/21 09/29/21 09/29/21 09/01/21 09/29/21 09/29/21 09/01/21 09/08/21 09/29/21 09/29/21 09/15/21 09/15/21 09/08/21 09/15/21 09/01/21 09/29/21 09/15/21 Vendor K12 MANAGEMENT INC K12 MANAGEMENT INC Independence Blue Cross SMARTSHEET Inc. VIRTUAL TECHNOLOGIES GROUP SBH ASSOCIATES, L.P. VIRTUAL TECHNOLOGIES GROUP LIFE INSURANCE COMPANY OF NORTH AMERICA Reading Plus LLC. GRANATT LLC LIFE INSURANCE COMPANY OF NORTH AMERICA COMM-CORE AUDACY OPERATIONS INC COMM-CORE METLIFE SMALL BUSINESS CENTER OFFICETEAM THIRTY INC D/B/A EDEN RESORT & SUITES SOLUTION TREE INC THE PALACE CENTER ERIE COUNTY CONVENTION CENTER AUTHORITY dba SHERATON ERIE BAYFRONT HOTEL OFFICETEAM OFFICETEAM SMARTSHEET Inc. NORMANDY DEVELOPMENT LP D/B/A NORMANDY FARM 15078 Document No Amount 3,227,233 2,558,906 256,397 46,988 40,909 38,272 16,531 15,043 14,885 14,000 13,917 13,063 12,300 12,059 11,881 9,540 9,200 8,500 8,000 7,257 6,674 5,956 5,728 5,134 Date 09/29/21 09/08/21 09/29/21 09/08/21 09/08/21 09/08/21 09/29/21 09/15/21 09/29/21 09/15/21 09/08/21 09/15/21 09/29/21 09/01/21 09/29/21 09/01/21 09/29/21 09/15/21 09/01/21 09/15/21 09/24/21 09/15/21 09/01/21 09/29/21 Vendor GOD TORONITA LLC D/B/A FOUR POINTS SHERATON YORK OFFICETEAM THERAPY SOURCE PenServ Plan Services, Inc. TAYMARK D/B/A GRADUATION AUTHORITY Nippon Life Insurance Co of America A/CAPA VIRTUAL TECHNOLOGIES GROUP ENTRY LEVEL LLC D/B/A ENTRY LEVEL NURSE AIDE PROGRAM NCS PEARSON LINDA J HELLER THERAPY SOURCE McKenna Snyder LLC Staples MATT MASCARI SUPPORT BRANDS LLC Liberty Therapy Solutions LEVEL 3 COMMUNICATIONS, LLC Sunnyland Management Co, LLC DBA Hampton Inn LANGUAGE LINE SERVICES PITNEY BOWES GLOBAL FINANCIAL SERVICES LLC A/CAPA DEVON HEALTHCARE GROUP AUDACY OPERATIONS INC Document No 15125 15055 15138 15056 15061 15054 15117 15086 15123 15077 15052 15085 15132 15036 15131 15035 15130 15075 15037 15073 Amount $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4,800 4,421 3,741 3,632 3,485 3,069 2,671 2,538 2,500 2,491 2,415 1,743 1,680 1,464 1,384 1,320 1,271 1,207 1,200 1,133 1,021 1,005 1,000 1,000 15051 15059 15141 15082 15039 15129 15134 15126 15030 15120 15119 15025 15053 15133 15139 15083 15084 15050 15079 15033 15135 15070 15026 15118 COMPANY CONFIDENTIAL 8

  9. Disbursements September 2021 Date 09/01/21 09/01/21 09/01/21 09/08/21 09/30/21 09/08/21 09/01/21 09/29/21 09/15/21 09/15/21 09/08/21 09/15/21 09/29/21 09/29/21 09/01/21 09/08/21 09/15/21 09/08/21 09/01/21 09/15/21 09/01/21 09/08/21 09/29/21 09/29/21 Vendor K12 MANAGEMENT INC K12 MANAGEMENT INC LITERACY RESOURCES LLC D/B/A HEGGERTY PHONEMIC AWARENESS APPLIED EDUCATIONAL SYSTEMS, INC. PITNEY BOWES GLOBAL FINANCIAL SERVICES LLC Don Johnston TransAmerica Employee Benefits TransAmerica Employee Benefits PERSAD CENTER INC Verizon Wireless Nichol A Laskey PITTSBURG POST-GAZETTE Ranelle C Hartley Infinisource Inc DBA Isolved Benefit Serv. LA TONJA MCMILLAN ELLINGSEN & ASSOCIATES INC Amanda Thomas THERAPY SOURCE Liberty Therapy Solutions CONNECTING THE PIECES, LLC GLOBAL TELETHERAPY SARAH M KING DeLage Landen, Inc. Lauren Ardiff Document No Amount Date 09/08/21 09/15/21 09/29/21 09/29/21 09/29/21 09/15/21 09/29/21 09/29/21 09/29/21 09/29/21 09/29/21 09/22/21 09/15/21 09/29/21 09/08/21 09/29/21 09/01/21 09/08/21 09/01/21 09/15/21 09/01/21 09/15/21 09/15/21 09/15/21 Vendor VIRTUAL TECHNOLOGIES GROUP Carolyn R Whalen Ranelle C Hartley EBS Healthcare Jenna Schreiner Verizon Wireless Karisa A Haslett Leah M Haney Diane Morian Tara E Stine Elizabeth A Ohnstad Audra E Mazzante LEARNING A-Z dba/Explore Learning Megan Miller Staples Staples Jennifer L Detruf Megan Miller Megan A Kiebler Melissa C Stanton Morgan B Peters Kiley Brady Kelsey Fuller David A Surovec Document No 15063 15091 15160 15122 15147 15087 15149 15155 15144 15161 15145 15107 15074 15157 15060 15137 15041 15067 15043 15102 15044 15100 15098 15092 Amount $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 951 951 800 799 774 675 658 658 500 486 421 419 409 400 350 350 344 336 315 313 276 268 254 239 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 218 200 200 184 166 160 155 150 150 150 150 145 138 130 126 124 121 120 109 105 100 100 100 100 15031 15047 15048 15038 15140 15080 15087 15068 15081 15160 15127 15029 15049 15089 15062 15032 15071 15028 15057 15121 15153 COMPANY CONFIDENTIAL 9

  10. Disbursements September 2021 Date 09/15/21 09/15/21 09/22/21 09/22/21 09/22/21 09/22/21 09/29/21 09/29/21 09/29/21 09/29/21 09/15/21 09/15/21 09/01/21 09/01/21 09/29/21 09/29/21 09/01/21 09/01/21 09/01/21 09/08/21 09/08/21 09/08/21 09/08/21 09/15/21 09/15/21 Vendor Erin R Harper Julia Long Tricia I Babilonia Matthew C Gill Gloria Campese Korrin Helinski Jill A Dunlap Kristin Barrett Melissa M Probst Emily M Prohorchuck Kay-Cee N O'Malley Melanie E Noel Johanna Best SBH ASSOCIATES, L.P. GLOBAL TELETHERAPY SUPPORT BRANDS LLC Hannah Bevington Stacy L Stuenzi Rebecca M Gilliard Carolyn J Hockman Lacey J Olbryk Diana M McDonell Sarah E Mazzulla Kelsey M Brenner Michelle L Botti Document No 15093 15096 15116 15112 15110 15111 15148 15152 15159 15146 15097 15101 15042 15034 15124 15136 15040 15046 15045 15064 15066 15065 15069 15099 15103 Amount Date 09/15/21 09/15/21 09/15/21 09/15/21 09/15/21 09/22/21 09/22/21 09/22/21 09/22/21 09/22/21 09/29/21 09/29/21 09/29/21 09/29/21 09/29/21 09/29/21 09/29/21 09/15/21 09/15/21 09/15/21 09/29/21 09/08/21 09/29/21 09/01/21 09/15/21 Vendor Amanda Morrison Johanna Best Hannah Bevington Sarah M Ridder Valerie L Marraccini Michelle N Turner Diana M McDonell Caitlin D Klan Shari Donch Stacy L Stuenzi Amanda J Faust Krista M Fischetti LIFE HEALTH STRENGTH PHYSICAL REHABILITATION Tara Rosa Maria J D'Amato Krista C Clark Catherine M Flynn Liberty Therapy Solutions Rebecca Brossman Brett M Witmer Lauren Spelling SBH ASSOCIATES, L.P. Melissa A Cichello EBS Healthcare Infinisource Inc DBA Isolved Benefit Serv. Document No 15088 15095 15094 15105 15106 15113 15109 15108 15114 15115 15142 15151 15128 15162 15156 15150 15143 15076 15104 15090 15154 15058 15158 15027 15072 Amount $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 100 100 100 100 100 100 100 100 100 90 80 80 77 72 71 60 50 50 50 50 50 50 50 50 50 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 45 45 40 40 36 30 23 14 Total $ 6,428,912 COMPANY CONFIDENTIAL 10

  11. K12 Invoice Aging Recommended Payment $ Bill GL Posting Date 1-30 31-60 Total K12 MANAGEMENT ISPA 003-3603 OLS ISPA 003-3649 M&T FY20 True Up ISPA 003-3585 IST ISPA 003-3647 COM ISPA 003-3602 MAT ISPA 003-511 PR MISC CM ISPA 003-3506 M&T Total Payments for Board Approval 09/01/21 09/01/21 09/01/21 09/01/21 09/01/21 09/15/21 09/15/21 $ 685,833 7,002 8,778 295,656 765,815 (6,320) 399,956 $ 2,156,719 $ 685,833 7,002 8,778 295,656 765,815 (6,320) 399,956 685,833 7,002 8,778 295,656 765,815 (6,320) 399,956 $ - $ 2,156,719 $ 2,156,719 COMPANY CONFIDENTIAL 11

  12. 2021-2022 Top 10 AR Balances As of 09-30-21 Amounts Due Amounts Paid District Regular Ed $ 107,390 $ 52,561 $ 159,951 84,537 250,573 74,886 72,104 102,698 28,663 158,929 69,325 153,807 6,577,381 4,404,747 $ 7,680,292 $ 5,230,402 $ 12,910,694 Special Ed Total Due District $ - $ - $ - $ - $ 159,951 0 - - 0 273,001.45 - 44,086 0 - 0 0 - 0 187,288 - 0 - - 178,086 - - 0 - - - 169,390 - - 6,801,219 1,618,980 $ 7,192,781 $ 2,079,269 $ - $ 9,272,050 UniPay Refunds Total Paid Net Due East Stroudsburg Area SD Harrisburg City SD Pittsburgh SD Southeast Delco SD Lancaster SD Chester-Upland SD Neshaminy SD Reading SD William Penn SD Allentown City SD All Other Districts Total 71,731 149,980 82,760 41,454 175,667 53,794 98,667 8,477 90,565 156,268 400,553 157,645 113,558 278,365 82,456 257,596 77,803 244,372 10,982,128 0 156,268 127,552 113,560 113,558 91,077 82,456 79,509 77,803 74,982 2,561,929 273,001 44,086 0 187,288 0 178,086 169,390 8,420,199 0 $ 3,638,644 $ 1,076,715 Total Top 10 Top 10 % 39% COMPANY CONFIDENTIAL 12

  13. 2020-2021 Top 10 AR Balances As of 09-30-21 Amounts Due Amounts Paid District Regular Ed $ 10,924,744 $ 5,529,914 $ 16,454,659 443,932 580,880 171,388 63,251 767 363,721 286,468 109,523 19,123 26,412,267 16,740,134 $ 39,376,063 $ 24,251,893 $ 63,627,955 Special Ed Total Due UniPay $ - $ - $ 15,785,031 $ 669,628 628,245 231,320 - 732,561 - - 300,875 0 - 30,599 0 - 5,318 - - 469,311 - - 649,105 - - 72,758 - - 72,758 68,150 - - 28,462,275 15,483,105 14,432 $ 47,204,228 $ 15,714,426 $ 14,432 $ 62,904,221 $ 723,734 District Refunds Total Paid Net Due Philadelphia City SD Chester-Upland SD East Stroudsburg Area SD Bensalem Township SD Charleroi SD Aliquippa SD Lancaster SD Bethlehem Area SD Palisades SD Exeter Township SD All Other Districts Total $ 15,785,031 770,976 304,591 214,585 11,489 47,944 146,284 403,179 1,214,908 885,471 385,974 74,739 48,711 510,004 689,646 109,523 101,919 43,152,401 859,565 732,561 300,875 30,599 5,318 469,311 649,105 355,343 152,910 85,099 44,141 43,393 40,693 40,542 36,765 33,768 -778,547 0 82,796 68,150 43,930,948 Total Top 10 Top 10 % $ 1,502,281 39% COMPANY CONFIDENTIAL 13

  14. 2019-2020 AR Balances As of 09-30-21 Amounts Due Amounts Paid District Regular Ed $ 31,626 $ - $ 31,626 Special Ed Total Due District $ - $ 22,604 $ - $ 22,604 $ 9,022 UniPay Refunds Total Paid Net Due California Area SD COMPANY CONFIDENTIAL 14

  15. Federal Funds As of 09-30-21 Program or Award Amount Total Received for the Program Expenditures Funds Remaining % Program Name Grant Period FY19 FY20 FY21 FY22 Remaining Title I GY21 Title I GY22 08/28/20 - 09/30/22 08/28/20 - 09/30/22 1,668,978 1,811,772 467,269 35,311 1,188,614 346,400 98,653 1,811,772 6% 100% Title II GY19 Title II GY21 Title II GY22 08/30/18 - 09/30/19 08/28/20 - 09/30/22 08/28/20 - 09/30/22 64,105 162,823 162,329 16,046 45,702 27,070 37,035 - 146,155 16,668 13,223 149,106 92% Title III GY21 Title III GY22 08/28/20 - 09/30/22 08/28/20 - 09/30/22 4,529 17,184 1,701 1,719 1,110 17,184 24% 100% Title IV GY21 Title IV GY22 08/28/20 - 09/30/22 08/28/20 - 09/30/22 45,436 125,435 25,963 3,911 5,002 36,523 125,435 80% 100% ESSER I / CARES Act ESSER II / CARES Act ESSER III / CARES Act 03/13/20 - 09/30/21 03/13/20 - 09/30/23 03/13/20 - 09/30/23 492,071 6,163,017 12,465,999 310,782 286,652 361,582 238,969 57,624 611,543 72,865 5,312,505 12,465,999 15% 86% 100% IDEA 611 GY21 07/01/20 - 06/30/21 363,159 201,148 27,849 335,311 68,862 (68,862) -19% TOTAL FEDERAL AWARDS GY19 GY21 GY22 64,105 2,736,997 $ 20,745,736 $ $ 16,046 1,050,865 $ 286,652 $ $ $ $ $ 27,070 $ $ $ 37,035 63,160 $ 2,037,274 $ 238,969 $ - $ 496,275 $ 624,766 $ - $ $ 19,882,001 $ - 0% 5% - - 140,288 - 100% COMPANY CONFIDENTIAL 15

  16. Personnel The following changes to staff occurred September 1, 2021 thru 31, 2021: Employee Totals September 30, 2021 Insight Employees 347 Hired 25 Separations 4 LOA - 5 K12 Employees 12 Total 359 Employee Type Teachers General Ed Teachers Special Ed Teacher Breakdown includes Specialists Elementary (K-5) Middle School 140 65 17 11 28 86 12 70 56 Interventionists & Instructional Coach Guidance Counselors School Administration Student Support Services K12 Administrative Services High School 67 HS Electives & CTE 12 COMPANY CONFIDENTIAL 16

  17. Personnel The following new staff were hired September 1, 2021 thru September 30, 2021 New Hires By Position Position Total Number Academic Data & Achieve. Analyst 1 Paraprofessional - HS 3 Student Resource Specialist 4 Teacher Gen Ed 1 2 Teacher Gen Ed 2 1 Teacher Gen Ed 3 1 Teacher Gen Ed 5 2 Teacher Gen Ed HS ELA 1 Teacher Gen Ed HS Science Teacher Gen Ed HS Social Studies 1 1 Teacher Gen Ed MS ELA 1 Teacher Gen Ed MS Science 1 Teacher HS Gen Ed CTE - BCIT 1 Teacher Interven. Elem Math 1 Teacher Spec Ed Elem 1 Teacher Spec Ed HS 1 Teacher Spec Ed MS 2 COMPANY CONFIDENTIAL 17

  18. Personnel Separated During September 2021 Separated Employees Name Hire Date Separation Date Annual Salary Job Title Wade , Kristie 10/12/20 09/03/21 55,786.00 Teacher Spec Ed HS Hartley, Ranelle C 01/01/21 09/23/21 73,338.00 School Psychologist Johnson, Allison Elizabeth 01/18/21 09/17/21 55,547.00 Teacher Gen Ed HS ELA Dalessandro, Bettina Marie 09/07/21 09/16/21 47,325.00 Teacher Gen Ed HS ELA COMPANY CONFIDENTIAL 18

  19. Personnel The following additional change to staff occurred September 1, 2021 thru September 30, 2021 Leave of Absence Name Leave Date Return Date Annual Salary Job Title Wells, Heather D 09/15/21 10/27/21 58,240.00 Teacher Gen Ed 3 Reimers, Stacey 08/23/21 11/15/21 59,613.00 Teacher Spec Ed HS Smitsky, Brooke 09/06/21 10/19/21 30,351.80 Paraprofessional - ES Peters, Morgan Brianne 09/20/21 12/13/21 59,450.00 Student Resource Specialist Williams , Trevor M 01/01/21 TBD 46,597.00 Student Support Advisor COMPANY CONFIDENTIAL 19

  20. Balance Sheet Assets Total Cash Total Fixed Assets Total Other Current Assets Total Assets As Of 6/30/2021 As Of 8/31/2021 As Of 9/30/2021 Change in Balance From Prev. Month Total Cash: School Districts & Grants payments received September Disbursements 22,331,681 $ $ $ 26,346,594 258,490 12,314,204 38,919,288 $ $ 22,571,322 253,061 18,655,509 41,479,891 $ $ $ $ (3,775,272) (5,429) 6,341,305 2,560,604 Total Other Current Assets: State & Federal Accounts Receivable Prepaid Testing Facility Expenses 264,977 8,653,127 31,249,785 $ Liabilities and Equity Liabilities Total Accounts Payable Total Other Current Liabilities Total Liabilities Total Liabilities: Decreased Trade Accounts Payable Increased Accrued Payroll Liabilities Increased Accrued M&T $ 1,721,454 7,321,412 9,042,866 $ $ 5,842,585 5,916,055 11,758,639 $ $ 2,157,067 10,326,140 12,483,207 $ $ $ (3,685,517) 4,410,086 724,568 $ Equity Total Equity For the full Balance Sheet, see supporting detail. 22,206,918 $ $ 27,160,649 $ 28,996,684 $ 1,836,035 31,249,785 $ Total Liabilities and Equity $ 38,919,288 $ 41,479,891 $ 2,560,604 COMPANY CONFIDENTIAL 20

More Related Content