Finance Committee Agenda and Packet 2012 04 16

Home Browse Search

685,926 44,908 70,807 36,638 8 ,704 846,983 SEPTEMBER 736,581 10,589 76,657 30,590 32,922 887,339 OCTOBER 683,343 10,892 80,537 31,630 23,903 830,304 NOVEMBER 662,050 14,960 57,204 19,381 1 ,360 754,955 DECEMBER 963,270 5,434 70,951 16,119 6 ,663 1,062,438 YTD TOTALS 8,729,032 266,455 808,852 304,674 171,095 10,280,109 YTD Variance % to Prior Year ‐3.4% N/A 24.8% 3.8% 5.1% 12.9% ‐1.9% 2009 JANUARY 758,656 48,791 60,758 19,724 775 888,705 FEBRUARY 600,069 1,388 63,535 17,638 2 ,980 685,610 MARCH 751,129 4,704 61,142 19,105 6 ,563 842,643 APRIL 711,199 5,762 58,382 19,360 1 ,770 796,473 MAY 741,994 30,426 55,443 27,549 19,352 874,764 JUNE 813,144 6,658 59,238 31,859 4 ,794 915,692 JULY 762,592 16,214 60,780 35,713 72,661 947,960 AUGUST 712,559 60,815 67,804 33,421 11,384 885,982 SEPTEMBER 762,495 11,951 107,176 24,657 6 ,847 913,127 OCTOBER 724,281 12,269 70,148 26,537 13,569 846,803 NOVEMBER 698,436 12,212 45,132 18,958 5 ,793 780,531 DECEMBER 1,004,279 2,395 69,830 15,263 5 ,053 1,096,819 YTD TOTALS 9,040,831 213,586 779,367 289,785 151,541 10,475,109 YTD Variance % to Prior Year ‐3.4% N/A ‐81.8% 1.1% ‐21.5% 95.7% ‐10.8% 2008 JANUARY 730,950 105,673 87,383 23,458 ‐947,464 FEBRUARY 660,361 92,179 70,790 21,905 1,647 846,882 MARCH 775,718 101,749 65,121 25,070 352 968,009 APRIL 744,665 70,362 59,901 28,708 1,764 905,401 MAY 800,688 211,052 60,865 38,175 ‐1,110,779 JUNE 850,363 82,263 68,532 34,670 10,135 1,045,962 JULY 801,783 68,083 62,419 44,827 45,841 1,022,954 AUGUST 752,023 75,925 61,928 47,973 ‐937,850 SEPTEMBER 814,631 70,781 58,503 32,702 11,592 988,209 OCTOBER 702,582 116,127 69,428 33,876 205 922,217 NOVEMBER 698,913 60,471 46,626 20,722 4,462 831,195 DECEMBER 1,026,800 118,297 59,122 16,933 1,421 1,222,572 YTD TOTALS 9,359,476 1,172,961 770,620 369,019 77,419 11,749,495 Variance % to Prior Yr. ‐0.4% N/A 146.2% ‐20.0% 3.5% ‐17.1% 4.1% 2007 JANUARY 750,177 3,934 65,977 23,949 708 844,745 FEBRUARY 619,863 27,690 78,317 19,814 1,274 746,958 MARCH 813,871 15,713 78,750 22,782 869 931,985 APRIL 701,755 43,682 85,333 25,638 2,497 858,906 MAY 772,235 87,603 89,446 33,915 5,128 988,327 JUNE 946,277 165,677 88,126 39,628 21,482 1,261,189 JULY 769,616 (84,100) 85,424 40,351 13,918 825,208 AUGUST 686,846 52,503 85,960 38,956 27,962 892,228 SEPTEMBER 858,798 14,254 75,117 33,754 16,376 998,299 OCTOBER 753,474 48,080 93,304 35,773 81 930,713 NOVEMBER 757,518 95,159 69,508 23,845 3,102 949,131 DECEMBER 964,177 6,283 68,199 18,295 ‐1,056,954 YTD TOTALS 9,394,606 476,477 963,462 356,701 93,396 11,284,643 Variance % to Prior Yr. 2.8% N/A 212.4% 9.4% 8.1% ‐0.4% 6.5% CITY OF LOUISVILLE Revenue History 2007 through 2012 35 2007 2008 2009 2010 2011 2012 % Of AREA NAME Actual Actual Actual Actual Actual Actual Total Interchange 286,360 280,656 253,167 187,312 189,806 205,830 31.3% Outside City 121,239 160,974 113,556 177,064 148,930 184,134 28.0% Louisville Plaza 91,844 93,303 97,292 106,353 117,811 112,589 17.1% McCaslin North 32,459 35,605 42,789 39,348 45,619 52,458 8.0% Downtown 25,834 28,117 31,575 33,678 39,674 47,231 7.2% Centennial Valley 294 260 168 117 150 5,460 0.8% Hwy 42 South 10,040 10,571 14,851 12,969 12,672 13,919 2.1% CTC 11,307 10,025 8,615 11,149 12,444 11,791 1.8% S Boulder Rd 25,047 24,082 25,298 24,050 9,178 9,430 1.4% Hwy 42 North 7,205 10,145 7,352 5,054 5,978 5,063 0.8% Pine Street 3,831 3,401 2,813 3,968 4,981 6,098 0.9% S Suburban 4,606 3,334 2,259 2,220 2,390 2,349 0.4% Residential 49 195 335 250 226 250 0.0% Totals 620,115 660,668 600,069 603,533 589,859 656,603 % Of Change ‐5.3% 6.5% ‐9.2% 0.6% ‐2.3% 11.3% Monthly Revenue Comparisons by Area (February 2012) 500,000 600,000 700,000 Monthly Comparison by Area to Prior Years February 2012 Totals Interchange 0 100,000 200,000 300,000 400,000 2007 2008 2009 2010 2011 2012 Louisville Plaza All Other In‐City Outside City 0 50,000 100,000 150,000 200,000 250,000 Monthly Comparison to February 2011 2012 2011 36 2007 2008 2009 2010 2011 2012 % Of AREA NAME Actual Actual Actual Actual Actual Actual Total Grocery 122,132 124,572 132,826 143,470 132,238 141,072 21.5% Food/Beverage 89,985 92,385 100,699 96,566 113,188 126,809 19.3% Building Materials 68,655 71,276 63,041 60,706 59,933 65,342 10.0% Communications/Utilities 97,670 132,516 89,208 124,717 93,478 121,552 18.5% Services 34,125 36,166 41,238 40,386 46,775 57,912 8.8% General Merchandise 130,524 134,852 127,983 61,351 62,318 55,230 8.4% Manufacturing 5,414 6,222 4,239 23,342 24,750 27,411 4.2% Miscellaneous Retail 34,746 23,773 14,831 15,102 19,190 20,492 3.1% Finance/Leasing 9,981 12,439 9,915 14,136 12,715 13,162 2.0% Furniture 8,335 6,802 5,337 9,102 8,606 12,130 1.8% Wholesale 7,690 6,922 5,794 6,999 8,894 7,425 1.1% Apparel 811 939 1,172 2,181 2,277 3,072 0.5% Automotive 8,723 10,075 1,537 4,153 3,790 3,705 0.6% Construction 265 631 47 109 639 121 0.0% Agriculture 1,061 1,100 2,202 1,212 1,068 1,167 0.2% Totals 620,115 660,668 600,069 603,533 589,859 656,603 % Of Change ‐5.3% 6.5% ‐9.2% 0.6% ‐2.3% 11.3% Monthly Revenue Comparisons by Industry (February 2012) 140,000 160,000 Monthly Comparison by Industry to Prior Years February 2012 Communications/Utilities Grocery ‐20,000 40,000 60,000 80,000 100,000 120,000 2007 2008 2009 2010 2011 2012 Food/Beverage All Other Building Materials Services General Merchandise ‐20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 Monthly Comparison to February 2011 2012 2011 37 Mnthly Y‐T‐D Mnthly Y‐T‐D Month 2008 2009 2010 2011 2012 2012 % Of % Of % Of % Of Of Sale Actual Actual Actual Actual Budget Actual 2011 2011 Bdgt Bdgt Jan 730,950 759,431 654,777 636,994 682,059 681,326 107.0% 107.0% 99.9% 99.9% Feb 661,989 603,049 613,160 592,370 612,922 658,227 111.1% 109.0% 107.4% 103.4% Mar 776,070 757,692 777,711 778,075 754,816 0.0% 66.7% 0.0% 65.4% Apr 746,429 712,968 733,959 727,061 705,161 0.0% 49.0% 0.0% 48.6% May 800,688 751,562 737,768 738,711 748,630 0.0% 38.6% 0.0% 38.2% Jun 850,363 817,334 821,825 881,992 826,595 0.0% 30.8% 0.0% 30.9% Jul 847,624 764,058 720,871 738,194 746,826 0.0% 26.3% 0.0% 26.4% Aug 752,023 722,772 688,670 740,614 714,493 0.0% 23.0% 0.0% 23.1% Sep 826,223 766,080 757,807 797,496 775,372 0.0% 20.2% 0.0% 20.4% Oct 702,786 737,373 703,168 720,320 717,539 0.0% 18.2% 0.0% 18.4% Nov 703,376 703,728 663,138 751,407 710,409 0.0% 16.5% 0.0% 16.8% Dec 1,028,220 1,010,001 969,155 1,003,547 937,249 0.0% 14.7% 0.0% 15.0% Totals 9,426,741 9,106,047 8,842,010 9,106,781 8,932,070 1,339,553 % Of Change ‐0.6% ‐3.4% ‐2.9% 3.0% ‐1.9% Mnthly Y‐T‐D Mnthly Y‐T‐D Month 2008 2009 2010 2011 2012 2012 % Of % Of % Of % Of Of Sale Actual Actual Actual Actual Budget Actual 2011 2011 Bdgt Bdgt Jan 23,458 1 9,724 1 5,093 18,884 21,005 21,299 112.8% 112.8% 101.4% 101.4% Feb 21,905 1 7,638 1 5,512 18,361 20,670 21,356 116.3% 114.5% 103.3% 102.4% Mar 25,070 1 9,105 1 9,765 20,385 22,523 0.0% 74.0% 0.0% 66.4% Apr 28,708 1 9,360 1 9,502 22,368 23,605 0.0% 53.3% 0.0% 48.6% May 38,175 3 3,689 2 9,180 35,261 35,331 0.0% 37.0% 0.0% 34.6% Jun 34,670 3 1,859 3 4,186 35,938 36,348 0.0% 28.2% 0.0% 26.7% Jul 44,827 3 5,713 3 7,078 38,443 39,823 0.0% 22.5% 0.0% 21.4% City of Louisville, Colorado Total Sales Tax Revenue 2008 ‐2012 2008 ‐2012 City of Louisville, Colorado Lodging Tax Revenue Aug 47,973 3 3,421 3 6,638 40,498 39,710 0.0% 18.5% 0.0% 17.8% Sep 32,702 2 6,645 3 0,590 32,129 31,790 0.0% 16.3% 0.0% 15.8% Oct 33,876 2 6,537 3 1,630 31,123 32,582 0.0% 14.5% 0.0% 14.1% Nov 20,722 1 8,958 1 9,381 23,399 23,018 0.0% 13.5% 0.0% 13.1% Dec 16,933 1 5,263 1 6,119 18,685 18,784 0.0% 12.7% 0.0% 12.4% Totals 369,019 297,913 304,674 335,474 345,190 42,656 % Of Change 3.5% ‐19.3% 2.3% 10.1% 2.9% Mnthly Y‐T‐D Mnthly Y‐T‐D Month 2008 2009 2010 2011 2012 2012 % Of % Of % Of % Of Of Sale Actual Actual Actual Actual Budget Actual 2011 2011 Bdgt Bdgt Jan 87,383 6 0,758 6 6,070 64,708 74,583 70,085 108.3% 108.3% 94.0% 94.0% Feb 70,790 6 3,535 6 1,173 56,736 73,279 81,880 144.3% 125.1% 111.7% 102.8% Mar 65,121 6 1,142 6 2,819 77,130 79,071 0.0% 76.5% 0.0% 67.0% Apr 59,901 5 8,382 6 2,576 72,171 70,749 0.0% 56.1% 0.0% 51.0% May 60,865 5 5,443 6 4,894 73,741 71,688 0.0% 44.1% 0.0% 41.1% Jun 68,532 5 9,238 6 5,663 87,068 78,383 0.0% 35.2% 0.0% 33.9% Jul 62,419 6 0,780 6 9,503 69,746 76,338 0.0% 30.3% 0.0% 29.0% Aug 61,928 6 7,804 7 0,807 87,377 83,084 0.0% 25.8% 0.0% 25.0% Sep 58,503 107,176 7 6,657 74,646 90,357 0.0% 22.9% 0.0% 21.8% Oct 69,428 7 0,148 8 0,537 89,734 86,698 0.0% 20.2% 0.0% 19.4% Nov 46,626 4 5,132 5 7,204 76,039 69,962 0.0% 18.3% 0.0% 17.8% Dec 59,122 6 9,830 7 0,951 69,956 68,549 0.0% 16.9% 0.0% 16.5% Totals 770,620 779,367 808,853 899,051 922,740 151,965 % Of Change ‐20.0% 1.1% 3.8% 11.2% 2.6% 2008 ‐2012 City of Louisville, Colorado Auto Use Tax Revenue Actual G/L amounts may vary 38 Mnthly Y‐T‐D Mnthly Y‐T‐D Month 2008 2009 2010 2011 2012 2012 % Of % Of % Of % Of Of Sale Actual Actual Actual Actual Budget Actual 2011 2011 Bdgt Bdgt Jan 18,290 4 8,791 4,958 24,333 43,703 27,928 114.8% 114.8% 63.9% 63.9% Feb 21,389 1,388 1 9,291 45,823 39,721 40,696 88.8% 97.8% 102.5% 82.3% Mar 36,628 4,704 4 5,287 15,941 36,422 0.0% 79.7% 0.0% 57.3% Apr 10,461 5,762 1 6,038 45,812 42,170 0.0% 52.0% 0.0% 42.4% May 150,187 3 0,426 4 8,555 38,312 92,603 0.0% 40.3% 0.0% 27.0% Jun 13,731 6,658 1 0,210 50,480 58,892 0.0% 31.1% 0.0% 21.9% Jul 5,664 1 6,214 3 5,333 83,345 47,927 0.0% 22.6% 0.0% 19.0% Aug 13,997 6 0,815 4 4,908 91,563 77,843 0.0% 17.3% 0.0% 15.6% Sep 12,283 1 1,951 1 0,589 92,181 63,701 0.0% 14.1% 0.0% 13.6% Oct 46,698 1 2,269 1 0,892 96,533 58,360 0.0% 11.7% 0.0% 12.2% Nov 13,844 1 2,212 1 4,960 65,564 50,380 0.0% 10.6% 0.0% 11.2% Dec 55,025 2,395 5,434 85,218 56,899 0.0% 9.3% 0.0% 10.3% Totals 398,197 213,585 266,455 735,105 668,620 68,624 % Of Change ‐16.4% ‐46.4% 24.8% 175.9% ‐9.0% Mnthly Y‐T‐D Mnthly Y‐T‐D Month 2008 2009 2010 2011 2012 2012 % Of % Of % Of % Of Of Sale Actual Actual Actual Actual Budget Actual 2011 2011 Bdgt Bdgt Jan 11,262 10,479 32,851 291.7% 291.7% 313.5% 313.5% Feb 5,900 5,490 52,354 887.4% 496.5% 953.7% 533.6% Mar 45,119 41,980 0.0% 136.8% 0.0% 147.0% Apr 15,521 14,441 0.0% 109.5% 0.0% 117.7% 2008 ‐2012 City of Louisville, Colorado City of Louisville, Colorado Consumer Use Tax Revenue Building Use Tax Revenue 2008 ‐2012 May 15,403 14,331 0.0% 91.4% 0.0% 98.3% Jun 32,373 30,121 0.0% 67.9% 0.0% 72.9% Jul 19,392 18,043 0.0% 58.8% 0.0% 63.2% Aug 22,640 21,065 0.0% 50.8% 0.0% 54.6% Sep 43,390 40,371 0.0% 40.4% 0.0% 43.4% Oct 35,381 32,920 0.0% 34.6% 0.0% 37.2% Nov 27,461 25,550 0.0% 31.1% 0.0% 33.4% Dec 263,544 245,210 0.0% 15.9% 0.0% 17.0% Totals ‐‐‐537,385 500,000 85,205 % Of Change ‐7.0% Actual G/L amounts may vary 39 COUNCIL COMMUNICATION TO: MAYOR AND CITY COUNCIL FROM: MALCOLM FLEMING, CITY MANAGER DATE: APRIL 16, 2012 SUBJECT: FINANCIAL STATEMENTS FOR THE PERIOD ENDING MAR 31, 2012 SUMMARY: The accompanying statements are for the three months (25.0%) ending March 31, 2012. The 2011 revenue and expenses included in these statements are unaudited. The 2011 revenues and expenditures included in the attached statements are subject to audit. Audit fieldwork will be conducted during the two-week period, April 23rd – May 4th 2012. General Fund Through March 31st, General Fund expenditures exceed revenues by $93,267. Total revenue is 21.5% of annual budget and expenditures is 19.3%. Conservation Trust – Land Acquisition Fund Through March 31st, expenditures exceed revenues by $28,121. Total revenue is 15.5% of annual budget and expenditures is 13.1%. Capital Projects Fund Through March 31st, revenues exceed expenditures by $325,113. Total revenue is 8.7% of annual budget and expenditures is 5.1%. Water Utility Fund Through March 31st, revenues exceed expenses by $191,600. Total revenue is 18.6% of annual budget and expenses is 15.2%. Wastewater Utility Fund Through March 31st, revenues exceed expenses by $243,996. Total revenue is 23.9% of annual budget and expenses is 11.6%. SUBJECT FINAN CIAL STATE MENT S FOR THE AGENDA ITEM PERIOD ENDING MARCH 31, 2012 40 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Property Taxes 2,184,463 2,275,222 2,287,333 651,766 2,236,100 675,446 30.2% Sales Tax 5,189,855 5,024,678 5,184,297 700,662 5,017,090 764,075 15.2% Use Tax-Consumer/Auto /Bldg 751,584 787,353 1,088,385 113,902 1,057,840 178,967 16.9% Other Taxes 1,437,139 1,480,882 1,506,094 158,252 1,519,970 150,521 9.9% Licenses & Permits 498,038 620,813 818,888 166,577 762,520 246,937 32.4% Intergovernmental Revenue 836,990 933,521 1,062,503 360,509 1,061,230 355,817 33.5% Charges for Services 1,538,238 1,731,229 1,774,496 458,454 1,675,960 467,607 27.9% Fines & Forfeitures 239,895 264,006 235,246 66,037 267,970 55,170 20.6% Miscellaneous Revenue 403,994 402,081 358,471 81,921 294,360 91,350 31.0% Interfund Transfers 64,000 64,000 64,000 16,000 64,000 16,000 25.0% Total Revenue & Other Sources 13,144,198 13,583,786 14,379,715 2,774,081 13,957,040 3,001,890 21.5% % of Prior Year 103.3% 105.9% 20.4% 97.1% 108.2% Expenditures Central Charges 278,919 285,850 306,375 175,715 256,290 110,311 43.0% Legislative 363,621 304,205 332,065 86,549 366,040 148,511 40.6% City Manager 603,537 509,862 535,650 105,742 589,630 136,177 23.1% City Attorney 169,867 184,486 152,638 14,086 150,000 17,191 11.5% City Clerk 155,822 180,964 152,341 27,117 210,460 33,348 15.8% Human Resources 273,089 256,545 289,845 47,868 292,870 71,581 24.4% Information Technology 164,753 211,711 197,213 31,996 219,350 45,883 20.9% Finance 400,688 376,939 308,272 71,732 326,330 79,290 24.3% Police 3,945,723 3,829,257 3,993,738 738,203 4,155,990 879,991 21.2% Public Works 2,774,586 2,559,513 2,566,890 472,060 2,751,180 591,768 21.5% Planning 755,699 757,083 722,347 141,832 991,340 203,153 20.5% Library/Museum 1,052,295 1,155,004 1,198,414 245,655 1,295,650 288,040 22.2% Recreation & Senior Services 1,808,489 1,674,270 1,748,659 348,895 1,838,790 381,311 20.7% Parks & Open Space 590,287 527,194 561,250 87,984 566,820 93,791 16.5% Interfund Transfers 66,190 73,840 82,570 20,642 2,059,250 14,813 0.7% Total Expenditures & Other Uses 13,403,564 12,886,725 13,148,266 2,616,077 16,069,990 3,095,156 19.3% % of Prior Year 96.1% 102.0% 20.3% 122.2% 118.3% Revenue Over/(Under) Expend's (259,367) 697,060 1,231,448 158,004 (2,112,950) (93,267) Beginning Fund Balance 4,663,694 4,404,328 5,101,388 5,101,388 6,332,836 6,332,836 Ending Fund Balance 4,404,328 5,101,388 6,332,836 5,259,392 4,219,886 6,239,570 % of Change from Prior Year 15.8% 24.1% -33.4% 18.6% City of Louisville, Colorado General Fund Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 2012 41 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Property Tax 23,529 49,106 43,310 5,777 57,270 11,585 20.2% Grant Revenue --Interest Earnings 279 768 (50) 31 500 24 4.9% Total Revenue & Other Sources 23,808 49,874 43,260 5,808 5 7,770 11,609 20.1% % of Prior Year 209.5% 86.7% 11.6% 133.5% 199.9% Expenditures Professional Services 25 59 74 26 20 1 3.6% Support Services -City of Louisville -69,700 41,626 -63,750 -0.0% Total Expenditures & Other Uses 25 69,759 41,700 26 6 3,770 1 0.0% % of Prior Year 279037.0% 59.8% 0.0% 152.9% 2.8% Revenue Over/(Under) Expend's 23,783 (19,885) 1,560 5,782 (6,000) 11,609 Beginning Fund Balance (1) 23,782 3,896 3,896 5,457 5,457 Ending Fund Balance 23,782 3,896 5,457 9,679 (543) 17,065 % of Change from Prior Year -83.6% 40.0% -110.0% 76.3% 2012 City of Louisville, Colorado Urban Renewal Fund Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 42 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Technical Grant --PEG Funds 13,586 33,559 25,625 -26,000 -0.0% Interest Earnings 341 321 282 138 300 80 26.6% Total Revenue & Other Sources 13,928 33,881 25,908 138 26,300 80 0.3% % of Prior Year 243.3% 76.5% 0.4% 101.5% 57.7% Expenditures Technical Grant Expenses 8,050 10,000 -PEG Funds -CCTV 3,360 20,213 12,813 -13,000 0 0.0% PEG Funds -Capital Outlay City -1,341 14,265 -13,000 -0.0% Investment Fees 12 21 2 20 2 8.7% Total Expenditures & Other Uses 11,410 31,566 27,098 2 26,020 2 0.0% % of Prior Year 276.6% 85.8% 0.0% 96.0% 76.4% Revenue Over/(Under) Expend's 2,518 2,315 (1,191) 136 280 78 Beginning Fund Balance 19,521 22,039 24,354 24,354 23,163 23,163 Ending Fund Balance 22,039 24,354 23,163 24,489 23,443 23,241 % of Change from Prior Year 10.5% -4.9% 1.2% -5.1% 2012 City of Louisville, Colorado Public Access Television Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 43 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Charges for Services 32,400 -Interest Earnings (166) (5) -(0) --Interfund Transfer 149,220 -Total Revenue & Other Sources 1 81,454 ( 5) -(0) --% of Prior Year 0.0% 0.0% 4.8% 0.0% Expenditures Land Acquisitions 82,638 -----Total Expenditures & Other Uses 8 2,638 -----% of Prior Year 0.0% Revenue Over/(Under) Expend's 98,816 (5) -(0) --Beginning Fund Balance (98,862) (45) (50) (50) (50) (50) Ending Fund Balance ( 45) ( 50) (50) (51) ( 50) (49) % of Change from Prior Year 11.4% 0.0% 0.0% -2.5% 2012 City of Louisville, Colorado Parking Improvement Fund Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 44 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Interest Earnings 13,359 8,819 5,647 3,599 8,000 1,842 23.0% Developer Contributions Total Revenue & Other Sources 1 3,359 8,819 5,647 3,599 8 ,000 1,842 23.0% % of Prior Year 66.0% 64.0% 40.8% 141.7% 51.2% Expenditures Investment Fees -380 483 60 500 45 9.0% Interfund Transfers 14,370 -146,580 -0.0% Total Expenditures & Other Uses -380 14,853 60 1 47,080 45 0.0% % of Prior Year 3906.1% 15.7% 990.2% 74.9% Revenue Over/(Under) Expend's 13,359 8,439 (9,206) 3,539 (139,080) 1,797 Beginning Fund Balance 699,129 712,488 720,927 720,927 711,720 711,720 Ending Fund Balance 7 12,488 720,927 711,720 724,466 5 72,640 713,518 % of Change from Prior Year 1.2% -1.3% -19.5% -1.5% 2012 City of Louisville, Colorado McCaslin Interchange Improvement Fund Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 45 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Sales Tax 975,854 948,069 982,385 131,375 957,550 143,264 15.0% Use Tax-Consumer/Auto /Bldg 110,402 119,505 258,076 24,044 249,260 44,467 17.8% Miscellaneous 2,691 6,865 625 625 1,000 -0.0% Grant Revenues -27,655 51,224 5,000 52,950 -0.0% Interest Earnings 140,439 97,011 60,660 38,653 80,000 20,051 25.1% Land Dedication Fee --Sale of Assets 389,934 -Total Revenue & Other Sources 1,619,321 1,199,104 1,352,969 199,696 1,340,760 207,783 15.5% % of Prior Year 74.0% 112.8% 16.7% 99.1% 104.0% Expenditures Legal Administration 1,045,468 954,635 1,029,223 154,187 1,164,460 193,462 16.6% Capital 262,586 276,148 201,256 11,781 637,130 42,442 6.7% Total Expenditures & Other Uses 1,308,055 1,230,782 1,230,479 165,967 1,801,590 235,904 13.1% % of Prior Year 94.1% 100.0% 13.5% 146.4% 142.1% Revenue Over/(Under) Expend's 311,266 (31,678) 122,490 33,729 (460,830) (28,121) Beginning Fund Balance 7,467,701 7,778,967 7,747,289 7,747,289 7,869,779 7,869,779 Ending Fund Balance 7,778,967 7,747,289 7,869,779 7,781,018 7,408,949 7,841,658 % of Change from Prior Year -0.4% 1.6% -5.9% 0.8% 2012 City of Louisville, Colorado Conservation Trust -Land Acquisition Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 46 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue State Lottery 177,167 167,832 171,623 49,492 169,410 42,802 25.3% Interest Earnings 9,785 5,453 3,299 2,206 5,000 1,360 27.2% Miscellaneous Revenue -180 Total Revenue & Other Sources 186,952 173,464 1 74,923 51,698 174,410 44,162 25.3% % of Prior Year 92.8% 100.8% 29.8% 99.7% 85.4% Expenditures Professional Services -270 317 37 300 34 11.2% Capital 200,803 247,100 91,186 43,100 205,180 2,708 1.3% Total Expenditures & Other Uses 200,803 247,370 91,502 43,137 205,480 2 ,741 1.3% % of Prior Year 123.2% 37.0% 17.4% 224.6% 6.4% Revenue Over/(Under) Expend's (13,851) (73,905) 83,420 8,561 (31,070) 41,420 Beginning Fund Balance 524,397 510,546 436,641 436,641 520,061 520,061 Ending Fund Balance 510,546 436,641 5 20,061 4 45,201 488,991 561,481 % of Change from Prior Year -14.5% 19.1% -6.0% 26.1% 2012 City of Louisville, Colorado Conservation Trust -Lottery Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 47 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Burial Permits --Burial Permits -Restricted 25,017 16,812 21,733 7,484 24,960 6,404 25.7% Interest Earnings (1,578) 4,147 2,861 1,769 5,000 945 18.9% Total Revenue & Other Sources 23,438 20,959 24,594 9,253 29,960 7,349 24.5% % of Prior Year 89.4% 117.3% 44.1% 121.8% 79.4% Expenditures Professional Services 180 241 29 250 23 9.3% Capital --Interfund Transfers 304,730 4,147 2,953 1,750 5,000 1,250 25.0% Total Expenditures & Other Uses 304,730 4,327 3,193 1,779 5,250 1,273 24.3% % of Prior Year 1.4% 73.8% 41.1% 164.4% 71.6% Revenue Over/(Under) Expend's (281,292) 16,632 21,401 7,473 24,710 6,076 Beginning Fund Balance 613,857 332,565 349,198 349,198 370,598 370,598 Ending Fund Balance 332,565 349,198 370,598 3 56,671 3 95,308 376,674 % of Change from Prior Year 5.0% 6.1% 6.7% 5.6% 2012 City of Louisville, Colorado Cemetery Perpetual Care Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 48 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Burial Permits 25,017 16,812 21,733 7,484 24,960 6,404 25.7% Burial Fees 42,626 9,604 27,500 6,772 24.6% Miscellaneous Revenue 9,346 702 405 217 500 157 31.3% Transfer from General Fund 66,190 73,840 82,570 20,642 59,250 14,813 25.0% Transfer from Cemetery Perp. Care 304,730 4,147 2,953 1,750 5,000 1,250 25.0% Total Revenue & Other Sources 405,283 95,501 150,286 39,697 117,210 29,395 25.1% % of Prior Year 23.6% 157.4% 41.6% 78.0% 74.0% Expenditures Administration 85,805 91,440 110,013 18,777 100,210 17,523 17.5% Capital 247,729 51,945 14,116 1,101 17,000 -0.0% Total Expenditures & Other Uses 333,534 143,385 124,129 19,878 117,210 17,523 15.0% % of Prior Year 43.0% 86.6% 13.9% 94.4% 88.2% Revenue Over/(Under) Expend's 71,749 (47,884) 26,157 19,819 -11,872 Beginning Fund Balance -71,749 23,865 23,865 50,022 50,022 Ending Fund Balance 71,749 23,865 50,022 43,684 50,022 61,894 % of Change from Prior Year -66.7% 109.6% 0.0% 41.7% 2012 City of Louisville, Colorado Cemetery Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 49 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Sales Tax 324,042 315,440 327,409 43,775 318,590 47,755 15.0% Use Tax-Consumer/Auto /Bldg 77,268 8,007 70,250 14,823 21.1% Grant Revenue 8,775 Miscellaneous 19 60 -Interest Earnings 8,418 5,847 5,335 3,049 8,000 2,131 26.6% Total Revenue & Other Sources 332,479 321,347 418,787 54,830 396,840 64,709 16.3% % of Prior Year 96.7% 130.3% 17.1% 94.8% 118.0% Expenditures Administration 8,884 44,606 89,092 18,916 129,050 10,146 7.9% Contributions -16,017 57,810 4,328 317,160 1,618 0.5% Acquisitions --59,573 -90,000 -0.0% Contingency ----121,800 -0.0% Total Expenditures & Other Uses 8,884 60,623 206,475 23,244 658,010 11,764 1.8% % of Prior Year 682.4% 340.6% 38.3% 318.7% 50.6% Revenue Over/(Under) Expend's 323,596 260,724 212,313 31,586 (261,170) 52,945 Beginning Fund Balance -323,596 584,319 584,319 796,632 796,632 Ending Fund Balance 323,596 584,319 796,632 6 15,906 535,462 849,577 % of Change from Prior Year 80.6% 36.3% -32.8% 37.9% City of Louisville, Colorado Historical Preservation Fund Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 2012 50 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Sales Tax 2,597,516 2,512,339 2,592,152 350,333 2,508,550 382,037 15.2% Use Tax -Consumer/Bldg 102,050 142,247 761,144 77,375 604,130 176,772 29.3% Grant Revenue 1,748,376 1,535,697 124,308 34,245 586,320 -0.0% Miscellaneous Revenue 74,400 156,005 56,989 19,668 49,440 13,695 27.7% Intergovernmental Revenue 290,000 Interfund Transfers 896,000 156,300 108,830 -2,845,580 -0.0% Total Revenue & Other Sources 5,418,342 4,792,588 3,643,423 481,620 6,594,020 572,505 8.7% % of Prior Year 88.5% 76.0% 10.0% 181.0% 118.9% Expenditures General Government 563,856 513,923 712,151 81,952 782,660 112,064 14.3% Debt 451,488 449,938 448,088 -449,930 -0.0% Public Works Capital 3,984,675 3,214,876 1,317,706 8,098 2,753,400 72,260 2.6% Parks and Rec Capital 1,271,074 544,452 217,393 10,593 498,420 18,559 3.7% Interfund Transfers 349,220 200,000 799,517 42,500 403,000 44,509 11.0% Total Expenditures & Other Uses 6,620,313 4,923,189 3,494,854 143,143 4,887,410 247,391 5.1% % of Prior Year 74.4% 71.0% 2.9% 139.8% 172.8% Revenue Over/(Under) Expend's (1,201,971) (130,601) 148,568 338,477 1,706,610 325,113 Beginning Fund Balance 4,286,295 3,084,324 2,953,723 2,953,723 3,102,292 3,102,292 Ending Fund Balance 3,084,324 2,953,723 3,102,292 3,292,201 4,808,902 3,427,405 % of Change from Prior Year -4.2% 5.0% 55.0% 4.1% 2012 City of Louisville, Colorado Capital Projects Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 51 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Impact Fee -Transportation 26,295 23,720 125,353 8,765 84,680 19,970 23.6% Impact Fee -Muni Govt 10,995 9,563 52,830 3,665 34,140 22,320 65.4% Impact Fee -Police Facility --Impact Fee -Library 11,535 9,997 54,354 3,845 35,690 19,083 53.5% Impact Fee -Parks and Trails 48,000 41,600 226,176 16,000 148,510 98,154 66.1% Impact Fee -Recreation 3,000 2,600 14,136 1,000 9,280 49,518 533.6% Interest Earnings 14,856 3,540 2,621 1,769 5,000 2,234 44.7% Total Revenue & Other Sources 1 14,681 91,021 475,470 35,044 317,300 211,279 66.6% % of Prior Year 79.4% 522.4% 38.5% 66.7% 602.9% Expenditures Professional Services 243 331 29 250 55 22.0% Interfund Transfers 796,000 156,300 94,460 -399,000 -0.0% Total Expenditures & Other Uses 7 96,000 156,543 94,791 29 399,250 55 0.0% % of Prior Year 19.7% 60.6% 0.0% 421.2% 189.6% Revenue Over/(Under) Expend's (681,319) (65,522) 380,679 35,015 (81,950) 211,224 Beginning Fund Balance 1,074,837 393,518 327,996 327,996 708,675 708,675 Ending Fund Balance 3 93,518 327,996 708,675 363,010 626,725 919,899 % of Change from Prior Year -16.7% 116.1% -11.6% 153.4% 2012 City of Louisville, Colorado Impact Fee Fund Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 52 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue Miscellaneous Revenue 4,887 1,277 814 519 -267 Interfund Transfers --Total Revenue & Other Sources 4,887 1,277 814 519 -267 % of Prior Year 26.1% 63.7% 40.6% 0.0% 51.5% Expenditures Professional Services 55 70 9 -7 Library Construction 9,129 5,087 Library Technology --Interfund Transfers --Total Expenditures & Other Uses 9,129 5,142 70 9 -7 % of Prior Year 56.3% 1.4% 0.2% 0.0% 75.7% Revenue Over/(Under) Expend's (4,242) (3,865) 744 510 -261 Beginning Fund Balance 111,976 107,734 103,869 103,869 104,613 104,613 Ending Fund Balance 107,734 103,869 104,613 104,379 104,613 104,874 % of Change from Prior Year -3.6% 0.7% 0.0% 0.5% 2012 City of Louisville, Colorado Library Construction Fund Revenue, Expenditures, & Changes to Fund Balance March 31, 2012 53 2009 2010 2011 2011 Current YTD % of Actual Actual Actual YTD Actual Budget Actual Budget Revenue User Fees and Related Charges 3,774,437 3,875,918 4,326,438 425,501 4,617,360 413,419 9.0% Water Tap Fees 435,140 419,600 1,844,536 144,840 1,497,970 719,372 48.0% Interest Earnings 102,348 35,709 12,187 9,780 25,000 9,903 39.6% Miscellaneous Revenue 15,794 60,642 45,708 1,890 36,500 5,380 14.7% Total Revenue & Other Sources 4,327,720 4,391,869 6,228,869 582,010 6,176,830 1,148,074 18.6% % of Prior Year 101.5% 141.8% 13.3% 99.2% 197.3% Expenditures General Govt 470,454 467,644 489,107 170,584 536,490 153,612 28.6% Finance 122,331 122,049 71,178 15,231 75,740 18,167 24.0% Plant Operations 1,278,438 1,197,102 1,288,121 212,513 1,395,910 261,578 18.7% Raw Water 536,269 563,575 692,413 190,554 648,900 204,064 31.4% Distribution and Collection 401,833 421,730 314,967 60,156 347,340 85,301 24.6% General Govt -Debt 1,639,371 1,636,637 1,639,890 162,323 1,545,700 162,595 10.5% Public Works -Capital Replacement 285,648 1,518,061 90,954 14,042 726,100 7,791 1.1% Public Works -Capital New 169,178 76,373 1,194,962