| Springboro Community Five Year Forecast for Fiscal Year 2018 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| District Type: City | |||||||||
| IRN: 050427 | |||||||||
| County: Warren | |||||||||
| Date Submitted: 10/17/2017 Date Processed: 10/18/2017 | |||||||||
| Actual | Forecasted | ||||||||
| Line | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | |
| 1.010 General Property (Real Estate) | 23,273,806 | 24,311,920 | 25,387,526 | 25,333,881 | 22,519,005 | 19,785,585 | 20,204,993 | 21,309,126 | |
| 1.020 Tangible Personal Property Tax | 3,750,738 | 3,698,924 | 4,243,735 | 5,048,256 | 4,703,217 | 4,381,378 | 4,447,099 | 4,513,805 | |
| 1.035 Unrestricted Grants-in-Aid | 13,400,138 | 14,829,983 | 15,833,702 | 16,241,864 | 16,703,111 | 16,705,038 | 16,716,914 | 16,715,188 | |
| 1.040 Restricted Grants-in-Aid | 327,820 | 5,644 | 8,297 | 8,601 | 8,889 | 9,054 | 9,100 | 9,094 | |
| 1.050 Property Tax Allocation | 3,472,907 | 3,568,448 | 3,619,250 | 3,668,994 | 3,244,619 | 2,845,235 | 2,905,979 | 3,073,759 | |
| 1.060 All Other Operating Revenue | 1,084,814 | 1,189,726 | 1,084,022 | 1,447,354 | 1,469,641 | 1,492,374 | 1,515,562 | 1,539,213 | |
| 1.070 Total Revenue | 45,310,223 | 47,604,645 | 50,176,532 | 51,748,950 | 48,648,481 | 45,218,664 | 45,799,647 | 47,160,185 | |
| 2.060 All Other Financial Sources | 110,544 | 59,702 | 50,478 | 153,398 | 10,000 | 10,000 | 10,000 | 10,000 | |
| 2.070 Total Other Financing Sources | 110,544 | 59,702 | 50,478 | 153,398 | 10,000 | 10,000 | 10,000 | 10,000 | |
| 2.080 Total Revenues and Other Financing Sources | 45,420,767 | 47,664,347 | 50,227,010 | 51,902,348 | 48,658,481 | 45,228,664 | 45,809,647 | 47,170,185 | |
| 3.010 Personnel Services | 25,433,907 | 25,994,569 | 27,425,509 | 29,033,242 | 29,959,080 | 31,087,354 | 32,258,119 | 33,472,976 | |
| 3.020 Employees' Retirement/Insurance Benefits | 9,413,623 | 9,567,447 | 9,389,402 | 9,694,407 | 10,122,428 | 10,685,361 | 11,285,580 | 11,925,777 | |
| 3.030 Purchased Services | 7,296,366 | 6,908,036 | 8,041,312 | 8,545,769 | 8,947,818 | 9,250,850 | 9,564,330 | 9,888,644 | |
| 3.040 Supplies and Materials | 2,370,193 | 2,087,422 | 1,973,745 | 2,313,637 | 2,156,828 | 2,795,165 | 2,534,270 | 2,529,156 | |
| 3.050 Capital Outlay | 1,701,648 | 859,285 | 1,064,672 | 1,029,000 | 1,134,140 | 930,423 | 947,031 | 963,972 | |
| 4.010 Debt Service: All Principal (Historical) | 430,000 | 625,000 | 639,000 | ||||||
| 4.055 Debt Service: Principal - Other | 530,000 | 326,000 | 337,000 | 342,000 | 291,000 | ||||
| 4.060 Debt Service: Interest and Fiscal Charges | 211,470 | 296,225 | 274,124 | 246,802 | 241,701 | 224,000 | 211,758 | 198,689 | |
| 4.300 Other Objects | 601,744 | 605,890 | 612,947 | 619,076 | 625,267 | 631,520 | 637,835 | 644,213 | |
| 4.500 Total Expenditures | 47,458,951 | 46,943,874 | 49,420,711 | 52,011,933 | 53,513,262 | 55,941,673 | 57,780,923 | 59,914,428 | |
| 5.010 Operational Transfers - Out | 376,242 | 939,213 | 371,840 | ||||||
| 5.020 Advances - Out | 3,720 | ||||||||
| 5.040 Total Other Financing Uses | 376,242 | 942,933 | 371,840 | ||||||
| 5.050 Total Expenditure and Other Financing Uses | 47,835,193 | 47,886,807 | 49,792,551 | 52,011,933 | 53,513,262 | 55,941,673 | 57,780,923 | 59,914,428 | |
| 6.010 Excess Rev & Oth Financing Sources over(under) Exp & Oth Financing | (2,414,426) | (222,460) | 434,459 | (109,585) | (4,854,781) | (10,713,009) | (11,971,276) | (12,744,243) | |
| 7.010 Beginning Cash Balance | 10,782,864 | 8,368,438 | 8,145,978 | 8,580,437 | 8,470,852 | 3,616,071 | (7,096,938) | (19,068,214) | |
| 7.020 Ending Cash Balance | 8,368,438 | 8,145,978 | 8,580,437 | 8,470,852 | 3,616,071 | (7,096,938) | (19,068,214) | (31,812,457) | |
| 10.010 Fund Balance June 30 for Certification of Appropriations | 8,368,438 | 8,145,978 | 8,580,437 | 8,470,852 | 3,616,071 | (7,096,938) | (19,068,214) | (31,812,457) | |
| 11.020 Property Tax - Renewal or Replacement | 4,205,839 | 8,411,655 | 8,411,604 | 8,411,169 | |||||
| 11.300 Cumulative Balance of Replacement/Renewal Levies | 4,205,839 | 12,617,494 | 21,029,098 | 29,440,267 | |||||
| 12.010 Fund Bal June 30 for Cert of Contracts,Salary Sched,Oth Obligations | 8,368,438 | 8,145,978 | 8,580,437 | 8,470,852 | 7,821,910 | 5,520,556 | 1,960,884 | (2,372,190) | |
| 13.020 Property Tax - New | 84,012 | 253,959 | 427,647 | ||||||
| 13.030 Cumulative Balance of New Levies | 84,012 | 337,971 | 765,618 | ||||||
| 15.010 Unreserved Fund Balance June 30 | 8,368,438 | 8,145,978 | 8,580,437 | 8,470,852 | 7,821,910 | 5,604,568 | 2,298,855 | (1,606,572) | |
| Notes to the Five Year Forecast | |||||||||
| Please visit the Ohio Department of Education website at | |||||||||
| ftp://ftp.ode.state.oh.us/geodoc/5-yrForecast/ | |||||||||