Loading...
HomeMy WebLinkAbout05.b. (Handout) CashFlows-Balances2020 Item 5.b. (Handout) Running Expense,Sewer Construction,Debt Service Fund Balances and Flows FY 2019-20 Projected Balance $76,831,117 $86,457,168 $76,607,168 $67,257,168 $58,147,168 $110,179,583 $101,704,583 $92,249,926 $81,049,926 $121,798,926 $109,823,926 $101,867,651 Actual Balance $76,060,241 $64,637,964 $80,627,283 $74,425,137 $60,810,506 $118,683,951 $109,368,521 $100,142,579 $91,540,765 $131,773,908 $127,180,396 $117,276,121 Projected Inflow $840,000 $24,028,808 $1,150,000 $1,150,000 $890,000 $62,782,415 $1,025,000 $950,000 $1,300,000 $53,749,000 $1,025,000 $6,229,500 Actual Inflow $1,405,721 $741,653 $25,691,394 $4,105,539 $2,196,269 $66,694,799 $527,939 $959,299 $634,523 $50,852,527 $1,275,454 $4,281,500 Projected Inflow Cumm. $840,000 $24,868,808 $26,018,808 $27,168,808 $28,058,808 $90,841,223 $91,866,223 $92,816,223 $94,116,223 $147,865,223 $148,890,223 $155,119,723 Actual Inflow Cumm. $1,405,721 $2,147,374 $27,838,768 $31,944,307 $34,140,576 $100,835,375 $101,363,314 $102,322,613 $102,957,136 $153,809,663 $155,085,117 $159,366,617 Projected Outflow $27,500,000 $14,402,757 $11,000,000 $10,500,000 $10,000,000 $10,750,000 $9,500,000 $10,404,658 $12,500,000 $13,000,000 $13,000,000 $14,185,775 Actual Outflow $28,836,597 $12,163,930 $9,871,805 $10,307,685 $15,810,900 $8,926,783 $9,843,369 $10,185,241 $9,236,337 $10,619,384 $5,868,966 $14,185,775 Projected Outflow Cumm. $27,500,000 $41,902,757 $52,902,757 $63,402,757 $73,402,757 $84,152,757 $93,652,757 $104,057,415 $116,557,415 $129,557,415 $142,557,415 $156,743,190 Actual Outflow Cumm. $28,836,597 $41,000,527 $50,872,332 $61,180,017 $76,990,917 $85,917,700 $95,761,069 $105,946,310 $115,182,647 $125,802,031 $131,670,997 $145,856,772 Cash&Investment Balances,Inflows&Outflows by Month $120,000,000 $100,000,000 $80,000,000 $60,000,000 $40,000,000 $20,000,000 $0 July August September October November December January February March April May June Projected Balance Actual Balance -Projected Inflow -Actual Inflow -Projected Outflow -Actual Outflow