March 21, 2023 – Version 1.3.4 Update: The Calculator’s Tab 2. Portfolio Summary (BCC) square footage calculations have been updated, due to some users reporting square footage inaccuracies in Version 1.3.3. SAHF recommends all users downloading and using this new version.
The SAHF Multifamily Portfolio Carbon Emissions Calculator ("the Calculator") allows multifamily portfolio owners to calculate their annual greenhouse gas (GHG) emissions in CO2 equivalent ("carbon emissions"). The Calculator was created to allow multifamily portfolio owners understand their carbon emissions baseline based on actual and estimated data, providing them with the first step of the journey to measurable carbon reductions.
- Quantifies annual Scope 1 Direct and Scope 2 Indirect carbon emissions from property-level energy and water data
- Provides annual carbon emissions for 2016 through 2020
- Allows for the import of ENERGY STAR Portfolio Manager data
- Aligns with the DOE Better Climate Challenge baseline calculation protocols
The Calculator allows for users to import data from ENERGY STAR Portfolio Manager or provide data from other sources. For properties with incomplete utility data (e.g. properties that do not have access to resident utility data), the Calculator provides estimated carbon emissions based on a calculated baseline using aggregated actual utility data from similarly located multifamily housing properties.
The Calculator will be easiest to use and most accurate for portfolio owners that have been collecting energy data for most or all properties for at least a year. The Calculator can be used by portfolio owners that have only some or even no properties that have energy data, but the results will then be based on an assumed baselines and are estimates only. As the number of properties using this assumed baseline increases, the accuracy of the Calculator's results decreases.
The Calculator was developed with the intention of being used by multifamily portfolio owners of all sizes and capacities. To support broad use, SAHF has designed the Calculator to be accessible to users with versions of Excel after 2007. However, because this tool was developed in Excel 2021, users with prior versions will be able to produce accurate results, but may notice some reduced functionality.
SAHF would like to thank Wells Fargo and the Wells Fargo Foundation for their generous support in development of the Calculator and accompanying resources.
SAHF Multifamily Portfolio Carbon Emissions Calculator
SAHF Calculator Detailed Instructions
If you have feedback, please send comments via email to [email protected].