|
TSMF Model V.2.0.xls
<br /> FYQ7 FY08 am Fin FY11 FY7
<br /> Total Target Expenditures for All Funds 4,100,000 9,268,200 9,586,099 9,911,068 10,278,769 10,666,278
<br /> Less Fund 333 SDC Transportation Reimbursemen 900,000 926,820 958,610 991,107 1,027,877 1,066,628
<br /> Net Capital Preservation Target Expenditures 3,200,000 8,341,380 8,627,489 8,919,961 9,250,892 9,599,650
<br /> Transportation Utility - Fund 133
<br /> Beginning Working Capital 179,209 182,209 - - _
<br /> Projected Revenue
<br /> Net Fuel Tax Revenue after costs - Annual 3,369,000 2.928,000 2.020,000 2,020,000 2,020,000 2,020,000
<br /> Other Trans ortation Utility Revenue 82,000 30,000 30,000 30,000 30,000 80000
<br /> Total Revenue 3,451,111 8,159,17 8,627,489 8,919,961 9,250,892 9,599,650
<br /> Total Resources 3,630,209 8,341,380 8,627,489 8,919,961 9,250,892 9,599,650
<br /> Requirements
<br /> Capital Preservation Program Not TSMF d. Fundec 3,200,000 3 140,209 2,050,000 2,050,000 2,050,000 2,050,000
<br /> .1,':. m 4� ;', Z 2 v _ ice ;,.' t p , E � o- a -, ,' � ��
<br /> <
<br /> Total Capital Preservation 3,200,000 8,341,380 8,627,489 8,919,961 9,250,892 tt 9,599,650
<br /> Nondepartmental 248,000 - - - -
<br /> Total Expenditures 3,448,000 8,341,380 8,627,489 8,919,961 9,250,892 9,599,650
<br /> Balance Available 182,209 - - - _ -
<br /> Total Requirements 3,630,209 8,341,380 8,627,489 8,919,961 9,250,892 9,599,650
<br /> FY08 FY09 FY10 FY11 EI12
<br /> Monthly Base Fee 0.351 0.437 0.522 0.616 0.714
<br /> Net Collected Base Revenue - Annual 185,899 233,950 283,069 338,647 397,220
<br /> Target Revenue 185,899 233,950 283,069 338,647 397,220
<br /> Net <> Target - _
<br /> Trip -rate Fee 0.283 0.354 0.365 0.378 0.391
<br /> Net Collected Trip -rate Revenue - Annual 5,201,171 6,577,489 6,869,961 7,200,892 7,549,650
<br /> Target Revenue 5,201,171 6,577,489 6,869,961 7,200,892 7,549,650
<br /> -
<br /> Net <> Target _ _ -
<br /> Monthly Administrative Fee 0.867 0.880 0.893 0.908 0.925
<br /> Net Collected Administrative Fee Revenue -
<br /> Annual 458,969 471,603 484,367 499,054 514,457
<br /> Target Revenue 458,969 471,603 484,367 499,054 514,457
<br /> Net <> Target _ _ -
<br /> Total Monthly Revenue
<br /> Residential 212,493 260,166 274,108 289,903 306,543
<br /> Non- Residential 274.677 346,755 362,342 379,980 398,568
<br /> Total 487.170 606,920 636,450 669,883 705,111
<br /> % Residential Share 44% 43% 43% 43% 43%
<br /> % Non - residential Share 56% 57% 57% 57% 57%
<br /> z,,,' +few;:
<br /> Median Number of Total Monthly Fee
<br /> Examples Units for Median Units
<br /> Residential Apartments/Multifamily 1 $ 3.06
<br /> Single Family Dwelling 1 $ 4.03
<br /> Townhomes/Condos 1 $ 2.83
<br /> Mobile Home Parks 1 $ 2.57
<br /> Congregate Care Facifi 50 $ 31.69
<br /> Retirement Community 1 $ 1.94
<br /> Group Housing 25 $ 16.45
<br /> Non - Residential Low General Heavy Industn 8,640 $ 14.68
<br /> Mini - warehouse 32,423 $ 51.73
<br /> Park (Acre) 3 $ 5.89
<br /> General Light Industrial 10,680 $ 17.86
<br /> General Office Building 4,427 $ 8.11
<br /> Church 8,054 $ 13.77
<br /> Non - Residential Medium Clinic 4,566 $ 35.30
<br /> Specialty Retail Center 5,022 $ 38.70
<br /> Shopping Center 39,314 $ 294.63
<br /> Nursery- Garden Cente 3,662 $ 28.55
<br /> Discount Club 33,650 $ 252.36
<br /> Non - Residential High Govemment Office Buii 17,933 $ 401.42
<br /> Quality Restaurant 5,577 $ 125.68
<br /> Walk -In Bank 6,600 $ 148.51
<br /> Supermarket 5,787 $ 130.37
<br /> Fast Food Restaurant 2,632 $ 59.96
<br /> Non - Residential Education Elementary School (Sti 135 $ 49.73
<br /> Middle School (Student 300 $ 109.02
<br /> High School (Students) 1,500 $ 540.22
<br /> University (Students) 20,000 $ 7,187.90
<br /> Page 10 of 14
<br />
|