Skip to content
Log in

Rental Cashflow Worksheet

Works out what a rental actually returns after the costs people leave out — voids, management, maintenance and the ones that only appear in year three.

0

Share this prompt

Free — no card needed

Create a free account

to open Rental Cashflow Worksheet — and the other 364 prompts across 21 categories.

We store your email address to send these. We never sell it or pass it to advertisers. Withdraw at any time. Privacy Policy.

Already have an account?

CategoryReal EstateForAnalysts, Solopreneurs, ConsultantsTested onClaudeChatGPT

Running it, start to finish

  1. Enter the property, the evidenced rent, and every cost you already know.
  2. Add the omitted costs the worksheet names before drawing any conclusion.
  3. Take the finished worksheet to a qualified accountant before committing to a purchase.

What you get back

The output this produces, every time.

  • Applies a void allowance and the costs headline yields leave out, including your own time.
  • Amortises the lumpy costs that only appear in year three, which is where projections usually break.
  • Shows gross and net side by side, and explains the gap line by line.

Getting better results

Where this usually goes wrong, and how to avoid it.

  • Use achieved rents, not advertised ones. The gap between the two widens in a slow market, and it is where optimistic worksheets start.
  • Cost your own management. Self-management is not free. Pricing it at zero makes the comparison with a managed property meaningless.
  • Read the sensitivity table first. The base case is the least informative column. What matters is what two months of voids does to it.

More Real Estate prompts

All Real Estate

Written for The AI University. Every prompt in this library is original work — authored, tested and revised here, not collected from elsewhere. 365 of them, free with an account.