Free Rental Property Analysis Spreadsheet
Keystead Lite is a free rental property analysis spreadsheet for new investors. Enter the price, rent, expenses and loan terms for up to three properties and it calculates cash flow, cash flow per door, NOI, cap rate, cash-on-cash return, DSCR and the 1% rule. Every result is checked against targets you set, with PASS, CLOSE or FAIL and a 0-100 deal score.
Who it is for
Keystead Lite is made for first-time buyers, house hackers and part-time investors who want to screen a listing in a few minutes. Set your own minimum cash flow per door, cash-on-cash return, cap rate and DSCR once, then every deal you enter is judged the same way. Leave any percentage blank and your default from Settings is used, so a first analysis needs only the price, rent, taxes and insurance.
What’s included
- Start Here tab with instructions and tab buttons
- Dashboard with KPI tiles and four charts
- Deal Inputs for 3 properties
- Rental Analyzer with income statement and five deal checks
- Settings for your currency, targets and default assumptions
- Engine tab with every formula open to audit
Excel-format .xlsx for Microsoft Excel; tested in LibreOffice Calc; built with standard functions that also work when you open it in Google Sheets.
What the full version adds
The full Keystead Real Estate Deal Analyzer analyzes 10 deals and adds:
- BRRRR analyzer with cash back at refinance and cash left in the deal
- Fix and flip analyzer with the 70% rule, maximum allowable offer, profit and ROI
- Max-offer calculator and a rent and interest-rate stress test
- 30-year projection with appreciation, loan paydown and equity
- Side-by-side comparison of 10 deals, a rehab budget, a 24-step checklist, a glossary and an illustrated user guide
How to download
Downloading needs a free Taskdale account, and free downloads are limited to 3 per day.
Personal use only. Not financial advice: results are estimates based on the numbers you enter.
Reviews
There are no reviews yet.