Orange County NC Website
Browse       Search
31 <br /> 1 Slide#17 <br /> Debt Model- Key Features <br /> straightforward update to Input C I P Detail Page cornprised of <br /> more than 140 County Capital Projects; <br /> Input Worksheet includes, Fiscal Year of Debt Issuance, <br /> Amortization Financing Period,and Interest Rate Assumptions; <br /> Output+ orksheet includes-,Debt Service to Revenue % Ratio. <br /> Total Debt to Assessed Value(Tax Base), Dash Surplus or Deficit <br /> and Tax Rate Requirements <br /> Reconciled to General Ledger, Financial Statements, Long-Term <br /> Operating Model & Comprehensive Model (28 Excel worksheets) <br /> ORANGE COUNTY <br /> 2 <br /> 3 <br /> 4 Gary Donaldson said that the model is very flexible for running different assumptions. <br /> 5 <br /> 6 Slide #18 <br /> Debt Model- CIP Detail Worksheet <br /> PFI0.RA WF 12?0): r0iU1A4ry f­ <br /> r§p 1,1W bu�r- <br /> } <br /> IFwftMaaeeAl UAFFr+n4Inwma"i[any0Wl s MAW F s M" 2lQY <br /> fi r1411,i,ulvt L 434.50 L s 431.SB6 2M <br /> 7 P.1m.r 1l—!w roc Fir lwvNioo L 3KOW % - # Famo M{ <br /> prl.l:r..„rc..:.lnllrr-vrrru a::n swll } �w�.�r� <br /> BF] CY—Jrn,rPl+il lrr}yrpl } omw % - s 5MAM 2027 <br /> JBrl hl,Ifpyf4YC L L.104AW L s 1.1154.0BP 2827 <br /> Jl ft1 I.w 11­F-FIr H— 4 3ir3." % - # FWAW 2027 <br /> 1'Fl.limn r ru•S� lr�Yrno 4�m�l % 311.114 % - # ...I —7 <br /> JJ n h ,",lry9 ny. } DIM F - s �R76 2L27 <br /> V M[r5rp'+orrtria L aBsM } s en.3-1 2027 <br /> JS Y1 L.A�..., nr irr0r l L 962,72E It # 9a.M 2M <br /> JT�r...rtwr Sawa 144.7417 % - s F90.796 2L27 <br /> 1B P d, .d r:—r.kq F—M rV0.9 L 21.506 } s MAW 202 <br /> D FNA[P}>}.v L 3E19ID L - s 98LABp 2M <br /> 90rxucr,a..ti L Msiaw % - # 616150 2W9 <br /> 2261J45n%nFrn,R•aaaxa 5EE MM �5 2_Ql)74 F b 20X1CO iZU <br /> 93 R.Madura{a,x orn 5 420.0) E 5 44DXM 20T2 <br /> XO <br /> ¢alt• <br /> ORANGE COUNTY <br /> NOWT]I CAR.OLINA <br /> 7 <br /> 8 Gary Donaldson said that this is the input page from the debt model. <br /> 9 <br /> 10 <br />