Orange County NC Website
Browse       Search
31 <br /> Slide #17 <br /> Debt Model- Key Futures <br /> Straightforward updale to Input C I P Detail Page comprised of <br /> more than 140 County Capital Projects; <br /> Input Worksheet includes, Fiscal Year of Debt Issuance, <br /> Amorti7alion Financing Period,and Interest Rate Assumptions; <br /> Output Worksheet includes;Debt Service to Revenue % Ratio, <br /> Total Debt to Assessed Value(Tax Base), Cash 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 /> �,,)W lICAN11.Nli <br /> Gary Donaldson said that the model is very flexible for running different assumptions. <br /> Slide #18 <br /> Debt Model- CIP Detail Worksheet <br /> h YCtfISA W'J22g22 fedlf5q.i r3MF{M410 NNIWrg r�ITwu <br /> r� 11n11 bu.m <br /> L <br /> pre[1ap'Mxa54FH4�aM 5•?F,t+IrpRlMgl4br}'9w1- -.i NOW i 4 4M= 2= <br /> L rl Oil�>nK- 4 I_ It 3WIM0 $ - i UAW} 2W7 <br /> p rlr„rc,•;r�,al lr�.-:Irr.i_iT�.il �� 117.1 ri S - F -v,1 ra r:u� <br /> 9r1 •,M.yr�r,.,,al lrr.ar+a, I,# p4}.= 1 4 SM.Qw 202Z <br /> Ja.1 N4'am .L L.iW.M L 4 L.LEAM 2M <br /> AP.—A.a,.�1a��F—rlr.row.e IS 38000 S - t ..am 2wp <br /> 12.I.__ l—0..'_.J 16 —.114 S - L 1.L'.3. '3'll'1 <br /> 13 rE kltsml hM Iry§ft*l i i 62.Or16 5 - # 62AB6 2Ek7 <br /> IL%w—Fxpaocxfa :L tB4.35i 3 # 9B,.3s1 2027 <br /> J54n.0 ffy...larvn}.wlh EhK,l IS 9w'M i t 952,72R 2f#9 <br /> Jft 53.I rl e.c yIS.nIn F 3M.M1 $ <br /> n..n [Stall] ;1u1] <br /> J1 CW .sy_laarl.Nr Rdo-4 I,# 16P.EM 5 - # E6p.1% 7W7 <br /> JB Polkf.xA Fa .w rrr4ry Fkrlvrxrr.r lr,},p 4b'I # 24.5-W 5 i ... . <br /> D HWf wf Ia 3819M 4 S 38LM 2E#2 <br /> flk 2 V.Wb :# phi%" S - L 61hpw "? <br /> 2LR m'p llalriD I;# iMgq S - # a.T.QD ;lye <br /> a MJ45UW rrrrLL,WlralaFe iEE MM. 5 2000W i 4 Y-M_,''0 Z'J <br /> A3 R. tltW FS 40M i _-M <br /> L.Y19n'*fi..fw.a4nlidn-0wl 5 96 Aft S 4 ra�Cl rA3 <br /> I _ <br /> orcr rl IT9k <br /> ORANGE COUNTY <br /> WOM[CARGL.INA <br /> Gary Donaldson said that this is the input page from the debt model. <br />