Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
A-1. Review Second Quarter Revenue Activity and Investment Update
1101 MEMORANDUM CITY OF TO: Mayor&City Council Members CIIANIIASSEN FROM: Greg Sticha, Finance Director 7700 Market Boulevard DATE: July 25, 2016 CAkC/7 PO Box 147 Chanhassen,MN 55317 SUBJ: Second Quarter 2016 Budget& Investment Update Administration Phone:952.227.1100 BACKGROUND Fax:952.227.1110 Building Inspections In an effort to keep the City Council informed of the city's financial position, staff Phone:952.227.1180 will review the current status of the 2016 revenue and expenditure budgets and recap Fax:952.227.1190 the city's investment portfolio at the work session. Engineering 2016 BUDGET Phone:952.227.1160 Fax:952.227.1170 Revenues: Halfway through the year, revenues are on target for all line items. As of Finance June 30,building permit revenue has collected 50%of the total budget. Attached is Phone:952.227.1140 the budget versus actual revenue report for your review. Fax:952.227.1110 Expenditures: As of June 30, expenditures have been 46% spent. It appears there Park&Recreation are no line items currently expected to significantly exceed the budget in 2016. Phone:952.227.1120 Fax:952.227.1110 Iin summary, it appears both revenues and expenditures are tracking with the Recreation Center originally-adopted budgets. 2310 Coulter Boulevard Phone:952.227.1400 INVESTMENTS Fax:952.227.1404 Attached is a summary of the city's investments. At this evening's meeting Reid Planning& Christianson from Wells Fargowill bepresent to answer questions about the Natural Resources any Phone:952.227.1130 city's investment portfolio. Fax:952.227.1110 The average yield at cost for the portfolio as of June 30, 2016 is 1.2%. There are a Public Works number of other indicators and information about the portfolio included in the 7901 Park Place summary that will be reviewed at the meeting. Phone:952.227.1300 Fax:952.227.1310 ATTACHMENTS Senior Center Phone:952.227.1125 1. Investment Portfolio Summary. Fax:952.227.1110 2. Budget vs. Actual Revenue& Expense General Fund. Website www.ci.chanhassen.mn.us f:\gregs\counci1\2016\7-25 2nd quarter 2016 update.docx Chanhassen is a Community for Life-Providing for Today and Planning for Tomorrow s 0 I bo w w 3 W U ( Eo I. . � C,) is 1 1.0 1-1 4-10 1-1 g 0 0 0 Z a W 0 o 0 o b 0 0 o C....) o A Oo w 'N -4 C-.) p a) a O U a) Et" U En Q ri LO 1-1w o it . N O U Cd t C/D O 0 .- cn O •O O ct w ~ •~ci) O C) a° a° a° C7 .fl cd o..\ d '1-6 -i-+ct0 U x ,-- U �I-i cd 0 O O C/D .0 t o �' as U 1-0 Ci a P4 U [-I 4 N M '71- M N CT O CO 01 I 1 N ,--I O) cn N O CT I o N ,1 In ,1 M ,-i . o, vi N O ,1 a M 1 1 lR Z 0 i o vi C rn O 1v .5 N O O v] 'Fr V O C A O Pi M U •• •• bq.0 O o 0 O p ` y a, U " 0 0 O , P: O O c"0 o o .. 411- L rn a a N 4 •• 4fh 0 0 N O Q O 111- O o [4 40 O cn E ° o N 0 3 3 4411- O a) bO o 1 c" N i1- o o I +-' C U E "� � v f N - v o wv o c , o 0_ v I,_., f0 (Q U L 0 co rn O U 0 .,•' -- 0 O f0 (Of0 E-,' CQ M o COU2UI-, Q ,.I o C Z Z Z Z Z v Z o 00 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O, CO N Lb Ll1 V MN .-I0 O 0 N ID h V M N N N N N N N = . ti ▪ ,-{ ri ,-i ,1 ,1 U oo Cr 11 O ,-i N 1 m i0 k0 N i1 N O O iii o, N ,1 In N co M o b ,1 N 'EPr 'CF ,1 ,-I a o N O Z v {fl- ,-i 0 O a +� I 0 a U .fl O, r mC cu 0 0 Q rS o a O as 14 o a G ,• moi U a o o m o P: a0 a N C) o 0 0 o M 0 o O v oo ..O ,:-. bA Q 4 .4:2AO O n0 o• a o,a F- .x ttr oO m 0 0 .- Q oJ `La) )T m = a (0 cn 0 fp O O .0 w o Y 1 . o — — > N tU Z t O L a- 01 • O 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 C O > > 0 0 CO N (0 vb a co N - 0 o+ m N (0 (0 a MN C1 a m D o Q Q N N in (n ^ 11 ,. o n N LOf } • CO00 p 1b 0 N .1 .-7N O o tiO/vkb CO v, iN-N 0 cc M II iD (0 O 1• b' o N } O '.' o r, .O 0 CC ~ .0 0 'G O I Q O Nco .iiii a; Qti a V yoN Mo} c o 'Al, 0 0 ° o . w U .. 0 N Ci) v] ry M •• �. f0 C C In U 0 Q 'o O tp -p !, 4 0 N CI U@ U lL Om 5 ▪ � - . � >:1-' O 03 9 v � O 0 `° >< t' > 0 ' > O aro � yw0 0 0 0 O 0 O OO N O O 0 Oo O O00 O o o o 0. cWU7:. Z ti O 01 (0 N lD In (0 M N 2 O.3 4t'y 10 10 10 t0 0 + + + + cCI < a a c aT, 74 a a a a tat H3 01 Cf c v V d' 00 y C 0 0 0 .--i • 0 0 0 0 Q) CO O a M N G H . a N N N � O V x o N M N O p{ N M N .1 o E b 10 N 01 .1 -0 .0 7., VO 7 v1cid cr vi } C T O O O O T P1 H I G) E 3v3 0 0 O, N 0 0Cj / 0+ Q 0 0 .-1 0 1p .-1 o O Oil v o 0 0 0 >- Y O1 Q � M 10 01 W y 01 W t0 10 O,C b C, a N 10 N M o G N N 0 CO 3 N N 'b CD O O cJ 03- M N V CO N .-1 N . C O CO O V Hv N N N NLn .y O 0000 ONNNN O M M M M tO 0011 M tO 0 0 0 0 0 0 0 0 0 0 0 0 N 0 CO tO et N O O 0 O O 0 00,, ,, 00 U 666666 .0.:1- 1- Log W Q rn O m m m o 4-1 O N N ,--1.-I b N Ln V d' m W Oe e 'd' O lO VDd' H p .-1 O .-1 r , ti 101 C MO O O O O N Ln 01 01�O N ,y, O O ,-i ,-I O O X 12., ,,-, M M ,--1 ,-1 r-1 G N N N N M 0 Vi GC O 14,..., �p MO N O W W W M .v 00 el F. C. O l0 M n N Ln N Y O v d-W o n 04a tOiOLnLnmN 7i^ p N M In Ln N n H p Netto to {-iN 4- ♦. p M O Ol m 0 A 49-v 6Du)Lr,mN 11)0 V • .. O^ ^LMn o a v .460;,;(.i ..4 X Do OIM DO Y CO I, O o O l O M I. 01 OMMO cq .-1 O M M N .4 p Qp Nino 7M0 1, d'OOO MM v ,--I O,4 ri N .y a < < + + + + oj --------< < < < zch zz « .< 4 toK cc >, gb < < ,, ,f O a Z Z< QQ Q Q ,O M M M Ln Ont ‘ p d' mNNO1 p v v m m m OD-v k6O to Ln m N 1.4Z O v U40aQr0- F 4.0V I) x 1 Ls-9oJ 'O ca M O OD O 0 CO O Ln 0 CO R ONj r^-I O71. M M I N Ln N M l0 O O- • y N - N N I' N Z o0 c9 V p 0 ars j 8 f d _ ? o cz I L M 01 co M 1,-.,9 n to W U OO N co O1 V V) N .. b .-f CO ct� u O M• O V r M a) L > 0 N M M N O Ln O 0 - M .~_. .N.. - N U 0 o F ,-L I i o°c rm I .- .Mi N 0 'OV ,—i M ti � U N N\ M ,-I N M n .r 3'2 Ln r1 n in 7 N O• _....._- m u l0 rnM N ,-1 — ' 3 NO n ,-i O i O N N O1 M Ln ,-L 7 01 N N 1 10 LO x O N O Lo 01 Ol OD ur 1 d O M d' n tri LO .4' O j O N W d' N r♦ O N g i{ N M N rl O C7 tom. c N N N N ce N N N ((I N w C N N N N O '4 ,-I 1I -4 °j 0000 ° ° 0 U G O U0 0 0 0 0 - E a1 p • Ln d- M N M N CO 3 0 0 0 0 0 0 0 v W p ,-i ,-i ,� .-L .-1 ,-i .-LI m t O .1 f bR ,�+ t M O V' M V N N v p N Ln OO ,-i 7 . O O O O O .-i rl g'0 p Cg a) T2 Io o a t, to Ln O1 [t M w N l0 <a 00000 -41--I9 a .-i ,-L ri ti .-4 rt ,-4 v m 2 ( U N u O1 n Ln d' 00 N u"' t >" N •C 0 .-I 0 rl M 01 7 O 0, ri ti O O 6 v p" e. v Pp F O O O O O ,-L ,-) -z-. o a a 3 is LO V [N' N N 01 M 0, M 01 p 00 M Ln 0 E" N ,-i ,-i O O O O 2 to 0) 0) Pg (N4 U CidLimon o z O U10 Y r tea, 0 X c I (n m p 0 O O _ N.L.+ W Ln O O U � � � O � O � O o O O O O o 0 o y� O� 4e O O O O o O O OCI C (7 O O O O O i 13 >^ O O O O o O O O N C L0 co ,D d' N 0 2 ce Q d 0 0b 0 ri • Y U O U N 0 CO 'O^a co N N Q N t O 0 ct N 0 v U o N U W Q.) OCO 'O CO N o °. A N + O o b 74 y U O O O co u w N N N ✓ cU 1 '^ N co O O O ,� N CO aaQ N 0\i ,--i O O ,..i 0 0000 O O O 0 d V)i O O O U ca O O O cm O 1 Lfl Ln CL. p M M O p Q) O CO o p O v O c. 00 N Lfl LO Lo Ln M t0 M W Q O 4i O N 00 O O O O O N 0 00 O 00 rl N M L 1 O O O N 0000 O ^ © nom oQ VD 'ct O C.) LPI nj 0 C7 a (f) CC) DU Z X m ~ Z zO z J O LL1 W 0 Z J W W M LU (f) 12I LU ++ • O O L(1 d N py - N CON p V M M co) M 0 T Ln I, N O lf) O O CO O Ln O O In 0� 0 on 0 v0) O 1 O O 01 O co N O 01 O I• O O ,H N N .+ .+ O O ,x O O O O N O O .--I O .--I .--I O .-I • ----i- Ix G I co n O Ln 10 (Ni O N O Ol O CY Ln O d- O M to O M Ll1 O In O In l0 O W CO O O .-I 0 0 0 0 0 0 0 0 N.L a�b4 In M 1D N O •'-I co N N CO 01 0 10 .^.1 Lo N O In 'I' d' Cr, N ::...° d' M O n L.O n 4• N O N CO d' Ln .ti O co- r-1 O V N co- O N d' f -L. 1O 10 01 M O 01 O M d' .-1 N -1 N E.o O O N In in N CO In Il) OD O .-1 M to M M M V 10 N O O O . - 1 .--I N N N - . 1 N O. Q N. •,-.• •d' CO .M-1 co .--I CO 10 0 10 N itl O .- W ^ N N N CO LO N O I-A cr.) ,H ro in, O O k� N ^ •! " .0 Ln 01 O N co 01 M .N-I N 10 in M o Tr n „`f', N N.- ti N N N N N N f .i a b y e.'1 0 D c 0 f n .a cv M0O . V) 0 0 0 0 0 0 0 0 0 0 0 0 0 O 151 LL N P O N 4 41 P 3o L' :: to CO C cn 0 0 co 00 0 0 0 0 0 0 co 0 0 0 o `-' al RR i d u 0 t, co O O O O coo O O O O O O 0 1�0 ate-+ • I0 Z •0 ✓ 0 0 00O O O O O O 0 .�' 0 0 O O O O O O O• to O CO 0 ) O O to 01 O O O N 01 O OD Tr 'r m d' d' d' N d' O V d- d- CO 0 N i l0 N In N N N 10 ,-- O O O II fa CO 0 0 o O 0 0 0 0 0 0 0 0 0 0 0 0 o O (5 o o al In .-I "4 ri 1 m a' vy Ln W M 10 W .-I W OD l0 1O O N Lo N aS d' Ol .--I .-1 n N N Ln W .--I O d' M N d' OD n n n N N N n n to .--I O d M O Ili [t [r O M N d' .-I W n 1 to ti N Ln N N N M O d' .--1 N .-1 M C) M .moi O 10 10 10 10 )0 0 N N N N N N N ... WI •--1 •--I •--1 ,--1 •--1 1--1 1--1 1--1 1--1 •--I 1--1 1--1 •--1 O O O O O O O O O O O O O 0 0 O O O 0 0 0 a) NNNNNNNNNNNNN o 0 o O 0 0 0 — — — — — — — — — — — — 0 0 0 0 0 0 0 Q .-4 H O rl O .--I .-4 CO H O .-4 O H O 0 O O O O 0 M M M co co M co N M M M M co 0 0 0 o O o 0 N W O\1 O .\-I N .\-I N N d\' L 1 110 N +' ,y 0 0 0 .-1 .-I .-f 0 0 0 . . . . . ^ rvl N U G S LL LL LL LL ¢ Ff ff i � f E f f JXX o o � VD 0 A N a¢¢a z z z z W � 0 F" aaaa U • Z Z Z Z W w i z z z z o n N zzzz � N :5-a a ct < za z z a ¢¢¢ a z z z v° a a a a a o z zzzz v 0 aaaa of zzzz 0 o m aaaa 0 �. Z ZZZ E dcn �m N N 0 o 0 O O O 00 N O N N N N is f0 .0 O n n n n N K O O O C i 0660 `-� 11Y00 C • 0 d ▪ m U 0 X m z C H N Z a 0 m 3Cm =oma H .V. O Z O 1- U m C Z C a o Y 8y Z Z z Z y I I I I o N U U U U � memo N00 8000 N 0000 U u 3 0 LU W Y c ( V1 o z oo 3 .z a o C rn z m O OMI'a.OLOOM.y I'0000000 w w 0.v NNN N N MM a InInInov110 but M 000000000 w w w w.1.,10,10-10101U1 In N mm.M'� O O O O 0 0 0 M o w w••O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O w O O O O o O O O O O O O O O O O O O O O O O O O O O w O O ..l 0 0 0 0 0 0 0"t O O O O 0 o O O O O O O O 0 O O O O O O O O O O O O O O O p O 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 O O 0 0 0 0 0 0 0 0 m am O m0 n IM AID a a m a IMOm m1.N mNmn a 1.am mMOOIN m II..00000m w a mmmlOOm.OmNm.00TNMN nm1O W G o1M ION I'M.01I1010O•4•41.Nlll N WO.I'01111.0 CO 01. 01 N 0100000 a.i m000000N0 V1..N Ma I'IO V1..N M V OMI11N NNOI0 d.• ONNNMI+t w wa I'0006000 O-4-4-4-4.4-4.4.4 NN1.NMMMMMM111..000000000.4...4.+.4.4000 NNMMMMM a.4.. ^- m0I000N00.-.a..0.400IO1f1V111110011100MOOMOOM0OIIN.4OOIIOOIOONNN.l1000IO0OIOOIOp0OC 'C WNO!n m 00 W aMOIO1MmM llln N O.oNOON M.OMOO.!.!.-!0.400 V14•000 MON.-!.4 m.-!010.0.4.401.+M O.IA.0 a.4..1-.1-..t.. i 0.4.4.4 .I .+0N, OOp00.4.i.41..i.+.+.4.-..40NN.+NNNNN.+ M .+ N..Io00oo.+.40.4o.+ .4.4.+.4.+N .+.4N. i..j..j Nm Om m0¢0101 m m m INA a iM a-NNN01M.4O0 ONm mMm IM N-0.100.01.0 mMn m 0l m N NM 01.4 N m a m N wID N N ION v a.D..NmN N wNI O I'I'a I'MMW W W W OINONNO N.4..NNNMN0I000MOnna.ONN N N N IIIO01m.iN.4N.4IOIN 00.460.4.4.-..4.446600000000000.4.40.4.4.4...4.4.4.4.1.1 d6600600.4000000000000.4www.4.400 w NMI' (.f 1. 001 N 400010101000.401001000...4.4 OINNN.4.-.01M N m0IDN,,NO N N.4Wn1Om I'..N.-.(MMIN.0IN~O �'a• mmOmNmmm.DI p01Ommm01MMOM01m0f 01010101nm010101010100 V.w1.IM .W MN mmN W NMmn INNmIN N W W Ma? a .404.41..4.+.+ONNOOO000000000000OO000000000NOOi01MN.4O0.400.4.4OOM00...+.4MO 10 C O MN.N4�Ow OON 1.1000000.4.4 M.4.40N..N a M m ON W W ID n Oti 00000000OM1.NN.4.4I'MNN.Mi M N.N4 mN�N "P' C C M C v Opmj 01.4 N OOm.-I I111:X A mm nmmm N mmmmmmmOf N N01nn N N N V V R{i. N n.000.4MN0000,W N aNmNN 010 a00111NN O a O m O N O O N n )a a a a a a a a a a a a a a a a a a a a N N N N N a V j11 N n N V 0 N N 0 0 0 O N m N m O w N 111 0 0 0 0 w O N N I11N-I't01M 1111111'''M" 0 W NN N NNNN N N N NNN N NN N N NNN N N N NN'0 NN m�IONIDNv1mIn M w wlna N N NI11.11a W m J N X IIn 4 N O 0 0 0 O o 0 o W 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 0 0 0 OI'1.01 01 0 0 100 N Q O N 0 0 a 0 W N N m ,y E N O 0 W N 0 0 0 4 1,n 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 o O O o 0 0 0 0 0 O 0 0 0 0 O w m O N 0 a M a O I'm I.1 N O m O 0 O w N M O m o o a a O 0 w 'O 00oO o o O O o0 o O.4 o 0 0 0 o O o 0 oO O o Oo O O o O O O 00 oO O 0 0 0 w0 0 0CNm M. 0 pO o o0 ..00000 D mmm0. . m. m. . w. . . . . ... . ww...4...1.1. . . .. . . . 4ww. . . . w. . . . . . . . . . . .+...4.... M " OQ.Ni.nIDMOOM W q0 V 0NN QIOMO00 d0'¢1041NNIN0000NONOOM.Mw1f p,NNv 00100000^W NON10I nN11000.n4O10 5 V IMNti10.0MMMNO NNNNNNNNNNNNNNNNNNNNNNNNNN I NNOIwION.011111101 V1 M.-1.4IOa N,N NIOIIf 100 N •P. O N N m m 00MM^O N N N m a N M 0 1 0 N N 0A 0n oa 0 I O NfV.MV.NW.VWN.W 0 0 0 0 0 0 N N m ON 0 0 M 01 I'..0iMONO.i m.i afV OfaV.O4 m mMM0 0IMN M O MONn00M000000MMa00 NOmaNI'mwa..00000OONNnn .M0IN. a0100Y Ow N 00 a 00000000.• 000000.NN0ON. 000000.00000 +O . ON.Pe0OOMOOmwmOo00000000000000000oO00000000000OO00000000000.00000000WN w0w . .. 0 . . . 0,-, M0,0,00,00,,.0' 0, a00000000000000000000000000 0000 W.00nJ.MO_N4.ToONMMO.NO•.NOONOQW Quoo" ooC.a. 00000000000000000000000000 0000 0000000000..4000 000000 a mmmm,.,,,m,., N IO.O.O.O4: IOOIm9 00InOI11MInIn1MM a 10 m .. M10I' MIOIOW N 0 00000.-..O v1M IO l0 I0I 000OIM.Oa • 000000 0000 00000000000000000000000000 0000 000000000000000000000 0000000000 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N NOMmOMoWVm oWV00MNVmalO,.WWV,.V.\4VO1MM�OV010 w NWOOV0101MN10MWMMWVVNWNV M.4O.IOM.-..-IN \0000 00.40000.400.4.40.4 000.-. NOON M..NNN.-.O.4N.40 NN.-1 00 .. 1• 010100 WMM V V .41-,M.+1WV W1 W%O0NMMI�OfNMIOWWWWICON ,IMNw4-IP.�..-..G01�IDInN000...1;1 a.: 44 0000.00000 ..000000000000000.4000000.400 0000 00.100.4.4000.40.00000000 0 WO 1 0 O O 0 -1 Q Q Q Q Q N N a Q a a 1 a Q a a Q a o a a 1 a Q¢Q Q a 6 a Q a Q a a •4,_ .1 1 1 Q Q a¢Q Q a Q Q Q N a a a Q a 1 Q a¢ -"- -1_5,5_ z z z z z M 0 z z zzzzzzzzzzzzzzzzzzzzzzzzzz zz z z z z z z z Z z z o z z z z z z z Z z z v • O.w. O • • c. C +++++ ++++ <<<.(4<.( <4««<.(««««4‹ O<<a <<<4< aaa 1 a¢o a Q a+Q 1 a 1 ' '.. 11Q1Q11aa zzzzzzzzzzzzzzzzzzzzzzzzzz zzzz azz¢¢azQz¢Q¢a¢z1aaazQ va �aaaa aaaa • N 0 0 0 0 0 <<<<<<<<<<<<<<<<<<<<<<<<<< a a a a N M Q Io M w 1 N N ¢N N N N w a N N N N N N N.0 N i0 l0\N IO � aaaa"¢aaaa¢ zzzzzzzzzzzzzzzzzzzzzzzzzz zzzz aaazal¢za"alaaza¢aaal"z c N UO OI1N1 Om 0000Onm m comm N Alm n mmmmmmmn NmN N N N N mIDa .mvn•DODoo N 000 op 0 N O O n1.IM IM IM Ooo pool - NOOmo0NOO: NONNNV NN0OmN.01N0NO<a N VN-i111 .0NNNNNNNNNNNNNNNNNNNNNNNNNNOMWMOUN. . Ya0NU 4 M b N b ON Z 100011.011.01100100 IN m.IDD..mom.N..a.N-I.1.OOOI II00011 CO1C'1 O1 1.101.0+.N 10001.04 IO..I.D..N.N.N.N.N OIOII IO1O.ON N N N C' 0000000000 00000000000000000000000000 0000 000000000000000000000 t 0000000 N 000 ON 000000NNOON 00 NOO 0000000001%0000000000000 NOON 000000000000 • MO\W.I010 W00 m 0.000.0.a N mm.ai N a 04000-0000 0.-. 000 0v10 • 001\100 NM 0.40000 NMNOW00 00.-1 1..-..-1 NNN�NNOo0000.4000.-..4000000000 00000.1 • 00000.000. 0000000000000000..1000000.....-I.1.. 0000 00.000000.00000.-000.00000 G,-, 000MOOMp0OV00000IOn111n11IOM000OO111OOMOOIIN.4OOIONa00001O000000N0IOIOOIOOMO o.' ONO.000IOIOMOIMIOIMMN NO.-.ONO0N MIOM00.4.4.l0.4NO111 V OOOMO.OIM 0ONNNo 00.4M.0On.-.IO0.IOOMM -- 0.40.-.00.4.40¢.•100000.4.i.+(V.a-..i.-I.+.i.i.i fV fV.ifV.VNNN.4N.I00000Nu111'1N.•i.i.io.4Nv1...-.N0M..NNNf100 OE ZO.O.VIZ gZZ--a2 a 5Z rY,_1/1 .Z. YYQ m O ZON�2NUZI��UO(O.)Vl R1 W F m<0.-0.004.0 OOZ 3 Q>W Y N O Q z m F a W IAM Q O J 10",t,m x<zU Y O„.„.„„,u. U Q J J N Z N 00 rj Z,w OJp 0(O9 X U ZFNQmF FZmU >Z W J W mNYSU�OOaZYaOOO W l7U IaMZ Z --.40.0 .4 X..m Nr.� XQ..O�QLL W QZ a E N U p E E Q O V U IrM V)amu,m U'N Y W Z Y J Y 3 O>..U a O Q y S 1 V 1 o X..4-.. x E O X¢J I-z 4w1- ¢, -,J��I`-i?-,I`� ym.�m1-maxzwzu,ce3Z*mw-'MNI��Oj iwnwY".05Nz1J-Z MO zg^LL a'LL z_OFg�~Z^z_O(6(��}~wJZ rOr X3u �I� 06gZLL66OLL6 F.i0gMgOWV11 aDWm0Xm mQON,aLLQJ2� .MKQ3 OojEz�i0HEZQjOW1LYV)2 .y ^ S=aJzmxMZ omuLu LuZ00amzw0YW WNIMmUIXz¢N0 �pS OmLLwa 'zQzOTzVa wuzmu COD 7=4f,044.1 , J Z Q O J J J O r LL J V I y O V I¢I%Wry LL' Z Z a Z y a,6' M O Z Z O O Q W O U Z y y Z J Q O w n.F y¢Y LL W iQ-7KK W 3Zi tjL. 6--T3 mhdg'.2Of W 0680 V Fwzw m "'9°- 0YOZ W{LL-KY cLmw°SOa'Y W wdaW''LLwww W LL LY mZmmg¢l7 Eoa3 aQa001.0._ fZUQ O1--Cm¢ IIIIIIOl11mSZ¢Q W OSOµxIuIaYwIO11� ,w LL K K E E W U U f 0 a E IM JO E E U U E W,LE U U W F O Z U m g W aYlwmI'ONNm m1.N 01a wONN,N..O3MN aNw mM 20NNOmm m1.WM wl.wm DnY mOm>aEO ONa1. MFN-mM` W,I' 3aDa>akuo >wzmxouuYJLLS »l-hr. NrzwuS zzzz 1.0>r »I.axzwou.n>M . OMaWQmONla1U .gARE ^XgmOnOW ,0,wl- 1111 Rrn-ENO UN0ZJS 0 170000Qwm wW.,NOMMN0NWNwNW1nMnOnNa.OUUUU ¢.W00,000N1noM4. ONM • M . M. W NQmWWm4a0WmD00a4aa4NNMW1.qO0000 NS0. a .,0. 0004. U .MMMMMwN 0VNM NO000100 . .M., I'Oi. 01. 00 . 0 WMNa0ONa0O0000 O mOplw MMMNMmMNN MMMN0ONwMNOmO0.NNMWN0OW.MW 0000WMOM0 No.oNNM w,wo.w •� u s zu O 4 X _)I2 a 4 000000000000000.1...1.1.1.1.1.1..N NONN NNM MMMMM V l+1 V V 0N00NN0WWW0 N0M W W.-1.1*NO O 000000000000000000000000000000000000000000000000000000°00....0 U 000000000000000000000000000000000000000000000000000006Z0000000 000001V 010..-1VNVOW00NM 0 0000100 W W VNVlAV 0100100001.100.-1001WOI�W.4NNLANh V WIONO 00000.-1.-1.-1NNN1.INNN W O.i.1NM V V V 000010 W NO.-I.-INMMN V IONO(00000N V MM V NM W NN W Np1.-1 W O O 00000000000000.1.1.4 .10.4.1.1.1 N N NNN N N N NN NM MNNNN MMM MM.i.i MM Q V V Ill.4 ', 00100.40 W N.-10000111 O NNN N N M O M M OOO M 0001/110 00010000111 000000000000 OO M 00.1 N W V 000MNM0W.-1M W N0.10.a0100.iN000ION M10N 4MM0001.iNO.-I.i.iO-M W W.ONN V 1OQ V.-1MNOM.i m U OOOO.i 000.1 OOMOO.4.-1.1N.10.4.4N.1.aM.-I,yNNNN.4.4.4.1 N.4.-1.i.i.-1 M 0 N N N,4 0000 W C V V VMl V V V,W IT0 W IWIIN NINN W ON1 W 1OAON.n ONOOONOOWiO2 W NN.N-IN NMN�OOi NN1•N')N. Al Ni NMNllllllln 00000000000.000000000 0 00 0,...,1000.O.I.y 00.i.i.i.i.i.-I.-i 0.-.i.-I.i.a.i.i.y.a.-I.a'.i.i 0 v 000110NN000NO1O1NO1N000.1. 0.110 W 010 V.-101000NN.4.1 W.-1MM V.401NNN0MNNN.401 VIOOIA.D V IANMO ,� NMMW OMMMW WNW WN010101WN WNMW 001001010100 01111N01O0WMWN010101WN011�01WNW W W W1D111 V O1Q p 0600i.400.4000N 0.-10000.0.-0.+000000000,.0'100*0,000000MN'10000r1 ti.i.i 1V'1N OO a. - ;^ F 00000000000MOON.4.IMMN N.-1N.1.i.i.1p N.1NM V V MNIANNtiOONt01010 ti.Wy2M N ONOONM NN.N-1ti N 1Rv N O O VMN 0.10101.1 NO1N11101MN01 W NO V N0O W W N V W W W W ONO.W N^NN01I�O1I�NNN V.1I�NNN V 0000m111.1ION nN N N 0 V V0M14-VN VOV V V V 000^W V VNNV V V V V0V.1(\V0N01 V V V V V V 00N0V V000.10 N ON V N ' N N ONNNNNNNONIANN NNIOIN MN N.1.1N NN NNNN V N tiN V N NN NNN ti W MN NNNIA10101AN V ION 1. N a m V 0 0 0 0.N O O N 001 0 0 0 0 0 0 0 0 0 0 Q M Q 0 0 0 V W 0 0 0 0 0 0 O*O O y W N 000000. 0 0 0 0 0 0 N 0 0 0 0.*O O 0 0 4 N N O O m00000000000000000000000.0,1.0.000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0,-.1 0 0 0 0 0 0 0 0 0 0 N N 0 0 0 0 0 0 N a d:0 0 0 N 0 0 V O M .-1 0 0 .kc, E 0000000000000000000000000000000000000 p.M.000000 0 O 00000.00 W 0,-,00 M PI l'',0 NI^.•0••O0NMN0 W 01 V 00010 V IM,y N0.01 W M W OOIOMLN.-1 NNM.iM0 V MMM,,,W N W V 0100001N0000N y o u,NNNO V V OM V V N V O V IA V 00 0 0^0v V N0a1A V 1A V 0111Nn11 LA.-IIA V I/1MMIA0"1M O10a000.A.1N N W IAN .'.V,',' NN W NNNNNNION0NNNNIA0111 MNN.i.1NNNNNNN V NtiNMNNNNNN.W WNNNN0 W 1101 V WNn S' 0000NONONNNLA W 01 V NM.1N CI IOM010.1 V MNN01 ION WOO V W 0 V W 0O.N W.-I W.4md.W W.10010101.10 N MIOO 0 0 0 0.400M000Np^01M Md'N OWN V N N W O. NI.^OO V M♦}.INNN N O W V M V V^,N W.I. 000 V MNM V O Y V 00000000.-100000000.4666.4666.-i N 0000.1.4-I.-1 N N NN O N NN N 0 N 0,400( +1 10 V N' • OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOONNOOOOOOOOOooOOO000.0eE . NWm N000000001 -0000000000MNV000MN0000000400MNW000000NMW000. 00NOVWVO p"v 00 00 W OO M 000OO N OOOO V W.i V OOOO N 00 OOO M 0000 4 O W 000000 0 0 000 N00 V O,y W.10 OOOON 00 N 1:0000 V 00000.1000 V N 00 00000000.4 N Oj 000000 W,y r100 O N 00 V OIy1.4 V O C•E O O O O O O O O.40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0 0 0 0 0 0 0 0 0 0. 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O.1 O 0000NONNN000MMNN W.iNNNMMIAMM.4MMNNN W 00MM V ION V 0 V V V V 0 V NN V 10100 W ION W V N V 000000000000000000 0000000000000000000000000 H W NNNNNNNNNNNNNNNNNNMNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN0NNNNNN 4. O ,- .iOl\ON�7000OMVNN7NN.IOMN:lA`o07\OWVIAIAoNO7N�'IIA�o7olAVN .4N40.4NN 1 0 MMMM.-1 NO.i.iNMMM.-1.iNN.iNNN OMM.iNOO. 0M.i 00.1 NO.IN.i.i NN.i0.1NN.-IM.i0.-1.-INN 0000 400000.100000.-1.100 00 .IN000000.40000000000 N 000000000000 N I"1 00000.100000.-10000000.-1.-100000.10000000.-10.-100000 00000.1 00.-1000000000.-i T N ,0,0 0 H 00 «<««««<<««<««««N««<««4«««««‹4‹<< ««« 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 Z p 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 Z M Z Z Z Z Z Z 0 0.. a: .czQaaQQaQ+\\QQ\QQaaQQa<a<QaQa<<«�Qa<a a+aQ«�<<<«++a+QaQ+Q+aQQQQa u. zzzz zMZ... zzzzQ¢z zzz*¢zzzz.k.: *z¢zzzzzz*Qa/z.21.1 ¢ ¢Z z ' a<aa.4a¢mN<<N<<<«<mmm\�mQQmm; C O T N 0) g CO N a a 10 - E a v.L C' a m .0 Z.. o °0 G a u=To v a .mU a a V 12 a C 5 a ° Ca° m aa, N a m �- .v 3 0 y 01 °a Q 8 L a u m C ata C , 3 C C '° c L m N O a N 0 A O O 0, y, N m m Y a a m- m o' Ym -5 E. 8 U L w 0, o a�f .xc ° Z. U vm D(5 W 10u t Covn >0 >Y S aC va m to E m v m i Nc m N a• = L V U L U 5 _ a,ns U p f u a yU= a L 7. Ew �3 1- m 0 L O m W • N E m 2 8 N 6 O L T 11 g 'O C C a E N E o 0 E c te? m 0 v 3 ' v �w N m 2 V= 2. E ,1r3 _ c m v'� > 6 $ 0 3 cow= 0 ✓ c m �v a VFl 1- o o C u, 2Y . m 113, U xQ , u'O' 7 a W a U a Cl! N (. X c N 0 v >a Eco .iNa 2 m Y a or u Y0 o c a ° 2 u.' • r aD m t° L m Ic ,i v o3 v3UU p m m aN c CD 412 m 3 a E E aB LL I ) ' N j U a 0 a 1--1� . 41 q c WFn .p, D . wE O 8O N m > C U 'x q--, ac 0 3 m E c v.4 a 0 .m o .' p a ac v c o ° ^ w N.-, W U W m v Ccg. w - m x 2 a a N E p E O F 01 S w T fv U o m ° F n > > m ri c i w ' n o m s v OO n 0 1O m U L O v c — — C pc D c o oa • w E oc clCm . mm f., 3 NN > E i06p V V N O m m m `.2ON QCOa j .0 m c a , LL = 1 W W. 0 Fu, 0 c yw N > >- WN -0 • c • i vi OO _ W Ymg -Z O, i, 2C U 'a , m° O Y am m5 E N w 0-N a vO - av c m my" c • Tmm c U° FNa) v) a vv a)2gCCn c g . 0 a E > a• a a 10 m a °m . ac m 0 c> o 8 N NN W L k ,r C U L! a ua N a, V Em3 aj ,Va 3 >Z. v ' w E co w o o o 3 To o' .aaO m v o 10 u a a C a '0 AlN a VQ L. Z' 'O 1na o o'" a o. u caE. m nvw vo U1c ° a oLa i 3 a) '0 0 2 C U ]a O U '5O N •c y 0 a,a Nm 0 ' mm m 3 m E 4 n a 9 y U oc u w v m c u O c a 3COC a 1 .> .LvW a a F v a ° N c *,0) 0,a C Lor a y L �mU) 0 .3, y a,m t s o LLU 3 E c o ; ' N ,v a v v 3 3 N ao o N E E c E p cm vE t p O Om o f N n 23 u ". q v3LcoW a q V6° t V , a O O oj caNW ' c UN a O N 0 aa. 0 3 w aU m a m p c °' ,n LY coo 0 . E cE a vv co o E u ° c ? c E. w 0 , p . u m C E!w c c O Z ' c c .o m a av 3 p X O C J a uo ut cW .0aEnn a >0 W 23 �W it K V a a tv C -= O a Uj W m> u U F H a C C C +'m 'O u agWanC O pm >ON 0 — ' c N ' c ' CWCO .O ca' V '° , T .O L a aU oNYa N W 7 mm IC , c as 0 a at' -5 a a s a n 0)O V5 m ° Y i i= .0m. a w U v01 c N 5 N m a Q o °E 3 U U E aa O O kzo' O V 0 a a cp. 0 N Y 9 X=5 N aL E ' mimT L P. + o c uV, v .-g St' a an u z. c o ° p3 m ,n L aT Oa a > N . Cr.,- E EN , N 3NC� mf m u NNa> 3. a> U a a B 2, 0, , Q e a C c f. oO ° c m m85 =C U 3 j J t 1 41 a .4 H oU (- C L L oa w u EEu w a 5 L `W a F v Oc O coN a o. aE ° ° 3ma 3 a" c o ` .09' a u ' v wyBC Q m Nm n - 0 -Nv o Inu v 9 cc a ua m m Y cC S u f W aa O c L ° a 0 v c > 0 > > '6 °a a v,na u u a EmmWE o N >f a 5 aa t-2 >. - / ymmu eN u 22 DL3 T Y d>' •U° 2 C C a' Y m x N E jm a cu u a Ev v O o oN >, m o ac nL Hn ` ` ; .°mya cwEv ^m a w t cfn .-5, w me w ymyaAL .. a oa aa mg- a a ?v °v vuo vm � a g aaa '3vb _3, acm u gua ,- ` ca va Ina mu Mu u ..5.0 Yo, mrn an 6u Y m m .' m .c' E.. m.c m m °. 3H._ o «-o ac ac 4 v � ?m m m >=, ' „oD° LU a 6 ',1., 0 " O .' NN ' L ` a fl U) vis \sgaU 0a a 0e,-,;.,7 9s O" G brV° a8t am et> > im• fm 23 102 ' 5.� HE - 2 vroE LIE 2P E E cam cvm ama 'IYc g . i �C0 , ° rO� Sa> aa y01Ep o5 c wC 5vy5N 0 N V SL3 V f 1 , U) >0 U m 1 v "23 c N O E°•0 av'iL cnMo cY e a Hat 0vYi �`m $ E : o P axwD yw 33 , ° 3° 30 3 , ' 3o ' , .-Eat aop 0 E2 N QE Q3 QE QE cay j ' •y"m.53 _ 3>0y ° 3 t 0t 8 t °N ° Lc 33LL ° •Kaa ayau v —1 `a • v . a ma `a ma `a `a aaO' aa_ oapaa 'al aNaaasOaO0VF VF pF F >F of >F or OF or< Sf OFuwrv., =- .o NU NU ou mu .0-9 of cF Z ,i ;Uu g a a •V •ca a 4 S 2 3 3 3 8 3 3 3 3 3 3 u 3 u u u u W : a, Et' le,N N C U O N E r O 01 .o a.Ni CO ya O -0 . c.- as >1 ' o v c a o 0 + 3 Z E-c _u '-' '.2 Z 1O' m u ET N v 0 r Z' N cu 0 0 o.6 m 0 v IT Ea o -' C.03 E. u .L. w o o ....0 a v p fi 2.8 o ',13e n5 c c 0 ov ww01 5. al E 8t4 o Um N o W W > O- ' N NC 0. vt0��a N I' L, nvy a V CC _or.,N S' .2"g m v NN C -Co VE m CN 2 pa' V E C > C C C gNQ VI O n C _UC a. asNN 'at m N aNux $8O In Nr= E- 0 c FN a0 ° �o , ,!u ,, nY , - om 0 E 0) 2- i E 0.0 o 5w Ziy Zn 3 u c n Er c c+% ao nE Nom' U1 a,: wvE t oe 10c°z oa a an S•-m u N N N , ED> 'i '6.002 0 C W O 0-., a,r C C N 10 C m N u ;84,3 >`> 1/ai X N+L' wmo m N Q L�o,,W n a 00. >� �U'" C LL Q Ok°W iNN q 1;9, �� Sic uN -o� vvo n id NQm , u . 1- 4, �. '3 min'+� c O > 2,L.,c N Qam N�Z>az O �v c 1 tL� c ` w ornu v a aam Oa KV1N�� ti v '° m yy m 4u j N 10 y _g a' H v >3S 3� uo°Y ° N =4-5 '',T-., +' .-.7,f o 00 3 a0. -6, a w ii v voc, N w N +i Yo °Y n wmy ° YE m ' ` Nd. ' 61 0O Eo E E m 0 uuN E u oog0 u 2 w -.5 >V .:7,. ..v o Y v m U° v a v o S m yg 'g,§14 N' m ,, Lo r. YE 2 Ene Er. v vw c m rnm «Q m>u Y a En ac v °aaE E V a on a t PI24E m t Q v mn a m m m E m Lo = v c o vLc a S m -‹ Qa a ' m wac o n wEc Nmo un a � p O G ao ¢ a22 u m 'L - Cmc> III ! W ° m s+ o oLLI mm ofar0 r on v mr a° 4� n _ W u L o La v wa N3 , o w ° 0mm, 0 oa p u0 -.E fm 3cLvaa =v n Eo toc Q , oS 0wc0 ° 0v 8 Y n Qw a .0 0 ot cv Eot o a Y za' ¢ro - o u0mn° ' a U, o f, 3 a u va - : c E v 2CO W O0 C' p y T w N N ° LNO mW N2 > d.a O , . WON U 3 ' =m r >, L N N oo i -- ' Nlf ZJ OV CJN C rmL ° LN a QJJ 0 5NU W gi Q QQm UCIWLL(D=O C O E ° C Vr t r F 'O0LOO O mwYN N N O 7 aE ` t ° NC NCV� U 5 oO ' E o u ° c s 03 «Q ,q62 m Ny c ° v ° ° c o0 c t ° no va c - 00 `1";., ow°L iE .y y W c r mLo c T° vN v y K mvoo `! uC ,, mE m O ^ Nof m r N yV v - n 8o a a U1 NW C m 0 m F • . c Av v EO my o (ov am - m NcN auv o m m NN o m L w Lovon 1vurH9wE ° CZaN0GocOE o n 3 .ag y c Mt vzvE w y v 4 9N4'ulov a2 G " L % L m L `i urn dc - E n m E gyuu CQt t ' « ' 0 Y 2 OT O8oa 0. 1.'20- % vL t «YWOc3 o3� ' vmnm ZbAac,5 a ; u u g u eo of o g- f Ndl asa mid mai Lf, + i .u+$ L i •t L 10 t0'1n:'E �f y a Al u CO?c c o La o _t o N ;3 Lna f W N - w IL _ 0 y N V N d( N ' + - +....'n EyaW .4m„ `pw.' wE Udou OO jB � 'Ly •N3 t� N.L N3LL Ly YDZS yv '6 govp¢ Q i IT0- a¢ mm e-s<<¢ oUC4 cy oc o 5v 7u mv > ° o .0v do d od v co oo 0 v d o oD N N o1% m w�uoO a� Ig5 ro Esq., 8:!,....-i,,07,3 oaQr mm 1 aAdo >v > > 2 m . w24 4 a m oOn '` dc > mo p • uo ao 6p u .2-2 pouo am o6'uuoe oco '"0 ;vrn d° 10 NNQQMam666Q¢a 00 cava ..-'> •' > .'"c'dwa 0 o o o o o o ' mo oN 1ti V K nn o1H o1Q�Qm QQQmmU uv d va7 wv vwpvww wom oam 0E Ncw Yw CuCC0., ,s, $L Ile L L EF r F rL L L EL rL rt L L X33 � 2 cnaV drrY - °p Q QQm y 4 f f f Z aA a a a a 2 2 6 6 a 2 Oa Oa ` A A naan K C d N Tri o TO E f tg_ # '32 2 O 2 / )_f _ - t - \ k #® ®gi _ 2 / . L :£_ ; = ! 2 xmlz. ©—_ _ — C eewe: — k •2 - # 1 / | o k \ #2 | f / \ to /8 \ T j } {0 | \ / ! o , 3 2 im5 { ) 2m 351.,1 292 { \ E. ,I3 — & 7i, g 12 / \ ) 5 = = E 2 ; E - ) / k j i/l�\ a \ \ 3 ) kk \) .. } ! _ { E. Gz: ( { 5 2 - 2q9lf / - ■ & \ - ® | O ) § r § / { } \ ƒ IV, k, 5.\ 5 5 } ) ) { Rl,: t = e ! = &r{ ) i { / ] / -| !££, e } & g! ,c„' !g »a! : - m k| f |! f t-QU|6{ 5 ��\ ( |2 `( !I e s !\g/{ !/ t/\ © ©S }; )5w'- -2 5 �_ ! �/ Ul ,a ■{ a<a -! eadSa§ �` ! � y� � �l �= �= 1.72..5.: eG\Gm §! 2 |; a| t/ t( .h e9 2 1,1 gm �0000uw2a2; ■- . .- —@ 0 E; &r! f/ |2 |f |! |3 ;2 ;J I' . . it it , ■ 7. Important Disclosures Relating to Conflicts of Interest and Potential Conflicts of Interest Wells Fargo Securities,LLC may sell or buy the subject securities to/from customers on a principal basis.Wells Fargo Securities,LLC has or may have proprietary positions in the securities mentioned herein.The trading desk has or may have proprietary positions in the securities mentioned herein.The author's compensation is based on,among other things,Wells Fargo Securities, LLC's overall performance,the profitability of Wells Fargo Securities,LLC's Markets Division and the profitability of the trading desk.As an affiliate,Wells Fargo Securities,LLC maybe compensated for this activity. Accuracy of Information This account summary was prepared by Wells Fargo Securities Fixed Income Market and Portfolio Strategy and is not a substitute for your monthly statement or trade confirmation.Prices and yields are current as of the date of this summary and are subject to change and availability;past performance is no guarantee of future results.Municipal leases are shown at their par value.Any rating provided for a municipal lease investment is a rating associated with the lessee,and does not constitute a rating of the lease investment itself. For Securities held away from Wells Fargo Securities,cost data and acquisition dates have not been verified and positions may not be covered by SIPC The indicative valuation(s)provided in this report are for information purposes only and are intended for use solely by the addressee.The information contained herein is derived from sources that Wells Fargo Securities in good faith considers reliable,however Wells Fargo Securities does not guarantee the accuracy,reliability or completeness of this information and makes no warranty, express or implied,with respect thereto. The indicative valuations do not represent advice,an offer to purchase or sell any security or other instrument either at the indicative valuation(s)or any other price(s).There is no representation that any transaction can or could have been effected at the indicative valuation(s).The indicative valuations contained herein represent estimates as of the stated valuation date and are subject to change without notice.Such estimates do not necessarily reflect Wells Fargo Securities'internal bookkeeping or theoretical model-based valuation.The indicative valuations are based on certain assumptions,and different assumptions,by Wells Fargo Securities or any other source may yield substantially different results.These valuations also may vary from those of another Wells Fargo division,since they may use other sources of market information or make calculations as of a different time. Wells Fargo Securities is not responsible for any loss or damage arising out of any person's use of or reliance upon the information contained herein or otherwise,including but not limited to,errors (including errors of transmission),inaccuracies,omissions,changes in market factors or other conditions or any other circumstances whether or not such errors are within Wells Fargo Securities' control.Under no circumstances shall Wells Fargo Securities be liable for special or consequential damages that arise from any person's use of or reliance upon the information contained herein, even if Wells Fargo Securities has been advised of the possibility of such damages. About Wells Fargo Securities Wells Fargo Securities is the trade name for the capital markets and investment banking services of Wells Fargo&Company and its subsidiaries,including but not limited to Wells Fargo Securities, LLC,a member of NYSE,FINRA,NFA and SIPC,Wells Fargo Prime Services,LLC,a member of FINRA,NFA and SIPC,and Wells Fargo Bank,N.A. Wells Fargo Securities,LLC and Wells Fargo Prime Services,LLC are distinct entities from affiliated banks and thrifts. Copyright©2016 Wells Fargo&Company SECURITIES:NOT FDIC:-INSURED/NOT BANK-GUARANTEED/MAY LOSE VALUE 15 of 15 General Ledger Revenue Budget vs Actual Period 01 - 06 Fiscal Year 2016 Account Description Budget Actual $ Uncollected % Uncollected General Property Tax 3010 Current Property Tax 8,017,431.00 4,208,671.65 3,808,759.35 47.51 3002 Allowance for Delinquent Taxes (50,000.00) - (50,000.00) 100.00 3011 Delinquent Property Tax 85,000.00 30,871.70 54,128.30 63.68 - - 3090 Other Property Taxes - - Total General Property Tax $ 8,052,431.00 $ 4,239,543.35 $ 3,812,887.65 47.35% Licenses 3203 Dog Kennel 500.00 250.00 250.00 50.00 3206 Massage License 1,300.00 300.00 1,000.00 76.92 3226 Liquor On/Off Sale 97,000.00 91,400.00 5,600.00 5.77 3284 Rubbish 4,000.00 300.00 3,700.00 92.50 Total Licenses $ 102,800.00 $ 92,250.00 $ 10,550.00 10.26% Permits 3301 Building 495,000.00 211,896.76 283,103.24 57.19 3302 Plan Check 225,000.00 98,906.84 126,093.16 56.04 3305 Heating&A/C 82,800.00 54,066.98 28,733.02 34.70 3306 Plumbing 65,000.00 47,122.38 17,877.62 27.50 3307 Trenching 30,000.00 13,825.40 16,174.60 53.92 3308 Hunting/Shooting 1,400.00 240.00 1,160.00 82.86 3309 Sprinkler 11,000.00 4,497.98 6,502.02 59.11 3311 Sign 6,500.00 4,185.00 2,315.00 35.62 3316 Septic Tank - 384.60 (384.60) - . 3320 Stable 300.00 180.00 120.00 40.00 3331 Firework's Application Fee - 200.00 (200.00) - 3390 Misc Permits 3,000.00 1,550.00 1,450.00 48.33 Total Permits $ 920,000.00 $ 437,055.94 $ 482,944.06 52.49% Fines& Penalties 3401 Traffic&Ordinance Violation 110,000.00 27,894.06 82,105.94 74.64 3402 Vehicle Lockouts 1,000.00 202.00 798.00 79.80 3404 Dog/Cat Impound - 343.96 (343.96) - 3405 Other Fines& Penalties - - _ - Total Fines& Penalties $ 111,000,00 $ 28,440.02 $ 82,559 98 74.38% Intergovernmental Revenue 3503 School District Reimbursement 45,000.00 - 45,000.00 100.00 3509 Other Shared Taxes 180,000.00 - 180,000.00 100.00 3510 Grants-State 140,000.00 - 140,000.00 100.00 3520 Grants-County - - - - 3530 Grants-Federal - - - - 3533 Other Grants - 6,533.00 (6,533.00) - Total Intergovernmental Revenue $ 365,000.00 $ 6,533.00 $ 358,467.00 98.21% Page 1 of 2 General Ledger Revenue Budget vs Actual Period 01 - 06 Fiscal Year 2016 Account Description Budget Actual $ Uncollected % Uncollected Charges for Current Services 3601 Sale of Documents 500.00 812.75 (312.75) (62.55) 3602 Use&Variance Permits 20,000.00 9,689.00 10,311.00 51.56 3603 Rezoning Fees 1,000.00 1,075.00 (75.00) (7.50) 3604 Assessment Searches 300.00 15.00 285.00 95.00 3605 Plat Recording Fees 5,100.00 900.00 4,200.00 82.35 3607 Election Filing Fees - - - _ 3613 Misc-General Government 4,000.00 1,555.05 2,444.95 61.12 3614 Admin Charge-2%Const 60,000.00 - 60,000.00 100.00 3615 Admin Charge-5%Street Re-Const - - - - 3617 Engineering General - - - _ 3619 Investment Management Fee 75,000.00 75,000.00 100.00 3629 Misc-Public Safety 10,000.00 4,908.12 5,091.88 50.92 3630 Recreation Program Fees 40,000.00 35,139.12 4,860.88 12.15 3631 Recreation Center 210,000.00 93,118.25 116,881.75 55.66 3633 Park Equipment Rental 300.00 - 300.00 100.00 3634 Park Facility Usage Fee 22,000.00 14,710.75 7,289.25 33.13 3635 Watercraft Rental 11,000.00 5,508.12 5,491.88 49.93 3636 Self-Supporting Programs 50,000.00 39,603.12 10,396.88 20.79 3637 Senior Programs 32,000.00 21,949.42 10,050.58 31.41 3638 Food Concessions 12,000.00 4,013.29 7,986.71 66.56 3639 Misc-Park& Rec 1,200.00 904.94 295.06 24.59 3641 Youth Sport Donation - - - - 3642 Recreation Sports 46,300.00 24,597.54 21,702.46 46.87 3649 Misc-Public Works 3,500.00 1,732.04 1,767.96 50.51 3651 Merchandise Sales 1,500.00 1,598.45 (98.45) (6.56) 3670 Internment Fee - - Total Current Services $ 605,700.00 $ 261,829.96 $ 343,870.04 56.77% Other Revenue 3801 Interest Earnings 45,000.00 - 45,000.00 100.00 3802 Equipment Rental&Sale 174,000.00 63,038.92 110,961.08 63.77 3803 Building Rental 5,500.00 3,381.75 2,118.25 38.51 3804 Land Sale - 1,000.00 (1,000.00) - 3807 Donations 23,269.00 22,008.80 1,260.20 5.42 3816 SAC Retainer 5,000.00 621.25 4,378.75 87.58 3818 Sur-Tax Retainer 1,000.00 281.15 718.85 71.89 3820 Misc Other Revenue 300.00 180.00 120.00 40.00 3903 Refunds/Reimbursements 75,000.00 33,716.00 41,284.00 55.05 3980 Cash Over/Short - (0.84) 0.84 - Total Other Revenue $ 329,069.00 $ 124,227.03 $ 204,841.97 62.25% Grand Total $ 10,486,000.00 $ 5,189,879.30 $ 5,296,120.70 50.51% Page 2 of 2 General Ledger Expense Budget vs Actual Period 01 - 06 Fiscal Year 2016 Description Budget Actual Dollars Unspent % Unspent Legislative 103,800.00 49,695.43 54,104.57 52.12 Administration 495,600.00 308,040.35 187,559.65 37.84 Finance 340,700.00 161,081.75 179,618.25 52.72 Legal 168,000.00 59,844.38 108,155.62 64.38 Property Assessment 134,000.00 10,313.89 123,686.11 92.30 Management Information Systems 279,800.00 132,802.67 146,997.33 52.54 City Hall Maintenance 394,500.00 391,036.53 3,463.47 0.88 Elections 38,200.00 - 38,200.00 100.00 Library Building 113,000.00 47,440.81 65,559.19 58.02 General Government $ 2,067,600.00 $ 1,160,255.81 $ 907,344.19 43.88% Police/Carver Co Contract 1,810,100.00 852,803.50 957,296.50 52.90 Fire Prevention &Admin 868,900.00 278,396.02 590,503.98 67.96 Code Enforcement 657,800.00 327,308.75 330,491.25 50.24 Community Service 68,500.00 28,483.94 40,016.06 58.42 Law Enforcement $ 3,405,300.00 $ 1,486,992.21 $ 1,918,307.79 56.33% Engineering 650,700.00 296,498.12 354,201.88 54.43 Street Maintenance 903,800.00 367,626.44 536,173.56 59.32 Street Lighting & Signals 351,000.00 175,360.84 175,639.16 50.04 Fleet Department 555,700.00 210,416.37 345,283.63 62.13 Public Works $ 2,461,200.00 $ 1,049,901.77 $ 1,411,298.23 57.34% Planning Commission 1,300.00 317.22 982.78 75.60 Planning Administration 437,200.00 201,321.69 235,878.31 53.95 Senior Commission 35,400.00 14,367.40 21,032.60 59.41 Community Development $ 473,900.00 $ 216,006.31 $ 257,893.69 54.42% Park& Rec Commission 500.00 35.15 464.85 92.97 Park& Rec Administration 222,700.00 98,995.27 123,704.73 55.55 Recreation Center 337,400.00 145,246.98 192,153.02 56.95 Lake Ann Park Operations 63,100.00 17,031.26 46,068.74 73.01 Park Maintenance 971,700.00 430,108.37 541,591.63 55.74 Senior Citizens Center 76,800.00 36,074.51 40,725.49 53.03 Recreation Programs 311,700.00 112,450.27 199,249.73 63.92 Self-Supporting Programs 57,500.00 20,375.61 37,124.39 64.56 Recreation Sports 36,600.00 17,581.74 19,018.26 51.96 Park& Recreation $ 2,078,000.00 $ 877,899.16 $ 1,200,100.84 57.75% Grand Total $ 10,486,000.00 $ 4,791,055.26 $ 5,694,944.74 54.31%