Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
5.1 Monthly Financial Report - July 2018
BoardDocs® ProPage 1 of 2 Agenda Item Details MeetingAug 21, 2018 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m. Category5. CONSENT AGENDA Subject5.1 Monthly Financial Report - July 2018 AccessPublic TypeAction (Consent) Preferred DateAug 21, 2018 Absolute DateAug 21, 2018 Fiscal ImpactNo BudgetedNo Recommended ActionAccept the monthly financial report for July 2018. Public Content Information The monthly financial report contains a Cash Position Report and Fund Financials for the month ended July 31, 2018 Alternatives 1. Accept the monthly financial report for July 2018 2. Action at discretion of Village Board. Staff Recommendation Staff recommends the Village Board accept the monthly financial report for July 31, 2018. 07 July Board Report for Upload.pdf (771 KB)Combined Financials for BD 7-2018.pdf (785 KB) Administrative Content Executive Content https://www.boarddocs.com/il/vomp/Board.nsf/Public8/21/2018 BoardDocs® ProPage 2 of 2 All items under Consent Agenda are considered routine by the Village Board and will be enacted by one motion. There will be no separate discussion of those items unless a Board member or member from the audience so requests, in which the item will be removed from the Consent Agenda and considered in its sequence on the agenda. https://www.boarddocs.com/il/vomp/Board.nsf/Public8/21/2018 8 1 20 , 1 3 & July – 1 July BUDGET REVENUE EXPENDITURE SUMMARIES VILLAGE OF MOUNT PROSPECT .00 84,105.4291,381.56 801,738.92578,987.63221,193.40225,514.19 3,400,729.568,973,215.91 11,679,811.17 Prior Year YTD $26,056,677.76$26,056,677.76 7850656535517845 142 66% +++ Rec'd Summary Listing % Used/ Through 07/31/18 20.00 45,082.02 495,069.00844,598.02214,145.23121,142.02 Transactions (104,558.98) 3,570,479.404,101,472.658,652,071.79 Budget - YTD $17,939,521.15$17,939,521.15 YTD Prior Fiscal Year Activity Included (20.00) 97,757.98 921,931.00460,401.98222,854.77159,917.98356,058.98 Transactions 4,108,527.35 12,969,520.6016,231,788.21 $35,528,738.85$35,528,738.85 .00.00.00.00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00 3,820.02 69,332.7821,727.7213,767.8423,605.40 838,016.16250,662.53 Transactions 4,071,727.735,272,409.74 Current Month $10,565,069.92$10,565,069.92 .00 Budget Њ Amended 437,000.00205,000.00218,900.00251,500.00 8,210,000.001,417,000.001,305,000.00 16,540,000.0024,883,860.00 $53,468,260.00$53,468,260.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 437,000.00205,000.00218,900.00251,500.00 8,210,000.001,417,000.001,305,000.00 16,540,000.0024,883,860.00 $53,468,260.00$53,468,260.00 Totals REVENUE TOTALS 001 - General Fund Fund 001 - General Fund REVENUE Account ClassificationFundProperty TaxesOther TaxesLicenses, Permits & FeesIntergovernmental RevenueCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00 950.78 281,303.72123,142.51 1,644,264.89 $2,049,661.90$2,049,661.90 Prior Year YTD 7 7366 552 50% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 (4,521.37) 639,081.11347,293.68 Transactions 1,508,161.63 Budget - YTD $2,490,015.05$2,490,015.05 .00.00 YTD Prior Fiscal Year Activity Included 5,521.37 665,224.32109,988.37 Transactions 1,740,918.89 $2,521,652.95$2,521,652.95 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 3,203.16 579,160.52236,929.20 Transactions $819,292.88$819,292.88 Current Month .00.00 Budget Ћ 1,000.00 Amended 2,380,000.001,012,518.001,618,150.00 $5,011,668.00$5,011,668.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 1,000.00 2,380,000.001,012,518.001,618,150.00 $5,011,668.00$5,011,668.00 Totals REVENUE TOTALS 002 - Debt Service Fund Fund 002 - Debt Service Fund REVENUE Account ClassificationFundProperty TaxesOther TaxesIntergovernmental RevenueInvestment IncomeOther RevenueOther Financing Sources .00.00.00.00 3,634.95 407,626.13 $411,261.08$411,261.08 Prior Year YTD 00 66 42% ++++++ 1170 Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 10,000.00 445,900.00750,000.00 (10,698.53) Transactions Budget - YTD $1,195,201.47$1,195,201.47 .00.00.00.00 YTD Prior Fiscal Year Activity Included 11,698.53 854,100.00 Transactions $865,798.53$865,798.53 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 3,561.92 304,200.00 Transactions $307,761.92$307,761.92 Current Month .00.00 Budget Ќ 1,000.00 Amended 10,000.00 750,000.00 1,300,000.00 $2,061,000.00$2,061,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 1,000.00 10,000.00 750,000.00 1,300,000.00 $2,061,000.00$2,061,000.00 Totals REVENUE TOTALS 020 - Capital Improvement Fund Fund 020 - Capital Improvement Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00.00.00 2,124.45 25,671.88 751,091.09 1,560,712.00 $2,339,599.42$2,339,599.42 Prior Year YTD 6193 198625 81% ++++++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00 (1,957.43) 772,315.73114,003.00 (22,733.81) Transactions $704,046.97$704,046.97 (157,580.52) Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 3,957.43 22,733.81 187,580.52 Transactions 1,207,684.271,535,997.00 $2,957,953.03$2,957,953.03 .00.00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 2,348.289,864.26 24,090.50 363,870.14 Transactions $400,173.18$400,173.18 Current Month .00.00.00.00 Budget Ѝ 2,000.00 Amended 30,000.00 1,980,000.001,650,000.00 $3,662,000.00$3,662,000.00 .00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00 Budget Revenue Budget by Account Classification Report Adopted 2,000.00 30,000.00 1,980,000.001,650,000.00 $3,662,000.00$3,662,000.00 Totals REVENUE TOTALS 023 - Street Improvement Construc Fund Fund 023 - Street Improvement Construc Fund REVENUE Account ClassificationFundOther TaxesLicenses, Permits & FeesIntergovernmental RevenueFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00 7,744.004,003.64 19,823.50 126,322.40 $157,893.54$157,893.54 Prior Year YTD 6649 159100 68% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00 98,784.0012,798.00 (3,559.17) Transactions $108,022.83$108,022.83 Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 9,559.17 12,202.0020,000.00 189,216.00 Transactions $230,977.17$230,977.17 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 3,140.87 67,392.00 $70,532.87$70,532.87 Transactions Current Month .00.00 Budget Ў 6,000.00 Amended 25,000.0020,000.00 288,000.00 $339,000.00$339,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 6,000.00 25,000.0020,000.00 288,000.00 $339,000.00$339,000.00 Totals REVENUE TOTALS 024 - Flood Control Construction Fund Fund 024 - Flood Control Construction Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueCharges For ServicesInvestment IncomeReimbursementsOther Financing Sources .00.00 $0.00$0.00 Prior Year YTD +++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 $0.00$0.00 Transactions Budget - YTD .00.00 YTD $0.00$0.00 Prior Fiscal Year Activity Included Transactions .00.00 YTD $0.00$0.00 Encumbrances .00.00 $0.00$0.00 Transactions Current Month .00.00 $0.00$0.00 Budget Џ Amended .00.00 $0.00$0.00 Budget Amendments .00.00 $0.00$0.00 Budget Revenue Budget by Account Classification Report Adopted Totals REVENUE TOTALS 025 - Police & Fire Building Const. Fund 025 - Police & Fire Building Const. REVENUE Account ClassificationFundInvestment IncomeOther Financing Sources .00 357.33 2,819.06 24,075.9773,233.34 2,353,916.07 $2,454,401.77$2,454,401.77 Prior Year YTD 57494362 130 57% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 572.50 23,444.7342,201.99 (1,188.27) Transactions 1,802,718.23 Budget - YTD $1,867,749.18$1,867,749.18 .00 YTD Prior Fiscal Year Activity Included 427.50 5,188.27 22,555.2768,798.01 Transactions 2,372,281.77 $2,469,250.82$2,469,250.82 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00 156.98 4,691.781,546.219,954.70 280,798.83 Transactions $297,148.50$297,148.50 Current Month .00 Budget А 4,000.001,000.00 Amended 46,000.00 111,000.00 4,175,000.00 $4,337,000.00$4,337,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 4,000.001,000.00 46,000.00 111,000.00 4,175,000.00 $4,337,000.00$4,337,000.00 Totals REVENUE TOTALS 040 - Refuse Disposal Fund Fund 040 - Refuse Disposal Fund REVENUE Account ClassificationFundProperty TaxesCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther Revenue .00 7,252.003,561.68 672,251.36 $683,065.04$683,065.04 Prior Year YTD 4938 361 50% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 9,297.90 718,272.34 (13,050.29) Transactions $714,519.95$714,519.95 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 5,702.10 18,050.29 676,727.66 Transactions $700,480.05$700,480.05 .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 6,134.95 104,621.59 Transactions $110,756.54$110,756.54 Current Month .00 Budget Б 5,000.00 Amended 15,000.00 1,395,000.00 $1,415,000.00$1,415,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 5,000.00 15,000.00 1,395,000.00 $1,415,000.00$1,415,000.00 Totals REVENUE TOTALS 041 - Motor Fuel Tax Fund Fund 041 - Motor Fuel Tax Fund REVENUE Account ClassificationFundIntergovernmental RevenueInvestment IncomeReimbursementsOther Revenue .00 172,859.33109,437.73 $282,297.06$282,297.06 Prior Year YTD 8 78 18% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 13,390.00 346,687.01 Transactions $360,077.01$360,077.01 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 31,978.9946,610.00 $78,588.99$78,588.99 Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00 31,978.9921,610.00 $53,588.99$53,588.99 Transactions Current Month .00 Budget В Amended 60,000.00 378,666.00 $438,666.00$438,666.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 60,000.00 378,666.00 $438,666.00$438,666.00 Totals REVENUE TOTALS 042 - CDBG Fund 042 - CDBG REVENUE Account ClassificationFundIntergovernmental RevenueInvestment IncomeOther Revenue 356.58 3,043.38 $3,399.96$3,399.96 Prior Year YTD 142183 Rec'd 145% Summary Listing % Used/ Through 07/31/18 (414.63) (2,734.13) ($3,148.76)($3,148.76) Transactions Budget - YTD YTD Prior Fiscal Year Activity Included 914.63 9,234.13 $10,148.76$10,148.76 Transactions .00.00 YTD $0.00$0.00 Encumbrances 250.00286.46 $536.46$536.46 Transactions Current Month 500.00 Budget 6,500.00 ЊЉ Amended $7,000.00$7,000.00 .00.00 $0.00$0.00 Budget Amendments 500.00 Budget Revenue Budget by Account Classification Report Adopted 6,500.00 $7,000.00$7,000.00 Totals REVENUE TOTALS 043 - Asset Seizure Fund Fund 043 - Asset Seizure Fund REVENUE Account ClassificationFundFines & ForfeitsInvestment Income .00 89.42 $89.42$89.42 Prior Year YTD 0 36 4% Rec'd Summary Listing % Used/ Through 07/31/18 128.69 1,800.00 $1,928.69$1,928.69 Transactions Budget - YTD .00 YTD 71.31 Prior Fiscal Year Activity Included $71.31$71.31 Transactions .00.00 YTD $0.00$0.00 Encumbrances .00 6.54 $6.54$6.54 Transactions Current Month 200.00 Budget 1,800.00 ЊЊ Amended $2,000.00$2,000.00 .00.00 $0.00$0.00 Budget Amendments 200.00 Budget Revenue Budget by Account Classification Report Adopted 1,800.00 $2,000.00$2,000.00 Totals REVENUE TOTALS 044 - Federal Equitable Share Funds Fund 044 - Federal Equitable Share Funds REVENUE Account ClassificationFundFines & ForfeitsInvestment Income 249.53 11,136.29 $11,385.82$11,385.82 Prior Year YTD 3639 36% Rec'd Summary Listing % Used/ Through 07/31/18 305.68 15,954.63 $16,260.31$16,260.31 Transactions Budget - YTD YTD Prior Fiscal Year Activity Included 194.32 9,045.37 $9,239.69$9,239.69 Transactions .00.00 YTD $0.00$0.00 Encumbrances .00 18.24 $18.24$18.24 Transactions Current Month 500.00 Budget ЊЋ Amended 25,000.00 $25,500.00$25,500.00 .00.00 $0.00$0.00 Budget Amendments 500.00 Budget Revenue Budget by Account Classification Report Adopted 25,000.00 $25,500.00$25,500.00 Totals REVENUE TOTALS 045 - DUI Fine Fund Fund 045 - DUI Fine Fund REVENUE Account ClassificationFundFines & ForfeitsInvestment Income .00.00 959.72 14,898.47 $15,858.19$15,858.19 Prior Year YTD 6 8% 101 ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 (13.11) 84,229.04 $84,215.93$84,215.93 Transactions Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 5,770.962,013.11 $7,784.07$7,784.07 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 582.70 5,770.96 $6,353.66$6,353.66 Transactions Current Month .00.00 Budget 2,000.00 ЊЌ Amended 90,000.00 $92,000.00$92,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 2,000.00 90,000.00 $92,000.00$92,000.00 Totals REVENUE TOTALS 046 - Foreign Fire Tax Board Fund Fund 046 - Foreign Fire Tax Board Fund REVENUE Account ClassificationFundOther TaxesInvestment IncomeOther RevenueOther Financing Sources .00 3,109.75 428,782.85332,500.00 $764,392.60$764,392.60 Prior Year YTD 4067 278 48% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 (5,340.71) 660,863.36140,280.00 Transactions $795,802.65$795,802.65 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 8,340.71 439,136.64279,720.00 Transactions $727,197.35$727,197.35 .00.00.00.00 YTD $0.00$0.00 Encumbrances .00 2,746.76 97,661.87 109,620.00 Transactions $210,028.63$210,028.63 Current Month .00 Budget 3,000.00 ЊЍ Amended 420,000.00 1,100,000.00 $1,523,000.00$1,523,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 3,000.00 420,000.00 1,100,000.00 $1,523,000.00$1,523,000.00 Totals REVENUE TOTALS 048 - Business District Fund Fund 048 - Business District Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueInvestment IncomeOther Financing Sources .00.00.00.00 $0.00$0.00 Prior Year YTD 123457 ++++++ Rec'd 418% Summary Listing % Used/ Through 07/31/18 (58,644.38)(44,844.54)(69,119.54) Transactions Budget - YTD (5,718,879.30) ($5,891,487.76)($5,891,487.76) YTD Prior Fiscal Year Activity Included 44,844.5469,119.54 312,597.38 Transactions 7,318,879.30 $7,745,440.76$7,745,440.76 .00.00.00.00 YTD $0.00$0.00 Encumbrances .00 7,901.35 35,959.77 312,597.38 Transactions $356,458.50$356,458.50 Current Month .00.00 Budget ЊЎ Amended 253,953.00 1,600,000.00 $1,853,953.00$1,853,953.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 253,953.00 1,600,000.00 $1,853,953.00$1,853,953.00 Totals REVENUE TOTALS 049 - Prospect and Main TIF District Fund 049 - Prospect and Main TIF District REVENUE Account ClassificationFundProperty TaxesInvestment IncomeOther RevenueOther Financing Sources .00 9,730.523,064.00 12,120.0055,861.2943,230.43 (5,972.58) 7,575,012.40 $7,693,046.06$7,693,046.06 Prior Year YTD 0 62554540 529 41% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 8,746.137,560.001,200.00 71,128.5447,731.53 (69,145.42) Transactions 6,504,649.375,000,000.00 Budget - YTD $11,571,870.15$11,571,870.15 .00 YTD Prior Fiscal Year Activity Included 12,440.0058,871.4685,245.4232,268.47 (8,746.13)(1,200.00) Transactions 7,939,550.63 $8,118,429.85$8,118,429.85 .00.00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 1,360.007,481.564,780.00 21,124.98 (3,525.68) Transactions 1,164,227.52 Current Month $1,195,448.38$1,195,448.38 .00.00 Budget ЊЏ Amended 20,000.0016,100.0080,000.00 130,000.00 5,000,000.00 14,444,200.00 $19,690,300.00$19,690,300.00 .00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 20,000.0016,100.0080,000.00 130,000.00 5,000,000.00 14,444,200.00 $19,690,300.00$19,690,300.00 Totals REVENUE TOTALS 050 - Water and Sewer Fund Fund 050 - Water and Sewer Fund REVENUE Account ClassificationFundProperty TaxesLicenses, Permits & FeesCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00 837.88 1,718.50 115,053.90 $117,610.28$117,610.28 Prior Year YTD 5757 193 58% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 (926.39) 1,282.90 82,409.69 $82,766.20$82,766.20 Transactions Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 1,926.391,717.10 111,190.31 Transactions $114,833.80$114,833.80 .00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 571.55270.55 14,021.51 $14,863.61$14,863.61 Transactions Current Month .00.00 Budget 1,000.003,000.00 ЊА Amended 193,600.00 $197,600.00$197,600.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 1,000.003,000.00 193,600.00 $197,600.00$197,600.00 Totals REVENUE TOTALS 051 - Village Parking System Fund Fund 051 - Village Parking System Fund REVENUE Account ClassificationFundOther TaxesCharges For ServicesInvestment IncomeOther RevenueOther Financing Sources .00.00.00 321.21797.65 90,074.60 $91,193.46$91,193.46 Prior Year YTD 5871 176 58% +++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00 289.85 (377.94) 65,763.15 $65,675.06$65,675.06 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 877.94710.15 90,236.85 $91,824.94$91,824.94 Transactions .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 91.00 289.23 12,327.85 $12,708.08$12,708.08 Transactions Current Month .00.00.00 500.00 Budget 1,000.00 ЊБ Amended 156,000.00 $157,500.00$157,500.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 500.00 Budget Revenue Budget by Account Classification Report Adopted 1,000.00 156,000.00 $157,500.00$157,500.00 Totals REVENUE TOTALS 052 - Parking System Revenue Fund Fund 052 - Parking System Revenue Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueCharges For ServicesInvestment IncomeOther RevenueOther Financing Sources .00.00 1,996.89 1,184,145.69 $1,186,142.58$1,186,142.58 Prior Year YTD 58 115 58% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 (452.09) 850,344.70 Transactions $849,892.61$849,892.61 Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 3,452.09 Transactions 1,190,482.30 $1,193,934.39$1,193,934.39 .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 1,045.84 170,068.90 Transactions $171,114.74$171,114.74 Current Month .00.00 Budget 3,000.00 ЊВ Amended 2,040,827.00 $2,043,827.00$2,043,827.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 3,000.00 2,040,827.00 $2,043,827.00$2,043,827.00 Totals REVENUE TOTALS 060 - Vehicle Maintenance Fund Fund 060 - Vehicle Maintenance Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther RevenueOther Financing Sources .00.00 4,852.00 35,783.0760,629.30 959,583.24 $1,060,847.61$1,060,847.61 Prior Year YTD 58446695 60% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 4,488.532,988.00 16,953.43 671,375.07 Transactions $695,805.03$695,805.03 Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 3,511.47 33,046.5762,012.00 939,924.93 Transactions $1,038,494.97$1,038,494.97 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 12,360.33 134,274.99 Transactions $146,635.32$146,635.32 Current Month .00.00 Budget 8,000.00 ЋЉ Amended 50,000.0065,000.00 1,611,300.00 $1,734,300.00$1,734,300.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Revenue Budget by Account Classification Report Adopted 8,000.00 50,000.0065,000.00 1,611,300.00 $1,734,300.00$1,734,300.00 Totals REVENUE TOTALS 061 - Vehicle Replacement Fund Fund 061 - Vehicle Replacement Fund REVENUE Account ClassificationFundCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00 1,306.22 140,483.63 $141,789.85$141,789.85 Prior Year YTD 58 198 59% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 85,457.13 (1,463.07) $83,994.06$83,994.06 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 2,963.07 119,639.87 Transactions $122,602.94$122,602.94 .00.00.00 YTD $0.00$0.00 Encumbrances .00 919.91 17,091.41 $18,011.32$18,011.32 Transactions Current Month .00 Budget 1,500.00 ЋЊ Amended 205,097.00 $206,597.00$206,597.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 1,500.00 205,097.00 $206,597.00$206,597.00 Totals REVENUE TOTALS 062 - Computer Replacement Fund Fund 062 - Computer Replacement Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther Financing Sources .00 7,419.23 794,527.16 3,880,918.47 $4,682,864.86$4,682,864.86 Prior Year YTD 579963 58% 1238 Rec'd Summary Listing % Used/ Through 07/31/18 162.81 593,417.14 (11,384.63) Transactions 3,059,982.82 Budget - YTD $3,642,178.14$3,642,178.14 YTD Prior Fiscal Year Activity Included 12,837.1912,384.63 989,110.86 Transactions 4,104,367.18 $5,118,699.86$5,118,699.86 .00.00.00.00 YTD $0.00$0.00 Encumbrances 1,587.774,238.95 585,837.42123,270.10 Transactions $714,934.24$714,934.24 Current Month Budget 1,000.00 ЋЋ Amended 13,000.00 7,164,350.001,582,528.00 $8,760,878.00$8,760,878.00 .00.00.00.00 $0.00$0.00 Budget Amendments Budget Revenue Budget by Account Classification Report Adopted 1,000.00 13,000.00 7,164,350.001,582,528.00 $8,760,878.00$8,760,878.00 Totals REVENUE TOTALS 063 - Risk Management Fund Fund 063 - Risk Management Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeReimbursementsOther Revenue .00 5,193,305.903,120,400.97 $8,313,706.87$8,313,706.87 Prior Year YTD 4769 57% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 Transactions 2,764,288.931,406,324.46 Budget - YTD $4,170,613.39$4,170,613.39 .00 YTD Prior Fiscal Year Activity Included Transactions 2,496,711.073,078,175.54 $5,574,886.61$5,574,886.61 .00.00.00 YTD $0.00$0.00 Encumbrances .00 824,922.86 Transactions 1,236,218.88 Current Month $2,061,141.74$2,061,141.74 .00 Budget ЋЌ Amended 5,261,000.004,484,500.00 $9,745,500.00$9,745,500.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Revenue Budget by Account Classification Report Adopted 5,261,000.004,484,500.00 $9,745,500.00$9,745,500.00 Totals REVENUE TOTALS 070 - Police Pension Fund Fund 070 - Police Pension Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther Revenue 6,300,538.452,360,155.25 $8,660,693.70$8,660,693.70 Prior Year YTD 4368 54% Rec'd Summary Listing % Used/ Through 07/31/18 Transactions 2,892,365.651,287,912.05 Budget - YTD $4,180,277.70$4,180,277.70 YTD Prior Fiscal Year Activity Included Transactions 2,185,634.352,751,387.95 $4,937,022.30$4,937,022.30 .00.00 YTD $0.00$0.00 Encumbrances 914,071.15 Transactions 1,066,644.39 Current Month $1,980,715.54$1,980,715.54 Budget ЋЍ Amended 5,078,000.004,039,300.00 $9,117,300.00$9,117,300.00 .00.00 $0.00$0.00 Budget Amendments Budget Revenue Budget by Account Classification Report Adopted 5,078,000.004,039,300.00 $9,117,300.00$9,117,300.00 Totals REVENUE TOTALS 071 - Fire Pension Fund Fund 071 - Fire Pension Fund REVENUE Account ClassificationFundInvestment IncomeOther Revenue .00.00 2,322.23 27,288.1082,743.5779,822.6381,304.01 266,586.42234,084.34329,852.54503,473.00179,108.03 8,501,468.944,543,657.07 14,090,767.52 Prior Year YTD $28,922,478.40$28,922,478.40 7040 54674857325854276769 56% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 9,035.84 43,555.7746,761.8785,787.85 296,181.95227,996.80174,270.85345,135.29683,456.00331,605.30750,000.00 Transactions 4,830,361.323,756,701.90 Budget - YTD 12,387,378.01 $23,968,228.75$23,968,228.75 .00.00.00 YTD Prior Fiscal Year Activity Included 392.16 3,394.23 16,851.13 247,801.49106,059.20243,340.15381,314.84149,358.14305,250.86 Transactions 9,663,872.684,244,452.67 14,517,658.99 $29,879,746.54$29,879,746.54 .00.00.00.00.00.00.00.00.00 YTD 163.00 23,605.5631,454.8724,784.01 650,871.43423,581.84 Encumbrances $1,154,460.71$1,154,460.71 .00.00.00.00 484.89 2,628.02 15,436.1222,337.6534,772.4942,126.1123,479.83 682,732.03165,083.51 Transactions 2,123,483.272,402,831.69 Current Month $5,515,395.61$5,515,395.61 .00 Budget 9,428.00 Amended 46,950.0063,776.00 Њ 567,589.00334,056.00417,611.00757,905.00683,456.00259,930.00750,000.00 8,652,026.001,060,438.00 26,905,037.0014,494,234.00 $55,002,436.00$55,002,436.00 .00.00.00.00.00.00.00.00 Budget (950.00) 3,780.009,000.006,400.00 12,750.00 (6,400.00) 162,438.00 $187,018.00$187,018.00 Amendments .00 Budget Adopted 46,950.0015,828.0054,776.00 Expense Budget by Account Classification Report 568,539.00334,056.00417,611.00754,125.00683,456.00253,530.00898,000.00750,000.00 8,639,276.00 26,905,037.0014,494,234.00 $54,815,418.00$54,815,418.00 Totals EXPENSE TOTALS 001 - General Fund Fund 001 - General Fund EXPENSE Account ClassificationFundPersonal Services, Salaries & WagesEmployee BenefitsOther Employee CostsPension BenefitsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuildin g ImprovementsOffice EquipmentOther EquipmentDistribution SystemsInfrastructureInterfund Transfers .00.00.00.00 1,230.50 93,810.21 688,490.25 $783,530.96$783,530.96 Prior Year YTD 2 5047 14% ++++++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00.00 3,164.50 647,733.58 Transactions 3,656,753.00 Budget - YTD $4,307,651.08$4,307,651.08 .00.00.00.00 YTD Prior Fiscal Year Activity Included 2,835.50 56,018.00 648,467.42 Transactions $707,320.92$707,320.92 .00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00.00.00.00 $0.00$0.00 Transactions Current Month .00.00.00.00 Budget 6,000.00 Amended Ћ 3,712,771.001,296,201.00 $5,014,972.00$5,014,972.00 .00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00 Budget Adopted 6,000.00 Expense Budget by Account Classification Report 3,712,771.001,296,201.00 $5,014,972.00$5,014,972.00 Totals EXPENSE TOTALS 002 - Debt Service Fund Fund 002 - Debt Service Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresBond PrincipalInterest ExpenseBank & Fiscal FeesInterfund TransfersOther Financing Uses .00.00.00 65,663.8020,529.2045,152.0129,421.82 121,973.44212,861.97 $495,602.24$495,602.24 Prior Year YTD 05 403434 26% ++++++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00.00 113,030.00315,000.00512,160.69273,471.24 Transactions 1,093,096.42 Budget - YTD $2,306,758.35$2,306,758.35 .00.00.00.00.00.00 YTD Prior Fiscal Year Activity Included 12,609.31 138,775.76321,539.23 Transactions $472,924.30$472,924.30 .00.00.00.00.00.00 YTD 75,000.0013,455.00 242,485.35 $330,940.35$330,940.35 Encumbrances .00.00.00.00.00.00 10,603.91 222,407.08 (13,363.11) Transactions $219,647.88$219,647.88 Current Month .00.00.00.00 Budget Amended Ќ 188,030.00315,000.00538,225.00412,247.00 1,657,121.00 $3,110,623.00$3,110,623.00 .00.00.00.00.00 Budget 58,225.00 110,000.00115,000.00478,121.00 $761,346.00$761,346.00 Amendments .00.00.00.00 Budget Adopted 78,030.00 Expense Budget by Account Classification Report 200,000.00480,000.00412,247.00 1,179,000.00 $2,349,277.00$2,349,277.00 Totals EXPENSE TOTALS 020 - Capital Improvement Fund Fund 020 - Capital Improvement Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresLand ImprovementsBuilding ImprovementsOffice EquipmentMotor EquipmentOther EquipmentInfrastructureInterfund Transfers .00.00.00 7,292.00 1,675,304.27 $1,682,596.27$1,682,596.27 Prior Year YTD 6691 90% +++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00 13,465.00 349,349.09 Transactions $362,814.09$362,814.09 Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 11,430.00 Transactions 2,215,762.94 $2,227,192.94$2,227,192.94 .00.00.00 YTD 15,105.00 1,211,887.97 Encumbrances $1,226,992.97$1,226,992.97 .00.00.00.00 851,742.02 Transactions $851,742.02$851,742.02 Current Month .00.00.00 Budget Amended 40,000.00 Ѝ 3,777,000.00 $3,817,000.00$3,817,000.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 Budget Adopted 40,000.00 Expense Budget by Account Classification Report 3,777,000.00 $3,817,000.00$3,817,000.00 Totals EXPENSE TOTALS 023 - Street Improvement Construc Fund 023 - Street Improvement Construc Fund Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresLand ImprovementsInfrastructureInterfund Transfers .00 27.90 440.00 1,250.604,010.75 19,532.20 116,930.91 $142,192.36$142,192.36 Prior Year YTD 536747192754 50% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 838.95 2,819.804,306.00 59,001.88 114,285.00377,652.24 Transactions $558,903.87$558,903.87 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 1,711.052,486.201,000.00 28,087.6210,824.40 131,369.97 Transactions $175,479.24$175,479.24 .00.00.00.00 YTD 37,206.5030,665.60 318,922.79 $386,794.89$386,794.89 Encumbrances .00.00.00 1,605.399,424.40 11,227.0024,127.90 $46,384.69$46,384.69 Transactions Current Month .00 Budget 2,550.005,306.005,306.00 Amended Ў 124,296.00155,775.00827,945.00 $1,121,178.00$1,121,178.00 .00.00.00.00.00 Budget 53,775.00 247,445.00 $301,220.00$301,220.00 Amendments .00 Budget Adopted 2,550.005,306.005,306.00 Expense Budget by Account Classification Report 124,296.00102,000.00580,500.00 $819,958.00$819,958.00 Totals EXPENSE TOTALS 024 - Flood Control Construction Fund Fund 024 - Flood Control Construction Fund EXPENSE Account ClassificationFundContractual ServicesUtilitiesCommodities & SuppliesOther ExpendituresOther EquipmentDistribution SystemsInfrastructure .00.00 $0.00$0.00 Prior Year YTD +++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 (36,084.84) Transactions ($36,084.84)($36,084.84) Budget - YTD .00 YTD Prior Fiscal Year Activity Included 36,084.84 $36,084.84$36,084.84 Transactions .00.00 YTD $0.00$0.00 Encumbrances .00 36,084.84 $36,084.84$36,084.84 Transactions Current Month .00.00 $0.00$0.00 Budget Amended Џ .00.00 $0.00$0.00 Budget Amendments .00.00 $0.00$0.00 Budget Adopted Expense Budget by Account Classification Report Totals EXPENSE TOTALS 025 - Police & Fire Building Const. Fund 025 - Police & Fire Building Const. EXPENSE Account ClassificationFundContractual ServicesBuilding Improvements 171.35 1,164.36 62,664.9217,224.6920,560.51 133,876.07 1,967,833.44 $2,203,495.34$2,203,495.34 Prior Year YTD 54563657195828 57% Rec'd Summary Listing % Used/ Through 07/31/18 842.06385.67 52,221.7411,113.7529,238.82 124,778.13 Transactions 1,659,071.09 Budget - YTD $1,877,651.26$1,877,651.26 YTD Prior Fiscal Year Activity Included 88.33 481.94 67,639.2615,559.2511,524.18 146,220.87 Transactions 2,234,069.91 $2,475,583.74$2,475,583.74 .00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances 22.64 183.27 9,605.762,222.752,620.00 22,309.25 440,612.59 Transactions $477,576.26$477,576.26 Current Month 474.00 Budget 1,324.00 Amended 26,673.0040,763.00 А 270,999.00119,861.00 3,893,141.00 $4,353,235.00$4,353,235.00 .00.00.00.00.00.00 Budget 5,065.00 $5,065.00$5,065.00 Amendments 474.00 Budget Adopted 1,324.00 26,673.0040,763.00 Expense Budget by Account Classification Report 270,999.00119,861.00 3,888,076.00 $4,348,170.00$4,348,170.00 Totals EXPENSE TOTALS 040 - Refuse Disposal Fund Fund 040 - Refuse Disposal Fund EXPENSE Account ClassificationFundPersonal Services, Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesInsuranceCommodities & Supplies .00 1,949.62 90,744.84 102,353.43269,457.28 $464,505.17$464,505.17 Prior Year YTD 685064 101 82% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 81,985.52 (4,786.00) 114,100.62125,104.55 Transactions $316,404.69$316,404.69 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 83,626.48 199,156.93210,076.48767,094.00 Transactions $1,259,953.89$1,259,953.89 .00.00 YTD 39,853.4514,818.97 168,351.00 $223,023.42$223,023.42 Encumbrances .00.00.00 84,792.6315,898.65 Transactions $100,691.28$100,691.28 Current Month .00 Budget Amended Б 353,111.00165,612.00350,000.00930,659.00 $1,799,382.00$1,799,382.00 .00.00.00.00 Budget 330,659.00 $330,659.00$330,659.00 Amendments .00 Budget Adopted Expense Budget by Account Classification Report 353,111.00165,612.00350,000.00600,000.00 $1,468,723.00$1,468,723.00 Totals EXPENSE TOTALS 041 - Motor Fuel Tax Fund Fund 041 - Motor Fuel Tax Fund EXPENSE Account ClassificationFundContractual ServicesUtilitiesCommodities & SuppliesBuilding ImprovementsInfrastructure .00.00.00.00.00 104.00 26,139.9913,422.52 273,479.18 $313,145.69$313,145.69 Prior Year YTD 2 5591 94% ++++++++++++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00.00 493.25539.51 37,799.13 (2,010.37) $25,901.52$25,901.52 (10,920.00) Transactions Budget - YTD .00.00.00.00 YTD Prior Fiscal Year Activity Included 10.49 610.75 2,010.37 10,920.00 223,174.87 Transactions $236,726.48$236,726.48 .00.00.00.00.00.00.00.00 YTD 176,038.00 $176,038.00$176,038.00 Encumbrances .00.00.00.00.00.00 741.00 4,025.00 152,210.48 Transactions $156,976.48$156,976.48 Current Month .00.00.00.00.00.00 550.00 Budget 1,104.00 Amended В 437,012.00 $438,666.00$438,666.00 .00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00.00.00 550.00 Budget Adopted 1,104.00 Expense Budget by Account Classification Report 437,012.00 $438,666.00$438,666.00 Totals EXPENSE TOTALS 042 - CDBG Fund 042 - CDBG EXPENSE Account ClassificationFundPersonal Services, Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesCommodities & SuppliesOther ExpendituresLand ImprovementsBuilding ImprovementsInfrastructure .00.00 499.99 12,857.70 $13,357.69$13,357.69 Prior Year YTD 0 4654 360 71% Rec'd Summary Listing % Used/ Through 07/31/18 1,000.008,299.22 11,123.31 (7,809.40) $12,613.13$12,613.13 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 7,200.78 13,276.6910,809.40 $31,286.87$31,286.87 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00 91.90 210.42 4,951.58 $5,253.90$5,253.90 Transactions Current Month Budget 1,000.003,000.00 Amended 15,500.0024,400.00 $43,900.00$43,900.00 ЊЉ .00.00.00.00 $0.00$0.00 Budget Amendments Budget Adopted 1,000.003,000.00 15,500.0024,400.00 Expense Budget by Account Classification Report $43,900.00$43,900.00 Totals EXPENSE TOTALS 043 - Asset Seizure Fund Fund 043 - Asset Seizure Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesCommodities & SuppliesOther Equipment .00.00.00 $0.00$0.00 Prior Year YTD 00 0% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 1,000.001,000.00 $2,000.00$2,000.00 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included $0.00$0.00 Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 $0.00$0.00 Transactions Current Month .00 Budget 1,000.001,000.00 Amended $2,000.00$2,000.00 ЊЊ .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Adopted 1,000.001,000.00 $2,000.00$2,000.00 Expense Budget by Account Classification Report Totals EXPENSE TOTALS 044 - Federal Equitable Share Funds Fund 044 - Federal Equitable Share Funds EXPENSE Account ClassificationFundContractual ServicesBuilding ImprovementsOther Equipment .00.00 917.23 6,373.29 $7,290.52$7,290.52 Prior Year YTD 0 55 169 +++ Rec'd 129% Summary Listing % Used/ Through 07/31/18 .00 450.00 1,000.00 (3,465.30) ($2,015.30)($2,015.30) Transactions Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 550.00 3,330.30 $3,880.30$3,880.30 Transactions .00.00.00 YTD 5,135.00 $5,135.00$5,135.00 Encumbrances .00.00.00 550.00 $550.00$550.00 Transactions Current Month .00 Budget 1,000.001,000.005,000.00 Amended $7,000.00$7,000.00 ЊЋ .00.00.00 Budget 4,000.00 $4,000.00$4,000.00 Amendments .00 Budget Adopted 1,000.001,000.001,000.00 $3,000.00$3,000.00 Expense Budget by Account Classification Report Totals EXPENSE TOTALS 045 - DUI Fine Fund Fund 045 - DUI Fine Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesOther EquipmentInterfund Transfers .00.00 1,640.663,703.035,146.596,581.92 $17,072.20$17,072.20 Prior Year YTD 0 22738129 42% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 500.00 1,870.602,487.26 11,716.9021,356.40 $37,931.16$37,931.16 Transactions Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 2,233.105,129.408,643.60 10,512.74 $26,518.84$26,518.84 Transactions .00.00.00.00.00 YTD 1,050.00 $1,050.00$1,050.00 Encumbrances .00.00.00.00 952.28 5,333.00 $6,285.28$6,285.28 Transactions Current Month .00 500.00 Budget 7,000.00 Amended 15,000.0013,000.0030,000.00 $65,500.00$65,500.00 ЊЌ .00.00.00.00 $0.00$0.00 Budget 8,000.00 (8,000.00) Amendments .00 500.00 Budget Adopted 5,000.00 15,000.0015,000.0030,000.00 Expense Budget by Account Classification Report $65,500.00$65,500.00 Totals EXPENSE TOTALS 046 - Foreign Fire Tax Board Fund Fund 046 - Foreign Fire Tax Board Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesInsuranceCommodities & SuppliesBuilding ImprovementsOther Equipment .00 238,414.16 $238,414.16$238,414.16 Prior Year YTD 38 38% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 943,954.33 Transactions $943,954.33$943,954.33 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 579,045.67 Transactions $579,045.67$579,045.67 .00.00 YTD $0.00$0.00 Encumbrances .00 61,876.95 $61,876.95$61,876.95 Transactions Current Month .00 Budget Amended ЊЍ 1,523,000.00 $1,523,000.00$1,523,000.00 .00.00 $0.00$0.00 Budget Amendments .00 Budget Adopted Expense Budget by Account Classification Report 1,523,000.00 $1,523,000.00$1,523,000.00 Totals EXPENSE TOTALS 048 - Business District Fund Fund 048 - Business District Fund EXPENSE Account ClassificationFundBond PrincipalInterest Expense .00.00.00.00.00.00.00.00 19,034.0934,029.88 $53,063.97$53,063.97 Prior Year YTD 0000 4039 157178 ++++++ Rec'd 117% Summary Listing % Used/ Through 07/31/18 .00.00 900.00 1,500.00 750,000.00260,000.00710,000.00112,145.75 Transactions (103,770.97) Budget - YTD ($936,610.51)($936,610.51) (2,667,385.29) .00.00.00.00.00.00 YTD Prior Fiscal Year Activity Included 600.00 71,273.25 222,272.31 Transactions 5,999,752.29 $6,293,897.85$6,293,897.85 .00.00.00.00.00.00.00.00 YTD 62,998.6690,633.00 $153,631.66$153,631.66 Encumbrances .00.00.00.00.00.00.00.00 16,794.1272,500.00 $89,294.12$89,294.12 Transactions Current Month .00.00 Budget 1,500.001,500.00 Amended 181,500.00750,000.00260,000.00710,000.00183,419.00 ЊЎ 3,423,000.00 $5,510,919.00$5,510,919.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Adopted 1,500.001,500.00 Expense Budget by Account Classification Report 181,500.00750,000.00260,000.00710,000.00183,419.00 3,423,000.00 $5,510,919.00$5,510,919.00 Totals EXPENSE TOTALS 049 - Prospect and Main TIF District Fund 049 - Prospect and Main TIF District EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesCommodities & SuppliesOther ExpendituresLand ImprovementsBuilding ImprovementsInfrastructureBond PrincipalInterest ExpenseInterfund Transfers .00.00.00.00.00.00.00 326.19 32,299.4268,708.9758,357.88 465,318.44126,910.85118,371.09294,290.84 1,109,729.424,169,051.43 $6,443,364.53$6,443,364.53 Prior Year YTD 9000 56617752405835336841 56% +++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00 9,966.291,060.00 39,559.1263,750.0010,000.00 361,684.40102,299.28213,598.22182,335.94115,000.00108,248.42 Transactions 1,022,349.494,303,559.231,813,164.67 Budget - YTD $8,346,575.06$8,346,575.06 .00.00.00.00.00.00 YTD Prior Fiscal Year Activity Included 1,450.00 33,632.7168,992.7255,382.8866,532.0375,781.3174,297.58 567,538.60216,086.37 Transactions 1,295,798.514,403,973.87 $6,859,466.58$6,859,466.58 .00.00.00.00.00.00.00.00.00.00.00.00 YTD 4,800.00 49,838.7515,263.75 178,348.90 3,675,662.96 Encumbrances $3,923,914.36$3,923,914.36 .00.00.00.00.00.00.00.00 3,321.167,911.841,386.00 72,298.7410,375.1411,699.0131,081.31 184,383.71745,929.50 Transactions Current Month $1,068,386.41$1,068,386.41 .00.00.00 Budget 1,060.00 Amended 43,599.0094,942.0070,000.0010,000.00 929,223.00171,292.00329,969.00273,381.00115,000.00182,546.00 ЊЏ 2,318,148.008,885,882.005,704,914.00 $19,129,956.00$19,129,956.00 .00.00.00.00.00.00.00.00.00.00.00.00.00.00.00 Budget 101,000.00242,500.00 $343,500.00$343,500.00 Amendments .00.00.00 Budget Adopted 1,060.00 43,599.0094,942.0070,000.0010,000.00 Expense Budget by Account Classification Report 929,223.00171,292.00329,969.00172,381.00115,000.00182,546.00 2,318,148.008,885,882.005,462,414.00 $18,786,456.00$18,786,456.00 Totals EXPENSE TOTALS 050 - Water and Sewer Fund Fund 050 - Water and Sewer Fund EXPENSE Account ClassificationFundPersonal Services, Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuilding ImprovementsOffice EquipmentOther EquipmentDistribution SystemsInfrastructureBond PrincipalInterest ExpenseInterfund Transfers .00.00.00.00.00 14.00 931.00 9,548.355,131.24 19,970.74 $35,595.33$35,595.33 Prior Year YTD 00 5658255868 46% +++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00 272.50552.00 7,496.587,506.00 16,989.5745,986.7216,220.00 $95,023.37$95,023.37 Transactions Budget - YTD .00.00.00.00.00 YTD Prior Fiscal Year Activity Included 381.50 21,687.4310,208.4211,746.1333,780.00 $77,803.48$77,803.48 Transactions .00.00.00.00.00.00.00.00.00 YTD 3,340.15 $3,340.15$3,340.15 Encumbrances .00.00.00.00.00.00 54.50 3,285.061,482.212,261.20 $7,082.97$7,082.97 Transactions Current Month .00.00.00 654.00552.00 Budget 7,506.00 Amended 38,677.0017,705.0061,073.0050,000.00 ЊА $176,167.00$176,167.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 654.00552.00 Budget Adopted 7,506.00 38,677.0017,705.0061,073.0050,000.00 Expense Budget by Account Classification Report $176,167.00$176,167.00 Totals EXPENSE TOTALS 051 - Village Parking System Fund Fund 051 - Village Parking System Fund EXPENSE Account ClassificationFundPersonal Services, Salaries & WagesEmployee BenefitsContractual ServicesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuilding ImprovementsInfrastructureInterfun d Transfers .00.00.00.00 806.19 7,036.013,619.581,692.25 14,691.9933,149.20 $60,995.22$60,995.22 Prior Year YTD 2 5657492558 66% ++++++++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00.00 402.94 5,571.248,519.20 12,423.7755,769.7210,371.55 $59,715.07$59,715.07 (33,343.35) Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 564.06213.45 7,525.762,867.809,783.35 15,851.2341,930.29 $78,735.94$78,735.94 Transactions .00.00.00.00.00.00.00.00 YTD 11,197.9923,560.00 $34,757.99$34,757.99 Encumbrances .00.00.00.00.00 80.58 559.17 2,395.021,090.61 13,270.16 $17,395.54$17,395.54 Transactions Current Month .00.00.00.00 967.00 Budget Amended 28,275.0013,097.0011,387.0010,585.00 108,898.00 ЊБ $173,209.00$173,209.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00 967.00 Budget Adopted 28,275.0013,097.0011,387.0010,585.00 Expense Budget by Account Classification Report 108,898.00 $173,209.00$173,209.00 Totals EXPENSE TOTALS 052 - Parking System Revenue Fund Fund 052 - Parking System Revenue Fund EXPENSE Account ClassificationFundPersonal Services, Salaries & WagesEmployee BenefitsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuilding ImprovementsInterfund Transfers .00.00 3,692.132,693.062,954.77 44,946.94 558,656.27228,945.20241,653.49 $1,083,541.86$1,083,541.86 Prior Year YTD 6078986076845091 70% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 100.97801.85303.80360.00 88,852.2443,886.6081,708.16 406,103.08 Transactions $622,116.70$622,116.70 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 298.20 3,984.032,523.153,504.00 47,113.20 602,328.92316,470.76342,924.52 Transactions $1,319,146.78$1,319,146.78 .00.00.00.00.00.00.00 YTD 17,800.2097,146.32 $114,946.52$114,946.52 Encumbrances .00.00 422.00355.74 5,378.823,014.00 82,624.5931,825.8753,156.60 Transactions $176,777.62$176,777.62 Current Month .00 602.00 Budget 4,085.003,325.003,864.00 Amended 405,323.00108,800.00521,779.00 ЊВ 1,008,432.00 $2,056,210.00$2,056,210.00 .00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 602.00 Budget Adopted 4,085.003,325.003,864.00 Expense Budget by Account Classification Report 405,323.00108,800.00521,779.00 1,008,432.00 $2,056,210.00$2,056,210.00 Totals EXPENSE TOTALS 060 - Vehicle Maintenance Fund Fund 060 - Vehicle Maintenance Fund EXPENSE Account ClassificationFundPersonal Services, Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesCommodities & SuppliesOther ExpendituresOffice EquipmentOther Equipment .00.00 1,751,201.90 $1,751,201.90$1,751,201.90 Prior Year YTD 43 43% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 Transactions 1,683,748.25 Budget - YTD $1,683,748.25$1,683,748.25 .00.00 YTD Prior Fiscal Year Activity Included 344,704.49 Transactions $344,704.49$344,704.49 .00.00 YTD 929,993.26 $929,993.26$929,993.26 Encumbrances .00.00 269,585.46 Transactions $269,585.46$269,585.46 Current Month .00.00 Budget Amended ЋЉ 2,958,446.00 $2,958,446.00$2,958,446.00 .00.00 Budget 572,446.00 $572,446.00$572,446.00 Amendments .00.00 Budget Adopted Expense Budget by Account Classification Report 2,386,000.00 $2,386,000.00$2,386,000.00 Totals EXPENSE TOTALS 061 - Vehicle Replacement Fund Fund 061 - Vehicle Replacement Fund EXPENSE Account ClassificationFundOther ExpendituresMotor EquipmentInterfund Transfers .00.00 24,148.73 $24,148.73$24,148.73 Prior Year YTD 21 21% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00.00 234,517.31 Transactions $234,517.31$234,517.31 Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 48,605.50 $48,605.50$48,605.50 Transactions .00.00 YTD 12,392.19 $12,392.19$12,392.19 Encumbrances .00.00 7,590.97 $7,590.97$7,590.97 Transactions Current Month .00.00 Budget Amended 295,515.00 ЋЊ $295,515.00$295,515.00 .00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Adopted Expense Budget by Account Classification Report 295,515.00 $295,515.00$295,515.00 Totals EXPENSE TOTALS 062 - Computer Replacement Fund Fund 062 - Computer Replacement Fund EXPENSE Account ClassificationFundOther ExpendituresBuilding ImprovementsOffice Equipment .00.00 9,800.003,013.13 5,207,206.59 $5,220,019.72$5,220,019.72 Prior Year YTD 0 7236 72% ++++++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 27,000.0012,715.35 (1,112.65) Transactions 2,411,471.72 Budget - YTD $2,450,074.42$2,450,074.42 .00.00 YTD Prior Fiscal Year Activity Included 7,284.651,112.65 Transactions 6,154,866.28 $6,163,263.58$6,163,263.58 .00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 5,764.30 716,837.52 Transactions $722,601.82$722,601.82 Current Month .00.00 Budget Amended 27,000.0020,000.00 ЋЋ 8,566,338.00 $8,613,338.00$8,613,338.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Adopted 27,000.0020,000.00 Expense Budget by Account Classification Report 8,566,338.00 $8,613,338.00$8,613,338.00 Totals EXPENSE TOTALS 063 - Risk Management Fund Fund 063 - Risk Management Fund EXPENSE Account ClassificationFundContractual ServicesInsuranceCommodities & SuppliesOther EquipmentInterfund Transfers .00.00.00 9,210.00 42,097.02 2,799,790.62 $2,851,097.64$2,851,097.64 Prior Year YTD 00 613880 60% +++ Rec'd Summary Listing % Used/ Through 07/31/18 .00 100.00 2,000.00 15,000.00 101,872.25 Transactions 1,984,388.65 Budget - YTD $2,103,360.90$2,103,360.90 .00.00.00 YTD Prior Fiscal Year Activity Included 8,000.00 63,627.75 Transactions 3,049,166.35 $3,120,794.10$3,120,794.10 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 20,107.00 466,026.04 Transactions $486,133.04$486,133.04 Current Month .00 100.00 Budget Amended 15,000.0010,000.00 165,500.00 ЋЌ 5,033,555.00 $5,224,155.00$5,224,155.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 100.00 Budget Adopted 15,000.0010,000.00 Expense Budget by Account Classification Report 165,500.00 5,033,555.00 $5,224,155.00$5,224,155.00 Totals EXPENSE TOTALS 070 - Police Pension Fund Fund 070 - Police Pension Fund EXPENSE Account ClassificationFundPension BenefitsContractual ServicesInsuranceCommodities & SuppliesOther ExpendituresOffice Equipment .00.00 8,795.00 60,145.59 3,121,924.11 $3,190,864.70$3,190,864.70 Prior Year YTD $55,997,574.60 00 615182 60% Rec'd Summary Listing % Used/ Through 07/31/18 100.00 1,810.00 66,075.8315,000.00 Transactions 2,195,038.55 Budget - YTD $2,278,024.38$2,278,024.38 $51,619,257.04 .00.00 YTD Prior Fiscal Year Activity Included 8,190.00 67,424.17 Transactions 3,406,571.45 $3,482,185.62$3,482,185.62 $65,900,348.49 .00.00.00.00.00 YTD $0.00$0.00 Encumbrances $8,677,411.47 .00.00.00 14,180.00 489,912.36 Transactions $504,092.36$504,092.36 Current Month $10,827,405.50 100.00 Budget Amended 15,000.0010,000.00 133,500.00 ЋЍ 5,601,610.00 $5,760,210.00$5,760,210.00 $126,197,017.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments $2,505,254.00 100.00 Budget Adopted 15,000.0010,000.00 Expense Budget by Account Classification Report 133,500.00 5,601,610.00 $5,760,210.00$5,760,210.00 $123,691,763.00 Totals Grand Totals EXPENSE TOTALS 071 - Fire Pension Fund Fund 071 - Fire Pension Fund EXPENSE Account ClassificationFundPension BenefitsContractual ServicesInsuranceCommodities & SuppliesOther Expenditures Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: DIRECTOR OF FINANCE DATE: AUGUST 16, 2018 SUBJECT: MONTHLY FINANCIAL REPORT JULY 2018 Attached hereto are the cash position and investment statements of the Village for the month ended July 31 noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you on by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these are not funds accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report All Funds (page 4) This report provides a detailed summary of cash and investments for the Village broken out by governmental and enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and Internal Service Funds. The Enterprise Funds consist of the Water/Sewer Fund and two (2) Parking Funds. include the Escrow Deposit and Flex comp Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flex comp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. Governmental and Enterprise Funds - Cash and cash equivalents at June 30 was $53.2 million. During July, cash receipts totaled $9,610,618 and investment income was $73,827. Reductions in cash and cash equivalents during July totaled $5,794,684. Of this amount, payments to vendors were $4,156,211 and employee payroll expenses were $1,625,660. Outflows resulting from interfund activity totaled $17,808 while other reductions to cash totaled $12,813. Cash and cash equivalents at July 31 were $57.1 million. Investments in the Governmental and Enterprise Funds at June 30 were $6,192,560. During the month of July, investment income showed a loss of $3,030. Enterprise Funds reside in multiple Funds investing surplus funds above what is needed for cash flow purposes. Total investments at July 31 remaine at $6.2 million. Total cash and investments for Governmental and Enterprise Funds at June 30 were $59,411,729. Cash and investments at July 31 totaled $63,280,652. This is an increase of $3,868,923 for the month. Monthly Financial Report July 2018 16, 2018 Page 2 TrustandAgency Funds-Cashandcash equivalentsat June30was$3.0million.DuringJuly,cash receipts totaled $1,861,988. Investment income for the month was $84,210. There was also a net decrease incashduetoinvestmentactivitiesof$409,737whileinflowsduetoInterfundactivitytotaled$17,808. ReductionsincashandcashequivalentsduringJulytotaled$995,679.Ofthisamount,paymentsto vendors were $168,591 and employee payroll and related expenses were $825,399. Other disbursements totaled $1,689. Cash and cash equivalents at July 31 were $3.6 million. Total investments atJuly 31 were$138,701,690,an increaseof $2,599,370 from June30.Therewere investment gains of$2,189,633 anda nettransferfrom cash of $409,737 thataccounted for the change. Total cashandinvestments forTrustandAgency Funds atJune30 were$139,139,537.Cashand investments atJuly 31 totaled $142,297,496. This isan increase of $3,157,959. Summary of CashActivity by Fund Type (page 5) This reportprovides a breakdown of the cash activity forthe monthbroken downby fund type. This breakdownis useful inidentifyingwherethe activity (receipts and disbursements) is occurring.Thereare times during theyearwhen activity incertainfunds suchas the capital improvementand special revenue funds is higher thannormal.This will distortthe financial picture of someof the other components of the governmental funds suchas the General Fundwhichtends tobe morelevel and predictableinterms of spending andreceiptof revenue.Eachmonththereportwill providedetail explanation on activity of the eGeneral Fund is highlighted below. GeneralFundCashandcashequivalentsatJune30totaled$14,845,551.DuringJuly,cashreceipts totaled $5,850,213, and investment income was $8,453. Significant cash receipts include sales and income taxes. Salestax revenues for the month totaled $1,853,416. Sales taxes received in Julyare for Aprilsales as there is a three-month lag in getting this distribution from the state. State income taxreceipts for Julytotaled $464,032and were for the month of June. Disbursements from the General Fund for Julyincluded payments to vendors of $1,619,487, payments for employee wages and benefits of $1,431,017and other disbursements of $6,090. There was also a net decrease in cash from Interfund transfers totaling $827,574. Cash and cash equivalents at July 31were $16,820,048, an increase of $1,974,497from June 30. In addition, investments consisting of certificates of deposit totaling $2,471,350bring total cash and investments for the General Fund to $19,291,398. Statement of Investments (page 6) This report provides a breakdown of investments by trust and agency funds and governmental and enterprise funds. The report also provides a fund-by-fund breakdown of the investments. Government and Enterprise Funds-Investments for the governmental and agency funds are made up of Certificates of Deposit. At July 31, there was a total of $6,189,531 governmental and enterprise funds. A detail list of holdings is included with this report. Trust and Agency FundsThe investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. At July 31, there was a total of Monthly Financial Report July 2018 16, 2018 Page 3 $138,701,690 invested in a combination of fixed income and equity instruments. A detail list of holdings is pension funds is governed by an Investment Policy adopted by each Pension Board. Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third-party holder of the fixed income securities.The funds are managed by three investment management firms, Galliard, Segall Bryant and Mesirow Financial. SegallBryantholdsapproximatelyhalfofthefixedincomeinvestmentsforthetwopensionfundswhile Galliard and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investmentsin equitiesconsistofmutualfundsspread acrossvarioussectors(small,mid andlarge-cap stocks) as well as investment philosophies (value, core and growth). The funds also invest a small amount ininternationalstocks.Each yearthe investmentmixis evaluatedforoptimal diversificationtomeetpension fundinvestmentpolicygoalsandobjectives.EquityinvestmentsheldbythePolicePensionFundare managedbySawyerFaldutoAssetManagement.Abreakdownofwherepensionfundsareinvestedis included with this report. Conclusion This cashpositionreportis intended to provide asn monthenddate.Using this report,weareabletoprovide trend information tosupportcashmanagement mitments. This reportis provided tothe Village Boardand FinanceCommission on amonthly basis.Pleasedo not hesitateto contact me withany questions. David O. Erb Director of Finance VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended July 31, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and CashTotal Cash and EquivalentsInvestmentsInvestments Balance at June 30, 2018$53,219,168.63**$ 6,192,560.22$59,411,728.85 Cash receipts9,610,618.239,610,618.23 Investment income73,826.96(3,029.72)70,797.24 Transfers from investments to cash--- Transfers to investments from cash--- Interfund activity(17,807.92)(17,807.92) Disbursements: Accounts payable(4,156,211.48)(4,156,211.48) Payroll(1,625,659.75)(1,625,659.75) Other(12,812.85)(12,812.85) Balance at July 31, 2018$57,091,121.82$ 6,189,530.50$63,280,652.32 TRUST AND AGENCY FUNDS * Cash and CashTotal Cash and EquivalentsInvestmentsInvestments Balance at June 30, 2018$3,037,216.36$136,102,320.19$139,139,536.55 Cash receipts1,861,987.691,861,987.69 Investment income (loss)84,209.752,189,632.832,273,842.58 Transfers from investments to cash1,027,170.97(1,027,170.97)- Transfers to investments from cash(1,436,907.86)1,436,907.86- Interfund activity17,807.9217,807.92 Disbursements: Accounts payable(168,591.04)(168,591.04) Payroll(810,044.68)(810,044.68) Flex spending(15,354.41)(15,354.41) Other(1,688.99)(1,688.99) Balance at July 31, 2018$3,595,805.71$138,701,689.91$142,297,495.62 * Assets are restricted in purpose and do not represent discretionary assets of the government. ** Balance restated to include 2018A Bond Proceeds not reflected in May 2018 report. 4 5 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of July 31, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS MaturityPurchaseFinancial InvestmentCUSIP/Market DateDateInstitutionDescriptionFDIC #Net YieldValue GENERAL FUND (001) 12/31/1812/28/17U.S. Treasury NoteTreasury Note912828A751.500%1,240,403.60 12/13/1912/28/17Federal Home Loan BankAgency Notes3130A0JR22.375%1,230,946.73 2,471,350.33 VEHICLE REPLACEMENT FUND (061) 05/30/1912/28/17Freddie MacAgency Notes3137EADG11.750%1,243,292.50 06/12/2012/28/17Federal Home Loan BankAgency Notes313383MB41.875%1,231,300.00 12/11/2012/28/17Federal Home Loan BankAgency Notes3130A3UQ51.875%1,223,525.00 3,698,117.50 RISK MANAGEMENT FUND (063) 03/06/1903/06/17Mount Prospect State BankCertificate of Deposit3540580.250%20,062.67 20,062.67 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS$ 6,189,530.50 TRUST AND AGENCY FUNDS * MaturityPurchaseFinancial InvestmentCUSIP/InterestMarket DateDateInstitutionDescriptionAcct #Rate %Value POLICE PENSION FUND (070) VariousVariousWells FargoWells Fargo InvestmentsVariousVarious$ 23,198,922.60 VariousVariousVariousMutual Fund InvestmentsVariousVarious49,160,035.57 72,358,958.17 FIRE PENSION FUND (071) Various5/26/2015Principal Life Insurance CompanyGroup Annuity Contract8-10810Variable5,910,130.71 VariousVariousWells FargoWells Fargo InvestmentsVariousVarious22,162,144.46 VariousVariousVariousMutual Fund InvestmentsVariousVarious38,270,456.57 66,342,731.74 TOTAL TRUST AND AGENCY FUND INVESTMENTS$ 138,701,689.91 * Assets are restricted in purpose and do not represent discretionary assets of the government. 6