Rental Property Investment Tracker — Cash Flow, Cap Rate, Cash-on-Cash + Deal Analyzer (Excel + Google Sheets)

Stop guessing whether a rental is a good deal. This tracker runs the numbers real estate investors actually use — automatically — so you can buy with confidence and watch your portfolio grow.

6 easy tabs in one file:

⭐ Start Here — a simple guide + colour legend so you know exactly where to type.

📊 Dashboard — your whole portfolio at a glance: total value, rent, monthly & annual cash flow, equity, cap rate and cash-on-cash — all auto-calculated.

🏠 Rental Properties — one row per property. Type the purchase price, rent and costs; cash flow, cap rate and ROI calculate instantly.

🧮 Deal Analyzer — test a property BEFORE you buy. Enter the numbers and get an instant STRONG / OK / CAUTION verdict.

🧾 Income & Expense Log — track real rent received and expenses each month; net cash flow rolls up automatically.

📘 Guide & Tips — the 4 numbers that matter (cash flow, cap rate, cash-on-cash, 1% rule) explained in plain English.

Why you'll love it:

✔ Works in Google Sheets (free) AND Microsoft Excel

✔ All the investor math is built in — mortgage payment, cash flow, cap rate, cash-on-cash, 1% rule

✔ Analyze a deal in under 2 minutes — no finance background needed

✔ Track one property or a whole portfolio

✔ Instant digital download — start today

What you get (instant download):

• 1 Excel file (.xlsx) with all 6 tabs, pre-filled with example numbers

• A PDF version too, so you can print or preview it

• Works in Google Sheets — just upload to Google Drive and open

How to use in Google Sheets: Download the file, go to Google Drive, click New, File Upload, then right-click, Open with, Google Sheets.

⚠️ Educational planning & tracking tool only — not financial, tax, or investment advice. Digital download; nothing is shipped.

Made with care by Kit & Quill.