|
3/17/2016
<br />25C -38
<br />EXHIBIT E
<br />Cities Share of Max Construction Costs
<br />30,000,000.00
<br />Additional Funding
<br />Cost Rate
<br />0.77%
<br />Number of Payments
<br />$779,966.51
<br />40
<br />Payments
<br />Quarterly Payment Schedule
<br />N Payments '
<br />Period
<br />Beginning
<br />Balance
<br />Payment
<br />Cities Share
<br />MCC
<br />of
<br />Additional
<br />Funding Cost
<br />Cumulative
<br />Cities Share of
<br />MCC -
<br />Cumulative.
<br />Additional'
<br />Funding Cost
<br />Ending Balance
<br />5 Year Average *. (%)
<br />1
<br />10/1/2016
<br />_
<br />30,000,000.00
<br />$779,966.81
<br />722,216.81
<br />57,750.00
<br />29,277,783.19
<br />2
<br />1/1/2017
<br />29,277,783.19
<br />779,966.81
<br />723,607.09
<br />56,359.73
<br />723,607.08
<br />28,554,176.11
<br />3
<br />4/1/2017
<br />28,554,176.11
<br />779,966.81
<br />725,000.02
<br />54,966.79
<br />1,445,607.10
<br />_56,359.73
<br />111,326.52
<br />27,829,17_6.09
<br />4
<br />7/1/2017
<br />27,829,176.09
<br />779,966.81
<br />726,395.65
<br />53,571.16
<br />2,175,002.75
<br />164,897.68
<br />27,102,780.44
<br />5
<br />10/1/2017
<br />27,102,780.44
<br />779,966.81
<br />727,793.96
<br />52,17185
<br />2,902,796.71
<br />217,070.53
<br />_ 26,374,986.48
<br />6
<br />1/1/2018
<br />26,374,986.48
<br />779,966.81
<br />729,194.96
<br />50,771.85
<br />3,631,991.67
<br />267,842.38
<br />25,645,791.52
<br />�^ 7
<br />4/1/2018
<br />25,645,791.52
<br />779,966.81
<br />730,598.66
<br />49,36815
<br />4,362,590.33
<br />317,210.53
<br />24,915,192.86
<br />8
<br />7/1/2018
<br />24,915,192.86
<br />779,966.81
<br />732,005.06
<br />47,96175
<br />5,094,595.39
<br />365,172.28
<br />24,183,157.80
<br />9
<br />10/1/2018
<br />24,183,187.80
<br />779,966.81
<br />733,414.17
<br />46,55164
<br />5,528,009.56
<br />411,724.92
<br />23,449,773.63
<br />10
<br />1/1/2019
<br />23,449,773.63
<br />779,966.81
<br />734,826.00
<br />4_5,140.81
<br />6,562,835.56
<br />456,865.73
<br />22,714,947.63
<br />11
<br />4/1/2019
<br />22,714,947.63
<br />779,966.81
<br />736,240.54
<br />43,726.27
<br />7,299,076.10
<br />500,592.00
<br />21,978,707.09
<br />_12
<br />7/1/2019
<br />21,978,707.09
<br />77_9,966.81
<br />737,657.80
<br />42,309.01
<br />8,036,73190
<br />542,901.01
<br />21,241,049.29
<br />13
<br />10/1/2019
<br />21,241,049.29
<br />779,966.81
<br />739,077.79
<br />_
<br />40,889.02
<br />5,775,811.69
<br />583,790.03
<br />20,501,971.50
<br />14
<br />1/1/2020
<br />20,501,971.50
<br />779,966.81
<br />740,500.51
<br />9,5_16,31120
<br />623,256.33
<br />19,761,470.99
<br />15
<br />4/1/2020
<br />779,966.81
<br />741,925.98
<br />_39,466.30
<br />38,040.83
<br />10,258,_238.18
<br />661,297.16
<br />19,019,545.01
<br />/1/202_0
<br />_19,761,470.99
<br />19,019,545.01
<br />779,966.81
<br />743,354.19
<br />36,612.62
<br />11,001,592.37
<br />697,909.78
<br />18,276,190.82
<br />0/1/2020
<br />18,276,190.82
<br />779,966.81
<br />744,785.14
<br />35,181.67
<br />11,746,377.51
<br />733,091.45
<br />17,531,405.68
<br />1/1/2021
<br />17,531,405.68
<br />779,966.81
<br />746,218.85
<br />33,747.96
<br />12,492,596.36
<br />766,839.41
<br />16,785,156.83
<br />/1/2021
<br />16,785,186.83
<br />779,966.81
<br />747,655.33
<br />32,311.48
<br />13,240,251.69
<br />799,150.89
<br />~16,037,531.50
<br />/1/2021
<br />16,037,531.50
<br />779,966.81
<br />749,094.56
<br />30,872.25
<br />13,989,346.25
<br />830,023.14
<br />15,288,436.94
<br />0/1/2021
<br />15,288,436.94
<br />779,966.81
<br />750,536.57
<br />29,430.24
<br />14,739,882.82
<br />14,537,900.37
<br />1/1/2022
<br />14,537,900.37
<br />779,966.81
<br />751,981.35
<br />27,985.46
<br />15,491,864.17
<br />_859,453.38
<br />887,438.84
<br />13,785,919.02
<br />_
<br />/1/2022
<br />E
<br />13,785,919.02
<br />779,966.81
<br />753,425.92
<br />26,537.89
<br />16,245,293.09
<br />913,976.73
<br />13,032,490.10
<br />7/1/2022
<br />13,032,490.10
<br />779,966.81
<br />754,879.27
<br />25,087.54
<br />17,000,172.36
<br />939,064.27
<br />12,277,610.83
<br />0/1/2022
<br />12,277,610.83
<br />779,966.81
<br />756,332.41
<br />23,634.40
<br />17,756,504.77
<br />962,698.67
<br />11,521,278.42
<br />1/1/2023
<br />11,521,278.42
<br />779,966.51
<br />757,788.35
<br />22,178.46
<br />18,514,293.12
<br />984,877.13
<br />10,763,490.07
<br />4/1/2023
<br />10,763,490.07
<br />779,966.81
<br />759,247.09
<br />20,719.72
<br />19,273,540.21
<br />1,005,596.85
<br />10,004,242.98
<br />7/1/2023
<br />10,004,242.98
<br />779,966.81
<br />760,708.64
<br />19,258.17
<br />20,034,248.85
<br />1,024,855.02
<br />9,243,534.34
<br />0/1/2023
<br />9,243,534.34
<br />779,966.81
<br />762,173.01
<br />17,793.80
<br />20,796,421.86
<br />1,042,648.82
<br />8,481,361.33
<br />1/1/2024
<br />8,481,361.33
<br />779,966.81
<br />763,640.19
<br />16,326.62
<br />21,560,062.05
<br />1,058,975.44
<br />7,717,721.14
<br />4/1/2024
<br />7,717,721.14
<br />779,966.81
<br />765,110.20
<br />14,856.61
<br />22,325,172.25
<br />1,073,832.05
<br />6,952,610.94
<br />32
<br />7/1/2024
<br />6,952,610.94
<br />779,966.81
<br />766,583.03
<br />13,383.78
<br />23,091,755.28
<br />1,087,215.83
<br />6,186,027.91
<br />33
<br />10/1/2024
<br />6,186,027.91
<br />768,058.71
<br />11,908.10
<br />23,859,813.99
<br />1,099,123.93
<br />5,417,969.20
<br />34
<br />1/1/2025
<br />5,417,969.20
<br />_779,966.81
<br />779,966.81
<br />_
<br />769,537.22
<br />_
<br />10,429.59
<br />24,629,351.21
<br />1,109,553.52
<br />4,648,431.95
<br />35
<br />4/1/2025
<br />4,645,431.98
<br />779,966.81
<br />771,018.58
<br />8,948.23
<br />25,400,369.79
<br />1,118,501.75
<br />3,877,413.40
<br />36
<br />7/1/2025
<br />3,877,413.40
<br />779,966.81
<br />772,502.79
<br />7,464.02
<br />26,172,872.58
<br />1,125,965.77
<br />3,104,910.61
<br />37
<br />10/1/2025
<br />779,966.81
<br />773,989.86
<br />5,976.95
<br />26,946,862.44
<br />1,131,942.72
<br />2,330,920.75
<br />38
<br />1/1/2026
<br />_3,104,910.61
<br />779,966.81
<br />775,479.79
<br />4,487.02
<br />27,722,342.23
<br />1,136,429.74
<br />1,555,440.96
<br />39
<br />4/1/20261
<br />_2,330,920.75
<br />1,555,440.96
<br />779,966.81
<br />776,972.59
<br />2,994.22
<br />28,499,314.82
<br />1,139,423.96
<br />778,4_6837
<br />40
<br />7/1/20261
<br />778,468.37
<br />779,966.81
<br />778,468.26
<br />1,498.55
<br />29,277,783.08
<br />1,140,922.51
<br />0.11
<br />TOTAL
<br />31,198,672.40
<br />29,999,999.89
<br />1,198,672.51
<br />3/17/2016
<br />25C -38
<br />
|