| |
Actual |
YTD |
Projected |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
|
|
| RESOURCES |
2009 |
2010^ |
2010 |
2011 |
2012 |
2013 |
2014 |
2015 |
2016 |
2017 |
2018 |
2019 |
TOTAL |
|
| Infrastructure Sales Tax - CI Reserve |
$1,889,133 |
$1,145,231 |
$3,440,000 |
$3,518,800 |
$3,599,176 |
$3,681,160 |
$3,764,783 |
$3,850,078 |
$3,937,080 |
$4,025,822 |
$4,116,338 |
$1,461,944 |
$37,284,313 |
|
| Interest |
|
|
|
|
|
| Infrastructure Sales Tax - Equip
Reserve |
$500,000 |
$166,666 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$5,500,000 |
|
| Interest |
|
|
|
|
|
| Total Revenue |
$2,389,133 |
$1,311,897 |
$3,940,000 |
$4,018,800 |
$4,099,176 |
$4,181,160 |
$4,264,783 |
$4,350,078 |
$4,437,080 |
$4,525,822 |
$4,616,338 |
$1,961,944 |
$42,784,313 |
|
| |
|
|
|
|
|
| |
Actual |
YTD |
Projected |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Budget |
Needed From |
|
| SALE TAX
EXPENSES (total proj. cost) |
2009 |
2010^ |
2010* |
2011* |
2012* |
2013* |
2014* |
2015* |
2016* |
2017* |
2018* |
2019* |
TOTAL* |
other sources** |
|
| Residential
Street Maintenance - ($5,000,000) |
$280,888 |
|
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$500,000 |
$210,000 |
$4,990,888 |
$9,112 |
|
| Fire Apparatus |
|
|
|
|
| Ladder 2 - ($1,205,591) |
|
|
$500,000 |
|
$705,591 |
|
| Engine 6 - ($651,065) |
|
|
$500,000 |
|
$151,065 |
|
| Quint 6 - ($973,236) |
|
|
|
$500,000 |
|
$473,236 |
|
| Quint 3 - ($998,191) |
|
|
|
$250,000 |
|
$748,191 |
|
| Hazmat 5 - ($750,000) |
|
|
|
$250,000 |
|
|
|
$500,000 |
|
| Quint 7 - ($1,106,329) |
|
|
|
|
$500,000 |
|
$606,329 |
|
| Quint 5 - ($1,081,374) |
|
|
|
$500,000 |
|
|
|
$581,374 |
|
| Ladder 5 - ($1,688,298) |
|
|
|
$1,000,000 |
|
$688,298 |
|
| Tender 1 - ($600,000) |
|
|
|
$500,000 |
|
|
$100,000 |
|
| Quint 1 - ($1,247,739) |
|
|
|
|
$500,000 |
|
|
$747,739 |
|
| Total Fire Apparatus |
|
|
|
|
|
$5,000,000 |
$5,301,823 |
|
| Burroughs Creek -($350,000) |
$176,368 |
$173,632 |
$173,632 |
|
|
|
|
|
|
|
|
|
$350,000 |
$0 |
|
| Kasold - 23rd to 31st -
($6,500,000) |
|
|
|
|
|
|
$1,000,000 STP |
| Engineering |
$250,740 |
$195,948 |
$189,260 |
|
|
|
|
$50,000 Utilities |
| R/W |
|
|
$10,000 |
|
|
|
|
|
| Construction |
|
|
|
$5,000,000 |
|
|
|
$5,450,000 |
$1,050,000 |
|
| 5th and Maple Pump Station -
($5,000,000) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Engineering |
|
|
|
$400,000 |
|
|
|
| R/W |
|
|
$100,000 |
|
$100,000 |
|
|
|
| Construction |
|
|
|
|
|
$2,400,000 |
$2,000,000 |
|
|
|
|
|
$5,000,000 |
$0 |
|
| Iowa - Harvard to Irving Hill Road Overpass
-($6,050,000) |
|
|
|
|
|
$3,000,000 STP |
| Engineering |
|
|
$400,000 |
|
|
|
|
$800,000 Safety |
| R/W |
|
|
|
$150,000 |
|
|
|
$1,250,000 CIP |
| Construction |
|
|
|
|
$450,000 |
|
|
|
$1,000,000 |
$5,050,000 |
|
| BBP - Crestline to Kasold -
($3,483,000) |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Engineering |
|
|
|
|
$300,000 |
|
|
|
|
|
| R/W |
|
|
|
|
$23,000 |
|
|
|
|
|
| Construction |
|
|
|
|
|
$2,900,000 |
|
|
|
|
|
$3,223,000 |
$260,000 |
Utilities |
| Wakarusa - BBP to 18th - ($3,150,000) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Engineering |
|
|
|
|
|
|
|
|
| R/W |
|
|
|
|
$25,000 |
|
|
|
|
| Construction |
|
|
|
|
|
|
$2,700,000 |
|
|
|
|
$2,725,000 |
$425,000 |
Utilities |
| 19th - Iowa to Naismith -($3,885,500) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Engineering |
|
|
|
|
$350,000 |
|
|
|
| R/W |
|
|
|
|
$25,500 |
|
|
|
| Construction |
|
|
|
|
|
|
|
$2,200,000 |
$1,000,000 |
|
|
|
$3,575,500 |
$310,000 |
Utilities |
| Kasold - Harvard to BBP - ($4,922,000) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Engineering |
|
|
|
|
|
|
$420,000 |
|
|
|
| R/W |
|
|
|
|
|
|
$42,000 |
|
|
|
| Construction |
|
|
|
|
|
|
|
|
|
$3,000,000 |
$1,100,000 |
|
$4,562,000 |
$360,000 |
Utilities |
| Wakarusa - BBP to Legends - (4,663,000) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Engineering |
|
|
|
|
|
|
$300,000 |
|
|
|
| R/W |
|
|
|
|
|
|
$23,000 |
|
|
|
| Construction |
|
|
|
|
|
|
|
|
|
|
$2,000,000 |
$2,100,000 |
$4,423,000 |
$240,000 |
Utilities |
| BBP - Iowa to Crestline ($5,105,000) |
|
|
|
|
|
|
|
|
|
|
| Engineering |
|
|
|
|
|
|
$400,000 |
|
|
|
| R/W |
|
|
|
|
|
|
$10,000 |
|
|
|
| Construction - Phase I |
|
|
|
|
|
|
|
$2,000,000 |
$2,410,000 |
$2,695,000 |
|
| Total
Expenses from Infrastructure Sales Tax |
$707,996 |
$369,580 |
$2,372,892 |
$6,150,000 |
$2,273,000 |
$6,300,000 |
$3,400,500 |
$5,400,000 |
$2,962,000 |
$4,323,000 |
$4,510,000 |
$4,310,000 |
$42,709,388 |
$21,002,758 |
|
| Revenues over Expenses |
$1,681,137 |
$942,317 |
$1,567,108 |
-$2,131,200 |
$1,826,176 |
-$2,118,840 |
$864,283 |
-$1,049,922 |
$1,475,080 |
$202,822 |
$106,338 |
-$2,348,057 |
$74,924 |
|
|
| |
|
|
|
|
|
|
|
| Fund Balance Forward Jan 1 |
$0 |
|
$1,681,137 |
$3,248,245 |
$1,117,045 |
$2,943,221 |
$824,381 |
$1,688,663 |
$638,742 |
$2,113,822 |
$2,316,643 |
$2,422,981 |
|
|
| |
|
|
|
|
|
|
|
| Ending Balance Dec 31 |
$1,681,137 |
|
$3,248,245 |
$1,117,045 |
$2,943,221 |
$824,381 |
$1,688,663 |
$638,742 |
$2,113,822 |
$2,316,643 |
$2,422,981 |
$74,924 |
$74,924 |
|
| *
expenses do not reflect total project cost. Instead, only the project expenses to be
funded with proceeds from the Infrastructure Sales Tax are shown here. |
|
|
|
| **
Other sources include state and/or federal aid, as well as cash from
other funds or other reserve funds, debt financing, etc. |
|
|
|
| ^
Year to date as of May 21, 2010 |
|
|
|
|
|
| Assumptions: |
|
|
| .50 sales tax |
|
|
|
| .30 for infrastructure and
equipment |
|
|
| 10 year sunset |
|
|
| November
election; April effective date; June 30 initial collections (7months of
collections); March 31, 2019 sunset - 2019 receipts for 5 months |
|
|
| sales
tax - 2010 revised 4/15/2010; 2% annual growth beginning in 2011 |
|
|
| Base year 1-cent sales tax
generates |
$12,891,000 |
|
|
| |
|
|
|
| |
|
|
| |
|
|
|
|
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|