Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020-06_RevenueReports
JEFFERSON COUNTY TREASURER PO Box 571, Port Townsend WA 98368 Email: sprada@co.jefferson.wa.us Web: www.co.jefferson.wa.us Stacie Prada – Treasurer (360) 385-9150 Sabrina Hathaway – Chief Deputy (360) 385-9352 Page | 1 JEFFERSON COUNTY BUDGET COMMITTEE Treasurer’s Revenue Report June 2020 Revenue General Fund at $11,770,255 – 55.1% of the 2020 budget year to date which is slightly less than last year. Property tax collections are on track. PILT came in above our budgeted amount, so we should adjust that along with other COVID revenue adjustments in future budget amendments. Private Harvest Tax is lower year to date than the last six years. Interest on delinquent taxes is up. This month we had $11,993 in rollback interest which amounts to 1/3 of this month’s collections. Rollback interest is paid when a property is removed from the current use program, and it reflects back taxes and interest for 10 years based on current assessed value. I added a new sheet showing general fund revenue charts showing 2015-2020 year to date detail and percentage of full year collections. 2020 is shown as a percentage of our adopted budget. Other Funds at $17,148,300– 47.5% of 2020 budget year to date. Notably, Parks & Rec was negative this month and reflects $870 in refunds for programs and facilities that could not be used due to the Covid stay at home order. General Fund Cash Balance - $8,074,825 at the end of June which includes the $3.392 million budgeted reserve. This is slightly less than the amount for this time last year. This reserve amount will adjust as we modify budgeted expenditures for the remainder of 2020. General Sales Tax Receipts - $312,261 which includes $68,693 for Special Purpose in June 2020. General & Optional Sales tax is down 7.4% from this month last year and 1.6% under this month’s budgeted amount. It’s holding at 12% over budget for 2020 YTD due to a strong start for the year prior to the pandemic and stay at home order. Special Purpose was down 11% from this time last year and 11.7% under this month’s budget. Cumulatively they’re 8.3% less than this month last year, 3.7% under budget for the month but 9.12% over for YTD. The updated charts show the revenue per month back to 2005, the split of the two types of sales tax with amounts year to date and full year. The full year amount reflects YTD Actuals plus budgeted amount for the rest of 2020. 2020 Budget has not yet been adjusted due to COVID-19 impacts. Due to the two month time frame for processing and distribution to counties, This month’s sales tax revenue reflects a full month of our county with the Stay Home, Stay Safe. order. we saw the Page | 2 first impact with our revenues received in May. July might be similar, and we can hope it goes up in August when we receive sales tax revenue from June. Thankfully, we had a very strong beginning for 2020, It helped me to look at the dates of the proclamations to compare revenue and business activity. Heightened awareness occurred mid-March, and most businesses shut down effective March 23. REET Receipts - Fund 302 - $205,638 in June, which is almost twice as much as this month last year and 38% over budget for the month. Year to Date, REET Collections are almost 17% over budget and 20% over 2019YTD. $49,800 of the local REET was from the PLA and OPG sale where approximately 45,000 acres sold for $9.9 million. Two other sales were over $1 million, both single family residences in Port Ludlow. There were 19 sales in unincorporated Jefferson County in May with selling prices between $500,000 and $1 million. Nationally there have been news articles about people considering moves out of urban cities to more rural areas, and that seems to hold true for Jefferson County right now. Hotel/Motel Lodging Tax – Fund 125 - $742 in June, and $208 of that was investment interest. This puts it 98% under budget for the month. Year to date it is 26.4% under budget and 32.8% less than YTD in 2019. This is based on sales tax collected on sales two months prior. I added charts like I did for Sales Tax to show the revenue YTD and Full Year. 2020 is comprised of YTD actuals plus the amount budgeted for the rest of the year. I anticipate Hotel/Motel to be near zero for at least another month. 2020 6 June Jefferson County Treasurer 2-Jul-2020 General Fund REVENUE NAME BARS BUDGET QTRLY AMENDED JUN Y-T-D Y-T-D BUDGET Quarterly AMENDED ACTUAL JUN Y-T-D Y-T-D BUDGET ACTUAL JUN Y-T-D Y-T-D *2020 Approp Budget 2020 2020 2020 %2019 Approp Budget 2019 2019 2019 2019 %2018 2018 2018 2018 % of Actual Property Tax 1 311.10 8,290,037 8,290,037 101,692 4,664,204 56.3%8,021,323 8,021,323 7,992,860 45,010 4,574,488 57.0%7,850,027 7,805,908 57,650 4,423,105 56.7% Diverted Road Prop Tax 1 311.20 720,000 720,000 8,959 413,294 57.4%720,000 720,000 720,000 4,196 414,072 57.5%720,000 720,000 5,654 409,254 56.8% Sales Tax 1 313.11 3,326,609 3,326,609 243,568 1,671,112 50.2%3,204,826 192,869 3,397,695 3,601,761 263,069 1,582,475 46.6%3,040,000 3,195,259 248,506 1,416,669 44.3% special purpose 313.15 1,045,244 1,045,244 68,693 472,538 45.2%1,006,979 55,384 1,062,363 1,064,119 77,429 476,013 44.8%955,428 999,945 75,141 447,608 44.8% Local Criminal Justice 1 313.71 422,650 422,650 28,242 196,904 46.6%407,177 22,395 429,572 442,239 32,251 197,725 46.0%380,070 417,655 31,603 187,088 44.8% Leasehold Excise Tax 3 317.20 66,801 66,801 16,910 38,725 58.0%66,801 66,801 75,500 18,490 37,130 55.6%62,000 65,642 16,641 31,549 48.1% Private Harvest Tax - TAV 2 317.40.10/.20 339,599 339,599 0 137,325 40.4%339,599 339,599 363,246 - 259,278 76.3%335,000 537,635 - 309,599 57.6% P.I.L.T. (incl DNR)4332.15.23/336.02.31 1,015,150 1,015,150 1,572,825 1,572,825 154.9%1,015,136 537,328 1,552,464 1,553,455 1,537,328 1,537,328 99.0%1,867,988 1,850,941 1,833,818 1,833,818 99.1% P.U.D. Privilege Tax 4 335.00.91 386,555 386,555 0 0 0.0%375,296 375,296 385,397 - 0 0.0%323,420 393,491 - 0 0.0% Crim Just Hi Crime/DUI/Asst 5 336.06.10/51 451,770 451,770 0 248,894 55.1%438,612 438,612 336,086 - 209,259 47.7%463,500 425,438 - 216,268 50.8% Marijuana Enforcement/Excise 6 336.06.41/42 52,548 52,548 12,230 24,461 46.5%51,017 51,017 170,903 12,111 24,224 47.5%24,720 63,962 12,337 39,588 61.9% Liquor Excise Tax 8 336.06.94 48,267 48,267 0 27,160 56.3%47,321 47,321 51,439 - 26,177 55.3%41,536 47,254 - 23,707 50.2% Liquor Profit 6 336.06.95 90,650 90,650 20,844 41,687 46.0%88,873 88,873 83,623 20,968 41,936 47.2%90,203 84,066 21,065 42,130 50.1% Treasurer Invest & Other Fees 1 341.42.15-20/50 35,830 35,830 1,171 17,417 48.6%35,000 35,000 43,596 2,525 20,692 59.1%16,290 42,753 2,223 27,204 63.6% Treas. Collection Fees (REET)3 341.42.31/32/33 87,175 87,175 7,706 31,804 36.5%87,175 87,175 85,234 7,383 36,543 41.9%80,000 83,290 9,359 39,628 47.6% Penalties on delinquent taxes 1 359.40.10/.20 119,757 119,757 13,285 69,058 57.7%117,409 117,409 113,976 9,437 69,697 59.4%133,332 98,079 12,819 58,426 59.6% Investment Income 1 361.11 713,000 713,000 14,359 227,891 32.0%349,847 600,000 949,847 1,028,831 64,067 677,421 71.3%230,000 534,468 34,443 220,754 41.3% Interest on delinquent taxes 1 361.40.10 192,316 192,316 35,518 144,097 74.9%188,545 188,545 224,004 14,883 128,360 68.1%210,000 197,154 19,409 112,887 57.3% Interfund Chg Svc-Cost Alloc 3 362.50.00.180/0671 339,521 339,521 19,471 5.7%329,632 329,632 232,066 260 19,410 5.9%328,526 409,407 - 195,627 47.8% DNR Timber & DNRTimbTrust 2 1 395.1.1/335.02.33 250,000 250,000 54,065 200,962 80.4%250,000 250,000 500,000 352,075 - 314,772 63.0%250,000 330,761 1,016 5,923 1.8% Transfer in 1 397.00 3,000 3,000 0 25,572 852.4%8,000 8,000 21,798 16,393 20,298 253.7%3,000 42,992 11,212 19,194 44.6% Miscellaneous 1341.43/341.81/361.40.00/361.40.30/362.50.1/369.81/369.9 27,784 27,784 737 7,034 25.3%13,631 13,631 111,997 1,308 8,244 60.5%11,900 43,811 818 4,577 10.4% Assessor 1 001-010-000 8,300 8,300 5 3,828 46.1%8,300 8,300 9,642 23 3,844 46.3%8,700 8,542 171 3,985 46.6% Auditor-Recording Fees 1 341.21.10 69,495 69,495 8,310 40,226 57.9%70,510 70,510 69,039 5,607 29,696 42.1%72,063 70,227 6,086 35,255 50.2% Auditor-M.V. License Fees 1341.48+/336.00.93 246,440 16,370 262,810 17,561 152,192 57.9%229,257 229,257 302,603 16,970 129,958 56.7%232,703 234,383 16,584 118,406 50.5% Auditor-Other Revenue 1 35,330 35,330 1,431 12,036 34.1%42,450 42,450 35,127 2,937 17,949 42.3%26,605 34,184 3,102 16,600 48.6% Elections 1 001-021-000 116,110 116,110 274 303,127 261.1%130,160 130,160 161,606 - 98,704 75.8%159,722 101,546 13,563 89,791 88.4% Clerk 1 001-020-000 149,591 149,591 10,715 65,747 44.0%152,506 152,506 149,436 10,725 74,876 49.1%170,768 181,580 12,755 87,442 48.2% County Administrator 1 001-059-000 438,600 438,600 0 4,000 0.9%4,260 (560) 3,700 4,260 - 4,260 115.1%4,260 4,260 - 4,260 100.0% Commissioners 1 001-060-000 8,000 8,000 892 4,281 53.5%8,000 8,000 7,843 649 3,463 43.3%8,000 8,522 708 4,321 50.7% Safety & Security 1 001-067-000 75,538 75,538 15,857 67,399 89.2%70,604 70,604 36,232 - 28,578 40.5%64,959 44,082 - 30,414 69.0% Community Services 1 001-068-000 4,155 4,155 23 1,979 47.6%4,005 4,005 3,987 40 2,021 50.5%6,900 4,180 57 1,367 32.7% District Court 1 001-080-000 644,505 644,505 27,071 181,945 28.2%636,823 (612) 636,211 682,644 142,128 325,067 51.1%603,032 674,579 154,389 353,800 52.4% Juvenile Service 1 001-110-000 279,284 279,284 3,613 128,734 46.1%298,727 (13,500) 285,227 243,744 18,906 110,144 38.6%259,676 288,710 28,132 148,252 51.3% Prosecuting Attorney 1 001-150-000 320,633 320,633 7,958 72,974 22.8%148,916 16,789 165,705 257,902 20,423 96,132 58.0%178,690 110,543 7,049 50,849 46.0% Coroner 1 001-151-000 25,348 25,348 0 7,958 31.4%25,348 25,348 18,324 - 11,924 47.0%25,348 32,723 - 18,140 55.4% Sheriff 1 001-180-000 794,303 794,303 100,054 425,426 53.6%561,174 483,436 1,044,610 1,141,545 35,940 499,913 47.9%625,969 618,527 127,250 289,289 46.8% Superior Court 1 001-240-000 59,421 59,421 220 7,060 11.9%60,912 109 61,021 50,414 220 6,700 11.0%60,822 51,520 - 26,043 50.5% Non Departmental 1 001-270-000 35,568 35,568 2,589 38,913 109.4%50,437 25,000 75,437 39,722 - 34,152 45.3%50,447 32,802 - 32,802 100.0% TOTAL CURRENT EXPENSE REVENUE 21,334,884 16,370 21,351,254 2,397,377 11,770,255 55.1%19,664,588 2,168,638 21,833,226 22,268,272 2,381,676 12,152,923 55.7%19,975,604 20,890,820 2,763,560 11,375,619 54.5% * 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 excluded 388/89 0 3,771 26,903 0 1,319 7,436 0 4,138 15,006 June 2020 GENERAL FUND REVENUE NAME 2015 2016 2017 2018 2019 2020 Property Tax 4,197,581 4,270,081 4,347,627 4,423,105 4,574,488 4,664,204 Diverted Road Prop Tax 421,714 412,667 413,088 409,254 414,072 413,294 Sales Tax 1,139,719 1,247,500 1,337,617 1,416,669 1,582,475 1,671,112 special purpose 349,376 403,377 419,441 447,608 476,013 472,538 Local Criminal Justice 144,631 167,710 173,585 187,088 197,725 196,904 Leasehold Excise Tax 31,722 29,729 34,549 31,549 37,130 38,725 Private Harvest Tax 366,366 183,394 171,790 309,599 259,278 137,325 P.I.L.T. (incl DNR)1,253,823 1,422,312 1,390,772 1,833,818 1,537,328 1,572,825 P.U.D. Privilege Tax 370,446 318,107 314,148 - - - Crim Just Hi Crime/DUI/Asst 232,313 257,512 219,545 216,268 209,259 248,894 Marijuana Enforcement/Excise - 25,568 11,354 39,588 24,224 24,461 Liquor Excise Tax 8,488 21,411 22,491 23,707 26,177 27,160 Liquor Profit 42,582 42,439 42,310 42,130 41,936 41,687 Treasurer Invest & Other Fees 1,881 4,308 20,765 27,204 20,692 17,417 Treas. Collection Fees (REET)32,401 41,507 43,384 39,628 36,543 31,804 Penalties on delinquent taxes 65,384 65,356 56,126 58,426 69,697 69,058 Investment Income 16,293 54,628 207,851 220,754 677,421 227,891 Interest on delinquent taxes 130,203 129,313 114,785 112,887 128,360 144,097 Interfund Chg Svc-Cost Alloc 17,503 17,692 19,800 195,627 19,410 19,471 DNR Timber 325,972 224,129 4,884 5,923 314,772 200,962 Transfer in 5,000 21,687 19,546 19,194 20,298 25,572 Miscellaneous 14,284 14,629 3,267 4,577 8,244 7,034 Assessor 474 4,004 6,223 3,985 3,844 3,828 Auditor-Recording Fees 34,659 35,185 37,134 35,255 29,696 40,226 Auditor-M.V. License Fees 80,650 118,273 126,215 118,406 129,958 152,192 Auditor-Other Revenue 38,149 16,305 15,364 16,600 17,949 12,036 Elections 55,146 73,405 55,987 89,791 98,704 303,127 Clerk 105,981 97,578 88,514 87,442 74,876 65,747 County Administrator - - - 4,260 4,260 4,000 Commissioners 4,141 4,125 4,402 4,321 3,463 4,281 Safety & Security 15,003 27,802 29,574 30,414 28,578 67,399 Community Services 2,820 2,288 2,036 1,367 2,021 1,979 District Court 336,498 329,753 318,325 353,800 325,067 181,945 Juvenile Service 141,051 127,107 150,310 148,252 110,144 128,734 Prosecuting Attorney 132,279 75,571 88,714 50,849 96,132 72,974 Coroner 3,480 8,340 24,610 18,140 11,924 7,958 Sheriff 294,256 335,917 303,411 289,289 499,913 425,426 Superior Court 4,500 15,321 46,660 26,043 6,700 7,060 Non Departmental - 10 10 32,802 34,152 38,913 TOTAL CURRENT EXPENSE 10,416,768 10,646,041 10,686,214 11,375,619 12,152,923 11,770,255 TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET 18,950,211 19,246,395 19,181,590 20,890,820 19,975,604 21,351,254 YTD % of Full Year Actual/2020 Budget 55.0%55.3%55.7%54.5%60.8%55.1% - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 2015 2016 2017 2018 2019 2020 GENERAL FUND REVENUE YTD Non Departmental Superior Court Sheriff Coroner Prosecuting Attorney Juvenile Service District Court Community Services Safety & Security Commissioners County Administrator Clerk Elections Auditor-Other Revenue Auditor-M.V. License Fees Auditor-Recording Fees Assessor Miscellaneous Transfer in DNR Timber Interfund Chg Svc-Cost Alloc Interest on delinquent taxes Investment Income Penalties on delinquent taxes Treas. Collection Fees (REET) Treasurer Invest & Other Fees Liquor Profit Liquor Excise Tax Marijuana Enforcement/Excise Crim Just Hi Crime/DUI/Asst P.U.D. Privilege Tax P.I.L.T. (incl DNR) Private Harvest Tax Leasehold Excise Tax Local Criminal Justice special purpose Sales Tax Diverted Road Prop Tax Property Tax 55.0%55.3%55.7%54.5% 60.8% 55.1% 0.0% 20.0% 40.0% 60.0% 80.0% 100.0% 120.0% - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 2015 2016 2017 2018 2019 2020 GENERAL FUND YTD AND FULL YEAR ACTUAL/2020 BUDGET TOTAL CURRENT EXPENSE TOTAL CURRENT EXPENSE ACTUAL/2020 BUDGET YTD % of Full Year Actual/2020 Budget OTHER FUNDS REVENUE REPORT 2020 3 year view June 6 7/2/2020 FUND Fund #Orig Budget Budget Amended BDGT Jun YTD YTD Orig Budget Budget Amended BDGT Jun YTD YTD ACTUAL Jun YTD YTD 2020 Amendment 2020 2020 2020 %2019 Amendment 2019 2019 2019 %2019 2018 2018 % SPECIAL REVENUE HAVA COVID Grant 103 - - 153,422 165,309 Auditor's O & M 105 77,900 77,900 3,074 14,960 19.2%80,480 80,480 2,304 12,409 15.4%76,912 2,446 13,318 17.3% Court Facilitator 106 4,500 4,500 220 1,320 29.3%4,100 4,100 500 2,460 60.0%4,820 520 2,540 52.7% Boating Safety 107 50,000 50,000 - 30,384 60.8%48,500 1,638 50,138 - 32,085 64.0%47,887 - 30,607 63.9% WSU Cooperative 108 532,762 (69,310) 463,452 4,011 212,993 46.0%416,215 52,707 468,922 1,947 173,225 36.9%556,121 4,298 301,948 54.3% Noxious Weed 109 217,717 (23,700) 194,017 2,462 106,497 54.9%141,217 119,599 260,816 1,763 103,827 39.8% 4-H After School 113 Moved to Fund 108 - 47,600 47,600 12,000 44,732 94.0%37,750 - 32,250 85.4% JeffComCap 119 119 206,640 206,640 17,220 103,320 50.0%204,000 204,000 17,000 102,000 50.0%264,695 22,058 132,348 50.0% Crime Victim's Svc 120 81,543 81,543 1,737 51,666 63.4%140,813 140,813 418 55,285 39.3%113,502 1,799 53,491 47.1% Grant Mgmt 123 150,000 150,000 - 51,297 34.2%150,000 150,000 - 48,346 32.2%101,793 6,504 67,983 66.8% Hotel-Motel 125 521,444 521,444 742 137,145 26.3%500,500 500,500 43,299 203,995 40.8%542,805 36,556 190,187 35.0% Jeff Co Public Health 127 4,994,011 4,994,011 342,105 2,751,478 55.1%4,422,082 229,547 4,651,629 338,140 2,467,514 53.0%4,606,955 222,934 2,111,967 45.8% Water Quality 128 1,307,279 1,307,279 117,433 613,767 46.9%1,163,949 1,163,949 75,384 557,494 47.9%969,155 148,166 565,170 58.3% Water Quality Land Acq 129 115,000 115,000 - - 0.0%234,448 40,552 275,000 - - 0.0%132,825 - 0.0% Mental Health 130 50,289 50,289 960 28,911 57.5%47,637 47,637 366 29,594 62.1%50,132 433 27,326 54.5% Chem Dep Mnt Hlth tx 131 553,433 553,433 38,748 270,148 48.8%527,003 527,003 44,296 271,578 51.5%573,509 43,449 257,216 44.8% Drug Fund 135 13,850 13,850 2,600 4,696 33.9%12,249 12,249 197 4,041 33.0%14,395 1,658 7,181 49.9% Law Library 140 16,081 16,081 575 8,419 52.4%10,927 10,927 591 4,378 40.1%9,915 725 4,970 50.1% Trial Court Imprvmnt 141 23,000 23,000 - 14,168 61.6%23,000 23,000 - 11,400 49.6%23,201 - 11,605 50.0% Community Develpmnt 143 1,657,637 76,000 1,733,637 139,690 788,270 45.5%1,731,920 80,930 1,812,850 104,529 782,652 43.2%1,476,187 51,715 651,476 44.1% Federal Forest Title III 147 21,000 21,000 54 17,831 - - 236 20,190 20,164 107 573 2.8% Jeff Co Affrdbl Hsg 148 45,131 45,131 9,501 39,972 88.6%48,000 48,000 4,174 22,342 46.5%310,493 28,948 128,286 41.3% Homeless Housing Fund 149 272,874 272,874 32,506 160,852 58.9%315,000 272,282 587,282 25,303 135,085 23.0% Treasurer's O & M 150 54,650 54,650 4,033 13,082 23.9%47,624 47,624 6,049 13,827 29.0%46,224 5,451 13,788 29.8% REET technology 151 13,816 13,816 1,073 6,349 46.0%15,690 15,690 1,378 6,907 44.0%16,175 1,525 7,845 48.5% Veteran's Relief 155 65,510 65,510 984 47,680 72.8%64,975 25,015 89,990 558 48,291 53.7%105,484 536 45,022 42.7% Park & Rec 174 684,549 684,549 (610) 285,430 41.7%669,649 669,649 7,552 318,440 47.6%674,760 10,183 314,337 46.6% County Park Imprvmnt 175 171,625 31,360 202,985 2,661 37,484 18.5%184,125 (24,000) 160,125 100,074 118,883 74.2%155,581 35,524 98,139 63.1% Post Harvest Timber Mgmt Rsv178 - - 4 58 50 50 19 109 218.5% County Roads 180 8,801,630 8,801,630 357,621 4,396,843 50.0%8,938,628 (6,707) 8,931,921 203,613 4,647,053 52.0%8,929,361 208,083 4,231,547 47.4% Facilities Mgmt *507 eff 7/1/2020183 1,169,335 1,169,335 96,936 620,860 53.1%1,065,393 1,065,393 88,783 562,600 52.8%1,121,480 94,493 572,701 51.1% County Fair 199 280,000 515 280,515 19,116 101,635 36.2%252,937 19,061 95,819 37.9% Total Special Revenue 21,873,206 14,350 21,887,556 1,176,338 10,815,881 49.4%21,535,774 792,078 22,327,852 1,099,589 10,902,380 48.8%21,235,218 928,111 9,969,637 49.8% OTHER FUNDS REVENUE REPORT 2019 3 year view FUND Orig Budget Amended BDGT Jun YTD YTD Orig Budget Amended BDGT Jun YTD YTD YTD Jun YTD YTD 2020 2020 2020 2020 %2019 2019 2019 2019 %2018 2018 2,018 % CAPITAL IMPROVEMENT Const/Renovation 301 363,826 363,826 - 48,732 13.4%518,500 518,500 26,442 223,706 43.1%110,679 10,500 16,117 1.6% Capital Improvement 302 1,156,313 1,000,000 2,156,313 205,638 1,608,099 74.6%1,072,125 1,072,125 104,991 504,141 47.0%1,264,506 147,514 568,634 53.0% Public Infrastructure 306 565,000 565,000 35,328 249,806 44.2%510,100 510,100 42,095 257,711 50.5%536,758 40,816 240,347 53.2% Conservation Futures 308 271,860 271,860 5,365 156,608 57.6%258,841 258,841 3,334 163,588 63.2%284,064 3,231 149,479 62.4% Total CAP IMP 2,356,999 1,000,000 3,356,999 246,331 2,063,244 61.5%2,359,566 - 2,359,566 176,863 1,149,146 48.7%2,196,007 202,061 974,576 35.3% ENTERPRISE Solid Waste 401 3,718,073 3,718,073 339,885 1,848,516 49.7%3,336,196 300,117 3,636,313 346,478 1,857,385 51.1%3,680,126 210,319 1,557,748 46.4% Solid Waste Post Clos 402 - - 13 227 - - 99 595 979 81 428 285.2% Solid Waste Eqpt Res 403 15,000 15,000 258 4,494 30.0%8,000 8,000 1,757 10,576 132.2%15,780 1,279 6,685 167.1% Yard Waste Educ Fnd 404 7,000 7,000 1 21 0.3%6,800 6,800 19 112 1.6%5,765 9 47 0.8% Tri Area Sewer 405 982,500 23,087 1,005,587 246 153,107 15.2%234,500 69,132 303,632 1,476 43,746 14.4%42,268 1,094 5,860 2.3% Total ENTERPRISE 4,722,573 23,087 4,745,660 340,403 2,006,366 42.3%3,585,496 369,249 3,954,745 349,830 1,912,414 48.4%3,744,918 212,782 1,570,767 43.4% INTERNAL SERVICE Equipment Rental 501 2,617,745 2,617,745 185,741 1,024,671 39.1%2,421,684 717,803 3,139,487 181,402 1,087,777 34.6%2,950,721 162,849 918,060 37.5% Risk Management 502 150,000 150,000 - - 0.0%215,000 215,000 - 0 0.0%27,431 - - 0.0% Benefit Reserve 505 275,000 275,000 22,627 207,710 75.5%208,000 208,000 25,293 151,311 72.7%239,489 25,644 140,571 67.6% Information Services 506 1,968,639 1,076,937 3,045,576 2,983 1,030,429 33.8%1,901,855 295,210 2,197,065 5,230 922,406 42.0%2,004,180 1,279 995,307 45.6% Facilities Mgmt eff 7/1/2020 507 - - 1,065,393 1,065,393 88,783 562,600 52.8%1,121,480 94,493 572,701 51.1% Total INT SERV 5,011,384 1,076,937 6,088,321 211,351 2,262,809 37.2%4,746,539 1,013,013 5,759,552 211,925 2,161,494 37.5%5,221,821 189,771 2,053,939 40.6% Total 33,964,162 2,114,374 36,078,536 1,974,423 17,148,300 47.5%32,227,375 2,174,340 34,401,715 1,838,206 16,125,433 46.9%32,397,965 1,532,726 14,568,919 46.3% GENERAL FUND CASH BALANCE REPORT 7/2/2020 END OF MONTH CASH BALANCES 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 January 2,548,924$ 3,317,483$ 2,556,108$ 3,030,949$ 2,798,256$ 4,109,412$ 4,360,809$ 4,416,485$ 5,320,169$ 6,803,191$ February 1,882,264$ 3,023,683$ 1,802,345$ 2,041,248$ 2,202,079$ 3,278,685$ 3,622,756$ 3,681,133$ 4,464,746$ 6,243,097$ March 1,934,629$ 2,347,678$ 1,654,411$ 2,108,155$ 2,384,301$ 3,289,638$ 3,759,875$ 3,580,887$ 4,861,100$ 6,359,340$ April 3,819,239$ 4,144,298$ 3,732,606$ 4,429,017$ 4,572,778$ 5,181,554$ 5,391,984$ 5,572,170$ 7,300,275$ 8,452,851$ May 3,850,878$ 4,045,216$ 3,747,009$ 4,421,127$ 4,622,123$ 5,174,859$ 5,455,638$ 5,330,488$ 7,124,392$ 7,105,615$ June 4,081,060$ 3,980,389$ 4,663,469$ 4,818,824$ 5,866,387$ 6,413,636$ 6,593,259$ 6,795,577$ 8,169,229$ 8,074,825$ July 3,732,809$ 3,396,868$ 3,873,932$ 3,736,091$ 5,087,286$ 5,610,102$ 5,806,710$ 6,177,104$ 8,112,936$ August 2,974,460$ 2,394,180$ 3,010,467$ 2,898,623$ 4,203,581$ 5,416,407$ 5,111,812$ 5,237,488$ 6,926,951$ September 2,312,554$ 1,734,730$ 2,217,696$ 2,118,250$ 3,742,452$ 4,710,400$ 4,724,294$ 4,511,047$ 5,850,565$ October 4,339,258$ 4,098,330$ 4,148,666$ 4,133,005$ 5,804,449$ 6,326,563$ 6,245,727$ 6,682,718$ 8,291,898$ November 4,236,934$ 3,781,830$ 3,878,581$ 3,795,871$ 5,043,942$ 5,519,658$ 6,098,807$ 6,804,203$ 7,781,753$ December 3,862,223$ 3,346,366$ 3,605,804$ 3,694,709$ 4,808,162$ 5,384,768$ 5,201,817$ 6,038,266$ 7,658,281$ REQUIRED RESERVE ** (includes 10% of total expenditures and revenue stabilization reserve) 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Budg Total Reserve $ 1,666,150 $ 1,708,161 $ 1,786,000 $ 2,121,257 $ 2,140,726 $ 2,308,223 $ 2,589,184 $ 2,703,102 $ 3,281,222 $ 3,392,138 15% GF Budgeted Expenditures * $ 1,566,150 $ 1,608,161 $ 1,646,000 $ 1,681,257 $ 1,700,726 $ 1,806,223 $ 1,863,184 $ 1,977,102 $ 3,281,222 $ 3,392,138 Revenue Stabilization $ 100,000 $ 100,000 $ 140,000 $ 440,000 $ 440,000 $ 502,000 $ 726,000 $ 726,000 n/a n/a * In 2019, Resolution 41-19 changed the reserve to 15% of the GF Total Spending and eliminated the Revenue Stabilization Reserve - changes with appropriations throughout year $- $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 January February March April May June July August September October November December General Fund Cash Balance 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 6 June 6/29/2020 General Fund Treasurer 001-250-000 Sales 313.11 Special Purpose 313.15 MONTHLY SALES TAX RECEIPTS Revenue Cumulative Cumulative Year End 3 yr. avg Expected Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/Under January 154,373 180,283 156,597 207,318 152,937 133,849 137,774 137,615 177,776 176,956 163,811 185,292 185,505 207,899 258,313 303,235 6.7%224,122 303,235 $79,114 135.30%$4,500,882 $1,174,273February224,687 244,043 249,049 206,809 219,448 215,617 201,110 206,281 227,634 218,000 239,784 263,305 310,729 279,301 314,528 355,834 9.4%311,072 355,834 $44,762 123.15%$4,096,584 $769,975March142,119 161,270 157,709 170,679 177,252 122,153 136,282 115,959 194,619 156,957 164,393 194,466 189,576 206,999 241,958 251,543 6.6%219,588 251,543 $31,956 120.65%$4,013,416 $686,807 April 156,731 170,147 181,390 162,253 148,592 131,100 127,885 124,117 174,718 154,216 167,550 181,384 193,862 202,532 209,415 249,173 6.3%208,334 249,173 $40,839 120.42%$4,005,909 $679,300 May 198,754 211,995 207,595 212,586 181,514 175,118 178,468 151,451 195,175 178,074 207,951 226,291 249,596 271,431 295,191 267,758 8.4%280,693 267,758 -$12,935 114.77%$3,818,015 $491,406June 164,380 165,275 175,802 167,706 172,947 133,593 154,669 133,909 166,750 156,362 196,231 196,762 208,349 248,506 263,069 243,568 7.4%247,577 243,568 -$4,009 107.94%$3,590,720 $264,111July187,091 235,150 199,236 174,881 159,276 136,373 166,276 155,881 188,957 174,130 185,889 204,143 236,448 262,489 308,592 8.3%277,705 - August 220,873 241,022 250,665 244,562 199,901 184,345 187,132 192,602 219,583 238,784 257,369 276,309 293,953 309,575 355,294 9.9%329,733 - September 211,602 211,286 200,636 213,505 187,214 173,733 169,379 242,312 198,879 212,018 227,766 247,376 241,325 307,750 319,609 9.0%298,735 - October 213,751 244,393 214,468 212,410 168,681 161,452 182,962 203,958 214,572 208,256 239,390 254,002 267,264 306,832 334,704 9.4%312,531 - November 253,367 234,710 263,159 239,855 213,651 200,463 180,293 206,475 220,843 231,070 240,812 293,377 279,959 311,101 363,975 9.9%328,431 - December 183,910 170,134 197,603 197,943 155,866 150,355 146,560 176,593 169,167 196,112 195,665 215,537 219,772 280,843 337,112 8.7%288,089 - TTL 2,311,638 2,469,708 2,453,909 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 3,195,259 3,601,761 1,671,112 100.0%$3,326,609 $1,671,112 $179,726 $3,590,720 $264,111 ytd 1,041,044 1,133,013 1,128,142 1,127,351 1,052,690 911,430 936,188 869,332 1,136,672 1,040,565 1,139,719 1,247,500 1,337,617 1,416,669 1,582,475 1,671,112 1,491,386 1,671,112 179,726 ytd change 8.83%-0.43%-0.07%-6.62%-13.42%2.72%-7.14%30.75%-8.46%9.53%9.46%7.22%5.91%11.70%5.60%12.05%over (under) ytd expectedannual % chg.6.84%-0.64%-1.77%-11.33%-10.25%2.64%3.98%14.73%-2.03%8.07%10.12%5.04%11.09%12.72% Special Purp./Public Safety Tax Cumulative Cumulative Year EndActual3 yr avg.Projection Actual Over/Under % of projection20052006200720082009201020112012201320142015201620172018201920202017-19 2020 2020 Expected expected Projection Over/Under January 45,217 50,919 50,377 51,210 58,026 61,161 66,993 79,236 84,751 7.0%73,057 84,751 $11,695 116.01%$1,212,562 $167,318 February 61,899 70,678 67,508 73,364 83,521 93,242 90,853 94,690 101,181 9.4%98,207 101,181 $2,973 103.03%$1,076,892 $31,648 March 40,604 56,106 49,782 50,931 62,285 61,183 66,479 70,614 72,888 6.7%69,846 72,888 $3,042 104.35%$1,090,764 $45,520April43,155 51,054 47,573 52,541 59,481 59,911 63,784 65,310 69,887 6.4%66,580 69,887 $3,306 104.97%$1,097,151 $51,907May51,908 58,324 56,012 62,613 74,233 78,716 84,357 88,754 75,138 8.5%88,710 75,138 -$13,572 84.70%$885,324 -$159,920 June 45,930 46,797 50,067 48,647 58,717 65,832 65,229 75,141 77,429 68,693 7.3%76,724 68,693 -$8,031 89.53%$935,839 -$109,405 July 55,488 49,385 68,295 54,074 56,793 69,908 73,136 81,117 89,815 8.2%85,977 - August 59,578 56,220 56,063 68,712 76,734 87,275 89,679 97,261 107,514 9.9%103,727 - September 55,746 54,902 61,455 64,622 72,022 77,854 77,534 97,036 94,733 9.1%94,867 - October 59,692 61,120 64,400 64,152 73,903 82,028 82,991 95,473 97,187 9.3%97,103 - November 58,107 60,952 64,915 71,491 77,947 89,596 90,736 98,020 105,075 9.9%103,507 - December 46,767 49,281 52,177 59,043 62,263 66,133 69,582 83,431 93,783 8.3%86,938 - TOTAL 381,308 621,440 704,453 701,993 769,039 876,170 903,099 999,945 1,064,140 472,538 100.0%1,045,244 472,538 (587) 935,839 (109,405) ytd 45,930 289,580 337,148 319,899 349,376 403,377 419,441 447,608 476,033 472,538 473,125 $472,538 -$587 ytd change 16.43%-5.12%9.21%15.46%3.98%6.72%6.35%-0.73%-0.12%over (under) ytd expected annual % chg.62.98%13.36%-0.35%9.55%13.93%3.07%10.72%6.42% Sales Tax receipts are for the approximate timeframe of two months prior depending on the business reporting schedules.3 yr avg.Projection Actual Over/Under % of projectionSales Tax 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected Projection Over/Under General & Optional YTD1,041,044 1,133,013 1,128,142 1,127,351 1,052,690 911,430 982,118 1,158,912 1,473,820 1,360,465 1,489,095 1,650,877 1,757,058 1,864,276 2,058,508 2,143,649 #VALUE!1,964,510 2,143,649 179,139 3,590,720 264,111 Special Purpose YTD - - - - - - 45,930 289,580 337,148 319,899 349,376 403,377 419,441 447,608 476,033 472,538 473,125 472,538 (587) 935,839 (109,405) G&O and SP Sales Tax YTD1,041,044 1,133,013 1,128,142 1,127,351 1,052,690 911,430 1,028,048 1,448,492 1,810,968 1,680,364 1,838,472 2,054,253 2,176,498 2,311,884 2,534,540 2,616,187 #VALUE!2,437,635 2,616,187 178,552 4,526,560 154,707 Full Year Total Actual w/ 2020 Budget2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 4,371,853 2,143,649 4,371,853 - - MONTHLY SALES TAX GENERAL & OPTIONAL AND SPECIAL PURPOSE Revenue Cumulative Cumulative Year End 3 yr. avg Expected Actual Over/Under % of projection 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2017-19 2020 2020 Expected expected ProjectionYear End Projected Over/Under Budget January 154,373 180,283 156,597 207,318 152,937 133,849 137,774 182,832 228,695 227,333 215,021 243,317 246,667 274,892 337,549 387,987 8.9%297,178 387,987 $90,808 130.56%$5,713,443 $1,341,590 February 224,687 244,043 249,049 206,809 219,448 215,617 201,110 268,180 298,312 285,508 313,148 346,826 403,971 370,154 409,218 457,015 12.2%409,279 457,015 $47,736 111.66%$5,173,476 $801,623 March 142,119 161,270 157,709 170,679 177,252 122,153 136,282 156,563 250,725 206,739 215,324 256,751 250,759 273,478 312,572 324,431 8.7%289,434 324,431 $34,997 112.09%$5,104,180 $732,327April156,731 170,147 181,390 162,253 148,592 131,100 127,885 167,272 225,772 201,789 220,090 240,865 253,772 266,316 274,725 319,060 8.2%274,914 319,060 $44,145 116.06%$5,103,060 $731,207May198,754 211,995 207,595 212,586 181,514 175,118 178,468 203,359 253,499 234,086 270,564 300,523 328,312 355,788 383,945 342,896 11.0%369,403 342,896 -$26,507 92.82%$4,703,340 $331,487 June 164,380 165,275 175,802 167,706 172,947 133,593 200,599 180,706 216,817 205,010 254,948 262,594 273,577 323,647 340,499 312,261 9.7%324,301 312,261 -$12,040 96.29%$4,526,560 $154,707 July 187,091 235,150 199,236 174,881 159,276 136,373 221,764 205,266 257,252 228,204 242,682 274,051 309,584 343,606 398,407 - 10.9%363,682 - August 220,873 241,022 250,665 244,562 199,901 184,345 246,710 248,822 275,646 307,496 334,103 363,584 383,632 406,836 462,808 - 13.0%433,460 - September 211,602 211,286 200,636 213,505 187,214 173,733 225,125 297,214 260,334 276,640 299,788 325,230 318,859 404,786 414,342 - 11.8%393,602 - October 213,751 244,393 214,468 212,410 168,681 161,452 242,654 265,078 278,972 272,408 313,293 336,030 350,255 402,305 431,890 - 12.2%409,634 - November 253,367 234,710 263,159 239,855 213,651 200,463 238,400 267,427 285,758 302,561 318,760 382,973 370,695 409,120 469,051 - 12.9%431,938 - December 183,910 170,134 197,603 197,943 155,866 150,355 193,327 225,874 221,344 255,155 257,928 281,670 289,354 364,274 430,895 - 11.2%375,028 - TTL 2,311,638 2,469,708 2,453,909 2,410,507 2,137,279 1,918,151 2,350,098 2,668,593 3,053,126 3,002,929 3,255,650 3,614,414 3,779,438 4,195,203 4,665,900 2,143,649 109.6%$4,371,853 $2,143,649 ytd 1,041,044 1,133,013 1,128,142 1,127,351 1,052,690 911,430 982,118 1,158,912 1,473,820 1,360,465 1,489,095 1,650,877 1,757,058 1,864,276 2,058,508 2,143,649 1,964,510 2,143,649 ytd change 8.83%-0.43%-0.07%-6.62%-13.42%7.76%18.00%27.17%-7.69%9.45%10.86%6.43%6.10%10.42%4.14%9.12%over (under) ytd expectedannual % chg.6.84%-0.64%-1.77%-11.33%-10.25%22.52%13.55%14.41%-1.64%8.42%11.02%4.57%11.00%11.22% - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 GENERAL & OPTIONAL SALES TAX RECEIPTS BY MONTH AND YEAR (Does not include Special Purpose/Public Safety Tax) June 2020 December November October September August July June May April March February January - 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 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Sales Tax and Special Purpose Sales Tax YTD, Actual Total and 2020 Budget June 2020 Special PurposeYTD General & Optional YTD Full Year Total Actual w/ 2020 Budget - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 1 2 3 4 5 6 7 8 9 10 11 12 2020 Monthly Actual Revenue & Budgeted Share Actual 2020 Expected 2020 -$500,000 $500,000 $1,500,000 $2,500,000 $3,500,000 $4,500,000 $5,500,000 1 2 3 4 5 6 7 8 9 10 11 12 2020 Cumulative YTD Actual & Budget Expected by Month Year End Projected Over/Under Budget YTD Budget YTD Actual 6 June 302-000-010 Capital Improvement fund, not other financing sources, transfer, appropriation Recent 2020 % Budget Month Change 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 4 YR AVG Budget Difference prior year January $78,294 $83,384 $72,424 $45,530 123,064$ 28,601$ 56,823$ 28,435$ 28,059$ 44,132$ 33,177$ 57,144$ 78,597$ 49,830$ 64,496 69,086 62,517 57,998 19.1%7.1% February $112,120 $74,250 $65,590 $45,612 10,730$ 22,594$ 66,268$ 30,745$ 18,846$ 26,888$ 48,279$ 51,148$ 47,854$ 65,067$ 51,891 84,560 53,990 50,087 68.8%63.0% March $92,812 $82,868 $58,766 $63,286 66,768$ 44,044$ 34,138$ 39,257$ 42,889$ 40,689$ 168,735$ 79,657$ 91,388$ 75,558$ 82,105 93,964 82,177 76,237 23.3%14.4% April $105,772 $83,776 $95,258 $105,272 20,838$ 54,965$ 21,847$ 35,754$ 60,839$ 55,546$ 61,766$ 77,161$ 78,523$ 102,480$ 89,657 78,860 86,955 80,670 -2.2%-12.0% May $124,210 $125,632 $86,666 $49,638 34,242$ 36,932$ 27,146$ 59,286$ 50,555$ 62,184$ 73,099$ 108,945$ 111,101$ 128,185$ 111,001 75,991 114,808 106,509 -28.7%-31.5% June $164,122 $137,630 $89,338 $54,812 30,788$ 35,648$ 37,194$ 44,068$ 63,205$ 71,373$ 118,836$ 241,046$ 147,551$ 147,514$ 104,991 205,638 160,276 148,690 38.3%95.9% July $132,668 $117,584 $108,226 $57,890 43,154$ 34,393$ 36,658$ 28,856$ 57,623$ 67,722$ 110,603$ 105,451$ 105,582$ 108,763$ 136,683 114,120 105,871 August $133,848 $355,084 $92,362 $58,240 46,658$ 31,371$ 30,855$ 43,974$ 71,327$ 55,685$ 92,001$ 125,719$ 110,037$ 131,097$ 130,942 124,449 115,453 September $147,903 $104,040 $67,136 $39,174 47,520$ 46,444$ 37,641$ 54,626$ 67,050$ 71,552$ 219,697$ 95,883$ 181,336$ 117,652$ 105,075 124,986 115,952 October $203,764 $89,674 $100,551 $46,562 31,806$ 31,382$ 34,231$ 66,934$ 57,808$ 65,594$ 102,267$ 137,192$ 113,373$ 119,144$ 134,016 125,931 116,828 November $126,964 $99,990 $52,266 $22,654 54,154$ 31,746$ 33,220$ 67,226$ 127,615$ 41,510$ 66,034$ 75,151$ 119,897$ 96,368$ 110,009 100,356 93,102 December $97,838 $113,314 $46,605 $37,906 49,676$ 27,938$ 27,429$ 49,960$ 62,067$ 101,510$ 102,439$ 83,276$ 100,034$ 74,910$ 125,158 95,845 88,917 Total $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $608,099 1,246,409$ 1,156,313$ -47.4%-51.2% YTD 677,330 587,540 468,042 364,150 286,430 $187,136 243,416 237,545 264,393 300,812 503,893 615,102 555,012 568,634 504,140 608,099 560,722$ 520,191$ 16.9%20.6% YTD change -13.26%-20.34%-22.20%-21.34%-34.67%10.20%-2.41%11.30%13.77%67.51%22.07%-9.77%2.45%-11.34%20.62% Annual % chg -13.26%-20.34%-22.20%-21.34%4.08%23.83%28.91%-0.49%69.93%3.41%3.84%-5.35%2.42% Actual Full Year or Budget $1,520,315 $1,467,226 $935,188 $626,576 $559,398 $426,058 $443,450 $549,121 $707,883 $704,385 $1,196,934 $1,237,774 $1,285,270 $1,216,569 $1,246,024 $1,156,313 Total Sales Value for year incl City of PT 219,533,884 237,164,120 348,155,918 395,379,956 404,420,675 365,442,489 369,816,284 Jan 2019 7 sales>$500k Jul 2019 1@$3.3M, 16>$500k Jan 2020 9 sales>$500k Feb 2019 1@$1M, 4 sales>$500k Aug 2019 2@$1.25M &1.2M, 12>$500k Feb 2020 1@1.2M & 6 sales>$500k Mar 2019 1@$1.4M, 6 sales>$500k Sep 2019 1@$1.25M & 1.425M, 11>$500k Mar 2020 1@1.025M & 10 sales>$500k Apr 2019 9 sales>$500k Oct 2019 2@$1.475M and 1.5M, 6>$500k Apr 2020 8 sales>$500k May 2019 1@1.045M, 9 sales>$500k Nov 2019 2@$1.75M & 1.1M, 12>$500k May 2020 1@$1.3M and 6>$500k Jun 2019 1@$2.36M & 1@ $1.275M, 7>$500k Dec 2019 1@$2.61, 4@$1+,10>$500k June 2020 3 sales over $1M: $9.9M, $1.07M & $1.375M; and 19 sales>$500k 7/1/2020 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Real Estate Excise Tax Collections -2005 to Present Fund 302 Capital Improvement Fund June 2020 December November October September August July June May April March February January Actual Full Year or Budget $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 REET YTD, Actual Total and 2020 Budget YTD Actual YTD Budget 0 50,000 100,000 150,000 200,000 250,000 2020 Monthly Actual Revenue & Budgeted Share 2020 Actual Budget June 7/1/2020 4 yr avg *2020 2020 % Budget % Diff 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2016-19 Budget Actual Difference Prior Year January 16,089 11,507 12,045 8,863 13,575 17,051 18,473 19,394 23,177 29,854 32,023 22,725 22,792 32,023 40.5%7.3% February 27,998 25,532 23,188 38,274 30,356 36,141 51,077 53,093 46,226 41,186 34,092 47,895 48,037 34,092 -29.0%-17.2% March 22,623 12,406 7,271 11,203 12,715 14,345 14,554 16,889 19,419 25,281 29,621 19,035 19,092 29,621 55.2%17.2% April 11,344 10,791 14,950 11,430 12,427 14,983 18,530 20,901 23,749 22,829 29,140 21,502 21,566 29,140 35.1%27.6% May 19,646 25,142 17,142 18,010 19,151 23,886 29,462 45,943 41,061 41,546 11,527 39,503 39,620 11,527 -70.9%-72.3% June 19,205 17,302 17,916 16,477 18,786 25,070 29,476 31,485 36,556 43,299 742 35,204 35,308 742 -97.9%-98.3% July 20,155 19,311 20,201 21,512 24,536 27,711 33,687 38,400 44,445 48,748 41,320 41,442 August 35,178 24,742 31,171 33,140 37,534 48,845 56,349 64,820 64,934 70,516 64,155 64,345 September 41,757 42,500 40,882 39,890 42,349 44,713 53,487 56,561 68,870 88,306 66,806 67,004 October 43,012 43,861 41,015 41,741 43,659 49,182 59,970 58,458 65,200 60,682 61,077 61,258 November 44,351 38,547 36,906 39,146 46,879 58,967 57,999 69,054 63,101 65,013 63,792 63,980 December 19,873 21,703 11,109 15,514 33,858 25,213 26,084 32,870 46,067 42,545 36,892 37,001 Full Year 321,231 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 137,145 519,906 521,444 137,145 YTD 116,905 102,680 92,512 104,257 107,010 131,476 161,572 187,705 190,187 203,995 137,145 185,865 186,415 137,145 -26.4%-32.8% Full Year Actual/2020 Budget 293,344 273,796 295,200 335,825 386,107 449,148 507,868 542,805 579,805 521,444 YTD Change 15.70%-9.90%12.70%2.64%22.86%22.89%16.17%1.32%7.26%-32.77% Annual % Change 0.24%-6.66%7.82%13.76%14.97%16.33%13.07%6.88%6.82%$521,444 2020 Budget 2% Basic RCW 67.28.181(1).RCW 67.28.180 2% Special RCW 67.28.181(1).11% Total sales tax paid on a lodging charges for periods of less than 30 consecutive days Revenue reflects 2% "basic" as a credit against 6.5% state sales tax, 2% "special" tax levied locally, interest on amounts held at DOR until disbursement, and 1% Admin fee from DOR. Revenue is reported one month after reporting to DOR. It typically reflects collections for activity from two months prior to distribution. Some businesses may report quarterly or annually. 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 December November October September August July June May April March February January $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2020 YTD Actual and Budget YTD Actual YTD Budget 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 2020 Monthly Actual and Budget 2020 Actual Budget