The URL can be used to link to this page

Home My WebLink AboutWK - November 19, 20191685 CROSSTOWN C I T Y O F NDOVE _ BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, November 19, 2019 Conference Rooms A & B Call to Order — Following City Council Meeting (763) 755-5100 2. 2040 Comprehensive Plan Update Discussion— Engineering/Planning/Administration 2019 Budget Progress Reports —Administration 4. 2019 City Investments Review - Administration Other Business 6. Adjournment Y 0 F O jTt L. 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GO TO: Honorable Mayor and Council bets CC: Jim Dickinson, City Administrato FROM: Joe Janish, Community Developm Di ctor SUBJECT: 2040 Comprehensive Plan Update Discussion — Engineering/Planning/ Administration DATE: November 19, 2019 DISCUSSION Metropolitan Council has reviewed the 2018 Comprehensive Plan Update. The Metropolitan Council has determined our submittal to be incomplete. On October 22, 2019 city staff discussed with the City Council a few concerns Met Council raised related to density. Utilizing feedback from the work session staff developed two options for review on November 6, 2019. Discussion at the November 6, 2019 works session resulted in staff making the following adjustments: • Staff created two new land use designations, Urban Residential Medium Low (VRML), and Urban Residential High Low (URHL). • Staff adjusted the density ranges for all land use designations: Designations Min. Units Max. Units Urban Res. Low (URL, R4) 2.2 4 Urban Res. Medium Low (URML, Ml) 4 8 Urban Res. Medium (U_RM, M2) 8 12 Urban Res. High Low (URHL, H1) 12 20 Urban Res. High (U_RH H2) 20 25 Staff re -guided an outlot within Andover Station North for Urban Residential High (URH). Staff adjusted certain parcels to Urban Residential Medium (URM) which are located along major roadways within the community, or along the railroad tracks. At the November 12, 2019 work session City Council reviewed the above changes and provided additional feedback to provide adjustments. The feedback changed proposed designations to some parcels. The proposed adjustments made by City Council on November 12, 2019 still exceed the minimum requirements of the Metropolitan Council. Initial review of the City Council's direction indicates the proposed land use designations provide for an overall density of 3.13 (Met Council is looking for 3.0) and could provide for 466 Affordable Housing units (Met Council is looking for 363). City Council has the ability to still lower some of the proposed land use designations and still meet the minimum requirements of the Met Council. Staff will be present to discuss this in further detail at the work session. ACTION REQUESTED The City Council is requested to discuss tonight's proposal and provide feedback to staff regarding future land use, and physical locations. Once feedback is obtained staff will continue to work on completing the information for Met Council including working on a population projection. ATTACHMENTS: Proposed Future Land Use Map Option #2.2 q tfull sub 'tted, Joe Janis Community Development Director Sewer Pipe and Lift Station #5 Capacity Issue: Requires onstruction 1685 CROSSTOWN BOULEVARD N -W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: October 2019 General Fund Budget Progress Report DATE: November 19, 2019 INTRODUCTION The City of Andover 2019 General Fund Budget contains total revenues of $11,378,046 and total expenditures of $11,740,993; a decrease in fund balance is planned. Monthly reporting of the City Budget progress to the Governing body is a recommended financial practice and often viewed positively by rating agencies. DISCUSSION Attached is the General Fund Revenue & Expenditure Budget Summary - Budget Year 2019, reflecting year to date actual through October 2019. The attachments are provided to assist discussion reviewing 2019 progress; other documents may be distributed at the meeting. The following represents Administration's directives and departmental expectations for 2019: 1. Expenditure budgets while approved, expenses are to meet with the spirit that needs are fulfilled first, expansions of service and special requests are to be reviewed with City Administration before proceeding. 2. Departments are to be committed to search for the best possible prices when purchasing goods and services. 3. Departments are to be committed to continually searching out new efficiencies and to challenge the status quo of how the City provides services. 4. Departments are to be committed to searching out collaborative opportunities to facilitate efficient and cost-effective utilization of governmental assets and personnel. 5. Departments are to be committed to developing effective, consistent and ongoing communications with City residents, businesses and other stakeholders. 6. Departments are to be cognizant that services provided are subject to available revenues and should not commit to services that are not sustainable. ACTION REQUESTED The Council is requested to receive a brief presentation from staff. submitted, CITY OF ANDOVER General Fund Budget Summary Totals Budget Year 2019 2018 1 2019 REVENUES Budget Oct YTD %Bud Final Budget Oct YTD %Bud General Property Tax $ 8,721,256 $ 4,671,673 54% $ 8,634,130 S 9,023,970 $ 4,724,058 52% Licenses and Permits 377,900 471,510 125% 562,525 384,900 692,225 180% Intergovernmental 766,274 762,365 99% 829,860 787,918 792,638 101% Charges for Services 746,700 754,284 101% 888,947 708,700 951,785 134% Fines 90,250 57,952 64% 73,719 75,250 48,787 65% Investment Income 75,000 39,639 53% 107,560 75,000 54,486 73% Miscellaneous 129,300 144,815 112% 176,662 134,300 150,874 112% Transfers In 178,558 178,558 100% 178,558 188,008 188,008 100% Total Revenues $ 11,085,238 S 7,080,796 64 % S 11451,961 $ 11378 046 $ 7,602,861 67 % Total Expenditures $ 11,549,815 S 9,742,054 84% S 11,105,246 $ 11,740,993 S 9,617,521 82% NET INCREASE (DECREASE) $ (464,577) $ (2,661,258) S 346,715 S (362,947) $ (2,014,660) 2018 2019 EXPENDITURES Budget Oct YTD %Bud Final Budget Oct YTD %Bud GENERAL GOVERNMENT Mayor and Council $ 91,298 $ 74,989 82% $ 87,813 $ 107,751 $ 85,428 79% Administration 203,833 160,360 79% 198,945 215,952 169,775 79% Newsletter 26,000 15,841 61% 17,770 26,800 18,953 71% Human Resources 28,431 15,707 55% 13,666 28,771 17,731 62% Attorney 191,360 140,982 74% 188,031 197,041 143,902 73% City Clerk 155,608 126,162 81% 149,770 163,651 133,526 82% Elections 59,781 31,840 53% 50,629 65,640 17,340 26% Finance 278,660 230,582 83% 272,851 290,752 237,889 82% Assessing 154,000 146,403 95% 149,040 154,000 149,033 97% Information Services 180,597 142,192 79% 171,637 187,743 138,080 74% Planning & Zoning 438,827 339,247 77% 422,984 456,887 326,050 71% Engineering 553,765 433,787 78% 527,688 575,968 463,123 80% Facility Management 678,519 407,096 60% 497,641 695,944 424,481 61% Total General Gov 3,040,679 2 265 188 74% 2,748,465 3,166,900 2 325 311 73% PUBLICSAFETY Police Protection 3,053,526 3,053,526 100% 3,053,526 3,183,610 3,183,610 100% Fire Protection 1,423,914 1,216,068 85% 1,445,167 1,471,101 1,153,822 78% Protective Inspection 462,164 353,760 77% 436,789 479,543 380,615 79% Civil Defense 32,502 14,779 45% 18,060 29,184 16,639 57% Animal Control 5,950 1,915 32% 2,809 5,950 3,788 64% Total Public Safe 4,978,056 4640 048 93% 4,956,351 52169,388 4 738,474 92% PUBLIC WORKS Streets and Highways 659,943 545,417 83% 656,194 696,225 526,922 76% Snow and Ice Removal 562,706 500,864 89% 599,028 586,375 545,143 93% Street Signs 219,418 164,601 75% 206,890 227,527 152,738 67% Trak Signals 37,000 19,286 52% 33,857 39,500 19,613 50% Street Lighting 40,400 24,656 61% 32,829 40,400 24,508 61% Street Lights - Billed 2209500 105,485 48% 142,937 180,500 106,262 59% Park & Recreation 1,318,395 1,069,020 81% 1,282,415 1,352,017 971,900 72% Natural Resource Preservation 15,074 4,931 33% 5,158 18,107 13,181 73% Recycling 157,216 160,643 102% 199,182 168,626 179,393 106% Total Public Works 3,230,652 295949903 80% 3,158,490 3,309,277 2,539,660 77% OTHER Miscellaneous 261,828 233,415 89% 233,440 56,828 5,576 10% Youth Services 38,600 8,500 22% 8,500 38,600 8,500 22% Total Other 300,428 241,915 81% 241,940 95,428 14,076 15% Total Expenditures $ 11,549,815 S 9,742,054 84% S 11,105,246 $ 11,740,993 S 9,617,521 82% NET INCREASE (DECREASE) $ (464,577) $ (2,661,258) S 346,715 S (362,947) $ (2,014,660) t I ' L, C I T Y 0 F( D4 ADOVEA -- 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: October 2019 City Investment Reports DATE: November 19, 2019 INTRODUCTION Summary reporting of the City Investment portfolio to the Governing body is a recommended financial practice and often viewed positively by rating agencies. Furthermore, the City of Andover Investment Policy recommends the Finance Director presents to the City Council at least quarterly the type of investments held by the City. DISCUSSION Attached is the Investment Maturities Summary for October 2019, the October 2019 Investment Detail Report, and the October 2019 Money Market Funds Report. These attachments are intended to provide a status report on the October 2019 investments. ACTION REQUESTED for Council review. Staff will provide a brief presentation and answer questions. submitted, Investment Maturities - October 2019 U.S. agencies AAA Total investments Deposits Total cash and investments Credit Investment Type Rating Fair Less Than Money market funds N/A MN Municipal Money Value Market Fund (4M) N/A Certificates of deposit FDIC Local governments A/Al/A2 $ AA/AAI/AA2/AA3 $ AAA State governments A/Al/A2 AA/AA1/AA2/AA3 AAA U.S. agencies AAA Total investments Deposits Total cash and investments Investment Maturities (in Years) Fair Less Than More Than Value 1 1 - 5 6-10 10 $ 1,985,066 $ 1,985,066 $ $ $ 23,869,865 23,869,865 13,958,375 11,231, 531 2,479,771 247,073 226,459 165,041 61,418 - 4,132,382 1,576,699 1,530,085 1,025,598 - 5,121,471 1,888,749 1,458,257 1,421,697 352,769 205,362 - 205,362 - - 648,567 572,565 76,001 963,106 45,540 917,566 - 11,299,575 3,626,591 6,602,649 1,070,334 - $ 62,410,228 $ 44,961,647 $ 13,331,110 $ 3,764,702 $ 352,769 1,098,500 $ 63,508,728 October 2019 Investment Detail Description Cusip Number Credit RatinglF DIC p Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity) Due Date Third Federal Sav & Loan _ 1 Year CD- Premier Bank 88413QAW8 30012 CD 128,000.00 128,000.00 128,000.00 2.000% 128,047.36 semi-annual 11/24/14 05/24/15 11/25/19 1D91003210 2055214401 3041574901 21714 _ 33202 33204 CD CD 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 2.500% 2.500% 245,000.00 245,000.00 maturity 12/16/18 none 12/16/19 1 Year CD- Premier Bank Rochester maturity 12/16/18 none 12/16/19 1 Year CD - Premier Bank MN 1Year CD - Premier Bank Celtic Bank CD 245,000.00 245,000.00 275,000.00 245,000.00 2.500% 2.500% 2.050% 245,000.00 275,000.00 247,227.24 maturity 12116/18 none 12/16/19 1091003211 CD 275,000.00 275,000.00 maturity, 12117/18 none 12/17/19 15118RJMO 57056 CD 247,000.00 247,000.00 247,000.00 semi-annual 12/20/13 06/20/14 12120/19 Customers Bank 23204HHJO 34444 CD 245,000.00 245,000.00 245,000.00 1.950% 245,129.85 maturity 09120/19 none 12120/19 Steams Bank NA 857894PB9 10988 CD 247,000.00 247,000.00 247,000.00 1.000% 247,200.07 semi-annual 12/26/14 06/26/15 12126119 _ Compass Bk 20451PVJ2 19048 CD 245,000.00 245,000.00 245,000.00 2.650% 245,543.90 semi-annual 10/11/18 04/11/19 01/13/20 Bank India NY 06279KYP5 33648_ CD 245,000.00 245,000.00 245,000.00 1.900% 245,173.95 maturity 09/19/19 none 01/15120 Bank of China 06428FKUO 33653 CD 245,000.00 245,000.00 245,000.00 2,000% 245,227.85 maturity 07/17119 none 01/17/20 BankUnited A Savings 066519KA6 58979 CD 245,000.00 245,000.00 245,000.00 2.000% 245,227.85 maturity 07/17119 none 01/17/20 PNC Bank NA 69355NAH8 6384 CD 245,000.00 245,000.00 245,000.00 2.000% 245,227.85 maturity 07/17119 none 01/17/20 _ _ Kearny Bank 48714LAS8 _ _ 28765 1435 16022 CD 245,000.00 245,000.00 245,000.00 2.750% 245,661.50 semi-annual 12/21/18 06/21/19 01/21/20 _ Exchange Bank 301074DA5 CD 245,000.00 245,000.00 245,000.00 245,000.00 2.350% 245,465.50 maturity 04/26/19 none 01/27/20 _ New York Community Bank 649447SM2 CD 245,000.00 245,000.00 2.400% 245,570.85 maturity 05/10/19 none 02110/20 Sefm National Bk Fifth Third Bank MizuhoBank USA 78658Q6T5 2_6876 CD 245,000.00 245,000.00 245,000.00 245,000.00 245,000.0_0 245,000.00 245,000.00 2.000% 245,320.95 maturity 07/18119 none 02118/20 316777WS6 _ 6672 21843_ CD CD 245,000.00 2.500% 245,815.85 maturity 03113/19 none 03113120 60688MYG3 245,000.00 2.500% 245,815.85 maturity 03/13/19 none 03/13/20 US Bank NA Citizens Bank NA _ Jefferson Sk & Tr Co CifiBank NA Discover Bk Greenwood Del Iberia Bank Community West Bank Chemical Bk Midland Mich 90333VL32 75524KML5 472376AD4 17312QJ34 254673NR3 45083AJL7 _ 6548 57957 1071 7213 5649 28100 27572 CD CD CD CD CD 245,000.00 245,000.00 245,000.00 2.450% 245,771.75 maturity 03/13/19 none 03/13/20 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 1.850% 2.450% 2.550% 245,252.35 maturity semi-annual 09/18/19 04/11118 04/11/18 none 10/11/18 10111118 03/18/20 245,000.00 245,000.00 245,000.00 245,000.00 245,938.35 246,068.20 04110/20 semi-annual 04/13/20 245.000.00 245,000.00 2.500% 246,011.85 246,124.55 semi-annual 04/11/18 10/11/18 04/13/20 CD CD 245,000.00 245,000.00 2.600% semi-annual 07/12/18 01/11/19 04/13/20 20415QGU7 245,000.00 245,000.00 245,000.00 1.950% 245,392.00 maturity 07/15119 none 04/15/20 163681ES4 _ 1003 CD 245,000.00 245,000.00 245,000.00 2.300% 245,786.45 maturity 06/17/19 none 04/17/20 State Bk India New York NY 856285RK9 33682 CD 245,000.00 245,000.00 245,000.00 1.850% 2.350% 245,296.45 maturity 10/21/19 none 04121120 Bankwell Bank 06654BBA8 57368 CD 245,000.00 245,000.00 245,000.00 245,894.25 maturity 04/30/19 none 04/29/20 Israel Discount Bank 4650760F7 19977 CD 245,000.00 245,000.00 245,000.00 2.400% 246,002.05 maturity 05110/19 none 05/08/20 Independence Bk 45340KEX3 8136 CD 245,000.00 245.000.00 245,000.00 245,000.00 1.950% 245,487.55 maturity 07129/19 none 05/29/20 Bank of America, NA 06051VD37 3510 CD 245,000.00 245,000.00 2.850% 246,869.35 semi-annual 12/12/18 06/12/19 06/12/20 Citizens Alliance Bank 17318LAP9 1402 CD 249,000.00 249,000.00 245,000.00 249,000.00 2.000% 250,060.74 monthly 06/27/14 07/27/14 06/26/20 Morgan Stanley Bank NA 61747M3Q2 32992 CD 245,000.00 245,000.00 2.750% 246,964.90 semiannual 07/12/18 01/12/19 07/13/20 _ Morgan Stanley Private Bank 61760AMT3 34221 CD 245,000.00 245,000.00 245,000.00 2.750% 246,982.05 semi-annual 07/12118 07/14/18 07/1320 Customers Bank 23204HHD3 34444 CD 245,000.00 245,000.00 245,000.00 1.950% 245,597.80 maturity 07/19/19 none 07/1720 MUFG Union Bank NA 624786CY3 22826 CD 245,000.00 245,000.00 245,000.00 2.600% 246,734.60 semi-annual 07/17/18 01/17/19 07/1720 Enerbank USA 29266NA31 57293 CD 249,000.00 249,000.00 249,000.00 2.100% 249,893.91 monthly 07/18114 08/18/14 07/20/20 NBT Bank Norwich 628779FT2 7230 CD 245,000.00 245,000.00 245,000.00 2.700% 246,930.60 semi-annual 07/18/18 01/18/19 07120/20 Sallie Mae Bank 7954504T9 58177 CD 245,000.00 245,000.00 245,000.00 1.750% 245,267.05 maturity 10/23/19 none 0712320 First Republic Bank 33616CBL3 59017 CD 245,000.00 245,000.00 245,000.00 2.800% 247,366.70 semi-annual 08/31/18 09/01/18 08128120 Merchants State Bank 589227AF4 1125 CD 245,000.00 245,000.00 245,000.00 2.650% 247,163.35 semi-annual 08/31/18 0228/19 08/28/20 Description Cuslp Number Credit Rating/F DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity/ Due Date Wex 3k _ TIAA FSB Jacksonville FL 92937CHY7 87270LBXO 149159PE9 46176PMB8 34697 CD CD 245,000.00 245,000.00 245,000.00 245,000.00 3.000% 2.400% 248,057.60 semi-annual semi-annual 10/10/18 04/17/19 04/10/19 10/13/20 34775 245,000.00 245,000.00 246,680.70 10/17/19 10/19/20 Cathay Bank 18503 CD 245,000.00 245,000.00 245,000.00 1.750% 245,139.65 maturity 10/23/19 none 10/22/20 Investors Bk/Short Hills 28892 CD 245,000.00 245,000.00 245,000.00 1.750% 245,139.65 maturity 10/24/19 none 10/2320 Elbow Lake MN 284281 KC5 A local 170,045.70 170,045.70 165,000.00 2.750% 165,041.25 semi-annual 12/08/14 none 12/01/19 Dunn County WI 265777HD7 AA local 115,752.10 115,752.10 115,000.00 3.000% 116,398.40 semi-annual 04/04/19 none 10/01/20 _ _ _ Steams Co MN 857896MH4 AA+ local 276,875.00 276,875.00 278,632.50 250,000.00 4.500% 250,547.50 semi-annual 04/17/13 none 06/0120 Minneapolis MN_ Hampton VA 60374YS81 AA1 AA1 local local 278,632.50 250,000.00 3.500% 250,327.50 semi-annual 02126/13 none 12101/19 4095582J1 100,836.00 100,836.00 100,000.00 2.209% 100,167.00 semi-annual 01/20/16 none 04/0120 Brunswick Cnly 117061VH1 W local 108,967.10 108,967.10 110,000.00 1.740% 109,901.00 semi-annual 0821/15 none 05/0120 Middleton WI 596782RX2 AA1 local 106,979.00 106,979.00 100,000.00 3.750% 100,172.00 semi-annual 0224115 none 09/0120 Bristol VA 110331NT8 AA1 local 251,562.50 251,562.50 250,000.00 3.002% 253,090.00 semi-annual 07/05/18 none 10/0120 _ Portsmouth VA _ 73723RJ38 AA2 local 160,116.00 160,116.00 165,000.00 2.400% 165,376.20 semi-annual 07/17/13 02/01/14 02/01120 _ _ Portsmouth VA 73723RJ46 AA2 local 126,152.00 126,152.00 130,000.00 2.400% 130,252.20 semi-annual 07/17/13 02101/14 02/0120 Moorhead MN 6161412R7 AA3 local 108,820.00 108,820.00 100,000.00 3.800% 100,467.00 semi-annual 11/14/11 none 02/01/20 Mounds View MN ISD #621 _ Rothsay MN ISD #850 Saint Paul MN Port Auth Woodbury MN 620637V70 AAA local 246,875.00 246,875.00 250,000.00 1.900% 250,095.00 semi-annual 05/16/18 07/06/16 none none 08101117 none 08/15/11 09/01/17 none 06115/13 none 02/01/20 02/0120 02/0120 02/0120 02115120 03/01/20 05/01/20 778731AZ2 AAA local 208,640.25 208,640.25 T95,000.00 3.000% 195,859.95 semi-annual 793028WS6 AAA local 201,806.00 201,806.00 200,000.00 2.000% 200,260.00 semi-annual semi-annual semi-annual semi-annual maturity 1222/16 12122111 04116/12 01/10/17 97913PCQ7 AAA AAA local local _local local local local local state state 123,037.35 116,900.00 123,037.35 116,900.00 115,000.00 100,000.00 3.250% 4.450% 2.000% 1.800% 1.400% 2.090% 115,328.90 Dallas TX Indpt Sch Dist 100,796.00 _ Saint Paul MN Port Auth Tenn Valley Auth Zero Cpn Salt Lake County UT Tenn Val Auth Cpn Strip Zero Cpn McAllen TX Dev Corp Massachusetts State Florida St Hurricane _235308QK2 793067CC1 AAA 79,756.80 263,970.00 368,212.50 88,133.00 175,000.00 199,744.00 279,439.80 79,756.80 80,000.00 80,081.60 88059EHD9 795676QL2 88059EMX9 579086AW9 57582P2T6 AAA AAA AAA _ AAA AA1 263,970.00 368,212.50 88,133.00 175,000.00 199,744.00 _ 300,000.00 375,000.00 297,435.00 03/11/13 375,528.75 98,796.00 174,567.75 semi-annual maturity semi-annuai 05/18/18 03/18/13 06/1520 07/15120 100,000.00 175,000.00 0726/16 02/15/17 08/1520 200,000.00 200,396.00 semi-annual 12/17/14 11/01/14 05/0120 _ 34074GDH4 AA3 279,439.80 270,000.00 2.995% 271,968.30 semi-annual 11/10/15 07/01/13 0710120 Minnesota St Colleges & Univ 60414FPJ3 AA3 state 100,000.00 100,000.00 100,000.00 2.000% 100,201.00 semi-annual 02/26/15 10/01/15 10/01/20 Tennessee State 880541 QQ3 AAA state 48,218.85 48,218.85 45,000.00 3.178% 45,539.55 semi-annual 08/30/16 02/01/12 08/0120 Fed Farm Credit Bank 3133EGBKO AAA US 199.600.00 199.600.00 200,000.00 1.300% 199,954.00 semi-annual 05/25/16 11/25/16 1125/19 Fed Home Ln Mtg CorpZero C_pn 31340OBV4 AAA US 950,527.00 950,527.00 1,000,000.00 998,540.00 maturity 11/02115 none 1129/19 Fed Farm Credit Bank 3133EGFR1 313381ND3 3137EAEE5 AAA US 223,031.25 223,031.25 225,000.00 1.330% 224,921.25 semi-annual 11/03/17 none 12/16/19 Fed Home Ln Bank AAA US 147,300.00 147,300.00 150,000.00 1.450% 149,944.50 semi-annual 0323/18 none 01/0920 Fed Home Ln Mtg Corp AAA US 297,912.00 297,912.00 300,000.00 1.500% 299,904.00 semi-annual 12/07/17 07/17/17 01/17/20 Fed Home Ln Bank 313OA3XL3 AAA US 99,500.00 99,500.00 100,000.00 1.500% 99,938.00 semi-annual 07/22/15 08/10/15 02/10/20 Fed Home Ln Mtg Corp Mad Term Note 3134G9ML8 AAA US 294,390.00 294,390.00 300,000.00 1.300% 299,661.00 semi-annual 12/10/18 none 0311620 Fed Home Ln Bank 3130AECJ7 AAA US 300,114.00 300,114.00 300,000.00 2.625% 1.500% 2.875% 1.500% 301,716.00 semi-annual 07/12/18 11/28/18 05/2820 Fed Nall Mtg Assn 3135GOT60 AAA US 248,830.00 248,830.00 250,000.00 249,770.00 252,670.00 semi-annual 07111/19 01/30/18 07/3020 Fed Home Ln Bank 31337OUS5 AAA US 252,620.00 252,620.00 250,000.00 semi-annual 07111/19 03/11/11 09/1120 _ Fed Farm Credit Bank 3133EHYM9 AAA US 294,735.00 294,735.00 300,000.00 299,775.00 semi-annual 01117/19 03/14/18 09/1420 Fed Nall Mtg Assn 3135GORM7 AAA US 248,940.00 248,940.00 250,000.00 1.630% 249,797.50 semi-annual 07/11/19 none 10/3020 _ - 19,106,715.97 11,231,530.87 CD 3,630,489.00 local 618,104.85 state 3,626,591.25 US Less Than 1 Year Description Cusip Number Credit Rating/F DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity/ Due Date B-Bay, LLC 05580ARJ5 12556LAT3 35141 58978 CD CD 245,000.00 245,000.00 245.000.00 245,000.00 245,000.00 2.350% 246,609.65 semi-annual semi-annual 05/10/19 12/17/18 11/10/19 11/10120 Cit Bank Nat Assn 245,000.00 3.000% 248,523.10 06/17/19 12/17/20 Flagstar Bank FSB 33847E2T3 32541 CD 245,000.00 245,000.00 245,000.00 2.000% 245,837.90 semi-annual 07/17119 01117/20 01/19121 Synovus Bank 87164DMW7 873 CD 245,000.00 245,000.00 245,000.00 2.400% 247,366.70 semiannual 04/17/19 10117119 04/16121 Bank Hapoalim BM NY 06251AW89 33686 CD 247,000.00 247,000.00 247,000.00 2.100% 248,457.30 semi-annual 07/19/19 01119/20 07119121 First Source Bank 33646CKP8 9087 CD 245,000.00 245,000.00 245,000.00 3.150% 251,764.45 semi-annual 12/17/18 06/17119 11/17/21 Raymond James Bk 75472RAA9 33893 CD 245,000.00 245,000.00 245,000.00 247,000.00 2.950% 2.100% 251,147.05 248.538.81 semi-annual 01/25/19 07/25/19 01/25/22 Goldman Sachs Bank 38149MDR1 33124 CD 247,000.00 247,000.00 245,000.00 semi-annual 07124/19 01/24/20 07125/22 JP Morgan Chase Bank NA 48128HV47 628 CD 245,000.00 245,000.00 2.200% 246,078.00 semi-annual 07119/19 01/19/20 07/19/23 State Bank of India 856283,156 33664 CD 245,000.00 245,000.00 245,000.00 2.600% 245,448.35 semi-annual 07112119 01/12/20 07/12/24 Kaufman TX 486206KR5 A3 local 61,821.00 61,821.00 60,000.00 3.000% 61,417.80 semi-annual 06/28116 02/15/17 02/15123 Chaska MN 161663653 AA local 83,725.60 83,725.60 80,000.00 4.000%1 80,438.40 semi-annual 09/08/14 none 02/01/24 Des Moines IA Area Cmnty, Col 2500971-121 _ AA1 local 50,606.00 50,606.00 50,000.00 2.450% 50,559.50 semi-annual 11/10114 12101/14 06/01121 Minneapolis MN 60374YG68 AA1 local 110,419.00 110,419.00 100,000.00 4.700% 100,245.00 semi-annual 10131111 none 03/01123 Fon Du Lac Cnty WI 344442KK3 AA2 local 259,715.00 259,715.00 250,000.00 3.250% 251,140.00 semi-annual 03/10117 none 03/01121 Adams & Arapahoe Cntys CO 005482W83 _ AA2 local 117,817.50 117,817.50 115,000.00 3.930% 117,352.90 semiannual 07112118 none 12/01/21 Alexandria MN ISD#206 0151311-06 AA2 local 279,760.50 279,760.50 270,000.00 3.000% 278,869.50 semiannual 01121115 none 02/01/23 _ Bangor ME 0600954R4 966204KA6 _ AA2 _AA3 AA3 local 235,428.00 235,428.00 240,000.00 2.850% 248,880.00 semi-annual 11/21/18 none 11101123 12101/20 12/15121 Whitewater Wis _ Georgetown MA_ _ local 109,541.00 109,641.00 100,000.00 4.850% 103,304.00 semi-annual semi-annual 06/09/11 02/20/19 none 12/15/20 372838KG6 local 98,922.00 98,922.00 100,000.00 2.500% 100,254.00 _ _ West Bend WI W Palm Beach FL Indianapolis Ind Mounds View MN ISO #621 Rochester MN Baltimore Cnty MD New York St Mtge Agy _ 951428BNO AA3 local 97,805.00 97,805.00 100,000.00 1.900% 99,494.00 semi-annual semi-annual 01/11/18 07/05/16 07/11/17 12/20/18 none 10/01/16 04/01/22 10/01/22 01115/21 955116BE7 AA3 AAA AAA AAA AAA local local local local local 101,245.00 101,245.00 251.507.50 100,000.00 2.264% 99,548.00 45528UGF2 620637V88 771588RH5 05914FME7 251,507.50 378,408.80 _ 250,000.00 2.219% 2.050% 3.750% 2.097% 251,707.50 386,555.40 254,900.00 50.104.00 semi-annual semi-annual 07/15/13 378,408.80 385,000.00 250,000.00 50,000.00 none 02/01/21 254,532.50 254,532.50 51,290.00 semi-annual 12/19/18 none 02/01121 51,290.00 semi-annual 08131/16 none 08/01121 64988RHG0 _ AAA local 100,000.00 100,000.00 100,000.00 2.375% 101,014.00 semi-annual 10127115 04/01/16 10/01/21 Columbus OH 199492CS6 AAA_ local 39,956.40 39,956.40 40,000.00 2.133% 40,395.60 semi-annual 02120/15 none 12101121 OutagamieCntyWI 689900898 80465PAN4 AAA AAA kcal 170,000.00 170,000.00 170,000.00 2.350% 172,296.70 semi-annual 11/07117 05/01118 11/01/22 _ Savage Minn local 198,018.00 198,018.00 200.000.00 4.800% 201,284.00 semi-annual 06/17/10 02/01/11 02101/24 _ Connecticut State 20772JQN5 _ Al stale 214,954.00 214,954.00 200,000.00 3.517% 205,362.00 semi-annual 05/27116 02/15/14 08/15121 Vermont State Hag Fin Ally 92419RAE2 AA2 state 74,130.75 74,130.75 75,000.00 2.550% 76,001.25 semi-annual 08/28/18 05/01118 11/01/21 Texas St 882722VHI _ AAA AAA state 255,737.50 255,737.50 250,000.00 3.523% 266,027.50 semi-annual 10/17/19 none 04101/21 Kentucky St Hag Corp 49130TSHO state 203,458.00 203.458.00 200,000.00 2.780% 203,020.00 semi-annual 03/29/17 none 07101/21 Georgia State 373384208 _ _ AAA_ stale 204,444.00 204,444.00 200,000.00 2.780% 205,958.00 semi-annual 12/13/16 none 02/01/23 Texas St 882723YM5 AAA state 250,639.90 250,639.90 245,000.00 2.732% 252,560.70 semi-annual 07/19/19 none 08/01/23 Fed Home Ln Mtg Corp 3137EAEK1 AAA US 299,193.00 299,193.00 300,000.00 1.875% 300,801.00 semi-annual 12/07/17 05/17/18 11/17120 Fed Farm Credit Bank 3133EJPW3 AAA US 299,769.00 299,769.00 300,000.00 2.700% 303,177.00 semi-annual 05/21/18 06/21/18 12/21/20 Fed Nag Mtg Assn 3136G4JM6 3134GBJR4 AAA US 200,000.00 200,000.00 249,177.50 297,516.00 200,000.00 1.850% 200,048.00 semi-annual 12128116 06/28/17 12/28/20 Fed Home Ln Mtg Corp Med Term Note AAA US 249,177.50 250,000.00 1.740% 250,537.50 semi-annual 07111/19 none 01/26121 Fed Home Ln Bank 3130ADME9 US 297,516.00 300,000.00 2.375% 302,826.00 semi-annual 07112118 08/08/18 02/08121 Fed Home Ln Mig Corp Med Term Note 3134G8KU2 _AAA AAA US 246,407.50 246,407.50 250,000.00 1.500% 250,002.50 semi-annual 12/04118 02/26/19 02/26121 Fed Home Ln Bank 313382K69 AAA US 249,212.50 249,212.50 250,000.00 1.750% 250,347.50 semi-annual 07111119 none 03112/21 2,479,771.31 CD 3,049,760.30 local 1,198,929.45 state DescriptionCusip r Number Credit Rating/F DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Date Acquired Coupon Date Maturity) Due Date Fed Farm Credit Bank 3133EFX36 AAA US 117,277.20 117,277.20 120,000.00 1.680% 119,607.60 semi-annual 01/17/19 10/05/16 04/05/21 Fed Nall Mtg Assn 3135GOU27 AAA US 252,630.00 252,630.00 250,000.00 2.500% 253,337.50 semi-annual 07/11/19 10/13118 04/13/21 Fed Home Ln Mtg Corp Med Tem! Note 3134GBP89 AAA US 292,425.00 292,425.00 300,000.00 1.850% 301,236.00 semi-annual 08/07/18 04/26/18 04/26/21 Fed Farm Credit Bank _3133EGAH8 3133EKLQ7 AAA US 288,960.00 288,960.00 300,000.00 1.550% 298,785.00 semi-annual 10/10/18 11/17/16 05/17/21 Fed Farm Credit Bank AAA US 1 251,562.50 251,562.50 250,000.00 2.250% 252,350.00 semi-annual 07/11/19 11/17/19 05/17/21 _ Fed Home Ln Bank 313OA7Z73 AAA US 153,217.50 153,217.50 155,000.00 1.250% 154,820.20 semi-annual 12/18/18 11/25116 05/25/21 Fed Home Ln Bank 313OA82BB AAA US 294,030.00 294,030.00 300,000.00 1.000% 300,039.00 semi-annual 07/17/18 none 05/25/21 Fed Home Ln Bank 313373ZY1 AAA US 257,980.00 257,980.00 250,000.00 3.625% 258,097.50 semi-annual 07/11/19 12/11111 06/11/21 Fed Nag Mtg Assn 313500035 AAA US 300,249.00 300,249.00 300,000.00 2.750% 305,577.00 semi-annual 07112/18 12/22118 06122/21 Fed Home Ln Bank 3130ABSR5 AAA US 244,531.25 244,531.25 250,000.00 1.000% 249,550.00 semi-annual 07110/18 none 07/27/21 Fed Home Ln Bank 3130AGXL4 AAA US 300,000.00 300,000.00 300,000.00 2.050% 300,024.00 semi-annual 08123/19 02/26/20 08126/21 Fed Home Ln Bank 313OA8MNO AAA US 194,414.00 194,414.00 200,000.00 1.625%1 199,368.00 semi-annual 01/25/19 none 10/07/21 Fed Home Ln Mtg Corp Med Term Note 3134GAWP5 AAA US 245,875.00 245,875.00 250,000.00 1.900% 250,015.00 semi-annual 12/04/18 02/23/16 11/23/21 Fed Home Ln Mtg Corp Med Term Note 3134GTGZO AAA US 300,000.00 300,000.00 300,000.00 2.500% 300,915.00 semi-annual 04/15/19 10/15/19 04/15/24 Fed Home Ln Mtg Corp Med Tenn Note 3134GTMD2 AAA US 300,000.00 300,000.00 300,000.00 2.650% 301,143.00 semi-annual 05/15/19 11/15/19 05/15/24 Fed Farm Credit Bank 3133EKTT3 AAA US 300,000.00 300,000.00 300,000.00 2.230% 300,585.00 semi-annual 07/10/19 01/08/20 07/08/24 Fed Farm Credit Bank 3133EKVR4 AAA US 600,000.00 599,859.00 599,859.00 2.240% 599,460.00 semi-annual 07/22/19 01/22/20 07122/24 13,331,110.36 semi-annual semi-annual 07/30/19 12/05112 01/30/20 08/01/13 04/01/19 07130/27 02101/25 10/01/26 Wells Fargo Bank NA 949763F43 3511 CD 245,000.00 245,000.00 245,000.00 2.750% 247,072.70 Duluth MN 264438ZL9 AA2 local 29,767.20 29,767.20 30,000.00 2.625% 30,691.50 South Milwaukee WI Will County IL Cmnty Zero Coupon Waterloo lA Birmingham AL Lake City Minn ISD #813 838855ZV9 969078QM9 941647UR8 09088RB70 508084DW7 AA2 AA2 AA2 AA3 AAA local 327,798.25 327,798.25 325,000.00 3.350% 340,002.00 semi-annual 01/25/19 local local local 159,000.00 173,216.40 159,000.00 173,216.40 500,000.00 170,000.00 2.600% 398,040.00 maturity semi-annual 08/25/09 none 11/01/27 173,984.80 09/13/19 06/01/25 06/01/28 83,255.20 83,255.20 80,000.00 2.951% 82,880.00 semi-annual 10/03/19 none 03/01/25 local 103,933.00 103,933.00 100,000.00 5.000% 100,665.00 semi-annual 05/11/11 none 02/01/25 Charlotte NC 16103544 AAA local 298,317.00 298,317.00 300,000.00 1.790% 297,786.00 semi-annual 08128/19 12/01/19 06/01/25 Tonnessee Valley Auth Serf 880591CJ9 AAA local 121,500.00 121,500.00 100,000.00 6.750% 127,840.00 semi-annual 03/19/09 none 11/01/25 Minneapolis MN Spl Sch Dist #1 60378931J0 AAA local 268,815.00 268,815.00 300,000.00 1.150% 283,476.00 semi-annual 04/22/19 none 12/15/25 Austin TX 052397RE8 AAA local 359,971.20 359,971.20 360,000.00 2.124% 361,929.60 semi-annual 10/02/19 03/01/20 09101/26 Ice Deposit- National Sports Center none local 250,000.00 250,000.00 250,000.00 250,000.00 maturity 02/06/08 none 01/01/26 Fed Farm Credit Hank 3133EKC95 AAA US 300,000.00 300,000.00 300,000.00 2.190°h 300,123.00 semi-annual 08120/19 02/20120 02/20/25 Fed Home Ln Bank 3130AGQ73 AAA US 300,000.00 300,000.00 300,000.00 2.450% 300,288.00 semi-annual 07117/19 01117/20 07/17/25 Fed Home Ln Bank 313OA8W33 AAA US 39,000.00 39,000.00 40,000.00 2.100% 40,002.40 semi-annual 07127/17 08/22117 08122/25 Fed Farm Credit Bank 31331 VLC8 AAA US 106,030.45 106,030.45 100,000.00 5.250% 126,933.00 semi-annual 02126/10 none 04/21/28 Fed Home Ln Bank 3130AGT21 AAA US 300,000.00 300,000.00 300,000.00 2.640% 302,988.00 semi-annual 07126/19 01/26/20 07/26/29 3,764,702.00 Anoka-Hennepin MN ISD#11 036303285 AAA local 323,613.50 323,613.50 350,000.00 2.550% 352,768.50 semi-annual 01/25/19 none 02/01/30 352,768.50 36,555,296.83 6,602,649.30 US 1- 5 Years 247,072.70 CD 2,447,294.90 local 1,070,334.40 US 6 - 10 Years 352,768.50 local 10+ Years INVESTMENT SCHEDULE - Money Market Funds October 31, 2019 Description Current Market Value YTD Interest Wells Fargo I lWells Fargo Government Money Market Fund 1 $1,985,066.431 $41,545.44 4M I 14M 1,037,283.721 17,428.70 4M PLUS I 14M Plus 1,012,991.101 4,500.30 4M and 4M PLUS- PUBLIC WORKS 1 14M and 4M Plus - CIP Bonds 6,163,136.981 159,456.33 4M and 4M PLUS - COMM CENTER 1 14M and 4M Plus - CIP Bonds 1 15,656,452.701 30,193.53 Grand Total Money Market Funds 1 $25,854,930.93 1 $253,124.30 Updated: 11/14/2019