|
8/30 • Tax Increment Cashflo e 3
<br /> EHLERS
<br /> & ASSOCIATES INC
<br /> Presbyterian Homes
<br /> City of Arden Hills
<br /> 152 Senior Apartments and 50 Rental Brownstones
<br /> TAX INCREMENT CASH FLOW
<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% 10% Increment Value Yrs. Year Date
<br /> - - _ - 08/01/12
<br /> - - - - 02/01/13
<br /> 100% 76,000 (100,455) - (24,455) 105% (25,784) (12,892) 46 1,285 (11,561) (10,541) 0.5 2013 08/01/13
<br /> (12,892) 46 1,285 (11,561) (20,763) 1 2013 02/01/14
<br /> 100% 142,500 (100,455) - 42,045 105% 44,329 22,165 (80) (2,208) 19,876 (3,721) 1.5 2014 08/01/14
<br /> 22,165 (80) (2,208) 19,876 12,804 2 2014 02/01/15
<br /> 100% 236,875 (100,455) - 136,420 105% 143,831 71,916 (259) (7,166) 64,491 64,798 2.5 2015 08/01/15
<br /> 71,916 (259) (7,166) 64,491 115,216 3 2015 02/01/16
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 180,905 3.5 2016 08/01/16
<br /> 96,626 (348) (9,628) 86,651 244,604 4 2016 02/01/17
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 306,373 4.5 2017 08/01/17
<br /> 96,626 (348) (9,628) 86,651 366,270 5 2017 02/01/18
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 424,352 5.5 2018 08/01/18
<br /> 96,626 (348) (9,628) 86,651 480,674 6 2018 02/01/19
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 535,289 6.5 2019 08/01/19
<br /> 96,626 (348) (9,628) 86,651 588,249 7 2019 02/01/20
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 639,604 7.5 2020 08/01/20
<br /> 96,626 (348) (9,628) 86,651 689,403 8 2020 02/01/21
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 737,693 8.5 2021 08/01/21
<br /> 96,626 (348) (9,628) 86,651 784,519 9 2021 02/01/22
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 829,927 9.5 2022 08/01/22
<br /> 96,626 (348) (9,628) 86,651 873,959 10 2022 02/01/23
<br /> 1006/ 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 916,656 10.5 2023 08/01/23
<br /> 96,626 (348) (9,628) 86,651 958,059 11 2023 02/01/24
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 998,208 11.5 2024 08/01/24
<br /> 96,626 (348) (9,628) 86,651 1,037,140 12 2024 02/01/25
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 1,074,893 12.5 2025 08/01/25
<br /> 96,626 (348) (9,628) 86,651 1,111,501 13 2025 02/01/26
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 1,147,000 13.5 2026 08/01/26
<br /> 96,626 (348) (9,628) 86,651 1,181,424 14 2026 02/01/27
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 1,214,804 14.5 2027 08/01/27
<br /> 96,626 (348) (9,628) 86,651 1,247,172 15 2027 02/01/28
<br /> 100% 283,750 (100,455) - 183,295 105% 193,253 96,626 (348) (9,628) 86,651 1,278,560 15.5 2028 08/01/28
<br /> 96,626 (348) ((9,628) 86,651 1,308,997 16 2028 02/01/29
<br /> otal 2,674 662, (9,629) -(2 6,503 . 2,398,530
<br /> r - ; ,-Present Value Prom 02/01/2012' Present Value Rate'. :.6.25% .. 'r' 1,459,696 (5,255) -(145,444) ; `1)308,997
<br /> Prepared by Ehlers&Associates,Inc.-Estimates Only N\Minnsota\Arden Hills\Housing-Economic-Redevelopment Pending Projects\Pres Homes and LibrarylRenovadon Renewal TIF run 8.31.2010.xls
<br />
|