|
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
<br />Mill Levy
<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 />+ BOOM
<br />y +TEBO
<br />2%
<br />84.450
<br />84.450
<br />85.187
<br />2011
<br />2012
<br />2012
<br />2013
<br />2013
<br />2014
<br />85.187
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />83.387
<br />2014
<br />2015
<br />2015
<br />2016
<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 />37,803,464
<br />44,334,564
<br />2016
<br />2017
<br />38,559,533
<br />45,221,255
<br />626,850
<br />2017 2018
<br />2018 2019
<br />39,330,724 40,117,338
<br />47,414,603 53,412,059
<br />626,850 3,840,700
<br />1,216,234
<br />2,871,570
<br />636,800 1,026,840
<br />424,900
<br />194,662
<br />788,040
<br />630,300
<br />2019
<br />2020
<br />40,919,685
<br />61,283,634
<br />623,460
<br />788,040
<br />630,300
<br />2020
<br />2021
<br />41,738,079
<br />64,591,943
<br />547,335
<br />398,000
<br />2021 2022
<br />2022 2023
<br />42,572,840 43,424,297
<br />66,848,024 68,875,116
<br />278,600
<br />398,000
<br />2023
<br />2024
<br />44,292,783
<br />70,252,618
<br />2024
<br />2025
<br />45,178,639
<br />71,657,671
<br />2025
<br />2026
<br />46,082,212
<br />73,090,824
<br />2026
<br />2027
<br />47,003,856
<br />74,552,641
<br />Total Assessed Value plus Projects
<br />Total TIF Assessed Value
<br />TIF Revenue
<br />Prior Year Fund Balance
<br />29,413,479 30,235,128 31,139,814 32,983,771 44,334,564 46,484,905
<br />688,805 769,107 2,285,864
<br />58,170 64,951 194,726
<br />Expenditure Assumptions
<br />% Growth of Admin Costs
<br />% payback to City for Underpass
<br />Underpass contribution
<br />Underpass Interest
<br />County Payment %
<br />3%
<br />25%
<br />$ 1,300,000
<br />0.650%
<br />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 />Funding for Other Projects
<br />Underpass Commitment
<br />47.85%
<br />16.50%
<br />4,564,228
<br />388,813
<br />6,531,100
<br />544,609
<br />157,759
<br />522,718
<br />10.80%
<br />6.09%
<br />20
<br />20
<br />30
<br />50
<br />200
<br />31,120
<br />32,630
<br />31,080
<br />32,460
<br />32,130
<br />3,770
<br />42,000
<br />33,180
<br />1,500
<br />6,500
<br />325,000
<br />27,800
<br />45,000
<br />Total Expenditures
<br />Yearly Revenue Exceeding Expenditures
<br />Ending Fund Balance
<br />of Revenue
<br />Underpass Interest
<br />Balance of Underpass Contribution
<br />Total to Underpass by Year
<br />63,770
<br />63,560
<br />35,930
<br />441,350
<br />91,200
<br />40,200
<br />200,000
<br />65,000
<br />436,280
<br />(52,537) 108,329
<br />7,925,372
<br />660,873
<br />631,047
<br />5.17%
<br />200
<br />34,175
<br />52,866
<br />130,000
<br />47,252
<br />300,000
<br />75,000
<br />52,364,763 60,081,995 63,325,434 65,537,278 67,524,624 68,875,116 70,252,618 71,657,671 73,090,824 74,552,641
<br />13,034,039
<br />1,086,869
<br />3.24%
<br />20
<br />35,201
<br />113,079
<br />125,000
<br />77,711
<br />450,000
<br />243,489
<br />19,964,656 22,405,749 23,799,199 24,951,783 25,450,819 25,959,835 26,479,032 27,008,613 27,548,785
<br />1,664,793 1,868,348 1,984,544 2,080,654 2,122,267 2,164,713 2,208,007 2,252,167 2,297,211
<br />2.18%
<br />20
<br />36,257
<br />438,512
<br />119,033
<br />600,000
<br />377,376
<br />2.00%
<br />20
<br />37,344
<br />447,695
<br />133,587
<br />700,000
<br />424,354
<br />1.94%
<br />20
<br />38,465
<br />457,055
<br />141,895
<br />1,100,000
<br />102,295
<br />1.90%
<br />20
<br />39,619
<br />626,249
<br />148,767
<br />1,000,000
<br />1.92%
<br />20
<br />40,807
<br />638,644
<br />151,742
<br />1,050,000
<br />1.94%
<br />20
<br />42,031
<br />651,283
<br />154,777
<br />1,000,000
<br />1.96%
<br />20
<br />43,292
<br />664,170
<br />157,873
<br />1,100,000
<br />1.98%
<br />2.00%
<br />20 20
<br />44,591 45,929
<br />677,311 690,711
<br />161,030 164,251
<br />1,150,000 1,200,000
<br />639,493
<br />21,380
<br />(5,600) 1,391 158,796 105,222 631,047 652,426
<br />-10% 2% 82% 27% 116% 99%
<br />1,044,500
<br />42,370
<br />1,571,198 1,743,000
<br />93,595
<br />125,348
<br />694,796 788,391 913,739
<br />64% 47% 49%
<br />8,158 7,788 7,351 5,816 3,401
<br />$ 1,300,000 $ 1,255,000 $ 1,198,158 $ 1,130,946 $ 894,807 $ 523,248 $ 102,295 $
<br />45,000
<br />110,000
<br />*Assumes Safeway increment is received in the Year budgeted (may be different than specified in TIF Rebate Agreement)
<br />185,000
<br />428,489
<br />805,865 1,230,219
<br />1,839,729
<br />144,814
<br />1,058,553
<br />53%
<br />1,332,514
<br />1,814,655
<br />266,000
<br />1,881,213 1,848,111
<br />241,054
<br />316,602
<br />1,324,553 1,565,607 1,882,209
<br />64% 74% 87%
<br />1,332,514
<br />1,332,514 1,332,514
<br />1,965,355
<br />242,652
<br />2,124,861
<br />96%
<br />1,332,514
<br />2,032,952 2,100,910
<br />219,215
<br />196,300
<br />2,344,076 2,540,376
<br />104% 111%
<br />1,332,514 1,332,514
<br />
|