Loading...
HomeMy WebLinkAbout2018_02_Revenue Reports2018 2 February General Fund Jefferson County Treasurer 9-Mar-2018 REVENUE NAME BARS BUDGET FEB Y-T-D Y-T-D ACTUAL FEB Y-T-D Y-T-D ACTUAL FEB Y-T-D Y-T-D *2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % Property Tax 1 311.10 7,850,027 331,893 352,740 4.5%7,643,881 309,064 325,553 4.3%7,514,257 361,999 374,048 5.0% Diverted Road Prop Tax 1 311.20 720,000 31,220 33,091 4.6%720,000 30,674 32,478 4.5%720,000 36,299 37,617 5.2% Private Harvest Tax 2 317.40.10/.20 335,000 186,243 186,243 55.6%377,824 80,745 80,745 21.4%281,335 72,085 72,085 25.6% Sales Tax 1 313.11 3,040,000 279,301 487,200 16.0%2,876,339 310,729 496,234 17.3%2,738,244 263,305 448,597 16.4% special purpose 313.15 955,428 90,853 157,846 16.5%903,099 93,242 154,403 17.1%876,170 83,521 141,546 16.2% Local Criminal Justice 1 313.71 380,070 37,607 65,650 17.3%375,219 38,326 63,660 17.0%364,508 34,675 58,973 16.2% Leasehold Excise Tax 3 317.20 62,000 13,824 13,824 22.3%69,801 13,291 13,291 19.0%55,407 15,378 15,378 27.8% Treas. Collection Fees (REET)3 341.42.31/32/33 80,000 4,369 9,070 11.3%90,727 8,537 13,734 15.1%84,213 3,278 7,332 8.7% Penalties on delinquent taxes 1 359.40.10/.20 133,332 5,074 17,140 12.9%98,944 8,043 16,263 16.4%112,239 9,362 15,125 13.5% Interest on delinquent taxes 1 361.40.10 210,000 6,627 20,897 10.0%193,625 11,573 20,382 10.5%213,458 15,490 18,597 8.7% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 572,220 - 0 0.0%1,458,645 - 0 0.0%1,476,638 - 0 0.0% P.U.D. Privilege Tax 4 335.00.91 323,420 - 0 0.0%314,148 - 0 0.0%318,107 - 0 0.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 463,500 - 108,130 23.3%435,778 - 109,769 25.2%477,057 - 128,762 27.0% Marijuana Enforcement/Excise 6 336.06.41 24,720 - 0 0.0%21,297 - 0 0.0%36,920 - 0 0.0% Liquor Excise Tax 8 336.06.94 41,536 - 10,819 26.0%44,174 - 10,241 23.2%41,772 - 9,372 22.4% Liquor Profit 6 336.06.95 90,203 - 0 0.0%84,441 - 0 0.0%84,749 - 0 0.0% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.180/0671 328,526 - 186,331 56.7%143,455 - 9,022 6.3%294,890 - 0 0.0% Investment Income 1 361.11 230,000 16,532 61,191 26.6%354,385 7,726 21,097 6.0%682,617 3,197 3,942 0.6% Treasurer Invest & Other Fees 1 341.42.15-19/50 16,290 2,782 5,034 30.9%33,805 2,438 8,139 24.1%11,599 701 1,197 10.3% DNR Timber 1 395.1.1 250,000 - 448 0.2%207,899 - 0 0.0%336,350 39,161 143,786 42.7% Transfer in 1 397.00 3,000 750 750 25.0%40,322 750 750 1.9%46,441 750 750 1.6% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 920 1,804 15.2%9,020 382 726 8.1%2,590 1,966 2,590 100.0% Assessor 1 001-010-000 8,700 1,847 1,883 21.6%10,970 1,814 1,985 18.1%8,761 1,962 2,118 24.2% Auditor-Recording Fees 1 341.21.10 72,063 4,440 10,180 14.1%74,248 5,766 12,020 16.2%74,077 4,547 9,936 13.4% Auditor-M.V. License Fees 1 341.48/336.00.93 232,703 11,600 23,051 9.9%242,031 10,222 21,064 8.7%229,927 46,069 56,666 24.6% Auditor-Other Revenue 1 26,605 2,216 4,997 18.8%29,714 2,231 5,213 17.5%32,440 3,133 5,374 16.6% Elections 1 001-021-000 146,191 18,624 53,032 36.3%138,996 - 0 0.0%160,903 532 32,647 20.3% Clerk 1 001-020-000 170,768 9,984 30,801 18.0%179,130 10,624 27,299 15.2%192,402 14,771 30,801 16.0% County Administrator 1 001-059-000 4,260 4,260 4,260 3,700 0 0 Commissioners 1 001-060-000 8,000 551 1,247 15.6%8,923 657 1,399 15.7%8,609 556 1,159 13.5% Safety & Security 1 001-067-000 64,959 3,398 15,742 24.2%66,877 9,636 9,636 14.4%70,305 13,953 15,403 21.9% Community Services 1 001-068-000 6,900 329 392 5.7%4,611 1,719 1,742 37.8%8,269 1,119 1,148 13.9% District Court 1 001-080-000 603,032 35,223 68,625 11.4%596,433 35,362 65,469 11.0%632,629 53,158 87,271 13.8% Juvenile Service 1 001-110-000 259,676 21,523 39,784 15.3%290,984 28,026 42,937 14.8%260,358 32,833 53,026 20.4% Prosecuting Attorney 1 001-150-000 178,690 11,247 18,334 10.3%151,185 47,674 54,915 36.3%124,918 17,963 24,755 19.8% Coroner 1 001-151-000 25,348 - 0 0.0%24,610 - 0 0.0%8,340 8,340 8,340 100.0% Sheriff 1 001-180-000 563,077 9,426 68,621 12.2%722,960 13,981 71,674 9.9%626,703 22,264 29,434 4.7% Superior Court 1 001-240-000 40,038 11,565 11,815 29.5%90,193 4,500 4,500 5.0%26,142 9,911 9,911 37.9% Non Departmental 1 001-270-000 50,447 - 32,802 65.0%49,196 - 10 0.0%10 10 TOTAL CURRENT EXPENSE 18,582,629 1,154,227 2,103,775 11.3%19,181,590 1,087,731 1,696,349 8.8%19,234,355 1,172,278 1,847,695 9.6% * Revenue Schedule 1 monthly , 2 Feb/May/Aug/Nov, 3 Feb/Apr/Jun/Aug/Oct/Dec , 4 Jun 5 Jan/Apr/Jul/Oct 6 Mar/Jun/Sep/Dec 7 Nov 8 Var REFUND EXPEND CY/PRIOR exclud 388/89 7,893 9,039 253,160 50 50 194,294 351 993 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2018 3 year view 3/9/2018 February 2 FUND Fund #Budget Feb YTD YTD ACTUAL Feb YTD YTD ACTUAL Feb YTD YTD 2018 2018 2018 %2017 2017 2017 %2016 2016 2016 % SPECIAL REVENUE Auditor's O & M 105 75,337 1,714 3,865 5.1%77,983 1,998 4,225 5.4%74,342 1,707 3,560 4.8% Court Facilitator 106 5,100 520 1,040 20.4%5,920 460 840 14.2%6,220 580 980 15.8% Boating Safety 107 48,740 - - 0.0%49,100 - 218 0.4%61,493 - 8,787 14.3% WSU Cooperative 108 510,294 63,151 73,079 14.3%534,494 73,380 79,390 14.9%528,605 91,262 99,301 18.8% 4-H After School 113 37,250 27,250 27,250 73.2%44,475 20,950 20,950 47.1%10,600 10,600 10,600 100.0% JeffComCap 119 119 204,000 22,058 44,116 21.6%254,838 21,409 42,630 16.7%276,062 22,899 45,798 16.6% Crime Victim's Svc 120 110,757 20,306 25,118 22.7%99,707 1,006 24,860 24.9%79,335 4,275 14,886 18.8% Grant Mgmt 123 150,000 10,846 24,222 16.1%76,723 19,911 19,911 26.0%95,126 34,621 35,817 37.7% Hotel-Motel 125 500,500 46,226 69,403 13.9%507,868 53,093 72,486 14.3%449,148 51,077 69,550 15.5% Jeff Co Public Health 127 3,956,447 390,141 812,695 20.5%4,064,163 370,041 825,512 20.3%4,076,806 502,093 1,074,509 26.4% Water Quality 128 960,714 164,754 169,318 17.6%975,455 101,950 105,100 10.8%999,219 88,402 90,411 9.0% Mental Health 130 45,150 2,939 3,061 6.8%47,474 2,270 2,366 5.0%46,854 2,745 3,346 7.1% Chem Dep Mnt Hlth tx 131 490,490 51,704 90,258 18.4%516,131 52,833 87,756 17.0%500,457 47,543 80,983 16.2% Drug Fund 135 18,288 795 1,640 9.0%11,819 1,232 2,166 18.3%23,562 1,005 2,168 9.2% Law Library 140 10,150 704 1,344 13.2%10,049 773 1,439 14.3%9,692 839 1,455 15.0% Trial Court Imprvmnt 141 25,000 5,807 5,807 23.2%23,449 5,863 5,863 25.0%22,669 5,618 5,618 24.8% Public Defense Fnd 142 35,000 - - 0.0%0 - - 0.0%36,673 - - 0.0% Community Develpmnt 143 1,663,379 193,747 250,492 15.1%1,418,569 200,444 274,805 19.4%1,668,687 198,948 276,662 16.6% Jeff Co Affrdbl Hsg 148 237,381 16,006 36,092 15.2%250,150 18,458 38,492 15.4%243,809 15,597 32,986 13.5% Treasurer's O & M 150 47,280 843 1,089 2.3%28,653 23 38 0.1%23,981 2,322 2,327 9.7% REET technology 151 14,420 1,123 2,410 16.7%16,827 1,090 2,357 14.0%16,194 953 2,243 13.8% Veteran's Relief 155 59,820 19,876 20,082 33.6%65,060 18,666 18,794 28.9%63,652 18,651 19,275 30.3% Water Pollution Cntrl 160 - - - - - - 18,607 100 200 1.1% Park & Rec 174 648,380 139,804 142,646 22.0%625,429 154,318 156,422 25.0%569,174 116,992 119,045 20.9% County Park Imprvmnt 175 131,185 - - 0.0%119,426 - - 0.0%84,284 - 36 0.0% County Roads 180 7,838,108 614,524 1,147,242 14.6%9,773,015 364,472 555,223 5.7%8,949,637 446,085 707,769 7.9% Facilities Mgmt 183 1,074,934 100,844 178,918 16.6%1,040,019 86,319 162,792 15.7%1,116,468 155,617 233,782 20.9% County Fair 199 250,000 10,288 13,829 5.5%308,594 6,402 12,983 4.2%269,769 8,585 13,210 4.9% Total Special Revenue 19,148,104 1,895,680 3,145,015 16.4%20,945,389 1,570,957 2,517,617 12.0%20,321,124 1,820,531 2,955,303 14.5% OTHER FUNDS REVENUE REPORT 2018 3 year view FUND Budget Feb YTD YTD YTD Feb YTD YTD Budget Feb YTD YTD 2018 2018 2,018 %2017 2017 2017 %2016 2016 2016 % CAPITAL IMPROVEMENT Const/Renovation 301 1,000,000 - 1,808 0.2%517,754 500,000 501,755 96.9%1,113,333 275,000 285,567 25.6% Capital Improvement 302 1,072,938 65,067 114,897 10.7%1,285,270 47,854 126,450 9.8%1,537,774 51,148 108,292 7.0% Public Infrastructure 306 451,400 47,916 83,993 18.6%477,127 48,465 80,580 16.9%456,854 43,290 73,712 16.1% Conservation Futures 308 239,400 16,368 17,743 7.4%256,431 12,298 13,045 5.1%244,237 14,326 17,528 7.2% Total CAP IMP 2,763,738 129,351 218,441 7.9%2,536,581 608,616 721,831 28.5%3,352,198 383,764 485,098 14.5% ENTERPRISE Solid Waste 401 3,357,942 258,273 496,663 14.8%3,488,829 204,653 448,819 12.9%3,481,538 294,411 511,560 14.7% Solid Waste Post Clos 402 150 59 122 81.6%516 43 77 15.0%335 21 34 10.2% Solid Waste Eqpt Res 403 4,000 917 1,900 47.5%7,601 600 1,078 14.2%302,768 169 280 0.1% Yard Waste Educ Fnd 404 5,800 8 12 0.2%5,750 2 4 0.1%1,781 3 5 0.3% Tri Area Sewer 405 226,000 943 1,759 0.8%297,554 1,184 1,491 0.5%172,740 178 291 0.2% Total ENTERPRISE 3,593,892 260,199 500,456 13.9%3,800,250 206,482 451,468 11.9%3,959,162 294,782 512,170 12.9% INTERNAL SERVICE Equipment Rental 501 2,451,202 177,612 222,715 9.1%2,508,636 163,603 242,532 9.7%2,179,575 2,692 45,201 2.1% Risk Management 502 215,000 - 0 0.0%112,770 - - 0.0%57,666 - - 0.0% Benefit Reserve 505 208,000 25,965 47,978 23.1%225,590 22,081 44,035 19.5%215,434 20,236 41,808 19.4% Information Services 506 2,103,298 76,202 484,698 23.0%1,832,926 82,529 379,634 20.7%1,551,832 219,418 347,604 22.4% Total INT SERV 4,977,500 279,779 755,392 15.2%4,679,922 268,212 666,201 14.2%4,004,508 242,346 434,613 10.9% Total 30,483,234 2,565,009 4,619,305 15.2%31,962,142 2,654,268 4,357,117 13.6%31,636,992 2,741,424 4,387,184 13.9% GENERAL FUND CASH BALANCE REPORT 3/7/2018 END OF MONTH CASH BALANCES 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 January 3,001,108$ 2,717,342$ 2,548,924$ 3,317,483$ 2,556,108$ 3,030,949$ 2,798,256$ 4,109,412$ 4,360,809$ 4,416,485$ February 2,167,401$ 1,804,045$ 1,882,264$ 3,023,683$ 1,802,345$ 2,041,248$ 2,202,079$ 3,278,685$ 3,622,756$ 3,681,133$ March 2,190,309$ 1,691,583$ 1,934,629$ 2,347,678$ 1,654,411$ 2,108,155$ 2,384,301$ 3,289,638$ 3,759,875$ April 4,090,214$ 3,764,298$ 3,819,239$ 4,144,298$ 3,732,606$ 4,429,017$ 4,572,778$ 5,181,554$ 5,391,984$ May 3,913,999$ 3,623,704$ 3,850,878$ 4,045,216$ 3,747,009$ 4,421,127$ 4,622,123$ 5,174,859$ 5,455,638$ June 3,961,669$ 3,554,636$ 4,081,060$ 3,980,389$ 4,663,469$ 4,818,824$ 5,866,387$ 6,413,636$ 6,593,259$ July 3,217,764$ 2,978,751$ 3,732,809$ 3,396,868$ 3,873,932$ 3,736,091$ 5,087,286$ 5,610,102$ 5,806,710$ August 2,548,416$ 2,117,574$ 2,974,460$ 2,394,180$ 3,010,467$ 2,898,623$ 4,203,581$ 5,416,407$ 5,111,812$ September 2,150,120$ 1,596,637$ 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ 4,724,294$ October 3,787,064$ 3,363,104$ 4,339,258$ 4,098,330$ 4,148,666$ 4,133,005$ 5,804,449$ 6,326,563$ 6,245,727$ November 3,281,183$ 3,339,559$ 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ 6,098,807$ December 3,297,287$ 3,248,681$ 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ 5,201,817$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2009 2010 2011 2012 2013 2014 2015 2016 2017 Budg ***2018 Budg *** Total Reserve $ 1,517,056 $ 1,530,071 $ 1,666,150 $ 1,708,161 $ 1,786,000 $ 2,121,257 $ 2,140,726 $ 2,308,223 $ 2,589,184 $ 2,653,611 10% GF Budgeted Expenditures $ 1,517,056 $ 1,530,071 $ 1,566,150 $ 16,081,612 $ 1,646,000 $ 1,681,257 $ 1,700,726 $ 1,806,223 $ 1,863,184 $ 1,927,611 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 ***The Required Reserve is based on 10% of the total General Fund budgeted expenditures, plus a revenue stabilization reserve. If General Fund budgeted expenditures are amended (e.g. by a Quarterly Budget Extension), or if the revenue stabilization reserve is drawn down or increased, then the Required Reserve will also change. $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 GENERAL FUND END OF MONTH CASH BALANCE 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2 February GENERAL SALES TAX RECEIPTS 3/7/2018 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End 3 yr. avg Expected Actual Over/Under Cum %projection 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2015-17 2018 2018 Expected expected Projection Over/Under January 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 6.6%200,614 207,899 $7,285 103.63%$3,150,395 $110,395February219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 279,301 10.0%305,388 279,301 -$26,087 96.28%$2,927,043 -$112,957March177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 6.8%205,802 - April 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 6.7%203,686 - May 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 8.4%256,612 - June 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 7.4%225,655 - July 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 7.7%235,089 - August 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 10.2%310,571 - September 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 8.8%268,857 - October 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 9.4%285,439 - November 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 10.0%305,512 - December 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 219,772 7.8%236,775 - TTL 2,137,279 1,918,151 1,968,790 2,047,153 2,348,673 2,300,936 2,486,611 2,738,244 2,876,339 487,200 100.0%$3,040,000 $487,200ytd 372,385 349,466 338,884 343,896 405,410 394,956 403,595 448,597 496,234 487,200 506,001 487,200 ytd change -6.15%-3.03%1.48%17.89%-2.58%2.19%11.15%10.62%-1.82%-3.72%over (under) ytd expected annual % chg.-10.25%2.64%3.98%14.73%-2.03%8.07%10.12% Special Purp./Public Safety Tax Actual Actual Actual Actual Actual Actual Actual 3 yr avg.Projection Actual20122013201420152016201720182015-17 2018 2018 Proj Actual %Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 6.69%63,886 66,993 264,500 274,892 3.9% February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 9.8%93,779 90,853 399,167 370,154 -7.3%March 40,604 56,106 49,782 50,931 62,285 61,183 6.8%65,387 - 271,189 - April 43,155 51,054 47,573 52,541 59,481 59,911 6.7%64,462 - 268,148 - May 51,908 58,324 56,012 62,613 74,233 78,716 8.5%80,820 - 337,432 - June 46,797 50,067 48,647 58,717 65,832 65,229 7.4%71,153 - 296,808 - July 49,385 68,295 54,074 56,793 69,908 73,136 7.8%74,924 - 310,013 - August 56,220 56,063 68,712 76,734 87,275 89,679 10.0%95,114 - 405,686 - September 54,902 61,455 64,622 72,022 77,854 77,534 8.9%85,262 - 354,119 - October 61,120 64,400 64,152 73,903 82,028 82,991 9.4%89,578 - 375,017 - November 60,952 64,915 71,491 77,947 89,596 90,736 10.1%96,836 - 402,348 - December 49,281 52,177 59,043 62,263 66,133 69,582 7.8%74,227 - 311,003 - TOTAL 621,440 704,453 701,993 769,039 876,170 903,099 157,846 100.0%955,428 157,846 3,995,428 645,046 ytd 121,597 117,885 124,574 141,546 154,403 $157,846 157,665 $157,846 663,667 $645,046 -2.8% 0.11%over (under) ytd expected TOTAL 2018 SALES TAX Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules. 100,000 150,000 200,000 250,000 300,000 GENERAL SALES TAX RECEIPTS 2018 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 February 2 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation TOTAL Recent 2018 2018 % Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 4 YR AVG Budget Actual Difference January 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 53,263$ 49,358$ 49,830$ 1.0% February 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 43,542$ 40,350$ 65,067$ 61.3% March 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 95,117$ 88,144$ -$ April 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 68,249$ 63,245$ -$ May 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 88,832$ 82,320$ -$ June 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 144,702$ 134,093$ -$ July 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 97,339$ 90,203$ -$ August 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 95,860$ 88,833$ -$ September 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 142,117$ 131,698$ -$ October 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 104,607$ 96,938$ -$ November 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 75,648$ 70,102$ -$ December 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 96,815$ 89,717$ -$ Total $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $114,897 1,106,090$ 1,025,000$ 114,897$ -89% YTD 133,794$ 51,195$ 123,091$ 59,180$ 46,905$ 71,020$ 81,457$ 108,292$ 126,450$ $114,897 96,805$ 89,708$ 114,897$ 28% Y/Y chg -61.74%140.44%-51.92%-20.74%51.41%14.70%32.94%16.77%-9.14% Jan 2017 1@1.565M, 6 Res>$500k Sept 2017 12>$500k Feb 2017 5 Res>$500k Oct 2017 2 sales @$1.31M and $1.445M, 6 res>$500k Mar 2017 6 Res>$500k Nov 2017 12 sales>$500k Apr 2017 1@$1.098, 1@$1.035, 6 Res>$500k Dec 2017 1 sale @ $1.529M, 11>$500k May 2017 1@$1.098, 1@$1.035, 6 Res>$500k Jan 2018 no unincorp sales>$445k Jun 2017 1@$1.05, 16>$500k Feb 2018 1@1.435M, 3 Res>$500k July 2017 6>$500k Aug 2017 1@$1.024, 1@1.37 and 11>$500k 3/9/2018 $- $50,000 $100,000 $150,000 $200,000 $250,000 2018 REET RECEIPTS 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2 February 3/9/2018 REVENUE 4 yr avg *2018 2018 % Budget 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2013-16 Budget Actual Difference January 16,089$ 10,732$ 11,507$ 12,045$ 8,863$ 13,575$ 17,051$ 18,473$ 19,394$ 23,177$ 17,123$ 20,418$ 23,177$ 13.5% February 27,998$ 21,729$ 25,532$ 23,188$ 38,274$ 30,356$ 36,141$ 51,077$ 53,093$ 45,060$ 42,667$ 50,876$ 45,060$ -11.4% March 22,623$ 9,838$ 12,406$ 7,271$ 11,203$ 12,715$ 14,345$ 14,554$ 16,889$ 14,626$ 17,440$ April 11,344$ 11,934$ 10,791$ 14,950$ 11,430$ 12,427$ 14,983$ 18,530$ 20,901$ 16,710$ 19,926$ May 19,646$ 19,561$ 25,142$ 17,142$ 18,010$ 19,151$ 23,886$ 29,462$ 45,943$ 29,611$ 35,308$ June 19,205$ 19,650$ 17,302$ 17,916$ 16,477$ 18,786$ 25,070$ 29,476$ 31,485$ 26,204$ 31,247$ July 20,155$ 14,326$ 19,311$ 20,201$ 21,512$ 24,536$ 27,711$ 33,687$ 38,400$ 31,083$ 37,064$ August 35,178$ 36,076$ 24,742$ 31,171$ 33,140$ 37,534$ 48,845$ 56,349$ 64,820$ 51,887$ 61,871$ September 41,757$ 40,208$ 42,500$ 40,882$ 39,890$ 42,349$ 44,713$ 53,487$ 56,561$ 49,278$ 58,759$ October 43,012$ 46,548$ 43,861$ 41,015$ 41,741$ 43,659$ 49,182$ 59,970$ 58,458$ 52,817$ 62,980$ November 44,351$ 43,285$ 38,547$ 36,906$ 39,146$ 46,879$ 58,967$ 57,999$ 69,054$ 58,225$ 69,428$ December 19,873$ 18,741$ 21,703$ 11,109$ 15,514$ 33,858$ 25,213$ 26,084$ 32,870$ 29,506$ 35,184$ Total 321,231$ 292,628$ 293,344$ 273,796$ 295,200$ 335,825$ 386,107$ 449,148$ 507,868$ 68,237$ 419,737$ 500,500$ 68,237$ YTD 44,087$ 32,461$ 37,039$ 35,233$ 47,137$ 43,931$ 53,191$ 69,550$ 72,486$ 68,237$ 59,790$ 71,294$ 68,237$ -4.3% $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 2018 HOTEL/MOTEL LODGING TAX -Fund 125 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018