SFH flip in Grand Junction, CO

[Samuel Hall]

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.