Excel Sample Sheet 41783 | Cashflowworksheet

Partial file snippet.

Sheet 1: Cash Flow Worksheet Analysis

	
	
	
	
	
	
	
		This form is used by New Jersey school districts to document cash flow shortage due to the delayed June 2022 state aid payments. This worksheet contains five tables. All content is contained in columns A through F.
		
	
		New Jersey Department of Education
		
	
		Borrowing on June 2022 Delayed State Aid Payments
		
	
		Cash Flow Worksheet - General Fund
		
	
		Blank cells in the columns of this worksheet are used for data entry
		
	
		District Name:
		

		County Name:
		

		

		

	
	
		Line #
		Line Description
		Beginning Balance - April 30
		Anticipated Monthly Cash Activity - May
		Anticipated Monthly Cash Activity - June
		Estimated Ending Cash Balance 6/30/22 (Blank cells in this column are intentionally left blank) 
	
	
		1a
		4/30/22 General Fund Cash-On-Hand Book Balance
		 600,000 
		 not applicable in this table 
		 not applicable in this table 
		

	
	
		1b
		4/30/22 Preschool Cash-On-Hand Book Balance
		 70,000 
		 not applicable in this table 
		 not applicable in this table 
		

	
	
		1c
		Total Cash on Hand
		

		

		

		 670,000 
	
	
		General Fund and Preschool Investments - Month End Balance For Informational Purposes Only
		

		

		

		

		

	
	
		Line #
		Line Description
		Beginning Balance - April 30
		Anticipated Monthly Cash Activity - May
		Anticipated Monthly Cash Activity - June
		

	
	
		2
		  Certificates of Deposits
		 not applicable in this table 
		 60,000 
		 60,000 
		

	
	
		3
		  Treasury Bills
		 not applicable in this table 
		 8,000 
		 8,000 
		

	
	
		4
		  Other Investments:
		 not applicable in this table 
		

		

		

	
	
		4a
		

		 not applicable in this table 
		

		

		

	
	
		

		General Fund and Preschool Revenues to be received:
		

		

		

		

	
	
		Line #
		Line Description
		Beginning Balance - April 30
		Anticipated Monthly Cash Activity - May
		Anticipated Monthly Cash Activity - June
		

	
	
		5
		  Tax Levy (Payment Schedule)
		 not applicable in this table 
		 150,000 
		 150,000 
		

	
	
		6
		  Tuition Revenue
		 not applicable in this table 
		 7,000 
		 10,000 
		

	
	
		7
		  State Aid (Payment Schedule-Excluding Last Payments)
		 not applicable in this table 
		 600,000 
		 -   
		

	
	
		8
		  Other State Revenues
		 not applicable in this table 
		 50,000 
		 50,000 
		

	
	
		9
		  Unrestricted Federal Revenues (ex.Impact Aid)
		 not applicable in this table 
		 1,500 
		 4,000 
		

	
	
		10
		  Interest Income
		 not applicable in this table 
		 50 
		 25 
		

	
	
		11
		  Other Miscellaneous Local Revenue
		 not applicable in this table 
		 9,000 
		 2,000 
		

	
	
		12
		  Other receipts:
		 not applicable in this table 
		

		

		

	
	
		12a
		Preschool Revenues
		 not applicable in this table 
		 25,000 
		 10,000 
		

	
	
		12b
		

		 not applicable in this table 
		

		

		

	
	
		12c
		

		 not applicable in this table 
		

		

		

	
	
		12d
		

		 not applicable in this table 
		

		

		

	
	
		13
		Add: Subtotal - revenues
		 not applicable in this table 
		 842,550 
		 226,025 
		 1,068,575 
	
	
		

		General Fund and Preschool Expenses Paid/Due:
		

		

		

		

	
	
		Line #
		Line Description
		Beginning Balance - April 30
		Anticipated Monthly Cash Activity - May
		Anticipated Monthly Cash Activity - June
		

	
	
		14
		  Payroll (Payroll Records)
		 not applicable in this table 
		 650,000 
		 725,000 
		

	
	
		15
		  Payroll Taxes
		 not applicable in this table 
		 65,000 
		 72,500 
		

	
	
		16
		  Tuition Expenditures
		 not applicable in this table 
		 60,000 
		 35,000 
		

	
	
		17
		  A/P - (Amounts Due In Current Period)
		 not applicable in this table 
		 65,000 
		 100,000 
		

	
	
		18
		  Other payments:
		 not applicable in this table 
		

		

		

	
	
		18a
		Check Register
		 not applicable in this table 
		 200,000 
		 150,000 
		

	
	
		18b
		Preschool Expenses
		 not applicable in this table 
		 75,000 
		 59,000 
		

	
	
		18c
		

		 not applicable in this table 
		

		

		

	
	
		18d
		

		 not applicable in this table 
		

		

		

	
	
		19
		Less: Subtotal - Expenses
		 not applicable in this table 
		 1,115,000 
		 1,141,500 
		 2,256,500 
	
	
		20
		Estimated General Fund and Preschool Ending Cash Balance (Calculated as Line 1c plus line 13 minus line 19)
		

		

		

		 (517,925)
	
	
		Line Number
		Federal Awards - Cash Information for Fund 20
		Amount
		

		

		

	
	
		21
		Total Amount of 2021-22 Federal Awards granted to the district
		 400,000 
		

		

		

	
	
		22
		Amount of 2021-22 Federal Awards Expended at date of borrowing application
		 300,000 
		

		

		

	
	
		23
		Amount of 2021-22 Federal Cash Reimbursements Received at date of borrowing application
		 100,000 
		

		

		

	
	
		24
		2021-22 Federal Awards Receivable (Line 22 minus Line 23)
		 200,000 
		

		

		

	
	
		

		Please provide an explanation of any federal awards receivable, including an anticipated date that federal funds will be drawn down:
		

		

		

		

	
	
		

		

		

		

		

		

	
	
		end of worksheet

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet cash flow worksheet analysis this form is used by new jersey school districts to document shortage due the delayed june state aid payments contains five tables all content contained in columns a through f department of education borrowing on general fund blank cells are for data entry district name county line description beginning balance april anticipated monthly activity may estimated ending column intentionally left cashonhand book not applicable table b preschool c total hand and investments month end informational purposes only certificates deposits treasury bills other revenues be received tax levy payment schedule tuition revenue scheduleexcluding last unrestricted federal eximpact interest income miscellaneous local receipts d add subtotal expenses paiddue payroll records taxes expenditures ap amounts current period check register less calculated as plus minus number awards information amount granted expended at date application reimbursements receivable please provide a...

Related files

Share

Help

This form is used by New Jersey school districts to document cash flow shortage due to the delayed June 2022 state aid payments. This worksheet contains five tables. All content is contained in columns A through F.
New Jersey Department of Education
Borrowing on June 2022 Delayed State Aid Payments
Cash Flow Worksheet - General Fund
Blank cells in the columns of this worksheet are used for data entry
District Name:		County Name:
Line #	Line Description	Beginning Balance - April 30	Anticipated Monthly Cash Activity - May	Anticipated Monthly Cash Activity - June	Estimated Ending Cash Balance 6/30/22 (Blank cells in this column are intentionally left blank)
1a	4/30/22 General Fund Cash-On-Hand Book Balance	600,000	not applicable in this table	not applicable in this table
1b	4/30/22 Preschool Cash-On-Hand Book Balance	70,000	not applicable in this table	not applicable in this table
1c	Total Cash on Hand				670,000
General Fund and Preschool Investments - Month End Balance For Informational Purposes Only
Line #	Line Description	Beginning Balance - April 30	Anticipated Monthly Cash Activity - May	Anticipated Monthly Cash Activity - June
2	Certificates of Deposits	not applicable in this table	60,000	60,000
3	Treasury Bills	not applicable in this table	8,000	8,000
4	Other Investments:	not applicable in this table
4a		not applicable in this table
	General Fund and Preschool Revenues to be received:
Line #	Line Description	Beginning Balance - April 30	Anticipated Monthly Cash Activity - May	Anticipated Monthly Cash Activity - June
5	Tax Levy (Payment Schedule)	not applicable in this table	150,000	150,000
6	Tuition Revenue	not applicable in this table	7,000	10,000
7	State Aid (Payment Schedule-Excluding Last Payments)	not applicable in this table	600,000	-
8	Other State Revenues	not applicable in this table	50,000	50,000
9	Unrestricted Federal Revenues (ex.Impact Aid)	not applicable in this table	1,500	4,000
10	Interest Income	not applicable in this table	50	25
11	Other Miscellaneous Local Revenue	not applicable in this table	9,000	2,000
12	Other receipts:	not applicable in this table
12a	Preschool Revenues	not applicable in this table	25,000	10,000
12b		not applicable in this table
12c		not applicable in this table
12d		not applicable in this table
13	Add: Subtotal - revenues	not applicable in this table	842,550	226,025	1,068,575
	General Fund and Preschool Expenses Paid/Due:
Line #	Line Description	Beginning Balance - April 30	Anticipated Monthly Cash Activity - May	Anticipated Monthly Cash Activity - June
14	Payroll (Payroll Records)	not applicable in this table	650,000	725,000
15	Payroll Taxes	not applicable in this table	65,000	72,500
16	Tuition Expenditures	not applicable in this table	60,000	35,000
17	A/P - (Amounts Due In Current Period)	not applicable in this table	65,000	100,000
18	Other payments:	not applicable in this table
18a	Check Register	not applicable in this table	200,000	150,000
18b	Preschool Expenses	not applicable in this table	75,000	59,000
18c		not applicable in this table
18d		not applicable in this table
19	Less: Subtotal - Expenses	not applicable in this table	1,115,000	1,141,500	2,256,500
20	Estimated General Fund and Preschool Ending Cash Balance (Calculated as Line 1c plus line 13 minus line 19)				(517,925)
Line Number	Federal Awards - Cash Information for Fund 20	Amount
21	Total Amount of 2021-22 Federal Awards granted to the district	400,000
22	Amount of 2021-22 Federal Awards Expended at date of borrowing application	300,000
23	Amount of 2021-22 Federal Cash Reimbursements Received at date of borrowing application	100,000
24	2021-22 Federal Awards Receivable (Line 22 minus Line 23)	200,000
	Please provide an explanation of any federal awards receivable, including an anticipated date that federal funds will be drawn down:

end of worksheet

Related files

Share

Share to social media

Help

Login Area