Loading...
HomeMy WebLinkAbout[06] Debt Management Study Council Agenda Item 6 MEETING DATE: June 4, 2018 AGENDA ITEM: Tammy Omdal - Debt Management Study SUBMITTED BY: Finance /Financial Advisor BOARD/COMMISSION/COMMITTEE RECOMMENDATION: None PREVIOUS COUNCIL ACTION: None BACKGROUND INFORMATION: Annually, Tammy Omdahl, financial advisor from Northland Securities, prepares an analysis of the outstanding bonds held by the City of St. Joseph. Attached is the 2018 debt study (with balances as of 12/31/17) Tammy prepared with the assistance of finance. The debt study provides information of what the required tax levies and other revenue sources should be, what debts might be a candidate to refund or payoff early, how many years remain on each debt, and the summary of the debt costs versus the requirements to pay the total debt. The study only includes bonds issued as of the most recent audited financial statements, including the 2018 equipment certificates. BUDGET/FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action 2018 Debt Management Study REQUESTED COUNCIL ACTION: The debt management study is information only for the council. e c n a n i F c i l b u P 8 d 1 n 0 a 2 l / h 4 t / r 6 o N y NorthlandSecurities,Inc. b d e r a p e r P 150SouthFifthStreet,Suite3300,Minneapolis,MN55402 MemberFINRAandSIPC|RegisteredwithSECandMSRB DebtStudyforYear2018 CityofSt.Joseph Main:(612)851-5900/Direct:(612)851-4964/Email:tomdal@northlandsecurities.com NorthlandSecurities,Inc. 150SouthFifthStreet,Suite3300,Minneapolis,MN55402 MemberFINRAandSIPC|RegisteredwithSECandMSRB Main:(612)851-5900/Direct:(612)851-4964/Email:tomdal@northlandsecurities.com ) ” y d u t S “ e h t ( y d u t S t b e D 8 1 0 2 : E May31,2018LoriBartlett,FinanceDirectorCityofSaintJosephP.O.Box668SaintJoseph,MN56374RDearLori:NorthlandhascompletedastudyoftheCity’sexistingdebtoutstandingandestimatedsourcesofrevenueforrepayment.Thi sstudywascompletedatthedirectionoftheCity.TheCityusestheissuanceofdebtasanimportantandessentialtoolforfinancingtheconstructionofpublicimprovementsandtoacquirecapitalequipment.Ongoingdebtmanagementisi mportanttomonitortherepaymentofexistingdebtobligationsandtobewellpreparedforthefutureissuanceofdebt.TheStudyisintendedtoserveasaguidefortheCity’sfinancialmanagementofitsdebtobligations.Alldebtobligat ionsidentifiedbytheCityareincludedintheStudy.TheStudyisbuiltaroundidentifiedkeyassumptions,includingassumptionsforfuturerevenuesources.Thisincludesestimatesforthepaymentofoutstandingspecialassessment s.TotheextenttheassumptionsintheStudychangeinthemonthsandyearsahead,whichtheywill,theCitywillneedtocontinuetoadjustitsfinancialandbudgetplansaccordingly.Thestepstakenaspartofthestudyprocessincludedth eCityprovidinginformationtoNorthlandonpastfinancialinformation,includingcashbalancesandverificationofcurrentsourceoffundsfordebtpayment.InformationprovidedbytheCitywasorganized,analyzed,andusedtosupp ortthedevelopmentoffinancialplansforeachseriesofdebtoutstandingbypurpose.TheStudydidnotincludereconciliationtotheCity’smostrecentauditedfinancialstatementsbyNorthland.Also,theStudydidnotincludearevie woftheutilityfundstoverifyratesaresetatalevelsufficienttomeetexistingoutstandingdebtobligations.Sincerely,NORTHLANDSECURITIESTammyOmdalSeniorVicePresident r 6789012345678901 124 e 111111111122 b m u N e g a P s e S c r T u o N S E e T u n N e v O e C R l F a t o O T E d L n a B s t A n T e n o m i t y r a o P P l a d t e n o s a T o s , p e g r i re n u i c e P i d S v n d r y a n e t b a S s t g t s u n e b i i e r O d e t D n S b r a t e o d s f Dt n y l uo g v a B O t n e i t ty L i t s b b x i m e s xa s a EDT n t n a fff a a l r ooo DP T l yyy f f rrr Chart1–TaxLevyforDebtServiceChart2–DebtOutstandingatYearEndChart3–SourceofRevenueforPaymentonDebtOutstandingChart4–AmortizationofDebtOutstandingChart5–DebtServicePaidfromWaterRevenuesChart6–DebtServi cePaidfromSanitarySewerRevenuesChart7–DebtServicePaidfromSpecialAssessmentRevenuesChart8–DebtServicePaidfromSalesTaxRevenueChart9–DebtServicePaidfromAllOtherRevenueSourcesG.O.CrossoverRefundingBonds, Series2009AG.O.CapitalImprovementPlanRefundingBonds,Series2009BG.O.WastewaterRevenueBonds,Series2009BG.O.WastewaterTreatmentBonds,Series2010G.O.SewerRevenueBonds,Series2010AG.O.ImprovementBonds,Serie s2010B-RefundingPortionG.O.ImprovementBonds,Series2010B-NewMoneyPortion a o i o aaa c s r t mmm n e r t a a mmm t n h uuu ei LSSSCF TABLEOFCONTENTS 234567890123456789012 222222223333333333444 G.O.Bonds,Series2011A-ImprovementRefundingPortionG.O.Bonds,Series2011A-CIPPortionG.O.Bonds,Series2011A-EquipmentPortionG.O.Bonds,Series2011A-SystemPortionG.O.WaterRevenueCrossoverRefundingBonds,Serie s2012AG.O.Bonds,Series2013A-ImprovementPortionG.O.Bonds,Series2013A-SewerPortionG.O.Bonds,Series2013A-EquipmentPortionG.O.SewerRevenueBonds,Series2013BG.O.Bonds,Series2014A-ImprovementPortionG.O.Bond s,Series2014A–SystemPortionG.O.Bonds,Series2015A-ImprovementPortionG.O.Bonds,Series2015A-EquipmentPortionG.O.TaxAbatementBonds,Series2015BG.O.CapitalImprovementPlanBonds,Series2016AG.O.ImprovementBon ds,Series2016BG.O.CapitalImprovementPlanBonds,Series2017AG.O.Bonds,Series2017B-ImprovementPortionG.O.Bonds,Series2017B-SystemPortionCityPortionofSt.Cloud2017PublicFacilitiesAuthorityLoanG.O.Bonds,Ser ies2018A-EquipmentCertificates TABLEOFCONTENTS Page1of42 1,361,3701,217,8901,111,0601,088,3781,109,7871,138,7811,188,0181,233,6561,288,5941,344,9911,403,2231,447,6361,491,9481,517,2551,544,0871,562,7471,581,3261,599,8181,618,4431,623,435 Balance 35,589,619 EndingCash 490,725493,767391,854390,167388,326391,113104,836 Total 2,726,6262,709,3452,623,1342,504,5022,268,3222,206,9692,157,1272,114,6651,491,1681,497,8451,459,4801,164,3741,100,731 28,675,077 0 Levy 697,290735,929781,431737,826658,117674,460637,462589,860495,151498,963473,715473,699475,478314,722318,901285,446283,648281,708284,409 NetTax 9,698,214 0000000000000000 48,64424,00024,00022,000 Less: 118,644 Other Revenues 0 8,2927,0466,2684,7653,6883,1392,7242,2061,9202,0142,1142,2112,3101,9382,0731,5351,6371,7391,841 59,460 Less: Income Interest 00000 20,00020,000 179,742182,682180,267183,102180,582183,312180,031181,999183,154178,902174,649170,397166,073 2,364,891 Less:Sales TaxRevenue 000000000000 19,25019,25019,25019,25013,25013,25013,25013,250 130,000 Water Less:Storm 00000 21,49320,82122,73222,428 710,020701,706690,186687,616679,910603,362611,585613,002135,425145,007146,335 Less: Water 5,811,625 SOURCESOFFUNDSFORDEBTSERVICESPAYMENTS 772,978844,416733,024700,028628,469628,348621,417626,572625,524624,198627,407461,965402,087109,820108,853104,873104,882104,879104,863104,836 9,039,439 Sewer Less:Sanitary 00000 90,65987,77649,99348,76135,26034,61133,96221,51321,513 290,411194,316188,709149,915104,307101,098 1,452,804 Assessments Less:Special 488,689490,281391,854390,167388,326391,113104,836 Levy 3,016,7772,995,4662,866,4622,653,5442,359,2582,286,8742,213,2852,172,4771,508,0421,513,5201,471,3111,175,9601,109,239 105%of 29,987,482 99,844 465,418466,935373,194371,588369,834372,489 2,873,1212,852,8242,729,9642,527,1842,246,9132,177,9752,107,8912,069,0261,436,2311,441,4471,401,2491,119,9621,056,418 28,559,507 toTaxLevy P&ISubject 0 98,762 813,155461,481 9,948,9538,120,7766,879,2565,602,2804,333,6323,314,4152,334,4131,921,9141,498,3721,158,786 Debt 22,214,72819,875,04317,608,45915,496,98413,620,39211,771,674 Outstanding 99,844 465,418466,935373,194371,588369,834372,489 2,873,1212,852,8242,729,9642,527,1842,246,9132,177,9752,107,8912,069,0261,436,2311,441,4471,401,2491,119,9621,056,418 28,559,507 9,7701,081 76,41552,92043,39233,60825,95718,160 552,414513,140463,380415,709370,320329,257285,169240,849194,711164,472132,600100,745 4,024,072 98,762 980,003412,498423,542339,586345,630351,674362,718 DEBTSERVICEPAYMENTS 2,320,7072,339,6852,266,5842,111,4751,876,5921,848,7181,822,7221,828,1771,241,5201,276,9751,268,6481,019,217 N 24,535,435 M , h p e s o J . t S f FiscalPrincipalInterestTotal 20182019202020212022202320242025202620272028202920302031203220332034203520362037 YEAR o SummaryofExistingDebtOutstanding,TotalPaymentsandTotalRevenueSources y t i C 0 2029 Page2of42 273,444165,000130,000135,000140,000760,972 1,710,000 3,314,415 00 2028 55,000 542,146325,000170,000270,000190,000851,486 1,930,000 4,333,632 0 2027 806,219115,000150,000110,000480,000210,000405,000240,000941,062 2,145,000 5,602,281 2026 34,000 225,000295,000160,000630,000250,000540,000290,000 1,065,6632,360,0001,029,593 6,879,256 000 2025 68,000 325,000435,000210,000775,000285,000675,000340,000 1,320,5912,570,0001,117,184 8,120,776 0 2024 65,00065,00042,000 865,000570,000260,000915,000320,000805,000390,000102,000 1,571,1162,775,0001,203,836 9,948,953 0 2023 50,00084,000 125,000700,000305,000355,000125,000930,000440,000136,000 1,817,1261,390,0001,050,0002,975,0001,289,549 11,771,674 0 2022 56,000 185,000100,000830,000350,000390,000185,000490,000126,000170,000 2,059,0701,895,0001,185,0001,055,0003,170,0001,374,322 13,620,392 00000 2021 70,000 240,000145,000955,000395,000425,000245,000540,000168,000204,000110,000 2,296,7252,390,0001,315,0001,175,0003,365,0001,458,259 15,496,984 000 2020 40,00020,00045,00025,000 295,000140,000190,000435,000460,000305,000590,000210,000239,000140,000163,000 2,530,2022,875,0001,075,0001,440,0001,295,0003,555,0001,541,257 17,608,459 0 2019 85,00020,00040,00085,00050,00035,000 135,000350,000275,000235,000475,000495,000365,000640,000252,000274,000211,000215,000 2,759,7283,350,0001,195,0001,560,0001,410,0003,740,0001,623,316 19,875,043 00 2018 95,00040,00060,00075,00070,000 130,000270,000405,000410,000125,000275,000515,000530,000425,000690,000294,000309,000282,000265,000 2,985,1893,825,0001,315,0001,675,0001,525,0003,920,0001,704,539 22,214,728 N M , h p e s o J . t S f SummaryofDebtOutstandingbySeriesandPortionCollectionYear G.O.CrossoverRefundingBonds,Series2009AG.O.CapitalImprovementPlanRefundingBonds,Series2009BG.O.WastewaterRevenueBonds,Series2009BG.O.Wastewate rTreatmentBonds,Series2010G.O.SewerRevenueBonds,Series2010AG.O.ImprovementBonds,Series2010B-RefundingPortionG.O.ImprovementBonds,Series2010B-NewMoneyPortionG.O.Bonds,Series2011A-ImprovementRefundingP ortionG.O.Bonds,Series2011A-CIPPortionG.O.Bonds,Series2011A-EquipmentPortionG.O.Bonds,Series2011A-SystemPortionG.O.WaterRevenueCrossoverRefundingBonds,Series2012AG.O.Bonds,Series2013A-ImprovementPort ionG.O.Bonds,Series2013A-SewerPortionG.O.Bonds,Series2013A-EquipmentPortionG.O.SewerRevenueBonds,Series2013BG.O.Bonds,Series2014A-ImprovementPortionG.O.Bonds,Series2014A-SystemPortionG.O.Bonds,Series 2015A-ImprovementPortionG.O.Bonds,Series2015A-EquipmentPortionG.O.TaxAbatementBonds,Series2015BG.O.CapitalImprovementPlanBonds,Series2016AG.O.ImprovementBonds,Series2016BG.O.CapitalImprovementPlanBon ds,Series2017AG.O.Bonds,Series2017B-ImprovementPortionG.O.Bonds,Series2017B-SystemPortionCityportionofSt.CloudPublic2017FacilitiesAuthority(PFA)LoanG.O.Bonds,Series2018A-EquipmentCertificates Total o y t i C Page3of42 (0) (0) 2037 0 2036 98,762 98,762 2035 265,000196,481 461,481 2034 520,000293,155 813,155 2033 770,000388,786 1,158,786 00 2032 483,372 1,015,000 1,498,372 2031 45,00045,000 576,914 1,255,000 1,921,914 000 2030 90,00090,000 669,413 1,485,000 2,334,413 Continuedfrompriorpage SummaryofDebtOutstandingbySeriesandPortionCollectionYear G.O.CrossoverRefundingBonds,Series2009AG.O.CapitalImprovementPlanRefundingBonds,Series2009BG.O.WastewaterRevenueBonds,Series2009BG.O.Wastewate rTreatmentBonds,Series2010G.O.SewerRevenueBonds,Series2010AG.O.ImprovementBonds,Series2010B-RefundingPortionG.O.ImprovementBonds,Series2010B-NewMoneyPortionG.O.Bonds,Series2011A-ImprovementRefundingP ortionG.O.Bonds,Series2011A-CIPPortionG.O.Bonds,Series2011A-EquipmentPortionG.O.Bonds,Series2011A-SystemPortionG.O.WaterRevenueCrossoverRefundingBonds,Series2012AG.O.Bonds,Series2013A-ImprovementPort ionG.O.Bonds,Series2013A-SewerPortionG.O.Bonds,Series2013A-EquipmentPortionG.O.SewerRevenueBonds,Series2013BG.O.Bonds,Series2014A-ImprovementPortionG.O.Bonds,Series2014A-SystemPortionG.O.Bonds,Series 2015A-ImprovementPortionG.O.Bonds,Series2015A-EquipmentPortionG.O.TaxAbatementBonds,Series2015BG.O.CapitalImprovementPlanBonds,Series2016AG.O.ImprovementBonds,Series2016BG.O.CapitalImprovementPlanBon ds,Series2017AG.O.Bonds,Series2017B-ImprovementPortionG.O.Bonds,Series2017B-SystemPortionCityportionofSt.CloudPublic2017FacilitiesAuthority(PFA)LoanG.O.Bonds,Series2018A-EquipmentCertificates Total N M , h p e s o J . t S f o y t i C 00000000000000000000000 2030 Page4of42 20,82110,000 162,500282,157 475,478 00000000000000000000000 2029 21,49310,000 160,000282,206 473,699 00000000000000000000000 2028 22,14410,000 160,000281,572 473,715 0000000000000000000000 2027 22,77410,00020,000 160,000286,190 498,963 0000000000000000000000 2026 20,70010,00020,000 159,000285,452 495,151 0000000000000000000 2025 20,00021,25135,00010,00044,00020,000 155,000284,609 589,860 000000000000000000 2024 20,00045,00021,80235,00010,00045,00025,000 152,000283,660 637,462 00000000000000000 2023 20,00042,00021,85430,00010,00046,00025,00057,000 140,000282,606 674,460 00000000000000000 2022 15,00040,00022,31325,00010,00047,00020,00057,000 135,000286,804 658,117 00000000000000 2021 15,00062,00015,00022,00035,00022,68020,00010,00048,00020,00057,500 125,000285,646 737,826 000000000000 2020 5,000 50,00010,00055,00020,00022,00025,00023,04820,00035,00049,00020,00058,000 105,000284,383 781,431 0000000000000 2019 6,0005,000 40,00055,00023,00022,00015,00090,00022,91515,00036,00051,00015,00057,000 283,014 735,929 0000000000000 2018 6,0005,0009,000 57,00035,00050,00023,00020,79010,00057,00080,00022,50015,00037,000 270,000 697,290 N M , h p e s o J . t S f SummaryofTaxLevyforDebtServiceCollectionYear G.O.CrossoverRefundingBonds,Series2009AG.O.CapitalImprovementPlanRefundingBonds,Series2009BG.O.WastewaterRevenueBonds,Series2009BG.O.WastewaterTreatmentBo nds,Series2010G.O.SewerRevenueBonds,Series2010AG.O.ImprovementBonds,Series2010B-RefundingPortionG.O.ImprovementBonds,Series2010B-NewMoneyPortionG.O.Bonds,Series2011A-ImprovementRefundingPortionG.O.Bo nds,Series2011A-CIPPortionG.O.Bonds,Series2011A-EquipmentPortionG.O.Bonds,Series2011A-SystemPortionG.O.WaterRevenueCrossoverRefundingBonds,Series2012AG.O.Bonds,Series2013A-ImprovementPortionG.O.Bonds ,Series2013A-SewerPortionG.O.Bonds,Series2013A-EquipmentPortionG.O.SewerRevenueBonds,Series2013BG.O.Bonds,Series2014A-ImprovementPortionG.O.Bonds,Series2014A-SystemPortionG.O.Bonds,Series2015A-Improv ementPortionG.O.Bonds,Series2015A-EquipmentPortionG.O.TaxAbatementBonds,Series2015BG.O.CapitalImprovementPlanBonds,Series2016AG.O.ImprovementBonds,Series2016BG.O.CapitalImprovementPlanBonds,Series201 7AG.O.Bonds,Series2017B-ImprovementPortionG.O.Bonds,Series2017B-SystemPortionCityportionofSt.CloudPublic2017FacilitiesAuthority(PFA)LoanG.O.Bonds,Series2018A-EquipmentCertificates Total o y t i C Page5of42 000000000000000000000000000 0 2037 00000000000000000000000000 2036 284,409 284,409 00000000000000000000000000 2035 281,708 281,708 00000000000000000000000000 2034 283,648 283,648 00000000000000000000000000 2033 285,446 285,446 000000000000000000000000 2032 22,42810,000 286,473 318,901 000000000000000000000000 2031 22,73210,000 281,991 314,722 Continuedfrompriorpage SummaryofTaxLevyforDebtServiceCollectionYear G.O.CrossoverRefundingBonds,Series2009AG.O.CapitalImprovementPlanRefundingBonds,Series2009BG.O.WastewaterRevenueBonds,Series2009BG.O.WastewaterTreatmentBo nds,Series2010G.O.SewerRevenueBonds,Series2010AG.O.ImprovementBonds,Series2010B-RefundingPortionG.O.ImprovementBonds,Series2010B-NewMoneyPortionG.O.Bonds,Series2011A-ImprovementRefundingPortionG.O.Bo nds,Series2011A-CIPPortionG.O.Bonds,Series2011A-EquipmentPortionG.O.Bonds,Series2011A-SystemPortionG.O.WaterRevenueCrossoverRefundingBonds,Series2012AG.O.Bonds,Series2013A-ImprovementPortionG.O.Bonds ,Series2013A-SewerPortionG.O.Bonds,Series2013A-EquipmentPortionG.O.SewerRevenueBonds,Series2013BG.O.Bonds,Series2014A-ImprovementPortionG.O.Bonds,Series2014A-SystemPortionG.O.Bonds,Series2015A-Improv ementPortionG.O.Bonds,Series2015A-EquipmentPortionG.O.TaxAbatementBonds,Series2015BG.O.CapitalImprovementPlanBonds,Series2016AG.O.ImprovementBonds,Series2016BG.O.CapitalImprovementPlanBonds,Series201 7AG.O.Bonds,Series2017B-ImprovementPortionG.O.Bonds,Series2017B-SystemPortionCityportionofSt.CloudPublic2017FacilitiesAuthority(PFA)LoanG.O.Bonds,Series2018A-EquipmentCertificates Total N M , h p e s o J . t S f o y t i C Page6of42 ) 7 1 0 2 , 1 3 r e b e c m i e v c r e e D f S o t s b 1 a e t g r n D i a d r h n o a f C t s y t u v O e t L b x e a D T g n i t s i x E r o F ( N M , h p 2018201920202021202220232024202520262027202820292030203120322033203420352036 e s o J . $0 t S f o y t$900,000$800,000$700,000$600,000$500,000$400,000$300,000$200,000$100,000 i C Page7of42 d n ) 7 E -1 r 0 2 a , e 1 Y 3 r t e a b g m e n i c 2 e d t D r n f a a o t h s s a C t t u b e O D t n b o e d D e s l a a B t ( o T N M , h p 2018201920202021202220232024202520262027202820292030203120322033203420352036 e s o J . t $5.0$0.0 S $25.0$20.0$15.0$10.0 f snoilliM o y t i C Page8of42 g n i d n 5% a t s t u O ) 7 SpecialAssessments t 1 b 0 e 2 32% , D 1 Revenue l 3 a r t e SanitarySewer b o T m e n c e o 3 D t t f r 20% n o a e s a h m C g y WaterRevenue n i a d P n a r t s o t f u e O u t b n e 34% e D (TaxLevy v e R f o e c r 8% u o S SalesTaxRevenue 1% N M , h p e AllOtherRevenue s o J . t S f o y t i C %001 %99 Page9of42 %79 %69 %49 %39 %19 t ) 7 b 1 e 0 2 %78 D , 1 g 3 n r i e %38 d b n m a e t c %77 s e 4 t D t f u r o O a s %27 f a h o C g n i n d %76 o n i a t t a s t z i u %06 t O r t o b e m %25 D ( A %54 %73 %82 %91 N M , h p %9 e 12345678910111213141516171819 s o 2018201920202021202220232024202520262027202820292030203120322033203420352036 J . t S f 0% o 80%60%40%20% y t 120%100% i C Page10of42 e ) u 7 1 n 0 e 2 v , 1 e 3 R r r e b e t m a e c W e 5 D y t f r b o a s d a h i a C g n P i d e n c a i t s v t r u e O S t t b e b D e ( D N M , h p 2018201920202021202220232024202520262027202820292030203120322033203420352036 e s o J . $0 t S f o y t$800,000$700,000$600,000$500,000$400,000$300,000$200,000$100,000 i C Page11of42 e u n e v ) e 7 1 R 0 r 2 , e 1 3 w r e e S b y m r e c a e t 6 i D t n f r o a a s S a h y C g b n i d d i n a a t s P t u e O c i t v b r e e D ( S t b e D N M , h p 20182019202020212022202320242025202620272028202920302031203220332034203520362037 e s o J . $0 t S f o y t$900,000$800,000$700,000$600,000$500,000$400,000$300,000$200,000$100,000 i C Page12of42 s t n e ) 7 m 1 s 0 s 2 , e 1 s 3 s r A e b l a m i e c c e e 7 D p t f S r o a y s a h b C g d n i i d a n P a t e s t c u i v O r t e b e S D t ( b e D N M , h p 2018201920202021202220232024202520262027202820292030203120322033203420352036 e s o J . $0 t S f o $50,000 y t$350,000$300,000$250,000$200,000$150,000$100,000 i C Page13of42 e u ) n 7 e 1 v 0 2 e , R 1 3 x r a e T b s m e e l c e a 8 D S t f r y o a s b a h d C g i n i a d P n a e t c s i t u v r O e t S b e t D ( b e D N M , h p 2018201920202021202220232024202520262027202820292030203120322033203420352036 e s o J . $0 t S f o $80,000$60,000$40,000$20,000 y t$200,000$180,000$160,000$140,000$120,000$100,000 i C Page14of42 s e e c r u u ) n o 7 e S 1 v 0 r 2 e e , R h 1 t 3 r r O e e d h b t n m a O e , c l e l e 9 D A m t f o r y o c a s b n a h I d t C g i s n i a e d r P n e t a e t n c s I i t , u v r r O e t e t a b S e t W D ( b m e r o D t S N M , h p e 2018201920202021202220232024202520262027202820292030203120322033203420352036 s o J . t $0 S f o y t$80,000$70,000$60,000$50,000$40,000$30,000$20,000$10,000 i C Cash Ending Balance Page15of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Less: Revenue SalesTax Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.CrossoverRefundingBonds,Series2009A(i)CrossoverrefundtheCity'sG.O.SewerRevenueBondsof2001.(ii)CrossoverrefundtheCity'sG.O.ImprovementBondsof2002(Thisportionmatured12/1/17).60203/01/09$455,000Dece mber1$170,000December1,2016December1,2021 1InvestmentincomewillaccruetotheSewerFund.2Pledgenetrevenuessufficienttopay105%ofdebtservice.3TheBondsarereportedasaliabilityoftheSewerFund. N M , h NOTES p e s o J Total170,00016,363186,363186,363195,6810195,681000000195,681 201840,0003.850%6,54546,54546,54548,872048,87200000048,8723,327201945,0003.850%5,00550,00550,00552,505052,50500000052,5055,828202045,0003.850%3,27348,27348,27350,686050,68600000050,6868,241202140,000 3.850%1,54041,54041,54043,617043,61700000043,61710,318 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y t Purpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: i C Cash Ending Balance Page16of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Less: Revenue SalesTax Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.CapitalImprovementPlanRefundingBonds,Series2009B CurrentRefundtheEDA'sPlublicProjectRevenueBondsof2003.(aquirethepublicworksfacilitywhichtheCitywasleasingfromtheEDA)34309/01/09$495,000December1$6 0,000Non-callableDecember1,2018 1Nooutstandingitemstonote. N M , NOTES h p e s Total60,0002,25062,25062,25065,363000000057,00057,000 o 201860,0003.750%2,25062,25062,25065,363000000057,00057,0005,383 J . t S f YearPrincipalDuePrincipalRatesInterestTotal o Purpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: y t i C Cash Ending Balance Page17of42 NetTaxLevyTotal Revenues Less:Other Less: InterestIncome Less:Sales TaxRevenue Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.WastewaterRevenueBonds,Series2009B FinancetheCity'sportionofthemetrointerceptorrepairproject,thelowerpan,LincolnAvenueandtheTri-Cityliftstation.SISPhasesI&II 60210/26/09$835,000August1$185,000Aug ust1,2017August1,2019 N 1TheBondsarereportedasaliabilityoftheSewerFund.2Pledgenetrevenuessufficienttopay105%ofdebtservice. M , h NOTES p e s o J Total185,00011,200196,200196,200206,0100206,010000000206,010 . 201890,0004.000%7,40097,40097,400102,2700102,270000000102,2704,870201995,0004.000%3,80098,80098,800103,7400103,740000000103,7409,810 t S f o y YearPrincipalDuePrincipalRatesInterestTotal t i Purpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C Cash Ending Balance Page18of42 NetTaxLevyTotal Revenues Less:Other Less: InterestIncome Tax Revenue Less:Sales Water Less:Storm Less: Water Less: SOURCESOFFUNDSFORDEBTSERVICESPAYMENTS Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTS G.O.WastewaterTreatmentBonds,Series2010 FinancetheCity'sportionoftheCityofSt.CloudRUEProjectPFALoan(11.29%).60208/01/10$4,527,703August20$3,206,699AnyDateAugust20,2030 1BondsarepayablefromnetrevenuesfromtheSanitarySewerFundandadditionallysecuredbyanunlimitedadvaloremtaxpledge.2TheBondsarereportedasaliabilityoftheSewerFund.3Pledgenetrevenuessufficiencttopay105%ofdeb tservice. N M , h NOTES p e s o J Total3,206,699411,4733,618,1713,618,1713,799,08003,799,0800000003,799,080 2018221,5101.771%56,791278,300278,300292,2150292,215000000292,21513,9152019225,4611.771%52,868278,329278,329292,2450292,245000000292,24527,8312020229,5261.771%48,875278,400278,400292,3200292,32000000 0292,32041,7512021233,4771.771%44,810278,287278,287292,2010292,201000000292,20155,6662022237,6551.771%40,675278,329278,329292,2460292,246000000292,24669,5822023241,9451.771%36,466278,411278,411292,33 10292,331000000292,33183,5032024246,0091.771%32,181278,190278,190292,1000292,100000000292,10097,4122025250,5251.771%27,824278,350278,350292,2670292,267000000292,267111,3302026254,9281.771%23,388278,3 16278,316292,2320292,232000000292,232125,2462027259,4441.771%18,873278,317278,317292,2330292,233000000292,233139,1622028264,0731.771%14,278278,351278,351292,2690292,269000000292,269153,0792029268,702 1.771%9,601278,303278,303292,2190292,219000000292,219166,9942030273,4441.771%4,843278,286278,286292,2010292,201000000292,201180,909 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y ExistingDebt-G.O.WastewaterTreatmentBonds,Series2010Purpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: t i C Cash Ending Balance Page19of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Less:Sales TaxRevenue Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.SewerRevenueBonds,Series2010A FinancetheCity'sportionofthemetrointerceptorrepairproject,includingtheupperandlowerpan,38thand54thavenues.SISphaseIII 60210/21/10$180,000August1$60,000August1,2018Au gust1,2020 N 1InvestmentincomewillaccruetotheSanitarySewerFund.2BondsarepayablefromnetrevenuesfromtheSanitarySewerFundandadditionallysecuredbyanunlimitedadvaloremtaxpledge.3TheBondsarereportedasaliabilityoftheSan itarySewerFund.4Pledgenetrevenuessufficiencttopay105%ofdebtservice. M , h NOTES p e s o J . Total60,0002,90062,90062,90066,045066,04500000066,045 201820,0002.000%1,40021,40021,40022,470022,47000000022,4701,070201920,0002.500%1,00021,00021,00022,050022,05000000022,0502,120202020,0002.500%50020,50020,50021,525021,52500000021,5253,145 t S f o y YearPrincipalDuePrincipalRatesInterestTotal t i ExistingDebt-G.O.SewerRevenueBonds,Series2010APurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C Cash Ending Balance Page20of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Less:Sales TaxRevenue Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.ImprovementBonds,Series2010B-RefundingPortion CrossoverrefundtheCity'sG.O.ImprovementBonds,Series2005B.(CloverdaleandHillStreetprojects)33309/01/10$1,035,000December1$405,000December1,2018Decembe r1,2020 1Debtservicescheduleisthe"Refunding"portionofthe2010BBondsonlyandsecuredbyspecialassessmentsandadvalorempropertytax.2Specialassessmentprincipaloutstandingasof12/31/2017:$227,564 N M , h NOTES p e s o J Total405,00018,968423,968423,968445,166189,55600002,1590125,000316,715 2018135,0002.100%9,248144,248144,248151,460123,1860000814035,000159,000123,3092019135,0002.300%6,413141,413141,413148,48333,1850000925040,00074,11056,0062020135,0002.450%3,308138,308138,308145,22333, 1850000420050,00083,6051,304 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y ExistingDebt-G.O.ImprovementBonds,Series2010B-RefundingPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: t i C Cash Ending Balance Page21of42 NetTaxLevyTotal Less: Other Revenues Less: InterestIncome Less: Revenue SalesTax Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.ImprovementBonds,Series2010B-NewMoneyPortion Financethe16thAvenueimprovementproject.34509/01/10$790,000December1$455,000December1,2018December1,2025 1Debtservicescheduleisthe"NewMoney"portionofthe2010BBondsonlyandsecuredbyspecialassessmentsandadvalorempropertytax.2Specialassessmentprincipaloutstandingasof12/31/2017:$111,537 N M , h NOTES p e s o J Total455,00062,968517,968517,968543,866133,73200106,00005,5790112,000357,311 201850,0002.100%12,65562,65562,65565,78819,2960013,25001,27406,00039,820146,997201955,0002.300%11,60566,60566,60569,93518,5590013,25001,10206,00038,911119,303202055,0002.450%10,34065,34065,34068,6071 7,8220013,2500895010,00041,96795,930202155,0002.900%8,99363,99363,99367,19217,0850013,2500719015,00046,05477,992202255,0002.900%7,39862,39862,39865,51716,3480013,2500585015,00045,18360,777202360,0002 .900%5,80365,80365,80369,09315,6110013,2500456020,00049,31744,292202460,0003.250%4,06364,06364,06367,26614,8740013,2500332020,00048,45628,685202565,0003.250%2,11367,11367,11370,46814,1370013,25002150 20,00047,6029,175 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y ExistingDebt-G.O.ImprovementBonds,Series2010B-NewMoneyPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: t i C Cash Ending Balance Page22of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Tax Revenue Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2011A-ImprovementRefundingPortion CrossoverRefundtheCity'sG.O.ImprovementBonds,Series2006C.Originalpurposeofthe2006CBondswasthefinancingoftheconstructionofoverlayprojectinteriorstreet .33811/01/11$1,040,000October1$540,000October1,2018October1,2021 1The"ImprovementRefundingPortion"ofthe2011ABondsonly,andsecuredbyspecialassessments,systemrevenuesintheamountof$18,000annuallyandadvalorempropertytax.2Specialassessmentprincipaloutstandingasof12/31/2 017:$156,832 N M , NOTES h p e s o Total540,00030,350570,350570,350598,868184,00024,00024,00024,00001,9590222,000479,959 2018130,0002.000%11,630141,630141,630148,71249,6006,0006,0006,0000751050,000118,35176,8992019135,0002.000%9,030144,030144,030151,23247,2006,0006,0006,0000577055,000120,77753,6462020135,0002.200%6,330 141,330141,330148,39744,8006,0006,0006,0000402055,000118,20230,5182021140,0002.400%3,360143,360143,360150,52842,4006,0006,0006,0000229062,000122,6299,787 J . t S f o YearPrincipalDuePrincipalRatesInterestTotal y ExistingDebt-G.O.Bonds,Series2011A-ImprovementRefundingPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: t i C Cash Ending Balance Page23of42 NetTaxLevyTotal Less: Other Revenues Less: InterestIncome Tax Revenue Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2011A-CIPPortion Financeroofandgaragerepairs.34711/01/11$195,000October1$80,000October1,2018October1,2021 1Debtservicescheduleisthe"CIPPortion"ofthe2011ABondsonlyandsecuredbyadvalorempropertytaxes. N M , h NOTES p e s o J Total80,0004,44084,44084,44088,66200000148081,00081,148 201820,0002.000%1,72021,72021,72022,8060000025023,00023,0254,625201920,0002.000%1,32021,32021,32022,3860000035023,00023,0356,340202020,0002.200%92020,92020,92021,9660000048020,00020,0485,467202120,00 02.400%48020,48020,48021,5040000041015,00015,04128 . t S f o y YearPrincipalDuePrincipalRatesInterestTotal t ExistingDebt-G.O.Bonds,Series2011A-CIPPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: i C Cash Ending Balance Page24of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Less: Revenue SalesTax Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2011A-EquipmentPortion Financethepurchaseofapumpertruckandtransportationvan.34611/01/11$195,000October1$165,000October1,2018October1,2021 1Debtservicescheduleisthe"EqupimentPortion"ofthe2011ABondsonlyandissecuredbyadvalorempropertytaxes.2OtherrevenuecomesfromapaymentfromtheTownshipforanallocatedshareofthecostofacquisitionofafiretruck. N M , NOTES h p e s Total165,0009,360174,360174,360183,078000008492,94486,790179,818 o 201840,0002.000%3,56043,56043,56045,73800000022,94420,79043,734202201940,0002.000%2,76042,76042,76044,89800000224,00022,00046,0023,444202040,0002.200%1,96041,96041,96044,058000002624,00022,00046,0267 ,510202145,0002.400%1,08046,08046,08048,384000005622,00022,00044,0565,486 J . t S f YearPrincipalDuePrincipalRatesInterestTotal o ExistingDebt-G.O.Bonds,Series2011A-EquipmentPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: y t i C Cash Ending Balance Page25of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Tax Revenue Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2011A-SystemPortion FinancethesewerforcemainimprovementsincludingtheSaukRiverCrossing.60211/01/11$195,000October1$100,000October1,2018October1,2021 N 1Pledgenetrevenuessufficiencttopay105%ofdebtservice. M , h NOTES p e s o J . Total100,0005,550105,550105,550110,8280110,0000005700110,057 201825,0002.000%2,15027,15027,15028,508027,50000060027,5061,202201925,0002.000%1,65026,65026,65027,983027,50000090027,5092,061202025,0002.200%1,15026,15026,15027,458027,500000150027,5153,427202125,00 02.400%60025,60025,60026,880027,500000260027,5265,353 t S f o y YearPrincipalDuePrincipalRatesInterestTotal t i ExistingDebt-G.O.Bonds,Series2011A-SystemPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C Cash Ending Balance Page26of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Tax Revenue Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.WaterRevenueCrossoverRefundingBonds,Series2012A CrossoverrefundedtheCity'sG.O.WaterRevenueBonds,Series2005D.PurposeoftheoriginalSeries2005DwasconstructionofWaterPlantNo.2andWells6,7,and8.60104/01 /12$4,860,000December1$4,295,000December1,2021December1,2028 1Pledgenetrevenuessufficiencttopay105%ofdebtservice. N M , NOTES h p e s Total4,295,000522,2784,817,2784,817,2785,058,141005,058,141000005,058,141 o 2018470,0002.000%97,808567,808567,808596,19800596,19800000596,198228,3902019475,0002.000%88,408563,408563,408591,57800591,57800000591,578256,5612020475,0002.000%78,908553,908553,908581,60300581,60300 000581,603284,2562021485,0002.000%69,408554,408554,408582,12800582,12800000582,128311,9772022495,0002.200%59,708554,708554,708582,44300582,44300000582,443339,7122023505,0002.400%48,818553,818553,8185 81,50800581,50800000581,508367,4032024525,0002.500%36,698561,698561,698589,78200589,78200000589,782395,4882025540,0002.650%23,573563,573563,573591,75100591,75100000591,751423,6662026100,0002.850%9,26 3109,263109,263114,72600114,72600000114,726429,1292027110,0002.850%6,413116,413116,413122,23300122,23300000122,233434,9502028115,0002.850%3,278118,278118,278124,19100124,19100000124,191440,864 J . t S f o YearPrincipalDuePrincipalRatesInterestTotal ExistingDebt-G.O.WaterRevenueCrossoverRefundingBonds,Series2012APurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: y t i C Cash Ending Balance Page27of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Less: Revenue SalesTax Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2013A-ImprovementPortion Finance2013streetoverlayproject.34809/01/13$405,000December1$310,000December1,2020December1,2024 1Debtservicescheduleisthe"ImprovementPortion"ofthe2013ABondsonlyandsecuredbyspecialassessmentsandadvalorempropertytax.2Specialassessmentprincipalbalanceoutstandingasof12/31/2017:$43,802 N M NOTES , h p e s Total310,00034,848344,848344,848362,09050,232000273273212,000267,759 201835,0002.000%7,77042,77042,77044,9099,1860000830010,00020,01687,951201940,0002.100%7,07047,07047,07049,4248,8600000660015,00024,52065,401202045,0002.100%6,23051,23051,23053,7928,53500001,319025,00 034,85449,025202145,0002.650%5,28550,28550,28552,7998,20900001,030035,00044,23942,979202245,0002.650%4,09349,09349,09351,5477,8840000742040,00048,62642,512202350,0002.800%2,90052,90052,90055,5457,558 0000534042,00050,09239,704202450,0003.000%1,50051,50051,50054,07500000412045,00045,41233,616 o J . t S f YearPrincipalDuePrincipalRatesInterestTotal o ExistingDebt-G.O.Bonds,Series2013A-ImprovementPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: y t i C Cash Ending Balance Page28of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Less: Revenue SalesTax Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2013A-SewerPortion FinanceCSAH75sewermainandliftstationcontrols.60209/01/13$1,875,000December1$1,430,000December1,2020December1,2028Debtservicescheduleisthe"SewerPortion"ofthe2013ABon dsonlyarepayablefromnetrevenuesplus5%fromtheSanitarySewerFundandsecuredbyanunlimitedadvaloremtaxpledge. N 12TheBondsarereportedasaliabilityoftheSanitarySewerFund. M , h p NOTES e s o J . Total1,430,000285,2431,715,2431,715,2431,801,00501,801,0050000001,801,005 t 2018115,0002.000%41,363156,363156,363164,1810164,181000000164,1818,3182019120,0002.100%39,063159,063159,063167,0160167,016000000167,01616,2712020120,0002.100%36,543156,543156,543164,3700164,370000000 164,37024,0982021120,0002.650%34,023154,023154,023161,7240161,724000000161,72431,8002022125,0002.650%30,843155,843155,843163,6350163,635000000163,63539,5922023130,0002.800%27,530157,530157,530165,407 0165,407000000165,40747,4682024130,0003.000%23,890153,890153,890161,5850161,585000000161,58555,1632025135,0003.300%19,990154,990154,990162,7400162,740000000162,74062,9122026140,0003.300%15,535155,535 155,535163,3120163,312000000163,31270,6892027145,0003.700%10,915155,915155,915163,7110163,711000000163,71178,4852028150,0003.700%5,550155,550155,550163,3280163,328000000163,32886,262 S f o y t YearPrincipalDuePrincipalRatesInterestTotal i ExistingDebt-G.O.Bonds,Series2013A-SewerPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C Cash Ending Balance Page29of42 NetTaxLevyTotal Less: Other Revenues Less: InterestIncome Less: Revenue SalesTax Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2013A-EquipmentPortion Financeacquisitionofafront-endloader,squadcar,AEDreplacement,surveilancecameras/recorders,computers,4x6Gatorandgrapple.34909/01/13$265,000December1$60,000Non-ca llableDecember1,2018 1Debtservicescheduleisthe"EquipmentPortion"ofthe2013ABondsonlyandsecuredbyadvalorempropertytax. N M , h NOTES p e s o J Total60,0001,20061,20061,20064,2600000053057,00057,053 201860,0002.000%1,20061,20061,20064,2600000053057,00057,0532,897 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y ExistingDebt-G.O.Bonds,Series2013A-EquipmentPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: t i C Cash Ending Balance Page30of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Tax Revenue Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.SewerRevenueBonds,Series2013B FinancetheCity'sportionoftheinterceptorrepairs(SISPhaseIV)fortheSt.CloudWastewaterTreatmentFacility.60211/01/13$650,000February1$550,000February1,2022February1,2029B ondsarepayablefromnetrevenuesfromtheSaniatarySewerFundandsecuredbyanunlimitedadvaloremtaxpledge. 12TheBondsarereportedasaliabilityoftheSanitarySewerFund. N M , NOTES h p e s o Total550,000124,500674,500674,500708,2250708,225000000708,225 J 201835,0004.000%9,97544,97544,97547,224047,22400000047,2242,249201940,0004.000%18,55058,55058,55061,478061,47800000061,4785,176202040,0004.000%16,95056,95056,95059,798059,79800000059,7988,024202140 ,0004.000%15,35055,35055,35058,118058,11800000058,11810,791202245,0004.000%13,75058,75058,75061,688061,68800000061,68813,729202345,0004.000%11,95056,95056,95059,798059,79800000059,79816,576202445,000 3.000%10,15055,15055,15057,908057,90800000057,90819,334202550,0003.000%8,80058,80058,80061,740061,74000000061,74022,274202650,0003.250%7,30057,30057,30060,165060,16500000060,16525,139202750,0003.375% 5,67555,67555,67558,459058,45900000058,45927,923202855,0003.500%3,98858,98858,98861,937061,93700000061,93730,872202955,0003.750%2,06357,06357,06359,916059,91600000059,91633,725 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y ExistingDebt-G.O.SewerRevenueBonds,Series2013BPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: t i C Cash Ending Balance Page31of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Tax Revenue Less:Sales Water Less:Storm Less: Water Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2014A-ImprovementPortion FinancetheParkTerraceStreetimprovementproject.35006/01/14$2,010,000December1$1,790,000December1,2021December1,2030 1Debtservicescheduleisthe"ImprovementPortion"ofthe2014ABondsonlyandsecuredbyspecialassessmentsandadvalorempropertytax.2Specialassessmentprincipaloutstandingasof12/31/2017:$140,9333Cashbalancewasaccum ultedfromprepaymentofspecialassessmentsanddepositofunspentprojectcontingencyintothedebtservicefund. N M , h NOTES p e s o J Total1,790,000397,9752,187,9752,187,9752,297,374212,4590008,60701,783,5002,004,566 2018115,0002.000%49,435164,435164,435172,65720,2370001,869080,000102,106186,8462019115,0002.000%47,135162,135162,135170,24219,5880001,401090,000110,989135,7002020120,0002.000%44,835164,835164,835173, 07718,9390001,0180105,000124,95795,8222021125,0002.000%42,435167,435167,435175,80718,2900007190125,000144,00972,3962022130,0002.500%39,935169,935169,935178,43217,6410005430135,000153,18455,6452023135 ,0003.000%36,685171,685171,685180,26916,9920004170140,000157,40941,3692024135,0003.000%32,635167,635167,635176,01716,3430003100152,000168,65342,3872025140,0003.000%28,585168,585168,585177,01415,69400 03180155,000171,01244,8142026145,0003.000%24,385169,385169,385177,85415,0450003360159,000174,38149,8102027150,0003.000%20,035170,035170,035178,53714,3960003740160,000174,77054,5452028155,0003.100%15, 535170,535170,535179,06213,7470004090160,000174,15658,1662029160,0003.200%10,730170,730170,730179,26713,0980004360160,000173,53460,9702030165,0003.400%5,610170,610170,610179,14112,4490004570162,50017 5,40665,766 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y t ExistingDebt-G.O.Bonds,Series2014A-ImprovementPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: i C Cash Ending Balance Page32of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Tax Revenue Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2014A-SystemPortion Financewatertowerrefurbishmentandsewermainliftstationcosts.60106/01/14$660,000December1$565,000December1,2021December1,2032Debtservicescheduleisthe"SystemPortion"o fthe2014ABondsonlyarepayablefromnetrevenuesplus5%fromtheSanitarySewerFundandWaterFundandsecuredbyanunlimitedadvaloremtaxpledge.chargessufficienttocover105%ofdebtservice. 12BondswereissuedunderMS444.Taxrevenueshouldbeusedonly,andthenonatemporarybasis,topaygeneralobligationswhentheotherrevenuesareinsufficient.Citymadeacovenanttomaintainratesand N M NOTES , h p e s Total565,000145,925710,925710,925746,471082,000331,4530000331,453744,906 201835,0002.000%16,01551,01551,01553,56607,00022,500000022,50052,00035,985201935,0002.000%15,31550,31550,31552,83107,00022,915000022,91552,83138,501202035,0002.000%14,61549,61549,61552,09606,00023,04 8000023,04852,09640,982202135,0002.000%13,91548,91548,91551,36106,00022,680000022,68051,36143,427202235,0002.500%13,21548,21548,21550,62606,00022,313000022,31350,62645,838202335,0003.000%12,34047,340 47,34049,70706,00021,854000021,85449,70748,205202435,0003.000%11,29046,29046,29048,60505,00021,802000021,80248,60550,520202535,0003.000%10,24045,24045,24047,50205,00021,251000021,25147,50252,78220263 5,0003.000%9,19044,19044,19046,40005,00020,700000020,70046,40054,991202740,0003.000%8,14048,14048,14050,54705,00022,774000022,77450,54757,398202840,0003.100%6,94046,94046,94049,28705,00022,144000022, 14449,28759,745202940,0003.200%5,70045,70045,70047,98505,00021,493000021,49347,98562,030203040,0003.400%4,42044,42044,42046,64105,00020,821000020,82146,64164,251203145,0003.400%3,06048,06048,06050,46 305,00022,732000022,73250,46366,654203245,0003.400%1,53046,53046,53048,85704,00022,428000022,42848,85768,981 o J . t S f YearPrincipalDuePrincipalRatesInterestTotal o ExistingDebt-G.O.Bonds,Series2014A-SystemPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: y t i C Cash Ending Balance Page33of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Less: Revenue SalesTax Water Less:Storm Less: Water Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2015A-ImprovementPortion FinancetheClintonVillage,NorthlandandJasmineLaneimprovementprojects.35108/01/15$595,000December1$485,000December1,2022December1,2025 1Debtservicescheduleisthe"ImprovementPortion"ofthe2015ABondsonlyandsecuredbyspecialassessmentsandadvalorempropertytax.2Specialassessmentprincipaloutstandingasof12/31/2017:$165,7663Cashbalancewasaccum ulatedfromprepaymentofspecialassessmentsanddepositofunspentprojectcontingencyintothedebtservicefund. N M , h NOTES p e s o J Total485,00056,100541,100541,100568,155204,8960004,1960195,000404,092 201860,0001.500%10,95070,95070,95074,49828,8100001,095015,00044,905119,952201960,0001.500%10,05070,05070,05073,55327,896000900015,00043,79693,698202060,0002.000%9,15069,15069,15072,60826,983000703020 ,00047,68672,233202160,0002.000%7,95067,95067,95071,34826,069000542020,00046,61150,894202260,0002.000%6,75066,75066,75070,08825,155000382025,00050,53734,681202360,0003.000%5,55065,55065,55068,82824,2 41000260030,00054,50123,632202460,0003.000%3,75063,75063,75066,93823,328000177035,00058,50518,387202565,0003.000%1,95066,95066,95070,29822,414000138035,00057,5528,989 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y t ExistingDebt-G.O.Bonds,Series2015A-ImprovementPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: i C Cash Ending Balance Page34of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Less: Revenue SalesTax Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2015A-EquipmentPortion Financetheacquisitionofaplowtruck,wingdeckmower,1tontruck,squadcar,equipment,portableradios,tasers,utilitytruck,squadcarvideoandcomputer.35212/12/17$165,000Dece mber1$105,000December1,2022December1,2020 1Debtservicescheduleisthe"EquipmentPortion"ofthe2015ABondsonlyandsecuredbyadvalorempropertytax. N M , NOTES h p e s Total105,0003,675108,675108,675114,10900000370108,000108,037 o 201835,0001.500%1,75036,75036,75038,5880000011037,00037,0111,789201935,0001.500%1,22536,22536,22538,0360000013036,00036,0131,578202035,0002.000%70035,70035,70037,4850000012035,00035,012890 J . t S f o YearPrincipalDuePrincipalRatesInterestTotal ExistingDebt-G.O.Bonds,Series2015A-EquipmentPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: y t i C Cash Ending Balance Page35of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Tax Revenues Less:Sales Water Less:Storm Less: Water Assessments Less:Special Levy 105%Tax P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.TaxAbatementBonds,Series2015B FinancetheacquisitionofColtsAcademytouseasaCommunityCenter.35308/01/15$1,870,000December1$1,635,000December1,2022December1,2030 N 1Citycertifiedanabatementlevyfordebtservice.Theannualabatementlevymaybecancelledanddebtpaidfromotherrevenue.TheCityplanstousesalestaxrevenuetopaydebtservice. M , h p NOTES e s o J . Total1,635,000331,5631,966,5631,966,5632,064,8910002,064,8910002,064,891 t 2018110,0002.000%42,135152,135152,135159,742000159,742000159,74227,8112019115,0002.000%39,935154,935154,935162,682000162,682000162,68235,5582020115,0002.000%37,635152,635152,635160,267000160,26700016 0,26743,1892021120,0002.000%35,335155,335155,335163,102000163,102000163,10250,9562022120,0002.000%32,935152,935152,935160,582000160,582000160,58258,6032023125,0002.500%30,535155,535155,535163,3120001 63,312000163,31266,3802024125,0002.500%27,410152,410152,410160,031000160,031000160,03174,0002025130,0003.000%24,285154,285154,285161,999000161,999000161,99981,7142026135,0003.000%20,385155,385155,385 163,154000163,154000163,15489,4842027135,0003.000%16,335151,335151,335158,902000158,902000158,90297,0502028135,0003.000%12,285147,285147,285154,649000154,649000154,649104,4152029135,0003.050%8,235143 ,235143,235150,397000150,397000150,397111,5762030135,0003.050%4,118139,118139,118146,073000146,073000146,073118,532 S f o y t YearPrincipalDuePrincipalRatesInterestTotal i ExistingDebt-G.O.TaxAbatementBonds,Series2015BPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C Cash 245,415259,046 Ending Balance Page36of42 283,448286,250 281,708284,409 NetTaxLevyTotal 00 Less: Other Revenues 1,7391,841 Less: Income Interest 00 Tax Revenues Less:Sales 00 Water Less:Storm 00 Less: Water 00 Less: Sewer Sanitary 00 Assessments Less:Special 283,448286,250 105% TaxLevy Subjectto P&I 269,950272,619 TaxLevy Subjectto 269,950272,619 7,619 14,950 2.875%2.875% DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS 255,000265,000 G.O.CapitalImprovementPlanBonds,Series2016A FinancetheGovernmentServiceCenter.30107/01/16$4,275,000December15$4,100,000December15,2023December15,2036Nooutstandingitemstonote. 1 N M NOTES , h p e s Total4,100,0001,058,5115,158,5115,158,5115,416,4370000017,69505,381,9715,399,666 2018180,0002.000%93,243273,243273,243286,905000001340270,000270,13414,7832019180,0002.000%89,643269,643269,643283,125000001110283,014283,12528,2652020185,0002.000%86,043271,043271,043284,595000002120 284,383284,59541,8172021190,0002.000%82,343272,343272,343285,960000003140285,646285,96055,4342022195,0002.000%78,543273,543273,543287,220000004160286,804287,22069,1112023195,0002.000%74,643269,643269 ,643283,125000005180282,606283,12582,5932024200,0002.000%70,743270,743270,743284,280000006190283,660284,28096,1302025205,0002.000%66,743271,743271,743285,330000007210284,609285,330109,7182026210,0002 .000%62,643272,643272,643286,275000008230285,452286,275123,3502027215,0002.000%58,443273,443273,443287,115000009250286,190287,115137,0222028215,0002.000%54,143269,143269,143282,600000001,0280281,5722 82,600150,4792029220,0002.250%49,843269,843269,843283,335000001,1290282,206283,335163,9712030225,0002.250%44,893269,893269,893283,387000001,2300282,157283,387177,4662031230,0002.450%39,830269,830269, 830283,322000001,3310281,991283,322190,9572032240,0002.450%34,195274,195274,195287,905000001,4320286,473287,905204,6672033245,0002.700%28,315273,315273,315286,981000001,5350285,446286,981218,33320342 50,0002.700%21,700271,700271,700285,285000001,6370283,648285,285231,91820352036 o J . t S f YearPrincipalDuePrincipalRatesInterestTotal o ExistingDebt-G.O.CapitalImprovementPlanBonds,Series2016APurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: y t i C Cash Ending Balance Page37of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Tax Revenues Less:Sales Water Less:Storm Less:Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.ImprovementBonds,Series2016B FinancetheFieldStreetimprovementprojectandCR121to7thAveSE 30411/01/16$740,000December15$740,000December15,2023December15,2032 N 1Specialassessmentprincipaloutstandingasof12/31/2017,includesdeferredspecialassessments:$632,5812Asignificantportionofthebalanceoutstandingisfordeferredspecialassessmentsthatmaynotbepayablewithinthen extthirtyyears. M , h NOTES p e s o J .Total740,000130,250870,250870,250913,763322,695000300,00013,3110135,000771,006 201850,0001.000%13,85063,85063,85067,04321,51300020,0001,42805,00047,941174,551201950,0001.000%13,35063,35063,35066,51821,51300020,0001,30905,00047,822159,024202050,0001.150%12,85062,85062,85065,9932 1,51300020,0001,19305,00047,706143,879202150,0001.150%12,27562,27562,27565,38921,51300020,0001,079010,00052,592134,196202250,0001.350%11,70061,70061,70064,78521,51300020,0001,006010,00052,519125,0162 02350,0001.350%11,02561,02561,02564,07621,51300020,000938010,00052,451116,441202450,0002.000%10,35060,35060,35063,36821,51300020,000873010,00052,386108,478202550,0002.000%9,35059,35059,35062,31821,51 300020,000814010,00052,327101,454202650,0002.000%8,35058,35058,35061,26821,51300020,000761010,00052,27495,378202750,0002.100%7,35057,35057,35060,21821,51300020,000715010,00052,22890,257202850,0002.10 0%6,30056,30056,30059,11521,51300020,000677010,00052,19086,147202950,0002.100%5,25055,25055,25058,01321,51300020,000646010,00052,15983,056203050,0003.000%4,20054,20054,20056,91021,51300020,000623010, 00052,13680,992203145,0003.000%2,70047,70047,70050,08521,51300020,000607010,00052,12085,412203245,0003.000%1,35046,35046,35048,66821,51300020,000641010,00052,15491,216 t S f o y YearPrincipalDuePrincipalRatesInterestTotal t i ExistingDebt-G.O.ImprovementBonds,Series2016BPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C Cash Ending Balance Page38of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Tax Revenues Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.CapitalImprovementPlanBonds,Series2017A AdditionalproceedsfortheGovernmentServiceCenter.30308/30/17$337,000December15$337,000AnydateJanuary15,2025 N M , h NOTES p e s o J Total337,00044,311381,311381,311400,3770000000330,000330,000 201843,0002.750%11,97154,97154,97157,72000000000035201942,0002.750%8,08550,08550,08552,589000000051,00051,000950202042,0002.750%6,93048,93048,93051,377000000049,00049,0001,020202142,0002.750%5,77547, 77547,77550,164000000048,00048,0001,245202242,0002.750%4,62046,62046,62048,951000000047,00047,0001,625202342,0002.750%3,46545,46545,46547,738000000046,00046,0002,160202442,0002.750%2,31044,31044,3104 6,526000000045,00045,0002,850202542,0002.750%1,15543,15543,15545,313000000044,00044,0003,695 . t S f o YearPrincipalDuePrincipalRatesInterestTotal y ExistingDebt-G.O.CapitalImprovementPlanBonds,Series2017APurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: t i C Cash Ending Balance Page39of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Tax Revenues Less:Sales Water Less:Storm Less: Water Less: Sewer SOURCESOFFUNDSFORDEBTSERVICESPAYMENTS Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto cbd DEBTSERVICEPAYMENTS G.O.Bonds,Series2017B-ImprovementPortion FinancetheCentralBusinessDistrict(CBD),PhaseI,alleyproject.30508/30/17$344,000December15$170,000December15,2022December15,2027 1Debtservicescheduleisthe"ImprovementPortion"ofthe2015ABondsonlyandsecuredbyspecialassessmentsandadvalorempropertytax.2$25,340inprepaidassessmentswerecollectedanddepositedintotheconstructionaccountat issuance.3Specialassessmentprincipaloutstandingasof12/31/2017:$89,2714Anticipate$20,000transferinfromcapitalprojectsfundin2018,asotherrevenuesource. N M , NOTES h p e s o Total344,00055,129399,129399,129419,085155,2340000020,000194,000369,234 201835,0002.250%11,64446,64446,64448,97618,5830000020,0009,00047,58345,901201935,0002.250%8,22843,22843,22845,38917,51500000015,00032,51535,188202035,0002.250%7,44042,44042,44044,56216,93200000020,00 036,93229,680202135,0002.250%6,65341,65341,65343,73516,34900000020,00036,34924,377202234,0002.250%5,86539,86539,86541,85815,76600000020,00035,76620,278202334,0003.000%5,10039,10039,10041,05515,183000 00025,00040,18321,361202434,0003.000%4,08038,08038,08039,98414,60100000025,00039,60122,882202534,0003.000%3,06037,06037,06038,91314,01800000020,00034,01819,840202634,0003.000%2,04036,04036,04037,8421 3,43500000020,00033,43517,235202734,0003.000%1,02035,02035,02036,77112,85200000020,00032,85215,067 J . t S f o YearPrincipalDuePrincipalRatesInterestTotal Purpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: y t i C Cash Ending Balance Page40of42 NetTaxLevyTotal Less: Other Revenues Less: Income Interest Tax Revenues Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto (Finalmaturitydateofthe2017B,ImprovementPortionis12/31/2027,calldateprovidesfortheoptionalredemptionforthisportion.) DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2017B-SystemPortion FinanceWaterTreatmentPlantNo.1improvements.60109/01/13$1,875,000December15$353,000December15,2022December15,2022Debtservicescheduleisthe"SystemPortion"ofthe2017BBo ndsonlyarepayablefromnetrevenuesplus5%fromtheWaterTreatmentFundandsecuredbyanunlimitedadvaloremtaxpledge. N 12TheBondsarereportedasaliabilityoftheWaterTreatmentFund. M , h NOTES p e s o J . Total353,00026,077379,077379,077398,03000398,03000000398,030 201871,0002.250%10,25981,25981,25985,3220085,3220000085,32239,063201971,0002.250%6,34577,34577,34581,2120081,2120000081,21242,930202071,0002.250%4,74875,74875,74879,5350079,5350000079,53546,718202170 ,0002.250%3,15073,15073,15076,8080076,8080000076,80850,375202270,0002.250%1,57571,57571,57575,1540075,1540000075,15453,954 t S f o y YearPrincipalDuePrincipalRatesInterestTotal t i ExistingDebt-G.O.Bonds,Series2017B-SystemPortionPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C 87,50992,50397,495 Cash Ending Balance Page41of42 104,879104,863104,836 000 NetTaxLevyTotal 000 Revenues Less:Other 000 Less: Income Interest 000 Tax Revenues Less:Sales 000 Water Less:Storm 000 Less: Water 104,879104,863104,836 Less: Sewer SOURCESOFFUNDSFORDEBTSERVICESPAYMENTS Sanitary 000 Assessments Less:Special 104,879104,863104,836 105% TaxLevy Subjectto 99,88499,87099,844 P&I TaxLevy Subjectto 99,88499,87099,844 3,2102,1511,081 1.095%1.095%1.095% DEBTSERVICEPAYMENTS 96,67497,71898,762 CityportionofSt.CloudPublic2017FacilitiesAuthority(PFA)Loan St.CloudWastewaterPFANoteforabiosolidstreatmentupdate(CityreferstotheprojectasNR2-newtreatmentmethod)30610/09/17$1,744,736December1$1,744,7 36CallableatanytimeAugust20,2037 N 1TheCityofSt.Josephisresponsiblefor10.44%oftheprojectcosts. M , h NOTES p e s o J . Total1,744,736205,1631,949,8991,949,8992,047,39302,047,3930000002,047,393 201840,1970.000%12,41852,61552,61555,246055,24600000055,2462,631201981,2231.095%18,66599,88899,888104,8820104,882000000104,8827,625202082,0581.095%17,77599,83499,834104,8250104,825000000104,82512,617 202182,9981.095%16,87799,87599,875104,8690104,869000000104,86917,611202283,9381.095%15,96899,90699,906104,9010104,901000000104,90122,606202384,7731.095%15,04999,82299,822104,8130104,813000000104,8132 7,597202485,7121.095%14,12199,83399,833104,8250104,825000000104,82532,589202586,6521.095%13,18299,83499,834104,8260104,826000000104,82637,580202687,5921.095%12,23399,82599,825104,8160104,816000000104 ,81642,572202788,5311.095%11,27499,80599,805104,7960104,796000000104,79647,562202889,5751.095%10,30599,88099,880104,8740104,874000000104,87452,556202990,5151.095%9,32499,83999,839104,8310104,83100000 0104,83157,548203091,5591.095%8,33399,89199,891104,8860104,886000000104,88662,542203192,4981.095%7,33099,82899,828104,8200104,820000000104,82067,534203293,5421.095%6,31799,86099,860104,8530104,853000 000104,85372,527203394,5861.095%5,29399,87999,879104,8730104,873000000104,87377,521203495,6301.095%4,25799,88899,888104,8820104,882000000104,88282,515203520362037 t S f o y YearPrincipalDuePrincipalRatesInterestTotal t i ExistingDebt-CityportionofSt.CloudPublic2017FacilitiesAuthority(PFA)LoanPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C Cash Ending Balance Page42of42 NetTaxLevyTotal Revenues Less:Other Less: Income Interest Tax Revenues Less:Sales Water Less:Storm Less: Water Less: Sewer Sanitary Assessments Less:Special 105% TaxLevy Subjectto P&I TaxLevy Subjectto DEBTSERVICEPAYMENTSSOURCESOFFUNDSFORDEBTSERVICESPAYMENTS G.O.Bonds,Series2018A-EquipmentCertificates Financeequipmentacquisition.30602/28/18$265,000December15$265,000Non-callableDecember15,2023 N 1Sourceofotherrevenueincludes$5,282ofcapitalizedinterestfundsfrombondproceeds. M , h NOTES p e s o J . Total265,00025,507290,507290,507305,03200000505,700286,500292,250 201800.000%5,2825,2825,2825,5460000005,70005,700418201950,0002.500%6,62556,62556,62559,456000003057,00057,003797202052,0002.500%5,37557,37557,37560,244000006058,00058,0061,428202153,0002.500%4,07557, 07557,07559,9290000011057,50057,5111,863202254,0002.500%2,75056,75056,75059,5880000014057,00057,0142,127202356,0002.500%1,40057,40057,40060,2700000016057,00057,0161,743 t S f o y YearPrincipalDuePrincipalRatesInterestTotal t i ExistingDebt-G.O.Bonds,Series2018A-EquipmentCertificatesPurpose:CityFund:Dated:OriginalAmount:Mature:Outstanding:Call:FinalMaturity: C