Store / Rental Property & BRRRR Analyzer
Rental Property & BRRRR Analyzer
Will this rental cash-flow, and how much of your cash stays in it?
A rental property spreadsheet for buy-and-hold and BRRRR investors: cash flow, cash-on-cash, DSCR and cap rate, the refinance math, a 10-year projection with IRR, and the highest price that still meets your targets. For Excel and Google Sheets.
Excel + Google Sheets · No macros · .xlsx download
$19 one payment · no subscription
Five reasons to use it
- A verdict against your own rules Set the cash flow per unit, cash-on-cash return and DSCR you need. The sheet says which targets the deal meets and which it misses.
- The BRRRR math, done for you Enter the purchase loan, rehab and holding costs, then a refinance at a % of the after-repair value. It shows the cash back at the refinance and the cash left in the deal, and the highest price that leaves no more than the cash you're willing to leave in.
- Two max offers One for your cash-flow target if you keep the purchase loan. One for your cash-left target if you refinance.
- See what moves the deal A grid of cash flow as rent moves ±10% and the rate moves ±1 point, and the cash left in the deal if the appraisal comes in 10% low or high.
- The long run Ten years of rent, NOI, loan payments, cash flow, loan balance, value and equity, then the profit and yearly return (IRR) if you sell.
What you get
- One .xlsx workbook with three tabs:
- How to use: one page.
- Inputs: the purchase and a 6-line rehab budget with contingency; the purchase loan (interest-only or amortizing); rent for up to 4 units, vacancy and 9 expense lines; the refinance, growth rates and your targets.
- Results: the verdict and key ratios, and both max offers; cash in and the refinance; a year-1 operating statement (at purchase and long-term); the 10-year projection and the sale; two what-if tables.
- No macros. The formulas are locked, and the file uses only functions that Google Sheets supports.
- A filled-in sample duplex, with invented numbers, so you can see it work before you type in yours.
Honest limits
- It gives estimates, not financial advice. It can't see the property, the local market or your lender's terms. A result is only as good as the numbers you type in.
- The refinance is simplified. It's treated as done before year 1 starts, and holding costs before the property is rented are one total you enter.
- No taxes. Income taxes, depreciation and tax on the sale aren't included.
- Limited scope: one property per file, up to 4 units; no short-term rental mode; no partner splits.
- The ARV is your number. The sheet doesn't estimate it from comps.
Questions
- Does it work in Google Sheets?
- Yes. We opened it in Google Sheets, and every formula gave the same result as our own checks. Upload the .xlsx to Google Drive and open it. Google Sheets doesn't keep the cell locks, so avoid typing over grey cells.
- What is BRRRR?
- Buy, rehab, rent, refinance, repeat. You buy and fix a property, rent it out, then refinance at the higher value to get some or all of your cash back.
- Can I use it without a refinance?
- Yes. Choose No under Refinance, and the sheet keeps the purchase loan for the long run.
- Can I analyze an all-cash purchase?
- Yes. Type 100% as the down payment.
- What if my lender's loan is interest-only?
- Choose Yes under Interest-only. This is common for hard-money loans.
- Can I unlock the formulas?
- Yes. In Excel, go to Review > Unprotect sheet. There's no password.
More from the store
Spreadsheets for estimating, not advice. The sample data is invented.