|
9/10/2015
<br />EHLERS
<br />t5hota5n! PM; 'Mang
<br />PSD Apartments - No Inflation
<br />City of Ramsey
<br />122 Market Rate Apartments
<br />TAX INCREMENT CASH FLOW
<br />Tax Increment Cashflow - Page 3
<br />Project Original Fiscal Captured Local Annual Semi -Annual State Admin. Semi -Annual Semi -Annual PERIOD
<br />of Tax Tax Disparities Tax Tax Gross Tax Gross Tax Auditor at Net Tax Present ENDING Tax Payment
<br />OTC Capacity Capacity Incremental Capacity Rate Increment Increment 0.36% 15% Increment Value Yrs. Year Date
<br />- - 02/01/17
<br />- - 08/01/17
<br />- - - - 02/01/18
<br />125,313 108.410% 135,852 67,926 (245) (10,152) 57,529 53,148 0.5 2018 08/01/18
<br />67,926 (245) (10,152) 57,529 105,254 1 2018 02/01/19
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 174,558 1.5 2019 08/01/19
<br />92,152 (332) (13,773) 78,047 242,503 2 2019 02/01/20
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 309,115 2.5 2020 08/01/20
<br />92,152 (332) (13,773) 78,047 374,422 3 2020 02/01/21
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 438,448 3.5 2021 08/01/21
<br />92,152 (332) (13,773) 78,047 501,218 4 2021 02/01/22
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 562,758 4.5 2022 08/01/22
<br />92,152 (332) (13,773) 78,047 623,091 5 2022 02/01/23
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 682,241 5.5 2023 08/01/23
<br />92,152 (332) (13,773) 78,047 740,231 6 2023 02/01/24
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 797,084 6.5 2024 08/01/24
<br />92,152 (332) (13,773) 78,047 852,823 7 2024 02/01/25
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 907,468 7.5 2025 08/01/25
<br />92,152 (332) (13,773) 78,047 961,042 8 2025 02/01/26
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,013,566 8.5 2026 08/01/26
<br />92,152 (332) (13,773) 78,047 1,065,060 9 2026 02/01/27
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,115,544 9.5 2027 08/01/27
<br />92,152 (332) (13,773) 78,047 1,165,038 10 2027 02/01/28
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,213,561 10.5 2028 08/01/28
<br />92,152 (332) (13,773) 78,047 1,261,134 11 2028 02/01/29
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,307,773 11.5 2029 08/01/29
<br />92,152 (332) (13,773) 78,047 1,353,498 12 2029 02/01/30
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,398,326 12.5 2030 08/01/30
<br />92,152 (332) (13,773) 78,047 1,442,276 13 2030 02/01/31
<br />170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,485,363 13.5 2031 08/01/31
<br />92,152 (332) (13,773) 78,047 1,527,606 14 2031 02/01/32
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,569,021 14.5 2032 08/01/32
<br />92,152 (332) (13,773) 78,047 1,609,623 15 2032 02/01/33
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,649,429 15.5 2033 08/01/33
<br />92,152 (332) (13,773) 78,047 1,688,455 16 2033 02/01/34
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,726,716 16.5 2034 08/01/34
<br />92,152 (332) (13,773) 78,047 1,764,226 17 2034 02/01/35
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,801,001 17.5 2035 08/01/35
<br />92,152 (332) (13,773) 78,047 1,837,055 18 2035 02/01/36
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,872,402 18.5 2036 08/01/36
<br />92,152 (332) (13,773) 78,047 1,907,055 19 2036 02/01/37
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 1,941,030 19.5 2037 08/01/37
<br />92,152 (332) (13,773) 78,047 1,974,338 20 2037 02/01/38
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 2,006,993 20.5 2038 08/01/38
<br />92,152 (332) (13,773) 78,047 2,039,008 21 2038 02/01/39
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 2,070,395 21.5 2039 08/01/39
<br />92,152 (332) (13,773) 78,047 2,101,166 22 2039 02/01/40
<br />100% 178,774 (8,768) - 170,007 108.410% 184,304 92,152 (332) (13,773) 78,047 2,131,334 22.5 2040 08/01/40
<br />92,152 (332) (13,773) 78,047 2,160,911 23 2040 02/01/41
<br />Total 4,190,542 (15,086) (626,318) 3,549,138
<br />Present Value From 08/01/2016 Present Value Rate 4.00% 2,551,433 (9,185) (381,337) 2,160,911
<br />100% 134,081 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />100% 178,774 (8,768)
<br />Prepared by Ehlers & Associates, Inc. - Estimates Only N:\Minnsota\Ramsey\Housing - Economic - Redevelopment \TIF\TIF Districts\TIF District No. 14- COR\COR\TIF Runs\TIF Run 9-1-15 - PSD Apartments
<br />
|