Loading...
2020.11 Monthly Budget Report MONTHLY BUDGET FINANCIAL STATUS UPDATE To: Mayor and Council members From: Noah Crocker, Finance Director Period: November 2020 OVERVIEW: The Finance Department is committed to providing clear information to the Mayor, Council and staff regarding the budget status of the City. We have prepared the following reports to keep you up to date on the current budget status of the City. 1) Budget Report 2) Detail Fund Summary Report BUDGET REPORT: The Budget report will first provide Operational Funds and follow up with Capital Projects Funds. This report does not include beginning fund balance. This report is designed to provide a high-level view of each fund reviewing total revenues and expenses. The report does provide expense information by department. The goal of the City is to pay all current budget year expenses with current budget year revenues. We are not quite there yet, and this will show in the Surplus (Deficit) line at the end of each fund. We expect that future budget cycles will smooth out revenues and expenditures. The Budget Report provides information on current revenues and expenditures by fund including the following: • The original budgeted amount. • Current budget which would reflect any amendments that have been made. • Period activity which details the revenue and expense activity for the period in which the report was run. • Fiscal activity will provide the year to date expense and revenue amounts • Variance Shows the difference between budgeted and actual. • Percent remaining is the amount still needed to reach the budgeted amount. CASH AND INVESTMENT FUND SUMMARY The Cash and Investment Fund Summary provides information on current total cash & investment balances by Fund. Page 1 of 10 POINTS OF INTEREST: Current Expense Fund 001 – The Current Expense Fund is used for the general governmental functions of the City. The revenues received through November 2020 exceed our budget by 7.52%. The effects of the COVID19 pandemic had little effect on November Current Expense Fund revenues. Future reports will show what effects the COVID19 Pandemic may have on the City’s Current Expense Fund. The table provides budget versus actual (YTD) data by source of revenue. The table also shows revenue received for the month of September. SALES TAX REVENUES SUMMARY • Total 2020 Budget: $5,085,000 • Total 2020 YTD Actuals: $5,244,207 • Year-to-Date Actual revenue collected is 12.20% higher when compared to Year-to Date Budgeted • Year-to-Date Actual revenue collected is 6.83% higher when compared to Prior Year-to Date Actuals The following tables provide additional sales tax information. Table 1: Shows revenue received by month over a three year period Table 2: provides current data for sales tax revenue collected Year-to-date Revenue Source 2020 Original Budget 2020 Current Budget 2020 YTD % of Budget Received Received November 2020 Property Tax 1,900,000 1,900,000 1,901,957 100.10%100,722 Sales Tax 5,085,000 5,085,000 5,244,207 103.13%549,714 Other Taxes 2,125,000 2,125,000 2,070,243 97.42%128,040 Total Taxes 9,110,000 9,110,000 9,216,407 101.17% 778,476 Licenses & Permits 405,300 405,300 627,830 154.90%48,747 Intergovernmental Revenue 226,700 226,700 509,498 224.75%10,485 Charges for Goods & Services 444,800 444,800 567,501 127.59%49,727 Fines & Penalties 179,700 179,700 159,265 88.63%14,468 Misc Revenues 173,800 173,800 229,345 131.96%15,721 Non-Revenues - - 17,806 0.00%1,606 Capital Contributions - - 5,000 0.00%- REVENUE TOTALS 10,540,300 10,540,300 11,332,651 107.52%919,230 Current Expense Fund Revenues Page 2 of 10 Real Estate Excise Tax (REET) Fund 109 and Impact Mitigation Fee Fund 111 Real Estate Excise Tax receipts fluctuate monthly but are trending up through November 2020 7.15% higher than revenue received at the same time-period for 2019. REET continues to come in above what was projected for the 2020 budget year. The table below shows biennial balances through October 2020 for REET 1 & 2 and Impact fees. These restricted funds are used as a local funding source for capital projects that have been documented in the City’s comprehensive plans. REET funds are also used for debt payments. The table shows 2019 beginning fund balances, biennial revenue received, expenses budgeted for the biennium and expenses which are obligated for future projects but have not yet been officially budgeted. The intent of this table is to snapshot and illustrate available balances and what is projected for the end of the biennium. This table includes project cost revisions which were approved as part of the mid biennial review amendment Ordinance # 044-19, adopted by Council on October 22, 2019 and a 2020 Budget Amendment, Ordinance #024-20. Impact Fees received for the November 2020 are as follows: McCormick Woods Transportation $20,245.59, Parks $6,488.00, Transportation $2,486.68. REET revenues received in September: REET 1 received $42,492.72, REET 2 received $42,492.71. Capital Construction Fund 302 – The City awarded the design of the McCormick Woods Splash Pad to Land Expressions, LLC. (C-056-20). The work was completed October 2020. Street Capital Construction Fund 304 – Public Works is continuing to work towards final close out of the Tremont Widening Project with closeout change order & amendment going to Dec 15th Council. Bay Street Pedestrian Path Right of Way efforts are ongoing. – No change ENTERPRISE/UTILITY FUNDS: Water operation - Water operations budgeted revenues in the amount of $3,353,200 for 2020. Through October the City has received 95.81% of the annual budgeted revenues. Revenues for the Water utility, in winter and spring, are typically lower with larger monthly revenues received during the warmer summer and fall months. Revenues received in October are for the August-September cycle. Impact Fees REET Recreation Reserve MW Transport Impact Parks Impact Bayside Plat SEPA Transportation REET 1 REET 2 Recreation Reserve (001) Admissions 2019-2020 Beginning Balance 536,834 44,266 316,474 542,494 688,136 1,321,810 54,930 2019-2020 Revenue Received*331,756 250,233 6,342 658,187 1,056,828 1,056,864 63,182 2019-2020 Expenses Budgeted (98,353) (100,000) (313,285) (365,000) (162,914) (1,472,517) (25,000) 2019-2020 Obligated Expenses - - - - (458,000) - - 2019-2020 Ending Balance 770,238 194,499 9,531 835,682 1,124,050 906,157 93,112 *Revenue received includes interest earned Page 3 of 10 Operational expenses through the end of November are at 62.11% of the annual budgeted amount for 2020. Leaving a remaining budget of 37.89%. The water operational expense budget also includes transfers which have not yet been executed. The City manages its transfers according to when the anticipated expenses are to occur in the Water Capital Project, Debt or ER&R fund. Thus, there are currently approximately $1.185 million of transfers budgeted in 2019-2020 which have not occurred yet. Sewer operation - Sewer Operational Revenues received for the period ending November 2020 are trending at 93.5% of the annual budgeted revenue. Operational Sewer expenses are at 54.25% for the period ending November 2020 leaving 45.75% of available annual budget authority to be used in 2020. The sewer operational expense budget also includes transfers which have not yet been executed. The City manages its transfers according to when the anticipated expenses are to occur in the Sewer Capital Project, Debt or ER&R fund. There are currently approximately $2.051 million of transfers budgeted in 2019-2020 which have not occurred yet. Storm Drainage operations -As of November the Storm Drainage utility has received 96.79% of its annual budgeted revenue. Expenses through November for the Storm Drainage Operations Fund are at 80.70%, leaving 19.30% remaining budget authority through the end of the year. The storm drainage operational expense budget also includes transfers which have not yet been executed. The City manages its transfers according to when the anticipated expenses are to occur in the Storm Drainage Capital Project, Debt or ER&R fund. All budgeted transfers for 2019- 2020 have occurred. Page 4 of 10 12/15/2020 8:54:47 AM Page 1 of 5 Budget Report City of Port Orchard Group Summary For Fiscal: 2020 Period Ending: 11/30/2020 Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining Fund: 001 - Current Expense Revenue 00 - Revenues 11,332,650.70919,229.5710,540,300.00 10,540,300.00 792,350.70 7.52 % 11,332,650.70919,229.5710,540,300.00 10,540,300.00 792,350.70Revenue Total:7.52 % Expense 01 - Finance 821,169.5773,734.42872,500.00 872,500.00 51,330.43 5.88 % 02 - Court 456,358.2436,241.97709,600.00 722,141.00 265,782.76 36.80 % 03 - Law Enforcement 3,732,466.47293,390.925,368,387.00 5,268,387.00 1,535,920.53 29.15 % 04 - Community Development 1,349,985.7998,456.011,435,917.00 1,641,917.00 291,931.21 17.78 % 05 - Public Works 992,321.8758,270.371,126,771.00 1,226,771.00 234,449.13 19.11 % 06 - Miscellaneous 1,188,615.501,186,853.00350,000.00 1,211,853.00 23,237.50 1.92 % 07 - Administration 1,114,785.08117,201.881,521,018.00 1,191,018.00 76,232.92 6.40 % 9,655,702.521,864,148.5711,384,193.00 12,134,587.00 2,478,884.48Expense Total:20.43 % 1,676,948.18-944,919.00-843,893.00 -1,594,287.00 3,271,235.18Fund: 001 - Current Expense Surplus (Deficit):205.18 % Fund: 002 - City Street Fund Revenue 00 - Revenues 1,950,125.64531,567.581,634,000.00 1,904,000.00 46,125.64 2.42 % 1,950,125.64531,567.581,634,000.00 1,904,000.00 46,125.64Revenue Total:2.42 % Expense 05 - Public Works 1,088,315.3774,483.551,683,871.00 1,748,871.00 660,555.63 37.77 % 1,088,315.3774,483.551,683,871.00 1,748,871.00 660,555.63Expense Total:37.77 % 861,810.27457,084.03-49,871.00 155,129.00 706,681.27Fund: 002 - City Street Fund Surplus (Deficit):-455.54 % Fund: 003 - Stabilization Fund Revenue 00 - Revenues 774,671.06767,038.42200,000.00 766,853.00 7,818.06 1.02 % 774,671.06767,038.42200,000.00 766,853.00 7,818.06Revenue Total:1.02 % 774,671.06767,038.42200,000.00 766,853.00 7,818.06Fund: 003 - Stabilization Fund Total:1.02 % Fund: 103 - Criminal Justice Revenue 00 - Revenues 306,461.0326,216.64244,700.00 244,700.00 61,761.03 25.24 % 306,461.0326,216.64244,700.00 244,700.00 61,761.03Revenue Total:25.24 % Expense 03 - Law Enforcement 292,159.23170,746.38325,686.00 325,686.00 33,526.77 10.29 % 292,159.23170,746.38325,686.00 325,686.00 33,526.77Expense Total:10.29 % 14,301.80-144,529.74-80,986.00 -80,986.00 95,287.80Fund: 103 - Criminal Justice Surplus (Deficit):117.66 % Fund: 104 - Special Investigative Unit Revenue 00 - Revenues 4,387.45183.664,000.00 4,000.00 387.45 9.69 % 4,387.45183.664,000.00 4,000.00 387.45Revenue Total:9.69 % Expense 03 - Law Enforcement 1,681.0611.462,200.00 3,436.00 1,754.94 51.08 % 1,681.0611.462,200.00 3,436.00 1,754.94Expense Total:51.08 % 2,706.39172.201,800.00 564.00 2,142.39Fund: 104 - Special Investigative Unit Surplus (Deficit):-379.86 % Fund: 107 - Community Events Revenue 00 - Revenues 94,885.1310,093.92100,000.00 100,000.00 -5,114.87 5.11 % 94,885.1310,093.92100,000.00 100,000.00 -5,114.87Revenue Total:5.11 % _________________________________________________________________________________________________________________________________________________Operating Page 5 of 10 Budget Report For Fiscal: 2020 Period Ending: 11/30/2020 12/15/2020 8:54:47 AM Page 2 of 5 Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining Expense 01 - Finance 0.000.002,500.00 2,500.00 2,500.00 100.00 % 07 - Administration 22,827.314,122.57109,700.00 109,700.00 86,872.69 79.19 % 22,827.314,122.57112,200.00 112,200.00 89,372.69Expense Total:79.65 % 72,057.825,971.35-12,200.00 -12,200.00 84,257.82Fund: 107 - Community Events Surplus (Deficit):690.64 % Fund: 108 - Paths & Trails Revenue 00 - Revenues 1,066.85101.591,000.00 1,000.00 66.85 6.69 % 1,066.85101.591,000.00 1,000.00 66.85Revenue Total:6.69 % 1,066.85101.591,000.00 1,000.00 66.85Fund: 108 - Paths & Trails Total:6.69 % Fund: 109 - Real Estate Excise Tax Revenue 00 - Revenues 1,006,987.7486,179.26700,000.00 700,000.00 306,987.74 43.86 % 1,006,987.7486,179.26700,000.00 700,000.00 306,987.74Revenue Total:43.86 % Expense 06 - Miscellaneous 298,006.160.020.00 977,600.00 679,593.84 69.52 % 298,006.160.020.00 977,600.00 679,593.84Expense Total:69.52 % 708,981.5886,179.24700,000.00 -277,600.00 986,581.58Fund: 109 - Real Estate Excise Tax Surplus (Deficit):355.40 % Fund: 111 - Impact Mitigation Fee Revenue 00 - Revenues 874,618.8929,938.10140,000.00 140,000.00 734,618.89 524.73 % 874,618.8929,938.10140,000.00 140,000.00 734,618.89Revenue Total:524.73 % Expense 05 - Public Works 47,310.010.000.00 55,000.00 7,689.99 13.98 % 06 - Miscellaneous 0.000.00150,000.00 778,285.00 778,285.00 100.00 % 47,310.010.00150,000.00 833,285.00 785,974.99Expense Total:94.32 % 827,308.8829,938.10-10,000.00 -693,285.00 1,520,593.88Fund: 111 - Impact Mitigation Fee Surplus (Deficit):219.33 % Fund: 206 - Bond Redemption Fund Revenue 00 - Revenues 298,006.160.020.00 298,006.00 0.16 0.00 % 298,006.160.020.00 298,006.00 0.16Revenue Total:0.00 % Expense 06 - Miscellaneous 298,006.160.02298,007.00 298,007.00 0.84 0.00 % 298,006.160.02298,007.00 298,007.00 0.84Expense Total:0.00 % 0.000.00-298,007.00 -1.00 1.00Fund: 206 - Bond Redemption Fund Surplus (Deficit):100.00 % Fund: 411 - Water Operating Revenue 00 - Revenues 3,212,664.81281,982.833,353,200.00 3,353,200.00 -140,535.19 4.19 % 3,212,664.81281,982.833,353,200.00 3,353,200.00 -140,535.19Revenue Total:4.19 % Expense 05 - Public Works 2,040,989.70135,819.242,258,138.00 2,258,138.00 217,148.30 9.62 % 06 - Miscellaneous 292,400.00290,000.00527,500.00 1,477,500.00 1,185,100.00 80.21 % 2,333,389.70425,819.242,785,638.00 3,735,638.00 1,402,248.30Expense Total:37.54 % 879,275.11-143,836.41567,562.00 -382,438.00 1,261,713.11Fund: 411 - Water Operating Surplus (Deficit):329.91 % Fund: 412 - Water Stabilization Revenue 00 - Revenues 290,634.24290,014.80290,000.00 290,000.00 634.24 0.22 % 290,634.24290,014.80290,000.00 290,000.00 634.24Revenue Total:0.22 % 290,634.24290,014.80290,000.00 290,000.00 634.24Fund: 412 - Water Stabilization Total:0.22 % Page 6 of 10 Budget Report For Fiscal: 2020 Period Ending: 11/30/2020 12/15/200 8:54:47 AM Page 3 of 5 Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining Fund: 414 - Water Debt Service Revenue 00 - Revenues 22,475.000.0050,000.00 50,000.00 -27,525.00 55.05 % 22,475.000.0050,000.00 50,000.00 -27,525.00Revenue Total:55.05 % Expense 06 - Miscellaneous 22,475.000.0050,000.00 50,000.00 27,525.00 55.05 % 22,475.000.0050,000.00 50,000.00 27,525.00Expense Total:55.05 % 0.000.000.00 0.00 0.00Fund: 414 - Water Debt Service Surplus (Deficit):0.00 % Fund: 421 - Storm Drainage Utility Revenue 00 - Revenues 1,692,155.42170,779.821,639,500.00 1,639,500.00 52,655.42 3.21 % 1,692,155.42170,779.821,639,500.00 1,639,500.00 52,655.42Revenue Total:3.21 % Expense 05 - Public Works 964,250.0588,365.851,202,066.00 1,230,766.00 266,515.95 21.65 % 06 - Miscellaneous 187,190.1610,199.98215,890.00 187,190.00 -0.16 0.00 % 1,151,440.2198,565.831,417,956.00 1,417,956.00 266,515.79Expense Total:18.80 % 540,715.2172,213.99221,544.00 221,544.00 319,171.21Fund: 421 - Storm Drainage Utility Surplus (Deficit):-144.07 % Fund: 422 - Storm Drainage Stabilization Revenue 00 - Revenues 11,248.8210,222.4410,200.00 10,200.00 1,048.82 10.28 % 11,248.8210,222.4410,200.00 10,200.00 1,048.82Revenue Total:10.28 % 11,248.8210,222.4410,200.00 10,200.00 1,048.82Fund: 422 - Storm Drainage Stabilization Total:10.28 % Fund: 424 - Storm Drainage Debt Service Revenue 00 - Revenues 176,990.16-0.02176,990.00 176,990.00 0.16 0.00 % 176,990.16-0.02176,990.00 176,990.00 0.16Revenue Total:0.00 % Expense 06 - Miscellaneous 176,990.16-0.02176,990.00 176,990.00 -0.16 0.00 % 176,990.16-0.02176,990.00 176,990.00 -0.16Expense Total:0.00 % 0.000.000.00 0.00 0.00Fund: 424 - Storm Drainage Debt Service Surplus (Deficit):0.00 % Fund: 431 - Sewer Operating Revenue 00 - Revenues 5,074,764.98415,259.805,427,400.00 5,427,400.00 -352,635.02 6.50 % 5,074,764.98415,259.805,427,400.00 5,427,400.00 -352,635.02Revenue Total:6.50 % Expense 05 - Public Works 3,125,100.17348,805.003,773,488.00 3,811,388.00 686,287.83 18.01 % 06 - Miscellaneous 165,475.00165,475.00856,300.00 2,217,129.00 2,051,654.00 92.54 % 3,290,575.17514,280.004,629,788.00 6,028,517.00 2,737,941.83Expense Total:45.42 % 1,784,189.81-99,020.20797,612.00 -601,117.00 2,385,306.81Fund: 431 - Sewer Operating Surplus (Deficit):396.81 % Fund: 432 - Sewer Stabilization Revenue 00 - Revenues 167,841.78165,535.0118,400.00 165,475.00 2,366.78 1.43 % 167,841.78165,535.0118,400.00 165,475.00 2,366.78Revenue Total:1.43 % 167,841.78165,535.0118,400.00 165,475.00 2,366.78Fund: 432 - Sewer Stabilization Total:1.43 % Fund: 500 - Equipment Rental and Revolving Revenue 00 - Revenues 459,170.42178,295.83753,402.00 732,697.00 -273,526.58 37.33 % 459,170.42178,295.83753,402.00 732,697.00 -273,526.58Revenue Total:37.33 % Expense 10 - ER&R 1,022,501.5025,253.65370,857.00 1,128,357.00 105,855.50 9.38 % Page 7 of 10 Budget Report For Fiscal: 2020 Period Ending: 11/30/2020 Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityDepartment Current Total Budget Original Total Budget Percent Remaining 1,022,501.5025,253.65370,857.00 1,128,357.00 105,855.50Expense Total:9.38 % -563,331.08153,042.18382,545.00 -395,660.00 -167,671.08Fund: 500 - Equipment Rental and Revolving Surplus (Deficit):-42.38 % Report Surplus (Deficit):705,208.00 8,050,426.721,895,706.00 -2,426,809.00 10,477,235.72 431.73 % Page 8 of 10 Budget Report City of Port Orchard Group Summary For Fiscal: 2020 Period Ending: 11/30/2020 Fiscal AcƟvity Variance Favorable (Unfavorable) Period AcƟvityAccount Type Current Total Budget Original Total Budget Percent Remaining Fund: 302 - Capital Construction Revenue 16,074.1528.940.00 127,263.00 -111,188.85 87.37 % Expense 100,761.500.00318,000.00 436,215.00 335,453.50 76.90 % -84,687.3528.94-318,000.00 -308,952.00 224,264.65Fund: 302 - Capital Construction Surplus (Deficit):72.59 % Fund: 304 - Street Capital Projects Revenue 469,227.721,960.88150,000.00 1,832,813.00 -1,363,585.28 74.40 % Expense 1,323,065.90898,182.10592,594.00 4,224,245.00 2,901,179.10 68.68 % -853,838.18-896,221.22-442,594.00 -2,391,432.00 1,537,593.82Fund: 304 - Street Capital Projects Surplus (Deficit):64.30 % Fund: 413 - Water Capital Revenue 2,337,384.2739,966.522,562,500.00 3,512,500.00 -1,175,115.73 33.46 % Expense 2,973,113.10976,789.584,480,500.00 4,495,444.00 1,522,330.90 33.86 % -635,728.83-936,823.06-1,918,000.00 -982,944.00 347,215.17Fund: 413 - Water Capital Surplus (Deficit):35.32 % Fund: 423 - Storm Drainage Capital Facil Revenue 3,115.5454.100.00 1,348.00 1,767.54 131.12 % Expense 527,297.38527,297.38501,640.00 623,874.00 96,576.62 15.48 % -524,181.84-527,243.28-501,640.00 -622,526.00 98,344.16Fund: 423 - Storm Drainage Capital Facil Surplus (Deficit):15.80 % Fund: 433 - Sewer Capital Revenue 1,392,811.6483,894.082,155,000.00 3,406,654.00 -2,013,842.36 59.11 % Expense 3,050,945.55221,825.123,772,400.00 4,973,883.00 1,922,937.45 38.66 % -1,658,133.91-137,931.04-1,617,400.00 -1,567,229.00 -90,904.91Fund: 433 - Sewer Capital Surplus (Deficit):-5.80 % Report Surplus (Deficit):-2,498,189.66 -3,756,570.11-4,797,634.00 -5,873,083.00 2,116,512.89 36.04 % _______________________________________________________________________________________________________________________________________________Capital Projects Page 9 of 10 Date Range: 11/01/2020 - 11/30/2020 12/11/2020 3:05:19 PM Fund Summary Ending BalanceBeginning BalanceFund Total Activity 001 - Current Expense 7,927,512.39 6,942,188.37-985,324.02 002 - City Street Fund 1,215,352.67 1,672,436.70457,084.03 003 - Stabilization Fund 1,366,364.50 2,133,402.92767,038.42 103 - Criminal Justice 509,108.40 364,578.66-144,529.74 104 - Special Investigative Unit 96,338.72 96,510.92172.20 107 - Community Events 217,958.92 223,930.275,971.35 108 - Paths & Trails 10,883.43 10,985.02101.59 109 - Real Estate Excise Tax 3,079,359.19 3,165,538.4386,179.24 111 - Impact Mitigation Fee 2,558,296.12 2,588,234.2229,938.10 206 - Bond Redemption Fund 0.00 0.000.00 302 - Capital Construction 216,374.94 216,403.8828.94 304 - Street Capital Projects 2,510,329.36 1,614,108.14-896,221.22 401 - Water-Sewer Utilities 0.00 0.000.00 403 - Water-Sewer Cumulative Reserve 0.00 0.000.00 411 - Water Operating 3,221,498.34 3,090,777.08-130,721.26 412 - Water Stabilization 101,894.06 391,908.86290,014.80 413 - Water Capital 2,665,665.77 1,728,842.71-936,823.06 414 - Water Debt Service 0.00 0.000.00 421 - Storm Drainage Utility 2,004,789.88 2,084,134.5979,344.71 422 - Storm Drainage Stabilization 168,834.41 179,056.8510,222.44 423 - Storm Drainage Capital Facil 626,775.05 99,531.77-527,243.28 424 - Storm Drainage Debt Service 0.00 0.000.00 431 - Sewer Operating 4,309,737.40 4,230,876.35-78,861.05 432 - Sewer Stabilization 446,974.37 612,509.38165,535.01 433 - Sewer Capital 1,491,975.61 1,354,044.57-137,931.04 434 - Sewer Debt Service 0.00 0.000.00 500 - Equipment Rental and Revolving 3,133,937.61 3,286,979.79153,042.18 631 - Trust and Agency 9,587.98 10,618.171,030.19 632 - Wastewater Treatment Facil Fee 2,806,073.79 2,831,930.2725,856.48 Grand Total:40,695,622.91 38,929,527.92-1,766,094.99 _________________________________________________________________________________________________________________________________________________________________________Cash & Investments Page 10 of 10