The URL can be used to link to this page

Home My WebLink AboutDocumentation_Pension Public Safety_Tab 14_08/07/2006VILLAGE OF TEQUESTA PUBLIC SAFETY EMPLOYEES' PENSION TRUST FUND SCHEDULE OF INVESTMENT ACTIVITIES FOR THE QUARTER ENDING JUNE 30, 2006 BEGINNING STATEMENT BALANCE -March 31, 2006 INCREASES CONTRIBUTIONS Employee -Fire 17,180.51 Employee -Police 7,547 q7 Village -Fire 25,654.65 Village -Police 29,358.92 State of Florida -Fire State of Florida -Police 79,741.55 INTEREST & DIVIDENDS Interest 11,728.73 Dividend 6,056.60 17,785.33 OTHER Return of Capital 173.20 Change in Accrued Income 2,967.28 Gain/Loss on Sale of Investments 133.18 UnRealized Gain/Loss on Investments (44,479.94 -41,206.28 TOTAL INCREASES DEDUCTIONS DISTRIBUTIONS Refund of Pension Contributions (14,358.54) Federal Withholding Tax (3,589,63) (17, 948.17 ) ADMINISTRATIVE EXPENSES Bogdahn Consulting (2,000.00) Misc. Charges (Fedex) (55.96) Fee on Dividend (2.56) Salem Trust -Fees (1,452.00) Business Services Connection (306.09) Rockwood Capital Management (7,859.72) FPPTA Membership Dues 0.00 FPPTA Reg. Fee 8 Travel Exps 0.00 Foreign Tax W/Held (300.29) Gabriel, Roeder (6,290.00) Hanson, Perry 8 Jensen PA (780 g8) (19,047.60) Due to General Fund (300.00) TOTAL DEDUCTIONS ENDING STATEMENT BALANCE -June 30, 2006 Transaction in Transit at June 30, 2006 -Pension Contrib. 6/30106 Due to General Fund -Fedex Adjusted Ending Balance -June 30, 2006 BALANCE $ 3,030,474.24 56,320.60 (37,295.77) S 3,049,499.07 9,795.43 (55.96) S 3,039,759.60 f BALANCE SHEET Village of Tequesta Page: 1 7/ 19/2006 9:40 am As of~ 6/30/2006 Balances Fund Type: 600 Trust and Agency Funds Fund:. 601 -Village Employee Pension-Fire Assets Acct Class: 101 Cash and Cash Equivalents ] 01.100 Cash -Bank of America -0.01 Acct Class: 101 Cash and Cash Equivalents -0.01 Acct Class: 103 Investments 135.100 Accrued Income 10,335.00 151.000 Investments 2,334,261.63 Acct Class: 103 Investments 2,344,596.63 Total Assets 2,344,596.62 Liabilities Acct Class: 208 Due to Other Funds 207.001 Due to/from General Fund (001) 43.15 Acct Class: 208 Due to Other Funds 43.15 Total Liabilities 43.15 ReservesBalances Acct Class: 253 F/B - Unreserved/[Jndesignated 271.000 Fund Balance 2,240,747.05 299.000 Change In Fund Balance 103,806.42 Acct Class: 253 F/B - Unreserved/Undesignated 2,344,553.47 Total ReservesBalances 2,344,553.47 Total Liabilities & Balances 2,344,596.62 Villaoe of Teauesta QTR: 3 Fund: 601 - Village Emplovee Pension-Fire Revenues Dept: 000 General Accc Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 361.102 Dividend Income Unrestricted Investment Earnin Acc( 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 540.300 Travel & Per Diem 545.300 Insurance 549.300 Other Misc Chgs & Obligations 554,300 Books, Publ, Subs & Membership 554.600 Seminars & Training -Pensions Operaiinq Expenditures/Expense General Dept: 165 Pension Acct Class: 530 Operating Expenditures/Expense 536.300 Pension Distributions/Refunds Operating Expenditures/Expense Pension Expenditures Net Effect for Fund Village Emplovee Pension-Fire INCOME STATEMENT QUARTER ENDED 6/30/06 Pa4e: 1 7/19/2006 959 am QTD Amd. Bud. YTD Actual QTD Actual 0.00 37,388.01 11,247.28 0.00 12,601.29 4,662.78 0.00 49,989.30 15,910.06 0.00 -7,706.64 98.15 0.00 -18,055.18 -34,229.55 0.00 75,855.02 25,654.65 0.00 45,906.00 17,180.51 0.00 401.42 133.38 0.00 96,400.62 8,837.14 0.00 146,389.92 24,747.20 0.00 146,389.92 24,747.20 0.00 1,149.23 605.26 0.00 486.51 237,22 0.00 14,756.84 8,984.01 0.00 4,849.59 4,849.59 0.00 377.17 0.00 0.00 2,489.12 0.00 0.00 43.15 43.15 0.00 174.08 0.00 0.00 309.64 0.00 0.00 24,635.33 14,729.23 0.00 24,635.33 14,729.23 0.00 17,948.17 0.00 0.00 17,948.17 0.00 0.00 17,948.17 0.00 0.00 42,583.50 14,729.23 0.00 103, 806.42 10, 017.97 'Skipped Budgeted & Unbudgeted $0 Balance Accounts REVENUE REPORT Village o(Tequesta For the Period: 4/1/2006 to 6/30,2006 Page: 1 7/19/2006 10:06 am Original Bud. Amended Bud. pTD Actual Encumb. YTD UnencBal % Bud Fund: 601 -Village Employee Pension-Fire Revenues Dept. 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 04/30/2006 GJ APR 06 -INTEREST SALEM $4,159.33 3,206.75 04/30/2006 GJ APR 06 -REV MAR O6 ACCRUAL SALEM - $10,475.75 $,118,71 04/30/2006 GJ APR 06 -ACCRUED INCOME SALEM - $9542.76 7,357.47 05/31/2006 GJ MAY 06 -INTEREST -SALEM PRO RATA SHARE $3,605.18 2,776.43 05/31/2006 GJ MAY 06 -REV. APR 06 ACCRUED INCOME SALEM PRO RATA $9,542.76 -7,357.47 05/31/2006 GJ MAY 06 -ACCRUED INCOME SALEM PRO RATA SHARE $12,911.11 9,942.85 06/30/2006 GJ JUN 06 -INTEREST -SALEM TRUST PRO RATA SHARE $3,964.22 3,047.81 06/30/2006 GJ JUN 06 REV, MAY 06 ACCRUED INCOME SALEM -PRO RATA $12,911.11 -9,942.85 06/30/2006 GJ JUN 06 -ACCRUED INCOME SALEM -PRO RATA $13,443.03 10,335.00 Interest Income 0.00 0.00 11,247.28 0.00 -11 247.28 0 0 361.102 Dividend Income , . 04/30/2006 GJ APR 06 -DIVIDEND SALEM - $1,156.61 881,72 05/31/2006 GJ MAY 06 -DIVIDENDS -SALEM PRO RATA SHARE $2,945.81 2,268.63 06/30/2006 GJ JUN D6 -DIVIDEND -SALEM TRUST PRO RATA SHARE $1,954.18 1,502.43 Dividend Income 0.00 0.00 4,662.78 0.00 -0,662.78 0.0 Unrestricted Investment Earnin 0.00 0.00 15,910.06 0.00 -15,910.06 0.0 Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 04/30/2006 GJ APR 06 -LOSS ON SALE OF INVEST SALEM ($2530.41) -1,950.95 "x31/2006 GJ MAY 06 -GAIN ON SALE OF INVESTMENT SALEM -PRO RATA SHARE $1,029.70 792.97 30/2006 GJ JUN 06 -GAIN ON SALE OF INVESTMENT SALEM -PRO RATA $1,633.89 1,256.13 Gain/Loss-Sale of Investments 0.00 0.00 98.15 0.00 -98 15 0 0 367.100 Unrealized gain/loss on invest . . 04/30/2006 GJ APR O6 UNREALIZED GAIN SALEM - $21803.84 16,810.76 05131/2006 GJ MAY 06 -UNREALIZED LOSS SALEM PRO RATA SHARE ($62,572.71) -48,187.24 06/3012006 GJ JUN 06 -UNREALIZED LOSS SALEM -PRO RATA ($3711.07) -2,853.07 Unrealized gainlloss on invest 0.00 0.00 -34,229.55 0.00 34 229 55 0 0 368.001 Pension Fund Cont-Employer , . . 04/0712006 PA VOT PENSION DEPOSIT-PID 04/07106 2,238.67 04/2112006 PA VOT PENSION DEPOSITS-P/D 04/21/06 3,719,94 05105(2006 PA VOT PENSION DEPOSIT-PID D5/05/06 4,060.49 05/19/2006 PA VOT PENSION DEPOSIT-P/D 05/19/06 3,936.21 06/02/2006 PA VOT PENSION DEPOSIT PID 06/02/06 3,743.00 06/16/2006 PA VO7 PENSION DEPOSITS-PID 06116/06 4,211.26 06/30/2006 PA VOT PENSION DEPOSITS-P/D 06/30/06 3,745.10 Pension Fund Cont-Employer 0.00 0.00 25,654.65 0.00 -25 654 65 0 0 368.002 Pension Fund Cont-Employee , . . 04/0712006 PA VOT PENSIOfJ DEPOSIT-PID 04/07/06 2,378.71 04/21/2006 PA VOT PENSION DEPOSITS-PID 04/21/06 2,351.45 05105/2006 PA VOT PENSION DEPOSIT-PID 05/05/06 2,566.73 05/1912006 PA VOT PENSION DEPOSIT-P/D 05119106 2,488.17 06/02/2006 PA VOT PENSION DEPOSIT PID 06/02/06 2,366.04 06/1612006 PA VOT PENSION DEPOSITS-P/D 06/16/06 2,662.04 06!30(2006 PA VOT PENSION DEPOSITS P/D 06/30/06 2,367.37 Pension Fund Cont Employee 0.00 0.00 17,180.51 0.00 -17 180 51 0 0 Other Miscellaneous Revenue , . . _.,/31/2006 GJ MAY 06 -RETURN OF CAPITAL SALEM PRO RATA SHARE $173.20 133.38 Other Miscellaneous Reve ue 0.00 0.00 133.38 0.00 -133.38 0.0 Village of Tequesta For the Period: 4/112006 to 6/30/2006 REVENUE REPORT Page: 2 7ltg/2006 10:06 am Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud rung: buy - vmage tmpioyee Nens~on-F~re Revenues Miscellaneous Revenues General 0.00 0.00 8,837.14 0.00 0.00 24,747.20 0.00 x,837.14 0.0 0.00 -24,747.20 0.0 Revenues 0.00 0,00 24,747.20 0.00 -24,747.20 0.0 EXPENDITURE REPORT Village of Tequesta Page: 1 For the Period: 411/2006 to 6/30/2006 7/19/2006 _ 1 0:08 am Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud Fund: 601 -Village Employee Pension-Fire Expenditures Dept. 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 04/1812006 GJ APR 06 - HANSON, PERRY & JENSEN SALEM PRO RATA -LEGAL SVS $780.98 605.26 LEGAL SVS THRU 3/15106 Legal Services 531.304 Recording Secy Service 0.00 0.00 605.26 0.00 -605.26 0.0 04/18/2006 GJ APR 06 -BUSINESS SERVICES CONNECT SALEM PRO RATA $306.09 237.22 ATTEND AT t]TRLY MTG 2114/06 Recording Secy Service 0.00 0.00 237.22 0.00 -237 22 0 0 531.307 Investment Services . . 04!18/2006 GJ APR 06 - BOGDAHN CONSULTING SALEM PRO RATA $2000.00 1,550.00 QTRLY FEE 01/01/06 - 03/31/06 04!18/2006 GJ APR 06 - ROCKWOOD CAPITAL MGT FEE SALEM PRO RATA $4038.09 3,129.52 MGT FEE 12/31/05 TO 3/31/06 04/18/2006 GJ APR 06 - ROCKWOOD CAPITAL MGT FEE 6/30/05 TO 9130/05 -SALEM $3,821.63 2,961.76 04/30/2006 GJ APR O6 ADMINISTRATION EXPENSES SALEM -($1,452.00) 1,119.49 04/3012006 GJ APR 06 FOREIGH TAX W/HELD SALEM - ($23.06) 17,78 05/31/2006 GJ MAY O6 -FOREIGN TAX W/HELD SALEM PRO RATA SHARE ($277.23) 213.49 05/31/2006 GJ MAY 06 -FEE ON DIVIDEND SALEM PRO RATA SHARE ($2.56) 1.97 Investment Services 0.00 0.00 8,994.01 0.00 -8 994 01 0 0 531.309 Actuarial Services , . . 05!12/2006 GJ MAY O6 • GABRIEL, ROEDER SMITH SERV. RENDERED THRU 3/31/06 4,849.59 SALEM -PRO RATA $6,290.00 Actuarial Services 0.00 0.00 4,849.59 0.00 -4 849 59 0 0 549.300 Other Misc Chgs & Obligations , . . 06/08/2006 GJ JUN 06 - PY1~1T DUE TO GEN. FUND FOR FEDEX POSTAGE $55.96 43.15 Other Misc Chgs & Obligations 0.00 0.00 43.15 0.00 -43,15 0.0 Operating Expenditures/Expense 0.00 0.00 14,729.23 0.00 -14,729.23 0.0 General 0.00 0.00 14,729.23 0.00 -14,729.23 0.0 Expenditures 0.00 0.00 14,729.23 0.00 -14,729.23 0.0 REVENUE/EXPENDITURE REPORT Village of Tequesta - - - ~ Page: 1 For the Period: 10/1/2005 to 9/30/2006 _ , - i~ 8/1/2006 .. 9:54 am Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud 601 -Village Employee Pension-Fire Hues Dept 000 Ge neral Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 10/31/2005 GJ OCT 05 INTEREST -SALEM PRO RATA SHARE $4735.18 3,658.90 10/31/2005 GJ OCT 05 REV. SEP05 ACCRUED INCOME SALEM -PRO RATA $7502.19 -5,898.97 10/31/2005 GJ OCT 05 ACCRUED INCOME SALE PRO RATA $7948.04 6,141.45 11/30/2005 GJ NOV 05 INTEREST SALEM -PRO RATA SHARE $3153.58 2,439.20 11/30/2005 GJ NOV 05 REV. OCT 05 ACCRUED INCOME SALEM -PRO RATA SHARE $7948.04 -6,141.45 11/30/2005 GJ NOV 05 ACCRUED INCOME SALEM PRO RATA SHARE $12701.38 9,824.52 12131/2005 GJ DEC 05 -REV. NOV 05 ACCRUED INCOME SALEM -PRO RATA SHARE $12,701.38 -9,824.52 12/31/2005 GJ DEC 05 ACCRUED INCOME SALEM -PRO RATA SHARE $14,623.18 11,293.48 12/31/2005 GJ DEC 05 -INTEREST -SALEM PRO RATA SHARE $2,704.65 2,088.82 01/31/2006 GJ JAN O6 -INTEREST -SALEM PRO RATA SHARE $2693.36 2,083.91 01/31/2006 GJ JAN 06 -REV. DEC 05 ACC, INCOME SALEM -PRO RATA $14623.18 -11,293.48 01/31/2006 GJ JAN O6 -ACCRUED INCOME -SALEM PRO RATA SHARE $15073.02 11,662.00 02/28/2006 GJ FEB 06 REV JAN 06 ACCRUED INCOME SALEM PRO RATA SHARE$15,073.02 -11,662.00 02/28/2006 GJ FEB 06 ACCRUED INCOME SALEM PRO RATA SHARE $14,492.11 11,566.69 02/28/2006 GJ FEB 06 INTEREST SALEM PRO RATA SHARE $6579.18 5,092.62 03/3112006 GJ MAR 06 INTEREST $11,041.40 SALEM -PRO RATA SHARE 8,557.54 0313112006 GJ MAR 06 -REV FEB 06 ACCRUED INCOME SALEM PRO RATA $14,921.11 -11,566.69 03/31/2006 GJ MAR 06 ACCRUED INCOME SALEM -PRO RATA $10,475.75 8,118.71 04130/2006 GJ APR 06 -INTEREST SALEM $4,159.33 3,206.75 04/30/2006 GJ APR 06 -REV MAR O6 ACCRUAL SALEM - $10,475.75 -8,118.71 04/30/2006 GJ APR 06 -ACCRUED INCOME SALEM - $9542.76 7,357.47 -31/2006 GJ MAY 06 -INTEREST -SALEM PRO RATA SHARE $3,605.18 2,776.43 3112006 GJ MAY O6 -REV, APR 06 ACCRUED INCOME SALEM PRO RATA $9,542.76 -7,357.47 3112006 GJ MAY 06 -ACCRUED INCOME SALEM PRO RATA SHARE $12,911.11 9,942.85 6/30/2006 GJ JUN O6 -INTEREST -SALEM TRUST PRO RATA SHARE $3,964.22 3,047.81 06/30/2006 GJ JUN 06 REV. MAY 06 ACCRUED INCOME SALEM -PRO RATA $12,911.11 -9,942.85 06/30/2006 GJ JUN 06 -ACCRUED INCOME SALEM -PRO RATA $13,443.03 10,335.00 Interest Income 0.00 0.00 37,388.01 0.00 0.00 -37,388.01 0.0 361.102 Dividend Income 10/31/2005 GJ OCT 05 -DIVIDENDS -SALEM PRO RATA SHARE $574.90 444.23 11/30/2005 GJ NOV 05 DIVIDENDS SALEM -PRO RATA SHARE $1793.23 1,387.01 12/31/2005 GJ DEC 05 -DIVIDENDS -SALEM PRO RATA SHARE $2,910.80 2,248.03 01/31/2006 GJ JAN 06 -DIVIDENDS -SALEM PRO RATA SHARE $2289.16 1,771.17 02/28/2006 GJ FEB O6 DIVIDENDS SALEM PRO RATA SHARE $1,222.00 945.89 03/3112006 GJ MAR 05 -DIVIDENDS $1,473.70 SALEM -PRO RATA SHARE 1,142.18 04/30/2006 GJ APR 06 -DIVIDEND SALEM - $1,156.61 891.72 05/31/2006 GJ MAY 06 -DIVIDENDS -SALEM PRO RATA SHARE $2,945.81 2,268.63 06/30/2006 GJ JUN 06 -DIVIDEND -SALEM TRUST PRO RATA SHARE $1,954.18 1,502.43 Dividend Income 0.00 0.00 12,601.29 0.00 0.00 -12,601.29 0.0 Unrestricted I nvestment Earnin 0.00 0.00 49,989.30 0.00 0.00 -49,989.30 0.0 Acct Cla ss: MISC Miscellaneous Revenues 367.000 Gain/Loss-S ale of Investments 10/31/2005 GJ OCT 05 LOSS ON SALE OF INVEST SALEM PRO RATA SHARE ($5344.86) -0,129.97 11/30/2005 GJ NOV 05 LOSS ON SALE OF INVESTMENT SALEM PRO RATA ($1189.53) -920.10 12/3112005 GJ DEC 05 -LOSS ON SALE OF INVEST SALEM -PRO RATA ($1,460.50) -1,127.94 01/3112006 GJ JAN O6 -LOSS ON SALE OF INV. -SALEM PRO RATA SHARE - ($1415.28) -1,095.00 n2/2812006 GJ FEB 06 GAIN ON SALE OF INVEST SALEM PRO RATA SHARE $1190.80 921.80 3112006 3012006 GJ GJ MAR 06 LOSS ON SALE OF INVEST APR 06 -LOSS ON SALE OF INVEST SALEM -PRO RATA SHARE ($1875.59) SALEM ($2530.41) -1,453.58 -1,950.95 /31/2006 GJ MAY 06 -GAIN ON SALE OF INVESTMENT SALEM -PRO RATA SHARE $1,029.70 792.97 06/3012006 GJ JUN 06 -GAIN ON SALE OF INVESTMENT SALEM -PRO RATA $1,633.89 1,256.13 REVENUEIEXPENDITURE REPORT Village of Tequesta For the Period: 1011/2005 to 9/30/2006 Page: 2 811/2006 9:54 am Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud 601 -Village Employee Pension-Fire R ues Dept: 000 Gen eral Acct Cla ss: MISC Miscellaneous Revenues Gain/L oss-S ale of Investments 0.00 0,00 -7,706.64 0.00 367.100 Unreali zed g ainlloss on invest 10/31/2005 GJ OCT 05 UNREALIZED LOSS -SALEM PRO RATA SHARE ($105,979,09) -81,890.04 11/30/2005 GJ NOV 05 UNREALIZED GAIN SALEM -PRO RATA $56481.15 43,688.17 12/3112005 GJ DEC 05 -UNREALIZED GAIN SALEM -PRO RATA SHARE $12,658,09 9,775.84 01/31/2006 GJ JAN 06 -UNREALIZED GAIN -SALEM PRO RATA SHARE $67115.50 51,927.26 02/28/2006 GJ FEB 06 UNREALIZED LOSS SALEM PRO RATA SHARE ($34,925.68) -27,035.97 03/31/2006 GJ MAR 06 -UNREALIZED GAIN -SALEM PRO RATA SHARE $25,431.11 19,709.11 04/30/2006 GJ APR O6 UNREALIZED GAIN SALEM - $21803.84 16,810.76 05/31/2006 GJ MAY 06 -UNREALIZED LOSS SALEM PRO RATA SHARE ($62,572.71) -48,187.24 06/30/2006 GJ JUN 06 -UNREALIZED LOSS SALEM -PRO RATA ($3711.07) -2,853.07 Unreal ized gainlloss on invest 0.00 0.00 -18,055.18 0.00 368.001 Pensio n Fun d Cont-Employer 10/07/2005 PA VOT PENSION DEPOSITS-P/D 10/07/05 213.47 10/07/2005 PA VOT PENSION DEPOSITS-PID 10107/05 271.79 10/07/2005 RE RVRS JE#146204 prior year accrual FYE05 ACCRUED CONTRIB RECEIVABLE -2,049.20 10/27/2005 PA VOT PENSION DEPOSIT-PID 10/27/05 3,754.00 11/01/2005 PA VOT PENSION DEPOSITS-P/D 11/01/05 4,696.40 11/18/2005 PA VOT PENSION DEPOSIT-PID 11/18/05 4,099.27 12/0212005 PA VOT PENSION DEPOSITS-P/D 12/02105 4,341.78 12116/2005 PA VOT PENSION DEPOSITS-PID 12116/05 3,755.47 "'12912005 PA VOT PENSION DEPOSITS-PID 12129/05 4,185.03 1312006 PA VOT PENSION DEPOSITS-PID 01/13106 4,966.73 7/2006 PA VOT PENSION DEPOSITS-PID 01/27/06 4,234.45 ,._ 110/2006 PA VOT PENSION DEPOSITS-PID 02/10/06 3,739.03 02/2412006 GJ VOT PENSION DEPOSITS-PID 02/24/06 5,285.16 03/1012006 PA VOT PENSION DEPOSIT PID 03/10/06 4,793.00 03/2412006 PA VOT PENSION DEPOSIT PID 03124/06 3,913.99 04/0712006 PA VOT PENSION DEPOSIT-PID 04/07/06 2,238.67 04121/2006 PA VOT PENSION DEPOSITS-PID 04/21/06 3,719,92 0510512006 PA VOT PENSION DEPOSIT-PID 05/05/06 _..__ 4,060.49 05119/2006 PA VOT PENSION DEPOSIT-PID 05/19/06 3,936.21 06/02/2006 PA VOT PENSION DEPOSIT PID 06/02/06 3,743.00 06116/2006 PA VOT PENSION DEPOSITS-PID 06116/06 4,211.26 06/30/2006 PA VOT PENSION DEPOSITS-P1D 06130/06 3,745.10 07/14/2006 PA _ . _. VOT PENSION DEPOSIT-P/D 07/14/06 _ _. 3,742.18 07/2812006 PA VOT PENSION DEPOSITS-P/D 07/28/06 3,756.93 Pension Fund Cont-Employer 0.00 0.00 83,354.13 0.00 368.002 Pensio n Fun d Cont-Employee 10/07/2005 PA VOT PENSION DEPOSITS-PID 10/07/05 131.00 10/07/2005 PA VOT PENSION DEPOSITS-PID 10/07/05 166.79 10/07/2005 RE RVRS JE#146204 prior year accrual FYE05 ACCRUED CONTRIB RECEIVABLE -3,339.19 10/27/2005 PA VOT PENSION DEPOSIT-P/D 10/27/05 2,303.76 11101/2005 PA VOT PENSION DEPOSITS-PID 11101/05 2,882.10 11/18/2005 PA VOT PENSION DEPOSIT-PID 11/18/05 2,515.65 12/02/2005 PA VOT PENSION DEPOSITS-P/D 12102/05 __ 2,664.48 12/16/2005 PA VOT PENSION DEPOSITS-PID 12/16/05 2,304.69 12129/2005 PA VOT PENSION DEPOSITS-P/D 12/29/05 _ __ _ _ _ 2,568.29 ' 11312006 PA VOT PENSION DEPOSITS-P/D 01/13/06 3,047.99 2712006 PA VOT PENSION DEPOSITS-PID 01/27/06 2,598.61 0/2006 PA VOT PENSION DEPOSITS-PID 02110/06 2,294.58 2/2412006 GJ VOT PENSION DEPOSITS-PID 02/24/06 3,243.41 0.00 7,706.64 0.0 0.00 18,055.18 0.0 0.00 -83,354.13 0.0 REVENUEIEXPENDITURE REPORT Village of Tequesta For the Period: 10/112005 to 9/30/2006 Page: 3 8/112006 9:54 am Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD Unenc6al % Bud ou ~ - visage cmpioyee tension-tire ues Dept: 000 General Acct Class: MISC Miscellaneous Revenues 03/10/2006 PA VOT PENSION DEPOSIT P/D 03110/06 0312412006 PA VOT PENSION DEPOSIT P/D 03/24/06 04/07/2006 PA VOT PENSION DEPOSIT-P/D 04/07/06 04121/2006 PA VOT PENSION DEPOSITS-P/D 04/21/06 05/05/2006 PA VOT PENSION DEPOSIT-PID 05/05/06 05/19/2006 PA VOT PENSION DEPOSIT-PID 05/19106 06102/2006 PA VOT PENSION DEPOSIT P/D 06/02/06 06/16/2006 PA VOT PENSION DEPOSITS-P/D 06/16/06 06130/2006 PA VOT PENSION DEPOSITS-PID 06130/06 0711412006 PA VOT PENSION DEPOSIT-P/D 07/14106 07/28/2006 PA VOT PENSION DEPOSITS-PID 07/28106 Pension Fund Cont-Employee 369.000 Other Miscellaneous Revenue 11130/2005 GJ NOV 05 RETURN OF CAPITAL 02/28/2006 GJ FEB O6 RETURN OF CAPITAL 05131/2006 GJ MAY 06 -RETURN OF CAPITAL Other Miscellaneous Revenue Miscellaneous Revenues 2,941.38 2,401.95 -~ 2,378.71 2, 351.45 2,566.73 2,488.17 2,366.04 2,662.04 2,367.37 ... 2,365.52 2,374.85 0.00 0.00 50,646.37 0.00 0.00 -50,646.37 0.0 SALEM -PRO RATA $173.20 133.97 SALEM PRO RATA SHARE $173.20 134.07 SALEM PRO RATA SHARE $173.20 133.38 0.00 0.00 401.42 0.00 0.00 -401.42 0.0 0.00 0.00 108,640.10 0.00 0.00 -108,640.10 0.0 General 0.00 ~es 0.00 0.00 Expenditures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 02!24/2006 GJ FEB 05 - HANSON, PERRY &JENSEN SALEM -PRO RATA - $703.07 04118/2006 GJ APR O6 - HANSON, PERRY &JENSEN SALEM PRO RATA -LEGAL SVS $780.98 Legal Services 3,944.00 3,944.00 531.304 Recording Secy Service 02/24/2006 GJ FEB 05 -BUSINESS SERVICES CONNECT SALEM -PRO RATA $322.20 04/18/2006 GJ APR 06 -BUSINESS SERVICES CONNECT SALEM PRO RATA $306.09 Recording Secy Service 789.00 789.00 531.307 Investment Services 11130/2005 GJ NOV 05 ADMINISTRATION FEES SALEM PRO RATA SHARE $750.00 12/31/2005 GJ DEC 05 WIRE FEE WACHOVIA PRO RATA SHARE $25.00 01/31/2006 GJ JAN 06 -ADMIN. EXPS. -SALEM PRO RATA SHARE ($750.00) 01/31/2006 GJ JAN 06 -FOREIGN TAX WIH -SALEM PRO RATA SHARE ($30.57) 02/24/2006 GJ FEB 05 - BOGDAHN CONSULTING SALEM -PRO RATA $2000.00 02/24/2006 GJ FEB 05 - ROOCKWOOD CAPITAL SALEM -PRO RATA $3893.07 04/18/2006 GJ APR 06 - BOGDAHN CONSULTING SALEM PRO RATA $2000.00 04/18/2006 GJ APR O6 - ROCKWOOD CAPITAL MGT FEE SALEM PRO RATA $4038.09 04118/2006 GJ APR O6 - ROCKWOOD CAPITAL MGT FEE 6130/05 TO 9130/05 -SALEM $3,821.63 04130/2006 GJ APR O6 ADMINISTRATION EXPENSES SALEM • ($1,452.00) 04/30/2006 GJ APR O6 FOREIGH TAX W/HELD SALEM - ($23.06) 05/31/2006 GJ MAY 06 -FOREIGN TAX W/HELD SALEM PRO RATA SHARE ($277.23) '31/2006 GJ MAY 06 - FEE ON DIVIDEND SALEM PRO RATA SHARE ($2.56) Investment Services 18,931.00 18,931.00 5 9 Actuarial Services 05112/2006 GJ MAY 06 - GABRIEL, ROEDER SMITH SERV. RENDERED THRU 3/31106 0.00 0.00 -158,629.40 0.0 0.00 158,629.40 158,629.40 0.00 0.00 -158,629.40 0.0 543.97 605.26 LEGAL SVS THRU 3/15/06 1,149.23 0.00 0.00 2,794.77 29.1 249.29 237.22 ATTEND AT OTRLY MTG 2/14/06 486.51 0.00 0.00 302.49 61,7 580.13 19.30 580.28 23.65 1,547.40 3,012.07 1,550.00 QTRLY FEE 01/01/06 - 03/31/06 3,129.52 MGT FEE 12/31/05 TO 3/31/06 2,961.76 1,119.49 17.78 213.49 1.97 14,756.84 0.00 0.00 4,849.59 SALEM -PRO RATA $6,290.00 4,174.16 78.0 REVENUEIEXPENDITURE REPORT Page: 4 Village of Tequesta 8/1!2006 For the Period: 1011/2005 to 9130/2006 9:54 am Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud 601 -Village Employee Pension-Fire E ditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense Actuarial Services 4,891.00 4,891.00 4,849.59 0.00 0.00 41.41 99.2 Other Contractual Services 789.00 789.00 0.00 0.00 0.00 789.00 0.0 540.300 Travel & Per Diem 03/1512006 GJ FEB 06 -REGIST. FEE 8 TRAVEL EXPS TO ATTEND FPPTA CONF 377.17 REG. FEE $400 & TRAVEL $487.23 Travel & Per Diem 1,183.00 1,183.00 377.17 0.00 0.00 805.83 31.9 545.300 Insurance 12/12/2005 GJ OCT 05 TO OCT O6 - ACORDIA LIABILITY INSURANCE $32 18.00 2,489.12 Insurance 2,682.00 2,682.00 2,489.12 0.00 0.00 192.88 92.8 549.300 Other Misc Chgs 8 Obligations 06/08/2006 GJ JUN 06 - PYMT DUE TO GEN. FUND FOR FEDEX POSTAGE $55.96 43.15 Other Misc Chgs & Obligations 0.00 0.00 43.15 0.00 0.00 -43.15 0.0 554.300 Books, Publ, Subs & Membership 0212412006 GJ FEB OS -FPPTA MEMBERSHIP DUES SALEM -PRO RATA $225.0 0 174.08 Books, Publ, Subs 8 Membership 0.00 0.00 174.08 0.00 0.00 -174.08 0.0 554.600 Seminars & Training -Pensions 03/15/2006 GJ FEB 06 -REGIST. FEE 8 TRAVEL EXPS TO ATTEND FPPTA CONF 309.64 REG. FEE $400 & TRAVEL $487.23 Seminars&Training-Pensions 1,183.00 1,183.00 309.64 0.00 0.00 873.36 26.2 Operating ExpenditureslExpense 34,392.00 34,392.00 24,635.33 0.00 0.00 9,756.67 71.6 3eneral 34,392.00 34,392.00 24,635.33 0.00 0.00 9,756.67 71.6 ~pC 165 Pension Acct Class: 530 Operating ExpenditureslExpense 536.300 Pension Distributions/Refunds 03131/2006 GJ MAR 06 - ALEX NATHANSON REF. OF PENSION CONTRI B $17,948.17 17,948.17 Pension Distributions/Refunds 0.00 0.00 17,948.17 0.00 0.00 -17,948.17 0.0 Operating ExpenditureslExpense 0.00 0.00 17,948.17 0.00 0.00 -17,948.17 0.0 Pension 0.00 0.00 17,948.17 0.00 0.00 -17,948.17 0.0 Expenditures 34,392.00 34,392.00 42,583.50 0.00 0.00 -8,191.50 123.8 Net Effect for Village Employee Pension-Fire -34,392.00 -34,392.00 116,045.90 0.00 0.00 -150,437.90 Change in Fund Balance: 116,045.90 • BALANCE SHEET Village of Tequesta As of: 6/30/2006 • Fund Type: 600 Trust and Agency Funds Fund: 603 -Village Employee Pension-Polic Assets Acct Cass: 101 Cash and Cash Equivalents 101.100 Cash -Bank of America Acct Class: 101 Cash and Cash Equivalents Acct Class: 103 Investments 135.100 Accrued Income ] 51.000 Investments Acct Class: 103 Investments Liabilities Acct Class: 208 Due to Other Funds 207.001 Due to/from General Fund (001) Acct Class: 208 Due to Other Funds Total Liabilities Reserves/Balances Acct Class: 253 FB - Unreserved/Undesignated 271.000 Fund Balance 299.000 Change In Fund Balance • Acct Class: 253 F/B - Unreserved/Undesignated Total ReservesBalances Total Liabilities & Balances Page: I 7/ ] 9/2006 9:41 am Balances 0.01 Total Assets 0.01 3,108.03 701,856.73 704,964.76 704,964.77 12.81 12.81 12.81 656,510.66 48,441.30 704,951.96 704,951.96 704,964.77 INCOME STATEMENT QUARTER ENDED 6/30/06 Village of Teguesla Page: 3 7/192006 9•~~ am UIK::3 Fund: 603 -Village Employee Pension-Polk Revenues 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 GainlLoss-Sale of Investments 367,100 Unrealized gainlloss on invest 368.001 Pension Fund Conf-Employer 368.002 Pension Fund Conf-Employee 369.000 Other Miscellaneous Revenue Miscellaneous Revenues General Revenues Expenditures Dept: 000 General Acct Class, 530 Operating Expendi(ures/Expense 531.301 Legal Services 531.304 P,ecording Secy Service 531.307 Investment Services 531.309 Ac(uarial Services 540.300 Travel 8 Per Diem 545.300 Insurance 549.300 Other hnisc Chgs & Obligations • 554.300 Books, Publ, Subs & Membership 554.600 Seminars & Training -Pensions Operat~na ExpendilureslExpense Genera! Dept 165 Pension Acct Class 530 Operating Expendiiures/Expense 536.300 Pension DistributionslRefunds Operating Expendiiures/Expense Pension Expenditures Net Effect for Fund Village Employee Pension-Polk Grand Total Net Effect: • QTD Amd. Bud. YTD Actual QTD actual 0.00 11,188.91 3,448.73 0.00 3,719.10 1,303.82 0.00 14, 908.01 4,8412.55 0.00 -2,255.14 35.03 0.00 -5,643.68 -10,20.39 0.00 51,000.63 29,3518.92 0.00 20,782.33 7,5417,47 0.00 118.18 39.82 0.00 64,002.32 26,730.85 0.00 78,910.33 31,57'3.40 0.00 78,910.33 31,57'3.40 0.00 334.82 1 T~5.72 0.00 141.78 6.87 0.00 4,306.37 2,6210.56 0.00 1,440.41 1,44(0,41 0.00 110.06 m.00 0.00 728.88 m.00 0.00 12.81 12.81 0.00 50.92 m.00 0.00 90.36 ®.00 0.00 7,216.41 4,31&3.37 0.00 7,216.41 4,318.37 0.00 23,252.62 (0.00 0.00 23,252.62 m.00 0,00 23,252.62 m.00 0.00 30,469.03 4,318.37 0.00 48,441.30 27,25 03 0.00 307,311.52 72,83 70 'Skipped Budgeted 8 Unbudgeled $0 Balance Accounts REVENUE REPORT Village of Tequesta For the Period: 4/112006 to 6/30/2006 0.00 0.00 3,448.73 _ Original Bud. Amended Bud. QTD Actual Encumb YTD UnencBal % Bud 603 -Village Employee Pension-Polk Revenues Dept 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 04!30/2006 GJ APR 06 -INTEREST SALEM $4,159.33 952.58 04/30/2006 GJ APR 06 -REV MAR 06 ACCRUAL SALEM - $10,475.75 -2,357.04 04/30/2006 GJ APR 06 -ACCRUED INCOME SALEM - $9542.76 2,185.29 05/31/2006 GJ MAY 06 -INTEREST -SALEM PRO RATA SHARE $3,605.18 828.75 05/31/2006 GJ MAY 06 -REV. APR 06 ACCRUED INCOME SALEM PRO RATA $9,542.76 -2,185.29 05/3112006 GJ MAY 06 -ACCRUED INCOME SALEM PRO RATA SHARE $12,911.11 2,968.26 06/30/2006 GJ JUN 06 -INTEREST -SALEM TRUST PRO RATA SHARE $3,964.22 916.41 06/3012006 GJ JUN 06 REV. MAY 06 ACCRUED INCOME SALEM -PRO RATA $12,911.11 -2,968.26 06/30/2006 GJ JUN 06 -ACCRUED INCOME SALEM -PRO RATA $13,443.03 3 108.03 Interest Income 361.102 Dividend Income 04/30/2006 GJ APR 06 • DIVIDEND 05/31/2006 GJ MAY 06 -DIVIDENDS -SALEM 06/30/2006 GJ JUN 06 - DI'/IDEND -SALEM TRUST Dividend Income Page: 5 7/19/2006 10:06 am 0.00 -3,448.73 0.0 0.00 -1,393.82 0.0 SALEM - $1,156.61 264.89 PRO RATA SHARE $2,945.81 677.18 PRO RATA SHARE $1,954.18 451.75 0.00 0.00 1,393.82 Unrestricted Investmen(Earnin 0.00 0.00 Acc(Class: MISC Miscellaneous Revenues 367.000 GainlLoss Sale of Investmen(s 04/3012006 GJ APR 06 - LOSS ON SALE OF INVEST SALEM ($2530.41) ^513112006 GJ MAY 06 -GAIN ON SALE OF INVESTMENI SALEM-PRO RATA SHARE $1,029.70 .012006 GJ JUN 06 • GAIN ON SALE OF INVESTMENT SALEM -PRO RATA $1,633.89 Gain/Loss-Sale of Inveslmen~s 0.00 0.00 367.100 Unrealized gainlloss on ~n:es( 04/30/2006 GJ APR 06 UNREALIZED GAIN SALEM-$21803.84 05/31/2006 GJ MAY 06 -UNREALIZED LOSS SALEM PRO RATA SHARE ($62,572.71) 06/30/2006 GJ JUN 06 • UNREALIZED LOSS SALEM -PRO RATA ($3711.07) Unrealized gain/loss on invest 368.001 Pensio n Fun d Conl-Emplc; _r 04/0712006 PA VOT PENSION DEPOSIT•P/D 04107/06 04/2112006 PA VOT PENS!CN DEPOSITS-PID 04/21/06 05/05/2006 PA VOT PENSIC~ I DEPOSIT-P/D 05/05/06 05/1912006 PA VOT PENSION DEPOSIT-P/D 05/19106 06/02/2006 PA VOT PENS/ON DEPOSIT PID 06/02/06 06/16/2006 PA V07 PENS'~r1 DEPOSITS-P/D 06116/06 06/30/2006 PA VOT PENSIOfI DEPOSITS-P/D 06/30106 0.00 0.00 Pension Fund Cont-Emplcy~r 368.002 Pensio n Fun d Cont-Employee 04/07/2006 PA VOT PEN51~~N DEPOSIT-PID 04/07/06 04/2112006 PA VOT PENS.-N DEPOSITS-P/004/21/06 05/0512006 PA VOT PENSION DEPOSIT-P/D 05/05106 05/19/2006 PA VOT PENSIC`N DEPOSIT-P/D 05/19106 06/02/2006 PA VOT PENSC D_POSIT PID 06/02/06 06/16/2006 PA VOT PENSD~N DEPOSITS-P/D 06116/06 06/30/2006 PA VOT PENSION DEPOSITS-P/D 06/30/06 Pension Fund Cont Empl. vee `7 Other Miscellaneous Revenue 112006 GJ MAY 06 - RDTURN OF CAPITAL Other Miscellaneous Rev~.n ~e 0.00 0.00 4,842.55 -579.46 236.73 377.76 35.03 4,993.08 -14,385.47 -858.00 -10,250.39 14,517.54 2,321.44 2,658.15 2,346.92 2,456.57 2,491.39 2,566.91 0.00 -0,842.55 0.0 0.00 -35.03 0.0 0.00 10,250.39 0.0 29,358.92 0.00 -29,358.92 D.0 1,094.69 1,009.32 1,155.72 1,020.40 1,068.08 1,083.21 1,116.05 0.00 0.00 7,547.47 0.00 -7,547.47 0.0 SALEM PRO RATA SHARE $173.20 39.82 0.00 0.00 39.82 0.00 -39.82 0.0 REVENUE REPORT Village of Tequesta Page: 6 For the Period: 4/1/2006 to 6/3012006 7/19/2006 10:06 am Original Bud. Amended Bud. pTD Actual Encumb. YTD UnencBal % Bud 603 -Village Employee Pension-Polio Revenues Dept: 000 General Miscellaneous Revenues 0.00 0.00 26,730.85 0.00 -26,730.85 0.0 General 0.00 0.00 31,573.40 0.00 -31,573.40 0.0 Revenues 0.00 0.00 31,573.40 0.00 -31,573.40 0.0 • Page: 3 /illage of Tequesta 7119120D6 or tha Period. 4/112006 to 6/30/2006 10:08 am Original Bud. Amended Bud, QTD Actual Encumb. YTD UnencBal % Bud Fi 73 -Village Employee Pension-folic :xp 00 General cct Class: 530 Operating ExpendilureslExpense 31.301 Legal Services 04/18/20(16 GJ APR 06 - HANSON, PERR`! 8 JENSEN SALEM PRO RATA - LEGAL SVS $780.98 175.72 LEGAL SVS THRU 3115106 Legal Services 0.00 0.00 175.72 0.00 -175.72 0.0 31.304 Recording Secy Service 04/18;2006 GJ APR 06 - EUr (NESS SERVICES CONNECT SALEM PRO RATA $306,09 68.87 ATTEND AT QTRLY MTG 2114/06 Recording Secy Service 0.00 0.00 68.87 0.00 -68.87 0.0 31.301 Investment Services 041181'2006 GJ APR 06 - BOGDAHN CO`JSULTING SAL.iEM PRO RATA $2000.00 450.00 ~TRLY FEE O1/01106.03/31106 04/18/2006 GJ APR O6 - ROCKWOOD CAPITAL MGT FEE SALEM PRO RATA $4038.09 908.57 MGT FEE 12/31105 TO 3131/06 04/t 8;2006 GJ APR 06 - ROCKWOOD C?,PITAL MGT FEE 6/30;105 TO 9/30/05 -SALEM $3,821.63 859.87 04/30/2006 GJ APR 06 ADMINISTRATION EXPENSES SALEM - ($1,452.00) 332.51 04/30.x2006 GJ APR 06 FOREIGN TAX WIHELD SALEM - ($23.06) 5.28 05/31/2006 GJ MAY 06 -FOREIGN TAX WIHELD SAM PRO RATA SHARE ($277.23) 63.74 05/31/2006 GJ MAY 06 -FEE ON DIVIDEND SALIEM PRO RATA SHARE ($2.56) 0.59 Investment Services 0.00 0.00 2,620.56 0.00 -2,620.56 0.0 31.309 Actuarial Service's 05/12/2006 GJ MAY 06 - GABRIEL, ROEDER SMITH SERV. RENDERED THRU 3131106 1,440.41 SALEM -PRO RATA $6,290.00 Actuarial Services 0.00 0.00 1,440.41 0.00 -1,440.41 0.0 19.300 Other Misc Chgs & Obligations 06/0812006 GJ JUN 06 - PYMT DUE TO GEfJ FUND FOR FEDEX POSTAGE $55.96 12.81 Other Misc Chgs 8 Obligabo^s 0.00 0.00 12.81 0.00 -12.81 0.0 ~ting EzpendifureslExpense 0.00 0.00 4,318.37 0.00 -0,318.37 0.0 Ge-el 0.00 0.00 4,318.37 0.00 -0,318.37 0.0 cpenditures 0.00 0.00 4,318.37 0.00 -0,318.37 0.0 • REVENUEIEXPENDITURE REPORT Village of Tequesta ,r- -. Page: 1 811 /2006 For the Period: 10/112005 to 9/30/2006 9:49 am _ Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud 603 Village Employee Pension-Polk Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 10/31/2005 GJ OCT 05 INTEREST -SALEM PRO RATA SHARE $4735.18 10/31/2005 GJ OCT 05 REV. SEP05 ACCRUED INCOME SALEM -PRO RATA $7502.19 10/31/2005 GJ OCT 05 ACCRUED INCOME SALE PRO RATA $7948.04 11130/2005 GJ NOV 05 INTEREST SALEM -PRO RATA SHARE $3153.58 11/30/2005 GJ NOV 05 REV. OCT 05 ACCRUED INCOME SALEM -PRO RATA SHARE $7948.04 11/30/2005 GJ NOV 05 ACCRUED INCOME SALEM PRO RATA SHARE $12701.38 12/31/2005 GJ DEC 05 -REV. NOV 05 ACCRUED INCOME SALEM -PRO RATA SHARE $12,701.38 12/31/2005 GJ DEC 05 ACCRUED INCOME SALEM -PRO RATA SHARE $14,623.18 12/31/2005 GJ DEC 05 -INTEREST -SALEM PRO RATA SHARE $2,704.65 01/31/2006 GJ JAN O6 -INTEREST -SALEM PRO RATA SHARE $2693.36 01/31/2006 GJ JAN O6 -REV. DEC 05 ACC. INCOME SALEM -PRO RATA $14623.18 01/31/2006 GJ JAN 06 -ACCRUED INCOME -SALEM PRO RATA SHARE $15073.02 02/28/2006 GJ FEB 06 REV JAN O6 ACCRUED INCOME SALEM PRO RATA SHARE$15,073.02 02/28/2006 GJ FEB 06 ACCRUED INCOME SALEM PRO RATA SHARE $14,492.11 02/28/2006 GJ FEB 06 INTEREST SALEM PRO RATA SHARE $6579.18 03/31/2006 GJ MAR O6 INTEREST $11,041.40 SALEM -PRO RATA SHARE 03/31/2006 GJ MAR O6 -REV FEB 06 ACCRUED INCOME SALEM PRO RATA $14,921.11 03/31/2006 GJ MAR 06 ACCRUED INCOME SALEM -PRO RATA $10,475.75 04130/2006 GJ APR 06 -INTEREST SALEM $4,159.33 04/30/2006 GJ APR O6 -REV MAR O6 ACCRUAL SALEM - $10,475.75 04/30/2006 GJ APR 06 -ACCRUED INCOME SALEM - $9542.76 5/31/2006 GJ MAY 06 -INTEREST -SALEM PRO RATA SHARE $3,605.18 1/2006 GJ MAY 06 -REV. APR O6 ACCRUED INCOME SALEM PRO RATA $9,542.76 1/2006 GJ MAY 06 -ACCRUED INCOME SALEM PRO RATA SHARE $12,911.11 !30/2006 GJ JUN 06 -INTEREST -SALEM TRUST PRO RATA SHARE $3,964.22 06/30/2006 GJ JUN 06 REV. MAY 06 ACCRUED INCOME SALEM -PRO RATA $12,911.11 06/30/2006 GJ JUN 06 -ACCRUED INCOME SALEM -PRO RATA $13,443.03 Interest Income 0.00 0.00 361.102 Dividend Income 10131/2005 GJ OCT 05 -DIVIDENDS -SALEM PRO RATA SHARE $574.90 11/30/2005 GJ NOV 05 DIVIDENDS SALEM -PRO RATA SHARE $1793.23 12131/2005 GJ DEC 05 -DIVIDENDS -SALEM PRO RATA SHARE $2,910.80 01/31/2006 GJ JAN O6 -DIVIDENDS -SALEM PRO RATA SHARE $2289.16 02/28/2006 GJ FEB 06 DIVIDENDS SALEM PRO RATA SHARE $1,222.00 03/31/2006 GJ MAR 05 -DIVIDENDS $1,473.70 SALEM -PRO RATA SHARE 04/30/2006 GJ APR 06 -DIVIDEND SALEM - $1,156.61 05/31/2006 GJ MAY 06 -DIVIDENDS -SALEM PRO RATA SHARE $2,945.81 06/30/2006 GJ JUN O6 -DIVIDEND -SALEM TRUST PRO RATA SHARE $1,954.18 Dividend Income 0.00 0.00 1,076.28 -1,603.22 1,806.59 714.38 -1,806.59 2,876.86 -2,876.86 3,329.70 615.83 609.45 -3, 329.70 3,411.02 -3,411.02 3,375.42 1,486.56 2,483.86 -3,375.42 2,357.04 952.58 -2,357.04 2,185.29 828.75 -2,185.29 2,968.26 916.41 -2,968.26 3,108.03 11,188.91 0.00 0.00 -11,188.91 0.0 130.67 406.22 662.77 517.99 276.11 331.52 264.89 677.18 451.75 3,719.10 0.00 0.00 0.00 0.00 -3,719.10 0.0 Unrestricted Investment Earnin 0.00 0.00 14,908.01 Acct Cla ss: MISC Miscellaneous Revenues 367.000 Gain/Loss- Sale of Investments 10/31/2005 GJ OCT 05 LOSS ON SALE OF INVEST SALEM PRO RATA SHARE ($5344.86) -1,214.89 11/30/2005 GJ NOV 05 LOSS ON SALE OF INVESTMENT SALEM PRO RATA ($1189.53) -269.43 12/31/2005 GJ DEC 05 -LOSS ON SALE OF INVEST SALEM -PRO RATA ($1,460.50) -332.56 01/31/2006 GJ JAN 06 -LOSS ON SALE OF INV. -SALEM PRO RATA SHARE - ($1415.28) -320.28 02/28!2006 GJ FEB O6 GAIN ON SALE OF INVEST SALEM PRO RATA SHARE $1190.80 269.00 3112006 GJ MAR O6 LOSS ON SALE OF INVEST SALEM -PRO RATA SHARE ($1875.59) -422.01 /2006 GJ APR 06 -LOSS ON SALE OF INVEST SALEM ($2530.41) -579.46 1/2006 GJ MAY 06 -GAIN ON SALE OF INVESTMENT SALEM -PRO RATA SHARE $1,029.70 236.73 06/30/2006 GJ JUN 06 -GAIN ON SALE OF INVESTMENT SALEM -PRO RATA $1,633.89 377.76 14,908.01 0.0 REVENUEIEXPENDITURE REPORT Village of'equesta For the Period: 10/1/2005 to 9/30/2006 0.00 0.00 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud 603 -Village Employee Pension-Polk Dept: 000 General Acct Class: MISC Miscellaneous Revenues Gain/Loss-Sale of Investments 367.100 Unreali zed g ain/loss on invest 10/31/2005 GJ OCT 05 UNREALIZED LOSS -SALEM 11130/2005 GJ NOV 05 UNREALIZED GAIN 12131/2005 GJ DEC 05 -UNREALIZED GAIN 01/31/2006 GJ JAN 06 -UNREALIZED GAIN -SALEM 02/2812006 GJ FEB O6 UNREALIZED LOSS 03/31/2006 GJ MAR 06 -UNREALIZED GAIN -SALEM 04130/2006 GJ APR 06 UNREALIZED GAIN 05131/2006 GJ MAY O6 -UNREALIZED LOSS 06/30/2006 GJ JUN O6 -UNREALIZED LOSS 0,00 0.00 -2,255.14 0.00 PRO RATA SHARE ($105,979.09) SALEM -PRO RATA $56481.15 SALEM -PRO RATA SHARE $12,658.09 PRO RATA SHARE $67115.50 SALEM PRO RATA SHARE ($34,925.68) PRO RATA SHARE $25,431.11 SALEM - $21803.84 SALEM PRO RATA SHARE ($62,572.71) SALEM -PRO RATA ($3711.07) Unrealized gainlloss on invest 368.001 Pension Fund Cont-Employer 10107/2005 PA VOT PENSION DEPOSITS-P/D 10/07/05 Page: 2 811 /2006 9:49 am 0.00 2,255.14 0.0 -24,089.05 12,792.98 2,882.25 15,188.24 -7,889.71 5,722.00 4,993.08 -14,385.47 -858.00 -5,643.68 0.00 0.00 5,643.68 0.0 96.78 10/07/2005 RE RVRS JE#146204 prior year accrual FYE05 ACCRUED CONTRIB RECEIVABLE -1,294.53 10127/2005 PA VOT PENSION DEPOSIT-P/D 10/27/05 _ - 1803.14 11/01/2005 PA VOT PENSION DEPOSITS-P/D 11/01/05 1,894.15 11/18/2005 PA VOT PENSION DEPOSIT-P/D 11/18/05 1,847.16 12/02/2005 PA VOT PENSION DEPOSITS-P/D 12/02/05 . - -- 2,072.36 12/16/2005 PA VOT PENSION DEPOSITS-P/D 12/16/05 1,904.97 12/29/2005 PA VOT PENSION DEPOSITS-PID 12/29105 1,949.68 _- X1/13/2006 PA VOT PENSION DEPOSITS-P/D 01/13/06 2,045.70 27/2006 PA VOT PENSION DEPOSITS-PID 01/27/06 1 855.68 012006 PA VOT PENSION DEPOSITS-P/D 02/10/06 1 868.39 124/2006 GJ VOT PENSION DEPOSITS-PID 02/24/06 1,897.93 03/10/2006 PA VOT PENSION DEPOSIT PID 03/10/06 1,910.27 - _ 03!24/2006 PA VOT PENSION DEPOSIT PID 03124/06 1,790.03 04107/2006 PA VOT PENSION DEPOSIT-P/D 04/07/06 _-- _ 14,517.54 04/21/2006 PA VOT PENSION DEPOSITS-PID 04/21/06 2,321.44 05/05/2006 PA VOT PENSION DEPOSIT-P/D 05/05/06 2,658.15 05/19/2006 PA VOT PENSION DEPOSIT-PID 05/19/06 2,346.92 06/02/2006 PA VOT PENSION DEPOSIT P/D 06/02/06 2,456.57 ~~~ 06116/2006 PA VOT PENSION DEPOSITS-PID 06/16/06 2,491.39 06/30/2006 PA VOT PENSION DEPOSITS-PID 06/30106 2,566.91 0711412006 PA VOT PENSION DEPOSIT-PID 07114/06 _._...,- 2 458.36 07128/2006 PA VOT PENSION DEPOSITS-P/D 07/28106 2,519.44 Pension Fun d Cont-Employer 0.00 0.00 55,978.43 0.00 368.002 Pensio n Fund Cont-Employee 10/07/2005 PA VOT PENSION DEPOSITS-P/D 10/07/05 64.09 10/07/2005 RE RVRS JE#146204 prior year accrual FYE05 ACCRUED CONTRIB RECEIVABLE -1 954.73 10/27/2005 PA VOT PENSION DEPOSIT-PID 10/27/05 11/01/2005 PA VOT PENSION DEPOSITS-PID 11/01/05 _ 11/18/2005 PA VOT PENSION DEPOSIT-P/D 11118/05 12/02/2005 PA VOT PENSION DEPOSITS-P/D 12/02/05 12/16/2005 PA VOT PENSION DEPOSITS-P/D 12/16/05 12/29/2005 PA VOTpENSION DEPOSITS-P/D 12/29/05 01/13/2006 PA VOT PENSION DEPOSITS-P/D 01/13/06 01/27/2006 PA VOT PENSION DEPOSITS-P1D 01/27/06 ^~I10/2006 PA VOT PENSION DEPOSITS-PID 02/10/06 24/2006 GJ VOT PENSION DEPOSITS-PID 02/24106 0/2006 PA VOT PENSION DEPOSIT P/D 03/10/06 124/2006 PA VOT PENSION DEPOSIT P/D 03/24/06 1,194.13 1,254.41 1,223.29..__-_ 1,372.43 1,211.40 __ ..:.._1.,341..35-- 1,354.77 1,228.93 _ _ __..,...V..-._. 1, 237.35 1 256.91 ___ 1 265.08 1,185.45 0.00 -55,978.43 0.0 REVENUEIEXPENDITURE REPORT Village of Tequesta For the Period: 101112005 to 9130/2006 Page: 3 8/1/2006 9:49 am _ Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud our - visage tmpioyee rension-rout R ues Dept: 000 General Acct Class: MISC Miscellaneous Revenues 04107/2006 PA VOT PENSION DEPOSIT-P/D 04/07/06 04/21/2006 PA VOT PENSION DEPOSITS-PID 04/21/06 05/05/2006 PA VOT PENSION DEPOSIT-P/D 05/05/06 05119/2006 PA VOT PENSION DEPOSIT-P/D 05/19/06 --- 06102/2006 PA VOT PENSION DEPOSIT P/D 06/02/06 06/16/2006 PA VOT PENSION DEPOSITS-PID 06/16/06 06/30/2006 PA VOT PENSION DEPOSITS-PID 06/30/06 07114/2006 PA VOT PENSION DEPOSIT-P1D 07/14/06 07/2812006 PA VOT PENSION DEPOSITS-PID 07128/06 Pension Fund Cont-Employee 369.000 Other Miscellaneous Revenue 11130/2005 GJ NOV 05 RETURN OF CAPITAL 02128/2006 GJ FEB 06 RETURN OF CAPITAL 05131/2006 GJ MAY O6 -RETURN OF CAPITAL Other Miscellaneous Revenue 1,094.69 1,009.32_ 1,155.72 1,020.40 _ ~ 1,oss.os 1,083.21 1,116.05 .__~, 1,068.85 1,095.41 0.00 0.00 22,946.59 SALEM -PRO RATA $173.20 39.23 SALEM PRO RATA SHARE $173.20 39.13 SALEM PRO RATA SHARE $173.20 39.82 0.00 0.00 118.18 0.00 0.00 0.00 -22,946.59 0.0 0.00 -118.18 0.0 Miscellaneous Revenues 0.00 0.00 71,144.38 0.00 0.00 -71,144.38 0.0 General 0.00 0.00 86,052.39 0.00 0.00 -86,052.39 0.0 Revenues 0.00 0.00 86,052.39 0.00 0.00 itures pt: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 0212412006 GJ FEB 05 - HANSON, PERRY 8 JENSEN SALEM -PRO RATA - $703.07 159.10 04118/2006 GJ APR 06 - HANSON, PERRY &JENSEN SALEM PRO RATA - LEGAL SVS $780.98 175.72 LEGAL SVS THRU 3/15/06 Legal Services 1,056.00 1,056.00 334.82 0.00 0.00 531.304 Recording Secy Service 02/24/2006 GJ FEB 05 -BUSINESS SERVICES CONNECT SALEM -PRO RATA $322.20 72.91 04!18/2006 GJ APR O6 -BUSINESS SERVICES CONNECT SALEM PRO RATA $306.09 68.87 ATTEND AT OTRLY MTG 2/14/06 Recording Secy Service 211.00 211.00 141.78 0.00 0.00 531.307 Investment Services 11/30/2005 GJ NOV 05 ADMINISTRATION FEES SALEM PRO RATA SHARE $750.00 169.87 12/31/2005 GJ DEC 05 WIRE FEE WACHOVIA PRO RATA SHARE $25.00 5.70 01/31/2006 GJ JAN 06 -ADMIN. EXPS. -SALEM PRO RATA SHARE ($750.00) 169.72 01/31/2006 GJ JAN O6 -FOREIGN TAX W/H -SALEM PRO RATA SHARE ($30.57) 6.92 02/24/2006 GJ FEB 05 - BOGDAHN CONSULTING SALEM -PRO RATA $2000.00 452.60 02/24/2006 GJ FEB 05 - ROOCKWOOD CAPITAL SALEM -PRO RATA $3893.07 881.00 04/18/2006 GJ APR 06 - BOGDAHN CONSULTING SALEM PRO RATA $2000.00 450.00 OTRLY FEE 01/01/06 - 03/31/06 04/18/2006 GJ APR O6 - ROCKWOOD CAPITAL MGT FEE SALEM PRO RATA $4038.09 908.57 MGT FEE 12/31/05 TO 3/31/06 0411812006 GJ APR 06 - ROCKWOOD CAPITAL MGT FEE 6/30/05 TO 9/30/05 -SALEM $3,821.63 859.87 0413012006 GJ APR 06 ADMINISTRATION EXPENSES SALEM - ($1,452.00) 332.51 04/3012006 GJ APR 06 FOREIGN TAX W/HELD SALEM - ($23.06) 5.2g 05/3112006 GJ MAY O6 -FOREIGN TAX W/HELD SALEM PRO RATA SHARE ($277.23) 63.74 05131!2006 GJ MAY 06 - FEE ON DIVIDEND SALEM PRO RATA SHARE ($2.56) 0.59 Investment Services 5,069.00 5,069.00 4,306.37 0.00 0.00 9 Actuarial Services •2/2006 GJ MAY O6 - GABRIEL, ROEDER SMITH SERV. RENDERED THRU 3/31/06 1,440.41 SALEM -PRO RATA $6,290.00 Actuarial Services 1,309.00 1,309.00 1,440.41 0.00 0.00 -86,052.39 0.0 721.18 31.7 69.22 67.2 762.63 85.0 131.41 110.0 REVENUEIEXPENDITURE REPORT Page: 4 Village of ?equesta 811/2006 For the Period: 1011!2005 to 9130/2006 9:49 am Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud 603 -Village Employee Pension-folic ditures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 540.300 Travel & Per Diem 0311512006 GJ FEB 06 -REGIST. FEE & TRAVEL EXPS TO ATTEND FPPTA CONE 110.06 REG. FEE $400 & TRAVEL $487.23 Travel & Per Diem 317.00 317.00 110.06 0.00 0.00 206.94 34.7 545.300 Insurance 12112/2005 GJ OCT 05 TO OCT 06 - ACORDIA LIABILITY INSURANCE $3218.00 728.88 Insurance 718.00 718.00 728.88 0.00 0.00 -10.88 101.5 549.300 Other Misc Chgs & Obligations 06/08/2006 GJ JUN 06 - PYMT DUE TO GEN. FUND FOR FEDEX POSTAGE $55.96 12.81 Other Misc Chgs & Obligations 0.00 0.00 12.81 0.00 0.00 -12.81 0.0 554.300 Books, Publ, Subs & Membership 0212412006 GJ FEB 05 -FPPTA MEMBERSHIP DUES SALEM -PRO RATA $225.00 50.92 Books, Publ, Subs & Membership 0.00 0.00 50.92 0.00 0.00 -50.92 0.0 554.600 Seminars & Training -Pensions 0311512006 GJ FEB O6 -REGIST. FEE & TRAVEL EXPS TO ATTEND FPPTA CONF 90.36 REG. FEE $400 & TRAVEL $487.23 Seminars 8 Training -Pensions 317.00 317.00 90.36 0.00 0.00 226.64 28.5 Operating ExpenditureslExpense 8,997.00 8,997.00 7,216.41 0.00 0.00 1,780.59 80.2 General 8,997.00 8,997.00 7,216.41 0.00 0.00 1,780.59 80.2 Dept: 165 Pension Acct Class: 530 Operating Expenditures/Expense Pension Distributions/Refunds 3112005 GJ DEC 05 -JASON FLEMING REF. OF CONTRIBS - $8878.02 8,878.02 01131/2006 GJ JAN 06 -RICHARD GROUSE -TERM REF. OF PENSION CONTRIBS. $3290.11 3,290.11 03/17/2006 GJ MAR 06 -BRIAN YOUNGBLOOD REF. OF PENSION CONTRIBS. $11,084.49 11,084.49 Pension Distributions/Refunds 0.00 0.00 23,252.62 0.00 0.00 -23,252.62 0.0 Operating Expenditures/Expense 0.00 0.00 23,252.62 0.00 0.00 -23,252.62 0.0 Pension 0.00 0.00 23,252.62 0.00 0.00 -23,252.62 0.0 Expenditures 8,997.00 8,997.00 30,469.03 0.00 0.00 -21,472.03 338.7 Net Effect for Village Employee Pension-folic -8,997.00 -8,997.00 55,583.36 0.00 0.00 -64,580.36 Change in Fund Balance: 55,583.36 i•