Loading...
HomeMy WebLinkAbout06-24-13 CC Work Session AgendaPCITY OF SHOREWOOD CITY COUNCIL WORK SESSION MONDAY, JUNE 24, 2013 AGENDA 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call B. Review Agenda 5755 COUNTRY CLUB ROAD COUNCIL CHAMBERS 6:30 P.M. Mayor Zerby Hotvet Siakel Sundberg Woodruff 2. 2012 AUDIT PRESENTATION BY ABDO, EICK AND MEYERS, LLP 3. ADJOURN Finance Director's memo CITY OF SHOREWOOD SHOREWOOD, MINNESOTA MANAGEMENT LETTER FOR THE YEAR ENDED DECEMBER 31, 2012 IA 4 It CRAFT At3ll0 EICK MEYEITLIS LLP Certified Public Accountants & Consultants CITY OF SHOREWOOD SHOREWOOD, MINNESOTA MANAGEMENT LETTER FOR THE YEAR ENDED DECEMBER 31, 2012 PA Nk" FmAil I m I . u ABDO M�, _ � EICK & J t C 1 0 HEYE1 �l SUP Certified Public Accountants & Consultants 5201 Eden Avenue Suite 250 Edina, MN 55436 Management, Honorable Mayor and City Council City of Shorewood, Minnesota 1►1�1�1�1�7:r1�1 We have audited the accompanying financial statements of the governmental activities, the business -type activities, each major fund, and the aggregate remaining fund information of the City of Shorewood, Minnesota (the City) for the year ended December 31, 2012 and have issued our report thereon dated NEED DATE. Professional standards also require that we communicate to you the following information related to our audit. Our Responsibility Under Auditing Standards Generally Accepted in the United States of America As stated in our engagement letter, our responsibility, as described by professional standards, is to plan and perform our audit to obtain reasonable, but not absolute, assurance that the financial statements are free of material misstatement and are fairly presented in accordance with accounting principles generally accepted in the United States of America. Because an audit is designed to provide reasonable, but not absolute, assurance and because we did not perform a detailed examination of all transactions, there is a risk that material errors, fraud or illegal acts may exist and not be detected by us_ Our responsibility is to plan and perform the audit to obtain reasonable, but not absolute, assurance that the financial statements are free of material misstatement. As part of our audit, we considered the internal control over financial reporting of the City. Such considerations were solely for the purpose of determining our audit procedures and not to provide any assurance concerning such internal control over financial reporting. We are responsible for communicating significant matters related to the audit that are, in our professional judgment, relevant to your responsibilities in overseeing the financial reporting process. However, we are not required to design procedures specifically to identify such matters. Significant Audit Findings In planning and performing our audit, we considered the City's internal control over financial reporting as a basis for designing our auditing procedures for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City's internal control over financial reporting. Accordingly, we do not express an opinion on the effectiveness of the City's internal control over financial reporting. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct misstatements on a timely basis. A material weakness is a deficiency, or combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity's financial statements will not be prevented, or detected and corrected on a timely basis. Our consideration of internal control over financial reporting was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control over financial reporting that might be deficiencies, significant deficiencies, or material weaknesses. We consider the deficiency presented as finding 2012 -1 described on the following page to be a material weakness. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com City of Shorewood NEED DATE Page 2 2012 -1 Audit adjustments Condition: During our audit, adjustments were needed to adjust coding and reclassify amounts to correct fund balance, payables, and unearned revenue. Criteria: Adjustments were needed to correct year end balances. Cause: The City has not prepared a year -end trial balance reflecting all necessary accounting entries Effect: This indicates that a misstatement may occur and not be detected by the City's system of internal control over financial reporting. Some financial information presented during the year may not have been accurate. The audit firm cannot serve as a compensating control over this deficiency. Recommendation: We recommend that management review each journal entry, obtain an understanding of why the entry was necessary and modify current procedures to ensure that future corrections are not needed. Management response: Significant progress was made this year with the removal of the cash and investments finding from last year. Staff prepared many of the year end closing entries, but will continue to look for assistance from the auditors for the GASB government -wide accrual entries. With the improved internal processes already in place and additional processes suggested through this year's audit, staff believes that all necessary journal entries will be made prior to the audit for successive years. r r Compliance . As part of obtaining reasonable assurance about w ether the P financial statements are free of material misstatement, we performed tests of compliance with certain provisions of Minnesota statutes. However, the objective of our tests was not to provide an opinion on compliance with such provisions. We noted no instances of noncompliance with Minnesota statutes. Summary of Prior Year Findings 2011 -1 Cash and investment reconciliations Condition: During our audit we noted bank and investment reconciliations were not fully completed for all of 2011. As a result adjustments were needed to correct the cash and investment balance such as correction of duplicate receipts, adjust interest earnings, adjust market value, record cash with fiscal agent and multiple other miscellaneous corrections. Criteria: The financial statements are the responsibility of the City's management. The accounting records should reflect timely and accurate information for report to management and the City Council. The reconciliation bank and investment statements is an important component of internal controls. Current year status: Cash and investment reconciliations were completed for all of 2012. Planned Scope and Timing of the Audit We performed the audit according to the planned scope and timing previously communicated to you. 952.835.9090 • Fax 952.835.3261 www.aemepas.com City of Shorewood NEED DATE Page 3 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. The requirements of GASB statements No. 63 and 65 were adopted for the year ended December 31, 2012. 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. 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 estimate affecting the financial statements was capital asset basis and depreciation. Management's estimate of these accounting estimates is based on estimated or actual historical cost and the estimated useful lives of capital assets. We evaluated the key factors and assumptions used to develop these accounting estimates in determining that it is reasonable in relation to the financial statements taken as a whole. The disclosures in the financial statements are neutral, consistent, and clear. Certain financial statement disclosures are particularly sensitive because of their significance to financial statement users. Difficulties Encountered in Performing the Audit We encountered no significant difficulties in dealing with management in performing and completing our audit. Corrected and Uncorrected Misstatements P Professional standards require us to accumulate all known and likely misstatements identified during the audit, other than those that are trivial, and communicate them to the appropriate level of management. Management has corrected all such misstatements. We proposed journal entries that we consider to be audit entries or corrections of management decisions. They related to adjustments needed to correct beginning fund balance, payables and unearned revenue. We assisted in preparing a number of year end accounting entries. These were necessary to adjust the City's records at year end to correct ending balances. The City should establish more detailed processes and procedures to reduce the total number of audit and accounting entries. The City will receive better and timelier information if the preparation of entries is completed internally. Disagreements with Management For purposes of this letter, professional standards define a disagreement with management as 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 NEED DATE. 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. 952.835.9090 • Fax 952.835.3261 www.aemepas.com City of Shorewood NEED DATE Page 4 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 City's auditors. However, these discussions occurred in the normal course of our professional relationship and our responses were not a condition to our retention. Financial Position and Results of Operations Our principal observations and recommendations are summarized below. These recommendations resulted from our observations made in connection with our audit of the City's financial statements for the year ended December 31, 2012. General Fund The General fund is used to account for resources traditionally associated with government, which are not required legally or by sound principal management to be accounted for in another fund. The General fund balance increased $136,241 from 2011. The City Council budgeted for the use of $87,435 of resources. The fund balance of $3,624,468 is 68 percent of the 2013 budgeted expenditures and transfers. We recommend the fund balance be maintained at a level sufficient to fund operations until the major revenue sources are received in June. We feel a reserve of approximately 50 percent of planned expenditures and transfers out is adequate to meet working capital and small emergency needs. The purposes and benefits of a strong fund balance are as follows: • Expenditures are incurred somewhat evenly throughout the year. However, property tax and state aid revenues are not received until the second half of the year. An adequate fund balance will provide the cash flow required to finance the governmental fund expenditures. 11 11 • The City is vulnerable to legislative actions at the State and Federal level. The State continually adjusts the local government aid formulas. We also have seen the State mandate levy limits for cities over 2,500 in population. An adequate fund balance will provide a temporary buffer against those aid adjustments or levy limits. • Expenditures not anticipated at the time the annual budget was adopted may need immediate City Council action. These would include capital outlay, replacement, lawsuits and other items. An adequate fund balance will provide the financing needed for such expenditures. • A strong fund balance will assist the City in maintaining, improving or obtaining its bond rating. The result will be better interest rates in future bond sales. 952.835.9090 • Fax 952.835.3261 www.aemepas.com City of Shorewood NEED DATE Page 5 A table summarizing the General fund balance in relation to budget follows: $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Fund Balance as a Percent of Next Year's Budget $5,488,562 $5,375,404 $5,268,884 $5,223,830 $5,367,218 68% 66 670 % 68% $- 2008 2009 2010 2011 2012 2013 +Fund Balance f Budget We have compiled a peer group average derived from information available on the website of the Office of the State Auditor for Cities of the 4th class which have populations of 2,500- 10,000. In 2010 and 2011, the average General fund balance as a percentage of expenditures was 67 percent and 69, percent, respectively. Based on comparison to the peer groups, the City's fund balance in consistent with the average. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com Percent General of Fund Fund Balance Budget Fund Balance to Year December 31 Year Budget Budget 2008 $ 3,708,109 2009 $ 5,488,562 68 % 2009 3,555,724 2010 5,375,404 66 2010 3,526,992 2011 5,268,884 67 2011 3,488,227 2012 5,223,830 67 2012 3,624,468 2013 5,367,218 68 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Fund Balance as a Percent of Next Year's Budget $5,488,562 $5,375,404 $5,268,884 $5,223,830 $5,367,218 68% 66 670 % 68% $- 2008 2009 2010 2011 2012 2013 +Fund Balance f Budget We have compiled a peer group average derived from information available on the website of the Office of the State Auditor for Cities of the 4th class which have populations of 2,500- 10,000. In 2010 and 2011, the average General fund balance as a percentage of expenditures was 67 percent and 69, percent, respectively. Based on comparison to the peer groups, the City's fund balance in consistent with the average. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com The 2012 operations are summarized as follows: Revenues Expenditures Excess of revenues over expenditures Other financing sources (uses) Transfers in Transfers out Total other financing sources (uses) Net change in fund balances City of Shorewood NEED DATE Page 6 Final Budgeted Actual Variance with Amounts Amounts Final Budget $ 5,096,395 $ 5,306,395 $ 210,000 4,316,030 4,262,354 53,676 780,365 1,044, 041 263,676 40,000 - (40,000) (907,800) (907,800) - (867,800) (907,800) (40,000) (87,435) 136,241 223,676 Fund balances, January 1 3,488,227 3,488,227 - Fund balances, December 31 $ 3,400,792 $ 3,624,468 $ 223,676 • The General fund balance increased $136,241 during the year ended December 31, 2012. More detailed information of the variances is as follows: • Revenues were $210,000 over budget. The largest revenue variance was in miscellaneous revenues over budget by $98,924. The next largest revenue variance was in licenses and permits over budget by $65,887. • Expenditures were $53,676 under budget. General government was over budget by $93,791. Public works was under budget by $105,586. 952.835.9090 • Fax 952.835.3261 www.aemepas.com A more detailed comparison for the last five years General fund revenues and transfers as follows: Source 2008 2009 2010 2011 2012 Property taxes $ 4,582,602 $ 4,703,368 $ 4,717,204 $ 4,787,195 $ 4,783,939 Licenses and permits 195,419 127,883 154,113 174,119 175,087 Intergovernmental 78,155 66,411 69,134 72,968 76,102 Charges for services 50,753 41,649 42,882 30,741 61,611 Fines and forfeitures 53,369 52,968 55,806 52,635 66,230 Special assessments - - 333 - - Interest on investment, 161,862 58,627 46,767 20,021 25,602 Miscellaneous 14,675 24,131 39,803 109,327 117,824 Transfers in 40,000 40,000 33,464 40,000 - Total revenues and City of Shorewood NEED DATE Page 7 Percent of Per Total Capita 90.2 % $ 654 3.3 24 1.4 10 1.2 8 1.2 9 0.5 4 2.2 16 transfers in $ 5,176,835 $ 5,115,037 $ 51159,506 $ 51287,006 $ 51306,395 100.0 % $ 725 The sources of revenues and transfers from the past five years are presented graphically below. Property taxes have been excluded from the graph to better illustrate the fluctuation in the General funds other revenue sources due to property taxes consisting of 90 percent in 2012. I $250,000 $200,000 $150,000 $100,000 $50,000 2008 2009 2010 2011 2012 t Licenses and permits f Charges for services f Fines and forfeitures -0- Interest on investments -I--Other 952.835.9090 • Fax 952.835.3261 www.aemcpas.com City of Shorewood NEED DATE Page 8 A more detailed comparison for the last five years General fund expenditures and transfers as follows: Percent Peer Group of Per Per Program 2008 2009 2010 2011 2012 Total Capita Capita General government $ 1,430,354 $ 1,384,712 $ 1,147,198 $ 1,306,948 $ 1,282,580 24.7 % $ 175 $ 125 Public safety 1,352,254 1,392,139 1,392,923 1,460,664 1,445,149 28.0 198 222 Public works 760,272 669,578 859,069 866,413 823,234 15.9 113 112 Culture and recreation 229,252 267,407 263,928 256,601 205,542 4.0 28 56 Capital outlay 565,213 528,388 519,792 504,736 505,849 9.8 69 26 Debt service 7,890 5,425 2,959 - - - - - Transfers out 885,000 1,019,773 1,002,369 930,409 907,800 17.6 124 Total expenditures and transfers out $ 5,230,235 $ 5,267,422 $ 5,188,238 $ 5,325,771 $ 5,170,154 100.0 % $ 707 $ 541 The above chart compares the amount the City spends per capita, in comparison to a peer group. We have compiled peer group average fund balance information from fourth class cities (populations of 2,500 to 10,000). The peer group average is derived from information available on the website of the Office of the State Auditor. The functional expenditures and transfers from the past five years are presented graphically as follows: i� Tr�r� r� -1 r mi $1,600,000 $1,400,000 $1,200,000 $1,000,000 $ 800,000 $600,000 $400,000 $200,000 2008 2009 2010 2011 2012 t General government f Public safety f Public works —0—Transfers out �� Other 952.835.9090 • Fax 952.835.3261 www.aemcpas.com City of Shorewood NEED DATE Page 9 Debt Service Funds 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). Debt Service funds may have one or a combination of the following revenue sources pledged to retire debt as follows: • Property taxes - Primarily for general City benefit projects such as parks and municipal buildings. Property taxes may also be used to fund special assessment bonds which are not fully assessed. • Tax increments - Pledged exclusively for tax increment /economic development districts. • Capitalized interest portion of bond proceeds - After the sale of bonds, the project may not produce revenue (tax increments or special assessments) for a period of one to two years. Bonds are issued with this timing difference considered in the form of capitalized interest. • Special assessments - Charges to benefited properties for various improvements In addition to the above pledged assets, other funding sources may be received by Debt Service funds as follows: • Residual project proceeds from the related capital projects fund • Investment earnings • State or Federal grants 4]k/-3 IFT • Transfers from other funds The following summarizes the assets of each Debt Service fund with the bonds payable at year end: Total 952.835.9090 • Fax 952.835.3261 www.aemcpas.com $ 19,925 $ 8,394,925 $ 9,515,000 Final Cash and Total Bonds Maturity Debt Description Investments Assets Outstanding Date 2007A Public Safety Building $ 13,097 $ 3,493,097 $ 3,480,000 2023 2007B Public Safety Building 2,854 3,612,854 3,610,000 2023 2007C Public Safety Building 761 1,285,761 1,285,000 2022 2008 Lease Revenue Bond 3,213 3,213 1,140,000 2028 Total 952.835.9090 • Fax 952.835.3261 www.aemcpas.com $ 19,925 $ 8,394,925 $ 9,515,000 City of Shorewood NEED DATE Page 10 Special Revenue Fund Special revenue fund receive revenue from specific sources and expenditures for specific purposes. The City's only special revenue fund is the Southshore Community Center fund. At the end of 2012, the fund had a deficit fund balance of $40,749. We recommend the City put a plan in place to eliminate the deficit. Capital Projects Funds Capital projects funds account for the acquisition of capital assets or construction of major capital projects not being financed by proprietary funds. A summary of year end fund balances for all capital projects funds follows: Fund Major Street Reconstruction Community Infrastructure Nonmaj or Public Facilities Park Capital Improvement Equipment Replacement MSA Construction Trail Construction Technology Total Fund Balances December 31, 2012 2011 $ 1,760,337 $ 1,481,482 1,842,330 1,829,478 - 178,089 168,427 150,958 613,693 521,172 133,937 132,650 (34,576) - - 79,089 Following is some of the significant activity: Street Reconstruction fund • $432,511 of expenditures • $700,000 of transfers in from other funds Equipment Replacement fund • $312,416 of transfers in from other funds • $227,747 of expenditures 952.835.9090 • Fax 952.835.3261 www.aemepas.com Increase (Decrease) 278,855 12,852 (178,089) 17,469 92,521 1,287 (34,576) (79,089) $ 4,484,148 $ 4,372,918 $ (167,625) City of Shorewood NEED DATE Page 11 Enterprise Funds Water Fund The results of the operations and cash position of the Water fund for the past three years are as follows: 2010 2011 2012 Operating revenues Operating expenses Operating income (loss) Nonoperating revenues and connections fees Change in net position Cash and cash equivalents Bonds payable $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 Total Percent Total Percent Total Percent $ 468,889 100 % $ 511,427 100 % $ 612,892 100 % 518,479 111 573,635 112 588,537 96 (49,590) (11) (62,208) (12) 24,355 4 106,382 23 98,671 19 96,186 16 $ 56,792 12—% $ 36,463 7 % $ 120,541 20 % $ 3,751,756 $ 3,837,465 $ 4,045,974 $ 2,915 0 $ 2,675,000 $ 2,500,000 -J Water Fund 2010 2011 2012 ■ Operating revenues ■ Operating expenses The cash balance of the fund remains strong and increased due to cash flows provided by operating activities, which increased from 2011. Operating expenses include depreciation of $272,640 in 2012, which is a noncash expense. The City should continue to monitor operations to ensure charges are sufficient to cover operating expenses, debt service and future projects. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com Sewer Fund The results of the operations and cash position of the Sewer fund for the past three years are as follows: 2010 2011 Operating revenues Operating expenses Operating loss Nonoperating revenues Loss before transfers Transfers in Change in net position Cash and cash equ` ' $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 City of Shorewood NEED DATE Page 12 2012 Total Percent Total Percent Total Percent $ 840,413 100 % $ 818,296 100 % $ 828,490 100 % 980,173 117 1,151,626 141 1,065,926 129 (139,760) (17) (333,330) (41) (237,436) (29) 43,070 5 28,753 4 35,393 4 (96,690) (12) (304,577) (37) (202,043) (25) 60,000 7 - - - - $ (36,690) (5) % $ (304,577) (37) % $ (202,043) (25) % 2010 2011 2012 ■ Operating revenues ■ Operating expenses The cash balance remains strong; however, it has decreased slightly each of the last two years. Cash provided by operations increased from 2011. Operating expenses include depreciation of $220,632 in 2012, which is a noncash expense. The City should continue to monitor operations to ensure charges are sufficient to cover operating expenses, debt service and future projects. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com City of Shorewood NEED DATE Page 13 Recycling Fund The results of the operations and cash position of the Recycling fund for the past three years are as follows $200,000 $180,000 $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 Recycling Fund 2010 2011 2012 Operating revenues Nonoperating revenues f Operating expenses We recommend the City monitor cash flows to ensure sufficient resources to cover expenses. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com 2010 2011 2012 Total Percent Total Percent Total Percent Operating revenues $ 146,002 100 % $ 151,894 100 % $ 157,585 100 % Operating expenses 173,896 119 174,857 115 187,713 119 Operating loss (27,894) (19) (22,963) (15) (30,128) (19) Nonoperating revenues 24,216 17 33,728 22 23,536 15 Change in net position $ (3,678) (2) % $ 10,765 7_% $ (6,592) (4) % Cash and cash equivalents $ 43,390 $ 53,146 $ 44,454 $200,000 $180,000 $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 Recycling Fund 2010 2011 2012 Operating revenues Nonoperating revenues f Operating expenses We recommend the City monitor cash flows to ensure sufficient resources to cover expenses. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com City of Shorewood NEED DATE Page 14 Stormwater Management Utility Fund The results of the operations and cash position of the Stormwater Management Utility fund for the past three years are as follows: 2010 2011 2012 Operating revenues Operating expenses Operating income (loss) Nonoperating revenues Change in net position Cash and cash equivalents $ 700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 Total Percent Total Percent Total Percent $ 198,470 100 % $ 195,970 100 % $ 193,931 100 % 131,107 66 233,035 119 273,846 141 67,363 34 (37,065) (19) (79,915) (41) 10,962 6 3,982 2 1,412 1 $ 78,325 39 % $ (33,083) (17) % $ (78,503) (40) % $ 665,518 $ 214,142 $ 82,479 Storrnwater Management Utility Fund 2010 2011 2012 ■ Operating revenues ■ Operating expenses ■ Cash and cash equivalents The cash balance in the fund decreased $131,663 due to acquisition of capital assets of $110,901, cash used by operating activities of $21,831 and interest received on investments of $1,069. We recommend the City monitor cash flows to ensure sufficient resources to cover expenses. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com City of Shorewood NEED DATE Page 15 Ratio Analysis The following captures a few ratios from the City's financial statements that give some additional information for trend and peer group analysis. The peer group average is derived from information we requested and compiled from the Office of the State Auditor for Cities of the 4th class (population 2,500 — 10,000). The majority of these ratios facilitate the use of economic resources focus and accrual basis of accounting at the government -wide level. A combination of liquidity (ability to pay its most immediate obligations), solvency (ability to pay its long -term obligations), funding (comparison of financial amounts and economic indicators to measure changes in financial capacity over time) and common -size (comparison of financial data with other cities) ratios are shown below. Ratio Calculation Source 2009 2010 2011 2012 Debt to assets Total liabilities /total assets Government -wide 35% 31% 68% 34% 34% Debt service coverage Net cash provided by operations/ Enterprise funds 125% 108% enterprise fund debt payments 261% 90% Debt per capita Bonded debt/population Government -wide $ 2,171 $ 1,876 Taxes per capita Tax revenues /population Current expenditures per capita Governmental fund current Capital expenditures per capita Capital assets % left to depreciate - Governmental Capital assets % left to depreciate - Business -type Represents the City of Shorewc Peer Group ratio 952.835.9090 • Fax 952.835.3261 www.aemepas.com expenditures / population Governmental fund capital outlay / population Net capital assets/ gross capital assets Net capital assets/ gross capital assets od $ 2,713 $ 2,774 Government -wide $ 626 -"649 $ 399 $ 458 Governmental funds $ 498 $ 512 $ 625 $ 624 Governmental funds $ 258 $ 284 $ 310 $ 265 Government -wide 31% 31% 68% 68% Government -wide 49% 47% 67% 68% 30% 29% 33% N/A 91% 144% 106% N/A $ 1,758 $ 2,826 $ 648 $ 500 $ 544 $ 640 $ 199 $ 229 29% 64% 46% 65% $ 1,643 N/A $ 651 N/A $ 532 N/A $ 168 N/A 27% N/A 44% N/A City of Shorewood NEED DATE Page 16 Debt -to- Assets Leverage Ratio (Solvency Ratio) The debt -to- assets leverage ratio is a comparison of a City's total liabilities to its total assets or the percentage of total assets that are provided by creditors. It indicates the degree to which the City's assets are financed through borrowings and other long -term obligations (i.e. a ratio of 50 percent would indicate half of the assets are financed with outstanding debt). Debt Service Coverage Ratio (Solvency Ratio) The debt coverage ratio is a comparison of cash generated by operations to total debt service payments (principal and interest) of enterprise funds. This ratio indicates if there are sufficient cash flows from operations to meet debt service obligations. Except in cases where other nonoperating revenues (i.e. taxes, assessments, transfers from other funds, etc.) are used to fund debt service payments, an acceptable ratio would be above 100 percent. Bonded Debt per Capita (Funding Ratio) This dollar amount is arrived at by dividing the total bonded debt by the population of the City and represents the amount of bonded debt obligation for each citizen of the City at the end of the year. The higher the amount, the more resources are needed in the future to retire these obligations through taxes, assessments or user fees. The increase in 2007 is due to the refunding bonds that were issued in 2007 to refund bonds in 2009. Taxes per Capita (Funding Ratio) This dollar amount is arrived at by dividing the total tax revenues by the population of the City and represents the amount of taxes for each citizen of the City for the year. The higher this amount is, the more reliant the City is on taxes to fund its operations. Current Expenditures per Capita (Funding Ratio) This dollar amount is arrived at by dividing the total current governmental expenditures by the population of the City and represents the amount of governmental expenditure for each citizen of the City during the year. Since this is generally based on ongoing expenditures, we would expect consistent annual per capita results. Capital Expenditures per Capita (Funding Ratio) This dollar amount is arrived at by dividing the total governmental capital outlay expenditures by the population of the City and represents the amount of capital expenditure for each citizen of the City during the year. Since projects are not always recurring, the per capita amount will fluctuate from year to year. Capital Assets Percentage (Common -size Ratio) This percentage represents the percent of governmental or business -type capital assets that are left to be depreciated. The lower this percentage, the older the City's capital assets are and may need major repairs or replacements in the near future. A higher percentage may indicate newer assets being constructed or purchased and may coincide with higher debt ratios or bonded debt per capita. 952.835.9090 • Fax 952.835.3261 www.aemepas.com City of Shorewood NEED DATE Page 17 Future Accounting Standard Changes GASB Statement No. 61 - The Financial Reporting Entity: Omnibus an Amendment of GASB Statements No. 14 and No. 34 Summary The objective of this Statement is to improve financial reporting for a governmental financial reporting entity. The requirements of Statement No. 14 and the related financial reporting requirements of Statement No. 34, were amended to better meet user needs and to address reporting entity issues that have arisen since the issuance of those Statements. This Statement modifies certain requirements for inclusion of component units in the financial reporting entity. This Statement also amends the criteria for reporting component units as if they were part of the primary government (that is, blending) in certain circumstances. This Statement clarifies the reporting of equity interests in legally separate organizations as well. It requires a primary government to report its equity interest in a component unit as an asset. The provisions of this Statement are effective for financial statements for periods beginning after June 15, 2012. Earlier application is encouraged. How the Changes in This Statement Will Improve Financial Reporting The requirements of this Statement result in financial reporting entity financial statements being more relevant by improving guidance for including, presenting, and disclosing information about component units and equity interest transactions of a financial reporting entity. 4L IN GASB Statement No. 66 - Technical Corrections- an Amendment of GASB Statements No. 10 and No. 62 Summary The objective of this Statement is to improve accounting and financial reporting for a governmental financial reporting entity by resolving conflicting guidance that resulted from the issuance of two pronouncements, Statements No. 54, Fund Balance Reporting and Governmental Fund Type Definitions, and No. 62, Codification of Accounting and Financial Reporting Guidance Contained in Pre - November 30, 1989 FASB and AICPA Pronouncements. The provisions of this Statement are effective for financial statements for 'periods beginning after December 15, 2012. Earlier application is encouraged. How the Changes in This Statement Will Improve Financial Reporting The requirements of this Statement resolve conflicting accounting and financial reporting guidance that could diminish the consistency of financial reporting and thereby enhance the usefulness of the financial reports. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com City of Shorewood NEED DATE Page 18 Future Accounting Standard Changes - Continued GASB Statement No. 67 - The Financial Reporting for Pension Plans- an Amendment to GASB Statement No. 25 Summary The objective of this Statement is to improve financial reporting by state and local governmental pension plans. This Statement results from a comprehensive review of the effectiveness of existing standards of accounting and financial reporting for pensions with regard to providing decision - useful information, supporting assessments of accountability and interperiod equity, and creating additional transparency. This Statement replaces the requirements of Statements No. 25, Financial Reporting for Defined Benefit Pension Plans and Note Disclosures for Defined Contribution Plans, and No. 50, Pension Disclosures, as they relate to pension plans that are administered through trusts or equivalent arrangements (hereafter jointly referred to as trusts) that meet certain criteria. The requirements of Statements No. 25 and No. 50 remain applicable to pension plans that are not administered through trusts covered by the scope of this Statement and to defined contribution plans that provide postemployment benefits other than pensions. This Statement is effective for financial statements for fiscal years beginning after June 15, 2013. Earlier application is encouraged. How the Changes in This Statement Will Improve Financial Reporting 11 r The requirements of this Statement will improve financial reporting primarily through enhanced note disclosures and schedules of required supplementary information that will be presented by the pension plans that are within its scope. The new information will enhance the decision - usefulness of the financial reports of these pension plans, their value for assessing accountability, and their transparency by providing information about measures of net pension liabilities and explanations of how and why those liabilities changed from year to year. The net pension liability information, including ratios, will offer an up -to -date indication of the extent to which the total pension liability is covered by the fiduciary net position of the pension plan. The comparability of the reported information for similar types of pension plans will be improved by the changes related to the attribution method used to determine the total pension liability. The contribution schedule will provide measures to evaluate decisions related to the assessment of contribution rates in comparison to actuarially determined rates, when such rates are determined. In that circumstance, it also will provide information about whether employers and nonemployer contributing entities, if applicable, are keeping pace with actuarially determined contribution measures. In addition, new information about rates of return on pension plan investments will inform financial report users about the effects of market conditions on the pension plan's assets over time and provide information for users to assess the relative success of the pension plan's investment strategy and the relative contribution that investment earnings provide to the pension plan's ability to pay benefits to plan members when they come due. 952.835.9090 • Fax 952.835.3261 www.aemcpas.com City of Shorewood NEED DATE Page 19 Future Accounting Standard Changes - Continued GASB Statement No. 68 - The Accounting and Financial Reporting of Pensions- an Amendment of GASB Statement No. 27 The primary objective of this Statement is to improve accounting and financial reporting by state and local governments for pensions. It also improves information provided by state and local governmental employers about financial support for pensions that is provided by other entities. This Statement results from a comprehensive review of the effectiveness of existing standards of accounting and financial reporting for pensions with regard to providing decision - useful information, supporting assessments of accountability and interperiod equity, and creating additional transparency. This Statement replaces the requirements of Statement No. 27, Accounting for Pensions by State and Local Governmental Employers, as well as the requirements of Statement No. 50, Pension Disclosures, as they relate to pensions that are provided through pension plans administered as trusts or equivalent arrangements (hereafter jointly referred to as trusts) that meet certain criteria. The requirements of Statements 27 and 50 remain applicable for pensions that are not covered by the scope of this Statement. This Statement is effective for fiscal years beginning after June 15, 2014. Earlier application is encouraged. How the Changes in This Statement Will Improve Financial Reporting The requirements of this Statement will improve the decision - usefulness of information in employer and governmental nonemployer contributing entity financial reports and will enhance its value for assessing accountability and interperiod equity by requiring recognition of the entire net pension liability and a more comprehensive measure of pension expense. Decision - usefulness and accountability also will be enhanced through new note disclosures and required supplementary information. of X This communication is intended solely for the information and use of management, City Council, other within the City, and the Minnesota Office of the State Auditor and is not intended to be, and should not be, used by anyone other than these specified parties. Our audit would not necessarily disclose all weaknesses in the system because it was based on selected tests of the accounting records and related data. The comments and recommendations in the report are purely constructive in nature, and should be read in this context. If you have any questions or wish to discuss any of the items contained in this letter, please feel free to contact us at your convenience. We wish to thank you for the opportunity to be of service and for the courtesy and cooperation extended to us by your staff. NEED DATE Minneapolis, Minnesota 952.835.9090 • Fax 952.835.3261 www.aemcpas.com ABDO, EICK & MEYERS, LLP Certified Public Accountants CITY OF SHOREWOOD SHOREWOOD, MINNESOTA OTHER REQUIRED REPORT FOR THE YEAR ENDED DECEMBER 31, 2012 DRAFT MDO EICK& MEYERIS LLP Certified Public Accountants & Consultants 04 CITY OF SHOREWOOD SHOREWOOD, MINNESOTA OTHER REQUIRED REPORT FOR THE YEAR ENDED DECEMBER 31, 2012 PA Nk" FmAil I m I OTHER REQUIRED REPORT Auditor's Report on Legal Compliance CITY OF SHOREWOOD, MINNESOTA OTHER REQUIRED REPORT TABLE OF CONTENTS FOR THE YEAR ENDED DECEMBER 31, 2012 N0 %, N FMA&I -1- Page No. ABDO EICK & ®II el -1 MEYEl W LLP Certified Public Accountants & Consultants 5201 Eden Avenue Suite 250 Edina, MN 55436 AUDITOR'S REPORT ON LEGAL COMPLIANCE Honorable Mayor and City Council City of Shorewood, Minnesota We have audited the accompanying financial statements of the governmental activities, the business -type activities, each major fund and the aggregate remaining fund information of the City of Shorewood, Minnesota (the City) as of and for the year ended December 31, 2012, and have issued our report thereon dated NEED DATE, which collectively comprise the City's basic financial statements. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the provisions of the Minnesota Legal Compliance Audit Guide for Political Subdivisions, promulgated by the Minnesota Office of the State Auditor pursuant to Minnesota statutes, section 6.65. Accordingly, the audit included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. The Minnesota Legal Compliance Audit Guide for Political Subdivision covers seven categories of compliance to be tested: contracting and bidding, deposits and investments, conflicts of interest, public indebtedness, claims and disbursements, tax increment financing and miscellaneous provisions. Our study included all of the listed categories. The results of our tests indicate that for the items tested, the City complied with the material terms and conditions of applicable legal provisions. This report is intended solely for the information and use of management, the City Council, others within the City and the Minnesota Office of the State Auditor and is not intended to be and should not be used by anyone other than these specified parties. NEED DATE ABDO, EICK & MEYERS, LLP Minneapolis, Minnesota Certified Public Accountants 952.835.9090 • Fax 952.835.3261 www.aemepas.com -2- CITY OF SHOREWOOD SHOREWOOD, MINNESOTA COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED DECEMBER 31, 2012 BILL JOYNES, CITY ADMINISTRATOR REPORT PREPARED BY BRUCE DEJONG, FINANCE DIRECTOR/TREASURER MEMBER OF GOVERNMENT FINANCE OFFICERS ASSOCIATION OF THE UNITED STATES AND CANADA CITY OF SHOREWOOD, MINNESOTA COMPREHENSIVE ANNUAL FINANCIAL REPORT TABLE OF CONTENTS FOR THE YEAR ENDED DECEMBER 31, 2012 Exhibit Page No. INTRODUCTORY SECTION Elected and Appointed Officials 4 Organization Chart 5 Letter of Transmittal 7 Certification of Achievement for Excellence in Financial Reporting 12 FINANCIAL SECTION Independent Auditor's Report 15 Management's Discussion and Analysis 19 Basic Financial Statements Government -wide Financial Statements Statement of Net Position 1 33 Statement of Activities 2 34 Fund Financial Statements Governmental Funds Balance Sheet 3 38 Reconciliation of the Balance Sheet to the Statement of Net Position 4 41 Statement of Revenues, Expenditures and Changes in Fund Balances 5 42 Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances to the Statement of Activities 6 44 General Fund Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual 7 45 Proprietary Funds Statements of Net Position 8 46 Statements of Revenues, Expenses and Changes in Net Position 9 48 Statements of Cash Flows 10 50 Fiduciary Fund Statement of Net Position 11 54 Notes to the Financial Statements 55 Combining and Individual Fund Financial Statements and Schedules Nonmajor Governmental Funds Combining Balance Sheet A -1 80 Combining Statement of Revenues, Expenditures and Changes in Fund Balances A -2 81 Nonmajor Capital Projects Funds Combining Balance Sheet B -1 84 Combining Statement of Revenues, Expenditures and Changes in Fund Balances B -2 86 Nonmajor Proprietary Funds Combining Statements of Net Position C -1 90 Combining Statements of Revenues, Expenses and Changes in Net Position C -2 92 Combining Statements of Cash Flows C -3 94 General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual D -1 97 Debt Service Funds Combining Balance Sheet E -1 102 Combining Schedule of Revenues, Expenditures and Changes in Fund Balances E -2 103 Agency Fund Combining Schedule of Changes in Assets and Liabilities F -1 104 Summary Financial Report Revenues and Expenditures for General Operations - Governmental Funds G -1 105 -1- CITY OF SHOREWOOD, MINNESOTA COMPREHENSIVE ANNUAL FINANCIAL REPORT TABLE OF CONTENTS - CONTINUED FOR THE YEAR ENDED DECEMBER 31, 2012 -2- Exhibit Page No. STATISTICAL SECTION (UNAUDITED) Net Position by Component 1 110 Changes in Net Position 2 112 Fund Balances of Governmental Funds 3 116 Changes in Fund Balances of Governmental Funds 4 118 Tax Capacity, Market Value and Estimated Actual Value of Taxable Property 5 120 Property Tax Capacity Rates - Direct and Overlapping Governments 6 122 Principal Taxpayers 7 124 Property Tax Levies and Collections 8 125 Ratio of Net Bonded Debt to Assessed Value and Net Bonded Debt Per Capita 9 126 Ratios of General Bonded Debt Outstanding 10 127 Computation of Direct and Overlapping Debt 11 129 Legal Debt Margin Information 12 130 Pledged- Revenue Coverage 13 132 Demographic and Economic Statistics 14 133 Principal Employers 15 134 Full -Time Equivalent City Government Employees by Function 16 135 Operating Indicators by Function 17 136 Capital Asset Statistics by Function 18 137 -2- INTRODUCTORY SECTION CITY OF SHOREWOOD SHOREWOOD, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2012 -3- CITY OF SHOREWOOD, MINNESOTA ELECTED AND APPOINTED OFFICIALS FOR THE YEAR ENDED DECEMBER 31, 2012 1010X V00111 Name Title Christine Lizee Richard Woodruff Scott Zerby Laura Hotvet Debbie Siakel Name Bill Joynes Bruce DeJong Mayor Council Member Council Member Council Member Council Member APPOINTED Title City Administrator Finance Director /Treasurer -4- Term Expires 12/31/12 12/31/12 12/31/12 12/31/14 12/31/14 City of Shorewood Organizational Chart -5- THIS PAGE IS LEFT BLANK INTENTIONALLY -6- June 24, 2013 Honorable Mayor and Members of the City Council, City of Shorewood, Minnesota Mayor and City Council Members: The Comprehensive Annual Financial Report of the City of Shorewood, Minnesota, for the fiscal year ended December 31, 2012, is hereby submitted. The report was prepared in accordance with accounting principles generally accepted in the United States of America (GAAP) as established by the Governmental Accounting Standards Board and meets the requirements of the Office of State Auditor. The report consists of management's representations concerning the finances of the City. Consequently, management assumes full responsibility for the completeness and reliability of the information presented in this report. To provide a reasonable basis for making these representations, management of the City has established internal controls designed to protect the City's assets from loss, theft, or misuse, and to provide sufficient information for the preparation of these financial statements in conformity with GAAP. Because the cost of internal controls should not outweigh the benefits, the City's internal controls have been designed to provide reasonable, rather than absolute, assurance that the financial statements are free of any material misstatements. As management, we assert that to the best of our knowledge and belief this financial report is complete and reliable in all material respects. The City of Shorewood's financial statements have been audited by the firm of Abdo, Eick & Meyers, LLP, Certified Public Accountants. The goal of the audit was to provide reasonable assurance that the financial statements of the City for the year ended December 31, 2012, are free of material misstatement. The independent audit involved examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements, assessing the accounting principles used and significant estimates used by management; and evaluating the overall financial statement presentation. Based upon the audit, the independent auditor concluded that there was reasonable basis for rendering an unqualified opinion that the City's financial statements, for the year ended December 31, 2012, are fairly presented in conformity with GAAP. The independent auditor's report is presented at the front of the financial section of this report. GAAP requires that management provide a narrative introduction, overview, and analysis to accompany the basic financial statements in the form of Management's Discussion and Analysis (MD &A). The City's MD &A can be found in the financial section of this report immediately following the independent auditor's report. -7- City Profile The City of Shorewood is a suburban community located southwest of the Twin Cities on the southern shore of Lake Minnetonka, a setting of rolling hills and picturesque lakes and creeks. Shorewood has a convenient location, a comprehensive system of highways, and is a short distance from downtown Minneapolis and St. Paul and the Minneapolis -St. Paul International Airport. The City is predominantly a residential community with limited commercial businesses and two commercial shopping malls. The City is 6 square miles in area and had an estimated population of 7,312 as of 2011. The City, which is currently 95% developed, continues to experience some growth in its residential base but, because of the limited availability of large tracts of land, this growth will come slowly through small developments such as the Ashland Woods subdivision. Incorporated in 1956 as a village, the City of Shorewood operates under the Council - Administrator form of government. Policy making and legislative authority are vested in a governing council consisting of the mayor and four - member council, elected on a non - partisan basis. Council members serve four -year staggered terms, with two council members elected every two years. The mayor is elected to serve a two -year term. The City Administrator /Clerk is responsible for overseeing the day - to -day operations of the government, and to assign responsibility to City staff for the efficient and effective delivery of City services. The Economic Development Authority (EDA) of the City was created in 2001 pursuant to Minnesota Statutes to carry out economic and industrial development and redevelopment consistent with policies established by the Council. Its board is comprised of members of the City Council. The EDA activities are blended and separate financial statements are not issued for this component unit. The City provides its residents and businesses with a broad range of municipal services consisting of police and fire protection, street maintenance, recreation programs, park maintenance, community and economic development, and administrative services, including building inspections. During 2011, the City operated four enterprises: a water utility, sanitary sewer, recycling, and storm water management utilities. Economic Conditions and Outlook Governance The City Council, in its leadership role, has effectively established a focus for government in Shorewood and has established overall goals and expectations for the City. The Council's calendar consists of three phases. The first phase is planning. It includes review of the previous year's work plan and identifies goals and priorities for the next twelve months. The second phase is capital finance planning; each year the ten -year Capital Improvement Program is reviewed and updated based upon priorities established in the first phase. Those projects are then incorporated into a financial management plan that includes both operating and capital spending plans to determine the overall feasibility of the plans and the effect of that spending on fund balances and tax levies. The third phase is budgeting; the annual operating budget is developed based on decisions made in the first two phases. The annual budget serves as the foundation of the City of Shorewood's financial planning and control. Departments submit budget requests to Finance in June and the City Administrator presents the proposed budget to the City Council for review prior to September 15"' of each year. Budget work - sessions are held with the City Council in July and August. The City Council holds a Truth -in- Taxation public hearing on the proposed budget and adopts the final budget in December each year. -8- The budget is prepared by fund and function. The City's department directors develop their budgets, with subsequent review and input from the City Administrator and Finance Director. Any changes in the overall budget must be approved by the City Council. Cooperative Public Service Delivery Shorewood is committed to working cooperatively with other Lake Minnetonka area cities to carefully consider methods to efficiently deliver public services. The City has various contractual arrangements with other governmental jurisdictions and with private entities for providing many of these services. The City is also involved in cooperative employee training, disaster preparedness and other areas of mutual concern as an active participant in the Lake Minnetonka area. The City has been a member city of the South Lake Minnetonka Police Department (SLMPD) since its inception in 1973. The other members of this joint powers organization are the cities of Excelsior, Greenwood, and Tonka Bay. The City of Shorewood, along with the cities of Deephaven, Excelsior, Greenwood, and Tonka Bay, has been a member of the Excelsior Fire District since 2000. The Excelsior Fire District is a joint powers organization. A combined police and fire public safety building that serves the South Lake Minnetonka Area cities was completed in late 2003. The City contracts with Hennepin County for property assessment services. The Hennepin County Assessor analyzes property sales information, sets taxable values, and handles the valuation appeal process. Debt Administration As of December 31, 2012, the City's debt outstanding totaled $12,015,000. Of this total, $2,500,000 is General Obligation Water Revenue bonds issued in 1996, 2005, and 2006. The proceeds from these bonds financed water system extensions and improvements and will be repaid from special assessments and water rate revenues. The remaining outstanding debt balance of $9,515,000 is EDA Lease Revenue Advance Refunding bonds issued in 2007 for the public safety buildings and EDA Lease Revenue bonds issued in 2008 for remodeling City Hall. These bonds will be repaid from lease payments from the Excelsior Fire District, South Lake Minnetonka Police Department, and the City of Shorewood. The City of Shorewood's bond rating was upgraded to Aa2 from Aa3 in July, 2008, by Moody's Investors Service. At that time, Moody's also upgraded the Shorewood Economic Development Authority (EDA) bond rating to Aa3 from Al, based upon the City's pledge to make the lease payments subject to annual appropriation in the City's operating budget, and the fact that a city hall facility is an essential part of a municipality. Long -term Financial Planning The City has implemented various financial/budgetary policies to guide the City Council and staff when making financial decisions to ensure the long -term stability and flexibility of City finances and operations. These policies include the following: • The original budget should be balanced with revenues equal to expenditures. -9- • By policy, the City Council has set the fund balance level in the General Fund 55 -60% of the next years' expenditure budget. This policy ensures the long -term economic stability of the organization by providing adequate working capital given the periodic nature of tax receipts and by providing for unexpected shortfalls or emergencies. In accordance with this policy, the City Council may use up to 3% of any General Fund reserves in excess of 60% to reduce the budgeted tax levy, or for one -time projects, or transfer to any of the city's capital funds. • The City will maintain a ten -year capital improvement plan to provide for capital asset acquisition, maintenance, replacement, and retirement. • The City will continue to accumulate resources for future capital equipment and improvement projects with operating transfers to various capital project funds in 2012. Budgeted transfers for capital improvement purposes during 20121 were $907,800. Major Initiatives The City implemented a 10 year Financial Management Plan. This is a comprehensive review of all funds of the city on both an operational and capital spending basis. It compares spending plans against revenue sources to determine how planned outlays compare against estimated revenues and what additional resources may be necessary to accomplish long -term balanced budgets. Other initiatives during the year included the following: • The City of Shorewood operated the Southshore Community Center for the entire year of 2012. The Center was built in the late 1990s as a joint venture by the following five Lake Minnetonka Area Cities: Shorewood, Excelsior, Tonka Bay, Deephaven, and Greenwood. Until recently, the Center was leased to an organization that emphasized senior programming. Many of the senior - oriented programs still remain during the day, and these are a critical component, but Center renovations were made to attract new renters, including businesses, community education classes, and wedding, birthday, and graduation parties. Shorewood has committed to operate the center through December, 2015 by the renewal of an automatic three year extension. New programs have been developed to attract all ages. The Southshore Center's long range options are being evaluated by a committee of the South Shore Senior Partners and other interested parties. Certificate of Achievement The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of Shorewood for its comprehensive annual financial report (CAFR) for the fiscal year ended December 31, 2011. The Certificate of Achievement is a prestigious national award recognizing conformance with the highest standards for preparation of state and local government financial reports. In order to be awarded a Certificate of Achievement, a government unit must publish an easily readable and efficiently organized comprehensive annual financial report whose contents conform to program standards. Such comprehensive annual financial report must satisfy both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year. The City of Shorewood has received a Certificate of Achievement for the past eighteen consecutive years. We believe our current report continues to conform to the Certificate of Achievement program requirements, and we are submitting it to the GFOA to determine its eligibility for another certificate. -10- Acknowledgments We would like to express our appreciation to the employees of the Administration, Finance, Planning, and Public Works departments for their contribution to the preparation of this report. We would also like to thank the Mayor and Council members for their continued support in planning and conducting the financial operations of the City in a responsible and prudent manner. Respectfully submitted, Bill Joynes City Administrator Bruce M. DeJong Finance Director /Treasurer -11- Certificate of Achievement for Excellence in Financial Reporting Presented to City of Shorewood Minnesota For its Comprehensive Annual Financial Report for the Fiscal Year Ended December 31, 2011 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFRs) achieve the highest standards in government accounting and financial reporting. UNITED � �. AND cAINanA - President L '�RPORATION NwA *44r 44 Executive Director -12- FINANCIAL SECTION CITY OF SHOREWOOD SHOREWOOD, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2012 -13- THIS PAGE IS LEFT BLANK INTENTIONALLY -14- ABD ' '- � EICK J _ 1 JERS LL,P Cert fW 1"'iVic ilcc iintaws e!>'` Gowiihaiits ;120.1. EdK.n Avenue `3ui4c 2:50 Kdina, MN 55430 INDEPENDENT AUDITOR'S REPORT Honorable Mayor and City Council City of Shorewood, Minnesota Report on the Financial Statements We have audited the accompanying financial statements of the governmental activities, the business -type activities, each major fund, and the aggregate remaining fund information of the City of Shorewood, Minnesota (the City), as of and for the year ended December 31, 2012, which collectively comprise the City's basic financial statements as listed in the table of contents. Management's Responsibility for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Auditor's Responsibility Our responsibility is to express opinions on these financial statements based on our audit. The prior year comparative information has been derived from the City's 2011 financial statements and, in our report dated August 20, 2012 we express unqualified opinions on the respective proprietary fund financial statements. We did not audit the financial statements of the South Lake Minnetonka Police Department, a joint venture, which is disclosed in Note 5A in the notes to the financial statements. Those statements were audited by other auditors whose report has been furnished to us, and our opinion, insofar as it relates to the amounts included for the South Lake Minnetonka Police Department, is based solely on the report of the other auditors. We conducted our audit in accordance with auditing standards generally accepted in the United States of America. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statements. The procedures selected depend on the auditor's judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the City's preparation and fair presentation of the financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the City's internal control. Accordingly, we express no such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall financial statement presentation. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions. 952A35,9090 • Fax 952 835.3261 -15- www.aemcpa7s.corn THIS PAGE IS LEFT BLANK INTENTIONALLY -16- Opinions In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business -type activities, each major fund, and the aggregate remaining fund information of the City as of December 31, 2012, and the respective changes in financial position and, where applicable, cash flows thereof and the budgetary comparison for the General fund for the year then ended in conformity with accounting principles generally accepted in the United States of America. Other Matters Change in Accounting Standards As described in the Note 8 to the basic financial statements, the City adopted the provisions of Governmental Accounting Standards Board (GASB) Statement No. 63, Financial Reporting of Deferred Outflows of Resources, Deferred Inflows of Resources, and Net Position and Statement No. 65, Items Previously Reported as Assets and Liabilities, for the year ended December 31, 2012. Adoption of the provisions of these statements results in significant change to the classifications of the components of the financial statements. Required Supplementary Information Accounting principles generally accepted in the United States of America require that the Management's Discussion and Analysis starting on page 19 be presented to supplement the basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management's responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. Supplementary Information in Relation to the Financial Statements as a Whole Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City's basic financial statements as a whole. The introductory section, combining and individual fund financial statements and schedules, and statistical section are presented for purposes of additional analysis and are not a required part of the financial statements. The combining and individual fund financial statements and schedules are the responsibility of management and were derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. The information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the financial statements or to the financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the information is fairly stated in all material respects in relation to the financial statements as a whole. The introductory section and statistical sections have not been subjected to the auditing procedures applied in the audit of the basic financial statements and, accordingly, we do not express an opinion or provide any assurance on them. NEED DATE ABDO, EICK & MEYERS, LLP Minneapolis, Minnesota Certified Public Accountants 952A35,9090 • Fax 952 835.3261 -17- www.aemcpais.com THIS PAGE IS LEFT BLANK INTENTIONALLY -18- Management's Discussion and Analysis As management of the City of Shorewood, Minnesota, (the City), we offer readers of the City's financial statements this narrative overview and analysis of the financial activities of the City for the fiscal year ended December 31, 2012. Financial Highlights • The assets of the City exceeded its liabilities and deferred inflows of resources at the close of the most recent fiscal year by $31,108,781 (net position). Of this amount, $16,127,543 (unrestricted net position) may be used to meet the City's ongoing obligations to residents and creditors. • The City's total net position decreased $733,239, due primarily to losses in the Sewer and Stormwater Management funds and depreciation on infrastructure and equipment. • As of the close of the current fiscal year, the City's governmental funds reported combined ending fund balances of $8,085,567 , an increase of $187,305 in comparison with the prior year. This increase is primarily the result of current expenditures in nonmajor governmental funds. Approximately 43.3 percent of this total amount, $3,499,143, is unassigned and available for spending at the City's discretion. • At the end of the current fiscal year, unassigned fund balance for the General fund was $3,574,468, or 83.9 percent of total 2012 budgeted expenditures. The City has a policy to maintain a General fund working capital balance of 55.0 - 60.0 percent of expenditures and transfers. • The City's total debt decreased $833,020, or 6.4 percent during the current fiscal year. The key factor in this decrease was annual principal and interest payments. -19- Overview of the Financial Statements This discussion and analysis is intended to serve as an introduction to the City's basic financial statements. The City's basic financial statements comprise three components: 1) government -wide financial statements, 2) fund financial statements, and 3) notes to the financial statements. This report also contains other supplemental information in addition to the basic financial statements themselves. The financial statements also include notes that explain some of the information in the financial statements and provide more detailed data. The statements are followed by a section of combining and individual fund financial statements and schedules that further explains and supports the information in the financial statements. Figure 1 illustrates how the required parts of this annual report are arranged and relate to one another. In addition to these required elements, we have included a section with combining and individual fund financial statements and schedules that provide details about nonmajor governmental funds, which are added together and presented in single columns in the basic financial statements. Figure 1 Required Components of the City's Annual Financial Report ................................................ ............................... Management's Basic Required Discussion and Financial Supplementary Analysis Statements Information Government- Fund Notes to the wide Financial Financial Financial Statements Statements Statements Summary 0 0 Detail -20- Figure 2 summarizes the major features of the City's financial statements, including the portion of the City government they cover and the types of information they contain. The remainder of this overview section of management's discussion and analysis explains the structure and contents of each of the statements. Figure 2 Major features of the Government -wide and Fund Financial Statements Government -wide financial statements. The government -wide financial statements are designed to provide readers with a broad overview of the City's finances, in a manner similar to a private- sector business. The statement of net position presents information on all of the City's assets and liabilities, with the difference between the two reported as net position. Over time, increases or decreases in net position may serve as a useful indicator of whether the financial position of the City is improving or deteriorating. The statement of activities presents information showing how the City's net position changed during the most recent fiscal year. All changes in net position are reported as soon as the underlying event giving rise to the change occurs, regardless of the timing of related cashflows. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in future fiscal periods (e.g., uncollected taxes and earned but unused vacation leave). Both of the government -wide financial statements distinguish functions of the City that are principally supported by taxes and intergovernmental revenue (governmental activities) from other functions that are intended to recover all or a significant portion of their costs through user fees and charges (business -type activities). The governmental activities of the City include general government, public safety, public works, culture and recreation, and interest on long -term debt. The business -type activities of the City include water, sewer, recycling, and stormwater management utility. -21- Fund Financial Statements Government -wide Governmental Funds Proprietary Funds Statements Scope Entire City government The activities of the City that Activities the City operates (except fiduciary funds) and are not proprietary or similar to private businesses, the City's component units fiduciary, such as police, fire such as the water and sewer and parks system Required financial • Statement of Net • Balance Sheet • Statements of Net statements Position • Statement of Revenues, Position • Statement of Activities Expenditures, and • Statements of Revenues, Changes in Fund Expenses and Changes in Balances Fund Net Position • Statements of Cash Flows Accounting Basis and Accrual accounting and Modified accrual accounting Accrual accounting and measurement focus economic resources focus and current financial economic resources focus resources focus Type of asset /liability All assets and liabilities, both Only assets expected to be All assets and liabilities, both information financial and capital, and used up and liabilities that financial and capital, and short-term and long -term come due during the year or short-term and long -term soon thereafter; no capital assets included Type of deferred All deferred Only deferred outflows of All deferred outflows/inflows of outflows/inflows of resources expected to be outflows/inflows of resources information resources, regardless of used up and deferred inflows resources, regardless of when cash is received or of resources that come due when cash is received or paid paid. during the year of son thereafter; no capital assets included Type of in flow /out flow All revenues and expenses Revenues for which cash is All revenues and expenses information during year, regardless of received during or soon after during the year, regardless of when cash is received or paid the end of the year; when cash is received or paid expenditures when goods or services have been received and payment is due during the year or soon thereafter Government -wide financial statements. The government -wide financial statements are designed to provide readers with a broad overview of the City's finances, in a manner similar to a private- sector business. The statement of net position presents information on all of the City's assets and liabilities, with the difference between the two reported as net position. Over time, increases or decreases in net position may serve as a useful indicator of whether the financial position of the City is improving or deteriorating. The statement of activities presents information showing how the City's net position changed during the most recent fiscal year. All changes in net position are reported as soon as the underlying event giving rise to the change occurs, regardless of the timing of related cashflows. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in future fiscal periods (e.g., uncollected taxes and earned but unused vacation leave). Both of the government -wide financial statements distinguish functions of the City that are principally supported by taxes and intergovernmental revenue (governmental activities) from other functions that are intended to recover all or a significant portion of their costs through user fees and charges (business -type activities). The governmental activities of the City include general government, public safety, public works, culture and recreation, and interest on long -term debt. The business -type activities of the City include water, sewer, recycling, and stormwater management utility. -21- The government -wide financial statements include not only the City itself (known as the primary government), but also a legally separate Economic Development Authority (EDA) for which the City is financially accountable. The EDA, although legally separate, functions for all practical purposes as a department of the City, and therefore has been included as an integral part of the primary government. The government -wide financial statements start on page 33 of this report. Fund financial statements. A fund is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities or objectives. The City, like other state and local governments, uses fund accounting to ensure and demonstrate compliance with finance- related legal requirements. All of the funds of the City can be divided into three categories: governmental funds, proprietary funds and fiduciary funds. Governmental funds. Governmental funds are used to account for essentially the same functions reported as governmental activities in the government -wide financial statements. However, unlike the government -wide financial statements, governmental fund financial statements focus on near -term inflows and outflows of spendable resources, as well as on balances of spendable resources available at the end of the fiscal year. Such information may be useful in evaluating a government's near -term financing requirements. Because the focus of governmental funds is narrower than that of the government -wide financial statements, it is useful to compare the information presented for governmental funds with similar information presented for governmental activities in the government -wide financial statements. By doing so, readers may better understand the long -term impact by the government's near -term financing decisions. Both the governmental fund balance sheet and the governmental fund statement of revenues, expenditures and changes in fund balances provide a reconciliation to facilitate this comparison between governmental funds and governmental activities. The City maintains 15 individual governmental funds. Information is presented separately in the governmental fund balance sheet and in the governmental fund statement of revenues, expenditures and changes in fund balances for the General, Debt Service, and Community Infrastructure funds, which are considered to be major funds. Data from the other eight governmental funds are combined into a single, aggregated presentation. Individual fund data for each of these nonmajor governmental funds is provided in the form of combining statements or schedules elsewhere in this report. The City adopts an annual appropriated budget for its General fund. A budgetary comparison statement has been provided for the General fund to demonstrate compliance with this budget. The basic governmental fund financial statements start on page 38 of this report. Proprietary funds. The City maintains one type of proprietary fund. Enterprise funds are used to report the same functions presented as business -type activities in the government -wide financial statements. The City uses enterprise funds to account for its water, sewer, recycling, and stormwater management utility. Proprietary funds provide the same type of information as the government -wide financial statements, only in more detail. The proprietary fund financial statements provide separate information for each of the enterprise funds which are considered to be major funds of the City. The basic proprietary fund financial statements start on page 46 of this report. Fiduciary funds. Fiduciary funds are used to account for resources held for the benefit of parties outside the City. Fiduciary funds are not reflected in the government -wide financial statements because the resources of those funds are not available to support the City's own programs. The accounting used for fiduciary funds is much like that used for proprietary funds. The basic fiduciary fund financial statements can be found on page 54 of this report. Notes to the financial statements. The notes provide additional information that is essential to a full understanding of the data provided in the government -wide and fund financial statements. The notes to the financial statements start on page 55 of this report. Other information. The combining statements referred to earlier in connection with nonmajor governmental funds are presented following the notes to the financial statements. Combined and individual fund financial statements and schedules starts on page 80 of this report. -22- Government -wide Financial Analysis As noted earlier, net position may serve over time as a useful indicator of a government's financial position. In the case of the City, assets exceeded liabilities and deferred inflows of resources by $31,108,781 at the close of the most recent fiscal year. Of the City's net position 48.2 percent reflects its investment in capital assets (e.g., land, buildings, machinery and equipment), less any related debt used to acquire those assets that is still outstanding. The City uses these capital assets to provide services to citizens; consequently, these assets are not available for future spending. Although the City's investment in its capital assets is reported net of related debt, it should be noted that the resources needed to repay this debt must be provided from other sources, since the capital assets themselves cannot be used to liquidate these liabilities. City of Shorewood's Summary of Net Position The balance of unrestricted net position is $16,127,543. This may be used to meet the City's ongoing obligations to citizens and creditors. -23- Governmental Activities Business -type Activities Increase Restated Increase 2012 2011 (Decrease) 2012 2011 (Decrease) Assets Cash and temporary investments $ 7,593,686 $ 7,596,833 $ (3,147) $ 7,452,376 $ 7,482,041 $ (29,665) Cash with fiscal agent - 6,504 (6,504) 235,245 166,957 68,288 Receivables 8,997,619 9,486,472 (488,853) 615,851 636,382 (20,531) Prepaids 50,000 48,000 2,000 - - - Land held for resale 150,068 150,068 - - - - Capital assets 9,627,162 10,413,669 (786,507) 8,994,076 9,350,613 (356,537) Total assets 26,418,535 27,701,546 (1,283,011) 17,297,548 17,635,993 (338,445) Liabilities Noncurrent liabilities 9,696,762 10,354,782 (658,020) 2,500,000 2,675,000 (175,000) Other liabilities 255,241 313,590 (58,349) 155,299 152,147 3,152 Total liabilities 9,952,003 10,668,372 (716,369) 2,655,299 2,827,147 (171,848) Net position Net investment in capital assets 8,487,162 9,223,669 (736,507) 6,494,076 6,675,613 (181,537) Unrestricted 7,979,370 7,809,505 169,865 8,148,173 8,133,233 14,940 Total net position $16,466,532 $17,033,174 $ (566,642) $14,642,249 $14,808,846 $ (166,597) The balance of unrestricted net position is $16,127,543. This may be used to meet the City's ongoing obligations to citizens and creditors. -23- Governmental activities. Governmental activities decreased the City's net position by $566,642. Key elements of this increase are as follows: Revenues Program revenues Charges for services Operating grants and contributions Capital grants and contributions General revenues Property taxes Grants and contributions not restricted to specific programs Unrestricted investment earnings Gain on sale of capital assets Total revenues Expenses General government Public safety Public works Culture and recreation Interest on long -term debt Water Sewer Recycling Stormwater management utility Total expenses Increase (decrease) in net position before transfers Transfers Change in net position Net position, January 1 Net position, December 31 City of Shorewood's Changes in Net Position Governmental Activities Business -type Activities Increase Restated Increase 2012 2011 (Decrease) 2012 2011 (Decrease) $ 832,626 $ 732,114 $ 100,512 $ 1,940,551 $ 1,840,253 $ 100,298 102,959 113,717 (10,758) 23,007 33,586 (10,579) - - - 22,400 15,000 7,400 4,761,213 4,733,948 27,265 - - - 6,019 4,751 1,268 - - - 61,584 56,705 4,879 64,135 62,345 1,790 - 28,500 (28,500) - - - 5,764,401 5,669,735 94,666 2,050,093 1,951,184 98,909 1,331,286 1,405,791 (74,505) - - - 1,947,868 1,960,894 (13,026) - - - 2,162,123 2,031,136 130,987 - - - 460,879 412,257 48,622 - - - 428,887 438,088 (9,201) - - - - - - 689,205 682,098 7,107 - - - 1,065,926 1,151,626 (85,700) - - - 187,713 174,857 12,856 - - - 273,846 233,035 40,811 6,331,043 6,248,166 82,877 2,216,690 2,241,616 (24,926) (566,642) (578,431) 11,789 (166,597) (290,432) 123,835 (566,642) (578,431) 11,789 (166,597) (290,432) 123,835 17,033,174 17,611,605 (578,431) 14,808,846 15,099,278 (290,432) $16,466,532 $17,033,174 $ (566,642) $14,642,249 $14,808,846 $ (166,597) -24- The following graph depicts various governmental activities and shows the revenue and expenses directly related to those activities. $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $- Expenses and Program Revenues - Governmental Activities General government Public safety Public works Culture and recreation IIIIIIIII Expenses IIIIIIIIIIII Program revenues Revenues by Source - Governmental Activities Property 82.6% Grants and Unrestricted Charges for contributions not investment earnings services 0.1% 144% -25- Interest on long -term debt Operating grants and contributions 1.8% Business -type activities. Business -type activities decreased the City's net position by $166,597. $1,200,000 $1,000,000 $ 800,000 $600,000 $400,000 $200,000 Expenses and Program Revenues - Business -type Activities Water Sewer Recycling Stormwater management utility Expenses Program revenues Revenues by Source - Business -type Activities Operating grants and contribution 1.1% Capital grants and Unrestricted contributions investment -26- ,2harges for services 94.7% Financial Analysis of the Government's Funds As noted earlier, the City uses fund accounting to ensure and demonstrate compliance with finance - related legal requirements Governmental funds. The focus of the City's governmental funds is to provide information on near -term inflows, outflows and balances of spendable resources. Such information is useful in assessing the City's financing requirements. In particular, unassigned fund balance may serve as a useful measure of a government's net resources available for spending at the end of the fiscal year. As of the end of the current fiscal year, the City's governmental funds reported combined ending fund balances of $8,085,567, a increase of $187,305 in comparison with the prior year. Approximately 44 percent of this total amount, $3,499,143 constitutes unassigned fund balance, which is available for spending at the City's discretion. The remaining fund balance is made up of the following: 1) Nonspendable ($200,068), 2) Restricted ($17,700), and 3) Assigned ($4,368,656). The General fund is the chief operating fund of the City. At the end of the current year, the fund balance of the General fund was $3,624,468. As a measure of the General fund's liquidity, it may be useful to compare both unassigned fund balance and total fund balance to total fund expenditures. Total fund balance represents 83.9 percent of same year fund expenditures. The fund balance of the City's General fund increased $136,241 during the current fiscal year. The Debt Service fund has a total fund balance of $17,700, all of which is restricted for the payment of debt service. The decrease in fund balance of $12,739 was in line with the City's debt service financing plan. The Community Infrastructure fund has a fund balance of $1,842,330. The fund balance increased $12,852 during the current fiscal year due to an excess of revenues over expenditures. The Street Reconstruction fund has a fund balance of $1,760,337. The fund balance increased by $278,885 during the current fiscal year due to a transfer in of $700,000, which exceeded expenditures. Proprietary funds. The City's proprietary funds provide the same type of information found in the government -wide financial statements, but in more detail. Unrestricted net position of the enterprise funds at the end of the year amounted to $8,148,173. The total decrease in net position for the funds was $166,597. Other factors concerning the finances of this fund have already been addressed in the discussion of the City's business -type activities. General Fund Budgetary Highlights The City's General fund budget was not amended during the year. The budget called for the planned use of General fund reserves in the amount of $87,435. Revenues were over budget by $220,367, and expenditures were under budget by $56,487. The actual amounts were different from the final budget amounts because of the following: • The largest positive variances in revenue were related to fiscal disparities and refunds and reimbursements, which were over budget by $113,410 and $67,032. • There were seven departments that experienced a negative budget variance. The largest negative expenditure variance was related to Administrative which was $96,788 over budget due to personal services and other services and charges. -27- Capital Asset and Debt Administration Capital assets. The City's investment in capital assets for its governmental and business -type activities as of December 31, 2012, amounts to $18,621,238 (net of accumulated depreciation). This investment in capital assets includes land, structures, improvements, machinery and equipment, park facilities, and roads. Major capital asset events during the current fiscal year included the following: • Freightliner dump truck • Asphalt roller • Case skid steer tractor • Covington Road sediment trap • Smithtown sewer reconstruction Additional information on the City's capital assets can be found in Note 3 B starting on page 66 of this report. City of Shorewood's Capital Assets (net of depreciation) Total $ 9,627,162 $10,413,669 $ (786,507) $ 8,994,076 $ 9,350,613 $ (356,537) Long -term debt. At the end of the current fiscal year, the City had total bonded debt outstanding of $12,015,000. Of this amount, $9,515,000 is lease revenue bonds and $2,500,000 is general obligation revenue bonds. While all of the City's bonds have dedicated revenue streams pledged to repayment, the general obligation revenue bonds are all backed by the full faith and credit of the City. General obligation revenue bonds Lease revenue bonds Compensated absences payable Total City of Shorewood's Outstanding Debt Governmental Activities Business -type Activities Increase Increase 2012 2011 (Decrease) 2012 2011 (Decrease) $ - $ - $ - 9,515,000 10,170,000 (655,000) 181,762 184,782 (3,020) $ 2,500,000 $ 2,675,000 $ (175,000) $ 9,696,762 $10,354,782 $ (658,020) $ 2,500,000 $ 21675,000 $ (175,000) Minnesota statutes limit the amount of net general obligation debt a City may issue to 3 percent of the market value of taxable property within the City. Net debt is debt payable solely from ad valorem taxes. Additional information on the City's long -term debt can be found in Note 3D starting on page 68 of this report. -28- Governmental Activities Business -type Activities Increase Increase 2012 2011 (Decrease) 2012 2011 (Decrease) Land $ 741,826 $ 741,826 $ - $ 434,113 $ 434,113 $ - Constructioninprogress - 52,145 (52,145) 63,931 174,603 (110,672) Buildings 2,339,814 2,424,026 (84,212) - - - Improvements other than buildings 325,942 365,799 (39,857) - - - Machinery and equipment 714,285 652,216 62,069 4,331 9,249 (4,918) Infrastructure 5,505,295 6,177,657 (672,362) 8,491,701 8,732,648 (240,947) Total $ 9,627,162 $10,413,669 $ (786,507) $ 8,994,076 $ 9,350,613 $ (356,537) Long -term debt. At the end of the current fiscal year, the City had total bonded debt outstanding of $12,015,000. Of this amount, $9,515,000 is lease revenue bonds and $2,500,000 is general obligation revenue bonds. While all of the City's bonds have dedicated revenue streams pledged to repayment, the general obligation revenue bonds are all backed by the full faith and credit of the City. General obligation revenue bonds Lease revenue bonds Compensated absences payable Total City of Shorewood's Outstanding Debt Governmental Activities Business -type Activities Increase Increase 2012 2011 (Decrease) 2012 2011 (Decrease) $ - $ - $ - 9,515,000 10,170,000 (655,000) 181,762 184,782 (3,020) $ 2,500,000 $ 2,675,000 $ (175,000) $ 9,696,762 $10,354,782 $ (658,020) $ 2,500,000 $ 21675,000 $ (175,000) Minnesota statutes limit the amount of net general obligation debt a City may issue to 3 percent of the market value of taxable property within the City. Net debt is debt payable solely from ad valorem taxes. Additional information on the City's long -term debt can be found in Note 3D starting on page 68 of this report. -28- Economic Factors and Next Year's Budgets and Rates • The City is experiencing a decrease in property values on higher value properties, but lower value home prices seem to be stabilizing. • Unemployment trends in the region compare favorably to national indices. • The 2013 budget was developed to continue using General fund balance to bring the overall balance down to the policy level while continuing to provide the same basic service levels to the public. • Property tax revenues for the 2013 budget were unchanged from the 2012 budget. All of these factors were taken into account in preparing the City's budget for the 2013 fiscal year During the 2012 fiscal year, the fund balance in the General fund increased by $136,241. This City budgeted a use of fund balance of $87,435. This planned use of fund balance in accordance with the Fund Balance Policy adopted by the City Council. Other possible uses of available fund balance over the policy level include one -time projects, and transfers to capital project funds as determined by the City Council. Requests for Information This financial report is designed to provide a general overview of the City's finances for all those with an interest in the City's finances. Questions concerning any of the information provided in this report or requests for additional financial information should be addressed to the City of Shorewood, 5755 Country Club Road, Shorewood, Minnesota 55331. -29- THIS PAGE IS LEFT BLANK INTENTIONALLY -30- GOVERNMENT -WIDE FINANCIAL STATEMENTS CITY OF SHOREWOOD SHOREWOOD, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2012 -31- THIS PAGE IS LEFT BLANK INTENTIONALLY -32- CITY OF SHOREWOOD, MINNESOTA STATEMENT OF NET POSITION DECEMBER 31, 2012 ASSETS Cash and temporary investments Cash with fiscal agent Receivables Accrued interest Property taxes Accounts Special assessments Lease Due from other governments Prepaid items Land held for resale Capital assets Nondepreciable assets Depreciable capital assets, net TOTAL ASSETS LIABILITIES Accounts and contracts payable Due to other governments Accrued interest payable Noncurrent liabilities Due within one year Due in more than one year TOTAL LIABILITIES NET POSITION Net investment in capital assets Unrestricted TOTAL NET POSITION The notes to the financial statements are an integral part of this statement. -33- Exhibit I Governmental Business -type Activities Activities Total S 7,593,686 S 7,452,376 S 15,046,062 - 235,245 235,245 174,877 31,036 205,913 118,582 - 118,582 45,779 423,273 469,052 2,210 161,542 163,752 8,652,892 - 8,652,892 3,279 - 3,279 50,000 - 50,000 150,068 - 150,068 741,826 498,044 1,239,870 8,885,336 8,496,032 17,381,368 26,418,535 17,297,548 43,716,083 104,035 104,322 208,357 1,518 1,157 2,675 149,688 49,820 199,508 822,969 185,000 1,007,969 8,873,793 2,315,000 11,188,793 9,952,003 2,655,299 12,607,302 8,487,162 6,494,076 14,981,238 7,979,370 8, 148, 173 16, 127,543 S 16,466,532 S 14,642,249 S 31,108,781 Functions /Programs Governmental activities General government Public safety Public works Culture and recreation Interest on long -term debt Total governmental activities Business -type activities CITY OF SHOREWOOD, MINNESOTA STATEMENT OF ACTIVITIES FOR THE YEAR ENDED DECEMBER 31, 2012 Water 689,205 757,395 - Program Revenues Sewer 1,065,926 831,640 - Operating Capital Grants Recycling Charges for Grants and and Expenses Services Contributions Contributions Total business -type activities 2,216,690 1,940,551 23,007 22,400 S 1,331,286 S 144,883 S 300 S - 1,947,868 604,400 1,328 - 2,162,123 4,137 68,755 - 460,879 79,206 32,576 - 428,887 - - - Unrestricted investment earnings 6,331,043 832,626 102,959 - Water 689,205 757,395 - 20,000 Sewer 1,065,926 831,640 - 21400 Recycling 187,713 157,585 23,007 - Stormwater management utility 273,846 193,931 - - Total business -type activities 2,216,690 1,940,551 23,007 22,400 Total S 8,547,733 S 2,773,177 S 125,966 S 22,400 General revenues Taxes Property taxes, levied for general purposes Grants and contributions not restricted to specific programs Unrestricted investment earnings Total general revenues and transfers Change in net position Net position as restated, January 1 Net position, December 31 The notes to the financial statements are an integral part of this statement. -34- Exhibit 2 Net (Expense) Revenue and Changes in Net Position Governmental Business -type $ (1,186,103) $ - $ (1,186,103) (1,342,140) - (1,342,140) (2,089,231) - (2,089,231) (349,097) - (349,097) (428,887) - (428,887) (5,395,458) - (5,395,458) 88,190 88,190 (231,886) (231,886) (7,121) (7,121) (79,915) (79,915) (230,732) (230,732) (5,395,458) (230,732) (5,626,190) 4,761,213 - 4,761,213 6,019 - 6,019 61,584 64,135 125,719 4,828,816 64,135 4,892,951 (566,642) (166,597) (733,239) $ 16,466,532 $ 14,642,249 $ 31,108,781 -35- THIS PAGE IS LEFT BLANK INTENTIONALLY -36- FUND FINANCIAL STATEMENTS CITY OF SHOREWOOD SHOREWOOD, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2012 -37- CITY OF SHOREWOOD, MINNESOTA BALANCE SHEET GOVERNMENTAL FUNDS DECEMBER 31, 2012 The notes to the financial statements are an integral part of this statement -38- Debt Street General Service Reconstruction ASSETS Cash and temporary investments S 3,517,917 S 19,925 S 1,755,991 Receivables Accrued interest 13,432 - 5,757 Taxes 118,582 - - Accounts 45,779 - - Special assessments 2,210 - - Lease - 8,375,000 - Due from other governments 3,279 - - Due from other funds 37,611 - - Prepaid items 50,000 - - Land held for resale - - - TOTAL ASSETS S 3,788,810 S 8,394,925 S 1,761,748 LIABILITIES Accounts and contracts payable S 83,055 S 2,225 S 1,411 Due to other governments 1,518 - - Due to other funds - - - TOTAL LIABILITIES 84,573 2,225 1,411 DEFERRED INFLOWS OF RESOURCES Unavailable revenue - property taxes 77,559 - - Unavailable revenue - lease receivable - 8,375,000 - Unavailable revenue - special assessments 2,210 - - TOTAL DEFERRED INFLOWS OF RESOURCES 79,769 8,375,000 - FUND BALANCES Nonspendable Prepaid items 50,000 - - Land held for resale - - - Restricted for debt service - 17,700 - Assigned to Street reconstruction - - 1,760,337 Community infrastructure - - - Capital outlay - - - Unassigned 3,574,468 - - TOTAL FUND BALANCES 3,624,468 17,700 1,760,337 TOTAL LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCES S 3,788,810 S 8,394,925 S 1,761,748 The notes to the financial statements are an integral part of this statement -38- Exhibit 3 Other Total Community Governmental Governmental Infrastructure Funds Funds $ 1,663,908 $ 635,945 $ 7,593,686 6,960 3,244 29,393 - - 118,582 - - 45,779 - - 2,210 - 277,892 8,652,892 - - 3,279 21,394 - 59,005 - - 50,000 150,068 - 150,068 $ 1,842,330 $ 917,081 $ 16,704,894 $ - $ 17,344 $ 104,035 - - 1,518 - 59,005 59,005 - 76,349 164,558 - - 77,559 - - 8,375,000 - - 2,210 - - 8,454,769 - - 50,000 150,068 - 150,068 - - 17,700 1,760,337 1,692,262 - 1,692,262 - 916,057 916,057 - (75,325) 3,499,143 1,842,330 840,732 8,085,567 $ 1,842,330 $ 917,081 $ 16,704,894 -39- THIS PAGE IS LEFT BLANK INTENTIONALLY -40- CITY OF SHOREWOOD, MINNESOTA Exhibit 4 RECONCILIATION OF THE BALANCE SHEET TO THE STATEMENT OF NET POSITION GOVERNMENTAL FUNDS DECEMBER 31, 2012 Total fund balances - governmental S 8,085,567 Amounts reported for the governmental activities in the statement of net position are different because Capital assets used in governmental activities are not financial resources and therefore are not reported as assets in governmental funds. Cost of capital assets 35,772,472 Less: accumulated depreciation (26,145,310) Long -term liabilities, including bonds payable, are not due and payable in the current period and therefore are not reported as liabilities in the funds. Long -term liabilities at year -end consist of Bonds payable (9,515,000) Compensated absences payable (181,762) Some receivables are not available soon enough to pay for the current period's expenditures, and therefore are reported as unavailable revenue in the funds. Interest on lease receivable 145,484 Delinquent taxes receivable 77,559 Special assessments receivable 2,210 Leases receivable 8,375,000 Governmental funds do not report a liability for accrued interest until due and payable. (149,688) Total net position - governmental activities S 16,466,532 The notes to the financial statements are an integral part of this statement. -41- CITY OF SHOREWOOD, MINNESOTA STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31, 2012 REVENUES Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Interest on investments Miscellaneous TOTAL REVENUES EXPENDITURES Current General government Public safety Public works Culture and recreation Capital outlay General government Public safety Public works Culture and recreation Debt service Principal Interest and service charges TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Transfers in Transfers out TOTAL OTHER FINANCING SOURCES (USES) NET CHANGE IN FUND BALANCES FUND BALANCES, JANUARY 1 FUND BALANCES, DECEMBER 31 Debt Street General Service Reconstruction S 4,783,939 S - S - 175,087 - - 76,102 - - 61,611 - - 66,230 - - 25,602 746 11,366 117,824 978,744 - 5,306,395 979,490 11,366 1,282,580 - - 1,445,149 - - 823,234 - - 205,542 - - 2,811 - - 503,038 - - - - 432,511 - 655,000 - - 439,429 - 4,262,354 1,094,429 432,511 1,044,041 (114,939) (421,145) - 102,200 700,000 (907,800) - - (907,800) 102,200 700,000 136,241 (12,739) 278,855 3,488,227 30,439 1,481,482 S 3,624,468 S 17,700 S 1,760,337 The notes to the financial statements are an integral part of this statement. -42- Exhibit 5 Other Total Community Governmental Governmental Infrastructure Funds Funds $ - $ - $ 4,783,939 - - 175,087 - - 76,102 - 60,014 121,625 - - 66,230 14,232 9,638 61,584 - 19,268 1,115,836 14,232 88,920 6,400,403 - 6,124 1,288,704 - - 1,445,149 - - 823,234 - 125,982 331,524 1,380 1,380 - 2,811 - 503,038 222,614 655,125 67,704 69,084 - 655,000 - 439,429 422,424 6,213,098 12,852 (333,504) 187,305 - 368,016 1,170,216 - (262,416) (1,170,216) - 105,600 - 12,852 (227,904) 187,305 1,829,478 1,068,636 7,898,262 $ 1,842,330 $ 840,732 $ 8,085,567 -43- CITY OF SHOREWOOD, MINNESOTA Exhibit 6 RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES TO THE STATEMENT OF ACTIVITIES GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31, 2012 Total net change in fund balances - governmental funds S 187,305 Amounts reported for governmental activities in the statement of activities are different because Capital outlays are reported in governmental funds as expenditures. However, in the statement of activities, the cost of those assets is allocated over the estimated useful lives as depreciation expense. Capital outlays 230,309 Depreciation expense (1,016,816) The issuance of long -term debt provides current financial resources to governmental funds, while the repayment of principal of long -term debt consumes the current financial resources of governmental funds. Neither transaction, however, has any effect on net position. Also, governmental funds report the effect of premiums, discounts and similar items when debt is first issued, whereas these amounts are deferred and amortized in the statement of activities. Principal repayments 655,000 Interest on long -term debt in the statement of activities differs from the amount reported in the governmental funds because interest is recognized as an expenditure in the funds when it is due, and thus requires the use of current financial resources. In the statement of activities, however interest expense is recognized as the interest accrues, regardless of when it is due. 10,542 Certain revenues are recognized as soon as it is earned. Under the modified accrual basis of accounting certain revenues cannot be recognized until they are available to liquidate liabilities of the current period. Delinquent taxes (22,726) Special assessments 2,210 Leases (615,486) Some expenses reported in the statement of activities do not require the use of current financial resources and, therefore, are not reported as expenditures in governmental funds. Compensated absences 3,020 Change in net position - governmental activities S (566,642) The notes to the financial statements are an integral part of this statement. -44- CITY OF SHOREWOOD, MINNESOTA Exhibit 7 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL GENERAL FUND FOR THE YEAR ENDED DECEMBER 31, 2012 REVENUES Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Interest on investments Miscellaneous IC0ir :UlRILTA0641M0 EXPENDITURES Current General government Public safety Public works Culture and recreation Capital outlay General government Public safety TOTAL EXPENDITURES EXCESS OF REVENUES OVER EXPENDITURES OTHER FINANCING SOURCES (USES) Transfers in Transfers out TOTAL OTHER FINANCING SOURCES (USES) FUND BALANCES, JANUARY 1 FUND BALANCES, DECEMBER 31 Budgeted Amounts Actual Variance with Original Final Amounts Final Budget S 4,763,319 S 4,763,319 S 4,783,939 S 20,620 109,200 109,200 175,087 65,887 70,401 70,401 76,102 5,701 35,075 35,075 61,611 26,536 54,500 54,500 66,230 11,730 45,000 45,000 25,602 (19,398) 18,900 18,900 117,824 98,924 5,096,395 5,096,395 5,306,395 210,000 1,188,789 1,188,789 1,282,580 (93,791) 1,445,589 1,445,589 1,445,149 440 928,820 928,820 823,234 105,586 249,794 249,794 205,542 44,252 - - 2,811 (2,811) 503,038 503,038 503,038 - 4,316,030 4,316,030 4,262,354 53,676 780,365 780,365 1,044,041 263,676 40,000 40,000 - (40,000) (907,800) (907,800) (907,800) - (867,800) (867,800) (907,800) (40,000) (87,435) (87,435) 136,241 223,676 3,488,227 3,488,227 3,488,227 - S 3,400,792 S 3,400,792 S 3,624,468 S 223,676 The notes to the financial statements are an integral part of this statement. -45- CITY OF SHOREWOOD, MINNESOTA STATEMENTS OF NET POSITION PROPRIETARY FUNDS DECEMBER 31, 2012 AND 2011 ASSETS CURRENT ASSETS Cash and temporary investments Cash with fiscal agent Receivables Accrued interest Accounts Special assessments TOTAL CURRENT ASSETS NONCURRENT ASSETS Special assessments receivable Capital assets Land Construction in progress Machinery and equipment Infrastructure Less accumulated depreciation NET CAPITAL ASSETS TOTAL NONCURRENT ASSETS TOTAL ASSETS LIABILITIES CURRENT LIABILITIES Accounts and contracts payable Accrued salaries payable Due to other governments Accrued interest payable Unearned revenue Bonds payable - current TOTAL CURRENT LIABILITIES NONCURRENT LIABILITIES Bonds payable TOTAL LIABILITIES NET POSITION Net investment in capital assets Unrestricted TOTAL NET POSITION The notes to the financial statements are an integral part of this statement. Business -type Activities - Enterprise Funds 601 611 Water Sewer 18,314 874 49,820 185,000 254,008 10,204 82,108 51,061 3,234 - 3,446 1,158 283 - 53,308 - 21,550 - 175,000 - - 264,454 82,391 54,507 2,315,000 2,500,000 - - 2,569,008 Restated 82,391 54,507 2012 2011 2012 2011 4,220,403 3,999,945 3,695,849 3,740,609 $ 3,810,729 $ 3,670,508 $ 3,514,714 $ 3,544,245 235,245 166,957 - - 15,633 4,669 14,549 4,508 108,743 102,013 220,760 217,182 2,813 6,325 4,823 6,187 4,173,163 3,950,472 3,754,846 3,772,122 116,248 138,927 23,394 22,994 - - 63,931 - 39,869 39,869 43,385 43,385 9,944,664 9,944,664 8,776,827 8,776,827 (3,981,844) (3,706,927) (7,381,505) (7,160,291) 6,002,689 6,277,606 1,502,638 1,659,921 6,118,937 6,416,533 1,526,032 1,682,915 10,292,100 10,367,005 5,280,878 5,455,037 18,314 874 49,820 185,000 254,008 10,204 82,108 51,061 3,234 - 3,446 1,158 283 - 53,308 - 21,550 - 175,000 - - 264,454 82,391 54,507 2,315,000 2,500,000 - - 2,569,008 2,764,454 82,391 54,507 3,502,689 3,602,606 1,502,638 1,659,921 4,220,403 3,999,945 3,695,849 3,740,609 $ 7,723,092 $ 7,602,551 $ 5,198,487 $ 5,400,530 -46- Exhibit 8 Business -type Activities - Enterprise Funds Nonmajor Enterprise Totals Restated $ 126,933 $ 267,288 $ 7,452,376 $ 7,482,041 - - 235,245 166,957 854 340 31,036 9,517 93,770 119,994 423,273 439,189 2,490 2,465 10,126 14,977 224,047 390,087 8,152,056 8,112,681 11,774 10,778 151,416 172,699 434,113 434,113 434,113 434,113 - 174,603 63,931 174,603 - - 83,254 83,254 1,292,577 1,009,997 20,014,068 19,731,488 (237,941) (205,627) (11,601,290) (11,072,845) 1,488,749 1,413,086 8,994,076 9,350,613 1,500,523 1,423,864 9,145,492 9,523,312 1,724,570 1,813,951 17,297,548 17,635,993 3,900 7,422 104,322 68,687 - 764 - 7,444 - - 1,157 1,158 - - 49,820 53,308 - - - 21,550 - - 185,000 175,000 3,900 8,186 340,299 327,147 - - 2,315,000 2,500,000 3,900 8,186 2,655,299 2,827,147 1,488,749 1,413,086 6,494,076 6,675,613 231,921 392,679 8,148,173 8,133,233 $ 1,720,670 $_1,805 ,765 $ 14,642,249 $ 14,808,846 -47- CITY OF SHOREWOOD, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION PROPRIETARY FUNDS FOR THE YEARS ENDED DECEMBER 31, 2012 AND 2011 OPERATING REVENUES Charges for services OPERATING EXPENSES Personal services Supplies Repairs and maintenance Depreciation Professional services Contracted services Insurance Water purchases Utilities Disposal charges Other TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) NONOPERATING REVENUES (EXPENSES) Special assessments Interest on investments Other income Interest expense Business -type Activities - Enterprise Funds 601 611 Water Sewer Restated 2012 2011 2012 2011 S 612,892 S 511,427 S 828,490 S 818,296 137,295 105,904 94,617 99,995 13,294 11,812 1,970 3,044 8,515 3,514 12,149 31,562 274,917 273,673 221,214 214,247 11,344 1,385 14,510 - 10,190 22,716 10,230 42,521 - - 773 - 41,442 37,054 - - 75,903 72,651 8,700 10,625 - - 702,206 744,098 15,637 44,926 (443) 5,534 588,537 573,635 1,065,926 1,151,626 24,355 (62,208) (237,436) (333,330) 19,486 14,648 - - 32,351 30,768 29,843 27,553 125,017 146,718 3,150 1,200 (100,668) (108,463) - - TOTAL NONOPERATING REVENUES (EXPENSES) 76,186 83,671 32,993 28,753 INCOME (LOSS) BEFORE CONTRIBUTIONS CAPITAL CONTRIBUTIONS - CONNECTION FEES CHANGE IN NET POSITION NET POSITION AS RESTATED, JANUARY 1 NET POSITION AS RESTATED, DECEMBER 31 100,541 21,463 (204,443) (304,577) 20,000 15,000 2,400 - 120,541 36,463 (202,043) (304,577) 7,602,551 7,566,088 5,400,530 5,705,107 S 7,723,092 S 7,602,551 S 5,198,487 S 5,400,530 The notes to the financial statements are an integral part of this statement. -48- Exhibit 9 Business -type Activities - Enterprise Funds Nonmajor Enterprise Totals Restated 2012 2011 2012 2011 $ 351,516 $ 347,864 $ 1,792,898 $ 1,677,587 64,104 50,896 296,016 256,795 16,607 5,199 31,871 20,055 30,030 88,004 50,694 123,080 32,314 25,250 528,445 513,170 19,783 29,632 45,637 31,017 297,650 208,420 318,070 273,657 - - 773 - - - 41,442 37,054 - - 84,603 83,276 - - 702,206 744,098 1,071 491 16,265 50,951 461,559 407,892 2,116,022 2,133,153 (110,043) (60,028) (323,124) (455,566) - - 19,486 14,648 1,941 4,024 64,135 62,345 23,007 33,686 151,174 181,604 - - (100,668) (108,463) 24,948 37,710 134,127 150,134 (85,095) (22,318) (188,997) (305,432) - - 22,400 15,000 (85,095) (22,318) (166,597) (290,432) 1,805,765 1,828,083 14, 808, 846 15,099,278 $ 1,720,670 $ 1,805,765 $ 14,642,249 $ 14,808,846 -49- CITY OF SHOREWOOD, MINNESOTA STATEMENTS OF CASH FLOWS - CONTINUED ON THE FOLLOWING PAGES PROPRIETARY FUNDS FOR THE YEARS ENDED DECEMBER 31, 2012 AND 2011 CASH FLOWS FROM OPERATING ACTIVITIES Receipts from customers and users Other receipts related to operations Payments to suppliers, contractors and other governments Payments to employees NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Connection fees received Principal paid on revenue bonds Interest paid on revenue bonds Acquisition of capital assets Special assessments collected NET CASH USED BY CAPITAL AND RELATED FINANCING ACTIVITIES CASH FLOWS FROM INVESTING ACTIVITIES Interest received on investments NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS CASH AND CASH EQUIVALENTS, JANUARY 1 CASH AND CASH EQUIVALENTS, DECEMBER 31 Business -type Activities - Enterprise Funds 601 611 Water Sewer Restated 2012 2011 2012 2011 $ 606,162 $ 500,572 $ 825,876 $ 820,379 103,467 124,962 3,150 1,200 (168,499) (201,185) (760,681) (792,783) (140,529) (104,295) (98,063) (97,835) 400,601 320,054 (29,718) (69,039) 20,000 15,000 2,400 - (175,000) (240,000) - - (104,156) (112,291) - - - - (22,015) (190,013) 45,677 73,582 - - (213,479) (263,709) (19,615) (190,013) 21,387 29,364 19,802 26,976 208,509 85,709 (29,531) (232,076) 3,837,465 3,751,756 3,544,245 3,776,321 $ 4,045,974 $ 3,837,465 $ 3,514,714 $ 3,544,245 RECONCILIATION OF CASH AND CASH EQUIVALENTS TO THE STATEMENT OF NET POSITION Cash and temporary investments $ 3,810,729 $ 3,670,508 $ 3,514,714 $ 3,544,245 Cash with fiscal agent 235,245 166,957 - - TOTAL CASH AND CASH EQUIVALENTS $ 4,045,974 $ 3,837,465 $ 3,514,714 $ 3,544,245 The notes to the financial statements are an integral part of this statement. -50- Exhibit 10 Business -type Activities - Enterprise Funds Nonmmajor Enterprise Totals Restated 2012 2011 2012 2011 $ 376,719 $ 319,464 $ 1,808,757 $ 1,640,415 23,007 33,686 129,624 159,848 (365,739) (330,238) (1,294,919) (1,324,206) (64,868) (51,001) (303,460) (253,131) (30,881) (28,089) 340,002 222,926 - - 22,400 15,000 - - (175,000) (240,000) - - (104,156) (112,291) (110,901) (418,085) (132,916) (608,098) - - 45,677 73,582 (110,901) (418,085) (343,995) (871,807) 1,427 4,554 42,616 60,894 (140,355) (441,620) 38,623 (587,987) 267,288 708,908 7,648,998 8,236,985 $ 126,933 $ 267,288 $ 7,687,621 $ 7,648,998 $ 126,933 $ 267,288 $ 7,452,376 $ 7,482,041 - - 235,245 166,957 $ 126,933 $ 267,288 $ 7,687,621 $ 7,648,998 -51- CITY OF SHOREWOOD, MINNESOTA STATEMENTS OF CASH FLOWS - CONTINUED PROPRIETARY FUNDS FOR THE YEARS ENDED DECEMBER 31, 2012 AND 2011 Business -type Activities - Enterprise Funds 601 611 Water Sewer RECONCILIATION OF OPERATING INCOME (LOSS) TO NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES Operating income (loss) Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities Other income related to operations Depreciation (Increase) decrease in assets Accounts receivable Special assessments receivable Increase (decrease) in liabilities Accounts payable Due to other governments Accrued salaries payable NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES NONCASH CAPITAL AND RELATED FINANCING ACTIVITIES Capital assets purchased on account 2012 2011 2012 2011 $ 24,355 $ (62,208) $ (237,436) $ (333,330) 103,467 124,962 3,150 1,200 274,917 273,673 221,214 214,247 (6,730) (10,855) (3,578) (202) - - 964 2,285 8,110 (7,520) (10,869) 44,601 (284) 393 283 - (3,234) 1,609 (3,446) 2,160 $ 400,601 $ 320,054 $ (29,718) $ (69,039) $ 41,916 $ - The notes to the financial statements are an integral part of this statement. -52- Exhibit 10 Business -type Activities - Enterprise Funds Nonmmajor Enterprise Totals 2012 2011 2012 2011 $ (110,043) $ (60,028) $ (323,124) $ (455,566) 23,007 33,686 129,624 159,848 32,314 25,250 528,445 513,170 26,224 (27,767) 15,916 (38,824) (1,021) (633) (57) 1,652 (598) 1,508 (3,357) 38,589 - - (1) 393 (764) (105) (7,444) 3,664 $ (30,881) $ (28,089) $ 340,002 $ 222,926 $ - $ 2,924 $ 41,916 $ 2,924 -53- CITY OF SHOREWOOD, MINNESOTA Exhibit 11 STATEMENT OF NET POSITION FIDUCIARY FUND DECEMBER 31, 2012 ASSETS Cash and temporary investments Illk�lilll��l�! Escrow deposits payable Agency S 47,087 S 47,087 The notes to the financial statements are an integral part of this statement. -54- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 leMM1VY11u lu 111:1w11 Icy [Mel I y 167.110 IIT60011101 Y VIM 01 a [f11 Iy A. Reporting entity The City of Shorewood, Minnesota (the City), operates under the "Optional Plan A" form of government as defined in the State of Minnesota statutes. Under this plan, the government of the City is directed by a City Council composed of an elected Mayor and four elected City Council members. The City Council exercises legislative authority and determines all matters of policy. The City Council appoints personnel responsible for the proper administration of all affairs relating to the City. The City has considered all potential units for which it is financially accountable, and other organizations for which the nature and significance of their relationship with the City are such that exclusion would cause the City's financial statements to be misleading or incomplete. The Governmental Accounting Standards Board (GASB) has set forth criteria to be considered in determining financial accountability. These criteria include appointing a voting majority of an organization's governing body, and (1) the ability of the City to impose its will on that organization or (2) the potential for the organization to provide specific benefits to, or impose specific financial burdens on the City. Blended component units, although legally separate entities are, in substance, part of the City's operations and so data from these units are combined with data of the City. The City has the following component unit: Blended component unit The Economic Development Authority (EDA) of the City was created pursuant to Minnesota statutes 469.090 through 469.108 to carry out economic and industrial development and redevelopment consistent with policies established by the City Council. It is comprised of the members of the City Council and has a December 31 year end. The EDA activities are blended and reported in the Debt Service and capital projects funds. Separate financial statements are not issued for this component unit. B. Government -wide and fund financial statements The government -wide financial statements (i.e., the statement of net position and the statement of activities) report information on all of the nonfiduciary activities of the City and its component unit. Governmental activities, which normally are supported by taxes and intergovernmental revenues, are reported separately from business -type activities, which rely to a significant extent on fees and charges for support. The statement of activities demonstrates the degree to which the direct expenses of a given function or segment is offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function or segment. Program revenues include 1) charges to customers or applicants who purchase, use, or directly benefit from goods, services, or privileges provided by a given function or segment and 2) grants and contributions that are restricted to meeting the operational or capital requirements of a particular function or segment. Taxes and other items not properly included among program revenues are reported instead as general revenues. Separate financial statements are provided for governmental funds, proprietary funds and fiduciary funds. Major individual governmental funds and major individual enterprise funds are reported as separate columns in the fund financial statements. C. Measurement focus, basis of accounting and financial statement presentation Governmental fund financial statements are reported using the current financial resources measurement focus and the mod f ed accrual basis of accounting. Revenues are recognized as soon as they are both measurable and available. Revenues are considered to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. For this purpose, the City considers revenues to be available if they are collected within 60 days of the end of the current fiscal period. Expenditures generally are recorded when a liability is incurred, as under accrual accounting. However, debt service expenditures, as well as expenditures related to compensated absences and claims and judgments, are recorded only when payment is due. Property taxes, licenses and interest associated with the current fiscal period are all considered to be susceptible to accrual and so have been recognized as revenues of the current fiscal period. Only the portion of special assessments receivable due within the current fiscal period is considered to be susceptible to accrual as revenue of the current period. All other revenue items are considered to be measurable and available only when cash is received by the City. -55- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 Note 1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - CONTINUED Revenue resulting from exchange transactions, in which each party gives and receives essentially equal value, is recorded on the accrual basis when the exchange takes place. On a modified accrual basis, revenue is recorded in the year in which the resources are measurable and become available. Non - exchange transactions, in which the City receives value without directly giving equal value in return, include property taxes, grants, entitlement and donations. On an accrual basis, revenue from property taxes is recognized in the year for which the tax is levied. Revenue from grants, entitlements and donations is recognized in the year in which all eligibility requirements have been satisfied. Eligibility requirements include timing requirements, which specify the year when the resources are required to be used or the year when use is first permitted, matching requirements, in which the City must provide local resources to be used for a specified purpose, and expenditure requirements, in which the resources are provided to the City on a reimbursement basis. On a modified accrual basis, revenue from non - exchange transactions must also be available before it can be recognized. Unearned revenue arises when assets are recognized before revenue recognition criteria have been satisfied. Grants and entitlements received before eligibility requirements are met are also recorded as unearned revenue. The preparation of financial statements in conformity with accounting principles generally accepted in the United States of America requires management to make estimates and assumptions that affect certain reported amounts and disclosures. Accordingly, actual results could differ from those estimates. The City reports the following major governmental funds: The General fund is the City's primary operating fund. It accounts for all financial resources of the general government, except those required to be accounted for in another fund. The Debt Service fund accounts for the resources accumulated and payments made for principal and interest on long -term general obligation debt of governmental funds. The Street Construction fund accounts for the resources accumulated and payments made for the periodic reconstruction of City streets and roadways. The Community Infirastr ucture fund accounts for the resources accumulated and payments made for future improvements in the City. The City reports the following major proprietary funds: The Water fund accounts for the activities of the City's water distribution system. The Sewer fund accounts for the activities of the City's sewage collection system. Additionally, the City reports the following fund types: The fiduciary funds account for assets held by the City in a trustee capacity or as an agent on behalf of others. The agency fund is custodial in nature and does not present results of operations or have a measurement focus. Agency funds are accounted for using the accrual basis of accounting. This fund is used to account for assets that the City holds for certain residents, developers, and other parties that are involved with escrow related projects within the City. As a general rule the effect of interfund activity has been eliminated from government -wide financial statements. Exceptions to this general rule are payments -in -lieu of taxes and other charges between the City's water and sewer function and various other functions of the City. Elimination of these charges would distort the direct costs and program revenues reported for the various functions concerned. -56- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 Note 1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - CONTINUED Amounts reported as program revenues include 1) charges to customers or applicants for goods, services, or privileges provided, 2) operating grants and contribution, and 3) capital grants and contributions, including special assessments. Internally dedicated resources are reported as general revenues rather than as program revenues. Likewise, general revenues include all taxes. Proprietary funds distinguish operating revenues and expenses from nonoperating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with a proprietary fund's principal ongoing operations. The principal operating revenues of the water, sewer, recycling and stormwater management utility enterprise funds are charges to customers for sales and services. Operating expenses for enterprise funds include the cost of sales and services, administrative expenses, and depreciation on capital assets. All revenues and expenses not meeting this definition are reported as nonoperating revenues and expenses. When both restricted and unrestricted resources are available for use, it is the City's policy to use restricted resources first, then unrestricted resources as they are needed. D. Assets, liabilities, deferred inflows of resources, and net position /fund balance Deposits and investments The City's cash and cash equivalents are considered to be cash on hand, demand deposits, and short-term investments with original maturities of three months or less from the date of acquisition. Cash balances from all funds are pooled and invested, to the extent available, in certificates of deposit and other authorized investments. Earnings from such investments are allocated on the basis of applicable participation by each of the funds. The City may invest idle funds as authorized by Minnesota statutes, as follows: 1. Direct obligations or obligations guaranteed by the United States or its agencies. 2. Shares of investment companies registered under the Federal Investment Company Act of 1940 and received the highest credit rating, rated in one of the two highest rating categories by a statistical rating agency, and have a final maturity of thirteen months or less. 3. General obligations of a state or local government with taxing powers rated "A" or better; revenue obligations rated "AA" or better. 4. General obligations of the Minnesota Housing Finance Agency rated "A" or better. 5. Bankers' acceptances of United States banks eligible for purchase by the Federal Reserve System. 6. Commercial paper issued by United States banks corporations or their Canadian subsidiaries, of highest quality category by at least two nationally recognized rating agencies, and maturing in 270 days or less. 7. Repurchase or reverse repurchase agreements and securities lending agreements with financial institutions qualified as a "depository" by the government entity, with banks that are members of the Federal Reserve System with capitalization exceeding $10,000,000, a primary reporting dealer in U.S. government securities to the Federal Reserve Bank of New York, or certain Minnesota securities broker - dealers. 8. Guaranteed Investment Contracts (GIC's) issued or guaranteed by a United States commercial bank, a domestic branch of a foreign bank, a United States insurance company, or its Canadian subsidiary, whose similar debt obligations were rated in one of the top two rating categories by a nationally recognized rating agency. Investments for the City are reported at fair value. Earnings on investments are allocated to the individual funds based upon the average cash and investment balances. -57- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 1►6iMOVIIlu lu 111:1w11 Icy [Mel 111 [611►Y IIT6001110111 1►[ej 01 a [f111PWOUIel Y 1►1111111 Property taxes The City Council annually adopts a tax levy in December and certifies it to the County for collection in the following year. The County is responsible for collecting all property taxes for the City. These taxes attach an enforceable lien on taxable property within the City on January 1 and are payable by the property owners in two installments. The taxes are collected by the County Auditor and tax settlements are made to the City during January, July and December each year. Delinquent taxes receivable include the past six years' uncollected taxes. Delinquent taxes have been offset by a deferred inflow of resources for delinquent taxes not received within 60 days after year end in the governmental fund financial statements. Accounts receivable Accounts receivable include amounts billed for services provided before year end. Unbilled utility enterprise fund receivables are also included for services provided in 2012. The City annually certifies delinquent water and sewer accounts to the County for collection in the following year. Therefore, there has been no allowance for doubtful accounts established. Special assessments Special assessments represent the financing for public improvements paid for by benefiting property owners. These assessments are recorded as receivables upon certification to the County. Special assessments are recognized as revenue when they are received in cash or within 60 days after year end. All governmental assessments receivable are offset by a deferred inflow of resources in the fund financial statements. Interfund receivables and payables Transactions between funds that are representative of lending/borrowing arrangements outstanding at the end of the fiscal year are referred to as either "interfund receivables /payables" (i.e., the current portion of Interfund loans) or "advances to /from other funds" (i.e., the non - current portion of Interfund loans). All other outstanding balances between funds are reported as "due to /from other funds." Any residual balances outstanding between the governmental activities and business -type activities are reported in the government -wide financial statements as "internal balances." Advances between funds, as reported in the fund financial statements, are offset by a nonspendable fund balance account in applicable governmental funds to indicate they are not available for appropriation and are not expendable available financial resources. Prepaid items Certain payments to vendors reflect costs applicable to future accounting periods and are recorded as prepaid items in both government -wide and fund financial statements. Prepaid items of the City are accounted for using the consumption method. -58- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 1►6iMOVIIlu lu 111:1w11ILI [Mel 111167.110 IIT60011101 Y 1►[ej 01 a [f111PWO010 Y 1►1111111 Capital assets Capital assets, which include property, plant, equipment and infrastructure assets (e.g., roads, bridges, sidewalks, and similar items), are reported in the applicable governmental or business -type activities columns in the government -wide financial statements. Capital assets are defined by the City as assets with an estimated useful life in excess of one year. Such assets are recorded at historical cost or estimated historical cost if purchased or constructed. Donated capital assets are recorded at estimated fair market value at the date of donation. For financial statement purposes only, a capitalization threshold is established for each capital asset category as follows: Assets Threshold Land and land improvements $ 10,000 Other improvements 25,000 Buildings 25,000 Building improvements 25,000 Machinery and equipment 5,000 Vehicles 5,000 Infrastructure 100,000 Other assets 5,000 In the case of initial capitalization of general infrastructure assets (i.e., those reported by governmental activities) the City chose to include items dating back to June 30, 1980. The City was able to estimate the historical cost for the initial reporting of these assets through backtrending (i.e., estimating the current replacement cost of the infrastructure to be capitalized and using an appropriate price -level index to deflate the cost to the acquisition year or estimated acquisition year). As the City constructs or acquires capital assets each period, including infrastructure assets, they are capitalized and reported at historical cost. The reported value excludes normal maintenance and repairs which are essentially amounts spent in relation to capital assets that do not increase the capacity or efficiency of the item or extend its useful life beyond the original estimate. Interest incurred during the construction phase of capital assets of business -type activities is included as part of the capitalized value of the assets constructed. Property, plant and equipment of the City, are depreciated using the straight -line method over the following estimated useful lives: Useful Lives Assets in Years Land improvements 15-20 Buildings and improvements 7-40 System improvements /infrastructure 20-50 Machinery and equipment 5- 15 Vehicles 5- 15 -59- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 Note 1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - CONTINUED Deferred inflows of resources In addition to liabilities, the statement of financial position and fund financial statements will sometimes report a separate section for deferred inflows of resources. This separate financial statement element, deferred inflows of resources, represents an acquisition of net position that applies to a future period and so will not be recognized as an inflow of resources (revenue) until that time. The government has only one type of item, which arises only under a modified accrual basis of accounting, that qualifies as needing to be reported in this category. Accordingly, the item, unavailable revenue, is reported only in the governmental funds balance sheet. The governmental funds report unavailable revenues from three sources: property taxes, special assessments and lease receivable. These amounts are deferred and recognized as an inflow of resources in the period that the amounts are received. Compensated absences It is the City's policy to permit employees to accumulate a portion of earned but unused vacation and sick pay benefits. Accumulated vacation and sick pay are accrued when incurred in the government -wide, proprietary, and fiduciary fund financial statements. A liability for these amounts is reported in governmental funds only if they have matured, for example, as a result of employee resignations and retirements. In the case of an employee leaving, the General fund would be responsible for liquidation of the liability. Postemployment benefits other than pensions Under Minnesota statute 471.61, subdivision 2b., public employers must allow retirees and their dependents to continue coverage indefinitely in an employer- sponsored health care plan, under the following conditions: 1) Retirees must be receiving (or eligible to receive) an annuity from a Minnesota public pension plan, 2) Coverage must continue in group plan until age 65, and retirees must pay no more than the group premium, and 3) Retirees may obtain dependent coverage immediately before retirement. All premiums are funded on a pay -as- you -go basis. It was determined, in accordance with GASB Statement 45, at December 31, 2012 that the City has a zero liability. Long -term obligations In the government -wide financial statement and proprietary fund types in the fund financial statements, long -term debt and other long -term obligations are reported as liabilities in the applicable governmental activities, business -type activities or proprietary fund type statement of net position. The recognition of bond premiums and discounts are amortized over the life of the bonds using the straight -line method. Bonds payable are reported net of the applicable bond premium or discount. Bond issuance costs are reported as an expense in the period incurred. In the fund financial statements, governmental fund types recognize bond premiums and discounts, as well as bond issuance costs, during the current period. The face amount of debt issued is reported as other financing sources. Premiums received on debt issuances are reported as other financing sources while discounts on debt issuances are reported as other financing uses. Issuance costs, whether or not withheld from the actual debt proceeds received, are reported as debt service expenditures. -60- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 1►6iMOVIIlu lu 111:1w11ILy [Mel 111 [N1►Y IIT6001110111 1►[ej 01 a [a I OPWO010 Y 1►11110 11 Fund balance In the fund financial statements, fund balance is divided into five classifications based primarily on the extent to which the City is bound to observe constraints imposed upon the use of resources reported in the governmental funds. These classifications are defined as follows: Nonspendable - Amounts that cannot be spent because they are not in spendable form, such as prepaid items and land held for sale. Restricted - Amounts related to externally imposed constraints established by creditors, grantors or contributors; or constraints imposed by state statutory provisions. Committed - Amounts constrained for specific purposes that are internally imposed by formal action (resolution) of the City Council, which is the City's highest level of decision - making authority. Committed amounts cannot be used for any other purpose unless the City Council modifies or rescinds the commitment by resolution. Assigned - Amounts constrained for specific purposes that are internally imposed. In governmental funds other than the General fund, assigned fund balance represents all remaining amounts that are not classified as nonspendable and are neither restricted nor committed. In the General fund, assigned amounts represent intended uses established by the City Council itself or by an official to which the governing body delegates the authority. The City Council has adopted a fund balance policy which delegates the authority to assign amounts for specific purposes to the City Administrator. Unassigned - The residual classification for the General fund and also negative residual amounts in other funds. The City considers restricted amounts to be spent first when both restricted and unrestricted fund balance is available. Additionally, the City would first use committed, then assigned, and lastly unassigned amounts of unrestricted fund balance when expenditures are made. The City has formally adopted a fund balance policy for the General fund. The City's policy is to maintain a minimum unassigned fund balance of two months operating expenditures for cash -flow timing needs. Net position Net position represents the difference between assets and liabilities. Net position is displayed in three components: a. Net investment in capital assets - Consists of capital assets, net of accumulated depreciation reduced by any outstanding debt attributable to acquire capital assets. b. Restricted net position - Consist of net position balances restricted when there are limitations imposed on their use through external restrictions imposed by creditors, grantors, laws or regulations of other governments. c. Unrestricted net position - All other net position balances that do not meet the definition of "restricted" or "net investment in capital assets ". Comparative data/reclassifications Comparative total data for the prior year have been presented only for individual enterprise funds in the fund financial statements in order to provide an understanding of the changes in the financial position and operations of these funds. Also, certain amounts presented in the prior year data have been reclassified in order to be consistent with the current year's presentation. -61- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 Note 2: STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY A. Budgetary information Annual budgets are adopted on a basis consistent with accounting principles generally accepted in the United States of America for the General fund. All annual appropriations lapse at fiscal year end. The City does not use encumbrance accounting. In August of each year, all departments of the City submit requests for appropriations to the City Administrator so that a budget may be prepared. Before September 151h, the proposed budget is presented to the City Council for review. In early December, the City Council holds public hearings and a final budget is prepared and adopted. The appropriated budget is prepared by fund, function and department. The City's department heads, with the approval of the City Administrator, may make transfers of appropriations within a department. Transfers of appropriations between departments require the approval of the City Council. The legal level of budgetary control is the department level. There were no budget amendments made during 2012. B. Deficit fund equity The following fund had a deficit fund balance as of December 31, 2012: Fund Nonmajor capital project Trail Construction Nonmajor special revenue Southshore Community Center The City plans to fund this deficit with future revenues and interfund transfers. Note 3: DETAILED NOTES ON ALL FUNDS A. Deposits and investments Deposits Amount 34,576 40,749 Custodial credit risk for deposits and investments is the risk that in the event of a bank failure, the City's deposits and investments may not be returned or the City will not be able to recover collateral securities in the possession of an outside party. In accordance with Minnesota statutes and as authorized by the City Council, the City maintains deposits at those depository banks, all of which are members of the Federal Reserve System. Minnesota statutes require that all City deposits be protected by insurance, surety bond or collateral. The fair value of collateral pledged must equal 110 percent of the deposits not covered by insurance or bonds. -62- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 lemmim 11 ON 1I1I1111110631 Y ORK17►/:1111 11110 lj-�We 7►Y Y 1►1111111 Authorized collateral in lieu of a corporate surety bond includes: • United States government Treasury bills, Treasury notes, Treasury bonds; • Issues of United States government agencies and instrumentalities as quoted by a recognized industry quotation service available to the government entity; • General obligation securities of any state or local government with taxing powers which is rated "A" or better by a national bond rating service, or revenue obligation securities of any state or local government with taxing powers which is rated "AA" or better by a national bond rating service; • General obligation securities of a local government with taxing powers may be pledged as collateral against funds deposited by that same local government entity; • Irrevocable standby letters of credit issued by Federal Home Loan Banks to a municipality accompanied by written evidence that the bank's public debt is rated "AA" or better by Moody's Investors Service, Inc., or Standard & Poor's Corporation; and • Time deposits that are fully insured by any Federal agency. Minnesota statutes require that all collateral shall be placed in safekeeping in a restricted account at a Federal Reserve Bank, or in an account at a trust department of a commercial bank or other financial institution that is not owned or controlled by the financial institution furnishing the collateral. The selection should be approved by the government entity. At year end, the City's carrying amount of deposits was $282,617 and the bank balance was $335,981. The entire bank balance was covered by Federal depository insurance or by collateral held by the City's agent in the City's name. A reconciliation of cash and temporary investments as shown on the financial statements for the City follows: Primary Government Carrying amount of deposits $ 282,617 Investments 15,045,657 Cash on hand 120 Total $ 15,328,394 As reported on the financial statements Statement of net position $ 15,046,062 Cash with fiscal agent 235,245 Fiduciary fund 47,087 Total $ 15,328,394 -63- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 lemmim 11 ON 1I1I1111110631 Y ORK17►/:1111 11110 lj-�We 7►Y Y 1►1111111 Investments The Minnesota Municipal Money Market fund (the 4M fund) is a customized cash management and investment program for Minnesota public funds. Sponsored and governed by the League of Minnesota Cities since 1987, the 4M fund is a unique investment alternative designed to address the daily and long -term investment needs of Minnesota cities and other municipal entities. Allowable under Minnesota statutes, the 4M fund is comprised of top quality, rated investments. The Minnesota Municipal Money Market fund and broker money market investment pools operate in accordance with appropriate State laws and regulations. The 4M fund is an external investment pool not registered with the Securities and Exchange Commission (SEC); however, it follows the same regulatory rules of the SEC under rule 2a7. The reported value of the pool is the same as the fair value of the pool share. Financial statements of the 4M fund can be obtained by contracting RBC Global Asset Management at 100 South Fifth Street, Suite 2300, Minneapolis, MN 55402 -1240. At year end, the City had the following investments that are insured or registered, or securities held by the City's agent in the City's name: Types of Investments Non Pooled investments U.S. Government Agency Securities Municipal Bonds Municipal Bonds Municipal Bonds Municipal Bonds Municipal Bonds Municipal Bonds Municipal Bonds Municipal Bonds Municipal Bonds Municipal Bonds Municipal Bonds Brokered Certificates of Deposit Brokered Certificates of Deposit Brokered Certificates of Deposit Total non pooled Pooled investments Minnesota Municipal Money Market fund Broker Money Market Total pooled Total investments 10,811,617 N/A less than 6 months 2,109,528 N/A less than 6 months 2,124,512 4,234,040 S 15,045,657 (1) Ratings are provided by various credit ratings agencies where applicable to indicate associated credit risk. (2) Interest rate risk is disclosed using the segmented time distribution method. N/A Indicates not applicable or available. -64- Fair Value Credit Segmented and Quality/ Time Carrying Rating (1) Distribution (2) Amount AAA more than 3 years S 1,502,425 AA less than 6 months 222,873 Aa2 less than 6 months 185,178 Aa3 less than 6 months 1,400,448 Aa2 less than 1 year 1,076,197 Aa3 less than 1 year 539,312 A 1 to 3 years 528,710 Aa2 1 to 3 years 738,032 Aa3 1 to 3 years 571,577 A more than 3 years 532,950 AA more than 3 years 1,191,075 Aa2 more than 3 years 610,808 N/A less than 6 months 1,130,018 N/A 6 to 12 months 341,425 N/A 1 to 3 years 240,589 10,811,617 N/A less than 6 months 2,109,528 N/A less than 6 months 2,124,512 4,234,040 S 15,045,657 (1) Ratings are provided by various credit ratings agencies where applicable to indicate associated credit risk. (2) Interest rate risk is disclosed using the segmented time distribution method. N/A Indicates not applicable or available. -64- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 lemmim 11 ON 1I1I1111110631 Y ORK17►/:1111 1111011-�K/7►Y Y 1►1111111 The investments of the City are subject to the following risks: • Credit Risk. Credit risk is the risk that an issuer or other counterparty to an investment will not fulfill its obligations. Ratings are provided by various credit rating agencies and where applicable, indicate associated credit risk. Minnesota statutes and the City's investment policy limit the City's investments to the list on page 57 of the notes. Custodial Credit Risk. The custodial credit risk for investments is the risk that, in the event of the failure of the counterparty to a transaction, a government will not be able to recover the value of investment or collateral securities that are in the possession of an outside parry. In accordance with the City's investment policy, the investment officer shall structure all investments, deposits and repurchase agreements so that the custodial risk is categorized as either insured or registered, or securities held by the City or its agent in the City's name or uninsured and unregistered, with securities held by the counterparty's trust department or agent in the City's name. All investments are placed in safekeeping at financial institutions. • Concentration of Credit Risk. Concentration of credit risk is the risk of loss attributed to the magnitude of a government's investment in a single issuer. In accordance with the City's investment policy, the City diversifies its investment portfolio to eliminate the risk of loss resulting from over - concentration of assets in a specific maturity, a specific issuer or a specific class of securities. As of December 31, 2012 the City had invested 5.0 percent or more of its total investment portfolio in the following issuer: Groton Connecticut Taxable, 9.3 percent. • Interest Rate Risk. Interest rate risk is the risk that changes in interest rates will adversely affect the fair value of an investment. In accordance with its investment policy and also detailed in the description of concentration of credit risk, the City manages its exposure to declines in fair values by "laddering" their investment maturities to ensure that a portion of the portfolio is maturing monthly, or as needed to meet projected expenditures. The City also permits no more than 30 percent of total investments to extend beyond five (5) years and does not directly invest in securities maturing more than 15 years from the date of purchase. -65- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 lemmim 11 ON 1I1I1111110631 Y ORK17►/:1111 11110 lj-�We 7►Y Y 1►1111111 B. Capital assets Capital asset activity for the year ended December 31, 2012 was as follows: Beginning Ending Governmental activities Capital assets not being depreciated Land Construction in progress Total capital assets not being depreciated Capital assets being depreciated Buildings Improvements other than buildings Infrastructure Machinery and equipment Total capital assets being depreciated Less accumulated depreciation Buildings Improvements other than buildings Infrastructure Machinery and equipment Total accumulated depreciation Total capital assets being depreciated, net Governmental activities capital assets, net S 741,826 S - S - S 741,826 52,145 11,178 (63,323) - 793,971 11,178 (63,323) 741,826 3,373,870 - - 3,373,870 1,012,469 - - 1,012,469 27,773,568 63,323 - 27,836,891 2,653,342 219,131 (65,057) 2,807,416 34,813,249 282,454 (65,057) 35,030,646 (949,843) (84,213) - (1,034,056) (646,670) (39,857) - (686,527) (21,595,910) (735,686) - (22,331,596) (2,001,128) (157,060) 65,057 (2,093,131) (25,193,551) (1,016,816) 65,057 (26,145,310) 9,619,698 (734,362) - 8,885,336 $ 10,413,669 S (723,184) S (63,323) S 9,627,162 -66- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 Note 3: DETAILED NOTES ON ALL FUNDS - CONTINUED Beginning Ending Balance Increases Decreases Balance Business -type activities Capital assets not being depreciated Land S 434,113 S - S - S 434,113 Construction in progress 174,603 171,908 (282,580) 63,931 Total capital assets not being depreciated 608,716 171,908 (282,580) 498,044 Capital assets being depreciated Infrastructure 19,731,488 282,580 - 20,014,068 Machinery and equipment 83,254 - - 83,254 Total capital assets being depreciated 19,814,742 282,580 - 20,097,322 Less accumulated depreciation for Infrastructure (10,998,841) (523,526) - (11,522,367) Machinery and equipment (74,004) (4,919) - (78,923) Total accumulated depreciation (11,072,845) (528,445) - (11,601,290) Total capital assets being depreciated, net 8,741,897 (245,865) - 8,496,032 Business -type activities capital assets, net S 9,350,613 S (73,957) S (282,580) S 8,994,076 Depreciation expense was charged to functions /programs of the City as follows: Governmental activities General government S 60,786 Public works 895,502 Culture and recreation 60,528 Total depreciation expense - governmental activities S 1,016,816 Business -type activities Water S 274,917 Sewer 221,214 Stormwater management utility 32,314 Total depreciation expense - business -type activities S 528,445 -67- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 lemmim 11 ON 1I1I1111110631 Y ORK17►/:1111 1111011-�K/7►Y Y 1►1111111 Construction commitments The City has active construction projects as of December 31, 2012. At year end, the commitment with the contractors for these projects is as follows: Spent Remaining Project to date Commitment 2012 Rehabilitation of Lift Station 5 & 6 $ 41,916 $ 267,392 C. Interfund receivables, payables and transfers Interfund balances The composition of Interfund balances as of December 31, 2012, is as follows: Receivable Fund Major governmental General Community Infrastructure Interfund transfers Payable Fund Nonmajor governmental Southshore Community Center Trail Construction Purpose Cash flow Cash flow 4 ­­t 37,611 21,394 The City made transfers during the fiscal year 2012 as shown and described below: Transfers in Street Nonmajor Fund Debt Service Reconstruction Governmental Total Transfers out General $ 102,200 $ 700,000 $ 105,600 $ 907,800 Nonmajor governmental - - 262,416 262,416 Total $ 102,200 $ 700,000 $ 368,016 $ 1,170,216 The City annually budgets transfers for specific purposes. Annual transfers are made as part of capital improvement plans as well as annual budgets. For the year ended December 31, 2012, the City made the following one -time transfers: • The Technology fund transferred $78,317 to the Equipment Replacement fund to close the fund. • The Public Facilities /Office Equipment fund transferred $184,099 to the Equipment Replacement fund to close the fund. D. Long -term debt General obligation bonds. The City issues general obligation bonds to provide funds for the acquisition and construction of major capital facilities. General obligation bonds have been issued for both governmental and business -type activities. These bonds are reported in the proprietary funds if they are expected to be repaid from proprietary fund revenues. In addition, general obligation bonds have been issued to refund special assessments related bonds. General obligation bonds are direct obligations and pledge the full faith and credit of the City. The City has the following general obligation debt: -68- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 Note 3: DETAILED NOTES ON ALL FUNDS - CONTINUED General obligation revenue bonds The following bonds were issued to finance capital improvements in the enterprise funds. They will be retired from net revenues of the enterprise funds. Lease revenue bonds The City also issues bonds where the City pledges income derived from the acquired or constructed assets to pay debt service. Revenue bonds outstanding at year end are as follows: Description Public Safety Fire Facility, Refunding Series 2007A Public Safety Police Facility, Refunding Series 2007B Public Safety Fire Facility, Refunding Series 20070 Public Project Lease Revenue Bonds, Series 2008A Total Lease Revenue Bonds Balance Authorized Interest Issue Maturity at and Issued Rate Date Date Year End S 4,130,000 5.30-5.40 % 4,285,000 3.50-4.25 1,585,000 3.75 -5.00 1,310,000 2.85-4.80 -69- 01 /01 /07 02/01/23 S 3,480,000 01 /01 /07 02/01/23 3,610,000 01 /01 /07 02/01/22 1,285,000 08/19/08 12/01/28 1,140, 000 S 9,515,000 Balance Authorized Interest Issue Maturity at Description and Issued Rate Date Date Year End G.O. Water Revenue Bonds of 2005 1,525,000 3.50-4.25 % 06 /01 /05 01 /01 /25 S 1,100,000 G.O. Water Revenue Bonds of 2006 1,450,000 4.00 11/29/06 01 /01 /22 1,400,000 Total G.O. Revenue Bonds S 2,500,000 Annual debt service requirements to maturity for general obligation revenue bonds are as follows: G.O. Revenue Bonds Year Ending Business -type Activities December 31, Principal Interest Total 2013 S 185,000 S 96,103 S 281,103 2014 190,000 88,940 278,940 2015 195,000 81,555 276,555 2016 205,000 73,808 278,808 2017 215,000 65,595 280,595 2018-2022 1,200,000 190,898 1,390,898 2023-2025 310,000 19,974 329,974 Total $ 2,500,000 S 616,873 S 3,116,873 Lease revenue bonds The City also issues bonds where the City pledges income derived from the acquired or constructed assets to pay debt service. Revenue bonds outstanding at year end are as follows: Description Public Safety Fire Facility, Refunding Series 2007A Public Safety Police Facility, Refunding Series 2007B Public Safety Fire Facility, Refunding Series 20070 Public Project Lease Revenue Bonds, Series 2008A Total Lease Revenue Bonds Balance Authorized Interest Issue Maturity at and Issued Rate Date Date Year End S 4,130,000 5.30-5.40 % 4,285,000 3.50-4.25 1,585,000 3.75 -5.00 1,310,000 2.85-4.80 -69- 01 /01 /07 02/01/23 S 3,480,000 01 /01 /07 02/01/23 3,610,000 01 /01 /07 02/01/22 1,285,000 08/19/08 12/01/28 1,140, 000 S 9,515,000 CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 lemmim 11 ON 1I1I1111110631 Y ORK17►/:1111 11110 1RWK 10 Y 1►1111111 The Public Safety Fire Facility Refunding Series 2007A, 2007B and 20070 were issued for construction of the public safety building, which there is a lease receivable from the South Lake Minnetonka Police and Excelsior Fire District. This debt is excluded from the calculation of net position invested in capital assets, net of related debt as the building is reported on the South Lake Minnetonka Police and Excelsior Fire District as a capital asset. Refer to Note 5 A and B for further information. Annual debt service requirements to maturity for revenue bonds are as follows: Year Ending December 31, 2013 2014 2015 2016 2017 2018-2022 2023-2027 2028 Total Changes in long -term liabilities Lease Revenue Bonds Governmental Activities Principal Interest Total $ 675,000 $ 385,963 $ 1,060,963 705,000 356,227 1,061,227 735,000 325,081 1,060,081 770,000 290,863 1,060,863 800,000 257,068 1,057,068 4,525,000 770,631 5,295,631 1,210,000 101,604 1,311,604 95,000 4,559 99,559 147,969 $ 9,515,000 $ 2,491,996 $ 12,006,996 Long -term liability activity for the year ended December 31, 2012, was as follows: Business -type activities General obligation revenue bonds $ 2,675,000 $ - $ (175,000) $ 2,500,000 $ 185,000 -70- Beginning Ending Due Within Balance Increases Decreases Balance One Year Governmental activities Lease revenue bonds $ 10,170,000 $ - $ (655,000) $ 9,515,000 $ 675,000 Compensated absences 184,782 147,408 (150,428) 181,762 147,969 Total $ 10,354,782 $ 147,408 $ (805,428) $ 9,696,762 $ 822,969 Business -type activities General obligation revenue bonds $ 2,675,000 $ - $ (175,000) $ 2,500,000 $ 185,000 -70- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 Note 4: DEFINED BENEFIT PENSION PLAN - STATEWIDE A. Plan description All full -time and certain part-time employees of the City are covered by defined benefit plans administered by the Public Employees Retirement Association of Minnesota (PERA). PERA administers the General Employees Retirement Fund (GERF), which is a cost - sharing, multiple - employer retirement plan. This plan is established and administered in accordance with Minnesota statutes, chapters 353 and 356. GERF members belong to either the Coordinated Plan or the Basic Plan. Coordinated Plan members are covered by Social Security and Basic Plan members are not. All new members must participate in the Coordinated Plan. PERA provides retirement benefits as well as disability benefits to members, and benefits to survivors upon death of eligible members. Benefits are established by Minnesota statute, and vest after three years of credited service. The defined retirement benefits are based on a member's highest average salary for any five successive years of allowable service, age and years of credit at termination of service. Two methods are used to compute benefits for PERA's Coordinated and Basic Plan members. The retiring member receives the higher of a step -rate benefit accrual formula (Method 1) or a level accrual formula (Method 2). Under Method 1, the annuity accrual rate for a Basic Plan member is 2.20 percent of average salary for each of the first 10 years of service and 2.70 percent for each remaining year. The annuity accrual rate for a Coordinated Plan member is 1.20 percent of average salary for each of the first 10 years and 1.70 percent for each remaining year. Under Method 2, the annuity accrual rate is 2.70 percent of average salary for Basic Plan members and 1.70 percent for Coordinated Plan members for each year of service. For all GERF members hired prior to July 1, 1989 whose annuity is calculated using Method 1, a full annuity is available when age plus years of service equal 90. Normal retirement age is 65 for Basic and Coordinated members hired prior to July 1, 1989. Normal retirement age is the age for unreduced Social Security benefits capped at 66 for Coordinated members hired on or after July 1, 1989. A reduced retirement annuity is also available to eligible members seeking early retirement. There are different types of annuities available to members upon retirement. A single -life annuity is a lifetime annuity that ceases upon the death of the retiree -- no survivor annuity is payable. There are also various types of joint and survivor annuity options available which will be payable over joint lives. Members may also leave their contributions in the fund upon termination of public service in order to qualify for a deferred annuity at retirement age. Refunds of contributions are available at any time to members who leave public service, but before retirement benefits begin. The benefit provisions stated in the previous paragraphs of this section are current provisions and apply to active plan participants. Vested, terminated employees who are entitled to benefits but are not receiving them yet are bound by the provisions in effect at the time they last terminated their public service. PERA issues a publicly available financial report that includes financial statements and required supplementary information for GERF. That report may be obtained on the Internet at mnpera.org, by writing to PERA, 60 Empire Drive #200, St. Paul, Minnesota, 55103 -2088 or by calling (651) 296 -7460 or (800) 652 -9026. B. Funding policy Minnesota statutes, chapter 353 sets the rates for employer and employee contributions. These statutes are established and amended by the Minnesota legislature. The City makes annual contributions to the pension plans equal to the amount required by Minnesota statutes. GERF Basic Plan members and Coordinated Plan members were required to contribute 9.10 percent and 6.25 percent, respectively, of their annual covered salary in 2012. The City is required to contribute the following percentages of annual covered payroll: 11.78 percent for Basic Plan GERF members and 7.25 percent for Coordinated Plan GERF members. The City's contributions to the GERF for the years ending December 31, 2012, 2011 and 2010 were $99,678, $100,570, and $89,850, respectively. The City's contributions were equal to the contractually required contributions for each year as set by Minnesota statute. -71- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 1►6r Mill1►Y IMA Dieu IUl N 0D A. South Lake Minnetonka Police Department The City participates in a joint powers agreement with the cities of Excelsior, Greenwood and Tonka Bay, which establishes the South Lake Minnetonka Police Department (Department) for the purpose of providing police protection within the four communities. The agreement creates a coordinating committee, comprised of the Mayors of each participating community, as the governing body, which meets quarterly. Each year, the coordinating committee adopts an operating budget, which is approved by all participating cities. The cost of the operating budget is divided between the participating cities based upon a fixed percentage of the total municipal revenue allocated to each City. Any budget shortfall is made up first from department reserves, with any excess shortfall assessed to each participating community according to the formula. The most recent year of audited information is December 31, 2012. Separate financial statements can be obtained by writing to the South Lake Minnetonka Police Department, 24150 Smithtown Road, Shorewood, Minnesota 55331. The following is a summary of the Department's Statement of Net Position as of December 31, 2012 and 2011: Assets Liabilities Net position Total liabilities and net position SOUTH LAKE MINNETONKA POLICE DEPARTMENT SUMMARY OF STATEMENTS OF NET POSITION DECEMBER 31, 2012 AND 2011 2012 2011 S 5,339,920 S 5,461,572 S 3,895,391 S 4,171,056 1,444,529 1,290,516 S 5,339,920 S 5,461,572 The following is a summary of the Department's statement of activities for the years ended December 31, 2012 and 2011: Revenues Expenses Net revenues General revenues Change in net position Net position, January 1 Net position, December 31 SOUTH LAKE MINNETONKA POLICE DEPARTMENT SUMMARY STATEMENTS OF ACTIVITIES FOR THE YEARS ENDED DECEMBER 31, 2012 AND 2011 -72- 2012 S 2,691,104 2,562,528 128,576 2011 S 2,630,997 2,468,543 162,454 25,437 46,460 154,013 1 290 516 208,914 1 081 602 S 1,444,529 S 1,290,516 CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 1►6r Mill lem ILIA Dieu IUl N Wwefflel Y 1►11110 VC B. Excelsior Fire District In August of 2000, the cities of Deephaven, Excelsior, Greenwood, Shorewood and Tonka Bay entered a joint powers agreement to provide fire protection and medical response service to their residents and created an entity called the Excelsior Fire District (the District). The Board of Directors is comprised of ten members and five alternate members. Each member City appoints two representatives on the Board of Directors and one alternate. The City is billed for service based on a formula that determines its share of the total expenditures. Separate financial statements can be obtained by writing to the Excelsior Fire District, 24100 Smithtown Road, Shorewood, Minnesota 55331. The following is a summary of the District's Statement of Net Position as of December 31, 2012 and 2011: EXCELSIOR FIRE DISTRICT SUMMARY OF STATEMENTS OF NET POSITION DECEMBER 31, 2012 AND 2011 Assets Liabilities Net position Total liabilities and net position 7111 7 7111 1 S 8,105,724 S 8,041,260 S 5,277,656 S 5,521,156 2,828,068 2,520,104 S 8,105,724 S 8,041,260 The following is a summary of the District's statement of activities for the years ended December 31, 2012 and 2011: Revenues Expenses Net revenues General revenues Change in net position Net position, January 1 Net position, December 31 EXCELSIOR FIRE DISTRICT SUMMARY STATEMENTS OF ACTIVITIES FOR THE YEARS ENDED DECEMBER 31, 2012 AND 2011 -73- 7111 7 7111 1 S 1,557,428 S 1,551,957 1,251,845 1,319,634 305,583 232,323 2,381 19,404 307,964 251,727 2,520,104 2,268,377 S 2,828,068 S 2,520,104 CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 1► m • Aey Y 1101.14lei IN] N►i Fr Y [00 A. Risk management The City is exposed to various risks of loss related to torts; theft of, damage to and destruction of assets; errors and omissions; injuries to employees; and natural disasters for which the City carries insurance. The City obtains insurance through participation in the League of Minnesota Cities Insurance Trust (LMCIT) which is a risk sharing pool with approximately 800 other governmental units. The City pays an annual premium to LMCIT for its workers compensation and property and casualty insurance. The LMCIT is self - sustaining through member premiums and will reinsure for claims above a prescribed dollar amount for each insurance event. Settled claims have not exceeded the City's coverage in any of the past three fiscal years. Liabilities are reported when it is probable that a loss has occurred and the amount of the loss can be reasonably estimated. Liabilities, if any, include an amount for claims that have been incurred but not reported (IBNRs). The City's management is not aware of any incurred but not reported claims. B. Legal debt margin The City's statutory debt limit is $43,080,294 computed as three percent of the taxable market value of property within the City. Long -term debt issued and financed partially or entirely by special assessments, tax increments or the net revenues of enterprise fund operations is excluded from the debt limit computation. The City has no debt that is subject to the statutory debt limit. C. Southshore Community Center On July 1, 2009, the City entered into an agreement to take over operations of the Southshore Community Center. The City also contracted with Community Recreation Resources (CRR) for the operation, management, and programming of the Southshore Community Center. The contract with CRR was for the period of July 1, 2009 to July 1, 2012 with an option to renew for another three years or renegotiate. The contract was re- negotiated in January, 2012. The City agreed to pay CRR $5,000 per month for the period of January 1, 2012 to December 31, 2012. During this time, the City paid a 15 percent commission on monthly revenues to CRR. A quarterly bonus commission of five percent was due if the quarterly program and rental income exceeded $13,500. The contract was subsequently extended on a month by month basis through March 31, 2013 when CRR ceased to provide services as the Southshore Community Center management company. Note 7: SUBSEQUENT EVENT On March 6, 2013, the government issued $2,260,000 General Obligation Revenue Refunding Bonds for the purpose of refunding the 2005A Revenue Bonds. The average interest rate on the bonds is 1.04 percent and the maturity date is January 1, 2022. -74- CITY OF SHOREWOOD, MINNESOTA NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2012 1►[iM:3xf11 /IM" a VIET6001110 Y 1►[el W R 1►[f1191111 During fiscal year 2012, the City implemented several new accounting pronouncements issued by the Government Accounting Standards Board (GASB), including Statement No. 63, "Financial Reporting of Deferred Outflows of Resources, Deferred Inflows of Resources, and Net Position" and Statement No. 65, "Items Previously Reported as Assets and Liabilities ". These standards required a retroactive implementation which resulted in the restatement of beginning balances in the December 31, 2012 financial statements. Changes related to these standards are reflected in the financial statements and schedules and related disclosures included in Note 1. As a result of the restatement of beginning balances, the following schedule reconciles the previously reported December 31, 2010 balances to the December 31, 2012 financial statements: Activities/Fund Governmental activities Business -type activities Proprietary funds Water Sewer Recycling Stormwater Management Utility Total proprietary funds Net Position December 31, 2010 as Previously Reported (1) Restatement Net Position January 1, 2011 as Restated $ 17,778,488 $ (166,883) $ 17,611,605 $ 15,161,145 $ (61,867) $ 15,099,278 $ 7,627,955 $ (61,867) $ 7,566,088 5,705,107 - 5,705,107 88,263 - 88,263 1,739,820 - 1,739,820 $ 15,161,145 1 $ (61,867) $ 15,099,278 (1) Write -off of unamortized bond issuance cost balances at December 31, 2010. As a result of the restatement of beginning balances, the following schedule reconciles the previously reported December 31, 2011 balances to the December 31, 2012 financial statements: Activities /Fund Governmental activities Business -type activities Proprietary funds Water Sewer Recycling Stormwater Management Utility Total proprietary funds Net Position December 31, 2011 as Previously Reported (2) Restatement Net Position January 1, 2012 as Restated $ 17,188,372 $ (155,198) $ 17,033,174 $ 14,862,448 $ (53,602) $ 14,808,846 $ 7,656,153 5,400,530 99,028 1,706,737 $ (53,602) $ 7,602,551 5,400,530 99,028 1,706,737 $ 14,862,448 $ (53,602) $ 14,808,846 (2) Write -off of unamortized bond issuance cost balances at December 31, 2011 -75- THIS PAGE IS LEFT BLANK INTENTIONALLY -76- COMBINING AND INDIVIDUAL FUND FINANCIAL STATEMENTS AND SCHEDULES CITY OF SHOREWOOD SHOREWOOD, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2012 -77- THIS PAGE IS LEFT BLANK INTENTIONALLY -78- NONMAJOR GOVERNMENTAL FUNDS NONMAJOR SPECIAL REVENUE FUNDS Special revenue funds are used to account for revenue derived from specific taxes or other earmarked revenue sources. They are usually required by Minnesota statute or local ordinances to finance particular functions or other activities of government. Southshore Community Center - This fund was established to account for the resources accumulated from events and activities held at the City's community center, and the payment of expenditures related to operations of the community center. The City has committed charges for services revenues for operations. -79- CITY OF SHOREWOOD, MINNESOTA Exhibit A-1 NONMAJOR GOVERNMENTAL FUNDS COMBINING BALANCE SHEET DECEMBER 31, 2012 Special -80- Southshore Total Community Capital Nonmajor Center Projects Funds ASSETS Cash and temporary investments S - S 635,945 S 635,945 Receivables Accrued interest - 3,244 3,244 Lease - 277,892 277,892 TOTAL ASSETS S - S 917,081 S 917,081 LIABILITIES Accounts and contracts payable S 3,138 S 14,206 S 17,344 Due to other funds 37,611 21,394 59,005 TOTAL LIABILITIES 40,749 35,600 76,349 FUND BALANCES Assigned to capital outlay - 916,057 916,057 Unassigned (40,749) (34,576) (75,325) TOTAL FUND BALANCES (40,749) 881,481 840,732 TOTAL LIABILITIES AND FUND BALANCES S - S 917,081 S 917,081 -80- CITY OF SHOREWOOD, MINNESOTA NONMAJOR GOVERNMENTAL FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES FOR THE YEAR ENDED DECEMBER 31, 2012 Special REVENUES Charges for services Interest on investments Miscellaneous Park dedication fees Contributions and donations Other IC0ir :UlRILTA0641M0 EXPENDITURES Current General government Culture and recreation Capital outlay Public works Culture and recreation TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Transfers in Transfers out TOTAL OTHER FINANCING SOURCES (USES) 16410 rQ: I<U641111 807,111 D :11►[e 0 FUND BALANCES, JANUARY 1 FUND BALANCES, DECEMBER 31 -81- Exhibit A -2 Southshore 6,124 Total Community Capital Nonmajor Center Projects Funds S 60,014 S - S 60,014 - 9,638 9,638 - 10,000 10,000 1,219 - 1,219 866 7,183 8,049 62,099 26,821 88,920 - 6,124 6,124 123,126 2,856 125,982 - 222,614 222,614 - 67,704 67,704 123,126 299,298 422,424 (61,027) (272,477) (333,504) 13,600 354,416 368,016 - (262,416) (262,416) 13,600 92,000 105,600 (47,427) (180,477) (227,904) 6,678 1,061,958 1,068,636 S (40,749) S 881,481 S 840,732 THIS PAGE IS LEFT BLANK INTENTIONALLY -82- NONMAJOR CAPITAL PROJECTS FUNDS Capital projects funds are used to account for the acquisition and construction of major capital facilities other than those financed by enterprise funds. Public Facilities - This fund was established to account for capital improvement projects for municipal public facilities. Park Capital Improvement - This fund accounts for park land acquisition and other capital improvements in the City parks. Equipment Replacement - This fund was established for the purpose of funding the replacement of capital equipment. MSA Construction - This fund was established to account for the accumulation of Municipal State Aid (MSA) to fund the periodic reconstruction of MSA designated roads. Trail Construction — This fund was established for the purpose of funding future trail improvements and construction Technology - This fund was established for the replacement of office equipment, computers, and technology for municipal operations at the City offices. -83- CITY OF SHOREWOOD, MINNESOTA NONMAJOR CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET DECEMBER 31, 2012 ASSETS Cash and temporary investments Receivables Accrued interest Lease TOTAL ASSETS LIABILITIES Accounts and contracts payable Due to other funds TOTAL LIABILITIES FUND BALANCES Assigned to capital outlay Unassigned TOTAL FUND BALANCES TOTAL LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCES -84- 401 402 403 Park Public Capital Equipment Facilities Improvement Replacement S - S 167,792 S 333,796 - 635 2,005 - - 277,892 S - S 168,427 S 613,693 S - S - S - - 168,427 613,693 - 168,427 613,693 $ - S 168,427 S 613,693 Exhibit B -1 405 406 408 MSA Trail Construction Construction Technology Total S 133,389 S - S 968 S 635,945 548 56 - 3,244 S 133,937 S 56 S 968 S 917,081 $ - S 13,238 S 968 S 14,206 - 21,394 - 21,394 - 34,632 968 35,600 133,937 - - 916,057 - (34,576) - (34,576) 133,937 (34,576) - 881,481 S 133,937 S 56 S 968 S 917,081 -85- CITY OF SHOREWOOD, MINNESOTA NONMAJOR CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES FOR THE YEAR ENDED DECEMBER 31, 2012 401 Public REVENUES Interest on investments Miscellaneous Park dedication fees Other TOTAL REVENUES EXPENDITURES Current General government Culture and recreation Capital outlay Public works Culture and recreation TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Transfers in Transfers out TOTAL OTHER FINANCING SOURCES (USES) NET CHANGE IN FUND BALANCES FUND BALANCES, JANUARY 1 FUND BALANCES, DECEMBER 31 -86- $ 783 5,250 6,033 23 402 403 Park - Capital Equipment Improvement Replacement $ 1,273 $ 5,919 10,000 - - 1,933 11,273 7,852 - 5,133 - - 222,614 - 35,804 - 23 35,804 227,747 6,010 (24,531) (219,895) - 42,000 312,416 (184,099) - - (184,099) 42,000 312,416 (178,089) 17,469 92,521 178,089 150,958 521,172 $ - $ 168,427 $ 613,693 405 M SA Construction S 1,287 1,287 Exhibit B -2 406 408 Trail Construction Technology Total 180 S 196 S 9,638 180 - 2,856 - 31,900 - 34,756 - 10,000 - 7,183 196 26,821 968 6,124 - 2,856 - 222,614 - 67,704 968 299,298 1,287 (34,576) (772) (272,477) - - - 354,416 - - (78,317) (262,416) - - (78,317) 92,000 1,287 (34,576) (79,089) (180,477) 132,650 - 79,089 1,061,958 S 133,937 $ (34,576) S - S 881,481 -87- THIS PAGE IS LEFT BLANK INTENTIONALLY -88- NONMAJOR PROPRIETARY FUNDS NONMAJOR ENTERPRISE FUNDS Enterprise funds are used to account for fund activities of the City that operate in a manner similar to private businesses. Recycling - This fund accounts for the activities of the City's recycling program. Stormwater Management Utility - This fund accounts for the activities of the City's stormwater management system. -89- CITY OF SHOREWOOD, MINNESOTA NONMAJOR PROPRIETARY FUNDS COMBINING STATEMENTS OF NET POSITION DECEMBER 31, 2012 AND 2011 ASSETS CURRENT ASSETS Cash and temporary investments Receivables Accrued interest Accounts Special assessments 1 r63 rvcKo:AR 0641 rvo 00 NONCURRENT ASSETS Special assessments receivable Capital assets Land Construction in progress Infrastructure Less accumulated depreciation NET CAPITAL ASSETS TOTAL NONCURRENT ASSETS TOTAL ASSETS LIABILITIES CURRENT LIABILITIES Accounts and contracts payable Accrued salaries payable TOTAL LIABILITIES NET POSITION Net investment in capital assets Unrestricted IC6lr:U1►1 ONK61311[07►1 Business -type Activities - Enterprise Funds 621 631 Recycling Stormwater Management Utility 2012 2011 2012 2011 $ 44,454 $ 53,146 $ 82,479 $ 214,142 225 54 629 286 42,440 40,537 51,330 79,457 737 668 1,753 1,797 87,856 94,405 136,191 295,682 4,992 4,699 6,782 6,079 - - 434,113 434,113 - - - 174,603 - - 1,292,577 1,009,997 - - (237,941) (205,627) - - 1,488,749 1,413,086 4,992 4,699 1,495,531 1,419,165 92,848 99,104 1,631,722 1,714,847 412 - 3,488 7,422 412 76 3,488 8,110 - - 1,488,749 1,413,086 92,436 99,028 139,485 293,651 $ 92,436 $ 99,028 $ 1,628,234 $ 1,706,737 -90- Exhibit C -1 Totals 2012 2011 $ 126,933 $ 267,288 854 340 93,770 119,994 2,490 2,465 224,047 390,087 11,774 10,778 434,113 434,113 - 174,603 1,292,577 1,009,997 (237,941) (205,627) 1,488,749 1,413,086 1 GOO G72 1 All QCA 1,724,570 1,813,951 3,900 7,422 -7,< n 3,900 8,186 1,488,749 1,413,086 231,921 392,679 $ 1,720,670 $ 1,805,765 -91- CITY OF SHOREWOOD, MINNESOTA NONMAJOR PROPRIETARY FUNDS COMBINING STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR THE YEARS ENDED DECEMBER 31, 2012 AND 2011 OPERATING REVENUES Charges for services OPERATING EXPENSES Personal services Supplies Repairs and maintenance Depreciation Professional services Contracted services Other TOTAL OPERATING EXPENSES [elm I 1.11111641 fRe7Xl NONOPERATING REVENUES Interest on investments Other income TOTAL NONOPERATING REVENUES Ca 0@01311101641 NET POSITION, JANUARY 1 NET POSITION, DECEMBER 31 Business -type Activities - Enterprise Funds 621 631 Recycling Stormwater Management Utility S 157,585 S 151,894 S 193,931 S 195,970 6,493 6,181 57,611 44,715 14,922 1,634 1,685 3,565 - - 30,030 88,004 - - 32,314 25,250 - - 19,783 29,632 166,162 166,668 131,488 41,752 136 374 935 117 187,713 174,857 273,846 233,035 (30,128) (22,963) (79,915) (37,065) 529 142 1,412 3,882 23,007 33,586 - 100 23,536 33,728 1,412 3,982 (6,592) 10,765 (78,503) (33,083) 99,028 88,263 1,706,737 1,739,820 S 92,436 S 99,028 S 1,628,234 S 1,706,737 -92- Exhibit C -2 Business -type Activities - Enterprise Funds Totals 2012 2011 $ 351,516 $ 347,864 64,104 50,896 16,607 5,199 30,030 88,004 32,314 25,250 19,783 29,632 297,650 208,420 1 071 491 461,559 407,892 (110,043) (60,028) 1,941 4,024 23,007 33,686 24,948 37,710 (85,095) (22,318) 1,805,765 1,828,083 $ 1,720,670 $ 1,805,765 -93- CITY OF SHOREWOOD, MINNESOTA NONMAJOR PROPRIETARY FUNDS COMBINING STATEMENTS OF CASH FLOWS FOR THE YEARS ENDED DECEMBER 31, 2012 AND 2011 CASH FLOWS FROM OPERATING ACTIVITIES Receipts from customers and users Other receipts related to operations Payments to suppliers, contractors and other governments Payments to employees NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Acquisition of capital assets CASH FLOWS FROM INVESTING ACTIVITIES Interest received on investments NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS CASH AND CASH EQUIVALENTS, JANUARY 1 CASH AND CASH EQUIVALENTS, DECEMBER 31 RECONCILIATION OF OPERATING INCOME (LOSS) TO NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES Operating income (loss) Adjustments to reconcile operating income (loss) to net cash provided (used) by operating activities Other income related to operations Depreciation (Increase) decrease in assets Accounts receivable Special assessments receivable Increase (decrease) in liabilities: Accounts payable Accrued salaries payable NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES NONCASH CAPITAL AND RELATED FINANCING ACTIVITIES Capital assets purchased on account Business -type Activities Enterprise Funds 621 631 Recycling Stormwater Management Utility 2012 2011 2012 2011 $ 155,320 $ 151,025 $ 221,399 $ 168,439 23,007 33,586 - 100 (180,808) (169,072) (184,931) (161,166) (6,569) (6,105) (58,299) (44,896) (9,050) 9,434 (21,831) (37,523) - - (110,901) (418,085) 358 322 1,069 4,232 (8,692) 9,756 (131,663) (451,376) 53,146 43,390 214,142 665,518 $ 44,454 $ 53,146 $ 82,479 $ 214,142 $ (30,128) $ (22,963) $ (79,915) $ (37,065) 23,007 33,586 - 100 - - 32,314 25,250 (1,903) 220 28,127 (27,987) (362) (1,089) (659) 456 412 (396) (1,010) 1,904 (76) 76 (688) (181) $ (9,050) $ 9,434 $ (21,831) $ (37,523) $ - $ - $ - $ 2,924 -94- Exhibit C -3 Business -type Activities - Enterprise Funds Totals 2012 2011 $ 376,719 $ 319,464 23,007 33,686 (365,739) (330,238) (64,868) (51,001) (30,881) (28,089) (110,901) (418,085) 1,427 4,554 (140,355) (441,620) 267,288 708,908 $ 126,933 $ 267,288 $ (110,043) $ (60,028) 23,007 33,686 32,314 25,250 26,224 (27,767) (1,021) (633) (598) 1,508 (764) (105) $ (30,881) $ (28,089) $ - $ 2,924 -95- THIS PAGE IS LEFT BLANK INTENTIONALLY -96- -97- CITY OF SHOREWOOD, MINNESOTA Exhibit D -1 GENERALFUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - CONTINUED ON THE FOLLOWING PAGES FOR THE YEAR ENDED DECEMBER 31, 2012 (With comparative actual amounts for the year ended December 31, 2011) 2012 2011 Budgeted Amounts Actual Variance with Actual Original Final Amounts Final Budget Amounts REVENUES Taxes General property taxes S 4,649,909 S 4,649,909 S 4,670,529 S 20,620 S 4,666,192 Fiscal disparities 113,410 113,410 113,410 - 121,003 Total 4,763,319 4,763,319 4,783,939 20,620 4,787,195 Licenses and permits Business 13,850 13,850 15,866 2,016 23,393 Nonbusiness 95,350 95,350 159,221 63,871 150,726 Total 109,200 109,200 175,087 65,887 174,119 Intergovernmental State Property tax credits - - 245 245 - Other 70,401 70,401 75,857 5,456 72,968 Total 70,401 70,401 76,102 5,701 72,968 Charges for services General government 5,650 5,650 21,928 16,278 608 Culture and recreation 29,425 29,425 39,683 10,258 30,133 Total 35,075 35,075 61,611 26,536 30,741 Fines and forfeitures 54,500 54,500 66,230 11,730 52,635 Interest on investments 45,000 45,000 25,602 (19,398) 20,021 Miscellaneous revenue Refunds and reimbursements - - 67,032 67,032 83,021 Contributions and donations - - 3,514 3,514 4,450 Other 18,900 18,900 47,278 28,378 21,856 Total 18,900 18,900 117,824 98,924 109,327 TOTAL REVENUES 5,096,395 5,096,395 5,306,395 210,000 5,247,006 -97- Administrative Personal services CITY OF SHOREWOOD, MINNESOTA Exhibit D -1 373,914 GENERALFUND Supplies SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - 17,906 6,189 - BUDGET AND ACTUAL - CONTINUED 39,935 39,935 FOR THE YEAR ENDED DECEMBER 31, 2012 (42,073) 5,138 (With comparative actual amounts for the year ended December 31, 2011) 383,505 473,828 2012 2011 144,866 Budgeted Amounts Actual Variance with Actual 4,583 Original Final Amounts Final Budget Amounts EXPENDITURES Professional services Current General government Other services and charges 199,320 Mayor and Council 190,592 8,728 Personal services S 16,800 S 16,800 S 16,794 S 6 S 16,794 Supplies 3,000 3,000 887 2,113 684 Other services and charges 86,315 86,315 80,309 6,006 76,063 Total 106,115 106,115 97,990 8,125 93,541 Administrative Personal services 319,475 319,475 373,914 (54,439) 152,678 Supplies 24,095 24,095 17,906 6,189 - Other services and charges 39,935 39,935 82,008 (42,073) 5,138 Total 383,505 383,505 473,828 (90,323) 157,816 City clerk / elections Personal services - - - - 274,427 Supplies - - - - 16,523 Other services and charges - - - - 36,717 Total - - - - 327,667 Finance Personal services 128,416 128,416 120,556 7,860 163,795 Supplies 7,300 7,300 8,041 (741) 7,785 Other services and charges 9,150 9,150 11,686 (2,536) 14,089 Total 180,733 Total 144,866 144,866 140,283 4,583 185,669 Professional services Other services and charges 199,320 199,320 190,592 8,728 188,963 Planning and zoning Personal services 170,666 170,666 181,381 (10,715) 168,156 Supplies 655 655 137 518 261 Other services and charges 9,412 9,412 7,691 1,721 8,080 Total 180,733 180,733 189,209 (8,476) 176,497 -98- CITY OF SHOREWOOD, MINNESOTA GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - CONTINUED FOR THE YEAR ENDED DECEMBER 31, 2012 (With comparative actual amounts for the year ended December 31, 2011) EXPENDITURES - CONTINUED Current - continued General government - continued Municipal building Supplies Other services and charges Total Total general government Public safety Police protection Other services and charges Fire protection Other services and charges Animal control Other services and charges Protective inspection 2012 Exhibit D -1 Budgeted Amounts Actual Variance with Actual Original Final Amounts Final Budget Amounts S 16,500 S 16,500 S 40,799 S (24,299) S 16,402 157,750 157,750 149,879 7,871 160,393 174,250 174,250 190,678 (16,428) 176,795 1,188,789 1,188,789 1,282,580 (93,791) 1,306,948 989,085 989,085 992,711 (3,626) 997,605 332,805 332,805 331,987 818 337,130 - (834) Personal services 118,049 118,049 114,396 3,653 122,171 Supplies 200 200 242 (42) 154 Other services and charges 5,450 5,450 5,813 (363) 4,438 Total 123,699 123,699 120,451 3,248 126,763 Total public safety 1,445,589 1,445,589 1,445,149 440 1,460,664 Public works General maintenance Personal services 418,633 418,633 417,331 1,302 272,414 Supplies 172,575 172,575 120,685 51,890 79,175 Other services and charges 134,439 134,439 121,759 12,680 43,832 Total 725,647 725,647 659,775 65,872 395,421 -99- -100- CITY OF SHOREWOOD, MINNESOTA Exhibit D -1 GENERALFUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - CONTINUED FOR THE YEAR ENDED DECEMBER 31, 2012 (With comparative actual amounts for the year ended December 31, 2011) 2012 2011 Budgeted Amounts Actual Variance with Actual Original Final Amounts Final Budget Amounts EXPENDITURES - CONTINUED Current - continued Public works - continued Streets and highways Personal services $ - $ - $ - $ - $ 95,619 Supplies - - - - 73,044 Other services and charges - - - - 25,340 Total - - - - 194,003 Snow and ice removal Personal services 55,024 55,024 27,502 27,522 37,959 Supplies 45,117 45,117 29,509 15,608 29,462 Total 100, 141 100, 141 57,011 43, 130 67,421 Traffic control Supplies - - - - 6,467 Other services and charges - - - - 54,307 Total - - - - 60,774 Sanitation and waste removal Personal services - - - - 627 Supplies - - - - 30 Other services and charges - - - - 7,847 Total - - - - 8,504 Tree maintenance Personal services - - - - 21,261 Supplies - - - - 331 Other services and charges - - - - 8,433 Total - - - - 30,025 City engineer Personal services 90,872 90,872 84,615 6,257 96,220 Supplies 200 200 144 56 496 Other services and charges 11,960 11,960 21,689 (9,729) 13,549 Total 103,032 103,032 106,448 (3,416) 110,265 Total public works 928,820 928,820 823,234 105,586 866,413 -100- CITY OF SHOREWOOD, MINNESOTA GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - CONTINUED FOR THE YEAR ENDED DECEMBER 31, 2012 (With comparative actual amounts for the year ended December 31, 2011) EXPENDITURES - CONTINUED Current - continued Public works - continued Culture and recreation Personal services Supplies Other services and charges Total culture and recreation Total current expenditures Capital outlay General government Public safety Public works 2012 Exhibit D -1 Budgeted Amounts Actual Variance with Actual Original Final Amounts Final Budget Amounts S 169,344 S 169,344 S 139,022 S 30,322 S 152,118 19,800 19,800 18,266 1,534 17,393 60,650 60,650 48,254 12,396 87,090 249,794 249,794 205,542 44,252 256,601 3,812,992 3,812,992 3,756,505 56,487 3,890,626 503,038 503,038 2,811 (2,811) 2,913 503,038 - 500,766 - - 1,057 Total capital outlay 503,038 503,038 505,849 (2,811) 504,736 TOTAL EXPENDITURES 4,316,030 4,316,030 4,262,354 53,676 4,395,362 EXCESS OF REVENUES OVER EXPENDITURES 780,365 780,365 1,044,041 263,676 851,644 OTHER FINANCING SOURCES (USES) Transfers in 40,000 40,000 - (40,000) 40,000 Transfers out (907,800) (907,800) (907,800) - (930,409) TOTAL OTHER FINANCING SOURCES (USES) (867,800) (867,800) (907,800) (40,000) (890,409) NET CHANGE IN FUND BALANCES (87,435) (87,435) 136,241 223,676 (38,765) FUND BALANCES, JANUARY 1 3,488,227 3,488,227 3,488,227 - 3,526,992 FUND BALANCES, DECEMBER 31 S 3,400,792 S 3,400,792 S 3,624,468 S 223,676 S 3,488,227 -101- ASSETS Cash and temporary investments Lease receivable TOTAL ASSETS LIABILITIES Accounts payable DEFERRED INFLOWS OF RESOURCES Unavailable revenue - lease FUND BALANCES Restricted for debt service TOTAL LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCES CITY OF SHOREWOOD, MINNESOTA 3,610,000 Exhibit E -1 DEBT SERVICE FUNDS 12,352 2,114 21 COMBINING BALANCE SHEET DECEMBER 31, 2012 2007A 2007B 2007C 2008 Public Safety Public Safety Public Safety Lease Revenue Building Building Building Bond Total $ 13,097 $ 2,854 $ 761 $ 3,213 $ 19,925 3,480,000 3,610,000 1,285,000 - 8,375,000 $ 3,493,097 $ 3,612,854 $ 1,285,761 $ 3,213 $ 8,394,925 $ 745 740 740 $ - $ 2,225 3,480,000 3,610,000 1,285,000 - 8,375,000 12,352 2,114 21 3,213 17,700 $ 3,493,097 $ 3,612,854 $ 1,285,761 $ 3,213 $ 8,394,925 -102- CITY OF SHOREWOOD, MINNESOTA DEBT SERVICE FUNDS COMBINING SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES FOR THE YEAR ENDED DECEMBER 31, 2012 2007A 2007B 2007C 2008 Public Safety Public Safety Public Safety Lease Revenue Building Building Building Bond REVENUES Lease payments S 401,125 S 416,178 S 161,441 S - Interest on investments 746 - - - TOTAL REVENUES 401,871 416,178 161,441 - EXPENDITURES Debt service Principal Interest and service charges TOTAL EXPENDITURES DEFICIENCY OF REVENUES UNDER EXPENDITURES OTHER FINANCING SOURCES Transfers in Transfer out Exhibit E -2 Total S 978,744 746 245,000 255,000 105,000 50,000 655,000 160,135 165,918 61,176 52,200 439,429 NET CHANGE IN FUND BALANCES (8,786) 405,135 420,918 166,176 102,200 1,094,429 2,889 3,199 3,213 (3,264) (4,740) (4,735) (102,200) (114,939) S 17,700 3,824 3,965 1,557 102,200 111,546 (9,346) - - - (9,346) TOTAL OTHER FINANCING SOURCES (USES) (5,522) 3,965 1,557 102,200 102,200 NET CHANGE IN FUND BALANCES (8,786) (775) (3,178) - (12,739) FUND BALANCES, JANUARY 1 21,138 2,889 3,199 3,213 30,439 FUND BALANCES, DECEMBER 31 S 12,352 S 2,114 S 21 S 3,213 S 17,700 -103- CITY OF SHOREWOOD, MINNESOTA Exhibit F -1 AGENCYFUND COMBINING SCHEDULE OF CHANGES IN ASSETS AND LIABILITIES FOR THE YEAR ENDED DECEMBER 31, 2012 Developer Escrow Accounts ASSETS Cash and temporary investments LIABILITIES Escrow deposits payable Balance Balance January 1 Additions Deductions December 31 S 68,508 S 12,038 S (33,459) S 47,087 $ 68,508 S 12,038 S (33,459) S 47,087 -104- CITY OF SHOREWOOD, MINNESOTA SUPPLEMENTARY INFORMATION SUMMARY FINANCIAL REPORT REVENUES AND EXPENDITURES FOR GENERAL OPERATIONS GOVERNMENTAL FUNDS FOR THE YEARS ENDED DECEMBER 31, 2012 AND 2011 REVENUES Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeits Interest on investments Miscellaneous TOTAL REVENUES Per Capita EXPENDITURES Current General government Public safety Public works Culture and recreation Capital outlay General government Public safety Public works Culture and recreation Debt service Principal Interest and service charges TOTAL EXPENDITURES Per Capita Total Long -term Indebtedness Per Capita General Fund Balance - December 31 Per Capita Total 2012 2011 $ 4,783,939 $ 4,787,195 175,087 174,119 76,102 72,968 121,625 102,500 66,230 52,635 61,584 56,705 1,115,836 1,032,566 $ 6,400,403 $ 6,278,688 $ 875 $ 859 $ 1,288,704 $ 1,306,948 1,445,149 1,460,664 823,234 866,413 331,524 343,326 2,811 34,733 503,038 500,766 655,125 814,854 69,084 106,648 655,000 625,000 439,429 447,307 $ 6,213,098 $ 6,506,659 $ 850 $ 890 S_9,515 ,O00 $ 10,170,000 $ 1,301 $ 1,392 $ 3,624,468 $ 3,488,227 $ 496 $ 477 Exhibit G -1 Percent Increase (Decrease) (0.07) % 0.56 4.30 18.66 25.83 8.60 8.06 1.94 % 1.87 % (1.40) % (1.06) (4.98) (3.44) (91.91) 0.45 (19.60) (35.22) 4.80 (1.76) (4.51) % (4.58) % (6.44) % (6.50) The purpose of this report is to provide a summary of financial information concerning the City of Shorewood to interested citizens. The complete financial statements may be examined at City Hall, 5755 Country Club Road, Shorewood, Minnesota 55331. Questions about this report should be directed to Bruce DeJong, Finance Director at (952)- 474 -3236. -105- 3.91 % 3.84 THIS PAGE IS LEFT BLANK INTENTIONALLY -106- STATISTICAL SECTION (UNAUDITED) CITY OF SHOREWOOD SHOREWOOD, MINNESOTA FOR THE YEAR ENDED DECEMBER 31, 2012 -107- THIS PAGE IS LEFT BLANK INTENTIONALLY -108- STATISTICAL SECTION (UNAUDITED) This part of the City of Shorewood's comprehensive annual financial report presents detailed information as a context for understanding what the information in the financial statements, note disclosures, and required supplementary information says about the government's overall financial health. Financial trends These schedules contain trend information to help the reader understand how the government's financial performance and well- being have changed over time. Revenue capacity These schedules contain information to help the reader assess the government's most significant local revenue source, the property tax. Debt capacity These schedules present information to help the reader assess the affordability of the government's current levels of outstanding debt and the government's ability to issue additional debt in the future. Demographic and economic information These schedules offer demographic and economic indicators to help the reader understand the environment within which the government's financial activities take place. Operating information These schedules contain service and infrastructure data to help the reader understand how the information in the government's financial report relocates to the services the government provides and the activities it performs. -109- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) NET POSITION BY COMPONENT LAST EIGHT FISCAL YEARS (accrual basis of accounting) Governmental activities Net investment in capital assets Restricted Unrestricted Total governmental activities net position Business -type activities Net investment in capital assets Unrestricted Total business -type activities net position Total primary government Net investment in capital assets Restricted Unrestricted Total primary government Note: Net position are not available for years prior to 2004. Fiscal Year 2004 2005 2006 2007 $ 12,167,269 $ 11,372,213 $ 11,690,620 $ 10,960,550 - - 24,632 - 6,669,073 6,316,707 5,716,027 6,147,185 $ 18,836,342 $ 17,688,920 $ 17,431,279 $ 17,107,735 $ 6,427,358 $ 6,172,309 $ 5,668,683 $ 6,066,229 7,470,272 8,182,612 9,829,761 10,422,397 $ 13,897,630 $ 14,354,921 $ 15,498,444 $ 16,488,626 $ 18,594,627 $ 17,544,522 $ 17,359,303 $ 17,026,779 - - 24,632 - 14,139,345 14,499,319 15,545,788 16,569,582 $ 32,733,972 $ 32,043,841 $ 32,929,723 $ 33,596,361 -110- Table 1 Fiscal Year 2008 2009 2010 2011 2012 $ 9,430,566 $ 9,480,314 $ 9,525,991 $ 9,223,669 $ 8,487,162 7,400,859 7,909,106 8,252,497 7,964,703 7,979,370 $ 16,831,425 $ 17,389,420 $ 17,778,488 $ 17,188,372 $ 16,466,532 $ 6,631,854 $ 6,482,297 $ 6,494,996 $ 6,675,613 $ 6,494,076 10,186,824 9,449,210 8,666,149 8,186,835 8,148,173 $ 16,818,678 $ 15,931,507 $ 15,161,145 $ 14,862,448 $ 14,642,249 $ 16,062,420 $ 15,962,611 $ 16,020,987 $ 15,899,282 $ 14,981,238 17,587,683 17,358,316 16,918,646 16,151,538 16,127,543 $ 33,650,103 $ 33,320,927 $ 32,939,633 $ 32,050,820 $ 31,108,781 -111- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) CHANGES IN NET POSITION - CONTINUED ON THE FOLLOWING PAGES LAST EIGHT FISCAL YEARS (accrual basis of accounting) Expenses Governmental activities General government Public safety Public works Culture and recreation Interest on long -term debt Total governmental activities expenses Business -type activities Water Sewer Recycling Stormwater management utility Liquor Total business -type activities expenses Total expenses Program revenues Governmental activities Charges for services General government Public safety Public works Culture and recreation Operating grants and contributions Capital grants and contributions Total governmental activities program revenues Business -type activities Charges for services Water Sewer Recycling Stormwater management utility Liquor Operating grants and contributions Capital grants and contributions Total business -type activities program revenues Fiscal Year 2004 2005 2006 2007 $ 1,074,028 $ 1,222,510 $ 1,357,714 $ 1,321,971 2,972,094 1,690,903 1,806,915 1,819,250 2,451,825 5,019,967 2,275,402 1,971,571 254,081 246,381 233,881 258,906 607,862 606,189 600,723 1,000,230 3,886,643 3,743,191 4,445,154 3,658,687 7,359,890 8,785,950 6,274,635 6,371,928 591,858 567,854 488,513 636,506 735,480 740,174 785,638 952,107 106,933 105,823 124,354 91,157 106,757 73,885 171,190 63,888 2,152,411 2,006,107 2,017,217 1,885,537 3,693,439 3,493,843 3,586,912 3,629,195 $11,053,329 $12,279,793 $ 9,861,547 $10,001,123 $ 51,069 $ 112,107 $ 25,340 $ 41,475 983,684 1,055,758 1,060,506 896,731 1,080 1,575 1,800 1,960 119,594 100,910 31,730 99,800 996,967 2,404,367 395,229 132,912 3,886,643 3,743,191 4,445,154 3,658,687 2,152,394 3,674,717 1,514,605 1,172,878 620,189 649,772 1,350,041 782,549 866,350 833,939 836,175 832,956 114,987 116,517 144,886 89,934 85,978 102,649 129,708 164,413 2,199,139 2,040,314 1,984,344 1,788,835 3,886,643 3,743,191 4,445,154 3,658,687 Total program revenues $ 6,039,037 $ 7,417,908 $ 5,959,759 $ 4,831,565 -112- Table 2 Fiscal Year 2008 2009 2010 2011 2012 $ 1,483,913 $ 1,486,281 $ 1,235,098 $ 1,405,791 $ 1,331,286 1,906, 890 1,904,966 1,893,413 1,960, 894 1,947, 868 2,485,752 1,941,272 2,231,473 2,031,136 2,162,123 273,054 394,110 452,437 412,257 460,879 1,002,423 638,768 474,082 449,773 428,887 674,343 43 114,330 - - 7,152,032 6,365,397 6,286,503 6,259,851 6,331,043 657,776 659,113 643,886 690,363 689,205 921,238 955,956 980,173 1,151,626 1,065,926 96,945 99,286 173,896 174,857 187,713 106,143 106,847 131,107 233,035 273,846 16,167 129 25 - - 1,798,269 1,821,331 1,929,087 2,249,881 2,216,690 $ 8,950,301 $ 8,186,728 $ 8,215,590 $ 8,509,732 $ 8,547,733 $ 32,528 $ 34,064 $ 53,381 $ 108,394 $ 144,883 793,041 634,742 624,330 544,749 604,400 - 6,279 - 6,293 4,137 605 35,843 58,661 72,678 79,206 90,493 90,681 99,114 113,717 102,959 674,343 43 114,330 - - 1,591,010 801,652 949,816 845,831 935,585 752,338 784,318 668,676 672,793 757,395 829,117 802,252 845,043 819,496 831,640 64,629 65,112 146,002 151,894 157,585 204,618 191,157 198,593 196,070 193,931 27,950 28,488 28,762 33,586 23,007 - - - 15,000 22,400 1,878,652 1,871,327 1,887,076 1,888,839 1,985,958 $ 3,469,662 $ 2,672,979 $ 2,836,892 $ 2,734,670 $ 2,921,543 -113- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) CHANGES IN NET POSITION - CONTINUED LAST EIGHT FISCAL YEARS (accrual basis of accounting) Net revenues (expenses) Governmental activities Business -type activities Total primary government General Revenues and Other Changes in Net Position General Revenues Governmental activities Taxes Property taxes, levied for general purpose Grants and contributions not restricted to specific programs Unrestricted investment earnings Gain on sale of capital assets Transfers Total governmental activities general revenues Business -type activities Unrestricted investment earnings Gain on sale of capital assets Transfers Total business -type activities general revenues Total primary government Change in Net Position Governmental activities Business -type activities Total primary government Fiscal Year 7nnn 7!1l1G 7!1l1t� 7!1!17 S (5,207,496) S (5,111,233) S (4,760,030) S (5,199,050) 193,204 249,348 858,242 29,492 S (5,014,292) S (4,861,885) S (3,901,788) S (5,169,558) S 3,345,326 S 3,770,702 S 4,144,543 S 4,360,254 4,723 4,785 4,925 37,746 127,853 201,024 327,921 621,234 - 4,300 - - 5,000 (17,000) 25,000 (143,728) 3,482,902 3,963,811 4,502,389 4,875,506 144,163 190,943 310,281 434,072 - - - 382,890 (5,000) 17,000 (25,000) 143,728 139,163 207,943 285,281 960,690 S 3,622,065 S 4,171,754 S 4,787,670 S 5,836,196 S (1,724,594) S (1,147,422) S (257,641) S (323,544) 227 2C,7 n G7 701 1 1 n2 G72 00() 1 R7 S (1,392,227) S (690,131) S 885,882 S 666,638 Note: Changes in Net position are not available for years prior to 2004. -114- Table 2 Fiscal Year 2008 2009 2010 2011 2012 $ (5,561,022) $ (5,563,745) $ (5,336,687) $ (5,414,020) $ (5,395,458) 80,383 49,996 (42,011) (361,042) (230,732) $ (5,480,639) $ (5,513,749) $ (5,378,698) $ (5,775,062) $ (5,626,190) $ 4,582,909 $ 4,743,174 $ 4,744,348 $ 4,733,948 $ 4,761,213 19,957 4,940 4,487 4,751 6,019 641,846 333,626 132,359 56,705 61,584 - - 31,130 28,500 - 40,000 1,040,000 813,431 - - 5,284,712 6,121,740 5,725,755 4,823,904 4,828,816 289,669 102,833 85,080 62,345 64,135 (40,000) (1,040,000) (813,431) - - 249,669 (937,167) (728,351) 62,345 64,135 $ 5,534,381 $ 5,184,573 $ 4,997,404 $ 4,886,249 $ 4,892,951 $ (276,310) $ 557,995 $ 389,068 $ (590,116) $ (566,642) 330,052 (887,171) (770,362) (298,697) (166,597) $ 53,742 $ (329,176) $ (381,294) $ (888,813) $ (733,239) -115- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) FUND BALANCES OF GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS General fund Reserved Unreserved Nonspendable Unassigned Total general fund All other governmental funds Reserved Unreserved, reported in Special revenue funds Capital project funds Nonspendable Restricted Assigned Unassigned Total all other governmental funds Fiscal Year 2003 2004 2005 2006 $ - $ - $ 48,593 $ - 2,546,472 2,941,223 2,944,588 3,383,906 $ 2,546,472 $ 2,941,223 $ 2,993,181 $ 3,383,906 $ 205,350 $ 191,410 $ 238,873 $ 262,438 4,562,479 3,566,803 3,116,437 2,197,367 $ 4,767,829 $ 3,758,213 $ 3,355,310 $ 2,459,805 -116- Table 3 Fiscal Year 2007 2008 2009 2010 2011 2012 $ - $ 47,750 $ 500 $ 49,060 $ - $ - 3,761,509 3,660,359 3,555,224 3,477,932 - - - - - - 48,000 50,000 - - - - 3,440,227 3,574,468 $ 3,761,509 $ 3,708,109 $ 3,555,724 $ 3,526,992 $ 3,488,227 $ 3,624,468 $ 10,040,556 $ 10,033,342 $ 1,934,628 $ 96,333 $ - $ - - - - (17,650) - - 2,473,097 3,743,980 4,252,870 4,520,558 - - - - - - 150,068 150,068 - - - - 30,439 17,700 - - - - 4,229,528 4,368,656 - - - - - (75,325) $ 12,513,653 $ 13,777,322 $ 6,187,498 $ 4,599,241 $ 4,410,035 $ 4,461,099 -117- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS Revenues Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Special assessments Interest on investments Miscellaneous Total revenues Expenditures General government Public safety Public works Culture and recreation Capital Outlay Debt service Principal Interest and service charges Bond issuance costs Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses) Transfers in Sale of capital assets Proceeds from sale of bonds Bonds refunded Discount on long -term debt issued Transfers out Total other financing sources (uses) Net change in fund balances Debt service as a percentage of Noncapital expenditures Fiscal Year 2003 2004 2005 2006 S 3,071,853 S 3,344,442 S 3,750,633 S 4,141,539 334,424 310,055 334,720 382,408 1,947,484 1,014,410 2,432,656 365,732 48,689 44,169 50,752 45,450 88,949 81,841 90,149 79,040 10,217 10,737 6,928 895 146,331 127,853 201,024 327,921 551,167 740,030 1,134,429 1,110,860 6,199,114 5,673,537 8,001,291 6,453,845 1,038,909 1,037,043 1,169,096 1,264,509 999,049 1,028,689 1,124,620 1,257,998 420,608 477,596 570,080 626,048 164,540 168,278 167,519 169,411 10,571,521 2,896,330 4,307,721 2,571,204 46,402 48,069 384,842 486,728 460,759 637,397 611,358 607,727 13,701,788 6,293,402 8,335,236 6,983,625 (7,502,674) (619,865) (333,945) (529,780) 391,107 328,500 542,000 635,000 2,368,378 - - - (391,107) (323,500) (559,000) (610,000) 2,368,378 5,000 (17,000) 25,000 S (5,134,296) S (614,865) S (350,945) S (504,780) -118- 16.2% 11.2% 12.7% 20.1% Table 4 Fiscal Year 2007 2008 2009 2010 2011 2012 $ 4,332,741 $ 4,582,602 $ 4,703,368 $ 4,717,204 $ 4,787,195 $ 4,783,939 256,472 195,419 127,883 154,113 174,119 175,087 224,286 753,605 66,411 173,334 72,968 76,102 50,819 50,753 41,649 100,899 102,500 121,625 77,777 53,369 52,968 55,806 52,635 66,230 418 - - 333 - - 621,234 641,846 333,626 132,359 56,705 61,584 1,077,012 1,053,916 1,059,914 1,037,522 1,032,566 1,115,836 6,640,759 7,331,510 6,385,819 6,371,570 6,278,688 6,400,403 1,253,223 1,443,549 1,386,614 1,147,198 1,306,948 1,288,704 1,263,921 1,352,254 1,392,139 1,392,923 1,460,664 1,445,149 718,350 760,287 670,954 859,069 866,413 823,234 190,931 229,259 326,502 342,654 343,326 331,524 1,123,796 2,164,366 1,953,756 2,075,109 1,457,001 1,230,058 534,594 485,000 520,000 600,000 625,000 655,000 956,532 977,957 818,063 516,167 447,307 439,429 - 58,569 - - - - 6,041,347 7,471,241 7,068,028 6,933,120 6,506,659 6,213,098 599,412 (139,731) (682,209) (561,550) (227,971) 187,305 770,091 933,366 2,059,773 1,942,550 984,541 1,170,216 - - - 31,130 - - 10,000,000 1,310,000 - - - - - - (8,100,000) (1,900,000) - - (24,233) - - - - - (913,819) (893,366) (1,019,773) (1,129,119) (984,541) (1,170,216) 9,832,039 1,350,000 (7,060,000) (1,055,439) - - $ 10,431,451 $ 1,210,269 $ (7,742,209) $ (1,616,989) $ (227,971) $ 187,305 26.3% 23.1% 22.4% 19.1% 18.4% 18.3% -119- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) TAX CAPACITY, MARKET VALUE AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY (Shown by year of tax collectability) Taxable market value Personal property Real estate Total taxable market value Estimated actual value of taxable property Taxable market value as a percentage of estimated actual value Tax capacity Personal property Real estate 2003 2004 2005 2006 14,354,830 Contribution to fiscal disparities pool (184,657) (200,062) $ 3,962,200 $ 3,831,300 $ 4,130,300 $ 4,361,600 914,769, 800 1,033,460,200 1,173, 029,000 1,318,313,000 $ 9,896,826 $ 11,252,371 $ 12,836,707 $ 14,477,835 $ 918,732,000 $1,037,291,500 $1,177,159,300 $1,322,674,600 $1,066,523,800 $1,415,129,000 $1,550,488,900 $1,416,341,600 86.14 % 73.30 % 75.92 % 93.39 % $ 78,073 $ 75,409 $ 81,333 $ 85,635 9,658,728 10,980,358 12,590,290 14,269,195 Total tax capacity 9,736,801 11,055,767 12,671,623 14,354,830 Contribution to fiscal disparities pool (184,657) (200,062) (213,988) (276,939) Receivable from fiscal disparities pool 344,682 396,666 379,072 399,944 Net tax capacity $ 9,896,826 $ 11,252,371 $ 12,836,707 $ 14,477,835 Tax levies General Debt service Total Direct tax rate General Debt service Total Source: Hennepin County Assessor $ 2,851,847 $ 2,907,997 $ 3,333,864 $ 3,678,592 305,000 512,232 496,792 511,803 $ 3,156,847 $ 3,420,229 $ 3,830,656 $ 4,190,395 28.816 % 25.843 % 25.971 % 25.408 % 3.082 4.552 3.870 3.535 31.898 % 30.395 % 29.841 % 28.944 % Note: Property in the county is reassessed annually. The county assesses property at approximately 90 percent of actual value for all types of real and personal property. -120- Table 5 2007 2008 2009 2010 2011 2012 $ 4,591,200 $ 4,336,600 $ 4,764,900 $ 4,629,900 $ 4,948,300 $ 5,291,700 1,475,529,200 1,597,262,400 1,651,054,700 1,631,938,000 1,507,900,600 1,430,712,101 $1,480,120,400 $1,601,599,000 $1,655,819,600 $1,636,567,900 $1,512,848,900 $1,436,003,801 $1,553,767,900 $1,645,188,300 $1,673,720,100 $1,638,118,400 $1,514,456,700 $1,453,867,700 95.26 % 97.35% 98.93 % 99.91 % 99.89 % 98.77 % $ 89,872 $ 84,780 $ 91,548 $ 88,848 $ 95,216 $ 102,084 16,130,097 17,619,943 18,305,114 18,087,557 16,620,629 15,761,142 16,219,969 17,704, 723 18,396, 662 18,176,405 16,715, 845 15, 863,226 (308,590) (351,789) (396,336) (432,995) (419,002) (389,965) 407,687 445,780 513,259 526,521 478,935 435,462 $ 16,319,066 $ 17,798,714 $ 18,513,585 $ 18,269,931 $ 16,775,778 $ 15,908,723 $ 3,835,173 $ 4,056,917 $ 4,158,672 $ 4,160,292 $ 4,158,672 $ 4,158,672 561,135 555,078 617,620 616,000 604,647 604,647 $ 4,396,308 $ 4,611,995 $ 4,776,292 $ 4,776,292 $ 4,763,319 $ 4,763,319 23.501 % 22.793 % 22.463 % 22.771 % 24.790 % 26.141 % 3.439 3.119 3.336 3.372 3.604 3.801 26.940 % 25.912% 25.799 % 26.143 % 28.394% 29.942 % -121- Year Taxes Payable 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) PROPERTY TAX CAPACITY RATES - DIRECT AND OVERLAPPING GOVERNMENTS (PER $1,000 OF TAX CAPACITY IN 2003 - 2012) City County 31.898 % 50.607 % 30.395 47.324 29.841 44.172 28.944 41.016 26.940 39.110 25.912 38.571 25.799 40.413 26.143 42.640 28.394 45.840 29.942 48.231 Source: Hennepin County Assessor (1) Includes vocational school Overlapping Rates (1) School District Watershed District No. 276 No. 277 No.3 No.4 Misc. 24.215 % 20.758 % 1.236 % 1.616 % 7.757 % 23.125 14.354 0.768 0.732 7.488 21.989 16.250 1.276 1.375 7.382 22.952 10.522 1.072 0.787 6.998 24.793 9.911 1.121 0.743 7.310 17.980 8.521 1.404 1.302 7.397 17.186 8.284 1.489 1.246 7.154 18.657 9.772 1.511 1.279 8.138 21.274 10.900 1.606 1.352 9.172 23.015 17.262 1.705 1.387 9.923 Overlapping rates are those of local and county governments that apply to property owners within the City. Not all overlapping rates apply to all City property owners (e.g. the rates for special districts apply only to the proportion of the government's property owners whose property is located within the geographic boundaries of the special district). -122- Table 6 Totals 115.713 % School 112.256 % District School District No. 276 No. 277 Watershed Watershed Watershed District District District No.3 No.4 No.3 115.713 % 116.093 % 112.256 % 109.100 109.064 100.329 104.660 104.759 98.921 100.982 100.697 88.552 99.274 98.896 84.392 91.264 91.162 81.805 92.041 91.798 83.139 97.089 96.857 88.204 106.286 106.032 95.912 112.816 112.498 107.063 -123- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) PRINCIPAL TAXPAYERS DECEMBER 31, 2012 Totals $ 798,660 Source: Hennepin County Assessor 2012 Rank -124- Percent Tax Taxpayer Capacity Tax Capacity Capacity Big Box One, LLC $ 151,250 Shorewood Village Shopping Center, Inc. 123,250 Two S Properties 103,350 R & M Fayfield 72,626 South Lake Office Building LLC 69,630 Jack & Gretchen Norqual 69,536 Elaine & Gary Jarrett 58,388 First State Bank Excelsior (Beacon Bank) 56,870 Minnetonka Country Club 49,830 Waterford Center LLP 43,930 Shurgard Storage Centers - James C. Akins - Thomas J. & Cynthia J. Redmond - The Mary Sue Simon Qprt - Russel & Luaina Hagen - Totals $ 798,660 Source: Hennepin County Assessor 2012 Rank -124- Percent of Total Tax Tax Capacity Capacity 1 0.95 % $ - 2 0.77 37,050 3 0.65 - 4 0.46 - 5 0.44 - 6 0.44 - 7 0.37 - 8 0.36 39,250 9 0.31 48,850 10 0.28 39,250 - - 103,736 - - 51,025 - - 35,380 - - 35,190 - - 31,935 5.02 % $ 421,666 2003 Rank Table 7 Percent of Total Tax Capacity - 0.37 - 0.40 - 0.49 - 0.40 - 1.05 - 0.52 - 0.36 - 0.36 - 0.32 4.26 % CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS (1) Includes state paid property tax credits. Percentage of Levy Collected 99.21 % 99.12 98.76 98.94 98.27 98.59 97.35 98.09 98.82 99.04 -125- Collection in subsequent years S 24,693 29,754 46,458 41,120 77,258 61,611 116,716 81,812 45,859 Total Collections S 3,156,491 3,419,891 3,829,532 4,186, 949 4,397,547 4,608,510 4,766,620 4,766,872 4,752,759 4,717,658 Table 8 Percent of Total Collections to Levy 99.99 % 99.99 99.97 99.92 100.03 99.92 99.80 99.80 99.78 99.04 (1) Collection Fiscal Total of Current Year Levy Year's Levy 2003 S 3,156,847 S 3,131,798 2004 3,420,229 3,390,137 2005 3,830,656 3,783,074 2006 4,190,395 4,145,829 2007 4,396,308 4,320,289 2008 4,611,995 4,546,899 2009 4,776,292 4,649,904 2010 4,776,292 4,685,060 2011 4,763,319 4,706,900 2012 4,763,319 4,717,658 (1) Includes state paid property tax credits. Percentage of Levy Collected 99.21 % 99.12 98.76 98.94 98.27 98.59 97.35 98.09 98.82 99.04 -125- Collection in subsequent years S 24,693 29,754 46,458 41,120 77,258 61,611 116,716 81,812 45,859 Total Collections S 3,156,491 3,419,891 3,829,532 4,186, 949 4,397,547 4,608,510 4,766,620 4,766,872 4,752,759 4,717,658 Table 8 Percent of Total Collections to Levy 99.99 % 99.99 99.97 99.92 100.03 99.92 99.80 99.80 99.78 99.04 CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) RATIO OF NET BONDED DEBT TO ASSESSED VALUE AND NET BONDED DEBT PER CAPITA LAST TEN FISCAL YEARS Note: Details regarding the City's outstanding debt can be found in the notes to the financial statements. See the Demographic and Economic Statistics table on page 133 for personal income and population data -126- Table 9 Percentage of Personal Per Business - Capita 4.31 % S 1,962 4.04 1,923 type 1,967 4.12 Governmental Activities 6.31 Activities 5.87 3,199 General Lease 3.19 General Total Fiscal Obligation Revenue Capital Obligation Primary Year Bonds Bonds Leases Revenue Bonds Government 2003 S 20,000 S 12,365,000 S 159,233 S 2,360,000 S 14,904,233 2004 - 12,365,000 131,134 2,170,000 14,666,134 2005 - 12,010,000 101,322 2,745,000 14,856,322 2006 - 11,555,000 69,594 3,920,000 15,544,594 2007 - 21,090,000 - 3,665,000 24,755,000 2008 - 21,915,000 - 3,415,000 25,330,000 2009 - 13,295,000 - 3,165,000 16,460,000 2010 - 10,795,000 - 2,915,000 13,710,000 2011 - 10,170,000 - 2,675,000 12,845,000 2012 - 9,515,000 - 2,500,000 12,015,000 Note: Details regarding the City's outstanding debt can be found in the notes to the financial statements. See the Demographic and Economic Statistics table on page 133 for personal income and population data -126- Table 9 Percentage of Personal Per Income Capita 4.31 % S 1,962 4.04 1,923 4.00 1,967 4.12 2,073 6.31 3,301 5.87 3,199 4.14 2,076 3.19 1,876 2.96 1,758 2.86 1,643 CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) RATIOS OF GENERAL BONDED DEBT OUTSTANDING LAST TEN FISCAL YEARS Table 10 Percentage of Estimated Actual Value of Per Taxable Property Capita (0.01) % S (12) Note: Details regarding the City's outstanding debt can be found in the notes to the financial statements. See the Demographic and Economic Statistics table on page 133 for population data. See the Tax Capacity, Market Value and Estimated Actual Value of Taxable Property table on pages 120 - 121 for property value information. -127- Less Amounts General Available in Net Fiscal Obligation Debt Service Bonded Year Bonds Funds Debt 2003 S 20,000 S 108,925 S (88,925) 2004 - - - 2005 - - - 2006 - - - 2007 - - - 2008 - - - 2009 - - - 2010 - - - 2011 - - - 2012 - - - Table 10 Percentage of Estimated Actual Value of Per Taxable Property Capita (0.01) % S (12) Note: Details regarding the City's outstanding debt can be found in the notes to the financial statements. See the Demographic and Economic Statistics table on page 133 for population data. See the Tax Capacity, Market Value and Estimated Actual Value of Taxable Property table on pages 120 - 121 for property value information. -127- THIS PAGE IS LEFT BLANK INTENTIONALLY -128- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) COMPUTATION OF DIRECT AND OVERLAPPING DEBT DECEMBER 31, 2012 Direct Debt City of Shorewood Overlapping Debt School District #276 School District #277 Hennepin County Henn Suburban Park District Henn Regional RR Authority Metropolitan Council Total Overlapping Debt Total Direct and Overlapping Debt Table 11 Gross Amount Bonded of Debt Used Percentage Net Debt For Net Debt Net Applicable to Applicable Calculation Debt District to District S 9,515,000 S 9,515,000 100.00 % 9,515,000 S 101,504,548 S 87,293,950 19.64 % S 17,144,532 35,280,000 34,977,241 2.42 846,449 678,885,000 673,838,501 1.20 8,086,062 90,255,000 72,840,200 1.62 1,180,011 39,110,000 38,770,299 1.20 465,244 257,390,000 193,377,711 0.55 1,063,577 S 1,202,424,548 S 1,101,097,902 2.61 % S 28,785,875 S 1,211,939,548 S 1,110,612,902 3.45 % S 38,300,875.26 Sources : Market value data used to estimate applicable percentages provided by the County Board of Equalization and Assessment. Debt outstanding data provided by the county. Note: Overlapping governments are those that coincide, at least in part, with the geographic boundaries of the City. This schedule estimates the portion of the outstanding debt of those overlapping governments that is borne by the residents and businesses of the City. This process recognized that, when considering the government's ability to issue and repay long -term debt, the entire debt burden borne by the residents and businesses should be taken into account. However, this does not imply that every taxpayer is a resident, and therefore responsible for repaying the debt, of each overlapping government. * The percentage of overlapping debt applicable is estimated using taxable market property values. Applicable percentages were estimated by determining the portion of the county's taxable market value that is within the City's boundaries and dividing it by the county's total taxable market value. -129- CITY OF SHOREWOOD, MINNESOTA STATISTICAL SECTION (UNAUDITED) LEGAL DEBT MARGIN INFORMATION LAST TEN FISCAL YEARS Fiscal Year 2003 2004 2005 2006 Debt limit S 18,374,640 S 20,745,830 S 23,543,186 S 26,453,492 Total net debt applicable to limit (88,925) - - - Legal debt margin S 18,463,565 S 20,745,830 S 23,543,186 S 26,453,492 Total net debt applicable to the limit as a percentage of debt limit (0.5 %) - - - Note: Under state law, the City's outstanding general obligation debt should not exceed 3 percent of the market value of taxable property. The percentage was changed to 3 percent for fiscal year 2008, prior to that, the percentage was 2 percent. By law, the general obligation debt subject to the limitation may be offset by amounts set aside for the extinguishment of those obligations. -130- Table 12 Fiscal Year 2007 2008 2009 2010 2011 2012 $ 29,602,408 $ 32,031,980 $ 33,116,392 $ 49,097,037 $ 45,385,467 $ 43,080,114 $ 29,602,408 $ 32,031,980 $ 33,116,392 $ 49,097,037 $ 45,385,467 $ 43,080,114 Legal Debt Margin Calculation for Fiscal Year 2012 Taxable market value Debt limit (3% of market value) Debt applicable to limit General obligation bonds Less: amount available in debt service funds Total net debt applicable to limit Legal debt margin -131- $ 1,436,003,801 $ 43,080,114 $ 43,080,114 CITY OF SHOREWOOD, MINNESOTA Table 13 STATISTICAL SECTION (UNAUDITED) PLEDGED - REVENUE COVERAGE LAST TEN FISCAL YEARS -132- General Obligation Revenue Bonds (1) Net Fiscal Gross (2) Revenue Debt Service Year Revenue Expenses Available Principal Interest Coverage 2003 S 539,287 S 192,689 S 346,598 S 185,000 S 93,280 1.25 % 2004 676,287 314,513 361,774 190,000 86,907 1.31 2005 720,438 300,858 419,580 950,000 88,712 0.40 2006 1,264,892 223,243 1,041,649 275,000 79,456 2.94 2007 765,717 259,056 506,661 255,000 81,165 1.51 2008 857,890 278,164 579,726 250,000 172,050 1.37 2009 821,778 250,995 570,783 250,000 142,589 1.45 2010 700,678 238,780 461,898 250,000 125,407 1.23 2011 718,561 299,962 418,599 240,000 116,728 1.17 2012 809,746 313,620 496,126 175,000 100,668 1.80 (1) Including interest and other income (2) Excluding depreciation and interest on bonds Capital Leases Revenue from Fiscal Property Debt Service Year Taxes Principal Interest Coverage 2003 S 37,544 S 26,402 S 11,142 1.00 % 2004 37,544 28,069 9,475 1.00 2005 37,544 29,842 7,702 1.00 2006 37,544 31,728 5,816 1.00 2007 73,406 69,594 3,812 1.00 2008 - - - - 2009 - - - - 2010 - - - - 2011 - - - - 2012 - - - - Lease Revenue Bonds Revenue from Fiscal Lease Debt Service Year Payments Principal Interest Coverage 2003 S 447,704 S - S 447,704 1.00 % 2004 620,596 - 624,650 0.99 2005 948,384 355,000 588,384 1.01 2006 1,040,693 455,000 589,056 1.00 2007 1,034,751 465,000 941,222 0.74 2008 1,037,241 485,000 970,065 0.71 2009 992,835 495,000 737,863 0.81 2010 982,037 555,000 457,840 0.97 2011 902,003 575,000 393,357 0.93 2012 978,744 605,000 372,230 1.00 -132- CITY OF SHOREWOOD, MINNESOTA Table 14 DEMOGRAPHIC AND ECONOMIC STATISTICS LAST TEN FISCAL YEARS Data Sources: (1) Metropolitan Council (2) Bureau of Economic Analysis (3) US Census Bureau (4) US Census Bureau 2010 (5) Minnesota Department of Employment and Economic Development Note: Personal income information is a total for the year. -133- Percent of Population Total Per Capita Which Has a Fiscal Personal Personal Median Bachelor's or Post Unemployment Year Population (1) Income (2) Income (2) Age (3) Graduate Degree (4) Rate (5) 2003 7,595 S 345,748,000 S 45,344 38.7 4.7 % 2004 7,625 362,787,795 48,045 38.7 4.3 2005 7,551 371,695,434 49,566 38.7 3.8 2006 7,499 377,246,826 49,566 38.7 3.3 2007 7,611 392,414,022 49,566 38.7 4.7 2008 7,917 431,535,825 54,425 39.0 7.3 2009 7,929 397,683,475 54,425 39.0 7.4 2010 7,307 429,651,600 58,800 39.1 5.1 2011 7,307 433,743,520 59,360 44.2 51.1 % 5.7 2012 7,312 420,264,512 57,476 44.1 49.8 4.6 Data Sources: (1) Metropolitan Council (2) Bureau of Economic Analysis (3) US Census Bureau (4) US Census Bureau 2010 (5) Minnesota Department of Employment and Economic Development Note: Personal income information is a total for the year. -133- CITY OF SHOREWOOD, MINNESOTA PRINCIPAL EMPLOYERS CURRENT YEAR AND NINE YEARS AGO (1) 2012 Employer Employees Cub Foods 94 Minnewashta Elementary School 83 Xcel Energy 35 Beacon Bank 35 Minnetonka County Club 29 City of Shorewood 28 Total 304 Total City Employment 1,548 19.64 % Source: Minnesota Department of Employment and Economic Development * Includes part -time and temporary seasonal employees. N/A - indicates not available (1) Information for 2002 was not available. The table will be updated for future years. -134- 2003 Rank Table 15 Percentage of Total City Employment N/A % N/A N/A N/A N/A N/A Percentage of Total City Rank Employment Employees 1 6.07 % - 2 5.36 - 3 2.26 - 4 2.26 - 5 1.87 - 6 1.81 - 19.64 % Source: Minnesota Department of Employment and Economic Development * Includes part -time and temporary seasonal employees. N/A - indicates not available (1) Information for 2002 was not available. The table will be updated for future years. -134- 2003 Rank Table 15 Percentage of Total City Employment N/A % N/A N/A N/A N/A N/A Function General government Public works Engineering Maintenance Culture and recreation Parks Economic developmen Water Sewer Municipal Liquor Total CITY OF SHOREWOOD, MINNESOTA FULL -TIME EQUIVALENT CITY GOVERNMENT EMPLOYEES BY FUNCTION LAST TEN FISCAL YEARS (1) Table 16 2006 2 2007 2 2008 2 2009 2 2010 2 2011 2 2012 13 1 13 1 13 1 12 1 12 1 10 1 10 - - - - - - - - - 1 1 1 1 6 6 6 6 6 6 6 6 6 5 5 5 5 13 5 5 5 5 5 5 5 5 3 3 3 3 Source: City of Shorewood (1) Information prior to 2006 was not maintained by the City. The table will be updated on a go- forward basis. -135- CITY OF SHOREWOOD, MINNESOTA Table 17 OPERATING INDICATORS BY FUNCTION LAST SIX FISCAL YEARS (1) Function 2006 2007 2008 2009 2010 2011 2012 Building /engineering 591 512 585 Permits issued 1,137 710 686 Public works 1,024 895 616 Street sweeping (hours) 1,000 1,614 1,500 Snowplowing (hours) 2,000 1,394 1,508 Equipment repair (hours) 2,080 2,080 2,080 Water 467,600 465,300 465,300 New connections 24 22 13 Water mains breaks 3 7 3 Average daily consumption (thousands of gallons) 482,000 482,000 482,000 Sewer Average daily treatment flow (thousands of gallons) 1,000,000 1,000,000 1,000,000 Source: City of Shorewood Note: Indicators are not available for the general government function. (1) Information prior to 2006 was not maintained by the City. The table will be updated on a go- forward basis. -136- 603 591 512 585 1,550 1,400 1,600 1,600 765 1,024 895 616 2,080 1,280 1,591 1,725 11 1 2 3 3 5 6 7 467,600 467,600 465,300 465,300 1,000,000 1,000,000 1,000,000 1,000,000 CITY OF SHOREWOOD, MINNESOTA Table 18 CAPITAL ASSET STATISTICS BY FUNCTION LAST SIX FISCAL YEARS (1) Function 2006 2007 2008 2009 2010 2011 2012 Public works Highways and streets Streets (miles) 50 51 51 51 51 51 51 Street lights 194 194 194 194 194 194 194 Traffic signals 5 5 5 5 5 5 5 Culture and recreation Parks division Parks 7 7 7 7 7 7 7 Parks acreage 102 102 102 102 102 102 102 Baseball diamonds 5 5 5 5 5 5 5 Basketball courts 1 1 1 1 1 1 1 Bike trails (miles) 2.45 2.45 2.45 2.45 2.45 2.45 2.45 Hockey rinks /outdoor 3 3 3 3 3 3 3 Softball diamonds 3 3 3 3 3 3 3 Swimming areas 1 1 1 1 1 1 1 Tennis courts 5 5 5 5 5 5 5 Volleyball courts 2 2 2 2 2 2 2 Utilities Water Miles of water main 27 28 28 28 28 28 28 Consumers 1,265 1,297 1,310 1,321 1,322 1,324 1,327 Maximum daily capacity (gallons) 919,000 919,000 919,000 919,000 919,000 919,000 919,000 Sewer Miles of sanitary sewer 60 60 60 60 60 60 60 Lift stations 14 14 14 14 14 14 14 Maximum daily treatment capacity (gallons) 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 Storm sewer Miles of storm sewer 12 12 12 12 12 12 12 Source: City of Shorewood Note: No capital asset indicators are available for the general government function. (1) Information prior to 2006 was not maintained by the City. The table will be updated on a go- forward basis. -137-