Scribd Logo
Upload

Welcome to Scribd!

  • 46 views

    Quarterly Report For Nov 2010

    Uploaded by

    Navarro College
    The document provides an investment report for Navarro College for the quarter ended November 30, 2010. It details the college's certificates of deposit investments with various banks, showing beginning and ending values. It also includes schedules of investments by fund, a recap of investments, and collateral pledged by banks to secure cash and CDs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Quarterly Report For Nov 2010

    Uploaded by

    Navarro College
    46 views6 pages
    The document provides an investment report for Navarro College for the quarter ended November 30, 2010. It details the college's certificates of deposit investments with various banks, showing beginning and ending values. It also includes schedules of investments by fund, a recap of investments, and collateral pledged by banks to secure cash and CDs.

    Original Title

    Quarterly Report for Nov 2010

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides an investment report for Navarro College for the quarter ended November 30, 2010. It details the college's certificates of deposit investments with various banks, showing beginning and ending values. It also includes schedules of investments by fund, a recap of investments, and collateral pledged by banks to secure cash and CDs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    46 views6 pages

    Quarterly Report For Nov 2010

    Uploaded by

    Navarro College
    The document provides an investment report for Navarro College for the quarter ended November 30, 2010. It details the college's certificates of deposit investments with various banks, showing beginning and ending values. It also includes schedules of investments by fund, a recap of investments, and collateral pledged by banks to secure cash and CDs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 6

    Navarro College

    Investment Report
    For the Quarter Ended

    Contact Information
    Rhina Sandoval
    Chief Accountant
    Navarro College
    3200 W. 7th Avenue
    Corsicana, TX 75110
    Phone: (903) 875-7465
    E-mail: [email protected]

    November 30, 2010

    NAVARRO COLLEGE
    INVESTMENT REPORT
    FOR THE QUARTER ENDED NOVEMBER 30, 2010

    TYPE OF INVESTMENT

    BEGINNING
    BOOK VALUE
    08/31/10

    ENDING
    BOOK VALUE
    11/30/10

    ADDITIONS/
    CHANGES
    FOR PERIOD

    BEGINNING
    MARKET VALUE
    08/31/10

    ENDING
    MARKET VALUE
    11/30/10

    Certificates of Deposit
    Citizens National Bank-Henderson CD #677159 (Schol)
    Due 08/01/2011 @ 2.100% Rate
    Purchased 08/01/2009

    250,000.00

    250,000.00

    250,431.51

    251,740.41

    Prosperity Bank - CD #730010473 (Agency)


    Due 04/09/2011 @ 1.100% Rate
    Purchased 04/09/2010

    100,000.00

    100,000.00

    100,433.97

    100,708.22

    Prosperity Bank - CD #730010475 (Schol)


    Due 04/09/2011 @1.100% Rate
    Purchased 04/09/2010

    510,000.00

    510,000.00

    512,213.26

    513,611.92

    Community National Bank & Trust of TX - CD #1121587 (Schol)


    Due 01/18/2012 @1.190% Rate
    Purchased 07/18/2010

    640,000.00

    640,000.00

    640,918.09

    642,816.88

    1,500,000.00

    1,500,000.00

    1,500,123.29

    1,503,863.01

    Community National Bank & Trust of TX - CD #1141420 (E&G)


    Due 02/28/2012 @ 1.000% Rate
    Purchased 08/28/2010
    Community National Bank & Trust of TX - CD #1141442 (E&G)
    Due 09/07/2011 @ .700% Rate
    Purchased 09/07/2010

    1,500,000.00

    1,500,000.00

    1,502,416.44

    State Farm - CD #1019063147 (Aux)


    Due 10/01/2011 @.9100% Rate
    Purchased 10/01/2010

    100,000.00

    100,000.00

    101,607.82

    Prosperity Bank - CD #730010472 (E&G)


    Due 04/09/2011 @ .4500% Rate
    Purchased 10/09/2010

    1,000,000.00

    1,000,000.00

    1,000,641.10

    First Bank & Trust Co. - CD #5006220 (E&G)


    Due 10/18/2011 @2.200% Rate
    Purchased 10/18/2010

    100,000.00

    100,000.00

    100,259.18

    Prosperity Bank - CD #730010417 (Plant)


    Due 09/02/2010 @ .800% Rate
    Purchased 03/02/2010

    3,000,000.00

    (3,000,000.00)

    3,011,967.12

    Prosperity Bank - CD #730010470 (E&G)


    Due 09/04/2010 @ .800% Rate
    Purchased 03/04/2010

    1,500,000.00

    (1,500,000.00)

    1,505,917.81

    Prosperity Bank - CD #730010472 (E&G)


    Due 10/09/2010 @ .800% Rate
    Purchased 04/09/2010

    1,000,000.00

    (1,000,000.00)

    1,003,156.16

    NAVARRO COLLEGE
    INVESTMENT REPORT
    FOR THE QUARTER ENDED NOVEMBER 30, 2010

    TYPE OF INVESTMENT

    ENDING
    MARKET VALUE
    11/30/10

    BEGINNING
    MARKET VALUE
    08/31/10

    ENDING
    BOOK VALUE
    11/30/10

    ADDITIONS/
    CHANGES
    FOR PERIOD

    BEGINNING
    BOOK VALUE
    08/31/10

    State Farm - CD #1019063147 (Aux)


    Due 10/01/2010 @1.450% Rate
    Purchased 10/01/2009

    100,000.00

    (100,000.00)

    101,333.41

    First Bank & Trust Co. - CD #5006220 (E&G)


    Due 10/18/2010 @2.200% Rate
    Purchased 10/18/2009

    100,000.00

    (100,000.00)

    101,910.68

    Subtotal

    8,700,000.00

    (3,000,000.00)

    5,700,000.00

    8,728,405.30

    5,717,664.98

    U.S. Government Agency Securities

    Subtotal

    0.00

    0.00

    0.00

    0.00

    5,700,000.00

    8,728,405.30

    5,717,664.98

    0.00
    TOTAL

    8,700,000.00

    (3,000,000.00)

    NAVARRO COLLEGE
    INVESTMENT REPORT RECAP
    FOR THE QUARTER ENDED NOVEMBER 30, 2010

    RECAP OF INVESTMENTS BY FUND

    ENDING
    BOOK VALUE
    11/30/2010

    TYPE OF INVESTMENT
    First Bank & Trust Co. - CD #5006220
    Community National Bank & Trust of TX - CD #1141420
    Community National Bank & Trust of TX - CD #1121587
    Community National Bank & Trust of TX - CD #1141442
    Citizens National Bank - CD #677159
    State Farm - CD #1019063147
    Prosperity Bank-CD#730010472
    Prosperity Bank-CD#730010473
    Prosperity Bank-CD#730010475
    $

    Educational and
    General Fund

    100,000.00

    100,000.00

    1,500,000.00
    640,000.00
    1,500,000.00
    250,000.00
    100,000.00
    1,000,000.00
    100,000.00
    510,000.00

    1,500,000.00

    5,700,000.00 $

    4,100,000.00 $

    Debt Service
    Fund

    Auxiliary
    Fund

    Agency
    Fund

    Student
    Financial
    Aid Fund

    Plant
    Fund

    640,000.00
    1,500,000.00
    250,000.00
    100,000.00
    1,000,000.00
    100,000.00
    510,000.00
    0.00 $

    100,000.00 $

    100,000.00 $

    0.00 $

    1,400,000.00

    November 30, 2010 Benchmark Rates:


    TexStar Local Government Investment Service

    0.1883%

    Rates and market values are from the November 30, 2010 The Wall Street Journal
    Federal Funds Rate
    Merrill Lynch Ready Assets Trust
    Treasury Bill - 26 weeks
    Certificates of Deposit - Six Months

    0.2000%
    0.0200%
    0.2100%
    0.3300%

    We, the investment officers of Navarro College District, swear that, to the best of our knowledge, this report displays Navarro College's investment portfolio as of November 30, 2010. We further swear that transactions involving this
    investment portfolio are in compliance with Navarro College's Investment Policy and Strategy and the provisions of the Public Funds Investment Act, Chapter 2256, and amendments of the Texas Government Code.

    Prepared by:

    Date

    Chief Accountant

    Date

    Investment Officer

    Date

    Investment Officer

    Prepared 1/14/2011

    Navarro College
    Investment Portfolio
    Maturity Schedule
    November 30, 2010
    MATURITY
    1st Quarter
    Sept - Nov

    Fiscal Year
    2011
    2012

    Total

    2nd Quarter
    Dec - Feb

    $
    1,700,000.00

    2,140,000.00

    1,700,000.00 $

    2,140,000.00

    3rd Quarter
    Mar - May
    $

    1,610,000.00
    -

    4th Quarter
    Jun - Aug
    $

    1,610,000.00 $

    250,000.00
    -

    Total Amount
    $

    1,860,000.00
    3,840,000.00

    250,000.00 $

    5,700,000.00

    NAVARRO COLLEGE
    PLEDGED COLLATERAL BY BANK
    TO SECURE CASH AND CERTIFICATES OF DEPOSIT
    AS OF NOVEMBER 30, 2010

    Per Bank
    Cash

    Entity
    Prosperity Bank

    Community National Bank & Trust

    11,959,335.69

    Citizens National Bank-Waxahachie

    Total
    Deposits

    CDs
    1,610,000.00

    3,640,000.00

    13,569,335.69

    FDIC
    Insurance
    $

    Pledged
    Collateral

    250,000.00

    $ 34,228,558.00

    3,640,000.00

    250,000.00

    4,725,961.42

    250,000.00

    100,000.00

    33,261.45

    33,261.45

    Citizens National Bank-Midlothian

    9,646.57

    9,646.57

    First National Bank-Mexia

    6,637.15

    6,637.15

    250,000.00

    250,000.00

    250,000.00

    250,000.00

    State Farm Bank

    100,000.00

    100,000.00

    250,000.00

    First Bank & Trust Company

    100,000.00

    100,000.00

    250,000.00

    17,708,880.86

    $ 1,750,000.00

    12,008,880.86

    5,700,000.00

    Government agency issues


    Surety Bond

    Mortgage backed securities and Government agency issues

    Citizens National Bank-Henderson

    TOTAL

    Type of
    Collateral

    325,687.50

    $ 39,380,206.92

    Government agency issues

    You might also like