A Use the information below to fill in the yellow areas in the spreadsheet. Provide an explanation for your work. Cash inflow: 27 28 Federal sources: $300,000, paid in January State sources: $300,000, paid bimonthly Local sources: $200,000, paid semiannually in July and January Federal State Local 12 13 14 15 16 Total cash outflow 17 Differences 18 19 20 Beginning cash balance 21 Ending cash balance B 1 2 Solution to Assignment 23.2. Developing a Cash-Flow Budget 3 Cash-Flow Budget for a Preschool ($ in thousands) 4 5 Cash 6 Receipts 7 8 9 10 Total cash inflow 11 Outlay PERSONNEL SERVICE COSTS CONTRACTED SERVICES SCHOOL OPERATIONS FACILITY MAINTENANCE Net cash flows Develop a cash budget based on the following information about a K-12 school. Its fiscal year runs from July 1 to June 30. 22 23 Cash safe margin 24 Cash shortage to borrow or surplus to invest 25 26 Solution: mark the correct one: Jul D 300,000 200,000 Aug E Sep 300,000 F Oct 10.000 100,000 100,000 100,000 100,000 10,000 10,000 10.000 20,000 20,000 20,000 30,000 30,000 30,000 30,000 160,000 160,000 160,000 160,000 20.000 G Nov 300,000 H Dec Cash outflow: Personnel services costs: $100,000 Contracted services: $10,000 School operations: $20,000 Facility operations & maintenance: $30,000 I Jan 300,000 300,000 200,000 J Feb K Mar 300,000 L M Apr May 300.000 N The preschool needs to have an $10,000 reserve or other liquidity to embark on the preschool program. The preschool needs to have an $170,000 reserve or other liquidity to embark on the preschool program. The preschool needs to have an $100,000 reserve or other liquidity to embark on the preschool program. Jun 100,000 100,000 100,000 100,000 100,000 10.000 10.000 10.000 10.000 100,000 100,000 100,000 10,000 10.000 10.000 10,000 20.000 20,000 20,000 20,000 20.000 20.000 20.000 20.000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 160,000 160,000 160,000 160,000 160,000 160,000 160,000 160,000 O Total