What tools do you actually use to analyze a deal before making an offer?

Question

Been going deep on the deal analysis process lately talking to a lot of first-time investors about their workflow before they make an offer.

What I keep hearing: people are stitching together 3–4 different tools (spreadsheets, Mashvisor, DealCheck, Zillow, random calculators) and still not feeling confident in their numbers.

Curious what this community actually uses. Specifically:

What does your workflow look like from "I found an interesting property" to "I'm making an offer"?

What do you wish existed that doesn't?

For those who've passed on a deal. How did you arrive at that decision?

Not selling anything. Building something in this space and trying to understand the real workflow before I build the wrong thing.

George Marshall · Answer

Great thread. One thing I don't see mentioned here that's bitten me before — title and lien status before the offer.

Most of the tools above nail the financial side (DealCheck is solid for MAO, agree with Jake on that). But I've walked into auctions and off-market deals where the numbers worked and the title didn't — IRS redemption rights, mechanics liens from a prior contractor, HOA super-liens that survived the foreclosure, municipal code violations running with the land.

None of that shows up in a spreadsheet.

What I added to my pre-offer workflow: a quick public-record title snapshot before I get too deep. I use TitlePin for this — it pulls deed history, open liens, and tax status into a PDF in a few minutes. Not a replacement for a full title search at closing, but enough to know if a deal has a hidden problem before I spend time underwriting it.

Saved me from two bad auction bids this year alone.

Curious if anyone else has a title check step in their pre-offer process or if most people are waiting until contract?

Jake Baker · Answer

@Mateo Yanez Barbosa

The biggest thing for me is defining your buy box and being strict about it. Pick a property type and investment strategy that you know will work for you time and time again, and don't deviate. From there, the workflow becomes very repeatable. I have saved searches set up in Zillow, and I also look at what wholesalers send me. When something comes in that fits the box, I plug it into a repeatable template I built in DealCheck to back into my maximum allowable offer (MAO), which takes all the emotion out of the negotiation. I'll also run it through RealAI using a repeatable prompt to get another layer of analysis. If I start gaining traction on the deal, that's when I have my agent and contractor walk the property together to make sure my numbers actually align with reality before I move forward.

Ryan Stomel · Answer

On the commercial side, the workflow is pretty different from what most first-time investors describe. The tools people stitch together for residential analysis don't really translate because the inputs are fundamentally different — you're not underwriting based on market rent comps, you're underwriting a specific lease, or the absence of one.

How I actually move from "interesting property" to offer on a small commercial deal:

First filter is the rent roll and lease abstracts. Before I run a single number, I want to see the actual leases. How many years left, rent escalation schedule, what expenses the tenant covers, any co-tenancy clauses or kick-out provisions. A deal that looks great on asking cap rate can fall apart completely once you read the lease. That part isn't a tool problem — it's just reading the documents.

Second is rebuilding NOI from scratch. I don't trust the seller's numbers. I take the rent roll, apply the actual expense pass-throughs from the leases, use my own management cost and maintenance assumptions, and build the income statement myself in a spreadsheet. For NNN deals this means calculating what the tenant actually owes versus what the listing says.

Third is the rent-to-market check. Is the current rent above, at, or below what you could get today? That tells you whether the deal is priced on a going-in yield that's sustainable or one that assumes renewal at the same rate.

On what I wish existed: a tool that actually connects lease data to accounting data so you're not reconciling by hand every time. The "did tenant pay what they owe" question for NNN and CAM reimbursements is more work than it should be. That's the gap that hasn't been solved at the small portfolio level.

Ryan Stomel · Answer

@Christian Spencer — good question. From the commercial side, it's both, but they show up at different stages.

The input trust problem comes first. For residential investors it's rent estimates — are the Zillow/RentCast numbers actually what this unit will lease for in this condition in this micro-market. On the commercial side it's even harder because there often aren't good comps. You're looking at a retail strip with one vacancy and trying to estimate achievable rent for a space that's been dark for 18 months. That's not a tool problem, that's a market knowledge problem, and no software solves it.

The "what numbers matter and in what order" problem is actually worse for first-timers and it's underserved. Residential underwriting has a relatively standard sequence that a lot of tools walk you through — rent, vacancy, expenses, NOI, debt service, cash-on-cash. Commercial deals have that same skeleton but with 10 variables that can change the answer completely before you even get to cap rate math: lease structure, remaining term, rollover risk, tenant credit, expense recovery language, etc. Most people don't know what to look at first, so they run the cap rate math and stop.

The "analysis vs portfolio" gap you mentioned is the right insight. That's where most tools leave you — they're great at deal analysis but the underwriting assumptions disappear into a file folder. Whether the deal performed to your assumptions is a question most operators can't answer without going back and manually rebuilding the original model. That's a real gap.

Masoud Arouni · Answer

@Mateo Yanez Barbosa, my workflow evolved after getting frustrated with exactly what you described.

First pass is always a gut check on two numbers. Does the rent hit 1% of purchase price, and does the expense ratio stay under 50% of gross rent. That rule breaks down fast in expensive markets like California where almost nothing clears 1%, but it still works as a directional filter. If a deal fails it badly with no compelling appreciation story to explain the gap, I move on in under two minutes. Most deals die here.

If it passes I run four numbers: gross rent, operating expenses, mortgage payment, and net cash flow. Cap rate to understand the asset value independent of my financing. Cash-on-cash to understand the return on my actual dollars in. That's the whole first-pass model.

What I wish existed and eventually built for myself, is a single input screen where I drop in an address, purchase price, rent, and expected expenses and immediately see how the deal stress-tests across vacancy, rate, and expense scenarios simultaneously. On expenses, a starting rule of thumb is 25% of gross rent for a newer property in good condition, scaling up to 45-50% for older properties with deferred maintenance or high HOA situations. Most people underestimate this number and that is where the spreadsheet confidence breaks down.

Not a base case. Three scenarios at once. Because the base case almost never kills deals. The downside does.

The confidence gap isn't a data problem. It's a framework problem. Most tools give you outputs but don't teach you which outputs to distrust first.-Masoud Arouni

Chris Lin · Answer

I invest out of state. Started learning by manually scrolling Zillow & Redfin, running numbers in spreadsheets to figure out anything that's more than 12% on paper. After a while, my workflow now consists of using a tool to scan the market that gives me ROI on each property on the market, then go into deeper view if the tool finds something matching my buy box.

Every morning I get a short list of properties that fit my minimum ROI — if something looks good, I run a full analysis with my own financing assumptions, and stress test the deal with different rent and interest rate scenarios (e.g. how much rent would drop or how much interest rate will rise until I start losing money). Then if everything checks out, I send my local agent there to do a video tour and make a decision from there.

Finding a strong investor-focused local agent is my key to close the loop — they are my boots on the ground for both visual confirmation and neighborhood validation.

James McGovern · Answer

I purchase foreclosure auction properties and wish there was a tool that could retrieve all of the necessary information hidden in court filings

What tools do you actually use to analyze a deal before making an offer?

Most Popular Reply