eu Grand Can, X | | StudentPo X | € Word Mic x | Il Document: x | @) ADM626T x | @) ADM6267 x | g GrandCan Xx @ chen2eb x () ADM626T x
C @ viewer.geu.edu/HGAK
PROJECTED CASH FLOW FOR VEAR ONE OF OPERATIONS A
opie duly 1, 2014 to June 30, 2015 o
July August September October November December January Fe
uary March April May June TOTAL
CASH INFLOW
REVENUES FROM
STATE SOURCES
Per Pupil Revenue
TOTAL REVENUE XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX178143
FROM STATE
SOURCES
ed TOTAL REVENUE 14250 = = XXXXXXXXXX XXXXXXXXXX,875
FROM FEDERAL
SOURCES
TOTAL REVENUE FROM ~~ = z a - a0 - = 2 c XXXXXXXXXX,750
LOCAL and OTHER
SOURCES
TOTAL CASH INFLOW XXXXXXXXXX — XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
CASH OUTFLOW
TOTAL PERSONNEL XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
SERVICE COSTS
TOTAL CONTRACTED ~~ XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
SERVICES
TOTAL SCHOOL XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX250574
OPERATIONS
TOTAL FACILITY XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX348064
OPERATION &
MAINTENANCE
[~] TOTALCASH OUTFLOW XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX21592f
NET CASH FLOW XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
Beginning Cash XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX
ie Balance
ENDING CASH 380,734 102,719 231,714 57,619 169,696 144,284 304,970 126,292 271,703 85,625 210,869 108,524 203,665
@MBQ xa 2 e B Are 64300 ®0
eu Grand Can, X | | StudentPo x | € Word Mic x
C @ viewer.geu.edu/HGAI
Balance
ENDING CASH XXXXXXXXXX,714 57, XXXXXXXXXX304,970 126,202 271, XXXXXXXXXX,869
BALANCE
Cash safe margin 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50, XXXXXXXXXX,000
Cash shortage to XXXXXXXXXX,719 181,714 7, XXXXXXXXXX254,970 76,202 221, XXXXXXXXXX,869
o
ow or surplus
to invest
Note: Original table downloaded from New York State Education Dept. with simplication and minor modification for ilustration purpose.
FORECASTING AND MANAGING CASH FLOW
Summary
ll Document x | @ ADM6267 Xx | @) ADM6267 X | x GrandCan x @ chenzen x {) ADM6267T X | + vo _ B x
108,524 203,665
50,000
58,524
Public organizations need to carefully manage their cash flow in addition to implementing accrual based
udgetary control. A useful tool for managing cash is cash flow forecasting or cash budgeting. Mo;
public organizations prepare a cash budget on at least a monthly basis so that they can foresee cash
shortages and surpluses. Management is therefore prepared if co
ective actions are needed.
There are multiple ways of dealing with short-term cash shortages and surpluses. Much of
the effort must be focused on sustaining uninte
upted public services and safeguarding the
nuhlic funds that have heen entrusted ta the aranization Timely undating of the cash flow hid-
@OEMBQ ao de
B ar 64300 ®0