Skip to content
×
PRO Members Get
Full Access
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime.
Level up your investing with Pro
Explore exclusive tools and resources to start, grow, or optimize your portfolio.
10+ investment analysis calculators
$1,000+/yr savings on landlord software
Lawyer-reviewed lease forms (annual only)
Unlimited access to the Forums

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
×
Take Your Forum Experience
to the Next Level
Create a free account and join over 3 million investors sharing
their journeys and helping each other succeed.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
Already a member?  Login here
Followed Discussions Followed Categories Followed People Followed Locations
Rehabbing & House Flipping
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated over 17 years ago on . Most recent reply

User Stats

141
Posts
25
Votes
Jeff Weissman
  • Involved In Real Estate
  • Oakland, CA
25
Votes |
141
Posts

Excel Spreadsheet for Deal Analysis

Jeff Weissman
  • Involved In Real Estate
  • Oakland, CA
Posted

Anybody out there who is an experienced rehabber willing to share an accurate, modifiable Excel spreadsheet with me? I'm looking at lots of houses ripe for rehab & need a quick & accurate way to evaluate them in order to decide whether to invest more time to hone the numbers, decide if there's sufficient profit to be made, and make an offer. I'd like to be able to plug in a house's sq. footage, the price per sq. ft. I can expect to sell for (based on my analysis of comps/BPO/CMA), my MAO (max. allowable offer) or PP, the private equity financing costs coupled w/ my down payment, my estimate of rehab cost and have the formulas in place so the spreadsheet will calculate approx. before tax net gain on the deal both in hard dollar terms and in % ROI.
I've looked, but haven't found any decent, free, online spreadsheets or calculators to do this. Stayed up most of the night last week trying to design my own, but lacking an accounting or finance background found the task daunting!
Any help with this would be much appreciated!!! Thanks in advance!!! :D

Loading replies...