Loading...
HomeMy WebLinkAbout2017-12_RevenueRpts2017 BARS General Fund 10-Jan-2018 y Treasurer REVENUE NAME BUDGET DEC Y-T-D Y-T-D ACTUAL DEC Y-T-D Y-T-D ACTUAL DEC Y-T-D Y-T-D *2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % Property Tax 1 311.10 7,696,105 45,801 7,643,881 99.3%7,514,257 43,997 7,514,257 100.0%7,388,068 47,813 7,388,068 100.0% Diverted Road Prop Tax 1 311.20 720,000 3,784 720,000 100.0%720,000 3,160 720,000 100.0%720,000 (4,725) 720,000 100.0% Private Harvest Tax 2 317.40.10/.20 335,000 - 377,824 112.8%281,335 - 281,335 100.0%460,885 - 460,885 100.0% Sales Tax 1 313.11 2,918,722 219,772 2,876,339 98.5%2,738,244 215,537 2,738,244 100.0%2,486,611 195,665 2,486,611 100.0% special purpose 313.15 907,549 69,582 903,099 99.5%876,170 66,133 876,170 100.0%769,039 62,263 769,039 100.0% Local Criminal Justice 1 313.71 366,157 29,090 375,219 102.5%364,508 27,824 364,508 100.0%318,901 25,961 318,901 100.0% Leasehold Excise Tax 3 317.20 62,000 16,019 69,801 112.6%55,407 8,447 55,407 100.0%59,267 11,682 59,267 100.0% Treas. Collection Fees (REET)3 341.42.31/32/33 70,000 6,896 90,727 129.6%84,213 6,092 84,213 100.0%74,197 6,759 74,197 100.0% Penalties on delinquent taxes 1 359.40.10/.20 132,300 18,310 98,944 74.8%112,239 18,700 112,239 100.0%109,143 19,293 109,143 100.0% Interest on delinquent taxes 1 361.40.10 204,300 21,221 193,625 94.8%213,458 23,339 213,458 100.0%200,845 18,935 200,845 100.0% P.I.L.T. (incl DNR)4 332.15.23/336.02.31 561,000 67,873 1,458,645 260.0%1,476,638 54,326 1,476,638 100.0%1,408,800 48,119 1,408,800 100.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 - 435,778 91.4%477,057 (47) 477,057 100.0%488,746 - 488,746 100.0% Marijuana Enforcement/Excise 336.06.41/336.06.42 39,530 4,973 21,297 53.9%36,920 5,676 36,920 100.0%25,568 12,784 25,568 Liquor Excise Tax 8 336.06.94 40,722 - 44,174 108.5%41,772 - 41,772 100.0%21,930 - 21,930 100.0% Liquor Profit 6 336.06.95 88,434 21,065 84,441 95.5%84,749 21,155 84,749 100.0%85,021 21,220 85,021 100.0% Interfund Chg Svc-Cost Alloc 3 349.14.10/362.50.00.0671/.180 307,661 116,388 143,455 46.6%294,890 259,507 294,890 100.0%293,327 258,321 293,327 100.0% Investment Income 1 361.11 218,484 (35,653) 354,385 162.2%682,617 17,003 682,617 100.0%465,346 290,479 465,346 100.0% Treasurer Invest & Other Fees 1 341.42.15-19/50 16,290 (1,893) 33,805 207.5%11,599 1,143 11,599 100.0%4,080 359 4,080 100.0% DNR Timber 1 395.1.1 250,000 448 207,899 83.2%336,350 7,565 336,350 100.0%473,880 - 473,880 100.0% Transfer in 1 397.00 3,000 1,484 40,322 1344.1%46,441 - 46,441 100.0%10,373 5,373 10,373 100.0% Miscellaneous 161.40.30/362.5/369.81/369.9 11,900 2,157 9,020 75.8%29,940 12,388 29,940 100.0%299,479 11,310 299,479 100.0% Assessor 1 001-010-000 8,700 367 10,970 126.1%8,761 434 8,761 100.0%1,125 284 1,125 100.0% Auditor-Recording Fees 1 341.21.10 70,000 6,318 74,248 106.1%74,077 6,384 74,077 100.0%72,112 6,523 72,112 100.0% Auditor-M.V. License Fees 1 341.48/336.00.93 222,601 9,346 242,031 108.7%229,927 7,117 229,927 100.0%157,587 10,590 157,587 100.0% Auditor-Other Revenue 1 25,252 2,356 29,714 117.7%32,440 1,914 32,440 100.0%84,605 8,160 84,605 100.0% Elections 1 001-021-000 110,711 24,791 138,996 125.5%160,903 7,436 160,903 100.0%101,929 32,681 101,929 100.0% Clerk 1 001-020-000 199,087 12,740 179,130 90.0%192,402 14,351 192,402 100.0%211,930 25,192 211,930 100.0% Commissioners 1 001-060-000 8,000 850 8,923 111.5%8,609 732 8,609 100.0%8,663 746 8,663 100.0% County Administrator 1 - 3,700 3,700 Safety & Security 1 001-067-000 64,959 - 66,877 103.0%70,305 10,937 70,305 100.0%71,593 - 71,593 100.0% Community Services 1 001-068-000 9,900 657 4,611 46.6%8,269 29 8,269 100.0%4,488 52 4,488 100.0% District Court 1 001-080-000 660,257 62,426 596,433 90.3%632,629 29,695 632,629 100.0%667,142 48,822 667,142 100.0% Juvenile Service 1 001-110-000 253,516 22,571 290,984 114.8%260,358 6,368 260,358 100.0%248,694 25,727 248,694 100.0% Prosecuting Attorney 1 001-150-000 195,552 7,049 151,185 77.3%124,918 6,911 124,918 100.0%224,953 22,901 224,953 100.0% Coroner 1 001-151-000 17,200 - 24,610 143.1%8,340 - 8,340 100.0%11,140 - 11,140 100.0% Sheriff 1 001-180-000 567,029 202,044 722,960 127.5%626,703 34,905 626,703 100.0%530,346 8,968 530,346 100.0% Superior Court 1 001-240-000 19,500 0 90,193 462.5%26,142 - 26,142 100.0%19,952 15,266 19,952 100.0% Non Departmental 1 001-270-000 49,416 49,186 49,196 99.6%24,293 24,283 24,293 TOTAL CURRENT EXPENSE 18,255,679 1,011,720 19,181,590 105.1%19,285,989 919,159 19,285,989 100.0%18,950,211 1,237,522 18,950,211 100.0% * 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 21,705 253,160.38 176,949 17,338 727 10,426 Prepared by the Jefferson County Treasurer OTHER FUNDS REVENUE REPORT 2017 3 year view 1/10/2018 FUND Fund #Budget Dec YTD YTD ACTUAL Dec YTD YTD ACTUAL Dec YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % SPECIAL REVENUE Auditor's O & M 105 77,169 2,246 77,983 101.1%74,342 2,215 74,342 100.0%71,081 2,301 71,081 100.0% Court Facilitator 106 6,000 360 5,920 98.7%6,220 600 6,220 100.0%5,989 540 5,989 100.0% Boating Safety 107 54,632 - 49,100 89.9%61,493 - 61,493 100.0%44,988 10,132 44,988 100.0% WSU Cooperative 108 590,016 108,589 534,494 90.6%528,605 5,920 528,605 100.0%326,722 200 326,722 100.0% 4-H After School 113 20,950 - 44,475 212.3%10,600 - 10,600 100.0%46,129 - 46,129 100.0% JeffComCap 119 119 254,650 21,221 254,838 100.1%276,062 22,899 276,062 100.0%286,656 24,551 286,656 100.0% Crime Victim's Svc 120 50,418 871 99,707 197.8%79,335 1,151 79,335 100.0%62,364 2,725 62,364 100.0% Grant Mgmt 123 150,000 18,378 76,723 51.1%95,126 33,172 95,126 100.0%69,440 15,469 69,440 100.0% Hotel-Motel 125 425,500 32,870 507,868 119.4%449,148 26,084 449,148 100.0%386,107 25,213 386,107 100.0% H&HS Site Abatement 126 - - - - - - 14,139 14,139 14,139 100.0% Jeff Co Public Health 127 3,964,210 275,247 4,064,163 102.5%4,076,806 201,811 4,076,806 100.0%3,898,751 222,670 3,898,751 100.0% Water Quality 128 1,029,803 118,089 975,455 94.7%999,219 114,633 999,219 100.0%880,574 53,139 880,574 100.0% Mental Health 130 47,650 355 47,474 99.6%46,854 335 46,854 100.0%47,746 341 47,746 100.0% Chem Dep Mnt Hlth tx 131 490,490 39,978 516,131 105.2%500,457 38,244 500,457 100.0%442,353 35,703 442,353 100.0% Drug Fund 135 23,438 898 11,819 50.4%23,562 945 23,562 100.0%18,657 2,039 18,657 100.0% Law Library 140 10,150 947 10,049 99.0%9,692 725 9,692 100.0%10,334 899 10,334 100.0% Trial Court Imprvmnt 141 25,000 5,864 23,449 93.8%22,669 - 22,669 100.0%22,905 - 22,905 100.0% Public Defense Fnd 142 35,000 - - 0.0%36,673 36,673 36,673 100.0%42,076 42,076 42,076 100.0% Community Develpmnt 143 1,594,110 70,001 1,418,569 89.0%1,668,687 106,091 1,668,687 100.0%1,555,523 222,117 1,555,523 100.0% Jeff Co Affrdbl Hsg 148 198,431 21,010 250,150 126.1%243,809 20,163 243,809 100.0%240,673 22,218 240,673 100.0% Treasurer's O & M 150 47,140 9,252 28,653 60.8%23,981 6,108 23,981 100.0%26,138 8,887 26,138 100.0% REET technology 151 14,420 1,372 16,827 116.7%16,194 1,362 16,194 100.0%15,156 1,139 15,156 100.0% Veteran's Relief 155 59,330 428 65,060 109.7%63,652 368 63,652 100.0%63,899 355 63,899 100.0% Water Pollution Cntrl 160 - - - 18,607 - 18,607 100.0%12,058 100 12,058 100.0% Park & Rec 174 586,640 40,184 625,429 106.6%569,174 11,335 569,174 100.0%594,033 2,195 594,033 100.0% County Park Imprvmnt 175 117,886 32,500 119,426 101.3%84,284 - 84,284 100.0%60,301 192 60,301 100.0% County Roads 180 10,012,963 629,046 9,773,015 97.6%8,949,637 593,078 8,949,637 100.0%9,720,929 822,091 9,720,929 100.0% Facilities Mgmt 183 1,037,953 104,856 1,040,019 100.2%1,116,468 86,931 1,116,468 100.0%958,738 44,196 958,738 100.0% County Fair 199 250,000 4,440 308,594 123.4%269,769 5,574 269,769 100.0%271,091 5,720 271,091 100.0% Total Special Revenue 21,173,949 1,534,563 20,945,389 98.9%20,321,124 1,310,844 20,321,124 100.0%20,195,549 1,575,628 20,195,549 100.0% OTHER FUNDS REVENUE REPORT 2017 3 year view FUND Budget Dec YTD YTD Budget Dec YTD YTD Budget Dec YTD YTD 2017 2017 2017 %2016 2016 2016 %2015 2015 2015 % CAPITAL IMPROVEMENT Const/Renovation 301 500,000 2,413 517,754 103.6%1,113,333 - 1,113,333 100.0%234,915 - 234,915 100.0% Capital Improvement 302 1,048,750 100,034 1,285,270 122.6%1,537,774 83,276 1,537,774 100.0%2,076,934 302,439 2,076,934 100.0% Public Infrastructure 306 411,400 33,742 477,127 116.0%456,854 35,189 456,854 100.0%399,328 32,462 399,328 100.0% Conservation Futures 308 239,645 2,431 256,431 107.0%244,237 1,960 244,237 100.0%246,862 1,826 246,862 100.0% Total CAP IMP 2,199,795 138,620 2,536,581 115.3%3,352,198 120,425 3,352,198 100.0%2,958,038 336,726 2,958,038 100.0% ENTERPRISE Solid Waste 401 3,408,989 289,786 3,488,829 102.3%3,481,538 261,802 3,481,538 100.0%3,137,778 233,056 3,137,778 100.0% Solid Waste Post Clos 402 150 (185) 516 343.7%335 31 335 100.0%103 9 103 100.0% Solid Waste Eqpt Res 403 1,500 (2,217) 7,601 506.7%302,768 273 302,768 100.0%779 70 779 100.0% Yard Waste Educ Fnd 404 7,740 5,725 5,750 74.3%1,781 1 1,781 100.0%12 1 12 100.0% Tri Area Sewer 405 201,000 86,399 297,554 148.0%172,740 216 172,740 100.0%206,433 35,483 206,433 100.0% Total ENTERPRISE 3,619,379 379,508 3,800,250 105.0%3,959,162 262,324 3,959,162 100.0%3,345,106 268,619 3,345,106 100.0% INTERNAL SERVICE Equipment Rental 501 2,411,194 279,082 2,508,636 104.0%2,179,575 279,358 2,179,575 100.0%2,146,936 269,149 2,146,936 100.0% Risk Management 502 150,000 37,659 112,770 75.2%57,666 42,632 57,666 100.0%76,871 1,058 76,871 100.0% Benefit Reserve 505 198,000 14,378 225,590 113.9%215,434 11,301 215,434 100.0%251,189 56,574 251,189 100.0% Information Services 506 1,696,833 121,680 1,832,926 108.0%1,551,832 40,680 1,551,832 100.0%1,639,415 102,794 1,639,415 100.0% Total INT SERV 4,456,027 452,798 4,679,922 105.0%4,004,508 373,972 4,004,508 100.0%4,114,411 429,575 4,114,411 100.0% Total 31,449,150 2,505,488 31,962,142 101.6%31,636,992 2,067,565 31,636,992 100.0%30,613,104 2,610,548 30,613,104 100.0% GENERAL FUND CASH BALANCE REPORT 1/8/2018 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$ 4,724,294$ 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$ 6,245,727$ 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$ 6,098,807$ 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$ 5,201,817$ 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 1/8/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 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%204,021 185,505 -$18,516 90.92%$2,653,836 -$264,886February206,809 219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 9.6%279,659 310,729 $12,554 102.60%$2,994,476 $75,754March170,679 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 6.9%200,049 189,576 $2,081 100.30%$2,927,606 $8,884April162,253 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 6.7%195,136 193,862 $807 100.09%$2,921,401 $2,679 May 212,586 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 8.1%237,474 249,596 $12,929 101.16%$2,952,525 $33,803June 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 7.3%213,056 208,349 $8,222 100.62%$2,936,773 $18,051July174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 7.5%218,798 236,448 $25,872 101.67%$2,967,496 $48,774August244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 10.3%299,583 293,953 $20,242 101.10%$2,950,695 $31,973September213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 9.1%266,501 241,325 -$4,934 99.77%$2,911,911 -$6,811 October 212,410 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 9.3%272,120 267,264 -$9,790 99.59%$2,906,748 -$11,974November239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 10.2%296,790 279,959 -$26,621 99.01%$2,889,765 -$28,957December197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 219,772 8.1%235,535 219,772 -$42,383 98.55%$2,876,339 -$42,383TTL2,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 2,876,339 100.0%$2,918,722 $2,876,339ytd 2,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 2,876,339 2,918,722 2,876,339 through December ytd change 149.09%-11.33%-10.25%2.64%3.98%14.73%-2.03%8.07%10.12%5.04%-1.45%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%61,714 61,161 265,736 246,667 -7.2%February 61,899 70,678 67,508 73,364 83,521 93,242 9.56%86,762 93,242 366,421 403,971 10.2%March 40,604 56,106 49,782 50,931 62,285 61,183 6.94%63,023 61,183 263,072 250,759 -4.7%April 43,155 51,054 47,573 52,541 59,481 59,911 6.80%61,707 59,911 256,844 253,772 -1.2% May 51,908 58,324 56,012 62,613 74,233 78,716 8.22%74,569 78,716 312,043 328,312 5.2%June 46,797 50,067 48,647 58,717 65,832 65,229 7.38%66,967 65,229 280,023 273,577 -2.3%July 49,385 68,295 54,074 56,793 69,908 73,136 7.70%69,897 73,136 288,695 309,584 7.2%August 56,220 56,063 68,712 76,734 87,275 89,679 9.91%89,982 89,679 389,565 383,632 -1.5%September 54,902 61,455 64,622 72,022 77,854 77,534 9.14%82,936 77,534 349,437 318,859 -8.8% October 61,120 64,400 64,152 73,903 82,028 82,991 9.38%85,095 82,991 357,215 350,255 -1.9%November 60,952 64,915 71,491 77,947 89,596 90,736 10.18%92,423 90,736 389,213 370,695 -4.8%December 49,281 52,177 59,043 62,263 66,133 69,582 7.99%72,473 69,582 308,008 289,354 -6.1%TOTAL 621,440 704,453 701,993 769,039 876,170 903,099 100.0%907,549 903,099 3,826,271 3,779,438 ytd $621,440 $704,453 $701,993 $769,039 $876,170 $903,099 $907,549 $903,099 $3,826,271 $3,779,438 -1.2% -0.49%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. Budget Appropriation 9/11/2017 to increase Sales Tax and Special Purpose budgeted revenue 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 2017 % 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$ 181,336$ 113,545$ 123,818$ 181,336$ 46% October $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 90,715$ 98,922$ 113,373$ 15% November $22,654 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 77,577$ 84,596$ 119,897$ 42% December $37,906 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 87,323$ 95,223$ 100,034$ 5% Total $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 961,744$ 1,048,750$ 1,285,270$ 23% YTD $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 961,744$ 1,048,750$ 1,285,270$ 23% Y/Y chg -33.00%-10.72%-23.84%4.08%23.83%28.91%-0.49%69.93%3.41%3.84% 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 Sept 2017 12>$500k Jun 2016 11.7k acres for $27.4M, 6 Res>$500k Feb 2017 5 Res>$500k Oct 2017 2 sales @$1.31M and $1.445M, 6 res>$500k July 2016 284 ac for $1.2M, 6 Res > $500k Mar 2017 6 Res>$500k Nov 2017 12 sales>$500k Aug 2016 6 sales >$500k in JC Apr 2017 1@$1.098, 1@$1.035, 6 Res>$500k Dec 2017 1 sale @ $1.529M, 11>$500k 1/8/2018 $0 $50,000 $100,000 $150,000 $200,000 $250,000 REET RECEIPTS 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 1/8/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 $56,561 45,110$ 52,362$ $56,561 8.0% October $42,480 43,012$ 46,548$ 43,861$ 41,015$ $41,741 $43,659 $49,182 $59,970 $58,458 48,638$ 56,457$ $58,458 3.5% November $44,786 44,351$ 43,285$ 38,547$ 36,906$ $39,146 $46,879 $58,967 $57,999 $69,054 50,748$ 58,906$ $69,054 17.2%December $21,753 19,873$ 18,741$ 21,703$ 11,109$ $15,514 $33,858 $25,213 $26,084 $32,870 25,167$ 29,213$ $32,870 12.5% YTD $318,444 $321,231 $292,628 $293,344 $273,796 $295,200 $335,825 $386,107 $449,148 $507,868 $366,570 425,500$ $507,868 19.4% Total $318,444 $321,231 $292,628 $293,344 $273,796 $295,200 $335,825 $386,107 $449,148 $507,868 $366,570 425,500$ $507,868 $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 HOTEL/MOTEL LODGING TAX -Fund 125 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017