Skip to content
Stay N Host Help

Model an investor pool

Screen /investor-model · Roles: Admin (writes) · Account Manager, External Accountant (read)

The Investor model answers “what would a pool of apartments return, and what is one investor’s share of it worth?” Unlike the throwaway forecast calculator, a model here is saved - it’s the assumption set your proposals cite, so the numbers you show a prospect stay reproducible.

  1. Click “New model” and state one apartment’s economics, repeated across the pool: a name, the property (or leave it empty for a portfolio-wide pool - the shape most deals take), apartments in the pool, sellable nights / month, ADR, lease per apartment per month, opex (as a percentage of revenue), and the management share - your slice before the pool is divided. Occupancy is not set here; it belongs to the scenarios.

  2. Set each scenario’s occupancy. Three columns - Conservative, Expected, Optimistic - sit side by side, each computing per-apartment gross, opex, lease, net, pool net, the investor share per month and year, yield on capital, and capital payback. Each column also states its margin of safety: how far the modelled occupancy sits above the break-even occupancy.

  3. Or seed Expected from your books. Prefill from actuals fills the Expected column from the trailing ledger - real occupancy, real ADR, real costs. It touches only Expected: Conservative and Optimistic stay your judgment. (Prefill reads the P&L, so it needs the Finance suite; hand-built models don’t.)

  4. Size the deal. In Deal sizing, enter the investor’s capital and the price of one apartment. Out come: units held, their share of the pool (after your management share), unallocated capital, and - because this models the pooled-equity agreement - what a loss month costs them, since losses are shared. Capital recovery charts their cumulative cash flow over 24 months, starting at minus the capital.

What’s next

Section titled “What’s next”