What you get
A single Excel workbook that runs full underwriting on any single-family or small multi-family rental. Enter your deal numbers once and the workbook returns every metric that determines whether a property is worth buying, from day-one cash flow through a 30-year compounding projection.
Who it's for
Buy-and-hold investors who are under contract or actively making offers on rental properties and need a rigorous, repeatable way to stress-test a deal before closing. It also works for investors already holding a portfolio who want one place to track performance across all properties.
What's inside
- Prop Inputs sheet — single data-entry area for purchase price, down payment, loan terms, rehab budget, monthly rent, vacancy rate, property management rate, taxes, insurance, repairs, CapEx reserve, HOA, and utilities
- Dashboard — instant readout of monthly cash flow, cash-on-cash return, cap rate, gross rent multiplier, and a 1% rule pass/fail check, all recalculating the moment any input changes
- 30-Year Projection — annual model showing how rent growth and property appreciation compound net operating income, equity, and total return from year 1 through year 30
- Rent vs. Buy sheet — side-by-side net-cost comparison that quantifies the true financial advantage of owning versus renting an equivalent property in the same market
- Portfolio Rollup — multi-property tracker with automatic totals for combined monthly cash flow, total equity, and blended cash-on-cash and cap rate across every property you own
- Return summary — year-1 through year-30 total ROI table showing cumulative cash flow, appreciation, and equity build in one readable output
How to use it
Open the file in Microsoft Excel or upload it to Google Sheets. Start on the Prop Inputs sheet, fill in your deal assumptions, and review the Dashboard immediately — no formulas to write and no setup required. When you add more properties, paste each set of inputs into the Portfolio Rollup sheet to build a running picture of your full portfolio.