Budgeting Operational Expenditures
vgirldesir
budget_worksheet_and_template.docxEDD/731 v8
Budget Worksheet and Template
EDD/731 v8
Page 3 of 3
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 (__) x ($_______ / student) = State foundation funding = _____________
|
Local Taxes |
Amount |
|
Quantity of maintenance and operation mills |
|
|
Quantity of debt service mills |
|
|
Quantity of capital outlay mills |
|
|
Total millage |
|
|
Assessed valuation |
|
|
Bonded debt |
|
Fund 1: Salary
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
0.00 |
0.00 |
|
Total revenue |
0.00 |
0.00 |
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance |
|
|
|
Full-time equivalents |
1,815 |
|
|
Average teacher salary |
45,897 |
|
Fund 2: Operating
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
|
|
|
Total revenue |
|
|
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance |
|
|
Fund 3: Building and Construction
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
|
|
|
Total revenue |
|
|
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance—building and construction is part of capital outlay |
|
|
Fund 4: Debt Service
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
|
|
|
Total revenue |
|
|
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance |
|
|
Fund 5: Capital Outlay
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
|
|
|
Total revenue |
|
|
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance |
|
|
Fund 6: Federal Grants
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
|
|
|
Total revenue |
|
|
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance |
|
|
Fund 7: Activity
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
|
|
|
Total revenue |
|
|
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance |
|
|
Fund 8: Food Service
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
|
|
|
Total revenue |
|
|
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance |
|
|
Fund 9: Fixed Assets
|
Category |
PY Actual |
CY Budget |
|
Beginning balance |
|
|
|
Total revenue |
|
|
|
Total expenditure |
|
|
|
Total transfers |
|
|
|
Ending balance |
|
|
Copyright 2020 by University of Phoenix. All rights reserved.
Copyright 2020 by University of Phoenix. All rights reserved.
