Stop guessing whether a Brooklyn rental pencils out

Every listing looks like a good deal until you actually run the numbers. A property that rents for a strong monthly figure can still lose money once you factor in NYC property taxes, water and sewer, insurance, vacancy, and repairs — and a building full of rent-stabilized units may never grow the way a spreadsheet-free investor assumes.

Our free rental property analysis template does that math for you. Enter a few inputs and it instantly returns the metrics lenders and seasoned investors actually use, so you can compare deals side by side and walk into a purchase (or a refinance) with clear eyes.

What's inside the spreadsheet

The template is pre-built with formulas — you only fill in the white input cells. It calculates:

  • Monthly and annual cash flow — what actually lands in your pocket after every expense and debt payment.
  • Net operating income (NOI) — income minus operating expenses, the foundation of every valuation. See our NOI definition.
  • Capitalization rate (cap rate) — your unleveraged return, so you can compare a Bed-Stuy brownstone to a Crown Heights walk-up. Learn how cap rate works.
  • Cash-on-cash return — the return on the actual cash you put in.
  • Gross rent multiplier (GRM) — a fast first-glance screen. What is GRM?
  • A full NYC expense checklist — taxes, insurance, water/sewer, HPD registration, management, maintenance reserves, and vacancy — so nothing important gets left off.
  • A rent-stabilization notes field — flag regulated units early, because they change your long-term numbers.

Who this is for

This tool is built for people making real decisions about NYC rental property:

  • First-time investors sizing up their first two-to-four-unit building.
  • Current owners deciding whether to hold, refinance, or sell.
  • Buyers working with a broker who want to independently sanity-check a deal — including clients coming through our sister brokerage, Pear NYC.

If you're weighing a purchase, pair the spreadsheet with our guide to investing in Brooklyn rental property and our breakdown of how to price a Brooklyn rental.

Want us to run the numbers for you?

A spreadsheet is only as good as the assumptions you feed it — and getting NYC rents, expenses, and stabilization status right is exactly what we do every day. Yak Management is a boutique, principal-led firm managing nearly 400 units across Brooklyn and greater NYC, with deep expertise in rent-stabilized and subsidized housing.

Skip the guesswork and let our team pull real market comps and realistic expenses for your specific building. Get a free, no-obligation rental analysis — we'll show you what your property should earn and where you're leaving money on the table.

Curious how ownership works with us day to day? Explore our financial reporting and full-service property management, or just reach out — we're happy to talk through a deal before you sign anything.

This template and page are educational tools, not investment, tax, or legal advice. Confirm rent-stabilization status, property taxes, and financing terms with the appropriate professionals before purchasing.