HomeMy WebLinkAboutA015 - Bids No 1 - 11 PARITY Bid Form Page I of 2
s
Upcoming Calendar Overview I Result I Excel
Robert W. Baird & Co., Inc. - Red Bank , NJ's Bid
Ames
$11,555,000 General Obligation Corporate Purpose Bonds, Series
2019A
For the aggregate principal amount of$11,555,000.00, we will pay you$12,617,066.85, plus accrued interest
from the date of issue to the date of delivery. The Bonds are to bear interest at the following rate(s):
Maturity Date Amount $Coupon %Yield % Dollar Price
06/01/2020 965M 5.0000 1.1000 102.785
06/01/2021 920M 5.0000 1.0500 106.711
06/01/2022 935M 5.0000 1.0600 110,532
06/01/2023 955M 1.5000 1.0700 101.563
06/01/2024 970M 5.0000 1.1000 117.886
06/01/2025 995M 5.0000 1.1500 121.250
06/01/2026 1,010M 5.0000 1.2000 124.459
06/01/2027 920M 5.0000 1.2500 127.511
06/01/2028 940M 2.0000 1.5000 103.630
06/01/2029 960M 2.0000 1.7000 102.160
06/01/2030
26/01/2031 1,985M 2.0000 2.0000 100.000
Total Interest Cost: $2,298,285.35
Premium: $1,062,066.85
Net Interest Cost: $1.236,218.50
TIC: 1.625930
Time Last Bid Received On:08/27/2019 10:53:39 CDST
This proposal is made subject to all of the terms and conditions of the Official Bid Form, the Official Notice of
Sale, and the Preliminary Official Statement, all of which are made a part hereof.
Bidder: Robert W. Baird&Co., Inc., Red Bank , NJ
Contact: chades massaro
Title: director
Telephone:732-576-4410
Fax: 732-576-4420
Issuer Name: City of Ames Company Name:
Accepted By: Accepted By:
Date: Date:
https://www.newissuehome.i-deal.com/Parity/asp/main.asp?frame=content&page=parityBi... 8/27/2019
PARITY Reoffering Page 1 of 1
Result
Robert W. Baird & Co., Inc.'s Reoffering Scale
Ames
$11,555,000 General Obligation Corporate Purpose Bonds, Series
2019A
Maturity Date Amount$Coupon %Yield % Dollar Price Call Date
06/01/2020 965M 5.0000 1.1000 102.785
06/01/2021 920M 5.0000 1.0500 106.711
06/01/2022 935M 5.0000 1.0600 110.532
06/01/2023 955M 1.5000 1.0700 101.563
06/01/2024 970M 5.0000 1.1000 117.886
06/01/2025 995M 5.0000 1.1500 121.250
06/01/2026 1,010M 5.0000 1.20001 124.459
06/01/2027 920M 5.0000 1,2500 127.511
06/01/2028 940M 2.0000 1.5000 103.630 06/01/2027
06/01/2029 960M 2.0000 1.7000 102.160 06/01/2027
06/01/2030
O6/01/2031 1,985M 2.0000 2.0000 100.000
Accrued Interest: $0.00
Gross Production: $12,696,944.10
019a1-2002 i-Deal LLC,All ngnls reserved, Trademarks
https://www.newissuehome.i-deal.com/Parity/asp/main.asp?frame=content&page=parityR... 8/27/2019
PARITY Bid Form Page I of 2
Upcoming Calendar I Overview I Result Excel
Janney Montgomery Scott LLC - Philadelphia , PA's Bid �%Rff'FW
Ames
$11,555,000 General Obligation Corporate Purpose Bonds, Series
2019A
For the aggregate principal amount of$11,555,000.00, we will pay you $13,119,100.00, plus accrued interest
from the date of issue to the date of delivery. The Bonds are to bear interest at the following rate(s):
Maturity Date Amount$Coupon %Yield % Dollar Price
06/01/2020 965M 5.0000 1.0500 102.822
06/01/2021 920M 5.0000 1.0500 106.711
06/01/2022 935M 5.0000 1.0600 110.532
06/01/2023 955M 1.5000 1.0700 101.563
06/01/2024 970M 5.0000 1.0900 117.937
06/01/2025 995M 5.0000 1.1000 121.559
06/01/2026 1,010M 5.0000 1.1600 124.751
06/01/2027 920M 5.0000 1.2000 127.934
06/01/2028 940M 5.0000 1.2800 127.258
06/01/2029 960M 3.0000 1.6200 109.974
06/01/2030 980M 3.0000 1.7900 108.686
06/01/2031 1,005M 3.0000 2.0000 107.118
Total Interest Cost: $2,860,311.32
Premium: $1,564,100.00
Net Interest Cost: $1,296,211.32
TIC: 1.646538
Time Last Bid Received On:08/27/2019 10:58:18 CDST
This proposal is made subject to all of the terms and conditions of the Official Bid Form, the Official Notice of
Sale, and the Preliminary Official Statement, all of which are made a part hereof.
Bidder: Janney Montgomery Scott LLC, Philadelphia , PA
Contact: Matthew Davis
Title:
Telephone:215-665-6521
Fax: 215-557-8648
Issuer Name: City of Ames Company Name:
Accepted By: Accepted By:
Date: Date:
https://www.newissuehome.i-deal.com/Parity/asp/main.asp?frame=content&page=parityBi... 8/27/2019
PARITY Bid Form Page I of 2
Upcoming Calendar I Overview I Result I Excel
UMB Bank, N.A. - Dallas , TX's Bid :;i■! � •
Ames
$11,555,000 General Obligation Corporate Purpose Bonds, Series
2019A
For the aggregate principal amount of$11,555,000.00,we will pay you$13,235,326.10, plus accrued interest
from the date of issue to the date of delivery.The Bonds are to bear interest at the following rate(s):
Maturity Date Amount$Coupon %Yield % Dollar Price
06/01/2020 965M 5.0000 1.0800 102.800
06/01/2021 920M 5.0000 1.1000 106,623
06/01/2022 935M 5.0000 1.1200 110.362
06/01/2023 955M 5.0000 1.1300 114.055
06/01/2024 970M 5.0000 1.1500 117.634
06/01/2025 995M 5.0000 1.1700 121.127
06/01/2026 1,010M 5.0000 1.2200 124.313
06/01/2027 920M 5.0000 1.2600 127.426
06/01/2028 940M 5.0000 1.3200 126.921
06/01/2029 960M 3.0000 1.5200 110.740
06/01/2030 980M 3,0000 1.6900 109.441
06/01/2031 1,005M 3.0000 1.8500 108.235
Total Interest Cost: $2,984,633.75
Premium: $1,680,326.10
Net Interest Cost: $1,304,307.65
TIC: 1.651750
Time Last Bid Received On:08127/2019 10:56:03 COST
This proposal is made subject to all of the terms and conditions of the Official Bid Form, the Official Notice of
Sale, and the Preliminary Official Statement, all of which are made a part hereof.
Bidder: UMB Bank, N.A., Dallas , TX
Contact: Steve Madden
Title: Underwriter
Telephone:214-389-5937
Fax:
Issuer Name: City of Ames Company Name:
Accepted By: Accepted By:
Date: Date
https://www.newissuehome.i-deal.com/Parity/asp/main.asp?frame=content&page=parityBi... 8/27/2019
PARITY Bid Form Page I of 2
upcoming Calendar I Overview I Result I Excel
J.P. Morgan Securities LLC - New York , NY's Bid :4:i'Mat R Y
Ames
$11,555,000 General Obligation Corporate Purpose Bonds, Series
2019A
For the aggregate principal amount of$11,555,000.00,we will pay you$13,422,132.85, plus accrued interest
from the date of issue to the date of delivery.The Bonds are to bear interest at the following rate(s):
Maturity Date Amount$Coupon %Yield % Dollar Price
06/01/2020 965M 5.0000 1.0500 102.822
06/01/2021 920M 5,0000 1,0600 106.694
06/01/2022 935M 5.0000 1.0800 110,475
06/01/2023 955M 5.0000 1.0900 114.212
06/01/2024 970M 5.0000 1.1200 117.785
06/01/2025 995M 5.0000 1.1600 121.188
06/01/2026 1.010M 5.0000 1.2200 124.313
06/01/2027 920M 5.0000 1.2800 127.258
06/01/2028 940M 4.0000 1.4100 118.879
06/01/2029 960M 4.0000 1.5200 117.997
06/01/2030 980M 4.0000 1.6400 117.044
06/01/2031 1,005M 4.0000 1.7500 116.178
Total Interest Cost: $3,218,808.61
Premium: $1,867,132.85
Net Interest Cost: $1,351,675.76
TIC: 1.685942
Time Last Bid Received On:08/27/2019 10:59:44 CDST
This proposal is made subject to all of the terms and conditions of the Official Bid Form, the Official Notice of
Sale, and the Preliminary Official Statement, all of which are made a part hereof.
Bidder: J.P. Morgan Securities LLC, New York , NY
Contact: Brian McGann
Title: Analyst
Telephone:212-834-7155
Fax:
Issuer Name: City of Ames Company Name:
Accepted By: Accepted By:
Date: Date
https://www.newissuchome.i-deal.com/Parity/asp/main.asp?frame=content&page=parityB i... 8/27/2019
PARITY Bid Form Page I of 2
upcoming Calendar I Overview I Result I Excel
Fifth Third Securities, Inc. - Cincinnati , OH's Bid "4-;A I I R If 7�lt:
Ames
$11 ,555,000 General Obligation Corporate Purpose Bonds, Series
2019A
For the aggregate principal amount of$11,555,000.00,we will pay you$13,099,006.59, plus accrued interest
from the date of issue to the date of delivery. The Bonds are to bear interest at the following rate(s):
Maturity Date mount Coupon%lYield%Dollar Price
06/01/2020 965M 5.0000 1.0300 102.836
06/01/2021 920M 5.0000 1.0400 106.729
06/01/2022 935M 5.0000 1.0500 110.560
06/01/2023 955M 1.5000 1.0600 101.600
06/01/2024 970M 5.0000 1,1000 117.886
06/01/2025 995M 5.0000 1.1400 121.312
06/01/2026 1,010M 5.0000 1.2000 124.459
06/01/2027 920M 5.0000 1.2500 127.511
06/01/2028 940M 4.0000 1.3600 119.282
06/01/2029 960M 4.0000 1.4700 118.397
06/01/2030 980M 3.0000 1.9000 107.861
06/01/2031 1,005M 3.0000 2.0000 107.118
Total Interest Cost: $2,871,655.21
Premium: $1,544,006.59
Net Interest Cost: $1,327,648.62
TIC: 1.687270
Time Last Bid Received On:08/27/2019 10:56:40 CDST
This proposal is made subject to all of the terms and conditions of the Official Bid Form, the Official Notice of
Sale, and the Preliminary Official Statement, all of which are made a part hereof.
Bidder: Fifth Third Securities, Inc., Cincinnati , OH
Contact: Geoff Kobayashi
Title:
Telephone:513-534-5535
Fax:
Issuer Name: City of Ames Company Name.
Accepted By: Accepted By:
Date: Date:
https://www.newissuehome.i-deal.com/Parity/asp/main.asp?frame=content&page=parityB i... 8/27/2019
PARITY Bid Form Page 1 of 2
Upcoming Calendar I Overview I Result I Excel
UBS Financial Services Inc. - New York , NY's Bid
Ames
$11,555,000 General Obligation Corporate Purpose Bonds, Series
2019A
For the aggregate principal amount of$11,555,000.00,we will pay you$13,068,518.07, plus accrued interest
from the date of issue to the date of delivery.The Bonds are to bear interest at the following rate(s):
Maturity Date Amount$Coupon % ield % Dollar Price
06/01/2020 965M 5.0000 1.0500 102.822
06/01/2021 920M 5.0000 1.0600 106.694
06/01/2022 935M 5.0000 1.0800 110.475
06/01/2023 955M 1.5000 1.0900 101.489
06/01/2024 970M 5.0000 1.1300 117.735
06/01/2025 995M 5.0000 1.1600 121.188
06/01/2026 1,010M 5.0000 1.2200 124.313
06/01/2027 920M 5.0000 1.2800 127.258
06/01/2028 940M 4.0000 1.4600 118.477
06/01/2029 960M 4.0000 1.6000 117.361
06/01/2030 980M 3.0000 1.9700 107.340
06/01/2031 1,005M 3.0000 2.0500 106.748
Total Interest Cost: $2.871.655.21
Premium: $1,513,518.07
Net Interest Cost: $1.358,137.14
TIC: 1.728901
Time Last Bid Received On:08/27/2019 10:58:30 CDST
This proposal is made subject to all of the terms and conditions of the Official Bid Form, the Official Notice of
Sale, and the Preliminary Official Statement, all of which are made a part hereof.
Bidder: UBS Financial Services Inc., New York , NY
Contact: Michael Ciliento
Title: Executive Director
Telephone:212-713-3000
Fax:
Issuer Name: City of Ames Company Name:
Accepted By: Accepted By:
Date: Date:
https://www.newissuehome.i-deal.com/Parity/asp/main.asp?frame=content&page=parityBi... 8/27/2019
ID pfm
SOURCES AND USES OF FUNDS
City of Ames,Iowa
General Obligation Corporate Purpose Bonds,Series 2019A
Final Numbers
Dated Date 09/12/2019
Delivery Date 09/12/2019
Portion Paid Portion Paid Portion Paid
Sources: by Taxes by TIE by Utilities Total
Bond Proceeds:
Par Amount 10,245,000.00 280,000.00 250,000.00 10,775,000.00
Premium 978,217.15 39.365.90 35,245.85 1,052,828.90
11,223,217.15 319,365.90 285,245.85 11,827,828.90
Portion Paid Portion Paid Portion Paid
Uses: by Taxes by TIF by Utilities Total
Project Fund Deposits:
Project Fund 11,090,000.00 314,204.00 280,000.00 11,684,204.00
Delivery Date Expenses:
Cost of Issuance 62,088.03 1,696.89 1,515.08 65,300.00
Underwriter's Discount 70,821.50 1,935.58 1,728.20 74,485.28
132,909.53 3,632.47 3,243.28 139,785.28
Other Uses of Funds:
Additional Proceeds 307.62 1,529.43 2,002.57 3,839.62
11,223,217.15 319,365.90 285,245.85 11,827,828.90
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 1
pfm
BOND SUMMARY STATISTICS
City of Ames,Iowa
General Obligation Corporate Purpose Bonds,Series 2019A
Final Numbers
Dated Date 09/12/2019
Delivery Date 09/122019
Last Maturity 06/O1/2031
Arbitrage Yield 1.512165%
True Interest Cost(TIC) 1.638826%
Net Interest Cost(MC) 1.720127%
All-In TIC 1.7351068/6
Average Coupon 3.126966%
Average Life(years) 6.454
Weighted Average Maturity(years) 6.401
Duration of Issue(years) 5.841
Par Amount 10,775,000.00
Bond Proceeds 11,827,828.90
Total Interest 2,174,554.79
Net Interest 1,196,211.17
Total Debt Service 12,949,554.79
Maximum Annual Debt Service 1,142,579.79
Average Annual Debt Service 1,104,963.20
Underwriter's Fees(per S 1000)
Average Takedown
Other Fee 6.912787
Total Underwriter's Discount 6.912787
Bid Price 109,079755
Par Average Average PV of I by
Bond Component Value Price Coupon Life change
Bond Component 8,795,000.00 111.971 3.656% 5.380 4,569.50
Term Bond 2031 1,980,000.00 100.000 2.000% 11.224 2,059.20
10,775,000.00 6A54 6,628.70
All-In Arbitrage
TIC TIC Yield
Par Value 10,775,000.00 10,775,000.00 10,775,000.00
+Accrued Interest
+Premium(Discount) 1,052,828.90 1,052,828.90 1,052,828.90
-Underwriter's Discount -74.495.28 -74.485.28
-Cost of Issuance Expense -65.300.00
-Other Amounts
Target Value 11,753,343.62 11,688,043.62 11,827,828.90
Target Date 09/12/2019 09/12/2019 09/12/2019
Yield 1.638826% 1.735106% 1.512165%
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 2
pfm
BOND PRICING
City of Ames,Iowa
General Obligation Corporate Purpose Bonds,Series 2019A
Final Numbers
Maturity Yield to Call Call Premium
Bond Campanian Data Amount R.I. Yield Price Maturity Date Price (-DtuounQ
Bond Component.
06/01/2020 960.000 5000% 1-100% 102785 2395100
0 6/0 12 02 1 T75,000 5.000% 1,050% 106.711 52,010.25
06/012022 910,000 5000% L060% 110,532 85.30920
06/012023 945,000 1500% 1.070% 101563 13.20735
06/01/2024 860,000 5.000% L100% 117.996 153.819.60
06/012025 905,000 5m% 1,150% 121.250 192,31230
D61012026 945,000 5.000% 1.200% 124.459 231,137.55
06/012027 895,000 5000% 1250% 127511 246,223.45
06/012028 940,000 2000% L500% 103.630 C 1.553% 06/012027 100.000 34,122.00
06/01/2029 960,000 2.000% 1.700% 102.160 C 1.757% 06/012027 100,000 20,736.00
8,795,000 1,052,829.90
Term Band_2031:
O6/01/2030 980,000 2000% 2.000% 100000
06/01/2031 1,000,000 2.000% 2.000% 100,000
1,990,000
10,775.000 1,052,928.90
Dated Date 0 9112/2 0 19
Delivm Date 09/12/2019
First Coupaa 06/012020
Par Antonio 10,775,000.00
Premium 1,052,828.90
Pradoctiw 11.827,82990 109.771034%
Underwraeis Discount =448528 -11 e91279^e
Purchase Price 11.753,34362 109,079755%
Accrued Interest
Net Proceeds 11,753,343.62
Aug 27.2019 12 04 pm Prepared 65 PFM Financial Advisors LLC Page 3
ID pfm
BOND DEBT SERVICE
City of Ames,Iowa
General Obligation Corporate Purpose Bonds,Series 2019A
Final Numbers
Period Annual
Ending Principal Coupon Interest Debt Service Debt Service
06/012020 860,000 5.000% 282,579.79 1,142,579.79 1,142,579.79
12/012020 174,887.50 174,887.50
06/01/2021 775,000 5.000% 174,897.50 949,887.50 1,124,775.00
12/012021 155,512.50 155,512.50
06/012022 810,000 5.000% 155.512.50 965,512.50 1,121,025.00
12/012022 135.262.50 135,262.50
06/012023 845,000 1.500% 135,262.50 980,262.50 1,115,525.00
12/01/2023 129,925.00 128,925.00
06/012024 860,000 5.000% 128,925.00 989,925.00 1,117,850.00
12/01/2024 107.425.00 107,425.00
06/012025 905,000 5.000% 107,425.00 1,012,425.00 1,119,850.00
12/012025 84,800,00 84,800.00
06/01/2026 945,000 5.000% 84,800.00 1,029,800.00 1,114,600.00
12/01/2026 61,175.00 61,175.00
06/01/2027 895,000 5.000% 61,175.00 956,175.00 1,017,350.00
12/01/2027 38.800.00 38,800.00
06/012028 940,000 2.000% 38,800.00 979,800.00 1,017,600.00
12/012028 29.400.00 29,400.00
06/012029 960,000 2.000% 29,400.00 989,400.00 1,018,800.00
12/012029 19,800.00 19,800.00
06/01/2030 980,000 2.000% 19,800.00 999,800.00 1,019,600.00
12/012030 10.000.00 10,000.00
06/012031 1,000.000 2.000% 10,000.00 1,010,000.00 1,020,000.00
10,775,000 2,174,554.79 12,949,554.79 12,949,554.79
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 4
Pfm
BOND DEBT SERVICE
City of Ames.Iowa
Portion Paid by Taxes
Period Annual
Ending Principal Coupon Interest Debt Service Debt Service
06/01/2020 860,000 5.000% 265,654.96 1,125,654.96 1,125,654.86
12/01/2020 163.125.00 163,125.00
06/01/2021 690,000 5.000% 163.125.00 853,125.00 1,016,250.00
12/01/2021 145,875.00 145,875.00
06/01/2022 725,000 5.000% 145,975.00 870,875.00 1,016,750.00
12/01/2022 127.750.00 127,750.00
06/01/2023 760,000 1.500% 127,750.00 887,750.00 1,015,500.00
12/012023 122,050.00 122,050.00
06/012024 775,000 5.000% 122,050.00 897,050.00 1,019,100.00
12/01/2024 102,675.00 102,675.00
06/01/2025 810,000 5.000% 102,675.00 912,675.00 1,015,350.00
12/012025 82,425.00 82.425.00
06/012026 850,000 5.000% 82,425.00 932,425.00 1,014,850.00
12/012026 61,175.00 61,175.00
06/012027 895,000 5.000% 61,175.00 956,175.00 1,017,350.00
12/012027 38,800.00 38,800.00
06/012028 940,000 2.000% 38,800.00 978,800.00 1,017,600.00
12/012028 29.400.00 29,400.00
06/012029 960,000 2.000% 29,400.00 989,400.00 1,018,800.00
12/012029 19.800.00 19,800.00
06/012030 980,000 2.000% 19,800.00 999,800.00 1,019,600.00
12/01/2030 10,000.00 10,000.00
06/012031 1,000,000 2.000% 10,000.00 1,010,000.00 1,020,000.00
10,245.000 2,071,804.86 12,316,804.86 12,316,804.86
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 5
Pfm
BOND DEBT SERVICE
City of Ames,Iowa
Portion Paid by TIF
Period Annual
Ending Principal Coupon Interest Debt Service Debt Service
06/01/2020 8,939.10 8,939.10 8,939.10
12/01/2020 6,212.50 6,212.50
06/012021 45,000 5.000% 6,212.50 51,212.50 57,425.00
12/01/2021 5,087.50 5,087.50
06/012022 45,000 5.000% 5,087.50 50,087.50 55,175.00
12/01/2022 3.962.50 3,962.50
06/012023 45,000 1.500% 3,962.50 48,962.50 52,925.00
12/012023 3.625.00 3,625.00
06/01/2024 45,000 5.000% 3,625.00 48,625.00 52,250.00
12/012024 2,500.00 2,500.00
06/012025 50,000 5.000% 2,100,00 52,500.00 55,000.00
12/012025 1,250.00 1,250.00
06/012026 50,000 5.000% 1,250.00 51,250.00 52,500.00
280,000 54,214.10 334,214.10 334,214.10
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 6
City of Ames,Iowa
General Obligation Corporate Purpose Bonds,Series 2019A
TIC Calculation
Period Robert W.Baird Janney UMB Bank J.P.Morgan Fifth Third UBS Financial
Endine Debt Servitt Debt Service Debt Service Debt Service Debt Service Debt Service
09-12-19 (12617066.85) (13,1191 1('000) 113.'ii_3'-,, 1(1) (13,4--2,11''85) (13 099.006 59) [13069,i 19 07)
06.01-20 1,272,760.35 1,314,236.32 1,338,293,75 1,352,708.61 1,314,380.21 1,314,380 21
12-01-20 189,762 50 219,587.50 235,300.00 245,325.00 218,697.50 218,68T50
06-01-21 1,109,762.50 1,138587.50 1,155,300.00 1,165,325.00 1,139,687.50 1,138,687.50
12.01-21 166,762.50 195,58750 212,30000 222,325.00 195,687,50 195,68750
06-01.22 1,101,762.50 1,130,587.50 1,147,300,00 1,157,325.00 1,130,687.50 1,130,687.50
12-01-22 143,38TS0 172,212 50 188,925.00 198,950.00 172,312.50 172,312.50
06-01-23 1,098,387.50 1,127,212.50 1.143,925 00 1,153,950.00 1,127,312.50 1,127,312.50
12-01-23 136,225.00 165,050.00 165,050.00 175,075.00 165,150.00 165,150.00
06-01-24 1,106,225.00 1.135.050.00 1,135,050.00 1,145,075.00 1,135,150.00 1,135,150.00
12-01-24 111.975.00 140,800,00 140,800.00 150,825 00 140,900.00 140,900.00
06-01-25 1,106,975.00 1,135,800,00 1,135,800,00 1,145,825.00 1.135,900,00 1,135,900,00
12-01-25 87,100.00 115.925.00 115,925.00 125,950.00 116,025.00 116,025,00
06-01-26 1,097,100.00 1,125,925 00 1,125,925.00 1,135,950.00 1,126,025,00 1,126,025.00
12-01-26 61,850.00 90,675.00 90,675 00 100,700.00 90,775M 90,775 00
06-01-27 981,850,00 1,010,675.00 1,010,67500 1,020,700.00 1,010,775,00 1.010,775,00
12-01-27 39,850.00 67,675.00 67,675.00 77,70000 67,77500 67,77500
06-01-28 978,850.00 1,007,67500 1,007,67500 1,017,700.00 1,007,775,00 1,007,77500
12-01-28 29,450,00 44,175.00 44,175M 59,900.00 48,975,00 48,975M
06-01-29 989,450.00 1,004,175.00 1,004,175.00 1,018,900,00 1,008,975.00 1008,975.00
12-01-29 19,850.00 29,775.00 29,775.00 39,700.00 29,775,00 29,775.00
06-01-30 999,850.00 1,009,775.00 1,009,775.00 1,019,700.00 1,009,775.00 1,009,775M
12-01-30 10,050.00 15,075.00 15,075.00 20,100.00 15,075.00 15,075.00
06-01-31 1,015,050.00 1,020,075.00 1.020,075 00 1,025,100.00 1,020,075.00 1,020,075.00
13,853,285.35 14,415,311 32 14,539,633 75 14,773,808 6l 14,426 655.21 14,426,655,21
Par 11,555,000,00 11,555,000,00 11,555,000.00 11,555,000,00 11,555,000.00 11,555,000.00
Accrued None None None None None None
Discount 1062,066.95 1,564,100.00 1,680,326,10 1,867,132.85 1,544,006,59 1513,518.07
12,617,066.85 13,119,100.00 13,235,326.10 13,422,132.95 13,099,006,59 13,069,518 07
TIC 1.625930% 1.646538% 1.651750% 1,685942% 1687270% 1.728901%
NIC 1,236,218.50 1,296,211.32 1,304,307.65 1,351,675.76 1,327,64862 1,358,137.14
Bid (12617,M685) (13.119,10()1)0) (13,235,3.2610) i13422_1i'-SSi (13.(199.00h i91 (13068.51807)
Bid NIC TIC
Robert W.Baird 12,617,066.85 1,236,218,50 1.6259301/6
Janney 13,119,10000 1,296,21132 1,646539%
UMB Bank 13,235,326.10 1,304,307,65 1651750%
J.P.Morgan 13,422,132.95 1,351 675.76 1.685942%
Fifth Third 13,099,006.59 1,327,648,62 1.687270%
UBS Financial 13,068,518.07 1,359,137.14 1.728901%
PFM Financial Advisors,LLC Date: 8/27/2019r Time: 11:08 AM
pfm
BOND DEBT SERVICE
City of Ames,Iowa
Portion Paid by Utilities
Period Annual
Ending Principal Coupon Interest Debt Service Debt Service
06/012020 7,985.83 7,985.83 7,985.83
12/01/2020 5,550.00 5,550.00
06/01/2021 40,000 5.000% 5,550.00 45,550.00 51,100.00
12/012021 4,550.00 4,550.00
06/01/2022 40,000 5.000% 4,550.00 44,550.00 49,100.00
12/012022 3,550.00 3,550.00
06/01/2023 40,000 1.500% 3,550.00 43,550.00 47,100.00
12/0/2023 3,250.00 3,250.00
06/01/2024 40,000 5.000% 3,250.00 43,250.00 46,500.00
12/012024 2,250.00 2,250.00
06/012025 45,000 5.000% 2,250.00 47,250.00 49,500.00
12/012025 1,125.00 1,125.00
06/01/2026 45,000 5.000% 1,125.00 46,125.00 47,250.00
250,000 48,535.83 298,535.83 298,535.83
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 7
10 pfm
FORM 8038 STATISTICS
City of Ames.Iowa
General Obligation Corporate Purpose Bonds,Series 2019A
Final Numbers
Dated Date 09/1212019
Delivery Date 09/12/2019
Redemption
Bond Component Date Principal Coupon Price Issue Price at Maturity
Bond Component:
06/01/2020 860,000.00 5.000% 102.785 883,951.00 860,000.00
06/01/2021 775,000.00 5.000% I06.711 827,010.25 775,000.00
O6/O1/2022 810,000.00 5.000% 110.532 995,309.20 810,000.00
06/O1/2023 845,000.00 1.500% 101.563 858,207.35 845,000.00
06/01/2024 860,000.00 5.00001. 117.886 1,013,919.60 860,000.00
06/01/2025 905,000.00 5.000% 121.250 1,097,312.50 905,000.00
06/01/2026 945,000.00 5.000% 124.459 1,176,137.55 945,000.00
06/01/2027 895,000.00 5.000% 127.511 1,141,223.45 895,000.00
06/01/2028 940,000.00 2.000% 103.630 974,122.00 940,000.00
06/01/2029 960,000.00 2.000% 102.160 980,736.00 960,000.00
Term Bond_2031:
06/01/2030 980,000.00 2.000% 100.000 980,000.00 980,000.00
06/01/2031 1,000,000.00 2.000% 100.000 1,000,000.00 1,000,000.00
10,775,000.00 11,827,828.90 10,775,000.00
Stated Weighted
Maturity Interest Issue Redemption Average
Date Rate Price at Maturity Maturity Yield
Final Maturity 06/01/2031 2.0000/6 1,000,000.00 1,000,000.00
Entire Issue 11,827,928.90 10,775,000.00 6.4009 1.5122%
Proceeds used for accrued interest 0.00
Proceeds used for bond issuance costs(including underwriters'discount) 139,78528
Proceeds used for credit enhancement 0.00
Proceeds allocated to reasonably required reserve or replacement fund 0.00
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 9
pfm
PROOF OF ARBITRAGE YIELD
City of Ames,Iowa
General Obligation Corporate Purpose Bonds,Series 2019A
Final Numbers
Present Value
to 09/12/2019
Date Debt Service Total a1 1.5121650085%
06/01/2020 1,142,579.79 1,142,579.79 1,130,263.08
12/012020 174,887.50 174,887.50 171,704.03
06/012021 949,887.50 949,887.50 925,598.47
12/012021 155.512.50 155.512.50 150,398.84
06/012022 965,512.50 965.512.50 926,756.86
12/01/2022 135,262.50 135,262.50 128,858.79
06/01/2023 980,262.50 980,262.50 926,846.36
12/012023 128,925.00 128,925.00 120,984.92
06/012024 988,925.00 988,925.00 921,056.28
12/01/2024 107,425.00 107,425.00 99,301.75
06/012025 1,012,425.00 1,012,425.00 928,844.74
12/012025 84,800.00 84,800.00 77,215.56
06/012026 1,029,800.00 1,029,800.00 930,659.06
12/012026 61,175.00 61,175.00 54,870.69
06/012027 2,856,175.00 2,956,175.00 2,542,611.39
12/01/2027 19,800.00 19,800.00 17.494.00
06/01/2028 19,800.00 19,800.00 17,362.72
12/01/2028 19,800.00 19,800.00 17,232.43
06/01/2029 19,800.00 19,800.00 17,103.12
12/012029 19.800.00 19,800.00 16,974.77
06/012030 999,800.00 999,800.00 850,708.29
12/012030 10,000.00 10,000.00 8,444.93
06/012031 1,010,000.00 1,010,000.00 846,537.81
12,892,354.79 12,892,354.79 11,827,828.90
Proceeds Summary
Delivery date 09/12/2019
Par Value 10,775,000.00
Premium(Discount) 1,052,828.90
Target for yield calculation 11,827,828.90
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 9
ID pfm
PROOF OF ARBITRAGE YIELD
City of Ames.Iowa
General Obligation Corporate Purpose Bonds.Series 2019A
Final Numbers
Assumed Call/Computation Dates for Premium Bonds
Bond Maturity Call Call Yield To
Component Date Rate Yield Date Price Call/Maturity
BOND 06/O1/2028 2.000% 1.500% 06/01/2027 100.000 1.4999287%
BOND 06/O1/2029 2.000% 1.700% 06/01/2027 100.000 1.6998740%
Reiected Call/Computation Dates for Premium Bonds
Bond Maturity Call Call Yield To Increase
Component Date Rate Yield Date Price. Call/Maturity to Yield
BOND 06/01/2028 2.000% 1.500% 1.5529573% 0.0530285%
BOND 06/01/2029 2.000% 1.700% 1.7569703% 0.0570963%
Aug 27,2019 12:04 pm Prepared by PFM Financial Advisors LLC Page 10
pfm
UNDERWRITER'S DISCOUNT
City of Ames,Iowa
General Obligation Corporate Purpose Bonds,Series 2019A
Final Numbers
Underwriter's Discount $/1000 Amount
Underwriter's Discount 6.91279 74,485.29
6.91279 74,495.28
Aug 27,2019 I2:04 pm Prepared by PFM Financial Advisors LLC Page 11