Landlord NumbersHome › Rental Deal Analyzer
Rental Deal Analyzer
Know whether a rental works before you make an offer, and how fragile the numbers are. Analyze up to three deals and compare them side by side.
Get the analyzer – $19 Instant download · Excel + Google Sheets · Blank + sample file
What's inside
- Buy & hold or BRRRR
Pick a strategy for each deal. BRRRR models the refinance at ARV × LTV, net proceeds, cash left in and cash pulled out. - Every year-1 metric
NOI, monthly cash flow, cap rate (on price and on all-in cost), cash-on-cash, DSCR, 1% rule, GRM, expense ratio, break-even occupancy. - 10-year projection
Rent and expense growth, debt service, loan balance, value, equity and net sale proceeds, year by year. - 5- and 10-year IRR
Plus equity multiple and total profit, using the projection's cash flows and sale proceeds. - Sensitivity tables
Cash flow at rent ±10% × rate ±1 point, and cash-on-cash at price × rent. Losses turn red. - Compare 3 deals
18 metrics side by side. The best value in each row is highlighted, with a cash-flow chart.
Who it's for
Investors and landlords sizing up a single-family or small multifamily purchase who want a spreadsheet they own: no subscription, no account and no macros, with every formula visible. For quick one-off checks, the free cash flow, DSCR and BRRRR calculators on this site may be all you need.
Refunds: 14-day refund, no questions asked: email wbishop12@gmail.com within 14 days of purchase.
The analyzer is an analysis tool, not financial, investment, lending or tax advice. Results are pre-tax estimates based on your inputs. BRRRR refinance timing, seasoning and appraisal risk are simplified. Verify figures and get professional advice before buying property.
FAQ
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. Every formula uses functions Google Sheets supports, including PMT and IRR. The chart may be restyled by Google.
Can it handle a duplex or small multifamily?
Yes. Enter the total rent for all units and the combined expenses.
How is BRRRR modeled?
The refinance happens at year 0: loan = ARV × LTV, less refinance closing costs and payoff of the purchase loan. Cash left in = your cash in − net refinance proceeds.
Why can a BRRRR show a very high IRR with negative cash flow?
When very little cash is left in the deal, IRR can look huge even if the property loses money each month. Always check cash flow, DSCR and break-even occupancy too.
What is the refund policy?
14-day refund, no questions asked: email wbishop12@gmail.com within 14 days of purchase.
Is this financial advice?
No. It's a calculator in spreadsheet form. Results are estimates based on your inputs.