Introduction (Please Read):
This document will provide you with an explanation of how REALHOUND CRM conducts Weighted Average calculations. Every effort has been made to make our reports statistically accurate. Because of this, some of our averages may calculate out different than yours, as REALHOUND CRM uses a true weighted average to determine overall averages. The example below illustrates this.
Let’s say that we have five apartment buildings for which we want to determine the overall average rent. The complexes and rents are:
|Name||Type||Square Feet||Units||Low Rent||High Rent||Total Low||Total High||Total SF|
First, you have to review all of the different unit types of all of the properties you want to average. Then, on a unit type by unit type basis, calculate the total low rent and total high rent by multiplying the respective rents by the number of units for that type. Calculate the total square feet by multiplying the unit’s square feet by the number of units. Then, sum up the total rents and total square feet columns.
Now, to calculate the average square feet per unit, divide the total square feet by the number of units. This will weight the average by the number of units, thus, the larger complexes will have more “weight” then the smaller ones.
To calculate the overall average rent, you first need to determine the average of the low and high rents. Because there are typically more low rent units than high rent ones, REALHOUND IP has an option on the Report Options screen to use a 2/3 weighting on this calculation. The calculation is ((low rent x 2) + High Rent)/3. If there is no high rent, then the low rent is substituted for it. After you have calculated the 2/3 weighted average of the total low and total high, divide this number by the total number of units. Here is the answer:
Average Rent = $1,088
Average SF = 764