Screen US single-family rentals and multi-family acquisitions without monthly software subscriptions. Pre-built with automated formulas for Net Operating Income (NOI), Cap Rates, Cash-on-Cash returns, and DSCR.
Automates purchase capitalization, Fannie Mae LTV constraints, and conventional 30-year amortization schedules.
Stress-tests US county property tax reassessments, hazard insurance premiums, and localized CapEx reserves.
Instantly reports unleveraged Cap Rate, Year 1 Cash-on-Cash yield, and commercial DSCR metrics.
The foundation of any real estate cash flow spreadsheet is an accurate Net Operating Income (NOI) projection. While amateur investors often only subtract the mortgage from the rent, our free template models true institutional metrics. It automatically deducts structural operating expenses—including property management fees, localized US county property taxes, landlord hazard insurance, and maintenance—from your Effective Gross Income (EGI). We also include a hard-coded 5% vacancy rate buffer to ensure your underwriting remains conservative against market fluctuations.
Effective financial modeling separates your asset's fundamental yield from your leveraged equity yield. The Unleveraged Cap Rate formula (NOI / Purchase Price) allows you to compare the raw earning power of a rental property directly against treasury bonds or index funds. Conversely, the Cash-on-Cash return isolates your capital efficiency, telling you exactly what percentage yield your 20% or 25% down payment is generating in Year 1.
If you plan to scale your US real estate portfolio outside of conventional Fannie Mae or Freddie Mac loans, commercial lenders will heavily scrutinize your DSCR. The attached Excel template automatically calculates this by dividing your NOI by your Annual Debt Service (Principal and Interest). If the cell outputs a metric below 1.25x, the property does not generate enough surplus cash flow to satisfy standard commercial lending requirements, serving as an immediate red flag for the deal.
Yes. The download is provided as a universal `.csv` (Comma Separated Values) file. You can drag and drop it directly into Google Sheets, Apple Numbers, or Microsoft Excel without losing the core data structure or formulas.
Most real estate software companies use gated spreadsheets as lead magnets to spam your inbox. We believe institutional underwriting tools should be open and accessible. You can download the file anonymously, instantly.
In your spreadsheet, establish a cell for Net Operating Income (e.g., C20) and a cell for Purchase Price (e.g., C2). The formula is simply =C20/C2. Format the resulting cell as a percentage to view your Cap Rate.