Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Finance Update
Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA July 23, 2008 (1) Monthly Investment Report (2) Preliminary Year End Data eschutes Count A CO ortfolio A 4) Investment Income Fiscal Year 2007-08 $ 340,109 $ 5,323,843 Total Investment Income 340,109 5,323,843 Less Fee: 5% of Invest. Income (17,005) (266,192) Investment Income - Net $ 323,103 $ 5,057,651 CO 0 c 3 IT Investments By County Function General $ 113,635,475 Total Investments $113,635,475 aturit b Investment T p - o ' v o 'o az O E j N. N O O O O . O C L O N EF! L a) Q to m a) a) O U Zc, a� N CO a) 0 E a 0 0 O E O O F- U. S. Treasuries (1) a) U a) .0 Q C 0 0 0i 0 < F- ns m a) Y C u_ m J7 O O O N tri M EO Total Investments 00 O co M Q)MN — N N Average Maturity in Days 2- rent Collatera 00C:)0000000 0 0 0 0 0 0 0 0 0 00C)00,0000 o 0 0 0 0 cfl O C) 0 0 0 0 0 0 LC) 0 LP) 0 0 0 0 O Imo- N- 00 Lf) N 0 L() N O N EF). Bank of America M Bank of the Cascades Columbia River Bank in 7 Y Y C 05 C (b C m Y 17i <a N c 0°c) [a LL Y A •5 c Y @ as Y m c ED >c0 CO m L .0 m Q rn O 2 O .Ea) 0 0 (0 (0 It) 0 0 0 0 f— N N N r r H N E o 7 C E `oa,w v, aa) l0 d C O 0 E O V .- 0)F= ��U G) d -)e a) 00 D Li m F- a) Q a) d O c Z m E 0 0 Total Portfolio: By Investment Types U z O R O U C O 7' 0) 0) jp T re p. '0 m o � o `O 000000.0 c.), 0 0 0 0 0 0 0 U., 0 0 0 0 0 0 0 0 0 0, 0 U. v 0 U O N u, U N, 0 U' � o 0 0,. U N o Z Z Z Z Z, Z'Z:Z'Z Z �Z Z Z Z Z Z'Z Z'Z Z Z Z Z Z z Q z Z Z z Z Z `- Z L`I z'z `-Z'Z � Z'- 0 - t o O 0 L '0 .4 0 0 0 N 0. 0 ch- r 0; r O N 0 0 0 0 cn (1)0 0) 0 O 0 co 0 0 r 0 (o r (7 �- 0 0 r to' 0 4 0 0 0 0 CO 0 0 O O-_ N 0 0 0': 0 0 O N O O: (n 0 t7 10, N)0 0 0 0.- 0 0 0 0 0 0 M N: 0 U) 0 0 N 4 0. 0 0 0 10 0 0 0 N 0 0. 0, 0 0 0, N•N O O'' N oo', 0': 0. r 0' O: O r N O o O' N O: U) O M O r. - (n 4 4 0.. 0 0' 0' 0 0 0 0 0: N U) 0: 0: (, M: N N N. N O: O:, co' co',r r O O N 0' co co 0 co co Q 0 co, U) N co 0:0; N-- 4 0 0 0 O: N O O O N co'' CO: O'', 0', N" CO 0 r 0 0 0'' N 0: N:. h: 0' (0 N. N' O' 0 co 0' N O r, r N. r' 0, 4 O O U) N; N O 0 S:0: N (0 10, 0I .- (N0:ei co" N: N 0))� nD 0' 00 (cos 0 O' o (0D' 4 co N N. 0' O N- (0 4; (D. 0 ei 0 (- 4 r0 CD 0; CO 0 00, 0' 0 _0 . 0. 0. (on O ,.,01 �'. 0 O'. O.0 .- �.' O.�'. r,0 .'Nx- N .0.- .- 0, ,-0,L-N 4 N. N N N N' � C1.1- N N N: N: N:' N N: N' N N N, N N N N N N.- C) N N N 10 N N N N- N. ''1(410 F ' 0 O. 0 0 0 1:. N O' 0 0 4 0 0 4 0, 0 0:. U) 0:0• 0' (n• 0 O; 0:o 0 0: 0 O N- 4 0 0 0.0'N 0 0,0:0 0'0,0,0- O 0', O O O. U)'' 4 01 0' 0 4 0 0 4 0 0 N: N 0 0• 0 co O 0' 0 0 0 0 0 0 N. 0 0 0 0 0,N 01 O 0 O O 0 o' o • 0 O 0 0 O' (n'• 0 O, O; 0 80 0 0 O r, r': N 0:0,0, CO. 0 0.0 0-0:4,0 0, N Q 0 0 OI 0' 0. 0 0.0,0:0,0V 0- 0 - 0 O: O (D. 4. 4, O 0, O: 0 ' N 14 N• U): N' m-, 0-00 O 01:0 0, O: 0 4 O' 0' 0 r r 0 N N' O 4 CO- co: N: O: f r 0 N : CO (D; N r 4 N: 4• OD: 0: N In 0; 0 (D (n' (n 0, ,- 0,N. M' U)' x- O' N N O. 4- N 0'' U), N. 0CO:O LO CO ' m- 0 0 COr; ; CO,0 N (n (n r, 0 0 0-(O 10 0 t0': N 0 NI N'. (D r: �} N 0 N: N 0 N 0 , r. .' 0- .: CO CO: N. O 0- 4 0, (V 0; 0 0) 0 ' 0' O' O O• O' 6 O O' O 0 O co; O O: O' 0 �' N , 4 0 O 0 U)' 0 U) N 0 .- 0' .- 0 U) 0' 0! N 0' 0' 0, O 0' 0. 0 O O .- o: o: O o o: 01 .- o..- r-. 0' O. 0 0' 0 0:0 0.0 a, O. 0 ©- 0: 0) O. o:.- 0, O 0' O 01 .- o 0 N N N N N,NN N N .,- N : (_ N; CV N•N N N .- • .- • N N-..- CO .- N N' N. - N,N N:N L- 'N• : 0 OS O O. 0,0 0 0,▪ 0'0, O' 0 0 0 O'. 0. 0,4 0 0 0 0,0 0. CO 0 0' 0 4. 0' 0' 0 0 0 0 o• 0 0'0 '. 0 o.c.1 O 0. o•q. co, O: O co: 0'i O O 0 OI co 0!0,0'0 O' 0' 0 0 0.0 0 0 N 0 0 0: 4 0 0 0.0' 0. 0:0'0 0. 0' 0' O 0 0 N 0,, 0 0 0: 0 0 0:0 0 0'0:0,0,0:0 : 0. O 0 r 0 0.0 0' 0 0 0 0 0 0 0 0: 0. 0 0 0 0 0' 0 0: 0 0,N:O 010 0 0.0'0 4 0 0;4 0,0 0,0.0:0,4;00,0:40'. 0 0 0 O: 0;,N 4'0 0'O. O. Q': (0,0 (A 0.0 0 0,0 0 0 4' N" N N CO- 0'' O 0: N 0_16 0 4.6 016 0: O : 0: O co 0'' .-: O 0 (o 10 0 co co O N 0: N. O N. 0. 0:0.0; 0 0.0' (m0: 4: r r0; C 04,: O 0'0. o. o' o: h o 0 0: o: N O cO o' o, m, co N' o 4 r: (0' 4 4 O• o o' co. 4 O. 0' o O (O 0. O o' 0 0,: 0 0 0 O� 0, O: 0 0I 0 0 4. r' M 4 0 O 0,0 Oc O, 0 4 0 0 `Cr 0,, O 0, 0 OI OI co(O .-I OI r 0 0.' o O, O 0 0. O 0. 0 O cD o: O. O .- O .- O. O: O: O O ,-: O' O) N..- N N N'� N.- N N: N N.- N N:.- N N ." M N N N N. N N N N N. N � 0 O(0 N 4 0 (1) • '— 0) r 0 4 : 0 a co O 1UJ N co 4 (n 0) 0, N (O O'(n:0 toco w 0,0:07 CO N'.O,M N .0 0': 0':4:0 4 O O'0 (V 040 N:.. 0.0 S 0 T. r:.- .- 01 r:0 0) El 10 0 (o 0:.- 00 r�, 0; 4 O 10: N O ,(0 :4'1 CO: r:,04,_N U):100 T 0,0 '. CO'0 OI O N 0' A 0 CO,(0 O N O Cr. O M O. 0:. O O 0'', (n N 0 0. 0 ,- a O N U) 0 r: 0 O 0: 0' O 0 0. U): N r: O• : O N 0: 4 ^ 0 r:, U) 0 0''. r 0 N, MI. U) O; 0: r 0 Q� N': 0 0 U)': (n: r N N' N: 0 0' cn N r 0 0, 0: . 0 0. 0 0 CO' N- r 0: N O N. m-'. 0 0 CO r s (0 N 0• N' N: O CO ,-:, N 4 S N U)' 10 0 N 0 (n, 0 4: 0 0, N r' 0 0 N N: _' CO 0' U) U) 0 U); O N '0 m- N O U). U) N' U) 4: 1() (n' N: 4 4 4 U), U) U) 41 4': 4 1 0') 4, 4 N 4 1h'. R) U) 1n N' N (1)', 4 N' N 4 (n 4 In (n On' (n N N N. [V, (h M''. M 1n O'O O O U). If, N U)- O -:.,...6: ^ O O: 'in U)' O' LL',. O_ � '. r' N r: O N 4 N: U)'. O: r N O', ` U)- r : Q 0 0. 0. 0 M' 0 0' r' U) • el0:. r'' (n: 0 0 N' co (6 4 4i 4' '. N 4:a! 4 4 (0(00) N: 0: co u-).4.4:.4 U):0 • N r O 00010,0 : N, 0. 0 0. N N r O 0' 0' r O' 00J-• N 4,0 4 (0(0(01010 :N.O CI o. 0 CI m co. O, o, N!: 00, d, a'. .l, �'. t0 0, :0 01 0 : ,0! : 0 0: 00400 NOO oo(`�oN O. 0 OD 00. 'o DD (0'0) r'0 (V'0 59,370,030.83 0 0 Z on E,. f).U. N fU' m E nl a) H ,o c 3 0:E(n m'm0 0 U -U; F- D,LL 2'J F- (pp ::• :12,... U0i (0, Imo, (0o O (D (00 m- .0�0'. O ._. .-- •4.;- `_-. .. A co r`Q r 0, co m 0 0 4 U) 4 4. VI 0 0 r:0 4 0'0 0 0 0 0 0 0 0 4 0 O O o 4 : 0 4 4 0 cn r N 0 I, M (+) Q. (+) cn Q, �'. M L0 Ln p. N O N 4 N 4 4 0 N m c7^M'--. O ' 0' 0 0 0 0 1 4 N;, 0 1. 0 0: 0 r r r N f' O. 0 0 O O 0: U) 0 0' 0 0 0 coO: r N 4. co co coM 4. co 0 M co 0 4 • 0 O O O'' O O O O: O O O O O O O' _ -.i ..- �- __ - _. _ _ _ ;._.. -_..� N :' 0 0• COCOCO'0: CO,CO 0 0 0 0 0I 0 CO 0:,!00 : 0 0 0 0 0 0 0 0 0 0 0 0. 0 0 0' 0 0 0 0 0: 0 0: 0, O O 0 0 0 0 0 • y Q O o o o. , n 0,0' O O o o, o o O O: O O O, CO c C� S (n: 0 • 4 4 OI' O O o LL',,, O o r r- U) 0 4 r O U) (n �, (n m, N 0: )�' N 0 N O r O' OD 0 r O U .O„ G � N, N O O O� 87; cV m O : co O ''. O ,V NI (V.-.:‘1.-::[.--9-,' �: O O ; O: O cV N ! m O N. O � y A ... 14 f o r m 0, 0 0 0' 0 O ,- O ,-..,,C2",,,9- : -c-s" co N (n' 4 U) 0' r 0 W D, 0 0 0 0.-.- 0 �' `.- N. 6 6 8 o. (O >4-: f.1 �' 0 0 0 0 0 01,0 0l0 0 0 � �.0 0• 000 0 0 0,0 0 0 0'8.86.- O 68 ?F J m• d co, r'' 0• c0 co;,:. c0 c0 r- 1.--,1, rr' r r r I r r 0 r N 0 r 0 N.r (0 0' co, r• 0: 001 00 r o t- 0' r 0' 0:. 0 0 co' 0 0' O: O' 0• 0 0; 01 0 0. 0: 00 01, 0 01 0' 0; 0 0 0 0:0:0 0 0 0: 0 0 0:, 0. 0•0 0' 0: 0• 0 Q!o-o; o 0 0 0 0: 0 0 • .- (0:. (o r 0: 0,!, 0 1 I0 0, 0 0! (V 0, 4 rl r CO,0 (0 r:.0 0 0-(0' 0•d N, c, 0, 0, r' 0 0 N!.-' COr oa (V,- m— 0 ',2' O N N O O Q',O c.7,..:.9......',-........,..... (OlO N N O �';O7.! N O Q O: ` Qg, O. 7.- 1 0 O .- OI 0 0: O N 0: 0' N 8. 2 8' r `8,8•3.`"',8.8!&°.8,7 N V'' 4 81 4; 0 t0 7 8' ',8 0' N N: On' V (O a opo !0 0 0:.�:o:=,81`:-','"IE, 0 0''0'',0 o:0 0 00, o o_o o �, o0 0 0 0.0 0;. 0: sd LL LL� LL LL LL �-: 1- LL• r F- LLFU,• , LL LL U LL U': LL U LL. 1u_ U u_ 0 LL LL LL. LL Iu_ LL`IaL Z K:0 Z a'' 0' U co!. V) 4 Z NFLL Z1 U V) m D. CO Z v) N --I ' LL -_ •Z .4; 1 Z Z ¢ ¢• d ¢ Z ILL LL H LL LL F LL f- H f- U LL LL MUa9 : 0 u co (0 Z Z Z•m: Z: Z m V) LL_ Z LL Zi i m Z: Q Z Z I 7 D. w rn y m v� w m D; 3< N 3 (n: v� m.'a (n' m a', V �' 1n •n aD m rn•[!OUH 2" ,? m �N 4 O0 .X0''m m A,(n N':, (0 (1) N (n: N:' N In '., M ^ (0- (n (v) 0 (n: cn• ( M''. 0': (n 0 " (n: M (n: - (n ( (n, M cn, (n. (n . Vcn. M', cn M tn' (n M:, M : [n tn'•0 r cn cn', (n cn'. M'' M, 0' N,:. CO (0 0. (n c.-).: r m'. :: co M.. co, to M (n; co c .Q) --. _ I0 ' 1 U Z �- _ .Z ._; _ .Q - ry m; 0 0 D, J0 N U m U (cal v : U : 0 Z• . c(y: dEix- U, • �'m 10] V Z Z' U al:: . i CO,; $1N ',Y ii : d;u C. Z I❑ - �. 0: _ halt -4 CD r2 0 0, 0 C J 0 i 0'4,2 y . 4, lJl ¢ y 0 A.• � m m- _. N J J'S Z 2,a E S''2 c 2 E Z: , al c o¢ U' •� m c U c c-, c! 0-Z m Z- o,2 tUi: ,' 0.Z '.Z r-... W m --. O. E>•:• H ¢ E¢ dy• m '''m c 2 c m ;co..,g H i 5.m 03;03 m w y 2 2 ' m z-' LL' u) 2 d LL" i m Z co:c LL -LL LL a-: :J- UILL 1.1., a-1 CO LL'LL,0I LL: J,D CO: U.LL LL = LL C7 u.., Li_ m LL CJILL m :LL LL. Q' LL.'(n: LL.. LL'LL LL. LL,U LL,LL J Im'I !, U 1'I u. ca, -)M z >1DIa:LL 40-.Z 4 CCI al .0 0. u) 1.i) »'3 CO 0 V u. I - Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2008 (July 11, 2008) Fund # Fund Name BUDGETED ACTUAL Difference 001 105 111 114 120 123 125 128 130 132 135 140 142 143 145 150 155 160 165 170 200 205 208 212 215 218 220 230 235 240 245 255 259 260 261 270 275 276 280 290 295 296 297 298 300 301 302 303 305 325 326 327 328 329 330 335 340 350 General (1) Business Loan Court Technology Reserve A & T Reserve Grant Projects Justice Courts La Pine Industrial Bethlehem Inn Park Acquisition & Devel Park Development Fees PERS Reserve Project Development General County Projects General Capital Reserve County School Special Transportation Taylor Grazing Transient Room Tax Video Lottery Welcome Center Industrial Development Land Sale Maintenance Liquor Enforcement Victims' Assistance Law Library Clerk's Records Comm on Child & Fam Juvenile Asset Forfeiture Court Security DC Communication System Sheriffs Office Health HealthyStart Health Department Reserve ABHA Mental Health Acute Care Services OHP-CDO Code Abatement CDD CDD-TDC Newberry Neighborhood Groundwater Protection CDD -Reserve CDD Bldg Reserve CDD Electrical Reserve CDD Bldg Improvmt Reserve GIS Dedicated Road Natural Resource Protection Forest Title III Surveyor Public Land Corner Road Building & Equip Road Improvement Res Vehicle Maint & Res Dog Control 6,050,000 430,000 16,000 204,500 80,000 (2,600,000). 140,000 146,000 9,200,000 5,050,000 276,000 1,072,532 100,000 2,000 30,000 45,000 170,000 25,000 44,000 70,000 343,901 571,035 1,090,000 20,000 22,000 194,000 707,000 450,000 549,000 469,428 2,750,000 830,728 134,383 91,945 (2,777,224) 479,496 270,674 3,000,00.0 2,444,111 1,934,856 276,269 122,576 776,042 6,108,195 18,467 529,307 4,043 1,400,537 1,664,977 5,741 777,770 70,000 6,560,327.75 445,509.31 15,458.68 203,402.53 40,855.49 100,668.10 11,740.16 (2,619,549.13) 97,256.85 150,077.80 9,322,840.75 5,038,791.15 193,825.57 1,068,967.92 345.51 113,155.48 5,688.36 131,719.85 38,099.28 16,955.71 96,417.76 150,498.88 23,976.05 69,938.62 145, 786.04 298,925.31 932,865.81 1,120,274.09 24,258.15 39,542.39 204,271.33 907,159.02 722,118.47 446,055.13 546,589.93 878,342.16 2,557,766.97 1,114,127.94 152,554.31 91, 552.09 (2,650,917.91) 477,433.06 405,107.40 Contingency 510,328 5,905,3.83 1.5,509 (541) (1,097) 40,855 20,668 11,740 (19,549) (42,743) 57,900 4,078 122,841 8,000,000 (11,209) 3,590,645 (82,174) 689,530 (3,564) 854,332 346 1.3,155 3,688 131,720 8,099 16,956 51,418 (19,501) (1,024) 25,939 75,786 (44,976) 361,831 30,274 4,258 17,542 10,271 907,159 15,118 (3,945) (2,410) 408,914 (192,233) 283,400 18,171 (393) 126,306 (2,063) 134,433 157,000 106,952 5,042 7,602 11,944 32,028 35,721 68,499 329,574 439,710 708,13.5 3,715 202,877 2,963,655 496,815 259,524 549,000 468,514 1,556,417 609,582 56,743 100 883,780 167,546 605 - (3,0.00,000) 10.0 2,444,173.52 63 1,934,450.42 (406) 276,265.17 (4) 110,754.72 (11,821) 793,199.17 17,157 6,797,615.39 689,420 (95,021.22) (113,488) 612,528.31 83,221 410,073.80 406,031 1,946,761.65 546,225 1,574,670.79 (90,306). 5,789.74 49 826,728.75 48,959 167,006.99 97,007 26,076 225,000 1,766,393 10,077 274,307 16,293 1,112,537 363,859 613,270 41,464 Unappropriated 3,439.408 264,.' 90 25,('.00 7/11/21108 Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2008 (July 11, 2008) Fund # Fund Name BUDGETED ACTUAL Difference 355 430 456 457 458 459 521 522 523 524 530 535 536 538 540 550 560 570 575 580 590 601 610 611 612 613 614 615 616 617 618 619 620 625 628 630 640 650 660 661 670 675 701 702 703 704 705 710 720 731 741 751 Adult P & P Local Impr District Jail Construction Jamison Acq & Remodel OSP/911 Bldg Construction Secure Treatment Facility 2000 Series LTD Tax Imp LID 2003 (BOTC) LID 2005 (U S Bank) LID 2007 (BOTC) CDD Bldg DS Full Faith & Credit 2003 Full Faith & Credit 2005 Full Faith & Credit 2007 HHS/BJCC DS Government Center DS Public Safety DS Redmond Bldg DS PERS D/S Welcome Center DS Fairgrounds DS RV Park Solid Waste Landfill Closure Landfill Postclosure Solid Waste Cap Projects Solid Waste Equip Res Solid Waste Enviro Remed SW Recycling Facility Fair & Expo Center Reserve Fair & Expo Center Deschutes County Fair Building Services Administrative Services BOCC Finance Legal Personnel Information Tech Citrix Insurance Health Benefits Trust Law Enforcement -County Law Enforcement -Rural LED County Capital Reserve LED Rural Capital Reserve Des Co 911 Des Co 911 - Equip Res Extension 4-H Bend Library DS Redmond Library DS Sunriver Library DS Total 663,144 158,235 560,000 9,500,000 1,600,000 41,000 54,000 3,000 123,451 9,000 114,000 228,000 44,250 200,000 209,000 82,000 1,221,164 5,879,439 2,323,391 4,592,055 827,719 2,004,835 898,624 150,000 112,466 280,000 120,000 629,352 114,400 225,000 378,226 140,310 2,500,000 14,000,000 2,560,294 1,169,561 754,000 751,000 2,393,117 606,067 179,670 70,000 13,000 8,000 Contingency 719,909.77 56,766 501,414 209,107.49 50,872 148,535 (9,147.53) (9,148) - 508,105.41 (51,895) - (9,500,000) 100 (1,6.0.0,000) 100 4,971.43 4,971 55,010 1,978.23 1,978 233,625 293.54 294 7,164 18,509.51 1.8,510 105,341 42,390.37 1,390 2,740 58,309.60 4,310 49,094 3,090.62 91 3,699 107,354.45 (16,097) 206,431 12,013.40 3,013 5,000 115,155.42 1,155 207,965.42 (20,035) 43,880.71 (369) 108,800.17 (91,200) 239,768 210,002.15 1,002 71,0.07.27 (10,993) - 47,571 2,345,797.25 1,124,633 540,838 7,239,322.42 1,359,883 2,400,000 2,315,237.39 (8,154) 300,000 3,577,981.35 (1,014,074) 1,201,369 827,110.43 (609) 755,463 1,996,206.09 (8,629) 583,835 158,879.71 158,880 - 646,559.07 (252,065) 337,707 255,477.91 105,478 192,325 120,170.36 7,704 28,063 330,396.44 50,396 207,835 141,59.8.86 21,599 69,990 50,954 844,457.31 215,105 422,350 148,669.19 34,269 62,060 366, 967.92 141,968 80,819 464,214.88 85,989 192,606 225,761.64 85,452 43,190 2,591,938.88 91,939 1,459,715 14,860,983.06 860,983 15,822,568 2,390,736.19 (169,558) - 439,455.09 (730,106) 636,992.03 (117,008) 634,449.16 (116,551) - 2,751,368.54 358,252 4,356,685 605,245.90 (821) 757,467 203,417.28 23,747 38,889 64,199.24 (5,801) 5,000.91 (7,999) 6,796.73 (1,203) Unappropriated 38.000 150,000 50,000 5,404,439 2,108,391 87,(00 60,( 00 9,( 00 7,( 00 104,371,059.00 97,124,865.98 (7,246,193) 65,178,566 11,642,=28 (1) Loan made to Jamison Acquisition and Remodel ($3,160,000) has been included in Beginning NWC. 7/11/2008 Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2008 (July 11, 2008) Fund # Fund Name BUDGETED ACTUAL _ Difference Contingency Unappropriated OPERATING FUNDS 610 Solid Waste 255 675 325 329 001 270 328 220 705 276 630 650 297 295 618 350 670 660 661 327 215 355 200 620 340 640 230 212 720 625 123 280 240 305 105 259 245 165 619 235 145 601 628 208 143 260 205 218 142 330 326 701 275 Sheriffs Office Health Benefits Trust Road Public Land Corner General (1) ABHA Surveyor Comm on Child & F am Des Co911 Acute Care Services Finance Personnel Newberry Neighborhood CDD Fair & Expo Center Dog Control Insurance Information Tech Citrix Forest Title III Law Library Adult P & P Industrial Development Building Services Vehicle Maint & Res Legal Juvenile Victims' Assistance Extension 4-H Administrative Services Justice Courts OHP-CDO Court Security GIS Dedicated Business Loan Health DC Communication System Video Lottery Deschutes County Fair Asset Forfeiture County School RV Park BOCC Liquor Enforcement General Capital Reserve HealthyStart Land Sale Maintenance Clerk's Records General County Projects Road Building & Equip Natural Resource Protection Law Enforcement -County Mental Health 702 Law Enforcement -Rural CONSTRUCTION FUNDS 616 SW Recycling Facility 430 Local Impr District 524 LID 2007 (BOTC) 1,221,164 2,345,797.25 1,124,633 907,159.02 14, 000, 000 14, 860, 983.06 6,108,195 6,797,615.39 1,400,537 1,946,761.65 6,050,000 6,560,327.75 4.69,428 878,342.16 4,043 410,073.80 571,035 932,865.81 2,393,117 2,751,368.54 830,728 1,114,127.94 629,352 844,457.31 225,000 366,967.92 270,674 405,107.40 (2,777,224) (2,650,917.91) 150,000 255,477.91 70,000 167,006.99 2,500,000 2,591,938.88 378,226 464,214.88 140,310 225,761.64 529,307 612,528.31 70,000 145,786.04 663,144 719,909.77 45,000 96,417.76 280,000 330,396.44 777,770 826,728.75 114,400 148,669.19 1,090,000 1,120,274.09 44,000 69,938.62 179,670 203,417.28 120,000 141,598.86 80,000 100,668.10 134,383 152,554.31 22,000 39,542.39 776,042 793,199.17 430,000 445,509.31 707,000 722,118.47 194,000 204,271.33 30,000 38,099.28 112,466 120,170.36 20,000 24,258.15 345.51 25,000 23,976.05 1,072,532 1,068,967.92 450,000 446,055.13 170,000 150,498.88 343,901 298,925.31 276,000 193,825.57 1,664,977 1,574,670.79 18,467 (95,021.22). 2,560,294 2,390,736.19 2,750,000 2,557,766.97 1,169,561 439,455.09 158,879.71 158,235 209,107.49 18,509.51 540,838 907,159 2,963,655 860,983 15,822,568 689,420 1,766,393 546,225 1,112,537 510,328 5,905,383 408,914 468,514 406,031 16,293 361,831 439,710 358,252 4,356,685 283,400 609,582 215,105 422,350 141,968 80,819 134,433 605 126,306 883,780 105,478 192,325 97,007 41,464 91,939 1,459,715 85,989 192,606 85,452 43,190 83,221 274,307 75,786 68,499 56,766 501,414 51,418 7,602 50,396 207,835 48,959 613,270 34,269 62,060 30,274 708,135 25,939 35,721 23,747 38,889 21,599 69,990 20,668 106,952 18,171 56,743 17,542 - 17,157 225,000 15,509 - 15,118 496,815 10,271 202,877 8,099 5,042 7,704 28,063 4,258 3,715 346 47,571 50,954 (1,024) 32,028 (3,564) 854,332 (3,945) 259,524 (19,501) 11,944 (44,976) 329,574 (82,174) 689,530 (90,306) 363,859 (113,488) 10,077 (169,558) - (192,233) 1,556,417 (730,106) - 158,880 50,872 18,510 148,535 105,341 25,000 87,00+) 264,290 7/11 /2 )08 Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2008 (July 11, 2008) Fund # Fund Name BUDGETED ACTUAL Difference 521 2000 Series LTD Tax Imp 535 Full Faith & Credit 2003 540 HHS /BJCC DS 522 LID 2003 (BOTC) 530 CDD Bldg DS 550 Government Center DS 580 Welcome Center DS 523 LID 2005 (U S Bank) 536 Full Faith & Credit 2005 570 Redmond Bldg DS 751 Sunriver Library DS 731 Bend Library DS 741 Redmond Library DS 456 Jail Construction 590 Fairgrounds DS 538 Full Faith & Credit 2007 560 Public Safety DS 457 Jamison Acq & Remodel 575 PERS D/S 613 Solid Waste Cap Projects 459 Secure Treatment Facility 298 Groundwater Protection 458 OSP/911 Bldg Construction OTHER FUNDS 160 Transient Room Tax 120 Grant Projects 170 Welcome Center 150 125 132 155 290 296 128 130 Special Transportation La Pine Industrial Park Development Fees Taylor Grazing Code Abatement CDD-TDC Bethlehem Inn Park Acquisition & Devel RESERVE FUNDS 611 Landfill Closure 135 PERS Reserve 300 CDD -Reserve 335 Road Improvement Res 302 CDD Electrical Reserve 301 CDD Bldg Reserve 111 Court Technology Reserve 614 Solid Waste Equip Res 710 Des Co911 -Equip Res 114 A & T Reserve 261 Health Department Reserve 612 Landfill Postclosure 615 Solid Waste Enviro Remed 140 Project Development 303 CDD Bldg Improvmt Reserve 704 LED Rural Capital Reserve 703 LED County Capital Reserve 617 Fair & Expo Center Reserve Total 54,000 9,000 41,000 114,000 209,000 3,000 4.4,250 8,000 70,000 13,000 82,000 123,451 228,000 560,000 200,000 4,592,055 1,600,000 3,000,000 9,500,000 4,971.43 58,309.60 12,013.40 1,978.23 42,390.37 115,155.42 210,002.15 293.54 3,090.62 43,880.71 6,796.73 64,199.24 5,000.91 (9,147.53) 71,007.27 107,354.45 207,965.42 508,105.41 108,800.17 3,577,981.35 131, 719.85 40,855.49 16,955.71 100,000 113,155.48 11,740.16 146,000 150,077.80 2,000 5,688.36 91,945 91,552.09 479,496 477,433.06 (2,600,000) (2,619,549.13) 140,000 97,256.85 5,879,439 7,239,322.42 9,200,000 9,322,840/5 2,444,111 2,444,173.52 5,741 5,789.74 276,269 276,265.17 1,934,856 1,934,450.42 16,000 15,458.68 827,719 827,110.43 606,067 204,500 549,000 2,323,391 2,004,835 5,050,000 122,576 751,000 754,000 898,624 104,371,059.00 605,245.90 203,402.53 546,589.93 2,315,237.39 1,996,206.09 5,038,791.15 110,754.72 634,449.16 636,992.03 646, 559.07 4,971 4,310 3,013 1,978 1,390 1,155 1,002 294 91 (369) (1,203) (5,801). (7,999) (9,148) (10,993) (16,097) (20,035) (51,895). (91,200) (1,014,074) (1,600,000) (3,000,000) (9,500,000) 131,720 40,855 16,956 13,155 1.1,740 4,078 3,688 (393) (2,063) (19,549) (42,743) Contingency 55,010 49,094 5,000 233,625 2,740 7,164 3,699 206,431 239,768 1,2.01,369 100 100 100 100 167,546 57,900 Unappropriated 38,000 7,000 6.0,000 9,000 50,000 150,000 1,359,883 2,400,000 5,404,439 122,841 8,000,000 3,439,408 63 49 (4) (406) (541) - (609) 755,463 (821) 757,467 (1,097) 157,000 (2,410) 549,000 (8,154) 300,000 2,108,3€1 (8,629) 583,835 (11,209) 3,590,645 (11,821) 26,076 (116,551) (117,008) - (252,065) 337,707 97,124,865.98 (7,246,193) 65,178,566 11,642,528 (1) Loan made to Jamison Acquisition and Remodel ($3,160,000) has been included in Beginning NWC. 7/11) ?008