|
4, City of Little Canada, Minnesota
<br />Cash Flow Analysis /Debt Service Schedule
<br />(2007 Street Reconstruction and Utility Improvements /Rice & R)
<br />Full Competitive Sale /10 Year Level /Underlying Moody's1A2"
<br />Optional Insurance paid by Purchaser to Moody's "Aaa"
<br />Sale Details
<br />Sale
<br />Closing
<br />Dated
<br />1st Interest
<br />Interest
<br />Option
<br />Registrar
<br />Authority
<br />Type
<br />Completion
<br />28 -Feb
<br />1 -Mar
<br />1 -Mar
<br />1- Aug -07
<br />Feb /Aug
<br />01- Feb -12
<br />TBD
<br />475/429
<br />Full Competitive
<br />TBD
<br />Average Coupon
<br />True Interest Cost (TIC)
<br />Tax
<br />Levy
<br />Year
<br />4.13%
<br />4.34%
<br />Tax Bond
<br />Collect Payment
<br />Year Date
<br />General Obligation (PIR) Fund Bonds, Series 2007
<br />Par Amount of Bonds
<br />Estimated Land Sales
<br />Ramsey County
<br />MnDOT Grant
<br />Estimated State Aid Funds (2007)
<br />Total Sources
<br />Total Underwriters Discount (1.200 %)
<br />Costs of Issuance
<br />Deposit to Capitalized Interest (CIF) Fund
<br />Deposit to Project Construction Fund
<br />Rounding Amount
<br />Total Uses
<br />Bond Bond Bond
<br />Principal Rate Interest
<br />2007
<br />2007
<br />2008
<br />2008
<br />2009
<br />2009
<br />2010
<br />2010
<br />2011
<br />2011
<br />2012
<br />2012
<br />2013
<br />2013
<br />2014
<br />2014
<br />2015
<br />2015
<br />2016
<br />2016
<br />2008
<br />2008
<br />2009
<br />2009
<br />2010
<br />2010
<br />2011
<br />2011
<br />2012
<br />2012
<br />2013
<br />2013
<br />2014
<br />2014
<br />2015
<br />2015
<br />2016
<br />2016
<br />2017
<br />2017
<br />3/1/2007
<br />8/1/2007
<br />2/1/2008
<br />8/1/2008
<br />2/1/2009
<br />8/1/2009
<br />2/1/2010
<br />8/1/2010
<br />2/1/2011
<br />8/1/2011
<br />2/1/2012
<br />8/1/2012
<br />2/1/2013
<br />8/1/2013
<br />2/1/2014
<br />8/1/2014
<br />2/1/2015
<br />8/1/2015
<br />2/1/2016
<br />8/1/2016
<br />2/1/2017
<br />8/1/2017
<br />2/1/2018
<br />70,000
<br />225,000
<br />235,000
<br />245,000
<br />250,000
<br />265,000
<br />275,000
<br />285,000
<br />295,000
<br />310,000
<br />315,000
<br />3.90%
<br />3.95%
<br />4.00%
<br />4.00%
<br />4.00%
<br />4.05%
<br />4.10%
<br />4.10%
<br />4.15%
<br />4.20%
<br />4.25%
<br />47,150
<br />56,580
<br />55,215
<br />55,215
<br />50,771
<br />50,771
<br />46,071
<br />46,071
<br />41,171
<br />41,171
<br />36.171
<br />36,171
<br />30,805
<br />30.805
<br />25,168
<br />25,168
<br />19,325
<br />19,325
<br />13,204
<br />13,204
<br />6,694
<br />6,694
<br />Bond
<br />Funded
<br />Interest
<br />(47,150)
<br />2,770,000
<br />345,000
<br />350,000
<br />400,000
<br />60,000
<br />3,925,000
<br />Option 2
<br />EHLERS
<br />Todd Hagen /Mark Ruff
<br />Public Finance Advisors
<br />651- 697 - 8508/8505
<br />1- 800,552 -1171
<br />Remaining Special Assessments
<br />Amount
<br />Rate
<br />Term
<br />Start Year (Levy /Collect)
<br />Assessed Bond Issue
<br />Assessed Project Costs
<br />Calculation Method
<br />33,240
<br />30,800 2007 Prepays
<br />47,150
<br />3,811,000
<br />2,810
<br />3,925,000
<br />Total Total
<br />P & I +5.00%
<br />Assmt Assmt
<br />Principal Interest
<br />492,330
<br />6.50% 2
<br />10
<br />2007/2008
<br />22%
<br />21%
<br />Equal PM
<br />125,000
<br />Less:
<br />Assmt Period MSA /Other Tax
<br />Revenue 3 Change Funds 4 Levy a
<br />126,580
<br />55,215
<br />280,215
<br />50,771
<br />285,771
<br />46,071
<br />291.071
<br />41,171
<br />291,171
<br />36,171
<br />301,171
<br />30,805
<br />305,805
<br />25,168
<br />310,168
<br />19,325
<br />314,325
<br />13,204
<br />323,204
<br />6,694
<br />321,694
<br />132,909
<br />57,976
<br />294,226
<br />53.310
<br />300,060
<br />48,375
<br />305,625
<br />43,230
<br />305.730
<br />37,980
<br />316,230
<br />32,345
<br />321,095
<br />26,426
<br />325,676
<br />20,291
<br />330,041
<br />13,864
<br />339,364
<br />7,028
<br />337,778
<br />(125,000)
<br />(18,242)
<br />(18,242)
<br />(19,428)
<br />(19,428)
<br />(20,691)
<br />(20,691)
<br />(22,035)
<br />(22,035)
<br />(23,468)
<br />(23,468)
<br />(24,993)
<br />(24,993)
<br />(26,618)
<br />(26,618)
<br />(28,348)
<br />(28,348)
<br />(30,190)
<br />(30,190)
<br />(32,153)
<br />(32,153)
<br />7.909)
<br />6,001)
<br />6,001)
<br />4.815)
<br />4,815)
<br />3,552)
<br />3.552)
<br />2,207)
<br />2.207)
<br />0,775)
<br />0,775)
<br />9,250)
<br />9,250)
<br />7,625)
<br />7,625)
<br />5,895)
<br />5,895)
<br />4,052)
<br />4,052)
<br />2,090)
<br />2,090)
<br />(132,909)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34.243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />(34,243)
<br />23,733
<br />259,983
<br />19,067
<br />265,817
<br />14,132
<br />271,382
<br />8,987
<br />271,487
<br />3,737
<br />281,987
<br />(1,897)
<br />286,853
<br />(7,817)
<br />291,433
<br />(13,951)
<br />295,799
<br />(20,379)
<br />305,121
<br />(27,214)
<br />303,536
<br />283,716
<br />284,884
<br />285,514
<br />280,474
<br />285,724
<br />284,955
<br />283,616
<br />281,847
<br />284,742
<br />276,321
<br />,770,000 752,920 (47,150) 3.475,770 3,649.559 617,330) (2 0,433) (817.763)
<br />Includes engineering, administration, and contingency.
<br />2 Provided by the City. Typically based on 2% over the average bond rate.
<br />3 It is essential that the City conduct the assessment hearing and certify the assessments to the County by November 30, 2007 for initial collection in 2008.
<br />If the final assessment hearing has not been held by the end of 2007 and the amount of the assessment for the project changes, the City will need to adjust the levy certified to the County,
<br />4 Used to offset tax levy.
<br />The initial tax levy must be made by September 15, 2007 for taxes payable in 2008.
<br />If significant prepayments of assessments are received before the first call date, the tax levy may need to be increased.
<br />Prepared by Ehlers & Associates, Inc. Preliminary: For Cis - 5 - purposes ONLY 2/9/2007
<br />
|