TIF District Analysis
<br />= Actual Values
<br />= Cells that can be modified
<br />Res AV %
<br />Comm AV %
<br />7.96%
<br />29%
<br />Assumptions:
<br />Organic Value Growth 2%
<br />Mill Levy 84.450 84.450 85.187 85.187 85.187 85.187 85.187 85.187 85.187 85.187 85.187 85.187 85.187 85.187
<br />Includ
<br />Tax Year as of January 1
<br />Year Tax paid
<br />Assessed Value Base
<br />Assessed Value Total
<br />y + DELO Res
<br />y + DELO Comm
<br />y + DELO Phase 2 Res
<br />y + DELO Phase 2 Comm
<br />y + Safeway
<br />y + Arnold
<br />y + North End Res
<br />y + North End Comm
<br />y +TEBO
<br />2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024
<br />2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025
<br />28,987,934 29,567,693 30,159,046 30,762,227 31,377,472 32,005,021 32,645,122 33,298,024 33,963,985 34,643,264
<br />33,643,446 35,574,889 41,577,096 44,933,344 51,942,662 54,343,598 56,222,653 57,753,066 58,908,127 60,086,289
<br />1,253,700 1,253,700 3,363,100 - - - - - -
<br />- 1,216,234 - - - - - -
<br />28,724,674
<br />29,413,479
<br />29,466,021
<br />30,235,128
<br />28,853,950
<br />31,139, 814
<br />28,419,543
<br />32,983,771
<br />835,896 2,871,570 - - -
<br />194,662 623,460 547,335 378,650 -
<br />398,000 636,800 1,026,840 788,040 788,040 398,000 398,000
<br />424,900
<br />Total Assessed Value plus Projects 29,413,479 30,235,128 31,139,814 32,983,771 34,877,342 40,761,859 44,052,298 50,924,178 53,278,037 55,120,248 56,620,653 57,753,066 58,908,127 60,086,289
<br />Total TIF Assessed Value
<br />TIF Revenue
<br />Prior Year Fund Balance
<br />688,805 769,107 2,285,864 4,564,228 5,889,409 11,194,167 13,893,252 20,161,951 21,900,565 23,115,226 23,975,531 24,455,041 24,944,142 25,443,025
<br />58,170 64,951 194,726 388,813 501,701 953,597 1,183,524 1,717,536 1,865,643 1,969,117 2,042,404 2,083,252 2,124,917 2,167,415
<br />157,759
<br />Expenditure Assumptions
<br />% Growth of Admin Costs 3%
<br />% payback to City for Underpass 25%
<br />Underpass contribution $ 1,300,000
<br />Underpass Interest 0.650%
<br />County Payment % 7.15%
<br />Expenditures
<br />Professional Services - Investment Fees
<br />Professional Services -Other
<br />Admin & Ops - Current GF Labor Costs
<br />Admin & Ops - Prior LRC Liability
<br />Bond Maintenance Fees
<br />Core Project Area Bond Repayment
<br />Tract One Rebate*
<br />Regional Detention Facility Capital Contribution
<br />County Payment
<br />Underpass Commitment
<br />Total Expenditures
<br />Yearly Revenue Exceeding Expenditures
<br />Ending Fund Balance
<br />Underpass Interest
<br />Balance of Underpass Contribution
<br />Total to Underpass by Year
<br />47.85% 16.50% 10.80% 8.62% 4.67%
<br />3.88% 2.75%
<br />2.61% 2.55%
<br />2.53% 2.55%
<br />2.58% 2.60%
<br />20 20 30 50 20 20 20 20 20 20 20 20 20 20
<br />31,120 31,080 32,130 42,000 43,260 44,558 45,895 47,271 48,690 50,150 51,655 53,204 54,800 56,444
<br />32,630 32,460 3,770 - - - - - -
<br />1,500
<br />89,115 184,638 449,616 459,585 469,217 644,318 657,024 669,979 683,187
<br />125,000 130,000 125,000
<br />325,000
<br />27,800 35,872 68,182 84,622 122,804 133,394 140,792 146,032 148,952 151,932 154,970
<br />45,000 65,000 75,000 263,252 386,865 420,890 76,187 - - - -
<br />63,770 63,560 35,930 441,350 269,152 406,875 703,427 1,006,577 1,062,579 736,367 842,025 859,201 876,731 894,622
<br />(52,537) 232,549 546,722 480,098 710,960 803,065 1,232,750 1,200,379 1,224,051 1,248,186 1,272,793
<br />(5,600) 1,391 158,796 105,222 232,549 546,722 480,098 710,960 803,065 1,232,750 1,200,379 1,224,051 1,248,186 1,272,793
<br />8,158 7,788 7,351 5,688 3,210 -
<br />$ 1,300,000 $ 1,255,000 $ 1,198,158 $ 1,130,946 $ 875,045 $ 493,867 $ 76,187 $ - $ - -
<br />45,000
<br />110,000 185,000
<br />*Assumes Safeway increment is received in the Year budgeted (may be different than specified in TIF Rebate Agreement)
<br />10
<br />448,252 835,117
<br />1,256,007 1,332,195
<br />1,332,195 1,332,195
<br />1,332,195 1,332,195
<br />
|