Loading...
HomeMy WebLinkAboutA019 - Debt Service Schedule$10,035,000 G. 0. Corporate Purpose Bonds, Series 1995 City of Ames, Iowa Final Based Upon Harris Trust & Savings Bank's Bid DEBT SERVICE SCHEDULE DATE PRINCIPAL COUPON INTEREST PERIOD TOTAL -------------- -------------- FISCAL TOTAL -------- 12/ 1/95 -------------- ---------- -------------- 297,510.21 297,510.21 6/ 1/96 715,000.00 4.850000 255,008.75 970,008.75 1,267,518.96 12/ 1/96 237,670.00 237,670.00 6/ 1/97 715,000.00 4.900000 237,670.00 952,670.00 1,190,340.00 12/ 1/97 220,152.50 220,152.50 6/ 1/98 715,000.00 5.000000 220,152.50 935,152.50 1,155,305.00 12/ 1/98 202,277.50 202,277.50 6/ 1/99 715,000.00 5.000000 202,277.50 917,277.50 1,119,555.00 12/ 1/99 184,402.50 184,402.50 6/ 1/ 0 715,000.00 5.000000 184,402.50 899,402.50 1,083,805.00 12/ 1/ 0 166,527.50 166,527.50 6/ 1/ 1 715,000.00 5.000000 166,527.50 881,527.50 1,048,055.00 12/ 1/ 1 148,652.50 148,652.50 6/ 1/ 2 715,000.00 5.000000 148,652.50 863,652.50 1,012,305.00 12/ 1/ 2 130,777.50 130,777.50 6/ 1/ 3 720,000.00 5.100000 130,777.50 850,777.50 981,555.00 12/ 1/ 3 112,417.50 112,417.50 6/ 1/ 4 720,000.00 5.100000 112,417.50 832,417.50 944,835.00 12/ 1/ 4 94,057.50 94,057.50 6/ 1/ 5 720,000.00 5.200000 94,057.50 814,057.50 908,115.00 12/ 1/ 5 75,337.50 75,337.50 6/ 1/ 6 720,000.00 5.250000 75,337.50 795,337.50 870,675.00 12/ 1/ 6 56,437.50 56,437.50 6/ 1/ 7 720,000.00 5.250000 56,437.50 776,437.50 832,875.00 12/ 1/ 7 37,537.50 37,537.50 6/ 1/ 8 480,000.00 5.250000 37,537.50 517,537.50 555,075.00 12/ 1/ 8 24,937.50 24,937.50 6/ 1/ 9 475,000.00 5.250000 24,937.50 499,937.50 524,875.00 12/ 1/ 9 12,468.75 12,468.75 6/ 1/10 475,000.00 -------------- 5.250000 12,468.75 -------------- 487,468.75 -------------- 499,937.50 10,035,000.00 3,959,826.46 13,994,826.46 ACCRUED 10,035,000.00 3,959,826.46 13,994,826.46 Dated 5/ 1/95 with Delivery of 5/ 1/95 Bond Years 76,871.250 Average Coupon 5.151245 Average Life 7.660314 N I C % 5.281523 % Using 99.0020329 T I C % 5,309062 % From Delivery Date RUNOATE: 04-11-1995 @ 13:16:53 FILENAME: AMES KEY: 95 $10,035,000 G.O. Corporate Purpose Bonds, Series 1995 $193,795 Fire Truck Portion of the Bonds Final Based Upon Harris Trust & Savings Bank's Bid DEBT SERVICE SCHEDULE DATE PRINCIPAL COUPON INTEREST PERIOD TOTAL .............. .............. FISCAL TOTAL ........ 12/ 1/95 .............. .......... .............. 5,713.59 5,713.59 6/ 1/96 16,150.00 4.850000 4,897.36 21,047.36 26,760.95 12/ 1/96 4,505.72 4,505.72 6/ 1/97 16,150.00 4.900000 4,505.72 20,655.72 25,161.44 12/ 1/97 4,110.05 4,110.05 6/ 1/98 16,150.00 5.000000 4,110.05 20,260.05 24,370.09 12/ 1/98 3,706.30 3,706.30 6/ 1/99 16,150.00 5.000000 3,706.30 19,856.30 23,562.59 12/ 1/99 3,302.55 3,302.55 6/ 1/ 0 16,150.00 5.000000 3,302.55 19,452.55 22,755.09 12/ 1/ 0 2,898.80 2,898.80 6/ 1/ 1 16,150.00 5.000000 2,898.80 19,048.80 21,947.59 12/ 1/ 1 2,495.05 2,495.05 6/ 1/ 2 16,150.00 5.000000 2,495.05 18,645.05 21,140.09 12/ 1/ 2 2,091.30 2,091.30 6/ 1/ 3 16,149.00 5.100000 2,091.30 18,240.30 20,331.59 12/ 1/ 3 1,679.50 1,679.50 6/ 1/ 4 16,149.00 5.100000 1,679.50 17,828.50 19,507.99 12/ 1/ 4 1,267.70 1,267.70 6/ 1/ 5 16,149.00 5.200000 1,267.70 17,416.70 18,684.39 12/ 1/ 5 847.82 847.82 6/ 1/ 6 16,149.00 5.250000 847.82 16,996.82 17,844.64 12/ 1/ 6 423.91 423.91 6/ 1/ 7 16,149.00 -------------- 5.250000 423.91 -------------- 16,572.91 -------------- 16,996.82 193,795.00 65,268.27 259,063.27 ACCRUED 193,795.00 65,268.27 259,063.27 Dated 5/ 1/95 with Delivery of 5/ 1/95 Bond Years 1,275.800 Average Coupon 5.115871 Average Life 6.583243 N I C % 5.267463 % Using 99.0020329 T I C % 5.295960 % From Delivery Date RUNDATE: 04-11-1995 @ 14:38:46 FILENAME: AMES KEY: 95F $10,035,000 G.O. Corporate Purpose Bonds, Series 1995 $520,185 Storm Sewer improvements Portion Final Based Upon Harris Trust & Savings Bank's Bid DEBT SERVICE SCHEDULE DATE PRINCIPAL COUPON INTEREST PERIOD TOTAL .............. .............. FISCAL TOTAL ........ 12/ .............. 1/95 .......... .............. 15,336.43 15,336.43 6/ 1/96 43,349.00 4.850000 13,145.51 56,494.51 71,830.94 12/ 1/96 12,094.30 12,094.30 6/ 1/97 43,349.00 4.900000 12,094.30 55,443.30 67,537.59 12/ 1/97 11,032.25 11,032.25 6/ 1/98 43,349.00 5.000000 11,032.25 54,381.25 65,413.49 12/ 1/98 9,948.52 9,948.52 6/ 1/99 43,349.00 5.000000 9,948.52 53,297.52 63,246.04 12/ 1/99 8,864.80 8,864.80 6/ 1/ 0 43,349.00 5.000000 8,864.80 52,213.80 61,078.59 12/ 1/ 0 7,781.07 7,781.07 6/ 1/ 1 43,349.00 5.000000 7,781.07 51,130.07 58,911.14 12/ 1/ 1 6,697.35 6,697.35 6/ 1/ 2 43,349.00 5.000000 6,697.35 50,046.35 56,743.69 12/ 1/ 2 5,613.62 5,613.62 6/ 1/ 3 43,349.00 5.100000 5,613.62 48,962.62 54,576.24 12/ 1/ 3 4,508.22 4,508.22 6/ 1/ 4 43,349.00 5.100000 4,508.22 47,857.22 52,365.44 12/ 1/ 4 3,402.82 3,402.82 6/ 1/ 5 43,348.00 5.200000 3,402.82 46,750.82 50,153.64 12/ 1/ 5 2,275.77 2,275.77 61 1/ 6 43,348.00 5.250000 2,275.77 45,623.77 47,899.54 12/ 1/ 6 1,137.89 1,137.89 6/ 1/ 7 43,348.00 5.250000 1,137.89 44,485.89 .............. 45,623.77 -------------- 520,185.00 .............. 175,195.11 695,380.11 ACCRUED 520,185.00 175,195.11 695,380.11 Dated 5/ 1/95 with Delivery of 5/ 1/95 Bond Years 3,424.538 Average Coupon 5.115876 Average Life 6.583307 N I C % 5.267467 % Using 99.0020329 T I C % 5.295963 % From Delivery Date RUNDATE: 04-11-1995 @ 14:34:00 FILENAME: AMES KEY: 95E $10,035,000 G.O.Bonds, Series 1995 $938,372 Water Portion OfThe Bonds rinaL Based upon Harris Trust & sw./nmm oan:'s e/u DEBT SERVICE SCHEDULE =============== oxrs pm/wczPxL ooupow Iwrcnssr -------------- PEmzoo TOTAL rIsou TOTAL -------- 12/ -------------- 1/95 ---------- -------------- 27,665.67 27,665.67 _______ a/ 1/96 78,198.00 4,850000 23,713.44 1$1,911,44 129,577.11 12/ 1/96 21,817-14 21,817.14 6/ 1/97 78,198'00 4'900000 31,817,14 100,015,14 121,02,27 12/ 1/97 19,901.29 19,901.29 6/ 1/98 78,198.00 5.000000 19,901.29 98,099.29 118,000.57 12y 1/9* 17,*46.34 17,946-34 6/ 1/99 78,198'00 5.000000 17,946.34 96,144'34 114,090.67 12y 1/99 15,991.39 15,991,39 6/ 1/ n 78.198.00 5,000000 15,991.39 94,189-39 110,180,77 12/ 1/ V 14,036.44 14,036-44 6/ 1/ 1 78,198-00 5.000000 14,036.44 92,234,44 106,270'87 12/ V 1 12,081.49 12,081.49 8/ 1/ Z 78,198.00 5,000000 13,081.49 90,279.49 102,360.97 12/ 1/ 2 10,136.54 10,126.54 u/ l/ 3 78,195.00 5.100000 10'126.54 88,324.54 98,451.07 12% 1/ 3 8,152.49 8,132.49 6/ 1/ 4 78,197.00 5.100000 8,132,49 86,329,49 94.461.97 12Y 1/ 4 6,138'48 6,138,46 6/ 1/ 5 78,197'00 5'200000 6,138'46 84,335.46 90,473.92 12Y 1/ 5 *,/05'34 4,105.34 6/ 1/ 6 78,197.00 5,350000 4,105.34 82,302.34 86,407,68 12Y 1/ 6 2,052.67 2,052'87 6/ 1/ 7 78,197.00 5.250000 2,052.67 80,249.67 82,302^34 ------- 938,372.00 -------------- -------------- 316,038-21 1,254,410.21 ACCRUED ============ 938,372,00 ============== 318,038.21 1,254,410.21 ======== Dated 5/ 1/95 with Detivery of 5/ 1/95 Bond ,ears 6,177,600 Average Coupon 5'115874 Average Life 6.583316 w / c % 5'267464 % Using *9-0020329 mumoxrs; 04-11'1995 m 14`31:59 FILENAME: x*ss KEY: 95o $10,035,000 G.O. Corporate Purpose Bonds, Series 1995 $1,193,895 Street improvements Portion Final Based Upon Harris trust & Savings Bank's Bid DEBT SERVICE SCHEDULE DATE PRINCIPAL COUPON INTEREST PERIOD TOTAL -------------- -------------- FISCAL TOTAL -------- 12/ 1/95 -------------- ---------- -------------- 35,199.17 35,199.17 6/ 1/96 99,492.00 4.850000 30,170.72 129,662.72 164,861.89 12/ 1/96 27,758.04 27,758.04 6/ 1/97 99,492.00 4.900000 27,758.04 127,250.04 155,008.08 12/ 1/97 25,320.49 25,320.49 6/ 1/98 99,492.00 5.000000 25,320.49 124,812.49 150,132.97 12/ 1/98 22,833.19 22,03.19 6/ 1/99 99,491.00 5.000000 22,03.19 122,324.19 145,157.37 12/ 1/99 20,345.91 20,345.91 6/ 1/ 0 99,491.00 5.000000 20,345.91 119,836.91 140,182.82 12/ 1/ 0 17,858.64 17,858.64 6/ 1/ 1 99,491.00 5.000000 17,858.64 117,349.64 135,208.27 12/ 1/ 1 15,371.36 15,371.36 6/ 1/ 2 99,491.00 5.000000 15,371.36 114,862.36 130,233.72 12/ 1/ 2 12,884.09 12,884.09 6/ 1/ 3 99,491.00 5.100000 12,884.09 112,375.09 125,259.17 12/ 1/ 3 10,347.07 10,347.07 6/ 1/ 4 99,491.00 5.100000 10,347.07 109,08.07 120,185.13 12/ 1/ 4 7,810.05 7,810.05 6/ 1/ 5 99,491.00 5.200000 7,810.05 107,301.05 115,111.09 12/ 1/ 5 5,223.28 5,223.28 6/ 1/ 6 99,491.00 5.250000 5,223.28 104,714.28 109,937.56 12/ 1/ 6 2,611.64 2,611.64 6/ 1/ 7 99,491.00 5.250000 2,611.64 102,102.64 -------------- 104,714.28 -------------- 1,193,895.00 -------------- 402,097.35 1,595,992.35 ACCRUED 1,193,895.00 402,097.35 1,595,992.35 Dated 5/ 1/95 with Delivery of 5/ 1/95 Bond Years 7,859.795 Average Coupon 5.115876 Average Life 6.583322 N I C % 5.267466 % Using 99.0020329 T I C % 5.295962 % From Delivery Date RUNDATE: 04-11-1995 & 14:29:04 FILENAME: AMES KEY: 95B $10,035,000 G.O. Corporate Purpose Bonds, Series 1995 $7,188,753 Resource Recovery Portion Final Based Upon Harris Trust & Savings Bank's Bid zaxxzxxxzzzxxxzxxxxxz DEBT SERVICE SCHEDULE xxxxxxxxxxxxxxxxxxxxx DATE PRINCIPAL COUPON INTEREST PERIOD TOTAL -------------- -------------- FISCAL TOTAL -------- 12/ 1/95 -------------- ---------- -------------- 213,595.35 213,595.35 6/ 1/96 477,811.00 4.850000 183,081.73 660,892.73 874,488.07 12/ 1/96 171,494.81 171,494.81 6/ 1/97 477,811.00 4.900000 171,494.81 649,305.81 820,800.62 12/ 1/97 159,788.44 159,788.44 6/ 1/98 477,811.00 5.000000 159,788.44 637,599.44 797,387.8.8 12/ 1/98 147,843.17 147,843.17 6/ 1/99 477,812.00 5.000000 147,843.17 625,655.17 773,498.33 12/ 1/99 135,897.87 135,897.87 6/ 1/ 0 477,812.00 5.000000 135,897.87 613,709.87 749,607.73 12/ 1/ 0 123,952.57 123,952.57 6/ 1/ 1 477,812.00 5.000000 123,952.57 601,764.57 725,717.13 12/ 1/ 1 112,007.27 112,007.27 6/ 1/ 2 477,812.00 5.000000 112,007.27 589,819.27 701,826.53 12/ 1/ 2 100,061.97 100,061.97 6/ 1/ 3 482,813.00 5.100000 100,061.97 582,874.97 682,936.93 12/ 1/ 3 87,750.24 87,750.24 6/ 1/ 4 482,814.00 5.100000 87,750.24 570,564.24 658,314.47 12/ 1/ 4 75,438.48 75,438.48 6/ 1/ 5 482,815.00 5.200000 75,438.48 558,253.48 633,691.96 12/ 1/ 5 62,885.29 62,885.29 6/ 1/ 6 482,815.00 5.250000 62,885.29 545,700.29 608,585.5e 12/ 1/ 6 50,211.40 50,211.40 6/ 1/ 7 482,815.00 5.250000 50,211.40 533,026.40 583,237.79 12/ 1/ 7 37,537.50 37,537.50 6/ 1/ 8 480,000.00 5.250000 37,537.50 517,537.50 555,075.00 12/ 1/ 8 24,937.50 24,937.50 6/ 1/ 9 475,000.00 5.250000 24,937.50 499,937.50 524,875.00 12/ 1/ 9 12,468.75 12,468.75 6/ 1/10 475,000.00 5.250000 12,468.75 487,468.75 499,937.5C -------------- 7,188,753.00 -------------- 3,001,227.52 -------------- 10,189,980.52 ACCRUED 7,188,753.00 3,001,227.52 10,189,980.52 Dated 5/ 1/95 with Delivery of 5/ 1/95 Bond Years 58,133.518 Average Coupon 5.162646 Average Life 8.086732 N I C % 5.286054 % Using 99.0020329 T I C % 5.313483 % From Delivery Date RUNDATE: 04-11-1995 @ 14:26:20 FILENAME: AMES KEY: 95A S10,035,000 G. 0. Corporate Purpose Bonds, Series 1995 City of Ames, Iowa Final Based Upon Harris Trust & Savings Bank's Bid BOND PRODUCTION REPORT DATED 5/ 1/1995 DELIVERY 5/ 1/1995 DATE PRINCIPAL BOND TYPE B/Y COUPON YIELD SPRICE -------- -------------- --------- -------- ------- ------- ------- 6/ 1/96 715,000.00 Standard 775 4.8500 4.4000 100.467 6/ 1/97 715,000.00 Standard 2264 4.9000 4.6000 100.585 6/ 1/98 715,000.00 Standard 4469 5.0000 4.7000 100.847 6/ 1/99 715,000.00 Standard 7388 5.0000 4.7500 100.914 6/ 1/ 0 715,000.00 Standard 11023 5.0000 4.8500 100.664 6/ 1/ 1 715,000.00 Standard 15373 5.0000 4.9500 100.255 6/ 1/ 2 715,000.00 Standard 20437 5.0000 5.0205 99.875 6/ 1/ 3 720,000.00 Standard 26257 5.1000 5.1184 99.875 6/ 1/ 4 720,000.00 Standard 32797 5.1000 5.1690 99.500 6/ 1/ 5 720,000.00 Standard 40057 5.2000 5.2316 99.750 6/ 1/ 6 720,000.00 Standard 48037 5.2500 5.2946 99.625 6/ 1/ 7 720,000.00 Standard 56737 5.2500 5.4000 98.676 6/ 1/ 8 480,000.00 Standard 63017 5.2500 5.5000 97.684 6/ 1/ 9 475,000.00 Standard 69707 5.2500 5.6000 96.616 6/ 1/10 475,000.00 Standard 76871 5.2500 5.7000 95.482 -------------- 10,035,000.00 Par Amount 10,035,000.00 Production -41,394.05 Gross Production 9,993,605.95 99.5875032 Bond Insurance 0.00 0.0000000 Underwriters Discount 58,751.95 0.5854704 Average Take Down 0.00 0.0000000 Bid 9,934,854.00 99.0020329 Accrued 0.00 Net to Issuer 9,934,854.00 Gross Interest Cost 3,959,826.46 +Net Discount 100,146.00 Net Interest Cost 4,059,972.46 N I C % 5.2815226 Using 99.0020329 T I C % 5.3090615 From Delivery Date Bond Years 76,871.250 Average Coupon 5.151245 Average Life 7.660314 RUNDATE: 04-11-1995 @ 13:39:26 FILENAME: AMES KEY: 95 GROSS PRICED TO CALL PRODUCTION 718,339.05 719,182.75 721,056.05 721,535.10 719,747.60 716,823.25 714,106.25 719,100.00 716,400.00 718,200.00 717,300.00 710,467.20 468,883.20 458,926.00 453,539.50 9,993,605.95 $10,035,000 G. 0. Corporate Purpose Bonds, Series 1995 City of Ames, Iowa final Based Upon Harris Trust & Sayings Bank's Bid DELIVERY DATE: 5/ 1/95 Par 10,035,000.00 Original Issue (+Prefnium/-Discount) -41,394.05 ------------------ Gross Yield Target Value 9,993,605.95 G R 0 S S Y I E L D 5.21020448 % RUNDATE: 04-11-1995 @ 13:39:35 FILENAME: AMES KEY: 95 $10,035,000 G. 0. Corporate Purpose Bonds, Series 1995 City of Ames, Iowa Final Based Upon Harris Trust & Savings Bank's aid PV DATE: 5/ 1/1995 with 2 Compoundings using 30/360 Year Basis PV RESULTS: PV TOTAL = 9,993,605.95 PV RATE = 5.2102044795 CASH - FLOW SUBTOTAL = 13,994,826.46 DATE AMOUNT RATE PV FACTOR ----------- PV AMOUNT ---------- 12/ 1/1995 --------------- 297,510.21 ----------- 5.2102045 --------------- 0.97044192 288,716.38 6/ 1/1996 970,008.75 5.2102045 0.94580279 917,436.98 12/ 1/1996 237,670.00 5.2102045 0.92178924 219,081.65 6/ 1/1997 952,670.00 5.2102045 0.89838538 855,864.80 12/ 1/1997 220,152.50 5.2102045 0.87557574 192,760.19 6/ 1/1998 935,152.50 5.2102045 0.85334522 798,007.92 12/ 1/1998 202,277.50 5.2102045 0.83167913 168,229.98 6/ 1/1999 917,277.50 5.2102045 0.81056313 743,511.33 12/ 1/1999 184,402.50 5.2102045 0.78998326 145,674.89 6/ 1/2000 899,402.50 5.2102045 0.76992591 692,473.28 12/ 1/2000 166,527.50 5.2102045 0.75037780 124,958.54 6/ 1/2001 881,527.50 5.2102045 0.73132601 644,683.99 12/ 1/2001 148,652.50 5.2102045 0.71275793 105,953.25 6/ 1/2002 863,652.50 5.2102045 0.69466130 599,945.97 12/ 1/2002 130,777.50 5.2102045 0.67702413 88,539.52 6/ 1/2003 850,777.50 5.2102045 0.65983476 561,372.56 12/ 1/2003 112,417.50 5.2102045 0.64308182 72,293.65 6/ 1/2004 832,417.50 5.2102045 0.62675423 521,721.19 12/ 1/2004 94,057.50 5.2102045 0.61084119 57,454.20 6/ 1/2005 814,057.50 5.2102045 0.59533218 484,634.63 12/ 1/2005 75,337.50 5.2102045 0.58021693 43,712.09 6/ 1/2006 795,337.50 5.2102045 0.56548546 449,751.79 12/ 1/2006 56,437.50 5.2102045 0.55112801 31,104.29 6/ 1/2007 776,437.50 5.2102045 0.53713509 417,051.83 12/ 1/2007 37,537.50 5.2102045 0.52349745 19,650.79 6/ 1/2008 517,537.50 5.2102045 0.51020606 264,050.77 12/ 1/2008 24,937.50 5.2102045 0.49725213 12,400.23 6/ 1/2009 499,937.50 5.2102045 0.48462710 242,283.26 12/ 1/2009 12,468.75 5.2102045 0.47232262 5,889.27 6/ 1/2010 487,468.75 ------------ 5.2102045 0.46033053 224,396.75 ------------ SUBTOTAL 13,994,826.46 9,993,605.95 RUNDATE: 04-11-1995 @ 13:39:36 FILENAME: AMES KEY: 95