Rental Property Cash Flow Analyzer | Deal, BRRRR and P&L Spreadsheet

Seller's description

Rental Property Cash Flow Analyzer — a rental-property deal, BRRRR, and multi-property P&L spreadsheet for landlords and small real-estate investors. Instant digital download: an Excel workbook that also opens in free Google Sheets. Screen a purchase, model a BRRRR illustration, and record income and expenses across up to 15 properties. This is not tax advice, not investment advice, not a Schedule E, and not a tax return.

DISCLAIMER — PLEASE READ
The seller is not a law firm, is not a CPA or tax preparer, and is not a registered investment adviser. These materials were not prepared by attorneys or tax professionals. This product is a set of blank spreadsheet templates and calculators for organizational use only. It is not legal advice, not tax advice, not investment advice, and not a substitute for advice from a licensed attorney, a CPA, or a qualified tax professional. It does not create an attorney-client or adviser-client relationship. It is not a tax form, not a Schedule E, and not a tax return. It does not predict returns, appraise property, or recommend that you buy, sell, refinance, or hold any property. Laws, tax rules, and local practice vary by jurisdiction and can change. You are responsible for confirming that your records and any decisions you make comply with current federal, state, and local law and with your own facts. No outcome is guaranteed. Using an expense category does not mean an amount is deductible. Official IRS sources: https://www.irs.gov/publications/p527 and https://www.irs.gov/instructions/i1040se

WHAT YOU GET (instant digital download)
• Rental_Property_Cash_Flow_Analyzer.xlsx — eleven working sheets: START HERE, Settings, Properties (up to 15), Dashboard, Deal Analyzer (up to 5 deals), BRRRR (up to 3 illustrations), Income Log, Expense Log, Schedule E Summary, Cash Flow, and CapEx Planner. Yellow cells are inputs. Green cells are formulas. Metrics include NOI, cap rate, cash-on-cash, DSCR, GRM, a 1% rule-of-thumb flag, and an illustrative stress test (rent −10%, vacancy +5 points, rate +2 points).
• Rental_Property_Cash_Flow_Analyzer_SAMPLE.xlsx — the same workbook filled with clearly fake sample data (123 Sample Street and other demonstration addresses) and a maroon SAMPLE LAYOUT ONLY banner. Use it to see how the file looks. Do not use it for your records.
• How_To_Rental_Property_Cash_Flow_Analyzer.pdf
• START_HERE.txt
• How_To_Open_In_Google.pdf — a one-page card for free Google Sheets
• Instant digital download. Nothing ships. Edit in Excel, LibreOffice, or free Google Sheets. No Canva Pro required. No macros.

WHO IT IS FOR
Landlords and small real-estate investors in any U.S. state who want a ready workbook to screen a deal or keep rental records. It is not written for a particular state. This is a calculator and recordkeeping tool, not a letter or a legal form. (This shop also has a simpler $11.99 rent ledger for day-to-day rent and expense logging. This listing is the deeper investment-and-P&L toolkit.)

HOW IT WORKS
1. Read START HERE inside the workbook and the how-to PDF.
2. On Settings, type the reporting year.
3. On Properties, enter a short Property ID you will reuse on the logs.
4. To screen a purchase, fill one column on Deal Analyzer or BRRRR. Green cells calculate automatically.
5. To track properties you operate, log amounts on the Income Log and Expense Log. The Dashboard, Schedule E Summary, and Cash Flow sheets update from those logs.
6. Use the blank workbook, not the SAMPLE file, for your own records. Do not store Social Security or bank-account numbers in the file.

WHAT THIS IS NOT
It is not a Schedule E, not a Form 1040, and not a depreciation schedule. It does not split mortgage principal from interest unless you enter interest yourself. The 1% rule and the stress test are illustrative rules of thumb, not standards and not predictions. Cap rate, cash-on-cash, and DSCR are arithmetic on the numbers you type; they are not a valuation and not a recommendation. After-repair value on the BRRRR sheet is your estimate, not an appraisal. This product does not advise you to refinance. Expense category names follow the groups printed on IRS Schedule E (Form 1040) for recordkeeping only; using a category does not make an amount deductible.

Support covers file access only, such as a file that will not open. Questions about a legal, tax, or investment situation should go to a licensed attorney or a tax professional.
Personal use for properties you own or manage. Do not resell, share, or republish these files. Do not put Social Security numbers, full bank-account numbers, or government-ID numbers in these files.
Instant digital download — nothing ships. Refunds if a file will not open; other refunds follow Etsy's digital-item policy. Content reviewed November 12, 2026.
These templates were prepared with the help of software tools. They were reviewed before listing. They are still blank templates only, not legal, tax, or investment advice.