| Springboro Community Five Year Forecast for Fiscal Year 2017 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| District Type: City | |||||||||
| IRN: 050427 | |||||||||
| County: Warren | |||||||||
| Date Submitted: 5/25/2017 Date Processed: 5/27/2017 | |||||||||
| Actual | Forecasted | ||||||||
| Line | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | |
| 1.010 General Property (Real Estate) | 23,536,769 | 23,273,806 | 24,311,920 | 25,345,116 | 25,003,832 | 22,411,331 | 19,639,563 | 20,081,768 | |
| 1.020 Tangible Personal Property Tax | 3,898,506 | 3,750,738 | 3,698,924 | 4,243,735 | 5,029,877 | 4,704,471 | 4,381,378 | 4,447,099 | |
| 1.035 Unrestricted Grants-in-Aid | 11,871,107 | 13,400,138 | 14,829,983 | 15,817,172 | 16,624,769 | 17,483,703 | 17,459,555 | 17,458,357 | |
| 1.040 Restricted Grants-in-Aid | 4,089 | 327,820 | 5,644 | 7,134 | 9,075 | 9,089 | 9,106 | 9,119 | |
| 1.050 Property Tax Allocation | 3,492,181 | 3,472,907 | 3,568,448 | 3,613,411 | 3,661,489 | 3,246,544 | 2,836,518 | 2,901,567 | |
| 1.060 All Other Operating Revenue | 797,593 | 1,084,814 | 1,189,726 | 1,116,002 | 1,138,322 | 1,161,088 | 1,184,310 | 1,207,996 | |
| 1.070 Total Revenue | 43,600,245 | 45,310,223 | 47,604,645 | 50,142,569 | 51,467,364 | 49,016,226 | 45,510,429 | 46,105,906 | |
| 2.050 Advances-In | 124,388 | ||||||||
| 2.060 All Other Financial Sources | 601,056 | 110,544 | 59,702 | 50,133 | 10,000 | 10,000 | 10,000 | 10,000 | |
| 2.070 Total Other Financing Sources | 725,444 | 110,544 | 59,702 | 50,133 | 10,000 | 10,000 | 10,000 | 10,000 | |
| 2.080 Total Revenues and Other Financing Sources | 44,325,689 | 45,420,767 | 47,664,347 | 50,192,702 | 51,477,364 | 49,026,226 | 45,520,429 | 46,115,906 | |
| 3.010 Personnel Services | 24,213,881 | 25,433,907 | 25,994,569 | 27,532,816 | 28,584,355 | 29,589,958 | 30,692,646 | 31,853,089 | |
| 3.020 Employees' Retirement/Insurance Benefits | 9,202,023 | 9,413,623 | 9,567,447 | 9,388,992 | 9,737,622 | 10,229,051 | 10,853,988 | 11,523,979 | |
| 3.030 Purchased Services | 6,250,074 | 7,296,366 | 6,908,036 | 8,032,593 | 8,215,716 | 8,800,356 | 9,406,796 | 10,035,895 | |
| 3.040 Supplies and Materials | 1,659,797 | 2,370,193 | 2,087,422 | 2,011,498 | 2,485,348 | 2,155,875 | 2,794,213 | 2,533,317 | |
| 3.050 Capital Outlay | 1,766,453 | 1,701,648 | 859,285 | 975,719 | 1,169,719 | 1,274,859 | 1,071,142 | 1,087,750 | |
| 4.010 Debt Service: All Principal (Historical) | 371,000 | 430,000 | 625,000 | ||||||
| 4.055 Debt Service: Principal - Other | 639,000 | 530,000 | 326,000 | 337,000 | 342,000 | ||||
| 4.060 Debt Service: Interest and Fiscal Charges | 164,337 | 211,470 | 296,225 | 265,571 | 246,802 | 241,701 | 224,000 | 211,758 | |
| 4.300 Other Objects | 618,935 | 601,744 | 605,890 | 611,910 | 617,990 | 624,131 | 630,333 | 636,598 | |
| 4.500 Total Expenditures | 44,246,500 | 47,458,951 | 46,943,874 | 49,458,099 | 51,587,552 | 53,241,931 | 56,010,117 | 58,224,386 | |
| 5.010 Operational Transfers - Out | 366,910 | 376,242 | 939,213 | 366,840 | 365,000 | 365,000 | 365,000 | 365,000 | |
| 5.020 Advances - Out | 3,720 | ||||||||
| 5.040 Total Other Financing Uses | 366,910 | 376,242 | 942,933 | 366,840 | 365,000 | 365,000 | 365,000 | 365,000 | |
| 5.050 Total Expenditure and Other Financing Uses | 44,613,410 | 47,835,193 | 47,886,807 | 49,824,939 | 51,952,552 | 53,606,931 | 56,375,117 | 58,589,386 | |
| 6.010 Excess Rev & Oth Financing Sources over(under) Exp & Oth Financing | (287,721) | (2,414,426) | (222,460) | 367,763 | (475,188) | (4,580,705) | (10,854,688) | (12,473,480) | |
| 7.010 Beginning Cash Balance | 11,070,585 | 10,782,864 | 8,368,438 | 8,145,978 | 8,513,741 | 8,038,553 | 3,457,848 | (7,396,840) | |
| 7.020 Ending Cash Balance | 10,782,864 | 8,368,438 | 8,145,978 | 8,513,741 | 8,038,553 | 3,457,848 | (7,396,840) | (19,870,320) | |
| 10.010 Fund Balance June 30 for Certification of Appropriations | 10,782,864 | 8,368,438 | 8,145,978 | 8,513,741 | 8,038,553 | 3,457,848 | (7,396,840) | (19,870,320) | |
| 11.020 Property Tax - Renewal or Replacement | 4,196,574 | 8,393,103 | 8,393,006 | ||||||
| 11.300 Cumulative Balance of Replacement/Renewal Levies | 4,196,574 | 12,589,677 | 20,982,683 | ||||||
| 12.010 Fund Bal June 30 for Cert of Contracts,Salary Sched,Oth Obligations | 10,782,864 | 8,368,438 | 8,145,978 | 8,513,741 | 8,038,553 | 7,654,422 | 5,192,837 | 1,112,363 | |
| 15.010 Unreserved Fund Balance June 30 | 10,782,864 | 8,368,438 | 8,145,978 | 8,513,741 | 8,038,553 | 7,654,422 | 5,192,837 | 1,112,363 | |
| Notes to the Five Year Forecast | |||||||||
| Please visit the Ohio Department of Education web site at | |||||||||
| ftp://ftp.ode.state.oh.geodoc/5-yrForecast/ | |||||||||