|
MUNI Center Debt Internal Loan
<br />$1,000,000,00 PV
<br />5,00% Rate
<br />20 Term Original for 2009 & 2010 budget Water Fund Loan Towards Muni Debt
<br />Payment
<br />NPV Beginning
<br />Interest .
<br />Period
<br />Principal
<br />Remaining Balance
<br />Payment Due
<br />$80,243.00
<br />$1,000,000,00
<br />$50,000.00
<br />1
<br />$30,243,00
<br />$9,69,757,00
<br />1/1/2009
<br />$80,243,00
<br />$969,757.00
<br />$48,487,85
<br />2
<br />$31,755,15
<br />$938,001.85
<br />1/1/2010
<br />$80,243.00
<br />$938,001.85
<br />$46,900.09
<br />3
<br />$33,342.91
<br />$904,658,94
<br />1/2/2011
<br />$80,243.00
<br />$904,658,94
<br />$45,232.95
<br />4
<br />$35,010.05
<br />$869,648,89
<br />1/2/2012
<br />$80,243,00
<br />$869,648.89
<br />$43,482,44
<br />5
<br />$36,760.56
<br />$832,888.33
<br />1/1/2013
<br />$80,243.00
<br />$832,888.33
<br />$41,644.42
<br />6
<br />$38,598,58
<br />$794,289,75
<br />1/1/2014
<br />$80,243.00
<br />$794,289,75
<br />$39,714.49
<br />7
<br />$40,528.51
<br />$753,761,24
<br />1/2/2015
<br />$80,243.00
<br />$753,761,24
<br />$37,688.06
<br />8
<br />$42,554.94
<br />$711,206.30
<br />1/2/2016
<br />$80,243.00
<br />$711,206.30
<br />$35,560.32
<br />9
<br />$44,682.68
<br />$6,66,523.62
<br />1/1/2017
<br />$80,243,00
<br />$666,523.62
<br />$33,326,18
<br />10
<br />$46,916.82
<br />$619,606.80
<br />1/1/2018
<br />$80,243,00
<br />$619,606.80
<br />$30,980.34
<br />11
<br />$49;262,66
<br />$5,70,344,14
<br />1/2/2019
<br />$80,243,00
<br />$570,344.14
<br />$28,517.21
<br />12
<br />$51,725.79
<br />$518,618.34
<br />1/2/2020
<br />$80,243.00
<br />$518,618,34
<br />$25,930.92
<br />13
<br />$54,312.08
<br />$464,306,26
<br />1/1/2021
<br />$80,243,00
<br />$464,306,26
<br />$23,215,31
<br />14
<br />$57,027,69
<br />$407,278,57
<br />1/1/2022
<br />'$80,243.00
<br />$407,278.57
<br />$20,363,93
<br />15
<br />.$59,879,07
<br />$347,399,50
<br />1/2/2023
<br />$80,243.00
<br />$347,399.50
<br />$17,369.98
<br />16
<br />$62,873.02
<br />$284,526,48
<br />1/2/2024
<br />$80,243,00
<br />$284,526.48
<br />$14,226.32
<br />17
<br />$66,016,68
<br />$218,509,80
<br />1/1/2025
<br />$80,243,00
<br />$218,509.80.
<br />$10,925.49
<br />18
<br />$69,317.51
<br />$149,192.29
<br />1/1/2026
<br />$80,243;00
<br />$149,192,29
<br />$7,459,61
<br />19
<br />$72,783.39
<br />$76,408,90
<br />1/2/2027
<br />$80;229.35
<br />$76,408.90
<br />$3,820.45
<br />20
<br />$76,408.90
<br />$0.00
<br />1/2/2028
<br />$604,846.35
<br />$1,000,000.00
<br />$938,001,85 PV
<br />2,00% Rate
<br />18 Term For 2011 and forward budget Water Fund Loan Towards Muni Debt lower int due to economy
<br />Payment
<br />NPV Beginning
<br />Interest
<br />Period
<br />Principal
<br />Remaining Balance
<br />Payment Due
<br />$61,853,00
<br />$938,001.85
<br />$18.,760.04
<br />1
<br />$43,092.96
<br />$894,908.89
<br />1/1/2011
<br />$61,853.00
<br />$894,908.89
<br />$17,898.18
<br />2
<br />$43,954.82
<br />$850,954.06
<br />1/1/2012.
<br />$61,853.00
<br />$850,954.06
<br />$17,019.08
<br />3
<br />$44,833.92
<br />'$8 06,120.15
<br />1/1/2013
<br />$61,853.00
<br />$806,120.15
<br />$16,122.40
<br />4
<br />$45,730.60
<br />'
<br />$7,389.55
<br />1/1/2014
<br />$61,853.00
<br />$760,389.55
<br />$15,207.79
<br />5
<br />$46,645.21
<br />$713,744.34.
<br />1/1/2015
<br />$61,853.00
<br />$713,744.34
<br />$14,274,89
<br />6
<br />$47,578.11
<br />$666,166.23
<br />1/1/2016
<br />$61,853.00
<br />$666,166.23
<br />$13,323.32
<br />7
<br />$48,629.08
<br />$6.17,636.55
<br />1/1/2017
<br />$61,853,00
<br />$617,636.55
<br />$12,352.73
<br />8
<br />$49,500.27
<br />$568,136.28
<br />1/1/2018
<br />$61,853,00
<br />$568,136.28
<br />$11,362.73
<br />9
<br />$50,490.27
<br />$517,646.01
<br />1/1/2019
<br />$61,853.00
<br />$517,646.01
<br />$10,352.92
<br />10
<br />$51,500.08
<br />$466,145.93
<br />1/1/2020
<br />$61,853.00
<br />$466,145,93
<br />$9,322.92
<br />11
<br />$52,530.08
<br />$413,615.85
<br />1/1/2021
<br />$61,853.00
<br />$413,615.85
<br />$8,272.32
<br />12
<br />$53,580,68
<br />$3.60,035.16
<br />1/1/2022
<br />$61,853.00
<br />$360,035.16
<br />$7,200.70
<br />13
<br />$54,652.30
<br />$305,382.87
<br />1/1/2023
<br />$61,853,00
<br />$305,382.87
<br />$6,107.66
<br />14
<br />$55,745.34
<br />$249,637.52
<br />1/1/2024
<br />$61;853.00
<br />$249,637.52
<br />$4,902,75
<br />15
<br />$56,860.25
<br />$192,777.27
<br />1/1/2025
<br />$61,853.00
<br />$192,777.27
<br />$3,855.55
<br />16
<br />$57,997.45
<br />$134,779.82
<br />1/1/2026
<br />$61,853.00
<br />$134,779.82
<br />$2,695.60
<br />17
<br />$59,157.40
<br />$75,622.42
<br />1/1/2027
<br />$77,134.86
<br />$75,622.42
<br />$1,512.45
<br />18
<br />$75,622.41
<br />$0.00
<br />1/1/2028
<br />$0.00
<br />19
<br />$0.00
<br />$0.00
<br />1/1/2029
<br />$190,634.01
<br />$938,001,85
<br />
|