Erie Real Estate Investing & Real Estate Financial Planning™ Podcast · James Orr

Secrets of Analyzing Deals

·1 hr 20 min·5 clips

Discover how the world's greatest real estate spreadsheet lets you track your investment performance year by year.

This episode is a module from the Real Estate Investing Secrets course, hosted by James Orr, focusing on the analytical process for rental property investments. Orr demonstrates his proprietary spreadsheet tool, which he calls the world's greatest real estate investor spreadsheet, for evaluating and tracking deals. He begins by entering a sample property with an after-repaired value of $295,000 and a purchase price of $285,000, representing a $10,000 discount. Orr argues that paying full price for a high-quality "wonderful" property can be a better long-term strategy than chasing steep discounts on inferior assets, paraphrasing a Warren Buffett principle. The analysis includes a 20% down payment and estimates closing costs at 1% of the purchase price, though he advises getting precise figures from a lender later. Orr explains that seller concessions, where a seller contributes to buyer closing costs, reduce the initial cash needed and can improve the calculated return on investment. He details "rent ready costs," which cover repairs or account for initial below-market rent, like honoring an existing $1,500 lease when market rent is $2,000. The spreadsheet also calculates "cumulative negative cashflow," which Orr describes as effectively financing the down payment if you put less money down. A key insight is his rough rule that for every $10,000 extra in down payment, monthly cashflow improves by about $50, meaning avoiding $100 in negative monthly cashflow might require an additional $20,000 down. He notes private mortgage insurance is required for down payments below 20% to protect the lender. The tool allows users to override assumptions for future years to track a property's actual performance over time, not just at purchase. The tone is instructional and methodical, mirroring a classroom lecture or software tutorial. Orr speaks directly to the listener, walking through each spreadsheet field with clear definitions and practical examples. This episode is ideal for new or analytical real estate investors seeking a systematic, spreadsheet-based approach to evaluating rental properties. Listeners looking for deal-sourcing stories, guest interviews, or advanced creative financing strategies might find it too basic or software-focused.

As heard by us

A practical walkthrough of the numbers behind Erie rental deal analysis.

This walkthrough treats deal analysis like a working underwriting session, with James Orr moving through the spreadsheet the way an investor would: monthly rent, other income, vacancy, and the assumptions that shape cash flow.

Read the full review in PlayNext →

Why you'd press play

Use the spreadsheet before you commit to the deal.

Read the full recommendation in PlayNext →

Listen to the show on

Apple Podcasts Spotify

Play clips from this episode More from Erie Real Estate Investing & Real Estate Financial Planning™ Podcast