The Best Real Estate Deal Analysis Spreadsheet Ever… FREE!

Why start your real estate investment journey from scratch? The Real Estate Financial Planner™ team offers countless resources and tools to help you make the most of your investments, including The World's Greatest Real Estate Deal Analysis Spreadsheet™ for for free.

The World's Greatest Real Estate Deal Analysis Spreadsheet™

Version: Latest version is version 4.30 on June 10, 2020 which includes both the original spreadsheet (shown above) and a simpler version for quick analysis.

Download Your Free Analysis Spreadsheet [.xlsm]

Gone are the days of:

  • Buying unprofitable properties because you did not run the numbers — or worse, because you ran the numbers wrong
  • Getting stuck with loser, cash-flow-sucking dogs of properties that don't put money in your pocket each month
  • Worrying about a math error somewhere in your spreadsheet
  • Taking hours to analyze each property just to find out it is a non-deal

The Evolution of The Spreadsheet

When my best friend Brian Williams first put together The World's Greatest Real Estate Deal Analysis Spreadsheet™ he wanted to make sure it met four criteria:

  1. It was quick and easy to use for analyzing potential properties he wanted to buy.
  2. It was accurate, with no math errors.
  3. It could model basic buy-and-hold purchases of single-family homes.
  4. It could also handle more sophisticated strategies, such as buying multi-family properties, apartments, retail space, and industrial properties, as well as lease-options, subject-to, partnerships, and more

So he built the very first version to use for himself and began using to start buying rental properties. The more he used it, the more improvements he made.

Then, we began to teach deal analysis classes for real estate investors using the spreadsheet, and we got feedback from a wide array of real estate investors, including both first-time newbie investors and sophisticated, battle-hardened apartment buyers. Brian made improvements and used it himself. Others began to use the spreadsheet and shared what they loved about it and what Brian could do to make it better.

Brian toiled for hours and hours and hours over a period of years to perfect The World’s Greatest Real Estate Deal Analysis Spreadsheet™. With each improvement, he sought feedback from many of the 1,400+ member Northern Colorado Real Estate Investor Group.

Now you can download and use it for yourself — completely free using the download button above!

How to Use The Spreadsheet

Lowball Offers

The World's Greatest Real Estate Deal Analysis Spreadsheet™ allows you to easily see how your cash-on-cash return on investment is impacted when you need to make an offer above asking price or if you’re fortunate enough to be able to negotiate a below-asking-price “lowball offer”.

Purchase Price With Rent Sensitivity Table for Cash-on-Cash ROI
Purchase Price With Rent Sensitivity Table for Cash-on-Cash ROI from The Spreadsheet.

The table above shows you what happens to cash-on-cash return on investment for every 1% increase or decrease in purchase price from list price, as well as for each $50 variation in rent above and below your default rent estimate in your analysis.

For a detailed discussed on “lowball offers,” you may want to read The Ultimate Guide to Low Ball Offers for Real Estate Investors.

Real Estate Bookkeeping Spreadsheet

The spreadsheet on this page is obviously for deal analysis, but we also offer a real estate bookkeeping spreadsheet you can use to keep track of all your rentals, including their income, expenses, and accounts. This bookkeeping spreadsheet includes super easy tools for inputting information to your taxes at year-end or for emailing to your accountant, bookkeeper, CPA, or other tax preparer.

Visit our real estate bookkeeping page to download this spreadsheet and read our tips how to get your real estate books organized and under control.

Learn More About Real Estate Bookkeeping

Need Deal Analysis Help?

We have over 14 hours of some of the best real estate deal analysis training available anywhere, taught by two experienced real estate investors: me and Brian.

Explore Our Deal Analysis Classes

You can also contact me in the comments with questions on how to best use The World’s Greatest Real Estate Deal Analysis Spreadsheet™!

The Real Estate Financial Planner™
More Powerful Than A Deal Analysis Spreadsheet

If you want to go beyond simple deal analysis and analyze your entire portfolio and investment strategy, including real estate as well as stocks, bonds, and other investments, then there is no option more powerful than the Real Estate Financial Planner™ software.

Create a “Forever Free” Account

Get INSTANT Access to this AND...
100+ Additional Real Estate Investor Class Recordings, Downloads and More...
...and all for the cost of a couple burritos.

A veritable Treasure Chest of goodies primarily for Buy-And-Hold Real Estate Investors, Nomads™ and House Hackers.

You get 1 full-year of access to:

  • Over 100 premium real estate investing classes
    • Over 200 hours of video training
  • Downloads:
    • The World's Greatest Real Estate Deal Analysis Spreadsheet™
    • How to Improve Cash Flow on Rentals Checklist
    • Rental Property Bookkeeping and Accounting Spreadsheet
    • Qualified Business Income Deduction with Rental Property Log
    • Interest Rate Buy-Down Spreadsheet
    • Off Market Deal Business Marketing Tracking Spreadsheet
    • 240-page book with detailed analysis of 10 different investing plans
  • 20 "secret" bonus classes - another 40+ hours of video training... and some of my best work
Get more info or... Get Instant Access Now - Just $27

Here's a list of the classes included:

  1. 10 House Hacking Tips and Tricks for Real Estate Investors
  2. 10 Things I Wish I Knew Before Starting to Invest in Real Estate
  3. 10 Tips to Get Offers Accepted in Hot Markets
  4. 8 Money Saving, Risk Reducing Real Estate Investor Insurance Tips
  5. 9 Nastiest Nomad™ Mistakes
  6. Advanced Lease-Option Deal Analysis
  7. Advanced Real-Time Deal Analysis with Brian's New, Improved Spreadsheet
  8. An Alternative to Cash Flow - Saving Money With Rental Properties
  9. Analyzing Deals 101: an Intro to Cash on Cash Return on Investment
  10. Analyzing Deals 102 - Fix and Flips
  11. Analyzing Deals 201 - Selling with Lease-Option
  12. Analyzing Deals 303 - Subject-To and Lease-Options
  13. Analyzing Multi-Family Properties
  14. Analyzing Single Family Homes, Condos, Townhomes and Multi-Family
  15. Arguably the Best Class of the Year - Part 1
  16. Arguably the Best Class of the Year - Part 2
  17. Arguably the Best Class of the Year - Part 3
  18. Arguably the Best Class of the Year - Part 4
  19. Arguably the Best Class of the Year - Part 5
  20. Ask Me Almost Anything
  21. Asset Allocation Secrets of Real Estate Investors
  22. Better Credit for Better Deals: Improving Your Credit Score
  23. Beyond Cash Flow - The Return on Investment Quadrant™
  24. Bookkeeping and Accounting for Real Estate Investors
  25. Buying Down Interest Rates
  26. Buying New Houses as Investments and Nomads™
  27. Buying Properties on Lease-Option, Lease-Purchase or Subject To
  28. Cap Ex – The Silent Killer
  29. Cash Flow Power Meter™
  30. Cash Flow Versus Appreciation
  31. Catch Up Nomad™
  32. Closing Real Estate Deals
  33. College Nomad™ Overview
  34. Comparable Sales 101
  35. Contract to Buy and Sell Real Estate in Detail
  36. Contract to Close
  37. Converting Your Owner-Occupant Property To A Rental
  38. Creative Financing 101
  39. Crushing Your Real Estate Goals Using EV
  40. Deal Alchemy™
  41. Deal Analysis 301 Multi-Family
  42. Deal Analysis Post-Coronavirus
  43. Establishing Your Buying Criteria Workshop
  44. Evaluating Mortgages and Comparing Lenders
  45. Everything You Learned About Deal Analysis is Wrong - ROIQ+R™
  46. Financial Mindset and Overcoming Fear
  47. Finding Amazing Real Estate Investor Deals
  48. Fix and Flip Case Studies
  49. Fixer Upper Nomad™ Overview
  50. Go to College or Skip It to Invest in Real Estate
  51. Grit and Persistence - Brian's Story
  52. Hard and Private Money 101
  53. House Hacking versus Nomad™
  54. How to Analyze Deals with Brian's Spreadsheet
  55. How to Be the Ideal Client That Realtors Call First with the Best Deals
  56. How To Do A Deal Using Self-Directed 401Ks and Self-Directed IRAs
  57. How to Get Down Payment
  58. How to Get Your Next Deal Done After Coronavirus
  59. How to Go Broke Using the BRRRR Strategy
  60. How to Improve Cash Flow Workshop
  61. How to Nomad™ without Moving into Properties
  62. How to Select a Real Estate Agent
  63. Improving Cash Flow by Buying Down Interest Rates
  64. Insider Secrets of Experienced Home Inspector for Investors
  65. Interest Rate Buy Down Spreadsheet
  66. Interest Rate Scenarios for Nomads™
  67. Is Nomad™ Dead?!
  68. Just One More Rental Property - Part 1
  69. Legacy Nomad™ Overview
  70. Line of Credit Magic
  71. Little Down Nomad™ Overview
  72. Live Deal Analysis
  73. Looking at Profitable Investment Properties Tips and Tricks
  74. Low and Nothing Down Strategies That Work In Today's Market
  75. Low-ball Offer Case Studies
  76. Making Strong Offers That Get Accepted
  77. Negotiating Win-Win Inspections for Maximum Benefit
  78. Nomad™ - Ask Me Almost Anything
  79. Nomad™ 101
  80. Nomad™ 101 FAQs
  81. Nomad™ by Proxy
  82. One Crazy Night - Brian Solves All Your Real Estate Problems
  83. Owner Financing
  84. Paying Off Debt Optimization for Real Estate Investors
  85. Presenting a Deal to Potential Partners
  86. Presenting A Wholesale Deal To Investors
  87. Pros and Cons of Every Real Estate Investing Strategy Compared
  88. Real Estate Appraisals for Real Estate Investors
  89. Real Estate Investor Buying Process Overview
  90. Real Estate Investor Financing After Coronavirus
  91. Real Estate Investor Horror Stories
  92. Real Estate Investor Loan Comparison Deep Dive
  93. Reducing Risk While Nomading™
  94. Rental Property Tax Deductions
  95. Return on Investment and Return on Equity
  96. Rules of Thumb and the Sacred Numerology of Real Estate Investing
  97. Seller’s Property Disclosure Case Studies
  98. Should I Sell My Rental? ROTNEQ+R™
  99. Should I Wait for a Real Estate Dip to Invest in Real Estate?
  100. Side Hustles: Earn Down Payments Faster - The Amazon Class
  101. Strategies to Get the Lowest Monthly Payment When Buying
  102. Stress Testing Your Real Estate Investing Portfolio - Part I
  103. Structuring Partnerships - Part 1 of 2
  104. Structuring Partnerships - Part 2 of 2
  105. The Case AGAINST Investing in Real Estate
  106. The Two Best Investing Strategies For Our Market Right Now
  107. The Ultimate Guide to Earnest Money
  108. The Ultimate Guide to Market Corrections
  109. The Ultimate Guide to Private Mortgage Insurance
  110. The Ultimate Guide to Rent Comps
  111. The Ultimate Guide to Should I Pay Off My Mortgage
  112. The Ultimate Guide to the BRRRR Strategy
  113. The Ultimate Guide to VA Loans
  114. The World's Best Real Estate Investing Goal Setting Class
  115. Unleashing the Secret Power of Debt-To-Income for Real Estate Investors
  116. Using Poker to Make Real Estate Decisions
  117. Wait! Before You Make That Offer...
  118. Warning - The Dangers and Risks of Real Estate Investing
  119. What Happens If Values and Rents Don't Always Go Up As A Nomad™
  120. World's Greatest Deal Analysis Spreadsheet Unleashed
30 Day Money Back GuaranteeAnd, it is all covered by an unconditional 30-day money back guarantee... try it for 30 days and if you don't agree these are some of the best real estate investing training classes and tools you've ever seen, at any price... simply request a full, no-questions-asked refund.
Get more info or... Get Instant Access Now - Just $27

4 thoughts on “Real Estate Deal Analysis Spreadsheet”

  1. Hey James, we’re both ostensibly pretty transactional people but you’ve got so many moving parts going in so many directions, I can’t keep up.
    I’d love to just buy some of your expertise if we could figure out how.
    First off, I’m not your targeted demographic. I’m not an RE investor, but an overly analytical home buyer (Nomad?) buying my own (non-conventional) residence — using investor methods.
    I have a bunch of spreadsheets — but would love to have yours if I can edit it — especially the macros — for my residential purposes.
    Would also love to buy downloadable files or documents on “creative deals” owner carry, wraps, subject to, etc. that I can share with a researcher.

    • Thanks for the comment Dru. Sorry you’re not able to keep up.

      Yes, we definitely focus on providing resources for buy-and-hold real estate investors, Nomads™ and house hackers. That is our target audience.

      You’re welcome to download Brian’s spreadsheet (aka The World’s Greatest Real Estate Deal Analysis Spreadsheet). He has it locked down so that anyone who is not an Excel expert can’t mess up the formulas and macros. If you’re an Excel expert you, of course, know how to unlock it so it is fully editable. If you need to ask Brian how to unlock it, you probably shouldn’t be messing with the formulas.

      I don’t think I offer downloadable files or documents for “creative deals” like owner carry, wraps, subject to for you to share with your researcher that I can think of except maybe the spreadsheet I created for modeling buying creative properties using marketing (linked below).

  2. Hello,

    Really great resources and lessons. Even though I am from Europe and focus on flats (its europe …), most of the things are applicable.

    Though I really had to dig and change the excel as Depreciation does not exist in Europe. We have here buildings old few centuries and people are still living in them. Also tax on RE is like nonexistent here 🙂

    If you have more ppl watching from EU, maybe add a feature to disable the depreciation part of the excel.

    Kind Regards,


Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.