Indian Hill Exempted Village Schools
Schedule Of Revenue, Expenditures and Changes In Fund Balances Actual and Forecasted Operating Fund
	
	ACTUAL
	FORECASTED
	
	Fiscal Year          Fiscal Year          Fiscal Year 2014                      2015                      2016
	Fiscal Year          Fiscal Year          Fiscal Year          Fiscal Year          Fiscal Year 2017                      2018                      2019                      2020                      2021
	
Revenue:
1.010 ‐ General Property Tax (Real Estate) 1.020 ‐ Public Utility Personal Property 1.030 ‐ Income Tax
1.035 ‐ Unrestricted Grants‐in‐Aid 1.040 ‐ Restricted Grants‐in‐Aid
1.045 ‐ Restricted Federal Grants‐in‐Aid ‐ SFSF 1.050 ‐ Property Tax Allocation
1.060 ‐ All Other Operating Revenues
	
23,004,627           22,987,562          23,796,994 510,905                 503,322                532,842
‐	‐	‐ 1,201,234             1,283,508             1,350,118
‐                     356,367                 171,449 ‐                               ‐                                   ‐
2,895,479             2,913,942             2,964,142 3,968,113             4,094,058             4,364,876
	
23,706,171          24,213,365          24,489,178          24,576,522          24,664,298 449,652                479,189                487,563                494,876                502,299
‐	‐	‐	‐	‐ 1,436,602             1,488,504             1,439,677             1,440,998             1,442,219
171,447	171,682	171,694	171,700	171,706 ‐                               ‐                               ‐                               ‐                               ‐
3,009,086             3,061,923             3,099,809             3,110,652             3,121,548 4,472,713             4,526,967             4,577,089             4,627,867             4,679,313
	
1.070 ‐ Total Revenue
	31,580,358	32,138,759	33,180,421
	33,245,672	33,941,630	34,265,009	34,422,615	34,581,383

Other Financing Sources:
2.010 ‐ Proceeds from Sale of Notes
2.020 ‐ State Emergency Loans and Advancements 2.040 ‐ Operating Transfers‐In
2.050 ‐ Advances‐In
2.060 ‐ All Other Financing Sources 2.070 ‐ Total Other Financing Sources
	
‐	‐	‐ ‐	‐	‐ ‐	‐	‐ ‐	‐	‐
63,158	1,959	37,527
	
‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐
15,000	15,000	15,000	15,000	15,000
	
	63,158	1,959	37,527
	15,000	15,000	15,000	15,000	15,000
	
2.080 ‐ Total Revenues and Other Financing Sources
	31,643,516	32,140,718	33,217,948
	33,260,672	33,956,630	34,280,009	34,437,615	34,596,383

Expenditures:
3.010 ‐ Personnel Services
3.020 ‐ Employees' Retirement/Insurance Benefits 3.030 ‐ Purchased Services
3.040 ‐ Supplies and Materials 3.050 ‐ Capital Outlay
3.060 ‐ Intergovernmental

Debt Service:
4.010 ‐ Principal‐All Years 4.020 ‐ Principal ‐ Notes 4.030 ‐ Principal ‐ State Loans
4.040 ‐ Principal ‐ State Advances 4.050 ‐ Principal ‐ HB264 Loan 4.055 ‐ Principal ‐ Other
4.060 ‐ Interest and Fiscal Charges 4.300 ‐ Other Objects
	
17,474,811          19,975,072           19,296,004 6,165,531             6,606,266             7,108,026 4,491,873             4,259,274             3,954,882 1,113,840             1,131,576             1,336,682 195,205             5,148,826             1,476,727
‐	‐	‐

‐	‐	‐

‐	‐	‐ 487,970                461,333                 457,226
	
19,944,604	20,383,385	20,994,887	21,309,810	21,629,457 6,962,141             7,029,685             7,214,682             7,402,214             7,677,198 4,366,930             4,153,670             4,211,823             4,270,198             4,329,603 1,032,982             1,144,032             1,135,162             1,159,033             1,172,666 1,358,696             4,000,000             2,500,000             1,500,000             1,500,000
‐	‐	‐	‐	‐

‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐
515,318	515,318	524,418	529,418	531,568
	
4.500 ‐ Total Expenditures
	29,929,230	37,582,347	33,629,547
	34,180,672	37,226,090	36,580,973	36,170,674	36,840,493

Other Financing Uses
5.010 ‐ Operating Transfers‐Out 5.020 ‐ Advances‐Out
5.030 ‐ All Other Financing Uses 5.040 ‐ Total Other Financing Uses
	
‐	‐	‐ ‐	‐	‐ ‐	‐                  5,500,000
	
‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐
	
	‐	‐	5,500,000
	‐	‐	‐	‐	‐
	
5.050 ‐ Total Expenditures and Other Financing Uses
	29,929,230	37,582,347	39,129,547
	34,180,672	37,226,090	36,580,973	36,170,674	36,840,493

Excess of Rev & Other Financing Uses Over (Under) 6.010 ‐ Expenditures and Other Financing Uses
			
	1,714,286	(5,441,629)	(5,911,599)
	(920,000)	(3,269,460)	(2,300,963)	(1,733,059)	(2,244,110)

Cash Balance July 1 ‐ Excluding Proposed Renewal/ 7.010 ‐ Replacement and New Levies
	
30,686,475	32,400,761	26,959,132
	
21,047,533	20,127,533	16,858,072	14,557,109	12,824,051
	
7.020 ‐ Cash Balance June 30
	32,400,761	26,959,132	21,047,533
	20,127,533	16,858,072	14,557,109	12,824,051	10,579,941

8.010 ‐ Estimated Encumbrances June 30

Reservations of Fund Balance:
9.010 ‐ Textbooks and Instructional Materials 9.020 ‐ Capital Improvements
9.030 ‐ Budget Reserve 9.040 ‐ DPIA
9.050 ‐ Debt Service
9.060 ‐ Property Tax Advances 9.070 ‐ Bus Purchases
9.080 ‐ Subtotal
	
4,706,362	1,036,395	‐

‐	‐	‐ ‐	‐	‐ ‐	‐	‐ ‐	‐	‐ ‐	‐	‐ ‐	‐	‐ ‐	‐	‐
	
‐	‐	‐	‐	‐

‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐
	
	‐	‐	‐
	‐	‐	‐	‐	‐
	
Fund Balance June 30 for Certification 10.010 ‐ of Appropriations
			
	27,694,399	25,922,737	21,047,533
	20,127,533	16,858,072	14,557,109	12,824,051	10,579,941

Rev from Replacement/Renewal Levies 11.010 ‐ Income Tax ‐ Renewal
11.020 ‐ Property Tax ‐ Renewal or Replacement
11.030 ‐ Cumulative Balance of Replacement/Renewal Levies

‐	‐	‐
	
‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐
	
Fund Balance June 30 for Certification 12.010 ‐ of Contracts, Salary and Other Obligations
			
	27,694,399	25,922,737	21,047,533
	20,127,533	16,858,072	14,557,109	12,824,051	10,579,941

Revenue from New Levies 13.010 ‐ Income Tax ‐ New 13.020 ‐ Property Tax ‐ New
13.030 ‐ Cumulative Balance of New Levies

14.010 ‐ Revenue from Future State Advancements

‐	‐	‐

‐	‐	‐
	
‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐ ‐	‐	‐	‐	‐

‐	‐	‐	‐	‐
	
15.010 ‐ Unreserved Fund Balance June 30
	27,694,399	25,922,737	21,047,533
	20,127,533	16,858,072	14,557,109	12,824,051	10,579,941

ADM Forecasts
20.010 ‐ Kindergarten 20.015 ‐ Grades 1‐12
		
132                         130                         130                         130                         130 1,860                     1,879                     1,915                     1,935                     1,953