The URL can be used to link to this page

Home My WebLink AboutAera Fiscal Impact Analysis 03.2007.pdfFISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 EXHIBIT A ANNUAL GENERAL FUND IMPACTS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 General Fund Net Revenues 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 4,301,000 1,192,000 3,109,000 Expenses Revenues Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 8:57 AM; jj EXHIBIT B COMPOSITION OF ANNUAL REVENUES AND EXPENSES AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 CITY GENERAL FUND REVENUES CITY GENERAL FUND EXPENSES Total Revenues: $4,301,000 Million Total Expenses: $3,109,000 Million Legislative Franchise Tax 1 oda Replacement Reserves & c„n,,,, „a __.._____ Property Transf, Tax 5% Sales Tax 10% Motor Vehicle License Fees 44% Public Works 13% Administration & Supp( 9% Community 9% Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 8:57 AM; jj ublic Safety / Police 63% Table 1 PROJECT DESCRIPTION FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 DEVELOPMENT PROGRAM RESIDENTIAL 72,000 SF MARKET RATE 52,000 SF Single Family Detached 2,200 Units Single Family Attached 600 Units Office 2,800 Units AFFORDABLE (Deed Restricted) 200,000 SF Single Family Detached 0 Units Single Family Attached 0 Units Apartments 0 Units 0 Units TOTAL RESIDENTIAL 2,800 Units COMMERCIAL In -Line Shops 72,000 SF Supermarket 52,000 SF Restaurants 16,000 SF Cinema 50,000 SF Office 10,000 SF Total Community Shopping Center 200,000 SF INFRASTRUCTURE TO BE MAINTAINED BY GENERAL FUND 15% of Park 6.75 ac Entry Road 218,000 sf 4,600 linear ft Brea Canyon Road to Golf Course entry 353,800 sf 8,000 linear ft Golf Course entry to County line 360,000 sf 9,000 linear ft INFRASTRUCTURE TO BE PRIVATELY OWNED AND MAINTAINED 85% of Park38.25 ac Open Space n/a Interior Streets n/a Storm Drain System n/a INFRASTRUCTURE TO BE MAINTAINED BY LANDSCAPING AND LIGHTING DISTRICT Street Lights n/a Landscaped Medians n/a Notes: Aera estimates 45 acres of parks will be required based on the development program; 85% will be built within the gated portion of the community and 15% will be maintained by the City. Source: Aera 11.16.2006 Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 8:57 AM; jj Table la SUMMARY OF PROPOSED FUNDING OF MAINTENANCE / OPERATING COSTS FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR. CA WORKING DRAFT 3/16/2007 Landscape & Fire General Lighting Protection Water Fund HOA District District District Total Legislative 100% Administration & Support 100% Community Development / Planning 100% Equipment Replacement & Insurance 100% Base Community Services / Recreation 100% On -Site Park 15% 85% On -Site Open Space 100% Base Public Works 100% Public Roads (incl. roadway, sidewalks, curbs, 100% gutters, signs, signals) Interior Streets (incl. roadway, sidewalks, curbs, 100% gutters, signs, signals) Drainage / Stormwater System - Public Roads 100% Drainage / Stormwater System - Interior Streets 100% Street Lights - Public Roads 100% Street Lights - Interior Streets 100% Landscaped Areas - Public Roads 100% Landscaped Areas - Interior Streets 100% Water and Sewer Public Safety / Police 100% Fire Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 8:57 AM; jj 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% Table 2 ANNUAL GENERAL FUND IMPACT FISCAL IMPACT ANALYSI1c AERA MASTER PLAN COMMUNITII CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 ANNUAL GENERAL FUND REVENUE / %a OF EXPENSE AT BUILDOUT TOTAL RECURRING GENERAL FUND AND PUBLIC WORKS FUND REVENUE Motor Vehicle License Fees 1,875,000 44% Property Tax 1,514,000 35% Sales Tax 434,000 10% Property Transfer Tax 198,000 5% Gas Tax 148,000 3% Franchise Tax 132,000 3% TOTAL 4,301,000 100% RECURRING GENERAL FUND AND PUBLIC WORKS FUND EXPENSES' Public Safety / Police 1,952,000 63% Community Services 291,000 9% Administration & Support 284,000 9% Public Works 406,000 13% Community Development 85,000 3% Legislative 44,000 1% Replacement Reserves & Insurance 47,000 2% TOTAL 3,109,000 100% NET ANNUAL GENERAL AND PUBLIC WORKS FUND $1,192,000 REVENUE(EXPENSE) Notes: Excludes expenses to maintain parks and roads within gated portions of the community; fire expenses covered through fire service district. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:08 AM; jj Table 3 EXISTING POPULATION AND EMPLOYMENT FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 RESIDENT DAY & NIGHTTIME POPULATION' EMPLOYMENT EQUIVALENTS POPULATION 0.35 per employee 1.00 per resident CITY OF DIAMOND BAR 59,722 19,431 66,523 Notes: State of California, Department of Finance, E-1 City/County Population Estimates, with Annual Percent Change, January 1, 2005 and 2006. Sacramento, California, May 2006. 1/1/06 Estimate. 2 Claritas 2006 3 Population plus employment. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:08 AM; jj 79,153 Table 4 POPULATION AND EMPLOYMENT ESTIMATES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 POPULATION DAY & UNIT OR RESIDENT NIGHTTIME 2 BASIS SIZE 1 EMPLOYMENT EQUIVALENTS POPULATION TOTAL 9,135 9,460 Population 8,960 Employment 500 Notes: Per Aera. 11.16.2006. 2 Total population plus employment. 3 Based on the average household size for the Aera project in Yorba Linda, CA per Aera 11.13.2006 and equal to the average household size for owner occupied units in Diamond Bar per the 2000 U.S. Census. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:08 AM; jj 1.00 RESIDENTIAL household size: 3 per resident MARKET RATE Single Family Detached 2,200 DU 3,300 SF 3.20 7,040 7,040 7,040 Single Family Attached 600 DU 2,000 SF 3.20 1,920 1,920 1,920 2,800 DU 8,960 8,960 8,960 AFFORDABLE (Deed Restricted) Single Family Detached 0 DU 3.20 0 0 0 Single Family Attached 0 DU 3.20 0 0 0 Apartments 0 DU 3.20 0 0 0 0 DU 0 0 0 employment 0.35 density per 1,000: per employee COMMERCIAL Community Shopping Center 200,000 Sq. Ft. 2.50 500 175 500 TOTAL 9,135 9,460 Population 8,960 Employment 500 Notes: Per Aera. 11.16.2006. 2 Total population plus employment. 3 Based on the average household size for the Aera project in Yorba Linda, CA per Aera 11.13.2006 and equal to the average household size for owner occupied units in Diamond Bar per the 2000 U.S. Census. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:08 AM; jj Table 5 - A GENERAL FUND REVENUE SOURCE ASSUMPTIONS FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 Property Taxes' 5.1917418% City share of 1 % property tax, based on AV. Property Transfer Tax 2 $ 0.55 Per $1,000 of AV at transfer Turnover Residential - Market rate 12.50% Assumed Annually Residential - Affordable 6.25% Assumed Annually Sales Tax, City's Portion 3 1% Local Share of Sales Tax 4,842 Taxable Sales Per Resident Gas Tax 985,750 Revenues in 2006/07 59,722 Residents 16.51 Per Resident Motor Vehicle License Fees 4 $3,398,067 Property Tax Based Revenues for 2004-05 5,446,642,517 2004-05 Diamond Bar gross AV 0.624 Per $1,000 in AV growth 370,000 Population Based Revenues for 2006-07 59,722 Residents 6.20 Per Resident Franchise Tax $960,000 Revenues for 2006-07 66,523 Resident Equivalents 14.43 Per Resident Equivalent Notes: Based on tax rate area ratios in neighboring parcels within the City of Diamond Bar (see Appendix C - 1). 2 Calculated on turnover of residential units, based on rate per Diamond Bar City Code. Commercial property assumed to be subject to extensive hold periods. 3 See Appendix tables D - 1 to D - 3. 4 Estimated in accordance with SB 1096 based on data from the California State Controller's Office. Only property tax based revenues have been included. Health and Welfare Reallignment MVLF is driven by case loads and is treated as a cost recovery revenue deducted from net Health and Sanitation and Public Assistance Costs. Source: City of Diamond Bar, Budget for the Fiscal Year 2006-2007 (See Appendix A - 1 and A - 2). Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DlamondBarFiscal_3.7.07.xls; 3/16/2007; 9:08 AM; jj Table 5 - B ANNUAL GENERAL FUND REVENUES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA GENERAL FUND REVENUES PROPERTY TAX (City Share) PROPERTY TRANSFER TAX' Residential - Market Rate Residential - Affordable Subtotal SALES TAX (1 % local share) MOTOR VEHICLE LICENSE FEES Assessed value based revenue Population based revenue Subtotal WORKING DRAFT 3/16/2007 TOTAL AT BASIS MEASURE 2 BUILDOUT 2,916,000 AV added ($000s) 5.1917418% of 1 % prop tax $1,514,000 2,874,000 AV added ($000s) $0.55/$1,000 AV, 12.50% turnover $198,000 0 AV added ($000s) $0.55/$1,000 AV, 6.25% turnover 198,000 8,960 residents $4,842 per resident $434,000 2,916,000 AV added ($000s) $0.624 per $1,000 in AV $1,819,000 8,960 residents $6.20 per resident $56,000 1,875,000 GAS TAX 8,960 residents $16.51 per resident $148,000 FRANCHISE TAX 9,135 resident equivalents $14.43 per resident equiv. $132,000 TOTAL GENERAL FUND REVENUES $4,301,000 Notes: Calculated based on turnover of residential units. Commercial property assumed to be subject to extensive hold periods. 2 See Table 5 - A. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:08 AM; jj Table 5 - C SUMMARY OF ANNUAL GENERAL FUND REVENUES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 TOTAL REVENUES AT BUILDOUT RECURRING GENERAL FUND REVENUES Property Tax 1,514,000 Property Transfer Tax 198,000 Sales Tax 434,000 Motor Vehicle License Fees 1,875,000 Gas Tax 148,000 Franchise Tax 132,000 TOTAL $4,301,000 Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:09 AM; jj Table 6 - A GENERAL FUND OPERATING EXPENSES ASSUMPTIONS' FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 Legislative 1,272,740 Expenses in 2006/07 Park Square Footage 25% Percent Variable Costs 50% 66,523 Resident Equivalents 2 Resident Equivalents 2 4.78 Per Resident Equivalent Administration & Support 4,140,735 Expenses in 2006/07 50% Percent Variable Costs 66,523 Resident Equivalents 2 31.12 Per Resident Equivalent Public Safety / Police 1,859,017 Estimated by LASD 3 5% Annual increase from 2005/06 1,952,000 Estimated for 2006/07 Fire Service provided by the Consolidated Fire Protection District of Los Angeles County Community Development 1,241,180 Expenses in 2006/07 50% Percent Variable Costs 66,523 Resident Equivalents 2 9.33 Per Resident Equivalent Community Services $2,859,670 Expenses in 2006/07 50% Percent Variable Costs 59,722 Residents 23.94 Per Resident 6.75 Park Acres 4 294,030 Park Square Footage Public Works $1,474,610 Expenses in 2006/07 50% Percent Variable Costs 66,523 Resident Equivalents 2 11.08 Per Resident Equivalent Replacement Reserves & Insurance 343,350 Expenses in 2006/07 100% Percent Variable Costs 66,523 Resident Equivalents 2 5.16 Per Resident Equivalent Notes: For City service departments. Z Assumes 1 employee = 0.35 residents (see Table 3). 3 Police services in Diamond Bar are contracted to the Los Angeles County Sheriffs Department (LASD). The cost to serve the project has been estimated by LASD based on the cost of 1 crime patrol car and 1 traffic patrol car 24 hours per day 7 days a week and 1 motorcycle officer 40 hours per week (without relief). Adjusted upwards by KMA by 5% from 2005/06 to 2006/07 costs consistent with estimates in the City's budget and typical annual increases noted by LASD. 4 Park acres to be maintained by City are 15% of the total 45 park acres in the project, per Aera 11. 16.2006 (see Table 1). Source: City of Diamond Bar, Budget for the Fiscal Year 2006-2007 (See Appendix A - 1 and A - 2). Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:09 AM; jj Table 6 - B ANNUAL GENERAL FUND EXPENSES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA GENERAL FUND EXPENSES Legislative Administration & Support Public Safety / Police Community Development Community Services Base Community Services (per Budget) Additional Park Area Total Community Services Public Works Base Public Works (per Budget) Additional Public Roads 3 Total Public Works Replacement Reserves & Insurance TOTAL GENERAL FUND EXPENSES WORKING DRAFT 3/16/2007 TOTAL AT 9,135 resident equivalents 4.78 per resident equiv. 44,000 9,135 resident equivalents 31.12 per resident equiv. 284,000 Estimated by LASD' 1,952,000 9,135 resident equivalents 9.33 per resident equiv. 85,000 8,960 residents 23.94 per resident 215,000 294,030 square feet 0.26 per square foot 2 76,000 291,000 9,135 resident equivalents $11.08 per resident equiv. $101,000 305,000 406,000 9,135 resident equivalents $5.16 per resident equiv. $47,000 Notes: See Table 6 - A. 2 Assumes 50% active and 50% passive park; at $0.22 and $0.30 per square foot, respectively, per City staff. 3 See Table 6 - C. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:09 AM; jj 3,109,000 Table 6 - C ADDITIONAL PUBLIC ROAD MAINTENANCE COSTS FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 TOTAL AT BASIS MEASURE BUILDOUT CLARIFICATIONS NEEDED: Signage amount/cost per unit Sidewalk square footage Review all Notes: Except landscaping and street lighting, assumed to be maintained by landscaping and lighting assessment district. 2 Per Aera: 11.16.2006 for Public Entry Rd., 3.1.2007 for Brea Canyon Rd. and Golf Course entry to County line. 3 Estimated based on KMA experience in other similar projects. 4 Per City staff for Public Entry Rd.: one 4 -way interior signalized intersection, one traffic light at Brea Canyon and Highway 57. No info given for Brea Canyon/Golf Course to County line. 5 For Public Entry Rd., estimated based on sidewalk area at 20% of street surface area, per KMA experience in similar projects. Per Aera 3.1.2007 for Brea Canyon/Golf Course to County line. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:09 AM; jj Brea Canyon Golf Course Public Entry Rd. to Golf Entry to Street Maintenance Cost Detail' Rd. Course Entry County Line Total Roadway 218,000 353,800 360,000 931,800 square feet 2 0.20 per square foot 3 186,360 Pavement Delineation 4,600 8,000 9,000 21,600 linear feet 2 0.14 per linear foot 3 3,024 Traffic Signals 5 n/a n/a 5 number 4 624 per signal 4 3,120 Signage 218,000 353,800 360,000 931,800 square feet 2 0.01 per square foot 3 6,026 Curb and Gutter Repair 4,600 8,000 9,000 21,600 linear feet 2 1.00 per linear foot 3 21,600 Sidewalk 43,600 75,200 81,000 199,800 square feet 5 0.15 per square foot 3 29,970 Drainage System 218,000 353,800 360,000 931,800 square feet 2 0.06 per square foot 3 54,976 TOTAL GENERAL FUND EXPENSES 305,077 Per Square Foot 0.33 CLARIFICATIONS NEEDED: Signage amount/cost per unit Sidewalk square footage Review all Notes: Except landscaping and street lighting, assumed to be maintained by landscaping and lighting assessment district. 2 Per Aera: 11.16.2006 for Public Entry Rd., 3.1.2007 for Brea Canyon Rd. and Golf Course entry to County line. 3 Estimated based on KMA experience in other similar projects. 4 Per City staff for Public Entry Rd.: one 4 -way interior signalized intersection, one traffic light at Brea Canyon and Highway 57. No info given for Brea Canyon/Golf Course to County line. 5 For Public Entry Rd., estimated based on sidewalk area at 20% of street surface area, per KMA experience in similar projects. Per Aera 3.1.2007 for Brea Canyon/Golf Course to County line. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:09 AM; jj Table 6 - D SUMMARY OF ANNUAL GENERAL FUND EXPENSES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 TOTAL EXPENSES AT BUILDOUT RECURRING GENERAL FUND EXPENDITURES Legislative 44,000 Administration & Support 284,000 Public Safety / Police 1,952,000 Community Development 85,000 Community Services 291,000 Public Works 406,000 Replacement Reserves & Insurance 47,000 TOTAL $3,109,000 Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\Diamond Bar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:09 AM; jj APPENDIX A: GENERAL FUND ANALYSIS INPUTS WORKING DRAFT 3/16/2007 Appendix A - 1 SUMMARY OF GENERAL FUND REVENUE SOURCES' FISCAL IMPACT ANALYSI: AERA MASTER PLAN COMMUNIT) CITY OF DIAMOND BAR, CE WORKING DRAFT 3/16/2007 AMOUNTS NET BUDGET DEDUCTED FROM AFTER 2006-07 SERVICE COSTS DEDUCTIONS COMMENTS / ASSUMPTIONS REVENUES INCLUDED IN ANALYSIS Property Taxes 3,315,000 0 3,315,000 Projected based on development program Property Taxes - HOX 30,000 0 30,000 Projected based on development program Sales Taxes 4,000,000 0 4,000,000 Based on new retail, residents, expenditure patterns Franchise Tax 960,000 0 960,000 Projected based on resident equivalents (electric, gas, cable) Property Transfer Tax 425,000 0 425,000 Projected based on homes values, assumed turnover rate VLF 370,000 0 370,000 Projected based on residents VLF - Property Tax in Lieu 3,868,000 0 3,868,000 Projected based on increases in Assessed Valuation Transfer in from Gas Tax Fund 985,750 0 985,750 Projected based on residents, assumes transferred to the General Fund per current budget Subtotal 13,953,750 0 13,953,750 REVENUES DEDUCTED FROM SERVICE COSTS Fines & Forfeitures Vehicle Code Fines 390,000 390,000 0 Law Enforcement Program Revenue General Fines 22,000 22,000 0 Law Enforcement Program Revenue Municipal Code Fines 500 500 0 Law Enforcement Program Revenue Parking Fines 165,000 165,000 0 Law Enforcement Program Revenue Vehicle Impound Fees 15,000 15,000 0 Law Enforcement Program Revenue False Alarm Fees 25,000 25,000 0 Fire Program Revenue Subtotal 617,500 617,500 0 Building Permit Fees 750,400 750,400 0 Building & Safety Program Revenue Planning Fees 410,000 410,000 0 Community Development/Planning Program Revenue Engineering Fees 967,000 967,000 0 Engineering Program Revenue Recreation Fees 676,385 676,385 0 Recreation Program Revenue Transfer In - AB2766 70,000 70,000 0 Devel. Svcs - Online permitting/inspections for air quality Transfer In - Safe Parks 53,000 53,000 0 Recr. - Prop A Activities - Youth master plan implementation Subtotal 03,544,285 3,544,285 REVENUES EXCLUDED FROM THE ANALYSIS Transient Occupancy Tax 700,000 0 700,000 A hotel is not anticipated in the subject development Federal Grants 70,000 0 70,000 Independent of subject development Transfer In - Prop C Fund 9,000 0 9,000 Independent of subject development Transfer In - Int. Wast Mgt. Fd 185,000 0 185,000 Independent of subject development Transfer In - COPS Fund 180,300 0 180,300 Independent of subject development Off Highway Tax 1,000 0 1,000 Independent of subject development Use of Money and Property 1,282,900 0 1,282,900 Independent of subject development Economic Dev. Fund Balance 715,850 0 715,850 Independent of subject development ERAF III State Takeaway 397,475 397,475 Independent of subject development Subtotal 2,746,575 0 2,746,575 Total General Fund 16,700,32520,244,610 3,544,285 Notes: For funding City departmental services Source: City of Diamond Bar. Proposed Budget for the Fiscal Year 2006-2007. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:11 AM; jj Appendix A - 2 SUMMARY OF GENERAL FUND BUDGET EXPENDITURES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 LESS) NET GF EXP 2006-07 PROGRAM INCLUDED IN BUDGET REVENUE' ANALYSIS GENERALFUND Legislative City Council 171,600 0 171,600 City Attorney 165,000 0 165,000 City Manager/City Clerk 936,140 0 936,140 Total 1,272,740 0 1,272,740 Administration and Support Finance 420,300 0 420,300 Human Resources 241,415 0 241,415 Information Systems 1,268,590 0 1,268,590 General Government 1,632,640 0 1,632,640 Public Information 577,790 0 577,790 Total 4,140,735 0 4,140,735 Public Safety / Police Law Enforcement 4,987,000 592,500) 4,394,500 Volunteer Patrol 9,250 0 9,250 Fire 40,900 25,000) 15,900 Animal Control 112,500 0 112,500 Emergency Preparedness 43,290 0 43,290 Total 5,192,940 617,500) 4,575,440 Community Development 647,890 0 647,890 Community Dev./Planning 916,630 480,000) 436,630 Building & Safety 482,600 750,400) 267,800) Neighborhood Improvement 356,500 0 356,500 Economic Development 715,850 0 715,850 Total 2,471,580 1,230,400) 1,241,180 Community Services Community Services Admin 470,760 0 470,760 Diamond Bar Center - Oper. 884,730 0 884,730 Park Operations 730,510 0 730,510 Recreation 1,503,055 729,385) 773,670 Total 3,589,055 729,385) 2,859,670 Public Works Public Works - Admin 647,890 0 647,890 Engineering 316,150 967,000) 650,850) Road Maintenance 1,135,750 0 1,135,750 Landscape Maintenance 341,820 0 341,820 Total 2,441,610 967,000) 1,474,610 Replacement Reserves & Insurance 343,350 0 343,350 transfer out) 19,452,010 3,544,285) 15,907,725 Notes: Program revenue identified on Appendix Table A - 1 Source: City of Diamond Bar. Proposed Budget for the Fiscal Year 2006-2007. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; 3/16/2007; 9:11 AM; jj APPENDIX B: ASSESSED VALUATION WORKING DRAFT 3/16/2007 Appendix B - 1 ASSESSED VALUATION AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 VALUE TOTAL ASSESSED BASIS PER UNIT VALUE AT BUILDOUT MARKET RATE VALUE ADDED Single Family Detached 2,200 DU $1,110,000 ' $2,442,000,000 Single Family Attached 600 DU $720,000 ' $432,000,000 Total 2,800 $1,030,000 $2,874,000,000 AFFORDABLE VALUE ADDED Single Family Detached 0 DU $0 Single Family Attached 0 DU Total $0 COMMERCIAL VALUE ADDED 2 Community Shopping Center 200,000 SF $210 2 $42,000,000 E.M.11. 111 111 Notes: Based on estimates from Aera 11.16.06. 2 Estimated based on Marshall and Swift Valuation Service, and land and site improvements value of $25 per sq. ft. Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; B-1 value added; 3/16/2007; jj APPENDIX C: TAX RATES WORKING DRAFT 3/16/2007 Appendix C - 1 TAX RATIO DISTRIBUTION FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 TAX RATE AREA 10068' AGENCIES RATIO Los Angeles County General LA County Accumulated Capital Outlay LA County Library Consolidated Fire Protection District of LA County LA County Fire - FFW 0.248744616 0.000110142 0.022368177 0.169363881 0.006156475 County Lighting Maintenance District No. 10006 0.020156003 LA County Flood Control Dr. Imp. Dist. Maintenance 0.001643522 LA County Flood Control Maintenance 0.009300947 Greater LA County Vector Control 0.000354735 County Sanitary District No. 21 Operating 0.012213084 City of Diamond Bar Tax District #1 0.051917418 Three Valley Metropolitan Water District Original Area 0.004089167 Walnut Valley Water District 0.000725305 Walnut Valley Water District Imp. Dist. #3 0.006585074 Walnut Valley Water District Imp. Dist. #4 0.001599968 Educational Revenue Augmentation Fund 0.078135050 Educational Augmentation Fund Impound 0.133937622 County School Services 0.001366065 Children's Instil. Tuition Fund 0.002711165 Mt. San Antonio Community College 0.029260376 Mt. San Antonio Children's Center Fund 0.000282427 Walnut Valley Unified School District 0.190573308 County School Service Fund - Walnut Valley 0.007573791 Dev. Center Handicapped Minors - Walnut Valley 0.000831682 Total 1.000000000 Notes: Tax rate area for Diamond Bar parcels neighboring Aera development. Source: Modified ATI Ratio Report FY 2006-07, Los Angeles County Auditor -Controller. Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xis; C-1 tax rates; 3/16/2007; jj APPENDIX D: RETAIL EXPENDITURE ANALYSIS WORKING DRAFT 3/16/2007 Appendix D - 1 TAXABLE RETAIL SALES PER CAPITA FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY WORKING DRAFT 3/16/2007 CITY OF DIAMOND BAR, CA 2005 CITY OF % of AERA COMMUNITY % of DIAMOND BARTotal AT BUILDOUT Z Total Taxable Retail Sales ($000s) General Merchandise 23,581 8.2% 3,538 8.2% Apparel 941 0.3% 141 0.3% HF & A 1,828 0.6% 274 0.6% Grocery 15,207 5.3% 2,281 5.3% Restaurants & Bars 49,841 17.2% 7,478 17.2% Building Materials & Farm Implements 8,117 2.8% 1,218 2.8% Service Stations 87,243 30.2% 13,089 30.2% Other Retail Stores 102,405 35.4% 15,364 35.4% Total Taxable Retail Sales 289,163 100.0% 43,383 100.0% Population 3 Taxable Retail Sales per Capita 59,722 4,842 Notes: California Retail Survey, 2006 Edition. 2 Distributed based on 2005 taxable retail sales per capita, and percent of spending per category. See Table 3 and 4. 8,960 4,842 Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; D-1; 3/16/2007; jj Appendix D - 2 TAXABLE RETAIL SALES IN COMMUNITY SHOPPING CENTER FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 RETAIL ESTIMATED PERCENT TAXABLE SQ.FT.' SALES PSF 2 TAXABLE 2 SALES $000s Aera Master Plan Retail In -Line Shops 72,000 220 90% 14,300 Supermarket 52,000 600 50% 15,600 Restaurants 16,000 400 100% 6,400 Cinema Food and Beverage 50,000 30 100% 1,500 Office (Second Floor) 10,000 0 0% 0 200,000 189 78% 37,800 Notes: Per Aera drawing 11.16.2006. 2 Per Dollars & Cents of Shopping Centers: 2004, Restaurant Industry Operations Report 2004, KMA experience in similar projects. Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DiamondBarFiscal_3.7.07.xls; D-2; 3/16/2007; jj Appendix D - 3 TAXABLE SALES ALLOCATED TO PROJECT FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 3/16/2007 Taxable Sales Comparison Total Annual Sales Residents/Retail Sq. Ft. Per Resident/Retail Sq. Ft. Notes: See Table D - 1. 2 See Table D - 2. BASED ON NEW BASED ON RESIDENTS 1 NEW RETAIL 2 43,383,000 8,960 res. 4,842/res. Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\DlamondBarFiscal_3.7.07.xls; D-3; 3/16/2007; jj 37,800,000 200,000 sf 189/sf FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 EXHIBIT A ANNUAL GENERAL FUND IMPACTS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 General Fund Net Revenues 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 10 4,301,000 1,416,000 I 13Expenses Revenues Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fsi\Employee\jjohnston\work\fiscal-impact\Diamond Bar\Diamond Bar—Fiscal 11.30.06.xls; 12/5/2006; 12:12 PM; jj co_ h W onozOWmWWWN Z JQ N W Z O V w oUH moNNm J 0a F N o t 0 a o O n zy o N o 0 o E O nc U E Q F N o t 0 a Table 1 PROJECT DESCRIPTION FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 RESIDENTIAL MARKET RATE Single Family Detached Single Family Attached AFFORDABLE (Deed Restricted) Single Family Detached Single Family Attached Apartments TOTAL RESIDENTIAL COMMERCIAL Community Shopping Center INFRASTRUCTURE TO BE MAINTAINED BY GENERAL FUND 15% of Park Entry Road t yy_irZQiji(gl(i77:71%r AL PJI I L•1 I]P I_11 Y/_11 1 85% of Park Open Space Interior Streets Storm Drain System DEVELOPMENT PROGRAM 2,200 Units 600 Units 2,800 Units 0 Units 0 Units 0 Units 0 Units 2,800 Units 200,000 SF 6.75 ac 4,600 linear ft 218,000 sf INFRASTRUCTURE TO BE MAINTAINED BY LANDSCAPING AND LIGHTING DISTRICT 38.25 ac n/a n/a n/a Street Lights n/a Landscaped Medians n/a Notes: Aera estimates 45 acres of parks will be required based on the development program; 85% will be built within the gated portion of the community and 15% will be maintained by the City. Source: Aera 11.16.2006 Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fsl\Employee\jjohnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xis; 12/5/2006; 12:12 PM; jj 0- N m H H LL 9 U N zZ Y Y j ul U , m 2 O R m c w = o Y I F m E a = dY LL26 @ @ r 0 c5 C O N wUz zw zz_ LLO z z z LL wu)o U) J V KOLL¢zm z¢az 0 LLJ 0 O N w N tp LL¢U 06 OI d CILL 0000 000 00 0 °°°0000 00 O O O O O O O O O O 0 0 0 0 0 0 0 O O O O O O 0 0 0 O O O 0 0 0 0 0 0 0 O O 0 0 0 0 0 0 O O O O O 0 0 0 0 0 0 0 0 O O O O 000 0 OO 0 0 a LL N N 9 U NN O U) C j ul U , O m @ a w = I F m E a = @ @ r 0 c5 C O N h N O p CO N N O N U @O O U C C GO 0 x> a o ,m .v m E E w c ao a O o m m m Q Q mCNO30NfnNO) O) @@ C CO O 0 0' @ c c @ C J J@@@ J J¢ U w m O O m w 01 C O) U7 (n J J LL LL a LL Table 2 ANNUAL GENERAL FUND IMPACTS FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 ANNUAL GENERAL FUND REVENUE / % OF EXPENSE AT BUILDOUT TOTAL RECURRING GENERAL FUND AND PUBLIC WORKS FUND REVENUES Motor Vehicle License Fees 1,875,000 44% Property Tax 1,514,000 35% Sales Tax 434,000 10% Property Transfer Tax 198,000 5% Gas Tax 148,000 3% Franchise Tax 132,000 3% TOTAL 4,301,000 100% RECURRING GENERAL FUND AND PUBLIC WORKS FUND EXPENSES' Public Safety / Police 1,952,000 68% Community Services 291,000 10% Administration & Support 284,000 10% Public Works 182,000 6% Community Development 85,000 3% Legislative 44,000 2% Replacement Reserves & Insurance 47,000 2% TOTAL 2,885,000 100% NET ANNUAL GENERAL AND PUBLIC WORKS FUND $1,416,000 REVENUE(EXPENSE) Notes: Excludes expenses to maintain parks and roads within gated portions of the community; fire expenses covered through fire service district. Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\Johnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls; 12/5/2006; 12:12 PM; E 2 LL 06 Ig b E 2 E E ms u S 7# IL j 03 5 E m Ez a IL M z t { D Z( S} za k c IL 2§0 2 E w U- ad W m LL LL 0 0 0 O O O l O U) U) Z o rn 0 0 rn H W r 00 c L X00= 00 0 000i0 N a z TN z 0 11 C C14 ai H n mI W F Y F J OQ .OQ Z Q LLZ o J~ E E E E= CO c zO a~ Q Q LL LL Q LLW N h Q a H w E WYmm mm U. gQ 0 aC Cn L C.) O LL a g OWt: z a. zz Y 11 00 00010 o rn rnz 0 W 00 W oL1' n m LL LL 0 0 0 O O O l O U) U) Z o rnO 0 rn H W r 00 L X00= EL a a m LL LL N U) U) N 110 OD N 0 p N N (N! N V N L H 0 11 0 0000 LL LL F {L U) U) z N 1107N 0 N O W m IN 0 11 0 0000 O I O O O N m In O N LL OOO OON m N U mcQO_ OtJNQ c E W E @ C E J CL a 00 Da°LU U F a co JW OO O O O OL O H m N O W Q V N HLU WLu z mU T N Q o U v a m O ro m m art J WZZQm OQ .OQ Z Q LLZWTT >. T W 0 w0 J~ E E E E= CO c zO a~ Q Q LL LL Q LLW N h Q H w E WYmm mm U. gQ 0 aC Cn L C.) LL a g OWt: a a Q U O I O O O N m In O N LL OOO OON m N U mcQO_ OtJNQ c E W E @ C E J CL a 00 Da°LU U F a Table 5 - A GENERAL FUND REVENUE SOURCE ASSUMPTIONS FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 Property Taxes 1 5.1917418% City share of I% property tax, based on AV Property Transfer Tax 2 0.55 Per $1,000 of AV at transfer Turnover Residential - Market rate 12.50% Assumed Annually Residential - Affordable 6.25% Assumed Annually Sales Tax, City's Portion 3 1% Local Share of Sales Tax 4,842 Taxable Sales Per Resident Gas Tax 985,750 Revenues in 2006/07 59,722 Residents 16.51 Per Resident Motor Vehicle License Fees ° 3,398,067 Property Tax Based Revenues for 2004-05 5,446,642,517 2004-05 Diamond Bar gross AV 0.624 Per $1,000 in AV growth 370,000 Population Based Revenues for 2006-07 59,722 Residents 6.20 Per Resident Franchise Tax $960,000 Revenues for 2006-07 66,523 Resident Equivalents 14.43 Per Resident Equivalent Notes: Based on tax rate area ratios in neighboring parcels within the City of Diamond Bar (see Appendix C - 1). 1 Calculated on turnover of residential units, based on rate per Diamond Bar City Code. Commercial property assumed to be subject tr extensive hold periods. s See Appendix tables D - 1 to D - 3. Estimated in accordance with SB 1096 based on data from the California State Controller's Office. Only property tax based revenues have been included. Health and Welfare Reallignment MVLF is driven by case loads and is treated as a cost recovery revenue deducted from net Health and Sanitation and Public Assistance Costs. Source: City of Diamond Bar, Budget for the Fiscal Year 2006-2007 (See Appendix A - 1 and A - 2). Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls; 12/5/2006; 12:12 PM; jj k 0 0 8G° S LU LLI U c Ek`=2a z % J j-/ LLI2} CO utk\ 2 0bQ6= I o 0 Lo 00 0 LU LLI U c Ek`=2a xz % J j-/ LLI2} utk\ 2 0bQ6= o#£G I o 0 LU LLI U c Ek`=2a xz % J j-/ LLI2} f U) utk\ 2 0bQ6= o#£G I o 0 Table 5 - C SUMMARY OF ANNUAL GENERAL FUND REVENUES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 TOTAL REVENUES AT BUILDOUT RECURRING GENERAL FUND REVENUES Property Tax 1,514,000 Property Transfer Tax 198,000 Sales Tax 434,000 Motor Vehicle License Fees 1,875,000 Gas Tax 148,000 Franchise Tax 132,000 TOTAL 4,301,000 Prepared by. Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls; 12/5/2006; 12:12 PM; jj Table 6 - A GENERAL FUND OPERATING EXPENSES ASSUMPTIONS' FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 1215/2006 Legislative 1,272,740 Expenses in 2006/07 Percent Variable Costs 25% Percent Variable Costs 5.16 66,523 Resident Equivalents 2 4.78 Per Resident Equivalent Administration & Support 4,140,735 Expenses in 2006/07 50% Percent Variable Costs 66,523 Resident Equivalents 2 31.12 Per Resident Equivalent Public Safety I Police 1,859,017 Estimated by LASD 3 5% Annual increase from 2005/06 1,952,000 Estimated for 2006/07 Fire Service provided by the Consolidated Fire Protection District of Los Angeles County Community Development 1,241,180 Expenses in 2006/07 50% Percent Variable Costs. 66,523 Resident Equivalents 2 9.33 Per Resident Equivalent Community Services 2,859,670 Expenses in 2006/07 50% Percent Variable Costs 59,722 Residents 23.94 Per Resident 6.75 Park Acres 4 294,030 Park Square Footage Public Works 1,474,610 Expenses in 2006/07 50% Percent Variable Costs 66,523 Resident Equivalents 2 11.08 Per Resident Equivalent Replacement Reserves & Insurance 343,350 Expenses in 2006/07 100% Percent Variable Costs 66,523 Resident Equivalents s 5.16 Per Resident Equivalent Notes: 1 For City service departments. 2Assumes 1 employee = 0.35 residents (see Table 3). Police services in Diamond Bar are contracted to the Los Angeles County Sheriffs Department (LASD). The cost to serve the project has been estimated by LASD based on the cost of 1 crime patrol car and 1 traffic patrol car 24 hours per day 7 days a week and 1 motorcycle officer 40 hours per week (without reref). Adjusted upwards by KMA by 5% from 2005/06 to 2006/07 costs consistent with estimates in the City's budget and typical annual increases noted by LASD. 4 Park acres to be maintained by City are 15% of the total 45 park acres in the project, per Aera 11. 16.2006 (see Table 1). Source: City of Diamond Bar, Budget for the Fiscal Year 2006-2007 (See Appendix A -1 and A-2). Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fsl\Employeeyjohnston\work\fiscal-impact\Diamond Bar\Diamond Bar—Fiscal 11.30.06.x15; 12/5/2006; 12:12 PM; jj a 0- C4 IT# G Y+ Ely cli& 0 2 CL co W 00CDm OD 3)_ z k a. 2;# k a0 z_j 0 m/< 7 2{2f\Ld t LU t f}) z k/) m00< G! u< z o o znw w E«o ca k 2 o 0 B {#« LL cn T ff>Z u Im 06j o k uj D B A S 6 G Z< 2 m< (L; E e 0. U 7u k; we q'<2 2/ I fJ\/ G0 z«o ca o B {#« cn T ff>Z u Table 6 - D SUMMARY OF ANNUAL GENERAL FUND EXPENSES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 TOTAL EXPENSES AT BUILDOUT RECURRING GENERAL FUND EXPENDITURES Legislative 44,000 Administration & Support 284,000 Public Safety / Police 1,952,000 Community Development 85,000 Community Services 291,000 Public Works 182,000 Replacement Reserves & Insurance 47,000 TOTAL $2,885,000 Prepared by: Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jiohnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls; 12/5/2006; 12:12 PM; jj APPENDIX A: GENERAL FUND ANALYSIS INPUTS WORKING DRAFT 12/5/2006 Appendix A - 1 SUMMARY OF GENERAL FUND REVENUE SOURCES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 AMOUNTS NET BUDGET DEDUCTED FROM AFTER 2006-07 SERVICE COSTS DEDUCTIONS COMMENTS I ASSUMPTIONS REVENUES INCLUDED IN ANALYST: Property Taxes 3,315,000 0 3,315,000 Projected based on development program Property Taxes - FOX 30,000 0 30,000 Projected based on development program Sales Taxes 4,000,000 0 4,000,000 Based on new retail, residents, expenditure patterns Franchise Tax 960,000 0 960,000 Projected based on resident equivalents (electric, gas, cable) Property Transfer Tax 425,000 0 425,000 Projected based on homes values, assumed turnover rate VLF 370,000 0 370,000 Projected based on residents VLF - Property Tax in Lieu 3,868,000 0 3,868,000 Projected based on increases in Assessed Valuation Transfer In from Gas Tax Fund 985,750 0 985,750 Projected based on residents, assumes transferred to the General Fund per current budget Subtotal 13,953,750 0 13,953,750 REVENUES DEDUCTED FROM SERVICE COST! Fines & Forfeitures Vehicle Code Fines 390,000 390,000 0 Law Enforcement Program Revenue General Fines 22,000 22,000 0 Law Enforcement Program Revenue Municipal Code Fines 500 500 0 Law Enforcement Program Revenue Parking Fines 155,000 165,000 0 Law Enforcement Program Revenue Vehicle Impound Fees 15,000 15,000 0 Law Enforcement Program Revenue False Alarm Fees$25,000$25,000 O Fire Program Revenue Subtotal 617,500 617,500 0 Building Permit Fees 750,400 750,400 0 Building 8 Safety Program Revenue Planning Fees 410,000 410,000 0 Community Development/Planning Program Revenue Engineering Fees 967,000 967,000 0 Engineering Program Revenue Recreation Fees 676,385 676,385 0 Recreation Program Revenue Transfer ln-AB2766 70,000 70,000 0 Dev.1Svcs- Online permitting/inspections for air quality Transfer In - Safe Parks 53,000 53,000 0 Recn- Prop A Activities- Youth master plan implementation Subtotal 3,544,285 3,544,285 0 REVENUES EXCLUDED FROM THE ANALYST: Transient Occupancy Tax 700,000 0 700,000 A hotel is not anticipated In the subject development Federal Grants 70,000 0 70,000 independent of subject development Transfer In - Prop CFund 9,000 0 9,000 Independent of subject development Transfer In - Int. Wast Mgt Fd 185,000 0 185,000 Independent of subject development Transfer In - COPS Fund 180,300 0 180,300 Independent of subject development Off Highway Tax 1,000 0 1,000 Independent of subject development Use of Money and Property 1,282,900 0 1,282,900 Independent of subject development Economic Dev. Fund Balance 715,850 0 715,850 Independent of subject development ERAF III State Takeaway 397475) 397475 Independent of subject development Subtotal 2,746,575 0 2,746,575 Total General Fund 20,244,610 3,544,285 16,700,325 Notes_ For funding City departmental services Source: Cilycf Diamoni Proposed Budget for the Fiscal Year 2006-2007. Prepared by: Keyser Marston Associates, Inc. Filenama: \\sf-fsl\Employee\jjohnston\work\fiscal-impact\DiamondBanDiamond Bar Fiscal 11.30.05,x1s', 12/5/2006; 12:12 PM; jj Appendix A - 2 SUMMARY OF GENERAL FUND BUDGET EXPENDITURES FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 LESS) NET GF EXP 2006-07 PROGRAM INCLUDED IN BUDGET REVENUE' ANALYSIS GENERALFUND Legislative City Council 171,600 0 171,600 City Attorney 165,000 0 165,000 City Manager/City Clerk 936,140 L0 936,140 Total 1,272,740 0 1,272,740 Administration and Support 3 290 t0 43,290 Finance 420,300 0 420,300 Human Resources 241,415 0 241,415 Information Systems 1,268,590 0 1,268,590 General Government 1,632,640 0 1,632,640 Public Information 577,790 0 577,790 Total 4,140,735 0 4,140,735 Public Safety I Police Law Enforcement 4,987,000 592,500) 4,394,500 Volunteer Patrol 9,250 0 9,250 Fire 40,900 25,000) 15,900 Animal Control 112,500 0 112,500 Emergency Preparedness4$ 3 290 t0 43,290 Total 5,192,940 617,500) 4,575,440 Community Development Community Dev./Planning 916,630 480,000) 436,630 Building & Safety 482,600 750,400) 267,800) Neighborhood Improvement 356,500 0 356,500 Economic Development71$ 5 850 0 715,850 Total 2,471,580 1,230,400) 1,241,180 Community Services Community Services Admin 470,760 0 470,760 Diamond Bar Center - Oyer. 884,730 0 884,730 Park Operations 730,510 0 730,510 Recreation 1,503,055 729,385) 773,670 Total 3,589,055 729,385) 2,859,670 Public Works Public Works - Admin 647,890 0 647,890 Engineering 316,150 967,000) 650,850) Road Maintenance 1,135,750 0 1,135,750 Landscape Maintenance34$ 1 820 0$341,820 Total 2,441,610 967,000) 1,474,610 Replacement Reserves & Insurance 343,350 0 343,350 transfer out) 19,452,010 3,544,285) 15,907,725 Notes; 1 Program revenue identified on Appendix Table A-1. Source: City of Diamond ear. Proposed Budget for the Fiscal Year 2006-2007 Prepared by: Keyser Marston Associates, Inc. Filenames\\sf-fsl\Employee\jjohnston\work\fiscal-impact\DiamondBar\Diamond Bar_ Fiscal 11.30.06.xts; 12/5/2006; 12:22 PM; E APPENDIX B: ASSESSED VALUATION ON 0 :a, [H X7:7_1 A a G'4mNlbil Appendix B - 1 ASSESSED VALUATION AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA VALUE TOTAL ASSESSED BASIS PER UNIT VALUE AT BUILDOUT MARKET RATE VALUE ADDED Single Family Detached 2,200 DU $1,110,000 ' $2,442,000,000 Single Family Attached 600 DU $720,000 ' $432,000,000 Total 2,800 $1,030,000 $2,874,000,000 AFFORDABLE VALUE ADDED Single Family Detached 0 DU $0 Single Family Attached 0 DU $00 Total $0 COMMERCIAL VALUE ADDED 2 Community Shopping Center 200,000 SF $210 2 $42,000,000 Notes: r Based on estimates from Aera 11,16.06. 2 Estimated based on Marshall and Swift Valuation Service, and land and site improvements value of $25 per sq. ft. Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\flscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls; B-1 value added; 12/5/2006; jj APPENDIX C: TAX RATES LWO] [I :/ I . [H C :13 A m p'amKITII Appendix C - 1 TAX RATIO DISTRIBUTION FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 TAX RATE AREA 10068' AGENCIES RATIO Los Angeles County General 0.248744616 LA County Accumulated Capital Outlay 0.000110142 LA County Library 0.022368177 Consolidated Fire Protection District of LA County 0.169363881 LA County Fire - FFW 0.006156475 County Lighting Maintenance District No. 10006 0.020156003 LA County Flood Control Dr. Imp. Dist. Maintenance 0.001643522 LA County Flood Control Maintenance 0.009300947 Greater LA County Vector Control 0.000354735 County Sanitary District No. 21 Operating 0.012213084 City of Diamond Bar Tax District #1 0.051917418 Three Valley Metropolitan Water District Original Area 0.004089167 Walnut Valley Water District 0.000725305 Walnut Valley Water District Imp. Dist. #3 0.006585074 Walnut Valley Water District Imp. Dist. #4 0.001599968 Educational Revenue Augmentation Fund 0.078135050 Educational Augmentation Fund Impound 0.133937622 County School Services 0.001366065 Children's Instil. Tuition Fund 0.002711165 Mt. San Antonio Community College 0.029260376 Mt. San Antonio Children's Center Fund 0.000282427 Walnut Valley Unified School District 0.190573308 County School Service Fund - Walnut Valley 0.007573791 Dev. Center Handicapped Minors - Walnut Valley 0.000831682 otal 1.000000000 Notes Tax rate area for Diamond Bar parcels neighboring Aera development. Source: Modified ATI Ratio Report FY 2006-07, Los Angeles County Auditor -Controller. Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjchnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls, C-1 tax rates; 12/5/2006; jj APPENDIX D: RETAIL EXPENDITURE ANALYSIS WORKING DRAFT 12/5/2006 Appendix D - 1 TAXABLE RETAIL SALES PER CAPITA FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY WORKING DRAFT 12/5/2006 CITY OF DIAMOND BAR, CA 2005 CITY OF of AERA COMMUNITY of DIAMOND BAR' Total AT BUILDOUT 2 Total Taxable Retail Sales ($000s) General Merchandise 23,581 8.2% 3,538 8.2% Apparel 941 0.3% 141 0.3% HF & A 1,828 0.6% 274 0.6% Grocery 15,207 5.3% 2,281 5.3% Restaurants & Bars 49,841 17.2% 7,478 17.2% Building Materials & Farm Implements 8,117 2.8% 1,218 2.8% Service Stations 87,243 30.2% 13,089 30.2% Other Retail Stores 102,405 35_4% 15,364 35.4% Total Taxable Retail Sales 289,163 100.0% 43,383 100.0% Population 3 59,722 8,960 Taxable Retail Sales per Capita 4,842 4,842 Notes: California Retail Survey, 2006 Edition. Distributed based on 2005 taxable retail sales per capita, and percent of spending per category. See Table 3 and 4. Prepared by Keyser Marston Associates, Inc. Filename; \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls, D-1; 12/5/2006; jj Appendix D - 2 TAXABLE RETAIL SALES IN COMMUNITY SHOPPING CENTER FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 RETAIL ESTIMATED PERCENT TAXABLE SQ.FT. 1 SALES PSF' TAXABLE' SALES ($000s) Aero Master Plan Retail In -Line Shops 72,000 220 90% 14,300 Supermarket 52,000 600 50% 15,600 Restaurants 16,000 400 100% 6,400 Cinema Food and Beverage 50,000 30 100% 1,500 Office (Second Floor) 10,000 0 0% 0 200,000 189 78% 37,800 Notes: Per Aera drawing 11.16.2006. 2 Per Dollars & Cents of Shopping Centers: 2004, Restaurant Industry Operations Report 2004, KMA experience in similar projects. Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls; D-2; 12/5/2006; jj Appendix D - 3 TAXABLE SALES ALLOCATED TO PROJECT FISCAL IMPACT ANALYSIS AERA MASTER PLAN COMMUNITY CITY OF DIAMOND BAR, CA WORKING DRAFT 12/5/2006 Taxable Sales Comparison Total Annual Sales Residents/Retail Sq. Ft. Per Resident/Retail Sq. Ft. Notes: See Table D - 1. 2 See Table D - 2. BASED ON NEW BASED ON RESIDENTS' NEW RETAIL' 43,383,000 8,960 res. 4,842/ es. 37,800,000 200,000 sf 189/sf Prepared by Keyser Marston Associates, Inc. Filename: \\sf-fs1\Employee\jjohnston\work\fiscal-impact\DiamondBar\Diamond Bar—Fiscal 11.30.06.xls; D-3; 12/5/2006, jj