1. Determine the sources of funds. Explain them
2. Determine the primary uses of funds and list them by the percentage used.
3. Determine the amounts set aside for capital expenditures? Identify the plans that these funds will be used for, by researching the facilities plan for College of the Desert.
College of the Desert General Fund Summary Fiscal Year 2022-2023 Adopted Budget and Multi-Year Projection Combined Restricted and Unrestricted General Fund % Change over PY Change Unaudited % Change Adopted Projected Projected Change Projected Change Actuals over PY Actuals Actuals over PY Budget Actuals Budget over PY Budget over PY 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 Revenues Federal Revenue 4,015,595 20.6% 10,907,188 9,954,642 8.7% 3,275,255 -67.1% 3,397,972 3.7% 3,517,428 3.5% State Revenue 47,414,295 17.6% 47,626,752 52,853,559 11.0% 79,918,630 51.2% 63,132,720 -21.0% 63,601,158 0.7% Local Property Taxes 42,512,877 0.8% 43,609,000 48,014,154 10.1% 49,214,508 2.5% 50,678,778 3.0% 51,992,611 2.6% Local Fees & Revenue 7,928,543 3.2% 6,826,610 5,633,144 -17.5% 9,382,308 66.6% 7,082,867 -24.5% 7,316,122 3.3% Total Revenues 101,871,310 8.3% 108,969,550 116,455,499 .9% 141,790,701 21.8% 124,292,338 -12.3% 126,427,319 1.7% Expenditures Academic Salaries 33,326,568 7.0% 34,384,572 35,543,964 3.4% 37,556,808 5.7% 41,966,172 11.7% 44,513,187 6.1% Non-Academic Salaries 20,084,527 2.5% 21,381,013 22,234,293 4.0% 26,067,555 17.2% 27,155,970 4.2% 30,051,571 10.7% Employee Benefits 22,860,186 -2.6% 23,351,538 25,676,068 10.0% 28,321,734 10.3% 29,069,923 2.6% 30,286,488 4.2% Total Salaries & Benefits 76,271,281 2.8% 79,117,123 83,454,325 5.5% 91,946,097 10.2% 98,192,065 6.8% 104,851,246 6.8% Materials & Supplies 2,004,954 -21.9% 1,873,212 2,419,924 29.2% 5,168,615 113.6% 2,578,873 -50.1% 2,682,543 4.0% Services and Operating Expenses 9,566,414 -10.1% 10,544,018 13,957,836 32.4% 21,952,909 57.3% 16,757,288 -23.7% 15,494,227 7.5% Capital Outlay 1,244,386 -16.2% 1,136,560 2,940,130 158.7% 4,347,446 47.9% 4,104,920 -5.6% 5,485,434 33.6% Total Expenditures 89,087,035 0.2% 92,670,913 102,772,215 10.9% 123,415,067 20.1% 121,633,146 1.4% 128,513,450 5.7% Excess (Deficiency) 12,784,275 16,298,637 13,683,284 18,375,634 2,659,191 (2,086,132) Transfers & Contributions 904,320 1,309,237 1,854,160 4,127,554 5,760,002 Other Outgo 7,572,266 12,582,494 11,059,468 20,215,581 6,695,292 3,335,202 Total Other Sources & Uses (7,572,266) 201.7% (11,678,174) (9,750,231) -16.5% (18,361,421) 88.3% (2,567,738) -86.0% 2,424,801 -194.4% Change in F 5,212,009 4,620,463 3,933,053 14,213 1,454 338,669 Beginning Fund Balance 17,620,131 22,832,140 27,452,600 31,385,654 31,399,868 31,491,322 Audit Adjustments Adjusted Beginning Balance 17,620,131 22,832,140 27,452,600 31,385,654 31,399,868 31,491,322 Ending Fund Balanc 22,832,140 29.6% 27,452,602 31,385,653 14.3% 31,399,868 0.0% 31,491,322 0.3% 31,829,991 1.1% Page 1 of 4
