Loading...
HomeMy WebLinkAbout2017-08_BC_Revenue Reports2017 BARS General Fund 6-Sep-17 Jefferson County Treasurer REVENUE NAME BUDGET AUG Y-T-D Y-T-D ACTUAL AUG Y-T-D Y-T-D ACTUAL AUG Y-T-D Y-T-D *2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % Property Tax 1 311.10 7,696,105 50,727 4,423,830 57.5%7,514,257 48,525 4,350,081 57.9%7,388,068 33,519 4,261,692 57.7% Diverted Road Prop Tax 1 311.20 720,000 4,723 420,267 58.4%720,000 4,708 420,216 58.4%720,000 2,995 427,668 59.4% Private Harvest Tax 2 317.40.10/.20 335,000 139,212 311,003 92.8%281,335 68,938 252,332 89.7%460,885 - 366,366 79.5% Sales Tax 1 313.11 2,742,000 293,953 1,868,018 68.1%2,738,244 276,309 1,727,952 63.1%2,486,611 257,369 1,582,977 63.7% special purpose 313.15 870,430 89,679 582,256 66.9%876,170 87,275 560,560 64.0%769,039 76,734 482,904 62.8% Local Criminal Justice 1 313.71 366,157 37,671 241,615 66.0%364,508 36,162 232,864 63.9%318,901 31,866 200,118 62.8% Leasehold Excise Tax 3 317.20 62,000 16,199 50,748 81.9%55,407 14,937 44,666 80.6%59,267 12,739 44,462 75.0% Treas. Collection Fees (REET)3 341.42.31/32/33 70,000 7,485 58,015 82.9%84,213 7,812 57,423 68.2%74,197 6,475 46,951 63.3% Penalties on delinquent taxes 1 359.40.10/.20 132,300 3,986 65,994 49.9%112,239 6,336 78,457 69.9%109,143 4,521 76,435 70.0% Interest on delinquent taxes 1 361.40.10 204,300 6,313 132,572 64.9%213,458 11,755 152,594 71.5%200,845 7,902 147,428 73.4% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 561,000 - 1,390,772 247.9%1,476,638 - 1,422,312 96.3%1,408,800 - 1,253,823 89.0% P.U.D. Privilege Tax 4 335.00.91 348,000 - 314,148 90.3%318,107 - 318,107 100.0%370,446 - 370,446 100.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 476,845 - 327,664 68.7%477,057 - 367,324 77.0%488,746 - 359,931 73.6% Marijuana Enforcement/Excise 336.06.41/336.06.42 39,530 - 11,354 28.7%36,920 - 25,568 69.3%25,568 - 0 Liquor Excise Tax 8 336.06.94 40,722 - 32,161 79.0%41,772 - 30,739 73.6%21,930 - 11,894 54.2% Liquor Profit 6 336.06.95 88,434 - 42,310 47.8%84,749 - 42,439 50.1%85,021 - 42,582 50.1% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.0671 307,661 - 30,577 9.9%294,890 - 26,537 9.0%293,327 - 26,255 9.0% Investment Income 1 361.11 218,484 20,875 270,868 124.0%682,617 544,654 611,048 89.5%465,346 19,744 34,928 7.5% Treasurer Invest & Other Fees 1 341.42.15/16/17/18/19/50 16,290 1,888 24,461 150.2%11,599 1,315 6,858 59.1%4,080 341 2,604 63.8% DNR Timber 1 395.1.1 250,000 89,291 94,176 37.7%336,350 33,414 257,543 76.6%473,880 8,424 365,227 77.1% Transfer in 1 397.00 3,000 750 20,296 676.5%46,441 750 22,437 48.3%10,373 - 5,000 48.2% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 1,024 5,024 42.2%46,095 292 15,993 34.7%299,479 3,253 25,749 8.6% Assessor 1 001-010-000 8,700 1,840 8,129 93.4%8,761 1,791 6,135 70.0%1,125 115 619 55.0% Auditor-Recording Fees 1 341.21.10 70,000 5,504 48,264 68.9%74,077 6,616 48,209 65.1%72,112 6,006 47,780 66.3% Auditor-M.V. License Fees 1 341.48/336.00.93 222,601 18,765 160,401 72.1%229,927 52,062 185,420 80.6%157,587 14,066 112,105 71.1% Auditor-Other Revenue 1 25,252 2,658 20,348 80.6%32,440 2,420 20,417 62.9%84,605 27,065 69,191 81.8% Elections 1 001-021-000 110,711 - 55,987 50.6%160,903 - 151,935 94.4%101,929 1,575 56,721 55.6% Clerk 1 001-020-000 199,087 22,385 120,444 60.5%192,402 19,675 131,291 68.2%211,930 20,938 142,750 67.4% Commissioners 1 001-060-000 8,000 686 5,772 72.2%8,609 829 5,670 65.9%8,663 757 5,773 66.6% Safety & Security 1 001-067-000 64,959 7,565 47,355 72.9%70,305 25,034 52,836 75.2%71,593 15,332 30,334 42.4% Community Services 1 001-068-000 9,900 1,780 3,857 39.0%8,269 34 2,857 34.5%4,488 52 3,292 73.4% District Court 1 001-080-000 660,257 82,960 432,362 65.5%632,629 86,833 450,185 71.2%667,142 83,350 460,147 69.0% Juvenile Service 1 001-110-000 253,516 21,724 183,907 72.5%260,358 18,370 169,014 64.9%248,694 14,719 162,240 65.2% Prosecuting Attorney 1 001-150-000 195,552 18,451 118,699 60.7%124,918 10,851 93,198 74.6%224,953 14,989 167,110 74.3% Coroner 1 001-151-000 17,200 - 24,610 143.1%8,340 - 8,340 100.0%11,140 7,660 11,140 100.0% Sheriff 1 001-180-000 567,029 85,183 436,531 77.0%626,703 73,579 417,361 66.6%530,346 21,095 372,982 70.3% Superior Court 1 001-240-000 19,500 21,080 67,739 347.4%26,142 5,411 20,732 79.3%19,952 32 4,532 22.7% Non Departmental 1 001-270-000 49,416 10 0.0%10 TOTAL CURRENT EXPENSE 18,041,838 1,054,356 12,452,543 69.0%19,277,851 1,446,688 12,787,650 66.3%18,950,211 693,632 11,782,155 62.2% * 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 OCT 2013 LESS $201,525.00 REF EXP LIABILITY PROP INS PREMIUM / 2012 LESS 253,332-CY REF EXP 2014 REFUND EXP 216,222 YTD REFUND EXPEND CY/PRIOR exclu 388/89 14149.54 28,115 536.1 11,222 10,426 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2017 3 year view 9/6/2017 FUND Fund #Budget Aug YTD YTD ACTUAL Aug YTD YTD ACTUAL Aug YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % SPECIAL REVENUE Auditor's O & M 105 77,169 2,112 68,571 88.9%74,342 2,514 65,415 88.0%71,081 2,279 62,268 87.6% Court Facilitator 106 6,000 280 3,920 65.3%6,220 460 4,000 64.3%5,989 640 4,188 69.9% Boating Safety 107 54,632 - 41,877 76.7%61,493 12,833 52,033 84.6%44,988 218 34,856 77.5% WSU Cooperative 108 590,016 49,398 305,106 51.7%528,605 84,309 374,485 70.8%326,722 97,630 252,482 77.3% 4-H After School 113 20,950 - 22,733 108.5%10,600 - 10,600 100.0%46,129 8,952 37,177 80.6% JeffComCap 119 119 254,650 21,221 169,955 66.7%276,062 22,899 183,193 66.4%286,656 24,551 188,450 65.7% Crime Victim's Svc 120 50,418 1,077 74,175 147.1%79,335 1,803 51,602 65.0%62,364 2,819 43,487 69.7% Grant Mgmt 123 150,000 5,701 58,345 38.9%95,126 - 61,954 65.1%69,440 - 34,086 49.1% Hotel-Motel 125 425,500 64,820 290,924 68.4%449,148 56,349 251,608 56.0%386,107 48,845 208,032 53.9% H&HS Site Abatement 126 - - - - - - 14,139 - - 0.0% Jeff Co Public Health 127 3,964,210 373,680 2,865,016 72.3%4,076,806 461,594 3,025,605 74.2%3,898,751 396,994 2,766,348 71.0% Water Quality 128 1,029,803 137,660 667,819 64.8%999,219 64,803 594,991 59.5%880,574 42,226 590,775 67.1% Mental Health 130 47,650 1,550 27,921 58.6%46,854 886 28,032 59.8%47,746 308 28,637 60.0% Chem Dep Mnt Hlth tx 131 490,490 51,770 332,566 67.8%500,457 49,704 320,068 64.0%442,353 43,824 275,552 62.3% Drug Fund 135 23,438 989 8,058 34.4%23,562 1,065 18,942 80.4%18,657 1,323 10,779 57.8% Law Library 140 10,150 945 6,616 65.2%9,692 927 6,445 66.5%10,334 994 7,053 68.2% Trial Court Imprvmnt 141 25,000 - 11,726 46.9%22,669 5,667 16,903 74.6%22,905 - 11,348 49.5% Public Defense Fnd 142 35,000 - - 0.0%36,673 - - 0.0%42,076 - - 0.0% Community Develpmnt 143 1,594,110 212,606 1,047,007 65.7%1,668,687 205,129 1,196,741 71.7%1,555,523 170,597 1,033,690 66.5% Jeff Co Affrdbl Hsg 148 198,431 19,854 161,614 81.4%243,809 23,305 161,266 66.1%240,673 20,958 157,514 65.4% Treasurer's O & M 150 47,140 1,542 18,769 39.8%23,981 2,173 15,454 64.4%26,138 13 16,301 62.4% REET technology 151 14,420 1,468 10,805 74.9%16,194 1,503 10,607 65.5%15,156 1,459 9,953 65.7% Veteran's Relief 155 59,330 1,637 44,999 75.8%63,652 926 44,483 69.9%63,899 321 44,510 69.7% Water Pollution Cntrl 160 - - - 18,607 - 17,665 94.9%12,058 100 11,658 96.7% Park & Rec 174 586,640 122,206 424,280 72.3%569,174 117,259 393,869 69.2%594,033 113,129 428,601 72.2% County Park Imprvmnt 175 61,000 12,126 78,540 128.8%84,284 10,181 79,749 94.6%60,301 8,414 52,052 86.3% County Roads 180 10,012,963 757,936 5,510,006 55.0%8,949,637 509,037 4,918,585 55.0%9,720,929 510,804 5,327,793 54.8% Facilities Mgmt 183 1,037,953 81,430 688,292 66.3%1,116,468 86,931 768,593 68.8%958,738 84,224 677,266 70.6% County Fair 199 250,000 75,173 257,583 103.0%269,769 83,421 206,805 76.7%271,091 74,192 221,883 81.8% Total Special Revenue 21,117,063 1,922,005 13,197,225 62.5%20,321,124 1,722,257 12,879,692 63.4%20,195,549 1,581,624 12,536,739 62.1% OTHER FUNDS REVENUE REPORT 2017 3 year view FUND Budget Aug YTD YTD Budget Aug YTD YTD Budget Aug YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % CAPITAL IMPROVEMENT Const/Renovation 301 500,000 - 511,831 102.4%1,113,333 275,000 836,612 75.1%234,915 100,000 233,213 99.3% Capital Improvement 302 1,048,750 110,037 770,631 73.5%1,537,774 125,719 846,272 55.0%2,076,934 92,001 706,497 34.0% Public Infrastructure 306 411,400 48,329 308,237 74.9%456,854 45,422 292,308 64.0%399,328 39,870 250,834 62.8% Conservation Futures 308 239,645 8,703 150,504 62.8%244,237 4,797 145,953 59.8%246,862 1,646 147,837 59.9% Total CAP IMP 2,199,795 167,070 1,741,202 79.2%3,352,198 450,939 2,121,145 63.3%2,958,038 233,516 1,338,381 45.2% ENTERPRISE Solid Waste 401 3,408,989 302,154 2,305,486 67.6%3,481,538 262,866 2,225,468 63.9%3,137,778 279,284 2,100,596 66.9% Solid Waste Post Clos 402 150 73 416 277.6%335 36 196 58.4%103 8 64 62.4% Solid Waste Eqpt Res 403 1,500 1,025 5,822 388.2%302,768 297 1,605 0.5%779 63 484 62.1% Yard Waste Educ Fnd 404 7,740 2 19 0.2%1,781 4 25 1.4%12 1 7 59.2% Tri Area Sewer 405 201,000 563 4,352 2.2%172,740 273 1,684 1.0%206,433 170,092 170,603 82.6% Total ENTERPRISE 3,619,379 303,817 2,316,095 64.0%3,959,162 263,475 2,228,976 56.3%3,345,106 449,450 2,271,755 67.9% INTERNAL SERVICE Equipment Rental 501 2,411,194 394,627 1,602,354 66.5%2,179,575 160,462 1,134,650 52.1%2,146,936 139,526 1,165,420 54.3% Risk Management 502 150,000 75,111 75,111 50.1%57,666 14,856 15,034 26.1%76,871 75,813 75,813 98.6% Benefit Reserve 505 198,000 16,853 167,077 84.4%215,434 16,252 163,061 75.7%251,189 16,340 156,675 62.4% Information Services 506 1,696,833 3,097 1,250,207 73.7%1,551,832 41,969 1,118,515 72.1%1,639,415 7,564 1,156,167 70.5% Total INT SERV 4,456,027 489,688 3,094,750 69.5%4,004,508 233,538 2,431,260 60.7%4,114,411 239,243 2,554,076 62.1% Total 31,392,264 2,882,579 20,349,272 64.8%31,636,992 2,670,209 19,661,074 62.1%30,613,104 2,503,833 18,700,951 61.1% GENERAL FUND CASH BALANCE REPORT 9/6/2017 END OF MONTH CASH BALANCES 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 January $3,761,366 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$ February $3,486,901 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$ March $2,898,116 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,932,654 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 $4,816,082 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 $4,785,927 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 $4,308,238 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 $3,191,594 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,986,861 2,150,120$ 1,596,637$ 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ October $4,764,280 3,787,064$ 3,363,104$ 4,339,258$ 4,098,330$ 4,148,666$ 4,133,005$ 5,804,449$ 6,326,563$ November $4,063,841 3,281,183$ 3,339,559$ 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ December $3,601,124 3,297,287$ 3,248,681$ 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Budg *** Total Reserve $1,528,008 $ 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 10% GF Budgeted Expenditures $1,528,008 $ 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 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,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. $0 $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 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 GENERAL SALES TAX RECEIPTS 9/6/2017 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cummulative Year End 3 yr. avg Expected Actual Over/Under Cum %projection 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2014-16 2017 2017 Expected expected Projection Over/UnderJanuary207,318 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 7.0%191,668 185,505 -$6,163 96.78%$2,653,836 -$88,164February206,809 219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 9.6%262,727 310,729 $41,840 109.21%$2,994,476 $252,476March170,679 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 6.9%187,936 189,576 $43,479 106.77%$2,927,606 $185,606April162,253 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 6.7%183,321 193,862 $54,020 106.54%$2,921,401 $179,401 May 212,586 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 8.1%223,095 249,596 $80,521 107.68%$2,952,525 $210,525June 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 7.3%200,156 208,349 $88,713 107.10%$2,936,773 $194,773July174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 7.5%205,551 236,448 $119,611 108.22%$2,967,496 $225,496August244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 10.3%281,444 293,953 $132,120 107.61%$2,950,695 $208,695September213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 9.1%250,365 - -$118,245 94.05%$2,578,765 -$163,235 October 212,410 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 9.3%255,644 - -$373,888 83.32%$2,284,710 -$457,290November239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 10.2%278,820 - -$652,708 74.11%$2,031,996 -$710,004December197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 8.1%221,273 - -$873,982 68.13%$1,868,018 -$873,982TTL2,410,507 2,137,279 1,918,151 1,968,790 2,047,153 2,348,673 2,300,936 2,486,611 2,738,244 1,868,018 100.0%$2,742,000 $1,868,018ytd 1,546,794 1,411,867 1,232,148 1,289,596 1,217,815 1,545,212 1,453,479 1,582,977 1,727,952 1,868,018 1,735,898 1,868,018 through December ytd change 59.84%-8.72%-12.73%4.66%-5.57%26.88%-5.94%8.91%9.16%8.11%7.61%over (under) ytd expected annual % chg.-1.77%-11.33%-10.25%2.64%3.98%14.73%-2.03%8.07%10.12% Special Purp./Public Safety TaxActualActualActual Actual Actual Actual 3 yr avg.Projection Actual 2012 2013 2014 2015 2016 2017 2014-16 2017 2017 Proj Actual %Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 6.80%59,190 61,161 250,858 246,667 -1.7%February 61,899 70,678 67,508 73,364 83,521 93,242 9.56%83,213 93,242 345,940 403,971 16.8%March 40,604 56,106 49,782 50,931 62,285 61,183 6.94%60,446 61,183 248,382 250,759 1.0%April 43,155 51,054 47,573 52,541 59,481 59,911 6.80%59,184 59,911 242,505 253,772 4.6% May 51,908 58,324 56,012 62,613 74,233 78,716 8.22%71,519 78,716 294,614 328,312 11.4%June 46,797 50,067 48,647 58,717 65,832 65,229 7.38%64,228 65,229 264,384 273,577 3.5%July 49,385 68,295 54,074 56,793 69,908 73,136 7.70%67,038 73,136 272,589 309,584 13.6%August 56,220 56,063 68,712 76,734 87,275 89,679 9.91%86,302 89,679 367,746 383,632 4.3%September 54,902 61,455 64,622 72,022 77,854 9.14%79,544 - 329,909 - October 61,120 64,400 64,152 73,903 82,028 9.38%81,615 - 337,258 - November 60,952 64,915 71,491 77,947 89,596 10.18%88,643 - 367,463 - December 49,281 52,177 59,043 62,263 66,133 7.99%69,509 - 290,783 - TOTAL 621,440 704,453 701,993 769,039 876,170 582,256 100.0%870,430 582,256 3,612,430 2,450,274 ytd $395,185 $461,506 $442,685 $482,904 $560,560 $582,256 $551,119 $582,256 $2,287,017 2,450,274 7.1% 5.65%over (under) ytd expected TOTAL 2017 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 2017 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation TOTAL Recent 2017 2016 % Budget 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 4 YR AVG Budget Actual Difference January $45,530 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 40,628$ 44,304$ 78,597$ 77% February $45,612 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 36,290$ 39,574$ 47,854$ 21% March $63,286 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 82,992$ 90,501$ 91,388$ 1% April $105,272 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 63,828$ 69,602$ 78,523$ 13% May $49,638 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 73,696$ 80,363$ 111,101$ 38% June $54,812 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 123,615$ 134,798$ 147,551$ 9% July $57,890 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 85,350$ 93,071$ 105,582$ 13% August $58,240 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 86,183$ 93,980$ 110,037$ 17% September $39,174 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 113,545$ 123,818$ -$ October $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 90,715$ 98,922$ -$ November $22,654 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 77,577$ 84,596$ -$ December $37,906 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 87,323$ 95,223$ -$ Total $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $770,631 961,744$ 1,048,750$ 770,631$ -27% YTD $480,280 $376,242 $288,548 $310,929 $310,375 $393,343 $424,219 $706,497 $846,272 $770,631 592,583$ 646,192$ 770,631$ 19% Y/Y chg -33.00%-21.66%-23.31%7.76%-0.18%26.73%7.85%66.54%19.78%-8.94% Jan 2016 2 sales at $1.275M and $755K Sept 2016 9 sales>$500k in JC May 2017 1@$1.098, 1@$1.035, 6 Res>$500k Feb 2016 3 sales >$500k Oct 2016 3 sales @ $5.3M, 1.9M & 1.3M, 8>$500k Jun 2017 1@$1.05, 16>$500k Mar 2016 3 Res >$500k Nov 2016 1 Res @$1.2M, 4 Res>$500k July 2017 6>$500k Apr 2016 3 Res >$500k Dec 2016 1@1.69M, 1@2.08M, 2 Res>$500k Aug 2017 1@$1.024, 1@1.37 and 11>$500k May 2016 5 Res >$500k Jan 2017 1@1.565M, 6 Res>$500k Jun 2016 11.7k acres for $27.4M, 6 Res>$500k Feb 2017 5 Res>$500k July 2016 284 ac for $1.2M, 6 Res > $500k Mar 2017 6 Res>$500k Aug 2016 6 sales >$500k in JC Apr 2017 1@$1.098, 1@$1.035, 6 Res>$500k 9/7/2017 $0 $50,000 $100,000 $150,000 $200,000 $250,000 REET RECEIPTS 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 9/6/2017 REVENUE 4 yr avg *2017 2017 % Budget 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2013-16 Budget Actual Difference January $15,742 16,089$ 10,732$ 11,507$ 12,045$ $8,863 $13,575 $17,051 $18,473 $19,394 14,490$ 16,820$ $19,394 15.3% February $29,461 27,998$ 21,729$ 25,532$ 23,188$ $38,274 $30,356 $36,141 $51,077 $53,093 38,962$ 45,225$ $53,093 17.4% March $10,723 22,623$ 9,838$ 12,406$ 7,271$ $11,203 $12,715 $14,345 $14,554 $16,889 13,204$ 15,327$ $16,889 10.2% April $11,702 11,344$ 11,934$ 10,791$ 14,950$ $11,430 $12,427 $14,983 $18,530 $20,901 14,343$ 16,648$ $20,901 25.5%May $20,360 19,646$ 19,561$ 25,142$ 17,142$ $18,010 $19,151 $23,886 $29,462 $45,943 22,627$ 26,265$ $45,943 74.9% June $18,853 19,205$ 19,650$ 17,302$ 17,916$ $16,477 $18,786 $25,070 $29,476 $31,485 22,452$ 26,062$ $31,485 20.8% July $23,514 20,155$ 14,326$ 19,311$ 20,201$ $21,512 $24,536 $27,711 $33,687 $38,400 26,861$ 31,180$ $38,400 23.2% August $37,302 35,178$ 36,076$ 24,742$ 31,171$ $33,140 $37,534 $48,845 $56,349 $64,820 43,967$ 51,035$ $64,820 27.0% September $41,768 41,757$ 40,208$ 42,500$ 40,882$ $39,890 $42,349 $44,713 $53,487 45,110$ 52,362$ October $42,480 43,012$ 46,548$ 43,861$ 41,015$ $41,741 $43,659 $49,182 $59,970 48,638$ 56,457$ November $44,786 44,351$ 43,285$ 38,547$ 36,906$ $39,146 $46,879 $58,967 $57,999 50,748$ 58,906$ December $21,753 19,873$ 18,741$ 21,703$ 11,109$ $15,514 $33,858 $25,213 $26,084 25,167$ 29,213$ YTD $167,657 $172,238 $143,846 $146,733 $143,884 $158,909 $169,080 $208,032 $251,608 $290,924 $196,907 228,562$ $290,924 27.3% Total $318,444 $321,231 $292,628 $293,344 $273,796 $295,200 $335,825 $386,107 $449,148 $290,924 $366,570 425,500$ $290,924 $5,000 $20,000 $35,000 $50,000 $65,000 HOTEL/MOTEL LODGING TAX -Fund 125 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017