Loading...
HomeMy WebLinkAbout201612, DecemberADMINISTRATIVE SERVICES  DEPARTMENT       M   E   M   O   R   A   N   D   U   M       DATE: February 15, 2017    TO: Armondo Pavone, Council President  Members of the Renton City Council     CC: Denis Law, Mayor  Administrators     FROM: Hai Nguyen, Sr. Finance Analyst     SUBJECT: December 2016 Financial Status Report       At the end of December, general governmental revenues show $33k under budget.  Revenue  source(s) that are higher than expected are: sales tax ($1.3 million); sales tax annexation credit  ($115k); utility taxes ($456k); gambling taxes ($501k); real estate excise tax ($214k); business &  occupation taxes ($1.4 million); state shared revenues ($261k); public safety ($364k); seizure  funds ($324k, restricted to drug enforcement and not available for general purposes); interest  ($184k); and other miscellaneous ($251k).  If we remove seizure funds, general governmental  revenues are $357k or 0.3% under budget.  On the down side, the revenue source(s) that are  underperforming the year to date budget are property tax ($175k below); emergency medical  services levy EMS ($590k below); building permits & development service fees ($630k below);  Fire District #25 & #40 service contracts ($2.6 million below); and fines & penalties ($460k below).   EMS levy and FD25&40 service contracts were expected to be under budget due to the formation  of the Renton Regional Fire Authority mid‐2016.  The combined $3.2 million deficit corresponds  with the $3.2 million in expenditure savings from the Fire department.    General government expenditures showed a favorable variance of $9.5 million or 7.4%.  See page  10 of report for further expenditure over‐spent explanations.    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 x6952 should you have any  questions or any suggestions about the report.         This page is intentionally left blank        General Governmental Funds $% Beginning Fund Balance 17,454,261$     17,454,261$  17,565,282$       17,565,282$  19,962,845$    19,962,845$ 19,962,845$    ‐                         0.0% OPERATING REVENUES Property Tax 35,295,390        35,295,390     36,369,429          36,369,429     37,213,314       37,213,314    37,038,480      (174,834)            ‐0.5% Sales  Tax 21,512,379        21,512,379     23,439,266          23,439,266     25,100,000       25,100,000    26,353,246      1,253,246        5.0% Sales  Tax ‐ Annexation  Credit 2,542,394           2,542,394        2,778,858             2,778,858        3,000,000          3,000,000       3,114,762         114,762            3.8% Criminal Justice Sales  Ta x 2,267,947           2,267,947        2,484,718             2,484,718        2,580,795          2,580,795       2,701,787         120,992            4.7% Natural Gas Use  Tax 271,485                271,485            228,899                  228,899             228,000               228,000            184,638             (43,362)              ‐19.0% Admission Tax 310,311                310,311            309,790                  309,790             320,000               320,000            262,506             (57,494)              ‐18.0% Franchise  Fees 1,342,269           1,342,269        1,349,154             1,349,154        1,330,000          1,330,000       1,406,092         76,092               5.7% Electricity Tax 5,167,444           5,167,444        5,012,962             5,012,962        5,396,019          5,396,019       5,440,139         44,120               0.8% Natural Gas  Utility Tax 1,562,341           1,562,341        1,437,552             1,437,552        1,350,900          1,350,900       1,327,937         (22,963)              ‐1.7% Garbage/Solid Waste 573,457                573,457            638,073                  638,073             680,000               680,000            717,148             37,148               5.5% TV Cable 1,518,821           1,518,821        1,591,866             1,591,866        1,629,365          1,629,365       1,619,364         (10,001)              ‐0.6% Telephone 909,088                909,088            880,233                  880,233             752,500               752,500            859,868             107,368            14.3% Cellular Phone 1,951,925           1,951,925        1,674,355             1,674,355        1,521,056          1,521,056       1,541,204         20,148               1.3% City Utilities 3,961,052           3,961,052        4,183,165             4,183,165        3,883,377          3,883,377       4,206,473         323,096            8.3% Utility Tax Audit 460,513                460,513            1,962,092             1,962,092        111,227               111,227            111,227              ‐                         0.0% Leasehold Excise  Tax 171,470                171,470            163,314                  163,314             179,000               179,000            173,769             (5,231)                  ‐2.9% Gambling Excise  Tax 1,650,384           1,650,384        2,299,156             2,299,156        2,000,000          2,000,000       2,500,604         500,604            25.0% Real Estate Excise  Tax 4,348,762           4,348,762        4,595,166             4,595,166        5,200,000          5,200,000       6,121,830         921,830            17.7% Less: CIP REET (1,650,000)          (1,650,000)      (1,401,300)            (1,401,300)       (2,000,000)         (2,000,000)      (2,707,676)       (707,676)           35.4% EMS Levy 916,361                916,361            936,406                  936,406             1,069,454          1,069,454       479,597             (589,858)           ‐55.2% B&O Taxes ‐                            ‐                         ‐                              ‐                          5,000,000          5,000,000       6,375,322         1,375,322        27.5% Less: CIP B&O Taxes ‐                            ‐                         ‐                              ‐                          (2,000,000)         (2,000,000)      (2,000,000)       ‐                         0.0% Business  License Fees 2,965,850           2,965,850        3,125,740             3,125,740        1,961,000          1,961,000       1,926,510         (34,490)              ‐1.8% Less: CIP Business License Fees (2,450,295)          (2,450,295)      (2,584,164)            (2,584,164)       (1,619,000)         (1,619,000)      (1,587,627)       31,373               ‐1.9% Animal  Licenses and Spec Events  Permits 95,698                   95,698               101,743                  101,743             91,000                  91,000               102,905             11,905               13.1% Building Permits & Development Svc Fees 4,519,234           4,519,234        6,077,055             6,077,055        5,923,368          5,923,368       5,293,563         (629,805)           ‐10.6% Intergovt'l (Grants, State  Shared, etc) 4,522,540           4,522,540        4,053,617             4,053,617        4,651,109          4,651,109       3,998,953         (652,156)           ‐14.0% Fire District 25 and 40 Contracts 5,959,428           5,959,428        6,369,132             6,369,132        6,128,712          6,128,712       3,517,779         (2,610,933)       ‐42.6% Public Safety 844,375                844,375            649,797                  649,797             630,135               630,135            994,179             364,044            57.8% Culture and Recreation 1,485,123           1,485,123        1,587,878             1,587,878        1,727,393          1,727,393       1,632,903         (94,490)              ‐5.5% Interfund/Interdept‐Services 3,270,503           3,270,503        3,106,430             3,106,430        3,439,406          3,439,406       3,377,663         (61,744)              ‐1.8% Fines  and Penalties 962,977                962,977            848,052                  848,052             1,126,500          1,126,500       901,592             (224,908)           ‐20.0% Photo Enforcement 1,719,971           1,719,971        2,171,184             2,171,184        2,194,000          2,194,000       1,959,071         (234,929)           ‐10.7% Seizure  Funds  ‐ Federal/State/Local 68,870                   68,870               21,676                     21,676                663,143               663,143            987,293             324,150            48.9% Interests  and Other Earnings 981,630                981,630            973,208                  973,208             875,300               875,300            1,058,880         183,580            21.0% Rents, Leases, and Concessions 711,070                711,070            762,361                  762,361             598,616               598,616            642,192             43,576               7.3% Contributions  and Donations 113,626                113,626            147,292                  147,292             102,700               102,700            96,582                (6,118)                 ‐6.0% Other Miscellaneous 879,105                879,105            941,127                  941,127             705,630               705,630            956,131             250,501            35.5% Other Financing Sources  (Transfer ‐In, etc) 48,632                   48,632               270,224                  270,224             2,105,396          2,105,396       2,129,561         24,165               1.1% Total  Operating Revenues 111,782,133     111,782,133  119,555,505       119,555,505  125,849,415    125,849,415 125,816,444   (32,971)              0.0% OPERATING EXPENDITURES Council 309,317                309,317            320,877                  320,877             375,761               375,761            358,550             17,212               4.6% Executive 1,338,738           1,338,738        1,691,189             1,691,189        1,784,464          1,784,464       1,778,206         6,258                  0.4% City Attorney 1,829,254           1,829,254        1,791,167             1,791,167        2,213,353          2,213,353       1,983,834         229,519            10.4% Court Services 2,016,273           2,016,273        2,013,364             2,013,364        2,187,710          2,187,710       2,075,763         111,947            5.1% Community and Eco  Dvlpmnt Admin 1,010,761           1,010,761        1,183,052             1,183,052        1,173,302          1,173,302       1,161,330         11,971               1.0% Development Services 2,659,078           2,659,078        2,632,264             2,632,264        3,197,543          3,197,543       2,859,410         338,134            10.6% Economic Development 654,007                654,007            658,515                  658,515             1,814,358          1,814,358       1,004,411         809,947            44.6% Planning 2,095,706           2,095,706        2,606,551             2,606,551        3,009,484          3,009,484       2,716,214         293,270            9.7% Finance 2,644,827           2,644,827        3,132,812             3,132,812        3,003,369          3,003,369       3,046,824         (43,455)              ‐1.4% City Clerk 1,152,246           1,152,246        1,027,084             1,027,084        1,151,870          1,151,870       914,251             237,619            20.6% Human Resources 922,668                922,668            1,182,629             1,182,629        1,372,669          1,372,669       1,193,016         179,653            13.1% Police 26,383,640        26,383,640     28,144,699          28,144,699     30,976,827       30,976,827    28,891,879      2,084,948        6.7% Jail Services 3,760,273           3,760,273        4,142,266             4,142,266        4,703,000          4,703,000       4,704,978         (1,978)                 0.0% Fire 25,240,760        25,240,760     26,536,999          26,536,999     28,932,928       28,932,928    25,720,587      3,212,341        11.1% Community Services  Admin 480,057                480,057            508,766                  508,766             655,344               655,344            585,983             69,361               10.6% Parks 4,070,181           4,070,181        4,411,383             4,411,383        5,065,610          5,065,610       4,445,115         620,495            12.2% Parks Planning & Natural Resources 722,739                722,739            808,558                  808,558             1,292,543          1,292,543       952,980             339,563            26.3% Recreation 4,823,865           4,823,865        5,088,483             5,088,483        5,350,288          5,350,288       5,096,236         254,053            4.7% Human Services 1,159,189           1,159,189        1,225,835             1,225,835        1,260,461          1,260,461       1,241,169         19,292               1.5% Neighborhoods, Resources, & Events 875,223                875,223            958,624                  958,624             1,109,048          1,109,048       865,551             243,497            22.0% Museum 214,291                214,291            227,094                  227,094             235,281               235,281            229,543             5,739                  2.4% Public Works Admin 389,493                389,493            387,493                  387,493             413,579               413,579            398,796             14,784               3.6% Street Maintenance 4,503,315           4,503,315        5,061,723             5,061,723        5,420,445          5,420,445       5,041,509         378,935            7.0% Transportation 4,263,725           4,263,725        4,975,059             4,975,059        6,149,047          6,149,047       5,966,281         182,766            3.0% Debt Service 8,393,140           8,393,140        6,371,715             6,371,715        6,248,676          6,248,676       6,099,166         149,510            2.4% Non‐Departmental and Other 9,758,346           9,758,346        10,069,740          10,069,740     9,656,299          9,656,299       9,883,923         (227,624)            ‐2.4% Total  Operating Expenditures 111,671,112     111,671,112  117,157,942       117,157,942  128,753,260    128,753,260 119,215,504   9,537,756        7.4% Total  Ending Fund Balance 17,565,282$     17,565,282$  19,962,846$       19,962,846$  17,059,000$    17,059,000$ 26,563,785$   9,504,785$     55.7% Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable) 2014 2015 2016 Variance Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual   Monthly Financial Report December 2016 Page 1 of 38 Monthly Financial Report December 2016      OVERVIEW  This financial overview reflects the City’s overall financial position for the fiscal year through December 31, 2016.  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 years.  The table on the previous page summarizes the general  governmental fund revenues and expenditures.    Revenues    Taxes   The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 75% of  all resources supporting general governmental activities.   The following section provides detail information on property,  sales, utility, and other taxes.    Property Tax  December’s collection is $145k,  making the total year‐to‐date  collection $37 million or 99.5% of  the total budget.  In comparison  to the previous year, the City  collected $669k or 2% more.   Compared to the budget, the City  collected $175k less.  The  April/May variance is due to the  timing of collections in the  current year compared to the  prior year.                  Sales Tax  December 2016 sales tax receipts  totaled $2.2 million.  Compared  with the same month last year, it  is $183k or 9% more.  Compared  to the projected current month’s  budget, it is $43k or 2% above.   The year‐to‐date collection of  $26.4 million is $2.9 million or  12% more than the prior year and  is also $1.3 million or 5% more  than budgeted.  New  Construction, Wholesale, and  Other are the sectors that are  collecting more than anticipated.   2016’s monthly budgets are  generally based on 2010 through  2015 collections.  2015 2016 2016 Actual Budget Actual $ % $ % Jan 67,234$            68,794$            44,745$            (22,489)$            ‐33% (24,049)$            ‐35% Feb 307,006            314,129            315,119            8,113                  3% 990                       0% Mar 939,218            961,010            1,273,685        334,468            36% 312,675            33% Apr 10,160,118     10,395,864     7,856,230        (2,303,888)       ‐23% (2,539,634)       ‐24% May 7,583,868        7,759,837        9,906,533        2,322,666        31% 2,146,696        28% Jun 147,318            150,736            137,794            (9,524)                  ‐6% (12,942)               ‐9% Jul 65,395               66,912               57,174               (8,221)                  ‐13% (9,739)                  ‐15% Aug 94,817               97,017               240,536            145,720            154% 143,520            148% Sep 561,525            574,554            558,716            (2,809)                  ‐1% (15,838)               ‐3% Oct 6,263,616        6,408,951        6,233,910        (29,706)              0% (175,042)            ‐3% Nov 9,975,046        10,206,498     10,268,791     293,745            3% 62,293               1% Dec 204,271            209,010            145,246            (59,025)               ‐29% (63,765)               ‐31% YTD  Total 36,369,429$  37,213,314$  37,038,480$  669,050$         2% (174,834)$        0% Annual  Total 36,369,429$  37,213,314$   Property Tax  Revenues Year to Date through December 2016 vs. 2015 2016 vs. Budget Month 2015 2016 2016 A c t u a l B u d g e t A c t u a l $%$% Jan 1,758,332$     1,945,759$     1,978,530$     220,198$         13% 32,772$            2% Feb 2,260,395        2,385,815        2,320,497        60,102               3% (65,318)               ‐3% Mar 1,674,147        1,856,099        1,854,773        180,626            11% (1,326)                 0% Apr 1,750,506        1,842,188        1,888,875        138,369            8% 46,687               3% May 1,977,843        2,189,189        2,314,220        336,377            17% 125,031            6% Jun 1,677,458        1,924,941        2,127,406        449,947            27% 202,464            11% Jul 1,866,949        1,987,424        2,103,896        236,948            13% 116,472            6% Aug 2,178,289        2,213,372        2,438,277        259,988            12% 224,905            10% Sep 2,100,591        2,126,242        2,179,438        78,848               4% 53,197               3% Oct 2,014,951        2,201,943        2,410,824        395,874            20% 208,881            9% Nov 2,158,753        2,265,914        2,532,820        374,067            17% 266,906            12% Dec 2,021,053        2,161,114        2,203,689        182,636            9% 42,575               2% YTD  Total 23,439,266$  25,100,000$  26,353,246$  2,913,980$     12% 1,253,246$     5% Annual  Total 23,439,266$  25,100,000$   2016 vs. Budget2016 vs. 2015 Month Year to Date through December Local Retail  Sales  Tax Revenues Page 2 of 38 Monthly Financial Report December 2016      The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business  sectors:                      Utility tax   December utility tax revenues  are $1.4 million, which is $506k  or 27% lower than the same  month last year and is also lower  than the budget by $29k or 2%.   The year‐to‐date collection is $16  million, which is $1.6 million or  9% lower than the prior year but  is $456k or 3% higher than the  budget.  The large June, July, and  December variances with the  prior year is due to the  recognition of utility tax audit  proceeds in 2015.          The table below breaks out Utility Tax by source.  The utility tax audit revenues are gross and do not include the related  audit fees ($26k).          2015 2016 2016 Actual Budget Actual $ % $ % Jan 1,199,348$     1,376,913$     1,509,960$     310,612$         26% 133,047$         10% Feb 1,371,771        1,411,904        1,597,348        225,577            16% 185,443            13% Mar 1,544,060        1,530,092        1,423,774        (120,286)            ‐8% (106,318)            ‐7% Apr 1,263,898        1,219,957        1,346,282        82,383               7% 126,325            10% May 1,262,764        1,283,812        1,363,323        100,559            8% 79,511               6% Jun 1,815,284        1,297,278        1,125,845        (689,439)            ‐38% (171,433)            ‐13% Jul 2,175,167        1,148,388        1,276,335        (898,831)            ‐41% 127,947            11% Aug 1,351,000        1,279,887        1,247,926        (103,074)            ‐8% (31,961)               ‐2% Sep 1,214,144        1,192,240        1,277,502        63,358               5% 85,262               7% Oct 1,204,406        1,182,637        1,351,888        147,482            12% 169,251            14% Nov 1,342,058        1,240,978        1,128,100        (213,958)           ‐16% (112,879)           ‐9% Dec 1,865,296        1,388,357        1,359,717        (505,579)           ‐27% (28,640)              ‐2% YTD  Total 17,609,196$  15,552,444$  16,007,999$  (1,601,197)$   ‐9% 455,555$         3% Annual  Total 17,609,196$  15,552,444$   2016 vs. Budget2016 vs. 2015 Year to Date through December Utility Tax  Revenues Month Sales  Tax  by Sector 2015 2016 Bgt YTD Act Change 2016/2015 2016 Act  vs  Bgt New Construction 3,019,042$     4,126,049$     4,682,830$     1,663,788$  55% $        556,781 13% Auto Sales 4,597,151        4,696,483        4,809,026        211,875          5%            112,543 2% General Retail 7,113,256        7,153,199        7,295,531        182,275          3%            142,332 2% Manufacturing 1,799,316        1,737,044        1,810,521        11,204             1%               73,477 4% Wholesale 1,198,960        1,302,822        1,435,391        236,430          20%            132,569 10% Service 5,145,373        5,462,547        5,635,185        489,812          10%            172,638 3% Other 566,166            621,856            684,762            118,595          21%               62,906 10% YTD  Total 23,439,266$  25,100,000$  26,353,246$  2,913,980$  12%1,253,246$    5% Note: Excludes  Annexation Credit and Criminal Justice Sales  Tax  revenue. Utility Tax  by Type 2015 2016 Bgt YTD Act Change 2016/2015  2016 Act  vs  Bgt  Electrical 5,012,962$     5,396,019$     5,440,139$     427,178$       9% $           44,120 1% Natural  Gas 1,666,451        1,578,900        1,512,576        (153,875)        ‐9%             (66,324)‐4% Cell 1,674,355        1,521,056        1,541,204        (133,151)        ‐8%               20,148 1% Phone 880,233            752,500            859,868            (20,365)            ‐2%            107,368 14% Cable 1,591,866        1,629,365        1,619,364        27,498             2%             (10,001)‐1% Garbage/Solid Waste 638,073            680,000            717,148            79,075             12%               37,148 5% City Utilities 4,183,165        3,883,377        4,206,473        23,309             1%            323,096 8% Utility Tax  Audit 1,962,092        111,227            111,227            (1,850,865)    ‐94%                              ‐ 0% YTD  Total 17,609,196$  15,552,444$  16,007,999$  (1,601,197)$ ‐9%455,555$        3% Annual Total 17,609,196$  15,552,444$   YTD  as % of 100% 100% Page 3 of 38 Monthly Financial Report December 2016      Other Taxes     Real Estate Excise Tax  The City collected $307k in Real  Estate Excise Tax revenues (REET)  for December.  This is $130k or  30% less than the same month  last year and is also $236k or 43%  less than the current month’s  budget.  The year‐to‐date  collection is $6.1 million, which is  $1.5 million or 33% more than  the prior year and is also $922k or  18% above the budget.  The  higher than expected variance is  due to 22 large transactions in  December, January, April, June,  July, August, September, and  October which accounts for $2.5  million of the total REET  collected.      Gambling Tax  December’s Gambling Tax  collections totaled $182k, which  is $10k or 5% below the same  month last year but is above the  current month’s budget by $9k or  5%.  The year‐to‐date total of  $2.5 million is $201k or 9% above  the prior year and is also $501k or  25% above budget.  $165k of the  year‐to‐date collections are from  a payment plan of back taxes  earned in 2013/2014 (final  payment was made in August  2016).    Pull tabs overall had a 3%  increase, bingo had a 94% decrease (bingo establishment closed December 2015), and card‐rooms are seeing 11% higher in  activities when compared to the prior year.      Franchise Fees  Franchise Fees are due quarterly  in January, April, July, and  October.  The year‐to‐date total  of $1.4 million is $57k or 4%  higher than the prior year and is  also $76k or 6% above the  projected year‐to‐date budget.   2015 2016 2016 Actual Budget Actual $ % $ % Jan 158,293$         146,887$         189,749$         31,457$            20% 42,862$            29% Feb 184,189            160,676            207,961            23,772               13% 47,285               29% Mar 169,262            163,542            195,255            25,993               15% 31,713               19% Apr 207,646            157,804            197,286            (10,361)               ‐5% 39,482               25% May 183,090            162,758            198,234            15,144               8% 35,476               22% Jun 174,036            156,847            185,042            11,007               6% 28,196               18% Jul 194,895            160,770            194,317            (578)                     0% 33,547               21% Aug 226,785            180,865            322,828            96,043               42% 141,964            78% Sep 180,986            162,262            202,409            21,423               12% 40,147               25% Oct 215,119            187,677            242,254            27,135               13% 54,577               29% Nov 212,838            187,242            183,345            (29,493)               ‐14% (3,897)                  ‐2% Dec 192,018            172,672            181,924            (10,094)               ‐5% 9,252                  5% YTD  Total 2,299,156$     2,000,000$     2,500,604$     201,448$         9% 500,604$         25% Annual  Total 2,299,156$     2,000,000$      Gambling Tax  Revenue Month Year to Date through December 2016 vs. Budget2016 vs. 2015 2015 2016 2016 Actual Budget Actual $ % $ % Jan 333,343$         324,400$         348,118$         14,775$            4% 23,718$            7% Apr 335,218            325,536            355,430            20,212               6% 29,895               9% Jul 340,657            328,584            343,910            3,254                  1% 15,327               5% Sep ‐                        ‐                         5,000                  5,000                  100% 5,000                  100% Oct 339,936            327,019            348,783            8,847                  3% 21,764               7% Dec ‐                        24,462               4,850                  4,850                  100% (19,612)               ‐80% YTD  Total 1,349,154$     1,330,000$     1,406,092$     56,938$            4% 76,092$            6% Annual  Total 1,349,154$     1,330,000$      Month 2016 vs . 2015 2016 vs. Budget Franchise  Fees  Revenue Year  to Date through December 2015 2016 2016 A c t u a l B u d g e t A c t u a l $%$% Jan 226,377$         250,883$         1,204,479$     978,102$         432% 953,596$         380% Feb 158,616            175,787            197,327            38,710               24% 21,540               12% Mar 343,579            380,772            208,452            (135,127)            ‐39% (172,320)            ‐45% Apr 438,485            485,952            335,985            (102,500)            ‐23% (149,967)            ‐31% May 394,014            436,667            475,244            81,230               21% 38,577               9% Jun 478,186            529,951            405,179            (73,008)               ‐15% (124,772)            ‐24% Jul 563,474            624,471            644,038            80,564               14% 19,567               3% Aug 281,921            312,440            759,583            477,662            169% 447,143            143% Sep 449,693            498,374            522,472            72,778               16% 24,098               5% Oct 497,978            551,885            559,552            61,574               12% 7,667                  1% Nov 325,743            409,769            502,139            176,396            54% 92,369               23% Dec 437,098            543,049            307,382            (129,716)            ‐30% (235,667)            ‐43% YTD  Total 4,595,166$     5,200,000$     6,121,830$     1,526,664$     33% 921,830$         18% Annual  Total 4,595,166$     5,200,000$      *Total REET (GF & CIP) Real  Estate Excise  Tax  (REET) Revenues* Year to Date through December Month 2016 vs. Budget2016 vs. 2015 Page 4 of 38 Monthly Financial Report December 2016      Admission Tax   Admission Tax returns are due  quarterly in January, April, July,  and October of each year.   October 2016 collections  represent activities conducted  during the 3rd quarter of 2016.   The year‐to‐date collection of  $263k is $46k or 15% less than  the prior year and is also $57k or  18% less than the budget.  The  decline in revenue is due to the  closure of Regal East Valley 13  Theater at the end of 2015.        Business & Occupation Tax  Business and Occupation (B&O)  Tax is a new revenue source for  the City in 2016.  It was adopted  by the Council in the 2015/2016  biennial budget.  Businesses with  gross receipts of $1.5 million or  more per year, earned within the  City of Renton, will be required to  file and pay B&O tax, in lieu of the  Per Employee Fee, which is  currently reported as Business  License revenue.  Year‐to‐date  receipts totaled $6.4 million.  This  is due to one business reporting a  full year’s worth of activity.        Licenses and Permits    Business Licenses  Business Licenses totaled $13k  for December, which is $6k or  31% below the same month last  year but is right on target with  the current month’s budget.  The  year‐to‐date Business Licenses  revenue of $1.9 million is $1.2  million or 38% below the prior  year and is also below the budget  by $34k or 2%.  The annual  budget was decreased due to the  City adopting the Business &  Occupation Tax for 2016.     2015 2016 2016 Actual Budget Actual $ % $ % Jan 83,675$            84,589$            76,393$            (7,282)$               ‐9% (8,196)$               ‐10% Feb 1,371                  707                       1,360                  (11)                         ‐1% 652                       92% Mar 106                       55                           ‐                          Apr 65,108               71,870               63,088               (2,020)                  ‐3% (8,782)                  ‐12% May 1,523                  786                       ‐                          Jun ‐                        75                          ‐                          Jul 82,804               83,565               60,763               (22,042)               ‐27% (22,803)               ‐27% Sep ‐                        ‐                        518                       518                       100% 518                       100% Oct 75,167               78,334               58,934               (16,233)               ‐22% (19,400)               ‐25% Nov 35                          18                          1,452                  1,417                  4065% 1,434                  7971% YTD  Total 309,790$         320,000$         262,506$         (45,655)$            ‐15% (56,578)$            ‐18% Annual  Total 309,790$         320,000$          2016 vs. Budget Admission Tax  Revenue Year  to Date through December Month 2016 vs. 2015 2015 2016 2016 Actual Budget Actual $ % $ % Jan ‐$                            ‐$                            ‐$                            Feb ‐                        ‐                         ‐                          Mar ‐                        ‐                         ‐                          Apr ‐                        4,500,000        4,578,349        4,578,349        100% 78,349               2% May ‐                        ‐                         304,032            304,032            100% 304,032            100% Jun ‐                        ‐                         30,591               30,591               100% 30,591               100% Jul ‐                        250,000            376,209            376,209            100% 126,209            50% Aug ‐                        ‐                         334,807            334,807            100% 334,807            100% Sep ‐                        ‐                         10,779               10,779               100% 10,779               100% Oct ‐                        250,000            603,622            603,622            100% 353,622            141% Nov ‐                        ‐                         136,933            136,933            100% 136,933            100% Dec ‐                        ‐                         ‐                          YTD  Total ‐$                           5,000,000$     6,375,322$     6,375,322$     100% 1,375,322$     28% Annual  Total ‐$                           5,000,000$      *Total Business & Occupation Taxes (GF & CIP) Business & Occupation  Taxes* Year to Date through December Month 2016 vs. 2015 2016 vs. Budget 2015 2016 2016 Actual Budget Actual $ % $ % Jan 588,093$         981,621            559,894$         (28,199)$            ‐5% (421,727)$         ‐43% Feb 222,022            118,452            275,059            53,038               24% 156,608            132% Mar 26,067               17,543               31,642               5,575                  21% 14,099               80% Apr 513,360            144,635            207,099            (306,261)           ‐60% 62,464               43% May 167,985            82,039               111,131            (56,855)               ‐34% 29,092               35% Jun 25,663               21,063               26,936               1,273                  5% 5,873                  28% Jul 645,791            213,106            248,769            (397,022)           ‐61% 35,663               17% Aug 134,328            74,127               121,095            (13,233)               ‐10% 46,968               63% Sep 29,333               18,678               22,190               (7,143)                  ‐24% 3,512                  19% Oct 637,451            204,637            218,271            (419,180)           ‐66% 13,634               7% Nov 117,394            72,580               91,870               (25,524)               ‐22% 19,290               27% Dec 18,254               12,520               12,555               (5,699)                  ‐31%35                          0% YTD  Total 3,125,740$     1,961,000$     1,926,510$     (1,199,230)$   ‐38% (34,490)$           ‐2% Annual  Total 3,125,740$     1,961,000$      *Total Business License (GF & CIP) 2016 vs. 2015 Year to Date through December 2016 vs. Budget Business Licenses* Month Page 5 of 38 Monthly Financial Report December 2016      Building Permits and  Development Service Fees  Building Permits and  Development Service Fee  revenues totaled $468k in  December.  The year‐to‐date  development fees revenue of  $5.3 million is $783k or 13% less  than the year before and is also  $630k or 11% lower than budget.   The large variances in January  2016, March 2016, June 2015 and  July 2015 were due to large  payments for building permits  and plan review (Southport  Developer, Group Health, Boeing  and Paccar).        Intergovernmental  These revenue sources  include federal (direct  and indirect) grants,  state grants, state  shared revenues, local  grants, and  entitlements.  State  shared revenues and  Fire Districts’ 25 and 40  contracts compose 88%  of the total revenues in this category.  The year‐to‐date total Intergovernmental revenue is $10.7 million or 74% of the budget.   The variance with the prior year and budget is mainly due to the formation of the Renton Regional Fire Authority (RRFA).  The  loss in FD25 and FD40 intergovernmental service revenues is offset by the overall savings in the remaining Fire Department  budget.       State Shared Revenues  State Shared Revenue  collections totaled $5.9  million since the start of  the year.  Compared to  the prior year, State  Shared Revenues are  above by $495k or 9%.   Compared to the  projected budget, the  City is collecting $261k  or 5% more.  The higher  than expected collection  is due to collecting more  than anticipated  Criminal Justice’s Sales Tax, Criminal Justice’s High Crime, Marijuana Enforcement (not budgeted), and Fuel Tax.       2015 2016 2016 Actual Budget Actual $ % $ % Jan 260,603$         391,612$         661,363$         400,760$         154% 269,751$         69% Feb 328,557            418,687            413,420            84,863               26% (5,267)                  ‐1% Mar 275,826            363,627            583,658            307,832            112% 220,031            61% Apr 655,282            560,700            336,108            (319,174)           ‐49% (224,592)           ‐40% May 235,121            335,517            376,324            141,204            60% 40,807               12% Jun 1,024,848        819,666            437,619            (587,229)           ‐57% (382,047)           ‐47% Jul 873,549            675,349            462,211            (411,337)           ‐47% (213,137)           ‐32% Aug 454,971            436,156            397,578            (57,393)               ‐13% (38,578)              ‐9% Sep 586,213            552,157            380,480            (205,733)           ‐35% (171,676)           ‐31% Oct 462,191            489,437            479,048            16,857               4% (10,389)              ‐2% Nov 427,863            373,411            297,449            (130,414)           ‐30% (75,962)               ‐20% Dec 492,031            507,049            468,303            (23,728)              ‐5% (38,746)              ‐8% YTD  Total 6,077,055$     5,923,368$     5,293,563$     (783,493)$        ‐13% (629,805)$        ‐11% Annual  Total 6,077,055$     5,923,368$      Year to Date through December 2016 vs. Budget2016 vs. 2015 Month Building Permits  and Development Service Fees Intergovernmental 2015 2016 Bgt YTD Act Change 2016/2015  2016 Act  vs  Bgt  Fire  District #25 1,310,548$     1,300,000$     698,123$         (612,425)$      ‐47% $      (601,877)‐46% Fire  District #40 5,057,385        4,828,712        2,819,656        (2,237,729)    ‐44% (2,009,056)     ‐42% State Shared Revenue 5,439,235        5,672,795        5,933,890        494,655          9% 261,095          5% Federal Grants 868,752            1,072,307        542,638            (326,114)         ‐38% (529,669)          ‐49% State  Grants 39,894               124,080            51,274               11,381             29% (72,805)             ‐59% Other Grants/Intgovt 1,126,860        1,432,176        652,533            (474,327)         ‐42% (779,643)          ‐54% ARRA Grants ‐                              0                             ‐                              ‐                            N/A ‐                            0% Total  Rev YTD 13,842,673$  14,430,070$  10,698,115$  (3,144,558)$ ‐23%(3,731,955)$  ‐26% Total  Rev Annual 13,842,673$  14,430,070$   YTD %100% 100% 74% Note:  Includes  CJ Sales  Tax and FD25  & FD40 contracts 2015 2016 2016 Actual Budget Actual $ % $ % Crim Just Sales  Tax 2,484,718$     2,580,795$     2,701,787$     217,069$         9% 120,992$         5% Judicial Contribution 21,873                ‐                         18,092               (3,781)                  ‐17% 18,092               100% Crim Just ‐ High Crime 281,859            250,000            289,982            8,123                  3% 39,982               16% Crim Just ‐ Pop 25,972               24,000               27,122               1,149                  4% 3,122                  13% Crim Just ‐ Spec Prog 95,162               89,000               98,887               3,725                  4% 9,887                  11% State DUI 14,725               17,000               15,353               628                       4% (1,647)                  ‐10% Marijuana  Enforcement 5,856                  ‐                         29,625               23,769               406% 29,625               100% Liquor Profits 851,685            850,000            848,248            (3,437)                 0% (1,752)                 0% Liquor Excise  Tax 264,628            440,000            459,427            194,799            74% 19,427               4% Fuel  Tax 1,392,756        1,422,000        1,445,368        52,612               4% 23,368               2% YTD  Total 5,439,235$     5,672,795$     5,933,890$     494,655$         9% 261,095$         5% Annual Total 5,439,235$     5,672,795$      State  Shared Revenues 2016 vs. 2015 Revenue Year to Date through December 2016 vs. Budget Page 6 of 38 Monthly Financial Report December 2016      Charges for Services   These revenue sources consist of general government, public safety, plan review and inspection, culture and recreation, and  interfund/interdepartmental sales and services.  Recreation and interfund/interdepartmental sales and services constitute  62% of the total revenue in this category.  The year‐to‐date total charges for services are $8.1 million or 103% of the budget.   The following sections provide detail information for Public Safety, Recreation, and Interfund Services.      Public Safety Services  Public Safety Services totaled  $994k since the start of the year.   These services include private  security, adult probation  services, monitoring of prisoners,  and intergovernmental public  safety services (non‐grants).   Compared to the prior year, the  City is collecting $343k or 53%  more.  Compared to the year‐to‐ date budget, the City is over  budget by $364k or 58%.  The  variance with the prior year and  budget is due to collecting 4 large  payments/reimbursements for  electronic home detention and  School Resource Officer programs.      Recreation  Recreation revenues totaled  $39k for the current month.   Compared to the same month  the prior year, the City collected  $3k or 7% less.  Compared to the  projected monthly budget, the  City collected $700 or 2% less.   The year‐to‐date collection of  $1.6 million is $45k or 3% higher  than the year before but is $94k  or 5% lower than the year‐to‐ date budget.           2015 2016 2016 Actual Budget Actual $ % $ % Jan 58,509$            74,126$            104,644$         46,135$            79% 30,518$            41% Feb 42,228               36,766               99,623               57,395               136% 62,858               171% Mar 62,481               44,821               58,031               (4,450)                  ‐7% 13,211               29% Apr 146,715            77,816               51,002               (95,713)               ‐65% (26,814)               ‐34% May 55,309               38,231               48,201               (7,108)                  ‐13% 9,970                  26% Jun 33,004               59,020               179,089            146,085            443% 120,069            203% Jul 39,540               40,294               34,906               (4,634)                  ‐12% (5,388)                  ‐13% Aug 59,046               51,865               44,439               (14,608)               ‐25% (7,426)                  ‐14% Sep 23,104               28,310               67,570               44,466               192% 39,261               139% Oct 33,339               94,331               160,438            127,100            381% 66,107               70% Nov 46,384               35,303               67,763               21,379               46% 32,460               92% Dec 51,339               49,254               78,473               27,133               53% 29,219               59% YTD  Total 650,997$         630,135$         994,179$         343,182$         53% 364,044$         58% Annual  Total 650,997$         630,135$          2016 vs. Budget Month 2016 vs. 2015 Year to Date through December Public Safety Services 2015 2016 2016 Actual Budget Actual $ % $ % Jan 117,124$         104,917$         163,783$         46,659$            40% 58,866$            56% Feb 30,177               55,678               48,009               17,832               59% (7,669)                  ‐14% Mar 35,946               57,563               60,615               24,669               69% 3,052                  5% Apr 91,404               152,158            112,627            21,224               23% (39,530)               ‐26% May 64,015               96,002               72,246               8,231                  13% (23,756)               ‐25% Jun 227,942            225,001            239,771            11,829               5% 14,769               7% Jul 428,943            420,247            325,043            (103,900)           ‐24% (95,203)               ‐23% Aug 313,197            314,325            349,650            36,453               12% 35,325               11% Sep 119,720            134,250            107,652            (12,068)               ‐10% (26,598)               ‐20% Oct 55,478               72,003               45,706               (9,772)                  ‐18% (26,297)               ‐37% Nov 61,601               55,079               68,324               6,723                  11% 13,245               24% Dec 42,331               40,169               39,475               (2,856)                  ‐7% (694)                      ‐2% YTD  Total 1,587,878$     1,727,393$     1,632,903$     45,025$            3% (94,490)$           ‐5% Annual  Total 1,587,878$     1,727,393$      2016 vs. Budget2016 vs. 2015 Month Recreation Year to Date through December Page 7 of 38 Monthly Financial Report December 2016      Interfund Services  The year‐to‐date collections for  Interfund Services revenues are  $3.4 million.  Compared to the  prior year, the revenues are over  by $271k or 9%.  Compared to the  projected budget, the revenues  are below by $62k or 2%.  2016’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.      Fines and Penalties  These revenue sources contain  civil (penalties, infractions, and  parking), criminal (traffic, non‐ traffic, and costs), and non‐court  fines, forfeitures, and penalties.   The table below breaks down  these fines by type.  The year‐to‐ date total fines and penalties is  $2.9 million.  This is $159k or 5%  lower than a year ago and is also  $460k or 14% below the budget.   The reason for the variance with  the budget is due to a change in  accounting for December 2014’s  revenue.  In the past we would  record December through November, but starting in 2015 we are recording January through December.  2016’s budget is  based on 2014/2015 activity.        2015 2016 2016 Actual Budget Actual $ % $ % Jan 265,068$         286,617$         272,841$         7,774$               3% (13,776)$            ‐5% Feb 264,413            286,617            286,748            22,336               8% 131                       0% Mar 260,071            286,617            305,054            44,983               17% 18,437               6% Apr 248,466            286,617            276,238            27,772               11% (10,380)              ‐4% May 260,774            286,617            272,641            11,867               5% (13,976)              ‐5% Jun 292,480            286,617            260,223            (32,257)               ‐11% (26,394)              ‐9% Jul 252,451            286,617            259,888            7,438                  3% (26,729)              ‐9% Aug 248,774            286,617            273,851            25,076               10% (12,767)              ‐4% Sep 247,822            286,617            286,057            38,236               15% (560)                     0% Oct 283,145            286,617            277,517            (5,628)                  ‐2% (9,100)                  ‐3% Nov 257,874            286,617            295,584            37,710               15% 8,967                  3% Dec 225,093            286,617            311,019            85,926               38% 24,402               9% YTD  Total 3,106,430$     3,439,406$     3,377,663$     271,232$         9% (61,744)$            ‐2% Annual  Total 3,106,430$     3,439,406$      2016 vs. Budget Month Interfund Services Year to Date through December 2016 vs. 2015 2015 2016 2016 Actual Budget Actual $ % $ % Jan 124,856$         152,177$         136,421$         11,565$            9% (15,756)$            ‐10% Feb 213,981            215,466            217,667            3,686                  2% 2,201                  1% Mar 275,737            281,062            263,648            (12,088)              ‐4% (17,414)              ‐6% Apr 245,206            298,933            250,873            5,667                  2% (48,060)               ‐16% May 257,217            273,396            214,613            (42,604)               ‐17% (58,783)               ‐22% Jun 268,116            288,287            261,254            (6,862)                  ‐3% (27,033)              ‐9% Jul 221,949            246,930            222,267            318                       0% (24,663)               ‐10% Aug 280,257            313,023            274,964            (5,293)                  ‐2% (38,059)               ‐12% Sep 272,343            299,806            200,986            (71,357)               ‐26% (98,820)               ‐33% Oct 260,327            290,029            238,517            (21,810)              ‐8% (51,512)               ‐18% Nov 281,222            333,431            273,338            (7,884)                  ‐3% (60,093)               ‐18% Dec 318,027            327,959            306,114            (11,913)              ‐4% (21,845)              ‐7% YTD  Total 3,019,236$     3,320,500$     2,860,662$     (158,573)$        ‐5% (459,838)$        ‐14% Annual  Total 3,019,236$     3,320,500$      Month 2016 vs. Budget2016 vs. 2015 Year to Date through December Fines  and Penalties by Month Year to Date through December 2015 2016 2016 Actual Budget Actual $ % $ % Civil Penalties 3,868$               15,500$            2,557$               (1,312)$               ‐34% (12,943)$            ‐84% Civil Infraction Penalties 385,164            605,500            366,683            (18,481)               ‐5% (238,817)           ‐39% Civil Parking Infraction Penalties 165,557            197,000            174,863            9,307                  6% (22,137)               ‐11% Photo Enforcement Program 2,171,184        2,194,000        1,959,071        (212,113)           ‐10% (234,929)           ‐11% Criminal Traffic  Misdemeanor Fines 87,307               112,000            81,217               (6,090)                  ‐7% (30,783)               ‐27% Criminal Non ‐Traffic  Fines 65,485               52,000               32,414               (33,071)               ‐51% (19,586)               ‐38% Criminal Costs 104,452            122,500            97,412               (7,039)                  ‐7% (25,088)               ‐20% Non‐Court Fines, Forfeitures and Penalties 36,220               22,000               146,446            110,226            304% 124,446            566% YTD  Total 3,019,236$     3,320,500$     2,860,662$     (158,573)$         ‐5% (459,838)$        ‐14% Annual Total 3,019,236$     3,320,500$      Revenue 2016 vs. Budget Fines  and Penalties by Type 2016 vs. 2015 Page 8 of 38 Monthly Financial Report December 2016      Included in the Fines and Penalties revenue  budget is $2.2 million from the Photo  Enforcement program.  The monthly budget  is based on the prior year’s revenue.  The  year‐to‐date collections from this program  equates to $2 million.      The associated costs includes the equipment  provided by American Traffic Solutions, Inc.  (ATS), dedicated 1 FTE in the Court Services  Department to process the increased  caseload and 1.1 FTEs in the Police  Department for support services.  This staff  time, along with a 50% pro tem budget and  interpreter costs amounts to $320k for  personnel costs.  The total costs for the  program equates to $1.1 million which is  represented in the table.  Due to the timing  of when the invoice was received, January 2016’s equipment rental cost was recorded in February.      Miscellaneous  This revenue source reflects the  collection of interest and other  earnings, rents, leases, and  concessions, contributions, and  donations from private sources,  and other miscellaneous  revenues.  The year‐to‐date total  miscellaneous is $3.2 million.   Compared to last year, the  revenues are above by $820k or  35%.  Compared to the projected  year‐to‐date budget, the  revenues are over by $645k or  25%.  The large variance with the  prior year and budget is due to  collecting more than anticipated Interest, Other (credit card rebates and misc settlements), and Seizure Funds.  Seizure Funds  are restricted to drug enforcement only and are not available for general operating purposes.           2015 2016 2016 Actual Budget Actual $ % $ % Jan 269,664$         199,599$         258,876$         (10,789)$            ‐4% 59,276$            30% Feb 135,539            108,716            802,908            667,369            492% 694,193            639% Mar 182,386            107,242            125,950            (56,436)               ‐31% 18,708               17% Apr 132,893            128,174            142,439            9,546                  7% 14,265               11% May 144,753            101,465            139,504            (5,249)                  ‐4% 38,039               37% Jun 215,629            224,184            174,848            (40,781)               ‐19% (49,336)               ‐22% Jul 189,913            65,270               181,285            (8,628)                  ‐5% 116,015            178% Aug 199,969            130,905            294,665            94,696               47% 163,759            125% Sep 139,977            741,419            160,616            20,638               15% (580,803)           ‐78% Oct 173,512            170,905            152,817            (20,695)               ‐12% (18,088)               ‐11% Nov 148,227            112,137            327,568            179,340            121% 215,430            192% Dec 435,114            451,742            425,765            (9,349)                  ‐2% (25,977)              ‐6% YTD  Total 2,367,576$     2,541,759$     3,187,241$     819,665$         35% 645,482$         25% Annual  Total 2,367,576$     2,541,759$      Year to Date through December Month 2016 vs. Budget2016 vs. 2015 Miscellaneous  Revenues  by Month Favorable 16 Budget 16 Actual 16  Budget 16 Actual (Unfavorable)1 Jan 103,426$         131,281$         89,912$            26,662$            104,619$          Feb 124,175            167,005            89,912               97,181               69,824                Mar 170,255            184,903            89,912               95,109               89,794                Apr 187,598            168,524            89,912               95,106               73,417                May 163,442            143,229            89,912               95,046               48,182                Jun 186,599            193,341            89,912               95,109               98,232                Jul 164,807            144,672            89,912               95,037               49,635                Aug 221,543            154,121            89,912               94,934               59,187                Sep 213,406            130,456            89,912               94,875               35,580                Oct 195,225            169,329            89,912               94,953               74,376                Nov 218,318            196,382            89,912               95,070               101,312             Dec 245,205            175,828            89,912               163,312            12,515                YTD  Total 2,194,000$     1,959,071$     1,078,943$     1,142,398$     816,673$          Annual Total 2,194,000$     1,078,943$      1Actuals  of Revenues and Expenses Photo Enforcement  Program Year to Date through December Month Revenues Expenses 2015 2016 2016 Actual Budget Actual $ % $ % Interests and Other Earnings 973,208$         875,300$         1,058,880$     85,673$            9% 183,580$         21% Rents, Leases, and Concessions 762,361            598,616            642,192            (120,169)            ‐16% 43,576               7% Contributions/Donations  from Private Sources 147,292            102,700            96,582               (50,710)               ‐34% (6,118)                  ‐6% Other 463,040            302,000            402,294            (60,746)               ‐13% 100,294            33% Seizure Funds  ‐ Federal/State/Local 21,676               663,143            987,293            965,617            4455% 324,150            49% YTD  Total 2,367,576$     2,541,759$     3,187,241$     819,665$         35% 645,482$         25% Annual  Total 2,367,576$     2,541,759$      2016 vs. Budget Miscellaneous  Revenues  by Type Year to Date through December Revenue 2016 vs. 2015 Page 9 of 38 Monthly Financial Report December 2016      EXPENSES  Overall the City has expended 93% of its budgeted general governmental expenditures at the end of December.  This is $9.5  million or 7% below year‐to‐date budgeted expenditures.  $2.1 million of the savings is related to the Police department  which is consists of restricted seizure funds, restricted grant funds, and unsettled Police union contract agreement (all of  which will be carried forward into 2017).  $3.2 million of the savings is related to the Fire department’s loss in revenue (EMS  levy and FD25&40 service contracts) as explained earlier in the report.  See below for summary of unfavorable items for  general governmental departments.    Other city services (Debt Service and Non‐department) is over the budget by $78k or 0.5%.  This is due to overspending on  the budget for retirement/separation pay‐outs.       Page 10 of 38 Monthly Financial Report December 2016      CASH AND INVESTMENTS –  4TH QUARTER  The current cash and  investments (C&I)  portfolio is provided in  the table to the right.   The City’s current C&I  balance is $165.8  million.    Currently, the majority  of the portfolio is  located in cash deposits  (US Bank) and the State  Investment Pool.  The  rest is spread out  between US Federal  Agency Securities and  various certificates of deposits.      The existing portfolio yield is approximately 0.71%.  Current  % Blended Allowed  per policy Current  Portfolio (principal value) 25% N/A $        40,852,926  0% 100%‐$                     45% 75% 75,144,187$        11% 75% 18,453,255$        19% 75% 31,306,761$        0% 25%‐$                     TOTAL INVESTMENTS 100% 165,757,128$       *Excluding Cash the portfolio distribution is 60% LGIP; 25% CD's; 15% GSE's By Type Cash US Treasury Securities Local Government Investment Pool US Federal  Agency Securities Certificates  of Deposit Commercial  Paper Cash 25% LGIP 45% GSE's 11% CD's 19% Distribution by Type      By Institution Current  % Blended Allowed by  Policy Current  Portfolio (principal value)Maturity Date APY Weighted  Yield Blended Current  Principal  Balance Cash US Bank ‐ Cash 25%N/A 40,852,926 overnight 0.45% 0.11%40,852,926    US Treasury Securities none 0%100%‐                        N/A N/A N/A ‐                              Local Government  Investment Pool 3920 State Investment Pool 45%75%75,144,187 10/1/2014 0.10% 0.24%75,144,187          US Federal Agency Securities * 314179A FHLB 1,996,920            8/11/2017 1.05%0.01% 315189D FNMA 4,997,500            10/26/2018 1.06%0.03% 314179G FHLB 5,009,485            10/17/2017 0.93%0.03% 315209A FHLMC 1,600,000            5/26/2020 1.75%0.02% 314179C FNMA 4,849,350          11/28/2017 1.00%0.03% Certificates of Deposit 115184A First Savings Bank Northwest 5,092,087 2/6/2018 1.03%0.03% 116214A First Savings Bank Northwest 5,154,418 2/3/2021 1.67%0.05% 114174A First Savings Bank Northwest 5,000,000 10/29/2017 1.15%0.03% 116191A Opus 5,000,000 2/25/2019 1.00%0.03% 116181A Opus 5,000,000 12/21/2018 1.35%0.04% 116191B Opus 5,000,000 12/21/2019 1.60%0.05% 216183A Commencement Bank (CDARS)1%1,060,257 9/16/2018 1.00%0.01%1,060,257           Commercial Paper none 0.00%5%‐                        N/A N/AN/A ‐                            165,757,128$      165,757,128$   15,246,504          *Held in our safekeeping account at BNY Trust and Custody TOTAL CASH & INVESTMENTS 20% 9% 15,000,000         9% 18,453,255         75%11% Page 11 of 38 Monthly Financial Report December 2016      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 ‐                  ‐                  ‐                  ‐                  83,823            53,500            ‐                   Grants  / intergovernmental 738,465          ‐                  111,688          ‐                  2,212,495       8,581,921       ‐                   Charges  for services 147,896          1,781,880       17,055,690     17,347,236     10,015,932     10,822,605     16,120,860      Interdepartmental  services ‐                 ‐                  ‐                  ‐                  ‐                  ‐                  ‐                   Fines  and penalties 3,473              ‐                  ‐                  ‐                  522                 ‐                  ‐                   Rents, leases, and misc fees 2,582,708       414,184          139,284          182,751          ‐                  ‐                  ‐                   Interest and other misc 11,356            2,990              16,502            5,431,626       3,695,864       2,546,008       21,609             TOTAL REVENUES 3,483,898       2,199,054       17,323,164     22,961,613     16,008,636     22,004,034     16,142,469      EXPENSES: Utility billing ‐                 ‐                  136,560          118,176          98,043            157,558          ‐                   Utility systems ‐                 ‐                  16,291,336     3,506,720       3,262,057       11,797,050     ‐                   Utility maintenance ‐                 ‐                  295,306          5,578,174       1,656,891       2,730,230       15,140,189      Transportation 1,649,629       ‐                  ‐                  ‐                  ‐                  ‐                  ‐                   Golf ‐                 1,964,995       ‐                  ‐                  ‐                  ‐                  ‐                   TOTAL EXPENSES 1,649,629       1,964,995       16,723,202     9,203,070       5,016,991       14,684,838     15,140,189      AMOUNT AVAILABLE FOR DEBT SERVICE 1,834,269       234,059          599,962          13,758,543     10,991,645     7,319,196       1,002,280        DEBT SERVICE: Principal ‐                 ‐                  ‐                  5,848,660       3,386,844       2,406,734       ‐                   Interest ‐                 ‐                  ‐                  506,148          248,631          744,392          ‐                   TOTAL DEBT SERVICE ‐                 ‐                  ‐                  6,354,808       3,635,475       3,151,126       ‐                   CAPITAL PROJECTS 276,175          86,915            ‐                  1,483,976       5,122,396       3,949,529       ‐                   TRANSFERS IN/(OUT)(83,500)          ‐                  ‐                  (72,447)          (10,628)          (7,343)            ‐                   CHANGE IN FUND BALANCE 1,474,594       147,144          599,962          5,847,312       2,223,146       211,198          1,002,280        BEGINNING FUND BALANCE, Jan  1 1,144,749       (110,056)        2,151,456       22,681,621     11,636,515     10,682,778     3,992,378        ENDING FUND BALANCE, Dec 31 2,619,343       37,088            2,751,418       28,528,933     13,859,661     10,893,976     4,994,658            Page 12 of 38 Monthly Financial Report December 2016      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 ‐               186,866        ‐                ‐                     ‐                ‐                ‐                 Grants  / intergovernmental ‐               ‐                ‐                ‐                     ‐                ‐                42,430          Charges  for services Equipment rental  m&o 2,839,429    3,296,220    ‐                ‐                     ‐                ‐                ‐                 Print and mail ‐               51,612         ‐                408,441             ‐                ‐                ‐                 Communications ‐               389,500       465,000       561,112             ‐                ‐                ‐                 Facilities ‐               ‐                4,507,452    ‐                     ‐                ‐                ‐                 Data  cards  and cell  phones ‐               147,636       ‐                ‐                     ‐                ‐                ‐                 IT service contracts ‐               472,104        ‐                ‐                     ‐                ‐                ‐                 Interest and other misc 29,680         12,014         7,096           2,870                 63,035         35,620         43,774          Internal service fund misc: Vehicle  / equipment capital  recovery 2,823,876    147,000       ‐                ‐                     ‐                ‐                ‐                 Insurance premiums ‐               ‐                ‐                ‐                     1,763,103    ‐                ‐                 Worker's  comp/unemployment ‐               ‐                ‐                ‐                     1,682,655    ‐                ‐                 Benefit premiums ‐               ‐                ‐                ‐                     ‐                10,673,326  2,225,290     Other misc 4,682           166              9,273           ‐                     ‐                1,027,188    18,229          Interfund Loan ‐               ‐                ‐                ‐                     321,298       ‐                ‐                 Capital  contributions ‐               ‐                ‐                ‐                     ‐                ‐                ‐                 Disposal of capital  assets 89,647         ‐                ‐                ‐                     ‐                ‐                ‐                 Insurance recoveries 19,500         ‐                ‐                ‐                     222,602       ‐                ‐                 TOTAL REVENUES 5,806,814    4,703,118    4,988,821    972,423             4,052,693    11,736,134  2,329,723     EXPENSES: Communications 622,695              Equipment rental 3,817,473     Facilities 4,470,838     Healthcare 13,303,252   Information technology 4,330,703     Print and mail 325,634              Retiree healthcare 1,142,961     Risk management: Ri sk management 2,159,037     Unemployment 87,557          Worker's  compensation 1,988,899     TOTAL EXPENSES 3,817,473    4,330,703    4,470,838    948,329             4,235,493    13,303,252  1,142,961     AMOUNT AVAILABLE FOR CAPITAL 1,989,341    372,415       517,983       24,094               (182,800)      (1,567,118)   1,186,762     CAPITAL PROJECTS 1,268,568    450,755       502,433       ‐                     ‐                ‐                ‐                 TRANSFERS IN 91,000         321,404       ‐                12,500               ‐                ‐                ‐                 TRANSFERS (OUT)‐               ‐                ‐                (70,000)              (50,000)        (1,800,000)   ‐                CHANGE IN FUND BALANCE 811,773       243,064       15,550         (33,406)              (232,800)      (3,367,118)   1,186,762     BEGINNING FUND BALANCE, Jan  1 5,620,280    2,327,309    1,259,503    576,333             13,085,310  7,523,267    8,892,488     ENDING FUND BALANCE, Dec 31 6,432,053    2,570,373    1,275,053    542,927             12,852,510  4,156,149    10,079,250   Page 13 of 38 Monthly Financial Report December 2016      FUND BALANCE  Page 15 shows the ending fund balance as of December 2016.  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 December, the City has $26.6 million reported in the combined general governmental fund balance of the  current year’s operating budget, which is approximately 21% of budgeted operating expenditures.  This is an increase of $6.6  million from the year’s beginning balance.  December’s ending fund balance is over the anticipated General Governmental  Fund Balance of $17.1 million by $9.5 million or 55.7%.  Although the ending fund balance is above projections, it is consistent  with the prior years’ trends.      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 hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.  Page 14 of 38 Monthly Financial Report December 2016      City  of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Cash  Basis through December 31, 2016 Funds Balance  01/01/2016 Budgeted  Revenue Revenue  12/31/16 Total Funds   Available Budgeted  Expenditure Expenditure  12/31/16 Ending Balance GENERAL GOVERNMENT FUNDS: 19,962,845      125,849,416    125,816,444    145,779,289    128,753,259    119,215,504    26,563,785       000 General 12,622,447      93,657,021      95,144,219      107,766,666    96,231,413      89,565,639      18,201,028       001 Community Services 2,818,784        13,117,674      12,796,338      15,615,122      13,361,577      11,845,356      3,769,766         003 Street 2,422,668        10,363,584      10,521,490      12,944,158      11,569,492      11,007,791      1,936,367         004 Community Dev Block Grant 66,654             882,158           264,269           330,923           882,158           264,269           66,654              005 Museum 66,388             235,281           235,526           301,914           235,281           229,543           72,372              009 Farmers  Market 110,830           120,022           80,410             191,240           111,256           100,510           90,730              011 Fire Health & Wellness 88,406             25,000             14,825             103,231           113,406           103,231            ‐                       201 Ltd  GO Bonds  Gen Govt Debt 845,273           1,755,255        1,762,288        2,607,561        1,755,255        1,755,450        852,111            215 Gen Govt Misc Debt Service 921,395           5,693,421        4,997,079        5,918,474        4,493,421        4,343,716        1,574,757         SPECIAL REVENUE FUNDS: 1,681,875        1,931,140        2,202,966        3,884,841        2,709,762        2,284,875        1,599,966         102 Arterial  Street 31,697             650,000           681,783           713,480           650,000           650,000           63,480              108 Leased  City Properties 560,515           943,466           1,051,907        1,612,422        1,466,244        1,335,557        276,865            110 Hotel  Motel 315,590           225,000           318,665           634,255           326,298           231,652           402,603            125 1% For Art 111,206           15,000             17,283             128,489           102,950           ‐                      128,489            127 Cable  Communication 330,376           97,674             131,794           462,170           164,270           67,666             394,504            135 Springbrook Wetlands  Bank 332,491           ‐                      1,534               334,025           ‐                      ‐                      334,025            CAPITAL PROJECT  FUNDS (CIP):21,039,649      32,296,166      24,420,906      45,460,555      46,940,153      19,258,150      26,202,405       303 Community Dev Mitigation 1,239,509        86,500             291,974           1,531,483        276,289           276,289           1,255,194         304 Fire  Mitigation 1,209,670        99,000             247,493           1,457,163        850,000           850,000           607,163            305 Transportation  Mitigation 937,248           610,660           671,160           1,608,408        110,660           110,660           1,497,748         316 Municipal  Facilities CIP 9,264,141        10,642,477      9,096,646        18,360,787      18,805,652      3,322,756        15,038,031       317 Transportation CIP 3,947,132        20,857,529      14,095,137      18,042,269      23,460,878      12,401,774      5,640,495         326 Housing Opportunity 1,041,775        ‐                      4,808               1,046,583        36,500             5,410               1,041,173         336 New Library Development 3,400,174        ‐                      13,688             3,413,862        3,400,174        2,291,261        1,122,601         ENTERPRISE FUNDS:52,179,441      114,589,323    100,186,830    152,366,271    132,596,982    88,681,192      63,685,079       4X2 Airport Operating & CIP 1,144,749        14,755,346      3,483,898        4,628,647        14,301,353      2,009,304        2,619,343         403 Solid Waste  Utility 2,151,456        16,514,320      17,323,163      19,474,619      17,140,339      16,723,202      2,751,417         4X4 Golf Operating & CIP (110,056)         2,812,793        2,249,054        2,138,998        2,295,432        2,101,910        37,088              4X5 Water Operating & CIP 22,681,621      20,907,021      22,975,575      45,657,196      30,690,837      17,128,262      28,528,934       4X6 Waste  Water Operating & CIP 11,636,515      18,046,588      16,008,636      27,645,151      22,137,504      13,785,489      13,859,662       416 King  County Metro 3,992,378        16,638,722      16,142,469      20,134,847      16,638,722      15,140,189      4,994,658         4X7 Surface  Water Operating & CIP 10,682,778      24,914,533      22,004,035      32,686,813      29,392,795      21,792,836      10,893,977       INTERNAL SERVICE FUNDS:39,284,490      37,793,031      35,014,630      74,299,120      41,309,074      36,390,806      37,908,314       501 Equipment Repair/Replacement 5,620,280        6,164,145        5,897,814        11,518,094      5,685,530        5,086,041        6,432,053         502 Insurance 13,085,310      4,166,201        4,052,693        17,138,003      3,662,594        4,285,494        12,852,509       503 Information Services 2,327,309        4,900,871        5,024,523        7,351,832        6,077,478        4,781,458        2,570,374         504 Facilities 1,259,503        4,953,544        4,988,821        6,248,324        5,407,389        4,973,271        1,275,053         505 Communications 576,333           1,040,239        984,923           1,561,256        1,112,381        1,018,329        542,927            512 Insurance, Healthcare 7,523,267        14,295,824      11,736,133      19,259,400      18,196,149      15,103,252      4,156,148         522 Insurance, Leoff1 Retirees HC 8,892,488        2,272,207        2,329,723        11,222,211      1,167,553        1,142,961        10,079,250       FIDUCIARY FUNDS: 5,299,035        468,000           487,666           5,786,701        200,475           208,656           5,578,045         611 Firemen's  Pension 5,299,035        468,000           487,666           5,786,701        200,475           208,656           5,578,045         TOTAL  FUNDS 139,447,335 312,927,076 288,129,442 427,576,777 352,509,705 266,039,183 161,537,594  Page 15 of 38 City of Renton General Government Financial Position 2016 Budget Year General Government Summary  Revenues Expenditures  $ Difference over (under)  w/beginning  balance  19,962,845             January 7,317,475              8,625,290              (1,307,815)             18,655,030             February 14,715,559            18,026,295            (3,310,736)             16,652,109             March 21,798,267            27,039,048            (5,240,781)             14,722,064             April 40,464,776            35,281,644            5,183,131              25,145,976             May 57,969,563            44,251,964            13,717,599            33,680,444             June 64,628,067            53,224,181            11,403,886            31,366,731             July 71,753,118            67,206,203            4,546,916              24,509,761             August 79,378,013            74,281,749            5,096,264              25,059,109             September 85,974,133            81,242,284            4,731,848              24,694,693             October 99,791,497            94,419,834            5,371,663              25,334,508             November 116,702,709          100,928,993          15,773,716            35,736,561             December 125,816,444          119,215,504          6,600,940              26,563,785              (9,000,000)  (8,000,000)  (7,000,000)  (6,000,000)  (5,000,000)  (4,000,000)  (3,000,000)  (2,000,000)  (1,000,000)  ‐  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  10,000,000  11,000,000  12,000,000  13,000,000  14,000,000  15,000,000  16,000,000  17,000,000  18,000,000  ‐  10,000,000  20,000,000  30,000,000  40,000,000  50,000,000  60,000,000  70,000,000  80,000,000  90,000,000  100,000,000  110,000,000  120,000,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Change in Fund  Balance Rev/Exp Revenues Expenditures Change in Fund Balance Page 16 of 38 City of Renton Monthly Revenue Analysis ‐ 2016 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 6,690,025        7,317,475        9.38% Feb 13,103,940      14,715,559      12.30% Mar 19,856,255      21,798,267      9.78% Apr 39,849,234      40,464,776      1.54% May 57,818,499      57,969,563      0.26% Jun 64,527,844      64,628,067      0.16% Jul 71,436,985      71,753,118      0.44% Aug 78,200,536      79,378,013      1.51% Sep 85,547,245      85,974,133      0.50% Oct 98,992,800      99,791,497      0.81% Nov 116,435,629    116,702,709    0.23% Dec 125,849,415    125,816,444     ‐0.03% Percent of budget 99.97% Property Tax Budget YTD Actual Annual %  over (under) Jan 68,794              44,745               ‐34.96% Feb 382,923           359,864            ‐6.02% Mar 1,343,934        1,633,550        21.55% Apr 11,739,798      9,489,780        ‐19.17% May 19,499,635      19,396,313      ‐0.53% Jun 19,650,371      19,534,107      ‐0.59% Jul 19,717,283      19,591,281      ‐0.64% Aug 19,814,300      19,831,817      0.09% Sep 20,388,854      20,390,534      0.01% Oct 26,797,806      26,624,443      ‐0.65% Nov 37,004,304      36,893,234      ‐0.30% Dec 37,213,314      37,038,480      ‐0.47% Percent of budget 99.53%  $‐  $10  $20  $30  $40  $50  $60  $70  $80  $90  $100  $110  $120  $130  $140 Millions Total Revenue General Government Budget Actual Last Year  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33  $36  $39 Millions Property Tax Budget Actual Last Year Page 17 of 38 City of Renton Monthly Revenue Analysis ‐ 2016 Budget Year Sales Tax Budget YTD Actual Annual %  over (under) Jan 2,169,936        2,212,710        1.97% Feb 4,845,486        4,807,357         ‐0.79% Mar 6,916,017        6,882,003         ‐0.49% Apr 8,977,504        8,995,034        0.20% May 11,417,259      11,583,888      1.46% Jun 13,566,148      13,963,417      2.93% Jul 15,793,754      16,317,079      3.31% Aug 18,288,563      19,044,048      4.13% Sep 20,678,990      21,480,124      3.87% Oct 23,140,231      24,170,845      4.45% Nov 25,681,143      27,002,419      5.14% Dec 28,100,000      29,468,008      4.87% Percent of budget 104.87% Note:  Excludes CJ Sales Tax and Natural Gas Use Tax. Utility Tax Budget YTD Actual Annual %  over (under) Jan 1,376,913        1,509,960        9.66% Feb 2,788,817        3,107,308        11.42% Mar 4,318,909        4,531,081        4.91% Apr 5,538,866        5,877,363        6.11% May 6,822,678        7,240,686        6.13% Jun 8,119,957        8,366,531        3.04% Jul 9,268,345        9,642,866        4.04% Aug 10,548,232      10,890,792      3.25% Sep 11,740,472      12,168,294      3.64% Oct 12,923,109      13,520,182      4.62% Nov 14,164,087      14,648,282      3.42% Dec 15,552,444      16,007,999      2.93% Percent of budget 102.93% Note:  Includes Natural Gas Use Tax.  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27 Millions Sales Tax Budget Actual Last Year  $‐  $2  $4  $6  $8  $10  $12  $14  $16  $18 Millions Utility Tax Budget Actual Last Year Page 18 of 38 City of Renton Monthly Revenue Analysis ‐ 2016 Budget Year Licenses &  Permits Budget YTD Actual Annual %  over (under) Jan 487,642           707,784           45.14% Feb 831,464           1,079,373        29.82% Mar 1,076,639        1,559,970        44.89% Apr 1,451,255        1,809,916        24.71% May 1,741,566        2,089,751        19.99% Jun 2,188,568        2,314,634        5.76% Jul 2,798,270        2,716,644         ‐2.92% Aug 3,178,244        3,035,243         ‐4.50% Sep 3,647,384        3,328,686         ‐8.74% Oct 4,074,674        3,717,906         ‐8.76% Nov 4,357,004        3,933,912         ‐9.71% Dec 4,647,000        4,176,571         ‐10.12% Percent of budget 89.88% Note:  GF only Intergovt'l Budget YTD Actual Annual %  over (under) Jan 922,404           589,820            ‐36.06% Feb 1,466,633        1,223,323        ‐16.59% Mar 2,029,330        1,784,286        ‐12.08% Apr 3,144,606        2,487,675        ‐20.89% May 5,922,220        6,211,081        4.88% Jun 6,525,704        7,149,225        9.55% Jul 7,034,800        7,708,932        9.58% Aug 7,940,989        8,340,808        5.03% Sep 8,553,466        8,934,054        4.45% Oct 9,318,994        9,487,270        1.81% Nov 11,213,822      9,981,050        ‐10.99% Dec 14,430,070      10,698,115      ‐25.86% Percent of budget 74.14% Note:  Includes CJ Sales Tax and FD25 & FD40 contracts  $‐  $2  $4  $6  $8  $10  $12  $14  $16 Millions Intergovernmental Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50 Millions Licenses & Permits Budget Actual Last Year Page 19 of 38 City of Renton Monthly Revenue Analysis ‐ 2016 Budget Year Charges for  Services Budget YTD Actual Annual %  over (under) Jan 586,575           640,658           9.22% Feb 1,094,135        1,197,265        9.43% Mar 1,666,865        1,777,230        6.62% Apr 2,446,007        2,377,940         ‐2.78% May 2,962,444        2,926,771         ‐1.20% Jun 3,948,930        3,873,402         ‐1.91% Jul 4,837,157        4,648,795         ‐3.89% Aug 5,593,436        5,488,977         ‐1.87% Sep 6,163,484        6,084,569         ‐1.28% Oct 6,754,156        6,724,439         ‐0.44% Nov 7,268,708        7,301,163        0.45% Dec 7,909,932        8,117,361        2.62% Percent of budget 102.62% Note: Excludes FD25 & FD40 contracts Fines &  Forfeits Budget YTD Actual Annual %  over (under) Jan 152,177           136,421           ‐10.35% Feb 367,643           354,088           ‐3.69% Mar 648,705           617,736           ‐4.77% Apr 947,638           868,609           ‐8.34% May 1,221,034        1,083,222        ‐11.29% Jun 1,509,321        1,344,477        ‐10.92% Jul 1,756,252        1,566,744        ‐10.79% Aug 2,069,275        1,841,708        ‐11.00% Sep 2,369,080        2,042,694        ‐13.78% Oct 2,659,110        2,281,211        ‐14.21% Nov 2,992,541        2,554,549        ‐14.64% Dec 3,320,500        2,860,662        ‐13.85% Percent of budget 86.15%  $‐  $1  $2  $3  $4  $5  $6  $7  $8  $9 Millions Charges for Services Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50 Millions Fines & Forfeits Budget Actual Last Year Page 20 of 38 City of Renton Monthly Revenue Analysis ‐ 2016 Budget Year Other Taxes Budget YTD Actual Annual %  over (under) Jan 725,986           1,216,500        67.57% Feb 1,018,440        1,525,197        49.76% Mar 1,440,215        1,824,678        26.69% Apr 5,059,345        7,228,286        42.87% May 5,518,967        5,968,173        8.14% Jun 6,081,965        6,431,675        5.75% Jul 7,228,301        7,728,893        6.93% Aug 7,633,852        8,778,071        14.99% Sep 8,132,788        9,258,013        13.84% Oct 9,281,088        10,825,217      16.64% Nov 9,598,253        11,597,564      20.83% Dec 10,029,000      12,132,447      20.97% Percent of budget 120.97% Misc Budget YTD Actual Annual %  over (under) Jan 199,599           258,876           29.70% Feb 308,315           1,061,784        244.38% Mar 415,557           1,187,734        185.82% Apr 543,731           1,330,173        144.64% May 645,196           1,469,677        127.79% Jun 869,381           1,644,525        89.16% Jul 934,651           1,825,810        95.35% Aug 1,065,556        2,120,475        99.00% Sep 1,806,974        2,281,090        26.24% Oct 1,977,880        2,433,908        23.06% Nov 2,090,017        2,761,475        32.13% Dec 2,541,759        3,187,241        25.40% Percent of budget 125.40%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50 Millions Miscellaneous Budget Actual Last Year  $‐  $1  $2  $3  $4  $5  $6  $7  $8  $9  $10  $11  $12  $13 Millions Other Taxes Budget Actual Last Year Page 21 of 38 City of Renton Monthly Revenue Analysis ‐ 2016 Budget Year Other  Financing Budget YTD Actual Annual %  over (under) Jan ‐                          ‐                         N/A Feb 84                      ‐                         0.00% Mar 84                      ‐                         0.00% Apr 484                    ‐                         0.00% May 2,067,499         ‐                         0.00% Jun 2,067,499        6,075                 ‐99.71% Jul 2,068,173        6,075                 ‐99.71% Aug 2,068,088        6,075                 ‐99.71% Sep 2,065,751        6,075                 ‐99.71% Oct 2,065,751        6,075                 ‐99.71% Nov 2,065,751        29,061               ‐98.59% Dec 2,105,396        2,129,561        1.15% Percent of budget 101.15% REET Budget YTD Actual Annual %  over (under) Jan 250,883           1,204,479        380.10% Feb 426,670           1,401,806        228.55% Mar 807,442           1,610,258        99.43% Apr 1,293,394        1,946,242        50.48% May 1,730,061        2,421,486        39.97% Jun 2,260,012        2,826,665        25.07% Jul 2,884,483        3,470,703        20.32% Aug 3,196,923        4,230,285        32.32% Sep 3,695,296        4,752,757        28.62% Oct 4,247,181        5,312,309        25.08% Nov 4,656,951        5,814,448        24.86% Dec 5,200,000        6,121,830        17.73% Percent of budget 117.73%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  $5.50  $6.00  $6.50 Millions Real Estate Excise Tax Budget Actual Last Year $0 $2 $4 $6 $8 $10 $12 $14 $16 Mi l l i o n s Other Financing Sources Budget Actual Last Year Page 22 of 38 City of Renton Monthly Revenue Analysis ‐ 2016 Budget Year Bldg Permits  & Devlpmt Svc  Fees Budget YTD Actual Annual %  over (under) Jan 391,612           661,363           68.88% Feb 810,299           1,074,783        32.64% Mar 1,173,926        1,658,442        41.27% Apr 1,734,626        1,994,550        14.98% May 2,070,144        2,370,874        14.53% Jun 2,889,810        2,808,493         ‐2.81% Jul 3,565,158        3,270,705         ‐8.26% Aug 4,001,315        3,668,283         ‐8.32% Sep 4,553,471        4,048,763         ‐11.08% Oct 5,042,908        4,527,811         ‐10.21% Nov 5,416,319        4,825,260         ‐10.91% Dec 5,923,368        5,293,563         ‐10.63% Percent of budget 89.37% B & O Tax Budget YTD Actual Annual %  over (under) Jan ‐                          ‐                         N/A Feb ‐                          ‐                         N/A Mar ‐                          ‐                         N/A Apr 4,500,000        4,578,349        1.74% May 4,500,000        4,882,381        8.50% Jun 4,500,000        4,912,972        9.18% Jul 4,750,000        5,289,180        11.35% Aug 4,750,000        5,623,988        18.40% Sep 4,750,000        5,634,767        18.63% Oct 5,000,000        6,238,389        24.77% Nov 5,000,000        6,375,322        27.51% Dec 5,000,000        6,375,322        27.51% Percent of budget 127.51%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00  $7.00 Millions Building Permits and Development Service  Fees Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50  $4.00  $4.50  $5.00  $5.50  $6.00  $6.50  $7.00 Millions Business & Occupation Tax Budget Actual Last Year Page 23 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year General  Government Budget YTD Actual Annual %  over (under) Jan 9,214,133        8,625,290         ‐6.39% Feb 18,781,417      18,026,295       ‐4.02% Mar 28,280,383      27,039,048       ‐4.39% Apr 37,569,468      35,281,644       ‐6.09% May 52,337,959      44,251,964       ‐15.45% Jun 62,008,716      53,224,181       ‐14.17% Jul 74,082,941      67,206,203       ‐9.28% Aug 84,141,226      74,281,749       ‐11.72% Sep 93,881,885      81,242,284       ‐13.46% Oct 103,558,810    94,419,834       ‐8.82% Nov 112,940,469    100,928,993     ‐10.64% Dec 128,753,260    119,215,504     ‐7.41% Percent of budget expended 92.59% Legislative Budget YTD Actual Annual %  over (under) Jan 33,153              34,732              4.76% Feb 67,972              64,182               ‐5.58% Mar 102,703           99,419              ‐3.20% Apr 132,696           129,027           ‐2.77% May 163,648           156,960           ‐4.09% Jun 194,452           186,176           ‐4.26% Jul 224,495           214,274           ‐4.55% Aug 254,415           242,571           ‐4.66% Sep 284,228           271,193           ‐4.59% Oct 314,294           300,668           ‐4.34% Nov 344,069           329,610           ‐4.20% Dec 375,761           358,550           ‐4.58% Percent of budget expended 95.42%  $‐  $20  $40  $60  $80  $100  $120  $140 Millions Total Expenditures General Government Budget Actual Last Year  $‐  $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  $350,000  $400,000 Legislative Budget Actual Last Year Page 24 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Executive Budget YTD Actual Annual %  over (under) Jan 92,301              192,359           108.40% Feb 227,599           322,242           41.58% Mar 363,001           486,643           34.06% Apr 501,457           616,267           22.90% May 639,149           744,988           16.56% Jun 775,317           890,444           14.85% Jul 916,869           1,019,792        11.23% Aug 1,146,554        1,165,850        1.68% Sep 1,302,813        1,333,539        2.36% Oct 1,437,782        1,463,344        1.78% Nov 1,585,169        1,593,538        0.53% Dec 1,784,464        1,778,206         ‐0.35% Percent of budget expended 99.65% City Attorney Budget YTD Actual Annual %  over (under) Jan 175,034           157,485            ‐10.03% Feb 349,257           326,649            ‐6.47% Mar 527,350           498,957           ‐5.38% Apr 710,479           670,522           ‐5.62% May 896,957           837,538           ‐6.62% Jun 1,092,924        1,004,061        ‐8.13% Jul 1,282,507        1,173,342        ‐8.51% Aug 1,475,680        1,341,723        ‐9.08% Sep 1,671,064        1,512,690        ‐9.48% Oct 1,846,482        1,676,659        ‐9.20% Nov 2,021,528        1,841,277        ‐8.92% Dec 2,213,353        1,983,834        ‐10.37% Percent of budget expended 89.63%  $‐  $0.30  $0.60  $0.90  $1.20  $1.50  $1.80 Millions Executive Budget Actual Last Year  $‐  $0.40  $0.80  $1.20  $1.60  $2.00  $2.40 Millions City Attorney Budget Actual Last Year Page 25 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Court Services Budget YTD Actual Annual %  over (under) Jan 169,086           163,432            ‐3.34% Feb 345,603           335,163            ‐3.02% Mar 524,116           508,523            ‐2.98% Apr 706,499           678,807            ‐3.92% May 890,985           849,557            ‐4.65% Jun 1,081,645        1,021,277         ‐5.58% Jul 1,265,010        1,191,366         ‐5.82% Aug 1,449,036        1,363,339         ‐5.91% Sep 1,627,840        1,546,812         ‐4.98% Oct 1,805,361        1,718,898         ‐4.79% Nov 1,978,143        1,890,069         ‐4.45% Dec 2,187,710        2,075,763         ‐5.12% Percent of budget expended 94.88% CED Admin Budget YTD Actual Annual %  over (under) Jan 91,797              95,028              3.52% Feb 183,819           190,655           3.72% Mar 275,840           286,282           3.79% Apr 370,361           382,305           3.22% May 465,873           478,727           2.76% Jun 560,943           575,150           2.53% Jul 707,388           671,572           ‐5.06% Aug 800,410           767,998           ‐4.05% Sep 893,724           864,286           ‐3.29% Oct 986,812           960,176           ‐2.70% Nov 1,079,454        1,055,753        ‐2.20% Dec 1,173,302        1,161,330        ‐1.02% Percent of budget expended 98.98%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  $2.00  $2.20 Millions Court Services Budget Actual Last Year  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20 Millions Community & Economic Development Admin Budget Actual Last Year Page 26 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Development  Services Budget YTD Actual Annual %  over (under) Jan 252,761           212,162            ‐16.06% Feb 522,698           448,710            ‐14.15% Mar 808,078           676,129            ‐16.33% Apr 1,087,558        892,326            ‐17.95% May 1,359,560        1,125,595         ‐17.21% Jun 1,621,254        1,370,849         ‐15.45% Jul 1,878,419        1,606,944         ‐14.45% Aug 2,151,809        1,850,577         ‐14.00% Sep 2,394,704        2,121,707         ‐11.40% Oct 2,650,101        2,365,335         ‐10.75% Nov 2,908,204        2,601,675         ‐10.54% Dec 3,197,543        2,859,410         ‐10.57% Percent of budget expended 89.43% Economic  Development Budget YTD Actual Annual %  over (under) Jan 109,993           50,235               ‐54.33% Feb 280,926           108,276           ‐61.46% Mar 425,794           166,805           ‐60.83% Apr 573,079           287,672           ‐49.80% May 703,119           361,504           ‐48.59% Jun 847,847           461,549           ‐45.56% Jul 1,007,562        563,033           ‐44.12% Aug 1,169,249        620,177           ‐46.96% Sep 1,318,699        676,493           ‐48.70% Oct 1,458,945        830,695           ‐43.06% Nov 1,611,514        930,197           ‐42.28% Dec 1,814,358        1,004,411        ‐44.64% Percent of budget expended 55.36%  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50 Millions Development Services Budget Actual Last Year  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60  $1.80  $2.00 Millions Economic Development Budget Actual Last Year Page 27 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Planning Budget YTD Actual Annual %  over (under) Jan 205,964           203,948            ‐0.98% Feb 423,854           411,848            ‐2.83% Mar 667,832           630,155            ‐5.64% Apr 905,102           846,345            ‐6.49% May 1,174,453        1,085,749         ‐7.55% Jun 1,438,180        1,327,179         ‐7.72% Jul 1,692,813        1,553,419         ‐8.23% Aug 1,944,561        1,797,371         ‐7.57% Sep 2,209,302        2,047,141         ‐7.34% Oct 2,492,024        2,274,192         ‐8.74% Nov 2,739,947        2,483,516         ‐9.36% Dec 3,009,484        2,716,214         ‐9.74% Percent of budget expended 90.26% Finance Budget YTD Actual Annual %  over (under) Jan 173,283           220,501           27.25% Feb 354,661           434,053           22.39% Mar 539,049           642,161           19.13% Apr 722,578           858,782           18.85% May 915,137           1,085,634        18.63% Jun 1,234,541        1,337,642        8.35% Jul 1,436,914        1,550,596        7.91% Aug 1,771,682        1,825,174        3.02% Sep 1,981,691        2,042,155        3.05% Oct 2,189,209        2,246,608        2.62% Nov 2,384,113        2,449,791        2.75% Dec 3,003,369        3,046,824        1.45% Percent of budget expended 101.45%  $‐  $0.40  $0.80  $1.20  $1.60  $2.00  $2.40  $2.80  $3.20  $3.60 Millions Finance Budget Actual Last Year  $‐  $0.50  $1.00  $1.50  $2.00  $2.50  $3.00  $3.50 Millions Planning Budget Actual Last Year Page 28 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year City Clerk Budget YTD Actual Annual %  over (under) Jan 62,637              67,195              7.28% Feb 164,231           168,845           2.81% Mar 303,940           242,432            ‐20.24% Apr 375,900           313,676            ‐16.55% May 450,924           384,293            ‐14.78% Jun 522,077           460,231            ‐11.85% Jul 593,286           541,066            ‐8.80% Aug 671,377           726,986           8.28% Sep 741,134           684,984            ‐7.58% Oct 834,041           758,024            ‐9.11% Nov 907,039           833,087            ‐8.15% Dec 1,151,870        914,251            ‐20.63% Percent of budget expended 79.37% Includes Hearing Examiner Human  Resources Budget YTD Actual Annual %  over (under) Jan 84,669              89,683              5.92% Feb 187,462           185,388           ‐1.11% Mar 299,503           299,054           ‐0.15% Apr 431,140           395,008           ‐8.38% May 540,016           491,217           ‐9.04% Jun 651,578           584,313           ‐10.32% Jul 766,621           675,537           ‐11.88% Aug 881,492           786,540           ‐10.77% Sep 993,608           883,392           ‐11.09% Oct 1,112,638        987,507           ‐11.25% Nov 1,219,645        1,083,398        ‐11.17% Dec 1,372,669        1,193,016        ‐13.09% Percent of budget expended 86.91%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40  $1.60 Millions Human Resources Budget Actual Last Year  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20 Millions City Clerk Budget Actual Last Year Page 29 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Police Budget YTD Actual Annual %  over (under) Jan 3,038,658        2,819,381         ‐7.22% Feb 5,743,148        5,349,745         ‐6.85% Mar 8,884,907        8,330,684         ‐6.24% Apr 11,581,048      10,868,880       ‐6.15% May 14,626,128      13,787,797       ‐5.73% Jun 17,512,867      16,379,009       ‐6.47% Jul 20,642,771      19,298,967       ‐6.51% Aug 23,378,365      21,856,456       ‐6.51% Sep 26,486,934      24,828,222       ‐6.26% Oct 29,275,861      27,488,728       ‐6.10% Nov 32,412,273      30,476,426       ‐5.97% Dec 35,679,827      33,596,857       ‐5.84% Percent of budget expended 94.16% Fire &  Emergency  Services Budget YTD Actual Annual %  over (under) Jan 2,586,605        2,291,374         ‐11.41% Feb 5,519,597        5,299,522        ‐3.99% Mar 7,802,990        7,516,586        ‐3.67% Apr 10,031,789      9,575,877        ‐4.54% May 12,264,252      11,745,775      ‐4.23% Jun 14,548,416      12,826,352      ‐11.84% Jul 16,881,163      19,651,039      16.41% Aug 19,396,900      19,707,735      1.60% Sep 21,746,924      19,738,507      ‐9.24% Oct 23,995,067      25,667,731      6.97% Nov 26,343,170      25,695,684      ‐2.46% Dec 28,932,928      25,720,587      ‐11.10% Percent of budget expended 88.90%  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33  $36 Millions Police Budget Actual Last Year  $‐  $3  $6  $9  $12  $15  $18  $21  $24  $27  $30  $33 Millions Fire & Emergency Services Budget Actual Last Year Page 30 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Community  Services Admin Budget YTD Actual Annual %  over (under) Jan 51,383              52,449              2.07% Feb 106,296           113,335           6.62% Mar 166,634           155,142            ‐6.90% Apr 220,283           196,697            ‐10.71% May 269,995           240,955            ‐10.76% Jun 318,337           282,185            ‐11.36% Jul 373,106           325,143            ‐12.86% Aug 427,414           366,838            ‐14.17% Sep 481,448           409,466            ‐14.95% Oct 534,041           452,338            ‐15.30% Nov 589,514           493,412            ‐16.30% Dec 655,344           585,983            ‐10.58% Percent of budget expended 89.42% Parks Budget YTD Actual Annual %  over (under) Jan 336,143           302,959            ‐9.87% Feb 700,947           615,902           ‐12.13% Mar 1,083,549        949,380           ‐12.38% Apr 1,459,798        1,301,241        ‐10.86% May 1,864,820        1,638,087        ‐12.16% Jun 2,298,738        2,027,520        ‐11.80% Jul 2,803,971        2,449,585        ‐12.64% Aug 3,298,106        2,895,238        ‐12.22% Sep 3,795,912        3,344,418        ‐11.89% Oct 4,241,176        3,734,313        ‐11.95% Nov 4,633,809        4,069,957        ‐12.17% Dec 5,065,610        4,445,115        ‐12.25% Percent of budget expended 87.75%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00 Millions Parks Budget Actual Last Year $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 Community Services Admin Budget Actual Last Year Page 31 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Parks Planning  and Natural  Resources Budget YTD Actual Annual %  over (under) Jan 75,967              46,446               ‐38.86% Feb 155,277           103,226            ‐33.52% Mar 253,324           165,213            ‐34.78% Apr 346,004           211,159            ‐38.97% May 467,457           300,170            ‐35.79% Jun 559,036           394,070            ‐29.51% Jul 680,904           460,928            ‐32.31% Aug 791,212           556,494            ‐29.67% Sep 915,691           654,600            ‐28.51% Oct 1,046,163        732,271            ‐30.00% Nov 1,169,288        816,259            ‐30.19% Dec 1,292,543        952,980            ‐26.27% Percent of budget expended 73.73% Recreation Budget YTD Actual Annual %  over (under) Jan 333,154           330,010           ‐0.94% Feb 695,736           697,557           0.26% Mar 1,066,633        1,078,551        1.12% Apr 1,449,320        1,463,787        1.00% May 1,833,378        1,843,391        0.55% Jun 2,256,569        2,255,376        ‐0.05% Jul 2,918,647        2,839,821        ‐2.70% Aug 3,604,160        3,456,776        ‐4.09% Sep 4,146,992        3,962,318        ‐4.45% Oct 4,519,771        4,344,481        ‐3.88% Nov 4,905,664        4,717,419        ‐3.84% Dec 5,350,288        5,096,236        ‐4.75% Percent of budget expended 95.25%  $‐  $200,000  $400,000  $600,000  $800,000  $1,000,000  $1,200,000  $1,400,000 Parks Planning and Natural Resources Budget Actual Last Year $0.00 $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 $4.00 $4.50 $5.00 $5.50 Millions Recreation Budget Actual Last Year Page 32 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Human  Services Budget YTD Actual Annual %  over (under) Jan 49,704              81,352              63.67% Feb 126,583           213,832           68.93% Mar 265,121           269,088           1.50% Apr 420,684           395,807            ‐5.91% May 488,600           476,551            ‐2.47% Jun 555,758           528,283            ‐4.94% Jul 696,590           613,350            ‐11.95% Aug 789,750           732,476            ‐7.25% Sep 851,504           796,475            ‐6.46% Oct 1,010,457        958,095            ‐5.18% Nov 1,071,598        1,058,333         ‐1.24% Dec 1,260,461        1,241,169         ‐1.53% Percent of budget expended 98.47% Neighborhoods , Resources,  and Events Budget YTD Actual Annual %  over (under) Jan 69,130              66,354              ‐4.02% Feb 168,671           144,459           ‐14.35% Mar 240,947           213,473           ‐11.40% Apr 311,156           268,788           ‐13.62% May 382,303           335,059           ‐12.36% Jun 467,795           392,885           ‐16.01% Jul 600,295           482,399           ‐19.64% Aug 701,207           557,046           ‐20.56% Sep 796,809           616,242           ‐22.66% Oct 879,768           692,390           ‐21.30% Nov 965,394           753,518           ‐21.95% Dec 1,109,048        865,551           ‐21.96% Percent of budget expended 78.04%  $‐  $0.20  $0.40  $0.60  $0.80  $1.00  $1.20  $1.40 Millions Human Services Budget Actual Last Year  $‐  $200,000  $400,000  $600,000  $800,000  $1,000,000  $1,200,000 Neighborhoods, Resources, and Events Budget Actual Last Year Page 33 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Museum Fund Budget YTD Actual Annual %  over (under) Jan 18,883              19,061              0.94% Feb 37,795              37,570               ‐0.59% Mar 56,682              55,330               ‐2.39% Apr 75,818              73,438               ‐3.14% May 95,501              92,699               ‐2.93% Jun 115,297           112,304            ‐2.60% Jul 135,152           131,860            ‐2.44% Aug 155,440           151,132            ‐2.77% Sep 175,323           170,790            ‐2.59% Oct 195,438           190,760            ‐2.39% Nov 215,317           210,229            ‐2.36% Dec 235,281           229,543            ‐2.44% Percent of budget expended 97.56% Public Works  Admin Budget YTD Actual Annual %  over (under) Jan 33,648              33,119               ‐1.57% Feb 68,336              67,230              ‐1.62% Mar 102,357           100,509           ‐1.81% Apr 136,585           133,872           ‐1.99% May 171,018           167,151           ‐2.26% Jun 205,573           200,630           ‐2.40% Jul 240,151           234,053           ‐2.54% Aug 275,209           267,579           ‐2.77% Sep 310,708           300,887           ‐3.16% Oct 344,670           333,632           ‐3.20% Nov 378,434           366,364           ‐3.19% Dec 413,579           398,796           ‐3.57% Percent of budget expended 96.43%  $‐  $50,000  $100,000  $150,000  $200,000  $250,000  $300,000  $350,000  $400,000  $450,000 Public Works Admin Budget Actual Last Year  $‐  $30,000  $60,000  $90,000  $120,000  $150,000  $180,000  $210,000  $240,000  $270,000 Museum Fund Budget Actual Last Year Page 34 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Street  Maintenance Budget YTD Actual Annual %  over (under) Jan 395,932           400,277           1.10% Feb 817,377           805,426            ‐1.46% Mar 1,243,762        1,236,414         ‐0.59% Apr 1,720,451        1,676,774         ‐2.54% May 2,164,177        2,087,428         ‐3.55% Jun 2,612,305        2,494,337         ‐4.52% Jul 3,090,003        2,917,165         ‐5.59% Aug 3,565,717        3,327,137         ‐6.69% Sep 4,014,860        3,762,097         ‐6.30% Oct 4,501,814        4,195,645         ‐6.80% Nov 4,933,704        4,605,606         ‐6.65% Dec 5,420,445        5,041,509         ‐6.99% Percent of budget expended 93.01% Transportation Budget YTD Actual Annual %  over (under) Jan 385,313           356,191            ‐7.56% Feb 848,593           720,619            ‐15.08% Mar 1,402,988        1,219,946        ‐13.05% Apr 1,985,654        1,593,069        ‐19.77% May 2,460,643        2,119,001        ‐13.88% Jun 2,936,948        2,537,694        ‐13.59% Jul 3,428,357        2,988,891        ‐12.82% Aug 3,947,043        3,412,556        ‐13.54% Sep 4,422,467        3,871,910        ‐12.45% Oct 4,952,795        5,049,376        1.95% Nov 5,426,873        5,370,311        ‐1.04% Dec 6,149,047        5,966,281        ‐2.97% Percent of budget expended 97.03%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00 Millions Street Maintenance Budget Actual Last Year $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 Millions Transportation Budget Actual Last Year Page 35 of 38 City of Renton Monthly Expenditure Analysis ‐ 2016 Budget Year Debt Service Budget YTD Actual Annual %  over (under) Jan 21,884              44,758              104.53% Feb 132,035           295,075           123.48% Mar 132,149           295,075           123.29% Apr 270,479           295,075           9.09% May 3,273,499        295,075            ‐90.99% Jun 3,582,315        936,921            ‐73.85% Jul 3,696,424        1,191,679         ‐67.76% Aug 3,806,357        1,441,996         ‐62.12% Sep 3,806,357        1,448,946         ‐61.93% Oct 4,193,693        1,448,946         ‐65.45% Nov 4,193,693        1,448,946         ‐65.45% Dec 6,248,676        6,099,166         ‐2.39% Percent of budget expended 97.61% Non‐ Departmental  Other City Budget YTD Actual Annual %  over (under) Jan 367,050           294,800           ‐19.68% Feb 552,943           566,783           2.50% Mar 741,132           917,099           23.74% Apr 1,043,549        1,156,445        10.82% May 3,776,369        1,521,060        ‐59.72% Jun 4,018,006        2,637,745        ‐34.35% Jul 6,123,523        2,860,383        ‐53.29% Aug 6,288,083        3,063,984        ‐51.27% Sep 6,511,150        3,353,015        ‐48.50% Oct 6,740,407        3,549,024        ‐47.35% Nov 6,922,915        3,754,617        ‐45.77% Dec 9,656,299        9,883,923        2.36% Percent of budget expended 102.36%  $‐  $1.00  $2.00  $3.00  $4.00  $5.00  $6.00  $7.00  $8.00  $9.00  $10.00 Millions Non‐Departmental Other City Services Budget Actual Last Year  $‐  $5  $10  $15  $20  $25 Millions Debt Service Budget Actual Last Year Page 36 of 38 City of Renton Monthly Enterprise Fund Financial Report ‐ 2016 Budget Year Utilities Budget Revenue Expense Jan 6,781,155        6,349,407      3,113,758       Feb 17,519,892      12,660,071    7,764,200       Mar 25,993,243      18,599,026    12,419,394     Apr 32,387,042      24,660,335    17,069,879     May 43,091,617      30,851,439    21,831,008     Jun 56,464,388      37,253,721    28,479,554     Jul 64,630,745      44,115,062    34,016,925     Aug 73,514,267      51,070,788    45,010,257     Sep 82,654,355      57,773,544    54,401,676     Oct 91,094,635      73,724,460    69,154,653     Nov 99,683,168      81,526,328    74,446,207     Dec 116,000,197    94,453,804    84,565,882     Percent of budget expended 55.80% Note:  Operations and Capital Airport Budget Revenue Expense Jan 255,279           379,338          102,054           Feb 700,194           746,998          246,569           Mar 3,810,882        1,127,792      409,998           Apr 4,815,409        1,367,786      567,432           May 7,160,545        1,614,567      695,455           Jun 7,921,949        1,834,885      845,678           Jul 8,808,490        2,081,888      997,029           Aug 9,978,912        2,302,425      1,140,620       Sep 10,969,853      2,536,402      1,335,868       Oct 11,716,670      3,039,128      1,545,361       Nov 12,983,484      3,255,910      1,664,584       Dec 14,301,353      3,483,897      2,009,303       Percent of budget expended 14.05% Note:  Operations and Capital $0 $10 $20 $30 $40 $50 $60 $70 $80 $90 $100 $110 $120 $130 Millions Utilities Budget Revenue Expense  $‐  $2.00  $4.00  $6.00  $8.00  $10.00  $12.00  $14.00  $16.00 Millions Airport Budget Revenue Expense Page 37 of 38 City of Renton Monthly Enterprise Fund Financial Report ‐ 2016 Budget Year Golf Course Budget Revenue Expense Jan 116,391           72,468            118,352           Feb 266,941           183,666          290,598           Mar 417,955           302,635          438,062           Apr 589,411           534,799          625,491           May 810,690           828,065          790,152           Jun 967,871           1,133,239      974,444           Jul 1,135,836        1,437,189      1,243,694       Aug 1,308,140        1,760,424      1,419,407       Sep 1,481,465        1,981,564      1,606,801       Oct 1,678,887        2,118,653      1,785,208       Nov 1,805,131        2,197,137      1,945,666       Dec 2,295,432        2,249,054      2,101,910       Percent of budget expended 91.57% Note:  Operations and Capital  $‐  $0.30  $0.60  $0.90  $1.20  $1.50  $1.80  $2.10  $2.40 Millions Golf Course Budget Revenue Expense Page 38 of 38