School District Budget Monitoring Report November 2020 Highlights
Explore the detailed analysis of the school district's financial performance in November 2020. The report covers budget monitoring, cash and investments comparison, monthly expenditures breakdown, and summary of all funds. Key insights include changes in cash and investments, revenue and expenditure comparisons, and fund balance variations.
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
AAPS MONTHLY BUDGET MONITORING REPORT NOVEMBER 2020 Presented to the Board of Education January 20, 2021 Prepared by Darci Francoeur, Director of Finance, Treasury & Grants Presented by Jill Minnick, Assistant Superintendent Finance and Operations
Comparison of Cash and Investments Report November 30, 2019 and November 30, 2020 Cash and Investments 11/30/19 $19,525,057 Cash and Investments 11/30/20 $45,605,803 Cash and Investments Change $26,080,746 General Fund Community Services Fund 3,579,451 1,087,721 (2,491,730) Food Service Fund (143,757) (160,107) (16,350) Student/School Activity Fund 1,535,923 1,242,017 (293,906) TOTAL $24,496,674 $47,775,434 $23,278,760 2 November 2020 Monthly Budget Monitoring Report January 20, 2021
Report of Monthly Expenditures for November 2020 General Fund $22,035,335 Community Services Fund 209,449 Food Service Fund 313,042 Student/School Activity Fund 19,509 TOTAL $22,577,335 3 November 2020 Monthly Budget Monitoring Report January 20, 2021
Comparison of Summary of All Funds Report YTD November 30, 2019 and November 30, 2020 Prior Income Statement Comparison Year-to-Date 2019-2020 Year-to-Date 2020-2021 Percent Changes Revenue General Fund $77,905,444 3,548,545 1,126,309 1,846,631 $84,426,929 $82,277,462 427,101 1,093,450 58,784 $83,856,797 $4,372,018 (3,121,444) (32,859) (1,787,847) $(570,132) 5.6% -88.0% -2.9% -96.8% -0.7% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL Expenditures General Fund $79,871,839 2,302,654 760,032 1,613,121 $84,547,646 $79,884,984 1,505,838 1,025,956 55,924 $82,472,702 $13,145 (796,816) 265,924 (1,557,197) $(2,074,944) 0.0% -34.6% 35.0% -96.5% -2.5% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL 4 November 2020 Monthly Budget Monitoring Report January 20, 2021
Comparison of Summary of All Funds Report YTD November 30, 2019 and November 30, 2020 (cont d) Prior Income Statement Comparison Year-to-Date 2019-2020 Year-to-Date 2020-2021 Percent Changes Addition (Reduction) to Fund Balance General Fund $(1,966,395) 1,245,891 366,277 233,510 $(120,717) $2,392,478 (1,078,737) 67,494 $4,358,873 (2,324,628) (298,783) (230,650) $1,504,812 221.7% -186.6% -81.6% -98.8% -1246.6% Community Services Fund Food Service Fund Student/School Activity Fund 2,860 TOTAL $1,384,095 Beginning Fund Balance General Fund Community Services Fund Food Service Fund Student/School Activity Fund $17,542,843 2,185,636 $20,575,615 2,244,235 $3,032,772 58,599 17.3% 2.7% 0.0% 0.0% 22.2% - - - - 1,283,606 $24,103,456 1,283,606 $4,374,977 TOTAL $19,728,479 Ending Fund Balance General Fund Community Services Fund Food Service Fund Student/School Activity Fund $15,576,448 3,431,527 366,277 233,510 $19,607,762 $22,968,093 1,165,498 67,494 1,286,466 $25,487,551 $7,391,645 (2,266,029) (298,783) 1,052,956 $5,879,789 47.5% -66.0% -81.6% 450.9% 30.0% TOTAL November 2020 Monthly Budget Monitoring Report January 20, 2021 5
Summary of All Funds Reports Revenues and Expenditures for Month Ending November 2020 Month- to-Date 2020-2021 Year- to-Date 2020-2021 Budget 2020-2021 Balance 2020-2021 YTD Percent Revenue General Fund $248,710,996 3,780,310 4,394,734 850,000 $257,736,040 $14,229,510 $82,277,462 427,101 1,093,450 58,784 $83,856,797 $166,433,534 3,353,209 3,301,284 791,216 $173,879,243 33.1% 11.3% 24.9% 6.9% 32.5% Community Services Fund Food Service Fund Student/School Activity Fund 7,961 287,452 9,082 TOTAL $14,534,005 Expenditures General Fund $256,188,005 4,424,566 4,394,734 850,000 $265,857,305 $22,035,335 209,449 313,042 19,509 $22,577,335 $79,884,984 1,505,838 1,025,956 55,924 $82,472,702 $176,303,021 2,918,728 3,368,778 794,076 $183,384,603 31.2% 34.0% 23.3% 6.6% 31.0% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL 6 November 2020 Monthly Budget Monitoring Report January 20, 2021
Summary of All Funds Reports Revenues and Expenditures for Month Ending November 2020 (cont d) Month- to-Date 2020-2021 Year- to-Date 2020-2021 Budget 2020-2021 Addition (Reduction) to Fund Balance General Fund $(7,477,009) (644,256) $(7,805,825) (201,488) (25,590) (10,427) $(8,043,330) $2,392,478 (1,078,737) 67,494 Community Services Fund Food Service Fund Student/School Activity Fund - - 2,860 $(8,121,265) $1,384,095 TOTAL Beginning Fund Balance General Fund Community Services Fund Food Service Fund Student/School Activity Fund $20,575,615 2,244,235 $20,575,615 2,244,235 - - 1,283,606 $24,103,456 1,283,606 $24,103,456 TOTAL Ending Fund Balance General Fund Community Services Fund Food Service Fund Student/School Activity Fund $13,098,606 1,599,979 $22,968,093 1,165,498 67,494 1,286,466 $25,487,551 - 1,283,606 $15,982,191 TOTAL 7 November 2020 Monthly Budget Monitoring Report January 20, 2021
