|
Attachment 4 ^_
<br /> Debt Affordability Analysis ORANGE COUNTY
<br /> NORTH CAROLINA
<br /> Existing Debt
<br /> A B C D E F G H I J K L M N 0 P
<br /> Debt
<br /> Proposed CIP and CIP General Fund Federal Internal Rogers Road Revenue from Estimated
<br /> Existing Debt GO Referendum Operating Budgeted Debt QSCB Service Cost Sharing Total Revenues Surplus/ Prior Tax Equiv. Capital Reserve Adjusted Surplus/ Incremental Tax Capital Reserve
<br /> FY Service Debt Impact Total Service Subsidy' Vehicle Fund Agreement2 Available (Deficit) (Column 0) Utilized (Deficit) Equivalent Fund Balance
<br /> 2017 26,132,576 26,132,576 25,879,488 332,068 282,125 26,493,682 361,106 361,106 361,106
<br /> 2018 25,562,017 25,562,017 25,879,488 299,182 283,263 26,461,934 899,917 899,917 1,261,022
<br /> 2019 24,272,270 24,272,270 25,879,488 265,940 283,202 26,428,630: 2,156,360 2,156,360 3,417,383
<br /> 2020 22,926,315 22,926,315 25,879,488 232,697 285,422 26,397,608; 3,471,293 3,471,293 6,888,675
<br /> 2021 21,870,917 21,870,917 25,879,488 199,455 123,096 26,202,039: 4,331,122 4,331,122 11,219,797
<br /> 2022 21,117,095 21,117,095 25,879,488 166,212 122,451 26,168,152 5,051,057 5,051,057 16,270,854
<br /> 2023 16,592,626 16,592,626 25,879,488 132,970 122,760 26,135,218: 9,542,593 9,542,593 25,813,447
<br /> 2024 12,826,703 12,826,703 25,879,488 99,727 - 25,979,216; 13,152,513 13,152,513 38,965,960
<br /> 2025 9,597,322 9,597,322 25,879,488 66,485 25,945,973: 16,348,652 16,348,652 55,314,612
<br /> 2026 7,160,699 7,160,699 25,879,488 33,242 25,912,731 18,752,032 18,752,032 74,066,644
<br /> 2027 7,843,931 7,843,931 25,879,488 - 25,879,488 18,035,558 18,035,558 92,102,202
<br /> 2028 2,942,835 2,942,835 25,879,488 25,879,488 22,936,654 22,936,654 115,038,855
<br /> 2029 2,645,877 2,645,877 25,879,488 25,879,488 23,233,611 23,233,611 138,272,466
<br /> 2030 2,105,800 2,105,800 25,879,488 25,879,488 23,773,688 23,773,688 162,046,154
<br /> 2031 1,595,765 1,595,765 25,879,488 25,879,488 24,283,723 24,283,723 186,329,877
<br /> 2032 1,154,868 1,154,868 25,879,488 25,879,488 24,724,621 24,724,621 211,054,498
<br /> 2033 1,103,660 1,103,660 25,879,488 25,879,488 24,775,828 24,775,828 235,830,326
<br /> 2034 - - 25,879,488 25,879,488 25,879,488 25,879,488 261,709,815
<br /> 2035 - - - - 25,879,488 - - - 25,879,488: 25,879,488 - - 25,879,488 - 287,589,303
<br /> 2036 25,879,488 25,879,488; 25,879,488 25,879,488 313,468,791
<br /> 2037 25,879,488 25,879,488: 25,879,488 25,879,488 339,348,280
<br /> 2038 25,879,488 25,879,488; 25,879,488 25,879,488 365,227,768
<br /> 2039 25,879,488 25,879,488: 25,879,488 25,879,488 391,107,256
<br /> 2040 25,879,488 25,879,488; 25,879,488 25,879,488 416,986,745
<br /> 2041 25,879,488 25,879,488 25,879,488 25,879,488 442,866,233
<br /> 2042 25,879,488 25,879,488 25,879,488 25,879,488 468,745,721
<br /> 2043 25,879,488 25,879,488 25,879,488 25,879,488 494,625,210
<br /> Total Tax Effect 0.00
<br /> Tota l 207,451,276 207,451,2 76 Tota l
<br /> i Reduced 6.95/.and beyond due to Federal Sequestration
<br /> 2The County has an Interlocal Agreement with the Town of Chapel Hill and Town of Carrboro to repay 43%and 14%of the debt service associated with the Rogers Road portion of the County's 20171FC,respectively.
<br /> ■ FY 2018 Value of a Penny: $1,781,692
<br /> ■ Assumed FY 2019 & Beyond Growth Rate: 1.70%
<br /> DAVENPORT&COMPANY
<br /> June 13,2017 Orange County, NC 13
<br />
|