Loading...
HomeMy WebLinkAbout5G 2016 3rd Quarter Financial Report 4646 Dakota Street SE Prior Lake, MN 55372 CITY COUNCIL AGENDA REPORT MEETING DATE: NOVEMBER 28, 2016 AGENDA #: 5G PREPARED BY: DON URAM, FINANCE DIRECTOR PRESENTER: DON URAM AGENDA ITEM: CONSIDER APPROVAL OF THE PRELIMINARY 3rd QUARTER 2016 FINANCIAL REPORTS DISCUSSION: Introduction Staff has prepared preliminary summary financial reports (attached) as of September 30, 2016 for the following funds:  General Fund  Debt Service Funds  Capital Park Fund  Revolving Equipment Fund  Facilities Management Fund  Water Fund  Sewer Fund  Water Quality Fund  Economic Development Authority Special Revenue Fund The reports reflect revenue and expenditure activity during the first three quarters of 2016. The reports are preliminary, unaudited and may change. The attached memorandum provides a summary of the significant issues. As requested by the City Council, comparative information has been included for the same period of the prior year. If council members have questions please feel free to contact me at 952- 447-9841 for more information. ALTERNATIVES: 1. A motion to accept the September 30, 2016 Financial Report as submitted. 2. Take no action and provide the staff with specific direction. RECOMMENDED MOTION: Alternative 1. Page 2 MEMORANDUM DATE: November 28, 2016 TO: Prior Lake City Council FROM: Don Uram, Finance Director RE: Financial Report dated 9/30/2016 The financial reports presented as part of this agenda item reflect activity during the first three quarters of 2016. The significant issues identified at this time are summarized below. General Fund Summary Key points for third quarter 2016:  Preliminary financial information reflects expenditures slightly exceeding revenues by $42k.  First half property taxes were collected in June and are comparable to the prior year.  The 2016 budget has been amended to use reserves of $233,000 for projects carried forward from 2015.  Intergovernmental revenue is higher than the same period 2015.  Building permits continue to be higher in comparison to 2nd quarter 2015.  Expenditures are higher than the same period 2015. General Fund Revenues Property taxes are received in June, December and January. Revenue from taxes are recognized on a cash basis for the General Fund. First half property taxes have been collected and are comparable to the prior year. Single family building permits were budgeted at 100 for 2016. Revenues associated with building permits and plan check fees are approximately $160k higher than 3nd quarter 2015. The following table provides a breakdown of the third quarter activity by year. Year Single Family Townhomes Commercial / Industrial Other Permits Total Change from PY 2016 82 4 14 1460 1560 (6%) 2015 86 10 35 1527 1658 10% 2014 83 4 29 1386 1502 (14%) 2013 108 35 30 1569 1742 The average value associated with the single-family permits is $344k which has increased $26K from the average for 2015. The first half payments were received in first quarter for Municipal State Aid and the township fire agreements. Intergovernmental revenue is higher due to the timing of the receipts of the State Police and Fire aid. First quarter Franchise fees and PEG fees collected in April and May are included in this report. Second quarter fees are recorded in July and August. Fees collected are slightly less compared to last year at this time. Project engineering fees are less than budget. This is due to fewer projects being done in 2016 than were budgeted. Staff has historically used a percentage of construction costs for estimating engineering time. In recent years, engineering staff has used Cartegraph to track their time on projects. The amount being charged is currently only 50% of the budget. Page 3 Recreation revenues (including Park admission fees and facility rental) are slightly higher than 3rd quarter 2015. Softball fees have decreased significantly due to fewer participants but Program fees and Facility/Shelter Rental fees have increased compared to this time last year. Interest earnings are at 56% of the budget. Interest rates on investments are continuing to decrease which is lowering the rate of return we earn. The report also reflects a $50k increase in the fair value of the securities. As rates decreased, the market value of the existing securities have increased. This is a paper gain; no actual gain is realized because the City holds the securities until maturity. General Fund Expenditures General Fund expenditures for 2016 represent 62% of the $13,008,738 amended budget. The level of expenditures (as a percent of budget) is higher compared to the same period in 2015. Some key points related to expenditures for 3rd quarter 2016 are listed.  Expenditures in administration, finance and human resources is higher than 2015 due mainly to being fully staffed in 2016.  Police remains higher than 2015, but within budget at 73%. This is primarily due to being fully staffed in 2016.  Central garage is slightly higher than 2015 due to an increase in major repairs to the City’s fleet vehicles. The 2017 budget has been increased to reflect this trend.  Recreation is higher than 2015 due to the reinstatement of several program offerings that had been cut for summer 2015. At this point in the year, there are no other significant variances to report. Staff will continue to monitor as we approach year end. Debt Service Funds Property taxes and special assessments are received in June, December and January (final tax settlement). Prepayments have been received for special assessments. Scheduled bond payments were made on the 1st and 15th of June. One bond payment was made to Scott County in April 2016. Other bond payments will be due on the 1st and 15th of December. Capital Park Fund Park Dedication Fees were received for the Dominium Gateway Shopping Center and Chatonka Heights projects in March and August. Expenditures for the Markley Lake Trail which was approved in November 2015 are included in 2016 which explain the variance from 2015. The Pike Lake Master Plan was not completed in 2015 and has been carried over. A collaborator group which is comprised of YMCA, SMSC, Three Rivers Parks District, PLSL Watershed and City staff was established for the Pike Lake Park Master Plan. The group is in the early stages of developing an RFP for designing the Plan although this project has been delayed until 2017 due to more pressing priorities. The group will also explore grant opportunities for funding the improvements. Revolving Equipment Fund Property taxes, the primary funding source, were received in June. Bond proceeds were received in May. Interest earnings are at 57% of the budget. The change in the fair value of the securities is adjusted against interest earnings and is allocated to each fund based on cash balances. Approved police vehicle, public works equipment, and parks equipment purchases took place in first quarter 2016. Vehicle and equipment purchases were approved at council meetings earlier in the year. Total expenditures for 2016 equal $588,853. Page 4 Facilities Management Fund The 2016 Budget included the issuance of debt totaling about $620,000 for the replacement of the Maintenance Center roof. This project has been deferred until 2017 due to a delay in the review and selection of the appropriate roofing material. Estimated cost is $620,000. In 2014, the Council approved a contract with Honeywell as part of the Guaranteed Energy Savings Program (GESP) to complete improvements to many of our facilities. The Council also approved a lease agreement with US Bank for $2,667,924 to fund these improvements. As of third quarter 2016, there are certain punch list items remaining on the project and it will be complete before year end. Water Fund The financial report for the Water Fund reflects four billing cycles. Consumption is higher compared to 2015 due to a dryer summer. Water revenues are higher than 2015 due to an increase in rates effective 3/1/16 and to the increased consumption in the 3rd quarter. Operating expenditures are comparable and transfers much higher than 2015. 2016 year to date includes a final project related transfer to fund the Welcome Ave Project. In 2016, operational budgetary transfers have been made according to the approved budget. Sewer Fund The financial report for the Sewer Fund reflects four billing cycles. Consumption is steady compared to prior year. Sewer revenues are at 64% of the budget and higher compared to 2015. The increase in revenue is due to the rate increase that was effective 3/1/16. The estimated level of discharge is reevaluated annually in conjunction with the preparation of the Capital Improvement Program. Operating expenditures for 2016 are at 58% of the approved budget and slightly lower than 2015. Operational budgetary transfers for first, second, and third quarters are reflected in the report. It also includes a final project related transfer to fund the Manitou Road Project. The prior year included transfers for capital projects that took place in 2015. Water Quality Fund The financial report for the Water Quality Fund reflects four billing cycles. Water Quality revenues are based on flat rates per billing cycle. Revenues are steady compared to 2015 at 70% of the budget. Operational expenditures are lower than 2015. Operational budgetary transfers for first, second, and third quarters are reflected in the report. It also includes a final project related transfer to fund the Manitou Road Project. The prior year included transfers for capital projects that took place in 2015. Capital expenditures will be less than budget due to the deferral of projects including Rolling Oakes and Cates Creek. Economic Development Authority Special Revenue Fund Property taxes are received in June, December and January (final tax settlement). Facility rental payments have been received for the Technology Village Business Incubator. Personnel, commissioner per diems, professional services and Technology Village Business Incubator expenditures comprise most of the expenditures and are at 64% of budget as of the third second quarter end. If you have any questions regarding these financial reports, please contact me at 952.447.9841. C i t y o f P r i o r L a k e G e n e r a l F u n d S u m m a r y A s o f 9 / 3 0 / 2 0 1 6 ( P r e l i m i n a r y & U n a u d i t e d ) Va r i a n c e  fr o m V a r i a n c e 20 1 6 2 0 1 6 2 0 1 6 A m e n d e d  Bu d g e t  ‐   % BD G T A c t u a l f r o m  2015 Bu d g e t A m e n d e d A c t u a l P o s i t i v e  (N e g a t i v e ) U S E D 9/30/2015 Positive  (Negative) Re v e n u e s Ta x e s 8 , 2 5 7 , 5 1 2          8, 2 5 7 , 5 1 2          4, 2 6 6 , 4 9 0    (3 , 9 9 1 , 0 2 2 )                                    52 % 4 , 1 8 7 , 6 0 2    78,888                           Li c e n s e s  an d  Pe r m i t s 6 3 0 , 4 9 5                63 0 , 4 9 5                59 6 , 8 8 4            (3 3 , 6 1 1 )                                                95 % 4 7 2 , 5 2 0            124,364                         In t e r g o v e r n m e n t a l 1 , 5 3 5 , 2 3 5          1, 5 3 5 , 2 3 5          1, 3 6 2 , 2 5 6    (1 7 2 , 9 7 9 )                                            89 % 9 2 7 , 7 0 5            434,551                         Ch a r g e s  fo r  Se r v i c e s 1 , 7 1 4 , 3 0 6          1, 7 1 4 , 3 0 6          1, 2 2 3 , 8 4 7    (4 9 0 , 4 5 9 )                                            71 % 1 , 1 7 3 , 0 4 0    50,807                           Fi n e s  an d  Fo r f e i t u r e s ‐                                  ‐                                  4, 7 4 3                    4, 7 4 3                                                        n/ a 1 , 3 5 0                    3,393                              In t e r e s t  (l o s s e s )  on  in v e s t m e n t s 1 2 0 , 0 0 0                12 0 , 0 0 0                67 , 2 5 1                (5 2 , 7 5 0 )                                                56 % 1 2 2 , 8 1 2            (55,561)                         Ot h e r 1 5 5 , 5 5 0                15 5 , 5 5 0                21 6 , 5 2 4            60 , 9 7 4                                                  13 9 % 1 4 8 , 8 7 4            67,651                           Tr a n s f e r s  in 5 3 2 , 6 4 0                36 2 , 6 4 0                27 1 , 9 8 0            (9 0 , 6 6 0 )                                                75 % 2 6 6 , 6 4 0            5,340                              To t a l  Re v e n u e s 12 , 9 4 5 , 7 3 8    12 , 7 7 5 , 7 3 8    8, 0 0 9 , 9 7 4    (4 , 7 6 5 , 7 6 4 )                                    63 % 7 , 3 0 0 , 5 4 3    709,432                         Ex p e n d i t u r e s Ge n e r a l  Go v e r n m e n t 2 , 7 4 4 , 8 4 9          2, 7 4 4 , 8 4 9          1, 9 3 8 , 9 3 4    80 5 , 9 1 4                                              71 % 1 , 8 3 0 , 4 8 3    (108,451)                       Pu b l i c  Sa f e t y 5 , 0 7 6 , 4 3 7          5, 0 8 8 , 4 3 7          3, 4 7 4 , 6 4 1    1, 6 1 3 , 7 9 6                                        68 % 3 , 1 4 8 , 1 4 7    (326,494)                       Pu b l i c  Wo r k s 2 , 1 5 3 , 3 8 7          2, 1 7 4 , 3 8 7          1, 2 7 4 , 0 7 8    90 0 , 3 0 9                                              59 % 1 , 2 4 4 , 1 8 2    (29,896)                         Cu l t u r e  an d  Re c r e a t i o n 1 , 8 8 6 , 3 4 6          1, 9 1 6 , 3 4 6          1, 2 7 9 , 6 6 5    63 6 , 6 8 1                                              67 % 1 , 2 6 0 , 5 5 0    (19,116)                         Tr a n s f e r  to  ot h e r  fu n d s 1 , 0 8 4 , 7 1 9          1, 0 8 4 , 7 1 9          84 , 6 8 4                1, 0 0 0 , 0 3 5                                        8% 1 0 2 , 7 4 6            18,063                           Co n t i n g e n t  Re s e r v e ‐                                  ‐                                  ‐                            ‐                                                                n/ a 6 , 2 1 3                    6,213                              To t a l  Ex p e n d i t u r e s 12 , 9 4 5 , 7 3 8    13 , 0 0 8 , 7 3 8    8, 0 5 2 , 0 0 2    4, 9 5 6 , 7 3 6                                        62 % 7 , 5 9 2 , 3 2 0    (459,682)                       Ne t  Ch a n g e 0                                        (2 3 3 , 0 0 0 )              (4 2 , 0 2 7 )              (291,777)        City of Prior Lake General Fund Revenues As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive ( Negative) USED 9/30/2015 Positive (Negative) Taxes 101 31010.00 Current Property Taxes  ‐ General Purpos 7,482,395.00 7,482,395.00 3,812,227.53 (3,670,167)                       51% 3,772,674   39,553                              101 31020.00 Delinquent Property Taxes ‐ General Purp 0.00 0.00 37,776.45 37,776                              n/a 45,881        (8,104)                               101 31040.00 Fiscal Disparities 775,117.00 775,117.00 416,485.91 (358,631)                           54% 369,047      47,439                              101 33423.00 Market Value Credit Aid 0.00 0.00 ‐                                     n/a ‐                ‐                                     Taxes 8,257,512.00 8,257,512.00 4,266,489.89   (3,991,022)                       52% 4,187,602   78,888                              Licenses and Permits 101 32100.00 Business Licenses 1,100               1,100               900.00 (200)                                   82% 1,000           (100)                                   101 32110.00 Liquor Licenses 69,990            69,990            70,465.00 475                                    101% 68,995        1,470                                 101 32160.00 Refuse Haulers 3,650               3,650               3,450.00 (200)                                   95% 3,650           (200)                                   101 32170.00 Outdoor Concert Permits 1,150               1,150               3,100.00 1,950                                 270% 1,450           1,650                                 101 32180.00 Cigarette Licenses 2,250               2,250               2,500.00 250                                    111% 2,500            ‐                                     101 32210.00 Building Permits 471,800          471,800          410,593            (61,207)                             87% 304,558      106,036                            101 32211.00 Retainage Forfeiture ‐                    ‐                   6,332                 6,332                                 n/a 5,583           749                                    101 32215.00 Mechanical Permits 32,770            32,770            43,251              10,481                              132% 39,791        3,460                                 101 32230.00 Plumbing Permits 31,285            31,285            43,918              12,633                              140% 31,187        12,731                              101 32231.00 Sewer/Water Inspection 7,725               7,725               5,525                 (2,200)                               72% 5,817           (292)                                   101 32232.00 Plumbing Registrations 1,200               1,200               675                    (525)                                   56% 1,150           (475)                                   101 32240.00 Animal Licenses 3,750               3,750               3,500                 (250)                                   93% 3,540           (40)                                     101 32260.00 Burning Permits 2,625               2,625               1,875                 (750)                                   71% 2,100           (225)                                   101 32270.00 Short‐term Rental Fee 1,200               1,200               800                    (400)                                   67% 1,200           (400)                                   Licenses and Permits 630,495          630,495          596,884            (33,611)                             95% 472,520      124,364                            Intergovernmental 101 33160.10 Fed Aids/Grants ‐ Operating Grants ‐                    ‐                    ‐                                     n/a ‐                ‐                                     101 33160.11 Fed Aids/Grants ‐ Operating Police 18,000            18,000            9,917                 (8,084)                               55% 5,765           4,151                                 101 33401.00 Local Government Aid 15,180            15,180            5,953                 (9,228)                               39% 5,953            ‐                                     101 33416.01 State Aid ‐ Police Train 7,800               7,800               6,253                 (1,547)                               80% 7,330           (1,077)                               101 33416.02 State Police Aid‐Ins Prem 175,000          175,000          188,115            13,115                              107%‐               188,115                            101 33417.00 State Aid ‐ Fire Training 7,000               7,000               8,910                 1,910                                 127% 5,854           3,056                                 101 33418.00 State Road & Bridge Aid 316,827          316,827          292,692            (24,135)                             92% 285,144      7,547                                 101 33420.00 State Fire Aid‐Ins. Prem. 206,000          206,000          214,891            8,891                                 104%‐               214,891                            101 33422.10 State Aids/Grants ‐ Operating Grants ‐                    ‐                    ‐                                     n/a ‐                ‐                                     102 33422.11 State Aids/Grants ‐ Operating Police ‐                    ‐                   1,957                 1,957                                 n/a ‐               1,957                                 101 33620.00 Township Fire & Resc Aid 311,068          311,068          311,068             ‐                                     100% 279,094      31,974                              101 33621.00 Liaison Aid 45,860            45,860            (45,860)                             0% 23,565        (23,565)                             101 33630.00 Metro Council Grants 12,500            12,500            (12,500)                             0%‐                ‐                                     101 33631.00 Payment in Lieu of Taxes 420,000          420,000          322,500            (97,500)                             77% 315,000      7,500                                 101 33700.23 Miscellaneous Grants ‐ Capital Parks ‐                    ‐                    ‐                                     n/a ‐                ‐                                     Intergovernmental 1,535,235       1,535,235       1,362,255         (172,980)                           89% 927,705      434,551                            COMPARATIVE City of Prior Lake General Fund Revenues As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive ( Negative) USED 9/30/2015 Positive (Negative) COMPARATIVE Charges for Services 101 31810.00 Franchise Taxes 595,000          595,000          307,290            (287,710)                           52% 300,293      6,997                                 101 34103.00 Zoning & Subdivision Fees 17,050            17,050            22,577              5,527                                 132% 23,121        (544)                                   101 34104.00 Plan Check Fees 253,396          253,396          237,005            (16,391)                             94% 183,128      53,876                              101 34105.00 Sale of Maps/Publications ‐ Reports 1,000               1,000               974                    (26)                                     97% 2,183           (1,209)                               101 34107.00 Assessment Searches ‐ Reports 400                  400                  520                    120                                    130% 490              30                                       101 34109.00 Project Admin/Eng Fees 343,000          343,000          172,579            (170,421)                           50% 207,582      (35,004)                             101 34203.00 Accident/Warrant Reports ‐ Reports 780                  780                  68                       (712)                                   9% 70                 (2)                                       101 34304.00 PEG Access Fees 34,000            34,000            16,178              (17,822)                             48% 16,505        (326)                                   101 34731.00 Softball Fees 25,000            25,000            13,199              (11,801)                             53% 22,619        (9,420)                               101 34735.00 Recreation Program Fees 40,000            40,000            48,481              8,481                                 121% 41,915        6,566                                 101 34740.00 Concessions ‐ Park Fees 750                  750                  72                       (678)                                   10%‐               72                                       101 34760.01 Facility Rental ‐ Regular 73,361            73,361            55,026              (18,335)                             75% 54,081        944                                    101 34761.00 Studio/Pavilion Rental 15,000            15,000            16,542              1,542                                 110% 15,308        1,234                                 101 34762.00 Park Shelter Rental 14,000            14,000            17,871              3,871                                 128% 14,048        3,823                                 101 34765.01 Tower Leases 243,069          243,069          244,686            1,617                                 101% 229,725      14,961                              101 34780.00 Park Admission Fees 15,000            15,000            23,668              8,668                                 158% 18,032        5,637                                 101 34783.00 City Contract Services 43,500            43,500            47,112              3,612                                 108% 43,940        3,172                                 Charges for Services 1,714,306       1,714,306       1,223,847         (490,459)                           71% 1,173,040   50,807                              Fines and Forfeitures 101 35101.00 County Court Fines ‐                    ‐                   500                    500                                    n/a 1,350           (850)                                   101 35104.00 Prosecution Restitution ‐                    ‐                   4,243                 4,243                                 n/a ‐               4,243                                 Fines and Forfeitures ‐                    ‐                   4,743                 4,743                                 n/a 1,350           3,393                                 Interest (losses) on investments 101 36210.00 Interest Earnings 120,000          120,000          67,251              (52,750)                             56% 77,723        (10,473)                             101 36225.00 Unrealized Inv.Gain(Loss)‐                    ‐                   49,835              49,835                              n/a 45,089        4,746                                 Interest (losses) on investments 120,000          120,000          117,085            (2,915)                               98% 122,812      (5,727)                               Other Miscellaneous Revenues 101 36102.00 County Assess. Collection 5,000               5,000               2,735                 (2,265)                               55% 1,237           1,498                                 102 36101.00 City Assess. Collection ‐                    ‐                   2,004                 2,004                                 n/a ‐               2,004                                 101 36211.00 Developer Agreements 55,000            55,000            74,261              19,261                              135% 60,669        13,592                              101 36212.00 Miscellaneous Revenue 95,550            95,550            44,884              (50,666)                             47% 69,152        (24,269)                             101 36220.16 Prof Services Fee Dep Bldg Inspections 28,177               101 36230.00 Contributions & Donations ‐                    ‐                   4,500                 4,500                                 n/a 10,685        (6,185)                               101 39102.00 Sale of Property ‐                    ‐                   10,129              10,129                              n/a 7,130           2,999                                 Other Miscellaneous Revenues 155,550          155,550          166,689            11,139                              107% 148,874      17,816                              Other financing sources 101 39203.00 Transfer from Other Funds 532,640          362,640          271,980            (90,660)                             75% 266,640      5,340                                 Transfers in 532,640          362,640          271,980            (90,660)                             75% 266,640      5,340                                 Total Revenues 12,945,738    12,775,738    8,009,974         (4,765,764)                       63% 7,300,543   709,431                            City of Prior Lake General Fund Expenditures As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance from 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Function: General Government 41110.00 MAYOR & COUNCIL 55,409          55,409          38,684        16,725                         70% 39,648        965                               41130.00 ORDINANCE 7,500            7,500            4,940          2,560                           66% 4,691          (250)                              41320.00 ADMINISTRATION 404,081        404,081        301,851     102,230                       75% 275,807     (26,044)                        41330.00 BOARDS & COMMISSIONS 10,539          10,539          7,033          3,506                           67% 6,800          (234)                              41410.00 ELECTIONS 29,640          29,640          9,105          20,535                         31% (26)              (9,131)                           41520.00 FINANCE 444,977        444,977        320,321     124,656                       72% 281,718     (38,603)                        41530.00 ACCOUNTING ‐                 ‐                249             (249)                             n/a 182             (67)                                41540.00 INTERNAL AUDITING 28,150          28,150          31,733        (3,583)                          113% 30,748        (985)                              41550.00 ASSESSING 169,750        169,750        167,500     2,250                           99% 150,000     (17,500)                        41610.00 LEGAL 200,000        200,000        105,655     94,345                         53% 157,794     52,139                          41820.00 HUMAN RESOURCES 154,831        154,831        107,570     47,261                         69% 58,623        (48,947)                        41830.00 COMMUNICATIONS 114,393        114,393        79,382        35,011                         69% 72,249        (7,133)                           41910.00 COMMUNITY DEVELOPMENT 337,359        337,359        228,556     108,803                       68% 200,385     (28,170)                        41920.00 INFORMATION TECHNOLOGY 336,161        336,161        207,135     129,026                       62% 178,470     (28,665)                        41940.00 FACILITIES ‐ CITY HALL 452,059        452,059        329,222     122,837                       73% 373,394     44,173                          Total ‐ Function General Government 2,744,849    2,744,849    1,938,934  805,914                       71% 1,830,483  (108,451)                      Function: Public Safety 42100.00 POLICE 3,542,365    3,554,365    2,578,395  975,969                       73% 2,285,740  (292,655)                      42200.00 FIRE 902,032        902,032        462,824     439,208                       51% 448,813     (14,010)                        42400.00 BUILDING INSPECTION 595,843        595,843        415,010     180,833                       70% 387,684     (27,326)                        42500.00 EMERGENCY MANAGEMENT 9,750            9,750            1,212          8,538                           12% 9,110          7,898                            42700.00 ANIMAL CONTROL 26,448          26,448          17,200        9,248                           65% 16,800        (400)                              Total ‐ Function Public Safety 5,076,437    5,088,437    3,474,641  1,613,796                   68% 3,148,147  (326,494)                      Function: Public Works 43050.00 ENGINEERING 387,626        387,626        248,572     139,054                       64% 254,003     5,431                            43100.00 STREET 1,385,392    1,406,392    777,900     628,492                       55% 779,467     1,567                            43400.00 CENTRAL GARAGE 380,369        380,369        247,606     132,763                       65% 210,712     (36,894)                        Total ‐ Function Public Works 2,153,387    2,174,387    1,274,078  900,309                       59% 1,244,182  (29,896)                        Function: Culture and Recreation 45100.00 RECREATION 406,218        406,218        308,650     97,568                         76% 262,917     (45,733)                        45200.00 PARKS 1,433,838    1,463,838    939,775     524,063                       64% 948,796     9,021                            45500.00 LIBRARIES 46,289          46,289          31,090        15,199                         67% 48,865        17,775                          46100.00 NATURAL RESOURCES ‐                 ‐                149             (149)                             n/a (29)              (178)                              Total ‐ Function Culture and Recreation 1,886,346    1,916,346    1,279,665  636,681                       67% 1,260,550  (19,116)                        00000.00 Transfer to Other Funds 1,084,719    1,084,719    84,684        1,000,035                   8% 102,746     18,063                          Function: Contingent Reserve 49999.00 CONTINGENT RESERVE ‐                 ‐                 ‐               ‐                               n/a 6,213          6,213                            Total ‐ Function Contingent Reserve ‐                 ‐                 ‐               ‐                               n/a 6,213          6,213                            Total Expenditures 12,945,738  13,008,738  8,052,002  4,956,736                   62% 7,592,320  (459,682)                                     COMPARATIVE City of Prior Lake Debt Service Funds As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Property Taxes Current Property Taxes 2,340,850  2,340,850  1,204,660  (1,136,190)                   51% 965,939      238,721                        Special Assessments City Assess. Collections ‐                ‐               165,601      165,601                       n/a 160,205      5,396                             County Assess. Collection 762,607      762,607      219,157      (543,450)                      29% 179,898      39,259                           Interest (losses) on investments Interest Earnings 24,245        24,245        28,807        4,562                            119% 92,595        (63,789)                         Unrealized Inv.Gain(Loss)‐                ‐               12,411        12,411                          n/a 12,311        100                                Miscellaneous Revenues Miscellaneous Revenues ‐                ‐               (70)               (70)                                n/a 70                                   Other Financing Sources Transfer from Other Funds 1,697,997  1,697,997  504,659      (1,193,338)                   30% 245,208      259,451                        Bond Proceeds ‐                ‐               1,656,086  1,656,086                    n/a 5,529,906  (3,873,820)                    Bond Discount/Premium ‐                ‐                ‐                                n/a ‐                ‐                                 Total Revenues 4,825,699  4,825,699  3,791,311  (1,034,388)                   79% 7,186,062  (3,394,611)                    Expenditures Debt Service Principal 3,792,365  3,792,365  263,683      3,528,683                    7% 135,000      (128,683)                       Interest and Other 1,317,807  1,317,807  550,224      767,583                       42% 510,994      (39,229)                         Other Debt Service Exp ‐                ‐               990              (990)                              n/a 1,995          1,005                             Transfers to Other Funds ‐                ‐                ‐                                n/a ‐                ‐                                 Bond Issuance Costs ‐                ‐               44,155        (44,155)                        n/a 92,463        48,308                           Bond Discount/Premium ‐                ‐               (70,270)       70,270                          n/a (143,647)    (73,377)                         Total Expenditures 5,110,172  5,110,172  788,781      4,321,391                    15% 596,805      (191,976)                       Net Change (284,473)    (284,473)    3,002,530  6,589,257                  COMPARATIVE City of Prior Lake Cable Fund As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Charges for Services 210‐41340.00‐31810.00 50,873 210‐41340.00‐34304.00 PEG Access Fees 5,133   5,133        6,296    1,163                           123% 5,133        1,163                            Total Revenues 5,133   5,133        57,169  1,163                           1114% 5,133        52,036                          Expenditures Capital Outlay 210‐41340.00‐55530.00 Infrastructure ‐         ‐             ‐         ‐                                n/a ‐             ‐                                 210‐41340.00‐55570.00 Machinery & Equipment 6,360   6,360        5,261    1,099                           83%‐            (5,261)                           Total Expenditures 6,360   6,360        5,261    1,099                           83%‐            (5,261)                           Net Change (1,227)  (1,227)       51,908  5,133                        COMPARATIVE City of Prior Lake Capital Park Fund As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Charges for Services 225‐45200.00‐34760.01 Facility Rental ‐ Regular 23,400    23,400      17,950    (5,450)                         77% 19,500      (1,550)                          225‐45200.00‐34791.00 Dedication Fees 567,000  567,000    542,650  (24,350)                       96% 89,060      453,590                       Charges for Services 590,400  590,400    560,600  (29,800)                       95% 108,560    452,040                       Interest (losses) on investments 225‐00000.00‐36210.00 Interest Earnings 7,000      7,000        7,105      105                              101% 8,867        (1,762)                          225‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐           ‐            4,137      4,137                           n/a 5,862        (1,725)                          Interest (losses) on investments 7,000      7,000        11,241    4,241                           161% 14,729      (3,487)                          Contributions and donations 225‐00000.00‐36230.00 Contributions & Donations ‐           ‐             ‐                               n/a 1,300        (1,300)                          Contributions and donations ‐           ‐            6,080       ‐                               n/a 1,300        (1,300)                          Total Revenues 597,400  597,400    577,921  (25,559)                       97% 124,589    447,253                       Expenditures 54320.00 Miscellaneous ‐           ‐            3,712      (3,712)                         n/a 3,346        (367)                              59203.00 Transfers to Other Funds 170,000   ‐             ‐           ‐                               n/a 62,356      62,356                          53100.80 Professional Services‐General ‐           ‐            9,147      (9,147)                         n/a 2,124        (7,023)                          55530.00 Infrastructure 170,000  170,000    387,168  (217,168)                     228% 26,916      (360,252)                      Total Expenditures 340,000  170,000    400,027  (230,027)                     235% 94,741      (304,919)                      Net Change 257,400  427,400    177,895  29,848                      COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Taxes 410‐00000.00‐31010.00 Current Property Taxes 325,000     325,000     167,096  (157,904)                     51% 128,726   38,370                         Taxes 325,000     325,000     167,096  (157,904)                     51% 128,726   38,370                         Intergovernmental 410‐00000.00‐33160.10 Fed Aids/Grants ‐ Operating Grants ‐               ‐               ‐           ‐                               n/a ‐             ‐                                410‐00000.00‐33422.10 State Aids/Grants ‐ Operating Grants ‐               ‐               ‐           ‐                               n/a ‐             ‐                                Intergovernmental ‐               ‐               ‐           ‐                               n/a ‐             ‐                                Interest (losses) on investments 410‐00000.00‐36210.00 Interest Earnings 15,067        15,067        8,596      (6,471)                         57% 12,663      (4,067)                          410‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐               ‐              6,545      6,545                           n/a 9,555        (3,010)                          Interest (losses) on investments 15,067        15,067        15,141    74                                100% 22,218      (7,077)                          Sale of assets 410‐00000.00‐39102.00 Sale of Property 24,000        24,000        (24,000)                       0% 6,240        (6,240)                          Sale of assets 24,000        24,000         ‐          (24,000)                       0% 6,240        (6,240)                          Other 410‐42100.06‐39104.00 Forfeiture Property Sales ‐               ‐               ‐           ‐                               n/a 80,523      (80,523)                        Other ‐               ‐               ‐           ‐                               n/a 80,523      (80,523)                        Transfers in 410‐00000.00‐39203.00 Transfer from Other Funds 141,000     141,000     105,750  (35,250)                       75% 105,750    ‐                                Transfers in 141,000     141,000     105,750  (35,250)                       75% 105,750    ‐                                Debt Issued 410‐00000.00‐39310.00 G.O. Bond Proceeds 400,000     400,000     410,000  10,000                        103%‐            410,000                       Debt Issued 400,000     400,000     410,000  10,000                        103%‐            410,000                       Total Revenues 905,067     905,067     697,987  (207,080)                     77% 343,457   354,530                       Expenditures Public Safety Police 410‐42100.00‐55550.00 Vehicles 98,116        98,116        92,186    5,930                           94% 94,932      2,746                            410‐42100.06‐54350.00 Agency Forfeit Proceeds ‐               ‐               ‐                               n/a 56,578      56,578                         Fire 410‐42200.00‐55550.00 Vehicles 103,000     103,000     441          102,559                      0% 96,196      95,755                         410‐42200.00‐55570.00 Machinery & Equipment ‐               ‐               ‐           ‐                               n/a ‐             Total Public Safety 201,116     201,116     92,627    108,489                      46% 247,706   155,079                       Public Works Street 410‐43100.00‐55070.00 Projects ‐ Bond Issuance Costs ‐               ‐              11,039    (11,039)                       n/a ‐            (11,039)                        410‐43100.00‐55110.00 Projects ‐ Bond Discount/Premium ‐               ‐              (16,305)   16,305                        n/a ‐            16,305                         410‐43100.00‐55550.00 Vehicles 435,690     435,690     174,802  260,888                      40% 260,352   85,550                         410‐43100.00‐55570.00 Machinery & Equipment ‐               ‐              41,024    (41,024)                       n/a ‐            (41,024)                        Engineering 410‐43050.00‐55550.00 Vehicles ‐               ‐               ‐           ‐                               n/a ‐             ‐                                Central Garage 410‐43400.00‐55550.00 Vehicles 20,000        20,000        365          19,636                        2% 11,261      10,897                         Total Public Works 455,690     455,690     210,925  244,765                      46% 271,613   60,688                         Culture and Recreation 410‐45200.00‐55530.00 Infrastructure ‐               ‐               ‐           ‐                               n/a ‐             ‐                                410‐45200.00‐55550.00 Vehicles 279,645     279,645     52,813    226,832                      19% 97,286      44,472                         410‐45200.00‐55570.00 Machinery and Equipment 264,504     264,504     227,956  36,548                        86%‐            (227,956)                      Total Culture & Recreation 544,149     544,149     280,769  263,380                      52% 97,286      (183,483)                      Water 410‐49400.00‐55550.00 Vehicles ‐               ‐               ‐           ‐                               n/a 25,368      25,368                         410‐49400.00‐55570.00 Machinery and Equipment ‐               ‐               ‐           ‐                               n/a 13,950      13,950                         Water Quality 410‐49420.00‐55550.00 Vehicles ‐               ‐               ‐           ‐                               n/a 89,831      89,831                         Sewer 410‐49450.00‐55570.00 Machinery and Equipment ‐               ‐               ‐           ‐                               n/a 2,500        2,500                            Transfers Transfers to Other Funds ‐               ‐              4,533      (4,533)                         n/a ‐            (4,533)                          Total Utility ‐               ‐               ‐           ‐                               n/a 131,649   131,649                       Total Expenditures 1,200,955  1,200,955  588,853  612,102                      49% 748,254   159,401                       Net Change (295,888)    (295,888)    109,134  (404,797)                  COMPARATIVE City of Prior Lake Facilities Management Fund As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Interest (losses) on investments 440‐00000.00‐36210.00 Interest Earnings 8,029      8,029        7,414      (615)                             92% 8,902           (1,488)                          440‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐           ‐            4,683      4,683                           n/a 5,254           (571)                              Interest (losses) on investments 8,029      8,029        12,096    4,067                           151% 14,156         (2,060)                          Transfers in 440‐00000.00‐39203.00 Transfer from Other Funds 55,000    55,000      41,250    (13,750)                       75% 37,500         3,750                            Transfers in 55,000    55,000      41,250    (13,750)                       75% 37,500         3,750                            Debt Issued 440‐00000.00‐39310.00 G.O. Bond Proceeds 620,000  620,000     ‐          (620,000)                     0%‐                ‐                                Debt Issued 620,000  620,000     ‐          (620,000)                     0%‐                ‐                                Energy Lease Issued 440‐00000.00‐39335.00 Lease Proceeds ‐           ‐             ‐           ‐                               n/a ‐                ‐                                Energy Lease Issued ‐           ‐             ‐           ‐                               n/a ‐                ‐                                Total Revenues 683,029  683,029    53,346    (629,683)                     8% 51,656         1,690                            Expenditures Function: General Government 00000.00 Transfers to Other Funds 45,614    45,614      22,807    22,807                         50%‐               (22,807)                        41910.00 COMMUNITY DEVELOPMENT ‐           ‐             ‐                               n/a 827               827                               41960.00 GESP ‐           ‐            101,294  (101,294)                     n/a 1,076,665    975,371                       Total ‐ Function General Government 45,614    45,614      124,101  (78,487)                       272% 1,077,492    953,391                       Function: Public Safety 42100.00 POLICE 44,558    44,558       ‐          44,558                         0%‐                ‐                                42200.00 FIRE 36,284    36,284       ‐          36,284                         0%‐                ‐                                Total ‐ Function Public Safety 80,842    80,842       ‐          80,842                         0%‐                ‐                                Function: Public Works 43400.00 CENTRAL GARAGE ‐           ‐             ‐           ‐                               n/a ‐                ‐                                Total ‐ Function Public Works ‐           ‐             ‐           ‐                               n/a ‐                ‐                                Function: Culture and Recreation 45100.00 RECREATION ‐           ‐             ‐           ‐                               n/a 6,642           6,642                            45500.00 LIBRARIES ‐           ‐             ‐           ‐                               n/a 6,872           6,872                            Total ‐ Function Culture and Recreation ‐           ‐             ‐           ‐                               n/a 13,514         13,514                          Function: Water 49400.00 Building & Building Improvement 619,950  619,950     ‐          619,950                      0%‐                ‐                                Total ‐ Function Water 619,950  619,950     ‐          619,950                      0%‐                ‐                                Total Expenditures 746,406  746,406    124,101  622,305                      17% 1,091,007    966,906                       Net Change (63,377)   (63,377)    (70,755)   (1,039,350)                  COMPARATIVE City of Prior Lake Water Fund As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Intergovernmental 601‐00000.00‐33633.00 Watershed Dist Grants/Aid ‐                ‐                ‐                ‐                                n/a ‐                ‐                                 601‐49400.00‐33422.15 State Aids/Grants ‐  Oper PW 3,333           601‐49400.00‐33422.25 State Aids/Grants ‐  Cap PW 10,000         Intergovernmental ‐                ‐               13,333         ‐                                n/a ‐                ‐                                 Interest (losses) on investments 601‐00000.00‐36210.00 Interest Earnings 60,000        60,000        27,666        (32,334)                        46% 37,989        (10,323)                         601‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                ‐               19,444        19,444                          n/a 23,888        (4,444)                            Interest (losses) on investments 60,000        60,000        47,110        (12,890)                        79% 61,877        (14,767)                         Debt Issued 601‐00000.00‐39310.00 G.O. Bond Proceeds 950,000      950,000       ‐               (950,000)                      0%‐                ‐                                 Debt Issued 950,000      950,000       ‐               (950,000)                      0%‐                ‐                                 Miscellaneous Revenues 601‐00000.00‐36212.00 Miscellaneous Revenue ‐                ‐               1,608          1,608                            n/a 515              1,093                             601‐00000.00‐36102.00 County Assess Collection ‐                ‐               581              581                               n/a 581                                601‐49400.00‐37190.00 Miscellaneous Revenue Adj ‐                ‐               32                32                                  n/a 48                (16)                                 601‐00000.00‐37901.00 Contribution (Other Fund)‐                ‐                ‐                ‐                                n/a ‐                ‐                                 601‐00000.00‐37902.00 Contribution (Developers)‐                ‐                ‐                ‐                                n/a ‐                ‐                                 Miscellaneous Revenues ‐                ‐               2,221          2,221                            n/a 563              1,658                             Water Charges 601‐49400.00‐37100.00 Utility Receipts ‐ Water 3,363,646  3,363,646  2,118,515  (1,245,131)                   63% 1,751,306  367,209                        601‐49400.00‐37160.00 Penalties 7,000          7,000          11,455        4,455                            164% 15,362        (3,907)                            Water Charges 3,370,646  3,370,646  2,129,971  (1,240,675)                   63% 1,766,668  363,302                        Capital Facility charges 601‐49400.00‐37110.00 Capital Facility Revenue 254,340      254,340      170,886      (83,454)                        67% 168,344      2,541                             Capital Facility charges 254,340      254,340      170,886      (83,454)                        67% 168,344      2,541                             Meter Sales 601‐49400.00‐37170.00 Water Meter Sales 104,150      104,150      53,401        (50,749)                        51% 60,659        (7,258)                            601‐49400.00‐37175.00 Pressure Reducers 35,400        35,400        16,915        (18,485)                        48% 17,544        (629)                               601‐49400.00‐37180.00 Frost Plates ‐                ‐               7                  7                                    n/a 28                (21)                                 Meter Sales 139,550      139,550      70,323        (69,227)                        50% 78,230        (7,907)                            Total Revenues 4,774,536  4,774,536  2,433,843  (2,354,026)                   51% 2,075,682  344,828                        Expenditures Function: General Government 00000.00 Transfers to Other Funds 828,464      828,464      1,185,543  (357,079)                      143% 1,434,038  248,496                        41520.00 FINANCE 87,683        87,683        62,000        25,683                          71% 54,938        (7,062)                            Total ‐ Function General Government 916,147      916,147      1,247,543  (331,396)                      136% 1,488,976  241,433                        Function: Water 49400.00 WATER 4,179,428  4,179,428  1,276,709  2,902,718                    31% 1,289,414  12,705                           Total ‐ Function Water 4,179,428  4,179,428  1,276,709  2,902,718                    31% 1,289,414  12,705                           Total Expenditures 5,095,575  5,095,575  2,524,253  2,571,322                    50% 2,778,390  254,138                        Net Change (321,039)    (321,038)    (90,409)       (702,708)     COMPARATIVE City of Prior Lake Sewer Fund As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Interest (losses) on investments 604‐00000.00‐36210.00 Interest Earnings 40,000        40,000        14,756        (25,244)                        37% 20,887          (6,132)                            604‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                ‐               10,574        10,574                          n/a 14,753          (4,179)                            Interest (losses) on investments 40,000        40,000        25,330        (14,670)                        63% 35,640          (10,310)                         Miscellaneous Revenues 604‐00000.00‐37901.00 Contribution (Other Fund)‐                ‐                ‐                ‐                                n/a ‐                 ‐                                 604‐00000.00‐37902.00 Contribution (Developers)‐                ‐                ‐                ‐                                n/a ‐                 ‐                                 Miscellaneous Revenues ‐                ‐                ‐                ‐                                n/a ‐                 ‐                                 Sewer Charges 604‐49450.00‐37102.00 Utility Receipts ‐ Sewer 1,207,960  1,207,960  841,275      (366,685)                      70% 682,638       158,637                        604‐49450.00‐37104.00 Utility Recpt‐Sewer MCES 1,327,560  1,327,560  777,282      (550,278)                      59% 726,641       50,641                           Sewer Charges 2,535,520  2,535,520  1,618,557  (916,963)                      64% 1,409,279    209,278                        Capital Facility charges 604‐49450.00‐37110.00 Capital Facility Revenue 254,970      254,970      170,892      (84,078)                        67% 168,350       2,542                             Capital Facility charges 254,970      254,970      170,892      (84,078)                        67% 168,350       2,542                             Water Charges 604‐49450.00‐37160.00 Penalties 7,000          7,000          10,214        3,214                            146% 7,722            2,493                             Water Charges 7,000          7,000          10,214        3,214                            146% 7,722            2,493                             Total Revenues 2,837,490  2,837,490  1,824,993  (1,012,497)                   64% 1,620,991    204,002                        Expenditures Function: General Government 00000.00 Transfers to Other Funds 251,320      251,320      552,945      (301,625)                      220% 1,281,880    728,935                        41520.00 FINANCE 87,683        87,683        61,969        25,714                          71% 54,904          (7,066)                            Total ‐ Function General Government 339,003      339,003      614,914      (275,911)                      181% 1,336,784    721,870                        Function: Sewer 49450.00 SEWER 2,593,298  2,593,298  1,493,407  1,099,891                    58% 1,550,956    57,549                           Total ‐ Function Sewer 2,593,298  2,593,298  1,493,407  1,099,891                    58% 1,550,956    57,549                           Total Expenditures 2,932,301  2,932,301  2,108,321  823,980                       72% 2,887,740    779,419                        Net Change (94,811)       (94,811)       (283,328)    (1,266,749)    COMPARATIVE City of Prior Lake Water Quality Fund As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance from 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Intergovernmental 602‐00000.00‐33160.10 Fed Aids/Grants ‐           ‐             ‐           ‐                               n/a ‐             ‐                                602‐00000.00‐33422.10 State Aids/Grants 34,790    34,790       ‐          (34,790)                       0% 2,190        (2,190)                          602‐49420.00‐33610.20 County‐City Aids/Grants ‐           ‐            (10,175)   (10,175)                       n/a ‐            (10,175)                        602‐49420.00‐33633.00 Watershed Dist Grants/Aid ‐           ‐             ‐           ‐                               n/a ‐             ‐                                Intergovernmental 34,790    34,790      (10,175)   (44,965)                        ‐29% 2,190        (12,365)                        Interest (losses) on investments 602‐00000.00‐36210.00 Interest Earnings 10,000    10,000      9,032      (968)                             90% 6,680        2,352                            602‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐           ‐            5,177      5,177                           n/a 4,035        1,142                            Interest (losses) on investments 10,000    10,000      14,210    4,210                           142% 10,715      3,494                            Miscellaneous Revenues 602‐00000.00‐37901.00 Contribution (Other Fund)‐           ‐             ‐           ‐                               n/a ‐             ‐                                Miscellaneous Revenues ‐           ‐             ‐           ‐                               n/a ‐             ‐                                Storm Water Charges 602‐49420.00‐37120.00 Storm Water Revenue 838,537  838,537   588,960  (249,577)                     70% 579,373   9,587                            Storm Water Charges 838,537  838,537   588,960  (249,577)                     70% 579,373   9,587                            Water Charges 602‐49420.00‐37160.00 Penalties ‐           ‐            2,322      2,322                           n/a 2,142        180                               Water Charges ‐           ‐            2,322      2,322                           n/a 2,142        180                               Total Revenues 883,327  883,327   595,316  (288,011)                     67% 594,420   897                               Expenditures Function: General Government 00000.00 Transfers to Other Funds 21,000    21,000      72,518    (51,518)                       345% 276,519   204,001                       Total ‐ Function General Government 21,000    21,000      72,518    (51,518)                       345% 276,519   204,001                       Function: Water Quality 49420.00 WATER QUALITY 942,553  942,553   267,162  675,391                      28% 338,492   71,330                         Total ‐ Function Water Quality 942,553  942,553   267,162  675,391                      28% 338,492   71,330                         Total Expenditures 963,553  963,553   339,680  623,873                      35% 615,011   275,331                       COMPARATIVE City of Prior Lake Economic Development Authority Special Revenue Fund As of 9/30/2016 (Preliminary & Unaudited) Variance from Variance from 2016 2016 2016 Amended Budget ‐ % BDGT Actual from 2015 Budget Amended Actual Positive (Negative) USED 9/30/2015 Positive (Negative) Revenues Taxes 240‐00000.00‐31010.00 Current Property Taxes 155,000  155,000   79,841    (75,159)                       52% 82,085      (2,244)                          240‐00000.00‐33423.00 Market Value Credit Aid ‐           ‐             ‐           ‐                               n/a ‐             ‐                                Taxes 155,000  155,000   79,841    (75,159)                       52% 82,085      (2,244)                          Intergovernmental 240‐46500.00‐33610.14 County‐City Aids/Grants ‐ Operat ‐           ‐            7,278      7,278                           n/a 11,976      (4,698)                          Intergovernmental ‐           ‐            7,278      7,278                           n/a 11,976      (4,698)                          Charges for Services 240‐00000.00‐34111.00 Administrative Charges ‐           ‐             ‐           ‐                               n/a ‐             ‐                                240‐46503.00‐34760.02 Facility Rental ‐ EDA 10,000    10,000      7,852      (2,148)                         79% 5,206        2,646                            Charges for Services 10,000    10,000      7,852      (2,148)                         79% 5,206        2,646                            Interest (losses) on investments 240‐00000.00‐36210.00 Interest Earnings 500          500           1,605      1,105                           321% 1,901        (296)                              240‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐           ‐            884          884                              n/a 1,010        (127)                              240‐46500.00‐36220.14 Prof Service Fee Deposit ‐ EDA 5,000       Interest (losses) on investments 500          500           7,489      1,989                           1498% 2,911        (4,578)                          Transfers in 240‐00000.00‐39203.00 Transfer from Other Funds ‐           ‐             ‐           ‐                               n/a ‐             ‐                                Transfers in ‐           ‐             ‐           ‐                               n/a ‐             ‐                                Total Revenues 165,500  165,500   102,460  (68,040)                       62% 102,178   282                               Expenditures Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 153,775  153,775   111,496  42,279                        73% 98,416      (13,080)                        46503.00 TECH VILLAGE INCUBATOR 27,650    27,650      5,169      22,481                        19% 9,461        4,292                            Total Expenditures 181,425  181,425   116,665  64,760                        64% 107,877   (8,788)                          Net Change (15,925)   (15,925)    (14,205)   (5,699)        COMPARATIVE