|
Attachment B 13
<br /> Co ms o,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
<br /> Gvangr:ll'vanait Plan Scenario ti.'ompairfs®n
<br /> The information shown s current as of the time of distribution.This information s preliminary and subject to change based upon ongoing d iso nn one with and updates by Gofriangle.
<br /> 1 Scenario V=1 Cl .__. ._.28 V£4 M 33 73 7 40 VS RR .__.
<br /> 2
<br /> 3 Scenario Description Included In April 4th Scenario Requested for Under Consideration/ Under Consideration/
<br /> Davenport Presentation Draft 201.7 Orange Requested by Working Requested by Worlswig
<br /> Transit Plan Group Group
<br /> 4
<br /> 5 LIT Cost Shave Assumptions(Ducharm/Orange/Private)
<br /> 6 Grapnel Coot w,2/'1S 52/18 82./'16/2 815/1..65320
<br /> 7 Shared Borrowings S2/1S 82/1.8 S2/1S 81..5/1.8.5
<br /> Ope;rakons and Maintenance
<br /> 9 Through 2036 .__. 8(/r( .__. .__.80/2�0 I./19 80./�0 .__.
<br /> 10 After 2030 elate of Good Repair 80/20 50/90 8.1/.159 51../19
<br /> 1.1. .__. .__. .__. .__.
<br /> 12 Through 2.036 x,6/20 50/90 S:1/.1: 50/
<br /> (1 90
<br /> 13 After 2035 S /2 .__. .__.80/20 81/19 81/1 .__.
<br /> 1.4
<br /> 15 GUrbore Wake CRT a Scenario.P -.. ScenarioP .__.
<br /> 1.6
<br /> 17 LIT iffitiall Capital Cost
<br /> 1D F'TA IVew Starts(arrant.C apital Cots .._. .._. .._. .._. $ .._. 1.'1 14 984.214 $ .._.1.194)284 21.4 $ 1.894.284214. $ 1 1..94.184 914
<br /> 1.9 elate Funding Capital Costs -__ .__. .__. .__. __.. 2 8.856,843 .__. 38,853843 233856,643 238,6 x6,843
<br /> 20 In Wad Contributions
<br /> 21 Orange County 3487,75ff .__. 3p 87.758 -.. 4487,758 .__.3,534,640
<br /> 22 Durham County 15.8E8375 15.w88675 15,SSS.675 15.791 793
<br /> 23 Joint Development.Grant.^, .__. .__. .__. .__. .__. .__. .__. .__.
<br /> 24 Grange County 11.716.747 11.716.747 11 716.747 1,.042912
<br /> 2li Our harp County .__. .__. .__. .__. __.. 5,.376,790 .__. 53,,76,3..96 53376,290 53,050525.
<br /> 26' final`Share Pnvate Caplt al Campaign(First$131.2 rl'llliron Applied to Orange:CourAyl ..... ..... ..... ..... ..... 1£5 110.000 ...15.120,000
<br /> 27 Lethal Sham Orange County -__ .__. __. .__. 15377242222 .__. 156,772422 138,652,422 1.43,1017 212
<br /> 2H Local Share Durham County 714185.479 714. 85.479 714 185.479 709.830,690
<br /> 29 Total LRT Initial Capital Cost $__.. 388.568,428 $ .__.y 388,568428 $ 2„388.568,428 $ 2,388,x(afi,428
<br /> 30
<br /> 31.LIT redo iffitiall Capital and Borrowing Cost.
<br /> 32 F'TA IVew Starts Grant.Capita l rend Borrowing Costs ..... ..... ..... $ ..... 1.2391164.227 $ .....1.1.4.6:1:1240 $ 1...235417.397 $ 12:5.12661"1.
<br /> 33 Slate Funding Capital and Borrowing Costs -__ .__. .__. .__. 7457733,697 .__. 244,861.1.67 245,026,598 244,939,841.
<br /> 34 In Wad Contributions
<br /> 35 Orange County 3487,758 .__. 3487.758 -.. 4487,758 .__.3,534,640
<br /> 36 Durham County 15.FiE8375 15.w88675 15,SSS.075 15.791 793
<br /> 37 Jong Development.Grant.^, .__. .__. .__. .__. .__. .__. .__. .__.
<br /> 38 Grange County 11.716.747 11.716.747 11 716.747 1,.042112
<br /> 39 Our ha rn County 5,.376,290 53,,76,396 3376,290 53,050525
<br /> 40 final`Share Pnvate Caplt al Campaign(First$131.2 n'llliron Applied to Orange:County) ..... ..... ..... ..... ..... 1£5 110.000 ...15.120,000
<br /> 4.1 Local Share Orange County -__ .__. __. .__. ,11.931,!349 .__. 31.0,664.1.41. 292 663,152 301,1 x47 5!5
<br /> 42 Local Share Durham County 1.421.011...800 .1.415.247.75: 1..41>790.365 1.,406.983,067
<br /> 43 Total LRT Initial Capital and Borrowing Cost -__ .__. .__. .__. $ 3,302.320,443 $ .__. 89342770 $ 3291497,054 $ 3,290,69 x,51.5.
<br /> 44
<br /> 45 Grange County LIP State of Good Repair through 20112
<br /> 46' Cash Funding .._. .._. .._. .._. .._. .._. $ .._. >:x 652.485 $ .._. 22.682.4E5 $ .._. 17,945.360 $ 1 7.94£5 360
<br /> 47 Debt Funding .__. .__. .__. .__. __.. 44.000.00(7 .__. 72.00(7.000 72,000,000 ...72!000,000.
<br /> 48 Interest.and Borrowing Costs 3916326 10.77'11..1.5 10)773.1i 10.773115
<br /> 49 Total State at Goods Refrain $ 93598,511 $ .__. 105,453603 $ __.101017,1.,478 $ 100,727.,478
<br /> 50
<br /> 131 tither Orange County Tax CDV:sthof Funding through 2045
<br /> 52 Bus O&M f 1119.760.380 $ 1.9.66912.59 f 1.39669259 $ 1.:9.661'259...
<br /> 53 DO LET.f. .__. .__. .__. .__. $ 8&.270.664 $ .__. 88.27(7.664 $ 3d 857.1.30 $ ...85.6 x7.,778.
<br /> ¢34 Bu.,Facilities and Capital Projects(Inrludini Replacements) $ 7.501.643 $ S.059.476 $ 8,059476 $ S.059,476'
<br /> E5E5 Vehicles(Including Replacements).__ .__. .__. .__. $ 14.168348 $ .__. 14,247.696 $ -..14,247,696 $ 14,147,696.
<br /> 230 Iry BRT Project(Constructon Costs) $ 6.1.25.000 $ 6825.000 $ 6,1.25.000 $ 6.1.25,000
<br /> 237 Hillsborough Train Station Project(Construction Costs) $ 686,666 $ 653000 $ 686,000 $ 686,000
<br /> lib
<br /> 59 Grange County belles Tax Aseaure faf ores
<br /> 60 FY 201.7.2046 Moody,Baseline: Moodys Baseline Moody's Paseirne Moody's Baseline
<br /> 61. FY 2047.2062 4.33%, .__. .__...71%, .__. 3.7130 3.71.% .__.
<br /> 62
<br /> 63 Grange County Financing.Aseaureptfiores
<br /> 64 Locally Funded lOBs-InIf.•eLRT .._. .._. .._. .._. .._. $ .._. 659.000.000 $ .._. 67.500.000 $ .._. 72,500.000 $ 71.1x00,000
<br /> 65 Grant Funded I_)ff.-Irnfatal 6(1.300,000 .__. 60,800.000 -...55,800,000 57,350,000
<br /> 663' TIFIA Loan Inlf el I..RT 77.400.000 77.400.000 77,400.000 79.550,000
<br /> 67 I_ocaily Funded ICBs-State at Good Repair .__. .__. .__. __.. 44.000,000 .__. 72,000.000 72,000,000 ...72,000,000.
<br /> 68 Total Orange County Financing.. .._. .._. .._. .._. .._. $ .._. 2°50.700.660 $ .._. 177.160.000 $ .._277,700.000 $ 281.400,000.E
<br /> o.5 .__. .__. .__. .__. .__. .__. .__. .__. .__. .__.
<br /> 70 Reserve)Assumptions
<br /> 71 Cash Balance Maintain Positive Maintain Positive Maintain Positive Maintain Positive
<br /> Balance Balance Balance ['Balance
<br /> 72 Op;ratmg Reserve 3Mrmih.,/25%of 3 Months/95%of 3Monihs/2b'/of 3 Months/15%of
<br /> CH/OPT Bus 0&M CH/OPT Bus O&M CH/OPT h..s 0&M CH/OFF Bus Ol
<br /> 73 Debt Service Reserve 100 of Debt issued 10'%of Debt Issued 10%of Debt Issued 100%of Debt Issued
<br /> 74
<br /> Ili Financial l-Ie ft Criteria
<br /> 76 IWnimurn Aggregate.D'CR LOBS(Initial RTl 1.17x 1 19x 1 1.£5x 1..18x
<br /> 77 Minimum Aggrnga Le DSCR Grant Funded LOBS(Initial LRi) 1.28x 134x 1..27x 1.31x
<br /> 7H IWnimurn Aggregate.D'CR TIFIA&Staate,of Good Rcepair 1 21x 6 18x 1 0£5x 1..07x
<br /> 79 Minirnurn Cash Balance During Construction-Orange(Fiscal Year) .__. .__. /1.2168,03(21.1. A . 7.303(2027) $4,990.825(2019)._. $4,362,360(201.9)__.
<br /> HO IWnimurn Cash Balance:After Construrton-Orange.(Fiscal Year) $21:x715(1045) $1.041870(1030) $19.57831. (1030) $1h.53.375(20)2;7)_
<br /> H1. Minmmnurn Cash Balance During Construction-Our harp(Fiscal Year) $34,983247(2021) $7,673391(2027) /3.669,460(2025) $3,427,523(2021)
<br /> £S2 IWnim urn Cash Balance After Construction Durham(Fiscal Year) .._. .._. $72.484154(10'19) $5'1.45..435(9029) $1820.398(2035)_. $['.4)1.0,091(1035)._
<br /> Davenport&Company LLC 1 18:49 1 4/19/2017
<br />
|