Update Budget

vgirldesir

budget_worksheet_and_templatefinal.docx

Home >Education homework help >Update Budget

EDD/731 v8

Budget Worksheet and Template

EDD/731 v8

Page 3 of 3

$C:\Users\djshirey\OneDrive - University of Phoenix\F_Drive\Style Guides\UPX Logos\Horizontal format\UOPX_Sig_Hor_Black_Medium.png$

Budget Worksheet and Template

Use this sheet to calculate prior year (PY) and current year (CY) revenue, expenditures, fund balances, operational balances, and budget balance. You may move or add items as necessary.

No. of students (_20_) x ($_45000______ / student) = State foundation funding = _$ 900000_______

Local Taxes	Amount
Quantity of maintenance and operation mills	$ 20,778.74
Quantity of debt service mills	$ 18,344.71
Quantity of capital outlay mills	$ 48,364.81
Total millage	$ 87,488.27
Assessed valuation	$ 4,374.41
Bonded debt	$ 874.88

Fund 1: Salary

Category	PY Actual	CY Budget
Beginning balance	$ -	$ -
Total revenue	$ -	$ -
Total expenditure	$ 36,682.57	$ 10,465.40
Total transfers	$ 45,729.69	$ 20,203.05
Ending balance	$ 26.42	$ 33,856.61
Full-time equivalents	$ 1,815.00	$ 1,815.00
Average teacher salary	$ 45,897.00	$ 45,897.00

Fund 2: Operating

Category	PY Actual	CY Budget
Beginning balance	$ 20,778.74	$ 37,001.63
Total revenue	$ 18,344.71	$ 10,361.74
Total expenditure	$ 43,691.04	$ 36,409.40
Total transfers	$ 1,675.48	$ 14,741.61
Ending balance	$ 20,778.74	$ 37,001.63

Fund 3: Building and Construction

Category	PY Actual	CY Budget
Beginning balance	$ 15,798.48	$ 52,327.39
Total revenue	$ 56,530.37	$ 32,367.10
Total expenditure	$ 18,393.87	$ 48,364.81
Total transfers	$ 14,450.37	$ 66,172.57
Ending balance—building and construction is part of capital outlay	$ 24,704.53	$ 63,831.32

Fund 4: Debt Service

Category	PY Actual	CY Budget
Beginning balance	$ 6,727.40	$ 6,338.98
Total revenue	$ 7,725.85	$ 2,698.38
Total expenditure	$ 8,072.47	$ 8,902.07
Total transfers	$ 5,094.65	$ 3,179.96
Ending balance	$ 1,264.44	$ 7,767.23

Fund 5: Capital Outlay

Category	PY Actual	CY Budget
Beginning balance	$ 38,566.77	$ 14,388.16
Total revenue	$ 68,906.19	$ 72,184.90
Total expenditure	$ 11,742.63	$ 84,269.62
Total transfers	$ 70,837.26	$ 35,172.75
Ending balance	$ 3,529.52	$ 3,192.50

Fund 6: Federal Grants

Category	PY Actual	CY Budget
Beginning balance	$ 3,683.89	$ 1,008.64
Total revenue	$ 2,183.23	$ 4,100.90
Total expenditure	$ 6,744.33	$ 8,934.86
Total transfers	$ 132.39	$ 8,834.16
Ending balance	$ 5,241.74	$ 6,929.77

Fund 7: Activity

Category	PY Actual	CY Budget
Beginning balance	$ 748.12	$ 4,552.27
Total revenue	$ 3,823.13	$ 1,330.13
Total expenditure	$ 2,651.41	$ 1,196.18
Total transfers	$ 3,951.42	$ 2,917.25
Ending balance	$ 4,527.15	$ 2,584.81

Fund 8: Food Service

Category	PY Actual	CY Budget
Beginning balance	$ 161.72	$ 151.77
Total revenue	$ 345.33	$ 793.15
Total expenditure	$ 626.58	$ 968.87
Total transfers	$ 714.94	$ 500.02
Ending balance	$ 63.07	$ 242.82

Fund 9: Fixed Assets

Category	PY Actual	CY Budget
Beginning balance	$295,159.70	$499,715.25
Total revenue	$203,680.95	$197,467.44
Total expenditure	$338,885.52	$402,676.46
Total transfers	$135,092.53	$239,172.85
Ending balance	$120,076.41	$342,940.95