The URL can be used to link to this page

Home My WebLink AboutWK - June 26, 20181685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, June 26, 2018 Conference Rooms A & B Call to Order — 6:00 p.m. • (763) 755-5100 2. Discuss Potential Community Center Expansion - Administration 3. May 2018 Budget Progress Reports -Administration 4. May 2018 City Investments Review—Administration 5. Other Business 6. Adjournment • • NDO R4104 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: FROM: SUBJECT: DATE: Mayor and Council Members Jim Dickinson, City Administrator Potential Community Center Expansion Discussion June 26, 2018 ACTION REQUESTED The City Council is requested to receive an update from 292 Design Group relative to exploring the expansion of the Andover YMCA Community Center. Focus of the presentation/discussion will be responding to questions generated at the May 22nd City Council work shop meeting via a schematic design presentation. Construction Manager, RJM Construction will be available to provide their expertise and high-level budgeting for the schematic design. Also, City Staff will provide analysis and the tax impacts of the various options for a potential expansion. The Council will be asked to provide direction on the what components of an expansion should progress to a detailed design. DISCUSSION On December 5, 2017, the City Council approved the 292 Design Group (292) as the architectural firm to provide architectural services to explore expansion of the Andover YMCA Community Center. The programming, schematic design and project development phase is working toward a decision point date in June 2018 as to what components of an expansion may progress to construction documents. On February I", City Staff and 292 held a stakeholder meeting with many of the local sports associations, school officials, Fun Fest representatives and Andover YMCA. On February 12d` the City Council and Community Center Advisory Commission was updated on the stakeholder input and the Council & Commission provided their goals for the project. Since February, City Staff has worked with 292 & RJM to assemble conceptual designs that will address the requests of the stakeholder groups and engage the YMCA on their potential participation in an expansion. The results of the past months discussions will be presented at the meeting. Respectfully submitted, Jim Dickinson attachments Andover Con7munity Center Expansion Exploration Indoor Ice /Turf/ Track/ 2 Gyms / Add'I Mtg Rms $20.0m Year Base 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 Inflation Factor - Revenues 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Inflation Factor - Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Hours Rented: Ice Rental - Prime Time 952 952 952 952 952 952 952 952 952 952 952 952 952 952 952 952 952 952 952 952 952 Dry Floor/ Turf 661 661 661 661 661 661 661 661 661 661 661 661 661 661 661 661 661 661 661 661 661 Field House - Prime Time 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 Hourly Rates Ice Rental - Prime Time $ 211.00 $ 217.00 $ 224.00 $ 231.00 $ 238.00 $ 245.00 $ 252.00 $ 260.00 $ 268.00 $ 276.00 $ 284.00 $ 293.00 $ 302.00 $ 311.00 $ 320.00 $ 330.00 $ 340.00 $ 350.00 $ 361.00 $ 372.00 $ 383.00 Dry Floor/ Turf $ 100.00 $ 103.00 $ 106.00 $ 109.00 $ 112.00 $ 115.00 $ 118.00 $ 122.00 $ 126.00 $ 130.00 $ 134.00 $ 138.00 $ 142.00 $ 146.00 $ 150.00 $ 155.00 $ 160.00 $ 165.00 $ 170.00 $ 175.00 $ 180.00 Field House Rate - Prime Time $ 54.00 $ 56.00 $ 58.00 $ 60.00 $ 62.00 $ 64.00 $ 66.00 $ 68.00 $ 70.00 $ 72.00 $ 74.00 $ 76.00 $ 78.00 $ 80.00 $ 82.00 $ 84.00 $ 87.00 $ 90.00 $ 93.00 $ 96.00 $ 99.00 Revenues Ice Rental - Prime Time $ 200,872 $ 206,584 $ 213,248 $ 219,912 $ 226,576 $ 233,240 $ 239,904 $ 247,520 $ 255,136 $ 262,752 $ 270,368 $ 278,936 $ 287,504 $ 296,072 $ 304,640 $ 314,160 $ 323,680 $ 333,200 $ 343,672 5 354,144 $ 364,616 Dry Floor/ Turf 66,060 68,042 70,024 72,005 73,987 75,969 77,951 80,593 83,236 85,878 88,520 91,163 93,805 96,448 99,090 102,393 105,696 108,999 112,302 115,605 118,908 Field House Rental - Prime Time 232,740 241,360 249,980 258,600 267,220 275,840 284,460 293,080 301,700 310,320 318,940 327,560 336,180 344,800 353,420 362,040 374,970 387,900 400,830 413,760 426,690 499,672 515,986 533,252 550,517 567,783 585,049 602,315 621,193 640,072 658,950 677,828 697,659 717,489 737,320 757,150 778,593 804,346 830,099 856,804 883,509 910,214 Expenses Personal Services 140,000 144,200 148,526 152,982 157,571 162,298 167,167 172,182 177,348 182,668 188,148 193,793 199,607 205,595 211,763 218,115 224,659 231,399 238,341 245,491 252,856 Operating Supplies 30,000 30,900 31,827 32,782 33,765 34,778 35,822 36,896 38,003 39,143 40,317 41,527 42,773 44,056 45,378 46,739 48,141 49,585 51,073 52,605 54,183 Marketing 5,000 5,150 5,305 5,464 5,628 5,796 5,970 6,149 6,334 6,524 6,720 6,921 7,129 7,343 7,563 7,790 8,024 8,264 8,512 8,768 9,031 Repair & Mtce 35,000 36,050 37,132 38,245 39,393 40,575 41,792 43,046 44,337 45,667 47,037 48,448 49,902 51,399 52,941 54,529 56,165 57,850 59,585 61,373 63,214 Utilities 225,000 231,750 238,703 245,864 253,239 260,837 268,662 276,722 285,023 293,574 302,381 311,453 320,796 330,420 340,333 350,543 361,059 371,891 383,047 394,539 406,375 Teen Room 50,000 51,500 53,045 54,636 56,275 57,964 59,703 61,494 63,339 65,239 67,196 69,212 71,288 73,427 75,629 77,898 80,235 82,642 85,122 87,675 90,306 Capital Outlay 0 0 0 0 0 20,000 20,600 21,218 21,855 22,510 23,185 23,881 24,597 25,335 26,095 26,878 27,685 28,515 29,371 30,252 31,159 Replacement Reserve 0 0 25,000 25,750 26,523 27,318 28,138 28,982 29,851 30,747 31,669 32,619 33,598 34,606 35,644 36,713 37,815 38,949 40,118 41,321 42,561 Total 485,000 499,550 539,537 555,723 572,394 609,566 627,853 646,689 666,089 686,072 706,654 727,854 749,689 772,180 795,346 819,206 843,782 869,096 895,168 922,023 949,684 Revenues over (under) expenditures 16,436 (6,285) (5,205) (4,611) (24,517) (25,538) (25,495) (26,018) (27,122) (28,826) (30,195) (32,200) (34,860) (38,196) (40,613) (39,436) (38,997) (38,364) (38,514) (39,470) (528,027) 20 yrs Other financing sources (uses) $ (26,401) Tax Levy (105% of DS) 1,516,699 1,515,780 1,511,449 1,511,564 1,515,554 1,512,299 1,512,819 1,511,664 1,514,032 1,514,937 1,512,343 1,512,895 1,515,803 1,516,622 1,515,310 1,516,475 1,515,199 1,516,039 1,514,107 1,514,601 Facility Debt Service ($20m) (1,444,475) (1,443,600) (1,439,475) (1,439,585) (1,443,385) (1,440,285) (1,440,780) (1,439,680) (1,441,935) (1,442,797) (1,440,327) (1,440,852) (1,443,622) (1,444,402) (1,443,152) (1,444,262) (1,443,047) (1,443,847) (1,442,007) (1,442,477) Total financing sources (uses) 72,224 72,180 71,974 71,979 72,169 72,014 72,039 71,984 72,097 72,140 72,016 72,043 72,181 72,220 72,158 72,213 72,152 72,192 72,100 72,124 Balance Annual Surplus/Deficit 88,660 65,895 66,769 67,368 47,652 46,476 46,544 45,966 44,975 43,314 41,821 39,842 37,321 34,025 31,545 32,777 33,156 33,828 33,586 32,654 Cumulative balance 88,660 154,555 221,323 288,691 336,344 382,819 429,363 475,329 520,304 563,618 605,439 645,282 682,602 716,627 748,172 780,949 814,105 847,933 881,519 914,172 Replacement Reserve Contribution 0 25,000 25,750 26,523 27,318 28,138 28,982 29,851 30,747 31,669 32,619 33,598 34,606 35,644 36,713 37,815 38,949 40,118 41,321 42,561 Use 0 0 0 0 0 60,000 0 0 0 0 140,000 0 0 0 0 65,000 0 0 0 0 Balance 0 25,000 50,750 77,273 104,591 72,728 101,710 131,562 162,308 193,978 86,597 120,195 154,801 190,445 227,158 199,973 238,922 279,040 320,361 362,922 1/2 zamboni floor 1/2 zamboni Andover Community Center Expansion Exploration Indoor Ice /Turf /Add'1 Mtg Rms $15.Om 2023 Year Base 2020 2021 2022 Inflation Factor - Revenues 3.00% 3.00% 3.00% 3.00% Inflation Factor - Expenses 3.00% 3.00% 3.00% 3.00% Hours Rented: Ice Rental - Prime Time Dry Floor / Turf Hourly Rates Ice Rental - Prime Time Dry Floor/ Turf Revenues Ice Rental - Prime Time Dry Floor / Turf Expenses Personal Services Operating Supplies Marketing Repair & Mtce Utilities Teen Room Capital Outlay Replacement Reserve Revenues over (under) expenditures Other financing sources (uses) Tax Levy (105% of DS) Facility Debt Service ($15m) Total financing sources (uses) Balance Annual Surplus/Deficit Cumulative balance Replacement Reserve Contribution Use Balance 952 952 952 952 661 661 661 661 952 952 952 952 661 661 661 661 2027 Indoor Ice /Turf /Add'1 Mtg Rms $15.Om 2023 2024 2025 2026 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 952 952 952 952 661 661 661 661 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 952 952 952 952 952 952 952 952 952 952 952 952 952 661 661 661 661 661 661 661 661 661 661 661 661 661 $ 211.00 $ 217.00 $ 224.00 $ 231.00 $ 238.00 $ 245.00 $ 252.00 $ 260.00 $ 268.00 $ 276.00 $ 284.00 $ 293.00 $ 302.00 $ 311.00 $ 320.00 $ 330.00 $ 340.00 $ 350.00 $ 361.00 $ 372.00 $ 383.00 $ 100.00 $ 103.00 $ 106.00 $ 109.00 $ 112.00 $ 115.00 $ 118.00 $ 122.00 $ 126.00 $ 130.00 $ 134.00 $ 138.00 $ 142.00 $ 146.00 $ 150.00 $ 155.00 $ 160.00 $ 165.00 $ 170.00 $ 175.00 $ 180.00 $ 200,872 $ 206,584 $ 213,248 $ 219,912 $ 226,576 $ 233,240 $ 239,904 $ 247,520 $ 255,136 $ 262,752 $ 270,368 $ 278,936 $ 287,504 $ 296,072 $ 304,640 $ 314,160 $ 323,680 $ 333,200 $ 343,672 $ 354,144 $ 364,616 66,060 68,042 70,024 72,005 73,987 75,969 77,951 80,593 83,236 85,878 88,520 91,163 93,805 96,448 99,090 102,393 105,696 108,999 112,302 115,605 118,908 266,932 274,626 283,272 291,917 300,563 309,209 317,855 328,113 338,372 348,630 358,888 370,099 381,309 392,520 403,730 416,553 429,376 442,199 455,974 469,749 483,524 92,000 94,760 97,603 100,531 103,547 106,653 109,853 113,148 116,543 120,039 123,640 127,350 131,170 135,105 139,158 143,333 147,633 152,062 156,624 161,323 166,162 24,000 24,720 25,462 26,225 27,012 27,823 28,657 29,517 30,402 31,315 32,254 33,222 34,218 35,245 36,302 37,391 38,513 39,668 40,858 42,084 43,347 5,000 5,150 5,305 5,464 5,628 5,796 5,970 6,149 6,334 6,524 6,720 6,921 7,129 7,343 7,563 7,790 8,024 8,264 8,512 8,768 9,031 14,000 14,420 14,853 15,298 15,757 16,230 16,717 17,218 17,735 18,267 18,815 19,379 19,961 20,559 21,176 21,812 22,466 23,140 23,834 24,549 25,286 170,000 175,100 180,353 185,764 191,336 197,077 202,989 209,079 215,351 221,811 228,466 235,320 242,379 249,651 257,140 264,854 272,800 280,984 289,414 298,096 307,039 50,000 51,500 53,045 54,636 56,275 57,964 59,703 61,494 63,339 65,239 67,196 69,212 71,288 73,427 75,629 77,898 80,235 82,642 85,122 87,675 90,306 0 0 0 0 0 20,000 20,600 21,218 21,855 22,510 23,185 23,881 24,597 25,335 26,095 26,878 27,685 28,515 29,371 30,252 31,159 0 0 15,000 15,450 15,914 16,391 16,883 17,389 17,911 18,448 19,002 19,572 20,159 20,764 21,386 22,028 22,689 23,370 24,071 24,793 25,536 Total 355,000 365,650 391,620 403,368 415,469 447,933 461,371 475,212 489,469 504,153 519,277 534,856 550,901 567,428 584,451 601,985 620,044 638,646 657,805 677,539 697865 (91,024) (108,348) (111,451) (114,906) (138,724) (143,516) (147,099) (151,097) (155,523) (160,389) (164,757) (169,592) (174,909) (180,721) (185,432) (190,668) (196,447) (201,831) (207,790) (214,341) 1,138,026 1,138,816 1,134,223 1,134,310 1,138,615 1,136,137 1,137,801 1,138,169 1,137,197 1,135,210 1,135,934 1,134,989 1,137,171 1,137,785 1,136,800 1,138,988 1,139,292 1,137,192 1,138,368 1,137,318 (1,083,834) (1,084,587) (1,080,212) (11080,295) (1,084,395) (1,082,035) (1,083,620) (1,083,970) (1,083,045) (1,081,152) (1,081,842) (1,080,942) (1,083,020) (1,083,605) (1,082,667) (1,084,750) (1,085,040) (1,083,040) (1,084,160) (1,083,160) 54,192 54,229 54,011 54,015 54,220 54,102 54,181 54,199 54,152 54,058 54,092 54,047 54,151 54,180 54,133 54,238 54,252 54,152 54,208 54,158 (36,833) (54,119) (57,440) (60,891) (84,504) (89,415) (92,918) (96,899) (101,371) (106,331) (110,665) (115,545) (120,758) (126,541) (131,298) (136,431) (142,195) (147,679) (153,582) (160,183) (36,833) (90,951) (148,391) (209,282) (293,787) (383,201) (476,120) (573,018) (674,389) (780,720) (891,385) (1,006,930) (1,127,688) (1,254,229) (1,385,527) (1,521,958) (1,664,152) (1,811,831) (1,965,414) (2,125,597) 0 15,000 15,450 15,914 16,391 16,883 17,389 17,911 18,448 19,002 19,572 20,159 20,764 21,386 22,028 22,689 23,370 24,071 24,793 25,536 0 0 0 0 0 60,000 0 0 0 0 0 0 0 0 0 65,000 0 0 0 0 0 15,000 30,450 46,364 62,754 19,637 37,026 54,937 73,385 92,387 111,958 132,117 152,880 174,267 196,295 153,984 177,353 201,424 226,217 251,753 1/2 zamboni 1/2 zamboni (3,208,565) 20 yrs $ (160,428) Andover Community Center Expansion Exploration Year Base 2020 Inflation Factor - Revenues 3.00% 3.00% Inflation Factor - Expenses 3.00% 3.00% Hours Rented: Field House - Prime Time Hourly Rates Field House Rate - Prime Time Revenues Field House Rental - Prime Time Expenses Personal Services Operating Supplies Marketing Repair & Mice Utilities Teen Room Capital Outlay Replacement Reserve Revenues over (under) expenditures Other financing sources (uses) Tax Levy (105% of DS) Facility Debt Service ($10m) Total financing sources (uses) Balance Annual Surplus/Deficit Cumulative balance Replacement Reserve Contribution Use Balance 2027 2028 2029 2 Gyms / Add'I Mtg RMS $10.Om 2021 2022 2023 2024 2025 2026 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 300% 3.00% 3.00% 3.00% 3.00% 3.00% 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 4,310 $ 54.00 $ 56.00 $ 58.00 $ 60.00 $ 62.00 $ 64.00 $ 66.00 $ 68.00 $ 70.00 $ 72.00 $ 74.00 $ 76.00 $ 78.00 $ 80.00 $ 82.00 $ 84.00 $ 87.00 $ 90.00 $ 93.00 $ 96.00 $ 99.00 232,740 241,360 249,980 258,600 267,220 275,840 284,460 293,080 301,700 310,320 318,940 327,560 336,180 344,800 353,420 362,040 374,970 387,900 400,830 413,760 426,690 232,740 241,360 249,980 258,600 267,220 275,840 284,460 293,080 301,700 310,320 318,940 327,560 336,180 344,800 353,420 362,040 374,970 387,900 400,830 413,760 426,690 92,000 94,760 97,603 100,531 103,547 106,653 109,853 113,148 116,543 120,039 123,640 127,350 131,170 135,105 139,158 143,333 147,633 152,062 156,624 161,323 166,162 17,000 17,510 18,035 18,576 19,134 19,708 20,299 20,908 21,535 22,181 22,847 23,532 24,238 24,965 25,714 26,485 27,280 28,098 28,941 29,810 30,704 5,000 5,150 5,305 5,464 5,628 5,796 5,970 6,149 6,334 6,524 6,720 6,921 7,129 7,343 7,563 7,790 8,024 8,264 8,512 8,768 9,031 14,000 14,420 14,853 15,298 15,757 16,230 16,717 17,218 17,735 18,267 18,815 19,379 19,961 20,559 21,176 21,812 22,466 23,140 23,834 24,549 25,286 115,000 118,450 122,004 125,664 129,434 133,317 137,316 141,435 145,679 150,049 154,550 159,187 163,963 168,881 173,948 179,166 184,541 190,077 195,780 201,653 207,703 50,000 51,500 53,045 54,636 56,275 57,964 59,703 61,494 63,339 65,239 67,196 69,212 71,288 73,427 75,629 77,898 80,235 82,642 85,122 87,675 90,306 0 0 0 0 0 20,000 20,600 21,218 21,855 22,510 23,185 23,881 24,597 25,335 26,095 26,878 27,685 28,515 29,371 30,252 31,159 0 0 15,000 15,450 15,914 16,391 16,883 17,389 17,911 18,448 19,002 19,572 20,159 20,764 21,386 22,028 22,689 23,370 24,071 24,793 25,536 Total 293,000 301,790 325,844 335,619 345,688 376,058 387,340 398,960 410,929 423,257 435,955 449,033 462,504 476,379 490,671 505,391 520,553 536,169 552,254 568,822 585,886 (60,430) (75,864) (77,019) (78,468) (100,218) (102,880) (105,880) (109,229) (112,937) (117,015) (121,473) (126,324) (131,579) (137,251) (343,351) (145,583) (148,269) (151,424) (155,062) (159,196) (2,359,451) 20 yrs $ (117,973) 758,830 755,906 756,431 756,488 761,108 759,407 756,966 759,014 760,116 760,486 759,100 756,658 758,113 758,522 757,866 761,074 757,708 758,128 757,162 760,034 (722,695) (719,910) (720,410) (720,465) (724,865) (723,245) (720,920) (722,870) (723,920) (724,272) (722,952) (720,627) (722,012) (722,402) (721,777) (724,832) (721,627) (722,027) (721,107) (723,842) 36,135 35,996 36,021 36,023 36,243 36,162 36,046 36,144 36,196 36,214 36,148 36,031 36,101 36,120 36,089 36,242 36,081 36,101 36,055 36,192 (24,295) (39,868) (40,999) (42,444) (63,975) (66,718) (69,834) (73,085) (76,741) (80,801) (85,326) (90,293) (95,479) (101,131) (107,262) (109,341) (112,188) (115,323) (119,006) (123,004) (24,295) (64,163) (105,162) (147,606) (211,581) (278,299) (348,133) (421,219) (497,959) (578,760) (664,086) (754,379) (849,857) (950,988) (1,OS8,250) (1,167,591) (1,279,779) (1,395,101) (1,514,108) (1,637,112) 0 15,000 15,450 15,914 16,391 16,883 17,389 17,911 18,448 19,002 19,572 20,159 20,764 21,386 22,028 22,689 23,370 24,071 24,793 25,536 0 0 0 0 0 0 0 0 0 0 140,000 0 0 0 0 0 0 0 0 0 15,000 30,450 46,364 62,754 79,637 97,026 114,937 133,385 152,387 31,958 52,117 72,880 94,267 116,295 138,984 162,353 186,424 211,217 236,753 floor CITY OF ANDOVER CITY OF ANDOVER Proposed Property Tax Increase on Various Bond Amounts Community Center Tax Levy Impacts Estimated Current Proposed Market City Tax Proposed Current Deferred New New Value Tax Increase Total Facility Maintenance Facility Operations Total 7.88% $2.5m $5.0m Construction Proceeds $ 200,000 $ 631.81 $ 22.88 $ 654.69 250,000 822.30 29.78 852.08 300,000 1,012.80 35.68 1,048.48 400,000 1,393.79 50.48 1,444.27 450,000 1,572.89 56.97 1,629.86 500,000 1,747.65 63.30 1,810.95 $ 200,000 $ 631.81 $ 34.29 $ 666.10 $ 250,000 822.30 44.63 73.24 =500,0001"',6747.695 866.93 393.79 100.79 $7.5m Construction Proceeds 300,000 1,012.80 54.97 747.65 126.38 1,067.77 63.30 400,000 1,393.79 75.65 28.44 1,469.44 18.20 450,000 1,572.89 85.37 126.38 1,658.26 315.91 500,000 1,747.65 94.86 1,842.51 $ 49.79 $ 11.86 $ 91.22 $ 1.82 $ 154.69 64.80 15.43 $10.0m Construction Proceeds12.80 $ 11.44 $ 31.81 $ 45.69 $ 677.50 22.30 59.46 881.76 73.24 =500,0001"',6747.695 1,086.04 393.79 100.79 1,494.58 572.89 113.74 1,686.63 747.65 126.38 1,874.03 $15.Om Construction Proceeds $20.0m Construction Proceeds 631.81 $ 68.50 822.30 89.15 012.80 109.80 393.79151.11 572.89 170.52 747.65 189.47 631.81 $ 91.22 822.30 118.72 012.80 146.22 393.79 1 201.23 .65 1 252.32 $ 49.79 $ 11.44 $ 22.88 64.80 14.89 29.78 79.81 17.84 35.68 109.83 25.24 50.48 123.94 28.49 56.97 137.71 31.65 63.30 $ 49.79 $ 11.32 $ 34.29 64.80 14.73 44.63 79.81 18.14 54.97 109.83 24.96 75.65 123.94 28.17 85.37 137.71 31.30 94.86 $ 49.79 $ 11.42 $ 45.69 $ 7.31 $ 114.21 64.80 14.87 59.46 9.51 148.64 79.81 18.31 73.24 11.72 183.08 109.83 25.20 100.79 16.13 251.94 123.94 28.44 113.74 18.20 284.31 137.71 31.60 126.38 20.22 315.91 $ 49.79 $ 11.65 $ 68.50 $ 9.59 $ 139.53 64.80 15.16 89.15 12.48 181.59 79.81 18.67 109.80 15.37 223.65 109.83 25.69 151.11 21.16 1 307.78 123.94 28.99 170.52 23.87 347.32 137.71 32.21 189.47 26.53 385.-- $ 49.79 $ 11.86 $ 91.22 $ 1.82 $ 154.69 64.80 15.43 118.72 2.37 201.33 79.81 19.01 146.22 2.92 247.96 109.83 26.16 201.23 4.02 341.24 123.94 29.52 227.09 4.54 385.09 137.71 32.80 252.32 5.05 427.88 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.CI.ANDOVER.MN.US TO: Mayor and Councilmember's CC: Jim Dickinson, City Administrator FROM: Erick Sutherland — Recreational Facility Manager SUBJECT: Neighboring Community Athletic Facility Assets DATE: June 26, 2018 INTRODUCTION: As requested by the City Council, the Recreational Facility Manager has gathered information related to the number of refrigerated ice sheets, turf spaces and gymnasiums located in Andover and neighboring communities. ANDOVER Refrigerated Ice Sheets T�irf t 1indoor 0 1 indoor 0 3 -ACC 3 - NSC Outdoor 20 -A/H Schools .25 - Indoor- NSC 1 indoor - NSC 11-A/H Schools COON RAPIDS Refrigerated Ice Sheets Turf G m Courts I awnLaurta 1indoor 0 22-A/H Schools 1 indoor (seasonal) Ioutdoor 3 - NSC Outdoor 20 -A/H Schools 1.5 indoor - NSC 1 indoor - NSC ANOKA Refrigerated Ice Sheets I Turf I G m Courts I awnLaurta 2 indoor I 1 indoor (seasonal) 1 14 -A/H Schools BLAINE Refrigerated Ice Sheets Turf GYM -Courts I awnLaurta 2 - Indoor 3 - NSC Indoor 3 - NSC 1 indoor (seasonal) 1.5 - Indoor NSC 3 - NSC Outdoor 20 -A/H Schools 1.5 indoor - NSC 25 - Indoor- Centennial LINO LAKES Refriaerated Ice SheetsTurf Turf I awnLaurta 1 indoor 1 indoor (seasonal) 16 - Centennial Schools 1.5 indoor - NSC ELK RIVER Refrigerated Ice Sh ets Turf -G-m Courts 2 indoor 0 16 - ER Schools ADRENALINE SPORTS CENTER -RAMSEY Turf Gym Courts 3 indoor 3 Private school gym space was not included in the numbers above Respectfully submitted, Erick Sutherland 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.CI.ANDOVER.MN.US TO: Mayor and Councilmember's CC: Jim Dickinson, City Administrator FROM: Erick Sutherland — Recreational Facility Manager SUBJECT: Andover Stakeholders Data DATE: June 26, 2018 INTRODUCTION: As requested by the City Council, the Recreational Facility Manager has gathered information from local associations that currently use the Community Center or may look to use the Community Center if an expansion were to happen. We have collected that information from several groups and have some others that we are still looking to hear from. Additional information will be sent out as it's collected. QUESTIONS TO STAKEHOLDERS: Currently, the city is looking for a better understanding of your needs. We have 4 primary expansion areas we're looking at. • Additional ice sheet • Turf (in the early spring once ice comes out) • Gym Space • Meeting room space 1) Do you currently have the space needed to run the programs you have? 2) If additional space were available would that allow you to grow your current programs or simply get your current programs the additional time they need? 3) Do you have to turn kids away from your programs due to a lack of space? Any additional information related to your group and/or programs that might be relevant to possible expansion will be very helpful as we continue the process. ANDOVER YMCA 1) Our Youth Sports program does not have enough space to run the number of programs that are needed. We are also having to limit the number of participants in the programs that we do offer due to lack of space. Currently, all of our Youth Sports program run off- site and are not located or offered at the Andover YMCA Community Center. Our Kids Stuff program also does not have enough space. During the Summer, we are challenged for space for School Aged kids in Kids Stuff. This would give them older activities to do and alleviate some congestion within Kids Stuff during the busy 9am-12 pm hours. We also do not have space for a Club Y (program serving 7-12yr old's). We could also offer more options for the Homeschool community. Ability to hold events or themed Family and PNO activities in need of a covered Gym space where the Kids Stuff gym is inadequate. (Late afternoon and early evening weekdays and Weekend). Also, we currently do not have fieldhouse space for many other traditional Y programs such as: open gym for Y members, senior adult programs, sports tournaments, large Group X classes, special/community events, adult leagues/classes, added Child Care and Release day programs, small group personal training and specialty birthday parties (bounce house). 2) If additional space were available would that allow you to grow your current programs or simply get your current programs the additional time needed? Sports - Additional gym space would allow more kids to participate in our current sports programs. It would also allow the addition of more programs that are in demand. Kids' Stuff - Getting the space for some activities could help grow a Club Y program and make Kids Stuff more appealing to ages 5+ and lend to member retention. Our Home School program would grow in #'s and in time's available. It would give Kids Stuff more space for the older ages and an ability to offer more youth programs during the day. 3) Youth Sports - Yes. Andover Sports programs utilizes off site locations for gym space which puts us at the mercy of that venue for scheduling. Those venues also allow other organizations to utilize their gyms, so we do still fight for space. For our Basketball League, we only have access to our off-site gym one day of the week which means we need to host practices for all of our teams on one night of the week, in one gym. We have to limit how many teams we can have in order to allow our teams ample space and to keep their practice to a reasonable time of night. For our basketball class, we use another off-site space that is not even set up efficiently for basketball. We are allowed one night per week for that venue as well which means our class sizes have to be limited not only because of the size of the space but also because of time night. This Spring, we had to turn away families because we could only offer one class, on one night of the week for each age group and it filled up quickly. If we had more space on site, not only would we be able to offer class multiple days a week, those classes would also take place in the Andover YMCA which would entice more of our parent members with alone time to utilize our facility. We could also begin to offer more Adult programs as kid's stuff would give parents an opportunity to be in a program while their child is supervised in the same building. We've had roughly 260 kids utilizing our indoor space programs (Sept 2017 -March 2018). With more gym space, I believe we could get 340 indoor program participants in that same time -frame. Not to mention all the new programs we could add including adult programs that would make that number grow even more. Kids' Stuff - We currently see 5,500 — 7,000 visits to our Kids Stuff programs monthly. At times, we do need to limit the number of children we are able to accommodate in Kids Stuff for safety reasons. During that time, the ability to move older children into a different space would benefit us greatly. ANDOVER YOUTH HOCKEY ASSOCIATION 1) No, we continue to have ice deficits annually and have resolved to sending teams out of town more, practice with more teams on the ice at the same time. We also cannot host any Andover tournaments. 2) Yes 3) Yes. Last year we turned away 26 total kids. 19 that could have played at a junior gold level and 6 bantams that we cut and found homes for elsewhere in the District. HOMETOWN HOCKEY MN 1) We do not have enough ice at the Andover Community Center to run the programs that we currently have. Last year 25% of the ice that we needed had to be rented at other rinks due to lack of availability at ACC. 2) If a 2nd sheet of ice was added, it would allow us to run the current programs we have all out of Andover (IF the 2nd sheet of ice was kept up in the spring time and not turned to turf). It would also allow us to grow our program by allowing us to run tournaments and expand our programs by being able to accept more kids. 3) Yes, we have to turn kids away from 3 of our most popular programs simply because we don't have enough space at ACC. If there were a 2nd sheet of ice, we could expand our program by adding more teams who could then skate on that 2nd sheet of ice. We currently have approx. 600 kids in our program and we could potentially add another 300 or so if we had access to a 2nd sheet. Regarding the turf, we could potentially run dryland programs on the turf, but it would most definitely be in our best interest to keep the ice in for the months of March and April. ANDOVER TRAVELING BASKETBALL 1) No 2) Yes 3) No, but it would be a heck of a lot easier to schedule practice times and host our tournament if we had our own facility. • 14-15 teams on average; about 150 kids •28+ practice slots needed a week (mid Oct to mid-March) -Tournament space -Potential space to host an AAU tournament or run a 3 on 3 league for a fundraiser ANDOVER GIRLS FASTPITCH For our fastpitch program we have not had to turn players away, but we are struggling to keep up with other communities that have access to indoor training facilities in their markets. Our program has grown from 130 players three years ago to just over 200 players this season and we are now one of the three largest fastpitch programs in the state. We host our try outs in the Fall to allow our summer teams to practice together all winter. We currently rent space at the high school, Grand Slam, and several other locations and we have extra demand for a turfed environment. Depending on rates, scope of the facility and availability I would see fastpitch spending $3,00045,000 (potentially more) for access to a turfed environment over the winter. If the plan is to have an area that is only turf during the early spring months, I don't know that we would have the same level of spend commitment every year. In years like this one we would obviously take as much time as we could buy to get players working together in a turfed environment, but there are also years when the weather cooperates more, and players would move outside earlier. Is there any thought of an area that would be turf year-round? For fastpitch, that would be the ideal scenario as that is what we are missing more than anything. As I mentioned in the planning meeting, I would love it if the designers and city planned big then challenged all of us to commit to the revenue contribution needed to support the expansion for the long term. If we can't commit to it then we can scale back, but it would be great to start large and shrink back in planning if needed. I love that we are getting the opportunity to participate in the conversation and that you are investing so much into our community. /:nd�i :IT.W.9 From an Andover Athletic standpoint, the track and field program would absolutely be interested in renting turf time. As you know we currently book indoor gym time in a variety of places including ACC and schools, but gym space does not adequately allow for field event practice. It's likely we would continue to rent gym time and supplement with turf time. Answers to the specific questions: 1) We do not currently have the space we need to run our programs. Gym time is difficult to get in the time frame in which we need it and we have a lack of indoor training options for teaching field events. Some years we're lucky and can do this outdoors but in other years (like this past spring), we miss opportunities to provide additional instruction on field events due to lack of time in appropriate spaces. 2) We would be able to get the additional time our program needs and improve the quality of our program by enabling some guaranteed (weather-proof) practice time for field events such as shotput and long jump. 3) We do not currently turn kids away for lack of space but have grown from 176 participants to 450 over the past 6 years so we are at the point where space resources are strained, especially for indoor practice time. Also, from the perspective of coaching traveling baseball that the space with turf is invaluable. Our team alone spent well over $1,000 this year in other communities to rent indoor space for training, most of it in March and April when the ACC turf would be available in an expanded building. I would like to see ABA make a commitment to renting turf time for all of it's teams but even if they didn't, you'd have baseball teams knocking down the doors to get access in those early months. FUN FEST Andover Family Fun Fest uses the fieldhouse for a craft and gift show. We always have enough space and don't believe we will need more. As I stated, I have phone calls out to follow up with some additional groups, I will pass along those notes once they are received. Respectfully submitted, Erick Sutherland REROUTE PO"ON OF ACCESS ROAD MAIN FLOOR scale: %32'=1'-0" ANDOVER COMMUNITY CENTER EXPANSION 06.11.2018 OVERALL PLAN - PRELIMINARY PROGRAM SECOND FLOOR zy,zuesic .11 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: May 2018 General Fund Budget Progress Report DATE: June 26, 2018 0 INTRODUCTION The City of Andover 2018 General Fund Budget contains total revenues of $11,085,238 and total expenditures of $11,319,815; 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 2018, reflecting year to date actual through May 2018. The attachment provided is to assist discussion in reviewing 2018 progress; other documents may be distributed at the meeting. The following represents Administration's directives and departmental expectations in place for 2018: 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 subiect to available revenues and should not commit to services that are not sustainable. ACTION REQUESTED The Council is requested to receive a presentation from staff. CITY OF ANDOVER General Fund Budget Summary Totals Budget Year 2018 2017 2015 REVENUES Budget May YTD % Bud Final Budget May YTD %Bud General Property Tax $ 8,420,354 $ 52 0% $ 8,332,634 $ 8,721,256 S 7,707 0% Licenses and Permits 367,705 238,036 65% 544,568 377,900 163,967 43% Intergovernmental 766,150 190,893 25% 793,931 766,274 204,013 27% Charges for Services 773,950 302,646 39% 787,042 746,700 287,924 39% Fines 100,750 27,500 27% 75,287 90,250 25,511 28% Investment Income 75,000 (4,811) -6% 64,751 75,000 (6,871) -9% Miscellaneous 124,300 93,259 75% 179,789 129,300 70,827 55% Transfers In 196,930 196,930 100% 196,930 178,558 178,558 100% Total Revenues S 10,825,139 S 1,044,505 10% $ 10,974,932 $ 11 085,238 S 931,636 8% PUBLIC SAFETY 2017 2018 EXPENDITURES Budget May YTD %Bud Final Budget May YTD %Bud Fire Protection GENERAL GOVERNMENT 494,094 35% 1,353,209 1,423,914 450,356 32% Protective Inspection Mayor and Council $ 89,991 $ 50,449 56% $ 84,136 $ 91,298 $ 50,916 56% Administration 199,541 74,997 38% 187,514 203,833 77,455 38% Newsletter 26,000 10,653 41% 25,287 26,000 7,243 28% Human Resources 27,913 10,202 37% 15,520 28,431 10,187 36% Attorney 191,360 62,700 33% 188,644 191,360 62,735 33% City Clerk 148,599 60,164 40% 147,450 155,608 61,028 ' 39% Elections 63,881 4,225 7% 17,852 59,781 11,864 20% Finance 268,129 111,938 42% 258,883 278,660 112,479 40% Assessing 150,000 145,367 97% 147,914 154,000 - 0% Information Services 180,722 66,086 37% 149,513 180,597 65,492 36% Planning & Zoning 462,212 151,930 33% 398,780 438,827 162,354 37% Engineering 535,715 203,124 38% 511,183 553,765 210,028 38% Facility Management 681,733 191,073 28% 509,547 678,519 183,701 27% Total General Gov 3,025,796 1,142,908 38% 2,642,223 3,040,679 1,015,482 33% PUBLIC SAFETY Police Protection 2,962,551 1,481,275 50% 2,962,551 3,053,526 1,526,763 50% Fire Protection 1,422,522 494,094 35% 1,353,209 1,423,914 450,356 32% Protective Inspection 446,688 170,945 38% 443,712 462,164 166,634 36% Civil Defense 24,847 6,760 27% 16,320 32,502 7,216 22% Animal Control 5,950 928 16% 2,544 5,950 767 13% Total Public Safety 4,862,558 2,154,002 44% 4,778,336 4,978,056 2,151,736 43% PUBLIC WORKS Streets and Highways 614,668 219,568 36% 597,964 659,943 224,893 34% Snow and Ice Removal 547,777 234,814 43% 449,881 562,706 394,244 70% Street Signs 215,244 74,919 35% 214,540 219,418 75,915 35% Traffic Signals 37,000 8,846 24% 36,152 37,000 6,493 18% Street Lighting 38,400 9,075 24% 27,735 40,400 10,938 27% Street Lights - Billed 217,500 46,965 22% 144,451 220,500 45,211 21% Park & Recreation 1,275,530 455,429 36% 1,207,359 1,318,395 407,746 31% Natural Resource Preservation 12,697 485 0% 6,503 15,074 503 3% Recycling 122,221 66,950 36% 169,956 157,216 70,732 45% Total Public Works 3,081,037 1,117,051 36% 2,854,541 3,230,652 1,236,675 38% OTHER Miscellaneous 31,728 14,550 46% 764,875 31,828 1,990 6% Youth Services 38,600 0% 38,600. 8,500 22% Total Other 70,328 14,550 21% 764,875 709428 109490 15% Total Expenditures S 11,039,719 $ 4,428,511 40% S 11,039,975 $ 11,319,815 S 4,414,383 39% NET INCREASE (DECREASE) S (214,580) $ (3,3849006) $ (65,043) $ (234,577) $ (3,482,747) 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: FROM: SUBJECT: DATE: Mayor and Councilmembers Jim Dickinson, City Administrator May 2018 City Investment Reports June 26, 2018 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 May 2018, the May 2018 Investment Detail Report, and the May 2018 Money Market Funds Report. These attachments are intended to provide a status report on the May 2018 investments. ACTION REQUESTED Informational, for Council review. Staff will provide a brief presentation and answer questions. Ily submitted, Investment Maturities - May 2018 Investment Maturities (in Years) Credit Fair Less Than More Than Investment Type Rating Value 1 1 - 5 6- 10 10 Money market funds N/A $ 1,185,785 $ 1,185,785 $ - $ - $ MN Municipal Money _ Market Fund (4M) N/A 1,016,810 1,016,810 - - - Premier Banks Money Market Fund N/A 275,875 275,875 - - - Certificates of deposit FDIC 11,631,6707,095,764 4,535,906 Local governments A/Al/A2 445,325 121,438 222,785 101,103 - AAl/AA2/AA3 _ 5,939,712 1,167,012 3,477,213 1,192,017 103,470 AAA 3,926,184 485,474 2,861,324 579,385-1-- 79,385IState - - Stategovernments A/Al/A2 201,180 - 201,180 _ AAl/AA2/AA3 1,164,877 389,975 F 774,902 AAA 587,292 125,354 461,939 - - U.S. agencies AAA 9,068,323 4,130,928 4,782,984 154,412 FNMA REMIC N/A 308 308 - - - U.S. agencies N/A 197,282 197,282 - - - Total investments $ 35,640,621 $ 16,192,002 $ 17,318,233 $ 2,026,917 $ 103,470 Deposits 377,910 Total cash and investments $ 36,018,531 May 2018 Investment Detail Description Cusip Number Credit RatinglF DIC Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity) Due Date PlainsCapital Bank 72663QC98 17491 CD 245,000.00 245,000.00 245,000.00 1.350% 244,958.35 maturity 06/21/17 none 06/21/18 Capital One Bank (USA) 140420ZQ6 33954 CD 245,000.00 245,000.00 245,000.00 245,000.00 0.900% 244,799.10 semi-annual 07/13/16 01/13/17 07/13/18 Key Bank National Association 49306SWQ5 17534 CD 245,000.00 245,000.00 0.850% 244,813.80 semi-annual 07/13/16 01/13/17 07/13/18 Bank of China NY 06426WNJ7 33653 CD 245,000.00 245,000.00 245,000.00 1.500% 244,931.40 maturity 07/20/17 none 07/20/18 First National Bank of Omaha 332135HA3 5452 CD 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 1.450% 244,897.10 maturity 07/28/17 none 07/27/18 Israel Discount Bank of NY 465076JU2 19977 CD 245,000.00 1.450% 244,855.45 maturity 08/09/17 none 08/09/18 Pacific Western Bank 69506YFTI 24045 CD 245,000.00 245,000.00 245,000.00 1.450% 244,855.45 maturity 08/09/17 none 08/09/18 BMO Hams Bk 05581 WST3 16571 CD 245,000.00 245,000.00 245,000.00 1.400% 244,794.20 maturity 10/20/17 none 08/20/18 Cathay Bank 149159LR4 18503 CD 245,000.00 245,000.00 245,000.00 1.500% 244,784.40 maturity 12/07/17 none 09/07/18 ZB NA 98878BLCO 2270 CD 245,000.00 245,000.00 245,000.00 1.500% 244,639.85 maturity 12/07/17 none 09/07/18 Beal Bk 07370W5138 57833 CD 245,000.00 245,000.00 245,000.00 1.500% 244,764.80 maturity 12/13/17 none 09/12/18 BNY Mellon 05584CBA3 7946 CD 245,000.00 245,000.00 245,000.00 1.550% 244,801.55 maturity 12/12/17 none 09/12/18 Bank India New York 06279H4M2 33648 CD 245,000.00 245,000.00 245,000.00 1.450% 244,556.55 maturity 10/19/17 none 10/17/18 CD F & M Bank _ _ _ _ New York Community Bank _ Amex Centudon Bk 30246AFM5 9963 CD 245,000.00 245,000.00 245,000.00 1.350% 244,451.20 244,676.60 244,554.10 maturity 10/20/17 none none 02/08/18 none none none 07/22/16 none none 10/19/18 10/22/18 11/08/18 12116/18 12116118 12/16118 01/22/19 02/27/19 02/28/19 04/10/19 649447RD3 02587DU63 16022_ CD 245,000.00 245,000.00 245,000.00 1.600°k maturity 12/22/17 08/03/17 12/16/17 12/16/17 12/16/17 01/22116 02/28118 02/28/18 27471 CD 245,000.00 245,000.00 245,000.00 245,000.00 1.550% 1.500% maturity 1 Year CD- Premier Bank 1 Year CD- Premier Bank Rochester 1 Year CD- Premier Bank MN 1091003210 21714_ CD 245,000.00 245,000.00 245,000.00 maturity maturity maturity semi-annual maturity maturity 2055214401 33202 CD 245,000.00 245,000.00 245,000.00 1.500% 245,000.00 3041574901 33204 CD 245,000.00 245,000.00 245,000.00 1.500% 245,000.00 BMW Bank of North America 05580ADR2 35141 CD 245,000.00 245,000.00 245,000.00 1.600% 244,247.85 Salta National Bk 78658Q2Q5 26876 CD 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 1.950% 244,657.00 TCF National Bank _ _ _ Beak Bank SSB 872278X76 28330 CD 245,000.00 1.900% 244,561.45 07370XDZ4 32574 CD 245,000.00 245,000.00 245,000.00 2.000% 244,571.25 maturity 04/11/18 none Bank Hapoalim, BM of NY 06251AT42 33686 CD 245,000.00 245,000.00 245,000.00 2.100% 244,747.65 maturity 04/20/18 none 04/18/19 Bank Bamda New York 06062RC42 33681 CD 245,000.00 245,000.00 245,000.00 2.050% 244,617.80 maturity 04/23/18 none 04/23/19 Berkshire Bk Pittsfield MA 084601NP4 23621 CD 245,000.00 245,000.00 245,000.00 1.950% 244,394.85 maturity 04/24/18 none 04/24/19 Customers Bank 23204HFAl 34444 CD 245,000.00 245,000.00 245,000.00 2.000% 244,372.80 semi-annual 02/21/16 08/21/18 05/21/19 Banner Bank 06652XFP5 28489 CD 245,000.00 245,000.00 245,000.00 1.850% 244,125.35 semi-annual 02/23/18 08/23/18 05/23/19 First Foundation Bk 32026UFSO 58647_ CD 245,000.00 245,000.00 245,000.00 2.000% 244,333.60 semi-annual 02/28/18 08/28/18 05/28/19 Oneida County NY 6824543R2 Al local 22,877.60 22,877.60 20,000.00 6.250% 20,641.60 semi-annual 08/16/10 none 04/15/19 Junction City Kansas 481502F72 A2 local 101,558.00 101,558.00 100,000.00 5.500% 100,796.00 semi-annual 05/28/08 03/01/09 09/01118 Farmington MN _ Rice Cnty MN 311297W84 762698GK8 _ AA _AA AA- local local local 102,787.00 102,787.00 100,000.00 2.000% 100,254.00 semi-annual 07/06/16 none 02/01/19 45,466.80 101,792.00 45,466.80 40,000.00 4.400% 40,431.20 semi-annual none 02/01/19 Racine Wl 7500216D4 101,792.00 100,000.00 2.100% 100,000.00 semi-annual _03/07/12 01/24/12 06/01/12 06101/18 Indiana St Bond Bank 454624S40 AA+ local 146,123.60 146,123.60 140,000.00 4.302% 140,478.80 semi-annual 12/30/16 none 08101/18 Ramsey MN 751813PB6 AA+ local 158,677.85 158,677.85 145,000.00 4.500% 145,220.40 semi-annual 02/16/12 04/01/16 04101/19 Scott County IA 809486EZ2 AA1 local 112,617.00 112,617.00 100,000.00 4.400% 100,000.00 semi-annual 10/31/12 12/01/12 06/01118 Minneapolis MN 60374YS73 AA1 local 111,898.00 111,898.00 100,000.00 3.250% 100,486.00 semi-annual 06/05/12 12/01/11 12/01118 Orange Beach ALA 68406PHF1 AA1 local 241,689.60 241,689.60 240,000.00 4.400% 242,743.20 semi-annual 08/05/10 02/01/11 02/01/19 Kane McHenry Cook & De Kalb Zero Cpn 484080MB9 AA3 local 157,328.00 157,328.00 200,000.00 197,398.00 maturity 07/16/12 none 12/01/18 Brownsville TX ISD Zero Coupon 116421E46 AAA local 229,640.00 229,640.00 250,000.00 248,697.50 maturity 06/26/13 none 08115/18 King Cnty WA 49474E3L5 AAA local 224,634.00 224,634.00 200,000.00 3.960% 201,710.00 semi-annual 03/27/12 none 12/01/18 7,095,763.50 CD Description Cusip Number Credit RatinglF DIC# Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity I Due Date Minnetonka MN ISO #276 604195RA7 AAA_ local 37,433.20 37,433.20 35,000.00 3.100% 35,066.85 semi-annual semi-annual 12/22/11 none 02/01/19 Washington Slate 939758DL9 AA state 205,804.00 205,804.00 200,000.00 4.500% 200,760.00 01/24/12 04101/12 10/01/18 New Hampshire St Hag 64469DWV9 AA2 state 105,625.80 105,625.80 105,000.00 1.939% 1.875% 104,938.05 84,276.65 semi-annual semi-annual 12/09/15 01/26/18 07/01/16 none 07/01/18 05/01/19 _ Colorado St Hsg & Fin Auth 196479A82 AA2 state 84,864.00 84,864.00 85,000.00 Georgia State 373384RQ1 AAA state 26,742.50 26,742.50 25,000.00 2.970% 25,068.50 semi-annual 02/08/12 none 10/01/18 Texas State Fed Home Ln Bank _ Fed Farm Credit Bank 882722J51 AAA state 103,089.00 103,089.00 100,000.00 250,000.00 2.894% 1.250% 100,285.00 249,965.00 semi-annual 08/10/11 04/01/12 10/01/18 313379DT3 AAA US 250,010.74 250,010.74 semi-annual 07107/17 12/08/12 06/08/18 3133EHDQ3 AAA US 200,042.00 200,042.00 200,000.00 1.180% 199,906.00 semi-annual 03/30/17 06/27/17 06/27/18 Fed Nall M(9 Assn 3135GOE33 AAA US 249,677.50 249,677.50 250,000.00 1.125% 249,727.50 semi-annual 07/07/17 07/20/15 07/20/18 Fed Home Ln Mtg Corp Med Tenn Note 3134G3ZK9 AAA US 200,000.00 200,000.00 200,000.00 1.200% 199,742.00 semi-annual 07/30/12 01/30/13 07/30/18 Fed Farm Credit Bank 31331Y4S6 AAA US 114,000.00 114,000.00 100,000.00 5.050% 100,509.00 semi-annual 09/11/13 none 08/01/18 Fed Farm Credit Bank 3133EGK87 AAA US 199,462.00 199,462.00 200,000.00 1.020% 199,382.00 semi-annual 03/30/17 none 09/24/18 Fed Home Ln Bank 3130ACR89 AAA US 249,862.50 249,862.50 250,000.00 1.375% 249,247.50 semi-annual 11/03/17 05/02/18 11/02/18 _ _ Govt Net Mtg Assn 3136G1LU1 AAA US 448,245.00 448,245.00 450,000.00 1.060% 447,880.50 semi-annual 08/21/17 none 11/14/18 Fed Farm Credit Bank Fed Farm Credit Bank 3133EHQF3 AAA US 249,870.00 249,870.00 250,000.00 1.350%1 248,870.00 semi-annual 07/07/17 01107118 01/07/19 3133EG3X1 3136GOY70 AAA US 199,711.60 199,711.60 200,000.00 1.250% 198,914.00 semi-annual 06/16/17 07117/17 01/17/19 Fed Nat Mtg Assn AAA US 199,300.00 199,300.00 99,587.00 200,000.00 100,000.00 1.080% 198,246.00 semi-annual 10/30/12 01/30/13 01/30/19 Fed Farm Credit Bank _ Fed Farm Credit Bank 3133EC5NO AAA US 99,587.00 1.250% 99,231.00 semi-annual 01107/13 07/07/17 06116117 07/07/17 06122/17 03/04/13 03/04/15 09/06117 09/08/12 none 03104/19 03104/19 03/06/19 03/08119 03/13/19 04/15/19 3133EDTU6 AAA AAA US US 251,285.00 199,654.80 251,285.00 250,000.00 1.700% 249,095.00 198,618.00 semi-annual semi-annual semi-annual semi-annual semi-annual Fed Fame Credit Bank Fed Home Ln Bank _ Fed Natl Mtg Assn Fed Home Ln Mtg Corp 3133EHLZ4 199,654.80 250,470.00 200,000.00 200,000.00 250,000.00 200,000.00 1.270% 1.500% 3133782M2 AAA US 250,470.00 248,615.00 3136G1FY0 AAA US 200,000.00 1.375% 1.125% 1.250% 4.500% 198,616.00 297,090.00 297,273.00 307.96 98,706.00 _ 3137EADZ9 AAA AAA US 297,417.00 297,417.00 300,000.00 12/14/17 10/15/16 Fed Nat Mtg Assn 3135GOK28 _ _ US US US 299,700.00 204,187.50 93,140.00 299,700.00 314.69 93,140.00 300,000.00 308.24 100,000.00 semi-annual 07/19/17 10/26/16 none none 04/26/19 Fed Nat Mtg Assn Remic 31393EAL3 monthly maturity 07/30/03 12/29/14 08/25/18 12/27/18 FICO Strip Cpn13 Zero Coupon 31771C2G9 FICO Strip_ Cpn Zero Coupon 31358BAA6 US 94,480.00 94,480.00 100,000.00 98,576.00 maturity 04/17/15 none 02/01/19 13,713,532.71 Ally Bank Midvale Utah 02006LF32 57803 CD 245,000.00 245,000.00 245,000.00 1.200% 242,011.00 semi-annual 06/30/16 12/30/16 07/01/19 Barclays Bank 06740KHB6 57203 CD 247,000.00 247,000.00 247,000.00 2.050% 246,140.44 semi-annual 07/03/14 01/02/15 07/02/19 Synchrony Bank 87164WBT4 27314 CD 247,000.00 247,000.00 247,000.00 2.050% 246,061.40 semi-annual 07111114 01/11/15 07/11/19 JP Morgan Chase Bank NA 48125Y51-4 628 CO 245,000.00 245,000.00 245,000.00 1.100% 241,739.05 quarterly 07/15/16 10/15/16 07/15/19 PrivateBank & Trust Co 74267GUQB 33306 CD 247,000.00 247,000.00 247,000.00 2.000% 245,994.71 semi-annual 07/21/14 01121115 07/22119 Goldman Sachs Bank USA 38147JU59 33124 CD 247,000.00 247,000.00 247,000.00 2.050% 245,878.62 Semi-annual 07/23/14 01/23115 07/23/19 Sallie Mae Bank 79545OB95 58177 CD 245,000.00 245,000.00 245,000.00 1.700% 243,062.05 semi-annual 08/09/17 02/09/18 08109/19 First Federal Svgs Bk 32021YCH4 29690 CD 249,000.00 249,000.00 249,000.00 1.500% 247,854.60 monthly 01/21/16 02/21/16 08/21/19 Victory Bank 92644LABB 58615 CD 247,000.00 247,000.00 247,000.00 2.000% 245,579.75 semi-annual 09/24/14 03/24/15 09/24/19 CommerceWest Bank NIA 20084TKXO 57176 CD 245,000.00 245,000.00 245,000.00 2.300% 244,412.00 semi-annual 04/25/18 10/25/18 10/25119 Umpqua Bk Roseburg Ore 90421MBZ5 17266 CD 245,000.00 245,000.00 245,000.00 2.350% 244,563.90 semi-annual 04/27/18 10/27/18 10128119 Third Federal Sav& Loan 88413QAW8 30012 CD 128,000.00 128,000.00 128,000.00 2.000% 127,208.96 semi-annual 11/24/14 05/24115 11/25/19 Celtic Bank 15118RJMO 57056 CD 247,000.00 247,000.00 247,000.00 2.050% 245,851.45 semi-annual 12/20/13 06/20/14 12/20/19 Steams Bank NA 857894PB9 10988 CD 247,000.00 247,000.00 247,000.00 1.000% 245,278.41 semi-annual 12126/14 06/26/15 12/26/19 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 I Due Date Jefferson Bk&Tr Co_ 472376AD4 1071 CD 245,000.00 245,000.00 245,000.00 2.450% 243,929.35 semi-annual semi-annual 04/11/18 04/11118 10/11/18 04/10/20 CitiBank NA 17312QJ34 7213 CD 245,000.00 245,000.00 245,000.00 2.550% 244,358.10 10/11/18 04/13/20 Discover Bk Greenwood Del 254673NR3 5649 CD 245,000.00 245,000.00 245,000.00 2.500% 244,135.15 semi-annual 04/11/18 10/11/18 04/13/20 Citizens Alliance Bank 17318LAP9 1402 CD 249,000.00 249,000.00 249,000.00 2.000% 246,383.01 monthly 06/27114 07/27/14 06/26/20 Enerbank USA 29266NA31 57293 CD 249,000.00 249,000.00 249,000.00 2.100% 245,464.20 monthly 07/18/14 08/18/14 07/20/20 Elbow Lake MN _ _ Kaufman TX Mounds View MN ISD #621 284281 KC5 A local 170,045.70 170,045.70 61,821.00 165,000.00 60,000.00 250,000.00 2.750% 3.000% 1.900% 163,947.30 58,837.20 246,910.00 semi-annual 12/08/14 none 02/15/17_ 12/01/19 02/15/23 02/01120 486206KR5 A3 local 61,821.00 semi-annual 06/28/16 620637V70 AA+ local 246,875.00 246,875.00 semi-annual 05/16/18 none Rothsay MN ISD #850 778731AZ2 AA+ local 208,640.25 208,640.25 195,000.00 3.000% 198,900.00 semi-annual 07/06/16 none 02/01120 Saint Paul MN Port Auth 793067CC1 AA+ local 79,756.80 79,756.80 80,000.00 2.000% 78,648.80 semi-annual 01/10/17 09101/17 03101/20 Steams Cc MN 857896MH4 AA+ local 276,875.00 276,875.00 250,000.00 4.500% 250,375.00 semi-annual 04117!13 none 06/01120 Greenway MN ISD #31 39678LDF6 AA+ local 27,593.50 27,593.50 25,000.00 5.000% 25,346.50 semi-annual 07/09/13 none 03/15/21 Cedar Rapids lA _ Multnomah Cnty OR Sch Dist 1J 150528RM1 AA1 local 217,672.00 217,672.00 200,000.00 3.000% 201,046.00 semi-annual 06/11/13 12/01/13 06/01/19 625517JMO AA1 local 250,000.00 250,000.00 250,000.00 1.450% 247,822.50 semi-annual 08/10/17 12/15/17 06/15/19 Minneapolis MN 60374YS81 AA1 local 278,632.50 278,632.50 250,000.00 3.500% 253,447.50 semi-annual 02/26/13 none 12/01/19 _ _ _ Hampton VA 4095582J1 AA1 local 100,836.00 100,836.00 100,000.00 2.209% 99,274.00 semi-annual 01/20/16 none 04/01/20 Middleton WI 596782RX2 AA1 AA1 local 106,979.00 106,979.00 100,000.00 3.750% 100,322.00 semi-annual 02/24/15 none 09/01/20 Des Moines IA Area Cmnty Col 250097H21 local 50,606.00 50,606.00 50,000.00 2.450% 49,315.00 semi-annual 11/10/14 12/01/14 06/01/21 Minneapolis MN 60374YG68 AA1 local 110,419.00 110,419.00 100,000.00 4.700% 101,491.00 semi-annual semi-annual semi-annual semi-annual semi-annual 10/31/11 12122/16 06/27/13 08116/11 07/17/13 none none 12101/13 04/01/12 02/01/14 03/01123 06/01119 06/01/19 10/01/19 02/01/20 Sioux City IA Waterloo IA 829458FC7 _ AA2 AA2 AA2 local local local 156,100.50 50,559.50 100,000.00 286,268.00 156,100.50 50,559.50 100,000.00 286,268.00 155,000.00 50,000.00 100,000.00 295,000.00 2.000% 2.000% 3.150% 2.400% 154,345.90 49,770.00 100,856.00 294,109.10 941647PAl Western Lake Superior MN 958522WU4 Portsmouth VA 73723RSL8 AA2 local Brunswick Cnty 117061VH1 AA2 AA2 AA2 _local local local 108,967.10 259,715.00 279,760.50 108,820.00 108,967.10 110,000.00 1.740% 107,261.00 semi-annual 08/21/15 03/10/17 01/21/15 11/14/11 none none none none 05/01/20 03/01/21 02/01/23 02/01/20 Fon Du Lac Cnty WI Alexandra MN ISD #206 344442KK3 015131LQ6 259,715.00 279,760.50 108,820.00 250,000.00 270,000.00 100,000.00 3.250% 3.000% 3.800% 251,565.00 268,631.10 semi-annual semi-annual semi-annual Moorhead MN 6161412R7 AA3 local 101,792.00 Whitewater Wis 966204KA6 AA3 local 109,541.00 109,541.00 100,000.00 4.850% 105,049.00 semi-annual 06/09/11 none 12/01/20 West Bend Wl 951428BNO AA3 local 97,805.00 97,805.00 100,000.00 1.900% 96,275.00 semi-annual 01/11/18 none 04/01/22 W Palm Beach FL 955116BE7 AA3 local 101,245.00 101,245.00 100,000.00 2.264% 94,661.00 semi-annual 07/05/16 10/01/16 10/01/22 Palm Beach Cnty, FLA 696497TR7 AAA local 174,889.50 174,889.50 150,000.00 5.898% 151,597.50 semi-annual 07/06/11 none 06/01/19 Tenn Val Auth Cpn Strip Zero Cpn 88059EWZ3 AAA local 262,890.00 262,890.00 300,000.00 291,930.00 maturity 12/27/13 none 06/15/19 Norwalk Conn 668844DS9 AAA local 122,464.80 122,464.80 120,000.00 4.050% 120,301.20 semi-annual 08/04/10 08/01/11 08/01/19 Greensboro NC 395460V21 AAA local 366,832.80 366,832.80 360,000.00 3.263% 364,032.00 semi-annual 07/15/11 none 10/01/19 Saint Paul MN Port Auth 793028WS6 AAA local 201,806.00 201,806.00 200,000.00 2.000% 197,818.00 semi-annual 12/22/16 08/01/17 02/01/20 _ Woodbury MN 97913PCO7 AAA AAA local 123,037.35 123,037.35 115,000.00 3.250% 115,670.45 semi-annual 12/22/11 none 02/01/20 Dallas TX Indpt Sch Dist 235308OK2 local 116,900.00 116,900.00 100,000.00 4.450% 103,278.00 semi-annual 04/16112 08/15/11 02/15/20 Tenn Valley Auth Zero Cpn 88059EHD9 AAA local 263,970.00 263,970.00 300,000.00 285,117.00 maturity 03/11/13 none 05/01/20 Salt Lake County UT 795676QL2 AAA local 368,212.50 368,212.50 375,000.00 1.800% 368,486.25 semi-annual 05/18/18 06/15/13 06/15/20 Tenn Val Auth Cpn Strip Zero Cpn 88059EMX9 AAA local 88,133.00 88,133.00 100,000.00 94,512.00 maturity 03/18/13 none 07/15120 McAllen TX Dev Corp 579086AW9 AAA local 175,000.00 175,000.00 175,000.00 1.400%1 170,063.25 semi-annual 07/26/16 02/15/17 08/15/20 Indianapolis Ind 45528UGF2 AAA local 251,507.50 251,507.50 250,000.00 2.219°b 247,017.50 semi-annual 07/11/17 07/15/13 01/15121 Baltimore Cnty MD 05914FME7 AAA local 51,290.00 51,290.00 50,000.00 2.097%1 49,008.50 semi-annual 08/31/16 none 08/01121 4,535,906.15 CD Description Number Credit DIC# Rating/F Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Date Acquired Coupon Date ry l Due Due Date New York St Mtge Agy 64988RHGO AAA local 100,000.00 100,000.00 100,000.00 2.375% 97,434.00 semi-annual 10/27/15 04/01/16 10/01/21 Columbus OH 199492CS6 AAA local 39,956.40 39,956.40 40,000.00 2.133% 38,815.60 semi-annual 02/20/15 none 12/01/21 Outagamie Cnty Wl 68990OB98 AAA local 170,000.00 170,000.00 170,000.00 2.350% 166,243.00 semi-annual 11/07/17 05/01/18 11/01/22 Connecticut State 20772JQN5 At state 214,954.00 214,954.00 200,000.00 200,000.00 3.517% 201,180.00 semi-annual 05/27/16 02/15/14 08/15121 Massachusetts State 57582P2T6 AA1 state 199,744.00 199,744.00 2.090% 198,174.00 semi-annual 12/17/14 11/01/14 05/01/20 Florida StHurricane Minnesota St Colleges & Univ 34074GDH4 AA3 slate 279,439.80 279,439.80 270,000.00 100,000.00 200,000.00 45,000.00 2.995% 2.000% 271,314.90 semi-annual 11/10/15 07/01/13 07/01/20 60414FPJ3 AA3 state 100,000.00 100,000.00 98,323.00 semi-annual 02/26/15 10/01/15 10/01120 Florida St Dept Environmental 34160WUAO AA3 state 217,800.00 217,800.00 6.206% 207,090.00 semi-annual 08/30/10 07101/10 07/01122 Tennessee State 880541Q03 AAA state 48,218.85 48,218.85 3.178% 45,584.10 semi-annual 08/30/16 02101/12 08101/20 Virginia State 928109XD4 AAA state 22,126.00 22,126.00 20,000.00 4.100% 20,330.80 semi-annual 02/07/12 none 06/01121 Kentucky St Hsg Corp 49130TSHO AAA state 203,458.00 203,458.00 200,000.00 2.780% 198,076.00 semi-annual 03/29/17 none 07/01121 Georgia State 373384208 AAA state 204,444.00 204,444.00 200,000.00 2.780% 197,948.00 semi-annual 12113/16 none 02/01/23 Fed Home Ln Mtg Corp 3137EADK2 AAA US 249,035.00 249,035.00 250,000.00 1.250% 246,937.50 semi-annual 07/07/17 02/01/13 Fed Home Ln Mtg Corp Med Term Note 3134G96U6 AAA US 200,000.00 200,000.00 200,000.00 1.050% 196,914.00 quarterly 08/23/16 11/23/16 _08/01/19 08/23/19 Fed Home Ln Bank _ _ _ Fed Farm Credit Bank Fed Farm Credit Bank 313383VN8 AAA US 301,065.00 301,065.00 300,000.00 2.000°h 298,770.00 semi-annual 12/07/17 none 09/13/19 3133EGVJ1 AAA US 297,300.00 297,300.00 300,000.00 1.160% 295,134.00 semi-annual none 09/26/19 3130ACLS1 AAA US 248,227.50 248,227.50 250,000.00 1.550% 247,260.00 semi-annual _12/08/17 01/04/18 04/11/16 10/11/19 Fed Home Ln Bank RFCSP Ship Principal Zero Coupon Fed Nall Mtg Assn 313OA8NRO AAA US 294,603.00 294,603.00 300,000.001.125°k 294,870.00 semi-annual 04/10/18 07/22/15 02/09/18 05125116 11/02/15 11/03/17 10/11/16 none 10/28/16 11/25/16 none none 10/11/19 10/15/19 10/28/19 11125/19 11/29/19 76116FAA5 AAA US 185,568.00 98,570.00 185,568.00 98,570.00 200,000.00 193,424.00 98,633.00 maturity semi-annual semi-annual maturity 3135GOJ95 3133EGBKO AAA_ AAA _ AAA US 100,000.00 200,000.00 1,000,000.00 225,000.00 1.350% 1.300% Fed Farm Credit Bank US 199,600.00 199,600.00 196,770.00 962,460.00 221,436.00 Fed Home Ln Mtg Corp Zero Cpn Fed Farm Credit Bank 313400BV4 US 950,527.00 950,527.00 223,031.25 1.330% 3133EGFRI AAA US 223,031.25 147,300.00 semi-annual 12/16/19 Fed Home Ln Bank 313381ND3 AAA AAA US US 147,300.00 150,000.00 1.450% 147,615.00 semi-annual 03/23/18 none 01/09/20 Fed Home Ln Mtg Corp Fed Home Ln Bank 3137EAEE5 297,912.00 297,912.00 300,000.00 100,000.00 1.500% 295,641.00 98,435.00 semi-annual semi-annual 12/07/17 07/22/15 07/17/17 08/10/15 01/17/20 02/10/20 3130A3XL3 AAA US 99,500.00 99,500.00 1.500% Fed Home Ln Mlg Corp Med Term Note 3134GBS78 AAA US 200,000.00 200,000.00 200,000.00 1.500% 197,642.00 semi-annual 10/27/17 04/27/18 10/27/20 Fed Home Ln Mtg Corp 3137EAEK1 AAA AAA US 299,193.00 299,193.00 300,000.00 1.875% 295,104.00 semi-annual 12/07117 05/17/18 11/17/20 Fed Farm Credit Bank 3133EJPW3 US 299,769.00 299,769.00 300,000.00 2.700% 300,918.00 semi-annual 05121/18 06/21/18 12/21/20 Fed Natl Mtg Assn 3136G4JM6 AAA US 200,000.00 200,000.00 200,000.00 1.850% 195,020.00 semi-annual 12/28/16 06/28/17 12/28/20 17,318,232.60 Itasca County Minn 465452GP9 A local 105,024.00 105,024.00 100,000.00 5.550% 101,103.00 semi-annual 07/12/11 none 02/01/28 Chaska MN 161663653 AA local 94,191.30 94,191.30 90,000.00 4.000% 91,536.30 semi-annual 09/08/14 none 02/01/24 Mitchell SD Sch Dist#17-2 606687EHO AA local 116,702.00 116,702.00 100,000.00 6.000% 103,486.00 semi-annual 12/20/11 06/15/19 06/15/24 Lake City Minn ISD #813 508084DW7 AA- AA+ local 103,933.00 103,933.00 100,000.00 5.000% 102,438.00 semi-annual 05/11/11 none 02/01125 Milaca Minn ISD#912 598699NT9 local 106,941.00 106,941.00 100,000.00 5.650% 101,652.00 semi-annual 07/22/11 none 02/01/27 Minneapolis MN _ _ 60374YG76 AA1 local 72,201.35 72,201.35 65,000.00 4.800% 66,002.30 semi-annual 12/09114 none 03/01/24 Ann Arbor Ml 035438CF5 AAt local 262,025.00 262,025.00 250,000.00 5.750% 256,557.50 semi-annual 12/27/17 05/01/19 05/01/27 Duluth MN 264438ZL9 AA2 local 29,767.20 29,767.20 30,000.00 2.625% 28,812.90 semi-annual 12/05112 08/01/13 02/01/25 Will County IL Cmnty Zero Coupon _ _ _ 969078QM9 AA2 local 159,000.00 159,000.00 500,000.00 340,150.00 maturity 08/25/09 none 11/01/27 Hawkins Cnty TN 420218PL7 AA3 local 111,480.00 111,480.00 100,000.00 4.800% 101,382.00 semi-annual 03/13/12 none 05/01/24 Savage Minn 80465PAN4 AAA local 198,018.00 198,018.00 200,000.00 4.800% 204,676.00 semi-annual 06/17110 02/01/11 02/01/24 6,561,322.15 local 1,438,020.80 state 4,782,983.50 US 1- 5 Years 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 Tennessee Valley Auth Ser E 880591CJ9 AAA local 121,500.00 121,500.00 100,000.00 6.750% 124,709.00 250,000.00 semi-annual maturity 03/19/09 none 11/01/25 Ice Deposit- National Sports Center none local 250,000.00 250,000.00 250,000.00 2.100% 5.250% 02/06/08 none 01/01/26 Fed Home Ln Bank 3130A8W33 AAA US 39,000.00 39,000.00 40,000.00 37,223.60 semi-annual 07/27/17 02/26/10 08/22/17 08/22/25 04/21/28 Fed Farm Credit Bank 31331VLC8 AAA 106,030.45 106,030.45 100,000.00 117,188.00 semi-annual none _ _US 2,026,916.60 Van Buren Mich Public Schools 920729HD5 AA1 local 102,750.00 102,750.00 100,000.00 6.430% 05/01/29 103,470.00 semi-annual 07/17/09 11/01/09 103,470.00 33,162,151.91 1,872,505.00 local 154,411.60 US 6 - 10 Years 103,470.00 local 10+ Years INVESTMENT SCHEDULE - Money Market Funds May 31, 2018 Description Current Market Value YTD Interest WeIIs Fargo 1 Wells Fargo Government Money Market Fund $1,185,785.041 $12,039.77 4M I 14M 1,009,836.121 5,238.29 4M PLUS I 4M Plus 1 6,973.631 39.59 Premier Bank I Premier Bank Money Market 275,874.61 285.14 Grand Total Money Market Funds 1 $2,478,469.40 1 $17,602.79 Updated: 6111/2018