|
440 City of Little Canada, Minnesota
<br />Cash Flow Analysis /Debt Service Schedule
<br />(2007 Street Reconstruction and Utility Improvements)
<br />Full Competitive Sale /10 Year Level /Underlying Moody's "A2"
<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 4.13%
<br />True Interest Cost (TIC) 4.34%
<br />Tax
<br />Levy
<br />Year
<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
<br />Principal
<br />Bond
<br />Bond Bond Funded
<br />Rate Interest Interest
<br />2,205,000
<br />345,000
<br />350,000
<br />400,000
<br />60,000
<br />3,360,000
<br />26,460
<br />30,800
<br />37,513
<br />3,261.0001
<br />4,228
<br />3,360,000
<br />Total Total
<br />P & I +5.00%
<br />Option 1
<br />EHLErRS
<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 />2007 Prepays
<br />Assmt Assmt
<br />Principal Interest
<br />492,330
<br />6.50% r
<br />10
<br />2007/2008
<br />28%
<br />25%
<br />Equal P&I
<br />125,000
<br />Less:
<br />Assmt Period MSA Tax
<br />Revenue a Change Funds 4 Levy
<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 />80,000
<br />180.000
<br />185,000
<br />190,000
<br />200,000
<br />205,000
<br />215,000
<br />225,000
<br />235,000
<br />240,000
<br />250,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 />37,513
<br />45,015
<br />43,455
<br />43,455
<br />39,900
<br />39,900
<br />36,200
<br />36,200
<br />32,400
<br />32,400
<br />28,400
<br />28,400
<br />24,249
<br />24,249
<br />19,841
<br />19,841
<br />15,229
<br />15,229
<br />10,353
<br />10,353
<br />5,313
<br />5,313
<br />(37,513)
<br />125,015
<br />43,455
<br />223.455
<br />39,900
<br />224,900
<br />36,200
<br />226,200
<br />32,400
<br />232,400
<br />28,400
<br />233,400
<br />24,249
<br />239,249
<br />19.841
<br />244,841
<br />15,229
<br />250,229
<br />10,353
<br />250,353
<br />5,313
<br />255.313
<br />131,266
<br />45,628
<br />234,628
<br />41,895
<br />236,145
<br />38.010
<br />237,510
<br />34,020
<br />244,020
<br />29,820
<br />245,070
<br />25,461
<br />251,211
<br />20,833
<br />257.083
<br />15,990
<br />262,740
<br />10,870
<br />262,870
<br />5,578
<br />268,078
<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 />(6.266)
<br />(16,001)
<br />(16,001)
<br />(14,815)
<br />(14,815)
<br />(13,552)
<br />(13,552)
<br />(12,207)
<br />(12,207)
<br />(10,775)
<br />(10,775)
<br />(9,250)
<br />(9,250)
<br />(7,625)
<br />(7,825)
<br />(5,895)
<br />(5,895)
<br />(4,052)
<br />(4,052)
<br />(2,090)
<br />(2,090)
<br />(131,266)
<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 />11,385
<br />200,385
<br />7,652
<br />201,902
<br />3,767
<br />203,267
<br />(223)
<br />209,777
<br />(4,423)
<br />210,827
<br />(8,782)
<br />216,968
<br />(13,409)
<br />222,841
<br />(18,253)
<br />228,497
<br />(23,373)
<br />228,627
<br />(28,665)
<br />233,835
<br />211,770
<br />209,555
<br />207,035
<br />209,555
<br />206,405
<br />208,187
<br />209,431
<br />210,245
<br />205,255
<br />205,171
<br />2.205,000 593,205 37,513 2,760,693 2,898,727
<br />617,330 198,790 816,
<br />Includes engineering, administration, and contingency.
<br />r Provided by the City. Typically based on 2% over the average bond rate.
<br />° 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 8 Associates, Inc. Preliminary: Far Dis..__4 ...'urposes ONLY 2/9/2007
<br />
|