Loading...
HomeMy WebLinkAboutHandouts_Workshop_Ex 04_08/14/2007• VILLAGE OF TEQUESTA GOVERNMENT-WIDE DEBT Fiscal /Budget Year Ending September 30, 2008 TABLE OF CONTENTS Summary Bonds: Tab 1994 Improvement Revenue Bonds ......................................................... 1 1998 Water Revenue Bonds .................................................................. 2 Notes Payable: 2002 Public Safety Facility Bank Loan ...................................................... 3 • 2004 Water Expansion Bank Loan .......................................................... 4 Capital Leases 2003 Fire Pumper .............................................................................. 5 2004 Chevrolet Tahoe ........................................................................ 6 2005 American Lafrance Medic Master Ambulance ........................................ 7 2006 800mghz Radios ........................................................................ 8 • 4-:1 • SUMMARY OF GOVERNMENT-WIDE TTnrT Outstanding_at Sep. 30, 2007 Bonds• 1994 Improvement Revenue Bonds $260,000 1998 Water Revenue Bonds 6 670 000 Subtotal of bonds $6,930,000 Notes Payable: C~ 2002 Public Safety Facility Bank Loan $4,118,052 2004 Water Expansion Bank Loan 437 952 Subtotal of notes payable $4,556,004 Capital Leases 2003 Fire Pumper $210,287.89 2004 Chevrolet Tahoe $8,572.91 2005 American Lafrance Medic Master Ambulance $87,708 2006 800mghz Radios 101 018 subtotal of capital leases $407,586.80 Total Debt $11,893,590.80 • C7 BOND 1994 IMPROVEMENT REVENUE BONDS • • Original Amount: • Interest Rate: • Term: 15 years • Outstanding @ September 30, 2007: $1,365,000 6.15% July 1994 -July 2009 $260,000 • • Village of Tequesta Improvement Revenue Refunding Bonds, Series 1994 Interest Rate of 6.15% date June 24, 1994, Maturing July 1, 2009 Interest paid each January 1st; P&I paid each July 1st as of September 30, 2007 REVENUE BONDS 6.15% Interest 1994 IMPROVEMENTREVENUE REFUNDING BONDS Principal Interest Payments Balance F/Y/E Sep 30: 260,000 2008 125,000 15,990 140,990 135,000 2009 135,000 8,303 143,303 - Total $ 260,000 $ 24,293 $ 284,293 Balance at September 30, 2007 is $260,000 This bond will mature July 1, 2009 • • • BOND 1998 WATER REVENUE BONDS • • Original Amount: • Interest Rate: • Term: 30 Years • Outstanding @ September 30, 2007: $7,915,00 3.8% to 5.125% March 1998 -March 2028 $6,670,000 1r 1 u • • Village of Tequesta 1998 Water Revenue Bonds Varying Interst rate of 3.8% to 5.125%, maturing March 1.2028 Balance Outstandin at September 30, 2007 REVENUE BONDS 3.8% TI 5.125% Interest 1998 WATER REVENUE BONDS Principal Interest Payments F!Y/E Sep 30: 2008 185,000.00 333,062.50 518,063 2009 195,000.00 324,415.00 519,415 2010 205,000.00 315,112.50 520,113 2011 215,000.00 305,135.00 520,135 2012 225,000.00 294,462.50 519,463 2013-2017 1,310,000 1,285,366 2,595,366 2018-2022 1,680,000 903,793 2,583,793 2023-2027 2,155,000 414,997 2,569,997 2028 500,000 12,813 512,813 Total S 6 670 000 S 4,189 156 $ 10,859 158 Less: Amort Disc (82,108) (82,108) Ba19130/2007 8,587,884 # 4,189,156 # 10,777,050 Total Princi al Interest Semi-annual Debt Service Mar-2008 185,000.00 168,612.50 353,612.50 Se -2008 164,450.00 164,450.00 Se -2008 518,062.50 Mar-2009 195,000.00 164,450.00 359,450.00 Sep-2009 159,965.00 159,965.00 Sep-2009 519,415.00 Mar-2010 205,000.00 159,965.00 364,965.00 Sep-2010 155,147.50 155,147.50 Nov-2009 520,112.50 Mar-2011 215,000.00 155,147.50 370,147.50 Sep-2011 149,987.50 149,987.50 Jan-2010 520,135.00 Mar-2012 225,000.00 149,987.50 374,987.50 Sep-2012 144,475.00 144,475.00 Mar-2010 519,462.50 Mar-2013 235,000.00 144,475.00 379,475.00 Sep-2013 138,600.00 138,600.00 May-2010 518,075.00 Mar-2014 250,000.00 138,600.00 388,600.00 Sep-2014 132,225.00 132,225.00 Jul-2010 520,825.00 Mar-2015 260,000.00 132,225.00 392,225.00 Sep-2015 125,562.50 125,562.50 Sep-2010 517,787.50 Mar-2016 275,000.00 125,562.50 400,562.50 Sep-2016 118,515.63 118,515.63 Nov-2010 519,078.13 Mar-2017 290,000.00 118,515.63 408,515.63 Sep-2017 111,084.35 111,084.35 Jan-2011 519,599.98 Mar-2018 305,000.00 111,084.35 416,084.39 Sep-2018 103,268.75 103,268.75 Mar-2011 519,353.14 Mar-2019 320,000.00 103,268.75 423,268.75 Sep-2019 95,068.75 95,068.75 May-2011 518,337.50 Mar-2020 335,000.00 95,068.75 430,068.75 Sep-2020 86,484.00 86,484.00 Jul-2011 516,552.75 Mar-2021 350,000.00 86,484.00 436,464.38 Sep-2021 77,515.63 77,515.63 Sep-2011 514,000.01 Mar-2022 370,000.00 77,515.63 447,515.63 Sep-2022 68,034.38 68,034.38 Nov-2011 515,550.01 Mar-2023 390,000.00 68,034.38 458,034.38 Sep-2023 58,040.63 58,040.63 Jan-2012 516,075.01 Mar-2024 410,000.00 58,040.63 468,040.63 Sep-2024 47,534.38 47,534.38 Mar-2012 515,575.01 Mar-2025 430,000.00 47,534.38 477,534.38 Sep-2025 36,515.63 36,515.63 May-2012 514,050.01 Mar-2026 450,000.00 36,515.63 486,515.63 Sep-2026 24,984.38 24,984.38 Jul-2012 511,500.01 Mar-2027 475,000.00 24,984.38 499,984.38 Sep-2027 12,812.50 12,812.50 Sep-2012 512,796.88 Mar-2028 500,000.00 12,812.50 512,812.50 Se -2028 Nov-2012 512,812.50 $ 6,670,000.00 4,189,155.52 15,613,353.44 $ 10,859,156 • NOTE PAYABLE 2002 PUBLIC SAFETY FACILITY BANK LOAN • • Original Amount: • Interest Rate: • Term: 20 Years • Outstanding @ September 30, 2007: $5,000,000 4.28% Sep. 2002 -Sep. 2022 $4,118,052 • • • • The Villlage of Tequesta $ 5,000,000 Note Payable, 4.28% Interest, M atures Sept. 20 22 Paid Monthly i n arrears from pledged and general revenues at Septem ber 30, 2007 NOTE PAYABLE 4.28% Interest 2002 Public Safe Facilit Bank Loan Term: 20 Years Beginning Year Ending Balance Principal Interest Total Payment End ing Balance 9/30/2003 $ 5,000,000 161,648.01 210,853 372,501 $ 4,838,352 9/30/2004 $ 4,838,352 168,703.89 203,798 372,501 $ 4,669,648 9/30/2005 $ 4,669,648 176,067.76 196,434 372,501 $ 4,493,580 9/30/2006 $ 4,493,580 183,753.06 188,748 372,501 $ 4,309,827 9/30/2007 $ 4,309,827 191,773.81 180,728 372,501 $ 4,118,053 9/30/2008 $ 4,118,053 200,144.68 172,357 372,501 $ 3,917,909 9/30/2009 $ 3,917,909 208,880.92 163,621 372,501 $ 3,709,028 9/30/2010 $ 3,709,028 217,998.50 154,503 372,501 $ 3,491,029 9/30/2011 $ 3,491,029 227,514.06 144,987 372,501 $ 3,263,515 9/30/2012 $ 3,263,515 237,445 135,057 372,501 $ 3,026,070 9/30/2013 $ 3,026,070 247,809 124,692 372,501 $ 2,778,261 9/30/2014 $ 2,778,261 258,626 113,875 372,501 $ 2,519,635 9/30/2015 $ 2,519,635 269,915 102,586 372,501 $ 2,249,720 9/30/2016 $ 2,249,720 281,697 90,805 372,501 $ 1,968,023 9/30/2017 $ 1,968,023 293,993 78,509 372,501 $ 1,674,030 9/30/2018 $ 1,674,030 306,825 65,676 372,501 $ 1,367,205 9/30/2019 $ 1,367,205 320,218 52,283 372,501 $ 1,046,986 9/30/2020 $ 1,046,986 334,196 38,306 372,501 $ 712,791 9/30/2021 $ 712,791 348,783 23,718 372,501 $ 364,007 9/30/2022 $ 364,007 364,007 8,494 372,501 $ 0 5,000,000 2,450,030 7,450,029 Payment Beginning Number Payment Date Balance Principal Interest Total Payment 1 10/13/02 $ 5,000,000 13,208 17,833 31,042 2 11/13/02 4,986,792 13,256 17,786 31,042 3 12/13/02 4,973,536 13,303 17,739 31,042 4 01/13/03 4,960,233 13,350 17,691 31,042 5 02/13/03 4,946,883 13,398 17,644 31,042 6 03/13/03 4,933,485 13,446 17,596 31,042 7 04/13/03 4,920,039 13,494 17,548 31,042 8 05/13/03 4,906,546 13,542 17,500 31,042 9 06/13/03 4,893,004 13,590 17,452 31,042 10 07/13/03 4,879,414 13,639 17,403 31,042 11 08!13/03 4,865,775 13,687 17,355 31,042 12 09/13/03 4,852,088 13,736 17,306 31,042 161,648 210,853 372,501 13 10/13/03 4,838,352 13,785 17,257 31,042 • 14 15 11/13/03 12/13/03 4,824,567 4,810,733 13,834 13,884 17,208 17,158 31,042 31,042 16 1/13/04 4,796,849 13,933 17,109 31,042 17 2/13!04 4,782,916 13,983 17,059 31,042 18 3/13/04 4,768,934 14,033 17,009 31,042 19 4/13/04 4,754,901 14,083 16,959 31,042 20 5/13/04 4,740,818 14,133 16,909 31,042 21 6/13/04 4,726,685 14,183 16,859 31,042 22 7/13/04 4,712,502 14,234 16,808 31,042 23 8/13/04 4,698,268 14,285 16,757 31,042 24 9/13/04 4,683,984 14,336 16,706 31,042 168,704 203,798 372,501 25 10/13/04 4,669,648 14,387 16,655 31,042 26 11/13/04 4,655,261 14,438 16,604 31,042 27 12/13/04 4,640,823 14,490 16,552 31,042 28 1/13/05 4,626,334 14,541 16,501 31,042 29 2/13/05 4,611,793 14,593 16,449 31,042 30 3/13/05 4,597,200 14,645 16,397 31,042 31 4/13/05 4,582,554 14,697 16,344 31,042 32 5/13/05 4,567,857 14,750 16,292 31,042 33 6/13/05 4,553,107 14,802 16,239 31,042 34 7/13/05 4,538,305 14,855 16,187 31,042 35 8/13/05 4,523,450 14,908 16,134 31,042 36 9/13/05 4,508,542 14,961 16,080 31,042 176,068 196,434 372,501 37 10/13/05 4,493,580 15,015 16,027 31,042 38 11/13/05 4,478,566 15,068 15,974 31,042 39 12/13/05 4,463,497 15,122 15,920 31,042 40 1/13/06 4,448,375 15,176 15,866 31,042 41 2/13/06 4,433,200 15,230 15,812 31,042 42 3/13/06 4,417,969 15,284 15,757 31,042 43 4/13/06 4,402,685 15,339 15,703 31,042 44 5/13/06 4,387,346 15,394 15,648 31,042 45 6/13/06 4,371,953 15,448 15,593 31,042 46 7/13/06 4,356,504 15,504 15,538 31,042 47 8/13/06 4,341,001 15,559 15,483 31,042 48 9/13/06 4,325,442 15,614 15,427 31,042 183,753 188,748 372,501 49 10/13/06 4,309,827 15,670 15,372 31,042 50 11/13/06 4,294,157 15,726 15,316 31,042 51 12/13/06 4,278,431 15,782 15,260 31,042 52 1/13/07 4,262,649 15,838 15,203 31,042 53 2/13/07 4,246,811 15,895 15,147 31,042 54 3/13/07 4,230,916 15,952 15,090 31,042 55 4/13/07 4,214,964 16,008 15,033 31,042 56 5/13/07 4,198,956 16,066 14,976 31,042 57 6/13/07 4,182,891 16,123 14,919 31,042 . 58 7/13/07 4,166,768 16,180 14,861 31,042 59 8/13/07 4,150,587 16,238 14,804 31,042 • 60 9/13/07 4,134,349 16,296 14,746 31,042 191,774 180,728 372,501 61 10/13/07 4,118,053 16,354 14,688 31,042 62 11/13/07 4,101,699 16,412 14,629 31,042 63 12/13/07 4,085,287 16,471 14,571 31,042 64 1/13/08 4,068,816 16,530 14,512 31,042 65 2/13/08 4,052,286 16,589 14,453 31,042 66 3/13/08 4,035,698 16,648 14,394 31,042 67 4/13/08 4,019,050 16,707 14,335 31,042 68 5/13/08 4,002,343 16,767 14,275 31,042 69 6!13/08 3,985,576 16,827 14,215 31,042 70 7/13/08 3,968,749 16,887 14,155 31,042 71 8/13/08 3,951,863 16,947 14,095 31,042 72 9/13/08 3,934,916 17,007 14,035 31,042 200,145 172,357 372,501 73 10/13/08 3,917,909 17,068 13,974 31,042 74 11/13/08 3,900,841 17,129 13,913 31,042 75 12/13/08 3,883,712 17,190 13,852 31,042 76 1/13/09 3,866,522 17,251 13,791 31,042 77 2/13/09 3,849,271 17,313 13,729 31,042 78 3/13/09 3,831,958 17,374 13,667 31,042 79 4/13/09 3,814,584 17,436 13,605 31,042 80 5/13/09 3,797,147 17,499 13,543 31,042 81 6/13/09 3,779,649 17,561 13,481 31,042 82 7/13/09 3,762,088 17,624 13,418 31,042 83 8/13/09 3,744,464 17,687 13,355 31,042 84 9/13/09 3,726,777 17,750 13,292 31,042 208,881 163, 621 372,501 85 10/13/09 3,709,028 17,813 13,229 31,042 86 11/13/09 3,691,215 17,876 13,165 31,042 87 12/13/09 3,673,338 17,940 13,102 31,042 88 1/13/10 3,655,398 18,004 13,038 31,042 89 2/13/10 3,637,394 18,068 12,973 31,042 90 3/13/10 3,619,326 18,133 12,909 31,042 91 4/13/10 3,601,193 18,198 12,844 31,042 92 5/13/10 3,582,995 18,262 12,779 31,042 93 6/13/10 3,564,733 18,328 12,714 31,042 94 7/13/10 3,546,405 18,393 12,649 31,042 95 8/13/10 3,528,012 18,459 12,583 31,042 96 9/13/10 3,509,554 18,524 12,517 31,042 217,999 154,503 372,501 97 10/13/10 3,491,029 18,590 12,451 31,042 98 11/13/10 3,472,439 18,657 12,385 31,042 99 12/13/10 3,453,782 18,723 12,318 31,042 100 1 /13/11 3,435,059 18,790 12,252 31,042 101 2/13/11 3,416,269 18,857 12,185 31,042 • 102 3/13/11 3,397,412 18,924 12,117 31,042 103 4/13/11 3,378,487 18,992 12,050 31,042 . 104 105 5/13/11 6/13/11 3,359,495 3,340,436 19,060 19,128 11,982 11,914 31,042 31,042 106 7/13/11 3,321,308 19,196 11,846 31,042 107 8!13/11 3,302,113 19,264 11,778 31,042 108 9/13/11 3,282,848 19,333 11,709 31,042 227,514 144,987 372,501 109 10/13/11 3,263,515 19,402 11,640 31,042 110 11 /13/11 3,244,113 19,471 11,571 31,042 111 12/13/11 3,224,642 19,541 11,501 31,042 112 1/13/12 3,205,102 19,610 11,432 31,042 113 2/13/12 3,185,491 19,680 11,362 31,042 114 3/13/12 3,165,811 19,750 11,291 31,042 115 4/13/12 3,146,061 19,821 11,221 31,042 116 5/13/12 3,126,240 19,892 11,150 31,042 117 6/13/12 3,106,348 19,962 11,079 31,042 118 7/13/12 3,086,386 20,034 11,008 31,042 119 8/13/12 3,066,352 20,105 10,937 31,042 120 9/13/12 3,046,247 20,177 10,865 31,042 237,445 135,057 372,501 121 10/13/12 3,026,070 20,249 10,793 31,042 122 11/13/12 3,005,822 20,321 10,721 31,042 123 12/13/12 2,985,500 20,394 10,648 31,042 124 1/13/13 2,965,107 20,466 10,576 31,042 125 2/13/13 2,944,641 20,539 10,503 31,042 126 3113/13 2,924,102 20,612 10,429 31,042 127 4/13/13 2,903,489 20,686 10,356 31,042 128 5/13/13 2,882,803 20,760 10,282 31,042 129 6/13/13 2,862,043 20,834 10,208 31,042 130 7/13/13 2,841,209 20,908 10,134 31,042 131 8/13/13 2,820,301 20,983 10,059 31,042 132 9/13/13 2,799,319 21,058 9,984 31,042 247,809 124,692 372,501 133 10/13/13 2,778,261 21,133 9,909 31,042 134 11/13/13 2,757,128 21,208 9,834 31,042 135 12/13/13 2,735,920 21,284 9,758 31,042 136 1/13/14 2,714,637 21,360 9,682 31,042 137 2/13/14 2,693,277 21,436 9,606 31,042 138 3/13/14 2,671,841 21,512 9,530 31,042 139 4/13/14 2,650,329 21,589 9,453 31,042 140 5/13/14 2,628,740 21,666 9,376 31,042 141 6/13/14 2,607,074 21,743 9,299 31,042 142 7/13/14 2,585,331 21,821 9,221 31,042 143 8/13/14 2,563,510 21,899 9,143 31,042 144 9/13/14 2,541,612 21,977 9,065 31,042 258,626 113,875 372,501 145 10/13/14 2,519,635 22,055 8,987 31,042 • 146 11/13/14 2,497,580 22,134 8,908 31,042 147 12/13/14 2,475,446 22,213 8,829 31,042 • 148 149 1/13/15 2/13/15 2,453,233 2,430,941 22,292 22,371 8,750 8,670 31,042 31,042 150 3/13/15 2,408,570 22,451 8,591 31,042 151 4/13/15 2,386,119 22,531 8,510 31,042 152 5/13/15 2,363,587 22,612 8,430 31,042 153 6/13/15 2,340,976 22,692 8,349 31,042 154 7/13/15 2,318,283 22,773 8,269 31,042 155 8/13/15 2,295,510 22,854 8,187 31,042 156 9/13/15 2,272,656 22,936 8,106 31,042 269,915 102,586 372,501 157 10/13/15 2,249,720 23,018 8,024 31,042 158 11/13/15 2,226,702 23,100 7,942 31,042 159 12/13/15 2,203,602 23,182 7,860 31,042 160 1/13/16 2,180,420 23,265 7,777 31,042 161 2/13/16 2,157,155 23,348 7,694 31,042 162 3/13/16 2,133,807 23,431 7,611 31,042 163 4/13/16 2,110,376 23,515 7,527 31,042 164 5/13/16 2,086,861 23,599 7,443 31,042 165 6/13/16 2,063,262 23,683 7,359 31,042 166 7/13/16 2,039,579 23,767 7,274 31,042 167 8/13/16 2,015,812 23,852 7,190 31,042 168 9/13/16 1,991,960 23,937 7,105 31,042 281,697 90,805 372,501 169 10/13/16 1,968,023 24,023 7,019 31,042 170 11/13/16 1,944,000 24,108 6,934 31,042 171 12/13/16 1,919,892 24,194 6,848 31,042 172 1/13/17 1,895,698 24,280 6,761 31,042 173 2/13/17 1,871,418 24,367 6,675 31,042 174 3/13/17 1,847,051 24,454 6,588 31,042 175 4/13/17 1,822,597 24,541 6,501 31,042 176 5/13/17 1,798,055 24,629 6,413 31,042 177 6/13/17 1,773,427 24,717 6,325 31,042 178 7/13/17 1,748,710 24,805 6,237 31,042 179 8/13/17 1,723,905 24,893 6,149 31,042 180 9/13/17 1,699,012 24,982 6,060 31,042 293,993 78,509 372,501 181 10/13/17 1,674,030 25,071 5,971 31,042 182 11/13/17 1,648,959 25,161 5,881 31,042 183 12/13/17 1,623,799 25,250 5,792 31,042 184 1/13/18 1,598,548 25,340 5,701 31,042 185 2/13/18 1,573,208 25,431 5,611 31,042 186 3/13/18 1,547,777 25,521 5,520 31,042 187 4/13/18 1,522,256 25,612 5,429 31,042 188 5/13/18 1,496,644 25,704 5,338 31,042 189 6/13/18 1,470,940 25,795 5,246 31,042 190 7/13/18 1,445,144 25,887 5,154 31,042 191 8/13/18 1,419,257 25,980 5,062 31,042 192 9/13/18 1,393,277 26,072 4,969 31,042 306,825 65,676 372,501 193 10/13/18 1,367,205 26,165 4,876 31,042 194 11 /13/18 1,341,039 26,259 4,783 31,042 195 12/13/18 1,314,781 26,352 4,689 31,042 196 1/13/19 1,288,428 26,446 4,595 31,042 197 2/13/19 1,261,982 26,541 4,501 31,042 198 3/13/19 1,235,441 26,635 4,406 31,042 199 4/13/19 1,208,806 26,730 4,311 31,042 200 5/13/19 1,182,075 26,826 4,216 31,042 201 6/13/19 1,155,249 26,921 4,120 31,042 202 7/13/19 1,128,328 27,017 4,024 31,042 203 8/13/19 1,101,311 27,114 3,928 31,042 204 9/13/19 1,074,197 27,210 3,831 31,042 320,218 52,283 372,501 205 10/13/19 1,046,986 27,308 3,734 31,042 206 11/13/19 1,019,679 27,405 3,637 31,042 207 12/13/19 992,274 27,503 3,539 31,042 208 1/13/20 964,771 27,601 3,441 31,042 209 2/13/20 937,170 27,699 3,343 31,042 210 3/13/20 909,471 27,798 3,244 31,042 211 4/13/20 881,673 27,897 3,145 31,042 212 5/13/20 853,776 27,997 3,045 31,042 213 6/13/20 825,779 28,097 2,945 31,042 214 7/13/20 797,683 28,197 2,845 31,042 215 8/13/20 769,486 28,297 2,745 31,042 216 9/13/20 741,189 28,398 2,644 31,042 334,196 38,306 372,501 217 10/13/20 712,791 28,500 2,542 31,042 218 11/13/20 684,291 28,601 2,441 31,042 219 12/13/20 655,690 28,703 2,339 31,042 220 1/13/21 626,987 28,806 2,236 31,042 221 2/13/21 598,181 28,908 2,134 31,042 222 3/13/21 569,273 29,011 2,030 31,042 223 4/13/21 540,262 29,115 1,927 31,042 224 5/13/21 511,147 29,219 1,823 31,042 225 6/13/21 481,928 29,323 1,719 31,042 226 7/13/21 452,605 29,427 1,614 31,042 227 8/13/21 423,178 29,532 1,509 31,042 228 9/13/21 393,645 29,638 1,404 31,042 348,783 23,718 372,501 229 10/13/21 364,007 29,743 1,298 31,042 230 11/13/21 334,264 29,850 1,192 31,042 231 12/13/21 304,414 29,956 1,086 31,042 232 1/13/22 274,458 30,063 979 31,042 233 2/13/22 244,395 30,170 872 31,042 234 3/13/22 214,225 30,278 764 31,042 235 4/13/22 183,948 30,386 656 31,042 236 5/13/22 153,562 30,494 548 31,042 237 6/13/22 123,068 30,603 439 31,042 238 7/13/22 92,465 30,712 330 31,042 • 239 8/13/22 61,753 30,822 220 31,042 240 9/13/22 30,931 30,931 110 30,931 364,007 8,494 372,501 • • • NOTE PAYABLE 2004 WATER EXPANSION BANK LOAN • • Original Amount: • Interest Rate: • Term: 20 Years • Outstanding @ September 30, 2007: $645,170 4.96%% May 2005 -May 2024 $437,952 • • • Water Expansion Loan Agreement dated June 30, 2004 x645,170 Bank of America Interest rate of 4.96%, Maturing May 1, 2024 as of September 30, 2007 Principal Interest Payments F/Y/E Sep 30: 2008 23,000 21,722 44,722 2009 24,000 19,004 43,004 2010 25,000 17,863 42,863 2011 26,000 16,672 42,672 2012 27,000 15,432 42,432 2013-2017 159,000 56,479 215,479 2018-2021 153,952 15,800 169,752 Total $ 437,952 $ 162,974 $ 600,926 2005 Prepayments 100,318 2006 Prepayments 35,427 2007 Prepayments 10,473 Total Prepayments 146,218 Amortizaiton Schedule for $645.170 2004 Note Payable Principal Interest Pre Pvnm[ Balance Year ending September 30: 645,170 2005 $ 20,000 $ 24,734 $ 100,318 $ 524,852 2006 20,000 26,430 $ 35,427 $ 469,425 2007 21,000 23,284 S 10,473 S 437,952 2008 23,000 21,722 414,952.45 2009 24,000 19,004 390,952.45 2010 25,000 17,863 365,952.45 2011 26,000 16,672 339,952.45 2012 27,000 15,432 312,952.45 2013 29,000 14,143 283,952.45 2014 30,000 12,804 253,952.45 2015 32,000 11,365 221, 952.45 2016 33,000 9,877 188,952.45 2017 35,000 8,290 153,952.45 2018 37,000 6,653 116,952.45 2019 39,000 4,917 77,952.45 2020 41,000 3,082 38,952.45 2021 43,000 1,148 2022 45,000 prepaid 2023 47,000 prepaid 2004 48,170 prepaid $ 645,170 $ 236,273 $ 146,218 Outstanding CrD. 913012007 437.952 CAPITAL LEASE 2003 FIRE PUMPER • Original Amount: • Interest Rate: • Term: 10 years • Outstanding @ September 30, 2007: $397,922 3.61 April 2003 - Apri12012 $210,287.89 • • • VILLAGE OF TEQUESTA Fiscal Year Ending September 30, 2007 3.610% Interest FIRE PUMPER The Village entered into a capital lease in the amount of $397,922 during February 2003 for the financing of a fire pumper. The applicable interest rate is 3.610% and interest and principal payments are due annually on April 15th. The lease expries on April 15, 2012. The following is a schedule of the future mimimum lease payments under this capital lease arrangement at September 30, 2007: Fiscal year ending September 30 2008 46,720 2009 46,720 2010 46,720 2011 46,720 2012 46,720 Total minimum lease payments 233,600 Less amount representing interest 23,312 Present value of future minimum lease payments $ 210,288 Fire Pumper Full Amortization Schedule Date Lease Payment Principal Interest Balance lease 2/13/03 397,922.01 1 4/15/03 46,720.05 44,285.98 2,434.07 353,636.03 2 4/15/04 46,720.05 33,953.79 12,766.26 319,682.24 3 4/15/05 46,720.05 35,179.52 11,540.53 284,502.72 4 4/15/06 46,720.05 36,449.50 10,270.55 248,053.22 5 4/15/07 46,720.05 37,765.33 8,954.72 210,287.89 6 4/15/08 46,720.05 39,128.66 7,591.39 171,159.23 7 4/15/09 46,720.05 40,541.20 6,178.85 130,618.03 8 4/15/10 46,720.05 42,004.74 4,715.31 88,613.29 9 4/15/11 46,720.05 43,521.11 3,198.94 45,092.18 10 4/15/12 46,720.05 45,092.18 1,627.87 - 397,922.01 69,278.49 • _ . ~- ~. _ ~ Prepared by: Date: ^~iReviewed by: • CAPITAL LEASE 2004 CHEVROLET TAHOE • Original Amount: • Interest Rate: • Term: 5 years • Outstanding @ September 30, 2007: $30,677.50 6.15% Dec. 2003 -Dec. 2008 $8572.91 • • CAPITAL LEASE COMMITMENTS VILLAGE OF TEQUESTA Fiscal Year Ending September 30, 2007 6.15% Interest FIRE - 2004 CHEVROLET TAHOE The Village entered into a capital lease in the amount of $30,677.50 during December 2003 for the financing of a 2004 Chevrolet Tahoe. The applicable interest rate is 6.15% with monthly principal and interest payments totaling $595.22. The lease expires on December 10, 2008. The following is a schedule of the future mimimum lease payments under this capital lease arrangement at September 30, 2006: Fiscal year ending September 30: 2008 7,143 2009 1,786 Total minimum lease payments 8,929 Less amount representing interest 356 Present value of future minimum lease payments $ 8,573 Fire -Chevrolet Tahoe - Full Amortization Schedule _~ lease Year 2004 i 6.15% Princiaal Interest Balance 30,677.50 30,239.50 29,799.26 29,356.76 28,911.99 28,464.94 28,015.60 27,563.96 27,110.01 26,653.73 1 Jan 438.00 157.22 2 Feb 440.24 154.98 3 Mar 442.50 152.72 4 Apr 444.77 150.45 5 May 447.05 148.17 6 Jun 449.34 145.88 7 Jul 451.64 143.58 8 Aug 453.95 141.27 9 Sep 456.28 138.94 4,023.77 1,333.21 2005 10 Oct 458.62 136.60 26,195.11 11 Nov 460.97 134.25 25,734.14 12 Dec 463.33 131.89 25,270.81 13 Jan 465.71 129.51 24,805.10 14 Feb 468.09 127.13 24,337.01 15 Mar 470.49 124.73 23,866.52 16 Apr 472.90 122.32 23,393.62 17 May 475.33 119.89 22,918.29 18 Jun 477.76 117.46 22,440.53 19 Jul 480.21 115.01 21,960.32 20 Aug 482.67 112.55 21,477.65 21 Sep 485.15 110.07 20,992.50 5,661.23 1,481.41 Prepared by: Date: ^~Reviewed by: • 2006 22 Oct 487.63 107.59 20,504.87 23 Nov 490.13 105.09 20,014.74 24 Dec 492.64 102.58 19,522.10 25 Jan 495.17 100.05 19,026.93 26 Feb 497.71 97.51 18,529.22 27 Mar 500.26 94.96 18,028.96 28 Apr 502.82 92.40 17,526.14 29 May 505.40 89.82 17,020.74 30 Jun 507.99 87.23 16,512.75 31 Jul 510.59 84.63 16,002.16 32 Aug 513.21 82.01 15,488.95 33 Sep 515.84 79.38 14,973.11 6,019.39 1,123.25 2007 34 Oct 518.48 76.74 14,454.63 35 Nov 521.14 74.08 13,933.49 36 Dec 523.81 71.41 13,409.68 37 Jan 526.50 68.72 12,883.18 38 Feb 529.19 66.03 12,353.99 39 Mar 531.91 63.31 11,822.08 40 Apr 534.63 60.59 11,287.45 41 May 537.37 57.85 10,750.08 42 Jun 540.13 55.09 10,209.95 43 Jul 542.89 52.33 9,667.06 44 Aug 545.68 49.54 9,121.38 45 Sep 548.47 46.75 8,572.91 6,400.20 742.44 2008 46 Oct 551.28 43.94 8,021.63 47 Nov 554.11 41.11 7,467.52 48 Dec 556.95 38.27 6,910.57 49 Jan 559.80 35.42 6,350.77 50 Feb 562.67 32.55 5,788.10 51 Mar 565.56 29.66 5,222.54 52 Apr 568.45 26.77 4,654.09 53 May 571.37 23.85 4,082.72 54 Jun 574.30 20.92 3,508.42 55 Jul 577.24 17.98 2,931.18 56 Aug 580.20 15.02 2,350.98 57 Sep 583.17 12.05 1,767.81 6,805.10 337.54 2009 58 Oct 586.16 9.06 1,181.65 59 Nov 589.16 6.06 592.49 60 Dec '592.49 3.04 - 1,767.50 18.16 Prepared by: Date: ^^Reviewed by: ._ .,:,~ C] CAPITAL LEASE 2005 AMERICAN LAFRANCE AMBULANCE CAPITAL LEASE • • Original Amount: • Interest Rate: • Term: 5 years • Outstanding @ September 30, 2007: $152,999 3.78% July 2005 -June 2010 $87,708 • C7 VILLAGE OF TEQUESTA Fiscal Year Ending September 30, 2007 CAPITAL LEASE COMMITMENTS FIRE -AMBULANCE The Village entered into a capital lease in the amount of $152,999.00 during July 2005 for the financing of a 2005 American Lafrance Medic Master ambulance. The applicable interest rate is 3.78% with monthly principal and interest payments totalling $2,802.55. The lease expires on June 3, 2010. The following is a schedule of the future mimimum lease payments under this capital lease arrangement at September 30, 2006: Fiscal year ending September 30 2008 33,631 2009 34,931 2010 25,223 Total minimum lease payments 93,784 Less amount representing interest 6,076 Present value of future minimum lease payments $ 87,708 • Fire -Ambulance -Amortization Schedule ~ 6.15% Year Principal Interest Balance Beg. Bal. 87,708.30 Oct 2007 2,526.27 276.28 85,182.03 Nov 2007 2,534.23 268.32 82,647.80 Dec 2007 2,542.21 260.34 80,105.59 Jan 2008 2,550.22 252.33 77,555.37 Feb 2008 2,558.25 244.30 74,997.12 Mar 2008 2,566.31 236.24 72,430.81 Apr 2008 2,574.39 228.16 69,856.42 May 2008 2,582.50 220.05 67,273.92 Jun 2008 2,590.64 211.91 64,683.28 Ju12008 2,598.80 203.75 62,084.48 Aug 2008 2,606.98 195.57 59,477.50 Sep 2008 2,615.20 187.35 56,862.30 30,846.00 2,784.60 ;~ Prepared by: Date: ^^Reviewed by: .7 r: • Oct 2008 2,623.43 179.12 54,238.87 Nov 2008 2,631.70 170.85 51,607.17 Dec 2008 2,639.99 162.56 48,967.18 Jan 2009 2,648.30 154.25 46,318.88 Feb 2009 2,656.65 1,445.90 43,662.23 Mar 2009 2,665.01 137.54 40,997.22 Apr 2009 2,673.41 129.14 38,323.81 May 2009 2,681.83 120.72 35,641.98 Jun 2009 2,690.28 112.27 32,951.70 Ju12009 2,698.75 103.80 30,252.95 Aug 2009 2,707.25 95.30 27,545.70 Sep 2009 2,715.78 86.77 24,829.92 32,032.38 2,898.22 Oct 2009 2,724.34 78.21 22,105.58 Nov 2009 2,732.92 69.63 19,372.66 Dec 2009 2,741.53 61.02 16,631.13 Jan 2010 2,750.16 52.39 13,880.97 Feb 2010 2,758.82 43.73 11,122.15 Mar 2010 2,767.52 35.03 8,354.63 Apr 2010 2,776.23 26.32 5,578.40 May 2010 2,784.98 17.57 2,793.42 June 2010 2,793.42 8.80 24,829.92 392.70 Prepared by: Date: ^^Reviewed by: CAPITAL LEASE 2006 POLICE 800MGHZ RADIOS • Original Amount: • Interest Rate: $136,789 4.38% • Term: 5 years May 2006 -Apr. 2011 • Outstanding @ September 30, 2007: $101,018 :7 • VILLAGE OF TEQUESTA Fiscal Year Ending September 30, 2007 CAPITAL LEASE COMMITMENTS 4.38% Interest Police Dept - 800mghz Radios The Village entered into a capital lease in the amount of $136,789 during May 2006 for the financing of 800 mhz radios for the police department. The applicable interest rate is 4.38% with monthly principal and interest payments totalling $2,542.70 The lease expires on April 21, 2011. The following is a schedule of the future mimimum lease payments under this capital lease arrangement at September 30, 2006: Fiscal year ending September 30: 2008 30,512 2009 30, 512 2010 30,512 2011 17, 799 Total minimum lease payments 109,336 Less amount representing interest 8,318 Present value of future minimum lease payments $ 101,018 PD - 800mghz Radios 4.38% Balance/ Year Principal Interest Price 101,018 Oct 2007 2,173.99 368.71 98,843.60 Nov 2007 2,181.92 360.78 96,661.68 Dec 2007 2,189.89 352.81 94,471.79 Jan 2008 2,197.88 344.82 92,273.91 Feb 2008 2,205.90 336.80 90,068.01 Mar 2008 2,213.95 328.74 87,854.06 Apr 2008 2,222.03 320.66 85,632.03 May 2008 2,230.14 312.55 83,401.89 Jun 2008 2,238.28 304.41 81,163.61 Ju12008 2,246.45 296.24 78,917.16 Aug 2008 2,254.65 288.04 76,662.51 Sep 2008 2,262.88 279.82 74,399.63 26,617.96 3,894.38 • Prepared by: Date: ^ ~ Reviewed by: Oct 2008 2,271.14 271.56 72,128.49 Nov 2008 2,279.43 263.27 69,849.06 Dec 2008 2,287.75 254.95 67,561.31 Jan 2009 2,296.10 246.60 65,265.21 Feb 2009 2,304.48 238.22 62,960.73 Mar 2009 2,312.89 229.80 60,647.84 Apr 2009 2,321.34 221.36 58,326.50 May 2009 2,329.81 212.89 55,996.69 Jun 2009 2,338.31 204.39 53,658.38 Ju12009 2,346.85 195.85 51,311.53 Aug 2009 2,355.41 187.28 48,956.12 Sep 2009 2,364.01 178.69 46,592.11 27,807.52 2,704.86 Oct 2009 2,372.64 170.06 44,219.47 Nov 2009 2,381.30 161.40 41,838.17 Dec 2009 2,389.99 152.71 39,448.18 Jan 2010 2,398.71 143.98 37,049.47 Feb 2010 2,407.47 135.23 34,642.00 Mar 2010 2,416.26 126.44 32,225.74 Apr 2010 2,425.08 117.62 29,800.66 May 2010 2,433.93 108.77 27,366.73 June 2010 2,442.81 99.89 24,923.92 Ju12010 2,451.73 90.97 22,472.19 Aug 2010 2,460.68 82.02 20,011.51 . Sep 2010 2,469.66 73.04 17,541.85 29,050.26 1,462.13 Oct 2010 2,478.67 64.03 15,063.18 Nov 2010 2,487.72 54.98 12,575.46 Dec 2010 2,496.80 45.90 10,078.66 Jan 2011 2,505.91 36.79 7,572.75 Feb 2011 2,515.06 27.64 5,057.69 Mar 2011 2,524.24 18.46 2,533.45 Apr 2011 2,533.45 9.25 0.00 17,541.85 257.05 • Prepared by: Date: ^C'Reviewed by: