|
Home2 Suites - No Inflation
<br /> FREERS City of Ramsey, MN
<br /> (Z'Z98 Room Hotel
<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% 40% Increment Value Yrs. Year Date
<br /> - - - 02/01/25
<br /> 100% 71,035 (5,486) 65,549 95.108% 62,343 31,171 (112) (12,424) 18,635 17,737 0.5 2025 08/01/25
<br /> 31,171 (112) (12,424) 18,635 35,042 1 2025 02/01/26
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 70,221 1.5 2026 08/01/26
<br /> 64,951 (234) (25,887) 38,830 104,541 2 2026 02/01/27
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 138,025 2.5 2027 08/01/27
<br /> 64,951 (234) (25,887) 38,830 170,691 3 2027 02/01/28
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 202,561 3.5 2028 08/01/28
<br /> 64,951 (234) (25,887) 38,830 233,654 4 2028 02/01/29
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 263,988 4.5 2029 08/01/29
<br /> 64,951 (234) (25,887) 38,830 293,583 5 2029 02/01/30
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 322,455 5.5 2030 08/01/30
<br /> 64,951 (234) (25,887) 38,830 350,624 6 2030 02/01/31
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 378,105 6.5 2031 08/01/31
<br /> 64,951 (234) (25,887) 38,830 404,916 7 2031 02/01/32
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 431,073 7.5 2032 08/01/32
<br /> 64,951 (234) (25,887) 38,830 456,593 8 2032 02/01/33
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 481,489 8.5 2033 08/01/33
<br /> 64,951 (234) (25,887) 38,830 505,779 9 2033 02/01/34
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 529,476 9.5 2034 08/01/34
<br /> 64,951 (234) (25,887) 38,830 552,595 10 2034 02/01/35
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 575,150 10.5 2035 08/01/35
<br /> 64,951 (234) (25,887) 38,830 597,155 11 2035 02/01/36
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 618,624 11.5 2036 08/01/36
<br /> 64,951 (234) (25,887) 38,830 639,569 12 2036 02/01/37
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 660,002 12.5 2037 08/01/37
<br /> 64,951 (234) (25,887) 38,830 679,938 13 2037 02/01/38
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 699,387 13.5 2038 08/01/38
<br /> 64,951 (234) (25,887) 38,830 718,362 14 2038 02/01/39
<br /> 100% 142,070 (5,486) 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 736,874 14.5 2039 08/01/39
<br /> 64,951 (234) (25,887) 38,830 754,935 15 2039 02/01/40
<br /> 100% 142,070 (5,486) - 136,584 95.108% 129,903 64,951 (234) (25,887) 38,830 772,555 15.5 2040 08/01/40
<br /> 64,951 (234) (25,887) 38,830 789,746 16 2040 02/01/41
<br /> Total 2,010,880 (7,239) (801,456) 1,202,185
<br /> Present Value From 08/01/2024 Present Value Rate 5.00% 1,320,998 (4,756) (526,497) 789,746
<br />
|