Anexo

EXHIBIT #1 Regular Council Meeting of 10/01/2007 Revenue Projection & Tracking System Dover City Council Presentation October 1, 2007 EXHIBIT #1 Jim Butkiewicz Regular Council Meeting of 10/01/2007 University of Delaware

I. OVERVIEW A. Economic Forecasting B. Input into budget process II. REVENUE FORECASTS Excel demonstration III. REVENUE TRACKING Excel demonstration

Important Variables Fiscal Year: 2007 Year to Use Kent County Population (2 Yrs ago): 143,968 2005 Kent County Population (Last Year): 147,675 2006 Kent County Population (This Year): 150,606 2007 US Housing Starts: 1,581 2007 US GDP (Billions of Dollars): 13,948.70 2007 Kent County Civilian Labor Force: 75,809.00 2007 US Unemployment Rate: 4.6 2007 Previous Year's Construction Values: 91,769,464 2006 Trend for Trash Fee Rebate: 6 All Other Trends: 10 Dover Construction Values: 64,919,822 2007 Change in Kent Population: 2,931 2007 Change in Kent Pop Last Year: 3,707 2006 Delaware Personal Income: 139,180 2007 Dover Employment: 17,618 2007 Dover Unemployment: 500 2007 Equations Used: PINC_DE = 9.977983469*USGDP EMPDOVER = 0.2427109343*CLFKENT - 169.9573527*USUNEMPRATE UNEMPDOVER = -0.004577414177*PINC_DE + 103.4566404*USUNEMPRATE + 0.008719727908*CLFKENT CONSTRUC_VALUES = 32333.28525*USHOUSING_STARTS + 4708.596909*D(KENT_POP) - 20761436.33*D_UNDER_05 + 45516044.16*D01

Business Licenses Forecast: $ 67,906 Variables Needed: Previous Year's Business Licenses: Other Variables Used: Construction Values: 64,919,821.52 Equation Used: BUS_LICENSES = 0.9663858704*BUS_LICENSES(-1) + 0.001046244651*CONSTRUC_VALUES + 0.0007918606757*D_UNDER_05*CONSTRUC_VALUES

Property Taxes Revised 1st Qtr Forecast Amount: 9,453,511.00 9,560,000 Actual Amount Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 9,477,359.35 33,287.90 Cumulative Amount Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 9,477,359.35 9,510,647.25 Cumulative Percent of Forecast Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 100.25% 100.60% Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Historic High % of Total: 100.21% 100.04% 99.89% 100.06% 100.06% 100.06% 100.59% 100.58% 100.58% 100.64% 100.64% 100.00% Cumulative Percent of Forecast Collected: 100.25% 100.60% Historic Low % of Total: 98.42% 98.38% 98.38% 98.93% 98.93% 98.93% 99.21% 99.53% 99.53% 99.55% 99.55% 100.00% Historic Average % of Total: 99.21% 99.10% 99.20% 99.50% 99.48% 99.59% 99.86% 99.87% 99.88% 99.99% 100.00% 100.00% Historic Median % of Total: 99.10% 99.10% 99.32% 99.57% 99.52% 99.62% 99.88% 99.88% 99.88% 100.00% 100.00% 100.00%

Realty Transfer Taxes Revised 1st Qtr Forecast Amount: 2,650,222.00 Actual Amount Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 243,227.18 327,026.83 Cumulative Amount Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 243,227.18 570,254.01 Cumulative Percent of Forecast Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 9.18% 21.52% Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Historic High % of Total: 33.80% 38.97% 50.19% 56.05% 63.16% 69.69% 73.31% 78.25% 83.74% 88.36% 94.63% 100.00% Cumulative Percent of Forecast Collected: 9.18% 21.52% Historic Low % of Total: 4.07% 6.70% 13.39% 18.91% 22.28% 25.12% 27.70% 55.10% 59.77% 64.74% 84.04% 100.00% Historic Average % of Total: 10.54% 18.23% 28.33% 37.72% 44.56% 53.78% 59.48% 68.46% 76.07% 82.20% 90.77% 100.00% Historic Median % of Total: 8.88% 16.91% 25.94% 37.93% 47.46% 55.32% 62.36% 70.33% 77.31% 83.20% 91.04% 100.00%

Business Licenses Revised 1st Qtr Forecast Amount: 1,320,000.00 1,350,000 Actual Amount Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 1,202,985.20 99,009.61 Cumulative Amount Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 1,202,985.20 1,301,994.81 Cumulative Percent of Forecast Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 91.14% 98.64% Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Historic High % of Total: 84.77% 93.58% 95.69% 96.95% 97.52% 97.91% 98.50% 98.75% 99.43% 99.76% 100.02% 100.00% Cumulative Percent of Forecast Collected: 91.14% 98.64% Historic Low % of Total: 13.17% 14.20% 14.23% 83.02% 85.20% 87.61% 87.93% 88.13% 88.54% 88.71% 89.37% 100.00% Historic Average % of Total: 59.99% 80.88% 84.70% 92.98% 94.02% 95.09% 96.55% 97.17% 97.68% 98.29% 98.70% 100.00% Historic Median % of Total: 71.16% 88.06% 91.37% 94.10% 95.13% 95.83% 97.78% 98.11% 98.67% 99.13% 99.64% 100.00% Revenue revised already over budget amount.

Building Permits Revised 1st Qtr Forecast Amount: 600,000.00 Actual Amount Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 75,772.50 77,374.00 Cumulative Amount Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 75,772.50 153,146.50 Cumulative Percent of Forecast Collected: Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 12.63% 25.52% Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Historic High % of Total: 20.60% 29.94% 37.41% 41.53% 64.37% 73.67% 77.25% 79.40% 82.67% 89.73% 96.88% 100.00% Cumulative Percent of Forecast Collected: 12.63% 25.52% Historic Low % of Total: 3.30% 5.19% 8.30% 19.32% 20.42% 27.92% 33.59% 48.90% 56.50% 59.26% 68.94% 100.00% Historic Average % of Total: 9.61% 17.15% 22.82% 32.36% 41.99% 53.69% 60.87% 67.40% 72.48% 78.97% 88.10% 100.00% Historic Median % of Total: 5.10% 17.35% 23.69% 35.77% 43.96% 49.83% 61.96% 70.25% 73.32% 82.34% 92.05% 100.00%

EXHIBIT #2 Regular Council Meeting of 10/01/2007 Forecasting Annual Revenue Regression Forecasts Regression equations have been estimated using available data, in most cases for ten years. The number of years is less where data are not available. The regression forecasting equations are based on historical relationships. A change in the relationship will affect the accuracy of the estimating equation. Tax revenues are the product of a tax rate(s) and tax base. A change in the rate or base will change the relationship. Thus, annexation of new land, a change in the method of assessment, or a rate change will change property tax revenue. This will affect the usefulness of the forecasting model. Forecasts should be used in conjunction with expert opinion when developing planned budgets. The forecasting model uses forecasts of several variables, including construction in Dover. Given Dover’s relatively small size, a significant project, such as construction of a large commercial or industrial property, will affect annual construction but will not be captured by the forecasting model, since these singular events average out over time. For example, if the construction forecasting equation predicts construction of $100 million, but actual construction is expected to be $130 million due to a large project, override the model estimate and use $130. An alternative, since the forecasting spreadsheet can be used repeatedly, is to estimate revenues using both $100 million and $130 million of construction, to establish a range of likely revenue. Using the Forecasting Spreadsheets The forecasting file consists of twenty-five spreadsheets. The first computes forecasts of key variables used to forecast revenues. The second computes the forecasts for construction values from three different equations and requires a manual entry to be entered for the actual prediction. The next twenty-two sheets compute forecast values for twenty-two revenue items. The last sheet forecasts general revenue. (The general revenue forecast is a separate forecast, not the sum of the twenty other forecasts. Thus, the general revenue forecast may different from the forecast obtained by adding the forecasts of the component revenue sources.) Variables used for forecasts The first sheet computes the variables used for the forecasts. Ten items must be entered in the red cells on this sheet. The first is the fiscal year which is being forecast (line 3). This is important because several forecasts include time trends. Trends are the number of years beginning with the first year in the data set. The forecasting sheets automatically compute this count by subtracting the beginning year from the fiscal year. (All trends begin in 1997 except the trash fee rebate which begins in 2001.) The next data to enter are Kent County population and labor force data. These are obtained from the Delaware Population Consortium. Their web site is: http://stateplanning.delaware.gov/information/dpc_projections.shtml

On this site, go to Single year projection, 2000-2030 at: http://stateplanning.delaware.gov/information/dpc/dpc_2006v0_single_year.xls There is a Kent County tab which has data for population and civilian labor force. Once you enter the fiscal year in the forecasting spreadsheet, the calendar year which must be entered in each cell appears to the right of the cell. In the Kent County spreadsheet, population data for each year is on line 5. The civilian labor force data is on line 17. Enter the data for the appropriate year. Enter the population values for the current and two previous fiscal years (lines 5 – 7). Enter the civilian labor force (line 13) values. Next you need to enter forecasts for three national variables, GDP (line11), housing starts (line 9) and the unemployment rate (line 15). These can be obtained from the web site of the Federal Reserve Bank of Philadelphia, which publishes two forecasts: the Survey of Professional Forecasters and the Livingston Survey. The forecasts links can be found at: http://www.philadelphiafed.org/econ/forecast/index.html For the Livingston Survey, click on the most recent date in the column on the right (currently June 2007). This will connect you to the latest survey release. You need the data for 2008. Scroll down to Table 1. The GDP data are in line 2, the housing starts in line 6 and unemployment in line 9. Note: Both surveys list housing starts in millions of units. Convert this to thousands by moving the decimal point three spaces to the right. If the last space is blank, just make it a zero. Thus 1.531 should be entered as 1531. Click on the most recent link for the Survey of Professional Forecasters. Scroll down to Table 1. Here the GNP data are in line 1, the housing data in line 7, and the unemployment data in line 4. As noted above, move the decimal three spaces to the right for the housing number. Which forecast is better? The answer is neither. They tend to be very similar. You can try both sets of numbers or average the two. Here are the data for the most recent 2008 forecasts: Survey of Professional Forecasters Livingston Survey GDP $14617.2 $14611.2 Housing 1.55 (Enter 1550) 1.531 (Enter 1531) Unemployment Rate 4.8 4.8 Finally, enter the dollar value of construction in Dover for the previous fiscal year (line 17). Construction is the key! Once these values are entered , three estimates of Dover construction for the current fiscal year appear on lines 4-6 of the next sheet. An average of the three estimates is also given on the same sheet. Then, you can enter the construction value you think is appropriate in the red box on line 11 and review the various revenue categories that are affected by construction. You can use any of the estimates on this sheet, the average estimate, or any other value that you feel is an appropriate estimate for the current fiscal year’s construction. You can change this value as often as you choose.

Completing the Forecast For eight revenue categories, you need to enter the previous fiscal year revenue in the appropriate red box on the sheet for each revenue item. These revenue categories are: Business Licenses Rental Dwelling Permits Trash Revenue Property Taxes Water Fees Sewer Fees Fuel/Waste-Water Adjust General Fund Total Revenue Choosing among alternatives For several revenue categories, there was no statistical basis to choose among two or more estimating equations. In these cases two or more estimates appear on the respective forecast sheet. Over time one estimate may prove to be superior to the other(s). The items with two or more forecasts are: Recreation Revenue Rental Dwelling Permits Trash Revenue Trash Fee Rebate Property Taxes Penalties – Taxes Chancery Court Fees Water Fees Sewer Fees Fuel/Waste-Water Adjust

EXHIBIT #3 Regular Council Meeting of 10/01/2007 Important Variables: Fiscal Year: 2007 Year to Use Kent County Population (2 Yrs ago): 143,968 2005 Kent County Population (Last Year): 147,675 2006 Kent County Population (This Year): 150,606 2007 US Housing Starts: 1,581 2007 US GDP (Billions of Dollars): 13,948.70 2007 Kent County Civilian Labor Force: 75,809.00 2007 US Unemployment Rate: 4.6 2007 Previous Year's Construction Values: 91,769,464 2006 Trend for Trash Fee Rebate: 6 All Other Trends: 10 Dover Construction Values: 64,919,822 2007 Change in Kent Population: 2,931 2007 Change in Kent Pop Last Year: 3,707 2006 Delaware Personal Income: 139,180 2007 Dover Employment: 17,618 2007 Dover Unemployment: 500 2007 Equations Used: PINC_DE = 9.977983469*USGDP EMPDOVER = 0.2427109343*CLFKENT - 169.9573527*USUNEMPRATE UNEMPDOVER = -0.004577414177*PINC_DE + 103.4566404*USUNEMPRATE + 0.008719727908*CLFKENT CONSTRUC_VALUES = 32333.28525*USHOUSING_STARTS + 4708.596909*D(KENT_POP) - 20761436.33*D_UNDER_05 + 45516044.16*D01

Building Permits: Forecast: $ 457,815 Variables Used: Construction Values: 64,919,821.52 Equation Used: BUILD_PERMITS = 0.006040382563*CONSTRUC_VALUES + 0.0004051900263*CONSTRUC_VALUES*D_UNDER_05 + 0.001011669087*CONSTRUC_VALUES*DUMMY_05

Business Licenses: Forecast: $ 67,906 Variables Needed: Previous Year's Business Licenses: Other Variables Used: Construction Values: 64,919,821.52 Equation Used: BUS_LICENSES = 0.9663858704*BUS_LICENSES(-1) + 0.001046244651*CONSTRUC_VALUES + 0.0007918606757*D_UNDER_05*CONSTRUC_VALUES

Franchise Fees: Forecast: $ 287,205 Variables Used: Construction Values: 64,919,821.52 Equation Used: FRANCHISE_FEES = 0.004423606806*CONSTRUC_VALUES

Impact Fee: Forecast: $ 917,419 Variables Used: Construction Values- Previous Fiscal Year: 91,769,464 Equation Used: IMPACT_FEE = 0.009996850321*CONSTRUC_VALUES(-1) + 0.005293997312*D_UNDER_05*CONSTRUC_VALUES(-1)

Library Fines: Forecast: $ 35,587 Variables Used: Kent Population: 150,606.00 Equation Used: FINES_REC = 0.2362922634*KENT_POP - 26424.1675*D99

Plumbing and HVAC Forecast: $ 59,791 Variables Used: Construction Values: 64,919,821.52 Equation Used: PLUMB_HVAC = 0.000921251994*CONSTRUC_VALUES + 0.0006137289897*CONSTRUC_VALUES*D_UNDER_05

Recreation Revenue: Forecast: a. $ 112,305 b. $ 103,348 Variables Used: Delaware Personal Income: 139,180 Dover Employment: 17,618 Kent Population: 150,606 Equations Used: a. REC_REVENUE = 0.5116696698*PINC_DE + 2.332326054*EMPDOVER b. REC_REVENUE = 0.6862164381*KENT_POP

Rental Dwelling Permits (Inspection Fee): Forecast: a. $ 214,006 b. $ 288,919 Variables Needed: Previous Year's Inspection Fee: Other Variables Used: Previous Year's Construction Values: 91,769,464 Trend: 10 Equations Used: a. RENT_INSP_FEE = 0.3252664469*RENT_INSP_FEE(-1) + 0.002331614878*CONSTRUC_VALUES(- 1) + 0.0002365761847*CONSTRUC_VALUES(-1)*D_UNDER_05 b. RENT_INSP_FEE = 170198.4884 + 11872.00743*@TREND

Trash Revenue: Forecast: a. $ 53,970 b. 1075199.747 Variables Needed: Previous Year's Trash Revenue: Variables Used: Construction Values: 64,919,822 Trend 10 Change in Trash Revenue: 53,970 Equation Used: (Change in Revenue) a. D(TRASH_REVENUE) = 0.000831336216*CONSTRUC_VALUES + 2.452125123*D_2001_INC*TRASH_REVENUE(-1) b. TRASH_REVENUE = 41405.31083 + 46425.97111*@TREND + 569534.7253*D2001ANDAFTER

Trash Fee Rebate: Forecast: a. $ 103,173 b. $ 155,467 Variables Used: Previous Year Construction Values: 91,769,464 Forecast for Trash Rev This Year: 53,970.20 Equations Used: a. TRASH_FEE_REBATE = 0.001065016912*CONSTRUC_VALUES(-1) + 0.1007641549*TRASH_RE b. TRASH_FEE_REBATE = 195090.339 - 6603.916286*TREND

EVENUE

Book Reimbursement: Forecast: $ 324,635 Variables Used: Kent Population: 150,606 Equation Used: BOOK_REIMB = 1.393779152*KENT_POP + 0.7617456638*KENT_POP*D1998 + 0.504370224*KENT_POP*D1998*D2006

Realty Transfer Taxes: Forecast: $ 2,272,837 Variables Used: Construction Values: 64,919,822 Previous Year's Change in Kent Population: 3,707 Equation Used: REALTY_TRANS = 0.003887182251*CONSTRUC_VALUES + 545.048135*D(KENT_POP(-1))

Property Taxes: Forecast: a. $ 188,073 b. $ 111,597 c. $ 161,147 Variables Needed: Previous Year's Property Tax: Variables Used: Construction Values: 64,919,822 Previous Year's Construction Values: 91,769,464 Change in Property Tax: a. 188,073 b. 111,597 c. 161,147 Equations Used: (Change in Prop Tax) a. D(PROP_TAX) = 0.002896700912*CONSTRUC_VALUES + 0.1290702924*DUMMY_06*PROP_TAX(-1) b. D(PROP_TAX) = 0.001719049003*CONSTRUC_VALUES + 0.1240535116*D03*PROP_TAX(-1) + 0.1442851078*D06*PROP_TAX(-1) c. D(PROP_TAX) = 0.00175637625*CONSTRUC_VALUES(-1) + 0.1266037121*D03*PROP_TAX(-1) + 0.1494077685*D06*PROP_TAX(-1)

PD Fines: Forecast: $ 286,399 Variables Used: Kent Population: 150,606 Dover Unemployment: 500 Equation Used: PD_FINES = 3.186059305*KENT_POP - 386.9978006*UNEMPDOVER

JP Court Fines: Forecast: $ 241,642 Variables Used: Kent Population: 150,606 Dover Unemployment: 500 Equation Used: JP_COURT_FINES = 1.167047822*KENT_POP + 131.7952004*UNEMPDOVER

Common Pleas Fines: Forecast: $ 146,415 Variables Used: Kent Population: 150,606 Dover Unemployment: 500 Equation Used: COMM_PLEAS_FINES = 1.458801402*KENT_POP - 146.6219625*UNEMPDOVER

Penalties- Taxes: Forecast: a. $ 64,772 b. $ 66,851 Variables Used: Delaware Personal Income: 139,180 Dover Unemployment: 500 Dover Construction Values: 64,919,822 Equations Used: a. PENALTIES_TAX = 0.3585283544*PINC_DE + 5.335351309*UNEMPDOVER + 0.0001877571097*CONSTRUC_VALUES - 0.0002845106049*D_UNDER_05*CONSTRUC_VALUES b. PENALTIES_TAX = 0.3963606068*PINC_DE + 0.0001799863119*CONSTRUC_VALUES - 0.0003034732051*D_UNDER_05*CONSTRUC_VALUES

Police Extra Duty: Forecast: $ 288,033 Variables Used: Dover Unemployment: 500 Kent Population: 150,606 Delaware Personal Income: 139,180 Trend: 10 Equations Used: POLICE_EXTRA_DUTY = -119.7434178*UNEMPDOVER + 0.104654286*KENT_POP + 2.386301185*PINC_DE + 170927.2146*D01TO03

Chancery Court Fees: Forecast: a. $ 690,880 b. $ 822,579 c. $ 696,130 d. $ 841,680 Variables Used: Delaware Personal Income: 139,180 Kent Population: 150,606 US GDP: 13,949 Trend: 10 Equations Used: a. CHANCERY_FEES = 4.963935407*PINC_DE b. CHANCERY_FEES = 22.53647125*PINC_DE - 15.3648858*KENT_POP c. CHANCERY_FEES = 49.90643494*USGDP d. CHANCERY_FEES = -269520 + 111120*@TREND

Water Fees Forecast: a. $ 4,329,803 b. $ 4,319,628 Variables Needed: Previous Year's Water Fees: 4,289,413.00 Variables Used: Construction 64,919,821.52 Trend 10 Change in Water Fees: 30,215 Equations Used: a. WATER_FEES = 2931166.157 + 40389.16*@TREND + 574394.9267*D03 + 420349.8967*D06 b. D(WATER_FEES) = 0.0004654267092*CONSTRUC_VALUES + 0.1996901485*D2003*WATER_FEES(- 1) + 0.1201311865*D06*WATER_FEES(-1)

Sewer Fees Forecast: a. $ 2,805,420 b. $ 2,669,162 Variables Used: Dover Construction Values: 64,919,821.52 Trend 10 Variables Needed: Previous Year's Sewer Fees: 2,605,428.00 Equations Used: a. SEWER_FEES = 1884275.998 + 92114.3983*@TREND b. SEWER_FEES = 1.009706875*SEWER_FEES(-1) + 0.0005921652268*CONSTRUC_VALUES

Fuel Waste-Water Adjust Forecast: a. $ 3,911,045 b. $ 3,805,363 Variables Needed: Previous Year's Fuel Wwater Adjust: 3,865,683.00 Variables Used: Dover Construction Values: 64,919,821.52 Trend 10 Equations Used: a. FUEL_WWATER = 2422482.549 + 45361.41617*@TREND + 1034948.116*D06 b. FUEL_WWATER = 0.9439119195*FUEL_WWATER(-1) + 0.002410645569*CONSTRUC_VALUES + 1179631.69*D06

Total General Fund Revenue: Forecast: $ 7,658,935 Variables Needed: Previous Year's General Fund Revenue: Other Variables Used: Dover Construction Values: 64,919,822 Change in Kent Population: 2,931 Equation Used: GENFUNDREV = 0.7019866957*GENFUNDREV(-1) + 0.04768681952*CONSTRUC_VALUES + 1556.845898*D(KENT_POP)

EXHIBIT #4 Regular Council Meeting of 10/01/2007 The Revenue Tracking System The tracking system consists of two files, a master spreadsheet with twenty-three separate sheets and a work sheet that updates the limits (percentages of revenue collected) each year as new data become available. These two files should be kept in the same folder, as they are connected. The Tracking System – Master file consists of twenty-three spreadsheets; the twenty-two revenue categories forecast and a sheet for total general revenue. There is a red box in cell B3 in each spreadsheet. Enter the projected or budgeted revenue for the current fiscal year for each revenue item in this box. I recommend tracking the “budgeted” amount if the “budgeted” revenue differs from the estimate of the “forecast” amount. Since spending will be linked to the “budgeted” revenue, you will want to determine if revenue collections are on track with projected spending. For each month of the fiscal year, enter on line 8 of each sheet the amount collected for each revenue item. The sheet automatically computes a cumulative total and cumulative percentage of projected revenue collected. On line 21 of each sheet, the cumulative percentage of revenue collected can be compared to the historic highs and lows on lines 20 and 22, respectively. If the percentage collected exceeds the historic highs for several months, review the underlying conditions to determine whether expected revenue should be increased. If the percent collected is below the historic minimum for several months, it would be advisable to review the conditions to determine whether projected revenue should be reduced. Extraordinary revenues Extraordinary revenues should be treated according to your budgetary guidelines. That is, if an item should be treated as reserve funds (a large one-time property transfer) do not include it in the tracking data. If the extraordinary item increases the spendable revenue base (annexation of land/properties increasing property taxes) include it in the revenue tracking data. In this latter case, the revenue will continue in ensuing years and should result in an increase in projected spendable income. Updating historic bounds (highs and lows) The file Tracking System Work computes the cumulative highs and lows each year and updates the historic highs and lows. This file consists of twenty-three spreadsheets for the twenty- two revenue categories and the general fund. In each sheet enter the monthly amount collected in the appropriate red box. (We do not have complete fiscal 2007 data, so you might want to update this file as soon as fiscal 2007 data are finalized.) The cumulative total on lines 80 – 85 are automatically updated. This file is connected to the Tracking System – Master file. If the historic highs and lows change, the change is made automatically in the Tracking System – Master file. The updating of the highs and lows in the Tracking System – Master file occurs only when June data are entered for each fiscal year in the Tracking System Work file. It is impossible to determine whether monthly bounds are exceeded until total revenue is known.

EXHIBIT #5 Regular Council Meeting of 10/01/2007 Property Taxes: Revised 1st Qtr Forecast Amount: 9,453,511.00 9,560,000 Actual Amount Collected: July August September October November December January February March April May June 9,477,359.35 33,287.90 Cumulative Amount Collected: July August September October November December January February March April May June 9,477,359.35 9,510,647.25 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 100.25% 100.60% July August September October November December January February March April May June Historic High % of Total: 100.21% 100.04% 99.89% 100.06% 100.06% 100.06% 100.59% 100.58% 100.58% 100.64% 100.64% 100.00% Cumulative Percent of Forecast Collected: 100.25% 100.60% Historic Low % of Total: 98.42% 98.38% 98.38% 98.93% 98.93% 98.93% 99.21% 99.53% 99.53% 99.55% 99.55% 100.00% Historic Average % of Total: 99.21% 99.10% 99.20% 99.50% 99.48% 99.59% 99.86% 99.87% 99.88% 99.99% 100.00% 100.00% Historic Median % of Total: 99.10% 99.10% 99.32% 99.57% 99.52% 99.62% 99.88% 99.88% 99.88% 100.00% 100.00% 100.00% EXHIBIT #5 Regular Council Meeting of 10/01/2007

Penalties- Taxes Revised 1st Qtr Forecast Amount: 67,800.00 Actual Amount Collected: July August September October November December January February March April May June 4,761.40 9,000.19 Cumulative Amount Collected: July August September October November December January February March April May June 4,761.40 13,761.59 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 7.02% 20.30% July August September October November December January February March April May June Historic High % of Total: 14.55% 27.78% 41.59% 52.66% 65.22% 72.39% 79.68% 85.45% 91.01% 95.98% 98.98% 100.00% Cumulative Percent of Forecast Collected: 7.02% 20.30% Historic Low % of Total: -0.30% 11.07% 20.77% 26.01% 31.98% 46.39% 57.28% 72.64% 80.17% 86.81% 95.36% 100.00% Historic Average % of Total: 7.24% 21.33% 34.01% 44.91% 55.58% 65.06% 72.32% 80.49% 86.64% 91.95% 97.39% 100.00% Historic Median % of Total: 7.81% 22.42% 34.83% 46.84% 57.66% 67.60% 74.54% 80.80% 87.30% 91.40% 97.60% 100.00%

Realty Transfer Taxes Revised 1st Qtr Forecast Amount: 2,650,222.00 Actual Amount Collected: July August September October November December January February March April May June 243,227.18 327,026.83 Cumulative Amount Collected: July August September October November December January February March April May June 243,227.18 570,254.01 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 9.18% 21.52% July August September October November December January February March April May June Historic High % of Total: 33.80% 38.97% 50.19% 56.05% 63.16% 69.69% 73.31% 78.25% 83.74% 88.36% 94.63% 100.00% Cumulative Percent of Forecast Collected: 9.18% 21.52% Historic Low % of Total: 4.07% 6.70% 13.39% 18.91% 22.28% 25.12% 27.70% 55.10% 59.77% 64.74% 84.04% 100.00% Historic Average % of Total: 10.54% 18.23% 28.33% 37.72% 44.56% 53.78% 59.48% 68.46% 76.07% 82.20% 90.77% 100.00% Historic Median % of Total: 8.88% 16.91% 25.94% 37.93% 47.46% 55.32% 62.36% 70.33% 77.31% 83.20% 91.04% 100.00%

Business Licenses Revised 1st Qtr Forecast Amount: 1,320,000.00 1,350,000 Actual Amount Collected: July August September October November December January February March April May June 1,202,985.20 99,009.61 Cumulative Amount Collected: July August September October November December January February March April May June 1,202,985.20 1,301,994.81 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 91.14% 98.64% July August September October November December January February March April May June Historic High % of Total: 84.77% 93.58% 95.69% 96.95% 97.52% 97.91% 98.50% 98.75% 99.43% 99.76% 100.02% 100.00% Cumulative Percent of Forecast Collected: 91.14% 98.64% Historic Low % of Total: 13.17% 14.20% 14.23% 83.02% 85.20% 87.61% 87.93% 88.13% 88.54% 88.71% 89.37% 100.00% Historic Average % of Total: 59.99% 80.88% 84.70% 92.98% 94.02% 95.09% 96.55% 97.17% 97.68% 98.29% 98.70% 100.00% Historic Median % of Total: 71.16% 88.06% 91.37% 94.10% 95.13% 95.83% 97.78% 98.11% 98.67% 99.13% 99.64% 100.00% Revenue revised already over budget amount.

Building Permits Revised 1st Qtr Forecast Amount: 600,000.00 Actual Amount Collected: July August September October November December January February March April May June 75,772.50 77,374.00 Cumulative Amount Collected: July August September October November December January February March April May June 75,772.50 153,146.50 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 12.63% 25.52% July August September October November December January February March April May June Historic High % of Total: 20.60% 29.94% 37.41% 41.53% 64.37% 73.67% 77.25% 79.40% 82.67% 89.73% 96.88% 100.00% Cumulative Percent of Forecast Collected: 12.63% 25.52% Historic Low % of Total: 3.30% 5.19% 8.30% 19.32% 20.42% 27.92% 33.59% 48.90% 56.50% 59.26% 68.94% 100.00% Historic Average % of Total: 9.61% 17.15% 22.82% 32.36% 41.99% 53.69% 60.87% 67.40% 72.48% 78.97% 88.10% 100.00% Historic Median % of Total: 5.10% 17.35% 23.69% 35.77% 43.96% 49.83% 61.96% 70.25% 73.32% 82.34% 92.05% 100.00%

HVAC Revised 1st Qtr Forecast Amount: 100,000.00 Actual Amount Collected: July August September October November December January February March April May June 11,239.00 16,994.00 Cumulative Amount Collected: July August September October November December January February March April May June 11,239.00 28,233.00 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 11.24% 28.23% July August September October November December January February March April May June Historic High % of Total: 14.17% 26.30% 37.75% 45.36% 53.51% 65.58% 73.51% 79.65% 85.15% 96.13% 100.26% 100.00% Cumulative Percent of Forecast Collected: 11.24% 28.23% Historic Low % of Total: 3.31% 8.85% 16.74% 26.02% 31.37% 37.65% 46.93% 51.19% 62.69% 78.51% 83.23% 100.00% Historic Average % of Total: 7.21% 16.64% 26.67% 35.81% 43.27% 52.16% 60.64% 68.08% 77.35% 86.26% 92.80% 100.00% Historic Median % of Total: 6.62% 16.12% 27.83% 34.53% 42.52% 54.49% 59.34% 69.49% 78.10% 87.56% 93.33% 100.00%

Rental Dwelling Permits (Inspection Fee) Revised 1st Qtr Forecast Amount: 391,343.00 Actual Amount Collected: July August September October November December January February March April May June 2,256.00 1,998.00 Cumulative Amount Collected: July August September October November December January February March April May June 2,256.00 4,254.00 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 0.58% 1.09% July August September October November December January February March April May June Historic High % of Total: 4.71% 11.09% 11.48% 11.69% 11.77% 34.30% 76.95% 91.85% 96.70% 98.13% 99.32% 100.00% Cumulative Percent of Forecast Collected: 0.58% 1.09% Historic Low % of Total: 0.00% 0.00% 0.00% 0.13% 0.13% 5.82% 59.61% 79.92% 82.04% 85.89% 97.12% 100.00% Historic Average % of Total: 1.30% 3.74% 4.05% 4.33% 4.55% 25.38% 69.57% 85.83% 90.95% 94.90% 98.50% 100.00% Historic Median % of Total: 0.72% 2.05% 2.26% 2.56% 2.79% 27.09% 71.78% 86.07% 91.97% 96.23% 98.79% 100.00% Scott states that in past years rental fees were not collected in a timely manner. Therefore, collections took place in July and August. Most collection shoulc take place in January/February which is what happened this past year. No change is recommended at this time.

Chancery Court Fees Revised 1st Qtr Forecast Amount: 761,000.00 Actual Amount Collected: July August September October November December January February March April May June - 77,680.00 Cumulative Amount Collected: July August September October November December January February March April May June - 77,680.00 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 0.00% 10.21% July August September October November December January February March April May June Historic High % of Total: 0.00% 17.49% 8.11% 18.36% 35.13% 39.85% 53.80% 63.44% 71.46% 81.30% 89.84% 100.00% Cumulative Percent of Forecast Collected: 0.00% 10.21% Historic Low % of Total: 0.00% 0.00% 0.00% 15.69% 26.99% 34.42% 39.85% 57.26% 60.96% 78.58% 81.30% 100.00% Historic Average % of Total: 0.00% 8.53% 5.40% 17.01% 31.07% 36.47% 46.46% 60.55% 66.57% 80.10% 86.97% 100.00% Historic Median % of Total: 0.00% 8.11% 8.10% 16.98% 31.07% 35.13% 45.73% 60.96% 67.29% 80.41% 89.75% 100.00%

Library Fines Revised 1st Qtr Forecast Amount: 46,350.00 Actual Amount Collected: July August September October November December January February March April May June 4,438.45 5,261.48 Cumulative Amount Collected: July August September October November December January February March April May June 4,438.45 9,699.93 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 9.58% 20.93% July August September October November December January February March April May June Historic High % of Total: 16.16% 18.52% 25.97% 36.92% 44.08% 54.83% 66.17% 77.07% 87.21% 96.82% 100.00% 100.00% Cumulative Percent of Forecast Collected: 9.58% 20.93% Historic Low % of Total: 5.65% 12.51% 16.16% 16.16% 16.16% 16.16% 16.16% 16.16% 16.16% 16.16% 30.54% 100.00% Historic Average % of Total: 7.86% 14.73% 21.12% 28.28% 35.53% 42.93% 51.29% 59.51% 68.83% 76.33% 84.79% 100.00% Historic Median % of Total: 7.11% 14.46% 21.06% 28.07% 36.48% 45.04% 53.84% 63.95% 73.57% 81.87% 90.38% 100.00%

Kent Book Reimbursement Revised 1st Qtr Forecast Amount: 329,600.00 Actual Amount Collected: July August September October November December January February March April May June - - Cumulative Amount Collected: July August September October November December January February March April May June - - Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 0.00% 0.00% July August September October November December January February March April May June Historic High % of Total: 25.04% 25.04% 25.04% 76.77% 67.17% 67.17% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Cumulative Percent of Forecast Collected: 0.00% 0.00% Historic Low % of Total: 0.00% 0.00% 0.00% 50.52% 50.52% 50.52% 50.77% 54.02% 54.02% 54.02% 73.10% 100.00% Historic Average % of Total: 6.82% 11.37% 11.37% 56.53% 54.47% 54.47% 73.46% 78.17% 78.17% 85.00% 97.55% 100.00% Historic Median % of Total: 0.00% 0.00% 0.00% 53.38% 53.38% 53.38% 74.68% 75.43% 75.43% 85.53% 100.00% 100.00%

Common Pleas Fines Revised 1st Qtr Forecast Amount: 154,000.00 Actual Amount Collected: July August September October November December January February March April May June - 175.00 Cumulative Amount Collected: July August September October November December January February March April May June - 175.00 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 0.00% 0.11% July August September October November December January February March April May June Historic High % of Total: 23.00% 37.17% 55.51% 55.75% 55.86% 56.13% 65.14% 67.87% 77.53% 93.61% 100.00% 100.00% Cumulative Percent of Forecast Collected: 0.00% 0.11% Historic Low % of Total: 0.15% 6.41% 12.81% 17.79% 23.05% 35.25% 44.51% 51.19% 55.57% 56.13% 82.52% 100.00% Historic Average % of Total: 8.80% 15.74% 24.76% 30.58% 36.53% 46.65% 54.21% 60.70% 69.43% 78.17% 90.91% 100.00% Historic Median % of Total: 6.30% 14.62% 23.02% 28.03% 34.26% 45.73% 54.16% 61.14% 71.29% 80.48% 91.26% 100.00%

JP Court Fines Revised 1st Qtr Forecast Amount: 250,000.00 Actual Amount Collected: July August September October November December January February March April May June 20,560.60 21,082.67 Cumulative Amount Collected: July August September October November December January February March April May June 20,560.60 41,643.27 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 8.22% 16.66% July August September October November December January February March April May June Historic High % of Total: 16.31% 26.16% 31.76% 42.73% 51.18% 52.79% 61.04% 68.39% 83.26% 91.46% 100.00% 100.00% Cumulative Percent of Forecast Collected: 8.22% 16.66% Historic Low % of Total: 0.00% 7.89% 16.04% 24.00% 30.84% 37.82% 46.62% 53.84% 62.08% 70.53% 82.80% 100.00% Historic Average % of Total: 7.45% 15.62% 24.37% 33.61% 41.49% 47.29% 55.99% 63.58% 74.81% 81.77% 91.43% 100.00% Historic Median % of Total: 8.26% 17.33% 24.88% 32.74% 41.49% 48.52% 58.35% 65.84% 75.17% 83.26% 91.44% 100.00%

PD Fines Revised 1st Qtr Forecast Amount: 230,000.00 Actual Amount Collected: July August September October November December January February March April May June 20,560.60 21,082.67 Cumulative Amount Collected: July August September October November December January February March April May June 20,560.60 41,643.27 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 8.94% 18.11% July August September October November December January February March April May June Historic High % of Total: 13.94% 21.25% 33.02% 40.57% 46.27% 56.70% 63.01% 72.16% 80.64% 86.10% 94.16% 100.00% Cumulative Percent of Forecast Collected: 8.94% 18.11% Historic Low % of Total: 4.20% 5.92% 15.88% 23.41% 31.25% 36.30% 38.23% 43.76% 60.81% 72.74% 87.65% 100.00% Historic Average % of Total: 7.07% 13.70% 24.77% 33.62% 41.22% 49.58% 56.70% 63.55% 73.67% 81.78% 91.42% 100.00% Historic Median % of Total: 6.38% 12.62% 26.50% 34.22% 42.55% 50.99% 58.91% 66.04% 74.59% 83.08% 91.84% 100.00%

Franchise Fees Revised 1st Qtr Forecast Amount: 422,000.00 Actual Amount Collected: July August September October November December January February March April May June - - Cumulative Amount Collected: July August September October November December January February March April May June - - Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 0.00% 0.00% July August September October November December January February March April May June Historic High % of Total: 55.87% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Cumulative Percent of Forecast Collected: 0.00% 0.00% Historic Low % of Total: -25.24% 0.00% 0.00% 0.00% 24.93% 24.93% 49.10% 49.10% 49.10% 74.19% 74.75% 100.00% Historic Average % of Total: 17.61% 35.17% 30.49% 47.91% 53.06% 56.23% 75.29% 75.29% 78.90% 90.72% 96.39% 100.00% Historic Median % of Total: 23.93% 32.78% 23.93% 48.52% 51.28% 51.28% 76.19% 76.19% 76.19% 100.00% 100.00% 100.00%

Police Extra Duty Revised 1st Qtr Forecast Amount: 300,000.00 Actual Amount Collected: July August September October November December January February March April May June 14,452.33 10,723.67 Cumulative Amount Collected: July August September October November December January February March April May June 14,452.33 25,176.00 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 4.82% 8.39% July August September October November December January February March April May June Historic High % of Total: 36.13% 22.75% 42.32% 63.45% 77.16% 80.25% 82.78% 85.14% 88.64% 89.50% 95.40% 100.00% Cumulative Percent of Forecast Collected: 4.82% 8.39% Historic Low % of Total: 0.00% 3.28% 5.21% 30.11% 31.98% 41.31% 44.98% 58.10% 60.82% 60.82% 63.66% 100.00% Historic Average % of Total: 10.23% 12.10% 19.69% 39.37% 47.69% 55.38% 61.60% 67.23% 73.67% 77.96% 83.40% 100.00% Historic Median % of Total: 5.64% 10.81% 17.05% 35.77% 43.07% 53.74% 59.55% 64.70% 70.32% 78.44% 83.02% 100.00%

Recreation Revenue Revised 1st Qtr Forecast Amount: 140,000.00 Actual Amount Collected: July August September October November December January February March April May June 14,826.36 18,918.00 Cumulative Amount Collected: July August September October November December January February March April May June 14,826.36 33,744.36 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 10.59% 24.10% July August September October November December January February March April May June Historic High % of Total: 4.46% 17.28% 24.02% 27.90% 34.97% 36.39% 39.45% 41.89% 68.77% 83.72% 96.55% 100.00% Cumulative Percent of Forecast Collected: 10.59% 24.10% Historic Low % of Total: 0.99% 6.82% 13.41% 16.67% 21.81% 25.29% 25.75% 28.58% 53.24% 68.80% 91.21% 100.00% Historic Average % of Total: 2.84% 12.51% 18.39% 22.77% 28.01% 30.27% 33.47% 36.90% 59.62% 78.14% 93.74% 100.00% Historic Median % of Total: 2.83% 14.34% 18.76% 22.88% 29.33% 31.09% 34.64% 38.31% 57.96% 79.92% 93.28% 100.00%

Trash Revenue Revised 1st Qtr Forecast Amount: 1,191,411.00 Actual Amount Collected: July August September October November December January February March April May June 94,547.03 98,055.31 Cumulative Amount Collected: July August September October November December January February March April May June 94,547.03 192,602.34 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 7.94% 16.17% July August September October November December January February March April May June Historic High % of Total: 8.55% 16.79% 25.04% 33.29% 41.56% 49.85% 59.05% 66.44% 74.86% 83.20% 92.48% 100.00% Cumulative Percent of Forecast Collected: 7.94% 16.17% Historic Low % of Total: 5.49% 11.53% 18.05% 25.54% 33.62% 42.37% 51.11% 53.54% 66.20% 74.22% 83.07% 100.00% Historic Average % of Total: 7.50% 15.18% 23.09% 31.13% 39.39% 47.52% 55.86% 63.38% 72.72% 81.28% 90.54% 100.00% Historic Median % of Total: 7.64% 15.84% 24.18% 32.54% 40.92% 49.25% 57.51% 65.92% 74.46% 82.92% 91.45% 100.00% Rate increase for out-of-City customers was not implemented until August.

Trash Fee Rebate Revised 1st Qtr Forecast Amount: 170,000.00 167,589 Actual Amount Collected: July August September October November December January February March April May June - 167,558.60 Cumulative Amount Collected: July August September October November December January February March April May June - 167,558.60 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 0.00% 98.56% July August September October November December January February March April May June Historic High % of Total: 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Cumulative Percent of Forecast Collected: 0.00% 98.56% Historic Low % of Total: 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Historic Average % of Total: 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% Historic Median % of Total: 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

General Fund Total Revenue Revised 1st Qtr Forecast Amount: 38,133,833.00 Actual Amount Collected: July August September October November December January February March April May June 11,476,185.55 1,025,736.00 Cumulative Amount Collected: July August September October November December January February March April May June 11,476,185.55 12,501,921.55 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 30.09% 32.78% July August September October November December January February March April May June Historic High % of Total: 48.06% 55.86% 65.50% 69.21% 76.07% 83.29% 86.19% 91.56% 92.93% 95.20% 97.38% 100.00% Cumulative Percent of Forecast Collected: 30.09% 32.78% Historic Low % of Total: 30.60% 36.03% 39.43% 46.13% 49.10% 62.02% 69.64% 71.72% 78.01% 80.52% 86.94% 100.00% Historic Average % of Total: 38.38% 43.18% 50.74% 58.03% 63.21% 71.83% 77.70% 82.32% 86.66% 91.30% 94.86% 100.00% Historic Median % of Total: 39.22% 42.39% 48.05% 56.19% 59.95% 72.88% 77.23% 82.06% 86.25% 93.37% 96.37% 100.00% Municipal Street Aid should be adjusted to actual receipt $709,694.

Water Fees Revised 1st Qtr Forecast Amount: 4,371,900.00 Actual Amount Collected: July August September October November December January February March April May June 396,579.80 447,480.14 Cumulative Amount Collected: July August September October November December January February March April May June 396,579.80 844,059.94 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 9.07% 19.31% July August September October November December January February March April May June Historic High % of Total: 13.03% 21.40% 30.62% 39.40% 46.71% 57.61% 64.93% 72.04% 80.71% 86.84% 92.96% 100.00% Cumulative Percent of Forecast Collected: 9.07% 19.31% Historic Low % of Total: 6.39% 18.20% 27.51% 35.31% 43.18% 51.35% 59.59% 60.32% 73.97% 81.66% 89.76% 100.00% Historic Average % of Total: 9.54% 19.58% 28.82% 37.03% 45.00% 53.39% 60.84% 67.42% 75.51% 83.01% 91.11% 100.00% Historic Median % of Total: 9.59% 19.30% 28.72% 37.11% 44.98% 52.77% 60.32% 67.54% 74.98% 82.47% 91.06% 100.00%

Sewer Fees Revised 1st Qtr Forecast Amount: 2,508,600.00 Actual Amount Collected: July August September October November December January February March April May June 226,530.92 243,449.51 Cumulative Amount Collected: July August September October November December January February March April May June 226,530.92 469,980.43 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 9.03% 18.73% July August September October November December January February March April May June Historic High % of Total: 9.93% 28.03% 35.58% 44.59% 53.87% 63.91% 63.22% 69.68% 79.03% 85.63% 92.35% 100.00% Cumulative Percent of Forecast Collected: 9.03% 18.73% Historic Low % of Total: 5.17% 16.67% 25.09% 33.17% 41.41% 49.69% 57.87% 60.72% 73.11% 80.92% 89.95% 100.00% Historic Average % of Total: 8.72% 19.06% 28.14% 36.80% 44.40% 53.28% 59.66% 66.72% 75.01% 82.91% 91.11% 100.00% Historic Median % of Total: 9.27% 18.20% 27.38% 35.61% 43.28% 52.06% 59.09% 66.83% 74.70% 82.62% 91.03% 100.00%

Fuel Waste-Water Adjust Revised 1st Qtr Forecast Amount: 4,264,357.00 Actual Amount Collected: July August September October November December January February March April May June 361,336.18 389,665.42 Cumulative Amount Collected: July August September October November December January February March April May June 361,336.18 751,001.60 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 8.47% 17.61% July August September October November December January February March April May June Historic High % of Total: 10.13% 29.01% 36.51% 45.85% 46.28% 57.69% 63.82% 70.18% 79.72% 86.22% 92.67% 100.00% Cumulative Percent of Forecast Collected: 8.47% 17.61% Historic Low % of Total: 4.95% 14.13% 21.61% 28.23% 34.83% 41.28% 58.01% 60.74% 73.17% 81.72% 90.28% 100.00% Historic Average % of Total: 8.44% 18.51% 27.19% 35.55% 42.74% 51.39% 59.85% 66.89% 75.19% 83.07% 91.18% 100.00% Historic Median % of Total: 9.01% 18.05% 26.71% 34.79% 43.00% 50.69% 58.80% 66.59% 74.75% 82.62% 90.94% 100.00%

Impact Fee Revised 1st Qtr Forecast Amount: 746,500.00 Actual Amount Collected: July August September October November December January February March April May June 75,220.68 108,391.52 Cumulative Amount Collected: July August September October November December January February March April May June 75,220.68 183,612.20 Cumulative Percent of Forecast Collected: July August September October November December January February March April May June 10.08% 24.60% July August September October November December January February March April May June Historic High % of Total: 49.95% 53.71% 56.55% 59.21% 63.70% 69.79% 75.63% 87.48% 89.53% 94.36% 96.21% 100.00% Cumulative Percent of Forecast Collected: 10.08% 24.60% Historic Low % of Total: 0.00% 0.00% 32.78% 39.03% 49.49% 55.37% 60.52% 69.20% 74.75% 82.02% 89.29% 100.00% Historic Average % of Total: 20.94% 29.12% 41.05% 48.52% 56.50% 63.13% 68.99% 77.41% 82.13% 86.98% 92.50% 100.00% Historic Median % of Total: 19.62% 32.93% 38.60% 47.24% 57.96% 65.57% 71.08% 76.26% 82.46% 86.75% 92.16% 100.00%