Loading...
HomeMy WebLinkAboutCity Council - 05/17/2011 AGENDA CITY COUNCIL WORKSHOP & OPEN PODIUM TUESDAY, MAY 17, 2011 CITY CENTER 5:00—6:25 PM, HERITAGE ROOM II 6:30—7:00 PM, COUNCIL CHAMBER CITY COUNCIL: Mayor Nancy Tyra-Lukens, Council Members Brad Aho, Sherry Butcher Wickstrom, Kathy Nelson, and Ron Case CITY STAFF: City Manager Rick Getschow, Police Chief Rob Reynolds, Fire Chief George Esbensen, Public Works Director Eugene Dietz, Community Development Director Janet Jeremiah, Parks and Recreation Director Jay Lotthammer, Communications Manager Joyce Lorenz, City Attorney Ric Rosow, and Recorder Lorene McWaters Heritage Room H I. COMPLETE STREET CONCEPT II. AUDITORS REPORT Council Chamber III. OPEN PODIUM IV. ADJOURNMENT AGENDA EDEN PRAIRIE CITY COUNCIL MEETING TUESDAY, MAY 17, 2011 7:00 PM, CITY CENTER Council Chamber 8080 Mitchell Road CITY COUNCIL: Mayor Nancy Tyra-Lukens, Council Members Brad Aho, Sherry Butcher Wickstrom, Kathy Nelson, and Ron Case CITY STAFF: City Manager Rick Getschow, Public Works Director Eugene Dietz, City Planner Michael Franzen, Community Development Director Janet Jeremiah, Parks and Recreation Director Jay Lotthammer, City Attorney Ric Rosow and Council Recorder Jan Curielli I. ROLL CALL/CALL THE MEETING TO ORDER II. COLOR GUARD/PLEDGE OF ALLEGIANCE III. COUNCIL FORUM INVITATION IV. PROCLAMATIONS /PRESENTATIONS A. 2010 COMPREHENSIVE ANNUAL FINANCIAL REPORT (CAFR) V. APPROVAL OF AGENDA AND OTHER ITEMS OF BUSINESS VI. MINUTES A. COUNCIL WORKSHOP HELD TUESDAY, MAY 3, 2011 B. CITY COUNCIL MEETING HELD TUESDAY, MAY 3, 2011 VII. REPORTS OF ADVISORY BOARDS & COMMISSIONS VIII. CONSENT CALENDAR A. CLERK'S LICENSE LIST B. WEDDING DAY DIAMONDS by Tanek, Inc. Second Reading of the Ordinance for Planned Unit Development District Review on 0.69 acres and Zoning District Amendment within the Commercial Regional Service Zoning District on 0.69 acres, Resolution for Site Plan Review on 0.69 acres. Location: 8320 Crystal View Rd. (Ordinance for PUD District Review and Zoning District Amendment; Resolution for Site Plan Review) C. RIDGE AT RILEY CREEK 4TH ADDITION by JMS Custom Homes, LLC. Second Reading of the Ordinance for Planned Unit Development District Review on 0.65 acres and Zoning District Amendment within the R1-13.5 Zoning District on 0.65 acres. Location: 9707 Sky Lane. (Ordinance for PUD District Review and Zoning District Amendment) CITY COUNCIL AGENDA May 17, 2011 Page 2 D. APPROVE SECOND READING OF ORDINANCE AMENDING CITY CODE CHAPTER 11 RELATING TO DEFINITIONS FOR CAST STONE, CULTURED STONE,ARCHITECTURAL PRECAST AND PRECAST CONCRETE PANEL AND ADOPT RESOLUTION APPROVING SUMMARY ORDINANCE E. ADOPT RESOLUTION APPROVING FINAL PLAT OF THE RIDGE AT RILEY CREEK 4TH ADDITION F. ADOPT RESOLUTION APPROVING CONSTRUCTION COOPERATIVE AGREEMENT WITH HENNEPIN COUNTY FOR COUNTY PARTICIPATION IN STORM SEWER COSTS FOR FLYING CLOUD FIELDS G. AWARD CONTRACT FOR 2011 STREET SEALCOATING TO PEARSON BROTHERS, INC. H. AWARD CONTRACT FOR 2011 STREET BITUMINOUS OVERLAY PROJECT TO BITUMINOUS ROADWAYS, INC. I. APPROVE PROFESSIONAL SERVICES AGREEMENT WITH WESTWOOD PROFESSIONAL SERVICES FOR CITY WEST TRAFFIC STUDY J. APPROVE PROFESSIONAL SERVICES AGREEMENT WITH SRF CONSULTING GROUP FOR THE LANDSCAPE PLAN FOR CSAH1 (BETWEEN FLYING CLOUD DR AND SHETLAND ROAD) K. AWARD THE CONTRACT FOR PLAYGROUND EQUIPMENT AT PIONEER PARK TO FLANAGAN SALES INC. L. APPROVE THE SECOND AMENDMENT TO THE 2009 REHABILITATION DEFERRED GRANT PROGRAM AGREEMENT BETWEEN THE CITY OF EDEN PRAIRIE AND PROP M. AWARD CONTRACT TO LAVAN FLOOR COVERING COMPANY TO REPLACE CARPET IN THE COMMUNITY CENTER LOBBY N. DIRECT STAFF TO NOT WAIVE THE MONETARY LIMITS ON MUNICIPAL TORT LIABILITY ESTABLISHED BY MINNESOTA STATUTES 466.04 O. APPROVE THE CITY'S FINANCIAL POLICIES FOR THE 2012/2013 BUDGET IX. PUBLIC HEARINGS /MEETINGS A. ERIC SCHAFFER ADDITION by Eric Schaffer. Request for Preliminary Plat on 1.5 acres into two lots. Location: 6451 Evergreen Ct& 6516 Kurtz Lane. (Resolution for Preliminary Plat) CITY COUNCIL AGENDA May 17, 2011 Page 3 B. RESOLUTIONS AMENDING TIF DISTRICT#15 PLAN AND PROJECT MANAGEMENT AGREEMENT (SUMMIT PLACE SENIOR HOUSING PROJECT) X. PAYMENT OF CLAIMS XI. ORDINANCES AND RESOLUTIONS A. RESOLUTION APPROVING FINAL PLAT OF THE ERIC SCHAFFER ADDITION XII. PETITIONS, REQUESTS AND COMMUNICATIONS XIII. APPOINTMENTS XIV. REPORTS A. REPORTS OF COUNCIL MEMBERS B. REPORT OF CITY MANAGER C. REPORT OF THE COMMUNITY DEVELOPMENT DIRECTOR 1. Reallocation of 2010 and 2011 CDBG Funds D. REPORT OF PARKS AND RECREATION DIRECTOR 1. Cost-Share Asreement with Nine Mile Creek Watershed District for Driveway and Parking Lot for Birch Island Woods Conservation Area 2. United States of America Pickleball Association Grant 3. Metropolitan Resional Arts Council Grant for Eden Prairie Players Strategic Plannin! E. REPORT OF PUBLIC WORKS DIRECTOR F. REPORT OF POLICE CHIEF G. REPORT OF FIRE CHIEF H. REPORT OF CITY ATTORNEY XV. OTHER BUSINESS XVI. CLOSED SESSION TO DISCUSS POTENTIAL LITIGATION XVII. ADJOURNMENT ANNOTATED AGENDA REVISED DATE: May 13, 2011 TO: Mayor and City Council FROM: Rick Getschow, City Manager RE: City Council Meeting for Tuesday, May 17, 2011 TUESDAY, MAY 17, 2011 7:00 PM, COUNCIL CHAMBER I. ROLL CALL/CALL THE MEETING TO ORDER II. COLOR GUARD/PLEDGE OF ALLEGIANCE III. OPEN PODIUM INVITATION Open Podium is an opportunity for Eden Prairie residents to address the City Council on issues related to Eden Prairie city government before each Council meeting, typically the first and third Tuesday of each month, from 6:30 to 6:55 p.m. in the Council Chamber. If you wish to speak at Open Podium,please contact the City Manager's office at 952.949.8412 by noon of the meeting date with your name, phone number and subject matter. If time permits after scheduled speakers are finished, the Mayor will open the floor to unscheduled speakers. Open Podium is not recorded or televised. If you have questions about Open Podium, please contact the City Manager's Office. IV. PROCLAMATIONS /PRESENTATIONS A. 2010 COMPREHENSIVE ANNUAL FINANCIAL REPORT (CAFR) Synopsis: Minnesota statutes require that by June 30 of each year, the City prepare a financial report for activities of the previous year. This accounting report will be forwarded to the State by that deadline. Preparation of the report is largely the work of the Finance Division. The report is prepared with review by the independent auditing firm of Kern, Dewenter, Viere, Ltd. Kern, Dewenter, Viere, Ltd issued an unqualified opinion which is the highest level of opinion the City can receive and means the auditor believe the financial statements are fairly presented in all material respects. Steve Wischmann,partner in the accounting firm,will make a presentation. IR40TION: Mov M mprehensive Annual Financial Report (CAFR). V. APPROVAL OF AGENDA AND OTHER ITEMS OF BUSINESS MOTION: Move to approve the agenda. ANNOTATED AGENDA - REVISED May 17, 2011 Page 2 VI. MINUTES MOTION: Move to approve the following City Council minutes: A. COUNCIL WORKSHOP HELD TUESDAY, MAY 3, 2011 B. CITY COUNCIL MEETING HELD TUESDAY, MAY 3, 2011 VII. REPORTS OF ADVISORY BOARDS & COMMISSIONS VIII. CONSENT CALENDAR MOTION: Move approval of items A-P on the Consent Calendar. A. CLERK'S LICENSE LIST B. WEDDING DAY DIAMONDS by Tanek, Inc. Second Reading of the Ordinance for Planned Unit Development District Review on 0.69 acres and Zoning District Amendment within the Commercial Regional Service Zoning District on 0.69 acres, Resolution for Site Plan Review on 0.69 acres. Location: 8320 Crystal View Rd. (Ordinance for PUD District Review and Zoning District Amendment; Resolution for Site Plan Review) C. RIDGE AT RILEY CREEK 4TH ADDITION by JMS Custom Homes, LLC. Second Reading of the Ordinance for Planned Unit Development District Review on 0.65 acres and Zoning District Amendment within the R1-13.5 Zoning District on 0.65 acres. Location: 9707 Sky Lane. (Ordinance for PUD District Review and Zoning District Amendment) D. APPROVE SECOND READING OF ORDINANCE AMENDING CITY CODE CHAPTER 11 RELATING TO DEFINITIONS FOR CAST STONE, CULTURED STONE,ARCHITECTURAL PRECAST AND PRECAST CONCRETE PANEL AND ADOPT RESOLUTION APPROVING SUMMARY ORDINANCE E. ADOPT RESOLUTION APPROVING FINAL PLAT OF THE RIDGE AT RILEY CREEK 4TH ADDITION F. ADOPT RESOLUTION APPROVING CONSTRUCTION COOPERATIVE AGREEMENT WITH HENNEPIN COUNTY FOR COUNTY PARTICIPATION IN STORM SEWER COSTS FOR FLYING CLOUD FIELDS G. AWARD CONTRACT FOR 2011 STREET SEALCOATING TO PEARSON BROTHERS, INC. H. AWARD CONTRACT FOR 2011 STREET BITUMINOUS OVERLAY PROJECT TO BITUMINOUS ROADWAYS, INC. I. APPROVE PROFESSIONAL SERVICES AGREEMENT WITH WESTWOOD PROFESSIONAL SERVICES FOR CITY WEST TRAFFIC STUDY ANNOTATED AGENDA - REVISED May 17, 2011 Page 3 J. APPROVE PROFESSIONAL SERVICES AGREEMENT WITH SRF CONSULTING GROUP FOR THE LANDSCAPE PLAN FOR CSAHI (BETWEEN FLYING CLOUD DR AND SHETLAND ROAD) K. AWARD THE CONTRACT FOR PLAYGROUND EQUIPMENT AT PIONEER PARK TO FLANAGAN SALES INC. L. APPROVE THE SECOND AMENDMENT TO THE 2009 REHABILITATION DEFERRED GRANT PROGRAM AGREEMENT BETWEEN THE CITY OF EDEN PRAIRIE AND PROP M. AWARD CONTRACT TO LAVAN FLOOR COVERING COMPANY TO REPLACE CARPET IN THE COMMUNITY CENTER LOBBY N. DIRECT STAFF TO NOT WAIVE THE MONETARY LIMITS ON MUNICIPAL TORT LIABILITY ESTABLISHED BY MINNESOTA STATUTES 466.04 O. APPROVE THE CITY'S FINANCIAL POLICIES FOR THE 2012/2013 BUDGET P. APPROVE LEASE AGREEMENT WITH METROPOLITAN AIRPORTS COMMISSION FOR THE COMMUNITY GARDEN PLOTS AREA IX. PUBLIC HEARINGS /MEETINGS A. ERIC SCHAFFER ADDITION by Eric Schaffer. Request for Preliminary Plat on 1.5 acres into two lots. Location: 6451 Evergreen Ct& 6516 Kurtz Lane. (Resolution for Preliminary Plat) Official notice of this public hearing was published in the May 5, 2011, Eden Prairie News and sent to 47 property owners. Synopsis: The property owners have agreed to relocate a common lot line between the two properties. Proposed lot one will increase in size from 22,000 sq. ft. to 40,849 sq. ft. Proposed lot two will decrease in size from 43,363 sq. ft. to 24,552 sq. ft. Both lots meet the requirements of the R1-22 zoning district. A Resolution for final approval of the subdivision is located in the Ordinances and Resolutions section of the agenda. The 120-Day Review Period Expires on July 24, 2011. The Planning Commission voted 7- 0 to recommend approval of the project at the April 25, 2011 meeting. Motion: Move to: PW • Close the Public Hearing; and •L. Adopt the Resolution for Preliminary Plat on 1.5 acres into 2 lots. B. RESOLUTIONS AMENDING TIF DISTRICT#15 PLAN & PROJECT MANAGEMENT AGREEMENT (SUMMIT PLACE SENIOR HOUSING PROJECT) Synopsis: This public hearing was continued from the May 3 City Council meeting. ANNOTATED AGENDA - REVISED May 17, 2011 Page 4 MOTION: Move to continue the Public Hearing to June 14, 2011. X. PAYMENT OF CLAIMS MOTION: Move approval of the Payment of Claims as submitted (Roll Call Vote). XI. ORDINANCES AND RESOLUTIONS A. RESOLUTION APPROVING FINAL PLAT OF THE ERIC SCHAFFER ADDITION Synopsis: This proposal is for the plat located at 6451 Evergreen Court and 6516 Kurtz Lane. The plat consists of 1.5 acres to be platted into two single family lots. With this proposal, the property owners have agreed to relocate a common lot line between the two properties. Proposed lot one will increase in size from 22,000 sq.ft. to 40,849 sq. ft. Proposed lot two will decrease in size from 43,363 sq. ft. to 24,552 sq. ft. Both lots meet the requirements of the R1-22 zoning district. The preliminary plat and final plat will be approved by the City Council on May 17, 2011. This is a replat of Tract C, RLS No. 664 and Tract H, RLS No. 261. Approval of the final plat is subject to the following conditions: • Receipt of engineering fee in the amount of$320.00 • Provide a list of areas (to the nearest square foot) of all lots, outlots and right-of- ways certified by surveyor MOTION: Move to adopt the resolution approving the final plat of Eric Schaffer Addition. XII. PETITIONS, REQUESTS AND COMMUNICATIONS XIII. APPOINTMENTS XIV. REPORTS A. REPORTS OF COUNCIL MEMBERS B. REPORT OF CITY MANAGER C. REPORT OF THE COMMUNITY DEVELOPMENT DIRECTOR 1. Reallocation of 2010 and 2011 CDBG Funds Synopsis: The city has an additional $4,000 in 2010 CDBG funds to reallocate to public service providers. $2,500 in additional funds is due to the city's decision to no longer fund HOME Line due to their non compliance with HUD income regulations. An additional $1,500 was due to a greater amount of program income received. The Human Services Review Committee recommended that$4,000 be reallocated to CAPSH for their ANNOTATED AGENDA - REVISED May 17, 2011 Page 5 Emergency Car Repair Program. CAPSH requested $15,000 in 2010 and were originally awarded $5,500. This additional funding will bring their allocation to $9,500 for 2010. The office of Housing and Urban Development (HUD) has announced that the city's 2011 CDBG allocation will be $233,330. The Human Services Review Committee reconvened on May 2, 2011 to reallocate the funds based on the $233,330 allocation. The regulations stipulate that public service funding may not exceed 15 percent of the City's total allocation ($233,330),plus 15 percent of the previous year's program income ($131,869). The Human Services Review Committee reviewed the 2011 CDBG proposals and recommended the following activities be funded. # Human Services Activity Funding County % of Level Priority Allocation 1 PROP Housing Support Services $25,000 High 11% 2 YMCA (Child Care Subsidy) $12,000 High 5% 3 HOME (Household & Outside $9,000 High 4% Maintenance for the Elderly) 5 CAPSH (Emergency Vehicle Repair) $8,000 High 3% Subtotal $54,000 6 Housing Rehabilitation Deferred $103,664 High 44% Loan Program 7 First Time Homebuyer $50,000 High 21% 8 Fair Housing Initiative $2,333 High 1% 9 Program Administration $23,333 10% Grand Total $233,330 MOTION: Move to approve the reallocation of 2010 and 2011 CDBG funds as recommended by the Eden Prairie Human Services Review Committee. D. REPORT OF PARKS AND RECREATION DIRECTOR 1. Cost-Share Agreement with Nine Mile Creek Watershed District for Driveway and Parking Lot for Birch Island Woods Conservation Area Synopsis: The City has been awarded a $25,000 Cost-Share Grant from the Nine Mile Creek Watershed District(NMCWD) to be used for the construction of a pervious pavement parking lot for the Birch Island Woods Conservation Area. The grant will be matched with an equal amount of funding from the Storm Water Utility Fund. This unique water resource protection project will be a first for the city park system and is viewed by the NMCWD as an important water resource demonstration project. A parking lot for Birch Island Woods Conservation Area has been on the park construction list for several years. Last fall as the parking lot project was ANNOTATED AGENDA - REVISED May 17, 2011 Page 6 starting it was discovered that the original timetable of construction approval had lapsed and the project needed to be re-reviewed by the NMCWD. The project was stopped and HTPO was hired as a consultant to prepare updated plans. The preliminary plans indicated that we needed to increase the size of the original rainwater garden to treat the parking lot runoff in accordance with current storm water regulations. Additionally, during the site evaluation process it was brought to the attention of city staff that an alternative method of handling the storm water was to use pervious pavement/concrete over a crushed rock base. This option was evaluated and a$50,000 cost estimate for the project was received. This high estimated cost put the new idea out of reach since our original plan was to construct the parking lot using in-house equipment and labor at an estimated cost of$20,000. As we prepared the parking lot construction plans to be submitted to the NMCWD, Leslie Stovring, Environmental Coordinator thought that the pervious pavement project would qualify for a Cost-Share Grant. An application for matching funds for the project was submitted and approved. The scope of this project is to construct a pervious concrete driveway and parking for nine cars at the Birch Island Woods Conservation Area. The construction project will be started in June and seeding/restoration complete by September. MOTION: Move to authorize the City Manager to execute the Cost-Share Agreement with the Nine Mile Creek Watershed District for the construction of a driveway and parking lot for Birch Island Woods Conservation Area. 2. United States of America Pickleball Association Grant Synopsis: The existing tennis courts at Pioneer Park were lined according to official pickleball court dimensions, doubling the number of pickleball courts from two to four, based on the increased interest and demand by seniors for this newly offered community sport in the past year. These grant funds will cover the cost for two of the four new USAPA net systems purchased. Last spring, two residents approached staff at the Senior Center to request the use of the neighborhood tennis courts for a senior pickleball program. The Senior Center staff worked with Park Maintenance staff to provide the initial two courts. Two additional courts were lined this spring. These courts providing dual use of the existing outdoor tennis courts for both tennis and pickleball. Over the past year, the interest in pickleball here in Eden Prairie has grown from a couple of guys to a group of over 50 senior men and women who ANNOTATED AGENDA - REVISED May 17, 2011 Page 7 gather together twice a week to play pickleball. In addition, pickleball was offered indoors at the Community Center this past winter. On May 3, 2011 over 50 pickleball players and invited guest attending the ceremonial "first serve" spring kick-off event at the newly expanded pickleball courts, located behind the Senior Center in Pioneer Park MOTION: Move to accept the USAPA Training Funds awarded to the City of Eden Prairie in the amount of $250 to be used toward expansion of the outdoor pickleball courts at Pioneer Park. 3. Metropolitan Regional Arts Council Grant for Eden Prairie Players Strategic Planning Synopsis: Metropolitan Regional Arts Council (MRAC) has awarded the City of Eden Prairie—Eden Prairie Players a management consulting fund grant in the amount of$1,500 for the purpose of strategic planning,relating to community theatre. The Eden Prairie Players have been providing community theatre performances throughout the year for the past 20 years, including the Summer Musical, Winter Theater, Collection of One Acts, Children's Theater Workshop and other performing arts initiatives. The Eden Prairie Players Advisory Committee along with staff determined a strategic planning process with management consulting services provided by MRAC would allow the Eden Prairie Players and City staff an opportunity to evaluate the programs and services currently provided by the City sponsored community theater group and establish a vision, mission and purpose moving forward for the next 10-20 years. MOTION: Move to accept the grant award from Metropolitan Regional Arts Council (MRAC), in the amount of $1,500, for strategic planning services. E. REPORT OF PUBLIC WORKS DIRECTOR F. REPORT OF POLICE CHIEF G. REPORT OF FIRE CHIEF H. REPORT OF CITY ATTORNEY XV. OTHER BUSINESS XVI. CLOSED SESSION TO DISCUSS POTENTIAL LITIGATION XVII. ADJOURNMENT MOTION: Move to adjourn the City Council meeting. CITY COUNCIL AGENDA DATE: SECTION: Presentations May 17, 2011 DEPARTMENT/DIVISION: ITEM DESCRIPTION: ITEM NO.: W.A. Sue Kotchevar, Office of the 2010 Comprehensive Annual Financial City Manager/Finance Report(CAFR) Requested Action Move to: Accept the 2010 Comprehensive Annual Financial Report (CAFR). Synopsis Minnesota statutes require that by June 30 of each year, the City prepare a financial report for activities of the previous year. This accounting report will be forwarded to the State by that deadline. Preparation of the report is largely the work of the Finance Division. The report is prepared with review by the independent auditing firm of Kern, Dewenter, Viere, Ltd. Kern, Dewenter, Viere, Ltd issued an unqualified opinion which is the highest level of opinion the City can receive and means the auditor believe the financial statements are fairly presented in all material respects. Steve Wischmann,Partner in the accounting firm will make a presentation of the financial report. Attachments • 2010 CAFR • Management Letter • Special Purpose Audit Report • Compre nsiv Annual • F'ienan ia eport For the Year Ended December 31, 2010 �1ED PRAI RI E LIVE-WORK-DREAM i COMPREHENSIVE ANNUAL FINANCIAL REPORT of the CITY OF EDEN PRAIRIE MINNESOTA For The Year Ended December 31, 2010 Rick Getschow, City Manager (started 3/28/2011) Jay Lotthammer, Interim City Manager Prepared by THE FINANCE DIVISION Sue Kotchevar, Chief Financial Officer City of Eden Prairie, Minnesota For the Year Ended December 31, 2010 Table of Contents Page Introductory Section Letterof Transmittal..........................................................................................................................................i GFOACertificate of Achievement..................................................................................................................x OrganizationalChart......................................................................................................................................xi Listof Principal Officials...............................................................................................................................xii Financial Section IndependentAuditor's Report......................................................................................................................2 Management's Discussion and Analysis......................................................................................................4 Basic Financial Statements Government-wide Financial Statements Statementof Net Assets........................................................................................................................20 Statementof Activities..........................................................................................................................21 Fund Financial Statements Balance Sheet-Governmental Funds...................................................................................................24 Reconciliation of the Balance Sheet of Governmental Funds to the Statement of Net Assets........................................................................................................26 Statement of Revenues, Expenditures and Changes in Fund Balances - Governmental Funds..........................................................................................27 Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances of Governmental Funds to the Statement of Activities.....................................29 Statement of Revenues, Expenditures and Changes in Fund Balance- Budget and Actual- General Fund....................................................................30 Statement of Net Assets- Proprietary Funds....................................................................................33 Statement of Revenues, Expenses and Changes in Net Assets - Proprietary Funds ....................34 Statement of Cash Flows - Proprietary Funds...................................................................................35 Statement of Fiduciary Net Assets - Agency Funds .........................................................................37 Notesto Financial Statements................................................................................................................39 City of Eden Prairie, Minnesota For the Year Ended December 31, 2010 Page Required Supplemental Information Modified Approach for Infrastructure Assets.......................................................................................71 Other Post-Employment Benefits Plan..................................................................................................72 Combining Fund Statements Combining Balance Sheet- Nonmajor Governmental Funds...........................................................79 Combining Statement of Revenues, Expenditures and Changes in Fund Balance - Nonmajor Governmental Funds.............................................................................87 Combining Statement of Net Assets - Internal Service Funds...........................................................96 Combining Statement of Revenues, Expenses and Changes in Net Assets - Internal Service Funds....................................................................................................98 Combining Statement of Cash Flows- Internal Service Funds ...................................................... 100 Combining Statement of Fiduciary Net Assets- Agency Funds..................................................... 105 Combining Statement of Changes in Assets and Liabilities - Agency Funds................................ 106 Statistical Section Government-wide Net Assets by Category........................................................................................ 109 Changesin Net Assets - Total.............................................................................................................. 110 Changes in Net Assets- Governmental Activities............................................................................ I I I Changes in Net Assets- Business-type Activities............................................................................. 112 Fund Balances - Governmental Funds............................................................................................... 113 Changes in Fund Balances - Governmental Funds........................................................................... 114 Assessed/Tax Capacity Value and Estimated Market Value of Property....................................... 115 Direct and Overlapping Property Tax Rates...................................................................................... 116 Principal Property Taxpayers............................................................................................................... 117 Property Tax Levies and Collections................................................................................................... 118 LegalDebt Margin................................................................................................................................. 119 Ratios of Outstanding Debt by Type................................................................................................... 120 Ratios of Total Debt Outstanding by Type......................................................................................... 121 Computation of Direct and Overlapping Bonded Debt- General Obligation Bonds ................. 122 Demographic and Economic Statistics............................................................................................... 123 PrincipalEmployers .............................................................................................................................. 124 Employeesby Function......................................................................................................................... 125 OperatingIndicators............................................................................................................................. 132 Capital Assets Statistics by Function................................................................................................... 133 Introductory 11 + 1 April 29, 2011 To the Honorable Mayor, Members of the City Council and the Citizens of the City of Eden Prairie: The comprehensive annual financial report of the City of Eden Prairie, Minnesota, for the year ended December 31, 2010, 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 State Auditor's Office. The report consists of management's representations concerning the finances of the City. Consequently management assumes full responsibility for the completeness and reliability of all information presented within 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 will be free from 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's financial statements have been audited by Kern, DeWenter, Viere, Ltd. Certified Public Accountants. The goal of the independent audit was to provide reasonable assurance that the financial statements of the City for the year ended December 31, 2010, 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, 2010, are fairly presented inconformity with GAAP. The independent auditors report is present in 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). This letter of transmittal is designed to complement the MD&A and should be read in conjunction with it. The City's MD&A can be found in the financial section of this report immediately following the report of the independent auditors. City Profile Eden Prairie is a suburban community of 62,683 people located in the southwest corner of Hennepin County in a setting of rolling hills and picturesque lakes and creeks. Eden Prairie 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. Incorporated in 1974 as a City,the City of Eden Prairie operates under a Statutory Plan B form of government. Policymaking and legislative authorities are vested in the governing council, which consists of a mayor and a four-member council. The governing council is responsible, among other things, for passing ordinances, adopting the budget, appointing committees and hiring the government's manager and attorney. The council is elected on a nonpartisan basis. The mayor and council members are elected to four-year staggered terms. The City Manager is responsible for carrying out the policies and ordinances of the governing council, for overseeing the day-to- day operations of the government, and to assign appropriate responsibility and authority to City staff for the efficient and effective delivery of City services. The City provides its residents and businesses with a full range of municipal services consisting of police and fire protection, street maintenance, recreation programs, park maintenance, community and economic development,building inspections, and a water and sewer utility. The City is also financially accountable for the Housing and Redevelopment Authority (HRA), which is included in the City's financial statements as a blended component unit. Additional information on the HRA can be found in Note 1 in the notes to the financial statements. The biennial budget serves as the foundation for the City's financial planning and control. Departments submit budget requests to Finance in May and the City Manager presents the proposed budget to the City Council for review prior to September 151h of each year. Budget workshops are usually held with the City Council in June or July and in August. The City Council holds a public meeting on the proposed budget and adopts the final budget in December each year. During the first year of the two year budget process, both years' budgets are developed and the first year's budget is adopted by the council. During the second year of the two year budget process, "budget work" is minimized. Staff updates the budget for any significant budget developments and the council then reviews and adopts the second year budget. The budget is prepared by department and division. The City's directors and division managers may make transfers of appropriations within a division. Transfers of appropriations between departments require the approval of the City Manger. Any changes in the total budget must be approved by the City Council. Economic Conditions and Outlook The City of Eden Prairie is located in the southwest corner of the Minneapolis/St. Paul Metropolitan area. With the update of the comprehensive plan in 2008 and the trend towards condensed multi-family housing in the downtown area, it is expected that Eden Prairie's population will grow to 77,100. Year Population Increase 1960 Census 3,233 134% 1970 Census 6,938 115% 1980 Census 16,263 134% 1990 Census 39,311 142% 2000 Census 54,901 40% 2010 City Estimate 62,683 14% As you can see from the table below, the City added new market value to the tax base. The City had many large remodel projects and a new strip mall was constructed. Although not as robust as some years, the there was new development and investment in the City. iii Total Market Value $250 $12 ~ $200 $10 ° $8 �? $150 $6 $100 $4 x $50 $2 3 z $0 $0 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 New Market Value Total Market Value The City's Major Center Area (MCA) is an area that encompasses Eden Prairie Center and includes about 1,200 acres in the "downtown" area of the City. It extends to Valley View Road on the north and includes the I-494, highway 5 and highway 212 interchange areas as well as the area around Prairie Center Drive. A study completed a few years ago established a visionary plan that helps city leaders guide land use, transportation, and livability initiatives through the year 2030. The study provided recommendations to achieve the vision of the area for land use and mix, regional role, physical character, and streets and trails. To help implement the policies in the MCA plan, the City Council approved a Town Center Ordinance, Town Center Design Guidelines, and a Town Center Streetscape Master Plan. Progress was made on a few projects during 2010. Randy's Bobby & Steve's Auto World, a 22,600 square foot building located in the Town Center consisting of Convenience Retail/Automotive Service/Restaurant opened in 2010. Also, Wal-mart in the Town Center was remodeled and includes updated branding which will be more complimentary with the desired look of the Town Center. Menards demolished the current Eden Prairie store, and built a new two story store in the same location. A new retail strip mall was built on Flying Cloud Drive and includes a Smashburger restaurant and Verizon Wireless store. Presbyterian Homes has a signed development agreement for 70,000 SF of commercial space, 447 care center and senior units, and 260 market rate apartments. The exact timing of this project is not known but should be the next couple of years. iv Eden Prairie serves as the corporate headquarters location for many national and international businesses including CH Robinson World Wide, GE Capital, United Healthcare Services, numerous multi-tenant office building partnerships, Lifetouch Inc., SuperValu Inc, American Family Mutual Insurance, MTS systems Corporation, and others. Eden Prairie also has key locations for retailing including the City's mall which was completely remodeled in 2001 and has approximately 1.5 million square feet of shopping. The mall is part of the City's "Major Center Area" or downtown. Stores include a 160,000 square foot Von Maur Department Store, a Barnes and Noble Bookstore, an 18-screen AMC movie theater, numerous restaurants including Wildfire, Biaggi's, TGIF, and other national retailers. The Southwest Station is also part of the City's downtown and includes the Southwest metro transit hub and offices, 900 car parking structure, multiple restaurants and a luxury 236 unit condominium complex. Long-term Financial Planning The City has implemented various financial/budget policies to guide the Council and staff when making financial decisions to ensure the long-term stability and flexibility of City finances and operations. These polices include the following: • The original budget should be balanced with revenues equal to expenditures, • One-time revenues will be used for one-time expenditures, • The City will designate as fund balance for working capital in the general fund 50% of the next years tax levy, • The City will maintain as unreserved - designated fund balance for budget stabilization in the general fund 15% of the next years budgeted expenditures, • The City will confine long-term debt to capital improvements or projects that cannot be financed from current revenues, and • The City will maintain a five-year capital improvement plan to provide for capital asset acquisition, maintenance, replacement, and retirement. As part of the budget process, the council reviews and updates the City's financial policies. As of 12/31/10, the City is within the financial and budgetary policy guidelines set by the City Council. Major Initiatives Organizational Change In the 2010 election, a new Mayor and Council Member were elected. Nancy Tyra-Lukens was elected as mayor of Eden Prairie, having previously served on the City Council from 1994 through 2001 and as mayor from 2002 through 2006. Her current term will end Dec. 31, 2014. Tyra-Lukens has also served the community on numerous boards and commissions, including the Suburban Transit Association, the Southwest Transit Commission and the Family Housing Fund. She is currently the president of the Eden Prairie Foundation. Tyra-Lukens earned a master's degree in nutritional biochemistry from the University of Michigan and a master's degree in finance and business administration from the Carlson School of Management at the University of Minnesota. Sherry Butcher Wickstrom is serving her fourth four-year term on the Eden Prairie City Council, having previously served from 1996 through 2008. Her current term will end Dec. 31, 2014. Butcher Wickstrom has also served the community on numerous boards and commissions including the Advisory Board to the Hennepin South Services Collaborative, the Eden Prairie Foundation, the Board of Directors for the League of Minnesota Cities Insurance Trust and the Committee for Democratic Governance for the National League of Cities. Butcher Wickstrom earned a bachelor's degree in anthropology/archaeology and a master's degree in American history with a program emphasis in museum studies, both from the University of Minnesota. She is a graduate of the Dispute Resolution Institute at Hamline University School of Law and a member of the Phi Beta Kappa society. Currently, Butcher Wickstrom is the executive director of professional training at Anoka-Ramsey Community College, where she directs the Public Leadership Academy for Elected Officials and the Anoka Area Chamber of Commerce Leadership Academy. During 2010 the City began the transition and hire of anew City Manager. Rick Getchow started on 03/28/2011. He served as Hopkins, Minn. city manager from 2005 to 2011. Between 1996 and 2005, he served as city administrator for the Minnesota cities of Lauderdale and Hector. He earned his bachelor's degree in political science from Miami University (Ohio) and master's degree in public administration from the University of Wisconsin-Milwaukee. Money Magazine Recognition In 2010 Eden Prairie was named the Best Place to Live in America by Money Magazine. Reasons for the recognition include family-friendliness and the City's economy. Eden Prairie's unemployment rate is nearly one percentage point below the county rate and more than four points below the national average. The City has major employers including Fortune 500 trucking company C.H. Robinson, hearing-aid maker Starkey Labs, and the Minnesota Vikings, whose practice facility and front office are here. The City's Aaa bond rating was noted as an indicator of fiscal strength. Also, the City's 17 lakes, parks, and 125 miles of running, hiking, and biking trails were noted. Transportation Significant time was spent this year planning for big changes in the future of Eden Prairie transportation. The Southwest Transitway is a proposed high frequency light rail transit line connecting Eden Prairie, Minnetonka, Hopkins, St. Louis Park, Minneapolis neighborhoods and the Minneapolis downtown area. The Hennepin County Regional Railroad has been leading the preparation of studies and plans for a transitway to serve this growing part of the Metro Area. Staff worked closely with MnDot on plans to proceed with the Hwy. 169/I-494 interchange improvement which is a $125 million dollar project. Substantial completion of the project is anticipated to occur by mid-November 2012. Energy Initiative Over the past three years, the City of Eden Prairie has been implementing an energy initiative called 20-40-15 that is aimed at increasing the overall efficiency of the City's use of electricity, fuel and other energy resources. The plan calls for increased energy efficiency in City-owned facilities by 20 percent; increased fuel efficiency in the City's fleet of vehicles by 40 percent; and accomplishing these goals by the year 2015. The City hired McKinstry to perform energy audits and to identify energy saving projects within the City. The City is currently implementing Phase III of 20-40-15. Phase III, which the City will be completed in 2011 and includes the following changes and improvements: installing a new,more efficient energy management system which would control all heating, ventilating and air conditioning units as well as most of the interior lighting at the City Center, modifying the ice rink dehumidifier at the Community Center to make it more energy efficient, replacing three major pieces of cooling equipment at the City Center with more energy efficient units, and replacing parking lot lights at four City parks with energy-efficient LED lighting. For Phase III, the City received $626,700 of Energy Efficiency and Conservation Block Grant from the federal government. vii Upon completion of Phase Three, the City will officially surpass the half-way mark, toward accomplishing the goals set forth by the 20-40-15 initiative! With four years remaining, City staff will continue to work explore possibilities for the next phase of the 20-40-15 initiative. Other Initiatives The City Council approved a new utility rate structure that took effect Jan. 1, 2011. The changes will allow the City's utilities operation to maintain the system as it ages and encourage water conservation among Eden Prairie residents and businesses. The City's new observatory opened in October 2010. Thanks to the donation of a 9-foot tall, 16- inch Cassegrain telescope from the Minnesota Astronomical Society, Eden Prairie has one of the largest telescopes in the state of Minnesota. Also, after generous donations the City was able to build an observatory building to house it The third phase of the Miller barrier-free" park was completed in October 2010. Features accessible pathways and surface structures which gives individuals with mobility impairments access to all levels of the play structure. The design allows individuals of all abilities the opportunity to play together, giving them the opportunity to thrive. The new design allows individuals of all abilities the opportunity to play together, giving them the opportunity to thrive. The Tom &Kathy Miller Foundation has raised significant dollars for this project. 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 Eden Prairie for its Comprehensive Annual Financial Report (CAFR) for the fiscal year ended December 31, 2009. 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 Eden Prairie has received a Certificate of Achievement every year since 1990. We believe our current report continues to conform to the Certificate of Achievement program requirements, and we are submitting it to GFOA. Viii In addition, the Government Finance Officers Association of the United States and Canada (GFOA) presented the Distinguished Budget Presentation award to the City of Eden Prairie for its Two Year Budget for the fiscal years beginning January 1, 2010 and 2011. In order to receive this award, a government unit must publish a budget document that meets program criteria as a policy document, as an operations guide, as a financial plan and a communications device. The award is valid for a period of two years only. The City of Eden Prairie has received a Distinguished Budget Presentation award for every budget since 1998. Also, the Government Finance Officers Association of the United States and Canada (GFOA) has given an Award for Outstanding Achievement in Popular Annual Financial Reporting to the City of Eden Prairie for its Popular Annual Financial Report for the fiscal year ended December 31, 2009. The Award for Outstanding Achievement in Popular Annual Financial Reporting is a prestigious national award recognizing conformance with the highest standards for preparation of state and local government financial reports. In order to receive an Award for Outstanding Achievement in Popular Annual Financial Reporting, a government unit must publish a Popular Annual Financial Report, whose contents conform to program standards of creativity, presentation, understandability, and reader appeal. An Award for Outstanding Achievement in Popular Annual Financial Reporting is valid for a period of one year only. The City of Eden Prairie has received the award annually since 1998. We believe our current report continues to conform to the Popular Annual Financial Reporting requirements, and we are submitting it to GFOA. Acknowledgements We would like to express our appreciation to the employees of the Finance Division 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 progressive manner. Respectfully submitted, �L ��� Rick Getschow Sue Kotchevar City Manager Chief Financial Officer ix City of Eden Prairie, Minnesota For the Year Ended December 31, 2010 Certificate of Achievement for Excellence in Financial Reporting Presented to City of Eden Prairie Minnesota For its Comprehensive Annual Financial Report for the Fiscal Year Ended December 31,2009 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. k� �F1WL {1kflEU31ATE$ y m AN A n axant>t� President d a;4rcr � �HtCA6o � ��'f 6-cw'60�-7 Executive Director x City of Eden Prairie, Minnesota For the Year Ended December 31, 2010 City of Eden Prairie Organization Structure Citizens Housing&Redevelopment Boards&Commissions City Council Authority(HRA)* •Arts&Culture Commission *Council serves in this capacity • Board of Appeal and Equalization • Budget Advisory Commission • Conservation Commission City Manager •Flying Cloud Airport Advisory Commission • Heritage Preservation Commission City Attorney • Human Rights&Diversity Commission •Parks,Recreation&Natural Resources Commission •Planning Commission Departments Administration Community Parks&Natural Police LM&L Engineering/ Development Resources Public Works • Communication •Assessing • Community Center • Investigation •Building Inspections •Engineering •Facilities •Economic •Parks •Patrol •Emergency •Fleet Management •Finance Development •Recreation • Support Services Preparedness • Streets • Human Resources • Housing& •Fire Inspections •Utilities/Water • IT Community Services •Fire Suppression • Office of City Manager •Planning xi City of Eden Prairie, Minnesota For the Year Ended December 31, 2010 Principal Officials Elected Officials: Mayor (Term expiration 12/31/10) Phillip Young Council Member (Term expiration 12/31/12) Ron Case Council Member (Term expiration 12/31/12) Brad Aho Council Member (Term expiration 12/31/10) Jon Duckstad Council Member (Term expiration 12/31/10) Kathy Nelson Appointed Officials: City Manager (started 3/28/2011) Rick Getschow Interim City Manager Jay Lotthammer City Attorney Richard Rosow Departments: Chief of Police Rob Reynolds Community Development Director Janet Jeremiah Fire Chief George Esbensen Parks and Recreation Director Jay Lotthammer Public Works Director Eugene Dietz XLL Financial i i Expert advice. When you need it.5°' INDEPENDENT AUDITOR'S REPORT Honorable Mayor and Members of the City Council City of Eden Prairie Eden Prairie, 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 Eden Prairie, Minnesota, as of and for the year ended December 31, 2010,which collectively comprise the City's basic financial statements as listed in the Table of Contents. These financial statements are the responsibility of the City's management. Our responsibility is to express opinions on these financial statements based on our audit. The prior year partial comparative information has been derived from the City's 2009 financial statements in our report dated May 5, 2010,we expressed unqualified opinions on the respective financial statements of the governmental activities, the business-type activities, each major fund and the aggregate remaining fund information. We conducted our audit in accordance with U.S. generally accepted auditing standards and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. 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 includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our 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 of Eden Prairie, Minnesota, as of December 31, 2010, and the respective changes in financial position and where applicable, cash flows, thereof, and the respective budgetary comparison for the General Fund for the year then ended in conformity with U.S. generally accepted accounting principles. The financial statements include prior year partial comparative information. Such information does not include all of the information required in a presentation in conformity with U.S. generally accepted accounting principles. Accordingly, such information should be read in conjunction with the City's financial statements for the year ended December 31, 2009, from which such partial information was derived. Expert advice. When you need it 8m St.Cloud Twin Cities www.kdv.com 220 Park Avenue S. 3800 American Boulevard W. CertiiiedPublic Accountants P.O.Box 1304 Suite 1000 Toll Free Wealth Management St.Cloud,Minnesota Bloomington,Minnesota 877.912.7696 Payroll Services 56302 55431 Business Valuations Phone:320.251.7010 2 Phone:952.563.6800 Technology Help Desk Technology Services Fax:320.251.1784 Fax:952.563.6801 866.400.6426 K' .DV In accordance with Government Auditing Standards,we have also issued our report dated April 29, 2011, on our consideration of the City's internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts and grant agreements and other matters. The purpose of that report is to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing and not to provide an opinion on the internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards and should be considered in assessing the results of our audit. U.S. generally accepted accounting principles require that the Management's Discussion and Analysis, which follows this report letter, and the information on the City's modified approach to infrastructure reporting as well as the Schedule of Funding Progress,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(GASB), who considers it to be an essential part of the 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 U.S. generally accepted auditing standards,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. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City's financial statements as a whole. The accompanying supplementary information identified in the Table of Contents is presented for purposes of additional analysis and is not a required part of the financial statements. The supplementary information is the responsibility of management and was derived from and relates 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 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 procedures in accordance with U.S. generally accepted auditing standards. In our opinion, the information is fairly stated, in all material respects in relation to the financial statements as a whole. The information identified in the Table of Contents as the Introductory and Statistical Sections is presented for purposes of additional analysis and is not a required part of the basic financial statements of the City. This information has not been subjected to the auditing procedures applied in the audit of the basic financial statements and, accordingly, we express no opinion on it. 16A4,-( * U)ZVA/ KERN,DEWENTER,VIERE,LTD. St. Cloud, Minnesota April 29, 2011 3 City of Eden Prairie, Minnesota Management's Discussion and Analysis As management of the City of Eden Prairie, this section of the City's comprehensive annual financial report presents a discussion and analysis of the City's financial activities during the fiscal year ended December 31, 2010. This discussion and analysis should be read in conjunction with the transmittal letter in the introductory section of this report. Financial Highlights The City as a Whole • The assets of the City exceeded liabilities by$373 million. Of this amount, $56 million (unrestricted net assets) may be used to meet the City's ongoing obligations to citizens and creditors, $308 million is invested in capital assets,net of related debt, and$9 million is restricted. • The City's total net assets decreased by$107,095 or .03%. • The City's total long-term liabilities decreased by $2.8 million or 7% in comparison with the prior year. The key factor in this decrease was the current year retirements of outstanding bonds. In 2010, debt was issued for the Single Tree Lane project. Fund Financial Statements • The City's governmental funds reported combined ending fund balances of$46 million, an increase of $502,977 or 1% in comparison with the prior year. The changes in fund balance can be contributed to changes to various funds including the following: • Increase in fund balance of$352,280 in the General fund which maintains the City's fund balance policy of maintaining adequate working capital for the first six months of next year and providing for budget stabilization. • Decrease in fund balance of$412,238 in the Capital Improvement Maintenance fund, of which details can be found on page 14. • Increase in fund balance of$1,026,085 in the Public Improvement Construction fund due mainly to the collection of special assessment debt for prior construction costs. • Other governmental funds had an overall decrease in fund balance of$537,680 due mainly to the following increases and decreases: • Decrease in fund balance of$828,527 in the HRA Lease Revenue 2002 fund due to planned use of fund balance to repay debt. • Increase in fund balance of$344,700 in the Park Improvement fund due to park dedication fees. • Decrease in fund balance of $777,241 in the Economic Development fund due to planned project expenses and transfers. • Increase in fund balance of$792,506 in the Project fund due to overpayments from Hennepin County that will be refunded. 4 City of Eden Prairie, Minnesota Management's Discussion and Analysis • Approximately 99.6% of the combined fund balances in the governmental funds is unreserved and therefore available to meet the City's current and future needs. Using This Annual Report This annual report consists of a series of financial statements. The Statement of Net Assets and the Statement of Activities provide information about the activities of the City as a whole and present a longer-term view of the City's finances. For governmental activities, the fund financial statements tell how these services were financed in the short term as well as what remains for future spending. Fund financial statements also report the City's operations in more detail than the government-wide statements by providing information about the City's most significant funds. The remaining statements provide financial information about activities for which the City acts solely as a trustee or agent for the benefit of those outside of the government. Reporting the City as a Whole The Statement of Net Assets and the Statement of Activities One of the most important questions asked about the City's finances is "Is the City as a whole better off or worse off as a result of the year's activities?" The Statement of Net Assets and the Statement of Activities report information about the City as a whole and about its activities in a way that helps answer this question. These statements include all assets and liabilities using the accrual basis of accounting, which is similar to the accounting used by most private-sector companies. All of the current year's revenues and expenses are taken into account regardless of when cash is received or paid. These two statements report the City's net assets and changes in them. You can think of the City's net assets — the difference between assets and liabilities — as one way to measure the City's financial health, or financial position. Over time, increases or decreases in the City's net assets are one indicator of whether its financial health is improving or deteriorating. You will need to consider other nonfinancial factors, however, such as changes in the City's property tax base and the condition of the City's roads, to assess the overall health of the City. In the Statement of Net Assets and the Statement of Activities, we divide the City into two kinds of activities: • Governmental Activities — Most of the City's basic services are reported here, including general government, public safety, public works, and parks and recreation. Property taxes, charges for services, and capital grants and contributions finance most of these activities. 5 City of Eden Prairie, Minnesota Management's Discussion and Analysis • Business-type Activities — The City charges a fee to customers to help it cover all or most of the cost of certain services it provides. The City's utility system (Water/Sewer Fund and Storm Drainage Fund) and liquor operations are reported here. Reporting the City's Most Significant Funds Fund Financial Statements The fund financial statements provide detailed information about the most significant funds — not the City as a whole. Some funds are required to be established by State law and by bond covenants. However, the City Council establishes many other funds to help it control and manage money for particular purposes or to show that it is meeting legal responsibilities for using certain grants and other money. The City's two kinds of funds — governmental and proprietary — use different accounting approaches. • Governmental funds — Most of the City's basic services are reported in governmental funds, which focus on how money flows into and out of those funds and the balances left at year-end that are available for spending. These funds are reported using an accounting method called modified accrual accounting, which measures cash and all other financial assets that can readily be converted to cash. The governmental fund statements provide a detailed short-term view of the City's general government operations and the basic services it provides. Governmental fund information helps to determine whether there are more or fewer financial resources that can be spent in the near future to finance the City's programs. We describe the relationship between governmental activities (reported in the Statement of Net Assets and the Statement of Activities) and governmental funds in a reconciliation provided after the fund financial statements. • Proprietary funds — When the City charges customers for the services it provides — these services are generally reported in proprietary funds. Proprietary funds are reported in the same way that all activities are reported in the Statement of Net Assets and the Statement of Activities. The City of Eden Prairie maintains two different types of proprietary funds. • Enterprise funds are the same as the business-type activities reported in the government-wide statements but provide more detail and additional information, such as cash flows. • Internal service funds are an accounting device used to accumulate and allocate costs internally among the City's various functions. The City uses internal service funds to account for activities pertaining to employee benefits, workers compensation, personal time off accruals, property insurance,facilities, fleet services, and information technology. 6 City of Eden Prairie, Minnesota Management's Discussion and Analysis The City as Trustee Reporting the City's Fiduciary Responsibilities All of the City's fiduciary activities are reported in separate Statement of Fiduciary Net Assets. The City is fiduciary for resources collected and owed to others including developers and governmental agencies. We exclude these activities from the City's other financial statements because the City cannot use these assets to finance operations. The City is responsible for ensuring that the assets reported in these funds are used for their intended purposes. The accounting used for fiduciary funds is much like that used for proprietary funds. The City as a Whole The City maintained its financial position for the last two years at $373 million. By far the largest portion of the City of Eden Prairie's net assets, $308 million (approximately 83%) 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 of Eden Prairie 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. An additional portion of the City's net assets $9 million (approximately 2%), represents resources that are subject to external restrictions on how they may be used. The remaining balance of unrestricted net assets, $56 million (approximately 15%), may be used to meet the City's ongoing obligations to citizens and creditors. At the end of the current fiscal year, the City is able to report positive balances in all of the categories of net assets reported for the government as a whole. City of Eden Prairie, Minnesota Management's Discussion and Analysis The following schedule provides a summary of the City's net assets for the year ended December 31, 2010 (in thousands): Governmental Activities Business-Type activities Total 2010 2009 2010 2009 2010 2009 Current and other assets $ 66,081 $ 64,621 $ 7,026 $ 8,065 $ 73,107 $ 72,686 Capital assets 203,633 203,400 138,307 142,093 341,940 345,493 Total assets 91$ 269,714 $ 268,021 $ 145,333 $ 150,158 $ 415,047 $ 418,179 Long-term liabilities 36,415 39,026 297 238 36,712 39,264 Other liabilities 3,587 4,038 1,504 1,526 5,091 5,564 Total liabilities $ 40,002 $ 43,064 $ 1,801 $ 1,764 $ 41,803 $ 44,828 Net assets: Invested in capital assets,net related debt $ 169,874 $ 165,579 $ 138,307 $ 142,093 $ 308,181 $ 307,672 Restricted 8,883 9,471 - - 8,883 9,471 Unrestricted 50,955 49,907 5,225 6,301 56,180 56,208 Total net assets $ 229,712 $ 224,957 $ 143,532 $ 148,394 $ 373,244 $ 373,351 Key elements of these changes are shown on the following page. s City of Eden Prairie, Minnesota Management's Discussion and Analysis Governmental Activities Business-Type activities Total 2010 2009 2010 2009 2010 2009 Revenues: Program revenues Charges for services $ 8,609 $ 7,285 $ 23,623 $ 24,116 $ 32,232 $ 31,401 Operating grants and contributions 1,320 1,736 32 - 1,352 1,736 Capital grants and contributions 3,104 3,341 - - 3,104 3,341 General revenues Property taxes 31,527 31,687 - - 31,527 31,687 Tax Increment 3,450 3,251 - - 3,450 3,251 Grants and contributions 230 207 - - 230 207 Investment income 427 673 12 13 439 686 Gain on sale of capital assets - (1,506) - - - (1,506) Total revenues 48,667 46,674 23,667 24,129 72,334 70,803 Expenses: General government 9,183 9,506 - - 9,183 9,506 Public safety 17,986 19,347 - - 17,986 19,347 Public works 7,523 8,129 - - 7,523 8,129 Parks and recreation 9,769 8,606 - - 9,769 8,606 Interest on long term debt 1,241 1,809 - - 1,241 1,809 Water/Sewer - - 14,036 13,463 14,036 13,463 Storm - - 1,983 1,524 1,983 1,524 Liquor - - 10,720 10,613 10,720 10,613 Total expenses 45,702 47,397 26,739 25,600 72,441 72,997 Changes in net assets before transfers 2,965 (723) (3,072) (1,471) (107) (2,194) Internal transfers 1,790 690 (1,790) (690) - - Change in net assets 4,755 (33) (4,862) (2,161) (107) (2,194) Net assets,January 1 224,957 224,990 148,394 150,555 373,351 375,545 Net assets,December 31 $ 229,712 $ 224,957 $ 143,532 $ 148,394 $ 373,244 $ 373,351 9 City of Eden Prairie, Minnesota Management's Discussion and Analysis Governmental Activities Revenue by Source Charges for Other services 1% 18% Grants and contributions 9% Property taxes and tax increment 72% • For the year, property taxes totaled $31,527,570 which is a decrease of $159,707 or .5% from 2009. In 2009, the HRA Lease Revenue Facility Bonds fund and the G.O. Obligation Equipment Cert. 2004 fund were closed. Offsetting the decrease was the collection of property taxes for the first time in 2010 in the Capital Equip Notes 2009B fund and the CIP Refunding Bonds 2009C fund. • Charges for services increased by$1,323,570 or 18% from 2009. This was due mainly to increased building permit revenue and increased revenue at the community center for memberships and facilities rentals. • Operating grants and contributions decreased by $415,585 or 24% from 2009. This was mainly due to the Community Development Block Grant. • Capital grants and contributions decreased by $237,051 or 7% from 2009. This was due to a decrease in state street aid which was offset by an increase in revenue for the energy efficient grant. 10 City of Eden Prairie, Minnesota Management's Discussion and Analysis Expenses by Program Parks & Other General recreatio n 3% government 21% 20% Public works 17%o Public safety 39% Expenses and Program Revenues-Governmental Activities (in Thousands) 20,000 18,000 16,000 14,000 12,000 10,000 8,000 6,000 4,000 2,000 General Public safetyPublic works Parks and Interest on govt. recreation long term d ebt ■expenses ■program revenue 11 City of Eden Prairie, Minnesota Management's Discussion and Analysis Business-type Activities For the business-type activities, charges for services accounts for 99% of revenues. The Liquor operations had a negative change in net assets of $79,648 due mainly to the maintenance of the Den Road building. The Water/Sewer Fund and Storm Drainage Fund had a negative change to net assets of $3,524,493 and $1,258,238 due mainly to depreciation expense. Sales decreased due to a decrease in the water usage. Water usage for the year is 2.8 billion gallons which is a decrease of 428 million gallons from 2009. Sewer rates were increased from $2 per 1,000 gallons to $2.20 per 1,000. Also in 2010 Utilities had $9,834 and $6,147 in capital contribution whereas in 2009 there were $219,881 and $239,893 in capital contributions. Expenses and Program Revenues - Business- type Activities (in Thousands) $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $0 Water/Sewer Storm Liquor OExpenses ■Program revenue 12 City of Eden Prairie, Minnesota Management's Discussion and Analysis The City's Funds The General fund is the chief operating fund of the City of Eden Prairie. The General fund had positive financial performance and the fund balance increased by $352,280. The table below reflects the changes to the City's General fund reserved and designated fund balances. 2010 2009 Difference Fund Balance: Reserved Encumbrances $ 29,000 $ 27,500 $ 1,500 Prepaid items 37,238 28,364 8,874 Unreserved- Budget stabilization 5,534,147 5,534,147 - Working capital 15,343,104 15,001,198 341,906 Total fund balance $ 20,943,489 $ 20,591,209 $ 352,280 Reserve Balances The amounts reserved in the General fund are amounts set aside for a specific purpose. The City is either obligated to pay these amounts in the future or the amounts are not currently available. Reserved for encumbrances represents amounts authorized by the City Manager for divisions to spend the next calendar year. Unreserved- Designated Balances The unreserved fund balance consists of the budget stabilization balance and the working capital balance. Budget Stabilization In compliance with City policy, $5,534,147 was maintained for budget stabilization which is 15% of the 2011 budget. Working Capital In compliance with City policy, 50% of the next year's tax levy or $13,999,507 is designated for working capital. This amount represents the amount needed to fund operations for the first six months of the year. The City receives a tax settlement in December that funds operations until the next settlement in June of the next year. An additional $1,343,597 was designated to pay for the planned use of the budget stabilization balance for the 2011 budget. 13 City of Eden Prairie, Minnesota Management's Discussion and Analysis Other Major Funds The General Obligation Improvement Revolving 2005B fund increased by$63,283 in 2010. The increase is due to the receipt of special assessment revenue to pay debt payments. The General Obligation Improv. Bonds 2003D fund decreased by $25,787 in 2010. The decrease is due to planned use of fund balance to repay debt. The Capital Improvement Maintenance fund decreased by$412,238 in 2010. Revenue of$1,039,716 was collected which includes the tax levy, special assessments, building rental income, grant revenue for the 20-40-15 project, donations, energy efficient rebate and investment income. The costs for the year pertained to the Miller Park improvement, 20/40/15 Energy Initiative, SCBA gear and police/fire enhancements. The Public Improvement Construction fund increased by$1,026,085 in 2010. Revenue of$613,342 was collected which includes special assessments, state street aid, reimbursement from MN Dot for their share of project costs and investment income. During the year, $1,190,000 of bond proceeds was received for the Single Tree Lane project. As of December 31, 2010, the fund had a negative fund balance of$2,734,995. The deficit will be reduced with the collection of special assessments and state aid. The Flying Cloud Drive fund increased by $37,034 in 2010. The Flying Cloud Drive project is the development of a three lane road. The funding for this project includes bond proceeds. As of December 31, 2010, the fund had a positive fund balance of$376,688. This fund will be closed in 2011. The City's proprietary funds provide the same type of information found in the government-wide financial statements,but in more detail. Water and sewer revenues through December 31, 2010 totaled $10,760,102 which is a decrease of $574,428 or 5% from 2009 due to the following: • Sales decreased by approximately $920,000 due to consumption decreasing from 3.2 billion gallons in 2009 to 2.8 billion gallons in 2010. The decrease was offset by approximately$257,000 due to a rate increase of twenty cents per 1,000 gallons for sewer. • Conservation surcharge decreased by $130,234 due to the decrease in demand for water consumption during the summer months. • Access charges increased by$161,590 due mainly from the remodel of the Menards store. Liquor sales had a moderate increase of .5% over 2009 to $11,524,121. Overall operating expenses remained the same except for a small increase for the maintenance of the building. 14 City of Eden Prairie, Minnesota Management's Discussion and Analysis Budgetary Highlights The General fund had positive operating results. Total revenues equaled $37,201,861 or 106% of the amount budgeted. The positive performance is due to conservative budgeting including a 2% allowance for uncollectible taxes, positive development revenue and revenues collected from the Community Center. Other items had positive and negative variances. Total expenditures equaled $36,324,346 or 99% of the budget. Various divisions were over and under budget. Capital Assets and Debt Administration Capital Assets At the end of 2010,the city had$342 million invested in capital assets. Major capital assets added during the current fiscal year by fund include the following: Utility Construction Metal Roof Replacement - Water Plant $ 390,891 Watermain Replacement (Westwind, Windward) 145,561 TH212/PCD Interchange Stage I 56,112 Improvement Projects Singletrcc Improvements 1,008,360 CSAH 1 273,865 Capital Maintenance &Reinvestment Fund Miller Park Play Area 462,596 CIP - Bonds 20/40/15 Project - Phase 3 489,632 SCBA Equipment 395,623 Police &Fire All-in One Software 328,184 Facilities Capital City Center heat Pump Replacement 93,980 Building Assessments 75,669 Community Center Family Locker Room Tile 69,954 15 City of Eden Prairie, Minnesota Management's Discussion and Analysis Capital Assets (net of depreciation, in thousands) Governmental Activities Business-type Activities Total 2010 2009 2010 2009 2010 2009 Land&land improv. $ 32,676 $ 32,513 $ 710 $ 712 $ 33,386 $ 33,225 Infrastructure 117,008 116,752 - - 117,008 116,752 Distribution system - - 98,697 101,978 98,697 101,978 Buildings&work in progress 47,041 46,444 35,414 37,881 82,455 84,325 Leasehold improvements 45 49 691 353 736 402 Machinery&equipment 906 1,125 2,657 984 3,563 2,109 Autos 3,802 4,163 94 139 3,896 4,302 Other assets 2,155 2,354 44 46 2,199 2,400 Total $ 203,633 $ 203,400 $ 138,307 $ 142,093 $ 341,940 $ 345,493 The City has chosen to maintain infrastructure using the modified approach. This means the City does not depreciate the cost of infrastructure but maintains the system at a "good condition" level or higher. Additional information on the modified approach can be found in Note 1 of this report and additional information on the City's capital assets can be found in Note 4 of this report. The City's policy is to achieve an average rating of good (55-69) for all streets and trails. In the summer of 2010, the City conducted a physical condition assessment. This assessment will be performed every three years. As of December 31, 2010, the City's infrastructure system was rated at a Pavement Condition Index (PCI) of 81.1%, which is higher than the City's policy level. The City's infrastructure are constantly deteriorating resulting from the following factors: (1) traffic using the system; (2) the sun's ultra-violet rays drying out and breaking down the top layer of pavement; (3) utility company/private development trenching operations; (4) water damage from natural precipitation; and (5) frost heave. The City is continuously taking actions to prolong the life of the system through short- term maintenance activities such as pothole patching, crack sealing, seal coating, and overlaying. The City expended $1,960,670 on infrastructure maintenance for the year ending December 31, 2010. These expenditures delayed deterioration; however, the overall condition of the system was not improved through these maintenance expenditures. The City has estimated that the amount of annual expenditures required maintaining the City's infrastructure at the average PCI rating of good is approximately$1,661,000. 16 City of Eden Prairie, Minnesota Management's Discussion and Analysis Debt At year-end, the City had approximately $36 million in bonds and other long-term liabilities outstanding versus $39 million last year. The City issued $1.2 million of General Obligation Permanent Improvement Revolving bonds for the Single Tree Lane project. Refer to Note 10 in the Notes to Financial Statements for a detailed schedule showing the City's long- term debt activity. Economic Factors and Next Year's Budgets The City's elected officials consider many factors when adopting the budget and determining fees for service and fees that will be charged for the business-type activities. These factors include service levels, the tax impact on the median value home, commercial/industrial and household growth, and inflation. Currently, the 2011 general fund budgeted appropriations are $36,894,313 which is the same as the 2010 budget. Budgeted revenues less expenditures total ($1,343,597). The City plans to use fund balance for the difference. The City will soon start reviewing the plans for the 2012/13 budget and work on a plan to more closely balance the budget. During the year, the City retained Advanced Engineering and Environmental Services, Inc. (AE2S) to develop a ten-year utility rate study for its Water, Sewer, and Storm Drainage Utilities. Continuing to provide above average service at affordable rates, while providing for the long term sustainability of the utilities is a primary goal for the City of Eden Prairie. This study and the implementation of the recommendations is an important step in planning for the challenges associated with successfully and equitably meeting future utility revenue requirements. The goals/tasks of the study included the following: • A high level engineering review of the status of the infrastructure to determine appropriate amounts to collect for the capital needs of the system • Preparation of budget projections • Analysis of the current rate structure and evaluation of the need for rate adjustments based on budget projections • Possible recommendation(s) of a different rate design if it would better meet the needs of citizens and the utility system • Review of irrigation cost demand on the system and analysis to determine if irrigation demand is paid by customers who irrigate • Recommendation of reserve policies to ensure the utility is prepared to meet capital, contingency and other needs. 17 City of Eden Prairie, Minnesota Management's Discussion and Analysis A new block rate structure was implemented January 1, 2011 that will meet the long term needs of the system. Contacting the City's Financial Management This financial report is designed to provide a general overview of the City's finances for those interested in the government's finances. If you have questions about this report or need additional financial information, contact the Finance Division at City of Eden Prairie, 8080 Mitchell Road, Eden Prairie, MN 55344. 18 Government- w ide Financial Statements CITY OF EDEN PRAIRIE,MINNESOTA STATEMENT OF NET ASSETS DECEMBER 31,2010 Primary Government Governmental Business-type Activities Activities Total ASSETS: Cash and cash equivalents $ 53,628,069 $ 2,048,145 $ 55,676,214 Receivables: Accounts 488,775 2,229,882 2,718,657 Interest 137,469 7,541 145,010 Due from other governments 546,609 31,258 577,867 Unremitted taxes 678,395 - 678,395 Delinquent taxes 420,826 - 420,826 Unremitted special assessments 431 18,052 18,483 Delinquent special assessments 23,818 400,725 424,543 Deferred special assessments 8,129,570 390,222 8,519,792 Special deferred assessments 771,669 407,190 1,178,859 Inventories 90,971 1,166,362 1,257,333 Prepaid items 269,532 326,388 595,920 Land held for resale 801,699 - 801,699 Restricted cash and cash equivalents 93,265 - 93,265 Capital assets: Nondepreciable: Land 22,600,571 656,356 23,256,927 Infrastructure 117,007,512 - 117,007,512 Work in progress 7,594,200 2,409,529 10,003,729 Depreciable buildings,property and equipment,net 56,430,938 135,241,267 191,672,205 Total assets $ 269,714,319 $ 145,332,917 $ 415,047,236 LIABILITIES: Accounts and contracts payable $ 1,712,026 $ 1,242,476 $ 2,954,502 Salaries payable 788,681 116,879 905,560 Interest payable 105,691 - 105,691 Due to other governments 284,508 142,080 426,588 Unearned revenue 697,352 2,671 700,023 Net OPEB Due in more than one year 494,335 77,816 572,151 Bonds payable Due within one year 4,035,000 - 4,035,000 Due in more than one year 30,193,787 30,193,787 Capital lease payable Due within one year 42,751 - 42,751 Compensated absences Due within one year 873,715 116,066 989,781 Due in more than one year 774,803 102,929 877,732 Total liabilities 40,002,649 1,800,917 41,803,566 NET ASSETS: Invested in capital assets,net of related debt 169,874,219 138,307,152 308,181,371 Restricted for perpetual care,nonexpendable 117,656 - 117,656 Restricted for debt service 8,765,298 - 8,765,298 Unrestricted 50,954,497 5,224,848 56,179,345 Total net assets 229,711,670 143,532,000 373,243,670 Total liabilities and net assets $ 269,714,319 $ 145,332,917 $ 415,047,236 The notes tofinancial statements are an integral part of this statement 20 CITY OF EDEN PRAIRIE,MINNESOTA STATEMENT OF ACTIVITIES FOR THE YEAR ENDED DECEMBER 31,2010 Program Revenue Operating Capital Charges for Grants and Grants and Expenses Services Contributions Contributions Functions/Programs: Primary government: Governmental activities: General government $ 9,183,334 $ 958,005 $ 338,974 $ 528,238 Public safety 17,985,648 3,135,082 881,444 79,605 Public works 7,522,749 230,390 70,620 1,923,320 Parks and recreation 9,769,235 4,285,057 28,976 572,433 Interest on long term debt 1,240,511 - - - Total governmental activities 45,701,477 8,608,534 1,320,014 3,103,596 Business-type activities: Water/Sewer 14,035,916 11,103,035 - - Storm 1,983,337 831,731 31,498 - Liquor 10,719,819 11,687,919 - - Total Business-type activities 26,739,072 23,622,685 31,498 - Total primary government $ 72,440,549 $ 32,231,219 $ 1,351,512 $ 3,103,596 General revenues: Taxes: Property taxes,levied for general purposes Property taxes,levied for debt service Tax increment Grants and contributions not restricted to specific programs Investment earnings Transfers Total general revenues and transfers Change in net assets Total net assets,January 1 Total net assets,December 31 The notes to financial statements are an integral part of this statement 21 Net(Expense) Revenue and Changes in Net Assets Governmental Business-type Activities Activities Total $ (7,358,117) $ - $ (7,358,117) (13,889,517) - (13,889,517) (5,298,419) - (5,298,419) (4,882,769) - (4,882,769) (1,240,511) - (1,240,511) (32,669,333) - (32,669,333) - (2,932,881) (2,932,881) - (1,120,108) (1,120,108) - 968,100 968,100 - (3,084,889) (3,084,889) (32,669,333) (3,084,889) (35,754,222) 28,160,196 - 28,160,196 3,367,374 - 3,367,374 3,450,291 - 3,450,291 229,510 - 229,510 427,377 12,379 439,756 1,789,869 (1,789,869) - 37,424,617 (1,777,490) 35,647,127 4,755,284 (4,862,379) (107,095) 224,956,386 148,394,379 373,350,765 $ 229,711,670 $ 143,532,000 $ 373,243,670 The notes to financial statements are an integral part of this statement 22 Fund Financial Statements CITY OF EDEN PRAIRIE,MINNESOTA BALANCE SHEET GOVERNMENTALFUNDS DECEMBER 31,2010 Page 1 of 2 Debt Service Capital Projects General General Obligation Obligation Improv. Improv. Capital Revolving Bonds Improvement General 2005B 2003D Maintenance ASSETS Cash and investments $ 21,426,934 $ 271,593 $ $ 4,529,570 Receivables: Accounts 420,884 - 41,348 Interest 49,866 742 16,659 Due from other governments 65,359 - - Unremitted taxes 359,962 1,130 Delinquent taxes 419,479 1,347 Unremitted special assessments - 6 - Delinquent special assessments 999 - - 6,046 Deferred special assessments - 2,045,663 980,994 98,880 Special deferred assessments - 120,762 317,922 Due from other funds - - 2,584,472 Prepaid items 37,238 - Land held for resale - Cash and investments with escrow agent - - - - Total assets $ 22,780,721 $ 2,317,998 $ 1,101,762 $ 7,597,374 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ 576,431 $ $ $ 32,115 Salaries payable 718,012 - Interest payable - 1,562 Due to other governments 16,625 - 10 Due to other funds - 430,776 - Unearned revenue 105,686 - 134,133 Deferred revenue 420,478 2,045,663 1,101,756 424,195 Total liabilities 1,837,232 2,045,663 1,534,094 590,453 Fund balance: Reserved Reserved for encumbrances 29,000 - - - Reserved for prepaid items 37,238 Reserved for perpetual care - Unreserved,reported in: General fund,designated for budget stabilization 5,534,147 General fund,designated for working capital 15,343,104 Special revenue fund,undesignated - - Debt service fund,undesignated 272,335 (432,332) - Capital projects fund,undesignated - 7,006,921 Permanent fund,undesignated - - - Total fund balance 20,943,489 272,335 (432,332) 7,006,921 Total liabilities and fund balance $ 22,780,721 $ 2,317,998 $ 1,101,762 $ 7,597,374 The notes to financial statements are an integral part of this statement 24 CITY OF EDEN PRAIRIE,MINNESOTA BALANCE SHEET GOVERNMENTALFUNDS DECEMBER 31,2010 Page 2 of 2 Capital Projects Public Other Total Improvement Flying Cloud Governmental Governmental Construction Drive Funds Funds ASSETS Cash and investments $ - $ 375,522 $ 19,012,271 $ 45,615,890 Receivables: Accounts 585 - 275 463,092 Interest - 1,166 50,749 119,182 Due from other governments - 479,583 544,942 Unremitted taxes 317,303 678,395 Delinquent taxes - - 420,826 Unremitted special assessments 425 431 Delinquent special assessments 16,773 - - 23,818 Deferred special assessments 2,550,237 1,430,000 1,023,796 8,129,570 Special deferred assessments 332,985 - - 771,669 Due from other funds - 525,546 3,110,018 Prepaid items 530 37,768 Land held for resale 801,699 801,699 Cash and investments with escrow agent - - 93,265 93,265 Total assets $ 2,901,005 $ 1,806,688 $ 22,305,017 $ 60,810,565 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ 141,020 $ $ 350,427 $ 1,099,993 Salaries payable - 5,080 723,092 Interest payable 10,513 371 12,446 Due to other governments - 5 16,640 Due to other funds 2,584,472 94,770 3,110,018 Unearned revenue - 352,829 592,648 Deferred revenue 2,899,995 1,430,000 1,023,796 9,345,883 Total liabilities 5,636,000 1,430,000 1,827,278 14,900,720 Fund balance: Reserved Reserved for encumbrances - - - 29,000 Reserved for prepaid items 530 37,768 Reserved for perpetual care 117,656 117,656 Unreserved,reported in: General fund,designated for budget stabilization - 5,534,147 General fund,designated for working capital - 15,343,104 Special revenue fund,undesignated 548,831 548,831 Debt service fund,undesignated - 4,543,747 4,383,750 Capital projects fund,undesignated (2,734,995) 376,688 15,126,391 19,775,005 Permanent fund,undesignated - 140,584 140,584 Total fund balance (2,734,995) 376,688 20,477,739 45,909,845 Total liabilities and fund balance $ 2,901,005 $ 1,806,688 $ 22,305,017 $ 60,810,565 The notes to financial statements are an integral part of this statement 25 CITY OF EDEN PRAIRIE,MINNESOTA GOVERNMENTALFUNDS RECONCILIATION OF THE BALANCE SHEET OF GOVERNMENTAL FUNDS TO THE STATEMENT OF NET ASSETS DECEMBER 31,2010 Total fund balance-governmental funds $ 45,909,845 Amounts reported for governmental activities in the Statement of Net Assets are different because: 1. Capital assets used in governmental activities are not financial resources and therefore are not reported as assets in governmental funds. Cost of capital assets 228,180,871 Less accumulated depreciation (25,368,602) 2. 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: Bond principal payable (34,228,787) Capital lease (42,751) 3. Taxes and special assessment receivable will be collected in future years,but are not available soon enough to pay for the current period's expenditures and therefore are deferred in the funds. 9,345,883 4. Governmental funds do not report a liability for accrued interest on long-term debt until due and payable. (93,099) 5. Internal service funds are used by management to charge the costs of employee benefits to individual funds. The assets and liabilities of the internal service fund are included in governmental activities in the statement of net assets. 6,008,310 Total net assets-governmental activities $ 229,711,670 The notes to financial statements are an integral part of this statement 26 CITY OF EDEN PRAIRIE,MINNESOTA STATEMENT OF REVENUES,EXPENDITURES, AND CHANGES IN FUND BALANCES GOVERNMENTALFUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Page 1 of 2 Debt Service Capital Projects General General Obligation Obligation Improv. Improv. Capital Revolving Bonds Improvement General 2005B 2003D Maintenance REVENUES General property taxes $ 27,984,674 $ - $ - $ 93,181 Special assessments 2 253,124 156,469 90,906 Penalties and interest 73,353 - - - Licenses and permits 3,119,449 - Intergovernmental revenue 1,122,980 489,632 Charges for services 3,919,848 - Fines and forfeits 496,074 - - Investment income 179,990 3,232 31,419 Building rental - - 229,510 Miscellaneous revenue 305,491 - - 105,068 Total revenues 37,201,861 256,356 156,469 1,039,716 EXPENDITURES Current: General government 5,487,297 - - - Public safety 16,674,307 Public works 5,133,977 Parks and recreation 8,830,160 - Interest on interfund borrowing - 4,650 - Capital outlay: General government - - 616,096 Public safety 138,549 723,998 Public works 12,303 3,328 Parks and recreation 2,901 - - 511,361 Debt service: Principal 40,749 105,000 150,000 - Interest 4,103 87,623 27,175 Bond issuance cost - - - Fiscal agent fees - 450 431 - Total expenditures 36,324,346 193,073 182,256 1,854,783 Excess of revenues over(under)expenditures 877,515 63,283 (25,787) (815,067) Other financing sources(uses): Issuance of debt - - Premium - - Transfers in 945,816 2,187,829 Transfers out (1,471,051) (1,785,000) Total other financing sources(uses) (525,235) - 402,829 Net change in fund balances 352,280 63,283 (25,787) (412,238) Fund balance(deficit)-beginning 20,591,209 209,052 (406,545) 7,419,159 Fund balance(deficit)-ending $ 20,943,489 $ 272,335 $ (432,332) $ 7,006,921 The notes to financial statements are an integral part of this statement 27 CITY OF EDEN PRAIRIE,MINNESOTA STATEMENT OF REVENUES,EXPENDITURES, AND CHANGES IN FUND BALANCES GOVERNMENTALFUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Page 2 of 2 Capital Projects Public Other Total Improvement Flying Cloud Governmental Governmental Construction Drive Funds Funds REVENUES General property taxes $ - $ - $ 7,014,699 $ 35,092,554 Special assessments 361,447 206,253 260,373 1,328,574 Penalties and interest - - - 73,353 Licenses and permits - - 3,119,449 Intergovernmental revenue 240,225 584,604 2,437,441 Charges for services - - 3,919,848 Fines and forfeits - 375 496,449 Investment income 3,781 187,859 406,281 Building rental - - - 229,510 Miscellaneous revenue 11,670 - 957,505 1,379,734 Total revenues 613,342 210,034 9,005,415 48,483,193 EXPENDITURES Current: General government - - 3,239,597 8,726,894 Public safety 114,743 16,789,050 Public works 143,675 5,277,652 Parks and recreation - 44,598 8,874,758 Interest on interfund borrowing 36,569 1,748 42,967 Capital outlay: General government - - 616,096 Public safety - - 862,547 Public works 1,238,699 2,349,544 3,603,874 Parks and recreation - 323,080 837,342 Debt service: Principal 3,615,000 3,910,749 Interest - 1,242,542 1,361,443 Bond issuance cost 28,442 3,800 32,242 Fiscal agent fees - 10,952 11,833 Total expenditures 1,303,710 - 11,089,279 50,947,447 Excess of revenues over(under)expenditures (690,368) 210,034 (2,083,864) (2,464,254) Other financing sources(uses): Issuance of debt 1,190,000 - 1,190,000 Premium 13,820 - 13,820 Transfers in 640,115 2,398,356 6,172,116 Transfers out (127,482) (173,000) (852,172) (4,408,705) Total other financing sources(uses) 1,716,453 (173,000) 1,546,184 2,967,231 Net change in fund balances 1,026,085 37,034 (537,680) 502,977 Fund balance(deficit)-beginning (3,761,080) 339,654 21,015,419 45,406,868 Fund balance(deficit)-ending $ (2,734,995) $ 376,688 $ 20,477,739 $ 45,909,845 The notes to financial statements are an integral part of this statement 28 CITY OF EDEN PRAIRIE,MINNESOTA RECONCILIATION OF THE STATEMENT OF REVENUES,EXPENDITURES, AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES FOR THE YEAR ENDED DECEMBER 31,2010 Total net change in fund balances-governmental funds $ 502,977 Amounts reported for Governmental Activities in the Statement of Activities are different because: 1. 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 life's as depreciation expense. Capital outlays 3,428,979 Depreciation expense (3,201,919) The net affect of the disposal of capital assets Contributed to Enterprise funds 46,126 Disposals (1,687,905) Depreciation on disposals 1,643,822 2. Principal payments of long-term debt consumes the current financial resources of governmental funds,however they have no effect on net assets. 3,910,749 3. 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 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. 50,167 4. The issuance of long-term debt provides current financial resources to governmental funds and has no effect on net assets. These amounts are reported in the governmental funds as a source of financing. These amounts are not shown as revenue in the Statement of Activities,but rather constitute long-term liabilities in the Statement of Net Assets. (1,190,000) 5. Governmental funds report debt issuance premiums,discounts and issuance costs as another financing source or use at the time of issuance. Premiums and discounts are reported as an unamortized asset or liability in the Government-wide financial statements. Premiums (13,820) Amortization of premiums/discounts 37,992 6. Deferred gain or loss on refunded bonds are amortized on the Statement of Activities,whereas governmental funds do not recognize these costs. Amortization of deferred gain 76,848 7. Taxes and special assessments receivable will be collected in future years,but are not available soon enough to pay for the current period's expenditures,and therefore are deferred in the funds. 66,137 8.Internal service funds are used by management to charge the costs of employee benefits to individual funds. The net revenue of these activities is reported in governmental activities. 1,085,131 Change in net assets-governmental activities $ 4,755,284 The notes to financial statements are an integral part of this statement 29 CITY OF EDEN PRAIRIE,MINNESOTA GENERALFUND STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCE-BUDGET AND ACTUAL FOR THE YEAR ENDED DECEMBER 31,2010 With Comparative Actual Amounts For The Year Ended December 31,2009 2010 2009 Budget Variance Original Final Actual Over/(Under) Actual REVENUES Taxes and special assessments General property taxes $ 27,511,540 $ 27,563,540 $ 27,984,674 $ 421,134 $ 27,927,462 Special assessments - - 2 2 3,959 Penalties and interest 30,000 30,000 73,353 43,353 56,014 Total taxes and special assessments 27,541,540 27,593,540 28,058,029 464,489 27,987,435 Licenses and permits Liquor and beer 316,000 316,000 302,712 (13,288) 274,462 Business licenses 16,950 16,950 20,373 3,423 24,795 Dog registration 19,000 19,000 20,072 1,072 19,142 Building permits 1,000,000 1,000,000 1,936,566 936,566 1,287,258 Cable TV 787,000 787,001 753,291 (33,710) 746,865 Other permits 76,210 76,210 86,435 10,225 34,434 Total licenses and permits 2,215,160 2,215,161 3,119,449 904,288 2,386,956 intergovernmental revenue State police and fire pension aid 785,355 785,355 723,128 (62,227) 726,396 State street aid 70,620 70,620 70,620 - 70,620 State police training aid 24,000 24,000 23,302 (698) 25,370 Grants - - 143,133 143,133 112,980 PERA aid 52,384 52,384 52,384 - 52,384 Local police/school liaison 110,000 110,000 110,413 413 109,219 Total intergovernmental revenue 1,042,359 1,042,359 1,122,980 80,621 1,096,969 Charges for services Public safety 55,000 55,000 19,499 (35,501) 37,321 Recreation Youth programs 266,440 266,440 284,418 17,978 267,630 Organized athletics 316,900 316,900 352,866 35,966 324,487 Community center 2,237,291 2,242,291 2,839,516 597,225 2,497,704 Oak point pool 92,100 92,100 95,557 3,457 88,770 Adult/therapeutic programs 53,950 53,950 63,637 9,687 55,951 Special events/arts 77,805 77,805 100,323 22,518 73,835 Park facilities 144,972 144,972 164,032 19,060 160,999 Total charges for services 3,244,458 3,249,458 3,919,848 670,390 3,506,697 Fines and forfeits 384,000 384,000 496,074 112,074 437,104 Investment income Interest income 200,000 200,000 207,030 7,030 337,480 Unrealized gain/(loss)on investments - - (27,040) (27,040) (75,149) Total investment income 200,000 200,000 179,990 (20,010) 262,331 Miscellaneous 294,325 289,324 305,491 16,167 416,662 Total revenues 34,921,842 34,973,842 37,201,861 2,228,019 36,094,154 The notes to financial statements are an integral part of this statement 30 CITY OF EDEN PRAIRIE,MINNESOTA GENERALFUND STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCE-BUDGET AND ACTUAL FOR THE YEAR ENDED DECEMBER 31,2010 Continued With Comparative Actual Amounts For The Year Ended December 31,2009 2010 2009 Budget Variance Original Final Actual Over/(Under) Actual EXPENDITURES Current General Government Administration Legislative $ 248,531 $ 248,531 $ 251,480 $ 2,949 $ 226,165 Office of the city manager 399,417 399,417 360,713 (38,704) 420,364 Legal counsel 443,000 443,000 425,463 (17,537) 464,652 City clerk 269,786 269,786 215,727 (54,059) 119,344 Communication services 493,871 493,871 471,306 (22,565) 472,665 Finance 667,616 668,157 661,503 (6,654) 779,082 Customer service 492,463 493,324 418,990 (74,334) 473,803 Human resources 701,810 702,220 684,980 (17,240) 531,227 Contingency 50,000 50,000 13,721 (36,279) 640 Total administration 3,766,494 3,768,306 3,503,883 (264,423) 3,487,942 Community development Assessing 911,229 911,229 893,894 (17,335) 892,823 City planning 547,743 548,517 525,793 (22,724) 557,867 Community development 179,609 179,609 160,609 (19,000) 159,811 Economic development 102,175 102,175 97,963 (4,212) 110,392 Housing and community services 310,679 310,679 305,155 (5,524) 299,249 Total community development 2,051,435 2,052,209 1,983,414 (68,795) 2,020,142 Total general government 5,817,929 5,820,515 5,487,297 (333,218) 5,508,084 Public Safety Police 11,465,324 11,485,934 11,678,049 192,115 11,675,910 Fire Fire 3,936,511 3,938,908 3,935,468 (3,440) 3,115,622 Public Safety Communications 234,460 234,460 170,333 (64,127) 241,346 Emergency preparedness 36,691 36,691 37,819 1,128 43,890 Inspections 1,019,560 1,020,086 991,187 (28,899) 1,097,822 Total fire 5,227,222 5,230,145 5,134,807 (95,338) 4,498,680 Total public safety 16,692,546 16,716,079 16,812,856 96,777 16,174,590 Public Works Engineering 1,077,828 1,078,867 1,065,996 (12,871) 1,172,174 Street maintenance 3,318,344 3,319,178 3,288,883 (30,295) 3,398,500 Street lighting 865,883 865,883 791,401 (74,482) 820,552 Total public works 5,262,055 5,263,928 5,146,280 (117,648) 5,391,226 The notes to financial statements are an integral part of this statement 31 CITY OF EDEN PRAIRIE,MINNESOTA GENERALFUND STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCE-BUDGET AND ACTUAL FOR THE YEAR ENDED DECEMBER 31,2010 Continued With Comparative Actual Amounts For The Year Ended December 31,2009 2010 2009 Budget Variance Original Final Actual Over/(Under) Actual EXPENDITURES(continued) Current(continued) Parks and Recreation Park administration 392,399 392,399 374,152 (18,247) 405,972 Park maintenance 3,264,511 3,267,742 3,240,876 (26,866) 3,249,339 Parks capital outlay 47,000 47,000 35,611 (11,389) 50,722 Recreation administration 263,068 263,068 270,283 7,215 239,695 Youth programs 380,464 380,464 363,741 (16,723) 369,507 Organized athletics 269,754 269,754 251,475 (18,279) 258,531 Special events 77,736 77,736 76,129 (1,607) 76,818 Arts 119,290 119,290 110,421 (8,869) 117,150 Arts center 159,823 159,823 178,578 18,755 133,705 Therapeutic recreation 137,870 137,870 129,782 (8,088) 157,663 Adult recreation 333,906 333,906 346,744 12,838 326,367 Beaches 33,927 33,927 27,085 (6,842) 32,635 Park facilities 154,226 154,783 169,422 14,639 171,413 Oak point pool 123,005 123,005 116,511 (6,494) 119,943 Community center 2,936,566 2,936,672 3,142,251 205,579 3,002,875 Total parks and recreation 8,693,545 8,697,439 8,833,061 135,622 8,712,335 Debt Service: Principal 40,749 40,749 40,749 - 39,577 Interest 4,103 4,103 4,103 - 5,275 Total debt service 44,852 44,852 44,852 - 44,852 Total expenditures 36,510,927 36,542,813 36,324,346 (218,467) 35,831,087 Excess(deficiency)of revenues over expenditures (1,589,085) (1,568,971) 877,515 2,446,486 263,067 Other financing sources/(uses) Transfers in 944,386 944,386 945,816 1,430 270,822 Transfers out (379,000) (379,000) (1,471,051) (1,092,051) (374,000) Total other financing sources/(uses) 565,386 565,386 (525,235) (1,090,621) (103,178) Net change in fund balance $ (1,023,699) $ (1,003,585) 352,280 $ 1,355,865 159,889 Fund balance,January 1 20,591,209 20,431,320 Fund balance,December 31 $ 20,943,489 $ 20,591,209 The notes to financial statements are an integral part of this statement 32 CITY OF EDEN PRAIRIE,MINNESOTA PROPRIETARY FUNDS STATEMENT OF NET ASSETS DECEMBER 31,2010 Governmental Activities Internal Water/Sewer Storm Drainage Liquor Service Fund Fund Fund Totals Fund ASSETS Current assets: Cash and investments $ 639,153 $ 739,940 $ 669,052 $ 2,048,145 $ 8,012,179 Receivables: Accounts 2,047,888 178,073 3,921 2,229,882 25,683 Interest 2,295 2,770 2,476 7,541 18,287 Unremitted special assessments 18,052 - - 18,052 - Delinquent special assessments 400,725 400,725 Deferred special assessments 390,222 390,222 Special deferred special assessments 407,190 - 407,190 - Due from other governments - 31,258 31,258 1,667 Due from other funds - - - - 54,104 Inventory 29,406 - 1,136,956 1,166,362 90,971 Prepaid items 310,435 215 15,738 326,388 231,764 Total current assets 4,245,366 952,256 1,828,143 7,025,765 8,434,655 Noncurrent assets Capital assets: Property,plant and equipment 194,530,254 41,354,068 3,379,580 239,263,902 849,358 Less accumulated depreciation (83,242,675) (17,059,413) (654,662) (100,956,750) (28,406) Total noncurrent assets 111,287,579 24,294,655 2,724,918 138,307,152 820,952 Total assets $ 115,532,945 $ 25,246,911 $ 4,553,061 $ 145,332,917 $ 9,255,607 LIABILITIES Current liabffities: Accounts payable $ 480,777 $ 72,365 $ 689,334 $ 1,242,476 $ 612,033 Salaries payable 79,922 5,235 31,722 116,879 65,589 Interest payable - - - - 146 Due to other governments 7,382 134,698 142,080 267,868 Unearned revenue - 2,671 2,671 104,704 Due to other funds - - - - 54,104 Current portion ofcompensated absences 78,012 5,882 32,172 116,066 873,715 Total current liabilities 646,093 83,482 890,597 1,620,172 1,978,159 Noncurrent liabilities: Net OPEB 65,094 3,452 9,270 77,816 494,335 Compensated absences 69,181 5,216 28,532 102,929 774,803 Total noncurrent liabilities 134,275 8,668 37,802 180,745 1,269,138 Total liabilities 780,368 92,150 928,399 1,800,917 3,247,297 NET ASSETS Invested in capital assets 111,287,579 24,294,655 2,724,918 138,307,152 820,952 Unrestricted 3,464,998 860,106 899,744 5,224,848 5,187,358 Total net assets 114,752,577 25,154,761 3,624,662 143,532,000 6,008,310 Total liabilities and net assets $ 115,532,945 $ 25,246,911 $ 4,553,061 $ 145,332,917 $ 9,255,607 The notes to financial statements are an integral part of this statement 33 CITY OF EDEN PRAIRIE,MINNESOTA PROPRIETARY FUNDS STATEMENT OF REVENUES,EXPENSES AND CHANGES IN NET ASSETS FOR THE YEAR ENDED DECEMBER 31,2010 Governmental Activities- Internal Water/Sewer Storm Drainage Liquor Service Fund Fund Fund Total Fund SALES AND COST OF SALES Sales $ $ $ 11,524,121 $ 11,524,121 $ Cost of sales (8,610,550) (8,610,550) Gross profit 2,913,571 2,913,571 OPERATING REVENUE Sales 9,842,350 818,340 - 10,660,690 Conservation surcharge 260,944 - 260,944 Access charges 561,645 561,645 Penalty charges 36,069 36,069 - Charges for services - - - 13,275,451 Grants - 31,498 - 31,498 3,240 Other revenue 59,094 13,391 122,964 195,449 1,596,218 Total operating revenues 10,760,102 863,229 122,964 11,746,295 14,874,909 OPERATING EXPENSE Personal services 2,686,921 188,471 937,951 3,813,343 4,892,875 Chemicals and supplies 569,769 8,993 41,372 620,134 1,672,673 Contractual services 1,650,878 682,498 752,361 3,085,737 5,364,320 Repairs and maintenance 615,840 167,311 34,392 817,543 833,867 Disposal charges 3,325,635 - - 3,325,635 47,568 Utilities 615,309 895 74,422 690,626 1,064,629 Depreciation 3,950,119 846,606 95,630 4,892,355 16,059 User charges 459,554 88,247 94,651 642,452 38,648 Total operating expenses 13,874,025 1,983,021 2,030,779 17,887,825 13,930,639 Operating income(loss) (3,113,923) (1,119,792) 1,005,756 (3,227,959) 944,270 NONOPERATING REVENUE(EXPENSE) Investment income 5,111 10,505 9,514 25,130 76,123 Unrealized loss on investments (7,316) (2,951) (2,484) (12,751) (9,471) Special assessments 256,746 256,746 - Gain(loss)on disposition of capital assets 86,187 (78,490) 7,697 93,877 Miscellaneous (161,891) (62,423) 40,834 (183,480) - Totalnonoperatingrevenues(expenses) 178,837 (54,869) (30,626) 93,342 160,529 Income(loss)before contributions and transfers (2,935,086) (1,174,661) 975,130 (3,134,617) 1,104,799 Contributions 9,834 6,147 - 15,981 - Transfers in - 106,150 106,150 800,000 Transfers(out) (599,241) (195,874) (1,054,778) (1,849,893) (819,668) Change in net assets (3,524,493) (1,258,238) (79,648) (4,862,379) 1,085,131 Total net assets,January 1 118,277,070 26,412,999 3,704,310 148,394,379 4,923,179 Total net assets,December 31 $ 114,752,577 $ 25,154,761 $ 3,624,662 $ 143,532,000 $ 6,008,310 The notes to financial statements are an integral part of this statement 34 CITY OF EDEN PRAIRIE,MINNESOTA PROPRIETARY FUNDS STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31,2010 Page 1 of 2 Governmental Activities- Internal Water/Sewer Storm Drainage Liquor Service Fund Fund Fund Totals Fund CASH FLOWS FROM OPERATING ACTIVITIES: Receipts from customers $ 10,320,473 $ 795,719 $ 11,648,131 $ 22,764,323 $ 13,362,959 Payments from other funds - - - - (88,767) Payments to other funds 88,767 Payments to vendors (7,269,386) (902,952) (9,944,962) (18,117,300) (8,954,598) Payments to employees (2,631,687) (186,774) (928,736) (3,747,197) (4,680,173) Other receipts 59,094 13,631 40,834 113,559 1,599,458 Net cash provided(used)by operating activities 478,494 (280,376) 815,267 1,013,385 1,327,646 CASH FLOWS FROM INVESTING ACTIVITIES: Investment income 2,935 9,591 8,743 21,269 73,010 Net cash provided(used)by investing activities 2,935 9,591 8,743 21,269 73,010 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Transfers in - 106,150 - 106,150 800,000 Transfers(out) (599,241) (195,874) (1,054,778) (1,849,893) (819,668) Net cash provided(used)by noncapital financing activities (599,241) (89,724) (1,054,778) (1,743,743) (19,668) CASH FLOWS FROM CAPITAL FINANCING ACTIVITIES: Acquisition and construction of capital assets (1,105,943) (46,491) (1,152,434) (19,974) Proceeds from sale of equipment 7,686 7,686 93,877 Special assessments 256,746 256,746 - Net cash provided(used)by capital financing activities (841,511) (46,491) (888,002) 73,903 Net increase(decrease)in cash and cash equivalents (959,323) (360,509) (277,259) (1,597,091) 1,454,891 Cash and cash equivalents,January 1 1,598,476 1,100,449 946,311 3,645,236 6,557,288 Cash and cash equivalents,December 31 $ 639,153 $ 739,940 $ 669,052 $ 2,048,145 $ 8,012,179 The notes to financial statements are an integral part of this statement 35 CITY OF EDEN PRAIRIE,MINNESOTA PROPRIETARY FUNDS STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31,2010 Page 2 of 2 Governmental Activities- Internal Water/Sewer Storm Drainage Liquor Service Fund Fund Fund Totals Fund RECONCILIATION OF OPERATING INCOME(LOSS)TO NET CASH PROVIDED(USED)BY OPERATING ACTIVITIES: Operating income(loss) $ (3,113,923) $ (1,119,792) $ 1,005,756 $ (3,227,959) $ 944,270 Adjustments to reconcile operating income(loss)to net cash provided (used)by operating activates: Depreciation 3,950,119 846,606 95,630 4,892,355 16,059 Miscellaneous (161,891) (316) 40,834 (121,373) - (Increase)decrease in assets: Accounts receivable (398,576) (22,621) (355) (421,552) 78,753 Special assessments receivable 18,041 - 18,041 - Due from other funds - - 88,767 Due from other governments - (31,258) (31,258) 10,577 Inventory 868 - (111,571) (110,703) 85 Prepaid items (24,050) 1,170 1,286 (21,594) 163,031 Increase(decrease)in liabilities: Accounts payable 156,005 44,982 (224,038) (23,051) (140,374) Salaries payable 7,014 (838) 1,206 7,382 2,579 Unearned revenue - - 1,401 1,401 8,755 Due to other governments (3,333) (844) (2,891) (7,068) 33,788 Due to other funds - - - - (88,767) Net other post employment benefits 26,860 1,474 3,507 31,841 186,280 Compensated absences 21,360 1,061 4,502 26,923 23,843 Net Cash provided(used)by operating activities $ 478,494 $ (280,376)$ 815,267 $ 1,013,385 $ 1,327,646 Noncash investing,capital and financing activities: Contributions of capital assets from government and developers $ 9,834 $ 6,147 $ - $ 15,981 $ - Contributions of capital assets to government and developers - (62,107) (62,107) Loss on disposition of capital assets - (78,490) (78,490) Capital asset trade-ins 78,500 78,500 The notes to financial statements are an integral part of this statement 36 CITY OF EDEN PRAIRIE,MINNESOTA AGENCY FUNDS STATEMENT OF FIDUCIARY NET ASSETS DECEMBER 31,2010 Total ASSETS Cash and investments $ 1,264,866 Total assets $ 1,264,866 LIABILITIES Accounts payable $ 1,178,629 Due to other governments 86,237 Total liabilities $ 1,264,866 The notes to financial statements are an integral part of this statement 37 Notes to Financial Statements City of Eden Prairie, Minnesota Notes to Financial Statements Note 1—Summary of Significant Accounting Policies Reporting Entity The City of Eden Prairie is a municipal corporation governed by an elected mayor and four-member council. The accompanying financial statements present the government and its component units. Component units are legally separate entities for which the primary government is financially accountable, or for which the exclusion of the component unit would render the financial statements of the primary government misleading. The criteria used to determine if the primary government is financially accountable for a potential component unit include whether or not the primary government appoints the voting majority of the potential component unit's board, is able to impose its will on the potential component unit, is in a relationship of financial benefit or burden with the potential component unit, or is fiscally depended upon by the potential component unit. Blended Component Unit The Housing and Redevelopment Authority (H.R.A.) is a body organized and existing under the laws of the State of Minnesota. The Authority was established in 1980 by the City to carry out certain redevelopment projects within the City and is governed by the City Council and the Mayor. The H.R.A. has a December 31 year-end and does not issue financial statements. This unit is included within the H.R.A., H.R.A. Lease Revenue 2002, 3rd Rink Lease Revenue Bonds 2007A, and Economic Development funds. Government-Wide and Fund Financial Statements The government-wide financial statements (i.e., the Statement of Net Assets and the Statement of Activities) report information on all of the nonfiduciary activities of the City. For the most part, the effect of interfund activity has been removed from these statements. 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 are 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, service 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. 39 City of Eden Prairie, Minnesota Notes to Financial Statements Note 1—Summary of Significant Accounting Policies (Continued) Measurement Focus,Basis of Accounting and Statement Presentation Separate financial statements are provided for governmental funds, proprietary funds, and fiduciary funds, even though the latter are excluded from the government-wide financial statements. Major individual governmental funds and major individual proprietary funds are reported as separate columns in the fund financial statements. The government-wide financial statements are reported using the economic resources measurement focus and the accrual basis of accounting, as are the proprietary fund financial statements. The fiduciary fund financial statements include Agency funds,which utilize the accrual basis of accounting,but do not have a measurement focus. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of the related cash flows. Property taxes are recognized as revenues in the year for which they are levied. Grants and similar items are recognized as revenues in the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. Governmental fund financial statements are reported using the current financial resources measurement focus and the modified 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, interest and special assessments are all considered to be susceptible to accrual and so have been recognized as revenues of the current fiscal period. All other revenue items are considered to be measurable and available only when cash is received by the City. 40 City of Eden Prairie, Minnesota Notes to Financial Statements Note 1—Summary of Significant Accounting Policies (Continued) 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 General Obligation Improvement Revolving 2005B fund accounts for the accumulation of tax revenues needed to repay bonds issued to pay for the construction at 212 and Charleson Road. • The General Obligation Improvement 2003D fund accounts for the accumulation of resources needed to repay bonds issued to finance the construction of streets, lateral utilities, and drainage for the Charlson and Hillcrest Construction Projects. The primary sources of repayment on these bonds are special assessments levied on benefited properties. • The Capital Improvement maintenance fund accounts for the accumulation of resources to be used for capital improvements and maintenance of City property. • The Public Improvement Construction fund accounts for proceeds of bonds sold and special assessments collected to finance street, drainage, and lateral utility construction within the City. • The Flying Cloud Drive fund accounts for proceeds of bonds sold to finance the construction of a three lane road from south of Shady Oak Road to the south end of the Liberty Plaza campus. The City reports the following major proprietary funds: • The Water/Sewer fund accounts for the operations of the City-owned water system and sanitary sewer service. • The Storm Drainage fund accounts for the operations of the City's storm drainage system. • The Liquor fund accounts for the operations of the City's three retail liquor stores and the operations of the City-owned Den Road building which is leased to City liquor operations and other tenants. Additionally, the city reports the following fund types: Internal Service funds: • The Health & Benefits fund accounts for the activities pertaining to health, dental, life and disability insurance. This fund also accounts for the employer's portion of pension, FICA and medicare contributions. • The Severance fund accounts for unused vacation and sick leave for governmental fund employees. 41 City of Eden Prairie, Minnesota Notes to Financial Statements Note 1—Summary of Significant Accounting Policies (Continued) • The Workers Compensation fund accounts for insurance payments and cost reimbursement from other departments. • The Property Insurance fund accounts for insurance payments and cost reimbursement from other departments. • The Facilities fund accounts for the accumulation of resources to be used for the maintenance of the city's buildings. • The Fleet fund accounts for the accumulation of resources to be used for the purchase and maintenance of machinery and equipment for the City. • The Information Technology funds accounts for planning, designing and implementing information systems and cost reimbursement from other departments. Fiduciary funds: • Agency funds account for various deposits, collections and remittances of expenses for accumulating donations and contributions in the Escrow fund, WAFTA and MCES funds. Private-sector standards of accounting and financial reporting issued prior to December 1, 1989, generally are followed in both the government-wide and proprietary fund financial statements to the extent that those standards do not conflict with or contradict guidance of the Governmental Accounting Standards Board. Governments also have the option of following subsequent private-sector guidance for their business-type activities and enterprise funds, subject to this same limitation. The City has elected not to follow subsequent private-sector guidance. As a general rule the effect of interfund activity has been eliminated from the government-wide financial statements. Exceptions to this 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 from the various functions concerned. 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 revenue of the City's proprietary funds are charges to customers for sales and services. Operating expenses for proprietary 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, and then unrestricted resources as they are needed. 42 City of Eden Prairie, Minnesota Notes to Financial Statements Note 1—Summary of Significant Accounting Policies (Continued) Assets,Liabilities and Net Assets or Equity Cash and Investments Cash and investments, except for small amounts of cash on hand, are deposited in pooled accounts of the City. The City invests cash surpluses in these accounts; and investment earnings, as well as gains and losses on sales of securities, are allocated to the various funds on the basis of average cash balances. Funds with deficit cash balance averages (interfund payable) are charged interest equivalent to the average investment earnings lost if financing the deficits. For purposes of the statement of cash flows,the Proprietary funds consider all unrestricted investments held in the pooled accounts of the City to be cash equivalents because this pool is used essentially as a demand deposit account. The pooled investments are recorded at fair value in accordance with GASB 31, and are based on quoted market prices at year end. Cash and Investments with Escrow Agent Certain resources set aside for repayment of lease revenue bond proceeds are classified as cash and investments with escrow agent on the balance sheet because their use is limited by applicable bond covenants. Interfund Receivables/Payables Activity between funds that are representative of lending/borrowing arrangements outstanding at the end of the fiscal year are referred to as "due to/from other funds" (i.e., the current portion of interfund loans) or advances to/from other funds. 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." Inventories and Prepaid Items Liquor fund inventories are valued at average cost. The Water/Sewer and Fleet fund's inventories are valued at cost. All inventories use the first-in/first-out (FIFO) method. Inventories of governmental funds are recorded as expenditures when consumed rather than when purchased. 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. 43 City of Eden Prairie, Minnesota Notes to Financial Statements Note 1—Summary of Significant Accounting Policies (Continued) 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 initial, individual cost of more than $10,000 and an estimated useful life in excess of 1 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. The costs of normal maintenance and repairs that do not add to the value of the asset or materially extend assets lives are not capitalized. The City has chosen to use the modified approach for its infrastructure assets, which means the following criteria will take place: • The City will preserve and maintain infrastructure assets at a condition level of 60. • The Engineering department will be in charge of determining the appropriate condition level at which these assets are to be maintained. • The City will maintain an inventory of these assets and perform a condition assessment every 3 years to establish that the condition level of 60 is being maintained. • The City will make annual estimates of the amounts that must be expended to preserve and maintain these assets at the condition level of 60. Property, plant, and equipment, except for infrastructure, of the City are depreciated using the straight line method over the following estimated useful lives: Buildings 5-50 years Land improvements 10-30 years Leasehold improvements 10-25 years Equipment 5-20 years Autos 5-20 years Other assets 5-30 years Distribution system 50-60 years Intangible assets 3 years 44 City of Eden Prairie, Minnesota Notes to Financial Statements Note 1—Summary of Significant Accounting Policies (Continued) Compensated Absences The City compensates employees upon termination for unused PTO. Such pay will be reflected as a liability in the government-wide financial statement and accrued as an expense as it is earned in an internal service fund. General Property Taxes Property tax levies are set by the City Council in December each year and are certified to Hennepin County for collection in the following year. In Minnesota, counties act as collection agents for all property taxes. The County spreads all levies over taxable property. Such taxes become a lien on January 1 and are recorded as receivables by the City at that date. Revenues are accrued and recognized in the year collectible, net of delinquencies. Real property taxes may be paid by taxpayers in two equal installments on May 15 and October 15. Personal property taxes may be paid on February 28 and June 30. The County provides tax settlements to taxing districts in February, June, and December. In the governmental fund financial statements, taxes that remain unpaid at December 31 are classified as delinquent taxes receivable and are fully offset by deferred revenue because they are not available to finance current expenditures. Special Assessment Levies Special assessments represent the financing for public improvements paid for by the benefiting property owner. In the fund financial statements, special assessment revenue and related interest income is generally recognized in the year collected. Hennepin County acts as the billing and collection agent. Amounts collected by the County during the year that have not yet been remitted to the City are considered collections for purposes of revenue recognition. Deferred special assessments receivable represents principal amounts due in future years. Special deferred assessments receivable includes Green Acres, disability, senior citizen owned property or other qualified hardship properties. These special assessments are deferred until such time the property loses its exempt status. While these taxes remain a valid receivable, the timing of their collection is uncertain. Interest accrues from the year of the deferment. Delinquent special assessments receivable represents special assessments principal and interest that are past due. In the governmental fund financial statements, deferred and delinquent special assessments receivable are fully offset by deferred revenue because such assessment revenue is not available currently. 45 City of Eden Prairie, Minnesota Notes to Financial Statements Note 1—Summary of Significant Accounting Policies (Continued) Long-term Obligations In the government-wide financial statements and proprietary fund financial statements, long-term debt and other long-term obligations are reported as liabilities in the statement of net assets. Bond premiums and discounts, as well as issuance costs, are deferred and amortized over the life of the bonds using the effective interest method. Bonds payable are reported net of the applicable bond premium or discount. Bond issuance costs are reported as deferred charges and amortized over the term of the related debt. 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 and discounts on debt issuances are reported as other financing sources/uses. Issuance costs, whether or not withheld from the actual debt proceeds received, are reported as debt service expenditures. Fund Equity In the fund financial statements, governmental funds reported reservations of fund balance for amounts that are not available for appropriation or are legally restricted by outside parties for use for a specific purpose. Designations of fund balance represent tentative Council plans that are subject to change. Prior Period Comparative Financial Information/Reclassification The financial statements include certain prior year partial comparative information but not at the level of detail required for a presentation in conformity with accounting principles generally accepted in the United States of America. Accordingly, such information should be read in conjunction with the City's financial statements for the year ended December 31, 2009, from which the summarized information was derived. Also, certain amounts presented in the prior year data have been reclassified in order to be consistent with the current year's presentation. Note 2—Stewardship, Compliance and Accountability Budgetary Information An annual budget is adopted on a basis consistent with generally accepted accounting principles for the General fund. The City does not budget for its Special Revenue funds. All annual appropriations lapse at fiscal year end. The proposed budget is presented to the City Council for review. The Council then holds truth-in- taxation hearings after which a final General Fund annual budget is legally adopted by no later than December 31. 46 City of Eden Prairie, Minnesota Notes to Financial Statements Note 2—Stewardship, Compliance and Accountability (Continued) The appropriated budget is prepared by department and division. The City's directors and division managers may make transfers of appropriations within a division. Transfers of appropriations between departments require the approval of the City Manager. The legal level of budgetary control is the fund level. Any changes in the total budget of each fund must be approved by a majority vote of the City Council. During the year, net adjustments between the original and final General fund amended budget totaled $20,114. Revenues increased by$52,000 and appropriations increased by$31,886. Following are changes made to the original budget during the year: Increase / (Decrease) Revenues Property taxes revenue needed for wage adjustments $ 52,000 Expenditures Wages increase in wage adjustments for steps $ 31,886 Encumbrance accounting is employed in governmental funds. Encumbrance (e.g., purchase orders, contracts) outstanding at year end are reported as reservations of fund balances and do not constitute expenditures or liabilities because the commitments will be reappropriated and honored during the subsequent year. Deficit Fund Equity The following governmental funds had deficit fund balances at December 31, 2010: Major Funds: General Obligation Improv. Bonds 2003D $ 432,332 Public Improvements Construction 2,734,995 Non-Major Governmental Funds: General Obligation Improv. Revolving 2005A 11,880 Capital Equip Notes 2008A 33,087 General Obligation Improvement Bonds 2010A 4,350 Sprint/Nextel 46,590 Internal Service Funds: Health and Benefits 16,369 Workers Compensation 20,139 The fund balance deficits of these individual Debt Service and Capital Project funds will be financed by property tax levies and special assessments. The fund balance deficit of the Internal Service fund will be financed by user charges. 47 City of Eden Prairie, Minnesota Notes to Financial Statements Note 3—Cash and Investments Components of Cash and Investments Cash and investments at year-end consist of the following: Deposits $ 4,491,507 Investments 52,534,483 Cash on hand 8,355 Total $ 57,034,345 Cash and investments are presented in the financial statements as follows: Statement of Net Assets Cash and cash equivalents $ 55,676,214 Restricted cash and cash equivalents 93,265 Statement of Fiduciary Net Assets Cash and investments 1,264,866 $ 57,034,345 Deposits In accordance with Minnesota Statutes, the City maintains deposits at those depository banks authorized by the City Council, including checking accounts and certificates of deposits. The following is considered the most significant risk associated with deposits: Custodial Credit Risk: In the case of deposits,this is the risk that in the event of a bank failure,the City's deposits may be lost. Minnesota Statutes require that all deposits be protected by federal deposit insurance, corporate surety bond, or collateral. The market value of collateral pledged must equal 110% of the deposits not covered by federal deposit insurance or corporate surety bonds. Authorized collateral includes treasury bills, notes, and bonds; issues of U.S. government agencies; general obligation rate "A" or better; revenue obligations rate "AA" or better; irrevocable standard letters of credit issued by the Federal Home Loan Bank; and certificated of deposit. Minnesota Statues require that securities pledged as collateral be held in safekeeping in a restricted account at the Federal Reserve Bank or in an account at a trust department 48 City of Eden Prairie, Minnesota Notes to Financial Statements Note 3—Cash and Investments (Continued) of a commercial bank or other financial institution that is not owned or controlled by the financial institution furnishing the collateral. It is the City's policy to limit collateral to what is authorized by Minnesota Statutes. At year-end, the carrying amount of the City's deposits was $4,491,507 while the balance on the bank records was $4,843,126. At December 31, 2010, all deposits were fully covered by federal depository insurance, surety bonds, or by collateral held by the City's agent in the City's name. Investments As of December 31, 2010,the city had the following investments and maturities: Investment Maturities (in Years) Fair Less 1 to 5 Value Than 1 Year Years U.S. Agencies $ 18,143,786 $ 4,028,918 $ 14,114,868 Municipal Bonds 5,389,143 2,476,902 2,912,241 Commercial Paper 1,747,169 1,747,169 - Negotiable Certificate of Deposit 596,577 246,541 350,036 Mutual Funds 26,657,808 26,657,808 - Total $ 52,534,483 $ 35,157,338 $ 17,377,145 Investments are subject to various risks,the following of which are considered the most significant. Interest Rate Risk Per City policy, the City will match its investments with anticipated cash flow requirements. Unless matched to a specific cash flow, the City will not directly invest in securities maturing more than five (5) years from the date of purchase. Reserve funds and other funds with longer-term investment horizons may be invested in securities exceeding five (5) years if the maturities of such investments are made to coincide as nearly as practicable with the expected use of funds. The intent to invest in securities with longer maturities will be disclosed to the City Council. Currently, the City does not have any investments maturing more than five years from the date of purchase. 49 City of Eden Prairie, Minnesota Notes to Financial Statements Note 3—Cash and Investments (Continued) Credit Risk It is the City's policy to limit its investments to the following types as authorized by Minnesota Statutes: • Direct obligations or obligations guaranteed by the United States or its agencies, its instrumentalities or organizations created by an act of congress, excluding mortgage-backed securities defined as high risk. • Shares of investment companies registered under the Federal Investment Company Act of 1940 and whose only investments are in securities described above or in general obligation tax exempt securities, or repurchase or reverse repurchase agreements. • Repurchase or reverse repurchase agreements 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; certain Minnesota securities broker-dealers, or, a bank qualified as a depositor. • Commercial paper issued by United States corporations or their Canadian subsidiaries, of the higher quality, and maturing in 270 days or less. • Banker's acceptance of U.S. banks eligible for purchase by the Federal Reserve System. • General obligations of a state of local government. • Money market mutual funds meeting the conditions of rule 2a-7 of the Securities and Exchange Commission. The fair value of the position in the pool is the net asset value per share provided by the pool. As of December 31, 2010, the City's investments in agency funds were rated AA1 and AAA by Moody's and Standard and Poor's. The City's investment in municipal bonds were rated BAA1 and higher. The City's mutual bond fund investments were rated AA- and higher by Standard and Poor's and BAA1 and higher by Moody's. The City's investment in commercial paper were rated Al by Standard and Poor's and B1 by Moody's. The money market mutual funds and negotiable certificate of deposits were not rated. Custodial Credit Risk For an investment, custodial credit risk is the risk that in the event of the failure of the counterparty, the city will not be able to recover the value of its investments or collateral securities that are in the possession of an outside party. At year end, the city's investment balance is not subject to custodial credit risk. The City's investment policy does not further address this risk, but the City typically limits its exposure by purchasing insured or registered investments, or by the control of who holds the securities. 50 City of Eden Prairie, Minnesota Notes to Financial Statements Note 3—Cash and Investments (Continued) Concentration Risk This is the risk associated with investing a significant portion of the City's investment (considered 5 percent or more) in the securities of a single issuer, excluding U.S. guaranteed investments (such as Treasuries), investment pools, and mutual funds. The City's investment policy does not limit the concentration of investments. At year end, the City held the following investments in securities of a single issuer which exceeded 5%. Issuer Percentage Federal National Mtg. Assn. 10.50% 51 City of Eden Prairie, Minnesota Notes to Financial Statements Note 4—Capital Assets Capital asset activity for the year ended December 31, 2010 was as follows: 2010 2010 Beginning Ending Balance Transfers Increases Decreases Balance Governmental activities: Capital assets,not being depreciated: Land $ 22,600,571 $ $ - $ $ 22,600,571 Infrastructure 116,751,560 255,952 117,007,512 Work in progress 6,237,075 (1,068,917) 2,426,042 7,594,200 Total capital assets,not being depreciated 145,589,206 (1,068,917) 2,681,994 147,202,283 Capital assets,being depreciated: Buildings 49,059,477 295,754 45,135 49,400,366 Land improvements 12,430,007 770,107 48,512 13,248,626 Leasehold improvements 77,318 - - 77,318 Machinery and equipment 3,469,278 116,931 63,217 3,522,992 Autos 8,703,410 - 484,334 288,129 8,899,615 Other assets 7,894,359 49,182 72,047 1,336,559 6,679,029 Total capital assets,being depreciated 81,633,849 1,115,043 766,959 1,687,905 81,827,946 Total Capital assets,cost 227,223,055 46,126 3,448,953 1,687,905 229,030,229 Less accumulated depreciation for: Buildings 8,852,381 - 1,100,634 - 9,953,015 Land improvements 2,517,603 655,294 3,172,897 Leasehold improvements 27,403 5,054 - 32,457 Machinery and equipment 2,344,252 336,223 63,217 2,617,258 Autos 4,540,609 801,492 244,527 5,097,574 Other assets 5,540,604 319,281 1,336,078 4,523,807 Total accumulated depreciation 23,822,852 - 3,217,978 1,643,822 25,397,008 Total capital assets,being depreciated,net 57,810,997 1,115,043 (2,451,019) 44,083 56,430,938 Governmental activities capital assets,net $ 203,400,203 $ 46,126 $ 230,975 $ 44,083 $ 203,633,221 During the year$62,107 was reassigned from business type activities to governmental activities. Offsetting this was $15,981 reassigned from governmental activities to business type activities resulting in a net of$46,126. 52 City of Eden Prairie, Minnesota Notes to Financial Statements Note 4-Capital Assets (Continued) 2010 2010 Beginning Ending Balance Transfers Increases Decreases Balance Business-type activities: Capital assets,not being depreciated: Land $ 656,356 $ - $ $ $ 656,356 Work in progess 3,658,773 (1,999,054) 749,810 - 2,409,529 Total capital assets,not being depreciated 4,315,129 (1,999,054) 749,810 - 3,065,885 Capital assets,being depreciated: Land improvements 62,412 - 62,412 Buildings 57,137,107 - - 106,500 57,030,607 Distribution system 173,028,116 116,147 56,112 - 173,200,375 Leasehold improvements 504,232 387,858 - - 892,090 Machinery and equipment 2,050,587 1,446,448 407,378 238,527 3,665,886 Autos 989,448 55,668 933,780 Other assets 395,234 - 17,633 - 412,867 Total capital assets,being depreciated 234,167,136 1,950,453 481,123 400,695 236,198,017 Total Capital assets,cost 238,482,265 (48,601) 1,230,933 400,695 239,263,902 Less accumulated depreciation for: Land improvements 6,583 1,960 - 8,543 Buildings 22,914,405 - 1,139,452 28,009 24,025,848 Distribution system 71,050,294 (2,475) 3,455,757 - 74,503,576 Leasehold improvements 150,757 50,527 - 201,284 Machinery and equipment 1,066,553 - 180,851 238,527 1,008,877 Autos 851,015 - 44,077 55,668 839,424 Other assets 349,467 - 19,731 - 369,198 Total accumulated depreciation 96,389,074 (2,475) 4,892,355 322,204 100,956,750 Total capital assets,being depreciated,net 137,778,062 1,952,928 (4,411,232) 78,491 135,241,267 Business-type activities capital assets,net $ 142,093,191 $ (46,126) $ (3,661,422) $ 78,491 $ 138,307,152 During the year$15,981 was reassigned from governmental activities to business type activities. Offsetting this was $62,107 reassigned from business type activities to governmental activities resulting in a net of$(46,126). 53 City of Eden Prairie, Minnesota Notes to Financial Statements Note 4—Capital Assets (Continued) Depreciation expense was charged to functions/programs of the City as follows: Governmental activities: General government $ 436,713 Public safety 911,296 Public works 518,148 Parks and recreation 1,335,762 Capital assets held by the government's internal service funds are charged to the various functions based on their usage of the assets 16,059 Total depreciation expense-governmental activities $ 3,217,978 Business-type activities: Utilities $ 3,950,119 Storm 846,606 Liquor 95,630 Total depreciation expense-business-type activities $ 4,892,355 Note 5—Interfund Receivables and Payables The composition of due to/from balances as of December 31, 2010, is as follows: Due from Due to other funds other funds G.O. Improv. Bonds 2003D $ - $ 430,776 Capital Improvement Maintenance 2,584,472 - Public Improvements Construction - 2,584,472 Non-Major Governmental Funds 525,546 94,770 Internal Service Funds 54,104 54,104 Total $ 3,164,122 $ 3,164,122 The funds will be repaid as special assessment revenue and user charges are received. Interfund payables and receivables are representative of lending/borrowing arrangements to cover deficit cash balances. 54 City of Eden Prairie, Minnesota Notes to Financial Statements Note 6—Interfund Transfers The composition of interfund transfers as of December 31, 2010, is as follows: Transfers In Transfers Out Amount General Water/Sewer fund $ 260,000 Storm Drainage fund 10,000 Non-Major Governmental funds 675,816 Capital Improvement Maintenance General 1,092,051 Public Improvement Construction 21,332 Liquor fund 1,054,778 Internal service funds 19,668 Public Improvement Construction Water/Sewer fund 339,241 Storm Drainage fund 185,874 Non-Major Governmental funds 115,000 Storm Drainage fund Public Improvement Construction 106,150 Non-Major Governmental funds General 379,000 Capital Improvement Maintenance 1,785,000 Flying Cloud Drive 173,000 Non-Major Governmental funds 61,356 Internal service funds Internal service funds 800,000 Total of transfers $ 7,078,266 Interfund transfers allow the City to allocate financial resources to the funds that receive benefit from services provided by another fund. All of the City's interfund transfers fall under that category. All of the 2010 transfers are considered routine and consistent with previous practices. 55 City of Eden Prairie, Minnesota Notes to Financial Statements Note 7—Pension Plan Defined Benefit Pension Plans- Statewide Plan Description All full-time and certain part-time employees of the City of Eden Prairie are covered by defined benefit plans administered by the Public Employees Retirement Association of Minnesota (PERA). PERA administers the General Employees Retirement Fund (GERF) and the Public Employees Police and Fire Fund (PEPFF), which are cost-sharing, multiple-employer retirement plans. These plans are 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. All police officers and fire-fighters who qualify for membership by statute are covered by the PEPFF. PERA provides retirement benefits as well as disability benefits to members, and benefits to survivors upon death of eligible members. Benefits are established by state 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.2 percent of average salary for each of the first 10 years of service and 2.7 percent for each remaining year. The annuity accrual rate for a Coordinated Plan member is 1.2 percent of average salary for each of the first 10 years and 1.7 percent for each remaining year. Under Method 2, the annuity accrual rate is 2.7 percent of average salary for Basic Plan members and 1.7 percent for Coordinated Plan members for each year of service. For PEPFF members, the annuity accrual rate is 3.0 percent for each year of service. For all PEPFF members and 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 55 for PEPFF members and 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. 56 City of Eden Prairie, Minnesota Notes to Financial Statements Note 7—Pension Plan (Continued) 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 and PEPFF. That report may be obtained on the Internet at www.mnpera.or ,by writing to PERA at 60 Empire Drive#200, St. Paul, Minnesota, 55103-2088 or by calling (651) 296-7460 or 1-800-652-9026. Funding Policy Minnesota Statutes Chapter 353 sets the rates for employer and employee contributions. These statutes are established and amended by the state legislature. The city makes annual contributions to the pension plans equal to the amount required by state statutes. GERF Basic Plan members and Coordinated Plan members were required to contribute 9.1% and 6.0%, respectively, of their annual covered salary in 2010. PEPFF members were required to contribute 9.4% of their annual covered salary in 2010. In 2010, the City of Eden Prairie was required to contribute the following percentages of annual covered payroll: 11.78% for Basic Plan members, 7% for Coordinated Plan members, and 14.1% for PEPFF members. The City's contributions to the Public Employees Retirement Fund for the years ending December 31, 2010, 2009 and 2008 were $911,909, $858,694, and$846,553, respectively. The City's contributions to the Public Employees Police & Fire Fund for the years ending December 31, 2010, 2009, and 2008 were $879,255, $849,003, and $779,666, respectively. The City's contributions were equal to the contractually required contributions for each year as set by state statute. Defined Contribution Plan Council members of the City of Eden Prairie are covered by the Public Employees Defined Contribution Plan (PEDCP), a multiple-employer deferred compensation plan administered by the Public Employees Retirement Association of Minnesota (PERA). The PEDCP is a tax qualified plan under Section 401(a) of the Internal Revenue Code and all contributions by or on behalf of employees are tax deferred until time of withdrawal. 57 City of Eden Prairie, Minnesota Notes to Financial Statements Note 7—Pension Plan (Continued) Plan benefits depend solely on amounts contributed to the plan plus investment earnings, less administrative expenses. Minnesota Statutes, Chapter 353D.03, specifies plan provisions, including the employee and employer contribution rates for those qualified personnel who elect to participate. An eligible elected official who decides to participate contributes 5 percent of salary which is matched by the elected official's employer. Employer and employee contributions are combined and used to purchase shares in one or more of the seven accounts of the Minnesota Supplemental Investment Fund. For administering the plan, PERA receives 2 percent of employer contributions and twenty-five hundredths of one percent of the assets in each member's account annually. Total contributions made by the City of Eden Prairie during the year ending December 31, 2010 were: Amount % of Covered Payroll Required Employee Employer Employee Employer Rates $ 2,280 $ 2,280 5.00% 5.00% 5.00% Defined Benefit Pension Plans-Volunteer Fire Fighter's Relief Association Plan Description The Eden Prairie Firefighter's Relief Association is the administrator of a single employer defined benefit pension plan established to provide benefits for members of the Eden Prairie Fire Department. Volunteer firefighters of the City are members of the Eden Prairie Fire Fighter's Relief Association. Full retirement benefits are payable to members who have reached age 50 and have completed 15 years of service for monthly service pension, or 10 years of service for lump sum service pension. Partial benefits are payable to members who have reached 50 and have completed 10 years of service. Disability benefits and widow and children's survivor benefits are also payable to members or their beneficiaries based upon requirements set forth in the bylaws. These benefit provisions and all other requirements are consistent with enabling state statutes. The Association issues a publicly available financial report that includes financial statements and required supplementary information. That report may be obtained by writing to Eden Prairie Firefighter's Association, 14800 Scenic Heights Rd., Eden Prairie, MN 55344 or by calling (952) 949- 8367. 58 City of Eden Prairie, Minnesota Notes to Financial Statements Note 7—Pension Plan (Continued) Funding Policy Minnesota Statutes Chapter 69.772 specifies minimum support rates required on an annual basis. The minimum support rates from the municipality and from State aid are determined as the amount required to meet the normal cost plus amortizing any existing prior service costs over a ten year period. The City's obligation is the financial requirement for the year less state aids. Any additional payments by the City shall be used to amortize the unfunded liability of the relief association. The Association is comprised of volunteers; therefore, there are no payroll expenditures (i.e., there are no covered payroll percentage calculations). During the year, the City recognized as revenue and as an expenditure an on- behalf payment of$292,384 made by the State of Minnesota for the Relief Association. The City's annual pension cost for the current year and related information is as follows: Annual pension cost- $1,421,386 Asset valuation method-Market Valuation date-December 31, 2009 Actuarial assumptions: Actuarial cost method-Entry age normal cost Investment return-5% per year Amortization method-Level dollar open Assumed inflation rate-N/A Remaining amortization period Cost of living adjustment-N/A Normal cost-20 Prior service cost-10 Three Year Trend Information Year Ended Actual Contribution Required Percentage Dec 31, City State Total Contribution Contributed 2008 $ 411,221 $ 335,779 $ 747,000 $ 747,000 100% 2009 462,805 284,195 747,000 747,000 100% 2010 1,129,002 292,384 1,421,386 1,421,386 100% 59 City of Eden Prairie, Minnesota Notes to Financial Statements Note 7—Pension Plan (Continued) Required Supplementary Information Actuarial Actuarial Actuarial Accrued (Unfunded) Valuation Value of Liability Overfunded Funded Date Assets (AAL) AAL Ratio 12/31/2008 $ 11,749,341 $ 18,142,870 $ (6,393,529) 64.76% 12/31/2009 14,511,437 18,574,088 (4,062,651) 78.13% 12/31/2010 16,967,737 19,282,133 (2,314,396) 88.00% The Association is comprised of volunteers; therefore, there are no payroll expenditures (i.e.,there are no covered payroll percentage calculations). Note 8—Other Post-Employment Benefits Plan Plan Description The City provides post-employment insurance benefits to certain eligible employees through the City's Other Post-Employment Benefits Plan, a single-employer defined benefit plan administered by the City. All post-employment benefits are based on contractual agreements with employee groups. These contractual agreements do not include any specific contribution or funding requirements. These benefits are summarized as follows: Post-Employment Insurance Benefits All retirees of the City have the option under state law to continue their medical insurance coverage through the City from the time of retirement until the employee reaches the age of eligibility for Medicare. For members of all employee groups, the retiree must pay the full premium to continue coverage for medical and dental insurance. The City is legally required to include any retirees for whom it provides health insurance coverage in the same insurance pool as its active employees, whether the premiums are paid by the City or the retiree. Consequently, participating retirees are considered to receive a secondary benefit known as an "implicit rate subsidy." This benefit relates to the assumption that the retiree is receiving a more favorable premium rate than they would otherwise be able to obtain if purchasing insurance on their own, due to being included in the same pool with the City's younger and statistically healthier active employees. 60 City of Eden Prairie, Minnesota Notes to Financial Statements Note 8—Other Post-Employment Benefits Plan (Continued) Funding Policy The required contribution is based on projected pay-as-you-go financing requirements, with additional amounts to pre-fund benefits as determined annually by the City. Annual OPEB Cost and Net OPEB Obligation The City's annual OPEB cost (expense) is calculated based on annual required contributions (ARC) of the City, an amount determined on an actuarially determined basis in accordance with the parameters of GASB Statement Nos. 43 and 45. The City prospectively implemented these statements during 2008. The ARC represents a level funding that, if paid on an ongoing basis, is projected to cover normal costs each year and amortize any unfunded actuarial liabilities (or funding excess) over a period not to exceed 30 years. The following table shows the components of the City's annual OPEB cost for the year, the amount actually contributed to the plan, and the changes in the City's net OPEB obligation to the plan: Annual required contribution $ 288,354 Interest on net OPEB obligation 15,931 Adjustment to annual required contribution (21,441) Annual OPEB cost expense 282,844 Contributions made 64,723 Increase in net OPEB obligation 218,121 Net OPEB obligation-beginning of year 354,030 Net OPEB obligation-end of year $ 572,151 The City's annual OPEB cost, the percentage of annual OPEB cost contributed to the plan, and the net OPEB obligation for the year are as follows: % of Annual Fiscal Annual Employer OPEB Cost Net OPEB Year Ended OPEB Cost Contribution Contributed Obligation 12/31/08 $ 216,372 $ 33,824 15.6% $ 182,548 12/31/09 216,372 44,890 20.7% 354,030 12/31/10 282,844 64,723 22.9% 572,151 61 City of Eden Prairie, Minnesota Notes to Financial Statements Note 8—Other Post-Employment Benefits Plan (Continued) Funded Status and Funding Progress As of January 1, 2010, the plan was zero percent funded. The actuarial accrued liability for benefits was $2,438,910, and the actuarial value of assets was $0, resulting in an unfunded actuarial accrued liability (UAAL) of$2,438,910. The covered payroll (annual payroll of active employees covered by the plan) was $17,127,274, and the ratio of the UAAL to the covered payroll was 14.2%. Actuarial valuations of an ongoing plan involve estimates of the value of reported amounts and assumptions about the probability occurrence of events far into the future. Examples include assumptions about future employment, mortality, and the healthcare cost trend. Amounts determined regarding the funded status of the plan and ARCs of the employer are subject to continual revision as actual results are compared with past expectations and new estimates are made about the future. The Schedule of Funding Progress immediately following the notes to the basic financial statements presents multi-year trend information about whether the actuarial value of plan assets is increasing or decreasing over time relative to the actuarial accrued liabilities for benefits. Actuarial Methods and Assumptions Projections of benefits for financial reporting purposes are based on the substantive plan (the plan as understood by the employer and the plan members) and include the types of benefits provided at the time of each valuation and the historical pattern of sharing of benefit costs between the employer and plan members to that point. The actuarial methods and assumptions used include techniques that are designed to reduce the effects of short-term volatility in actuarial accrued liabilities and the actuarial value of assets, consistent with the long-term perspective of the calculations. In the January 1, 2010 actuarial valuation, the projected unit credit actuarial cost method was used. The actuarial assumptions included: a 4.5% percent investment rate of return (net of investment expenses) based on the City's own investments; an annual healthcare cost trend rate of 8.5% initially, reduced by decrements to an ultimate rate of 5% after eight years for medical insurance. The UAAL is being amortized on a level dollar basis over a closed period. The remaining period at January 1, 2010 is 30 years or less. 62 City of Eden Prairie, Minnesota Notes to Financial Statements Note 9—Leases As Lessee The City has entered into two space leases in connection with its liquor store operations. Rental expense, excluding a prorated share of real estate taxes and common area operating costs, for the year ended December 31, 2010,was approximately$204,000. The following is an annual schedule of future minimum lease payments under these leases: Year Ended Prairie Prairie December 31, Village View 2011 119,400 88,165 2012 123,014 90,169 2013 126,710 90,169 2014 130,494 92,172 2015 134,430 92,172 2016-2019 402,884 380,713 $ 1,036,932 $ 833,560 As Lessor The City occupies approximately one-third of the City Center building. The remaining two-thirds are primarily leased to the Eden Prairie Independent School District and C.H. Robinson Company. The City recorded 2010 rental revenue of approximately $363,000 from these two tenants. Both the School District and C.H. Robinson Company have signed formal lease agreements wherein the City will receive approximately $372,000 annually through March 2011 plus the lessee's portion of maintenance, insurance and taxes. The City has entered into a lease agreement with Pure Grace for the rental of space located at the Smith Douglas More House. Rental income for the year ended December 31, 2010 was $34,000. This lease will expire on December 2011. The City will receive $34,000 annually through 2011. On September 8, 2010, the City has entered into a lease agreement with Ace Daycare for the rental of space located at 8098 Glen Lane. Rental income will not start until February 2011. This lease will expire on September 30, 2015. The City will receive $44,000 annually through 2015. 63 City of Eden Prairie, Minnesota Notes to Financial Statements Note 9—Leases (Continued) The assets acquired for these lease agreements is as follows: Govt' Liquor Activities Fund Asset: Land $ 2,534,900 $ 536,659 Building 11,873,679 1,900,408 Less: Accumulated depreciation (3,760,221) (416,677) Total $10,648,358 $ 2,020,390 Depreciation Expense $ 274,043 $ 37,936 Note 10—Long Term Debt 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 governmental activities. General obligation bonds are direct obligations and pledge the full faith and credit of the City. The City also issues assessment debt with governmental commitment to provide funds for the construction of streets and utilities. These bonds will be repaid from amounts levied against the property owners benefited by this construction. In the event that a deficiency exists because of unpaid or delinquent assessments at the time a debt service payment is due, the City must provide resources to cover the deficiency until other resources are received. Assessment debt with governmental commitment has been issued for governmental activities. The City also issued lease revenue bonds where the government pledges income derived from lease agreements to pay debt service. 64 City of Eden Prairie, Minnesota Notes to Financial Statements Note 10—Long Term Debt (Continued) Bonds currently outstanding (in thousands of dollars) are as follows: 2010 Interest Original Amount Maturities Rates Issue Outstanding Governmental Activity General obligation bonds G.O. Refunding Bonds of 2003A 2012 3.00-3.65% $ 3,185 $ 725 G.O. Refunding Bonds of 2003C 2014 2.00-3.90% 1,445 715 G.O. Bonds of 2005C 2026 4.10-4.20% 4,920 4,920 G.O. Bonds of 2006A 2021 3.50-4.25% 8,425 6,505 G.O. Bonds of 2006B 2027 4.25-4.50% 4,290 3,900 G.O. Bonds of 2006C 2012 4.25% 1,080 460 G.O. Equip Notes of 2008A 2018 3.00-4.00% 3,120 2,525 G.O. Equip Notes of 2009B 2018 3.00% 2,455 2,185 G.O. CIP Refunding Bonds 2009C 2014 2.50-3.00% 1,395 1,135 Lease revenue bonds Public Facility Bonds of 2007A 2028 3.60-4.50% 1,630 1,550 HRA Refunding Bonds of 2009A 2012 2.50-3.00% 3,235 2,245 Assess debt with govt commit G.O. Bonds of 2003D 2014 1.75-4.00% 4,305 650 G.O. Revolving Bonds of 2005A 2015 3.25-3.55% 2,390 1,305 G.O. Revolving Bonds of 2005B 2025 3.50-4.10% 2,690 2,200 G.O. Revolving Bonds of 2008B 2023 3.50-4.50% 1,845 1,655 G.O. Revolving Bonds of 2010A 2025 2.00-4.00% 1,190 1,190 Capital lease 2011 5.00% 123 43 Total $ 47,723 $ 33,908 65 City of Eden Prairie, Minnesota Notes to Financial Statements Note 10-Long Term Debt (Continued) Annual debt service requirements to maturity for governmental activity bonds (in thousands of dollars) are as follows: Assessment Debt with Govt Years Commitment Ending G.O.Bonds Lease Revenue Bonds Improv Bonds Total 12/31 Principal Interest Principal Interest Principal Interest Principal Interest 2011 $ 2,250 $ 868 $ 1,110 $ 114 $ 675 $ 259 $ 4,035 $ 1,241 2012 2,320 786 1,260 81 710 235 4,290 1,102 2013 2,280 711 65 61 715 211 3,060 983 2014 2,215 632 70 58 750 185 3,035 875 2015 1,185 558 70 56 595 162 1,850 776 2016 1,220 510 75 53 325 140 1,620 703 2017 1,255 461 80 50 340 129 1,675 640 2018 1,320 410 80 46 355 116 1,755 572 2019 940 363 85 42 365 102 1,390 507 2020 980 322 85 39 375 88 1,440 449 2021 1,025 279 90 35 385 73 1,500 387 2022 1,060 236 95 31 415 58 1,570 325 2023 1,120 191 100 26 425 41 1,645 258 2024 1,155 143 100 22 280 23 1,535 188 2025 1,190 93 100 17 290 12 1,580 122 2026 1,255 40 110 12 - - 1,365 52 2027 300 7 110 7 - - 410 14 2028 - - 110 3 - - 110 3 Total $23,070 $ 6,610 $ 3,795 $ 753 $ 7,000 $ 1,834 $33,865 $ 9,197 66 City of Eden Prairie, Minnesota Notes to Financial Statements Note 10—Long Term Debt (Continued) Capital Lease In 2008, the City entered into a new lease for financing the purchase of turn out gear for the Fire department. The lease agreement qualifies as a capital lease for accounting purposes and, therefore, has been recorded at the present value of their future minimum lease payments as of the inception date. This equipment was not capitalized by the City. The last lease obligations of$42,751 in principal and$2,101 in interest will be made in 2011. 67 City of Eden Prairie, Minnesota Notes to Financial Statements Note 10—Long Term Debt (Continued) Changes in Long Term Debt Long-term debt activity for the year ended December 31, 2010, (in thousands of dollars)was as follows: Due Beginning Ending Within Balance Additions Reductions Balance One Year Governmental Activity G.O. bonds $ 25,300 $ - $ 2,230 $23,070 $ 2,250 Lease revenue bonds 4,845 - 1,050 3,795 1,110 Assess. debt with govt commit Improvement bonds 6,400 1,190 590 7,000 675 Issuance premium/discount 178 14 38 154 - Deferred gain 286 - 77 209 - Total bonds 37,009 1,204 3,985 34,228 4,035 Compensated absences 1,625 1,570 1,546 1,649 874 Capital lease 84 - 41 43 43 Total $ 38,718 $ 2,774 $ 5,572 $35,920 $ 4,952 Business Type Activity Compensated absences $ 192 $ 239 $ 212 $ 219 $ 116 Total $ 192 $ 239 $ 212 $ 219 $ 116 For the governmental activities, the capital lease is generally paid with reserved fund balances within the General fund. Compensated absences will be paid out of the Internal Service fund. There are a number of limitations and restrictions contained in the various bond indentures. The City is in compliance with all significant limitations and restrictions. Call provisions are applicable to certain general obligation and special assessment bond issues. 68 City of Eden Prairie, Minnesota Notes to Financial Statements Note 11—Risk Financing and Related Insurance Issues The City is exposed to various risk of loss related to torts; thefts of, damage to and destruction of assets; errors and omissions; injuries to employees; and natural disasters. In order to protect against these risks of loss, the City purchases commercial insurance through the League of Minnesota Cities Insurance Trust, a public entity risk pool, for property insurance and workers compensation. This pool currently operates as a common risk management and insurance program for municipal entities. The City pays an annual premium to the League for its insurance coverage. The League of Minnesota Cities Insurance Trust is self-sustaining through commercial companies for excess claims. The City is covered through the pool for any claims incurred but unreported, however, retains risk for the deductible portion of its insurance policies. The amount of these deductibles is considered immaterial to the financial statements. During the year ended December 31, 2010, these were no significant reductions in insurance coverage from the prior year. Settled claims have not exceeded the City's commercial coverage in any of the past three years. Note 12—Contingencies The City has been named in various legal actions. At the present time, there is no significant litigation pending that would cause a material effect on the financial statements if unfavorable rulings would result. While it is not possible to provide any probability of success or estimate of potential loss in defending any of these legal actions, the City expects to contest the allegations vigorously and does not believe these actions will have a material effect on the financial statements. A potential claim may be asserted against the City arising out of its membership in the Western Area Firing Training Academy (WAFTA). WAFTA is a joint powers entity consisting of 11 member cities that was formed in 1974 to purchase property to be used and operated as a fire training facility. In the late 1980's, WAFTA became aware that the site was contaminated. Since that time, WAFTA has been working with the Minnesota Pollution Control Agency(MPCA) and other responsible parties to address the contamination issues on the site. At this time, there is not an estimated dollar amount of the cost to remediate the site nor has a claim been asserted against WAFTA or the City. Note 13—Contract Commitments At December 31, 2010, the City had commitments on various construction projects. These commitments totaled approximately$158,926. 69 City of Eden Prairie, Minnesota Notes to Financial Statements Note 14—Conduit Debt Obligations From time to time, the City has issued Industrial Revenue and Housing bonds to provide financial assistance to private-sector entities for the acquisition and construction of industrial and commercial facilities deemed to be in the public interest. The bonds are secured by the property financed and are payable solely from payments received on the underlying mortgage loans. Upon repayment of the bonds, ownership of the acquired facilities transfers to the private-sector entity served by the bond issuance. Neither the City, the State, nor any political subdivision thereof is obligated in any manner for repayment of the bonds. Accordingly, the bonds are not reported as liabilities in the accompanying financial statements. As of December 31, 2010, there were 43 series of Industrial Revenue Bonds outstanding,with outstanding balances of$167,730,303. Note 15—Subsequent Events On March 15, 2011 the City issued Taxable General Obligation Water and Sewer Revenue Bonds Series 2011A for$1,260,000. These bonds financed the roof improvements at the Water Treatment Plant. A portion of the bonds mature annually over ten years with an interest rate ranging from .5%-3.8%. On March 15, 2011 the City issued General Obligation Bonds Series 2011B for$3,735,000. These bonds financed the purchase of SCBA fire gear,water utility improvements and sewer utility equipment and improvements. A portion of the bonds mature annually over ten years with an interest rate ranging from 2.5%-3%. 70 City of Eden Prairie, Minnesota Required Supplemental Information Modified Approach for Infrastructure Assets Condition Rating of the City's Street System Average PCI 2010 81.10% 2007 81.30% 2004 80.40% 2001 80.50% 1998 84.90% Comparison of Needed-to-Actual Maintenance/Preservation 2010 2009 2008 2007 2006 Budget $2,280,000 $2,190,000 $2,080,000 $ 1,795,000 $ 1,695,000 Actual 1,960,670 2,187,455 1,581,724 1,312,279 1,609,348 Difference $ (319,330) $ (2,545) $ (498,276) $ (482,721) $ (85,652) The condition of road pavement is measured using Good Pointe's Icon pavement management system. Each of the pavements in the City of Eden Prairie was visually inspected using the Paver-based Pavement Condition Index (PCI) methodology. The methodology is based on a numeric rating system ranging from 100 for a newly surfaced pavement to 0 for a failed pavement. The condition index is used to classify roads in excellent condition (85-100), very good condition (70-84), good condition (55-69), fair condition (40-54), poor condition (25-39), very poor condition (10-24) and failed condition (0-9). It is the City's policy to maintain an average PCI of 60 percent. 71 City of Eden Prairie, Minnesota Required Supplemental Information Other Post-Employment Benefits Plan Schedule of Funding Progress Unfunded Unfunded Actuarial Actuarial Actuarial Actuarial Liability Valuation Accrued Value of Accrued Funded Covered as a % of Date Liability Plan Assets Liability Ratio Payroll Payroll 1/1/08 $ 1,781,809 $ - $ 1,781,809 0.0% $ 16,945,552 10.5% 1/1/09 1,781,809 - 1,781,809 0.0% 16,945,552 10.5% 1/1/10 2,438,910 - 2,438,910 0.0% 17,127,274 14.2% 72 Combining & Individual Fund Statements & Schedules City of Eden Prairie, Minnesota Nonmajor Governmental Funds Special Revenue Funds Special revenue funds are used to account for specific revenues that are legally restricted to expenditures for a particular purpose. Housing Redevelopment Authority(HRA Grant) - This fund accounts for monies received under Title I of the Housing and Community Development Act of 1974 and other related housing activities. Police - This fund accounts for all confiscated money, and / or property obtained through drug-related criminal arrests and compliance fines. The funds are earmarked for expenditures on law enforcement operations. Pleasant Hills Cemetery - This fund accounts for the current operations of the City cemetery including maintenance costs and lot sales. Heritage Preservation Grant - This fund was established to account for a federal grant awarded to the City by the Minnesota Historical Society. The grant award is restricted to expenditure on evaluation and survey work on historic and prehistoric sites within Eden Prairie. Recycling - This fund accounts for monies received from Hennepin County's household waste rebate programs. All dollars received are to be refunded to eligible households within Eden Prairie. E-911 - This fund accounts for monies received from the State of Minnesota to be used for the E-911 emergency system. Senior Board - This fund was established to account for monies received for Senior Awareness Week. Fire Fighters - This fund accounts for donations and other collections to be used for Fire Department activities. 74 City of Eden Prairie, Minnesota Nonmajor Governmental Funds Debt Service Funds Debt service funds are used to account for revenues from taxes and other sources set aside for the payment of principal and interest and paying agent fees on all general obligation debt. HRA Lease Revenue 2002 - This fund accounts for the refunding of the HRA Lease Revenue Bonds of 1992 (Rink Addition) and the HRA Lease Revenue Bonds of 1993 (City Center). General Obligation Park Refunding 2003 - This fund accounts for the refunding of the G.O. Park Bonds which accounted for the accumulation of tax revenues needed to repay bonds issued to finance major park development and park improvement projects within the City. Open Space Refunding 2003 - This fund accounts for the refunding of the 1994 G.O. Open Space Bonds which accounted for the accumulation of tax revenues needed to repay bonds issued to finance the acquisition of land for the City's preservation program. General Obligation Improvement Revolving 2005A - This fund is used to account for the accumulation of tax revenues needed to repay bonds issued to pay the construction projects for the ADC project. General Obligation Bonds 2005C - This fund is used to account for the accumulation of tax revenues needed to repay bonds issued to pay the construction projects for various trails, park improvements and the community center. General Obligation Bonds 2006A - This fund is used to account for the accumulation of tax revenues needed to repay bonds issued to pay the construction projects for various trails, park improvements and the community center. General Obligation Bonds 2006B - This fund is used to account for the accumulation of tax revenues needed to repay bonds issued to pay the construction projects for the new Fire station. General Obligation Bonds 2006C - This fund is used to account for the accumulation of tax revenues needed to repay bonds issued to finance various fire vehicles and upgrades to the communications control room. 75 City of Eden Prairie, Minnesota Nonmajor Governmental Funds Debt Service Funds (Continued) 3rd Rink Lease Revenue Bonds 2007A - This fund is used to account for the accumulation of tax revenues needed to repay bonds issued to pay the construction projects for the 3' Sheet of Ice at the community center. Capital Equipment Notes 2008A - This fund is used to account for the accumulation of tax revenues needed to repay certificates issued to finance the 20/40/15 project, regional radio conversion project and two fire trucks. General Obligation Bonds 2008B - This fund is used to account for the accumulation of resources needed to repay bonds issued to finance the construction of streets, lateral utilities, and drainage for the Flying Cloud Drive construction project. The primary sources of repayment on these bonds are special assessments levied on benefited properties. Capital Equipment Notes 2009B - This fund is used to account for the accumulation of tax revenues needed to repay certificates issued to finance the 20/40/15 project and the regional radio conversion project. CIP Refunding Bonds 2009C - This fund accounts for the refunding of the HRA Lease Revenue Facility Bonds for the Fire Station. General Obligation Improvement Bonds 2010A - This fund is used to account for the accumulation of tax revenues needed to repay bonds issued to pay the construction costs for the Singletree Lane project. 76 City of Eden Prairie, Minnesota Nonmajor Governmental Funds Capital Projects Funds Capital projects funds are used to account for the construction and acquisition of major capital facilities, other than those financed by proprietary funds and trust funds. Park Improvement - This fund accounts for the park dedication fees, grants, and other contributions earmarked for expenditure on park acquisition and development. CIP Trails - This fund accounts for the accumulation of resources to be used for capital improvements and maintenance of City trails. CIP Pavement Management - This fund accounts for the accumulation of resources to be used for capital improvements and maintenance of City streets. Economic Development — This fund accounts for money set aside to assist in the redevelopment of the City. Project — This fund accounts for tax increment revenue set aside to assist in the redevelopment of the City. Parks Referendum — This fund accounts for the construction projects at the various city parks which were approved with the park referendum. Trails Referendum — This fund accounts for the construction projects on the various city trails which were approved with the park referendum. Sprint / Nextel — This fund accounts for contributions from Sprint for the transition of the City's radio system. HRA — This fund accounts for the accumulation of resources to be used for economic development projects. Transportation - This fund accounts for proceeds of state aid. This revenue is used to finance street improvements. 77 City of Eden Prairie, Minnesota Nonmajor Governmental Funds Permanent Funds Permanent funds are used to report resources that are legally restricted to the extent that only earnings, not principal, may be used for purposes that support the City's programs. Historical and Cultural - This fund was established to account for estate monies willed to the City for preservation and maintenance of the Cummins-Grill House. The fund also accumulates revenue from the sale of a book on Eden Prairie's 100-year history. The book was donated to the City by the Eden Prairie Historical Society, with revenues earmarked for expenditure on the preservation of the history of Eden Prairie. Cemetery Perpetual Care - This fund was established to account for funds dedicated for cemetery maintenance in accordance with state statutes. 78 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS DECEMBER 31,2010 Page 1 of 8 Special Revenue Pleasant Heritage HRA Hills Preservation Grant Police Cemetery Grant Recycling ASSETS Cash and investments $ 20,483 $ 214,903 $ 8,973 $ 5,193 $ 12,734 Receivables: Accounts - 275 - - - Interest - 649 27 132 Due from other governments 41,697 - - Unremitted taxes - Unremitted special assessments Deferred special assessments Special deferred special assessments Due from other funds - Prepaid items 130 Land Held for Resale - Cash and investments with escrow agent - - - - - Total assets $ 62,310 $ 215,827 $ 9,000 $ 5,193 $ 12,866 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ 58,749 $ 8,833 $ 14 $ $ 1,704 Salaries payable 621 - Interest payable - - Due to other governments Due to other funds Unearned revenue Deferred revenue - - Total liabilities 59,370 8,833 14 1,704 Fund balance: Reserved Reserved for prepaids 130 Reserved for perpetual care - - - - Unreserved;undesignated 2,810 206,994 8,986 5,193 11,162 Total fund balance 2,940 206,994 8,986 5,193 11,162 Total liabilities and fund balance $ 62,310 $ 215,827 $ 9,000 $ 5,193 $ 12,866 79 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS DECEMBER 31,2010 Page 2 of 8 Special Revenue Senior Fire E-911 Board Fighters Total ASSETS Cash and investments $ 269,635 $ 14,917 $ 16,712 $ 563,550 Receivables: Accounts - - - 275 Interest 795 52 53 1,708 Due from other governments 13,268 54,965 Unremitted taxes - - Unremitted special assessments Deferred special assessments Special deferred special assessments Due from other funds - Prepaid items 130 Land Held for Resale - Cash and investments with escrow agent - - - - Total assets $ 283,698 $ 14,969 $ 16,765 $ 620,628 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ 994 $ 751 $ - $ 71,045 Salaries payable - - 621 Interest payable - Due to other governments 1 1 Due to other funds Unearned revenue Deferred revenue - - - Total liabilities 994 752 71,667 Fund balance: Reserved Reserved for prepaids - - 130 Reserved for perpetual care - - - - Unreserved;undesignated 282,704 14,217 16,765 548,831 Total fund balance 282,704 14,217 16,765 548,961 Total liabilities and fund balance $ 283,698 $ 14,969 $ 16,765 $ 620,628 80 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS DECEMBER 31,2010 Page 3 of 8 Debt Service General General HRA Obligation Open Obligation General Lease Park Space Improv. Obligation Revenue Refunding Refunding Revolving Bonds 2002 2003 2003 2005A 2005C ASSETS Cash and investments $ 2,141,198 $ 247,393 $ 150,636 $ $ 282,570 Receivables: Accounts - - - - Interest 6,819 132 79 569 Due from other governments - - - - Unremitted taxes 2,296 1,003 748 1,126 Unremitted special assessments - - - - Deferred special assessments 845,179 Special deferred special assessments - Due from other funds - Prepaid items 400 Land Held for Resale - Cash and investments with escrow agent - - - - - Total assets $ 2,148,017 $ 249,689 $ 151,771 $ 846,006 $ 284,665 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ $ $ $ $ Salaries payable Interest payable Due to other governments Due to other funds 12,707 Unearned revenue - Deferred revenue 845,179 Total liabilities 857,886 Fund balance: Reserved Reserved for prepaids 400 Reserved for perpetual care - Unreserved;undesignated 2,148,017 249,689 151,771 (11,880) 284,265 Total fund balance 2,148,017 249,689 151,771 (11,880) 284,665 Total liabilities and fund balance $ 2,148,017 $ 249,689 $ 151,771 $ 846,006 $ 284,665 81 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS DECEMBER 31,2010 Page 4 of 8 Debt Service 3rd Rink General General General Lease Capital Obligation Obligation Obligation Revenue Equip Bonds Bonds Bonds Bonds Notes 2006A 2006B 2006C 2007A 2008A ASSETS Cash and investments $ 342,857 $ 348,766 $ 265,384 $ 1,510 $ Receivables: Accounts - - - - Interest 1,019 477 371 304 Due from other governments - - - - - Unremitted taxes 4,338 2,436 1,750 2,704 Unremitted special assessments - - - - Deferred special assessments Special deferred special assessments - Due from other funds 478,956 Prepaid items - Land Held for Resale - Cash and investments with escrow agent - - - 93,265 - Total assets $ 827,170 $ 351,679 $ 267,505 $ 95,079 $ 2,704 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ $ $ $ $ Salaries payable - Interest payable 318 Due to other governments - Due to other funds 35,473 Unearned revenue - Deferred revenue - Total liabilities 35,791 Fund balance: Reserved Reserved for prepaids - Reserved for perpetual care Unreserved;undesignated 827,170 351,679 267,505 95,079 (33,087) Total fund balance 827,170 351,679 267,505 95,079 (33,087) Total liabilities and fund balance $ 827,170 $ 351,679 $ 267,505 $ 95,079 $ 2,704 82 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS DECEMBER 31,2010 Page 5 of 8 Debt Service General General Capital CIP Obligation Obligation Equip Refunding Improvement Bonds Notes Bonds Bonds 2008B 2009B 2009C 2010A Total ASSETS Cash and investments $ 77 $ 105,464 $ 107,591 $ 1,475 $ 3,994,921 Receivables: Accounts - - - - Interest 583 503 10,856 Due from other governments - - - Unremitted taxes 2,345 2,169 20,915 Unremitted special assessments - - - Deferred special assessments 845,179 Special deferred special assessments - Due from other funds 478,956 Prepaid items 400 Land Held for Resale - Cash and investments with escrow agent - - - 93,265 Total assets $ 77 $ 108,392 $ 110,263 $ 1,475 $ 5,444,492 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ $ - $ 790 $ 5,825 $ 6,615 Salaries payable - - - Interest payable 53 371 Due to other governments - Due to other funds 48,180 Unearned revenue - Deferred revenue - - 845,179 Total liabilities 53 790 5,825 900,345 Fund balance: Reserved Reserved for prepaids - - 400 Reserved for perpetual care - - - Unreserved;undesignated 24 108,392 109,473 (4,350) 4,543,747 Total fund balance 24 108,392 109,473 (4,350) 4,544,147 Total liabilities and fund balance $ 77 $ 108,392 $ 110,263 $ 1,475 $ 5,444,492 83 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS DECEMBER 31,2010 Page 6 of 8 Capital Projects CIP Economic Park CIP Pavement Development Project Improvement Trails Management Fund Fund ASSETS Cash and investments $ 2,277,000 $ 23,002 $ 1,519,723 $ 3,789,622 $ 3,935,565 Receivables: Accounts - - - - - Interest 6,222 609 7,283 11,983 10,182 Due from other governments 24,618 - - - - Unremitted taxes - 294,006 Unremitted special assessments - Deferred special assessments Special deferred special assessments - Due from other funds 46,590 Prepaid items - - Land Held for Resale 801,699 Cash and investments with escrow agent - - - - - Total assets $ 2,307,840 $ 23,611 $ 1,527,006 $ 4,603,304 $ 4,286,343 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ $ $ $ $ 232,431 Salaries payable - Interest payable Due to other governments 4 Due to other funds Unearned revenue 352,829 Deferred revenue - - Total liabilities 352,833 232,431 Fund balance: Reserved Reserved for prepaids - Reserved for perpetual care - Unreserved;undesignated 1,955,007 23,611 1,527,006 4,603,304 4,053,912 Total fund balance 1,955,007 23,611 1,527,006 4,603,304 4,053,912 Total liabilities and fund balance $ 2,307,840 $ 23,611 $ 1,527,006 $ 4,603,304 $ 4,286,343 84 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS DECEMBER 31,2010 Page 7 of 8 Capital Projects Parks Trails Sprint/ Referendum Referendum Nextel HRA Transportation Total ASSETS Cash and investments $ 2,080,819 $ 105,654 $ $ 181,302 $ 283,707 $ 14,196,394 Receivables: Accounts - - - - - Interest - 331 741 37,351 Due from other governments 400,000 - - 424,618 Unremitted taxes - 2,382 296,388 Unremitted special assessments - - - Deferred special assessments 178,617 178,617 Special deferred special assessments - - Due from other funds 46,590 Prepaid items - Land Held for Resale 801,699 Cash and investments with escrow agent - - - - Total assets $ 2,080,819 $ 505,654 $ $ 184,015 $ 463,065 $ 15,981,657 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ 16,102 $ 24,234 $ $ - $ $ 272,767 Salaries payable - - 4,459 4,459 Interest payable - - Due to other governments - 4 Due to other funds 46,590 46,590 Unearned revenue - 352,829 Deferred revenue - - 178,617 178,617 Total liabilities 16,102 24,234 46,590 4,459 178,617 855,266 Fund balance: Reserved Reserved for prepaids - - - - - - Reserved for perpetual care - - - - - Unreserved;undesignated 2,064,717 481,420 (46,590) 179,556 284,448 15,126,391 Total fund balance 2,064,717 481,420 (46,590) 179,556 284,448 15,126,391 Total liabilities and fund balance $ 2,080,819 $ 505,654 $ $ 184,015 $ 463,065 $ 15,981,657 85 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS DECEMBER 31,2010 Page 8 of 8 Permanent Fund Cemetery Total Historical Perpetual Nonmajor and Care Governmental Cultural Fund Total Funds ASSETS Cash and investments $ 7,179 $ 250,227 $ 257,406 $ 19,012,271 Receivables: Accounts - - - 275 Interest 26 808 834 50,749 Due from other governments - - 479,583 Unremitted taxes 317,303 Unremitted special assessments - Deferred special assessments 1,023,796 Special deferred special assessments - Due from other funds 525,546 Prepaid items 530 Land Held for Resale 801,699 Cash and investments with escrow agent - - - 93,265 Total assets $ 7,205 $ 251,035 $ 258,240 $ 22,305,017 LIABILITIES AND FUND BALANCE Liabilities: Accounts and contracts payable $ $ $ $ 350,427 Salaries payable 5,080 Interest payable 371 Due to other governments 5 Due to other funds 94,770 Unearned revenue 352,829 Deferred revenue 1,023,796 Total liabilities 1,827,278 Fund balance: Reserved Reserved for prepaids 530 Reserved for perpetual care 117,656 117,656 117,656 Unreserved;undesignated 7,205 133,379 140,584 20,359,553 Total fund balance 7,205 251,035 258,240 20,477,739 Total liabilities and fund balance $ 7,205 $ 251,035 $ 258,240 $ 22,305,017 86 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES,AND CHANGES IN FUND BALANCES Page 1 of 8 NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Special Revenue Pleasant Heritage HRA Hills Preservation Grant Police Cemetery Grant Recycling REVENUES General property taxes $ $ $ $ $ Special assessments Intergovernmental revenue State street aid - Other grants 338,974 - - - 140,435 Fines and forfeits - 375 - - - Investment income - 2,141 137 - 507 Interest on escrow fund - - - Other revenue Fees - - 16,670 - - Contributions and donations - - Miscellaneous - 25,465 - - - Total revenues 338,974 27,981 16,807 - 140,942 EXPENDITURES Current: General government 341,003 - - - - Public safety - 42,051 - - - Public works - - - - 143,675 Parks and recreation - - 40,062 - - Interest on interfund borrowing - Capital outlay: Public safety Public works Parks and recreation Debt service: Principal Interest - - - - - Bond issuance cost Fiscal agent fees - - - - Total expenditures 341,003 42,051 40,062 - 143,675 Excess of revenues over(under)expenditures (2,029) (14,070) (23,255) - (2,733) Other financing sources(uses): Issuance of debt Issuance of refunding bonds Payment to refunded bond escrow - Premiums - - - - - Transfers in - - 25,414 - - Transfers out - Total other financing sources(uses) - - 25,414 - - Net change in fund balances (2,029) (14,070) 2,159 - (2,733) Fund balances(deficit)-January 1 4,969 221,064 6,827 5,193 13,895 Fund balances(deficit)-December 31 $ 2,940 $ 206,994 $ 8,986 $ 5,193 $ 11,162 87 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES,AND CHANGES IN FUND BALANCES Page 2 of 8 NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Special Revenue Senior Fire E-911 Board Fighters Total REVENUES General property taxes $ $ $ $ Special assessments Intergovernmental revenue State street aid - Other grants 79,605 - - 559,014 Fines and forfeits - - - 375 Investment income 3,117 202 208 6,312 Interest on escrow fund - - - - Other revenue Fees - - - 16,670 Contributions and donations - 4,568 - 4,568 Miscellaneous - - - 25,465 Total revenues 82,722 4,770 208 612,404 EXPENDITURES Current: General government - - - 341,003 Public safety 72,692 - - 114,743 Public works - - - 143,675 Parks and recreation - 4,536 - 44,598 Interest on interfund borrowing - - Capital outlay: Public safety Public works Parks and recreation Debt service: Principal Interest - - - - Bond issuance cost Fiscal agent fees - - Total expenditures 72,692 4,536 - 644,019 Excess of revenues over(under)expenditures 10,030 234 208 (31,615) Other financing sources(uses): Issuance of debt - - - Issuance of refunding bonds Payment to refunded bond escrow - Premiums - - - - Transfers in - - - 25,414 Transfers out - (1,430) - (1,430) Total other financing sources(uses) - (1,430) - 23,984 Net change in fund balances 10,030 (1,196) 208 (7,631) Fund balances(deficit)-January 1 272,674 15,413 16,557 556,592 Fund balances(deficit)-December 31 $ 282,704 $ 14,217 $ 16,765 $ 548,961 88 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES,AND CHANGES IN FUND BALANCES Page 3 of 8 NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Debt Service General General HRA Obligation Open Obligation General Lease Park Space Improv. Obligation Revenue Refunding Refunding Revolving Bonds 2002 2003 2003 2005A 2005C REVENUES General property taxes $ - $ 430,942 $ 188,228 $ 106,054 $ 211,312 Special assessments - - - 207,070 - Intergovernmental revenue State street aid - Other grants Fines and forfeits - - - - Investment income 16,948 121 693 1,364 2,352 Interest on escrow fund - - - - - Other revenue Fees Contributions and donations Miscellaneous - - - Total revenues 16,948 431,063 188,921 314,488 213,664 EXPENDITURES Current: General government - - - - - Public safety Public works Parks and recreation Interest on interfund borrowing Capital outlay: Public safety Public works Parks and recreation - - - - Debt service: Principal 990,000 380,000 150,000 235,000 - Interest 74,475 32,680 29,015 54,040 203,145 Bond issuance cost - - - - - Fiscal agent fees - 431 431 350 400 Total expenditures 1,064,475 413,111 179,446 289,390 203,545 Excess of revenues over(under)expenditures (1,047,527) 17,952 9,475 25,098 10,119 Other financing sources(uses): Issuance of debt - - - - Issuance of refunding bonds Payment to refunded bond escrow - Premiums - - - - - Transfers in 219,000 - - - - Transfers out - Total other financing sources(uses) 219,000 - - - - Net change in fund balances (828,527) 17,952 9,475 25,098 10,119 Fund balances(deficit)-January 1 2,976,544 231,737 142,296 (36,978) 274,546 Fund balances(deficit)-December 31 $ 2,148,017 $ 249,689 $ 151,771 $ (11,880)$ 284,665 89 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES,AND CHANGES IN FUND BALANCES Page 4 of 8 NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Debt Service 3rd Rink General General General Lease Capital Obligation Obligation Obligation Revenue Equip Bonds Bonds Bonds Bonds Notes 2006A 2006B 2006C 2007A 2008A REVENUES General property taxes $ 814,033 $ 345,404 $ 248,107 $ - $ 383,349 Special assessments - - - - Intergovernmental revenue State street aid Other grants Fines and forfeits - - - Investment income 3,889 1,893 1,244 2,296 - Interest on escrow fund - - - - Other revenue Fees Contributions and donations Miscellaneous - Total revenues 817,922 347,297 249,351 2,296 383,349 EXPENDITURES Current: General government - - - - - Public safety Public works Parks and recreation - Interest on interfund borrowing - - - - 1,381 Capital outlay: Public safety - Public works Parks and recreation - - - - - Debt service: Principal 505,000 160,000 225,000 60,000 280,000 Interest 274,563 174,770 24,331 67,610 96,667 Bond issuance cost - - - - - Fiscal agent fees 400 400 375 2,150 400 Total expenditures 779,963 335,170 249,706 129,760 378,448 Excess of revenues over(under)expenditures 37,959 12,127 (355) (127,464) 4,901 Other financing sources(uses): Issuance of debt - - - - Issuance of refunding bonds Payment to refunded bond escrow - Premiums - - - - - Transfers in - - - 130,000 - Transfers out - Total other financing sources(uses) - - - 130,000 - Net change in fund balances 37,959 12,127 (355) 2,536 4,901 Fund balances(deficit)-January 1 789,211 339,552 267,860 92,543 (37,988) Fund balances(deficit)-December 31 $ 827,170 $ 351,679 $ 267,505 $ 95,079 $ (33,087) 90 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES,AND CHANGES IN FUND BALANCES Page 5 of 8 NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Debt Service General General Capital CIP Obligation Obligation Equip Refunding Improvement Bonds Notes Bonds Bonds 2008B 2009B 2009C 2010A Total REVENUES General property taxes $ - $ 332,487 $ 307,458 $ - $ 3,367,374 Special assessments - - - - 207,070 Intergovernmental revenue State street aid - Other grants Fines and forfeits - - - Investment income - 3,569 2,733 - 37,102 Interest on escrow fund - - - Other revenue Fees Contributions and donations Miscellaneous - Total revenues - 336,056 310,191 - 3,611,546 EXPENDITURES Current: General government - - - Public safety Public works Parks and recreation - Interest on interfund borrowing 367 - - - 1,748 Capital outlay: Public safety - - Public works Parks and recreation - - - - Debt service: Principal 100,000 270,000 260,000 - 3,615,000 Interest 72,285 98,200 40,761 - 1,242,542 Bond issuance cost - - - 3,800 3,800 Fiscal agent fees 400 400 1,940 550 8,627 Total expenditures 173,052 368,600 302,701 4,350 4,871,717 Excess of revenues over(under)expenditures (173,052) (32,544) 7,490 (4,350) (1,260,171) Other financing sources(uses): Issuance of debt - Issuance of refunding bonds Payment to refunded bond escrow - - Premiums - - - - - Transfers in 173,000 - - - 522,000 Transfers out - - Total other financing sources(uses) 173,000 - - - 522,000 Net change in fund balances (52) (32,544) 7,490 (4,350) (738,171) Fund balances(deficit)-January 1 76 140,936 101,983 - 5,282,318 Fund balances(deficit)-December 31 $ 24 $ 108,392 $ 109,473 $ (4,350)$ 4,544,147 91 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES,AND CHANGES IN FUND BALANCES Page 6 of 8 NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Capital Projects CIP Economic Park CIP Pavement Development Project Improvement Trails Mgmt Fund Fund REVENUES General property taxes $ - $ - $ - $ - $ 3,450,291 Special assessments - Intergovernmental revenue State street aid Other grants 25,590 - - - - Fines and forfeits - - Investment income 24,830 3,290 38,673 27,477 42,400 Interest on escrow fund - - - - - Other revenue Fees 345,805 - - - - Contributions and donations 141,793 - - - - Miscellaneous - - - 19,187 - Total revenues 538,018 3,290 38,673 46,664 3,492,691 EXPENDITURES Current: General government - - - 34,519 2,700,185 Public safety - - Public works Parks and recreation Interest on interfund borrowing Capital outlay: Public safety - - Public works - 283,943 1,576,118 - - Parks and recreation 223,318 - - - - Debt service: Principal - Interest - - - - - Bond issuance cost Fiscal agent fees - Total expenditures 223,318 283,943 1,576,118 34,519 2,700,185 Excess of revenues over(under)expenditures 314,700 (280,653) (1,537,445) 12,145 792,506 Other financing sources(uses): Issuance of debt - - - Issuance of refunding bonds Payment to refunded bond escrow - - - Premiums - - - - - Transfers in 30,000 210,000 1,610,942 - - Transfers out - (35,942) - (789,386) - Total other financing sources(uses) 30,000 174,058 1,610,942 (789,386) - Net change in fund balances 344,700 (106,595) 73,497 (777,241) 792,506 Fund balances(deficit)-January 1 1,610,307 130,206 1,453,509 5,380,545 3,261,406 Fund balances(deficit)-December 31 $ 1,955,007 $ 23,611 $ 1,527,006 $ 4,603,304 $ 4,053,912 92 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES,AND CHANGES IN FUND BALANCES Page 7 of 8 NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Capital Projects Parks Trails Sprint/ Referendum Referendum Nextel HRA Transportation Total REVENUES General property taxes $ - $ - $ - $ 197,034 $ - $ 3,647,325 Special assessments - - - - 53,303 53,303 Intergovernmental revenue State street aid - - Other grants - - - - - 25,590 Fines and forfeits - - - Investment income 1,005 178 - 1,044 2,905 141,802 Interest on escrow fund - - - - - Other revenue Fees - - - - - 345,805 Contributions and donations - 400,000 - - - 541,793 Miscellaneous - - - - - 19,187 Total revenues 1,005 400,178 - 198,078 56,208 4,774,805 EXPENDITURES Current: General government - - - 157,358 - 2,892,062 Public safety - - Public works Parks and recreation Interest on interfund borrowing Capital outlay: Public safety - - - Public works - 476,916 - - 12,567 2,349,544 Parks and recreation 99,762 - - - - 323,080 Debt service: Principal - - Interest - - - - - - Bond issuance cost - - - Fiscal agent fees 1,550 775 - - - 2,325 Total expenditures 101,312 477,691 - 157,358 12,567 5,567,011 Excess of revenues over(under)expenditures (100,307) (77,513) - 40,720 43,641 (792,206) Other financing sources(uses): Issuance of debt Issuance of refunding bonds Payment to refunded bond escrow - Premiums - - - - - - Transfers in - - - - - 1,850,942 Transfers out - - - - - (825,328) Total other financing sources(uses) - - - - - 1,025,614 Net change in fund balances (100,307) (77,513) - 40,720 43,641 233,408 Fund balances(deficit)-January 1 2,165,024 558,933 (46,590) 138,836 240,807 14,892,983 Fund balances(deficit)-December 31 $ 2,064,717 $ 481,420 $ (46,590)$ 179,556 $ 284,448 $ 15,126,391 93 CITY OF EDEN PRAIRIE,MINNESOTA COMBINING STATEMENT OF REVENUES, EXPENDITURES,AND CHANGES IN FUND BALANCES Page 8 of 8 NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED DECEMBER 31,2010 Permanent Fund Cemetery Total Historical Perpetual Nonmajor and Care Governmental Cultural Fund Total Funds REVENUES General property taxes $ - $ - $ - $ 7,014,699 Special assessments - - - 260,373 Intergovernmental revenue State street aid - Other grants - - - 584,604 Fines and forfeits - - - 375 Investment income 54 2,589 2,643 187,859 Interest on escrow fund - - - - Other revenue Fees 1,137 2,880 4,017 366,492 Contributions and donations - - - 546,361 Miscellaneous - - - 44,652 Total revenues 1,191 5,469 6,660 9,005,415 EXPENDITURES Current: General government 6,532 - 6,532 3,239,597 Public safety - - - 114,743 Public works - - - 143,675 Parks and recreation - - 44,598 Interest on interfund borrowing - - - 1,748 Capital outlay: Public safety - Public works - - - 2,349,544 Parks and recreation - - - 323,080 Debt service: Principal - - - 3,615,000 Interest - - - 1,242,542 Bond issuance cost - - - 3,800 Fiscal agent fees - - - 10,952 Total expenditures 6,532 - 6,532 11,089,279 Excess of revenues over(under)expenditures (5,341) 5,469 128 (2,083,864) Other financing sources(uses): Issuance of debt - - Issuance of refunding bonds Payment to refunded bond escrow - Premiums - - - - Transfers in - - - 2,398,356 Transfers out - (25,414) (25,414) (852,172) Total other financing sources(uses) - (25,414) (25,414) 1,546,184 Net change in fund balances (5,341) (19,945) (25,286) (537,680) Fund balances(deficit)-January 1 12,546 270,980 283,526 21,015,419 Fund balances(deficit)-December 31 $ 7,205 $ 251,035 $ 258,240 $ 20,477,739 94 City of Eden Prairie, Minnesota Internal Service Funds Internal Service Funds Internal service funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the government and to other government units, on a cost reimbursement basis. Health & Benefits - This fund accounts for the activities pertaining to health, dental, life and disability insurance. This fund also accounts for the employer's portion of pension, FICA and medicare contributions. Severance - This fund accounts for the payment of unused personal time off for governmental fund employees. Workers Compensation - This fund accounts for the costs associated with workers' compensation. Revenues are primarily charges to other funds, interest earnings and insurance checks. Expenditures will consist of insurance premiums. Property Insurance - This fund accounts for the costs associated with the City's property and casualty insurance program. Revenues are primarily charges to other funds and interest earnings. Expenditures will consist of insurance premiums. Facilities - This fund accounts for the costs associated with maintaining city owned buildings. Revenues are primarily charges to other funds and interest earnings. Fleet - These funds account for the costs associated with maintaining machinery and equipment for the City. Revenues are primarily charges to other funds and interest earnings. Information Technology - These funds account for the costs associated with maintaining and upgrading the network, computer infrastructure and communications service technologies that support the City's mission-critical operations. Revenues are primarily charges to other funds and interest earnings. 95 CITY OF EDEN PRAIRIE,MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF NET ASSETS DECEMBER 31,2010 Health& Workers Property Benefits Severance Compensation Insurance ASSETS Current assets: Cash and investments $ 789,117 $ 1,740,579 $ $ 419,078 Receivables: Accounts Receivable 14,418 - - Interest 649 5,747 1,099 Due from other governments - - - Due from other funds 54,104 Inventory - - Prepaid items - - 75,116 139,006 Total current assets 804,184 1,800,430 75,116 559,183 Non-current assets: Capital assets Property,plant and equipment - - - - Less accumulated depreciation Total noncurrent assets - - - - Total assets $ 804,184 $ 1,800,430 $ 75,116 $ 559,183 LIABILITIES Current Liabilities: Accounts payable $ 101,435 $ - $ 37,790 $ - Salaries payable - 1,895 1,895 Interest payable - 146 - Due to other governments 267,333 - Unearned Revenue - - Due to other funds - 54,104 Current portion of compensated absences - 873,715 - - Total current liabilities 368,768 873,715 93,935 1,895 Noncurrent liabilities: Net OPEB 451,785 - 1,320 1,320 Compensated absences - 774,803 - - Total noncurrent liabilities 451,785 774,803 1,320 1,320 Total liabilities 820,553 1,648,518 95,255 3,215 Net assets: Invested in capital assets - - - - Unrestricted (16,369) 151,912 (20,139) 555,968 Total net assets (16,369) 151,912 (20,139) 555,968 Total liabilities and net assets $ 804,184 $ 1,800,430 $ 75,116 $ 559,183 96 CITY OF EDEN PRAIRIE,MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF NET ASSETS DECEMBER 31,2010 Information Facilities Fleet Technology Total ASSETS Current assets: Cash and investments $ 2,837,814 $ 1,887,867 $ 337,724 $ 8,012,179 Receivables: Accounts Receivable 1,767 2,126 7,372 25,683 Interest 3,668 4,383 2,741 18,287 Due from other governments - - 1,667 1,667 Due from other funds - - 54,104 Inventory 90,971 - 90,971 Prepaid items - 1,500 16,142 231,764 Total current assets 2,843,249 1,986,847 365,646 8,434,655 Non-current assets: Capital assets Property,plant and equipment 849,358 - - 849,358 Less accumulated depreciation (28,406) (28,406) Total noncurrent assets 820,952 - - 820,952 Total assets $ 3,664,201 $ 1,986,847 $ 365,646 $ 9,255,607 LIABILITIES Current Liabilities: Accounts payable $ 323,071 $ 98,823 $ 50,914 $ 612,033 Salaries payable 23,972 17,057 20,770 65,589 Interest payable - - - 146 Due to other governments 57 366 112 267,868 Unearned Revenue 104,704 - - 104,704 Due to other funds - 54,104 Current portion of compensated absences - - - 873,715 Total current liabilities 451,804 116,246 71,796 1,978,159 Noncurrent liabilities: Net OPEB 15,190 15,208 9,512 494,335 Compensated absences - - - 774,803 Total noncurrent liabilities 15,190 15,208 9,512 1,269,138 Total liabilities 466,994 131,454 81,308 3,247,297 Net assets: Invested in capital assets 820,952 - - 820,952 Unrestricted 2,376,255 1,855,393 284,338 5,187,358 Total net assets 3,197,207 1,855,393 284,338 6,008,310 Total liabilities and net assets $ 3,664,201 $ 1,986,847 $ 365,646 $ 9,255,607 97 CITY OF EDEN PRAIRIE,MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS FOR THE YEAR ENDED DECEMBER 31,2010 Health& Workers Property Benefits Severance Compensation Insurance OPERATING REVENUE Charges for services $ 4,158,639 $ 8,774 $ 610,250 $ 602,509 Grants - - - - Other revenue 5,528 - 13,085 101,880 Total operating revenues 4,164,167 8,774 623,335 704,389 OPERATING EXPENSE Cost of services Personal services 2,664,238 108,691 61,577 62,478 Chemicals and supplies - - 206 - Insurance 1,754,945 510,782 437,111 Contractual services 26,762 1,018 - Repairs and maintenance - - Disposal charges Utilities User charges Depreciation - - - - Total operating expenses 4,445,945 108,691 573,583 499,589 Operating income(loss) (281,778) (99,917) 49,752 204,800 NONOPERATING REVENUE(EXPENSE) Investment income/(expense) 2,947 19,048 (64) 5,656 Unrealized gain/(loss)on investments (33) (9,890) 820 846 Gain(loss)on disposition of fixed assets - - - - Total nonoperating revenues(expenses) 2,914 9,158 756 6,502 Income(loss)before transfers (278,864) (90,759) 50,508 211,302 Transfer in - - Transfer out - - Changes in net assets (278,864) (90,759) 50,508 211,302 Total net assets,January 1 262,495 242,671 (70,647) 344,666 Total net assets,December 31 $ (16,369) $ 151,912 $ (20,139) $ 555,968 98 CITY OF EDEN PRAIRIE,MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS FOR THE YEAR ENDED DECEMBER 31,2010 Information Facilities Fleet Technology Total OPERATING REVENUE Charges for services $ 3,966,418 $ 2,209,159 $ 1,719,702 $ 13,275,451 Grants 3,240 - - 3,240 Other revenue 1,426,248 30,494 18,983 1,596,218 Total operating revenues 5,395,906 2,239,653 1,738,685 14,874,909 OPERATING EXPENSE Cost of services Personal services 798,121 513,528 684,242 4,892,875 Chemicals and supplies 285,546 1,144,223 242,698 1,672,673 Insurance - - - 2,702,838 Contractual services 2,193,283 8,125 432,294 2,661,482 Repairs and maintenance 225,201 360,249 248,417 833,867 Disposal charges 44,172 3,396 - 47,568 Utilities 1,032,917 - 31,712 1,064,629 User charges 15,947 19,284 3,417 38,648 Depreciation 16,059 - - 16,059 Total operating expenses 4,611,246 2,048,805 1,642,780 13,930,639 Operating income(loss) 784,660 190,848 95,905 944,270 NONOPERATING REVENUE(EXPENSE) Investment income/(expense) 16,420 20,078 12,038 76,123 Unrealized gain/(loss)on investments (514) 5 (705) (9,471) Gain(loss)on disposition of fixed assets - 93,877 - 93,877 Total nonoperating revenues(expenses) 15,906 113,960 11,333 160,529 Income(loss)before transfers 800,566 304,808 107,238 1,104,799 Transfer in 800,000 - - 800,000 Transfer out (12,390) - (807,278) (819,668) Changes in net assets 1,588,176 304,808 (700,040) 1,085,131 Total net assets,January 1 1,609,031 1,550,585 984,378 4,923,179 Total net assets,December 31 $ 3,197,207 $ 1,855,393 $ 284,338 $ 6,008,310 99 CITY OF EDEN PRAIRIE,MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31,2010 Health& Workers Property Benefits Severance Comp Insurance CASH FLOWS FROM OPERATING ACTIVITIES: Receipts from customers $ 4,156,224 $ 8,774 $ 615,991 $ 680,947 Payments from other funds - - (88,767) - Payments to other funds 88,767 Payments to vendors (1,474,633) - (479,417) (629,995) Payments to employees (2,497,384) (84,848) (61,070) (61,592) Other receipts 5,528 - 13,085 101,880 Net cash provided(used)by operating activities 189,735 12,693 (178) 91,240 CASH FLOWS FROM INVESTING ACTIVITIES: Investment income 2,924 16,058 178 5,880 Net cash provided(used)by investing activities 2,924 16,058 178 5,880 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Transfers in - - - - Transfers(out) Net cash provided(used)by noncapital financing activities CASH FLOWS FROM CAPITAL FINANCING ACTIVITIES: Acquisition and construction of capital assets Proceeds from sale of equipment Net cash provided(used)by capital financing activities - - - Net increase(decrease)in cash and cash equivalents 192,659 28,751 97,120 Cash and cash equivalents,January 1 596,458 1,711,828 321,958 Cash and cash equivalents,December 31 $ 789,117 $ 1,740,579 $ $ 419,078 100 CITY OF EDEN PRAIRIE,MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31,2010 Page 1 of 2 Information Facilities Fleet Technology Total CASH FLOWS FROM OPERATING ACTIVITIES: Receipts from customers $ 3,975,016 $ 2,213,677 $ 1,712,330 $ 13,362,959 Payments from other funds - - - (88,767) Payments to other funds 88,767 Payments to vendors (3,840,581) (1,503,700) (1,026,272) (8,954,598) Payments to employees (789,013) (508,788) (677,478) (4,680,173) Other receipts 1,429,488 30,494 18,983 1,599,458 Net cash provided(used)by operating activities 774,910 231,683 27,563 1,327,646 CASH FLOWS FROM INVESTING ACTIVITIES: Investment income 16,198 19,993 11,779 73,010 Net cash provided(used)by investing activities 16,198 19,993 11,779 73,010 CASH FLOWS FROM NONCAPITAL FINANCING ACT Transfers in 800,000 - - 800,000 Transfers(out) (12,390) (807,278) (819,668) Net cash provided(used)by noncapital financing activitie 787,610 (807,278) (19,668) CASH FLOWS FROM CAPITAL FINANCING ACTIVITIES: Acquisition and construction of capital assets (19,974) - (19,974) Proceeds from sale of equipment 93,877 93,877 Net cash provided(used)by capital financing activities (19,974) 93,877 73,903 Net increase(decrease)in cash and cash equivalents 1,558,744 345,553 (767,936) 1,454,891 Cash and cash equivalents,January 1 1,279,070 1,542,314 1,105,660 6,557,288 Cash and cash equivalents,December 31 $ 2,837,814 $ 1,887,867 $ 337,724 $ 8,012,179 101 CITY OF EDEN PRAIRIE,MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31,2010 Health& Workers Property Benefits Severance Comp Insurance RECONCILIATION OF OPERATING INCOME (LOSS)TO NET CASH PROVIDED(USED) BY OPERATING ACTIVITIES: Operating income(loss) $ (281,778) $ (99,917) $ 49,752 $ 204,800 Adjustments to reconcile operating income(loss) to net cash provided(used)by operating activities: Depreciation - - (Increase)decrease in assets: Accounts receivable (2,415) 5,741 78,438 Taxes receivable - - - - Due from other funds 88,767 Due from other governments 10,577 - Inventory - - Prepaid items 241,348 3,776 (86,766) Increase(decrease)in liabilities: Accounts payable 11,954 28,813 (105,476) Salaries payable - - 379 Unearned revenue - - Due to other governments 43,195 (642) Due to other funds - (88,767) - Net other post employment benefits 166,854 - 507 507 Compensated absences - 23,843 - - Net Cash provided(used)by operating activities $ 189,735 $ 12,693 $ (178) $ 91,240 102 CITY OF EDEN PRAIRIE,MINNESOTA INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31,2010 Page 2 of 2 Information Facilities Fleet Technology Total RECONCILIATION OF OPERATING INCOME (LOSS)TO NET CASH PROVIDED(USED) BY OPERATING ACTIVITIES: Operating income(loss) $ 784,660 $ 190,848 $ 95,905 $ 944,270 Adjustments to reconcile operating income(loss) to net cash provided(used)by operating activities: Depreciation 16,059 - - 16,059 (Increase)decrease in assets: Accounts receivable (157) 4,518 (7,372) 78,753 Taxes receivable - - - Due from other funds 88,767 Due from other governments - 10,577 Inventory - 85 - 85 Prepaid items 218 103 4,352 163,031 Increase(decrease)in liabilities: Accounts payable (41,908) 35,443 (69,200) (140,374) Salaries payable 1,210 (1,310) 2,300 2,579 Unearned revenue 8,755 - 8,755 Due to other governments (1,825) (4,054) (2,886) 33,788 Due to other funds - - - (88,767) Net other post employment benefits 7,898 6,050 4,464 186,280 Compensated absences - - - 23,843 Net Cash provided(used)by operating activities $ 774,910 $ 231,683 $ 27,563 $ 1,327,646 103 City of Eden Prairie, Minnesota Agency Funds Agency Funds Agency funds are used to account for assets held by the government as an agent for individuals, private organizations, other governments, or other funds. Escrow - This fund is used to account for various deposits (mainly contractor's deposits to guarantee payment of special assessments for water, sewer, streets and other improvements) required by the City. This fund is also used for accumulating donations and other contributions for specific purposes. WAFTA — This fund accounts for the collection and remittance of expenses pertaining to the fire training facility owned by 11 member cities. MCES - This fund accounts for the collection and remittance of sewer availability charges to the Metropolitan Council Environmental Services. 104 CITY OF EDEN PRAIRIE,MINNESOTA AGENCY FUNDS COMBINING STATEMENT OF FIDUCIARY NET ASSETS DECEMBER 31,2010 Escrow 2010 Fund WAFTA MCES Total ASSETS Cash and investments $ 1,178,629 $ 71,537 $ 14,700 $ 1,264,866 Total assets $ 1,178,629 $ 71,537 $ 14,700 $ 1,264,866 LIABILITIES Accounts payable $ 1,178,629 $ - $ - $ 1,178,629 Due to other governments - 71,537 14,700 86,237 Total liabilities $ 1,178,629 $ 71,537 $ 14,700 $ 1,264,866 105 CITY OF EDEN PRAIRIE,MINNESOTA AGENCYFUNDS COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES FOR THE YEAR ENDED DECEMBER 31,2010 Balance Balance January 1 December 31 2010 Additions Deductions 2010 Escrow Assets: Cash and investments $ 611,779 $ 916,875 $ 350,025 $ 1,178,629 Total assets $ 611,779 $ 916,875 $ 350,025 $ 1,178,629 Liabilities: Accounts payable $ 611,779 $ 1,164,785 $ 597,935 $ 1,178,629 WAFTA: Assets: Cash and investments $ 122,695 $ 22,884 $ 74,042 $ 71,537 Total assets $ 122,695 $ 22,884 $ 74,042 $ 71,537 Liabilities: Accounts payable $ 243 $ 71,774 $ 72,017 $ - Due to other governments 122,452 22,884 73,799 71,537 Total liabilities $ 122,695 $ 94,658 $ 145,816 $ 71,537 MCES Assets: Cash and investments $ 4,425 $ 352,460 $ 342,185 $ 14,700 Accounts receivable 25,275 - 25,275 Total assets $ 29,700 $ 352,460 $ 367,460 $ 14,700 Liabilities: Due to other governments $ 29,700 $ 326,885 $ 341,885 $ 14,700 Total liabilities $ 29,700 $ 326,885 $ 341,885 $ 14,700 Totals-All Agency Funds Assets: Cash and investments $ 738,899 $ 1,292,219 $ 766,252 $ 1,264,866 Accounts receivable 25,275 - 25,275 Total assets $ 764,174 $ 1,292,219 $ 791,527 $ 1,264,866 Liabilities: Accounts payable $ 612,022 $ 1,236,559 $ 669,952 $ 1,178,629 Due to other governmental units 152,152 349,769 415,684 86,237 Total liabilities $ 764,174 $ 1,586,328 $ 1,085,636 $ 1,264,866 106 Statistical City of Eden Prairie, Minnesota Statistical Section (Unaudited) This part of the City of Eden Prairie's comprehensive annual financial report presents detailed information as a context for understanding this year's financial statements, note disclosures, and supplementary information. This information has not been audited by the independent auditor. Contents Page FinancialTrends.........................................................................................................................................109-114 These tables contain trend information that may assist the reader in assessing the City's current financial performance by placing it in historical perspective. RevenueCapacity.............................................................................................................................115-118 These tables contain information that may assist the reader in assessing the viability of the City's most significant"own-source" revenue, the property tax. DebtCapacity..............................................................................................................................................119-122 These tables present information that may assist the reader in analyzing the affordability of the City's current levels of outstanding debt and the City's ability to issue additional debt in the future. Demographic and Economic Information............................................................................................123-131 These tables offer economic and demographic indicators that are commonly used for financial analysis and that can increase one's understanding of the City's present and ongoing financial status. OperatingInformation.............................................................................................................................132-133 These tables contain service and infrastructure indicators that can increase one's understanding of how the information in the City's financial statements relates to the services the City provides and the activities it performs. Source: Unless otherwise noted,the information in these tables is derived from the comprehensive annual financial reports for the relevant year. The City implemented GASB Statement No. 34 in calendar year 2003; schedules presenting government-wide information include information beginning in that year. 108 City of Eden Prairie , Minnesota Government-wide Net Assets by Category ( accrual basis of accounting) Last Eight Years 2003 2004 2005 2006 2007 2008 2009 2010 Governmental Activities Invested in capital assets,net of related debt $ 106,289,304 $ 128,665,664 $ 135,346,250 $ 133,041,891 $ 155,494,482 $ 162,522,110 $ 165,578,857 $ 169,874,219 Restricted 12,352,637 6,200,846 6,225,359 6,298,693 6,090,520 6,231,872 9,470,494 8,882,954 Unrestricted 45,992,152 45,055,078 50,144,555 64,133,581 53,052,529 56,235,986 49,907,035 50,954,497 Subtotal governmental activities net assets 164,634,093 179,921,588 191,716,164 203,474,165 214,637,531 224,989,968 224,956,386 229,711,670 Business-type Activities Invested in capital assets,net of related debt 156,101,861 143,594,356 141,987,088 140,872,743 142,849,627 143,504,412 142,093,191 138,307,152 Unrestricted 3,488,927 9,935,174 11,466,456 10,575,056 9,249,768 7,050,651 6,301,188 5,224,848 Subtotal business-type activities net assets 159,590,788 153,529,530 153,453,544 151,447,799 152,099,395 150,555,063 148,394,379 143,532,000 Primary Government Invested in capital assets,net of related debt 262,391,165 272,260,020 277,333,338 273,914,634 298,344,109 306,026,522 307,672,048 308,181,371 Restricted 12,352,637 6,200,846 6,225,359 6,298,693 6,090,520 6,231,872 9,470,494 8,882,954 Unrestricted 49,481,079 54,990,252 61,611,011 74,708,637 62,302,297 63,286,637 56,208,223 56,179,345 Total primary government net assets $ 324,224,881 $ 333,451,118 $ 345,169,708 $ 354,921,964 $ 366,736,926 $ 375,545,031 $ 373,350,765 $ 373,243,670 Less than ten years of information presented due to information not available prior to conversion to GASB 34. 109 City of Eden Prairie , Minnesota Changes in Net Assets-Total ( accrual basis of accounting) Last Eight Years Source 2003 2004 2005 2006 2007 2008 2009 2010 Expenses Governmental activities $ 32,123,423 $ 34,315,872 $ 38,130,927 $ 38,902,477 $ 41,926,473 $ 45,881,058 $ 47,397,022 $ 45,701,477 Business-type activities 19,853,224 20,881,410 22,121,630 22,634,036 24,768,351 25,265,911 25,599,664 26,739,072 Total expenses $ 51,976,647 $ 55,197,282 $ 60,252,557 $ 61,536,513 $ 66,694,824 $ 71,146,969 $ 72,996,686 $ 72,440,549 Program Revenues: Governmental activities $ 17,974,170 $ 14,928,446 $ 18,214,641 $ 14,693,423 $ 15,020,071 $ 16,270,317 $ 12,361,210 $ 13,032,144 Business-type activities 17,674,920 21,388,751 22,408,032 21,513,949 25,894,561 23,669,165 24,115,894 23,654,183 Total program revenues 35,649,090 36,317,197 40,622,673 36,207,372 40,914,632 39,939,482 36,477,104 36,686,327 Net(expense)revenue (16,327,557) (18,880,085) (19,629,884) (25,329,141) (25,780,192) (31,207,487) (36,519,582) (35,754,222) General revenues and transfers: Governmental activities 26,518,533 29,916,113 30,718,677 35,967,055 38,069,768 39,963,178 35,002,230 37,424,617 Business-type activities (677,069) (1,965,194) (620,361) (405,749) (474,614) 52,414 (676,914) (1,777,490) Total general revenues and transfers 25,841,464 27,950,919 30,098,316 35,561,306 37,595,154 40,015,592 34,325,316 35,647,127 Change in net assets $ 9,513,907 $ 9,070,834 $ 10,468,432 $ 10,232,165 $ 11,814,962 $ 8,808,105 $ (2,194,266) $ (107,095) Less than ten years of information presented due to information not available prior to conversion to GASB 34. 110 City of Eden Prairie , Minnesota Changes in Net Assets-Governmental Activities ( accrual basis of accounting) Last Eight Years Source 2003 2004 2005 2006 2007 2008 2009 2010 Expenses General government $ 9,577,100 $ 10,620,023 $ 13,375,941 $ 14,280,765 $ 14,424,872 $ 15,308,258 $ 9,506,104 $ 9,183,334 Public safety 8,244,041 10,910,006 12,102,614 11,713,095 13,883,325 15,808,506 19,346,668 17,985,648 Public works 8,456,449 6,473,043 6,810,846 7,313,935 5,960,154 7,048,819 8,128,507 7,522,749 Parks and recreation 4,338,435 5,480,061 4,949,620 4,396,128 6,087,328 6,212,450 8,606,431 9,769,235 Interest on longterm debt 1,507,398 832,739 891,906 1,198,554 1,570,794 1,503,025 1,809,312 1,240,511 Total expenses $ 32,123,423 $ 34,315,872 $ 38,130,927 $ 38,902,477 $ 41,926,473 $ 45,881,058 $ 47,397,022 $ 45,701,477 Program Revenues: Charges for services: General government $ 4,818,031 $ 1,988,779 $ 3,004,416 $ 2,859,961 $ 2,573,708 $ 2,506,269 $ 948,287 $ 958,005 Public safety 1,103,653 3,483,050 3,410,157 3,425,626 3,349,520 3,005,158 2,351,256 3,135,082 Public works 4,457,178 389,225 567,233 403,363 390,731 443,640 210,606 230,390 Parks and recreation 3,257,256 2,984,694 2,897,852 2,687,876 3,050,852 3,470,985 3,774,815 4,285,057 Interest on long term debt 50,301 - - - - - - - Operating grants and contributions 925,446 1,173,487 1,220,854 1,443,708 1,558,981 2,002,207 1,735,599 1,320,014 Capital grants and contributions 3,362,305 4,909,211 7,114,129 3,872,889 4,096,279 4,842,058 3,340,647 3,103,596 Total program revenues 17,974,170 14,928,446 18,214,641 14,693,423 15,020,071 16,270,317 12,361,210 13,032,144 Net(expense)revenue (14,149,253) (19,387,426) (19,916,286) (24,209,054) (26,906,402) (29,610,741) (35,035,812) (32,669,333) General revenues and transfers: Taxes Property taxes 24,714,298 25,156,515 26,280,177 28,545,219 31,222,834 31,907,308 31,687,277 31,527,570 Tax increment - 1,702,742 2,289,648 2,407,638 2,689,433 3,034,260 3,250,611 3,450,291 Grants and contributions not restricted to specific programs 384,565 343,241 298,506 190,446 225,295 195,478 206,907 229,510 Investment earnings 660,984 619,463 1,046,852 2,574,984 3,049,185 1,751,418 672,822 427,377 Gain(loss) on sale of capital assets - - - 1,431,440 - 2,883,897 (1,505,613) - Transfers 758,686 2,094,152 803,494 817,328 883,021 190,817 690,226 1,789,869 Total general revenues and transfers 26,518,533 29,916,113 30,718,677 35,967,055 38,069,768 39,963,178 35,002,230 37,424,617 Change in net assets $ 12,369,280 $ 10,528,687 $ 10,802,391 $ 11,758,001 $ 11,163,366 $ 10,352,437 $ (33,582) $ 4,755,284 ill City of Eden Prairie , Minnesota Changes in Net Assets-Business-type Activities ( accrual basis of accounting) Last Eight Years Source 2003 2004 2005 2006 2007 2008 2009 2010 Expenses Water/Sewer $ 12,174,191 $ 12,835,671 $ 11,838,114 $ 12,137,487 $ 13,161,533 $ 13,418,071 $ 13,462,844 $ 14,035,916 Storm - - 1,329,224 1,256,092 1,986,557 1,725,629 1,523,876 1,983,337 Liquor 7,679,033 8,045,739 8,954,292 9,240,457 9,620,261 10,122,211 10,612,944 10,719,819 Total expenses $ 19,853,224 $ 20,881,410 $ 22,121,630 $ 22,634,036 $ 24,768,351 $ 25,265,911 $ 25,599,664 $ 26,739,072 Program Revenues: Charges for services: Water/Sewer $ 8,088,439 $ 11,514,737 $ 9,734,838 $ 10,415,372 $ 11,553,501 $ 11,551,147 $ 11,487,634 $ 11,103,035 Storm - - 600,237 644,131 614,590 818,987 910,568 831,731 Liquor 8,415,914 8,880,874 10,038,462 10,454,446 10,741,799 11,299,031 11,717,692 11,687,919 Operating grants and contributions 31,498 Capital grants and contributions 1,170,567 993,140 2,034,495 - 2,984,671 - - - Total program revenues 17,674,920 21,388,751 22,408,032 21,513,949 25,894,561 23,669,165 24,115,894 23,654,183 Net(expense)revenue (2,178,304) 507,341 286,402 (1,120,087) 1,126,210 (1,596,746) (1,483,770) (3,084,889) General revenues and transfers: Investment earnings 19,835 128,958 183,133 411,579 408,407 243,231 13,312 12,379 Gain on sale of capital assets 16,540 - - - - - - - Transfers (713,444) (2,094,152) (803,494) (817,328) (883,021) (190,817) (690,226) (1,789,869) Total general revenues and transfers (677,069) (1,965,194) (620,361) (405,749) (474,614) 52,414 (676,914) (1,777,490) Change in net assets $ (2,855,373) $ (1,457,853) $ (333,959) $ (1,525,836) $ 651,596 $ (1,544,332) $ (2,160,684) $ (4,862,379) Less than ten years of information presented due to information not available prior to conversion to GASB 34. 112 City of Eden Prairie , Minnesota Fund Balances-Governmental Funds Last Ten Years 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 General fund Reserved $ 3,203,442 $ 3,946,916 $ 3,585,138 $ 3,906,562 $ 4,198,756 $ 1,145,293 $ 253,954 $ 138,507 $ 55,864 $ 66,238 Unreserved 12,699,147 15,099,670 16,281,005 16,526,362 17,133,623 18,042,399 19,392,450 20,292,813 20,535,345 20,877,251 Subtotal general fund 15,902,589 19,046,586 19,866,143 20,432,924 21,332,379 19,187,692 19,646,404 20,431,320 20,591,209 20,943,489 General fund%change 14.1% 19.8% 4.3% 2.9% 4.4% (10.1%) 2.4% 4.0% 0.8% 1.7% All other govt'funds Reserved 17,678,756 17,712,219 11,862,916 6,200,846 4,816,402 6,299,082 6,314,553 159,698 141,011 118,186 Unreserved: Special revenue 256,727 753,437 943,960 312,197 517,164 579,738 587,431 516,296 556,462 548,831 Debt service (109) (325) (56,285) (94,381) (43,896) (223) (1,162) 6,352,188 5,084,425 4,383,750 Capital projects 14,242,831 14,173,459 18,322,735 20,108,258 19,196,836 31,749,345 18,556,887 18,912,365 18,890,716 19,775,005 Trust and Agency 115,308 129,677 - - - - - - - - Permanent - - 134,773 136,053 138,518 139,106 139,965 142,094 143,045 140,584 Subtotal all other gout'funds 32,293,513 32,768,467 31,208,099 26,662,973 24,625,024 38,767,048 25,597,674 26,082,641 24,815,659 24,966,356 Total govt'funds Reserved 20,882,198 21,659,135 15,448,054 10,107,408 9,015,158 7,444,375 6,568,507 298,205 196,875 184,424 Unreserved 27,313,904 30,155,918 35,626,188 36,988,489 36,942,245 50,510,365 38,675,571 46,215,756 45,209,993 45,725,421 Totalgovt'funds $ 48,196,102 $ 51,815,053 $ 51,074,242 $ 47,095,897 $ 45,957,403 $ 57,954,740 $ 45,244,078 $ 46,513,961 $ 45,406,868 $ 45,909,845 All govt'funds%change 14.9% 7.5% (1.4%) (7.8%) (2.4%) 26.1% (21.9%) 2.8% (2.4%) 1.1% 113 City of Eden Prairie , Minnesota Changes in Fund Balances-Governmental Funds (modified accrual basis of accounting) Last Ten Years Source 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Revenues: Taxes and special assessments $ 24,837,688 $ 27,840,254 $ 27,783,835 $ 28,643,886 $ 30,206,322 $ 33,053,204 $ 35,309,781 $ 36,036,370 $ 36,547,460 $ 36,494,481 Licenses and permits 3,194,292 3,765,662 3,580,422 3,257,634 3,513,022 3,484,074 3,414,545 3,318,249 2,386,956 3,119,449 Intergovernmental revenue 2,796,134 1,825,736 2,312,517 3,922,628 1,600,867 4,347,179 3,064,142 4,332,864 4,114,295 2,437,441 Charges for services 5,489,550 6,360,624 6,203,761 2,179,595 2,744,535 3,011,863 2,881,485 4,106,763 3,506,697 3,919,848 Fines and forfeits 368,425 394,466 415,896 439,269 476,520 419,745 433,369 384,509 444,979 496,449 Investment income 2,228,704 1,508,510 769,912 710,752 1,152,288 2,807,250 3,101,558 1,811,199 638,483 406,281 Miscellaneous revenue 3,459,714 4,991,538 4,277,746 4,936,284 3,604,124 2,950,874 4,597,037 2,386,186 1,556,312 1,609,244 Total revenues $ 42,374,507 $ 46,686,790 $ 45,344,089 $ 44,090,048 $ 43,297,678 $ 50,074,189 $ 52,801,917 $ 52,376,140 $ 49,195,182 $ 48,483,193 Expenditures: General government $ 9,537,448 $ 9,644,814 $ 9,683,554 $ 10,431,323 $ 13,297,706 $ 14,420,850 $ 13,579,878 $ 14,236,199 $ 9,152,896 $ 8,726,894 Public safety 7,164,748 7,734,958 8,004,610 10,029,529 10,764,727 12,065,308 12,252,120 14,712,895 16,175,725 16,789,050 Public works 3,944,205 4,134,666 3,990,003 4,943,364 4,990,480 5,457,284 5,867,387 5,368,645 5,541,838 5,277,652 Parks and recreation 3,780,421 4,052,831 4,185,467 5,012,804 4,318,601 4,598,217 4,969,495 6,106,885 8,671,355 8,874,758 Capital outlay 6,006,368 14,466,576 11,676,808 11,347,805 16,999,203 10,000,224 25,478,947 13,517,922 8,188,289 5,919,859 Miscellaneous 925,794 540,838 105,960 87,377 120,672 242,555 275,397 210,039 130,251 42,967 Debt service Principal 5,844,538 9,265,487 4,022,560 3,861,549 4,769,810 3,284,606 3,608,823 3,887,918 4,308,577 3,910,749 Interest 2,197,655 2,014,287 1,624,140 911,869 773,379 1,162,050 1,486,112 1,448,514 1,588,937 1,361,443 Other 14,155 106,851 144,951 26,151 73,162 154,805 38,908 55,872 118,782 44,075 Total expenditures 39,415,332 51,961,308 43,438,053 46,651,771 56,107,740 51,385,899 67,557,067 59,544,889 53,876,650 50,947,447 Excess(deficiency)of revenues over(under)expenditures 2,959,175 (5,274,518) 1,906,036 (2,561,723) (12,810,062) (1,311,710) (14,755,150) (7,168,749) (4,681,468) (2,464,254) Other financing sources(uses) 3,263,898 8,885,580 (1,204,376) 2,776,627 11,671,568 13,309,047 2,960,721 8,438,632 3,574,375 2,967,231 Net change in fund balance $ 6,223,073 $ 3,611,062 $ 701,660 $ 214,904 $ (1,138,494)$ 11,997,337 $ (11,794,429)$ 1,269,883 $ (1,107,093)$ 502,977 Debt service as a%of noncapital expenditures 24.1% 30.4% 16.8% 13.1% 13.8% 11.3% 11.7% 11.3% 12.5% 11.2% 114 City of Eden Prairie , Minnesota Assessed/Tax Capacity Value and Estimated Market Value of Property Last Ten Years Tax Capacity Tax Tax Capacity Less: Less: Total Total Estimated Annual Payable Personal Commercial Farm& Before Fiscal Tax Assessed Direct Market % Dec.31 Property Residential Apartments &Industrial Other Deductions Disparities Increment Value Tax Rate Value Change 2001 1,572,529 49,101,337 5,736,074 42,390,927 1,688,914 100,489,781 15,076,891 259,237 85,153,653 27.152 5,172,050,100 13.3% 2002 1,012,303 39,052,891 4,891,636 27,869,108 1,338,591 74,164,529 10,134,643 261,957 63,767,929 37.611 5,818,738,000 12.5% 2003 1,026,330 44,591,407 4,590,598 28,284,563 1,245,457 79,738,355 11,193,583 1,070,532 67,474,240 35.192 6,496,639,500 11.7% 2004 1,046,857 51,646,689 4,657,705 27,952,129 1,306,580 86,609,960 11,393,809 1,124,059 74,092,092 32.945 7,188,472,300 10.6% 2005 1,159,659 58,891,623 5,435,153 28,630,702 1,284,443 95,401,580 11,355,915 2,181,143 81,864,522 30.601 7,755,652,600 7.9% 2006 1,202,194 65,779,883 5,700,405 30,783,022 1,187,555 104,653,059 11,557,916 2,396,480 90,698,663 28.782 8,593,444,425 10.8% 2007 1,316,149 71,553,209 6,443,883 35,401,780 1,005,179 115,720,200 12,573,128 2,804,557 100,342,515 28.050 9,439,037,100 9.8% 2008 1,282,145 76,169,571 6,657,437 39,973,888 53,761 124,136,802 14,480,546 3,145,493 106,510,763 27.177 9,961,912,400 5.5% 2009 1,262,207 76,242,150 6,418,903 41,524,663 58,691 125,506,614 16,186,185 3,239,713 106,080,716 27.271 10,019,575,800 0.6% 2010 1,250,594 72,344,688 5,912,957 40,911,206 63,679 120,483,124 16,806,832 3,274,193 100,402,099 28.742 9,577,402,500 -4.4% Percentages 2001 1.6% 48.9% 5.7% 42.2% 1.7% 17.7% 0.3% 2002 1.4% 52.7% 6.6% 37.6% 1.8% 15.9% 0.4% 2003 1.3% 55.9% 5.8% 35.5% 1.6% 16.6% 1.6% 2004 1.2% 59.6% 5.4% 32.3% 1.5% 15.4% 1.5% 2005 1.2% 61.7% 5.7% 30.0% 1.3% 13.9% 2.7% 2006 1.1% 62.9% 5.4% 29.4% 1.1% 12.7% 2.6% 2007 1.1% 61.8% 5.6% 30.6% 0.9% 12.5% 2.8% 2008 1.0% 61.4% 5.4% 32.2% 0.0% 13.6% 3.0% 2009 1.0% 60.7% 5.1% 33.1% 0.0% 15.3% 3.1% 2010 1.0% 60.0% 4.9% 34.0% 0.1% 16.7% 3.3% Source:City Assessing Department and Hennepin County 115 City of Eden Prairie , Minnesota Direct and Overlapping Property Tax Rate Last Ten Years Tax Capacity Rates Direct Rates Overlapping Rates Year School School School Watershed Watershed Watershed Ended City HRA Hennepin Special District District District District District District Dec.31 Rate Rate County Districts(1) #270 #272 #276 #1 #2 #4 2001 2 27.152 - 37.624 4.249 44.220 48.227 47.155 0.641 0.202 0.946 2002 37.611 - 50.409 7.386 15.034 15.71 20.868 1.317 0.469 1.608 2003 35.192 - 50.607 7.757 20.588 18.957 24.215 1.267 0.418 1.616 2004 32.945 - 47.324 7.488 22.203 16.933 23.125 1.269 0.381 0.732 2005 30.601 - 44.172 7.382 19.176 21.855 21.989 1.165 0.354 1.375 2006 28.561 0.221 41.016 6.998 21.565 23.187 22.952 1.106 0.315 0.787 2007 27.861 0.189 39.110 7.480 19.019 23.727 24.793 1.107 0.291 0.743 2008 26.998 0.179 38.571 7.397 19.218 23.425 17.98 1.149 0.432 1.302 2009 27.092 0.179 40.413 7.154 20.080 24.691 17.186 1.246 0.936 1.246 2010 28.553 0.189 42.640 8.138 23.050 25.959 18.657 1.293 0.520 1.279 Market Value Rates Overlapping Rates Year City School School School Ended Direct District District District Dec.31 Rate #270 #272 #276 2001 0.0181 0.181 0.212 0.120 2002 0.0194 0.194 0.116 0.110 2003 0.0177 0.177 0.157 0.100 2004 0.0158 0.158 0.144 0.080 2005 0.0143 0.143 0.133 0.080 2006 0.0177 0.151 0.173 0.177 2007 0.0183 0.141 0.156 0.165 2008 0.0172 0.138 0.146 0.203 2009 0.0171 0.130 0.145 0.202 2010 0.0173 0.139 0.157 0.202 (1) Special Districts include Metropolitan Council, Regional Transit Board,Metropolitan Mosquito Control, County Park Museum, &Hennepin Suburban Parks (2) 1999-2001 City rates include Local Transit Rates 116 City of Eden Prairie , Minnesota Principal Property Taxpayers For the Year Ended December 31 , 2010 and 2001 2010 2001 Percentage Percentage Tax of Total Tax of Total Taxpayer Capacity Tax Capacity Taxpayer Capacity Tax Capacity Eden Prairie Mall, LLC $ 2,399,250 2.0% Liberty Property Ltd Partnership $ 2,798,901 2.8% ADC Telecommunications, Inc 959,250 0.8% First Industrial Ltd Partnership 1,408,304 1.4% Geneva Office Exchange LLC 719,810 0.6% Best Buy Company 1,339,574 1.3% Lifetouch, Inc. 699,250 0.6% 11095 Viking Inc. 1,107,138 1.1% Liberty Property Ltd Partnership 639,250 0.5% Gelco Corporation (GE Capital) 847,140 0.8% DCX Flying Cloud Drive DST 519,910 0.4% Ryan /Wilson Ltd. Partnership 829,256 0.8% Flying Cloud Office Inc. 499,250 0.4% MSP Investors I, LLC 801,988 0.8% United Healthcare Serv. Inc 483,530 0.4% ADC Telecommunications, Inc. 638,550 0.6% EP-MN LLC 472,390 0.4% Lifetouch Inc. 574,841 0.6% IRET-MR9, LLC 471,110 0.4% Supervalu Inc. 535,142 0.5% Total principal taxpayers 7,863,000 6.5% 10,880,834 10.8% All other taxpayers 112,620,124 93.5% 89,608,947 89.2% Total $ 120,483,124 100.0% $ 100,489,781 100.0% Source: City of Eden Prairie Assessing Department 117 City of Eden Prairie , Minnesota Property Tax Levies and Collections Last Ten Years Collected Within the Year Current Year Levy Collections Total Collections to Date Ended Taxes %of in Subsequent %of Dec.31 Levied Amount Levy Years Amount Levy 2001 $ 22,130,324 $ 22,007,084 99.44% $ 119,191 $ 22,126,275 99.98% 2002 25,029,367 24,825,795 99.19% 181,212 25,007,007 99.91% 2003 24,653,827 24,611,527 99.83% 42,000 24,653,527 100.00% 2004 25,195,881 25,008,820 99.26% 187,646 25,196,466 100.00% 2005 26,132,057 26,072,924 99.77% 59,503 26,132,427 100.00% 2006 28,468,831 28,242,002 99.20% 226,142 28,468,144 100.00% 2007 30,657,304 30,422,094 99.23% 235,386 30,657,480 100.00% 2008 31,514,657 31,263,472 99.20% 222,443 31,485,915 99.91% 2009 31,773,143 31,278,850 98.44% 275,441 31,554,291 99.31% 2010 31,719,631 31,299,275 98.67% - 31,299,275 98.67% Source: Hennepin County 2001 and 2002 taxes levied includes Market Value Homestead Credit 118 City of Eden Prairie , Minnesota Legal Debt Margin Last Ten Years 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Estimated Market Value $ 5,172,050,100 $ 5,818,738,000 $ 6,496,639,500 $ 7,188,472,300 $ 7,755,652,600 $ 8,593,444,425 $ 9,439,037,100 $ 9,961,912,400 $ 10,019,575,800 $ 9,577,402,500 Legal Debt Margin: Debt Limit:3%of Market Value(1) $ 103,441,002 $ 116,374,760 $ 129,932,790 $ 143,769,446 $ 155,113,052 $ 171,868,889 $ 188,780,742 $ 298,857,372 $ 300,587,274 $ 287,322,075 General Obligation Bonds 7,295,000 7,660,000 8,321,000 7,141,000 10,852,000 23,407,000 21,881,000 23,369,000 25,300,000 23,070,000 Deductions: Amt available for repayment ofbonds 194,878 169,484 201,522 282,448 350,814 1,145,695 1,585,677 1,825,816 2,288,121 2,317,257 Total debt applicable to limit 7,100,122 7,490,516 8,119,478 6,858,552 10,501,186 22,261,305 20,295,323 21,543,184 23,011,879 20,752,743 Legal debt Margin 96,340,880 108,884,244 121,813,312 136,910,894 144,611,866 149,607,584 168,485,419 277,314,188 277,575,395 266,569,332 As a%of debt limit 93.1% 93.6% 93.8% 95.2% 93.2% 87.0% 89.2% 92.8% 92.3% 92.8% 1-In 2008 debt limit was changed from 2%to 3% 119 City of Eden Prairie , Minnesota Ratios of Outstanding Debt by Type Last Ten Years Business-Type Governmental Activities Activities Special Year General Lease Assessments Percentage Ended Obligation Revenue Improvement Contract Capital Loans Revenue of Personal Per Dec.31 Bonds Bonds Bonds for Deed Lease Payable Bonds Total Income( 1) Capita(2) 2001 $ 7,295,000 $ 14,325,000 $ 4,285,000 $ - $ - $ 108,265 $ 17,463,123 $ 43,476,388 * 756 2002 7,660,000 19,590,000 3,540,000 500,000 - 64,167 11,966,889 43,321,056 * 737 2003 8,321,000 10,935,000 6,770,000 300,000 - 27,138 11,083,516 37,436,654 * 614 2004 7,141,000 10,085,000 6,200,000 200,000 - 12,589 9,914,891 33,553,480 * 536 2005 10,852,000 9,170,000 8,740,000 100,000 - 6,779 8,209,771 37,078,550 * 579 2006 23,407,000 8,195,000 7,790,000 - 142,773 968 5,648,261 45,184,002 * 706 2007 21,881,000 8,790,000 6,770,000 - 115,918 - 2,879,983 40,436,901 * 620 2008 23,369,000 7,695,000 7,570,000 - 123,076 - - 38,757,076 * 619 2009 25,300,000 4,845,000 6,400,000 - 83,500 - - 36,628,500 * 579 2010 23,070,000 3,795,000 7,000,000 - 42,751 - - 33,907,751 * 541 (1) See Demographic and Economic Statistics for personal income (2) See Demographic and Economic Statistics for population *Information is not available 120 City of Eden Prairie , Minnesota Ratios of Total Debt by Type Last Ten Years Ratio of Net Year General Less Amounts Bonded Debt Ended Obligation Available in Debt to Estimated Per Dec.31 Debt(1) Service Fund Total Market Value(2) Capita(3) 2001 $ 7,295,000 $ 194,878 $ 7,100,122 0.14% 123 2002 7,660,000 169,484 7,490,516 0.13% 127 2003 8,321,000 201,522 8,119,478 0.12% 133 2004 7,141,000 282,448 6,858,552 0.10% 110 2005 10,852,000 350,814 10,501,186 0.14% 164 2006 23,407,000 (4) 1,145,695 22,261,305 0.26% 343 2007 21,881,000 1,585,677 20,295,323 0.22% 311 2008 23,369,000 1,825,816 21,543,184 0.23% 344 2009 25,300,000 2,288,121 23,011,879 0.23% 363 2010 23,070,000 2,317,257 20,752,743 0.22% 331 (1) Amount does not include special assessment improvement or revenue bonds. (2) See "Taxable Assessed Value and Estimated Actual Value of Property" for Market Value (3) See Demographic and Economic Statistics for population (4) 2006 includes $8.4 million in debt for the park referendum 121 City of Eden Prairie, Minnesota Computation of Direct and Overlapping Bonded Debt-G. O. Bonds December 31, 2010 Percent Debt of Debt Net Debt Gross Service Net Applicable Applicable Governmental Unit Debt(1) Funds Debt to City to City Direct Debt: City of Eden Prairie $ 23,070,000 $ 2,317,257 $ 20,752,743 100.00% $ 20,752,743 Overlapping Debt: Hennepin County $ 690,350,000 6,415,500 $ 683,934,500 6.99% $ 47,807,022 School Dist#272 81,965,000 12,118,378 69,846,622 97.87% 68,358,889 School Dist#270 160,660,000 2,618,418 158,041,582 3.91% 6,179,426 School Dist#276 106,149,548 19,384,866 86,764,682 2.69% 2,333,970 Henn Suburban Park District 78,780,000 11,149,935 67,630,065 9.38% 6,343,700 Henn Regional RR Authority 41,865,000 2,294,222 39,570,778 6.99% 2,765,997 Metropolitan Council 245,200,000 64,121,097 181,078,903 3.19% 5,776,417 Total Overlapping Debt 1,404,969,548 118,102,416 1,286,867,132 139,565,421 Total Direct and Overlapping Debt $ 1,428,039,548 $ 120,419,673 $ 1,307,619,875 $ 160,318,164 Notes: (1) Gross debt does not include special assessment improvement or revenue bonds. 122 City of Eden Prairie , Minnesota Demographic and Economic Statistics Last Ten Years Governmental Activities (thousands of dollars) Per Personal Capita Median School Unemployment Year Population Income Income Age Enrollment Rate 2001 57,513 $ * $ * * 10,508 1.9% 2002 58,973 * * * 10,400 2.9% 2003 60,931 * * * 10,360 3.5% 2004 62,603 * * * 10,360 3.6% 2005 64,032 * * * 9,955 3.5% 2006 64,846 * * * 9,771 4.0% 2007 65,257 * * * 9,806 4.6% 2008 62,210 1 * * * 9,806 6.9% 2009 63,314 * * * 10,200 7.4% 2010 62,683 * * * 9,628 7.0% Sources: City of Eden Prairie Planning Department Minnesota Department of Trade and Economic Development "Community Profile" Minnesota Local Area Unemployment Statistics File Minnesota Workforce Center Eden Prairie School District 272 - Enrollment History Website * - Data is not available 1 - Starting in 2008, using Met Council numbers 123 City of Eden Prairie, Minnesota Principal Employers For the Year Ended December 31, 2010 2010 Percentage of Total Employer Employees City Employment Eden Prairie School District #272 1,700 3.1% Starkey Labs 1,500 2.7% Super Valu Stores 1,500 2.7% CH Robinson 1,348 2.5% Ingenix 1,000 1.8% Deli Express 855 1.6% Kroll On-Track 808 1.5% MTS Systems Corp 700 1.3% GE Capital Fleet Services 673 1.2% Digital River Inc. 662 1.2% Total principal employer 10,746 19.5% Other employers 44,254 80.5% Total employers 55,000 100.0% Source: City Community Development Division Data from 9 years ago was not available 124 City of Eden Prairie, Minnesota Employees by Function Last Seven Years 2004 2005 2006 2007 2008 2009 2010 Governmental Funds: Administration City Manager City Manager 1 1 1 1 1 1 1 Assistant to the City Manager 1 1 1 1 1 Administrative Assistant 1 1 1 1 1 1 1 Total 3 3 3 3 3 2 2 City Clerk City Clerk 1 1 1 1 1 1 1 Total 1 1 1 1 1 1 1 Communication Services Communications Manager 1 1 1 1 1 1 1 Sr.Communications Coordinator 1 1 1 1 Communications Coordinator 1 1 1 1 1 1 1 Technician II 1 1 1 Total 3 3 3 3 3 3 3 Finance Finance Manager 1 1 1 1 1 1 1 Finance Supervisor 1 1 1 1 1 Senior Accountant 1 1 Accountant 1 1.50 1.50 1.50 1.50 1.50 1.50 Accounts Payable Technician I 1 1 1 1 1 1 1 Senior Accounting Clerk 1 1 1 1 1 Payroll Technician III 1 1 1 1 1 1 Technician I 1 1 1 1 1 1 1 Total 7 7.50 7.50 7.50 7.50 6.50 5.50 Source:Human Resource department Less than ten years is presented due to information not available. 125 City of Eden Prairie, Minnesota Employees by Function Last Seven Years 2004 2005 2006 2007 2008 2009 2010 Governmental Funds: Customer Service Customer Service/Office 4 4 3.80 4.05 4.05 4.05 4.05 Total 4.0 4.0 3.8 4.05 4.05 4.05 4.05 Human Resources Human Resources Manager 1 1 1 1 1 1 1 Senior Human Resources Generalist 1 1 1 1 1 1 1 Human Resources Technician III 1 1 1 1 0.60 0.60 0.60 Organization Development Specialist 0.50 0.50 0.60 1 Administration Assistant I 1 1 0.75 0.75 1 1 1 Payroll Technician III 1 Total 4 4 4.25 4.25 4.20 4.60 4.60 Community Development Assessing City Assessor 1 1 1 1 1 1 1 Appraiser 5 5 5 5 5 5 5 Technician I 1 1 1 1 1 1 1 Total 7 7 7 7 7 7 7 Planning Planning City Planner 1 1 1 1 1 1 1 Senior Planner 1 1 1 1 1 1 1 Planner 1.65 1.65 1.65 1.65 2.15 1.5 1.5 Heritage Preservation Specialist 1 1 1 1 0.50 Administrative Assistant I 1 1 1 1 1 1 1 Total 5.65 5.65 5.65 5.65 5.65 4.5 4.5 Community Development Community Development Director 1 1 1 1 1 0.9 0.9 Administrative Assistant II 1 1 1 1 1 Total 2 2 2 2 2 0.9 0.9 Economic Development Manager of Economic Development 1 1 1 1 1 1 1 Total 1 1 1 1 1 1 1 Source:Human Resource department Less than ten years is presented due to information not available. 126 City of Eden Prairie, Minnesota Employees by Function Last Seven Years 2004 2005 2006 2007 2008 2009 2010 Governmental Funds: Housing and Community Services Manager of Housing&Community Sry 1 1 1 1 1 1 1 Community Services Coordinator 1 1 0.5 0.5 0.5 Community Services Technician 1 1 1 1 1 0.5 0.5 Total 2 2 3 3 2.5 2 2 Parks and Recreation Park Administration Park and Recreation Director 1 1 1 1 1 1 1 Administrative Assistant 11 1 1 1 1 1 1 1 Total 2 2 2 2 2 2 2 Park&Natural Resources Manager of Parks and Natural Resource 1 1 1 1 1 1 1 Forestry Technician 1 1 1 1 1 1 1 Supervisor of Park Maintenance 1 1 1 1 1 1 1 Supervisor Park Construction/Repair 1 1 1 1 1 1 1 Maintenance Worker Parks 15 16 16 16 16 16 16 Total 19 20 20 20 20 20 20 Recreation Programming Manager of Recreation 1 1 1 1 1 1 1 Recreation Coordinator 4 4 4 4 4 3.5 3.5 Outdoor Center/Nature Programmer 1 1 1 1 1 1 1 Total 6 6 6 6 6 5.5 5.5 Community Center Recreation Coordinator 1 2 2 2 2 2 2 Office Supervisor 1 1 Community Center Manager 1 1 1 1 1 Customer Service/Office Assistant 3 2 2 2.5 2.5 2.5 2.5 Total 5 5 5 5.5 5.5 5.5 5.5 Art Center Manager-Art Center 0.5 0.5 0.5 Total 0 0 0 0 0.5 0.5 0.5 Source:Human Resource department Less than ten years is presented due to information not available. 127 City of Eden Prairie, Minnesota Employees by Function Last Seven Years 2004 2005 2006 2007 2008 2009 2010 Governmental Funds: Senior Center Manager- Community Center Recreation Coordinator 2 1 1 1 1 1 1 Administrative Assistant I 1 1 1 1 1 1 1 Total 3 2 2 2 2 2 2 Police Police Police Chief 1 1 1 1 1 1 1 Deputy Police Chief 1 1 1 1 1 1 1 Lieutentants 3 4 4 3 3 3 3 Sergeants 12 12 12 12 12 12 12 Police Officers 47 46 47 48 49 48 48 Animal Control Officer 2 2 2 2 2 2 2 Telecommunications Supervisor 1 1 1 1 1 1 1 Telecommunicators 9.50 9.50 9.50 9.50 10 10 10 Records Supervisor 1 1 1 1 1 1 1 Records Tech 6.75 6.75 6.75 6.75 6.75 6.75 6.75 Investigative Aide 1 1 1 1 1 1 1 Administrative Assistant 1 1 1 1 1 1 1 Customer Service/Office Assistant 1 1 1 1 1 1 1 Law Enforcement Analyst 1 1 1 1 Projects Coordinator 0.60 0.60 0.60 0.60 0.60 0.60 0.60 Zoning Administrator 0.80 0.80 0.80 1 1 1 1 Total 88.65 88.65 89.65 90.85 92.35 91.35 91.35 Fire Fire Fire Chief 1 1 1 1 1 1 1 Assistant Fire Chief 0.50 1 1 1 1 Fire Marshal 1 1 1 1 1 0.8 0.8 Fire Prevention Specialist 3 3 3 3 3 3 3 Rental Housing Inspector 1 1 1 1 1 Electronic Communications Specialist 1 1 1 1 1 1 1 Administrative Assistant 11 1 1 1 1 1 1 1 Total 7 7 8.50 9 9 8.8 8.8 Source:Human Resource department Less than ten years is presented due to information not available. 128 City of Eden Prairie, Minnesota Employees by Function Last Seven Years 2004 2005 2006 2007 2008 2009 2010 Governmental Funds: Inspections Manager of Building Inspections 1 1 1 1 1 1 1 Building Inspectors II 7 7 7 7 7 6 6 Technician I 2 2 2 2 2 2 2 Technician 11 1 1 1 1 1 Total 11 11 11 11 11 9 9 Public Works Engineering Public Works Director 0.8 0.8 0.8 0.8 0.8 0.8 0.8 City Engineer 1 1 1 1 1 1 1 Assistant City Engineer 1 1 1 1 1 1 1 Engineering Technician I 1 1 1 1 1 1 1 Engineering Technician II 1 1 1 1 1 Senior Project Engineer 1 1 1 1 1 1 1 Senior Traffic Engineer 1 1 1 1 1 Engineering Project Coordinator 1 1 1 1 1 1 Senior Engineering Tech 3.5 3.5 3.5 3.5 3.5 3.5 3.5 Administrative Assistant II 1 1 1 1 1 Total 12.3 12.3 12.3 12.3 12.3 9.3 8.3 Streets&Traffic Manager of Street Maintenance 1 1 1 1 1 1 1 Maintenance Workers 14 14 14 14 14 13 13 Administrative Assistant I 1 1 1 1 1 1 1 Total 16 16 16 16 16 15 15 Total Governmental Funds Administration 22.00 22.50 22.55 22.80 22.75 21.15 20.15 Community Development 17.65 17.65 18.65 18.65 18.15 15.40 15.40 Parks&Recreation 35.00 35.00 35.00 35.50 36.00 35.50 35.50 Police 88.65 88.65 89.65 90.85 92.35 91.35 91.35 Fire 18.00 18.00 19.50 20.00 20.00 17.80 17.80 Public Works 28.30 28.30 28.30 28.30 28.30 24.30 23.30 Total 209.60 210.10 213.65 216.10 217.55 205.50 203.50 Source:Human Resource department Less than ten years is presented due to information not available. 129 City of Eden Prairie, Minnesota Employees by Function Last Seven Years 2004 2005 2006 2007 2008 2009 2010 Enterprise Funds: Liquor Liquor Operations Manager 1 1 1 1 1 1 1 Managers 2 2 2 2 2 2 2 Assistant Manager 3 3 3 3 3 3 3 Senior Assistant Manager 1 1 1 1 1 1 1 Inventory Control Clerk 1 1 1 1 1 1 1 8 8 8 8 8 8 8 Utilities Public Works Director 0.2 0.2 0.2 0.2 0.2 0.2 0.2 Manager of Utilities 1 1 1 1 1 1 1 Water Treatment Supervisor 1 1 1 1 1 Water Treatment Lead 1 1 1 Water Treatment Maintenance Lead 1 1 1 1 1 Water Treatment Operators 11 11 8 8 8 8 8 Utility Field Operations Supervisor 2 1 1 1 1 1 1 Utility Field Operations Lead 1 2 1 1 1 1 1 Water Treatment Maintenance Technician 2 2 2 2 2 2 2 Utility Field Operators 8 8 11 11 11 11 11 Projects Coordinator 1 Utility Operations Project Manager 1 1 1 1 Storm Utility Maintenance Operator 1 1 1 1 Administrative Assistant 1 1 1 1 1 1 1 Technician 11 1 1 1 1 1 1 1 Customer Service/Office Assistant 1 1 1 1 1 1 1 Environmental Coordinator 1 1 1 1 1 1 1 Senior Engineering Tech 0.5 0.5 0.5 0.5 0.5 0.5 0.5 29.7 30.7 31.7 32.7 33.7 32.7 33.7 Source:Human Resource department Less than ten years is presented due to information not available. 130 City of Eden Prairie, Minnesota Employees by Function Last Seven Years 2004 2005 2006 2007 2008 2009 2010 Internal Service Funds: Workers Compensation Manager of Support Services 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Total 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Property Insurance Manager of Support Services 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Total 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Fleet Services Public Works Superintendent 1 1 1 1 1 1 1 Maintenance Worker 6 6 6 6 5 5 5 Total 7 7 7 7 6 6 6 Facilities Facilities Manager 1 1 1 1 1 1 1 Facilities Supervisor 2 2 2 2 2 2 2 Facilities Engineer 2 2 2 2 3 3 3 Facilities Technician 2 2 2 2 2 2 2 Technician I 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Total 7.5 7.5 7.5 7.5 8.5 8.5 8.5 Information Technology Information Technology Manager 1 1 1 1 1 1 1 Technology Analyst/Developer 1 1 1 1 1 1 1 IT Specialist 1 1 1 1 2 2 2 GIS Specialist 1 1 1 IT Technician 2 2 2 2 2 2 2 Technician I 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Total 5.5 5.5 5.5 5.5 7.5 7.5 7.5 Grand Total 268.30 269.80 274.35 277.80 282.25 269.20 268.20 131 City of Eden Prairie , Minnesota Operating Indicators Last Ten Years 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 General Government: Bond rating Aal Aal Aaa Aaa Aaa Aaa Aaa Aaa Aaa Aaa Housing and Human Services: Number of residents served 2,445 2,645 2,750 3,000 2,500 2,500 2,500 3,000 3,000 3,100 Assessing: Number of appraisals completed 6,449 6,458 6,526 6,000 5,300 5,300 5,300 5,643 5,276 5,517 Parks and recreation: Avg monthly community center membe n/a n/a n/a n/a n/a n/a n/a 843 1,751 2,100 Program registrations 11,181 10,741 10,642 12,173 12,751 14,027 15,281 15,844 15,689 16,213 Public Safety: Fire: Number of calls 1,191 880 886 908 975 888 1,011 1,233 1,247 1,633 Inspection permits issued 8,098 7,582 7,253 7,000 7,090 6,590 7,042 6,157 5,225 6,446 Police: Number of calls 42,403 45,122 45,209 52,554 54,622 47,190 52,543 54,483 59,470 52,041 Public Works: Patching materials(tons) n/a n/a n/a 2,200 2,300 2,500 2,500 1,900 2,500 2,800 Overlays(tons) 12,500 16,140 17,140 17,640 18,140 26,027 19,900 24,600 31,800 26,300 Crack filling materials(lbs) 140,000 140,000 140,000 140,000 140,000 200,000 200,000 112,000 200,000 200,000 Seal coating(sq yards) 520,000 520,000 520,000 520,000 520,000 402,258 360,535 324,000 427,000 392,000 Water System: Number of connections 16,679 17,029 17,370 17,717 18,271 18,607 18,745 18,794 18,800 18,948 Water main repairs n/a n/a n/a n/a n/a 15 153 35 28 41 Number of hydrant flushed n/a n/a 3,899 3,980 3,960 4,062 3,998 4,122 4,234 4,224 Average daily usage 8.07 MGD 7.3 MGD 8.5 MGD 8.0 MGD 8.0 MGD 8.0 MGD 8.0 MGD 8.0 MGD 9.0 MGD 7.7 MGD Sewer System: Number of connections 16,188 16,555 16,950 17,391 17,971 18,307 18,445 18,557 18,600 18,355 Miles of sanitary sewer cleaned 101 79 85 94 94 60 65 50 75 80 Storm System: Number of storm sumps maintained 130 146 143 188 154 138 63 157 101 93 Sources:Various city departments MGD-Million Gallons Daily N/A-Not available 132 City of Eden Prairie , Minnesota Capital Assets Statistics by Function Last Ten Years 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Public Safety: Fire Protection: Number of stations 3 3 3 3 3 4 4 4 4 4 Number of volunteer firefighters 72 77 75 74 72 79 95 95 95 96 Police Protection: Number of stations 1 1 1 1 1 1 1 1 1 1 Public Works: Miles of city streets N/A 217 221 222 224 225 225 232 231 229 Parks and Recreation: City parks 36 37 43 43 43 43 43 43 43 43 Conservation areas 15 15 15 15 15 5 15 15 15 15 Historic sites 5 5 5 5 5 5 5 5 5 5 Special use areas 5 5 5 5 5 5 5 5 5 5 Miles of trails 71 80 90 90 90 110 112 112 114 114 Water System: Number of wells 13 13 13 13 14 14 14 14 15 15 Total pumping capacity 19 MGD 19 MGD 22 MGD 22 MGD 22 MGD 22 MGD 22 MGD 22 MGD 22 MGD 24 MGD Total storage capacity 8.5M gals 8.5M gals 8.5M gals 8.5M gals 8.5M gals 8.5M gals 8.5M gals 8.5M gals 8.5M gals 8.5M gals Miles of water mains 241 248 255 259 261 264 265 265 268 269 Sewer System: Miles of sanitary sewer 219 224 233 236 237 241 242 242 244 244 Miles ofstorm sewer 144 150 154 159 162 166 168 168 171 172 Sources:Various city departments Note:No capital asset indicators are available for the general government functions. MGD-Million Gallons Daily N/A-Not available 133 CITY OF EDEN PRAIRIE Hennepin County,Minnesota MANAGEMENT LETTER For the Fiscal Year Ended December 31,2010 CITY OF EDEN PRAIRIE TABLE OF CONTENTS REPORT ON MATTERS IDENTIFIED AS A RESULT OF THE AUDIT OF THE FINANCIAL STATEMENTS............................................................... I RECOMMENDATION FOR MANAGEMENT .......................................................................... 3 REQUIRED COMMUNICATION................................................................................................ 4 FINANCIAL ANALYSIS................................................................................................................ 7 Expert advice. When you need it.s' REPORT ON MATTERS IDENTIFIED AS A RESULT OF THE AUDIT OF THE FINANCIAL STATEMENTS Honorable Mayor of Members of the City Council City of Eden Prairie Eden Prairie, Minnesota In planning and performing our audit of the financial statements of the City of Eden Prairie, Minnesota, as of and for the year ended December 31, 2010, in accordance with U.S. generally accepted auditing standards and Government Auditing Standards, we considered the City's internal control over financial reporting (internal control) as a basis for designing our auditing procedures for the purpose of expressing our opinion on the financial statements,but not for the purpose of expressing an opinion on the effectiveness of the City's internal control. Accordingly,we do not express an opinion on the effectiveness of the City's internal control. Our consideration of internal control was for the limited purpose described in the preceding paragraph and would not necessarily identify all deficiencies in internal control that might be significant deficiencies or material weaknesses and, therefore, there can be no assurance that all deficiencies, significant deficiencies or material weaknesses have been identified. Material weaknesses and significant deficiencies identified, if any, are stated within this letter. 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 City's financial statements will not be prevented or detected and corrected on a timely basis. A significant deficiency is a deficiency, or combination of deficiencies, in internal control that is less severe than a material weakness,yet important enough to merit attention by those charged with governance. The accompanying memorandum includes financial analysis and recommendations for improvement of accounting procedures and internal control measures that came to our attention as a result of our audit of the financial statements of the City for the year ended December 31, 2010. The matters discussed herein were considered by us during our audit and they do not modify the opinion expressed in our Independent Auditor's Report dated April 29, 2011, on such statements. 1 YskD6N This communication is intended solely for the information and use of management, the City Council, others within the City and state oversight agencies and is not intended to be and should not be used by anyone other than these specified parties. KERN, DEWENTER, VIERS, LTD. St. Cloud, Minnesota April 29, 2011 2 CITY OF EDEN PRAIRIE RECOMMENDATION FOR MANAGEMENT December 31,2010 CONSIDER THE IMPLICATIONS OF GOVERNMENTAL ACCOUNTING STANDARDS BOARD (GASB) STATEMENT NO. 54,FUND BALANCE REPORTING AND GOVERNMENTAL FUND TYPE DEFINITIONS Governmental Accounting Standards Board(GASB) Statement No. 54 was enacted to enhance the usefulness of fund balance information by providing clearer fund balance classifications that can be more consistently applied and by clarifying the existing governmental fund type definitions. The initial distinction that is made in reporting fund balance information is identifying amounts that are considered nonspendable, such as fund balance associated with inventories or prepaid expenses. This Statement also provides for additional classification as restricted, committed, assigned and unassigned based on the relative strength of the constraints that control how specific amounts can be spent. The restricted fund balance category includes amounts that can be spent only for the specific purposes stipulated by constitution, external resource providers or through enabling legislation. The committed fund balance classification includes amounts that can be used only for the specific purposes determined by a formal action of the government's highest level of decision-making authority. Amounts in the assigned fund balance classification are intended to be used by the government for specific purposes but do not meet the criteria to be classified as restricted or committed. In governmental funds other than the general fluid, assigned fund balance represents the remaining amount that is not restricted or committed, unless that is a negative balance. Unassigned fund balance is the residual classification for the government's general fund and includes all spendable amounts not contained in the other classifications. In other fiinds,the unassigned classification should be used only to report a deficit balance resulting from overspending for specific purposes for which amounts have been restricted, committed or assigned. Governments are allowed to have stabilization amounts which are formally set aside for use in emergency situations or when revenue shortages or budgetary imbalances arise. These fiuids must be restricted or committed for a specific purpose and cannot occur routinely. Governments are required to have a fund balance policy which addresses a reasonable minimum level of unassigned fund balance to be maintained,how the unassigned fund balance can be used or spent down and how that fund balance will be replenished if it falls below the minimum level. Elimination of the reserved component of fund balance in favor of a restricted classification will enhance the consistency between information reported in the government-wide statements and information in the government fiend financial statements and avoid confusion about the relationship between the reserved fund balance and restricted net assets. The Statement is also designed to enhance the usefulness of fund balance information by clarifying the definitions of governmental fund types. For example, special revenue funds are created only to report a revenue source that is restricted or committed to a specified purpose, and that revenue source should constitute a substantial portion of the resources reported in the fund. In addition,the definition of the capital project fund type has been clarified to focus on the broader,more consistent understanding of capital outlays and capital activities in today's environment. This Statement is effective for the year ending December 31, 2011. Fund balance reclassifications made to conform to the provisions of this Statement should be applied retroactively by restating fund balance for all prior periods presented. 3 CITY OF EDEN PRAIRIE REQUIRED COMMUNICATION December 31,2010 We have audited the financial statements of the City for the year ended December 31,2010, and have issued our report dated April 29, 2011. Professional standards require that we provide you with the following information related to our audit. OUR RESPONSIBILITY UNDER U.S. GENERALLY ACCEPTED AUDITING STANDARDS, GOVERNMENT A UDITING STANDARDS AND OMB CIRCULAR A-133 As stated in our engagement letter, our responsibility, as described by professional standards, is to express an opinion about whether the financial statements prepared by management with your oversight are fairly presented, in all material respects, in conformity with U.S. generally accepted accounting principles. Our audit of the financial statements does not relieve you or management of your responsibilities. Our responsibility is to plan and perform our 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 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. 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. As part of obtaining reasonable assurance about whether the City's financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws,regulations, contracts and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However,providing an opinion on compliance with those provisions was not an objective of our audit. We also considered internal control over compliance with requirements that could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance and to test and report on internal control over compliance in accordance with U.S. Office of Management and Budget(OMB) Circular A-133. Also, in accordance with OMB Circular A-133, we examined, on a test basis, evidence about the City's compliance with the types of compliance requirements described in the OMB Circular A-133 Compliance Supplement applicable to its major federal program for the purpose of expressing an opinion on the City's compliance with those requirements. While our audit provides a reasonable basis for our opinion,it does not provide a legal determination on the City's compliance with those requirements. PLANNED SCOPE AND TIMING OF THE AUDIT We performed the audit according to the planned scope and timing previously communicated to you. 4 CITY OF EDEN PRAIRIE REQUIRED COMMUNICATION December 31, 2010 QUALITATIVE ASPECTS OF ACCOUNTING PRACTICES Management is responsible for the selection and use of appropriate accounting policies. In accordance with the terms of our engagement letter, we will advise management about the appropriateness of accounting policies and their application. The significant accounting policies used by the City are described in Note 1 to the financial statements. During 2010, the City implemented GASB Statement No. 51,Accounting and Financial Reporting for Intangible Assets. We noted no transactions entered into during the year for which there is a lack of authoritative guidance or consensus. There are no significant transactions that have been recognized in the financial statements in a different period than when the transaction occurred. 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 significant estimate affecting the financial statements was: Depreciation—The City is currently depreciating its capital assets over their estimated useful lives, as determined by management,using the straight-line method. We evaluated the key factors and assumptions used to develop the above estimate in determining it is reasonable in relation to the financial statements taken as a whole. The disclosures in the financial statements are neutral, consistent and clear. DIFFICULTIES ENCOUNTERED IN PERFORMING THE AUDIT We encountered no difficulties in dealing with management in performing and completing our audit. CORRECTED AND UNCORRECTED MISSTATEMENTS 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. None of the adjustments detected as a result of audit procedures and corrected by management were material, either individually or in the aggregate, to the financial statements taken as a whole. 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 requested certain representations from management which were provided to us in the management representation letter. 5 CITY OF EDEN PRAIRIE REQUIRED COMMUNICATION December 31,2010 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 City'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. We are not aware of any consultations by the City's management with other accountants during the course of our audit. OTHER 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. OTHER INFORMATION IN DOCUMENTS CONTAINING AUDITED FINANCIAL STATEMENTS We have not reviewed, and it is our understanding, that no other published documents exist that contain audited financial statement information, for which we are currently auditing. As stated in our engagement letter,if you publish or reproduce the financial statements or make reference to our Firm name in relation to such documents, you agree to provide us with a copy of the final reproduced material for our approval before it is distributed. 6