I need to get a formula that will give me the total houses sold per year.
example. 233 houses houses sold in county 1.07% per year.
In how many years am I going to sale the 233 houses?
Any help will be appreciated.

You need some kind of sales data. Need more info.

"Fher C." wrote:

I need to get a formula that will give me the total houses sold per year.
example. 233 houses houses sold in county 1.07% per year.
In how many years am I going to sale the 233 houses?
Any help will be appreciated.

I only have this information, the year to Date average is 1.07. They want to
know how many houses could be sold in one year base on the Year to Date
Average percentage.

"John Bundy" wrote:

You need some kind of sales data. Need more info.

"Fher C." wrote:

I need to get a formula that will give me the total houses sold per year.
example. 233 houses houses sold in county 1.07% per year.
In how many years am I going to sale the 233 houses?
Any help will be appreciated.

Are you saying that your company sells an average of 1.07% of all of the
houses in the county? If so you just multiply total sold by 1.07. If you want
to know for the year divide the total number sold by days in the year so far
to get the daily average, multiply that by 365 to get yearly projection, then
multiply by 1.07 to get your estimated number sold.

-John

"Fher C." wrote:

I only have this information, the year to Date average is 1.07. They want to
know how many houses could be sold in one year base on the Year to Date
Average percentage.

"John Bundy" wrote:

You need some kind of sales data. Need more info.

"Fher C." wrote:

I need to get a formula that will give me the total houses sold per year.
example. 233 houses houses sold in county 1.07% per year.
In how many years am I going to sale the 233 houses?
Any help will be appreciated.

No, my boss wants to know how many houses are we going to sale based on the
absorption rate. For example: in contra costa county we have a community, the
absorption rate in the area is 1.07%, we have 233 houses in that community.
He wants to know how many houses are going to be sold based on the absorption
rate in that county. We haven't sold any houses, I think it is easy when you
have some data. This is what I was trying to do. A1 233 B1 1.07% C1
=(A1/B1)/(52weeks in one year)/52 = 5.07 years

233/5.07= 45.96 houses per year. am I doing this right?


"John Bundy" wrote:

Are you saying that your company sells an average of 1.07% of all of the
houses in the county? If so you just multiply total sold by 1.07. If you want
to know for the year divide the total number sold by days in the year so far
to get the daily average, multiply that by 365 to get yearly projection, then
multiply by 1.07 to get your estimated number sold.

-John

"Fher C." wrote:

I only have this information, the year to Date average is 1.07. They want to
know how many houses could be sold in one year base on the Year to Date
Average percentage.

"John Bundy" wrote:

You need some kind of sales data. Need more info.

"Fher C." wrote:

I need to get a formula that will give me the total houses sold per year.
example. 233 houses houses sold in county 1.07% per year.
In how many years am I going to sale the 233 houses?
Any help will be appreciated.

Assuming that the given 1.07% is yearly absorption rate you just multiply
houses*absorption rate, that is how many per year. This btw is wildly
innaccurate at predicting housing trends, build the wrong house at the wrong
price and math won't help, you can't put an equation on buying habits that
easily. All things equal however and this should be fairly accurate.

"Fher C." wrote:

No, my boss wants to know how many houses are we going to sale based on the
absorption rate. For example: in contra costa county we have a community, the
absorption rate in the area is 1.07%, we have 233 houses in that community.
He wants to know how many houses are going to be sold based on the absorption
rate in that county. We haven't sold any houses, I think it is easy when you
have some data. This is what I was trying to do. A1 233 B1 1.07% C1
=(A1/B1)/(52weeks in one year)/52 = 5.07 years

233/5.07= 45.96 houses per year. am I doing this right?


"John Bundy" wrote:

Are you saying that your company sells an average of 1.07% of all of the
houses in the county? If so you just multiply total sold by 1.07. If you want
to know for the year divide the total number sold by days in the year so far
to get the daily average, multiply that by 365 to get yearly projection, then
multiply by 1.07 to get your estimated number sold.

-John

"Fher C." wrote:

I only have this information, the year to Date average is 1.07. They want to
know how many houses could be sold in one year base on the Year to Date
Average percentage.

"John Bundy" wrote:

You need some kind of sales data. Need more info.

"Fher C." wrote:

I need to get a formula that will give me the total houses sold per year.
example. 233 houses houses sold in county 1.07% per year.
In how many years am I going to sale the 233 houses?
Any help will be appreciated.

Thank you very much for your help.
Have a wonderful day!!!

"John Bundy" wrote:

Assuming that the given 1.07% is yearly absorption rate you just multiply
houses*absorption rate, that is how many per year. This btw is wildly
innaccurate at predicting housing trends, build the wrong house at the wrong
price and math won't help, you can't put an equation on buying habits that
easily. All things equal however and this should be fairly accurate.

"Fher C." wrote:

No, my boss wants to know how many houses are we going to sale based on the
absorption rate. For example: in contra costa county we have a community, the
absorption rate in the area is 1.07%, we have 233 houses in that community.
He wants to know how many houses are going to be sold based on the absorption
rate in that county. We haven't sold any houses, I think it is easy when you
have some data. This is what I was trying to do. A1 233 B1 1.07% C1
=(A1/B1)/(52weeks in one year)/52 = 5.07 years

233/5.07= 45.96 houses per year. am I doing this right?


"John Bundy" wrote:

Are you saying that your company sells an average of 1.07% of all of the
houses in the county? If so you just multiply total sold by 1.07. If you want
to know for the year divide the total number sold by days in the year so far
to get the daily average, multiply that by 365 to get yearly projection, then
multiply by 1.07 to get your estimated number sold.

-John

"Fher C." wrote:

I only have this information, the year to Date average is 1.07. They want to
know how many houses could be sold in one year base on the Year to Date
Average percentage.

"John Bundy" wrote:

You need some kind of sales data. Need more info.

"Fher C." wrote:

I need to get a formula that will give me the total houses sold per year.
example. 233 houses houses sold in county 1.07% per year.
In how many years am I going to sale the 233 houses?
Any help will be appreciated.