Res 2012- 72 Sale of Bonds 2012A
de minimis
EXHIBIT A
BID TABULATION
$2,655,000* General Obligation Improvement Bonds, Series 2012A
CITY OF MENDOTA HEIGHTS, MINNESOTA
SALE:
August 21, 2012
AWARD:
BAIRD
RATING:BBI:
Moody’s Investors Service, Inc. "Aa1" 3.80%
NETTRUE
NAME OF BIDDERMATURITYRATEREOFFERINGPRICEINTERESTINTEREST
(February 1)YIELDCOSTRATE
BAIRD
20152.000%0.500%$2,654,802.25$754,656.762.3151%
Milwaukee, Wisconsin
20162.000%0.600%
C.L. King & Associates WMBE
20172.000%0.800%
Coastal Securities, Inc.
20182.000%1.100%
SAMCO Capital Markets
20192.000%1.400%
Loop Capital Markets20202.000%1.600%
Edward D. Jones & Co. 20212.000%
1.800%
Cronin & Co., Inc.2022**2.000%
1.900%
Kildare Capital2023**2.000%
1.900%
Crews & Associates, Inc. 2024***2.000%
2.050%
Davenport & Co. L.L.C.2025***2.000%
2.050%
Wedbush Securities Inc.2026****
2.200%2.200%
Dougherty & Company, LLC2027****
2.200%2.200%
Isaak Bond Investments, Inc2028*****
2.500%2.500%
Country Club Bank2029*****
2.500%2.500%
Advisors Asset Management2030*****
2.500%2.500%
Ross, Sinclaire & Associates, LLC
2031******2.700%2.720%
CastleOak Securities, L.P.
2032******2.700%2.720%
Vining-Sparks IBG, Limited Partnership
Northland Securities, Inc.
*Subsequent to bid opening the issue size was decreased to $2,630,000.
Adjusted Price - $2,629,802.39Adjusted Net Interest Cost - $747,986.20Adjusted TIC - 2.3157%
**$385,000 Term Bond due 2023 with mandatory redemption in 2022 (Adjusted amount of $380,000)
***$335,000 Term Bond due 2025 with mandatory redemption in 2024 (Adjusted amount of $330,000)
****$350,000 Term Bond due 2027 with mandatory redemption in 2026 (Adjusted amount of $345,000)
*****$545,000 Term Bond due 2030 with mandatory redemption in 2028-2029
******$390,000 Term Bond due 2032 with mandatory redemption in 2031 (Adjusted amount of $385,000)
A-1
$2,655,000 General Obligation Improvement Bonds, Series 2012APage 2
City of Mendota Heights, Minnesota
NETTRUE
NAME OF BIDDERMATURITYRATEREOFFERINGPRICEINTERESTINTEREST
(February 1)YIELDCOSTRATE
BOSC, INC., A SUBSIDIARY OF BOK20152.000%$2,677,592.95$850,728.262.5945%
FINANCIAL CORPORATION20162.000%
Menomonee Falls, Wisconsin2017
2.000%
20182.000%
20192.000%
20202.250%
2021
2.250%
20222.375%
20232.500%
20242.500%
2025
2.625%
20262.625%
20272.750%
2028
2.750%
20292.875%
20302.875%
20313.000%
2032
3.000%
A-2
Tax Levy Calculation For:
City of Mendota Heights, Minnesota
$2,630,000 General Obligation Improvement Bonds, Series 2012A
Dated Date: 9/12/2012
Less:(2)(3)(4)
LevyCollectPayTotalFundsP & I Less:Less:Less:Net
YearYearYearP & IAvailable (1)x 105%Spec AssmtsSpec AssmtsSpec AssmtsLevy
2012/2013/201481,378.58 (15,000.00) 69,697.51 (10,433.92) (26,683.73) (36,122.09) -
2013/2014/2015153,710.00 161,395.50 (10,053.12) (25,974.02) (34,803.77) 90,564.59
2014/2015/2016151,810.00 159,400.50 (9,661.44) (25,224.77) (33,447.77) 91,066.52
2015/2016/2017149,910.00 157,405.50 (9,269.76) (24,475.52) (32,091.78) 91,568.44
2016/2017/2018143,010.00 150,160.50 (8,878.08) (23,726.27) (30,735.78) 86,820.37
2017/2018/2019141,210.00 148,270.50 (8,486.40) (22,977.02) (29,379.79) 87,427.29
2018/2019/2020139,410.00 146,380.50 (8,094.72) (22,227.77) (28,023.80) 88,034.21
2019/2020/2021137,610.00 144,490.50 (7,703.04) (21,478.51) (26,667.81) 88,641.14
2020/2021/2022230,810.00 242,350.50 (7,311.36) (20,729.26) (25,311.82) 188,998.06
2021/2022/2023237,110.00 248,965.50 (6,919.68) (19,980.01) (23,955.83) 198,109.98
2022/2023/2024203,210.00 213,370.50 (19,230.76) 194,139.74
2023/2024/2025199,910.00 209,905.50 (18,481.51) 191,423.99
2024/2025/2026201,610.00 211,690.50 (17,732.26) 193,958.24
2025/2026/2027202,870.00 213,013.50 (16,983.01) 196,030.49
2026/2027/2028204,020.00 214,221.00 (16,233.76) 197,987.24
2027/2028/2029199,520.00209,496.00209,496.00
2028/2029/2030200,020.00210,021.00210,021.00
2029/2030/2031200,395.00210,414.75210,414.75
2030/2031/2032200,265.00210,278.25210,278.25
Totals3,377,788.58(15,000.00)3,530,928.01(86,811.52)(264,695.68)(300,540.24)2,882,422.80
(1)Capitalized interest in the amount of $15,000.00 will be available to pay a portion of the interest payments due 8/1/2013 and 2/1/2014.
(2)Projected special assessment revenue based on $65,280 assessed at 6.00%.
(3)Projected special assessment revenue based on $237,263 assessed at 6.00%.
(4)Projected special assessment revenue based on $225,998 assessed at 6.00%.