TSMF Model V:2.0.xls <br /> FY07 FY08 DM F`'10 FY11 FY12 <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 9599,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 nation Utility Revenue 82,000 30,000 30,000 30,000 30,000 30,000 <br /> R # S <br /> ..,. , st� : x a _ - u ....�;; 1��.:;.- .� ,..I , ;: ._,.,.. , ,° ", <br /> Total Revenue 3,451,000 8,159,171 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 Fundec 3,200,000 3,140,209 2,050,000 2,050,000 2,050,000 2,050,000 <br /> Total Capital Preservation 3,200,000 8,341,380 8,627,489 8,919,961 9,250,892 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 /> F Y08 FY09 EY10 FY11 FY12 <br /> Monthly Base Fee 2.647 2.704 2.761 2.828 2.898 <br /> Net Collected Base Revenue - Annual 1,400,899 1,448,950 1,498,069 1553,647 1,612,220 <br /> Target Revenue 1,400,899 1,448,950 1,498,069 1553,647 1,612,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 /> Net <> Target - - - - _ <br /> Monthly Administrative Fee 1.589 1.618 1.646 1.681 1.716 <br /> Net Collected Administrative Fee Revenue - <br /> Annual 841,241 867,092 893,328 923,272 954,716 <br /> Target Revenue 841241 867,092 893,328 923,272 954,716 <br /> Net <> Target - _ - <br /> Total Monthly Revenue <br /> Residential 336,781 385,483 400,474 417,456 435,344 <br /> Non - Residential 283,495 355,645 371,306 389,029 407,705 <br /> Total 620,276 741,128 771,780 806,484 843,049 <br /> % Residential Share 54% 52% 52% 52% 52% <br /> % Non - residential Share 46% 48% 48% 48% 48% <br /> Median Number of Total Monthly Fee <br /> Examples Units for Median Units <br /> Residential Apartments/Multifamily 1 $ 6.07 <br /> Single Family Dwelling 1 $ 7.05 <br /> Townhomes/Condos 1 $ 5.85 <br /> Mobile Home Parks 1 $ 5.59 <br /> Congregate Care Facie 50 $ 34.70 <br /> Retirement Community 1 $ 4.96 <br /> Group Housing 25 $ 19.47 <br /> Non - Residential Low General Heavy Indust, 8,640 $ 17.70 <br /> Mini - warehouse 32,423 $ 54.75 <br /> Park (Acre) 3 $ 8.91 <br /> General Light Industrial 10,680 $ 20.87 <br /> General Office Building 4,427 $ 11.13 <br /> Church 8,054 $ 16.78 <br /> Non- Residential Medium Clinic 4,566 $ 38.31 <br /> Specialty Retail Center 5,022 $ 41.72 <br /> Shopping Center 39,314 $ 297.65 <br /> Nursery- Garden Cente 3,662 $ 31.57 <br /> Discount Club 33,650 $ 255.38 <br /> Non- Residential High Govemment Office Buil 17,933 $ 404.44 <br /> Quality Restaurant 5,577 $ 128.70 <br /> Walk -In Bank 6,600 $ 151.53 <br /> Supermarket 5,787 $ 133.38 <br /> Fast Food Restaurant 2,632 5 62.97 <br /> Non - Residential Education Elementary School (Sit 135 $ 52.75 <br /> Middle School (Student 300 $ 112.04 <br /> High School (Students) 1,500 $ 543.24 <br /> University (Students) 20,000 $ 7,190.92 <br /> Page 6 of 14 <br />