CITY OF LAS VEGAS REVENUE REPORT

The following highlights are offered for the City 9s major revenue categories: " Intergovernmental revenues decreased -16.5% (approximately $3.3 million).<br><br> Consolidated Tax*, which accounts for 94% of the revenue in the category, declined -17.1% (approximately $3.3 million). Clark County taxable sales in July decreased -20.6% compared to the same month in the prior year. * Note- the Consolidated Tax figure noted above represents only one month of revenue.<br><br> At the time of this report, three months of revenue were reported by the State. Due to the timing of the CTAX payments received, the City does not accrue the distributions until the final two months of the fiscal year. So, the August distribution was recorded in October, whereas, September 9s distribution was recorded in November.<br><br> Therefore, through the first three months of FY2010, the City 9s Consolidated Tax declined $10.4 million (-17.3%) compared to the same period in the prior year. Consequently, restating the General Fund to include August and September Consolidated Tax distributions, the General Fund revenue decreased roughly $12.3 million (-9.6%). " Taxes through the first quarter of FY2010 decreased -4.5% (roughly $1.4 million) compared to the prior year.<br><br> Real Property Taxes declined -3.8% (roughly $1.2 million) while Personal Property Taxes dropped -24.3% (approximately $76 thousand). The drop in Personal Property taxes was due to the recession. Also, Room Tax declined -28.4 % (roughly $157 thousand) also due to the recession.<br><br> " Licenses and Permits decreased -2.8% (approximately $606 thousand) through the first quarter of FY2010. Business Licenses decreased -11.0% (approximately $423 thousand) due to the recession 4Gross Business Licenses declined -17.1% (roughly $447 thousand). Franchise Fees declined -1.8% ($281 thousand) due to less revenue in the Electric Utility (less demand) and the Gas Utility (rate decreases and less demand).<br><br> " Charges for Services increased 4.5% (approximately $339 thousand) through the first quarter of FY2010. EMS transports increased 21.4% (approximately $208 thousand) due to a fee increase and more transports. " Fines and Forfeits increased 4.5% (roughly $232 thousand) through the first quarter of FY2010.<br><br> Court Fines increased 3.7% (approximately $188 thousand) due to a 15% increase in Bail Converted to Fines. " Miscellaneous fees decreased -37.5% (approximately $388 thousand) due to the reclassification of rents provided by the City owned Atrium building. These rents were recorded in the General Fund in the first quarter of FY2009, whereas, in FY2010 they were reclassified into another Fund.<br><br> Page 2 Selected Enterprise Fund Revenue: " Building permits increased 1.4% (approximately $21 thousand) due in part to a 12.3% increase in building valuations. The increase in valuations was in large part due to healthy growth in Commercial Remodels (39%) and Miscellaneous (67%). All other valuation categories exhibited moderate to significant declines.<br><br> " Sewer Connection fees decreased -47.8% ($896 thousand) due to a drop in valuations other than the increase in Commercial Remodels (see above bullet). Commercial Remodels may or may not require a sewer connection depending on whether or not the remodel involves adding new fixtures. " Parking revenues increased 9.5% ($119 thousand).<br><br> The increase was due to more business and better collection efforts. GENERAL FUND REVENUE SUMMARY TOTAL REVENUES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 77,508,699 $ 82,817,017 $ 83,871,643 $ 87,300,584 $ 82,108,139 $ 2 nd 196,458,762 206,355,511 209,600,692 215,666,111 - 3 rd 321,373,591 337,092,683 342,159,784 341,723,967 - 4 th 490,292,702 508,110,241 509,889,134 485,554,731 - 482,608,032 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 16% 16% 16% 18% 17% 2nd qtr/4th qtr 40% 41% 41% 44% 3rd qtr/4th qtr 66% 66% 67% 70% 4th qtr/4th qtr 100% 100% 100% 100% 100% Total Revenue 2006-2010 Y-T-D $- $50,000,000 $100,000,000 $150,000,000 $200,000,000 $250,000,000 $300,000,000 $350,000,000 $400,000,000 $450,000,000 $500,000,000 $550,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Total Revenues 0.8% 6.6% 9.5% 20.5% 25.8% 36.7% TAXES LICENSES AND PERMITS INTERGOVERNMENTAL CHARGES FOR SERVICES FINES AND FORFEITS MISCELLANEOUS FY10 Unaudited Page 3 GENERAL FUND REVENUE CATEGORY- INTERGOVERNMENTAL SUMMARY STATISTICS INTERGOVERNMENTAL FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 21,223,916 $ 21,344,423 $ 21,086,480 $ 20,189,880 $ 16,866,187 $ 2 nd 87,510,009 88,020,488 85,864,133 81,125,213 - 3 rd 154,724,348 155,778,269 150,721,414 136,432,790 - 4 th 269,024,533 268,005,191 255,611,961 224,408,195 - 218,961,602 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 8% 8% 8% 9% 8% 2nd qtr/4th qtr 33% 33% 34% 36% 3rd qtr/4th qtr 58% 58% 59% 61% 4th qtr/4th qtr 100% 100% 100% 100% 100% Intergovernmental 2006-2010 Y-T-D $- $25,000,000 $50,000,000 $75,000,000 $100,000,000 $125,000,000 $150,000,000 $175,000,000 $200,000,000 $225,000,000 $250,000,000 $275,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Intergovernmental as a % of Total Revenue 20.5% Intergovernmental by Subcategories 5.2% 94.2% 0.5% State Shared Revenue Interlocal Cooperative Agreements Other Local Govt. Shared Revenue FY10 Unaudited Page 4 GENERAL FUND REVENUE CATEGORY- INTERGOVERNMENTAL STATE SHARED REVENUES FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual FY10 budget Quarter 1 st 20,038,393 $ 20,245,543 $ 20,018,880 $ 19,180,809 $ 15,894,973 $ 2 nd 85,161,371 85,777,716 83,676,311 79,012,576 - 3 rd 151,252,746 152,381,402 147,411,207 133,195,563 - 4 th 264,253,250 263,297,628 251,002,515 219,972,782 - 214,608,765 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 8% 8% 8% 9% 7% 2nd qtr/4th qtr 32% 33% 33% 36% 3rd qtr/4th qtr 57% 58% 59% 61% 4th qtr/4th qtr 100% 100% 100% 100% 100% State Shared Revenues 2006-2010 Y-T-D $- $40,000,000 $80,000,000 $120,000,000 $160,000,000 $200,000,000 $240,000,000 $280,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--State Shared Revenues State Shared Revenues decreased $3,285,836 (-17.13%) through the first quarter of FY2010 compared to the same period in the pri or year.<br><br> The decline in revenue can be attributed to the recession. For July, Statewide taxable sales declined 18.8% while Clark County taxable sales decreased 20.6%. Consolidated tax, which consists of six different revenue sources, accounts for the majority of the revenue in the categor y.<br><br> The six revenue sources are pooled at the County level and are distributed (by the State Treasurers office) to the local governments un der a two tiered formula. A base amount of revenue was initially established under the 1997 legislature and it has been adjusted each ca lendar year by the change in CPI to create the ensuing year base allocation. Accordingly, the City receives a base monthly allocation (calculated by the increase in CPI applied to prior years total distributions) and any excess collections above the base amount .<br><br> Any excess collections are distributed based on a formula that incorporates population and growth statistics. The increase in the CPI used to calculate FY2010 base amounts was 0.1%. As a side note, the first quarter year to date figure is only one month of revenue (July).<br><br> The Consolidated Tax Distribut ion for August and September are received in October and November and are recorded in the month of receipt--an accrual is not made. FY10 Unaudited Page 5 GENERAL FUND REVENUE CATEGORY- INTERGOVERNMENTAL INTERLOCAL COOPERATIVE AGREEMENTS FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual FY10 budget Quarter 1 st 153,929 $ 154,800 $ 127,037 $ 117,556 $ 88,094 $ 2 nd 351,187 371,049 306,276 317,014 - 3 rd 544,176 581,402 495,574 548,419 - 4 th 758,824 824,557 713,546 696,049 - 763,402 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 20% 19% 18% 17% 12% 2nd qtr/4th qtr 46% 45% 43% 46% 3rd qtr/4th qtr 72% 71% 69% 79% 4th qtr/4th qtr 100% 100% 100% 100% 100% Interlocal Cooperative Agreements 2006-2010 Y-T-D $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Interlocal Cooperative Agreements Through the first quarter of FY2010, Interlocal Agreements decreased $29,462 (-25.06%) compared to the same period in the prior year. Reimbursed From Other Governments is the lone item in the category.<br><br> FY10 Unaudited Page 6 GENERAL FUND REVENUE CATEGORY- INTERGOVERNMENTAL OTHER LOCAL GOVT. SHARED REVENUES FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual FY10 budget Quarter 1 st 1,031,594 $ 944,080 $ 940,563 $ 891,515 $ 883,120 $ 2 nd 1,997,451 1,871,723 1,881,546 1,795,623 - 3 rd 2,927,426 2,815,465 2,814,633 2,688,808 - 4 th 4,012,459 3,883,006 3,895,900 3,739,364 - 3,589,435 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 26% 24% 24% 24% 25% 2nd qtr/4th qtr 50% 48% 48% 48% 3rd qtr/4th qtr 73% 73% 72% 72% 4th qtr/4th qtr 100% 100% 100% 100% 100% Other Local Govt. Shared Revenues 2006-2010 Y-T-D $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Other Local Govt.<br><br> Shared Revenues First quarter revenue for FY2010 decreased $8,395 (-0.94%) compared to the same period in the prior year. The revenue category consists of County Gaming Licenses. The County collects gaming taxes from various City gambling establishments and subsequently distributes the proceeds to th e City.<br><br> County Gaming Licenses are levied upon the casino on a monthly basis per slot machine, per table game, and other miscellaneous games at varying rates depending on the type of game. These fees are paid quarterly in advance. A review of the Gaming Contro l Boards "Gaming Revenue Report", for the three month period ending September 30, 2009, indicated that the number of games/tables increased 2.88% while the number of slot machines increased 0.35% in the Downtown Las Vegas area.<br><br> On the downside, the gaming win for the same three month period declined -8.1% in the downtown Las Vegas area. FY10 Unaudited Page 7 GENERAL FUND REVENUE CATEGORY- TAXES SUMMARY STATISTICS TAXES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 25,911,851 $ 28,233,767 $ 30,309,782 $ 31,552,619 $ 30,145,445 $ 2 nd 49,949,727 55,279,105 59,781,187 62,892,559 - 3 rd 76,517,332 86,515,657 93,675,356 101,420,370 - 4 th 97,319,395 107,158,919 116,574,425 122,793,161 - 117,072,525 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 27% 26% 26% 26% 26% 2nd qtr/4th qtr 51% 52% 51% 51% 3rd qtr/4th qtr 79% 81% 80% 83% 4th qtr/4th qtr 100% 100% 100% 100% 100% Taxes 2006-2010 Y-T-D $- $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 $100,000,000 $110,000,000 $120,000,000 $130,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Taxes as a % of Total Revenue 36.7% Taxes by Subcategories 98.7% 1.3% Ad Valorem Property Tax Room Tax FY10 Unaudited Page 8 GENERAL FUND REVENUE CATEGORY- TAXES AD VALOREM PROPERTY TAX FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 25,338,912 $ 27,700,664 $ 29,709,278 $ 31,000,182 $ 29,749,899 $ 2 nd 48,780,677 54,133,627 58,508,530 61,823,911 - 3 rd 74,767,298 84,719,193 91,791,589 99,949,387 - 4 th 94,864,021 104,642,849 113,965,913 120,857,061 - 115,113,072 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 27% 26% 26% 26% 26% 2nd qtr/4th qtr 51% 52% 51% 51% 3rd qtr/4th qtr 79% 81% 81% 83% 4th qtr/4th qtr 100% 100% 100% 100% 100% Assessed Value and Ad Valorem Tax Rate Trend Analysis: 2006 2007 2008 2009 2010 Allowed Tax Rate 0.8595 0.8628 0.8644 0.8655 0.9454 Tax Rate Levied 0.6765 0.6765 0.6765 0.6765 0.6765 % = levied/allowable 79% 78% 78% 78% 72% Assessed Valuation 16.48 billion 22.03 billion 24.65 billion 24.99 billion 18.29 billion % change from prior year 29.57% 33.68% 11.89% 1.38% -26.81% Ad Valorem Property Tax 2006-2010 Y-T-D $10,000,000 $25,000,000 $40,000,000 $55,000,000 $70,000,000 $85,000,000 $100,000,000 $115,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Ad Valorem Property Tax Ad Valorem Property Tax declined $1,250,283 (-4.03%) through the first quarter of FY2010 compared to the same period in the prior year. The line item consists of Real Property Tax and Personal Property Tax.<br><br> Real Property Tax decreased $1,173,879 (-3.83%), while, Personal Property Taxes declined $76,405 (-24.33%). The decrease noted for Real Property Tax was due to the decline in assessed valuation as a result of the fall in the real estate market. The actual decline in revenue (-4.03%) did not mirror the decrease in assessed valuation (-26.81%) due to the Legislative tax cap implemented in FY2006 which limited the amount a property owners tax liability could increase from year to year---3% for residential and 8% for investment/commercial properties.<br><br> It also created an abatement which maintained the tax base despite declines in assessed valuations. The abatement requires depletion, by declines in assessed value, before tax liabilities can also decrease. So, for FY2010, the realtively small decline in revenue (relative to the - 26.81% dip in assessed value) was due to assessed valuations not falling enough to eliminate all the abatements.<br><br> It's projected that more material losses in Property Tax revenue will occur in FY2011 when all abatements are exhausted. FY10 Unaudited Page 9 GENERAL FUND REVENUE CATEGORY- TAXES ROOM TAX FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 572,939 $ 533,103 $ 600,504 $ 552,437 $ 395,546 $ 2 nd 1,169,050 1,145,478 1,272,657 1,068,648 - 3 rd 1,750,034 1,796,464 1,883,767 1,470,983 - 4 th 2,455,374 2,516,070 2,608,512 1,936,100 - 1,959,453 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 23% 21% 23% 29% 20% 2nd qtr/4th qtr 48% 46% 49% 55% 3rd qtr/4th qtr 71% 71% 72% 76% 4th qtr/4th qtr 100% 100% 100% 100% 100% Room Tax 2006-2010 Y-T-D $- $250,000 $500,000 $750,000 $1,000,000 $1,250,000 $1,500,000 $1,750,000 $2,000,000 $2,250,000 $2,500,000 $2,750,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Room Tax Room Tax revenue through the first quarter of FY2010 decreased $156,891 (-28.4%) compared to the same period in the prior year. The decline in revenue can be attributed to the recession.<br><br> Specifically, from a Room Tax perspective, per a review of the Las Vegas Convention and Visitor's Authority's website, almost all major gauges were down for calendar year 2009--with the exception of average daily auto traffic. Specifically, from January to September 2009, the following highlights a portion of the LVCVA's statistics from a room tax perspective: Visitor Volume decreased -4.7% Convention Attendance decreased -27.1% Total Occupancy Levels decreased -5.6% Average Room Rate decreased -24.7% Total Airline Passengers decreased -10.2% Auto Traffic All Major Highways increased 2.8% Auto Traffic I-15 at NV/CA Border increased 4.8% FY10 Unaudited Page 10 GENERAL FUND REVENUE CATEGORY- LICENSE AND PERMITS SUMMARY STATISTICS LICENSES & PERMITS FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 19,417,720 $ 21,314,864 $ 21,183,555 $ 21,838,073 $ 21,193,695 $ 2 nd 36,727,180 40,112,099 40,709,002 41,581,721 - 3 rd 56,018,820 59,472,695 60,034,829 60,571,378 - 4 th 76,366,795 83,429,429 83,402,354 80,022,859 - 84,500,755 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 25% 26% 25% 27% 25% 2nd qtr/4th qtr 48% 48% 49% 52% 3rd qtr/4th qtr 73% 71% 72% 76% 4th qtr/4th qtr 100% 100% 100% 100% 100% Licenses & Permits 2006-2010 Y-T-D $- $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Licenses & Permits as a % of Total Revenue 25.8% Licenses & Permits by Subcategories 72.1% 6.9% 3.4% 16.1% 1.4% Business Licenses Liquor Licenses City Gaming Licenses Franchise Fees Other Licenses & Permits FY10 Unaudited Page 11 GENERAL FUND REVENUE CATEGORY- LICENSES AND PERMITS BUSINESS LICENSES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 3,359,571 $ 3,826,630 $ 3,869,496 $ 3,845,453 $ 3,422,709 $ 2 nd 6,331,307 7,560,607 7,671,654 7,641,856 - 3 rd 10,446,596 11,819,890 11,829,974 11,400,392 - 4 th 13,838,572 15,584,842 15,543,256 14,678,367 - 15,071,022 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 24% 25% 25% 26% 23% 2nd qtr/4th qtr 46% 49% 49% 52% 3rd qtr/4th qtr 75% 76% 76% 78% 4th qtr/4th qtr 100% 100% 100% 100% 100% Business Licenses 2006-2010 Y-T-D $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Business Licenses Business Licenses, through the first quarter of FY2010, declined $422,744 (-10.99%) compared to the same period in the prior year. The decline was due to the recession.<br><br> Gross Business Licenses declined $447,449 (- 17.07%) while Fixed Business Licenses increased $32,684 (2.69%). The Gross portion of the category has suffered from business closures, as well as, a slowdown in consumer spending. FY10 Unaudited Page 12 GENERAL FUND REVENUE CATEGORY- LICENSES AND PERMITS LIQUOR LICENSES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 686,438 $ 776,694 $ 645,238 $ 576,852 $ 717,915 $ 2 nd 955,000 1,216,078 1,044,384 1,057,223 - 3 rd 1,536,475 1,824,531 1,779,076 1,737,150 - 4 th 1,808,911 2,056,629 2,168,024 1,961,866 - 2,108,140 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 38% 38% 30% 29% 34% 2nd qtr/4th qtr 53% 59% 48% 54% 3rd qtr/4th qtr 85% 89% 82% 89% 4th qtr/4th qtr 100% 100% 100% 100% 100% Liquor Licenses 2006-2010 Y-T-D $- $250,000 $500,000 $750,000 $1,000,000 $1,250,000 $1,500,000 $1,750,000 $2,000,000 $2,250,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Liquor Licenses Liquor licenses through the first quarter of FY2010 increased $141,063 (24.45%) compared to the same period in the prior year.<br><br> The category consists of semiannual license fees and original new license fees. Semiannual fees increased $40,903 (7.11%)---they range from $100 to $1,200 and are due in advance on April 1st and October 1st. Original new license fees increased $100,160.<br><br> FY10 Unaudited Page 13 GENERAL FUND REVENUE CATEGORY- LICENSES AND PERMITS CITY GAMING LICENSES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 1,541,464 $ 1,789,843 $ 1,214,111 $ 1,409,857 $ 1,464,249 $ 2 nd 1,985,738 1,912,494 1,928,666 1,855,358 - 3 rd 3,769,781 3,588,058 3,693,985 3,259,035 - 4 th 3,937,235 3,841,208 3,800,555 3,675,227 - 3,630,375 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 39% 47% 32% 38% 40% 2nd qtr/4th qtr 50% 50% 51% 50% 3rd qtr/4th qtr 96% 93% 97% 89% 4th qtr/4th qtr 100% 100% 100% 100% 100% City Gaming Licenses 2006-2010 Y-T-D $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--City Gaming Licenses City Gaming Licenses increased $54,392 (3.86%) through the first quarter of FY2010 compared to the same period in the prior year. City Gaming Licenses are due from an establishment on a per game basis. The licenses are due semiannually with each fee due in advance on October 1st and April 1st.<br><br> The increase noted for the revenue source can be attributed to a timing issue. A review of the Gaming Control Boards "Gaming Revenue Report", for the three month period ending September 30, 2009, indicated that the number of games/tables increased 2.88% while the number of slot machines increased 0.35% in the Downtown Las Vegas area. On the downside, the gaming win for the same three month period declined -8.1% in the downtown Las Vegas area.<br><br> FY10 Unaudited Page 14 GENERAL FUND REVENUE CATEGORY- LICENSES AND PERMITS FRANCHISE FEES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 12,636,597 $ 13,406,524 $ 14,456,719 $ 15,569,496 $ 15,288,354 $ 2 nd 24,624,212 26,799,926 28,371,716 30,194,754 - 3 rd 36,054,327 38,118,688 40,508,339 43,030,657 - 4 th 51,471,981 56,945,423 59,020,668 58,122,961 - 62,239,677 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 25% 24% 24% 27% 25% 2nd qtr/4th qtr 48% 47% 48% 52% 3rd qtr/4th qtr 70% 67% 69% 74% 4th qtr/4th qtr 100% 100% 100% 100% 100% Franchise Fees 2006-2010 Y-T-D $- $6,000,000 $12,000,000 $18,000,000 $24,000,000 $30,000,000 $36,000,000 $42,000,000 $48,000,000 $54,000,000 $60,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Franchise Fees Franchise fees decreased $281,142 (-1.81%) through the first quarter of FY2010 compared to the same period in the prior year. The following summarizes the activity for the period: Gas Utility decreased $ (102,192) -7.28% Electric Utility decreased $ (567,086) -5.85% Telephone Utility increased $ 325,687 12.78% Garbage Utility increased $ 11,974 1.46% Cable Utility increased $ 54,476 5.37% The decrease in the Gas Utility can be attributed to rate decreases and less demand while the Electric Utility also decreased due to less demand. On the brightside, the Telephone Utility increased due to a new franchise that added a substantial amount of revenue in the quarter.<br><br> Lastly, the Cable Utility increased due to more demand and rate hikes. FY10 Unaudited Page 15 GENERAL FUND REVENUE CATEGORY- LICENSES AND PERMITS OTHER LICENSES & PERMITS FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 1,193,650 $ 1,515,173 $ 997,991 $ 436,415 $ 300,468 $ 2 nd 2,830,923 2,622,994 1,692,582 832,530 - 3 rd 4,211,641 4,121,528 2,223,455 1,144,144 - 4 th 5,310,096 5,001,327 2,869,851 1,584,438 - 1,451,541 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 22% 30% 35% 28% 21% 2nd qtr/4th qtr 53% 52% 59% 53% 3rd qtr/4th qtr 79% 82% 77% 72% 4th qtr/4th qtr 100% 100% 100% 100% 100% Other Licenses & Permits 2006-2010 Y-T-D $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 $5,000,000 $5,500,000 $6,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Other Licenses and Permits Other Licenses and Permits decreased $135,947 (-31.15%) through the first quarter of FY2010 compared to the same period in the prior year. The majority of the line items in the category declined with the exception of Zoning which increased $10,790 (33.56%).<br><br> Life Safety permits, Plans Check Fees, and Off-site Permit Fees, which represent 82% of the revenue in the category, declined $54,636 (-38.80%), $82,476 (-50.81%), and $35,158 (-41.81%)--respectively. The downturn in the real estate market, and the recession, both contributed to the loss of revenue noted in the Other Licenses and Permits category. FY10 Unaudited Page 16 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES SUMMARY STATISTICS CHARGES FOR SERVICES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 7,364,340 $ 7,737,874 $ 6,542,506 $ 7,492,913 $ 7,832,152 $ 2 nd 14,292,303 13,816,156 13,089,819 16,391,977 - 3 rd 21,212,500 20,355,608 20,034,358 23,759,995 - 4 th 28,827,670 26,389,280 27,846,518 30,468,507 - 30,889,700 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 26% 29% 23% 25% 25% 2nd qtr/4th qtr 50% 52% 47% 54% 3rd qtr/4th qtr 74% 77% 72% 78% 4th qtr/4th qtr 100% 100% 100% 100% 100% Charges for Services 2006-2010 Y-T-D $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Charges for Services as a % of Total Revenue 9.5% Charges for Services by Subcategories 15.1% 12.3% 14.5% 2.1% 20.8% 21.8% 13.4% 0.1% Reimb.<br><br> Charges Correction Charges Planning & Dev. Charges Municipal Court Charges Miscellaneous Charges Transportation Fees Other Fees EMS Transports FY10 Unaudited Page 17 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES PLANNING & DEVELOPMENT FEES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 205,199 $ 176,075 $ 155,077 $ 150,274 $ 166,445 $ 2 nd 440,004 325,058 337,452 311,689 - 3 rd 664,622 530,087 505,966 510,918 - 4 th 890,602 693,838 659,738 697,220 - 702,834 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 23% 25% 24% 22% 24% 2nd qtr/4th qtr 49% 47% 51% 45% 3rd qtr/4th qtr 75% 76% 77% 73% 4th qtr/4th qtr 100% 100% 100% 100% 100% Planning & Development Charges 2006-2010 Y-T-D $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Planning & Development Charges Through the first quarter of FY2010, Planning & Development, which consists of two items (Planning & Development and Sign Code fees), increased $16,171 (10.76%) compared to the same period in the prior year. FY10 Unaudited Page 18 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES CORRECTIONS CHARGES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 2,585,349 $ 2,316,255 $ 1,521,499 $ 1,521,248 $ 1,625,843 $ 2 nd 5,047,470 3,578,026 3,066,223 3,093,799 - 3 rd 7,095,663 5,102,593 4,620,798 4,687,096 - 4 th 9,461,165 6,216,856 5,950,553 6,270,264 - 6,209,920 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 27% 37% 26% 24% 26% 2nd qtr/4th qtr 53% 58% 52% 49% 3rd qtr/4th qtr 75% 82% 78% 75% 4th qtr/4th qtr 100% 100% 100% 100% 100% Corrections Charges 2006-2010 Y-T-D $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000 $11,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Corrections Charges Through the first quarter of FY2010, Corrections Charges increased $104,595 (6.88%) compared to the same period in the prior year.<br><br> Revenue from the US Marshals declined $19,489 (-21.9%) while revenue from Clark County increased $121,029 (8.47%). The price per day charged for a bed remained the same compared to the prior year. The increase in revenue from Clark County can be attributed to an increase in volume.<br><br> FY10 Unaudited Page 19 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES REIMBURSABLE CHARGES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 1,697,486 $ 1,977,599 $ 1,482,745 $ 1,806,390 $ 1,703,520 $ 2 nd 3,441,357 3,863,824 3,264,992 3,850,951 - 3 rd 4,998,156 5,450,187 4,801,356 5,641,260 - 4 th 6,641,620 7,335,019 7,514,089 7,548,519 - 7,939,852 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 26% 27% 20% 24% 21% 2nd qtr/4th qtr 52% 53% 43% 51% 3rd qtr/4th qtr 75% 74% 64% 75% 4th qtr/4th qtr 100% 100% 100% 100% 100% Reimbursable Charges 2006-2010 Y-T-D $- $750,000 $1,500,000 $2,250,000 $3,000,000 $3,750,000 $4,500,000 $5,250,000 $6,000,000 $6,750,000 $7,500,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Reimbursable Charges Reimbursable charges decreased $102,870 (-5.69%) through the first quarter of FY2010 compared to the same period in the prior year. The revenue category consists of four revenue sources (only two are material)--Charges for Labor/Materials and General Government Cost Allocation. Charges for Labor/Materials decreased $52,528 (-4.47%).<br><br> The other line item in the category, General Government Cost Allocation, decreased $54,628 (-8.65%). The decline in the General Government Cost Allocation was due to an -8.61% decline in the "Allocation Base Monthly Labor". FY10 Unaudited Page 20 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES MUNICIPAL COURT CHARGES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 950,743 $ 1,038,129 $ 1,143,537 $ 1,138,518 $ 1,133,413 $ 2 nd 1,820,028 2,022,478 2,238,930 2,210,480 - 3 rd 2,913,081 3,251,428 3,602,667 3,510,940 - 4 th 3,984,945 4,467,164 4,798,957 4,677,004 - 4,813,415 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 24% 23% 24% 24% 24% 2nd qtr/4th qtr 46% 45% 47% 47% 3rd qtr/4th qtr 73% 73% 75% 75% 4th qtr/4th qtr 100% 100% 100% 100% 100% Municipal Court Charges 2006-2010 Y-T-D $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 $5,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Municipal Court Charges Municipal Court Charges decreased $5,105 (-0.45%) through the first quarter of FY2010 compared to the same period in the prior year.<br><br> The recession has had an effect on the category. The following shows the detail for the category: Financial Counseling Fees increased $28,348 20.72% In House Arrest Fee decreased ($10,701) (-18.98%) Miscellaneous Court Fees decreased ($36,352) (-13.49%) Court Counseling Fees decreased ($1,576) (-0.47%) Traffic School decreased ($1,434) (-2.17%) Internet Traffic School decreased ($6,202) (-9.84%) Assessment Center decreased ($4,440) (-15.56%) Work Program increased $10,287 31.70% Collection Fees increased $16,965 11.44% FY10 Unaudited Page 21 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES OTHER FEES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 527,087 $ 516,187 $ 583,735 $ 894,968 $ 1,051,896 $ 2 nd 1,046,623 1,015,799 1,154,422 3,129,795 - 3 rd 1,692,141 1,708,407 1,923,329 3,882,051 - 4 th 2,436,961 2,211,332 2,322,858 3,534,928 - 3,316,400 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 22% 23% 25% 25% 32% 2nd qtr/4th qtr 43% 46% 50% 89% 3rd qtr/4th qtr 69% 77% 83% 110% 4th qtr/4th qtr 100% 100% 100% 100% 100% Other Fees 2006-2010 Y-T-D $- $400,000 $800,000 $1,200,000 $1,600,000 $2,000,000 $2,400,000 $2,800,000 $3,200,000 $3,600,000 $4,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Other Fees Other fees increased $156,928 (17.53%) through the first quarter of FY2010 compared to the same period in the prior year. A majority of the line items in the category declined with the exception of Special Inspection fees.<br><br> Special Inspection fees increased $199,406 (53.61%) due to action by Council to charge parcel owners with civil penalties for noncompliance with Health and Safety ordinances. Notewothy declines were to Drainage Study fees (-$12,800; -67.37%), to Business License Application fees (-$4,870; -6.43%), and to UFC Permit fees (- $14,927; -8.39%). FY10 Unaudited Page 22 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES MISCELLANEOUS FEES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 681,183 $ 1,092,828 $ 1,098,358 $ 977,659 $ 959,699 $ 2 nd 1,144,023 1,791,315 1,811,074 1,573,043 - 3 rd 1,806,456 2,484,558 2,626,585 2,276,419 - 4 th 2,729,908 3,102,118 3,687,941 3,294,086 - 3,399,894 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 25% 35% 30% 30% 28% 2nd qtr/4th qtr 42% 58% 49% 48% 3rd qtr/4th qtr 66% 80% 71% 69% 4th qtr/4th qtr 100% 100% 100% 100% 100% Trend Analysis--Miscellaneous Fees Miscellaneous fees through the first quarter of FY2010 decreased $17,960 (-1.84%) compared to the same period in the prior year.<br><br> Miscellaneous fees consist of Recreation Charges and Theater Performances. Recreation Charges declined $18,866 (-1.93%) due to the economy. Miscellaneous Fees 2006-2010 Y-T-D $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual FY10 Unaudited Page 23 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES TRANSPORTATION FEES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 84,764 $ 43,501 $ 40,095 $ 28,344 $ 7,405 $ 2 nd 156,589 84,659 80,311 61,918 - 3 rd 242,821 129,772 114,183 83,164 - 4 th 306,040 158,756 146,488 115,826 - 110,764 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 28% 27% 27% 24% 7% 2nd qtr/4th qtr 51% 53% 55% 53% 3rd qtr/4th qtr 79% 82% 78% 72% 4th qtr/4th qtr 100% 100% 100% 100% 100% Trend Analysis--Transportation Fees Transportation Fees declined $20,939 (-73.87%) through the first quarter of FY2010 compared to the same period in the prior year.<br><br> Trolley Fares is the lone item in the category. Transportation Fees 2006-2010 Y-T-D $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual FY10 Unaudited Page 24 GENERAL FUND REVENUE CATEGORY- CHARGES FOR SERVICES EMS TRANSPORTS FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 632,529 $ 577,300 $ 517,460 $ 975,512 $ 1,183,931 $ 2 nd 1,196,209 1,134,997 1,136,415 2,160,302 - 3 rd 1,799,560 1,698,576 1,839,474 3,168,147 - 4 th 2,376,429 2,204,197 2,765,894 4,330,660 - 4,396,621 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 27% 26% 19% 23% 27% 2nd qtr/4th qtr 50% 51% 41% 50% 3rd qtr/4th qtr 76% 77% 67% 73% 4th qtr/4th qtr 100% 100% 100% 100% 100% Trend Analysis--EMS Transports EMS transport revenue increased $208,419 (21.37%) through the first quarter of FY2010 compared to the same period in the prior year. The jump in revenue can be attributed to more transports, an increase of 6.6%, and a fee increase.<br><br> EMS Transports 2006-2010 Y-T-D $- $300,000 $600,000 $900,000 $1,200,000 $1,500,000 $1,800,000 $2,100,000 $2,400,000 $2,700,000 $3,000,000 $3,300,000 $3,600,000 $3,900,000 $4,200,000 $4,500,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual FY10 Unaudited Page 25 GENERAL FUND REVENUE CATEGORY- FINES AND FORFEITS SUMMARY STATISTICS FINES & FORFEITS FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 3,626,532 $ 3,882,214 $ 3,902,965 $ 5,193,630 $ 5,425,188 $ 2 nd 6,989,340 7,651,260 7,770,408 10,402,191 - 3 rd 11,125,209 12,043,180 12,837,119 16,295,421 - 4 th 15,176,504 16,406,342 18,038,379 21,737,862 - 24,176,456 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 24% 24% 22% 24% 22% 2nd qtr/4th qtr 46% 47% 43% 48% 3rd qtr/4th qtr 73% 73% 71% 75% 4th qtr/4th qtr 100% 100% 100% 100% 100% Fines & Forfeits 2006-2010 Y-T-D $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 $20,000,000 $22,000,000 $24,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Fines & Forfeits as a % of Total Revenue 6.6% Fines & Forfeits by Subcategories 3.6% 96.4% COURT FINES FORFEITED BAIL FY10 Unaudited Page 26 GENERAL FUND REVENUE CATEGORY- FINES AND FORFEITS COURT FINES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 3,517,177 $ 3,793,136 $ 3,800,793 $ 5,043,160 $ 5,231,527 $ 2 nd 6,777,869 7,473,267 7,578,678 10,154,180 - 3 rd 10,799,490 11,768,988 12,475,596 15,930,501 - 4 th 14,749,114 16,033,088 17,557,150 21,229,121 - 23,700,656 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 24% 24% 22% 24% 22% 2nd qtr/4th qtr 46% 47% 43% 48% 3rd qtr/4th qtr 73% 73% 71% 75% 4th qtr/4th qtr 100% 100% 100% 100% 100% Court Fines 2006-2010 Y-T-D $- $1,500,000 $3,000,000 $4,500,000 $6,000,000 $7,500,000 $9,000,000 $10,500,000 $12,000,000 $13,500,000 $15,000,000 $16,500,000 $18,000,000 $19,500,000 $21,000,000 $22,500,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Court Fines Court Fines increased $188,367 (3.74%) through the first quarter of FY2010 compared to the same period in the prior year. There are two line items in the category--Municipal Court Fines and Bail Converted to Fines. Municipal Court Fines and Bail Converted to Fines increased $79,393 (1.84%) and $108,974 (14.97%)-- respectively.<br><br> FY10 Unaudited Page 27 GENERAL FUND REVENUE CATEGORY- FINES AND FORFEITS FORFEITED BAIL FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 109,355 $ 89,078 $ 102,172 $ 150,470 $ 193,661 $ 2 nd 211,471 177,993 191,730 248,011 - 3 rd 325,719 274,192 361,523 364,920 - 4 th 427,390 373,254 481,229 508,741 - 475,800 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 26% 24% 21% 30% 41% 2nd qtr/4th qtr 49% 48% 40% 49% 3rd qtr/4th qtr 76% 73% 75% 72% 4th qtr/4th qtr 100% 100% 100% 100% 100% Forfeited Bail 2006-2010 Y-T-D $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 $500,000 $550,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Forfeited Bail Forfeited Bail increased $43,191 (28.7%) through the first quarter of FY2010 compared to the same period in the prior year. FY10 Unaudited Page 28 GENERAL FUND REVENUE CATEGORY- MISCELLANEOUS SUMMARY STATISTICS MISCELLANEOUS FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st (35,660) $ 303,875 $ 748,746 $ 1,033,469 $ 645,472 $ 2 nd 990,203 1,476,403 2,288,534 3,272,450 - 3 rd 1,775,382 2,868,774 4,759,099 3,244,013 - 4 th 3,577,805 6,662,580 8,317,888 6,124,147 - 7,006,994 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr -1% 5% 9% 17% 9% 2nd qtr/4th qtr 28% 22% 28% 53% 3rd qtr/4th qtr 50% 43% 57% 53% 4th qtr/4th qtr 100% 100% 100% 100% 100% Miscellaneous 2006-2010 Y-T-D $(200,000) $600,000 $1,400,000 $2,200,000 $3,000,000 $3,800,000 $4,600,000 $5,400,000 $6,200,000 $7,000,000 $7,800,000 $8,600,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Miscellaneous Revenue as a % of Total Revenue 0.8% Miscellaneous by Subcategories (133,146) 323,154 455,464 (200,000) 0 200,000 400,000 600,000 INTEREST EARNINGS RENTALS OTHER FY10 Unaudited Page 29 GENERAL FUND REVENUE CATEGORY-MISCELLANEOUS INTEREST EARNINGS FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st (223,930) $ (146,947) $ (93,989) $ (33,069) $ (133,146) $ 2 nd 334,957 482,813 749,911 616,030 - 3 rd 769,720 1,300,096 1,571,792 1,427,672 - 4 th 1,821,731 3,316,456 3,711,593 3,549,942 - 3,303,671 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr -12% -4% -3% -1% -4% 2nd qtr/4th qtr 18% 15% 20% 17% 3rd qtr/4th qtr 42% 39% 42% 40% 4th qtr/4th qtr 100% 100% 100% 100% 100% Trend Analysis--Interest Earnings The category of Interest Earnings is comprised of Investment Income and Other Interest Earnings. The following details the activity for Investment Income through the first quarter of FY2010 compared to the same period in the prior year: FY10 FY09 $variance %vari ance July ($472,278) ($465,687) ($6,591) 1.42% August $134,192 $161,953 ($27,760) -17.14% September $199,972 $243,080 ($43,108) -17.73% July's negative interest figures were the reversals of the June accruals from the respective prior years.<br><br> FY2009's accrual was 1.42% larger than the FY2008 accrual. August and September of FY2010, which represents July and August interest, decreased $70,868 (-17.5%) compared to the same months in the prior year. The decline in Investment Income for July and August was due to a lower effective rate of return, as well as, a decline in the amount of the investment pool allocated to the General Fund.<br><br> Interest Earnings 2006-2010 Y-T-D ($300,000) $100,000 $500,000 $900,000 $1,300,000 $1,700,000 $2,100,000 $2,500,000 $2,900,000 $3,300,000 $3,700,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual FY10 Unaudited Page 30 GENERAL FUND REVENUE CATEGORY-MISCELLANEOUS RENTALS FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 197,925 $ 337,651 $ 282,362 $ 903,679 $ 455,464 $ 2 nd 476,807 642,681 608,733 2,118,081 - 3 rd 784,207 988,182 1,814,261 1,117,578 - 4 th 1,271,052 2,409,348 2,916,050 1,655,966 - 1,834,186 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 16% 14% 10% 55% 25% 2nd qtr/4th qtr 38% 27% 21% 128% 3rd qtr/4th qtr 62% 41% 62% 67% 4th qtr/4th qtr 100% 100% 100% 100% 100% Trend Analysis--Rentals Rental revenue through the first quarter of FY2010 decreased $448,215 (-49.6%) compared to the same period in the prior year. The large decrease was due to rents provided by the Atrium in the first quarter of FY2009. For FY2010, the rents provided by the Atrium are not recorded in the General Fund.<br><br> So, factoring out the Atrium rents from FY2009, the line item increased $230,181 (102.2%) due to the reclassification of rents from Leisure into the rental account that were recorded in Charges for Services previously. Rentals 2006-2010 Y-T-D $- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 $2,000,000 $2,200,000 $2,400,000 $2,600,000 $2,800,000 $3,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual FY10 Unaudited Page 31 GENERAL FUND REVENUE CATEGORY-MISCELLANEOUS OTHER FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st (9,655) $ 113,171 $ 560,373 $ 162,859 $ 323,154 $ 2 nd 178,439 350,909 929,890 538,339 - 3 rd 221,455 580,496 1,373,046 698,763 - 4 th 485,022 936,776 1,690,245 918,239 - 1,869,137 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr -2% 12% 33% 18% 17% 2nd qtr/4th qtr 37% 37% 55% 59% 3rd qtr/4th qtr 46% 62% 81% 76% 4th qtr/4th qtr 100% 100% 100% 100% 100% Other 2006-2010 Y-T-D $- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Other Other revenue increased $160,295 (98.43%) through the first quarter of FY2010 compared to the same period in the prior year. The large increase was partially due to the removal of turf at City locations which qualified for the SNWA's cash rebate program for replacing turf with water efficient landscapes.<br><br> FY10 Unaudited Page 32 SELECTED ENTERPRISE FUND REVENUES BUILDING PERMITS FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 4,114,647 $ 3,262,760 $ 1,864,486 $ 1,582,300 $ 1,603,743 $ 2 nd 7,177,823 6,066,697 4,198,935 3,303,960 - 3 rd 12,474,771 9,965,541 6,294,013 4,872,568 - 4 th 16,429,819 13,563,218 8,792,319 6,933,548 - 5,380,092 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 25% 24% 21% 23% 30% 2nd qtr/4th qtr 44% 45% 48% 48% 3rd qtr/4th qtr 76% 73% 72% 70% 4th qtr/4th qtr 100% 100% 100% 100% 100% Building Permits 2006-2010 Y-T-D $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Building Permits Building Permits, through the first quarter of FY2010, increased $21,443 (1.36%) compared to the same period in the prior year. The following highlights the activity in the first quarter of FY2010: Structural Permits $ (28,011) (-4.75%) Electrical Permits $ (19,589) (-12.83%) Plumbing Permits $ 37,221 22.13% Air Conditioning Permits $ (16,804) (-13.35%) Plans Check Fees $ 66,081 16.29% Plans O/T Reimb. $ (2,680) (-77.01%) Express Admin.<br><br> Fee $ 15,500 387.50% Express Hourly Plans Check $ (26,880) (-21.52%) The increase in the category was due to higher valuations compared to the prior year. Overall, valuations increased 12.3% through the first quarter of FY2010. The increase, in valuations, was the result of a 39% increase to Commercial Remodels and a 67% increase to Miscellaneous.<br><br> All other material categories experienced moderate to significant valuation declines. FY10 Unaudited Page 33 SELECTED ENTERPRISE FUND REVENUES SEWER CONNECTION FEES FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 6,743,724 $ 3,229,235 $ 1,935,865 $ 1,873,148 $ 977,375 $ 2 nd 10,821,869 6,789,672 4,682,827 2,598,720 - 3 rd 17,477,261 9,643,534 7,208,776 4,147,913 - 4 th 22,687,522 14,274,167 10,329,916 5,966,118 - 5,000,000 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 30% 23% 19% 18% 20% 2nd qtr/4th qtr 48% 48% 45% 25% 3rd qtr/4th qtr 77% 68% 70% 40% 4th qtr/4th qtr 100% 100% 100% 58% 100% Sewer Connection Fees 2006-2010 Y-T-D $- $2,500,000 $5,000,000 $7,500,000 $10,000,000 $12,500,000 $15,000,000 $17,500,000 $20,000,000 $22,500,000 $25,000,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Sewer Connection Fees Sewer Connection fees decreased $895,773 (-47.82%) through the first quarter of FY2010 compared to the same period in the prior year. Overall, valuations increased 12.3% through the first quarter of FY2010.<br><br> The increase, in valuations, was a result of a 39% increase to Commercial Remodels and a 67% increase to Miscellaneous. All other material categories experienced moderate to significant valuation declines. So, despite an overall increase in valuations, Sewer Connection fees regressed due to declines noted in the other categories besides Commercial Remodels (Commercial Remodels may, or may not, require a sewer connection).<br><br> FY10 Unaudited Page 34 SELECTED ENTERPRISE FUND REVENUES CORRELATION BETWEEN SEWER CONNECTION FEES AND BUILDING PERMITS $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual 1st Quarter BUILDING PERMITS SEWER CONNECTION FEES FY10 Unaudited Page 35 SELECTED ENTERPRISE FUND REVENUES PARKING REVENUE FY06 actua FY07 actua FY08 actua FY09 actua FY10 actua FY10 budget Quarter 1 st 971,101 $ 962,377 $ 1,067,459 $ 1,250,625 $ 1,369,539 $ 2 nd 2,053,332 1,919,962 2,205,002 2,485,294 - 3 rd 3,200,555 2,994,111 3,421,322 3,989,589 - 4 th 4,229,602 4,065,238 4,575,870 5,375,386 - 5,246,000 Ratio Analysis Act/Act Act/Act Act/Act Act/Act Act/Bud 1st qtr/4th qtr 23% 24% 23% 27% 26% 2nd qtr/4th qtr 49% 47% 48% 54% 3rd qtr/4th qtr 76% 74% 75% 87% 4th qtr/4th qtr 100% 100% 100% 117% 100% Parking Revenue (Meter Fees, Fines, & Penalties) 2006-2010 Y-T-D $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 $5,000,000 $5,500,000 1 st 2 nd 3 rd 4 th Quarter FY06 actual FY07 actual FY08 actual FY09 actual FY10 actual Trend Analysis--Parking Revenue Parking revenue, through the first quarter of FY2010, increased $118,914 (9.51%) compared to the same period in the prior year. The revenue category consists of Meter fees, Fines, and Penalties. Meter Fees, Fines, and Penalties increased $9,917 (3.19%), $30,936 (4.40%), and $78,061 (32.85%)--respectively.<br><br> The overall increase can be attributed to more business and better collection efforts. Specifically, for Penalties, the large increase was due to more customers paying late which resulted in more penalties being assessed and paid. FY10 Unaudited Page 36<br><br>

less