10/18/18

ODESSA COLLEGE QUARTERLY INVESTMENT REPORT

Quarter Ending: August 31, 2018

TEXAS PUBLIC FUNDS INVESTMENT ACT

To the best of my knowledge, the investment portfolio of the District, at August 31, 2018, and the investment transactions entered into during the quarter then ended are in compliance with the Texas Public Funds Investment Act.

The investments of the District comply with the investment objectives and strategies as expressed in the Odessa Junior College District Investment Policy.

All business organizations that have sold investments to Odessa College during the quarter have executed a written instrument stating that they meet the requirements of the District's Investment Policy.

Market Value Source: Frost Bank

Asset Class Face Amount/Shares

CDs MM & Int Ckg

Muni Bonds Public LGIP US Agency Total / Average

3,302,000.00 3,880,372.93 10,800,000.00 12,887,058.55 1,000,000.00 31,869,431.48

Market Value

3,283,759.39 3,880,372.93 10,846,053.10 12,887,058.55

998,471.50 31,895,715.47

Book Value

3,301,011.50 3,880,372.93 10,951,265.06 12,887,058.55

999,225.69 32,018,933.73

% of Portfolio

10.36 12.18 33.89 40.44

3.14 100.00

YTM @ Cost

1.97 1.85 1.95 2.07 2.96 2.02

Days To Maturity

440 1

449 1

1,170 235

Virginia Chisum, CPA, M.Ed. - Vice President for Business Affairs

10/18/18

Date

Kristi Gibbs, Controller

10/18/18

Date

Month 5/31/2018 6/30/2018 7/31/2018 8/31/2018 Total / Average

Market Value 35,559,652.58 33,229,186.81 31,548,379.40 31,895,715.47 33,058,233.57

Odessa College Portfolio Summary by Month

All Portfolios

Begin Date: 5/31/2018, End Date: 8/31/2018

Book Value 35,689,219.64 33,358,467.95 31,679,577.97 32,018,933.73 33,186,549.82

Unrealized Gain/Loss

YTM @ Cost

-129,567.06

1.89

-129,281.14

2.01

-131,198.57

2.04

-123,218.26

2.02

-128,316.26

1.99

Market Value / Book Value Comparison

YTM @ Market 2.21 2.37 2.41 2.38 2.34

Duration 0.51 0.55 0.53 0.62 0.55

Days To Maturity 192 208 203 235 209

page 2

Odessa College Distribution by Asset Class - Market Value

All Portfolios

Begin Date: 5/31/2018, End Date: 8/31/2018

Asset Class

Market Value 5/31/2018

CDs MM & Int Ckg

Muni Bonds Public LGIP US Agency Total / Average

3,279,683.43 2,744,420.48 11,541,133.00 17,994,415.67

0.00 35,559,652.58

Portfolio Holdings as of 5/31/2018

Asset Class Allocation

% of Portfolio 5/31/2018

9.22 7.72 32.46 50.60 0.00 100.00

Market Value 8/31/2018

3,283,759.39 3,880,372.93 10,846,053.10 12,887,058.55

998,471.50 31,895,715.47

Portfolio Holdings as of 8/31/2018

% of Portfolio 8/31/2018

10.30 12.17 34.00 40.40

3.13 100.00

page 3

Odessa College Distribution by Asset Class - Market Value

Fund Group: Pooled Operating

Begin Date: 5/31/2018, End Date: 8/31/2018

Asset Class

Market Value 5/31/2018

CDs MM & Int Ckg

Muni Bonds Public LGIP US Agency Total / Average

2,212,755.35 2,744,420.48 10,148,889.00 13,667,925.90

0.00 28,773,990.73

Portfolio Holdings as of 5/31/2018

Asset Class Allocation

% of Portfolio 5/31/2018

7.69 9.54 35.27 47.50 0.00 100.00

Market Value 8/31/2018

2,215,788.42 3,880,372.93 9,447,915.10 10,668,531.11

998,471.50 27,211,079.06

Portfolio Holdings as of 8/31/2018

% of Portfolio 8/31/2018

8.14 14.26 34.72 39.21

3.67 100.00

page 4

Odessa College Distribution by Asset Class - Market Value

Fund Group: Debt Service

Begin Date: 5/31/2018, End Date: 8/31/2018

Asset Class

Market Value 5/31/2018

CDs Muni Bonds Public LGIP Total / Average

1,066,928.08 1,392,244.00 4,326,489.77 6,785,661.85

Portfolio Holdings as of 5/31/2018

Asset Class Allocation

% of Portfolio 5/31/2018

15.72 20.52 63.76

100.00

Market Value 8/31/2018

1,067,970.97 1,398,138.00 2,218,527.44 4,684,636.41

Portfolio Holdings as of 8/31/2018

% of Portfolio 8/31/2018

22.80 29.85 47.36 100.00

page 5

Odessa College Total Rate of Return - Book Value by Month

All Portfolios

Begin Date: 6/30/2018, End Date: 8/31/2018

Month 6/30/2018 7/31/2018 8/31/2018

Beginning BV + Accrued Interest

35,804,932.14 33,455,627.85 31,774,155.64

Interest Earned During Period-BV

59,473.64 57,174.42 57,034.10

Realized Gain/Loss-BV

0.00 -1,618.40

0.00

Investment Income-BV

59,473.64 55,556.02 57,034.10

Annualized TRR-BV

Average Capital Base-BV

35,979,882.88 31,702,337.56 31,672,308.15

TRR-BV 0.17 0.18 0.18

Annualized TRR-BV

2.00 2.12 2.18

Treasury 1 Year

2.33 2.39 2.45

TRR-BV: Total Rate of Return - Book Value Benchmark: US Treasury 1 Year Interest Earned: Quarterly $ 173,682 / Fiscal YTD: $ 516,655

page 6

Maturity Range

0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months

1-2 Years 2-3 Years 3-4 Years Total / Average

Odessa College Distribution by Maturity Range - Market Value

All Portfolios

Maturity Range Allocation

Market Value 5/31/2018

% of Portfolio 5/31/2018

20,738,836.15 1,499,835.00 836,533.30 1,317,100.25 1,509,788.28 7,617,620.16 1,773,483.69 266,455.75

35,559,652.58

58.32 4.22 2.35 3.70 4.25

21.42 4.99 0.75

100.00

Portfolio Holdings

Begin Date: 5/31/2018, End Date: 8/31/2018

Market Value 8/31/2018

17,102,428.13 500,520.00

1,319,810.50 1,257,614.48 3,916,412.52 4,260,884.16 2,770,905.93

767,139.75 31,895,715.47

% of Portfolio 8/31/2018

53.62 1.57 4.14 3.94

12.28 13.36

8.69 2.41 100.00

page 7

Description CUSIP Debt Service - Fixed Income Barclays Bank 2.05 12/17/2019 06740KJC2

Customers Bank PA 2.1 9/10/2019 23204HCA4

Discover Bank DE 2.1 8/27/2019 2546714X5

Fresno County CA 2.488 8/15/2019-18 358266CQ5

Goldman Sachs NY 1.95 3/12/2019 38147JVL3

Signature Bank AR 1.6 9/27/2019 82669LFX6

Sub Total Debt Service - Fixed Income Debt Service - Liquid Assets TexPool - Prime LGIP LGIP0005P

TexPool - Prime LGIP LGIP0007P

TexPool - Prime LGIP LGIP0001P

TexPool - Prime LGIP LGIP0003P

TexPool LGIP LGIP0002

Face Amount / Shares

Odessa College Portfolio Holdings by Portfolio Name

All Portfolios

Settlement Date YTM @ Cost

Cost Value Book Value

Market Price YTM @ Market

Market Value Accrued Interest

Date: 8/31/2018

% Portfolio Unre. Gain/Loss

Credit Rating Credit Rating

Days To Call/Maturity Duration To Maturity

12/17/2014

247,000.00

99.43

245,600.99

0.77%

NR

473

247,000.00

2.05

247,000.00

2.50

1,040.45

-1,399.01

NR

1.28

9/10/2014

245,000.00

99.56

243,910.98

0.77%

NR

375

245,000.00

2.10

245,000.00

2.54

2,452.68

-1,089.02

NR

1.01

8/27/2014

240,000.00

99.59

243,990.84

0.76%

NR

361

245,000.00

2.54

244,011.50

2.52

56.38

-20.66

NR

0.98

9/22/2015

1,404,536.00

99.87

1,398,138.00

4.38%

NR

349

1,400,000.00

2.40

1,401,112.48

2.63

1,548.09

-2,974.48

S&P-AA-

0.95

3/12/2014

245,000.00

99.96

244,890.98

0.77%

NR

193

245,000.00

1.95

245,000.00

2.04

2,251.32

-109.02

NR

0.53

9/29/2015

90,000.00

99.53

89,577.18

0.28%

NR

392

90,000.00

1.60

90,000.00

2.04

7.89

-422.82

NR

1.06

2,471,536.00

2,466,108.97

7.73%

351

2,472,000.00

2.28

2,472,123.98

2.52

7,356.81

-6,015.01

0.95

4/30/2017

132,838.59

100.00

132,838.59

0.41%

NR

1

132,838.59

2.18

132,838.59

2.18

0.00

NR

0

4/30/2017

170,801.92

100.00

170,801.92

0.53%

NR

1

170,801.92

2.18

170,801.92

2.18

0.00

NR

0

4/30/2017

20,003.43

100.00

20,003.43

0.06%

NR

1

20,003.43

2.18

20,003.43

2.18

0.00

NR

0

4/30/2017

1,891,883.50

100.00

1,891,883.50

5.91%

NR

1

1,891,883.50

2.18

1,891,883.50

2.18

0.00

NR

0

4/30/2017

3,000.00

100.00

3,000.00

0.01%

NR

1

3,000.00

1.92

3,000.00

1.92

0.00

NR

0

page 8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download