|
CITY OF TUKWILA
<br />Policy Compliance & Liquidity Analysis
<br />CASH & INVESTMENT REPORT
<br />December 31, 2016
<br />Liauiditv Analvsis & Maturity Diversification
<br />Funds immediately available
<br />Fixed Maturity Investments, maturing in:
<br />0 -90 days after Report Date
<br />91 -180 days after Report Date
<br />181 -270 days after Report Date
<br />271 -360 days after Report Date
<br />Investments maturing in 1 year or less
<br />Investments maturing in 1 -3 years
<br />Investments maturing in 3 -5 years
<br />Investments maturing in 5 -7 years
<br />Investments maturing in 7 -10 years
<br />Investments maturing in more than 1 year
<br />and less than 10 years.
<br />TOTALS
<br />Investment Policy Parameters
<br />Funds available within 1 year
<br />Funds available within 5 years
<br />Funds available in 5- 10 years
<br />Liauiditv Reauirements and Funds Available for Investina:
<br />Funds immediately available
<br />Restrictions & designations:
<br />Operating liquidity (a)
<br />Liquidity threshold
<br />Funds available for longer term investing
<br />Q Q1 ill "r,
<br />POLICY LIMIT
<br />30.0%
<br />80.0%
<br />20.0%
<br />$ 82,873,997
<br />14,000,000
<br />14,000,000
<br />$ 68,873,997
<br />$ 88,356,564
<br />95%
<br />PORTFOLIO
<br />min 95%
<br />min 100%
<br />max 0%
<br />$ 93,331,956 $ -
<br />100% 0%
<br />Policy Met?
<br />Yes
<br />Yes
<br />Yes
<br />(a) Represents largest one month decline in portfolio balance over the most recent 36 month period doubled; or the
<br />equivalent of a 100% cushion.
<br />7.3
<br />As of Report Date
<br />3.9
<br />Available
<br />Available Available in
<br />Portfolio
<br />Within 1 Year
<br />Within 5 5 - 10 Years
<br />Amount
<br />Policy
<br />Years
<br />$ 82,873,997
<br />$ 82,873,997
<br />$ 82,873,997
<br />3,201,903
<br />US Bank
<br />$ 25,652,931
<br />1,250,508
<br />50.0%
<br />Yes
<br />500,517
<br />43,001,758
<br />46.1%
<br />529,639
<br />Yes
<br />Columbia Bank
<br />5,482,566
<br />5,482,566
<br />5,482,566
<br />3,498,133
<br />Sound Community Bank
<br />3,498,133
<br />1,477,259
<br />50.0%
<br />1,477,259
<br />4,975,392
<br />7,256,055
<br />7.8%
<br />Q Q1 ill "r,
<br />POLICY LIMIT
<br />30.0%
<br />80.0%
<br />20.0%
<br />$ 82,873,997
<br />14,000,000
<br />14,000,000
<br />$ 68,873,997
<br />$ 88,356,564
<br />95%
<br />PORTFOLIO
<br />min 95%
<br />min 100%
<br />max 0%
<br />$ 93,331,956 $ -
<br />100% 0%
<br />Policy Met?
<br />Yes
<br />Yes
<br />Yes
<br />(a) Represents largest one month decline in portfolio balance over the most recent 36 month period doubled; or the
<br />equivalent of a 100% cushion.
<br />7.3
<br />Total Investments
<br />3.9
<br />Total Portfolio
<br />77 d sr » ✓ l ,,. Yi f / 1' / }✓. e /Pr /�pY �r 71 %ef n r � ✓ tr;A r , „�'A •.
<br />%S „ <,r.% .,,r,, r .a �i.e,,,, :.. s.l „<;< „ - /,. „'�r6,�.✓�iau�aoa</5✓fl, ✓ikar,✓n, r,,, tki� /.rJl�/r,.li,d,y..h.,,td,t A �l.✓iuCwSe 4�, �ntic�v��r�,J)ia�;mfr'i�i��7Gi Q, ✓,Y,.,��e a{m�r}�,�v,��i trokal�'"'S.�''A..:�, ��01:
<br />POLICY MAXIMUM
<br />Portfolio
<br />Policy Met?
<br />POLICY
<br />Policy
<br />Financial Institution Diversification
<br />Amount
<br />% of Total
<br />MAXIMUM
<br />Met?
<br />US Bank
<br />$ 25,652,931
<br />27.5%
<br />50.0%
<br />Yes
<br />Washington State Treasurer
<br />43,001,758
<br />46.1%
<br />75.0%
<br />Yes
<br />Columbia Bank
<br />14,219,309
<br />15.2%
<br />50.0%
<br />Yes
<br />Sound Community Bank
<br />3,201,903
<br />3.4%
<br />50.0%
<br />Yes
<br />Other financial institutions
<br />7,256,055
<br />7.8%
<br />50.0%
<br />Yes
<br />Total
<br />$ 93,331,956
<br />100.0%
<br />Portfolio
<br />POLICY
<br />Policy
<br />Investment Mix
<br />Amount
<br />% of Total
<br />MAXIMUM
<br />Met?
<br />Depository
<br />25,652,931
<br />27.57/
<br />insured by PDPC
<br />Yes
<br />State Investment Pool
<br />43,001,758
<br />46.1%
<br />75.0%
<br />Yes
<br />Money market
<br />14,219,309
<br />15.2%
<br />insured by PDPC
<br />Yes
<br />Certificate of Deposit
<br />3,451,903
<br />3.7%
<br />insured by PDPC
<br />Yes
<br />US Agency
<br />3,996,812
<br />4.3%
<br />75.0%
<br />Yes
<br />Municipal Bonds
<br />3,009,243
<br />3.2%
<br />no limit specified in policy
<br />Yes
<br />Total
<br />93,331,956
<br />100.0%
<br />Weighted Average Maturites: Years
<br />Certificates of deposit 2.9
<br />Municipal bonds
<br />7.3
<br />Total Investments
<br />3.9
<br />Total Portfolio
<br />0.4
<br />POLICY MAXIMUM
<br />3.5
<br />Policy Met?
<br />Yes
<br />Note: Cash and cash equivalents are available within one day and are factored
<br />into the Total Portfolio weighted average maturity.
<br />i
<br />Performance Analysis
<br />Current portfolio yield
<br />0.47%
<br />Benchmarks:
<br />6 month treasury
<br />0.62%
<br />2 year treasury
<br />1.20%
<br />Local Govt Invst Pool
<br />(00.51%
<br />
|