Loading...
HomeMy WebLinkAboutL. Orchards Economic and Fiscal Impact Analysis, dated August 8, 2025, updated November 10, 2025HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 1 SUMMARY OF RESULTS ORCHARDS AT BISHOP RANCH ECONOMIC AND FISCAL IMPACT ANALYSIS AUGUST 8, 2025 UPDATED NOVEMBER 10, 2025 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 2 INTRODUCTION HR&A Advisors, Inc. (HR&A) is an industry-leading real estate, economic development and public policy consulting firm. For nearly 50 years, HR&A has provided a full range of pre-construction real estate advisory services, including market analysis, financial feasibility analysis, economic and fiscal impact analysis, and structuring of public-private financing agreements for some of the most complex mixed-use, neighborhood, downtown, campus, and regional development projects across North America and abroad. We understand the importance of linking private investment with public resources to support investor and community responsibilities and aspirations. Sunset Development (“Sunset” or the “Company”) is planning Orchards at Bishop Ranch, a mixed-use community on 92 acres (the “Project”) in the City of San Ramon (the “City” or “San Ramon”). The Project will offer up to 2,500 residential units consisting of various for-sale and rental products, 125,000 square feet of new retail at the base of new multifamily buildings, and open space amenities, including a 2.5-acre park, additional pocket parks, recreational facilities and pedestrian pathways. Construction is expected to begin in late 2026, with full build-out and stabilization by 2045. This briefing book reports analysis prepared by HR&A Advisors, Inc. on the Project’s economic impacts in the Contra Costa County economy and its fiscal impacts to San Ramon from 2026 to 2045, accounting for construction, initial home sales and rentals, and stabilized operations. WHO WE ARE STUDY PURPOSE HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 3 EXECUTIVE SUMMARY | Through 2045, the Project will generate approximately $2.1 billion in one-time and $358.2 million in annual economic activity to the Contra Costa economy and contribute approximately $4.4 million in cumulative net new revenue to San Ramon (all in 2025 $). NET FISCAL IMPACTS FROM OPERATIONS OVER PROJECT BUILD-OUT $4.4 million (2025 dollars) Revenues to the City of San Ramon resulting from Project operations between 2028-2045 (i.e., not including one-time revenues). ONE-TIME FISCAL IMPACTS $4.8 million (2025 dollars) Revenues to the City of San Ramon resulting from private construction spending. ECONOMIC IMPACTS FISCAL IMPACTS The Project will contribute to the Contra Costa County economy by adding new jobs and household spending, whose impacts will multiply throughout the economy. The Project will deliver important new revenue to the City of San Ramon through 2045 from applicable revenue sources, including transfer, property and sales tax, franchise fees and other revenues. RECURRING ECONOMIC IMPACTS FROM OPERATIONS $358.2 million (Annually, 2025 dollars) Economic output in Contra Costa resulting from ongoing Project operations at full build-out in 2045. ONE-TIME ECONOMIC IMPACTS $2.1 billion (2025 dollars) Economic output to the Contra Costa County resulting from private construction spending. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 4 ORCHARDS AT BISHOP RANCH MASTER PLAN | Sunset expects to complete the Project in phases between 2026 and 2045. For-sale residential will be completed and stabilized by 2030, mixed-use by 2034, and multifamily by 2045. Source: Sunset Development DEVELOPMENT PROGRAM 368 For-Sale Residential 1,465 Multifamily 619 Mixed-Use Residential 2,452 Total Residential Units (including 386 units below-market rate affordable) Neighborhood/For-Sale Residential District Multifamily District Mixed-Use District Orchards Park 2.5 acres HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 5 SUMMARY OF METHODOLOGICAL APPROACH This analysis quantifies the net economic impacts to the County and net fiscal impacts on the City's General Fund. Impacts from the existing commercial uses were deducted from gross Project impacts. Results focus on the “end state” scale of development, with phasing occurring according to market conditions and Sunset’s internal planning. The analysis does not look at spillover benefits from the Project on existing development, which will likely see property values increase and improved sales performance due to the Project’s new population and amenities. HR&A used IMPLAN for the economic impact analysis, which is an industry-standard input-output model used by leading public and private sector organizations across the United States. A custom spreadsheet model was developed to project tax revenues specific to the City. Economic and net fiscal results are shown in constant 2025 dollars;fiscal results are also shown in constant dollars (i.e., including inflation). For economic impacts, all inputs to the IMPLAN model were set to 2025 dollars (e.g., construction costs, anticipated household incomes) and were modeled at one point in time at full build- out. For fiscal impacts, 2025 dollars are calculated using a discount rate of 11.4% based on the weighted average cost of capital (WACC) for a set of major national homebuilders. Additional detail on the methodological approach is provided in Appendix A of this document. APPROACH HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 6 Assumptions were sourced primarily from Sunset (independently reviewed by HR&A), City of San Ramon, U.S. Census Bureau, and other third-party data sources. Where appropriate, HR&A made additional assumptions reflective of the market and Project characteristics. City service costs, tax rates, and tax formulas are from the FY 2025-26 San Ramon budget and are assumed to remain constant over the course of development (but subject to inflation adjustments). The costs of City services delivered to the Project are conservatively based on a per-capita cost accounting method that expresses Project residents and employees as “resident equivalents” based on the time they spend in the City to calculate average per-capita General Fund operating budgets of applicable City departments and certain other line items whose budgets tend to be affected by the Project’s new City population. The analysis is consistent with the tax sharing agreement between Contra Costa County and the City of San Ramon that governs the distribution of property taxes within Bishop Ranch. Accordingly, HR&A assumes 50 percent of new sales tax revenues from the Project’s retail operations would be debited from the City’s expected property tax general levy. The analysis assumes no major disruptive economic events to the Contra Costa economy over the course of Project development. Following City review of the initial draft fiscal analysis from August 2025, certain calculation adjustments are reflected in this updated version. Additional detail on assumptions for this analysis is also provided in Appendix A of this document. SUMMARY OF ASSUMPTIONS ASSUMPTIONS HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 7 ECONOMIC IMPACTS: SUMMARY | The Project is expected to generate almost 9,000 jobs and approximately $2.1 billion in one-time economic impacts and over 2,000 jobs and $358.2 million in ongoing economic impacts to Contra Costa County. ONE-TIME IMPACTS RECURRING IMPACTS Impacts to the Contra Costa County economy resulting from construction activities. Revenues to the Contra Costa County economy resulting for ongoing operations at full build-out in 2045. SUPPORTED EMPLOYMENT 8,976 jobs $860.4 million (2025 dollars) TOTAL ECONOMIC OUTPUT $2.1 billion (2025 dollars) EMPLOYEE COMPENSTATION Source: IMPLAN, HR&A SUPPORTED EMPLOYMENT 2,032 jobs $123.1 million (2025 dollars) TOTAL ECONOMIC OUTPUT $358.2 million (2025 dollars) EMPLOYEE COMPENSTATION Note: As a simplifying modeling assumption, we assumed that all new construction occurred in 2025 to report all economic impacts in 2025 dollars. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 8 Impact Category Employment Employee Compensation Total Economic Output Direct 6,083 $642,690,000 $1,467,230,000 Indirect 1,381 $114,060,000 $314,420,000 Induced 1,512 $103,690,000 $309,120,000 Total Impact 8,976 $860,430,000 $2,090,770,000 ECONOMIC IMPACTS: ONE-TIME | Project construction will contribute approximately $1.5 billion directly to the San Ramon economy, with a multiplier effect leading to an additional $623.5 million to the wider Contra Costa economy. ONE-TIME IMPACT SUMMARYInducedIndirect INDIRECT INDUCED DIRECT effects are from spending associated with Project construction. These effects occur primarily at the site, within the City of San Ramon. INDIRECT effects are from spending by businesses supplying construction-related goods and services. INDUCED effects from household spending due to income received from direct and indirect activities. DIRECT Source: IMPLAN, HR&A MU L T I P L I E R EF F E C T HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 9 ECONOMIC IMPACTS: RECURRING | At build-out, Project operations will contribute approximately $358.2 million of economic output to the Contra Costa economy. Source: IMPLAN, HR&A InducedIndirect INDIRECT INDUCED DIRECT effects are from spending immediately associated with annual retail operations and property management. INDIRECT effects are from spending by businesses supplying goods and services to building operations and retail tenants. INDUCED effects from household spending by direct and indirect workers and new Project households. DIRECT MU L T I P L I E R EF F E C T Impact Category Employment Employee Compensation Total Economic Output Direct 605 $23,300,000 $64,260,000 Indirect 100 $8,670,000 $22,330,000 Induced 1,327 $91,100,000 $271,580,000 Total Impact 2,032 $123,080,000 $358,180,000 SUMMARY OF RECURRING IMPACTS IN 2045 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 10 FISCAL IMPACTS: SUMMARY | By 2045, the Project will have generated $4.8 million in one-time revenues and $4.4 million in revenues from annual operations to San Ramon, for a combined total of $9.2 million (all in 2025 $). ONE-TIME IMPACTS RECURRING IMPACTS Impacts to the City of San Ramon resulting from construction activities. Net revenues to the City of San Ramon resulting from annual operations through 2045. IMPACT THROUGH 2045 Source: HR&A Note: 2025 dollars calculated using a discount rate of 11.4% based on the weighted average cost of capital (WACC) for a set of major national homebuilders. IMPACT THROUGH 2045 ANNUAL IMPACT AT FULL BUILD-OUT$0.09 million (2025 dollars, in 2045)$0.89 million (nominal dollars, in 2045) $4.4 million (2025 dollars) $14.2 million (nominal dollars) $4.8 million (2025 dollars) $9.7 million (nominal dollars) HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 11 Category Nominal $2025 $ Construction Property Tax $1,376,000 $648,000 Construction MVLF In Lieu $319,000 $150,000 Construction Materials Sales Tax $6,917,000 $3,365,000 Documentary Transfer Tax (Initial Sales)$1,042,000 $658,000 Net Fiscal Impact $9,654,000 $4,822,000 FISCAL IMPACTS: ONE-TIME | 70 percent of one-time fiscal revenues to San Ramon will come from sales tax on construction materials. Source: HR&A DISTRIBUTION OF ONE-TIME FISCAL REVENUES FROM CONSTRUCTION 2026-2045 GENERAL FUND FISCAL REVENUES RE V E N U E S T H R O U G H 2 0 4 5 Note: Construction sales tax revenues from building materials assume proper registration of the construction site with the California Department of Tax and Fee Administration. Motor Vehicle in Lieu Fee (“MVLF”) is an additional property tax provided by the State to communities following the elimination of local receipt of Motor Vehicle License Fees in 2005. Property Tax 13% MVLF 3% Sales Tax 70% Documentary Transfer Tax 14% HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 12 Category Nominal $2025 $ Property Tax $41,651,000 $10,657,000 MVLF In Lieu $9,682,000 $2,477,000 Documentary Transfer Tax (Ongoing Turnover)$2,891,000 $638,000 Franchise Tax $2,998,000 $734,000 Sales Tax (Ongoing)$31,762,000 $9,460,000 Licenses, Permits, Fees & Fines $13,155,000 $3,173,000 Total Revenues $102,139,000 $27,140,000 Less: Existing Prop. Tax & MVLF ($5,567,000)($2,010,000) Less: City Service Costs ($66,404,000)($16,021,000) Less: Sales Tax Reduction for City-County Tax Sharing Agreement ($15,881,000)($4,730,000) Net Fiscal Impact $14,297,000 $4,378,000 FISCAL IMPACTS: RECURRING| Over the duration of Project operations (but not including one-time revenues), property and sales taxes will combine for 74 percent of new General Fund revenues to San Ramon. Source: HR&A DISTRIBUTION OF CITY REVENUES FROM OPERATIONS 2028-2045 GENERAL FUND FISCAL REVENUES RE V E N U E S T H R O U G H 2 0 4 5 (O v e r A n a l y s i s P e r i o d ) Note: Property Tax and MVLF in Lieu include property tax turnover, assuming ten percent of homes are re-sold each year, resetting these taxes for those homes based on their resale price. One-free-standing, deed-restricted affordable housing building may be eligible for the Welfare Exemption from ad valorem property tax, which is not reflected in this analysis, because the calculation depends on building specifics which are not yet available. Sales Tax 35% Property Tax 39% Licenses, Permits, Fees & Fines 12% MVLF In Lieu 9% Franchise Tax 3% Documentary Transfer Tax 2% HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 13 Category Nominal $2025 $ Property Tax $4,240,000 $436,000 MVLF In Lieu $985,000 $101,000 Documentary Transfer Tax (Ongoing Turnover)$360,000 $37,000 Franchise Tax $308,000 $32,000 Sales Tax (Ongoing)$2,103,000 $216,000 Licenses, Permits, Fees & Fines $1,414,000 $145,000 Total Revenues $9,408,000 $967,000 Less: Existing Prop. Tax & MVLF ($333,000)($34,000) Less: City Service Costs ($7,135,000)($734,000) Less: Sales Tax Reduction for City-County Tax Sharing Agreement ($1,052,000)($108,000) Net Fiscal Impact $887,000 $91,000 FISCAL IMPACTS: RECURRING| At full build-out, property and sales taxes will combine for just over two-thirds of new General Fund revenues from Project annual operations to San Ramon. Source: HR&A DISTRIBUTION OF CITY REVENUES FROM OPERATIONS IN 2045 GENERAL FUND FISCAL REVENUES RE V E N U E S I N 2 0 4 5 (F u l l B u i l d -Ou t ) Note: Property Tax and MVLF in Lieu include property tax turnover, assuming ten percent of homes are re-sold each year, resetting these taxes for those homes based on their resale price. One-free-standing, deed-restricted affordable housing building may be eligible for the Welfare Exemption from ad valorem property tax, which is not reflected in this analysis, because the calculation depends on building specifics which are not yet available. Sales Tax 22% Property Tax 45% Licenses, Permits, Fees & Fines15% MVLF In Lieu 11% Franchise Tax 3% Documentary Transfer Tax 4% HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 14 GENERAL AND LIMITING CONDITIONS 1.Any person who relies on or otherwise uses this Study is required to have first read, understood and accepted the following disclosures, limitations and disclaimers, and will, by reason of such reliance or other use, be deemed to have read, understood and accepted the same. 2.HR&A Advisors, Inc. (HR&A) has been engaged and compensated by Sunset Development Company to prepare this Study. In preparing this Study, HR&A has used its independent professional judgment and skills in good faith, subject to the limitations, disclosures and disclaimers herein. 3.This Study is based on estimates, assumptions and other information developed by HR&A, other third-party consultants, and city officials. Every reasonable effort has been made to ensure that the data contained in this Study are accurate as of the date of this Study; however, factors exist that are outside the control of HR&A and that may affect the estimates and/or projections noted herein. HR&A neither guarantees any results nor takes responsibility for their actual achievement or continuing applicability, as actual outcomes will depend on future events and circumstances beyond HR&A’s control. 4.HR&A reviewed the information and projections provided by third parties using its independent professional judgment and skills in good faith, but assumes no liability resulting from errors, omissions or any other inaccuracies with respect to the information provided by such third parties referenced in this Study. 5.HR&A also relied on data provided by or purchased from the U.S. Census, American Community Survey, Minnesota IMPLAN Group (MIG), CoStar Group, and discussion with staff at Sunset Development Company. HR&A assumes no liability resulting from errors, omissions, or any other inaccuracies with respect to the information provided by these parties. 6.In addition to relying on data, information, projections, and forecasts of others as referred to above, HR&A has included in this Study estimates and assumptions made by HR&A that HR&A believes are appropriate, but HR&A makes no representation that there will be no variances between actual outcomes and such estimates and assumptions. 7.No summary or abstract of this Study, and no excerpts from this Study, may be made for any purpose without HR&A’s prior written consent. 8.HR&A has provided estimates of potential property tax impacts in San Ramon based on our experience and familiarity with national best practices for tax assessments of income-producing properties. HR&A is not a licensed real estate appraiser and makes no further representations regarding such estimates. 9.No opinion is intended to be expressed, and no responsibility is assumed for any matters that are legal in nature or require legal expertise or specialized knowledge beyond that of a real estate consultant. 10.Many of the figures presented in this report will be rounded. HR&A disclaims any and all liability relating to rounding errors. 11.This Study may be relied on and otherwise used only by persons who receive this Study from HR&A or with HR&A’s prior written consent and only for the purpose stated in writing in conjunction with such receipt or consent. No reliance on or other use of this Study by any person or for any purpose other than as stated in the previous sentence is permitted. HR&A disclaims all responsibility in the case of any reliance on or other use of this Study in conflict with the above portions of this paragraph. 12.If the Study is referred to or included in any offering material or prospectus, the Study shall be deemed to have been included for informational purposes only and its use shall be subject to these General and Limiting Conditions. HR&A, its directors, officers and employees have no liability to recipients of any such offering material or prospectus. HR&A disclaims any and all liability to any party. 13.This Study is qualified in its entirety by, and should be considered in light of these General and Limiting Conditions. By use of this Study, each party that uses this Study agrees to be bound by all of the General and Limiting Conditions stated herein. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 15 APPENDIX A HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 16 Appendix Guide Appendix A is divided into two sections, one each for the Economic Impacts and Fiscal Impacts analyses. Within each section, additional detail is provided on the approach and assumptions used for that analysis. Each section also contains tables of supporting calculation detail for the results presented in this analysis. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 17 Economic Impacts Methodology, Assumptions, and Summary Tables HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 18 Economic Impact Methodology HR&A’s economic impact analysis considers the one-time impact of Project construction and the ongoing impact from Project operations each year. Economic inputs include direct, indirect, induced, and total effects, as explained below. Induced Indirect Direct Initial change in spending or employment attributable to new investment (e.g., construction of new market rate and affordable homes). Change in spending or employment by businesses that supply goods and services to the directly affected industry (e.g., construction material suppliers). Change in household spending of employees who are compensated for working in the directly and indirectly affected industry sectors (e.g., food and beverage spending by construction workers). Also includes household spending by households in new residential development. Multiplier Impacts HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 19 10M SF Known Pipeline HR&A used IMPLAN to estimate the economic impacts of the development and operation of the Project on the local economy. IMPLAN, created by IMPLAN Group, LLC (formerly MIG, Inc. and the Minnesota IMPLAN Group, Inc.), is an industry standard input-output model used to conduct economic impact analyses by leading public and private sector organizations across the United States. It also has been used to monitor job creation for a range of Federal government initiatives, including the economic impacts of the American Recovery and Reinvestment Act of 2009 on state economies. HR&A conducted its analysis using the IMPLAN input-output model for the Contra Costa County economy. IMPLAN analysis traces the pattern of commodity purchases and sales between industries that are associated with each dollar’s worth of a product or service sold to a customer, analyzing interactions among 528 industry sectors. The model makes adjustments to exclude spending that takes place outside of the study area. The model relies on data about the Contra Costa County economy as of 2023 (latest available). In addition to overall economic output, the IMPLAN input-output model also produces estimates of the number of jobs supported and worker compensation. It includes wage and salary income plus benefits and employer paid taxes, in addition to income earned by independent proprietors. The estimates of jobs and labor income are based on the Bureau of Labor Statistics’ Quarterly Census of Employment and Wages (QCEW), data from the Census Bureau’s County Business Patterns data, and data from the U.S. Bureau of Economic Analysis Regional Economic and Product Accounts. A full description of IMPLAN and its data methods and sources can be found at www.implan.com. Economic Impact Methodology HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 20 10M SF Known Pipeline Economic Impact Methodology One-Time Economic Impacts in Contra Cosa County from Construction of the Orchards at Bishop Ranch Category Direct Indirect Induced Total Output 1. For-Sale Residential $315,080,483 $64,584,598 $71,139,499 $450,804,580 2. Multifamily $779,627,996 $169,318,821 $161,748,518 $1,110,695,335 3. Mixed $372,521,478 $80,516,900 $76,232,268 $529,270,646 Total $1,467,229,957 $314,420,320 $309,120,285 $2,090,770,561 Employment 1. For-Sale Residential 1,451 277 348 2,076 2. Multifamily 3,138 750 791 4,679 3. Mixed 1,494 354 373 2,220 Total 6,083 1,381 1,512 8,976 Labor Income 1. For-Sale Residential $151,380,470 $22,889,435 $23,862,575 $198,132,481 2. Multifamily $333,791,739 $62,034,137 $54,256,002 $450,081,877 3. Mixed $157,514,606 $29,133,850 $25,570,888 $212,219,344 Total $642,686,816 $114,057,422 $103,689,466 $860,433,703 Source(s): Sunset Development; IMPLAN; HR&A HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 21 10M SF Known Pipeline Economic Impact Methodology Ongoing Economic Impacts in Contra Cosa County from Construction of the Orchards at Bishop Ranch Category Direct Indirect Induced Total Output 1. For-Sale Residential --$51,696,619 $51,696,619 2. Multifamily $10,479,131 $4,690,465 $146,146,008 $161,315,604 3. Mixed $53,778,863 $17,642,956 $73,741,013 $145,162,833 Total $64,257,994 $22,333,421 $271,583,641 $358,175,056 Employment 1. For-Sale Residential --258 258 2. Multifamily 42 21 710 773 3. Mixed 563 79 359 1,001 Total 605 100 1,327 2,032 Labor Income 1. For-Sale Residential --$17,332,911 $17,332,911 2. Multifamily $3,113,276 $1,654,569 $49,042,929 $53,810,774 3. Mixed $20,190,144 $7,019,654 $24,724,253 $51,934,051 Total $23,303,420 $8,674,223 $91,100,093 $123,077,737 Source(s): Sunset Development; IMPLAN; HR&A HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 22 10M SF Known Pipeline Economic Impact Methodology Construction Cost Allocation Cost Categories Estimated Construction Cost (2025 $)Modelable?Estimated Costs for IMPLAN IMPLAN Sector #IMPLAN Sector Component For-Sale Residential Hard Costs $199,550,000 100%$199,550,000 52 Construction of new Single-Family residential structures Soft Costs $61,516,000 100%$61,516,000 439 Architectural, engineering, and related services Fee Costs $42,734,000 0%$0 Land Costs $193,300,000 0%$0 Demolition Costs - Infrastructure $4,522,183 100%$4,522,183 55 Maintenance and repair construction of nonresidential structures Hard Costs - Infrastructure $46,236,228 100%$46,236,228 49 Construction of new highways and streets Soft Costs - Infrastructure $3,256,072 100%$3,256,072 439 Architectural, engineering, and related services Property Taxes - Infrastructure $1,139,625 0%$0 0 0 0 Multifamily (Not Mixed-Use)0 0 0 Hard Costs $549,375,000 100%$549,375,000 53 Construction of new multifamily residential structures Soft Costs $201,975,000 100%$201,975,000 439 Architectural, engineering, and related services Fee Costs $91,025,000 0%$0 Land Costs $134,500,000 0%$0 Demolition Costs - Infrastructure $2,367,481 100%$2,367,481 55 Maintenance and repair construction of nonresidential structures Hard Costs - Infrastructure $24,205,876 100%$24,205,876 49 Construction of new highways and streets Soft Costs - Infrastructure $1,704,639 100%$1,704,639 439 Architectural, engineering, and related services Property Taxes - Infrastructure $596,624 0%$0 - 0 0 0 Mixed-Use $0 0 0 Hard Costs $263,075,000 100%$263,075,000 53 Construction of new multifamily residential structures Soft Costs $83,565,000 100%$83,565,000 439 Architectural, engineering, and related services Fee Costs $40,235,000 0%$0 Land Costs $61,900,000 0%$0 Tenant Improvement Costs $8,640,882 100%$8,640,882 55 Maintenance and repair construction of nonresidential structures Demolition Costs - Infrastructure $1,443,412 100%$1,443,412 55 Maintenance and repair construction of nonresidential structures Hard Costs - Infrastructure $14,757,897 100%$14,757,897 49 Construction of new highways and streets Soft Costs - Infrastructure $1,039,288 100%$1,039,288 439 Architectural, engineering, and related services Property Taxes – Infrastructure $363,751 0%$0 Total $2,033,023,958 -$1,467,229,958 Source(s): Sunset Development HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 23 10M SF Known Pipeline Economic Impact Methodology Retail Program Modeling Inputs Category Category % of Program Leasable SF Sales PSF Total Sales Vacancy Adjusted Sales IMPLAN Sector #IMPLAN Sector Grocery Grocery 17%20,839 $1,000 $20,838,546 $19,129,785 381 Wholesale - Grocery and related product wholesalers Full-Service Restaurant Food 12%14,467 $922 $13,345,114 $12,250,815 491 Full-service restaurants Fine Fast Casual Food 8%9,645 $1,127 $10,870,492 $9,979,112 492 Limited-service restaurants Walk-Up (coffee, juice, etc)Food 6%7,307 $986 $7,203,482 $6,612,797 493 All other food and drinking places Health and Convenience Retail (Goods)9%10,850 $1,015 $11,007,768 $10,105,131 380 Wholesale - Drugs and druggists’ sundries Health and Beauty Retail (Goods)5%6,028 $423 $2,547,737 $2,338,822 380 Wholesale - Drugs and druggists’ sundries Misc Retail Retail (Goods)20%24,112 $214 $5,153,449 $4,730,867 394 Retail - General merchandise stores Jeweler Retail (Goods)3%3,617 $1,886 $6,821,879 $6,262,485 395 Retail - Miscellaneous store retailers Hardware Store Retail (Goods)2%2,411 $412 $992,468 $911,086 388 Retail - Building material and garden equipment and supplies stores Apparel Retail (Goods)3%3,200 $1,127 $3,607,718 $3,311,885 392 Retail - Clothing and clothing accessories stores Boutique Fitness Retail (Services)8%9,645 $936 $9,031,084 $8,290,535 487 Fitness and recreational sports centers Laundromat Retail (Services)5%6,028 $57 $341,122 $313,150 501 Dry-cleaning and laundry services Hair Salon Retail (Services)2%2,411 $613 $1,478,194 $1,356,982 499 Personal care services Overall 100%120,560 $773 $93,239,054 $85,593,451 Source(s): Sunset Development; Retail Maxim (2021); HR&A HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 24 10M SF Known Pipeline Economic Impact Methodology Housing Program Modeling Inputs Project Component IMPLAN Sector Inputs For-Sale Residential 10009 - Households GT200k $121,568,146 Multifamily 10008 - Households 150-200k $212,229,921 Multifamily 10007 - Households 100-150k $9,431,468 Multifamily 10006 - Households 70-100k $9,737,398 Multifamily 10005 - Households 50-70k $6,094,667 Mixed 10008 - Households 150-200k $97,629,413 Mixed 10007 - Households 100-150k $4,352,985 Mixed 10005 - Households 50-70k $2,782,348 Total $463,826,346 Source(s): HR&A Advisors HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 25 10M SF Known Pipeline Economic Impact Methodology Multifamily On-Site FTEs Project Component IMPLAN Sector #IMPLAN Sector FTEs Multifamily 429 Other real estate 42 Mixed-Use (Multifamily/Retail)429 Other real estate 16 Source(s): Sunset Development HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 26 10M SF Known Pipeline Economic Impact Methodology Household Size to Bedroom Count Conversion Household Size Bed Room Count 1 person Studio 2 person 1-Bed 3 person 2-Bed 4 person 3-Bed 6 person 4-Bed Source(s): HCD HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 27 10M SF Known Pipeline Economic Impact Methodology 2025 Maximum Qualifying Annual Income Levels for San Ramon by Household Size (Inclusionary) Income Category 1 Person 2 Persons 3 Persons 4 Persons 5 Persons 6 Persons 7 Persons 8 Persons Acutely Low $16,750 $19,150 $21,550 $23,950 $25,850 $27,800 $29,700 $31,600 Extremely Low (30% AMI)$33,600 $38,400 $43,200 $47,950 $51,800 $55,650 $59,500 $63,300 Very Low Income (50% AMI)$55,950 $63,950 $71,950 $79,900 $86,300 $92,700 $99,100 $105,500 Low Income (80% AMI)$87,550 $100,050 $112,550 $125,050 $135,100 $145,100 $155,100 $165,100 Median Income $111,850 $127,850 $143,800 $159,800 $172,600 $185,350 $198,150 $210,950 Moderate Income (120% AMI)$134,250 $153,400 $172,600 $191,750 $207,100 $222,450 $237,750 $253,100 Source(s): HCD HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 28 10M SF Known Pipeline Economic Impact Methodology Inclusionary Rents and Average Household Income Category Unit Distribution Unit Mix 50% AMI Units (Half of Units) 80% AMI Units (Half of Units) Max Monthly Rent per Unit (50% AMI) Max Monthly Rent per Unit (80% AMI) Total Annual Rent Revenue Assumptions Studio 10%27 13.4 13.4 $1,399 $2,189 $575,148 1 Bedroom 40%107 53.4 53.4 $1,599 $2,501 $2,629,248 2 Bedroom 40%107 53.4 53.4 $1,799 $2,814 $2,957,904 3 Bedroom 10%27 13.4 13.4 $1,998 $3,126 $821,440 Total 100%267 133.6 133.6 $6,983,740 Weighted Average Household Income $ 67,945 $ 106,300 Source: HCD HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 29 10M SF Known Pipeline Economic Impact Methodology 2025 MSTP Income and Rent Limits and Average Household Income (LIHTC) Category Income Limits (60% AMI) Rent Limit (60% AMI)Unit Distribution Unit Mix Total Annual Rent Revenue Assumptions 1 bedroom $76,740 $1,798 50%60 $1,283,772 2 bedroom $86,340 $2,158 25%30 $770,406 3 bedroom $95,880 $2,493 25%30 $890,001 Total 100%119 $2,944,179 Weighted Average Household Income $83,925 Source: HCD HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 30 10M SF Known Pipeline Economic Impact Methodology Housing Income Calculation Category Townhome Row House Detached Court Multifamily - Market Rate Multifamily (Inclusionary - 80% AMI) Multifamily (Inclusionary - 50% AMI) Multifamily (LIHTC)Total Total Units 138 58 130 42 1,698 133 134 119 2,452 For-Sale Only Estimated Sales Price $1,250,000 $1,650,000 $1,900,000 $2,500,000 ---- Down Payment (20%)$250,000 $330,000 $380,000 $500,000 ---- Loan Amount $1,000,000 $1,320,000 $1,520,000 $2,000,000 ---- Interest Rate 6.6%6.6%6.6%6.6%---- Term (Years)30 30 30 30 ---- Monthly Mortgage $6,378 $6,378 $6,378 $6,378 ---- Property Tax (1.14%)$1,187 $1,187 $1,187 $1,187 ---- Homeowner's Insurance $347 $458 $527 $694 ---- Maintenance (1% of home value)$1,042 $1,042 $1,042 $1,042 ---- Household Income Estimate Average Monthly Mortgage or Rent $8,954 $9,065 $9,134 $9,301 $4,200 $2,658 $1,699 $2,098 Average Annual Mortgage or Rent $107,445 $108,777 $109,610 $111,608 $50,398 --- Average Annual Utility Cost $6,727 $6,727 $6,727 $6,727 $5,983 --- Total Annual Housing Cost $114,172 $115,504 $116,337 $118,335 $56,381 $31,890 $20,384 $25,178 Housing Cost as a Share of Household Income 35.0%35.0%35.0%35.0%30.0%30.0%30.0%30.0% Required Gross Household Income $326,206 $330,012 $332,391 $338,099 $187,935 $106,300 $67,945 $83,925 Total Project Gross Household Income $45,016,484 $19,140,703 $43,210,790 $14,200,169 $319,113,630 $14,137,900 $9,104,630 $9,987,075 $473,911,381 Estimated Vacancy Rate 0.0%0.0%0.0%0.0%2.9%2.5%2.5%2.5% Total Income from Occupied Units $45,016,484 $19,140,703 $43,210,790 $14,200,169 $309,859,334 $13,784,453 $8,877,015 $9,737,398 $463,826,346 IMPLAN Income Band 10009 - Households GT200k 10009 - Households GT200k 10009 - Households GT200k 10009 - Households GT200k 10008 - Households 150-200k 10007 - Households 100-150k 10005 - Households 50-70k 10006 - Households 70-100k Source(s): Sunset Development Company; US BLS Consumer Expenditure Survey; HCD; CoStar; HR&A Advisors HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 31 Fiscal Impacts Methodology, Assumptions, and Summary Tables HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 32 10M SF Known Pipeline To construct the fiscal impact analysis model for the Project, HR&A used public and proprietary third-party data to estimate certain real estate metrics, City municipal code requirements, and City budget data to identify tax revenues and tax formulas applicable to the Project, and industry-standard tax revenue and municipal services cost analysis approaches. Sunset provided HR&A with certain assumptions about the Project including the scale of Project components, phasing, and estimates of sale prices and rents and for each category of new housing and an illustrative retail program and pricing for the completed Project. HR&A quantified both one-time construction-rated impacts and recurring fiscal impacts to the General Fund for the City of San Ramon. One-time impacts include tax revenues resulting from property tax revenues on in-progress construction, initial real estate transfer tax on home sales, and the City’s share of sales tax on construction materials (assuming the construction site is properly registered by the contractors with the State of California for this purpose). The construction tax revenue estimates do not include any planning fees, construction permits, developer fees, or mitigation fee charges because these charges are generally set at rates intended to directly offset City costs and, therefore, do not represent net new revenues that can be used to fund other City expenditures. Recurring fiscal impacts refer to City revenues and costs that occur on an annual basis as the Project is completed in phases, leased, and stabilized. Estimated recurring Project revenues are based on current City tax rates and tax formulas, which are assumed to remain unchanged (except for the sales tax reversion to 1% in 2035) over the 2026-2045 projection period (i.e., incremental phased completion plus two years for stabilized operation of the last phase), and HR&A analysis. The estimated costs to deliver City services to the Project are based on a per-capita cost accounting method that first expresses the total number of residents and employees working in the City as “resident equivalents” (based on the time they spend in the City) and then calculates average per-capita General Fund operating expenditures for City departments and certain other line items whose budgets are affected by new development. The difference between total Project revenues and estimated City services costs, less current property tax revenues and tax sharing agreement adjustments (see pg. 34), yields the net fiscal impact of the Project. Results are shown in constant 2025-dollars unless otherwise specified, using a discount rate of 11.4% which is the weighted average cost of capital for a set of major national homebuilders. Fiscal Impact Methodology HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 33 10M SF Known Pipeline Descriptions of key revenue sources for the City of San Ramon’s General Fund are as follows: Sales Tax. The State Department of Tax and Fee Administration allocates one percent of local sales tax revenue back to the City for general purposes. Additionally, in November 2024 voters approved Measure N, which increased the City’s sales tax rate by one percent through 2034, unless extended by the voters, which extension is not assumed in this analysis. HR&A’s analysis includes sales tax generated from direct retail sales, spending by Project households in San Ramon, and designated construction materials. Property Tax. The property tax applicable to the Project site includes a one percent general levy on the assessed value of land and buildings, which is distributed among different local taxing entity accounts including the City. As each Project phase is completed, assessed value is based on the weighted average sales price for homes sold in that phase. Thereafter, assessed value of those homes is increased by two percent annually in accordance with Proposition 13. The analysis assumes that 3.5 percent of detached single family and 7.5 percent of attached single family homes in each phase are re-sold each year, which resets the property tax for those homes based on their resale price, which in turn assumes annual appreciation above the original sale price. Property Tax In Lieu of Motor Vehicle License Fees. This additional property tax revenue is provided by the State to communities following the elimination of local receipt of Motor Vehicle License Fees in 2005. The motor vehicle in lieu fee (MVLF) amount is set by the State based on the total assessed value of land and buildings in a given municipality each year. HR&A calculates MLVF based on the ratio of MVLF in FY 2024 and assessed value in FY 2024. This tax revenue calculation is also derived from assessed value, and hence it is based on the same per-phase weighted average sales price of homes sold each year, including resales. Documentary Transfer Tax. The City collects a transfer tax on every real estate transaction. HR&A applies this tax to each unit subject to initial sale and annual re-sale based on its sale price in that year. Franchise Tax. A franchise fee is imposed on various utilities, which permits them to use and operate facilities within the City. The fee is based on the gross income derived by each utility from charges to new Project businesses and households. This tax is applied as each building and phase is completed. Operating Transfers In and Out. At the City’s request, HR&A subsequently added cost factors for citywide insurance and for infrastructure maintenance and replacement. Fiscal Impact Methodology HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 34 10M SF Known Pipeline The following methodological component warrant further clarification: Open Space Maintenance: Modeling assumes Sunset Development will develop and maintain the central park and trails system as part of the Project, avoiding increased services costs for the City. The fiscal model, however, still accounts for increased expenses for the Parks and Community Services Department which might be overstated given the current plans for maintenance. Tax Sharing Agreement: Given the Project’s location in Bishop Ranch, a 585-acre area annexed into the City in 1987, the Project is subject to the Master Property Tax Exchange Agreement for Allocation of Property Tax (Master Agreement) between the County and City. Under the latest version of the Master Agreement adopted on June 14, 2016, property tax revenue allocation to the City for parcels within Bishop Ranch is reduced by 50 percent of the total sales tax and transient occupancy taxes collected in the Bishop Ranch area. To account for the impact of the Master Agreement on the Project, net fiscal impacts were reduced by 50 percent of the sales tax revenues anticipated from ongoing operations of the retail component of the Project. Property Turnover: HR&A did not consider the sale or resale of apartment buildings. Inclusion of turnover for apartment buildings would increase the property tax projections for the multifamily and mixed-use components of the Project. Rental Units vs. Condominiums: Our estimate of City revenues from multifamily residential units assumes all units will be rentals. If some share of the units are eventually developed as condominium units, City revenues and net fiscal impact from those units and the Project overall would likely be greater, due to (1) higher assessed building values and hence more local property tax revenue; (2) higher household incomes generating more household spending subject to local sales tax; (3) additional local real estate transfer tax revenue from periodic condo re-sales; and (4) no material difference in allocated City operating costs Welfare Exemption: HR&A did not apply any welfare exemption sometimes accorded to affordable housing complexes that are owned by non-profits. Most below market units (15% of total) will be built as inclusionary units within Sunset’s planned residential developments and therefore would not be eligible for this exemption. For the one free-standing affordable component (120 units as part of the multifamily district), the ownership structure has yet to be determined. Fiscal Impact Methodology HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 35 Fiscal Impact Methodology Net Fiscal Revenue Impact Summary for the Construction and Annual Operations of the Proposed Project Full Build-Out (2045) Over Analysis Period (2026-2045) One-Time Revenues to the City of San Ramon General Fund Nominal $2025 $1 Nominal $2025 $1 Construction Property Tax $157,880 $1,376,022 $648,067 Construction MVLF In Lieu $319,246 $150,356 Construction Materials Sales Tax $18,930 $6,917,087 $3,365,045 Documentary Transfer Tax (Initial Sale)$1,041,883 $658,335 Total One-Time Revenues to the City of San Ramon General Fund $334,689 $9,654,238 $4,821,802 Annual Revenues to the City of San Ramon General Fund Property Tax $4,238,212 $435,832 $41,651,473 $10,655,780 MVLF In Lieu $984,642 $101,255 $9,682,108 $2,477,435 Documentary Transfer Tax (Ongoing Turnover)$359,715 $36,991 $2,829,116 $639,752 Franchise Tax $307,886 $31,661 $2,997,620 $734,413 Sales Tax (Ongoing)$2,103,142 $216,275 $31,762,051 $9,460,036 Licenses, Permits, Fees and Fines $1,413,873 $145,394 $13,155,210 $3,173,108 Total Annual Recurring Revenues to City's General Fund $9,407,470 $967,408 $102,077,579 $27,140,524 Total General Fund Revenue (One-Time + Annual Recurring)$9,407,470 $967,408 $111,731,817 $31,962,326 Less: Property Tax and MVLF Revenue from Existing Site ($333,156)($34,260)($5,556,533)($2,010,021) Less: City Service Costs ($7,134,853)($733,706)($66,403,758)($16,021,374) Less: Sales Tax Reduction for City-County Tax Sharing Agreement ($1,051,571)($108,137)($15,881,025)($4,730,018) Net Fiscal Impact to City’s General Fund $887,889 $91,305 $23,890,502 $9,200,914 1 Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders, sourced from GuruFocus. Prepared by: HR&A Advisors, Inc. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 36 Fiscal Impact Methodology Net Fiscal and Other Revenue Impacts from Annual Operations to the City of San Ramon – Year 2045 (Complete Build-Out) – Nominal Year 2045 (Complete Build Out) - Nominal Annual Revenues to the City of San Ramon General Fund Total For-Sale Residential Multifamily (Single-Use)Multifamily (Mixed-Use)Other¹ Property Tax $4,238,212 $2,611,660 $1,153,588 $472,963 $0 MVLF In Lieu $984,642 $605,923 $268,988 $109,731 $0 Documentary Transfer Tax $359,715 $359,715 $0 $0 $0 Franchise Tax $307,886 $38,711 $154,108 $115,067 $0 Sales Tax (Ongoing)$2,103,142 $247,887 $566,510 $1,288,745 $0 Licenses, Permits, Fees and Fines $1,413,873 $210,703 $820,327 $382,844 $0 Total Annual Revenues to City's General Fund $9,407,470 $4,074,599 $2,963,521 $2,369,350 $0 Less: Property Tax and MVLF Revenue from Existing Site ($333,156) Less: City Service Costs ($7,134,853)($1,019,721)($4,169,105)($1,946,027)$0 Less: Sales Tax Reduction for City-County Tax Sharing Agreement ($1,051,571) Net Fiscal Impact to City's General Fund $887,889 $3,054,877 ($1,205,585)$423,324 $0 1Other category includes any horizontal infrastructure not easily assigned to a vertical project component (i.e., demolition/abatement of current office complex, parks and open space). Prepared by: HR&A Advisors, Inc. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 37 Fiscal Impact Methodology Net Fiscal and Other Revenue Impacts from Annual Operations to the City of San Ramon -- Year 2045 (Complete Build-Out) – NPV Year 2045 (Complete Build Out) – NPV Annual Revenues to the City of San Ramon General Fund Total For-Sale Residential Multifamily (Single-Use)Multifamily (Mixed-Use)Other¹ Property Tax $435,832 $268,568 $118,628 $48,637 $0 MVLF In Lieu $101,255 $62,310 $27,661 $11,284 $0 Documentary Transfer Tax (Ongoing Turnover)$36,991 $36,991 $0 $0 $0 Franchise Tax $31,661 $3,981 $15,848 $11,833 $0 Sales Tax (Ongoing)$216,275 $25,491 $58,256 $132,527 $0 Licenses, Permits, Fees and Fines $145,394 $21,667 $84,357 $39,369 $0 Total Annual Revenues to City's General Fund $967,408 $419,007 $304,751 $243,650 $0 Less: Property Tax and MVLF Revenue from Existing Site ($34,260) Less: City Service Costs ($733,706)($104,862)($428,726)($200,118)$0 Less: Sales Tax Reduction for City-County Tax Sharing Agreement ($108,137) Net Fiscal Impact to City's General Fund $91,305 $314,145 ($123,975)$43,532 $0 1Other category includes any horizontal infrastructure not easily assigned to a vertical project component (i.e., demolition/abatement of current office complex, parks and open space). Prepared by: HR&A Advisors, Inc. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 38 Fiscal Impact Methodology Net Fiscal and Other Revenue Impacts from Annual Operations to the City of San Ramon – Total 2026-2045 Projection Period – Nominal Total 2026-2045 Projection Period – Nominal Total For-Sale Residential Multifamily (Single-Use)Multifamily (Mixed-Use)Other¹ One-Time Revenues to the City of San Ramon General Fund Construction Property Tax $1,376,022 $272,184 $786,521 $317,317 $0 Construction MVLF $319,246 $63,148 $182,478 $73,620 $0 Documentary Transfer Tax (Initial Sale)$1,041,883 $1,041,883 $0 $0 $0 Construction Materials Sales Tax $6,917,087 $1,303,081 $3,846,315 $1,551,769 $215,922 Total One-Time Revenues to the City of San Ramon General Fund $9,654,238 $2,680,296 $4,815,314 $1,942,706 $215,922 Annual Revenues to the City of San Ramon General Fund Property Tax $41,651,473 $25,670,292 $9,326,010 $6,655,171 $0 MVLF In Lieu $9,682,108 $5,955,684 $2,182,379 $1,544,045 $0 Documentary Transfer Tax (Ongoing Turnover)$2,829,116 $2,829,116 $0 $0 $0 Franchise Tax $2,997,620 $525,512 $1,054,415 $1,417,694 $0 Sales Tax (Ongoing)$31,762,051 $4,328,356 $3,996,726 $23,436,969 $0 Licenses, Permits, Fees and Fines $13,155,210 $2,860,377 $5,600,389 $4,694,444 $0 Total Annual Revenues to City's General Fund $102,077,579 $42,169,337 $22,159,919 $37,748,323 $0 Total General Fund Revenue $111,731,817 $44,849,633 $26,975,233 $39,691,029 $215,922 Less: Property Tax and MVLF Revenue from Existing Site ($5,556,533) Less: City Service Costs ($66,403,758)($14,078,960)($28,462,580)($23,862,217)$0 Less: Sales Tax Reduction for City-County Tax Sharing Agreement ($15,881,025) Net Fiscal Impact to City's General Fund $23,890,502 $30,770,673 ($1,487,347)$15,828,812 $215,922 1Other category includes any horizontal infrastructure not easily assigned to a vertical project component (i.e., demolition/abatement of current office complex, parks and open space). Prepared by: HR&A Advisors, Inc. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 39 Fiscal Impact Methodology Net Fiscal and Other Revenue Impacts from Annual Operations to the City of San Ramon – Total 2026-2045 Projection Period – NPV Total 2026-2045 Projection Period - NPV Total For-Sale Residential Multifamily (Single-Use)Multifamily (Mixed-Use)Other¹ One-Time Revenues to the City of San Ramon General Fund Construction Property Tax $648,067 $182,641 $261,151 $204,275 $0 Construction MVLF $150,356 $42,374 $60,589 $47,393 $0 Documentary Transfer Tax (Initial Sale)$658,335 $658,335 $0 $0 $0 Construction Materials Sales Tax $3,365,045 $949,821 $1,277,102 $998,965 $139,157 Total One-Time Revenues to the City of San Ramon General Fund $4,821,802 $1,833,171 $1,598,841 $1,250,634 $139,157 Annual Revenues to the City of San Ramon General Fund Property Tax $10,655,780 $6,746,786 $1,984,485 $1,924,509 $0 MVLF In Lieu $2,477,435 $1,565,301 $465,635 $446,499 $0 Documentary Transfer Tax (Ongoing Turnover)$639,752 $639,752 $0 $0 $0 Franchise Tax $734,413 $152,113 $212,621 $369,678 $0 Sales Tax (Ongoing)$9,460,036 $1,448,027 $840,070 $7,171,939 $0 Licenses, Permits, Fees and Fines $3,173,108 $827,974 $1,127,775 $1,217,359 $0 Total Annual Revenues to City's General Fund $27,140,524 $11,379,952 $4,630,586 $11,129,985 $0 Total General Fund Revenue $31,962,326 $13,213,123 $6,229,427 $12,380,619 $139,157 Less: Property Tax and MVLF Revenue from Existing Site ($2,010,021) Less: City Service Costs ($16,021,374)($4,101,809)($5,731,635)($6,187,929)$0 Less: Sales Tax Reduction for City-County Tax Sharing Agreement ($4,730,018) Net Fiscal Impact to City's General Fund $9,200,914 $9,111,314 $497,792 $6,192,689 $139,157 1Other category includes any horizontal infrastructure not easily assigned to a vertical project component (i.e., demolition/abatement of current office complex, parks and open space). Prepared by: HR&A Advisors, Inc. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 40 Fiscal Impact Methodology Development Program¹ Product Total Residential Market Rate 80% AMI2 60% AMI2 50% AMI2 Retail For-Sale Residential 368 Units 368 Units ---- Townhomes 138 Units 138 Units Row House 58 Units 58 Units Detached Single Family 130 Units 130 Units Court 42 Units 42 Units Multifamily 1,465 Units 1,163 Units 91 Units 119 Units 92 Units - Multifamily (Single Use)1,345 Units 1,162 Units 91 Units 92 Units Affordable (LIHTC)120 Units 1 Units 119 Units Mixed-Use 619 Units 535 Units 42 Units -42 Units 120,560 SF Multifamily (Mixed Use)619 Units 535 Units 42 Units 42 Units Retail 120,560 SF Total 2,452 Units 2,066 Units 133 Units 119 Units 134 Units 120,560 SF ¹ Sunset Development ² Area Median Income (AMI) for Contra Costa County was $143,800 for a 3-person household. HCD, 2025 Income Limits. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 41 Fiscal Impact Methodology Phasing¹ Development 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Townhomes Units Under Construction 69 69 Units Delivered 138 Units Absorbed 69 69 Row House Units Under Construction 29 29 Units Delivered 58 Units Absorbed 29 29 Detached Single Family Units Under Construction 65 65 Units Delivered 130 Units Absorbed 65 65 Court Units Under Construction 21 21 Units Delivered 42 Units Absorbed 21 21 Affordable Development Units Under Construction 120 Units Delivered 120 Units Absorbed 120 Multifamily (Single Use) Units Under Construction 169 169 114 114 70 Units Delivered 337 227 Units Absorbed 169 169 114 Multifamily (Mixed Use) Units Under Construction 133 133 99 99 79 79 Units Delivered 265 197 157 Units Absorbed 133 133 99 99 79 79 Retail SF Under Construction 32,328 32,328 13,988 13,988 13,965 13,965 SF Delivered 64,655 27,975 27,930 SF Absorbed 32,328 32,328 13,988 13,988 13,965 13,965 Total Units Constructed --69 184 115 120 169 169 114 114 70 Total Units Absorbed ---69 184 115 120 -169 169 114 ¹ Sunset Development HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 42 Fiscal Impact Methodology Phasing¹ Development 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Townhomes Units Under Construction Units Delivered Units Absorbed Row House Units Under Construction Units Delivered Units Absorbed Detached Single Family Units Under Construction Units Delivered Units Absorbed Court Units Under Construction Units Delivered Units Absorbed Affordable Development Units Under Construction Units Delivered Units Absorbed Multifamily (Single Use) Units Under Construction 70 31 31 100 100 190 190 Units Delivered 140 61 200 380 Units Absorbed 114 70 70 31 31 100 100 190 190 Multifamily (Mixed Use) Units Under Construction Units Delivered Units Absorbed Retail SF Under Construction SF Delivered SF Absorbed Total Units Constructed 70 31 31 100 100 -190 190 -- Total Units Absorbed 114 70 70 31 31 100 100 -190 190 ¹ Sunset Development HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 43 Fiscal Impact Methodology Construction Hard Costs (2025$)¹ Category Vertical Costs Horizontal Costs Total For-Sale Residential $199,550,000 $39,996,909 $239,546,909 Townhomes $62,100,000 $12,447,046 $74,547,046 Row House $29,000,000 $5,812,630 $34,812,630 Detached Single Family $78,000,000 $15,633,971 $93,633,971 Court $30,450,000 $6,103,262 $36,553,262 Multifamily $549,375,000 $11,519,598 $560,894,598 Multifamily (Single-Use)$504,375,000 $10,576,013 $514,951,013 Affordable (LITHC)$45,000,000 $943,585 $45,943,585 Mixed-Use $271,715,882 $3,683,493 $275,399,375 Multifamily (Mixed-Use)$263,075,000 $3,683,493 $266,758,493 Retail (Tenant Improvements) $8,640,882 $8,640,882 Demolition/Abatement $8,333,076 $8,333,076 Parks and Open Spaces $30,000,000 $30,000,000 Total $1,020,640,882 $93,533,076 $1,114,173,958 ¹Sunset Development HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 44 Fiscal Impact Methodology Home Values¹ Category Average Sales Price Townhomes $1,250,000 Row House $1,650,000 Detached Single Family $1,900,000 Court $2,500,000 ¹Sunset Development HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 45 Fiscal Impact Methodology For-Sale Mortgage Assumptions Category Value Downpayment¹20% Interest Rate (30-year fixed rate mortgage)²6.6% Mortgage Term¹30 Property Tax (% of home value)³1.14% Homeowners Insurance (% of home value)⁴0.33% Maintenance (% of home value)¹1.00% ¹ HR&A Advisors, Inc. ² Freddie Mac - Primary Mortgage Market Survey ³ Contra Costa County, Annual Comprehensive Financial Report FY23-24⁴ MoneyGeek - Average Cost of Homeowners Insurance in CA (2025) HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 46 Fiscal Impact Methodology Operating Assumptions – Apartments Category Apartment (Market-Rate)Apartment (80% AMI)Apartment (60% AMI)Apartment (50% AMI) Monthly Rent per Unit1 $4,200 $2,658 $2,098 $1,699 Vacancy Rate1 2 2.9%2.5%2.5%2.5% OpEx2 30%30%30%30% Cost of Sale2 3%3%3%3% ¹ CoStar 2 HR&A Advisors, Inc. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 47 Fiscal Impact Methodology Operating Assumptions – Retail Use Monthly Rent per SF1 Monthly Rent per Unit1 $2.74 Vacancy Rate1 8.2% OpEx2 10% Cost of Sale2 3% Building Efficiency³86% Sales PSF² ⁴$773 Taxable Sales 85% ¹ CoStar 2 HR&A Advisors, Inc. ³ Sunset Development⁴ Retail Maxim 2021 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 48 Fiscal Impact Methodology Financing and Tax Assumptions Land Use Factors Apartment Cap Rate1 6.7% Retail Cap Rate1 7.6% Discount Rate for 2025 NPV2 11.4% Annual Inflation Rate³2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Housing Appreciation Rate ⁴ Detached Single Family 7.0% Condo/Townhomes 9.0% Unit Re-Sale Turnover 4, 5 Detached Single Family 3.5% Condo/Townhomes 7.5% 1 RERC, 2Q2025 2 Weighted average cost of capital (WACC) for major national homebuilders. ³ Consumer Price Index for All Urban Consumers, 2015-2025 YTD⁴ The Real Estate Market Trends Report - Contra Costa County 2024⁵ American Community Survey 2023 (5-Year Estimate) HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 49 Fiscal Impact Methodology City Tax Rates General Fund Factors General Levy (x Assessed Value)1.0% City Share of General Levy1 10.2% 2024 City Assessed Value2 $27,430,272,867 2024 City MVLF in Lieu2 $6,506,788 MVLF In Lieu Percentage (x Assessed Value)0.024% Documentary Transfer Tax3 $1.10/$1,000 Sales and Use Tax3 2.0% Tax Sharing Agreement Sales Tax Discount on PropertyTax4 Construction 0.00% Operations 50.00% Franchise Tax (Internet and Cable)3 5.0% 1 Contra Costa County Assessor 2 FY 2025-26 Adopted Budget, City of San Ramon 3 City of San Ramon Municipal Code; per Measure N (sunset date in 2034), this analysis assumes that the City sales tax rate will revert to 1% in 2035 4 3rd Amendment to the City-County Tax Sharing Agreement HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 50 Fiscal Impact Methodology Resident Estimates Category Factors Avg Future Owner HH Size¹2.90 Avg Future Renter HH Size Multifamily (Market)¹2.90 Inclusionary Housing ²2.50 Affordable (LIHTC)²2.75 Estimated Residents 6,990 Townhomes 402 Row House 169 Detached Single Family 378 Court 122 Multifamily (Single Use)3,827 Affordable (LIHTC)330 Multifamily (Mixed Use)1,762 ¹ Sunset Development ² HCD. Household Size to Bedroom County Conversion HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 51 Fiscal Impact Methodology Worker and Business Estimates Category Factors Retail Average Units/SF per Establishment 2,565 Number of Establishments / Buildings¹47 Workers (FTE)²596 FTE per Establishment 12.7 Apartment Workers (FTE)³58 FTE per Unit 0.027831094 1 HR&A assumption based on Sunset Development program. 2 IMPLAN 3 Sunset Development HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 52 Fiscal Impact Methodology Household Spending – Housing Costs¹ Category Annual Utilities1 Housing Cost2 For-Sale Housing $6,727 35% Apartment (Market-Rate)$5,983 30% Apartment (80% AMI)Part of rent allowance 30% Apartment (60% AMI)Part of rent allowance 30% Apartment (50% AMI)Part of rent allowance 30% ¹ Consumer Expenditure Survey, 2023 2 HR&A Advisors, Inc. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 53 Fiscal Impact Methodology Household Spending Categories Annual Consumer Expenditures1 Percent Taxable2 Adjustment for Shopping @ Project2 Food at Home 25%-10% Food Away from Home 100%-5% Alcoholic Beverages 100%0% Housekeeping Supplies 100%0% Household Furnishings & Equipment 100%-5% Apparel & Services 100%0% Transportation 100%0% Entertainment (less Fees & Admissions)100%-5% Personal Care Products & Services 100%-10% Reading 100%0% Tobacco Products 100%-5% Miscellaneous 100%0% Housing Costs 0%0% Health Care 0%-2% Entertainment - Fees & Admissions 0%0% Education 0%0% Cash Contributions 0%0% Personal Insurance and Pensions 0%0% ¹ Consumer Expenditure Survey, 2023 2 HR&A Advisors, Inc. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 54 Fiscal Impact Methodology Estimated Property Taxes (Construction) Stabilized Valuation Factors Values4 For-Sale Residential $239,546,909 Townhomes $74,547,046 Row House $34,812,630 Detached Single Family $93,633,971 Court $36,553,262 Multifamily $560,894,597.71 Multifamily (Single-Use)$514,951,013 Affordable (LIHTC)$45,943,585 Mixed-Use $275,399,375 Mixed-Use $266,758,493 Retail $8,640,882 Total Assessed Value $1,075,840,882 Property Tax General Levy Factors Values General Levy (x Assessed Value)3 1.0%$10,758,409 For-Sale Residential $2,395,469 Townhome $745,470 Row House $348,126 Detached Single Family $936,340 Court $365,533 Multifamily $5,608,946 Multifamily (Single-Use)$5,149,510 Affordable (LIHTC)$459,436 Mixed-Use $2,753,994 Mixed-Use $2,667,585 Retail $86,409 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 55 Fiscal Impact Methodology Estimated Property Taxes (Construction) – continued City Share of General Levy3 10.2%$1,099,977 For-Sale Residential $244,921 Townhome $76,220 Row House $35,594 Detached Single Family $95,735 Court $37,373 Multifamily $573,478.3 Multifamily (Single-Use)$526,504 Affordable (LIHTC)$46,974 Mixed-Use $281,578 Mixed-Use $272,743 Retail $8,835 MVLF In Lieu (x Assessed Value)3 0.0237%$255,202 For-Sale Residential $56,823 Townhome $17,683.45 Row House $8,257.97 Detached Single Family $22,211.10 Court $8,670.87 Multifamily $133,051 Multifamily (Single-Use)$122,152.52 Affordable (LIHTC)$10,898.37 Mixed-Use $65,328 Mixed-Use $63,278.30 Retail $2,049.72 1 Sunset Development. Includes both market-rate and affordable units. 2 Allocation based on total program units by product type. 3 See Appendix A - Table 2: Land Use Assumptions 4 Based on the total hard costs of construction. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 56 Fiscal Impact Methodology Estimated Onsite Construction Sales + Use Tax Land Use Total Allocated Hard Costs (2025 $)1 % Building Materials Taxable Sales % Sales Occurring in San Ramon Taxable Sales in San Ramon City's Sales Tax Rate2 Total Construction Sales (2019 $)3 Townhomes $74,547,046 50%$37,273,523 50%$18,636,762 2.0%$372,735.23 Row House $34,812,630 50%$17,406,315 50%$8,703,158 2.0%$174,063.15 Detached Single Family $93,633,971 50%$46,816,985 50%$23,408,493 2.0%$468,169.85 Court $36,553,262 50%$18,276,631 50%$9,138,315 2.0%$182,766.31 Multifamily (Single-Use)$514,951,013 50%$257,475,506 50%$128,737,753 2.0%$2,574,755.06 Affordable (LIHTC)$45,943,585 50%$22,971,792 50%$11,485,896 2.0%$229,717.92 Multifamily (Mixed-Use)$266,758,493 50%$133,379,247 50%$66,689,623 2.0%$1,333,792.47 Retail $8,640,882 50%$4,320,441 50%$2,160,220 2.0%$43,204.41 Demolition/Abatement $8,333,076 50%$4,166,538 50%$2,083,269 2.0%$41,665.38 Parks and Open Spaces $30,000,000 50%$15,000,000 50%$7,500,000 2.0%$150,000.00 Total $1,067,200,000 $5,336,000 1 See Appendix A - Table 3: Estimated Property Taxes (Construction) 2 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 3 Assumes the City will work with the contractors to ensure the point of sale of all materials occurs at the worksite (i.e. within City limits). HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 57 Fiscal Impact Methodology Estimated Property Taxes Stabilized Valuation Factors Values5 For-Sale Residential (Townhomes) Average Price per Unit1 $1,250,000 Total Units1 138 Gross Sales $172,500,000 Less: Cost of Sale @ 3%2 3%-$5,175,000 Net Value = Assessed Value $167,325,000 For-Sale Residential (Row House) Average Price per Unit1 $1,650,000 Total Units1 58 Gross Sales $95,700,000 Less: Cost of Sale @ 3%2 3%-$2,871,000 Net Value = Assessed Value $92,829,000 For-Sale Residential (Detached Single Family) Average Price per Unit1 $1,900,000 Total Units1 130 Gross Sales $247,000,000 Less: Cost of Sale @ 3%2 3%-$7,410,000 Net Value = Assessed Value $239,590,000 For-Sale Residential (Court) Average Price per Unit1 $2,500,000 Total Units1 42 Gross Sales $105,000,000 Less: Cost of Sale @ 3%2 3%-$3,150,000 Net Value = Assessed Value $101,850,000 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 58 Fiscal Impact Methodology Estimated Property Taxes – continued Multifamily (Single-Use) Rental Total Average Annual Rent1 $47,094 Total Apartments1 1,345 Occupancy3 97% Effective Gross Income $61,539,625 Less: OpEx @ 30% 3 -$18,461,888 NOI $43,077,738 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 -$1,292,332 Net Value = Assessed Value $642,951,307 Multifamily (Single-Use): Market Rate Average Annual Rent1 $50,400 Total Apartments1 1,162 Occupancy3 97% Effective Gross Income $56,866,421 Less: OpEx @ 30% 3 -$17,059,926 NOI 39,806,495 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 -$1,194,195 Net Value = Assessed Value $594,126,784 Multifamily (Single-Use): 80% AMI Average Annual Rent1 $31,890 Total Apartments1 91 Occupancy3 98% Effective Gross Income $2,829,440 Less: OpEx @ 30% 3 -$848,832 NOI 1,980,608 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 $59,418 Net Value = Assessed Value $29,561,316 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 59 Fiscal Impact Methodology Estimated Property Taxes – continued Multifamily (Single-Use): 50% AMI Average Annual Rent1 $20,384 Total Apartments1 92 Occupancy3 98% Effective Gross Income $1,828,400 Less: OpEx @ 30% 3 -$548,520 NOI $1,279,880 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 -$38,396 Net Value = Assessed Value $19,102,686.04 Affordable (60% AMI) Average Annual Rent1 $25,178 Total Apartments1 119 Occupancy3 98% Effective Gross Income $2,921,219.44 Less: OpEx @ 30% 3 -876,366 NOI 2,044,854 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 -$61,346 Net Value = Assessed Value $30,520,203 Multifamily (Mixed-Use) Rental Total Average Annual Rent1 $47,107 Total Apartments1 619 Occupancy3 97% Effective Gross Income $28,313,862 Less: OpEx @ 30% 3 -$8,494,159 NOI $19,819,703 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 -$594,591 Net Value = Assessed Value $295,816,467 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 60 Fiscal Impact Methodology Estimated Property Taxes – continued Multifamily (Mixed-Use): Market Rate Average Annual Rent1 $50,400 Total Apartments1 535 Occupancy3 97% Effective Gross Income $26,182,044 Less: OpEx @ 30% 3 -$7,854,613 NOI 18,327,431 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 -$549,823 Net Value = Assessed Value $273,543,743 Multifamily (Mixed-Use): 80% AMI Average Annual Rent1 $31,890 Total Apartments1 42 Occupancy3 97% Effective Gross Income $1,300,538 Less: OpEx @ 30% 3 -$390,161 NOI 910,377 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 -$27,311 Net Value = Assessed Value $13,587,710 Multifamily (Mixed-Use): 50% AMI Average Annual Rent1 $20,384 Total Apartments1 42 Occupancy3 97% Effective Gross Income $831,280 Less: OpEx @ 30% 3 -$249,384 NOI 581,896 Cap Rate4 6.7% Less: Cost of Sale @ 3%2 -$17,457 Net Value = Assessed Value $8,685,014 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 61 Fiscal Impact Methodology Estimated Property Taxes – continued Retail Average Annual Rent per SF1 $2.74 Gross SF1 120,560 Leasable SF @ 86% Efficiency 103,960 Occupancy2 92% Effective Gross Income @ 59% Occupied1 $261,494 Less: OpEx @ 10%3 -$26,149 NOI $235,344 Cap Rate4 7.6% Less: Cost of Sale @ 3%2 -$92,899 Net Value = Assessed Value $3,003,739 For-Sale Residential $601,594,000 Townhome $167,325,000 Row House $92,829,000 Detached Single Family $239,590,000 Court $101,850,000 Multifamily $673,310,990 Multifamily (Single-Use)$642,790,787 Affordable (LIHTC)$30,520,203 Mixed-Use $298,820,206 Mixed-Use $295,816,467 Retail $3,003,739 Total Assessed Value $1,573,725,196 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 62 Fiscal Impact Methodology Estimated Property Taxes – continued Property Tax Factors Values General Levy (x Assessed Value)4 1.0%$15,737,252 For-Sale Residential $6,015,940 Townhome $1,673,250 Row House $928,290 Detached Single Family $2,395,900 Court $1,018,500 Multifamily $6,733,110 Multifamily (Single-Use)$6,427,908 Affordable (LIHTC)$305,202 Mixed-Use $2,988,202 Mixed-Use $2,958,165 Retail $30,037 City Share of General Levy4 10.2%$1,609,032 For-Sale Residential $615,091 Townhome $171,079 Row House $94,912 Detached Single Family $244,965 Court $104,135 Multifamily $688,417 Multifamily (Single-Use)$657,212 Affordable (LIHTC)$31,205 Mixed-Use $305,524 Mixed-Use $302,453 Retail $3,071 HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 63 Fiscal Impact Methodology Estimated Property Taxes – continued MVLF In Lieu (x Assessed Value)4 0.0237%$373,306 For-Sale Residential $142,705 Townhome $39,691 Row House $22,020 Detached Single Family $56,834 Court $24,160 Multifamily $159,717 Multifamily (Single-Use)$152,478 Affordable (LIHTC)$7,240 Mixed-Use $70,884 Mixed-Use $70,171 Retail $713 1 Sunset Development. Includes both market-rate and affordable units. 2 HR&A Advisors. Includes management fee, a replacement reserve, and all other operating expenses. 3 HR&A Advisors, Inc. 4 See Appendix A - Table 2: Land Use Assumptions HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 64 Fiscal Impact Methodology Estimated Sales + Use Tax Tenant Type Leasable SF Sales Per SF¹ Annual Gross Sales Vacancy Rate Adjusted Annual Gross Sales Taxable %² Annual Taxable Retail Sales Retail 120,560 $773 $93,239,054 8%$85,593,451 85%$72,754,434 Total 120,560 $93,239,054 $85,593,451 $72,754,434 City's Sales Tax Rate3 2.00% Annual Sales Tax Revenue (2025 $)$1,455,089 1 Retail Sales per SF Standards (Retail Maxim). ² HR&A assumption based on retail mix from Sunset Development. 3 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 65 Fiscal Impact Methodology Household Retail Spending in San Ramon Categories Values Total Retail Spending in San Ramon1 $1,188,522,887 Number of Workers Living Outside San Ramon2 28,704 Annual Spending Per Worker3 $7,998 Total Worker Spending3 $229,568,633 Total Resident Spending in San Ramon $958,954,254 Total Spending Potential of San Ramon Residents $1,876,592,299 Percent Resident Spending in San Ramon 51% 1CA Department of Tax and Fee Administration, Taxable Sales (2024) 2LEHD. Excludes workers earning less than $3,333 per month ($40,000 per year). 3International Council of Shopping Centers, Office Worker Retail Spending in a Digital Age, p. 32, Urban Spending, 2011 4ESRI Business Analyst - Retail Demand by Industry (2022-23) HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 66 Fiscal Impact Methodology For-Sale Residential (Townhomes) Household Sales Tax Revenue Household Income Per Unit Spending Category Amount Percent Percent Taxable2 Taxable Amount % of Project Household Taxable Purchases San Ramon Adjustment for Shopping @ Project2 Off-site Taxable Purchases Average Purchase Price1 $1,250,000 Hhld. Income Before Taxes9 $335,248 100%52% Down Payment2 20%Average CES Household Size 3.2 Mortgage Principal $1,000,000 Average Expected Household Size 2.9 Term (Years)2 30 Household Size Adjustment Factor 0.9 Rate (APR)3 6.6% Average Monthly Mortgage Payment $6,378 Annual Consumer Expenditures10 $232,828 100.00%12.9%12.6% Monthly Utility Cost4 $561 Food at Home $8,792 3.78%30%$2,638 $1,372 -10%$1,234 Annual Property Tax Rate⁵1.139%Food Away from Home $7,997 3.43%100%$7,997 $4,158 -5%$3,950 Annual Property Tax Payment $14,241 Alcoholic Beverages $1,420 0.61%100%$1,420 $738 0%$738 Annual Insurance Cost⁶$4,163 Housekeeping Supplies $1,224 0.53%100%$1,224 $637 0%$637 Annual Maintenance $12,500 Household Furnishings & Equipment $5,111 2.20%100%$5,111 $2,658 -5%$2,525 Total Annual Housing Cost $114,172 Apparel & Services $4,233 1.82%100%$4,233 $2,201 0%$2,201 Housing Allocation2 35%Transportation $25,654 11.02%100%$25,654 $13,340 0%$13,340 Estimated Gross Hhld. Income $326,206 Entertainment (less Fees & Admissions)$5,401 2.32%100%$5,401 $2,809 -5%$2,668 Personal Care Products & Services $1,726 0.74%100%$1,726 $898 -10%$808 Project Annual Sales Tax Reading $219 0.09%100%$219 $114 0%$114 Total Units⁷138 Tobacco Products $200 0.09%100%$200 $104 -5%$99 Total Project Gross Hhld. Income $45,016,484 Miscellaneous $2,152 0.92%100%$2,152 $1,119 0%$1,119 Annual Hhld. Spending/Total Hhld. Income 69%Housing Costs2 $114,172 49.04%0%$0 $0 0%$0 Annual Hhld. Spending $31,263,777 Health Care $9,707 4.17%0%$0 $0 -2%$0 Adjustment for Taxable Spending 12.6%Entertainment-Fees & Admissions $3,232 1.39%0%$0 $0 0%$0 Annual Hhld. Taxable Spending After Adjustment $3,952,430 Education $6,166 2.65%0%$0 $0 0%$0 City Sales Tax Rate8 2.00%Cash Contributions $5,855 2.51%0%$0 $0 0%$0 Annual Sales Tax Revenue (2025$)$79,049 Personal Insurance and Pensions $29,565 12.70%0%$0 $0 0%$0 1 Sunset Development. 2 HR&A Advisors assumption. 3 Freddie Mac - Primary Mortgage Market Survey 4 U.S. Energy Information Administration and U.S. Environmental Protection Agency. 5 Contra Costa County, Annual Comprehensive Financial Report FY23-24 6 MoneyGeek - Average Cost of Homeowners Insurance in CA (2025) 7 See Appendix A - Table 2: Land Use Assumptions. 8 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 9 Bureau of Labor Statistics Consumer Expenditure Survey 2023 mean income before taxes for households earning over $200,000 annually. 10 Average consumer spending in total and by category correspond to the 2023 Consumer Expenditure Survey for households earning over $200,000 annually, adjusted for household size. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 67 Fiscal Impact Methodology For-Sale Residential (Row Homes) Household Sales Tax Revenue Household Income Per Unit Spending Category Amount Percent Percent Taxable2 Taxable Amount % of Project Household Taxable Purchases San Ramon Adjustment for Shopping @ Project2 Off-site Taxable Purchases Average Purchase Price1 $1,650,000 Hhld. Income Before Taxes9 $335,248 100%52% Down Payment2 20%Average CES Household Size 3.2 Mortgage Principal $1,320,000 Average Expected Household Size 2.9 Term (Years)2 30 Household Size Adjustment Factor 0.9 Rate (APR)3 6.6% Average Monthly Mortgage Payment $8,420 Annual Consumer Expenditures10 $267,211 114.77%11.3%11.0% Monthly Utility Cost4 $561 Food at Home $8,792 3.78%30%$2,638 $1,372 -10%$1,234 Annual Property Tax Rate⁵1.139%Food Away from Home $7,997 3.43%100%$7,997 $4,158 -5%$3,950 Annual Property Tax Payment $18,798 Alcoholic Beverages $1,420 0.61%100%$1,420 $738 0%$738 Annual Insurance Cost⁶$5,495 Housekeeping Supplies $1,224 0.53%100%$1,224 $637 0%$637 Annual Maintenance $16,500 Household Furnishings & Equipment $5,111 2.20%100%$5,111 $2,658 -5%$2,525 Total Annual Housing Cost $148,555 Apparel & Services $4,233 1.82%100%$4,233 $2,201 0%$2,201 Housing Allocation2 35%Transportation $25,654 11.02%100%$25,654 $13,340 0%$13,340 Estimated Gross Hhld. Income $424,442 Entertainment (less Fees & Admissions)$5,401 2.32%100%$5,401 $2,809 -5%$2,668 Personal Care Products & Services $1,726 0.74%100%$1,726 $898 -10%$808 Project Annual Sales Tax Reading $219 0.09%100%$219 $114 0%$114 Total Units⁷58 Tobacco Products $200 0.09%100%$200 $104 -5%$99 Total Project Gross Hhld. Income $24,617,639 Miscellaneous $2,152 0.92%100%$2,152 $1,119 0%$1,119 Annual Hhld. Spending/Total Hhld. Income 80%Housing Costs2 $148,555 63.80%0%$0 $0 0%$0 Annual Hhld. Spending $19,621,601 Health Care $9,707 4.17%0%$0 $0 -2%$0 Adjustment for Taxable Spending 11.0%Entertainment-Fees & Admissions $3,232 1.39%0%$0 $0 0%$0 Annual Hhld. Taxable Spending After Adjustment $2,161,419 Education $6,166 2.65%0%$0 $0 0%$0 City Sales Tax Rate8 2.00%Cash Contributions $5,855 2.51%0%$0 $0 0%$0 Annual Sales Tax Revenue (2025$)$43,228 Personal Insurance and Pensions $29,565 12.70%0%$0 $0 0%$0 1 Sunset Development. 2 HR&A Advisors assumption. 3 Freddie Mac - Primary Mortgage Market Survey 4 U.S. Energy Information Administration and U.S. Environmental Protection Agency. 5 Contra Costa County, Annual Comprehensive Financial Report FY23-24 6 MoneyGeek - Average Cost of Homeowners Insurance in CA (2025) 7 See Appendix A - Table 2: Land Use Assumptions. 8 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 9 Bureau of Labor Statistics Consumer Expenditure Survey 2023 mean income before taxes for households earning over $200,000 annually. 10 Average consumer spending in total and by category correspond to the 2023 Consumer Expenditure Survey for households earning over $200,000 annually, adjusted for household size. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 68 Fiscal Impact Methodology For-Sale Residential (Detached Single-Family) Household Tax Revenue Household Income Per Unit Spending Category Amount Percent Percent Taxable2 Taxable Amount % of Project Household Taxable Purchases San Ramon Adjustment for Shopping @ Project2 Off-site Taxable Purchases Average Purchase Price1 $1,900,000 Hhld. Income Before Taxes9 $335,248 100%52% Down Payment2 20%Average CES Household Size 3.2 Mortgage Principal $1,520,000 Average Expected Household Size 2.9 Term (Years)2 30 Household Size Adjustment Factor 0.9 Rate (APR)3 6.6% Average Monthly Mortgage Payment $9,695 Annual Consumer Expenditures10 $288,700 124.00%10.4%10.2% Monthly Utility Cost4 $561 Food at Home $8,792 3.78%30%$2,638 $1,372 -10%$1,234 Annual Property Tax Rate⁵1.139%Food Away from Home $7,997 3.43%100%$7,997 $4,158 -5%$3,950 Annual Property Tax Payment $21,647 Alcoholic Beverages $1,420 0.61%100%$1,420 $738 0%$738 Annual Insurance Cost⁶$6,327 Housekeeping Supplies $1,224 0.53%100%$1,224 $637 0%$637 Annual Maintenance $19,000 Household Furnishings & Equipment $5,111 2.20%100%$5,111 $2,658 -5%$2,525 Total Annual Housing Cost $170,044 Apparel & Services $4,233 1.82%100%$4,233 $2,201 0%$2,201 Housing Allocation2 35%Transportation $25,654 11.02%100%$25,654 $13,340 0%$13,340 Estimated Gross Hhld. Income $485,839 Entertainment (less Fees & Admissions)$5,401 2.32%100%$5,401 $2,809 -5%$2,668 Personal Care Products & Services $1,726 0.74%100%$1,726 $898 -10%$808 Project Annual Sales Tax Reading $219 0.09%100%$219 $114 0%$114 Total Units⁷130 Tobacco Products $200 0.09%100%$200 $104 -5%$99 Total Project Gross Hhld. Income $63,159,114 Miscellaneous $2,152 0.92%100%$2,152 $1,119 0%$1,119 Annual Hhld. Spending/Total Hhld. Income 86%Housing Costs2 $170,044 73.03%0%$0 $0 0%$0 Annual Hhld. Spending $54,389,692 Health Care $9,707 4.17%0%$0 $0 -2%$0 Adjustment for Taxable Spending 10.2%Entertainment-Fees & Admissions $3,232 1.39%0%$0 $0 0%$0 Annual Hhld. Taxable Spending After Adjustment $5,545,346 Education $6,166 2.65%0%$0 $0 0%$0 City Sales Tax Rate8 2.00%Cash Contributions $5,855 2.51%0%$0 $0 0%$0 Annual Sales Tax Revenue (2025$)$110,907 Personal Insurance and Pensions $29,565 12.70%0%$0 $0 0%$0 1 Sunset Development. 2 HR&A Advisors assumption. 3 Freddie Mac - Primary Mortgage Market Survey 4 U.S. Energy Information Administration and U.S. Environmental Protection Agency. 5 Contra Costa County, Annual Comprehensive Financial Report FY23-24 6 MoneyGeek - Average Cost of Homeowners Insurance in CA (2025) 7 See Appendix A - Table 2: Land Use Assumptions. 8 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 9 Bureau of Labor Statistics Consumer Expenditure Survey 2023 mean income before taxes for households earning over $200,000 annually. 10 Average consumer spending in total and by category correspond to the 2023 Consumer Expenditure Survey for households earning over $200,000 annually, adjusted for household size. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 69 Fiscal Impact Methodology For-Sale Residential (Court) Household Sales Tax Revenue Household Income Per Unit Spending Category Amount Percent Percent Taxable2 Taxable Amount % of Project Household Taxable Purchases San Ramon Adjustment for Shopping @ Project2 Off-site Taxable Purchases Average Purchase Price1 $2,500,000 Hhld. Income Before Taxes $335,248 100%52% Down Payment2 20%Average CES Household Size9 3.2 Mortgage Principal $2,000,000 Average Expected Household Size 2.9 Term (Years)2 30 Household Size Adjustment Factor 0.9 Rate (APR)3 6.6% Average Monthly Mortgage Payment $12,757 Annual Consumer Expenditures10 $340,274 146.15%8.9%8.7% Monthly Utility Cost4 $561 Food at Home $8,792 3.78%30%$2,638 $1,372 -10%$1,234 Annual Property Tax Rate⁵1.139%Food Away from Home $7,997 3.43%100%$7,997 $4,158 -5%$3,950 Annual Property Tax Payment $28,483 Alcoholic Beverages $1,420 0.61%100%$1,420 $738 0%$738 Annual Insurance Cost⁶$8,325 Housekeeping Supplies $1,224 0.53%100%$1,224 $637 0%$637 Annual Maintenance $25,000 Household Furnishings & Equipment $5,111 2.20%100%$5,111 $2,658 -5%$2,525 Total Annual Housing Cost $221,617 Apparel & Services $4,233 1.82%100%$4,233 $2,201 0%$2,201 Housing Allocation2 35%Transportation $25,654 11.02%100%$25,654 $13,340 0%$13,340 Estimated Gross Hhld. Income $633,193 Entertainment (less Fees & Admissions)$5,401 2.32%100%$5,401 $2,809 -5%$2,668 Personal Care Products & Services $1,726 0.74%100%$1,726 $898 -10%$808 Project Annual Sales Tax Reading $219 0.09%100%$219 $114 0%$114 Total Units⁷42 Tobacco Products $200 0.09%100%$200 $104 -5%$99 Total Project Gross Hhld. Income $26,594,098 Miscellaneous $2,152 0.92%100%$2,152 $1,119 0%$1,119 Annual Hhld. Spending/Total Hhld. Income 101%Housing Costs2 $221,617 95.18%0%$0 $0 0%$0 Annual Hhld. Spending $26,992,770 Health Care $9,707 4.17%0%$0 $0 -2%$0 Adjustment for Taxable Spending 8.7%Entertainment-Fees & Admissions $3,232 1.39%0%$0 $0 0%$0 Annual Hhld. Taxable Spending After Adjustment $2,334,952 Education $6,166 2.65%0%$0 $0 0%$0 City Sales Tax Rate⁸2.00%Cash Contributions $5,855 2.51%0%$0 $0 0%$0 Annual Sales Tax Revenue (2025$)$46,699 Personal Insurance and Pensions $29,565 12.70%0%$0 $0 0%$0 1 Sunset Development. 2 HR&A Advisors assumption. 3 Freddie Mac - Primary Mortgage Market Survey 4 U.S. Energy Information Administration and U.S. Environmental Protection Agency. 5 Contra Costa County, Annual Comprehensive Financial Report FY23-24 6 MoneyGeek - Average Cost of Homeowners Insurance in CA (2025) 7 See Appendix A - Table 2: Land Use Assumptions. 8 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 9 Bureau of Labor Statistics Consumer Expenditure Survey 2023 mean income before taxes for households earning over $200,000 annually. 10 Average consumer spending in total and by category correspond to the 2023 Consumer Expenditure Survey for households earning over $200,000 annually, adjusted for household size. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 70 Fiscal Impact Methodology Multifamily (Market-Rate) Household Income Per Unit Spending Category Amount Percent Percent Taxable 2 Taxable Amount % of Project Household Taxable Purchases San Ramon Adjustment for Shopping @ Project2 Off-site Taxable Purchases Average Monthly Rent¹$4,200 Hhld. Income Before Taxes⁵$171,339 100%52% Average Annual Rent $50,400 Average CES Household Size 3.2 Annual Utility Cost2 $5,983 Average Expected Household Size 2.9 Total Annual Housing Cost $56,383 Household Size Adjustment Factor 0.9 Housing Allocation2 30% Estimated Gross Hhld. Income $187,943 Annual Consumer Expenditures⁶$135,612 58.25%16.5%16.1% Food at Home $7,814 3.36%30%$2,344 $1,219 -10%$1,097 Food Away from Home $6,020 2.59%100%$6,020 $3,131 -5%$2,974 Alcoholic Beverages $1,150 0.49%100%$1,150 $598 0%$598 Housekeeping Supplies $1,046 0.45%100%$1,046 $544 0%$544 Household Furnishings & Equipment $3,544 1.52%100%$3,544 $1,843 -5%$1,751 Apparel & Services $2,731 1.17%100%$2,731 $1,420 0%$1,420 Transportation $19,155 8.23%100%$19,155 $9,961 0%$9,961 Entertainment (less Fees & Admissions)$3,765 1.62%100%$3,765 $1,958 -5%$1,860 Personal Care Products & Services $1,277 0.55%100%$1,277 $664 -10%$598 Project Annual Sales Tax Reading $157 0.07%100%$157 $82 0%$82 Total Units³1,698 Tobacco Products $294 0.13%100%$294 $153 -5%$145 Total Project Gross Hhld. Income 319,127,780 Miscellaneous $1,593 0.68%100%$1,593 $828 0%$828 Annual Hhld. Spending/Total Hhld. Income 79%Housing Costs2 $56,383 24.22%0%$0 $0 0%$0 Annual Hhld. Spending 252,584,214 Health Care $7,305 3.14%0%$0 $0 -2%$0 Adjustment for Taxable Spending 16.1%Entertainment-Fees & Admissions $1,562 0.67%0%$0 $0 0%$0 Annual Hhld. Taxable Spending After Adjustment 40,711,103 Education $1,911 0.82%0%$0 $0 0%$0 City Sales Tax Rate⁴2.00%Cash Contributions $2,907 1.25%0%$0 $0 0%$0 Annual Sales Tax Revenue (2025$)$814,222 Personal Insurance and Pensions $16,996 7.30%0%$0 $0 0%$0 1 CoStar 2 HR&A Advisors assumption. 3 See Appendix A - Table 2: Land Use Assumptions. 4 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 5 Bureau of Labor Statistics Consumer Expenditure Survey 2023 mean income before taxes for households earning between $150,000 and $199,999 annually. 6 Average consumer spending in total and by category correspond to the 2023 Consumer Expenditure Survey for households earning between $150,000 and $199,999 annually, adjusted for household size. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 71 Fiscal Impact Methodology Multifamily (80% AMI) Household Income Per Unit Spending Category Amount Percent Percent Taxable 2 Taxable Amount % of Project Household Taxable Purchases San Ramon Adjustment for Shopping @ Project2 Off-site Taxable Purchases Average Monthly Rent¹$2,658 Hhld. Income Before Taxes⁵$121,816 100%52% Average Annual Rent $31,890 Average CES Household Size 3.2 Annual Utility Cost2 $0 Average Expected Household Size 2.9 Total Annual Housing Cost $31,890 Household Size Adjustment Factor 0.9 Housing Allocation2 30% Estimated Gross Hhld. Income $106,300 Annual Consumer Expenditures⁶$111,119 47.73%20.2%19.7% Food at Home $7,814 3.36%30%$2,344 $1,219 -10%$1,097 Food Away from Home $6,020 2.59%100%$6,020 $3,131 -5%$2,974 Alcoholic Beverages $1,150 0.49%100%$1,150 $598 0%$598 Housekeeping Supplies $1,046 0.45%100%$1,046 $544 0%$544 Household Furnishings & Equipment $3,544 1.52%100%$3,544 $1,843 -5%$1,751 Apparel & Services $2,731 1.17%100%$2,731 $1,420 0%$1,420 Transportation $19,155 8.23%100%$19,155 $9,961 0%$9,961 Entertainment (less Fees & Admissions)$3,765 1.62%100%$3,765 $1,958 -5%$1,860 Personal Care Products & Services $1,277 0.55%100%$1,277 $664 -10%$598 Project Annual Sales Tax Reading $157 0.07%100%$157 $82 0%$82 Total Units³133 Tobacco Products $294 0.13%100%$294 $153 -5%$145 Total Project Gross Hhld. Income $14,137,900 Miscellaneous $1,593 0.68%100%$1,593 $828 0%$828 Annual Hhld. Spending/Total Hhld. Income 91%Housing Costs2 $31,890 13.70%0%$0 $0 0%$0 Annual Hhld. Spending $12,896,401 Health Care $7,305 3.14%0%$0 $0 -2%$0 Adjustment for Taxable Spending 19.7%Entertainment-Fees & Admissions $1,562 0.67%0%$0 $0 0%$0 Annual Hhld. Taxable Spending After Adjustment $2,536,793 Education $1,911 0.82%0%$0 $0 0%$0 City Sales Tax Rate⁴2.00%Cash Contributions $2,907 1.25%0%$0 $0 0%$0 Annual Sales Tax Revenue (2025$)$50,736 Personal Insurance and Pensions $16,996 7.30%0%$0 $0 0%$0 1 CoStar 2 HR&A Advisors assumption. 3 See Appendix A - Table 2: Land Use Assumptions. 4 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 5 Bureau of Labor Statistics Consumer Expenditure Survey 2023 mean income before taxes for households earning between $100,000 and $149,999 annually. 6 Average consumer spending in total and by category correspond to the 2023 Consumer Expenditure Survey for households earning between $100,000 and $149,999 annually, adjusted for household size. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 72 Fiscal Impact Methodology Multifamily (50% AMI) Household Income Per Unit Spending Category Amount Percent Percent Taxable 2 Taxable Amount % of Project Household Taxable Purchases San Ramon Adjustment for Shopping @ Project2 Off-site Taxable Purchases Average Monthly Rent¹$1,699 Hhld. Income Before Taxes⁵$59,346 100%52% Average Annual Rent $20,384 Average CES Household Size 3.2 Annual Utility Cost2 $0 Average Expected Household Size 2.9 Total Annual Housing Cost $20,384 Household Size Adjustment Factor 0.9 Housing Allocation2 30% Estimated Gross Hhld. Income $67,945 Annual Consumer Expenditures⁶$99,612 42.78%22.5%21.9% Food at Home $7,814 3.36%30%$2,344 $1,219 -10%$1,097 Food Away from Home $6,020 2.59%100%$6,020 $3,131 -5%$2,974 Alcoholic Beverages $1,150 0.49%100%$1,150 $598 0%$598 Housekeeping Supplies $1,046 0.45%100%$1,046 $544 0%$544 Household Furnishings & Equipment $3,544 1.52%100%$3,544 $1,843 -5%$1,751 Apparel & Services $2,731 1.17%100%$2,731 $1,420 0%$1,420 Transportation $19,155 8.23%100%$19,155 $9,961 0%$9,961 Entertainment (less Fees & Admissions)$3,765 1.62%100%$3,765 $1,958 -5%$1,860 Personal Care Products & Services $1,277 0.55%100%$1,277 $664 -10%$598 Project Annual Sales Tax Reading $157 0.07%100%$157 $82 0%$82 Total Units³134 Tobacco Products $294 0.13%100%$294 $153 -5%$145 Total Project Gross Hhld. Income $9,104,630 Miscellaneous $1,593 0.68%100%$1,593 $828 0%$828 Annual Hhld. Spending/Total Hhld. Income 168%Housing Costs2 $20,384 8.75%0%$0 $0 0%$0 Annual Hhld. Spending $15,282,144 Health Care $7,305 3.14%0%$0 $0 -2%$0 Adjustment for Taxable Spending 21.94%Entertainment-Fees & Admissions $1,562 0.67%0%$0 $0 0%$0 Annual Hhld. Taxable Spending After Adjustment $3,353,323 Education $1,911 0.82%0%$0 $0 0%$0 City Sales Tax Rate⁴2.00%Cash Contributions $2,907 1.25%0%$0 $0 0%$0 Annual Sales Tax Revenue (2025$)$67,066 Personal Insurance and Pensions $16,996 7.30%0%$0 $0 0%$0 1 CoStar 2 HR&A Advisors assumption. 3 See Appendix A - Table 2: Land Use Assumptions. 4 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 5 Bureau of Labor Statistics Consumer Expenditure Survey 2023 mean income before taxes for households earning between $50,000 and $69,999 annually. 6 Average consumer spending in total and by category correspond to the 2023 Consumer Expenditure Survey for households earning between $50,000 and $69,999 annually, adjusted for household size. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 73 Fiscal Impact Methodology Multifamily (60% AMI) Household Income Per Unit Spending Category Amount Percent Percent Taxable 2 Taxable Amount % of Project Household Taxable Purchases San Ramon Adjustment for Shopping @ Project2 Off-site Taxable Purchases Average Monthly Rent¹$2,098 Hhld. Income Before Taxes⁵$83,578 100%52% Average Annual Rent $25,178 Average CES Household Size 2.6 Annual Utility Cost2 $0 Average Expected Household Size 2.8 Total Annual Housing Cost $25,178 Household Size Adjustment Factor 1.1 Housing Allocation2 30% Estimated Gross Hhld. Income $83,925 Annual Consumer Expenditures⁶$71,280 30.61%19.3%18.8% Food at Home $5,510 2.37%30%$1,653 $860 -10%$774 Food Away from Home $3,284 1.41%100%$3,284 $1,708 -5%$1,622 Alcoholic Beverages $464 0.20%100%$464 $241 0%$241 Housekeeping Supplies $734 0.32%100%$734 $382 0%$382 Household Furnishings & Equipment $2,346 1.01%100%$2,346 $1,220 -5%$1,159 Apparel & Services $1,913 0.82%100%$1,913 $995 0%$995 Transportation $11,450 4.92%100%$11,450 $5,954 0%$5,954 Entertainment (less Fees & Admissions)$2,216 0.95%100%$2,216 $1,152 -5%$1,095 Personal Care Products & Services $924 0.40%100%$924 $481 -10%$433 Project Annual Sales Tax Reading $85 0.04%100%$85 $44 0%$44 Total Units³119 Tobacco Products $392 0.17%100%$392 $204 -5%$193 Total Project Gross Hhld. Income $9,987,075 Miscellaneous $978 0.42%100%$978 $508 0%$508 Annual Hhld. Spending/Total Hhld. Income 85%Housing Costs2 $25,178 10.81%0%$0 $0 0%$0 Annual Hhld. Spending $8,517,567 Health Care $5,463 2.35%0%$0 $0 -2%$0 Adjustment for Taxable Spending 18.8%Entertainment-Fees & Admissions $654 0.28%0%$0 $0 0%$0 Annual Hhld. Taxable Spending After Adjustment $1,601,225 Education $1,002 0.43%0%$0 $0 0%$0 City Sales Tax Rate⁴2.00%Cash Contributions $1,760 0.76%0%$0 $0 0%$0 Annual Sales Tax Revenue (2025$)$32,025 Personal Insurance and Pensions $6,927 2.98%0%$0 $0 0%$0 1 CoStar 2 HR&A Advisors assumption. 3 See Appendix A - Table 2: Land Use Assumptions. 4 Assumes 2.0% sales tax rate remains in effect through 2034, then reverts to 1.0% in 2035 through the remainder of the projection period. 5 Bureau of Labor Statistics Consumer Expenditure Survey 2023 mean income before taxes for households earning between $70,000 and $99,999 annually. 6 Average consumer spending in total and by category correspond to the 2023 Consumer Expenditure Survey for households earning between $70,000 and $99,999 annually, adjusted for household size. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 74 Fiscal Impact Methodology Estimated Franchise Tax Tenant Type Units/Establishments1 Net SF Cost per HH2 Cost per SF or Unit with Vacancy Allowance Franchise Tax Rate3 Total Franchise Tax For-Sale Residential Internet 368 $696 $661 5.0%$12,166 Cable 368 $936 $889 5.0%$16,361 $28,527 Multifamily (Single-Use) Internet 1,345 $696 $661 5.0%$44,466 Cable 1,345 $936 $889 5.0%$59,799 Multifamily (Mixed-Use) Internet 619 $696 $661 5.0%$20,464.14 Cable 619 $936 $889 5.0%$27,520.74 $47,984.88 Affordable (LIHTC) Internet 120 $696 $661 5.0%$3,967.20 Cable 120 $936 $889 5.0%$5,335.20 $9,302.40 Annual Residential Franchise Tax Revenue (2025$)$145,613 Internet2 47 120,560 $12,000 5.0%$28,200 $28,200 Annual Franchise Tax Revenue (2025$)$173,813 1 Sunset Development. Includes both for-sale and rental units. 2 U.S. Energy Information Administration, various cable and internet providers. 3 City of San Ramon. Assumes tax rates effective 1/1/2025 remain in effect without change over the projection period. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 75 Fiscal Impact Methodology Estimated Other Taxes % of Day in City1 Resident-Equivalents Residential Resident Population 6,990 89%6,223 Residential Workers 58 27%16 Retail/Restaurant Workers2 596 27%160 Total Resident-Equivalents 6,398 Licenses, Permits, Fees and Other Fines FY 2024-25 Revenues3 $10,633,185 Total Resident-Equivalents1 85,237 Per Resident-Equivalent $125 Annual Revenues (2025$)$798,184 1 See Resident-Equivalent calculation, Appendix A - Table 9: Resident-Equivalents. 2 Estimate based on IMPLAN outputs. 3 City of San Ramon. Revenues include general government service charge, city ordinance violation, application/filing fee, dog license, building permits, and miscellaneous permits per San Ramon's FY 2024-25 revised budget. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 76 Fiscal Impact Methodology City Resident-Equivalents Number % of Week in City4 Resident-Equivalents City of San Ramon Population1 Out-Commuting Resident Workers2 35,110 73%25,706 Remaining Residential Population 50,624 100%50,624 Subtotal 85,734 76,330 Weighted Average Percent 89% Non-Resident Daytime Employment Population3 33,256 27%8,908 Subtotal 33,256 8,908 Grand Total 118,990 85,237 1 2023 American Community Survey 5-Year Estimate. 2 Out-commuting resident workers per Longitudinal Employment Housing Data, 2022, U.S. Census Bureau. 3 In-commuting resident workers per Longitudinal Employment Housing Data, 2022, U.S. Census Bureau. 4 Calculated per an assumed percentage the individual is actually within the City. For example, non-resident daytime employees are assumed to be in the City 9 hours per day, 5 days per week for a total of 45 hours per week out of a total of 168 hours, this equates to 27% of the week within the City. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 77 Fiscal Impact Methodology Estimated City Service Costs City Departments FY 2025-26 Adopted Budget¹Adjustment Factor2 Total Resident- Equivalent Population3 Cost Per Resident-Equivalent General Government⁴$9,674,173 25%85,237 $28 Finance $2,213,756 10%85,237 $3 Community Development $6,622,082 25%85,237 $19 Public Works $19,890,877 90%85,237 $210 Police Services $23,106,728 90%85,237 $244 Parks & Community Services $10,346,598 90%85,237 $109 Non-Departmental $50,000 10%85,237 $0 Infrastructure Maintenance – Transfers-In/Out $631,000 100%85,237 $7 Citywide Insurance – Transfers-In/Out $1,100,000 100%85,237 $13 $73,635,214 $634 Number % of Day Resident-Equivalents Total Resident-Equivalents Resident Population⁵6,990 89%6,223 Residential Workers⁶58 27%16 Retail/Restaurant Workers⁷596 27%160 Total Resident-Equivalents 6,398 Total Cost of City Services (2025 $)$4,056,571 1 FY 2025-26 Adopted Budget, City of San Ramon; includes departmental budget appropriations (salary, expenses, and other direct costs) as well as certain related/indirect variable costs. 2 Adjustment factors based on HR&A precedent assumptions regarding the variable share of departmental budgets. 3 See Resident-Equivalent calculation, Appendix A - Table 10: City Resident-Equivalents. 4 General Government includes the expenditures of the City Council, City Manager, City Attorney, City Clerk, Human Resources, and Information Technology. 5 Estimate based on the product of residential units of market-rate versus affordable and their respective average household size. 6 Sunset Development. 7 Estimate based on IMPLAN outputs. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 78 Fiscal Impact Methodology Existing Property Tax Category Factor2 Total Assessed Value1 $177,990,000 General Levy (x Assessed Value)1.0%$1,779,900 City Share of General Levy 10.2%$181,983 MVLF In Lieu (x Assessed Value)0.024%$42,221 San Ramon Property Tax Revenue (2025 $)$224,205 1 2024 assessed value for parcel 213-120-008-7 from the Contra Costa County Assessors and includes both land and improvement value. 2 City of San Ramon Municipal Code; 3rd Amendment of City-County Tax Sharing Agreement HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 79 Fiscal Impact Methodology Tax Revenue Cash Flow – With Annual Inflation – Total Development Project 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Percent Program Constructed 0%6%32%74%100%100%100%100%100%100%100% Percent Program Delivered 0%0%0%38%100%100%100%100%100%100%100% Percent Program Absorbed 0%0%0%19%69%100%100%100%100%100%100% General Fund Revenues 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Property Tax (Construction)$0 $1,659 $60,964 $152,245 $239,200 $157,526 $110,905 $118,668 $50,219 $53,012 $32,795 MVLF In Lieu (Construction)$0 $385 $14,144 $35,322 $55,496 $36,547 $25,731 $27,532 $11,651 $12,299 $7,609 Documentary Transfer Tax (Construction)$0 $0 $0 $129,852 $508,751 $403,280 $0 $0 $0 $0 $0 Sales Tax (Construction)$0 $115,027 $608,370 $881,955 $630,068 $943,396 $542,358 $580,322 $245,587 $259,245 $160,375 Property Tax (Ongoing)$0 $0 $0 $263,568 $743,541 $1,296,794 $1,333,261 $1,672,509 $1,729,640 $1,938,776 $2,016,676 MVLF In Lieu (Ongoing)$0 $0 $0 $61,150 $172,526 $301,866 $310,347 $389,075 $402,351 $450,893 $468,988 Documentary Transfer Tax (Ongoing)$0 $0 $0 $0 $10,923 $46,220 $75,892 $84,783 $94,722 $105,831 $118,249 Franchise Tax $0 $0 $0 $4,465 $34,144 $60,814 $81,866 $95,382 $120,691 $147,388 $160,633 Sales Tax (Ongoing)$0 $0 $0 $108,243 $772,787 $1,412,477 $1,745,227 $2,045,354 $2,456,683 $2,844,309 $1,497,491 Licenses, Permits, Fees and Fines $0 $0 $0 $24,323 $144,784 $246,457 $337,074 $387,812 $500,370 $619,129 $684,966 Total Annual Revenues to City's General Fund $0 $117,071 $683,477 $1,661,121 $3,312,221 $4,905,377 $4,562,661 $5,401,437 $5,611,914 $6,430,883 $5,147,783 Less: Property Tax and MVLF Revenue from Existing Site ($224,205)($228,689)($233,262)($237,928)($242,686)($247,540)($252,491)($257,541)($262,691)($267,945)($273,304) Less: City Service Costs $0 $0 $0 ($123,615)($732,698)($1,244,060)($1,702,330)($1,957,861)($2,527,501)($3,128,593)($3,460,614) Less: City-County Tax Sharing Agreement for Sales Tax $0 $0 $0 ($54,121)($386,393)($706,238)($872,613)($1,022,677)($1,228,342)($1,422,155)($748,746) Net Fiscal Impact to City's General Fund ($224,205)($111,618)$450,215 $1,299,579 $2,336,837 $3,413,777 $2,607,840 $3,186,035 $2,821,722 $3,034,344 $1,413,865 Appreciation Annual Inflation Rate 2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Discount Rate1 11.4% 1Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 80 Fiscal Impact Methodology Tax Revenue Cash Flow – With Annual Inflation – Total Development Project – continued 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Percent Program Constructed 100%100%100%100%100%100%100%100%100%100% Percent Program Delivered 100%100%100%100%100%100%100%100%100%100% Percent Program Absorbed 100%100%100%100%100%100%100%100%100%100% General Fund Revenues 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Property Tax (Construction)$34,362 $15,130 $17,709 $52,525 $54,048 $4,431 $108,734 $111,888 $0 $0 MVLF In Lieu (Construction)$7,972 $3,510 $4,109 $12,186 $12,540 $1,028 $25,227 $25,959 $0 $0 Documentary Transfer Tax (Construction)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sales Tax (Construction)$168,042 $73,990 $86,604 $256,863 $264,312 $21,671 $531,742 $547,162 $0 $0 Property Tax (Ongoing)$2,198,610 $2,300,120 $2,457,455 $2,586,354 $2,880,727 $3,045,133 $3,228,548 $3,743,691 $3,977,857 $4,238,212 MVLF In Lieu (Ongoing)$511,220 $534,794 $571,320 $601,248 $669,569 $707,737 $750,315 $869,857 $924,211 $984,642 Documentary Transfer Tax (Ongoing)$132,133 $147,654 $165,008 $184,411 $206,107 $230,367 $257,497 $287,836 $321,767 $359,715 Franchise Tax $174,523 $185,442 $196,848 $205,259 $213,993 $229,581 $245,894 $253,025 $279,786 $307,886 Sales Tax (Ongoing)$1,576,001 $1,643,969 $1,714,555 $1,774,548 $1,836,580 $1,925,500 $2,018,033 $2,076,556 $2,210,596 $2,103,142 Licenses, Permits, Fees and Fines $754,100 $807,237 $862,822 $902,269 $943,279 $1,020,714 $1,101,847 $1,133,801 $1,270,354 $1,413,873 Total Annual Revenues to City's General Fund $5,556,963 $5,711,846 $6,076,428 $6,575,664 $7,081,155 $7,186,164 $8,267,837 $9,049,775 $8,984,571 $9,407,470 Less: Property Tax and MVLF Revenue from Existing Site ($278,770)($284,346)($290,033)($295,833)($301,750)($307,785)($313,941)($320,219)($326,624)($333,156) Less: City Service Costs ($3,809,320)($4,076,648)($4,356,336)($4,553,930)($4,759,379)($5,149,866)($5,559,058)($5,718,215)($6,408,880)($7,134,853) Less: City-County Tax Sharing Agreement for Sales Tax ($788,001)($821,985)($857,277)($887,274)($918,290)($962,750)($1,009,017)($1,038,278)($1,105,298)($1,051,571) Net Fiscal Impact to City's General Fund $1,468,873 $1,350,853 $1,430,060 $1,725,902 $2,020,025 $1,728,513 $2,394,839 $3,011,340 $2,249,068 $1,939,460 Appreciation Annual Inflation Rate 2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Discount Rate1 11.4% 1Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 81 Fiscal Impact Methodology Tax Revenue Cash Flow – With Annual Inflation – Total For-Sale Residential 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Percent Program Constructed 0%6%32%74%100%100%100%100%100%100%100% Percent Program Delivered 0%0%0%38%100%100%100%100%100%100%100% Percent Program Absorbed 0%0%0%19%69%100%100%100%100%100%100% General Fund Revenues 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Property Tax (Construction)$0 $0 $0 $83,045 $189,139 $0 $0 $0 $0 $0 $0 MVLF In Lieu (Construction)$0 $0 $0 $19,267 $43,882 $0 $0 $0 $0 $0 $0 Documentary Transfer Tax (Construction)$0 $0 $0 $129,852 $508,751 $403,280 $0 $0 $0 $0 $0 Sales Tax (Construction)$0 $64,040 $310,240 $543,548 $385,253 $0 $0 $0 $0 $0 $0 Property Tax (Ongoing)$0 $0 $0 $120,696 $596,907 $988,330 $1,018,628 $1,055,856 $1,100,654 $1,153,745 $1,215,945 MVLF In Lieu (Ongoing)$0 $0 $0 $28,002 $138,486 $229,299 $236,329 $244,966 $255,359 $267,677 $282,108 Documentary Transfer Tax (Ongoing)$0 $0 $0 $0 $10,923 $46,220 $75,892 $84,783 $94,722 $105,831 $118,249 Franchise Tax $0 $0 $0 $4,465 $16,845 $25,212 $25,943 $26,695 $27,470 $28,266 $29,086 Sales Tax (Ongoing)$0 $0 $0 $43,064 $201,207 $322,889 $332,253 $341,888 $351,803 $362,005 $186,252 Licenses, Permits, Fees and Fines $0 $0 $0 $24,323 $91,708 $137,227 $141,206 $145,301 $149,515 $153,851 $158,313 Total Annual Revenues to City's General Fund $0 $64,040 $310,240 $996,261 $2,183,101 $2,152,457 $1,830,251 $1,899,491 $1,979,523 $2,071,375 $1,989,952 Less: City Service Costs $0 $0 $0 ($123,615)($462,910)($688,837)($706,758)($725,199)($744,175)($763,701)($783,794) Net Fiscal Impact to City's General Fund $0 $64,040 $310,240 $872,646 $1,720,191 $1,463,620 $1,123,493 $1,174,292 $1,235,348 $1,307,673 $1,206,159 Annual Inflation Rate 2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Housing Appreciation Rate 9.0% Discount Rate1 11.4% 1Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 82 Fiscal Impact Methodology Tax Revenue Cash Flow – With Annual Inflation – Total For-Sale Residential – continued 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Percent Program Constructed 100%100%100%100%100%100%100%100%100%100% Percent Program Delivered 100%100%100%100%100%100%100%100%100%100% Percent Program Absorbed 100%100%100%100%100%100%100%100%100%100% General Fund Revenues 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Property Tax (Construction)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 MVLF In Lieu (Construction)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Documentary Transfer Tax (Construction)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sales Tax (Construction)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Property Tax (Ongoing)$1,288,176 $1,371,478 $1,467,017 $1,576,108 $1,700,223 $1,841,019 $2,000,351 $2,180,300 $2,383,199 $2,611,660 MVLF In Lieu (Ongoing)$298,866 $318,192 $340,358 $365,668 $394,463 $427,129 $464,095 $505,845 $552,919 $605,923 Documentary Transfer Tax (Ongoing)$132,133 $147,654 $165,008 $184,411 $206,107 $230,367 $257,497 $287,836 $321,767 $359,715 Franchise Tax $29,929 $30,797 $31,690 $32,609 $33,555 $34,528 $35,530 $36,560 $37,620 $38,711 Sales Tax (Ongoing)$191,653 $197,211 $202,930 $208,815 $214,871 $221,102 $227,514 $234,112 $240,901 $247,887 Licenses, Permits, Fees and Fines $162,904 $167,628 $172,489 $177,491 $182,639 $187,935 $193,385 $198,994 $204,764 $210,703 Total Annual Revenues to City's General Fund $2,103,661 $2,232,961 $2,379,493 $2,545,102 $2,731,858 $2,942,081 $3,178,372 $3,443,646 $3,741,170 $4,074,599 Less: City Service Costs ($804,469)($825,743)($847,635)($870,161)($893,341)($917,193)($941,737)($966,992)($992,980)($1,019,721) Net Fiscal Impact to City's General Fund $1,299,193 $1,407,217 $1,531,858 $1,674,941 $1,838,517 $2,024,888 $2,236,635 $2,476,655 $2,748,190 $3,054,877 Annual Inflation Rate 2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Housing Appreciation Rate 9.0% Discount Rate1 11.4% 1Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 83 Fiscal Impact Methodology Tax Revenue Cash Flow – With Annual Inflation – Total Multifamily (Single-Use) 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Percent Program Constructed 0%0%0%0%0%16%26%37%44%51%55% Percent Program Delivered 0%0%0%0%0%0%8%31%31%46%46% Percent Program Absorbed 0%0%0%0%0%0%8%8%19%31%39% General Fund Revenues 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Property Tax (Construction)$0 $0 $0 $0 $2,075 $104,680 $70,412 $74,500 $50,219 $53,012 $32,795 MVLF In Lieu (Construction)$0 $0 $0 $0 $481 $24,287 $16,336 $17,285 $11,651 $12,299 $7,609 Sales Tax (Construction)$0 $0 $0 $0 $10,146 $511,917 $344,333 $364,327 $245,587 $259,245 $160,375 Property Tax (Ongoing)$0 $0 $0 $0 $905 $47,949 $48,908 $251,037 $256,057 $404,644 $412,737 MVLF In Lieu (Ongoing)$0 $0 $0 $0 $229 $12,126 $12,368 $59,284 $60,470 $94,964 $96,863 Documentary Transfer Tax Franchise Tax $0 $0 $0 $0 $0 $0 $8,460 $8,705 $21,535 $35,102 $45,091 Sales Tax (Ongoing)$0 $0 $0 $0 $0 $0 $38,586 $39,705 $136,461 $238,796 $156,955 Licenses, Permits, Fees and Fines $0 $0 $0 $0 $0 $0 $43,661 $44,927 $113,364 $185,733 $239,000 Total Annual Revenues to City's General Fund $0 $0 $0 $0 $13,835 $700,959 $583,064 $859,770 $895,345 $1,283,795 $1,151,425 Less: City Service Costs $0 $0 $0 $0 $0 $0 ($221,897)($228,332)($576,145)($943,939)($1,214,660) Net Fiscal Impact to City's General Fund $0 $0 $0 $0 $13,835 $700,959 $361,166 $631,438 $319,200 $339,856 ($63,235) Annual Inflation Rate 2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Discount Rate1 11.4% 1Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 84 Fiscal Impact Methodology Tax Revenue Cash Flow – With Annual Inflation – Total Multifamily (Single-Use) – continued 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Percent Program Constructed 60%62%64%70%76%77%88%100%100%100% Percent Program Delivered 56%56%60%60%74%74%74%100%100%100% Percent Program Absorbed 46%51%56%58%60%67%74%74%87%100% General Fund Revenues 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Property Tax (Construction)$34,362 $15,130 $17,709 $52,525 $54,048 $4,431 $108,734 $111,888 $0 $0 MVLF In Lieu (Construction)$7,972 $3,510 $4,109 $12,186 $12,540 $1,028 $25,227 $25,959 $0 $0 Sales Tax (Construction)$168,042 $73,990 $86,604 $256,863 $264,312 $21,671 $531,742 $547,162 $0 $0 Property Tax (Ongoing)$514,679 $524,972 $578,695 $590,269 $752,127 $767,169 $782,513 $1,108,793 $1,130,969 $1,153,588 MVLF In Lieu (Ongoing)$120,537 $122,947 $135,434 $138,143 $175,719 $179,233 $182,818 $258,543 $263,714 $268,988 Documentary Transfer Tax Franchise Tax $55,630 $63,101 $70,959 $75,720 $80,696 $92,419 $104,754 $107,792 $130,342 $154,108 Sales Tax (Ongoing)$196,589 $224,554 $253,977 $271,614 $290,060 $334,131 $380,514 $391,549 $476,724 $566,510 Licenses, Permits, Fees and Fines $295,202 $335,031 $376,921 $402,278 $428,788 $491,303 $557,083 $573,238 $693,535 $820,327 Total Annual Revenues to City's General Fund $1,393,012 $1,363,235 $1,524,408 $1,799,596 $2,058,289 $1,891,386 $2,673,385 $3,124,924 $2,695,283 $2,963,521 Less: City Service Costs ($1,500,288)($1,702,709)($1,915,608)($2,044,476)($2,179,206)($2,496,923)($2,831,234)($2,913,340)($3,524,717)($4,169,105) Net Fiscal Impact to City's General Fund ($107,276)($339,474)($391,201)($244,879)($120,917)($605,536)($157,848)$211,584 ($829,435)($1,205,585) Annual Inflation Rate 2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Discount Rate1 11.4% 1Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 85 Fiscal Impact Methodology Tax Revenue Cash Flow – With Annual Inflation – Total Multifamily (Mixed-Use) 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Percent Program Constructed 0%1%21%44%59%75%87%100%100%100%100% Percent Program Delivered 0%0%0%43%43%75%75%100%100%100%100% Percent Program Absorbed 0%0%0%0%22%43%59%75%87%100%100% General Fund Revenues 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Property Tax (Construction)$0 $1,659 $60,964 $69,200 $47,987 $52,846 $40,494 $44,168 $0 $0 $0 MVLF In Lieu (Construction)$0 $385 $14,144 $16,055 $11,133 $12,261 $9,395 $10,247 $0 $0 $0 Sales Tax (Construction)$0 $8,113 $298,130 $338,407 $234,670 $258,430 $198,025 $215,995 $0 $0 $0 Property Tax (Ongoing)$0 $0 $0 $142,873 $145,730 $260,515 $265,725 $365,616 $372,928 $380,387 $387,995 MVLF In Lieu (Ongoing)$0 $0 $0 $33,147 $33,810 $60,441 $61,650 $84,825 $86,522 $88,252 $90,017 Documentary Transfer Tax Franchise Tax $0 $0 $0 $0 $17,300 $35,602 $47,463 $59,981 $71,686 $84,020 $86,456 Sales Tax (Ongoing)$0 $0 $0 $65,179 $571,580 $1,089,588 $1,374,388 $1,663,760 $1,968,419 $2,243,508 $1,154,285 Licenses, Permits, Fees and Fines $0 $0 $0 $0 $53,076 $109,230 $152,206 $197,583 $237,490 $279,546 $287,653 Total Annual Revenues to City's General Fund $0 $10,157 $373,238 $664,860 $1,115,285 $1,878,912 $2,149,346 $2,642,176 $2,737,046 $3,075,713 $2,006,406 Less: City Service Costs $0 $0 $0 $0 ($269,788)($555,224)($773,675)($1,004,329)($1,207,181)($1,420,953)($1,462,160) Net Fiscal Impact to City's General Fund $0 $10,157 $373,238 $664,860 $845,497 $1,323,688 $1,375,671 $1,637,847 $1,529,865 $1,654,760 $544,246 Annual Inflation Rate 2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Discount Rate1 11.4% 1Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders. HR&A Advisors, Inc. Orchards at Bishop Ranch Economic and Fiscal Analysis | 86 Fiscal Impact Methodology Tax Revenue Cash Flow – With Annual Inflation – Total Multifamily (Mixed-Use) 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Percent Program Constructed 100%100%100%100%100%100%100%100%100%100% Percent Program Delivered 100%100%100%100%100%100%100%100%100%100% Percent Program Absorbed 100%100%100%100%100%100%100%100%100%100% General Fund Revenues 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 Property Tax (Construction)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 MVLF In Lieu (Construction)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sales Tax (Construction)$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Property Tax (Ongoing)$395,755 $403,670 $411,743 $419,978 $428,378 $436,945 $445,684 $454,598 $463,690 $472,963 MVLF In Lieu (Ongoing)$91,818 $93,654 $95,527 $97,438 $99,387 $101,374 $103,402 $105,470 $107,579 $109,731 Documentary Transfer Tax Franchise Tax $88,964 $91,544 $94,198 $96,930 $99,741 $102,634 $105,610 $108,673 $111,824 $115,067 Sales Tax (Ongoing)$1,187,759 $1,222,204 $1,257,648 $1,294,120 $1,331,649 $1,370,267 $1,410,005 $1,450,895 $1,492,971 $1,288,745 Licenses, Permits, Fees and Fines $295,995 $304,578 $313,411 $322,500 $331,853 $341,476 $351,379 $361,569 $372,055 $382,844 Total Annual Revenues to City's General Fund $2,060,290 $2,115,650 $2,172,528 $2,230,966 $2,291,007 $2,352,696 $2,416,080 $2,481,204 $2,548,118 $2,369,350 Less: City Service Costs ($1,504,563)($1,548,195)($1,593,093)($1,639,293)($1,686,832)($1,735,750)($1,786,087)($1,837,884)($1,891,182)($1,946,027) Net Fiscal Impact to City's General Fund $555,727 $567,454 $579,435 $591,673 $604,175 $616,946 $629,992 $643,320 $656,936 $423,324 Annual Inflation Rate 2.9% Annual Inflation Rate (Property Tax and MVLF In Lieu)2.0% Discount Rate1 11.4% 1Discount rate of 11.4% based on the weighted average cost of capital (WACC) for major national homebuilders.