Loading...
HomeMy WebLinkAbout2015-07-21 WSTues Tues Tues Wed Wed Tues Tues Tues Tues Wed ses s Tues Tues AGENDA CITY COUNCILWORK SESSION CITY OF EDINA, MINNESOTA COMMUNITY ROOM TUESDAY, JULY 21, 2015 5:30 P.M. CALL TO ORDER II. ROLL CALL 111. BUSINESS MEETING IV. 2016-2017 PROPOSED BUDGET V. ADJOURNMENT The City of Edina wants all residents to be comfortable being part of the public process. If you need assistance in the way of hearing amplification, an interpreter, large -print documents or something else, please call 952- 927-8861 72 hours in advance of the meeting. SCHEDULE OF UPCOMING MEETINGS/DATES/EVENTS July 21 Work Session — Business Meeting 5:30 P.M. COMMUNITY ROOM 2016-2017 Proposed Budget 5:45 P.M. COMMUNITY ROOM July 21 Regular Meeting 7:00 P.M. COUNCIL CHAMBERS Aug 4 Night To Unite Aug 5 Work Session — France Avenue Working Group Update 5:00 P.M COMMUNITY ROOM Grandview Update 6:00 P.M. COMMUNITY ROOM Aug 5 Regular Meeting 7:00 P.M. COUNCIL CHAMBERS Aug 18 Work Session — Promenade Phase 5 5:30 P.M. COMMUNITY ROOM Aug 18 LABOR DAY HOLIDAY OBSERVED — City Hall Closed Sep 8 Work Session — Heritage Preservation Board 5:00 P.M. COMMUNITY ROOM Human Rights & Relations Commission 6:00 P.M. COMMUNITY ROOM Sep 8 Regular Meeting 7:00 P.M. COUNCIL CHAMBERS Sep 16 Work Session — Arts & Culture Commission 6:00 P.M. COMMUNITY ROOM Sep 16 Regular Meeting 7:00 P.M. COUNCIL CHAMBERS Oct 6 Work Session — Boards & Commission Annual Work Plans 5:00 P.M. COMMUNITY ROOM Oct 6 Regular Meeting 7:00 P.M. COUNCIL CHAMBERS Oct 20 Work Session — Business Meeting 5:30 P.M. COMMUNITY ROOM Oct 20 Regular Meeting 7:00 P.M. COUNCIL CHAMBERS • To: MAYOR AND CITY COUNCIL From: Eric Roggeman, Finance Director Date: July 21, 2015 Subject: Business Meeting Action Requested: This item is for discussion only. it 0 Agenda Item #: WS. III. Action ❑ Discussion Information ❑ Information / Background: In 2007, the City started a quarterly review process for general fund financials called Quarterly Update. Quarterly Update is a two-page written summary of finances and notable transactions in the general fund. • In 2012, the City added quarterly business meetings held on the second work session after every calendar quarter end. At quarterly business meetings staff presents to Council finances and notable transactions in the general fund and all the enterprise funds. In some quarters, financial data is not ready in time to be included in Council packets prior to the meeting. This quarter the financial data is ready and is attached for your review. Attachments: Business Meeting presentations slides General Fund Quarterly Update City of Edina • 4801 W. 50th St. • Edina, MN 55424 7/15/2015 The CITY of EDINA 2015 General Fund =�. �.� Revenue • 2015 YTD = $17.1M vs. $16M in 2014.(7.2% increase) • 50% of budget, compared to 48% in 2014 • 2010-2014 average rate is 47.4% Expenditures • 2015 YTD = $16.2M vs. $15.8M in 2014.(2.5% increase) • 46.4% of budget, compared to 46.5% in 2014. • 2010-2014 average rate is 46.9% Key Metric: License & Permit Revenue • 2015 YTD = $2.5M vs. $2.2M in 2014. (12.6% increase) • 65% of budget, compared to 67.7% in 2014. -EdinaMN.gov 1 n U 11 Utilities Fund Utilities Fund Operating Revenue X2015 Actual —2015 Budget 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% QI Q2 Q3 Q4 w .EdlnaMN.gov • Liquor Fund 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% Liquor Fund Operating Revenue X2015 Actual — 2015 Budget w .EdinaMN.gov • QI Q2 Q3 Q4 K The CITY of EDINA Key Metric:Water pumped out of City wells • 2015 YTD water pumped = 1.05B gallons vs. 957M gallons in 2014. • 20010-2014 average pumping rate was LOB gallons Jan -June. e The CITY of TEDINA Key Metric: Customer Counts • 2015YTD customers = 224,620 vs. 239,963 in 2014. • 20010-2014 average count was 236,521. Based on this figure, 2015 customer numbers are down 5% from historical averages. 7/15/2015 31 41 2 7/15/2015 e x The CITY of EDINA Liquor Fund �.�; y Liquor Fund Sales per Customer ■ Gross revenue (sales) per customer 35.00 30.00 28.83 28.25 25.86 26.44 26.22 26.27 26.67 26.33 25.58 24.78 25.00 20.00 15.00 10.00 5.00 2013 2013 2013 2013 2014 2014 2014 2014 2015 2015 2015 2015 QI Q2 Q3 Q4 QI Q2 Q3 Q4 QI Q2 Q3 Q4 w .EdinaMN.gov 5 U 'The CITY of qLi uor Fund =�` EDINA Liquor Fund Operating Income ■2010 ■2011 ■2012 ■2013 ■2014 ■2015Actual 600,000 500,000 400,000 300,000 200,000 100,000 QI Q2 Q3 Q4 -.EdinaMN.gov 6 0 3 is r: Aquatic Center Fund Aquatic Center Operating Revenue X2015 Actual —2015 Budget 60% 50% 40% 30% 20% 10% 0% QI Q2 Q3 Q4 w .EdinaMN.gov • Golf Course Fund Golf Course Fund Operating Revenue X2015 Actual —2015 Budget 50% 45% 40% 35% 30% 25% 20% IS% 10% 5% 0% v .EdinaMN.gov • QI Q2 Q3 Q4 The CITY of EDINA Key Metric: Season passes sold • 2015 YTD passes = 3,257 (10,194 people) vs. 3,344 (10,480 people) in 2014. • 20010-2014 average sales were 3,178. Note that new POS system in 2012 may distort this comparison slightly. v��NA..yi e "y. The CITY of >J EDINA Key Metric: Golf rounds played (Braemar, Executive & Fred Richards) • 2015YTD rounds= 32,703 vs. 32,230 in 2014. • 20010-2014 average rounds were 39,066. 7/15/2015 4 Golf Course Fund 50% 45% 40% 35% 30% 25% 20% 15% 10% S% 0% Golf Course Fund Operating Expense X2015 Actual —2015 Budget QI Q2 Q3 Q4 - EdinaMN.gov Golf Course Fund Golf Course Fund Operating Income (Loss) ■ 2010 ■ 2011 ■ 2012 ■ 2013 ■ 2014 0 2015 600,000 400,000 200,000 (200,000) (400,000) (600,000) www.EdinaMN.gov QI Q2 Q3 Q4 k;;`��`': The CITY of e EDINA • Expenses are down even though revenue is up. • Operating income improved $322,456 from 2014YTD. • Revenue pace will be difficult to maintain for the entire season now that the range and Braemar Executive are closed. The CITY of EDINA Y F • Expenses are down even though revenue is up. • Operating income improved $322,456 from 2014YTD. • Revenue pace will be difficult to maintain for the entire season now that the range and Braemar Executive are closed. 7/15/2015 • C7 5 r: Arena Fund 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% Arena Operating Revenue X2015 Actual —2015 Budget QI Q2 Q3 Q4 vvvvw.EdinaMN.gov • Arena Fund Braemar Arena Operating Expense 2015 Actual — 2015 Budget 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% -.EdinaMN.gov • QI Q2 Q3 Q4 - ie . f '�:,. The CITY of EDINA Key Metric: Ice rental hours sold • 2015 hours sold = 2,954 prime & 2,975 nonprime vs. 2,246 prime & 2,647 nonprime in 2014. • Utilization = 66% in 2015 vs. 67% in 2014. �l 4, The CITY of EDINA • Expenses have increased about $235K from 2014YTD. 7/15/2015 X 7/15/2015 e The CITY of Art Center Fund �.('r EDINA Art Center Operating Revenue X2015 Actual — 2015 Budget 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% Q Q2 Q3 Q4 w .EdinaMN.gov 13 Edinborough Park Fund Edinborough Operating Revenue X2015 Actual —2015 Budget 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% QI Q2 Q3 Q4 �i�NA..tf �x The CITY of l2� EDINA �'�r�n•n -.EdinaMN.gov 14 0 7 0 Centennial Lakes Fund Centennial Lakes Operating Revenue X 20 15 Actual —2015 Budget 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0°,6 w .EdMaMN.gov • QI Q2 Q3 Q4 Sports Dome Fund Braemar Field Operating Revenue ■ 2015 Actual 50% 45% 40% 35% 30% 25% 20% 15% 10% 5% 0% QI Q2 Q3 Q4 The CITY of =� EDINA Wiz= DANA. �f g ? The CITY of =�= EDINA 7/15/2015 w .Edi-MN.gov 16 • * CITY OF EDINA, MINNESOTA Quarterly Financial Update June 2015 0 General Fund - Revenues General Fund revenues total $17,131,138 through June 30, 2015. This amount represents 50% of total budgeted revenues for all of 2015, which is higher than 48% a year ago at the same time. License and permit revenue increased $279,971 from last year due to increased permit activity. The City has experienced rapid growth in permit revenue since 2009 of 15%, 13%, 16%, 32% and 9% annually from 2010 through 2014. The pace so far in 2015 is another 12% increase. We have also received $300,000 of parkland dedication fees through June 30 this year and another $500,000 already in July. General Fund — Expenditures Total General Fund expenditures are 46.4% of budget so far this year, which is the same as a year ago. With a large percentage of our General Fund budget tied to wages and benefits, it is common for our expenditures to be very consistent throughout the year, meaning that most years we use about 25% of our budget every quarter. A breakdown of expenditures by functional category is below. General government expenditures are 50% of budget so far this year, which is the same as • last year. Severance expenditures are high again in 2015, with vacation and sick time payouts of about $236,000 so far this year, which is similar to last year's pace. Although these expenditures are higher than budgeted, the excess is paid for by assigned fund balance that we hold in the general fund for this purpose. Public safety expenditures are 46.5% of budget for 2015, which is similar to the 2014 rate. Spending patterns in the Police and Fire Departments seem consistent with expectations at this point in the year with no notable exceptions. Public works expenditures total 44% of budget for 2015, which is lower than the 2014 rate of 45%. While slightly below the expected expenditure rate, 44% through six months is consistent with historical fluctuations in the Public Works Department, which includes the Parks Maintenance Division since 2014. Parks and recreation expenditures are 46% of budget in 2015, which is higher than the 2014 rate of 43%. The 46% rate is consistent with expectations for normal spending activity. Other expenditures increased from the prior year due to timing differences in overall insurance payments. Finance distributes these insurance expenditures to other departments through our Central Services function at the end of the year as part of the annual audit process, and large variances during the year can be common. is G:\P&L's\Quarterly Financial Update\2015\Quarterly Update.docx 0 • n CITY OF EDINA, MINNESOTA Quarterly Financial Update June 2015 Expenditures: General Fund Statement of Revenue, Expenditures and Changes in Fund Balance - Budget and Actual 769,242 79,949 For the six months ended June 30, 2015 516,464 (524,210) 506,493 9,971 2015 ' 2014 (257,783) 221,624 16,230 Severance Over/ 235,988' Increase/ 246,272 Budget Actual (Under) Actual (Decrease) Revenues: (23,516) Community development 1,612,160 732,124 (880,036) Property taxes (1) $ 22,810,958 $ 11,482,800 $ (11,328,158) $ 10,708,100 $ 774,700 Franchise and lodging tax 770,000 206,041 (563,959) 198,461 7,580 Licenses and permits (2) 3,830,080 2,498,323' (1,331,757) 2,218,352' 279,971 Intergovernmental (3) 1,113,500 373,271 (740,229) 237,460 135,811 Charges for service 3,969,494 1,612,494 (2,357,000) 1,664,002' (51,508) Fines and forfeitures 950,000 474,426 (475,574) 370,845 103,581 Other revenues 611,100 483,783 (127,317) 577,968 (94,185) Total revenues 34,055,132 17,131,138 (16,923,994) 15,975,188 1,155,950 Expenditures: Administration 1,619,238 849,191 (770,047) 769,242 79,949 Comm & tech services 1,040,674 516,464 (524,210) 506,493 9,971 Human resources 495,637 237,854 (257,783) 221,624 16,230 Severance 200,000 235,988' 35,988 246,272 (10,284) Finance 904,918 386,521 (518,397) 410,037 (23,516) Community development 1,612,160 732,124 (880,036) 735,325 (3,201) Public works 8,459,610 3,752,972 (4,706,638) 3,710,370 42,602 Engineering 1,735,095 722,865 (1,012,230) 700,109 22,756 Police 10,357,415 4,840,801 (5,516,614) 4,771,055 69,746 Fire 7,007,398 3,241,275 (3,766,123) 2,985,699 255,576 Parks & recreation 1,388,087 633,290 (754,797) 601,316 31,974 Other - 8,095 8,095 114,886 (106,791) Total expenditures 34,820,232 16,157,440 (18,662,792) 15,772,428 385,012 Revenues over (under) expenditures (765,100) 973,698 1,738,798 202,760 770,938 Other financing sources (uses): Transfers in (out) Liquor fund (4) 765,100 - (765,100) - - Other - - - - Parkland dedication - 300,000 300,000 382,278 (82,278) Total other financing source 765,100 300,000 (465,100) 382,278 (82,278) Net increase (decrease) in fund balance $ - $ 1,273,698 $ 1,273,698 $ 585,038 $ 688,660 1 The City receives the first property tax payment from the County in June and the second payment in Decembe 2 The licenses and permits category includes building permits. 3 The intergovernmental category includes grants from Federal, state and county sources. Generally, most of the grants the City receives are reimbursement grants, which means that if grant revenue increases, expenditures must also increase by an equal or greater amount. 4 The annual liquor fund transfer is always made in December. G:\P&L's\Quarterly Financial Update\2015\Quarterly Update.docx 2 0 si To: MAYOR AND CITY COUNCIL From: Eric Roggeman, Finance Director Date: July 21, 2015 Subject: 2016-2017 Proposed Budget Action Requested: This item is for discussion only. Agenda Item #: WS. IV. Action ❑ Discussion FA Information ❑ Information / Background: Staff has been working on the 2016-2017 budget this summer and will have a presentation ready for the work session on Tuesday. 2016-2017 budget process timeline: • April 21: City Manager presents 2016-2017 proposed work plan to Council. • May 15: Department Heads send budget requests to Finance. • July 8: Executive Leadership Team reviews budget draft. • July 21: City Manager presents 2016-2017 budget draft to Council. • September 1: Council and HRA adopt preliminary 2016-2017 budget and 2016 property tax levies. The preliminary property tax levies adopted on September I are the maximum amount of the final property tax levies the Council and HRA may adopt in December. • November: Hennepin County sends out parcel notices. • December I: Budget public hearing & option for Council to adopt final 2016-2017 budget and 2016 property tax levies. • December 15: Deadline to adopt final 2016-2017 budget and 2016 property tax levies. City of Edina • 4801 W. 50th St. • Edina, MN 55424 "40bb.- 0 0 0 The CITY of �- EDINA 2016-2017 Budget Process Update July 21, 2015 Council Worl< Session Agenda ,* Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons www.EdinaMN.gov The CITY of EDINA 0 0 0 2 %boom. 0 0 0 e The CITY of Definitions M. W� EDINA General Fund: The main operating fund of the City's government functions. Includes about $37M of revenues and expenditures. • Governmental Funds: In addition to the general fund, the City has a debt service fund, construction fund, HRA fund, and several special revenue funds.Annual expenditures are about $62M. Enterprise Funds: Used to account for "business -type" activities. Total annual expenses equal about $39M • Consolidated Budget: Approximately $1 OOM in total revenues and expenditures/expenses and includes all City and HRA funds, governmental and enterprise. www.EdinaMN.gov 3 Definitions www.EdinaMN.gov e - The CITY of r �I EDINA 0 Definitions 0 11-� e�.�, The CITY of r y' EDINA • Estimated Market Value: One way to measure "tax base".The City Assessor estimates values for each property in Edina.The total EMV of all properties in Edina is around $1 OB. Tax Capacity: A second way to measure "tax base".Tax capacity is a uniquely Minnesotan way of calculating property taxes.Tax capacity uses EMV and property classifications so that different types of property are taxed differently. www.EdinaMN.gov 5 tiA, e �The CITY of EDINA Definitions ����� • Total City Property Tax Levy or Levies: Often described as one, but the City actually has several different levies organized by purpose. • General Fund Property Tax Levy: The dollar amount that the City needs from property taxes to pay for General Fund expenditures. About $25M of the $37M General Fund budget (68%). Debt Levies: Edina has several debt levies that go towards principal and interest payments on some of the City's debt.The City also has debt that is paid by revenue other than property taxes, like our utility fund debt and special assessment debt. • Other Levies: Arts & culture, equipment, and HRA are examples. www.EdinaMN.gov kbVAV4, 6 • Agenda Y Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons e ��? The CITY of W` EDINA www.EdinaMN.gov 7 Work Plan Drives Budget Work Plan Themes www.EdinaMN.gov Work Plan Goals The CITY of r EDINA Budget • Staff 0 0 0 0 0 0 BudgetTimeline e The CITY of L EDINA April 21 City Manager presents 2016-2017 proposed work plan to Council May 15 Department Heads send budget requests to Finance ELT reviews 2016-2017 budget draft City Manager presents 2016-2017 budget draft to Council July 8 July 21 Aug. 18 or City Council adopts new WAC/SAC charges and utility rates based on Sept. I the rate study discussed on July 7 City Council adopts preliminary 2016 property tax levy and budget Sept. 16 Dec. I Public Hearing & option to adopt 2016 final property tax levy and j budget. Deadline to adopt final 2016 property tax levy and budget Dec. 15 www.EdinaMN.gov • Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons www.EdinaMN.gov • e �! The CITY of EDINA is 0 10 2016-2017 Budget Challenges 40 The CITY of r i✓ l EDINA • Minimum wage increase affects many positions in Edina. • 1 1.5% rate cap for health insurance premiums. • FT employee count increased by I since last budget cycle, but 5.45 increase in the General Fund is offset by a 4.45 decrease elsewhere. • Edinborough & Centennial Lakes reserve balances are projected to decrease. • Liquor profits are lower than past years - 2014 budgeted transfer was $1,800,100 but actual was $1,035,000 - 2015 budgeted transfer is $1,850,100 but actual will likely be less than $1 M - Draft 2016 budgeted transfer is about $1.15M less than 2015 budget www.EdinaMN.gov e The CITY of r -c 2016-2017 Budget Challenges �..EDINA • 2014 General Fund unassigned fund balance was $708,294.This is lower than in the past, which affects our CIP funding. • Services and expectations are increasing for all departments • Budget draft today would result in about an 7.25% total property tax levy increase — new staff requests not included (5 total FT staff requests) — GIS not included —Weber Woods and many work plan items also not included — Street sweeping expenses are being moved to Storm Utility fund • Council and staff have identified many possibilities, but priorities may need to be adjusted. www.EdinaMN.gov 0 0 0 12 0 0 0 e The CITY of 2016-2017 Wrlc P EDINA o Ian Themes is Focused Redevelopment - PW site decision with community space + financing by 3/1/16 - Hwy 100 lid study completed by 12/31/17 - Fred Richards plan + financing by 12/31/16 • Future Planning - Comprehensive plan draft complete by 12/31/17 • Intergovernmental Relations www.EdinaMN.gov 13 - The CITY of e � �i 2016-2017 Work Plan Themes = EDINA • Transportation & Infrastructure - Complete Grandview transportation study & plan by 12/31/17 - Complete construction of street or woonerf - Start construction on WTP #5 in 2017 - Study S'dale sanitary capacity & implement plan by 2017 - Convert debt retirement in 2017 into CIP funding - Consider increasing franchise fees for streets by 12/31/16 • Enterprise Stability - Complete business plans for each enterprise www.EdinaMN.gov 0 0 0 14 0 0 0 Budget Summary 10.00 8.00% 6.00% 4.00 2.00% 0.00% e . y, The CITY of �F EDINA Total Property Tax Levy Increases vs. General Fund Expenditures Rraamar Liquor 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 ■ Total Levy Increase % ■ Change in expenditures www.EdinaMN.gov 15 Agenda • Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons www.EdinaMN.gov K gThe CITY of ° EDINA 0 0 0 16 HRA Levy for 2017 41 e The CITY of e EDINA • State law allows an HRA to levy up to 0.0 185 % the previous year's taxable market value of all property in the City.This limit would produce tax revenue of about $1.8M in Edina. • An HRA raises its own levy separate from the City, and the HRA levy is not subject to levy limits (other than above) • Levies collected by an HRA must be used only for purposes listed in the HRA Act. A $95,000 HRA levy in Edina would be $4/year for a median single family home ($457,300) Sources: LMC Handbook for Cities, Edina Finance Dept., & Edina Assessing Division www.EdinaMN.gov 17 Agenda • Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons www.EdinaMN.gov e The CITY of Cr EDINA 0 0 0 18 e The CITY of e, ED Estimated MarketValue(EMV)�INA .. ,y Edina EMV Property Tax Base Growth $1,000,000,000 9.4% $800,000,000 7.2% $600,000,000 7.5/ 4.5% $400,000,000 2.5% $200,000,000 I.0% 1.4% 1.7% 1.9% o 0 0 1.2% 1.3% 1.6% 0.7% 0.7/ 0.7% 0.9/ $- ---- — -- $(200,000,000) -0.5% 0.0% $(400,000,000)° -3.4% -3.5% -3.6/ $(600,000,000) -5.9% $(800,000,000) 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 ■ Inflation/deflation due to real estate market forces ■ Growth due to improvements Source: City Assessor's Office and Hennepin County www.EdinaMN.gov 19 Annual PropertyTaxes $6,000 $5,000 $4,000 $3,000 $2,000 $1,000 www.EdinaMN.gov $4,522 e The CITY of s, EDINA $400,000 Edina Home Property Tax History $4,094 $5,610 $999 $872 $1,141 2005 2006 2007 2008 2009 2010 2011 City tax Total tax Source: LMC Property Tax Calculator 7/20/15 2012 2013 2014 2015 0 0 0 20 Annual PropertyTaxes $7,000 $6,000 $5,000 $4,000 $3,000 $2,000 $1,000 wvN'1 e ? The CITY of Wq EDINA "Median" Edina Home Property Tax History $4,435 $944 $1,195 $1,268 Source: LMC Property Tax Calculator 7/20/15 & City Assesor's Office www.EdinaMN.gov 21 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 City tax $944 $970 $1,012 $1,020 $1,042 $1,082 $1,102 $1,140 $1,195 $1,268 Total tax $4,435 $4,597 $4,725 $4,922 $5,066 $5,410 $5,449 $5,606 $5,861 Median Value $433,300 $444,800 $439,000 $432,700 $411,500 $403,100 $396,300 $399,700 $438,800 $457,300 Source: LMC Property Tax Calculator 7/20/15 & City Assesor's Office www.EdinaMN.gov 21 2016 Estimated Levy Impacts f? The CITY of EDINA • In 2015 the median home pays about $100 per month in property taxes to fund all of the City provided services. • Tax capacity is increasing in Edina by about 6% for taxes payable in 2016.The median value single family home is now $457,300. If the budget includes an 7.25% property tax increase, the effect on the $457,300 single family home would be about: - about 6% increase in City property taxes. - about $73 increase per year, or about $6 per month. - this home would pay about $106 per month in 2016 City property taxes. www.EdinaMN.gov 22 • • Governmental Revenue Per Capita Source: MN State Auditor website 7/7/15 Ll The CITY of W EDINA www.EdinaMN.gov 23 • • • totalThe governmental2013 per capita I Plymouth $ 684.12 2 Minnetonka $ 875.60 3 Eden Prairie $ 881.88 4 Richfield $ 987.76 5 Edina $ 1,011.63 6 Hopkins $ 1,147.21 7 Maple Grove $ 1,192.77 8 St. Louis Park $ 1,240.14 9 Bloomington $ 1,488.13 10 Golden Valley $ 1,435.72 11 Minneapolis $ 2,020.35 Source: MN State Auditor website 7/7/15 Ll The CITY of W EDINA www.EdinaMN.gov 23 Property Tax Revenue Per Capita The tax per ca .. • Property2013 I Plymouth $ 399.98 2 Maple Grove $ 492.27 3 Richfield $ 515.37 4 Eden Prairie $ 520.78 5 Bloomington $ 541.53 6 St. Louis Park $ 542.23 7 Edina $ 546.40 8 Hopkins $ 575.73 9 Minnetonka $ 606.30 10 Minneapolis $ 773.91 1 1 Golden Valley $ 814.57 Source: MN State Auditor website 7/7/15 www.EdinaMN.gov e The CITY of EDINA 24 City Property Taxes I Edina* $ 1,141 2 Plymouth* $ 1,202 3 Eden Prairie* $ 1,424 4 Shoreview* $ 1,495 5 Minnetonka* $ 1,559 6 Eagan* $ 1,593 7 Woodbury* $ 1,622 8 Lakeville* $ 1,650 9 Shakopee* $ 1,673 10 Maple Grove* $ 1,685 11 Inver Grove Heights* $ 1,859 SAI 4 eA. qv - The CITY of s� EDINA 12 Burnsville* $ 1,861 13 St. Louis Park $ 1,937 14 Bloomington* $ 1,941 15 Apple Valley* $ 1,995 16 Maplewood* $ 2,008 17 Savage* $ 2,269 18 Golden Valley $ 2,466 19 Hopkins $ 2,496 20 Richfield $ 2,571 21 Minneapolis $ 2,976 Source: LMC Property Tax calculator 7/7/15 *City is a member of the MLC www.EdinaMN.gov 25 C G:\Budget and CIP\2016 Budget\Meetings\20150721 Council work session\2016 Summary charts - Draft.xlsx 7/21/2015 CITY OF EDINA Draft Tax Levies is Draft Budget Draft Budget 2013 2014 2015 2016 2017 General Fund Levies General Operating Levy $ 21,824,894 $ 22,509,403 $ 22,933,958 $ 25,045,588 $ 26,425,558 General Fund Subtotal 21,824,894 22,509,403 22,933,958 25,045,588 26,425,558 Increase From Prior Year (%) 1.02% 3.14% 1.89% 9.21% 5.51% Arts and Culture Fund Levies Arts and Culture - - 20,000 20,000 20,000 Arts and Culture Fund Subtotal - - 20,000 20,000 20,000 Increase From Prior Year (%) 0.00% 0.00% Debt Service Fund Levies City Hall Debt Service 949,850 947,600 944,400 946,000 946,000 Equipment Certificates - - - - - Gymnasium Debt Service 396,444 409,244 409,440 417,000 422,000 Fire Station Debt Service 431,544 441,944 441,940 443,000 443,000 Public Works Facility Debt Service 1,536,743 1,526,809 1,546,600 1,561,000 1,696,000 Park Bond Market Value Levy 615,837 627,800 618,600 571,650 - Sports Dome - - 1,168,000 1,170,500 1,162,500 Debt Service Fund Subtotal 3,930,418 3,953,397 5,128,980 5,109,150 4,669,500 Increase From Prior Year (%) 7.63% 4.31% 29.74% -0.39% -8.61% Construction Fund Levies Equipment Levy 992,072 992,072 1,617,072 1,680,000 1,750,000 Construction Fund Subtotal 992,072 992,072 1,617,072 1,680,000 1,750,000 Increase From Prior Year (%) 0.00% 0.00% 63.00% 3.89% 4.17% HRA Fund Levies HRA Operating Levy - - - - 95,000 HRA Fund Subtotal - - - - 95,000 Increase From Prior Year (%) Total Property Tax Levy $ 26,747,384 $ 27,454,872 $ 29,700,010 $ 31,854,738 $ 32,960,058 Increase From Prior Year (%) 1.90% 2.65% 8.18% 7.25% 3.47% C G:\Budget and CIP\2016 Budget\Meetings\20150721 Council work session\2016 Summary charts - Draft.xlsx 7/21/2015 EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY DEPARTMENT • Administration $ 23,125,572 $ CITY OF EDINA $ 21,993,635 22.5% $ 2 -14.1% Consolidated Draft Budget Communications & tech. 1,205,409 1,506,574 1,355,785 2014 2015 Draft 2016 2,570,265 Draft 2017 • Human resources Actual Budget Budget 35.1% Budget 811,495 REVENUES AND OTHER FINANCING SOURCES Finance 1,015,847 1,191,299 1,156,525 -2.9% Property tax levy $ 26,988,493 $ 29,700,010 $ 31,854,738 7.3% $ 32,960,058 3.5% Reductions - (123,000) - -100.0% - NA Net tax revenue 26,988,493 29,577,010 31,854,738 7.7% 32,960,058 3.5% Tax increments 5,052,705 100,000 2,500,000 2400.0% 2,500,000 0.0% Franchise fees 2,055,396 2,070,000 2,090,000 1.0% 2,090,000 0.0% Lodging tax 11,301 - 20,000 NA 20,000 0.0% Special assessments 4,606,010 3,992,997 3,321,571 -16.8% 3,444,787 3.7% Licenses and permits 4,583,183 3,880,080 4,048,160 4.3% 4,217,660 4.2% Intergovernmental 4,294,999 5,169,825 4,329,550 -16.3% 2,348,550 -45.8% Charges for services 4,270,720 4,019,494 10,665,310 165.3% 4,217,973 -60.5% Fines and forfeitures 1,163,907 950,000 975,000 2.6% 975,000 0.0% Operating revenue 39,886,753 42,823,745 41,158,385 -3.9% 40,788,448 -0.9% Investment income 632,025 463,956 412,037 -11.2% 376,289 -8.7% Other revenue 1,604,975 1,188,448 643,311 -45.9% 644,711 0.2% Debt issued 21,335,000 4,599,895 2,917,200 -36.6% 3,619,200 24.1 Other financing sources 218,699 - - NA - NA TOTAL REVENUES AND OTHER 14,253,910 15,458,963 8.5% 15,905,873 2.9% FINANCING SOURCES $ 116,704,166 $ 98,835,450 $ 104,935,262 6.2% $ 98,202,676 -6.4% EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY DEPARTMENT • Administration $ 23,125,572 $ 17,960,549 $ 21,993,635 22.5% $ 18,882,055 -14.1% Communications & tech. 1,205,409 1,506,574 1,355,785 -10.0% 2,570,265 89.6% • Human resources 979,873 695,637 939,693 35.1% 811,495 -13.6% Finance 1,015,847 1,191,299 1,156,525 -2.9% 1,213,493 4.9% Public works 24,213,569 22,913,578 24,926,947 8.8% 25,475,177 2.2% Engineering 7,796,629 13,926,591 9,431,684 -32.3% 8,629,581 -8.5% Police 11,081,717 11,764,823 12,712,313 8.1% 12,553,801 -1.2% Fire 6,965,287 7,134,947 7,875,851 10.4% 8,003,126 1.6% Parks & recreation 12,933,141 13,244,427 12,515,379 -5.5% 12,970,871 3.6% Community development 1,543,486 1,742,160 1,770,974 1.7% 1,961,125 10.7% Debt service 7,105,222 6,654,894 6,008,988 -9.7% 6,179,315 2.8% TOTAL EXPENDITURES, EXPENSES AND OTHER FINANCING USES $ 97,965,752 $ 98,735,479 $ 100,687,774 2.0% $ 99,250,304 -1.4% EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY TYPE Cost of goods sold $ 10,440,199 $ 10,696,828 $ 9,761,579 -8.7% $ 9,803,441 0.4% Personal services 31,436,091 32,759,604 34,152,380 4.3% 34,610,706 1.3% Contractual services 15,439,638 14,253,910 15,458,963 8.5% 15,905,873 2.9% Commodities 3,590,164 3,853,162 4,221,663 9.6% 4,099,252 -2.9% Central services 4,872,724 5,154,924 5,200,539 0.9% 5,292,297 1.8% Equipment 1,468,320 1,746,978 2,138,140 22.4% 1,456,412 -31.9% Capital outlay 18,414,824 17,395,224 16,513,000 -5.1% 14,404,000 -12.8% Depreciation 5,198,570 5,471,750 6,538,750 19.5% 6,913,750 5.7% Debt service 7,105,222 7,403,099 6,702,760 -9.5% 6,764,573 0.9% TOTAL EXPENDITURES, EXPENSES AND OTHER FINANCING USES $ 97,965,752 $ 98,735,479 $ 100,687,774 2.0% $ 99,250,304 -1.4% CHANGE IN FUND BALANCE OR NET POSITION $ 18,738,414 $ 99,971 $ 4,247,488 $ (1,047,628) 7/21/2015 CITY OF EDINA Draft Budget by Fund Type Draft 2016 Governmental Enterprise Funds Funds Total REVENUES AND OTHER FINANCING SOURCES EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY FUNCTION 32,960,058 Property tax levy $ 31,854,738 $ 2,500,000 $ 31,854,738 Reductions - 20,000 $ Net tax revenue 31,854,738 $ 18,882,055 31,854,738 Tax increments 2,500,000 4,217,660 2,500,000 Franchise fees 2,090,000 4,217,973 2,090,000 Lodging Tax 20,000 - 20,000 Special assessments 3,321,571 40,788,448 3,321,571 Licenses and permits 4,048,160 623,211 4,048,160 Intergovernmental 4,032,550 297,000 4,329,550 Charges for services 10,665,310 - 10,665,310 Fines and forfeitures 975,000 - 975,000 Operating revenue - 41,158,385 41,158,385 Investment income 303,800 108,237 412,037 Other revenue 621,811 21,500 643,311 Transfers 300,000 568,100 868,100 Debt issued 2,917,200 12,046,581 2,917,200 Other financing sources - Fire - TOTAL REVENUES AND OTHER 7,875,851 8,003,126 FINANCING SOURCES $ 63,650,140 $ 42,153,222 $ 105,803,362 Draft 2017 Governmental Enterprise Funds Funds Total $ 32,960,058 $ - $ 32,960,058 32,960,058 EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY FUNCTION 32,960,058 2,500,000 2,500,000 2,090,000 10,238,352 $ 2,090,000 20,000 $ 20,000 3,444,787 $ 18,882,055 3,444,787 4,217,660 1,355,785 4,217,660 2,236,550 112,000 2,348,550 4,217,973 - 4,217,973 975,000 - 975,000 - 40,788,448 40,788,448 263,400 112,889 376,289 623,211 21,500 644,711 250,000 671,295 921,295 3,619,200 - 3,619,200 $ 57,417,839 $ 41,706,132 $ 99,123,971 3 7/21/2015 EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY FUNCTION Administration $ 10,238,352 $ 11,755,283 $ 21,993,635 $ 6,864,249 $ 12,017,806 $ 18,882,055 • Communication & tech. 1,355,785 - 1,355,785 2,570,265 - 2,570,265 Human resources 939,693 939,693 811,495 811,495 Finance 858,132 298,393 1,156,525 904,089 309,404 1,213,493 Public works 10,289,557 14,637,390 24,926,947 10,255,643 15,219,534 25,475,177 Engineering 9,157,588 274,096 9,431,684 8,351,327 278,254 8,629,581 Police 12,215,859 496,454 12,712,313 12,046,581 507,220 12,553,801 Fire 7,875,851 - 7,875,851 8,003,126 - 8,003,126 Parks & recreation 1,728,686 10,786,693 12,515,379 3,223,201 9,747,670 12,970,871 Community development 1,770,974 - 1,770,974 1,961,125 1,961,125 Debt service 6,008,988 6,008,988 6,179,315 - 6,179,315 Transfers 68,100 800,000 868,100 71,295 850,000 921,295 TOTAL EXPENDITURES, EXPENSES AND OTHER FINANCING USES $ 62,507,565 $ 39,048,309 $ 101,555,874 $ 61,241,711 $ 38,929,888 $ 100,171,599 EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY TYPE Cost of goods sold $ - $ 9,761,579 $ 9,761,579 $ - $ 9,803,441 $ 9,803,441 Personal services 26,150,875 8,001,505 34,152,380 27,1 17,571 7,493,135 34,610,706 Contractual services 5,538,813 9,920, I50 15,458,963 5,809,588 10,096,285 15,905,873 Commodities 2,194,387 2,027,276 4,221,663 2,238,410 1,860,842 4,099,252 Central services 3,895,262 1,305,277 5,200,539 3,965,120 1,327,177 5,292,297 Equipment 2,138,140 - 2,138,140 1,456,412 - 1,456,412 Capital outlay 16,513,000 - 16,513,000 14,404,000 - 14,404,000 Depreciation - 69538,750 6,538,750 - 6,913,750 6,913,750 Debt service 6,008,988 693,772 6,702,760 6,179,315 585,258 6,764,573 Transfers 68,100 800,000 868,100 71,295 850,000 921,295 TOTAL EXPENDITURES, EXPENSES AND OTHER FINANCING USES $ 62,507,565 $ 39,048,309 $ 101,555,874 $ 61,241,711 $ 38,929,888 $ 100,171,599 CHANGE IN FUND BALANCE OR NET POSITION $ 1,142,575 $ 3,104,913 $ 4,247,488 $ (3,823,872) $ 2,776,244 $ (1,047,628) 3 7/21/2015 CITY OF EDINA 4 Draft Governmental Fund Budgets 0 DRAFT 2016 GOVERNMENTAL FUND BUDGETS FUND BALANCE $ - $ 973,162 $ (52,566) $ - $ (3,639) $ 5,200 $ 2,425 $ 1,203,861 $ (104,000) $ (881,868) $ 1,142,575 7/21/2015 Braemar Arts & Debt Environmental General HRA PACS CDBG Police SR Memorial Culture Service Efficiency Construction Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Total REVENUES AND OTHER FINANCING SOURCES Property ax levy $ 25,045,588 $ - $ - $ - $ - $ - $ 20,000 $ 5,109,150 $ - $ 1,680,000 $ 31,854,738 Reductions - - - - Net tax revenue 25,045,588 - - - 20,000 5,109,150 - 1,680,000 31,854,738 Tax increments - 2,500,000 - - - - - - - - 2,500,000 Franchise fees 790,000 - 1,200,000 - - - - - - 100,000 2,090,000 Lodging Tax 20,000 - - - - - - - - - 20,000 Special assessments - - - - - - - 2,083,699 - 1,237,872 3,321,571 Licenses and permits 4,023,160 - - - - - - - - 25,000 4,048,160 Intergovernmental 1,191,550 - - 125,000 36,000 - - - - 2,680,000 4,032,550 Charges for services 3,940,310 6,675,000 - - - - - - - 50,000 10,665,310 Fines and forfeitures 975,000 - - - - - - - - - 975,000 investment income 120,000 75,000 - - 300 200 - 20,000 - 88,300 303,800 Other revenue 477,900 - - - 134,061 5,000 4,850 - - - 621,811 Transfers 100,000 - - - - - - - - 200,000 300,000 Debt issued - - - - - - - - - 2,917,200 2,917,200 Other financing sources - - TOTAL REVENUES AND OTHER FINANCING SOURCES $ 36,683,508 $ 9,250,000 $ 1,200,000 $ 125,000 $ 170,361 $ 5,200 $ 24,850 $ 7,212,849 $ - $ 8,978,372 $ 63,650,140 EXPENDITURES AND OTHER FINANCING USES - BY DEPARTMENT Administration $ 1,896,514 $ 8,276,838 $ - $ - $ - $ - $ - $ - $ - $ 65,000 $ 10,238,352 Communication & tech. 1,143,885 - - - - - - - - 211,900 1,355,785 Human resources 789,693 - - - - - - - - 150,000 939,693 Finance 833,132 - - - - - - - - 25,000 858,132 Public works 8,959,162 - - - - - - - 104,000 1,226,395 10,289,557 Engineering 1,585,022 - 1,252,566 - - - - - - 6,320,000 9,157,588 Police 11,003,014 - - - 174,000 - - - - 1,038,845 12,215,859 Fire 7,453,851 - - - - - - - - 422,000 7,875,851 Parks & recreation 1,373,261 - - - - 22,425 - - 333,000 1,728,686 Community development 1,645,974 - - 125,000 - - - - - - 1,770,974 Debt service - - - - - - - 6,008,988 - - 6,008,988 Transfers - - - - 68,100 68,100 TOTAL EXPENDITURES AND OTHER FINANCING USES $ 36,683,508 $ 8,276,838 $ 1,252,566 $ 125,000 $ 174,000 $ - $ 22,425 $ 6,008,988 $ 104,000 $ 9,860,240 $ 62,507,565 EXPENDITURES AND OTHER FINANCING USES - BY TYPE Personal services $ 25,811,380 $ 123,973 $ 112,566 $ - $ - $ - $ - $ - $ - $ 102,956 $ 26,150,875 Contractual services 4,894,026 226,865 20,000 125,000 104,000 - 20,400 - - 148,522 5,538,813 Commodities 2,082,840 1,000 20,000 - 15,000 - 2,025 - - 73,522 2,194,387 Central services 3,895,262 - - - - - - - - - 3,895,262 Equipment - - - - - - - - - 2,138,140 2,138,140 Capital outlay - 7,925,000 1,100,000 - 55,000 - - - 104,000 7,329,000 16,513,000 Debt service - - - - - - - 6,008,988 - - 6,008,988 Transfers - - - 68,100 68,100 TOTAL EXPENDITURES AND OTHER FINANCING USES $ 36,683,508 $ 8,276,838 $ 1,252,566 $ 125,000 $ 174,000 $ - $ 22,425 $ 6,008,988 $ 104,000 $ 9,860,240 $ 62,507,565 CHANGE IN FUND BALANCE $ - $ 973,162 $ (52,566) $ - $ (3,639) $ 5,200 $ 2,425 $ 1,203,861 $ (104,000) $ (881,868) $ 1,142,575 7/21/2015 C7 CITY OF EDINA Draft Governmental Fund Budgets DRAFT 2017 GOVERNMENTAL FUND BUDGETS Braemar Arts & Debt Envrionmental General HRA PACS CDBG Police SR Memorial Culture Service Efficiency Fund Fund Fund Fund Fund Fund Fund Fund Fund REVENUES AND OTHER FINANCING SOURCES Property tau levy $ 26,425,558 $ 95,000 $ - $ - $ - $ - $ 20,000 $ 4,669,500 $ - Reductions Net tax revenue 26,425,558 95,000 Total Tax increments - 2,500,000 - Franchise fees 790,000 - 1,200,000 - - Lodging Tax 20,000 - - - - Special assessments - - - - - Ucenses and permits 4,192,660 - - - - Intergovernmental 1,195,550 - - 125,000 36,000 Charges for services 4,017,973 150,000 - - - Fines and forfeitures 975,000 - - - - Investment income 120,000 60,000 - - 300 Other revenue 478,800 - - - 134,061 Transfers 50,000 - - - - Debt issued - - - - - Other financing sources Public works 9,226,381 - - - TOTAL REVENUES AND OTHER - - FINANCING SOURCES $ 38.265,541 $ 2805.000 $ 1,200,000 $ 125,000 $ 170,361 $ 20,000 4,669500 - 2,083,699 - 200 - 20,000 - 5,000 5,350 - - 5 Construction Fund Total $ 1,750,000 $ 32.960,058 1,750,000 32,960,058 - 2,500,000 100,000 2,090,000 - 20,000 1,361,088 3,444,787 25,000 4,217,660 880,000 2,236550 50,000 4,217,973 - 975,000 62,900 263,400 - 623,211 200,000 250,000 3,619,200 3,619,200 5,200 $ 25,350 $ 6,773,199 $ - $ 8,048,188 $ 57,417,839 EXPENDITURES AND OTHER FINANCING USES - BY DEPARTMENT Administration $ 1,931,816 $ 4,907433 $ - $ - $ - $ - $ - f - $ - $ 25,000 $ 6,864,249 Communication & tech. 1,281,365 - - - - - - - - 1,288,900 1570,265 Human resources 811,495 - - - - - - - - 811,495 Finance 879,089 - - - - - - - 25,000 904,089 Public works 9,226,381 - - - - - - - 1,029,262 10,255,643 Engineering 1,639,062 - 1,167,265 - - - - - - 5,545,000 8,351,327 Police 11,366,656 - - 113,000 - - - - 566,925 12,046,581 Fire 7,730,126 - - - - - - - - 273,000 8,003,126 Parks & recreation 1,458,426 - - - - - 22,450 - - 1,742,325 3,223,201 Community development 1,806,125 - - 125,000 - - - - 30,000 1,961,125 Debt service 179,315 - - 6,179,315 Transfers - - - - - - 71,295 71,295 TOTAL EXPENDITURES AND OTHER FINANCING USES $ 38,130541 $ 4,907,433 $ 1,167,265 $ 125,000 $ 113,000 $ - $ 22,450 $ 6,179,315 $ 71,295 $ 10,525,412 $ 61,241,711 EXPENDITURES AND OTHER FINANCING USES - BY TYPE Personal services $ 26,764,679 $ 129,068 $ 117,265 $ - $ - $ - $ - $ - $ 106,559 $ 27,117,571 Contractual services 5,272577 126,865 20,000 125,000 98,000 - 20,425 - - 146,721 5,809,588 Commodities 2,128,165 1,500 20,000 - 15.000 - 2,025 - - 71,720 2,238,410 Central services 3,965,120 - - - - - - 3,965,120 Equipment - - - - - - - - 1,456,412 1,456,412 Capital outlay - 4,650,000 1,010,000 - - - - - 8,744,000 14,404,000 Debt service - - - - - - 6,179,315 - - 6,179,315 Transfers 71,295 71,295 TOTAL EXPENDITURES AND OTHER FINANCING USES $ 38,130541 $ 4,907,433 $ 1,167,265 $ 125,000 $ 113,000 $ - $ 22,450 $ 6,179,315 $ 71,295 $ 10,525,412 $ 61,241,711 CHANGE IN FUND BALANCE $ 135,000 $ (2,102,433) $ 32,735 $ - $ 57,361 $ 5,200 $ 2,900 $ 593,884 $ (71,295) $ (2,477,224) $ (3,823,872) 712112015 CITY OF EDINA Draft Enterprise Fund Budgets 2016 ENTERPRISE FUND BUDGETS Aquatic Golf Utilities Liquor Center Course Arena Fund Fund Fund Fund Fund s Sports Art Dome Center Edinborough Centennial Fund Fund Fund Fund Total is REVENUES AND TRANSFERS IN Operating revenues $ 19,604,773 $ 12,414,257 $ 975,477 $ 2,955,168 $ 2,230,250 $ 396,310 $ 453,350 $ 1,350,800 $ 778,000 $ 41,158,385 Intergovernmental 297,000 - - - - - - - - 297,000 Investment income 74,237 - 7,000 2,000 3,000 3,000 14,000 5,000 108,237 Other revenue 10,000 10,000 - - - 1,500 - - 21,500 Transfers - 200,000 - 200,000 33,100 135,000 568,100 TOTAL REVENUES AND TRANSFERS IN $ 19,986,010 $ 12,424,257 $ 982,477 $ 2,955,168 $ 2,432,250 $ 399,310 $ 657,850 $ 1,397,900 $ 918,000 $ 42,153,222 EXPENSES AND TRANSFERS OUT - BY DEPARTMENT Administration $ - $ 11,755,283 $ $ $ - $ - $ - $ - $ - $ 11,755,283 Finance 298,393 - 298,393 Public works 14,637,390 14,637,390 Engineering 274,096 274,096 Police 496,454 496,454 Parks and recreation - - 913,673 3,193,133 2,607,443 721,422 680,631 1,610,457 1,059,934 10,786,693 Transfers 100,000 700,000 - - - - - - 800,000 TOTAL EXPENSES AND TRANSFERS OUT $ 15,806,333 $ 12,455,283 $ 913,673 $ 3,193,133 $ 2,607,443 $ 721,422 $ 680,631 $ 1,610,457 $ 1,059,934 $ 39,048,309 EXPENSES AND TRANSFERS OUT - BY TYPE COGS $ - $ 9,326,730 $ 42,000 $ 185,599 $ 105,500 $ - $ 2,750 $ 85,000 $ 14,000 $ 9,761,579 Personal services 2,041,750 1,492,365 331,305 1,356,923 871,133 58,272 439,729 774,962 635,066 8,001,505 Contractual services 7,211,595 517,906 179,200 490,794 729,950 148,180 106,350 352,250 183,925 9,920,150 Commodities 1,065,750 74,009 89,150 313,990 104,250 3,277 71,250 169,800 135,800 2,027,276 Central services 684,075 249,773 28,495 121,423 65,428 11,693 36,552 56,695 51,143 1,305,277 Depreciation 4,227,000 94,500 241,500 640,000 600,000 500,000 24,000 171,750 40,000 6,538,750 Interest 476,163 - 2,023 84,404 131,182 - - - - 693,772 Transfers 100,000 700,000 - - - - - 800,000 TOTAL EXPENSES AND TRANSFERS OUT $ 15,806,333 $ 12,455,283 $ 913,673 $ 3,193,133 $ 2,607,443 $ 721,422 $ 680,631 $ 1,610,457 $ 1,059,934 $ 39,048,309 CHANGE IN NET POSITION $ 4,179,677 $ (31,026) $ 68,804 $ (237,965) $ (175,193) $ (321112) $ (22,781) $ (211557) $ (141,934) $ 3,104,913 • 7/21/2015 CITY OF EDINA 7 Draft Enterprise Fund Budgets F- -7 J CHANGE IN NET POSITION $ 4,368,032 $ (89,860) $ 88,129 $ (733,343) $ (194,207) $ (329,117) $ (44,298) $ (200,846) $ (88,246) $ 2,776,244 7/21/2015 2017 ENTERPRISE FUND BUDGETS Aquatic Golf Sports Art Utilities Liquor Center Course Arena Dome Center Edinborough Centennial Fund Fund Fund Fund Fund Fund Fund Fund Fund Total REVENUES AND TRANSFERS IN Operating revenues $ 20,580,555 $ 12,667,946 $ 1,014,186 $ 1,273,301 $ 2,250,500 $ 401,810 $ 453,350 $ 1,362,800 $ 784,000 $ 40,788,448 Intergovernmental 112,000 - - - - - - - - 112,000 Investment income 79,889 - 3,000 4,000 5,000 3,000 13,000 5,000 112,889 Other revenue 10,000 10,000 - - - 1,500 - - 21,500 Transfers - - - 200,000 200,000 71,295 200,000 671,295 TOTAL REVENUES AND TRANSFERS IN $ 20,782,444 $ 12,677,946 $ 1,017,186 $ 1,273,301 $ 2,454,500 $ 406,810 $ 657,850 $ 1,447,095 $ 989,000 $ 41,706,132 EXPENSES AND TRANSFERS OUT - BY DEPARTMENT Administration $ - $ 12,017,806 $ - $ - $ - $ - $ - $ - $ - $ 12,017,806 Finance 309,404 - 309,404 Public works 15,219,534 15,219,534 Engineering 278,254 278,254 Police 507,220 507,220 Parks and recreation - - 929,057 2,006,644 2,648,707 735,927 702,148 1,647,941 1,077,246 9,747,670 Transfers 100,000 750,000 - - - - - - 850,000 TOTAL EXPENSES AND TRANSFERS OUT $ 16,414,412 $ 12,767,806 $ 929,057 $ 2,006,644 $ 2,648,707 $ 735,927 $ 702,148 $ 1,647,941 $ 1,077,246 $ 38,929,888 EXPENSES AND TRANSFERS OUT - BY TYPE COGS $ - $ 9,517,071 $ 42,000 $ 37,120 $ 105,500 $ - $ 2,750 $ 85,000 $ 14,000 $ 9,803,441 Personal services 2,123,424 1,551,432 343,354 584,204 905,311 60,424 456,631 807,256 661,099 7,493,135 Contractual services 7,499,526 526,879 179,200 367,175 729,950 149,930 107,950 351,750 183,925 10,096,285 Commodities 1,116,700 75,032 89,150 104,085 104,750 3,725 73,800 169,800 123,800 1,860,842 Central services 697,990 Depreciation 4,499,500 252,892 94,500 28,840 246,500 123,021 710,000 66,262 610,000 11,848 510,000 37,017 24,000 57,385 176,750 51,922 42,500 1,327,177 6,913,750 Interest 377,272 13 81,039 126,934 - - - 585,258 Transfers 100,000 750,000 - - - - 850,000 TOTAL EXPENSES AND TRANSFERS OUT $ 16,414,412 $ 12,767,806 $ 929,057 $ 2,006,644 $ 2,648,707 $ 735,927 $ 702,148 $ 1,647,941 $ 1,077,246 $ 38,929,888 CHANGE IN NET POSITION $ 4,368,032 $ (89,860) $ 88,129 $ (733,343) $ (194,207) $ (329,117) $ (44,298) $ (200,846) $ (88,246) $ 2,776,244 7/21/2015 CITY OF EDINA Draft Tax Levies Total Property Tax Levy Increases vs. General Fund Expenditures 10.00% Braemar Field Levy Liquor 8.00% revenue 6.00 decrease 4.00% 2.00% 0.00% 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 ■ Total Levy Increase % ■ Change in expenditures Future wants and needs not included in projection above: $450K New employee requests other than GIS $300-$500K GIS Coordinator plus CIP items $500K Replacement for park maintenance fees *$300K-$1 M CIP levy *$200K Deferred street maintenance $350K Weber Woods (3 years only) *$? Grandview capital & operating *$? Fred Richards plan & capital $? Braemar Park plan & capital * denotes 2016-2017 work plan item Estimated Additional Impact 1.5% 1.5%-2% 1.5% 1%-3% <1% 1% 0%-? 0%-? 0%-? G:\Budget and CIP\2016 Budget\Meetings\20150721 Council work session\2016 Summary charts - Draft.xlsx 7/20/2015 is 0 0 ply oK` e l���� The CITY of _4 EDINA 2016-2017 Budget Process Update July 21, 20 15 Council Work Session Agenda • Definitions Process and Timeline Budget Challenges HRA Levy • Tax Comparisons www.EdinaMN.gov a� et , The CITY of EDINA Definitions >>�..�. M The CITY of �e �y EDINA • ^��MII`��IIA��"• • General Fund: The main operating fund of the City's government functions. Includes about $37M of revenues and expenditures. • Governmental Funds: In addition to the general fund, the City has a debt service fund, construction fund, HRA fund, and several special revenue funds.Annual expenditures are about $62M. • Enterprise Funds: Used to account for "business -type" activities. Total annual expenses equal about $39M • Consolidated Budget: Approximately $1 OOM in total revenues and expenditures/expenses and includes all City and HRA funds, governmental and enterprise. www.EdinaMN.gov 3 The CITY of Definitions EDINA I M• 4� $1 00M • �lr �rrrlY sir I' In www.EdinaMN.gov Definitions eThe CITY of ti EDINA • Estimated Market Value: One way to measure "tax base".The City Assessor estimates values for each property in Edina.The total EMV of all properties in Edina is around $1 OB. • Tax Capacity: A second way to measure'tax base".Tax capacity is a uniquely Minnesotan way of calculating property taxes.Tax capacity uses EMV and property classifications so that different types of property are taxed differently. www.EdinaMN.gov 5 '% The CITY of e . . y Deflnitions EDINA • Total City Property Tax Levy or Levies: Often escribed as one, but the City actually has several different levies organized by purpose. • General Fund Property Tax Levy: The dollar amount that the City needs from property taxes to pay for General Fund expenditures. About $25M of the $37M General Fund budget (68%). • Debt Levies: Edina has several debt levies that go towards principal and interest payments on some of the City's debt.The City also has debt that is paid by revenue other than property taxes, like our utility fund debt and special assessment debt. • Other Levies: Arts & culture, equipment, and HRA are examples. www.EdinaMN.gov 6 Agenda • Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons www.EdinaMN.gov tiv�til 07, � " The CITY of N WN EDI A Work Plan Drives Budget Work Plan Themes www.EdinaMN.gov Work Plan Goals i e~t The CITY of w EDINA Budget.7• Staff BudgetTimeline ��` The CITY of Ale i. s EDINA April 21 ' City Manager presents 2016-2017 proposed work plan to Council May 15 Department Heads send budget requests to Finance July 8 ELT reviews 2016-2017 budget draft July 21 City Manager presents 2016-2017 budget draft to Council Aug. 18 or City Council adopts new WAC/SAC charges and utility rates based on Sept. I the rate study discussed on July 7 Sept. 16 City Council adopts preliminary 2016 property tax levy and budget Dec. I Public Hearing & option to adopt 2016 final property tax levy and budget. Dec. 15 Deadline to adopt final 2016 property tax levy and budget www.EdinaMN.gov 9 Agenda • Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons I- e "t. The CITY of s J EDINA www.EdinaMN.gov 10 2016-2017 Budget Challenges VNNn. �1 — The CITY of EDINA Minimum wage increase affects many positions in Edina. i 11.5% rate cap for health insurance premiums.Lf -C), • FT employee count increased by I since last budget cycle, but 5.45 increase in the General Fund is offset by a 4.45 decrease elsewhere. ® Edinborough & Centennial Lakes reserve balances are projected to decrease. i Liquor profits are lower than past years - 2014 budgeted transfer was $1,800,100 but actual was $1,035,000 - 2015 budgeted transfer is $1,850,100 but actual will likely be less than $1 M - Draft 2016 budgeted transfer is about $1.15M less than 2015 budget www.EdinaMN.gov �-,X1 �J The CITY of e 2016-2017 Budget Challenges .W EDINA • 2014 General Fund unassigned fund balance was $708,294.This is lower than in the past, which affects our CIP funding. • Services and expectations are increasing for all departments is Budget draft today would result in about an 7.25% total property tax levy increase — new staff requests not included (5 total FT staff requests) — GIS not included —Weber Woods and many work plan items also not included — Street sweeping expenses are being moved to Storm Utility fund ® Council and staff have identified many possibilities, but priorities may need to be adjusted. www.EdinaMN.gov 12 2016-2017Worl< Plan Themes Focused Redevelopment The CITY of EDINA - PW site decision with community space + financing by 3/1/16 - Hwy 100 lid study completed by 12/31/17 - Fred Richards plan + financing by 12/31/16 • Future Planning - Comprehensive plan draft complete by 12/31/17 • Intergovernmental Relations www.EdinaMN.gov 13 The CITY of er r 2016-2017 Work Plan Themes EDINA • Transportation & Infrastructure - Complete Grandview transportation study & plan by 12/31/17 - Complete construction of street or woonerf - Start construction on WTP #5 in 2017 - Study S'dale sanitary capacity & implement plan by 2017 - Convert debt retirement in 2017 into CIP funding - Consider increasing franchise fees for streets by 12/31/16 • Enterprise Stability - Complete business plans for each enterprise www.EdinaMN.gov 14 Budget Summary 10.00% 8.00% 6.00% 4.00% 2.00 0.00 \,\N�A' M ^f" The CITY of e, Cr EDINA Total Property Tax Levy Increases vs. General Fund Expenditures Braemar Liquor 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 ■ Total Levy Increase % ■ Change in expenditures www.EdinaMN.gov 15 Agenda • Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons e ��� The CITY of �° EDINA www.EdinaMN.gov 16 HRA Levy for 2017 e , f �? The CITY of s EDINA • State law allows an HRA to levy up to 0.0 185 % the previous year's taxable market value of all property in the City.This limit would produce tax revenue of about $1.8M in Edina. An HRA raises its own levy separate from the City, and the HRA levy is not subject to levy limits (other than above) Levies collected by an HRA must be used only for purposes listed in the HRA Act. A $95,000 HRA levy in Edina would be $4/year for a median single family home ($457,300) Sources: LMC Handbook for Cities, Edina Finance Dept., & Edina Assessing Division www.EdinaMN.gov 17 Agenda • Definitions • Process and Timeline • Budget Challenges • HRA Levy • Tax Comparisons % Estimated MarketValue (EMV) $1,000,000,000 $800,000,000 7.5% $600,000,000 $400,000,000 $200,000,000tO. 7% $(200,000,000) $(400,000,000) $(600 000 000) �vj Ami The CITY of =� !!!� EDINA Edina EMV Property Tax Base Growth 9.4% 7.2% 4.5% 2.5% 1.4% 1.7% 1.9% 1.2% L•6% 0 1.0/ ` M 0 0.7% 0.7% 0.9% _ 1.3% -0.5% , 1 , , 0.0% -3.4% -3.5% -3.6% -5.9% $(800,000,000) 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 ■ Inflation/deflation due to real estate market forces ■ Growth due to improvements Source: City Assessor's Office and Hennepin County www.EdinaMN.gov 19 Annual PropertyTaxes $6,000 $5,000 $4,522 $4,000 $3,000 $2,000 $1,000 v�I's1 The CITY of r" ED INA $400,000 Edina Home Property Tax History $5,610 $4,094 $999 $872 $1,141 2005 2006 2007 2008 2009 2010 2011 City tax Total tax Source: LMC Property Tax Calculator 7/20/15 2012 2013 2014 2015 www.EdinaMN.gov 20 Source: LMC Property Tax Calculator 7/20/15 & CityAssesor's Office www.EdinaMN.gov 21 2007 " `� The CITY of Annual PropertyTaxes =,. .�yEDINA 2013 2014 2015 2016 City tax $944 "Median" Edina Home Property Tax History $1,020 $7,000 $1,082 $1,102 $5,861 $6,000 $1,268 Total tax $4,435 $5,000 $4,435 $4,922 $5,066 $4,000 $5,449 $5,606 $5,861 $3,000 Median Value $433,300 $444,800 $2,000 $944 $411,500 $1,195 $1,268 $1,000 $399,700 $438,800 $457,300 Source: LMC Property Tax Calculator 7/20/15 & CityAssesor's Office www.EdinaMN.gov 21 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 City tax $944 $970 $1,012 $1,020 $1,042 $1,082 $1,102 $1,140 $1,195 $1,268 Total tax $4,435 $4,597 $4,725 $4,922 $5,066 $5,410 $5,449 $5,606 $5,861 Median Value $433,300 $444,800 $439,000 $432,700 $411,500 $403,100 $396,300 $399,700 $438,800 $457,300 Source: LMC Property Tax Calculator 7/20/15 & CityAssesor's Office www.EdinaMN.gov 21 2016 Estimated Levy Impacts o�v e The CITY of r EDINA • In 2015 the median home pays about $100 per month in property taxes to fund all of the City provided services. • Tax capacity is increasing in Edina by about 6% for taxes payable in 2016.The median value single family home is now $457,300. • If the budget includes an 7.25% property tax increase, the effect on the $457,300 single family home would be about: - about 6% increase in City property taxes. - about $73 increase per year, or about $6 per month. - this home would pay about $106 per month in 2016 City property taxes. www.EdinaMN.gov 22 A. / e �The CITY of Governmental Revenue Per Capita R'EDINA I Plymouth $ 684.12 2 Minnetonka $ 875.60 3 Eden Prairie $ 881.88 4 Richfield $ 987.76 5 Edina $ 1,011.63 6 Hopkins $ 1,147.21 7 Maple Grove $ 1,192.77 8 St. Louis Park $ 1,240.14 9 Bloomington $ 1,488.13 10 Golden Valley $ 1,435.72 II Minneapolis $ 2,020.35 Source: MN State Auditor website 7/7/15 www.EdinaMN.gov 23 PropertyTax Revenue Per Capita I Plymouth $ 399.98 2 Maple Grove $ 492.27 3 Richfield $ 515.37 4 Eden Prairie $ 520.78 5 Bloomington $ 541.53 6 St. Louis Park $ 542.23 7 Edina $ 546.40 8 Hopkins $ 575.73 9 Minnetonka $ 606.30 10 Minneapolis $ 773.91 11 Golden Valley $ 814.57 Source: MN State Auditor website 7/7/15 The CITY of �e r EDINA www.EdinaMN.gov 24 City Property Taxes I Edina* $ 1,141 2 Plymouth* $ 1,202 3 Eden Prairie* $ 1,424 4 Shoreview* $ 1,495 5 Minnetonka* $ 1,559 6 Eagan* $ 1,593 7 Woodbury* $ 1,622 8 Lakeville* $ 1,650 9 Shakopee* $ 1,673 10 Maple Grove* $ 1,685 11 Inver Grove Heights* $ 1,859 The CITY of e� EDINA 12 Burnsville* $ 1,861 13 St. Louis Park $ 1,937 14 Bloomington* $ 1,941 15 Apple Valley* $ 1,995 16 Maplewood* $ 2,008 17 Savage* $ 2,269 18 Golden Valley $ 2,466 19 Hopkins $ 2,496 20 Richfield $ 2,571 21 Minneapolis $ 2,976 Source: LMC Property Tax calculator 7/7/15 *City is a member of the MLC www.EdinaMN.gov 25 CITY OF EDINA Draft Tax Levies G:\Budget and CIP\2016 Budget\Meetings\20150721 Council work session\2016 Summary charts - Draft.xlsx 7/21/2015 Draft Budget Draft Budget 2013 2014 2015 2016 2017 General Fund Levies General Operating Levy $ 21,824,894 $ 22,509,403 $ 22,933,958 $ 25,045,588 $ 26,425,558 General Fund Subtotal 21,824,894 22,509,403 22,933,958 25,045,588 26,425,558 Increase From Prior Year (%) 1.02% 3.14% 1.89% 9.21% 5.51% Arts and Culture Fund Levies Arts and Culture - - 20,000 20,000 20,000 Arts and Culture Fund Subtotal - - 20,000 20,000 20,000 Increase From Prior Year (%) 0.00% 0.00% Debt Service Fund Levies City Hall Debt Service 949,850 947,600 944,400 946,000 946,000 Equipment Certificates - - - - - Gymnasium Debt Service 396,444 409,244 409,440 417,000 422,000 Fire Station Debt Service 431,544 441,944 441,940 443,000 443,000 Public Works Facility Debt Service 1,536,743 1,526,809 1,546,600 1,561,000 1,696,000 Park Bond Market Value Levy 615,837 627,800 618,600 571,650 - Sports Dome - - 1,168,000 1,170,500 1,162,500 Debt Service Fund Subtotal 3,930,418 3,953,397 5,128,980 5,109,150 4,669,500 Increase From Prior Year (%) 7.63% 4.31% 29.74% -0.39% -8.61% Construction Fund Levies Equipment Levy 992,072 992,072 1,617,072 1,680,000 1,750,000 Construction Fund Subtotal 992,072 992,072 1,617,072 1,680,000 1,750,000 Increase From Prior Year (%) 0.00% 0.00% 63.00% 3.89% 4.17% HRA Fund Levies HRA Operating Levy - - - - 95,000 HRA Fund Subtotal - - - - 95,000 Increase From Prior Year (%) Total Property Tax Levy $ 26,747,384 $ 27,454,872 $ 29,700,010 $ 31,854,738 $ 32,960,058 Increase From Prior Year (%) 1.90% 2.65% 8.18% 7.25% 3.47% G:\Budget and CIP\2016 Budget\Meetings\20150721 Council work session\2016 Summary charts - Draft.xlsx 7/21/2015 EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY DEPARTMENT Administration $ 23,125,572 $ CITY OF EDINA $ 21,993,635 22.5% 2 18,882,055 Consolidated Draft Budget Communications & tech. 1,205,409 1,506,574 2014 201S Draft 2016 Draft 2017 89.6% Human resources Actual Budget Budget 939,693 Budget REVENUES AND OTHER FINANCING SOURCES -13.6% Finance 1,015,847 1,191,299 Property tax levy $ 26,988,493 $ 29,700,010 $ 31,854,738 7.3% $ 32,960,058 3.5% Reductions - (123,000) - -100.0% - NA Net tax revenue 26,988,493 29,577,010 31,854,738 7.7% 32,960,058 3.5% Tax increments 5,052,705 100,000 2,500,000 2400.0% 2,500,000 0.0% Franchise fees 2,055,396 2,070,000 2,090,000 1.0% 2,090,000 0.0% Lodging tax 11,301 - 20,000 NA 20,000 0.0% Special assessments 4,606,010 3,992,997 3,321,571 -16.8% 3,444,787 3.7% Licenses and permits 4,583,183 3,880,080 4,048,160 4.3% 4,217,660 4.2% Intergovernmental 4,294,999 5,169,825 4,329,550 -16.3% 2,348,550 -45.8% Charges for services 4,270,720 4,019,494 10,665,310 165.3% 4,217,973 -60.5% Fines and forfeitures 1,163,907 950,000 975,000 2.6% 975,000 0.0% Operating revenue 39,886,753 42,823,745 41,158,385 -3.9% 40,788,448 -0.9% Investment income 632,025 463,956 412,037 -11.2% 376,289 -8.7% Other revenue 1,604,975 1,188,448 643,311 -45.9% 644,711 0.2% Debt issued 21,335,000 4,599,895 2,917,200 -36.6% 3,619,200 24.1 Other financing sources 218,699 - - NA - NA TOTAL REVENUES AND OTHER 14,253,910 15,458,963 8.5% 15,905,873 FINANCING SOURCES $ 116.704.166 $ 98.835.450 $ 104.935.262 6.2% $ 98.202.676 -6.4% EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY DEPARTMENT Administration $ 23,125,572 $ 17,960,549 $ 21,993,635 22.5% $ 18,882,055 -14.1% Communications & tech. 1,205,409 1,506,574 1,355,785 -10.0% 2,570,265 89.6% Human resources 979,873 695,637 939,693 35.1% 81 1,495 -13.6% Finance 1,015,847 1,191,299 1,156,525 -2.9% 1,213,493 4.9% Public works 24,213,569 22,913,578 24,926,947 8.8% 25,475,177 2.2% Engineering 7,796,629 13,926,591 9,431,684 -32.3% 8,629,581 -8.5% Police 11,081,717 11,764,823 12,712,313 8.1% 12,553,801 -1.2% Fire 6,965,287 7,134,947 7,875,851 10.4% 8,003,126 1.6% Parks & recreation 12,933,141 13,244,427 12,515,379 -5.5% 12,970,871 3.6% Community development 1,543,486 1,742,160 1,770,974 1.7% 1,961,125 10.7% Debt service 7,105,222 6,654,894 6,008,988 -9.7% 6,179,315 2.8% TOTAL EXPENDITURES, EXPENSES AND OTHER FINANCING USES $ 97,965,752 $ 98,735,479 $ 100,687,774 2.0% $ 99,250,304 -1.4% EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY TYPE Cost of goods sold $ 10,440,199 $ 10,696,828 $ 9,761,579 -8.7% $ 9,803,441 0.4% Personal services 31,436,091 32,759,604 34,152,380 4.3% 34,610,706 1.3% Contractual services 15,439,638 14,253,910 15,458,963 8.5% 15,905,873 2.9% Commodities 3,590,164 3,853,162 4,221,663 9.6% 4,099,252 -2.9% Central services 4,872,724 5,154,924 5,200,539 0.9% 5,292,297 1.8% Equipment 1,468,320 1,746,978 2,138,140 22.4% 1,456,412 -31.9% Capital outlay 18,414,824 17,395,224 16,513,000 -5.1% 14,404,000 -12.8% Depreciation 5,198,570 5,471,750 6,538,750 19.5% 6,913,750 5.7% Debt service 7,105,222 7,403,099 6,702,760 -9.5% 6,764,573 0.9% TOTAL EXPENDITURES, EXPENSES AND OTHER FINANCING USES $ 97,965,752 $ 98,735,479 $ 100,687,774 2.0% $ 99,250,304 -1.4% CHANGE IN FUND BALANCE OR NET POSITION $ 18,738,414 $ 99,971 $ 4,247,488 $ (1,047,628) 7/21/2015 CITY OF EDINA Draft Budget by Fund Type Draft 2016 Governmental Enterprise Funds Funds Total REVENUES AND OTHER FINANCING SOURCES OTHER FINANCING USES - 32,960,058 Property tax levy $ 31,854,738 $ 2,500,000 $ 31,854,738 Reductions - 20,000 - Net tax revenue 31,854,738 Human resources 31,854,738 Tax increments 2,500,000 4,217,660 2,500,000 Franchise fees 2,090,000 4,217,973 2,090,000 Lodging Tax 20,000 - 20,000 Special assessments 3,321,571 40,788,448 3,321,571 Licenses and permits 4,048,160 623,211 4,048,160 Intergovernmental 4,032,550 297,000 4,329,550 Charges for services 10,665,310 - 10,665,310 Fines and forfeitures 975,000 - 975,000 Operating revenue - 41,158,385 41,158,385 Investment income 303,800 108,237 412,037 Other revenue 621,811 21,500 643,311 Transfers 300,000 568,100 868,100 Debt issued 2,917,200 2,917,200 Other financing sources - $ - TOTAL REVENUES AND OTHER OTHER FINANCING USES - BY TYPE FINANCING SOURCES $ 63,650,140 $ 42,153,222 $ 105,803,362 c3 Draft 2017 Budget Governmental Enterprise Funds Funds Total $ 32,960,058 $ - $ 32,960,058 32,960,058 OTHER FINANCING USES - 32,960,058 2,500,000 10,238,352 $ 2,500,000 2,090,000 21,993,635 2,090,000 20,000 - 20,000 3,444,787 Human resources 3,444,787 4,217,660 278,254 4,217,660 2,236,550 112,000 2,348,550 4,217,973 - 4,217,973 975,000 - 975,000 - 40,788,448 40,788,448 263,400 112,889 376,289 623,211 21,500 644,711 250,000 671,295 921,295 3,619,200 - 3,619,200 EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY FUNCTION Administration $ 10,238,352 $ 11,755,283 $ 21,993,635 Communication & tech. 1,355,785 - 1,213,493 1,355,785 Human resources 939,693 - 278,254 939,693 Finance 858,132 298,393 8,003,126 1,156,525 Public works 10,289,557 14,637,390 12,970,871 24,926,947 Engineering 9,157,588 274,096 - 9,431,684 Police 12,215,859 496,454 12,712,313 Fire 7,875,851 - 7,875,851 Parks & recreation 1,728,686 10,786,693 12,515,379 Community development 1,770,974 - 1,770,974 Debt service 6,008,988 - 6,008,988 Transfers 68,100 800,000 868,100 TOTAL EXPENDITURES, EXPENSES AND OTHER FINANCING USES $ 62,507,565 $ 39,048,309 $ 101,555,874 EXPENDITURES, EXPENSES AND OTHER FINANCING USES - BY TYPE Cost of goods sold $ - $ 9,761,579 $ 9,761,579 Personal services 26,150,875 8,001,505 34,152,380 Contractual services 5,538,813 9,920,150 15,458,963 Commodities 2,194,387 2,027,276 4,221,663 Central services 3,895,262 1,305,277 5,200,539 Equipment 2,138,140 - 2,138,140 Capital outlay 16513,000 - 16,513,000 Depreciation - 6,538,750 6,538,750 Debt service 6,008,988 693,772 6,702,760 Transfers 68,100 800,000 868,100 TOTAL EXPENDITURES, EXPENSES AND OTHER FINANCING USES $ 62,507,565 $ 39,048,309 $ 101,555,874 CHANGE IN FUND BALANCE OR NET POSITION $ 1,142,575 $ 3,104,913 $ 4,247,488 $ 57,417,839 $ 41,706,132 $ 99,123,971 6,864,249 $ 12,017,806 $ 18,882,055 2,570,265 - 2,570,265 811,495 - 811,495 904,089 309,404 1,213,493 10,255,643 15,219,534 25,475,177 8,351,327 278,254 8,629,581 12,046,S81 S07,220 12,553,801 8,003,126 - 8,003,126 3,223,201 9,747,670 12,970,871 1,961,125 - 1,961,125 6,179,315 - 6,179,315 71,295 850,000 921,295 $ 61,241,711 $ 38,929,888 $ 100,171,599 - $ 9,803,441 $ 9,803,441 27,117,571 7,493,135 34,610,706 5,809,S88 10, 096, 285 15,905,873 2,238,410 1,860,842 4,099,252 3,965,120 1,327,177 5,292,297 1,456,412 - 1,456,412 14,404,000 - 14,404,000 - 6,913,750 6,913,750 6,179,315 585,258 6,764,573 71,295 850,000 921,295 $ 61,241,711 $ 38,929,888 $ 100,171,599 $ (3,823,872) $ 2,776,244 $ (1,047,628) 7/21/2015 CITY OF EDINA 4 Draft Governmental Fund Budgets DRAFT 2016 GOVERNMENTAL FUND BUDGETS FUND BALANCE $ - $ 973,162 $ (52,566) $ - $ (3,639) $ 5,200 $ 2,425 $ 1,203,861 $ (104,000) $ (881,868) $ 1,142,575 7/21/2015 Braemar Arts & Debt Environmental General HRA PACS CDBG Police SR Memorial Culture service Efficiency Construction Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Total REVENUES AND OTHER FINANCING SOURCES Property tax levy $ 25,045,588 $ - $ - $ - $ - $ - $ 20,000 $ 5,109,150 $ - $ 1,680,000 $ 31,854,738 Reductions - - - - - - Net tax revenue 25,045,588 - - 20,000 5,109,150 - 1,680,000 31,854,738 Tax increments - 2,500,000 - - - - - - - - 2,500,000 Franchise fees 790,000 - 1,200,000 - - - - - - 100,000 2,090,000 Lodging Tax 20,000 - - - - - - - - - 20,000 Special assessments - - - - - - - 2,083,699 - 1,237,872 3,321,571 Licenses and permits 4,023,160 - - - - - - - - 25,000 4,048,160 Intergovernmental 1,191,550 - - 125,000 36,000 - - - - 2,680,000 4,032,550 Charges for services 3,940,310 6,675,000 - - - - - - - 50,000 10,665,310 Fines and forfeitures 975,000 - - - - - - - - - 975,000 Investment income 120,000 75,000 - - 300 200 - 20,000 - 88,300 303,800 Other revenue 477,900 - - - 134,061 5,000 4,850 - - - 621,811 Transfers 100,000 - - - - - - - - 200,000 300,000 Debt issued - - - - - - - - - 2,917,200 2,917,200 Other financing sources - - - - - - TOTAL REVENUES AND OTHER FINANCING SOURCES $ 36,683,508 $ 9,250,000 $ 1,200,000 $ 125,000 $ 170,361 $ 5,200 $ 24,850 $ 7,212,849 $ - $ 8,978,372 $ 63,650,140 EXPENDITURES AND OTHER FINANCING USES - BY DEPARTMENT Administration $ 1,896,514 $ 8,276,838 $ - $ - $ - $ - $ - $ - $ - $ 65,000 $ 10,238,352 Communication & tech. 1,143,885 - - - - - - - - 211,90-0 1,355,785 Human resources 789,693 - - - - - - - - 150,000 939,693 Finance 833,132 - - - - - - - - 25,000 858,132 Public works 8,959,162 - - - - - - - 104,000 1,226,395 10,289,557 Engineering 1,585,022 - 1,252,566 - - - - - - 6,320,000 9,157,588 Police 11,003,014 - - - 174,000 - - - - 1,038,845 12,215,859 Fire 7,453,851 - - - - - - - - 422,000 7,875,851 Parks & recreation 1,373,261 - - - - - 22,425 - - 333,000 1,728,686 Community development 1,645,974 - - 125,000 - - - - - - 1,770,974 Debt service - - - - - - - 6,008,988 - - 6,008,988 Transfers - - - - - - - 68,100 68,100 TOTAL EXPENDITURES AND OTHER FINANCING USES $ 36,683,508 $ 8,276,838 $ 1,252,566 $ 125,000 $ 174,000 $ - $ 22,425 $ 6,008,988 $ 104,000 $ 9,860,240 $ 62,507,565 EXPENDITURES AND OTHER FINANCING USES - BY TYPE Personal services $ 25,811,380 $ 123,973 $ 112,566 $ - $ - $ - $ - $ - $ - $ 102,956 $ 26,150,875 Contractual services 4,894,026 226,865 20,000 125,000 104,000 - 20,400 - - 148,522 5,538,813 Commodities 2,082,840 1,000 20,000 - 15,000 - 2,025 - - 73,522 2,194,387 Central services 3,895,262 - - - - - - - - - 3,895,262 Equipment - - - - - - - - - 2,138,140 2,138,140 Capital outlay - 7,925,000 1,100,000 - 55,000 - - - 104,000 7,329,000 16,513,000 Debt service - - - - - - - 6,008,988 - - 6,008,988 Transfers - - - - - 68,100 68,100 TOTAL EXPENDITURES AND OTHER FINANCING USES $ 36,683,508 $ 8,276,838 $ 1,252,566 $ 125,000 $ 174,000 $ - $ 22,425 $ 6,008,988 $ 104,000 $ 9,860,240 $ 62,507,565 CHANGE IN FUND BALANCE $ - $ 973,162 $ (52,566) $ - $ (3,639) $ 5,200 $ 2,425 $ 1,203,861 $ (104,000) $ (881,868) $ 1,142,575 7/21/2015 CITY OF EDINA Draft Governmental Fund Budgets DRAFT 2017 GOVERNMENTAL FUND BUDGETS EXPENDITURES AND OTHER FINANCING USES - BY DEPARTMENT Braemar Arcs & Debt Envrionmental Administration $ 1,931,816 $ 4,907,433 $ - $ General HRA PACS CDBG Police SR Memorial Culture Service Efficiency Construction Communication & tech. 1,281,365 - Fund Fund Fund Fund Fund Fund Fund Fund Fund Fund Total REVENUES AND OTHER FINANCING SOURCES - - - - - - 811,495 Property tax levy $ 26,425,558 $ 95,000 $ - $ - $ - $ - $ 20,000 $ 4,669,500 $ - $ 1,750,000 $ 32,960,058 Reductions - - - - - - - - 1,029,262 10,255,643 Net tax revenue 26,425558 95,000 - - - - 20,000 4,669,500 1,750,000 32,960,058 Tax increments - 2,500,000 - - - - - - - - 2500,000 Franchise fees 790,000 - 1,200,000 - - - - - - 100,000 2,090,000 Lodging Tax 20,000 - - - - - - - - - 20,000 Special assessments - - - - - - - 2,083,699 - 1,36088 3,444,787 Licenses and permits 4,192,660 - - - - - - - - 25,000 4,217,660 Intergovernmental 1,195550 - - 125,000 36,000 - - - - 880,000 2,236550 Charges for services 4,017,973 150,000 - - - - - - - 50,000 4,217,973 Fines and forfeitures 975,000 - - - - - - - - - 975,000 Investment income 120,000 60,000 - - 300 200 - 20,000 - 62,900 263,400 Other revenue 478,800 - - - 134,061 5,000 5,350 - - - 623,211 Transfers 50,000 - - - - - - - - 200,000 250,000 Debt issued - - - - - - - - - 3,619,200 3,619,200 Other financing sources - - - - - - - - 3,965,120 Equipment - TOTAL REVENUES AND OTHER - - - - - - 1,456,412 1,456,412 FINANCING SOURCES $ 38,265541 $ 2,805,000 $ 1,200,000 $ 125,000 $ 170,361 $ 5,200 $ 25,350 $ 6,773,199 $ - $ 8,048,188 $ 57,417,839 EXPENDITURES AND OTHER FINANCING USES - BY DEPARTMENT Administration $ 1,931,816 $ 4,907,433 $ - $ - $ - $ - $ - $ - $ - $ 25,000 $ 6,864,249 Communication & tech. 1,281,365 - - - - - - - 1,288,900 2,570.265 Human resources 811,495 - - - - - - - - 811,495 Finance 879,089 - - - - - - - - 25,000 904,089 Public works 9,226,381 - - - - - - - - 1,029,262 10,255,643 Engineering 1,639,062 - 1,167,265 - - - - - - 5,545,000 8,351,327 Police 11,366,656 - - - 113,000 - - - - 566,925 12,046581 Fire 7,730,126 - - - - - - - 273,000 8,003,126 Parks & recreation 1,458,426 - - - - - 22,450 - - 1,742,325 3,223,201 Community development 1,806,125 - - 125,000 - - - - - 30,000 1,961,125 Debt service - - - - - - - 6,179,315 - - 6,179,315 Transfers - 71,295 71,295 TOTAL EXPENDITURES AND OTHER FINANCING USES $ 38,130,541 $ 4,907,433 $ 1,167,265 $ 125,000 $ 113,000 $ - $ 22,450 $ 6,179,315 $ 71,295 $ 10,525,412 $ 61,241,711 EXPENDITURES AND OTHER FINANCING USES - BY TYPE Personal services $ 26,764,679 $ 129,068 $ 117,265 $ - $ - $ $ - $ - $ 106,559 $ 27,117,571 Contractual services 5,272,577 126,865 20,000 125,000 98,000 - 20,425 - - 146,721 5,809,588 Commodities 2,128,165 1,500 20,000 - 15,000 - 2,025 - - 71,720 2,238,410 Central services 3,965,120 - - - - - - - - 3,965,120 Equipment - - - - - - - - 1,456,412 1,456,412 Capital outlay - 4,650,000 1,010,000 - - - - - 8,744,000 14,404,000 Debt service - - - - - 6,179,315 - - 6,179,315 Transfers 71,295 71,295 TOTAL EXPENDITURES AND OTHER FINANCING USES $ 38,130.541 $ 4,907.433 $ 1,167,265 $ 125,000 $ 113,000 $ - $ 22,450 $ 6,179,315 $ 71,295 $ 10,525,412 $ 61,241,711 CHANGE IN FUND BALANCE $ 135,000 $ (2,102,433) $ 32,735 $ - $ 57,361 $ 5,200 $ 2,900 $ 593,884 $ (71,295) $ (2477,224) $ (3,823,872) NP4001P CITY OF EDINA Draft Enterprise Fund Budgets 6 CHANGE IN NET POSITION $ 4,179,677 $ (31,026) $ 68,804 $ (237,965) $ (175,193) $ (322,112) $ (22,781) $ (212,557) $ (141,934) $ 3,104,913 7/21/2015 2016 ENTERPRISE FUND BUDGETS Aquatic Golf Sports Art Utilities Liquor Center Course Arena Dome Center Edinborough Centennial Fund Fund Fund Fund Fund Fund Fund Fund Fund Total REVENUES AND TRANSFERS IN Operating revenues $ 19,604,773 $ 12,414,257 $ 975,477 $ 2,955,168 $ 2,230,250 $ 396,310 $ 453,350 $ 1,350,800 $ 778,000 $ 41,158,385 Intergovernmental 297,000 - - - - - - - - 297,000 Investment income 74,237 - 7,000 2,000 3,000 3,000 14,000 5,000 108,237 Other revenue 10,000 10,000 - - - 1,500 - - 21,500 Transfers - - - 200,000 - 200,000 33,100 135,000 568,100 TOTAL REVENUES AND TRANSFERS IN $ 19,986,010 $ 12,424,257 $ 982,477 $ 2,955,168 $ 2,432,250 $ 399,310 $ 657,850 $ 1,397,900 $ 918,000 $ 42,153,222 EXPENSES AND TRANSFERS OUT - BY DEPARTMENT Administration $ - $ 11,755,283 $ - $ - $ - $ - $ - $ - $ - $ 11,755,283 Finance 298,393 - 298,393 Public works 14,637,390 14,637,390 Engineering 274,096 274,096 Police 496,454 496,454 Parks and recreation - - 913,673 3,193,133 2,607,443 721,422 680,631 1,610,457 1,059,934 10,786,693 Transfers 100,000 700,000 - - - - - - - 800,000 TOTAL EXPENSES AND TRANSFERS OUT $ 15,806,333 $ 12,455,283 $ 913,673 $ 3,193,133 $ 2,607,443 $ 721,422 $ 680,631 $ 1,610,457 $ 1,059,934 $ 39,048,309 EXPENSES AND TRANSFERS OUT - BY TYPE COGS $ - $ 9,326,730 $ 42,000 $ 185,599 $ 105,500 $ - $ 2,750 $ 85,000 $ 14,000 $ 9,761,579 Personal services 2,041,750 1,492,365 331,305 1,356,923 871,133 58,272 439,729 774,962 635,066 8,001,505 Contractual services 7,211,595 517,906 179,200 490,794 729,950 148,180 106,350 352,250 183,925 9,920,150 Commodities 1,065,750 74,009 89,150 313,990 104,250 3,277 71,250 169,800 135,800 2,027,276 Central services 684,075 249,773 28,495 121,423 65,428 11,693 36.552 56,695 51,143 1,305,277 Depreciation 4,227,000 94,500 241,500 640,000 600,000 500,000 24,000 171,750 40,000 6,538,750 Interest 476,163 - 2,023 84,404 131,182 - - - - 693,772 Transfers 100,000 700,000 - - - - - - - 800,000 TOTAL EXPENSES AND TRANSFERS OUT $ 15,806,333 $ 12,455,283 $ 913,673 $ 3,193,133 $ 2,607,443 $ 721,422 $ 680,631 $ 1,610,457 $ 1,059,934 $ 39,048,309 CHANGE IN NET POSITION $ 4,179,677 $ (31,026) $ 68,804 $ (237,965) $ (175,193) $ (322,112) $ (22,781) $ (212,557) $ (141,934) $ 3,104,913 7/21/2015 CITY OF EDINA 7 Draft Enterprise Fund Budgets 2017 ENTERPRISE FUND BUDGETS Aquatic Golf Sports Art Utilities Liquor Center Course Arena Dome Center Edinborough Centennial Fund Fund Fund Fund Fund Fund Fund Fund Fund Total REVENUES AND TRANSFERS IN Operating revenues $ 20,580,555 $ 12,667,946 $ 1,014,186 $ 1,273,301 $ 2,250,500 $ 401,810 $ 453,350 $ 1,362,800 $ 784,000 $ 40,788,448 Intergovernmental 112,000 - - - - - - - - 112,000 Investment income 79,889 - 3,000 4,000 5,000 3,000 13,000 5,000 112,889 Other revenue 10,000 10,000 - - - 1,500 - - 21,500 Transfers - 200,000 - 200,000 71,295 200,000 671,295 TOTAL REVENUES AND TRANSFERS IN $ 20,782,444 $ 12,677,946 $ 1,017,186 $ 1,273,301 $ 2,454,500 $ 406,810 $ 657,850 $ 1,447,095 $ 989,000 $ 41,706,132 EXPENSES AND TRANSFERS OUT - BY DEPARTMENT Administration $ - $ 12,017,806 $ - $ - $ - $ - $ - $ - $ - $ 12,017,806 Finance 309,404 - 309,404 Public works 15,219,534 15,219,534 Engineering 278,254 278,254 Police 507,220 507,220 Parks and recreation - - 929,057 2,006,644 2,648,707 735,927 702,148 1,647,941 1,077,246 9,747,670 Transfers 100,000 750,000 - - - - - - - 850,000 TOTAL EXPENSES AND TRANSFERS OUT $ 16,414,412 $ 12,767,806 $ 929,057 $ 2,006,644 $ 2,648,707 $ 735,927 $ 702,148 $ 1,647,941 $ 1,077,246 $ 38,929,888 EXPENSES AND TRANSFERS OUT - BY TYPE COGS $ - $ 9,517,071 $ 42,000 $ 37,120 $ 105,500 $ - $ 1750 $ 85,000 $ 14,000 $ 9,803,441 Personal services 2,123,424 1,551,432 343,354 584,204 905,311 60,424 456,631 807,256 661,099 7,493,135 Contractual services 7,499,526 526,879 179,200 367,175 729,950 149,930 107,950 351,750 183,925 10,096,285 Commodities 1,116,700 75,032 89,150 104,085 104,750 3,725 73,800 169,800 123,800 1,860,842 Central services 697,990 252,892 28,840 123,021 66,262 11,848 37,017 57,385 51,922 1,327,177 Depreciation 4,499,500 94,500 246,500 710,000 610,000 510,000 24,000 176,750 42,500 6,913,750 Interest 377,272 - 13 81,039 126,934 - - - - 585,258 Transfers 100,000 750,000 - - - - - 850,000 TOTAL EXPENSES AND TRANSFERS OUT $ 16,414,412 $ 12,767,806 $ 929,057 $ 2,006,644 $ 2,648,707 $ 735,927 $ 702,148 $ 1,647,941 $ 1,077,246 $ 38,929,888 CHANGE IN NET POSITION $ 4,368,032 $ (89,860) $ 88,129 $ (733,343) $ (194,207) $ (329,117) $ (44,298) $ (200,846) $ (88,246) $ 2,776,244 7/21/2015 CITY OF EDINA Draft Tax Levies Total Property Tax Levy Increases vs. General Fund Expenditures 10.00% Braemar Field Levy Liquor 8.00% revenue 6.00% decrease 4.00% 2.00% 0.00% 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 ■ Total Levy Increase % ■ Change in expenditures Future wants and needs not included in projection above: $450K New employee requests other than GIS $300-$500K GIS Coordinator plus CIP items $500K Replacement for park maintenance fees *$300K-$ I M CIP levy *$200K Deferred street maintenance $350K Weber Woods (3 years only) *$? Grandview capital & operating *$? Fred Richards plan & capital $? Braemar Park plan & capital * denotes 2016-2017 work plan item Estimated Additional Impact 1.5% 1.5%-2% 1.5% 1%-3% <1% I% 0%-? 0%-? 0%-? G:\Budget and CIP\2016 Budget\Meetings\20150721 Council work session\2016 Summary charts - Draft.xlsx 7/20/2015