SFH flip in Grand Junction, CO
I would like feedback on a rough analysis. Information gleamed from realtor and trulia.com and verified with the County Assessor. The construction estimate is extremely rough: My sense of construction cost is improving, and i am evaluating based on listing images only.
High AVG calculates the top 3 most expensive Price per square foot on comps (=AVERAGE(G3:G5))
Med AVG calculates all 4 PPSF comps
Low AVG calculates the lowest 3 PPSF comps
HARV, MARV, and LARV multiplies the High AVG, Med AVG and Low AVG with the subject property square footage (=F9*D2) to give us our after repair value.
The H,M,L spread take the ARV and subtracts it from the asking price. (=H9-F2) This would be my spread if I were to purchase the property at asking price.
H, M, L purchase multiplies the ARV by 70% and subtracts my estimated construction costs of 20K. (=(H9*0.7)-20000) This will be my offer in order to use a hard money lender to finance the purchase and the construction.
H,M,L, purchase spread subtracts "purchase price" from "ARV" and subtracts our construction cost of 20K (=H9-L9-20000) to get our after repair profit.
This does not factor closing and carrying costs.