My main fear is that I've underestimated my Opex assumptions or will miss some major issue during inspection that will turn the deal into an alligator property.For the last 4 months I've been stuck in analysis paralysis and haven't been able to just pull the trigger on a deal.

Far too many get stuck in the "paralysis by analysis" stage, thinking they just don't know enough to get started.

Your insights on potential risks and pitfalls associated with this acquisition would be invaluable in guiding my decision-making process.Thank you for your assistance.https://www.biggerpockets.com/analysis/rentals/8cd3ed2b-b98d...Thanks, Krishna

Anyone use a good, easy, and accurate tool to get comparable sales or rents in a location?For example, you want to buy a duplex for $400k and after spending $25k in renovation, what would be an estimated but accurate ...

As far as more technical financial analysis you mentioned above, I have found it is easiest to track these items in excel - I just update the workbook each time I analyze.

Can someone recommend a VERY simple app or software program for analysis and bookkeeping?

As part of your deal analysis, you need to do a Risk analysis on the location.

I think I've hit the analysis paralysis stage, and trying to get over it.Should I get over the anxiety and pull the trigger, or should I look at other creative ideas to build the portfolio over time? 

I’d have to take some time to do some thorough research on STR as a strategy and do a thorough market analysis.

And, even if you could find an appraiser to do an evaluation, it's not clear how that would help you.As you state, the motel has been shut down for nearly three years, so there's no current financial data.But even if you had recent numbers, you're planning to operate it as a sober living facility, which I suspect is a very different business model.You need to find a comparable facility in or near your local market and develop your own customized financial analysis model based upon this particular property.Then, given your business objectives (cash flow and cash-on-cash return, I assume), you'll need to back into what purchase terms you'll need to achieve those objectives.Only then will you be able to determine whether these seller financing terms will work.As far as documentation to get started, a letter of intent (LOI) is commonly used but you might move straight to a purchase and sale agreement, particularly if no agent is involved.Whichever path you choose, just be certain to give yourself plenty of time to thoroughly perform your due-diligence.