Cash Forecast FY23

JanuaryFebruaryMarchAprilMayJune
ForecastActualsForecastActualsForecastForecastForecastForecastForecastForecastForecast
Beginning Balances
Bank 60 - General3,969,8221,033,470
Less: Outstanding Checks*(452,702)(501,262)
Bank 53 - FFELP (International Exchange)10,428
Bank 52 - Perkins63,92765,554
Bank 09 - State5,027,0279,764,486
Bank 20 - State Allotment--
Bank 29 - State Capital Projects-(451,499)-(473,757)-
Total Beginning Balance8,156,5758,156,5759,898,9189,898,9189,678,3228,208,04811,818,7879,117,843
Inflows
Tuition/Fees/Room/Board
Student Payments - from students950,426956,871581,519264,2151,613,0111,059,764433,181406,725
Student Payments - direct loans/federal funds131,8543,400,0003,971,659500,000250,000
State Appropriations6,968,9006,968,9005,575,100
Grants and contracts1,606,8021,254,2751,606,8022,746,9382,232,3822,232,3822,232,3822,232,382
Other Revenues109,057-109,057-109,057109,057109,057109,057
Total Inflows9,635,1859,311,9015,697,3776,982,8114,454,4509,226,3032,774,6212,748,164
Outflows
Payroll (Monthly, hourly, student)(1,578,357)(1,468,126)(1,478,357)(1,464,533)(1,478,357)(1,478,357)(1,428,357)(1,403,357)
State Pension liability(194,000)(194,706)(194,000)(194,706)(194,000)(194,000)(194,000)(194,000)
Vendor payments(3,285,050)(3,528,349)(3,215,330)(3,040,364)(3,110,365)(3,110,365)(3,090,365)(3,080,365)
Total Outflows(5,715,564)(7,569,558)(6,292,091)(7,203,407)(5,924,724)(5,615,564)(5,475,564)(5,380,564)
Net change in cash3,919,6201,742,343(594,714)(220,596)(1,470,274)3,610,739(2,700,944)(2,632,400)
Ending Balance12,076,1959,898,9189,304,2049,678,3228,208,04811,818,7879,117,8436,485,443

30