How do you run your numbers?

[David Haynes]

I'm a numbers guy. I know that BiggerPockets has its own calculators, but I'm also hands-on. I'd rather understand the math and the formulas behind the profit margin. Here's my first attempt at creating a detailed spreadsheet for basic number running. There's always room for improvement, so I wanted to share this with the BP community to hear other perspectives and insights.

I created this sheet specifically for the Philly market, so that is why you will see drop-down lists for transfer taxes. They differ by county and can be split or full. The counties I do business in are Philadelphia, Montgomery County, and Delaware County. I also added an option for assignment fees when using a wholesaler. I also made it possible to view each property as a flip or rental in order to aid me in deciding which is best. Another option allows me to see the difference between using cash or a HML. I have attached a screenshot of each section of the spreadsheet.

The deal that I plugged the numbers in for is in South Philly within Girard Estates 19145. Amazingly, it looks like a great deal for either strategy, but I'm open to feedback on both the deal and spreadsheet.

[JD Martin]

So $30k more for the flip only grosses you $5k more on the ARV? I guess I would question whether the more expensive rehab made sense at that point.