Loading...
HomeMy WebLinkAbout201911, Novemberh:\finance\financial reporting\monthly reports\2019 reports\cover 1119.docx  ADMINISTRATIVE SERVICES  M   E   M   O   R   A   N   D   U   M  DATE:  TO:  CC:  FROM:  STAFF CONTACT:  SUBJECT:  January 23, 2020  Ruth Pérez, Council President  Members of Renton City Council  Armondo Pavone, Mayor  Bob Harrison, Chief Administrative Officer  Jan Hawn, ASD Administrator  Misty Baker, Sr. Finance Analyst  November 2019 Financial Status Report  At the end of November, general governmental revenues show $5.3M or 4.5% over  budget.  Revenue source(s) that are higher than expected are:   Property Tax ‐ $624K (pg 2) Local Retail Sales Tax  ‐ $539K (pg 3) Criminal Justice Sales Tax ‐ $351K (pg 3) Utility Tax ‐ $182K (pg 4) Gambling Excise Tax ‐ $448K (pg 5) Real Estate Excise Tax ‐ $996K (pg 5) B&O Tax ‐ $1.6M (pg 6) Business Licenses ‐ $133K (pg 7) Building Permits ‐ $266K (pg 8) State Shared Revenue ‐ $339K (pg 9) Development Services ‐ $175K (pg 10) Interest and Other Investment Earnings ‐ $310K (pg 12) On the down side, the revenue source(s) that are underperforming the year to date  budget are:   Franchise Fees – $127K (pg 7) Interfund Services – $594K (pg 10) General government expenditures showed a favorable variance of $7.5M or 6.5%. See  page 12 of report for further expenditure over‐spent explanations.  Don Persson, Council President  Members of Renton City Council  Page 2 of 2  January 23, 2020    h:\finance\financial reporting\monthly reports\2019 reports\cover 1119.docx   The attached report provides more detailed discussion of each revenue source and our  updated projections for the year.  Please do not hesitate to contact me at x6869 should  you have any questions or any suggestions about the report.      Page 1 of 16   General Governmental Funds $% Beginning Fund Balance 24,413,781$     24,413,781$    31,534,619$       31,534,619$      44,542,987$    44,542,987$ 44,578,377$   35,390               0.1% OPERATING REVENUES Taxes 79,228,239        74,342,488       79,899,075          74,489,498         84,027,220       78,807,198    83,624,294      4,817,096        6.1% Licenses & Permits 5,985,115           5,704,805          5,499,201             5,231,808            5,404,552          5,158,753       5,399,708         240,955            4.7% Intergovernmental 4,210,533           3,268,506          4,162,854             3,554,946            5,462,108          4,202,402       4,201,144         (1,258)                 0.0% Charges for Services 8,588,772           7,946,092          8,531,218             7,934,638            9,291,414          8,598,880       8,358,481         (240,400)            ‐2.8% Fines and Penalties 2,946,849           2,620,911          4,273,192             3,867,757            4,907,750          4,399,713       4,283,302         (116,411)            ‐2.6% Miscellaneous 3,649,183           3,074,335          3,667,475             3,293,091            3,238,358          2,806,641       3,374,067         567,425            20.2% Other Financing Sources (Transfer‐In, etc) 124,517                108,951               (282,188)                (310,953)               13,229,818       11,992,736    11,997,956      5,221                  0.0% Total Operating Revenues 104,733,207     97,066,088       105,750,828       98,060,785         125,561,221    115,966,324 121,238,951   5,272,627        4.5% OPERATING EXPENDITURES Council 362,101                331,903               377,512                  347,364                414,780               380,938            327,404             53,534               14.1% Executive 1,954,748           1,737,132          2,073,371             1,857,537            2,710,212          2,418,577       2,249,707         168,871            7.0% Emergency Management 569,333                523,795               590,655                  542,637                705,470               648,572            566,653             81,920               12.6% City Attorney 2,088,718           1,908,369          2,216,692             2,025,478            2,400,893          2,193,692       2,151,191         42,502               1.9% Court Services 2,174,217           1,982,165          2,222,633             2,037,380            2,701,599          2,469,768       2,173,525         296,243            12.0% Community and Eco Dvlpmnt Admin 1,351,830           1,227,699          1,347,568             1,231,488            1,599,054          1,456,760       1,390,992         65,768               4.5% Development Services 2,181,211           2,090,476          2,211,136             2,002,520            2,526,232          2,354,062       2,115,806         238,256            10.1% Economic Development 949,467                815,203               833,055                  676,396                2,374,400          1,986,877       934,830             1,052,047        52.9% Planning 3,657,665           3,267,791          3,843,116             3,497,023            4,316,773          3,893,218       3,463,909         429,308            11.0% Finance 3,132,609           2,501,966          3,427,262             2,717,481            3,617,820          2,878,566       2,714,334         164,232            5.7% City Clerk 1,119,376           976,122               1,274,941             1,162,960            1,344,720          1,201,373       1,134,046         67,326               5.6% Human Resources 1,221,841           1,116,195          1,268,733             1,159,905            1,553,349          1,419,584       1,313,375         106,209            7.5% Police 30,987,047        28,168,125       33,764,563          29,576,070         37,607,126       33,537,285    32,633,239      904,046            2.7% Jail Services 4,807,443           4,406,898          5,970,673             5,473,305            6,237,344          5,717,718       5,285,757         431,962            7.6% Community Services Admin 1,421,803           1,093,876          1,522,994             1,243,795            1,578,479          1,253,045       1,338,117         (85,071)               ‐6.8% Parks & Trails 4,926,587           4,415,236          5,026,203             4,633,501            5,464,268          4,967,927       4,831,597         136,329            2.7% Parks Planning & Natural Resources 1,059,058           938,972               1,114,153             995,748                2,499,025          2,224,779       1,365,491         859,288            38.6% Recreation & Neighborhoods 6,152,644           5,632,130          6,280,121             5,706,964            6,699,548          6,110,210       5,857,126         253,084            4.1% Human Services 1,634,387           1,256,572          1,421,280             1,237,010            1,585,266          1,293,659       1,272,285         21,374               1.7% Museum 235,712                215,835               245,590                  225,283                252,671               231,575            231,898             (324)                      ‐0.1% Public Works Admin 406,781                373,534               417,786                  383,470                426,696               391,733            389,870             1,864                  0.5% Street Maintenance 5,603,141           5,132,052          5,676,989             4,990,195            5,909,878          5,303,240       5,059,067         244,174            4.6% Transportation 5,368,887           4,645,164          5,550,779             5,108,863            8,339,426          7,449,219       5,491,191         1,958,028        26.3% Non‐Departmental and Other 14,245,763        2,884,877          4,064,656             2,767,618            30,928,518       22,649,444    22,649,444       ‐                        0.0% Total Operating Expenditures 97,612,369        77,642,085       92,742,459          81,599,992         133,793,547    114,431,820 106,940,852   7,490,967        6.5% Total Ending Fund Balance 31,534,619$     43,837,784$    44,542,987$       47,995,411$      36,310,660$    46,077,491$ 58,876,476$   12,798,984$  27.8% Favorable (Unfavorable) 2017 2018 2019 Variance Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual      Monthly Financial Report November 2019  Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 2 of 16   OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through November 30, 2019.  Except as  noted, year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement  patterns for the same period of the preceding two (2) years.  The table on the previous page summarizes the general  governmental funds revenues and expenditures.    REVENUES    Taxes     Taxes comprise 69% of all resources supporting general governmental activities. Taxes are broken down as follows:  2017 2018 2019 2019 Actual Actual Budget Actual $ % $ % Property Tax 19,570,781$   16,877,468$      20,292,413$       20,916,798$      4,039,330$    23.9% 624,385$           3.1% Local Retail Sales Tax 24,283,370      26,125,452         25,366,860          25,905,840         (219,612)           ‐0.8%538,980              2.1% State Sales Tax Credit ‐ Annexation/LRF 2,879,980         1,619,553            187,500                 255,497                 (1,364,056)      ‐84.2%67,997                 36.3% Criminal Justice Sales Tax 2,571,958         2,811,457            2,634,176             2,985,319            173,862           6.2% 351,143              13.3% Natural Gas Use Tax 169,071              133,158                 215,969                 210,521                 77,363              58.1%(5,448)                   ‐2.5% Admission Tax 178,503              225,466                 135,069                 196,087                 (29,379)              ‐13.0%61,018                 45.2% Utility Tax 15,382,442      14,782,532         14,018,335          14,200,114         (582,418)           ‐3.9%181,779              1.3% Leasehold Excise Tax 132,905              134,656                 132,002                 129,571                 (5,085)                 ‐3.8% (2,431)                   ‐1.8% Gambling Excise Tax 2,430,320         2,470,879            2,217,170             2,664,697            193,818           7.8% 447,527              20.2% Real Estate Excise Tax ‐                                 ‐                                   4,108,653             5,104,555            5,104,555       100.0% 995,902              24.2% B&O Tax 6,743,159         9,308,876            9,499,050             11,055,295         1,746,419       18.8% 1,556,245         16.4% YTD Total 74,342,488$   74,489,498$      78,807,198$       83,624,294$      9,134,796$    12.3% 4,817,096$      6.1% Annual Total 79,228,239$   79,899,075$      84,027,220$        Taxes by Type Revenue 2019 vs. 2018 2019 vs. Budget Year to Date through November     In the past, some taxes were allocated between the General Fund, Debt Service Fund, and Capital Project Funds. Beginning  in 2019, 100% of tax revenues are accounted for in the General Fund. For comparability purposes, the monthly tables  presented below are shown for total taxes received.    Property Tax  Property Tax revenues are budgeted based on the previous four (4) years’ collection rates. The 2019 property tax levy is  $1.9M more than 2018, which accounts for the majority of the 7.9% increase in collections over 2018. Year‐to‐date collections  are 3.1% higher than budget. The City is projecting Property Tax revenues to be around $21.5M by the end of the year.   2018 2019 2019 Actual Budget Actual $ % $ % Jan (12,745)$           17,768$                 39,879$            52,624$           ‐412.9%22,111$           124.4% Feb 106,364            229,128                 192,217            85,853              80.7%(36,911)             ‐16.1% Mar 665,471            563,923                 764,729            99,258              14.9% 200,806           35.6% Apr 6,908,633        5,382,248            7,158,264        249,631           3.6% 1,776,016      33.0% May 2,419,925        4,168,250            2,852,933        433,008           17.9%(1,315,317)      ‐31.6% Jun 108,842            92,118                    (1,679,877)      (1,788,719)      ‐1643.4% (1,771,996)      ‐1923.6% Jul 90,072               317,474                 1,798,442        1,708,370      1896.7% 1,480,968      466.5% Aug 84,185               295,005                 61,965               (22,220)             ‐26.4% (233,040)          ‐79.0% Sep 196,536            270,686                 317,271            120,735           61.4% 46,584              17.2% Oct 7,077,878        4,494,739            6,996,376        (81,502)             ‐1.2%2,501,636      55.7% Nov 1,742,104        4,461,073            2,414,600        672,496           38.6%(2,046,473)      ‐45.9% Dec 76,196               592,841                  ‐                               YTD Total 19,387,265$  20,292,413$      20,916,798$  1,529,533$   7.9% 624,385$        3.1% Annual Total 19,463,461$  20,885,254$       *Total Property Tax (GF & DS) Property Tax* Year to Date through November Month 2019 vs. 2018 2019 vs. Budget   Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 3 of 16   Local Retail Sales Tax  Local Retail Sales Tax revenues are budgeted based on the collection rates for the past five (5) years. Collections at the end  of November are $220k lower than 2018, but are 2.1% above budget. The City is expecting Local Retail Sales Tax revenues to  be $28.4M by the end of the year. The monthly sales tax report provides additional detail on sales taxes by sector.   2018 2019 2019 Actual Budget Actual $ % $ % Jan 2,217,949$     2,172,405$         2,260,685$     42,736$           1.9% 88,280$           4.1% Feb 2,839,044        2,602,634            2,758,295        (80,749)             ‐2.8%155,661           6.0% Mar 2,099,180        2,064,301            2,066,530        (32,650)             ‐1.6%2,229                 0.1% Apr 2,009,648        2,008,608            1,946,020        (63,628)             ‐3.2% (62,588)             ‐3.1% May 2,506,478        2,429,497            2,461,963        (44,515)             ‐1.8%32,466              1.3% Jun 1,997,751        2,105,242            2,060,512        62,761              3.1%(44,730)             ‐2.1% Jul 2,385,665        2,245,590            2,342,886        (42,779)             ‐1.8%97,296              4.3% Aug 2,573,863        2,475,019            2,832,719        258,856           10.1% 357,700           14.5% Sep 2,671,784        2,358,468            2,379,557        (292,227)          ‐10.9%21,089              0.9% Oct 2,438,390        2,413,738            2,365,273        (73,117)             ‐3.0% (48,465)             ‐2.0% Nov 2,385,700        2,491,359            2,431,401        45,701              1.9%(59,958)             ‐2.4% Dec 2,303,183        2,317,209             ‐                               YTD Total 26,125,452$  25,366,860$      25,905,840$  (219,612)$       ‐0.8%538,980$        2.1% Annual Total 28,428,635$  27,684,069$       Local Retail Sales Tax Year to Date through November Month 2019 vs. 2018 2019 vs. Budget   Criminal Justice Sales Tax   King County imposes a 0.1% sales tax for criminal justice purposes (RCW 82.14.340) that is shared with the City on a per  capital basis. These revenues are 6.2% higher than last year and 13.3% higher than budget at the end of November. The City  is expecting Criminal Justice Sales Tax revenues to be $3.3M by the end of the year.  2018 2019 2019 Actual Budget Actual $ % $ % Jan 231,017$         217,524$              261,015$         29,998$           13.0% 43,491$           20.0% Feb 297,464            277,788                 305,574            8,110                 2.7% 27,786              10.0% Mar 222,831            210,667                 239,908            17,076              7.7% 29,240              13.9% Apr 210,116            199,844                 214,151            4,035                 1.9% 14,307              7.2% May 264,162            248,880                 276,361            12,199              4.6% 27,482              11.0% Jun 234,959            219,031                 252,414            17,456              7.4% 33,383              15.2% Jul 256,344            231,301                 273,016            16,672              6.5% 41,714              18.0% Aug 286,104            267,570                 304,404            18,300              6.4% 36,833              13.8% Sep 266,961            248,535                 284,704            17,743              6.6% 36,169              14.6% Oct 264,875            251,382                 275,670            10,795              4.1% 24,288              9.7% Nov 276,624            261,653                 298,102            21,478              7.8% 36,449              13.9% Dec 279,563            252,568                  ‐                               YTD Total 2,811,457$     2,634,176$         2,985,319$     173,862$        6.2% 351,143$        13.3% Annual Total 3,091,020$     2,886,744$          Criminal Justice Sales Tax Year to Date through November Month 2019 vs. 2018 2019 vs. Budget      Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 4 of 16   Utility tax   Utility Tax revenues are underperforming in comparison to 2018. Taxpayer changes to their method of accounting for data  charges has resulted in decreased taxable activity for cellular utilities. Electrical and Natural Gas utility taxes are decreasing  as consumers move toward more efficient appliances. Cable utility taxes are decreasing as consumers are shifting away from  traditional cable and to online streaming services. The City is projecting Utility Tax revenues to be about $15.6M by the end  of the year.   2018 2019 2019 Actual Budget Actual $ % $ % Jan 1,380,809$     1,391,459$         1,228,645$     (152,164)$       ‐11.0% (162,815)$       ‐11.7% Feb 1,600,542        1,344,197            1,341,075        (259,467)          ‐16.2% (3,122)                ‐0.2% Mar 1,562,890        1,275,415            765,115            (797,776)          ‐51.0% (510,300)          ‐40.0% Apr 1,447,426        1,500,199            2,292,501        845,075           58.4% 792,302           52.8% May 1,399,812        1,318,983            1,295,860        (103,951)          ‐7.4% (23,122)             ‐1.8% Jun 1,258,549        1,210,769            1,179,491        (79,058)             ‐6.3% (31,278)             ‐2.6% Jul 1,389,799        1,185,533            1,340,108        (49,691)             ‐3.6%154,575           13.0% Aug 1,194,944        1,118,211            1,187,861        (7,084)                ‐0.6%69,650              6.2% Sep 1,189,390        1,134,606            1,124,073        (65,317)             ‐5.5% (10,533)             ‐0.9% Oct 1,283,609        1,447,186            1,248,996        (34,613)             ‐2.7% (198,190)          ‐13.7% Nov 1,074,761        1,091,778            1,196,390        121,629           11.3% 104,611           9.6% Dec 1,441,094        1,343,818             ‐                               YTD Total 14,782,532$  14,018,335$      14,200,114$  (582,418)$       ‐3.9%181,779$        1.3% Annual Total 16,223,626$  15,362,153$       Utility Tax Year to Date through November Month 2019 vs. 2018 2019 vs. Budget     The table below breaks out Utility Tax by source:  2018 2019 2019 Tax by Type YTD Actual YTD Budget YTD Actual $ % $ % Electrical 5,121,008$     4,795,109$         4,836,276$     (284,732)$       ‐5.6% $      41,167 0.9% Natural Gas 1,307,882        1,168,571            1,219,054        (88,828)             ‐6.8%          50,483 4.3% Cell 1,100,008        609,971                 703,948            (396,060)          ‐36.0%          93,977 15.4% Phone 748,678            806,515                 768,365            19,687              2.6%        (38,150)‐4.7% Cable 1,262,555        1,295,442            1,334,272        71,717              5.7%          38,830 3.0% Garbage 687,902            716,683                 742,611            54,709              7.9%          25,927 3.6% City Utilities 4,554,499        4,626,043            4,595,589        41,090              0.9%        (30,454)‐0.7% YTD Total 14,782,532$  14,018,335$      14,200,114$  (582,418)$      ‐3.9%181,779$   1.3% 2019 vs. 2018 2019 vs. Budget   Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 5 of 16   Gambling Tax  Gambling Tax revenue is 7.8% above 2018 and is 20.2% above budget.  The City is projecting Gambling Tax revenues to be  about $3M at the end of the year.   2018 2019 2019 Actual Budget Actual $ % $ % Jan 210,929$         195,183$              83,278$            (127,651)$       ‐60.5% (111,905)$       ‐57.3% Feb 255,285            206,240                 244,652            (10,633)             ‐4.2%38,412              18.6% Mar 245,283            192,766                 283,007            37,724              15.4% 90,241              46.8% Apr 275,795            224,023                 259,539            (16,256)             ‐5.9%35,516              15.9% May 222,540            213,164                 267,414            44,874              20.2% 54,250              25.4% Jun 252,663            219,651                 282,406            29,743              11.8% 62,755              28.6% Jul 255,351            219,714                 261,167            5,816                 2.3% 41,452              18.9% Aug 226,388            200,573                 291,657            65,269              28.8% 91,084              45.4% Sep 75,748               127,067                 281,157            205,409           271.2% 154,090           121.3% Oct 222,034            197,758                 220,033            (2,002)                ‐0.9%22,275              11.3% Nov 228,862            221,032                 190,388            (38,474)             ‐16.8% (30,644)             ‐13.9% Dec 360,166            282,830                  ‐                               YTD Total 2,470,879$     2,217,170$         2,664,697$     193,818$        7.8% 447,527$        20.2% Annual Total 2,831,045$     2,500,000$          Gambling Excise Tax Year to Date through November Month 2019 vs. 2018 2019 vs. Budget     Real Estate Excise Tax  REET collections through November are behind 2018 figures by 31.1%, but are 24.2% higher than anticipated. The City is  projecting REET to be around $5.5M by the end of the year.   2018 2019 2019 Actual Budget Actual $ % $ % Jan 840,316$         547,193$              748,462$         (91,854)$          ‐10.9%201,269$        36.8% Feb 366,011            205,855                 219,686            (146,325)          ‐40.0%13,831              6.7% Mar 291,045            292,784                 272,006            (19,039)             ‐6.5% (20,778)             ‐7.1% Apr 405,746            231,689                 430,070            24,324              6.0% 198,381           85.6% May 607,431            290,911                 456,154            (151,277)          ‐24.9%165,243           56.8% Jun 496,917            364,391                 444,031            (52,886)             ‐10.6%79,640              21.9% Jul 846,631            420,991                 529,539            (317,092)          ‐37.5%108,548           25.8% Aug 406,944            316,040                 472,051            65,107              16.0% 156,011           49.4% Sep 451,349            317,743                 534,380            83,031              18.4% 216,637           68.2% Oct 1,716,905        608,105                 384,156            (1,332,749)      ‐77.6% (223,949)          ‐36.8% Nov 976,580            512,951                 614,020            (362,560)          ‐37.1%101,068           19.7% Dec 409,249            291,347                  ‐                               YTD Total 7,405,875$     4,108,653$         5,104,555$     (2,301,320)$   ‐31.1%995,901$        24.2% Annual Total 7,815,124$     4,400,000$          *Total REET (GF, DS, & CIP) Real Estate Excise Tax (REET)* Year to Date through November Month 2019 vs. 2018 2019 vs. Budget      Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 6 of 16   Business & Occupation Tax  B&O Taxes are $367K more than 2018, and are $1.6M more than budget. The City is projecting B&O Taxes to be around $11M  by the end of the year.   2018 2019 2019 Actual Budget Actual $ % $ % Jan 1,301,574$     1,157,100$         919,391$         (382,183)$       ‐29.4% (237,709)$       ‐20.5% Feb 1,013,630        900,600                 1,317,771        304,141           30.0% 417,171           46.3% Mar 48,278               42,750                    105,983            57,705              119.5% 63,233              147.9% Apr 5,430,049        4,825,050            583,109            (4,846,940)      ‐89.3% (4,241,941)      ‐87.9% May 212,741            189,050                 4,272,007        4,059,266      1908.1% 4,082,957      2159.7% Jun 172,687            153,900                 11,365               (161,322)          ‐93.4% (142,535)          ‐92.6% Jul 840,839            747,650                 478,148            (362,691)          ‐43.1% (269,502)          ‐36.0% Aug 451,217            400,900                 1,654,529        1,203,312      266.7% 1,253,629      312.7% Sep 12,193               10,450                    45,525               33,332              273.4% 35,075              335.6% Oct 572,637            509,200                 790,586            217,949           38.1% 281,386           55.3% Nov 632,346            562,400                 876,882            244,536           38.7% 314,482           55.9% Dec 1,026                  950                            ‐                               YTD Total 10,688,191$  9,499,050$         11,055,295$  367,104$        3.4% 1,556,245$   16.4% Annual Total 10,689,217$  9,500,000$          *Total B&O (GF & CIP) Year to Date through November Month 2019 vs. 2018 2019 vs. Budget Business & Occupation Tax (B&O)*     Licenses and Permits    Licenses and Permits comprise 4% of all resources supporting general governmental activities. Licenses and Permits are  broken down as follows:  2017 2018 2019 2019 Actual Actual Budget Actual $ % $ % Amusement Licenses 8,400$                 4,980$                    14,000$                  ‐$                                (4,980)$             0.0%(14,000)$            0.0% Franchise Fees 1,539,350         1,499,915            1,626,699             1,499,893            (21)                       0.0% (126,805)             ‐7.8% Business Licenses 820,780              622,041                 829,292                 961,950                 339,909           54.6% 132,658              16.0% Animal Licenses 86,950                 81,460                    88,527                    76,510                    (4,950)                 ‐6.1% (12,017)                ‐13.6% Building Permits 3,201,566         2,998,342            2,554,037             2,820,365            (177,977)           ‐5.9%266,328              10.4% ROW/Street Excavation Permits 45,759                 23,720                    45,199                    38,995                    15,275              64.4%(6,204)                   ‐13.7% Special Event Permits 2,000                    1,350                       1,000                       1,995                       645                      47.8% 995                        99.5% YTD Total 5,704,805$      5,231,808$         5,158,753$          5,399,708$         167,900$        3.2% 240,955$           4.7% Annual Total 5,985,115$      5,499,201$         5,404,552$           Year to Date through August Revenue 2019 vs. 2018 2019 vs. Budget Licenses & Permits by Type        Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 7 of 16   Franchise Fees  Franchise fee collections are underperforming in comparison to 2018 and budget. The year‐to‐date collections are only $21  less than 2018, but they are $127K less than budget. One customer comprises over 80% of the City’s franchise fee revenue.  Franchise fees related to their account has decreased by 4% and is accounting for the majority of the budget difference. The  City is projecting franchise fees to be around $1.5M by the end of the year.  2018 2019 2019 Actual Budget Actual $ % $ % Jan 371,458$      402,667$      36,388$         (335,070)$    ‐90.2% (366,278)$    ‐91.0% Feb 16,600            12,257            342,814         326,214        1965.1% 330,557        2696.9% Mar 15,792            13,323            26,075            10,283           65.1% 12,752           95.7% Apr 37,420            217,862         321,069         283,649        758.0% 103,206        47.4% May 340,622         186,425         20,400            (320,222)       ‐94.0% (166,025)       ‐89.1% Jun 1,050               11,976            14,400            13,350           1271.4% 2,424              20.2% Jul 344,386         367,567         337,436         (6,950)             ‐2.0% (30,131)          ‐8.2% Aug 15,193            12,253            20,400            5,207              34.3% 8,147              66.5% Sep ‐                           4,683               18,600            18,600           100.0% 13,917           297.2% Oct 346,194         386,072         346,111         (83)                    0.0% (39,960)          ‐10.4% Nov 11,200            11,614            16,200            5,000              44.6% 4,586              39.5% Dec 9,000               16,993             ‐                            YTD Total 1,499,915$  1,626,699$  1,499,893$  (21)$                 0.0% (126,805)$    ‐7.8% Annual Total 1,508,915$  1,643,692$   Franchise Fees Year to Date through November Month 2019 vs. 2018 2019 vs. Budget   Business Licenses  Business license collections are 54.6% above 2018 and are 16% above budget. The City is projecting Business License  collections to be just over $1M by the end of the year.  2018 2019 2019 Actual Budget Actual $ % $ % Jan 327,143$      240,507$      281,106$      (46,037)$       ‐14.1%40,599$        16.9% Feb 130,035         116,909         348,391         218,356        167.9% 231,482        198.0% Mar 33,578            35,025            115,148         81,571           242.9% 80,123           228.8% Apr 27,803            79,229            60,577            32,774           117.9%(18,652)          ‐23.5% May 29,033            65,584            34,260            5,227              18.0%(31,324)          ‐47.8% Jun 19,583            25,830            21,894            2,311              11.8%(3,936)             ‐15.2% Jul 13,430            81,077            15,985            2,555              19.0%(65,092)          ‐80.3% Aug 14,850            48,583            21,104            6,254              42.1%(27,479)          ‐56.6% Sep 8,889               26,557            18,139            9,250              104.1%(8,418)             ‐31.7% Oct 9,750               72,453            14,123            4,373              44.9%(58,330)          ‐80.5% Nov 7,950               37,538            31,224            23,274           292.8%(6,314)             ‐16.8% Dec 54,000            52,163             ‐                            YTD Total 622,041$      829,292$      961,950$      339,909$     54.6% 132,658$     16.0% Annual Total 676,041$      881,455$       Business Licenses Year to Date through November Month 2019 vs. 2018 2019 vs. Budget          Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 8 of 16   Building Permits   Building permits are collected upon permit issuance. Building permits are underperforming compared to 2018. This is due to  a general slow‐down in the construction industry. The City is projecting Building Permits to be around $3M by the end of the  year.   2018 2019 2019 Actual Budget Actual $ % $ % Jan 188,207$      165,270$      203,502$      15,295$        8.1% 38,232$        23.1% Feb 184,749         148,061         240,102         55,353           30.0% 92,041           62.2% Mar 476,543         354,626         240,197         (236,346)       ‐49.6% (114,429)       ‐32.3% Apr 281,916         189,263         204,404         (77,512)          ‐27.5%15,141           8.0% May 289,639         288,592         229,378         (60,261)          ‐20.8% (59,214)          ‐20.5% Jun 226,866         273,164         320,264         93,398           41.2% 47,100           17.2% Jul 370,717         225,781         277,680         (93,037)          ‐25.1%51,899           23.0% Aug 311,562         275,344         281,848         (29,714)          ‐9.5%6,504              2.4% Sep 241,667         242,334         367,497         125,830        52.1% 125,163        51.6% Oct 248,276         185,441         272,064         23,789           9.6% 86,623           46.7% Nov 178,199         206,161         183,427         5,228              2.9%(22,734)          ‐11.0% Dec 198,984         170,694          ‐                            YTD Total 2,998,342$  2,554,037$  2,820,365$  (177,977)$    ‐5.9%266,328$     10.4% Annual Total 3,197,325$  2,724,731$   Building Permits Year to Date through November Month 2019 vs. 2018 2019 vs. Budget     Intergovernmental    Intergovernmental revenues comprise 3% of all resources supporting general governmental activities. Intergovernmental  revenues are broken down as follows:  2017 2018 2019 2019 Actual Actual Budget Actual $ % $ % State Shared Revenue 2,955,104$      3,207,371$         3,475,462$          3,814,095$         606,724$        18.9% 338,633$           9.7% Federal Grants 129,925              196,723                 364,448                 125,605                 (71,118)              ‐36.2% (238,843)             ‐65.5% State Grants 30,032                 56,189                    40,611                    65,878                    9,688                 17.2% 25,266                 62.2% Local Grants 153,445              94,663                    321,880                 195,566                 100,903           106.6%(126,314)             ‐39.2% YTD Total 3,268,506$      3,554,946$         4,202,402$          4,201,144$         646,198$        18.2%(1,258)$               0.0% Annual Total 4,210,533$      4,162,854$         5,462,108$           Intergovernmental by Type Revenue 2019 vs. 2018 2019 vs. Budget Year to Date through November        Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 9 of 16   State Shared Revenues  State shared revenues comprise 91% of total Intergovernmental revenues. They are over performing in comparison to both  2018 and budget. The City is projecting State Shared Revenues to be around $4.3M by the end of the year.   2018 2019 2019 Actual Budget Actual $ % $ % Jan 338,755$      375,421$      351,525$      12,771$        3.8%(23,896)$       ‐6.4% Feb 124,977         162,985         109,742         (15,235)          ‐12.2% (53,243)          ‐32.7% Mar 342,251         386,928         404,722         62,471           18.3% 17,794           4.6% Apr 348,999         380,602         371,513         22,514           6.5%(9,089)             ‐2.4% May 124,231         172,348         106,454         (17,777)          ‐14.3% (65,894)          ‐38.2% Jun 516,595         400,983         402,102         (114,494)       ‐22.2%1,119              0.3% Jul 343,127         388,844         765,393         422,266        123.1% 376,549        96.8% Aug 142,980         190,024         184,451         41,472           29.0%(5,573)             ‐2.9% Sep 416,763         420,695         476,278         59,515           14.3% 55,583           13.2% Oct 330,423         401,821         465,665         135,242        40.9% 63,843           15.9% Nov 178,271         194,811         176,251         (2,020)             ‐1.1% (18,560)          ‐9.5% Dec 412,208         416,908          ‐                            YTD Total 3,207,371$  3,475,462$  3,814,095$  606,724$     18.9% 338,633$     9.7% Annual Total 3,619,579$  3,892,370$   State Shared Revenue Year to Date through November Month 2019 vs. 2018 2019 vs. Budget    State shared revenues are broken down as follows:  2018 2019 2019 Tax by Type YTD Actual YTD Budget YTD Actual$%$% Judicial Contribution 16,533$         14,118$         21,666$         5,133$           31.1% 7,548$           53.5% Crim Just ‐ High Crime 284,633         276,071         289,405         4,772              1.7% 13,334           4.8% Crim Just ‐ Pop 29,781            24,725            31,208            1,427              4.8% 6,483              26.2% Crim Just ‐ Spec Prog 107,640         110,204         112,281         4,641              4.3% 2,077              1.9% State DUI 15,182            17,777            14,506            (676)                  ‐4.5% (3,271)             ‐18.4% Marijuana Distribution 213,889          ‐                           157,631         (56,258)          ‐26.3%157,631        100.0% Liquor Profits 638,266         637,608         636,508         (1,757)             ‐0.3% (1,100)             ‐0.2% Liquor Excise Tax 519,189         490,000         569,220         50,030           9.6% 79,220           16.2% Fuel Tax 1,382,259     1,904,958     1,981,670     599,411        43.4% 76,712           4.0% YTD Total 3,207,371$  3,475,462$  3,814,095$  606,724$     18.9%338,633$     9.7% 2019 vs. 2018 2019 vs. Budget     Charges for Services     Charges for Services revenues comprise 7% of all resources supporting general governmental activities. Charges for Services  revenues are broken down as follows:  2017 2018 2019 2019 Actual Actual Budget Actual $ % $ % Passport Fees 54,874                 46,180                    55,948                    30,735                    (15,445)              ‐33.4% (25,213)                ‐45.1% Court Services 38,468                 34,203                    10,095                    54,805                    20,602              60.2% 44,710                 442.9% General Government Services 2,604                    1,403                       485                            1,878                       475                      33.9% 1,392                    286.9% Public Safety Services 757,145              1,080,285            924,948                 979,519                 (100,766)           ‐9.3%54,571                 5.9% Development Services 1,762,430         1,670,676            1,783,093             1,958,246            287,570           17.2% 175,153              9.8% Transportation Services 40,008                 16,952                     ‐                                   17,144                    192                      1.1% 17,144                 100.0% Recreation/Farmer's Market/Events 1,676,377         1,509,479            1,414,340             1,500,545            (8,934)                 ‐0.6%86,205                 6.1% Interfund Services 3,614,187         3,575,459            4,409,971             3,815,608            240,149           6.7%(594,363)             ‐13.5% YTD Total 7,946,092$      7,934,638$         8,598,880$          8,358,481$         423,843$        5.3%(240,400)$          ‐2.8% Annual Total 8,588,772$      8,531,218$         9,291,414$           Year to Date through November Charges for Services by Type Revenue 2019 vs. 2018 2019 vs. Budget      Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 10 of 16   Development Services  Development Services revenues are comprised of CED administrative, planning, and inspection fees. They are over performing  both 2018 and budget. The City is projecting Development Services revenues to be around $2.1M by the end of the year.  2018 2019 2019 Actual Budget Actual $ % $ % Jan 146,322$      180,713$      420,597$      274,275$      187.4% 239,885$      132.7% Feb 128,559         118,057         173,054         44,495            34.6% 54,997            46.6% Mar 155,996         151,183         92,524            (63,472)            ‐40.7% (58,659)            ‐38.8% Apr 150,656         129,799         160,164         9,508               6.3% 30,365            23.4% May 166,578         212,795         187,376         20,798            12.5%(25,419)            ‐11.9% Jun 151,555         183,838         172,337         20,782            13.7%(11,501)            ‐6.3% Jul 123,390         121,517         194,832         71,442            57.9% 73,315            60.3% Aug 125,834         167,768         110,056         (15,778)            ‐12.5% (57,712)            ‐34.4% Sep 78,072            104,875         167,170         89,098            114.1% 62,295            59.4% Oct 208,903         181,167         151,169         (57,733)            ‐27.6% (29,997)            ‐16.6% Nov 234,811         231,382         128,967         (105,844)         ‐45.1% (102,415)         ‐44.3% Dec 123,834         166,678          ‐                            YTD Total 1,670,676$  1,783,093$  1,958,246$  287,570$      17.2% 175,153$      9.8% Annual Total 1,794,511$  1,949,771$   Development Services Year to Date through November Month 2019 vs. 2018 2019 vs. Budget     Interfund Services  2019’s monthly budgets are based on 1/12th of the annual budget.  The majority of these revenues are related to indirect cost  allocations, which are internal administrative costs.  The remaining costs consist of Development Services division’s inspection  fees, Parks Planning and Natural Resources division’s capital investment program reimbursements, Transportation division’s  capital investment program reimbursements, and Maintenance division’s street maintenance reimbursements. The majority  of the variance is due to Parks Planning and Natural Resource division not receiving budgeted reimbursement for salaries and  benefits of vacant capital project coordinator positions. The City is projecting Interfund Services revenues to be $4.2M at  year‐end.  2018 2019 2019 Actual Budget Actual $ % $ % Jan 341,804$      412,545$      355,266$      13,461$         3.9%(57,279)$         ‐13.9% Feb 344,339         407,400         340,799         (3,540)               ‐1.0% (66,601)            ‐16.3% Mar 378,470         463,506         341,533         (36,937)            ‐9.8% (121,973)         ‐26.3% Apr 332,894         407,942         365,875         32,981            9.9%(42,067)            ‐10.3% May 328,765         405,632         342,950         14,185            4.3%(62,682)            ‐15.5% Jun 320,735         394,506         334,732         13,996            4.4%(59,775)            ‐15.2% Jul 236,427         338,145         302,849         66,422            28.1%(35,296)            ‐10.4% Aug 313,949         374,081         355,757         41,808            13.3%(18,324)            ‐4.9% Sep 314,193         407,958         338,986         24,793            7.9%(68,972)            ‐16.9% Oct 330,901         399,885         401,481         70,579            21.3% 1,595               0.4% Nov 332,981         398,370         335,380         2,399               0.7%(62,990)            ‐15.8% Dec 324,948         384,647          ‐                            YTD Total 3,575,459$  4,409,971$  3,815,608$  240,149$      6.7%(594,363)$      ‐13.5% Annual Total 3,900,407$  4,794,617$   Month 2019 vs. 2018 2019 vs. Budget Interfund Services Year to Date through November        Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 11 of 16   Fines and Penalties    Fines and Penalties revenues comprise 4% of all resources supporting general governmental activities. Fines and Penalties  revenues are broken down as follows:  2017 2018 2019 2019 Actual Actual Budget Actual $ % $ % Civil Penalties 443,477$          495,304$            567,847$            403,022$            (92,282)$          ‐18.6% (164,825)$         ‐29.0% Photo Enforcement Program 1,924,564         3,118,804           3,548,589           3,614,397           495,592          15.9% 65,808              1.9% Criminal Traffic Misdemeanor Fines 69,133              64,081                 70,579                 52,950                 (11,131)            ‐17.4% (17,629)              ‐25.0% Criminal Non‐Traffic Fines 70,281              66,187                 27,306                 77,061                 10,874            16.4% 49,755              182.2% Criminal Costs 74,421              88,185                 16,307                 63,802                 (24,383)            ‐27.7%47,495              291.3% Non‐Court Fines, Forfeitures and Penalties 39,035              35,196                 162,376               72,070                 36,875            104.8%(90,306)              ‐55.6% YTD Total 2,620,911$      3,867,757$         4,393,004$         4,283,302$         415,545$        10.7%(109,702)$         ‐2.5% Annual Total 2,946,849$      4,273,192$         4,907,750$          Year to Date through August Revenue 2019 vs. 2018 2019 vs. Budget Fines and Penalties by Type     Photo Enforcement Program  Included in the Fines and Penalties annual revenue budget is $3.4M from the Photo Enforcement program. The program is  over performing both 2018 and budget. The City is projecting Photo Enforcement Program revenues to be around $4M by  the end of the year.   The associated costs include the equipment provided by American Traffic Solutions, Inc. (ATS), dedicated 2 FTE in the Court  Services Department to process the increased caseload.   19 Budget 19 Actual 2019 vs. 2018 18 Actual 19 Budget 19 Actual 19 Net Jan 200,462$         214,193$              77,340$            25,705$           35,413$         27,802$           186,391$         Feb 231,523            285,643                 131,055            93,460              121,321         127,071           158,572            Mar 246,496            399,499                 220,466            93,469              121,318         127,058           272,441            Apr 214,947            387,303                 264,441            93,469              121,322         127,068           260,235            May 262,456            280,350                 108,873            93,463              121,316         127,067           153,283            Jun 285,319            344,616                 189,471            93,460              121,310         27,802              316,814            Jul 431,039            387,738                 2,205                  25,705              78,365            27,802              359,936            Aug 545,404            303,087                 (192,154)           115,458           135,269         325,588           (22,500)              Sep 420,585            302,280                 (106,379)           115,466           135,268         27,802              274,479            Oct 541,913            394,008                 (111,213)           115,469           135,268         226,321           167,686            Nov 437,429            315,679                 (88,513)              124,973           141,293         127,074           188,605            Dec 411,834             ‐                                    ‐224,231           247,161          ‐                              ‐                        YTD Total 3,817,571$     3,614,397$         495,592$         990,094$        1,267,462$  1,298,456$   2,315,941$     Annual Total 4,229,405$     1,214,324$   1,514,623$   Month Revenues Photo Enforcement Program Year to Date through November Expenses        Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 12 of 16   Miscellaneous    Miscellaneous revenues comprise 3% of all resources supporting general governmental activities. Miscellaneous revenues  are broken down as follows:  2017 2018 2019 2019 Actual Actual Budget Actual $ % $ % Interest and Other Investment Earnings 773,659$           987,964$              876,603$              1,186,910$         198,946$        20.1% 310,307$           35.4% Rents, Leases, and Concessions 1,694,990         1,628,155            1,518,212             1,566,240            (61,916)              ‐3.8%48,027                 3.2% Contributions/Donations from Private Source 125,841              156,789                 168,899                 251,765                 94,976              60.6% 82,866                 49.1% Seizure Funds ‐ Federal/State/Local 168,830              279,998                  ‐                                   84,702                    (195,297)           ‐69.7%84,702                 100.0% Other 311,016              240,185                 242,928                 284,451                 44,266              18.4% 41,523                 17.1% YTD Total 3,074,335$      3,293,091$         2,806,641$          3,374,067$         80,976$           2.5% 567,425$           20.2% Annual Total 3,649,183$      3,667,475$         3,238,358$           Year to Date through August Revenue 2019 vs. 2018 2019 vs. Budget Miscellaneous by Type     Interest and Other Investment Earnings  Interest and Other Investment Earnings revenue is over performing both 2018 and budget. The City is projecting Interest and  Other Investment Earnings revenue to be around $1.5M by the end of the year.  2018 2019 2019 Actual Budget Actual $ % $ % Jan 74,999$                    66,440$          100,598$       25,599$        34.1% 34,158$          51.4% Feb 79,753                       71,241             101,195          21,442           26.9% 29,954             42.0% Mar 88,282                       76,787             118,607          30,325           34.4% 41,820             54.5% Apr 78,693                       74,223             116,741          38,048           48.4% 42,518             57.3% May 92,472                       81,145             106,701          14,229           15.4% 25,557             31.5% Jun 95,060                       83,803             111,735          16,676           17.5% 27,932             33.3% Jul 95,410                       84,029             112,442          17,032           17.9% 28,413             33.8% Aug 98,465                       86,235             107,728          9,263              9.4% 21,493             24.9% Sep 90,201                       81,773             104,927          14,726           16.3% 23,154             28.3% Oct 95,798                       84,528             102,643          6,845              7.1% 18,115             21.4% Nov 98,832                       86,399             103,592          4,760              4.8% 17,193             19.9% Dec 155,514                    253,397           ‐                             YTD Total 987,964$                 876,603$       1,186,910$  198,946$     20.1% 310,307$       35.4% Annual Total 1,143,478$            1,130,000$   Interest and Other Investment Earnings Year to Date through November Month 2019 vs. 2018 2019 vs. Budget     EXPENSES    Overall, the City has expended 79.9% of its budgeted general governmental expenditures at the end of November.  This is  $7.5M or 6.5% below year‐to‐date budgeted expenditures.      The Community Services Admin division is over the year‐to‐date budget by $85k. This is due entirely to the timing of  expenditures. The City is not expecting the Community Services Admin division to be over budget at the end of the year.    The Museum is over the year‐to‐date budget by $324 or .1%. This is due to the increased use/cost of part‐time staff. Use of  part‐time staff is variable depending on staffing needs and is easily managed. The City is not projecting the Museum to be  over budget at the end of the year.               Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 13 of 16   ENTERPRISE FUNDS  The table below gives an analysis of all City Enterprise funds.  Displayed are the year‐to‐date revenues and expenditures for  each enterprise.  Included in each funds are the capital revenues and expenditures.  Airport Golf Course Solid Waste  Utility Water Utility Wastewater  Utility Surface Water  Utility Metro REVENUES: Licenses and permits ‐$                    ‐$                    ‐$                    ‐$                   107,529$        49,650$           ‐$                    Grants / intergovernmental 198,148           ‐                     167,153           ‐                      ‐                     1,260,393        ‐                      Charges for services 268,081          1,880,979       17,744,890     16,220,071     9,967,547       10,856,259     15,851,391      Interdepartmental services ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      Fines and penalties 617                  ‐                      ‐                      ‐                     616                  ‐                      ‐                      Rents, leases, and misc fees 2,628,004       434,325           ‐                     174,577           ‐                      ‐                      ‐                      Interest and other misc 79,310            7,839              30,288            889,879          729,146          603,640          72,862             TOTAL REVENUES 3,174,160       2,323,143       17,942,332     17,284,527     10,804,838     12,769,942     15,924,253      EXPENSES: Utility billing ‐                      ‐                     39,787            156,554          126,468          193,242           ‐                      Utility systems ‐                      ‐                     17,774,554     4,029,738       3,605,623       3,615,587        ‐                      Utility maintenance ‐                      ‐                     357,811          5,533,789       1,988,226       2,908,341       15,488,291      Transportation 1,848,820        ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      Golf ‐                     2,159,003        ‐                      ‐                      ‐                      ‐                      ‐                      TOTAL EXPENSES 1,848,820       2,159,003       18,172,152     9,720,081       5,720,317       6,717,170       15,488,291      AMOUNT AVAILABLE FOR DEBT  SERVICE 1,325,340       164,140          (229,820)        7,564,446       5,084,521       6,052,772       435,962           DEBT SERVICE: Principal ‐                      ‐                      ‐                 345,818           ‐                      ‐                      ‐                      Interest ‐                      ‐                      ‐                 112,123          47,919            532,840           ‐                      TOTAL DEBT SERVICE ‐                      ‐                      ‐                     457,941          47,919            532,840           ‐                      CAPITAL PROJECTS 174,728          14,140             ‐                 5,399,531       2,987,791       2,624,939        ‐                      TRANSFERS IN/(OUT)‐                      ‐                      ‐                     (2,855)            27,588            (1,343)             ‐                      CHANGE IN FUND BALANCE 1,150,612       150,000          (229,820)        1,704,119       2,076,399       2,893,650       435,962           BEGINNING FUND BALANCE, Jan 1 4,985,377       110,812          2,276,333       37,957,336     18,681,655     16,254,097     5,512,418        ENDING FUND BALANCE, Nov 30 6,135,989$     260,812$        2,046,513$     39,661,455$   20,758,054$   19,147,747$   5,948,380$            Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 14 of 16   INTERNAL SERVICE FUNDS  The table below gives an analysis of all City Internal Service Funds.  Displayed are the year‐to‐date revenues and expenditures  for each internal service.  Included in each fund are the capital revenues and expenditures.   Equipment  Rental Information  Technology Facilities Communications Insurance Healthcare Retiree  Healthcare REVENUES: Technology Fee ‐$                 296,516$      ‐$                  ‐$                          ‐$                   ‐$                  ‐$                   Grants / intergovernmental ‐                    ‐                    ‐                    ‐                            ‐                     ‐                   35,898           Charges for services: Equipment rental m&o 2,231,959    4,552,363     ‐                    ‐                            ‐                     ‐                    ‐                     Print and mail ‐                    ‐                    ‐                   409,671                ‐                     ‐                    ‐                     Communications ‐                   19,823          ‐                   603,073                ‐                     ‐                    ‐                     Facilities ‐                    ‐                   3,936,796     ‐                            ‐                     ‐                    ‐                     Data cards and cell phones ‐                    ‐                    ‐                    ‐                            ‐                     ‐                    ‐                     IT service contracts ‐                    ‐                    ‐                    ‐                            ‐                     ‐                    ‐                     Interest and other misc 74,690         47,379         14,342         8,470                   225,748        56,092         175,854         Internal service fund misc: Vehicle / equipment capital recovery 2,462,698     ‐                    ‐                    ‐                            ‐                     ‐                    ‐                     Insurance premiums ‐                    ‐                    ‐                    ‐                           1,547,942      ‐                    ‐                     Worker's comp/unemployment ‐                    ‐                    ‐                    ‐                           1,347,565      ‐                    ‐                     Benefit premiums ‐                    ‐                    ‐                    ‐                            ‐                    9,290,787    2,405,960      Other misc 4,553           689              135,897       424                      50,000          945,371        ‐                     Interfund Loan ‐                    ‐                    ‐                    ‐                           175,000         ‐                    ‐                     Capital contributions ‐                    ‐                    ‐                    ‐                            ‐                     ‐                    ‐                     Disposal of capital assets 57,551          ‐                    ‐                    ‐                            ‐                     ‐                    ‐                     Insurance recoveries ‐                    ‐                    ‐                    ‐                           133,214         ‐                    ‐                     TOTAL REVENUES 4,831,451    4,916,770    4,087,035    1,021,638            3,479,469     10,292,250  2,617,712      EXPENSES: Communications ‐                    ‐                    ‐                   521,348                ‐                     ‐                    ‐                     Equipment rental 2,630,128     ‐                    ‐                    ‐                            ‐                     ‐                    ‐                     Facilities ‐                    ‐                   4,834,469     ‐                            ‐                     ‐                    ‐                     Healthcare ‐                    ‐                    ‐                    ‐                            ‐                    9,074,120     ‐                     Information technology ‐                   4,760,000     ‐                    ‐                            ‐                     ‐                    ‐                     Print and mail ‐                    ‐                    ‐                   379,287                ‐                     ‐                    ‐                     Retiree healthcare ‐                    ‐                    ‐                    ‐                            ‐                     ‐                   834,116         Risk management:‐                    ‐                    ‐                    ‐                            ‐                     ‐                    ‐                     Risk management ‐                    ‐                    ‐                    ‐                           1,366,631      ‐                    ‐                     Unemployment ‐                    ‐                    ‐                    ‐                           47,860           ‐                    ‐                     Worker's compensation ‐                    ‐                    ‐                    ‐                           660,375         ‐                    ‐                     TOTAL EXPENSES 2,630,128    4,760,000    4,834,469    900,635               2,074,866     9,074,120    834,116         AMOUNT AVAILABLE FOR CAPITAL 2,201,323    156,770       (747,434)      121,003               1,404,603     1,218,130    1,783,596      CAPITAL PROJECTS 4,031,567    292,195       10,901          ‐                            ‐                     ‐                    ‐                     TRANSFERS IN ‐                   60,483         12,389          ‐                            ‐                     ‐                    ‐                     TRANSFERS (OUT)‐                    ‐                   (5,220)           ‐                            ‐                     ‐                    ‐                     CHANGE IN FUND BALANCE (1,830,244)   (74,942)        (751,166)      121,003               1,404,603     1,218,130    1,783,596      BEGINNING FUND BALANCE, Jan 1 6,493,018    3,934,408    1,376,859    685,593               18,522,154   4,259,511    13,876,628    ENDING FUND BALANCE, Nov 30 4,662,774$  3,859,466$  625,693$     806,596$             19,926,757$ 5,477,641$  15,660,224$    Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 15 of 16   FUND BALANCE  Page 16 shows the ending fund balance as of November 2019.  The City’s fund balance is a combination of current  deficit/surplus of funds which have accrued from unexpended operating budgets, unanticipated excess revenues, and from  balances accumulated from prior years.      The prior year’s balances (or beginning balance) include funds identified as being reserved for specific purposes or required  to meet the current year’s appropriations. These balances also provide financial stability to the City’s operation during  uncertain times and provide a layer of security to bondholders.      At the end of November, the City has $58.8M reported in the combined general governmental fund balance of the current  year’s operating budget, which is approximately 44% of budgeted operating expenditures.  This is an increase of $14.3M from  the year’s beginning balance.  November’s ending fund balance is over the anticipated General Governmental Fund Balance  of $45M by $14.3M or 32%.  Although the ending fund balance is above projections, it is consistent with the prior years’  trends and consistent with the forecast (Long Range Plan) that was presented as part of the 2019/2020 Adopted Budget.    CONTACT INFORMATION  This report is prepared by the Finance Division of the Administrative Services Department.  For additional financial  information, please also review our website: http://www.rentonwa.gov/.  For any questions about the report, please feel  free to contact us at mbaker@rentonwa.gov or jhawn@rentonwa.gov.    Monthly Financial Report                                                               City of Renton, Washington November 2019  Page 16 of 16   City of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Budgetary Basis through November 30, 2019 Funds Balance  01/01/2019 Budgeted  Revenue Revenue  11/30/19 Total Funds  Available Budgeted  Expenditure Expenditure  11/30/19 Ending Balance GENERAL FUND: 44,578,377          125,561,221        121,238,951        165,817,328        133,793,547        106,940,852        58,876,476           SPECIAL REVENUE FUNDS: 1,875,558            528,039               741,871               2,617,429            1,022,040            580,307               2,037,122             102 Arterial Street 163,671               103,365                ‐                           163,671               267,036               163,671               (0)                          110 Hotel Motel 722,387               225,000               521,674               1,244,061            444,647               240,398               1,003,663             125 Municipal Art 119,446               102,000               84,050                 203,496               204,683               123,813               79,682                  127 Cable Communication 529,159               97,674                 132,143               661,302               105,674               52,425                 608,878                135 Springbrook Wetlands Bank 340,895                ‐                           4,004                   344,899                ‐                            ‐                           344,899                DEBT SERVICE FUND: 2,307,173            8,444,717            6,605,837            8,913,010            7,914,936            1,215,205            7,697,805             CAPITAL PROJECT FUNDS (CIP): 39,310,931          66,788,339          30,656,927          69,967,858          89,093,108          15,105,057          54,862,801           303 Community Services Mitigation 2,578,256            86,500                 466,420               3,044,676            1,200,000             ‐                           3,044,676             305 Transportation Mitigation 3,332,524            1,020,000            1,848,355            5,180,879            2,324,200             ‐                           5,180,879             316 Municipal Facilities CIP 20,675,238          20,470,370          15,817,882          36,493,120          39,952,505          8,975,703            27,517,417           317 Transportation CIP 5,492,313            40,114,969          12,398,750          17,891,063          43,712,273          5,562,527            12,328,536           326 Housing Opportunity 2,582,203            21,500                 31,587                 2,613,790            68,900                 42,984                 2,570,806             336 New Library Development 456,591                ‐                           4,404                   460,995               445,591                ‐                           460,995                346 New Family First Center Dvlpmnt 4,193,806            5,075,000            89,529                 4,283,335            1,389,638            523,844               3,759,491             ENTERPRISE FUNDS: 85,778,028          93,212,578          80,323,928          166,101,956        146,734,698        72,143,007          93,958,949           4X2 Airport Operating & CIP 4,985,377            3,298,685            3,174,160            8,159,537            7,912,888            2,023,548            6,135,989             403 Solid Waste Utility 2,276,333            19,512,021          17,942,332          20,218,665          19,403,677          18,172,152          2,046,513             4X4 Golf Operating & CIP 110,812               2,447,340            2,389,143            2,499,955            2,354,233            2,239,143            260,812                4X5 Water Operating & CIP 37,957,336          18,841,192          17,284,526          55,241,862          48,784,107          15,580,407          39,661,455           4X6 Waste Water Operating & CIP 18,681,655          11,582,615          10,833,194          29,514,849          24,728,976          8,756,794            20,758,054           416 King County Metro 5,512,418            16,922,613          15,924,253          21,436,671          16,922,613          15,488,291          5,948,380             4X7 Surface Water Operating & CIP 16,254,097          20,608,113          12,776,321          29,030,418          26,628,203          9,882,671            19,147,747           INTERNAL SERVICE FUNDS: 49,148,171          35,865,075          31,319,201          80,467,372          40,529,415          29,448,219          51,019,152           501 Equipment Repair/Replacement 6,493,018            7,705,395            4,831,452            11,324,470          9,249,649            6,661,695            4,662,774             502 Insurance 18,522,154          3,343,143            3,479,469            22,001,623          4,216,235            2,074,866            19,926,757           503 Information Services 3,934,408            6,122,843            4,977,255            8,911,663            7,758,840            5,052,197            3,859,466             504 Facilities 1,376,859            5,318,843            4,099,424            5,476,283            5,538,128            4,850,590            625,693                505 Communications 685,593               1,105,816            1,021,639            1,707,232            1,132,460            900,635               806,596                512 Insurance, Healthcare 4,259,511            11,027,762          10,292,250          14,551,761          11,655,841          9,074,120            5,477,642             522 Insurance, Leoff1 Retirees HC 13,876,628          1,241,273            2,617,713            16,494,341          978,262               834,116               15,660,225           FIDUCIARY FUNDS: 7,146,983            468,000               612,314               7,759,297            210,475               178,207               7,581,090             304 Fire Mitigation 1,455,669            99,000                 780,274               2,235,943            128,576                ‐                           2,235,943             611 Firemen's Pension 7,146,983            468,000               612,314               7,759,297            210,475               178,207               7,581,090             TOTAL FUNDS 231,600,890     330,966,969     272,279,304     503,880,193     419,426,795     225,610,854     278,269,339