RTIRZ-2013-06 RESOLUTION NO. RTIRZ 2013-06
A RESOLUTION OF THE TAX INCREMENT REINVESTMENT ZONE
NO. 2 (TIRZ), ACCEPTING THE INVESTMENT REPORT FOR THE
QUARTERS ENDING JUNE 2012, SEPTEMBER 2012, DECEMBER
2012 and MARCH 2013.
BE IT RESOLVED BY THE TIRZ BOARD OF DIRECTORS:
Section 1. That the Board hereby accepts the Investment Reports for the
Quarter ending June 2012, September 2012, December 2012, and March 2013.
PASSED, APPROVED, AND ADOPTED this 24th day of June, A.D., 2013.
/'
ENNETH R. PHI I 'S
TIRZ NO. 2 CHAIRMAN
ATTEST:/a
MIKE YBU N
TIRZ NO. 2 SECRETARY
RESOLUTION NO. RTIRZ NO. 2013-06
EXHIBIT"A"
RESOLUTION NO. RTIRZ NO. 2013-06
EXHIBIT "A"
TIRZ II
Quarterly Investment Report
Sept 30, 2012-Dec 31, 2012
Portfolio at Sent 30.2012 Portfolio at Dec 31.2012
Ending Book Value $ 4,655,490.69 Ending Book Value $ 6,353,200.39
Ending Market Value 4,655,490.69 Ending Market Value 6,353,200.39
Accrued Interest Receivable Accrued Interest Receivable
Unrealized Gain/(Loss) Unrealized Gain/(Loss)
Change in Unrealized Gain/Loss Change in Unrealized Gain/Loss
Weighted Average Maturity 1 Day Weighted Average Maturity 1 Day
Change in Market Value (7,405,172.34) Change in Market Value 1,697,709.70
Yield to Maturity at Cost 0.16% Yield to Maturity at Cost 0.15%
T-Bill Benchmark 0.17% T-Bill Benchmark 0.16%
Agency Note Benchmark 0.01% Agency Note Benchmark 0.01%
Averaee for Quarter
Total Rate of Return 0.15%
1 Year T-Bill Benchmark Yield 0.17%
Agency Note Benchmark Yield 0.01%
This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act
(Chapter 2256,Texas Government Code).
Prepared by:
ems( c.
Claire Bogard Rick over ar. Fat ma Uwakwe
Director of Finance Assistant Director of Finance Accounting Supervisor
TIRZ II
Summary by Type
December 31,2012
Description Face Amount',$hares Cost Value Book Value Market Value YTM to Cost Days To Maturity
Cash $ 2,129,347.45 $ 2,129,347.45 $ 2,129,347.45 $ 2,129,347.45 0.14 1
MM 4,223,852.94 4,223,852,94 4,223,852.94 4,223,852.94 0.15 1
Total/Average $ 6.353.200.39 S 6.353.200.39 5 6,353,200.39 $ 6.353.200.39 0.15 1
Group Portfolio Holdings Book Value by Maturity
by Type
7,000,000.00 ..._..._..._...____..._.........,.....�......_,____.�_..._.
6,000,000.00
r 34%
5,00C,000 00 _._ __. ............ _._.........._ ..... _........... ......._.._
-0,000.000.00 ......... ...._....... ......_..._.__ _...._.____ ___._ _.._..s'
3,000,000.00
2,000.000.00
66%
1.00C,000 00
._............ 000........ _..__.__ _ ._�..._
■Cash ••Mt, ! 0-1 Month 13 Months 3-8 Months 6-9 Months 9-12 Months >1 Year
Intere tes
Q ts3 :1.1A.4 .3_!TSP St..RAB 1:..Y[ 1..Yr 3 yr 7 yr 1P V� 19 Vr 0 Vr
Q/28J2012 0.06 0.10 0 4 0.27 0.23 0.31 Q62 104 1.65 2.A2 2.82
12J31/2012 0.02 0.05 0.11 0.16 0.25 0.36 0.32 1.18 1.78 2.54 2.95
Yield Curve Comparison
3 00
1 Day WRMf
t10
1.50 ,,._...1 :
i nw n r 6 me 1 yr 2 y; 3 yr 5 yr Tyr 10 yr 20 yr `s0 yr
—�-12!3112672 — —5r2B 20t.
Portfolio vs.Benchmark 0.20 .... '� •
.*
0.10
005 `°'►.
2 a�ti?- ��1.�3 1,''t" a�. J\"2 J91 L eQ 4- ��
5 F h PA !r P 9 O t� O
—+—FOnroire
To
- -1 Yvar T-F]ill ^-+ A+7mrcy koty
City of Pearland
Quarterly Investment Report
Report Format By CUSIP
Group By:Security Type
Portfolio/Report Group:66:TIR2 II
Begin Date:9/30/2012,End Date:12/31/2012
Ending
Portfolio YTM @ Maturity Amortized Amortized Investment
Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending By Income-BV
CASH
Cash Fargo Sweep WFSWEEP 66:TiRZ 0.14000 N/A 433,234.41 2,007,892,77 311,779.73 0.00 0.00 2,129,347.45 302.72
II
Sub
Total/Average 0.14000 433,234.41 2,007,892.77 311,779.73 0.00 0.00 2,129,347.45 302.72
Cash
MONEY MARKET
Weis Fargo MM WF7843 n6:TIRZ 0.15000 N/A 4,222,256.28 1,596.66 0.00 0.00 0.00 4,223,852.94 1,596.66
Sub
Total/Average 0.15000 4,222,256.28 1,596.66 0.00 0.00 0.00 4,223,852.94 1,596.66
Money Market
Total/
0.14665 4,655,490.69 2,009,489.43 311,779.73 0.00 0.00 6,353,200.39 1,899.38
Average
1 oft
City of Pearland
Quarterly Investment Report at Quarterend
Report Format:By Transaction
Group By Security Type
Portfolio/Report Group:66:TIR2 II
As of 12/31/2012
Portfolio Settlement Maturity YTM @ Face Days To Accrued Wo of
Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio
Cash
Wets Fargo WFSWEEP 6G'�� 5/31/2006 N/A 0.140 2,129,347.45 2,129,347.45 2,129,347.45 2,129,347.45 1 33.52
Sweep Cash 11
Sub Total/ 0.140 2,129,347.45 2,129,347.45 2,129,347.45 2,129,347.45 1 0.00 33.52
Average
Money Market __._._...
Wells Fargo 66:TIRZ
WF7843 5/30/2006 N/A 0.150 4,223,852,94 4,223,852.94 4,223,852.94 4,223,852.94 1 66.48
MM II
Sub Total/ 0.150 4,223,852.94 4,223,852.94 4,223,852.94 4,223,852.94 1 0.00 66.48
Average
Total/ 0.147 6,353,200.39 6,353,200.39 6,353 200.39 6,353,200.39 1 0.00 100
Average
1 oft
Pledged Collateral F ,onciliation Report
December 31, 2012
Bank Account Number Account Name Amount
Wells Fargo 201-0419505 Operating $ -
Wells Fargo 201-0419513 Payroll Fund -
Wells Fargo 001-3042841 Sweep Account 83.767,355.25
Wells Fargo 179-0121790 EMS Payments 71,435.67
Wells Fargo 807-1613395 Credit Card Account 1,030,312.27
Wells Fargo 818-4567843 Alvin ISD 4,223,852.94
Wells Fargo 001-3043112 PEDC Sales Tax -
Wells Fargo 280-7409871 Health Claims 215.436.87
Wells Fargo 805-9860145 BC MUD#4 1.43
Wells Fargo Certificate of Deposit -
Total of Bank Balances $ 89,308.394.43
Pledged Collateral for City 98,782.875.92
FDIC Insurance 250,000.00
Total Collateral $ 99,032,875.92
Over(Under)Collateralized $ 9,724,481.49
Total%Collateralized 110.9%
Bank Account Number Account Name Amount
Wells Fargo 100-7284258 Development Authority 1,016,140.48
Total of Bank Balances $ 1,016,140.48
Pledged Collateral for DAP 7,317.675.38
FDIC Insurance 250,000.00
Total Collateral $ 7,567,675.38
Over(Under)Collateralized $ 6,551,534.90
Total%Collateralized 744.7%
Total$Over(Under)Collateralized $ 16,276,016.39
Total%Collateralized 118.0%
Status Collateralized
I:Unvestments\Investment Reports\T!RZ Investment Retort-TIRZ-Otr 1212
TIRZ II
Quarterly Investment Report
March 31, 2012-June 30, 2012
Portfolio at March 31.2012 Portfolio at June 30.2012
Ending Book Value $ 8,051,941.89 Ending Book Value $ 12,061,097.03
Ending Market Value 8,051,751.67 Ending Market Value 12,060,663.03
Accrued Interest Receivable G1.15 Accrued Interest Receivable 482.90
Unrealized Gain/(Loss) - Unrealized Gain/(Loss)
Change in Unrealized Gain/Loss Change in Unrealized Gain/Loss -
Weighted Average Maturity 5 Days Weighted Average Maturity 30 Days
Change in Market Value 1,997,654.74 Change in Market Value 4,008,911.36
Yield to Maturity at Cost 0.05% Yield to Maturity at Cost 0.08%
T-Bill Benchmark 0.19% T-Bill Benchmark 0.21%
Agency Note Benchmark 0.01% Agency Note Benchmark 0.01%
Average for Quarter
Total Rate of Return 0.05%
1 YearT•Bill Benchmark Yield 0.20%
Agency Note Benchmark Yield 0.01%
This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act
(Chapter 2256,Texas Government Code).
Prepared by:
Claire Bogard Rick• -rtaar. Fatim.Uwakwe
Director of Finance Assistant Direct. of Finance Senior Accountant
TIR2 II
Summary by Type
June 30,2012
Description race Amount\Shares Cost Value Book Value Market Valu@ YTM Cost Days To Maturity
Cash $ 3,084,836.25 $ 3,084,836.25 5 3,084,836.25 $ 3,084,836.25 0.05 1
MM 7,980,260.78 7,980,260.78 7,980,260.78 7,980,260.78 0.05 1
CD 996,000.00 996,000.00 996,000.00 995,566.00 0.45 357
Total/Average S 12.061.097.03 5 12,061.097.03 S 12.061.097.03 5 12.060.663.03 0.08 30
Group Portfolio Holdings Book Value by Maturity
by Type
12,000,000.00
8%
p 26°I 10,000,000.00
8.000.000.00 _._..... _ _._.. _._
6,000,000.00 ... __
4.000.000.00 _......
66°%oJ 2,000,000.00
0.00 —.. _ Nam. N mime
wCash ■MM CD ! 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months >1 Year
Interest Rates
leys, .20 y, X)vT
r Ix!: 7-0
aX kn12
0.19 G' °5 072 I-11 l'°7 ..
3/30/2012 .
0 05 3—m-20 07 6 n':'15 jjr-.,, Lwro 13 "0A11
c 09 0.16 0.21 '-
6/29/2012 0.04 J. 1.04 1.61 2.23 32.0308 32:3755
Yield Curve Comparison
355 V
1
,
. -.
-..'
2.50 °4e1 ,4'",,,,1,, ",
.---'--
150 .,..`
'.,'i'';'''.!.:.''''il'Al.i,q;',''''.i',:*<,:,,,-,,;,30:ii`P t„.."•!:‘,,,,;,,,e:,!•,.,z...., „ ir,..„,
-',,' ' •''';;,*''''',.'',::-,'....'0*,:f't;.:iZ.<.:tiliP,iil'fi,-4,,,,,,,,.;-,-;;••■,,,,.:', a ,.„,
„„ „_ ,
/
100 ,
......
0,50 .--,:" ag..—
._
-0 yr
w22 -.-300a512
Portfolio vs.Benchmark
0-25
;;,,'"",),,i'liitkiiii,1":t:Iti,j2;,:
020
0.15
11'
,...,...
.I.,
010
".. „
r -4-.°---* '°
■
'\I'
0.00 ° - \ ,\ ..N't „O .6,.,.. c,e.y ,N..6.c IA' t-,
1 ,3... ,,,i,, .,,,N,... .0.,,,,,,, 4.,..
\;NA, ,NN .,.,1 _,,,,, ‘40,1 .0,e`' J
s‘t. q SE,' I1
It
poftlio •Total —at—I Year T-Eelt
City of Pearland
Quarterly Investment Report at Quarterend
Report Format: By Transaction
Grout By: Security Type
Portfolio/Report Group:66:TIRZ II
As of 6/30/2012
Portfolio Settlement Maturity YTM IF Face Days To Accrued %of
Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio
Cash
Wets Fargo 66:TIRZ
Sweep WFSWEEP II 5/31/7006 N/A 0.05000 3,084,836.25 3,084,836.25 3,084,836.25 3,084,836.25 1 N/A 25.58
Cash
Sub Total/ 0.05000 3,084,836.25 3,084,836.25 3,084,836.25 3,084,836.25 1 0.00 25.58
Average
Certificate Of Deposit
CDARS 0.5 CD1013981856 66:TIRZ 6/21/2012 6/20/2013 0.50000 500,000.00 500,000.00 500,000.00 500,000.00 355 G1.64 4.15
6/20/2013 11
MARLIN
BUSINESS CD57116ADR6 66:TIRZ 2/15/2012 8/15/2012 0.20000 248,000.00 248,000.00 248,000.00 247,944.20 46 184.81 2.06
BANK 0.2 II
8/1.5/2012
SAFRA
NATIONAL CO786580150 6b.TIRZ 5/3/2012 5/5/2014 0.60000 248,000.00 248,000.00 243,000.00 247,621.80 674 236.45 2.06
BANK 0.6 II
5/5/2014
Sub Total/ 0.45020 996,000.00 996,000.00 996,000.00 995,566.00 357 482.90 8.26
Average
Money Market
Wells Fargo WF7843 I( TIRZ 5/30/2006 N/A 0.05000 7,980,260.78 7,980,260.78 7,980,260.78 7,980,260.78 1 N/A 66.17
MM
Sub Total/ 0.05000 7,980,260.78 7,980,260.78 7,980,260.78 7,980,260.78 1 0.00 66.17
Average
Total/ 0.08305 12,061,097.03 12,061,097.03 12,061,097.03 12,060,663.03 30 482.90 100
Average
City of Pearland
Quarterly Investment Report
Report Format: By CUS1P
Group By: Security Type
Portfolio/Report Group:66:TIR2 II
Begin Date:3/31/2012,End Date:6/30/2012
Portfolio Maturity Annualized Amortized Amortized Investment
Description CUSIP/Ticker Name Date TRR-BV Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income-By
CASH
Wells Fargo WFSWEEP 66,TIRZ N/A 0.05 2,466,169.63 1,302,844.12 684,177.50 0.00 0.00 3,084,836.25 405.73
Sweep Cash II
Sub
Total/Average 0.05 2,466,169.63 1,302,844.12 684,177.50 0.00 0.00 3,084,836.25 405.73
Cash
CERTIFICATE OF DEPOSIT
CDARS 0.5 001013981856 66:TIRZ 6/20/2013 0.50 0.00 500,000.00 0.00 0.00 0.00 500,000.00 61.64
6/20/2013 II
MARLIN
BUSINESS CDS7116ADR6 66:TIRZ 8/15/2012 0.20 248,000.00 0.00 0.00 0.00 0.00 248,000.00 123.66
BANK 0.2 II
8/15/2012
SAFRA
NAT 10 NAL CD786580150 66:TIRZ 5/5/2014 0.60 0.00 248,000.00 0.00 0.00 0.00 248,000.00 236.45
BANK 0.6 II
5/5/2014
Sub
Total/Average 0.37 248,000.00 748,000.00 0,00 0.00 0.00 996,000.00 421.75
Certificate Of
Deposit
MONEY MARKET
Wells Fargo WF7843 65:TIR2 N/A 0.03 5,337,772,26 15,656,062.82 13,013,574.30 0.00 0.00 7,980,260.78 536.48
MM II
Sub
Total/Average 0.03 5,337,772.26 15,656,062.82 13,013,574.30 0.00 0.00 7,980,260.78 536.48
Money Market
Total/ 0.05 8,051,941.89 17,706,906.94 13,697,751.80 0.00 0.00 12,061,097.03 1,363.96
Average
Pledged Collateral Reconciliation Report
June 30, 2012
Bank Account Number Account Name Amount
Welts Fargo 201-0419505 Operating $ -
Wells Fargo 201-0419513 Payroll Fund -
Wells Fargo 001-3042841 Sweep Account 67,509,717.92
Wells Fargo 201-0419554 98 CO Escrow -
Wells Fargo 807-1613395 Credit Card Account 596.333.22
Wells Fargo 818-4567843 Alvin ISD 7,980,260.78
Wells Fargo 001-3043112 PEDC Sales Tax -
Wells Fargo 280-7409871 Health Claims 358,698.95
Wells Fargo 865-9860145 BC MUD#4 26,767.97
Wells Fargo Certificate of Deposit -
Total of Bank Balances $ 76,471,778.84
Pledged Collateral for City 87,633,555.68
FDIC Insurance 250,000.00
Total Collateral $ 87,883,555.68
Over(Under)Collateralized $ 11,411,776.84
Total%Collateralized 114.9%
Bank Account Number Account Name Amount
Wells Fargo 100-7284258 Development Authority 1,005.469.85
Total of Bank Balances $ 1,005,469.85
Pledged Collateral for DAP 9,561,774.04
FDIC Insurance 250.000.00
Total Collateral $ 9,811,774.04
Over(Under)Collateralized $ 8,806,304.19
Total%Collateralized 975.8%
Total$Over(Under)Collateralized $ 20,218,081.03
Total%Collateralized 126.1%
Status Collateralized
t:\Investments\Investment Reports\TIRZ Investment Report-TIRZ-Qtr 0612
TIRZ II
Quarterly Investment Report
Dec 31, 2012- Mar 31, 2013
Portfolio at De:31.201.2 Portfolio at Mar 31.2013
Ending Book Value S 6,353,200.39 Ending Book Value $ 8,510,336.50
Ending Market Value 6,353,200.39 Ending Market Value 8,510,33650
Accrued Interest Receivable - Accrued Interest Receivable -
Unrealized Gain/(Loss) - Unrealized Gain/(Loss) -
Change in Unrealized Gain/Loss - Change in Unrealized Gain/Loss -
Weighted Average Maturity 1 Day Weighted Average Maturity 1 Day
Change in Market Value 1,697,709.70 Change in Market Value 2,157,136.11
Yield to Maturity at Cost 0.15% Yield to Maturity at Cost 0.15%
T-Bill Benchmark 0.16% T-Bill Benchmark 0.14%
Agency Note Benchmark 0.01% Agency Note Benchmark 0.01%
Average for Quarter
Total Rate of Return 0.15%
1 Year T-Bill Benchmark Yield 0.15%
Agency Note Benchmark Yield 0.01%
This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act
(Chapter 2256,Texas Government Code).
Prepared bb :4y
Claire Bogard Ric.12 gaa d Fatima Uwakwe
Director of Finance Assistant Dire tor of Finance Accounting Supervisor
TIRZ II
Summary by Type
March 31,2013
Description! Face Amount 1Shares Cost Value Book Value Market Value YTM jt Cost Days To Maturity
Cash $ 3,993,264.33 S 3,993,264.33 $ 3,993,264.33 $ 3,993,264.33 0.14 1
MM 4,517,072.17 4,517,072.17 4,517,072.17 4,517,072.17 0.15 1
Total/Average $ 8,510336.50 S 8.510.336.50 S 8.510.336.50 S 8.510.336.50 0.15 1
Group Portfolio Ho dings Book Value by Maturity
by Type
9.000.00O.00 __._ _—_._._..._..__—_-_--......_...__..........___.........
8,000,000.00 _._......... _.....
7.000.000.00
47%
4,000,000.00 _.
53°l0� 3,000.000.00
2,OOO.00O.00
1.000,000 00
____ __. _..... .. _.....
0.00 _. _ .m__._ ._ ........_ ........_�..._
taCash ■Mkt 0-1 Month 1-3 Morphs 3-6 Months 6-5 Months 9-12 Months 1 Year
Intere tes
1280 1...r09 2 f,0 6 Ple 1.4". LC /Ir. ix Zs .1.0..kt .Z0. 19..A
12/31/2012 0.02 0.01 0.11 0.16 0.25 0.36 0.72 1.18 1.78 2.54 2.95
3/28/2013 0.04 0.07 0.11 0.14 0.25 0.30 0.77 1.24 1.87 2.71 3.10
Yield Curve Comparison
3.50
300
2.50
2.00
1.50 T1RZ's Portfolio YTM.15%
7 .
1 Doi;WAM
1.90
/
0.50 / ,
000 c. tCt.'111, al-T-7-11-7"---.m.--.- . . .
1 mo 7 mo S rno 1 yr 2 yr 3 yr 5 yr T yr 10 yr 20 yr 30 yr
-4-3;2812013 -el-1213112012
Portfolio vs.Benchmark
0.25
0.20
-IIL -' \\
0.15 /
/
0.10 -
..-.-----
0.05 . * 4,-----4---4r------
.
,1 --4,--
•
,f0- ,N'1 AS NS _NT X2- ,...q-
SZ'Y Or If l'Z' PO 02.1 VN- p.,0 SeC OC.‘ •.1ON' *De'
-4-portfolio Total -4.---1 Year Tall -4-Agency Note
City of Pear land
Quarterly Investment Report
Report Format:By CUSIP
Group By:Securty Type
Portfolio/Report Group:66:TIRZ II
Begin Date:12/31/2012,End Date:3/31/2013
Ending
Portfolio YTM @ Maturity Sell Amortized Amortized Investment
Description CUSIP/Tidier Name Cost Date Beginning By Buy Principal Principal Discount Premium Ending BV Income-BV
CASH
Welts Fargo Sweep WF54VFEP 66:TIRZ 0.140 WA 2,129,347.45 1,663,916.88 0.00 0.00 0.00 3,993,264.33 1,296.25
Cash II
Sub
Total/Average 0.140 2,129,347.45 1,863,916.88 0.00 0.00 0.00 3,993,264.33 1,296.25
Cash
MONEY MARKET
Wets Fargo MM WF7843 66:TIRZ 0.150 N/A 4,223,857.94 293,219.23 0.00 0.00 0.00 4,517,072.7.7 1,630.84
Sub
Total/Average 0.150 4,223,852.94 293,219.23 0.00 0.00 0.00 4,517,072.17 1,630.84
Money Market
Total/ 0.145 6,353,200.39 2,157,136.11 0.00 0.00 0.00 8,510,336.50 2,927.09
Average
1 ofI
City of Pearland
Quarterly Investment Report at Quarterend
Report Format:By Transaction
Group By:Security Type
Portfolio/Report Group:66:TIRZ II
As of 3/31/2013
Portfolio Settlement Maturity YTM C Face Days To Accrued °I°of
Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio
Cash
Welk Fargo WFSW°[P 66:TIRZ 5/31/2006 NjA 0.140 3,993,264.33 3,993,264.33 3,993,264.33 3,993,264.33 1 46.92
Sweep Cash 11
Sub Total/ 0.140 3,993,264.33 3,993,264.33 3,993,264.33 3,993,264.33 1 0.00 46.92
Average
Money Market
MMk Fargo WF7843 606:TIR2 5/30/2006 N/A 0.150 4,517,072.17 4,517,072.17 4,517,072,17 4,517,072.17 1 53.08
Sub Total/ 0.150 4,517,072.17 4,517,072.17 4,517,072.17 4,517,072.17 1 0.00 53.08
Average
Total/ 0.145 8,510,336.50 8,510,336.50 8,510,336.50 8,510,336.50 1 0.00 100
Average
•
1 etl
Pledged Collateral F onciliation Report
March 31, 2013
Bank Account Number Account Name Amount
Wets Fargo 201-0419505 Operating -
Wets Fargo 201-0419513 Payroll Fund -
Wells Fargo 001-3042841 Sweep Account 83.432,146.88
Wells Fargo 179-0121790 EMS Payments 446,045.16
Wells Fargo 807-1613395 Credit Card Account 319,150.17
Wells Fargo 818-4567843 Alvin ISD 4.517,072.17
Wells Fargo 001-3043112 PEDC Sales Tax -
Wells Fargo 280-7409871 Health Claims 478,377.15
Wells Fargo 865-9860145 BC MUD#4 1.43
Total of Bank Balances $ 89,192,792.96
Pledged Collateral for City 109,786,188.62
FDIC Insurance 250,000.00
Total Collateral $ 110.036,188.62
Over(Under)Collateralized $ 20,843,395.66
Total%Collateralized 123.4%
Bank Account Number Account Name Amount
Wells Fargo 100-7284258 Development Authority 1,008,554.08
Total of Bank Balances $ 1,008,554.08
Pledged Collateral for DAP 6,538,051.42
FDIC Insurance 250,000.00
Total Collateral $ 6,788,051.42
Over(Under)Collateralized $ 5,779,497.34
Total%Collateralized 673.0%
Total$Over(Under)Collateralized $ 26,622,893.00
Total%Collateralized 129.5%
Status Collateralized
lAnvestments1Investment Reperts1TIRLInvestment R3pOrt-TIRZ Qtr 0313
TIRZ II
Quarterly Investment Report
June 30, 2012-Sept 30, 2012
Period 13
Portfolio at June 30.2012 Portfolio at Seat 30.2012
Ending Book Value S 12,061,097.03 Ending Book Value $ 4,655,490.69
Ending Market Value 12,060,663.03 Ending Market Value 4,655,490.69
Accrued Interest Receivable 482.90 Accrued Interest Receivable
Unrealized Gain/(Loss) - Unrealized Gain/(Loss)
-
Change in Unrealized Gain/Loss - Change in Unrealized Gain/Loss -
Weighted Average Maturity 30 Days Weighted Average Maturity 1 Day
Change in Market Value 4,008,911.36 Change in Market Value (7,405,172.34)
Yield to Maturity at Cost 0.08% Yield to Maturity at Cost 0.16%
T-Bill Benchmark 0.21% T-Bill Benchmark 0.17%
Agency Note Benchmark 0.01% Agency Note Benchmark 0.01%
Average for Quarter
Total Rate of Return 0.10%
1 Year T-Bill Benchmark Yield 0.16%
Agency Note Benchmark Yield 0.01%
This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act
(Chapter 2256,Texas Government Code).
Prepared by:
l 0D O ZY.L>
Claire Bogard Rick 0 • ::ard Fats a Uwakwe
Director of Finance Assistant Director of Finance Accounting Supervisor
TIRZ II
Summary by Type
Sept 30,2012
pescriotion Face Amount\Shares Cost Value Book Value Market Value YTM tia Cost Pays To Maturity
Cash $ 433,234.41 S 433,234.41 $ 433,234.41 $ 433,234.41 0.17 1
MM 4,222,256.28 4,222,256.28 4,222,256.28 4,222,256.28 0.16 1
Total/Average 5 4.655.490.69 i 4.655.490.69 $ 4,655.490.69 5 4.655.490.69 0.16 1
Group Portfolio Holdings Book Value by Maturity
by Type
5,000.000.00 1
/ 9% 4,500.00000
4,000.000.00
3,500,000.00
3,000.000.00 --. _._...._.._ _.._.. ......__
2.500.000.00.
2,000,000.00
1,500.000.00
1,000,000.00
91% 500,000.00
_ 000
- •Cash ■MP 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months >1 Year
1
Interest Rates
Qs= km4 1012 £!n2 Lot 2x IV /Y1 Lot 121¢ 24.V .30 yr
6/29/2012 0.04 0.09 0.16 0.21 0.33 0.41 0.72 1.11 1.67 2.38 2.76
9/28/2012 0.06 0.10 0.14 0.17 0.23 0.31 0.62 1.04 1.65 2.42 2.82
Yield Curve Comparison
300 ... .........._ _.._......_.........__ ,..._ ......_._._._ _ ...____.__ ..._._.____..__,__.___..___.__.._, ._.___-......___._.___._._.�
2.50
2.00
1.50
TIR:.'s Portfolio YTM.16% j'/
1.00 /1 Da WAM f
0.50
/
jjj ---
0.00
1 mo mo 6 ma 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr
-+-9/2812012 -t-6/2912012
Portfolio vs.Benchmark
0.25
0.20 _-_-rani^_ / a
o.15
a-10
.._ *,_. A ._ .- - ..._�, -_ 1
0.00 - -
611 a4^.\ -1\ pn 11, c.icr 1 o-13. x.1. ay,17• Jr-11 v„17. 91. ,ja oeF,
-.-Portroiio Total -e--1 Year T-Big -a-Agency Note
City of Pearland
Quarterly Investment Report at Quarterend
Report Format: By Transaction
Group By: Security Type
Portfolio/Report Group:66:TIRZ II
As of 9/30/2012
Portfolio Settlement Maturity VIM B. Face Days To Accrued %of
Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio
Cash
Wells Fargo 66:TIR2
Sweep WFSWEEP II 5/31/2006 N/A 0.170 433,234.41 433,234.41 433,234.41 433,234.41 1 9.31
Cash
Sub Total/ 0.170 433,234.41 433,234.41 433,234.41 433,234.41 1 0.00 9.31
Average
Money Market
Wells Fargo 66:TIRZ
WF7843 5/30/2006 N/A 0.160 4,222,256.28 4,222,256.28 4,222,256.28 4,222,256.28 1 90.69
MM II
Sub Total/ 0.160 4,222,256.28 4,222,256.28 4,222,256.28 4,222,256.28 1 0.00 90.69
Average
Total/ 0.161 4,655,490.69 4,655,490.69 4,655,490.69 4,655,490.69 1 0.00 100
Average
City of Pearland
Quarterly Investment Report
Report Format: By CUSIP
Group By: Security Type
Portfolio/Report Group:66:TIRZ II
Begin Date:6/30/2012,End Date:9/30/2012
Portfolio Maturity Annualized Amortized Amortized Investment
Description CUSIP/Ticker Name Date TRR-BV Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income-BV
CASH
Wells Fargo WFSW EEP 66:TIRZ 1v A 0.03 3,084,836.25 1,882,655.99 4,534,257.83 0.00 0.00 433,234.41 196.18
Sweep Cash II
Sub
Total/Average 0.03 3,084,836.25 1,882,655.99 4,534,257.83 0.00 0.00 433,234.41 196.18
Cash
CERTIFICATE OF DEPOSIT
CDARS 0.5 C01013981856 66:TIRZ 6/20/2013 0.51 500,000.00 0.00 500,000.00 0.00 0.00 0.00 219.18
6/20/2013 II
MARLIN
BUSINESS C057116A0R6 66:TIRZ 8/15/20,2 0.20 248,000.00 0.00 248,000.00 0.00 0.00 0.00 62.51
BANK 0.2 II
8/15/2012
SAFRA
NATIONAL CD786580350 66:TIRZ 5/5/2014 0.61 248,000.00 0.00 248,000.00 0.00 0.00 0.00 130.45
BANK 0.6 II
5/5/2014
Sub
Total/Average 0.43 996,000.00 0.00 996,000.00 0.00 0.00 0.00 412.14
Certificate Of
Deposit
MONEY MARKET
Wells Fargo 66:TIRZ
WF7843 ri;A 0.11 7,980,260.78 798,142.24 4,556,146.74 0.00 0.00 4,222,256.28 1,761.05
MM II
Sub
Total/Average 0.11 7,980,260.78 798,142.24 4,556,146.74 0.00 0.00 4,222,256.28 1,761.05
Money Market
Total/ 0.10 12,061,097.03 2,680,798.23 10,086,404.57 0.00 0.00 4,655,490.69 2,369.37
Average
Pledged Collateral Reconciliation Report
September 30, 2012
Bank Account Number Account Name Amount
Wells Fargo 201-0419505 Operating $ -
Wells Fargo 201-0419513 Payroll Fund -
Wells Fargo 001-3042841 Sweep Account 57,594,144.23
Wells Fargo 201-0419554 98 CO Escrow -
Wells Fargo 807-1613395 Credit Card Account 620,889.88
Wells Fargo 8184567843 Alvin ISO 4,222,256.28
Wells Fargo 001-3043112 PEDC Sales Tax -
Wells Fargo 230-7409871 Health Claims 201,496.15
Wells Fargo 865-9860145 BC MUD#4 1.44
Wells Fargo Certificate of Deposit -
Total of Bank Balances $ 62,638,787.98
Pledged Collateral for City 92,979,805.97
FDIC Insurance 250,000.00
Total Collateral $ 93,229,805.97
Over(Under)Collateralized $ 30,591,017.99
Total%Collateralized 148.8%
Bank Account Number Account Name Amount
Wells Fargo 100-7284258 Development Authority 656,251.90
Total of Bank Balances $ 656,251.90
Pledged Collateral for DAP 8,145,221.83
FDIC Insurance 250,000.00
Total Collateral $ 8,395,221.83
Over(Under)Collateralized $ 7,738,969.93
Total%Collateralized 1279.3%
Total$Over(Under)Collateralized $ 38,329,987.92
Total%Collateralized 160.6%
Status Collateralized
I:\Investments\Investment Reports\TIRZ\Investment Report-TIRZ-Qtr 0912