Agenda - 04-27-2017 - 1 - Consideration of the Final Draft Durham – Orange Light Rail Cost Sharing Agreement and Final Draft Orange County Transit Plan

Browse Search

91 Flow Details Page 1/3 *Cash flow is based on assumptions in Table 4.7-1 of the Durham Operating Revenues 2018 M = 2021 _ 2022 ` 2023' 2024 =2025 = 2026 2028 Sales Tax 26,914,101 28,579,624 30,664,248 32,519,299 33,626,774 34,830,245 36,592,160 38,338,310 39,783,898 41,069,131 42,385,733 43,920,662 Vehicle Rental Tax 1,166,764 1,220,435 1,274,134 1,327,648 1,383,409 1,438,745 1,496,295 1,553,154 1,627,705 1,705,835 1,787,715 1,873,525 $3 Vehicle Registration Fee 696,164 718,441 736,402 754,076 771,420 789,163 806,525 824,269 841,579 864,302 887,638 911,604 $7 Vehicle Registration Fee 1,624,470 1,676,453 1,718,364 1,759,605 1,800,076 1,841,478 1,881,991 1,923,395 1,963,786 2,016,808 2,071,262 2,127,186 Prior Year Cash Balance Restricted Operating 1,821,214 - - - - - - - - - - - Prior Year Cash Balance Unrestricted 50,494,796 82,717,509 32,194,953 34,393,148 36,360,628 37,581,679 38,899,631 40,776,971 42,639,128 44,216,968 45,656,076 47,132,348 48,832,977 Operating Expenses 2017 2018 2019 2020 2021 2022 �11MLE, 2025 2026 JR _ 2027 Allocations to Transit Providers for Bus O&M 3,821,281 3,965,821 4,294,536 4,597,881 4,734,401 4,874,129 5,018,027 5,165,300 5,316,955 5,472,164 5,637,873 5,808,613 Allocations to Transit Providers for Administration - 174,060 123,290 84,741 87,368 297,254 92,869 95,748 98,716 152,665 293,809 108,185 Allocations to Transit Providers for Bus Facilities O&M - 8,079 16,713 26,948 41,995 59,391 67,423 69,513 84,830 87,460 90,171 107,391 Allocation to GoTriangle for D-O LRT O&M - - - - - - - - - - - - Allocation to GoTriangle for CRT O&M 3,821,281 4,147,959 4,434,539 4,709,570 4,863,765 5,230,774 5,178,320 5,330,561 5,500,502 5,712,288 6,021,853 6,024,189 Deposit to Operating Reserve 634,628 108,514 23,240 22,500 22,952 23,407 24,092 24,568 25,284 25,780 28,002 28,844 Operating Revenues Remaining for Capital 78,261,600 27,938,480 29,935,369 31,628,557 32,694,962 33,645,450 35,574,559 37,283,999 38,691,183 39,918,007 41,082,493 42,779,944 Capital Revenues 1W M1W 2018 2019 _V 2020 �21 2028 Carryover 53,904,375 45,842,418 52,958,260 148,328,534 153,200,665 130,139,063 82,153,263 8,167,908 18,913,507 11,319,147 8,569,523 Prior Year Cash Balance Restricted Capital 1,412,067 Durham D-O LRT Spent,Pre-2017" 25,548,001 - - - - - - - - - - - OperatingRevenuesRemainingforCapital 78,261,600 27,938,480 29,935,369 31,628,557 32,694,962 33,645,450 35,574,559 37,283,999 38,691,183 39,918,007 41,082,493 42,779,944 Durham D-O LRT Federal FFGA Revenues - - - 81,500,000 81,500,000 81,500,000 81,500,000 81,500,000 81,500,000 81,500,000 81,500,000 81,500,000 Durham D-O LRT State Revenues - - 19,466,833 19,532,033 19,466,833 19,466,833 19,466,833 19,516,833 19,870,583 20,517,735 20,766,653 20,669,727 Durham D-O LRT LOB Proceeds - - - - - - - 50,000,000 - 70,000,000 - - Durham D-O LRT GAN Proceeds - - - - - - - - 203,750,000 13,000,000 48,900,000 - Durham D-O LRT TIFIA Proceeds - - - - - - 26,283,750 148,941,250 52,567,500 52,567,500 52,567,500 17,522,500 Durham Debt Service Reserve Release - - - - - - - - - - - 3,278,254 Durham Debt Service Reserve Interest Earnings - - - - - - 25,826 222,175 477,577 612,229 712,782 679,999 Durham CRT Federal FFGA Revenues - - - - - - - - - - - - In-Kind Donation(Right of Way) - - - 15,791,793 - - - - - - - - Local Grants for Joint Development 465,024 478,886 25,655,793 26,451,122 105,221,668 81,842,855 95,244,619 201,410,643 281,990,329 287,812,948 292,990,032 419,617,519 405,489,774 297,507,863 282,504,367 201,451,070 Capital Expenses 2020 2022 2024 jssmls� 2026 2027 2013 Allocations to Transit Providers for Vehicles - 3,622,934 2,164,189 - - - - - 676,621 455,412 244,264 - Durham County Bus Facilities and Capital Projects - 1,964,329 3,206,093 3,001,542 2,240,127 424,562 208,027 342,140 147,416 198,125 106,331 - State of Good Repair for D-O LRT - - - - - - - - - - - - CRT Project Cost 5,211,041 5,587,263 5,370,281 3,001,542 2,240,127 424,562 208,027 342,140 824,037 653,537 350,595 5,211,041 D-O LRT Project Costs(No Debt)• 51,317,293 30,413,175 36,916,078 49,428,567 126,549,537 157,249,322 208,046,123 390,972,633 344,399,991 249,315,440 189,624,403 112,450,708 Durham LOB Debt Service - - - - - - - - 13,774,502 13,774,502 27,127,835 27,127,835 Durham GAN Debt Service - - - - - - - - - 8,150,000 46,287,774 48,243,774 Durham TIFIA Debt Service - - - - - - - - - - - - Durham Debt Service Reserve Deposit - - - - - - 2,582,619 19,634,839 25,540,237 13,465,237 10,055,237 - Durham Cost of Issuance 652,000 500,000 2,037,500 830,000 489,000 51,317,293 30,413,175 36,916,078 50,080,567 126,549,537 157,249,322 210,628,742 411,107,472 385,752,230 285,535,180 273,584,250 187,822,318 Cumulative Fund Balance 2018 2020z" 2021 0 2022 _,M 2023 0 2024 � 2026 Ending Balance 53,904,375 45,842,418 52,958,260 148,328,534 153,200,665 130,139,063 82,153,263 8,167,908 18,913,507 11,319,147 8,569,523 8,417,711 .The D-O LRT Project cost shown in FY 2017 is a total of actual and budgeted expenditures for FY 2014 through FY 2017.Corresponding Tax District revenues spent to date are shown as revenues.