Loading...
HomeMy WebLinkAboutPension General_Documentation_Tab 10_08/07/2006VILLAGE OF TEQUESTA GENERAL EMPLOYEES' PENSION TRUST FUND • SCHEDULE OF INVESTMENT ACTIVITIES FOR THE QUARTER ENDING JUNE 30, 2006 BEGINNING STATEMENT BALANCE -March 31, 2006 Independent Community Bank -Cash $ 1,010.45 Salem Trust Company 703,984.56 INCREASES CONTRIBUTIONS Employee 18,029.81 Village 25,076.64 43,106.45 INTEREST & DIVIDENDS Interest 3,910.11 Dividend 1,525.14 5,435.25 OTHER Change in Accrued Income 14.55 Gain (Loss) on Sale of Assets (745.48) Change in Investments 1,471.50 UnRealized Gain (Loss) on Investments (2,215.72) ~_ • TOTAL INCREASES 47,066.55 DEDUCTIONS DISTRIBUTIONS Refund of Pension Contributions (3,005.46) Withholding Tax (751.36) ADMINISTRATIVE EXPENSES Bogdahn Consulting (500.00) Salem Trust -Fees (339.99) Business Services Connection (418.86) Dana Investments (1,120.54) FPPTA Membership Dues _ Wire Fees & Service Charge (45.00) Foreign Tax W/Held _ Hanson, Perry ~ Jensen PA (821.64) Gabriel, Roeder, Smith & Co. (4,500.00) TOTAL DEDUCTIONS (11,502.85) ENDING STATEMENT BALANCE -JUNE 30, 2006 $ 740,558.71 Transaction in Transit at June 30, 2006 -Pension Co ntribs. 7,o3s.7~ Adjusted ICB & Salem Statement Balance -June 30, 2006 733,sts.oo • $ - BALANCE SHEET Village of Tequcsta Page: 1 7/19/2006 9:50 am As of: 6/30/2006 Fund Type: 600 Trust and Agency Funds Fund: 602 - VillageEmployee Pension-Gen Assets Acct Class: 101 Cash and Cash Equivalents 101.123 Cash -Independent Community B Acct Class: 101 Cash and Cash Equivalents Acct Class: 103 Investments 135.100 Accrued Income 151.000 Investments ncct Class: 103 Investments Total Assets Reserves/Balances Acct Class: 253 F/B - Unreserved/Undesignated 271.000 Fund Balance 299.000 Change In Fund Balance Acct Class: 253 F/B - Unreserved/IJndesignated Total Reserves/Balances Total Liabilities & Balances • Balances 847.59 847.59 4,073.14 735,637.99 739,711.13 740,558.72 585,494.92 155,063.80 740,558.72 740,558.72 740,558.72 • INCOME STATEMENT QUARTER ENDED 06130/2006 Page: 1 7/14/2006 Village of T~guesta 12:37 pm OTR:3 QTD Amd. Bud. YTD Actual OTD Actual Fund: 602 - VillageEmplovee Pension-Gen evenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 361,102 Dividend Income Unrestricted Investment Earnin Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 367.100 Unrealized gain/loss on invest 368.001 Pension Fund Cont-Employer 368.002 Pension Fund Cont-Employee 369.000 Other Miscellaneous Revenue Miscellaneous Revenues General Revenues Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 531.304 Recording Secy Service 531.307 Investment Services 531.309 Actuarial Services 545.300 Insurance 554.300 Books, Publ, Subs & Membership Operating Expenditures/Expense • General Dept: 165 Pension Acct Class: 530 Operating ExpenditureslExpense 536.300 Pension Distributions/Refunds Operatino Expenditures/Expense Pension Expenditures Net Effect for Fund VillageEmplovee Pension-Gen 0.00 10,142.18 3,924.66 0.00 4,076.50 1,525.14 0.00 14,218.68 5,449.80 0.00 758.46 -745.48 0.00 37,073.90 -2,215.72 0.00 74,027.14 25,076.64 0.00 43,839.67 18,029.81 0.00 1,471.50 1,471.50 0.00 157,170.67 41,616.75 0.00 171,389.35 47,066.55 0.00 171,389.35 47,066.55 0.00 1,547.03 821.64 0.00 644.40 418.86 0.00 4,909.30 2,005.53 0.00 4,500.00 4,500.00 0.00 743.00 0.00 0.00 225.00 0.00 0.00 12,568.73 7,746.03 0.00 12,568.73 7,746.03 0.00 3,756.82 3,756.82 0.00 3,756.82 3,756.82 0.00 3,756.82 3,756.82 0.00 16,325.55 11,502.85 Grand Total Net Effect: 0.00 155,063.80 35,563.70 Skipped Budgeted & Unbudgeted $0 Balance Accounts REVENUE REPORT Village of Tequesta For the Period: 41111006 to 6130/2006 Page: 1 7/14/2006 11:30 am - Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud 602 - VillageEmployee Pension-Gen ues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 04/30/2006 GJ APR 06 • REV. MAR O6 ACCRUED INC. SALEM TRUST $4058.59 -4,058.59 04/30/2006 GJ APR 06 ACCRUED INCOME SALEM $3370.76 3,370.76 04/30/2006 GJ APR O6 -INTEREST SALEM $1899.72 1,899.72 05/31/2006 GJ MAY O6 -INTEREST -SALEM $1,343.71 1,343.71 05/3112006 GJ MAY O6 -REV. APR 06 ACC. INCOME SALEM $3,370.76 -3,370.76 05/31/2006 GJ MAY 06 -ACCRUED INCOME SALEM $3,685.94 3,685.94 06130/2006 GJ JUN 06 -INTEREST -SALEM $666.68 666.68 06130/2006 GJ JUN O6 -REV. MAY O6 ACCRUED INCOME SALEM - $3,685.94 -3,685.94 06130/2006 GJ JUN 06 -ACCRUED INCOME SALEM - $4,073.14 4,073.14 Interest Income 0.00 0.00 3,924.66 0.00 -3,924.66 0.0 361.102 Dividend Income 04/30/2006 GJ APR O6 -DIVIDENDS SALEM $348.33 348.33 05/31/2006 GJ MAY 06 -DIVIDENDS -SALEM $420.60 420.60 06/30/2006 GJ JUN 06 -DIVIDENDS -SALEM $756.21 756.21 Dividend Income 0.00 0.00 1,525.14 0.00 -1,525.14 0.0 Unrestricted Investment Earnin 0.00 0.00 5,449.80 0.00 -5,449.80 0.0 Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 04/30/2006 GJ APR O6 -SALE OF INVEST -LOSS SALEM ($11.29) -11.29 05/31/2006 GJ MAY O6 -LOSS ON SALE OF INVEST. SALEM - ($15.97) -15.97 3012006 GJ JUN O6 -SALE OF INVEST -LOSS SALEM - ($718.22) -718.22 Gain/Loss-Sale of Investments 0.00 0.00 -745.48 0.00 745.48 0.0 367.100 Unrealized gain/loss on invest 0413012006 GJ APR 06 -UNREALIZED GAIN SALEM $8870.48 8,870.48 05/31/2006 GJ MAY 06 -UNREALIZED LOSS SALEM ($15,594.84) -15,594.84 06/30/2006 GJ JUN 06 -UNREALIZED GAIN SALEM $4,508.64 4,508.64 Unrealized gain/loss on invest 0.00 0.00 -2,215.72 0.00 2,215.72 0.0 368.001 Pension Fund Cont-Employer 04/07/2006 PA VOT PENSION DEPOSIT-PID 04107106 128.84 04/2112006 PA VOT PENSION DEPOSITS-PID 04121106 4,024.34 05/05/2006 PA VOT PENSION DEPOSIT-P/D 05/05106 4,113.10 0511912006 PA VOT PENSION DEPOSIT-PID 05119/06 4,086.99 06/02/2006 PA VOT PENSION DEPOSIT P/D 06/02/06 4,106.76 06/1612006 PA VOT PENSION DEPOSITS-P/D 06/16/06 4,272.04 06/30/2006 PA VOT PENSION DEPOSITS-P/D 06130106 4,344.57 Pension Fund Cont-Employer 0.00 0.00 25,076.64 0.00 -25,076.64 0.0 368.002 Pension Fund Cont-Employee 04/0712006 PA VOT PENSION DEPOSIT-PID 04107106 2,500.77 04/21/2006 PA VOT PENSION DEPOSITS-P/D 04/21106 2,549.23 05/05/2006 PA VOT PENSION DEPOSIT-PID 05/05/O6 2,551.55 05119/2006 PA VOT PENSION DEPOSIT-P/D 05/19106 2,535.35 0610212006 PA VOT PENSION DEPOSIT P/D 06102106 2,547.62 06/16/2006 PA VOT PENSION DEPOSITS-PID 06116/06 2,650.15 0613012006 PA VOT PENSION DEPOSITS-P/D 06/30/06 2,695.14 Pension Fund Cont-Employee 0.00 0.00 18,029.81 0.00 -18,029.81 0.0 369.000 Other Miscellaneous Revenue ~OI2006 GJ JUN O6 -CHANGE IN INVESTMENT SALEM $1,471.50 1,471.50 Other Miscellaneous Revenue 0.00 0.00 1,471.50 0.00 -1,471.50 0.0 Village of Tequesta For the Period: 41112006 to 6130/2006 REVENUE REPORT Page: 2 7/1412006 11:30 am - Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 602 - VillageEmployee Pension-Gen ues Dept: 000 General Miscellaneous Revenues 0.00 0.00 41,616.75 0.00 -41,616.75 0.0 General 0.00 0.00 47,066.55 0.00 -47,066.55 0.0 Revenues 0.00 0.00 47,066.55 0.00 -07,066.55 0.0 • C EXPENDITURE REPORT Page: 1 Village of TFquesta 7/14 12006 For the Period: 4/112006 to 6/30/2006 11:28 am Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 602 - VillageEmployee Pension-Gen Ex itures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 0412412006 GJ CK #1032 - HANSON, PERRY & JENSEN INV #60521 $821.64 821.64 FOR PERIOD ENDED 3115/06 Legal Services 0.00 0.00 821.64 0.00 -821.64 0.0 531.304 Recording Secy Service 04/2412006 GJ CK #1029 -BUSINESS SERVICES CONN. INV #T6-14 - $418.86 418.86 MEETING HELD ON 2/16106 Recording Secy Service 0.00 0.00 418.86 0.00 -418.86 0.0 531.307 Investment Services 04/07/2006 GJ APR 06 -ADMIN. EXPENSES SALEM ($339.99) 339.99 04/2412006 GJ CK #1028 -DANA INVESTMENT $1120.54 STATEMENT OF MANAGEMENT FEES 1,120.54 PERIOD 1ST QTR 2006 0412412006 GJ CK #1030 - BOGDAHN CONSULTING INV #1791 $500.00 500.00 QTRLY FEE 01101106 - 03/31106 04/3012006 GJ APR O6 -WIRE FEE INDEPENDENT COMMUNITY BANK 10.00 05/3112006 GJ MAY 06 -WIRE FEE INDEPENDENT COMMUNITY BANK 10.00 05/3112006 GJ MAY O6 -NET SERVICE CHARGE INDEPENDENT COMMUNITY BANK 15.00 06/30/2006 GJ JUN 06 -WIRE FEE ICB $10.00 10.00 Investment Services 0.00 0.00 2,005.53 0.00 -2,005.53 0.0 531.309 Actuarial Services 04/24/2006 GJ CK #1031 - GABRIEL, ROEDER & SMITH INV #96846 - $4,500.00 -ACTUARIAL VAL. 4,500.00 REP & EMPLOYEE BENEFIT -10/01105 Actuarial Services 0.00 0.00 4,500.00 0.00 -4,500.00 0.0 Operating Expenditures/Expense 0.00 0.00 7,746.03 0.00 -7,746.03 0.0 eneral 0.00 0.00 7,746.03 0.00 -7,746.03 0.0 ept: 165 Pension ~ Acct Class: 530 Operating Expenditures/Expense 536.300 Pension DistributionslRefunds 05/15/2006 GJ MAY 06 -TO RECORD REFUND OF PENSION CONTRIBS. - V. ROLEN 1,052.42 $1,052.42 05/1512006 GJ MAY 06 - TO RECORD W/HOLD TAX FROM V. ROLEN $263.10 263.10 05/25/2006 GJ MAY 06 - TO RECORD W/HOLD TAX FROM WALTER SCHMANSKI $180.78 180.78 0512512006 GJ MAY 06 - TO RECORD REFUND OF PENSION CONTRIBS - W. SCHMANSKI 723.13 $723.13 0611412006 GJ JUN 06 - CK#1038 -RECORD REFUND OF PENSION CONTRIBS. WILLIAM TAYLOR 1,229.91 $1,229.91 06/14/2006 GJ JUN O6 - CK #1039 - TO RECORD W/H TAX FROM WILLIAM TAYLOR $307.48 307.48 Pension Distributions/Refunds 0.00 0.00 3,756.82 0.00 -3,756.82 0.0 Operating Expenditures/Expense 0.00 0.00 3,756.82 0.00 -3,756.82 0.0 Pension 0.00 0.00 3,756.82 0.00 -3,756.82 0.0 Expenditures 0.00 0.00 11,502.85 0.00 -11,502.85 0.0 :7