Many investors glance at gross rents and a back‑of‑the‑napkin number and call it a day.

A clear picture of cap rate, cashflow, and cash‑on‑cash makes it easier to compare properties, evaluate offers, and decide whether a deal belongs in your portfolio.

The Cap Rate & Cashflow Worksheet gives you a simple structure to plug in income, expenses, and debt so you can see how a property is really performing—or how a potential deal might pencil—before you commit.

What the worksheet helps you calculate:
– Effective gross income after vacancy and credit loss
– Operating expenses and net operating income (NOI)
– Cap rate based on current or projected price
– Annual and monthly cashflow after financing
– Basic cash‑on‑cash return based on your invested capital

Use it for quick underwriting on new deals, or as a yearly check‑in on properties you already own. It’s deliberately straightforward, so you spend more time deciding and less time wrestling spreadsheets.