|
MUNI Center Debt Internal Loan
<br />$1,000,000.00 PV
<br />NPV Beginning
<br />Interest
<br />Period
<br />Principal
<br />Remaining! Balan
<br />Payment Due
<br />5.00% Rate
<br />$969,757,00
<br />$19,395,14
<br />1
<br />$42,457.86
<br />$927,299.14
<br />20 Term
<br />Original for 2010 budget
<br />Sewer
<br />Fund. Loan Towards
<br />Muni Debt
<br />$43,307,02
<br />Payment NPV Beginning
<br />Interest
<br />Period
<br />Principal
<br />Remaining Bal ance
<br />Payment Due
<br />$80,243.00
<br />$1,000,000.00
<br />$50,000,00
<br />1
<br />$30,243.00
<br />$969,757.00
<br />1/1/2010
<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/2011
<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/2012
<br />$80,243,00
<br />$904,658.94
<br />$45,232.95
<br />4
<br />$35,010.05
<br />$8,69,648.89
<br />1/1/2013
<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/2014
<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/2015
<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/2016
<br />$80,243.00
<br />$753,761,24'
<br />$37,688.06
<br />8
<br />$42,554.94
<br />$711,206.30
<br />1/1/2017
<br />$80,243.00
<br />$711,206.30
<br />$35,560.32
<br />9
<br />$44,682.68
<br />$666,523.62
<br />1/1/2018
<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/2019
<br />$80,243.00
<br />$619,606.80
<br />$30,980.34
<br />11
<br />$49,262.66
<br />$570,344.14
<br />1/2/2020
<br />$80,243,00
<br />$570,344.14
<br />$28,517.21
<br />12
<br />$51,725.79
<br />$518,618.34
<br />1/1/2021
<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/2022
<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/2023
<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/2024
<br />.$80,243,00
<br />$347,399,50
<br />$17,369,98
<br />16
<br />$62,873.02
<br />$284,526.48
<br />1%1/2025
<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/2026
<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/2027
<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/2028
<br />$80,229,35
<br />$76,408,90
<br />$3,820.45
<br />20
<br />$76,408.90
<br />$0.00
<br />1/1/2029
<br />$604,846.35
<br />$1,000,000,00
<br />$969,757.00 PV .
<br />2.00% Rate
<br />20 Term For 2011 and forward budget Sewer Fund Loan Towards Muni Debt lower int due to economy
<br />Payment
<br />NPV Beginning
<br />Interest
<br />Period
<br />Principal
<br />Remaining! Balan
<br />Payment Due
<br />$61,853,00
<br />$969,757,00
<br />$19,395,14
<br />1
<br />$42,457.86
<br />$927,299.14
<br />1/1/2011
<br />$61,853,00
<br />$927,299.14
<br />$18,545.98
<br />2
<br />$43,307,02
<br />$883,992,12
<br />1/1/2012
<br />$61,853.00
<br />$883,992,12
<br />$17,679.84
<br />3
<br />$44,173,16'
<br />$839,818.97
<br />1/1/2013
<br />$61,853.00
<br />$839,818.97
<br />$16,796,38
<br />4
<br />$45,056,62
<br />$794;762,34
<br />1/1/2014
<br />$61,853,00.
<br />$794,762.34
<br />$15,895.25
<br />5
<br />$45,957,75
<br />$748,804,59.
<br />1/1/2015
<br />$61,853,00
<br />$748,804.59
<br />$14,976.09
<br />6
<br />$46,876.91
<br />$701,927,68
<br />1/1/2016
<br />$61,853,00
<br />$701,927.68
<br />$14,038,55
<br />- 7
<br />$47,814.45
<br />$654,113.24
<br />1/1/2017
<br />$61,853,00
<br />$654,113.24
<br />$13,082,26
<br />8
<br />$48,770,74
<br />$605,342.50
<br />1/1/2018
<br />$61,853,00
<br />$605,342.50
<br />$12,106,85
<br />9
<br />$49,746,15
<br />$5,55,596.35
<br />1/1/2099
<br />$61,853,00
<br />$555,596.35
<br />$11,111,93
<br />10
<br />$50,741.07
<br />$504,855,28
<br />1/1/2020
<br />$61,853,00
<br />$504,855.28
<br />$10,097.11
<br />11
<br />$51,755,89
<br />$453,099.38
<br />1/1/2021
<br />$61,853.00
<br />$453,099,38
<br />$9,061.99
<br />12
<br />$52,791.01
<br />$400,308.37
<br />1/1/2022
<br />$61,853.00
<br />$400,308.37
<br />$8,006,17
<br />13
<br />$53,846,83
<br />$346,461.54
<br />1/1/2023
<br />$61,853,00
<br />$346,461.54
<br />$6,929,23
<br />14
<br />$54,92317
<br />$291,537.77
<br />1/1/2024
<br />$61,853,00
<br />$291,537.77
<br />$5,830,76
<br />15
<br />$56,022,24
<br />$235,515,53
<br />111/2025
<br />$61,853,00
<br />$235,515.53
<br />$4,710.31
<br />16
<br />$57,142,69
<br />$178,372.84
<br />1/1/2026
<br />$61,853.00
<br />$178,372.84
<br />$3,567.46
<br />17
<br />$58,285.54
<br />$120,087.29
<br />1/1/2027
<br />$61,853,00
<br />$120,087.29
<br />$2,401.75
<br />18
<br />$59,451,25
<br />$60,636,04
<br />'1/1/2028
<br />$61,848.76
<br />$60,636.04
<br />$1,212.72
<br />19
<br />$60,636.04
<br />($0.00)
<br />1/1/2029
<br />$205,445.76
<br />$969,757.00
<br />
|