|
DeLo Project - Scenario 2
<br />Revenue Projections
<br />coreietbn
<br />Year
<br />DELO & TEBO Development
<br />1
<br />Revenue
<br />Apartments
<br />Completed
<br />155 Units DELO
<br />24 Units DELO -GoaM
<br />Residential
<br />Market
<br />Value
<br />$250,000 /Unit
<br />$250,000 /Unit
<br />Town
<br />Homes
<br />Completed
<br />60 Homes
<br />Residential
<br />Market
<br />Value
<br />$525000 /Home
<br />Per Home
<br />Residential
<br />Assessed
<br />Value
<br />7.96%
<br />Assessment Rate
<br />Commercial
<br />Square Feet
<br />1,800 5F Amenity Building
<br />8,o0o5F DELO -Tebo
<br />27,00051 DECO - Boots
<br />23,40051 DELO /DELO -Tebo
<br />Commercial
<br />Market Value
<br />$125 Value /5F
<br />$1sO Value /5F
<br />$150 Value /SF
<br />$150 /$125 Value /SF
<br />Assessed
<br />Value Base
<br />Commercial
<br />Assessed
<br />Value
<br />29000
<br />Assessment Rate
<br />Core Area
<br />Assessed
<br />Value Base
<br />Core Area
<br />Assessed
<br />Value
<br />Core Area
<br />AV Growth 3.00%
<br />Biennially
<br />Residential
<br />Assessed
<br />Value
<br />Commercial
<br />Assessed
<br />Value
<br />Growth From
<br />AV Base
<br />3.00%
<br />Biennially
<br />Cumulative
<br />Assessed
<br />Value
<br />Tax
<br />Collection
<br />Year
<br />Applicable
<br />Mill
<br />Levy
<br />8445
<br />Revenue
<br />Available
<br />For
<br />Project
<br />Annual
<br />Debt Servic e
<br />Annual
<br />Surplus
<br />Cumulative
<br />Surplus
<br />Mill
<br />Levy
<br />Revenue
<br />Revenue to Boulder County
<br />County Staff Underpass
<br />Payment Cost Reduction
<br />(1)
<br />(2)
<br />(3)
<br />(4)
<br />(5)
<br />161
<br />(7)
<br />(8)
<br />91
<br />(10)
<br />(11)
<br />(12)
<br />(13)
<br />(14)
<br />(15)
<br />(16)
<br />(174
<br />(18)
<br />(19)
<br />120)
<br />(21)
<br />(22)
<br />1231
<br />(74)
<br />(25)
<br />(26)
<br />(27)
<br />utl'nsl /uml
<br />7.15%
<br />aolHxxlNUHRaI
<br />Co lection I
<br />2012
<br />2013
<br />2014
<br />10
<br />$5,250,000
<br />$417,900
<br />($1,808,210)
<br />$1,808,210
<br />$157,500
<br />($157,500)
<br />($157,5031
<br />2015
<br />27
<br />6,750,000
<br />50
<br />26,250,000
<br />2,626,800
<br />25,200
<br />$3,360,000
<br />($873,973(
<br />$100,427
<br />($1,808,210(
<br />$1,808,210
<br />$315,000
<br />($315,000(
<br />($505,575(
<br />2016
<br />04
<br />21,000,000
<br />1,671,600
<br />35,000
<br />$4,950,000
<br />$1,435,500,
<br />($1,808,210(
<br />$1,808,210
<br />$54,246
<br />$417,900
<br />$0
<br />$472,146
<br />2016
<br />84.45
<br />$39,873
<br />(32,851)
<br />($5,968)
<br />($9,968)
<br />$21,086
<br />$315,000
<br />($293,914)
<br />($855,453)
<br />2017
<br />68
<br />17,000,000
<br />1,353,200
<br />50
<br />($1,808,210)
<br />31,808,210
<br />$0
<br />$2,626,800
<br />$100,427
<br />$3,199,373
<br />2017
<br />84.45
<br />$270,187
<br />(19,318)
<br />(9,556)
<br />($67,547)
<br />$173,766
<br />$460,000
<br />($286,234)
<br />($1,221,605)
<br />2018
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />355,874
<br />$1,671,600
<br />$1,435,500
<br />$94,354
<br />$6,456,701
<br />2018
<br />84.45
<br />$545,268
<br />(38,987)
<br />(10,895)
<br />($136,317)
<br />$359,070
<br />$459,850
<br />($100,780)
<br />($1,414,952)
<br />2019
<br />$0
<br />(31,808,210)
<br />31,808,210
<br />$0
<br />$1,353,200
<br />$D
<br />$D
<br />57,809,901
<br />2019
<br />84.45
<br />$659,546
<br />(47,158)
<br />(10,460)
<br />($164,887)
<br />$437,043
<br />$459,000
<br />($21,957)
<br />($1,537,493)
<br />2020
<br />$0
<br />(51,808,210)
<br />31,808,210
<br />$57,550
<br />$D
<br />$D
<br />5230,993
<br />58,098,444
<br />2020
<br />84.45
<br />$683,914
<br />(48,900)
<br />(10,013)
<br />(5170,978)
<br />$454,022
<br />$462,450
<br />($8,428)
<br />($1,654,135)
<br />2021
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />$0
<br />3D
<br />3D
<br />$D
<br />$8,098,444
<br />2021
<br />84.45
<br />$683,914
<br />(48,900)
<br />(4,904)
<br />$630,110
<br />$459,850
<br />$170,260
<br />(31,587,746)
<br />2022
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />$59,276
<br />3D
<br />$D
<br />$237,923
<br />38,395,644
<br />2022
<br />84.45
<br />$709,012
<br />(50,694)
<br />(4,810)
<br />$653,508
<br />$461,550
<br />$191,958
<br />($1,493,493)
<br />2023
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />$0
<br />3D
<br />3D
<br />$D
<br />38,395,644
<br />2023
<br />84.45
<br />$709,012
<br />(50,694)
<br />(4,773)
<br />$653,545
<br />$462,200
<br />$191,345
<br />($1,393,299)
<br />2024
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />$61,055
<br />$D
<br />$D
<br />$245,061
<br />58,701,759
<br />2024
<br />84.45
<br />$734,864
<br />(52,543)
<br />(4,738)
<br />$677,583
<br />3461,800
<br />$215,783
<br />($1,259,942)
<br />2D25
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />30
<br />$D
<br />$D
<br />$D
<br />58,701,759
<br />2025
<br />84.45
<br />$734,864
<br />(52,543)
<br />(4,707)
<br />$677,614
<br />$460,350
<br />$217,264
<br />($1,115,666)
<br />2D26
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />$62,886
<br />$D
<br />$D
<br />5252,413
<br />59,017,058
<br />2026
<br />84.45
<br />$761,491
<br />(54,447)
<br />(4,679)
<br />$702,365
<br />$462,850
<br />$239,515
<br />($937,482)
<br />2027
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />$0
<br />3D
<br />3D
<br />$D
<br />$9,017,058
<br />2027
<br />34.45
<br />$761,491
<br />(54,447)
<br />(4,725)
<br />$702,319
<br />3458,950
<br />$243,369
<br />($742,700)
<br />2028
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />364,773
<br />3D
<br />$D
<br />$259,985
<br />39,141,816
<br />2028
<br />34.45
<br />3788,916
<br />(56,408)
<br />(4,771)
<br />$727,738
<br />$464,000
<br />$263,738
<br />($512,490)
<br />2029
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />$0
<br />3D
<br />3D
<br />$D
<br />39,341,816
<br />2029
<br />34.45
<br />3788,916
<br />(56,408)
<br />(4,818)
<br />$727,691
<br />$462,300
<br />$265,391
<br />($264,396)
<br />2030
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />$66,716
<br />$D
<br />$D
<br />$267,785
<br />59,676,317
<br />2030
<br />34.45
<br />$817,165
<br />(58,427)
<br />(4,865)
<br />$753,872
<br />$459,200
<br />$294,672
<br />$30,276
<br />2031
<br />$0
<br />($1,808,210)
<br />31,808,210
<br />30
<br />$D
<br />$D
<br />$D
<br />59,676,317
<br />2031
<br />34.45
<br />$817,165
<br />(58,427)
<br />(4,913)
<br />$753,825
<br />$459,700
<br />$294,125
<br />$324,401
<br />2032
<br />$0
<br />($1,808,210)
<br />$1,808,210
<br />$68,718
<br />$D
<br />$D
<br />3275,818
<br />510,020,853
<br />2032
<br />34.45
<br />$846,261
<br />(60,508)
<br />(4,961)
<br />$780,792
<br />$463,450
<br />$317,342
<br />$641,743
<br />2033
<br />$0
<br />($1,808,210)
<br />$1,808,210
<br />$0
<br />3D
<br />3D
<br />$D
<br />510,020,853
<br />2033
<br />34.45
<br />$846,261
<br />(60,508)
<br />(4,961)
<br />$780,792
<br />$460,100
<br />$320,692
<br />$962,436
<br />Totals
<br />179
<br />$44,750,000
<br />60
<br />$31,500,000
<br />$6,069,500
<br />60,200
<br />$8,310,000
<br />$1,535,927
<br />I
<br />$496,848
<br />$1,864,332
<br />$12,198,119
<br />(372,166)1
<br />(109,515)1
<br />(549,697)
<br />310,666,741
<br />38,625,100
<br />Based on net cashflows shown on column 19,
<br />a 2014 bond issue could be structured as follows:
<br />$4,500,000
<br />$4,500,000 Estimated Funds Available for Project
<br />2033 Term
<br />7.00% Interest Rate
<br />$8,625,100 Total Repayment Cost
<br />$962,436 Surplus at End of 2033
<br />Par Amount of Bond Issue
<br />5/22/2014
<br />
|