|
Appendix: Impact of 33 Marrett Road on CPA Funds
<br /> (A) (B) (c) (o) (E) (F) (G) (H) (0 P)
<br /> Projected Revenue
<br /> Estimated
<br /> Resources at
<br /> Estimated FY2014 Current Resources 2013 ATM for
<br /> Revenue on Hand FY14 FY2015 FY2016 FY2017 FY2018 FY2019 FY2020 FY2021
<br /> (1) Property Surcharge $ 3,691,000 $ 3,820,185 $ 3,953,891 $ 4,092,278 $ 4,235,507 $ 4,383,750 $ 4,537,181 $ 4,695,983
<br /> (2) State Match' $ 961,957 $ 995,625 $ 1,030,472 $ 1,066,539 $ 1,103,867 $ 1,142,503 $ 1,182,490 $ 1,223,878
<br /> (3) Investment Income z $ 17,000 $ 17,595 $ 18,211 $ 18,848 $ 19,508 $ 20,191 $ 20,897 $ 21,629
<br /> (a) Undesignated Fund Balance 3 �$ -
<br /> (5) Total $ 4,669,957 $ 1,958,131 $ 6,628,088 $ 4,833,405 $ 5,002,574 $ 5,177,664 $ 5,358,883 $ 5,546,444 $ 5,740 r
<br /> Projected Claims Against Projected Revenue
<br /> (0) Open Space •.•.•.•.•.•:.•.•.•.•.•.•.•:.•.•.•.•.•.•.•.•.• $46,500 $ 483,341 $ 500,257 $ 517,766 $ 535,888 $ 554,644 $ 574,057 $ 594,149
<br /> (7) Historic Resources a'r:••••••••••••••••••••••••••••••••••••••••••••••••• $1,591,500 $ 483,341 $ 500,257 $ 517,766 $ 535,888 $ 554,644 $ 574,057 $ 594,149 m
<br /> (e) Community Housing :::::::::::::::::: :::::::::::::: ::::::::::::::::::: $622,734 $ 483,341 $ 500,257 $ 517,766 $ 535,888 $ 554,644 $ 574,057 $ 594,149
<br /> .............................
<br /> (s) Other Projects ':':':' :':':':':':' :':':':':':':':':' $367,500 $ 483,341 $ 500,257 $ 517,766 $ 535,888 $ 554,644 $ 574,057 $ 594,149
<br /> (10) Administrative Expenses',:::::::•:•:•:•....•:•:•:•:•....•:•:•:•:•:•:•:•:•:• $150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000
<br /> (11) 2,750,043 lTJ
<br /> Projected Debt Service-10 Year Term @ 4%
<br /> Amount ATM Action FY2014 FY2015 FY2016 FY2017 FY2018 FY2019 FY2020 FY2021 Q
<br /> (12) Wright Farm $ 2,950,000 2012 $ 36,875 $ 413,000 $ 401,200 $ 389,400 7 377,600 $ 365,800 $ 354,000 $ 342,200
<br /> (13) Potential Marrett Rd.Purchase° $ 7,390,000 2013 $ - $ 1,034,600 $ 1,005,040 $ 975,480 $ 945,920 $ 916,360 $ 886,800 $ 857,240 ,
<br /> (14) Potential Marrett Rd.D&E $ 949,531 2013 $ 132,934 $ 129,136 $ 125,338 $ 121,540 $ 117,742 $ 113,944 $ 110,146 �]
<br /> (15) Potential Marrett Rd.Construction $ 8,545,775 2014 ti \\\\\\\\ $ 1,196,409 $ 1,162,225 $ 1,128,042 $ 1,093,859 $ 1,059,676 $ 1,025,493
<br /> (10) Potential Cary Hall D&E $ 550,000 2013 PROPOSED FUNDING AT THE 2013 ATM FROM CASH ON HAND(included in C7 above)
<br /> (17) Potential Cary Hall Construction(including Contingency) $ 7,987,000 2014 TBD $ 1,118,180 $ 1,086,232 $ 1,054,284 $ 1,022,336 990,388 958,440 m
<br /> b
<br /> (1e) Potential Center Pools $ 1,200,000 2016 $ 168,000 $ 163,200 $ 158,400 $ 153,600
<br /> roject° Q
<br /> (1e) Potential Center Track P $ 2,400,000 2017 $ 336,000 $ 326,400 $ 316,800
<br /> (20) Total Projected Debt Service $ 36,875 $ 1,580,534 60:
<br /> (21) Residual Balance Net of Debt Service $ 3,812,979 1,169,509 $ (998,420) $ (782,077) $ (730,057) $ (837,431) $ (595,266) $ (349,025) tJ
<br /> (zz) Application of Residual Balances $ 3,812,979_ 3,984,067 $ 3,201,990 $ 2,471,934 $ 1,634,503 $ 1,039,237f NO
<br /> (z3)
<br />
|