Loading...
HomeMy WebLinkAbout2015 Management Report CITY OF OAK PARK HEIGHTS, MINNESOTA AUDIT MANAGEMENT LETTER December 31, 2015 To the Honorable Mayor and Members of the City Council City of Oak Park Heights, Minnesota We have completed the 2015 audit of the City of Oak Park Heights, Minnesota and have issued our report thereon. Our Independent Auditor’s Report is included in the City’s Annual Financial Report. This Management Letter provides a summary of audit results along with comparisons and trend analysis of financial results. Thank you for the opportunity to serve the City. We are available to discuss this report with you. REDPATH AND COMPANY, LTD. St. Paul, Minnesota April 19, 2016 City of Oak Park Heights, Minnesota Audit Management Letter Report Summary Report Summary Several reports are issued in conjunction with the audit. A brief summary is as follows: Report Name Elements of Report Overview Annual Financial Report (AFR) Financial statements Unmodified (“clean”) opinion on the Financial Footnotes Statements Required supplementary information Statistical information Report on Internal Control and on Results of testing No findings of Compliance and Other Matters Internal controls over financial noncompliance reporting Internal control finding Compliance with laws, resulting in a prior period regulations, contracts and adjustment. grants State Legal Compliance Report Results of testing certain No findings of provisions of Minnesota noncompliance Statutes Audit Management LetterIntended to be a working tool for City Council Comparisons and trend analysis Outside factors influencing City financial reporting Policies and procedures 2 City of Oak Park Heights, Minnesota Audit Management Letter Analysis of Selected Accounts A NALYSIS OF S ELECTED A CCOUNTS Summary of Financial Activity The schedule below presents a condensed financial summary of all funds: Increase (Decrease) inFund Balance/ Revenue ExpendituresFund Balance/Net and Otherand OtherTransfersNetPosition FundSourcesUses(Net)Position12/31/15 1General$5,732,281$3,474,680($1,527,875)$729,726$4,632,533 Special Revenue Funds: 2Forfeiture and Seizure2,7549,9623,000(4,208)9,096 3Economic Development1,233 - - 1,23333,252 4TIF District #1184,590148,109 - 36,48186,341 5TIF District #21,01329,790 - (28,777)(406,043) Debt Service Funds: 6Bonds of 2008921430,417430,00050495,999 7Bonds of 2009327140,858140,000(531)19,741 8G.O. CIP Refunding Bonds of 2012A29,799104,758 - (74,959)4,941,725 9Bonds of 2014742,248250,100411,314903,4621,164,719 Capital Project Funds: 10Capital Revolving9,64879,199 - (69,551)26,189 11Budgeted Projects and Equipment Revolving19,848152,565593,842461,1252,422,997 12Street Reconstruction145,6263,947,41193,386(3,708,399)1,682,041 13City Hall Improvements7015,814 - (5,113)92,799 14Park Development4,7913,000 - 1,791661,464 15Moelter Park5,30220,186(97,100)(111,984)396,237 16Renewal and Replacement22,21426,058179,929176,0853,204,223 17Storm Sewer Renewal/Replacement973 - 263,800264,773440,719 18Sanitary Sewer Connection 33,821 - - 33,821454,428 19Water Connection163,163 - - 163,163612,759 20Storm Sewer Connection31,951 - - 31,951999,175 21Water Tower Rehabilitation49,0317340,47989,437368,605 22Well Rehabilitation94914,7369,006(4,781)127,719 23Sewer Rehabilitation367 - 1,9382,30553,177 Enterprise Funds: 24Water1,976,983491,730(363,544)1,121,7096,522,729 25Sanitary Sewer1,250,559744,554(174,442)331,5633,294,614 26Storm Sewer84,41359,951(3,733)20,729177,004 27 Total$10,495,506$10,133,951$0$361,555$32,114,242 3 City of Oak Park Heights, Minnesota Audit Management Letter Analysis of Selected Accounts Property Taxes A summary of property tax activity for the past five years is as follows: 20112012201320142015 Tax levy certified$3,964,704$4,228,062$4,538,193$4,784,896$5,022,731 Plus excess tax increment - 1,86211,23819,06322,148 Less market value homestead credit deduction(93,934) - - - - Net levy3,870,7704,229,9244,549,4314,803,9595,044,879 Receipts: Current property taxes3,819,2204,176,1254,515,2024,730,3425,029,814 Delinquent property taxes92,2695,82033,252(176,758)(6,734) Total receipts3,911,4894,181,9454,548,4544,553,5845,023,080 Adjustments(9,361)(30,356) - ($289,042)($21,976) Increase (decrease) in delinquent taxes receivable(50,080)17,623977(38,667)(177) Delinquent taxes - January 1132,81482,734100,357101,33462,667 Delinquent taxes - December 31$82,734$100,357$101,334$62,667$62,490 Current collection as a percent of current levy98.7%98.7%99.2%98.5%99.7% Total collections as a percent of current levy101.1%98.9%100.0%94.8%99.6% The City has experienced property tax abatements for the past two years. These abatements reduced property revenue as follows: 20152014 Current and delinquent tax collections$5,053,681$4,836,243 Payment in lieu of tax73,25173,245 Non-levy collections - 75 Reduction for property tax abatements(21,976)(289,042) Total property tax revenue reported in the financial statements$5,104,956$4,620,521 4 City of Oak Park Heights, Minnesota Audit Management Letter Analysis of Selected Accounts Tax Levies, Tax Rates and Tax Capacity A comparison of values for taxes payable in 2012 through 2016 is as follows: 20122013201420152016 Taxable market value$643,608,300$663,496,300$640,880,000$689,680,000$710,998,000 Tax capacity values: Real estate$10,095,639$10,257,139$10,165,672$10,715,786$10,998,502 Personal property90,84095,16895,59089,89693,894 Subtotal10,186,47910,352,30710,261,26210,805,68211,092,396 Tax increment - (108,254)(126,677)(185,870)(187,904) Fiscal disparity contribution(2,336,411)(2,346,765)(2,467,230)(2,214,196)(2,292,994) Fiscal disparity distribution405,806392,002386,218415,839388,319 Total$8,255,874$8,289,290$8,053,573$8,821,455$8,999,817 Tax capacity rates51.710 54.898 59.400 56.803 57.725 Tax levy$4,228,062$4,538,193$4,784,896$5,022,731$5,191,593 5 City of Oak Park Heights, Minnesota Audit Management Letter Analysis of Selected Accounts A schedule of tax capacity by classification is as follows: CITY OF OAK PARK HEIGHTS 20142015 Percent ofPercent of AmountCity TotalAmountCity Total Real estate: Agricultural$1,0690.0% $1,1720.0% Seasonal1,2350.0% 1,5200.0% Residential homestead1,660,30216.2% 1,954,15418.1% Residential nonhomestead1,173,27811.4% 1,324,77512.2% Commercial/industrial3,418,90233.3% 3,280,23230.4% Public utility3,904,92038.1% 4,148,06338.4% Railroad5,9660.1% 5,8700.1% Total real estate10,165,67299.1% 10,715,78699.2% Personal property95,5900.9% 89,8960.8% Total tax capacity$10,261,262100.0% $10,805,682100.0% As shown above, the City’s major tax payer (Xcel Energy) is 38.40% of total tax capacity. Tax Capacity by Property Class -2015 Personal Property 0.8% Public Utility 38.4% Residential Homestead 18.1% Residential Nonhomestead 12.2% Commercial/Industrial 30.5% 6 City of Oak Park Heights, Minnesota Audit Management Letter General Fund G ENERAL F UND The General Fund of the City is maintained to account for expenditures common to all cities (general government, public safety, public works, and parks and recreation). A ten- year history of major revenue sources that support the General Fund are as follows: (1) Property TaxesState AidsAll OtherTotal Revenue YearAmountPercentAmountPercentAmountPercentAmountPercent 2006$2,423,24677%$92,3703%$633,05720%$3,148,673100% 20072,687,730 79%181,233 5%547,531 16%3,416,494 100% 20083,156,807 82%120,701 3%592,538 15%3,870,046 100% 20093,134,378 82%249,822 7%439,143 11%3,823,343 100% 20103,305,004 79%180,174 4%673,969 17%4,159,147 100% 20113,583,487 87%75,860 2%468,768 11%4,128,115 100% 20124,245,360 90%69,677 1%423,580 9%4,738,617 100% 20134,433,202 90%86,775 2%388,469 8%4,908,446 100% 20144,620,521 89%79,354 2%481,640 9%5,181,515 100% 20155,104,956 89%135,133 2%492,192 9%5,732,281 100% (1) Since 2010, the General Fund has levied property taxes which have been transferred out to Debt Service Funds. Those levies were $608,000 $559,000, and $548,000 for the years ended December 31, 2015, 2014, and 2013, respectively. Major Revenue Sources -2015 State Aids 2% All Other 9% Property Taxes 89% 7 City of Oak Park Heights, Minnesota Audit Management Letter General Fund A graph of property taxes, state aids, and other revenue for the General Fund is as follows: $5,200,000 $5,000,000 $4,800,000 General Fund $4,600,000 Revenue by Source $4,400,000 $4,200,000 $4,000,000 $3,800,000 State Aids $3,600,000 All Other $3,400,000 $3,200,000 Property Taxes $3,000,000 Property Taxes without Debt $2,800,000 Levy $2,600,000 $2,400,000 $2,200,000 $2,000,000 $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $ - 2006200720082009201020112012201320142015 State Aids State aids of the General Fund have consisted of the following for the past seven years: State Aid2009201020112012201320142015 Market value homestead credit$ - $ - $ - $ - $ - $ - $ - LGA - - - - - - - Police aid69,39258,93063,27861,24270,03176,83978,435 Utility valuation transition aid178,390102,947 - - - - - Small cities grant - - - - - - 54,188 Other state revenue2,04018,29712,5828,43516,7442,5152,510 Totals$249,822$180,174$75,860$69,677$86,775$79,354$135,133 Change($69,648)($104,314)($6,183)$17,098($7,421)$55,779 % Change(28%)(58%)(8%)25% (9%)70% 8 City of Oak Park Heights, Minnesota Audit Management Letter General Fund Other General Fund Revenue Other revenue of the General Fund has consisted of the following for the past seven years: Description2009201020112012201320142015 Licenses and permits$100,074$197,181$131,081$163,986$90,910$137,543$125,704 Charges for services: (1) Enterprise64,40066,42069,4253,8304,1804,2484,242 Other9,89077,38618,12713,698300,22380,618144,399 Fines and forfeits70,10258,36557,86255,02351,36056,53764,515 (2) Earnings on investments 55,43950,67541,37836,791(23,982)73,41218,621 (3) Other139,238223,942150,895140,940135,864105,353112,930 Total$439,143$673,969$468,768$414,268$558,555$457,711$470,411 (1) Beginning in 2012, an administrative fee is charged only to the Storm Sewer Fund. As a result, the transfers from Water and Sewer to the Renewal and Replacement Fund were increased $64,047. Transfers were made in 2014 that were similar to 2013 and 2012. (2) Earnings on investments is negative in 2013 due to a market value adjustment. Although the City holds its investments to maturity and will receive par value at maturity, accounting standards require the City to report its investments at market value at year-end. The change in market value for 2013 resulted in an adjustment of $185,738. (3) The significant increase in other charges for services from 2012 to 2013 occurred because the City received a $207,600 closing fee when Presbyterian Homes refinanced their conduit debt agreement 9 City of Oak Park Heights, Minnesota Audit Management Letter General Fund Budget Versus Actual Comparison The General Fund balance increased by $729,000. Charges for services revenue exceeding budget resulted in higher than anticipated revenue. Expenditures in most City departments were also less than budgeted. A summary is as follows: 2015 Favorable (Unfavorable) BudgetActualVariance Revenue: General property taxes: Current and delinquent$5,022,731$5,053,681$30,950 Abatement of proptery taxes- (21,976) (21,976) Payment in lieu of taxes70,00073,2513,251 Total general property taxes5,092,7315,104,95612,225 Intergovernmental83,040156,90973,869 Licenses and permits51,830125,70473,874 Charges for services54,398148,64194,243 Fines and forfeits45,00064,51519,515 Earnings on investments - 18,62118,621 Refunds and reimbursements75,000108,38533,385 Donations and contributions - 4,5504,550 Other - - - Total revenue5,401,9995,732,281330,282 10 City of Oak Park Heights, Minnesota Audit Management Letter General Fund 2015 Favorable (Unfavorable) BudgetActualVariance Expenditures: General government: Mayor and council$103,055$89,489$13,566 City administration281,735278,9682,767 Legal 30,00044,881(14,881) General management and building 176,260142,85833,402 Elections 1,3001,456(156) Finance 277,308180,33696,972 Computer system 44,10036,7267,374 Audit 29,50030,555(1,055) Insurance 380,192354,93925,253 Assessing 23,50022,716784 Planning and zoning 32,00035,035(3,035) Engineering 27,85024,3103,540 General contingency 16,8838,2298,654 Total general government1,423,6831,250,498173,185 Public safety: Police department 1,322,5761,282,76839,808 Building inspections 107,28498,5768,708 Fire protection 230,238227,1473,091 Civil defense3,6009752,625 Animal control 1,6501,365285 Capital outlay - - - Total public safety1,665,3481,610,83154,517 Public works: Street maintenance 81,37564,56716,808 Snow removal 202,00079,726122,274 Sanitation203,650199,7713,879 Street lighting 76,00066,9359,065 Arborist 18,90012,5356,365 Tree removal and planting 35,00035,473(473) Total public works616,925459,007157,918 Recreation: Parks, playgrounds and rinks 171,168154,34416,824 Total expenditures3,877,1243,474,680402,444 Revenue over expenditures1,524,8752,257,601732,726 Other financing sources (uses): Sale of property - - - Transfers to Debt Service Fund - - - Transfers to Capital Project Fund(608,000)(608,000) - Transfers to Enterprise Fund(916,875)(916,875) - Transfers to Nonmajor Governmental Fund - (3,000)(3,000) Total other financing sources (uses)(1,524,875)(1,527,875)(3,000) Net increase (decrease) in fund balance$0$729,726$729,726 11 City of Oak Park Heights, Minnesota Audit Management Letter General Fund Transfers to other funds for 2015 included the following amounts: Fund20152014 Street Reconstruction353,600$ 343,295$ Storm Sewer Renewal/Replacement84,00081,628 Debt Service - 2008 Bonds430,000420,000 Debt Service - 2009 Bonds140,000139,000 Debt Service - 2014 Bonds38,000 - Budgeted Projects Fund479,275359,950 Forfeiture and Seizure Fund3,000 - $1,527,875$1,343,873 12 City of Oak Park Heights, Minnesota Audit Management Letter General Fund General Fund Reserves The fund balance of the General Fund increased in 2015. The schedule below reflects the General Fund balance for the past five years: Year EndedFundIncrease December 31,Balance(Decrease) 2011$3,261,561$287,764 20123,669,633408,072 20133,514,371(155,262) 20143,902,807388,436 20154,632,533729,726 $5,000,000 $4,500,000 $4,000,000 $3,500,000 Actual Fund Balance $3,000,000 Minimum Fund Balance per policy $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $0 20112012201320142015 13 City of Oak Park Heights, Minnesota Audit Management Letter General Fund Reserve balances are an important component of City financial management. When evaluating the adequacy of reserve balances, there are a number of important factors that must be considered. Several areas to consider are illustrated as follows: Need for Reserve Balances Benefits of Reserve Balances Cash Flow Timing Favorable bond rating Supplements revenues Difference indicatorwith investment income Intergovernmental Capital Outlay Revenue Cutbacks Replacement Avoids temporary Provides resources for overdrafts prior to major minor projects or receipts feasibility reports Avoids overburdening Provides the City of annual budgets for greater options to deal Emergency or certain capital outlay Specialwith unexpected events Unanticipated Projects Expenditures 14 City of Oak Park Heights, Minnesota Audit Management Letter General Fund The City’s current fund balance policy was adopted on November 15, 2011. The purpose of the policy is to establish appropriate fund balance levels for each fund that is primarily supported by property tax revenues or user fees. The City’s fund balance policy states the City will maintain funds for the following: Compensated absences Cash flow Contingencies The compensated absences reserve is an amount equal to 50% of accumulated vacation leave and 100% of that portion of sick leave that would be payable under the City’s severance pay policy. Assigned Fund Balance For Employee Benefits December 31, Employee Benefit20142015 Vacation leave carryover (50%)$48,174$49,753 Severance110,423115,366 Total$158,597$165,119 Rounded amount$165,000 15 City of Oak Park Heights, Minnesota Audit Management Letter General Fund Cash Flow Reserve Property taxes and related state aids have accounted for 80% to 85% of the revenue of the General Fund in recent years. Property taxes and the majority of state aid are not received until July and December of each year (i.e., the second half of the year). As a result, the City is required to have sufficient reserves at the beginning of the year to fund operations of the first half of the year. The City’s fund balance policy states that its cash flow reserve should be equal to 45-55% of the subsequent year’s budgeted operating expenditures. The recommended cash flow reserve is $2,370,000, computed as follows: Cash Flow Reserve 2016 tax levy $5,191,593 Less transfers out which occur after taxes are received(450,700) $4,740,893 Reserve amount @ 50%$2,370,000 16 City of Oak Park Heights, Minnesota Audit Management Letter General Fund The following graph of monthly General Fund cash balances illustrates the impact of receiving property taxes and state aids in the second half of the year: $4,400,000 General Fund Monthly Cash Balances $4,200,000 $4,000,000 $3,800,000 $3,600,000 $3,400,000 $3,200,000 $3,000,000 $2,800,000 $1,739,000 $2,600,000 decrease $2,400,000 $2,200,000 $2,000,000 $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 12/31/20141/31/20152/28/20153/31/20154/30/20155/31/20156/30/20157/31/20158/31/20159/30/201510/31/201511/30/201512/31/2015 Cash $3,455,566$3,172,642$2,992,216$2,746,014$2,502,177$2,234,807$1,716,876$3,509,560$3,254,814$2,965,926$2,854,094$2,713,308$4,194,065 As shown above, the cash balance decreased $1,739,000 between January 1 and June 30, illustrating the need for the cash flow reserve. 17 City of Oak Park Heights, Minnesota Audit Management Letter General Fund General Contingency Reserve The amount of General Fund reserve required to meet emergency and/or unanticipated expenditures is not readily quantifiable. Rather, the level of this requirement must be established by the City based on the history of the City and the philosophy of "adequate" reserve coverage. The City’s fund balance policy states this amount should be 10-15% of the subsequent year’s General Fund budgeted expenditures, computed as follows: General Contingency Reserve December 31, Description20142015 Ensuing year's budget$5,401,999$5,648,560 Reserve amount @ 15%$810,000$847,000 18 City of Oak Park Heights, Minnesota Audit Management Letter General Fund General Fund Balance Summary In summary, the fund balance of the General Fund at December 31, 2015, was as follows: General Fund Balance Constraint December 31, 20142015 Nonspendable: Prepaid items$80,806$57,602 Restricted: Small Cities Grant - 54,188 Assigned for: Employee benefits159,000165,000 Unassigned: Cash flow reserve2,293,0002,370,000 General contingency reserve810,000847,000 Snow Plow reserve - 122,272 Remaining balance560,0011,016,471 Subtotal - unassigned3,663,0014,355,743 Total fund balance$3,902,807$4,632,533 19 City of Oak Park Heights, Minnesota Audit Management Letter Special Revenue Funds S PECIAL R EVENUE F UNDS Special Revenue Funds are a classification of funds to account for revenues (and expenditures related thereto) segregated by City policy, Federal or State statutes for specific purposes. The City maintained three Special Revenue Funds during 2015. Forfeiture and Seizure Fund This fund was established in 1991 to account for property forfeited pursuant to MS 609.531. A summary of the financial activity of this fund from inception is as follows: Prior Years2015Total Revenue: Intergovernmental $9,825$ - $9,825 Earnings on investments16,3669916,465 Reimbursements8,601 - 8,601 Confiscated property179,5382,655182,193 Sale of municipal property5,046 - 5,046 Transfer from General Fund - 3,0003,000 Total revenue$219,376$5,754$225,130 Expenditures: Public safety: Materials and supplies$76,604$9,316$85,920 Contractual services28,35264628,998 Capital outlay101,116 - 101,116 Total expenditures$206,072$9,962216,034 Fund balance - December 31, 2015$9,096 The use of these funds is restricted by MS 609.531 subd. 5 to "supplement the agency's operating fund or similar fund for use in law enforcement." 20 City of Oak Park Heights, Minnesota Audit Management Letter Special Revenue Funds Economic Development Fund This fund was established in 1998 to account for the activity of the Oak Park Heights Economic Development Authority. A summary of the financial activity of this fund is as follows: Prior Years2015Total Revenue: Earnings on investments$35,989$232$36,221 Interfund loan interest1,113 - 1,113 Refunds and reimbursements2,5311,0013,532 Sale of municipal property76 - 76 Transfer from Capital Revolving Fund410,000 - 410,000 Total revenue$449,709$1,233450,942 Expenditures: Community development: Materials and supplies$645$ - 645 Contractual services45,914 - 45,914 Interfund loan interest70,000 - 70,000 Capital outlay290,018 - 290,018 Transfer to Capital Revolving Fund11,113 - 11,113 Total expenditures$417,690$0417,690 Fund balance - December 31, 2015$33,252 During 1998, the City purchased the Bell property and demolished the building in 1999. In prior years, this fund had a deficit that was funded by a $260,000 interfund loan from the Capital Revolving Fund. This fund did not have the resources to repay the interfund loan. Therefore, the interfund loan was forgiven. If a sale of the Bell property occurs, the proceeds should be receipted in the Capital Revolving Fund. During 2010, the City purchased property on Osgood Avenue, with the intent to resell the property. The purchase was funded by a $150,000 transfer from the Capital Revolving Fund. 21 City of Oak Park Heights, Minnesota Audit Management Letter Special Revenue Funds This was not a loan from the Capital Revolving Fund, but the intent is to transfer back sales proceeds to the Capital Revolving Fund once the property is sold. TIF District #1 Fund This fund was established in 2012 to account for Tax Increment District 1-1 (Oakgreen Commons). A summary of the financial activity of this fund from inception is as follows: Prior Years2015Total Revenue: Tax increment$258,627$184,251$442,878 Investment income289339628 Transfer in from TIF #25,049 - 5,049 Total revenue$263,965$184,590448,555 Expenditures: General government: TIF note payment$212,770$148,109360,879 Other 1,335 - 1,335 Total expenditures$214,105$148,109362,214 Fund balance - December 31, 2015$86,341 The City issued a TIF Note in the principal sum of $1,200,000. The TIF Note is payable solely from “available” tax increment revenue. Available tax increment revenue is an amount equal to 80% of tax increment revenue received by the City. The City has no obligation on the note after February 21, 2026. 22 City of Oak Park Heights, Minnesota Audit Management Letter Special Revenue Funds TIF District #2 Fund This fund was established in 2014. A summary of the financial activity is as follows: Prior Years2015Total Revenue: Investment income$12$13$25 Refunds and reimbursements - 1,0001,000 Total revenue$12$1,0131,025 Expenditures: Land purchase$341,710$ - 341,710 Other 30,51929,79060,309 Transfer to TIF #15,049 - 5,049 Total expenditures$377,278$29,790407,068 Fund balance - December 31, 2015($406,043) The fund deficit was financed by an internal loan from the General Fund. 23 City of Oak Park Heights, Minnesota Audit Management Letter Debt Service Funds D EBT S ERVICE F UNDS Debt Service Funds are a type of governmental fund to account for the accumulation of resources for the payment of interest and principal on debt (other than Enterprise Fund debt). The City maintained three Debt Service Funds during 2015. 24 City of Oak Park Heights, Minnesota Audit Management Letter Debt Service Funds Capital Improvement Bonds of 2008/2012A The bond was issued to finance construction of City Hall. The repayment of the bond issue is being funded by property tax levies. Taxes for 2009-2011 were levied in the Debt Service Fund. A $410,000 property tax was levied in the General Fund for 2013 and was transferred into the Debt Service Fund. In 2012, the Crossover Refunding Bonds of 2012A were issued to refund the 2008 Bonds on December 15, 2016. The refunding resulted in a debt service savings of $404,000. A schedule of actual and projected tax levies (per the bond resolution) and debt payments are as follows: Cash and CurrentTotalCash and Current Assets BalancePropertyBondInvestmentProjectedDebtAssets Balance YearJanuary 1TaxesProceedsInterestReceiptsPaymentsDecember 31 2008$ - $ - $242,303$7,457$249,760$122,513$127,247 2009127,247336,292 - 3,250339,542380,02586,764 201086,764392,805 - 1,656394,461391,65089,575 201189,575400,902 - 1,556402,458392,52599,508 201299,508400,0005,191,2835,1975,596,480403,0305,292,958 20135,292,958410,000 - (7,988)402,012521,6775,173,293 20145,173,293420,000 - 45,662465,662526,7765,112,179 20155,112,179430,000 - 30,720460,720535,1755,037,724 20165,037,724440,000 - 23,097463,0975,402,75898,063 201798,063410,000 - 701410,701409,75899,006 201899,006420,000 - 722420,722418,658101,070 2019101,070430,000 - 747430,747432,25899,559 202099,559440,000 - 762440,762445,45894,863 202194,863460,000 - 761460,761458,25897,366 202297,366475,000 - 790475,790470,658102,498 2023102,498490,000 - 841490,841492,658100,681 2024100,681505,000 - 860505,860509,05897,483 202597,483520,000 - 880520,880539,95878,405 202678,405535,000 - 815535,815560,05854,162 202754,162550,000 - 714550,714569,29435,582 202835,582575,000 - 659575,659597,57613,665 Total$9,039,999$5,433,586$119,859$14,593,444$14,579,779 Assumptions Property tax collection rate.....................................100% Investment interest rate...........................................0.50% Negative interest charged to funds?.....................no 25 City of Oak Park Heights, Minnesota Audit Management Letter Debt Service Funds Capital Improvement Bonds of 2009 The bond was issued as additional financing for construction of City Hall. The repayment of the bond is being funded by property tax levies. Taxes are levied in the General Fund and then transferred into the Debt Service Fund. A schedule of actual and projected tax levies (per the bond resolution) and debt payments are as follows: Cash and CurrentTransfers/TotalCash and Current Assets BalancePropertyBondInvestmentProjectedDebtAssets Balance YearJanuary 1TaxesProceedsInterestReceiptsPaymentsDecember 31 2009$ - $ - $21,582$1,357$22,939$7,588$15,351 201015,351122,000 - 720122,720130,3507,721 20117,721134,000 - 492134,492129,15013,063 201213,063136,000 - 460136,460132,65016,873 201316,873138,000 - 133138,133135,76019,246 201419,246139,000 - 586139,586138,56020,272 201520,272140,000 - 327140,327140,85819,741 201619,741142,000 - 389142,389142,67819,452 201719,452143,000 - 397143,397144,11418,735 201818,735144,000 - 397144,397150,08413,048 201913,048145,000 - 350145,350155,3263,072 Total$1,383,000$21,582$5,608$1,410,190$1,407,118 Assumptions Property tax collection rate................................100% Investment interest rate....................................1.00% Negative interest charged to funds?..................no 26 City of Oak Park Heights, Minnesota Audit Management Letter Debt Service Funds Capital Improvement Bonds of 2014A The bond was issued as financing for the 2015 street reconstruction project. The repayment of the bond is being funded by property tax levies and special assessments. Taxes are levied in the General Fund and then transferred into the Debt Service Fund. Assessments are levied in the Debt Service Fund. The data provided by the City’s fiscal advisor regarding the proposed manner of repayment for the Bonds from special assessments contained miscalculations which will lead to a shortage in the funding necessary to pay the bonds. A settlement was reached to which the City’s fiscal advisor paid the City $180,000 to cover a portion of that deficit. A schedule of actual and projected tax and assessment levies (per the bond resolution) and debt payments are as follows: City of Oak Park Heights, Minnesota Projection of Cashflow Capital Improvement Bonds of 2014A Bond Cash and CurrentTransfers/ProceedsTotalCash and Current Assets BalancePropertySpecialand OtherInvestmentProjectedDebtAssets Balance YearJanuary 1TaxesAssessmentsReceiptsInterestReceiptsPaymentsDecember 31 2014$ - $ - $218,041$87,054$2,021$307,116$45,859$261,257 2015261,257411,314381,071359,0122,1651,153,562250,1001,164,719 20161,164,719139,000135,145 - 492274,637481,800957,556 2017957,556141,000118,419 - 460259,879473,800743,635 2018743,635142,000114,424 - 133256,557465,800534,392 2019534,392144,000110,430 - 586255,016432,800356,608 2020356,608145,000106,436 - 327251,763425,300183,071 2021183,071147,000102,442 - 327249,769392,80040,040 202240,040149,00098,448 - 608248,056385,800(97,704) 2023(97,704)150,00094,453 - - 244,453353,800(207,051) 2024(207,051)152,00090,459 - - 242,459344,050(308,642) 2025(308,642)153,00037,760 - - 190,760319,300(437,182) Total$1,873,314$1,607,528$446,066$7,119$3,934,027$4,371,209 Assumptions Special assessment collection rate....................100% Property tax collection rate................................100% Investment interest rate....................................1.00% Negative interest charged to funds?..................no 27 City of Oak Park Heights, Minnesota Audit Management Letter Capital Project Funds C APITAL P ROJECT F UNDS A summary of the financial activity of the Capital Project Funds for the year ended December 31, 2015 is as follows: 28 City of Oak Park Heights, Minnesota Audit Management Letter Capital Project Funds Budgeted Projects and Equipment Revolving Fund The Budgeted Projects and Equipment Revolving Fund (formerly Capital Improvements Fund) was established in 1978 to account for monies set aside for various capital improvements. This fund is budgeted annually by the City Council in conjunction with the City's budget process. As part of such process, the City allocates the monies in this fund to specific projects and/or programs. Such allocation/designations were as follows at December 31, 2015: FundRevenuesFund BalanceandBalance Purpose12/31/14TransfersExpenditures12/31/15 1Sealcoat/crack seal$181,602$ - $79,109$102,493 2Mill and overlay - 100,000 - 100,000 3Fire station - 100,000 - 100,000 4Municipal building256,61215,000 - 271,612 5Recreation: 6 Park and trail improvements174,57635,000 - 209,576 7 Trail maintenance84,30010,000 - 94,300 8 Park building maintenance117,00050,000 - 167,000 9 Brekke Park memorial fund394 - - 394 10Computers56,28621,70020,32057,666 11Document imaging - - - - 12Vehicles: 13 Police125,88239,375 - 165,257 14 Public works152,91664,66727,684189,899 15 Building official238 - - 238 16Furniture and equipment: 17 General - - - - 18 Building inspections - - - - 19 Police 346 - - 346 20Trees86,3735,95019,84072,483 21Emerald ash borer120,000 - - 120,000 22Public works equipment215,216113,000 - 328,216 23Police radio equipment38,0803,000 - 41,080 24Police computer equipment15,1265,000 - 20,126 25Backup software7,5007,5005,6129,388 26Coalition of utility cities16,000 - - 16,000 27Civil defense16,000 - - 16,000 28Meter change out92,20026,100 - 118,300 29Generator replacement7,0003,500 - 10,500 30Unallocated198,22513,898 - 212,123 Totals$1,961,872$613,690$152,565$2,422,997 29 City of Oak Park Heights, Minnesota Audit Management Letter Enterprise Funds E NTERPRISE F UNDS Enterprise funds account for water, sanitary sewer and storm sewer operations. Water Utility Fund A chart of income from operations for the past seven years is as follows: $900,000 Water Operating Revenue & Expense $800,000 $700,000 $600,000 Depreciation Transfer Out $500,000 All Other Expenses Contractual Services Personal Services $400,000 Operating Revenue $300,000 $200,000 $100,000 $- 2009201020112012201320142015 30 City of Oak Park Heights, Minnesota Audit Management Letter Enterprise Funds Sewer Utility Fund A chart of income from operations for the past seven years is as follows: $1,000,000 Sewer Operating Revenue & Expense $900,000 $800,000 $700,000 Depreciation $600,000 Transfer Out Personal Services $500,000 All Other Expenses MCES Operating Revenue $400,000 $300,000 $200,000 $100,000 $- 2009201020112012201320142015 31 City of Oak Park Heights, Minnesota Audit Management Letter Enterprise Funds The City’s water and sewer rates for the past seven years are as follows: Monthly RateQuarterly Rate EffectiveEffectiveEffectiveEffectiveEffectiveEffectiveEffectiveEffective Type of Charge01/01/0807/01/0901/01/1001/01/1101/01/1201/01/1301/01/1401/01/15 Water: Base fee$24.35$28.31$28.31$29.91$30.70$30.70$30.70$38.19 Charge per 1,000 gallons for: Usage between 15,000 and 50,000 gallons$1.62$1.96$1.96$2.48$2.55$2.55$2.55$3.05 Usage between 50,000 and 99,000 gallons$2.22$2.68$2.68$2.97$3.05$3.05$3.05$3.55 Usage between 99,000 and 200,000 gallons$2.67$3.23$3.23$3.81$3.92$3.92$3.92$4.42 Usage in excess of 200,000 gallons$2.67$3.23$3.91$4.61$4.74$4.74$4.74$5.24 Sewer: Base fee$49.95$54.28$56.99$60.41$62.10$66.00$66.00$66.00 Charge per 1,000 gallons for: Usage between 15,000 and 50,000 gallons$3.40$3.70$4.07$4.31$4.43$4.60$4.80$4.90 Usage in excess of 50,000 gallons$3.40$3.70$4.50$4.77$4.90$4.90$5.20$5.30 32 City of Oak Park Heights, Minnesota Audit Management Letter Enterprise Funds Storm Sewer Utility Fund The City created the stormwater utility during 1999. A monthly fee (effective October 1, 1999) was established at $1 per household and $10 per acre for commercial properties. The fee for vacant residential property is 50 cents per month and undeveloped commercial property is $1.50 an acre per month. A chart of income from operation for the past seven years is as follows: $100,000 Storm Sewer Operating Revenue & Expense $90,000 $80,000 $70,000 $60,000 Transfer Out All Other Expenses Contractual Services $50,000 Personal Services Operating Revenue $40,000 $30,000 $20,000 $10,000 $- 2009201020112012201320142015 33 City of Oak Park Heights, Minnesota Audit Management Letter Communication With Those Charged With Governance C OMMUNICATION W ITH T HOSE C HARGED W ITH G OVERNANCE We have audited the financial statements of the governmental activities, the business- type activities, each major fund, and the aggregate remaining fund information of the City of Oak Park Heights, Minnesota (the City) for the year ended December 31, 2015. Professional standards require that we provide you with information about our responsibilities under generally accepted auditing standards and the standards applicable to financial audits contained in Government Auditing Standards, as well as certain information related to the planned scope and timing of our audit. We have communicated such information in our letter to you dated December 29, 2015. Professional standards also require that we communicate to you the following information related to our audit. Qualitative Aspects of Accounting Practices Management is responsible for the selection and use of appropriate accounting policies. The significant accounting policies used by the City are described in Note 1 to the financial statements. As described in Notes 7 and 18 to the financial statements, the City implemented GASB Statement No. 68, Accounting and Financial Reporting for Pensions – an Amendment of GASB Statement No. 27 for the year ended December 31, 2015. The most significant effect of this standard is that it required the City to record its proportionate share of the net pension liability of defined benefit pension plans, as well as related deferred inflows and outflows of resources. These items are only reported on full-accrual financial statements. The liability was initially recorded by restating beginning net position. It should be noted that the City’s contribution requirements to pension plans have not changed as a result of this standard. We noted no transactions entered into by the City during the year for which there is a lack of authoritative guidance or consensus. All significant transactions have been recognized in the financial statements in the proper period. 34 City of Oak Park Heights, Minnesota Audit Management Letter Communication With Those Charged With Governance Accounting estimates are an integral part of the financial statements prepared by management and are based on management’s knowledge and experience about past and current events and assumptions about future events. Certain accounting estimates are particularly sensitive because of their significance to the financial statements and because of the possibility that future events affecting them may differ significantly from those expected. The most sensitive estimates affecting the financial statements were management’s estimation of 1) the net pension liability and pension related deferred inflows and outflows of resources and, 2) the revenue recognition of MNDOT assistance relating to the bridge project. We evaluated the key factors and assumptions used to develop these estimates in determining that they are reasonable in relation to the financial statements taken as a whole. The pension estimates are based on actuarial studies. The City has several agreements with the State that details the financial assistance to be provided to the City of Oak Park Heights relating to the Bridge Project. The revenue recognition of this financial assistance has been delayed pending receipt of revenue. Certain financial statement disclosures are particularly sensitive because of their significance to financial statement users. The most sensitive disclosure affecting the financial statements pertained to the City’s commitment to relocate portions of its utility infrastructure along Highway 36 (Note 10A) and Note 7 – Defined Benefit Pension Plans and Note 18 – Change in Accounting Principle. The disclosures in the financial statements are neutral, consistent, and clear. Difficulties Encountered in Performing the Audit We encountered no difficulties in dealing with management in performing and completing our audit. 35 City of Oak Park Heights, Minnesota Audit Management Letter Communication With Those Charged With Governance Corrected and Uncorrected Misstatements Professional standards require us to accumulate all known and likely misstatements identified during the audit, other than those that are clearly trivial, and communicate them to the appropriate level of management. There were no uncorrected misstatements that have an effect on our opinion on the financial statements. Disagreements with Management For purposes of this letter, a disagreement with management is a financial accounting, reporting, or auditing matter, whether or not resolved to our satisfaction, that could be significant to the financial statements or the auditor’s report. We are pleased to report that no such disagreements arose during the course of our audit. Management Representations We have requested certain representations from management that are included in the management representation letter dated April 19, 2016. Management Consultations with Other Independent Accountants In some cases, management may decide to consult with other accountants about auditing and accounting matters, similar to obtaining a “second opinion” on certain situations. If a consultation involves application of an accounting principle to the governmental unit’s financial statements or a determination of the type of auditor’s opinion that may be expressed on those statements, our professional standards require the consulting accountant to check with us to determine that the consultant has all the relevant facts. To our knowledge, there were no such consultations with other accountants. 36 City of Oak Park Heights, Minnesota Audit Management Letter Communication With Those Charged With Governance Other Audit Findings or Issues We generally discuss a variety of matters, including the application of accounting principles and auditing standards, with management each year prior to retention as the governmental unit’s auditors. However, these discussions occurred in the normal course of our professional relationship and our responses were not a condition to our retention. Other Information in Documents Containing Audited Financial Statements With respect to the supplementary information accompanying the financial statements, we made certain inquiries of management and evaluated the form, content, and methods of preparing the information to determine that the information complies with accounting principles generally accepted in the United States of America, the method of preparing it has not changed from the prior period, and the information is appropriate and complete in relation to our audit of the financial statements. We compared and reconciled the supplementary information to the underlying accounting records used to prepare the financial statements or to the financial statements themselves. Closing This information is intended solely for the information and use of the City Council and Management of the City of Oak Park Heights, Minnesota and is not intended to be, and should not be, used by anyone other than these specified parties. 37