| Springboro Community Five Year Forecast
for Fiscal Year 2008 |
|
|
| District
Type: City |
|
| IRN:
050427 |
|
| County: Warren |
|
| Date
Submitted: 10/31/2007 Date Processed: 11/3/2007 |
|
|
|
|
Actual |
Forecasted |
|
| Line |
2005 |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
|
| 1.010 General
Property (Real Estate) |
14,021,586 |
16,457,604 |
21,692,832 |
23,560,716 |
20,535,235 |
18,140,649 |
19,558,538 |
20,654,441 |
|
| 1.020 Tangible
Personal Property Tax |
879,529 |
2,863,393 |
1,051,216 |
935,088 |
592,518 |
351,731 |
437,542 |
362,465 |
|
| 1.035 Unrestricted
Grants-in-Aid |
11,036,147 |
11,067,302 |
11,159,872 |
11,285,373 |
11,286,615 |
11,287,876 |
11,591,783 |
11,593,125 |
|
| 1.040 Restricted
Grants-in-Aid |
36,202 |
183,151 |
48,036 |
47,799 |
47,636 |
47,472 |
47,516 |
47,305 |
|
| 1.050 Property Tax
Allocation |
1,903,882 |
2,650,672 |
3,451,207 |
3,881,013 |
3,668,463 |
3,559,587 |
3,647,804 |
3,556,578 |
|
| 1.060 All Other
Operating Revenue |
1,926,119 |
2,459,850 |
1,062,687 |
773,314 |
781,047 |
788,857 |
796,746 |
804,714 |
|
| 1.070
Total Revenue |
29,803,465 |
35,681,972 |
38,465,850 |
40,483,304 |
36,911,515 |
34,176,172 |
36,079,929 |
37,018,628 |
|
| 2.010 Proceeds from
Sale of Notes |
2,734,670 |
|
| 2.040 Operating
Transfers-In |
500,000 |
96 |
2,840 |
|
| 2.050
Advances-In |
16,113 |
12,097 |
|
10,000 |
20,000 |
20,000 |
20,000 |
20,000 |
|
| 2.060 All Other
Financial Sources |
6,944 |
56,922 |
25,469 |
5,000 |
5,000 |
5,000 |
5,000 |
5,000 |
|
| 2.070 Total Other
Financing Sources |
523,057 |
2,803,785 |
28,309 |
15,000 |
25,000 |
25,000 |
25,000 |
25,000 |
|
| 2.080
Total Revenues and Other Financing Sources |
30,326,522 |
38,485,757 |
38,494,159 |
40,498,304 |
36,936,515 |
34,201,172 |
36,104,929 |
37,043,628 |
|
| 3.010 Personnel Services |
18,545,276 |
19,216,499 |
22,433,839 |
25,277,965 |
26,888,668 |
28,635,880 |
30,496,084 |
32,654,648 |
|
| 3.020
Employees' Retirement/Insurance Benefits |
5,812,143 |
5,940,149 |
7,324,004 |
8,035,390 |
8,573,102 |
9,152,160 |
9,770,299 |
10,457,939 |
|
| 3.030 Purchased Services |
3,171,037 |
3,507,360 |
5,088,329 |
5,602,782 |
5,774,646 |
5,950,738 |
6,132,181 |
6,319,134 |
|
| 3.040 Supplies and
Materials |
926,203 |
863,966 |
1,820,833 |
1,966,500 |
2,025,495 |
2,086,259 |
2,148,847 |
2,213,313 |
|
| 3.050 Capital Outlay |
157,683 |
93,097 |
946,578 |
435,426 |
444,134 |
453,017 |
462,077 |
471,319 |
|
| 4.010
Debt Service: All Principal (Historical) |
164,674 |
1,705,000 |
194,000 |
|
| 4.050 Debt
Service: Principal - HB 264 Loans |
|
165,648 |
165,648 |
165,648 |
165,648 |
165,648 |
|
| 4.055 Debt
Service: Principal - Other |
|
157,685 |
157,685 |
157,685 |
157,685 |
157,685 |
|
| 4.060
Debt Service: Interest and Fiscal Charges |
194,909 |
191,541 |
203,454 |
98,991 |
245,158 |
241,139 |
239,000 |
239,000 |
|
| 4.300
Other Objects |
619,187 |
469,200 |
608,323 |
496,701 |
522,036 |
548,138 |
575,545 |
575,545 |
|
| 4.500 Total Expenditures |
29,591,112 |
31,986,812 |
38,619,360 |
42,237,087 |
44,796,572 |
47,390,664 |
50,147,367 |
53,254,231 |
|
| 5.010 Operational
Transfers - Out |
500,000 |
859,136 |
|
| 5.020 Advances - Out |
12,097 |
2,232 |
119,532 |
20,000 |
20,000 |
20,000 |
20,000 |
20,000 |
|
| 5.030 All Other
Financing Uses |
134 |
1,796 |
1,784,498 |
17,500 |
15,000 |
15,000 |
15,000 |
15,000 |
|
| 5.040 Total Other
Financing Uses |
512,231 |
863,164 |
1,904,030 |
37,500 |
35,000 |
35,000 |
35,000 |
35,000 |
|
| 5.050
Total Expenditure and Other Financing Uses |
30,103,343 |
32,849,976 |
40,523,390 |
42,274,587 |
44,831,572 |
47,425,664 |
50,182,367 |
53,289,231 |
|
| 6.010
Excess Rev & Oth Financing Sources over(under)
Exp & Oth Financing |
223,179 |
5,635,781 |
-2,029,231 |
-1,776,284 |
-7,895,057 |
-13,224,492 |
-14,077,437 |
-16,245,603 |
|
| 7.010 Beginning Cash
Balance |
766,525 |
989,704 |
6,625,485 |
4,596,254 |
2,819,971 |
-5,075,087 |
-18,299,579 |
-32,377,016 |
|
| 7.020 Ending Cash Balance |
989,704 |
6,625,485 |
4,596,254 |
2,819,971 |
-5,075,087 |
-18,299,579 |
-32,377,016 |
-48,622,619 |
|
| 9.030 Budget Reserve |
|
1,306,070 |
838,885 |
1,015,209 |
500,000 |
500,000 |
750,000 |
1,000,000 |
|
| 9.080 Total Reservations |
|
1,306,070 |
838,885 |
1,015,209 |
500,000 |
500,000 |
750,000 |
1,000,000 |
|
| 10.010
Fund Balance June 30 for Certification of
Appropriations |
989,704 |
5,319,415 |
3,757,369 |
1,804,762 |
-5,575,087 |
-18,799,579 |
-33,127,016 |
-49,622,619 |
|
| 11.020
Property Tax - Renewal or Replacement |
|
4,773,188 |
9,270,300 |
9,270,300 |
9,270,300 |
|
| 11.300
Cumulative Balance of Replacement/Renewal Levies |
|
4,773,188 |
14,043,488 |
23,313,788 |
32,584,088 |
|
| 12.010
Fund Bal June 30 for Cert of Contracts,Salary
Sched,Oth Obligations |
989,704 |
5,319,415 |
3,757,369 |
1,804,762 |
-801,899 |
-4,756,091 |
-9,813,228 |
-17,038,531 |
|
| 15.010
Unreserved Fund Balance June 30 |
989,704 |
5,319,415 |
3,757,369 |
1,804,762 |
-801,899 |
-4,756,091 |
-9,813,228 |
-17,038,531 |
|
|
|
|
|
| Notes
to the Five Year Forecast |
|
|
|
|
|
| Springboro Community
City Schools |
|
| Warren
County |
|
|
|
|
| Notes
and Assumptions Related to 5-year Financial Forecast for FY08. |
|
|
|
|
| Please
visit the Ohio Department of Education website at: |
|
|
|
|
| http://www.ode.state.oh.us/GD/Templates/Pages/ODE/ODEPrimary.aspx?page=2&TopicRe |
|
| lationID=1011 |
|
|
|
|
| to see
the complete forecast assumptions file. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|